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

{"sheet":"Sheet1","index":0,"n_rows":42,"n_cols":15,"rows_kept":42}
[{"$nulls":3},"Main Street Piling Replacement                                                                                                                                                                                                                 "]
[{"$nulls":3},"City Project No. 2017-056"]
[{"$nulls":3},"Bid Schedule"]
["Item No.",null,"Description",null,null,"Est Qty","Unit","Contractor 1",null,"Contractor 2",null,"Contractor 3",null,"Unit Price","Total"]
[null,null,"Part A - General Conditions"]
[1,null,"Mobilization/Demobilization",null,null,1,"LS",null,{"$f":"H6*F6","v":{"v":0,"d":"$0.00"}},null,{"$f":"J6*F6","v":{"v":0,"d":"$0.00"}},null,{"$f":"L6*F6","v":{"v":0,"d":"$0.00"}},null,{"$f":"N6*F6","v":0}]
[2,null,"Environmental Compliance",null,null,1,"LS",{"$nulls":7},{"$f":"N7*F7","v":0}]
[null,null,"Part B - Structural Repairs"]
[3,"Remove Damaged Pile #1 - Bent 33",{"$nulls":3},1,"EA",{"$nulls":7},{"$f":"N9*F9","v":0}]
[4,"Remove Damaged Pile #3 -Bent 33",{"$nulls":3},1,"EA",{"$nulls":7},0]
[5,"Remove Danaged Pile #1 -Bent 43",{"$nulls":3},1,"EA",{"$nulls":7},0]
[6,"Remove Damaged Pile #2 - Bent 52",{"$nulls":3},1,"EA",null,{"$f":"H12*F12","v":{"v":0,"d":"$0.00"}},null,{"$f":"J12*F12","v":{"v":0,"d":"$0.00"}},null,{"v":0,"d":"$0.00"},null,0]
[7,null,"F & I Piling at Bent 33 Pile #1",null,null,1,"EA",{"$nulls":7},0]
[8,null,"F & I Piling at Bent 36 Pile #2",null,null,1,"EA",null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,0]
[9,null,"F & I Piling at Bent 40 Pile #1",null,null,1,"EA",null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,0]
[10,null,"F & I Piling at Bent 43 Pile #1",null,null,1,"EA",null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,0]
[11,null,"F & I Piling at Bent 43 Pile #3",null,null,1,"LS",null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,0]
[12,null,"F & I Piling at Bent 52 Pile #1",null,null,1,"LS",{"$nulls":7},0]
[13,null,"F & I Piling at Bent 54 Pile #1 ",null,null,1,"EA",{"$nulls":7},0]
[14,null,"F & I Piling at Bent 54 Pile #4",null,null,1,"EA",{"$nulls":7},0]
[15,null,"F & I Pile to Bent Connection",null,null,8,"EA",{"$nulls":7},0]
[16,"F & I  New Cross Bracing &  connection"]
[null,null,"  Hardware at  Bents 36,40 and 54",null,null,12,"EA",{"$nulls":7},{"$f":"N23*F23","v":0}]
[17," F & I  New Connection Hardware "]
[null,"at New Pile & Existing Crossbracing"]
[null,"at Bents 33 & 43",{"$nulls":3},3,"EA",{"$nulls":7},{"$f":"N26*F26","v":0}]
[null,null,"TOTAL BASE BID",{"$nulls":11},{"$f":"SUM(O6:O26)","v":0}]
[]
["Company:"]
[]
["Prepared by: "]
[]
["Title:",{"$nulls":6},"Printed Name: "]
[]
["Date: "]
[]
["Email:",{"$nulls":6},"Title: "]
[]
["Phone"]
[{"$nulls":7},"Date signed: "]
[]
[{"$nulls":7},"Email: "]

{"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"}}]