• Journal of Korean Society for Atmospheric Environment
• /
• 제28권5호
• /
• pp.556-570
• /
• 2012

The Low Carbon Path Calculator is an excel-based model to project greenhouse gas emissions from 2009 to 2050, which is based on the 2050 Pathways Calculator developed by the UK Department of Energy and Climate Change (DECC). Scenarios are developed to reduce GHG emissions in Korea at 50% based on 2005 levels by 2050 using a Low Carbon Path Calculator. They were classified in four different cases, which are high renewable, high nuclear, high CCS and mixed option scenarios. The objectives of this study are to compare scenarios in terms of GHG emissions, final energy, primary energy and electricity generation and examine the usefulness of that model in terms of identifying pathways towards a low carbon emission society. This model will enhance the understanding of the pathways toward a low carbon society and the level of the climate change policy for policy makers, stakeholders, and the public. This study can be considered as a reference for developing strategies in reducing GHG emissions in the long term.

• KSCE Journal of Civil and Environmental Engineering Research
• /
• 제37권6호
• /
• pp.973-980
• /
• 2017

The purpose of this study is to develop VDFT (Visual Basic based Density-coupled Flow and Transport), a numerical modeling code used to simulate density coupled flow equations used to simulate seawater intrusion in a two dimensional finite difference method. The VDFT code has the advantage of being intuitive and simple to use and has the advantage of utilizing the EXCEL Visual Basic platform, which is widely used for general business purposes. Generally, code developed for numerical simulation can be verified through representative example models called benchmark problem. In this study, we verified the VDFT code using benchmark problem called Henry Problem and Modified Henry Problem as well as two laboratory test data. The results of this study are analyzed the importance of each benchmark problems, validated VDFT code compared to those problems. In conclusion, the possibility of using VDFT code is diagnosed and the direction of future research is suggested.

• Journal of the military operations research society of Korea
• /
• 제33권1호
• /
• pp.1-18
• /
• 2007

In the early stage of weapon system acquisition process, acquisition policy is necessarily established to acquire weapon system in a faster, better, cheaper way. Several alternatives, such as "buy", "domestic research and development", and "technical corporative production", can be considered for the best acquisition policy making. However, the comparison factors for those alternatives have different metrics and values. Therefore, the aim of this paper is to suggest KAAM(Knowledge-based Alternatives Analysis Model) as a scientific method to compare the alternatives having such different metrics and values and giving a weighted and normalized single measurement for the easy comparison. KAAM is a hybrid model incorporating Satty technique, Delphi/Shang method, Consensus method, and SAW method. KAAM is implemented on Microsoft Excel environment and provided tabular form user interface. Finally, an illustrative example is shown using KAAM.

• Journal of the Korean Society for Aviation and Aeronautics
• /
• 제16권4호
• /
• pp.1-11
• /
• 2008

This research presents a study for the knowledge-based configuration design development of a RC (remote control) helicopter. Parametric design and knowledge based design concepts are introduced for rapid design changes and analyses using commercial CAD software, CATIA(R) Knowledgeware module. It is crucial for RC helicopter design because it enables rapid conceptual design through instant configuration changes. Positions and dimensions of RC helicopter parts were used as design parameters. As an example, positions of CG(center of gravity) points were traced and plotted as the configuration changes. Further research should be performed in areas of user interfaces and web-based multi-user environments instead of using Excel data sheets.

• Journal of Ocean Engineering and Technology
• /
• 제14권3호
• /
• pp.61-65
• /
• 2000

The estimation of soil stabilization is of great importance concerning the construction of structures on weak soil. A typical model of soil stabilization is considered as replacement, which is based on ground at failure due to direct loading on weak soil. The calculation of the line of predicting settlement was carried out using RPL and DIKE programs. The DIKE program is showing a tendency to excel totally about this embankment of the seadike. Hereafter, This program will be contributed widely to the construction of offshore structures on weak soil.

• Journal of the military operations research society of Korea
• /
• 제27권2호
• /
• pp.37-55
• /
• 2001

The main purpose of this study is to review the current system and to develop a decision support system for evaluating the priorities among those possible alternatives in the army facility enterprise. This paper also provides an information system which can be effectively applied to various criteria and stages in decision making process such as Planning and Programming phases in PPBEES. The model base of decision support systems uses the concepts of the analytic hierarchy process along with the supplementary techniques such as TOPSIS and 0-1 integer programming. Both AHP and TOPSIS are used scoring approaches in the Planning phase and IP is induced at the Programming phase to give GO/NO-GO solution for each project. We use Expert Choice, Excel and LINDO s/w's to implement a prototyped model. The proposed methodology in this paper enables the decision makers to evaluate the priority based on quantitative and qualitative data in a systematic way.

• Journal of Navigation and Port Research
• /
• 제39권4호
• /
• pp.353-360
• /
• 2015

The offshore oil production requires a huge amount of cost and time accompanied by multiple variables due to the peculiar nature of 'offshore'. And every process concerned is controlled by elaborate series of plans for reducing loss of lives, environment and property. This paper treats an optimization problem for offshore oil production and transportation. We present an offshore production and transportation network to define scope of the problem and construct a mixed integer linear programming model to tackle it. To demonstrate the validity of the optimization model presented, some computational experiments based on hypothetical offshore oil fields and demand markets are carried out by using MS Office Excel solver. The downstream of the offshore production and transportation network ends up with the maritime transportation problem distributing the crude oil produced from offshore fields to demand markets. We used MoDiSS(Model-based DSS in Ship Scheduling) which was built to resolve this maritime transportation problem. The paper concludes with the remark that the results of the study might be meaningfully applicable to the real world problems of offshore oil production and transportation.

• Korean Journal of Construction Engineering and Management
• /
• 제12권6호
• /
• pp.110-119
• /
• 2011

Global warming caused by excessive greenhouse gas emission is causing climate change all over the world. In Korea, greenhouse gas emission from residential buildings accounts for about 10% of gross domestic emission. Also, the number of deteriorated multi-family housing complexes is increasing. Therefore, the goal of this research is to establish the bases to manage energy consumption continuously and methodically during MR&R period of multi-family housings. The research process and methodologies are as follows. First, research team collected the data on project characteristics and energy consumption of multi-family housing complexes in Seoul. Second, an ontology-based breakdown structure was established with some primary characteristics affecting the energy consumption, which were selected by statistical analysis. Finally, a predictive model of energy consumption was developed based on the ontology-based breakdown structure, with application of CBR, ANN, MRA and GA. In this research, PASW (Predictive Analytics SoftWare) Statistics 18, Microsoft EXCEL, Protege 4.1 were utilized for data analysis and prediction. In future research, the model will be more continuous and methodical by developing the web-base system. And it has facility manager of government or local government, or multi-family housing complex make a decision with definite references regarding moderate energy consumption.

• International Journal of Highway Engineering
• /
• 제15권2호
• /
• pp.121-129
• /
• 2013

PURPOSES : This study deals with the traffic accidents of rotary in Korea. The objective of this study is to develop the accident models by age group based on the various data of rotaries. METHODS : In pursuing the above, this study gives particular attentions to classifying the accident data of 17 rotaries by age, collecting the data of geometric structure, traffic volume and others, and developing the models using SPSS 17.0 and EXCEL. RESULTS : First, 3 multiple linear regression models which were all statistically significant were developed. The value of model of under 30-49 age group were, however, evaluated to be 0.688 and be less than those of other models. Second, the most powerful variables were analyzed to be traffic volume in the model of under 30 age group, circulatory roadway width in the model of 30-49 age group, and the number of approach lane in the model of above 50 age group. Finally, the test results of accident models using RMSE were all evaluated to be fitted to the given data. CONCLUSIONS : This study propose install streetlights, speed humps and widen Circulatory as effective improvements for reduction of accident in rotary.

• Journal of the Society of Naval Architects of Korea
• /
• 제51권1호
• /
• pp.51-57
• /
• 2014

In the KIOST MOERI model ice basin, a lot of experiments to find the material properties of model ice and model ship tests are being performed. And therefore many data information was produced, yet it was saved as excel data format. In order to manage and use the data more effectively and systematically, a proper database management is required. To make realistic engineering DBMS(database management system), understanding of test process, the usage of data, design of data schema and computer language and system management are required. In this paper, basic design process and usage of DBMS based on network and multiple user concept is introduced.