Spreadsheet: 0ecc4542-ee8a-46f9-9d5d-f3d94a23a3a5
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Collapse | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26 | Unnamed: 27 | Unnamed: 28 | Unnamed: 29 | Unnamed: 30 | Unnamed: 31 | Unnamed: 32 | Unnamed: 33 | Unnamed: 34 | Unnamed: 35 | Unnamed: 36 | Unnamed: 37
 |  |  |  |  |  | Claims  Report* | % of Year Complete |  |  |  |  | 2013-07-01 00:00:00
[NAME] as of 2/14/2014 |  |  |  |  |  | 2014-02-14 00:00:00 | 0.6263736263736264
 |  |  |  |  |  |  |  |  |  |  |  | 228 |  | Paste Reduction Table Here- If it matches |  |  |  |  | Rection Table |  |  |  | Paste Claims PT Here
Insurer | Client Count  (YTD) | Sum of Paid  Plus Incentive | %  of Non-Medicaid | Non-Medicaid Total | Medicaid Total | Budget | % of Budget |  | Projected EOY Total GF Spending | Amount Over (Under) GF Budget |  | 16.28571428571428 |  | Row Labels | Count of Sum of Paid Plus Incentive | Sum of Sum of Paid Plus Incentive |  |  | Row Labels | Count of Sum of Paid Plus Incentive | Sum of Sum of Paid Plus Incentive |  | Row Labels | Count of Sum of Paid Plus Incentive | Row Labels | Sum of Sum of Paid Plus Incentive |  |  | Row Labels | Count of Sum of Paid Plus Incentive | Row Labels | Sum of Sum of Paid Plus Incentive |  | Row Labels | Count of Sum of Paid Plus Incentive | Sum of Sum of Paid Plus Incentive
DHW - IDHW - ATR-III - Administrative | 97 | 4101.939999999996 | 1 | 4101.939999999996 | 0 |  |  |  |  |  |  |  |  | DHW - IDHW - Adolescent - Medicaid | 1 | 14578.98000000001 |  |  | DHW - IDHW - Adolescent - Medicaid | 1 | 14578.98000000001 |  | DHW - IDHW - Adolescent - Medicaid | 1 | DHW - IDHW - Adolescent - Medicaid | 14578.98000000001 |  |  | DHW - IDHW - Adolescent - Medicaid | 1 | DHW - IDHW - Adolescent - Medicaid | 14578.98000000001 |  | DHW - IDHW - Adolescent - Medicaid | 1 | 14578.98000000001
DHW - IDHW - ATR-III Adolescent Benefit | 76 | 40520.72 | 1 | 40520.72 | 0 |  |  |  |  |  |  |  |  | DHW - IDHW - Adult | 48 | 58806.29 |  |  | DHW - IDHW - Adult | 48 | 58806.29 |  | DHW - IDHW - Adult | 48 | DHW - IDHW - Adult | 58806.29 |  |  | DHW - IDHW - Adult | 48 | DHW - IDHW - Adult | 58806.29 |  | DHW - IDHW - Adult | 48 | 58806.29
DHW - IDHW - ATR-III Adolescent Benefit - Medicaid | 28 | 6021.910000000001 | 0.3 | 1806.573 | 4215.337 |  |  |  |  |  |  |  |  | DHW - IDHW - Adult - Medicaid | 1 | 2781.259999999999 |  |  | DHW - IDHW - Adult - Medicaid | 1 | 2781.259999999999 |  | DHW - IDHW - Adult - Medicaid | 1 | DHW - IDHW - Adult - Medicaid | 2781.259999999999 |  |  | DHW - IDHW - Adult - Medicaid | 1 | DHW - IDHW - Adult - Medicaid | 2781.259999999999 |  | DHW - IDHW - Adult - Medicaid | 1 | 2781.259999999999
DHW - IDHW - ATR-III Military Benefit | 308 | 263780.4499999999 | 1 | 263780.4499999999 | 0 |  |  |  |  |  |  |  |  | DHW - IDHW - ATR-III - Administrative | 97 | 4101.939999999996 |  |  | DHW - IDHW - ATR-III - Administrative | 97 | 4101.939999999996 |  | DHW - IDHW - ATR-III - Administrative | 97 | DHW - IDHW - ATR-III - Administrative | 4101.939999999996 |  |  | DHW - IDHW - ATR-III - Administrative | 97 | DHW - IDHW - ATR-III - Administrative | 4101.939999999996 |  | DHW - IDHW - ATR-III - Administrative | 97 | 4101.939999999996
DHW - IDHW - ATR-III Military Benefit - Medicaid | 27 | 27229.47 | 0.3 | 8168.841 | 19060.629 |  |  |  |  |  |  |  |  | DHW - IDHW - ATR-III Adolescent Benefit | 76 | 40520.72 |  |  | DHW - IDHW - ATR-III Adolescent Benefit | 76 | 40520.72 |  | DHW - IDHW - ATR-III Adolescent Benefit | 76 | DHW - IDHW - ATR-III Adolescent Benefit | 40520.72 |  |  | DHW - IDHW - ATR-III Adolescent Benefit | 76 | DHW - IDHW - ATR-III Adolescent Benefit | 40520.72 |  | DHW - IDHW - ATR-III Adolescent Benefit | 76 | 40520.72
DHW - IDHW - ATR-III Misdemeanor | 1553 | 1238969.110000002 | 1 | 1238969.110000002 | 0 |  |  |  |  |  |  |  |  | DHW - IDHW - ATR-III Adolescent Benefit - Medicaid | 28 | 6021.910000000001 |  |  | DHW - IDHW - ATR-III Adolescent Benefit - Medicaid | 28 | 6021.910000000001 |  | DHW - IDHW - ATR-III Adolescent Benefit - Medicaid | 28 | DHW - IDHW - ATR-III Adolescent Benefit - Medicaid | 6021.910000000001 |  |  | DHW - IDHW - ATR-III Adolescent Benefit - Medicaid | 28 | DHW - IDHW - ATR-III Adolescent Benefit - Medicaid | 6021.910000000001 |  | DHW - IDHW - ATR-III Adolescent Benefit - Medicaid | 28 | 6021.910000000001
DHW - IDHW - ATR-III Misdemeanor - Medicaid | 106 | 63029.95 | 0.3 | 18908.985 | 44120.965 |  |  |  |  |  |  |  |  | DHW - IDHW - ATR-III Military Benefit | 308 | 263780.4499999999 |  |  | DHW - IDHW - ATR-III Military Benefit | 308 | 263780.4499999999 |  | DHW - IDHW - ATR-III Military Benefit | 308 | DHW - IDHW - ATR-III Military Benefit | 263780.4499999999 |  |  | DHW - IDHW - ATR-III Military Benefit | 308 | DHW - IDHW - ATR-III Military Benefit | 263780.4499999999 |  | DHW - IDHW - ATR-III Military Benefit | 308 | 263780.4499999999
ATR Total | 2195 | 1643653.550000002 |  | 1576256.619000003 | 67396.931 | 2724921 | 0.5784595659837487 |  | 2516479.865421057 | -208441.1345789433 |  |  |  | DHW - IDHW - ATR-III Military Benefit - Medicaid | 27 | 27229.47 |  |  | DHW - IDHW - ATR-III Military Benefit - Medicaid | 27 | 27229.47 |  | DHW - IDHW - ATR-III Military Benefit - Medicaid | 27 | DHW - IDHW - ATR-III Military Benefit - Medicaid | 27229.47 |  |  | DHW - IDHW - ATR-III Military Benefit - Medicaid | 27 | DHW - IDHW - ATR-III Military Benefit - Medicaid | 27229.47 |  | DHW - IDHW - ATR-III Military Benefit - Medicaid | 27 | 27229.47
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - ATR-III Misdemeanor | 1553 | 1238969.110000002 |  |  | DHW - IDHW - ATR-III Misdemeanor | 1553 | 1238969.110000002 |  | DHW - IDHW - ATR-III Misdemeanor | 1553 | DHW - IDHW - ATR-III Misdemeanor | 1238969.110000002 |  |  | DHW - IDHW - ATR-III Misdemeanor | 1553 | DHW - IDHW - ATR-III Misdemeanor | 1238969.110000002 |  | DHW - IDHW - ATR-III Misdemeanor | 1553 | 1238969.110000002
[NAME] | 48 | 58806.29 | 1 | 58806.29 | 0 |  |  |  |  |  |  |  |  | DHW - IDHW - ATR-III Misdemeanor - Medicaid | 106 | 63029.95 |  |  | DHW - IDHW - ATR-III Misdemeanor - Medicaid | 106 | 63029.95 |  | DHW - IDHW - ATR-III Misdemeanor - Medicaid | 106 | DHW - IDHW - ATR-III Misdemeanor - Medicaid | 63029.95 |  |  | DHW - IDHW - ATR-III Misdemeanor - Medicaid | 106 | DHW - IDHW - ATR-III Misdemeanor - Medicaid | 63029.95 |  | DHW - IDHW - ATR-III Misdemeanor - Medicaid | 106 | 63029.95
Adult-Medicaid | 1 | 2781.259999999999 | 0.3 | 834.3779999999996 | 1946.881999999999 |  |  |  |  |  |  |  |  | DHW - IDHW - Child Protection Drug Court | 41 | 55641.69 |  |  | DHW - IDHW - Child Protection Drug Court | 41 | 55641.69
Adult Total | 49 | 61587.55 |  | 59640.668 | 1946.881999999999 | 100000 | 0.59640668 |  | 95215.8032982456 | -4784.196701754394 |  |  |  | DHW - IDHW - CP/SUD | 454 | 518419.28 |  |  | DHW - IDHW - CP/SUD | 454 | 518419.28 |  | DHW - IDHW - CP/SUD | 454 | DHW - IDHW - CP/SUD | 518419.28 |  |  | DHW - IDHW - CP/SUD | 454 | DHW - IDHW - CP/SUD | 518419.28 |  | DHW - IDHW - CP/SUD | 454 | 518419.28
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - CP/SUD - Medicaid | 80 | 43829.51 |  |  | DHW - IDHW - CP/SUD - Medicaid | 80 | 43829.51 |  | DHW - IDHW - CP/SUD - Medicaid | 80 | DHW - IDHW - CP/SUD - Medicaid | 43829.51 |  |  | DHW - IDHW - CP/SUD - Medicaid | 80 | DHW - IDHW - CP/SUD - Medicaid | 43829.51 |  | DHW - IDHW - CP/SUD - Medicaid | 80 | 43829.51
Adolescent |  |  | 1 | 0 | 0 |  |  |  |  |  |  |  |  | DHW - IDHW - DV Court Misdemeanant | 265 | 308804.5599999999 |  |  | DHW - IDHW - DV Court Misdemeanant | 265 | 308804.5599999999 |  | DHW - IDHW - DV Court Misdemeanant | 265 | DHW - IDHW - DV Court Misdemeanant | 308804.5599999999 |  |  | DHW - IDHW - DV Court Misdemeanant | 265 | DHW - IDHW - DV Court Misdemeanant | 308804.5599999999 |  | DHW - IDHW - DV Court Misdemeanant | 265 | 308804.5599999999
Adolescent-Medicaid | 1 | 14578.98000000001 | 0.3 | 4373.694000000004 | 10205.28600000001 |  |  |  |  |  |  |  |  | DHW - IDHW - DV Court Misdemeanant - Medicaid | 22 | 20925.06 |  |  | DHW - IDHW - DV Court Misdemeanant - Medicaid | 22 | 20925.06 |  | DHW - IDHW - DV Court Misdemeanant - Medicaid | 22 | DHW - IDHW - DV Court Misdemeanant - Medicaid | 20925.06 |  |  | DHW - IDHW - DV Court Misdemeanant - Medicaid | 22 | DHW - IDHW - DV Court Misdemeanant - Medicaid | 20925.06 |  | DHW - IDHW - DV Court Misdemeanant - Medicaid | 22 | 20925.06
Adolescent Total | 1 | 14578.98000000001 |  | 4373.694000000004 | 10205.28600000001 | 100000 | 0.04373694000000004 |  | 6982.564105263164 | -399744.5916920371 |  |  |  | DHW - IDHW - IVDU | 687 | 735607.0799999994 |  |  | DHW - IDHW - IVDU | 687 | 735607.0799999994 |  | DHW - IDHW - IVDU | 687 | DHW - IDHW - IVDU | 735607.0799999994 |  |  | DHW - IDHW - IVDU | 687 | DHW - IDHW - IVDU | 735607.0799999994 |  | DHW - IDHW - IVDU | 687 | 735607.0799999994
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - IVDU - Medicaid | 53 | 76883.58000000006 |  |  | DHW - IDHW - IVDU - Medicaid | 53 | 76883.58000000006 |  | DHW - IDHW - IVDU - Medicaid | 53 | DHW - IDHW - IVDU - Medicaid | 76883.58000000006 |  |  | DHW - IDHW - IVDU - Medicaid | 53 | DHW - IDHW - IVDU - Medicaid | 76883.58000000006 |  | DHW - IDHW - IVDU - Medicaid | 53 | 76883.58000000006
CP-SUD | 454 | 518419.28 | 1 | 518419.28 |  |  |  |  |  |  |  |  |  | DHW - IDHW - Medicaid Only | 921 | 480467.0099999991 |  |  | DHW - IDHW - Medicaid Only | 921 | 480467.0099999991 |  | DHW - IDHW - Medicaid Only | 921 | DHW - IDHW - Medicaid Only | 480467.0099999991 |  |  | DHW - IDHW - Medicaid Only | 921 | DHW - IDHW - Medicaid Only | 480467.0099999991 |  | DHW - IDHW - Medicaid Only | 921 | 480467.0099999991
CP-SUD - Medicaid | 80 | 43829.51 | 0.3 | 13148.853 | 30680.657 |  |  |  |  |  |  |  |  | DHW - IDHW - PWWC | 257 | 415266.09 |  |  | DHW - IDHW - PWWC | 257 | 415266.09 |  | DHW - IDHW - PWWC | 257 | DHW - IDHW - PWWC | 415266.09 |  |  | DHW - IDHW - PWWC | 257 | DHW - IDHW - PWWC | 415266.09 |  | DHW - IDHW - PWWC | 257 | 415266.09
CP-SUD Total | 534 | 562248.7899999999 |  | 531568.1329999999 | 30680.657 | 750000 | 0.7087575106666666 |  | 848643.8614561403 | 98643.8614561403 |  |  |  | DHW - IDHW - PWWC - Medicaid | 155 | 216396.0700000001 |  |  | DHW - IDHW - PWWC - Medicaid | 155 | 216396.0700000001 |  | DHW - IDHW - PWWC - Medicaid | 155 | DHW - IDHW - PWWC - Medicaid | 216396.0700000001 |  |  | DHW - IDHW - PWWC - Medicaid | 155 | DHW - IDHW - PWWC - Medicaid | 216396.0700000001 |  | DHW - IDHW - PWWC - Medicaid | 155 | 216396.0700000001
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - State Hospital | 149 | 202946.51 |  |  | DHW - IDHW - State Hospital | 149 | 202946.51 |  | DHW - IDHW - State Hospital | 149 | DHW - IDHW - State Hospital | 202946.51 |  |  | DHW - IDHW - State Hospital | 149 | DHW - IDHW - State Hospital | 202946.51 |  | DHW - IDHW - State Hospital | 149 | 202946.51
DV Court | 265 | 308804.5599999999 | 1 | 308804.5599999999 | 0 |  |  |  |  |  |  |  |  | DHW - IDHW - State Hospital - Medicaid | 25 | 18509.69 |  |  | DHW - IDHW - State Hospital - Medicaid | 25 | 18509.69 |  | DHW - IDHW - State Hospital - Medicaid | 25 | DHW - IDHW - State Hospital - Medicaid | 18509.69 |  |  | DHW - IDHW - State Hospital - Medicaid | 25 | DHW - IDHW - State Hospital - Medicaid | 18509.69 |  | DHW - IDHW - State Hospital - Medicaid | 25 | 18509.69
DV Court- Medicaid | 22 | 20925.06 | 0.3 | 6277.517999999999 | 14647.542 |  |  |  |  |  |  |  |  | DHW - IDHW - Unknown / Ineligible | 1331 | 18458.93000000004 |  |  | DHW - IDHW - Unknown / Ineligible | 1331 | 18458.93000000004 |  | DHW - IDHW - Unknown / Ineligible | 1331 | DHW - IDHW - Unknown / Ineligible | 18458.93000000004 |  |  | DHW - IDHW - Unknown / Ineligible | 1331 | DHW - IDHW - Unknown / Ineligible | 18458.93000000004 |  | DHW - IDHW - Unknown / Ineligible | 1331 | 18458.93000000004
DV Court Misdemeanant Total | 287 | 329729.6199999999 |  | 315082.0779999999 | 14647.542 | 429000 | 0.7344570582750579 |  | 503025.7736491226 | 74025.77364912262 |  |  |  | DHW - PSC - Mental Health Court | 78 | 85500.16999999998 |  |  | DHW - PSC - Mental Health Court | 78 | 85500.16999999998 |  | DHW - PSC - Mental Health Court | 78 | DHW - PSC - Mental Health Court | 85500.16999999998 |  |  | DHW - PSC - Mental Health Court | 78 | DHW - PSC - Mental Health Court | 85500.16999999998 |  | DHW - PSC - Mental Health Court | 78 | 85500.16999999998
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DHW - PSC - Mental Health Court - Medicaid | 29 | 44719.39999999999 |  |  | DHW - PSC - Mental Health Court - Medicaid | 29 | 44719.39999999999 |  | DHW - PSC - Mental Health Court - Medicaid | 29 | DHW - PSC - Mental Health Court - Medicaid | 44719.39999999999 |  |  | DHW - PSC - Mental Health Court - Medicaid | 29 | DHW - PSC - Mental Health Court - Medicaid | 44719.39999999999 |  | DHW - PSC - Mental Health Court - Medicaid | 29 | 44719.39999999999
IVDU | 687 | 735607.0799999994 | 1 | 735607.0799999994 |  |  |  |  |  |  |  |  |  | DHW - PSC - Misdemeanor / DUI Court | 56 | 65928.58 |  |  | DHW - PSC - Misdemeanor / DUI Court | 56 | 65928.58 |  | DHW - PSC - Misdemeanor / DUI Court | 56 | DHW - PSC - Misdemeanor / DUI Court | 65928.58 |  |  | DHW - PSC - Misdemeanor / DUI Court | 56 | DHW - PSC - Misdemeanor / DUI Court | 65928.58 |  | DHW - PSC - Misdemeanor / DUI Court | 56 | 65928.58
IVDU - Medicaid | 53 | 76883.58000000006 | 0.3 | 23065.07400000002 | 53818.50600000004 |  |  |  |  |  |  |  |  | DHW - PSC - Misdemeanor / DUI Court - Medicaid | 7 | 5516.06 |  |  | DHW - PSC - Misdemeanor / DUI Court - Medicaid | 7 | 5516.06 |  | DHW - PSC - Misdemeanor / DUI Court - Medicaid | 7 | DHW - PSC - Misdemeanor / DUI Court - Medicaid | 5516.06 |  |  | DHW - PSC - Misdemeanor / DUI Court - Medicaid | 7 | DHW - PSC - Misdemeanor / DUI Court - Medicaid | 5516.06 |  | DHW - PSC - Misdemeanor / DUI Court - Medicaid | 7 | 5516.06
IVDU Total | 740 | 812490.6599999995 |  | 758672.1539999994 | 53818.50600000004 | 1000000 | 0.7586721539999994 |  | 1211213.438842104 | 211213.4388421043 |  |  |  | Grand Total | 6814 | 4977997.660000001 |  |  | Grand Total | 6814 | 4977997.660000001 |  | Grand Total | 6814 | Grand Total | 4977997.660000001 |  |  | Grand Total | 6814 | Grand Total | 4977997.660000001 |  | Grand Total | 6814 | 4977997.660000001 | 0
PWWC | 257 | 415266.09 | 1 | 415266.09
PWWC - Medicaid | 155 | 216396.0700000001 | 0.3 | 64918.82100000003 | 151477.2490000001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Unknown | 20 | -708.07
PWWC Total | 412 | 631662.1600000001 |  | 480184.9110000001 | 151477.2490000001 | 450000 | 1.06707758 |  | 766610.998263158 | 316610.998263158
State Hospital | 149 | 202946.51 | 1 | 202946.51
State Hospital - Medicaid | 25 | 18509.69 | 0.3 | 5552.906999999999 | 12956.783
State Hospital Total | 174 | 221456.2 |  | 208499.417 | 12956.783 | 325000 | 0.6415366676923078 |  | 332867.4902982457 | 7867.490298245684
Mental Health Court | 78 | 85500.16999999998 | 1 | 85500.16999999998
Mental Health Court - Medicaid | 29 | 44719.39999999999 | 0.3 | 13415.82 | 31303.57999999999
Mental Health Court Total | 107 | 130219.57 |  | 98915.98999999998 | 31303.57999999999 | 300000 | 0.3297199666666666 |  | 157918.5103508771 | -142081.4896491229
Misdemeanant PSC | 56 | 65928.58 | 1 | 65928.58
Misdemeanant PSC - Medicaid | 7 | 5516.06 | 0.3 | 1654.818 | 3861.242
Misdemeanant PSC Total | 63 | 71444.64 |  | 67583.398 | 3861.242 | 275000 | 0.2457578109090909 |  | 107896.3020701754 | -167103.6979298246
Medicaid Only | 921 | 480467.0099999991 | 0.3 | 144140.1029999997 | 336326.9069999994
Medicaid Only Total | 921 | 480467.0099999991 |  | 144140.1029999997 | 336326.9069999994 | 916667 |  |  | 0 | -916667
Direct Client Treatment Delivery Services | 0 | 247828 |  | 247828 | 0 | 546455 | 0.4535195029782873 |  | 395655.2280701754 | -150799.7719298246
Non-Medicaid Total |  |  |  | 4492745.165000002 |  | 7917043 | 0.5674776763243552 |  | 7172628.245877196 | -744414.7541228039
Medicaid Total |  |  |  |  | 714621.5649999995 |  |  |  | 0 | 0
Grand Total | 5483 | 5207366.73 |  |  | 5207366.730000001 | 7917043 | 0.6577413726311706 |  | 8313515.305789474 | 396472.3057894744
V:\BPA Invoices New\2014\20140214\Claims Reports\SR056_SFY14_6-7-13 - 1-30-14_Claims Report_20140214.xlsx
[NAME] | 0 | 0 | 0 | 0 | 0 | 0
Grand Total | 6196 | 3871765.830000111 | 0.786960501172644 | 3046926.778000006 | 824839.0519999991 | 7182150.000000001 | 0.4242360265380151 |  | 7493792.886432447 | 311642.8864324456
GF |  |  |  | 3046926.778000006 |  | 7182150.000000001 | 0.4242360265380151 |  | 7493792.886432447 | 311642.8864324456
Medicaid |  |  |  |  | 824839.0519999991 |  | 0.2914625625441693 |  | 2028658.208972971 | -801341.7910270293
GF Plus Medicaid |  | 3871765.830000005 |  |  |  |  | 0.3867067343178043 |  | 9522451.095405417 | -489698.9045945834
 | 6196 | 3871765.830000005 |  |  |  | 7182150.000000001 |  |  | 7423408.469135149 | 241258.469135149
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0