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

{"sheet":"Unit_Price_Tab","index":0,"n_rows":107,"n_cols":6,"rows_kept":107,"merged":[[1,0,1,5]]}
[{"$nulls":3},"PREPARED BY:","k.patel"]
["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:","P. Rigby"]
[]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","N. Pershing Dr. & WB.","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)",51,"CY",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)",87,"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","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.",46,"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.",552,"LF",null,{"v":0,"d":"$0.00"}]
["02611-C2-00110","Concrete Sidewalk, 4\" Thickness (Arlington County Detail R-2.0)",516,"SY",null,{"v":0,"d":"$0.00"}]
["02611-C2-00190","CG-12 Detectable Warning Surface - Truncated Domes",18,"SY",null,{"v":0,"d":"$0.00"}]
["02611-C2-00180","Concrete Driveway Entrance, 9\" Thick Commercial (Arlington County Details R-2.4A, R-2.4B, R-2.4C, R-2.4D)",41,"SY",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-00010","Asphalt Concrete, Planing or Milling (1/2\" to 3\" Depth)",927,"SY",null,{"$f":"IFERROR($C23*$E23, \"\")","v":{"v":0,"d":"$0.00"}}]
["02600-C3-00030","Asphalt Concrete, Base Course (VDOT BM-25.0A)",22,"TON",null,{"v":0,"d":"$0.00"}]
["02600-C3-00060","Asphalt Concrete, Surface Course (VDOT SM-9.5A)",118,"TON",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$23:$F$25)","v":{"v":0,"d":"$0.00"}}]
[]
["C4","STORM SEWER UTILITY WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["02500-C4-00620","15\" Pipe, RCP Class III, In Place Up to 6' Deep",12,"LF",null,{"$f":"IFERROR($C30*$E30, \"\")","v":{"v":0,"d":"$0.00"}}]
["02505-C4-01480","Abandon storm pipe in place Including capping all open ends and completely filling sewer with flowable fill (All material types, sizes and depths)",10,"LF",null,{"v":0,"d":"$0.00"}]
["02505-C4-00010","Storm Manhole MH-1 (Arlington County Detail D-3.0), In Place, DEPTH   8'",1,"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.",2,"EA",null,{"v":0,"d":"$0.00"}]
["02505-C4-00600","Storm Manhole, Catch Basin, Drop Inlet, Yard Inlet, or Grate Inlet, Remove",2,"EA",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$30:$F$34)","v":{"v":0,"d":"$0.00"}}]
[]
[]
["C6","WATERMAIN WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["02550-C6-00250","Remove Existing Fire Hydrant",1,"EA",null,{"$f":"IFERROR($C40*$E40, \"\")","v":{"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"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$40:$F$41)","v":{"v":0,"d":"$0.00"}}]
[]
[]
["C8","TRAFFIC SIGNAL WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["13160-C8-03XTS","Temporary traffic Signals installation as per plan (per latest Arlington County traffic signal and streetlight specifications)",1,"LS",null,{"$f":"IFERROR($C47*$E47, \"\")","v":{"v":0,"d":"$0.00"}}]
["13160-C8-03000","Proposed Traffic Control Signals & Communications installation as per plan (per latest Arlington County traffic signal and streetlight specifications)",1,"LS",null,{"$f":"IFERROR($C48*$E48, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$48:$F$48)","v":{"v":0,"d":"$0.00"}}]
[]
[]
["C10","PAVEMENT MARKING AND SIGNAGE WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["02900-C10-00010","Four (4) Inch Transverse Markings",50,"LF",null,{"$f":"IFERROR($C54*$E54, \"\")","v":{"v":0,"d":"$0.00"}}]
["02900-C10-00020","Six (6) Inch Transverse Markings",150,"LF",null,{"v":0,"d":"$0.00"}]
["02900-C10-00040","Eighteen (18) Inch Transverse Markings",25,"LF",null,{"v":0,"d":"$0.00"}]
["02900-C10-00050","Twenty Four (24) Inch Transverse Markings, Note: Used For Continental (Ladder) Crosswalk",710,"LF",null,{"v":0,"d":"$0.00"}]
["02900-C10-00070","Four (4) Inch Longitudinal Solid Line",300,"LF",null,{"v":0,"d":"$0.00"}]
["02900-C10-00080","Four (4) Inch Longitudinal Skip Line (Ten (10) Foot Line/Thirty (30) Foot Spacing), Note: Forty (40) LF Consists of Ten (10) LF of Marking and Thirty (30) LF of Space",100,"LF",null,{"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",150,"LF",null,{"v":0,"d":"$0.00"}]
["02900-C10-00240","Single Arrows",2,"EA",null,{"v":0,"d":"$0.00"}]
["02900-C10-00250","Combination Arrows",2,"EA",null,{"v":0,"d":"$0.00"}]
["02900-C10-00290","Standard Bicycle Symbols (MUTCD, Chapter 9C, Figure 9C-3), \"Bike Symbol\", \"Helmeted Bicyclist Symbol\"",6,"EA",null,{"v":0,"d":"$0.00"}]
["02900-C10-00360","Removal of Existing Longitudinal Lines (Up To and Including Six (6) Inch Width), Note: Base Unit For Removal",200,"LF",null,{"v":0,"d":"$0.00"}]
["02900-C10-00410","Traffic Control Sign (Typical Stop, Yield, No Parking, Speed Limit, or Similar), Install per Detail SG-1.0",6,"EA",null,{"v":0,"d":"$0.00"}]
["02900-C10-00430","Traffic Control Sign (Typical Stop, Yield, No Parking, Speed Limit, or Similar), Relocate with New Post",2,"EA",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$54:$F$66)","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",32,"CY",null,{"$f":"IFERROR($C71*$E71, \"\")","v":{"v":0,"d":"$0.00"}}]
["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)",12,"CY",null,{"v":0,"d":"$0.00"}]
["02800-C11-00030","Countinuious soil panel (per Arlington County DPR detail 329300.11)",14,"CY",null,{"v":0,"d":"$0.00"}]
["02801-C11-00070","Sod",84,"SY",null,{"v":0,"d":"$0.00"}]
["02800-C11-00606","Trees, Deciduous -4'-5' in height",2,"EA",null,{"v":0,"d":"$0.00"}]
["02800-C11-01020","Herbaceous Plant (#1 Container)",800,"EA",null,{"v":0,"d":"$0.00"}]
["311300-C11-00084","Root Protection Matting",100,"SF",null,{"v":0,"d":"$0.00"}]
["02800-C11-00100","Brick Pavers, Including Concrete Base (Arlington County Detail R-2.1)",20,"SY",null,{"v":0,"d":"$0.00"}]
["02800-C11-00110","Brick Pavers, Remove and Reset (Arlington County Detail R-2.1)",20,"SY",null,{"v":0,"d":"$0.00"}]
["02800-C11-00300","Landscape Wall, Repoint and Repair",10,"SY",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$71:$F$80)","v":{"v":0,"d":"$0.00"}}]
[]
["C12","BUS STOP SHELTER AND FURNISHINGS"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["13130-C12-00100","Provide & Install 6' Free-standing Bench (Supplemental Spec 13230)",2,"EA",null,{"$f":"IFERROR($C85*$E85, \"\")","v":{"v":0,"d":"$0.00"}}]
["13130-C12-00150","Provide & Install Traditional/Contemporary Bicycle Rack (Supplemental Spec 13280)",5,"EA",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$85:$F$86)","v":{"v":0,"d":"$0.00"}}]
[]
["C13","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($C91*$E91, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$91:$F$91)","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"]
["01000-C16-00010","Maintenance of Traffic (MOT)",1,"%",null,{"$f":"Unit_Price_Tab!$E100*$F$96","v":{"v":0,"d":"$0.00"}}]
["01000-C16-00030","Mobilization and De-Mobilization",1,"%",null,{"$f":"Unit_Price_Tab!$E101*$F$96","v":{"v":0,"d":"$0.00"}}]
["01500-SA-00200","SWPPP Administration",1,"%",null,{"$f":"Unit_Price_Tab!$E102*$F$96","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"PERCENTAGE LINE ITEMS SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$100:$F$102)","v":{"v":0,"d":"$0.00"}}]
[]
[]
[]
[{"$nulls":4},"GRAND TOTAL :",{"$f":"$F$103+F96","v":{"v":0,"d":"$0.00"}}]