{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["signal equip","street light","marking & signing"],"not_rendered":{"macros":1,"external_links":1,"defined_names":2},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"signal equip","index":0,"n_rows":105,"n_cols":18,"rows_kept":105,"merged":[[0,0,0,2],[1,0,1,3],[2,0,2,2],[3,0,3,4],[5,5,5,17]],"flags":["formulas_cached_only"]}
["CITY OF OVERLAND PARK, KANSAS"]
["Department of Public Works - Traffic Services Division"]
["Last Revised:   1/25/02"]
["APPROVED MANUFACTURERS - TRAFFIC SIGNAL EQUIPMENT SUMMARY"]
[]
[{"$nulls":4},"Sole","Approved Manufacturers"]
[null,null,"Item","OP Spec.","Source(s)","#1","#2","#3","#4","#5","#6","#7","#8","#9","#10","#11","#12","#13"]
[1,null,"Signal Heads"]
[null,"a","Vehicular Signal Head",null,null,"Auto/Eagle","TCT","Eagle Durasig","Peek Traffic","Indicator Controls, IDC"]
[null,"b","One-Section Pedestrian Signal Head","Model 7090",null,"IDC (Indicator Controls)","McCain Traffic Supply"]
[null,"c","LED Lens (Red)","DuraLED 433-1210-003","X","DiaLight"]
[null,"d","LED Lens (Yellow)","DuraLED 433-3230-001","X","DiaLight"]
[null,"e","LED Lens (Green)","DuraLED 433-2270-001A","X","DiaLight"]
[null,"f","LED Lens (Orange Hand/White Man)","Model 430-6472-001","X","DiaLight"]
[null,"g","LED Single Arrow Kit (Yellow)","430-3334-001","X","DiaLight"]
[null,"h","LED Single Arrow Kit (Green)","430-2374-001","X","DiaLight"]
[null,"i","LED Dual Arrow Kit","430-6370","X","DiaLight"]
[2,null,"Signal Head Brackets"]
[null,"a","Mastarm Signal Head Bracket  (Astro Brac)","AB-125 w/AB3009","X","Pelco"]
[null,"b","Side-Mount Signal Head Bracket",null,null,"Auto/Eagle","Gades","Durasig","Component Products"]
[null,"c","Pedestal Pole Bracket",null,null,"Auto/Eagle","Gades"]
[null,"d","Pedestrian Head Bracket  (clamshell mount)","Model 4805","X","ICC (Indicator Controls)"]
[null,"e","Mini Bracket (Pre-empt detector)","AB-0132-19","X","Pelco"]
[3,null,"Backplates"]
[null,"a","Backplate (Vehicular Signal)",null,null,"Gades Sales","Mid-American","Pelco","Traffic Controls"]
[4,null,"Signal Head Lamps"]
[null,"a","135 Watt Lamp",null,"X","National Lighting"]
[null,"b","105 Watt Lamp",null,"X","National Lighting"]
[5,null,"Pedestrian Pushbutton"]
[null,"a","Pedestrian Pushbutton (ADA Approved)",null,null,"Auto/Eagle","Pelco","TEECO P3-80044"]
[6,null,"Signal Poles"]
[null,"a","Galvanized Steel Signal Pole",null,null,"Valmont","Union Metal","Ameron"]
[null,"b","Aluminum Pedestrian Pole",null,null,"Gades Sales","Pelco","Bliss Eagle","MidAmerican","Comp. Prod. Inc."]
[7,null,"Junction Boxes & Service Boxes"]
[null,"a","Type I Junction Box",null,null,"Quazite","Assoc. Plastics","CDR","Armorcast","Whately Inc."]
[null,"b","Type II Junction Box",null,null,"Quazite","Armorcast","Assoc. Plastics"]
[null,"c","Type III Junction Box",null,null,"Quazite","Armorcast"]
[null,"d","Type 'FO' Fiber Optic Service Box",null,null,"Quazite","CDR","Armorcast"]
[null,"e","Standard Traffic Service Box",null,null,"Quazite","CDR","Barbour","Assoc. Plastics"]
[8,null,"Aluminum Service Enclosures"]
[null,"a","Service Enclosure","MET2-VLM-TS ","X","Myers"]
[null,"b","Service Enclosure w/Photocell","MET2-VLM-1","X","Myers"]
[9,null,"Grounding Equipment"]
[null,"a","Ground Rod (1/2\" x 10')",null,null,"Apache","Blackburn","Carolina","Josyln","Knight","LH Dottle"]
[null,"b","Ground Rod Clamp (1/2\")",null,null,"Apache","Blackburn JABH Type","Carolina","Josyln","Knight","LH Dottle","Burndy","Ilsco"]
[null,"c","Ground Wire (Bare Copper # 6 AWG)",null,null,"General Cable","Power-duct","Rome","Southwire","Tamaqua","Triangle","Copper Products?","Cerowire"]
[10,null,"Cable"]
[null,"a","Service Wire (USE # 2 AWG)",null,null,"General Cable","Power-duct","Rome","Southwire","Tamaqua","Triangle","Diamond","Laribee","TW ComCorp","Senator"]
[null,"b","Multi-conductor Signal Cable (7c # 14 AWG)",null,null,"American Insul.","Anixter","BSCC","Chester","Clifford","Energy","Independent","TW ComCorp","Pirelli","James Monroe","Essex","Rome","Belden"]
[null,"c","Shielded Detector Lead-in (2c # 14 AWG)",null,null,"Anixter","Badger Wire","BSCC","Chester","Clifford","Independent","TW Comcorp.","3M Model 3003 ","James Monroe","Essex",null,"Belden"]
[null,"d","Loop Cables (1c # 14 AWG)",null,null,"Anixter","BSCC","Chester","Clifford","Independent","ElectroWire","TW ComCorp","Std. Wire Cable","James Monroe","Kris-Tech Wire Co.","Falcon Fine Wire"]
[null,"e","Microloop Home Run Cable"]
[null,"f","Precision Video Detection Cable (COMM)","8281F 75 Ohm",null,"Belden"]
[null,"g","Video Detection Power Cable (3c # 14 AWG)",null,null,"American Insul.","Anixter","BSCC","Chester","Clifford","Energy","Independent","TW ComCorp","Pirelli","James Monroe","Essex","Rome","Belden"]
[null,"h","Pre-empt  Detector Cable","Model 138","X","3M"]
[null,"i","Non-Invasive Microloop Probes Home Run Cable","Model C30003","X","3M"]
[11,null,"Detectors"]
[null,"a","Microloop Probe"]
[null,"b","Pre-empt Detector","Model 721","X","3M"]
[null,"c","Microwave Vehicular Detector","Model TC-20","X","Microwave Sensors"]
[null,"d","Two-Channel Vehicle Detector","Model C822","X","3M "]
[null,"e","Four-Channel Vehicle Detector","Model C824","X","3M "]
[null,"f","Non-Invasive Microloop Probes/Carriers & Kits","Model 702","X","3M"]
[null,"g","Video Isolation Unit","ML108A","X","MIL-Lektron","Edco"]
[null,"h","High Resolution Video Camera",null,null,"Peek Traffic VPK351A","Iteris"]
[null,"i","Video Processing Unit",null,null,"Peek  Video Trak-905"]
[12,null,"Conduit and Fittings"]
[null,"a","Rigid Metallic Conduit (RMC)",null,null,"Allied","Galvite","Triangle","Western Tube","Wheatland","LTV","Sawhill - Steelduct"]
[null,"b","RMC Fittings",null,null,"Conduit Pipe ","Picoma","Shamrock"]
[null,"c","RMC Elbows",null,null,"Conduit Pipe ","Picoma","Shamrock"]
[null,"d","RMC Bushings",null,null,"Bridgeport","Lazy-lug","LH Dottie","NEER","Regal","Thomas & Betts","Steel City","Raco","OZ-Gedney","Arlington Ind (C-clamp)"]
[null,"e","PVC Conduit",null,null,"Cantex","Carlon","Certain-Teed"]
[null,"f","PVC Conduit Fittings",null,null,"Cantex","Carlon"]
[null,"g","PVC Conduit Elbows",null,null,"Cantex","Carlon"]
[null,"h","HDPE Fiber Optic Conduit","Schedule 40 (Orange)",null,"P.N.A.","Dura-Line","ETCO","ARNCO"]
[null,"i","HDPE Conduit Couplings",null,null,"P.N.A. (ELOC)","Dura-Line (ELOC)","ETCO (ELOC)","ARNCO","Cabletec"]
[null,"j","Expansion Couplings (@ bridges)"]
[13,null,"Fiber Optic Conduit Markers"]
[null,"a","Fiber Optic Conduit Markers","Orange",null,"J. Miller Industries","Carsonite"]
[14,null,"Loop Sealants"]
[null,"a","Loop Sealant",null,null,"Crafco PN221","3M","Triram PR26HA","Bondo E-709"]
[15,null,"Controller Cabinet"]
[null,"a","170 Pole-mount Cabinet",null,null,"SafeTran","Sig. Control Co."]
[null,"b","170 Pad-mount Cabinet",null,null,"SafeTran","Sig. Control Co."]
[null,"c","Standard 170 Pad-mount Cabinet","Model 332, etc.",null,"SafeTran","Sig. Control Co.","Eagle"]
[16,null,"Controller & Equipment"]
[null,"a","Signal Controller","170; 170E acceptable",null,"Auto/Eagle/SafeTran","Peek Traff/Sig.","SafeTran","Sig. Control Co."]
[null,"b","Conflict Monitor","Model 210P",null,"IDC Solid State","EDI 210E","Solid State Dev."]
[null,"c","Program Module","Model 470 I",null,"Auto/Eagle/SafeTran","SafeTran","Sig. Control Co."]
[null,"d","Flasher","Model 204",null,"Eberle Design","PDC","Traffic Sensor","EDI 810"]
[null,"e","Load Switch","Model 200",null,"Eberle Design","PDC","Traffic Sensor","EDI 510"]
[null,"f","Flasher Transfer Relay","Model 430",null,"Magncraft Elec","Midtex Relays "]
[null,"g","Surge Protector","EDCO SHA-1210","X","EDCO"]
[null,"h","DC Isolator","Model 242",null,"General Devices","PDC"]
[null,"I","AC Islolator","Model 252",null,"PDC"]
[null,"j","Pre-emption Phase Descriminator","Model 752","X","3M"]
[17,null,"Miscellaneous Brackets"]
[null,"a","Detector Camera Mounting Bracket (Lum Arm)","SH-0502-10",null,"Pelco"]
[null,"b","Detector Camera Mounting Bracket (Mast Arm)","AB-0164-1-62",null,"Pelco"]
[null,"c","Mast Arm Sign Bracket","Model AB-0142-A-L",null,"Pelco"]
[]
[]
[]
[]
[null,null," "]

{"sheet":"street light","index":1,"n_rows":58,"n_cols":15,"rows_kept":58,"merged":[[0,0,0,2],[1,0,1,3],[3,0,3,5],[5,5,5,14]],"flags":["formulas_cached_only"]}
["CITY OF OVERLAND PARK, KANSAS"]
["Department of Public Works - Traffic Services Division"]
["Last Revised:   1/25/02"]
["APPROVED MANUFACTURERS - STREET LIGHTING EQUIPMENT SUMMARY"]
[]
[{"$nulls":4},"Sole","Approved Manufacturers"]
[null,null,"Item","OP Spec.","Source(s)","#1","#2","#3","#4","#5","#6","#7","#8","#9","#10"]
[1,null,"Junction Boxes &Service Boxes"]
[null,"a","Type I Junction Boxes",null,null,"Quazite","Associated Plastics","CDR","Armorcast","Whately Inc."]
[null,"b","Type II Junction Boxes",null,null,"Quazite","Associated Plastics","CDR"]
[null,"c","Standard Service Boxes",null,null,"Quazite","Associated Plastics"]
[null,"d","Type 'FO' Fiber Optic Service Box",null,null,"Quazite","CDR"]
[2,null,"Luminaires"]
[null,"a","Cobra-head Luminaire",null,null,"GE","Hubbell"]
[null,"b","Highway Luminaire",null,"X","GE"]
[null,"c","Post-top Luminaire",null,null,"Holophane (RSL-350)","Sentry Hamlet (SLH)"]
[null,"d","Ornamental Post-Top"]
[3,null,"Lamps"]
[null,"a","High Pressure Sodium (HPS)","100w,150w,250w,310w,400w",null,"GE","Sylvania"]
[4,null,"Connector Kits & Fuses"]
[null,"a","Un-fused Disconnect",null,"X","Elastimold 20"]
[null,"b","Fused Disconnect",null,null,"Elastimold 65","Tron HEB-AW-RLCA"]
[null,"c","Fuse (8 Amp)",null,null,"Bussman KTK","Gouldshaw AT","Littelfuse","Ferraz Shawmut"]
[null,"d","Connector",null,null,"Fargo Go-32","Connector Mfg SLK-112I"]
[5,null,"Photocell"]
[null,"a","Photocell",null,"X","ALR-SST"]
[6,null,"Grounding Equipment"]
[null,"a","Ground Rod","1/2\" x 10'",null,"Apache","Blackburn","Carolina","Josyln","Knight","LH Dottle"]
[null,"b","Ground Rod Clamp","1/2\"",null,"Apache","Blackburn","Carolina","Josyln","Knight","LH Dottle"]
[null,"c","Ground Wire (Copper # 4 AWG)"]
[7,null,"Cable"]
[null,"a","Service Wire (USE # 2 AWG)","600V Rating",null,"General Cable","Power-Duct","Rome","Southwire","Tamaqua","Triangle","Senator"]
[null,"b","Distribution Cable (USE # 4 AWG)",null,null,"Southwire","Essex"]
[null,"c","Pole Cable (THHN/THWN # 10 AWG)",null,null,"Southwire","General Cable","Senator","Essex"]
[8,null,"Conduit and Fittings"]
[null,"a","Rigid Metallic Conduit (RMC)",null,null,"Alleid","Galvite","Triangle","Western Tube","Wheatland","LTV"]
[null,"b","RMC Fittings",null,null,"Conduit Pipe ","Picoma","Shamrock"]
[null,"c","RMC Elbows",null,null,"Conduit Pipe ","Picoma","Shamrock"]
[null,"d","RMC Bushings",null,null,"Bridgeport","Lazy-lug","LH Dottie","NEER","Regal","Thomas & Betts","Steel City","Raco"]
[null,"e","PVC Conduit",null,null,"Cantex","Carlon","Certain-Teed"]
[null,"f","PVC Conduit Fittings",null,null,"Cantex","Carlon"]
[null,"g","PVC Conduit Elbows",null,null,"Cantex","Carlon"]
[null,"h","HDPE Fiber Optic Conduit","Schedule 40 (Orange)",null,"P.N.A.","Dura-line","ARNCO"]
[null,"I","HDPE Street Lighting Conduit","Schedule 40 (Grey)",null,"P.N.A.","Dura-line","ARNCO"]
[null,"j","HDPE Conduit Couplings",null,null,"P.N.A. (ELOC)","Dura-line (COMFIT)","Dura-line (ELOC)","ARNCO","Cabletec"]
[null,"k","Expansion Couplings (@ bridges)"]
[9,null,"Break-away Couplings"]
[null,"a","Break-away Couplings",null,"X","PFI"]
[10,null,"Pole Foundations"]
[null,"a","Screw-in Foundations",null,null,"AB Chance","Dixie","JH Botts"]
[11,null,"Aluminum Control Centers"]
[null,"a","Aluminum Control Center",null,null,"Meyers","Pacific Utility Products","Milbank"]
[12,null,"Aluminum Poles"]
[null,"a","Street Light Poles, 30' & 40' MH's",null,null,"Hapco","Union Metal","Valmont","P&K","Pole Lite"]
[null,"b","Street Light Poles, 14' MH",null,null,"Hapco","Valmont"]
[]
[]
[{"$nulls":3},"Approved but no official notice has been sent out yet"]

{"sheet":"marking & signing","index":2,"n_rows":30,"n_cols":15,"rows_kept":30,"merged":[[0,0,0,2],[1,0,1,3],[3,0,3,6],[5,5,5,14]],"flags":["formulas_cached_only"]}
["CITY OF OVERLAND PARK, KANSAS"]
["Department of Public Works - Traffic Services Division"]
["Last Revised:   1/25/02"]
["APPROVED MANUFACTURERS - PAVEMENT MARKING & SIGNING EQUIPMENT SUMMARY"]
[]
[{"$nulls":4},"Sole","Approved Manufacturers"]
[null,null,"Item","OP Spec.","Source(s)","#1","#2","#3","#4","#5","#6","#7","#8","#9","#10"]
[1,null,"Cold Plastic"]
[null,"a","Cold Plastic Pavement Markings",null,null,"3-M company"]
[null,"b","Cold Plastic Symbol Markings",null,null,"3-M company"]
[2,null,"Thermoplastic"]
[null,"a","Thermoplastic Pavement Markings",null,null,"Catophote","Swarco","Brite-line"]
[null,"b","Thermoplastic Symbol Markings",null,null,"Catophote","Swarco","Brite-line"]
[3,null,"Preformed Thermoplastic Tape"]
[null,"a","Preformed Thermoplastic Tape",null,null,"Flint Trading Co.","Avery-Denison"]
[4,null,"Traffic Paint"]
[null,"a","Yellow Paint",null,null,"Rich Paint","Centerline","Ennis Paint"]
[null,"b","White Paint",null,null,"Rich Paint","Centerline","Ennis Paint"]
[5,null,"Glass Beads"]
[null,"a","Glass Beads",null,null,"Flex-O-Lite","Potters Industries","Swarco","Catophote"]
[6,null,"Aluminum Sign Faces"]
[null,"a","Aluminum Sign Faces",null,null,"National Sign","Hall Sign","Vulcan Sign","Newman"]
[7,null,"Sign Sheeting"]
[null,"a","Sign Sheeting",null,null,"3-M company","Avery-Denison"]
[8,null,"Sign Brackets"]
[null,"a","Sign Brackets",null,null,"National Sign","Hall Sign","Vulcan Sign"]
[9,null,"Sign Posts"]
[null,"a","Sign Posts 1 3/4\" x 1 3/4\"",null,null,"Unistrut","National","Newman"]
[null,"b","Anchor 2\" x 2\" x 3'",null,null,"Unistrut"]
[null,"c","Sleeves 2 1/4\" x 2 1/4\" x 18\"",null,null,"Unistrut"]