• 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 the Korea Academia-Industrial cooperation Society
• /
• v.5 no.1
• /
• pp.29-33
• /
• 2004

In this paper, I'm tying to define the connection of the Device Characteristics and the Error Terms, and yield maximum estimated value of the mismatching errors by modeling the individual devices with signal-flow graph, and by seeking the transfer function of the system with the mismatching error in the combination of the devices using the Signal-flow Graph Gain Formula.

• Journal of radiological science and technology
• /
• v.32 no.1
• /
• pp.39-43
• /
• 2009

The medical diagnostic examination using ionizing radiation has improved the patients' life and brought revolution in medical examination along with the mechanical development. However, the development of medical imaging systems has also been the reason to increase the patients' exposure for ionizing radiation. ICRP recommends that each country adopts diagnostic reference levels depending on regional and national situations. The Korea Food & Drug Administration suggested the dosimetry measurement guideline for patients in 2007. Nonetheless, in reality, it is hard to know the skin dose of the patients when applying a x-ray since there is no radiation dosimeter in most of clinical situation. Therefore, this study sets a program based on the bit system to figure out easily the skin dose of a patients using MS Excel program in the PC setting. The results showed 10% better outcome.

• Journal of the Korea Institute of Information and Communication Engineering
• /
• v.23 no.9
• /
• pp.1173-1178
• /
• 2019

In this paper, we design a security management application module for an Excel VBA password file. You will set a password for the important VBA program file. If this password is lost, you set a new password. If you forgot the password after setting the password in the Excel VBA file, you will not be able to change the VBA source code. In this paper, we design a function to modify VBA file passwords conveniently. The VBA password modification module extracts VBA files from Excel files. The password can be modified by modifying specific field information in the extracted VBA program file. This allows you to modify the password for the VBA program file. The experiments were performed by implementing the contents proposed in this paper. As a result of the experiment, we can confirm that the password can be used by modifying the VBA file password.

• School Mathematics
• /
• v.10 no.1
• /
• pp.1-22
• /
• 2008

The purpose of this study is to search the effective teaching-learning program by considering how affect on formation of linear function using Excel. This study was based on qualitative case study. The teaching experiment using Excel executed with five 8th graders' students for second research content. Teaching experiment was performed for two classes. Collecting the data was conducted via observations and interviews with students. The data include audio and video recording of the students' work, students' worksheets and detailed field notes. The conclusions drawn from teaching experiment are as follows: First, when students explored relevancy content of function in Excel environment, formation of concept of function was facilitated by experiencing operation of algebraic formulas, tables and graphs. We could infer that formation of concept was effected by conjecture activity and iterative process of feedback through Excel environment. Second, the students explored the changes very interestingly making algebraic formulas and presenting tables and graphs. The students were familiarized with observation on algebraic formulas, graphs and tables concurrently. Also, they tried to look for general rules through inductive observation. According to this study, we noticed that exploration teaming environment using Excel could supplement paper-and-pencil environment.

• The Korean Journal of Food And Nutrition
• /
• v.16 no.3
• /
• pp.180-186
• /
• 2003

In order to prediction of lethal effects on target microorganisms, this study was developed the program in the basis of Excel that was systemized with Visual Basic. This program was automatically calculated the lethal effects (L and Fo value) by using thermal characteristics (D and z value), kinetic model and mathematic model. For the selection of target microorganisms, we are selected two microorganisms because of spoilage increasing by acid production and decreasing quality of food, and heat resistance microorganisms. The target microorganisms were Bacillus cereus (D$_{121.1}$=0.0065 min, z=7.8$^{\circ}C$) and Bacillus subtilis (D$_{121.1}$=0.5 min, z =12$^{\circ}C$). The program was developed for the target microorganisms, and that was very useful for various microorganisms that direct introducing known D and z value.

• Research in Mathematical Education
• /
• v.7 no.4
• /
• pp.211-222
• /
• 2003

Recursive thinking is iterative, self-referential, and building on itself continuously. Moreover, it is becoming a more prominent feature of the mathematical scope because of the availability of computers and languages like Logo, Excel, and Pascal that support recursion. This study investigates the way to create students' recursive thinking in mathematics classroom and to use various methods to solve problems using a spreadsheet, the Excel program where technology could be accessible.

• Proceedings of the KIEE Conference
• /
• 2004.07d
• /
• pp.2480-2483
• /
• 2004

본 논문에서는 컴퓨터로 정밀 계측기기들을 자동 제어하고 데이터를 측정하기 위하여 기존의 상용 프로그램을 사용하지 않고 Excel VBA(Visual Basic for Applications)를 이용하는 방법에 대하여 연구하였다. 이는 반복측정 및 통계적 수치계산 등에서 많은 장점을 지니고 있어 수많은 국가교정기관 및 일반 산업체에서 유용하게 사용될 수 있으리라 사료된다.

• Proceedings of the KAIS Fall Conference
• /
• 2003.06a
• /
• pp.203-207
• /
• 2003

본 논문에서는 컴퓨터로 정밀 계측기 기들을 자동 제어하고 데이터？ 측정하기 위하여 기존의 상용 프로그램을 사용하지 않고 Extol VBA(Visual Basic for Applications)를 이용하는 방법에 대하여 연구하였다. 이는 반복측정 및 통계적 수치계산 둥에서 많은 장점을 지니고 있어 수많은 국가교정기관 및 일반 산업체에서 유용하게 사용될 수 있으리라 사료된다.

• 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.