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

{"sheet":"Unit_Price_Tab","index":0,"n_rows":53,"n_cols":6,"rows_kept":53,"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 _____________, 2022.  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-00130","Aggregate, VDOT #21-A  (Compacted in Place per VDOT standards & Specs)",70,"CY",null,{"$f":"IFERROR($C8*$E8, \"\")","v":{"v":0,"d":"$0.00"}}]
["02200-SP-00010","Brick Paver and Concrete Band Removal per Details on Sheet C004.1",70,"CY",null,{"$f":"IFERROR($C9*$E9, \"\")","v":{"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-00060","Concrete Curb & Gutter, Standard C-2 and C-2R (Arlington County Detail R-2.0), includes curb & gutter for aprons, ramps, etc.",119,"LF",null,{"$f":"IFERROR($C14*$E14, \"\")","v":{"v":0,"d":"$0.00"}}]
["02611-C2-00110","Concrete Sidewalk, 4\" Thickness (Arlington County Detail R-2.0)",140,"SY",null,{"v":0,"d":"$0.00"}]
["02611-C2-00190","CG-12 Detectable Warning Surface - Truncated Domes",5,"SY",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$14:$F$16)","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)",65,"TON",null,{"$f":"IFERROR($C21*$E21, \"\")","v":{"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$21:$F$22)","v":{"v":0,"d":"$0.00"}}]
[]
["C8","TRAFFIC SIGNAL WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["13160-C8-03000","Traffic Signal Upgrade",1,"LS",null,{"$f":"IFERROR($C27*$E27, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$27:$F$27)","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",76,"LF",null,{"$f":"IFERROR($C32*$E32, \"\")","v":{"v":0,"d":"$0.00"}}]
["02900-C10-00050","Twenty Four (24) Inch Transverse Markings, Note: Used For Continental (Ladder) Crosswalk",498,"LF",null,{"v":0,"d":"$0.00"}]
["02900-C10-00120","Six (6) Inch Longitudinal Solid Line",55,"LF",null,{"v":0,"d":"$0.00"}]
["02900-C10-00160","Six (6) Inch Longitudinal Skip Line (Two (2) Foot Line/ Four (4) Foot Spacing), Note: Twelve (12) LF Consists of Two (2) LF of Marking and Four (4) LF of Space",300,"LF",null,{"v":0,"d":"$0.00"}]
["02900-C10-00240","Single Arrows",1,"EA",null,{"v":0,"d":"$0.00"}]
["02900-C10-00300","Standard Bicycle Symbols (MUTCD, Chapter 9C, Figure 9C-9), \"Shared Lane Marking\"",4,"EA",null,{"v":0,"d":"$0.00"}]
["02900-C10-00350","Colorized Bike Lane Coatings (per Specification 02900)",50,"SY",null,{"v":0,"d":"$0.00"}]
["02619-C10-00410","Traffic Control Sign (Typical Stop, Yield, No Parking, Speed Limit, or Similar)",2,"EA",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$32:$F$39)","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","%",null,{"$f":"Unit_Price_Tab!$E47*$F$43","v":{"v":0,"d":"$0.00"}}]
["01000-C16-00010","Maintenance of Traffic (MOT)","NA","%",null,{"$f":"Unit_Price_Tab!$E48*$F$43","v":{"v":0,"d":"$0.00"}}]
["01000-C16-00030","Mobilization and De-Mobilization","NA","%",null,{"$f":"Unit_Price_Tab!$E49*$F$43","v":{"v":0,"d":"$0.00"}}]
["01500-SA-00200","SWPPP Administration","NA","%",null,{"$f":"Unit_Price_Tab!$E50*$F$43","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"PERCENTAGE LINE ITEMS SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$47:$F$50)","v":{"v":0,"d":"$0.00"}}]
[]
[{"$nulls":4},"CONTRACT GRAND TOTAL",{"$f":"$F$51+F43","v":{"v":0,"d":"$0.00"}}]