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

{"sheet":"Unit_Price_Tab","index":0,"n_rows":78,"n_cols":7,"rows_kept":78,"merged":[[1,0,1,5]]}
[{"$nulls":3},"DATE: "]
["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},"PREPARED BY:"]
[{"$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)",92,"CY",null,{"$f":"E9*C9","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUM(F9:F9)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(F9:F9)","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",24,"LF",null,{"$f":"E14*C14","v":{"v":0,"d":"$0.00"}}]
["02611-C2-00110","Concrete Sidewalk, 4\" Thickness (Arlington County Detail R‐2.0)",16,"SY",null,{"$f":"E15*C15","v":{"v":0,"d":"$0.00"}}]
["03100-C2-00220","Concrete Pier, Cradle, or Encasement (Arlington County Detail M-7.0)",10,"CY",null,{"$f":"E16*C16","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUM(F14:F16)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(F14:F16)","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)",605,"SY",null,{"$f":"E21*C21","v":{"v":0,"d":"$0.00"}}]
["02600-C3-00030","Asphalt Concrete, Base Course (VDOT BM-25.0A)",25,"TON",null,{"$f":"E22*C22","v":{"v":0,"d":"$0.00"}}]
["02600-C3-00070","Asphalt Concrete, Surface Course (VDOT SM-9.5D)",78,"TON",null,{"$f":"E23*C23","v":{"v":0,"d":"$0.00"}}]
["03100-C3-00150","Remove and Replace 8\" to 10\" Reinforced Concrete Paving VDOT Standards PR-3, PR-4, PR-5 and PR-6)",123,"SY",null,{"$f":"E24*C24","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUM(F21:F24)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(F21:F24)","v":{"v":0,"d":"$0.00"}}]
[]
["C6","WATERMAIN WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["02550-C6-00140","12-Inch Gate Valve & Valve Box",7,"EA",null,{"$f":"E29*C29","v":{"v":0,"d":"$0.00"}}]
["02550-C6-00150","8-Inch Gate Valve & Valve Box",1,"EA",null,{"v":0,"d":"$0.00"}]
["02550-C6-00160","6-Inch Gate Valve & Valve Box",1,"EA",null,{"v":0,"d":"$0.00"}]
["02550-C6-00190","Connect To Existing 12-Inch Water Main",3,"EA",null,{"v":0,"d":"$0.00"}]
["02550-C6-00210","Connect To Existing 6-Inch Water Main",2,"EA",null,{"v":0,"d":"$0.00"}]
["02550-C6-00250","Remove Existing Fire Hydrant",1,"EA",null,{"v":0,"d":"$0.00"}]
["02550-C6-00270","Install New Fire Hydrant ",1,"EA",null,{"v":0,"d":"$0.00"}]
["02550-C6-00330","Cut & Cap 6-Inch Water Main",2,"EA",null,{"v":0,"d":"$0.00"}]
["02550-C6-00350","Remove Existing Valve Boxes",4,"EA",null,{"v":0,"d":"$0.00"}]
["02550-C6-00030","12-Inch Water Main, DIP CL-52, Upto 6' Deep",654,"LF",null,{"v":0,"d":"$0.00"}]
["02550-C6-00050","8-Inch Water Main, DIP CL-52, Upto 6' Deep",34,"LF",null,{"v":0,"d":"$0.00"}]
["02550-C6-00070","6-Inch Water Main, DIP CL-53, Upto 6' Deep",20,"LF",null,{"v":0,"d":"$0.00"}]
["02550-C6-00710","Service Re-Taps  - 1 1/2-inch and 2-inch (TAP MAIN, INSTALL COPPER TUBING, CONNECT TO EXISTING SERVICE LINE, ABANDON CORPORATION COCK FROM EXISTING SERVICE LINE, BACKFILL, EXCAVATION & PAVEMENT RESTORATIONS)--UP TO 10 FT.",2,"EA",null,{"v":0,"d":"$0.00"}]
["02550-C6-00720","Service Re-Taps  - 1 1/2-inch and 2-inchPER ADDITIONAL LINEAR FOOT OVER 10 FT.",20,"LF",null,{"v":0,"d":"$0.00"}]
["02550-C6-SP001","Install 12\" DIP CL-52 watermain through the abutmentand under the deckof N. Rhodes Street Bridge over Route 50 as detailed on Sheet C052.1 through C052.3 of the watermain improvement plan",1,"LS",null,{"v":0,"d":"$0.00"}]
["02550-C6-SP002","Temporary Barrier",265,"LF",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUM(F29:F44)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(F29:F44)","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",79,"LF",null,{"$f":"E49*C49","v":{"v":0,"d":"$0.00"}}]
["02900-C10-00050","Twenty Four (24) Inch Transverse Markings, Note: Used For Continental (Ladder) Crosswalk",808,"LF",null,{"v":0,"d":"$0.00"}]
["02900-C10-00120","Six (6) Inch Longitudinal Solid Line",170,"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",100,"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",430,"LF",null,{"v":0,"d":"$0.00"}]
["02900-C10-00290","Standard Bicycle Symbols (MUTCD, Chapter 9C, Figure 9C-3), \"Bike Symbol\", \"Helmeted Bicyclist Symbol\"",2,"EA",null,{"v":0,"d":"$0.00"}]
["02900-C10-SP001","Type B, Class VI, Four (4) Inch Contrast",440,"LF",null,{"v":0,"d":"$0.00"}]
["02900-C10-SP002","Type B, Class VI, Six (6) Inch Contrast",418,"LF",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUM(F49:F56)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(F49:F56)","v":{"v":0,"d":"$0.00"}}]
[]
["C13","EROSION AND SEDIMENT CONTROL WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["01500-C13-10000","Temporary Erosion and Sediment Controls",1,"LS",null,{"$f":"E61*C61","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUM(F61)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(F61)","v":{"v":0,"d":"$0.00"}}]
[]
[{"$nulls":4}," CONTRACT TOTAL (EXCLUDING PERCENTAGE ITEMS)",{"$f":"F62+F57+F45+F25+F17+F10","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(G10:G62)","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":"F64*E68","v":{"v":0,"d":"$0.00"}},{"$f":"0.075*G64","v":{"v":0,"d":"$0.00"}}]
["01000-C16-00030","Mobilization and De-Mobilization","NA","%",null,{"$f":"F64*E69","v":{"v":0,"d":"$0.00"}},{"$f":"0.08*G64","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"PERCENTAGE LINE ITEMS SUBTOTAL",{"$f":"SUM(F68:F69)","v":{"v":0,"d":"$0.00"}},{"$f":"G68+G69","v":{"v":0,"d":"$0.00"}}]
[]
[{"$nulls":4},"TOTAL:",{"$f":"F70+F64","v":{"v":0,"d":"$0.00"}},{"$f":"G64+G70","v":{"v":0,"d":"$0.00"}}]
[]
[{"$nulls":4},"CONTRACT  TOTAL:",{"$f":"F72","v":{"v":0,"d":"$0.00"}},{"$f":"G72","v":{"v":0,"d":"$0.00"}}]
[]
[]
[]
["*Based on 2020 Specs"]