• Perspectives in Nursing Science
• /
• v.5 no.1
• /
• pp.45-58
• /
• 2008

The nursing informatics has been booming in Taiwan since 2003 when we started to use the end user computing strategy to promote it. We used Excel 2003, which was well known and used by our clinical nurses, as well as the embedded VBA to teach them how simple information applications could and should be built to meet their information management needs in order to support their professional responsibility. Many cost-effective projects were successfully done and the importance and potentials of nursing informatics started to be noticed. Our training strategy and materials are introduced in this paper.

• Bulletin of the Korean Chemical Society
• /
• v.16 no.10
• /
• pp.908-911
• /
• 1995

The EPR spectra of Cu-or Zr-doped BaTiO3 ceramics exhibited absorption signals with g∥=2.380 and g⊥=2.063 which are assigned to Ba1+(Ba2+ + e'→Ba1+) ion reduced by an electron that was produced from the oxygen vacancy (VO..). The intensity of these signals decreased as the temperature increased indicating that Ba1+ was changed to Ba2+ as the temperature increased. These ceramics also showed the EPR signal with g=1.997 around TC which arises from ionized Ba-vacancies, VBa'(VBa + e'→VBa'. In the orthorhombic and tetragonal phase region g=1.997 signal was not seen. The electrons generating from the oxidation of Ba1+ and ionized Ba-vacancies may contribute to a space charge which is responsible for a dielectric relaxation of these samples.

• Journal of the Architectural Institute of Korea Structure & Construction
• /
• v.34 no.12
• /
• pp.65-72
• /
• 2018

The purpose of this study is to predict vertical illuminance accurately at the design stage of a building without the help of simulation tools. Comparing two well-known vertical illuminance prediction algorithms with measured values, it is verified that the Igawa model is more consistent with the measured values than the Perez model. Using the DIVA program, we simulated the vertical illuminance at 30-degree intervals from south to north, compared with the vertical illuminance calculated with the Igawa model. The result of calculation values were verified from 120 degrees east to 120 degrees west. The vertical illuminance values with each of three shade devices were calculated using the Igawa model, and compared with the vertical illuminance simulated by DIVA program. As a result, all the errors when installing horizontal / vertical / grid shade divices were included in the error standard specified by ASHRAE.

• Korean Journal of Agricultural and Forest Meteorology
• /
• v.20 no.2
• /
• pp.228-232
• /
• 2018

Process-based crop models have been used to assess the impact of climate change on crop production. These models are implemented in procedural or object oriented computer programming languages including FORTRAN, C++, Delphi, Java, which have a stiff learning curve. The requirement for a high level of computer programming is one of barriers for efforts to develop and improve crop models based on biophysical process. In this study, we attempted to develop a Chinese cabbage model using Microsoft Excel with Visual Basic for Application (VBA), which would be easy enough for most agricultural scientists to develop a simple model for crop growth simulation. Results from Soil-Plant-Atmosphere-Research (SPAR) experiments under six temperature conditions were used to determine parameters of the Chinese cabbage model. During a plant growing season in SPAR chambers, numbers of leaves, leaf areas, growth rate of plants were measured six times. Leaf photosynthesis was also measured using LI-6400 Potable Photosynthesis System. Farquhar, von Caemmerer, and Berry (FvCB) model was used to simulate a leaf-level photosynthesis process. A sun/shade model was used to scale up to canopy-level photosynthesis. An Excel add-in, which is a small VBA program to assist crop modeling, was used to implement a Chinese cabbage model under the environment of Excel organizing all of equations into a single set of crop model. The model was able to simulate hourly changes in photosynthesis, growth rate, and other physiological variables using meteorological input data. Estimates and measurements of dry weight obtained from six SPAR chambers were linearly related ($R^2=0.985$). This result indicated that the Excel/VBA can be widely used for many crop scientists to develop crop models.

• Journal of the Korean Data and Information Science Society
• /
• v.16 no.3
• /
• pp.581-589
• /
• 2005

The purpose of this thesis is to develop and introduce Add-in program which we can systematically, visually and dynamically study discrete probability distribution of binomial distribution, poisson distribution and hypergeometric distribution, and continuous probability distribution of normal distribution, exponential distribution, and the definition and characteristics of t distribution, F distribution and ${\chi}^2$ distribution to be driven from normal distribution, and graphs, the computation process of probability by using VBA which is the device of Excel.

• Journal of the Korean Data and Information Science Society
• /
• v.16 no.2
• /
• pp.185-193
• /
• 2005

This study develops and introduces the program for letting learners study statistics in a systematic and efficient way by using Excel tools such as VBA and Macro, when they study statistical inference at two populations. This study helps learners understand the steps on statistical inference at two populations by utilizing the systematic and visual techniques.

• Polymer(Korea)
• /
• v.25 no.6
• /
• pp.782-788
• /
• 2001

The $[Ru(v-bpy)_3]^{2+}$ and vinylbenzoic acid (vba) were electrochemically copolymerized to afford electrodes modified with dopamine to study their properties such as electropolymerization rate, redox process, and electron transfer. The optimum mole ratio of the monomers was 5:2, which gave $1.84{ imes}10^{-2}s^{-1}$ of rate constant for first order reaction, while the ratio of the substances on the copolymeric film produced was 5:1.68. The formal potential produced from the hydroquinone=quinone+$2H^+2e^-$reaction at the electrode of GC/p- $[Ru(v-bpy)_3]^{2+}$/vba-dopamine was 0.17 V in phosphate buffer (pH=7.10). The electrocatalytic rate was $2.58{ imes}10^5cms^{-1}$;2.41 times faster than that of non-modified one. The mass change measured by EQCM was $3.28{ imes}10^3$$gmol^{-1}$ which is larger than that of non-modified one.

• 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 Society of Computer and Information
• /
• v.27 no.5
• /
• pp.149-156
• /
• 2022

Recently, there have been many reports of document-type malicious code injecting malicious code into Microsoft Office files. Document-type malicious code is often hidden by encoding the malicious code in the document. Therefore, document-type malware can easily bypass anti-virus programs. We found that malicious code was inserted into the Visual Basic for Applications (VBA) macro, a function supported by Microsoft Office. Malicious codes such as shellcodes that run external programs and URL-related codes that download files from external URLs were identified. We selected 354 keywords repeatedly appearing in malicious Microsoft Office files and defined the number of times each keyword appears in the body of the document as a feature. We performed machine learning with SVM, naïve Bayes, logistic regression, and random forest algorithms. As a result, each algorithm showed accuracies of 0.994, 0.659, 0.995, and 0.998, respectively.

• 한국정보통신설비학회:학술대회논문집
• /
• 2009.08a
• /
• pp.36-39
• /
• 2009

We developed an optimal design interface based on VBA(Visual Basic Application) that takes advantage of API(Application Program Interface) function of commonly used EM analysis software. The developed interface is adopted for an optimal design of a septum in a waveguide tee junction using PSO(Particle Swarm Optimization) algorithm. The objective function of the optimal design is defined by $S_{11}$-parameter of the waveguide tee junction Design variables are established as position of the septum, that are changed to satisfy the design goal Using the developed design interface and PSO algorithm, the objective function converged to the smallest value, showing the validity of the proposed method. The design interface was developed using Microsoft Excel software, enabling easy control of design parameters for user. Also, various analysis parameters can be set in the Excel interface, including waveguide input mode and frequency. After completion of the design, field solutions at user-specified positrons can be extracted to the output files in complex number form.