Spreadsheet: 27e36596-ccff-4d26-b52b-0e8b51d1f6cc
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 8/16/2013 |  |  |  |  |  | 2013-08-16 00:00:00 | 0.1263736263736264
 |  |  |  |  |  |  |  |  |  |  |  | 46 |  | 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 |  | 3.285714285714286 |  | 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 | 34 | 2119.31 | 1 | 2119.31 | 0 |  |  |  |  |  |  |  |  | DHW - IDHW - Adolescent - Medicaid | 1 | 12461.01000000001 |  |  | DHW - IDHW - Adolescent - Medicaid | 1 | 12461.01000000001 |  | DHW - IDHW - Adolescent - Medicaid | 1 | DHW - IDHW - Adolescent - Medicaid | 12461.01000000001 |  |  | DHW - IDHW - Adolescent - Medicaid | 1 | DHW - IDHW - Adolescent - Medicaid | 12461.01000000001
DHW - IDHW - ATR-III Adolescent Benefit | 24 | 2304.389999999999 | 1 | 2304.389999999999 | 0 |  |  |  |  |  |  |  |  | DHW - IDHW - Adult | 19 | 10883.58 |  |  | DHW - IDHW - Adult | 19 | 10883.58 |  | DHW - IDHW - Adult | 19 | DHW - IDHW - Adult | 10883.58 |  |  | DHW - IDHW - Adult | 19 | DHW - IDHW - Adult | 10883.58
DHW - IDHW - ATR-III Adolescent Benefit - Medicaid | 26 | 4158.86 | 0.3 | 1247.658 | 2911.202 |  |  |  |  |  |  |  |  | DHW - IDHW - Adult - Medicaid | 1 | 2018.32 |  |  | DHW - IDHW - Adult - Medicaid | 1 | 2018.32 |  | DHW - IDHW - Adult - Medicaid | 1 | DHW - IDHW - Adult - Medicaid | 2018.32 |  |  | DHW - IDHW - Adult - Medicaid | 1 | DHW - IDHW - Adult - Medicaid | 2018.32
DHW - IDHW - ATR-III Military Benefit | 161 | 83159.84999999995 | 1 | 83159.84999999995 | 0 |  |  |  |  |  |  |  |  | DHW - IDHW - ATR-III - Administrative | 34 | 2119.31 |  |  | DHW - IDHW - ATR-III - Administrative | 34 | 2119.31 |  | DHW - IDHW - ATR-III - Administrative | 34 | DHW - IDHW - ATR-III - Administrative | 2119.31 |  |  | DHW - IDHW - ATR-III - Administrative | 34 | DHW - IDHW - ATR-III - Administrative | 2119.31
DHW - IDHW - ATR-III Military Benefit - Medicaid | 26 | 19297.02 | 0.3 | 5789.105999999999 | 13507.914 |  |  |  |  |  |  |  |  | DHW - IDHW - ATR-III Adolescent Benefit | 24 | 2304.389999999999 |  |  | DHW - IDHW - ATR-III Adolescent Benefit | 24 | 2304.389999999999 |  | DHW - IDHW - ATR-III Adolescent Benefit | 24 | DHW - IDHW - ATR-III Adolescent Benefit | 2304.389999999999 |  |  | DHW - IDHW - ATR-III Adolescent Benefit | 24 | DHW - IDHW - ATR-III Adolescent Benefit | 2304.389999999999
DHW - IDHW - ATR-III Misdemeanor | 786 | 313761.5899999989 | 1 | 313761.5899999989 | 0 |  |  |  |  |  |  |  |  | DHW - IDHW - ATR-III Adolescent Benefit - Medicaid | 26 | 4158.86 |  |  | DHW - IDHW - ATR-III Adolescent Benefit - Medicaid | 26 | 4158.86 |  | DHW - IDHW - ATR-III Adolescent Benefit - Medicaid | 26 | DHW - IDHW - ATR-III Adolescent Benefit - Medicaid | 4158.86 |  |  | DHW - IDHW - ATR-III Adolescent Benefit - Medicaid | 26 | DHW - IDHW - ATR-III Adolescent Benefit - Medicaid | 4158.86
DHW - IDHW - ATR-III Misdemeanor - Medicaid | 90 | 42382.58000000001 | 0.3 | 12714.774 | 29667.806 |  |  |  |  |  |  |  |  | DHW - IDHW - ATR-III Military Benefit | 161 | 83159.84999999995 |  |  | DHW - IDHW - ATR-III Military Benefit | 161 | 83159.84999999995 |  | DHW - IDHW - ATR-III Military Benefit | 161 | DHW - IDHW - ATR-III Military Benefit | 83159.84999999995 |  |  | DHW - IDHW - ATR-III Military Benefit | 161 | DHW - IDHW - ATR-III Military Benefit | 83159.84999999995
ATR Total | 1147 | 467183.5999999988 |  | 421096.6779999988 | 46086.92200000001 | 2724921 | 0.1545353711171806 |  | 3332156.321565208 | 607235.321565208 |  |  |  | DHW - IDHW - ATR-III Military Benefit - Medicaid | 26 | 19297.02 |  |  | DHW - IDHW - ATR-III Military Benefit - Medicaid | 26 | 19297.02 |  | DHW - IDHW - ATR-III Military Benefit - Medicaid | 26 | DHW - IDHW - ATR-III Military Benefit - Medicaid | 19297.02 |  |  | DHW - IDHW - ATR-III Military Benefit - Medicaid | 26 | DHW - IDHW - ATR-III Military Benefit - Medicaid | 19297.02
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - ATR-III Misdemeanor | 786 | 313761.5899999989 |  |  | DHW - IDHW - ATR-III Misdemeanor | 786 | 313761.5899999989 |  | DHW - IDHW - ATR-III Misdemeanor | 786 | DHW - IDHW - ATR-III Misdemeanor | 313761.5899999989 |  |  | DHW - IDHW - ATR-III Misdemeanor | 786 | DHW - IDHW - ATR-III Misdemeanor | 313761.5899999989
[NAME] | 19 | 10883.58 | 1 | 10883.58 | 0 |  |  |  |  |  |  |  |  | DHW - IDHW - ATR-III Misdemeanor - Medicaid | 90 | 42382.58000000001 |  |  | DHW - IDHW - ATR-III Misdemeanor - Medicaid | 90 | 42382.58000000001 |  | DHW - IDHW - ATR-III Misdemeanor - Medicaid | 90 | DHW - IDHW - ATR-III Misdemeanor - Medicaid | 42382.58000000001 |  |  | DHW - IDHW - ATR-III Misdemeanor - Medicaid | 90 | DHW - IDHW - ATR-III Misdemeanor - Medicaid | 42382.58000000001
Adult-Medicaid | 1 | 2018.32 | 0.3 | 605.496 | 1412.824 |  |  |  |  |  |  |  |  | DHW - IDHW - Child Protection Drug Court | 39 | 33354.70999999999 |  |  | DHW - IDHW - Child Protection Drug Court | 39 | 33354.70999999999 |  | DHW - IDHW - Child Protection Drug Court | 39 | DHW - IDHW - Child Protection Drug Court | 33354.70999999999 |  |  | DHW - IDHW - Child Protection Drug Court | 39 | DHW - IDHW - Child Protection Drug Court | 33354.70999999999
Adult Total | 20 | 12901.9 |  | 11489.076 | 1412.824 | 100000 | 0.11489076 |  | 2477322.631419683 | 2377322.631419683 |  |  |  | DHW - IDHW - CP/SUD | 197 | 86910.9999999999 |  |  | DHW - IDHW - CP/SUD | 197 | 86910.9999999999 |  | DHW - IDHW - CP/SUD | 197 | DHW - IDHW - CP/SUD | 86910.9999999999 |  |  | DHW - IDHW - CP/SUD | 197 | DHW - IDHW - CP/SUD | 86910.9999999999
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - CP/SUD - Medicaid | 70 | 32120.86 |  |  | DHW - IDHW - CP/SUD - Medicaid | 70 | 32120.86 |  | DHW - IDHW - CP/SUD - Medicaid | 70 | DHW - IDHW - CP/SUD - Medicaid | 32120.86 |  |  | DHW - IDHW - CP/SUD - Medicaid | 70 | DHW - IDHW - CP/SUD - Medicaid | 32120.86
Adolescent |  |  | 1 | 0 | 0 |  |  |  |  |  |  |  |  | DHW - IDHW - DV Court Misdemeanant | 121 | 75441.35999999997 |  |  | DHW - IDHW - DV Court Misdemeanant | 121 | 75441.35999999997 |  | DHW - IDHW - DV Court Misdemeanant | 121 | DHW - IDHW - DV Court Misdemeanant | 75441.35999999997 |  |  | DHW - IDHW - DV Court Misdemeanant | 121 | DHW - IDHW - DV Court Misdemeanant | 75441.35999999997
Adolescent-Medicaid | 1 | 12461.01000000001 | 0.3 | 3738.303000000003 | 8722.707000000008 |  |  |  |  |  |  |  |  | DHW - IDHW - DV Court Misdemeanant - Medicaid | 21 | 12424.92 |  |  | DHW - IDHW - DV Court Misdemeanant - Medicaid | 21 | 12424.92 |  | DHW - IDHW - DV Court Misdemeanant - Medicaid | 21 | DHW - IDHW - DV Court Misdemeanant - Medicaid | 12424.92 |  |  | DHW - IDHW - DV Court Misdemeanant - Medicaid | 21 | DHW - IDHW - DV Court Misdemeanant - Medicaid | 12424.92
Adolescent Total | 1 | 12461.01000000001 |  | 3738.303000000003 | 8722.707000000008 | 100000 | 0.03738303000000003 |  | 1210.408307962904 | -399744.5916920371 |  |  |  | DHW - IDHW - IVDU | 361 | 108110.9799999999 |  |  | DHW - IDHW - IVDU | 361 | 108110.9799999999 |  | DHW - IDHW - IVDU | 361 | DHW - IDHW - IVDU | 108110.9799999999 |  |  | DHW - IDHW - IVDU | 361 | DHW - IDHW - IVDU | 108110.9799999999
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - IVDU - Medicaid | 46 | 40703.10000000002 |  |  | DHW - IDHW - IVDU - Medicaid | 46 | 40703.10000000002 |  | DHW - IDHW - IVDU - Medicaid | 46 | DHW - IDHW - IVDU - Medicaid | 40703.10000000002 |  |  | DHW - IDHW - IVDU - Medicaid | 46 | DHW - IDHW - IVDU - Medicaid | 40703.10000000002
CP-SUD | 197 | 86910.9999999999 | 1 | 86910.9999999999 |  |  |  |  |  |  |  |  |  | DHW - IDHW - Medicaid Only | 854 | 344394.619999999 |  |  | DHW - IDHW - Medicaid Only | 854 | 344394.619999999 |  | DHW - IDHW - Medicaid Only | 854 | DHW - IDHW - Medicaid Only | 344394.619999999 |  |  | DHW - IDHW - Medicaid Only | 854 | DHW - IDHW - Medicaid Only | 344394.619999999
CP-SUD - Medicaid | 70 | 32120.86 | 0.3 | 9636.257999999998 | 22484.602 |  |  |  |  |  |  |  |  | DHW - IDHW - PWWC | 118 | 119505.89 |  |  | DHW - IDHW - PWWC | 118 | 119505.89 |  | DHW - IDHW - PWWC | 118 | DHW - IDHW - PWWC | 119505.89 |  |  | DHW - IDHW - PWWC | 118 | DHW - IDHW - PWWC | 119505.89
CP-SUD Total | 267 | 119031.8599999999 |  | 96547.2579999999 | 22484.602 | 750000 | 0.1287296773333332 |  | 2775723.156441996 | 2025723.156441996 |  |  |  | DHW - IDHW - PWWC - Medicaid | 140 | 153398.41 |  |  | DHW - IDHW - PWWC - Medicaid | 140 | 153398.41 |  | DHW - IDHW - PWWC - Medicaid | 140 | DHW - IDHW - PWWC - Medicaid | 153398.41 |  |  | DHW - IDHW - PWWC - Medicaid | 140 | DHW - IDHW - PWWC - Medicaid | 153398.41
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - State Hospital | 65 | 49161.92 |  |  | DHW - IDHW - State Hospital | 65 | 49161.92 |  | DHW - IDHW - State Hospital | 65 | DHW - IDHW - State Hospital | 49161.92 |  |  | DHW - IDHW - State Hospital | 65 | DHW - IDHW - State Hospital | 49161.92
DV Court | 121 | 75441.35999999997 | 1 | 75441.35999999997 | 0 |  |  |  |  |  |  |  |  | DHW - IDHW - State Hospital - Medicaid | 23 | 10941.78 |  |  | DHW - IDHW - State Hospital - Medicaid | 23 | 10941.78 |  | DHW - IDHW - State Hospital - Medicaid | 23 | DHW - IDHW - State Hospital - Medicaid | 10941.78 |  |  | DHW - IDHW - State Hospital - Medicaid | 23 | DHW - IDHW - State Hospital - Medicaid | 10941.78
DV Court- Medicaid | 21 | 12424.92 | 0.3 | 3727.476000000001 | 8697.444000000001 |  |  |  |  |  |  |  |  | DHW - IDHW - Unknown / Ineligible | 723 | 9567.010000000046 |  |  | DHW - IDHW - Unknown / Ineligible | 723 | 9567.010000000046 |  | DHW - IDHW - Unknown / Ineligible | 723 | DHW - IDHW - Unknown / Ineligible | 9567.010000000046 |  |  | DHW - IDHW - Unknown / Ineligible | 723 | DHW - IDHW - Unknown / Ineligible | 9567.010000000046
DV Court Misdemeanant Total | 142 | 87866.27999999997 |  | 79168.83599999997 | 8697.444000000001 | 429000 | 0.1845427412587412 |  | 3979187.790075603 | 3550187.790075603 |  |  |  | DHW - PSC - Mental Health Court | 39 | 32156.91 |  |  | DHW - PSC - Mental Health Court | 39 | 32156.91 |  | DHW - PSC - Mental Health Court | 39 | DHW - PSC - Mental Health Court | 32156.91 |  |  | DHW - PSC - Mental Health Court | 39 | DHW - PSC - Mental Health Court | 32156.91
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DHW - PSC - Mental Health Court - Medicaid | 23 | 29365.92999999999 |  |  | DHW - PSC - Mental Health Court - Medicaid | 23 | 29365.92999999999 |  | DHW - PSC - Mental Health Court - Medicaid | 23 | DHW - PSC - Mental Health Court - Medicaid | 29365.92999999999 |  |  | DHW - PSC - Mental Health Court - Medicaid | 23 | DHW - PSC - Mental Health Court - Medicaid | 29365.92999999999
IVDU | 361 | 108110.9799999999 | 1 | 108110.9799999999 |  |  |  |  |  |  |  |  |  | Grand Total | 4008 | 1630105.909999997 |  |  | Grand Total | 4008 | 1630105.909999997 |  | Grand Total | 4008 | Grand Total | 1630105.909999997 |  |  | Grand Total | 4008 | Grand Total | 1630105.909999997
IVDU - Medicaid | 46 | 40703.10000000002 | 0.3 | 12210.93000000001 | 28492.17000000001
IVDU Total | 407 | 148814.0799999999 |  | 120321.9099999999 | 28492.17000000001 | 1000000 | 0.1203219099999999 |  | 2594431.359829477 | 1594431.359829477
PWWC | 118 | 119505.89 | 1 | 119505.89
PWWC - Medicaid | 140 | 153398.41 | 0.3 | 46019.52299999999 | 107378.887
PWWC Total | 258 | 272904.2999999999 |  | 165525.413 | 107378.887 | 450000 | 0.3678342511111111 |  | 7931396.005117089 | 7481396.005117089
State Hospital | 65 | 49161.92 | 1 | 49161.92
State Hospital - Medicaid | 23 | 10941.78 | 0.3 | 3282.534 | 7659.246000000001
State Hospital Total | 88 | 60103.7 |  | 52444.454 | 7659.246000000001 | 325000 | 0.1613675507692308 |  | 3479474.637450219 | 3154474.637450219
Mental Health Court | 39 | 32156.91 | 1 | 32156.91
Mental Health Court - Medicaid | 23 | 29365.92999999999 | 0.3 | 8809.778999999997 | 20556.151
Mental Health Court Total | 62 | 61522.83999999999 |  | 40966.68899999999 | 20556.151 | 300000 | 0.13655563 |  | 2944469.62181095 | 2644469.62181095
Misdemeanant PSC |  |  | 1 | 0
Misdemeanant PSC - Medicaid |  |  | 0.3 | 0 | 0
Misdemeanant PSC Total | 0 | 0 |  | 0 | 0 | 275000 | 0
Medicaid Only | 854 | 344394.619999999 | 0.3 | 103318.3859999997 | 241076.2339999993
Medicaid Only Total | 854 | 344394.619999999 |  | 103318.3859999997 | 241076.2339999993 | 916667 |  |  | 0 | -916667
Unknown / Ineligible / Reserve | 723 | 9567.010000000046 | 1 | 9567.010000000046 |  | 546455
Non-Medicaid Total |  |  |  | 1104184.012999998 |  | 7917043 | 0.1394692453988185 |  | 8737456.10286955 | 820413.1028695498
Medicaid Total |  |  |  |  | 492567.1869999993 |  |  |  | 0 | 0
Grand Total | 3969 | 1596751.199999997 |  |  | 1596751.199999997 | 7917043 | 0.2016853009387466 |  | 12635161.6695652 | 4718118.669565197
[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