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

{"sheet":"Unit_Price_Tab","index":0,"n_rows":151,"n_cols":9,"rows_kept":151,"merged":[[1,0,1,5]]}
[{"$nulls":3},"PREPARED BY:"]
["THE UNDERSIGNED CERTIFIES THAT (CONTRACTOR NAME)___________________________\nIS CURRENTLY REGISTERED WITH THE VIRGINIA STATE BOARD OF CONTRACTORS AS REQUIRED BY THE CODE OF VIRGINIA.  CERTIFICATE NUMBER _________________ WAS ISSUED ON THE ________DAY OF _____________, 20XX.  THE UNDERSIGNED FURTHER CERTIFIES THAT THE REGISTRATION FEE AND ALL RENEWAL FEES REQUIRED UNDER LAW HAVE BEEN PAID.  THE CONTRACTOR AGREES TO FURNISH ALL NECESSARY LABOR, EQUIPMENT, MATERIALS, AND ALL THINGS NECESSARY TO PERFORM THE WORK AS SET FORTH IN ACCORDANCE WITH THE PLANS AND SPECIFICATIONS. THE CONTRACTOR AGREES TO PERFORM RELATED WORK FOR THE FOLLOWING ITEMS AT THE FOLLOWING STIPULATED PRICES: (ALL PRICES INCLUDE PROVISION AND INSTALLATION)."]
[{"$nulls":3},"CHECKED BY:"]
[]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT PRICE","TOTAL"]
["C1",{"$f":"VLOOKUP(A6,[1]!Table_BidItem_CategoryClassification[#All],2,FALSE)","v":"GENERAL EARTH WORK"}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT PRICE","TOTAL"]
["01400-C1-00030","Test Pits (or Test Bores), Up to 6' Deep (with restoration)",3,"EA",null,{"$f":"IFERROR($C8*$E8, \"\")","v":{"v":0,"d":"$0.00"}}]
["02200-C1-00130","Aggregate, VDOT #21-A  (Compacted in Place per VDOT standards & Specs)",79,"CY",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$8:$F$9)","v":{"v":0,"d":"$0.00"}}]
[]
["C2",{"$f":"VLOOKUP(A12,[1]!Table_BidItem_CategoryClassification[#All],2,FALSE)","v":"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.",240,"LF",null,{"$f":"IFERROR($C14*$E14, \"\")","v":{"v":0,"d":"$0.00"}}]
["02750-C2-00060","Concrete Curb & Gutter, Standard C-2 and C-2R (Arlington County Detail R-2.0), includes curb & gutter for aprons, ramps, etc.",970,"LF",null,{"v":0,"d":"$0.00"}]
["02750-C2-00085","Concrete Curb, C-5 Alternate Curb for Medians (Arlington County Detail R-2.0)",130,"LF",null,{"v":0,"d":"$0.00"}]
["02611-C2-00110","Concrete Sidewalk, 4\" Thickness (Arlington County Detail R-2.0)",621,"SY",null,{"v":0,"d":"$0.00"}]
["02611-C2-00190","CG-12 Detectable Warning Surface - Truncated Domes",3,"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)",337,"SY",null,{"v":0,"d":"$0.00"}]
["02750-C2-SP110","Concrete Curb. 9.5\" Header Curb (Modified C-4 Curb & Gutter, Arlington County Detail R-2.0), Includes curb for aprons, ramps,etc.",100,"LF",null,{"v":0,"d":"$0.00"}]
["02611-C2-SP010","Median Strip Surface - Concrete (per Arlington County Detail R-1.4)",30,"SY",null,{"v":0,"d":"$0.00"}]
["02611-C2-SP020","Median Strip Suface - Landscape (per Arlington County Detail R-1.4)",90,"SY",null,{"v":0,"d":"$0.00"}]
["02611-C2-SP030","Mountable Concrete Median per Detail on plans (Modifed Mountable Curb Detail at Traffic Circle, Arlington County Detail R-2.7)",80,"SY",null,{"v":0,"d":"$0.00"}]
["02611-C2-SP100","Embedded Detectible Warning Surface - Truncated Domes (Color per Plans)",7,"SY",null,{"v":0,"d":"$0.00"}]
["02611-C2-SP110","Embedded Longitudinal Directional Indicators - 24\" (Color per Plans)",9,"LF",null,{"v":0,"d":"$0.00"}]
["02611-C2-SP120","Embedded Longitudinal Directional Indicators - 12\" (Color per Plans)",5,"LF",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$14:$F$26)","v":{"v":0,"d":"$0.00"}}]
[]
["C3",{"$f":"VLOOKUP(A29,[1]!Table_BidItem_CategoryClassification[#All],2,FALSE)","v":"ASPHALT WORK"}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["02600-C3-00010","Asphalt Concrete, Planing or Milling (1/2\" to 3\" Depth)",1280,"SY",null,{"$f":"IFERROR($C31*$E31, \"\")","v":{"v":0,"d":"$0.00"}}]
["02600-C3-00030","Asphalt Concrete, Base Course (VDOT BM-25.0A)",171,"TON",null,{"v":0,"d":"$0.00"},null,null,"SF x IN /9 x 120 /2000 =TON"]
["02600-C3-00060","Asphalt Concrete, Surface Course (VDOT SM-9.5A)",210,"TON",null,{"v":0,"d":"$0.00"},null,null,"SF x IN /9 x 120 /2000 =TON"]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$31:$F$33)","v":{"v":0,"d":"$0.00"}}]
[]
["C4",{"$f":"VLOOKUP(A36,[1]!Table_BidItem_CategoryClassification[#All],2,FALSE)","v":"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",71,"LF",null,{"$f":"IFERROR($C38*$E38, \"\")","v":{"v":0,"d":"$0.00"}}]
["02500-C4-00830","15\" Pipe, RCP Class IV, In Place 6' to 10' Deep",47,"LF",null,{"v":0,"d":"$0.00"}]
["02500-C4-00840","15\" Pipe, RCP Class IV, In Place 10' Deep",112,"LF",null,{"v":0,"d":"$0.00"}]
["02505-C4-00010","Storm Manhole MH-1 (Arlington County Detail D-3.0), In Place, DEPTH   8'",1,"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.",3,"EA",null,{"v":0,"d":"$0.00"}]
["02505-C4-00250","Curb Drop Inlet, Standard VDOT DI-3B (12\" to 30\" Pipe), In Place Up to 8' Deep, Inlet Throat Length 4' to 20'",2,"EA",null,{"v":0,"d":"$0.00"}]
["02500-C4-00460","Storm Manhole Frame and Cover, Remove & Replace",1,"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'",8,"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.",9,"VF",null,{"v":0,"d":"$0.00"}]
["02505-C4-00260","Curb Drop Inlet, Standard VDOT DI-3BB (12\" to 30\" Pipe), Each VF Over 8' Deep, Inlet Throat Length 4' to 20'",15,"VF",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$38:$F$47)","v":{"v":0,"d":"$0.00"}}]
[]
["C5",{"$f":"VLOOKUP(A50,[1]!Table_BidItem_CategoryClassification[#All],2,FALSE)","v":"GUARDRAIL"}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[{"$nulls":4},"SUBTOTAL",{"v":0,"d":"$0.00"}]
[]
["C6",{"$f":"VLOOKUP(A54,[1]!Table_BidItem_CategoryClassification[#All],2,FALSE)","v":"WATERMAIN WORK"}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["02550-C6-00140","12-Inch Gate Valve & Valve Box",1,"EA",null,{"$f":"IFERROR($C56*$E56, \"\")","v":{"v":0,"d":"$0.00"}}]
["02550-C6-00150","8-Inch Gate Valve & Valve Box",2,"EA",null,{"v":0,"d":"$0.00"}]
["02550-C6-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",2,"EA",null,{"v":0,"d":"$0.00"}]
["02550-C6-00250","Remove Existing Fire Hydrant",1,"EA",null,{"v":0,"d":"$0.00"}]
["02550-C6-00270","Install New Fire Hydrant (includes Fire Hydrant, Gate Valve with Valve Box and up to 20 LF 6-inch DIP CL-52)",1,"EA",null,{"v":0,"d":"$0.00"}]
["02550-C6-00300","Cut & Cap 12-Inch Water Main",2,"EA",null,{"v":0,"d":"$0.00"}]
["02550-C6-00350","Remove Existing Valve Boxes",3,"EA",null,{"v":0,"d":"$0.00"}]
["02550-C6-00030","12-Inch Water Main, DIP CL-52, Upto 6' Deep",60,"LF",null,{"v":0,"d":"$0.00"}]
["02550-C6-00040","12-Inch Water Main, DIP CL-52, > 6' Deep",148,"LF",null,{"v":0,"d":"$0.00"}]
["02550-C6-00060","8-Inch Water Main, DIP CL-52, > 6' Deep",30,"LF",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$56:$F$66)","v":{"v":0,"d":"$0.00"}}]
[]
["C7",{"$f":"VLOOKUP(A69,[1]!Table_BidItem_CategoryClassification[#All],2,FALSE)","v":"SANITARY SEWER WORK"}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[{"$nulls":4},"SUBTOTAL",{"v":0,"d":"$0.00"}]
[]
["C8",{"$f":"VLOOKUP(A73,[1]!Table_BidItem_CategoryClassification[#All],2,FALSE)","v":"TRAFFIC SIGNAL WORK"}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[{"$nulls":4},"SUBTOTAL",{"v":0,"d":"$0.00"}]
[]
["C9",{"$f":"VLOOKUP(A77,[1]!Table_BidItem_CategoryClassification[#All],2,FALSE)","v":"STREET LIGHTING WORK"}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["14040-C9-00170","Furnish and Install Junction Box and Lid SMALL (Detail 14040-01)",3,"EA",null,{"$f":"IFERROR($C79*$E79, \"\")","v":{"v":0,"d":"$0.00"}}]
["14040-C9-00220","Enter Existing Junction Box",1,"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",1220,"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"}]
["14112-C9-00910","Decorative Post-Top Aluminum Streetlight Pole with Single Post-Top Luminaire per Arlington Lighting Standard 14112-01",7,"EA",null,{"v":0,"d":"$0.00"}]
["14030-C9-SP033","Furnish and Install 2 inch SCH 40 PVC or SCH 80 HDPE/SDR11 Conduit either by Trenching or  Directional Bore (Detail 14030-01)",1220,"LF",null,{"$f":"IFERROR($C84*$E84, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$79:$F$84)","v":{"v":0,"d":"$0.00"}}]
[]
["C10",{"$f":"VLOOKUP(A87,[1]!Table_BidItem_CategoryClassification[#All],2,FALSE)","v":"PAVEMENT MARKING AND SIGNAGE WORK"}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["02900-C10-00010","Four (4) Inch Transverse Markings",680,"LF",null,{"$f":"IFERROR($C89*$E89, \"\")","v":{"v":0,"d":"$0.00"}}]
["02900-C10-00020","Six (6) Inch Transverse Markings",205,"LF",null,{"v":0,"d":"$0.00"}]
["02900-C10-00050","Twenty Four (24) Inch Transverse Markings, Note: Used For Continental (Ladder) Crosswalk",60,"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: Six (6) LF Consists of Two (2) LF of Marking and Four (4) LF of Space",691,"LF",null,{"v":0,"d":"$0.00"}]
["02900-C10-00280","Speed Hump Markings (MUTCD Fig. 3B-29 Option A, or Fig. 3B-30 Option B), Two (2) Each Per Hump, **Each Hump Will Have 2 - 1 In Each Direction**",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\"",5,"EA",null,{"v":0,"d":"$0.00"}]
["02900-C10-00350","Colorized Bike Lane Coatings (per Specification 02900)",45,"SY",null,{"v":0,"d":"$0.00"}]
["02619-C10-00410","Traffic Control Sign (Typical Stop, Yield, No Parking, Speed Limit, or Similar)",9,"EA",null,{"v":0,"d":"$0.00"}]
["02840-C10-SP100","Vehicle Delineators",2,"EA",null,{"$f":"IFERROR($C97*$E97, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$89:$F$97)","v":{"v":0,"d":"$0.00"}}]
[]
["C11",{"$f":"VLOOKUP(A100,[1]!Table_BidItem_CategoryClassification[#All],2,FALSE)","v":"LANDSCAPE AND HARDSCAPE RESTORATION WORK"}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["02800-C11-00020","Topsoil for Street Trees, Backfill Soil Mixture of 3/4 Existing Soil and 1/4 Organic Material (per Arlington County DPR Specification)",336,"CY",null,{"$f":"IFERROR($C102*$E102, \"\")","v":{"v":0,"d":"$0.00"}},null,null,"Median grass is part of another line item"]
["02801-C11-00060","Sod, Tall Fescue/Bluegrass Mixture",336,"SY",null,{"v":0,"d":"$0.00"}]
["02800-C11-00603","Trees, Deciduous - 2.0 to 2.5\" caliper",1,"EA",null,{"v":0,"d":"$0.00"}]
["05500-C11-00150","Handrail - Ornamental (Arlington County Detail R-3.2)",25,"LF",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$102:$F$105)","v":{"v":0,"d":"$0.00"}}]
[]
["C12",{"$f":"VLOOKUP(A108,[1]!Table_BidItem_CategoryClassification[#All],2,FALSE)","v":"BUS STOP SHELTER AND FURNISHINGS"}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["10530-C12-00010","Bus Shelter Pad (Detail R-2.10)",50,"SY",null,{"$f":"IFERROR($C110*$E110, \"\")","v":{"v":0,"d":"$0.00"}}]
["10530-C12-00185","Solar-powered LED Light Panel Kit",1,"EA",null,{"v":0,"d":"$0.00"}]
["10530-C12-SP025","Furnish and Install Bus Shelter Unit, 4' x 10' Traditional Cantilever Shelter",1,"EA",null,{"$f":"IFERROR($C112*$E112, \"\")","v":{"v":0,"d":"$0.00"}}]
["10530-C12-SP105","Furnish and Install 6' Free-standing Bench",1,"EA",null,{"$f":"IFERROR($C113*$E113, \"\")","v":{"v":0,"d":"$0.00"}}]
["10530-C12-SP135","Furnish and Install Bus Shelter Litter Receptacle",1,"EA",null,{"$f":"IFERROR($C114*$E114, \"\")","v":{"v":0,"d":"$0.00"}}]
["10530-C12-SP136","Furnish and Install Bus Shelter Recycling Receptacle",1,"EA",null,{"$f":"IFERROR($C115*$E115, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$110:$F$115)","v":{"v":0,"d":"$0.00"}}]
[]
["C13",{"$f":"VLOOKUP(A118,[1]!Table_BidItem_CategoryClassification[#All],2,FALSE)","v":"EROSION AND SEDIMENT CONTROL WORK"}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[{"$nulls":4},"SUBTOTAL",{"v":0,"d":"$0.00"}]
[]
["C15",{"$f":"VLOOKUP(A122,[1]!Table_BidItem_CategoryClassification[#All],2,FALSE)","v":"UNLISTED WORK"}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[{"$nulls":4},"SUBTOTAL",{"v":0,"d":"$0.00"}]
[]
["C16",{"$f":"VLOOKUP(A126,[1]!Table_BidItem_CategoryClassification[#All],2,FALSE)","v":"MOT AND RE-MOBILIZATION WORK"}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[{"$nulls":4},"SUBTOTAL",{"v":0,"d":"$0.00"}]
[]
["C17",{"$f":"VLOOKUP(A130,[1]!Table_BidItem_CategoryClassification[#All],2,FALSE)","v":"STORMWATER WORK"}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[{"$nulls":4},"SUBTOTAL",{"v":0,"d":"$0.00"}]
[]
["C18",{"$f":"VLOOKUP(A134,[1]!Table_BidItem_CategoryClassification[#All],2,FALSE)","v":"NON COUNTY UTILITIES"}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[{"$nulls":4},"SUBTOTAL",{"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",{"$f":"VLOOKUP(A141,[1]!Table_BidItem_CategoryClassification[#All],2,FALSE)","v":"PERCENTAGE LINE ITEMS"}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["01500-C13-10000","Temporary Erosion and Sediment Controls","N/A","%",null,{"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,{"v":0,"d":"$0.00"}]
["01500-SA-00200","SWPPP Administration","NA","%",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"PERCENTAGE LINE ITEMS SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$143:$F$146)","v":{"v":0,"d":"$0.00"}}]
[]
[]
[]
[{"$nulls":4},"PROJECT TOTAL :",{"$f":"$F$147+F139","v":{"v":0,"d":"$0.00"}}]