{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Cover","Detail SC & HC"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":3,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Cover","index":0,"n_rows":41,"n_cols":2,"rows_kept":41,"cut":false,"hidden":false,"merged":[[40,0,41,2],[19,0,19,2],[20,0,20,2],[21,0,21,2],[22,0,22,2],[34,0,34,2],[28,0,28,2],[23,0,23,2],[5,0,5,2],[10,0,10,2],[3,0,3,2],[0,0,2,2],[11,0,11,2],[12,0,12,2],[13,0,13,2],[14,0,14,2],[15,0,15,2],[16,0,16,2],[17,0,17,2],[18,0,18,2]]}
["Detailed Project Budget"]
[]
[]
[]
[null,"*Packet must include Attachment A and Attachment B*"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Applicant"]
["City, County"]
["Project Title"]
["Name of Contact"]
["Date of Report"]
[]
[]
[]
["Total Project Cost:"]
[null,{"$f":"'Detail SC & HC'!D260","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Division of Public School Capital Construction Assistance – Colorado Department of Education – 1580 Logan St., #310 Denver, CO 80203 "]

{"sheet":"Detail SC & HC","index":1,"n_rows":262,"n_cols":8,"rows_kept":262,"cut":false,"hidden":false,"merged":[[252,0,252,1],[3,5,3,6],[124,0,124,5],[110,0,110,5],[99,0,99,5],[196,0,196,1],[5,0,5,7],[10,7,11,7],[9,0,9,7],[7,0,7,7],[6,0,6,7],[261,0,261,7],[259,3,259,6],[10,3,10,5],[10,6,11,6],[114,1,114,2],[58,1,58,2],[180,2,180,5],[140,0,140,5],[255,0,255,7],[250,0,250,5],[258,0,258,2],[258,3,258,6],[241,0,241,5],[194,0,194,5],[10,1,11,1],[10,2,11,2],[0,0,0,6],[257,0,257,2],[184,1,184,2],[256,3,256,6],[257,3,257,6],[4,5,4,6],[4,1,4,4],[13,0,13,7],[237,0,240,0],[234,0,235,0],[233,0,233,1],[56,0,56,5],[44,0,44,5],[8,0,8,7],[251,0,251,1],[253,0,253,5],[1,5,1,6],[2,5,2,6],[93,0,93,5],[182,0,182,7],[179,0,179,5],[151,0,151,5],[10,0,11,0],[1,1,1,4],[2,1,2,4],[3,1,3,4]]}
["\nTOTAL BUILDING COST MATRIX"]
["Applicant:",{"$f":"Cover!A16","v":"Applicant"},null,null,null,"Date of Report: ",null,{"$f":"Cover!A20","v":"Date of Report"}]
["City, County:",{"$f":"Cover!A17","v":"City, County"},null,null,null,"  Revision Date:"]
["Project Title:",{"$f":"Cover!A18","v":"Project Title"},null,null,null,"  Revision Date:"]
["Contact:",{"$f":"Cover!A19","v":"Name of Contact"},null,null,null,"Affected Sq. Ft.:"]
["- All cells in this spreadsheet with a green background can be filled in by the applicant."]
["- The Sugg. Responsible Party (A/E, GC, Owner) section demonstrates the firms the applicant typically obtains costs from for that line item."]
["- To insert a row click a cell in the green shaded area where you wish to insert the row, select Insert from the top menu, select rows."]
["- The applicant must include each cost associated with each item below that is budgeted for your project.  If a line item does not pertain to your project, type NA or leave blank.  "]
["- If the applicant is requesting more than 25% of the funding for this project to be provided by the State of Colorado, and if the project includes an HVAC system, and if the project is more than 5,000 sq. ft, and if the total project costs exceed 25% of the replacement value of the facility they must comply with SB07-51 (High Performance Certification Program) and the costs for implementing a HPCP project must be reflected in the budget."]
["Group Header","Category","Sub-Category","Sugg. Responsible Party",null,null,"Enter          Cost Here","Applicant Notes for CCA                             -enter in any clarifying statements here-"]
[null,null,null,"A/E ","GC ","Owner "]
[]
["SOFT COSTS"]
["Design/ Consulting Fees",null,null,null,null,null,null,"If cost exceeds recommended ranges, please indicate reason"]
[null,"Architectural/ Design Fees (Typ 7% - 9%)","Architectural",null,null,null,0]
[null,null,"Structural",null,null,null,0]
[null,null,"Mechanical",null,null,null,0]
[null,null,"Electrical",null,null,null,0]
[null,null,"Landscape Design",null,null,null,0]
[null,null,"Code and Accessibility Review",null,null,null,0]
[null,null,"Interiors",null,null,null,0]
[null,null,"Printing/ Reimbursables/ Mileage",null,null,null,0]
[null,"3D Modeling/ Computer Animation/ Model",null,null,null,null,0]
[null,"Acoustical Design",null,null,null,null,0]
[null,"Lighting Design",null,null,null,null,0]
[null,"Food Service Design",null,null,null,null,0]
[null,null,"Health Dept. Review",null,null,null,0]
[null,"Historical Reviews",null,null,null,null,0]
[null,"Civil Engineering",null,null,null,null,0]
[null,null,"Drainage Study",null,null,null,0]
[null,null,"Zoning ",null,null,null,0]
[null,null,"PUD",null,null,null,0]
[null,null,"Special Use Permit Costs",null,null,null,0]
[null,null,"Colorado Geological Survey",null,null,null,0]
[null,"Transportation Improvement Plan",null,null,null,null,0]
[null,"Traffic Study/Parking",null,null,null,null,0]
[null,"High Performance Energy Modeling",null,null,null,null,0]
[null,"High Performance Commissioning (CxA)",null,null,null,null,0]
[null,"LEED/CHPS Design & Coordination",null,null,null,null,0]
[null,"LEED/CHPS Certification",null,null,null,null,0]
[null,"Project Management/ Owners Representative (Typ 1% - 3%)",null,null,null,null,0]
[null,"Other:",null,null,null,null,0]
[null,"Other:",null,null,null,null,0]
["Design Fees Subtotal  ",null,null,null,null,null,{"$f":"SUM(G16:G44)","v":0}]
["City and Planning Fees",null,null,null,null,null,null,"If cost exceeds recommended ranges, please indicate reason"]
[null,"Preliminary Development Plan (PDP)",null,null,null,null,0]
[null,"Official Development Plan (ODP)",null,null,null,null,0]
[null,"Amendment to PDP of ODP",null,null,null,null,0]
[null,"Rezoning Fee (if applicable)",null,null,null,null,0]
[null,"Public Right-of-Way Easement Vacation",null,null,null,null,0]
[null,"Park Development Fees",null,null,null,null,0]
[null,"Street Excavation Permit",null,null,null,null,0]
[null,"Submittal Fees",null,null,null,null,0]
[null,"Other:",null,null,null,null,0]
[null,"Other:",null,null,null,null,0]
["City Planning Fees Subtotal  ",null,null,null,null,null,{"$f":"SUM(G47:G56)","v":0}]
["Utility and Development Costs"]
[null,"Water Tap and Development Review Assessments",null,null,null,null,0]
[null,null,"Well Permits (water)",null,null,null,0]
[null,null,"Fire Protection Water Tap",null,null,null,0]
[null,null,"Fire Hydrants",null,null,null,0]
[null,null,"Water Reserve for Fire Protection",null,null,null,0]
[null,null,"Water Tap Fees",null,null,null,0]
[null,null,"Existing Water Tap Credits",null,null,null,0]
[null,null,"Special Metro Districts",null,null,null,0]
[null,"Sanitary Sewer Review and Assessment",null,null,null,null,0]
[null,null,"Septic System/ Leach Fields",null,null,null,0]
[null,null,"Metro District",null,null,null,0]
[null,null,"County (as applicable)",null,null,null,0]
[null,null,"City ",null,null,null,0]
[null,null,"State (as applicable)",null,null,null,0]
[null,"Storm Sewer",null,null,null,null,0]
[null,"Utility Services",null,null,null,null,0]
[null,null,"Utility Extensions",null,null,null,0]
[null,null,"Gas",null,null,null,0]
[null,null,"Fuel Storage/ Propane/ Wood?",null,null,null,0]
[null,null,"Electric",null,null,null,0]
[null,null,"3 Phase Power",null,null,null,0]
[null,null,null,null,null,null,0]
[null,"Existing Solar Panel Removal & Reconnection",null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,"Phone  Cabling",null,null,null,null,0]
[null,"Cable Television Cabling",null,null,null,null,0]
[null,"City Traffic Impact Fee",null,null,null,null,0]
[null,"City Development Excise Tax",null,null,null,null,0]
[null,"Metro  District Fees",null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,"Street Lighting Fees",null,null,null,null,0]
[null,"Traffic Control Devices",null,null,null,null,0]
[null,"Extraordinary Offsite Utility Costs",null,null,null,null,0]
[null,"Other:",null,null,null,null,0]
[null,"Other:",null,null,null,null,0]
["Utility & Development Costs Subtotal",null,null,null,null,null,{"$f":"SUM(G59:G93)","v":0}]
["Site Survey and Soils Report"]
[null,"Site Survey",null,null,null,null,0]
[null,"Geo Technical Report",null,null,null,null,0]
[null,"Other:",null,null,null,null,0]
[null,"Other:",null,null,null,null,0]
["Site Survey and Soils Report Subtotal",null,null,null,null,null,{"$f":"SUM(G96:G99)","v":0}]
["Material Testing/ 3rd Party Inspections",null,null,null,null,null,null,"*Included but not limited to the noted below."]
[null,"Caisson Inspection",null,null,null,null,0]
[null,"Soils Compaction",null,null,null,null,0]
[null,"Rebar Inspection",null,null,null,null,0]
[null,"Concrete Testing",null,null,null,null,0]
[null,"Steel Welds & Bolted Connections",null,null,null,null,0]
[null,"Asphalt Testing",null,null,null,null,0]
[null,"Spray Fireproofing",null,null,null,null,0]
[null,"Other:",null,null,null,null,0]
[null,"Other:",null,null,null,null,0]
["Material Testing Subtotal  ",null,null,null,null,null,{"$f":"SUM(G102:G110)","v":0}]
["Environmental"]
[null,"ACM Abatement",null,null,null,null,0]
[null,null,"Block Filler",null,null,null,0]
[null,"Underground Tanks/Contaminated Soils",null,null,null,null,0]
[null,"Lead",null,null,null,null,0]
[null,"CFCs",null,null,null,null,0]
[null,"Storm Water Management",null,null,null,null,0]
[null,"State Demolition Permit",null,null,null,null,0]
[null,"State Fugitive Dust Permit",null,null,null,null,0]
[null,"Animal Removal/Relocation",null,null,null,null,0]
[null,null,"Endangered Species Act",null,null,null,0]
[null,"Other:",null,null,null,null,0]
[null,"Other:",null,null,null,null,0]
["Environmental/Hazmat/Testing Subtotal  ",null,null,null,null,null,{"$f":"SUM(G113:G124)","v":0}]
["Additional Costs",null,null,null,null,null,null,"* The owner is tax exempt"]
[null,"Builder's Risk Insurance (If by owner)",null,null,null,null,0]
[null,"Leasing Fees",null,null,null,null,0]
[null,null,"Rental costs during construction",null,null,null,0]
[null,"Legal Fees",null,null,null,null,0]
[null,"Finance Costs",null,null,null,null,0]
[null,"Moving & Relocating Costs",null,null,null,null,0]
[null,"Land Purchase",null,null,null,null,0]
[null,"Site Development",null,null,null,null,0]
[null,"Colo. Dept. of Transportation Costs",null,null,null,null,0]
[null,"Easement Dedications",null,null,null,null,0]
[null,"Construction Loan Interest",null,null,null,null,0]
[null,"Other: ",null,null,null,null,0]
[null,"Other: ",null,null,null,null,0]
[null,"Other: ",null,null,null,null,0]
["Additional Costs Subtotal  ",null,null,null,null,null,{"$f":"SUM(G127:G140)","v":0}]
["Building Systems Infrastructure (by owner)"]
[null,"Sound System/Audiovisual/TV-DVD",null,null,null,null,0]
[null,"Telecommunications",null,null,null,null,0]
[null,null,"Phone Systems Cabling ",null,null,null,0]
[null,null,"Data Systems Cabling",null,null,null,0]
[null,null,"Equipment",null,null,null,0]
[null,"Security Systems",null,null,null,null,0]
[null,"Fire Alarm System",null,null,null,null,0]
[null,"Other: ",null,null,null,null,0]
[null,"Other:",null,null,null,null,0]
["Building Systems Subtotal",null,null,null,null,null,{"$f":"SUM(G143:G151)","v":0}]
["Furniture/ Fixtures and Equipment",null,null,null,null,null,null,"*Items may or may not be included with the grant application, to be reviewed."]
[null,"Window Coverings",null,null,null,null,0]
[null,"Parking Lot Signage",null,null,null,null,0]
[null,"Permanent Interior Signage",null,null,null,null,0]
[null,null,"Interior Plaque ",null,null,null,0]
[null,"Permanent Exterior Signage",null,null,null,null,0]
[null,null,"Monument Signage",null,null,null,0]
[null,"Technology",null,null,null,null,0]
[null,null,"Computers/Laptops/Tablets",null,null,null,0]
[null,null,"Projection Equipment",null,null,null,0]
[null,null,"Smart boards, LED Touch Screens, Etc.",null,null,null,0]
[null,"School Desks/ Tables/ Chairs",null,null,null,null,0]
[null,"Cafeteria Chairs and Tables",null,null,null,null,0]
[null,"Office Furniture",null,null,null,null,0]
[null,"Office Equipment",null,null,null,null,0]
[null,"Display Cases",null,null,null,null,0]
[null,"Marker & Tack Boards",null,null,null,null,0]
[null,"Foodservice Equipment",null,null,null,null,0]
[null,"Indoor Sports Equipment",null,null,null,null,0]
[null,null,"Bleachers",null,null,null,0]
[null,null,"Scoreboards",null,null,null,0]
[null,"Site Furnishings ",null,null,null,null,0]
[null,null,"Site Furniture",null,null,null,0]
[null,null,"Outdoor Sports Equipment",null,null,null,0]
[null,null,"Playground Equipment",null,null,null,0]
[null,"Other:",null,null,null,null,0]
[null,"Other:",null,null,null,null,0]
["Project Furniture/ Fixtures and Equipment Subtotal",null,null,null,null,null,{"$f":"SUM(G154:G179)","v":0}]
[null,null,"SOFT COST TOTAL  ",null,null,null,{"$f":"+G180+G152+G141+G125+G111+G100+G94+G57+G45","v":0}]
[]
[" HARD COST"]
["Permits, Taxes, Bonds",null,null,null,null,null,null,"*Public School Facilities are tax exempt"]
[null,"Building, Mechanical, Plumbing, Electrical Permit Fees",null,null,null,null,0]
[null,"Plan Review Fee (State)",null,null,null,null,0]
[null,"Fire Department Review Fee",null,null,null,null,0]
[null,"State Inspections by 3rd Party",null,null,null,null,0]
[null,"Storm Water Permit Fees",null,null,null,null,0]
[null,"Land Disturbance Fee",null,null,null,null,0]
[null,"Other:",null,null,null,null,0]
[null,"Other:",null,null,null,null,0]
[null,"Other:",null,null,null,null,0]
[null,"Other:",null,null,null,null,0]
["Permits, Taxes, Bonds Subtotal",null,null,null,null,null,{"$f":"SUM(G185:G194)","v":0}]
["Building Construction Cost"]
["Direct Cost of Work by Division",null,"Cost per SF",null,null,null,"Totals","If cost exceeds recommended ranges, please indicate reason"]
["Division 00","Procurement and Contracting Requirements",{"$f":"SUM(G198/H$5)","v":{"$error":"#DIV/0!"}},null,null,null,0]
["Division 1","General Requirements",{"$f":"SUM(G199/H$5)","v":{"$error":"#DIV/0!"}},null,null,null,0]
["Division 2","Existing Conditions",{"$f":"SUM(G200/H$5)","v":{"$error":"#DIV/0!"}},null,null,null,0]
["Division 3","Concrete",{"$error":"#DIV/0!"},null,null,null,0]
["Division 4","Masonry",{"$error":"#DIV/0!"},null,null,null,0]
["Division 5","Metals",{"$error":"#DIV/0!"},null,null,null,0]
["Division 6","Woods, Plastics & Composites",{"$error":"#DIV/0!"},null,null,null,0]
["Division 7","Thermal and Moisture Protection",{"$error":"#DIV/0!"},null,null,null,0]
["Division 8","Openings",{"$error":"#DIV/0!"},null,null,null,0]
["Division 9","Finishes",{"$error":"#DIV/0!"},null,null,null,0]
["Division 10","Specialties",{"$error":"#DIV/0!"},null,null,null,0]
["Division 11","Equipment",{"$error":"#DIV/0!"},null,null,null,0]
["Division 12","Furnishings",{"$error":"#DIV/0!"},null,null,null,0]
["Division 13","Special Construction",{"$error":"#DIV/0!"},null,null,null,0]
["Division 14","Conveying Systems",{"$error":"#DIV/0!"},null,null,null,0]
["Division 21","Fire Supression",{"$error":"#DIV/0!"},null,null,null,0]
["Division 22","Plumbing",{"$error":"#DIV/0!"},null,null,null,0]
["Division 23","Heating, Ventating, and Air Conditioning (HVAC)",{"$error":"#DIV/0!"},null,null,null,0]
["Division 25","Integrated Automation",{"$error":"#DIV/0!"},null,null,null,0]
["Division 26","Electrical",{"$error":"#DIV/0!"},null,null,null,0]
["Division 27","Communications",{"$error":"#DIV/0!"},null,null,null,0]
["Division 28","Electronic Safety and Security",{"$error":"#DIV/0!"},null,null,null,0]
["Division 31","Earthwork",{"$error":"#DIV/0!"},null,null,null,0]
["Division 32","Exterior Improvements",{"$error":"#DIV/0!"},null,null,null,0]
["Division 33","Utilities",{"$error":"#DIV/0!"},null,null,null,0]
["Division 34","Transportation",{"$error":"#DIV/0!"},null,null,null,0]
["Division 35","Waterway and Marine Construction",{"$error":"#DIV/0!"},null,null,null,0]
["Division 40","Process Integration",{"$error":"#DIV/0!"},null,null,null,0]
["Division 41","Materials Processing and Handling Equipment",{"$error":"#DIV/0!"},null,null,null,0]
["Division 42","Process Heating, Cooling, and Drying Equipment",{"$error":"#DIV/0!"},null,null,null,0]
["Division 43","Process Gas and Liquid Handling, Purification and Storage Equipment",{"$error":"#DIV/0!"},null,null,null,0]
["Division 44","Polution and Waste Control Equipment",{"$error":"#DIV/0!"},null,null,null,0]
["Division 45","Industry-Specific Manufacturing Equipment",{"$error":"#DIV/0!"},null,null,null,0]
["Division 46","Water and Wastewater Equipment",{"$error":"#DIV/0!"},null,null,null,0]
["Division 48","Electrical Power Generation",{"$error":"#DIV/0!"},null,null,null,0]
["Single Scope","Lump Sum Bid (use if no divisions provided)",{"$error":"#DIV/0!"},null,null,null,0]
["Subtotal for Direct Cost of Work",null,{"$f":"SUM(C199:C232)","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"SUM(G198:G233)","v":0}]
["Contingencies in Estimate","Escalation Contingency (Typ 3% - 6%) ",0,null,null,null,{"$f":"SUM(G234*C235)","v":0}]
[null,"Construction Contingency (Typ 3% - 6%)",0,null,null,null,{"$f":"SUM(G234*C236)","v":0}]
[null,"Subtotal for Direct and Indirect Cost of Work",{"$f":"SUM(G237/H5)","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"SUM(G234:G236)","v":0}]
["Fees, Insurance, and Bonds","General Liability Insurance (Typ 1%) ",0,null,null,null,{"$f":"SUM(G237*C238)","v":0}]
[null,"Builder's Risk Insurance (Typ 0.10% - 0.20%)",0,null,null,null,{"$f":"SUM(G237*C239)","v":0}]
[null,"Fees for Overhead and Profit (2% - 4%)",0,null,null,null,{"$f":"SUM(G237*C240)","v":0}]
[null,"Performance and Payment Bonds (0.65% - 1%)",0,null,null,null,{"$f":"SUM(G237*C241)","v":0}]
["Building Construction Costs Subtotal",null,null,null,null,null,{"$f":"SUM(G237:G241)","v":0}]
["Other Costs Not Listed Above","Please list:"]
[null,"1)",null,null,null,null,0]
[null,"2)",null,null,null,null,0]
[null,"3)",null,null,null,null,0]
[null,"4)",null,null,null,null,0]
[null,"5)",null,null,null,null,0]
[null,"6)",null,null,null,null,0]
[null,"7)",null,null,null,null,0]
["Other Hard Costs Subtotal",null,null,null,null,null,{"$f":"SUM(G244:G250)","v":0}]
["HARD COST SUBTOTAL",null,{"$f":"SUM(G252/H5)","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"G195+G242+G251","v":0}]
["OWNER'S CONTINGENCY (Typ 3% - 6%)",null,0,null,null,null,{"$f":"SUM(G252*C253)","v":0}]
["HARD COST TOTAL  ",null,null,null,null,null,{"$f":"G252+G253","v":0}]
[]
["PROJECT SUMMARY"]
[null,null,null,"Cost Totals",null,null,null,"Cost Per Sq. Ft."]
["Soft Cost Total",null,null,{"$f":"G181","v":0},null,null,null,{"$f":"D258/H5","v":{"$error":"#DIV/0!"}}]
["Hard Cost Total",null,null,{"$f":"G254","v":0},null,null,null,{"$f":"D259/H5","v":{"$error":"#DIV/0!"}}]
[null,null,"(Enter this amount in Application Sect. III Question C. \"Project Cost\") TOTAL PROJECT COST  ",{"$f":"+D258+D259","v":0},null,null,null,{"$f":"D260/H5","v":{"$error":"#DIV/0!"}}]
[]
["For GAINS Budget \"BGA - BEST Grant Amount\": Refer to calculated value in Application Sect. III Question E \"Requested BEST Grant Amount\")"]