• Title/Summary/Keyword: excel based model

Search Result 86, Processing Time 0.031 seconds

A Plug-in Development for Interworking between SysML Model and Plant Information (SysML모델과 플랜트정보 간 상호연동을 위한 플러그인 개발)

  • Kim, Joon Young;Lee, Tae Kyong;Cha, Jae Min
    • Journal of the Korean Society of Systems Engineering
    • /
    • v.15 no.2
    • /
    • pp.17-30
    • /
    • 2019
  • Due to difficulties in tracking design information of existing document-based configuration management, the research on the development of plant SysML model was started to apply the model-based system engineering methodology to comprehensively manage various design information. However, until now, in order to create the SysML model, the engineers are checking the design information and inputting it to the SysML model. This process requires a lot of time and manpower, it is required to minimize it. Therefore, this study has recognized the problem, a plug-in that extracts the plant design information in the design document and automatically converts the SysML plant model from it. Specifically, the development was performed in the following order. First, the extraction file was selected as the most commonly used Excel file as the plant design document. Next, the design information in the document was analyzed, and extracted information including tag number, name, and the capacity were selected. Finally, the plant SysML model conversion module was implemented. The developed plug-in is confirmed that the task load of the engineers by the SysML model conversion can be minimized and the model can be generated more quickly and accurately.

Design of Flexible DSS Architecture for OTC Derivatives Trading: 'A' Bank Case (장외파생상품거래를 위한 유연한 의사결정지원시스템 아키텍처 설계에 관한 연구: A은행 사례)

  • Lee, Keun-Woo;Yang, Kun-Woo
    • The Journal of Information Systems
    • /
    • v.20 no.1
    • /
    • pp.107-126
    • /
    • 2011
  • Model-based decision support system (DSS) has acted as a crucial role in strengthening the business competitiveness by providing a way of modeling and solving real-world decision problems in a quantitative and scientific manner. It is even more important for trading OTC derivatives, which requires extensive financial-engineering expertise while actively reacting to the continuously changing financial market. This paper proposes a flexible model-based DSS architecture that can support user-friendly interface for executing and analyzing the models and can adapt to the changes of financial market seamlessly. For user-friendliness, we implement the user-interfaces (UIs) using Microsoft Excel, a very widely used spreadsheet program for its great generality and extensibility. Users can utilize the analysis results of DSS or reprocess them for their special needs through the UIs in the form of familiar spreadsheets easily. For adaptiveness to the markets, the proposed architecture is constructed based on the object-oriented concepts, which enables such changes as release of a new financial product can be updated into the system without any delay at the lowest cost. We investigate the practical benefits and limitations of the proposed architecture by a case study on the construction of Model-based Trading Support System (MTSS), performed by a commercial bank in Korea.

Development of BIM Based Information Model Interface Module for a Modular Pier (모듈러 교각의 BIM 기반 정보 모델 인터페이스 모듈 개발)

  • Kim, Dong-Wook;Lee, Kwang-Myong;Nam, Sang-Hyeok
    • Journal of KIBIM
    • /
    • v.5 no.1
    • /
    • pp.1-7
    • /
    • 2015
  • Modular technology has become a major issue of the construction industries to enhance their productivity. Modular bridge construction generally requires the data exchange between the contractors, designers, fabricators and constructors. Therefore, a readily accessible information model interface module based on BIM technology is essential for their communication during a project life-cycle. In this study, BIM based information model interface module for a modular pier was developed. For the information models, the PBS(Product Breakdown Structure) and LOD(Level of Development) were defined. Next, all components of a modular pier were conducted by the parametric modeling technique, and then 3D cell library interface was developed. An nterface module was also developed using VBA(Visua basic Application) for exchanging a data from 3D model library to other softwares such as Microstation, AutoCad and Excel and was connected with MS Access database. The developed information model interface module would improve the design quality of the modular pier and reduce the time and cost for design. Updated 3D information models could be utilized for the fabrication, assembly, and construction process for modular piers.

A Study on the classification of quality attributes in culinary education based on the Kano model (Kano 모델을 기반으로 한 조리교육 품질속성 분류에 관한 연구 - 전문대학, 전문학교를 중심으로 -)

  • Kim, Tae-Hyun;Kim, Tae-Hee
    • Culinary science and hospitality research
    • /
    • v.19 no.5
    • /
    • pp.170-183
    • /
    • 2013
  • The purpose of this study is to classify the attributes of culinary educational quality by using the Kano model. This study carried out literary research and empirical analysis. Data were collected among 486 students whose major is culinary arts and analyzed with SPSS 19.0 and EXCEL 2007. It classified culinary educational quality by employing the Kano model and modified the Better and Worse quotients suggested by Timko. The results of the study are as follows. First, it was found that total 25 attributes could be classified into 17 Attractive quality attributes, 2 Must-be quality attributes and 6 Indifferent quality attributes, while One-dimensional quality, Reverse quality and Questionable quality attributes were not found. Second, according to the Better and Worse quotient by Timko, "Objective instructor's evaluation" item was the highest score in the Better quotient. On the other hand, the "Having foreign professors" item is the lowest in the Worse quotient. Third, marketing implications and limitations were discussed.

  • PDF

Development of a Graphical Modeler for Manipulating Series Data Based on Object-Oriented Technique (일련 자료 처리를 위한 시각적 객체 기반 모델러 개발)

  • Kim, Tae-Gon;Lee, Jeong-Jae
    • Journal of The Korean Society of Agricultural Engineers
    • /
    • v.51 no.2
    • /
    • pp.43-49
    • /
    • 2009
  • Many researcher uses simulation techniques for understanding the phenomenon and expecting the response. Simulation techniques have many advantages which is less time-consuming, easy to control constraints, and cheaper than experimental study. However Researches usually are not good at programming the model, it's hard to implement simulation model using computer language. They use spreadsheet program like Microsoft $excel^{TM}$ Although a spreadsheet program is good for modeling, it's cumbersome to describe expressions which consist of not variable name but location indicator. This study suggests the program which helps researcher developing model using graphical interface and variable name. For verifying usability, the model which is implemented by developed modeler were compared with by spreadsheet program.

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

A Method on Developing 3D/BIM-Based Real Time Fire Disaster Information Management (3D/BIM 기반 기존 건축물 실시간 건물 화재 정보 관리 방안)

  • Bae, Subin;Cha, Heesung
    • Korean Journal of Construction Engineering and Management
    • /
    • v.24 no.2
    • /
    • pp.3-12
    • /
    • 2023
  • Fire accidents in buildings are reported more frequently nowadays. Existing building fire accidents can lead to large-scale accidents as damage to human and physical resources increases over time, so it is necessary to quickly find ways to suppress fires and rescue them. Currently, more attention is being paid to new buildings than the existing buildings. In addition, fire information can not be captured in a real time basis for the buildings. In line with the demands of this technology, this study presents a quick and systematic fire management method to minimize damage caused by fire in buildings. As a way to achieve the purpose of the study, ArduinoTM sensors and ExcelTM and RevitTM-DynamoTM tools have been combined to develop a new fire information management system and develop a real-time 3D visualization model. It is expected to contribute to the real-time smart fire management system by proposing a fire management application as a way to utilize it in the future.

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.

Evaluation of Factors Related to Productivity and Yield Estimation Based on Growth Characteristics and Growing Degree Days in Highland Kimchi Cabbage (고랭지배추 생산성 관련요인 평가 및 생육량과 생육도일에 의한 수량예측)

  • Kim, Ki-Deog;Suh, Jong-Taek;Lee, Jong-Nam;Yoo, Dong-Lim;Kwon, Min;Hong, Soon-Choon
    • Horticultural Science & Technology
    • /
    • v.33 no.6
    • /
    • pp.911-922
    • /
    • 2015
  • This study was carried out to evaluate growth characteristics of Kimchi cabbage cultivated in various highland areas, and to create a predicting model for the production of highland Kimchi cabbage based on the growth parameters and climatic elements. Regression model for the estimation of head weight was designed with non-destructive measured growth variables (NDGV) such as leaf length (LL), leaf width (LW), head height (HH), head width (HW), and growing degree days (GDD), which was $y=6897.5-3.57{\times}GDD-136{\times}LW+116{\times}PH+155{\times}HH-423{\times}HW+0.28{\times}HH{\times}HW{\times}HW$, ($r^2=0.989$), and was improved by using compensation terms such as the ratio (LW estimated with GDD/measured LW ), leaf growth rate by soil moisture, and relative growth rate of leaf during drought period. In addition, we proposed Excel spreadsheet model for simulation of yield prediction of highland Kimchi cabbage. This Excel spreadsheet was composed four different sheets; growth data sheet measured at famer's field, daily average temperature data sheet for calculating GDD, soil moisture content data sheet for evaluating the soil water effect on leaf growth, and equation sheet for simulating the estimation of production. This Excel spreadsheet model can be practically used for predicting the production of highland Kimchi cabbage, which was calculated by (acreage of cultivation) ${\times}$ (number of plants) ${\times}$ (head weight estimated with growth variables and GDD) ${\times}$ (compensation terms derived relationship of GDD and growth by soil moisture) ${\times}$ (marketable head rate).

An Longitudinal Analysis of Changing Beliefs on the Use in IT Educatee by Elaboration Likelihood Model (정교화 가능성 모형에 의한 IT 피교육자 신용 믿음 변화의 종단분석)

  • Lee, Woong-Kyu
    • Asia pacific journal of information systems
    • /
    • v.18 no.3
    • /
    • pp.147-165
    • /
    • 2008
  • IT education can be summarized as persuading the educatee to accept IT. The persuasion is made by delivering the messages for how-to-use and where-to-use to the educatee, which leads formulation of a belief structure for using IT. Therefore, message based persuasion theory, as well as IT acceptance theories such as technology acceptance model(TAM), would play a very important role for explaining IT education. According to elaboration likelihood model(ELM) that has been considered as one of the most influential persuasion theories, people change attitude or perception by two routes, central route and peripheral route. In central route, people would think critically about issue-related arguments in an informational message. In peripheral route, subjects rely on cues regarding the target behavior with less cognitive efforts. Moreover, such persuasion process is not a one-shot program but continuous repetition with feedbacks, which leads to changing a belief structure for using IT. An educatee would get more knowledge and experiences of using IT as following an education program, and be more dependent on a central route than a peripheral route. Such change would reformulate a belief structure which is different from the intial one. The objectives of this study are the following two: First, an identification of the relationship between ELM and belief structures for using IT. Especially, we analyze the effects of message interpretation through both of central and peripheral routes on perceived usefulness which is an important explaining variable in TAM and perceived use control which have perceived ease of use and perceived controllability as sub-dimensions. Second, a longitudinal analysis of the above effects. In other words, change of the relationship between interpretation of message delivered by IT education and beliefs of IT using is analyzed longitudinally. For achievement of our objectives, we suggest a research model, which is constructed as three-layered. While first layer has a dependent variable, use intention, second one has perceived usefulness and perceived use control that has two sub-concepts, perceived ease of use and perceived controllability. Finally, third one is related with two routes in ELM, source credibility and argument quality which are operationalization of peripheral route and central route respectively. By these variables, we suggest five hypotheses. In addition to relationship among variables, we suggest two additional hypotheses, moderation effects of time in the relationships between perceived usefulness and two routes. That is, source credibility's influence on perceived usefulness is decreased as time flows, and argument quality's influence is increased. For validation of it, our research model is tested empirically. With measurements which have been validated in the other studies, we survey students in an Excel class two times for longitudinal analysis. Data Analysis is done by partial least square(PLS), which is known as an appropriate approach for multi-group comparison analysis with a small sized sample as like this study. In result. all hypotheses are statistically supported. One of theoretical contributions in this study is an analysis of IT education based on ELM and TAM which are considered as important theories in psychology and IS theories respectively. A longitudinal analysis by comparison between two surveys based on PLS is also considered as a methodological contribution. In practice, finding the importance of peripheral route in early stage of IT education should be notable.