Spreadsheet: 132991d1324073080-data-referencing-across-tabs-copy-of-survey-input-example-forum
Sheet: Data

Facility ID | Facility Name | Pharmacy | RSA | Division | [NAME] | Time Period | Submitted By | Type | Average Score | Ease of ordering (e.g. fax, phone) process | Medication accuracy (i.e. Right Drug/Right Patient) | Routine scheduled deliveries are on time | Stats are delivered within an appropriate timeframe | Medical Records are accurate | Medical Records are received by the agreed upon date | Pharmacy billing statements are accurate | Overall rating of the pharmacy's ability to meet your needs | Expertise of infusion (IV) services personnel | Expertise of consultant pharmacist | Expertise of other pharmacy services (ie: nursing, QA tech, customer service) | Staff education | Drug information provided by Pharmacists is useful | Assistance in resolving facility or patient concerns | Timely response to facility or patient concerns | Understanding of facility or patient concerns | Courtesy of pharmacy staff | Clear explanation and timely communication about medications that are not available for your order | Overall rating of the pharmacy's ability to meet your expectations | Compared to Last Year Service is | Recommend OCR | Comments in Survey
PHNDX1184 | Abc Manor | DENMAN PHARM SERV | Indy | Mideast | Inman | Feb 2012 Q1 | DON | ALF |  | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 0 | 3 | 3 | 3 | 3 | 3 | 3 | Better | No | Yes
PHNDX1256 | Abc Manor | HOME PHARM SERV | Indy | Mideast | Inman | Mar 2012 Q1 | DON | ALF |  | 2 | 3 | 4 | 5 | 0 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 1 | 3 | 3 | 3 | 3 | 3 | 3 | Better | No | No
PHNDX1270 | Abc Manor | [NAME] | Indy | Mideast | Inman | Aug 2012 Q3 | DON | ALF |  | 1 | 3 | 3 | 3 | 0 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | Better | No | No
PHNDX1275 | Abc Manor | INTERLOCK COLUMBIA | Indy | Mideast | Inman | Feb 2012 Q4 | DON | ALF |  | 3 | 1 | 3 | 3 | 4 | 3 | 2 | 3 | 4 | 5 | 3 | 3 | 3 | 3 | 3 | 1 | 3 | 3 | 3 | Better | No | No
PHNDX1305 | Abc Manor | INTERLOCK FLORISSANT | Indy | Mideast | Inman | Apr 2012 Q2 | DON | ALF |  | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 3 | 3 | 1 | 3 | 3 | 3 | Better | No | No
PHNDX432 | Abc Manor | MANAGED HEALTHCARE | Indy | Mideast | Inman | Jan 2012 Q1 | DON | ALF |  | 2 | 3 | 2 | 3 | 3 | 3 | 3 | 2 | 3 | 3 | 3 | 3 | 5 | 3 | 3 | 2 | 3 | 3 | 3 | Better | No | No
PHNDX437 | Abc Manor | MEDICATE FARMINGTON | Indy | Mideast | Inman | Jan 2012 Q1 | DON | ALF |  | 3 | 1 | 3 | 3 | 3 | 2 | 3 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 2 | 3 | 3 | 3 | Better | No | No
PHNDX438 | Abc Manor | [NAME] | Indy | Mideast | Inman | Jan 2012 Q1 | DON | ALF |  | 3 | 3 | 3 | 3 | 3 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | Better | No | No
PHNDX443 | Abc Manor | [NAME] | Indy | Mideast | Inman | Jan 2012 Q1 | DON | ALF |  | 3 | 3 | 3 | 3 | 3 | 2 | 3 | 5 | 3 | 3 | 3 | 3 | 3 | 3 | 5 | 4 | 3 | 3 | 3 | Better | No | No
PHNDX506 | Abc Manor | OCR MINNESOTA | Indy | Mideast | Inman | Jan 2012 Q1 | DON | ALF |  | 5 | 4 | 3 | 2 | 1 | 1 | 1 | 0 | 0 | 0 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | Better | No | No
PHNDX538 | Abc Manor | OCR NEBRASKA | Indy | Mideast | Inman | Jan 2012 Q1 | DON | ALF |  | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 5 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | Better | No | No
PHNDX545 | Abc Manor | OCR PHARMACY MIDWEST | Indy | Mideast | Inman | Jan 2012 Q1 | DON | ALF |  | 3 | 3 | 3 | 3 | 2 | 2 | 3 | 3 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | Better | No | No
PHNDX658 | Abc Manor | OCR S DAKOTA | Indy | Mideast | Inman | Jan 2012 Q1 | DON | ALF |  | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | Better | No | No
PHNDX658 | Abc Manor | OCR URBANDALE | Indy | Mideast | Inman | Jan 2012 Q1 | DON | ALF |  | 3 | 3 | 5 | 4 | 3 | 2 | 1 | 1 | 1 | 2 | 3 | 4 | 5 | 1 | 0 | 0 | 4 | 3 | 3 | Better | Yes | No
PHNDX658 | Abc Manor | PHARMACY CARE ASSOC | Indy | Mideast | Inman | Jan 2012 Q1 | DON | ALF |  | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 0 | 3 | 3 | 3 | 3 | 3 | 3 | Better | Yes | No
PHNDX658 | Abc Manor | SEQUOIA OKLAHOMA | Indy | Mideast | Inman | Jan 2012 Q1 | DON | ALF |  | 2 | 3 | 4 | 5 | 0 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 1 | 3 | 3 | 3 | 3 | 3 | 3 | Better | Yes | No
PHNDX658 | Abc Manor | [NAME] | Indy | Mideast | Inman | Jan 2012 Q1 | DON | ALF |  | 1 | 3 | 3 | 3 | 0 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | Better | Yes | No
PHNDX658 | Abc Manor | DENMAN PHARM SERV | Indy | Mideast | Inman | Jan 2012 Q1 | DON | ALF |  | 3 | 1 | 3 | 3 | 4 | 3 | 2 | 3 | 4 | 5 | 3 | 3 | 3 | 3 | 3 | 1 | 3 | 3 | 3 | Better | Yes | No
PHNDX658 | Abc Manor | HOME PHARM SERV | Indy | Mideast | Inman | Jan 2012 Q1 | DON | ALF |  | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 3 | 3 | 1 | 3 | 3 | 3 | Better | Yes | No
PHNDX658 | Abc Manor | [NAME] | Indy | Mideast | Inman | Jan 2012 Q1 | DON | ALF |  | 2 | 3 | 2 | 3 | 3 | 3 | 3 | 2 | 3 | 3 | 3 | 3 | 5 | 3 | 3 | 2 | 3 | 3 | 3 | Better | Yes | No
PHNDX658 | Abc Manor | INTERLOCK COLUMBIA | Indy | Mideast | Inman | Jan 2012 Q1 | DON | ALF |  | 3 | 1 | 3 | 3 | 3 | 2 | 3 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 2 | 3 | 3 | 3 | Better | No | No
PHNDX658 | Abc Manor | INTERLOCK FLORISSANT | Indy | Mideast | Inman | Jan 2012 Q1 | DON | ALF |  | 3 | 3 | 3 | 3 | 3 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | Better | No | No
PHNDX658 | Abc Manor | MANAGED HEALTHCARE | Indy | Mideast | Inman | Jan 2012 Q1 | DON | ALF |  | 3 | 3 | 3 | 3 | 3 | 2 | 3 | 5 | 3 | 3 | 3 | 3 | 3 | 3 | 5 | 4 | 3 | 3 | 3 | Better | No | No
PHNDX658 | Abc Manor | MEDICATE FARMINGTON | Indy | Mideast | Inman | Jan 2012 Q1 | DON | ALF |  | 5 | 4 | 3 | 2 | 1 | 1 | 1 | 0 | 0 | 0 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | Better | No | No
PHNDX658 | Abc Manor | [NAME] | Indy | Mideast | Inman | Jan 2012 Q1 | DON | ALF |  | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 5 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | Better | No | No
PHNDX658 | Abc Manor | [NAME] | Indy | Mideast | Inman | Jan 2012 Q1 | DON | ALF |  | 3 | 3 | 3 | 3 | 2 | 2 | 3 | 3 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | Better | N/A | No
PHNDX658 | Abc Manor | OCR MINNESOTA | Indy | Mideast | Inman | Jan 2012 Q1 | DON | ALF |  | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | Better | N/A | No
PHNDX658 | Abc Manor | OCR NEBRASKA | Indy | Mideast | Inman | Jan 2012 Q1 | DON | ALF |  | 3 | 3 | 5 | 4 | 3 | 2 | 1 | 1 | 1 | 2 | 3 | 4 | 5 | 1 | 0 | 0 | 4 | 3 | 3 | Better | N/A | No
PHNDX658 | Abc Manor | OCR PHARMACY MIDWEST | Indy | Mideast | Inman | Jan 2012 Q1 | DON | ALF |  | 3 | 3 | 5 | 4 | 3 | 2 | 1 | 1 | 1 | 2 | 3 | 4 | 5 | 1 | 0 | 0 | 4 | 2 | 3 | Better | N/A | No
PHNDX658 | Abc Manor | OCR S DAKOTA | Indy | Mideast | Inman | Jan 2012 Q1 | DON | ALF |  | 3 | 3 | 5 | 4 | 3 | 2 | 1 | 1 | 1 | 2 | 3 | 4 | 5 | 1 | 0 | 0 | 4 | 1 | 3 | Better | N/A | No
PHNDX658 | Abc Manor | OCR URBANDALE | Indy | Mideast | Inman | Jan 2012 Q1 | DON | ALF |  | 3 | 3 | 5 | 4 | 3 | 2 | 1 | 1 | 1 | 2 | 3 | 4 | 5 | 1 | 0 | 0 | 4 | 0 | 3 | Better | N/A | No
PHNDX658 | Abc Manor | PHARMACY CARE ASSOC | Indy | Mideast | Inman | Jan 2012 Q1 | DON | ALF |  | 3 | 3 | 5 | 4 | 3 | 2 | 1 | 1 | 1 | 2 | 3 | 4 | 5 | 1 | 0 | 0 | 4 | 0 | 3 | Better | N/A | No
PHNDX658 | Abc Manor | SEQUOIA OKLAHOMA | Indy | Mideast | Inman | Jan 2012 Q1 | DON | ALF |  | 3 | 3 | 5 | 4 | 3 | 2 | 1 | 1 | 1 | 2 | 3 | 4 | 5 | 1 | 0 | 0 | 4 | 0 | 3 | Better | N/A | No
PHNDX658 | Abc Manor | [NAME] | Indy | Mideast | Inman | Jan 2012 Q1 | DON | ALF |  | 3 | 3 | 5 | 4 | 3 | 2 | 1 | 1 | 1 | 2 | 3 | 4 | 5 | 1 | 0 | 0 | 4 | 0 | 3 | Better | N/A | No
PHNDX658 | Abc Manor | DENMAN PHARM SERV | Indy | Mideast | Inman | Jan 2012 Q1 | DON | ALF |  | 3 | 3 | 5 | 4 | 3 | 2 | 1 | 1 | 1 | 2 | 3 | 4 | 5 | 1 | 0 | 0 | 4 | 5 | 3 | Better | No | No
PHNDX658 | Abc Manor | HOME PHARM SERV | Indy | Mideast | Inman | Jan 2012 Q1 | DON | ALF |  | 3 | 3 | 5 | 4 | 3 | 2 | 1 | 1 | 1 | 2 | 3 | 4 | 5 | 1 | 0 | 0 | 4 | 4 | 3 | Better | No | No
PHNDX658 | Abc Manor | [NAME] | Indy | Mideast | Inman | Jan 2012 Q1 | DON | ALF |  | 3 | 3 | 5 | 4 | 3 | 2 | 1 | 1 | 1 | 2 | 3 | 4 | 5 | 1 | 0 | 0 | 4 | 3 | 3 | Better | No | No
PHNDX658 | Abc Manor | INTERLOCK COLUMBIA | Indy | Mideast | Inman | Jan 2012 Q1 | DON | ALF |  | 3 | 3 | 5 | 4 | 3 | 2 | 1 | 1 | 1 | 2 | 3 | 4 | 5 | 1 | 0 | 0 | 4 | 2 | 3 | Better | No | No
PHNDX658 | Abc Manor | INTERLOCK FLORISSANT | Indy | Mideast | Inman | Jan 2012 Q1 | DON | ALF |  | 3 | 3 | 5 | 4 | 3 | 2 | 1 | 1 | 1 | 2 | 3 | 4 | 5 | 1 | 0 | 0 | 4 | 1 | 3 | Better | No | No
PHNDX658 | Abc Manor | MANAGED HEALTHCARE | Indy | Mideast | Inman | Jan 2012 Q1 | DON | ALF |  | 3 | 3 | 5 | 4 | 3 | 2 | 1 | 1 | 1 | 2 | 3 | 4 | 5 | 1 | 0 | 0 | 4 | 1 | 3 | Better | No | No
PHNDX658 | Abc Manor | MEDICATE FARMINGTON | Indy | Mideast | Inman | Jan 2012 Q1 | DON | ALF |  | 3 | 3 | 5 | 4 | 3 | 2 | 1 | 1 | 1 | 2 | 3 | 4 | 5 | 1 | 0 | 0 | 4 | 1 | 3 | Better | No | No