|
Construction Estimating Using Excel
|
Attention New York Engineers:
This course cannot be taken to fulfill your
continuing education requirements in the state of New York since the course does
not cover material from one of the core engineering disciplines.
For more information, check the
New
York State Board Requirements.
|
Robert Duane
Nickols, P.E.
Overview
This course is of particular interest anybody
involved with construction. Very little knowledge of Excel is needed. This
course covers many different spreadsheets needed to do a quantity take-off on
many different construction materials.
·
Concrete
·
Earthwork
·
Finishes
·
Masonry
·
Metals
·
Openings
·
Paving
·
Thermal & Moisture Protection
·
Wood
The take-off is performed
using many different units.
·
Cubic feet, cf, ft3, cu ft
·
Cubic yards, cu yd, yd3,
·
Feet, ft
·
Square feet, sf, ft2, sq ft
·
Tons
·
Pounds, lbs, #
·
Linear feet, lf
·
Square, sq
·
Foot board measure, fbm
·
Gallons, gal
We will use only a few commands, like border and fill color. We
will use only a few built-in functions like SUM and PRODUCT. I have included an
installation program that will install all the files covered in the course plus
some additional blank forms.
The
student must take a multiple-choice quiz consisting of ten (10)
questions at the end of the course to obtain PDH credits.
Specific Knowledge or Skill Attained
This course
teaches the following specific knowledge and skills
- How
to use built-in functions in Excel
- SUM
- PRODUCT
- Know
the order of precedence of arithmetic operators
- How
to apply a border and fill color to a cell
- Become
familiar with different construction material
- Become
familiar with different types of units used in construction
- Cubic
feet
- Cubic
yards
- Feet
- Square
feet
- Tons
- Pounds
- Linear
feet
- Square
- Foot
board measure
- gallons
- Know
how to convert some units, like cubic feet to cubic yards
- Become
familiar with the Master Format by CSI
- Know
how to specify a range of adjacent or non-adjacent cells in Excel
Course
Click on the link below to review the course
"Construction Estimating Using Excel" prior to taking a quiz for credit.
Construction
Estimating Using Excel (606 KB)
Excel
worksheets used in the course can be downloaded and installed on your hard drive
in the following manner:
1 -
RIGHT click the link below and select "Save Target As" (Internet
Explorer) or "Save Link As" (Firefox)
2 -
Save the file to your desktop
3 -
When completed, double click on the icon to install the files on your computer.
Worksheet
installation file for Construction Estimating Using Excel
Having Trouble Downloading the PDF File?
Right click on the link. Select "Save Target As..."
Then save on your desktop. To view the file, double click the icon on your
desktop and return to this page to take the quiz.
You may need Acrobat Reader to view this document.
Click on the link below to download a free copy of Acrobat Reader.
To obtain PDH credits for this course, you will need to take a quiz for
credit. Click on the link below.
(To take the quiz,
your web browser must be set to accept cookies. See how to
check your cookie settings.)
 
|
