• Title/Summary/Keyword: Microsoft Excel

Search Result 176, Processing Time 0.028 seconds

Analysis of BOD Mean Concentration and Confidence Interval using Bootstrap Technique (Bootstrap 기법을 이용한 BOD 평균 농도 및 신뢰구간 분석)

  • Kim, Kyung Sub
    • Journal of Korean Society on Water Environment
    • /
    • v.26 no.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).

A Study on Development Program of Harmonic Emission Limit Assessment for Transmission System (송전계통 고조파 방출 한계 평가 프로그램 개발에 관한 연구)

  • Wang, Yong-Peel;Jeong, Jong-Won;Kim, Se-Dong;Kwak, No-Hong;Jeon, Young-Soo;Park, Sang-Ho
    • Proceedings of the Korean Institute of IIIuminating and Electrical Installation Engineers Conference
    • /
    • 2007.05a
    • /
    • 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.

  • PDF

siMacro: A Fast and Easy Data Processing Tool for Cell-Based Genomewide siRNA Screens

  • Singh, Nitin Kumar;Seo, Bo Yeun;Vidyasagar, Mathukumalli;White, Michael A.;Kim, Hyun Seok
    • Genomics & Informatics
    • /
    • v.11 no.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.

Optimizing a Construction Schedule Considering Cash-flow (현금 흐름을 고려한 건설일정 최적화에 관한 연구)

  • Lee, Hyung-Guk;Lim, Tae-Kyung;Son, Chang-Baek;Lee, Dong-Eun
    • Proceedings of the Korean Institute of Building Construction Conference
    • /
    • 2012.05a
    • /
    • 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.

  • PDF

Developing Mathematics Creativity with Spreadsheets

  • Deane Arganbright
    • Research in Mathematical Education
    • /
    • v.9 no.3 s.23
    • /
    • 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.

  • PDF

The Investigate of Human Strength Demand of Information Electrical the Kind of Occupation (정보전기 직종의 인력 수요에 대한 고찰)

  • Kim, Soo-Yong;Lee, Seung-Ho
    • Journal of Engineering Education Research
    • /
    • v.11 no.4
    • /
    • pp.58-63
    • /
    • 2008
  • This thesis investigated way of employment, education course of a training school of electrical company. And student more than. Faced a human power demand in an education demand and a field rehearsal student demand and and analyzed it. The sample extraction used industrial classification, work of scale, Assignment sample extraction way (quota Sampling). All data called at a silver phone and, and the investigated, The data parser analyzed the statistics that used Microsoft Excel.

ICT Implementation for Materials Management in Construction Projects: Case Studies

  • Kasim, Narimah
    • Journal of Construction Engineering and Project Management
    • /
    • v.1 no.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.

Development of a Graphical Modeler for Manipulating Series Data Based on Object-Oriented Technique (일련 자료 처리를 위한 시각적 객체 기반 모델러 개발)

  • Kim, Tae-Gon;Lee, Jeong-Jae
    • Journal of The Korean Society of Agricultural Engineers
    • /
    • v.51 no.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.

Simple Equivalent Circuit for Efficiency Calculation of Brushless DC Motors

  • Ishikawa, Takeo;Tsuji, Takuma;Hashimoto, Seiji;Kurita, Nobuyuki
    • Journal of international Conference on Electrical Machines and Systems
    • /
    • v.3 no.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.

Optimal design of offshore production considering market demand (시장 수요를 고려한 Offshore Production의 최적화 설계)

  • Kim, Chang-Su;Kim, Si-Hwa
    • Proceedings of the Korean Institute of Navigation and Port Research Conference
    • /
    • 2014.10a
    • /
    • 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를 통해 구하였으며 그 계산실험의 결과를 요약하여 보고한다.

  • PDF