Spreadsheet: 191487d1352133546-help-with-creating-form-in-excel-that-pulls-data-from-table-oor-survey-template-draft-5-nov-2012
Sheet: Sample-Table

Customer# | Customer Name | Location# | Location Name | Location Description | Location Address | Location City / State | Door / Installation | Door Description | Inst-Type | Inst-Type Desc / Manuf | Contract | Warranty [NAME] | Contact Person | Location Telephone# | Customer Telephone# | Line of Business | LOB Description
605247 | Customer A | 27540097 | Front-1 | [NAME] | 123 3rd Street | Sample City, State | 548340 | Fill Finish Airlock 1019 | 15400 | Swingmaster |  | 1990-12-31 00:00:00 | [NAME] | 123-45-6789 | 123-45-6789 | J-A | Private Management Companies
605247 | Customer A | 27540097 | Front-2 | [NAME] | 123 3rd Street | Sample City, State | 548378 | 2038 | 17100 | SW 100 Dual | Y | 1990-12-31 00:00:00 | [NAME] | 123-45-6789 | 123-45-6789 | J-A | Private Management Companies
605247 | Customer A | 27540097 | Front-3 | [NAME] | 123 3rd Street | Sample City, State | 548384 | Airlock 2191 | 90000 | Other Doors (Manual Doors) | Y | 1990-12-31 00:00:00 | [NAME] | 123-45-6789 | 123-45-6789 | J-A | Private Management Companies
605247 | Customer A | 27540097 | Front-4 | [NAME] | 123 3rd Street | Sample City, State | 548385 | [NAME] | 90000 | Other Doors (Manual Doors) | Y | 1990-12-31 00:00:00 | [NAME] | 123-45-6789 | 123-45-6789 | J-A | Private Management Companies
605247 | Customer A | 27540097 | Back-1 | [NAME] | 123 3rd Street | Sample City, State | 548386 | Ext Waste Holding | 42500 | [NAME] |  | 1990-12-31 00:00:00 | [NAME] | 123-45-6789 | 123-45-6789 | J-A | Private Management Companies
605247 | Customer A | 27540097 | Back-2 | [NAME] | 123 3rd Street | Sample City, State | 653836 | [NAME] | 17300 | SM 900 |  | 2010-11-24 00:00:00 | [NAME] | 123-45-6789 | 123-45-6789 | J-A | Private Management Companies
605247 | Customer A | 27540097 | [NAME] | [NAME] | 123 3rd Street | Sample City, State | 653837 | [NAME] | 17300 | SM 900 |  | 2010-11-24 00:00:00 | [NAME] | 123-45-6789 | 123-45-6789 | J-A | Private Management Companies
605247 | Customer A | 27540097 | Back-4 | [NAME] | 123 3rd Street | Sample City, State | 653838 | [NAME] | 17300 | SM 900 | Y | 2010-11-24 00:00:00 | [NAME] | 123-45-6789 | 123-45-6789 | J-A | Private Management Companies
605247 | Customer A | 27540097 | Middle-1 | [NAME] | 123 3rd Street | Sample City, State | 653839 | [NAME] | 17300 | SM 900 |  | 2010-11-24 00:00:00 | [NAME] | 123-45-6789 | 123-45-6789 | J-A | Private Management Companies
605247 | Customer A | 27540097 | Middle-2 | [NAME] | 123 3rd Street | Sample City, State | 901394 | Verify Location | 17300 | SM 900 |  | 2010-12-27 00:00:00 | [NAME] | 123-45-6789 | 123-45-6789 | J-A | Private Management Companies
606066 | Customer B | 60640002 | NULL | Bethany Methodist Retirement* | Chew Ave | [NAME], State | 142731 | Nursing Home Inner Entrance | 19300 | Bi-Fold/ Ready Fold |  | 1990-12-31 00:00:00 | [NAME] | [PHONE] | [PHONE] | HA- | Hospitals
606066 | Customer B | 60640002 | NULL | Bethany Methodist Retirement* | Chew Ave | [NAME], State | 142732 | Nursing Home Outer Entrance | 19300 | Bi-Fold/ Ready Fold |  | 1990-12-31 00:00:00 | [NAME] | [PHONE] | [PHONE] | HA- | Hospitals
606066 | Customer B | 60640002 | NULL | Bethany Methodist Retirement* | Chew Ave | [NAME], State | 334544 | Emergency Door | 19300 | Bi-Fold/ Ready Fold |  | 1990-12-31 00:00:00 | [NAME] | [PHONE] | [PHONE] | HA- | Hospitals
606066 | Customer B | 60640002 | NULL | Bethany Methodist Retirement* | Chew Ave | [NAME], State | 60640002-1 | Outpatient I/I | 18999 | Other [NAME] |  | 1990-12-31 00:00:00 | [NAME] | [PHONE] | [PHONE] | HA- | Hospitals
606066 | Customer B | 60640002 | NULL | Bethany Methodist Retirement* | Chew Ave | [NAME], State | 60640002-2 | Outpatient I/O | 18999 | Other [NAME] |  | 1990-12-31 00:00:00 | [NAME] | [PHONE] | [PHONE] | HA- | Hospitals
606066 | Customer B | 60640003 | NULL | Bethany Methodist Retirement* | [NAME] | Delaware, State | 60640003-1 | Outpatient O/I | 18999 | Other [NAME] |  | 1990-12-31 00:00:00 | [NAME] | [PHONE] | [PHONE] | HA- | Hospitals
606066 | Customer B | 60640003 | NULL | Bethany Methodist Retirement* | [NAME] | Delaware, State | 60640003-2 | Outpatient O/O | 18999 | Other [NAME] |  | 1990-12-31 00:00:00 | [NAME] | [PHONE] | [PHONE] | HA- | Hospitals
606066 | Customer B | 60640003 | NULL | Bethany Methodist Retirement* | [NAME] | Delaware, State | 60640003-3 | X-ray | 19300 | Bi-Fold/ Ready Fold | Y | 1990-12-31 00:00:00 | [NAME] | [PHONE] | [PHONE] | HA- | Hospitals
606066 | Customer B | 60640003 | NULL | Bethany Methodist Retirement* | [NAME] | Delaware, State | 60640003-4 | Pavillion Entrance | 19300 | Bi-Fold/ Ready Fold | Y | 1990-12-31 00:00:00 | [NAME] | [PHONE] | [PHONE] | HA- | Hospitals
606066 | Customer B | 60640003 | NULL | Bethany Methodist Retirement* | [NAME] | Delaware, State | 60640003-5 | Pavillion Entrance | 18999 | Other [NAME] |  | 1990-12-31 00:00:00 | [NAME] | [PHONE] | [PHONE] | HA- | Hospitals
606066 | Customer B | 60640003 | NULL | Bethany Methodist Retirement* | [NAME] | Delaware, State | 60640003-6 | Hospital Main Entrance I/I | 44500 | Dor-O-matic Swinger | Y | 1990-12-31 00:00:00 | [NAME] | [PHONE] | [PHONE] | HA- | Hospitals
606066 | Customer B | 60640003 | NULL | Bethany Methodist Retirement* | [NAME] | Delaware, State | 60640003-7 | Hospital Main Entrance O/I | 44500 | Dor-O-matic Swinger | Y | 1990-12-31 00:00:00 | [NAME] | [PHONE] | [PHONE] | HA- | Hospitals
750930 | Customer C | 48152033 | NULL | [NAME] | Case Street | Test City, State | BNC1014799 | Rear Inner | 35999 | Other Competitor Slider |  | 1990-12-31 00:00:00 | [NAME] | [PHONE] | [PHONE] | J-- | Private Office Buildings
750930 | Customer C | 48152033 | NULL | [NAME] | Case Street | Test City, State | BNC1014800 | Rear Outer | 35999 | Other Competitor Slider |  | 1990-12-31 00:00:00 | [NAME] | [PHONE] | [PHONE] | J-- | Private Office Buildings
750930 | Customer C | 48152033 | NULL | [NAME] | Case Street | Test City, State | BNC1014801 | Front Outer | 35999 | Other Competitor Slider |  | 1990-12-31 00:00:00 | [NAME] | [PHONE] | [PHONE] | J-- | Private Office Buildings
750930 | Customer C | 48152033 | NULL | [NAME] | Case Street | Test City, State | BNC1014802 | Front Inner | 35999 | Other Competitor Slider |  | 1990-12-31 00:00:00 | [NAME] | [PHONE] | [PHONE] | J-- | Private Office Buildings
750930 | Customer C | 48152033 | NULL | [NAME] | Case Street | Test City, State | BS1014799 | Rear Inner | XXXXX | Obsolete Doors |  | 1990-12-31 00:00:00 | [NAME] | [PHONE] | [PHONE] | J-- | Private Office Buildings
916026 | Customer D | 91607004 | NULL | Cambridge Farms* | Whodunit Street | Don’t know City, State | 843570 | West deli entrance | 11600 | [NAME]) Unifit |  | 1991-01-02 00:00:00 | [NAME] | [PHONE] | [PHONE] | C-- | Retail
916026 | Customer D | 91607004 | NULL | Cambridge Farms* | Whodunit Street | Don’t know City, State | 853598 | Entrance | 11400 | Unislide | Y | 2008-11-01 00:00:00 | [NAME] | [PHONE] | [PHONE] | C-- | Retail
916026 | Customer D | 91607004 | NULL | Cambridge Farms* | Whodunit Street | Don’t know City, State | [NAME] | East entrance | 10000 | [NAME] |  | 1991-01-02 00:00:00 | [NAME] | [PHONE] | [PHONE] | C-- | Retail
947726 | Customer E | 94701005 | NULL | West Berkeley Bowl | Drummer Street | Bass City, State | 436975 | Deli | 11400 | Unislide |  | 2010-03-08 00:00:00 | [NAME] | [PHONE] | [PHONE] | L-- | Non Class - Other
947726 | Customer E | 94701005 | NULL | West Berkeley Bowl | Drummer Street | Bass City, State | 436976 | Market North | 11400 | Unislide | Y | 2010-03-08 00:00:00 | [NAME] | [PHONE] | [PHONE] | L-- | Non Class - Other
947726 | Customer E | 94701005 | NULL | West Berkeley Bowl | Drummer Street | Bass City, State | 436977 | Market S Exit | 11400 | Unislide |  | 2010-03-08 00:00:00 | [NAME] | [PHONE] | [PHONE] | L-- | Non Class - Other