{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Sheet1","Sheet3","Sheet2","Old"],"not_rendered":{"images":1,"defined_names":2,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":53,"n_cols":16,"rows_kept":53,"merged":[[0,0,0,15],[1,0,1,1],[1,2,1,5],[1,8,1,9],[1,10,1,11],[1,12,1,13],[2,0,2,1],[2,2,2,5],[3,0,3,1],[3,2,3,5],[4,0,4,1],[4,2,4,5],[5,0,5,1],[5,2,5,5],[6,0,6,1],[6,2,6,5],[7,0,7,1],[7,2,7,5],[8,0,8,1],[8,2,8,5],[9,0,9,1],[9,2,9,5],[10,0,10,1],[10,2,10,5],[11,0,11,1],[11,2,11,5],[12,0,12,1],[12,2,12,5],[13,0,13,1],[13,2,13,5],[14,0,14,1],[14,2,14,5],[15,0,15,1],[15,2,15,5],[16,0,16,1],[16,2,16,5],[17,0,17,1],[17,2,17,5],[18,0,18,1],[18,2,18,5],[19,0,19,1],[19,2,19,5],[20,0,20,1],[20,2,20,5],[21,0,21,1],[21,2,21,5],[22,0,22,1],[22,2,22,5],[23,0,23,1],[23,2,23,5],[24,0,24,1],[24,2,24,5],[25,0,25,1],[25,2,25,5],[26,0,26,1],[26,2,26,5],[27,0,27,1],[27,2,27,5],[28,0,28,1],[28,2,28,5],[29,0,29,1],[29,2,29,5],[30,0,30,5],[31,0,31,1],[31,2,31,5],[32,0,32,1],[32,2,32,5],[33,0,33,1],[33,2,33,5],[34,0,34,1],[34,2,34,5],[35,0,35,1],[35,2,35,5],[36,0,36,5],[37,0,37,1],[37,2,37,5],[38,0,38,1],[38,2,38,5],[39,0,39,1],[39,2,39,5],[40,0,40,1],[40,2,40,5],[41,0,41,1],[41,2,41,5],[42,0,42,1],[42,2,42,5],[43,0,43,1],[43,2,43,5],[44,0,44,1],[44,2,44,5],[45,0,45,5],[46,0,46,1],[47,0,47,1],[47,2,47,5],[48,0,48,1],[48,2,48,5],[49,0,49,1],[49,2,49,5],[50,0,50,1],[50,2,50,5],[51,0,51,1],[51,2,51,5],[52,0,52,1],[52,2,52,5]]}
["Main Street Pier Repair                                                                                                                                                                    City Project No. 2017-056                                                                                                                                                                                                           Bid Schedule - ITB 20073"]
["Item No.",null,"Bid Item",{"$nulls":3},"QTY","Unit","Contractor 1",null,"Contractor 2",null,"Contractor 3",null,"Unit Price","Total"]
[null,null,"Base Bid"]
[null,null,"Part A - General Conditions"]
[1,null,"Mobilization/Demobilization-Max 5%",{"$nulls":3},1,"LS",null,{"$f":"I5*G5","v":{"v":0,"d":"$0.00"}},null,{"$f":"K5*G5","v":{"v":0,"d":"$0.00"}},null,{"$f":"M5*G5","v":{"v":0,"d":"$0.00"}},null,{"$f":"+O5*G5","v":0}]
[2,null,"As- Built Drawings",{"$nulls":3},1,"LS",{"$nulls":7},{"$f":"+O6*G6","v":0}]
[3,null,"Environmental Compliance",{"$nulls":3},1,"LS",{"$nulls":7},0]
[null,null,"Part B - Structural Repairs"]
[4,null,"Replace Loose Angle Bolts @ Bulkhead",{"$nulls":3},1,"LS",{"$nulls":7},{"$f":"+O9*G9","v":0}]
[5,null," Flat Straps w/Bolts - Bents 1 to 17.5",{"$nulls":3},160,"EA",{"$nulls":7},0]
[6,null,"Repair Split Pile",{"$nulls":3},3,"EA",null,{"$f":"I11*G11","v":{"v":0,"d":"$0.00"}},null,{"$f":"K11*G11","v":{"v":0,"d":"$0.00"}},null,{"v":0,"d":"$0.00"},null,0]
[7,null,"Replace Side Bracing at Bent 2",{"$nulls":3},2,"EA",{"$nulls":7},0]
[8,null,"Concrete Repair Bent 3 to 4 area",{"$nulls":3},1,"LS",{"$nulls":7},0]
[9,null,"Seal Conduits in Concrete Bent 3 to 4",{"$nulls":3},1,"LS",{"$nulls":7},0]
[10,null,"Shim Gap at Pile/Pile Cap ",{"$nulls":3},2,"EA",null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,0]
[11,null,"Repair Concrete Beam Connection",{"$nulls":3},1,"LS",{"$nulls":7},0]
[12,null,"Repair Necked Pile",{"$nulls":3},5,"EA",null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,0]
[13,null,"Replace Cross Member at Bent",{"$nulls":3},32,"EA",{"$nulls":7},0]
[14,null,"Repair Rotten Pile at Bent",{"$nulls":3},1,"EA",null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,0]
[15,null,"Repair Cracked Pile at Bent",{"$nulls":3},1,"EA",null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,0]
[16,null,"Concrete Repair-Bents 14 to 15 area",{"$nulls":3},1,"LS",null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,0]
[17,null,"Replace Brace Members - Grease Trap",{"$nulls":3},25,"EA",null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,0]
[18,null,"Repair Detached Pile-Bent 34",{"$nulls":3},1,"LS",null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,0]
[19,null,"Repair Exist. Concrete Pile Collar",{"$nulls":3},5,"EA",{"$nulls":7},0]
[20,null,"Pile Replacement Bent 43",{"$nulls":3},1,"LS",{"$nulls":7},0]
[21,null,"Tighten all Pier Bolted Connections",{"$nulls":3},1,"LS",{"$nulls":7},0]
[22,null,"Replace connection hardware complete",{"$nulls":3},200,"EA",{"$nulls":7},0]
[23,null,"Install Conc. Collars on Exist. Piles",{"$nulls":3},19,"EA",{"$nulls":7},0]
[null,null,"TOTAL BASE BID",{"$nulls":12},{"$f":"SUM(P5:P28)","v":0}]
[]
["Additive Alternate 1 - Electrical Repairs"]
[1,null,"Replace Conduit Hanger Straps ",{"$nulls":3},10,"EA",{"$nulls":7},{"$f":"+O32*G32","v":0}]
[2,null,"Repair conduit,fittings at Bent 3&4",{"$nulls":3},1,"LS",{"$nulls":7},0]
[3,null,"Repair conduit at Bent 5&6",{"$nulls":3},1,"LS",{"$nulls":7},0]
[null,null,"Total Additive Alternate 1",{"$nulls":12},{"$f":"SUM(P32:P34)","v":0}]
[]
["Additive Alternate 2 - Plumbing Repair"]
[1,null,"Fernco Coupling- Sewer line-Bent 18",{"$nulls":3},2,"EA",{"$nulls":7},{"$f":"+O38*G38","v":0}]
[2,null,"Purchase & Deliver 4\" Backflow Device",{"$nulls":3},1,"LS",{"$nulls":7},0]
[3,null,"Replace 1.5\" Backflow Device-Bent 1",{"$nulls":3},1,"LS",{"$nulls":7},0]
[4,null,"Replace Hangers 2\"& 1.5\"utility pipe",{"$nulls":3},20,"EA",{"$nulls":7},0]
[5,null,"Replace Hangers 2 inch gas pipe",{"$nulls":3},45,"EA",{"$nulls":7},0]
[6,null,"Replace Hangers 4 inch utility pipe",{"$nulls":3},38,"EA",{"$nulls":7},0]
[null,null,"Total Additive Alternate 2",{"$nulls":12},{"$f":"SUM(P38:P43)","v":0}]
[]
["Additive Alternate 3 - Fire Sprinkler Repairs"]
[1,null,"Replace 6 inch backflow assembly",{"$nulls":3},1,"LS",{"$nulls":7},{"$f":"+O47*G47","v":0}]
[2,null,"Replace 6\" grooved pipe couplings",{"$nulls":3},20,"EA",{"$nulls":7},0]
[3,null,"Replace 6\" Fire Line-Bents 18 to 21",{"$nulls":3},80,"LF",{"$nulls":7},0]
[4,null,"Paint 6\" Fire Line-Bents 18 to 21",{"$nulls":3},80,"LF",{"$nulls":7},0]
[5,null,"Replace 6 inch 90 degree Bend",{"$nulls":3},6,"EA",{"$nulls":7},0]
[6,null,"Replace  Pipe Hangers ",{"$nulls":3},30,"EA",{"$nulls":7},0]
[null,null,"Total Additive Alternate 3",{"$nulls":12},{"$f":"SUM(P47:P52)","v":0}]

{"sheet":"Sheet3","index":1,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Sheet2","index":2,"n_rows":7,"n_cols":10,"rows_kept":7,"merged":[[6,1,6,4]]}
[]
[]
["DEDUCTIVE ALTERNATE"]
[]
["State the amount to be deducted from Total Base Bid for substitution"]
[]
["522-1","Concrete Sidewalk 4\" thick, 2500 psi",{"$nulls":3},4081,"SY","$",null,"$"]

{"sheet":"Old","index":3,"n_rows":16,"n_cols":17,"rows_kept":16,"merged":[[0,0,0,14],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,1,5],[1,6,1,7],[1,8,1,9],[1,10,1,11],[1,12,2,12],[1,13,2,13],[1,14,2,14]]}
["Bill France & Mason NE Sidewalk Upgrade Project\nEngineers Cost Estimate "]
["Item No.","Bid Item Description","QTY","Unit","Contractor 1",null,"Contractor 2",null,"Contractor 3",null,"Engineering Estimate",null,"% Contractor differs from Eng Est","AVERAGE ","MAX"]
[{"$nulls":4},"Unit Price","Total","Unit Price","Total","Unit Price","Total","Unit Price","Total"]
[1,"Mobilization (includes pre construciton video)",1,"LS",null,{"$f":"E4*C4","v":{"v":0,"d":"$0.00"}},null,{"$f":"G4*C4","v":{"v":0,"d":"$0.00"}},null,{"$f":"I4*C4","v":{"v":0,"d":"$0.00"}},{"v":3000,"d":"$3,000.00"},{"$f":"K4*$C4","v":{"v":3000,"d":"$3,000.00"}},"10% total",{"$f":"+AVERAGE(F4,H4,J4,)","v":{"v":0,"d":"$0.00"}},{"$f":"+MAX(F4,H4,J24)","v":{"v":0,"d":"$0.00"}},null,"* 10% of total cost"]
[2,"Maintenance of Traffic",1,"LS",null,{"$f":"E5*C5","v":{"v":0,"d":"$0.00"}},null,{"$f":"G5*C5","v":{"v":0,"d":"$0.00"}},null,{"v":0,"d":"$0.00"},{"v":6000,"d":"$6,000.00"},{"$f":"K5*$C5","v":{"v":6000,"d":"$6,000.00"}},"Holsonback",{"v":0,"d":"$0.00"},{"$f":"+MAX(F5,H5,J25)","v":{"v":0,"d":"$0.00"}}]
[3,"Erosion Control",812,"LF",null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},{"v":2,"d":"$2.00"},{"v":1624,"d":"$1,624.00"},"Holsonback",{"v":0,"d":"$0.00"},{"$f":"+MAX(F6,H6,J26)","v":{"v":0,"d":"$0.00"}}]
[4,"Clearing and Grubbing (includes tree, grass, concrete removal to accommodate construction)",78,"SY",null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},{"v":3.5,"d":"$3.50"},{"v":273,"d":"$273.00"},"FDOT p.2      (see calcs)",{"v":0,"d":"$0.00"}]
[5,"Earthwork",31,"SY",null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},{"v":6.5,"d":"$6.50"},{"v":201.5,"d":"$201.50"},"JimmyAnn & Holsonback (see calcs)",{"v":0,"d":"$0.00"},{"$f":"+MAX(F8,H8, J8)","v":{"v":0,"d":"$0.00"}}]
[6,"Finished Grade",262,"SY",null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},{"v":0.62,"d":"$0.62"},{"v":162.44,"d":"$162.44"},"FDOT p.3",{"v":0,"d":"$0.00"},{"$f":"+MAX(F9,H9,J29)","v":{"v":0,"d":"$0.00"}},null,"* All R&R + new concrete"]
[7,"Closed Sidewalk Sign ",1,"EA",null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},{"v":362.23,"d":"$362.23"},{"v":362.23,"d":"$362.23"},"FDOT p. 24",{"v":0,"d":"$0.00"},{"$f":"+MAX(F10,H10,J30)","v":{"v":0,"d":"$0.00"}}]
[8,"Remove and Replace Existing Sidewalk (6 inch thick 3,500 psi)",227,"SY",null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},{"v":66.5,"d":"$66.50"},{"v":15095.5,"d":"$15,095.50"},"FDOT p.16 + $15 (for remove s/w)",{"v":0,"d":"$0.00"}]
[9,"5' Sidewalk (6\" thick) (3,400 psi) (including ADA ramps and detectable warning surfaces)",35,"SY",null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},{"v":51.5,"d":"$51.50"},{"v":1802.5,"d":"$1,802.50"},"FDOT p. 16",{"v":0,"d":"$0.00"},{"$f":"+MAX(F12,H12,J32)","v":{"v":0,"d":"$0.00"}}]
[10,"Sodding",176,"SY",null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},{"v":2.91,"d":"$2.91"},{"v":512.1600000000001,"d":"$512.16"},"FDOT p. 18",{"v":0,"d":"$0.00"},{"$f":"+MAX(F13,H13,J34)","v":{"v":0,"d":"$0.00"}}]
[11,"As-Built Drawings (certified)",1,"LS",null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},{"v":4000,"d":"$4,000.00"},{"v":4000,"d":"$4,000.00"},"Holsonback",{"v":0,"d":"$0.00"},{"$f":"+MAX(F14,H14,J37)","v":{"v":0,"d":"$0.00"}}]
[null,"10% Contingency to Mobilization",{"$nulls":11},{"$f":"+N4*0.1","v":{"v":0,"d":"$0.00"}},{"$f":"+O4*0.1","v":{"v":0,"d":"$0.00"}}]
[null,"Grand Total Bid",{"$nulls":3},{"$f":"SUM(F4:F15)","v":{"v":0,"d":"$0.00"}},null,{"$f":"SUM(H4:H15)","v":{"v":0,"d":"$0.00"}},null,{"$f":"SUM(J4:J15)","v":{"v":0,"d":"$0.00"}},null,{"$f":"SUM(L4:L15)","v":{"v":33033.33,"d":"$33,033.33"}},".9% Less",{"$f":"SUM(N4:N15)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(O4:O15)","v":{"v":0,"d":"$0.00"}}]