• Journal of the Korean Data and Information Science Society
• /
• v.25 no.2
• /
• pp.403-410
• /
• 2014

Binary logistic regression analysis is a statistical technique that explains binary response variable by quantitative or qualitative explanatory variables. In the binary logistic regression model, the probability that the response variable equals, say 1, one of the binary values is to be explained as a transformation of linear combination of explanatory variables. This is one of big barriers that non-statisticians have to overcome in order to understand the model. In this study, an educational tool is developed that explains the need of the binary logistic regression analysis using Excel VBA. More precisely, this tool explains the problems related to modeling the probability of the response variable equal to 1 as a linear combination of explanatory variables and then shows how these problems can be solved through some transformations of the linear combination.

• Journal of the Korea Academia-Industrial cooperation Society
• /
• v.17 no.8
• /
• pp.55-61
• /
• 2016

BIM is a rising core technology for increasing the productivity of the AEC industry, but such a paradigm shift is placing excessive demand on the practice of small medium size enterprises. BIM has many useful functions that are difficult to imagine in 2D CAD but BIM programs and the system buildup cost are too expensive. Therefore, small medium size enterprises hesitate to apply BIM in their fields. In this study, a customized 4D and 5D system was implemented using the building information generated from basic BIM tools, such as Revit, MS Project, Navisworks, and Excel VBA's customizing process to review the schedule and verify the quantities according to the schedule. Those programs are so basic in BIM circumstances, that small medium size enterprises can be equipped without burden. As a result, essential building information for 4D and 5D system implementation was investigated and its customizing process was established.

• Journal of the Korea Institute of Information Security & Cryptology
• /
• v.24 no.2
• /
• pp.319-325
• /
• 2014

Since smart phones or tablet PCs have been widely used recently, the users can create and edit documents anywhere in real time. If the input and edit flows of documents can be traced, it can be used as evidence in digital forensic investigation. The typical document application is the MS(Microsoft) Office. As the MS Office applications consist of two file formats that Compound Document File Format which had been used from version 97 to 2003 and OOXML(Office Open XML) File Format which has been used from version 2007 to now. The studies on MS Office files were for making a decision whether the file has been tampered or not through detection of concealed items or analysis of documents properties so far. This paper analyzed the input order of text cells on MS Excel files and shows how to figure out what cell is the last edited in digital forensic perspective.

• Journal of the Korean Society for Nondestructive Testing
• /
• v.26 no.4
• /
• pp.246-254
• /
• 2006

A computation program has been developed for automatic data processing in the calibration process of gamma survey meter. The automatic processing program has been developed based on Visual Basic. The program has been coded according to steps of calibration procedure. The OLE(object linking an embedding) Excel automation method fur automatic data processing is used in this program, which is a kind of programming technique for the Excel control. The performance test on the basis of reference data has been carried out by using the developed program. In the results of performance test, the values of calibration factors and uncertainties by the developed program were equal to those obtained from the reference data. In addition, It was revealed that the efficiency and precision of working are significantly increased by using the developed program.

• Journal of Breast Disease
• /
• v.6 no.2
• /
• pp.35-38
• /
• 2018

Purpose: The eighth American Joint Committee on Cancer staging system for breast cancer was recently published to more accurately predict the prognosis by adding biomarkers such as estrogen receptors, progesterone receptors, and human epidermal growth factor receptor 2. However, this system is very complicated and difficult to use by clinicians. The authors developed a program to aid in setting up the staging system and confirmed its usefulness by applying it to theoretical combinations and actual clinical data. Methods: The program was developed using the Microsoft Excel Macro. It was used for the anatomic, clinical and pathological prognostic staging of 588 theoretical combinations. The stages were also calculated the stages using 840 patients with breast cancer without carcinoma in situ or distant metastasis who did not undergo preoperative chemotherapy. Results: The anatomic, clinical and pathological prognostic stages were identical in 240 out of 588 theoretical combinations. In the actual patients' data, stages IB and IIIB were more frequent in clinical and pathological prognostic stages than in the anatomic stage. The anatomic stage was similar to the clinical prognostic stage in 58.2% and to the pathological prognostic stage in 61.9% of patients. Oncotype DX changed the pathological prognostic stage in 2.1% of patients. Conclusion: We developed a program for the new American Joint Committee on Cancer staging system that will be useful for clinical prognostic prediction and large survival data analysis.

• Journal of KIBIM
• /
• v.12 no.2
• /
• pp.49-59
• /
• 2022

The main idea of this study is to propose a BIM-based automation system drawing up a report of energy conservation plan in the architecture division. In order to obtain a building permit, an energy conservation plan must be prepared for buildings with a total floor area of 500m² or more under the current law. Currently, it is adopted as a general method to complete a report by obtaining data and drawings necessary for an energy conservation plan through manual work and input them directly into the verification system. This method takes a lot of effort and time in the design phase which ultimately increases the initial cost of the business, including the services of companies specialized in the environmental field. However, in preparation for mandatory BIM work process in the future, it is necessary to introduce BIM-based automatic creation system that has an advantage for shortening the whole process to enable rapid permission of energy-saving designs for buildings. There may be many methods of automation, but this study introduces how to build an application using Dynamo of Revit, in terms of utilizing BIM, and write an energy conservation plan by automatic completion of report through Dynamo and Excel's VBA algorithm, which can save time and cost in preparing the report of energy conservation plan compared with the manual process. Also we have insisted that the digital transformation of architectural process is a necessary for an efficient use of our automation system in the current energy conservation plan workflow.

• The Journal of Korean Society for Radiation Therapy
• /
• v.25 no.1
• /
• pp.87-90
• /
• 2013

Purpose: Introducing CR (Computed Radiography) system created a process of printing therapy irradiation images and converting the degree of enlargement. This is to increase job efficiency and contribute to work improvement using a computerized method with home grown software to simplify this process, work efficiency. Materials and Methods: Microsoft EXCEL (ver. 2007) and VISUAL BASIC (ver. 6.0) have been used to make the software. A window for each shield block was designed to enter patients' treatment information. Distances on the digital images were measured, the measured data were entered to the Excel program to calculate the degree of enlargement, and printouts were produced to manufacture shield blocks. Results: By computerizing the existing method with this program, the degree of enlargement can easily be calculated and patients' treatment information can be entered into the printouts by using macro function. As a result, errors in calculation which may occur during the process of production or errors that the treatment information may be delivered wrongly can be reduced. In addition, with the simplification of the conversion process of the degree of enlargement, no copy machine was needed, which resulted in the reduction of use of paper. Conclusion: Works have been improved by computerizing the process of block production and applying it to practice which would simplify the existing method. This software can apply to and improve the actual conditions of each hospital in various ways using various features of EXCEL and VISUAL BASIC which has already been proven and used widely.

• The Korean Journal of Nuclear Medicine Technology
• /
• v.16 no.2
• /
• pp.156-161
• /
• 2012

Purpose : IRMA method for the experimental reagents, as set out in the manual settings for doing and reporting the test results should, in principle. But many of the reagents allows for the setting of the plot does not have a lot of information. Depending on the angle setting of the table make a difference in test results and what settings are best suited to investigate. Materials and Methods : The hospital has Boramae DREAM10, Cobra, SR-300's using the Immunotech TSH reagents have been compared with the measurements. Since then there using EXCEL calculation of the equipment compared with the measurement. Results : In the comparison between each piece of equipment 1.SR-300: DREAM 10 y = 1.1376x - 0.046 (LOG-LOGIT), 2.SR-300: COBRA y = 1.0985x + 0.042 (LOG-LOG) 3.DREAM10: COBRA y = 0.965x + 0.0887 (LOG-LOG) was the result. In all charts the same X, Y axis, X values were good in general when you have. Linear-Logit value of Cobra Dream10 and Excel tends to match the calculated values provided. Conclusion : Is to guide the B / max, B / Total Logit Y axis of the chart is set to draw a look at the value equation when the X-axis LOG a high concentration are disadvantages rising urgently toward the slope. Linear-Logit plots close to the straight line has a curve. If you have a chart to guide on setting AS setting and therefore, set to guide the absence of information on the need to set up the experiment are thought to pass through.

• Journal of the Korea Academia-Industrial cooperation Society
• /
• v.22 no.2
• /
• pp.104-112
• /
• 2021

For extrusion processes in the process industry, the need to build smart factories is increasing. However, in most extrusion production sites, the production method is continuous, and because the properties of the data are undeed, it is difficult to process the data. In order to solve this problem, we present a methodology utilizing a near field communication (NFC) sensor rather than water-based data entry. To this end, a wireless network environment was built, and a data management method was designed. A non-contact NFC method was studied for the production performance-data input method, and an analysis method was implemented using the pivot function of the Excel program. As a result, data input using NFC was automated, obtaining a quantitative effect from reducing the operator's data processing time. In addition, using the input data, we present a case where a bottleneck is improved due to quality problems.

• Proceedings of the Korean Society of Surveying, Geodesy, Photogrammetry, and Cartography Conference
• /
• 2003.10a
• /
• pp.211-218
• /
• 2003

The purpose of this study is to analyze the interior orientation, relative orientation, absolute orientation, space intersection, space resection, computing the orientation parameter, 3-dimensional coordinates by using the EXCE for educational purpose.