• Title/Summary/Keyword: Excel environment

Search Result 106, Processing Time 0.03 seconds

Integrated Water Distribution Network System using the Mathematical Analysis Model and GIS (수리해석 모형과 GIS를 이용한 통합 용수배분 시스템)

  • Kwon, Jae-Seop;Jo, Myung-Hee
    • Journal of the Korean Association of Geographic Information Studies
    • /
    • v.4 no.4
    • /
    • pp.21-28
    • /
    • 2001
  • In this study, GNLP(GIS linked non-linear network analysis program) for pipeline system analysis has been developed. This GNLP gets the input data for pipeline analysis from existing GIS(geographic information system) data automatically, and has GUI(graphic user interface) for user. Non-Linear Method was used for hydraulic analysis of pipe network based on Hazen-Williams equation, and Microsoft Access of relational database management system(RDBMS) was used for the framework of database applied program. GNLP system environment program was improved so that a pipe network designer can input information data for hydraulic analysis of pipeline system more easily than that of existing models. Furthermore this model generate output such as pressure and water quantities in the form of a table and a chart, and also produces output data in Excel file. This model is also able to display data effectively for analysed data confirmation and query function which is the core of GIS program.

  • PDF

Improving the Reliability of the National Database for Chemical Hazard Information (국가 화학물질 유해성정보 데이터베이스 구축 과정의 신뢰도 제고 방안에 관한 연구)

  • Lee, Somin;Lee, Minhyeok;Kang, Mijin;Kwon, Soon-Kwang;Ra, Jin-Sung;Park, Beaksoo
    • Journal of Environmental Health Sciences
    • /
    • v.46 no.4
    • /
    • pp.410-422
    • /
    • 2020
  • Objectives: According to the Act on Registration, Evaluation, Etc. of Chemicals, new and existing chemicals must be registered by 2030. In addition, industries need to submit hazard data as an attachment during the registration process. Therefore, we constructed a nationwide chemical database to support small industry by providing hazard data and original sources. During the process, we developed a new standard procedure for minimizing errors and increasing reliability. Methods: We analyzed the categories of errors and the cause of the errors through the verification results of the 2019 project. We present an improved database construction methodology and system. Results: Errors are categorized according to their causative factors into simple, technical, and structural type errors. Simple errors arise simply because of decreased concentration or negligence in following the instructions. Technical errors are caused by a discrepancy between the professional field and the type of data. Structural errors indicate systemic errors such as incomplete forms on the excel database or ambiguity in the guidelines. Lessons from the errors collected in the 2019 project are used to update the procedures for database authorization and technical guidelines. The main update points are as follows; 'supplementation of review process', 'giving regular training to external reviewers', 'giving additional information to authors, like physico-chemical properties of substances, degradability, etc.', 'amendment of excel form', and 'guideline upgrades'. Conclusions: We conducted this study with the aim of improving the accuracy and reliability of the database of hazard information for chemical substances. The new procedures and guidelines are now being used in the 2020 project for construction of a hazard information database for Korea.

Human Environment for being a Great doctor - from case to construction - (훌륭한 의사를 기르는 인적환경 - 사례에서 구조까지 -)

  • Ryue, Soo-hee
    • Korean Medical Education Review
    • /
    • v.9 no.2
    • /
    • pp.57-66
    • /
    • 2007
  • Purpose How can be a great doctor with excellence and ethics? In this study, I wanted to find out the characteristics of human environment to make a great doctor. Methods: First, I researched factors and construct of the human environment. So I conceived a model for analyzing human environment with two construction model : Howard Gardner's System Model and Bron-fenbrenner's ecological systems model. Second, I analyzed the life of the Oliver R. Evison M.D. and Ki Ryu Jang M.D. Oliver R. Evison was the pioneer of medicine of Korea and establisher of the Severance Hospital and medical college. Dr KiRyu Jang, who was called 'Schweitzer of Korea', was a good doctor of the poor and weak patients in Korea. Third, I tried to find out a new human environment model to make a great doctor. Results One model for analyzing human environment was made of relationship based on emotion. relationship teaching knowledge and skill, and relationship communicating on value. In the light of analyzing of two great doctors. Oliver R. Evison M.D. and KiRyu Jang M.D, I found out special interrelationship, Hardie, Allen, Severance for Evison, Kyosin Kim, Kyucheol Choi etc. for Ki Ryu Jang These special people were religious actors or social thinkers. Conclusions: To be a great doctor to excel and innovate medical field, medical students should have the chance to meet with people based on religious, ethical and social action, discuss on value across social fields, and can construct the idea to make and realize higher value of medical action. In sum, another important human environment for medical students would be a person who could be communicate with true value.

The Design of Manufacturing Simulation Modeling Based on Digital Twin Concept (Digital Twin 개념을 적용한 제조환경 시뮬레이션 모형 설계)

  • Hwang, Sung-Bum;Jeong, Suk-Jae;Yoon, Sung-Wook
    • Journal of the Korea Society for Simulation
    • /
    • v.29 no.2
    • /
    • pp.11-20
    • /
    • 2020
  • As the manufacturing environment becomes more complex, traditional simulation models alone are having a lot of difficulties in reflecting real-time manufacturing situations. Although the Digital Twin concept is actively discussed as an alternative to overcome theses issues, many studies are being carried out only in the product design phase. This research presents a Digital Twin-based manufacturing environment framework for applying the Digital Twin concept to the manufacturing process. Twin model that is operated in virtual space, physical system and databases describing the actual manufacturing environment, are proposed as detailed components that make up the framework. To check the applicability of proposed framework, a simple Digital Twin-based manufacturing system was simulated in a conveyor system using Arena software and Excel VBA. Experiment results have shown that the twin model is transmitted real time data from the physical system via DB and were operating in the same time unit. The Excel VBA fitted parameters defined by cycle time based on historical data that real-time and training data are being accumulated together. This study proposes operating method of digital twin model through the simple experiment examples. The results lead to the applicability of Digital twin model.

A Study on the Calculation of Load Resistance Factor of over Tension Anchors by Optimization Design (최적화 설계를 통한 과긴장 앵커의 하중-저항계수 산정 연구)

  • Soung-Kyu Lee;Yeong-Jin Lee;Yong-Jae Song;Tae-Jun Cho;Kang-Il Lee
    • Journal of the Korean Geosynthetics Society
    • /
    • v.22 no.4
    • /
    • pp.17-26
    • /
    • 2023
  • To consider the risk of damage and fracture of P.C strands, the existing post-maintenance system alone has the limitations, hence it is necessary to quantitatively evaluate and predict the deterioration, durability and safety of facilities and establish a reasonable maintenance system considering the asset value of facilities. Therefore, it is worth considering a preventive maintenance plan that allows proactive measures to be taken before a major defect occurs in the temporary anchor. This study devised a preventive over tension method, reviewed its effectiveness through design and field tests, by calculating the resistance factors by performing a reliability-based optimization design. At this time, the over tension anchor method was evaluated using the ratio of the residual tension force after the fracture of P.C strands to the effective tension force before the fracture of P.C strand, followed by the resistance factor calculated by the optimal solution for each random variables using Excel solver and applying it to the limit state equations. As a result of the study, if the over tension ratio is 125% to 130%, the remaining strands showed a high resistance effect even after the fracture of P.C strand. As a result of the optimization design, it was found that it is appropriate to apply the load factor (γ) of 1.25, and the resistance factors of Φ1, Φ2, Φ3 as 0.7, 0.5, 0.6.

A Practical 1 Page Contextual Diagram for Monitoring Multiple Projects: An Empirical Study of an IT Organization

  • Lee, Jung-Gyu;Jeong, Seung-Ryul
    • Journal of Internet Computing and Services
    • /
    • v.17 no.5
    • /
    • pp.121-129
    • /
    • 2016
  • Company A, an embedded system manufacturer, has been managing multiple development projects. Executives need to understand the risk level of every project and prioritize resource distribution. Traditional project monitoring tools or excel sheets are too complex for calculating the risk factors across a functional organization. Two new charts, "Spear-head Chart" and "Float Chart" were designed to assist high level decision making processes. Two charts were used for weekly executive meetings in order to monitor project progress and rectify project direction. One page graphical monitoring tools in Company A are good enough for high management decision making. Authors explain the characteristics of two charts and propose its practical implementation in real working environment. Spear-head chart was also implemented as a system.

수송기계 엔진용 3C-SiC 마이크로 압력센서의 제작

  • Han, Gi-Bong;Jeong, Gwi-Sang
    • Proceedings of the Korean Society Of Semiconductor Equipment Technology
    • /
    • 2006.10a
    • /
    • pp.10-13
    • /
    • 2006
  • This paper describes on the fabrication and characteristics of a 3C-SiC (Silicon Carbide) micro pressure sensor for harsh environment applications. The implemented micro pressure sensor used 3C-SiC thin-films heteroepitaxially grown on SOI (Si-on-insulator) structures. This sensor takes advantages of the good mechanical properties of Si as diaphragms fabricated by D-RIE technology and temperature properties of 3C-SiC piezoresistors. The fabricated pressure sensors were tasted at temperature up to $250^{\circ}C$ and indicated a sensitivity of 0.46 mV/V*bar at room temperature and 0.28 mV/V*bar at $250^{\circ}C$. The fabricated 3C-Sic/SOI pressure sensor presents a high-sensitivity and excel lent temperature stability.

  • PDF

Development of Design Program for Air Handling Units (공기조화기 설계프로그램 개발)

  • Ham, J.K.;Kim, J.H.;Kim, Y.K.;Kim, Y.I.;Kang, P.Y.
    • Proceedings of the KSME Conference
    • /
    • 2000.11b
    • /
    • pp.674-679
    • /
    • 2000
  • An air handling unit(AHU) has been usually designed by manual calculations. Drawing works together with design calculations should be redone far every designing work, and also be needed to make some corrections of them. In order to design the AHU more efficiently, an AHU program has been developed. The developed program on the Windows environment is operated by the graphic user interface(GUI) realized using the Visual Basic Interpreter. The program provides calculation sheet of coils, weights and pressures in a MS-Excel file format as well as design drawing of the AHU in a Auto CAD file format idealized by AutoLISP. Those files of the commercial softwares make easier for a designer to transfer design results to the another company for bid via e-mail.

  • PDF

Experimental Study of Floor Impact Sound Insulation by the Finishing Materials and Porous Ratio of Insulations of Floor Structure in Mock-up Test Room (모형실험실에서 바닥충격음 완충재의 발포율 및 바닥마감재의 변화에 따른 충격음 차단성능에 대한 실험적 연구)

  • 김태희;오진균;신일섭;조창근
    • Proceedings of the Korean Society for Noise and Vibration Engineering Conference
    • /
    • 2003.11a
    • /
    • pp.756-759
    • /
    • 2003
  • It is increasing the interest on the comfortable dwelling environment and the efforts to solve the problem of the floor impact noise in apartment houses have been realized, as a result numerous products have been made. The purpose of this study is to investigate the sound insulation performances according to foaming rate of floor impact noise insulators and flooring coverings in Mock-up Test Room. The test results of impact insulation performance for each floor impact noise insulators is that double structure of insulator is excel than one in low-middle frequency band and as foaming rate go up, the sound insulation performance is improved.

  • PDF

New Business Model Development Using 6Sigma Methodology (6시그마 방법론을 이용한 신 비즈니스 모델 개발)

  • Sung, Ki-Wook;Yoo, Jae-Sung;Kim, Bong-Sun
    • Proceedings of the Safety Management and Science Conference
    • /
    • 2010.04a
    • /
    • pp.401-414
    • /
    • 2010
  • Global financial crisis at 2008 caused a great change of the company itself and environment as hit product, new creative business model. But it is not easy program. Ambidextrous organization excel at exploiting existing products to enable incremental innovation and at exploring new opportunities fo foster more radical innovation. In this paper are presented the improved procedures of new business model development using 6 sigma methodology. To inspired about new business ideas we use exploration method. To eliminate project's waste we use exploitation method such as 6sigma methodology. The main object of this study is to introduce an empirical study on DIDOV.

  • PDF