{"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":91,"n_cols":8,"rows_kept":91,"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","Column1"]
["01400-C1-00030","Test Pits (or Test Bores), Up to 6' Deep (with restoration)",5,"EA",null,{"$f":"IFERROR($C8*$E8, \"\")","v":{"v":0,"d":"$0.00"}}]
["01400-C1-00040","Test Pits (or Test Bores), Each VF Over 6' Deep (with restoration)",10,"VF",null,{"v":0,"d":"$0.00"}]
["02200-C1-00130","Aggregate, VDOT #21-A  (Compacted in Place per VDOT standards & Specs)",380,"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"}},{"$f":"SUM(F8:F10)","v":{"v":0,"d":"$0.00"}}]
[]
["C2","CONCRETE WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT PRICE","TOTAL","Column1"]
["02750-C2-00040","Concrete Curb, Standard 6\" (VDOT CG-2), includes curb for aprons, ramps, etc.",144,"LF",null,{"$f":"IFERROR($C15*$E15, \"\")","v":{"v":0,"d":"$0.00"}}]
["02750-C2-00070","Concrete Curb & Gutter, Combination 6\" (VDOT CG-6), includes curb & gutter for aprons, ramps, etc.",276,"LF",null,{"v":0,"d":"$0.00"}]
["02611-C2-00110","Concrete Sidewalk, 4\" Thickness (Arlington County Detail R-2.0)",101,"SY",null,{"v":0,"d":"$0.00"}]
["02612-C2-00130","Concrete Pavers (Arlington County Detail R-2.1)",51,"SY",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$15:$F$18)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(F15:F18)","v":{"v":0,"d":"$0.00"}}]
[]
["C3","ASPHALT WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL","Column1"]
["02600-C3-00010","Asphalt Concrete, Planing or Milling (1/2\" to 3\" Depth)",4885,"SY",null,{"$f":"IFERROR($C23*$E23, \"\")","v":{"v":0,"d":"$0.00"}}]
["02600-C3-00030","Asphalt Concrete, Base Course (VDOT BM-25.0A)",194,"TON",null,{"v":0,"d":"$0.00"}]
["02600-C3-00060","Asphalt Concrete, Surface Course (VDOT SM-9.5A)",597,"TON",null,{"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)",1385,"SY",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$23:$F$26)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(F23:F26)","v":{"v":0,"d":"$0.00"}}]
[]
[]
[]
["C6","WATERMAIN WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL","Column1"]
["02550-C6-00140","12-Inch Gate Valve & Valve Box",11,"EA",null,{"$f":"IFERROR($C33*$E33, \"\")","v":{"v":0,"d":"$0.00"}}]
["02550-C6-00150","8-Inch Gate Valve & Valve Box",2,"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-00200","Connect To Existing 8-Inch Water Main",3,"EA",null,{"v":0,"d":"$0.00"}]
["02550-C6-00210","Connect To Existing 6-Inch Water Main",4,"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 (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-00300","Cut & Cap 12-Inch Water Main",4,"EA",null,{"v":0,"d":"$0.00"}]
["02550-C6-00320","Cut & Cap 8-Inch Water Main",3,"EA",null,{"v":0,"d":"$0.00"}]
["02550-C6-00330","Cut & Cap 6-Inch Water Main",3,"EA",null,{"v":0,"d":"$0.00"}]
["02550-C6-00630","Service Taps - 3/4-inch and 1-inch (TAP MAIN, INSTALL COPPER TUBING, INSTALL ANGLE VALVES, CORPORATION COCK, METER BOX AND METER YOKE/METER, CONNECT TO EXISTING PRIVATE SERVICE LINE, BACKFILL, EXCAVATION AND PAVEMENT RESTORATIONS)--UP TO 1O FT.",10,"EA",null,{"v":0,"d":"$0.00"}]
["02550-C6-00640","Service Taps - 3/4-inch and 1-inch PER ADDITIONAL LINEAR FOOT OVER 10 FT.",256,"LF",null,{"v":0,"d":"$0.00"}]
["02550-C6-00650","Service Re-Taps  - 3/4-inch and 1-inch (TAP MAIN, INSTALL COPPER TUBING, CONNECT TO EXISTING SERVICE LINE, ABANDON CORPORATION COCK FROM EXISTING SERVICE LINE, BACKFILL, EXCAVATION AND PAVEMENT RESTORATIONS)-UP TO 10 FT.",9,"EA",null,{"v":0,"d":"$0.00"}]
["02550-C6-00660","Service Re-Taps  - 3/4-inch and 1-inch PER ADDITIONAL LINEAR FT. OVER 10 FT.",298,"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 AND PAVEMENT RESTORATIONS)--UP TO 10 FT.",7,"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.",208,"LF",null,{"v":0,"d":"$0.00"}]
["02550-C6-00350","Remove Existing Valve Boxes",8,"EA",null,{"v":0,"d":"$0.00"}]
["02550-C6-00030","12-Inch Water Main, DIP CL-52, Upto 6' Deep",1365,"LF",null,{"v":0,"d":"$0.00"}]
["02550-C6-00040","12-Inch Water Main, DIP CL-52, > 6' Deep",676,"LF",null,{"v":0,"d":"$0.00"}]
["02550-C6-00050","8-Inch Water Main, DIP CL-52, Upto 6' Deep",87,"LF",null,{"v":0,"d":"$0.00"}]
["02550-C6-00070","6-Inch Water Main, DIP CL-53, Upto 6' Deep",90,"LF",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$33:$F$54)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(F33:F54)","v":{"v":0,"d":"$0.00"}}]
[]
["C10","PAVEMENT MARKING AND SIGNAGE WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL","Column1"]
["02900-C10-00020","Six (6) Inch Transverse Markings",400,"LF",null,{"$f":"IFERROR($C59*$E59, \"\")","v":{"v":0,"d":"$0.00"}}]
["02900-C10-00040","Eighteen (18) Inch Transverse Markings",36,"LF",null,{"v":0,"d":"$0.00"}]
["02900-C10-00050","Twenty Four (24) Inch Transverse Markings, Note: Used For Continental (Ladder) Crosswalk",1001,"LF",null,{"v":0,"d":"$0.00"}]
["02900-C10-SP001","Twenty Four (24) Inch Transverse Markings, Note: Used For Stop Bars",175,"LF",null,{"v":0,"d":"$0.00"}]
["02900-C10-00070","Four (4) Inch Longitudinal Solid Line",1785,"LF",null,{"v":0,"d":"$0.00"}]
["02900-C10-00080","Four (4) Inch Longitudinal Skip Line (Ten (10) Foot Line/Thirty (30) Foot Spacing), Note: Forty (40) LF Consists of Ten (10) LF of Marking and Thirty (30) LF of Space",2831,"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",396,"LF",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$59:$F$65)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(F59:F65)","v":{"v":0,"d":"$0.00"}}]
[]
["C11","LANDSCAPE AND HARDSCAPE RESTORATION WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL","Column1"]
["02200-C11-00010","Imported Topsoil",35,"CY",null,{"$f":"IFERROR($C70*$E70, \"\")","v":{"v":0,"d":"$0.00"}}]
["02801-C11-00060","Sod, Tall Fescue/Bluegrass Mixture",201,"SY",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$70:$F$71)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(F70:F71)","v":{"v":0,"d":"$0.00"}}]
[]
[]
[]
[]
[{"$nulls":4}," CONTRACT TOTAL (EXCLUDING PERCENTAGE ITEMS)",{"$f":"SUM(F11,F19,F27,F55,F66,F72)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(G8:G74)","v":{"v":0,"d":"$0.00"}}]
[]
["PCT","PERCENTAGE LINE ITEMS"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL","Column1"]
["01500-C13-10000","Temporary Erosion and Sediment Controls","NA","%",null,{"$f":"Unit_Price_Tab!$E81*$F$77","v":{"v":0,"d":"$0.00"}},{"$f":"Unit_Price_Tab!$F81","v":{"v":0,"d":"$0.00"}},{"$f":"G77*Unit_Price_Tab!$E81","v":{"v":0,"d":"$0.00"}}]
["01000-C16-00010","Maintenance of Traffic (MOT)","NA","%",null,{"$f":"Unit_Price_Tab!$E82*$F$77","v":{"v":0,"d":"$0.00"}},{"$f":"Unit_Price_Tab!$F82","v":{"v":0,"d":"$0.00"}},{"$f":"G77*Unit_Price_Tab!$E82","v":{"v":0,"d":"$0.00"}}]
["01000-C16-00020","Re-Mobilization (For On-Call Contracts Only)","NA","%",{"v":0,"d":"0.00%"},{"$f":"Unit_Price_Tab!$E83*$F$77","v":{"v":0,"d":"$0.00"}},{"$f":"Unit_Price_Tab!$F83","v":{"v":0,"d":"$0.00"}},0]
["01000-C16-00030","Mobilization and De-Mobilization","NA","%",null,{"$f":"Unit_Price_Tab!$E84*$F$77","v":{"v":0,"d":"$0.00"}},{"$f":"Unit_Price_Tab!$F84","v":{"v":0,"d":"$0.00"}},{"$f":"G77*Unit_Price_Tab!$E84","v":{"v":0,"d":"$0.00"}}]
["01500-SA-00200","SWPPP Administration","NA","%",null,{"$f":"Unit_Price_Tab!$E85*$F$77","v":{"v":0,"d":"$0.00"}},{"$f":"Unit_Price_Tab!$F85","v":{"v":0,"d":"$0.00"}},{"$f":"G77*Unit_Price_Tab!$E85","v":{"v":0,"d":"$0.00"}}]
["01000-VF-00200","VDOT Inspection Fee (Only for LAP Projects. Do not Inlude in the Bid Tab)","NA","%",null,{"$f":"Unit_Price_Tab!$E86*$F$77","v":{"v":0,"d":"$0.00"}},{"$f":"Unit_Price_Tab!$F86","v":{"v":0,"d":"$0.00"}},{"$f":"G77*Unit_Price_Tab!$E86","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"PERCENTAGE LINE ITEMS SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$81:$F$86)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(G81:G86)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(H81:H86)","v":{"v":0,"d":"$0.00"}}]
[]
[]
[]
[{"$nulls":4},"PRIMARY CONTRACT :",{"$f":"$F$87+F77","v":{"v":0,"d":"$0.00"}},{"$f":"Unit_Price_Tab!$G$87+G77","v":{"v":0,"d":"$0.00"}}]