GSA Hartford Courthouse Project - Draft Pricing Template - 2025-03-11.xlsx
XLSX spreadsheet 74 KB Posted
- Solicitation number
- 47PB5126R0013
- Issued by
- Not on record
About this file
This is a draft pricing template for the GSA Hartford Courthouse Project, structured using the Uniformat classification system for building cost estimation. The template is designed to capture elemental cost data for a new Hartford U.S. Courthouse with a maximum gross area of 281,000 square feet, organized by construction divisions including foundations, basement construction, superstructure, exterior enclosure, roofing, interior construction, stairs, interior finishes, conveying systems, plumbing, HVAC, fire protection/alarm systems, electrical systems, equipment, furnishings, special construction, selective demolition, and sitework.
The template provides line items for detailed cost breakdowns across all major building systems, with columns for quantities, unit rates, total costs, and cost per square foot calculations. Each division contains multiple subdivision categories with associated measurement units (square feet, linear feet, each, stories, flights, etc.) to accommodate various construction elements. The template includes a project cost summary section that rolls up direct costs, applies contingency, adds general conditions/profit/bond, and applies escalation to reach a base contract total. However, the current version contains formula errors (#REF! and #DIV/0!) indicating this is a preliminary draft requiring data population and formula reconciliation before use for actual pricing submissions in response to GSA Solicitation 47PB5126R0013.
View the file
Other files
Show all 26
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Project Cost Detail Uniformat
| PROJECT COST SUMMARY TEMPLATE DRAFT |
| HARTFORD US COURTHOUSE |
| Project: | New Hartford Courthouse | Gross Area (SF): | Date: | DRAFT | ||||||||
| Location: | Hartford, CT | |||||||||||
| Amount | Total Cost | Rate $/SF | % | Elemental Cost Data | ||||||||
| $ | $ | Gross Floor Area | Quantities | Unit | Notes | Unit Rate | ||||||
| A | 10 | FOUNDATIONS | $0 | ERROR:#REF! | 0.00 | ERROR:#DIV/0! | ||||||
| A1010 | Standard Foundations | ERROR:#REF! | ERROR:#REF! | SF | 1 | ERROR:#DIV/0! | ||||||
| A1020 | Special Foundations | ERROR:#REF! | ERROR:#REF! | SF | 1 | ERROR:#DIV/0! | ||||||
| A1030 | Slab On Grade | ERROR:#REF! | ERROR:#REF! | SF | 1 | ERROR:#DIV/0! | ||||||
| A | 20 | BASEMENT CONSTRUCTION | $0 | ERROR:#REF! | CY | 2 | ERROR:#DIV/0! | |||||
| A2010 | Basement Excavation | ERROR:#REF! | ERROR:#REF! | 0.00 | CY | 3 | ERROR:#DIV/0! | |||||
| A2020 | Basement Walls | ERROR:#REF! | ERROR:#REF! | SF | 4 | ERROR:#DIV/0! | ||||||
| B | 10 | SUPERSTRUCTURE | $0 | ERROR:#REF! | 0.00 | SF | 5 | ERROR:#DIV/0! | ||||
| B1010 | Floor Construction | ERROR:#REF! | ERROR:#REF! | SF | 6 | ERROR:#DIV/0! | ||||||
| B1020 | Roof Construction | ERROR:#REF! | ERROR:#REF! | SF | 7 | ERROR:#DIV/0! | ||||||
| B | 20 | EXTERIOR ENCLOSURE | $0 | ERROR:#REF! | SF | 8 | ERROR:#DIV/0! | |||||
| B2010 | Exterior Walls | ERROR:#REF! | ERROR:#REF! | SF | 8 | ERROR:#DIV/0! | ||||||
| B2020 | Exterior Windows | ERROR:#REF! | ERROR:#REF! | SF | 9 | ERROR:#DIV/0! | ||||||
| B2030 | Exterior Doors | ERROR:#REF! | ERROR:#REF! | EA | 10 | ERROR:#DIV/0! | ||||||
| B | 30 | ROOFING | $0 | ERROR:#REF! | SF | 11 | ERROR:#DIV/0! | |||||
| B3010 | Roof Coverings | ERROR:#REF! | ERROR:#REF! | SF | 11 | ERROR:#DIV/0! | ||||||
| C | 10 | INTERIOR CONSTRUCTION | $0 | ERROR:#REF! | SF | 12 | ERROR:#DIV/0! | |||||
| C1010 | Partitions | ERROR:#REF! | ERROR:#REF! | SF | 13 | ERROR:#DIV/0! | ||||||
| C1020 | Interior Doors | ERROR:#REF! | ERROR:#REF! | LEF | 14 | ERROR:#DIV/0! | ||||||
| C1030 | Fittings | ERROR:#REF! | ERROR:#REF! | SF | 12 | ERROR:#DIV/0! | ||||||
| C | 20 | STAIRS | $0 | ERROR:#REF! | FLT | 15 | ERROR:#DIV/0! | |||||
| C2010 | Stair Construction | ERROR:#REF! | ERROR:#REF! | FLT | 15 | ERROR:#DIV/0! | ||||||
| C2020 | Stair Finishes | ERROR:#REF! | ERROR:#REF! | SF | 16 | ERROR:#DIV/0! | ||||||
| C | 30 | INTERIOR FINISHES | $0 | ERROR:#REF! | SF | 17 | ERROR:#DIV/0! | |||||
| C3010 | Wall Finishes | ERROR:#REF! | ERROR:#REF! | SF | 18 | ERROR:#DIV/0! | ||||||
| C3020 | Floor Finishes | ERROR:#REF! | ERROR:#REF! | SF | 19 | ERROR:#DIV/0! | ||||||
| C3030 | Ceiling Finishes | ERROR:#REF! | ERROR:#REF! | SF | 20 | ERROR:#DIV/0! | ||||||
| D | 10 | CONVEYING | $0 | ERROR:#REF! | STY | 21 | ERROR:#DIV/0! | |||||
| D1010 | Elevators & Lifts | ERROR:#REF! | ERROR:#REF! | STP | 22 | ERROR:#DIV/0! | ||||||
| D1020 | Escalators & Moving Walks | ERROR:#REF! | ERROR:#REF! | 0.00 | LF | 23 | ERROR:#DIV/0! | |||||
| D1090 | Other Conveying Systems | ERROR:#REF! | ERROR:#REF! | EA | ERROR:#DIV/0! | |||||||
| D | 20 | PLUMBING | $0 | ERROR:#REF! | EA | 24 | ERROR:#DIV/0! | |||||
| D2010 | Plumbing Fixtures | ERROR:#REF! | ERROR:#REF! | EA | 24 | ERROR:#DIV/0! | ||||||
| D2020 | Domestic Water Distribution | ERROR:#REF! | ERROR:#REF! | EA | 24 | ERROR:#DIV/0! | ||||||
| D2030 | Sanitary Waste | ERROR:#REF! | ERROR:#REF! | EA | 24 | ERROR:#DIV/0! | ||||||
| D2040 | Rain Water Drainage | ERROR:#REF! | ERROR:#REF! | SF | 25 | ERROR:#DIV/0! | ||||||
| D2050 | Other Plumbing Systems | ERROR:#REF! | ERROR:#REF! | 1.00 | EA | 26 | 0 | |||||
| D | 30 | HVAC | $0 | ERROR:#REF! | MBH | 27 | ERROR:#DIV/0! | |||||
| D3010 | Energy Supply | ERROR:#REF! | ERROR:#REF! | MBH | 28 | ERROR:#DIV/0! | ||||||
| D3020 | Heat Generating Systems | ERROR:#REF! | ERROR:#REF! | MBH | 28 | ERROR:#DIV/0! | ||||||
| D3030 | Cooling Generating Systems | ERROR:#REF! | ERROR:#REF! | TON | 29 | ERROR:#DIV/0! | ||||||
| D3040 | Distribution Systems | ERROR:#REF! | ERROR:#REF! | MBH | 30 | ERROR:#DIV/0! | ||||||
| D3050 | Terminal and Package Units | ERROR:#REF! | ERROR:#REF! | MBH | 30 | ERROR:#DIV/0! | ||||||
| D3060 | Controls and Instrumentaion | ERROR:#REF! | ERROR:#REF! | MBH | 30 | ERROR:#DIV/0! | ||||||
| D3070 | Systems Testing and Balancing | ERROR:#REF! | ERROR:#REF! | MBH | 30 | ERROR:#DIV/0! | ||||||
| D3090 | Other HVAC Systems and Equipment | ERROR:#REF! | ERROR:#REF! | EA | 31 | ERROR:#DIV/0! | ||||||
| D | 40 | FIRE PROTECTION/ALARM | $0 | ERROR:#REF! | SF | 12 | ERROR:#DIV/0! | |||||
| D4010 | Fire Alarm & Detection Systems | ERROR:#REF! | ERROR:#REF! | SF | 12 | ERROR:#DIV/0! | ||||||
| D4020 | Fire Suppression Water Supply and Equipment | ERROR:#REF! | ERROR:#REF! | LF | 32 | ERROR:#DIV/0! | ||||||
| D4030 | Standpipe System | ERROR:#REF! | ERROR:#REF! | EA | 33 | ERROR:#DIV/0! | ||||||
| D4040 | Sprinklers | ERROR:#REF! | ERROR:#REF! | EA | 33 | ERROR:#DIV/0! | ||||||
| D4050 | Fire Protection Specialties | ERROR:#DIV/0! | ERROR:#REF! | EA | 34 | ERROR:#DIV/0! | ||||||
| D4090 | Other Fire Protection Systems | ERROR:#DIV/0! | ERROR:#REF! | EA | 35 | ERROR:#DIV/0! | ||||||
| D | 50 | ELECTRICAL | $0 | ERROR:#REF! | AMP | 12 | ERROR:#DIV/0! | |||||
| D5010 | Electrical Service & Distribution | ERROR:#REF! | ERROR:#REF! | AMP | 12 | ERROR:#DIV/0! | ||||||
| D5020 | Lighting & Branch Wiring | ERROR:#REF! | ERROR:#REF! | SF | 36 | ERROR:#DIV/0! | ||||||
| D5030 | Communications and Security | ERROR:#REF! | ERROR:#REF! | SF | 36 | ERROR:#DIV/0! | ||||||
| D5090 | Other Electrical Systems | ERROR:#REF! | ERROR:#REF! | SF | 12 | ERROR:#DIV/0! | ||||||
| E | 10 | EQUIPMENT | $0 | ERROR:#REF! | SF | 12 | ERROR:#DIV/0! | |||||
| E1010 | Commercial Equipment | ERROR:#REF! | ERROR:#REF! | SF | 36 | ERROR:#DIV/0! | ||||||
| E1020 | Institutional Equipment | ERROR:#REF! | ERROR:#REF! | SF | 36 | ERROR:#DIV/0! | ||||||
| E1030 | Vehicular Equipment | ERROR:#REF! | ERROR:#REF! | EA | 37 | ERROR:#DIV/0! | ||||||
| E1090 | Other Equipment | ERROR:#REF! | ERROR:#REF! | SF | 36 | ERROR:#DIV/0! | ||||||
| E | 20 | FURNISHINGS | $0 | ERROR:#REF! | SF | 36 | ERROR:#DIV/0! | |||||
| E2010 | Fixed Furnishings | ERROR:#REF! | ERROR:#REF! | SF | 36 | ERROR:#DIV/0! | ||||||
| E2020 | Moveable Furnishings | ERROR:#REF! | ERROR:#REF! | ERROR:#DIV/0! | ||||||||
| F | 10 | SPECIAL CONSTRUCTION | $0 | ERROR:#REF! | SF | 36 | ERROR:#DIV/0! | |||||
| F1010 | Special Structures | ERROR:#REF! | ERROR:#REF! | SF | 36 | ERROR:#DIV/0! | ||||||
| F1020 | Integrated Construction | ERROR:#REF! | ERROR:#REF! | SF | 36 | ERROR:#DIV/0! | ||||||
| F1030 | Special Construction Systems | ERROR:#REF! | ERROR:#REF! | SF | 38 | ERROR:#DIV/0! | ||||||
| F1040 | Special Facilities | ERROR:#REF! | ERROR:#REF! | SF | 38 | ERROR:#DIV/0! | ||||||
| F1050 | Special Controls and Instrumentation | ERROR:#REF! | ERROR:#REF! | XX | ERROR:#DIV/0! | |||||||
| F | 20 | SELECTIVE BUILDING DEMOLITION | $0 | ERROR:#REF! | SF | 42 | ERROR:#DIV/0! | |||||
| F2010 | Building Elements Demolition | ERROR:#REF! | ERROR:#REF! | SF | 42 | ERROR:#DIV/0! | ||||||
| F2020 | Hazardous Components Abatement | ERROR:#REF! | ERROR:#REF! | SF | 42 | ERROR:#DIV/0! | ||||||
| G | 10 | SITEWORK - BUILDING RELATED | $0 | ERROR:#REF! | ERROR:#DIV/0! | |||||||
| G1010 | Site Preparation | ERROR:#REF! | ERROR:#REF! | ACR | 39 | ERROR:#DIV/0! | ||||||
| G1020 | Site Improvements | ERROR:#REF! | ERROR:#REF! | SF | 43 | ERROR:#DIV/0! | ||||||
| G1030 | Site Civil/Mechanical Utilities | ERROR:#REF! | ERROR:#REF! | EA | 40 | ERROR:#DIV/0! | ||||||
| G1040 | Site Electrical Utilities | ERROR:#REF! | ERROR:#REF! | EA | 41 | ERROR:#DIV/0! | ||||||
| G | 20 | SITEWORK - NON-BUILDING RELATED | $0 | ERROR:#REF! | ERROR:#DIV/0! | |||||||
| G2010 | Site Preparation | ERROR:#REF! | ERROR:#REF! | ACR | 39 | ERROR:#DIV/0! | ||||||
| G2020 | Site Improvements | ERROR:#REF! | ERROR:#REF! | SF | 43 | ERROR:#DIV/0! | ||||||
| G2030 | Site Civil/Mechanical Utilities | ERROR:#REF! | ERROR:#REF! | EA | 40 | ERROR:#DIV/0! | ||||||
| G2040 | Site Electrical Utilities | ERROR:#REF! | ERROR:#REF! | EA | 41 | ERROR:#DIV/0! | ||||||
| G | 30 | OTHER SITE CONSTRUCTION | $0 | ERROR:#REF! | LS | ERROR:#DIV/0! | ||||||
| G3010 | Service and Pedestrian Tunnels | ERROR:#REF! | ERROR:#REF! | XX | ERROR:#DIV/0! | |||||||
| G3020 | Other Site Construction | ERROR:#REF! | ERROR:#REF! | XX | ERROR:#DIV/0! | |||||||
| DIRECT COST SUBTOTAL | $0 | ERROR:#REF! | ||||||||||
| CONTINGENCY (Based on subtotal) | ERROR:#REF! | ERROR:#REF! | ||||||||||
| SUBTOTAL | $0 | ERROR:#REF! | ERROR:#REF! | |||||||||
| GENERAL CONDITIONS, PROFIT, BOND | ERROR:#REF! | ERROR:#REF! | ||||||||||
| SUBTOTAL | $0 | ERROR:#REF! | ERROR:#REF! | |||||||||
| ESCALATION FROM | TO | ERROR:#REF! | ERROR:#REF! | |||||||||
| BASE CONTRACT TOTAL | $0 | ERROR:#REF! |
| Notes: | |||
| 1 | Footprint Area at Grade | 22 | Number of Stops |
| 2 | Volume of Excavation | 23 | Length of stairs or walks |
| 3 | Area of basement plan measured to outside of enclosing wall and average depth of finished grade to underside of slab on grade | 24 | Number of fixtures |
| 25 | Area of Roof | ||
| 26 | Number of Special fixtures, etc. | ||
| 4 | Area of Wall | 27 | Total MBH Capacity |
| 5 | Sum of area of supported floors and roof structure | 28 | Total power of heating system |
| 6 | Area of Supported Floors | 29 | Total Power of Cooling Capacity |
| 7 | Area of Supported Roof | 30 | Power |
| 8 | Area of Exterior Walls | 31 | Number of special mechanical systms |
| 9 | Area of Windows | 32 | Length of system |
| 10 | Number of Doors | 33 | Number of sprinkler heads |
| 11 | Gross Area of Roof | 34 | Number of extinguishers |
| 12 | Gross Floor Area | 35 | Each System |
| 13 | Area of Partitions | 36 | Floor Area |
| 14 | Number of Leaves | 37 | Pieces of Equipment |
| 15 | Number of Flights | 38 | Area of Room |
| 16 | Area of finished landings, treads, risers | 39 | Total Area of Site |
| 17 | Area of finishing | 40 | Each Utility |
| 18 | Area of Finished Walls | 41 | Systems Total |
| 19 | Area of Finished Floors | 42 | Square Foot of affected area |
| 20 | Area of Ceilings | 43 | Square Foot of improved area |
| 21 | Number of Stories |
File details come from the government source that posted it. Updated .