Spreadsheet: 717508d1612707570-index-match-problem-i-cant-seem-to-fix-job-tracking-experimental
Sheet: Data Field

 | LOCATION DATA |  |  |  |  |  | Customer Project Managers |  |  |  |  | Project Managers |  |  |  |  | Contract | Validation |  | Sub Contractors |  |  |  |  |  |  |  |  |  |  |  | Vendors | Validation | Duration Reason
 | [NAME] | STREET ADDRESS | CITY | STATE | ZIP |  | Project Manager | E-Mail | Phone Main | Phone Cell |  | BMS Project Manager | E-Mail | Phone Main | Phone Cell |  |  |  |  | Engineering & Testing | Electric | Sheet Metal | Mechanical | Pipe Fitting | Controls | Rigging | Plumbing | Balancing | Insulation | Cleaning & Misc | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes
 | Abingdon Medical Center | 3400 Box Hill Corporate Center Drive | Abingdon | MD | 21009 |  |  |  |  |  |  |  |  |  |  |  |  | No
 | Alexandria Medical Center | 3000 Potomac Avenue | [NAME] | VA | 22306
 | Annapolis Medical Center | 888 Bestgate Road, Suite 111 | [NAME] | MD | 21401
 | Anne Arundel Medical Center | 2001 Medical Parkway | [NAME] | MD | 31401
 | Ashburn Medical Center | 43480 Yukon Drive | [NAME] | VA | 20147
 | Baltimore Harbor Medical Center | 815 E. Pratt Street | Baltimore | MD | 21202
 | Baltimore Washington Medical Center | 301 Hospital Drive | [NAME] | MD | 21061
 | Burke Medical Center | 5999 Burke Commons Road | Burke | VA | 22015
 | Camp Springs Medical Center | 6104 Old Branch Ave. | Temple Hills | MD | 20748
 | Capitol Hill Medical Center | 700 2nd St. NE | Washington | DC | 20002
 | Children's National Medical Center | 111 Michigan Ave NW | Washington | DC | 20010
 | Columbia Gateway Medical Center | 7070 [NAME] | Columbia | MD | 21046
 | Doctors Community Hospital | 8118 [NAME]. | Lanham | MD | 20706
 | Fair Oaks Medical Center | 12255 Fair Lakes Parkway | Fairfax | VA | 22033
 | Falls Church Medical Center | 201 N. Washington St. | Falls Church | VA | 22046
 | Frederick Medical Center | 7190 Crestwood Blvd. | [NAME] | MD | 21703
 | Fredericksburg Medical Center | 1201 Hospital Drive | Fredericksburg | VA | 22401
 | Gaithersburg Medical Center | 655 Watkins Mill Road | Gaithersburg | MD | 20879
 | Greater Baltimore Medical Center | 6701 North Charles Street | Baltimore | MD | 21204
 | Haymarket Medical Center | 15050 Heathcote Blvd | Haymarket | VA | 20169
 | Holy Cross Hospital | 1400 Forest [NAME] | Silver Spring | MD | 20910
 | Kensington One Medical Center | 10810 Connecticut Ave. | Kensington | MD | 20895
 | Kensington Two Medical Center | 10812 Connecticut Ave. | Kensington | MD | 20895
 | Largo Medical Center | 1221 Mercantile Lane | Upper Marlboro | MD | 20774
 | Manassas Medical Center | 10701 [NAME] | Manassas | VA | 20109
 | Marlow Heights Medical Center | 5100 Auth Way | Suitland | MD | 20746
 | North Arundel Medical Center | 7670 Quarterfield Road | [NAME] | MD | 21061
 | Northwest D.C. Medical Office Building | 2301 M Street NW | Washington | DC | 20037
 | Physician's Office Building - Holy Cross Hospital | 1500 Forest [NAME] | Silver Spring | MD | 20910
 | Prince George's Medical Center | 6525 Belcrest Road | [NAME] | MD | 20782
 | Regional HQ | [NAME] | Rockville | MD | 20852
 | Reston Hospital Center | 1850 Town Center Parkway | Reston | VA | 20190
 | Reston Medical Center | 1890 Metro Center Drive | Reston | VA | 20190
 | [NAME] | 6111 Executive Blvd. | Rockville | MD | 20852
 | Shady Grove Medical Center | 1396 [NAME] | Rockville | MD | 20850
 | Sibley Memorial Hospital | 5255 Loughboro Road, N.W. | Washington | DC | 20016
 | Silver Spring Medical Center | 12201 Plum Orchard Drive | Silver Spring | MD | 20904
 | South Baltimore County Medical Center | 1701 Twin Springs Road | Halethorpe | MD | 21227
 | Springfield Medical Center | 6501 Loisdale Court | Springfield | VA | 22150
 | Stafford Medical Center | 125 Hospital Center Blvd | Stafford | VA | 22556
 | Stafford Hospital | 101 Hospital Center Blvd. | Stafford | VA | 22554
 | Sterling Pharmacy | 22370 [NAME] | Sterling | VA | 20164
 | [NAME] | 8600 Old Georgetown Road | Bethesda | MD | 20814
 | Suite N | 11941 [NAME] | Silver Spring | MD | 20904
 | Towson Medical Center | 1447 York Road, Suite 100 | Lutherville | MD | 21093
 | Tysons Corner Medical Center | 8008 Westpark Dr. | McLean | VA | 22102
 | Virginia Hospital Center | 1701 N. George Mason Drive | Arlington | VA | 22205
 | Washington Hospital Center | 110 Irving Street, NW | Washington | DC | 20010
 | White Marsh Medical Center | 4920 Campbell Blvd. | [NAME] | MD | 21236
 | Woodbridge Medical Center | 14139 Potomac Mills Road | [NAME] | VA | 22192
 | Woodlawn Medical Center | 7141 Security Blvd. | Baltimore | MD | 21244
 | [NAME] | 118 South River Clubhouse Road | [NAME] | MD | 21037
 | [NAME] | 3845 North Military Road | Arlington | VA | 22203
 | Crown [NAME] | 11123 Race Track Road | Berlin | MD | 21811
 | [NAME] | 5202 River Road | Bethesda | MD
 | Crown Castle Bowling Green | 21425 AP Hill Blvd | Bowling Green | VA | 22427
 | Crown Castle Boyds | 16700 Barnesville Rd | Boyds | MD | 20841
 | [NAME] | 4522 Cartmills Gap Rd | [NAME] | VA
 | Crown Castle Charlottesville | 1 Carters Mountain | Charlottesville | VA | 22902
 | Crown Castle Crownsville | 1284 Bacon Ridge Road | Crownsville | MD | 21032
 | Crown Castle Dameron | 18248 Three Notch Road | Dameron | MD | 20628
 | [NAME] | 11710 Longwoods Rd | Easton | MD | 21061
 | Crown Castle Gaithersburg | 9701 Fields Road | Gaithersburg | MD | 20878
 | [NAME] | 2380 Davidsonville Road | Gambrills | MD
 | Crown Castle Glenelg | 15155 [NAME] 32 | Glenelg | MD
 | Crown Castle Govans | [NAME] | Govans | MD
 | Crown Castle Hampstead | 2300 [NAME] | Hampstead | MD | 21074
 | Crown [NAME] | 3007 Hospital Drive | [NAME] | MD | 20785
 | Crown [NAME] | 310 Parker Court | Leesburg | VA
 | Crown Castle Leonardtown | 41875 Baldridge Street | [NAME] | MD | 20650
 | Crown Castle Lexington Park | 45774 Fire Dept Lane | Lexington Park | MD | 20619
 | [NAME] | 3847 [NAME] | Linkwood | MD | 21835
 | Crown Castle Manassas | 13621 Independence Drive | Manassas | VA | 20112
 | Crown Castle [NAME] | 9552 Riggin Rd | [NAME] | MD | 21837
 | Crown Castle Marion Station | 28927 [NAME] | Marion Station | MD | 21838
 | Crown Castle Mechanicsville | 28306 Flora Corner Road | Mechanicsville | MD | 20659
 | Crown Castle Mechanicsville | [NAME] | Mechanicsville | MD
 | [NAME] | 15711 Midlothan Turnpike | Midlothian | VA | 23113
 | [NAME] | 3725 Mountain Road | Pasadena | MD
 | [NAME] | 28 Walker Ave. | Pikesville | MD | 21208
 | Crown Castle Pittsville | 34684 Warren Road | Pittsville | MD | 21850
 | Crown Castle Silver Spring | 49 Randolph Road | Silver Spring | MD
 | Crown Castle Towson | 1400 Taylor Ave. | Towson | MD
 | Crown [NAME] | 4833 Ocean Gateway | Vienna | MD | 21869
 | Crown Castle Virginia Beach | 1949 Kempsville Rd | Virginia Beach | VA | 23464
 | Crown Castle Waldorf | 2910 Old Washington Road | Waldorf | MD | 20601
 | Crown [NAME] | Hall Road & Rt 50 | Whaleysville | MD