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

{"sheet":"Unit_Price_Tab","index":0,"n_rows":118,"n_cols":7,"rows_kept":118,"merged":[[1,1,1,6]]}
[null,"22- DES-ITB-316 Bid/Price Sheet",null,null,"PREPARED BY:"]
[null,"THE UNDERSIGNED CERTIFIES THAT (CONTRACTOR NAME)___________________________\nIS CURRENTLY REGISTERED WITH THE VIRGINIA STATE BOARD OF CONTRACTORS AS REQUIRED BY THE CODE OF VIRGINIA.  CERTIFICATE NUMBER _________________ WAS ISSUED ON THE ________DAY OF _____________, 20XX.  THE UNDERSIGNED FURTHER CERTIFIES THAT THE REGISTRATION FEE AND ALL RENEWAL FEES REQUIRED UNDER LAW HAVE BEEN PAID.  THE CONTRACTOR AGREES TO FURNISH ALL NECESSARY LABOR, EQUIPMENT, MATERIALS, AND ALL THINGS NECESSARY TO PERFORM THE WORK AS SET FORTH IN ACCORDANCE WITH THE PLANS AND SPECIFICATIONS. THE CONTRACTOR AGREES TO PERFORM RELATED WORK FOR THE FOLLOWING ITEMS AT THE FOLLOWING STIPULATED PRICES: (ALL PRICES INCLUDE PROVISION AND INSTALLATION)."]
[{"$nulls":4},"CHECKED BY:"]
[]
[null,"MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT PRICE","TOTAL"]
[null,"C1",{"$f":"VLOOKUP(B6,[4]!Table_BidItem_CategoryClassification[#All],2,FALSE)","v":{"$error":"#REF!"}}]
[null,"MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT PRICE","TOTAL"]
[1,"02200-C1-00050","Select Borrow (VDOT Section 207 - Select Material, Type I)",null,"CY",null,{"$f":"IFERROR($D8*$F8, \"\")","v":{"v":0,"d":"$0.00"}}]
[2,"02200-C1-00130","Aggregate, VDOT #21-A  (Compacted in Place per VDOT standards & Specs)",null,"CY",null,{"v":0,"d":"$0.00"}]
[{"$nulls":5},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$G$8:$G$9)","v":{"v":0,"d":"$0.00"}}]
[]
[null,"C2",{"$f":"VLOOKUP(B12,[4]!Table_BidItem_CategoryClassification[#All],2,FALSE)","v":{"$error":"#REF!"}}]
[null,"MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT PRICE","TOTAL"]
[3,"02750-C2-00020","Concrete Curb, Standard Header Curb C-3 (Arlington County Detail R-2.0), includes curb for aprons, ramps, etc.",null,"LF",null,{"$f":"IFERROR($D14*$F14, \"\")","v":{"v":0,"d":"$0.00"}}]
[4,"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.",null,"LF",null,{"v":0,"d":"$0.00"}]
[5,"02611-C2-00110","Concrete Sidewalk, 4\" Thickness (Arlington County Detail R-2.0)",null,"SY",null,{"v":0,"d":"$0.00"}]
[6,"02611-C2-00180","Concrete Driveway Entrance, 9\" Thick Commercial (Arlington County Details R-2.4A, R-2.4B, R-2.4C, R-2.4D)",null,"SY",null,{"v":0,"d":"$0.00"}]
[{"$nulls":5},"SUBTOTAL",{"$f":"SUM(G14,G15,G16,G17)","v":{"v":0,"d":"$0.00"}}]
[]
[null,"C3",{"$f":"VLOOKUP(B20,[4]!Table_BidItem_CategoryClassification[#All],2,FALSE)","v":{"$error":"#REF!"}}]
[null,"MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[7,"02600-C3-00030","Asphalt Concrete, Base Course (VDOT BM-25.0A)",null,"TON",null,{"$f":"IFERROR($D22*$F22, \"\")","v":{"v":0,"d":"$0.00"}}]
[8,"02600-C3-00060","Asphalt Concrete, Surface Course (VDOT SM-9.5A)",null,"TON",null,{"v":0,"d":"$0.00"}]
[9,"02200-C1-00130","Aggregate, VDOT #21-A  (Compacted in Place per VDOT standards & Specs)",null,"CY",null,{"v":0,"d":"$0.00"}]
[{"$nulls":5},"SUBTOTAL",{"$f":"SUM(G22,G24,G23,)","v":{"v":0,"d":"$0.00"}}]
[]
[null,"C4",{"$f":"VLOOKUP(B27,[4]!Table_BidItem_CategoryClassification[#All],2,FALSE)","v":{"$error":"#REF!"}}]
[null,"MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[10,"02500-C4-00620","15\" Pipe, RCP Class III, In Place Up to 6' Deep",null,"LF",null,{"$f":"IFERROR($D29*$F29, \"\")","v":{"v":0,"d":"$0.00"}}]
[11,"02505-C4-00630","15\" Pipe, RCP Class III, In Place 6' to 8' Deep",null,"LF",null,{"v":0,"d":"$0.00"}]
[12,"02500-C4-00640","18\" Pipe, RCP Class III, In Place Up to 6' Deep",null,"LF",null,{"v":0,"d":"$0.00"}]
[13,"02550-C4-01306","8\" Pipe, DIP (Class 52), In Place Up to 6' Deep",null,"LF",null,{"v":0,"d":"$0.00"}]
[14,"02505-C4-00010","Storm Manhole MH-1 (Arlington County Detail D-3.0), In Place, DEPTH   8'",null,"EA",null,{"$f":"IFERROR($D33*$F33, \"\")","v":{"v":0,"d":"$0.00"}}]
[15,"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.",null,"EA",null,{"$f":"IFERROR($D34*$F34, \"\")","v":{"v":0,"d":"$0.00"}}]
[16,"02505-C4-00420","Standard Ditch Drop Inlet, VDOT DI-5 (12\" to 42\" Pipe), All Depths",null,"EA",null,{"v":0,"d":"$0.00"}]
[17,"02505-C4-00425","Grate Inlet, Standard VDOT DI-7 (12\" to 42\" Pipe), All Depths",null,"EA",null,{"v":0,"d":"$0.00"}]
[18,"02505-C4-00380","Yard Inlet (Arlington County Detail D-1.10), In Place Up to 6' Deep",null,"EA",null,{"v":0,"d":"$0.00"}]
[19,"02505-C4-00450","Grate Inlet Driveway (Arlington County Detail D-1.12)",null,"LF",null,{"$f":"IFERROR($D38*$F38, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":5},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$G$29:$G$38)","v":{"v":0,"d":"$0.00"}}]
[]
[null,"C5",{"$f":"VLOOKUP(B41,[3]!Table_BidItem_CategoryClassification[#All],2,FALSE)","v":{"$error":"#REF!"}}]
[null,"MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[]
[null,"C6",{"$f":"VLOOKUP(B44,[3]!Table_BidItem_CategoryClassification[#All],2,FALSE)","v":{"$error":"#REF!"}}]
[null,"MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[]
[null,"C7",{"$f":"VLOOKUP(B47,[3]!Table_BidItem_CategoryClassification[#All],2,FALSE)","v":{"$error":"#REF!"}}]
[null,"MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[]
[null,"C8",{"$f":"VLOOKUP(B50,[3]!Table_BidItem_CategoryClassification[#All],2,FALSE)","v":{"$error":"#REF!"}}]
[null,"MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[]
[null,"C9","PARKING AREA LIGHTING WORK"]
[null,"MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[20,"14030-C9-00010","Furnish and Install 2 inch Steel Riser on Wooden Poles",null,"LF",null,{"$f":"IFERROR($D55*$F55, \"\")","v":{"v":0,"d":"$0.00"}}]
[21,"14030-C9-00040","Furnish and Install 2 Inch Sch 40 PVC Conduit in Trench (Detail 14030-01)",null,"LF",null,{"v":0,"d":"$0.00"}]
[22,"14040-C9-00170","Furnish and Install Junction Box and Lid SMALL (Detail 14040-01)",null,"EA",null,{"v":0,"d":"$0.00"}]
[23,"14112-C9-00930","Round Tapered Composite Roadway Light Pole on Foundation with Single Cobra Head Luminaire per Arlington Lighting Standard 14160-03",null,"EA",null,{"v":0,"d":"$0.00"}]
[24,"14100-C9-00630","Furnish and Install Meter Pan, Pedestal, Control Box and Components (Detail 14100-01)",null,"EA",null,{"$f":"IFERROR($D59*$F59, \"\")","v":{"v":0,"d":"$0.00"}}]
[25,"14050-C9-00260","Furnish & Install #6 THHN Copper Cable ",null,"LF",null,{"$f":"IFERROR($D60*$F60, \"\")","v":{"v":0,"d":"$0.00"}}]
[26,"14080-C9-00490","On-Foundation Roadway Light or Streetlight Pole Removal",null,"EA",null,{"$f":"IFERROR($D61*$F61, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":5},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$G$55:$G$61)","v":{"v":0,"d":"$0.00"}}]
[]
[null,"C10","PAVEMENT MARKING AND SIGNAGE WORK"]
[null,"MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[27,"02900-C10-00010","Four (4) Inch Transverse Markings",null,"LF",null,{"$f":"IFERROR($D66*$F66, \"\")","v":{"v":0,"d":"$0.00"}}]
[28,"02900-C10-00250","Combination Arrows",null,"EA",null,{"v":0,"d":"$0.00"}]
[29,"02900-C10-00340","Handicap Symbol (Off-Street)",null,"EA",null,{"v":0,"d":"$0.00"}]
[30,"02900-C10-00410","Traffic Control Sign (Typical Stop, Yield, No Parking, Speed Limit, or Similar), Install per Detail SG-1.0",null,"EA",null,{"v":0,"d":"$0.00"}]
[{"$nulls":5},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$G$66:$G$69)","v":{"v":0,"d":"$0.00"}}]
[]
[null,"C11",{"$f":"VLOOKUP(B72,[4]!Table_BidItem_CategoryClassification[#All],2,FALSE)","v":{"$error":"#REF!"}}]
[null,"MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[31,"02800-C11-00200","6' Chainlink Fence",null,"LF",null,{"$f":"IFERROR($D74*$F74, \"\")","v":{"v":0,"d":"$0.00"}}]
[32,null,"Landscape and Planting Work (Estimate Prepared by Landscape Architect - Tree protection, Arborist,Sod, Trees, Shrubs, mulch)",null,"LS",null,{"$f":"IFERROR($D75*$F75, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":5},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$G$74:$G$75)","v":{"v":0,"d":"$0.00"}}]
[]
[null,"C12",{"$f":"VLOOKUP(B78,[3]!Table_BidItem_CategoryClassification[#All],2,FALSE)","v":{"$error":"#REF!"}}]
[null,"MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[]
[null,"C13",{"$f":"VLOOKUP(B81,[4]!Table_BidItem_CategoryClassification[#All],2,FALSE)","v":{"$error":"#REF!"}}]
[null,"MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[33,"01500-C13-00010","Erosion and Sediment Control  as shown on plan sheets C031.1, C031.2, C031.3, C032.1,C032.2, C032.3 and Specification Section 01500.",null,"LS",null,{"$f":"IFERROR($D83*$F83, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":5},"SUBTOTAL",{"$f":"G83","v":{"v":0,"d":"$0.00"}}]
[]
[null,"C15",{"$f":"VLOOKUP(B86,[4]!Table_BidItem_CategoryClassification[#All],2,FALSE)","v":{"$error":"#REF!"}}]
[null,"MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[34,"02800-C11-00500","Tree/Stump Removal - Class A. Remove and Dispose, Up to 6\" DBH to 12\" DBH (Diameter at Breast Height)",null,"EA",null,{"$f":"Unit_Price_Tab!$D88*Unit_Price_Tab!$F88","v":{"v":0,"d":"$0.00"}}]
[35,"02800-C11-00501","12\" TO 18\" Tree and stump removal",null,"EA",null,{"$f":"Unit_Price_Tab!$D89*Unit_Price_Tab!$F89","v":{"v":0,"d":"$0.00"}}]
[36,"02800-C11-00502","18\" TO 24\" Tree and stump remvoal",null,"EA",null,{"$f":"Unit_Price_Tab!$D90*Unit_Price_Tab!$F90","v":{"v":0,"d":"$0.00"}}]
[37,"C11-SP002","Traffic Barrier Concrete Service",null,"LF",null,{"$f":"Unit_Price_Tab!$D91*Unit_Price_Tab!$F91","v":{"v":0,"d":"$0.00"}}]
[38,"C11-SP003","Decorative Iron Fencing",null,"LF",null,{"$f":"IFERROR($D92*$F92, \"\")","v":{"v":0,"d":"$0.00"}}]
[39,"C11-SP004","Electric Gate",null,"EA",null,{"$f":"IFERROR($D93*$F93, \"\")","v":{"v":0,"d":"$0.00"}}]
[40,"C11-SP005","6' Long Concrete Wheel Stops",null,"EA",null,{"$f":"Unit_Price_Tab!$D94*Unit_Price_Tab!$F94","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":5},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$G$88:$G$94)","v":{"v":0,"d":"$0.00"}}]
[]
[null,"C16",{"$f":"VLOOKUP(B97,[3]!Table_BidItem_CategoryClassification[#All],2,FALSE)","v":{"$error":"#REF!"}}]
[null,"MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[]
[null,"C17",{"$f":"VLOOKUP(B100,[4]!Table_BidItem_CategoryClassification[#All],2,FALSE)","v":{"$error":"#REF!"}}]
[null,"MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[41,"02800-C11-00101","Permeable Unit Pavers installed (Supplemental Spec 02780)",null,"SY",null,{"$f":"IFERROR($D102*$F102, \"\")","v":{"v":0,"d":"$0.00"}}]
[42,"ACWM-C17-SP001","Manufactured Stormwater Treatment Device",null,"EA ",null,{"$f":"IFERROR($D103*$F103, \"\")","v":{"v":0,"d":"$0.00"}}]
[43,"ACSWM-C17-00300","PVC Cleanout with Cap",null,"EA ",null,{"$f":"IFERROR($D104*$F104, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":5},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$G$102:$G$104)","v":{"v":0,"d":"$0.00"}}]
[]
[{"$nulls":5}," CONTRACT TOTAL (EXCLUDING PERCENTAGE ITEMS)",{"$f":"SUM(Unit_Price_Tab!$G$10,Unit_Price_Tab!$G$18,Unit_Price_Tab!$G$25,Unit_Price_Tab!$G$39,Unit_Price_Tab!$G$62,Unit_Price_Tab!$G$70,Unit_Price_Tab!$G$76,Unit_Price_Tab!$G$84,Unit_Price_Tab!$G$95,Unit_Price_Tab!$G$105)","v":{"v":0,"d":"$0.00"}}]
[]
[null,"PCT",{"$f":"VLOOKUP(B109,[4]!Table_BidItem_CategoryClassification[#All],2,FALSE)","v":{"$error":"#REF!"}}]
[null,"MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[44,"01000-C16-00010","Maintenance of Traffic (MOT)",null,"%",null,{"$f":"Unit_Price_Tab!$F111*$G$107","v":{"v":0,"d":"$0.00"}}]
[45,"01000-C16-00030","Mobilization and De-Mobilization",null,"%",null,{"$f":"Unit_Price_Tab!$F112*$G$107","v":{"v":0,"d":"$0.00"}}]
[46,"01500-SA-00200","SWPPP Administration",null,"%",null,{"$f":"Unit_Price_Tab!$F113*$G$107","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":5},"PERCENTAGE LINE ITEMS SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$G$111:$G$113)","v":{"v":0,"d":"$0.00"}}]
[]
[]
[]
[{"$nulls":5},"PRIMARY CONTRACT :",{"$f":"$G$114+G107","v":{"v":0,"d":"$0.00"}}]