# An Excel Based Construction Estimate Format

Estimator's Personal Notebook is your personal construction cost estimating tool centered on an Excel based construction estimate format to prepare detailed construction cost estimates, to estimate construction material costs, to estimate construction labor costs, to establish construction cost control systems and to create unit price estimates. Estimator's Personal Notebook (EPN) is your online accessible, organized binder of construction cost estimating information to refer to while preparing construction cost estimates. Home building construction cost estimates, residential remodeling construction cost estimates and light commercial construction cost estimates are used as examples for simplicity sake but EPN's unique Excel based construction estimate format is so totally open and straightforward it can be modified or expanded to estimate any construction trade or discipline.

## Construction Cost Control Systems

Estimator's Personal Notebook's (EPN's) unique Excel based construction estimate format is the detailed construction cost estimate that is the basis of your bid. Later, the estimated construction material costs are used as your material buy list. Also, if the takeoffs are inputted by location, isolated material stocking lists are created. When the estimated construction labor costs are summed for activity and location they become your labor budgets. EPN will show how these construction cost control systems are derived directly from the detailed construction cost estimate.

## Unit Price Estimates

EPN's unique Excel based construction estimate format (or Pricing Model) is a detailed construction cost estimate that can generate fairly reliable unit price estimates when used to price projects with similar plans. Selected takeoffs for certain building components or assemblies are inputted into the Pricing Model to generate unit prices. The detailed construction cost estimate shown in this website for House 3240 took about 80 hours to complete. The unit price estimate shown in this website for House 2160 (using unit prices from House 3240) took about 16 hours to complete. With EPN's Excel based construction estimate format, you will have a construction cost estimating tool to generate unit prices so you may estimate projects with similar plans and save 80% of your time.

## EPN Documentation of Costs

EPN's Excel based construction estimate format (or Pricing Model) is straightforward, detailed and proven effective when used to assess cost impacts of plan changes. By inputting takeoffs with (-) negative values for work deleted and (+) values for work added, the resultant detailed lists of estimated construction material costs and estimated construction labor costs generated by the Pricing Model can be used to clearly document changes when negotiating cost proposals. This is especially useful when an Owner's change proposal format requires a detailed breakdown of materials and labor.

## EPN Modifications on the Spot

EPN's Excel based construction estimate format (or Pricing Model) is modifiable on the spot. Change any takeoff quantity, labor productivity, wage rate, material price, subcontractor amount, general condition amount, supervision rate or markup and your bid amount changes - immediately. You will be under less pressure closer to bid time when last minute price quotations come in or when in your final bid review, changes to labor productivity are decided. Change one or two cells in the Pricing Model and instantly you'll see the changed bid amount.