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

{"sheet":"Unit_Price_Tab","index":0,"n_rows":79,"n_cols":6,"rows_kept":79,"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-00010","General Excavation, only when not included in other pay items",5120,"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)",188,"CY",null,{"v":0,"d":"$0.00"}]
["02200-C1-00140","Aggregate, VDOT #21-B  (Compacted in Place per VDOT standards & Specs)",63,"CY",null,{"v":0,"d":"$0.00"}]
[null,"Repair or Replace existing Gabion Cage as needed",1,"LS",null,{"$f":"IFERROR($C11*$E11, \"\")","v":{"v":0,"d":"$0.00"}}]
[null,"Invasive Species Treatment Removal in Meadow Areas",1,"LS",null,{"$f":"IFERROR($C12*$E12, \"\")","v":{"v":0,"d":"$0.00"}}]
[null,"Clear and Grub",1.08,"AC",null,{"$f":"IFERROR($C13*$E13, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$8:$F$13)","v":{"v":0,"d":"$0.00"}}]
[]
["C2","CONCRETE WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT PRICE","TOTAL"]
["02611-C2-00110","Concrete Sidewalk, 4\" Thickness (Arlington County Detail R-2.0)",562,"SY",null,{"$f":"IFERROR($C18*$E18, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$18:$F$18)","v":{"v":0,"d":"$0.00"}}]
[]
["C4","STORM SEWER UTILITY WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["02500-C4-01190","12\" Pipe, HDPE, In Place Up to 6' Deep",{"$f":"18*2+27*2","v":90},"LF",null,{"$f":"IFERROR($C23*$E23, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$23:$F$23)","v":{"v":0,"d":"$0.00"}}]
[]
["C9","STREET LIGHTING WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["14030-C9-00130","Trenching- Earth",123,"LF",null,{"$f":"IFERROR($C28*$E28, \"\")","v":{"v":0,"d":"$0.00"}}]
[null,"Conduit, in trench, Rigid galvanized steel, 2-1/2\" diameter.",123,"LF",null,{"$f":"IFERROR($C29*$E29, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$28:$F$29)","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",20,"LF",null,{"$f":"IFERROR($C34*$E34, \"\")","v":{"v":0,"d":"$0.00"}}]
["02900-C10-00070","Four (4) Inch Longitudinal Solid Line",326,"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",9,"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",1,"EA",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$34:$F$37)","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",329,"CY",null,{"$f":"IFERROR($C42*$E42, \"\")","v":{"v":0,"d":"$0.00"}}]
["02801-C11-00050","Seed, Mixture of 85% Tall Fescue/Bluegrass and 15% Annual Rye",{"$f":"2656+936","v":3592},"SY",null,{"v":0,"d":"$0.00"}]
["02801-C11-00060","Sod, Tall Fescue/Bluegrass Mixture",824,"SY",null,{"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)",4,"EA",null,{"v":0,"d":"$0.00"}]
["02800-C11-00603","Trees, Deciduous - 2.0 to 2.5\" caliper",{"$f":"7+8","v":15},"EA",null,{"v":0,"d":"$0.00"}]
["02800-C11-00609","Trees, Deciduous -8'-10' in height",6,"EA",null,{"v":0,"d":"$0.00"}]
["02800-C11-01090","Shrub (#2 Container)- Container or B&B",230,"EA",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$42:$F$48)","v":{"v":0,"d":"$0.00"}}]
[]
["C13","EROSION AND SEDIMENT CONTROL WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["01500-C13-00005","Gravel construction entrance, including wash rack (per Virginia Erosion & Sediment Control Handbook Standard & Specification 3.02)",1,"EA",null,{"$f":"IFERROR($C53*$E53, \"\")","v":{"v":0,"d":"$0.00"}}]
["01500-C13-00010","Silt Fence, with Wire Support (Virginia Erosion & Sediment Control Handbook Standard & Specification 3.05)",1592,"LF",null,{"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)",4,"EA",null,{"v":0,"d":"$0.00"}]
["01500-C13-00100","Install and Remove Temporary Diversion Dike (per Virginia Erosion & Sediment Control Handbook Standard & Specification 3.09)",603,"LF",null,{"v":0,"d":"$0.00"}]
["01500-C13-00110","Rock Check Dam (per Virginia Erosion & Sediment Control Handbook Standard & Specification 3.20)",6,"EA",null,{"v":0,"d":"$0.00"}]
["01500-C13-00130","6' Chain Link Tree Protection Fence (per Arlington County DPR Standard 02231.1)",385,"LF",null,{"v":0,"d":"$0.00"}]
["01500-C13-00150","Root Pruning (per Arlington County DPR Standard 02231.5)",262,"LF",null,{"v":0,"d":"$0.00"}]
["01500-C13-00500","Permanent Soil stabilization mat - slope installation, Type C (VDOT standard EC-3) includes biodegradable stake.",2186,"SY",null,{"v":0,"d":"$0.00"}]
[null,"Super Silt Fence, with Chain link fence must be 39\" above grade with 3\" embedded for a total fabric of 42\". The post must be 42\" above grade with 30\" place below grade (without concrete) for a total length of 72\"",1092,"LF",null,{"$f":"IFERROR($C61*$E61, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$53:$F$61)","v":{"v":0,"d":"$0.00"}}]
[]
[null,"MOT"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["01000-C16-00010","Maintenance of Traffic (MOT)",1,"LS",null,{"$f":"IFERROR($C66*$E66, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$66)","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-00030","Mobilization and De-Mobilization","NA","%",{"v":0.05,"d":"5%"},{"$f":"Unit_Price_Tab!$E73*$F$69","v":{"v":0,"d":"$0.00"}}]
["01500-SA-00200","SWPPP Administration","NA","%",null,{"$f":"Unit_Price_Tab!$E74*$F$69","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"PERCENTAGE LINE ITEMS SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$73:$F$74)","v":{"v":0,"d":"$0.00"}}]
[]
[]
[]
[{"$nulls":4},"PRIMARY CONTRACT :",{"$f":"$F$75+F69","v":{"v":0,"d":"$0.00"}}]