{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["DHCS Only","Instructions","1. Information","2. Component Summary","3. CSS","4. PEI","5. INN","6. WET","7. CFTN","8. TTACB, WET RP, HP","9. Adjustment (MHSA)","10. Adjustment (FFP)","11. Comments","drop down fields","E-1 CountyState2017"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":70,"comments":0,"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":"DHCS Only","index":0,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["For DHCS use only."]
["Click button to lock or unlock all sheets for editing. "]
["This tab should be hidden when not in use. "]

{"sheet":"Instructions","index":1,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[[11,1,13,1],[9,1,10,1],[9,2,10,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2]]}
[null,"Annual Mental Health Services Act Revenue and Expenditure Report"]
[null,"Fiscal Year 2016-17"]
[null,"ARER Instructions"]
[]
[null,"• For detailed instructions, see Enclosure 2: Instruction Manual for Fiscal Year 2016-17 of the MHSA Annual Revenue and Expenditure Report. "]
[null,"• These worksheets are used to report the total expenditures for each MHSA-funded program. Expenditures should be recognized in the period that the fund liability is incurred. (Accounting Standards and Procedures for Counties, State Controller’s Office (SCO), May 2014). "]
[null,"• Counties must report any expenditure that occurred between July 1, 2016 and June 30, 2017, on the appropriate component worksheet."]
[null,"• Counties should reflect total (gross) program expenditures for each MHSA program on the MHSA Component Expenditure Worksheets."]
[]
[null,"Step 1: Complete the Information worksheet","The information provided on the Information worksheet automatically links to worksheets in the ARER.  This worksheet eliminates the redundant entry of county name, code, and date on worksheets. "]
[]
[null,"Step 2: Complete section one and two of the Component Summary worksheet","Section one provides the total amount of unspent funds available from prior fiscal years.  These amounts should match the amount of unspent funds previously reported in the FY 2015-16 ARER, Unspent MHSA Funds in the Local Mental Health Service (MHS) Fund (Section 6)."]
[null,null,"Section two provides the total amount of revenue received and deposited into the local MHS Fund from July 1, 2016 through June 30, 2017."]
[null,null,"Skip section three through seven of the Component Summary worksheet. These sections are linked to the remaining component worksheets and will auto populate as the county completes each individual worksheet."]
[null,"Step 3: Complete each component and adjustment worksheet","In general, counties will enter expenditure data in the blue boxes throughout the workbook. Cells shaded gray will require no data entry because it is an excel formula or data is not relevant for that particular cell."]
[null,"Step 4: Review the Component Summary worksheet","Counties should verify that sections three through seven of the Component Summary worksheet accurately reflect the expenditures reported on the component and adjustment worksheets."]

{"sheet":"1. Information","index":2,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[null,"Annual Mental Health Services Act Revenue and Expenditure Report"]
[null,"Fiscal Year 2016-17"]
[null,"Information"]
[]
[null,1,"Date:","2018-04-02"]
[null,2,"County:"]
[null,3,"County Code:",{"$f":"IF(ISBLANK(D6),\"\",VLOOKUP(D6,Info_County_Code,2))","v":""}]
[null,4,"Address:","720 Wood Street"]
[null,5,"City:","Eureka CA"]
[null,6,"Zip:",95501]
[null,7,"County Population:  Over 200,000? (Yes or No)",{"$f":"IF(ISBLANK(D6),\"\",VLOOKUP(D6,County_Population,5,FALSE))","v":""}]
[null,8,"Name of Preparer:","Melissa Chilton"]
[null,9,"Title of Preparer:","Budget Specialist"]
[null,10,"Preparer Contact Email:","mchilton@co.humboldt.ca.us"]
[null,11,"Preparer Contact Telephone","(707) 441-5446"]

{"sheet":"2. Component Summary","index":3,"n_rows":102,"n_cols":14,"rows_kept":102,"cut":false,"hidden":false,"merged":[[4,1,4,2],[60,1,60,2],[75,1,75,2],[55,1,55,3]]}
[null,"Annual Mental Health Services Act Revenue and Expenditure Report"]
[null,"Fiscal Year 2016-17"]
[null,"Comopnent Summary"]
[]
[null,"County:",null,{"$f":"IF(ISBLANK('1. Information'!D6),\"\",'1. Information'!D6)","v":""},null,"Date:",{"$f":"IF(ISBLANK('1. Information'!D5),\"\",'1. Information'!D5)","v":"2018-04-02"}]
[]
[null,null,null,null,"A"]
[null,null,null,null,"% of revenue "]
[null,1,"Total Annual Planning Costs",{"$f":"'3. CSS'!F14+'4. PEI'!F14+'5. INN'!F14+'6. WET'!F14+'7. CFTN'!F14","v":110952.06999999999},{"$f":"IF(AND(N33>0,D9>0),D9/N33,\"\")","v":1.6791862383370864E-2},"Total MHSA costs for planning for all components may not exceed 5 percent of the total annual MHSA revenues received by the County"]
[null,2,"Total Evaluation Costs",{"$f":"'3. CSS'!F15+'4. PEI'!F15+'5. INN'!F17+'6. WET'!F15+'7. CFTN'!F16+'7. CFTN'!F17","v":48535.58}]
[null,3,"Total Administration",{"$f":"'3. CSS'!F16+'4. PEI'!F16+'5. INN'!F15+'5. INN'!F16+'6. WET'!F16+'7. CFTN'!F18+'7. CFTN'!F19","v":167163.42000000001}]
[]
[null,null,null,"A","B","C","D","E","F","G","H","I","J","K"]
[null,null,"(Click component title to jump to worksheet)","CSS","PEI","INN","WET","CFTN","TTACB","WET RP","PEI SW","MHSA HP","PR","TOTAL"]
[null,"SECTION 1: Unspent MHSA Funds Available in the MHS Fund From Prior Fiscal Years"]
[null,1,"Local Prudent Reserve",null,null,null,null,null,null,null,null,null,1168816,{"$f":"M16","v":1168816}]
[null,2,"FY 2006-07",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D17:L17)","v":0}]
[null,3,"FY 2007-08",null,null,null,311631,null,null,null,null,null,null,{"$f":"SUM(D18:L18)","v":311631}]
[null,4,"FY 2008-09",null,null,null,null,null,null,null,null,null,null,0]
[null,5,"FY 2009-10",null,null,null,null,null,null,null,null,null,null,0]
[null,6,"FY 2010-11",null,null,null,null,null,null,null,null,null,null,0]
[null,7,"FY 2011-12",null,null,null,5712,null,null,null,null,null,null,5712]
[null,8,"FY 2012-13",null,null,177092,null,null,null,null,null,null,null,177092]
[null,9,"FY 2013-14",null,null,223001,null,null,null,null,null,null,null,223001]
[null,10,"FY 2014-15",null,1080939,312150,null,null,null,null,null,null,null,1393089]
[null,11,"FY 2015-16",183014,1027368,256842,null,212380,null,null,null,null,null,1679604]
[null,12,"Interest",{"$f":"5370.29-5370.46+11498.87+2421.42","v":13920.12},{"$f":"10443.32+13382.44+11021.35+21712.66+162.98","v":56722.750000000007},{"$f":"6583.74+7036.66+7143.62+7895.52","v":28659.54},{"$f":"2509.89+1930.05+754.38+1045.24","v":6239.5599999999995},{"$f":"1217.66-1217.62-975.23","v":-975.18999999999983},null,null,null,null,14617.94,{"$f":"SUM(D27:M27)","v":119184.72}]
[null,13,"TOTAL",{"$f":"SUM(D16:D27)","v":196934.12},2165029.75,997744.54,323582.56,211404.81,0,0,0,0,1183433.94,{"$f":"SUM(D28:M28)","v":5078129.7200000007}]
[null,"SECTION 2: MHSA Funds Received in FY 2016-17 (Revenue)"]
[null,1,"Transfer from Local Prudent Reserve",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D30:M30)","v":0}]
[null,2,"FY 2016-17 MHSA Funds",{"$f":"+SUM(6528702.8-F31)*0.8","v":4961814.1280000005},{"$f":"+SUM(6528702.8-F31)*0.2","v":1240453.5320000001},{"$f":"6528702.8*0.05","v":326435.14},null,null,null,null,null,null,null,{"$f":"SUM(D31:M31)","v":6528702.7999999998}]
[null,3,"FY 2016-17 Interest Earned on local MHS Fund",{"$f":"1249.81+5728.31","v":6978.1200000000008},38759.19,14380.71,1245.8599999999999,null,null,null,null,null,17423.75,{"$f":"SUM(D32:M32)","v":78787.63}]
[null,4,"TOTAL",{"$f":"SUM(D30:D32)","v":4968792.2480000006},{"$f":"SUM(E30:E32)","v":1279212.7220000001},340815.85000000003,1245.8599999999999,0,0,0,0,0,17423.75,{"$f":"SUM(D33:M33)","v":6607490.4300000006}]
[null,"SECTION 3: Program Expenditures and Sources of Funding 2016-17"]
[null,1,"MHSA Funds"]
[null,2,"FY 2006-07",null,null,null,{"$f":"'6. WET'!W20","v":0},null,null,null,null,null,null,{"$f":"SUM(D36:M36)","v":0}]
[null,3,"FY 2007-08",null,null,null,{"$f":"'6. WET'!V20","v":111007.44},{"$f":"'7. CFTN'!V21","v":0},null,null,null,null,null,{"$f":"SUM(D37:M37)","v":111007.44}]
[null,4,"FY 2008-09",null,null,{"$f":"'5. INN'!U20","v":0},{"$f":"'6. WET'!U20","v":0},{"$f":"'7. CFTN'!U21","v":0},{"$f":"'8. TTACB, WET RP, HP'!T14","v":0},{"$f":"'8. TTACB, WET RP, HP'!T15","v":0},{"$f":"'4. PEI'!U17","v":0},null,null,0]
[null,5,"FY 2009-10",null,null,{"$f":"'5. INN'!T20","v":0},{"$f":"'6. WET'!T20","v":0},{"$f":"'7. CFTN'!T21","v":0},{"$f":"'8. TTACB, WET RP, HP'!S14","v":0},{"$f":"'8. TTACB, WET RP, HP'!S15","v":0},{"$f":"'4. PEI'!T17","v":0},null,null,0]
[null,6,"FY 2010-11",null,null,{"$f":"'5. INN'!S20","v":0},{"$f":"'6. WET'!S20","v":0},{"$f":"'7. CFTN'!S21","v":0},{"$f":"'8. TTACB, WET RP, HP'!R14","v":0},{"$f":"'8. TTACB, WET RP, HP'!R15","v":0},{"$f":"'4. PEI'!S17","v":0},null,null,0]
[null,7,"FY 2011-12",null,null,{"$f":"'5. INN'!R20","v":0},{"$f":"'6. WET'!R20","v":0},{"$f":"'7. CFTN'!R21","v":0},{"$f":"'8. TTACB, WET RP, HP'!Q14","v":0},{"$f":"'8. TTACB, WET RP, HP'!Q15","v":0},{"$f":"'4. PEI'!R17","v":0},null,null,0]
[null,8,"FY 2012-13",null,null,{"$f":"'5. INN'!Q20","v":177092},{"$f":"'6. WET'!Q20","v":0},{"$f":"'7. CFTN'!Q21","v":0},null,{"$f":"'8. TTACB, WET RP, HP'!P15","v":0},null,null,null,177092]
[null,9,"FY 2013-14",null,null,{"$f":"'5. INN'!P20","v":223001},{"$f":"'6. WET'!P20","v":0},{"$f":"'7. CFTN'!P21","v":0},null,{"$f":"'8. TTACB, WET RP, HP'!O15","v":0},null,null,null,223001]
[null,10,"FY 2014-15",{"$f":"'3. CSS'!O24-SUM('3. CSS'!O20:O22)","v":0},{"$f":"'4. PEI'!O21","v":1080939},{"$f":"'5. INN'!O20","v":261030.92},{"$f":"'6. WET'!O20","v":0},{"$f":"'7. CFTN'!O21","v":0},null,{"$f":"'8. TTACB, WET RP, HP'!N15","v":0},null,{"$f":"'8. TTACB, WET RP, HP'!N16","v":0},null,1341969.9199999999]
[null,11,"FY 2015-16",{"$f":"'3. CSS'!N24-SUM('3. CSS'!N20:N22)","v":183014},{"$f":"'4. PEI'!N21","v":407298.16999999993},{"$f":"'5. INN'!N20","v":0},{"$f":"'6. WET'!N20","v":0},{"$f":"'7. CFTN'!N21","v":156049.19},null,{"$f":"'8. TTACB, WET RP, HP'!M15","v":0},null,{"$f":"'8. TTACB, WET RP, HP'!M16","v":0},null,746361.35999999987]
[null,12,"FY 2016-17",{"$f":"'3. CSS'!M24-SUM('3. CSS'!M20:M22)","v":4061265.21},{"$f":"'4. PEI'!M21","v":0},{"$f":"'5. INN'!M20","v":0},{"$f":"'6. WET'!M20","v":0},{"$f":"'7. CFTN'!M21","v":0},null,{"$f":"'8. TTACB, WET RP, HP'!L15","v":0},null,{"$f":"'8. TTACB, WET RP, HP'!L16","v":0},null,{"$f":"SUM(D46:M46)","v":4061265.21}]
[null,13,"MHSA Interest",{"$f":"'3. CSS'!L24","v":19648.43},{"$f":"'4. PEI'!L21","v":95318.96},{"$f":"'5. INN'!L20","v":13620.4},{"$f":"'6. WET'!L20","v":6239.56},{"$f":"'7. CFTN'!L21","v":-975.19},{"$f":"'8. TTACB, WET RP, HP'!K14","v":0},{"$f":"'8. TTACB, WET RP, HP'!K15","v":0},{"$f":"'4. PEI'!L17","v":0},{"$f":"'8. TTACB, WET RP, HP'!K16","v":0},null,{"$f":"SUM(D47:M47)","v":133852.16}]
[null,14,"MHSA Net Expenditure Subtotal for FY 2016-17",{"$f":"SUM(D36:D47)","v":4263927.6399999997},{"$f":"SUM(E36:E47)","v":1583556.13},674744.32000000007,117247,155074,0,0,0,0,null,{"$f":"SUM(D48:M48)","v":6794549.0899999999}]
[null,15,"Other Funds"]
[null,16,"1991 Realignment",{"$f":"'3. CSS'!H24","v":0},{"$f":"'4. PEI'!H21","v":0},{"$f":"'5. INN'!H20","v":0},{"$f":"'6. WET'!H20","v":0},{"$f":"'7. CFTN'!H21","v":0},{"$f":"'8. TTACB, WET RP, HP'!G14","v":0},{"$f":"'8. TTACB, WET RP, HP'!G15","v":0},{"$f":"'4. PEI'!H17","v":0},{"$f":"'8. TTACB, WET RP, HP'!G16","v":0},null,{"$f":"SUM(D50:M50)","v":0}]
[null,17,"Behavioral Health Subaccount",{"$f":"'3. CSS'!I24","v":0},{"$f":"'4. PEI'!I21","v":0},{"$f":"'5. INN'!I20","v":0},{"$f":"'6. WET'!I20","v":0},{"$f":"'7. CFTN'!I21","v":0},{"$f":"'8. TTACB, WET RP, HP'!H14","v":0},{"$f":"'8. TTACB, WET RP, HP'!H15","v":0},{"$f":"'4. PEI'!I17","v":0},{"$f":"'8. TTACB, WET RP, HP'!H16","v":0},null,{"$f":"SUM(D51:M51)","v":0}]
[null,18,"FFP Revenue",{"$f":"'3. CSS'!G24","v":2704068.9},{"$f":"'4. PEI'!G21","v":62665.049999999988},{"$f":"'5. INN'!G20","v":88522.05},{"$f":"'6. WET'!G20","v":0},{"$f":"'7. CFTN'!G21","v":0},{"$f":"'8. TTACB, WET RP, HP'!F14","v":0},{"$f":"'8. TTACB, WET RP, HP'!F15","v":0},{"$f":"'4. PEI'!G17","v":0},{"$f":"'8. TTACB, WET RP, HP'!F16","v":0},null,{"$f":"SUM(D52:M52)","v":2855255.9999999995}]
[null,19,"Other",{"$f":"'3. CSS'!J24","v":0},{"$f":"'4. PEI'!J21","v":0},{"$f":"'5. INN'!J20","v":0},{"$f":"'6. WET'!J20","v":0},{"$f":"'7. CFTN'!J21","v":0},{"$f":"'8. TTACB, WET RP, HP'!I14","v":0},{"$f":"'8. TTACB, WET RP, HP'!I15","v":0},{"$f":"'4. PEI'!J17","v":0},{"$f":"'8. TTACB, WET RP, HP'!I16","v":0},null,0]
[null,20,"MHSA Other Funds Expenditure Subtotal for FY 2016-17",{"$f":"SUM(D50:D53)","v":2704068.9},{"$f":"SUM(E50:E53)","v":62665.049999999988},88522.05,0,0,0,0,0,0,null,2855255.9999999995]
[null,21,"TOTAL MHSA and Other Funding Sources",{"$f":"D48+D54","v":6967996.5399999991},{"$f":"E48+E54","v":1646221.18},763266.37000000011,117247,155074,0,0,0,0,null,9649805.0899999999]
[null,"SECTION 4: Transfers to Prudent Reserve, WET or CFTN"]
[null,1,"FY 2014-15",{"$f":"(G57+H57+M57)*-1","v":0},null,null,{"$f":"'3. CSS'!O20","v":0},{"$f":"'3. CSS'!O21","v":0},null,null,null,null,{"$f":"'3. CSS'!O22","v":0},{"$f":"SUM(D57:M57)","v":0}]
[null,2,"FY 2015-16",{"$f":"(G58+H58+M58)*-1","v":0},null,null,{"$f":"'3. CSS'!N20","v":0},{"$f":"'3. CSS'!N21","v":0},null,null,null,null,{"$f":"'3. CSS'!N22","v":0},{"$f":"SUM(D58:M58)","v":0}]
[null,3,"FY 2016-17",{"$f":"(G59+H59+M59)*-1","v":0},null,null,{"$f":"'3. CSS'!M20","v":0},{"$f":"'3. CSS'!M21","v":0},null,null,null,null,{"$f":"'3. CSS'!M22","v":0},0]
[null,4,"TOTAL",{"$f":"SUM(D57:D59)","v":0},null,null,{"$f":"SUM(G57:G59)","v":0},{"$f":"SUM(H57:H59)","v":0},null,null,null,null,{"$f":"SUM(M57:M59)","v":0},0]
[null,"SECTION 5: Adjustments to MHSA Funds"]
[null,1,"Local Prudent Reserve",null,null,null,null,null,null,null,null,null,{"$f":"SUM('9. Adjustment (MHSA)'!E36:E38)","v":13042.01},{"$f":"SUM(D62:M62)","v":13042.01}]
[null,2,"FY 2006-07",{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"CSS\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2006-07\")","v":0},null,null,{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"WET\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2006-07\")","v":0},null,null,null,null,null,null,{"$f":"SUM(D63:M63)","v":0}]
[null,3,"FY 2007-08",{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"CSS\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2007-08\")","v":0},null,null,{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"WET\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2007-08\")","v":0},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"CFTN\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2007-08\")","v":0},null,null,null,null,null,{"$f":"SUM(D64:M64)","v":0}]
[null,4,"FY 2008-09",{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"CSS\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2008-09\")","v":0},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"PEI\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2008-09\")","v":0},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"INN\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2008-09\")","v":0},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"WET\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2008-09\")","v":0},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"CFTN\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2008-09\")","v":0},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"TTACB\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2008-09\")","v":0},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"WET RP\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2008-09\")","v":0},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"PEI SW\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2008-09\")","v":0},null,null,0]
[null,5,"FY 2009-10",{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"CSS\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2009-10\")","v":0},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"PEI\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2009-10\")","v":0},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"INN\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2009-10\")","v":0},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"WET\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2009-10\")","v":0},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"CFTN\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2009-10\")","v":0},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"TTACB\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2009-10\")","v":0},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"WET RP\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2009-10\")","v":0},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"PEI SW\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2009-10\")","v":0},null,null,0]
[null,6,"FY 2010-11",{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"CSS\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2010-11\")","v":0},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"PEI\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2010-11\")","v":0},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"INN\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2010-11\")","v":0},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"WET\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2010-11\")","v":0},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"CFTN\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2010-11\")","v":0},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"TTACB\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2010-11\")","v":0},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"WET RP\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2010-11\")","v":0},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"PEI SW\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2010-11\")","v":0},null,null,0]
[null,7,"FY 2011-12",{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"CSS\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2011-12\")","v":0},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"PEI\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2011-12\")","v":0},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"INN\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2011-12\")","v":0},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"WET\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2011-12\")","v":0},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"CFTN\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2011-12\")","v":0},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"TTACB\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2011-12\")","v":0},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"WET RP\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2011-12\")","v":0},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"PEI SW\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2011-12\")","v":0},null,null,0]
[null,8,"FY 2012-13",{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"CSS\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2012-13\")","v":57373},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"PEI\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2012-13\")","v":-57373},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"INN\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2012-13\")","v":0},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"WET\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2012-13\")","v":0},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"CFTN\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2012-13\")","v":0},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"TTACB\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2012-13\")","v":0},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"WET RP\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2012-13\")","v":0},null,null,null,0]
[null,9,"FY 2013-14",{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"CSS\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2013-14\")","v":44600.14},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"PEI\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2013-14\")","v":-44600.14},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"INN\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2013-14\")","v":0},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"WET\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2013-14\")","v":0},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"CFTN\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2013-14\")","v":0},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"TTACB\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2013-14\")","v":0},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"WET RP\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2013-14\")","v":0},null,null,null,0]
[null,10,"FY 2014-15",{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"CSS\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2014-15\")","v":62429.95},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"PEI\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2014-15\")","v":-62429.95},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"INN\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2014-15\")","v":0},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"WET\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2014-15\")","v":0},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"CFTN\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2014-15\")","v":0},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"TTACB\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2014-15\")","v":0},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"WET RP\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2014-15\")","v":0},null,{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"MHSA HP\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2014-15\")","v":0},null,0]
[null,11,"FY 2015-16",{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"CSS\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2015-16\")","v":51368.39},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"PEI\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2015-16\")","v":-59566.7},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"INN\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2015-16\")","v":0},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"WET\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2015-16\")","v":0},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"CFTN\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2015-16\")","v":0},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"TTACB\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2015-16\")","v":0},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"WET RP\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2015-16\")","v":0},null,{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"MHSA HP\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2015-16\")","v":0},null,-8198.3099999999977]
[null,12,"FY 2016-17",{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"CSS\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2016-17\")","v":-13042.01},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"PEI\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2016-17\")","v":0},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"INN\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2016-17\")","v":0},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"WET\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2016-17\")","v":0},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"CFTN\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2016-17\")","v":0},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"TTACB\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2016-17\")","v":0},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"WET RP\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2016-17\")","v":0},null,{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$13:$F$22,'9. Adjustment (MHSA)'!$D$13:$D$22,\"MHSA HP\",'9. Adjustment (MHSA)'!$E$13:$E$22,\"FY 2016-17\")","v":0},null,-13042.01]
[null,13,"Interest",{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$28:$F$30,'9. Adjustment (MHSA)'!$E$28:$E$30,\"CSS\")","v":0},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$28:$F$30,'9. Adjustment (MHSA)'!$E$28:$E$30,\"PEI\")","v":0},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$28:$F$30,'9. Adjustment (MHSA)'!$E$28:$E$30,\"INN\")","v":0},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$28:$F$30,'9. Adjustment (MHSA)'!$E$28:$E$30,\"WET\")","v":0},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$28:$F$30,'9. Adjustment (MHSA)'!$E$28:$E$30,\"CFTN\")","v":0},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$28:$F$30,'9. Adjustment (MHSA)'!$E$28:$E$30,\"TTACB\")","v":0},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$28:$F$30,'9. Adjustment (MHSA)'!$E$28:$E$30,\"WET RP\")","v":0},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$28:$F$30,'9. Adjustment (MHSA)'!$E$28:$E$30,\"PEI SW\")","v":0},{"$f":"SUMIFS('9. Adjustment (MHSA)'!$F$28:$F$30,'9. Adjustment (MHSA)'!$E$28:$E$30,\"MHSA HP\")","v":0},null,0]
[null,14,"TOTAL",{"$f":"SUM(D62:D74)","v":202729.46999999997},{"$f":"SUM(E62:E74)","v":-223969.78999999998},0,0,0,0,0,0,0,13042.01,-8198.3100000000068]
[null,"SECTION 6: Adjustments to FFP Revenue"]
[null,1,"FY 2006-07",{"$f":"'10. Adjustment (FFP)'!H13","v":0},{"$f":"'10. Adjustment (FFP)'!H23","v":0},{"$f":"'10. Adjustment (FFP)'!H33","v":0},{"$f":"'10. Adjustment (FFP)'!H43","v":0},null,null,null,null,null,null,{"$f":"SUM(D77:M77)","v":0}]
[null,2,"FY 2007-08",{"$f":"'10. Adjustment (FFP)'!H14","v":0},{"$f":"'10. Adjustment (FFP)'!H24","v":0},{"$f":"'10. Adjustment (FFP)'!H34","v":0},{"$f":"'10. Adjustment (FFP)'!H44","v":0},null,null,null,null,null,null,{"$f":"SUM(D78:M78)","v":0}]
[null,3,"FY 2008-09",{"$f":"'10. Adjustment (FFP)'!H15","v":0},{"$f":"'10. Adjustment (FFP)'!H25","v":0},{"$f":"'10. Adjustment (FFP)'!H35","v":0},{"$f":"'10. Adjustment (FFP)'!H45","v":0},null,null,null,null,null,null,0]
[null,4,"FY 2009-10",{"$f":"'10. Adjustment (FFP)'!H16","v":0},{"$f":"'10. Adjustment (FFP)'!H26","v":0},{"$f":"'10. Adjustment (FFP)'!H36","v":0},{"$f":"'10. Adjustment (FFP)'!H46","v":0},null,null,null,null,null,null,0]
[null,5,"FY 2010-11",{"$f":"'10. Adjustment (FFP)'!H17","v":0},{"$f":"'10. Adjustment (FFP)'!H27","v":0},{"$f":"'10. Adjustment (FFP)'!H37","v":0},{"$f":"'10. Adjustment (FFP)'!H47","v":0},null,null,null,null,null,null,0]
[null,6,"FY 2011-12",{"$f":"'10. Adjustment (FFP)'!H18","v":0},{"$f":"'10. Adjustment (FFP)'!H28","v":0},{"$f":"'10. Adjustment (FFP)'!H38","v":0},{"$f":"'10. Adjustment (FFP)'!H48","v":0},null,null,null,null,null,null,0]
[null,7,"FY 2012-13",{"$f":"'10. Adjustment (FFP)'!H19","v":0},{"$f":"'10. Adjustment (FFP)'!H29","v":0},{"$f":"'10. Adjustment (FFP)'!H39","v":0},{"$f":"'10. Adjustment (FFP)'!H49","v":0},null,null,null,null,null,null,0]
[null,8,"FY 2013-14",{"$f":"'10. Adjustment (FFP)'!H20","v":0},{"$f":"'10. Adjustment (FFP)'!H30","v":0},{"$f":"'10. Adjustment (FFP)'!H40","v":0},{"$f":"'10. Adjustment (FFP)'!H50","v":0},null,null,null,null,null,null,0]
[null,9,"FY 2014-15",{"$f":"'10. Adjustment (FFP)'!H21","v":0},{"$f":"'10. Adjustment (FFP)'!H31","v":0},{"$f":"'10. Adjustment (FFP)'!H41","v":0},{"$f":"'10. Adjustment (FFP)'!H51","v":0},null,null,null,null,null,null,0]
[null,10,"FY 2015-16",{"$f":"'10. Adjustment (FFP)'!H22","v":0},{"$f":"'10. Adjustment (FFP)'!H32","v":0},{"$f":"'10. Adjustment (FFP)'!H42","v":0},{"$f":"'10. Adjustment (FFP)'!H52","v":0},null,null,null,null,null,null,0]
[null,11,"TOTAL",{"$f":"SUM(D77:D86)","v":0},0,0,{"$f":"SUM(G77:G86)","v":0},null,null,null,null,null,null,0]
[null,"SECTION 7: Unspent MHSA Fund in the Local MHS Fund Balance (MHSA + FFP)"]
[null,1,"Local Prudent Reserve",null,null,null,null,null,null,null,null,null,{"$f":"M16+M30+M60+M62","v":1181858.01},{"$f":"M89","v":1181858.01}]
[null,2,"FY 2006-07",null,null,null,{"$f":"G17-G36+G63+G77","v":0},null,null,null,null,null,null,{"$f":"SUM(D90:M90)","v":0}]
[null,3,"FY 2007-08",null,null,null,200623.56,{"$f":"H18-H37+H64+H78","v":0},null,null,null,null,null,{"$f":"SUM(D91:M91)","v":200623.56}]
[null,4,"FY 2008-09",{"$f":"D19-D38+D65+D79","v":0},0,0,0,0,{"$f":"I19-I38+I65+I79","v":0},0,0,null,null,0]
[null,5,"FY 2009-10",0,0,0,0,0,0,0,0,null,null,0]
[null,6,"FY 2010-11",0,0,0,0,0,0,0,0,null,null,0]
[null,7,"FY 2011-12",0,0,0,5712,0,0,0,0,null,null,5712]
[null,8,"FY 2012-13",57373,-57373,0,0,0,null,{"$f":"J23-J42+J69+J83","v":0},null,null,null,0]
[null,9,"FY 2013-14",44600.14,-44600.14,0,0,0,null,{"$f":"J24-J43+J70+J84","v":0},null,null,null,0]
[null,10,"FY 2014-15",{"$f":"D25-D44+D57+D71+D85","v":62429.95},{"$f":"E25-E44+E57+E71+E85","v":-62429.95},{"$f":"F25-F44+F57+F71+F85","v":51119.079999999987},{"$f":"G25-G44+G57+G71+G85","v":0},{"$f":"H25-H44+H57+H71+H85","v":0},null,{"$f":"J25-J44+J71+J85","v":0},null,null,null,51119.079999999987]
[null,11,"FY 2015-16",{"$f":"D26-D45+D58+D72+D86","v":51368.39},{"$f":"E26-E45+E58+E72+E86","v":560503.13000000012},{"$f":"F26-F45+F58+F72+F86","v":256842},{"$f":"G26-G45+G58+G72+G86","v":0},{"$f":"H26-H45++H58+H72+H86","v":56330.81},null,{"$f":"J26-J45+J72+J86","v":0},null,{"$f":"L26-L45+L72+L86","v":0},null,925044.33000000007]
[null,12,"FY 2016-17",{"$f":"D31-D46+D59+D73","v":887506.90800000052},{"$f":"E31-E46+E59+E73","v":1240453.5320000001},{"$f":"F31-F46+F59+F73","v":326435.14},{"$f":"G31-G46+G59+G73","v":0},{"$f":"H31-H46+H59+H73","v":0},null,{"$f":"J31-J46+J73","v":0},null,{"$f":"L31-L46+L59+L73","v":0},null,2454395.5800000005]
[null,13,"Interest",{"$f":"(D27+D32)-(D47+D74)","v":1249.8100000000013},162.97999999999593,29419.85,1245.8599999999988,0,0,0,0,0,{"$f":"M27+M32+M74","v":32041.690000000002},64120.189999999995]
[null,14,"TOTAL",{"$f":"SUM(D89:D101)","v":1104528.1980000006},{"$f":"SUM(E89:E101)","v":1636716.5520000001},663816.06999999995,{"$f":"SUM(G89:G101)","v":207581.41999999998},56330.81,0,0,0,0,{"$f":"SUM(M89:M101)","v":1213899.7},4882872.7500000009]

{"sheet":"3. CSS","index":4,"n_rows":83,"n_cols":22,"rows_kept":83,"cut":false,"hidden":false,"merged":[[14,2,14,4],[15,2,15,4],[18,2,18,4],[24,2,24,4],[11,6,11,9],[16,2,16,4],[17,2,17,4],[0,1,0,3],[6,1,6,2],[13,2,13,4],[2,1,2,10],[3,1,3,10],[4,1,4,10],[11,10,11,20],[36,7,36,10],[36,11,36,21],[36,2,36,6],[19,2,19,4],[21,2,21,4],[20,2,20,4],[29,2,29,4],[30,2,30,4],[31,2,31,4],[22,2,22,4],[23,2,23,4]]}
[null,"Back to Summary"]
[]
[null,"Annual Mental Health Services Act Revenue and Expenditure Report          "]
[null,"Fiscal Year 2016-17"]
[null,"Community Services and Supports (CSS) Summary  "]
[]
[null,"County:",null,{"$f":"IF(ISBLANK('1. Information'!D6),\"\",'1. Information'!D6)","v":""},null,"Date:",{"$f":"IF(ISBLANK('1. Information'!D5),\"\",'1. Information'!D5)","v":"2018-04-02"}]
[]
[null,"SECTION ONE"]
[]
[null,null,null,null,null,"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P"]
[null,null,null,null,null,null,"Other Funds",null,null,null,"MHSA Funds"]
[null,null,null,null,null,"Total","Medi-Cal FFP","1991 Realignment","Behavioral Health Subaccount","Other Funding","Total MHSA CSS (Including MHSA Interest)","MHSA Interest","MHSA CSS 2016-17","MHSA CSS 2015-16","MHSA CSS 2014-15","MHSA CSS 2013-14","MHSA CSS 2012-13","MHSA CSS 2011-12","MHSA CSS 2010-11","MHSA CSS 2009-10","MHSA CSS 2008-09"]
[null,1,"CSS Annual Planning Costs",null,null,{"$f":"SUM($G14:$J14,$K14)","v":32911.42},{"$f":"SUM(169365*0.46)*0.25","v":19476.975000000002},null,null,null,{"$f":"SUM($M14:$U14, $L14)","v":13434.444999999996},null,{"$f":"32911.42-G14","v":13434.444999999996}]
[null,2,"CSS Evaluation Costs",null,null,{"$f":"SUM($G15:$J15,$K15)","v":22522.49},{"$f":"SUM(169365*0.46)*0.17","v":13244.343000000003},null,null,null,{"$f":"SUM($M15:$U15, $L15)","v":9278.146999999999},null,{"$f":"22522.49-G15","v":9278.146999999999}]
[null,3,"CSS Administration Costs",null,null,77570.63,{"$f":"SUM(169365*0.46)*0.58","v":45186.582000000002},null,null,null,32384.048000000003,null,{"$f":"77570.63-G16","v":32384.048000000003}]
[null,4,"CSS Funds Transferred to JPA",null,null,{"$f":"SUM($G17:$J17,$K17)","v":0},null,null,null,null,0]
[null,5,"CSS Expenditure Incurred by JPA",null,null,{"$f":"SUM($G18:$J18,$K18)","v":0},null,null,null,null,{"$f":"SUM($M18:$U18, $L18)","v":0}]
[null,6,"CSS Funds Transferred to CalHFA",null,null,{"$f":"SUM($G19:$J19,$K19)","v":0},null,null,null,null,{"$f":"SUM($M19:$U19, $L19)","v":0}]
[null,7,"CSS Funds Transferred to WET",null,null,{"$f":"SUM($G20:$J20,$K20)","v":0},null,null,null,null,{"$f":"SUM($M20:$U20, $L20)","v":0}]
[null,8,"CSS Funds Transferred to CFTN",null,null,{"$f":"SUM($G21:$J21,$K21)","v":0},null,null,null,null,{"$f":"SUM($M21:$U21, $L21)","v":0}]
[null,9,"CSS Funds Transferred to PR",null,null,0,null,null,null,null,{"$f":"SUM($M22:$U22, $L22)","v":0}]
[null,10,"CSS Program Expenditures",null,null,{"$f":"SUM($G23:$J23,$K23)","v":6834992},{"$f":"SUM($H39:$H83)","v":2626161},{"$f":"SUM($I39:$I83)","v":0},{"$f":"SUM($J39:$J83)","v":0},{"$f":"SUM(K39:K83)","v":0},4208831,{"$f":"SUM($M39:$M83)","v":19648.43},{"$f":"SUM(N39:N83)","v":4006168.57},{"$f":"SUM(O39:O83)","v":183014},{"$f":"SUM(P39:P83)","v":0},{"$f":"SUM(Q39:Q83)","v":0},0,0,0,0,0]
[null,11,"Total CSS Expenditures (Excluding Funds Transferred to JPA)",null,null,{"$f":"SUM(F14:F16,F18:F23)","v":6967996.54},{"$f":"SUM(G14:G16,G18:G23)","v":2704068.9},0,0,0,4263927.6399999997,19648.43,4061265.21,183014,0,0,0,0,0,0,0]
[null,12,"Total MHSA CSS Available for Expenditures",null,null,null,null,null,null,null,{"$f":"SUM(L25,M25:U25)","v":5165726.3680000007},{"$f":"'2. Component Summary'!D27+'2. Component Summary'!D32","v":20898.240000000002},{"$f":"'2. Component Summary'!D30+'2. Component Summary'!D31","v":4961814.1280000005},{"$f":"'2. Component Summary'!D26","v":183014},{"$f":"'2. Component Summary'!D25","v":0},{"$f":"'2. Component Summary'!D24","v":0},{"$f":"'2. Component Summary'!D23","v":0},{"$f":"'2. Component Summary'!D22","v":0},{"$f":"'2. Component Summary'!D21","v":0},{"$f":"'2. Component Summary'!D20","v":0},{"$f":"'2. Component Summary'!D19","v":0}]
[]
[null,"SECTION TWO"]
[]
[null,null,null,null,null,"A","B"]
[null,1,"Total MHSA FSP Program Expenditure",null,null,{"$f":"SUMIF($F$39:$F$83,\"FSP\",$L$39:$L$83)","v":3782132},"(A)"]
[null,2,"Total MHSA CSS Expenditures (Excluding Funds Transferred to JPA)",null,null,{"$f":"SUM(K14:K16,K18,K23)","v":4263927.6399999997},"(B)"]
[null,3,"FSP Percentage of Total CSS Expenditure",null,null,{"$f":"IF($K$24=0,\"-\",(F30)/(F31))","v":0.88700660970878964},"(A) ÷ (B)"]
[]
[null,"SECTION THREE"]
[]
[null,null,"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T"]
[null,null,"CSS Component",null,null,null,null,"Other Funds",null,null,null,"MHSA Funds"]
[null,"#","County Code","Program Name","Prior Program Name","Service Category","Total CSS Program Expenditures","Medi-Cal FFP","1991 Realignment","Behavorial Health Subaccount","Other Funding","Total MHSA CSS (Including MHSA Interest)","MHSA Interest","MHSA CSS 2016-17","MHSA CSS 2015-16","MHSA CSS 2014-15","MHSA CSS 2013-14","MHSA CSS 2012-13","MHSA CSS 2011-12","MHSA CSS 2010-11","MHSA CSS 2009-10","MHSA CSS 2008-09"]
[null,1,{"$f":"IF(AND(NOT(COUNTA(D39:F39)),(NOT(COUNTA(H39:K39))),(NOT(COUNTA(N39:V39)))),\"\",VLOOKUP($D$7,Info_County_Code,2,FALSE))","v":{"$error":"#N/A"}},null,null,"Non-FSP",{"$f":"SUM(H39:K39,L39)","v":820739},294803,null,null,null,{"$f":"SUM($N39:$V39)+$M39","v":525936},null,525936]
[null,2,{"$error":"#N/A"},"CCT",null,"FSP",{"$f":"SUM(H40:K40,L40)","v":5979054},2196922,null,null,null,3782132,19648.43,{"$f":"3782132-M40-O40","v":3579469.57},183014]
[null,3,{"$error":"#N/A"},"OMS",null,"Non-FSP",27505,90286,null,null,null,-62781,null,-62781]
[null,4,{"$error":"#N/A"},"Older & Dependant Adults",null,"Non-FSP",7694,44150,null,null,null,-36456,null,-36456]
[null,5,"",null,null,null,0,null,null,null,null,0]
[null,6,"",null,null,null,0,null,null,null,null,0]
[null,7,"",null,null,null,0,null,null,null,null,0]
[null,8,"",null,null,null,0,null,null,null,null,0]
[null,9,"",null,null,null,0,null,null,null,null,0]
[null,10,"",null,null,null,0,null,null,null,null,0]
[null,11,"",null,null,null,0,null,null,null,null,0]
[null,12,"",null,null,null,0,null,null,null,null,0]
[null,13,"",null,null,null,0,null,null,null,null,0]
[null,14,"",null,null,null,0,null,null,null,null,0]
[null,15,"",null,null,null,0,null,null,null,null,0]
[null,16,"",null,null,null,0,null,null,null,null,0]
[null,17,"",null,null,null,0,null,null,null,null,0]
[null,18,"",null,null,null,0,null,null,null,null,0]
[null,19,"",null,null,null,0,null,null,null,null,0]
[null,20,"",null,null,null,0,null,null,null,null,0]
[null,21,"",null,null,null,0,null,null,null,null,0]
[null,22,"",null,null,null,0,null,null,null,null,0]
[null,23,"",null,null,null,0,null,null,null,null,0]
[null,24,"",null,null,null,0,null,null,null,null,0]
[null,25,"",null,null,null,0,null,null,null,null,0]
[null,26,"",null,null,null,0,null,null,null,null,0]
[null,27,"",null,null,null,0,null,null,null,null,0]
[null,28,"",null,null,null,0,null,null,null,null,0]
[null,29,"",null,null,null,0,null,null,null,null,0]
[null,30,"",null,null,null,0,null,null,null,null,0]
[null,31,"",null,null,null,0,null,null,null,null,0]
[null,32,"",null,null,null,0,null,null,null,null,0]
[null,33,"",null,null,null,0,null,null,null,null,0]
[null,34,"",null,null,null,0,null,null,null,null,0]
[null,35,"",null,null,null,0,null,null,null,null,0]
[null,36,"",null,null,null,0,null,null,null,null,0]
[null,37,"",null,null,null,0,null,null,null,null,0]
[null,38,"",null,null,null,0,null,null,null,null,0]
[null,39,"",null,null,null,0,null,null,null,null,0]
[null,40,"",null,null,null,0,null,null,null,null,0]
[null,41,"",null,null,null,0,null,null,null,null,0]
[null,42,"",null,null,null,0,null,null,null,null,0]
[null,43,"",null,null,null,0,null,null,null,null,0]
[null,44,"",null,null,null,0,null,null,null,null,0]
[null,45,"",null,null,null,0,null,null,null,null,0]

{"sheet":"4. PEI","index":5,"n_rows":66,"n_cols":27,"rows_kept":66,"cut":false,"hidden":false,"merged":[[6,1,6,2],[34,12,34,15],[34,16,34,26],[12,2,12,4],[13,2,13,4],[14,2,14,4],[15,2,15,4],[20,2,20,4],[21,2,21,4],[19,2,19,4],[17,2,17,4],[18,2,18,4],[16,2,16,4],[26,6,28,6],[34,2,34,11],[26,5,28,5],[11,6,11,9],[11,10,11,20],[29,2,29,4]]}
[null,"Back to Summary"]
[]
[null,"Annual Mental Health Services Act Revenue and Expenditure Report       "]
[null,"Fiscal Year 2016-17"]
[null,"Prevention and Early Intervention (PEI) Summary"]
[]
[null,"County:",null,{"$f":"IF(ISBLANK('1. Information'!D6),\"\",'1. Information'!D6)","v":""},null,"Date:",{"$f":"IF(ISBLANK('1. Information'!D5),\"\",'1. Information'!D5)","v":"2018-04-02"}]
[]
[null,"SECTION ONE"]
[]
[null,null,null,null,null,"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P"]
[null,null,null,null,null,null,"Other Funds",null,null,null,"MHSA Funds"]
[null,null,null,null,null,"Total","Medi-Cal FFP","1991 Realignment","Behavioral Health Subaccount","Other Funding","Total MHSA PEI (Including MHSA Interest)","MHSA Interest","MHSA PEI 2016-17","MHSA PEI 2015-16","MHSA PEI 2014-15","MHSA PEI 2013-14","MHSA PEI 2012-13","MHSA PEI 2011-12","MHSA PEI 2010-11","MHSA PEI 2009-10","MHSA PEI 2008-09"]
[null,1,"PEI Annual Planning Costs",null,null,{"$f":"SUM(G14:J14,K14)","v":66040.179999999993},{"$f":"SUM(169365*0.37)*0.25","v":15666.262499999999},null,null,null,{"$f":"SUM(L14,M14:U14)","v":50373.917499999996},{"$f":"95318.96-SUM(L15+L16+L18+R42)","v":16116.627500000002},null,{"$f":"26011.67+40028.51-SUM(G14+L14)","v":34257.289999999994}]
[null,2,"PEI Evaluation Costs",null,null,{"$f":"SUM(G15:J15,K15)","v":17800.73},{"$f":"SUM(169365*0.37)*0.17","v":10653.058499999999},null,null,null,{"$f":"SUM(L15,M15:U15)","v":7147.6715000000004},{"$f":"17800.73-G15","v":7147.6715000000004}]
[null,3,"PEI Administration Costs",null,null,{"$f":"SUM(G16:J16,K16)","v":61308.25},{"$f":"SUM(169365*0.37)*0.58","v":36345.728999999992},null,null,null,24962.521000000008,{"$f":"61308.25-G16","v":24962.521000000008}]
[null,4,"PEI Funds Expended by CalMHSA for PEI SW ",null,null,{"$f":"SUM(G17:J17,K17)","v":0},null,null,null,null,0]
[null,5,"PEI Funds Transferred to JPA",null,null,{"$f":"SUM(G18:J18,K18)","v":8198.31},null,null,null,null,8198.31,null,null,8198.31]
[null,6,"PEI Expenditure Incurred by JPA",null,null,{"$f":"SUM(G19:J19,K19)","v":0},null,null,null,null,0]
[null,7,"PEI Program Expenditures",null,null,{"$f":"SUM(G20:J20,K20)","v":1501072.02},{"$f":"SUMIF($G$37:$G$66,\"Combined Summary\",M$37:M$66) + SUMIF($F$37:$F$66,\"Standalone\",M$37:M$66)","v":0},0,0,0,1501072.02,47092.14,0,373040.87999999995,1080939,0,0,0,0,0,0]
[null,8,"Total PEI Expenditures (Excluding Transfers and PEI SW)",null,null,{"$f":"SUM(F14:F16,F19:F20)","v":1646221.18},{"$f":"SUM(G14:G16,G19:G20)","v":62665.049999999988},0,0,0,{"$f":"SUM(K14:K16,K19:K20)","v":1583556.1300000001},{"$f":"SUM(L14:L16,L19:L20)","v":95318.96},{"$f":"SUM(M14:M16,M19:M20)","v":0},{"$f":"SUM(N14:N16,N19:N20)","v":407298.16999999993},{"$f":"SUM(O14:O16,O19:O20)","v":1080939},{"$f":"SUM(P14:P16,P19:P20)","v":0},{"$f":"SUM(Q14:Q16,Q19:Q20)","v":0},{"$f":"SUM(R14:R16,R19:R20)","v":0},{"$f":"SUM(S14:S16,S19:S20)","v":0},{"$f":"SUM(T14:T16,T19:T20)","v":0},{"$f":"SUM(U14:U16,U19:U20)","v":0}]
[null,9,"Total MHSA PEI Available for Expenditures",null,null,null,null,null,null,null,{"$f":"SUM(L22,M22:U22)","v":3444242.4720000001},{"$f":"'2. Component Summary'!E27+'2. Component Summary'!E32","v":95481.94},{"$f":"'2. Component Summary'!E30+'2. Component Summary'!E31","v":1240453.5320000001},{"$f":"'2. Component Summary'!E26","v":1027368},{"$f":"'2. Component Summary'!E25","v":1080939},{"$f":"'2. Component Summary'!E24","v":0},{"$f":"'2. Component Summary'!E23","v":0},{"$f":"'2. Component Summary'!E22","v":0},{"$f":"'2. Component Summary'!E21","v":0},{"$f":"'2. Component Summary'!E20","v":0},{"$f":"'2. Component Summary'!E19","v":0}]
[]
[null,"SECTION TWO"]
[]
[null,null,null,null,null,"A","B"]
[null,null,null,null,null,"Percent Expended for Clients 25 and Under, All PEI","Percent Expended for Clients 25 and Under, JPA"]
[]
[]
[null,1,"MHSA PEI Fund Expenditures in Program to Clients 25 and Under (calculated from weighted program values) divided by Total MHSA PEI Expenditures",null,null,{"$f":"IF(K21=0,\"\",((SUMPRODUCT($K$37:$K$66,$Q$37:$Q$66)+(K19*G30))/$K$21))","v":0}]
[]
[null,"SECTION THREE"]
[]
[null,null,"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y"]
[null,null,"PEI Component",null,null,null,null,null,null,null,null,null,"Other Funds",null,null,null,"MHSA Funds"]
[null,"#","County","Program Name","Prior Program Name","Combined/ Standalone","Program Type","Program Activity Name (in Combined Program)","Subtotal Percentage for Combined Program","% of PEI Expended on Clients 25 & Under (Standalone and Program Activities in Combined Program)","% of PEI Expended on Clients 25 & Under (Combined Summary and Standalone)","Total PEI Program Expenditures","Medi-Cal FFP","1991 Realignment","Behavorial Health Subaccount","Other Funding","Total MHSA PEI (Including MHSA Interest)","MHSA Interest","MHSA PEI 2016-17","MHSA PEI 2015-16","MHSA PEI 2014-15","MHSA PEI 2013-14","MHSA PEI 2012-13","MHSA PEI 2011-12","MHSA PEI 2010-11","MHSA PEI 2009-10","MHSA PEI 2008-09"]
[null,1,{"$f":"IF(AND(NOT(COUNTA(D37:J37)),(NOT(COUNTA(M37:P37))),(NOT(COUNTA(R37:AA37)))),\"\",VLOOKUP($D$7,Info_County_Code,2,FALSE))","v":{"$error":"#N/A"}},"Suicide Prevention",null,"Standalone","Suicide Prevention",null,null,null,{"$f":"IF(OR(G37=\"Combined Summary\",F37=\"Standalone\"),(SUMPRODUCT(--(D$37:D$66=D37),I$37:I$66,J$37:J$66)),\"\")","v":0},{"$f":"IF(AND(G37=\"Combined Summary\",F37=\"Combined\"),SUM(M37:Q37),IF(F37=\"Standalone\",SUM(M37:Q37),\"\"))","v":239682.77},null,null,null,null,{"$f":"SUM(R37,S37:AA37)","v":239682.77},null,null,null,239682.77]
[null,2,{"$error":"#N/A"},"Stigma & Discrimination Reduction",null,"Standalone","Stigma & Discrimination Reduction",null,null,null,0,{"$f":"IF(AND(G38=\"Combined Summary\",F38=\"Combined\"),SUM(M38:Q38),IF(F38=\"Standalone\",SUM(M38:Q38),\"\"))","v":183056.65},null,null,null,null,{"$f":"SUM(R38,S38:AA38)","v":183056.65},null,null,null,183056.65]
[null,3,{"$error":"#N/A"},"Hope Center",null,"Standalone","Access and Linkage",null,null,null,0,273766.52,null,null,null,null,273766.52,null,null,null,273766.52]
[null,4,{"$error":"#N/A"},"Transitional Age Youth (TAY)",null,"Standalone","Improving Timely Access",null,null,null,0,412320.26,null,null,null,null,412320.26,null,null,{"$f":"412320.26-U40","v":27887.199999999953},{"$f":"1080939-SUM(U37+U38+U39)","v":384433.06000000006}]
[null,5,{"$error":"#N/A"},"Parent Partnership Program",null,"Standalone","Access and Linkage",null,null,null,0,241467.8,null,null,null,null,241467.8,null,null,241467.8]
[null,6,{"$error":"#N/A"},"Multi-Tiered Support Structure",null,"Standalone","Early Intervention",null,null,null,0,150778.01999999999,null,null,null,null,150778.01999999999,47092.14,null,{"$f":"150778.02-R42","v":103685.87999999999}]
[null,7,"",null,null,null,null,null,null,null,"","",null,null,null,null,0]
[null,8,"",null,null,null,null,null,null,null,"","",null,null,null,null,0]
[null,9,"",null,null,null,null,null,null,null,"","",null,null,null,null,0]
[null,10,"",null,null,null,null,null,null,null,"","",null,null,null,null,0]
[null,11,"",null,null,null,null,null,null,null,"","",null,null,null,null,0]
[null,12,"",null,null,null,null,null,null,null,"","",null,null,null,null,0]
[null,13,"",null,null,null,null,null,null,null,"","",null,null,null,null,0]
[null,14,"",null,null,null,null,null,null,null,"","",null,null,null,null,0]
[null,15,"",null,null,null,null,null,null,null,"","",null,null,null,null,0]
[null,16,"",null,null,null,null,null,null,null,"","",null,null,null,null,0]
[null,17,"",null,null,null,null,null,null,null,"","",null,null,null,null,0]
[null,18,"",null,null,null,null,null,null,null,"","",null,null,null,null,0]
[null,19,"",null,null,null,null,null,null,null,"","",null,null,null,null,0]
[null,20,"",null,null,null,null,null,null,null,"","",null,null,null,null,0]
[null,21,"",null,null,null,null,null,null,null,"","",null,null,null,null,0]
[null,22,"",null,null,null,null,null,null,null,"","",null,null,null,null,0]
[null,23,"",null,null,null,null,null,null,null,"","",null,null,null,null,0]
[null,24,"",null,null,null,null,null,null,null,"","",null,null,null,null,0]
[null,25,"",null,null,null,null,null,null,null,"","",null,null,null,null,0]
[null,26,"",null,null,null,null,null,null,null,"","",null,null,null,null,0]
[null,27,"",null,null,null,null,null,null,null,"","",null,null,null,null,0]
[null,28,"",null,null,null,null,null,null,null,"","",null,null,null,null,0]
[null,29,"",null,null,null,null,null,null,null,"","",null,null,null,null,0]
[null,30,"",null,null,null,null,null,null,null,"","",null,null,null,null,0]

{"sheet":"5. INN","index":6,"n_rows":87,"n_cols":26,"rows_kept":87,"cut":false,"hidden":false,"merged":[[19,2,19,4],[20,2,20,4],[25,15,25,25],[25,2,25,9],[11,10,11,20],[11,6,11,9],[25,11,25,14],[0,1,0,3],[14,2,14,4],[16,2,16,4],[17,2,17,4],[18,2,18,4],[15,2,15,4],[6,1,6,2],[13,2,13,4],[12,2,12,4]]}
[null,"Back to Summary"]
[]
[null,"Annual Mental Health Services Act Revenue and Expenditure Report for"]
[null,"Fiscal Year 2016-17"]
[null,"Innovation (INN) Summary"]
[]
[null,"County:",null,{"$f":"IF(ISBLANK('1. Information'!D6),\"\",'1. Information'!D6)","v":""},null,"Date:",{"$f":"IF(ISBLANK('1. Information'!D5),\"\",'1. Information'!D5)","v":"2018-04-02"}]
[]
[null,"SECTION ONE"]
[]
[null,null,null,null,null,"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P"]
[null,null,null,null,null,null,"Other Funds",null,null,null,"MHSA INN Fiscal Year"]
[null,null,null,null,null,"Total","Medi-Cal FFP","1991 Realignment","Behavioral Health Subaccount","Other Funding","Total MHSA INN (Including MHSA Interest)","MHSA Interest","MHSA INN 2016-17","MHSA INN 2015-16","MHSA INN 2014-15","MHSA INN 2013-14","MHSA INN 2012-13","MHSA INN 2011-12","MHSA INN 2010-11","MHSA INN 2009-10","MHSA INN 2008-09"]
[null,1,"INN Annual Planning Costs",null,null,{"$f":"SUM(G14:J14,K14)","v":12000.47},{"$f":"SUM(169365*0.17)*0.25","v":7198.0125000000007},null,null,null,{"$f":"SUM(L14,M14:U14)","v":4802.4574999999986},null,null,null,{"$f":"12000.47-G14","v":4802.4574999999986}]
[null,2,"INN Indirect Administration",null,null,{"$f":"SUM(G15:J15,K15)","v":28284.54},{"$f":"SUM(169365*0.17)*0.58","v":16699.388999999999},null,null,null,{"$f":"SUM(L15,M15:U15)","v":11585.151000000002},null,null,null,{"$f":"28284.54-G15","v":11585.151000000002}]
[null,3,"INN Project Administration",null,null,0,{"$f":"SUMIF($J$28:$J$87,\"Project Administration\",L$28:L$87)","v":0},{"$f":"SUMIF($J$28:$J$87,\"Project Administration\",M$28:M$87)","v":0},{"$f":"SUMIF($J$28:$J$87,\"Project Administration\",N$28:N$87)","v":0},{"$f":"SUMIF($J$28:$J$87,\"Project Administration\",O$28:O$87)","v":0},0,{"$f":"SUMIF($J$28:$J$87,\"Project Administration\",Q$28:Q$87)","v":0},0,0,0,0,0,0,0,0,0]
[null,4,"INN Project Evaluation",null,null,8212.36,{"$f":"SUMIF($J$28:$J$87,\"Project Evaluation\",L$28:L$87)","v":4894.6485000000011},{"$f":"SUMIF($J$28:$J$87,\"Project Evaluation\",M$28:M$87)","v":0},{"$f":"SUMIF($J$28:$J$87,\"Project Evaluation\",N$28:N$87)","v":0},{"$f":"SUMIF($J$28:$J$87,\"Project Evaluation\",O$28:O$87)","v":0},3317.7114999999994,{"$f":"SUMIF($J$28:$J$87,\"Project Evaluation\",Q$28:Q$87)","v":0},0,0,3317.7114999999994,0,0,0,0,0,{"$f":"SUMIF($J$28:$J$53,\"Project Evaluation\",Z$28:Z$53)","v":0}]
[null,5,"INN Project Direct",null,null,714769,{"$f":"SUMIF($J$28:$J$87,\"Project Direct\",L$28:L$87)","v":59730},{"$f":"SUMIF($J$28:$J$87,\"Project Direct\",M$28:M$87)","v":0},{"$f":"SUMIF($J$28:$J$87,\"Project Direct\",N$28:N$87)","v":0},{"$f":"SUMIF($J$28:$J$87,\"Project Direct\",O$28:O$87)","v":0},655039,{"$f":"SUMIF($J$28:$J$87,\"Project Direct\",Q$28:Q$87)","v":13620.4},0,0,241325.6,223001,177092,0,0,0,{"$f":"SUMIF($J$28:$J$53,\"Project Direct\",Z$28:Z$53)","v":0}]
[null,6,"INN Project Subtotal",null,null,{"$f":"SUM(F16:F18)","v":722981.36},{"$f":"SUM(G16:G18)","v":64624.648500000003},{"$f":"SUM(H16:H18)","v":0},{"$f":"SUM(I16:I18)","v":0},{"$f":"SUM(J16:J18)","v":0},{"$f":"SUM(L19,M19:U19)","v":658356.71149999998},{"$f":"SUM(L16:L18)","v":13620.4},{"$f":"SUM(M16:M18)","v":0},{"$f":"SUM(N16:N18)","v":0},{"$f":"SUM(O16:O18)","v":244643.31150000001},{"$f":"SUM(P16:P18)","v":223001},{"$f":"SUM(Q16:Q18)","v":177092},{"$f":"SUM(R16:R18)","v":0},{"$f":"SUM(S16:S18)","v":0},{"$f":"SUM(T16:T18)","v":0},{"$f":"SUM(U16:U18)","v":0}]
[null,7,"Total Innovation Expenditures",null,null,{"$f":"SUM(F14:F15,F16:F18)","v":763266.37},88522.05,0,0,0,674744.31999999995,13620.4,0,0,261030.92,223001,177092,0,0,0,0]
[null,8,"Total MHSA INN Available for Expenditures",null,null,null,null,null,null,null,{"$f":"SUM(L21,M21:U21)","v":1338560.3900000001},{"$f":"'2. Component Summary'!F27+'2. Component Summary'!F32","v":43040.25},{"$f":"'2. Component Summary'!F30+'2. Component Summary'!F31","v":326435.14},{"$f":"'2. Component Summary'!F26","v":256842},{"$f":"'2. Component Summary'!F25","v":312150},{"$f":"'2. Component Summary'!F24","v":223001},{"$f":"'2. Component Summary'!F23","v":177092},{"$f":"'2. Component Summary'!F22","v":0},{"$f":"'2. Component Summary'!F21","v":0},{"$f":"'2. Component Summary'!F20","v":0},{"$f":"'2. Component Summary'!F19","v":0}]
[]
[null,"SECTION TWO"]
[]
[null,null,"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X"]
[null,null,"INN Component",null,null,null,null,null,null,null,null,"Other Funds",null,null,null,"MHSA Funds"]
[null,"#","County","Project Name","Prior Project Name","Project MHSOAC Approval Date","Project Start Date","MHSOAC-Authorized MHSA INN Project Budget","Amended MHSOAC-Authorized MHSA INN Project Budget","Project Expenditure Type","Total Project Expenditures by Type","Medi-Cal FFP","1991 Realignment","BH Subaccount","Other","Total MHSA INN Funds (Including MHSA Interest)","MHSA Interest","MHSA INN 2016-17","MHSA INN 2015-16","MHSA INN 2014-15","MHSA INN 2013-14","MHSA INN 2012-13","MHSA INN 2011-12","MHSA INN 2010-11","MHSA INN 2009-10","MHSA INN 2008-09"]
[null,1,{"$f":"IF(AND(NOT(COUNTA(D28:I28)),(NOT(COUNTA(L28:O28))),(NOT(COUNTA(R28:Z28)))),\"\",VLOOKUP($D$7,Info_County_Code,2,FALSE))","v":{"$error":"#N/A"}},"Rapid re-Housing",null,"1905-07-07","1905-07-07",650000,null,"Project Administration",{"$f":"SUM(L28:O28,P28)","v":0},null,null,null,null,{"$f":"SUM(Q28,R28:Z28)","v":0}]
[null,1,{"$f":"IF(ISBLANK(C28),\"\",C28)","v":{"$error":"#N/A"}},"Rapid re-Housing","","1905-07-07","1905-07-07",650000,"","Project Evaluation",0,null,null,null,null,{"$f":"SUM(Q29,R29:Z29)","v":0}]
[null,1,{"$f":"IF(ISBLANK(C28),\"\",C28)","v":{"$error":"#N/A"}},"Rapid re-Housing","","1905-07-07","1905-07-07",650000,null,"Project Direct",240691,null,null,null,null,240691,null,null,null,null,{"$f":"240691-V30","v":63599},177092]
[null,1,{"$f":"IF(ISBLANK(C28),\"\",C28)","v":{"$error":"#N/A"}},"Rapid re-Housing","","1905-07-07","1905-07-07",650000,"","Project Subtotal",240691,{"$f":"SUM(L28:L30)","v":0},{"$f":"SUM(M28:M30)","v":0},0,0,240691,0,{"$f":"SUM(R28:R30)","v":0},{"$f":"SUM(S28:S30)","v":0},{"$f":"SUM(T28:T30)","v":0},{"$f":"SUM(U28:U30)","v":63599},{"$f":"SUM(V28:V30)","v":177092},{"$f":"SUM(W28:W30)","v":0},{"$f":"SUM(X28:X30)","v":0},{"$f":"SUM(Y28:Y30)","v":0},{"$f":"SUM(Z28:Z30)","v":0}]
[null,2,{"$f":"IF(AND(NOT(COUNTA(D32:I32)),(NOT(COUNTA(L32:O32))),(NOT(COUNTA(R32:Z32)))),\"\",VLOOKUP($D$7,Info_County_Code,2,FALSE))","v":{"$error":"#N/A"}},"MIST",null,"1905-07-06","1905-07-06",200000,null,{"$f":"IF(NOT(ISBLANK(D32)),$J$28,\"\")","v":"Project Administration"},0,null,null,null,null,0]
[null,2,{"$f":"IF(ISBLANK(C32),\"\",C32)","v":{"$error":"#N/A"}},"MIST","","1905-07-06","1905-07-06",200000,"",{"$f":"IF(NOT(ISBLANK(D32)),$J$29,\"\")","v":"Project Evaluation"},8212.36,{"$f":"SUM(169365*0.17)*0.17","v":4894.6485000000011},null,null,null,3317.7114999999994,null,null,null,{"$f":"8212.36-L33","v":3317.7114999999994}]
[null,2,{"$f":"IF(ISBLANK(C32),\"\",C32)","v":{"$error":"#N/A"}},"MIST","","1905-07-06","1905-07-06",200000,"",{"$f":"IF(NOT(ISBLANK(D32)),$J$30,\"\")","v":"Project Direct"},474078,59730,null,null,null,414348,13620.4,null,null,{"$f":"414348-U34-Q34","v":241325.6},{"$f":"223001-U30","v":159402}]
[null,2,{"$f":"IF(ISBLANK(C32),\"\",C32)","v":{"$error":"#N/A"}},"MIST","","1905-07-06","1905-07-06",200000,"",{"$f":"IF(NOT(ISBLANK(D32)),$J$31,\"\")","v":"Project Subtotal"},482290.36,{"$f":"SUM(L32:L34)","v":64624.648500000003},{"$f":"SUM(M32:M34)","v":0},{"$f":"SUM(N32:N34)","v":0},{"$f":"SUM(O32:O34)","v":0},417665.71149999998,{"$f":"SUM(Q32:Q34)","v":13620.4},{"$f":"SUM(R32:R34)","v":0},{"$f":"SUM(S32:S34)","v":0},{"$f":"SUM(T32:T34)","v":244643.31150000001},{"$f":"SUM(U32:U34)","v":159402},{"$f":"SUM(V32:V34)","v":0},{"$f":"SUM(W32:W34)","v":0},{"$f":"SUM(X32:X34)","v":0},{"$f":"SUM(Y32:Y34)","v":0},{"$f":"SUM(Z32:Z34)","v":0}]
[null,3,{"$f":"IF(AND(NOT(COUNTA(D36:I36)),(NOT(COUNTA(L36:O36))),(NOT(COUNTA(R36:Z36)))),\"\",VLOOKUP($D$7,Info_County_Code,2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(NOT(ISBLANK(D36)),$J$28,\"\")","v":""},0,null,null,null,null,0]
[null,3,{"$f":"IF(ISBLANK(C36),\"\",C36)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D36)),$J$29,\"\")","v":""},0,null,null,null,null,0]
[null,3,{"$f":"IF(ISBLANK(C36),\"\",C36)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D36)),$J$30,\"\")","v":""},0,null,null,null,null,0]
[null,3,{"$f":"IF(ISBLANK(C36),\"\",C36)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D36)),$J$31,\"\")","v":""},0,{"$f":"SUM(L36:L38)","v":0},{"$f":"SUM(M36:M38)","v":0},{"$f":"SUM(N36:N38)","v":0},{"$f":"SUM(O36:O38)","v":0},0,{"$f":"SUM(Q36:Q38)","v":0},{"$f":"SUM(R36:R38)","v":0},{"$f":"SUM(S36:S38)","v":0},{"$f":"SUM(T36:T38)","v":0},{"$f":"SUM(U36:U38)","v":0},{"$f":"SUM(V36:V38)","v":0},{"$f":"SUM(W36:W38)","v":0},{"$f":"SUM(X36:X38)","v":0},{"$f":"SUM(Y36:Y38)","v":0},{"$f":"SUM(Z36:Z38)","v":0}]
[null,4,{"$f":"IF(AND(NOT(COUNTA(D40:I40)),(NOT(COUNTA(L40:O40))),(NOT(COUNTA(R40:Z40)))),\"\",VLOOKUP($D$7,Info_County_Code,2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(NOT(ISBLANK(D40)),$J$28,\"\")","v":""},0,null,null,null,null,0]
[null,4,{"$f":"IF(ISBLANK(C40),\"\",C40)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D40)),$J$29,\"\")","v":""},0,null,null,null,null,0]
[null,4,{"$f":"IF(ISBLANK(C40),\"\",C40)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D40)),$J$30,\"\")","v":""},0,null,null,null,null,0]
[null,4,{"$f":"IF(ISBLANK(C40),\"\",C40)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D40)),$J$31,\"\")","v":""},0,{"$f":"SUM(L40:L42)","v":0},{"$f":"SUM(M40:M42)","v":0},{"$f":"SUM(N40:N42)","v":0},{"$f":"SUM(O40:O42)","v":0},0,{"$f":"SUM(Q40:Q42)","v":0},{"$f":"SUM(R40:R42)","v":0},{"$f":"SUM(S40:S42)","v":0},{"$f":"SUM(T40:T42)","v":0},{"$f":"SUM(U40:U42)","v":0},{"$f":"SUM(V40:V42)","v":0},{"$f":"SUM(W40:W42)","v":0},{"$f":"SUM(X40:X42)","v":0},{"$f":"SUM(Y40:Y42)","v":0},{"$f":"SUM(Z40:Z42)","v":0}]
[null,5,{"$f":"IF(AND(NOT(COUNTA(D44:I44)),(NOT(COUNTA(L44:O44))),(NOT(COUNTA(R44:Z44)))),\"\",VLOOKUP($D$7,Info_County_Code,2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(NOT(ISBLANK(D44)),$J$28,\"\")","v":""},0,null,null,null,null,0]
[null,5,{"$f":"IF(ISBLANK(C44),\"\",C44)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D44)),$J$29,\"\")","v":""},0,null,null,null,null,0]
[null,5,{"$f":"IF(ISBLANK(C44),\"\",C44)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D44)),$J$30,\"\")","v":""},0,null,null,null,null,0]
[null,5,{"$f":"IF(ISBLANK(C44),\"\",C44)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D44)),$J$31,\"\")","v":""},0,{"$f":"SUM(L44:L46)","v":0},{"$f":"SUM(M44:M46)","v":0},{"$f":"SUM(N44:N46)","v":0},{"$f":"SUM(O44:O46)","v":0},0,{"$f":"SUM(Q44:Q46)","v":0},{"$f":"SUM(R44:R46)","v":0},{"$f":"SUM(S44:S46)","v":0},{"$f":"SUM(T44:T46)","v":0},{"$f":"SUM(U44:U46)","v":0},{"$f":"SUM(V44:V46)","v":0},{"$f":"SUM(W44:W46)","v":0},{"$f":"SUM(X44:X46)","v":0},{"$f":"SUM(Y44:Y46)","v":0},{"$f":"SUM(Z44:Z46)","v":0}]
[null,6,{"$f":"IF(AND(NOT(COUNTA(D48:I48)),(NOT(COUNTA(L48:O48))),(NOT(COUNTA(R48:Z48)))),\"\",VLOOKUP($D$7,Info_County_Code,2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(NOT(ISBLANK(D48)),$J$28,\"\")","v":""},0,null,null,null,null,0]
[null,6,{"$f":"IF(ISBLANK(C48),\"\",C48)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D48)),$J$29,\"\")","v":""},0,null,null,null,null,0]
[null,6,{"$f":"IF(ISBLANK(C48),\"\",C48)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D48)),$J$30,\"\")","v":""},0,null,null,null,null,0]
[null,6,{"$f":"IF(ISBLANK(C48),\"\",C48)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D48)),$J$31,\"\")","v":""},0,{"$f":"SUM(L48:L50)","v":0},{"$f":"SUM(M48:M50)","v":0},{"$f":"SUM(N48:N50)","v":0},{"$f":"SUM(O48:O50)","v":0},0,{"$f":"SUM(Q48:Q50)","v":0},{"$f":"SUM(R48:R50)","v":0},{"$f":"SUM(S48:S50)","v":0},{"$f":"SUM(T48:T50)","v":0},{"$f":"SUM(U48:U50)","v":0},{"$f":"SUM(V48:V50)","v":0},{"$f":"SUM(W48:W50)","v":0},{"$f":"SUM(X48:X50)","v":0},{"$f":"SUM(Y48:Y50)","v":0},{"$f":"SUM(Z48:Z50)","v":0}]
[null,7,{"$f":"IF(AND(NOT(COUNTA(D52:I52)),(NOT(COUNTA(L52:O52))),(NOT(COUNTA(R52:Z52)))),\"\",VLOOKUP($D$7,Info_County_Code,2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(NOT(ISBLANK(D52)),$J$28,\"\")","v":""},0,null,null,null,null,0]
[null,7,{"$f":"IF(ISBLANK(C52),\"\",C52)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D52)),$J$29,\"\")","v":""},0,null,null,null,null,0]
[null,7,{"$f":"IF(ISBLANK(C52),\"\",C52)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D52)),$J$30,\"\")","v":""},0,null,null,null,null,0]
[null,7,{"$f":"IF(ISBLANK(C52),\"\",C52)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D52)),$J$31,\"\")","v":""},0,{"$f":"SUM(L52:L54)","v":0},{"$f":"SUM(M52:M54)","v":0},{"$f":"SUM(N52:N54)","v":0},{"$f":"SUM(O52:O54)","v":0},0,{"$f":"SUM(Q52:Q54)","v":0},{"$f":"SUM(R52:R54)","v":0},{"$f":"SUM(S52:S54)","v":0},{"$f":"SUM(T52:T54)","v":0},{"$f":"SUM(U52:U54)","v":0},{"$f":"SUM(V52:V54)","v":0},{"$f":"SUM(W52:W54)","v":0},{"$f":"SUM(X52:X54)","v":0},{"$f":"SUM(Y52:Y54)","v":0},{"$f":"SUM(Z52:Z54)","v":0}]
[null,8,{"$f":"IF(AND(NOT(COUNTA(D56:I56)),(NOT(COUNTA(L56:O56))),(NOT(COUNTA(R56:Z56)))),\"\",VLOOKUP($D$7,Info_County_Code,2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(NOT(ISBLANK(D56)),$J$28,\"\")","v":""},0,null,null,null,null,0]
[null,8,{"$f":"IF(ISBLANK(C56),\"\",C56)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D56)),$J$29,\"\")","v":""},0,null,null,null,null,0]
[null,8,{"$f":"IF(ISBLANK(C56),\"\",C56)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D56)),$J$30,\"\")","v":""},0,null,null,null,null,0]
[null,8,{"$f":"IF(ISBLANK(C56),\"\",C56)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D56)),$J$31,\"\")","v":""},0,{"$f":"SUM(L56:L58)","v":0},{"$f":"SUM(M56:M58)","v":0},{"$f":"SUM(N56:N58)","v":0},{"$f":"SUM(O56:O58)","v":0},0,{"$f":"SUM(Q56:Q58)","v":0},{"$f":"SUM(R56:R58)","v":0},{"$f":"SUM(S56:S58)","v":0},{"$f":"SUM(T56:T58)","v":0},{"$f":"SUM(U56:U58)","v":0},{"$f":"SUM(V56:V58)","v":0},{"$f":"SUM(W56:W58)","v":0},{"$f":"SUM(X56:X58)","v":0},{"$f":"SUM(Y56:Y58)","v":0},{"$f":"SUM(Z56:Z58)","v":0}]
[null,9,{"$f":"IF(AND(NOT(COUNTA(D60:I60)),(NOT(COUNTA(L60:O60))),(NOT(COUNTA(R60:Z60)))),\"\",VLOOKUP($D$7,Info_County_Code,2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(NOT(ISBLANK(D60)),$J$28,\"\")","v":""},0,null,null,null,null,0]
[null,9,{"$f":"IF(ISBLANK(C60),\"\",C60)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D60)),$J$29,\"\")","v":""},0,null,null,null,null,0]
[null,9,{"$f":"IF(ISBLANK(C60),\"\",C60)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D60)),$J$30,\"\")","v":""},0,null,null,null,null,0]
[null,9,{"$f":"IF(ISBLANK(C60),\"\",C60)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D60)),$J$31,\"\")","v":""},0,{"$f":"SUM(L60:L62)","v":0},{"$f":"SUM(M60:M62)","v":0},{"$f":"SUM(N60:N62)","v":0},{"$f":"SUM(O60:O62)","v":0},0,{"$f":"SUM(Q60:Q62)","v":0},{"$f":"SUM(R60:R62)","v":0},{"$f":"SUM(S60:S62)","v":0},{"$f":"SUM(T60:T62)","v":0},{"$f":"SUM(U60:U62)","v":0},{"$f":"SUM(V60:V62)","v":0},{"$f":"SUM(W60:W62)","v":0},{"$f":"SUM(X60:X62)","v":0},{"$f":"SUM(Y60:Y62)","v":0},{"$f":"SUM(Z60:Z62)","v":0}]
[null,10,{"$f":"IF(AND(NOT(COUNTA(D64:I64)),(NOT(COUNTA(L64:O64))),(NOT(COUNTA(R64:Z64)))),\"\",VLOOKUP($D$7,Info_County_Code,2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(NOT(ISBLANK(D64)),$J$28,\"\")","v":""},0,null,null,null,null,0]
[null,10,{"$f":"IF(ISBLANK(C64),\"\",C64)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D64)),$J$29,\"\")","v":""},0,null,null,null,null,0]
[null,10,{"$f":"IF(ISBLANK(C64),\"\",C64)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D64)),$J$30,\"\")","v":""},0,null,null,null,null,0]
[null,10,{"$f":"IF(ISBLANK(C64),\"\",C64)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D64)),$J$31,\"\")","v":""},0,{"$f":"SUM(L64:L66)","v":0},{"$f":"SUM(M64:M66)","v":0},{"$f":"SUM(N64:N66)","v":0},{"$f":"SUM(O64:O66)","v":0},0,{"$f":"SUM(Q64:Q66)","v":0},{"$f":"SUM(R64:R66)","v":0},{"$f":"SUM(S64:S66)","v":0},{"$f":"SUM(T64:T66)","v":0},{"$f":"SUM(U64:U66)","v":0},{"$f":"SUM(V64:V66)","v":0},{"$f":"SUM(W64:W66)","v":0},{"$f":"SUM(X64:X66)","v":0},{"$f":"SUM(Y64:Y66)","v":0},{"$f":"SUM(Z64:Z66)","v":0}]
[null,11,{"$f":"IF(AND(NOT(COUNTA(D68:I68)),(NOT(COUNTA(L68:O68))),(NOT(COUNTA(R68:Z68)))),\"\",VLOOKUP($D$7,Info_County_Code,2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(NOT(ISBLANK(D68)),$J$28,\"\")","v":""},0,null,null,null,null,0]
[null,11,{"$f":"IF(ISBLANK(C68),\"\",C68)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D68)),$J$29,\"\")","v":""},0,null,null,null,null,0]
[null,11,{"$f":"IF(ISBLANK(C68),\"\",C68)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D68)),$J$30,\"\")","v":""},0,null,null,null,null,0]
[null,11,{"$f":"IF(ISBLANK(C68),\"\",C68)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D68)),$J$31,\"\")","v":""},0,{"$f":"SUM(L68:L70)","v":0},{"$f":"SUM(M68:M70)","v":0},{"$f":"SUM(N68:N70)","v":0},{"$f":"SUM(O68:O70)","v":0},0,{"$f":"SUM(Q68:Q70)","v":0},{"$f":"SUM(R68:R70)","v":0},{"$f":"SUM(S68:S70)","v":0},{"$f":"SUM(T68:T70)","v":0},{"$f":"SUM(U68:U70)","v":0},{"$f":"SUM(V68:V70)","v":0},{"$f":"SUM(W68:W70)","v":0},{"$f":"SUM(X68:X70)","v":0},{"$f":"SUM(Y68:Y70)","v":0},{"$f":"SUM(Z68:Z70)","v":0}]
[null,12,{"$f":"IF(AND(NOT(COUNTA(D72:I72)),(NOT(COUNTA(L72:O72))),(NOT(COUNTA(R72:Z72)))),\"\",VLOOKUP($D$7,Info_County_Code,2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(NOT(ISBLANK(D72)),$J$28,\"\")","v":""},0,null,null,null,null,0]
[null,12,{"$f":"IF(ISBLANK(C72),\"\",C72)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D72)),$J$29,\"\")","v":""},0,null,null,null,null,0]
[null,12,{"$f":"IF(ISBLANK(C72),\"\",C72)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D72)),$J$30,\"\")","v":""},0,null,null,null,null,0]
[null,12,{"$f":"IF(ISBLANK(C72),\"\",C72)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D72)),$J$31,\"\")","v":""},0,{"$f":"SUM(L72:L74)","v":0},{"$f":"SUM(M72:M74)","v":0},{"$f":"SUM(N72:N74)","v":0},{"$f":"SUM(O72:O74)","v":0},0,{"$f":"SUM(Q72:Q74)","v":0},{"$f":"SUM(R72:R74)","v":0},{"$f":"SUM(S72:S74)","v":0},{"$f":"SUM(T72:T74)","v":0},{"$f":"SUM(U72:U74)","v":0},{"$f":"SUM(V72:V74)","v":0},{"$f":"SUM(W72:W74)","v":0},{"$f":"SUM(X72:X74)","v":0},{"$f":"SUM(Y72:Y74)","v":0},{"$f":"SUM(Z72:Z74)","v":0}]
[null,13,{"$f":"IF(AND(NOT(COUNTA(D76:I76)),(NOT(COUNTA(L76:O76))),(NOT(COUNTA(R76:Z76)))),\"\",VLOOKUP($D$7,Info_County_Code,2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(NOT(ISBLANK(D76)),$J$28,\"\")","v":""},0,null,null,null,null,0]
[null,13,{"$f":"IF(ISBLANK(C76),\"\",C76)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D76)),$J$29,\"\")","v":""},0,null,null,null,null,0]
[null,13,{"$f":"IF(ISBLANK(C76),\"\",C76)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D76)),$J$30,\"\")","v":""},0,null,null,null,null,0]
[null,13,{"$f":"IF(ISBLANK(C76),\"\",C76)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D76)),$J$31,\"\")","v":""},0,{"$f":"SUM(L76:L78)","v":0},{"$f":"SUM(M76:M78)","v":0},{"$f":"SUM(N76:N78)","v":0},{"$f":"SUM(O76:O78)","v":0},0,{"$f":"SUM(Q76:Q78)","v":0},{"$f":"SUM(R76:R78)","v":0},{"$f":"SUM(S76:S78)","v":0},{"$f":"SUM(T76:T78)","v":0},{"$f":"SUM(U76:U78)","v":0},{"$f":"SUM(V76:V78)","v":0},{"$f":"SUM(W76:W78)","v":0},{"$f":"SUM(X76:X78)","v":0},{"$f":"SUM(Y76:Y78)","v":0},{"$f":"SUM(Z76:Z78)","v":0}]
[null,14,{"$f":"IF(AND(NOT(COUNTA(D80:I80)),(NOT(COUNTA(L80:O80))),(NOT(COUNTA(R80:Z80)))),\"\",VLOOKUP($D$7,Info_County_Code,2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(NOT(ISBLANK(D80)),$J$28,\"\")","v":""},0,null,null,null,null,0]
[null,14,{"$f":"IF(ISBLANK(C80),\"\",C80)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D80)),$J$29,\"\")","v":""},0,null,null,null,null,0]
[null,14,{"$f":"IF(ISBLANK(C80),\"\",C80)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D80)),$J$30,\"\")","v":""},0,null,null,null,null,0]
[null,14,{"$f":"IF(ISBLANK(C80),\"\",C80)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D80)),$J$31,\"\")","v":""},0,{"$f":"SUM(L80:L82)","v":0},{"$f":"SUM(M80:M82)","v":0},{"$f":"SUM(N80:N82)","v":0},{"$f":"SUM(O80:O82)","v":0},0,{"$f":"SUM(Q80:Q82)","v":0},{"$f":"SUM(R80:R82)","v":0},{"$f":"SUM(S80:S82)","v":0},{"$f":"SUM(T80:T82)","v":0},{"$f":"SUM(U80:U82)","v":0},{"$f":"SUM(V80:V82)","v":0},{"$f":"SUM(W80:W82)","v":0},{"$f":"SUM(X80:X82)","v":0},{"$f":"SUM(Y80:Y82)","v":0},{"$f":"SUM(Z80:Z82)","v":0}]
[null,15,{"$f":"IF(AND(NOT(COUNTA(D84:I84)),(NOT(COUNTA(L84:O84))),(NOT(COUNTA(R84:Z84)))),\"\",VLOOKUP($D$7,Info_County_Code,2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(NOT(ISBLANK(D84)),$J$28,\"\")","v":""},0,null,null,null,null,0]
[null,15,{"$f":"IF(ISBLANK(C84),\"\",C84)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D84)),$J$29,\"\")","v":""},0,null,null,null,null,0]
[null,15,{"$f":"IF(ISBLANK(C84),\"\",C84)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D84)),$J$30,\"\")","v":""},0,null,null,null,null,0]
[null,15,{"$f":"IF(ISBLANK(C84),\"\",C84)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D84)),$J$31,\"\")","v":""},0,{"$f":"SUM(L84:L86)","v":0},{"$f":"SUM(M84:M86)","v":0},{"$f":"SUM(N84:N86)","v":0},{"$f":"SUM(O84:O86)","v":0},0,{"$f":"SUM(Q84:Q86)","v":0},{"$f":"SUM(R84:R86)","v":0},{"$f":"SUM(S84:S86)","v":0},{"$f":"SUM(T84:T86)","v":0},{"$f":"SUM(U84:U86)","v":0},{"$f":"SUM(V84:V86)","v":0},{"$f":"SUM(W84:W86)","v":0},{"$f":"SUM(X84:X86)","v":0},{"$f":"SUM(Y84:Y86)","v":0},{"$f":"SUM(Z84:Z86)","v":0}]

{"sheet":"6. WET","index":7,"n_rows":33,"n_cols":24,"rows_kept":33,"cut":false,"hidden":false,"merged":[[13,2,13,4],[26,11,26,23],[11,6,11,9],[11,10,11,22],[20,2,20,4],[16,2,16,4],[17,2,17,4],[14,2,14,4],[15,2,15,4],[19,2,19,4],[26,7,26,10],[26,2,26,6],[18,2,18,4]]}
[null,"Back to Summary"]
[]
[null,"Annual Mental Health Services Act Revenue and Expenditure Report             "]
[null,"Fiscal Year 2016-17"]
[null,"Workforce Education and Training (WET) Summary"]
[]
[null,null,"County:",{"$f":"IF(ISBLANK('1. Information'!D6),\"\",'1. Information'!D6)","v":""},null,"Date:",{"$f":"IF(ISBLANK('1. Information'!D5),\"\",'1. Information'!D5)","v":"2018-04-02"}]
[]
[null,"SECTION ONE"]
[]
[null,null,null,null,null,"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R"]
[null,null,null,null,null,null,"Other Fund",null,null,null,"MHSA Fund"]
[null,null,null,null,null,"Total","Medi-Cal FFP","1991 Realignment","Behavioral Health Subaccount","Other Funding","Total MHSA WET (Including Interest)","MHSA Interest","MHSA WET 2016-17","MHSA WET 2015-16","MHSA WET 2014-15","MHSA WET 2013-14","MHSA WET 2012-13","MHSA WET 2011-12","MHSA WET 2010-11","MHSA WET 2009-10","MHSA WET 2008-09","MHSA WET 2007-08","MHSA WET 2006-07"]
[null,1,"WET Annual Planning Costs",null,null,{"$f":"SUM(G14:J14,K14)","v":0},null,null,null,null,{"$f":"SUM(L14,M14:W14)","v":0}]
[null,2,"WET Evaluation Costs",null,null,{"$f":"SUM(G15:J15,K15)","v":0},null,null,null,null,{"$f":"SUM(L15,M15:W15)","v":0}]
[null,3,"WET Administration Costs",null,null,{"$f":"SUM(G16:J16,K16)","v":0},null,null,null,null,{"$f":"SUM(L16,M16:W16)","v":0}]
[null,4,"WET Funds Transferred to JPA",null,null,{"$f":"SUM(G17:J17,K17)","v":0},null,null,null,null,{"$f":"SUM(L17,M17:W17)","v":0}]
[null,5,"WET Expenditure Incurred by JPA",null,null,0,null,null,null,null,0]
[null,6,"WET Program Expenditures",null,null,{"$f":"SUM(G19:J19,K19)","v":117247},{"$f":"SUM(H29:H33)","v":0},0,0,{"$f":"SUM(K29:K33)","v":0},{"$f":"SUM(L19,M19:W19)","v":117247},{"$f":"SUM(M29:M33)","v":6239.56},0,0,0,0,0,0,0,0,0,{"$f":"SUM(W29:W33)","v":111007.44},{"$f":"SUM(X29:X33)","v":0}]
[null,7,"Total WET Expenditures (Excluding Transfers to JPA)",null,null,{"$f":"SUM(F14:F16,F18:F19)","v":117247},{"$f":"SUM(G14:G16,G18:G19)","v":0},{"$f":"SUM(H14:H16,H18:H19)","v":0},0,0,117247,6239.56,0,0,0,0,0,0,0,0,0,111007.44,0]
[null,8,"Total MHSA WET Available for Expenditures",null,null,null,null,null,null,null,{"$f":"SUM(L21,M21:W21)","v":324828.42},{"$f":"'2. Component Summary'!G27+'2. Component Summary'!G32","v":7485.4199999999992},{"$f":"'2. Component Summary'!G30+'2. Component Summary'!G31","v":0},{"$f":"'2. Component Summary'!G26","v":0},{"$f":"'2. Component Summary'!G25","v":0},{"$f":"'2. Component Summary'!G24","v":0},{"$f":"'2. Component Summary'!G23","v":0},{"$f":"'2. Component Summary'!G22","v":5712},{"$f":"'2. Component Summary'!G21","v":0},{"$f":"'2. Component Summary'!G20","v":0},{"$f":"'2. Component Summary'!G19","v":0},{"$f":"'2. Component Summary'!G18","v":311631},{"$f":"'2. Component Summary'!G17","v":0}]
[]
[]
[null,"SECTION TWO"]
[]
[null,null,"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V"]
[null,null,"Wet Component",null,null,null,null,"Other Funds",null,null,null,"MHSA Funds"]
[null,"#","County","Program Name","Prior Program Name","Funding Category","Total WET Program Expenditures","Medi-Cal FFP","1991 Realignment","Behavorial Health Subaccount","Other Funding","Total MHSA WET (Including Interest)","MHSA Interest","MHSA WET 2016-17","MHSA WET 2015-16","MHSA WET 2014-15","MHSA WET 2013-14","MHSA WET 2012-13","MHSA WET 2011-12","MHSA WET 2010-11","MHSA WET 2009-10","MHSA WET 2008-09","MHSA WET 2007-08","MHSA WET 2006-07"]
[null,1,{"$f":"IF(AND(NOT(COUNTA(D29:E29)),(NOT(COUNTA(H29:K29))),(NOT(COUNTA(M29:X29)))),\"\",VLOOKUP($D$7,Info_County_Code,2,FALSE))","v":""},null,null,"Workforce Staffing",{"$f":"SUM(H29:K29,L29)","v":0},null,null,null,null,{"$f":"SUM(M29,N29:X29)","v":0}]
[null,2,{"$f":"IF(AND(NOT(COUNTA(D30:E30)),(NOT(COUNTA(H30:K30))),(NOT(COUNTA(M30:X30)))),\"\",VLOOKUP($D$7,Info_County_Code,2,FALSE))","v":{"$error":"#N/A"}},null,null,"Training/Technical Assistance",{"$f":"SUM(H30:K30,L30)","v":117247},null,null,null,null,{"$f":"SUM(M30,N30:X30)","v":117247},6239.56,null,null,null,null,null,null,null,null,null,{"$f":"117247-M30","v":111007.44}]
[null,3,{"$f":"IF(AND(NOT(COUNTA(D31:E31)),(NOT(COUNTA(H31:K31))),(NOT(COUNTA(M31:X31)))),\"\",VLOOKUP($D$7,Info_County_Code,2,FALSE))","v":""},null,null,"MH Career Pathways",{"$f":"SUM(H31:K31,L31)","v":0},null,null,null,null,0]
[null,4,{"$f":"IF(AND(NOT(COUNTA(D32:E32)),(NOT(COUNTA(H32:K32))),(NOT(COUNTA(M32:X32)))),\"\",VLOOKUP($D$7,Info_County_Code,2,FALSE))","v":""},null,null,"Residency/Internship",{"$f":"SUM(H32:K32,L32)","v":0},null,null,null,null,0]
[null,5,{"$f":"IF(AND(NOT(COUNTA(D33:E33)),(NOT(COUNTA(H33:K33))),(NOT(COUNTA(M33:X33)))),\"\",VLOOKUP($D$7,Info_County_Code,2,FALSE))","v":""},null,null,"Financial Incentive",{"$f":"SUM(H33:K33,L33)","v":0},null,null,null,null,0]

{"sheet":"7. CFTN","index":8,"n_rows":48,"n_cols":24,"rows_kept":48,"cut":false,"hidden":false,"merged":[[11,6,11,9],[0,1,0,3],[11,10,11,22],[26,7,26,10],[26,11,26,23],[13,2,13,4],[15,2,15,4],[16,2,16,4],[17,2,17,4],[20,2,20,4],[19,2,19,4],[14,2,14,4],[26,2,26,6],[18,2,18,4],[21,2,21,4]]}
[null,"Back to Summary"]
[]
[null,"Annual Mental Health Services Act Revenue and Expenditure Report     "]
[null,"Fiscal Year 2016-17"]
[null,"Capital Facility Technological Needs (CFTN) Summary"]
[]
[null,"County:",null,{"$f":"IF(ISBLANK('1. Information'!D6),\"\",'1. Information'!D6)","v":""},null,"Date:",{"$f":"IF(ISBLANK('1. Information'!D5),\"\",'1. Information'!D5)","v":"2018-04-02"}]
[]
[null,"SECTION ONE"]
[]
[null,null,null,null,null,"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R"]
[null,null,null,null,null,null,"Other Fund",null,null,null,"MHSA Funds"]
[null,null,null,null,null,"Total","Medi-Cal FFP","1991 Realignment","Behavioral Health Subaccount","Other Funding","Total MHSA CFTN","MHSA Interest","MHSA CFTN 2016-17","MHSA CFTN 2015-16","MHSA CFTN 2014-15","MHSA CFTN 2013-14","MHSA CFTN 2012-13","MHSA CFTN 2011-12","MHSA CFTN 2010-11","MHSA CFTN 2009-10","MHSA CFTN 2008-09","MHSA CFTN 2007-08","MHSA CFTN 2006-07"]
[null,1,"CF Annual Planning Costs",null,null,{"$f":"SUM(G14:J14,K14)","v":0},null,null,null,null,{"$f":"SUM(L14,M14:W14)","v":0}]
[null,2,"TN Annual Planning Costs",null,null,0,null,null,null,null,{"$f":"SUM(L15,M15:W15)","v":0}]
[null,3,"CF Evaluation Costs",null,null,0,null,null,null,null,0]
[null,4,"TN Evaluation Costs",null,null,0,null,null,null,null,0]
[null,5,"CF Administration",null,null,0,null,null,null,null,0]
[null,6,"TN Administration",null,null,0,null,null,null,null,0]
[null,7,"CFTN Program Expenditure",null,null,155074,{"$f":"SUM(H29:H48)","v":0},{"$f":"SUM(I29:I48)","v":0},{"$f":"SUM(J29:J48)","v":0},{"$f":"SUM(K29:K48)","v":0},155074,{"$f":"SUM(M29:M48)","v":-975.19},0,156049.19,0,0,0,0,0,0,0,0,0]
[null,8,"Total CFTN Expenditures",null,null,{"$f":"SUM(F14:F20)","v":155074},{"$f":"SUM(G14:G20)","v":0},0,0,0,155074,-975.19,0,156049.19,0,0,0,0,0,0,0,0,0]
[null,9,"Total MHSA CFTN Available for Expenditures",null,null,null,null,null,null,null,{"$f":"SUM(L22,M22:W22)","v":211404.81},{"$f":"'2. Component Summary'!H27+'2. Component Summary'!H32","v":-975.18999999999983},{"$f":"'2. Component Summary'!H30+'2. Component Summary'!H31","v":0},{"$f":"'2. Component Summary'!H26","v":212380},{"$f":"'2. Component Summary'!H25","v":0},{"$f":"'2. Component Summary'!H24","v":0},{"$f":"'2. Component Summary'!H23","v":0},{"$f":"'2. Component Summary'!H22","v":0},{"$f":"'2. Component Summary'!H21","v":0},{"$f":"'2. Component Summary'!H20","v":0},{"$f":"'2. Component Summary'!H19","v":0},{"$f":"'2. Component Summary'!H18","v":0},{"$f":"'2. Component Summary'!H17","v":0}]
[]
[null,"SECTION TWO"]
[]
[null,null,"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V"]
[null,null,"CFTN Component",null,null,null,null,"Other Fund",null,null,null,"MHSA Fund"]
[null,"#","County","Project Name","Prior Project Name","Project Type","Total Project Expenditures","Medi-Cal FFP","1991 Realignment","Behavorial Health Subaccount","Other Funding","Total MHSA CFTN","MHSA Interest","MHSA CFTN 2016-17","MHSA CFTN 2015-16","MHSA CFTN 2014-15","MHSA CFTN 2013-14","MHSA CFTN 2012-13","MHSA CFTN 2011-12","MHSA CFTN 2010-11","MHSA CFTN 2009-10","MHSA CFTN 2008-09","MHSA CFTN 2007-08","MHSA CFTN 2006-07"]
[null,1,{"$f":"IF(AND(NOT(COUNTA(D29:F29)),(NOT(COUNTA(H29:K29))),(NOT(COUNTA(M29:X29)))),\"\",VLOOKUP($D$7,Info_County_Code,2,FALSE))","v":{"$error":"#N/A"}},"ICAIS",null,"Technological Need",{"$f":"SUM(H29:K29,L29)","v":155074},null,null,null,null,{"$f":"SUM(M29,N29:X29)","v":155074},-975.19,null,{"$f":"155074-M29","v":156049.19}]
[null,2,"",null,null,null,0,null,null,null,null,{"$f":"SUM(M30,N30:X30)","v":0}]
[null,3,"",null,null,null,0,null,null,null,null,0]
[null,4,"",null,null,null,0,null,null,null,null,0]
[null,5,"",null,null,null,0,null,null,null,null,0]
[null,6,"",null,null,null,0,null,null,null,null,0]
[null,7,"",null,null,null,0,null,null,null,null,0]
[null,8,"",null,null,null,0,null,null,null,null,0]
[null,9,"",null,null,null,0,null,null,null,null,0]
[null,10,"",null,null,null,0,null,null,null,null,0]
[null,11,"",null,null,null,0,null,null,null,null,0]
[null,12,"",null,null,null,0,null,null,null,null,0]
[null,13,"",null,null,null,0,null,null,null,null,0]
[null,14,"",null,null,null,0,null,null,null,null,0]
[null,15,"",null,null,null,0,null,null,null,null,0]
[null,16,"",null,null,null,0,null,null,null,null,0]
[null,17,"",null,null,null,0,null,null,null,null,0]
[null,18,"",null,null,null,0,null,null,null,null,0]
[null,19,"",null,null,null,0,null,null,null,null,0]
[null,20,"",null,null,null,0,null,null,null,null,0]

{"sheet":"8. TTACB, WET RP, HP","index":9,"n_rows":16,"n_cols":22,"rows_kept":16,"cut":false,"hidden":false,"merged":[[11,9,11,21],[0,1,0,3],[6,1,6,2],[11,2,11,4],[11,5,11,8]]}
[null,"Back to Summary"]
[]
[null,"Annual Mental Health Services Act Revenue and Expenditure Report"]
[null,"Fiscal Year 2016-17"]
[null,"TTACB, WET RP, MHSA HP Summary"]
[]
[null,"County:",null,{"$f":"IF(ISBLANK('1. Information'!D6),\"\",'1. Information'!D6)","v":""},null,"Date:",{"$f":"IF(ISBLANK('1. Information'!D5),\"\",'1. Information'!D5)","v":"2018-04-02"}]
[]
[null,"SECTION ONE"]
[]
[null,null,"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T"]
[null,null,"TTACB, WET RP, PE SW, HP Component",null,null,"Other Funds",null,null,null,"MHSA Funds"]
[null,"#","County Code","Funding Type","Expenditures","Medi-Cal FFP","1991 Realignment","Behavorial Health Subaccount","Other Funding","Total MHSA TTACB, WET RP, HP","MHSA Interest"," TTACB, WET RP,  HP 2016-17"," TTACB, WET RP, HP 2015-16"," TTACB, WET RP, HP 2014-15"," TTACB, WET RP, HP 2013-14"," TTACB, WET RP, HP 2012-13"," TTACB, WET RP, HP 2011-12"," TTACB, WET RP, HP 2010-11"," TTACB, WET RP, HP 2009-10"," TTACB, WET RP, HP 2008-09"," TTACB, WET RP, HP 2007-08"," TTACB, WET RP, HP 2006-07"]
[null,1,{"$f":"IF(AND(NOT(COUNTA(F14:I14)),(NOT(COUNTA(L14:V14)))),\"\",VLOOKUP($D$7,Info_County_Code,2,FALSE))","v":""},"Training, Technical Assistance & Capacity Building (TTACB)",{"$f":"SUM(F14:I14,J14)","v":0},null,null,null,null,{"$f":"SUM(K14,L14:V14)","v":0}]
[null,2,{"$f":"IF(AND(NOT(COUNTA(F15:I15)),(NOT(COUNTA(L15:V15)))),\"\",VLOOKUP($D$7,Info_County_Code,2,FALSE))","v":""},"WET Regional Partnerships (WET RP)",{"$f":"SUM(F15:I15,J15)","v":0},null,null,null,null,{"$f":"SUM(K15,L15:V15)","v":0}]
[null,3,{"$f":"IF(AND(NOT(COUNTA(F16:I16)),(NOT(COUNTA(L16:V16)))),\"\",VLOOKUP($D$7,Info_County_Code,2,FALSE))","v":""},"MHSA Housing Program (Unencumbered Funds)",{"$f":"SUM(F16:I16,J16)","v":0},null,null,null,null,0]

{"sheet":"9. Adjustment (MHSA)","index":10,"n_rows":38,"n_cols":7,"rows_kept":38,"cut":false,"hidden":false,"merged":[[6,1,6,2]]}
[null,"Back to Summary"]
[]
[null,"Annual Mental Health Services Act Revenue and Expenditure Report"]
[null,"Fiscal Year 2016-17"]
[null,"Adjustments Worksheet (MHSA)"]
[]
[null,"County:",null,{"$f":"IF(ISBLANK('1. Information'!D6),\"\",'1. Information'!D6)","v":""},null,"Date",{"$f":"IF(ISBLANK('1. Information'!D5),\"\",'1. Information'!D5)","v":"2018-04-02"}]
[]
[null,"SECTION ONE"]
[]
[null,null,"A","B","C","D","E"]
[null,"#","County","Component","Adjustment to FY","Amount","Reason"]
[null,1,{"$f":"IF(NOT(COUNTA(D13:G13)),\"\",VLOOKUP($D$7,Info_County_Code,2,FALSE))","v":{"$error":"#N/A"}},"CSS","FY 2016-17",-13042.01,"Transfer FY 2011-12 interest apportionment to PR"]
[null,2,{"$error":"#N/A"},"PEI","FY 2015-16",-8198.31,"To reduce PEI available funds per transfer to JPA"]
[null,3,{"$error":"#N/A"},"CSS","FY 2012-13",57373,"To correct component allocation "]
[null,4,{"$error":"#N/A"},"PEI","FY 2012-13",-57373,"To correct component allocation "]
[null,5,{"$error":"#N/A"},"CSS","FY 2013-14",44600.14,"To correct component allocation "]
[null,6,{"$error":"#N/A"},"PEI","FY 2013-14",-44600.14,"To correct component allocation "]
[null,7,{"$error":"#N/A"},"CSS","FY 2014-15",62429.95,"To correct component allocation "]
[null,8,{"$error":"#N/A"},"PEI","FY 2014-15",-62429.95,"To correct component allocation "]
[null,9,{"$error":"#N/A"},"CSS","FY 2015-16",51368.39,"To correct component allocation "]
[null,10,{"$error":"#N/A"},"PEI","FY 2015-16",-51368.39,"To correct component allocation "]
[null,null,{"$f":"IF(NOT(COUNTA(D23:G23)),\"\",VLOOKUP(D21,Info_County_Code,2,FALSE))","v":""}]
[null,"SECTION TWO"]
[]
[null,null,"A","B","C","D","E"]
[null,"#","County","Adjustment to","Component","Amount","Reason"]
[null,1,{"$f":"IF(NOT(COUNTA(E28:G28)),\"\",VLOOKUP($D$7,Info_County_Code,2,FALSE))","v":""},"Interest"]
[null,2,{"$f":"IF(NOT(COUNTA(E29:G29)),\"\",VLOOKUP($D$7,Info_County_Code,2,FALSE))","v":""},"Interest"]
[null,3,{"$f":"IF(NOT(COUNTA(E30:G30)),\"\",VLOOKUP($D$7,Info_County_Code,2,FALSE))","v":""},"Interest"]
[]
[null,"SECTION THREE"]
[]
[null,null,"A","B","C","D"]
[null,"#","County","Adjustment to","Amount","Reason"]
[null,1,{"$f":"IF(NOT(COUNTA(E36:F36)),\"\",VLOOKUP($D$7,Info_County_Code,2,FALSE))","v":{"$error":"#N/A"}},"Prudent Reserve",13042.01,"FY 2011-12 interest apportionment"]
[null,2,{"$f":"IF(NOT(COUNTA(E37:F37)),\"\",VLOOKUP($D$7,Info_County_Code,2,FALSE))","v":""},"Prudent Reserve"]
[null,3,{"$f":"IF(NOT(COUNTA(E38:F38)),\"\",VLOOKUP($D$7,Info_County_Code,2,FALSE))","v":""},"Prudent Reserve"]

{"sheet":"10. Adjustment (FFP)","index":11,"n_rows":52,"n_cols":9,"rows_kept":52,"cut":false,"hidden":false,"merged":[[6,1,6,2],[0,1,0,3]]}
[null,"Back to Summary"]
[]
[null,"Annual Mental Health Services Act Revenue and Expenditure Report          "]
[null,"Fiscal Year 2016-17"]
[null,"FFP Revenue Adjustment"]
[]
[null,"County:",null,{"$f":"IF(ISBLANK('1. Information'!D6),\"\",'1. Information'!D6)","v":""},null,"Date:",{"$f":"IF(ISBLANK('1. Information'!D5),\"\",'1. Information'!D5)","v":"2018-04-02"}]
[]
[null,"SECTION ONE"]
[]
[null,null,"A","B","C","D","E","F","G"]
[null,"#","County","Fiscal Year","Cost Report Stage","Component","Beginning Balance","Adjustment Amount","Ending Balance"]
[null,1,{"$f":"IF(NOT(COUNTA(G13:H13)),\"\",VLOOKUP($D$7,Info_County_Code,2,FALSE))","v":""},"FY 2006-07",null,"CSS",null,null,{"$f":"SUM(G13:H13)","v":0}]
[null,2,"","FY 2007-08",null,"CSS",null,null,{"$f":"SUM(G14:H14)","v":0}]
[null,3,"","FY 2008-09",null,"CSS",null,null,0]
[null,4,"","FY 2009-10",null,"CSS",null,null,0]
[null,5,"","FY 2010-11",null,"CSS",null,null,0]
[null,6,"","FY 2011-12",null,"CSS",null,null,0]
[null,7,"","FY 2012-13",null,"CSS",null,null,0]
[null,8,"","FY 2013-14",null,"CSS",null,null,0]
[null,9,"","FY 2014-15",null,"CSS",null,null,0]
[null,10,"","FY 2015-16",null,"CSS",null,null,0]
[null,11,"","FY 2006-07",null,"PEI",null,null,0]
[null,12,"","FY 2007-08",null,"PEI",null,null,0]
[null,13,"","FY 2008-09",null,"PEI",null,null,0]
[null,14,"","FY 2009-10",null,"PEI",null,null,0]
[null,15,"","FY 2010-11",null,"PEI",null,null,0]
[null,16,"","FY 2011-12",null,"PEI",null,null,0]
[null,17,"","FY 2012-13",null,"PEI",null,null,0]
[null,18,"","FY 2013-14",null,"PEI",null,null,0]
[null,19,"","FY 2014-15",null,"PEI",null,null,0]
[null,20,"","FY 2015-16",null,"PEI",null,null,0]
[null,21,"","FY 2006-07",null,"INN",null,null,0]
[null,22,"","FY 2007-08",null,"INN",null,null,0]
[null,23,"","FY 2008-09",null,"INN",null,null,0]
[null,24,"","FY 2009-10",null,"INN",null,null,0]
[null,25,"","FY 2010-11",null,"INN",null,null,0]
[null,26,"","FY 2011-12",null,"INN",null,null,0]
[null,27,"","FY 2012-13",null,"INN",null,null,0]
[null,28,"","FY 2013-14",null,"INN",null,null,0]
[null,29,"","FY 2014-15",null,"INN",null,null,0]
[null,30,"","FY 2015-16",null,"INN",null,null,0]
[null,31,"","FY 2006-07",null,"WET",null,null,0]
[null,32,"","FY 2007-08",null,"WET",null,null,0]
[null,33,"","FY 2008-09",null,"WET",null,null,0]
[null,34,"","FY 2009-10",null,"WET",null,null,0]
[null,35,"","FY 2010-11",null,"WET",null,null,0]
[null,36,"","FY 2011-12",null,"WET",null,null,0]
[null,37,"","FY 2012-13",null,"WET",null,null,0]
[null,38,"","FY 2013-14",null,"WET",null,null,0]
[null,39,"","FY 2014-15",null,"WET",null,null,0]
[null,40,"","FY 2015-16",null,"WET",null,null,0]

{"sheet":"11. Comments","index":12,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Back to Summary"]
[]
[null,"Annual Mental Health Services Act Revenue and Expenditure Report          "]
[null,"Fiscal Year 2016-17"]
[null,"Comments"]
[]
[null,null,"Comments"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]

{"sheet":"drop down fields","index":13,"n_rows":60,"n_cols":13,"rows_kept":60,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Info_County_Code",null,"Info_Population","CSS_Service_Category","PEI_Combined_Standalone","PEI_Program_Type","INN_Expenditure_Type","WET_Funding_Category","CFTN_Project_Type","Adjustment_MHSA_Component","Adjustment_FY","Adjustment_Reason","Cost_Report_Stage"]
["Alameda",1,"Yes","FSP","Combined","Prevention","Project","Workforce Staffing","Capital Facility","CSS","FY 2006-07","Cost Report Reconciliation","Audited"]
["Alpine",2,"No","Non-FSP","Standalone","Early Intervention","Project Administration","Training/Technical Assistance","Technological Need","PEI","FY 2007-08","Cost Report Audit","Settled"]
["Amador",3,null,null,null,"Outreach","Project Evaluation","MH Career Pathways",null,"INN","FY 2008-09","SDMC Chart Audit","Initial"]
["Berkeley City",65,null,null,null,"Stigma & Discrimination Reduction",null,"Residency/Internship",null,"WET","FY 2009-10","Local Quality Assurance Audit"]
["Butte",4,null,null,null,"Suicide Prevention",null,"Financial Incentive",null,"CFTN","FY 2010-11","Error"]
["Calaveras",5,null,null,null,"Access and Linkage",null,null,null,"TTACB","FY 2011-12","Other"]
["Colusa",6,null,null,null,"Improving Timely Access",null,null,null,"WET RP","FY 2012-13"]
["Contra Costa",7,null,null,null,"Combined Summary",null,null,null,"PEI SW","FY 2013-14"]
["Del Norte",8,null,null,null,null,null,null,null,"MHSA HP","FY 2014-15"]
["El Dorado",9,null,null,null,null,null,null,null,null,"FY 2015-16"]
["Fresno",10,null,null,null,null,null,null,null,null,"FY 2016-17"]
["Glenn",11]
["Humboldt",12]
["Imperial",13]
["Inyo",14]
["Kern",15]
["Kings",16]
["Lake",17]
["Lassen",18]
["Los Angeles",19]
["Madera",20]
["Marin",21]
["Mariposa",22]
["Mendocino",23]
["Merced",24]
["Modoc",25]
["Mono",26]
["Monterey",27]
["Napa",28]
["Nevada",29]
["Orange",30]
["Placer",31]
["Plumas",32]
["Riverside",33]
["Sacramento",34]
["San Benito",35]
["San Bernardino",36]
["San Diego",37]
["San Francisco",38]
["San Joaquin",39]
["San Luis Obispo",40]
["San Mateo",41]
["Santa Barbara",42]
["Santa Clara",43]
["Santa Cruz",44]
["Shasta",45]
["Sierra",46]
["Siskiyou",47]
["Solano",48]
["Sonoma",49]
["Stanislaus",50]
["Sutter/Yuba",63]
["Tehama",52]
["Tri-City",66]
["Trinity",53]
["Tulare",54]
["Tuolumne",55]
["Ventura",56]
["Yolo",57]

{"sheet":"E-1 CountyState2017","index":14,"n_rows":82,"n_cols":5,"rows_kept":82,"cut":false,"hidden":false,"merged":[[4,1,4,2],[1,0,1,4],[2,0,2,4]]}
[null,null,null,"About the Data"]
["E-1: State/County Population Estimates with Annual Percent Change"]
["January 1, 2016 and 2017"]
[]
["State/County","           Total Population",null,"Percent"]
[null,"2016-01-01","2017-01-01","Change","County Population:  Over 200,000? (Yes or No)"]
[]
["California",39189035,39523613,0.9]
[]
["Alameda",1629233,1645359,1,{"$f":"IF(B10>=200000,\"Yes\", \"No\")","v":"Yes"}]
["Alpine",1160,1151,-0.8,{"$f":"IF(B11>=200000,\"Yes\", \"No\")","v":"No"}]
["Amador",37667,38382,1.9,"No"]
["Butte",224703,226404,0.8,"Yes"]
["Calaveras",45246,45168,-0.2,"No"]
["Colusa",21965,22043,0.4,"No"]
["Contra Costa",1126824,1139513,1.1000000000000001,"Yes"]
["Del Norte",27006,27124,0.4,"No"]
["El Dorado",184371,185062,0.4,"No"]
["Fresno",985079,995975,1.1000000000000001,"Yes"]
["Glenn",28639,28731,0.3,"No"]
["Humboldt",135557,136953,1,"No"]
["Imperial",186080,188334,1.2,"No"]
["Inyo",18632,18619,-0.1,"No"]
["Kern",886803,895112,0.9,"Yes"]
["Kings",149822,149537,-0.2,"No"]
["Lake",64790,64945,0.2,"No"]
["Lassen",30841,30918,0.2,"No"]
["Los Angeles",10182961,10241278,0.6,"Yes"]
["Madera",154933,156492,1,"No"]
["Marin",263150,263604,0.2,"Yes"]
["Mariposa",18167,18148,-0.1,"No"]
["Mendocino",88771,89134,0.4,"No"]
["Merced",271547,274665,1.1000000000000001,"Yes"]
["Modoc",9620,9580,-0.4,"No"]
["Mono",13654,13713,0.4,"No"]
["Monterey",438171,442365,1,"Yes"]
["Napa",141888,142408,0.4,"No"]
["Nevada",98609,98828,0.2,"No"]
["Orange",3172152,3194024,0.7,"Yes"]
["Placer",376203,382837,1.8,"Yes"]
["Plumas",19837,19819,-0.1,"No"]
["Riverside",2348213,2384783,1.6,"Yes"]
["Sacramento",1496619,1514770,1.2,"Yes"]
["San Benito",56621,56854,0.4,"No"]
["San Bernardino",2135724,2160256,1.1000000000000001,"Yes"]
["San Diego",3286717,3316192,0.9,"Yes"]
["San Francisco",864889,874228,1.1000000000000001,"Yes"]
["San Joaquin",735677,746868,1.5,"Yes"]
["San Luis Obispo",278480,280101,0.6,"Yes"]
["San Mateo",765895,770203,0.6,"Yes"]
["Santa Barbara",447295,450663,0.8,"Yes"]
["Santa Clara",1922619,1938180,0.8,"Yes"]
["Santa Cruz",275557,276603,0.4,"Yes"]
["Shasta",178232,178605,0.2,"No"]
["Sierra",3194,3207,0.4,"No"]
["Siskiyou",44722,44688,-0.1,"No"]
["Solano",430972,436023,1.2,"Yes"]
["Sonoma",502604,505120,0.5,"Yes"]
["Stanislaus",541466,548057,1.2,"Yes"]
["Sutter",96614,96956,0.4,"No"]
["Tehama",63942,63995,0.1,"No"]
["Trinity",13647,13628,-0.1,"No"]
["Tulare",466563,471842,1.1000000000000001,"Yes"]
["Tuolumne",54949,54707,-0.4,"No"]
["Ventura",853893,857386,0.4,"Yes"]
["Yolo",215522,218896,1.6,"Yes"]
["Yuba",74328,74577,0.3,"No"]
["Sutter/Yuba",{"$f":"B60+B67","v":170942},{"$f":"C60+C67","v":171533},null,"No"]
["Berkeley City",119997,121238,null,"No"]
["Tri-City",{"$f":"B72+B73+B74","v":387546},{"$f":"C72+C73+C74","v":391983},null,"Yes"]
[]
["Carlsbad",112866,113725]
["Oceanside",175842,176461]
["Vista",98838,101797]
[]
[]
["Department of Finance"]
["Demographic Research Unit"]
["Phone: (916) 323-4086"]
[]
["For more information:  http://www.dof.ca.gov/research/demographic/reports/estimates/e-1/view.php"]
["Released on May 1, 2017"]