Spreadsheet: 150886d1334711633-rank-formula-miscalculation-scorecard-041712
Sheet: RSA Scorecard 2012

RSA | Pharmacy | Service - Billing | Service - Lack of Relationship with Decision Maker | Service - Medical Records | Service - Medication Errors | Service - Medications not Delivered Timely | Service - Stat Errors | Service - State Survey Issues (Pharmacy Related | Service - Technology | All Loss Revenue | Rank out of 35 | Total Service Loss Revenue | Rank out of 35 | Average Survey Score | Rank out of 35 | Recommend OCR | Rank out of 35 | Total Surveys | Total Score | Possible | % | FINAL Rank
Eastern PA |  |  |  |  |  |  |  |  |  |  |  | 9344825 |  | 3.29 |  | 0.5094339622641509 |  | 53
Colorado |  |  |  |  |  |  |  |  |  |  |  | 1944561 |  | 3.73 |  | 0.6615384615384615 |  | 65
Chicago |  |  |  |  |  |  |  |  |  |  |  | 3487407 |  | 3.9 |  | 0.7680412371134021 |  | 194
Perrysburg |  |  |  |  |  |  |  |  |  |  |  | 3429763 |  | 3.81 |  | 0.7807486631016043 |  | 187
New England |  |  |  |  |  |  |  |  |  |  |  | 847184 |  | 3.82 |  | 0.7727272727272727 |  | 110
Arkansas |  |  |  |  |  |  |  |  |  |  |  | 327972 |  | 3.63 |  | 0.782608695652174 |  | 46
Northern California |  |  |  |  |  |  |  |  |  |  |  | 672116 |  | 3.82 |  | 0.7841726618705036 |  | 139
Southern California |  |  |  |  |  |  |  |  |  |  |  | 1423081 |  | 3.86 |  | 0.7982456140350878 |  | 114
Stand Alone  NE |  |  |  |  |  |  |  |  |  |  |  | 15701 |  | 3.78 |  | 0.8 |  | 15
Maryland |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 3.68 |  | 0.6923076923076923 |  | 13
Indianapolis |  |  |  |  |  |  |  |  |  |  |  | 1835898 |  | 4.04 |  | 0.9145299145299145 |  | 117
Iowa |  |  |  |  |  |  |  |  |  |  |  | 1191148 |  | 0 |  | 0 |  | 0
Connecticut |  |  |  |  |  |  |  |  |  |  |  | 335053 |  | 4.01 |  | 0.8735632183908046 |  | 87
St. Louis |  |  |  |  |  |  |  |  |  |  |  | 2477434 |  | 4.19 |  | 0.8670212765957447 |  | 188
Pacific Northwest |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 3.9 |  | 0.7613636363636364 |  | 88
Tennessee |  |  |  |  |  |  |  |  |  |  |  | 265005 |  | 4.19 |  | 0.8095238095238095 |  | 21
Florida |  |  |  |  |  |  |  |  |  |  |  | 1136209 |  | 4.18 |  | 0.9104477611940298 |  | 67
Kentucky |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 4.02 |  | 0.7727272727272727 |  | 66
Carolina |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 3.98 |  | 0.7758620689655172 |  | 58
Wisconsin |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 3.88 |  | 0.8478260869565217 |  | 184
North Texas |  |  |  |  |  |  |  |  |  |  |  | 1467260 |  | 4.26 |  | 0.9270833333333334 |  | 96
Upstate New York |  |  |  |  |  |  |  |  |  |  |  | 50933 |  | 4.14 |  | 0.9326923076923077 |  | 208
South Texas |  |  |  |  |  |  |  |  |  |  |  | 335616 |  | 4.17 |  | 0.9482758620689655 |  | 58
Stand Alone  C |  |  |  |  |  |  |  |  |  |  |  | 16435 |  | 4.21 |  | 0.8958333333333334 |  | 96
Atlanta |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 4.04 |  | 0.875 |  | 48
West Pennsylvania |  |  |  |  |  |  |  |  |  |  |  | 3495066 |  | 4.79 |  | 1 |  | 1
Salt Lake |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 4.04 |  | 0.8961038961038961 |  | 77
Arizona |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 4.08 |  | 0.9333333333333333 |  | 15
Downstate New York |  |  |  |  |  |  |  |  |  |  |  | 37 |  | 4.21 |  | 0.9744897959183674 |  | 196
New Jersey |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 4.12 |  | 0.9285714285714286 |  | 42
Stand Alone  M |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 4.18 |  | 0.9528301886792453 |  | 106
Stand Alone  W |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 4.37 |  | 0.9354838709677419 |  | 62
Virginia |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 4.2 |  | 0.9895833333333334 |  | 96
Oklahoma |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 4.44 |  | 0.9444444444444444 |  | 54
Louisiana |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 4.77 |  | 1 |  | 27
Grand |  |  |  |  |  |  |  |  |  |  |  | 34098704