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

{"sheet":"Unit_Price_Tab","index":0,"n_rows":71,"n_cols":6,"rows_kept":71,"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",{"$f":"VLOOKUP(A7,[1]!Table_BidItem_CategoryClassification[#All],2,FALSE)","v":"GENERAL EARTH WORK"}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT PRICE","TOTAL"]
["02200-C1-00130","Aggregate, VDOT #21-A  (Compacted in Place per VDOT standards & Specs)",233,"CY",null,{"$f":"IFERROR($C9*$E9, \"\")","v":{"v":0,"d":"$0.00"}}]
["02200-C1-SP001","Supersonic AirTool Excavation (per Arlington County Specification 02410)",120,"CF",null,{"$f":"IFERROR($C10*$E10, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$9:$F$10)","v":{"v":0,"d":"$0.00"}}]
[]
["C2",{"$f":"VLOOKUP(A13,[1]!Table_BidItem_CategoryClassification[#All],2,FALSE)","v":"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.",109,"LF",null,{"$f":"IFERROR($C15*$E15, \"\")","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.",1316,"LF",null,{"v":0,"d":"$0.00"}]
["02611-C2-00110","Concrete Sidewalk, 4\" Thickness (Arlington County Detail R-2.0)",611,"SY",null,{"v":0,"d":"$0.00"}]
["02611-C2-SP001","Suspended sidewalk detail per sheet C002.1",7,"SY",null,{"$f":"IFERROR($C18*$E18, \"\")","v":{"v":0,"d":"$0.00"}}]
["02611-C2-00190","CG-12 Detectable Warning Surface - Truncated Domes",11,"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)",221,"SY",null,{"v":0,"d":"$0.00"}]
["03100-C2-00200","Concrete Steps Each (Arlington County Detail R-3.0, including all reinforcing bars as shown in detail)",30,"LF-W",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$15:$F$21)","v":{"v":0,"d":"$0.00"}}]
[]
["C3",{"$f":"VLOOKUP(A24,[1]!Table_BidItem_CategoryClassification[#All],2,FALSE)","v":"ASPHALT WORK"}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["02600-C3-00030","Asphalt Concrete, Base Course (VDOT BM-25.0A)",93,"TON",null,{"$f":"IFERROR($C26*$E26, \"\")","v":{"v":0,"d":"$0.00"}}]
["02600-C3-00060","Asphalt Concrete, Surface Course (VDOT SM-9.5A)",37,"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",{"$f":"VLOOKUP(A30,[1]!Table_BidItem_CategoryClassification[#All],2,FALSE)","v":"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",25,"LF",null,{"$f":"IFERROR($C32*$E32, \"\")","v":{"v":0,"d":"$0.00"}}]
["02550-C4-01412","4\" Pipe, PVC ( Schedule 40 or SDR 35) in Place up to 6' Deep",140,"LF",null,{"v":0,"d":"$0.00"}]
["02505-C4-00080","CB-2 (Arlington County Standards), In Place Up to 6' Deep",1,"EA",null,{"v":0,"d":"$0.00"}]
["02505-C4-00190","Curb Drop Inlet, Standard VDOT DI-2C (12\" to 24\" Pipe), In Place Up to 9' Deep, Inlet Throat Length 6' to 20'",1,"EA",null,{"v":0,"d":"$0.00"}]
["02505-C4-00520","Convert Catch Basin to Manhole",1,"EA",null,{"v":0,"d":"$0.00"}]
["02500-C4-SP001","Culvert plan detail per sheet C002.1",1,"EA",null,{"$f":"IFERROR($C37*$E37, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$32:$F$37)","v":{"v":0,"d":"$0.00"}}]
[]
["C10",{"$f":"VLOOKUP(A40,[1]!Table_BidItem_CategoryClassification[#All],2,FALSE)","v":"PAVEMENT MARKING AND SIGNAGE WORK"}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["02900-C10-00020","Six (6) Inch Transverse Markings",335,"LF",null,{"$f":"IFERROR($C42*$E42, \"\")","v":{"v":0,"d":"$0.00"}}]
["02900-C10-00040","Eighteen (18) Inch Transverse Markings",110,"LF",null,{"v":0,"d":"$0.00"}]
["02900-C10-00050","Twenty Four (24) Inch Transverse Markings, Note: Used For Continental (Ladder) Crosswalk",200,"LF",null,{"v":0,"d":"$0.00"}]
["02619-C10-00410","Traffic Control Sign (Typical Stop, Yield, No Parking, Speed Limit, or Similar)",13,"EA",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$42:$F$45)","v":{"v":0,"d":"$0.00"}}]
[]
["C11",{"$f":"VLOOKUP(A48,[1]!Table_BidItem_CategoryClassification[#All],2,FALSE)","v":"LANDSCAPE AND HARDSCAPE RESTORATION WORK"}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["02800-C11-00030","Topsoil for Street Trees, Purchased Mixture (per Arlington County DPR Specification)",93,"CY",null,{"$f":"IFERROR($C50*$E50, \"\")","v":{"v":0,"d":"$0.00"}}]
["02801-C11-00060","Sod, Tall Fescue/Bluegrass Mixture",832,"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)",1,"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)",1,"EA",null,{"v":0,"d":"$0.00"}]
["02800-C11-00100","Brick Pavers, Including Concrete Base (Arlington County Detail R-2.1)",7,"SY",null,{"v":0,"d":"$0.00"}]
["02800-C11-00120","Flagstone Walkway, Remove & Reset or Replace to Match Existing",3,"SY",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$50:$F$55)","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(A60,[1]!Table_BidItem_CategoryClassification[#All],2,FALSE)","v":"PERCENTAGE LINE ITEMS"}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["01500-C13-10000","Temporary Erosion and Sediment Controls - 5% MAXIMUM",null,"%",{"$f":"C62/100","v":{"v":0,"d":"0.00%"}},{"$f":"Unit_Price_Tab!$E62*$F$58","v":{"v":0,"d":"$0.00"}}]
["01000-C16-00010","Maintenance of Traffic (MOT) - LUMP SUM",null,"$",{"$f":"C63","v":0},{"$f":"E63","v":{"v":0,"d":"$0.00"}}]
["01000-C16-00030","Mobilization and\nDe-Mobilization - 5% MAXIMUM",null,"%",{"$f":"C64/100","v":{"v":0,"d":"0.00%"}},{"$f":"Unit_Price_Tab!$E64*$F$58","v":{"v":0,"d":"$0.00"}}]
["01500-SA-00200","SWPPP Administration",null,"%",{"$f":"C65/100","v":{"v":0,"d":"0.00%"}},{"$f":"Unit_Price_Tab!$E65*$F$58","v":{"v":0,"d":"$0.00"}}]
[]
[{"$nulls":4},"PERCENTAGE LINE ITEMS SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$62:$F$66)","v":{"v":0,"d":"$0.00"}}]
[]
[]
[]
[{"$nulls":4},"PROJECT TOTAL :",{"$f":"$F$67+F58","v":{"v":0,"d":"$0.00"}}]