{"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":63,"n_cols":6,"rows_kept":63,"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-00070","Geotextile Drainage Fabric In Place (VDOT Section 245.03.c)",100,"SY",null,{"$f":"IFERROR($C8*$E8, \"\")","v":{"v":0,"d":"$0.00"}}]
["02200-C1-00080","Geotextile for Rip Rap Bedding In Place (VDOT Section 245.03.b)",174,"SY",null,{"v":0,"d":"$0.00"}]
["02200-C1-00160","Aggregate, VDOT #57  (Compacted in Place per VDOT standards & Specs)",17,"CY",null,{"v":0,"d":"$0.00"}]
["02210-C1-00170","Riprap, Dry Class I",29,"SY",null,{"v":0,"d":"$0.00"}]
["02210-C1-10001","Stream Channel Excavation",150,"CY",null,{"$f":"IFERROR($C12*$E12, \"\")","v":{"v":0,"d":"$0.00"}}]
["02210-C1-10002","Disposal of Excavated Material",150,"CY",null,{"$f":"IFERROR($C13*$E13, \"\")","v":{"v":0,"d":"$0.00"}}]
["02210-C1-10003","Class I RBM",107,"CY",null,{"$f":"IFERROR($C14*$E14, \"\")","v":{"v":0,"d":"$0.00"}}]
["02210-C1-10004","Class II RBM",53,"CY",null,{"$f":"IFERROR($C15*$E15, \"\")","v":{"v":0,"d":"$0.00"}}]
["02210-C1-10005","Aggregate, VDOT #3  (Compacted in Place per VDOT standards & Specs)",17,"CY",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"}}]
[]
["C11","LANDSCAPE AND HARDSCAPE RESTORATION WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["02200-C11-00010","Imported Topsoil",21,"CY",null,{"$f":"IFERROR($C21*$E21, \"\")","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)",27,"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)",1,"EA",null,{"v":0,"d":"$0.00"}]
["02800-C11-10001","Modified Cross Vane",1,"EA",null,{"$f":"IFERROR($C24*$E24, \"\")","v":{"v":0,"d":"$0.00"}}]
["02800-C11-10002","Vegetation - Live Stakes (1' O.C.)",2242,"EA",null,{"v":0,"d":"$0.00"}]
["02800-C11-10003","Vegetation - 1 gal. Container (6' O.C.) Overstory",207,"EA",null,{"v":0,"d":"$0.00"}]
["02800-C11-10004","Vegetation - 1 gal. Container (6' O.C.) Understory",144,"EA",null,{"v":0,"d":"$0.00"}]
["02800-C11-10005","Vegetation - 1 gal. Container (6' O.C.) Shrub",672,"EA",null,{"v":0,"d":"$0.00"}]
["02800-C11-10006","Seed (Permanent) and Straw",1452,"SY",null,{"v":0,"d":"$0.00"}]
["02800-C11-10007","Replace existing park sign adjacent to Utah St",1,"LS",null,{"v":0,"d":"$0.00"}]
["02800-C11-10008","Pre-Construction Invasive Species Control",1,"LS",null,{"v":0,"d":"$0.00"}]
["02800-C11-10009","Post-Construction Vegetation Maintenance",1,"LS",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$21:$F$29)","v":{"v":0,"d":"$0.00"}}]
["C13","EROSION AND SEDIMENT CONTROL WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["01500--C13-10001","Wood Chips - 6\" Depth",763,"SY",null,{"$f":"IFERROR($C36*$E36, \"\")","v":{"v":0,"d":"$0.00"}}]
["01500-C13-10002","Tree Trunk Protection",10,"EA",null,{"$f":"IFERROR($C37*$E37, \"\")","v":{"v":0,"d":"$0.00"}}]
["\n01500-C13-00002","Tree Protection/Orange Mesh/Safety Fence",2084,"LF",null,{"v":0,"d":"$0.00"}]
["01500--C13-10004","Deck Mats (Access, Staging, and Stream Crossings)",116,"SY",null,{"$f":"IFERROR($C39*$E39, \"\")","v":{"v":0,"d":"$0.00"}}]
["01500--C13-10005","Coir Fiber Matting",244,"SY",null,{"$f":"IFERROR($C40*$E40, \"\")","v":{"v":0,"d":"$0.00"}}]
["01500--C13-10006","Trenchless Super Silt Fence",183,"LF",null,{"$f":"IFERROR($C41*$E41, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$36:$F$41)","v":{"v":0,"d":"$0.00"}}]
[]
["C15","UNLISTED WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["01000-C15-00280","Bypass Pumping",10,"DAY",null,{"$f":"IFERROR($C46*$E46, \"\")","v":{"v":0,"d":"$0.00"}}]
["01000-C15-SP028","As-Built Survey",1,"LS",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$46:$F$46)","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",{"$f":"VLOOKUP(A54,[1]!Table_BidItem_CategoryClassification[#All],2,FALSE)","v":{"$error":"#REF!"}}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["01000-C16-00010","Maintenance of Traffic (MOT)","NA","%",null,{"$f":"Unit_Price_Tab!$E56*$F$52","v":{"v":0,"d":"$0.00"}}]
["01000-C16-00030","Mobilization and De-Mobilization","NA","%",null,{"$f":"Unit_Price_Tab!$E57*$F$52","v":{"v":0,"d":"$0.00"}}]
["01500-SA-00200","SWPPP Administration","NA","%",null,{"$f":"Unit_Price_Tab!$E58*$F$52","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"PERCENTAGE LINE ITEMS SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$56:$F$58)","v":{"v":0,"d":"$0.00"}}]
[]
[]
[]
[{"$nulls":4},"PROJECT TOTAL :",{"$f":"$F$59+F52","v":{"v":0,"d":"$0.00"}}]