{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Grand Total Summary Sheet","Segment C","Segment D"],"not_rendered":{"comments":4},"read":"whole","date_system":"1900"}

{"sheet":"Grand Total Summary Sheet","index":0,"n_rows":8,"n_cols":2,"rows_kept":8,"merged":[[2,0,2,1],[3,0,3,1]]}
[]
[]
["Columbia Pike Multimodal Street Improvements Project     Segment C & D"]
["Contract Amount Summary"]
["Description","Contract Amount"]
["Segment C",{"$f":"+'Segment C'!F219","v":{"v":0,"d":"$0.00"}}]
["Segment D",{"$f":"+'Segment D'!F208","v":{"v":0,"d":"$0.00"}}]
["Grand Total Bid ",{"$f":"+B6+B7","v":{"v":0,"d":"$0.00"}}]

{"sheet":"Segment C","index":1,"n_rows":219,"n_cols":6,"rows_kept":219,"merged":[[0,0,0,5]]}
["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)."]
[]
["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)",3515,"CY",null,{"$f":"IFERROR($C6*$E6, \"\")","v":{"v":0,"d":"$0.00"}}]
["02200-C1-00140","Aggregate, VDOT #21-B  (Compacted in Place per VDOT standards & Specs)",3685,"CY",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUM(F6:F7)","v":{"v":0,"d":"$0.00"}}]
[]
["C2","GENERAL EARTH 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.",763,"LF",null,{"$f":"IFERROR($C12*$E12, \"\")","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.",4414,"LF",null,{"v":0,"d":"$0.00"}]
["02611-C2-00110","Concrete Sidewalk, 4\" Thickness (Arlington County Detail R-2.0)",983,"SY",null,{"v":0,"d":"$0.00"}]
["02611-C2-00190","CG-12 Detectable Warning Surface - Truncated Domes",83,"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)",475,"SY",null,{"v":0,"d":"$0.00"}]
["03100-C2-00200","Concrete Steps Each (Arlington County Detail R-3.0, including all reinforcing bars as shown in detail)",170,"LF-W",null,{"v":0,"d":"$0.00"}]
["03100-C2-SP130","Concrete Bus Pad as per detail Inset C shown on Sheet C3.1.1. \nConcrete Surface A-3 Concrete with Welded Wire 6\"x6\" W2.9xW2.9.",70,"CY",null,{"$f":"IFERROR($C18*$E18, \"\")","v":{"v":0,"d":"$0.00"}}]
["02750-C2-00075","Concrete Curb & Gutter, Standard C-4 (Arlington County Detail R-2.0)",215,"LF",null,{"$f":"IFERROR($C19*$E19, \"\")","v":{"v":0,"d":"$0.00"}}]
["02750-C2-SP120","Concrete Sidewalk as per details shown on sheet C14.4, C14.5 & C14.6. including but not limited to brick bands, steel edgings, WWM, rebars, dowels, vapor barriers all complete",2751,"SY",null,{"$f":"IFERROR($C20*$E20, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUM(F12:F20)","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)",1532,"SY",null,{"$f":"IFERROR($C25*$E25, \"\")","v":{"v":0,"d":"$0.00"}}]
["02600-C3-00030","Asphalt Concrete, Base Course (VDOT BM-25.0A)",155,"TON",null,{"v":0,"d":"$0.00"}]
["02600-C3-00160","Asphalt Concrete, Base Course (VDOT BM-25.OD)",3795,"TON",null,{"v":0,"d":"$0.00"}]
["02600-C3-00050","Asphalt Concrete, Intermediate Course (VDOT IM-19.0D)",2533,"TON",null,{"v":0,"d":"$0.00"}]
["02600-C3-00060","Asphalt Concrete, Surface Course (VDOT SM-9.5A)",40,"TON",null,{"v":0,"d":"$0.00"}]
["02600-C3-00070","Asphalt Concrete, Surface Course (VDOT SM-9.5D)",1452,"TON",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUM(F25:F30)","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",50,"LF",null,{"$f":"IFERROR($C35*$E35, \"\")","v":{"v":0,"d":"$0.00"}}]
["02505-C4-00630","15\" Pipe, RCP Class III, In Place 6' to 8' Deep",725,"LF",null,{"v":0,"d":"$0.00"}]
["02500-C4-00650","18\" Pipe, RCP Class III, In Place 6' to 9' Deep",190,"LF",null,{"v":0,"d":"$0.00"}]
["02505-C4-01420","Underdrain, Standard VDOT UD-1",2450,"LF",null,{"v":0,"d":"$0.00"}]
["02505-C4-00010","Storm Manhole MH-1 (Arlington County Detail D-3.0), 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",3,"EA",null,{"v":0,"d":"$0.00"}]
["02505-C4-00100","CB-2A or CB-2B (throat lengths from 8'-6\" up to 16'-0\"),  In Place Up to 6' Deep, Arlington County Standards.",11,"EA",null,{"v":0,"d":"$0.00"}]
["02505-C4-00470","Catch Basin Structure Top, Remove & Replace",8,"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",2,"EA",null,{"v":0,"d":"$0.00"}]
["02500-C4-00061","Storm Manhole (VDOT MH-1, MH1-A), In Place, PER ADDITIONAL VF OVER 8'",10,"VF",null,{"v":0,"d":"$0.00"}]
["02505-C4-00110","CB-2A or CB-2B (throat lengths from 8'-6\" up to 16'-0\"), Each VF Over 6' Deep, Arlington County Standards.",19,"VF",null,{"v":0,"d":"$0.00"}]
["02500-C4-SP100","Install Underground 8\" Corrugated Flexible Drainage Pipe all complete",41,"LF",null,{"$f":"IFERROR($C47*$E47, \"\")","v":{"v":0,"d":"$0.00"}}]
["02500-C4-SP200","Cast in place custom inlet as per detail shown on sheet C2.5",2,"EA",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUM(F35:F48)","v":{"v":0,"d":"$0.00"}}]
[]
["C5","GUARDRAIL"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[{"$nulls":4},"SUBTOTAL"]
[]
["C6","WATERMAIN WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["02550-C6-00140","12-Inch Gate Valve & Valve Box",17,"EA",null,{"$f":"IFERROR($C57*$E57, \"\")","v":{"v":0,"d":"$0.00"}}]
["02550-C6-00150","8-Inch Gate Valve & Valve Box",7,"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",6,"EA",null,{"v":0,"d":"$0.00"}]
["02550-C6-00210","Connect To Existing 6-Inch Water Main",3,"EA",null,{"v":0,"d":"$0.00"}]
["02550-C6-00250","Remove Existing Fire Hydrant",4,"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)",5,"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-00320","Cut & Cap 8-Inch Water Main",1,"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 AND EXCAVATION)--UP TO 1O FT.",7,"EA",null,{"v":0,"d":"$0.00"}]
["02550-C6-00690","Service Taps  - 1 1/2-inch and 2-inch (TAP MAIN, INSTALL COPPER TUBING, INSTALL GATE VALVES, CORPORATION COCK, METER BOX AND METER, CONNECT TO EXISTING PRIVATE SERVICE LINE, BACKFILL AND EXCAVATION)--UP TO 1O FT.",1,"EA",null,{"v":0,"d":"$0.00"}]
["02550-C6-00030","12-Inch Water Main, DIP CL-52, Upto 6' Deep",1325,"LF",null,{"v":0,"d":"$0.00"}]
["02550-C6-00040","12-Inch Water Main, DIP CL-52, > 6' Deep",380,"LF",null,{"v":0,"d":"$0.00"}]
["02550-C6-00050","8-Inch Water Main, DIP CL-52, Upto 6' Deep",270,"LF",null,{"v":0,"d":"$0.00"}]
["02550-C6-00060","8-Inch Water Main, DIP CL-52, > 6' Deep",195,"LF",null,{"v":0,"d":"$0.00"}]
["02550-C6-00070","6-Inch Water Main, DIP CL-53, Upto 6' Deep",80,"LF",null,{"v":0,"d":"$0.00"}]
["02550-C6-00640","Service Taps - 3/4-inch and 1-inch PER ADDITIONAL LINEAR FOOT OVER 10 FT.",130,"LF",null,{"v":0,"d":"$0.00"}]
["02550-C6-00700","Service Taps  - 1 1/2-inch and 2-inch PER ADDITIONAL LINEAR FOOT OVER 10 FT.",15,"LF",null,{"v":0,"d":"$0.00"}]
["02550-C6-SP741","Water Meter Vault Per Detail on Sheet C2.5",1,"EA",null,{"$f":"IFERROR($C76*$E76, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUM(F57:F76)","v":{"v":0,"d":"$0.00"}}]
[]
["C7","SANITARY SEWER WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["02510-C7-00010","Sanitary Sewer - 8\" PVC, SDR 35, DEPTH < 8’",25,"LF",null,{"$f":"IFERROR($C81*$E81, \"\")","v":{"v":0,"d":"$0.00"}}]
["02510-C7-00020","Sanitary Sewer - 8\" PVC, SDR 35, 8’ ≤ DEPTH < 14’",50,"LF",null,{"v":0,"d":"$0.00"}]
["02510-C7-00030","Sanitary Sewer - 8\" PVC, SDR 26, DEPTH ≥ 14'",30,"LF",null,{"v":0,"d":"$0.00"}]
["02510-C7-00140","Sanitary Sewer - 12\" PVC, SDR 35, 8’ ≤ DEPTH < 14'",570,"LF",null,{"v":0,"d":"$0.00"}]
["02510-C7-00150","Sanitary Sewer - 12\" PVC, SDR 26,  DEPTH ≥ 14'",775,"LF",null,{"v":0,"d":"$0.00"}]
["02510-C7-00200","Manhole - Precast Concrete, 4' ID, DEPTH  < 8'",4,"EA",null,{"v":0,"d":"$0.00"}]
["02510-C7-00210","Manhole-Precast Concrete 4' I.D. DEPTH > 8', PER ADDITIONAL VF OVER 8'",20,"VF",null,{"v":0,"d":"$0.00"}]
["02510-C7-00220","Manhole-Precast Concrete 5' I.D. DEPTH  < 8'",5,"EA",null,{"v":0,"d":"$0.00"}]
["02510-C7-00230","Manhole-Precast Concrete 5' I.D. DEPTH >8', PER ADDITIONAL VF OVER 8'",30,"VF",null,{"v":0,"d":"$0.00"}]
["02510-C7-00760","Sanitary Sewer Drop Connection, All sizes, (Arlington County Detail S-2.3)",5,"EA",null,{"v":0,"d":"$0.00"}]
["02510-C7-00270","Sanitary Sewer House Laterals(IN ACCORDANCE WITH Arlington County CONSTRUCTION STANDARDS AND SPECIFICATIONS SECTION 02510, PART 3, ITEM 3.5)",265,"LF",null,{"v":0,"d":"$0.00"}]
["02510-C7-SP255","Remove Existing Sanitary Manhole",5,"EA",null,{"v":0,"d":"$0.00"}]
["02510-C7-SP261","Connect to Existing MH #1938-B",1,"EA",null,{"v":0,"d":"$0.00"}]
["02510-C7-SP262","Connect to Existing Sanitary Sewer Main with Sleeve in Place",5,"EA",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUM(F81:F94)","v":{"v":0,"d":"$0.00"}}]
[]
["C8","TRAFFIC SIGNAL WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["13160-C8-SP300","Traffic Signal Work Complete per Plan C17.1 C17.2 and C17.3",1,"LS",null,{"$f":"IFERROR($C99*$E99, \"\")","v":{"v":0,"d":"$0.00"}}]
["13160-C8-SP400","Traffic Signal Work Complete per Plan C17.3 C17.5 and C17.6",1,"LS",null,{"v":0,"d":"$0.00"}]
["13160-C8-SP500","OPTIONAL ITEM: Traffic Signal Work Complete per Columbia Pike and S Rolfe Street Intersection Realignment 30% Design Plan – Attachment N",1,"LS",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUM(F99:F101)","v":{"v":0,"d":"$0.00"}}]
[]
["C9","STREET LIGHTING WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["14030-C9-00030","Furnish and Install 2 inch SCH 80 HDPE Direct Bore Conduit (Detail 14030-01)",650,"LF",null,{"$f":"IFERROR($C106*$E106, \"\")","v":{"v":0,"d":"$0.00"}}]
["14030-C9-00040","Furnish and Install 2 Inch Sch 40 PVC Conduit in Trench (Detail 14030-01)",2205,"LF",null,{"v":0,"d":"$0.00"}]
["14040-C9-00220","Enter Existing Junction Box",2,"EA",null,{"v":0,"d":"$0.00"}]
["14050-C9-00260","Furnish & Install full set of conductors as required by plan per linear foot of conduit ",2855,"LF",null,{"v":0,"d":"$0.00"}]
["14060-C9-00290","Install Streetlight Pole Foundation Type F-1 (Detail 14060-01)",6,"EA",null,{"v":0,"d":"$0.00"}]
["14060-C9-00310","Install Shallow Depth Foundation (Detail 14060-02)",18,"EA",null,{"v":0,"d":"$0.00"}]
["14060-C9-00350","Removal of Existing Foundation - up to 4' Deep",5,"EA",null,{"v":0,"d":"$0.00"}]
["14100-C9-00630","Furnish and Install Meter Pan, Pedestal, Control Box and Components (Detail 14100-01)",1,"EA",null,{"v":0,"d":"$0.00"}]
["14112-C9-00920","Decorative Post-Top Aluminum Streetlight Pole with Double Post Top Luminaires per Arlington Lighting Standard 14112-02",19,"EA",null,{"v":0,"d":"$0.00"}]
["14050-C9-SP0080","Relocate Existing Streetlight Pole, Luminaire Arm and Light Fixture",5,"EA",null,{"$f":"IFERROR($C115*$E115, \"\")","v":{"v":0,"d":"$0.00"}}]
["14050-C9-SP090","Remove Roadway Light or Streetlight Pole",5,"EA",null,{"$f":"IFERROR($C116*$E116, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUM(F106:F116)","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",90,"LF",null,{"$f":"IFERROR($C121*$E121, \"\")","v":{"v":0,"d":"$0.00"}}]
["02900-C10-00040","Eighteen (18) Inch Transverse Markings",210,"LF",null,{"v":0,"d":"$0.00"}]
["02900-C10-00050","Twenty Four (24) Inch Transverse Markings, Note: Used For Continental (Ladder) Crosswalk",840,"LF",null,{"v":0,"d":"$0.00"}]
["02900-C10-00070","Four (4) Inch Longitudinal Solid Line",1790,"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",3160,"LF",null,{"v":0,"d":"$0.00"}]
["02900-C10-SP100","Four (4) Inch Yellow Longitudinal Skip Line (Two (2) Foot Line/ Four (4) Foot Spacing), Note: Six (6) LF Consists of Two (2) LF of Marking and Four (4) LF of Space",68,"LF",null,{"v":0,"d":"$0.00"}]
["02900-C10-00120","Six (6) Inch Longitudinal Solid Line",1045,"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",45,"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",1245,"LF",null,{"v":0,"d":"$0.00"}]
["02900-C10-00240","Single Arrows",9,"EA",null,{"v":0,"d":"$0.00"}]
["02900-C10-00250","Combination Arrows",2,"EA",null,{"v":0,"d":"$0.00"}]
["02900-C10-00300","Standard Bicycle Symbols (MUTCD, Chapter 9C, Figure 9C-9), \"Shared Lane Marking\"",1,"EA",null,{"v":0,"d":"$0.00"}]
["02619-C10-00410","Traffic Control Sign (Typical Stop, Yield, No Parking, Speed Limit, or Similar)",11,"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",21,"EA",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUM(F121:F134)","v":{"v":0,"d":"$0.00"}}]
[]
["C11","LANDSCAPE AND HARDSCAPE RESTORATION WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["02800-C11-SP020","Planting Soil Mixture / Backfill Soil Mixture (per Arlington County DPR Specification and Bid Plan Set Attachment-D)",900,"CY",null,{"$f":"IFERROR($C139*$E139, \"\")","v":{"v":0,"d":"$0.00"}}]
["02800-C11-SP031","Continuous Soil Panel (Per DPR Detail 329300.11 Modified shown on Bid Plan Set Attachment-D)",1760,"CY",null,{"v":0,"d":"$0.00"}]
["02801-C11-00040","Shredded hardwood mulch; Aged 6 months minimum - Free of Trash & Debris",440,"CY",null,{"v":0,"d":"$0.00"}]
["02801-C11-00050","Seed, Mixture of 85% Tall Fescue/Bluegrass and 15% Annual Rye",1000,"SY",null,{"v":0,"d":"$0.00"}]
["02801-C11-00060","Sod, Tall Fescue/Bluegrass Mixture",2070,"SY",null,{"v":0,"d":"$0.00"}]
["02100-C11-00500","Tree/Stump Removal - Class A. Remove and Dispose, Up to 6\" DBH to 12\" DBH (Diameter at Breast Height)",27,"EA",null,{"v":0,"d":"$0.00"}]
["02100-C11-00501","Tree/Stump Removal - Class B. Remove and Dispose, over 12\" DBH to 18\" DBH (Diameter at Breast Height)",13,"EA",null,{"v":0,"d":"$0.00"}]
["02100-C11-00502","Tree/Stump Removal - Class C. Remove and Dispose, over 18\" DBH to 24\" DBH (Diameter at Breast Height)",1,"EA",null,{"v":0,"d":"$0.00"}]
["05500-C11-00140","Handrail (Arlington County Detail R-3.1)",185,"LF",null,{"v":0,"d":"$0.00"}]
["02800-C11-00200","Chain Link Fence, Height Less Than or Equal to 6'",200,"LF",null,{"v":0,"d":"$0.00"}]
["05500-C11-00260","Fence and Posts (Any Size or Material), Remove & Dispose, only when not included in other pay items",1330,"LF",null,{"v":0,"d":"$0.00"}]
["03100-C11-SP105","Retaining Wall - Concrete Gravity as per details shown Sheet C20.1",3640,"CF",null,{"v":0,"d":"$0.00"}]
["05500-C11-SP205","Furnish and Install 6' Tall Hinged Wooden Gate Per Sheet C10.1",1,"EA",null,{"v":0,"d":"$0.00"}]
["05500-C11-SP181","Wooden Fence, Height Up to 6' per sheet C10.1",120,"LF",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUM(F139:F152)","v":{"v":0,"d":"$0.00"}}]
[]
["C12","BUS STOP SHELTER AND FURNISHINGS"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["13130-C12-00010","Bus Shelter Pad (Detail R-2.10) (6\" and 10\" depth)",275,"SY",null,{"$f":"IFERROR($C157*$E157, \"\")","v":{"v":0,"d":"$0.00"}}]
["13130-C12-00150","Install Traditional/Contemporary Bicycle Rack",6,"EA",null,{"v":0,"d":"$0.00"}]
["10530-C12-00200","Bus Shelter (Any type), Remove, Transport and Salvage in the County Facility 2900 S. Eads Street",1,"EA",null,{"v":0,"d":"$0.00"}]
["13130-C12-00101","Install 8' Free-standing Bench",2,"EA",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUM(F157:F160)","v":{"v":0,"d":"$0.00"}}]
[]
["C13","EROSION AND SEDIMENT CONTROL WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[{"$nulls":4},"SUBTOTAL"]
[]
["C15","UNLISTED WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[{"$nulls":4},"SUBTOTAL"]
[]
["C16","MOT AND RE-MOBILIZATION WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[{"$nulls":4},"SUBTOTAL"]
[]
["C17","STORMWATER WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[{"$nulls":4},"SUBTOTAL"]
[]
["C18","NON COUNTY UTILITIES"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["02580-C18-DO120","1-4\" Duct Standard Duct Bank (1W X 1H) All Depths",395,"LF",null,{"$f":"IFERROR($C181*$E181, \"\")","v":{"v":0,"d":"$0.00"}}]
["02580-C18-DO130","2-4\" Duct Standard Duct Bank (2W X 1H) All Depths",100,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-DO220","2-8\" Duct Standard Duct Bank (2W X 1H) All Depths",245,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-DO230","4-8\" Duct Standard Duct Bank (2W X 2H) All Depths",270,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-DO240","6-8\" Duct Standard Duct Bank (2W X 3H) All Depths",470,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-DO510","1-4\" & 2-8\" Duct Standard Duct Bank (1W X 1H & 2W X 1H) All Depths",120,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-DO515","1-4\" & 4-8\" Duct Standard Duct Bank (1W X 1H & 2W X 2H) All Depths",185,"LF",null,{"$f":"IFERROR($C187*$E187, \"\")","v":{"v":0,"d":"$0.00"}}]
["02580-C18-DOSP4","2-4\" & 4-8\" Duct Standard Duct Bank (1W X 1H & 2W X 2H) All Depths",19,"LF",null,{"$f":"IFERROR($C188*$E188, \"\")","v":{"v":0,"d":"$0.00"}}]
["02580-C18-DOSP5","1-4\" & 6-8\" Duct Standard Duct Bank (1W X 1H & 2W X 3H) All Depths",14,"LF",null,{"$f":"IFERROR($C189*$E189, \"\")","v":{"v":0,"d":"$0.00"}}]
["02580-C18-DOSP6","2-6\" & 2-8\" Duct Standard Duct Bank (2W X 1H & 2W X 1H) All Depths",57,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-DOSP7","DEV MANHOLE (8'X16'10') 0-5' Deep (DEV provided manhole frame anc covers)",2,"EA",null,{"v":0,"d":"$0.00"}]
["02580-C18-DOSP8","INSTALL 78\"X48\" DEV SPLICE BOX (PROVIDED BY DEV)",1,"EA",null,{"v":0,"d":"$0.00"}]
["02580-C18-DOSP9","Furnish and Install DEV Meter Base or Meter Pedestal and Disconnect Switch",8,"EA",null,{"v":0,"d":"$0.00"}]
["02580-C18-DOS10","Internal/external secondary service connections including all materials, appurtenances, labor, permitting, and coordination to make the secondary service connections in accordance with the latest edition of Dominion Energy’s Blue Book.",4,"EA",null,{"v":0,"d":"$0.00"}]
["02580-C18-CO130","2-4\" Duct Standard Duct Bank (2W X 1H)All Depths",895,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-CO140","4-4\" Duct Standard Duct Bank (2W X 2H) All Depths",365,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-COSP1","1-4\" Duct Standard Duct Bank (1W X 1H) All Depths",44,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-COSP2","5-4\" Duct Standard Duct Bank (2W X 3H) All Depths",175,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-COSP3","7-4\" Duct Standard Duct Bank (2W X 4H) All Depths",22,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-COSP4","INSTALL COMCAST DOUBLE VAULT  (62.5\" x 40\") (Vault Provided by Comcast)",3,"EA",null,{"v":0,"d":"$0.00"}]
["02580-C18-COSP5","INSTALL COMCAST 2'x3' HAND HOLE (Handhole Provided by Comcast)",5,"EA",null,{"v":0,"d":"$0.00"}]
["02580-C18-SP010","1-2\" Elec. Conduit All Depths",455,"LF",null,{"$f":"IFERROR($C202*$E202, \"\")","v":{"v":0,"d":"$0.00"}}]
["02581-C18-SP020","1-2\" Comm. Conduit All Depths",285,"LF",null,{"$f":"IFERROR($C203*$E203, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUM(F181:F203)","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":"+E211*$F$207","v":{"v":0,"d":"$0.00"}}]
["01000-C16-00010","Maintenance of Traffic (MOT)","NA","%",null,{"v":0,"d":"$0.00"}]
["01000-C16-00030","Mobilization and De-Mobilization","NA","%",null,{"$f":"+E213*$F$207","v":{"v":0,"d":"$0.00"}}]
["01500-SA-00200","SWPPP Administration","NA","%",null,{"$f":"+E214*$F$207","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"PERCENTAGE LINE ITEMS SUBTOTAL",{"$f":"SUM(F211:F214)","v":{"v":0,"d":"$0.00"}}]
[]
[]
[]
[{"$nulls":4},"Segment C Total :",{"$f":"$F$215+F207","v":{"v":0,"d":"$0.00"}}]

{"sheet":"Segment D","index":2,"n_rows":208,"n_cols":6,"rows_kept":208,"merged":[[0,0,0,5]]}
["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)."]
[]
["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)",5665,"CY",null,{"$f":"IFERROR($C6*$E6, \"\")","v":{"v":0,"d":"$0.00"}}]
["02200-C1-00140","Aggregate, VDOT #21-B  (Compacted in Place per VDOT standards & Specs)",5840,"CY",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUM(F6:F7)","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.",1475,"LF",null,{"$f":"IFERROR($C12*$E12, \"\")","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.",4475,"LF",null,{"v":0,"d":"$0.00"}]
["02750-C2-00100","Valley Gutter (Arlington County Detail R-2.9, including all materials as shown in detail)",35,"SY",null,{"v":0,"d":"$0.00"}]
["02611-C2-00110","Concrete Sidewalk, 4\" Thickness (Arlington County Detail R-2.0)",2175,"SY",null,{"v":0,"d":"$0.00"}]
["02611-C2-00190","CG-12 Detectable Warning Surface - Truncated Domes",115,"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)",500,"SY",null,{"v":0,"d":"$0.00"}]
["03100-C2-00200","Concrete Steps Each (Arlington County Detail R-3.0, including all reinforcing bars as shown in detail)",110,"LF-W",null,{"v":0,"d":"$0.00"}]
["03100-C2-SP130","Concrete Bus Pad as per detail Inset C shown on Sheet D3.1. \nConcrete Surface A-3 Concrete with Welded Wire 6\"x6\" W2.9xW2.9.",225,"CY",null,{"$f":"IFERROR($C19*$E19, \"\")","v":{"v":0,"d":"$0.00"}}]
["02750-C2-0075","Concrete Curb & Gutter, Standard C-4 (Arlington County Detail R-2.0)",390,"LF",null,{"$f":"IFERROR($C20*$E20, \"\")","v":{"v":0,"d":"$0.00"}}]
["02750-C2-SP120","Concrete Sidewalk as per details shown on sheet D14.6, D14.7 & D14.7.1 including but not limited to brick bands, steel edgings, WWM, rebars, dowels, vapor barriers all complete.",2585,"SY",null,{"$f":"IFERROR($C21*$E21, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUM(F12:F21)","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)",2490,"SY",null,{"$f":"IFERROR($C26*$E26, \"\")","v":{"v":0,"d":"$0.00"}}]
["02600-C3-00030","Asphalt Concrete, Base Course (VDOT BM-25.0A)",265,"TON",null,{"v":0,"d":"$0.00"}]
["02600-C3-00160","Asphalt Concrete, Base Course (VDOT BM-25.0D)",5845,"TON",null,{"v":0,"d":"$0.00"}]
["02600-C3-00050","Asphalt Concrete, Intermediate Course (VDOT IM-19.0D)",3900,"TON",null,{"v":0,"d":"$0.00"}]
["02600-C3-00060","Asphalt Concrete, Surface Course (VDOT SM-9.5A)",65,"TON",null,{"v":0,"d":"$0.00"}]
["02600-C3-00070","Asphalt Concrete, Surface Course (VDOT SM-9.5D)",2245,"TON",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUM(F26:F31)","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",335,"LF",null,{"$f":"IFERROR($C36*$E36, \"\")","v":{"v":0,"d":"$0.00"}}]
["02505-C4-00630","15\" Pipe, RCP Class III, In Place 6' to 8' Deep",500,"LF",null,{"v":0,"d":"$0.00"}]
["02500-C4-00650","18\" Pipe, RCP Class III, In Place 6' to 9' Deep",60,"LF",null,{"v":0,"d":"$0.00"}]
["02500-C4-00690","24\" Pipe, RCP Class III, In Place 6' to 11' Deep",360,"LF",null,{"v":0,"d":"$0.00"}]
["02505-C4-01420","Underdrain, Standard VDOT UD-1",4475,"LF",null,{"v":0,"d":"$0.00"}]
["02505-C4-01480","Abandon storm pipe in place Including capping all open ends and completely filling sewer with flowable fill (All material types, sizes and depths)",90,"LF",null,{"v":0,"d":"$0.00"}]
["02505-C4-00010","Storm Manhole MH-1 (Arlington County Detail D-3.0), In Place, DEPTH   8'",2,"EA",null,{"v":0,"d":"$0.00"}]
["02505-C4-00100","CB-2A or CB-2B (throat lengths from 8'-6\" up to 16'-0\"),  In Place Up to 6' Deep, Arlington County Standards.",18,"EA",null,{"v":0,"d":"$0.00"}]
["02505-C4-00470","Catch Basin Structure Top, Remove & Replace",3,"EA",null,{"v":0,"d":"$0.00"}]
["02505-C4-00600","Storm Manhole, Catch Basin, Drop Inlet, Yard Inlet, or Grate Inlet, Remove",4,"EA",null,{"v":0,"d":"$0.00"}]
["02500-C4-00011","Storm Manhole MH-1 (Arlington County Detail D-3.0), In Place, PER ADDITIONAL VF OVER 8'",3,"VF",null,{"v":0,"d":"$0.00"}]
["02505-C4-00110","CB-2A or CB-2B (throat lengths from 8'-6\" up to 16'-0\"), Each VF Over 6' Deep, Arlington County Standards.",25,"VF",null,{"v":0,"d":"$0.00"}]
["02505-C4-SP200","Cast in place custom inlet as per notes mentioned on D10.2 and detail shown on sheet D2.4",1,"EA",null,{"$f":"IFERROR($C48*$E48, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUM(F36:F48)","v":{"v":0,"d":"$0.00"}}]
[]
["C5","GUARDRAIL"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[{"$nulls":4},"SUBTOTAL"]
[]
["C6","WATERMAIN WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["02550-C6-00140","12-Inch Gate Valve & Valve Box",26,"EA",null,{"$f":"IFERROR($C57*$E57, \"\")","v":{"v":0,"d":"$0.00"}}]
["02550-C6-00150","8-Inch Gate Valve & Valve Box",3,"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",9,"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-00230","2-Inch Air Release Or Vacuum Valve In Concrete Manhole For All Diameter Of Water Mains",2,"EA",null,{"v":0,"d":"$0.00"}]
["02550-C6-00250","Remove Existing Fire Hydrant",6,"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)",9,"EA",null,{"v":0,"d":"$0.00"}]
["02550-C6-00300","Cut & Cap 12-Inch Water Main",15,"EA",null,{"v":0,"d":"$0.00"}]
["02550-C6-00320","Cut & Cap 8-Inch Water Main",7,"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 AND EXCAVATION)--UP TO 1O FT.",31,"EA",null,{"v":0,"d":"$0.00"}]
["02550-C6-00690","Service Taps  - 1 1/2-inch and 2-inch (TAP MAIN, INSTALL COPPER TUBING, INSTALL GATE VALVES, CORPORATION COCK, METER BOX AND METER, CONNECT TO EXISTING PRIVATE SERVICE LINE, BACKFILL AND EXCAVATION)--UP TO 1O FT.",12,"EA",null,{"v":0,"d":"$0.00"}]
["02550-C6-00730","Water Meter Relocations  - 1 1/2-inch and 2-inch (INSTALL COPPER TUBING, CONNECT TO EXISTING COUNTY AND PRIVATE SERVICE LINES, PROVIDE NEW GATE VALVES, RELOCATE METER HOUSING AND METER, BACKFILL AND EXCAVATION)--UP TO 10 FT.",1,"EA",null,{"v":0,"d":"$0.00"}]
["02550-C6-00030","12-Inch Water Main, DIP CL-52, Upto 6' Deep",2445,"LF",null,{"v":0,"d":"$0.00"}]
["02550-C6-00040","12-Inch Water Main, DIP CL-52, > 6' Deep",525,"LF",null,{"v":0,"d":"$0.00"}]
["02550-C6-00050","8-Inch Water Main, DIP CL-52, Upto 6' Deep",95,"LF",null,{"v":0,"d":"$0.00"}]
["02550-C6-00060","8-Inch Water Main, DIP CL-52, > 6' Deep",235,"LF",null,{"v":0,"d":"$0.00"}]
["02550-C6-00070","6-Inch Water Main, DIP CL-53, Upto 6' Deep",45,"LF",null,{"v":0,"d":"$0.00"}]
["02550-C6-00640","Service Taps - 3/4-inch and 1-inch PER ADDITIONAL LINEAR FOOT OVER 10 FT.",620,"LF",null,{"v":0,"d":"$0.00"}]
["02550-C6-00700","Service Taps  - 1 1/2-inch and 2-inch PER ADDITIONAL LINEAR FOOT OVER 10 FT.",255,"LF",null,{"v":0,"d":"$0.00"}]
["02550-C6-00740","Service Relocations  - 1 1/2-inch and 2-inch PER ADDITIONAL LINEAR FOOT OVER 10 FT.",22,"LF",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUM(F57:F77)","v":{"v":0,"d":"$0.00"}}]
[]
["C7","SANITARY SEWER WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["02510-C7-00010","Sanitary Sewer - 8\" PVC, SDR 35, DEPTH < 8’",130,"LF",null,{"$f":"IFERROR($C82*$E82, \"\")","v":{"v":0,"d":"$0.00"}}]
["02510-C7-00020","Sanitary Sewer - 8\" PVC, SDR 35, 8’ ≤ DEPTH < 14’",345,"LF",null,{"v":0,"d":"$0.00"}]
["02510-C7-00030","Sanitary Sewer - 8\" PVC, SDR 26, DEPTH ≥ 14'",40,"LF",null,{"v":0,"d":"$0.00"}]
["02510-C7-00080","Sanitary Sewer - 10\" PVC, SDR 35,  8’ ≤ DEPTH < 14'",90,"LF",null,{"v":0,"d":"$0.00"}]
["02510-C7-00090","Sanitary Sewer - 10\" PVC, SDR 26, DEPTH ≥ 14'",65,"LF",null,{"v":0,"d":"$0.00"}]
["02510-C7-00130","Sanitary Sewer - 12\" PVC, SDR 35, DEPTH< 8’",510,"LF",null,{"v":0,"d":"$0.00"}]
["02510-C7-00140","Sanitary Sewer - 12\" PVC, SDR 35, 8’ ≤ DEPTH < 14'",620,"LF",null,{"v":0,"d":"$0.00"}]
["02510-C7-00150","Sanitary Sewer - 12\" PVC, SDR 26,  DEPTH ≥ 14'",265,"LF",null,{"v":0,"d":"$0.00"}]
["02510-C7-00200","Manhole - Precast Concrete, 4' ID, DEPTH  < 8'",13,"EA",null,{"v":0,"d":"$0.00"}]
["02510-C7-00210","Manhole-Precast Concrete 4' I.D. DEPTH > 8', PER ADDITIONAL VF OVER 8'",25,"VF",null,{"v":0,"d":"$0.00"}]
["02510-C7-00220","Manhole-Precast Concrete 5' I.D. DEPTH  < 8'",1,"EA",null,{"v":0,"d":"$0.00"}]
["02510-C7-00230","Manhole-Precast Concrete 5' I.D. DEPTH >8', PER ADDITIONAL VF OVER 8'",15,"VF",null,{"v":0,"d":"$0.00"}]
["02510-C7-SP240","Manhole-Construct Over Existing Sewer, Arlington County DRAWING S-2.2 (PAYMENT SHALL BE FOR DOGHOUSE MANHOLE COMPLETE IN PLACE INCLUDING BASE, FRAME AND COVER; VF BEYOND 8' SHALL BE PAID UNDER VF PRICES FOR MANHOLES PER ITEM ABOVE)",8,"EA",null,{"v":0,"d":"$0.00"}]
["02510-C7-00760","Sanitary Sewer Drop Connection, All sizes, (Arlington County Detail S-2.3)",2,"EA",null,{"v":0,"d":"$0.00"}]
["02510-C7-00260","Connect To Existing Sanitary Manhole",2,"EA",null,{"v":0,"d":"$0.00"}]
["02510-C7-00270","Sanitary Sewer House Laterals(IN ACCORDANCE WITH Arlington County CONSTRUCTION STANDARDS AND SPECIFICATIONS SECTION 02510, PART 3, ITEM 3.4)",1295,"LF",null,{"v":0,"d":"$0.00"}]
["02510-C7-SP235","Manhole - Precast Concrete, 6' ID, DEPTH < 8'",1,"EA",null,{"$f":"IFERROR($C98*$E98, \"\")","v":{"v":0,"d":"$0.00"}}]
["02510-C7-SP236","Manhole - Precast Concrete 6' I.D. DEPTH > 8', PER ADDITONAL VF OVER 8'",10,"VF",null,{"$f":"IFERROR($C99*$E99, \"\")","v":{"v":0,"d":"$0.00"}}]
["02510-C7-SP255","Remove Existing Sanitary Manhole",3,"EA",null,{"$f":"IFERROR($C100*$E100, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUM(F82:F100)","v":{"v":0,"d":"$0.00"}}]
[]
["C8","TRAFFIC SIGNAL WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["13160-C8-03000","Traffic Signal Work Complete per Plan D17.1 through D17.8",1,"LS",null,{"$f":"IFERROR($C105*$E105, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUM(F105:F105)","v":{"v":0,"d":"$0.00"}}]
[]
["C9","STREET LIGHTING WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["14030-C9-00030","Furnish and Install 2 inch SCH 80 HDPE Direct Bore Conduit (Detail 14030-01)",755,"LF",null,{"$f":"IFERROR($C110*$E110, \"\")","v":{"v":0,"d":"$0.00"}}]
["14030-C9-00040","Furnish and Install 2 Inch Sch 40 PVC Conduit in Trench (Detail 14030-01)",2000,"LF",null,{"v":0,"d":"$0.00"}]
["14040-C9-00200","Furnish and Install Junction Box Lid LARGE (Detail 14040-02)",2,"EA",null,{"v":0,"d":"$0.00"}]
["14050-C9-00260","Furnish & Install full set of conductors as required by plan per linear foot of conduit",2750,"LF",null,{"v":0,"d":"$0.00"}]
["14060-C9-00290","Install Streetlight Pole Foundation Type F-1 (Detail 14060-01)",9,"EA",null,{"v":0,"d":"$0.00"}]
["14060-C9-00310","Install Shallow Depth Foundation (Detail 14060-02)",13,"EA",null,{"v":0,"d":"$0.00"}]
["14060-C9-00350","Removal of Existing Foundation - up to 4' Deep",40,"EA",null,{"v":0,"d":"$0.00"}]
["14100-C9-00630","Furnish and Install Meter Pan, Pedestal, Control Box and Components (Detail 14100-01)",1,"EA",null,{"v":0,"d":"$0.00"}]
["14050-C9-SP0080","Relocate Existing Streetlight Pole, Luminaire Arm and Light Fixture",22,"EA",null,{"$f":"IFERROR($C118*$E118, \"\")","v":{"v":0,"d":"$0.00"}}]
["14050-C9-SP090","Remove Roadway Light or Streetlight Pole",17,"EA",null,{"$f":"IFERROR($C119*$E119, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUM(F110:F119)","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",115,"LF",null,{"$f":"IFERROR($C124*$E124, \"\")","v":{"v":0,"d":"$0.00"}}]
["02900-C10-00030","Twelve (12) Inch Transverse Markings",35,"LF",null,{"v":0,"d":"$0.00"}]
["02900-C10-00040","Eighteen (18) Inch Transverse Markings",470,"LF",null,{"v":0,"d":"$0.00"}]
["02900-C10-00050","Twenty Four (24) Inch Transverse Markings, Note: Used For Continental (Ladder) Crosswalk",2570,"LF",null,{"v":0,"d":"$0.00"}]
["02900-C10-00070","Four (4) Inch Longitudinal Solid Line",2055,"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",3545,"LF",null,{"v":0,"d":"$0.00"}]
["02900-C10-00120","Six (6) Inch Longitudinal Solid Line",1120,"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",810,"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",1880,"LF",null,{"v":0,"d":"$0.00"}]
["02900-C10-00240","Single Arrows",25,"EA",null,{"v":0,"d":"$0.00"}]
["02900-C10-00250","Combination Arrows",1,"EA",null,{"v":0,"d":"$0.00"}]
["02900-C10-00290","Standard Bicycle Symbols (MUTCD, Chapter 9C, Figure 9C-3), \"Bike Symbol\", \"Helmeted Bicyclist Symbol\"",1,"EA",null,{"v":0,"d":"$0.00"}]
["02900-C10-00300","Standard Bicycle Symbols (MUTCD, Chapter 9C, Figure 9C-9), \"Shared Lane Marking\"",1,"EA",null,{"v":0,"d":"$0.00"}]
["02900-C10-00350","Colorized Bike Lane Coatings (per Specification 02900)",25,"SY",null,{"v":0,"d":"$0.00"}]
["02619-C10-00410","Traffic Control Sign (Typical Stop, Yield, No Parking, Speed Limit, or Similar)",33,"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",16,"EA",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUM(F124:F139)","v":{"v":0,"d":"$0.00"}}]
[]
["C11","LANDSCAPE AND HARDSCAPE RESTORATION WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["02800-C11-SP020","Planting Soil Mixture / Backfill Soil Mixture (per Arlington County DPR Specification and Bid Plan Set Attachment-D)",335,"CY",null,{"$f":"IFERROR($C144*$E144, \"\")","v":{"v":0,"d":"$0.00"}}]
["02800-C11-SP031","Continuous Soil Panel (Per DPR Detail 329300.11 Modified shown on Bid Plan Set Attachment-D)",990,"CY",null,{"v":0,"d":"$0.00"}]
["329100-C11-00040","Shredded hardwood mulch; Aged 6 months minimum - Free of Trash & Debris",80,"CY",null,{"v":0,"d":"$0.00"}]
["329200-C11-00050","Seed, Mixture of 85% Tall Fescue/Bluegrass and 15% Annual Rye",1000,"SY",null,{"v":0,"d":"$0.00"}]
["329200C11-00060","Sod, Tall Fescue/Bluegrass Mixture",1350,"SY",null,{"v":0,"d":"$0.00"}]
["02100-C11-00500","Tree/Stump Removal - Class A. Remove and Dispose, Up to 6\" DBH to 12\" DBH (Diameter at Breast Height)",42,"EA",null,{"v":0,"d":"$0.00"}]
["02100-C11-00501","Tree/Stump Removal - Class B. Remove and Dispose, over 12\" DBH to 18\" DBH (Diameter at Breast Height)",5,"EA",null,{"v":0,"d":"$0.00"}]
["02100-C11-00502","Tree/Stump Removal - Class C. Remove and Dispose, over 18\" DBH to 24\" DBH (Diameter at Breast Height)",3,"EA",null,{"v":0,"d":"$0.00"}]
["02100-C11-00503","Tree/Stump Removal - Class D. Remove and Dispose, over 24\" DBH to 30\" DBH (Diameter at Breast Height)",1,"EA",null,{"v":0,"d":"$0.00"}]
["02800-C11-00200","Chain Link Fence, Height Less Than or Equal to 6'",65,"LF",null,{"v":0,"d":"$0.00"}]
["05500-C11-00260","Fence and Posts (Any Size or Material), Remove & Dispose, only when not included in other pay items",450,"LF",null,{"v":0,"d":"$0.00"}]
["04300-C11-SP120","Remove 5' Section of Wall, Construct Temporary Stairs and Walkway, Restore In Kind per Sheet D6.1",1,"LS",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUM(F144:F155)","v":{"v":0,"d":"$0.00"}}]
[]
["C12","BUS STOP SHELTER AND FURNISHINGS"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["13130-C12-00010","Bus Shelter Pad (Detail R-2.10)",660,"SY",null,{"$f":"IFERROR($C160*$E160, \"\")","v":{"v":0,"d":"$0.00"}}]
["13130-C12-00150","Install Traditional/Contemporary Bicycle Rack",10,"EA",null,{"v":0,"d":"$0.00"}]
["10530-C12-00170","Bus Shelter Furnishings (Any Type), Remove and Dispose, or Remove and Salvage",11,"EA",null,{"v":0,"d":"$0.00"}]
["13130-C12-00101","Install 8' Free-standing Bench",4,"EA",null,{"v":0,"d":"$0.00"}]
["10530-C12-00200","Bus Shelter (Any type), Remove, Transport and Salvage in the County Facility 2900 S. Eads Street",2,"EA",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUM(F160:F164)","v":{"v":0,"d":"$0.00"}}]
[]
["C13","EROSION AND SEDIMENT CONTROL WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[{"$nulls":4},"SUBTOTAL"]
[]
["C15","UNLISTED WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[{"$nulls":4},"SUBTOTAL"]
[]
["C16","MOT AND RE-MOBILIZATION WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[]
[]
["C17","STORMWATER WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[{"$nulls":4},"SUBTOTAL"]
[]
["C18","NON COUNTY UTILITIES"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["02580-C18-SP010","1-2\" Elec. Conduit All Depths",765,"LF",null,{"$f":"IFERROR($C185*$E185, \"\")","v":{"v":0,"d":"$0.00"}}]
["02581-C18-SP020","1-2\" Comm. Conduit All Depths",365,"LF",null,{"$f":"IFERROR($C186*$E186, \"\")","v":{"v":0,"d":"$0.00"}}]
["02580-C18-DO130","2-4\" Duct Standard Duct Bank (2W X 1H) All Depths",41,"LF",null,{"$f":"IFERROR($C187*$E187, \"\")","v":{"v":0,"d":"$0.00"}}]
["02580-C18-DO150","4-4\" Duct Standard Duct Bank (2W X 2H) All Depths",20,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-DO200","2-6\" Duct Standard Duct Back (2W X 1H) All Depths",45,"LF",null,{"v":0,"d":"$0.00"}]
["02581-C18-DOSP1","2-4\" DEV Conduit All Depths",20,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-DOSP2","4-4\" & 2-6\" Duct Standard Duct Bank (2W X 1H & 2W X 1H) All Depths",26,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-DOSP3","Install Splice Box ((Provided by DEV) 24\"X36\")",1,"EA",null,{"$f":"IFERROR($C192*$E192, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUM(F185:F192)","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":"+E200*$F$196","v":{"v":0,"d":"$0.00"}}]
["01000-C16-00010","Maintenance of Traffic (MOT)","NA","%",null,{"$f":"+E201*$F$196","v":{"v":0,"d":"$0.00"}}]
["01000-C16-00030","Mobilization and De-Mobilization","NA","%",null,{"v":0,"d":"$0.00"}]
["01500-SA-00200","SWPPP Administration","NA","%",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"PERCENTAGE LINE ITEMS SUBTOTAL",{"$f":"SUM(F202:F203)","v":{"v":0,"d":"$0.00"}}]
[]
[]
[]
[{"$nulls":4},"Segment D Total :",{"$f":"$F$204+F196","v":{"v":0,"d":"$0.00"}}]