Spreadsheet: 183531d1348852710-average-ifs-formula-help-sample
Sheet: Data Input

Facility ID |  | Pharmacy |  |  | [NAME] |  |  |  | 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
KOPDX4177 |  | [NAME] |  |  | Lewis |  |  |  |  | 5 | 3 | 4 | 4 | 3 | 0 | 4 | 4 | 4 | 4 | 2 | 0 | 4 | 2 | 2 | 2 | 3 | 1 | 2 | Better | Yes | Yes
KOPDX4155 |  | [NAME] |  |  | Lewis |  |  |  |  | 5 | 3 | 5 | 5 | 3 | 5 | 3 | 4 | 0 | 4 | 4 | 0 | 4 | 5 | 5 | 5 | 5 | 0 | 4 | Better | Yes | No
[NAME] |  | [NAME] |  |  | Lewis |  |  |  |  | 5 | 5 | 5 | 4 | 0 | 0 | 0 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | Better | Yes | Yes
KOPDX4155 |  | [NAME] |  |  | Lewis |  |  |  |  | 5 | 4 | 4 | 5 | 2 | 5 | 0 | 5 | 0 | 5 | 5 | 0 | 5 | 5 | 5 | 5 | 5 | 3 | 5 | Better | Yes | Yes
KOPDX9040 |  | CCRX Newport |  |  | Lewis |  |  |  |  | 3 | 2 | 1 | 1 | 3 | 1 | 0 | 2 | 0 | 4 | 3 | 3 | 2 | 2 | 1 | 1 | 2 | 1 | 2 | Worse | No | Yes
EDIDX1029 |  | OCR Edison |  |  | Lewis |  |  |  |  | 5 | 3 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | Better | Yes | No
EDIDX146 |  | OCR Edison |  |  | Lewis |  |  |  |  | 4 | 5 | 3 | 4 | 5 | 5 | 3 | 4 | 4 | 0 | 4 | 0 | 5 | 5 | 5 | 5 | 4 | 3 | 4 | Same | Yes | Yes
EDIDX170 |  | OCR Edison |  |  | Lewis |  |  |  |  | 3 | 4 | 3 | 2 | 2 | 4 | 4 | 3 | 3 | 4 | 3 | 3 | 4 | 3 | 4 | 4 | 3 | 3 | 3 | Same | Yes | Yes
 |  | OCR Edison |  |  | Lewis |  |  |  |  | 4 | 4 | 4 | 2 | 4 | 0 | 0 | 4 | 0 | 0 | 4 | 0 | 4 | 5 | 5 | 4 | 4 | 3 | 4 | Better | Yes | Yes
EDIDX242 |  | OCR Edison |  |  | Lewis |  |  |  |  | 5 | 4 | 4 | 4 | 0 | 0 | 4 | 4 | 4 | 0 | 5 | 4 | 4 | 5 | 5 | 5 | 5 | 4 | 4 | Same | Yes | No
OPWDX2252 |  | OCR Greensburg |  |  | Lewis |  |  |  |  | 5 | 4 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | Same | Yes | No
OPWDX2001 |  | OCR Greensburg |  |  | Lewis |  |  |  |  | 4 | 4 | 4 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 4 | 4 | N/A | Yes | No
OPWDX2008 |  | OCR Greensburg |  |  | Lewis |  |  |  |  | 3 | 2 | 4 | 3 | 4 | 4 | 3 | 3 | 3 | 5 | 3 | 0 | 5 | 2 | 3 | 3 | 3 | 2 | 3 | Same | No | Yes
OPWDX2015 |  | OCR Greensburg |  |  | Lewis |  |  |  |  | 4 | 4 | 4 | 3 | 4 | 5 | 5 | 5 | 4 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | Better | Yes | No
OPWDX2033 |  | OCR Greensburg |  |  | Lewis |  |  |  |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | N/A | Yes | No
OPWDX2257 |  | OCR Greensburg |  |  | Lewis |  |  |  |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 0 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | Better | Yes | No
OPWDX2260 |  | OCR Greensburg |  |  | Lewis |  |  |  |  | 4 | 3 | 3 | 3 | 3 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | Same | Yes | No
OPWDX3242 |  | OCR Greensburg |  |  | Lewis |  |  |  |  | 5 | 4 | 5 | 3 | 3 | 5 | 0 | 4 | 5 | 3 | 5 | 0 | 4 | 4 | 4 | 4 | 5 | 5 | 4 | Same | Yes | No
OPWDX2047 |  | OCR Greensburg |  |  | Lewis |  |  |  |  | 5 | 5 | 5 | 5 | 5 | 5 | 2 | 4 | 0 | 5 | 5 | 0 | 0 | 5 | 5 | 5 | 5 | 5 | 5 | Better | Yes | Yes
KOPDX140 |  | [NAME] of Prussia |  |  | Lewis |  |  |  | 4.368421052631579 | 5 | 5 | 4 | 4 | 4 | 5 | 4 | 4 | 5 | 5 | 5 | 5 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | Better | Yes | No
KOPDX141 |  | [NAME] of Prussia |  |  | Lewis |  |  |  | 3.470588235294118 | 4 | 3 | 4 | 3 | 4 | 4 | 0 | 3 | 0 | 4 | 4 | 3 | 4 | 4 | 3 | 3 | 4 | 2 | 3 | Same | No | No
KOPDX190 |  | [NAME] of Prussia |  |  | Lewis |  |  |  |  | 3 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 5 | 3 | 3 | 3 | 2 | 2 | 3 | 4 | 2 | 3 | Same | No | No
[NAME] |  | [NAME] of Prussia |  |  | Lewis |  |  |  |  | 5 | 4 | 3 | 3 | 3 | 3 | 3 | 4 | 0 | 5 | 5 | 0 | 5 | 5 | 5 | 5 | 5 | 4 | 4 | Better | Yes | Yes
[NAME] |  | [NAME] of Prussia |  |  | Lewis |  |  |  |  | 3 | 3 | 5 | 4 | 3 | 5 | 4 | 4 | 3 | 4 | 5 | 4 | 5 | 0 | 4 | 4 | 4 | 4 | 0 | Better | Yes | Yes
KOPDX415 |  | [NAME] of Prussia |  |  | Lewis |  |  |  |  | 3 | 5 | 4 | 3 | 5 | 5 | 0 | 4 | 4 | 5 | 5 | 5 | 5 | 4 | 4 | 5 | 5 | 5 | 4 | Same | Yes | Yes
[NAME] |  | [NAME] of Prussia |  |  | Lewis |  |  |  |  | 3 | 3 | 3 | 3 | 0 | 0 | 0 | 3 | 3 | 3 | 2 | 0 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | Same | N/A | Yes
KOPDX155 |  | OCR of Williamsport |  |  | Lewis |  |  |  |  | 4 | 4 | 5 | 5 | 2 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 5 | 5 | 4 | N/A | Yes | No
KOPDX3164 |  | OCR of Williamsport |  |  | Lewis |  |  |  |  | 3 | 3 | 2 | 3 | 4 | 4 | 4 | 3 | 4 | 4 | 4 | 4 | 5 | 4 | 4 | 4 | 5 | 3 | 3 | Same | Yes | No
OPWDX3171 |  | OCR Pittsburgh |  |  | Lewis |  |  |  |  | 3 | 3 | 3 | 3 | 2 | 5 | 4 | 3 | 5 | 5 | 3 | 3 | 5 | 5 | 5 | 4 | 3 | 1 | 3 | Same | Yes | Yes
EDIDX2194 |  | OCR Southern NJ |  |  | Lewis |  |  |  |  | 4 | 4 | 4 | 4 | 3 | 4 | 4 | 4 | 0 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | Better | Yes | No
EDIDX2155 |  | OCR Southern NJ |  |  | Lewis |  |  |  |  | 4 | 3 | 3 | 3 | 3 | 5 | 5 | 4 | 4 | 5 | 5 | 4 | 0 | 5 | 5 | 3 | 4 | 3 | 3 | Better | Yes | No
EDIDX2155 |  | OCR Southern NJ |  |  | Lewis |  |  |  |  | 4 | 5 | 5 | 4 | 5 | 5 | 5 | 5 | 4 | 4 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 4 | 5 | N/A | Yes | No
EDIDX2156 |  | OCR Southern NJ |  |  | Lewis |  |  |  |  | 4 | 3 | 3 | 3 | 3 | 5 | 5 | 4 | 4 | 5 | 5 | 4 | 0 | 5 | 5 | 3 | 4 | 3 | 3 | Better | Yes | No
EDIDX2183 |  | OCR Southern NJ |  |  | Lewis |  |  |  |  | 4 | 3 | 3 | 3 | 3 | 5 | 5 | 4 | 4 | 5 | 5 | 4 | 0 | 5 | 5 | 3 | 4 | 3 | 3 | Better | Yes | No
EDIDX3006 |  | OCR Southern NJ |  |  | Lewis |  |  |  |  | 5 | 4 | 5 | 5 | 5 | 5 | 0 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | Better | Yes | Yes
EDIDX3008 |  | OCR Southern NJ |  |  | Lewis |  |  |  |  | 3 | 5 | 5 | 5 | 5 | 5 | 3 | 4 | 0 | 5 | 5 | 4 | 4 | 4 | 5 | 5 | 5 | 5 | 4 | Same | Yes | No
EDIDX2138 |  | OCR Southern NJ |  |  | Lewis |  |  |  |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 0 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | Better | Yes | No
EDIDX2157 |  | OCR Southern NJ |  |  | Lewis |  |  |  |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 0 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | Better | Yes | No
EDIDX3072 |  | OCR Southern NJ |  |  | Lewis |  |  |  |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | Same | Yes | No
EDIDX2177 |  | OCR Southern NJ |  |  | Lewis |  |  |  |  | 4 | 3 | 2 | 3 | 2 | 3 | 3 | 3 | 3 | 4 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | Better | Yes | Yes
EDIDX2178 |  | OCR Southern NJ |  |  | Lewis |  |  |  |  | 4 | 3 | 2 | 3 | 2 | 3 | 3 | 3 | 3 | 4 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | Better | Yes | Yes
EDIDX3013 |  | OCR Southern NJ |  |  | Lewis |  |  |  |  | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 0 | 5 | 4 | 4 | 5 | 5 | 5 | 4 | 3 | 4 | Better | Yes | No
PPLDX704 |  | [NAME] |  |  | Lewis |  |  |  |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | Better | N/A | No
PPLDX732 |  | [NAME] |  |  | Lewis |  |  |  |  | 5 | 4 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 0 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | Better | Yes | Yes
 |  | [NAME] |  |  | Lewis |  |  |  |  | 0 | 4 | 4 | 4 | 4 | 0 | 4 | 4 | 5 | 4 | 5 | 0 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | N/A | Yes | Yes
PPLDX742 |  | [NAME] |  |  | Lewis |  |  |  |  | 4 | 4 | 5 | 2 | 3 | 5 | 2 | 3 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 0 | 5 | Same | N/A | Yes
PPLDX701 |  | [NAME] |  |  | Lewis |  |  |  |  | 5 | 5 | 5 | 0 | 3 | 5 | 5 | 5 | 0 | 0 | 4 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | N/A | Yes | Yes
PPLDX777 |  | [NAME] |  |  | Lewis |  |  |  |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | Same | Yes | Yes
[NAME] |  | [NAME] |  |  | Lewis |  |  |  |  | 3 | 4 | 4 | 3 | 4 | 4 | 4 | 4 | 3 | 4 | 3 | 4 | 4 | 3 | 4 | 4 | 4 | 4 | 4 | Better | Yes | No
 |  | [NAME] |  |  | Lewis |  |  |  |  | 5 | 4 | 5 | 4 | 5 | 5 | 5 | 4 | 0 | 5 | 4 | 0 | 5 | 4 | 4 | 4 | 4 | 4 | 4 | Better | Yes | No
PPLDX2780 |  | [NAME] |  |  | Lewis |  |  |  |  | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | Same | Yes | No
PPLDX703 |  | [NAME] |  |  | Lewis |  |  |  |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | Better | Yes | No
PPLDX704 |  | [NAME] |  |  | Lewis |  |  |  |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | Better | Yes | No
 |  |  |  |  | [NAME] |  |  |  | 4 |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
 |  |  |  |  | Curly |  |  |  | 3 |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
 |  |  |  |  | Mo |  |  |  | 3 |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
 |  |  |  |  |  |  |  |  | 4 |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5