Industrial Process Plant Construction Estimating and Man-Hour Analysis

Kenneth Storm

• Publisher: Gulf Professional Publishing
• Year: 2019
• ISBN:
  9780128200223
• Topic: Technologie et ingénierie
• Subtopic: Ingénierie de la chimie et de la biochimie

Industrial Process Plant Construction Estimating and Man-Hour Analysis focuses on industrial process plants and enables the estimator to apply statistical applications, estimate data tables, and estimate sheets to use methods for collecting, organizing, summarizing, presenting, and analyzing historical man-hour data.

The book begins with an introduction devoted to labor, productivity measurement, collection of historical data, verification of data, estimating methods, and factors affecting construction labor productivity and impacts of data. It goes on to explore construction statistics and mathematical spreadsheets, followed by detailed scopes of work ranging from coal-fired power plants to oil refineries and solar plants, among others. Man-hour schedules based on historical data collected from past installations in industrial process plants are also included as well as a detailed glossary, Excel and mathematical formulas, area and volume formulas, metric/standard conversions, and boiler man-hour tables.

Industrial Process Plant Construction Estimating and Man-Hour Analysis aids industrial project managers, estimators, and engineers with the level of detail and practical utility for today's industrial operations and is an ideal resource for those involved in engineering, technology, or construction estimation.

• Identify quantity differences with the comparison method and eliminate impacts between proposed and previously installed equipment
• Understand how to implement statistical and estimating methods, scopes of work, man-hour tables and estimate sheets to produce direct craft man-hour estimates, RFPs, and field change orders
• Set up and utilize Excel templates to automate statistical functions that will perform mathematical applications key to process plant construction

Chapter 1

Introduction to construction statistics using Excel

Abstract

This section provides individuals in construction and engineering a basic understanding of how to set up and use Excel templates and spreadsheets. Excel is a powerful spreadsheet program that is used to perform mathematical and statistical calculations. The use of computer spreadsheets—specifically Microsoft Excel—demonstrates how templates and spreadsheets can be used to automate statistical functions. In addition, this section will provide an introduction to the basic operation of Excel. This includes how to set up Excel templates and spreadsheets, formatting spreadsheets, writing statistical and mathematical formulas, using the basic statistical functions, entering data, and printing results and graphs. The purpose of the following Excel statistical templates and spreadsheets is to make the connection to construction forecasting, learning curves, time series, work sampling, risk analysis, and bidding strategy.

Keywords

Statistics using Excel; Construction statistics; Excel templates; Basic statistical functions; Construction forecasting; Statistical formulas; Mathematical formulas

1.1 Section introduction—Introduction to construction statistics using Excel

This section provides individuals in construction and engineering a basic understanding of how to set up and use excel templates and spreadsheets. Excel is a powerful spreadsheet program that is used to perform mathematical and statistical calculations. The use of computer spreadsheets—specifically Microsoft Excel—demonstrates how templates and spreadsheets can be used to automate statistical functions. In addition, this section will provide an introduction to the basic operation of Excel. This includes how to set up Excel templates and spreadsheets, formatting spreadsheets, writing statistical and mathematical formulas, using the basic statistical functions, entering data, and printing results and graphs. The purpose of the following Excel statistical templates and spreadsheets is to make the connectio...