{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":114,"n_cols":9,"rows_kept":114,"merged":[[0,0,0,7],[1,0,1,7],[2,0,2,7],[3,0,3,2],[3,4,3,6],[3,7,3,8],[4,0,4,2],[4,4,4,6],[4,7,4,8],[5,0,5,8],[6,0,6,8],[8,0,23,0],[24,0,32,0],[33,0,35,0],[36,0,43,0],[44,0,49,0],[50,0,61,0],[62,0,69,0],[70,0,74,0],[75,0,87,0],[88,0,92,0],[93,0,103,0],[93,2,93,3],[94,2,94,3],[95,2,95,3],[96,2,96,3],[97,2,97,3],[98,2,98,3],[99,2,99,3],[100,2,100,3],[101,2,101,3],[102,2,102,3],[103,2,103,3],[104,0,111,0],[104,2,104,3],[105,2,105,3],[106,2,106,3],[107,2,107,3],[108,2,108,3],[109,2,109,3],[110,2,110,3],[111,2,111,3],[112,5,112,7],[113,0,113,7]]}
["Arlington County Government"]
["ATTACHMENT A - PRICE SCHEDULE"]
[]
["NAME OF OFFEROR OR CONTRACTOR",{"$nulls":3},"SOLICITATION OR CONTRACT NUMBER",null,null,"PAGE"]
["sdffdgd",{"$nulls":3},"23-DES-ITBPW-287"]
["SCOPE OF WORK"]
["The Contractor shall provide the labor, materials, tools, parts, supplies, equipment, transportation, and supervision necessary to complete the various lighting maintenance tasks outlined in the items below and in accordance with the contract document. "]
[null,"ITEM NO.","SUPPLIES/SERVICES","Reference","EST QTY","UNIT","UNIT PRICE","LIST ALL TRADESMEN FOR ANY INSTALLATION AND REMOVAL SERVICES","AMOUNT"]
["Conduits",1,"Furnish and Install 1 inch Steel Riser on Wooden Poles",14030,300,"LF",null,null,{"$f":"IF(G9=\"\",\"\",(E9*(ROUND(G9,2))))","v":""}]
[null,2,"Furnish and Install 1 Inch Steel Conduit on Wall Surfaces",14030,500,"LF"]
[null,3,"Furnish and Install 2 Inch SCH 80 HDPE Direct Bore Conduit",14030,15000,"LF",null,null,""]
[null,4,"Furnish and Install 2 Inch SCH 40 PVC Conduit in Trench",14030,10000,"LF",null,null,{"$f":"IF(G12=\"\",\"\",(E12*(ROUND(G12,2))))","v":""}]
[null,5,"Furnish and Install 2 Inch SCH 40 PVC Conduit in Road Crossing",14030,500,"LF",null,null,{"$f":"IF(G13=\"\",\"\",(E13*(ROUND(G13,2))))","v":""}]
[null,6,"Testpit in Roadway",14030,150,"EA",null,null,""]
[null,7,"Testpit in Concrete",14030,150,"EA",null,null,""]
[null,8,"Testpit in Pavers",14030,150,"EA",null,null,""]
[null,9,"Testpit in Landscape Area",14030,150,"EA",null,null,""]
[null,10,"Trenching  - Asphalt",14030,1000,"LF",null,null,""]
[null,11,"Trenching  - Concrete ",14030,2000,"LF",null,null,""]
[null,12,"Trenching  - Pavers",14030,3000,"LF",null,null,""]
[null,13,"Trenching - Earth",14030,4000,"LF",null,null,""]
[null,14,"Clear Existing Conduit",14030,3000,"LF",null,null,""]
[null,15,"Remove Underground Conduit",14030,500,"LF",null,null,""]
[null,16,"Remove Conduit from Wall Surfaces (e.g, retaining wall, bridge deck)",14030,200,"LF",null,null,""]
["Junction Boxes",17,"Furnish and Install Junction Box and Lid SMALL",14040,200,"EA",null,null,{"$f":"IF(G25=\"\",\"\",(E25*(ROUND(G25,2))))","v":""}]
[null,18,"Furnish and Install Junction Box and Lid LARGE ",14040,200,"EA",null,null,""]
[null,19,"Furnish and Install Junction Box Lid SMALL",14040,25,"EA",null,null,""]
[null,20,"Furnish and Install Junction Box Lid LARGE",14040,25,"EA",null,null,""]
[null,21,"Furnish and Install Wall Mount Junction Box and Lid",14040,20,"EA",null,null,""]
[null,22,"Enter Existing Junction Box",14040,10,"EA",null,null,{"$f":"IF(G30=\"\",\"\",(E30*(ROUND(G30,2))))","v":""}]
[null,23,"Remove Junction Box SMALL",14040,50,"EA",null,null,""]
[null,24,"Remove Junction Box LARGE",14040,50,"EA",null,null,""]
[null,25,"Adjust Existing Junction Box to Grade",14040,10,"EA",null,null,""]
["Conductors",26,"Furnish & Install #6 XHHW-2 cable",14050,160000,"LF",null,null,{"$f":"IF(G34=\"\",\"\",(E34*(ROUND(G34,2))))","v":""}]
[null,27,"Furnish & Install #12 UF cable with ground wire",14050,6500,"LF",null,null,{"$f":"IF(G35=\"\",\"\",(E35*(ROUND(G35,2))))","v":""}]
[null,28,"Remove Coductor",14050,5000,"LF",null,null,{"$f":"IF(G36=\"\",\"\",(E36*(ROUND(G36,2))))","v":""}]
["Foundations",29,"Install Streetlight Pole Foundation",14060,240,"EA",null,null,{"$f":"IF(G37=\"\",\"\",(E37*(ROUND(G37,2))))","v":""}]
[null,30,"Install Roadway Light Pole Foundation",14060,50,"EA",null,null,""]
[null,31,"Install Shallow-Depth Foundation",14060,10,"EA",null,null,""]
[null,32,"Enter Existing Foundation",14060,5,"EA",null,null,""]
[null,33,"Install Anchor Bolts in Existing Foundation",14060,5,"EA",null,null,""]
[null,34,"Demolish of Existing Foundation",14060,20,"EA",null,null,""]
[null,35,"Removal of Existing Foundation - up to 4' Deep",14060,10,"EA",null,null,""]
[null,36,"Removal of Existing Foundation - 4' to 8' Deep ",14060,10,"EA",null,null,""]
["Pole Base",37,"Furnish and install Clamshell Base",14070,15,"EA",null,null,{"$f":"IF(G45=\"\",\"\",(E45*(ROUND(G45,2))))","v":""}]
[null,38,"Furnish and install Transformer Base",14070,50,"EA",null,null,""]
[null,39,"Furnish and install aluminum transformer base cover",14070,25,"EA",null,null,""]
[null,40,"Furnish and install plastic transformer base cover",14070,200,"EA",null,null,""]
[null,41,"Remove Clamshell Base",14070,5,"EA",null,null,""]
[null,42,"Remove Transformer Base",14070,50,"EA",null,null,""]
["Light Poles",43,"Furnish and Install Wooden Roadway Light Pole",14080,5,"EA",null,null,{"$f":"IF(G51=\"\",\"\",(E51*(ROUND(G51,2))))","v":""}]
[null,44,"Install Direct-Buried Composite Roadway Light Pole",14080,20,"EA",null,null,""]
[null,45,"Install Direct-Buried Composite Streetlight Pole",14080,5,"EA",null,null,""]
[null,46,"Install on-foundation composite or aluminum roadway light poles  ",14080,50,"EA",null,null,""]
[null,47,"Install on-foundation composite or aluminum or steel streetlight poles  ",14080,250,"EA",null,null,""]
[null,48,"Direct-buried Roadway Light or Streetlight Pole Removal",14080,10,"EA",null,null,""]
[null,49,"On-Foundation Roadway Light or Streetlight Pole Removal",14080,40,"EA",null,null,""]
[null,50,"Emergency Roadway Light or Streetlight Pole Removal ",14080,5,"EA",null,null,""]
[null,51,"Pole Painting On-site Roadway Light ",14080,5,"EA",null,null,""]
[null,52,"Pole Painting On-site Streetlight Pole",14080,20,"EA",null,null,""]
[null,53,"Straighten Leaning Direct-Buried Roadway Poles ",14080,5,"EA",null,null,""]
[null,54,"Straighten Leaning Direct-Buried Streetlight Poles ",14080,5,"EA",null,null,""]
["Luminaire Arms",55,"Install Standard Aluminum Luminaire 6' Arm",14090,50,"EA",null,null,{"$f":"IF(G63=\"\",\"\",(E63*(ROUND(G63,2))))","v":""}]
[null,56,"Install Upsweep Aluminum Luminaire 6' Arm",14090,15,"EA",null,null,""]
[null,57,"Install S-Curve Aluminum Luminaire 6' Arm",14090,10,"EA",null,null,""]
[null,58,"Install Decorative Post-Top Aluminum Luminaire Arm",14090,100,"EA",null,null,""]
[null,59,"Install Decorative Single Arm for Rear Mount Octaflute Pole",14090,5,"EA",null,null,""]
[null,60,"Install Aluminum Arm Adapter for Teardrop Fixture",14090,5,"EA",null,null,""]
[null,61,"Straighten Decorative Post-Top Aluminium Luminaire Arm",14090,20,"EA",null,null,""]
[null,62,"Remove Luminaire Arm",14090,10,"EA",null,null,""]
["Electric Service",63,"Furnish and Install Meter Pan, Pedestal, Control Box and Components ",14100,15,"EA",null,null,{"$f":"IF(G71=\"\",\"\",(E71*(ROUND(G71,2))))","v":""}]
[null,64,"Furnish and Install Contactor",14100,50,"EA",null,null,""]
[null,65,"Furnish and Install HOA Switch",14100,50,"EA",null,null,""]
[null,66,"Furnish and Install Photocell",14100,50,"EA",null,null,""]
[null,67,"Remove Meter Pedestal and Pan",14100,20,"EA",null,null,""]
["Luminaires",68,"Install decorative post-top globe",14110,50,"EA",null,null,{"$f":"IF(G76=\"\",\"\",(E76*(ROUND(G76,2))))","v":""}]
[null,69,"Install decorative post-top globe and metal base",14110,50,"EA",null,null,{"$f":"IF(G77=\"\",\"\",(E77*(ROUND(G77,2))))","v":""}]
[null,70,"Retrofit decorative post-top LED luminaire",14110,150,"EA",null,null,{"$f":"IF(G78=\"\",\"\",(E78*(ROUND(G78,2))))","v":""}]
[null,71,"Install complete decorative post-top LED luminaire assembly",14110,300,"EA",null,null,""]
[null,72,"Install cobra LED luminaire and communication device",14110,50,"EA",null,null,""]
[null,73,"Install teardrop LED luminaire and communication device",14110,50,"EA",null,null,""]
[null,74,"Furnish and install wallpack LED luminaire",14110,20,"EA",null,null,""]
[null,75,"Repair tilted roadway luminaire",14110,20,"EA",null,null,""]
[null,76,"Repair tilted decorative post-top luminaire",14110,50,"EA",null,null,""]
[null,77,"Repair dislocated wallpack luminaire",14110,5,"EA",null,null,""]
[null,78,"Remove decorative post-top luminaire",14110,200,"EA",null,null,""]
[null,79,"Remove roadway luminaire",14110,25,"EA",null,null,""]
[null,80,"Remove wallpack luminaire",14110,20,"EA",null,null,""]
["Typical Maintenance/ Replacement",81,"Lighting Outage Investigation","SS-01",100,"HR",null,null,""]
[null,82,"Furnish and Replace HPS bulb - roadway luminaire","SS-02",10,"EA",null,null,""]
[null,83,"Furnish and Replace HPS bulb - decorative post-top luminaire","SS-02",10,"EA",null,null,""]
[null,84,"Furnish and Replace fuse","SS-03",50,"EA",null,null,""]
[null,85,"Replace photocell ","SS-04",50,"EA",null,null,""]
["Laborer Personnel",86,"Foreman",null,20,"HR",null,null,""]
[null,87,"Laborer",null,20,"HR",null,null,""]
[null,88,"Lineman",null,20,"HR",null,null,""]
[null,89,"Welder with accessories",null,20,"HR",null,null,""]
[null,90,"Concrete finisher",null,20,"HR",null,null,""]
[null,91,"Utility truck driver",null,20,"HR",null,null,""]
[null,92,"Dump truck driver",null,20,"HR",null,null,""]
[null,93,"Pole truck driver",null,20,"HR",null,null,""]
[null,94,"Aerial lift truck operator",null,20,"HR",null,null,""]
[null,95,"Backhoe operator",null,20,"HR",null,null,""]
[null,96,"Air compressor driver",null,20,"HR",null,null,""]
["Equipment Only",97,"Utility truck ",null,20,"HR",null,null,""]
[null,98,"Dump truck ",null,20,"HR",null,null,""]
[null,99,"Pole truck",null,20,"HR",null,null,""]
[null,100,"Aerial Lift truck ",null,20,"HR",null,null,""]
[null,101,"Backhoe ",null,20,"HR",null,null,""]
[null,102,"Air compressor with air tools ",null,20,"HR",null,null,""]
[null,103,"Pole trailer ",null,20,"HR",null,null,""]
[null,104,"Cable trailer",null,20,"HR",null,null,""]
[{"$nulls":5},"Grand Total",null,null,{"$f":"SUM(I9:I112)","v":{"v":0,"d":"$0"}}]
["COMMENCEMENT, PROSECUTION AND COMPLETION OF WORKS: The Contractor shall be required to (a) commence work under this contract within 10 calendar days after the date the Contractor receives Notice to Proceed; (b) prosecute the work diligently; (c) complete all work ready for use not later than the number of days specified in the contract. \n\n\n"]