• 제목/요약/키워드: Excel environment

검색결과 106건 처리시간 0.027초

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

  • 권재섭;조명희
    • 한국지리정보학회지
    • /
    • 제4권4호
    • /
    • pp.21-28
    • /
    • 2001
  • 본 연구에서는 기존에 개발된 상수도 관련 GIS(geographic information system)에서 관로해석을 위한 자료를 자동으로 입력할 수 있고, 사용자를 위한 GUI(geographic user interface)를 제공하는 GNLP(GIS linked non-linear pipe network analysis program)프로그램을 개발하였다. 관로시스템의 수리해석은 Hazen-Williams의 손실수두방정식을 기초로 한 비선형 해석기법을 이용하여 시행하였으며, 데이터베이스 응용 프로그램을 작성하기 위해서 관계형 데이터베이스 관리시스템(RDBMS ; relational database management system)인 Microsoft사의 Microsoft Access를 사용하였다. 이 GNLP 프로그램은 실제 관망설계자가 관로시스템의 수리해석에 필요한 자료의 입력을 용이하게 할 수 있도록 시스템환경을 개선하였다. 그리고 압력 및 유량 등 관로시스템의 수리적 해석 결과를 표 및 챠트 형태로 출력이 가능하고, Excel 파일로 변환이 가능하다. 또한 GIS의 중요 요소인 질의(query) 기능이나 분석된 자료를 확인하고자 할 때 이를 효과적으로 디스플레이가 가능하도록 개발되었다.

  • PDF

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

  • 이소민;이민혁;강미진;권순광;나진성;박백수
    • 한국환경보건학회지
    • /
    • 제46권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 -)

  • 류숙희
    • 의학교육논단
    • /
    • 제9권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.

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

  • 황성범;정석재;윤성욱
    • 한국시뮬레이션학회논문지
    • /
    • 제29권2호
    • /
    • pp.11-20
    • /
    • 2020
  • 제조환경이 더욱 복잡해짐에 따라 전통적인 시뮬레이션만으로는 실시간 현장 결과를 평가하는 데 많은 어려움을 겪고 있다. 이를 극복하기 위한 대안으로 Digital Twin개념이 활발히 논의되고 있지만, 제품설계 단계에 국한되어 연구가 진행되고 있는 실정이다. 본 연구는 Digital Twin개념이 생산 공정 프로세스에 적용되기 위한 Digital Twin 기반 제조환경 프레임워크를 제시하였다. 구성요소는 실제 생산환경인 물리적 시스템과 데이터베이스, 그리고 가상 시스템인 트윈 모델을 제안하였다. 본 연구에서는 Arena 소프트웨어와 엑셀 VBA를 활용하여 컨베이어 시스템을 대상으로 간단한 Digital Twin 기반 제조시스템을 모의실험하였다. 실험결과 트윈 모델이 실제 물리적 시스템의 실시간 데이터를 전송받아 동일한 시간단위로 작동됨을 확인하였고, 엑셀 VBA에서 축적된 실시간 데이터와 학습 데이터를 기반으로 조정된 파라미터를 생성하고 있음을 확인하였다. 또한, 간단한 모의실험을 통해 Digital Twin 모델 구동 방법을 제안하였으며, Digital Twin 모델의 구현 가능성을 보여주었다.

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

  • 이성규;이영진;송용재;조태준;이강일
    • 한국지반신소재학회논문집
    • /
    • 제22권4호
    • /
    • pp.17-26
    • /
    • 2023
  • 강연선의 손상 및 파단위험에 대하여 적극적으로 대처하기 위해서는 기존의 사후 유지관리 체계만으로는 한계가 있으며 시설물의 내구성, 안전성 저하를 정량적으로 평가 및 예측하고 시설물의 자산가치를 고려한 합리적인 유지관리 체계의 구축이 요구된다. 따라서 가설앵커에 큰 결함이 발생하기 전 사전조치가 이루어지도록 하는 선제적 유지관리 방안을 고려해볼 가치가 있다. 이를 위해 본 연구에서는 선제적 과긴장 공법을 고안하여 설계 및 현장시험을 통해 그 효과를 검토하고 신뢰성 기반 최적화 설계를 수행하여 저항계수를 산정하였다. 이때 과긴장 앵커의 흙막이 가시설 지지효과는 강연선 파단전 유효긴장력에 대한 강연선 파단후 잔존긴장력의 비를 이용하여 평가하였으며 저항계수는 각 확률변수에 대한 최적해를 Excel solver를 이용하여 구하고 이를 한계상태식에 적용하여 산정하였다. 연구결과 과긴장률이 125%~130%인 경우 강연선 파단 후에도 높은 흙막이 가시설 지지효과를 보였으며 최적화 설계결과 하중계수(γ)는 1.25, 저항계수 Φ1, Φ2, Φ3은 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
    • 인터넷정보학회논문지
    • /
    • 제17권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 마이크로 압력센서의 제작

  • 한기봉;정귀상
    • 한국반도체및디스플레이장비학회:학술대회논문집
    • /
    • 한국반도체및디스플레이장비학회 2006년도 추계학술대회 발표 논문집
    • /
    • 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)

  • 함진기;김종화;김영기;김영일;강병윤
    • 대한기계학회:학술대회논문집
    • /
    • 대한기계학회 2000년도 추계학술대회논문집B
    • /
    • 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)

  • 김태희;오진균;신일섭;조창근
    • 한국소음진동공학회:학술대회논문집
    • /
    • 한국소음진동공학회 2003년도 추계학술대회논문집
    • /
    • 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

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

  • 성기욱;유재성;김봉선
    • 대한안전경영과학회:학술대회논문집
    • /
    • 대한안전경영과학회 2010년도 춘계학술대회
    • /
    • 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