Spreadsheet: 189dc9e7-79f6-48b5-9f26-56bab83043e7
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
 |  |  |  |  |  | Claims  Report* | % of Year Complete |  |  |  |  | 2013-07-01 00:00:00
[NAME] as of 10/28/2013 |  |  |  |  |  | 2013-10-28 00:00:00 | 0.3269230769230769
 |  |  |  |  |  |  |  |  |  |  |  | 119 |  | 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 |  | 8.5 |  | 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
DHW - IDHW - ATR-III - Administrative | 97 | 4101.939999999996 | 1 | 4101.939999999996 | 0 |  |  |  |  |  |  |  |  | DHW - IDHW - Adolescent - Medicaid | 1 | 14578.98000000002 |  |  | DHW - IDHW - Adolescent - Medicaid | 1 | 14578.98000000002 |  | DHW - IDHW - Adolescent - Medicaid | 1 | DHW - IDHW - Adolescent - Medicaid | 14578.98000000002 |  |  | DHW - IDHW - Adolescent - Medicaid | 1 | DHW - IDHW - Adolescent - Medicaid | 14578.98000000002
DHW - IDHW - ATR-III Adolescent Benefit | 36 | 3866.929999999998 | 1 | 3866.929999999998 | 0 |  |  |  |  |  |  |  |  | DHW - IDHW - Adult | 24 | 33474.59000000001 |  |  | DHW - IDHW - Adult | 24 | 33474.59000000001 |  | DHW - IDHW - Adult | 24 | DHW - IDHW - Adult | 33474.59000000001 |  |  | DHW - IDHW - Adult | 24 | DHW - IDHW - Adult | 33474.59000000001
DHW - IDHW - ATR-III Adolescent Benefit - Medicaid | 28 | 5841.909999999999 | 0.3 | 1752.573 | 4089.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 - ATR-III Military Benefit | 199 | 166250.2399999998 | 1 | 166250.2399999998 | 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 Military Benefit - Medicaid | 27 | 27229.47 | 0.3 | 8168.841 | 19060.629 |  |  |  |  |  |  |  |  | DHW - IDHW - ATR-III Adolescent Benefit | 36 | 3866.929999999998 |  |  | DHW - IDHW - ATR-III Adolescent Benefit | 36 | 3866.929999999998 |  | DHW - IDHW - ATR-III Adolescent Benefit | 36 | DHW - IDHW - ATR-III Adolescent Benefit | 3866.929999999998 |  |  | DHW - IDHW - ATR-III Adolescent Benefit | 36 | DHW - IDHW - ATR-III Adolescent Benefit | 3866.929999999998
DHW - IDHW - ATR-III Misdemeanor | 971 | 652639.8599999993 | 1 | 652639.8599999993 | 0 |  |  |  |  |  |  |  |  | DHW - IDHW - ATR-III Adolescent Benefit - Medicaid | 28 | 5841.909999999999 |  |  | DHW - IDHW - ATR-III Adolescent Benefit - Medicaid | 28 | 5841.909999999999 |  | DHW - IDHW - ATR-III Adolescent Benefit - Medicaid | 28 | DHW - IDHW - ATR-III Adolescent Benefit - Medicaid | 5841.909999999999 |  |  | DHW - IDHW - ATR-III Adolescent Benefit - Medicaid | 28 | DHW - IDHW - ATR-III Adolescent Benefit - Medicaid | 5841.909999999999
DHW - IDHW - ATR-III Misdemeanor - Medicaid | 105 | 62281.15999999997 | 0.3 | 18684.34799999999 | 43596.81199999998 |  |  |  |  |  |  |  |  | DHW - IDHW - ATR-III Military Benefit | 199 | 166250.2399999998 |  |  | DHW - IDHW - ATR-III Military Benefit | 199 | 166250.2399999998 |  | DHW - IDHW - ATR-III Military Benefit | 199 | DHW - IDHW - ATR-III Military Benefit | 166250.2399999998 |  |  | DHW - IDHW - ATR-III Military Benefit | 199 | DHW - IDHW - ATR-III Military Benefit | 166250.2399999998
ATR Total | 1463 | 922211.5099999991 |  | 855464.7319999991 | 66746.77799999998 | 2724921 | 0.3139411131552067 |  | 2616715.650823527 | -108205.3491764734 |  |  |  | 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 Misdemeanor | 971 | 652639.8599999993 |  |  | DHW - IDHW - ATR-III Misdemeanor | 971 | 652639.8599999993 |  | DHW - IDHW - ATR-III Misdemeanor | 971 | DHW - IDHW - ATR-III Misdemeanor | 652639.8599999993 |  |  | DHW - IDHW - ATR-III Misdemeanor | 971 | DHW - IDHW - ATR-III Misdemeanor | 652639.8599999993
[NAME] | 24 | 33474.59000000001 | 1 | 33474.59000000001 | 0 |  |  |  |  |  |  |  |  | DHW - IDHW - ATR-III Misdemeanor - Medicaid | 105 | 62281.15999999997 |  |  | DHW - IDHW - ATR-III Misdemeanor - Medicaid | 105 | 62281.15999999997 |  | DHW - IDHW - ATR-III Misdemeanor - Medicaid | 105 | DHW - IDHW - ATR-III Misdemeanor - Medicaid | 62281.15999999997 |  |  | DHW - IDHW - ATR-III Misdemeanor - Medicaid | 105 | DHW - IDHW - ATR-III Misdemeanor - Medicaid | 62281.15999999997
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 | 25 | 36255.85000000001 |  | 34308.96800000001 | 1946.881999999999 | 100000 | 0.3430896800000001 |  | 104945.0785882353 | 4945.078588235323 |  |  |  | DHW - IDHW - CP/SUD | 251 | 191396.3699999998 |  |  | DHW - IDHW - CP/SUD | 251 | 191396.3699999998 |  | DHW - IDHW - CP/SUD | 251 | DHW - IDHW - CP/SUD | 191396.3699999998 |  |  | DHW - IDHW - CP/SUD | 251 | DHW - IDHW - CP/SUD | 191396.3699999998
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 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
Adolescent |  |  | 1 | 0 | 0 |  |  |  |  |  |  |  |  | DHW - IDHW - DV Court Misdemeanant | 146 | 155321.4399999999 |  |  | DHW - IDHW - DV Court Misdemeanant | 146 | 155321.4399999999 |  | DHW - IDHW - DV Court Misdemeanant | 146 | DHW - IDHW - DV Court Misdemeanant | 155321.4399999999 |  |  | DHW - IDHW - DV Court Misdemeanant | 146 | DHW - IDHW - DV Court Misdemeanant | 155321.4399999999
Adolescent-Medicaid | 1 | 14578.98000000002 | 0.3 | 4373.694000000005 | 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
Adolescent Total | 1 | 14578.98000000002 |  | 4373.694000000005 | 10205.28600000001 | 100000 | 0.04373694000000005 |  | 13378.35811764707 | -86621.64188235292 |  |  |  | DHW - IDHW - IVDU | 458 | 254118.9499999995 |  |  | DHW - IDHW - IVDU | 458 | 254118.9499999995 |  | DHW - IDHW - IVDU | 458 | DHW - IDHW - IVDU | 254118.9499999995 |  |  | DHW - IDHW - IVDU | 458 | DHW - IDHW - IVDU | 254118.9499999995
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - IVDU - Medicaid | 53 | 76883.58 |  |  | DHW - IDHW - IVDU - Medicaid | 53 | 76883.58 |  | DHW - IDHW - IVDU - Medicaid | 53 | DHW - IDHW - IVDU - Medicaid | 76883.58 |  |  | DHW - IDHW - IVDU - Medicaid | 53 | DHW - IDHW - IVDU - Medicaid | 76883.58
CP-SUD | 251 | 191396.3699999998 | 1 | 191396.3699999998 |  |  |  |  |  |  |  |  |  | DHW - IDHW - Medicaid Only | 921 | 479579.0599999987 |  |  | DHW - IDHW - Medicaid Only | 921 | 479579.0599999987 |  | DHW - IDHW - Medicaid Only | 921 | DHW - IDHW - Medicaid Only | 479579.0599999987 |  |  | DHW - IDHW - Medicaid Only | 921 | DHW - IDHW - Medicaid Only | 479579.0599999987
CP-SUD - Medicaid | 80 | 43829.51 | 0.3 | 13148.853 | 30680.657 |  |  |  |  |  |  |  |  | DHW - IDHW - PWWC | 151 | 213152.8 |  |  | DHW - IDHW - PWWC | 151 | 213152.8 |  | DHW - IDHW - PWWC | 151 | DHW - IDHW - PWWC | 213152.8 |  |  | DHW - IDHW - PWWC | 151 | DHW - IDHW - PWWC | 213152.8
CP-SUD Total | 331 | 235225.8799999998 |  | 204545.2229999998 | 30680.657 | 750000 | 0.2727269639999997 |  | 625667.7409411757 | -124332.2590588243 |  |  |  | DHW - IDHW - PWWC - Medicaid | 155 | 216227.19 |  |  | DHW - IDHW - PWWC - Medicaid | 155 | 216227.19 |  | DHW - IDHW - PWWC - Medicaid | 155 | DHW - IDHW - PWWC - Medicaid | 216227.19 |  |  | DHW - IDHW - PWWC - Medicaid | 155 | DHW - IDHW - PWWC - Medicaid | 216227.19
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - State Hospital | 83 | 100306.34 |  |  | DHW - IDHW - State Hospital | 83 | 100306.34 |  | DHW - IDHW - State Hospital | 83 | DHW - IDHW - State Hospital | 100306.34 |  |  | DHW - IDHW - State Hospital | 83 | DHW - IDHW - State Hospital | 100306.34
DV Court | 146 | 155321.4399999999 | 1 | 155321.4399999999 | 0 |  |  |  |  |  |  |  |  | DHW - IDHW - State Hospital - Medicaid | 25 | 18509.68999999999 |  |  | DHW - IDHW - State Hospital - Medicaid | 25 | 18509.68999999999 |  | DHW - IDHW - State Hospital - Medicaid | 25 | DHW - IDHW - State Hospital - Medicaid | 18509.68999999999 |  |  | DHW - IDHW - State Hospital - Medicaid | 25 | DHW - IDHW - State Hospital - Medicaid | 18509.68999999999
DV Court- Medicaid | 22 | 20925.06 | 0.3 | 6277.518000000001 | 14647.542 |  |  |  |  |  |  |  |  | DHW - IDHW - Unknown / Ineligible | 1331 | 18458.92999999999 |  |  | DHW - IDHW - Unknown / Ineligible | 1331 | 18458.92999999999 |  | DHW - IDHW - Unknown / Ineligible | 1331 | DHW - IDHW - Unknown / Ineligible | 18458.92999999999 |  |  | DHW - IDHW - Unknown / Ineligible | 1331 | DHW - IDHW - Unknown / Ineligible | 18458.92999999999
DV Court Misdemeanant Total | 168 | 176246.4999999999 |  | 161598.9579999999 | 14647.542 | 429000 | 0.3766875477855476 |  | 494302.6950588234 | 65302.69505882339 |  |  |  | DHW - PSC - Mental Health Court | 47 | 49350.35000000002 |  |  | DHW - PSC - Mental Health Court | 47 | 49350.35000000002 |  | DHW - PSC - Mental Health Court | 47 | DHW - PSC - Mental Health Court | 49350.35000000002 |  |  | DHW - PSC - Mental Health Court | 47 | DHW - PSC - Mental Health Court | 49350.35000000002
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DHW - PSC - Mental Health Court - Medicaid | 29 | 44584.75999999999 |  |  | DHW - PSC - Mental Health Court - Medicaid | 29 | 44584.75999999999 |  | DHW - PSC - Mental Health Court - Medicaid | 29 | DHW - PSC - Mental Health Court - Medicaid | 44584.75999999999 |  |  | DHW - PSC - Mental Health Court - Medicaid | 29 | DHW - PSC - Mental Health Court - Medicaid | 44584.75999999999
IVDU | 458 | 254118.9499999995 | 1 | 254118.9499999995 |  |  |  |  |  |  |  |  |  | Grand Total | 5241 | 2855690.369999996 |  |  | Grand Total | 5241 | 2855690.369999996 |  | Grand Total | 5241 | Grand Total | 2855690.369999996 |  |  | Grand Total | 5241 | Grand Total | 2855690.369999996
IVDU - Medicaid | 53 | 76883.58 | 0.3 | 23065.074 | 53818.506
IVDU Total | 511 | 331002.5299999994 |  | 277184.0239999995 | 53818.506 | 1000000 | 0.2771840239999995 |  | 847857.0145882337 | -152142.9854117663
PWWC | 151 | 213152.8 | 1 | 213152.8
PWWC - Medicaid | 155 | 216227.19 | 0.3 | 64868.15700000001 | 151359.033
PWWC Total | 306 | 429379.99 |  | 278020.9569999999 | 151359.033 | 450000 | 0.6178243488888887 |  | 850417.0449411762 | 400417.0449411762
State Hospital | 83 | 100306.34 | 1 | 100306.34
State Hospital - Medicaid | 25 | 18509.68999999999 | 0.3 | 5552.906999999997 | 12956.78299999999
State Hospital Total | 108 | 118816.03 |  | 105859.247 | 12956.78299999999 | 325000 | 0.3257207599999999 |  | 323804.7555294117 | -1195.244470588339
Mental Health Court | 47 | 49350.35000000002 | 1 | 49350.35000000002
Mental Health Court - Medicaid | 29 | 44584.75999999999 | 0.3 | 13375.428 | 31209.33199999999
Mental Health Court Total | 76 | 93935.11000000002 |  | 62725.77800000002 | 31209.33199999999 | 300000 | 0.2090859266666667 |  | 191867.0856470589 | -108132.9143529411
Misdemeanant PSC |  |  | 1 | 0
Misdemeanant PSC - Medicaid |  |  | 0.3 | 0 | 0
Misdemeanant PSC Total | 0 | 0 |  | 0 | 0 | 275000 | 0 |  | 0 | -275000
Medicaid Only | 921 | 479579.0599999987 | 0.3 | 143873.7179999996 | 335705.3419999991
Medicaid Only Total | 921 | 479579.0599999987 |  | 143873.7179999996 | 335705.3419999991 | 916667 | 0.1569530898352396 |  | 440084.3138823517 | -476582.6861176483
Unknown / Ineligible / Reserve | 1331 | 18458.92999999999 | 1 | 18458.92999999999
Direct Client Treatment Delivery Services | 0 | 13310 |  | 13310 | 0 | 546455 | 0.02435699188405267
Non-Medicaid Total |  |  |  | 2159724.228999998 |  | 7917043 | 0.2727943032518578 |  | 6606215.288705876 | -1310827.711294124
Medicaid Total |  |  |  |  | 709276.1409999991 |  |  |  | 0 | 0
Grand Total | 5241 | 2869000.369999997 |  |  | 2869000.369999997 | 7917043 | 0.3623828202019361 |  | 8775765.83764705 | 858722.8376470506
V:\BPA Invoices New\2014\20131011\Claims Reports\DHW SR056_SFY14_6-7-13 - 10-10-13_Claims Report_20131011.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