{"text_format":"1","workbook":"xlsx","n_sheets":19,"sheets":["Macros","Medicaid Worksheet","Medicaid CRCS","FSR - Medicaid","FSR - Healthy Michigan","FSR - Health Homes BH","FSR - Opioid Health Home BH","FSR - MI Health Link","FSR - SUD","SUD - Supplemental","Res Fund Bal","Medicaid ISF Report","Medicaid Shared Risk Calc","FSR - All Non Medicaid","GF CRCS","GF Worksheet","GF Special Fund Account - 226a","Certification page","Additional Narrative"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":31,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Macros","index":0,"n_rows":100,"n_cols":54,"rows_kept":100,"cut":false,"hidden":false,"merged":[[0,0,0,2],[4,0,4,2],[2,0,2,2]]}
["To use this form, you must first enable macros. Please click \"Enable Content\" button above. Or click the link below for Microsoft enable macro instructions"]
[]
["How to enable macros"]
[]
["If questions or issues with form, please use contact information below"]
[]
["John Duvendeck","duvendeckj@michigan.gov"," or 517-241-5218"]
["Kidada Smith","smithk67@michigan.gov"," or 517-284-9369"]
["Enika Whitmon","whitmone@michigan.gov"," or 517-284-9391"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"Medicaid Worksheet","index":1,"n_rows":72,"n_cols":9,"rows_kept":72,"cut":false,"hidden":true,"merged":[[72,1,78,8],[71,1,71,8],[56,1,57,4],[58,2,58,4],[59,2,59,4],[63,1,63,2],[67,1,67,2],[68,1,68,2],[64,1,64,2],[65,1,65,2],[66,1,66,2],[15,1,15,2],[33,8,34,8],[32,5,32,7],[33,5,34,7],[60,2,60,4],[45,1,45,2],[19,1,19,2],[40,1,40,2],[23,1,29,7],[39,1,39,2],[42,4,42,6],[43,4,43,6],[54,2,54,4],[47,1,47,2],[46,1,46,2],[0,0,0,8],[1,0,1,8],[2,0,2,8],[4,3,4,7],[35,2,36,3],[22,1,22,2],[32,1,32,2],[33,1,33,2],[12,1,12,2],[13,1,13,2],[11,1,11,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[14,1,14,2],[21,1,21,2]]}
["MDHHS/PIHP MEDICAID MANAGED SPECIALTY SUPPORTS AND SERVICES"]
["CONCURRENT WAIVER PROGRAMS"]
["MEDICAID CONTRACT SETTLEMENT WORKSHEET"]
[]
[null,null,"PIHP:     "]
[null,null,"FISCAL YEAR:     ","SELECT"]
[null,null,"SUBMISSION TYPE:     ","SELECT"]
[null,null,"SUBMISSION DATE:     "]
[]
[]
[]
["1.","Specialty Managed Care - Medicaid",null,"Medicaid (Incl Autism & HRA)","HMP (Incl Autism & HRA)","HSW","DHIP","Total","FY Indicator"]
["a.","Current Fiscal Year - Medicaid Revenue rec'd thru 9/30",null,null,null,null,null,{"$f":"SUM(D13:G13)","v":0},{"$f":"IF($D$6=\"FY 18 / 19\", \"FY 19\",IF($D$6=\"FY 19 / 20\",\"FY 20\"))","v":false}]
["b.","Current Fiscal Year - Medicaid Revenue Accruals",null,null,null,null,null,0,{"$f":"IF($D$6=\"FY 18 / 19\", \"FY 19\",IF($D$6=\"FY 19 / 20\",\"FY 20\"))","v":false}]
["c.","Sub-Total Current Fiscal Year Medicaid Revenue:",null,{"$f":"+$D$13+$D$14","v":0},{"$f":"+E13+E14","v":0},{"$f":"+F14+F13","v":0},{"$f":"+G14+G13","v":0},0,{"$f":"IF($D$6=\"FY 18 / 19\", \"FY 19\",IF($D$6=\"FY 19 / 20\",\"FY 20\"))","v":false}]
["d.","Prior Fiscal Year 1 - Accrual Adjustment - Net",null,null,null,null,null,0,{"$f":"IF($D$6=\"FY 18 / 19\", \"FY 18\",IF($D$6=\"FY 19 / 20\",\"FY 19\"))","v":false}]
["e.","Prior Fiscal Year 2 - Accrual Adjustment - Net",null,null,null,null,null,0,{"$f":"IF($D$6=\"FY 18 / 19\", \"FY 17\",IF($D$6=\"FY 19 / 20\",\"FY 18\"))","v":false}]
["f.","Other Adjustments (DHHS Approval Required)",null,null,null,null,null,0,"Describe Below"]
["g.","Sub-Total - Prior Year Accrual Adjustments:",null,{"$f":"SUM(D16:D18)","v":0},{"$f":"SUM(E16:E18)","v":0},{"$f":"SUM(F16:F18)","v":0},{"$f":"SUM(G16:G18)","v":0},{"$f":"SUM(H16:H18)","v":0}]
["h.","Total Medicaid Revenue - Current Year Settlement:",null,{"$f":"+$D$15+$D$19","v":0},{"$f":"+$E$15+$E$19","v":0},{"$f":"+$F$15+$F$19","v":0},{"$f":"+$G$15+$G$19","v":0},{"$f":"+$H$15+$H$19","v":0}]
[]
["i.","Total Current Fiscal Year Performance Bonus Incentive Pool (PBIP) Withheld (enter as a positive amount)",null,null,null,null,null,{"$f":"SUM(D22:G22)","v":0}]
["j.","Explanation of Accrual Adjustments"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["2.","Forced Lapse to MDHHS",null,"Amount"]
["a.","Medicaid Specialty Managed Care Forced Lapse (enter as negative)"]
[null,"1.","Explanation of Forced Lapse:"]
[]
[]
[]
[]
["3.","Medicaid Savings / Medicaid Lapse Calculation",null,"Amount"]
["a.","Specialty Managed Care - Medicaid Capitation (incl Autism)",null,{"$f":"'Medicaid Shared Risk Calc'!E13+'Medicaid Shared Risk Calc'!F13+'Medicaid Shared Risk Calc'!G13","v":0}]
[]
[null,"1.","Band # 1  (95 - 100%)                                                                   5%",{"$f":"ROUND($D$41*5%,0)","v":0},"PIHP retains"]
[null,"2.","Band # 2  (90 - 95%)                                                                     5%",{"$f":"ROUND($D$41*5%,0)","v":0},"Shared PIHP / MDHHS"]
[]
["b.  ","Balance Available for Savings (from Medicaid FSR)",null,{"$f":"IF('FSR - Medicaid'!M46<=0,0,'FSR - Medicaid'!M46)","v":0}]
["b1.","Balance Available for Savings (from Healthy Michigan FSR) ",null,{"$f":"IF('FSR - Healthy Michigan'!M43<=0,0,'FSR - Healthy Michigan'!M43)","v":0},null,"Total","Total Earned","Total Savings"]
["b2."," Total Available for Savings",null,{"$f":"D46+D47","v":0},null,"Lapse","Savings","Corridor"]
[]
["c.","1.","Band # 1 ",{"$f":"IF($D$48<=$D$43,$D$48,$D$43)","v":0},null,null,{"$f":"+$D$50","v":0},{"$f":"SUM($F$50:$G$50)","v":0}]
[null,"2.","Sub-Total - Band # 1        ",{"$f":"+$D$48-$D$50","v":0}]
[null,"3.","Band # 2 ",{"$f":"IF($D$51<$D$44,$D$51,$D$44)","v":0},null,{"$f":"+$D$52-$G$52","v":0},{"$f":"ROUND($D$52*50%,0)","v":0},{"$f":"SUM($F$52:$G$52)","v":0}]
[null,"4.","Sub-Total - Band # 2        ",{"$f":"+$D$51-$D$52","v":0}]
[null,"5.","Band # 3 ",{"$f":"+$D$53","v":0},null,{"$f":"+$D$54","v":0},null,{"$f":"SUM($F$54:$G$54)","v":0}]
[null,"6.","Totals        ",null,null,{"$f":"SUM($F$50:$F$54)","v":0},{"$f":"SUM($G$50:$G$54)","v":0},{"$f":"SUM($H$50:$H$54)","v":0}]
[]
[null,"Summary of Total Savings / Lapse",null,null,null,"Total","Total Earned","Total Savings","% of Savings"]
["4.",null,null,null,null,"Lapse","Savings","Corridor","by Funding"]
[null,"1."," Total Disposition of Medicaid Savings / Lapse",null,null,null,null,{"$f":"SUM($F$59:$G$59)","v":0},{"$f":"G59/G61","v":{"$error":"#DIV/0!"}}]
[null,"2.","Total Disposition of Healthy Michigan Savings / Lapse",null,null,null,null,{"$f":"SUM($F$60:$G$60)","v":0},{"$f":"G60/G61","v":{"$error":"#DIV/0!"}}]
[null,"3."," Total Savings / Lapse",null,null,{"$f":"SUM($F$59:$F$60)","v":0},{"$f":"SUM($G$59:$G$60)","v":0},{"$f":"SUM($H$59:$H$60)","v":0},{"$f":"SUM(I59:I60)","v":{"$error":"#DIV/0!"}}]
[]
[]
["5.","Medicaid Savings - Prior Year Earnings to Expend",null,"FY","FY","FY","FY","Total"]
["a.","Prior Year Medicaid Savings Earned - Medicaid",null,null,null,null,null,{"$f":"SUM($D$65:$G$65)","v":0}]
["b.","Current Year Expenditures - Medicaid",null,null,null,null,null,{"$f":"SUM($D$66:$G$66)","v":0}]
["c.","Prior Year Medicaid Savings Earned - HMP",null,null,null,null,null,{"$f":"SUM($D$67:$G$67)","v":0}]
["d.","Current Year Expenditures - HMP",null,null,null,null,null,{"$f":"SUM($D$68:$G$68)","v":0}]
["e.","Balance of Medicaid Savings:  ",null,{"$f":"+$D$65+$D$67-$D$66-$D$68","v":0},{"$f":"+$E$65+$E$67-$E$66-$E$68","v":0},{"$f":"+$F$65+$F$67-$F$66-$F$68","v":0},{"$f":"+$G$65+$G$67-$G$66-$G$68","v":0},{"$f":"+$H$65+$H$67-$H$66-$H$68","v":0}]
[]
[]
["6.","Narrative:  Both CRCS and Contract Settlement Worksheet  "]

{"sheet":"Medicaid CRCS","index":2,"n_rows":89,"n_cols":9,"rows_kept":89,"cut":false,"hidden":true,"merged":[[38,7,38,8],[13,1,13,2],[0,0,0,8],[1,0,1,8],[2,0,2,8],[4,3,4,7],[11,3,13,3],[14,1,14,2],[16,1,16,2],[21,1,21,2],[18,1,18,2],[31,1,31,2],[37,1,37,2],[27,1,27,2],[19,1,19,2],[23,1,23,2],[35,1,35,2],[40,1,40,2],[41,1,41,2],[43,1,43,2],[44,1,44,2],[28,1,28,2],[29,1,29,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[25,1,25,2],[22,1,22,2],[20,1,20,2],[36,1,36,2],[74,1,74,2],[30,1,30,2],[63,1,63,2],[64,1,64,2],[39,1,39,2],[38,1,38,2],[62,1,62,2],[46,1,46,2],[48,1,48,2],[53,1,53,2],[54,1,54,2],[45,1,45,2],[49,1,49,2],[88,2,91,2],[78,1,78,2],[80,1,80,6],[82,2,85,2],[73,6,73,7],[73,1,73,2],[74,6,74,7],[75,1,75,2],[76,1,76,2],[77,1,77,2],[75,6,75,7],[77,6,77,7],[76,6,76,7],[65,1,65,2],[66,1,66,2],[67,1,67,2],[72,1,72,2],[72,6,72,7],[71,1,71,2],[71,6,71,7],[68,1,68,2],[69,1,69,2]]}
["MDHHS/PIHP MEDICAID MANAGED SPECIALTY SUPPORTS AND SERVICES"]
["CONCURRENT WAIVER PROGRAMS"]
["MEDICAID/HMP CONTRACT RECONCILIATION AND CASH SETTLEMENT"]
[]
[null,null,"PIHP:     ",{"$f":"+'Medicaid Worksheet'!D5","v":0}]
[null,null,"FISCAL YEAR:     ",{"$f":"+'Medicaid Worksheet'!D6","v":"SELECT"}]
[null,null,"PERIOD COVERED:     ",{"$f":"+'Medicaid Worksheet'!D7","v":"SELECT"}]
[null,null,"SUBMISSION DATE:     ",{"$f":"+'Medicaid Worksheet'!D8","v":"00:00:00"}]
[]
[]
[]
[null,null,null,"PIHP Contract Cost Settled"]
[]
["1.","Medicaid Services - Available Resources"]
["a.","Total Managed Care Capitation  (Medicaid & Healthy Michigan Plan)",null,{"$f":"+'Medicaid Worksheet'!H20","v":0}]
[]
["b.","1st & 3rd Party Collections - Medicaid     (FSR A 121)",null,{"$f":"+'FSR - Medicaid'!M15","v":0}]
["c.","1st & 3rd Party Collections - HMP     (FSR AI 121)",null,{"$f":"+'FSR - Healthy Michigan'!M15","v":0}]
["d.","Prior Year Medicaid Savings   (FSR A 123 + FSR AI 123)",null,{"$f":"+'FSR - Medicaid'!M17+'FSR - Healthy Michigan'!M17","v":0}]
["e.","ISF Abatement - Medicaid / HMP(FSR A 124 + FSR AI 124)",null,{"$f":"+'FSR - Medicaid'!M18+'FSR - Healthy Michigan'!M18","v":0}]
["f.","Redirected FROM CMHSP to CMHSP Contracts     (FSR A 302 + FSR AI 302)",null,{"$f":"+'FSR - Medicaid'!M34+'FSR - Healthy Michigan'!M31","v":0}]
["g.","Redirected FROM Non-MDHHS Earned Contracts     (FSR A 303 + FSR AI 303)",null,{"$f":"+'FSR - Medicaid'!M35+'FSR - Healthy Michigan'!M32","v":0}]
["h.","Redirected FROM Restricted Fund Balance (FSR A 315 + AI 315 + AK 315) ",null,{"$f":"+'FSR - Medicaid'!M37+'FSR - Healthy Michigan'!M34+'FSR - MI Health Link'!E29","v":0}]
["i.","Sub-Total Other Medicaid Services - Resources  ",null,{"$f":"SUM($D$17:$D$23)","v":0}]
[]
["j.","Total Medicaid Services - Available Resources  ",null,{"$f":"+$D$24+$D$15","v":0}]
[]
["2.","Medicaid Services - Expenditures"]
["a.","PIHP Insurance Provider Assessment (IPA) Tax     (FSR A 201 + FSR AI 201)",null,{"$f":"+'FSR - Medicaid'!M22+'FSR - Healthy Michigan'!M22","v":0}]
["b.","Medicaid Services    (FSR A 202 - A 122 - A 325)",null,{"$f":"+'FSR - Medicaid'!M23-'FSR - Medicaid'!M16-'FSR - Medicaid'!M38","v":0}]
["b.1","Healthy Michigan Plan Services (FSR AI 202 - AI 122 - AI 325)",null,{"$f":"+'FSR - Healthy Michigan'!M23-'FSR - Healthy Michigan'!M16-'FSR - Healthy Michigan'!M35","v":0}]
["b.2","MI Health Link Medicaid Services     (FSR A 205)",null,{"$f":"+'FSR - Medicaid'!M26","v":0}]
["c.","Deposits - ISF Medicaid / HMP (FSR A 203 + FSR AI 203)",null,{"$f":"+'FSR - Medicaid'!M24+'FSR - Healthy Michigan'!M24","v":0}]
["d.","Psych Hospital HRA     (FSR A 204 + FSR AI 204)",null,{"$f":"+'FSR - Medicaid'!M25+'FSR - Healthy Michigan'!M25","v":0}]
["e.","Sub-Total Medicaid Services - Expenditures  ",null,{"$f":"SUM($D$29:$D$34)","v":0}]
[]
["f.","Redirected TO CMHSP to CMHSP Contracts     (FSR A 301 + FSR AI 301)",null,{"$f":"-'FSR - Medicaid'!M30+-'FSR - Healthy Michigan'!M29","v":0}]
["g.","Intentionally left blank",null,{"$f":"-'FSR - Medicaid'!M31","v":0}]
["h.","Redirected TO MI Health Link     (FSR A 301c)",null,{"$f":"-'FSR - Medicaid'!E33","v":0}]
["i.","Sub-Total Medicaid Services - Redirected Expenditures  ",null,{"$f":"SUM($D$37:$D$39)","v":0}]
[]
["j.","Total Medicaid Services - Expenditures  ",null,{"$f":"+$D$35+$D$40","v":0}]
[]
["3.","Net Medicaid Services Surplus / (Deficit)"]
["a.","Medicaid Funding Surplus / (Deficit)",null,{"$f":"+$D$26-$D$42","v":0}]
["b.","Less:  Forced Lapse to MDHHS (Medicaid worksheet 2.a)",null,{"$f":"+'Medicaid Worksheet'!D34","v":0}]
["c.","Net Medicaid Services Surplus / (Deficit)  ",null,{"$f":"SUM($D$45:$D$46)","v":0}]
[]
["4.","Disposition",null,"Amount"]
["a.","Surplus"]
[null,"1.","Transfer to Fund Balance - Medicaid Savings Earned",{"$f":"-'Medicaid Worksheet'!G55","v":0}]
[null,"2.","Lapse to MDHHS - Contract Settlement",{"$f":"-'Medicaid Worksheet'!F55","v":0}]
[null,"3.","Total Disposition - Surplus  ",{"$f":"+$D$51+$D$52","v":0}]
[]
["b.","Deficit"]
[null,"1.","Redirected from General Fund (FSR A 331 + AI 331 + AK 331)",{"$f":"+'FSR - Medicaid'!M40+'FSR - Healthy Michigan'!M37+'FSR - MI Health Link'!E32","v":0}]
[null,"2.","Redirected from Local     (FSR A 332 + AI 332 +  AK 332)",{"$f":"+'FSR - Medicaid'!M41+'FSR - Healthy Michigan'!M38+'FSR - MI Health Link'!E33","v":0}]
[null,"3.","Redirected Risk Corridor - PIHP Share (FSR A 333 + AI 333)",{"$f":"+'FSR - Medicaid'!M42+'FSR - Healthy Michigan'!M39","v":0}]
[null,"4.","Redirected Risk Corridor - MDHHS Share (FSR A 334 + AI 334)",{"$f":"+'FSR - Medicaid'!M43+'FSR - Healthy Michigan'!M40","v":0}]
[null,"5.","Redirected from Restricted Fund Balance (FSR A 335 + AI 335 + AK 335) ",{"$f":"+'FSR - Medicaid'!M44+'FSR - Healthy Michigan'!M41+'FSR - MI Health Link'!M36","v":0}]
[null,"6.","Total Disposition - Deficit  ",{"$f":"SUM($D$56:$D$60)","v":0}]
[]
["4.1","Medicaid Savings Transferred To/From",null,"Amount"]
[null,"PIHP receiving transferred Medicaid savings",null,"Total Transferred"]
["a."]
["b."]
["c."]
["d."]
["e."]
["f.","Total",null,{"$f":"SUM(D65:D69)","v":0}]
[]
["5.","Cash Settlement:  (Due MDHHS) / Due PIHP",null,"Amount",null,"6.","Medicaid MDHHS Commitment",null,"Amount"]
["a.","Forced Lapse to MDHHS",null,{"$f":"+$D$46","v":0},null,"a.","MDHHS / PIHP Medicaid Funded Expenditures",null,{"$f":"+$D$15+$D$51+$D$46+$D$52","v":0}]
["b.","Lapse to MDHHS - Contract Settlement",null,{"$f":"+$D$52","v":0},null,"b.","Earned Medicaid Savings ",null,{"$f":"-$D$51","v":0}]
["c.","Risk Corridor - MDHHS Share",null,{"$f":"+D$59","v":0},null,"c.","               Sub-Total MDHHS Commitment  ",null,{"$f":"SUM($I$73:$I$74)","v":0}]
["d.","Return of Prior Year Medicaid Savings",null,null,null,"d.","Risk Corridor - MDHHS Share ",null,{"$f":"+$D$59","v":0}]
["e.","Misc (please explain)",null,null,null,"e.","                Total MDHHS Medicaid Commitment  ",null,{"$f":"+$I$75+$I$76","v":0}]
["f.","Misc (please explain)",null,null,null,"f. ","General Fund Supplement for Unfunded Medicaid",null,{"$f":"+$D$56","v":0}]
["g.","Total Cash Settlement:  (Due MDHHS) / Due PIHP  ",null,{"$f":"SUM($D$73:$D$78)","v":0}]
[]
["7.","Report Certification"]
["This is to certify accuracy and completeness of this report."]
[null,null,"This certification has been moved to the CERTIFICATION OF MDHHS CONTRACT ATTACHMENTS 7.7.1.1 REPORT SUBMISSIONS form."]
[]
[]
[]
[]
["Questions should be directed to:"]
[null,null,"This contact information has been moved to the CERTIFICATION OF MDHHS CONTRACT ATTACHMENTS 7.7.1.1 REPORT SUBMISSIONS form."]

{"sheet":"FSR - Medicaid","index":3,"n_rows":109,"n_cols":13,"rows_kept":109,"cut":false,"hidden":true,"merged":[[5,4,6,4],[5,12,6,12],[98,2,98,3],[8,2,8,3],[4,0,4,2],[5,0,5,2],[5,5,5,11],[6,0,6,2],[7,2,7,3],[63,0,63,12],[41,2,41,3],[42,2,42,3],[44,2,44,3],[17,2,17,3],[37,2,37,3],[38,2,38,3],[39,2,39,3],[40,2,40,3],[70,2,70,3],[67,0,67,2],[68,0,68,2],[71,2,71,3],[66,2,66,3],[82,2,82,3],[0,0,0,12],[1,0,1,12],[3,0,3,1],[3,2,3,3],[3,4,3,12],[9,2,9,3],[45,2,45,3],[50,2,59,12],[49,2,49,12],[48,2,48,12],[10,2,10,3],[11,2,11,3],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[32,2,32,3],[43,2,43,3],[33,2,33,3],[34,2,34,3],[30,2,30,3],[18,2,18,3],[19,2,19,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[26,2,26,3],[27,2,27,3],[28,2,28,3],[29,2,29,3],[25,2,25,3],[97,2,97,3],[83,2,83,3],[84,2,84,3],[85,2,85,3],[86,2,86,3],[99,2,99,3],[95,2,95,3],[72,2,72,3],[74,2,74,3],[87,2,87,3],[96,2,96,3],[91,2,91,3],[92,2,92,3],[93,2,93,3],[94,2,94,3],[90,2,90,3],[89,2,89,3],[88,2,88,3],[73,2,73,3],[108,2,108,3],[100,2,100,3],[101,2,101,3],[102,2,102,3],[103,2,103,3],[104,2,104,3],[105,2,105,3],[106,2,106,3],[107,2,107,3],[31,2,31,3],[35,2,35,3],[79,2,79,3],[80,2,80,3],[81,2,81,3],[78,2,78,3],[75,2,75,3],[76,2,76,3],[77,2,77,3],[36,2,36,3],[64,0,64,12],[66,0,66,1],[66,4,66,12],[68,4,68,11],[69,0,69,2]]}
["MDHHS/PIHP MEDICAID MANAGED SPECIALTY SUPPORTS AND SERVICES CONCURRENT WAIVER PROGRAMS CONTRACT"]
["FINANCIAL STATUS REPORT - MEDICAID page 1"]
[]
["PIHP:",null,{"$f":"'Medicaid Worksheet'!D5","v":0},null,"YEAR TO DATE REPORTING"]
["FISCAL YEAR: ",null,null,{"$f":"'Medicaid Worksheet'!D6","v":"SELECT"},"A","B","C","D","E","F","G","H","I"]
["SUBMISSION TYPE: ",null,null,{"$f":"'Medicaid Worksheet'!D7","v":"SELECT"},"Regional Authority / Reporting Board","CMHSP",null,null,null,null,null,null,"PIHP Grand Total page     1 & 2"]
["SUBMISSION DATE: ",null,null,{"$f":"'Medicaid Worksheet'!D8","v":"00:00:00"},null,"# 1","# 2","# 3","# 4","# 5","# 6","# 7"]
[1,null,"PIHP or CMHSP"]
[]
["A",null,"MEDICAID SERVICES - PIHP USE ONLY"]
["A",100,"REVENUE"]
["A",101,"Specialty Managed Care Medicaid Revenue",null,{"$f":"'Medicaid Worksheet'!D20+'Medicaid Worksheet'!F20+'Medicaid Worksheet'!G20","v":0},null,null,null,null,null,null,null,{"$f":"SUM(E12:L12,E75:M75)","v":0}]
["A",115,"Medicaid Managed Care - Affiliate Contracts",null,{"$f":"-SUM(F13:L13,E76:M76)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(E13:L13,E76:M76)","v":0}]
["A",120,"Subtotal - Current Period Medicaid Services Revenue  ",null,{"$f":"SUM(E11:E13)","v":0},0,0,0,0,0,0,0,0]
["A",121,"1st & 3rd Party Collections - Medicare/Medicaid Consumers - Rpting Bd",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E15:L15,E78:M78)","v":0}]
["A",122,"1st & 3rd Party Collections - Medicare/Medicaid Consumers - Affiliate",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E16:L16,E79:M79)","v":0}]
["A",123,"Prior Year Medicaid Savings (Funding Current Year Expenses)",null,{"$f":"+'Medicaid Worksheet'!H66","v":0},null,null,null,null,null,null,null,{"$f":"SUM(E17:L17,E80:M80)","v":0}]
["A",124,"ISF Abatement ",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E18:L18,E81:M81)","v":0}]
["A",140,"Subtotal - Other Medicaid Revenue",null,{"$f":"SUM(E15:E18)","v":0},0,0,0,0,0,0,0,0]
["A",190,"TOTAL REVENUE",null,{"$f":"+E14+E19","v":0},0,0,0,0,0,0,0,0]
["A",200,"EXPENDITURE"]
["A",201,"PIHP Insurance Provider Assessment (IPA) Tax",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E22:L22,E85:M85)","v":0}]
["A",202,"Medicaid Services (incl Autism)",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E23:L23,E86:M86)","v":0}]
["A",203,"Payment into Medicaid ISF",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E24:L24,E87:M87)","v":0}]
["A",204,"Psych Hospital Rate Adjuster (HRA) ",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E25:L25,E88:M88)","v":0}]
["A",205,"MI Health Link - Medicaid Services",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E26:L26,E89:M89)","v":0}]
["A",290,"TOTAL EXPENDITURE",null,{"$f":"SUM(E21:E26)","v":0},{"$f":"SUM(F21:F26)","v":0},{"$f":"SUM(G21:G26)","v":0},0,0,0,0,0,{"$f":"SUM(M21:M26)","v":0}]
["A",295,"SUBTOTAL NET MEDICAID SERVICES SURPLUS (DEFICIT)",null,{"$f":"+E20-E27","v":0},0,0,0,0,0,0,0,0]
["A",300,"Redirected Funds (To) From"]
["A",301,"(TO) CMHSP to CMHSP Earned Contracts - J304",null,{"$f":"-'FSR - All Non Medicaid'!E301","v":0},null,null,null,null,null,null,null,{"$f":"SUM(E30:L30,E93:M93)","v":0}]
["A","301a","Intentionally left blank",null,null,null,null,null,null,null,null,null,0]
["A","301b","(TO) Healthy MI Plan - AI310",null,{"$f":"-'FSR - Healthy Michigan'!E33","v":0},null,null,null,null,null,null,null,0]
["A","301c","(TO) MI Health Link Services (Medicare) - AK310",null,{"$f":"-'FSR - MI Health Link'!E28","v":0},null,null,null,null,null,null,null,0]
["A",302,"FROM CMHSP to CMHSP Earned Contracts - J301 (explain - section AB)",null,null,null,null,null,null,null,null,null,0]
["A",303,"FROM Non-MDHHS Earned Contracts - K301   (explain - section AB)",null,null,null,null,null,null,null,null,null,0]
["A","310a","FROM Healthy MI Plan - AI301a",null,null,null,null,null,null,null,null,null,0]
["A",315,"FROM Restricted Fund Balance - RES 1.c",null,{"$f":"-SUM('Res Fund Bal'!E14+'Res Fund Bal'!G14)","v":0},null,null,null,null,null,null,null,0]
["A",325,"Info only - Affiliate Total Redirected Funds - I390",null,null,null,null,null,null,null,null,null,0]
["A",330,"Subtotal Redirected Funds rows 301 - 325",null,{"$f":"SUBTOTAL(9,E29:E38)","v":0},0,0,0,0,0,0,0,0]
["A",331,"FROM General Fund - Redirected to Unfunded Medicaid Costs - B301",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E40:L40,E103:M103)","v":0}]
["A",332,"FROM Local Funds - M301",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E41:L41,E104:M104)","v":0}]
["A",333,"FROM Risk Corridor - PIHP Share - N301",null,{"$f":"-'Medicaid ISF Report'!H16","v":0},null,null,null,null,null,null,null,{"$f":"SUM(E42:L42,E105:M105)","v":0}]
["A",334,"FROM Risk Corridor - MDHHS Share - N302",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E43:L43,E106:M106)","v":0}]
["A",335,"FROM Restricted Fund Balance - Risk Financing RES 1.c",null,{"$f":"-SUM('Res Fund Bal'!F14+'Res Fund Bal'!H14)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(E44:L44,E107:M107)","v":0}]
["A",390,"Total Redirected Funds",null,{"$f":"(SUBTOTAL(9,E29:E44))","v":0},0,0,0,0,0,0,0,0]
["A",400,"BALANCE MEDICAID SERVICES",null,{"$f":"+E28+E45","v":0},0,0,0,0,0,0,0,0]
[]
[]
["AB",null,"REMARKS"]
["AB",null,"Remarks may be added about any entry or activity on the report for which additional information may be useful."]
["AB"]
["AB"]
["AB"]
["AB"]
["AB"]
["AB"]
["AB"]
["AB"]
["AB"]
["AB"]
[]
[]
[]
["MDHHS/PIHP MEDICAID MANAGED SPECIALTY SUPPORTS AND SERVICES CONCURRENT WAIVER PROGRAMS CONTRACT"]
["FINANCIAL STATUS REPORT - MEDICAID page 2"]
[]
["PIHP:",null,{"$f":"+C4","v":0},null,"YEAR TO DATE REPORTING"]
["FISCAL YEAR: ",null,null,{"$f":"D5","v":"SELECT"},"J","K","L","M","N","O","P","Q","R"]
["SUBMISSION TYPE: ",null,null,{"$f":"+D6","v":"SELECT"},"CMHSP"]
["SUBMISSION DATE: ",null,null,{"$f":"+D7","v":"00:00:00"},"# 8","# 9","# 10","# 11","# 12","# 13","# 14","# 15","# 16"]
[1,null,"PIHP or CMHSP"]
[]
["A",null,"MEDICAID SERVICES - PIHP USE ONLY"]
["A",100,"REVENUE"]
["A",101,"Total Specialty Managed Care Medicaid Revenue"]
["A",115,"Medicaid Managed Care - Affiliate Contracts"]
["A",120,"Subtotal - Current Period Medicaid Services Revenue  ",null,{"$f":"SUM(E74:E76)","v":0},0,0,0,0,0,0,0,0]
["A",121,"1st & 3rd Party Collections - Medicare/Medicaid Consumers - Rpting Bd"]
["A",122,"1st & 3rd Party Collections - Medicare/Medicaid Consumers - Affiliate"]
["A",123,"Prior Year Medicaid Savings (Funding Current Year Expenses)"]
["A",124,"ISF Abatement "]
["A",140,"Subtotal - Other Medicaid Revenue",null,{"$f":"SUM(E78:E81)","v":0},0,0,0,0,0,0,0,0]
["A",190,"TOTAL REVENUE",null,{"$f":"+E77+E82","v":0},0,0,0,0,0,0,0,0]
["A",200,"EXPENDITURE"]
["A",201,"PIHP Insurance Provider Assessment (IPA) Tax"]
["A",202,"Medicaid Services (incl Autism)"]
["A",203,"Payment into Medicaid ISF"]
["A",204,"Psych Hospital Rate Adjuster (HRA) "]
["A",205,"MI Health Link - Medicaid Services"]
["A",290,"TOTAL EXPENDITURE",null,{"$f":"SUM(E84:E89)","v":0},{"$f":"SUM(F84:F89)","v":0},0,0,0,0,0,0,0]
["A",295,"SUBTOTAL NET MEDICAID SERVICES SURPLUS (DEFICIT)",null,{"$f":"+E83-E90","v":0},0,0,0,0,0,0,0,0]
["A",300,"Redirected Funds (To) From"]
["A",301,"(TO) CMHSP to CMHSP Earned Contracts - J304"]
["A","301a","Intentionally left blank"]
["A","301b","(TO) Healthy MI Plan - AI310"]
["A","301c","(TO) MI Health Link Services (Medicare) - AK310"]
["A",302,"FROM CMHSP to CMHSP Earned Contracts - J301 (explain - section AB)"]
["A",303,"FROM Non-MDHHS Earned Contracts - K301   (explain - section AB)"]
["A","310a","FROM Healthy MI Plan - AI301a"]
["A",315,"FROM Restricted Fund Balance - RES 1.c"]
["A",325,"Info only - Affiliate Total Redirected Funds - I390"]
["A",330,"Subtotal Redirected Funds rows 301 - 325",null,{"$f":"SUBTOTAL(9,E92:E101)","v":0},0,0,0,0,0,0,0,{"$f":"SUBTOTAL(9,M92:M101)","v":0}]
["A",331,"FROM General Fund - Redirected to Unfunded Medicaid Costs - B301"]
["A",332,"FROM Local Funds - M301"]
["A",333,"FROM Risk Corridor - PIHP Share - N301"]
["A",334,"FROM Risk Corridor - MDHHS Share - N302"]
["A",335,"FROM Restricted Fund Balance - Risk Financing RES 1.c"]
["A",390,"Total Redirected Funds",null,{"$f":"(SUBTOTAL(9,E92:E107))","v":0},{"$f":"(SUBTOTAL(9,F92:F107))","v":0},0,0,0,0,0,0,0]
["A",400,"BALANCE MEDICAID SERVICES",null,{"$f":"+E91+E108","v":0},0,0,0,0,0,0,0,0]

{"sheet":"FSR - Healthy Michigan","index":4,"n_rows":103,"n_cols":13,"rows_kept":103,"cut":false,"hidden":true,"merged":[[5,4,6,4],[5,12,6,12],[96,2,96,3],[104,2,104,3],[97,2,97,3],[98,2,98,3],[99,2,99,3],[101,2,101,3],[102,2,102,3],[100,2,100,3],[82,2,82,3],[83,2,83,3],[85,2,85,3],[86,2,86,3],[87,2,87,3],[88,2,88,3],[90,2,90,3],[91,2,91,3],[94,2,94,3],[95,2,95,3],[93,2,93,3],[92,2,92,3],[89,2,89,3],[78,2,78,3],[79,2,79,3],[80,2,80,3],[81,2,81,3],[84,2,84,3],[72,2,72,3],[73,2,73,3],[76,2,76,3],[77,2,77,3],[74,2,74,3],[75,2,75,3],[69,2,69,3],[70,2,70,3],[71,2,71,3],[64,0,64,2],[65,0,65,2],[65,4,65,11],[66,0,66,2],[67,2,67,3],[68,2,68,3],[47,2,56,12],[60,0,60,12],[61,0,61,12],[63,0,63,1],[63,2,63,3],[63,4,63,12],[42,2,42,3],[27,2,27,3],[28,2,28,3],[30,2,30,3],[31,2,31,3],[34,2,34,3],[35,2,35,3],[32,2,32,3],[36,2,36,3],[37,2,37,3],[38,2,38,3],[39,2,39,3],[41,2,41,3],[40,2,40,3],[29,2,29,3],[33,2,33,3],[22,2,22,3],[23,2,23,3],[25,2,25,3],[26,2,26,3],[17,2,17,3],[18,2,18,3],[19,2,19,3],[20,2,20,3],[21,2,21,3],[24,2,24,3],[16,2,16,3],[10,2,10,3],[11,2,11,3],[14,2,14,3],[15,2,15,3],[45,2,45,12],[46,2,46,12],[9,2,9,3],[0,0,0,12],[1,0,1,12],[3,0,3,1],[3,2,3,3],[3,4,3,12],[4,0,4,2],[5,0,5,2],[5,5,5,11],[6,0,6,2],[7,2,7,3],[8,2,8,3],[12,2,12,3],[13,2,13,3]]}
["MDHHS/PIHP MEDICAID MANAGED SPECIALTY SUPPORTS AND SERVICES CONCURRENT WAIVER PROGRAMS CONTRACT"]
["FINANCIAL STATUS REPORT - Healthy Michigan page 1"]
[]
["PIHP:",null,{"$f":"'FSR - Medicaid'!C4","v":0},null,"YEAR TO DATE REPORTING"]
["FISCAL YEAR: ",null,null,{"$f":"'FSR - Medicaid'!D5","v":"SELECT"},"A","B","C","D","E","F","G","H","I"]
["SUBMISSION TYPE: ",null,null,{"$f":"'FSR - Medicaid'!D6","v":"SELECT"},"Regional Authority / Reporting Board","CMHSP",null,null,null,null,null,null,"PIHP Grand Total page     1 & 2"]
["SUBMISSION DATE: ",null,null,{"$f":"'FSR - Medicaid'!D7","v":"00:00:00"},null,"# 1","# 2","# 3","# 4","# 5","# 6","# 7"]
[1,null,"PIHP or CMHSP",null,{"$f":"'FSR - Medicaid'!E8","v":0},{"$f":"'FSR - Medicaid'!F8","v":0},{"$f":"'FSR - Medicaid'!G8","v":0},{"$f":"'FSR - Medicaid'!H8","v":0},{"$f":"'FSR - Medicaid'!I8","v":0},{"$f":"'FSR - Medicaid'!J8","v":0},{"$f":"'FSR - Medicaid'!K8","v":0},{"$f":"'FSR - Medicaid'!L8","v":0}]
[]
["AI",null,"HEALTHY MICHIGAN SERVICES - PIHP USE ONLY"]
["AI",100,"REVENUE"]
["AI",101,"Healthy Michigan Plan",null,{"$f":"+'Medicaid Worksheet'!E20","v":0},null,null,null,null,null,null,null,{"$f":"SUM(E12:L12,E72:M72)","v":0}]
["AI",115,"Healthy Michigan Managed Care - Affiliate Contracts",null,{"$f":"-SUM(F13:L13,E73:M73)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(E13:L13,E73:M73)","v":0}]
["AI",120,"Subtotal - Current Period Healthy Michigan Services Revenue  ",null,{"$f":"SUM(E11:E13)","v":0},0,0,0,0,0,0,0,0]
["AI",121,"       1st & 3rd Party Collections - HMP Consumers - Rpting Bd",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E15:L15,E75:M75)","v":0}]
["AI",122,"       1st & 3rd Party Collections - HMP Consumers - Affiliate",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E16:L16,E76:M76)","v":0}]
["AI",123,"Prior Year Healthy MI Plan Savings (Funding Current Year Expenses)",null,{"$f":"'Medicaid Worksheet'!H68","v":0},null,null,null,null,null,null,null,{"$f":"SUM(E17:L17,E77:M77)","v":0}]
["AI",124,"ISF Abatement HMP",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E18:L18,E78:M78)","v":0}]
["AI",140,"Subtotal - Other Healthy Michigan Revenue",null,{"$f":"SUM(E15:E18)","v":0},0,0,0,0,0,0,0,0]
["AI",190,"TOTAL REVENUE",null,{"$f":"+E14+E19","v":0},0,0,0,0,0,0,0,0]
["AI",200,"EXPENDITURE"]
["AI",201,"PIHP Insurance Provider Assessment (IPA) Tax Healthy Michigan Plan",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E22:L22,E82:M82)","v":0}]
["AI",202,"Healthy Michigan Plan Services (incl Autism)",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E23:L23,E83:M83)","v":0}]
["AI",203,"Payment into Healthy Michigan Plan ISF",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E24:L24,E84:M84)","v":0}]
["AI",204,"Psych Hospital Rate Adjuster (HRA) ",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E25:L25,E85:M85)","v":0}]
["AI",290,"TOTAL EXPENDITURE",null,{"$f":"SUM(E21:E25)","v":0},{"$f":"SUM(F21:F25)","v":0},0,0,0,0,0,0,0]
["AI",295,"SUBTOTAL NET HEALTHY MICHIGAN SERVICES SURPLUS (DEFICIT)",null,{"$f":"+E20-E26","v":0},0,0,0,0,0,0,0,0]
["AI",300,"Redirected Funds (To) From"]
["AI",301,"(TO) CMHSP to CMHSP Earned Contracts - J304.1",null,{"$f":"-'FSR - All Non Medicaid'!E302","v":0},null,null,null,null,null,null,null,{"$f":"SUM(E29:L29,E89:M89)","v":0}]
["AI","301a","(TO) Medicaid - A310a",null,{"$f":"-'FSR - Medicaid'!E36","v":0},null,null,null,null,null,null,null,0]
["AI",302,"FROM CMHSP to CMHSP Earned Contracts - J301.1 (explain - section AJ)",null,null,null,null,null,null,null,null,null,0]
["AI",303,"FROM Non-MDHHS Earned Contracts - K301.1   (explain - section AJ)",null,null,null,null,null,null,null,null,null,0]
["AI",310,"FROM Medicaid - A301b",null,null,null,null,null,null,null,null,null,0]
["AI",315,"FROM Restricted Fund Balance - RES 1.g",null,{"$f":"-SUM('Res Fund Bal'!E18+'Res Fund Bal'!G18)","v":0},null,null,null,null,null,null,null,0]
["AI",325,"Info only - Affiliate Total Redirected Funds - I390",null,null,null,null,null,null,null,null,null,0]
["AI",330,"Subtotal Redirected Funds rows 301 - 325",null,{"$f":"SUBTOTAL(9,E28:E35)","v":0},0,0,0,0,0,0,0,0]
["AI",331,"FROM General Fund - Redirected to Unfunded Healthy Michigan Costs - B301.1",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E37:L37,E97:M97)","v":0}]
["AI",332,"FROM Local Funds - M301.1",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E38:L38,E98:M98)","v":0}]
["AI",333,"FROM Risk Corridor - PIHP Share - N301.1",null,{"$f":"-'Medicaid ISF Report'!I16","v":0},null,null,null,null,null,null,null,{"$f":"SUM(E39:L39,E99:M99)","v":0}]
["AI",334,"FROM Risk Corridor - MDHHS Share - N302.1",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E40:L40,E100:M100)","v":0}]
["AI",335,"FROM Restricted Fund Balance - Risk Financing RES 1.g",null,{"$f":"-SUM('Res Fund Bal'!F18+'Res Fund Bal'!H18)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(E41:L41,E101:M101)","v":0}]
["AI",390,"Total Redirected Funds",null,{"$f":"(SUBTOTAL(9,E28:E41))","v":0},0,0,0,0,0,0,0,0]
["AI",400,"BALANCE HEALTHY MICHIGAN PLAN SERVICES",null,{"$f":"+E27+E42","v":0},0,0,0,0,0,0,0,0]
[]
[]
["AJ",null,"REMARKS"]
["AJ",null,"Remarks may be added about any entry or activity on the report for which additional information may be useful."]
["AJ"]
["AJ"]
["AJ"]
["AJ"]
["AJ"]
["AJ"]
["AJ"]
["AJ"]
["AJ"]
["AJ"]
[]
[]
[]
["MDHHS/PIHP MEDICAID MANAGED SPECIALTY SUPPORTS AND SERVICES CONCURRENT WAIVER PROGRAMS CONTRACT"]
["FINANCIAL STATUS REPORT - Healthy Michigan page 2"]
[]
["PIHP:",null,{"$f":"+C4","v":0},null,"YEAR TO DATE REPORTING"]
["FISCAL YEAR: ",null,null,{"$f":"D5","v":"SELECT"},"J","K","L","M","N","O","P","Q","R"]
["SUBMISSION TYPE: ",null,null,{"$f":"+D6","v":"SELECT"},"CMHSP"]
["SUBMISSION DATE: ",null,null,{"$f":"+D7","v":"00:00:00"},"# 8","# 9","# 10","# 11","# 12","# 13","# 14","# 15","# 16"]
[1,null,"PIHP or CMHSP",null,{"$f":"'FSR - Medicaid'!E71","v":0},{"$f":"'FSR - Medicaid'!F71","v":0},{"$f":"'FSR - Medicaid'!G71","v":0},{"$f":"'FSR - Medicaid'!H71","v":0},{"$f":"'FSR - Medicaid'!I71","v":0},{"$f":"'FSR - Medicaid'!J71","v":0},{"$f":"'FSR - Medicaid'!K71","v":0},{"$f":"'FSR - Medicaid'!L71","v":0},{"$f":"'FSR - Medicaid'!M71","v":0}]
[]
["AI",null,"HEALTHY MICHIGAN SERVICES - PIHP USE ONLY"]
["AI",100,"REVENUE"]
["AI",101,"Healthy Michigan Plan"]
["AI",115,"Healthy Michigan Managed Care - Affiliate Contracts"]
["AI",120,"Subtotal - Current Period Healthy Michigan Services Revenue  ",null,{"$f":"SUM(E71:E73)","v":0},0,0,0,0,0,0,0,0]
["AI",121,"       1st & 3rd Party Collections - HMP Consumers - Rpting Bd"]
["AI",122,"       1st & 3rd Party Collections - HMP Consumers - Affiliate"]
["AI",123,"Prior Year Healthy MI Plan Savings (Funding Current Year Expenses)"]
["AI",124,"ISF Abatement HMP"]
["AI",140,"Subtotal - Other Healthy Michigan Revenue",null,{"$f":"SUM(E75:E78)","v":0},0,0,0,0,0,0,0,0]
["AI",190,"TOTAL REVENUE",null,{"$f":"+E74+E79","v":0},0,0,0,0,0,0,0,0]
["AI",200,"EXPENDITURE"]
["AI",201,"PIHP Insurance Provider Assessment (IPA) Tax Healthy Michigan Plan"]
["AI",202,"Healthy Michigan Plan Services (incl Autism)"]
["AI",203,"Payment into Healthy Michigan Plan ISF"]
["AI",204,"Psych Hospital Rate Adjuster (HRA) "]
["AI",290,"TOTAL EXPENDITURE",null,{"$f":"SUM(E81:E85)","v":0},{"$f":"SUM(F81:F85)","v":0},0,0,0,0,0,0,0]
["AI",295,"SUBTOTAL NET HEALTHY MICHIGAN SERVICES SURPLUS (DEFICIT)",null,{"$f":"+E80-E86","v":0},0,0,0,0,0,0,0,0]
["AI",300,"Redirected Funds (To) From"]
["AI",301,"(TO) CMHSP to CMHSP Earned Contracts - J304.1"]
["AI","301a","(TO) Medicaid - A310a"]
["AI",302,"FROM CMHSP to CMHSP Earned Contracts - J301.1 (explain - section AJ)"]
["AI",303,"FROM Non-MDHHS Earned Contracts - K301.1   (explain - section AJ)"]
["AI",310,"FROM Medicaid - A301b"]
["AI",315,"FROM Restricted Fund Balance - RES 1.g"]
["AI",325,"Info only - Affiliate Total Redirected Funds - I390"]
["AI",330,"Subtotal Redirected Funds rows 301 - 325",null,{"$f":"SUBTOTAL(9,E88:E95)","v":0},0,0,0,0,0,0,0,0]
["AI",331,"FROM General Fund - Redirected to Unfunded Healthy Michigan Costs - B301.1"]
["AI",332,"FROM Local Funds - M301.1"]
["AI",333,"FROM Risk Corridor - PIHP Share - N301.1"]
["AI",334,"FROM Risk Corridor - MDHHS Share - N302.1"]
["AI",335,"FROM Restricted Fund Balance - Risk Financing RES 1.g"]
["AI",390,"Total Redirected Funds",null,{"$f":"(SUBTOTAL(9,E88:E101))","v":0},0,0,0,0,0,0,0,0]
["AI",400,"BALANCE HEALTHY MICHIGAN PLAN SERVICES",null,{"$f":"+E87+E102","v":0},0,0,0,0,0,0,0,0]

{"sheet":"FSR - Health Homes BH","index":5,"n_rows":42,"n_cols":13,"rows_kept":42,"cut":false,"hidden":true,"merged":[[9,2,9,3],[0,0,0,12],[1,0,1,12],[3,0,3,1],[3,2,3,3],[3,4,3,12],[4,0,4,2],[5,0,5,2],[5,5,5,11],[6,0,6,2],[7,2,7,3],[8,2,8,3],[5,4,6,4],[5,12,6,12],[13,2,13,3],[14,2,14,3],[15,2,15,3],[10,2,10,3],[11,2,11,3],[12,2,12,3],[28,2,28,3],[32,2,41,12],[18,2,18,3],[16,2,16,3],[17,2,17,3],[22,2,22,3],[24,2,24,3],[25,2,25,3],[27,2,27,3],[20,2,20,3],[19,2,19,3],[31,2,31,12],[30,2,30,12],[26,2,26,3],[21,2,21,3],[23,2,23,3]]}
["MDHHS/PIHP MEDICAID MANAGED SPECIALTY SUPPORTS AND SERVICES CONCURRENT WAIVER PROGRAMS CONTRACT"]
["FINANCIAL STATUS REPORT - Health Home Services"]
[]
["PIHP:",null,{"$f":"'FSR - Medicaid'!C4","v":0},null,"YEAR TO DATE REPORTING"]
["FISCAL YEAR: ",null,null,{"$f":"'FSR - Medicaid'!D5","v":"SELECT"},"A","B","C","D","E","F","G","H","I"]
["SUBMISSION TYPE: ",null,null,{"$f":"'FSR - Medicaid'!D6","v":"SELECT"},"Regional Authority / Reporting Board","CMHSP",null,null,null,null,null,null,"PIHP Grand Total page     1 & 2"]
["SUBMISSION DATE: ",null,null,{"$f":"'FSR - Medicaid'!D7","v":"00:00:00"},null,"# 1","# 2","# 3","# 4","# 5","# 6","# 7"]
[1,null,"PIHP or CMHSP",null,{"$f":"'FSR - Medicaid'!E8","v":0},{"$f":"'FSR - Medicaid'!F8","v":0},{"$f":"'FSR - Medicaid'!G8","v":0},{"$f":"'FSR - Medicaid'!H8","v":0},{"$f":"'FSR - Medicaid'!I8","v":0},{"$f":"'FSR - Medicaid'!J8","v":0},{"$f":"'FSR - Medicaid'!K8","v":0},{"$f":"'FSR - Medicaid'!L8","v":0}]
[]
["AG",null,"Health Home Program - PIHP USE ONLY"]
["AG",100,"REVENUE"]
["AG",101,"    Revenue - Health Home Services",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E12:L12)","v":0}]
["AG",115,"Affiliate Contracts",null,{"$f":"-SUM(F13:L13)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(E13:L13)","v":0}]
["AG",190,"TOTAL REVENUE",null,{"$f":"SUM(E12:E13)","v":0},{"$f":"SUM(F12:F13)","v":0},0,0,0,0,0,0,0]
["AG",200,"EXPENDITURE"]
["AG",201,"PIHP Insurance Provider Assessment (IPA) Tax",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E16:L16)","v":0}]
["AG",202,"Expenditure - Health Home Services",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E17:L17)","v":0}]
["AG",204,"Surplus Funding Retained",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E18:L18)","v":0}]
["AG",290,"TOTAL EXPENDITURE",null,{"$f":"SUM(E16:E18)","v":0},{"$f":"SUM(F16:F18)","v":0},0,0,0,0,0,0,0]
["AG",295,"SUBTOTAL NET HEALTH HOME SERVICES SURPLUS (DEFICIT)",null,{"$f":"+E14-E19","v":0},{"$f":"+F14-F19","v":0},0,0,0,0,0,0,0]
["AG",300,"Redirected Funds (To) From"]
["AG",315,"FROM Restricted Fund Balance - RES 1.f",null,{"$f":"-SUM('Res Fund Bal'!E17+'Res Fund Bal'!G17)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(E22:L22)","v":0}]
["AG",325,"Info only - Affiliate Total Redirected Funds - IC390",null,null,null,null,null,null,null,null,null,0]
["AG",330,"Subtotal Redirected Funds rows 301 - 325",null,{"$f":"SUBTOTAL(9,E21:E23)","v":0},{"$f":"SUBTOTAL(9,F21:F23)","v":0},0,0,0,0,0,0,0]
["AG",331,"FROM General Fund - B301.4",null,null,null,null,null,null,null,null,null,0]
["AG",332,"FROM Local Funds - M301.4",null,null,null,null,null,null,null,null,null,0]
["AG",335,"FROM Restricted Fund Balance - Risk Financing RES 1.f",null,{"$f":"-SUM('Res Fund Bal'!F17+'Res Fund Bal'!H17)","v":0},null,null,null,null,null,null,null,0]
["AG",390,"Total Redirected Funds",null,{"$f":"(SUBTOTAL(9,E21:E27))","v":0},{"$f":"(SUBTOTAL(9,F21:F27))","v":0},{"$f":"(SUBTOTAL(9,G21:G27))","v":0},0,0,0,0,0,{"$f":"(SUBTOTAL(9,M21:M27))","v":0}]
["AG",400,"BALANCE HEALTH HOMES BEHAVIORAL HEALTH SERVICES",null,{"$f":"+E20+E28","v":0},{"$f":"+F20+F28","v":0},0,0,0,0,0,0,0]
[]
["AH",null,"REMARKS"]
["AH",null,"Remarks may be added about any entry or activity on the report for which additional information may be useful.  Please note risk management arrangement between PIHP and Affiliates."]
["AH"]
["AH"]
["AH"]
["AH"]
["AH"]
["AH"]
["AH"]
["AH"]
["AH"]
["AH"]

{"sheet":"FSR - Opioid Health Home BH","index":6,"n_rows":42,"n_cols":13,"rows_kept":42,"cut":false,"hidden":true,"merged":[[28,2,28,3],[30,2,30,12],[31,2,31,12],[32,2,41,12],[20,2,20,3],[22,2,22,3],[24,2,24,3],[25,2,25,3],[26,2,26,3],[27,2,27,3],[21,2,21,3],[23,2,23,3],[19,2,19,3],[8,2,8,3],[9,2,9,3],[10,2,10,3],[11,2,11,3],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[7,2,7,3],[0,0,0,12],[1,0,1,12],[3,0,3,1],[3,2,3,3],[3,4,3,12],[4,0,4,2],[5,0,5,2],[5,4,6,4],[5,5,5,11],[5,12,6,12],[6,0,6,2]]}
["MDHHS/PIHP MEDICAID MANAGED SPECIALTY SUPPORTS AND SERVICES CONCURRENT WAIVER PROGRAMS CONTRACT"]
["FINANCIAL STATUS REPORT - Opioid Health Home Services"]
[]
["PIHP:",null,{"$f":"'FSR - Medicaid'!C4","v":0},null,"YEAR TO DATE REPORTING"]
["FISCAL YEAR: ",null,null,{"$f":"'FSR - Medicaid'!D5","v":"SELECT"},"A","B","C","D","E","F","G","H","I"]
["SUBMISSION TYPE: ",null,null,{"$f":"'FSR - Medicaid'!D6","v":"SELECT"},"Regional Authority / Reporting Board","CMHSP",null,null,null,null,null,null,"PIHP Grand Total page     1 & 2"]
["SUBMISSION DATE: ",null,null,{"$f":"'FSR - Medicaid'!D7","v":"00:00:00"},null,"# 1","# 2","# 3","# 4","# 5","# 6","# 7"]
[1,null,"PIHP or CMHSP",null,{"$f":"'FSR - Medicaid'!E8","v":0},{"$f":"'FSR - Medicaid'!F8","v":0},{"$f":"'FSR - Medicaid'!G8","v":0},{"$f":"'FSR - Medicaid'!H8","v":0},{"$f":"'FSR - Medicaid'!I8","v":0},{"$f":"'FSR - Medicaid'!J8","v":0},{"$f":"'FSR - Medicaid'!K8","v":0},{"$f":"'FSR - Medicaid'!L8","v":0}]
[]
["AE",null,"Opioid Health Home Program - PIHP USE ONLY"]
["AE",100,"REVENUE"]
["AE",101,"    Revenue - Opioid Health Home Services",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E12:L12)","v":0}]
["AE",115,"Affiliate Contracts",null,{"$f":"-SUM(F13:L13)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(E13:L13)","v":0}]
["AE",190,"TOTAL REVENUE",null,{"$f":"SUM(E12:E13)","v":0},{"$f":"SUM(F12:F13)","v":0},0,0,0,0,0,0,0]
["AE",200,"EXPENDITURE"]
["AE",201,"PIHP Insurance Provider Assessment (IPA) Tax   ",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E16:L16)","v":0}]
["AE",202,"Expenditure - Opioid Health Home Services",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E17:L17)","v":0}]
["AE",204,"Surplus Funding Retained",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E18:L18)","v":0}]
["AE",290,"TOTAL EXPENDITURE",null,{"$f":"SUM(E16:E18)","v":0},{"$f":"SUM(F16:F18)","v":0},0,0,0,0,0,0,0]
["AE",295,"SUBTOTAL NET OPIOID HEALTH HOME SERVICES SURPLUS (DEFICIT)",null,{"$f":"+E14-E19","v":0},{"$f":"+F14-F19","v":0},0,0,0,0,0,0,0]
["AE",300,"Redirected Funds (To) From"]
["AE",315,"FROM Restricted Fund Balance - RES 1.e",null,{"$f":"-SUM('Res Fund Bal'!E16+'Res Fund Bal'!G16)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(E22:L22)","v":0}]
["AE",325,"Info only - Affiliate Total Redirected Funds - IB390",null,null,null,null,null,null,null,null,null,0]
["AE",330,"Subtotal Redirected Funds rows 301 - 325",null,{"$f":"SUBTOTAL(9,E21:E23)","v":0},{"$f":"SUBTOTAL(9,F21:F23)","v":0},0,0,0,0,0,0,0]
["AE",331,"FROM General Fund - B301.3",null,null,null,null,null,null,null,null,null,0]
["AE",332,"FROM Local Funds - M301.3",null,null,null,null,null,null,null,null,null,0]
["AE",335,"FROM Restricted Fund Balance - Risk Financing RES 1.e",null,{"$f":"-SUM('Res Fund Bal'!F16+'Res Fund Bal'!H16)","v":0},null,null,null,null,null,null,null,0]
["AE",390,"Total Redirected Funds",null,{"$f":"(SUBTOTAL(9,E21:E27))","v":0},{"$f":"(SUBTOTAL(9,F21:F26))","v":0},0,0,0,0,0,0,{"$f":"(SUBTOTAL(9,M21:M27))","v":0}]
["AE",400,"BALANCE  OPIOID HEALTH HOME SERVICES",null,{"$f":"+E20+E28","v":0},{"$f":"+F20+F28","v":0},0,0,0,0,0,0,0]
[]
["AF",null,"REMARKS"]
["AF",null,"Remarks may be added about any entry or activity on the report for which additional information may be useful.  Please note risk management arrangement between PIHP and Affiliates."]
["AF"]
["AF"]
["AF"]
["AF"]
["AF"]
["AF"]
["AF"]
["AF"]
["AF"]
["AF"]

{"sheet":"FSR - MI Health Link","index":7,"n_rows":95,"n_cols":13,"rows_kept":95,"cut":false,"hidden":true,"merged":[[5,12,6,12],[13,2,13,3],[10,2,10,3],[11,2,11,3],[9,2,9,3],[8,2,8,3],[12,2,12,3],[0,0,0,12],[1,0,1,12],[3,0,3,1],[3,2,3,3],[3,4,3,12],[4,0,4,2],[5,0,5,2],[5,5,5,11],[6,0,6,2],[7,2,7,3],[5,4,6,4],[14,2,14,3],[15,2,15,3],[16,2,16,3],[17,2,17,3],[29,2,29,3],[19,2,19,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[25,2,25,3],[26,2,26,3],[27,2,27,3],[18,2,18,3],[28,2,28,3],[59,0,59,1],[59,2,59,3],[59,4,59,12],[30,2,30,3],[31,2,31,3],[32,2,32,3],[33,2,33,3],[36,2,36,3],[37,2,37,3],[38,2,38,3],[43,2,52,12],[56,0,56,12],[57,0,57,12],[34,2,34,3],[35,2,35,3],[42,2,42,12],[60,0,60,2],[61,0,61,2],[61,4,61,11],[62,0,62,2],[63,2,63,3],[64,2,64,3],[65,2,65,3],[66,2,66,3],[67,2,67,3],[69,2,69,3],[68,2,68,3],[91,2,91,3],[70,2,70,3],[81,2,81,3],[82,2,82,3],[75,2,75,3],[76,2,76,3],[90,2,90,3],[73,2,73,3],[74,2,74,3],[84,2,84,3],[41,2,41,12],[93,2,93,3],[89,2,89,3],[92,2,92,3],[94,2,94,3],[71,2,71,3],[72,2,72,3],[83,2,83,3],[86,2,86,3],[87,2,87,3],[88,2,88,3],[77,2,77,3],[78,2,78,3],[79,2,79,3],[80,2,80,3],[85,2,85,3]]}
["MDHHS/PIHP MEDICAID MANAGED SPECIALTY SUPPORTS AND SERVICES CONCURRENT WAIVER PROGRAMS CONTRACT"]
["FINANCIAL STATUS REPORT - MI Health Link page 1"]
[]
["PIHP:",null,{"$f":"'FSR - Medicaid'!C4","v":0},null,"YEAR TO DATE REPORTING"]
["FISCAL YEAR: ",null,null,{"$f":"'FSR - Medicaid'!D5","v":"SELECT"},"A","B","C","D","E","F","G","H","I"]
["SUBMISSION TYPE: ",null,null,{"$f":"'FSR - Medicaid'!D6","v":"SELECT"},"Regional Authority / Reporting Board","CMHSP",null,null,null,null,null,null,"PIHP Grand Total page     1 & 2"]
["SUBMISSION DATE: ",null,null,{"$f":"'FSR - Medicaid'!D7","v":"00:00:00"},null,"# 1","# 2","# 3","# 4","# 5","# 6","# 7"]
[1,null,"PIHP or CMHSP",null,{"$f":"'FSR - Medicaid'!E8","v":0},{"$f":"'FSR - Medicaid'!F8","v":0},{"$f":"'FSR - Medicaid'!G8","v":0},{"$f":"'FSR - Medicaid'!H8","v":0},{"$f":"'FSR - Medicaid'!I8","v":0},{"$f":"'FSR - Medicaid'!J8","v":0},{"$f":"'FSR - Medicaid'!K8","v":0},{"$f":"'FSR - Medicaid'!L8","v":0}]
[]
["AK",null,"MI HEALTH LINK SERVICES - PIHP USE ONLY"]
["AK",100,"REVENUE"]
["AK",101,"MI Health Link",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E12:L12,E68:M68)","v":0}]
["AK",102,"ICO - Risk Financing / (ICO - Shared Savings)",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E13:L13,E69:M69)","v":0}]
["AK",115,"MI Health Link - Affiliate Contracts",null,{"$f":"-SUM(F14:L14,E70:M70)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(E14:L14,E70:M70)","v":0}]
["AK",120,"Subtotal - Current Period MI Health Link Services Revenue  ",null,{"$f":"SUM(E11:E14)","v":0},0,0,0,0,0,0,0,0]
["AK",121,"       1st & 3rd Party Collections - MI Health Link Consumers - Rpting Bd",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E16:L16,E72:M72)","v":0}]
["AK",122,"       1st & 3rd Party Collections - MI Health Link Consumers - Affiliate",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E17:L17,E73:M73)","v":0}]
["AK",140,"Subtotal - Other MI Health Link Revenue",null,{"$f":"SUM(E16:E17)","v":0},0,0,0,0,0,0,0,0]
["AK",190,"TOTAL REVENUE",null,{"$f":"+E15+E18","v":0},0,0,0,0,0,0,0,0]
["AK",200,"EXPENDITURE"]
["AK",202,"MI Health Link Services",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E21:L21,E77:M77)","v":0}]
["AK",290,"TOTAL EXPENDITURE",null,{"$f":"SUM(E20:E21)","v":0},0,0,0,0,0,0,0,0]
["AK",295,"SUBTOTAL NET MI HEALTH LINK SERVICES SURPLUS (DEFICIT)",null,{"$f":"+E19-E22","v":0},0,0,0,0,0,0,0,0]
["AK",300,"Redirected Funds (To) From"]
["AK",301,"(TO) CMHSP to CMHSP Earned Contracts - J304.3",null,{"$f":"-'FSR - All Non Medicaid'!E304","v":0},null,null,null,null,null,null,null,{"$f":"SUM(E25:L25,E81:M81)","v":0}]
["AK",302,"FROM CMHSP to CMHSP Earned Contracts - J301.3 (explain - section AL)",null,null,null,null,null,null,null,null,null,0]
["AK",303,"FROM Non-MDHHS Earned Contracts - K301.3   (explain - section AL)",null,null,null,null,null,null,null,null,null,0]
["AK",310,"FROM Medicaid - A301c",null,null,null,null,null,null,null,null,null,0]
["AK",315,"FROM Restricted Fund Balance - RES 1.h",null,{"$f":"-SUM('Res Fund Bal'!E19+'Res Fund Bal'!G19)","v":0},null,null,null,null,null,null,null,0]
["AK",325,"Info only - Affiliate Total Redirected Funds - ID390",null,null,null,null,null,null,null,null,null,0]
["AK",330,"Subtotal Redirected Funds rows 301 - 325",null,{"$f":"SUBTOTAL(9,E24:E30)","v":0},0,0,0,0,0,0,0,0]
["AK",331,"FROM General Fund - Redirected to Unfunded MI Health Link Costs - B301.5",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E32:L32,E88:M88)","v":0}]
["AK",332,"FROM Local Funds - M301.5",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E33:L33,E89:M89)","v":0}]
["AK",333,"Intentionally left blank"]
["AK",334,"Intentionally left blank"]
["AK",335,"FROM Restricted Fund Balance - Risk Financing RES 1.h",null,{"$f":"-SUM('Res Fund Bal'!F19+'Res Fund Bal'!H19)","v":0}]
["AK",336,"(TO) Local funds - M313.3",null,{"$f":"-'FSR - All Non Medicaid'!E398","v":0},null,null,null,null,null,null,null,{"$f":"SUM(E37:L37,E93:M93)","v":0}]
["AK",390,"Total Redirected Funds",null,{"$f":"(SUBTOTAL(9,E24:E37))","v":0},0,0,0,0,0,0,0,0]
["AK",400,"BALANCE MI HEALTH LINK SERVICES (must = 0)",null,{"$f":"+E23+E38","v":0},0,0,0,0,0,0,0,0]
[]
[]
["AL",null,"REMARKS"]
["AL",null,"Remarks may be added about any entry or activity on the report for which additional information may be useful."]
["AL"]
["AL"]
["AL"]
["AL"]
["AL"]
["AL"]
["AL"]
["AL"]
["AL"]
["AL"]
[]
[]
[]
["MDHHS/PIHP MEDICAID MANAGED SPECIALTY SUPPORTS AND SERVICES CONCURRENT WAIVER PROGRAMS CONTRACT"]
["FINANCIAL STATUS REPORT - MI HEALTH LINK page 2"]
[]
["PIHP:",null,{"$f":"+C4","v":0},null,"YEAR TO DATE REPORTING"]
["FISCAL YEAR: ",null,null,{"$f":"D5","v":"SELECT"},"J","K","L","M","N","O","P","Q","R"]
["SUBMISSION TYPE: ",null,null,{"$f":"+D6","v":"SELECT"},"CMHSP"]
["SUBMISSION DATE: ",null,null,{"$f":"+D7","v":"00:00:00"},"# 8","# 9","# 10","# 11","# 12","# 13","# 14","# 15","# 16"]
[1,null,"PIHP or CMHSP",null,{"$f":"'FSR - Medicaid'!E71","v":0},{"$f":"'FSR - Medicaid'!F71","v":0},{"$f":"'FSR - Medicaid'!G71","v":0},{"$f":"'FSR - Medicaid'!H71","v":0},{"$f":"'FSR - Medicaid'!I71","v":0},{"$f":"'FSR - Medicaid'!J71","v":0},{"$f":"'FSR - Medicaid'!K71","v":0},{"$f":"'FSR - Medicaid'!L71","v":0},{"$f":"'FSR - Medicaid'!M71","v":0}]
[]
["AK",null,"MI HEALTH LINK SERVICES - PIHP USE ONLY"]
["AK",100,"REVENUE"]
["AK",101,"MI Health Link"]
["AK",102,"FROM ICO - Risk Financing / (TO) ICO - Shared Savings"]
["AK",115,"MI Health Link - Affiliate Contracts"]
["AK",120,"Subtotal - Current Period MI Health Link Services Revenue  ",null,{"$f":"SUM(E67:E70)","v":0},0,0,0,0,0,0,0,0]
["AK",121,"       1st & 3rd Party Collections - MI Health Link Consumers - Rpting Bd"]
["AK",122,"       1st & 3rd Party Collections - MI Health Link Consumers - Affiliate"]
["AK",140,"Subtotal - Other MI Health Link Revenue",null,{"$f":"SUM(E72:E73)","v":0},0,0,0,0,0,0,0,0]
["AK",190,"TOTAL REVENUE",null,{"$f":"+E71+E74","v":0},0,0,0,0,0,0,0,0]
["AK",200,"EXPENDITURE"]
["AK",202,"MI Health Link Services"]
["AK",290,"TOTAL EXPENDITURE",null,{"$f":"SUM(E76:E77)","v":0},0,0,0,0,0,0,0,0]
["AK",295,"SUBTOTAL NET MI HEALTH LINK SERVICES SURPLUS (DEFICIT)",null,{"$f":"+E75-E78","v":0},0,0,0,0,0,0,0,0]
["AK",300,"Redirected Funds (To) From"]
["AK",301,"(TO) CMHSP to CMHSP Earned Contracts - J304.3"]
["AK",302,"FROM CMHSP to CMHSP Earned Contracts - J301.3 (explain - section AL)"]
["AK",303,"FROM Non-MDHHS Earned Contracts - K301.3   (explain - section AL)"]
["AK",310,"FROM Medicaid - A301c"]
["AK",315,"FROM Restricted Fund Balance - RES 1.h"]
["AK",325,"Info only - Affiliate Total Redirected Funds - ID390"]
["AK",330,"Subtotal Redirected Funds rows 301 - 325",null,{"$f":"SUBTOTAL(9,E80:E86)","v":0},0,0,0,0,0,0,0,0]
["AK",331,"FROM General Fund - Redirected to Unfunded MI Health Link Costs - B301.5"]
["AK",332,"FROM Local Funds - M301.5"]
["AK",333,"Intentionally left blank"]
["AK",334,"Intentionally left blank"]
["AK",335,"FROM Restricted Fund Balance - Risk Financing RES 1.h"]
["AK",336,"(TO) Local funds - M313.3"]
["AK",390,"Total Redirected Funds",null,{"$f":"(SUBTOTAL(9,E80:E93))","v":0},0,0,0,0,0,0,0,0]
["AK",400,"BALANCE MI HEALTH LINK SERVICES (must = 0)",null,{"$f":"+E79+E94","v":0},0,0,0,0,0,0,0,0]

{"sheet":"FSR - SUD","index":8,"n_rows":85,"n_cols":13,"rows_kept":85,"cut":false,"hidden":true,"merged":[[26,2,26,3],[77,2,77,3],[24,2,24,3],[70,2,70,3],[10,2,10,3],[11,2,11,3],[12,2,12,3],[19,2,19,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[13,2,13,3],[18,2,18,3],[17,2,17,3],[32,2,32,3],[84,2,84,3],[31,2,31,3],[23,2,23,3],[83,2,83,3],[25,2,25,3],[56,0,56,2],[60,2,60,3],[59,2,59,3],[61,2,61,3],[62,2,62,3],[63,2,63,3],[64,2,64,3],[65,2,65,3],[57,0,57,2],[58,2,58,3],[30,2,30,3],[9,2,9,3],[0,0,0,12],[1,0,1,12],[3,0,3,1],[3,2,3,3],[3,4,3,12],[4,0,4,2],[5,0,5,2],[5,5,5,11],[6,0,6,2],[7,2,7,3],[8,2,8,3],[5,4,6,4],[5,12,6,12],[33,2,33,3],[37,2,46,12],[51,0,51,12],[27,2,27,3],[52,0,52,12],[29,2,29,3],[36,2,36,12],[35,2,35,12],[28,2,28,3],[54,0,54,1],[54,2,54,3],[54,4,54,12],[55,0,55,2],[56,4,56,12],[67,2,67,3],[68,2,68,3],[69,2,69,3],[66,2,66,3],[71,2,71,3],[72,2,72,3],[80,2,80,3],[81,2,81,3],[82,2,82,3],[73,2,73,3],[74,2,74,3],[75,2,75,3],[76,2,76,3],[78,2,78,3],[79,2,79,3]]}
["MDHHS/PIHP MEDICAID MANAGED SPECIALTY SUPPORTS AND SERVICES CONCURRENT WAIVER PROGRAMS CONTRACT"]
["FINANCIAL STATUS REPORT - Substance Use Disorder Services - Page 1"]
[]
["PIHP:",null,{"$f":"'FSR - Medicaid'!C4","v":0},null,"YEAR TO DATE REPORTING"]
["FISCAL YEAR: ",null,null,{"$f":"'FSR - Medicaid'!D5","v":"SELECT"},"A","B","C","D","E","F","G","H","I"]
["SUBMISSION TYPE: ",null,null,{"$f":"'FSR - Medicaid'!D6","v":"SELECT"},"Regional Authority / Reporting Board","CMHSP",null,null,null,null,null,null,"PIHP Grand Total page     1 & 2"]
["SUBMISSION DATE: ",null,null,{"$f":"'FSR - Medicaid'!D7","v":"00:00:00"},null,"# 1","# 2","# 3","# 4","# 5","# 6","# 7"]
[1,null,"PIHP or CMHSP",null,{"$f":"'FSR - Medicaid'!E8","v":0},{"$f":"'FSR - Medicaid'!F8","v":0},{"$f":"'FSR - Medicaid'!G8","v":0},{"$f":"'FSR - Medicaid'!H8","v":0},{"$f":"'FSR - Medicaid'!I8","v":0},{"$f":"'FSR - Medicaid'!J8","v":0},{"$f":"'FSR - Medicaid'!K8","v":0},{"$f":"'FSR - Medicaid'!L8","v":0}]
[]
["AC",null,"Substance Use Disorder (SUD) Services - PIHP USE ONLY"]
["AC",100,"REVENUE"]
["AC",101,"    Revenue - SUD Agreement",null,{"$f":"+'SUD - Supplemental'!C25","v":0},null,null,null,null,null,null,null,{"$f":"SUM(E12:L12,E63:M63)","v":0}]
["AC",115,"Affiliate Contracts",null,{"$f":"-SUM(F13:L13,E64:M64)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(E13:L13,E64:M64)","v":0}]
["AC",120,"Subtotal SUD Agreement Revenue",null,{"$f":"SUM(E12:E13)","v":0},{"$f":"SUM(F12:F13)","v":0},0,0,0,0,0,0,0]
["AC",121,"Fees & Collections - Rpting Bd",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E15:L15,E66:M66)","v":0}]
["AC",122,"Fees & Collections - Affiliate",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E16:L16,E67:M67)","v":0}]
["AC",140,"Subtotal - Other Revenue",null,{"$f":"SUM(E15:E16)","v":0},0,0,0,0,0,0,0,0]
["AC",190,"TOTAL REVENUE",null,{"$f":"E14+E17","v":0},0,0,0,0,0,0,0,0]
["AC",200,"EXPENDITURE"]
["AC",201,"   Expenditure - SUD Services",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E20:L20,E71:M71)","v":0}]
["AC",290,"TOTAL EXPENDITURE",null,{"$f":"SUM(E20:E20)","v":0},0,0,0,0,0,0,0,0]
["AC",295,"SUBTOTAL NET SUD SERVICES SURPLUS (DEFICIT)",null,{"$f":"+E18-E21","v":0},{"$f":"+F18-F21","v":0},{"$f":"+G18-G21","v":0},0,0,0,0,0,{"$f":"+M18-M21","v":0}]
["AC",300,"Redirected Funds (To) From"]
["AC",301,"(TO) CMHSP to CMHSP Earned Contracts - J304.2",null,{"$f":"-'FSR - All Non Medicaid'!E303","v":0},null,null,null,null,null,null,null,{"$f":"SUM(E24:L24,E75:M75)","v":0}]
["AC",302,"FROM CMHSP to CMHSP Earned Contracts - J301.2 (explain section AD)",null,null,null,null,null,null,null,null,null,0]
["AC",303,"FROM Non-MDHHS Earned Contracts - K301.2 (explain section AD)",null,null,null,null,null,null,null,null,null,0]
["AC",315,"FROM Restricted Fund Balance - RES 1.d",null,{"$f":"-SUM('Res Fund Bal'!E15+'Res Fund Bal'!G15)","v":0},null,null,null,null,null,null,null,0]
["AC",325,"Info only - Affiliate Total Redirected Funds - IA390",null,null,null,null,null,null,null,null,null,0]
["AC",330,"Subtotal Redirected Funds rows 301 - 325",null,{"$f":"SUBTOTAL(9,E23:E28)","v":0},{"$f":"SUBTOTAL(9,F23:F28)","v":0},0,0,0,0,0,0,0]
["AC",331,"FROM General Funds - Redirected to Unfunded SUD Costs - B301.2",null,null,null,null,null,null,null,null,null,0]
["AC",332,"FROM Local Funds - M301.2",null,null,null,null,null,null,null,null,null,0]
["AC",335,"FROM Restricted Fund Balance - Risk Financing RES 1.d",null,{"$f":"-SUM('Res Fund Bal'!F15+'Res Fund Bal'!H15)","v":0},null,null,null,null,null,null,null,0]
["AC",390,"Total Redirected Funds",null,{"$f":"(SUBTOTAL(9,E23:E32))","v":0},{"$f":"(SUBTOTAL(9,F25:F32))","v":0},0,0,0,0,0,0,{"$f":"(SUBTOTAL(9,M23:M32))","v":0}]
["AC",400,"BALANCE SUD Services",null,{"$f":"+E22+E33","v":0},0,0,0,0,0,0,0,0]
[]
["AD",null,"REMARKS"]
["AD",null,"Remarks may be added about any entry or activity on the report for which additional information may be useful.  Please note risk management arrangement between PIHP and Affiliates."]
["AD"]
["AD"]
["AD"]
["AD"]
["AD"]
["AD"]
["AD"]
["AD"]
["AD"]
["AD"]
[]
[]
[]
[]
["MDHHS/PIHP MEDICAID MANAGED SPECIALTY SUPPORTS AND SERVICES CONCURRENT WAIVER PROGRAMS CONTRACT"]
["FINANCIAL STATUS REPORT - Substance Use Disorder Services - Page 2"]
[]
["PIHP:",null,{"$f":"C4","v":0},null,"YEAR TO DATE REPORTING"]
["FISCAL YEAR: ",null,null,{"$f":"D5","v":"SELECT"},"J","K","L","M","N","O","P","Q","R"]
["SUBMISSION TYPE: ",null,null,{"$f":"D6","v":"SELECT"},"CMHSP"]
["SUBMISSION DATE: ",null,null,{"$f":"D7","v":"00:00:00"},"# 8","# 9","# 10","# 11","# 12","# 13","# 14","# 15","# 16"]
[1,null,"PIHP or CMHSP",null,{"$f":"'FSR - Medicaid'!E71","v":0},{"$f":"'FSR - Medicaid'!F71","v":0},{"$f":"'FSR - Medicaid'!G71","v":0},{"$f":"'FSR - Medicaid'!H71","v":0},{"$f":"'FSR - Medicaid'!I71","v":0},{"$f":"'FSR - Medicaid'!J71","v":0},{"$f":"'FSR - Medicaid'!K71","v":0},{"$f":"'FSR - Medicaid'!L71","v":0},{"$f":"'FSR - Medicaid'!M71","v":0}]
[]
["AC",null,"Substance Use Disorder (SUD) Services - PIHP USE ONLY"]
["AC",100,"REVENUE"]
["AC",101,"    Revenue - SUD Agreement"]
["AC",115,"Affiliate Contracts"]
["AC",120,"Subtotal SUD Agreement Revenue",null,{"$f":"SUM(E63:E64)","v":0},{"$f":"SUM(F63:F64)","v":0},0,0,0,0,0,0,0]
["AC",121,"Fees & Collections - Rpting Bd"]
["AC",122,"Fees & Collections - Affiliate"]
["AC",140,"Subtotal - Other Revenue",null,{"$f":"SUM(E66:E67)","v":0},0,0,0,0,0,0,0,0]
["AC",190,"TOTAL REVENUE",null,{"$f":"E65+E68","v":0},0,0,0,0,0,0,0,0]
["AC",200,"EXPENDITURE"]
["AC",201,"   Expenditure - SUD Services"]
["AC",290,"TOTAL EXPENDITURE",null,{"$f":"SUM(E71:E71)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(M71:M71)","v":0}]
["AC",295,"SUBTOTAL NET SUD SERVICES SURPLUS (DEFICIT)",null,{"$f":"+E69-E72","v":0},{"$f":"+F69-F72","v":0},{"$f":"+G69-G72","v":0},0,0,0,0,0,{"$f":"+M69-M72","v":0}]
["AC",300,"Redirected Funds (To) From"]
["AC",301,"(TO) CMHSP to CMHSP Earned Contracts - J304.2"]
["AC",302,"FROM CMHSP to CMHSP Earned Contracts - J301.2"]
["AC",303,"FROM Non-MDHHS Earned Contracts - K301.2"]
["AC",315,"FROM Restricted Fund Balance - RES 1.d"]
["AC",325,"Info only - Affiliate Total Redirected Funds - IA390"]
["AC",330,"Subtotal Redirected Funds rows 301 - 325",null,{"$f":"SUBTOTAL(9,E74:E79)","v":0},{"$f":"SUBTOTAL(9,F74:F79)","v":0},0,0,0,0,0,0,0]
["AC",331,"FROM General Funds - Redirected to Unfunded SUD Costs - B301.2"]
["AC",332,"FROM Local Funds - M301.2"]
["AC",335,"FROM Restricted Fund Balance - Risk Financing RES 1.d"]
["AC",390,"Total Redirected Funds",null,{"$f":"(SUBTOTAL(9,E74:E83))","v":0},{"$f":"(SUBTOTAL(9,F76:F83))","v":0},0,0,0,0,0,0,0]
["AC",400,"BALANCE SUD Services",null,{"$f":"+E73+E84","v":0},0,0,0,0,0,0,0,0]

{"sheet":"SUD - Supplemental","index":9,"n_rows":65,"n_cols":15,"rows_kept":65,"cut":false,"hidden":true,"merged":[[0,0,0,14],[1,0,1,14],[49,12,49,13],[54,12,54,13],[55,12,55,13],[6,0,6,4],[8,3,8,12],[3,2,3,5],[4,0,4,4],[5,0,5,4],[50,12,50,13],[51,12,51,13],[50,9,50,10],[51,9,51,10],[52,9,52,10],[53,9,53,10],[64,6,64,7],[3,0,3,1],[48,1,48,14],[47,1,47,14],[52,12,52,13],[53,12,53,13],[56,12,56,13],[57,12,57,13],[63,12,63,13],[64,12,64,13],[58,12,58,13],[61,12,61,13],[62,12,62,13],[59,12,59,13],[60,12,60,13],[49,9,49,10],[54,9,54,10],[55,9,55,10],[56,9,56,10],[57,9,57,10],[58,9,58,10],[63,6,63,7],[59,9,59,10],[60,9,60,10],[61,9,61,10],[62,9,62,10],[63,9,63,10],[64,9,64,10],[49,1,64,5],[49,6,49,7],[50,6,50,7],[51,6,51,7],[52,6,52,7],[53,6,53,7],[54,6,54,7],[55,6,55,7],[56,6,56,7],[57,6,57,7],[58,6,58,7],[59,6,59,7],[60,6,60,7],[61,6,61,7],[62,6,62,7]]}
["MDHHS/PIHP MEDICAID MANAGED SPECIALTY SUPPORTS AND SERVICES CONCURRENT WAIVER PROGRAMS CONTRACT"]
["SUPPLEMENTAL FINANCIAL STATUS REPORT -  SUD SERVICES"]
[]
["PIHP:",null,{"$f":"'FSR - Medicaid'!C4","v":0}]
["FISCAL YEAR: ",null,null,null,null,{"$f":"'FSR - Medicaid'!D5","v":"SELECT"}]
["SUBMISSION TYPE: ",null,null,null,null,{"$f":"'FSR - Medicaid'!D6","v":"SELECT"}]
["SUBMISSION DATE: ",null,null,null,null,{"$f":"'FSR - Medicaid'!D7","v":"00:00:00"}]
[]
[null,null,null,"EXPENDITURES"]
[null,"Fund Source","Budgeted Revenue","General Admin","Access Mgt Sys","Treatment","Womens Specialty","Prevention","PFS 2015-2020","State Targeted Response (STR) \nGY1: 10/1/18-4/30/19","State Targeted Response (STR) \nGY 2: 5/1/19-9/30/19","Gambling Disorder Prevention","Other (DHHS Approval Required)","Total","Balance"]
["A","State Agreement ","A.","B.","C.","D.","E.","F.","G.","H.","I.","J.","K.","L.","M."]
[1,"Community Grant",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D12:M12)","v":0},{"$f":"C12-N12","v":0}]
["1.a","     - General Admin",null,null,null,null,null,null,null,null,null,null,null,0,0]
["1.b","     - Access Management System",null,null,null,null,null,null,null,null,null,null,null,0,0]
["1.c","     - Treatment",null,null,null,null,null,null,null,null,null,null,null,0,0]
["1.d","     - Women's Specialty Services (WSS)",null,null,null,null,null,null,null,null,null,null,null,0,0]
["1.e","     - Other (DHHS Approval required)",null,null,null,null,null,null,null,null,null,null,null,0,0]
["1.f","Subtotal - Community Grant",{"$f":"SUM(C12:C17)","v":0},{"$f":"SUM(D12:D17)","v":0},0,0,0,0,0,0,{"$f":"SUM(K12:K17)","v":0},0,0,{"$f":"SUM(N12:N17)","v":0},{"$f":"SUM(O12:O17)","v":0}]
[2,"Prevention",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D19:M19)","v":0},{"$f":"C19-N19","v":0}]
[3,"State Disability Assistance",null,null,null,null,null,null,null,null,null,null,null,0,0]
[4,"Partnership For Success (2015-2020)",null,null,null,null,null,null,null,null,null,null,null,0,0]
[5,"State Targeted Response",null,null,null,null,null,null,null,null,null,null,null,0,0]
[6,"Gambling Disorder Prevention",null,null,null,null,null,null,null,null,null,null,null,0,0]
[7,"Intentionally left blank",null,null,null,null,null,null,null,null,null,null,null,0,0]
[8,"Subtotal - State Agreement",{"$f":"C18+C19+C20+C21+C22+C23+C24","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(N18:N24)","v":0},{"$f":"SUM(O18:O24)","v":0}]
["B","Medicaid"]
[1,"Medicaid",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D27:M27)","v":0},{"$f":"C27-N27","v":0}]
[2,"Healthy MI Plan",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D28:M28)","v":0},{"$f":"C28-N28","v":0}]
[3,"Medicaid- Savings / ISF",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D29:M29)","v":0},{"$f":"C29-N29","v":0}]
[4,"Healthy MI Plan - Savings / ISF",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D30:M30)","v":0},{"$f":"C30-N30","v":0}]
[5,"Subtotal - Medicaid",{"$f":"SUM(C27:C30)","v":0},{"$f":"SUM(D27:D30)","v":0},0,0,0,0,0,0,{"$f":"SUM(K27:K30)","v":0},0,0,{"$f":"SUM(N27:N30)","v":0},{"$f":"SUM(O27:O30)","v":0}]
["C","MI Health Link (Medicare)"]
[1,"MI Health Link (Medicare)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D33:M33)","v":0},{"$f":"C33-N33","v":0}]
[2,"Subtotal - Medicare",{"$f":"SUM(C33)","v":0},{"$f":"SUM(D33)","v":0},0,0,0,0,0,0,{"$f":"SUM(K33)","v":0},0,0,{"$f":"SUM(N33)","v":0},{"$f":"SUM(O33)","v":0}]
["D","Local & Other"]
[1,"Restricted Fund Balance",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D36:M36)","v":0},{"$f":"C36-N36","v":0}]
[2,"Fees & Collections",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D37:M37)","v":0},{"$f":"C37-N37","v":0}]
[3,"Other Contracts & Sources",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D38:M38)","v":0},{"$f":"C38-N38","v":0}]
[4,"Other Local",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D39:M39)","v":0},{"$f":"C39-N39","v":0}]
[5,"Subtotal - Local & Other",{"$f":"SUM(C36:C39)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(K36:K39)","v":0},0,0,0,0]
[]
["E","Grand Total",{"$f":"C25+C31+C34+C40","v":0},{"$f":"D25+D31+D34+D40","v":0},0,0,0,0,0,0,{"$f":"K25+K31+K34+K40","v":0},0,0,0,0]
[]
["F","Local Match Computation","Funds Subject to Match",null,null,null,null,null,null,null,null,null,null,"Total Match Funds (Local & Other - D1+D2+D4)","Match Percentage"]
[null,null,{"$f":"SUM(D45:M45)","v":0},{"$f":"SUM(+D25+D36+D37+D39)","v":0},0,0,0,0,0,0,{"$f":"SUM(+K25+K36+K37+K39)","v":0},0,0,{"$f":"N36+N37+N39","v":0},{"$f":"N45/C45","v":{"$error":"#DIV/0!"}}]
[]
[]
["G","REMARKS"]
["G","Remarks may be added about any entry or activity on the report for which additional information may be useful."]
["G",null,null,null,null,null,"Expenditure Category Detail",null,"Amount","Expenditure Category Detail",null,"Amount","Expenditure Category Detail",null,"Amount"]
["G"]
["G"]
["G"]
["G"]
["G"]
["G"]
["G"]
["G"]
["G"]
["G"]
["G"]
["G"]
["G"]
["G"]
["G",null,null,null,null,null,"Total",null,{"$f":"SUM(I51:I64)","v":0},"Total",null,{"$f":"SUM(L51:L64)","v":0},"Total",null,{"$f":"SUM(O51:O64)","v":0}]

{"sheet":"Res Fund Bal","index":10,"n_rows":133,"n_cols":9,"rows_kept":133,"cut":false,"hidden":true,"merged":[[14,2,14,3],[16,2,16,3],[15,2,15,3],[0,0,0,8],[1,0,1,8],[11,2,11,3],[12,2,12,3],[13,2,13,3],[10,2,10,3],[3,3,3,6],[3,0,3,2],[4,0,4,2],[5,0,5,2],[6,0,6,2],[20,4,20,5],[20,6,20,7],[17,2,17,3],[18,2,18,3],[19,2,19,3],[20,2,20,3]]}
["MDHHS/PIHP MEDICAID MANAGED SPECIALTY SUPPORTS AND SERVICES CONCURRENT WAIVER PROGRAMS CONTRACT"]
["RESTRICTED FUND BALANCE ACTIVITY"]
[]
["PIHP:     ",null,null,{"$f":"'FSR - Medicaid'!C4","v":0}]
["FISCAL YEAR:     ",null,null,{"$f":"'FSR - Medicaid'!D5","v":"SELECT"}]
["SUBMISSION TYPE:     ",null,null,{"$f":"'FSR - Medicaid'!D6","v":"SELECT"}]
["SUBMISSION DATE:     ",null,null,{"$f":"'FSR - Medicaid'!D7","v":"00:00:00"}]
[]
[]
[]
[null,"1.","Restricted Fund Balance Activity",null,"PA2","PA2 - (Risk Financing)","Performance Bonus Incentive Pool (PBIP)","Performance Bonus Incentive Pool (PBIP) - (Risk Financing)","Restricted Fund Balances / Current Activity"]
[null,"a.","Restricted Fund Balance @ Beginning of Fiscal Year",null,null,null,null,null,{"$f":"SUM(E12:H12)","v":0}]
[null,"b.","Current Period Deposits",null,null,null,null,null,{"$f":"SUM(E13:H13)","v":0}]
[null,"c.","Current Period Financing Medicaid",null,null,null,null,null,0]
[null,"d.","Current Period Financing SUD Non-Medicaid",null,null,null,null,null,0]
[null,"e.","Current Period Financing Opioid Health Homes Behavioral Health",null,null,null,null,null,0]
[null,"f.","Current Period Financing Health Homes Behavioral Health",null,null,null,null,null,0]
[null,"g.","Current Period Financing Healthy MI Plan",null,null,null,null,null,0]
[null,"h.","Current Period Financing MI Health Link",null,null,null,null,null,0]
[null,"i.","Current Period Financing Behavioral Health System",null,null,null,null,null,0]
[null,"j.","Restricted Fund Ending Balance",null,{"$f":"SUM(E12:F20)","v":0},null,{"$f":"SUM(G12:H20)","v":0},null,{"$f":"SUM(E21:H21)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"MDHHS original"]

{"sheet":"Medicaid ISF Report","index":11,"n_rows":168,"n_cols":10,"rows_kept":168,"cut":false,"hidden":true,"merged":[[39,4,39,7],[40,4,42,7],[20,2,20,8],[26,2,26,8],[27,2,27,8],[28,2,28,8],[29,2,29,8],[30,2,30,8],[21,2,21,8],[22,2,22,8],[23,2,23,8],[24,2,24,8],[25,2,25,8],[0,0,0,9],[1,0,1,9],[3,0,3,4],[6,0,6,4],[5,0,5,4],[4,0,4,4],[3,5,3,8]]}
["MDHHS/PIHP MEDICAID MANAGED SPECIALTY SUPPORTS AND SERVICES CONCURRENT WAIVER PROGRAMS CONTRACT"]
["INTERNAL SERVICE FUND"]
[]
["PIHP:     ",null,null,null,null,{"$f":"'FSR - Medicaid'!C4","v":0}]
["FISCAL YEAR:     ",null,null,null,null,{"$f":"'FSR - Medicaid'!D5","v":"SELECT"}]
["SUBMISSION TYPE:     ",null,null,null,null,{"$f":"'FSR - Medicaid'!D6","v":"SELECT"}]
["SUBMISSION DATE:     ",null,null,null,null,{"$f":"'FSR - Medicaid'!D7","v":"00:00:00"}]
[]
[]
[]
[]
[null,null,null,null,"Current Period","Current Period"]
[null,null,null,"ISF Balance","ISF","ISF","Current Period","Current Period","Current Period"]
[null,null,null,"@ Beginning","Contributions","Contributions","ISF Reduction","ISF Financing","ISF Financing","ISF Ending"]
["1.","Internal Service Fund Fiscal Year Activity",null,"of Fiscal Year","Interest Earned","Deposits","(Abatement)","Medicaid (Risk)","HMP (Risk)","Balance"]
[null,"a.","ISF Balances / Current Activity",{"$f":"+$D$17+$D$18","v":0},{"$f":"+$E$17+$E$18","v":0},{"$f":"+$F$17+$F$18","v":0},{"$f":"+$G$17+$G$18","v":0},{"$f":"+$H$17+$H$18","v":0},{"$f":"+$I$17+$I$18","v":0},{"$f":"+$D$16+$E$16+$F$16+$G$16+$H$16+$I$16","v":0}]
[null,"b.","Specialty Managed Care",null,null,{"$f":"+'FSR - Medicaid'!M24","v":0},{"$f":"-'FSR - Medicaid'!M18","v":0},null,null,{"$f":"+$D$17+$E$17+$F$17+$G$17+$H$17+$I$17","v":0}]
[null,"c.","Healthy Michigan Plan",null,null,{"$f":"+'FSR - Healthy Michigan'!M24","v":0},{"$f":"-'FSR - Healthy Michigan'!M18","v":0},null,null,{"$f":"+$D$18+$E$18+$F$18+$G$18+$H$18+$I$18","v":0}]
[]
[]
[1.1000000000000001,null,"PIHP Transferred To/From ISF balances",null,null,null,null,null,null,"Total Transferred"]
[null,"a."]
[null,"b."]
[null,"c."]
[null,"d."]
[null,"e."]
[null,"f.","Total Transferred to/from PIHPs",null,null,null,null,null,null,{"$f":"SUM(J22:J26)","v":0}]
[null,"g.","Final balance after transfers",null,null,null,null,null,null,{"$f":"+J16+J27","v":0}]
[]
[null,"h.","Specialty Managed Care portion of balance",null,null,null,null,null,null,{"$f":"J28-J31","v":0}]
[null,"i.","Healthy Michigan Plan portion of balance",null,null,null,null,null,null,{"$f":"+J18","v":0}]
[]
[]
["2.","PIHP Maximum Allowable Funding of ISF",null,"Amount"]
[null,"a.","Specialty Managed Care - Medicaid Capitation (FSR Medicaid - A 120 + FSR HMP - AI 120 + Medicaid Worksheet - 1.i  PBIP Withhold)",{"$f":"+'Medicaid Shared Risk Calc'!E13+'Medicaid Shared Risk Calc'!F13+'Medicaid Shared Risk Calc'!G13","v":0}]
[null,"b.","% of Current Year Medicaid Capitation",7.4999999999999997E-2]
[null,"c.","Maximum Allowable Funding of Med ISF",{"$f":"ROUND($D$35*$D$36,0)","v":0}]
[]
[]
["3.","Disposition of ISF Ending Balance",null,"Amount","   Narrative of Resolution if ISF Over Funded"]
[null,"a.","Maximum Allowable Funding of Medicaid ISF",{"$f":"+$D$37","v":0}]
[null,"b.","Medicaid ISF Ending Balance",{"$f":"+J28","v":0}]
[null,"c.","Within Maximum Allowable Limit  /  (Overfunded) ",{"$f":"+$D$41-$D$42","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"MDHHS original"]

{"sheet":"Medicaid Shared Risk Calc","index":12,"n_rows":44,"n_cols":10,"rows_kept":44,"cut":false,"hidden":true,"merged":[[31,2,31,6],[30,2,30,6],[35,2,35,6],[34,2,34,6],[0,0,0,9],[1,0,1,9],[12,2,12,3],[3,0,3,4],[4,0,4,4],[5,0,5,4],[6,0,6,4],[3,5,3,7],[18,2,18,5],[40,2,40,6],[41,2,41,6],[42,2,42,6],[43,2,43,6],[32,2,32,6],[33,2,33,6]]}
["MDHHS/PIHP MEDICAID MANAGED SPECIALTY SUPPORTS AND SERVICES CONCURRENT WAIVER PROGRAM CONTRACT"]
["SHARED RISK CALCULATION & RISK FINANCING"]
[]
["PIHP:     ",null,null,null,null,{"$f":"+'FSR - Medicaid'!C4","v":0}]
["FISCAL YEAR:     ",null,null,null,null,{"$f":"+'FSR - Medicaid'!D5","v":"SELECT"}]
["SUBMISSION TYPE:     ",null,null,null,null,{"$f":"+'FSR - Medicaid'!D6","v":"SELECT"}]
["SUBMISSION DATE:     ",null,null,null,null,{"$f":"+'FSR - Medicaid'!D7","v":"00:00:00"}]
[]
[]
[]
[]
["1.","Shared Risk Calculation",null,null,"Medicaid Amount","HMP Amount","PBIP Amount","Total Amount"]
[null,"a1.","Specialty Managed Care - Medicaid Capitation (FSR Medicaid - A 120 + FSR HMP - AI 120 + Medicaid Worksheet - 1.i  PBIP Withhold)",null,{"$f":"+'FSR - Medicaid'!M14","v":0},{"$f":"'FSR - Healthy Michigan'!M14","v":0},{"$f":"+'Medicaid Worksheet'!H22","v":0},{"$f":"+E13+F13+G13","v":0}]
[]
[null,"a2.","Band # 1  (100 - 105%)",0.05,null,null,{"$f":"ROUND(H13*5%,0)","v":0},"Full PIHP Responsibility"]
[null,"a3.","Band # 2  (105 - 110%)",0.05,null,null,{"$f":"ROUND(H13*5%,0)","v":0},"Shared  State / PIHP Responsibility"]
[]
[]
[null,"b.","Total Risk",null,null,null,{"$f":"IF(SUM('FSR - Medicaid'!M28+'FSR - Healthy Michigan'!M27)<0,SUM(-'FSR - Medicaid'!M28-'FSR - Medicaid'!M39,-'FSR - Healthy Michigan'!M27-'FSR - Healthy Michigan'!M36),0)","v":0}]
[]
[null,null,null,null,null,null,null,"State Risk ","Local Risk","Total Risk Corridor"]
[null,"c1.","Band # 1 Liability",null,null,null,{"$f":"IF($G$19<=$G$15,$G$19,$G$15)","v":0},null,{"$f":"+$G$22","v":0},{"$f":"SUM($H$22:$I$22)","v":0}]
[null,"c2.","Sub-Total - Band # 1",null,null,null,{"$f":"+$G$19-$G$22","v":0}]
[null,"c3.","Band # 2 Liability",null,null,null,{"$f":"IF($G$23<$G$16,$G$23,$G$16)","v":0},{"$f":"ROUND($G$24*50%,0)","v":0},{"$f":"$G$24-$H$24","v":0},{"$f":"SUM($H$24:$I$24)","v":0}]
[null,"c4.","Sub-Total - Band # 2",null,null,null,{"$f":"+$G$23-$G$24","v":0}]
[null,"c5.","Band # 3 Liability",null,null,null,{"$f":"+$G$25","v":0},{"$f":"+$G$26","v":0},null,{"$f":"SUM($H$26:$I$26)","v":0}]
[null,"c6.",null,null,null,null,"Total Risk Responsibility ",{"$f":"SUM($H$19:$H$26)","v":0},{"$f":"SUM($I$19:$I$26)","v":0},{"$f":"+$I$27+$H$27","v":0}]
[]
[]
["2.","Disposition of Risk ",null,null,null,null,null,"State Risk ","Local Risk","Total Risk Corridor"]
[null,"a.","Stop/Loss Insurance (FSR - Non-Medicaid Line N 101)",null,null,null,null,null,{"$f":"+'FSR - All Non Medicaid'!E406","v":0},{"$f":"SUM($H$31:$I$31)","v":0}]
[null,"b.","Medicaid / HMP for PIHP Share Risk Corridor (FSR - Non-Medicaid Line N 102)",null,null,null,null,null,{"$f":"+'FSR - All Non Medicaid'!E407","v":0},{"$f":"SUM($H$32:$I$32)","v":0}]
[null,"c.","Local Funds / Local Fund Balance - Medicaid / HMP Services (FSR - Non-Medicaid Line M 301, M 301.1)",null,null,null,null,null,{"$f":"-'FSR - All Non Medicaid'!E377-'FSR - All Non Medicaid'!E378","v":0},{"$f":"SUM($H$33:$I$33)","v":0}]
[null,"d.","Restricted Funds / Restricted Fund Balance - Medicaid / HMP Services (FSR - Non-Medicaid Line N 104)",null,null,null,null,null,{"$f":"+'FSR - All Non Medicaid'!E409","v":0},{"$f":"SUM($H$34:$I$34)","v":0}]
[null,"e.","General Fund Redirect for Unfunded Medicaid / HMP Costs - MDHHS Approved ONLY (FSR - Non-Medicaid Line B 301, B301.1)",null,null,null,null,null,{"$f":"-'FSR - All Non Medicaid'!E78-'FSR - All Non Medicaid'!E79","v":0},{"$f":"SUM($H$35:$I$35)","v":0}]
[null,"f.","Due PIHP From MDHHS (FSR - Non-Medicaid Line N 103)",null,null,null,null,{"$f":"+'FSR - All Non Medicaid'!E408","v":0},null,{"$f":"SUM($H$36:$I$36)","v":0}]
[null,"g.",null,null,null,null,"Total Risk Corridor Funding ",{"$f":"SUM($H$31:$H$36)","v":0},{"$f":"SUM($I$31:$I$36)","v":0},{"$f":"SUM($J$31:$J$36)","v":0}]
[]
[]
["3.","Summary of Total Risk / Funding ",null,null,null,null,null,"State Risk ","Local Risk","Total Risk Corridor"]
[null,"a.","Total Risk ",null,null,null,null,{"$f":"+$H$27","v":0},{"$f":"+$I$27","v":0},{"$f":"+$J$27","v":0}]
[null,"b.","Total Disposition of MDHHS / Local Risk - Medicaid",null,null,null,null,null,null,{"$f":"+$H42+$I$42","v":0}]
[null,"b1.","Total Disposition of MDHHS / Local Risk - Healthy Michigan Plan",null,null,null,null,null,null,{"$f":"+$H$43+$I$43","v":0}]
[null,"c.","Balance of Risk Corridor (Must = $0)",null,null,null,null,{"$f":"+$H$41-$H$42-$H$43","v":0},{"$f":"+$I$41-$I$42-$I$43","v":0},{"$f":"+$J$41-$J$42-J$43","v":0}]

{"sheet":"FSR - All Non Medicaid","index":13,"n_rows":458,"n_cols":5,"rows_kept":458,"cut":false,"hidden":true,"merged":[[145,2,145,3],[171,2,171,3],[146,2,146,3],[169,2,169,3],[168,2,168,3],[170,2,170,3],[153,2,153,3],[166,2,166,3],[162,2,162,3],[154,2,154,3],[160,2,160,3],[156,2,156,3],[158,2,158,3],[157,2,157,3],[155,2,155,3],[159,2,159,3],[164,2,164,3],[165,2,165,3],[167,2,167,3],[161,2,161,3],[447,2,447,4],[438,2,438,3],[423,2,423,3],[409,2,409,3],[446,2,446,4],[427,2,427,3],[172,2,172,3],[176,2,176,3],[178,2,178,3],[201,2,201,3],[177,2,177,3],[220,2,220,3],[238,2,238,3],[266,2,266,3],[269,2,269,3],[270,2,270,3],[292,2,292,3],[240,2,240,3],[258,2,258,3],[271,2,271,3],[259,2,259,3],[272,2,272,3],[273,2,273,3],[274,2,274,3],[448,2,457,4],[418,2,418,3],[397,2,397,3],[400,2,400,3],[399,2,399,3],[394,2,394,3],[383,2,383,3],[384,2,384,3],[387,2,387,3],[425,2,425,3],[426,2,426,3],[389,2,389,3],[445,2,445,3],[440,2,440,3],[441,2,441,3],[414,2,414,3],[437,2,437,3],[444,2,444,3],[443,2,443,3],[432,2,432,3],[433,2,433,3],[442,2,442,3],[385,2,385,3],[391,2,391,3],[439,2,439,3],[436,2,436,3],[420,2,420,3],[417,2,417,3],[368,2,368,3],[355,2,355,3],[358,2,358,3],[424,2,424,3],[429,2,429,3],[435,2,435,3],[431,2,431,3],[374,2,374,3],[382,2,382,3],[422,2,422,3],[363,2,363,3],[364,2,364,3],[360,2,360,3],[367,2,367,3],[361,2,361,3],[362,2,362,3],[411,2,411,3],[381,2,381,3],[388,2,388,3],[412,2,412,3],[309,2,309,3],[337,2,337,3],[377,2,377,3],[340,2,340,3],[307,2,307,3],[325,2,325,3],[378,2,378,3],[354,2,354,3],[434,2,434,3],[419,2,419,3],[415,2,415,3],[386,2,386,3],[310,2,310,3],[352,2,352,3],[347,2,347,3],[318,2,318,3],[313,2,313,3],[315,2,315,3],[311,2,311,3],[338,2,338,3],[335,2,335,3],[336,2,336,3],[413,2,413,3],[416,2,416,3],[430,2,430,3],[407,2,407,3],[428,2,428,3],[401,2,401,3],[410,2,410,3],[403,2,403,3],[396,2,396,3],[408,2,408,3],[402,2,402,3],[314,2,314,3],[326,2,326,3],[328,2,328,3],[316,2,316,3],[323,2,323,3],[317,2,317,3],[327,2,327,3],[322,2,322,3],[370,2,370,3],[359,2,359,3],[334,2,334,3],[341,2,341,3],[346,2,346,3],[351,2,351,3],[349,2,349,3],[353,2,353,3],[356,2,356,3],[332,2,332,3],[320,2,320,3],[343,2,343,3],[344,2,344,3],[350,2,350,3],[339,2,339,3],[321,2,321,3],[345,2,345,3],[324,2,324,3],[342,2,342,3],[333,2,333,3],[319,2,319,3],[392,2,392,3],[398,2,398,3],[404,2,404,3],[406,2,406,3],[380,2,380,3],[331,2,331,3],[329,2,329,3],[405,2,405,3],[393,2,393,3],[357,2,357,3],[366,2,366,3],[390,2,390,3],[371,2,371,3],[369,2,369,3],[373,2,373,3],[372,2,372,3],[376,2,376,3],[379,2,379,3],[375,2,375,3],[216,2,216,3],[217,2,217,3],[228,2,228,3],[230,2,230,3],[194,2,194,3],[205,2,205,3],[200,2,200,3],[192,2,192,3],[209,2,209,3],[193,2,193,3],[206,2,206,3],[181,2,181,3],[229,2,229,3],[224,2,224,3],[222,2,222,3],[182,2,182,3],[197,2,197,3],[202,2,202,3],[219,2,219,3],[203,2,203,3],[210,2,210,3],[221,2,221,3],[218,2,218,3],[195,2,195,3],[196,2,196,3],[213,2,213,3],[212,2,212,3],[188,2,188,3],[198,2,198,3],[184,2,184,3],[185,2,185,3],[211,2,211,3],[191,2,191,3],[187,2,187,3],[189,2,189,3],[174,0,174,3],[180,2,180,3],[308,2,308,3],[298,2,298,3],[290,2,290,3],[289,2,289,3],[304,2,304,3],[299,2,299,3],[263,2,263,3],[243,2,243,3],[244,2,244,3],[279,2,279,3],[246,2,246,3],[287,2,287,3],[288,2,288,3],[301,2,301,3],[295,2,295,3],[250,2,250,3],[264,2,264,3],[256,2,256,3],[257,2,257,3],[267,2,267,3],[268,2,268,3],[252,2,252,3],[262,2,262,3],[253,2,253,3],[251,2,251,3],[223,2,223,3],[226,2,226,3],[275,2,275,3],[237,2,237,3],[247,2,247,3],[231,2,231,3],[249,2,249,3],[234,2,234,3],[239,2,239,3],[242,2,242,3],[232,2,232,3],[233,2,233,3],[248,2,248,3],[260,2,260,3],[261,2,261,3],[235,2,235,3],[236,2,236,3],[0,0,0,4],[1,0,1,4],[3,4,4,4],[18,2,18,3],[19,2,19,3],[4,0,4,2],[5,2,5,3],[3,0,3,2],[2,0,2,1],[14,2,14,3],[15,2,15,3],[16,2,16,3],[17,2,17,3],[115,2,115,3],[116,2,116,3],[306,2,306,3],[297,2,297,3],[296,2,296,3],[300,2,300,3],[278,2,278,3],[286,2,286,3],[282,2,282,3],[283,2,283,3],[284,2,284,3],[294,2,294,3],[303,2,303,3],[291,2,291,3],[305,2,305,3],[293,2,293,3],[302,2,302,3],[280,2,280,3],[281,2,281,3],[276,2,276,3],[277,2,277,3],[254,2,254,3],[227,2,227,3],[241,2,241,3],[129,2,129,3],[134,2,134,3],[190,2,190,3],[183,2,183,3],[207,2,207,3],[179,2,179,3],[215,2,215,3],[108,2,108,3],[142,2,142,3],[136,2,136,3],[148,2,148,3],[151,2,151,3],[147,2,147,3],[138,2,138,3],[139,2,139,3],[144,2,144,3],[150,2,150,3],[143,2,143,3],[149,2,149,3],[121,2,121,3],[112,2,112,3],[111,2,111,3],[113,2,113,3],[117,2,117,3],[21,2,21,3],[66,2,66,3],[61,2,61,3],[28,2,28,3],[29,2,29,3],[30,2,30,3],[33,2,33,3],[60,2,60,3],[59,2,59,3],[58,2,58,3],[56,2,56,3],[63,2,63,3],[62,2,62,3],[64,2,64,3],[65,2,65,3],[31,2,31,3],[32,2,32,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[26,2,26,3],[34,0,34,4],[43,2,43,3],[44,2,44,3],[52,2,52,3],[53,2,53,3],[54,2,54,3],[70,2,70,3],[100,2,100,3],[83,2,83,3],[96,2,96,3],[89,2,89,3],[86,2,86,3],[94,2,94,3],[84,2,84,3],[87,2,87,3],[73,2,73,3],[93,2,93,3],[99,2,99,3],[78,2,78,3],[90,2,90,3],[91,2,91,3],[57,2,57,3],[98,2,98,3],[76,2,76,3],[85,2,85,3],[67,2,67,3],[68,2,68,3],[45,2,45,3],[46,2,46,3],[47,2,47,3],[36,2,36,3],[37,2,37,3],[38,2,38,3],[39,2,39,3],[40,2,40,3],[51,2,51,3],[50,2,50,3],[107,2,107,3],[106,2,106,3],[75,2,75,3],[81,2,81,3],[72,2,72,3],[82,2,82,3],[79,2,79,3],[88,2,88,3],[77,2,77,3],[92,2,92,3],[102,2,102,3],[104,0,104,3],[80,2,80,3],[101,2,101,3],[69,2,69,3],[74,2,74,3],[95,2,95,3],[97,2,97,3],[186,2,186,3],[199,2,199,3],[109,2,109,3],[110,2,110,3],[135,2,135,3],[126,2,126,3],[122,2,122,3],[119,0,119,3],[114,2,114,3],[123,2,123,3],[124,2,124,3],[127,2,127,3],[131,2,131,3],[141,2,141,3],[140,2,140,3],[137,2,137,3],[133,2,133,3],[125,2,125,3],[130,2,130,3],[128,2,128,3]]}
["MDHHS/CMHSP MANAGED MENTAL HEALTH SUPPORTS AND SERVICES CONTRACT (GF)"]
["FINANCIAL STATUS REPORT - ALL NON MEDICAID"]
["CMHSP:",null,null,"FISCAL YEAR:","SELECT"]
["SUBMISSION TYPE: ",null,null,"SELECT","YEAR TO DATE REPORTING"]
["SUBMISSION DATE: "]
[null,null,"Column A",null,"Column B"]
[]
["A",null,"MEDICAID SERVICES - Summary From FSR - Medicaid"]
["A",190,"TOTAL REVENUE",null,{"$f":"+'FSR - Medicaid'!M$20-'FSR - Medicaid'!M$16","v":0}]
["A",290,"TOTAL EXPENDITURE",null,{"$f":"+'FSR - Medicaid'!M$27-'FSR - Medicaid'!M$16-'FSR - Medicaid'!M38","v":0}]
["A",295,"NET MEDICAID SERVICES SURPLUS (DEFICIT)",null,{"$f":"+'FSR - Medicaid'!M$28+'FSR - Medicaid'!M38","v":0}]
["A",390,"Total Redirected Funds",null,{"$f":"+'FSR - Medicaid'!M$45-'FSR - Medicaid'!M38","v":0}]
["A",400,"BALANCE MEDICAID SERVICES",null,{"$f":"+'FSR - Medicaid'!M$46","v":0}]
[]
["AC",null,"SUD NON-MEDICAID SERVICES - Summary From FSR - SUD"]
["AC",190,"TOTAL REVENUE",null,{"$f":"+'FSR - SUD'!M18-'FSR - SUD'!M16","v":0}]
["AC",290,"TOTAL EXPENDITURE",null,{"$f":"+'FSR - SUD'!M21-'FSR - SUD'!M28-'FSR - SUD'!M16","v":0}]
["AC",295,"NET SUD NON-MEDICAID SERVICES SURPLUS (DEFICIT)",null,{"$f":"+'FSR - SUD'!M22+'FSR - SUD'!M28","v":0}]
["AC",390,"Total Redirected Funds",null,{"$f":"+'FSR - SUD'!M33-'FSR - SUD'!M28","v":0}]
["AC",400,"BALANCE SUD NON-MEDICAID SERVICES",null,{"$f":"+'FSR - SUD'!M34","v":0}]
[]
["AE",null,"OPIOID HEALTH HOME SERVICES - Summary From FSR - Opioid Health Home Services"]
["AE",190,"TOTAL REVENUE",null,{"$f":"+'FSR - Opioid Health Home BH'!M14","v":0}]
["AE",290,"TOTAL EXPENDITURE",null,{"$f":"+'FSR - Opioid Health Home BH'!M19-'FSR - Opioid Health Home BH'!M23","v":0}]
["AE",295,"NET SURPLUS (DEFICIT)",null,{"$f":"+'FSR - Opioid Health Home BH'!M23+'FSR - Opioid Health Home BH'!M20","v":0}]
["AE",390," Total Redirected Funds",null,{"$f":"+'FSR - Opioid Health Home BH'!M28-'FSR - Opioid Health Home BH'!M23","v":0}]
["AE",400,"BALANCE OPIOID HEALTH HOME SERVICES",null,{"$f":"+'FSR - Opioid Health Home BH'!M29","v":0}]
[]
["AG",null,"HEALTH HOME SERVICES - Summary From FSR - Health Home Services"]
["AG",190,"TOTAL REVENUE",null,{"$f":"+'FSR - Health Homes BH'!M14","v":0}]
["AG",290,"TOTAL EXPENDITURE",null,{"$f":"+'FSR - Health Homes BH'!M19-'FSR - Health Homes BH'!M23","v":0}]
["AG",295,"NET HEALTH HOME SERVICES SURPLUS (DEFICIT)",null,{"$f":"+'FSR - Health Homes BH'!M23+'FSR - Health Homes BH'!M20","v":0}]
["AG",390,"Total Redirected Funds",null,{"$f":"+'FSR - Health Homes BH'!M28-'FSR - Health Homes BH'!M23","v":0}]
["AG",400,"BALANCE HEALTH HOME SERVICES",null,{"$f":"+'FSR - Health Homes BH'!M29","v":0}]
[]
["AI",null,"HEALTHY MICHIGAN SERVICES - Summary From FSR - Healthy Michigan"]
["AI",190,"TOTAL REVENUE",null,{"$f":"+'FSR - Healthy Michigan'!M20-'FSR - Healthy Michigan'!M16","v":0}]
["AI",290,"TOTAL EXPENDITURE",null,{"$f":"+'FSR - Healthy Michigan'!M26-'FSR - Healthy Michigan'!M16-'FSR - Healthy Michigan'!M35","v":0}]
["AI",295,"NET HEALTHY MICHIGAN SERVICES SURPLUS (DEFICIT)",null,{"$f":"+'FSR - Healthy Michigan'!M27+'FSR - Healthy Michigan'!M35","v":0}]
["AI",390,"Total Redirected Funds",null,{"$f":"+'FSR - Healthy Michigan'!M42-'FSR - Healthy Michigan'!M35","v":0}]
["AI",400,"BALANCE HEALTHY MICHIGAN SERVICES",null,{"$f":"+'FSR - Healthy Michigan'!M43","v":0}]
[]
["AK",null,"MI HEALTH LINK SERVICES - Summary From FSR - MI Health Link"]
["AK",190,"TOTAL REVENUE",null,{"$f":"+'FSR - MI Health Link'!M19-'FSR - MI Health Link'!M17","v":0}]
["AK",290,"TOTAL EXPENDITURE",null,{"$f":"+'FSR - MI Health Link'!M22-'FSR - MI Health Link'!M17-'FSR - MI Health Link'!M30","v":0}]
["AK",295,"NET MI HEALTH LINK SERVICES SURPLUS (DEFICIT)",null,{"$f":"+'FSR - MI Health Link'!M23+'FSR - MI Health Link'!M30","v":0}]
["AK",390,"Total Redirected Funds",null,{"$f":"+'FSR - MI Health Link'!M38-'FSR - MI Health Link'!M30","v":0}]
["AK",400,"BALANCE MI HEALTH LINK SERVICES",null,{"$f":"+'FSR - MI Health Link'!M39","v":0}]
[]
["RES",null,"RESTRICTED FUND BALANCE ACTIVITY"]
["RES",180,"Beginning Restricted Fund balance",null,{"$f":"+'Res Fund Bal'!I12","v":0}]
["RES",190,"TOTAL REVENUE (Deposits)",null,{"$f":"+'Res Fund Bal'!I13","v":0}]
["RES",290,"TOTAL EXPENDITURE (PBIP only)",null,{"$f":"-'Res Fund Bal'!I20","v":0}]
["RES",390,"Total Redirected Funds",null,{"$f":"+SUM('Res Fund Bal'!I14:I19)","v":0}]
["RES",400,"BALANCE RESTRICTED FUND",null,{"$f":"+'Res Fund Bal'!I21","v":0}]
[]
["B",null,"GENERAL FUND"]
["B",100,"REVENUE"]
["B",101,"CMH Operations"]
["B",102,"Intentionally left blank"]
["B",103,"Intentionally left blank"]
["B",120,"Subtotal - Current Period General Fund Revenue  ",null,{"$f":"SUM(E58:E61)","v":0}]
["B",121,"1st & 3rd Party Collections (Not in Section 226a Funds) 100% Services"]
["B",122,"1st & 3rd Party Collections (Not in Section 226a Funds) 90% Services"]
["B",123,"Prior Year GF Carry Forward"]
["B",124,"Intentionally left blank"]
["B",140,"Subtotal - Other General Fund Revenue  ",null,{"$f":"SUM(E63:E66)","v":0}]
["B",190,"TOTAL REVENUE",null,{"$f":"+E62+E67","v":0}]
["B",200,"EXPENDITURE"]
["B",201,"100% MDHHS Matchable Services / Costs"]
["B",202,"100% MDHHS Matchable Services Based on CMHSP Local Match Cap",null,{"$f":"-E367","v":0}]
["B",203,"90% MDHHS Matchable Services / Costs",null,{"$f":"ROUND((+$D$72-$E$64)*0.9,0)+E64","v":0}]
["B",204,"Intentionally left blank"]
["B",205,"Intentionally left blank"]
["B",290,"TOTAL EXPENDITURE",null,{"$f":"SUM(E69:E74)","v":0}]
["B",295,"NET GENERAL FUND SURPLUS (DEFICIT)",null,{"$f":"+E68-E75","v":0}]
["B",300,"Redirected Funds (To) From"]
["B",301,"(TO) Medicaid - Redirected for Unfunded Medicaid Costs - A331   (PIHP use only)",null,{"$f":"-'FSR - Medicaid'!E40","v":0}]
["B",301.10000000000002,"(TO) Healthy Michigan - Redirected for Unfunded Healthy Michigan Costs - AI331   (PIHP use only)",null,{"$f":"-'FSR - Healthy Michigan'!E37","v":0}]
["B",301.2,"(TO) SUD Non-Medicaid - Redirected for Unfunded SUD Non-Medicaid Services AC331   (PIHP use only)",null,{"$f":"-'FSR - SUD'!E30","v":0}]
["B",301.3,"(TO) Opioid Health Home Services - Redirected for Unfunded Opioid Health Home Services AE331   (PIHP use only)",null,{"$f":"-'FSR - Opioid Health Home BH'!E25","v":0}]
["B",301.39999999999998,"(TO) Health Home Services - Redirected for Unfunded Health Home Services AG331   (PIHP use only)",null,{"$f":"-'FSR - Health Homes BH'!E25","v":0}]
["B",301.5,"(TO) MI Health Link - Redirected for Unfunded MI Health Link Costs - AK331   (PIHP use only)",null,{"$f":"-'FSR - MI Health Link'!E32","v":0}]
["B",303,"Intentionally left blank"]
["B",304,"(TO) Targeted Case Management - D301",null,{"$f":"-E127","v":0}]
["B",305,"(TO) GF Cost of SED - E301",null,{"$f":"-E147","v":0}]
["B",306,"(TO) GF Cost of SED - Not SED Waiver eligible - E303",null,{"$f":"-E149","v":0}]
["B",307,"Intentionally left blank"]
["B",308,"(TO) GF Cost of Children's Waiver - F301",null,{"$f":"-E159","v":0}]
["B",309,"(TO) Allowable GF Cost of Injectable Medications - G301",null,{"$f":"-E170","v":0}]
["B",310,"(TO) PIHP to Affiliate Medicaid Services Contracts - I304",null,{"$f":"-E222","v":0}]
["B",310.10000000000002,"(TO) PIHP to Affiliate SUD (Non-Medicaid) Services Contracts - IA304",null,{"$f":"-E241","v":0}]
["B",310.2,"(TO) PIHP to Affiliate Opioid Health Home Services Contracts - IB304",null,{"$f":"-E252","v":0}]
["B",310.3,"(TO) PIHP to Affiliate Health Home Services Contracts - IC304",null,{"$f":"-E262","v":0}]
["B",310.39999999999998,"(TO) PIHP to Affiliate MI Health Link Services Contracts - ID304",null,{"$f":"-E281","v":0}]
["B",312,"(TO) CMHSP to CMHSP Earned Contracts - J305   (explain - section Q)",null,{"$f":"-E306","v":0}]
["B",313,"FROM CMHSP to CMHSP Earned Contracts - J302"]
["B",314,"FROM Non-MDHHS Earned Contracts - K302"]
["B",330,"Subtotal Redirected Funds rows 301 - 314",null,{"$f":"SUBTOTAL(9,E77:E98)","v":0}]
["B",331,"FROM Local Funds - M302"]
["B",332,"FROM Risk Corridor - N303"]
["B",390,"Total Redirected Funds",null,{"$f":"(SUBTOTAL(9,E77:E101))","v":0}]
["B",400,"BALANCE GENERAL FUND     (cannot be < 0)",null,{"$f":"+E76+E102","v":0}]
[]
["OTHER GF CONTRACTUAL OBLIGATIONS"]
[]
["C",null,"INTENTIONALLY LEFT BLANK"]
["C",100,"Revenue "]
["C",170]
["C",180]
["C",190,"Total Revenue",null,{"$f":"SUM(E109:E110)","v":0}]
["C",290,"Expenditure"]
["C",295,"NET SURPLUS (DEFICIT)",null,{"$f":"+E111+-E112","v":0}]
["C",300,"Redirected Funds (To) From"]
["C",301]
["C",302]
["C",390,"Total Redirected Funds",null,{"$f":"SUM(E114:E116)","v":0}]
["C",400,"BALANCE  (cannot be < 0)",null,{"$f":"+E113+E117","v":0}]
[]
["FEE FOR SERVICE MEDICAID"]
[]
["D",null,"TARGETED CASE MANAGEMENT - (GHS Only)"]
["D",190,"Revenue"]
["D",290,"Expenditure"]
["D",295,"NET TARGETED CASE MANAGEMENT (cannot be > 0)",null,{"$f":"+E123-E124","v":0}]
["D",300,"Redirected Funds (To) From"]
["D",301,"FROM General Fund - B304"]
["D",302,"FROM Local Funds - M304"]
["D",303,"(TO) CMHSP to CMHSP Earned Contracts - J304.4",null,{"$f":"-E305","v":0}]
["D",304,"FROM CMHSP to CMHSP Earned Contracts - J303.4"]
["D",390,"Total Redirected Funds",null,{"$f":"SUM(E126:E130)","v":0}]
["D",400,"BALANCE TARGETED CASE MANAGEMENT (GHS Only) (must = 0)",null,{"$f":"+E125+E131","v":0}]
[]
["E",null,"SED WAIVER"]
["E",100,"REVENUE"]
["E",101,"FFS Medicaid - SED-Trad"]
["E",102,"FFS Medicaid - SED-DHS"]
["E",190,"TOTAL REVENUE",null,{"$f":"SUM(E135:E137)","v":0}]
["E",200,"EXPENDITURE"]
["E",201,"Expenditure - Traditional - Federal Reimbursable"]
["E",202,"Expenditure - Traditional - Not SED waiver eligible"]
["E",203,"Expenditure - SED-DHS - Federal Reimbursable"]
["E",204,"Expenditure - SED-DHS - Not SED waiver eligible"]
["E",290,"TOTAL EXPENDITURE",null,{"$f":"SUM(E139:E143)","v":0}]
["E",295,"NET SED WAIVER (DEFICIT) ",null,{"$f":"+E138-E144","v":0}]
["E",300,"Redirected Funds (To) From"]
["E",301,"FROM General Fund - B305                                       "]
["E",302,"FROM Local Funds - M305"]
["E",303,"FROM General Fund - Not SED Waiver eligible - B306"]
["E",304,"FROM Local Funds - Not SED Waiver eligible - M306"]
["E",390,"Total Redirected Funds",null,{"$f":"SUM(E146:E150)","v":0}]
["E",400,"BALANCE SED WAIVER (must = 0)",null,{"$f":"+E145+E151","v":0}]
[]
["F",null,"CHILDREN'S WAIVER"]
["F",190,"Revenue"]
["F",290,"Expenditure"]
["F",295,"NET CHILDREN'S WAIVER (cannot be > 0)",null,{"$f":"+E155-E156","v":0}]
["F",300,"Redirected Funds (To) From"]
["F",301,"FROM General Fund - B308"]
["F",302,"FROM Local Funds - M308"]
["F",303,"FROM Activity not otherwise reported - O301"]
["F",390,"Total Redirected Funds",null,{"$f":"SUM(E158:E161)","v":0}]
["F",400,"BALANCE CHILDREN'S WAIVER (must = 0)",null,{"$f":"+E157+E162","v":0}]
[]
["G",null,"INJECTABLE MEDICATIONS"]
["G",190,"Revenue"]
["G",290,"Expenditure"]
["G",295,"NET INJECTABLE MEDICATIONS (cannot be > 0)",null,{"$f":"+E166-E167","v":0}]
["G",300,"Redirected Funds (To) From"]
["G",301,"FROM General Fund - B309"]
["G",302,"FROM Local Funds - M309"]
["G",390,"Total Redirected Funds",null,{"$f":"SUM(E169:E171)","v":0}]
["G",400,"BALANCE INJECTABLE MEDICATIONS (must = 0)",null,{"$f":"+E168+E172","v":0}]
[]
["OTHER FUNDING"]
[]
["H",null,"MDHHS EARNED CONTRACTS"]
["H",100,"REVENUE"]
["H",101,"PASARR"]
["H",102,"DHHS Block Grants for CMH services"]
["H",103,"DD Council Grants"]
["H",104,"PATH/Homeless"]
["H",105,"Prevention"]
["H",106,"Aging"]
["H",107,"HUD Shelter Plus Care"]
["H",108,"Multicultural Integration"]
["H",109,"DHHS Block Grants for SUD services"]
["H",150,"Other MDHHS Earned Contracts (describe): "]
["H",151,"Other MDHHS Earned Contracts (describe): "]
["H",190,"TOTAL REVENUE",null,{"$f":"SUM(E178:E189)","v":0}]
["H",200,"EXPENDITURE"]
["H",201,"PASARR"]
["H",202,"DHHS Block Grants for CMH services"]
["H",203,"DD Council Grants"]
["H",204,"PATH/Homeless"]
["H",205,"Prevention"]
["H",206,"Aging"]
["H",207,"HUD Shelter Plus Care"]
["H",208,"Multicultural Integration"]
["H",209,"DHHS Block Grants for SUD services"]
["H",250,"Other MDHHS Earned Contracts (describe): "]
["H",251,"Other MDHHS Earned Contracts (describe): "]
["H",290,"TOTAL EXPENDITURE",null,{"$f":"SUM(E191:E202)","v":0}]
["H",400,"BALANCE MDHHS EARNED CONTRACTS (must = 0)",null,{"$f":"+E190-E203","v":0}]
[]
["I",null,"PIHP to AFFILIATE MEDICAID SERVICES CONTRACTS - CMHSP USE ONLY"]
["I",100,"REVENUE"]
["I",101,"Revenue - from PIHP Medicaid (incl Autism)"]
["I",104,"Revenue - from PIHP Healthy Michigan Plan (incl Autism)"]
["I",122,"1st & 3rd Party Collections - Medicare/Medicaid Consumers - Affiliate"]
["I",123,"1st & 3rd Party Collections - Healthy Michigan Plan Consumers - Affiliate"]
["I",190,"TOTAL REVENUE",null,{"$f":"SUM(E207:E211)","v":0}]
["I",201,"Expenditure - Medicaid (incl Autism)"]
["I",202,"Expenditure - Healthy Michigan Plan (incl Autism)"]
["I",203,"Expenditure - MI Health Link (Medicaid) Services"]
["I",290,"TOTAL EXPENDITURE",null,{"$f":"SUM(E213:E215)","v":0}]
["I",295,"NET PIHP to AFFILIATE MEDICAID SERVICES CONTRACTS SURPLUS (DEFICIT)",null,{"$f":"+E212-E216","v":0}]
["I",300,"Redirected Funds (To) From"]
["I",301,"(TO) CMHSP to CMHSP Earned Contracts - J306",null,{"$f":"-E307","v":0}]
["I",302,"FROM CMHSP to CMHSP Earned Contracts - J303"]
["I",303,"FROM Non-MDHHS Earned Contracts - K303"]
["I",304,"FROM General Fund - B310"]
["I",306,"FROM Local Funds - M309.1"]
["I",390,"Total Redirected Funds",null,{"$f":"SUM(E218:E223)","v":0}]
["I",400,"BALANCE PIHP to AFFILIATE MEDICAID SERVICES CONTRACTS (must = 0)",null,{"$f":"+E217+E224","v":0}]
[]
["IA",null,"PIHP to AFFILIATE SUBSTANCE USE DISORDER (NON-MEDICAID) CONTRACTS - CMHSP USE ONLY"]
["IA",100,"REVENUE"]
["IA",101,"Revenue - SUD Non-Medicaid - from PIHP"]
["IA",122,"Revenue - Fees & Collections - Affiliate"]
["IA",190,"TOTAL REVENUE",null,{"$f":"SUM(E228:E230)","v":0}]
["IA",200,"EXPENDITURE"]
["IA",201,"Expenditure "]
["IA",202,"Intentionally left blank"]
["IA",290,"TOTAL EXPENDITURE",null,{"$f":"+E233","v":0}]
["IA",295,"NET PIHP to AFFILIATE SUD (NON-MEDICAID) SERVICES CONTRACTS SURPLUS (DEFICIT)",null,{"$f":"+E231-E235","v":0}]
["IA",300,"Redirected Funds (To) From"]
["IA",301,"(TO) CMHSP to CMHSP Earned Contracts - J306.2",null,{"$f":"-E308","v":0}]
["IA",302,"FROM CMHSP to CMHSP Earned Contracts - J303.2"]
["IA",303,"FROM Non-MDHHS Earned Contracts - K303.2"]
["IA",304,"FROM General Fund - B310.1"]
["IA",305,"Intentionally left blank"]
["IA",306,"FROM Local Funds - M309.2"]
["IA",390,"Total Redirected Funds",null,{"$f":"SUM(E237:E243)","v":0}]
["IA",400,"BALANCE PIHP to AFFILIATE SUD (NON-MEDICAID) SERVICES CONTRACTS (must = 0)",null,{"$f":"+E236+E244","v":0}]
[]
["IB",null,"PIHP to AFFILIATE OPIOID HEALTH HOME SERVICES CONTRACTS - CMHSP USE ONLY"]
["IB",190,"Revenue - Medicaid Opioid Health Home Services - from PIHP"]
["IB",290,"Expenditure - Medicaid Opioid Health Home Services"]
["IB",295,"NET PIHP to AFFILIATE OPIOID HEALTH HOME SERVICES CONTRACTS SURPLUS (DEFICIT)",null,{"$f":"+E248-E249","v":0}]
["IB",300,"Redirected Funds (To) From"]
["IB",304,"FROM General Fund - B310.2"]
["IB",306,"FROM Local Funds - M309.3"]
["IB",390,"Total Redirected Funds",null,{"$f":"SUM(E251:E253)","v":0}]
["IB",400,"BALANCE PIHP to AFFILIATE OPIOID HEALTH HOME SERVICES CONTRACTS (cannot be < 0)",null,{"$f":"+E250+E254","v":0}]
[]
["IC",null,"PIHP to AFFILIATE HEALTH HOME SERVICES CONTRACTS - CMHSP USE ONLY"]
["IC",190,"Revenue - Medicaid Health Home Services - from PIHP"]
["IC",290,"Expenditure - Medicaid Health Home Services"]
["IC",295,"NET PIHP to AFFILIATE HEALTH HOME SERVICES CONTRACTS SURPLUS (DEFICIT)",null,{"$f":"+E258-E259","v":0}]
["IC",300,"Redirected Funds (To) From"]
["IC",304,"FROM General Fund - B310.3"]
["IC",306,"FROM Local Funds - M309.4"]
["IC",390,"Total Redirected Funds",null,{"$f":"SUM(E261:E263)","v":0}]
["IC",400,"BALANCE PIHP to AFFILIATE HEALTH HOME SERVICES CONTRACTS (cannot be < 0)",null,{"$f":"+E260+E264","v":0}]
[]
["ID",null,"PIHP to AFFILIATE MI HEALTH LINK SERVICES CONTRACTS - CMHSP USE ONLY"]
["ID",100,"REVENUE"]
["ID",101,"Revenue - MI Health Link - from PIHP"]
["ID",122,"1st & 3rd Party Collections - MI Health Link Consumers - Affiliate"]
["ID",190,"TOTAL REVENUE",null,{"$f":"SUM(E268:E270)","v":0}]
["ID",200,"EXPENDITURE"]
["ID",201,"Expenditure "]
["ID",202,"Intentionally left blank"]
["ID",290,"TOTAL EXPENDITURE",null,{"$f":"+E273","v":0}]
["ID",295,"NET PIHP to AFFILIATE MI HEALTH LINK SERVICES CONTRACTS SURPLUS (DEFICIT)",null,{"$f":"+E271-E275","v":0}]
["ID",300,"Redirected Funds (To) From"]
["ID",301,"(TO) CMHSP to CMHSP Earned Contracts - J306.3",null,{"$f":"-E309","v":0}]
["ID",302,"FROM CMHSP to CMHSP Earned Contracts - J303.3"]
["ID",303,"FROM Non-MDHHS Earned Contracts - K303.3"]
["ID",304,"FROM General Fund - B310.4"]
["ID",305,"Intentionally left blank"]
["ID",306,"FROM Local Funds - M309.5"]
["ID",390,"Total Redirected Funds",null,{"$f":"SUM(E277:E283)","v":0}]
["ID",400,"BALANCE PIHP to AFFILIATE MI HEALTH LINK SERVICES CONTRACTS (must = 0)",null,{"$f":"+E276+E284","v":0}]
[]
["J",null,"CMHSP to CMHSP EARNED CONTRACTS"]
["J",190,"Revenue"]
["J",290,"Expenditure"]
["J",295,"NET CMHSP to CMHSP EARNED CONTRACTS SURPLUS (DEFICIT)",null,{"$f":"+E288-E289","v":0}]
["J",300,"Redirected Funds (To) From"]
["J",301,"(TO) Medicaid Services - A302   (PIHP use only)",null,{"$f":"-'FSR - Medicaid'!E34","v":0}]
["J",301.10000000000002,"(TO) Healthy Michigan - AI302   (PIHP use only)",null,{"$f":"-'FSR - Healthy Michigan'!E31","v":0}]
["J",301.2,"(TO) SUD (Non-Medicaid) Services Contracts - AC302   (PIHP use only)",null,{"$f":"-'FSR - SUD'!E25","v":0}]
["J",301.3,"(TO) MI Health Link - AK302   (PIHP use only)",null,{"$f":"-'FSR - MI Health Link'!E26","v":0}]
["J",302,"(TO) General Fund - B313",null,{"$f":"-E97","v":0}]
["J",303,"(TO) PIHP to Affiliate Medicaid Services Contracts - I302",null,{"$f":"-E220","v":0}]
["J",303.2,"(TO) PIHP to Affiliate SUD (Non-Medicaid) Services Contracts - IA302",null,{"$f":"-E239","v":0}]
["J",303.3,"(TO) PIHP to Affiliate MI Health Link Services Contracts - ID302",null,{"$f":"-E279","v":0}]
["J",303.39999999999998,"(TO) Targeted Case Management - D304",null,{"$f":"-E130","v":0}]
["J",304,"FROM Medicaid Services - A301   (PIHP use only)"]
["J",304.10000000000002,"FROM Healthy Michigan - AI301   (PIHP use only)"]
["J",304.2,"FROM SUD (Non-Medicaid) Service Contracts - AC301   (PIHP use only)"]
["J",304.3,"FROM MI Health Link - AK301   (PIHP use only)"]
["J",304.39999999999998,"FROM Targeted Case Management - D303"]
["J",305,"FROM General Fund - B312"]
["J",306,"FROM PIHP to Affiliate Medicaid Services Contracts - I301"]
["J",306.2,"FROM PIHP to Affiliate SUD (Non-Medicaid) Services Contracts - IA301"]
["J",306.3,"FROM PIHP to MI Health Link Services Contracts - ID301"]
["J",307,"FROM Local Funds - M310"]
["J",390,"Total Redirected Funds",null,{"$f":"SUM(E291:E310)","v":0}]
["J",400,"BALANCE CMHSP to CMHSP EARNED CONTRACTS (must = 0)",null,{"$f":"+E290+E311","v":0}]
[]
["K",null,"NON-MDHHS EARNED CONTRACTS"]
["K",190,"Revenue"]
["K",290,"Expenditure"]
["K",295,"NET NON-MDHHS EARNED CONTRACTS SURPLUS (DEFICIT)",null,{"$f":"+E315-E316","v":0}]
["K",300,"Redirected Funds (To) From"]
["K",301,"(TO) Medicaid Services - A303   (PIHP use only)",null,{"$f":"-'FSR - Medicaid'!E35","v":0}]
["K",301.10000000000002,"(TO) Healthy Michigan - AI303   (PIHP use only)",null,{"$f":"-'FSR - Healthy Michigan'!E32","v":0}]
["K",301.2,"(TO) SUD (Non-Medicaid) Services Contracts - AC303   (PIHP use only)",null,{"$f":"-'FSR - SUD'!E26","v":0}]
["K",301.3,"(TO) MI Health Link - AK303   (PIHP use only)",null,{"$f":"-'FSR - MI Health Link'!E27","v":0}]
["K",302,"(TO) General Fund - B314",null,{"$f":"-E98","v":0}]
["K",303,"(TO) PIHP to Affiliate Medicaid Services Contracts - I303",null,{"$f":"-E221","v":0}]
["K",303.2,"(TO) PIHP to Affiliate SUD (Non-Medicaid) Services Contracts - IA303",null,{"$f":"-E240","v":0}]
["K",303.3,"(TO) PIHP to Affiliate MI Health Link Services Contracts - ID303",null,{"$f":"-E280","v":0}]
["K",304,"(TO) Local Funds - M315",null,{"$f":"-E400","v":0}]
["K",305,"FROM Local Funds - M311"]
["K",390,"Total Redirected Funds",null,{"$f":"SUM(E318:E328)","v":0}]
["K",400,"BALANCE NON-MDHHS EARNED CONTRACTS (must = 0)",null,{"$f":"+E317+E329","v":0}]
[]
["L",null,"Intentionally left Blank"]
["L",100,"REVENUE"]
["L",101]
["L",102]
["L",190,"TOTAL REVENUE",null,{"$f":"SUM(E333:E335)","v":0}]
["L",200,"EXPENDITURE"]
["L",201]
["L",202]
["L",290,"TOTAL EXPENDITURE",null,{"$f":"SUM(E337:E339)","v":0}]
["L",295,"NET SURPLUS (DEFICIT)",null,{"$f":"+E336-E340","v":0}]
["L",300,"Redirected Funds (To) From"]
["L",300.3]
["L",300.5]
["L",301]
["L",302]
["L",390,"Total Redirected Funds",null,{"$f":"SUM(E342:E346)","v":0}]
["L",400,"BALANCE (must = 0)",null,{"$f":"+E341+E347","v":0}]
[]
["M",null,"LOCAL FUNDS"]
["M",100,"REVENUE"]
["M",101,"County Appropriation for Mental Health "]
["M",102,"County Appropriation for Substance Abuse - Non Public Act 2 Funds"]
["M",103,"Section 226 (a)  Funds",null,{"$f":"'GF Special Fund Account - 226a'!H33","v":0}]
["M",104,"Affiliate Local Contribution to State Medicaid Match Provided from CMHSP (PIHP only)"]
["M",105,"Medicaid Fee for Service Adjuster Payments"]
["M",106,"Local Grants"]
["M",107,"Interest"]
["M",108,"Intentionally left blank"]
["M",109,"SED Partner"]
["M",110,"All Other Local Funding"]
["M",111,"Performance Bonus Incentive Pool (PBIP) Restricted Local Funding"]
["M",190,"TOTAL REVENUE",null,{"$f":"SUM(E351:E362)","v":0}]
["M",200,"EXPENDITURE"]
["M",201,"GF 10% Local Match",null,{"$f":"+$D$72-$E$72","v":0}]
["M",202,"Local match cap amount"]
["M",203,"GF Local Match Capped per MHC 330.1308",null,{"$f":"IF($D$366=0,0,IF($E$365+$E$369>$D$366,(-$E$365-$E$369+$D$366),0))","v":0}]
["M",204,"Local Cost for State Provided Services"]
["M",205,"Local Contribution to State Medicaid Match (CMHSP Contribution Only)"]
["M",206,"Local Contribution to State Medicaid Match on Behalf of Affiliate (PIHP Only)"]
["M",207,"Local Match to Grants and MDHHS Earned Contracts"]
["M",208,"Intentionally left blank"]
["M",209,"Local Only Expenditures"]
["M",290,"TOTAL EXPENDITURE",null,{"$f":"SUM(E364:E373)","v":0}]
["M",295,"NET LOCAL FUNDS SURPLUS (DEFICIT)",null,{"$f":"+E363-E374","v":0}]
["M",300,"Redirected Funds (To) From"]
["M",301,"(TO) Medicaid Services - A332   (PIHP use only)",null,{"$f":"-'FSR - Medicaid'!E41","v":0}]
["M",301.10000000000002,"(TO) Healthy Michigan - AI332   (PIHP use only)",null,{"$f":"-'FSR - Healthy Michigan'!E38","v":0}]
["M",301.2,"(TO) SUD (Non-Medicaid) Services - AC332   (PIHP use only)",null,{"$f":"-'FSR - SUD'!E31","v":0}]
["M",301.3,"(TO) Opioid Health Home Services - AE332   (PIHP use only)",null,{"$f":"-'FSR - Opioid Health Home BH'!E26","v":0}]
["M",301.39999999999998,"(TO) Health Home Services - AG332   (PIHP use only)",null,{"$f":"-'FSR - Health Homes BH'!E26","v":0}]
["M",301.5,"(TO) MI Health Link - AK332   (PIHP use only)",null,{"$f":"-'FSR - MI Health Link'!E33","v":0}]
["M",302,"(TO) General Fund - B331",null,{"$f":"-E100","v":0}]
["M",304,"(TO) Targeted Case Management - D302",null,{"$f":"-E128","v":0}]
["M",305,"(TO) SED Waiver - E302",null,{"$f":"-E148","v":0}]
["M",306,"(TO) SED Waiver - Not SED Waiver eligible - E304",null,{"$f":"-E150","v":0}]
["M",307,"Intentionally left blank"]
["M",308,"(TO) Children's Waiver - F302",null,{"$f":"-E160","v":0}]
["M",309,"(TO) Injectable Medications - G302",null,{"$f":"-E171","v":0}]
["M",309.10000000000002,"(TO) PIHP to Affiliate Medicaid Services Contracts - I306",null,{"$f":"-E223","v":0}]
["M",309.2,"(TO) PIHP to Affiliate SUD (Non-Medicaid) Services Contracts - IA306",null,{"$f":"-E243","v":0}]
["M",309.3,"(TO) PIHP to Affiliate Opioid Health Home Services Contracts - IB306",null,{"$f":"-E253","v":0}]
["M",309.39999999999998,"(TO) PIHP to Affiliate Health Home Services Contracts - IC306",null,{"$f":"-E263","v":0}]
["M",309.5,"(TO) PIHP to Affiliate MI Health Link Services Contracts - ID306",null,{"$f":"-E283","v":0}]
["M",310,"(TO) CMHSP to CMHSP Earned Contracts - J307",null,{"$f":"-E310","v":0}]
["M",311,"(TO) Non-MDHHS Earned Contracts - K305",null,{"$f":"-E328","v":0}]
["M",313,"(TO) Activity Not Otherwise Reported - O302",null,{"$f":"-E437","v":0}]
["M",313.3,"FROM MI Health Link (Medicare) - AK336 - (PIHP use only)"]
["M",314,"Intentionally left blank"]
["M",315,"FROM Non-MDHHS Earned Contracts - K304"]
["M",390,"Total Redirected Funds",null,{"$f":"SUM(E376:E400)","v":0}]
["M",400,"BALANCE LOCAL FUNDS                                          ",null,{"$f":"+E375+E401","v":0}]
[]
["N",null,"RISK CORRIDOR "]
["N",100,"REVENUE"]
["N",101,"   Stop/Loss Insurance"]
["N",102,"Medicaid ISF for PIHP Share Risk Corridor",null,{"$f":"-SUM('Medicaid ISF Report'!H17:I18)","v":0}]
["N",103,"MDHHS for MDHHS Share of Medicaid Risk Corridor "]
["N",104,"Restricted Fund balance for PIHP Share Risk Corridor",null,{"$f":"-SUM('Res Fund Bal'!F14+'Res Fund Bal'!H14+'Res Fund Bal'!F18+'Res Fund Bal'!H18)","v":0}]
["N",190,"TOTAL REVENUE",null,{"$f":"SUM(E405:E409)","v":0}]
["N",300,"Redirected Funds (To) From"]
["N",301,"(TO) Medicaid Services - PIHP Share - A333   (PIHP use only)",null,{"$f":"-'FSR - Medicaid'!E42","v":0}]
["N",301.10000000000002,"(TO) Healthy Michigan - PIHP Share - AI333   (PIHP use only)",null,{"$f":"-'FSR - Healthy Michigan'!E39","v":0}]
["N",301.2,"(TO) Restricted Fund balance for PIHP Share - A335 & AI335 (PIHP use only)",null,{"$f":"-SUM('FSR - Medicaid'!M44+'FSR - Healthy Michigan'!M41)","v":0}]
["N",302,"(TO) Medicaid Services - MDHHS Share - A334   (PIHP use only)",null,{"$f":"-'FSR - Medicaid'!E43","v":0}]
["N",302.10000000000002,"(TO) Healthy Michigan - MDHHS Share - AI334   (PIHP use only)",null,{"$f":"-'FSR - Healthy Michigan'!E40","v":0}]
["N",302.3,"Intentionally left blank"]
["N",303,"(TO) General Fund - B332",null,{"$f":"-E101","v":0}]
["N",304,"Intentionally left blank"]
["N",390,"Total Redirected Funds",null,{"$f":"SUM(E411:E419)","v":0}]
["N",400,"BALANCE RISK CORRIDOR (must = 0)",null,{"$f":"+E410+E420","v":0}]
[]
["O",null,"ACTIVITY NOT OTHERWISE REPORTED"]
["O",100,"REVENUE"]
["O",101," Other Revenue (describe):"]
["O",102," Other Revenue (describe):"]
["O",103," Other Revenue (describe):"]
["O",190,"TOTAL REVENUE",null,{"$f":"SUM(E424:E427)","v":0}]
["O",200,"EXPENDITURE"]
["O",201," Other Expenditure (describe): "]
["O",202," Other Expenditure (describe): "]
["O",203," Other Expenditure (describe): "]
["O",290,"TOTAL EXPENDITURE",null,{"$f":"SUM(E429:E432)","v":0}]
["O",295,"NET ACTIVITY NOT OTHERWISE REPORTED SURPLUS (DEFICIT)",null,{"$f":"+E428-E433","v":0}]
["O",300,"Redirected Funds (To) From"]
["O",301,"(TO) Children's Waiver - F303",null,{"$f":"-E161","v":0}]
["O",302,"FROM Local Funds - M313"]
["O",390,"Total Redirected Funds",null,{"$f":"SUM(E435:E437)","v":0}]
["O",400,"BALANCE ACTIVITY NOT OTHERWISE REPORTED",null,{"$f":"+E434+E438","v":0}]
[]
["P",null,"GRAND TOTALS"]
["P",190,"GRAND TOTAL REVENUE",null,{"$f":"+E9+E16+E52+E68+E111+E123+E138+E155+E166+E190+E212+E231+E248+E288+E315+E336+E363+E410+E428+E23+E30+E37+E258+E44+E271","v":0}]
["P",290,"GRAND TOTAL EXPENDITURE",null,{"$f":"+E10+E17+E53+E75+E112+E124+E144+E156+E167+E203+E216+E235+E249+E289+E316+E340+E374+E433+E24+E31+E38+E259+E45+E275","v":0}]
["P",390,"GRAND TOTAL REDIRECTED FUNDS (must = 0)",null,{"$f":"+E12+E19+E54+E102+E117+E131+E151+E162+E172+E224+E244+E254+E311+E329+E347+E401+E420+E438+E26+E33+E40+E264+E47+E284-E414","v":0}]
["P",400,"NET INCREASE (DECREASE)",null,{"$f":"+E442-E443","v":0}]
[]
["Q",null,"REMARKS"]
["Q",null,"This section has been provided for the CMHSP to provide narrative descriptions as requested in the FSR instructions or where additional narrative would be meaningful to the CMHSP / MDHHS."]
["Q"]
["Q"]
["Q"]
["Q"]
["Q"]
["Q"]
["Q"]
["Q"]
["Q"]
["Q"]

{"sheet":"GF CRCS","index":14,"n_rows":57,"n_cols":9,"rows_kept":57,"cut":false,"hidden":true,"merged":[[21,5,21,7],[42,5,42,6],[30,5,30,7],[12,5,12,7],[5,0,5,2],[5,3,5,5],[6,0,6,2],[11,5,11,7],[6,3,6,5],[13,5,13,6],[14,5,14,6],[15,5,15,7],[16,5,16,7],[17,5,17,7],[0,0,0,8],[1,0,1,8],[3,0,3,2],[4,0,4,2],[4,3,4,5],[3,3,3,6],[55,6,56,7],[48,6,49,7],[32,5,32,7],[18,5,18,7],[19,5,19,7],[23,5,23,7],[25,5,25,7],[26,5,26,7],[27,5,27,7],[33,5,33,7],[22,5,22,7],[29,5,29,7],[20,5,20,7],[28,5,28,7],[31,5,31,7],[24,5,24,7]]}
["MDHHS/CMHSP MANAGED MENTAL HEALTH SUPPORTS AND SERVICES CONTRACT (GF)"]
["GENERAL FUND CONTRACT RECONCILIATION AND CASH SETTLEMENT"]
[]
["CMHSP:     ",null,null,{"$f":"+'FSR - All Non Medicaid'!C3","v":0}]
["FISCAL YEAR:     ",null,null,{"$f":"+'FSR - All Non Medicaid'!E3","v":"SELECT"}]
["SUBMISSION TYPE:     ",null,null,{"$f":"+'FSR - All Non Medicaid'!D4","v":"SELECT"}]
["SUBMISSION DATE:     ",null,null,{"$f":"+'FSR - All Non Medicaid'!D5","v":"00:00:00"}]
[]
[]
[]
["1.","General Fund Services - Available Resources","Funding Resources",null,"2.","General Fund Services - Expenditures",null,"90/10 - Local Cap","Expenditures"]
["a.","CMH Operations     (FSR B 101)",{"$f":"+'FSR - All Non Medicaid'!E59","v":0},null,"a.","100% MDHHS Matchable Services     (FSR B 201)",null,null,{"$f":"+'FSR - All Non Medicaid'!E70","v":0}]
["b.","Intentionally left blank",null,null,"b.","100% MDHHS Matchable Services - CMHSP Local Match Cap     (FSR B 202)",null,null,{"$f":"+'FSR - All Non Medicaid'!E71","v":0}]
["c.","Intentionally left blank",null,null,"c.","90/10% MDHHS Matchable Services    (FSR B 203 Column A)",null,{"$f":"+'FSR - All Non Medicaid'!D72","v":0}]
["d.","Sub-Total General Fund Contract Authorization",{"$f":"SUM($C$12:$C$14)","v":0},null,"d.","Local 10% Match Cap Adjustment     (FSR M 203) ",null,{"$f":"+'FSR - All Non Medicaid'!E367","v":0},{"$f":"+H14+H15","v":0}]
["e.","1st & 3rd Party Collections     (FSR B 121 + B 122)",{"$f":"+'FSR - All Non Medicaid'!E63+'FSR - All Non Medicaid'!E64","v":0},null,"e.","Intentionally left blank"]
["f.","Prior Year GF Carry-Forward    (FSR B 123)",{"$f":"+'FSR - All Non Medicaid'!E65","v":0},null,"f.","Intentionally left blank"]
["g.","Intentionally left blank",null,null,"g.","Sub-Total General Fund Services - Expenditures  ",null,null,{"$f":"SUM($I$12:$I$17)","v":0}]
["h.","Redirected CMHSP to CMHSP Contracts     (FSR B 313)",{"$f":"+'FSR - All Non Medicaid'!E97","v":0},null,"h.","GF Supplement for Unfunded Medicaid - (PIHP use only)     (FSR B 301)",null,null,{"$f":"-'FSR - All Non Medicaid'!E78","v":0}]
["i.","Redirected Non-MDHHS Earned Contracts     (FSR B 314)",{"$f":"+'FSR - All Non Medicaid'!E98","v":0},null,"i.","GF Supplement for Unfunded Healthy Michigan - (PIHP use only)     (FSR B 301.1)",null,null,{"$f":"-'FSR - All Non Medicaid'!E79","v":0}]
["j.","Sub-Total Other General Fund Resources  ",{"$f":"SUM($C$16:$C$20)","v":0},null,"j.","GF Supplement for Unfunded  SUD (Non-Medicaid) Services (PIHP use only) (FSR B 301.2)",null,null,{"$f":"-'FSR - All Non Medicaid'!E80","v":0}]
["k.","Local 10% Associated to 90/10 Services     (FSR M 201)",{"$f":"+'FSR - All Non Medicaid'!E365","v":0},null,"k.","GF Supplement for Unfunded Opioid Health Home Services   (PIHP use only) (FSR B 301.3)",null,null,{"$f":"-'FSR - All Non Medicaid'!E81","v":0}]
["l.","Local 10% Match Cap Adjustment     (FSR M 203) ",{"$f":"+'FSR - All Non Medicaid'!E367","v":0},null,"l.","GF Supplement for Unfunded Health Home Services   (PIHP use only) (FSR B 301.4)",null,null,{"$f":"-'FSR - All Non Medicaid'!E82","v":0}]
["m.","Sub-Total Local 10% Associated to 90/10 Services  ",{"$f":"SUM($C$22:$C$23)","v":0},null,"m.","GF Supplement for Unfunded MI Health Link - (PIHP use only) (FSR B 301.5)",null,null,{"$f":"-'FSR - All Non Medicaid'!E83","v":0}]
[null,null,null,null,"n.","GF Supplement for Unfunded Targeted Case Management     (FSR B 304)",null,null,{"$f":"-'FSR - All Non Medicaid'!E85","v":0}]
["n.","Total General Fund Services - Resources  ",{"$f":"+$C$15+$C$21+$C$24","v":0},null,"o.","GF Supplement  for SED     (FSR B 305 + B 306)",null,null,{"$f":"-'FSR - All Non Medicaid'!E86-'FSR - All Non Medicaid'!E87","v":0}]
[null,null,null,null,"p.","GF Supplement for Children's Waiver     (FSR B 308)",null,null,{"$f":"-'FSR - All Non Medicaid'!E89","v":0}]
[null,null,null,null,"q.","GF Supplement for Injectable Medications     (FSR B 309)",null,null,{"$f":"-'FSR - All Non Medicaid'!E90","v":0}]
["3.","Summary of Resources / Expenditures","Amount",null,"r.","GF Supplement for PIHP to Affiliate Medicaid Services Contracts (FSR B 310)",null,null,{"$f":"-'FSR - All Non Medicaid'!E91","v":0}]
["a.","Total General Fund Services - Resources",{"$f":"+$C$26","v":0},null,"s.","GF Supplement for PIHP to Affiliate SUD (Non-Medicaid) Services Contracts (FSR B 310.1)",null,null,{"$f":"-'FSR - All Non Medicaid'!E92","v":0}]
["b.","Total General Fund Services - Expenditures",{"$f":"+$I$37","v":0},null,"t.","GF Supplement for PIHP to Affiliate Opioid Health Home Services Contracts   (FSR B 310.2)",null,null,{"$f":"-'FSR - All Non Medicaid'!E93","v":0}]
["c.","Sub-Total General Fund Services Surplus (Deficit)  ",{"$f":"+$C$30-$C$31","v":0},null,"u.","GF Supplement for PIHP to Affiliate Health Home Services Contracts   (FSR B 310.3)",null,null,{"$f":"-'FSR - All Non Medicaid'!E94","v":0}]
["d.","Less:  Forced Lapse to MDHHS (GF work sheet 5 d column F) ",{"$f":"+'GF Worksheet'!F32","v":0},null,"v.","GF Supplement for PIHP to Affiliate MI Health Link Services Contracts  (FSR B 310.4)",null,null,{"$f":"-'FSR - All Non Medicaid'!E95","v":0}]
["e.","Net General Fund Services Surplus (Deficit)  ",{"$f":"SUM($C$32:$C$33)","v":0},null,"w.","GF Supplement for CMHSP to CMHSP Contracts     (FSR B 312)",null,null,{"$f":"-'FSR - All Non Medicaid'!E96","v":0}]
[null,null,null,null,"x.","Sub-Total General Fund Services Supplement - Expenditures  ",null,null,{"$f":"SUM($I$19:$I$34)","v":0}]
[]
["4.","Disposition:","Amount",null,"y.","Total General Fund Services - Expenditures  ",null,null,{"$f":"+$I$18+$I$35","v":0}]
["a.","Surplus"]
["b.","Transfer to Fund Balance - GF Carry-Forward Earned",{"$f":"IF($C$34<=0,0,IF('GF Worksheet'!D19:$D$19>$C$34,$C$34*-1,'GF Worksheet'!D19:$D$19*-1))","v":0}]
["c.","Lapse to MDHHS - Contract Settlement",{"$f":"IF($C$34<=0,0,($C$34+$C$39)*-1)","v":0}]
["d.","Total Disposition - Surplus  ",{"$f":"SUM($C$39:$C$40)","v":0},null,"6.","General Fund MDHHS Commitment"]
[]
["e.","Deficit",null,null,"a.","MDHHS / CMHSP Contract Funded Expenditures ",null,{"$f":"+$C$15+$C$39+$C$33+$C$40","v":0}]
["f.","Redirected from Local     (FSR B 331)",{"$f":"+'FSR - All Non Medicaid'!E100","v":0},null,"b.","Earned General Fund Carry-Forward",null,{"$f":"-$C$39","v":0}]
["g.","Redirected from risk corridor     (FSR B 332)",{"$f":"+'FSR - All Non Medicaid'!E101","v":0},null,"c.","Total MDHHS General Fund Commitment  ",null,{"$f":"+$H$43+$H$44","v":0}]
["h.","Total Disposition - Deficit  ",{"$f":"SUM($C$44:$C$45)","v":0}]
[]
[null,null,null,null,"7.","Report Certification"]
["5.","Cash Settlement:  (Due MDHHS)  / Due CMHSP","Amount",null,null,null,"This certification has been moved to the CERTIFICATION OF MDHHS CONTRACT ATTACHMENTS 6.5.1.1 REPORT SUBMISSIONS form."]
["a.","Forced Lapse to MDHHS",{"$f":"+$C$33","v":0}]
["b.","Lapse to MDHHS - Contract Settlement",{"$f":"+$C$40","v":0}]
["c.","Return of Prior Year General Fund Carry-Forward"]
["d.","Intentionally left blank"]
["e.","Contract Authorization - Late Amendment",{"$f":"+'GF Worksheet'!H14","v":0}]
["f.","Intentionally left blank",null,null,"Questions should be directed to:"]
["g.","Misc:  (please explain)",null,null,null,null,"This contact information has been moved to the CERTIFICATION OF MDHHS CONTRACT ATTACHMENTS 6.5.1.1 REPORT SUBMISSIONS form."]
["h.","Total Cash Settlement:  (Due MDHHS) / Due CMHSP  ",{"$f":"SUM($C$50:$C$56)","v":0}]

{"sheet":"GF Worksheet","index":15,"n_rows":35,"n_cols":8,"rows_kept":35,"cut":false,"hidden":true,"merged":[[6,0,6,2],[0,0,0,7],[1,0,1,7],[3,0,3,2],[3,4,3,6],[4,0,4,2],[5,0,5,2],[34,1,34,7],[35,0,39,7],[22,3,24,7],[27,3,27,4],[28,3,28,4],[29,3,29,4],[30,3,30,4],[9,4,9,6],[31,3,31,4],[16,3,16,4],[18,3,18,4],[21,3,21,7]]}
["MDHHS/CMHSP MANAGED MENTAL HEALTH SUPPORTS AND SERVICES CONTRACT (GF)"]
["GENERAL FUND CONTRACT SETTLEMENT WORKSHEET"]
[]
["CMHSP:     ",null,null,null,{"$f":"+'FSR - All Non Medicaid'!C3","v":0}]
["FISCAL YEAR:     ",null,null,null,{"$f":"+'FSR - All Non Medicaid'!E3","v":"SELECT"}]
["SUBMISSION TYPE:     ",null,null,null,{"$f":"+'FSR - All Non Medicaid'!D4","v":"SELECT"}]
["SUBMISSION DATE:     ",null,null,null,{"$f":"+'FSR - All Non Medicaid'!D5","v":"00:00:00"}]
[]
[]
[null,null,null,null,"Cash Received",null,null,"Amount Due"]
["1.","General Fund (Formula and Categorical Funding)","Contract Authorization",null,"Through 9/30","After 9/30                Prior to Settlement","Total","CMHSP / (MDHHS) Cash Settlement"]
["a.","CMH Operations",{"$f":"+'FSR - All Non Medicaid'!E59","v":0},null,null,null,{"$f":"+E12+F12","v":0},{"$f":"+$C$12-$G$12","v":0}]
["b.","Intentionally left blank",null,null,null,null,{"$f":"+E13+F13","v":0},{"$f":"+$C$13-$G$13","v":0}]
["c.","Total Current FY GF Authorization / Cash Received / Cash Settlement ",{"$f":"SUM($C$12:$C$13)","v":0},null,{"$f":"SUM($E$12:$E$13)","v":0},{"$f":"SUM($F$12:$F$13)","v":0},{"$f":"SUM($G$12:$G$13)","v":0},{"$f":"SUM($H$12:$H$13)","v":0}]
[]
[]
["2.","Current Year - General Fund Carry-Forward - Maximum","Contract Authorization","Maximum C/F"]
["a.","CMH Operations",{"$f":"+$C$12","v":0}]
["b.","Total Current Year Maximum Carry-Forward  ",{"$f":"+$C$18","v":0},{"$f":"ROUND(+$C$19*5%,0)","v":0}]
[]
[]
["3.","Prior Year - General Fund Carry-Forward","FY "," If balance of Prior Year GF Carry-Forward is not zero, balance must be explained"]
["a.","Prior Year GF Carry-Forward Earned"]
["b.","Prior Year GF Carry-Forward (FSR B 123)",{"$f":"+'FSR - All Non Medicaid'!E65","v":0}]
["c.","Balance of Prior Year General Fund Carry-Forward  ",{"$f":"+$C$23-$C$24","v":0}]
[]
[]
["4.","Categorical - Categories","Authorization","Expenditures",null,"Lapse","Cost Above Authorizations"]
["a.","Other Funding - Please explain  ",null,null,null,{"$f":"IF(($D$29-$C$29)<0,($D$29-$C$29),0)","v":0},{"$f":"IF(($D$29-$C$29)>0,($D$29-$C$29),0)","v":0}]
["b.","Other Funding - Please explain  ",null,null,null,{"$f":"IF(($D$30-$C$30)<0,($D$30-$C$30),0)","v":0},{"$f":"IF(($D$30-$C$30)>0,($D$30-$C$30),0)","v":0}]
["c.","Other Funding - Please explain",null,null,null,{"$f":"IF(($D$31-$C$31)<0,($D$31-$C$31),0)","v":0},{"$f":"IF(($D$31-$C$31)>0,($D$31-$C$31),0)","v":0}]
["d.","Totals  ",{"$f":"SUM($C$29:$C$31)","v":0},{"$f":"SUM($D$29:$E$31)","v":0},null,{"$f":"SUM($F$29:$F$31)","v":0},{"$f":"SUM($G$29:$G$31)","v":0}]
[]
[]
["5.","Narrative:  Both CRCS and Contract Settlement Worksheet"]

{"sheet":"GF Special Fund Account - 226a","index":16,"n_rows":45,"n_cols":8,"rows_kept":45,"cut":false,"hidden":true,"merged":[[32,1,32,6],[34,1,34,7],[35,1,35,7],[36,1,37,7],[39,1,40,7],[31,1,31,6],[20,1,20,3],[21,1,21,3],[22,1,22,3],[23,1,23,3],[24,1,24,3],[25,1,25,7],[26,1,26,7],[27,1,27,7],[28,1,28,6],[29,1,29,6],[30,1,30,6],[14,1,14,7],[15,1,15,7],[16,1,19,3],[16,4,19,4],[16,5,19,5],[16,6,19,6],[16,7,19,7],[12,1,12,6],[1,1,1,7],[2,1,2,7],[3,1,3,7],[5,1,5,3],[5,4,5,7],[6,1,6,3],[7,1,7,3],[8,1,8,3],[10,1,10,7],[11,1,11,6]]}
[]
[null," SPECIAL FUND ACCOUNT   "]
[null,"For Recipient Fees and Third-Party Reimbursement"]
[null,"As Added to Mental Health Code per PA 423, 1980"]
[]
[null,"CMHSP:     ",null,null,{"$f":"'FSR - All Non Medicaid'!C3","v":0}]
[null,"FISCAL YEAR:     ",null,null,{"$f":"'FSR - All Non Medicaid'!E3","v":"SELECT"}]
[null,"SUBMISSION TYPE:     ",null,null,{"$f":"'FSR - All Non Medicaid'!D4","v":"SELECT"}]
[null,"SUBMISSION DATE:     ",null,null,{"$f":"'FSR - All Non Medicaid'!D5","v":"00:00:00"}]
[]
[null,"Part A:  Mental Health Code (MHC) 330.1311 - County Funding Level"]
[null,"  1.  County Funding - 1979/1980 "]
[null,"  2.  County Funding - Current Fiscal Year"]
[]
[null,"Part B:  Mental Health Code (MHC) 330.1226a - Cash Collections"]
[null,"Year to Date by Service Category and Source"]
[null,"Service Category",null,null,"(1)                Individuals Relatives","(2)                 Insurers Including Medicare","(3)                 Medicaid\n Health Plan Organizations","(4)                              Total"]
[]
[]
[]
[null,"  1.  Inpatient Services",null,null,null,null,null,{"$f":"SUM(E21:G21)","v":0}]
[null,"  2.  Residential Services",null,null,null,null,null,{"$f":"SUM(E22:G22)","v":0}]
[null,"  3.  Community Living Services",null,null,null,null,null,{"$f":"SUM(E23:G23)","v":0}]
[null,"  4.  Outpatient Services",null,null,null,null,null,{"$f":"SUM(E24:G24)","v":0}]
[null,"  5.  Total",null,null,{"$f":"SUM(E21:E24)","v":0},{"$f":"SUM(F21:F24)","v":0},{"$f":"SUM(G21:G24)","v":0},{"$f":"SUM(H21:H24)","v":0}]
[null,""]
[null,"Part C:  Mental Health Code (MHC) 330.1226a - Cash Collections"]
[null,"Quarterly Summary"]
[null,"  1.  First Quarter"]
[null,"  2.  Second Quarter"]
[null,"  3.  Third Quarter"]
[null,"  4.  Fourth Quarter"]
[null,"  5.  Total ",null,null,null,null,null,{"$f":"SUM(H29:H32)","v":0}]
[]
[]
[null,"Certification"]
[null,"This certification has been moved to the CERTIFICATION OF MDHHS CONTRACT ATTACHMENTS 6.5.1.1 REPORT SUBMISSIONS form."]
[]
[null,"Questions should be directed to:"]
[null,"This contact information has been moved to the CERTIFICATION OF MDHHS CONTRACT ATTACHMENTS 6.5.1.1 REPORT SUBMISSIONS form."]
[]
[]
[]
[]
[null,null,"section 7.2.4 Special Fund Account of the CMHSP contract"]

{"sheet":"Certification page","index":17,"n_rows":41,"n_cols":5,"rows_kept":41,"cut":false,"hidden":true,"merged":[[6,0,6,1],[7,0,7,2],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[5,0,5,1],[41,0,41,1],[40,0,40,1],[39,0,39,4],[9,0,9,4],[11,2,11,4],[19,2,19,4],[37,0,37,4],[38,0,38,4]]}
["MDHHS/PIHP MEDICAID MANAGED SPECIALTY SUPPORTS AND SERVICES CONCURRENT 1915(b)/(c) WAIVER PROGRAM CONTRACT"]
["AND"]
["MDHHS/CMHSP MANAGED MENTAL HEALTH SUPPORTS AND SERVICES CONTRACT (GF)"]
["CERTIFICATION OF MDHHS CONTRACT ATTACHMENTS C.6.5.1.1 & P.7.7.1.1 REPORT SUBMISSIONS"]
[]
["PIHP:",null,{"$f":"'Medicaid Worksheet'!D5","v":0},"FISCAL YEAR:","SELECT"]
["CMHSP:",null,{"$f":"'FSR - All Non Medicaid'!C3","v":0},"SUBMISSION TYPE:","SELECT"]
[null,null,null,"SUBMISSION DATE:"]
[]
["An \"X\" in the appropriate box in the section(s) below identifies the reports covered by this certification.  "]
[]
[null,null,"Contact"]
["General Fund - Non Medicaid Reports","\"X\"","Name","Telephone #","Email Address"]
["Special Fund Account - Section 226a"]
["Financial Status Report (FSR) - All Non-Medicaid"]
["Contract Reconciliation and Cash Settlement"]
["Contract Settlement Worksheet"]
["Year End Accrual Schedule"]
[]
[null,null,"Contact"]
["Medicaid Reports","\"X\"","Name","Telephone #","Email Address"]
["Financial Status Report (FSR) - Medicaid"]
["Financial Status Report (FSR) - Healthy Michigan"]
["Financial Status Report (FSR) - Health Homes"]
["Financial Status Report (FSR) - Opioid Health Homes"]
["Financial Status Report (FSR) - MI Health Link"]
["Financial Status Report (FSR) - SUD"]
["SUD  - Supplemental"]
["RES Fund Balance"]
["Internal Service Fund (ISF)"]
["Shared Risk Calculation & Risk Financing"]
["Contract Reconciliation and Cash Settlement"]
["Contract Settlement Worksheet"]
["Year End Accrual Schedule"]
[]
[]
[]
["CERTIFICATION"]
["The name below is authorized to certify on behalf of the CMHSP or PIHP that this is an accurate statement of revenues / expenditures for the reporting period.  Appropriate documentation is available and will be maintained for the required period to support the revenues and expenditures reported. "]
["Contact Information"]
["Name & Title",null,"Date","Telephone #","Email Address"]

{"sheet":"Additional Narrative","index":18,"n_rows":33,"n_cols":5,"rows_kept":33,"cut":false,"hidden":true,"merged":[[23,2,23,4],[25,2,25,4],[0,0,0,4],[2,0,2,4],[3,0,3,4],[6,0,6,1],[7,0,7,1],[8,0,8,2],[1,0,1,4],[10,0,12,4],[19,2,19,4],[20,2,20,4],[22,2,22,4],[26,2,26,4],[28,2,28,4],[29,2,29,4],[31,2,31,4],[32,2,32,4]]}
["MDHHS/PIHP MEDICAID MANAGED SPECIALTY SUPPORTS AND SERVICES CONCURRENT 1915(b)/(c) WAIVER PROGRAM CONTRACT"]
["AND"]
["MDHHS/CMHSP MANAGED MENTAL HEALTH SUPPORTS AND SERVICES CONTRACT (GF)"]
["FINANCIAL STATUS REPORT BUNDLE"]
[]
[]
["PIHP:",null,{"$f":"+'Medicaid Worksheet'!D5","v":0},"FISCAL YEAR:","SELECT"]
["CMHSP:",null,{"$f":"+'FSR - All Non Medicaid'!C3","v":0},"SUBMISSION TYPE:","SELECT"]
[null,null,null,"SUBMISSION DATE:"]
[]
["The \"Additional Narrative\" tab of the FSR Bundle should be utilized to provide additional narrative explanation regarding any entry or activity where additional information would be beneficial when the narrative section of the individual form was not sufficient.  "]
[]
[]
[]
["Column Instructions:"]
["FORM (FSR Bundle Tab):","  Select the appropriate Form (FSR Bundle Tab) from the drop down menu."]
["Row Reference:","  Enter the row reference that the additional narrative refers to.  "]
["Narrative:","  Enter narrative explanation regarding any entry or activity where additional information would be beneficial."]
[]
["FORM (FSR Bundle Tab)","Row Reference","Narrative "]
["SELECT"]
[]
["FORM (FSR Bundle Tab)","Row Reference","Narrative "]
["SELECT"]
[]
["FORM (FSR Bundle Tab)","Row Reference","Narrative "]
["SELECT"]
[]
["FORM (FSR Bundle Tab)","Row Reference","Narrative "]
["SELECT"]
[]
["FORM (FSR Bundle Tab)","Row Reference","Narrative "]
["SELECT"]