{"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":97,"n_cols":6,"rows_kept":97,"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)",67,"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)",180,"CY",null,{"$f":"IFERROR($C9*$E9, \"\")","v":{"v":0,"d":"$0.00"}}]
["02200-C1-00140","Aggregate, VDOT #21-B  (Compacted in Place per VDOT standards & Specs)",10,"CY",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$8:$F$10)","v":{"v":0,"d":"$0.00"}}]
[]
["C2","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.",92,"LF",null,{"$f":"IFERROR($C15*$E15, \"\")","v":{"v":0,"d":"$0.00"}}]
["02750-C2-00040","Concrete Curb, Standard 6\" (VDOT CG-2), includes curb for aprons, ramps, etc.",60,"LF",null,{"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.",790,"LF",null,{"v":0,"d":"$0.00"}]
["02611-C2-00110","Concrete Sidewalk, 4\" Thickness (Arlington County Detail R-2.0)",510,"SY",null,{"v":0,"d":"$0.00"}]
["02611-C2-00190","CG-12 Detectable Warning Surface - Truncated Domes",18,"SY",null,{"v":0,"d":"$0.00"}]
["02611-C2-00180","Concrete Driveway Entrance, 9\" Thick Commercial (Arlington County Details R-2.4A, R-2.4B, R-2.4C, R-2.4D)",22,"SY",null,{"v":0,"d":"$0.00"}]
["03100-C2-00230","Concrete and Formwork (VDOT Class A3), only when not included in other pay items",15,"CY",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","ASPHALT WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["02600-C3-00010","Asphalt Concrete, Planing or Milling (1/2\" to 3\" Depth)",1300,"SY",null,{"$f":"IFERROR($C26*$E26, \"\")","v":{"v":0,"d":"$0.00"}}]
["02600-C3-00030","Asphalt Concrete, Base Course (VDOT BM-25.0A)",130,"TON",null,{"v":0,"d":"$0.00"}]
["02600-C3-00060","Asphalt Concrete, Surface Course (VDOT SM-9.5A)",200,"TON",null,{"v":0,"d":"$0.00"}]
["02600-C3-00070","Asphalt Concrete, Surface Course (VDOT SM-9.5D)",10,"TON",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$26:$F$29)","v":{"v":0,"d":"$0.00"}}]
[]
["C4","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",106,"LF",null,{"$f":"IFERROR($C34*$E34, \"\")","v":{"v":0,"d":"$0.00"}}]
["02500-C4-00020","Storm Manhole PH-1 (Arlington County Detail D-3.1), In Place, DEPTH   8'",1,"EA",null,{"v":0,"d":"$0.00"}]
["02505-C4-00120","PCB-2, In Place Up to 6' Deep, Arlington County Standards",1,"EA",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$34:$F$36)","v":{"v":0,"d":"$0.00"}}]
[]
["C6","WATERMAIN WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["02550-C6-00250","Remove Existing Fire Hydrant",1,"EA",null,{"$f":"IFERROR($C41*$E41, \"\")","v":{"v":0,"d":"$0.00"}}]
["02550-C6-00270","Install New Fire Hydrant (includes Fire Hydrant, Gate Valve with Valve Box and up to 20 LF 6-inch DIP CL-52)",1,"EA",null,{"v":0,"d":"$0.00"}]
["02550-C6-00320","Cut & Cap 8-Inch Water Main",1,"EA",null,{"v":0,"d":"$0.00"}]
["02550-C6-00330","Cut & Cap 6-Inch Water Main",1,"EA",null,{"v":0,"d":"$0.00"}]
["02550-C6-00350","Remove Existing Valve Boxes",2,"EA",null,{"v":0,"d":"$0.00"}]
["02550-C6-00540","Abandon Existing Water Main (All sizes and depths)",55,"LF",null,{"$f":"IFERROR($C46*$E46, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$41:$F$46)","v":{"v":0,"d":"$0.00"}}]
[]
["C10","PAVEMENT MARKING AND SIGNAGE WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["02900-C10-00030","Twelve (12) Inch Transverse Markings or 8\" Gore Marking",17,"LF",null,{"$f":"IFERROR($C51*$E51, \"\")","v":{"v":0,"d":"$0.00"}}]
["02900-C10-00040","Eighteen (18) Inch Transverse Markings",35,"LF",null,{"v":0,"d":"$0.00"}]
["02900-C10-00050","Twenty Four (24) Inch Transverse Markings, Note: Used For Continental (Ladder) Crosswalk and Gore Marking",{"$f":"390+34","v":424},"LF",null,{"v":0,"d":"$0.00"}]
["02900-C10-00060","Yield Line Markings (Twenty Four (24) Inch Triangle/Twelve (12) Inch Spacing), Note: LF is Width of Lane for Units",13,"LF",null,{"v":0,"d":"$0.00"}]
["02900-C10-00070","Four (4) Inch Longitudinal Solid Line",{"$f":"630","v":630},"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",145,"LF",null,{"v":0,"d":"$0.00"}]
["02900-C10-00170","Twelve (12) Inch Yellow Longitudinal Centerline, Two - Four (4) Inch Yellow Lines with Four (4) Inch Separation",504,"LF",null,{"v":0,"d":"$0.00"}]
["02900-C10-00240","Single Arrows",2,"EA",null,{"v":0,"d":"$0.00"}]
["02900-C10-00300","Standard Bicycle Symbols (MUTCD, Chapter 9C, Figure 9C-9), \"Shared Lane Marking\"",2,"EA",null,{"v":0,"d":"$0.00"}]
["02619-C10-00410","Traffic Control Sign (Typical Stop, Yield, No Parking, Speed Limit, or Similar)",22,"EA",null,{"v":0,"d":"$0.00"}]
["02619-C10-00430","Traffic Control Sign (Typical Stop, Yield, No Parking, Speed Limit, or Similar), Relocate with New Post",12,"EA",null,{"v":0,"d":"$0.00"}]
["02619-C10-SP445","Flashing Pedestrian Crossing sign system per details on Sheet TS-1",1,"LS",null,{"$f":"IFERROR($C62*$E62, \"\")","v":{"v":0,"d":"$0.00"}}]
["02619-C10-SP441","Remove Existing Sign out of the limits of work",4,"EA",null,{"$f":"IFERROR($C63*$E63, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$51:$F$63)","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",30,"CY",null,{"$f":"IFERROR($C68*$E68, \"\")","v":{"v":0,"d":"$0.00"}}]
["02800-C11-00020","Topsoil for Street Trees, Backfill Soil Mixture of 3/4 Existing Soil and 1/4 Organic Material (per Arlington County DPR Specification)",12,"CY",null,{"v":0,"d":"$0.00"}]
["02801-C11-00060","Sod, Tall Fescue/Bluegrass Mixture",355,"SY",null,{"v":0,"d":"$0.00"}]
["02800-C11-00603","Trees, Deciduous - 2.0 to 2.5\" caliper",6,"EA",null,{"v":0,"d":"$0.00"}]
["02800-C11-01020","Herbaceous Plant (#1 Container)",{"$f":"90+85","v":175},"EA",null,{"v":0,"d":"$0.00"}]
["2800-C11-SP005","Virginia Sweetspire 18\" -24\" size",17,"EA",null,{"$f":"IFERROR($C73*$E73, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$68:$F$73)","v":{"v":0,"d":"$0.00"}}]
[]
["C12","BUS STOP SHELTER AND FURNISHINGS"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["10530-C12-00080","Install Traditional 6' Bus Shelter Bench",2,"EA",null,{"$f":"IFERROR($C78*$E78, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$78:$F$78)","v":{"v":0,"d":"$0.00"}}]
[]
["C13","EROSION AND SEDIMENT CONTROL WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[null,"Erosion and Sediment Control work",1,"LS",null,{"$f":"IFERROR($C83*$E83, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$83)","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-00010","Maintenance of Traffic (MOT)","NA","%",null,{"$f":"Unit_Price_Tab!$E90*$F$86","v":{"v":0,"d":"$0.00"}}]
["01000-C16-00030","Mobilization and De-Mobilization","NA","%",null,{"$f":"Unit_Price_Tab!$E91*$F$86","v":{"v":0,"d":"$0.00"}}]
["01500-SA-00200","SWPPP Administration","NA","%",null,{"$f":"Unit_Price_Tab!$E92*$F$86","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"PERCENTAGE LINE ITEMS SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$90:$F$92)","v":{"v":0,"d":"$0.00"}}]
[]
[]
[]
[{"$nulls":4},"PRIMARY CONTRACT :",{"$f":"$F$93+F86","v":{"v":0,"d":"$0.00"}}]