Spreadsheet: 132978d1324065292-data-referencing-across-tabs-copy-of-survey-input-example
Sheet: Inman Summary

CENTRAL | DIV
INMAN | [NAME]
Pharmacy | Survey #'s | [NAME]
DENMAN PHARM SERV | 57
HOME PHARM SERV | 24
[NAME] | 0
INTERLOCK COLUMBIA | 18
INTERLOCK FLORISSANT | 80
MANAGED HEALTHCARE | 36
MEDICATE FARMINGTON | 17
[NAME] | 20
[NAME] | 26
OCR MINNESOTA | 109
OCR NEBRASKA | 2
OCR PHARMACY MIDWEST | 34
OCR S DAKOTA | 38
OCR URBANDALE | 29
PHARMACY CARE ASSOC | 4
SEQUOIA OKLAHOMA | 67
[NAME] | 58
REGION TOTAL | 619 | 4.160855409027414
 | DENMAN PHARM SERV | HOME PHARM SERV | [NAME] | INTERLOCK COLUMBIA | INTERLOCK FLORISSANT | MANAGED HEALTHCARE | MEDICATE FARMINGTON | [NAME] | [NAME] | OCR MINNESOTA | OCR NEBRASKA | OCR PHARMACY MIDWEST | OCR S DAKOTA | OCR URBANDALE | PHARMACY CARE ASSOC | SEQUOIA OKLAHOMA | [NAME] | REGION AVE.
Pharmacy Average
Ease of ordering (e.g. fax, phone) process | 4.24074074074074 | 4.260869565217392 | 0 | 4.555555555555555 | 4.25 | 4.444444444444445 | 4.411764705882353 | 4.45 | 3.96 | 4.317757009345795 | 5 | 4.484848484848484 | 4.5 | 3.678571428571428 | 4 | 4 | 3.974358974358974 | 4.283056931810323
Medication accuracy (i.e. Right Drug/Right Patient) | 4.127272727272727 | 4.25 | 0 | 4.5625 | 4.197368421052632 | 4.472222222222222 | 4.470588235294118 | 4.9 | 4.04 | 4.264150943396227 | 4 | 4.264705882352941 | 4.289473684210527 | 3.703703703703704 | 3.666666666666667 | 4.155555555555556 | 4.153846153846154 | 4.219878387223342
Routine scheduled deliveries are on time | 3.865384615384615 | 4.041666666666667 | 0 | 4.529411764705882 | 3.769736842105263 | 4.361111111111111 | 4.294117647058823 | 4.7 | 3.884615384615385 | 3.995145631067961 | 4 | 4.205882352941177 | 4.473684210526316 | 3.714285714285714 | 2.666666666666667 | 4.111111111111111 | 3.769230769230769 | 4.023878155467341
Stats are delivered within an appropriate timeframe | 3.908163265306122 | 3.708333333333333 | 0 | 4.066666666666666 | 3.398648648648649 | 4.575757575757576 | 4.25 | 4 | 3.416666666666667 | 3.808080808080808 | 3 | 3.863636363636364 | 4.411764705882353 | 3.444444444444445 | 2.666666666666667 | 3.720930232558139 | 3.607142857142857 | 3.740431389674415
Medical Records are accurate | 3.673076923076923 | 4.291666666666667 | 0 | 4 | 3.953333333333333 | 4.548387096774194 | 4 | 4.45 | 3.3 | 3.852631578947368 | 5 | 3.8125 | 4.090909090909091 | 3.703703703703704 | 3.333333333333333 | 4.088235294117647 | 3.676470588235294 | 3.985890475568597
Medical Records are received by the agreed upon date | 4.083333333333333 | 4.739130434782608 | 0 | 4.411764705882353 | 4.416666666666667 | 4.7 | 4.411764705882353 | 4.85 | 4.15 | 4.289156626506024 | 5 | 4.387096774193548 | 4.67741935483871 | 3.925925925925926 | 4 | 4.411764705882353 | 4.09375 | 4.409235827118367
Pharmacy billing statements are accurate | 3.95 | 3.761904761904762 | 0 | 4.5 | 4.140625 | 4.514285714285714 | 4.294117647058823 | 4.466666666666667 | 3.416666666666667 | 4 | 3.5 | 3.6875 | 4.234375 | 3.666666666666667 | 4.5 | 4.333333333333333 | 3.96969696969697 | 4.058489901642475
Overall rating of the pharmacy's ability to meet your needs | 4.105263157894737 | 4.217391304347826 | 0 | 4.111111111111111 | 4.073333333333333 | 4.638888888888889 | 4.3125 | 4.65 | 3.769230769230769 | 3.962264150943396 | 4.5 | 4.029411764705882 | 4.473684210526316 | 3.517857142857143 | 3.666666666666667 | 4.106060606060606 | 4.03448275862069 | 4.135509116574211
Expertise of infusion (IV) services personnel | 4.357142857142857 | 4.5 | 0 | 4.545454545454546 | 4.337837837837838 | 4.588235294117647 | 4.636363636363637 | 4.428571428571429 | 3.909090909090909 | 4.162162162162162 | #[NAME]! | 4.538461538461538 | 4.470588235294118 | 4.090909090909091 | 3 | 4.083333333333333 | 4.333333333333333 | 4.265432280138163
Expertise of consultant pharmacist | 4.285714285714286 | 4.833333333333333 | 0 | 4.470588235294118 | 4.552631578947368 | 4.71875 | 4.882352941176471 | 4.555555555555555 | 4.625 | 4.290322580645161 | 4 | 4.692307692307693 | 4.657894736842105 | 4.56 | 3.666666666666667 | 4.597826086956522 | 4.358974358974359 | 4.484244878275852
Expertise of other pharmacy services (ie: nursing, QA tech, customer service) | 4.111111111111111 | 4.625 | 0 | 4.470588235294118 | 4.273972602739726 | 4.617647058823529 | 4.764705882352941 | 4.625 | 3.72 | 4.131868131868132 | 4 | 4.357142857142857 | 4.527777777777778 | 4.142857142857143 | 3.333333333333333 | 4.2 | 3.948717948717949 | 4.240607630126163
Staff education | 4.023255813953488 | 4.521739130434782 | 0 | 4.428571428571429 | 4.373134328358209 | 4.428571428571429 | 4.705882352941177 | 4.571428571428571 | 3.304347826086957 | 3.958904109589041 | 4 | 4.185185185185185 | 4.361111111111111 | 3.619047619047619 | 4 | 4.186046511627907 | 4 | 4.166701588556681
Drug information provided by Pharmacists is useful | 4.147058823529412 | 4.75 | 0 | 4.294117647058823 | 4.355263157894737 | 4.647058823529412 | 4.705882352941177 | 4.526315789473684 | 4.153846153846154 | 4.203883495145631 | 4 | 4.409090909090909 | 4.5 | 3.814814814814815 | 4 | 4.478260869565218 | 4.17948717948718 | 4.322817501023573
Assistance in resolving facility or patient concerns | 3.951923076923077 | 4.541666666666667 | 0 | 4.444444444444445 | 4.224358974358974 | 4.685714285714286 | 4.588235294117647 | 4.388888888888889 | 3.461538461538462 | 3.926470588235294 | 4.5 | 4.242424242424242 | 4.513157894736842 | 3.888888888888889 | 4 | 4.155555555555556 | 3.871794871794872 | 4.211566383393009
Timely response to facility or patient concerns | 3.944444444444445 | 4.5 | 0 | 4.277777777777778 | 4.102564102564102 | 4.735294117647059 | 4.529411764705882 | 4.3125 | 3.32 | 3.92156862745098 | 4 | 4 | 4.631578947368421 | 3.678571428571428 | 3.666666666666667 | 4.2 | 3.769230769230769 | 4.099350540401721
Understanding of facility or patient concerns | 3.925925925925926 | 4.541666666666667 | 0 | 4.222222222222222 | 4.115384615384615 | 4.676470588235294 | 4.529411764705882 | 4.473684210526316 | 3.44 | 3.961538461538462 | 4.5 | 3.939393939393939 | 4.552631578947368 | 3.678571428571428 | 3.666666666666667 | 4.177777777777778 | 3.794871794871795 | 4.137263602589647
Courtesy of pharmacy staff | 4.218181818181818 | 4.416666666666667 | 0 | 4.555555555555555 | 4.448717948717949 | 4.617647058823529 | 4.705882352941177 | 4.7 | 3.52 | 4.284403669724771 | 5 | 4.352941176470588 | 4.684210526315789 | 4.107142857142857 | 4 | 4.177777777777778 | 4 | 4.361820463019905
Clear explanation and timely communication about medications that are not available for your order | 3.735849056603774 | 3.958333333333333 | 0 | 4.111111111111111 | 3.590909090909091 | 4.514285714285714 | 4.411764705882353 | 3.95 | 3.34 | 3.759615384615385 | 3.5 | 3.53030303030303 | 4.328947368421052 | 3.357142857142857 | 3 | 3.897959183673469 | 3.390243902439024 | 3.773529046170013
Overall rating of the pharmacy's ability to meet your expectations | 4.038461538461538 | 4.291666666666667 | 0 | 4.333333333333333 | 4.092105263157895 | 4.606060606060606 | 4.529411764705882 | 4.4 | 3.6 | 3.981481481481481 | 4.5 | 3.970588235294118 | 4.592105263157895 | 3.777777777777778 | 3.333333333333333 | 4.121212121212121 | 4.017241379310345 | 4.136548672747062
Recommendation "Yes" | 55 | 21 | 0 | 15 | 70 | 33 | 17 | 17 | 20 | 88 | 2 | 24 | 38 | 22 | 4 | 60 | 49
Recommendation  "No" | 2 | 1 | 0 | 1 | 3 | 0 | 0 | 1 | 4 | 11 | 0 | 5 | 0 | 5 | 0 | 3 | 6
Recommendation "na" | 0 | 2 | 0 | 2 | 7 | 3 | 0 | 2 | 2 | 10 | 0 | 5 | 0 | 2 | 0 | 4 | 3