Kori Unit 1 was permanently shut down in 2017 and is preparing to be dismantled. Decommissioning nuclear power plants is expected to generate a lot of decommissioning waste. Therefore, a radioactive waste treatment complex will be built on the site to safely and effectively the process of decommissioning waste generated from the Kori Unit 1, and the details are specified in the decommissioning plan. Therefore, a safety assessment should be conducted according to the facility’s normal and abnormal operations to construct a radioactive waste treatment complex. Currently, a safety assessment for a radioactive waste treatment complex can be conducted by the Safety Assessment Framework (SAFRAN) Tool based on the Safety Assessment Driving Radioactive Waste Management Solutions (SADRWMS) methodology developed by the International Atomic Energy Agency (IAEA). The SAFRAN Tool can be calculated radiation dose and hazard quotient (HQ) for workers and the public under normal and abnormal conditions of the radioactive waste treatment complex. When evaluating the radiation dose for the public due to releasing radioactive materials into the air or discharging radioactive materials into liquids, the radiation dose is calculated using the amount discharged or released from the treatment complex, and the Pathway Dose Factors (PDFs) derived from the generic environmental model given in the IAEA Safety Reports Series No.19. PDFs, which reflect the specific site data rather than the generic environmental model data, should be calculated and evaluated when performing the safety evaluation of the radioactive waste treatment complex to be built on the Kori site. In addition, in the SAFRAN tool, there is an inconvenience in that it must be calculated separately by radionuclides to calculate the contribution of dose or HQ for each radionuclide. Therefore, in this study, a safety assessment tool for a radioactive waste treatment complex was developed using Visual Basic by supplementing the limitations of the SAFRAN tool. This tool was developed to allow users to choose whether to apply PDFs based on the IAEA SRS-19 based on the generic environmental model or PDFs calculated to reflect the specific site data. Furthermore, the tool considered all types of decommissioning wastes that may occur during the decommissioning of the Kori Unit 1 and the treatment process scheduled to be introduced. Therefore, this study is expected to be used as basic data when conducting the safety assessment of radioactive waste treatment complex scheduled to be introduced in Korea.

Climate change is the biggest environmental issue of our times. A variety of activities to reduce greenhouse gas emissions have been in progress to observe the Kyoto Protocol. Especially, the Energy Target Scheme is created to reduce greenhouse emission with the supervision of Korean government. This includes Green-house Gas Information Systems to promote activities in the private sector to reduce green-house gas emissions, to cut a cost of energy use, and to reduce GHG emissions. Also, the system has calculated the amount of greenhouse gases. Without any additional investment, 2.75% savings are increased over the previous year. In service sector, a cooperation of customers and employees is necessary. A reduction of GHG emissions requires a proper service organization, considering an amount of investment and payback period. Without any additional investment or replacement, employees can save energy easily turning off ventilation systems an hour before employees’ departure, installing timers to turn off water purifiers and vending machines after some period of no use. The Green-house Gas Information System is similar to that of Environmental Management System. However, the Excel is the best program to calculate an amount of green-house gas emissions, and to assess for a reduced amount of GHG emissions. A goal of this research is to propose a practical method in the private sector to calculate an amount of green-house gases. The Green-house gas Information System based on Excel spreadsheet gives standards for good evaluation. The greenhouse gas information system establishes and executes the policies and objectives related to greenhouse gas emissions Similar to ISO 14001 environment management system structures, the advantages of using simplified Excel Sheet for calculating GHG emissions and reducing GHG emissions are easy to access.

This paper presents PKES(PuKyung -Excel based Simulator) for WWTPs(wastewater treatment plants) by using MS Excel and VBA(Visual Basic for Application). PKES is a user-friendly simulator for the design and optimization of the whole plant including biological and physico-chemical processes for the wastewater and sludge treatment. PKES calculates the performance under steady or dynamic state and allows changing the mathematical model by the user. Mathematical model implemented in PKES is a improved integration model based on ASM2d and ADM1 for simulation of AS(activated sludge) and AD(anaerobic digestion). Gaseous components of N2, N2O, CO2 and CH4 are added for estimation of GHGs(greenhouse gases) emission.The simulation results for comparison between PKES and Aquasim(EAWAG) showed about the same effluent concentrations. As a result of verification using by measured data of BOD, TSS, TN and TP for 2 years of operation, calculated effluent concentrations were similar to measured effluent concentrations. The values of average RMSE(root mean square error) were 1.9, 0.8, 1.6 and 0.2 mg/L for BOD, TSS, TN and TP, respectively. Total GHGs emission of WWTP calculated by PKES was 138.5 ton-CO2/day and GHGs emissions of N2O, CO2 and CH4 were calculated at 21.7, 28.9 and 87.9 ton-CO2/day, respectively. GHGs emission of activated sludge was 32.5 % and that of anaerobic digestion was 67.5 %.

Climate change has been identified as one of the greatest challenges facing nations,government, business and citizens over future decades. Activities to reduce greenhouse gas emissions by the Kyoto Protocol, the international community has been in progress. Korea also has introduced the green house gas and energy Target Scheme to reduce greenhouse emission under the supervision of the government. Established green house gas information systems to promote activities of the private sector to reduce greenhouse gas emissions, The main propulsion is intended to be used as a basis in the private sector to reduce greenhouse gas utilized in the calculation of greenhouse gas emissions program (Excel spreadsheet), and to reduce greenhouse gas emissions evaluation standards published.

Belleville springs can sustain relatively large loads with small deflections and belleville spring washers are especially suited for high loads in small places. Belleville springs are used singly or in stacks to achieve desired load such as power transmission components. The aim of this paper is to design for the belleville spring diameter and thickness to minimize volume of the system. The design is carried out using finding solution in a commercial spreadsheet application software, Microsoft Excel 2007. The numerical results are obtained where the displacement, stress and load in the spring are treated as constraints function.

This research studies the present status of utilization of IT in SMB, Small & Medium Business, logistics companies, and analyzes the examples of utilizing Excel VBA for building and operating IT system in SMB logistics companies. Through the study, this research suggests main issues of building and operating logistic systems and the effective way of utilizing the systems in SMB logistics companies.

The purpose of this thesis is to develop a performance rating training tool for the time and motion study. It is widely recognized that rating training tools based on films were made several decades ago and introduced to Korea. However, to the best of our

This research studies the present status of utilization of IT in SMB, Small & Medium Business, logistics companies, and analyzes the examples of utilizing Excel VBA for building and operating IT system in SMB logistics companies. Through this study, this research suggests main issues of building and operating logistic systems and the effective way of utilizing the systems in SMB logistics companies.

This paper focuses on a BOM(Bill of Materials) management problem for a small and medium manufacturing company that produce automobile parts. Automobile part's manufacturers produce various products due to various automobile characteristics such as types,

This paper proposes an efficient and effective BOM management scheme for small and medium manufacturing (SME) companies that produce automobile parts. Automobile part‘s manufacturers produce very various products due to various automobile characteristics such as types, colors, and options of cars. These products are classified into product groups with common parts and like this product groups with commonality are regarded as product family. This paper proposes a BOM data model for product family structures and implements the practical EXCEL-based BOM management system for real small and medium manufacturing (SME) companies that produces automobile parts.