{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Bid Template REVISED"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":1,"comments":0,"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":"Bid Template REVISED","index":0,"n_rows":205,"n_cols":5,"rows_kept":205,"cut":false,"hidden":false,"merged":[[203,1,203,2],[194,1,194,2],[30,1,30,2],[36,1,36,2],[83,1,83,2],[108,1,108,2],[183,1,183,2],[191,1,191,2],[176,1,176,2],[180,1,180,2],[167,1,167,2],[173,1,173,2],[4,3,4,4],[197,1,197,2],[200,1,200,2],[149,1,149,2],[156,1,156,2],[146,1,146,2],[159,1,159,2],[164,1,164,2],[128,1,128,2],[133,1,133,2],[136,1,136,2],[140,1,140,2],[143,1,143,2],[93,1,93,2],[105,1,105,2],[112,1,112,2],[115,1,115,2],[125,1,125,2],[70,1,70,2],[74,1,74,2],[77,1,77,2],[86,1,86,2],[90,1,90,2],[28,1,28,2],[39,1,39,2],[61,1,61,2],[64,1,64,2],[67,1,67,2],[8,1,8,2],[27,1,27,2],[0,3,0,4],[2,1,2,2],[3,1,3,2],[2,3,2,4],[0,1,0,2]]}
[null,"CONSTRUCTION BID FORM",null,"BKA Proj #  225106"]
[]
[null,"BGR - The Halal Guys - Warwick, RI",null,"Bid Due Date:  Friday, Oct 10th, 5pm"]
[null,"1727 Post Road, Warwick, RI"]
[null,null,null,"New England Construction"]
[null," ",null,"CONSTRUCTION","COST ANALYSIS"]
[null,"DIVISION",null,"BID","COST / GSF"]
[]
[null,"EXECUTIVE SUMMARY"]
[null,null,"DIVISION 00 - FEES",{"$f":"D37","v":58815},{"$f":"E37","v":0}]
[null,null,"DIVISION 01 - GENERAL CONDITIONS",121250,{"$f":"E62","v":0}]
[null,null,"DIVISION 02 - EXISTING CONDITIONS",{"$f":"D68","v":12250},{"$f":"E68","v":0.35362720475736842}]
[null,null,"DIVISION 03 - CONCRETE",{"$f":"D75","v":19070},{"$f":"E75","v":0}]
[null,null,"DIVISION 05 - METALS",{"$f":"D84","v":46432},{"$f":"E84","v":0}]
[null,null,"DIVISION 06 - WOODS, PLASTICS & COMPOSITES",{"$f":"D91","v":7373},{"$f":"E91","v":0}]
[null,null,"DIVISION 07 - THERMAL MOISTURE PROTECTION",{"$f":"D106","v":26000},{"$f":"E106","v":0}]
[null,null,"DIVISION 08 - OPENINGS",{"$f":"D113","v":8743},{"$f":"E113","v":0}]
[null,null,"DIVISION 09 - FINISHES",{"$f":"D126","v":120391},{"$f":"E126","v":0}]
[null,null,"DIVISION 10 - SPECIALTIES",{"$f":"D134","v":2675},{"$f":"E134","v":0}]
[null,null,"DIVISION 11 - EQUIPMENT",{"$f":"D141","v":54620},{"$f":"E141","v":0}]
[null,null,"DIVISION 12 - FURNISHINGS ",{"$f":"D147","v":0},{"$f":"E147","v":0}]
[null,null,"DIVISION 22 - PLUMBING",{"$f":"D157","v":105420},{"$f":"E157","v":0}]
[null,null,"DIVISION 23 - HVAC",{"$f":"D165","v":119900},{"$f":"E165","v":0}]
[null,null,"DIVISION 26 - ELECTRICAL",{"$f":"D174","v":103000},{"$f":"E174","v":0}]
[null,null,"DIVISION 28 - ELECTRONIC SAFETY & SECURITY",{"$f":"D181","v":14875},{"$f":"E181","v":0}]
[null,null,"DIVISION 31 - UTILITIES",{"$f":"D192","v":0},{"$f":"E192","v":0}]
[]
[null,"CONSTRUCTION REPORT TOTAL",null,{"$f":"SUM(D10:D27)","v":820814},{"$f":"SUM(E10:E27)","v":0.35362720475736842}]
[null," ",null," "]
[]
[null,"DIVISION 0 - FEES"]
[null,null,"Contractor Fee + Overhead",46461,0]
[null,null,"Insurance",12312,0]
[null,null,"Sub guard Insurance ",0,0]
[null,null,"Tax",42,0]
[]
[null,{"$f":"B31&\" TOTAL\"","v":"DIVISION 0 - FEES TOTAL"},null,{"$f":"SUM(D32:D36)","v":58815},{"$f":"SUM(E32:E36)","v":0}]
[]
[]
[null,{"$f":"$C$11","v":"DIVISION 01 - GENERAL CONDITIONS"}]
[null,null,"General Conditions - Lump Sum",0,0]
[null,null,"Project Manager",22425,0]
[null,null,"Assistant Project Manager (if applicable)",12750,0]
[null,null,"Site Management - Superintendent",69000,0]
[null,null,"Site Management - Asst. Superintendent  (if applicable)","N/A",0]
[null,null,"Site Labor","N/A",0]
[null,null,"Temporary Storage","N/A",0]
[null,null,"Dumpsters",4950,0]
[null,null,"Scaffolding","N/A",0]
[null,null,"Temporary Utilities",3725,0]
[null,null,"Construction Facilities  - Site Office",3250,0]
[null,null,"Site Maintenance and Protection","N/A",0]
[null,null,"Mileage","N/A",0]
[null,null,"Special Inspections ","N/A",0]
[null,null,"Permitting","N/A",0]
[null,null,"Safety Signage","Included",0]
[null,null,"Misc. Punchlist Close Out Items ","N/A",0]
[null,null,"Site Safety ","N/A",0]
[null,null,"Final Cleaning",1400,0]
[null,null,"Submittals",3750,0]
[]
[null,{"$f":"B40&\" TOTAL\"","v":"DIVISION 01 - GENERAL CONDITIONS TOTAL"},null,{"$f":"SUM(D41:D61)","v":121250},{"$f":"SUM(E41:E61)","v":0}]
[]
[]
[null,"DIVISION 02 - EXISTING CONDITIONS",null," "]
[null,null,"Selective demolition",12250,{"$f":"D66/34641","v":0.35362720475736842}]
[]
[null,"DIVISION 02 - EXISTING CONDITIONS TOTAL",null,{"$f":"SUM(D66:D67)","v":12250},{"$f":"SUM(E66:E67)","v":0.35362720475736842}]
[]
[]
[null,{"$f":"$C$13","v":"DIVISION 03 - CONCRETE"},null,null," "]
[null,null,"Cast in place Concrete, BUILDING Formwork",19070,0]
[null,null,"Cast in Place Concrete, BUILDING flatwork","Included",0]
[]
[null,{"$f":"B71&\" TOTAL\"","v":"DIVISION 03 - CONCRETE TOTAL"},null,{"$f":"SUM(D72:D74)","v":19070},{"$f":"SUM(E72:E74)","v":0}]
[]
[]
[null,{"$f":"$C$14","v":"DIVISION 05 - METALS"}]
[null,null,"Structural Steel, Joists and Deck",24932,0]
[null,null,"Structural metal stud framing","N/A",0]
[null,null,"Misc. Metals BUILDING",21500,0]
[null,null,"Misc. Metals SITE","N/A",0]
[null,null,null,null," "]
[null,{"$f":"B78&\" TOTAL\"","v":"DIVISION 05 - METALS TOTAL"},null,{"$f":"SUM(D79:D83)","v":46432},{"$f":"SUM(E79:E83)","v":0}]
[]
[]
[null,{"$f":"$C$15","v":"DIVISION 06 - WOODS, PLASTICS & COMPOSITES"}]
[null,null,"Rough Carpentry",1373,0]
[null,null,"Finish Carpentry",6000,0]
[]
[null,{"$f":"B87&\" TOTAL\"","v":"DIVISION 06 - WOODS, PLASTICS & COMPOSITES TOTAL"},null,{"$f":"SUM(D88:D90)","v":7373},{"$f":"SUM(E88:E90)","v":0}]
[]
[]
[null,{"$f":"$C$16","v":"DIVISION 07 - THERMAL MOISTURE PROTECTION"}]
[null,null,"Damproofing and Waterproofing","In Div. 09",0]
[null,null,"Building Insulation","In Div. 09",0]
[null,null,"Spray foam insulation","N/A",0]
[null,null,"Air Barriers","N/A",0]
[null,null,"Roofing and Flashing",25500,0]
[null,null,"Firestopping/Fireproofing",500,0]
[null,null,"Caulking & Joint Sealers ","N/A",0]
[null,null,"EIFS System","N/A",0]
[null,null,"Composite Metal Panels","N/A",0]
[null,null,"Vapor Barrier","N/A",0]
[]
[null,{"$f":"B94&\" TOTAL\"","v":"DIVISION 07 - THERMAL MOISTURE PROTECTION TOTAL"},null,{"$f":"SUM(D95:D105)","v":26000},{"$f":"SUM(E95:E105)","v":0}]
[]
[]
[null,{"$f":"$C$17","v":"DIVISION 08 - OPENINGS"}]
[null,null,"Doors and Frames",8743,0]
[null,null,"Hardware","Included",0]
[]
[null,{"$f":"B109&\" TOTAL\"","v":"DIVISION 08 - OPENINGS TOTAL"},null,{"$f":"SUM(D110:D112)","v":8743},{"$f":"SUM(E110:E112)","v":0}]
[]
[]
[null,{"$f":"$C$18","v":"DIVISION 09 - FINISHES"}]
[null,null,"Gypsum Wall Board",47521,0]
[null,null,"Non-Strutural Metal Framing","Included",0]
[null,null,"Tiling",57500,0]
[null,null,"Acoustical ceilings (panel & grid)",5000,0]
[null,null,"FRP","In Gyp. Bd",0]
[null,null,"Resilient Flooring & Base","N/A",0]
[null,null,"Wall Finishes",4620,0]
[null,null,"Paints and Coatings",5750,0]
[]
[null,{"$f":"B116&\" TOTAL\"","v":"DIVISION 09 - FINISHES TOTAL"},null,{"$f":"SUM(D117:D125)","v":120391},{"$f":"SUM(E117:E125)","v":0}]
[]
[]
[null,{"$f":"$C$19","v":"DIVISION 10 - SPECIALTIES"}]
[null,null,"Wall and Door Protection","N/A",0]
[null,null,"Toilet Room Accessories",1375,0]
[null,null,"Safety Specialties - Fire Extinguishers & Cabinets",1300,0]
[]
[null,{"$f":"B129&\" TOTAL\"","v":"DIVISION 10 - SPECIALTIES TOTAL"},null,{"$f":"SUM(D130:D133)","v":2675},{"$f":"SUM(E130:E133)","v":0}]
[]
[]
[null,"DIVISIONS 11 - EQUIPMENT "]
[null,null,"Installation of vendor-provided equipment, millwork, & furniture",54620,0]
[null,null,"F&I of equipment per equipment plan","N/A",0]
[]
[null,"DIVISIONS 11 - EQUIPMENT TOTAL",null,{"$f":"SUM(D138:D140)","v":54620},{"$f":"SUM(E138:E140)","v":0}]
[]
[]
[null,"DIVISION 12 - FURNISHINGS"]
[]
[]
[null,{"$f":"B144&\" TOTAL\"","v":"DIVISION 12 - FURNISHINGS TOTAL"},null,{"$f":"SUM(D145:D146)","v":0},{"$f":"SUM(E145:E146)","v":0}]
[]
[]
[null,{"$f":"$C$22","v":"DIVISION 22 - PLUMBING"}]
[null,null,"Domestic Water Piping",105420,0]
[null,null,"Sanitary Waste & Vent Piping","Included",0]
[null,null,"Plumbing Fixtures","Included",0]
[null,null,"Water Heaters","Included",0]
[null,null,"Plumbing installation","Included",0]
[]
[null,{"$f":"B150&\" TOTAL\"","v":"DIVISION 22 - PLUMBING TOTAL"},null,{"$f":"SUM(D151:D156)","v":105420},{"$f":"SUM(E151:E156)","v":0}]
[]
[]
[null,{"$f":"$C$23","v":"DIVISION 23 - HVAC"}]
[null,null,"HVAC",119900,0]
[null,null,"Automatic Temperature Controls",0,0]
[null,null,"Testing and Balancing","Included",0]
[]
[null,{"$f":"B160&\" TOTAL\"","v":"DIVISION 23 - HVAC TOTAL"},null,{"$f":"SUM(D161:D164)","v":119900},{"$f":"SUM(E161:E164)","v":0}]
[]
[]
[null,"DIVISION 26 - ELECTRICAL "]
[null,null,"Electrical Systems",103000,0]
[null,null,"Lighting and Devices",0,0]
[null,null,"Electrical Miscellaneous",0,0]
[null,null,"Voice Communications",0,0]
[]
[null,{"$f":"B168& \"TOTAL\"","v":"DIVISION 26 - ELECTRICAL TOTAL"},null,{"$f":"SUM(D169:D173)","v":103000},{"$f":"SUM(E169:E173)","v":0}]
[]
[]
[null,{"$f":"$C$25","v":"DIVISION 28 - ELECTRONIC SAFETY & SECURITY"}]
[null,null,"Access Controls & Security Systems","N/A",0]
[null,null,"Fire Detection and Alarm System",14875,0]
[]
[null,{"$f":"B177&\" TOTAL\"","v":"DIVISION 28 - ELECTRONIC SAFETY & SECURITY TOTAL"},null,{"$f":"SUM(D178:D180)","v":14875},{"$f":"SUM(E178:E180)","v":0}]
[]
[]
[null,"DIVISON 33 - UTILITIES"]
[null,null,"Water Utilites",0,0]
[null,null,"Sewer utilites",0,0]
[null,null,"Storm Utilities",0,0]
[null,null,"Electrical and Communication Untilites",0,0]
[null,null,"Gas Utilites",0,0]
[null,null,"Plumbing Utilites",0,0]
[]
[null,"DIVISON 33 - UTILITIES TOTAL",null,{"$f":"SUM(D185:D191)","v":0},{"$f":"SUM(E185:E191)","v":0}]
[]
[]
[null,"CONSTRUCTION REPORT TOTAL",null,{"$f":"D28","v":820814},{"$f":"E28","v":0.35362720475736842}]
[]
[]
[null,"ALTERNATE #1",null,0,0]
[null,null,"Description of Alternate"]
[]
[null,"ALTERNATE #2",null,0,0]
[null,null,"Description of Alternate"]
[]
[null,"ALTERNATE #3",null,0,0]
[null,null,"Description of Alternate"]