{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Unit_Price_Tab"],"not_rendered":{"external_links":2,"defined_names":8},"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},"DATE: "]
["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},"PREPARED BY:","L Dizon"]
[{"$nulls":3},"CHECKED BY:","S. Shikur"]
[]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT PRICE","TOTAL"]
["C1","GENERAL EARTH WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT PRICE","TOTAL"]
["02200-C1-00130","Aggregate, VDOT #21-A  (Compacted in Place per VDOT standards & Specs)",23,"CY",null,{"$f":"IFERROR($C9*$E9, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$9:$F$9)","v":{"v":0,"d":"$0.00"}}]
[]
["C2","CONCRETE WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT PRICE","TOTAL"]
["02750-C2-00020","Concrete Curb, Standard Header Curb C-3 (Arlington County Detail R-2.0), includes curb for aprons, ramps, etc.",10,"LF",null,{"$f":"IFERROR($C14*$E14, \"\")","v":{"v":0,"d":"$0.00"}}]
["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.",374,"LF",null,{"v":0,"d":"$0.00"}]
["02611-C2-00110","Concrete Sidewalk, 4\" Thickness (Arlington County Detail R-2.0)",79,"SY",null,{"v":0,"d":"$0.00"}]
["02611-C2-00170","Concrete Driveway Entrance, 6\" Thick Residential (Arlington County Details R-2.4A, R-2.4B, R-2.4C, R-2.4D)",20,"SY",null,{"v":0,"d":"$0.00"}]
["03100-C2-00220","Concrete Pier, Cradle, or Encasement (Arlington County Detail M-7.0)",22,"CY",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$14:$F$18)","v":{"v":0,"d":"$0.00"}}]
[]
["C3","ASPHALT WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["02600-C3-00030","Asphalt Concrete, Base Course (VDOT BM-25.0A)",16,"TON",null,{"$f":"IFERROR($C23*$E23, \"\")","v":{"v":0,"d":"$0.00"}}]
["02600-C3-00060","Asphalt Concrete, Surface Course (VDOT SM-9.5A)",6,"TON",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$23:$F$24)","v":{"v":0,"d":"$0.00"}}]
[]
["C4","STORM SEWER UTILITY WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["02550-C4-01560","14\" Pipe, DIP (CLASS 56), In Place Up to 6' Deep",20,"LF",null,{"$f":"IFERROR($C29*$E29, \"\")","v":{"v":0,"d":"$0.00"}}]
["02505-C4-00180","Curb Drop Inlet, Standard VDOT DI-2B (12\" to 24\" Pipe), In Place Up to 9' Deep, Inlet Throat Length 4' to 20'",1,"EA",null,{"v":0,"d":"$0.00"}]
["02505-C4-00552","Core Drill and Connect 8\" to 14\" Dia Ductile Iron Pipe to Existing Storm Manhole, Catch Basin, Drop Inlet, Yard Inlet, or Grate Inlet",1,"EA",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$29:$F$31)","v":{"v":0,"d":"$0.00"}}]
[]
["C5",{"$f":"VLOOKUP(A34,#REF!,2,FALSE)","v":{"$error":"#REF!"}}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!#REF!)","v":{"$error":"#REF!"}}]
[]
["C6","WATERMAIN WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["02550-C6-01230","30-Inch Butterfly Valve & Valve Box",1,"EA",null,{"$f":"IFERROR($C40*$E40, \"\")","v":{"v":0,"d":"$0.00"}}]
["02550-C6-01240","24-Inch Butterfly Valve & Valve Box",2,"EA",null,{"v":0,"d":"$0.00"}]
["02550-C6-00150","8-Inch Gate Valve & Valve Box",1,"EA",null,{"v":0,"d":"$0.00"}]
["02550-C6-00160","6-Inch Gate Valve & Valve Box",2,"EA",null,{"v":0,"d":"$0.00"}]
["02550-C6-01320","Connect To Existing 24-Inch Water Main",1,"EA",null,{"v":0,"d":"$0.00"}]
["02550-C6-00200","Connect To Existing 8-Inch Water Main",1,"EA",null,{"$f":"Unit_Price_Tab!$E45*Unit_Price_Tab!$C45","v":{"v":0,"d":"$0.00"}}]
["02550-C6-00210","Connect To Existing 6-Inch Water Main",4,"EA",null,{"v":0,"d":"$0.00"}]
["02550-C6-00230","2-Inch Air Release Or Vacuum Valve In Concrete Manhole For All Diameter Of Water Mains",4,"EA",null,{"v":0,"d":"$0.00"}]
["02550-C6-00250","Remove Existing Fire Hydrant",1,"EA",null,{"v":0,"d":"$0.00"}]
["02550-C6-00270","Install New Fire Hydrant (includes Fire Hydrant, Gate Valve with Valve Box and up to 20 LF 6-inch DIP CL-52)",1,"EA",null,{"v":0,"d":"$0.00"}]
["02550-C6-00320","Cut & Cap 8-Inch Water Main",1,"EA",null,{"$f":"Unit_Price_Tab!$E50*Unit_Price_Tab!$C50","v":{"v":0,"d":"$0.00"}}]
["02550-C6-00330","Cut & Cap 6-Inch Water Main",4,"EA",null,{"v":0,"d":"$0.00"}]
["02550-C6-00350","Remove Existing Valve Boxes",4,"EA",null,{"v":0,"d":"$0.00"}]
["02550-C6-01030","30-Inch Water Main, DIP CL-52,  > 6' Deep",40,"LF",null,{"v":0,"d":"$0.00"}]
["02550-C6-01050","24-Inch Water Main, DIP CL-52, > 6' Deep",3490,"LF",null,{"v":0,"d":"$0.00"}]
["02550-C6-00050","8-Inch Water Main, DIP CL-52, Upto 6' Deep",936,"LF",null,{"v":0,"d":"$0.00"}]
["02550-C6-00060","8-Inch Water Main, DIP CL-52, > 6' Deep",16,"LF",null,{"v":0,"d":"$0.00"}]
["02550-C6-00070","6-Inch Water Main, DIP CL-53, Upto 6' Deep",60,"LF",null,{"v":0,"d":"$0.00"}]
["02550-C6-00080","6-Inch Water Main, DIP CL-52,  > 6' Deep",100,"LF",null,{"v":0,"d":"$0.00"}]
["02550-C6-00630","Service Taps - 3/4-inch and 1-inch (TAP MAIN, INSTALL COPPER TUBING, INSTALL ANGLE VALVES, CORPORATION COCK, METER BOX AND METER YOKE/METER, CONNECT TO EXISTING PRIVATE SERVICE LINE, BACKFILL, EXCAVATION & PAVEMENT RESTORATIONS)--UP TO 1O FT.",13,"EA",null,{"$f":"Unit_Price_Tab!$E59*Unit_Price_Tab!$C59","v":{"v":0,"d":"$0.00"}}]
["02550-C6-00640","Service Taps - 3/4-inch and 1-inch PER ADDITIONAL LINEAR FOOT OVER 10 FT.",625,"LF",null,{"$f":"Unit_Price_Tab!$E60*Unit_Price_Tab!$C60","v":{"v":0,"d":"$0.00"}}]
["02550-C6-00650","Service Re-Taps  - 3/4-inch and 1-inch (TAP MAIN, INSTALL COPPER TUBING, CONNECT TO EXISTING SERVICE LINE, ABANDON CORPORATION COCK FROM EXISTING SERVICE LINE, BACKFILL, EXCAVATION & PAVEMENT RESTORATION)-UP TO 10 FT.",25,"EA",null,{"$f":"Unit_Price_Tab!$E61*Unit_Price_Tab!$C61","v":{"v":0,"d":"$0.00"}}]
["02550-C6-00660","Service Re-Taps  - 3/4-inch and 1-inch PER ADDITIONAL LINEAR FT. OVER 10 FT.",198,"LF",null,{"v":0,"d":"$0.00"}]
["02550-C6-00680","Service Relocations - 3/4-Inch and 1-Inch Per Additional Linear Foot Over 10 Ft.",200,"LF",null,{"v":0,"d":"$0.00"}]
["02550-C6-SP001","Connect Proposed 24-inch Water Main to Existing 30-inch PCCP with Required Fittings and Accessories including, but not limited to, Tee, Sleeves, Adapters, as shown on DIP-PCCP Connection Detail on sheet 22 (Valves will be paid with separate line items)",1,"LS",null,{"v":0,"d":"$0.00"}]
["02550-C6-SP002","In-Line Thrust Block including retainer gland and submission of design & details of Thrust Restraint for 30\" PCCP at the connection point of proposed 24-inch Water Main as mentioned on DIP-PCCP Connection Detail Note#6 on sheet 22",1,"LS",null,{"v":0,"d":"$0.00"}]
["02550-C6-SP003","Remove Existing Blowoff Valve, Valve Box and Blocks",1,"EA",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$40:$F$66)","v":{"v":0,"d":"$0.00"}}]
[]
["C7",{"$f":"VLOOKUP(A69,#REF!,2,FALSE)","v":{"$error":"#REF!"}}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!#REF!)","v":{"$error":"#REF!"}}]
[]
["C8",{"$f":"VLOOKUP(A73,#REF!,2,FALSE)","v":{"$error":"#REF!"}}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!#REF!)","v":{"$error":"#REF!"}}]
[]
["C9",{"$f":"VLOOKUP(A77,#REF!,2,FALSE)","v":{"$error":"#REF!"}}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!#REF!)","v":{"$error":"#REF!"}}]
[]
["C10","PAVEMENT MARKING AND SIGNAGE WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["02900-C10-00040","Eighteen (18) Inch Transverse Markings",13,"LF",null,{"$f":"IFERROR($C83*$E83, \"\")","v":{"v":0,"d":"$0.00"}}]
["02900-C10-00170","Twelve (12) Inch Yellow Longitudinal Centerline, Two - Four (4) Inch Yellow Lines with Four (4) Inch Separation",570,"LF",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$83:$F$84)","v":{"v":0,"d":"$0.00"}}]
[]
["C11","LANDSCAPE AND HARDSCAPE RESTORATION WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["02800-C11-00020","Topsoil for Street Trees, Backfill Soil Mixture of 3/4 Existing Soil and 1/4 Organic Material (per Arlington County DPR Specification)",2,"CY",null,{"$f":"IFERROR($C89*$E89, \"\")","v":{"v":0,"d":"$0.00"}}]
["02801-C11-00060","Sod, Tall Fescue/Bluegrass Mixture",17,"SY",null,{"v":0,"d":"$0.00"}]
["02800-C11-00120","Flagstone Walkway, Remove & Reset or Replace to Match Existing",1,"SY",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$89:$F$91)","v":{"v":0,"d":"$0.00"}}]
[]
["C12",{"$f":"VLOOKUP(A94,#REF!,2,FALSE)","v":{"$error":"#REF!"}}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!#REF!)","v":{"$error":"#REF!"}}]
[]
["C13",{"$f":"VLOOKUP(A98,#REF!,2,FALSE)","v":{"$error":"#REF!"}}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!#REF!)","v":{"$error":"#REF!"}}]
[]
["C15",{"$f":"VLOOKUP(A102,#REF!,2,FALSE)","v":{"$error":"#REF!"}}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!#REF!)","v":{"$error":"#REF!"}}]
[]
["C16",{"$f":"VLOOKUP(A106,#REF!,2,FALSE)","v":{"$error":"#REF!"}}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[{"$nulls":3},{"$f":"SUBTOTAL(103,Unit_Price_Tab!#REF!)","v":{"$error":"#REF!"}},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!#REF!)","v":{"$error":"#REF!"}}]
[]
["C17",{"$f":"VLOOKUP(A110,#REF!,2,FALSE)","v":{"$error":"#REF!"}}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!#REF!)","v":{"$error":"#REF!"}}]
[]
["C18",{"$f":"VLOOKUP(A114,#REF!,2,FALSE)","v":{"$error":"#REF!"}}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!#REF!)","v":{"$error":"#REF!"}}]
[]
[]
["C13","EROSION AND SEDIMENT CONTROL WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["01500-C13-00010","Silt Fence, with Wire Support (Virginia Erosion & Sediment Control Handbook Standard & Specification 3.05)",200,"LF",null,{"$f":"IFERROR($C121*$E121, \"\")","v":{"v":0,"d":"$0.00"}}]
["01500-C13-00040","Storm Drain Inlet Protection, Gravel & Wire Mesh Drop Inlet Application (per Virginia Erosion & Sediment Control Handbook Standard & Specification 3.07)",28,"EA",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$89:$F$91)","v":{"v":0,"d":"$0.00"}}]
[]
[]
[{"$nulls":4}," CONTRACT TOTAL (EXCLUDING PERCENTAGE ITEMS)",{"v":0,"d":"$0.00"}]
[]
[]
["PCT","PERCENTAGE LINE ITEMS"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["01000-C16-00010","Maintenance of Traffic (MOT)",1,"%",null,{"v":0,"d":"$0.00"}]
["01000-C16-00030","Mobilization and De-Mobilization",1,"%",null,{"v":0,"d":"$0.00"}]
["01500-SA-00200","SWPPP Administration",1,"%",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"PERCENTAGE LINE ITEMS SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$131:$F$133)","v":{"v":0,"d":"$0.00"}}]
[]
[]
[]
[{"$nulls":4},"PROJECT TOTAL",{"v":0,"d":"$0.00"}]