250 APPENDIX G
LOADING THE
SPREADSHEETS
Before modifying the spreadsheets, they need to be loaded on
a local computer’s hard drive. This is done by inserting the disk
into the CD drive. If the Autorun starts the installation process,
the user must cancel the installation process by clicking on the
Cancel button, by clicking on the Yes button to confirm that
he wants to exit, and by clicking on the Finish button to exit
FIGURE G.10.WinEst Calculator.
the installation. The user then opens My Computer, right-
clicks on the CD drive, and selects Explore from the popup
menu to bring up the window shown in Figure G.11. The user
then copies the Excel Files folder to a local computer. The user
may now access these files from the local computer.
The table below contains the file name, description, and
figure reference for the spreadsheets from the CD. These
spreadsheets are provided as guides and may need to be
revised to meet specific needs.
File Name Description Figure
Bid-Tab.xls Subcontractor bid tabulation Figure G.12
Cut-Fill.xls Cut and fill worksheet Figure G.13
Est-Summary.xls Project estimate summary sheet Figure G.14
Rebar.xls Worksheet to calculate reinforcing bars Figure G.15
Recap.xls Estimate summary sheet Figure G.16
Slab-Rebar.xls Worksheet to calculate reinforcing bars in slabs Figure G.17
Steel.xls Worksheet for quantifying structural steel Figure G.18
Warehouse.xls Warehouse Model Figure G.19
Work-Sheet.xls Generic estimate work up sheet Figure G.20
Note:The highlighted cells contain formulas and do not require any input.