{"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":164,"n_cols":7,"rows_kept":164,"merged":[[1,0,1,5]]}
["ITB No. 21-DES-ITB-470"]
["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 _____________, 20___.  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)."]
[]
[]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT PRICE","TOTAL"]
["C1","GENERAL EARTH WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT PRICE","TOTAL"]
["02200-C1-00060","Flowable BackFill (VDOT Special Provision S302G02-0610)",25,"CY",null,{"$f":"IFERROR($C8*$E8, \"\")","v":{"v":0,"d":"$0.00"}}]
["02200-C1-00140","Aggregate, VDOT #21-B  (Compacted in Place per VDOT standards & Specs)",775,"CY",null,{"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-00020","Concrete Curb, Standard Header Curb C-3 (Arlington County Detail R-2.0), includes curb for aprons, ramps, etc.",44,"LF",null,{"$f":"IFERROR($C14*$E14, \"\")","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.",1919,"LF",null,{"v":0,"d":"$0.00"}]
["02611-C2-00110","Concrete Sidewalk, 4\" Thickness (Arlington County Detail R-2.0)",1330,"SY",null,{"v":0,"d":"$0.00"}]
["02611-C2-00190","CG-12 Detectable Warning Surface - Truncated Domes",27,"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)",60,"SY",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$14:$F$18)","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)",600,"SY",null,{"$f":"IFERROR($C23*$E23, \"\")","v":{"v":0,"d":"$0.00"}}]
["02600-C3-00030","Asphalt Concrete, Base Course (VDOT BM-25.0A)",1516,"TON",null,{"v":0,"d":"$0.00"}]
["02600-C3-00060","Asphalt Concrete, Surface Course (VDOT SM-9.5A)",578,"TON",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$23:$F$25)","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",392,"LF",null,{"$f":"IFERROR($C30*$E30, \"\")","v":{"v":0,"d":"$0.00"}}]
["02505-C4-00630","15\" Pipe, RCP Class III, In Place 6' to 8' Deep",91,"LF",null,{"v":0,"d":"$0.00"}]
["02500-C4-00640","18\" Pipe, RCP Class III, In Place Up to 6' Deep",57,"LF",null,{"v":0,"d":"$0.00"}]
["02500-C4-00830","15\" Pipe, RCP Class IV, In Place 6' to 10' Deep",148,"LF",null,{"v":0,"d":"$0.00"}]
["02500-C4-00020","Storm Manhole PH-1 (Arlington County Detail D-3.1), In Place, DEPTH   8'",4,"EA",null,{"v":0,"d":"$0.00"}]
["02505-C4-00080","CB-2 (Arlington County Standards), In Place Up to 6' Deep",4,"EA",null,{"v":0,"d":"$0.00"}]
["02505-C4-00140","CB-4, In Place Up to 6' Deep, Arlington County Standards",1,"EA",null,{"v":0,"d":"$0.00"}]
["02505-C4-00120","PCB-2, In Place Up to 6' Deep, Arlington County Standards",6,"EA",null,{"v":0,"d":"$0.00"}]
["02505-C4-00160","Curb Drop Inlet, Standard VDOT DI-1 (12\" to 24\" Pipe), In Place Up to 10' Deep",2,"EA",null,{"v":0,"d":"$0.00"}]
["02505-C4-00170","Curb Drop Inlet, Standard VDOT DI-2A (12\" to 24\" Pipe), In Place Up to 9' Deep",1,"EA",null,{"v":0,"d":"$0.00"}]
["02505-C4-00180","Curb Drop Inlet, Standard VDOT DI-2B (12\" to 24\" Pipe), In Place Up to 9' Deep, Inlet Throat Length 4' to 20'",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",2,"EA",null,{"v":0,"d":"$0.00"}]
["02505-C4-00600","Storm Manhole, Catch Basin, Drop Inlet, Yard Inlet, or Grate Inlet, Remove",6,"EA",null,{"v":0,"d":"$0.00"}]
["02505-C4-00090","CB-2 (Arlington County Standards), Each VF Over 6' Deep",1,"VF",null,{"v":0,"d":"$0.00"}]
["02505-C4-00130","PCB-2, Each VF Over 6' Deep, Arlington County Standards",5,"VF",null,{"v":0,"d":"$0.00"}]
["02505-C4-00530","Convert Catch Basin to Grate Inlet",1,"EA",null,{"$f":"IFERROR($C46*$E46, \"\")","v":{"v":0,"d":"$0.00"}},1]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$30:$F$46)","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":"IFERROR($C51*$E51, \"\")","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",2,"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",4,"EA",null,{"v":0,"d":"$0.00"}]
["02550-C6-00250","Remove Existing Fire Hydrant",2,"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)",2,"EA",null,{"v":0,"d":"$0.00"}]
["02550-C6-00300","Cut & Cap 12-Inch Water Main",2,"EA",null,{"v":0,"d":"$0.00"}]
["02550-C6-00350","Remove Existing Valve Boxes",5,"EA",null,{"v":0,"d":"$0.00"}]
["02550-C6-00030","12-Inch Water Main, DIP CL-52, Upto 6' Deep",504,"LF",null,{"v":0,"d":"$0.00"}]
["02550-C6-00040","12-Inch Water Main, DIP CL-52, > 6' Deep",143,"LF",null,{"v":0,"d":"$0.00"}]
["02550-C6-00050","8-Inch Water Main, DIP CL-52, Upto 6' Deep",23,"LF",null,{"v":0,"d":"$0.00"}]
["02550-C6-00060","8-Inch Water Main, DIP CL-52, > 6' Deep",75,"LF",null,{"v":0,"d":"$0.00"}]
["02550-C6-00070","6-Inch Water Main, DIP CL-53, Upto 6' Deep",52,"LF",null,{"v":0,"d":"$0.00"}]
["02550-C6-00540","Abandon Existing Water Main (All sizes and depths)",912,"LF",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$51:$F$65)","v":{"v":0,"d":"$0.00"}}]
[]
["C7","SANITARY SEWER WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["02510-C7-00140","Sanitary Sewer - 12\" PVC, SDR 35, 8’ ≤ DEPTH < 14'",115,"LF",null,{"$f":"IFERROR($C70*$E70, \"\")","v":{"v":0,"d":"$0.00"}}]
["02510-C7-00210","Manhole-Precast Concrete 4' I.D. DEPTH > 8', PER ADDITIONAL VF OVER 8'",9,"VF",null,{"v":0,"d":"$0.00"}]
["02510-C7-00240","Manhole-Construct Over Existing Sewer, Arlington County DRAWING S-2.2 (PAYMENT SHALL BE FOR DOGHOUSE BASE AND REMAINDER OF MANHOLE SHALL BE PAID UNDER VF PRICES FOR MANHOLES PER ITEM ABOVE)",3,"EA",null,{"v":0,"d":"$0.00"}]
["02510-C7-00250","Abandon Existing Sanitary Manhole",2,"EA",null,{"v":0,"d":"$0.00"}]
["02510-C7-00260","Connect To Existing Sanitary Manhole",2,"EA",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$70:$F$74)","v":{"v":0,"d":"$0.00"}}]
[]
["C8","TRAFFIC SIGNAL WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["13160-C8-03000","Traffic Signal Cost",1,"LS",null,{"$f":"IFERROR($C79*$E79, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$79:$F$79)","v":{"v":0,"d":"$0.00"}}]
[]
["C9","STREET LIGHTING WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["14030-C9-00040","Furnish and Install 2 Inch Sch 40 PVC Conduit in Trench (Detail 14030-01)",945,"LF",null,{"$f":"IFERROR($C84*$E84, \"\")","v":{"v":0,"d":"$0.00"}}]
["14030-C9-00100","Trenching - Asphalt",657,"LF",null,{"v":0,"d":"$0.00"}]
["14030-C9-00130","Trenching- Earth",{"$f":"288+445","v":733},"LF",null,{"v":0,"d":"$0.00"}]
["14040-C9-00220","Enter Existing Junction Box",3,"EA",null,{"v":0,"d":"$0.00"}]
["14050-C9-00260","Furnish & Install # 6 TNNH Copper Cable",2,"LF",null,{"v":0,"d":"$0.00"}]
["14050-C9-00270","Furnish & Install # 12 UF Cable with ground wire",{"$f":"1185+445","v":1630},"LF",null,{"v":0,"d":"$0.00"}]
["14060-C9-00290","Install Streetlight Pole Foundation (Detail 14060-01)",15,"EA",null,{"v":0,"d":"$0.00"}]
["14060-C9-00350","Removal of Existing Foundation - up to 4' Deep",1,"EA",null,{"v":0,"d":"$0.00"}]
["14160-C9-00910","Decorative Post-Top Aluminum Streetlight Pole with Single Post-Top Luminaire per Arlington Lighting Standard 14160-01",9,"EA",null,{"v":0,"d":"$0.00"}]
["14160-C9-00920","Decorative Post-Top Aluminum Streetlight Pole with Double Post Top Luminaires per Arlington Lighting Standard 14160-02",6,"EA",null,{"v":0,"d":"$0.00"}]
["14160-C9-00930","Round Tapered Composite Roadway Light Pole on Foundation with Single Cobra Head Luminaire per Arlington Lighting Standard 14160-03",2,"EA",null,{"v":0,"d":"$0.00"}]
[null,"Furnish & Install Meter Pedestal",1,"EA",null,{"v":0,"d":"$0.00"},"Why bidding as individual items instead of \"roll-up\" items discussed with Streetlight team? \"Meter price is not included in other items. Separate bidding is requested by TE&O for these items and matches their cost estimate they sent to us.\""]
[null,"Temporary Cobrahead Luminaire",2,"EA",null,{"v":0,"d":"$0.00"}]
[null,"Temporary Luminaire Arm 8'",1,"EA",null,{"v":0,"d":"$0.00"}]
[null,"Temporary Cobrahead Streetlight on Wooden Pole",2,"EA",null,{"v":0,"d":"$0.00"}]
[null,"Temporary Cobrahead Luminaire Relocation",2,"EA",null,{"v":0,"d":"$0.00"}]
[null,"Temporary Luminaire Arm 8' Relocation",2,"EA",null,{"v":0,"d":"$0.00"}]
[null,"Temporary 2 Inch Sch 40 PVC Conduit & Fittings in Trench",445,"LF",null,{"$f":"IFERROR($C101*$E101, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$84:$F$101)","v":{"v":0,"d":"$0.00"}}]
[]
["C10","PAVEMENT MARKING AND SIGNAGE WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["02900-C10-00020","Six (6) Inch Transverse Markings",304,"LF",null,{"$f":"IFERROR($C106*$E106, \"\")","v":{"v":0,"d":"$0.00"}}]
["02900-C10-00030","Twelve (12) Inch Transverse Markings",28,"LF",null,{"v":0,"d":"$0.00"}]
["02900-C10-00040","Eighteen (18) Inch Transverse Markings",103,"LF",null,{"v":0,"d":"$0.00"}]
["02900-C10-00050","Twenty Four (24) Inch Transverse Markings, Note: Used For Continental (Ladder) Crosswalk",710,"LF",null,{"v":0,"d":"$0.00"}]
["02900-C10-00070","Four (4) Inch Longitudinal Solid Line",387,"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",1045,"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",866,"LF",null,{"v":0,"d":"$0.00"}]
["02900-C10-00380","Removal of Existing Transverse Lines (Up To and Including Six (6) Inch Width), Note: Base Unit For Removal",1250,"LF",null,{"v":0,"d":"$0.00"}]
["02900-C10-00410","Traffic Control Sign (Typical Stop, Yield, No Parking, Speed Limit, or Similar), Install per Detail SG-1.0",20,"EA",null,{"v":0,"d":"$0.00"}]
["02900-C10-00430","Traffic Control Sign (Typical Stop, Yield, No Parking, Speed Limit, or Similar), Relocate with New Post",1,"EA",null,{"v":0,"d":"$0.00"}]
["02900-C10-00450","Portable Changeable Message Sign",30,"DAY",null,{"v":0,"d":"$0.00"}]
["02900-C10-00225","Twelve (12) Inch Yellow Gore Markings, Twenty (20) Foot Spacing @ 45 Degree",35,"LF",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$106:$F$117)","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",300,"CY",null,{"$f":"IFERROR($C122*$E122, \"\")","v":{"v":0,"d":"$0.00"}}]
["02801-C11-00060","Sod, Tall Fescue/Bluegrass Mixture",901,"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)",5,"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)",2,"EA",null,{"v":0,"d":"$0.00"}]
["02800-C11-00603","Trees, Deciduous - 2.0 to 2.5\" caliper",12,"EA",null,{"v":0,"d":"$0.00"}]
["02800-C11-00100","Brick Pavers, Including Concrete Base (Arlington County Detail R-2.1)",32,"SY",null,{"v":0,"d":"$0.00"}]
["02800-C11-00210","Chain Link Fence, Height Greater Than 6' Up to 8'",224,"LF",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$122:$F$128)","v":{"v":0,"d":"$0.00"}}]
[]
["C13","EROSION AND SEDIMENT CONTROL WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["01500-C13-10000","Erosion and Sediment Control",1,"LS",null,{"$f":"IFERROR($C133*$E133, \"\")","v":{"v":0,"d":"$0.00"}},1]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$133)","v":{"v":0,"d":"$0.00"}}]
[]
["C18","NON COUNTY UTILITIES"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["02580-C18-DO130","2-4\" Duct Standard Duct Bank All Depths",294,"LF",null,{"$f":"IFERROR($C138*$E138, \"\")","v":{"v":0,"d":"$0.00"}}]
["02580-C18-DO220","2-8\" Duct Standard Duct Back All Depths",122,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-DO230","4-8\" Duct Standard Duct Back All Depths",86,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-DO240","6-8\" Duct Standard Duct Back All Depths",313,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-DO270","16'x8'x10' Electric Vault w/frame and cover. Dom. Energy to provide manhole frame and cover.",2,"EA",null,{"v":0,"d":"$0.00"}]
["02580-C18-VE130","2-4\" Duct Standard Duct Bank All Depths",147,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-VE170","Verizon Quazite Handholes",2,"EA",null,{"v":0,"d":"$0.00"}]
["02580-C18-CO130","2-4\" Duct Standard Duct Bank All Depths",438,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-CO170","Comcast Quazite Handhole",1,"EA",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$138:$F$146)","v":{"v":0,"d":"$0.00"}}]
[]
[null,"MOT"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["01000-C16-00010","Maintenance of Traffic (MOT)",1,"LS",null,{"$f":"IFERROR($C151*$E151, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$151)","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-00030","Mobilization and De-Mobilization","NA","%",{"v":0.05,"d":"5%"},{"$f":"Unit_Price_Tab!$E158*$F$154","v":{"v":0,"d":"$0.00"}}]
["01500-SA-00200","SWPPP Administration","NA","%",null,{"$f":"Unit_Price_Tab!$E159*$F$154","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"PERCENTAGE LINE ITEMS SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$158:$F$159)","v":{"v":0,"d":"$0.00"}}]
[]
[]
[]
[{"$nulls":4},"PROJECT TOTAL :",{"$f":"$F$160+F154","v":{"v":0,"d":"$0.00"}}]