• Title/Summary/Keyword: Spreadsheet

Search Result 170, Processing Time 0.025 seconds

A Study of Reliability of Predictive Models for Permanent Deformation and Fatigue Failure Related to Flexible Pavement Design (연성포장설계의 소성변형과 피로파괴 예측모델에 대한 신뢰성 연구)

  • Kim, Dowan;Han, Beomsoo;Kim, Yeonjoo;Mun, Sungho
    • International Journal of Highway Engineering
    • /
    • v.16 no.6
    • /
    • pp.105-113
    • /
    • 2014
  • PURPOSES: The objective of this paper is to select the confidential intervals by utilizing the second moment reliability index(Hasofer and Lind; 1974) related to the number of load applications to failure which explains the fatigue failure and rut depth that it indicates the permanent deformation. By using Finite Element Method (FEM) Program, we can easily confirm the rut depth and number of load repetitions without Pavement Design Procedures for generally designing pavement depths. METHODS : In this study, the predictive models for the rut depth and the number of load repetitions to fatigue failure were used for determining the second moment reliability index (${\beta}$). From the case study results using KICTPAVE, the results of the rut depth and the number of load repetitions to fatigue failure were deducted by calculating the empirical predictive equations. Also, the confidential intervals for rut depth and number of load repetitions were selected from the results of the predictive models. To determine the second moment reliability index, the spreadsheet method using Excel's Solver was used. RESULTS : From the case studies about pavement conditions, the results of stress, displacement and strain were different with depth conditions of layers and layer properties. In the clay soil conditions, the values of strain and stresses in the directly loaded sections are relatively greater than other conditions. It indicates that the second moment reliability index is small and confidential intervals for rut depth and the number of load applications are narrow when we apply the clay soil conditions comparing to the applications of other soil conditions. CONCLUSIONS : According to the results of the second moment reliability index and the confidential intervals, the minimum and maximum values of reliability index indicate approximately 1.79 at Case 9 and 2.19 at Case 22. The broadest widths of confidential intervals for rut depth and the number of load repetitions are respectively occurred in Case 9 and Case 7.

Determination of Risk Ranking of Combination of Potentially Hazardous Foods and Foodborne Pathogens Using a Risk Ranger (Risk Ranger를 활용한 잠재적 위해식품과 미생물 조합에 대한 위해순위 결정)

  • Min, Kyung-Jin;Hwang, In-Gyun;Lee, Soon-Ho;Cho, Joon-Il;Yoon, Ki-Sun
    • Journal of Food Hygiene and Safety
    • /
    • v.26 no.2
    • /
    • pp.91-99
    • /
    • 2011
  • Risk ranking must be determined for various hazards/food combinations to conduct microbial risk management effectively. Risk Ranger is a simple, easy-to-use calculation tool developed in Microsoft Excel and designed to rank the risk (low, medium, and high) for semi-quantitative microbial risk assessment. The user is required to answer 11 questions in Risk Ranger related to 1) severity of the hazard, 2) likelihood of a disease-causing dose of the hazard being present in the meal, and 3) the probability of exposure to the hazard in a defined time. This study determined the risk ranking for twenty three combinations of foodborne pathogens/potentially hazardous foods (PHFs) using a Risk Ranger. In this study, pathogenic E. coli in fresh cut produce salad was scored as 79, which was the highest rank among the 23 combinations of the foodborne pathogens and PHFs. On the other hand, zero risk was obtained with V parahaemolyticus in sushi, Salmonella in meat products and E. coli O157:H7 in hamburger patties. Although Risk Ranger is very simple method to rate the risk of foodborne pathogens and PHFs combination, the accuracy of result was mainly affected by the availability and accuracy of data in the literature. According to the result of literature review, the data are needed for contamination rate of raw materials, consumption amount/frequency of PHFs, and the effect of processing on pathogen. Risk ranking must be continuously revalidated with new data.

Development of an Automated Measurement System for Dilution Process and Spraying Amount of Disinfectant

  • Kim, Jung-Chul;Chung, Sun-Ok;Cho, Byoung-Kwan;Chang, Hong-Hee;Kim, Suk;Chang, Dongil
    • Journal of Biosystems Engineering
    • /
    • v.38 no.4
    • /
    • pp.228-239
    • /
    • 2013
  • Purpose: The objectives of this study were to develop an automated disinfectant dilution system, and an automated data management system for spraying amount for resolving uncertainty problem. Methods: Proper diluting rate was made by a controlled volume pump for liquid disinfectant and a screw conveyer pump for solid disinfectant. The water capacity of disinfecting system of 400 L was controlled by two water level sensors. The water quantity of water tank was controlled by the signals which were produced by the water level sensors. Signals were processed by Labview Programming, and ON/OFF of solenoid valve that was used for controlling water supplying to water tank, was controlled by SSR. The operating time of pumps for disinfectant was controlled quantitatively. A turbine flowmeter was used for development of automated measurement system for spraying amount of disinfectant. In order to save the flowmeter data and to control the spraying system, a multi-function data logger was used, and it was processed and saved in Excel file by a program developed in this study. Results: Labview 2010 was used for programming to control the automated measurement system for spraying amount of disinfectant. Results showed that the relationship between flowmeter value and time had a significant linear relationship such as 0.99 of $R^2$. Generally, 6.74 L/s of diluted disinfectant is sprayed for a vehicle passing through the disinfection system (about 15 seconds). Test results showed that average error between the measured spraying amount and the flowmeter data was 50 mL, and the range of error was 1.3%. Since the amount and time of spraying could be saved in real-time by using the spreadsheet files which could not be modified arbitrarily, it made possible to judge objectively whether the disinfection spraying was performed or not. Test results of spraying liquid and solid disinfectant showed that the errors between the measured discharge rate and the theoretical one were ranged within 3-4% for various dilution rates. Conclusions: The disinfection system developed would be working accurately. The automated spraying data base management system satisfied the purpose of this study. The automated dilution process system developed in this study could discharge liquid and solid disinfectant with accurate dilution rate, relatively.

Comparative Analysis of Influential Factors on Computer-Based Mathematics Assessment between Korea and Singapore (우리나라와 싱가포르의 컴퓨터 기반 수학 평가 결과에 대한 영향 요인 비교 분석)

  • Rim, Haemee;Jung, Hyekyun
    • Journal of Educational Research in Mathematics
    • /
    • v.27 no.2
    • /
    • pp.157-170
    • /
    • 2017
  • Mathematics was the main domain of PISA 2012, and both paper-based and computer-based assessment of mathematics (CBAM) were conducted. PISA 2012 was the first large-scale computer-based mathematics assessment in Korea, and it is meaningful in that it evaluated students' mathematical literacy in problem situations using dynamic geometry, graph, and spreadsheet. Although Korea ranked third in CBAM, the use of ICT in mathematics lessons appeared to be low. On the other hand, this study focused on Singapore, which ranked first in CBAM. The Singapore Ministry of Education developed online programs such as AlgeTools and AlgeDisc, and implemented the programs in classes by specifying them in mathematics curriculum and textbooks. Thus, this study investigated influential factors on computer-based assessment of mathematics by comparing the results of Korea and Singapore, and aimed to provide meaningful evidence on the direction of Korea's ICT-based mathematics education. The results showed that ICT use at home for school related tasks, attitudes towards computers as a tool for school learning, and openness and perseverance of problem solving were positively associated with computer-based mathematics performance, whereas the use of ICT in mathematics class by teacher demonstration was negatively related. Efforts are needed to improve computer use and enhance teaching techniques related to ICT use in Korean math classes. Future research is recommended to examine how effectively teachers use ICT in mathematics class in Singapore.

ANALYSIS OF THE TRANSPORTATION LOGISTICS FOR SPENT NUCLEAR FUEL IN KOREA

  • Lee, Hyo-Jik;Ko, Won-Il;Seo, Ki-Seok
    • Nuclear Engineering and Technology
    • /
    • v.42 no.5
    • /
    • pp.582-589
    • /
    • 2010
  • As a part of the back-end fuel cycle, transportation of spent nuclear fuel (SNF) from nuclear power plants (NPPs) to a fuel storage facility is very important in establishing a nuclear fuel cycle. In Korea, the accumulated amount of SNF in the NPP pools is troublesome since the temporary storage facilities at these NPP pools are expected to be full of SNF within ten years. Therefore, Korea cannot help but plan for the construction of an interim storage facility to solve this problem in the near future. Especially, a decision on several factors, such as where the interim storage facility should be located, how many casks a transport ship can carry at a time and how many casks are initially required, affect the configuration of the transportation system. In order to analyze the various possible candidate scenarios, we assumed four cases for the interim storage facility location, three cases for the load capacity that a transport ship can carry and two cases for the total amount of casks used for transportation. First, this study considered the currently accumulated amount of SNF in Korea, and the amount of SNF generated from NPPs until all NPPs are shut down. Then, how much SNF per year must be transported from the NPPs to an interim storage facility was calculated during an assumed transportation period. Second, 24 candidate transportation scenarios were constructed by a combination of the decision factors. To construct viable yearly transportation schedules for the selected 24 scenarios, we created a spreadsheet program named TranScenario, which was developed by using MS EXCEL. TranScenario can help schedulers input shipping routes and allocate transportation casks. Also, TranScenario provides information on the cask distribution in the NPPs and in the interim storage facility automatically, by displaying it in real time according to the shipping routes, cask types and cask numbers that the user generates. Once a yearly transportation schedule is established, TranScenario provides some statistical information, such as the voyage time, the availability of the interim storage facility, the number of transported casks sent from the NPPs, and the number of transported casks received at the interim storage facility. By using this information, users can verify and validate a yearly transportation schedule. In this way, the 24 candidate scenarios could be constructed easily. Finally, these 24 scenarios were compared in terms of their operation cost.

Development of an Approximate Cost Estimating Model for Bridge Construction Project using CBR Method (사례기반추론 기법을 이용한 교량 공사비 추론 모형 구축)

  • Kim, Min-Ji;Moon, Hyoun-Seok;Kang, Leen-Seok
    • Korean Journal of Construction Engineering and Management
    • /
    • v.14 no.3
    • /
    • pp.42-52
    • /
    • 2013
  • The aim of this study is to present a prediction model of construction cost for a bridge that has a high reliability using historical data from the planning phase based on a CBR (Case-Based Reasoning) method in order to overcome limitations of existing construction cost prediction methods, which is linearly estimated. To do this, a reasoning model of bridge construction cost by a spreadsheet template was suggested using complexly both CBR and GA (Genetic Algorithm). Besides, this study performed a case study to verify the suggested cost reasoning model for bridge construction projects. Measuring efficiency for a result of the case study was 8.69% on average. Since accuracy of the suggested prediction cost is relatively high compared to the other analysis methods for a prediction of construction cost, reliability of the suggested model was secured. In the case that information for detailed specifications of each bridge type in an initial design phase is difficult to be collected, the suggested model is able to predict the bridge construction cost within the minimized measuring efficiency with only the representative specifications for bridges as an improved correction method. Therefore, it is expected that the model will be used to estimate a reasonable construction cost for a bridge project.

A Design of the OOPP(Optimized Online Portfolio Platform) using Enterprise Competency Information (기업 직무 정보를 활용한 OOPP(Optimized Online Portfolio Platform)설계)

  • Jung, Bogeun;Park, Jinuk;Lee, ByungKwan
    • The Journal of Korea Institute of Information, Electronics, and Communication Technology
    • /
    • v.11 no.5
    • /
    • pp.493-506
    • /
    • 2018
  • This paper proposes the OOPP(Optimized Online Portfolio Platform) design for the job seekers to search for the job competency necessary for employment and to write and manage portfolio online efficiently. The OOPP consists of three modules. First, JDCM(Job Data Collection Module) stores the help-wanted advertisements of job information sites in a spreadsheet. Second, CSM(Competency Statistical Model) classifies core competencies for each job by text-mining the collected help-wanted ads. Third, OBBM(Optimize Browser Behavior Module) makes users to look up data rapidly by improving the processing speed of a browser. In addition, The OBBM consists of the PSES(Parallel Search Engine Sub-Module) optimizing the computation of a Search Engine and the OILS(Optimized Image Loading Sub-Module) optimizing the loading of image text, etc. The performance analysis of the CSM shows that there is little difference in accuracy between the CSM and the actual advertisement because its data accuracy is 99.4~100%. If Browser optimization is done by using the OBBM, working time is reduced by about 68.37%. Therefore, the OOPP makes users look up the analyzed result in the web page rapidly by analyzing the help-wanted ads. of job information sites accurately.

Status and Quality Analysis on the Biodiversity Data of East Asian Vascular Plants Mobilized through the Global Biodiversity Information Facility (GBIF) (세계생물다양성정보기구(GBIF)에 출판된 동아시아 관속식물 생물다양성 정보 현황과 자료품질 분석)

  • Chang, Chin-Sung;Kwon, Shin-Young;Kim, Hui
    • Journal of Korean Society of Forest Science
    • /
    • v.110 no.2
    • /
    • pp.179-188
    • /
    • 2021
  • Biodiversity informatics applies information technology methods in organizing, accessing, visualizing, and analyzing primary biodiversity data and quantitative data management through the scientific names of accepted names and synonyms. We reviewed the GBIF data published by China, Japan, Taiwan, and internal institutes, such as NIBR, NIE, and KNA of the Republic of Korea, and assessed data in diverse aspects of data quality using BRAHMS software. Most data from four Asian countries have quality problems with the lack of data consistency and missing information on georeferenced data, collectors, collection date, and place names (gazetteers) or other invalid data forms. The major problem is that biodiversity management institutions in East Asia are using unstructured databases and simple spreadsheet-type data. Owing to the nature of the biodiversity information, if data relationships are not structured, it would be impossible to secure the data integrity of scientific names, human names, geographical names, literature, and ecological information. For data quality, it is essential to build data integrity for database management and training systems for taxonomists who are continuous data managers to correct errors. Thus, publishers in East Asia play an essential role not only in using specialized software to manage biodiversity data but also in developing structured databases and ensuring their integration and value within biodiversity publishing platforms.

A Case Study on Application of the Menu Engineering Technique in Government Offices Contract Foodservice (관공서급식소의 메뉴엔지니어링기법을 적용한 메뉴분석 사례연구)

  • Rho, Sung-Yoon
    • Journal of Nutrition and Health
    • /
    • v.42 no.1
    • /
    • pp.78-96
    • /
    • 2009
  • The purpose of this study was to analyze and evaluate the menu served in government offices foodservice by using Kasavana & Smith's Menu-Engineering. Sales and food costs were collected from the daily sales reports for a year from Jan 2 to Dec 31 in 2007. Calculation for menu analysis and customer's data were done by computer using the MS 2003 Excel spreadsheet program and SPSS 12.0 package program. Menu mix% (MM%) and unit contribution margin were used as variables by Kasavana & Smith. Four possible classifications by Menu-Engineering technique were turned out as 'STAR', 'PLOWHORSE', 'PUZZLE', 'DOG'. The main menus served during a year were 128 dishes and about 141 peoples visited this restaurant daily. The mean age of the men was $44.1\;{\pm}\;6.3$, women were $32.7\;{\pm}\;6.4$ and showed that was statistically higher than that of women (p < .0001). The rates of STAR menus were 'Western style (75.0%)', 'guk/tang-ryu (48.1%)', 'jjigae/ jeongol-ryu (23.1%)', 'bap-ryu (17.2%)' in sequence. There were no STAR menus in gui/jorim/jjim-ryu. PLOWHORSE menus were 'gui-ryu (75.0%)', 'guk/tang-ryu (29.6%)', 'bap-ryu (27.6%)' in sequence. There were no PUZZLE or DOG menus in 'jjigae/jeongol-ryu'. PUZZLE menus were 'jorim/jjim-ryu and Myeonryu (each 33.3%)', 'bap-ryu (31.0%)' in sequence. PUZZLE menus were a lots of 'Chinese food (75.0%)' and 'myeonryu (55.6%)'. This study provides the basic data based on regularly menu analysis method applied the scientific menu analysis techniques in government offices food services, I'd like to suggest that the menu management must be done based on the necessity and result of menu analysis according to the seasonal and middle, long-term plans.

A Study of the Health Service Computerization State and the Occupational Nurses's Satisfaction Level on Computerization (산업간호현장의 보건업무 전산화시스템 활용현황과 산업간호사의 전산화 직무만족도 연구)

  • Jung, Hee Young;Park, Hyoung-Sook
    • Korean Journal of Occupational Health Nursing
    • /
    • v.13 no.1
    • /
    • pp.5-18
    • /
    • 2004
  • This study aims to investigate the use state of the health service computerization system in the occupational nursing field and the occupational nursers' satisfaction level, and provide basic data to promote the development of the health service computerization system for the nursing field. For this study, a questionnaire was provided to 118 occupational nurses who belong to Busan and Gyeongnam branches of KAOHN(Korean Association of Occupational Health Nurses) for 2 months (from Dec. 1, 2002 to Jan. 31, 2003). A tool of Choi Yong-Heui(2000) was used to investigate the satisfaction level of using the health service computerization system. The collected materials were analyzed in real number and percentage, average and standard deviation, t-test and ANOVA by using the SPSS WIN 10.0 program. This study is summarized as follows: 1. The average age was $31.99{\pm}5.58$ old in this study. The married were 54.2%. Participants who graduated from a junior college was 76.9%. The average service period was $4.48{\pm}4.68$ years. In service types, 79.7% of participants served in a health care center. The average service period was $3.22{\pm}2.89$ years. The service place which had 1000 workers or more was 35.6%. 2. Only 20.3% of participants in this study had a computer use education. 3. The field who participants used mostly was communication/internet, $3.29{\pm}.85$ hours in average. 4. 97.1% of occupational fields had computers and peripheral devices: 71.4% in pentium computer, 42.8% in the hard disk capacity of 20-29GB, 60.0% in 15 inch monitors, 86.2% in printers, 18.1% in digital cameras, 12.4% in LAN, and 9.5% in scanners. 80.1% of the occupational fields which were objects of study could use communication. 5. The occupational fields which did not introduced the health service computerization system were 62.8%. The main cause was attributable to entrepreneurs' insufficient recognition 66.6%. 51.5% of the entrepreneurs did not have an introduction plan. 37.2% of participating companies had the health service computerization system. 56.4% of them introduced it since the year 2000. 81.6% of the introduction motivation aimed to the efficiency of health service. The most issue upon introduction was insufficient understanding of a person in charge - 25.6%. The in-house development of the system covered 56.4%. 61.5% of the participants accepted their demands from the first stage of development. The direct effect of computerization showed the increase of 25.9% in the quickness and continuity of service treatment, and 25.9% in the serviceability of statistical treatment. 6. 22.0% of the participants had a computerization system use education. 69.2% of them had a in-house education. An educational method by nurses who used the computerization system was 76.9%. 92.3% of the education was helpful for practical duties. 7. An analysis of the computer use by health service fields showed that the medicine management in a health management field was 15.9%. the work environment measuring management in a work environment filed was 32.9%. the employment. general and special examination management in a heal th management field was 61.1 %. the various reports management in an administrative field was 64%. the health education data preparation management in an educational field was 58.0%. and the medicine and expendables management in an equipment management field was 51.6%. An analysis of the computerization system use showed that the various statistical data manage in a health management field was 13.0%. the work environment measuring management in a health management field was 34.8%. the personal disease management in a health management field was 51.9%. the heal education data preparation management in an educational field was 54.5%. and the equipment management of health care centers in an equipment management field was 52.6%. 8. 31.6% of the participants wanted that health service computerization system would include the generals of health services. 42.4% of the participants thought that first of all. the aggressive interest and investment of employers were required to build the health service computerization system. 9. The participants' satisfaction level on the computerization system use was $3.51{\pm}.57$ points. An analysis by each factor showed $3.62{\pm}.68$ points in a service change factor. $3.15{\pm}.63$ points in a computer program use factor, and $3.45{\pm}.71$ points in a continuous computerization use factor. 10. An analysis of the computerization system use by general characteristics of participants showed that the married (p = .022) had the satisfaction level higher than the unmarried. 11. The satisfaction level of the computerization system use by participants' computer use ability tended to be higher in proportion to the increase of computer use abilities in spreadsheet (F=2.606. p=.048). presentation (F=3.62. p=.012) and communication/internet(F=2.885. p=.0321. Based on the study results mentioned above. I will suggest as follows : The nationwide enlargement and repetition study is required for occupational nurses who serve in occupational nursing fields. The computerization system in a health service field is inferior comparing with other fields. The computerization system standard by business types and characteristics should be prepared through employers's aggressive participation and national support. Therefore various statistical data which occurs in occupational fields will be managed systematically and efficiently. A regular and systematic computer education plan for occupational nurses in charge of health services in the filed is urgently required to efficiently manage and improve the health of on-site workers.

  • PDF