Spreadsheet: 99151d1297880439-cell-reference-to-an-autofilterd-worksheet-problem-2010-bonus-calc
Sheet: By Group

PCP Name | Region | TOTAL | Bonus Adjustment | $ Senior | $ Sr Growth | $ CM | $ CM Growth | $ CM Profitability | $ Sr. Profitability | $P4P | $[NAME] | $ [NAME] | $ Recruits
FAMILY CARE SPECIALIST
HERRERA MD, MARGARET | HCP IPA - EAST LA | 16442.5 | 5000 | 5800 | 800 | 252.5 | 40 | 0 | 500 | 3300 | 750 | 0 | 0
HIROMURA MD, CHRISTOPHER | HCP IPA - EAST LA | 253.75 | 0 | 120 | 0 | 8.75 | 50 | 0 | 0 | 75 | 0 | 0 | 0
HMAYAKYAN MD, SAMVEL | HCP IPA - GLENDALE | 6583.75 | 0 | 240 | 400 | 108.75 | 760 | 0 | 0 | 75 | 0 | 5000 | 0
HO MD, [NAME] | HCP IPA - SAN GABRIEL VALLEY | 2000 | 806.25 | 400 | 400 | 63.75 | 0 | 0 | 0 | 330 | 0 | 0 | 0
HOVHANNISYAN MD, ARMEN | HCP IPA - WESTSIDE | 1273.75 | 0 | 440 | 700 | 16.25 | 110 | 0 | 0 | 7.5 | 0 | 0 | 0
HURTADO-WARNECKE MD, IRMA | HCP IPA - EAST LA | 850 | 0 | 240 | 0 | 12.5 | 0 | 0 | 500 | 97.5 | 0 | 0 | 0
IN MD, [NAME] | HCP IPA - GLENDALE/LA COUNTY | 6966.25 | 3000 | 1360 | 200 | 536.25 | 0 | 250 | 0 | 1620 | 0 | 0 | 0
ISKANDER MD, ROSANNA |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
JIANG MD, SIMON | HCP IPA - EAST WEST REG II | 1000 | 512.5 | 200 | 200 | 17.5 | 70 | 0 | 0 | 0 | 0 | 0 | 0
JIMENEZ MD, FRANCISCO A | HCP IPA - BEVERLY/SAN GABRIEL VALLEY | 1560 | -3920 | 520 | 100 | 97.5 | 150 | 125 | 4000 | 487.5 | 0 | 0 | 0
JIMENO MD, ALBERTO | HCP IPA - BEVERLY/SAN GABRIEL VALLEY | 2132.5 | 0 | 1040 | 500 | 37.5 | 0 | 0 | 0 | 555 | 0 | 0 | 0
KAMDAR MD, ANJANA | HCP IPA - EAST LA | 1693.75 | 0 | 560 | 0 | 76.25 | 480 | 0 | 0 | 577.5 | 0 | 0 | 0
[NAME], [NAME] | HCP IPA - WESTSIDE | 4646.25 | 0 | 1200 | 3000 | 36.25 | 290 | 0 | 0 | 120 | 0 | 0 | 0
KANG MD, [NAME] | HCP IPA - LA COUNTY | 3400 | 1452.5 | 720 | 500 | 117.5 | 190 | 0 | 0 | 420 | 0 | 0 | 0
[NAME], MUSHTAQ AHMAD | HCP IPA - LA COUNTY | 1000 | -4241.25 | 40 | 100 | 6.25 | 50 | 0 | 0 | 45 | 0 | 5000 | 0
[NAME], GLORIA I | HCP IPA - GLENDALE | 0 | -45 | 0 | 0 | 5 | 40 | 0 | 0 | 0 | 0 | 0 | 0
[NAME], KAREN | HCP IPA - LA COUNTY | 3818.75 | 0 | 640 | 400 | 216.25 | 0 | 0 | 2000 | 562.5 | 0 | 0 | 0
[NAME], KENNETH KWANSEUNG | HCP IPA - GLENDALE/LA COUNTY | 2648.75 | 0 | 600 | 0 | 208.75 | 0 | 0 | 500 | 840 | 500 | 0 | 0
[NAME], WON C | HCP IPA - LA COUNTY | 0 | -40 | 0 | 0 | 17.5 | 0 | 0 | 0 | 22.5 | 0 | 0 | 0
KIRAKOSYAN MD, KARINE | HCP IPA - GLENDALE | 3500 | 2133.75 | 480 | 0 | 153.75 | 0 | 0 | 500 | 232.5 | 0 | 0 | 0
[NAME], GEMMA TH | HCP IPA - BEVERLY/SAN GABRIEL VALLEY | 10000 | 3783.75 | 1520 | 400 | 73.75 | 0 | 125 | 1500 | 1597.5 | 1000 | 0 | 0
[NAME], CLAIRE | HCP IPA - EAST LA/LA COUNTY | 401.25 | 0 | 240 | 0 | 3.75 | 0 | 0 | 0 | 157.5 | 0 | 0 | 0
TOTAL FAMILY CARE SPECIALIST |  | 70171.25 | 8442.5 | 16360 | 7700 | 2066.25 | 2230 | 500 | 9500 | 11122.5 | 2250 | 10000 | 0
WHITE MEMORIAL MEDICAL GROUP
VILLEGAS MD, SERGIO | HCP IPA - EAST LA/LA COUNTY | 3445 | 0 | 1320 | 400 | 72.5 | 0 | 500 | 0 | 652.5 | 500 | 0 | 0
[NAME], [NAME] | HCP IPA - EAST WEST REG II | 1000 | 265 | 280 | 200 | 25 | 140 | 0 | 0 | 90 | 0 | 0 | 0
[NAME], [NAME] | HCP IPA - BEVERLY | 1390 | 0 | 0 | 0 | 95 | 0 | 500 | 0 | 795 | 0 | 0 | 0
WANSKI MD, Z [NAME] | HCP IPA - LA COUNTY | 16852.5 | 0 | 4120 | 1400 | 380 | 0 | 0 | 500 | 5452.5 | 0 | 5000 | 0
WARAICH MD, BASHIR A | HCP IPA - SAN GABRIEL VALLEY | 0 | -147.5 | 40 | 100 | 7.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0
WARE MD, MICHELE | HCP IPA - GLENDALE | 630 | 0 | 160 | 0 | 122.5 | 160 | 0 | 0 | 187.5 | 0 | 0 | 0
WASSILY MD, VICTOR | HCP IPA - LA COUNTY | 1000 | 750 | 80 | 0 | 7.5 | 20 | 0 | 0 | 142.5 | 0 | 0 | 0
WONG MD, KAI YIP | HCP IPA - EAST WEST REG II | 0 | -158.75 | 40 | 100 | 3.75 | 0 | 0 | 0 | 15 | 0 | 0 | 0
TOTAL WHITE MEMORIAL MEDICAL GROUP |  | 24317.5 | 708.75 | 6040 | 2200 | 713.75 | 320 | 1000 | 500 | 7335 | 500 | 5000 | 0
MONTES MEDICAL GROUP
PROTACIO MD, RODOLFO B | HCP IPA - GLENDALE | 13000 | 7210 | 2160 | 800 | 155 | 180 | 375 | 500 | 1620 | 0 | 0 | 0
[NAME], FRANCISCO |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
REDDY MD, NAVEEN C | HCP IPA - EAST LA | 1000 | 837.5 | 40 | 100 | 2.5 | 20 | 0 | 0 | 0 | 0 | 0 | 0
ROMAN MD, RICARDO RICHARD | HCP IPA - GLENDALE | 10000 | 3517.5 | 2840 | 0 | 192.5 | 0 | 0 | 500 | 1950 | 1000 | 0 | 0
TOTAL MONTES MEDICAL GROUP |  | 24000 | 11565 | 5040 | 900 | 350 | 200 | 375 | 1000 | 3570 | 1000 | 0 | 0
MODERN CONCEPT MEDICAL GROUP
PAN MD, ZHAO YANG(CHARLES) | HCP IPA - EAST WEST REG II | 0 | -237.5 | 80 | 100 | 10 | 40 | 0 | 0 | 7.5 | 0 | 0 | 0
PATEL MD, AMI N | HCP IPA - HILLCREST | 1000 | 298.75 | 160 | 400 | 18.75 | 100 | 0 | 0 | 22.5 | 0 | 0 | 0
TOTAL MODERN CONCEPT MEDICAL GROUP |  | 1000 | 61.25 | 240 | 500 | 28.75 | 140 | 0 | 0 | 30 | 0 | 0 | 0
[NAME]
[NAME], FRANKLIN C | HCP IPA - SAN GABRIEL VALLEY | 0 | -7.5 | 0 | 0 | 7.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NUR MD, KHALID | HCP IPA - BEVERLY/SAN GABRIEL VALLEY | 1000 | 43.75 | 480 | 0 | 33.75 | 0 | 0 | 0 | 442.5 | 0 | 0 | 0
PACHECO MD, ARMANDO | HCP IPA - GLENDALE | 6755 | 0 | 2880 | 1100 | 155 | 0 | 250 | 500 | 1620 | 250 | 0 | 0
PAJA MD, ISAIAS | HCP IPA - LA COUNTY | 1088.75 | -5000 | 280 | 700 | 11.25 | 90 | 0 | 0 | 7.5 | 0 | 5000 | 0
TOTAL [NAME] MEDICAL GROUP |  | 8843.75 | -4963.75 | 3640 | 1800 | 207.5 | 90 | 250 | 500 | 2070 | 250 | 5000 | 0
FAMILY PRACTICE OF GLENDALE
[NAME], PABLO | HCP IPA - HILLCREST | 0 | -6080 | 480 | 100 | 65 | 30 | 0 | 0 | 405 | 0 | 5000 | 0
CHURG MD, WARREN | HCP IPA - GLENDALE/HILLCREST | 0 | -5866.25 | 320 | 300 | 66.25 | 0 | 0 | 0 | 180 | 0 | 5000 | 0
CORNELL MD, [NAME] | HCP IPA - GLENDALE/HILLCREST | 18602.5 | 0 | 5840 | 0 | 1202.5 | 0 | 0 | 500 | 5310 | 750 | 5000 | 0
CUNNINGHAM MD, [NAME] | HCP IPA - GLENDALE/HILLCREST | 16448.75 | 0 | 3360 | 400 | 1238.75 | 0 | 0 | 500 | 5700 | 250 | 5000 | 0
GRIGORIAN MD, ELA | HCP IPA - GLENDALE/HILLCREST | 0 | -4568.75 | 320 | 500 | 283.75 | 1480 | 0 | 0 | 735 | 1250 | 0 | 0
HOWARD MD, JULIE A | HCP IPA - GLENDALE/HILLCREST | 0 | -7866.25 | 560 | 900 | 231.25 | 920 | 0 | 0 | 255 | 0 | 5000 | 0
KHANOYAN MD, SIRVARD | HCP IPA - GLENDALE/HILLCREST | 0 | -14355 | 800 | 1500 | 420 | 2470 | 250 | 1500 | 2415 | 0 | 5000 | 0
KHUBESRIAN MD, MARINA | HCP IPA - HILLCREST | 0 | -5116.25 | 40 | 0 | 16.25 | 0 | 0 | 0 | 60 | 0 | 5000 | 0
MARCUS MD, [NAME] | HCP IPA - GLENDALE/HILLCREST | 0 | -18878.75 | 4800 | 0 | 1278.75 | 0 | 0 | 0 | 7050 | 750 | 5000 | 0
[NAME], [NAME] | HCP IPA - EAST WEST REG II | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
MILLER MD, KATRINA | HCP IPA - GLENDALE/HILLCREST | 0 | -11480 | 680 | 400 | 200 | 170 | 250 | 4000 | 780 | 0 | 5000 | 0
SAWIRIS MD, SAMIR | HCP IPA - GLENDALE/HILLCREST | 0 | -18882.5 | 6720 | 200 | 420 | 80 | 0 | 0 | 5212.5 | 1250 | 5000 | 0
YU MD, JACK | HCP IPA - GLENDALE/HILLCREST | 0 | -10465 | 1520 | 600 | 277.5 | 10 | 0 | 500 | 1807.5 | 750 | 5000 | 0
TOTAL FAMILY PRACTICE OF GLENDALE |  | 35051.25 | -103558.75 | 25440 | 4900 | 5700 | 5160 | 500 | 7000 | 29910 | 5000 | 55000 | 0