{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["Total Quantities","Charles St Ext","Craven St","Jericho Woods SD","Stone Marten","Schein Loop"],"not_rendered":{"external_links":1,"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"Total Quantities","index":0,"n_rows":38,"n_cols":8,"rows_kept":38,"merged":[[1,0,1,6],[2,0,2,6],[3,0,3,6],[4,6,4,7],[6,0,7,0],[6,1,7,1],[6,3,7,3],[6,4,7,4],[6,5,7,5],[6,6,7,6],[37,3,38,4],[37,5,38,6]]}
[]
["CITY OF BEAUFORT"]
["CTC RESURFACING - Phase I"]
[]
[]
[]
["ITEM #","DESCRIPTION",null,"UNIT","QUANTITY","UNIT PRICE","TOTAL PRICE"]
[]
[1,"Mobilization",{"$f":"A9","v":1},"LS",{"$f":"SUM('Charles St Ext'!E11,'Craven St'!E12,'Jericho Woods SD'!E11,'Stone Marten'!E11,'Schein Loop'!E12)","v":{"v":1,"d":"1.00"}},null,{"$f":"'Charles St Ext'!G11+'Craven St'!G12+'Jericho Woods SD'!G11+'Stone Marten'!G11+'Schein Loop'!G12","v":{"v":0,"d":"$0.00"}},{"v":0.2,"d":"20%"}]
[2,"Bonds & Insurance",{"$f":"A10","v":2},"LS",{"$f":"SUM('Charles St Ext'!E12,'Craven St'!E13,'Jericho Woods SD'!E12,'Stone Marten'!E12,'Schein Loop'!E13)","v":{"v":1,"d":"1.00"}},null,{"$f":"E10*F10","v":{"v":0,"d":"$0.00"}},{"v":0.02,"d":"2%"}]
[3,"Construction Stakes, Lines, & Grades",3,"LS",{"$f":"SUM('Charles St Ext'!E13,'Craven St'!E14,'Jericho Woods SD'!E13,'Stone Marten'!E13,'Schein Loop'!E14)","v":{"v":1,"d":"1.00"}},null,{"v":0,"d":"$0.00"},{"v":0.1,"d":"10%"}]
[4,"Traffic Control",4,"LS",{"$f":"SUM('Charles St Ext'!E14,'Craven St'!E15,'Jericho Woods SD'!E14,'Stone Marten'!E14,'Schein Loop'!E15)","v":{"v":1,"d":"1.00"}},null,{"v":0,"d":"$0.00"},{"v":0.15,"d":"15%"}]
[5,"Borrow Excavation",{"$f":"VLOOKUP(B13,'Total Quantities'!B8:C37,2,FALSE)","v":5},"CY",{"$f":"SUM('Charles St Ext'!E37,'Craven St'!E40,'Jericho Woods SD'!E15,'Jericho Woods SD'!E37,'Stone Marten'!E15,'Stone Marten'!E33,'Schein Loop'!E16)","v":580},null,{"v":0,"d":"$0.00"}]
[6,"Maintenance Stone",{"$f":"VLOOKUP(B14,'Total Quantities'!B9:C38,2,FALSE)","v":5},"TON",{"$f":"SUM('Schein Loop'!E17)","v":20},null,{"v":0,"d":"$0.00"}]
[7,"Removal & Disposal of Existing Curb",{"$f":"A15","v":7},"SY",{"$f":"+'Craven St'!E16","v":70},null,{"v":0,"d":"$0.00"}]
[8,"Concrete Curb and Gutter (3'-0\") Sloping Face",null,"LF",{"$f":"+SUM('Craven St'!E17)","v":200},null,{"v":0,"d":"$0.00"}]
[9,"Mill Existing Asphalt Pavement (variable depth)",{"$f":"VLOOKUP(B17,'Total Quantities'!B12:C40,2,FALSE)","v":11},"SY",{"$f":"+SUM('Charles St Ext'!E15,'Craven St'!E18,'Jericho Woods SD'!E16,'Schein Loop'!E18)","v":2435},null,{"v":0,"d":"$0.00"}]
[10,"Full Depth HMA Patching 6\" Uniform",{"$f":"VLOOKUP(B18,'Total Quantities'!B13:C41,2,FALSE)","v":12},"SY",{"$f":"SUM('Charles St Ext'!E16,'Charles St Ext'!E38,'Craven St'!E19,'Jericho Woods SD'!E17,'Jericho Woods SD'!E38,'Stone Marten'!E16,'Stone Marten'!E34,'Schein Loop'!E19)","v":1150},null,{"v":0,"d":"$0.00"}]
[11,"Liquid Asphalt Binder PG64-22",{"$f":"VLOOKUP(B19,'Total Quantities'!B15:C42,2,FALSE)","v":13},"TON",{"$f":"+SUM('Charles St Ext'!E17,'Charles St Ext'!E39,'Craven St'!E20,'Craven St'!E41,'Jericho Woods SD'!E18,'Jericho Woods SD'!E39,'Stone Marten'!E17,'Stone Marten'!E35,'Schein Loop'!E20)","v":{"v":131.5,"d":"131.50"}},null,{"v":0,"d":"$0.00"}]
[12,"H/M Asph. Surf. Cr. Type D (150 lbs/sy)",{"$f":"VLOOKUP(B20,'Total Quantities'!B17:C44,2,FALSE)","v":17},"TON",{"$f":"+SUM('Charles St Ext'!E18,'Charles St Ext'!E40,'Craven St'!E21,'Craven St'!E42,'Jericho Woods SD'!E19,'Jericho Woods SD'!E40,'Stone Marten'!E18,'Stone Marten'!E36)","v":{"v":1110,"d":"1110.00"}},null,{"v":0,"d":"$0.00"}]
[13,"H/M Asph. Surf. Cr. Type B (200 lbs/sy)",null,"TON",{"$f":"'Schein Loop'!E21","v":{"v":890,"d":"890.00"}},null,{"v":0,"d":"$0.00"}]
[14,"H/M Asph. Surf. Cr. Type E (Varies)",null,"TON",{"$f":"'Schein Loop'!E22","v":{"v":200,"d":"200.00"}},null,{"v":0,"d":"$0.00"}]
[15,"Permanent Construction Signs (Ground Mounted)",null,"SF",{"$f":"'Schein Loop'!E23","v":{"v":152,"d":"152.00"}},null,{"v":0,"d":"$0.00"}]
[16,"8\" White Solid Lines(Crosswalk) Fast Dry Paint",null,"LF",{"$f":"+SUM('Craven St'!E22)","v":50},null,{"v":0,"d":"$0.00"}]
[17,"4\" White Solid Lines (Pavement Edge Lines) Fast Dry Paint",{"$f":"VLOOKUP(B25,'Total Quantities'!B19:C47,2,FALSE)","v":21},"LF",{"$f":"+SUM('Charles St Ext'!E19,'Jericho Woods SD'!E20,'Schein Loop'!E24)","v":6480},null,{"v":0,"d":"$0.00"}]
[18,"24\" White Solid Lines (Stop) Fast Dry Paint",{"$f":"VLOOKUP(B26,'Total Quantities'!B20:C48,2,FALSE)","v":24},"LF",{"$f":"+SUM('Charles St Ext'!E20,'Charles St Ext'!E41,'Craven St'!E23,'Craven St'!E43,'Jericho Woods SD'!E21,'Jericho Woods SD'!E41,'Stone Marten'!E19,'Stone Marten'!E37,'Schein Loop'!E25)","v":273},null,{"v":0,"d":"$0.00"}]
[19,"4\" Yellow Solid Line (No Passing Zone) Fast Dry Paint",{"$f":"VLOOKUP(B27,'Total Quantities'!B20:C49,2,FALSE)","v":25},"LF",{"$f":"+SUM('Charles St Ext'!E21,'Schein Loop'!E26)","v":6976},null,{"v":0,"d":"$0.00"}]
[20,"Restripe Yellow Curb - Fast Dry Paint",null,"LF",{"$f":"+SUM('Craven St'!E24)","v":800},null,{"v":0,"d":"$0.00"}]
[21,"4\" White Solid Lines (Pavement Edge Lines) Thermoplastic-90 mil",{"$f":"VLOOKUP(B29,'Total Quantities'!B20:C51,2,FALSE)","v":27},"LF",{"$f":"+SUM('Charles St Ext'!E22,'Jericho Woods SD'!E22,'Schein Loop'!E27)","v":6480},null,{"v":0,"d":"$0.00"}]
[22,"24\" White Solid Lines (Stop/Diag Lines) Thermoplastic-125 mil",{"$f":"VLOOKUP(B30,'Total Quantities'!B25:C52,2,FALSE)","v":31},"LF",{"$f":"+SUM('Charles St Ext'!E23,'Charles St Ext'!E42,'Craven St'!E25,'Craven St'!E44,'Jericho Woods SD'!E23,'Jericho Woods SD'!E42,'Stone Marten'!E20,'Stone Marten'!E38,'Schein Loop'!E28)","v":273},null,{"v":0,"d":"$0.00"}]
[23,"4\" Yellow Solid Line (No Passing Zone) Thermoplastic-90 mil",{"$f":"VLOOKUP(B31,'Total Quantities'!B26:C53,2,FALSE)","v":32},"LF",{"$f":"+SUM('Charles St Ext'!E24,'Craven St'!E26,'Schein Loop'!E29)","v":7276},null,{"v":0,"d":"$0.00"}]
[24,"8\" White Solid Lines Thermoplastic - 125 MIL.",null,"LF",{"$f":"+SUM('Craven St'!E27)","v":50},null,{"v":0,"d":"$0.00"}]
[25,"Permanent Yellow Pavement Markers Bi-Dir.-4\"x4\"",{"$f":"VLOOKUP(B33,'Total Quantities'!B30:C56,2,FALSE)","v":41},"EA",{"$f":"+SUM('Charles St Ext'!E25,'Craven St'!E28,'Schein Loop'!E30)","v":49},null,{"v":0,"d":"$0.00"}]
[26,"Permanent Clear Pavement Markers Mono.-4\"x4\"",{"$f":"VLOOKUP(B34,'Total Quantities'!B34:C59,2,FALSE)","v":{"$error":"#N/A"}},"EA",{"$f":"+SUM('Jericho Woods SD'!E24)","v":14},null,{"v":0,"d":"$0.00"}]
[27,"36\" RCP (Remove & Replace)",null,"LF",{"$f":"'Schein Loop'!E31","v":48},null,{"v":0,"d":"$0.00"}]
[28,"42\" RCP (Remove & Replace)",null,"LF",{"$f":"'Schein Loop'!E32","v":64},null,{"v":0,"d":"$0.00"}]
[29,"Permanent Vegetation",{"$f":"VLOOKUP(B37,'Total Quantities'!B31:C57,2,FALSE)","v":42},"MSY",{"$f":"+SUM('Charles St Ext'!E43,'Craven St'!E45,'Jericho Woods SD'!E25,'Jericho Woods SD'!E43,'Stone Marten'!E21,'Stone Marten'!E39,'Schein Loop'!E33)","v":{"v":7.025,"d":"7.03"}},null,{"$f":"E37*F37","v":{"v":0,"d":"$0.00"}}]
[null,null,{"$f":"A38","v":0},"TOTAL",null,{"$f":"SUM(G9:G37)","v":{"v":0,"d":"$0.00"}}]

{"sheet":"Charles St Ext","index":1,"n_rows":47,"n_cols":10,"rows_kept":47,"merged":[[0,16,0,17],[8,0,9,0],[8,1,9,1],[8,3,9,3],[8,4,9,4],[8,5,9,5],[8,6,9,6],[25,5,26,5],[25,6,26,6],[34,0,35,0],[34,1,35,1],[34,3,35,3],[34,4,35,4],[34,5,35,5],[34,6,35,6],[43,5,44,5],[43,6,44,6],[46,5,47,5],[46,6,47,6]]}
["Charles Street"]
[]
["Section 1 of 2"]
["Start:","Charles Street (@ US-21)"]
["Stop:","Charles Street (@ Calhoun St)- Tie down at Calhoun, don't pull across"]
["Road Length:","      .06 mi"]
["Original Width:     31 ft          Widen Left:   0 ft            Widen Right:   0 ft          Final Width:   31 ft"]
[]
["ITEM #","DESCRIPTION",null,"UNIT","QUANTITY","UNIT PRICE","TOTAL PRICE",null,"Proposed Width [ft]",28]
[{"$nulls":8},"Pavement Area [sy]",{"$f":"(#REF!*J9)/9","v":{"$error":"#REF!"}}]
[1,"Mobilization",{"$f":"A11","v":1},"LS",{"v":0.2,"d":"0.20"},{"$f":"'Total Quantities'!F9","v":{"v":0,"d":"$0.00"}},{"$f":"E11*F11","v":{"v":0,"d":"$0.00"}}]
[2,"Bonds & Insurance",{"$f":"A12","v":2},"LS",{"v":0.2,"d":"0.20"},{"$f":"'Total Quantities'!F10","v":{"v":0,"d":"$0.00"}},{"$f":"E12*F12","v":{"v":0,"d":"$0.00"}}]
[3,"Construction Stakes, Lines, & Grades",3,"LS",{"v":0.2,"d":"0.20"},{"$f":"'Total Quantities'!F11","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[4,"Traffic Control",4,"LS",{"v":0.2,"d":"0.20"},{"$f":"'Total Quantities'!F12","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[9,"Mill Existing Asphalt Pavement (variable depth)",{"$f":"VLOOKUP(B15,'Total Quantities'!B16:C43,2,FALSE)","v":11},"SY",210,{"$f":"'Total Quantities'!F17","v":{"v":0,"d":"$0.00"}},{"$f":"F15*E15","v":{"v":0,"d":"$0.00"}}]
[10,"Full Depth HMA Patching 6\" Uniform",{"$f":"VLOOKUP(B16,'Total Quantities'!B17:C44,2,FALSE)","v":12},"SY",15,{"$f":"'Total Quantities'!F18","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[11,"Liquid Asphalt Binder PG64-22",{"$f":"VLOOKUP(B17,'Total Quantities'!B17:C45,2,FALSE)","v":13},"TON",{"v":5,"d":"5.000"},{"$f":"'Total Quantities'!F19","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[12,"H/M Asph. Surf. Cr. Type D (150 lbs/sy)",{"$f":"VLOOKUP(B18,'Total Quantities'!B19:C47,2,FALSE)","v":{"$error":"#N/A"}},"TON",{"v":80,"d":"80.00"},{"$f":"'Total Quantities'!F20","v":{"v":0,"d":"$0.00"}},{"$f":"F18*E18","v":{"v":0,"d":"$0.00"}},"Rate",80]
[17,"4\" White Solid Lines (Pavement Edge Lines) Fast Dry Paint",{"$f":"VLOOKUP(B19,'Total Quantities'!B20:C50,2,FALSE)","v":21},"LF",30,{"$f":"'Total Quantities'!F25","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[18,"24\" White Solid Lines (Stop) Fast Dry Paint",{"$f":"VLOOKUP(B20,'Total Quantities'!B25:C51,2,FALSE)","v":24},"LF",62,{"$f":"'Total Quantities'!F26","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[19,"4\" Yellow Solid Line (No Passing Zone) Fast Dry Paint",{"$f":"VLOOKUP(B21,'Total Quantities'!B25:C52,2,FALSE)","v":25},"LF",626,{"$f":"'Total Quantities'!F27","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[21,"4\" White Solid Lines (Pavement Edge Lines) Thermoplastic-90 mil",{"$f":"VLOOKUP(B22,'Total Quantities'!B26:C54,2,FALSE)","v":27},"LF",30,{"$f":"'Total Quantities'!F29","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[22,"24\" White Solid Lines (Stop/Diag Lines) Thermoplastic-125 mil",{"$f":"VLOOKUP(B23,'Total Quantities'!B27:C55,2,FALSE)","v":31},"LF",62,{"$f":"'Total Quantities'!F30","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[23,"4\" Yellow Solid Line (No Passing Zone) Thermoplastic-90 mil",{"$f":"VLOOKUP(B24,'Total Quantities'!B30:C56,2,FALSE)","v":32},"LF",626,{"$f":"'Total Quantities'!F31","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[25,"Permanent Yellow Pavement Markers Bi-Dir.-4\"x4\"",{"$f":"VLOOKUP(B25,'Total Quantities'!B34:C59,2,FALSE)","v":{"$error":"#N/A"}},"EA",4,{"$f":"'Total Quantities'!F33","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[{"$nulls":5}," SUB-TOTAL =",{"$f":"SUM(G11:G25)","v":{"v":0,"d":"$0.00"}}]
[]
[]
["Section 2 of 2"]
["Start:","Charles Street (@ Calhoun St)"]
["Stop:","Charles Street (end of road)"]
["Road Length:","      .09 mi"]
["Original Width:     18 ft          Widen Left:   0 ft            Widen Right:   0 ft          Final Width:   18 ft"]
[]
["ITEM #","DESCRIPTION",null,"UNIT","QUANTITY","UNIT PRICE","TOTAL PRICE",null,"Proposed Width [ft]",28]
[{"$nulls":8},"Pavement Area [sy]",{"$f":"(#REF!*J35)/9","v":{"$error":"#REF!"}}]
[5,"Borrow Excavation",{"$f":"VLOOKUP(B37,'Total Quantities'!B44:C67,2,FALSE)","v":{"$error":"#N/A"}},"CY",30,{"$f":"'Total Quantities'!F13","v":{"v":0,"d":"$0.00"}},{"$f":"F37*E37","v":{"v":0,"d":"$0.00"}}]
[10,"Full Depth HMA Patching 6\" Uniform",{"$f":"VLOOKUP(B38,'Total Quantities'!B49:C75,2,FALSE)","v":{"$error":"#N/A"}},"SY",135,{"$f":"'Total Quantities'!F18","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[11,"Liquid Asphalt Binder PG64-22",{"$f":"VLOOKUP(B39,'Total Quantities'!B49:C76,2,FALSE)","v":{"$error":"#N/A"}},"TON",{"v":5,"d":"5.00"},{"$f":"'Total Quantities'!F19","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[12,"H/M Asph. Surf. Cr. Type D (150 lbs/sy)",{"$f":"VLOOKUP(B40,'Total Quantities'!B51:C78,2,FALSE)","v":{"$error":"#N/A"}},"TON",{"v":75,"d":"75.00"},{"$f":"'Total Quantities'!F20","v":{"v":0,"d":"$0.00"}},{"$f":"F40*E40","v":{"v":0,"d":"$0.00"}},"Rate",80]
[18,"24\" White Solid Lines (Stop) Fast Dry Paint",{"$f":"VLOOKUP(B41,'Total Quantities'!B54:C82,2,FALSE)","v":{"$error":"#N/A"}},"LF",20,{"$f":"'Total Quantities'!F26","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[22,"24\" White Solid Lines (Stop/Diag Lines) Thermoplastic-125 mil",{"$f":"VLOOKUP(B42,'Total Quantities'!B56:C86,2,FALSE)","v":{"$error":"#N/A"}},"LF",20,{"$f":"'Total Quantities'!F30","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[29,"Permanent Vegetation",{"$f":"VLOOKUP(B43,'Total Quantities'!B65:C92,2,FALSE)","v":{"$error":"#N/A"}},"MSY",0.35,{"$f":"'Total Quantities'!F37","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[{"$nulls":5}," SUB-TOTAL =",{"$f":"SUM(G37:G42)","v":{"v":0,"d":"$0.00"}}]
[]
[]
[{"$nulls":5},"ROAD TOTAL =",{"$f":"+SUM(G44,G26)","v":{"v":0,"d":"$0.00"}}]

{"sheet":"Craven St","index":2,"n_rows":49,"n_cols":13,"rows_kept":49,"merged":[[0,8,0,9],[9,0,10,0],[9,1,10,1],[9,3,10,3],[9,4,10,4],[9,5,10,5],[9,6,10,6],[28,5,29,5],[28,6,29,6],[37,0,38,0],[37,1,38,1],[37,3,38,3],[37,4,38,4],[37,5,38,5],[37,6,38,6],[45,5,46,5],[45,6,46,6],[48,5,49,5],[48,6,49,6]]}
["Craven Street ",{"$nulls":7},"Road Dimensions"]
[]
["Section 1 of 2"]
["Start:","Craven Street (@ Carteret) "]
["Stop:","Craven Street (@ East Street) "]
["State Road #","S-7-62"]
["Road Length:",".10 mi."]
["Original Width:     25 ft          Widen Left:   0 ft            Widen Right:   0 ft          Final Width:   25 ft"]
[{"$nulls":8},"Total Length [ft]",{"v":6750,"d":"6,750"},null,{"$f":"J9/5280","v":{"v":1.2784090909090908,"d":"1.28"}},"[mi]"]
["ITEM #","DESCRIPTION",null,"UNIT","QUANTITY","UNIT PRICE","TOTAL PRICE",null,"Pavement Area [sy]",{"$f":"(J9*#REF!)/9","v":{"$error":"#REF!"}}]
[]
[1,"Mobilization",{"$f":"A12","v":1},"LS",{"v":0.2,"d":"0.20"},{"$f":"'Total Quantities'!F9","v":{"v":0,"d":"$0.00"}},{"$f":"E12*F12","v":{"v":0,"d":"$0.00"}}]
[2,"Bonds & Insurance",{"$f":"A13","v":2},"LS",{"v":0.2,"d":"0.20"},{"$f":"'Total Quantities'!F10","v":{"v":0,"d":"$0.00"}},{"$f":"E13*F13","v":{"v":0,"d":"$0.00"}}]
[3,"Construction Stakes, Lines, & Grades",3,"LS",{"v":0.2,"d":"0.20"},{"$f":"'Total Quantities'!F11","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[4,"Traffic Control",4,"LS",{"v":0.2,"d":"0.20"},{"$f":"'Total Quantities'!F12","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[7,"Removal & Disposal of Existing Curb",7,"SY",70,{"$f":"'Total Quantities'!F15","v":{"v":0,"d":"$0.00"}},{"$f":"E16*F16","v":{"v":0,"d":"$0.00"}}]
[8,"Concrete Curb and Gutter (3'-0\") Sloping Face",null,"LF",200,{"$f":"'Total Quantities'!F16","v":{"v":0,"d":"$0.00"}},{"$f":"E17*F17","v":{"v":0,"d":"$0.00"}}]
[9,"Mill Existing Asphalt Pavement (variable depth)",{"$f":"VLOOKUP(B18,'Total Quantities'!B16:C43,2,FALSE)","v":11},"SY",1700,{"$f":"'Total Quantities'!F17","v":{"v":0,"d":"$0.00"}},{"$f":"F18*E18","v":{"v":0,"d":"$0.00"}}]
[10,"Full Depth HMA Patching 6\" Uniform",{"$f":"VLOOKUP(B19,'Total Quantities'!B17:C44,2,FALSE)","v":12},"SY",30,{"$f":"'Total Quantities'!F18","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[11,"Liquid Asphalt Binder PG64-22",{"$f":"VLOOKUP(B20,'Total Quantities'!B17:C45,2,FALSE)","v":13},"TON",{"v":7,"d":"7.00"},{"$f":"'Total Quantities'!F19","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},"Rate",80]
[12,"H/M Asph. Surf. Cr. Type D (150 lbs/sy)",{"$f":"VLOOKUP(B21,'Total Quantities'!B19:C47,2,FALSE)","v":{"$error":"#N/A"}},"TON",{"v":115,"d":"115.00"},{"$f":"'Total Quantities'!F20","v":{"v":0,"d":"$0.00"}},{"$f":"F21*E21","v":{"v":0,"d":"$0.00"}}]
[16,"8\" White Solid Lines(Crosswalk) Fast Dry Paint",null,"LF",50,{"$f":"'Total Quantities'!F24","v":{"v":0,"d":"$0.00"}},{"$f":"F22*E22","v":{"v":0,"d":"$0.00"}}]
[18,"24\" White Solid Lines (Stop) Fast Dry Paint",{"$f":"VLOOKUP(B23,'Total Quantities'!B25:C51,2,FALSE)","v":24},"LF",50,{"$f":"'Total Quantities'!F26","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[20,"Restripe Yellow Curb - Fast Dry Paint",null,"LF",800,{"$f":"'Total Quantities'!F28","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[22,"24\" White Solid Lines (Stop/Diag Lines) Thermoplastic-125 mil",{"$f":"VLOOKUP(B25,'Total Quantities'!B27:C55,2,FALSE)","v":31},"LF",50,{"$f":"'Total Quantities'!F30","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[23,"4\" Yellow Solid Line (No Passing Zone) Thermoplastic-90 mil",{"$f":"VLOOKUP(B26,'Total Quantities'!B30:C56,2,FALSE)","v":32},"LF",800,{"$f":"'Total Quantities'!F31","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[24,"8\" White Solid Lines Thermoplastic - 125 MIL.",null,"LF",50,{"$f":"'Total Quantities'!F32","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[25,"Permanent Yellow Pavement Markers Bi-Dir.-4\"x4\"",{"$f":"VLOOKUP(B28,'Total Quantities'!B34:C59,2,FALSE)","v":{"$error":"#N/A"}},"EA",7,{"$f":"'Total Quantities'!F33","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[{"$nulls":5},"SUB-TOTAL",{"$f":"SUM(G12:G28)","v":{"v":0,"d":"$0.00"}}]
[]
[]
["Section 2 of 2"]
["Start:","Craven Street (@ East St)"]
["Stop:","Craven Street (end of road)"]
["Road Length:",".018 mi."]
["Original Width:     20 ft          Widen Left:   0 ft            Widen Right:   0 ft          Final Width:   20 ft"]
[]
["ITEM #","DESCRIPTION",null,"UNIT","QUANTITY","UNIT PRICE","TOTAL PRICE"]
[]
[5,"Borrow Excavation",{"$f":"VLOOKUP(B40,'Total Quantities'!B45:C68,2,FALSE)","v":{"$error":"#N/A"}},"CY",10,{"$f":"'Total Quantities'!F13","v":{"v":0,"d":"$0.00"}},{"$f":"F40*E40","v":{"v":0,"d":"$0.00"}}]
[11,"Liquid Asphalt Binder PG64-22",{"$f":"VLOOKUP(B41,'Total Quantities'!B50:C77,2,FALSE)","v":{"$error":"#N/A"}},"TON",{"v":1.5,"d":"1.50"},{"$f":"'Total Quantities'!F19","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[12,"H/M Asph. Surf. Cr. Type D (150 lbs/sy)",{"$f":"VLOOKUP(B42,'Total Quantities'!B52:C79,2,FALSE)","v":{"$error":"#N/A"}},"TON",{"v":20,"d":"20.00"},{"$f":"'Total Quantities'!F20","v":{"v":0,"d":"$0.00"}},{"$f":"F42*E42","v":{"v":0,"d":"$0.00"}}]
[18,"24\" White Solid Lines (Stop) Fast Dry Paint",{"$f":"VLOOKUP(B43,'Total Quantities'!B51:C79,2,FALSE)","v":{"$error":"#N/A"}},"LF",12,{"$f":"'Total Quantities'!F26","v":{"v":0,"d":"$0.00"}},{"$f":"F43*E43","v":{"v":0,"d":"$0.00"}}]
[22,"24\" White Solid Lines (Stop/Diag Lines) Thermoplastic-125 mil",{"$f":"VLOOKUP(B44,'Total Quantities'!B53:C83,2,FALSE)","v":{"$error":"#N/A"}},"LF",12,{"$f":"'Total Quantities'!F30","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[29,"Permanent Vegetation",{"$f":"VLOOKUP(B45,'Total Quantities'!B65:C92,2,FALSE)","v":{"$error":"#N/A"}},"MSY",{"v":0.075,"d":"0.08"},{"$f":"'Total Quantities'!F37","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[{"$nulls":5},"SUB-TOTAL",{"$f":"SUM(G40:G45)","v":{"v":0,"d":"$0.00"}}]
[]
[]
[{"$nulls":5},"ROAD TOTAL =",{"$f":"+SUM(G46,G29)","v":{"v":0,"d":"$0.00"}}]

{"sheet":"Jericho Woods SD","index":3,"n_rows":47,"n_cols":13,"rows_kept":47,"merged":[[0,8,0,9],[8,0,9,0],[8,1,9,1],[8,3,9,3],[8,4,9,4],[8,5,9,5],[8,6,9,6],[25,5,26,5],[25,6,26,6],[28,8,28,9],[34,0,35,0],[34,1,35,1],[34,3,35,3],[34,4,35,4],[34,5,35,5],[34,6,35,6],[43,5,44,5],[43,6,44,6],[46,5,47,5],[46,6,47,6]]}
["Jericho Woods Subdivision",{"$nulls":7},"Road Dimensions"]
[]
["Jericho Woods Road"]
["Start:","Jericho Woods (Entrance @ Battery Creek Road)"]
["Stop:","Jericho Woods (Exit @ Battery Creek Road)"]
["Road Length:","0.31 mi."]
["Original Width:     22 ft          Widen Left:   0 ft            Widen Right:   0 ft          Final Width:   22 ft"]
[]
["ITEM #","DESCRIPTION",null,"UNIT","QUANTITY","UNIT PRICE","TOTAL PRICE",null,"Proposed Width [ft]",28]
[{"$nulls":8},"Pavement Area [sy]",{"$f":"(#REF!*J9)/9","v":{"$error":"#REF!"}}]
[1,"Mobilization",{"$f":"A11","v":1},"LS",{"v":0.2,"d":"0.20"},{"$f":"'Total Quantities'!F9","v":{"v":0,"d":"$0.00"}},{"$f":"E11*F11","v":{"v":0,"d":"$0.00"}}]
[2,"Bonds & Insurance",{"$f":"A12","v":2},"LS",{"v":0.2,"d":"0.20"},{"$f":"'Total Quantities'!F10","v":{"v":0,"d":"$0.00"}},{"$f":"E12*F12","v":{"v":0,"d":"$0.00"}}]
[3,"Construction Stakes, Lines, & Grades",3,"LS",{"v":0.2,"d":"0.20"},{"$f":"'Total Quantities'!F11","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[4,"Traffic Control",4,"LS",{"v":0.2,"d":"0.20"},{"$f":"'Total Quantities'!F12","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[5,"Borrow Excavation",{"$f":"VLOOKUP(B15,'Total Quantities'!B11:C39,2,FALSE)","v":5},"CY",100,{"$f":"'Total Quantities'!F13","v":{"v":0,"d":"$0.00"}},{"$f":"F15*E15","v":{"v":0,"d":"$0.00"}}]
[9,"Mill Existing Asphalt Pavement (variable depth)",{"$f":"VLOOKUP(B16,'Total Quantities'!B16:C43,2,FALSE)","v":11},"SY",375,{"$f":"'Total Quantities'!F17","v":{"v":0,"d":"$0.00"}},{"$f":"F16*E16","v":{"v":0,"d":"$0.00"}}]
[10,"Full Depth HMA Patching 6\" Uniform",{"$f":"VLOOKUP(B17,'Total Quantities'!B17:C44,2,FALSE)","v":12},"SY",15,{"$f":"'Total Quantities'!F18","v":{"v":0,"d":"$0.00"}},{"$f":"F17*E17","v":{"v":0,"d":"$0.00"}}]
[11,"Liquid Asphalt Binder PG64-22",{"$f":"VLOOKUP(B18,'Total Quantities'!B17:C45,2,FALSE)","v":13},"TON",{"v":21,"d":"21.00"},{"$f":"'Total Quantities'!F19","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},"Rate",450]
[12,"H/M Asph. Surf. Cr. Type D (150 lbs/sy)",{"$f":"VLOOKUP(B19,'Total Quantities'!B19:C47,2,FALSE)","v":{"$error":"#N/A"}},"TON",{"v":330,"d":"330.00"},{"$f":"'Total Quantities'!F20","v":{"v":0,"d":"$0.00"}},{"$f":"F19*E19","v":{"v":0,"d":"$0.00"}}]
[17,"4\" White Solid Lines (Pavement Edge Lines) Fast Dry Paint",{"$f":"VLOOKUP(B20,'Total Quantities'!B20:C50,2,FALSE)","v":21},"LF",100,{"$f":"'Total Quantities'!F25","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[18,"24\" White Solid Lines (Stop) Fast Dry Paint",{"$f":"VLOOKUP(B21,'Total Quantities'!B25:C51,2,FALSE)","v":24},"LF",64,{"$f":"'Total Quantities'!F26","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[21,"4\" White Solid Lines (Pavement Edge Lines) Thermoplastic-90 mil",{"$f":"VLOOKUP(B22,'Total Quantities'!B26:C54,2,FALSE)","v":27},"LF",100,{"$f":"'Total Quantities'!F29","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[22,"24\" White Solid Lines (Stop/Diag Lines) Thermoplastic-125 mil",{"$f":"VLOOKUP(B23,'Total Quantities'!B27:C55,2,FALSE)","v":31},"LF",64,{"$f":"'Total Quantities'!F30","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[26,"Permanent Clear Pavement Markers Mono.-4\"x4\"",{"$f":"VLOOKUP(B24,'Total Quantities'!B30:C56,2,FALSE)","v":{"$error":"#N/A"}},"EA",14,{"$f":"'Total Quantities'!F34","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[29,"Permanent Vegetation",{"$f":"VLOOKUP(B25,'Total Quantities'!B40:C65,2,FALSE)","v":{"$error":"#N/A"}},"MSY",1.15,{"$f":"'Total Quantities'!F37","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[{"$nulls":5},"SUB-TOTAL",{"$f":"SUM(G11:G24)","v":{"v":0,"d":"$0.00"}}]
[]
[]
["Joshua Circle",{"$nulls":7},"Road Dimensions"]
["Start:","Joshua Circle (start @Jericho Woods) "]
["Stop:","Joshua Circle (end @Jericho Woods) "]
["Road Length:","0.16 mi."]
["Original Width:     22 ft          Widen Left:   0 ft            Widen Right:   0 ft          Final Width:   22 ft"]
[]
["ITEM #","DESCRIPTION",null,"UNIT","QUANTITY","UNIT PRICE","TOTAL PRICE",null,"Total Length [ft]",{"v":6750,"d":"6,750"},null,{"$f":"J35/5280","v":{"v":1.2784090909090908,"d":"1.28"}},"[mi]"]
[{"$nulls":8},"Proposed Width [ft]",28]
[5,"Borrow Excavation",{"$f":"VLOOKUP(B37,'Total Quantities'!B44:C67,2,FALSE)","v":{"$error":"#N/A"}},"CY",60,{"$f":"'Total Quantities'!F13","v":{"v":0,"d":"$0.00"}},{"$f":"F37*E37","v":{"v":0,"d":"$0.00"}}]
[10,"Full Depth HMA Patching 6\" Uniform",{"$f":"VLOOKUP(B38,'Total Quantities'!B49:C75,2,FALSE)","v":{"$error":"#N/A"}},"SY",80,{"$f":"'Total Quantities'!F18","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[11,"Liquid Asphalt Binder PG64-22",{"$f":"VLOOKUP(B39,'Total Quantities'!B49:C76,2,FALSE)","v":{"$error":"#N/A"}},"TON",{"v":13,"d":"13.00"},{"$f":"'Total Quantities'!F19","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[12,"H/M Asph. Surf. Cr. Type D (150 lbs/sy)",{"$f":"VLOOKUP(B40,'Total Quantities'!B51:C78,2,FALSE)","v":{"$error":"#N/A"}},"TON",{"v":195,"d":"195.00"},{"$f":"'Total Quantities'!F20","v":{"v":0,"d":"$0.00"}},{"$f":"F40*E40","v":{"v":0,"d":"$0.00"}},"Rate",450]
[18,"24\" White Solid Lines (Stop) Fast Dry Paint",{"$f":"VLOOKUP(B41,'Total Quantities'!B54:C82,2,FALSE)","v":{"$error":"#N/A"}},"LF",15,{"$f":"'Total Quantities'!F26","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[22,"24\" White Solid Lines (Stop/Diag Lines) Thermoplastic-125 mil",{"$f":"VLOOKUP(B42,'Total Quantities'!B56:C86,2,FALSE)","v":{"$error":"#N/A"}},"LF",15,{"$f":"'Total Quantities'!F30","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[29,"Permanent Vegetation",{"$f":"VLOOKUP(B43,'Total Quantities'!B64:C91,2,FALSE)","v":{"$error":"#N/A"}},"MSY",0.75,{"$f":"'Total Quantities'!F37","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[{"$nulls":5},"SUB-TOTAL",{"$f":"SUM(G37:G42)","v":{"v":0,"d":"$0.00"}}]
[]
[]
[{"$nulls":5},"ROAD TOTAL =",{"$f":"+SUM(G44,G26)","v":{"v":0,"d":"$0.00"}}]

{"sheet":"Stone Marten","index":4,"n_rows":43,"n_cols":13,"rows_kept":43,"merged":[[0,8,0,9],[8,0,9,0],[8,1,9,1],[8,3,9,3],[8,4,9,4],[8,5,9,5],[8,6,9,6],[21,5,22,5],[21,6,22,6],[24,8,24,9],[30,0,31,0],[30,1,31,1],[30,3,31,3],[30,4,31,4],[30,5,31,5],[30,6,31,6],[39,5,40,5],[39,6,40,6],[42,5,43,5],[42,6,43,6]]}
["Stone Marten Subdivision",{"$nulls":7},"Road Dimensions"]
[]
["Stone Marten Drive"]
["Start:","Stone Marten Drive (end @ Mink Point Blvd) "]
["Stop:","Stone Marten Drive (start @ Mink Point Blvd) "]
["Road Length:","0.23 mi."]
["Original Width:     20 ft          Widen Left:   0 ft            Widen Right:   0 ft          Final Width:   20 ft"]
[]
["ITEM #","DESCRIPTION",null,"UNIT","QUANTITY","UNIT PRICE","TOTAL PRICE",null,"Proposed Width [ft]",28]
[{"$nulls":8},"Pavement Area [sy]",{"$f":"(#REF!*J9)/9","v":{"$error":"#REF!"}}]
[1,"Mobilization",{"$f":"A11","v":1},"LS",{"v":0.2,"d":"0.20"},{"$f":"'Total Quantities'!F9","v":{"v":0,"d":"$0.00"}},{"$f":"E11*F11","v":{"v":0,"d":"$0.00"}}]
[2,"Bonds & Insurance",{"$f":"A12","v":2},"LS",{"v":0.2,"d":"0.20"},{"$f":"'Total Quantities'!F10","v":{"v":0,"d":"$0.00"}},{"$f":"E12*F12","v":{"v":0,"d":"$0.00"}}]
[3,"Construction Stakes, Lines, & Grades",3,"LS",{"v":0.2,"d":"0.20"},{"$f":"'Total Quantities'!F11","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[4,"Traffic Control",4,"LS",{"v":0.2,"d":"0.20"},{"$f":"'Total Quantities'!F12","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[5,"Borrow Excavation",{"$f":"VLOOKUP(B15,'Total Quantities'!B11:C39,2,FALSE)","v":5},"CY",80,{"$f":"'Total Quantities'!F13","v":{"v":0,"d":"$0.00"}},{"$f":"F15*E15","v":{"v":0,"d":"$0.00"}}]
[10,"Full Depth HMA Patching 6\" Uniform",{"$f":"VLOOKUP(B16,'Total Quantities'!B17:C44,2,FALSE)","v":12},"SY",75,{"$f":"'Total Quantities'!F18","v":{"v":0,"d":"$0.00"}},{"$f":"F16*E16","v":{"v":0,"d":"$0.00"}}]
[11,"Liquid Asphalt Binder PG64-22",{"$f":"VLOOKUP(B17,'Total Quantities'!B17:C45,2,FALSE)","v":13},"TON",{"v":15,"d":"15.00"},{"$f":"'Total Quantities'!F19","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},"Rate",450]
[12,"H/M Asph. Surf. Cr. Type D (150 lbs/sy)",{"$f":"VLOOKUP(B18,'Total Quantities'!B19:C47,2,FALSE)","v":{"$error":"#N/A"}},"TON",{"v":235,"d":"235.00"},{"$f":"'Total Quantities'!F20","v":{"v":0,"d":"$0.00"}},{"$f":"F18*E18","v":{"v":0,"d":"$0.00"}}]
[18,"24\" White Solid Lines (Stop) Fast Dry Paint",{"$f":"VLOOKUP(B19,'Total Quantities'!B25:C51,2,FALSE)","v":24},"LF",15,{"$f":"'Total Quantities'!F26","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[22,"24\" White Solid Lines (Stop/Diag Lines) Thermoplastic-125 mil",{"$f":"VLOOKUP(B20,'Total Quantities'!B27:C55,2,FALSE)","v":31},"LF",15,{"$f":"'Total Quantities'!F30","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[29,"Permanent Vegetation",{"$f":"VLOOKUP(B21,'Total Quantities'!B37:C60,2,FALSE)","v":{"$error":"#N/A"}},"MSY",0.95,{"$f":"'Total Quantities'!F37","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[{"$nulls":5},"SUB-TOTAL",{"$f":"SUM(G11:G20)","v":{"v":0,"d":"$0.00"}}]
[]
[]
["Stone Marten Circle",{"$nulls":7},"Road Dimensions"]
["Start:","Stone Marten Circle (start @ Stone Marten Drive) "]
["Stop:","Stone Marten Circle (end @ Stone Marten Drive) "]
["Road Length:","0.04 mi."]
["Original Width:     20 ft          Widen Left:   0 ft            Widen Right:   0 ft          Final Width:   20 ft"]
[]
["ITEM #","DESCRIPTION",null,"UNIT","QUANTITY","UNIT PRICE","TOTAL PRICE",null,"Total Length [ft]",{"v":6750,"d":"6,750"},null,{"$f":"J31/5280","v":{"v":1.2784090909090908,"d":"1.28"}},"[mi]"]
[{"$nulls":8},"Proposed Width [ft]",28]
[5,"Borrow Excavation",{"$f":"VLOOKUP(B33,'Total Quantities'!B40:C61,2,FALSE)","v":{"$error":"#N/A"}},"CY",25,{"$f":"'Total Quantities'!F13","v":{"v":0,"d":"$0.00"}},{"$f":"F33*E33","v":{"v":0,"d":"$0.00"}}]
[10,"Full Depth HMA Patching 6\" Uniform",{"$f":"VLOOKUP(B34,'Total Quantities'!B43:C69,2,FALSE)","v":{"$error":"#N/A"}},"SY",50,{"$f":"'Total Quantities'!F18","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[11,"Liquid Asphalt Binder PG64-22",{"$f":"VLOOKUP(B35,'Total Quantities'!B43:C70,2,FALSE)","v":{"$error":"#N/A"}},"TON",{"v":4,"d":"4.00"},{"$f":"'Total Quantities'!F19","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[12,"H/M Asph. Surf. Cr. Type D (150 lbs/sy)",{"$f":"VLOOKUP(B36,'Total Quantities'!B45:C72,2,FALSE)","v":{"$error":"#N/A"}},"TON",{"v":60,"d":"60.00"},{"$f":"'Total Quantities'!F20","v":{"v":0,"d":"$0.00"}},{"$f":"F36*E36","v":{"v":0,"d":"$0.00"}},"Rate",450]
[18,"24\" White Solid Lines (Stop) Fast Dry Paint",{"$f":"VLOOKUP(B37,'Total Quantities'!B48:C76,2,FALSE)","v":{"$error":"#N/A"}},"LF",15,{"$f":"'Total Quantities'!F26","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[22,"24\" White Solid Lines (Stop/Diag Lines) Thermoplastic-125 mil",{"$f":"VLOOKUP(B38,'Total Quantities'!B50:C80,2,FALSE)","v":{"$error":"#N/A"}},"LF",15,{"$f":"'Total Quantities'!F30","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[29,"Permanent Vegetation",{"$f":"VLOOKUP(B39,'Total Quantities'!B58:C85,2,FALSE)","v":{"$error":"#N/A"}},"MSY",0.25,{"$f":"'Total Quantities'!F37","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[{"$nulls":5},"SUB-TOTAL",{"$f":"SUM(G33:G38)","v":{"v":0,"d":"$0.00"}}]
[]
[]
["* Clip Grass at edge of pavement",{"$nulls":4},"ROAD TOTAL =",{"$f":"+SUM(G40,G22)","v":{"v":0,"d":"$0.00"}}]

{"sheet":"Schein Loop","index":5,"n_rows":34,"n_cols":13,"rows_kept":34,"merged":[[0,8,0,9],[9,0,10,0],[9,1,10,1],[9,3,10,3],[9,4,10,4],[9,5,10,5],[9,6,10,6],[33,5,34,5],[33,6,34,6]]}
["Schein Loop",{"$nulls":7},"Road Dimensions"]
[]
["Start:","Bay Pine Road"]
["Stop:","Cul-de-sac"]
["Road Length:","      .55 mi"]
["Original Width:     20 ft          Widen Left:   0 ft            Widen Right:   0 ft          Final Width:   20 ft"]
[]
[]
[{"$nulls":8},"Total Length [ft]",{"v":6750,"d":"6,750"},null,{"$f":"J9/5280","v":{"v":1.2784090909090908,"d":"1.28"}},"[mi]"]
["ITEM #","DESCRIPTION",null,"UNIT","QUANTITY","UNIT PRICE","TOTAL PRICE",null,"Proposed Width [ft]",28]
[{"$nulls":8},"Pavement Area [sy]",{"$f":"(J9*J10)/9","v":21000}]
[1,"Mobilization",{"$f":"A12","v":1},"LS",{"v":0.2,"d":"0.20"},{"$f":"'Total Quantities'!F9","v":{"v":0,"d":"$0.00"}},{"$f":"E12*F12","v":{"v":0,"d":"$0.00"}}]
[2,"Bonds & Insurance",{"$f":"A13","v":2},"LS",{"v":0.2,"d":"0.20"},{"$f":"'Total Quantities'!F10","v":{"v":0,"d":"$0.00"}},{"$f":"E13*F13","v":{"v":0,"d":"$0.00"}}]
[3,"Construction Stakes, Lines, & Grades",3,"LS",{"v":0.2,"d":"0.20"},{"$f":"'Total Quantities'!F11","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[4,"Traffic Control",4,"LS",{"v":0.2,"d":"0.20"},{"$f":"'Total Quantities'!F12","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[5,"Borrow Excavation",{"$f":"VLOOKUP(B16,'[1]Total Quantities'!B11:C33,2,FALSE)","v":5},"CY",275,{"$f":"'Total Quantities'!F13","v":{"v":0,"d":"$0.00"}},{"$f":"F16*E16","v":{"v":0,"d":"$0.00"}},null,"Intersections [sy]",220]
[6,"Maintenance Stone",{"$f":"VLOOKUP(B17,'[1]Total Quantities'!B14:C39,2,FALSE)","v":10},"TON",20,{"$f":"'Total Quantities'!F14","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[9,"Mill Existing Asphalt Pavement (variable depth)",{"$f":"VLOOKUP(B18,'[1]Total Quantities'!B14:C40,2,FALSE)","v":11},"SY",150,{"$f":"'Total Quantities'!F17","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[10,"Full Depth HMA Patching 6\" Uniform",{"$f":"VLOOKUP(B19,'[1]Total Quantities'!B14:C41,2,FALSE)","v":12},"SY",750,{"$f":"'Total Quantities'!F18","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[11,"Liquid Asphalt Binder PG64-22",{"$f":"VLOOKUP(B20,'[1]Total Quantities'!B15:C42,2,FALSE)","v":13},"TON",60,{"$f":"'Total Quantities'!F19","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[13,"H/M Asph. Surf. Cr. Type B (200 lbs/sy)",{"$f":"VLOOKUP(B21,'[1]Total Quantities'!B18:C45,2,FALSE)","v":{"$error":"#N/A"}},"TON",890,{"$f":"'Total Quantities'!F21","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},"Rate",200]
[14,"H/M Asph. Surf. Cr. Type E (Varies)",{"$f":"VLOOKUP(B22,'[1]Total Quantities'!B17:C44,2,FALSE)","v":17},"TON",200,{"$f":"'Total Quantities'!F22","v":{"v":0,"d":"$0.00"}},{"$f":"F22*E22","v":{"v":0,"d":"$0.00"}},"Rate",80]
[15,"Permanent Construction Signs (Ground Mounted)",{"$f":"VLOOKUP(B23,'[1]Total Quantities'!B18:C46,2,FALSE)","v":20},"SF",152,{"$f":"'Total Quantities'!F23","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[17,"4\" White Solid Lines (Pavement Edge Lines) Fast Dry Paint",{"$f":"VLOOKUP(B24,'[1]Total Quantities'!B19:C47,2,FALSE)","v":21},"LF",6350,{"$f":"'Total Quantities'!F25","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[18,"24\" White Solid Lines (Stop) Fast Dry Paint",{"$f":"VLOOKUP(B25,'[1]Total Quantities'!B20:C48,2,FALSE)","v":24},"LF",20,{"$f":"'Total Quantities'!F26","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[19,"4\" Yellow Solid Line (No Passing Zone) Fast Dry Paint",{"$f":"VLOOKUP(B26,'[1]Total Quantities'!B21:C49,2,FALSE)","v":25},"LF",6350,{"$f":"'Total Quantities'!F27","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[21,"4\" White Solid Lines (Pavement Edge Lines) Thermoplastic-90 mil",{"$f":"VLOOKUP(B27,'[1]Total Quantities'!B22:C51,2,FALSE)","v":27},"LF",6350,{"$f":"'Total Quantities'!F29","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[22,"24\" White Solid Lines (Stop/Diag Lines) Thermoplastic-125 mil",{"$f":"VLOOKUP(B28,'[1]Total Quantities'!B23:C52,2,FALSE)","v":31},"LF",20,{"$f":"'Total Quantities'!F30","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[23,"4\" Yellow Solid Line (No Passing Zone) Thermoplastic-90 mil",{"$f":"VLOOKUP(B29,'[1]Total Quantities'!B25:C53,2,FALSE)","v":32},"LF",5850,{"$f":"'Total Quantities'!F31","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[25,"Permanent Yellow Pavement Markers Bi-Dir.-4\"x4\"",{"$f":"VLOOKUP(B30,'[1]Total Quantities'!B28:C56,2,FALSE)","v":{"$error":"#N/A"}},"EA",38,{"$f":"'Total Quantities'!F33","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[27,"36\" RCP (Remove & Replace)",null,"LF",48,{"$f":"'Total Quantities'!F35","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[28,"42\" RCP (Remove & Replace)",null,"LF",64,{"$f":"'Total Quantities'!F36","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[29,"Permanent Vegetation",{"$f":"VLOOKUP(B33,'[1]Total Quantities'!B29:C57,2,FALSE)","v":42},"MSY",3.5,{"$f":"'Total Quantities'!F37","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[{"$nulls":5},"ROAD TOTAL",{"$f":"SUM(G12:G33)","v":{"v":0,"d":"$0.00"}}]