{"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":98,"n_cols":6,"rows_kept":98,"merged":[[0,1,0,3],[1,0,1,5]]}
[null,"ARLINGTON COUNTY, VIRGINIA\nOFFICE OF THE PURCHASING AGENT\nINVITATION TO BID NO. 21-CPHD-ITB-475\nPROJECT NO.: N559"]
["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)."]
[]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT PRICE","TOTAL"]
["C1","GENERAL EARTH WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT PRICE","TOTAL"]
["02200-C1-00011","General Excavation, for Bioretention work only",116,"CY",null,{"$f":"IFERROR($C7*$E7, \"\")","v":{"v":0,"d":"$0.00"}}]
["02200-C1-00050","Select Borrow (VDOT Section 207 - Select Material, Type I)",290,"CY",null,{"v":0,"d":"$0.00"}]
["02200-C1-00130","Aggregate, VDOT #21-A  (Compacted in Place per VDOT standards & Specs)",363,"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.",8,"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.",910,"LF",null,{"v":0,"d":"$0.00"}]
["02611-C2-00110","Concrete Sidewalk, 4\" Thickness (Arlington County Detail R-2.0)",470,"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)",190,"SY",null,{"v":0,"d":"$0.00"}]
["02750-SP-00010","Concrete Header  Curb, Modified C-3 Arlington County Detail R-2.0. See Sheet 3 for Details  ",500,"LF",null,{"$f":"IFERROR($C18*$E18, \"\")","v":{"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)",53,"SY",null,{"$f":"IFERROR($C23*$E23, \"\")","v":{"v":0,"d":"$0.00"}}]
["02600-C3-00030","Asphalt Concrete, Base Course (VDOT BM-25.0A)",520,"TON",null,{"v":0,"d":"$0.00"}]
["02600-C3-00060","Asphalt Concrete, Surface Course (VDOT SM-9.5A)",38,"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-01010","36\" Pipe, RCP Class IV, In Place 6' to 10' Deep",9,"LF",null,{"$f":"IFERROR($C30*$E30, \"\")","v":{"v":0,"d":"$0.00"}}]
["02505-C4-00520","Convert Catch Basin to Manhole",1,"EA",null,{"v":0,"d":"$0.00"}]
["02505-SP-00020","Yard Inlet (Modified Arlington County Detail D-1.10 per Plan)",1,"EA",null,{"v":0,"d":"$0.00"}]
["02505-SP-00030","Convert Manhole to Catch Basin",1,"EA",null,{"$f":"IFERROR($C33*$E33, \"\")","v":{"v":0,"d":"$0.00"}}]
["02505-SP-00040","Inlet Shaping, Arlington County Detail D-2.1 (Inspect and if Absent, Provide)",2,"EA",null,{"$f":"IFERROR($C34*$E34, \"\")","v":{"v":0,"d":"$0.00"}}]
["02505-SP-00050","Trench Drain per Details on Sheet 37 ",1,"EA",null,{"$f":"IFERROR($C35*$E35, \"\")","v":{"v":0,"d":"$0.00"}}]
["02500-SP-00060","Sump Pump and Private Drainage Pipe Connection to Existing Storm Pipe per Details on Sheet 21B, Including All Materials and Work Required to Complete Installation ",2,"EA",null,{"$f":"IFERROR($C36*$E36, \"\")","v":{"v":0,"d":"$0.00"}}]
["02500-SP-00070","12\" Pipe, RCP Class III, In Place 6' to 8' Deep",20,"LF",null,{"$f":"IFERROR($C37*$E37, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$30:$F$37)","v":{"v":0,"d":"$0.00"}}]
[]
[]
["C6","WATERMAIN WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["02550-SP-00080","Spiked Water Meter Cover for Water Meters Cast in Concrete, Per Detail on Sheet 3",7,"EA",null,{"$f":"IFERROR($C43*$E43, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$43:$F$43)","v":{"v":0,"d":"$0.00"}}]
[]
[]
["C10","PAVEMENT MARKING AND SIGNAGE WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["02900-C10-00170","Twelve (12) Inch Yellow Longitudinal Centerline, Two - Four (4) Inch Yellow Lines with Four (4) Inch Separation",50,"LF",null,{"$f":"IFERROR($C49*$E49, \"\")","v":{"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",17,"EA",null,{"v":0,"d":"$0.00"}]
["02900-C10-00420","Traffic Control Sign (Typical Stop, Yield, No Parking, Speed Limit, or Similar), Relocate with Existing Post",2,"EA",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$49:$F$51)","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",85,"CY",null,{"$f":"IFERROR($C56*$E56, \"\")","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)",45,"CY",null,{"v":0,"d":"$0.00"}]
["02801-C11-00060","Sod, Tall Fescue/Bluegrass Mixture",763,"SY",null,{"v":0,"d":"$0.00"}]
["02800-C11-01000","Herbaceous plants ( 3\" Deep plug Minimum)",104,"EA",null,{"v":0,"d":"$0.00"}]
["02800-C11-01010","Herbaceous Plant (Quart)",14,"EA",null,{"v":0,"d":"$0.00"}]
["02800-C11-01020","Herbaceous Plant (#1 Container)",242,"EA",null,{"v":0,"d":"$0.00"}]
["02800-C11-01090","Shrub (#2 Container)- Container or B&B",15,"EA",null,{"v":0,"d":"$0.00"}]
["02800-C11-00110","Brick Pavers, Remove and Reset (Arlington County Detail R-2.1)",13,"SY",null,{"v":0,"d":"$0.00"}]
["02800-C11-00120","Flagstone Walkway, Remove & Reset or Replace to Match Existing",44,"SY",null,{"v":0,"d":"$0.00"}]
["311300-C11-00082","Tree Pruning",2,"EA",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$56:$F$64)","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($C70*$E70, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$70:$F$70)","v":{"v":0,"d":"$0.00"}}]
[]
["C17","STORMWATER WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["ACSWM-C17-00009","Aggregate, Double Washed VDOT #8 (Uncompacted in Place, Choking Layer)",5,"CY",null,{"$f":"IFERROR($C75*$E75, \"\")","v":{"v":0,"d":"$0.00"}}]
["ACSWM-C17-00020","Aggregate, Double Washed VDOT #57-A (Uncompacted in Place)",19,"CY",null,{"v":0,"d":"$0.00"}]
["ACSWM-C17-00030","Inlet Protection/ Energy Dissipaton (3\"-6\" Rounded River Rock)",2,"CY",null,{"v":0,"d":"$0.00"}]
["02200-C1-00070","Geotextile Drainage Fabric in Place (VDOT Section 245.03.c)",5,"SY",null,{"v":0,"d":"$0.00"}]
["02200-C1-00071","Geotextile Stabilization Fabric In Place (VDOT Section 245.03.d.2)",27,"SY",null,{"v":0,"d":"$0.00"}]
["ACSWM-C17-00350","30mil HDPE or PVC Impermeable liner installed in place",7,"SY",null,{"v":0,"d":"$0.00"}]
["ACSWM-C17-00050","6\" Perforated Pipe, PVC ( Schedule 40 or SDR 35, perforated 3/8\" holes at 6\" on center, Maximum of 3 rows of perforations) in Place up to 6' Deep)",50,"LF",null,{"v":0,"d":"$0.00"}]
["ACSWM-C17-00110","Bioretention Filter Media",56,"CY",null,{"v":0,"d":"$0.00"}]
["ACSWM-C17-00300","PVC Cleanout with Cap",2,"EA",null,{"v":0,"d":"$0.00"}]
["ACSWM-C17-00500","Thickened Concrete Curb & Gutter - Detail in special conditions - See ITB Attachment",11,"CY",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$75:$F$84)","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)","NA","%",null,{"$f":"Unit_Price_Tab!$E91*$F$87","v":{"v":0,"d":"$0.00"}}]
["01000-C16-00030","Mobilization and De-Mobilization","NA","%",null,{"$f":"Unit_Price_Tab!$E92*$F$87","v":{"v":0,"d":"$0.00"}}]
["01500-SA-00200","SWPPP Administration","NA","%",null,{"$f":"Unit_Price_Tab!$E93*$F$87","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"PERCENTAGE LINE ITEMS SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$91:$F$93)","v":{"v":0,"d":"$0.00"}}]
[]
[]
[]
[{"$nulls":4},"PROJECT TOTAL:",{"$f":"$F$94+F87","v":{"v":0,"d":"$0.00"}}]