Spreadsheet: 09fd9fcd-1ff9-46d2-989d-6c9121307d1b
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
 |  |  |  |  |  | Claims  Report* | % of Year Complete |  |  |  |  | 2013-07-01 00:00:00
[NAME] as of 4/25/2014 |  |  |  |  |  | 2014-04-25 00:00:00 | 0.8186813186813187
 |  |  |  |  |  |  |  |  |  |  |  | 298 |  | 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 |  | 21.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 | Sum of Sum of Paid Plus Incentive
DHW - IDHW - ATR-III - Administrative | 99 | 4101.939999999995 | 1 | 4101.939999999995 | 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 | 14578.98000000001 | 0 | 0
DHW - IDHW - ATR-III Adolescent Benefit | 111 | 93027.26999999999 | 1 | 93027.26999999999 | 0 |  |  |  |  |  |  |  |  | DHW - IDHW - Adult | 60 | 93247.32999999999 |  |  | DHW - IDHW - Adult | 60 | 93247.32999999999 |  | DHW - IDHW - Adult | 60 | DHW - IDHW - Adult | 93247.32999999999 |  |  |  | DHW - IDHW - Adult | 60 | 93247.32999999999 | 0 | 0
DHW - IDHW - ATR-III Adolescent Benefit - Medicaid | 28 | 6021.91 | 0.3 | 1806.573 | 4215.337 |  |  |  |  |  |  |  |  | DHW - IDHW - Adult - Medicaid | 1 | 2781.259999999998 |  |  | DHW - IDHW - Adult - Medicaid | 1 | 2781.259999999998 |  | DHW - IDHW - Adult - Medicaid | 1 | DHW - IDHW - Adult - Medicaid | 2781.259999999998 |  |  |  | DHW - IDHW - Adult - Medicaid | 1 | 2781.259999999998 | 0 | 0
DHW - IDHW - ATR-III Military Benefit | 338 | 332800.4499999998 | 1 | 332800.4499999998 | 0 |  |  |  |  |  |  |  |  | DHW - IDHW - ATR-III - Administrative | 99 | 4101.939999999995 |  |  | DHW - IDHW - ATR-III - Administrative | 99 | 4101.939999999995 |  | DHW - IDHW - ATR-III - Administrative | 99 | DHW - IDHW - ATR-III - Administrative | 4101.939999999995 |  |  |  | DHW - IDHW - ATR-III - Administrative | 99 | 4101.939999999995 | 0 | 0
DHW - IDHW - ATR-III Military Benefit - Medicaid | 27 | 27229.47000000001 | 0.3 | 8168.841000000002 | 19060.62900000001 |  |  |  |  |  |  |  |  | DHW - IDHW - ATR-III Adolescent Benefit | 111 | 93027.26999999999 |  |  | DHW - IDHW - ATR-III Adolescent Benefit | 111 | 93027.26999999999 |  | DHW - IDHW - ATR-III Adolescent Benefit | 111 | DHW - IDHW - ATR-III Adolescent Benefit | 93027.26999999999 |  |  |  | DHW - IDHW - ATR-III Adolescent Benefit | 111 | 93027.26999999999 | 0 | 0
DHW - IDHW - ATR-III Misdemeanor | 1719 | 1644507.510000002 | 1 | 1644507.510000002 | 0 |  |  |  |  |  |  |  |  | DHW - IDHW - ATR-III Adolescent Benefit - Medicaid | 28 | 6021.91 |  |  | DHW - IDHW - ATR-III Adolescent Benefit - Medicaid | 28 | 6021.91 |  | DHW - IDHW - ATR-III Adolescent Benefit - Medicaid | 28 | DHW - IDHW - ATR-III Adolescent Benefit - Medicaid | 6021.91 |  |  |  | DHW - IDHW - ATR-III Adolescent Benefit - Medicaid | 28 | 6021.91 | 0 | 0
DHW - IDHW - ATR-III Misdemeanor - Medicaid | 107 | 63029.94999999998 | 0.3 | 18908.98499999999 | 44120.96499999999 |  |  |  |  |  |  |  |  | DHW - IDHW - ATR-III Military Benefit | 338 | 332800.4499999998 |  |  | DHW - IDHW - ATR-III Military Benefit | 338 | 332800.4499999998 |  | DHW - IDHW - ATR-III Military Benefit | 338 | DHW - IDHW - ATR-III Military Benefit | 332800.4499999998 |  |  |  | DHW - IDHW - ATR-III Military Benefit | 338 | 332800.4499999998 | 0 | 0
ATR Total | 2429 | 2170718.500000002 |  | 2103321.569000002 | 67396.931 | 2724921 | 0.7718835037786423 |  | 2569157.889651009 | -155763.1103489907 |  |  |  | DHW - IDHW - ATR-III Military Benefit - Medicaid | 27 | 27229.47000000001 |  |  | DHW - IDHW - ATR-III Military Benefit - Medicaid | 27 | 27229.47000000001 |  | DHW - IDHW - ATR-III Military Benefit - Medicaid | 27 | DHW - IDHW - ATR-III Military Benefit - Medicaid | 27229.47000000001 |  |  |  | DHW - IDHW - ATR-III Military Benefit - Medicaid | 27 | 27229.47000000001 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - ATR-III Misdemeanor | 1719 | 1644507.510000002 |  |  | DHW - IDHW - ATR-III Misdemeanor | 1719 | 1644507.510000002 |  | DHW - IDHW - ATR-III Misdemeanor | 1719 | DHW - IDHW - ATR-III Misdemeanor | 1644507.510000002 |  |  |  | DHW - IDHW - ATR-III Misdemeanor | 1719 | 1644507.510000002 | 0 | 0
[NAME] | 60 | 93247.32999999999 | 1 | 93247.32999999999 | 0 |  |  |  |  |  |  |  |  | DHW - IDHW - ATR-III Misdemeanor - Medicaid | 107 | 63029.94999999998 |  |  | DHW - IDHW - ATR-III Misdemeanor - Medicaid | 107 | 63029.94999999998 |  | DHW - IDHW - ATR-III Misdemeanor - Medicaid | 107 | DHW - IDHW - ATR-III Misdemeanor - Medicaid | 63029.94999999998 |  |  |  | DHW - IDHW - ATR-III Misdemeanor - Medicaid | 107 | 63029.94999999998 | 0 | 0
Adult-Medicaid | 1 | 2781.259999999998 | 0.3 | 834.3779999999995 | 1946.881999999999 |  |  |  |  |  |  |  |  | DHW - IDHW - Child Protection Drug Court | 41 | 55641.69 |  |  | DHW - IDHW - Child Protection Drug Court | 41 | 55641.69 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Adult Total | 61 | 96028.58999999998 |  | 94081.70799999998 | 1946.881999999999 | 100000 | 0.9408170799999999 |  | 114918.5963489933 | 14918.59634899329 |  |  |  | DHW - IDHW - CP/SUD | 536 | 746306.6 |  |  | DHW - IDHW - CP/SUD | 536 | 746306.6 |  | DHW - IDHW - CP/SUD | 536 | DHW - IDHW - CP/SUD | 746306.6 |  |  |  | DHW - IDHW - CP/SUD | 536 | 746306.6 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - CP/SUD - Medicaid | 80 | 43829.51000000001 |  |  | DHW - IDHW - CP/SUD - Medicaid | 80 | 43829.51000000001 |  | DHW - IDHW - CP/SUD - Medicaid | 80 | DHW - IDHW - CP/SUD - Medicaid | 43829.51000000001 |  |  |  | DHW - IDHW - CP/SUD - Medicaid | 80 | 43829.51000000001 | 0 | 0
Adolescent |  |  | 1 | 0 | 0 |  |  |  |  |  |  |  |  | DHW - IDHW - DV Court Misdemeanant | 278 | 373810.6799999998 |  |  | DHW - IDHW - DV Court Misdemeanant | 278 | 373810.6799999998 |  | DHW - IDHW - DV Court Misdemeanant | 278 | DHW - IDHW - DV Court Misdemeanant | 373810.6799999998 |  |  |  | DHW - IDHW - DV Court Misdemeanant | 278 | 373810.6799999998 | 0 | 0
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 | 20925.06 | 0 | 0
Adolescent Total | 1 | 14578.98000000001 |  | 4373.694000000004 | 10205.28600000001 | 100000 | 0.04373694000000004 |  | 5342.364483221481 | -94657.63551677852 |  |  |  | DHW - IDHW - IVDU | 815 | 1083584.24 |  |  | DHW - IDHW - IVDU | 815 | 1083584.24 |  | DHW - IDHW - IVDU | 815 | DHW - IDHW - IVDU | 1083584.24 |  |  |  | DHW - IDHW - IVDU | 815 | 1083584.24 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - IVDU - Medicaid | 54 | 76883.58000000003 |  |  | DHW - IDHW - IVDU - Medicaid | 54 | 76883.58000000003 |  | DHW - IDHW - IVDU - Medicaid | 54 | DHW - IDHW - IVDU - Medicaid | 76883.58000000003 |  |  |  | DHW - IDHW - IVDU - Medicaid | 54 | 76883.58000000003 | 0 | 0
CP-SUD | 536 | 746306.6 | 1 | 746306.6 |  |  |  |  |  |  |  |  |  | DHW - IDHW - Medicaid Only | 925 | 480467.0099999987 |  |  | DHW - IDHW - Medicaid Only | 925 | 480467.0099999987 |  | DHW - IDHW - Medicaid Only | 925 | DHW - IDHW - Medicaid Only | 480467.0099999987 |  |  |  | DHW - IDHW - Medicaid Only | 925 | 480467.0099999987 | 0 | 0
CP-SUD - Medicaid | 80 | 43829.51000000001 | 0.3 | 13148.853 | 30680.65700000001 |  |  |  |  |  |  |  |  | DHW - IDHW - PWWC | 282 | 478028.8200000001 |  |  | DHW - IDHW - PWWC | 282 | 478028.8200000001 |  | DHW - IDHW - PWWC | 282 | DHW - IDHW - PWWC | 478028.8200000001 |  |  |  | DHW - IDHW - PWWC | 282 | 478028.8200000001 | 0 | 0
CP-SUD Total | 616 | 790136.11 |  | 759455.453 | 30680.65700000001 | 750000 | 1.012607270666667 |  | 927656.9962818793 | 177656.9962818793 |  |  |  | DHW - IDHW - PWWC - Medicaid | 156 | 216396.0699999999 |  |  | DHW - IDHW - PWWC - Medicaid | 156 | 216396.0699999999 |  | DHW - IDHW - PWWC - Medicaid | 156 | DHW - IDHW - PWWC - Medicaid | 216396.0699999999 |  |  |  | DHW - IDHW - PWWC - Medicaid | 156 | 216396.0699999999 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DHW - IDHW - State Hospital | 185 | 280206.3200000001 |  |  | DHW - IDHW - State Hospital | 185 | 280206.3200000001 |  | DHW - IDHW - State Hospital | 185 | DHW - IDHW - State Hospital | 280206.3200000001 |  |  |  | DHW - IDHW - State Hospital | 185 | 280206.3200000001 | 0 | 0
DV Court | 278 | 373810.6799999998 | 1 | 373810.6799999998 | 0 |  |  |  |  |  |  |  |  | DHW - IDHW - State Hospital - Medicaid | 26 | 18509.69 |  |  | DHW - IDHW - State Hospital - Medicaid | 26 | 18509.69 |  | DHW - IDHW - State Hospital - Medicaid | 26 | DHW - IDHW - State Hospital - Medicaid | 18509.69 |  |  |  | DHW - IDHW - State Hospital - Medicaid | 26 | 18509.69 | 0 | 0
DV Court- Medicaid | 22 | 20925.06 | 0.3 | 6277.518 | 14647.542 |  |  |  |  |  |  |  |  | DHW - IDHW - Unknown / Ineligible | 1357 | 22690.97 |  |  | DHW - IDHW - Unknown / Ineligible | 1357 | 22690.97 |  | DHW - IDHW - Unknown / Ineligible | 1357 | DHW - IDHW - Unknown / Ineligible | 22690.97 |  |  |  | DHW - IDHW - Unknown / Ineligible | 1357 | 22690.97 | 0 | 0
DV Court Misdemeanant Total | 300 | 394735.7399999998 |  | 380088.1979999998 | 14647.542 | 429000 | 0.8859864755244751 |  | 464268.8056107381 | 35268.80561073805 |  |  |  | DHW - PSC - Mental Health Court | 88 | 110560.23 |  |  | DHW - PSC - Mental Health Court | 88 | 110560.23 |  | DHW - PSC - Mental Health Court | 88 | DHW - PSC - Mental Health Court | 110560.23 |  |  |  | DHW - PSC - Mental Health Court | 88 | 110560.23 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DHW - PSC - Mental Health Court - Medicaid | 29 | 44719.4 |  |  | DHW - PSC - Mental Health Court - Medicaid | 29 | 44719.4 |  | DHW - PSC - Mental Health Court - Medicaid | 29 | DHW - PSC - Mental Health Court - Medicaid | 44719.4 |  |  |  | DHW - PSC - Mental Health Court - Medicaid | 29 | 44719.4 | 0 | 0
IVDU | 815 | 1083584.24 | 1 | 1083584.24 |  |  |  |  |  |  |  |  |  | DHW - PSC - Misdemeanor / DUI Court | 155 | 121348.8 |  |  | DHW - PSC - Misdemeanor / DUI Court | 155 | 121348.8 |  | DHW - PSC - Misdemeanor / DUI Court | 155 | DHW - PSC - Misdemeanor / DUI Court | 121348.8 |  |  |  | DHW - PSC - Misdemeanor / DUI Court | 155 | 121348.8 | 0 | 0
IVDU - Medicaid | 54 | 76883.58000000003 | 0.3 | 23065.07400000001 | 53818.50600000002 |  |  |  |  |  |  |  |  | DHW - PSC - Misdemeanor / DUI Court - Medicaid | 0 | 0 |  |  | DHW - PSC - Misdemeanor / DUI Court - Medicaid | 0 | 0 |  | DHW - PSC - Misdemeanor / DUI Court - Medicaid |  | DHW - PSC - Misdemeanor / DUI Court - Medicaid |  |  |  |  |  |  |  | 0 | 0
IVDU Total | 869 | 1160467.820000001 |  | 1106649.314 | 53818.50600000002 | 1000000 | 1.106649314 |  | 1351746.141932887 | 351746.1419328866 |  |  |  | Grand Total | 7479 | 6399593.050000002 |  |  | Grand Total | 7479 | 6399593.050000002 |  | Grand Total | 7479 | Grand Total | 6399593.050000002 |  |  |  | Grand Total | 7479 | 6399593.050000002 | 0 | 0
PWWC | 282 | 478028.8200000001 | 1 | 478028.8200000001
PWWC - Medicaid | 156 | 216396.0699999999 | 0.3 | 64918.82099999997 | 151477.2489999999 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7479 | 6399593.050000004
PWWC Total | 438 | 694424.89 |  | 542947.6410000001 | 151477.2489999999 | 450000 | 1.206550313333334 |  | 663197.7896778524 | 213197.7896778524
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Unknown | 23 | 4232.04 | 23 | 4232.04
State Hospital | 185 | 280206.3200000001 | 1 | 280206.3200000001
State Hospital - Medicaid | 26 | 18509.69 | 0.3 | 5552.907 | 12956.783
State Hospital Total | 211 | 298716.0100000001 |  | 285759.2270000001 | 12956.783 | 325000 | 0.8792591600000003 |  | 349048.1833154364 | 24048.18331543636
Mental Health Court | 88 | 110560.23 | 1 | 110560.23
Mental Health Court - Medicaid | 29 | 44719.4 | 0.3 | 13415.82 | 31303.58
Mental Health Court Total | 117 | 155279.63 |  | 123976.05 | 31303.58 | 300000 | 0.4132535000000001 |  | 151433.8328859061 | -148566.1671140939
Misdemeanant PSC | 155 | 121348.8 | 1 | 121348.8
Misdemeanant PSC - Medicaid | 0 | 0 | 0.3 | 0 | 0
Misdemeanant PSC Total | 155 | 121348.8 |  | 121348.8 | 0 | 275000 | 0.4412683636363638 |  | 148224.7087248323 | -126775.2912751677
Medicaid Only | 925 | 480467.0099999987 | 0.3 | 144140.1029999996 | 336326.9069999991
Medicaid Only Total | 925 | 480467.0099999987 |  | 144140.1029999996 | 336326.9069999991 | 916667 | 0.6813893300402417 |  | 762942.9165503335 | -153724.0834496665
Unknown / Ineligible / Reserve | 1357 | 22690.97 | 1 | 22690.97 |  | 546455
Direct Client Treatment Delivery Services | 0 | 359282 |  | 359282 | 0 | 546455 | 0.6574777429065523 |  | 438854.5234899329 | -107600.4765100671
Non-Medicaid Total |  |  |  | 6048114.727000001 |  | 7917043 | 0.7639360714600136 |  | 7387630.069221477 | -529412.930778523
Medicaid Total |  |  |  |  | 710760.322999999 |  |  |  | 0 | 0
Grand Total | 7479 | 6758875.05 |  |  | 6758875.05 | 7917043 | 0.8537120551195693 |  | 8255807.108053692 | 338764.1080536917
V:\BPA Invoices New\2014\20140425\Claims Reports\DHW SR056_SFY14_6-7-13 - 4-28-14_Claims Report_20140314.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