{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["BID PRICING"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"BID PRICING","index":0,"n_rows":132,"n_cols":7,"rows_kept":132,"merged":[[0,1,0,6],[1,1,1,6],[2,1,2,6],[3,1,3,2],[3,3,3,5],[4,1,4,2],[4,3,4,5],[5,1,5,6],[6,1,6,6],[7,1,7,6],[8,1,8,6],[10,1,10,2],[30,1,30,2],[59,1,59,2],[78,1,78,2],[95,1,95,2],[111,1,111,2],[128,1,128,6],[129,1,129,6],[130,2,130,6],[131,2,131,6],[132,2,132,6]]}
[null,"Arlington County Government"]
[null,"ATTACHMENT B  - BID PRICING"]
[]
[null,"NAME OF OFFEROR OR CONTRACTOR",null,"SOLICITATION OR CONTRACT NUMBER",null,null,"PAGE"]
[]
[null,"SCOPE OF WORK"]
[]
[null,"The Contractor shall supply traffic equipment, materials, and technical support listed in the sections below to the County."]
[]
[null,"ITEM NO.","SUPPLIES/SERVICES","EST QTY","UNIT","UNIT PRICE","AMOUNT"]
[null,"SECTION 1 - Thermal Detection System"]
[null,null,"Thermal Detector Assemblies"]
[null,"1.1","One-Detector Assembly",10,"EA",null,{"$f":"IF(F13=\"\",\"\",(D13*(ROUND(F13,2))))","v":""}]
[null,"1.2","Two-Detector Assembly",10,"EA",null,""]
[null,"1.3","Three-Detector Assembly",15,"EA",null,""]
[null,"1.4","Four-Detector Assembly",25,"EA",null,""]
[null,null,"Components and Replacement Parts"]
[null,"1.5","Detector",5,"EA",null,{"$f":"IF(F18=\"\",\"\",(D18*(ROUND(F18,2))))","v":""}]
[null,"1.6","Mounting Hardware",5,"EA",null,""]
[null,"1.7","Cable",10000,"LF",null,""]
[null,"1.8","Cable junction box",5,"EA",null,""]
[null,"1.9","Surge protector",5,"EA",null,""]
[null,"1.10","Power adapter",5,"EA",null,""]
[null,"1.11","LCD monitor",5,"EA",null,""]
[null,"1.12","Video Card",5,"EA",null,""]
[null,"1.13","Communication/PIM module",5,"EA",null,""]
[null,null,"Support Services"]
[null,"1.14","Technical Support",200,"HR",null,{"$f":"IF(F28=\"\",\"\",(D28*(ROUND(F28,2))))","v":""}]
[null,"GRAND TOTAL FOR SECTION 1",{"$nulls":4},{"$f":"SUM(G13:G28)","v":{"v":0,"d":"$0.00"}}]
[]
[null,"SECTION 2 - Radar Detection"]
[null,null,"Side-Fire Radar Detection Systems"]
[null,"2.1","1 AC Radar Assembly",10,"EA",null,{"$f":"IF(F33=\"\",\"\",(D33*(ROUND(F33,2))))","v":""}]
[null,"2.2","2 AC Radar Assembly",10,"EA",null,""]
[null,"2.3","1 Solar Assembly",10,"EA",null,""]
[null,null,"Corner-Fire Radar Detection System"]
[null,"2.4","1 Radar Assembly",5,"EA",null,{"$f":"IF(F37=\"\",\"\",(D37*(ROUND(F37,2))))","v":""}]
[null,"2.5","2 Radar Assembly",10,"EA",null,""]
[null,"2.6","3 Radar Assembly",5,"EA",null,""]
[null,"2.7","4 Radar Assembly",20,"EA",null,{"$f":"IF(F40=\"\",\"\",(D40*(ROUND(F40,2))))","v":""}]
[null,null,"Components and Replacement Parts"]
[null,"2.8","Side-fire Detector",5,"EA",null,{"$f":"IF(F42=\"\",\"\",(D42*(ROUND(F42,2))))","v":""}]
[null,"2.9","Corner-fire Detector",5,"EA",null,""]
[null,"2.10","360 rotating Detector Backplate",5,"EA",null,""]
[null,"2.11","Mounting Kit",5,"EA",null,""]
[null,"2.12","Extended Mounting Kit",20,"EA",null,""]
[null,"2.13","Side-fire Pigtail (20 ft with connector)",5,"EA",null,""]
[null,"2.14","Corner-fire Pigtail (20 ft with connector)",5,"EA",null,{"$f":"IF(F48=\"\",\"\",(D48*(ROUND(F48,2))))","v":""}]
[null,"2.15","Side-fire Cable",10000,"LF",null,{"$f":"IF(F49=\"\",\"\",(D49*(ROUND(F49,2))))","v":""}]
[null,"2.16","Corner-fire radar cable",25000,"LF",null,""]
[null,"2.17","Surge Protector",5,"EA",null,""]
[null,"2.18","Cable junction box",5,"EA",null,""]
[null,"2.19","Side-fire radar communication module",5,"EA",null,""]
[null,"2.20","Corner-fire radar communication module",5,"EA",null,""]
[null,"2.21","Power adapter",5,"EA",null,""]
[]
[null,"2.22","Tehnical Support",200,"HR",null,""]
[null,"GRAND TOTAL FOR SECTION 2",{"$nulls":4},{"$f":"SUM(G33:G57)","v":{"v":0,"d":"$0.00"}}]
[]
[null,"SECTION 3 - Video Detection System"]
[null,null,"Video Camera Detection System"]
[null,"3.1","One-Detector Assembly",5,"EA",null,{"$f":"IF(F62=\"\",\"\",(D62*(ROUND(F62,2))))","v":""}]
[null,"3.2","Two-Detector Assembly",10,"EA",null,""]
[null,"3.3","Three-Detector Assembly",15,"EA",null,""]
[null,"3.4","Four-Detector Assembly",20,"EA",null,""]
[null,null,"Components and Replacement Parts"]
[null,"3.5","Detector",5,"EA",null,{"$f":"IF(F67=\"\",\"\",(D67*(ROUND(F67,2))))","v":""}]
[null,"3.6","Mounting Hardware",5,"EA",null,""]
[null,"3.7","Cable",5000,"LF",null,""]
[null,"3.8","Surge protector",5,"EA",null,""]
[null,"3.9","Power adapter",5,"EA",null,""]
[null,"3.10","LCD monitor",5,"EA",null,""]
[null,"3.11","Video Card",5,"EA",null,""]
[null,"3.12","Communication/PIM module",5,"EA",null,{"$f":"IF(F74=\"\",\"\",(D74*(ROUND(F74,2))))","v":""}]
[null,null,"Support Services"]
[null,"3.13","Technical Support",200,"HR",null,{"$f":"IF(F76=\"\",\"\",(D76*(ROUND(F76,2))))","v":""}]
[null,"GRAND TOTAL FOR SECTION 3",{"$nulls":4},{"$f":"SUM(G62:G76)","v":{"v":0,"d":"$0.00"}}]
[]
[null,"SECTION 4 - Hybrid Detection System"]
[null,null,"Video & Radar Combined Detection System"]
[null,"4.1","One-Detector Assembly",5,"EA",null,{"$f":"IF(F81=\"\",\"\",(D81*(ROUND(F81,2))))","v":""}]
[null,"4.2","Two-Detector Assembly",25,"EA",null,""]
[null,"4.3","Three-Detector Assembly",5,"EA",null,""]
[null,"4.4","Four-Detector Assembly",5,"EA",null,""]
[null,null,"Components and Replacement Parts"]
[null,"4.5","Hybrid Detector",5,"EA",null,""]
[null,"4.6","Hybrid Detector Cable",5000,"LF",null,""]
[null,"4.7","Mounting Kit",5,"EA",null,""]
[null,"4.8","Communications/Processor Module",5,"EA",null,""]
[null,"4.9","Surge Protector",5,"EA",null,""]
[null,"4.10","Power Supply/Adapter",5,"EA",null,""]
[null,null,"Technical Support"]
[null,"4.11","Technical Support",200,"HRS",null,{"$f":"IF(F93=\"\",\"\",(D93*(ROUND(F93,2))))","v":""}]
[null,"GRAND TOTAL FOR SECTION 4",{"$nulls":4},{"$f":"SUM(G81:G93)","v":{"v":0,"d":"$0.00"}}]
[]
[null,"SECTION 5 - 3 Wire Broadband over Power Video Detection System"]
[null,null,"Broadband over Power Video Detection System"]
[null,"5.1","One-Detector Assembly",20,"EA",null,{"$f":"IF(F98=\"\",\"\",(D98*(ROUND(F98,2))))","v":""}]
[null,"5.2","Two-Detector Assembly",15,"EA",null,""]
[null,"5.3","Three-Detector Assembly",10,"EA",null,""]
[null,"5.4","Four-Detector Assembly",5,"EA",null,""]
[null,null,"Components and Replacement Parts"]
[null,"5.5","720P HD Sensor",5,"EA",null,{"$f":"D103*F103","v":{"v":0,"d":"$0.00"}}]
[null,"5.6","6' Mounting Kit",5,"EA",null,{"$f":"IF(F104=\"\",\"\",(D104*(ROUND(F104,2))))","v":""}]
[null,"5.7","Standard Mounting Kit",5,"EA",null,{"$f":"F105*D105","v":{"v":0,"d":"$0.00"}}]
[null,"5.8","Cable",15000,"LF",null,{"$f":"IF(F106=\"\",\"\",(D106*(ROUND(F106,2))))","v":""}]
[null,"5.9"," Communication Manager",5,"EA",null,{"$f":"IF(F107=\"\",\"\",(D107*(ROUND(F107,2))))","v":""}]
[null,null,"Support Services"]
[null,"5.10","Tehnical Support",200,"HR",null,{"$f":"IF(F109=\"\",\"\",(D109*(ROUND(F109,2))))","v":""}]
[null,"GRAND TOTAL FOR SECTION 5",{"$nulls":4},{"$f":"SUM(G98:G109)","v":{"v":0,"d":"$0.00"}}]
[]
[null,"SECTION 6 - Passive Pedestrian Detection System"]
[null,null,"Pedetrian Detection System"]
[null,"6.1","One-Pair Detection System",5,"EA",null,{"$f":"IF(F114=\"\",\"\",(D114*(ROUND(F114,2))))","v":""}]
[null,"6.2","Two-Pair Detection System",1,"EA",null,""]
[null,"6.3","Three-Pair Detection System",1,"EA",null,""]
[null,"6.4","Four-Pair Detection System",1,"EA",null,""]
[null,null,"Components and Replacement Parts"]
[null,"6.5","Pedestrian Detector",5,"EA"]
[null,"6.6","Mounting Kit",5,"EA",null,{"$f":"IF(F120=\"\",\"\",(D120*(ROUND(F120,2))))","v":""}]
[null,"6.7","Cable",5000,"LF",null,{"$f":"IF(F121=\"\",\"\",(D121*(ROUND(F121,2))))","v":""}]
[null,"6.8","Cable junction box",5,"EA",null,""]
[null,"6.9","Surge protector",5,"EA",null,""]
[null,"6.10","Power Supply",5,"EA",null,""]
[null,"6.11","Communication/processor Module",5,"EA",null,{"$f":"IF(F125=\"\",\"\",(D125*(ROUND(F125,2))))","v":""}]
[null,null,"Support Services"]
[null,"6.12","Tehnical Support",200,"HR",null,{"$f":"IF(F127=\"\",\"\",(D127*(ROUND(F127,2))))","v":""}]
[null,"GRAND TOTAL FOR SECTION 6",{"$nulls":4},{"$f":"SUM(G114:G127)","v":{"v":0,"d":"$0.00"}}]
[null,"NOTES:"]
[]
[null,1,"Refer to Arlington County Traffic Signal Specifications and the Supplemental Specifications (Attachment A) included as part of the ITB. "]
[null,2,"Bidders may choose which Section(s) to bid. Every line item in a Section must be completed in order to be deemed responsive. "]