• Journal of The Korea Institute of Healthcare Architecture
• /
• v.26 no.2
• /
• pp.39-47
• /
• 2020

Purpose: Clinical laboratory of hospital has been demanded to extension or relocation regarding with the test number increase and analyzer development. Space area criteria per test numbers, lab functions, hospital bed and lab staffs are needed for draft space programing. So, the purpose of this study is to provide the space area guideline of clinical laboratory for space calculation in planning and design the spatial environment. Methods: Literature review has been used in checking the standards and guidelines. And questionnaire surveys to laboratory supervisors in hospitals have been conducted for the data collection. 60 answers have been analysed statistically by MS Excel program. Results: The result of this study can be summarized into three way calculations. The first one shows that the basic standard workspace and distance is applied in lab design. The second one shows that average space area criteria resulted from case studies is applied by 19㎡ per one staff, 0.9~1.0㎡ per one bed, and lastly linear length calculation of workbenches and analyzers on the bench top and floor mount, is multiplying it by the sum of the counter depth plus aisle width. Implications: In updating the space area calculation guidelines, it is necessary to cooperate with medical staffs and designers.

• Journal of Nutrition and Health
• /
• v.36 no.3
• /
• pp.319-326
• /
• 2003

The purposes of this study were to : (a) analyze the menus of food service operations using the menu analysis techniques of Kasavana & Smith, Miller, Merricks & Jones, Pavesic and Uman, (b) closely examine the characteristics of the five analysis techniques. Calculations for the menu analysis were done by computer using the MS 2000 Excel spreadsheet program. Menu mix% and unit contribution margin were used as variables by Kasavana & Smith, sales volume and food cost% by Miller, sales volume and cash contribution by Merrick & Jones, weighted contribution margin and food cost% by Pavesic, and total cash contribution and unit contribution margin by Uman. In each case, a four-cell matrix was created, and menu items were located in each according they achieved high or low scores with respect to two variables. Items that scored favorably on both variables were rated in the top category (e.g., star, prime, signature, group A, winner) and those that scored below average on both were rated in the lowest category (e.g., dog, problem, loser, group D, loser). While the 3 methods of Kasavana & Smith, Miller, Merrick & Jones focus on customers' viewpoints, the others consider the managers' viewpoints. Therefore, it is more likely to be desirable for decision-making on menus if the menu analysis technique chosen is suited to its purpose.

• Proceedings of the SAREK Conference
• /
• 2009.06a
• /
• pp.218-223
• /
• 2009

Cost related to building equipment accounts for about 85% of the life cycle cost of buildings. Therefore proper selection of air-conditioning system is important for reducing the overall cost of buildings. In this study, large capacity ice thermal storage and absorption chiller-heater for air-conditioning a building with a floor area of $9,900\;m^2$ are compared economically. For easy input and analysis, an Ms Excel VBA program has been developed. To consider all the factors of initial and operation costs effectively, an annual equal payment method is proposed. Under the assumptions made in this study, overall cost of an absorption chiller-heater is less than that of an ice thermal storage, but this is not absolute and different outcome may result if different assumptions are made. This study is useful for those who are interested in choosing an economical air-conditioning system for large-size buildings with simple calculations.

• Journal of Korean Society of Water and Wastewater
• /
• v.29 no.1
• /
• pp.123-131
• /
• 2015

A CCTV inspection method has been widely used to assess sewer condition and performance, but Korea lacks a proper decision support system for prioritizing sewer repair and rehabilitation (R&R). The objective of this paper is to introduce the results that we have developed in the Sewer Condition Assessment and Rehabilitation Decision-making (SCARD) Program using MS-EXCEL. The SCARD-Program is based on a standardized defect score for sewer structural and hydraulic assessment. Priorities are ranked based on risk scores, which are calculated by multiplying the sewer severity scores by the environmental impacts. This program is composed of three parts, which are decision-making for sewer condition and performance assessment, decision-making for sewer R&R priority assessment, and decision-making for optimal budget allocation. The SCARD-Program is useful for decision-makers, as it enables them to assess the sewer condition and to prioritize sewer R&R within the limited annual budget. In the future, this program logic will applied to the GIS-based sewer asset management system in local governments.

• Journal of Korean Society of Water and Wastewater
• /
• v.29 no.1
• /
• pp.97-106
• /
• 2015

A CCTV inspection method has been widely used to assess sewer condition and performance, but Korea lacks a proper decision support system for prioritizing sewer repair and rehabilitation (R&R). The objective of this paper is to introduce the results that we have developed in the Sewer Condition Assessment and Rehabilitation Decision-making (SCARD) Program using MS-EXCEL. The SCARD-Program is based on a standardized defect score for sewer structural and hydraulic assessment. Priorities are ranked based on risk scores, which are calculated by multiplying the sewer severity scores by the environmental impacts. This program is composed of three parts, which are decision-making for sewer condition and performance assessment, decision-making for sewer R&R priority assessment, and decision-making for optimal budget allocation. The SCARD-Program is useful for decision-makers, as it enables them to assess the sewer condition and to prioritize sewer R&R within the limited annual budget. In the future, this program logic will applied to the GIS-based sewer asset management system in local governments.

• Journal of The Korean Society of Agricultural Engineers
• /
• v.55 no.3
• /
• pp.105-111
• /
• 2013

Probability distribution of microbes in wastewater is a crucial factor to be determined for microbial risk assessment associated with its reuse. The objective of this study was to investigate probability distribution of an indicator microorganism in wastewater. Daily total coliform counts measured from nationwide wastewater treatment plants in 2010 by the Ministry of Environment were used for statistical analysis. Basic statistics and probability distributions were estimated in the three different spatial scales using the MS Excel software and FARD2006 model. Overall, wastewater from manure and livestock treatment plants demonstrated greater median coliform counts than from sewage and village treatment plants. Generalized logistic (GLO) and 2-parameter Weibull (WBU2) appeared to be the two probability distributions that fitted best for total coliform numbers in wastewater. The study results of microbial statistics and probability distributions would provide useful data for quantitative assessment of microbial risk from agricultural wastewater reuse.

• Journal of KIBIM
• /
• v.5 no.1
• /
• pp.1-7
• /
• 2015

Modular technology has become a major issue of the construction industries to enhance their productivity. Modular bridge construction generally requires the data exchange between the contractors, designers, fabricators and constructors. Therefore, a readily accessible information model interface module based on BIM technology is essential for their communication during a project life-cycle. In this study, BIM based information model interface module for a modular pier was developed. For the information models, the PBS(Product Breakdown Structure) and LOD(Level of Development) were defined. Next, all components of a modular pier were conducted by the parametric modeling technique, and then 3D cell library interface was developed. An nterface module was also developed using VBA(Visua basic Application) for exchanging a data from 3D model library to other softwares such as Microstation, AutoCad and Excel and was connected with MS Access database. The developed information model interface module would improve the design quality of the modular pier and reduce the time and cost for design. Updated 3D information models could be utilized for the fabrication, assembly, and construction process for modular piers.

• Journal of the Korean Dietetic Association
• /
• v.21 no.1
• /
• pp.72-82
• /
• 2015

The purpose of this study was to provide preliminary data for competitive dominance in an institutional foodservice environment. Data were collected from 85 experts and practitioners on customer-oriented service contact elements and contact fields in the foodservice industry. PASW Statistics ver.18 and MS Excel were used for data analysis. From the pilot study, 67 service contact-elements were derived. Contribution rate analysis and frequency analysis in each contact field were performed in order to categorize four factors, including environment-oriented contact, product-oriented contact, service-oriented contact, and image-oriented contact fields. Thirty three contact elements were derived, and environment-oriented contact consisted of eight contact-elements (cleanliness of restaurant/kitchen, etc.), product-oriented contact consisted of twelve contact-elements (food taste, etc.), service-oriented contact consisted of seven contact-elements (service quality, etc.), and image-oriented contact consisted of six contact-elements (image/reputation, etc.). The results of study will be useful to develop an effective marketing program for competitive dominance in an competitive foodservice industry environment.

• Journal of Industrial Technology
• /
• v.25 no.A
• /
• pp.57-65
• /
• 2005

In this paper, for the highly plastic marine soft clay distributed in west and southern coast of Korean peninsula of Kwangyang and Busan New Port areas, correlation between compression index and other indices representing geotechnical engineering properties such as liquid limit, void ratio and natural water content were analyzed. Appropriate empirical equations of being able to estimate the compressibility of clays in the specific areas were proposed and compared with other existing empirical ones. For analyses of the data and test results, data for marine clays were used from areas of the South Container Port of the Busan New Port, East Breakwater, Passenger Quay, Jungma Reclamation and Reclamation Containment in the 3rd stage in Kwangyang. In order to find the best regression model by using the commercially available software, MS EXCEL 2000, results obtained from the simple linear regression analysis, using the values of liquid limit, initial void ratio and natural water content as independent variables, were compared with the existing empirical equations. Multiple linear regression was also performed to find the best fit regression curves for compression index and other soil properties by combining those independent variables. On the other hands, another software of SPSS for non-linear regression was used to analyze the correlations between compression index and other soil properties.

• Korean Journal of Construction Engineering and Management
• /
• v.5 no.2 s.18
• /
• pp.144-152
• /
• 2004

Defining value as a measure of how well the project value objectives are met, Value Management Process (VMP) is considered to be any management effort or process that can proactively pursue one or more project objectives (i.e., security/safety, cost effectiveness, schedule optimization, and risk containment). The collection of 44 VMPs has been established based on a rigorous effort conducted by Construction Industry Institute (CII). Because varying circumstances on each project determine the level of suitability, it is crucial to identify which VMP should be implemented on a particular project. The current VMP selection process is primarily based on human intuition. The main objective of this paper is to provide a systematic method to facilitate the usage of VMPs on a particular project. This paper identified and quantified the selection principles (i.e., targeted value objectives, timing of initiation, project characteristics, and relative impact). The data collected from industry practitioners and VMP experts characterized each VMP in terms of the magnitude of benefit. An automated selection tool by Visual Basic Application (VBA) on MS Excel TM, was developed and proved its validity. As a pioneering study, this paper provides a comprehensive and structured knowledge on the subject of VMPs. From the industry's perspective, the automated selection tool, the premier of this study, contributes the facilitation of the VMP implementations in the construction industry thereby maximizing the potential benefits to a particular project.