{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Unit_Price_Tab"],"not_rendered":{"external_links":1,"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"Unit_Price_Tab","index":0,"n_rows":138,"n_cols":6,"rows_kept":138,"merged":[[1,0,1,5]]}
[{"$nulls":3},"PREPARED BY:"]
["THE UNDERSIGNED CERTIFIES THAT (CONTRACTOR NAME)___________________________\nIS CURRENTLY REGISTERED WITH THE VIRGINIA STATE BOARD OF CONTRACTORS AS REQUIRED BY THE CODE OF VIRGINIA.  CERTIFICATE NUMBER _________________ WAS ISSUED ON THE ________DAY OF _____________, 20XX.  THE UNDERSIGNED FURTHER CERTIFIES THAT THE REGISTRATION FEE AND ALL RENEWAL FEES REQUIRED UNDER LAW HAVE BEEN PAID.  THE CONTRACTOR AGREES TO FURNISH ALL NECESSARY LABOR, EQUIPMENT, MATERIALS, AND ALL THINGS NECESSARY TO PERFORM THE WORK AS SET FORTH IN ACCORDANCE WITH THE PLANS AND SPECIFICATIONS. THE CONTRACTOR AGREES TO PERFORM RELATED WORK FOR THE FOLLOWING ITEMS AT THE FOLLOWING STIPULATED PRICES: (ALL PRICES INCLUDE PROVISION AND INSTALLATION)."]
[{"$nulls":3},"CHECKED BY:"]
[]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT PRICE","TOTAL"]
["C1","GENERAL EARTH WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT PRICE","TOTAL"]
["02200-C1-00050","Select Borrow (VDOT Section 207 - Select Material, Type I)",71,"CY",null,{"$f":"IFERROR($C8*$E8, \"\")","v":{"v":0,"d":"$0.00"}}]
["02200-C1-00070","Geotextile Drainage Fabric In Place (VDOT Section 245.03.c)",815,"SY",null,{"v":0,"d":"$0.00"}]
["02200-C1-00160","Aggregate, VDOT #57  (Compacted in Place per VDOT standards & Specs)",200,"CY",null,{"v":0,"d":"$0.00"}]
["02227-","Stacked Stone (Per DEQ Virginia Stream restoration and stabilization best management pracitices guide, Chapter 4, Section 1, Practice 1.3, Detail 1.3)",450,"TON",null,{"v":0,"d":"$0.00"}]
["02228-","Permanent Erosion Control Coir Matting (per Sheet C092.1 and Supplemental Specification 02228)",770,"SY",null,{"v":0,"d":"$0.00"}]
["02223-","Rock Cross Vanes (per Virginia Stream Restoration and Stabilization Best Management Practices guide, Ch. 4, Sect. 3, Practice 3.1, Detail 3.1a and 3.1b)",178,"TON",null,{"v":0,"d":"$0.00"}]
["01501-","Pump Around Diversion per Detail on Sheet C032.2",80,"DAYS",null,{"v":0,"d":"$0.00"}]
["02221-","Imported Stream Bed Materials, Placed per Nature and Gradation Specified in Supplemental Specs Section 02221",350,"TON",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$8:$F$15)","v":{"v":0,"d":"$0.00"}}]
[]
["C2","CONCRETE WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT PRICE","TOTAL"]
["03100-C2-00210","Concrete Pier, Cradle, or Encasement (Arlington County Detail M-3.0)",133,"LF",null,{"$f":"IFERROR($C20*$E20, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$20:$F$20)","v":{"v":0,"d":"$0.00"}}]
[]
["C3","ASPHALT WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["02600-C3-00010","Asphalt Concrete, Planing or Milling (1/2\" to 3\" Depth)",1235,"SY",null,{"$f":"IFERROR($C25*$E25, \"\")","v":{"v":0,"d":"$0.00"}}]
["02600-C3-00060","Asphalt Concrete, Surface Course (VDOT SM-9.5A)",149,"TON",null,{"v":0,"d":"$0.00"}]
["02600-C3-00120","Asphalt Header Curb, 6\"-8\" (VDOT SM-9.5A)",25,"LF",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$25:$F$27)","v":{"v":0,"d":"$0.00"}}]
[]
["C4","STORM SEWER UTILITY WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["02500-C4-00660","21\" Pipe, RCP Class III, In Place Up to 6' Deep",4.4,"LF",null,{"$f":"IFERROR($C32*$E32, \"\")","v":{"v":0,"d":"$0.00"}}]
["02500-C4-SP250","Standard Endwall for Multiple Pipe Culverts 12\" - 36\" Circular Pipes (VDOT Std. EW-6)",1,"EA",null,{"$f":"IFERROR($C33*$E33, \"\")","v":{"v":0,"d":"$0.00"}}]
["02500-C4-SP855","18\" Pipe Aluminum Coated Type 2 Corrugated Steel",4.4,"LF",null,{"$f":"IFERROR($C34*$E34, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$32:$F$34)","v":{"v":0,"d":"$0.00"}}]
[]
["C11","LANDSCAPE AND HARDSCAPE RESTORATION WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["02200-C11-00010","Imported Topsoil",77,"CY",null,{"$f":"IFERROR($C39*$E39, \"\")","v":{"v":0,"d":"$0.00"}}]
["02801-C11-00040","Shredded hardwood mulch; Aged 6 months minimum - Free of Trash & Debris",305,"CY",null,{"v":0,"d":"$0.00"}]
["02801-C11-00050","Seed, Mixture of 85% Tall Fescue/Bluegrass and 15% Annual Rye",420,"SY",null,{"v":0,"d":"$0.00"}]
["02800-C11-01080","Shrub (#1 Container)- Container or B&B",188,"EA",null,{"v":0,"d":"$0.00"}]
["311300-C11-00084","Root Protection Matting",1020,"SF",null,{"v":0,"d":"$0.00"}]
["311300-C11-SP083","Wooden Deck Mat (Sheet C032.2)",4930,"SF",null,{"v":0,"d":"$0.00"}]
["02801-C11-SP055","Permanent Seed, Upland Woodland Slope Seed Mix per Landscape Plan (Sheet C092.1)",6,"LBS",null,{"v":0,"d":"$0.00"}]
["02802-","Live Stakes (Sheet C092.1)",150,"EA",null,{"v":0,"d":"$0.00"}]
["02800-C11-SP614","Tree Planting (1 gal / 3-4' tall)",630,"EA",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$39:$F$47)","v":{"v":0,"d":"$0.00"}}]
[]
["C5","GUARDRAIL"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[{"$nulls":4},"SUBTOTAL"]
[]
["C6","WATERMAIN WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[{"$nulls":4},"SUBTOTAL"]
[]
["C7","SANITARY SEWER WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[null,"Standard Concrete Encasement, 8\" Pipe",null,"CY",null,{"$f":"IFERROR($C60*$E60, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL"]
[]
["C8","TRAFFIC SIGNAL WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[{"$nulls":4},"SUBTOTAL"]
[]
["C9","STREET LIGHTING WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[{"$nulls":4},"SUBTOTAL"]
[]
["C10","PAVEMENT MARKING AND SIGNAGE WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[{"$nulls":4},"SUBTOTAL"]
[]
["C12","BUS STOP SHELTER AND FURNISHINGS"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[{"$nulls":4},"SUBTOTAL"]
[]
["C13","EROSION AND SEDIMENT CONTROL WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["01500-C13-00005","Gravel construction entrance, including wash rack (per Virginia Erosion & Sediment Control Handbook Standard & Specification 3.02)",1,"EA",null,{"$f":"IFERROR($C81*$E81, \"\")","v":{"v":0,"d":"$0.00"}}]
["01500-C13-00020","Silt Fence, without Wire Support (Virginia Erosion & Sediment Control Handbook Standard & Specification 3.05)",130,"LF",null,{"$f":"IFERROR($C82*$E82, \"\")","v":{"v":0,"d":"$0.00"}}]
["01500-C13-00140","4' Chain Link Tree Protection Fence (per Arlington County DPR Standard 02231.2)",1365,"LF",null,{"$f":"IFERROR($C83*$E83, \"\")","v":{"v":0,"d":"$0.00"}}]
["01500-C13-00150","Root Pruning (per Arlington County DPR Standard 311300.5)",460,"LF",null,{"$f":"IFERROR($C84*$E84, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUM(F81:F84)","v":{"v":0,"d":"$0.00"}}]
[]
["C15","UNLISTED WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[{"$nulls":4},"SUBTOTAL"]
[]
["C16","MOT AND RE-MOBILIZATION WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[{"$nulls":4},"SUBTOTAL"]
[]
["C17","STORMWATER WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[{"$nulls":4},"SUBTOTAL"]
[]
["C18","NON COUNTY UTILITIES"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[{"$nulls":4},"SUBTOTAL"]
[]
["C11 - OPTIONAL BID","LANDSCAPE AND HARDSCAPE RESTORATION WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["02200-C11-00010","Imported Topsoil",null,"CY",null,{"$f":"IFERROR($C105*$E105, \"\")","v":{"v":0,"d":"$0.00"}}]
["02801-C11-00040","Shredded hardwood mulch; Aged 6 months minimum - Free of Trash & Debris",null,"CY",null,{"v":0,"d":"$0.00"}]
["02801-C11-00050","Seed, Mixture of 85% Tall Fescue/Bluegrass and 15% Annual Rye",null,"SY",null,{"v":0,"d":"$0.00"}]
["02800-C11-00500","Tree/Stump Removal - Class A. Remove and Dispose, Up to 6\" DBH to 12\" DBH (Diameter at Breast Height)",13,"EA",null,{"v":0,"d":"$0.00"}]
["02800-C11-00501","Tree/Stump Removal - Class B. Remove and Dispose, over 12\" DBH to 18\" DBH (Diameter at Breast Height)",1,"EA",null,{"v":0,"d":"$0.00"}]
["02800-C11-00502","Tree/Stump Removal - Class C. Remove and Dispose, over 18\" DBH to 24\" DBH (Diameter at Breast Height)",3,"EA",null,{"v":0,"d":"$0.00"}]
["02800-C11-00503","Tree/Stump Removal - Class D. Remove and Dispose, over 24\" DBH to 30\" DBH (Diameter at Breast Height)",4,"EA",null,{"v":0,"d":"$0.00"}]
["02800-C11-00504","Tree/Stump Removal - Class E. Remove and Dispose, over 30\" DBH to 36\" DBH (Diameter at Breast Height)",4,"EA",null,{"v":0,"d":"$0.00"}]
["02800-C11-00505","Tree/Stump Removal - Class F. Remove and Dispose, over 36\" DBH to 42\" DBH (Diameter at Breast Height)",3,"EA",null,{"v":0,"d":"$0.00"}]
["02800-C11-00506","Tree/Stump Removal - Class G. Remove and Dispose, over 42\" DBH to 48\" DBH (Diameter at Breast Height)",1,"EA",null,{"v":0,"d":"$0.00"}]
[null,"Trees, Deciduous -3'-4' in height",null,"EA",null,{"v":0,"d":"$0.00"}]
["02800-C11-01080","Shrub (#1 Container)- Container or B&B",null,"EA",null,{"v":0,"d":"$0.00"}]
["311300-C11-00084","Root Protection Matting",null,"SF",null,{"v":0,"d":"$0.00"}]
["311300-C11-SP083","Wooden Deck Mat (Sheet C032.2)",null,"SF",null,{"v":0,"d":"$0.00"}]
["02801-C11-SP055","Permanent Seed, Upland Woodland Slope Seed Mix per Landscape Plan (Sheet C092.1)",null,"LBS",null,{"v":0,"d":"$0.00"}]
["02802-","Live Stakes (Sheet C092.1)",null,"EA",null,{"v":0,"d":"$0.00"}]
["02800-C11-SP614","Tree Planting (1 gal / 3-4' tall)",null,"EA",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL OPTIONAL ITEM",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$105:$F$121)","v":{"v":0,"d":"$0.00"}}]
[]
[{"$nulls":4}," CONTRACT TOTAL (EXCLUDING PERCENTAGE ITEMS)",{"$f":"SUMIF(E:E,\"SUBTOTAL\",F:F)","v":{"v":0,"d":"$0.00"}}]
[]
["PCT","PERCENTAGE LINE ITEMS"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["01500-C13-10000","Temporary Erosion and Sediment Controls",null,"%",null,{"$f":"Unit_Price_Tab!$E128*$F$124","v":{"v":0,"d":"$0.00"}}]
["01000-C16-00010","Maintenance of Traffic (MOT)",null,"%",null,{"$f":"Unit_Price_Tab!$E129*$F$124","v":{"v":0,"d":"$0.00"}}]
["01000-C16-00020","Re-Mobilization (For On-Call Contracts Only)",null,"%",null,{"$f":"Unit_Price_Tab!$E130*$F$124","v":{"v":0,"d":"$0.00"}}]
["01000-C16-00030","Mobilization and De-Mobilization",null,"%",null,{"$f":"Unit_Price_Tab!$E131*$F$124","v":{"v":0,"d":"$0.00"}}]
["01500-SA-00200","SWPPP Administration",null,"%",null,{"$f":"Unit_Price_Tab!$E132*$F$124","v":{"v":0,"d":"$0.00"}}]
["01000-VF-00200","VDOT Inspection Fee (Only for LAP Projects. Do not Inlude in the Bid Tab)",null,"%",null,{"$f":"Unit_Price_Tab!$E133*$F$124","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"PERCENTAGE LINE ITEMS SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$128:$F$133)","v":{"v":0,"d":"$0.00"}}]
[]
[]
[]
[{"$nulls":4},"PROJECT TOTAL :",{"$f":"$F$134+F124","v":{"v":0,"d":"$0.00"}}]