{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Grand Total Summary Sheet","Segment F","Segment A"],"not_rendered":{"external_links":6,"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"]
["Contract Amount Summary"]
["Description","Contract Amount"]
["Segment A",{"$f":"+'Segment A'!F217","v":{"v":0,"d":"$0.00"}}]
["Segment F",{"$f":"+'Segment F'!F261","v":{"v":0,"d":"$0.00"}}]
["Grand Total Bid ",{"$f":"+B6+B7","v":{"v":0,"d":"$0.00"}}]

{"sheet":"Segment F","index":1,"n_rows":261,"n_cols":6,"rows_kept":261,"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)",7150,"CY",null,{"$f":"IFERROR($C6*$E6, \"\")","v":{"v":0,"d":"$0.00"}}]
["02200-C1-00130","Aggregate, VDOT #21-A  (Compacted in Place per VDOT standards & Specs)",230,"CY",null,{"v":0,"d":"$0.00"}]
["02200-C1-00140","Aggregate, VDOT #21-B  (Compacted in Place per VDOT standards & Specs)",7500,"CY",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUM(F6:F8)","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.",4420,"LF",null,{"$f":"IFERROR($C13*$E13, \"\")","v":{"v":0,"d":"$0.00"}}]
["02750-C2-00070","Concrete Curb & Gutter, Combination 6\" (VDOT CG-6), includes curb & gutter for aprons, ramps, etc.",5750,"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)",180,"SY",null,{"v":0,"d":"$0.00"}]
["02611-C2-00110","Concrete Sidewalk, 4\" Thickness (Arlington County Detail R-2.0)",620,"SY",null,{"v":0,"d":"$0.00"}]
["02611-C2-00190","CG-12 Detectable Warning Surface - Truncated Domes",165,"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)",635,"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)",30,"LF-W",null,{"v":0,"d":"$0.00"}]
["03100-C2-00230","Concrete and Formwork (VDOT Class A3), only when not included in other pay items",215,"CY",null,{"v":0,"d":"$0.00"}]
["03100-C2-SP130","Concrete Bus Pad as per detail Inset C shown on Sheet F3.1. \nConcrete Surface A-3 Concrete with Welded Wire 6\"x6\" W2.9xW2.9.",190,"CY",null,{"$f":"IFERROR($C21*$E21, \"\")","v":{"v":0,"d":"$0.00"}}]
["02750-C2-SP065","Concrete Curb & Gutter, Standard C-4 (Arlington County Detail R-2.0)",705,"LF",null,{"$f":"IFERROR($C22*$E22, \"\")","v":{"v":0,"d":"$0.00"}}]
["02750-C2-SP120","Concrete Sidewalk as per details shown on sheet F14.6.2 & F14.6.3. including but not limited to brick bands, steel edgings, dowels all complete",5570,"SY",null,{"$f":"IFERROR($C23*$E23, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUM(F13:F23)","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)",505,"SY",null,{"$f":"IFERROR($C28*$E28, \"\")","v":{"v":0,"d":"$0.00"}}]
["02600-C3-00160","Asphalt Concrete, Base Course (VDOT BM-25.OD)",8210,"TON",null,{"v":0,"d":"$0.00"}]
["02600-C3-00050","Asphalt Concrete, Intermediate Course (VDOT IM-19.0D)",5145,"TON",null,{"v":0,"d":"$0.00"}]
["02600-C3-SP075","Asphalt Concrete, Surface Course (VDOT SM-9.5E)",2760,"TON",null,{"$f":"IFERROR($C31*$E31, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUM(F28: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",175,"LF",null,{"$f":"IFERROR($C36*$E36, \"\")","v":{"v":0,"d":"$0.00"}}]
["02500-C4-00820","15\" Pipe, RCP Class IV, In Place Up to 6' Deep",800,"LF",null,{"v":0,"d":"$0.00"}]
["02500-C4-00830","15\" Pipe, RCP Class IV, In Place 6' to 10' Deep",1055,"LF",null,{"v":0,"d":"$0.00"}]
["02500-C4-00850","18\" Pipe, RCP Class IV, In Place Up to 6' Deep",15,"LF",null,{"v":0,"d":"$0.00"}]
["02500-C4-00860","18\" Pipe, RCP Class IV, In Place 6' to 10' Deep",65,"LF",null,{"v":0,"d":"$0.00"}]
["02500-C4-00910","24\" Pipe, RCP Class IV, In Place Up to 6' Deep",105,"LF",null,{"v":0,"d":"$0.00"}]
["02505-C4-01440","Underdrain, Standard VDOT UD-4",4430,"LF",null,{"v":0,"d":"$0.00"}]
["02505-C4-00010","Storm Manhole MH-1 (Arlington County Detail D-3.0), In Place, DEPTH   8'",20,"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.",33,"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"}]
["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-00300","Curb Drop Inlet, Standard (with Utility Space) VDOT DI-3E (12\" to 30\" Pipe), In Place Up to 8' Deep, Inlet Throat Length 4' to 20'",3,"EA",null,{"v":0,"d":"$0.00"}]
["02505-C4-00600","Storm Manhole, Catch Basin, Drop Inlet, Yard Inlet, or Grate Inlet, Remove",7,"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'",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.",25,"VF",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUM(F36:F50)","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-00190","Connect To Existing 12-Inch Water Main",3,"EA",null,{"$f":"IFERROR($C59*$E59, \"\")","v":{"v":0,"d":"$0.00"}}]
["02550-C6-00200","Connect To Existing 8-Inch Water Main",5,"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-00230","2-Inch Air Release Or Vacuum Valve In Concrete Manhole For All Diameter Of Water Mains",1,"EA",null,{"v":0,"d":"$0.00"}]
["02550-C6-00250","Remove Existing Fire Hydrant",7,"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)",7,"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",4,"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-00530","6\" x 6\" Tap/Sleeve On Iron Pipe, Valve & Valve Box",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.",1,"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.",3,"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",2375,"LF",null,{"v":0,"d":"$0.00"}]
["02550-C6-00040","12-Inch Water Main, DIP CL-52, > 6' Deep",90,"LF",null,{"v":0,"d":"$0.00"}]
["02550-C6-00050","8-Inch Water Main, DIP CL-52, Upto 6' Deep",325,"LF",null,{"v":0,"d":"$0.00"}]
["02550-C6-00060","8-Inch Water Main, DIP CL-52, > 6' Deep",55,"LF",null,{"v":0,"d":"$0.00"}]
["02550-C6-00070","6-Inch Water Main, DIP CL-53, Upto 6' Deep",190,"LF",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUM(F59:F76)","v":{"v":0,"d":"$0.00"}}]
[]
["C7","SANITARY SEWER WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["02510-C7-SP005","Sanitary Sewer - 6\" PVC, SDR 35, DEPTH  ≥ 14'",20,null,null,{"$f":"IFERROR($C81*$E81, \"\")","v":{"v":0,"d":"$0.00"}}]
["02510-C7-00010","Sanitary Sewer - 8\" PVC, SDR 35, DEPTH < 8’",155,"LF",null,{"$f":"IFERROR($C82*$E82, \"\")","v":{"v":0,"d":"$0.00"}}]
["02510-C7-00020","Sanitary Sewer - 8\" PVC, SDR 35, 8’ ≤ DEPTH < 14’",270,"LF",null,{"v":0,"d":"$0.00"}]
["02510-C7-00030","Sanitary Sewer - 8\" PVC, SDR 26, DEPTH ≥ 14'",20,"LF",null,{"v":0,"d":"$0.00"}]
["02510-C7-00140","Sanitary Sewer - 12\" PVC, SDR 35, 8’ ≤ DEPTH < 14'",1185,"LF",null,{"v":0,"d":"$0.00"}]
["02510-C7-00150","Sanitary Sewer - 12\" PVC, SDR 26,  DEPTH ≥ 14'",1125,"LF",null,{"v":0,"d":"$0.00"}]
["02510-C7-00050","Sanitary Sewer- 8\"DIP CLASS 52, 8'≤ DEPTH < 15'",30,"LF",null,{"v":0,"d":"$0.00"}]
["02510-C7-00200","Manhole - Precast Concrete, 4' ID, DEPTH  < 8'",18,"EA",null,{"v":0,"d":"$0.00"}]
["02510-C7-00210","Manhole-Precast Concrete 4' I.D. DEPTH > 8', PER ADDITIONAL VF OVER 8'",105,"VF",null,{"v":0,"d":"$0.00"}]
["02510-C7-00220","Manhole-Precast Concrete 5' I.D. DEPTH  < 8'",2,"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-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)",7,"EA",null,{"v":0,"d":"$0.00"}]
["02510-C7-00260","Connect To Existing Sanitary Manhole",6,"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)",90,"LF",null,{"v":0,"d":"$0.00"}]
["02510-C7-SP255","Remove Existing Sanitary Manhole",17,"EA",null,{"$f":"IFERROR($C95*$E95, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUM(F81:F95)","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 F17.1 through F17.5",1,"LS",null,{"$f":"IFERROR($C100*$E100, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUM(F100)","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)",1260,"LF",null,{"$f":"IFERROR($C105*$E105, \"\")","v":{"v":0,"d":"$0.00"}}]
["14030-C9-00040","Furnish and Install 2 Inch Sch 40 PVC Conduit in Trench (Detail 14030-01)",5795,"LF",null,{"v":0,"d":"$0.00"}]
["14030-C9-00150","Remove Underground Conduit",300,"LF",null,{"v":0,"d":"$0.00"}]
["14040-C9-00180","Furnish and Install Junction Box and Lid LARGE (Detail 14040-02)",11,"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",7055,"LF",null,{"v":0,"d":"$0.00"}]
["14060-C9-00290","Install Streetlight Pole Foundation Type F-1 (Detail 14060-01)",36,"EA",null,{"v":0,"d":"$0.00"}]
["14060-C9-00310","Install Shallow Depth Foundation (Detail 14060-02)",20,"EA",null,{"v":0,"d":"$0.00"}]
["14060-C9-00350","Removal of Existing Foundation - up to 4' Deep",21,"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-00925","Direct-Buried Decorative Post-Top Aluminum Streetlight Pole with Clamshell Base and Double Post-Top Luminaires per Arlington Lighting Standards 14080-01, 14090-03, and 14110-01",38,"EA",null,{"v":0,"d":"$0.00"}]
["14050-C9-SP0080","Relocate Existing Streetlight Pole, Luminaire Arm and Light Fixture",18,"EA",null,{"$f":"IFERROR($C115*$E115, \"\")","v":{"v":0,"d":"$0.00"}}]
["14050-C9-SP090","Remove Roadway Light or Streetlight Pole",3,"EA",null,{"$f":"IFERROR($C116*$E116, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUM(F105:F116)","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",525,"LF",null,{"$f":"IFERROR($C121*$E121, \"\")","v":{"v":0,"d":"$0.00"}}]
["02900-C10-00050","Twenty Four (24) Inch Transverse Markings, Note: Used For Continental (Ladder) Crosswalk",2350,"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",80,"LF",null,{"v":0,"d":"$0.00"}]
["02900-C10-00070","Four (4) Inch Longitudinal Solid Line",4265,"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",4865,"LF",null,{"v":0,"d":"$0.00"}]
["02900-C10-00120","Six (6) Inch Longitudinal Solid Line",1000,"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",670,"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",1485,"LF",null,{"v":0,"d":"$0.00"}]
["02900-C10-00240","Single Arrows",20,"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-00350","Colorized Bike Lane Coatings (per Specification 02900)",35,"SY",null,{"v":0,"d":"$0.00"}]
["02619-C10-00410","Traffic Control Sign (Typical Stop, Yield, No Parking, Speed Limit, or Similar)",36,"EA",null,{"v":0,"d":"$0.00"}]
["02619-C10-00420","Traffic Control Sign (Typical Stop, Yield, No Parking, Speed Limit, or Similar), Relocate with Existing Post",12,"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",1,"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"]
["329100-C11-00020","Planting Soil Mixture / Backfill Soil Mixture of 3/4 Existing Soil and 1/4 Organic Material (per Arlington County DPR Specification)",1145,"CY",null,{"$f":"IFERROR($C139*$E139, \"\")","v":{"v":0,"d":"$0.00"}}]
["329100-C11-00030","Topsoil for Street Trees, Purchased Mixture (per Arlington County DPR Specification)",650,"CY",null,{"v":0,"d":"$0.00"}]
["329100-C11-00040","Shredded hardwood mulch; Aged 6 months minimum - Free of Trash & Debris",325,"CY",null,{"v":0,"d":"$0.00"}]
["329200-C11-00050","Seed, Mixture of 85% Tall Fescue/Bluegrass and 15% Annual Rye",430,"SY",null,{"v":0,"d":"$0.00"}]
["329200C11-00060","Sod, Tall Fescue/Bluegrass Mixture",8215,"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)",{"$f":"153+122","v":275},"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)",65,"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)",19,"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)",5,"EA",null,{"v":0,"d":"$0.00"}]
["02100-C11-00504","Tree/Stump Removal - Class E. Remove and Dispose, over 30\" DBH to 36\" DBH (Diameter at Breast Height)",1,"EA",null,{"v":0,"d":"$0.00"}]
["02100-C11-00507","Tree/Stump Removal - Class H. Remove and Dispose, over 48\" DBH (Diameter at Breast Height)",1,"EA",null,{"v":0,"d":"$0.00"}]
["329300-C11-00600","Trees, Deciduous - 0.75 to 1.0\" caliper",16,"EA",null,{"v":0,"d":"$0.00"}]
["329300-C11-00601","Trees, Deciduous - 1.0 to 1.5\" caliper",11,"EA",null,{"v":0,"d":"$0.00"}]
["329300-C11-00603","Trees, Deciduous - 2.0 to 2.5\" caliper",17,"EA",null,{"v":0,"d":"$0.00"}]
["329300-C11-00605","Trees, Deciduous - 3.0 to 3.5\" caliper",97,"EA",null,{"v":0,"d":"$0.00"}]
["329300-C11-01010","Herbaceous Plant (Quart)",2337,"EA",null,{"v":0,"d":"$0.00"}]
["329300-C11-01020","Herbaceous Plant (#1 Container)",1121,"EA",null,{"v":0,"d":"$0.00"}]
["329300-C11-01110","Shurb (#5 Container)- Container or B&B",495,"EA",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",265,"LF",null,{"v":0,"d":"$0.00"}]
["05500-C11-SP162","Handrail HR-1 Type I (VDOT 25002)",100,"LF",null,{"v":0,"d":"$0.00"}]
["05500-C11-SP164","Handrail HR-1 Type II (VDOT 25003)",895,"LF",null,{"v":0,"d":"$0.00"}]
["04200-C11-SP090","Barcroft Apartments Monument Sign and Planter complete as per detail shown on Sheet F14.6.0",1,"LS",null,{"$f":"IFERROR($C160*$E160, \"\")","v":{"v":0,"d":"$0.00"}}]
["05500-C11-SP100","Metal Fence, Remove & Replace, Height Up to 6'",40,"LF",null,{"$f":"IFERROR($C161*$E161, \"\")","v":{"v":0,"d":"$0.00"}}]
["03100-C11-SP105","Retaining Wall - Concrete Gravity as per details shown Sheet F20.1",31380,"CF",null,{"$f":"IFERROR($C162*$E162, \"\")","v":{"v":0,"d":"$0.00"}}]
["05500-C11-SP110","H-Pile Wall, includes design, fabrication, delivery, installation and all materials, labor, tools, and incidentals necessary to complete the work.",2210,"SF",null,{"$f":"IFERROR($C163*$E163, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUM(F139:F163)","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)",630,"SY",null,{"$f":"IFERROR($C168*$E168, \"\")","v":{"v":0,"d":"$0.00"}}]
["13130-C12-00150","Install Traditional/Contemporary Bicycle Rack",12,"EA",null,{"v":0,"d":"$0.00"}]
["13130-C12-00101","Install 8' Free-standing Bench",5,"EA",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUM(F168:F170)","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":"IFERROR($C175*$E175, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUM(F175)","v":{"v":0,"d":"$0.00"}}]
[]
["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"]
["01000-C16-00010","Maintenance of Traffic (MOT)",1,"LS",null,{"$f":"IFERROR($C184*$E184, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":3},{"$f":"SUBTOTAL(103,[1]Unit_Price_Tab!$D$185:$D$185)","v":1},"SUBTOTAL",{"$f":"SUM(F184)","v":{"v":0,"d":"$0.00"}}]
[]
["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",390,"LF",null,{"$f":"IFERROR($C193*$E193, \"\")","v":{"v":0,"d":"$0.00"}}]
["02580-C18-DO130","2-4\" Duct Standard Duct Bank (2W X 1H) All Depths",300,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-DO150","4-4\" Duct Standard Duct Bank (2W X 2H) All Depths",10,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-DO200","2-6\" Duct Standard Duct Back (2W X 1H) All Depths",170,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-DO220","2-8\" Duct Standard Duct Bank (2W X 1H) All Depths",1060,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-DO230","4-8\" Duct Standard Duct Bank (2W X 2H) All Depths",1600,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-DO240","6-8\" Duct Standard Duct Bank (2W X 2H) All Depths",385,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-DO250","8-8\" Duct Standard Duct Bank (2W X 2H) All Depths",150,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-DO260","16'x8'x8' Electric Vault w/frame and cover. Dom. Energy to provide manhole frame and cover.",7,"EA",null,{"v":0,"d":"$0.00"}]
["02580-C18-DO300","Internal/External Secondary Service Connections - includes all labor, materials, coordination for all secondary service connections",1,"EA",null,{"v":0,"d":"$0.00"}]
["02580-C18-DO500","1-4\" Conduit (Direct Bury) All Depths",60,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-D505","1-4\" & 2-6\" & 6-8\" Duct Standard Duct Bank (1W X 1H & 2W X 1H & 2W X 3H) All Depths",25,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-D510","1-4\" & 2-8\" Duct Standard Duct Bank (1W X 1H & 2W X 1H) All Depths",20,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-D515","1-4\" & 4-8\" Duct Standard Duct Bank (1W X 1H & 2W X 2H) All Depths",215,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-D520","1-4\" & 6-8\" Duct Standard Duct Bank (1W X 1H & 2W X 3H) All Depths",35,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-D525","1-4\" & 8-8\" Duct Standard Duct Bank (1W X 1H & 2W X 4H) All Depths",20,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-D530","2-2\" & 2-8\" Duct Standard Duct Bank (2W X 1H & 2W X 1H) All Depths",50,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-D535","2-2\" & 6-8\" Duct Standard Duct Bank (2W X 1H & 2W X 3H) All Depths",25,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-D540","2-4\" & 2-6\" Duct Standard Duct Bank (2W X 1H & 2W X 1H) All Depths",105,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-D545","2-4\" & 4-8\" Duct Standard Duct Bank (2W X 1H & 2W X 2H) All Depths",185,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-D550","2-6\" & 2-8\" Duct Standard Duct Bank (2W X 1H & 2W X 1H) All Depths",95,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-D555","2-6\" & 4-8\" Duct Standard Duct Bank (2W X 1H & 2W X 2H) All Depths",265,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-D560","2-6\" & 6-8\" Duct Standard Duct Bank (2W X 1H & 2W X 3H) All Depths",250,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-D565","2-6\" & 8-8\" Duct Standard Duct Bank (2W X 1H & 2W X 4H) All Depths",25,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-D570","4-6\" & 4-8\" Duct Standard Duct Bank (2W X 2H & 2W X 2H) All Depths",15,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-D575","4-6\" & 6-8\" Duct Standard Duct Bank (2W X 2H & 2W X 2H) All Depths",85,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-D580","Furnish and Install Meter Base, Meter Pedestal, and Disconnect Switch",6,"EA",null,{"v":0,"d":"$0.00"}]
["02580-C18-D585","Instal Secondary Pedestal (Provided by DEV) (31\"X31\")",1,"EA",null,{"$f":"IFERROR($C220*$E220, \"\")","v":{"v":0,"d":"$0.00"}}]
["02580-C18-D590","Install Splice Box ((Provided by DEV) 78\"X48\")",2,"EA",null,{"$f":"IFERROR($C221*$E221, \"\")","v":{"v":0,"d":"$0.00"}}]
["02580-C18-D595","Manhole (6'x12'x7') DEV will provide manhole frame and covers.",2,"EA",null,{"$f":"IFERROR($C222*$E222, \"\")","v":{"v":0,"d":"$0.00"}}]
["02580-C18-D597","Manhole (8'x16'x8') DEV will provide manhole frame and covers.",7,"EA",null,{"$f":"IFERROR($C223*$E223, \"\")","v":{"v":0,"d":"$0.00"}}]
["02580-C18-D599","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.",1,"EA",null,{"v":0,"d":"$0.00"}]
["02580-C18-VE130","2-4\" Duct Standard Duct Bank (2W X 1H) All Depths",1940,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-VE140","4-4\" Duct Standard Duct Bank (2W X 2H) All Depths",1130,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-VE150","6-4\" Duct Standard Duct Bank (2W X 2H) All Depths",115,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-VE170","Ifurnish and Install New Quazite Handholes (24\"x36.\") and Adjust to Proposed Grade",4,"EA",null,{"v":0,"d":"$0.00"}]
["02580-C18-VE500","1-4\" Conduit (Direct Bury) All Depths",60,"LF",null,{"$f":"IFERROR($C229*$E229, \"\")","v":{"v":0,"d":"$0.00"}}]
["02580-C18-VE510","2-4\" Conduit (Directional Drill) All Depths",210,null,null,{"$f":"IFERROR($C230*$E230, \"\")","v":{"v":0,"d":"$0.00"}}]
["02580-C18-VE520","8-4\" Duct Standard Duct Bank (2W X 4H) All Depths",190,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-VE530","Manhole (6'x12'x7') Type J Including Frame and Cover. ",1,"EA",null,{"v":0,"d":"$0.00"}]
["02580-C18-CO130","2-4\" Duct Standard Duct Bank (2W x 1H)All Depths",1680,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-CO140","4-4\" Duct Standard Duct Bank (2W x 2H) All Depths",210,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-CO150","6-4\" Duct Standard Duct Bank (2W x 3H) All Depths",60,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-CO160","Install Comcast Comcast Vault (62.5\" x 40\") (Vault Provided by Comcast)",14,"EA",null,{"v":0,"d":"$0.00"}]
["02580-C18-CO170","Install Comcast Handhole (Handhole Provided by Comcast)",2,"EA",null,{"v":0,"d":"$0.00"}]
["02580-C18-CO180","Install Comcast Pedestal (Pedestal Provided by Comcast)",2,"EA",null,{"v":0,"d":"$0.00"}]
["02580-C18-CO500","2 - 4\" Conduits (Direct Bury) All Depths",1575,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-CO510","3 - 4\" Conduits (Direct Bury) All Depths",120,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-CO520","8 - 4\" Conduits (Direct Bury) All Depths",10,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-CO530","Install Comcast Power Supply Cabinet (1' X 2.5') (Cabinet Provided by Comcast)",1,"EA",null,{"v":0,"d":"$0.00"}]
["02580-C18-FO500","4-2\" Duct Standard Duct Bank (2W X 2H) All Depths",105,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-FO510","2-2\" Conduits  From Pole to New Junction Box",30,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-FO520","Install Junction Box Type 3",1,"EA",null,{"v":0,"d":"$0.00"}]
["02580-C18-SP010","1-2\" Elec. Conduit All Depths",750,"LF",null,{"v":0,"d":"$0.00"}]
["02581-C18-SP020","1-2\" Comm. Conduit All Depths",810,"LF",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUM(F193:F247)","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","%",null,{"$f":"+E255*F251","v":{"v":0,"d":"$0.00"}}]
["01500-SA-00200","SWPPP Administration","NA","%",null,{"$f":"+E256*F251","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"PERCENTAGE LINE ITEMS SUBTOTAL",{"$f":"SUM(F255:F256)","v":{"v":0,"d":"$0.00"}}]
[]
[]
[]
[{"$nulls":4},"SEGMENT F TOTAL :",{"$f":"$F$257+F251","v":{"v":0,"d":"$0.00"}}]

{"sheet":"Segment A","index":2,"n_rows":217,"n_cols":6,"rows_kept":217,"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)",1835,"CY",null,{"$f":"IFERROR($C6*$E6, \"\")","v":{"v":0,"d":"$0.00"}}]
["02200-C1-00130","Aggregate, VDOT #21-A  (Compacted in Place per VDOT standards & Specs)",205,"CY",null,{"v":0,"d":"$0.00"}]
["02200-C1-00140","Aggregate, VDOT #21-B  (Compacted in Place per VDOT standards & Specs)",1985,"CY",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUM(F6:F8)","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.",840,"LF",null,{"$f":"IFERROR($C13*$E13, \"\")","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.",2300,"LF",null,{"v":0,"d":"$0.00"}]
["02750-C2-00085","Concrete Curb, C-5 Alternate Curb for Medians (Arlington County Detail R-2.0)",445,"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)",45,"SY",null,{"v":0,"d":"$0.00"}]
["02611-C2-00110","Concrete Sidewalk, 4\" Thickness (Arlington County Detail R-2.0)",425,"SY",null,{"v":0,"d":"$0.00"}]
["02611-C2-00190","CG-12 Detectable Warning Surface - Truncated Domes",75,"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)",675,"SY",null,{"v":0,"d":"$0.00"}]
["03100-C2-00230","Concrete and Formwork (VDOT Class A3), only when not included in other pay items",20,"CY",null,{"v":0,"d":"$0.00"}]
["03100-C2-SPXXXX","Concrete Bus Pad as per detail Inset C shown on Sheet F3.1. \nConcrete Surface A-3 Concrete with Welded Wire 6\"x6\" W2.9xW2.9.",90,null,null,{"$f":"IFERROR($C21*$E21, \"\")","v":{"v":0,"d":"$0.00"}}]
["02750-C2-SP065","Concrete Curb & Gutter, Standard C-4 (Arlington County Detail R-2.0)",210,"LF",null,{"$f":"IFERROR($C22*$E22, \"\")","v":{"v":0,"d":"$0.00"}}]
["02750-C2-SP120","Concrete Sidewalk as per details shown on sheets A14.4 & A14.5 including but not limited to brick bands, steel edgings, dowels all complete",1395,null,null,{"$f":"IFERROR($C23*$E23, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUM(F13:F23)","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)",895,"SY",null,{"$f":"IFERROR($C28*$E28, \"\")","v":{"v":0,"d":"$0.00"}}]
["02600-C3-00030","Asphalt Concrete, Base Course (VDOT BM-25.0A)",445,"TON",null,{"v":0,"d":"$0.00"}]
["02600-C3-00160","Asphalt Concrete, Base Course (VDOT BM-25.0D)",1985,"TON",null,{"v":0,"d":"$0.00"}]
["02600-C3-00050","Asphalt Concrete, Intermediate Course (VDOT IM-19.0D)",1325,"TON",null,{"v":0,"d":"$0.00"}]
["02600-C3-00060","Asphalt Concrete, Surface Course (VDOT SM-9.5A)",110,"TON",null,{"v":0,"d":"$0.00"}]
["02600-C3-00070","Asphalt Concrete, Surface Course (VDOT SM-9.5D)",770,"TON",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUM(F28:F33)","v":{"v":0,"d":"$0.00"}}]
[]
["C4","STORM SEWER UTILITY WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["02500-C4-00820","15\" Pipe, RCP Class IV, In Place Up to 6' Deep",400,"LF",null,{"$f":"IFERROR($C38*$E38, \"\")","v":{"v":0,"d":"$0.00"}}]
["02500-C4-00880","21\" Pipe, RCP Class IV, In Place Up to 6' Deep",85,"LF",null,{"v":0,"d":"$0.00"}]
["02500-C4-00940","30\" Pipe, RCP Class IV, In Place Up to 6' Deep",60,"LF",null,{"v":0,"d":"$0.00"}]
["02500-C4-01120","23\" x 14\" Elliptical Pipe (18\" Equivalent), RCP Class III, In Place 6' to 10' Deep",45,"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)",125,"LF",null,{"v":0,"d":"$0.00"}]
["02505-C4-00010","Storm Manhole MH-1 (Arlington County Detail D-3.0), In Place, DEPTH   8'",12,"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.",13,"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",1,"EA",null,{"v":0,"d":"$0.00"}]
["02500-C4-00460","Storm Manhole Frame and Cover, Remove & Replace",2,"EA",null,{"v":0,"d":"$0.00"}]
["02505-C4-00600","Storm Manhole, Catch Basin, Drop Inlet, Yard Inlet, or Grate Inlet, Remove",12,"EA",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUM(F38:F47)","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-00180","Connect To Existing 16-Inch Water Main",1,"EA",null,{"$f":"IFERROR($C56*$E56, \"\")","v":{"v":0,"d":"$0.00"}}]
["02550-C6-00190","Connect To Existing 12-Inch Water Main",2,"EA",null,{"v":0,"d":"$0.00"}]
["02550-C6-00200","Connect To Existing 8-Inch Water Main",1,"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-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-00240","2-Inch Blowoff Valve Assembly & Box",1,"EA",null,{"v":0,"d":"$0.00"}]
["02550-C6-00250","Remove Existing Fire Hydrant",3,"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",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-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.",1,"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.",4,"EA",null,{"v":0,"d":"$0.00"}]
["02550-C6-00010","16-Inch Water Main, DIP CL-52, Upto 6' Deep",615,"LF",null,{"v":0,"d":"$0.00"}]
["02550-C6-00020","16-Inch Water Main, DIP CL-52, > 6' Deep",430,"LF",null,{"v":0,"d":"$0.00"}]
["02550-C6-00030","12-Inch Water Main, DIP CL-52, Upto 6' Deep",120,"LF",null,{"v":0,"d":"$0.00"}]
["02550-C6-00040","12-Inch Water Main, DIP CL-52, > 6' Deep",35,"LF",null,{"v":0,"d":"$0.00"}]
["02550-C6-00050","8-Inch Water Main, DIP CL-52, Upto 6' Deep",20,"LF",null,{"v":0,"d":"$0.00"}]
["02550-C6-00060","8-Inch Water Main, DIP CL-52, > 6' Deep",120,"LF",null,{"v":0,"d":"$0.00"}]
["02550-C6-00070","6-Inch Water Main, DIP CL-53, Upto 6' Deep",175,"LF",null,{"v":0,"d":"$0.00"}]
["02550-C6-00080","6-Inch Water Main, DIP CL-52, > 6' Deep",70,"LF",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUM(F56:F75)","v":{"v":0,"d":"$0.00"}}]
[]
["C7","SANITARY SEWER WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["02510-C7-00020","Sanitary Sewer - 8\" PVC, SDR 35, 8’ ≤ DEPTH < 14’",615,"LF",null,{"$f":"IFERROR($C80*$E80, \"\")","v":{"v":0,"d":"$0.00"}}]
["02510-C7-00200","Manhole - Precast Concrete, 4' ID, DEPTH  < 8'",3,"EA",null,{"v":0,"d":"$0.00"}]
["02510-C7-00210","Manhole-Precast Concrete 4' I.D. DEPTH > 8', PER ADDITIONAL VF OVER 8'",10,"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)",1,"EA",null,{"v":0,"d":"$0.00"}]
["02510-C7-00260","Connect To Existing Sanitary Manhole and Reshaping Invert As Required",4,"EA",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUM(F80:F84)","v":{"v":0,"d":"$0.00"}}]
[]
["C8","TRAFFIC SIGNAL WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[{"$nulls":4},"SUBTOTAL"]
[]
["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)",295,"LF",null,{"$f":"IFERROR($C93*$E93, \"\")","v":{"v":0,"d":"$0.00"}}]
["14030-C9-00040","Furnish and Install 2 Inch Sch 40 PVC Conduit in Trench (Detail 14030-01)",1540,"LF",null,{"v":0,"d":"$0.00"}]
["14040-C9-00180","Furnish and Install Junction Box and Lid LARGE (Detail 14040-02)",3,"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",2200,"LF",null,{"v":0,"d":"$0.00"}]
["14060-C9-00290","Install Streetlight Pole Foundation Type F-1 (Detail 14060-01)",7,"EA",null,{"v":0,"d":"$0.00"}]
["14060-C9-00310","Install Shallow Depth Foundation (Detail 14060-02)",6,"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",13,"EA",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUM(F93:F100)","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",205,"LF",null,{"$f":"IFERROR($C105*$E105, \"\")","v":{"v":0,"d":"$0.00"}}]
["02900-C10-00050","Twenty Four (24) Inch Transverse Markings, Note: Used For Continental (Ladder) Crosswalk",610,"LF",null,{"v":0,"d":"$0.00"}]
["02900-C10-00070","Four (4) Inch Longitudinal Solid Line",1140,"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",1615,"LF",null,{"v":0,"d":"$0.00"}]
["02900-C10-00120","Six (6) Inch Longitudinal Solid Line",560,"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",620,"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",1015,"LF",null,{"v":0,"d":"$0.00"}]
["02900-C10-00240","Single Arrows",10,"EA",null,{"v":0,"d":"$0.00"}]
["02619-C10-00410","Traffic Control Sign (Typical Stop, Yield, No Parking, Speed Limit, or Similar)",13,"EA",null,{"v":0,"d":"$0.00"}]
["02619-C10-00420","Traffic Control Sign (Typical Stop, Yield, No Parking, Speed Limit, or Similar), Relocate with Existing Post",23,"EA",null,{"v":0,"d":"$0.00"}]
["02900-C10-00225","Twelve (12) Inch Yellow Gore Markings, Twenty (20) Foot Spacing @ 45 Degree",55,"LF",null,{"v":0,"d":"$0.00"}]
["02900-C10-SP230","Twelve (12) Inch White Gore Markings, Twenty (20) Foot Spacing @ 45 Degree",70,"LF",null,{"$f":"IFERROR($C116*$E116, \"\")","v":{"v":0,"d":"$0.00"}}]
["xxxxx-C10-SP500","Furnish and Install Dynamic Message Sign Assembly, Cabinet, Junction Boxes and Conduits",1,"LS",null,{"$f":"IFERROR($C117*$E117, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUM(F105:F117)","v":{"v":0,"d":"$0.00"}}]
[]
["C11","LANDSCAPE AND HARDSCAPE RESTORATION WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["02800-C11-00020","Planting SoilMixture / Backfill Soil Mixture of 3/4 Existing Soil and 1/4 Organic Material (per Arlington County DPR Specification)",275,"CY",null,{"$f":"IFERROR($C122*$E122, \"\")","v":{"v":0,"d":"$0.00"}}]
["02800-C11-00030","Topsoil for Street Trees, Purchased Mixture (per Arlington County DPR Specification)",200,"CY",null,{"v":0,"d":"$0.00"}]
["02801-C11-00040","Shredded hardwood mulch; Aged 6 months minimum - Free of Trash & Debris",200,"CY",null,{"v":0,"d":"$0.00"}]
["02801-C11-00050","Seed, Mixture of 85% Tall Fescue/Bluegrass and 15% Annual Rye",145,"SY",null,{"v":0,"d":"$0.00"}]
["02801-C11-00060","Sod, Tall Fescue/Bluegrass Mixture",2400,"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)",20,"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)",7,"EA",null,{"v":0,"d":"$0.00"}]
["02800-C11-00605","Trees, Deciduous - 3.0 to 3.5\" caliper",16,"EA",null,{"v":0,"d":"$0.00"}]
["02800-C11-00613","Trees, Evergreen - 10.0 to 12.0' in height",12,"EA",null,{"v":0,"d":"$0.00"}]
["02800-C11-01020","Herbaceous Plant (#1 Container)",313,"EA",null,{"v":0,"d":"$0.00"}]
["02800-C11-01090","Shrub (#2 Container)- Container or B&B",369,"EA",null,{"v":0,"d":"$0.00"}]
["02800-C11-00200","Chain Link Fence, Height Less Than or Equal to 6'",460,"LF",null,{"v":0,"d":"$0.00"}]
["02800-C11-00260","Fence and Posts (Any Size or Material), Remove & Dispose, only when not included in other pay items",265,"LF",null,{"v":0,"d":"$0.00"}]
["02800-C11-00370","Retaining Wall - Concrete Gravity (VDOT RW-3)",6150,"CF",null,{"v":0,"d":"$0.00"}]
["05500-C11-SP164","Handrail HR-1 Type II (VDOT 25003)",490,"LF",null,{"$f":"IFERROR($C136*$E136, \"\")","v":{"v":0,"d":"$0.00"}}]
["02800-C11-SP205","Furnish and Install 6' Tall Hinged Chain Link Gate",1,"EA",null,{"$f":"IFERROR($C137*$E137, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUM(F122:F137)","v":{"v":0,"d":"$0.00"}}]
[]
["C12","BUS STOP SHELTER AND FURNISHINGS"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["10530-C12-00010","Bus Shelter Pad (Detail R-2.10)",275,"SY",null,{"$f":"IFERROR($C142*$E142, \"\")","v":{"v":0,"d":"$0.00"}}]
["10530-C12-00150","Install Traditional/Contemporary Bicycle Rack",6,"EA",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUM(F142:F143)","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":"IFERROR($C148*$E148, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUM(F148)","v":{"v":0,"d":"$0.00"}}]
[]
["C15","UNLISTED WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE"]
[{"$nulls":4},"SUBTOTAL"]
[]
["C16","MOT AND RE-MOBILIZATION WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["01000-C16-00010","Maintenance of Traffic (MOT)",1,"LS",null,{"$f":"IFERROR($C157*$E157, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":3},{"$f":"SUBTOTAL(103,[4]Unit_Price_Tab!$D$157:$D$157)","v":1},"SUBTOTAL",{"$f":"SUM(F157)","v":{"v":0,"d":"$0.00"}}]
[]
["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",455,"LF",null,{"$f":"IFERROR($C166*$E166, \"\")","v":{"v":0,"d":"$0.00"}}]
["02580-C18-DO130","2-4\" Duct Standard Duct Bank (2W X 1H) All Depths",40,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-DO140","3-4\" Duct Standard Duct Bank (2W X 1H) All Depths",30,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-DO220","2-8\" Duct Standard Duct Back (2W X 1H) All Depths",560,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-DO230","4-8\" Duct Standard Duct Back (2W X 2H) All Depths",525,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-DO240","6-8\" Duct Standard Duct Back (2W X 3H) All Depths",175,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-DO260","16'x8'x8' Electric Vault w/frame and cover. Dominion Energy to provide manhole frame and cover.",2,"EA",null,{"v":0,"d":"$0.00"}]
["02580-C18-DO300","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-D510","1 - 4\" & 2 - 8\" DUCT STANDARD DUCTBANK (1W X 1H & 2W X 1H) ALL DEPTHS",10,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-D546","3 - 4\" & 2 - 8\" DUCT STANDARD DUCTBANK (3W X 1H & 2W X 1H) ALL DEPTHS",10,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-D515","1 - 4\" & 4 - 8” DUCT STANDARD DUCTBANK (1W X 1H & 2W X 2H) ALL DEPTHS",260,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-D545","2 - 4\" & 4 - 8” DUCT STANDARD DUCTBANK (2W X 1H & 2W X 2H) ALL DEPTHS",75,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-D566","3 - 4\" & 4 - 8” DUCT STANDARD DUCTBANK (3W X 1H & 2W X 2H) ALL DEPTHS",90,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-D520","1 - 4\" & 6 - 8\" DUCT STANDARD DUCTBANK (1W X 1H & 2W X 3H) ALL DEPTHS",25,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-D525","1 - 4\" & 8 - 8\" DUCT STANDARD DUCTBANK (1W X 1H & 2W X 4H) ALL DEPTHS",30,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-D595","6' x 12' x 7' Electric Vault w/Frame and Cover. Dominion Energy to Provide Frame and Cover",1,"EA",null,{"$f":"IFERROR($C181*$E181, \"\")","v":{"v":0,"d":"$0.00"}}]
["02580-C18-D580","Furnish and Install Meter Base, Meter Pedestal, and Disconnect Switch",3,"EA",null,{"$f":"IFERROR($C182*$E182, \"\")","v":{"v":0,"d":"$0.00"}}]
["02580-C18-VE130","2-4\" Duct Standard Duct Bank (2W X 1H) All Depths",1200,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-VE140","4-4\" Duct Standard Duct Bank (2W X 2H) All Depths",70,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-VE170","Furnish and Install New Verizon Quazite Handholes and Adjust to Proposed Grade",3,"EA",null,{"v":0,"d":"$0.00"}]
["02580-C18-VE180","Install Pedestal (Provided by Verizon) and Adjust to Proposed Grade",1,"EA",null,{"v":0,"d":"$0.00"}]
["02580-C18-VE525","9 – 4” Duct Standard Duct Bank (3W X 3H) All depths",390,"LF",null,{"$f":"IFERROR($C187*$E187, \"\")","v":{"v":0,"d":"$0.00"}}]
["02580-C18-VE530","Manhole (6' x 12' x 7') Type J Including Frame and Cover",1,"EA",null,{"$f":"IFERROR($C188*$E188, \"\")","v":{"v":0,"d":"$0.00"}}]
["02580-C18-CO130","2-4\" Duct Standard Duct Bank (2W X 1H) All Depths",780,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-CO140","4-4\" Duct Standard Duct Bank (2W X 2H) All Depths",215,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-CO150","6-4\" Duct Standard Duct Bank (2W X 3H) All Depths",30,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-CO160","Install Comcast Vault (62.5\" x 40\") (Vault Provided by Comcast)",3,"EA",null,{"v":0,"d":"$0.00"}]
["02580-C18-CO170","Install Comcast Handhole (Handhole Provided by Comcast)",3,"EA",null,{"v":0,"d":"$0.00"}]
["02580-C18-CO180","Install Comcast Pedestal (24\"x42\") (Pedestal provided by Comcast)",1,"EA",null,{"v":0,"d":"$0.00"}]
["02580-C18-CO500","2 - 4\" CONDUITS (Direct Bury) All Depths",460,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-CO512","4 - 4\" CONDUITS (Direct Bury) All Depths",150,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-CO515","6 – 4” CONDUITS (Direct Bury) All Depths",25,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-CO520","8 – 4” CONDUITS (Direct Bury) All Depths",15,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-CO525","12 – 4” CONDUITS (Direct Bury) All Depths",10,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-FO500","4 – 2” DUCT STANDARD DUCT BANK (4W X 1H) ALL DEPTH",80,"LF",null,{"v":0,"d":"$0.00"}]
["02580-C18-FO530","Install Junction Box Type 3",1,"EA",null,{"v":0,"d":"$0.00"}]
["02580-C18-SP010","1-2\" Elec. Conduit All Depths",250,"LF",null,{"$f":"IFERROR($C202*$E202, \"\")","v":{"v":0,"d":"$0.00"}}]
["02580-C18-SP020","1-2\" Comm. Conduit All Depths",205,"LF",null,{"$f":"IFERROR($C203*$E203, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUM(F166: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"]
["01000-C16-00030","Mobilization and De-Mobilization","NA","%",null,{"$f":"+E211*F207","v":{"v":0,"d":"$0.00"}}]
["01500-SA-00200","SWPPP Administration","NA","%",null,{"$f":"+E212*F207","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"PERCENTAGE LINE ITEMS SUBTOTAL",{"$f":"SUM(F211:F212)","v":{"v":0,"d":"$0.00"}}]
[]
[]
[]
[{"$nulls":4},"SEGMENT A TOTAL :",{"$f":"$F$213+F207","v":{"v":0,"d":"$0.00"}}]