Spreadsheet: 150886d1334711633-rank-formula-miscalculation-scorecard-041712
Sheet: WIP

Division | RSA | [NAME] | Pharmacy |  | Closed | Collections/ AR | JV / In House Pharmacy | Sold/Under New Management | Other | Per Diem | Pricing | ALL OTHERS | SERVICE | 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
West | Colorado | Solaro | APS - Austin, TX
Central | Kentucky | Meyer | Beeber - Englewood, OH
Southeast | Carolina | Henderson | Best Care LTC - Oxford, NC
West | Stand Alone | Solaro | Bridgeport - Lakewood LTC, WA
West | Northern California | Wood | Broadway Pharmacy - Sacramento, CA
West | Southern California | Wood | Pharmacy Advantage - Burbank
Southeast | Louisiana | [NAME], S | Campo - New Orleans, LA
Mideast | Indianapolis | Schrader | Care - Griffith, IN
Southeast | Atlanta | Henderson | Carters's - Pooler, GA
Northeast | West Pennsylvania | Lewis | CCRx - Kane, PA
Northeast | Eastern PA | Lewis | CCRx - Chambersburg, PA
Northeast | Eastern PA | Lewis | OCR of PA East - Quakertown, PA
Northeast | Eastern PA | Lewis | CCRx - Topton, PA
Northeast | Eastern PA | Lewis | CCRx Mechanicsburg
Northeast | Eastern PA | Lewis | CCRx - Newport, PA
Southeast | Carolina | Henderson | CCRX of Charlotte
Southeast | Carolina | Henderson | CCRx - Raleigh, NC
Southeast | Arkansas | [NAME], S | Central - Little Rock, AR
West | Northern California | Wood | Creekside - Santa Rosa, CA
Central | Kentucky | Meyer | D&R - Lexington, KY
Mideast | Indianapolis | Schrader | D&R - Louisville, KY
Central | St. Louis | Inman | Denman - Quincy, IL
Mideast | Perrysburg | Schrader | Eldercare - Escanaba, MI
Central | Iowa | Inman | Enloe - Pharmacy Care Associates - Cedar Rapids, IA
Mideast | Chicago | Agonis | Enloe - Decatur, IL
Mideast | Chicago | Agonis | Enloe - Peoria, IL
West | Pacific Northwest | Solaro | Evergreen - Kirkland
West | Pacific Northwest | Solaro | Evergreen - Medford
West | Pacific Northwest | Solaro | Evergreen- Puget Sound
West | Pacific Northwest | Solaro | Evergreen - Portland, OR
West | Stand Alone | Solaro | Evergreen - Spokane
Mideast | Virginia | [NAME], D | [NAME], VA
Southeast | Carolina | Henderson | APS - Hickory, NC
Central | Kentucky | Meyer | Home Care - Cincinnati, OH
Central | St. Louis | Inman | Home Pharmacy - Belleville, IL
Central | St. Louis | Inman | Interlock - Columbia, MO
Central | St. Louis | Inman | Interlock - Florissant, MO
Mideast | Perrysburg | Schrader | Lo-Med - Wadsworth, OH
Central | St. Louis | Inman | Managed Health - Springfield, MO
Northeast | New England | Lewis | McClelland Home Health - West Springfield, MA
Northeast | Downstate New York | [NAME] | [NAME]
Southeast | Atlanta | Henderson | Medical Arts - Conyers, GA
Central | St. Louis | Inman | Medicate - Farmington, MO
Northeast | Stand Alone | [NAME] | Medico, Ontario, Canada
Southeast | Florida | [NAME], S | [NAME]. Myers, FL
Northeast | Other | Lewis | NCP - NJ State Contract ([NAME])
Mideast | Wisconsin | Agonis | NCS of Appleton, WI
Northeast | Other | [NAME] | NCS at St. Camillus Hospital, NY
Central | St. Louis | Inman | NCS of Herrin, IL
Southeast | Carolina | Henderson | NCS of Mt. Pleasant, SC
Central | Stand Alone | Inman | NCS of Wichita, KS
Mideast | Stand Alone | [NAME], D | NCP - Portsmouth LLC (JV)
Mideast | Stand Alone | [NAME], D | NCP - Richmond LLC (JV)
Mideast | Stand Alone | [NAME], D | NCP - Roanoke LLC (JV)
Southeast | Carolina | Henderson | NCP - Southern Pines, NC
Mideast | Maryland | [NAME], D | NCP - Salisbury, MD
Northeast | New England | Lewis | North Shore - Peabody, MA
West | North Texas | Swart | NCS of Albuquerque, NM
West | North Texas | Swart | SunScript - Amarillo, TX
Mideast | Maryland | [NAME], D | NCP - Annapolis Jctn, MD
Central | Kentucky | Meyer | Home Care - Ashland, KY
West | Southern California | Wood | NCS of Bakersfield, CA
West | [NAME] | Wood | NCS of Billings, MT
West | Southern California | Wood | OCR of Canoga Park, Canoga Park, CA
Southeast | Florida | [NAME], S | APS - Longwood, FL
Mideast | Perrysburg | Schrader | NCS of Hilliard, OH
West | Arizona | Solaro | Medilife - Phoenix, AZ
West | Northern California | Wood | Owens Pharmacy - Chico, CA
Northeast | Connecticut | Rappa | Value Health - Southington, CT
West | South Texas | Swart | APS - Corpus Christi, TX
Mideast | Perrysburg | Schrader | NCS of Dover, OH
Northeast | New Jersey | Lewis | NCP - Edison, NJ
Southeast | Carolina | Henderson | NCP - Florence, SC
Mideast | Indianapolis | Schrader | NCP - Fort Wayne, IN
West | North Texas | Swart | APS - Fort Worth, TX
West | Colorado | Solaro | NCP - Golden, CO
West | Colorado | Solaro | City Market - Grand Junction, CO
Northeast | West Pennsylvania | Lewis | OCR Greensburg
Northeast | Upstate New York | [NAME] | NCS of New Hartford, NY
Mideast | Indianapolis | Schrader | [NAME], KY
West | South Texas | Swart | APS - Houston, TX
Southeast | Atlanta | Henderson | CompScript - Jackson, MS
Southeast | Florida | [NAME], S | SunScript - Jacksonville, FL
Northeast | Eastern PA | Lewis | NCP - King of Prussia, PA
West | [NAME] | Wood | Resource Pharmacy - Las Vegas, NV
West | Northern California | Wood | NCP - Lodi, CA
West | North Texas | Swart | APS - Lubbock, TX
Northeast | New England | Lewis | OCR Maine, Westbrook ME
Central | Tennessee | Meyer | NCS of Memphis, TN
Central | Stand Alone | Inman | UPA - Golden Valley - Crystal, MN
Central | Stand Alone | Meyer | NCP - Morgantown, WV
Mideast | Chicago | Agonis | Jacobs - Des Plaines, IL
West | South Texas | Swart | SunScript - Nacogdoches, TX
Central | Tennessee | Meyer | [NAME], TN
Central | Iowa | Inman | OPSS - Unidose - Omaha, NE
Northeast | New England | Lewis | NCS of Londonderry, NH
Central | Stand Alone | Meyer | Home Care - Nitro, WV
Mideast | Perrysburg | Schrader | [NAME], OH
Northeast | Eastern PA | Lewis | NCP - Williamsport, PA
Southeast | Florida | [NAME], S | APS - Panama City, FL
Central | St. Louis | Inman | Freed's - Kansas City, MO
West | South Texas | Swart | APS - Pharr, TX
Northeast | West Pennsylvania | Lewis | OCR of PA West - Pittsburgh, PA
West | Colorado | Solaro | APS - Pueblo, CO
Mideast | Chicago | Agonis | Enloe - OCR of the Quad Cities, IA
West | Northern California | Wood | Owens Pharmacy - Redding, CA
West | Northern California | Wood | Resource Pharmacy - Reno, NV
Northeast | Connecticut | Rappa | NCP - Coventry, RI
Northeast | Upstate New York | [NAME] | NCS of Rochester, NY
Central | Stand Alone | Inman | OPSS - Unomed - Sioux Falls, SD
Southeast | Florida | [NAME], S | Medistat - Sunrise (Weston, FL)
West | South Texas | Swart | NCP - San Antonio, TX
West | Southern California | Wood | NCP - San Diego, CA
Northeast | Eastern PA | Lewis | NCP - Scranton, PA
Mideast | Indianapolis | Schrader | NCP - South Bend, IN
Northeast | New Jersey | Lewis | [NAME], NJ
Southeast | Carolina | Henderson | Pharm. Consult. - Spartanburg, SC
Northeast | Upstate New York | [NAME] | NCP - Syracuse, NY
Southeast | Florida | [NAME], S | Medistat - Tampa, FL
Central | Tennessee | Meyer | Medilife - Cleveland, TN
West | North Texas | Swart | SunScript - Tyler, TX
Central | Iowa | Inman | NCS of Urbandale, IA
West | North Texas | Swart | APS - Waco, TX
Northeast | Upstate New York | [NAME] | OCR of W. NY - West Seneca, NY
Northeast | New Jersey | Lewis | NCP - Whippany, NJ
Southeast | Carolina | Henderson | LTC - OCR of Carolina-Wilson, NC
West | Southern California | Wood | Pharmacy Advantage - Los Alamitos
West | Northern California | Wood | Pharmacy Advantage - Stockton
Southeast | Arkansas | [NAME], S | Pharmacy Solutions, Inc. - Jonesboro, AR
West | Southern California | Wood | PSS - Los Angeles, CA
West | Northern California | Wood | PSS - Hayward, CA
Southeast | Louisiana | [NAME], S | Pharmed - Alexandria, LA
Mideast | Wisconsin | Agonis | Pinnacle - LaCrosse, WI
Mideast | Wisconsin | Agonis | Pinnacle - Madison, WI
Mideast | Indianapolis | Schrader | PRN - Indianapolis, IN
Mideast | Other | Agonis | Roeschen's Behavioral Health Systems
Mideast | Wisconsin | Agonis | [NAME]'s OCR Pharmacy - Milwaukee, WI
Northeast | Upstate New York | [NAME] | Royal Care - Malta, NY
Southeast | Carolina | Henderson | RxServices - Wilmington, NC
Mideast | Virginia | [NAME], D | RxServices - Abingdon, VA
Central | Oklahoma | Inman | Sequoia - Oklahoma City, OK
Central | Oklahoma | Inman | [NAME], OK
Northeast | Downstate New York | [NAME] | Shore - Plainview, NY
West | Arizona | Solaro | Southern Desert - Prescott, AZ
Mideast | Perrysburg | Schrader | Specialized West - Grand Rapids, MI
Mideast | Perrysburg | Schrader | Specialized - Livonia, MI
Mideast | Perrysburg | Schrader | Specialized - West Branch, MI
Northeast | Stand Alone | Rappa | Stat Care - North Grafton, MA
Southeast | Louisiana | [NAME], S | Sterling - Shreveport, LA
Central | Tennessee | Meyer | SunScript - Huntsville, AL
West | [NAME] | Wood | Superior Care of Idaho
West | [NAME] | Wood | Superior Care - Salt Lake City, UT
West | [NAME] | Wood | Superior Care - St. George, UT
Central | Kentucky | Meyer | D&R - Three Forks - Beattyville, KY
Southeast | Atlanta | Henderson | Unicare - Prattville, AL
Southeast | Florida | [NAME], S | Vanguard Pharmacy Systems - Bradenton, FL
West | Arizona | Solaro | Southern Desert - Youngtown, AZ
Mideast | Virginia | [NAME], D | [NAME], VA
Mideast | Virginia | [NAME], D | [NAME], VA
Mideast | Perrysburg | Schrader | ZellMed Solutions - Akron, OH