Attachment 1 - Rate Table.xlsx

Instructions

If macros are disabled in your spreadsheet, select Tools, Macros, Security, and set security level to Medium. This will allow you to enable macros.

All data on the Enclosure Tabs comes from information entered into the Rate Table Tab. No data is to be entered directly into Enclosure Tab except for the Estimate Quantity and/or the Unit of Measure unless a special circumstance requires. The Unit Price will populate from corresponding data entered on the Rate Table Tab. This prevents errors in the price calculations resulting from users mistakenly changing cell values or formulas.

Cells which are colored light gray, are for user input. Please add zero "0" to all cells with no numerical value. Note - Not all light gray cells necessarily need to be filled in.

Filled cells such as this are not used. They are colored simply for clarity of the form.

The cells under Labor - Estimated Quantity are protected, with the exception of the gray (user input) Labor- Unit Price cells. The Esimated Quantity should remain protected at all times unless specific modifications are required. There is no password required to unlock the cells, but this could be changed by request and modification.

Some cells, or groups of cells, contain helpful information attached as a comment. Cells with comments, such as this one, contain a small red marker in the upper right corner. Just place your cursor in the cell to read the comment.

Lundquist, Christopher CIV MSC, N71: Lundquist, Christopher CIV MSC, N71:

Example Comment

The Contractor is required to fill in the information on the Rate Table Tab, including all applicable estimated quantities, unit prices and or unit of measure.

The cost tab pulls drawings and hours from each discipline to provide a summary for cost calculations.

Summary Sheet

TM-LH Rate Table

FFP Rate Table

Parts List