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

Division | RSA | [NAME] | Pharmacy | All Loss Revenue Sans Service | 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
Northeast | Eastern PA | Lewis | CCRX Newport | 5047360 |  | 3604264 |  | 3.343400167084377 |  | 0.5 |  | 12
Northeast | Eastern PA | Lewis | [NAME] | 663275 |  | 615549 |  | 3.426796157059315 |  | 0.7777777777777778 |  | 9
Northeast | New England | Rappa | McClelland | 2535165 |  | 37 |  | 3.957456140350878 |  | 0.9 |  | 10
Central | St. Louis | Inman | Interlock Florissant | 1606904 |  | 22480 |  | 3.960667699039792 |  | 0.8666666666666667 |  | 45
Southeast | Arkansas | [NAME], S | Central Little Rock | 949676 |  | 327972 |  | 3.524968528857348 |  | 0.7560975609756098 |  | 41
West | Stand Alone | Solaro | APS [NAME] | 484022 |  | 952582 |  | 4.521301366275929 |  | 0.9473684210526315 |  | 38
Central | Stand Alone | Meyer | [NAME] | 1923904 |  | 423353 |  | 0 |  | 0 |  | 0
West | North Texas | Swart | OCR Albuquerque | 811934 |  | 416316 |  | 4.268595270534329 |  | 0.8636363636363636 |  | 22
West | Northern California | Wood | [NAME] | 3459934 |  | 335053 |  | 4.56077694235589 |  | 1 |  | 7
Northeast | Eastern PA | Lewis | CCRX [NAME] | 0 |  | 2415775 |  | 3 |  | 1 |  | 1
West | South Texas | Swart | [NAME] | 232606 |  | 2191237 |  | 4.100877192982455 |  | 1 |  | 4
West | Northern California | Wood | Broadway | 0 |  | 463345 |  | 3.913228980161113 |  | 0.8846153846153846 |  | 26
Mideast | Indianapolis | Schrader | D&R Louisville | 0 |  | 104479 |  | 2.789473684210526 |  | 1 |  | 1
Central | St. Louis | Inman | Denman | 32774 |  | 0 |  | 3.975401791191264 |  | 1 |  | 13
Mideast | Virginia | [NAME], D | Extended Care Assoc | 521 |  | 0 |  | 4.040746603350482 |  | 1 |  | 21
West | [NAME] | Wood | [NAME] | 1788595 |  | 142919 |  | 4.255882352941176 |  | 1 |  | 5
Southeast | Carolina | Henderson | CCRX of Raleigh | 605728 |  | 0 |  | 4.831766917293233 |  | 1 |  | 8
West | North Texas | Swart | OCR Amarillo | 1567990 |  | 0 |  | 4.37719298245614 |  | 1 |  | 3
West | Stand Alone | Solaro | Evergreen Spokane | 297849 |  | 0 |  | 3.995128138974888 |  | 0.8888888888888888 |  | 18
Central | Kentucky | Meyer | [NAME] | 0 |  | 1423081 |  | 4.526315789473684 |  | 1 |  | 4
Mideast | Chicago | Agonis | Enloe Peoria | 0 |  | 76807 |  | 3.958742167483305 |  | 0.8235294117647058 |  | 34
Central | Kentucky | Meyer | Beeber | 731729 |  | 0 |  | 4.198300576001405 |  | 0.8571428571428571 |  | 21
Northeast | Downstate New York | [NAME] | Med World | 40006 |  | 0 |  | 4.224889478121641 |  | 0.9927536231884058 |  | 138
Central | Tennessee | Meyer | OCR Memphis | 37757 |  | 16435 |  | 4.02719298245614 |  | 1 |  | 5
West | Arizona | Solaro | OCR CHANDLER | 0 |  | 65852 |  | 3.991721728563834 |  | 1 |  | 12
Southeast | Carolina | Henderson | Best Care | 112131 |  | 0 |  | 4.543859649122806 |  | 1 |  | 4
Central | St. Louis | Inman | [NAME] | 60884 |  | 0 |  | 4.444444444444444 |  | 1 |  | 6
Southeast | Atlanta | Henderson | Medical Arts | 294826 |  | 0 |  | 4.029293822792275 |  | 0.8823529411764706 |  | 17
Central | St. Louis | Inman | Interlock Columbia | 0 |  | 1185042 |  | 3.925412014885699 |  | 0.7272727272727273 |  | 11
Central | St. Louis | Inman | Managed Healthcare | 330781 |  | 0 |  | 4.56628590856656 |  | 0.9772727272727273 |  | 44
Southeast | Carolina | Henderson | Hickory | 69919 |  | 0 |  | 4.6 |  | 1 |  | 1
Mideast | Perrysburg | Schrader | OCR Central OH | 350773 |  | 0 |  | 3.69441778936035 |  | 0.9090909090909091 |  | 22
Northeast | New England | Rappa | OCR Maine Westrook | 3345366 |  | 110511 |  | 3.889570813568687 |  | 0.7735849056603774 |  | 53
Southeast | Florida | [NAME], S | OCR Central FL | 0 |  | 792693 |  | 3.70749791144528 |  | 0.8 |  | 10
Central | St. Louis | Inman | NCS Herin | 223076 |  | 0 |  | 3.782934609250399 |  | 0.8181818181818182 |  | 11
Northeast | Connecticut | Rappa | OCR Connecticut | 827352 |  | 0 |  | 3.984789525638196 |  | 0.8765432098765432 |  | 81
Mideast | Indianapolis | Schrader | [NAME]. [NAME] | 1757907 |  | 0 |  | 3.95856695913231 |  | 0.8695652173913043 |  | 23
West | North Texas | Swart | OCR Lubbock | 8827 |  | 244140 |  | 4.33483709273183 |  | 0.8571428571428571 |  | 7
Central | Stand Alone | Meyer | OCR Morgantown | 1403667 |  | 3077811 |  | 4.192982456140351 |  | 0.6666666666666666 |  | 3
Southeast | Florida | [NAME], S | OCR Panama City | 862865 |  | 1292392 |  | 4.334586466165414 |  | 1 |  | 9
Northeast | West Pennsylvania | Lewis | OCR Greensburg | 545307 |  | 0 |  | 4.789473684210527 |  | 1 |  | 1
West | North Texas | Swart | [NAME]. Worth | 542238 |  | 0 |  | 4.082262185738855 |  | 0.9375 |  | 32
West | Southern California | Wood | [NAME] | 0 |  | 74350 |  | 3.784824707181806 |  | 0.7727272727272727 |  | 44
West | South Texas | Swart | [NAME] | 1652424 |  | 3495066 |  | 3.599498746867167 |  | 1 |  | 7
Central | St. Louis | Inman | Home Pharm Services | 563364 |  | 0 |  | 4.302141021974148 |  | 0.7755102040816326 |  | 49
West | Pacific Northwest | Solaro | Evergreen Portland | 95880 |  | 0 |  | 3.771364825989661 |  | 0.675 |  | 40
West | South Texas | Swart | OCR Nacogdoches | 1480322 |  | 0 |  | 4.759273182957394 |  | 1 |  | 10
Mideast | Maryland | [NAME], D | OCR Annapolis Junction | 260631 |  | 0 |  | 3.682860998650472 |  | 0.6923076923076923 |  | 13
Northeast | Connecticut | Rappa | [NAME] | 248924 |  | 26507 |  | 4.363157894736842 |  | 0.8333333333333334 |  | 6
Southeast | Florida | [NAME], S | [NAME] | 0 |  | 2709237 |  | 0 |  | 0 |  | 0
Central | Kentucky | Meyer | Home Care Cincy | 477944 |  | 0 |  | 3.563459144203246 |  | 0.6 |  | 30
Central | Stand Alone | Inman | [NAME] | 1099667 |  | 0 |  | 4.540789473684211 |  | 1 |  | 21
Mideast | Chicago | Agonis | [NAME] | 911992 |  | 0 |  | 3.925608926714858 |  | 0.7378640776699029 |  | 103
West | Northern California | Wood | OCR Lodi | 0 |  | 1050944 |  | 3.363829748053378 |  | 0.7017543859649122 |  | 57
West | Colorado | Solaro | [NAME] | 0 |  | 991979 |  | 3.645949559497121 |  | 0.5945945945945946 |  | 37
West | Southern California | Wood | BURBANK | 1145013 |  | 0 |  | 0 |  | 0 |  | 0
Southeast | Florida | [NAME], S | [NAME] | 0 |  | 335616 |  | 4.194046924232803 |  | 0.8709677419354839 |  | 31
West | Colorado | Solaro | [NAME] | 0 |  | 332789 |  | 3.79534705301657 |  | 0.7307692307692307 |  | 26
Northeast | Eastern PA | Lewis | OCR Scranton | 601979 |  | 0 |  | 4.081578947368421 |  | 1 |  | 5
Mideast | Perrysburg | Schrader | Eldercare | 149695 |  | 0 |  | 4.56140350877193 |  | 0.6666666666666666 |  | 3
Central | Iowa | Inman | Enloe - Pharmacy Care Associates - Cedar Rapids, IA | 0 |  | 297375 |  | 0 |  | 0 |  | 0
Mideast | Maryland | [NAME], D | Neighborcare Salisbury | 0 |  | 524707 |  | 0 |  | 0 |  | 0
Mideast | Other | Agonis | ROESCHENS WAU | 1612360 |  | 0 |  | 0 |  | 0 |  | 0
Southeast | Florida | [NAME], S | OCR Tampa | 3479393 |  | 0 |  | 4.276491052806842 |  | 1 |  | 14
West | South Texas | Swart | OCR San Antonio | 625725 |  | 0 |  | 4.01193878361061 |  | 0.8947368421052632 |  | 19
Central | Iowa | Inman | OCR Nebraska | 0 |  | 78337 |  | 0 |  | 0 |  | 0
Central | St. Louis | Inman | OCR Pharmacy Midwest | 2065255 |  | 0 |  | 3.730701754385965 |  | 0.6666666666666666 |  | 6
West | Stand Alone | Solaro | Bridgeport | 0 |  | 0 |  | 4.44561403508772 |  | 1 |  | 6
Mideast | Indianapolis | Schrader | Care | 0 |  | 0 |  | 4.285045948203843 |  | 1 |  | 10
Central | St. Louis | Inman | Medicate Farmington | 0 |  | 0 |  | 4.203703703703703 |  | 1 |  | 3
Northeast | New Jersey | Lewis | OCR Southern NJ | 919681 |  | 0 |  | 4.185423778148237 |  | 0.9444444444444444 |  | 18
West | North Texas | Swart | [NAME] | 0 |  | 893773 |  | 4.335395306447938 |  | 0.9545454545454546 |  | 22
West | North Texas | Swart | OCR Waco | 0 |  | 24426 |  | 4.512406015037596 |  | 1 |  | 10
Mideast | Stand Alone | [NAME], D | [NAME] | 0 |  | 0 |  | 4.089949306904072 |  | 0.9454545454545454 |  | 55
Southeast | Carolina | Henderson | [NAME] | 5146942 |  | 0 |  | 4.157894736842105 |  | 1 |  | 2
Southeast | Florida | [NAME], S | [NAME] | 0 |  | 0 |  | 4.473684210526317 |  | 1 |  | 3
Mideast | Stand Alone | [NAME], D | Neighborcare Richmond | 0 |  | 0 |  | 4.333047657399828 |  | 0.975609756097561 |  | 41
West | Arizona | Solaro | Southern [NAME] | 462727 |  | 0 |  | 0 |  | 0 |  | 0
Northeast | Upstate New York | [NAME] | [NAME] | 0 |  | 0 |  | 4.1948312571486 |  | 0.9841269841269841 |  | 63
Mideast | Chicago | Agonis | [NAME] | 0 |  | 0 |  | 4.010097311781493 |  | 0.90625 |  | 32
Southeast | Louisiana | [NAME], S | Campos | 0 |  | 0 |  | 4.915789473684211 |  | 1 |  | 10
West | Pacific Northwest | Solaro | Evergreen Kirkland | 0 |  | 0 |  | 3.98663144809674 |  | 0.9 |  | 20
Northeast | Upstate New York | [NAME] | OCR Western NY | 210049 |  | 0 |  | 4.081902834008098 |  | 0.8846153846153846 |  | 26
Mideast | Chicago | Agonis | OCR Quad Cities Davenport | 37626 |  | 0 |  | 3.580490752573132 |  | 0.64 |  | 25
Northeast | New Jersey | Lewis | OCR Edison | 0 |  | 0 |  | 4.01655858761122 |  | 0.9333333333333333 |  | 15
Mideast | Wisconsin | Agonis | Pinnacle Madison | 0 |  | 1731419 |  | 4.191142772679566 |  | 0.9583333333333334 |  | 24
Southeast | Atlanta | Henderson | Carters | 0 |  | 0 |  | 3.856621947024424 |  | 0.8823529411764706 |  | 17
Mideast | Stand Alone | [NAME], D | Neighborcare Roanoke | 0 |  | 0 |  | 4.02923976608187 |  | 0.9 |  | 10
Central | Stand Alone | Inman | [NAME] | 0 |  | 0 |  | 4.269951837956296 |  | 0.9111111111111111 |  | 45
West | Colorado | Solaro | OCR Grand Junction | 0 |  | 0 |  | 4.447368421052632 |  | 1 |  | 2
Mideast | Perrysburg | Schrader | [NAME] | 0 |  | 0 |  | 4.028755547194471 |  | 0.868421052631579 |  | 38
Southeast | Carolina | Henderson | RX Services | 1287743 |  | 0 |  | 4.111111111111111 |  | 1 |  | 1
Mideast | Virginia | [NAME], D | RX Services Abingdon | 915479 |  | 0 |  | 3.955263157894738 |  | 1 |  | 5
Southeast | Atlanta | Henderson | [NAME] | 0 |  | 0 |  | 4.611111111111111 |  | 1 |  | 1
Central | Oklahoma | Inman | [NAME] | 3715493 |  | 0 |  | 4.285550775334056 |  | 0.9090909090909091 |  | 22
West | South Texas | Swart | [NAME] | 0 |  | 0 |  | 4.271350527697278 |  | 0.9444444444444444 |  | 18
Mideast | Wisconsin | Agonis | Pinnacle La Crosse | 62395 |  | 0 |  | 3.673223646366062 |  | 0.6585365853658537 |  | 41
Mideast | Perrysburg | Schrader | Specialized Grand Rapids | 1369763 |  | 0 |  | 4.130701754385965 |  | 0.8 |  | 5
Mideast | Perrysburg | Schrader | Specialized West Branch | 21243 |  | 15701 |  | 3.833333333333333 |  | 1 |  | 1
West | Pacific Northwest | Solaro | Evergreen Medford | 0 |  | 0 |  | 4.032777749015466 |  | 0.7857142857142857 |  | 28
West | Southern California | Wood | OCR San Diego | 0 |  | 0 |  | 4.351754385964913 |  | 1 |  | 5
Northeast | Upstate New York | [NAME] | [NAME] | 0 |  | 0 |  | 4.154590738006441 |  | 0.9324324324324325 |  | 74
Mideast | Indianapolis | Schrader | OCR South Bend | 0 |  | 0 |  | 4.085030591183842 |  | 0.9411764705882353 |  | 17
Mideast | Indianapolis | Schrader | [NAME] | 0 |  | 0 |  | 3.558771929824562 |  | 0.8461538461538461 |  | 13
Southeast | Carolina | Henderson | [NAME] | 0 |  | 0 |  | 4.042105263157895 |  | 0.8 |  | 10
Southeast | Arkansas | [NAME], S | PHARMACY SOLUTIONS - JONESBORO | 0 |  | 0 |  | 4.492105263157894 |  | 1 |  | 5
Northeast | New England | Rappa | OCR New Hampshire | 0 |  | 0 |  | 3.854081593184575 |  | 0.8421052631578947 |  | 19
West | Northern California | Wood | Creekside | 0 |  | 0 |  | 4.15964091378178 |  | 0.782608695652174 |  | 23
Northeast | Upstate New York | [NAME] | OCR Syracuse | 0 |  | 0 |  | 4.000619124074501 |  | 0.8518518518518519 |  | 27
Mideast | Wisconsin | Agonis | [NAME] | 0 |  | 0 |  | 3.537965634367976 |  | 0.75 |  | 32
Central | Stand Alone | Inman | OCR Minnesota | 0 |  | 0 |  | 3.818283097598724 |  | 0.8148148148148148 |  | 27
Southeast | Louisiana | [NAME], S | Pharmed Holdings | 0 |  | 0 |  | 4.872886762360446 |  | 1 |  | 11
Northeast | New Jersey | Lewis | [NAME] | 0 |  | 0 |  | 4.163847117794487 |  | 0.8888888888888888 |  | 9
West | [NAME] | Wood | OCR BILLINGS | 0 |  | 0 |  | 3.649397242726762 |  | 0.7307692307692307 |  | 26
West | Northern California | Wood | OCR Redding | 0 |  | 0 |  | 4.494920115280227 |  | 0.9090909090909091 |  | 22
Northeast | Upstate New York | [NAME] | Royal Care | 0 |  | 0 |  | 4.189423643951508 |  | 0.9444444444444444 |  | 18
Southeast | Carolina | Henderson | OCR Florence | 0 |  | 0 |  | 3.730263157894737 |  | 0.7777777777777778 |  | 9
Northeast | New England | Lewis | North Shore | 0 |  | 0 |  | 3.657560055843808 |  | 0.6785714285714286 |  | 28
Southeast | Louisiana | [NAME], S | Sterling Healthcare | 0 |  | 154494 |  | 4.235087719298246 |  | 1 |  | 6
West | Southern California | Wood | Pharmacy Support Cerritos | 0 |  | 0 |  | 3.876479032106697 |  | 0.8245614035087719 |  | 57
Mideast | Wisconsin | Agonis | [NAME]'s Milwaukee | 0 |  | 0 |  | 4.022144707051195 |  | 0.9425287356321839 |  | 87
West | Southern California | Wood | [NAME] | 0 |  | 0 |  | 3.930701754385965 |  | 0.625 |  | 8
Central | Oklahoma | Inman | [NAME] | 0 |  | 0 |  | 4.53617850559027 |  | 0.96875 |  | 32
Southeast | Carolina | Henderson | CCRX of Charlotte | 0 |  | 0 |  | 3.736111111111111 |  | 0.5555555555555556 |  | 9
Mideast | Indianapolis | Schrader | PRN | 0 |  | 0 |  | 4.157112239296853 |  | 0.9245283018867925 |  | 53
Central | Tennessee | Meyer | OCR Nashville | 0 |  | 0 |  | 4.12280701754386 |  | 0.6666666666666666 |  | 3
Northeast | Downstate New York | [NAME] | Shore | 0 |  | 0 |  | 4.177594827491069 |  | 0.9310344827586207 |  | 58
Mideast | Perrysburg | Schrader | OCR Northwest OH | 0 |  | 0 |  | 3.770707216759849 |  | 0.7 |  | 30
Mideast | Perrysburg | Schrader | Specialized Livonia | 0 |  | 0 |  | 4.092894986573284 |  | 0.9534883720930233 |  | 43
Central | Kentucky | Meyer | Three Forks Apothecary | 186223 |  | 0 |  | 4.719359003569529 |  | 1 |  | 11
Southeast | Atlanta | Henderson | Unicare Prattsville | 132300 |  | 1061859 |  | 4.25184639921482 |  | 0.8461538461538461 |  | 13
West | [NAME] | Wood | Superior Care Idaho | 1195392 |  | 0 |  | 4.411764705882353 |  | 0 |  | 1
Central | Tennessee | Meyer | OCR Tennessee | 0 |  | 0 |  | 3.86140350877193 |  | 0.75 |  | 8
Mideast | Perrysburg | Schrader | [NAME] | 0 |  | 0 |  | 3.340431755267236 |  | 0.5333333333333333 |  | 45
Northeast | Eastern PA | Lewis | [NAME] of Prussia | 0 |  | 0 |  | 3.067508926130809 |  | 0.3076923076923077 |  | 26
Southeast | Carolina | Henderson | OCR Spartanburg SC | 0 |  | 0 |  | 3.300770866560341 |  | 0.6666666666666666 |  | 12
Southeast | Carolina | Henderson | Neighborcare S. Pines | 0 |  | 0 |  | 4.789473684210527 |  | 0.5 |  | 2
West | [NAME] | Wood | Superior Care St. George | 0 |  | 0 |  | 4.898245614035088 |  | 1 |  | 6
Northeast | Stand Alone | Rappa | Stat Care Pharmacy | 0 |  | 0 |  | 3.781275741802058 |  | 0.8 |  | 15
West | [NAME] | Wood | Superior Care Salt Lake City | 0 |  | 0 |  | 4.104785873082272 |  | 1 |  | 39
Mideast | Virginia | [NAME], D | Williamsons Harrisonburg | 206095 |  | 0 |  | 4.202446135500041 |  | 1 |  | 32
Central | Tennessee | Meyer | [NAME] | 0 |  | 0 |  | 4.892105263157895 |  | 0.8 |  | 5
West | Northern California | Wood | Pharmacy Support Hayward | 0 |  | 0 |  | 3.552631578947369 |  | 0.5 |  | 2
West | Arizona | Solaro | Village Southern Desert | 0 |  | 0 |  | 4.464912280701754 |  | 0.6666666666666666 |  | 3
Northeast | West Pennsylvania | Lewis | CCRx - Kane, PA | 0 |  | 0 |  | 0 |  | 0 |  | 0
Northeast | Eastern PA | Lewis | CCRX CHAMBERS | 0 |  | 0 |  | 0 |  | 0 |  | 0
Northeast | Eastern PA | Lewis | CCRx Mechanicsburg | 0 |  | 0 |  | 0 |  | 0 |  | 0
Central | Kentucky | Meyer | D&R Lexington | 0 |  | 0 |  | 0 |  | 0 |  | 0
West | Pacific Northwest | Solaro | EVERGREEN OF PUGET SOUND | 0 |  | 0 |  | 0 |  | 0 |  | 0
Northeast | Stand Alone | [NAME] | Medico, Ontario, Canada | 0 |  | 0 |  | 0 |  | 0 |  | 0
Northeast | Other | Lewis | NCP - NJ State Contract ([NAME]) | 0 |  | 0 |  | 0 |  | 0 |  | 0
Northeast | Other | [NAME] | NCS at St. Camillus Hospital, NY | 0 |  | 0 |  | 0 |  | 0 |  | 0
Northeast | Eastern PA | Lewis | OCR of Williamsport | 0 |  | 0 |  | 0 |  | 0 |  | 0
Northeast | West Pennsylvania | Lewis | OCR Pittsburgh | 0 |  | 0 |  | 0 |  | 0 |  | 0
Central | Iowa | Inman | OCR Urbandale | 0 |  | 0 |  | 0 |  | 0 |  | 0
West | Southern California | Wood | Pharmacy Advantage - Los Alamitos | 0 |  | 0 |  | 0 |  | 0 |  | 0
West | Northern California | Wood | Pharmacy Advantage - Stockton | 0 |  | 0 |  | 0 |  | 0 |  | 0
Southeast | Florida | [NAME], S | Vanguard Pharmacy Systems - Bradenton, FL | 0 |  | 0 |  | 0 |  | 0 |  | 0
West | Northern California | Wood | [NAME] | 0 |  | 0 |  | 2.147058823529412 |  | 0 |  | 2
Mideast | Perrysburg | Schrader | Zellmed |  |  |  |  | 0 |  | 0 |  | 0
Mideast | Virginia | [NAME], D | Williamsons Richmond | 0 |  | 0 |  | 4.317442453623313 |  | 0.9736842105263158 |  | 38