{"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":122,"n_cols":6,"rows_kept":122,"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",null,"TOTAL"]
["C1",{"$f":"VLOOKUP(A6,[1]!Table_BidItem_CategoryClassification[#All],2,FALSE)","v":"GENERAL EARTH WORK"}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT PRICE","TOTAL"]
["02200-C1-00070","Geotextile Drainage Fabric In Place (VDOT Section 245.03.c)",222,"SY",null,{"$f":"IFERROR($C8*$E8, \"\")","v":{"v":0,"d":"$0.00"}}]
["02200-C1-00130","Aggregate, VDOT #21-A  (Compacted in Place per VDOT standards & Specs)",100,"CY",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$8:$F$9)","v":{"v":0,"d":"$0.00"}}]
[]
["C2",{"$f":"VLOOKUP(A12,[1]!Table_BidItem_CategoryClassification[#All],2,FALSE)","v":"CONCRETE WORK"}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT PRICE","TOTAL"]
["02750-C2-00060","Concrete Curb & Gutter, Standard C-2 and C-2R (Arlington County Detail R-2.0), includes curb & gutter for aprons, ramps, etc.",16,"LF",null,{"$f":"IFERROR($C14*$E14, \"\")","v":{"v":0,"d":"$0.00"}}]
["03100-C2-SP290","8\" Thick Continuously Reinforced Concrete Pavement (Steel Bar Reinforcement, VDOT PR-3)",385,"SY",null,{"$f":"IFERROR($C15*$E15, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$14:$F$15)","v":{"v":0,"d":"$0.00"}}]
[]
["C3",{"$f":"VLOOKUP(A18,[1]!Table_BidItem_CategoryClassification[#All],2,FALSE)","v":"ASPHALT WORK"}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["02600-C3-00010","Asphalt Concrete, Planing or Milling (1/2\" to 3\" Depth)",710,"SY",null,{"$f":"IFERROR($C20*$E20, \"\")","v":{"v":0,"d":"$0.00"}}]
["02600-C3-00030","Asphalt Concrete, Base Course (VDOT BM-25.0A)",10,"TON",null,{"v":0,"d":"$0.00"}]
["02600-C3-00060","Asphalt Concrete, Surface Course (VDOT SM-9.5A)",5,"TON",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$20:$F$22)","v":{"v":0,"d":"$0.00"}}]
[]
["C4",{"$f":"VLOOKUP(A25,[1]!Table_BidItem_CategoryClassification[#All],2,FALSE)","v":"STORM SEWER UTILITY WORK"}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["02500-C4-00650","18\" Pipe, RCP Class III, In Place 6' to 9' Deep",70,"LF",null,{"$f":"IFERROR($C27*$E27, \"\")","v":{"v":0,"d":"$0.00"}}]
["02500-C4-02000","15\" Polypropylene Pipe,In Place Up to 6' Deep",475,"LF",null,{"v":0,"d":"$0.00"}]
["02500-C4-02040","18\" Polypropylene Pipe,In Place 6' to 10' Deep",50,"LF",null,{"v":0,"d":"$0.00"}]
["02505-C4-00010","Storm Manhole MH-1 (Arlington County Detail D-3.0), In Place, DEPTH   8'",3,"EA",null,{"v":0,"d":"$0.00"}]
["02505-C4-00100","CB-2A or CB-2B (throat lengths from 8'-6\" up to 16'-0\"),  In Place Up to 6' Deep, Arlington County Standards.",1,"EA",null,{"v":0,"d":"$0.00"}]
["02505-C4-00380","Yard Inlet (Arlington County Detail D-1.10), In Place Up to 6' Deep",1,"EA",null,{"v":0,"d":"$0.00"}]
["02505-C4-00430","Grate Inlet Non-roadway Shallow (Arlington County Detail D-1.9), In Place Up to 6' Deep",2,"EA",null,{"v":0,"d":"$0.00"}]
["02505-C4-SP450","Nyloplast or approved equal inlets / drain basins",7,"EA",null,{"v":0,"d":"$0.00"}]
["02505-C4-00600","Storm Manhole, Catch Basin, Drop Inlet, Yard Inlet, or Grate Inlet, Remove",3,"EA",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$27:$F$35)","v":{"v":0,"d":"$0.00"}}]
[]
["C5",{"$f":"VLOOKUP(A38,[1]!Table_BidItem_CategoryClassification[#All],2,FALSE)","v":"GUARDRAIL"}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[{"$nulls":4},"SUBTOTAL"]
[]
["C6",{"$f":"VLOOKUP(A42,[1]!Table_BidItem_CategoryClassification[#All],2,FALSE)","v":"WATERMAIN WORK"}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["02550-C6-00200","Connect To Existing 8-Inch Water Main",1,"EA",null,{"$f":"IFERROR($C44*$E44, \"\")","v":{"v":0,"d":"$0.00"}}]
["02550-C6-00700","Service Taps  - 1 1/2-inch and 2-inch PER ADDITIONAL LINEAR FOOT OVER 10 FT.",65,"LF",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$44:$F$45)","v":{"v":0,"d":"$0.00"}}]
[]
["C7",{"$f":"VLOOKUP(A48,[1]!Table_BidItem_CategoryClassification[#All],2,FALSE)","v":"SANITARY SEWER WORK"}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[{"$nulls":4},"SUBTOTAL"]
[]
["C8",{"$f":"VLOOKUP(A52,[1]!Table_BidItem_CategoryClassification[#All],2,FALSE)","v":"TRAFFIC SIGNAL WORK"}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[{"$nulls":4},"SUBTOTAL"]
[]
["C9",{"$f":"VLOOKUP(A56,[1]!Table_BidItem_CategoryClassification[#All],2,FALSE)","v":"STREET LIGHTING WORK"}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[{"$nulls":4},"SUBTOTAL"]
[]
["C10",{"$f":"VLOOKUP(A60,[1]!Table_BidItem_CategoryClassification[#All],2,FALSE)","v":"PAVEMENT MARKING AND SIGNAGE WORK"}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["02900-C10-00120","Six (6) Inch Longitudinal Solid Line",200,"LF",null,{"$f":"IFERROR($C62*$E62, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$62:$F$62)","v":{"v":0,"d":"$0.00"}}]
[]
["C11",{"$f":"VLOOKUP(A65,[1]!Table_BidItem_CategoryClassification[#All],2,FALSE)","v":"LANDSCAPE AND HARDSCAPE RESTORATION WORK"}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["02800-C11-00500","Tree/Stump Removal - Class A. Remove and Dispose, Up to 6\" DBH to 12\" DBH (Diameter at Breast Height)",5,"EA",null,{"$f":"IFERROR($C67*$E67, \"\")","v":{"v":0,"d":"$0.00"}}]
["02800-C11-00603","Trees, Deciduous - 2.0 to 2.5\" caliper",4,"EA",null,{"v":0,"d":"$0.00"}]
["02800-C11-00611","Trees, Evergreen - 6.0 to 7.0' in height",1,"EA",null,{"v":0,"d":"$0.00"}]
["311300-C11-00082","Tree Pruning",6,"EA",null,{"v":0,"d":"$0.00"}]
["02800-C11-00200","Chain Link Fence, Height Less Than or Equal to 6'",60,"LF",null,{"v":0,"d":"$0.00"}]
["02800-C11-00210","Chain Link Fence, Height Greater Than 6' Up to 8'",80,"LF",null,{"v":0,"d":"$0.00"}]
["02800-C11-00240","Chain Link Fence - Remove & Dispose, Height Less Than or equal to 6'",60,"LF",null,{"v":0,"d":"$0.00"}]
["02800-C11-00250","Chain Link Fence - Remove & Dispose, Height Greater Than 6' Up to 8'",40,"LF",null,{"v":0,"d":"$0.00"}]
["02800-C11-00270","Landscape/Retaining Wall, Excluding Foundation (Segmental Non-Reinforced Interlocking Concrete Wall), Height Less Than 3' Exposed Face (Versa-Lok, or County Approved Alternate System)",100,"SF",null,{"v":0,"d":"$0.00"}]
["02800-C11-00280","Landscape/Retaining Wall (Block, Brick, Segmental, or Similar), Height Less Than or Equal to 3' Exposed Face, Remove and Dispose (Foundation Removal Paid Separately under Rock Excavation)",100,"SF",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$67:$F$76)","v":{"v":0,"d":"$0.00"}}]
[]
["C12",{"$f":"VLOOKUP(A79,[1]!Table_BidItem_CategoryClassification[#All],2,FALSE)","v":"BUS STOP SHELTER AND FURNISHINGS"}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[{"$nulls":4},"SUBTOTAL"]
[]
["C13",{"$f":"VLOOKUP(A83,[1]!Table_BidItem_CategoryClassification[#All],2,FALSE)","v":"EROSION AND SEDIMENT CONTROL WORK"}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["01500-C13-10000","Temporary Erosion and Sediment Controls",1,"LS",null,{"$f":"IFERROR($C85*$E85, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUM(C85*E85)","v":{"v":0,"d":"$0.00"}}]
[]
["C15",{"$f":"VLOOKUP(A88,[1]!Table_BidItem_CategoryClassification[#All],2,FALSE)","v":"UNLISTED WORK"}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["01000-C15-SP005","Removal and Fill of Existing Gravel SWM Ditches",122,"CY",null,{"$f":"IFERROR($C90*$E90, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$90:$F$90)","v":{"v":0,"d":"$0.00"}}]
[]
["C16",{"$f":"VLOOKUP(A93,[1]!Table_BidItem_CategoryClassification[#All],2,FALSE)","v":"MOT AND RE-MOBILIZATION WORK"}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[{"$nulls":4},"SUBTOTAL"]
[]
["C17",{"$f":"VLOOKUP(A97,[1]!Table_BidItem_CategoryClassification[#All],2,FALSE)","v":"STORMWATER WORK"}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["ACSWM-C17-02541","Manufactured Filtering Device",1,"EA",null,{"$f":"IFERROR($C99*$E99, \"\")","v":{"v":0,"d":"$0.00"}}]
["ACSWM-C17-02542","Stormwater Detention System",1,"EA",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$99:$F$100)","v":{"v":0,"d":"$0.00"}}]
[]
["C18",{"$f":"VLOOKUP(A103,[1]!Table_BidItem_CategoryClassification[#All],2,FALSE)","v":"NON COUNTY UTILITIES"}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["02580-C18-00010","Electrical Service for Brine Machine",1,"LS",null,{"$f":"IFERROR($C105*$E105, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$105:$F$105)","v":{"v":0,"d":"$0.00"}}]
[]
[]
[{"$nulls":4}," CONTRACT TOTAL (EXCLUDING PERCENTAGE ITEMS)",{"$f":"SUM(Unit_Price_Tab!$F$106,Unit_Price_Tab!$F$101,Unit_Price_Tab!$F$91,Unit_Price_Tab!$F$86,Unit_Price_Tab!$F$77,Unit_Price_Tab!$F$63,Unit_Price_Tab!$F$46,Unit_Price_Tab!$F$36,Unit_Price_Tab!$F$23,Unit_Price_Tab!$F$16,Unit_Price_Tab!$F$10)","v":{"v":0,"d":"$0.00"}}]
[]
["PCT",{"$f":"VLOOKUP(A111,[1]!Table_BidItem_CategoryClassification[#All],2,FALSE)","v":"PERCENTAGE LINE ITEMS"}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["01500-C13-10000","Temporary Erosion and Sediment Controls","NA","%",null,{"$f":"Unit_Price_Tab!$E113*$F$109","v":{"v":0,"d":"$0.00"}}]
["01000-C16-00010","Maintenance of Traffic (MOT)","NA","%",null,{"$f":"Unit_Price_Tab!$E114*$F$109","v":{"v":0,"d":"$0.00"}}]
["01000-C16-00020","Re-Mobilization (For On-Call Contracts Only)","NA","%",null,{"$f":"Unit_Price_Tab!$E115*$F$109","v":{"v":0,"d":"$0.00"}}]
["01000-C16-00030","Mobilization and De-Mobilization","NA","%",null,{"$f":"Unit_Price_Tab!$E116*$F$109","v":{"v":0,"d":"$0.00"}}]
["01500-SA-00200","SWPPP Administration","NA","%",null,{"$f":"Unit_Price_Tab!$E117*$F$109","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"PERCENTAGE LINE ITEMS SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$113:$F$117)","v":{"v":0,"d":"$0.00"}}]
[]
[]
[]
[{"$nulls":4},"PRIMARY CONTRACT :",{"$f":"$F$118+F109","v":{"v":0,"d":"$0.00"}}]