{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Bid Template REVISED"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":2,"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":306,"n_cols":5,"rows_kept":306,"cut":false,"hidden":false,"merged":[[8,1,8,2],[33,1,33,2],[35,1,35,2],[37,1,37,2],[0,3,0,4],[2,1,2,2],[3,1,3,2],[2,3,2,4],[0,1,0,2],[4,3,4,4],[38,1,38,2],[49,1,49,2],[71,1,71,2],[74,1,74,2],[77,1,77,2],[80,1,80,2],[90,1,90,2],[93,1,93,2],[96,1,96,2],[99,1,99,2],[109,1,109,2],[113,1,113,2],[116,1,116,2],[128,1,128,2],[139,1,139,2],[142,1,142,2],[155,1,155,2],[158,1,158,2],[170,1,170,2],[173,1,173,2],[180,1,180,2],[183,1,183,2],[188,1,188,2],[191,1,191,2],[194,1,194,2],[40,1,40,2],[46,1,46,2],[106,1,106,2],[131,1,131,2],[269,1,269,2],[245,1,245,2],[250,1,250,2],[253,1,253,2],[260,1,260,2],[263,1,263,2],[223,1,223,2],[228,1,228,2],[231,1,231,2],[239,1,239,2],[242,1,242,2],[197,1,197,2],[298,1,298,2],[301,1,301,2],[304,1,304,2],[186,1,186,2],[289,1,289,2],[292,1,292,2],[295,1,295,2],[286,1,286,2],[271,1,271,2],[279,1,279,2],[282,1,282,2],[284,1,284,2],[200,1,200,2],[203,1,203,2],[207,1,207,2],[220,1,220,2]]}
[null,"CONSTRUCTION BID FORM",null,"BKA Proj #  225088"]
[]
[null,"Dave's Hot Chicken - BGR Hospitality",null,"Bid Due Date:  Sept 10, 2025, 5pm"]
[null,"2055 Washington St, Hanover, MA"]
[null,null,null,"New England Construction"]
[null," ",null,"CONSTRUCTION","COST ANALYSIS"]
[null,"DIVISION",null,"BID","COST / GSF"]
[]
[null,"EXECUTIVE SUMMARY"]
[null,null,"DIVISION 01 - GENERAL CONDITIONS",{"$f":"D72","v":86319.4},0]
[null,null,"DIVISION 02 - EXISTING CONDITIONS",{"$f":"D78","v":10600},0]
[null,null,"DIVISION 03 - CONCRETE",{"$f":"D91","v":28011},0]
[null,null,"DIVISION 04 - MASONRY",0,0]
[null,null,"DIVISION 05 - METALS",0,0]
[null,null,"DIVISION 06 - WOODS, PLASTICS & COMPOSITES",{"$f":"D114","v":3470},0]
[null,null,"DIVISION 07 - THERMAL MOISTURE PROTECTION",{"$f":"D129","v":15280},0]
[null,null,"DIVISION 08 - OPENINGS",{"$f":"D140","v":12578},0]
[null,null,"DIVISION 09 - FINISHES",{"$f":"D156","v":88496},0]
[null,null,"DIVISION 10 - SPECIALTIES",{"$f":"D171","v":4673},0]
[null,null,"DIVISION 11 - EQUIPMENT",{"$f":"D181","v":12250},0]
[null,null,"DIVISION 12 - FURNISHINGS ",{"$f":"D187","v":1360},0]
[null,null,"DIVISION 13 - SPECIAL CONSTRUCTION",0,0]
[null,null,"DIVISION 14 - CONVEYING EQUIPMENT",0,0]
[null,null,"DIVISION 21 - FIRE SUPPRESSION",{"$f":"D204","v":7400},0]
[null,null,"DIVISION 22 - PLUMBING",{"$f":"D221","v":63000},0]
[null,null,"DIVISION 23 - HVAC",{"$f":"D229","v":71700},0]
[null,null,"DIVISION 26 - ELECTRICAL",{"$f":"D240","v":85350},0]
[null,null,"DIVISION 27 - COMMUNICATIONS ",0,0]
[null,null,"DIVISION 28 - ELECTRONIC SAFETY & SECURITY",{"$f":"D251","v":15436},0]
[null,null,"DIVISION 31 - EARTHWORK",0,0]
[null,null,"DIVISION 32 - EXTERIOR IMPROVEMENTS",0,0]
[null,null,"DIVISION 31 - UTILITIES",0,0]
[]
[null,"CONSTRUCTION BUDGET SUB-TOTAL",null,{"$f":"SUM(D10:D32)","v":505923.4},{"$f":"SUM(E10:E32)","v":0}]
[]
[null,"CONSTRUCTION CONTINGENCY (20%)",null,null,{"$f":"SUM(E12:E34)*20%","v":0}]
[]
[null,"CONSTRUCTION REPORT TOTAL",null,{"$f":"SUM(D34:D36)","v":505923.4},{"$f":"SUM(E34:E36)","v":0}]
[null," ",null," "]
[]
[null,"DIVISION 0 - FEES"]
[null,null,"Contractor Fee + Overhead",30846,0]
[null,null,"Insurance",8174,0]
[null,null,"Sub guard Insurance ",0,{"$f":"D44/#REF!","v":{"$error":"#REF!"}}]
[null,null,"Tax"]
[]
[null,{"$f":"B41&\" TOTAL\"","v":"DIVISION 0 - FEES TOTAL"},null,{"$f":"SUM(D42:D46)","v":39020},{"$f":"SUM(E42:E43)","v":0}]
[]
[]
[null,{"$f":"$C$10","v":"DIVISION 01 - GENERAL CONDITIONS"}]
[null,null,"General Conditions - Lump Sum",{"$f":"[2]Sheet1!$F$19+[2]Sheet1!$F$38","v":86319.4},0]
[null,null,"Project Manager",0,0]
[null,null,"Assistant Project Manager (if applicable)",0,0]
[null,null,"Site Management - Superintendent",0,0]
[null,null,"Site Management - Asst. Superintendent  (if applicable)",0,0]
[null,null,"Site Labor",0,0]
[null,null,"Temporary Storage",0,0]
[null,null,"Dumpsters",0,0]
[null,null,"Scaffolding",0,0]
[null,null,"Temporary Utilities",0,0]
[null,null,"Construction Facilities  - Site Office",0,0]
[null,null,"Site Maintenance and Protection",0,0]
[null,null,"Mileage",0,0]
[null,null,"Special Inspections ",0,0]
[null,null,"Permitting",0,0]
[null,null,"Safety Signage",0,0]
[null,null,"Misc. Punchlist Close Out Items ",0,0]
[null,null,"Site Safety ",0,0]
[null,null,"Final Cleaning",0,0]
[null,null,"Submittals",0,0]
[]
[null,{"$f":"B50&\" TOTAL\"","v":"DIVISION 01 - GENERAL CONDITIONS TOTAL"},null,{"$f":"SUM(D51:D71)","v":86319.4},{"$f":"SUM(E51:E71)","v":0}]
[]
[]
[null,"DIVISION 02 - EXISTING CONDITIONS",null," "]
[null,null,"Selective demolition",{"$f":"[2]Sheet1!$F$55","v":10600},{"$f":"D76/34641","v":0.3059957853410698}]
[]
[null,"DIVISION 02 - EXISTING CONDITIONS TOTAL",null,{"$f":"SUM(D76:D77)","v":10600},{"$f":"SUM(E76:E77)","v":0.3059957853410698}]
[]
[]
[null,{"$f":"$C$12","v":"DIVISION 03 - CONCRETE"},null,null," "]
[null,null,"Earthwork Grading / Excavation",0,0]
[null,null,"Cast in place Concrete, BUILDING Formwork",0,0]
[null,null,"Cast in Place Concrete, BUILDING flatwork",0,0]
[null,null,"Cast in Place Concrete, SITE Formwork",0,0]
[null,null,"Cast in place Concrete, SITE Flatwork",0,0]
[null,null,"Trenching & Patching",{"$f":"[2]Sheet1!$F$58","v":12130},0]
[null,null,"Housekeeping Pads",{"$f":"[2]Sheet1!$F$64","v":4226},0]
[null,null,"Polished Concrete",{"$f":"[2]Sheet1!$F$69","v":11655},0]
[]
[null,{"$f":"B81&\" TOTAL\"","v":"DIVISION 03 - CONCRETE TOTAL"},null,{"$f":"SUM(D82:D90)","v":28011},{"$f":"SUM(E82:E90)","v":0}]
[]
[]
[null,"DIVISION 04 - MASONRY"]
[null,null,"Concrete Unit Masonry",0,0]
[]
[null,{"$f":"B94&\" TOTAL\"","v":"DIVISION 04 - MASONRY TOTAL"},null,{"$f":"SUM(D95:D96)","v":0},{"$f":"SUM(E95:E96)","v":0}]
[]
[]
[null,{"$f":"$C$14","v":"DIVISION 05 - METALS"}]
[null,null,"Structural Steel, Joists and Decl",0,0]
[null,null,"Structural metal stud framing",0,0]
[null,null,"Misc. Metals BUILDING",0,0]
[null,null,"Misc. Metals SITE",0,0]
[null,null,"Metal railings",0,0]
[null,null,null,null," "]
[null,{"$f":"B100&\" TOTAL\"","v":"DIVISION 05 - METALS TOTAL"},null,{"$f":"SUM(D101:D106)","v":0},{"$f":"SUM(E101:E105)","v":0}]
[]
[]
[null,{"$f":"$C$15","v":"DIVISION 06 - WOODS, PLASTICS & COMPOSITES"}]
[null,null,"Rough Carpentry",{"$f":"SUM([1]Sheet1!$F$88:$F$90)","v":750},0]
[null,null,"Finish Carpentry",{"$f":"SUM([1]Sheet1!$F$96:$F$97)","v":2720},0]
[]
[null,{"$f":"B110&\" TOTAL\"","v":"DIVISION 06 - WOODS, PLASTICS & COMPOSITES TOTAL"},null,{"$f":"SUM(D111:D113)","v":3470},{"$f":"SUM(E111:E113)","v":0}]
[]
[]
[null,{"$f":"$C$16","v":"DIVISION 07 - THERMAL MOISTURE PROTECTION"}]
[null,null,"Damproofing and Waterproofing",0,0]
[null,null,"Building Insulation",0,0]
[null,null,"Spray foam insulation",0,0]
[null,null,"Air Barriers",0,0]
[null,null,"Roofing and Flashing",{"$f":"[1]Sheet1!$F$104","v":15280},0]
[null,null,"Firestopping/Fireproofing",0,0]
[null,null,"Caulking & Joint Sealers ",0,0]
[null,null,"EIFS System",0,0]
[null,null,"Composite Metal Panels",0,0]
[null,null,"Vapor Barrier",0,0]
[]
[null,{"$f":"B117&\" TOTAL\"","v":"DIVISION 07 - THERMAL MOISTURE PROTECTION TOTAL"},null,{"$f":"SUM(D118:D128)","v":15280},{"$f":"SUM(E118:E128)","v":0}]
[]
[]
[null,{"$f":"$C$17","v":"DIVISION 08 - OPENINGS"}]
[null,null,"Metal Doors and Frames",{"$f":"[1]Sheet1!$F$112","v":12578},0]
[null,null,"Hardware",0,0]
[null,null,"Access Doors",0,0]
[null,null,"Overhead Doors",0,0]
[null,null,"Glass and Glazing",0,0]
[null,null,"Security and Films",0,0]
[]
[null,{"$f":"B132&\" TOTAL\"","v":"DIVISION 08 - OPENINGS TOTAL"},null,{"$f":"SUM(D133:D139)","v":12578},{"$f":"SUM(E133:E139)","v":0}]
[]
[]
[null,{"$f":"$C$18","v":"DIVISION 09 - FINISHES"}]
[null,null,"Gypsum Wall Board",{"$f":"[1]Sheet1!$F$115","v":19522},0]
[null,null,"Non-Strutural Metal Framing",0,0]
[null,null,"Tiling",{"$f":"[1]Sheet1!$F$136","v":9600},0]
[null,null,"Acoustical ceilings (clean room panels & grid)",0,0]
[null,null,"Acoustical ceilings (panel & grid)",{"$f":"[1]Sheet1!$F$145","v":3300},0]
[null,null,"FRP",{"$f":"[1]Sheet1!$F$153","v":14471},0]
[null,null,"Resilient Flooring & Base",{"$f":"[1]Sheet1!$F$147","v":3000},0]
[null,null,"Urethane Concrete Flooring with integral 4\" epoxy base",{"$f":"[1]Sheet1!$F$149","v":31148},0]
[null,null,"Concrete Sealer",0,0]
[null,null,"Wall Finishes",0,0]
[null,null,"Paints and Coatings",{"$f":"[1]Sheet1!$F$160+[1]Sheet1!$F$171","v":7455},0]
[]
[null,{"$f":"B143&\" TOTAL\"","v":"DIVISION 09 - FINISHES TOTAL"},null,{"$f":"SUM(D144:D155)","v":88496},{"$f":"SUM(E144:E155)","v":0}]
[]
[]
[null,{"$f":"$C$19","v":"DIVISION 10 - SPECIALTIES"}]
[null,null,"Exterior Signage",0,0]
[null,null,"Interior Signage",{"$f":"[1]Sheet1!$F$178","v":750},0]
[null,null,"Telephone Speacialties",0,0]
[null,null,"Partitions",0,0]
[null,null,"Wall and Door Protection",{"$f":"SUM([1]Sheet1!$F$184:$F$186)","v":2330},0]
[null,null,"Toilet Room Accessories",{"$f":"[1]Sheet1!$F$191","v":906},0]
[null,null,"Safety Specialties - Fire Extinguishers & Cabinets",{"$f":"[1]Sheet1!$F$187","v":687},0]
[null,null,"Lockers",0,0]
[null,null,"Interior Bollards",0,0]
[null,null,"Storage Shelving",0,0]
[]
[null,{"$f":"B159&\" TOTAL\"","v":"DIVISION 10 - SPECIALTIES TOTAL"},null,{"$f":"SUM(D160:D169)","v":4673},{"$f":"SUM(E160:E170)","v":0}]
[]
[]
[null,"DIVISIONS 11 - EQUIPMENT "]
[null,null,"Walk in freezer (Allowance)",0,0]
[null,null,"Drying Racks",0,0]
[null,null,"Pip Racks",0,0]
[null,null,"Air Shower",0,0]
[null,null,"Food Service Equipment Install",{"$f":"[1]Sheet1!$F$202","v":12250},0]
[]
[null,"DIVISIONS 11 - EQUIPMENT TOTAL",null,{"$f":"SUM(D175:D180)","v":12250},{"$f":"SUM(E175:E180)","v":0}]
[]
[]
[null,"DIVISION 12 - FURNISHINGS"]
[null,null,"Furniture Install",{"$f":"[1]Sheet1!$F$208","v":1360},0]
[]
[null,"DIVISIONS 12 - FURNISHINGS TOTAL",null,{"$f":"SUM(D185:D186)","v":1360},{"$f":"SUM(E181:E186)","v":0}]
[]
[null,"DIVISION 13 - SPECIAL CONSTRUCTION"]
[null,null,"Vault",0,0]
[]
[null,{"$f":"B189&\" TOTAL\"","v":"DIVISION 13 - SPECIAL CONSTRUCTION TOTAL"},null,{"$f":"SUM(D190:D191)","v":0},{"$f":"SUM(E190:E191)","v":0}]
[]
[]
[null,"DIVISION 14 - CONVEYING SYSTEMS"]
[null,null,"Elevator",0,0]
[]
[null,{"$f":"B195&\" TOTAL\"","v":"DIVISION 14 - CONVEYING SYSTEMS TOTAL"},null,{"$f":"SUM(D196:D197)","v":0},{"$f":"SUM(E196:E197)","v":0}]
[]
[]
[null,"DIVISION 21 - FIRE SUPPRESSION"]
[null,null,"Water Based Fire Suppression System",{"$f":"[1]Sheet1!$F$215","v":7400},0]
[]
[null,{"$f":"B201&\" TOTAL\"","v":"DIVISION 21 - FIRE SUPPRESSION TOTAL"},null,{"$f":"SUM(D202:D203)","v":7400},{"$f":"SUM(E202:E203)","v":0}]
[]
[]
[]
[null,{"$f":"$C$25","v":"DIVISION 22 - PLUMBING"}]
[null,null,"Storm Drainage System",0,0]
[null,null,"Plant Water Drainage System",0,0]
[null,null,"Domestic Water Piping",{"$f":"[1]Sheet1!$F$218","v":63000},0]
[null,null,"Sanitary Waste & Vent Piping",0,0]
[null,null,"Plumbing Fixtures",0,0]
[null,null,"Water Heaters",0,0]
[null,null,"New Water Service",0,0]
[null,null,"Plumbing installation",0,0]
[null,null,"Fertigation Piping System",0,0]
[null,null,"Condensate Piping",0,0]
[null,null,"Site Utilities",0,0]
[]
[null,{"$f":"B208&\" TOTAL\"","v":"DIVISION 22 - PLUMBING TOTAL"},null,{"$f":"SUM(D209:D220)","v":63000},{"$f":"SUM(E209:E220)","v":0}]
[]
[]
[null,{"$f":"$C$26","v":"DIVISION 23 - HVAC"}]
[null,null,"HVAC",{"$f":"[1]Sheet1!$F$257","v":71700},0]
[null,null,"Automatic Temperature Controls",0,0]
[null,null,"Testing and Balancing",0,0]
[]
[null,{"$f":"B224&\" TOTAL\"","v":"DIVISION 23 - HVAC TOTAL"},null,{"$f":"SUM(D225:D228)","v":71700},{"$f":"SUM(E225:E228)","v":0}]
[]
[]
[null,"DIVISION 26 - ELECTRICAL "]
[null,null,"Electrical Systems",85350,0]
[null,null,"Lighitng and Devices",0,0]
[null,null,"Electrical Miscellaneous",0,0]
[null,null,"Voice Communications",0,0]
[null,null,"Generator Supply and Install",0,0]
[null,null,"Site lighting",0,0]
[]
[null,{"$f":"B232& \"TOTAL\"","v":"DIVISION 26 - ELECTRICAL TOTAL"},null,{"$f":"SUM(D233:D239)","v":85350},{"$f":"SUM(E233:E239)","v":0}]
[]
[]
[null,"DIVISION 27 - COMMUNICATIONS (NOT USED)"]
[]
[]
[null,{"$f":"$C$29","v":"DIVISION 28 - ELECTRONIC SAFETY & SECURITY"}]
[null,null,"Access Controls & Security Systems",0,0]
[null,null,"Fire Detection and Alarm System",{"$f":"[1]Sheet1!$F$315","v":15436},0]
[null,null,"BDA (bi-directional amplifier) allowance",0,0]
[]
[null,{"$f":"B246&\" TOTAL\"","v":"DIVISION 28 - ELECTRONIC SAFETY & SECURITY TOTAL"},null,{"$f":"SUM(D247:D250)","v":15436},{"$f":"SUM(E247:E250)","v":0}]
[]
[]
[null,"DIVISION 31 - EARTHWORK"]
[null,null,"Erosion Control",0,0]
[null,null,"Site Prep",0,0]
[null,null,"Site Grading",0,0]
[null,null,"Trucking & Disposal",0,0]
[null,null,"Building Excavations",0,0]
[]
[null,"DIVISION 31 - EARTHWORK TOTAL",null,{"$f":"SUM(D255:D260)","v":0},{"$f":"SUM(E255:E260)","v":0}]
[]
[]
[null,"DIVISION 32 - EXTERIOR IMPROVEMENTS"]
[null,null,"Asphalt Parking lots",0,0]
[null,null,"Curbs",0,0]
[null,null,"Sidewalks",0,0]
[null,null,"Landscaping",0,0]
[]
[null,{"$f":"B264&\" TOTAL\"","v":"DIVISION 32 - EXTERIOR IMPROVEMENTS TOTAL"},null,{"$f":"SUM(D265:D269)","v":0},{"$f":"SUM(E265:E269)","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(D273:D279)","v":0},{"$f":"SUM(E273:E279)","v":0}]
[]
[]
[null,"CONSTRUCTION BUDGET SUB-TOTAL",null,{"$f":"D34","v":505923.4},0]
[]
[null,"CONSTRUCTION CONTINGENCY",null,0,0]
[]
[null,"CONSTRUCTION REPORT TOTAL",null,{"$f":"D34+D47","v":544943.4},0]
[]
[]
[null,"ALTERNATE #1",null,4889,0]
[null,null,"Ceramic Tile Floor & Base in lieu of Polished Concrete in Dining Area"]
[]
[null,"ALTERNATE #2",null,-14548,0]
[null,null,"Quarry Tile Floor & Base in lieu of Silikal Epoxy in BOH & Kitchen"]
[]
[null,"ALTERNATE #3",null,-10317,0]
[null,null,"Provide an alternate Epoxy Flooring Product"]
[]
[null,"ALTERNATE #4",null,11994,0]
[null,null,"Furnish the Light Fixture & Controls Package"]
[]
[null,"ALTERNATE #5",null,4309,0]
[null,null,"Furnish & install security cabling"]
[]
[null,"ALTERNATE #6",null,7540,0]
[null,null,"Furnish & install tel/data cabling"]