Spreadsheet: 750831d1633665428-using-conditional-formatting-to-highlight-rows-conditional-formatting-based-on-keyword-rgrohman-
Sheet: Sheet1

 | Siding
Keywords | Type | [NAME] | Contact 1 | Contact 1 # | Contact 2 | Contact 2 # | Office# | [NAME] 1 | [NAME] 2 | Address | City | St. | Zip | Counties Served | MSA | Notes
Annual Plantings, Flowers, Arbor Construction, Artificial Grass Installation, [NAME] and Stone Driveway Installation, [NAME] or Stone Driveway Repair, Brush Removal, Decorative Wall Construction, Drainage Systems Construction and Installation, Drip Irrigation Installation, Erosion Control | Landscaping | [NAME] | [NAME] | [PHONE] |  |  |  | [EMAIL] |  | Post Office Box 372 | Campbelltown | PA | 17010 | Lebanon/Dauphin | No
Fence, fencing | Fencing | Tyson Fence Co. | [NAME] | [PHONE] |  |  | [PHONE] | [EMAIL] |  | 7970 [NAME] Rd | Harrisburg | PA | 17111 | 45 Minutes from Harrisburg | No
Fire Alarms, [NAME], Fire Suppression, Security, Communications, Audio, Video, Monitoring | Life Safety | Berkshire Systems Group | [NAME] | [PHONE] | [NAME] | [PHONE] | [PHONE] | [EMAIL] | [EMAIL] | 50 S Museum Rd | Reading | PA | 19607 | Statewide | Yes
Intrusion Alarms, Burglar Alarm, Fire Alarms, Access Control, Surveillance, Intercom, Monitoring | Life Safety/Security | Alwine Security | [NAME] | [PHONE] | [NAME] | [PHONE] | [PHONE] | [EMAIL] | [EMAIL] | 208 E Main St | Brownstown | PA | 17508 | Lancaster, Chester, Berks, Lebanon, York, Adams, Cumberland, [NAME], [NAME] and [NAME] | Yes
Roofing, Shingle, Gutters, Siding, Sheet Metal | Roofing/Siding | Allied Roofing | [NAME] | [PHONE] | [NAME] | [PHONE] | [PHONE] | [EMAIL] | [EMAIL] | 340 Pleasant View Rd | New Cumberland | PA | 17070 |  | Yes
Painting | Painting | [NAME] | [NAME] | [PHONE] |  |  |  | [EMAIL] |  | 18 Railroad Ave | Shiremanstown | PA | 17011 |  | Yes
Paving, Paving Repairs, Sealcoating, Line Striping, Crack Repair | Paving/Seal Coating | A+ Seal Coating and Paving | [NAME] | (717) 490-9300 |  |  | (717) 458-4548 | [EMAIL] |  | 5130 E Trindle Rd | Mechanicsburg | PA | 17050 |  | Yes
Painting | Painting | Capital Painting | [NAME] | (717) 379-0702 |  |  |  | [EMAIL] |  |  |  |  |  |  | Yes
Electric, Electrical, Lighting Upgrade | Electrical | [NAME] | [NAME] | [PHONE] | [NAME] | [PHONE] | [PHONE] | [EMAIL] | [EMAIL] |  |  |  |  |  | Yes
Painting | Painting | Certipro | [NAME] | (717) 761-2248 |  |  |  | [EMAIL] |  |  |  |  |  | Cumberland, York, Dauphin, Lebanon, [NAME] and Adam’s | Yes
Water Sediment Removal Process, Landscape Maintenance, Snow Removal | Landscaping/Snow Removal | [NAME] | [NAME] | [PHONE] | [NAME] | [PHONE] | [PHONE] | [EMAIL] | [EMAIL] |  |  |  |  |  | Yes
plumbing, heating, air conditioning, electrical contractors, design build | Plumbing/Electrical/Mechanical/HVAC | D&T Mechanical Contractor | [NAME] | [PHONE] |  |  |  | [EMAIL] |  |  |  |  |  |  | Yes
Sprinkler Design, Sprinkler Installations, Sprinkler Service, Sprinkler Repairs, Sprinkler inspections | Fire Safety | Diamond Automatic Sprinklers | [NAME] | (717) 486–5755 |  |  |  | [EMAIL] |  |  |  |  |  | Cumberland, Perry, Dauphin, York, Adams, Franklin, Lancaster | Yes
Elevator Inspection | Elevator Inspections | Dominion Elevator | [NAME] | (410) 493-1060 |  |  |  | [EMAIL] |  |  |  |  |  |  | Yes
HVAC, Lighting Control, Access Control, Elevator Access, Energy Management, HVAC Installation, HVAC Service, HVAC [NAME], [NAME], Water Loop Piping, Water Source Heat Pumps, Electrical, Vacuum Systems | HVAC/Mechanical/Controls/Electrical | Dynamech | [NAME] | [PHONE] |  |  |  | [EMAIL] |  |  |  |  |  |  | Yes
Plumbing, HVAC, Energy Savings, Fabrication, Healthy Spaces | HVAC/Mechanical/Plumbing | Enginuity | [NAME] | (717) 443-6393 |  |  | [PHONE] | [EMAIL] |  |  |  |  |  |  | Yes
Cleaning, Cleaners | Cleaning | Facility Concierge Services | [NAME] | [PHONE] |  |  |  | [EMAIL] |  |  |  |  |  |  | Yes
Decals, Labels, & Stickers, Electrical Signs, ADA & Regulatory Signage, Vehicle Graphics, Wayfinding & Directional Signage, Yard & Site Signs, [NAME], [NAME], Event & Display Counter Graphics, Pop-Up Displays, Trade Show Displays, [NAME], Prints & Fine Art, Vinyl Lettering, Wall Graphics, [NAME], Digital Display Board, Digital Kiosks, Digital Menu Boards, Interactive Digital Signage, LED Displays, Banners & Flags, Floor Graphics, Menu Boards, Point of Purchase Posters, Standees & Cutouts, Business Cards, Direct Mail, Letterhead, Printed Posters, Sales Collateral, Promotional Clothing & Wearables, Promotional Giveaways, Promotional Inflatables, Promotional Writing Instruments, Recognition & Awards | Signage | Fast Signs (Harrisburg) | [NAME] | [PHONE] |  |  | [PHONE] | [EMAIL] |  |  |  |  |  |  | Yes
Decals, Labels, & Stickers, Electrical Signs, ADA & Regulatory Signage, Vehicle Graphics, Wayfinding & Directional Signage, Yard & Site Signs, [NAME], [NAME], Event & Display Counter Graphics, Pop-Up Displays, Trade Show Displays, [NAME], Prints & Fine Art, Vinyl Lettering, Wall Graphics, [NAME], Digital Display Board, Digital Kiosks, Digital Menu Boards, Interactive Digital Signage, LED Displays, Banners & Flags, Floor Graphics, Menu Boards, Point of Purchase Posters, Standees & Cutouts, Business Cards, Direct Mail, Letterhead, Printed Posters, Sales Collateral, Promotional Clothing & Wearables, Promotional Giveaways, Promotional Inflatables, Promotional Writing Instruments, Recognition & Awards | Signage | Fast Signs (Mechanicsburg) | [NAME] | [PHONE] |  |  | (717) 737-4467 | [EMAIL] |  |  |  |  |  |  | No
[NAME], Building Exterior Washing, Building Interior Washing, Sidewalk Washing and Gum Removal, Warehouse and Shop [NAME], [NAME], Loading Dock Cleaning, Rust Stain Removal, [NAME], Paver Restoration, Concrete Cleaning and Sealing, [NAME], [NAME] and Common Area Washing | Power Washing | Full Blast Pressure Washing | [NAME] | [PHONE] |  |  |  | [EMAIL] |  |  |  |  |  |  | Yes
Doors, Windows, [NAME], Store Fronts, Door Hardware | Doors/Windows/Glass | Hershocks | Gregory Deaven | [PHONE] | [NAME] | [PHONE] | [PHONE] | [EMAIL] | [EMAIL] | 3501 N. 6th Street, P.O. Box 5800 | Harrisburg | PA | 17110 |  | Yes
Cleaning, Cleaners | Cleaning | [NAME] | [NAME] | [PHONE] |  |  | [PHONE] | [EMAIL] |  |  |  |  |  |  | Yes
[NAME], Fire Suppression System, Fire Alarm System, Security Alarm System, Card Access System, Emergency / Exit Lighting, Gas Detection System, Sprinkler System, [NAME] | Life Safety | Kint | [NAME] | [PHONE] | [NAME] | [PHONE] |  | [EMAIL] | [EMAIL] |  |  |  |  |  | Yes
Access Control, CCTV, Security Alarms, Fire Alarms | Life Safety | LowV | [NAME] | [PHONE] | [NAME] | [PHONE] | [PHONE] | [EMAIL] | [EMAIL] | 114 [NAME] D | Mechanicsburg | PA | 17055 |  | Yes
Building Automation Systems (BAS/ATC), Card Access,  Security Systems,  Energy Star Services, Lighting Control Systems | Controls | NRG Controls | [NAME] | [PHONE] |  |  | [PHONE] | [EMAIL] |  | 48 S Harrisburg St | [NAME] | PA | 17113 |  | Yes
Building Automation Systems, Design/Build Services, [NAME] to [NAME] upgrades, Building Automation System integrations, Service Support Agreements | Controls | OAESYS | Caleb Wise | (717) 585-2461 | [NAME] | (717) 645-4566 | (717) 585-6190 | [EMAIL] | [EMAIL] | 806 South 29th Street, Suite A | Harrisburg | PA | 17111 |  | Yes
Pest Control | Pest Control | [NAME] | [NAME] | [PHONE] | [NAME] | [PHONE] | [PHONE] | [EMAIL] | [EMAIL] | 4450 [NAME] | Harrisburg | PA | 17111 |  | Yes
Garage Doors, Door Operators, Loading Dock Equipment | Doors | Overhead door | [NAME] | [PHONE] |  |  | [PHONE] | [EMAIL] |  |  |  |  |  |  | Yes
Generator Service | Generator Service | Penn Power Systems |  |  |  |  |  |  |  |  |  |  |  |  | Yes
Facility Services Division, General Construction, Design/Build, Construction Management | Construction | Pyramid |  |  |  |  |  |  |  |  |  |  |  |  | Yes
Cleaning, Cleaners | Cleaning | ServiceMaster |  |  |  |  |  |  |  |  |  |  |  |  | Yes
Cleaning, Cleaners | Cleaning | Sheffield |  |  |  |  |  |  |  |  |  |  |  |  | Yes
Plumbing, Heating, HVAC, Sprinkler Systems, Mechanical | Mechanical/HVAC | S&L Mechanical | [NAME] | [PHONE] | [NAME] | [PHONE] 103 | [PHONE] | [EMAIL] | [EMAIL] |  |  |  |  |  | Yes
Pest Control | Pest Control | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | Yes
Lawn Plan, Aeration, Disease Control, Fertilization, [NAME], [NAME], Insect Control, Lime Application, Natural/Organic Lawn Care, Nuisance Pest Control, Seeding, Plugging, Pre-Emergent Weed Control Applications, [NAME], Vegetation Control, [NAME], Weed Control for Ornamental Plant Beds, Tree & Shrub Plan, Apple Scab Service, Disease Control, [NAME], Insect Control Japanese Beetle Control, Scale Insect Control, [NAME], Tree Drench Injection, Geese Repellent | Lawn Care | TruGreen |  |  |  |  |  |  |  |  |  |  |  |  | Yes
Generator Service, Generator Emergency Service | Generator Service | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | Yes
 | Fire Sprinkler Systems | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | Yes
Doors, Windows, [NAME], Store Fronts, Door Hardware | Doors/Windows/Glass | Weavers [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | Yes
 |  | Water Treatment by Design |  |  |  |  |  |  |  |  |  |  |  |  | Yes
Heating, Cooling, Refrigeration, Food Service Equipment, Water Heaters, Air and water Quality, Green Solutions |  | Thermotech
 |  | A.L. Fence | [NAME] |  |  |  |  | [EMAIL]