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

{"sheet":"Unit_Price_Tab","index":0,"n_rows":96,"n_cols":7,"rows_kept":96,"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) and Bringing to Final Grade",1800,"CY",null,{"$f":"IFERROR($C8*$E8, \"\")","v":{"v":0,"d":"$0.00"}}]
["02200-C1-00100","Aggregate, VDOT #1 (Compacted in Place per VDOT standards & Specs)",180,"CY",null,{"v":0,"d":"$0.00"}]
["02200-C1-00130","Aggregate, VDOT #21-A  (Compacted in Place per VDOT standards & Specs)",425,"CY",null,{"v":0,"d":"$0.00"}]
["02210-C1-00180","Riprap, Dry Class II",86,"SY",null,{"v":0,"d":"$0.00"}]
["02210-C1-00200","Riprap, Grouted",421,"SY",null,{"v":0,"d":"$0.00"}]
["02200-C1-SP015","Excavation and Bringing to Final Grade",6700,"CY",null,{"$f":"IFERROR($C13*$E13, \"\")","v":{"v":0,"d":"$0.00"}}]
["01400-C1-00030","Test Pits (or Test Bores), Up to 6' Deep (with restoration)",1,"EA",null,{"$f":"IFERROR($C14*$E14, \"\")","v":{"v":0,"d":"$0.00"}}]
["0200-C1-SP055","Clay Core (GC, SC, CL Soils with 95% Compaction)",250,"CY",null,{"$f":"IFERROR($C15*$E15, \"\")","v":{"v":0,"d":"$0.00"}}]
["02200-C1-SP075","Tri-Axial Geogrid - Tensar TX140 or approved equialent. Only for use within the pond when weak soils are encountered and over excavation is needed.",1450,"SY",null,{"$f":"IFERROR($C16*$E16, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$8:$F$16)","v":{"v":0,"d":"$0.00"}}]
[]
["C2","CONCRETE WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT PRICE","TOTAL","Column1"]
["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.",12,"LF",null,{"$f":"IFERROR($C21*$E21, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$21:$F$21)","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)",105,"TON",null,{"$f":"IFERROR($C26*$E26, \"\")","v":{"v":0,"d":"$0.00"}}]
["02600-C3-00060","Asphalt Concrete, Surface Course (VDOT SM-9.5A)",42,"TON",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$26:$F$27)","v":{"v":0,"d":"$0.00"}}]
[]
["C4","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",12,"LF",null,{"$f":"IFERROR($C32*$E32, \"\")","v":{"v":0,"d":"$0.00"}}]
["02500-C4-00720","30\" Pipe, RCP Class III, In Place Up to 6' Deep",96,"LF",null,{"v":0,"d":"$0.00"}]
["02500-C4-00730","30\" Pipe, RCP Class III, In Place 6' to 12' Deep",112,"LF",null,{"v":0,"d":"$0.00"}]
["02500-C4-00020","Storm Manhole PH-1 (Arlington County Detail D-3.1), In Place, DEPTH   8'",5,"EA",null,{"v":0,"d":"$0.00"}]
["02505-C4-00250","Curb Drop Inlet, Standard VDOT DI-3B (12\" to 30\" Pipe), In Place Up to 8' Deep, Inlet Throat Length 4' to 20'",1,"EA",null,{"v":0,"d":"$0.00"}]
["02505-C4-00400","Yard Inlet Pre-Cast (Arlington County Detail D-1.11), In Place Up to 6' Deep",1,"EA",null,{"v":0,"d":"$0.00"}]
["02500-C4-03410","Standard wing for 4' high box culvert ( 1 side only)- VDOT Road and Bridge Standards - Section 1000",2,"EA",null,{"v":0,"d":"$0.00"}]
["02500-C4-02340","Standard Endwall for pipe culverts 36\" circular (VDOT standard EW-1)",1,"EA",null,{"v":0,"d":"$0.00"}]
["02500-C4-02510","Standard Endwall for pipe culverts 48\" circular (VDOT standard EW-2)",1,"EA",null,{"v":0,"d":"$0.00"}]
["02500-C4-00021","Storm Manhole PH-1 (Arlington County Detail D-3.1), In Place, PER ADDITIONAL VF OVER 8'",8,"VF",null,{"v":0,"d":"$0.00"}]
["02500-C4-SP765","36\" Pipe, RCP Class V, In Place Up to 6' Deep",23,"LF",null,{"$f":"IFERROR($C42*$E42, \"\")","v":{"v":0,"d":"$0.00"}}]
["02500-C4-SP032","4'x8' single box culvert (Fills to 25')- VDOT Road and Bridge Standards - Section 1000",114,"LF",null,{"$f":"IFERROR($C43*$E43, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$32:$F$43)","v":{"v":0,"d":"$0.00"}}]
[]
["C10","PAVEMENT MARKING AND SIGNAGE WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["02900-C10-00040","Eighteen (18) Inch Transverse Markings",10,"LF",null,{"$f":"IFERROR($C48*$E48, \"\")","v":{"v":0,"d":"$0.00"}}]
["02900-C10-00070","Four (4) Inch Longitudinal Solid Line",84,"LF",null,{"v":0,"d":"$0.00"}]
["02900-C10-00120","Six (6) Inch Longitudinal Solid Line",20,"LF",null,{"v":0,"d":"$0.00"}]
["02619-C10-00410","Traffic Control Sign (Typical Stop, Yield, No Parking, Speed Limit, or Similar)",4,"EA",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$48:$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",392,"CY",null,{"$f":"IFERROR($C56*$E56, \"\")","v":{"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)",73,"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)",22,"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)",8,"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)",7,"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)",2,"EA",null,{"v":0,"d":"$0.00"}]
["02800-C11-00602","Trees, Deciduous - 1.5 to 2.0\" caliper",120,"EA",null,{"v":0,"d":"$0.00"}]
["02800-C11-01000","Herbaceous plants ( 3\" Deep plug Minimum)",1420,"EA",null,{"v":0,"d":"$0.00"}]
["02800-C11-01100","Shrub (#3 Container)- Container or B&B",200,"EA",null,{"v":0,"d":"$0.00"}]
["02800-C11-SP055","Ripariain Seed Mix (Planting Plan)",4200,"SY",null,{"$f":"IFERROR($C65*$E65, \"\")","v":{"v":0,"d":"$0.00"}}]
["02800-C11-SP056","Turfgrass Seed Mix (Planting Plan)",500,"SY",null,{"v":0,"d":"$0.00"}]
[null,"Deer and Beaver Protection",200,"LF",null,{"v":0,"d":"$0.00"}]
[null,"Live Stakes",200,"EA",null,{"v":0,"d":"$0.00"}]
[null,"Pre-Construction Invasive Species Control",2,"AC",null,{"v":0,"d":"$0.00"}]
[null,"Post-Construction Maintenance of Landscape",1,"LS",null,{"v":0,"d":"$0.00"}]
[]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$56:$F$66)","v":{"v":0,"d":"$0.00"}}]
[]
[]
["C17","STORMWATER WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["ACSWM-C17-00350","30mil HDPE or PVC Impermeable liner installed in place",85,"SY",null,{"$f":"IFERROR($C77*$E77, \"\")","v":{"v":0,"d":"$0.00"}}]
["ASCWM-C17-SP235","Riser structure and appurtenances (hand rail, trash rack, beaver leveler, etc.). Furnish and install per plan specifications",1,"LS",null,{"$f":"IFERROR($C78*$E78, \"\")","v":{"v":0,"d":"$0.00"}}]
["ASCWM-C17-SP236","Storm manhole for box culverts - Detail D05",1,"LS",null,{"$f":"IFERROR($C79*$E79, \"\")","v":{"v":0,"d":"$0.00"}}]
[null,"Armorflex ARTICULATING CONCRETE BLOCK (ACB) SYSTEM",1340,"SF"]
[null,"Pond Access Gate",1,"LS"]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$77:$F$79)","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","NA","%",{"v":0,"d":"0.00%"},{"$f":"Unit_Price_Tab!$E88*$F$84","v":{"v":0,"d":"$0.00"}}]
["01000-C16-00010","Maintenance of Traffic (MOT)","NA","%",null,{"$f":"Unit_Price_Tab!$E89*$F$84","v":{"v":0,"d":"$0.00"}}]
["01000-C16-00030","Mobilization and De-Mobilization","NA","%",null,{"$f":"Unit_Price_Tab!$E90*$F$84","v":{"v":0,"d":"$0.00"}}]
["01500-SA-00200","SWPPP Administration","NA","%",null,{"$f":"Unit_Price_Tab!$E91*$F$84","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"PERCENTAGE LINE ITEMS SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$88:$F$91)","v":{"v":0,"d":"$0.00"}}]
[]
[]
[]
[{"$nulls":4},"PRIMARY CONTRACT :",{"$f":"$F$92+F84","v":{"v":0,"d":"$0.00"}}]