{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Guidance","Unit_Price_Tab","SP_Info_Biditem_Category"],"not_rendered":{"images":4,"defined_names":12,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Guidance","index":1,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Unit_Price_Tab","index":2,"n_rows":179,"n_cols":6,"rows_kept":179,"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,Table_BidItem_CategoryClassification[#All],2,FALSE)","v":"GENERAL EARTH WORK"}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT PRICE","TOTAL"]
["02200-C1-00010","General Excavation, only when not included in other pay items",1710,"CY",null,{"$f":"IFERROR($C8*$E8, \"\")","v":{"v":0,"d":"$0.00"}}]
["02200-C1-00050","Select Borrow (VDOT Section 207 - Select Material, Type I)",1630,"CY",null,{"v":0,"d":"$0.00"}]
["02200-C1-00060","Flowable BackFill (VDOT Special Provision S302G02-0610)",5,"CY",null,{"v":0,"d":"$0.00"}]
["02200-C1-00140","Aggregate, VDOT #21-B  (Compacted in Place per VDOT standards & Specs)",2605,"CY",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$8:$F$11)","v":{"v":0,"d":"$0.00"}}]
[]
["C2",{"$f":"VLOOKUP(A14,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.",4615,"LF",null,{"$f":"IFERROR($C16*$E16, \"\")","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.",1560,"LF",null,{"v":0,"d":"$0.00"}]
["02750-C2-00070","Concrete Curb & Gutter, Combination 6\" (VDOT CG-6), includes curb & gutter for aprons, ramps, etc.",480,"LF",null,{"v":0,"d":"$0.00"}]
["02750-C2-00085","Concrete Curb, C-5 Alternate Curb for Medians (Arlington County Detail R-2.0)",8050,"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)",20,"SY",null,{"v":0,"d":"$0.00"}]
["02611-C2-00110","Concrete Sidewalk, 4\" Thickness (Arlington County Detail R-2.0)",2780,"SY",null,{"v":0,"d":"$0.00"}]
["02611-C2-00190","CG-12 Detectable Warning Surface - Truncated Domes",175,"SY",null,{"v":0,"d":"$0.00"}]
["02612-C2-00130","Concrete Pavers (Arlington County Detail R-2.1)",5,"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)",120,"SY",null,{"v":0,"d":"$0.00"}]
["03100-C2-00240","Concrete and Formwork (VDOT Class A4), only when not included in other pay items",40,"CY",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$16:$F$25)","v":{"v":0,"d":"$0.00"}}]
[]
["C3",{"$f":"VLOOKUP(A28,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)",25400,"SY",null,{"$f":"IFERROR($C30*$E30, \"\")","v":{"v":0,"d":"$0.00"}}]
["02600-C3-00030","Asphalt Concrete, Base Course (VDOT BM-25.0A)",5015,"TON",null,{"v":0,"d":"$0.00"}]
["02600-C3-00070","Asphalt Concrete, Surface Course (VDOT SM-9.5D)",4305,"TON",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$30:$F$32)","v":{"v":0,"d":"$0.00"}}]
[]
["C4",{"$f":"VLOOKUP(A35,Table_BidItem_CategoryClassification[#All],2,FALSE)","v":"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",310,"LF",null,{"$f":"IFERROR($C37*$E37, \"\")","v":{"v":0,"d":"$0.00"}}]
["02505-C4-00630","15\" Pipe, RCP Class III, In Place 6' to 8' Deep",480,"LF",null,{"v":0,"d":"$0.00"}]
["02500-C4-00820","15\" Pipe, RCP Class IV, In Place Up to 6' Deep",650,"LF",null,{"v":0,"d":"$0.00"}]
["02500-C4-00870","18\" Pipe, RCP Class IV, In Place  10' Deep",90,"LF",null,{"v":0,"d":"$0.00"}]
["02505-C4-01440","Underdrain, Standard VDOT UD-4",3880,"LF",null,{"$f":"IFERROR($C41*$E41, \"\")","v":{"v":0,"d":"$0.00"}}]
["02500-C4-00060","Storm Manhole (VDOT MH-1, MH1-A), In Place, DEPTH   8'",3,"EA",null,{"v":0,"d":"$0.00"}]
["02500-C4-00070","Storm Manhole (VDOT MH-2), In Place, DEPTH   8'",3,"EA",null,{"v":0,"d":"$0.00"}]
["02505-C4-00180","Curb Drop Inlet, Standard VDOT DI-2B (12\" to 24\" Pipe), In Place Up to 9' Deep, Inlet Throat Length 4' to 20'",21,"EA",null,{"v":0,"d":"$0.00"}]
["02505-C4-00190","Curb Drop Inlet, Standard VDOT DI-2C (12\" to 24\" Pipe), In Place Up to 9' Deep, Inlet Throat Length 6' to 20'",1,"EA",null,{"v":0,"d":"$0.00"}]
["02505-C4-00230","Curb Drop Inlet, Standard VDOT DI-3A (12\" to 30\" Pipe), In Place Up to 8' Deep",1,"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'",12,"EA",null,{"v":0,"d":"$0.00"}]
["02505-C4-00270","Curb Drop Inlet, Standard VDOT DI-3C (12\" to 30\" Pipe), In Place Up to 8' Deep, Inlet Throat Length 6' 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"}]
["02505-C4-00520","Convert Catch Basin to Manhole",7,"EA",null,{"v":0,"d":"$0.00"}]
["02505-C4-00550","Core Drill and Connect 15\" to 24\" Dia Concrete Pipe to Existing Storm Manhole, Catch Basin, Drop Inlet, Yard Inlet, or Grate Inlet",14,"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'",9,"VF",null,{"$f":"IFERROR($C53*$E53, \"\")","v":{"v":0,"d":"$0.00"}}]
["02500-C4-00071","Storm Manhole (VDOT MH-2), In Place, PER ADDITIONAL VF OVER 8'",5,"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'",1,"VF",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$37:$F$55)","v":{"v":0,"d":"$0.00"}}]
[]
["C5",{"$f":"VLOOKUP(A58,Table_BidItem_CategoryClassification[#All],2,FALSE)","v":"GUARDRAIL"}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!#REF!)","v":{"$error":"#REF!"}}]
[]
["C6",{"$f":"VLOOKUP(A62,Table_BidItem_CategoryClassification[#All],2,FALSE)","v":"WATERMAIN WORK"}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["02550-C6-00250","Remove Existing Fire Hydrant",2,"EA",null,{"$f":"IFERROR($C64*$E64, \"\")","v":{"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",1,"EA",null,{"v":0,"d":"$0.00"}]
["02550-C6-00490","12\" x 12\" Tap/Sleeve On Iron Pipe, Valve & Valve Box",2,"EA",null,{"v":0,"d":"$0.00"}]
["02550-C6-00350","Remove Existing Valve Boxes",2,"EA",null,{"$f":"IFERROR($C68*$E68, \"\")","v":{"v":0,"d":"$0.00"}}]
["02550-C6-SP251","Install New Fire Hydrant (connect to existing 6\" WM)",1,"EA",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"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$64:$F$70)","v":{"v":0,"d":"$0.00"}}]
[]
["C7",{"$f":"VLOOKUP(A73,Table_BidItem_CategoryClassification[#All],2,FALSE)","v":"SANITARY SEWER WORK"}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["02510-C7-00280","Adjust Sanitary Manhole to New Grade (Arlington County Detail S-2.5), Type A",13,"EA",null,{"$f":"IFERROR($C75*$E75, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$75:$F$75)","v":{"v":0,"d":"$0.00"}}]
[]
["C8",{"$f":"VLOOKUP(A78,Table_BidItem_CategoryClassification[#All],2,FALSE)","v":"TRAFFIC SIGNAL WORK"}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["13160-C8-03000","Traffic Signal Cost for five (5) intersections",1,"LS",null,{"$f":"IFERROR($C80*$E80, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$80:$F$80)","v":{"v":0,"d":"$0.00"}}]
[]
["C9",{"$f":"VLOOKUP(A83,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)",10,"EA",null,{"$f":"IFERROR($C85*$E85, \"\")","v":{"v":0,"d":"$0.00"}}]
["14040-C9-00180","Furnish and Install Junction Box and Lid LARGE (Detail 14040-02)",4,"EA",null,{"v":0,"d":"$0.00"}]
["14060-C9-00300","Install Roadway Light Pole Foundation (Detail 14060-03)",22,"EA",null,{"v":0,"d":"$0.00"}]
["14060-C9-00313","Install Roadway Light Pole Foundation Shallow Depth Option 2 (Detail 14060-05)",3,"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-00980","Octaflute Aluminum Roadway Light Pole with Single Tear Drop Luminaire per Arlington Lighting Standard 14112-07",22,"EA",null,{"v":0,"d":"$0.00"}]
["14112-C9-00970","Octaflute Aluminum Roadway Light Pole with Double Tear Drop Luminaires per Arlington Lighting Standard 14112-08",3,"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 Trenchng or Directional Boring (Detail 14030-01)",4350,"LF",null,{"$f":"IFERROR($C92*$E92, \"\")","v":{"v":0,"d":"$0.00"}}]
["14030-C9-SP035","Furnish and Install 3 inch SCH 40 PVC or SCH 80 HDPE/SDR11 Conduit either by Trenchng or Directional Boring (Detail 14030-01)",450,"LF",null,{"$f":"IFERROR($C93*$E93, \"\")","v":{"v":0,"d":"$0.00"}}]
["14050-C9-00260","Furnish and Install # 6 Copper Stranded XHHW-2  including grounding conductor per AC 2020 Lighting Specifications Section 14050: Lighting Conductores",4800,"LF",null,{"$f":"IFERROR($C94*$E94, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$85:$F$94)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":3},"l"]
["C10",{"$f":"VLOOKUP(A97,Table_BidItem_CategoryClassification[#All],2,FALSE)","v":"PAVEMENT MARKING AND SIGNAGE WORK"}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["02900-C10-00040","Eighteen (18) Inch Transverse Markings",890,"LF",null,{"$f":"IFERROR($C99*$E99, \"\")","v":{"v":0,"d":"$0.00"}}]
["02900-C10-00050","Twenty Four (24) Inch Transverse Markings, Note: Used For Continental (Ladder) Crosswalk",4020,"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",25,"LF",null,{"v":0,"d":"$0.00"}]
["02900-C10-00070","Four (4) Inch Longitudinal Solid Line",8315,"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",3730,"LF",null,{"v":0,"d":"$0.00"}]
["02900-C10-00120","Six (6) Inch Longitudinal Solid Line",1900,"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",1100,"LF",null,{"v":0,"d":"$0.00"}]
["02900-C10-00230","Eight (8) Foot Letters, Note: 'Turn Only' (for example)",35,"EA",null,{"v":0,"d":"$0.00"}]
["02900-C10-00240","Single Arrows",65,"EA",null,{"v":0,"d":"$0.00"}]
["02900-C10-00250","Combination Arrows",8,"EA",null,{"v":0,"d":"$0.00"}]
["02900-C10-00290","Standard Bicycle Symbols (MUTCD, Chapter 9C, Figure 9C-3), \"Bike Symbol\", \"Helmeted Bicyclist Symbol\"",36,"EA",null,{"v":0,"d":"$0.00"}]
["02900-C10-00320","Six (6) Foot Bicycle Lane Arrow (Only for Multi-Use or Bikes Opposing Traffic)",35,"EA",null,{"v":0,"d":"$0.00"}]
["02900-C10-00350","Colorized Bike Lane Coatings (per Specification 02900)",1200,"SY",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",95,"EA",null,{"v":0,"d":"$0.00"}]
["02900-C10-00055","Twenty Four (24) Inch Transverse Markings, Note: Used For Bike Continental (Ladder) Crosswalk with 4\" Width Edging ",520,"LF",null,{"v":0,"d":"$0.00"}]
["02900-C10-SP065","Yield Line Markings (Twelve (12) Inch Triangle/Six (6) Inch Spacing), Note: LF is Width of Lane for Units",90,"LF",null,{"v":0,"d":"$0.00"}]
["02900-C10-SP227","Eight (8) Inch Gore Markings, Ten (10) Foot Spacing @ 45 Degree",500,"LF",null,{"v":0,"d":"$0.00"}]
["02900-C10-SP105","Four (4) 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, **Turn Lane Skips**",1675,"LF",null,{"v":0,"d":"$0.00"}]
["02900-C10-SP165","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. Used on bike crosswalk edging and centerline",1690,"LF",null,{"v":0,"d":"$0.00"}]
["02840-C10-SP100","Vehicle Delineators (yellow)",21,"EA",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$99:$F$118)","v":{"v":0,"d":"$0.00"}}]
[]
["C11",{"$f":"VLOOKUP(A121,Table_BidItem_CategoryClassification[#All],2,FALSE)","v":"LANDSCAPE AND HARDSCAPE RESTORATION WORK"}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["02200-C11-00010","Imported Topsoil",360,"CY",null,{"$f":"IFERROR($C123*$E123, \"\")","v":{"v":0,"d":"$0.00"}}]
["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)",170,"CY",null,{"v":0,"d":"$0.00"}]
["02801-C11-00040","Shredded hardwood mulch; Aged 6 months minimum - Free of Trash & Debris",15,"CY",null,{"v":0,"d":"$0.00"}]
["02801-C11-00060","Sod, Tall Fescue/Bluegrass Mixture",3415,"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)",3,"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)",4,"EA",null,{"v":0,"d":"$0.00"}]
["02800-C11-00604","Trees, Deciduous - 2.5 to 3.0\" caliper",60,"EA",null,{"v":0,"d":"$0.00"}]
["05500-C11-00140","Handrail (Arlington County Detail R-3.1)",130,"LF",null,{"v":0,"d":"$0.00"}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$123:$F$130)","v":{"v":0,"d":"$0.00"}}]
[]
["C12",{"$f":"VLOOKUP(A133,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)",210,"SY",null,{"$f":"IFERROR($C135*$E135, \"\")","v":{"v":0,"d":"$0.00"}}]
["10530-C12-SP015","Concrete Curb, Modified 9.5\" Header Curb C-3 (Arl. Co. Detail R-2.0), includes curb for aprons, ramps, etc. See Detail Sheet C002.2",100,"LF",null,{"$f":"C136*E136","v":{"v":0,"d":"$0.00"}}]
["10530-C12-SP017","Concrete Pavement, 10\" thick Reinforced Class A4 Concrete Pad infront of Bus Shelter. See Detail Sheet C002.2",110,"SY",null,{"$f":"IFERROR($C137*$E137, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$135:$F$137)","v":{"v":0,"d":"$0.00"}}]
[]
["C13",{"$f":"VLOOKUP(A140,Table_BidItem_CategoryClassification[#All],2,FALSE)","v":"EROSION AND SEDIMENT CONTROL WORK"}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!#REF!)","v":{"$error":"#REF!"}}]
[]
["C15",{"$f":"VLOOKUP(A144,Table_BidItem_CategoryClassification[#All],2,FALSE)","v":"UNLISTED WORK"}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!#REF!)","v":{"$error":"#REF!"}}]
[]
["C16",{"$f":"VLOOKUP(A148,Table_BidItem_CategoryClassification[#All],2,FALSE)","v":"MOT AND RE-MOBILIZATION WORK"}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[{"$nulls":3},{"$f":"SUBTOTAL(103,Unit_Price_Tab!#REF!)","v":{"$error":"#REF!"}},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!#REF!)","v":{"$error":"#REF!"}}]
[]
["C17",{"$f":"VLOOKUP(A152,Table_BidItem_CategoryClassification[#All],2,FALSE)","v":"STORMWATER WORK"}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!#REF!)","v":{"$error":"#REF!"}}]
[]
["C18",{"$f":"VLOOKUP(A156,Table_BidItem_CategoryClassification[#All],2,FALSE)","v":"NON COUNTY UTILITIES"}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!#REF!)","v":{"$error":"#REF!"}}]
[]
[]
[{"$nulls":4}," CONTRACT TOTAL (EXCLUDING PERCENTAGE ITEMS)",{"$f":"F12+F26+F33+F56+F71+F81+F95+F119+F131+F138","v":{"v":0,"d":"$0.00"}}]
[]
["LS",{"$f":"VLOOKUP(A163,Table_BidItem_CategoryClassification[#All],2,FALSE)","v":"LUMP SUM ITEMS"}]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["01500-C13-10000","Temporary Erosion and Sediment Controls",1,"LS",null,{"$f":"C165*E165","v":{"v":0,"d":"$0.00"}}]
["01000-C16-00010","Maintenance of Traffic (MOT)",1,"LS",null,{"$f":"C166*E166","v":{"v":0,"d":"$0.00"}}]
["01000-C16-00030","Mobilization and De-Mobilization",1,"LS",null,{"$f":"Unit_Price_Tab!$E167*$F$161","v":{"v":0,"d":"$0.00"}}]
["01500-SA-00200","SWPPP Administration",1,"LS",null,{"$f":"Unit_Price_Tab!$E168*$F$161","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"LUMP SUM ITEMS SUBTOTAL",{"$f":"SUBTOTAL(109,Unit_Price_Tab!$F$165:$F$168)","v":{"v":0,"d":"$0.00"}}]
[]
[]
[]
[{"$nulls":4},"PROJECT TOTAL :",{"$f":"$F$169+F161","v":{"v":0,"d":"$0.00"}}]
[]
[]
[{"$nulls":4},"Arlington County CMI and CA Services",{"v":992568.18,"d":"$992,568.18"}]
[{"$nulls":4},"VDOT PEOS",{"v":330875,"d":"$330,875.00"}]
[{"$nulls":4},"VDOT CSOS",{"v":198525,"d":"$198,525.00"}]
[{"$nulls":4},"TOTAL COST",{"$f":"SUM(F176:F178)","v":{"v":1521968.1800000002,"d":"$1,521,968.18"}}]

{"sheet":"SP_Info_Biditem_Category","index":3,"n_rows":24,"n_cols":5,"rows_kept":24}
["CategoryNum","Category_Title","Item Type","Path","CategorySort"]
["C1","GENERAL EARTH WORK","Item","sites/extranet/EngineeringBureau/Lists/Info_BidItems_CategoryClassification",1]
["C2","CONCRETE WORK","Item","sites/extranet/EngineeringBureau/Lists/Info_BidItems_CategoryClassification",2]
["C3","ASPHALT WORK","Item","sites/extranet/EngineeringBureau/Lists/Info_BidItems_CategoryClassification",3]
["C4","STORM SEWER UTILITY WORK","Item","sites/extranet/EngineeringBureau/Lists/Info_BidItems_CategoryClassification",4]
["C5","GUARDRAIL","Item","sites/extranet/EngineeringBureau/Lists/Info_BidItems_CategoryClassification",5]
["C6","WATERMAIN WORK","Item","sites/extranet/EngineeringBureau/Lists/Info_BidItems_CategoryClassification",6]
["C7","SANITARY SEWER WORK","Item","sites/extranet/EngineeringBureau/Lists/Info_BidItems_CategoryClassification",7]
["C8","TRAFFIC SIGNAL WORK","Item","sites/extranet/EngineeringBureau/Lists/Info_BidItems_CategoryClassification",8]
["C9","STREET LIGHTING WORK","Item","sites/extranet/EngineeringBureau/Lists/Info_BidItems_CategoryClassification",9]
["C10","PAVEMENT MARKING AND SIGNAGE WORK","Item","sites/extranet/EngineeringBureau/Lists/Info_BidItems_CategoryClassification",10]
["C11","LANDSCAPE AND HARDSCAPE RESTORATION WORK","Item","sites/extranet/EngineeringBureau/Lists/Info_BidItems_CategoryClassification",11]
["C12","BUS STOP SHELTER AND FURNISHINGS","Item","sites/extranet/EngineeringBureau/Lists/Info_BidItems_CategoryClassification",12]
["C13","EROSION AND SEDIMENT CONTROL WORK","Item","sites/extranet/EngineeringBureau/Lists/Info_BidItems_CategoryClassification",13]
["C14","MATERIAL TESTING WORK","Item","sites/extranet/EngineeringBureau/Lists/Info_BidItems_CategoryClassification",14]
["C15","UNLISTED WORK","Item","sites/extranet/EngineeringBureau/Lists/Info_BidItems_CategoryClassification",15]
["C16","MOT AND RE-MOBILIZATION WORK","Item","sites/extranet/EngineeringBureau/Lists/Info_BidItems_CategoryClassification",16]
["M1","MAINTENANCE WORK","Item","sites/extranet/EngineeringBureau/Lists/Info_BidItems_CategoryClassification",101]
["M2","MOT WORK","Item","sites/extranet/EngineeringBureau/Lists/Info_BidItems_CategoryClassification",102]
["C17","STORMWATER WORK","Item","sites/extranet/EngineeringBureau/Lists/Info_BidItems_CategoryClassification",17]
["RM","REMOVED ITEM","Item","sites/extranet/EngineeringBureau/Lists/Info_BidItems_CategoryClassification",1001]
["C18","NON COUNTY UTILITIES","Item","sites/extranet/EngineeringBureau/Lists/Info_BidItems_CategoryClassification",18]
["LS","LUMP SUM ITEMS","Item","sites/extranet/EngineeringBureau/Lists/Info_BidItems_CategoryClassification",500]
["VF","VDOT FEE","Item","sites/extranet/EngineeringBureau/Lists/Info_BidItems_CategoryClassification",600]