Spreadsheet: 156363d1337269611-having-trouble-using-the-index-function-to-return-an-entire-column-of-values-in-excel-2010-dp_vicksburgms_integrationcomplete_rpt_5-9-12_jdunawayv-2-demo-
Sheet: Interface Engine

[NAME] | Application Name | Application Description | Source System (From) | Destination System (To) | Message Types to be Delivered (ADT, ORU, ORM, DFT, etc.) | Filter, Translation, etc., Required | Connenction Data for the Inbound Listen Thread on Clover \ [NAME] Format = IP:Port -Test/Prod | Connection Data of the Ancillary System Clover \ PIM is sending to Format = IP:Port -Test/Prod | Inbound Thread Name in Cloverleaf | Outbound Thread Name in Cloverleaf | Vendor Test System "Y/N" | Vendor HL7 Technical Contact (Name, Phone, [NAME]) | CHS (non-facility) Clinical Application Analyst Contact | Facility Application SME Contact (SuperUser) | NOTES | Vendor Engaged | PO's Completed | VPN Completed | Connection Information Gathered | Connection Validated | Engine Programming Complete | Unit Test Complete | Included in Integrated Test Round 1 | TOTAL | Overall Status
PowerScribe | PowerScribe | Voice Rec, Dictation and Transcription - radiology | HMS | Powerscribe | ADT |  | IP: 10.35.68.215 Port (T) - 6923 Port (P) - 6023 | IP:  172.16.17.185 Port:  (T) - 13800 Port:  (P) - 12800 |  |  | Y | [NAME] [PHONE] [EMAIL] |  |  | No PO required - working on test system | x
 |  |  | HRM | Powerscribe | ORM |  | IP: 10.35.68,215 Port:  (T) - XXXXX Port:  (P) - XXXXX | IP:  172.16.17.185 Port:  (T) - XXXXX Port:  (P) - XXXXX |  |  | Y | [NAME] [PHONE] [EMAIL] |  |  | No PO required - working on test system
 |  |  | PowerScribe | HRM | TEST |  | IP: 10.35.68.215 Port (T) - 13801 Port (P) - 12801 | IP:  XXX.XXX.XXX.XXX Port:  (T) - XXXXX Port:  (P) - XXXXX |  |  | Y | [NAME] [PHONE] [EMAIL] |  |  | No PO required - working on test system |  |  |  |  | x | x
GE | Centricity Perinatal | Labor and Delivery | HMS | Centricity CPN | ADT |  | IP: 10.35.68.215 Port (T) - 6923 Port (P) - 6023 | IP:  172.16.45.12 Port:  (T) - XXXXX Port:  (P) - 3320 |  |  |  | [NAME]  [EMAIL] [PHONE] |  |  | 5/11/12 - kickoff call | x
PowerScribe | PowerScribe | Voice Rec, Dictation and Transcription - radiology | HMS | Powerscribe | ADT |  | IP: 10.35.68.215 Port (T) - 6923 Port (P) - 6023 | IP:  172.16.17.185 Port:  (T) - 13800 Port:  (P) - 12800 |  |  | Y | [NAME] [PHONE] [EMAIL] |  |  | No PO required - working on test system | x | x | x | x | x
 |  |  | HRM | Powerscribe | ORM |  | IP: 10.35.68,215 Port:  (T) - XXXXX Port:  (P) - XXXXX | IP:  172.16.17.185 Port:  (T) - XXXXX Port:  (P) - XXXXX |  |  | Y | [NAME] [PHONE] [EMAIL] |  |  | No PO required - working on test system | x | x | x | x | x
 |  |  | PowerScribe | HRM | ORU |  | IP: 10.35.68.215 Port (T) - 13801 Port (P) - 12801 | IP:  XXX.XXX.XXX.XXX Port:  (T) - XXXXX Port:  (P) - XXXXX |  |  | Y | [NAME] [PHONE] [EMAIL] |  |  | No PO required - working on test system | x | x | x | x | x
Cerner | CoPath | Pathology | HMS | CoPath | ADT |  | IP: 10.35.68.215 Port (T) - 6923 Port (P) - 6023 | IP:  XXX.XXX.XXX.XXX Port:  (T) - XXXXX Port:  (P) - XXXXX | hms_in | ppath_adt_out | Y | [NAME] [EMAIL] [PHONE] |  |  | Awaiting PO approval | x
 |  |  | HLAB | CoPath | ORM |  | IP: 172.16.17.129 | IP:  XXX.XXX.XXX.XXX Port:  (T) - XXXXX Port:  (P) - XXXXX | ppath_oru_in | hci_oru_out | Y | [NAME] [EMAIL] [PHONE] |  |  | Awaiting PO approval | x
 |  |  | CoPath | HCI | ORU |  | IP: 172.16.1.1 Port:  (T) - 1375 Port:  (P) - 22244 | IP:  XXX.XXX.XXX.XXX Port:  (T) - XXXXX Port:  (P) - XXXXX | ppath_dft_in | hms_out | Y | [NAME] [EMAIL] [PHONE] |  |  | Awaiting PO approval | x
GE | MacLab | Cardiology | HMS | MacLab | ADT |  | IP: 10.35.68.215 Port (T) - 6923 Port (P) - 6023 | IP:  XXX.XXX.XXX.XXX Port:  (T) - XXXXX Port:  (P) - XXXXX | hms_in |  |  | [NAME][EMAIL] |  |  | 5/4/2012 - Vendor found issues with current application's database; in discussions on resolution | x
MRS | MRS | Mammography Reporting | HMS | MRS | ADT |  | IP: 10.35.68.215 Port (T) - 6923 Port (P) - 6023 | IP:  XXX.XXX.XXX.XXX Port:  (T) - XXXXX Port:  (P) - XXXXX |  |  | Y | [NAME] [EMAIL] [PHONE]   Interface Resource Don Valdez [EMAIL] |  |  | received interface in mail 5/8 - referred to IEPM | x | x | x | x
 |  |  | HRM | MRS | ORM |  | IP:  XXX.XXX.XXX.XXX Port:  (T) - XXXXX Port:  (P) - XXXXX | IP:  XXX.XXX.XXX.XXX Port:  (T) - XXXXX Port:  (P) - XXXXX |  |  | Y | [NAME] [EMAIL] [PHONE]   Interface Resource Don Valdez [EMAIL] |  |  | received interface in mail 5/8 - referred to IEPM | x | x | x | x
M*Modal | M*Modal | Dictation and Transcription | HMS | M*Modal | ADT |  | IP: 10.35.68.215 Port (T) - 6923 Port (P) - 6023 | IP:  208.88.40.26 Port:  (T) - 17341 Port:  (P) - XXXXX |  |  | Y | [NAME] [EMAIL] (267) 940 - 5707 |  |  | 05/09/12 - IE - successfully connected to Mmodal to send ADTs | x | x | x | x | x | x
 |  |  | HMS | M*Modal | ORM |  | IP: 10.35.68.215 Port (T) - 6923 Port (P) - 6023 | IP:  208.88.40.26 Port:  (T) - 17342 Port:  (P) - XXXXX |  |  |  | [NAME] [EMAIL] (267) 940 - 5707 |  |  | 05/09/12 - IE - successfully connected to Mmodal to send ORMs | x | x | x | x | x | x
 |  |  | M*Modal | HRM | ORU  (HIM / TRANS) |  | IP:  10.35.68.215 Port:  (T) - 13501 Port:  (P) - 13500 | IP:  XXX.XXX.XXX.XXX Port:  (T) - XXXXX Port:  (P) - XXXXX |  |  | Y | [NAME] [EMAIL] (267) 940 - 5707 |  |  | 05/09/12 - IE - successfully connected to Mmodal to receive ORUs (HIM) | x | x | x | x | x | x
 |  |  | M*Modal | HRM | ORU  (CARD) |  | IP:  10.35.68.215 Port:  (T) - 12501 Port:  (P) - 12500 | IP:  XXX.XXX.XXX.XXX Port:  (T) - XXXXX Port:  (P) - XXXXX |  |  | Y | [NAME] [EMAIL] (267) 940 - 5707 |  |  | 05/09/12 - IE - successfully connected to Mmodal to receive ORUs (CARD) | x | x | x | x | x | x
Carefusion | Pyxis  Pyxis Connect | Drug Inventory Software Optical Scanning and Archival System | HMM | Pyxis | ADT - A08 w AL1 seg for allergies | ADT passed thru HMM | IP:  172.16.1.1 Port:  (T) - 655 Port:  (P) - 41401 | IP:  XXX.XXX.XXX.XXX Port:  (T) - XXXXX Port:  (P) - XXXXX |  |  | Y | [NAME] Office Phone: [PHONE] Mobile Phone: [PHONE]  [EMAIL] |  |  | 05/09/12 - vendor is building vmware on RRMC server and will notify when complete | x | x | x
 |  |  | HMM | Pyxis | RDE (med orders) |  | IP:  172.16.17.88 Port:  (T) - 699 Port:  (P) - 41402 | IP:  XXX.XXX.XXX.XXX Port:  (T) - XXXXX Port:  (P) - XXXXX |  |  | Y | [NAME] Office Phone: [PHONE] Mobile Phone: [PHONE]  [EMAIL] |  |  | 05/09/12 - vendor is building vmware on RRMC server and will notify when complete | x | x | x
 |  |  | Pyxis | HMM | DFT |  | IP: 172.16.23.7 Port:  (T) - 696 Port:  (P) - 9100 | IP:  XXX.XXX.XXX.XXX Port:  (T) - XXXXX Port:  (P) - XXXXX |  |  | Y | [NAME] Office Phone: [PHONE] Mobile Phone: [PHONE]  [EMAIL] |  |  | 05/09/12 - vendor is building vmware on RRMC server and will notify when complete | x | x | x
 |  |  | Pyxis | HMM | [NAME] (Load/Unload) |  | IP:  130.94.70.9 Port:  (T) - 695 Port:  (P) - 8015 | IP:  XXX.XXX.XXX.XXX Port:  (T) - XXXXX Port:  (P) - XXXXX |  |  | Y | [NAME] Office Phone: [PHONE] Mobile Phone: [PHONE]  [EMAIL] |  |  | 05/09/12 - vendor is building vmware on RRMC server and will notify when complete | x | x
GE Healthcare | GE PACS | PACS | HMS | GE PACS | ADT |  | IP:  XXX.XXX.XXX.XXX Port:  (T) - XXXXX Port:  (P) - XXXXX | IP: 172.16.45.12 Port:  (T) - XXXXX Port:  (P) - 3320 |  |  |  | [NAME] (PACS field engineer) brian.e.adair2ge.com T:  (262) 312 - 1857 T:  (800) 257 - 2878 x7023928 C:  (601) 573 - 1329 |  |  | received PO and is working on bulilding test environment | x | x |  | x
 |  |  | HRM | GE PACS | ORM |  | IP: 172.16.45.12 | IP:  XXX.XXX.XXX.XXX Port:  (T) - XXXXX Port:  (P) - XXXXX |  |  |  | [NAME][PHONE] |  |  | received PO and is working on bulilding test environment | x | x |  | x
[NAME] | HLAB | LIS | HMS | HLAB | ADT |  | IP: 10.35.68.215 Port (T) - 6923 Port (P) - 6023 | IP:  10.35.86.187 Port:  12020 IP:  (P) Port:  (P) |  |  | Y |  |  |  |  | x | x | x | x | x | x
 |  |  | HMS | HLAB | MFN (staff) |  | IP: 10.35.68.215 Port (T) - 6923 Port (P) - 6023 | IP:  10.35.86.187 Port:  12025 IP:  (P) Port:  (P) |  |  | Y |  |  |  |  | x | x | x | x | x | x
 |  |  | HLAB | HMS | DFT |  | IP:  (T) Port:  (T) IP:  (P) Port:  (P) | IP:  (T) Port:  (T) IP:  (P) Port:  (P) |  |  | Y |  |  |  |  | x | x | x | x | x | x
 |  |  | HLAB | HCI | ORM |  | IP:  (T) Port:  (T) IP:  (P) Port:  (P) | IP:  (T) Port:  (T) IP:  (P) Port:  (P) |  |  | Y |  |  |  |  | x | x | x | x | x | x
 |  |  | HLAB | HCI | ORU |  | IP:  (T) Port:  (T) IP:  (P) Port:  (P) | IP:  (T) Port:  (T) IP:  (P) Port:  (P) |  |  | Y |  |  |  |  | x | x | x | x | x | x
 |  |  | HLAB | HMM | ORU |  | IP:  (T) Port:  (T) IP:  (P) Port:  (P) | IP:  (T) Port:  (T) IP:  (P) Port:  (P) |  |  | Y |  |  |  |  | x | x | x | x | x | x
[NAME] | HCI/HPP | clinicals | HMS | HCI | ADT |  | IP: 10.35.66.5 Port (T) - 6923 Port (P) - 6023 | IP:  (T) Port:  (T) IP:  (P) Port:  (P) |  |  | Y |  |  |  |  | x | x | x | x | x | x
 |  |  | HMS | HCI/HPP | MFN (staff) |  | IP: 10.35.66.5 Port (T) - 6923 Port (P) - 6023 | IP:  (T) Port:  (T) IP:  (P) Port:  (P) |  |  | Y |  |  |  |  | x | x | x | x | x | x
 |  |  | HCI/HPP | HMS | DFT |  | IP:  (T) Port:  (T) IP:  (P) Port:  (P) | IP:  (T) Port:  (T) IP:  (P) Port:  (P) |  |  | Y |  |  |  |  | x | x | x | x | x | x
 |  |  | HCI/HPP | HLAB | ORM |  | IP:  (T) Port:  (T) IP:  (P) Port:  (P) | IP:  (T) Port:  (T) IP:  (P) Port:  (P) |  |  | Y |  |  |  |  | x | x | x | x | x | x
 |  |  | HCI/HPP | HMM | ORU (Ht and Wt) |  | IP:  (T) Port:  (T) IP:  (P) Port:  (P) | IP:  (T) Port:  (T) IP:  (P) Port:  (P) |  |  | Y |  |  |  |  | x | x | x | x | x | x
[NAME] | HMM | pharmacy | HMS | HMM | ADT |  | IP: 10.35.66.5 Port (T) - 6923 Port (P) - 6023 | IP:  (T) Port:  (T) IP:  (P) Port:  (P) |  |  | Y |  |  |  |  | x | x | x | x
 |  |  | HMS | HMM | MFN (staff updates) |  | IP: 10.35.66.5 Port (T) - 6923 Port (P) - 6023 | IP:  (T) Port:  (T) IP:  (P) Port:  (P) |  |  | Y |  |  |  |  | x | x | x | x
 |  |  | HMM | HMS | DFT |  | IP:  (T) Port:  (T) IP:  (P) Port:  (P) | IP:  (T) Port:  (T) IP:  (P) Port:  (P) |  |  | Y |  |  |  |  | x | x | x | x
 |  |  | HMM | HCI | Allergies (A60) |  | IP:  (T) Port:  (T) IP:  (P) Port:  (P) | IP:  (T) Port:  (T) IP:  (P) Port:  (P) |  |  | Y |  |  |  |  | x | x | x | x
 |  |  | HMM | Pyxis | A08^AL1 (allergies) |  | IP:  (T) Port:  (T) IP:  (P) Port:  (P) | IP:  (T) Port:  (T) IP:  (P) Port:  (P) |  |  | Y |  |  |  |  | x | x | x | x
 |  |  | HMM | HCI | RDE |  | IP:  (T) Port:  (T) IP:  (P) Port:  (P) | IP:  (T) Port:  (T) IP:  (P) Port:  (P) |  |  | Y |  |  |  |  | x | x | x | x
 |  |  | HMM | PHS | Allergies (A60) |  | IP:  (T) Port:  (T) IP:  (P) Port:  (P) | IP:  (T) Port:  (T) IP:  (P) Port:  (P) |  |  | Y |  |  |  |  | x | x | x | x
[NAME] | HRM | Radiology | HMS | HRM | ADT |  | IP: 10.35.66.5 Port (T) - 6923 Port (P) - 6023 | IP:  (T) Port:  (T) IP:  (P) Port:  (P) |  |  | Y |  |  |  |  | x | x | x | x
 |  |  | HRM | HCI | ORM |  | IP:  (T) Port:  (T) IP:  (P) Port:  (P) | IP:  (T) Port:  (T) IP:  (P) Port:  (P) |  |  | Y |  |  |  |  | x | x | x | x
 |  |  | HRM | HCI | ORM (order status updates) |  | IP:  (T) Port:  (T) IP:  (P) Port:  (P) | IP:  (T) Port:  (T) IP:  (P) Port:  (P) |  |  | Y |  |  |  |  | x | x | x | x
 |  |  | HRM | HCI | ORU |  | IP:  (T) Port:  (T) IP:  (P) Port:  (P) | IP:  (T) Port:  (T) IP:  (P) Port:  (P) |  |  | Y |  |  |  |  | x | x | x | x
 |  |  | HRM | HMS | DFT Charges (P03) |  | IP:  (T) Port:  (T) IP:  (P) Port:  (P) | IP:  (T) Port:  (T) IP:  (P) Port:  (P) |  |  | Y |  |  |  |  | x | x | x | x
[NAME] | HSM/PHS | Horizon Surgery Mgr / Scheduling | HMS | PHS | ADT passed to HSM |  | IP: 10.35.66.5 Port (T) - 6923 Port (P) - 6023 | IP:  (T) Port:  (T) IP:  (P) Port:  (P) |  |  | Y |  |  |  |  | x | x | x | x
 |  |  | HMS | HSM | MFN (M01, M02) |  | IP: 10.35.66.5 Port (T) - 6923 Port (P) - 6023 | IP:  (T) Port:  (T) IP:  (P) Port:  (P) |  |  | Y |  |  |  |  | x | x | x | x
 |  |  | PHS | HCI | Allergies (A60) |  | IP:  (T) Port:  (T) IP:  (P) Port:  (P) | IP:  (T) Port:  (T) IP:  (P) Port:  (P) |  |  | Y |  |  |  |  | x | x | x | x
 |  |  | PHS | HMS | ADT |  | IP:  (T) Port:  (T) IP:  (P) Port:  (P) | IP:  (T) Port:  (T) IP:  (P) Port:  (P) |  |  | Y |  |  |  |  | x | x | x | x
 |  |  | PHS | HMM | Allergies (A60) |  | IP:  (T) Port:  (T) IP:  (P) Port:  (P) | IP:  (T) Port:  (T) IP:  (P) Port:  (P) |  |  | Y |  |  |  |  | x | x | x | x
 |  |  | HSM | HCI | ORU Surgical Report |  | IP:  (T) Port:  (T) IP:  (P) Port:  (P) | IP:  (T) Port:  (T) IP:  (P) Port:  (P) |  |  | Y |  |  |  |  | x | x | x | x
 |  |  | HSM | HMS | DFT |  | IP:  (T) Port:  (T) IP:  (P) Port:  (P) | IP:  (T) Port:  (T) IP:  (P) Port:  (P) |  |  | Y |  |  |  |  | x | x | x | x
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0