• 한국물환경학회지
• /
• 제26권2호
• /
• pp.297-302
• /
• 2010

It is very important to know mean and confidence interval of water-quality constituents such as BOD for water-quality control and management of rivers and reservoirs effectively. The mean and confidence interval of BOD at Anseong2 and Hwangguji3 sampling stations which are located at the border of local governments in Anseong Stream were estimated and analyzed in this paper using Bootstrap technique which is one of non-parametric statistics. The results of Bootstrap were compared with arithmetic mean, geometric mean, Biweight method mean as a point estimator and distribution mean came from the appropriate probability distribution of Log-normal. In Bootstrap technique 12 data set was randomly selected in each year and 1000 samples was produced to get parameter of population. Visual Basic for Applications (VBA) of Microsoft Excel was utilized in Bootstrap. It was revealed that the Bootstrap technique can be used to explain more rigorously and robustly the achievement or violation of BOD target concentration in Total Maximum Daily Load (TMDL).

• 한국조명전기설비학회:학술대회논문집
• /
• 한국조명전기설비학회 2007년도 춘계학술대회 논문집
• /
• pp.200-202
• /
• 2007

In recent years, equipment and network standards have been increasing in both number and complexity. Two standards that will soon be introduced to KOREA are the HV standards for assessing distorting and fluctuating loads, IEC 61000-3-6. Utility engineers, being under increasing time constraints, are turning more and more to software to quickly solve problems. This paper describes the methodology used to implement the above standards in Microsoft Excel in order to assist utility engineers to readily apply these standards in practical situations.

• Genomics & Informatics
• /
• 제11권1호
• /
• pp.55-57
• /
• 2013

Growing numbers of studies employ cell line-based systematic short interfering RNA (siRNA) screens to study gene functions and to identify drug targets. As multiple sources of variations that are unique to siRNA screens exist, there is a growing demand for a computational tool that generates normalized values and standardized scores. However, only a few tools have been available so far with limited usability. Here, we present siMacro, a fast and easy-to-use Microsoft Office Excel-based tool with a graphic user interface, designed to process single-condition or two-condition synthetic screen datasets. siMacro normalizes position and batch effects, censors outlier samples, and calculates Z-scores and robust Z-scores, with a spreadsheet output of >120,000 samples in under 1 minute.

• 한국건축시공학회:학술대회논문집
• /
• 한국건축시공학회 2012년도 춘계 학술논문 발표대회
• /
• pp.303-305
• /
• 2012

This paper presents a system called a Cash-flow based Construction Scheduling Optimization (CfSO). The existing CPM is biased on schedule and cost management. For a profitable and successful project management, the cash-flow which occurred actually by contractual conditions should be considered in the project scheduling. Therefore, this study provides a method to estimate the amount of a cash-flow occurred periodically by integrating the terms of contract into scheduling. The proposed methodology is implemented as a system prototype in Microsoft Excel. CfSO helps a site manager as a decision-maker to establish a optimized project scheduling and decide profitable contractual conditions against a construction owner.

• 한국수학교육학회지시리즈D:수학교육연구
• /
• 제9권3호
• /
• pp.187-201
• /
• 2005

The spreadsheet Microsoft Excel is the most widely used mathematical tool in today's workplace. Moreover, it is also an outstanding means for developing a surprisingly wide range of creative and innovative educational uses within such areas as mathematical modeling, visualization, and instruction. The spreadsheet's format provides us with a tool that closely parallels the way in which we naturally carry out problem solving, while the spreadsheet creation process itself illuminates the underlying mathematical concepts. In addition, the spreadsheet's visual layout allows us to introduce a broad variety of challenging and interesting topics, and to design creative demonstrations through eye-catching animated graphics. The material presented comes from actual classroom mathematics teaching experience in both industrially advanced and developing nations. A series of highly visual interactive illustrations from mathematics, the natural and social sciences, computing, engineering, and the arts provide a number of usable examples. The material discussed is applicable at diverse levels, ranging from schools and universities through adult education and in-service teacher development programs.

• 공학교육연구
• /
• 제11권4호
• /
• pp.58-63
• /
• 2008

본 논문은 중소도시의 전기 설비 및 전기공사 업체의 인력 수요와 채용과정 및 훈련기관의 교육 내용을 조사하였다. 그리고 학생의 취업 향상과 교육훈련과정개발을 위한 정보를 제공함에 목적이 있다. 인력수요 및 교육수요와 현장 실습생 수요에 대해 분석하였다. 표본추출은 업종별, 규모별 할당표본 추출방법(quota Sampling)을 사용하였다. 조사방법은 전화 및 방문하여 조사하였으며, 자료분석은 엑셀을 이용한 통계 분석을 하였다.

• Journal of Construction Engineering and Project Management
• /
• 제1권1호
• /
• pp.31-36
• /
• 2011

Construction materials usually constitute a major portion of the total cost in a building construction project. Materials management Is made problematic by materials shortages, delays in supply, price fluctuations, damage and wastage, and lack of storage space. Despite the potential benefit of ICT, convincing construction organisations to embrace its use and implementation has proved a difficult task. This study seeks to identify the implementation of ICT for materials management processes in construction projects. The findings from the case studies reveal that the implementation of ICT in the materials management processes for construction projects in Malaysia Is at early stage. Microsoft Excel Spreadsheet and handheld devices are found to be the common ICT tools adopted in the materials management processes. The main barrier is found to be the cost involvement at the initial stage or overall implementation of ICT in the materials management processes. Finally, this paper concludes the finding from interviews towards the ICT implementation of materials management in the construction projects.

• 한국농공학회논문집
• /
• 제51권2호
• /
• pp.43-49
• /
• 2009

Many researcher uses simulation techniques for understanding the phenomenon and expecting the response. Simulation techniques have many advantages which is less time-consuming, easy to control constraints, and cheaper than experimental study. However Researches usually are not good at programming the model, it's hard to implement simulation model using computer language. They use spreadsheet program like Microsoft $excel^{TM}$ Although a spreadsheet program is good for modeling, it's cumbersome to describe expressions which consist of not variable name but location indicator. This study suggests the program which helps researcher developing model using graphical interface and variable name. For verifying usability, the model which is implemented by developed modeler were compared with by spreadsheet program.

• Journal of international Conference on Electrical Machines and Systems
• /
• 제3권1호
• /
• pp.54-60
• /
• 2014

This paper shows a calculation method of several types of loss and the efficiency of brushless DC motors coupled with a load system by using a simple equivalent circuit, in which copper loss, eddy current loss, hysteresis loss, friction loss, viscous loss, and inverter loss are taken into account. We clarify each loss and motor efficiency at different motor speeds and different output torques by using the Microsoft-Excel. Moreover, the calculated results are in good agreement with the measured ones.

• 한국항해항만학회:학술대회논문집
• /
• 한국항해항만학회 2014년도 추계학술대회
• /
• pp.53-55
• /
• 2014

Offshore 에서의 oil & gas 생산은 해상이라는 환경으로 인한 고유의 특성 때문에 항상 다수의 변수들에 영향을 받으며, 막대한 비용이 소요되기 때문에 비용을 최소화하며, 비용 대비 수익을 최대화시키기 위한 optimal design이 필수이다. 본 논문은 가상의 offshore plant와 이에서 생산된 oil의 수요지들을 설정하여 시장수요에 따른 offshore 생산의 최적화 문제를 연구대상으로 하며, 다수의 offshore oil fields를 보유한 major oil company가 당면할 수 있는 offshore production에 관한 문제를 일반화하여 정의하고, 이윤을 극대화시킬 수 있는 최적화 모형을 혼합정수계획모형(mixed integer programming)으로 정식화 하였다. 최적화 모형의 해는 Microsoft office excel solver를 통해 구하였으며 그 계산실험의 결과를 요약하여 보고한다.