{"text_format":"3","workbook":"xlsx","n_sheets":24,"sheets":["DHCS Only","1. Information","Instructions 1. Information","2. Component Summary","Instructions 2. Component Summa","3. CSS","Instructions 3. CSS","4. PEI","Instructions 4. PEI","5. INN","Instructions 5. INN","6. WET","Instructions 6. WET","7. CFTN","Instructions 7. CFTN","8. Adjustment (MHSA)","Instructions 8. Adjust (MHSA)","9. Adjustment (FFP)","Instructions 9. Adjust (FFP)","10. Comments","Instructions 10. Comments","Checks","drop down fields","E-1 CountyState2017"],"not_rendered":{"macros":1,"external_links":2,"defined_names":133,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"DHCS Only","index":0,"n_rows":3,"n_cols":1,"rows_kept":3,"hidden":true}
["For DHCS use only."]
["Click button to lock or unlock all sheets for editing. "]
["This tab should be hidden when not in use. "]

{"sheet":"1. Information","index":1,"n_rows":20,"n_cols":5,"rows_kept":20}
["Press UP or DOWN arrow to read through table. Use UP or DOWN arrow to read through document. Press LEFT or RIGHT arrow to input needed information. ","STATE OF CALIFORNIA",null,null,"Department of Health Care Services"]
[null,"HEALTH AND HUMAN SERVICES AGENCY"]
[]
[null,"DHCS 1822 A (02/19)"]
[null,"Annual Mental Health Services Act (MHSA) Revenue and Expenditure Report"]
[null,{"$f":"\"Fiscal Year: \"&D10","v":"Fiscal Year: 2018-19"}]
[null,"Information Worksheet"]
[]
[null,1,"Date:","2019-12-10"]
[null,2,"ARER Fiscal Year (20YY-YY):","2018-19"]
[null,3,"County:","Kings"]
[null,4,"County Code:",{"$f":"IF(ISBLANK(D11),\"\",VLOOKUP(D11,Info_County_Code,2))","v":16}]
[null,5,"Address:","460 Kings County Dr. Ste. 101"]
[null,6,"City:","Hanford"]
[null,7,"Zip:",93230]
[null,8,"County Population:  Over 200,000? (Yes or No)",{"$f":"IF(ISBLANK(D11),\"\",VLOOKUP(D11,County_Population,5,FALSE))","v":"No"}]
[null,9,"Name of Preparer:","Matthew Boyett"]
[null,10,"Title of Preparer:","Fiscal Analyst III"]
[null,11,"Preparer Contact Email:","matthew.boyett@co.kings.ca.us"]
[null,12,"Preparer Contact Telephone:","(559) 852-2438"]

{"sheet":"Instructions 1. Information","index":2,"n_rows":13,"n_cols":1,"rows_kept":13}
["Press UP or DOWN arrow to read through the instructions."]
["Row 1: Enter the date when the ARER was completed."]
["Row 2: Enter the reporting fiscal year for the ARER. "]
["Row 3: Selection Only. Select the name of the County for which this ARER was prepared from the pull-down menu in the response cell."]
["Row 4: No entry. This field will auto populate. The County code is consistent with the coding system used in the Data Collection and Reporting system."]
["Row 5: Enter the administrative headquarters address for the County Mental Health or Behavioral Health Department as appropriate."]
["Row 6: Enter the administrative headquarters city for the County Mental Health or Behavioral Health Department as appropriate."]
["Row 7: Enter the administrative headquarters zip code for the County Mental Health or Behavioral Health Department as appropriate."]
["Row 8: No entry. This field will auto-populate “Yes” if the County’s population is equal to or greater than 200,000 or “No” if the County’s population is less than 200,000. Population data is available at: http://dof.ca.gov/Forecasting/Demographics/Estimates/E-1/"]
["Row 9: Enter the name of the person who prepared the ARER or is responsible for responding to inquiries about the ARER."]
["Row 10: Enter the title of the person who prepared the ARER or is responsible for responding to inquiries about the ARER."]
["Row 11: Enter the contact Email address of the person who prepared the ARER or is responsible for responding to inquiries about the ARER."]
["Row 12: Enter the contact telephone number of the person who prepared the ARER or is responsible for responding to inquiries about the ARER."]

{"sheet":"2. Component Summary","index":3,"n_rows":46,"n_cols":10,"rows_kept":46}
["Press UP or DOWN arrow to navigate through section tables. Press UP and DOWN arrow to read expenditure types. Press LEFT or RIGHT arrow on each row to input funding amounts.","STATE OF CALIFORNIA",{"$nulls":6},"Department of Health Care Services"]
[null,"HEALTH AND HUMAN SERVICES AGENCY"]
[]
[null,"DHCS 1822 B (02/19)"]
[null,{"$f":"'1. Information'!B5","v":"Annual Mental Health Services Act (MHSA) Revenue and Expenditure Report"}]
[null,{"$f":"'1. Information'!B6","v":"Fiscal Year: 2018-19"}]
[null,"Component Summary Worksheet"]
[]
[null,"County:",{"$f":"IF(ISBLANK('1. Information'!D11),\"\",'1. Information'!D11)","v":"Kings"},null,null,"Date:",{"$f":"IF(ISBLANK('1. Information'!D9),\"\",'1. Information'!D9)","v":"2019-12-10"}]
[]
[]
[{"$nulls":3},"A","B","C","D","E","F"]
[null,"SECTION 1: Interest",null,"CSS","PEI","INN","WET","CFTN","TOTAL"]
[null,1,"Component Interest Earned",{"v":149764.24,"d":"$149,764.24"},{"v":10018.53,"d":"$10,018.53"},{"v":49545.1,"d":"$49,545.10"},{"v":0,"d":"$0.00"},{"v":15604.81,"d":"$15,604.81"},{"$f":"SUM(D14:H14)","v":{"v":224932.68,"d":"$224,932.68"}}]
[null,2,"Joint Powers Authority Interest Earned",{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"SUM(D15:H15)","v":{"v":0,"d":"$0.00"}}]
[]
[{"$nulls":3},"A","B","C"]
[null,"SECTION 2: Prudent Reserve",null,"CSS","PEI","TOTAL"]
[null,3,"Local Prudent Reserve Beginning Balance",null,null,{"v":2138118,"d":"$2,138,118.00"}]
[null,4,"Transfer from Local Prudent Reserve",{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"-D20-E20","v":{"v":0,"d":"$0.00"}}]
[null,5,"CSS Funds Transferred to Local Prudent Reserve",{"$f":"'3. CSS'!F24","v":{"v":0,"d":"$0.00"}},null,{"$f":"SUM(D21:E21)","v":{"v":0,"d":"$0.00"}}]
[null,6,"Local Prudent Reserve Adjustments",null,null,{"$f":"SUM('8. Adjustment (MHSA)'!F51:F80)","v":{"v":0,"d":"$0.00"}}]
[null,7,"Local Prudent Reserve Ending Balance",null,null,{"$f":"F19+F20+F21+F22","v":{"v":2138118,"d":"$2,138,118.00"}}]
[]
[{"$nulls":3},"A","B","C","D","E","F"]
[null,"SECTION 3: CSS Transfers to PEI, WET, CFTN, or Prudent Reserve",null,"CSS","PEI","WET","CFTN","PR","TOTAL"]
[null,8,"Transfers",{"$f":"(E27+F27+G27+H27)*-1","v":{"v":0,"d":"$0.00"}},{"$f":"'3. CSS'!F21","v":{"v":0,"d":"$0.00"}},{"$f":"'3. CSS'!F22","v":{"v":0,"d":"$0.00"}},{"$f":"'3. CSS'!F23","v":{"v":0,"d":"$0.00"}},{"$f":"'3. CSS'!F24","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(D27:H27)","v":{"v":0,"d":"$0.00"}},{"$f":"IF(SUM(D27:H27)=I27,\"\",\"ERROR\")","v":""}]
[]
[{"$nulls":3},"A","B","C","D","E","F"]
[null,"SECTION 4: Program Expenditures and Sources of Funding",null,"CSS","PEI","INN","WET","CFTN","TOTAL"]
[null,9,"MHSA Funds",{"$f":"'3. CSS'!F27","v":{"v":8515725.52,"d":"$8,515,725.52"}},{"$f":"'4. PEI'!F22","v":{"v":2098318.11,"d":"$2,098,318.11"}},{"$f":"'5. INN'!F23","v":{"v":40897.93,"d":"$40,897.93"}},{"$f":"'6. WET'!F21","v":{"v":0,"d":"$0.00"}},{"$f":"'7. CFTN'!F21","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(D31:H31)","v":{"v":10654941.559999999,"d":"$10,654,941.56"}}]
[null,10,"Medi-Cal FFP",{"$f":"'3. CSS'!G27","v":{"v":0,"d":"$0.00"}},{"$f":"'4. PEI'!G22","v":{"v":0,"d":"$0.00"}},{"$f":"'5. INN'!G23","v":{"v":0,"d":"$0.00"}},{"$f":"'6. WET'!G21","v":{"v":0,"d":"$0.00"}},{"$f":"'7. CFTN'!G21","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[null,11,"1991 Realignment",{"$f":"'3. CSS'!H27","v":{"v":0,"d":"$0.00"}},{"$f":"'4. PEI'!H22","v":{"v":0,"d":"$0.00"}},{"$f":"'5. INN'!H23","v":{"v":0,"d":"$0.00"}},{"$f":"'6. WET'!H21","v":{"v":0,"d":"$0.00"}},{"$f":"'7. CFTN'!H21","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[null,12,"Behavioral Health Subaccount",{"$f":"'3. CSS'!I27","v":{"v":0,"d":"$0.00"}},{"$f":"'4. PEI'!I22","v":{"v":0,"d":"$0.00"}},{"$f":"'5. INN'!I23","v":{"v":0,"d":"$0.00"}},{"$f":"'6. WET'!I21","v":{"v":0,"d":"$0.00"}},{"$f":"'7. CFTN'!I21","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[null,13,"Other",{"$f":"'3. CSS'!J27","v":{"v":209493.38,"d":"$209,493.38"}},{"$f":"'4. PEI'!J22","v":{"v":494111.94999999995,"d":"$494,111.95"}},{"$f":"'5. INN'!J23","v":{"v":0,"d":"$0.00"}},{"$f":"'6. WET'!J21","v":{"v":0,"d":"$0.00"}},{"$f":"'7. CFTN'!J21","v":{"v":0,"d":"$0.00"}},{"v":703605.33,"d":"$703,605.33"}]
[null,14,"TOTAL",{"$f":"SUM(D31:D35)","v":{"v":8725218.9,"d":"$8,725,218.90"}},{"$f":"SUM(E31:E35)","v":{"v":2592430.0599999996,"d":"$2,592,430.06"}},{"v":40897.93,"d":"$40,897.93"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"SUM(D36:H36)","v":{"v":11358546.89,"d":"$11,358,546.89"}}]
[]
[{"$nulls":3},"A"]
[null,"SECTION 5: Miscellaneous MHSA Costs and Expenditures",null,"TOTAL"]
[null,15,"Total Annual Planning Costs",{"$f":"'3. CSS'!K15+'4. PEI'!K15+'5. INN'!K15+'6. WET'!K15+'7. CFTN'!K15","v":{"v":0,"d":"$0.00"}}]
[null,16,"Total Evaluation Costs",{"$f":"'3. CSS'!F16+'4. PEI'!F16+'5. INN'!F20+'6. WET'!F16+'7. CFTN'!F16","v":{"v":27155,"d":"$27,155.00"}}]
[null,17,"Total Administration",{"$f":"'3. CSS'!F17+'4. PEI'!F17+'5. INN'!F16+'5. INN'!F19+'6. WET'!F17+'7. CFTN'!F17","v":{"v":2914294.18,"d":"$2,914,294.18"}}]
[null,18,"Total WET RP"]
[null,19,"Total PEI SW",{"$f":"'4. PEI'!F18","v":{"v":179839.59,"d":"$179,839.59"}}]
[null,20,"Total MHSA HP"]
[null,21,"Total Mental Health Services For Veterans",{"v":5400,"d":"$5,400.00"}]

{"sheet":"Instructions 2. Component Summa","index":4,"n_rows":80,"n_cols":1,"rows_kept":80}
["Use UP or DOWN arrow to navigate spreadsheet. "]
["County: No entry. This field will auto-populate from the Information worksheet."]
["Date: No entry. This field will auto-populate from the Information worksheet."]
["Row 1, Column A: Enter the amount of interest earned on MHSA funds that is attributable to the CSS Account."]
["Row 1, Column B: Enter the amount of interest earned on MHSA funds that is attributable to the PEI Account."]
["Row 1, Column C: Enter the amount of interest earned on MHSA funds that is attributable to the INN Account."]
["Row 1, Column D: Enter the amount of interest earned on MHSA funds that is attributable to the WET Account."]
["Row 1, Column E: Enter the amount of interest earned on MHSA funds that is attributable to the CFTN Account."]
["Row 1, Column F: No entry. This amount is the sum of Row 1, Columns A-E."]
["Row 1, Interest Earned: report interest earned on the local MHS Fund, by Account where applicable. Use one of the following methods to determine the amount of interest to apportion to each Account:\n1. Actual interest earned by Account\n2. Share of funding by Account "]
["Row 2, Column A: Enter the amount of interest earned on MHSA funds transferred to the JPA that is attributable to the CSS Account."]
["Row 2, Column B: Enter the amount of interest earned on MHSA funds transferred to the JPA that is attributable to the PEI Account."]
["Row 2, Column C: Enter the amount of interest earned on MHSA funds transferred to the JPA that is attributable to the INN Account."]
["Row 2, Column D: Enter the amount of interest earned on MHSA funds transferred to the JPA that is attributable to the WET Account."]
["Row 2, Column E: Enter the amount of interest earned on MHSA funds transferred to the JPA that is attributable to the CFTN Account."]
["Row 2, Column F: No entry. This amount is the sum of Row 2, Columns A-E."]
["Row 3, Column A: This cell is blank."]
["Row 3, Column B: This cell is blank."]
["Row 3, Column C: Enter the beginning balance of the Prudent Reserve. This amount must match the Prudent Reserve ending balance reported in the prior year's ARER."]
["Row 4, Column A: Enter the amount of funds transferred from the Prudent Reserve to the CSS Account."]
["Row 4, Column B: Enter the amount of funds transferred from the Prudent Reserve to the PEI Account."]
["Row 4, Column C: No entry. This amount is the sum of Row 4, Columns A-B. The amount will reflect as a negative amount."]
["Row 5, Column A: No entry. Data will autopopulate from Worksheet 3. CSS, Row 10, Column A."]
["Row 5, Column B: This cell is blank."]
["Row 5, Column C: No entry. Data will autopopulate from Row 5, Column A."]
["Row 6, Column A: This cell is blank."]
["Row 6, Column B: This cell is blank."]
["Row 6, Column C: No entry. Data will autopopulate from Worksheet 8. Adjustment (MHSA), Section Three, Row 1-30, Column D. "]
["Row 7, Column A: This cell is blank."]
["Row 7, Column B: This cell is blank."]
["Row 7, Column C: No entry. This amount is the sum of Row 3, Column C, Row 4 Column C, Row 5 Column C, and Row 6 Column C."]
["Row 8, Column A: No entry. Data will autopopulate from the Worksheet 3. CSS and is the sum of Row 7 Column A, Row 8 Column A, Row 9 Column A, and Row 10 Column A. The amount will reflect as a negative amount."]
["Row 8, Column B: No entry. Data will auto populate from Worksheet 3. CSS, Row 7, Column A."]
["Row 8, Column C: No entry. Data will auto populate from Worksheet 3. CSS, Row 8, Column A."]
["Row 8, Column D: No entry. Data will auto populate from Worksheet 3. CSS, Row 9, Column A."]
["Row 8, Column E: No entry. Data will auto populate from Worksheet 3. CSS, Row 10, Column A."]
["Row 8, Column F: No entry. This amount is the sum of Row 8, Columns A-E."]
["Row 9, Column A: No entry. Data will auto populate from Worksheet 3. CSS, Row 13, Column A."]
["Row 9, Column B: No entry. Data will auto populate from Worksheet 4. PEI, Row 8, Column A."]
["Row 9, Column C: No entry. Data will auto populate from Worksheet 5. INN, Row 9, Column A."]
["Row 9, Column D: No entry. Data will auto populate from Worksheet 6. WET, Row 7, Column A."]
["Row 9, Column E: No entry. Data will auto populate from Worksheet 7. CFTN, Row 5, Column A."]
["Row 9, Column F: No entry. This amount is the sum of Row 9, Columns A-E."]
["Row 10, Column A: No entry. Data will auto populate from Worksheet 3. CSS, Row 13, Column B."]
["Row 10, Column B: No entry. Data will auto populate from Worksheet 4. PEI, Row 8, Column B."]
["Row 10, Column C: No entry. Data will auto populate from Worksheet 5. INN, Row 9, Column B."]
["Row 10, Column D: No entry. Data will auto populate from Worksheet 6. WET, Row 7, Column B."]
["Row 10, Column E: No entry. Data will auto populate from Worksheet 7. CFTN, Row 5, Column B."]
["Row 10, Column F: No entry. This amount is the sum of Row 10, Columns A-E."]
["Row 11, Column A: No entry. Data will auto populate from Worksheet 3. CSS, Row 13, Column C."]
["Row 11, Column B: No entry. Data will auto populate from Worksheet 4. PEI, Row 8, Column C."]
["Row 11, Column C: No entry. Data will auto populate from Worksheet 5. INN, Row 9, Column C."]
["Row 11, Column D: No entry. Data will auto populate from Worksheet 6. WET, Row 7, Column C."]
["Row 11, Column E: No entry. Data will auto populate from Worksheet 7. CFTN, Row 5, Column C."]
["Row 11, Column F: No entry. This amount is the sum of Row 11, Columns A-E."]
["Row 12, Column A: No entry. Data will auto populate from Worksheet 3. CSS, Row 13, Column D."]
["Row 12, Column B: No entry. Data will auto populate from Worksheet 4. PEI, Row 8, Column D."]
["Row 12, Column C: No entry. Data will auto populate from Worksheet 5. INN, Row 9, Column D."]
["Row 12, Column D: No entry. Data will auto populate from Worksheet 6. WET, Row 7, Column D."]
["Row 12, Column E: No entry. Data will auto populate from Worksheet 7. CFTN, Row 5, Column D."]
["Row 12, Column F: No entry. This amount is the sum of Row 12, Columns A-E."]
["Row 13, Column A: No entry. Data will auto populate from Worksheet 3. CSS, Row 13, Column E."]
["Row 13, Column B: No entry. Data will auto populate from Worksheet 4. PEI, Row 8, Column E."]
["Row 13, Column C: No entry. Data will auto populate from Worksheet 5. INN, Row 9, Column E."]
["Row 13, Column D: No entry. Data will auto populate from Worksheet 6. WET, Row 7, Column E."]
["Row 13, Column E: No entry. Data will auto populate from Worksheet 7. CFTN, Row 5, Column E."]
["Row 13, Column F: No entry. This amount is the sum of Row 13, Columns A-E."]
["Row 14, Column A: No entry. This amount is the sum of Rows 9-13, Column A. "]
["Row 14, Column B: No entry. This amount is the sum of Rows 9-13, Column B. "]
["Row 14, Column C: No entry. This amount is the sum of Rows 9-13, Column C. "]
["Row 14, Column D: No entry. This amount is the sum of Rows 9-13, Column D. "]
["Row 14, Column E: No entry. This amount is the sum of Rows 9-13, Column E. "]
["Row 14, Column F: No entry. This amount is the sum of Row 9, Column A-E. "]
["Row 15, Column A: No entry. This amount is the sum of Worksheet 3. CSS Row 1 Column A, Worksheet 4. PEI Row 1 Column A, Worksheet 5. INN Row 1 Column A, Worksheet 6. WET Row 1 Column A, and Worksheet 7. CFTN Row 1 Column A.  "]
["Row 16, Column A: No entry. This amount is the sum of Worksheet 3. CSS Row 2 Column A, Worksheet 4. PEI Row 2 Column A, Worksheet 5. INN Row 6 Column A, Worksheet 6. WET Row 2 Column A, and Worksheet 7. CFTN Row 2 Column A.  "]
["Row 17, Column A: No entry. This amount is the sum of Worksheet 3. CSS Row 3 Column A, Worksheet 4. PEI Row 3 Column A, Worksheet 5. INN Rows 2 and 5 Column A, Worksheet 6. WET Row 3 Column A, and Worksheet 7. CFTN Row 3 Column A.  "]
["Row 18, Column A: Enter the amount of WET Regional Partnership funds expended for goods or services during the reporting fiscal year."]
["Row 19, Column A: No entry. Data will auto populate from Worksheet 4. PEI, Section One, Row 4, Column A."]
["Row 20, Column A: Enter the amount of unencumbered MHSA Housing Program funds expended for goods or services, if applicable."]
["Row 21, Column A: Enter the total MHSA funds spent on mental health services provided to veterans for all programs and projects funded from the CSS, PEI, and INN accounts, combined. Enter $0 if there were no MHSA funds spent to provide services to veterans. Counties do not need to report MHSA funds spent on mental health services for veterans separately by component.  "]

{"sheet":"3. CSS","index":5,"n_rows":133,"n_cols":12,"rows_kept":133}
["Press UP or DOWN arrow to read through C S S spreadsheet. In section 1, use UP and DOWN arrow for different C S S expenditure types. Use LEFT or RIGHT arrow on these cell rows to input amount of funding type. In section 2, use LEFT or RIGHT arrow to navigate different headers. Use UP and DOWN arrow to input dollar amount designated for each column.","STATE OF CALIFORNIA",{"$nulls":9},"Department of Health Care Services"]
[null,"HEALTH AND HUMAN SERVICES AGENCY"]
[]
[null,"DHCS 1822 C (02/19)"]
[null,{"$f":"'1. Information'!B5","v":"Annual Mental Health Services Act (MHSA) Revenue and Expenditure Report"}]
[null,{"$f":"'1. Information'!B6","v":"Fiscal Year: 2018-19"}]
[null,"Community Services and Supports (CSS) Summary  Worksheet"]
[]
[null,"County:",null,{"$f":"IF(ISBLANK('1. Information'!D11),\"\",'1. Information'!D11)","v":"Kings"},null,"Date:",{"$f":"IF(ISBLANK('1. Information'!D9),\"\",'1. Information'!D9)","v":"2019-12-10"}]
[]
[null,"SECTION ONE"]
[]
[{"$nulls":5},"A","B","C","D","E","F"]
[{"$nulls":5},"Total MHSA Funds (Including Interest)","Medi-Cal FFP","1991 Realignment","Behavioral Health Subaccount","Other","Grand Total"]
[null,1,"CSS Annual Planning Costs",null,null,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"SUM(F15:J15)","v":{"v":0,"d":"$0.00"}}]
[null,2,"CSS Evaluation Costs",null,null,{"v":26247.5,"d":"$26,247.50"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"SUM(F16:J16)","v":{"v":26247.5,"d":"$26,247.50"}}]
[null,3,"CSS Administration Costs",null,null,{"v":1750972.05,"d":"$1,750,972.05"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":1750972.05,"d":"$1,750,972.05"}]
[null,4,"CSS Funds Transferred to JPA",null,null,{"v":0,"d":"$0.00"},{"$nulls":4},{"$f":"F18","v":{"v":0,"d":"$0.00"}}]
[null,5,"CSS Expenditures Incurred by JPA",null,null,{"v":0,"d":"$0.00"},{"$nulls":4},{"$f":"F19","v":{"v":0,"d":"$0.00"}}]
[null,6,"CSS Funds Transferred to CalHFA",null,null,{"v":0,"d":"$0.00"},{"$nulls":4},{"v":0,"d":"$0.00"}]
[null,7,"CSS Funds Transferred to PEI",null,null,{"v":0,"d":"$0.00"},{"$nulls":4},{"v":0,"d":"$0.00"}]
[null,8,"CSS Funds Transferred to WET",null,null,{"v":0,"d":"$0.00"},{"$nulls":4},{"v":0,"d":"$0.00"}]
[null,9,"CSS Funds Transferred to CFTN",null,null,{"v":0,"d":"$0.00"},{"$nulls":4},{"v":0,"d":"$0.00"}]
[null,10,"CSS Funds Transferred to PR",null,null,{"v":0,"d":"$0.00"},{"$nulls":4},{"v":0,"d":"$0.00"}]
[null,11,"CSS Program Expenditures",null,null,{"$f":"SUM(G34:G133)","v":{"v":6738505.97,"d":"$6,738,505.97"}},{"$f":"SUM(H34:H133)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(I34:I133)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(J34:J133)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(K34:K133)","v":{"v":209493.38,"d":"$209,493.38"}},{"$f":"SUM(F25:J25)","v":{"v":6947999.35,"d":"$6,947,999.35"}}]
[null,12,"Total CSS Expenditures (Excluding Funds Transferred to JPA)",null,null,{"$f":"SUM(F15:F17,F19:F25)","v":{"v":8515725.52,"d":"$8,515,725.52"}},{"$f":"SUM(G15:G17,G25)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(H15:H17,H25)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(I15:I17,I25)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(J15:J17,J25)","v":{"v":209493.38,"d":"$209,493.38"}},{"$f":"SUM(F26:J26)","v":{"v":8725218.9,"d":"$8,725,218.90"}}]
[null,13,"Total CSS Expenditures (Excluding Funds Transferred to JPA, PEI, WET, CFTN and PR)",null,null,{"$f":"SUM(F15:F17,F19,F20,F25)","v":{"v":8515725.52,"d":"$8,515,725.52"}},{"$f":"SUM(G15:G17,G25)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(H15:H17,H25)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":209493.38,"d":"$209,493.38"},{"$f":"SUM(F27:J27)","v":{"v":8725218.9,"d":"$8,725,218.90"}}]
[]
[]
[null,"SECTION TWO"]
[]
[null,null,"A","B","C","D","E","F","G","H","I","J"]
[null,"#","County Code","Program Name","Prior Program Name","Program Type","Total MHSA Funds (Including Interest)","Medi-Cal FFP","1991 Realignment","Behavioral Health Subaccount","Other","Grand Total"]
[null,14,{"$f":"IF(L34<>0,VLOOKUP($D$9,Info_County_Code,2,FALSE),\"\")","v":16},"Wraparound Services-Children/TAY FSP",null,"FSP",{"$f":"1225473.16-209493.38","v":{"v":1015979.7799999999,"d":"$1,015,979.78"}},{"$nulls":3},{"v":209493.38,"d":"$209,493.38"},{"$f":"SUM(G34:K34)","v":{"v":1225473.16,"d":"$1,225,473.16"}}]
[null,15,16,"Parent-Child Interaction Therapy (PCIT)",null,"Non-FSP",{"v":8592.27,"d":"$8,592.27"},{"$nulls":4},{"$f":"SUM(G35:K35)","v":{"v":8592.27,"d":"$8,592.27"}}]
[null,16,16,"Intensive Case Management/Outpatient Prog.",null,"Non-FSP",{"v":1860064.95,"d":"$1,860,064.95"},{"$nulls":4},{"$f":"SUM(G36:K36)","v":{"v":1860064.95,"d":"$1,860,064.95"}}]
[null,17,16,"Assertive Community Treatment",null,"FSP",{"v":484789.85,"d":"$484,789.85"},{"$nulls":4},{"v":484789.85,"d":"$484,789.85"}]
[null,18,16,"Full Service Partnership for Adults/Older Adults",null,"FSP",{"v":1665114.68,"d":"$1,665,114.68"},{"$nulls":4},{"v":1665114.68,"d":"$1,665,114.68"}]
[null,19,16,"Collaborative Justice Treatment Court",null,"Non-FSP",{"v":444587.63,"d":"$444,587.63"},{"$nulls":4},{"v":444587.63,"d":"$444,587.63"}]
[null,20,16,"MH Services for Domestic Violence Survivors",null,"Non-FSP",260796.06,{"$nulls":4},{"v":260796.06,"d":"$260,796.06"}]
[null,21,16,"KARELink",null,"Non-FSP",{"v":833110.88,"d":"$833,110.88"},{"$nulls":4},{"v":833110.88,"d":"$833,110.88"}]
[null,22,16,"Outreach and Engagement","O&E Multi-Service Centers","Non-FSP",{"v":114545.32,"d":"$114,545.32"},{"$nulls":4},{"v":114545.32,"d":"$114,545.32"}]
[null,23,16,"CSS MHSA Housing Program Assigned Funds",null,"Non-FSP",{"v":50924.55,"d":"$50,924.55"},{"$nulls":4},{"v":50924.55,"d":"$50,924.55"}]
[null,24,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,25,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,26,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,27,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,28,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,29,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,30,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,31,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,32,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,33,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,34,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,35,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,36,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,37,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,38,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,39,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,40,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,41,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,42,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,43,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,44,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,45,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,46,{"$f":"IF(L66<>0,VLOOKUP($D$9,Info_County_Code,2,FALSE),\"\")","v":""},{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,47,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,48,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,49,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,50,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,51,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,52,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,53,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,54,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,55,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,56,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,57,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,58,"",{"$nulls":8},{"$f":"SUM(G78:K78)","v":{"v":0,"d":"$0.00"}}]
[null,59,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,60,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,61,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,62,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,63,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,64,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,65,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,66,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,67,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,68,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,69,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,70,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,71,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,72,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,73,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,74,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,75,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,76,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,77,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,78,{"$f":"IF(L98<>0,VLOOKUP($D$9,Info_County_Code,2,FALSE),\"\")","v":""},{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,79,"",{"$nulls":8},{"$f":"SUM(G99:K99)","v":{"v":0,"d":"$0.00"}}]
[null,80,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,81,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,82,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,83,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,84,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,85,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,86,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,87,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,88,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,89,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,90,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,91,"",{"$nulls":8},{"$f":"SUM(G111:K111)","v":{"v":0,"d":"$0.00"}}]
[null,92,"",{"$nulls":8},{"$f":"SUM(G112:K112)","v":{"v":0,"d":"$0.00"}}]
[null,93,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,94,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,95,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,96,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,97,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,98,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,99,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,100,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,101,"",{"$nulls":8},{"$f":"SUM(G121:K121)","v":{"v":0,"d":"$0.00"}}]
[null,102,"",{"$nulls":8},{"$f":"SUM(G122:K122)","v":{"v":0,"d":"$0.00"}}]
[null,103,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,104,"",{"$nulls":8},{"$f":"SUM(G124:K124)","v":{"v":0,"d":"$0.00"}}]
[null,105,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,106,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,107,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,108,"",{"$nulls":8},{"$f":"SUM(G128:K128)","v":{"v":0,"d":"$0.00"}}]
[null,109,"",{"$nulls":8},{"$f":"SUM(G129:K129)","v":{"v":0,"d":"$0.00"}}]
[null,110,"",{"$nulls":8},{"$f":"SUM(G130:K130)","v":{"v":0,"d":"$0.00"}}]
[null,111,"",{"$nulls":8},{"$f":"SUM(G131:K131)","v":{"v":0,"d":"$0.00"}}]
[null,112,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,113,"",{"$nulls":8},{"v":0,"d":"$0.00"}]

{"sheet":"Instructions 3. CSS","index":6,"n_rows":91,"n_cols":1,"rows_kept":91}
["Use UP or DOWN arrow to navigate spreadsheet. "]
["County: No entry. This field will auto-populate from the Information worksheet."]
["Date: No entry. This field will auto-populate from the Information worksheet."]
["Row 1, Column A: Enter the amount of MHSA funds, including interest, expended for CSS Annual Planning."]
["Row 1, Column B: Enter the amount of Medi-Cal FFP funds expended for CSS Annual Planning."]
["Row 1, Column C: Enter the amount of 1991 Realignment funds expended for CSS Annual Planning."]
["Row 1, Column D: Enter the amount of Behavioral Health Subaccount funds expended for CSS Annual Planning."]
["Row 1, Column E: Enter the amount of Other funds expended for CSS Annual Planning. Other funds include funding from sources not otherwise identified such as from local General Fund or other local sources, or from sources such as Federal grants or other grants."]
["Row 1, Column F: No entry. This amount is the sum of Row 1, Columns A-E."]
["Row 2, Column A: Enter the amount of MHSA funds, including interest, expended for CSS Evaluation."]
["Row 2, Column B: Enter the amount of Medi-Cal FFP funds expended for CSS Evaluation."]
["Row 2, Column C: Enter the amount of 1991 Realignment funds expended for CSS Evaluation."]
["Row 2, Column D: Enter the amount of Behavioral Health subaccount funds expended for CSS Evaluation."]
["Row 2, Column E: Enter the amount of Other funds expended for CSS Evaluation."]
["Row 2, Column F: No entry. This amount is the sum of Row 2, Columns A-E."]
["Row 3, Column A: Enter the amount of MHSA funds, including interest, expended for CSS Administration. This amount should include direct administrative costs and an appropriate allocation of indirect costs. Direct administrative costs are administrative costs that only benefit CSS programs or services. Indirect administrative costs are those administrative costs that are incurred for a common or joint purpose and cannot be readily identified as benefiting only one MHSA component. Counties must use an appropriate allocation method to allocate indirect costs to the CSS Account. The share of costs attributed to the CSS Account  should be in proportion to the extent the CSS programs or services benefit from the support activity. Counties must maintain proper documentation of the allocation methodology used to allocate indirect costs to administration of CSS programs or services. To avoid double-counting, do not include costs incurred as both Administration Costs and either Annual Planning Costs, Evaluation Costs or Program Expenditures."]
["Row 3, Column B: This cell is blank."]
["Row 3, Column C: This cell is blank."]
["Row 3, Column D: This cell is blank."]
["Row 3, Column E: This cell is blank."]
["Row 3, Column F: No entry. This amount is equal to Row 3, Column A."]
["Row 4, Column A: Enter the amount of MHSA funds, including interest, transferred to a Joint Powers Authority (JPA) for CSS programs."]
["Row 4, Column B: This cell is blank."]
["Row 4, Column C: This cell is blank."]
["Row 4, Column D: This cell is blank."]
["Row 4, Column E: This cell is blank."]
["Row 4, Column F: No entry. This amount is equal to Row 4, Column A."]
["Row 5, Column A: Enter the amount of MHSA funds, including interest, expended by a JPA on behalf of the County during the reporting fiscal year for authorized CSS goods or services. Funds reported here as transferred will not increase the Total CSS Expenditures (Row 12)."]
["Row 5, Column B: This cell is blank."]
["Row 5, Column C: This cell is blank."]
["Row 5, Column D: This cell is blank."]
["Row 5, Column E: This cell is blank."]
["Row 5, Column F: No entry. This amount is equal to Row 5, Column A."]
["Row 6, Column A: Enter the amount of MHSA funds, including interest, transferred to CalHFA during the reporting fiscal year for the Special Needs Housing Program (SNHP). CalHFA operates the SNHP on behalf of jurisdictions throughout California. The SNHP allows local governments to use Mental Health Services Act (MHSA) funds and other local funds, as appropriate, to provide financing for the development of permanent supportive rental housing that includes units dedicated for individuals with serious mental illness, and their families, who are homeless or at risk of homelessness. Participation requires a completed SNHP Participation Agreement between CalHFA and the County."]
["Row 6, Column B: This cell is blank."]
["Row 6, Column C: This cell is blank."]
["Row 6, Column D: This cell is blank."]
["Row 6, Column E: This cell is blank."]
["Row 6, Column F: No entry. This amount is equal to Row 6, Column A."]
["Row 7, Column A: Enter the amount of MHSA funds, including interest, transferred from the CSS account to PEI during the reporting fiscal year."]
["Row 7, Column B: This cell is blank."]
["Row 7, Column C: This cell is blank."]
["Row 7, Column D: This cell is blank."]
["Row 7, Column E: This cell is blank."]
["Row 7, Column F: No entry. This amount is equal to Row 7, Column A."]
["Row 8, Column A: Enter the amount of MHSA funds, including interest, transferred from the CSS account to WET during the reporting fiscal year."]
["Row 8, Column B: This cell is blank."]
["Row 8, Column C: This cell is blank."]
["Row 8, Column D: This cell is blank."]
["Row 8, Column E: This cell is blank."]
["Row 8, Column F: No entry. This amount is equal to Row 8, Column A."]
["Row 9, Column A: Enter the amount of MHSA funds, including interest, transferred from the CSS account to CFTN during the reporting fiscal year."]
["Row 9, Column B: This cell is blank."]
["Row 9, Column C: This cell is blank."]
["Row 9, Column D: This cell is blank."]
["Row 9, Column E: This cell is blank."]
["Row 9, Column F: No entry. This amount is equal to Row 9, Column A."]
["Row 10, Column A: Enter the amount of MHSA funds, including interest, transferred from the CSS account to Prudent Reserve during the reporting fiscal year."]
["Row 10, Column B: This cell is blank."]
["Row 10, Column C: This cell is blank."]
["Row 10, Column D: This cell is blank."]
["Row 10, Column E: This cell is blank."]
["Row 10, Column F: No entry. This amount is equal to Row 10, Column A."]
["Row 11, Column A: No entry. This amount is equal to Rows 14-113, Column E. "]
["Row 11, Column B: No entry. This amount is equal to Rows 14-113, Column F."]
["Row 11, Column C: No entry. This amount is equal to Rows 14-113, Column G."]
["Row 11, Column D: No entry. This amount is equal to Rows 14-113, Column H."]
["Row 11, Column E: No entry. This amount is equal to Rows 14-113, Column I."]
["Row 11, Column F: No entry. This amount is equal to the sum of Row 11, Columns A-E. "]
["Row 12, Column A: No entry. This amount is equal to the sum of Rows 1-3 and 5-11, Column A."]
["Row 12, Column B: No entry. This amount is equal to the sum of Rows 1-3 and 11, Column B."]
["Row 12, Column C: No entry. This amount is equal to the sum of Rows 1-3 and 11, Column C."]
["Row 12, Column D: No entry. This amount is equal to the sum of Rows 1-3 and 11, Column D."]
["Row 12, Column E: No entry. This amount is equal to the sum of Rows 1-3 and 11, Column E."]
["Row 12, Column F: No entry. This amount is equal to the sum of Row 12, Columns A-E."]
["Row 13, Column A: No entry. This amount is equal to the sum of Rows 1-3, 5-6, and 11, Column A."]
["Row 13: Column B: No entry. This amount is equal to the sum of Rows 1-3 and 11, Column B."]
["Row 13: Column C: No entry. This amount is equal to the sum of Rows 1-3 and 11, Column C."]
["Row 13: Column D: No entry. This amount is equal to the sum of Rows 1-3 and 11, Column D."]
["Row 13: Column E: No entry. This amount is equal to the sum of Rows 1-3 and 11, Column E."]
["Row 13: Column F: No entry. This amount is equal to the sum of Row 13, Columns A-E."]
["Rows 14-113, Column A: No entry. This field auto-populates as the County enters expenditure data and is determined according to the County Name entered on  Worksheet 1. Information, Row 3. The County Code corresponds to the numeric ID code used to identify the County in the Data Collection and Reporting system."]
["Rows 14-113 Column B: Enter the Program name for each CSS program funded by the CSS Account. Program name must be consistent with Program Name provided in the most recent MHSA Three-Year Program and Expenditure Plan or Annual Update covering the same Fiscal Year. If a County has changed the name of a Program subsequent to publication of the relevant Three-Year Program and Expenditure Plan or Annual Update, the County must provide the name change on worksheet 10. Comments."]
["Rows 14-113, Column C: If the Program name is identical to the Program name reported in the prior year ARER or this is a new program this reporting year, no entry. If the Program name has changed from what was reported on the prior year ARER, enter the name used to identify this Program in the prior year ARER. If this program represents a combination of two or more programs formerly reported separately, or if this program was formerly combined with another Program, leave this field blank, but provide a comment on the Worksheet 10. "]
["Rows 14-113, Column D: Selection only. Select the program type from the drop-down menu. Options are Full-Service Partnership (FSP) or non-Full-Service Partnership (Non-FSP). Non-FSP includes General System Development and Outreach and Engagement programs."]
["Rows 14-113, Column E: Enter the amount of MHSA funds, including Interest, expended for goods and services delivered in each CSS program during the reporting fiscal year."]
["Rows 14-113, Column F: Enter the amount of Medi-Cal FFP funds expended for goods and services delivered in each CSS program during the reporting fiscal year."]
["Rows 14-113, Column G: Enter the amount of 1991 Realignment funds expended for goods and services delivered in each CSS program during the reporting fiscal year."]
["Rows 14-113, Column H: Enter the amount of Behavioral Health Subaccount funds expended for goods and services delivered in each CSS program during the reporting fiscal year."]
["Rows 14-113, Column I: Enter the amount of Other funds expended for goods and services delivered in each CSS program during the reporting fiscal year. "]
["Rows 14-113, Column J: No entry. This field represents the sum of Rows 14-113, Columns E-I ."]

{"sheet":"4. PEI","index":7,"n_rows":133,"n_cols":19,"rows_kept":133}
["Press UP or DOWN arrow to read through P E I spreadsheet. In section 1, use the UP and DOWN arrow for different P E I expenditure types. Use LEFT or RIGHT arrow on these cell rows to input amount of funding type. In section 2, use LEFT or RIGHT and UP and DOWN arrows to navigate headers. In section 3, use LEFT or RIGHT arrows to navigate headers for P E I program components on the header rows. Use UP or DOWN arrows to read each Program Name and LEFT or RIGHT arrows on the rows below the headers to input dollar amount needed. ","STATE OF CALIFORNIA",{"$nulls":14},"Department of Health Care Services"]
[null,"HEALTH AND HUMAN SERVICES AGENCY"]
[]
[null,"DHCS 1822 D (02/19)"]
[null,{"$f":"'1. Information'!B5","v":"Annual Mental Health Services Act (MHSA) Revenue and Expenditure Report"}]
[null,{"$f":"'1. Information'!B6","v":"Fiscal Year: 2018-19"}]
[null,"Prevention and Early Intervention (PEI) Summary Worksheet"]
[]
[null,"County:",null,{"$f":"IF(ISBLANK('1. Information'!D11),\"\",'1. Information'!D11)","v":"Kings"},{"$f":"IF(ISBLANK('1. Information'!D11),\"\",'1. Information'!D11)","v":"Kings"},"Date:",{"$f":"IF(ISBLANK('1. Information'!D9),\"\",'1. Information'!D9)","v":"2019-12-10"}]
[]
[null,"SECTION ONE"]
[]
[{"$nulls":5},"A","B","C","D","E","F"]
[{"$nulls":5},"Total MHSA Funds (Including Interest)","Medi-Cal FFP","1991 Realignment","Behavioral Health Subaccount","Other","Grand Total"]
[null,1,"PEI Annual Planning Costs",null,null,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"SUM(F15:J15)","v":{"v":0,"d":"$0.00"}}]
[null,2,"PEI Evaluation Costs",null,null,{"v":907.5,"d":"$907.50"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"SUM(F16:J16)","v":{"v":907.5,"d":"$907.50"}}]
[null,3,"PEI Administration Costs",null,null,{"v":1153254.97,"d":"$1,153,254.97"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":1153254.97,"d":"$1,153,254.97"}]
[null,4,"PEI Funds Expended by CalMHSA for PEI Statewide ",null,null,{"v":179839.59,"d":"$179,839.59"},{"$nulls":4},{"$f":"F18","v":{"v":179839.59,"d":"$179,839.59"}}]
[null,5,"PEI Funds Transferred to JPA",null,null,{"v":0,"d":"$0.00"},{"$nulls":4},{"$f":"F19","v":{"v":0,"d":"$0.00"}}]
[null,6,"PEI Expenditures Incurred by JPA",null,null,{"v":0,"d":"$0.00"},{"$nulls":4},{"v":0,"d":"$0.00"}]
[null,7,"PEI Program Expenditures",null,null,{"$f":"SUMIF($G$34:$G$133,\"Combined Summary\",L$34:L$133) + SUMIF($F$34:$F$133,\"Standalone\",L$34:L$133)","v":{"v":944155.64,"d":"$944,155.64"}},{"$f":"SUMIF($G$34:$G$133,\"Combined Summary\",M$34:M$133) + SUMIF($F$34:$F$133,\"Standalone\",M$34:M$133)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIF($G$34:$G$133,\"Combined Summary\",N$34:N$133) + SUMIF($F$34:$F$133,\"Standalone\",N$34:N$133)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIF($G$34:$G$133,\"Combined Summary\",O$34:O$133) + SUMIF($F$34:$F$133,\"Standalone\",O$34:O$133)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIF($G$34:$G$133,\"Combined Summary\",P$34:P$133) + SUMIF($F$34:$F$133,\"Standalone\",P$34:P$133)","v":{"v":494111.94999999995,"d":"$494,111.95"}},{"v":1438267.5899999999,"d":"$1,438,267.59"}]
[null,8,"Total PEI Expenditures (Excluding Transfers and PEI Statewide)",null,null,{"$f":"SUM(F15:F17,F20:F21)","v":{"v":2098318.11,"d":"$2,098,318.11"}},{"$f":"SUM(G15:G17,G20:G21)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":494111.94999999995,"d":"$494,111.95"},{"v":2592430.0599999996,"d":"$2,592,430.06"}]
[]
[null,"SECTION TWO"]
[]
[{"$nulls":4},"A","B"]
[{"$nulls":4},"Percent Expended for Clients Age 25 and Under, All PEI","Percent Expended for Clients Age 25 and Under, JPA"]
[null,9,null,"MHSA PEI Fund Expenditures in Program to Clients Age 25 and Under (calculated from weighted program values) divided by Total MHSA PEI Expenditures",{"$f":"IF(F22=0,\"0%\",((SUMPRODUCT($K$34:$K$133,$L$34:$L$133)+(F20*F28))/$F$22))","v":{"v":0.22947873065824131,"d":"22.95%"}},{"v":0,"d":"0.00%"}]
[]
[null,"SECTION THREE"]
[]
[null,null,"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O"]
[null,"#","County Code","Program Name","Prior Program Name","Combined/Standalone Program","Program Type","Program Activity Name (in Combined Program)","Subtotal Percentage for Combined Program","Percent of PEI Expended on Clients Age 25 & Under (Standalone and Program Activities in Combined Program)","Percent of PEI Expended on Clients Age 25 & Under (Combined Summary and Standalone)","Total MHSA Funds (Including Interest)","Medi-Cal FFP","1991 Realignment","Behavioral Health Subaccount","Other","Grand Total","Check"]
[null,10,{"$f":"IF(AND(NOT(COUNTA(D34:J34)),(NOT(COUNTA(L34:P34)))),\"\",VLOOKUP($D$9,Info_County_Code,2,FALSE))","v":16},"School Based Services",null,"Standalone","Prevention",null,{"v":1,"d":"100%"},{"v":0.51,"d":"51%"},{"$f":"IF(OR(G34=\"Combined Summary\",F34=\"Standalone\"),(SUMPRODUCT(--(D$34:D$133=D34),I$34:I$133,J$34:J$133)),\"\")","v":{"v":0.51,"d":"51.0%"}},{"$f":"194745.58-123527.98","v":{"v":71217.59999999999,"d":"$71,217.60"}},{"$nulls":3},{"v":123527.98,"d":"$123,527.98"},{"$f":"SUM(L34:P34)","v":{"v":194745.58,"d":"$194,745.58"}},{"$f":"IF(OR(G34=\"Combined Summary\",F34=\"Standalone\"),(SUMIF(D$34:D$133,D34,I$34:I$133)),\"\")","v":{"v":1,"d":"100%"}},{"$f":"IF(AND(F34=\"Standalone\",NOT(R34=1)),\"ERROR\",IF(AND(G34=\"Combined Summary\",NOT(R34=1)),\"ERROR\",\"\"))","v":""}]
[null,11,16,"Therapeutic Activity Groups",null,"Standalone","Prevention",null,{"v":1,"d":"100%"},{"v":0.51,"d":"51%"},{"$f":"IF(OR(G35=\"Combined Summary\",F35=\"Standalone\"),(SUMPRODUCT(--(D$34:D$133=D35),I$34:I$133,J$34:J$133)),\"\")","v":{"v":0.51,"d":"51.0%"}},{"v":250.98,"d":"$250.98"},{"$nulls":4},{"$f":"SUM(L35:P35)","v":{"v":250.98,"d":"$250.98"}},{"$f":"IF(OR(G35=\"Combined Summary\",F35=\"Standalone\"),(SUMIF(D$34:D$133,D35,I$34:I$133)),\"\")","v":{"v":1,"d":"100%"}},{"$f":"IF(AND(F35=\"Standalone\",NOT(R35=1)),\"ERROR\",IF(AND(G35=\"Combined Summary\",NOT(R35=1)),\"ERROR\",\"\"))","v":""}]
[null,12,16,"Truancy Intervention Program",null,"Standalone","Prevention",null,{"v":1,"d":"100%"},{"v":0.51,"d":"51%"},{"v":0.51,"d":"51.0%"},{"v":87281.93,"d":"$87,281.93"},{"$nulls":4},{"v":87281.93,"d":"$87,281.93"},{"v":1,"d":"100%"},""]
[null,13,16,"Early Intervention Clinical Services",null,"Standalone","Early Intervention",null,{"v":1,"d":"100%"},{"v":0.51,"d":"51%"},{"v":0.51,"d":"51.0%"},{"v":90181.12,"d":"$90,181.12"},{"$nulls":4},{"v":90181.12,"d":"$90,181.12"},{"v":1,"d":"100%"},""]
[null,14,16,"Senior Access for Engagement",null,"Standalone","Access and Linkage",null,{"v":1,"d":"100%"},{"v":0.51,"d":"51%"},{"v":0.51,"d":"51.0%"},{"$f":"252385.33-200000","v":{"v":52385.32999999999,"d":"$52,385.33"}},{"$nulls":3},{"v":200000,"d":"$200,000.00"},{"v":252385.33,"d":"$252,385.33"},{"v":1,"d":"100%"},""]
[null,15,16,"Respite for Caregivers",null,"Standalone","Access and Linkage",null,{"v":1,"d":"100%"},{"v":0.51,"d":"51%"},{"v":0.51,"d":"51.0%"},{"v":95265.88,"d":"$95,265.88"},{"$nulls":4},{"v":95265.88,"d":"$95,265.88"},{"v":1,"d":"100%"},""]
[null,16,16,"Prevention and Wellness",null,"Standalone","Prevention",null,{"v":1,"d":"100%"},{"v":0.51,"d":"51%"},{"v":0.51,"d":"51.0%"},{"$f":"203756.38-123527.98","v":{"v":80228.40000000001,"d":"$80,228.40"}},{"$nulls":3},{"v":123527.98,"d":"$123,527.98"},{"v":203756.38,"d":"$203,756.38"},{"v":1,"d":"100%"},""]
[null,17,16,"Outreach and Engagement/Training",null,"Standalone","Outreach",null,{"v":1,"d":"100%"},{"v":0.51,"d":"51%"},{"v":0.51,"d":"51.0%"},{"v":15045.23,"d":"$15,045.23"},{"$nulls":4},{"v":15045.23,"d":"$15,045.23"},{"v":1,"d":"100%"},""]
[null,18,16,"Community Wide Engagement",null,"Standalone","Outreach",null,{"v":1,"d":"100%"},{"v":0.51,"d":"51%"},{"v":0.51,"d":"51.0%"},{"v":108294.72,"d":"$108,294.72"},{"$nulls":4},{"v":108294.72,"d":"$108,294.72"},{"v":1,"d":"100%"},""]
[null,19,16,"Stigma and Discrimination Reduction",null,"Standalone","Stigma & Discrimination Reduction",null,{"v":1,"d":"100%"},{"v":0.51,"d":"51%"},{"v":0.51,"d":"51.0%"},{"v":108162.81,"d":"$108,162.81"},{"$nulls":4},{"v":108162.81,"d":"$108,162.81"},{"v":1,"d":"100%"},""]
[null,20,16,"Access and Linkage",null,"Standalone","Access and Linkage",null,{"v":1,"d":"100%"},{"v":0.51,"d":"51%"},{"v":0.51,"d":"51.0%"},{"v":115165.35,"d":"$115,165.35"},{"$nulls":4},{"v":115165.35,"d":"$115,165.35"},{"v":1,"d":"100%"},""]
[null,21,16,"Suicide Prevention","Suicide Prevention Task Force","Standalone","Suicide Prevention",null,{"v":1,"d":"100%"},{"v":0.51,"d":"51%"},{"v":0.51,"d":"51.0%"},{"$f":"167732.28-47055.99","v":{"v":120676.29000000001,"d":"$120,676.29"}},{"$nulls":3},{"v":47055.99,"d":"$47,055.99"},{"v":167732.28,"d":"$167,732.28"},{"v":1,"d":"100%"},""]
[null,22,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,23,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,24,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,25,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,26,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,27,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,28,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,29,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,30,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,31,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,32,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,33,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,34,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,35,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,36,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,37,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,38,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,39,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,40,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,41,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,42,{"$f":"IF(AND(NOT(COUNTA(D66:J66)),(NOT(COUNTA(L66:P66)))),\"\",VLOOKUP($D$9,Info_County_Code,2,FALSE))","v":""},{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,43,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,44,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,45,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,46,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,47,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,48,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,49,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,50,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,51,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,52,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,53,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,54,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,55,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,56,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,57,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,58,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,59,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,60,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,61,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,62,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,63,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,64,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,65,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,66,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,67,"",{"$nulls":7},"",{"$nulls":5},{"$f":"SUM(L91:P91)","v":{"v":0,"d":"$0.00"}},"",""]
[null,68,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,69,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,70,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,71,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,72,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,73,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,74,{"$f":"IF(AND(NOT(COUNTA(D98:J98)),(NOT(COUNTA(L98:P98)))),\"\",VLOOKUP($D$9,Info_County_Code,2,FALSE))","v":""},{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,75,"",{"$nulls":7},{"$f":"IF(OR(G99=\"Combined Summary\",F99=\"Standalone\"),(SUMPRODUCT(--(D$34:D$133=D99),I$34:I$133,J$34:J$133)),\"\")","v":""},{"$nulls":5},{"$f":"SUM(L99:P99)","v":{"v":0,"d":"$0.00"}},{"$f":"IF(OR(G99=\"Combined Summary\",F99=\"Standalone\"),(SUMIF(D$34:D$133,D99,I$34:I$133)),\"\")","v":""},{"$f":"IF(AND(F99=\"Standalone\",NOT(R99=1)),\"ERROR\",IF(AND(G99=\"Combined Summary\",NOT(R99=1)),\"ERROR\",\"\"))","v":""}]
[null,76,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,77,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,78,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,79,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,80,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,81,"",{"$nulls":7},"",{"$nulls":5},{"$f":"SUM(L105:P105)","v":{"v":0,"d":"$0.00"}},"",""]
[null,82,"",{"$nulls":7},"",{"$nulls":5},{"$f":"SUM(L106:P106)","v":{"v":0,"d":"$0.00"}},"",""]
[null,83,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,84,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,85,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,86,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,87,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,88,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,89,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,90,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,91,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,92,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,93,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,94,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,95,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,96,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,97,"",{"$nulls":7},"",{"$nulls":5},{"$f":"SUM(L121:P121)","v":{"v":0,"d":"$0.00"}},"",""]
[null,98,"",{"$nulls":7},"",{"$nulls":5},{"$f":"SUM(L122:P122)","v":{"v":0,"d":"$0.00"}},"",""]
[null,99,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,100,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,101,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,102,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,103,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,104,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,105,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,106,{"$f":"IF(AND(NOT(COUNTA(D130:J130)),(NOT(COUNTA(L130:P130)))),\"\",VLOOKUP($D$9,Info_County_Code,2,FALSE))","v":""},{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,107,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,108,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]
[null,109,"",{"$nulls":7},"",{"$nulls":5},{"v":0,"d":"$0.00"},"",""]

{"sheet":"Instructions 4. PEI","index":8,"n_rows":68,"n_cols":1,"rows_kept":68}
["Use UP or DOWN arrow to navigate spreadsheet. "]
["County: No entry. This field will auto-populate from the Information worksheet."]
["Date: No entry. This field will auto-populate from the Information worksheet."]
["Row 1, Column A: Enter the amount of MHSA funds, including interest, expended for PEI Annual Planning."]
["Row 1, Column B: Enter the amount of Medi-Cal FFP funds expended for PEI Annual Planning."]
["Row 1, Column C: Enter the amount of 1991 Realignment funds expended for PEI Annual Planning."]
["Row 1, Column D: Enter the amount of Behavioral Health Subaccount funds expended for PEI Annual Planning."]
["Row 1, Column E: Enter the amount of Other funds expended for PEI Annual Planning. Other funds include funding from sources not otherwise identified such as from local General Fund or other local sources, or from sources such as Federal grants or other grants."]
["Row 1, Column F: No entry. This amount is the sum of Row 1, Columns A-E."]
["Row 2, Column A: Enter the amount of MHSA funds, including interest, expended for PEI Evaluation."]
["Row 2, Column B: Enter the amount of Medi-Cal FFP funds expended for PEI Evaluation."]
["Row 2, Column C: Enter the amount of 1991 Realignment funds expended for PEI Evaluation."]
["Row 2, Column D: Enter the amount of Behavioral Health Subaccount funds expended for PEI Evaluation."]
["Row 2, Column E: Enter the amount of Other funds expended for PEI Evaluation."]
["Row 2, Column F: No entry. This amount is the sum of Row 2, Columns A-E."]
["Row 3, Column A: Enter the amount of MHSA funds, including interest, expended for PEI Administration. This amount should include direct administrative costs and an appropriate allocation of indirect costs. Direct administrative costs are administrative costs that only benefit PEI programs or services. Indirect administrative costs are those administrative costs that are incurred for a common or joint purpose and cannot be readily identified as benefiting only one MHSA component. Counties must use an appropriate allocation method to allocate indirect costs to the PEI Account. The share of costs attributed to the PEI Account  should be in proportion to the extent the PEI programs or services benefit from the support activity. Counties must maintain proper documentation of the allocation methodology used to allocate indirect costs to administration of PEI programs or services. To avoid double-counting, do not include costs incurred as both Administration Costs and either Annual Planning Costs, Evaluation Costs or Program Expenditures."]
["Row 3, Column B: Enter the amount of Medi-Cal FFP funds expended for PEI Administration."]
["Row 3, Column C: Enter the amount of 1991 Realignment funds expended for PEI Administration."]
["Row 3, Column D: Enter the amount of Behavioral Health Subaccount funds expended for PEI Administration."]
["Row 3, Column E: Enter the amount of Other funds expended for PEI Administration."]
["Row 3, Column F: No entry. This amount is the sum of Row 3, Columns A-E."]
["Row 4, Column A: Enter the amount of MHSA funds, including interest, expended by CalMHSA on behalf of the County for authorized PEI Statewide Projects during the reporting fiscal year. PEI Statewide Project funding was made available to counties in FY 2008-09 through FY 2011-12. To avoid double counting, funds reported here as expended will not be included in Row 8, Column A. They are reported separately on Worksheet 2. Component Summary, Row 19, Column A. "]
["Row 4, Column B: This cell is blank."]
["Row 4, Column C: This cell is blank."]
["Row 4, Column D: This cell is blank."]
["Row 4, Column E: This cell is blank."]
["Row 4, Column F: No entry. This amount is equal to Row 4, Column A."]
["Row 5, Column A: Enter the amount of MHSA funds, including interest, transferred to a Joint Powers Authority (JPA) for PEI programs."]
["Row 5, Column B: This cell is blank."]
["Row 5, Column C: This cell is blank."]
["Row 5, Column D: This cell is blank."]
["Row 5, Column E: This cell is blank."]
["Row 5, Column F: No entry. This amount is equal to Row 5, Column A."]
["Row 6, Column A: Enter the amount of MHSA funds, including interest, expended by a JPA on behalf of the County during the reporting fiscal year for authorized PEI programs. Transfers of MHSA PEI funds made to a JPA for State-Level Projects should not be reflected as PEI Funds Expended by CalMHSA for PEI Statewide (Row 4). Funds reported here as transferred will not increase the Total PEI Expenditures (Row 8)."]
["Row 6, Column B: This cell is blank."]
["Row 6, Column C: This cell is blank."]
["Row 6, Column D: This cell is blank."]
["Row 6, Column E: This cell is blank."]
["Row 6, Column F: No entry. This amount is equal to Row 6, Column A."]
["Row 7, Column A: No entry. This amount is equal to the sum of Rows 10-109, Column J"]
["Row 7, Column B: No entry. This amount is equal to the sum of Rows 10-109, Column K."]
["Row 7, Column C: No entry. This amount is equal to the sum of Rows 10-109, Column L."]
["Row 7, Column D: No entry. This amount is equal to the sum of Rows 10-109, Column M."]
["Row 7, Column E: No entry. This amount is equal to the sum of Rows 10-109, Column N."]
["Row 7, Column F: No entry. This amount is equal to the sum of Row 7, Columns A-E."]
["Row 8, Column A: No entry. This amount is equal to the sum of Rows 1-3 and 6-7, Column A."]
["Row 8, Column B: No entry. This amount is equal to the sum of Rows 1-3 and 6-7, Column B."]
["Row 8, Column C: No entry. This amount is equal to the sum of Rows 1-3 and 6-7, Column C."]
["Row 8, Column D: No entry. This amount is equal to the sum of Rows 1-3 and 6-7, Column D."]
["Row 8, Column E: No entry. This amount is equal to the sum of Rows 1-3 and 6-7, Column E."]
["Row 8, Column F: No entry. This amount is equal to the sum of Row 8, Columns A-E."]
["Row 9, Column A: No entry. This amount is equal to the sum of Rows 10-109, Column I divided by Row 8, Column A. Per California Code of Regulations (CCR), title 9, section 3706(a), counties are required to serve all ages in one or more PEI programs. Per section 3706(b), counties are required to use at least 51 percent of the Prevention and Early Intervention Fund to serve individuals who are 25 years old or younger. Per section 3760(c), programs that serve parents, caregivers, or family members with the goal of addressing MHSA outcomes for children or youth at risk of or with early onset of a mental illness can be counted as meeting this requirement.  A County with population under 200,000 that meets certain conditions may opt out of this requirement (CCR Title 9, Section 3706(d)). "]
["Row 9, Column B: Enter the estimated percentage of funding reported in Row 6, Column A, that were expended in support of clients aged 25 and under."]
["Rows 10-109, Column A: No entry. This field auto-populates as the County enters expenditure data and is determined according to the County Name entered on  Worksheet 1. Information, Row 3. The County Code corresponds to the numeric ID code used to identify the County in the Data Collection and Reporting system."]
["Rows 10-109, Column B: Enter the Program name for each PEI program funded by the PEI Account. Program name must be consistent with Program Name provided in the most recent MHSA Three-Year Program and Expenditure Plan or Annual Update covering the same Fiscal Year. Each Standalone and Combined Program must have a unique name to ensure the calculation in Column H  functions properly. If a County has changed the name of a Program subsequent to publication of the relevant Three-Year Program and Expenditure Plan or Annual Update, the County must provide the name change on worksheet 10. Comments."]
["Rows 10-109, Column C: If the Program name is identical to the Program name reported in the prior year ARER or this is a new program this reporting year, no entry. If the Program name has changed from what was reported on the prior year ARER, enter the name used to identify this Program in the prior year ARER. If this program represents a combination of two or more programs formerly reported separately, or if this program was formerly combined with another Program, leave this field blank, but provide a comment on the Worksheet 10. "]
["Rows 10-109, Column D: Selection only. Select the  program type. Options are Combined or Standalone. If the row data refers to a Program Activity within a Combined Program or to summary information for a Combined Program, select Combined. Otherwise, select Standalone. Counties may combine an Early Intervention Program with a Prevention Program as long as the requirements in CCR, Sections 3710 and 3720 are met."]
["Rows 10-109, Column E: Selection only. Identify the program type for each program and program activity funded with PEI funds. Options include Early Intervention Program (CCR, Section 3710), Outreach for Increasing Recognition of Early Signs of Mental Illness (CCR Section 3715), Prevention Program (CCR Section 3720), Stigma and Discrimination Reduction Program (CCR Section 3725), Access and Linkage to Treatment Program (CCR Section 3726), Suicide Prevention Programs (CCR Section 3730), Improving Timely Access to Services for Underserved Populations (CCR 3735(a)(2)(A), or Combined Summary (CCR Section 3510.010(a)(1)(A)1.If the County provides for its Outreach for Increasing Recognition of Early Signs of Mental Illness Program through another MHSA component, explain on worksheet 10. Comments."]
["Rows 10-109, Column F: For Combined Programs, enter the name for each Program Activity row used to report data for the Combined Program. Do not enter data into this cell for Standalone programs and Combined Summary rows."]
["Rows 10-109, Column G: Enter an estimate of the percentage of MHSA PEI expenditures in a Combined Program dedicated to the selected Program Activity in the Program Type column (Column E). Enter a value between zero and 100. For Programs designated as Standalone in Column D, enter 100.  Do not enter data in this column for rows identified as program summary rows. The sum of percentages reported for Program Activities in a Combined Program must equal 100."]
["Rows 10-109, Column H: Enter an estimate of the percentage of Total MHSA Fund program expenditures (Column J) dedicated to clients age 25 and under. Enter as a value between zero and 100.  For Program Activities within a Combined Program, estimate the percentage of the Program Activity expenditures dedicated to serving clients age 25 and under. Leave blank if Column E is selected as Combined Summary."]
["Rows 10-109, Column I: No entry. The cell auto-populates from data entered in Column G and Column H. This cell displays the weighted average of the percentages reported for each of the Program Activities within the Combined Program. The weighted average is the sum of Columns G and H."]
["Rows 10-109, Column J: Enter the amount of MHSA PEI component funds, including interest, expended for goods and services delivered during the reporting year for each program. For a Combined Program, enter expenditure data only for the summary row (Program Type “Combined Summary” in Column E)."]
["Rows 10-109, Column K: Enter the amount of Medi-Cal FFP funds expended for goods and services delivered during the reporting year for each program. For a Combined Program, enter expenditure data only for the summary row (Program Type “Combined Summary” in Column E)."]
["Rows 10-109, Column L: Enter the amount of 1991 Realignment funds expended for goods and services delivered during the reporting year for each program. For a Combined Program, enter expenditure data only for the summary row (Program Type “Combined Summary” in Column E)."]
["Rows 10-109, Column M: Enter the amount of Behavioral Health Subaccount funds expended for goods and services delivered during the reporting year for each program. For a Combined Program, enter expenditure data only for the summary row (Program Type “Combined Summary” in Column E)."]
["Rows 10-109, Column N: Enter the amount of Other Funds expended for goods and services delivered during the reporting year for each program. For a Combined Program, enter expenditure data only for the summary row. "]
["Rows 10-109, Column O: No entry. This amount is the sum of Columns J-N. The Column should be blank for program activity rows within a combined program."]

{"sheet":"5. INN","index":9,"n_rows":128,"n_cols":17,"rows_kept":128}
["Press UP or DOWN arrow to read through I N N spreadsheet. In section 1, use UP and DOWN arrow for different I N N expenditure types. Use LEFT or RIGHT arrow on these cell rows to input amount of funding type. In section 2, use LEFT or RIGHT arrow to navigate different headers. Use UP and DOWN arrow to input necessary information designated for each column. ","STATE OF CALIFORNIA",{"$nulls":13},"Department of Health Care Services"]
[null,"HEALTH AND HUMAN SERVICES AGENCY"]
[]
[null,"DHCS 1822 E (02/19)"]
[null,{"$f":"'1. Information'!B5","v":"Annual Mental Health Services Act (MHSA) Revenue and Expenditure Report"}]
[null,{"$f":"'1. Information'!B6","v":"Fiscal Year: 2018-19"}]
[null,"Innovation (INN) Summary Worksheet"]
[]
[null,"County:",null,null,{"$f":"IF(ISBLANK('1. Information'!D11),\"\",'1. Information'!D11)","v":"Kings"},null,"Date:",{"$f":"IF(ISBLANK('1. Information'!D9),\"\",'1. Information'!D9)","v":"2019-12-10"}]
[]
[null,"SECTION ONE"]
[]
[{"$nulls":5},"A","B","C","D","E","F"]
[{"$nulls":5},"Total MHSA Fund (Including Interest)","Medi-Cal FFP","1991 Realignment","Behavioral Health Subaccount","Other","Grand Total"]
[null,1,"INN Annual Planning Costs",null,null,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"SUM(F15:J15)","v":{"v":0,"d":"$0.00"}}]
[null,2,"INN Indirect Administration",null,null,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"SUM(F16:J16)","v":{"v":0,"d":"$0.00"}}]
[null,3,"INN Funds Transferred to JPA",null,null,{"v":0,"d":"$0.00"},{"$nulls":4},{"$f":"F17","v":{"v":0,"d":"$0.00"}}]
[null,4,"INN Expenditures Incurred by JPA",null,null,{"v":0,"d":"$0.00"},{"$nulls":4},{"$f":"F18","v":{"v":0,"d":"$0.00"}}]
[null,5,"INN Project Administration",null,null,{"$f":"SUMIF($K$29:$K$128,\"Project Administration\",L$29:L$128)","v":{"v":10067.16,"d":"$10,067.16"}},{"$f":"SUMIF($K$29:$K$128,\"Project Administration\",M$29:M$128)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIF($K$29:$K$128,\"Project Administration\",N$29:N$128)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIF($K$29:$K$128,\"Project Administration\",O$29:O$128)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIF($K$29:$K$128,\"Project Administration\",P$29:P$128)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(F19:J19)","v":{"v":10067.16,"d":"$10,067.16"}}]
[null,6,"INN Project Evaluation",null,null,{"$f":"SUMIF($K$29:$K$128,\"Project Evaluation\",L$29:L$128)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIF($K$29:$K$128,\"Project Evaluation\",M$29:M$128)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIF($K$29:$K$128,\"Project Evaluation\",N$29:N$128)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIF($K$29:$K$128,\"Project Evaluation\",O$29:O$128)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIF($K$29:$K$128,\"Project Evaluation\",P$29:P$128)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[null,7,"INN Project Direct",null,null,{"$f":"SUMIF($K$29:$K$128,\"Project Direct\",L$29:L$128)","v":{"v":30830.77,"d":"$30,830.77"}},{"$f":"SUMIF($K$29:$K$128,\"Project Direct\",M$29:M$128)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIF($K$29:$K$128,\"Project Direct\",N$29:N$128)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIF($K$29:$K$128,\"Project Direct\",O$29:O$128)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIF($K$29:$K$128,\"Project Direct\",P$29:P$128)","v":{"v":0,"d":"$0.00"}},{"v":30830.77,"d":"$30,830.77"}]
[null,8,"INN Project Subtotal",null,null,{"$f":"SUM(F19:F21)","v":{"v":40897.93,"d":"$40,897.93"}},{"$f":"SUM(G19:G21)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(H19:H21)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(I19:I21)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(J19:J21)","v":{"v":0,"d":"$0.00"}},{"v":40897.93,"d":"$40,897.93"}]
[null,9,"Total Innovation Expenditures  (Excluding Transfers to JPA)",null,null,{"$f":"SUM(F15:F16,F18:F21)","v":{"v":40897.93,"d":"$40,897.93"}},{"$f":"SUM(G15:G16,G19:G21)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(H15:H16,H19:H21)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":40897.93,"d":"$40,897.93"}]
[]
[null,"SECTION TWO"]
[]
[{"$nulls":3},"A","B","C","D","E","F","G","H","I","J","K","L","M","N"]
[null,"#",null,"County Code","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 MHSA Funds (Including Interest)","Medi-Cal FFP","1991 Realignment","Behavioral Health Subaccount","Other","Grand Total"]
[null,10,"A",{"$f":"IF(Q32<>0,VLOOKUP($E$9,Info_County_Code,2,FALSE),\"\")","v":16},"MOST",null,"2018-09-27","2018-12-19",{"v":1663631,"d":"$1,663,631.00"},null,"Project Administration",{"v":10067.16,"d":"$10,067.16"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"SUM(L29:P29)","v":{"v":10067.16,"d":"$10,067.16"}}]
[null,10,"B",{"$f":"IF(ISBLANK(D29),\"\",D29)","v":16},"MOST","","2018-09-27","2018-12-19",{"v":1663631,"d":"$1,663,631.00"},"","Project Evaluation",{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"SUM(L30:P30)","v":{"v":0,"d":"$0.00"}}]
[null,10,"C",{"$f":"IF(ISBLANK(D29),\"\",D29)","v":16},"MOST","","2018-09-27","2018-12-19",{"v":1663631,"d":"$1,663,631.00"},"","Project Direct",{"v":30830.77,"d":"$30,830.77"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":30830.77,"d":"$30,830.77"}]
[null,10,"D",{"$f":"IF(ISBLANK(D29),\"\",D29)","v":16},"MOST","","2018-09-27","2018-12-19",{"v":1663631,"d":"$1,663,631.00"},"","Project Subtotal",{"$f":"SUM(L29:L31)","v":{"v":40897.93,"d":"$40,897.93"}},{"$f":"SUM(M29:M31)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(N29:N31)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":40897.93,"d":"$40,897.93"}]
[null,11,"A",{"$f":"IF(Q36<>0,VLOOKUP($E$9,Info_County_Code,2,FALSE),\"\")","v":""},{"$nulls":6},{"$f":"IF(NOT(ISBLANK(E33)),$K$29,\"\")","v":""},{"$nulls":5},{"$f":"SUM(L33:P33)","v":{"v":0,"d":"$0.00"}}]
[null,11,"B",{"$f":"IF(ISBLANK(D33),\"\",D33)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E33)),$K$30,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,11,"C",{"$f":"IF(ISBLANK(D33),\"\",D33)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E33)),$K$31,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,11,"D",{"$f":"IF(ISBLANK(D33),\"\",D33)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E33)),$K$32,\"\")","v":""},{"$f":"SUM(L33:L35)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(M33:M35)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(N33:N35)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[null,12,"A",{"$f":"IF(Q40<>0,VLOOKUP($E$9,Info_County_Code,2,FALSE),\"\")","v":""},{"$nulls":6},{"$f":"IF(NOT(ISBLANK(E37)),$K$29,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,12,"B",{"$f":"IF(ISBLANK(D37),\"\",D37)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E37)),$K$30,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,12,"C",{"$f":"IF(ISBLANK(D37),\"\",D37)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E37)),$K$31,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,12,"D",{"$f":"IF(ISBLANK(D37),\"\",D37)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E37)),$K$32,\"\")","v":""},{"$f":"SUM(L37:L39)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(M37:M39)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(N37:N39)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(O37:O39)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(P37:P39)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[null,13,"A",{"$f":"IF(Q44<>0,VLOOKUP($E$9,Info_County_Code,2,FALSE),\"\")","v":""},{"$nulls":6},{"$f":"IF(NOT(ISBLANK(E41)),$K$29,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,13,"B",{"$f":"IF(ISBLANK(D41),\"\",D41)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E41)),$K$30,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,13,"C",{"$f":"IF(ISBLANK(D41),\"\",D41)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E41)),$K$31,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,13,"D",{"$f":"IF(ISBLANK(D41),\"\",D41)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E41)),$K$32,\"\")","v":""},{"$f":"SUM(L41:L43)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(M41:M43)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(N41:N43)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(O41:O43)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(P41:P43)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[null,14,"A",{"$f":"IF(Q48<>0,VLOOKUP($E$9,Info_County_Code,2,FALSE),\"\")","v":""},{"$nulls":6},{"$f":"IF(NOT(ISBLANK(E45)),$K$29,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,14,"B",{"$f":"IF(ISBLANK(D45),\"\",D45)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E45)),$K$30,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,14,"C",{"$f":"IF(ISBLANK(D45),\"\",D45)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E45)),$K$31,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,14,"D",{"$f":"IF(ISBLANK(D45),\"\",D45)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E45)),$K$32,\"\")","v":""},{"$f":"SUM(L45:L47)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(M45:M47)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(N45:N47)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(O45:O47)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(P45:P47)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[null,15,"A",{"$f":"IF(Q52<>0,VLOOKUP($E$9,Info_County_Code,2,FALSE),\"\")","v":""},{"$nulls":6},{"$f":"IF(NOT(ISBLANK(E49)),$K$29,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,15,"B",{"$f":"IF(ISBLANK(D49),\"\",D49)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E49)),$K$30,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,15,"C",{"$f":"IF(ISBLANK(D49),\"\",D49)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E49)),$K$31,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,15,"D",{"$f":"IF(ISBLANK(D49),\"\",D49)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E49)),$K$32,\"\")","v":""},{"$f":"SUM(L49:L51)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(M49:M51)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(N49:N51)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(O49:O51)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(P49:P51)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[null,16,"A",{"$f":"IF(Q56<>0,VLOOKUP($E$9,Info_County_Code,2,FALSE),\"\")","v":""},{"$nulls":6},{"$f":"IF(NOT(ISBLANK(E53)),$K$29,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,16,"B",{"$f":"IF(ISBLANK(D53),\"\",D53)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E53)),$K$30,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,16,"C",{"$f":"IF(ISBLANK(D53),\"\",D53)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E53)),$K$31,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,16,"D",{"$f":"IF(ISBLANK(D53),\"\",D53)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E53)),$K$32,\"\")","v":""},{"$f":"SUM(L53:L55)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(M53:M55)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(N53:N55)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(O53:O55)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(P53:P55)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[null,17,"A",{"$f":"IF(Q60<>0,VLOOKUP($E$9,Info_County_Code,2,FALSE),\"\")","v":""},{"$nulls":6},{"$f":"IF(NOT(ISBLANK(E57)),$K$29,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,17,"B",{"$f":"IF(ISBLANK(D57),\"\",D57)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E57)),$K$30,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,17,"C",{"$f":"IF(ISBLANK(D57),\"\",D57)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E57)),$K$31,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,17,"D",{"$f":"IF(ISBLANK(D57),\"\",D57)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E57)),$K$32,\"\")","v":""},{"$f":"SUM(L57:L59)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(M57:M59)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(N57:N59)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(O57:O59)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(P57:P59)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[null,18,"A",{"$f":"IF(Q64<>0,VLOOKUP($E$9,Info_County_Code,2,FALSE),\"\")","v":""},{"$nulls":6},{"$f":"IF(NOT(ISBLANK(E61)),$K$29,\"\")","v":""},{"$nulls":5},{"$f":"SUM(L61:P61)","v":{"v":0,"d":"$0.00"}}]
[null,18,"B",{"$f":"IF(ISBLANK(D61),\"\",D61)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E61)),$K$30,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,18,"C",{"$f":"IF(ISBLANK(D61),\"\",D61)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E61)),$K$31,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,18,"D",{"$f":"IF(ISBLANK(D61),\"\",D61)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E61)),$K$32,\"\")","v":""},{"$f":"SUM(L61:L63)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(M61:M63)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(N61:N63)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(O61:O63)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(P61:P63)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[null,19,"A",{"$f":"IF(Q68<>0,VLOOKUP($E$9,Info_County_Code,2,FALSE),\"\")","v":""},{"$nulls":6},{"$f":"IF(NOT(ISBLANK(E65)),$K$29,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,19,"B",{"$f":"IF(ISBLANK(D65),\"\",D65)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E65)),$K$30,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,19,"C",{"$f":"IF(ISBLANK(D65),\"\",D65)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E65)),$K$31,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,19,"D",{"$f":"IF(ISBLANK(D65),\"\",D65)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E65)),$K$32,\"\")","v":""},{"$f":"SUM(L65:L67)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(M65:M67)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(N65:N67)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(O65:O67)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(P65:P67)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[null,20,"A",{"$f":"IF(Q72<>0,VLOOKUP($E$9,Info_County_Code,2,FALSE),\"\")","v":""},{"$nulls":6},{"$f":"IF(NOT(ISBLANK(E69)),$K$29,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,20,"B",{"$f":"IF(ISBLANK(D69),\"\",D69)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E69)),$K$30,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,20,"C",{"$f":"IF(ISBLANK(D69),\"\",D69)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E69)),$K$31,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,20,"D",{"$f":"IF(ISBLANK(D69),\"\",D69)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E69)),$K$32,\"\")","v":""},{"$f":"SUM(L69:L71)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(M69:M71)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(N69:N71)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(O69:O71)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(P69:P71)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[null,21,"A",{"$f":"IF(Q76<>0,VLOOKUP($E$9,Info_County_Code,2,FALSE),\"\")","v":""},{"$nulls":6},{"$f":"IF(NOT(ISBLANK(E73)),$K$29,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,21,"B",{"$f":"IF(ISBLANK(D73),\"\",D73)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E73)),$K$30,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,21,"C",{"$f":"IF(ISBLANK(D73),\"\",D73)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E73)),$K$31,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,21,"D",{"$f":"IF(ISBLANK(D73),\"\",D73)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E73)),$K$32,\"\")","v":""},{"$f":"SUM(L73:L75)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(M73:M75)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(N73:N75)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(O73:O75)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(P73:P75)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[null,22,"A",{"$f":"IF(Q80<>0,VLOOKUP($E$9,Info_County_Code,2,FALSE),\"\")","v":""},{"$nulls":6},{"$f":"IF(NOT(ISBLANK(E77)),$K$29,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,22,"B",{"$f":"IF(ISBLANK(D77),\"\",D77)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E77)),$K$30,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,22,"C",{"$f":"IF(ISBLANK(D77),\"\",D77)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E77)),$K$31,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,22,"D",{"$f":"IF(ISBLANK(D77),\"\",D77)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E77)),$K$32,\"\")","v":""},{"$f":"SUM(L77:L79)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(M77:M79)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(N77:N79)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(O77:O79)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(P77:P79)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[null,23,"A",{"$f":"IF(Q84<>0,VLOOKUP($E$9,Info_County_Code,2,FALSE),\"\")","v":""},{"$nulls":6},{"$f":"IF(NOT(ISBLANK(E81)),$K$29,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,23,"B",{"$f":"IF(ISBLANK(D81),\"\",D81)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E81)),$K$30,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,23,"C",{"$f":"IF(ISBLANK(D81),\"\",D81)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E81)),$K$31,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,23,"D",{"$f":"IF(ISBLANK(D81),\"\",D81)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E81)),$K$32,\"\")","v":""},{"$f":"SUM(L81:L83)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(M81:M83)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(N81:N83)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(O81:O83)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(P81:P83)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[null,24,"A",{"$f":"IF(Q88<>0,VLOOKUP($E$9,Info_County_Code,2,FALSE),\"\")","v":""},{"$nulls":6},{"$f":"IF(NOT(ISBLANK(E85)),$K$29,\"\")","v":""},{"$nulls":5},{"$f":"SUM(L85:P85)","v":{"v":0,"d":"$0.00"}}]
[null,24,"B",{"$f":"IF(ISBLANK(D85),\"\",D85)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E85)),$K$30,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,24,"C",{"$f":"IF(ISBLANK(D85),\"\",D85)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E85)),$K$31,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,24,"D",{"$f":"IF(ISBLANK(D85),\"\",D85)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E85)),$K$32,\"\")","v":""},{"$f":"SUM(L85:L87)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(M85:M87)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(N85:N87)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[null,25,"A",{"$f":"IF(Q92<>0,VLOOKUP($E$9,Info_County_Code,2,FALSE),\"\")","v":""},{"$nulls":6},{"$f":"IF(NOT(ISBLANK(E89)),$K$29,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,25,"B",{"$f":"IF(ISBLANK(D89),\"\",D89)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E89)),$K$30,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,25,"C",{"$f":"IF(ISBLANK(D89),\"\",D89)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E89)),$K$31,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,25,"D",{"$f":"IF(ISBLANK(D89),\"\",D89)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E89)),$K$32,\"\")","v":""},{"$f":"SUM(L89:L91)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(M89:M91)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(N89:N91)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[null,26,"A",{"$f":"IF(Q96<>0,VLOOKUP($E$9,Info_County_Code,2,FALSE),\"\")","v":""},{"$nulls":6},{"$f":"IF(NOT(ISBLANK(E93)),$K$29,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,26,"B",{"$f":"IF(ISBLANK(D93),\"\",D93)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E93)),$K$30,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,26,"C",{"$f":"IF(ISBLANK(D93),\"\",D93)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E93)),$K$31,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,26,"D",{"$f":"IF(ISBLANK(D93),\"\",D93)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E93)),$K$32,\"\")","v":""},{"$f":"SUM(L93:L95)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(M93:M95)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(N93:N95)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[null,27,"A",{"$f":"IF(Q100<>0,VLOOKUP($E$9,Info_County_Code,2,FALSE),\"\")","v":""},{"$nulls":6},{"$f":"IF(NOT(ISBLANK(E97)),$K$29,\"\")","v":""},{"$nulls":5},{"$f":"SUM(L97:P97)","v":{"v":0,"d":"$0.00"}}]
[null,27,"B",{"$f":"IF(ISBLANK(D97),\"\",D97)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E97)),$K$30,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,27,"C",{"$f":"IF(ISBLANK(D97),\"\",D97)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E97)),$K$31,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,27,"D",{"$f":"IF(ISBLANK(D97),\"\",D97)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E97)),$K$32,\"\")","v":""},{"$f":"SUM(L97:L99)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(M97:M99)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(N97:N99)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[null,28,"A",{"$f":"IF(Q104<>0,VLOOKUP($E$9,Info_County_Code,2,FALSE),\"\")","v":""},{"$nulls":6},{"$f":"IF(NOT(ISBLANK(E101)),$K$29,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,28,"B",{"$f":"IF(ISBLANK(D101),\"\",D101)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E101)),$K$30,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,28,"C",{"$f":"IF(ISBLANK(D101),\"\",D101)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E101)),$K$31,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,28,"D",{"$f":"IF(ISBLANK(D101),\"\",D101)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E101)),$K$32,\"\")","v":""},{"$f":"SUM(L101:L103)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(M101:M103)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(N101:N103)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[null,29,"A",{"$f":"IF(Q108<>0,VLOOKUP($E$9,Info_County_Code,2,FALSE),\"\")","v":""},{"$nulls":6},{"$f":"IF(NOT(ISBLANK(E105)),$K$29,\"\")","v":""},{"$nulls":5},{"$f":"SUM(L105:P105)","v":{"v":0,"d":"$0.00"}}]
[null,29,"B",{"$f":"IF(ISBLANK(D105),\"\",D105)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E105)),$K$30,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,29,"C",{"$f":"IF(ISBLANK(D105),\"\",D105)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E105)),$K$31,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,29,"D",{"$f":"IF(ISBLANK(D105),\"\",D105)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E105)),$K$32,\"\")","v":""},{"$f":"SUM(L105:L107)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(M105:M107)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(N105:N107)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[null,30,"A",{"$f":"IF(Q112<>0,VLOOKUP($E$9,Info_County_Code,2,FALSE),\"\")","v":""},{"$nulls":6},{"$f":"IF(NOT(ISBLANK(E109)),$K$29,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,30,"B",{"$f":"IF(ISBLANK(D109),\"\",D109)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E109)),$K$30,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,30,"C",{"$f":"IF(ISBLANK(D109),\"\",D109)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E109)),$K$31,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,30,"D",{"$f":"IF(ISBLANK(D109),\"\",D109)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E109)),$K$32,\"\")","v":""},{"$f":"SUM(L109:L111)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(M109:M111)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(N109:N111)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[null,31,"A",{"$f":"IF(Q116<>0,VLOOKUP($E$9,Info_County_Code,2,FALSE),\"\")","v":""},{"$nulls":6},{"$f":"IF(NOT(ISBLANK(E113)),$K$29,\"\")","v":""},{"$nulls":5},{"$f":"SUM(L113:P113)","v":{"v":0,"d":"$0.00"}}]
[null,31,"B",{"$f":"IF(ISBLANK(D113),\"\",D113)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E113)),$K$30,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,31,"C",{"$f":"IF(ISBLANK(D113),\"\",D113)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E113)),$K$31,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,31,"D",{"$f":"IF(ISBLANK(D113),\"\",D113)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E113)),$K$32,\"\")","v":""},{"$f":"SUM(L113:L115)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(M113:M115)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(N113:N115)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[null,32,"A",{"$f":"IF(Q120<>0,VLOOKUP($E$9,Info_County_Code,2,FALSE),\"\")","v":""},{"$nulls":6},{"$f":"IF(NOT(ISBLANK(E117)),$K$29,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,32,"B",{"$f":"IF(ISBLANK(D117),\"\",D117)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E117)),$K$30,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,32,"C",{"$f":"IF(ISBLANK(D117),\"\",D117)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E117)),$K$31,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,32,"D",{"$f":"IF(ISBLANK(D117),\"\",D117)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E117)),$K$32,\"\")","v":""},{"$f":"SUM(L117:L119)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(M117:M119)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(N117:N119)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[null,33,"A",{"$f":"IF(Q124<>0,VLOOKUP($E$9,Info_County_Code,2,FALSE),\"\")","v":""},{"$nulls":6},{"$f":"IF(NOT(ISBLANK(E121)),$K$29,\"\")","v":""},{"$nulls":5},{"$f":"SUM(L121:P121)","v":{"v":0,"d":"$0.00"}}]
[null,33,"B",{"$f":"IF(ISBLANK(D121),\"\",D121)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E121)),$K$30,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,33,"C",{"$f":"IF(ISBLANK(D121),\"\",D121)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E121)),$K$31,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,33,"D",{"$f":"IF(ISBLANK(D121),\"\",D121)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E121)),$K$32,\"\")","v":""},{"$f":"SUM(L121:L123)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(M121:M123)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(N121:N123)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[null,34,"A",{"$f":"IF(Q128<>0,VLOOKUP($E$9,Info_County_Code,2,FALSE),\"\")","v":""},{"$nulls":6},{"$f":"IF(NOT(ISBLANK(E125)),$K$29,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,34,"B",{"$f":"IF(ISBLANK(D125),\"\",D125)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E125)),$K$30,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,34,"C",{"$f":"IF(ISBLANK(D125),\"\",D125)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E125)),$K$31,\"\")","v":""},{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,34,"D",{"$f":"IF(ISBLANK(D125),\"\",D125)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(E125)),$K$32,\"\")","v":""},{"$f":"SUM(L125:L127)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(M125:M127)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(N125:N127)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]

{"sheet":"Instructions 5. INN","index":10,"n_rows":113,"n_cols":1,"rows_kept":113}
["Use UP or DOWN arrow to navigate spreadsheet. "]
["County: No entry. This field will auto-populate from the Information worksheet."]
["Date: No entry. This field will auto-populate from the Information worksheet."]
["Row 1, Column A: Enter the amount of MHSA funds, including interest, expended for INN Annual Planning."]
["Row 1, Column B: Enter the amount of Medi-Cal FFP funds expended for INN Annual Planning."]
["Row 1, Column C: Enter the amount of 1991 Realignment funds expended for INN Annual Planning."]
["Row 1, Column D: Enter the amount of Behavioral Health Subaccount funds expended for INN Annual Planning."]
["Row 1, Column E: Enter the amount of Other funds expended for INN Annual Planning. Other funds include funding from sources not otherwise identified such as from local General Fund or other local sources, or from sources such as Federal grants or other grants."]
["Row 1, Column F: No entry. This amount is the sum of Row 1, Columns A-E."]
["Row 2, Column A: Enter the amount of MHSA funds, including interest, expended for INN Indirect Administration costs. Indirect administrative costs are those administrative costs that are incurred for a common or joint purpose and cannot be readily identified as benefiting only one MHSA component. Counties must use an appropriate allocation method to allocate indirect costs to the INN Account. The share of costs attributed to the INN Account  should be in proportion to the extent the INN projects or services benefit from the support activity. Counties must maintain proper documentation of the allocation methodology used to allocate indirect costs to administration of INN projects or services. To avoid double-counting, do not include costs incurred as both INN Indirect Administration Costs and either INN Project Administration, INN Project Evaluation or INN Project Direct Expenditures."]
["Row 2, Column B: Enter the amount of Medi-Cal FFP funds expended for INN Indirect Administration."]
["Row 2, Column C: Enter the amount of 1991 Realignment funds expended for INN Indirect Administration."]
["Row 2, Column D: Enter the amount of Behavioral Health subaccount funds expended for INN Indirect Administration."]
["Row 2, Column E: Enter the amount of Other funds expended for INN Indirect Administration."]
["Row 2, Column F: No entry. This amount is the sum of Row 2, Columns A-E."]
["Row 3, Column A: Enter the amount of MHSA funds, including interest, transferred to a Joint Powers Authority (JPA) for INN projects."]
["Row 3, Column B: This cell is blank."]
["Row 3, Column C: This cell is blank."]
["Row 3, Column D: This cell is blank."]
["Row 3, Column E: This cell is blank."]
["Row 3, Column F: No entry. This amount is equal to Row 3, Column A."]
["Row 4, Column A: Enter the amount of MHSA funds, including interest, expended by a JPA on behalf of the County during the reporting fiscal year for authorized INN projects. Funds reported here as transferred will not increase the Total INN Expenditures (Row 9)."]
["Row 4, Column B: This cell is blank."]
["Row 4, Column C: This cell is blank."]
["Row 4, Column D: This cell is blank."]
["Row 4, Column E: This cell is blank."]
["Row 4, Column F: No entry. This amount is equal to Row 4, Column A."]
["Row 5, Column A: No entry. This amount is equal to the sum of Rows 10-34, Column I identified as Project Administration in Column H."]
["Row 5, Column B: No entry. This amount is equal to the sum of Rows 10-34, Column J identified as Project Administration in Column H."]
["Row 5, Column C: No entry. This amount is equal to the sum of Rows 10-34, Column K identified as Project Administration in Column H."]
["Row 5, Column D: No entry. This amount is equal to the sum of Rows 10-34, Column L identified as Project Administration in Column H."]
["Row 5, Column E: No entry. This amount is equal to the sum of Rows 10-34, Column M identified as Project Administration in Column H."]
["Row 5, Column F: No entry. This amount is equal to the sum of Row 5, Columns A-E."]
["Row 6, Column A: No entry. This amount is equal to the sum of Rows 10-34, Column I identified as Project Evaluation in Column H."]
["Row 6, Column B: No entry. This amount is equal to the sum of Rows 10-34, Column J identified as Project Evaluation in Column H."]
["Row 6, Column C: No entry. This amount is equal to the sum of Rows 10-34, Column K identified as Project Evaluation in Column H."]
["Row 6, Column D: No entry. This amount is equal to the sum of Rows 10-34, Column L identified as Project Evaluation in Column H."]
["Row 6, Column E: No entry. This amount is equal to the sum of Rows 10-34, Column M identified as Project Evaluation in Column H."]
["Row 6, Column F: No entry. This amount is equal to the sum of Row 6, Columns A-E."]
["Row 7, Column A: No entry. This amount is equal to the sum of Rows 10-34, Column I identified as Project Direct in Column H."]
["Row 7, Column B: No entry. This amount is equal to the sum of Rows 10-34, Column J identified as Project Direct in Column H."]
["Row 7, Column C: No entry. This amount is equal to the sum of Rows 10-34, Column K identified as Project Direct in Column H."]
["Row 7, Column D: No entry. This amount is equal to the sum of Rows 10-34, Column L identified as Project Direct in Column H."]
["Row 7, Column E: No entry. This amount is equal to the sum of Rows 10-34, Column M identified as Project Direct in Column H."]
["Row 7, Column F: No entry. This amount is equal to the sum of Rows 7, Columns A-E."]
["Row 8, Column A: No entry. This amount is equal to the sum of Rows 5-7, Column A."]
["Row 8, Column B: No entry. This amount is equal to the sum of Rows 5-7, Column B."]
["Row 8, Column C: No entry. This amount is equal to the sum of Rows 5-7, Column C."]
["Row 8, Column D: No entry. This amount is equal to the sum of Rows 5-7, Column D."]
["Row 8, Column E: No entry. This amount is equal to the sum of Rows 5-7, Column E."]
["Row 8, Column F: No entry. This amount is equal to the sum of Row 8, Columns A-E."]
["Row 9, Column A: No entry. This amount is equal to the sum of Rows 1-2 and 4-7, Column A. "]
["Row 9, Column B: No entry. This amount is equal to the sum of Rows 1-2 and 5-7, Column B. "]
["Row 9, Column C: No entry. This amount is equal to the sum of Rows 1-2 and 5-7, Column C. "]
["Row 9, Column D: No entry. This amount is equal to the sum of Rows 1-2 and 5-7, Column D. "]
["Row 9, Column E: No entry. This amount is equal to the sum of Rows 1-2 and 5-7, Column E. "]
["Row 9, Column F: No entry. This amount is equal to the sum of Row 9, Columns A-E."]
["Rows10A-34A, Column A: No entry. This field auto-populates as the County enters expenditure data and is determined according to the County Name entered on  Worksheet 1. Information, Row 3. The County Code corresponds to the numeric ID code used to identify the County in the Data Collection and Reporting system."]
["Rows 10A-34A, Column B: Enter the Program name for each INN project funded by the INN Account. Project name must be consistent with Project Name provided in the most recent MHSA Three-Year Program and Expenditure Plan or Annual Update covering the same Fiscal Year. If a County has changed the name of a Project subsequent to publication of the relevant Three-Year Program and Expenditure Plan or Annual Update, the County must provide the name change on worksheet 10. Comments."]
["Rows 10A-34A, Column C: If the Project name is identical to the Project name reported in the prior year ARER or this is a new program this reporting year, no entry. If the Project name has changed from what was reported on the prior year ARER, enter the name used to identify this Project in the prior year ARER. If this Project represents a combination of two or more Projects formerly reported separately, or if this Project was formerly combined with another Project leave this field blank, but provide a comment on the Worksheet 10. "]
["Rows 10A-34A, Column D: Enter in the date of the MHSOAC meeting in which the MHSOAC initially approved the Project. "]
["Rows 10A-34A, Column E: Enter in the start date for the Project. The start date is the date on which the County began implementing the project. INN projects are time-limited projects that can extend a maximum of five years from their respective Start Date. (California Code of Regulations, Title 9, Section 3910.010(a))"]
["Rows 10A-34A, Column F: Enter the amount of MHSA INN funding the MHSOAC initially authorized for the Project on the date entered in Column E. Provide a comment in Worksheet 10. Comments explaining the amount authorized, including any specific MHSA INN allocations designed for expenditure in the approved project."]
["Rows 10A-34A, Column G: If the Project has not been amended, no entry. Otherwise, enter the additional amount of MHSA INN funding authorized by the MHSOAC for the Project through an amendment. The sum of Column F and Column G should equal the total amount the MHSOAC authorized for the Project through the amendment. Provide a comment in Worksheet 10. Comments explaining the additional amount authorized, including any specific MHSA INN allocations designed for expenditure in the approved project."]
["Rows 10A-34A, Column H: No entry."]
["Rows 10A-34A, Column I: Enter the amount of MHSA funds, including interest, expended for goods and services delivered during the reporting fiscal year for each Project, for Project Administration."]
["Rows 10A-34A, Column J: Enter the amount of Medi-Cal FFP funds expended for goods and services delivered during the reporting fiscal year for each Project, for Project Administration."]
["Rows 10A-34A, Column K: Enter the amount of 1991 Realignment funds expended for goods and services delivered during the reporting fiscal year for each Project, for Project Administration."]
["Rows 10A-34A, Column L: Enter the amount of Behavioral Health Subaccount funds expended for goods and services delivered during the reporting fiscal year for each Project, for Project Administration."]
["Rows 10A-34A, Column M: Enter the amount of Other funds expended for goods and services delivered during the reporting fiscal year for each Project, for Project Administration."]
["Rows 10A-34A, Column N: No entry. This amount is the sum of Rows 10A-34A, Columns I-M."]
["Rows10B-34B, Column A: No entry. This field auto-populates as the County enters expenditure data and is determined according to the County Name entered on  Worksheet 1. Information, Row 3. The County Code corresponds to the numeric ID code used to identify the County in the Data Collection and Reporting system."]
["Rows 10B-34B, Column B: No entry. This data autopopulates from Rows 10A-34A, Column B."]
["Rows 10B-34B, Column C: No entry. This data autopopulates from Rows 10A-34A, Column C."]
["Rows 10B-34B, Column D: No entry. This data autopopulates from Rows 10A-34A, Column D."]
["Rows 10B-34B, Column E: No entry. This data autopopulates from Rows 10A-34A, Column E."]
["Rows 10B-34B, Column F: No entry. This data autopopulates from Rows 10A-34A, Column F."]
["Rows 10B-34B, Column G: No entry. This data autopopulates from Rows 10A-34A, Column G."]
["Rows 10B-34B, Column H: No entry. "]
["Rows 10B-34B, Column I: Enter the amount of MHSA funds, including interest, expended for goods and services delivered during the reporting fiscal year for each Project, for Project Evaluation."]
["Rows 10B-34B, Column J: Enter the amount of Medi-Cal FFP funds expended for goods and services delivered during the reporting fiscal year for each Project, for Project Evaluation."]
["Rows 10B-34B, Column K: Enter the amount of 1991 Realignment funds expended for goods and services delivered during the reporting fiscal year for each Project, for Project Evaluation."]
["Rows 10B-34B, Column L: Enter the amount of Behavioral Health Subaccount funds expended for goods and services delivered during the reporting fiscal year for each Project, for Project Evaluation."]
["Rows 10B-34B, Column M: Enter the amount of Other funds expended for goods and services delivered during the reporting fiscal year for each Project, for Project Evaluation."]
["Rows 10B-34B, Column N: No entry. This amount is the sum of Rows 10B-34B, Columns I-M."]
["Rows10C-34C, Column A: No entry. This field auto-populates as the County enters expenditure data and is determined according to the County Name entered on  Worksheet 1. Information, Row 3. The County Code corresponds to the numeric ID code used to identify the County in the Data Collection and Reporting system."]
["Rows 10C-34C, Column B: No entry. This data autopopulates from Rows 10A-34A, Column B."]
["Rows 10C-34C, Column C: No entry. This data autopopulates from Rows 10A-34A, Column C."]
["Rows 10C-34C, Column D: No entry. This data autopopulates from Rows 10A-34A, Column D."]
["Rows 10C-34C, Column E: No entry. This data autopopulates from Rows 10A-34A, Column E."]
["Rows 10C-34C, Column F: No entry. This data autopopulates from Rows 10A-34A, Column F."]
["Rows 10C-34C, Column G: No entry. This data autopopulates from Rows 10A-34A, Column G."]
["Rows 10C-34C, Column H: No entry. "]
["Rows 10C-34C, Column I: Enter the amount of MHSA funds, including interest, expended for goods and services delivered during the reporting fiscal year for each Project, for Project Direct."]
["Rows 10C-34C, Column J: Enter the amount of Medi-Cal FFP funds expended for goods and services delivered during the reporting fiscal year for each Project, for Project Direct."]
["Rows 10C-34C, Column K: Enter the amount of 1991 Realignment funds expended for goods and services delivered during the reporting fiscal year for each Project, for Project Direct."]
["Rows 10C-34C, Column L: Enter the amount of Behavioral Health Subaccount funds expended for goods and services delivered during the reporting fiscal year for each Project, for Project Direct."]
["Rows 10C-34C, Column M: Enter the amount of Other funds expended for goods and services delivered during the reporting fiscal year for each Project, for Project Direct."]
["Rows 10C-34C, Column N: No entry. This amount is the sum of Rows 10C-34C, Columns I-M."]
["Rows10D-34D, Column A: No entry. This field auto-populates as the County enters expenditure data and is determined according to the County Name entered on  Worksheet 1. Information, Row 3. The County Code corresponds to the numeric ID code used to identify the County in the Data Collection and Reporting system."]
["Rows 10D-34D, Column B: No entry. This data autopopulates from Rows 10A-34A, Column B."]
["Rows 10D-34D, Column C: No entry. This data autopopulates from Rows 10A-34A, Column C."]
["Rows 10D-34D, Column D: No entry. This data autopopulates from Rows 10A-34A, Column D."]
["Rows 10D-34D, Column E: No entry. This data autopopulates from Rows 10A-34A, Column E."]
["Rows 10D-34D, Column F: No entry. This data autopopulates from Rows 10A-34A, Column F."]
["Rows 10D-34D, Column G: No entry. This data autopopulates from Rows 10A-34A, Column G."]
["Rows 10D-34D, Column H: No entry. "]
["Rows 10D-34D, Column I: No entry. This amount is the sum of Rows 10A-34A, Rows 10B-34B, Rows 10C-34C, Column I."]
["Rows 10D-34D, Column J: No entry. This amount is the sum of Rows 10A-34A, Rows 10B-34B, Rows 10C-34C, Column J."]
["Rows 10D-34D, Column K: No entry. This amount is the sum of Rows 10A-34A, Rows 10B-34B, Rows 10C-34C, Column K."]
["Rows 10D-34D, Column L: No entry. This amount is the sum of Rows 10A-34A, Rows 10B-34B, Rows 10C-34C, Column L."]
["Rows 10D-34D, Column M: No entry. This amount is the sum of Rows 10A-34A, Rows 10B-34B, Rows 10C-34C, Column M."]
["Rows 10D-34D, Column N: No entry. This amount is the sum of Rows 10D-34D, Columns I-M."]

{"sheet":"6. WET","index":11,"n_rows":32,"n_cols":11,"rows_kept":32}
["Press UP or DOWN arrow to read through the WET spreadsheet. In section 1, use the UP and DOWN arrow for different WET expenditures. Use LEFT or RIGHT arrow on these cell rows to input amount of fund type. In section 2, use the UP and DOWN arrow to read through the different funding categories and use LEFT or RIGHT arrow to input amount of fund type. ","STATE OF CALIFORNIA",{"$nulls":8},"Department of Health Care Services"]
[null,"HEALTH AND HUMAN SERVICES AGENCY"]
[]
[null,"DHCS 1822 F (02/19)"]
[null,{"$f":"'1. Information'!B5","v":"Annual Mental Health Services Act (MHSA) Revenue and Expenditure Report"}]
[null,{"$f":"'1. Information'!B6","v":"Fiscal Year: 2018-19"}]
[null,"Workforce Education and Training (WET) Summary Worksheet"]
[]
[null,null,"County:",{"$f":"IF(ISBLANK('1. Information'!D11),\"\",'1. Information'!D11)","v":"Kings"},null,"Date:",{"$f":"IF(ISBLANK('1. Information'!D9),\"\",'1. Information'!D9)","v":"2019-12-10"}]
[]
[null,"SECTION ONE"]
[]
[{"$nulls":5},"A","B","C","D","E","F"]
[{"$nulls":5},"Total MHSA Funds (Including Interest)","Medi-Cal FFP","1991 Realignment","Behavioral Health Subaccount","Other","Grand Total"]
[null,1,"WET Annual Planning Costs",{"$nulls":7},{"$f":"SUM(F15:J15)","v":{"v":0,"d":"$0.00"}}]
[null,2,"WET Evaluation Costs",{"$nulls":7},{"$f":"SUM(F16:J16)","v":{"v":0,"d":"$0.00"}}]
[null,3,"WET Administration Costs",{"$nulls":7},{"v":0,"d":"$0.00"}]
[null,4,"WET Funds Transferred to JPA",{"$nulls":7},{"$f":"F18","v":{"v":0,"d":"$0.00"}}]
[null,5,"WET Expenditures Incurred by JPA",{"$nulls":7},{"$f":"F19","v":{"v":0,"d":"$0.00"}}]
[null,6,"WET Program Expenditures",null,null,{"$f":"SUM(E28:E32)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(F28:F32)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"SUM(I28:I32)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[null,7,"Total WET Expenditures (Excluding Transfers to JPA)",null,null,{"$f":"SUM(F15:F17,F19:F20)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(G15:G17,G20)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(H15:H17,H20)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(I15:I17,I20)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(J15:J17,J20)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[]
[]
[null,"SECTION TWO"]
[]
[null,null,"A","B","C","D","E","F","G","H"]
[null,"#","County Code","Funding Category","Total MHSA Funds (Including Interest)","Medi-Cal FFP","1991 Realignment","Behavioral Health Subaccount","Other","Grand Total"]
[null,8,{"$f":"IF(J28<>0,VLOOKUP($D$9,Info_County_Code,2,FALSE),\"\")","v":""},"Workforce Staffing",{"$nulls":5},{"$f":"SUM(E28:I28)","v":{"v":0,"d":"$0.00"}}]
[null,9,"","Training/Technical Assistance",{"$nulls":5},{"$f":"SUM(E29:I29)","v":{"v":0,"d":"$0.00"}}]
[null,10,"","Mental Health Career Pathways",{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,11,"","Residency/Internship",{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,12,"","Financial Incentive",{"$nulls":5},{"v":0,"d":"$0.00"}]

{"sheet":"Instructions 6. WET","index":12,"n_rows":85,"n_cols":1,"rows_kept":85}
["Use UP or DOWN arrow to navigate through spreadsheet. "]
["County: No entry. This field will auto-populate from the Information worksheet."]
["Date: No entry. This field will auto-populate from the Information worksheet."]
["Row 1, Column A: Enter the amount of MHSA funds, including interest, expended for WET Annual Planning."]
["Row 1, Column B: Enter the amount of Medi-Cal FFP funds expended for WET Annual Planning."]
["Row 1, Column C: Enter the amount of 1991 Realignment funds expended for WET Annual Planning."]
["Row 1, Column D: Enter the amount of Behavioral Health Subaccount funds expended for WET Annual Planning."]
["Row 1, Column E: Enter the amount of Other funds expended for WET Annual Planning. Other funds include funding from sources not otherwise identified such as from local General Fund or other local sources, or from sources such as Federal grants or other grants."]
["Row 1, Column F: No entry. This amount is the sum of Row 1, Columns A-E."]
["Row 2, Column A: Enter the amount of MHSA funds, including interest, expended for WET Evaluation."]
["Row 2, Column B: Enter the amount of Medi-Cal FFP funds expended for WET Evaluation."]
["Row 2, Column C: Enter the amount of 1991 Realignment funds expended for WET Evaluation."]
["Row 2, Column D: Enter the amount of Behavioral Health Subaccount funds expended for WET Evaluation."]
["Row 2, Column E: Enter the amount of Other funds expended for WET Evaluation."]
["Row 2, Column F: No entry. This amount is the sum of Row 2, Columns A-E."]
["Row 3, Column A: Enter the amount of MHSA funds, including interest, expended for WET Administration. This amount should include direct administrative costs and an appropriate allocation of indirect costs. Direct administrative costs are administrative costs that only benefit WET programs or services. Indirect administrative costs are those administrative costs that are incurred for a common or joint purpose and cannot be readily identified as benefiting only one MHSA component. Counties must use an appropriate allocation method to allocate indirect costs to the WET Account. The share of costs attributed to the WET Account  should be in proportion to the extent the WET programs or services benefit from the support activity. Counties must maintain proper documentation of the allocation methodology used to allocate indirect costs to administration of WET programs or services. To avoid double-counting, do not include costs incurred as both Administration Costs and either Annual Planning Costs, Evaluation Costs or Program Expenditures."]
["Row 3, Column B: Enter the amount of Medi-Cal FFP funds expended for WET Administration."]
["Row 3, Column C: Enter the amount of 1991 Realignment funds expended for WET Administration."]
["Row 3, Column D: Enter the amount of Behavioral Health Subaccount funds expended for WET Administration."]
["Row 3, Column E: Enter the amount of Other funds expended for WET Administration."]
["Row 3, Column F: No entry. This amount is the sum of Row 3, Columns A-E."]
["Row 4, Column A: Enter the amount of MHSA funds, including interest, transferred to a Joint Powers Authority (JPA) for WET programs."]
["Row 4, Column B: This cell is blank."]
["Row 4, Column C: This cell is blank."]
["Row 4, Column D: This cell is blank."]
["Row 4, Column E: This cell is blank."]
["Row 4, Column F: No entry. This amount is equal to Row 4, Column A."]
["Row 5, Column A: Enter the amount of MHSA funds, including interest, expended by a JPA on behalf of the County during the reporting fiscal year for authorized WET goods or services. "]
["Row 5, Column B: This cell is blank."]
["Row 5, Column C: This cell is blank."]
["Row 5, Column D: This cell is blank."]
["Row 5, Column E: This cell is blank."]
["Row 5, Column F: No entry. This amount is equal to Row 5, Column A."]
["Row 6, Column A: No entry. This amount is the sum of Rows 8-12, Column C."]
["Row 6, Column B: No entry. This amount is the sum of Rows 8-12, Column D."]
["Row 6, Column C: No entry. This amount is the sum of Rows 8-12, Column E."]
["Row 6, Column D: No entry. This amount is the sum of Rows 8-12, Column F."]
["Row 6, Column E: No entry. This amount is the sum of Rows 8-12, Column G."]
["Row 6, Column F: No entry. This amount is the sum of Row 6, Columns A-E."]
["Row 7, Column A: No entry. This amount is the sum of Rows 1-3 and 5-6, Column A."]
["Row 7, Column B: No entry. This amount is the sum of Rows 1-3 and 6, Column B."]
["Row 7, Column C: No entry. This amount is the sum of Rows 1-3 and 6, Column C."]
["Row 7, Column D: No entry. This amount is the sum of Rows 1-3 and 6, Column D."]
["Row 7, Column E: No entry. This amount is the sum of Rows 1-3 and 6, Column E."]
["Row 7, Column F: No entry. This amount is the sum of Row 7, Columns A-E."]
["Row 8, Column A: No entry. This field auto-populates as the County enters expenditure data and is determined according to the County Name entered on  Worksheet 1. Information, Row 3. The County Code corresponds to the numeric ID code used to identify the County in the Data Collection and Reporting system."]
["Row 8, Column B: No entry."]
["Row 8, Column C: Enter the amount of MHSA funds, including interest, expended for goods and services delivered during the reporting fiscal year for Workforce Staffing."]
["Row 8, Column D: Enter the amount of MediCal FFP funds expended for goods and services delivered during the reporting fiscal year for Workforce Staffing."]
["Row 8, Column E: Enter the amount of 1991 Realignment funds expended for goods and services delivered during the reporting fiscal year for Workforce Staffing."]
["Row 8, Column F: Enter the amount of Behavioral Health Subaccount funds expended for goods and services delivered during the reporting fiscal year for Workforce Staffing."]
["Row 8, Column G: Enter the amount of Other funds expended for goods and services delivered during the reporting fiscal year for Workforce Staffing."]
["Row 8, Column H: No entry. This amount is the sum of Row 8, Columns C-G."]
["Row 9, Column A: No entry. This field auto-populates as the County enters expenditure data and is determined according to the County Name entered on  Worksheet 1. Information, Row 3. The County Code corresponds to the numeric ID code used to identify the County in the Data Collection and Reporting system."]
["Row 9, Column B: No entry."]
["Row 9, Column C: Enter the amount of MHSA funds, including interest, expended for goods and services delivered during the reporting fiscal year for Training/Technical Assistance."]
["Row 9, Column D: Enter the amount of MediCal FFP funds expended for goods and services delivered during the reporting fiscal year for Training/Technical Assistance."]
["Row 9, Column E: Enter the amount of 1991 Realignment funds expended for goods and services delivered during the reporting fiscal year for Training/Technical Assistance."]
["Row 9, Column F: Enter the amount of Behavioral Health Subaccount funds expended for goods and services delivered during the reporting fiscal year for Training/Technical Assistance."]
["Row 9, Column G: Enter the amount of Other funds expended for goods and services delivered during the reporting fiscal year for Training/Technical Assistance."]
["Row 9, Column H: No entry. This amount is the sum of Row 9, Columns C-G."]
["Row 10, Column A: No entry. This field auto-populates as the County enters expenditure data and is determined according to the County Name entered on  Worksheet 1. Information, Row 3. The County Code corresponds to the numeric ID code used to identify the County in the Data Collection and Reporting system."]
["Row 10, Column B: No entry."]
["Row 10, Column C: Enter the amount of MHSA funds, including interest, expended for goods and services delivered during the reporting fiscal year for Mental Health Career Pathways."]
["Row 10, Column D: Enter the amount of MediCal FFP funds expended for goods and services delivered during the reporting fiscal year for Mental Health Career Pathways."]
["Row 10, Column E: Enter the amount of 1991 Realignment funds expended for goods and services delivered during the reporting fiscal year for Mental Health Career Pathways."]
["Row 10, Column F: Enter the amount of Behavioral Health Subaccount funds expended for goods and services delivered during the reporting fiscal year for Mental Health Career Pathways."]
["Row 10, Column G: Enter the amount of Other funds expended for goods and services delivered during the reporting fiscal year for Mental Health Career Pathways."]
["Row 10, Column H: No entry. This amount is the sum of Row 10, Columns C-G."]
["Row 11, Column A: No entry. This field auto-populates as the County enters expenditure data and is determined according to the County Name entered on  Worksheet 1. Information, Row 3. The County Code corresponds to the numeric ID code used to identify the County in the Data Collection and Reporting system."]
["Row 11, Column B: No entry."]
["Row 11, Column C: Enter the amount of MHSA funds, including interest, expended for goods and services delivered during the reporting fiscal year for Residency/Internship."]
["Row 11, Column D: Enter the amount of MediCal FFP funds expended for goods and services delivered during the reporting fiscal year for Residency/Internship."]
["Row 11, Column E: Enter the amount of 1991 Realignment funds expended for goods and services delivered during the reporting fiscal year for Residency/Internship."]
["Row 11, Column F: Enter the amount of Behavioral Health Subaccount funds expended for goods and services delivered during the reporting fiscal year for Residency/Internship."]
["Row 11, Column G: Enter the amount of Other funds expended for goods and services delivered during the reporting fiscal year for Residency/Internship."]
["Row 11, Column H: No entry. This amount is the sum of Row 11, Columns C-G."]
["Row 12, Column A: No entry. This field auto-populates as the County enters expenditure data and is determined according to the County Name entered on  Worksheet 1. Information, Row 3. The County Code corresponds to the numeric ID code used to identify the County in the Data Collection and Reporting system."]
["Row 12, Column B: No entry."]
["Row 12, Column C: Enter the amount of MHSA funds, including interest, expended for goods and services delivered during the reporting fiscal year for Financial Incentives."]
["Row 12, Column D: Enter the amount of MediCal FFP funds expended for goods and services delivered during the reporting fiscal year for Financial Incentives."]
["Row 12, Column E: Enter the amount of 1991 Realignment funds expended for goods and services delivered during the reporting fiscal year for Financial Incentives."]
["Row 12, Column F: Enter the amount of Behavioral Health Subaccount funds expended for goods and services delivered during the reporting fiscal year for Financial Incentives."]
["Row 12, Column G: Enter the amount of Other funds expended for goods and services delivered during the reporting fiscal year for Financial Incentives."]
["Row 12, Column H: No entry. This amount is the sum of Row 12, Columns C-G."]

{"sheet":"7. CFTN","index":13,"n_rows":46,"n_cols":12,"rows_kept":46}
["Press UP or DOWN arrow to navigate through CFTN spreadsheet. In section 1, use UP and DOWN arrow to read the CFTN expenditures and use the LEFT or RIGHT arrows to input amount of funding type. In section 2, use LEFT or RIGHT arrow on the header column to read about project components and use the UP or DOWN arrow on these cells to input needed information. ","STATE OF CALIFORNIA",{"$nulls":9},"Department of Health Care Services"]
[null,"HEALTH AND HUMAN SERVICES AGENCY"]
[]
[null,"DHCS 1822 G (02/19)"]
[null,{"$f":"'1. Information'!B5","v":"Annual Mental Health Services Act (MHSA) Revenue and Expenditure Report"}]
[null,{"$f":"'1. Information'!B6","v":"Fiscal Year: 2018-19"}]
[null,"Capital Facility Technological Needs (CFTN) Summary Worksheet"]
[]
[null,"County:",null,{"$f":"IF(ISBLANK('1. Information'!D11),\"\",'1. Information'!D11)","v":"Kings"},null,"Date:",{"$f":"IF(ISBLANK('1. Information'!D9),\"\",'1. Information'!D9)","v":"2019-12-10"}]
[]
[null,"SECTION ONE"]
[]
[{"$nulls":5},"A","B","C","D","E","F"]
[{"$nulls":5},"Total MHSA Funds (Including Interest)","Medi-Cal FFP","1991 Realignment","Behavioral Health Subaccount","Other","Grand Total"]
[null,1,"CFTN Annual Planning Costs",null,null,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"SUM(F15:J15)","v":{"v":0,"d":"$0.00"}}]
[null,2,"CFTN Evaluation Costs",null,null,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"SUM(F16:J16)","v":{"v":0,"d":"$0.00"}}]
[null,3,"CFTN Administration Costs",null,null,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[null,4,"CFTN Funds Transferred to JPA",null,null,{"v":0,"d":"$0.00"},{"$nulls":4},{"$f":"F18","v":{"v":0,"d":"$0.00"}}]
[null,5,"CFTN Expenditures Incurred by JPA",null,null,{"v":0,"d":"$0.00"},{"$nulls":4},{"$f":"F19","v":{"v":0,"d":"$0.00"}}]
[null,6,"CFTN Project Expenditures",null,null,{"$f":"SUM(G27:G46)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(H27:H46)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(I27:I46)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(J27:J46)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(K27:K46)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[null,7,"Total CFTN Expenditures (Excluding Transfers to JPA)",null,null,{"$f":"SUM(F15:F17,F19:F20)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(G15:G17,G20)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(H15:H17,H20)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"SUM(F21:J21)","v":{"v":0,"d":"$0.00"}}]
[]
[null,"SECTION TWO"]
[]
[null,null,"A","B","C","D","E","F","G","H","I","J"]
[null,"#","County Code","Project Name","Prior Project Name","Project Type","Total MHSA Funds (Including Interest)","Medi-Cal FFP","1991 Realignment","Behavioral Health Subaccount","Other","Grand Total"]
[null,8,{"$f":"IF(L27<>0,VLOOKUP($D$9,Info_County_Code,2,FALSE),\"\")","v":""},{"$nulls":8},{"$f":"SUM(G27:K27)","v":{"v":0,"d":"$0.00"}}]
[null,9,"",{"$nulls":8},{"$f":"SUM(G28:K28)","v":{"v":0,"d":"$0.00"}}]
[null,10,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,11,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,12,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,13,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,14,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,15,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,16,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,17,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,18,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,19,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,20,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,21,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,22,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,23,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,24,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,25,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,26,"",{"$nulls":8},{"v":0,"d":"$0.00"}]
[null,27,"",{"$nulls":8},{"v":0,"d":"$0.00"}]

{"sheet":"Instructions 7. CFTN","index":14,"n_rows":55,"n_cols":1,"rows_kept":55}
["Use UP or DOWN arrow to navigate spreadsheet. "]
["County: No entry. This field will auto-populate from the Information worksheet."]
["Date: No entry. This field will auto-populate from the Information worksheet."]
["Row 1, Column A: Enter the amount of MHSA funds, including interest, expended for CFTN Annual Planning."]
["Row 1, Column B: Enter the amount of Medi-Cal FFP funds expended for CFTN Annual Planning."]
["Row 1, Column C: Enter the amount of 1991 Realignment funds expended for CFTN Annual Planning."]
["Row 1, Column D: Enter the amount of Behavioral Health Subaccount funds expended for CFTN Annual Planning."]
["Row 1, Column E: Enter the amount of Other funds expended for CFTN Annual Planning. Other funds include funding from sources not otherwise identified such as from local General Fund or other local sources, or from sources such as Federal grants or other grants."]
["Row 1, Column F: No entry. This amount is the sum of Row 1, Columns A-E."]
["Row 2, Column A: Enter the amount of MHSA funds, including interest, expended for CFTN Evaluation."]
["Row 2, Column B: Enter the amount of Medi-Cal FFP funds expended for CFTN Evaluation."]
["Row 2, Column C: Enter the amount of 1991 Realignment funds expended for CFTN Evaluation."]
["Row 2, Column D: Enter the amount of Behavioral Health subaccount funds expended for CFTN Evaluation."]
["Row 2, Column E: Enter the amount of Other funds expended for CFTN Evaluation."]
["Row 2, Column F: No entry. This amount is the sum of Row 2, Columns A-E."]
["Row 3, Column A: Enter the amount of MHSA funds, including interest, expended for CFTN Administration. This amount should include direct administrative costs and an appropriate allocation of indirect costs. Direct administrative costs are administrative costs that only benefit CFTN projects. Indirect administrative costs are those administrative costs that are incurred for a common or joint purpose and cannot be readily identified as benefiting only one MHSA component. Counties must use an appropriate allocation method to allocate indirect costs to the CFTN Account. The share of costs attributed to the CFTN Account  should be in proportion to the extent the CFTN project benefit from the support activity. Counties must maintain proper documentation of the allocation methodology used to allocate indirect costs to administration of CFTN projects. To avoid double-counting, do not include costs incurred as both Administration Costs and either Annual Planning Costs, Evaluation Costs or Project Expenditures."]
["Row 3, Column B: Enter the amount of Medi-Cal FFP funds expended for CFTN Administration."]
["Row 3, Column C: Enter the amount of 1991 Realignment funds expended for CFTN Administration."]
["Row 3, Column D: Enter the amount of Behavioral Health subaccount funds expended for CFTN Administration."]
["Row 3, Column E: Enter the amount of Other funds expended for CFTN Administration."]
["Row 3, Column F: No entry. This amount is the sum of Row 3, Columns A-E."]
["Row 4, Column A: Enter the amount of MHSA funds, including interest, transferred to a Joint Powers Authority (JPA) for CFTN projects."]
["Row 4, Column B: This cell is blank."]
["Row 4, Column C: This cell is blank."]
["Row 4, Column D: This cell is blank."]
["Row 4, Column E: This cell is blank."]
["Row 4, Column F: No entry. This amount is equal to Row 4, Column A."]
["Row 5, Column A: Enter the amount of MHSA funds, including interest, expended by a JPA on behalf of the County during the reporting fiscal year for authorized CFTN goods or services. "]
["Row 5, Column B: This cell is blank."]
["Row 5, Column C: This cell is blank."]
["Row 5, Column D: This cell is blank."]
["Row 5, Column E: This cell is blank."]
["Row 5, Column F: No entry. This amount is equal to Row 5, Column A."]
["Row 6, Column A: No entry. This amount is the sum of Rows 8-27, Column E."]
["Row 6, Column B: No entry. This amount is the sum of Rows 8-27, Column F."]
["Row 6, Column C: No entry. This amount is the sum of Rows 8-27, Column G."]
["Row 6, Column D: No entry. This amount is the sum of Rows 8-27, Column H."]
["Row 6, Column E: No entry. This amount is the sum of Rows 8-27, Column I."]
["Row 6, Column F: No entry. This amount is the sum of Row 6, Columns A-E."]
["Row 7, Column A: No entry. This amount is the sum of Rows 1-3 and 5-6, Column A."]
["Row 7, Column B: No entry. This amount is the sum of Rows 1-3 and 6, Column B."]
["Row 7, Column C: No entry. This amount is the sum of Rows 1-3 and 6, Column C."]
["Row 7, Column D: No entry. This amount is the sum of Rows 1-3 and 6, Column D."]
["Row 7, Column E: No entry. This amount is the sum of Rows 1-3 and 6, Column E."]
["Row 7, Column F: No entry. This amount is the sum of Row 7, Columns A-E."]
["Rows 8-27, Column A: No entry. This field auto-populates as the County enters expenditure data and is determined according to the County Name entered on  Worksheet 1. Information, Row 3. The County Code corresponds to the numeric ID code used to identify the County in the Data Collection and Reporting system."]
["Rows 8-27, Column B: Enter the Project name for each CFTN project funded by the CFTN Account. Project name must be consistent with Project Name provided in the most recent MHSA Three-Year Program and Expenditure Plan or Annual Update covering the same Fiscal Year. If a County has changed the name of a Project subsequent to publication of the relevant Three-Year Program and Expenditure Plan or Annual Update, the County must provide the name change on worksheet 10. Comments."]
["Rows 8-27, Column C: If the Project name is identical to the Project name reported in the prior year ARER or this is a new project this reporting year, no entry. If the Project name has changed from what was reported on the prior year ARER, enter the name used to identify this Project in the prior year ARER. If this project represents a combination of two or more projects formerly reported separately, or if this program was formerly combined with another Project leave this field blank, but provide a comment on the Worksheet 10. "]
["Rows 8-27, Column D: Selection Only. Select the Project Type.  Options are Capital Facility or Technological Needs. "]
["Rows 8-27, Column E: Enter the amount of MHSA funds, including interest, expended for goods and services delivered during the reporting fiscal year for CFTN."]
["Row 8-27, Column F: Enter the amount of MediCal FFP funds expended for goods and services delivered during the reporting fiscal year for CFTN."]
["Row 8-27, Column G: Enter the amount of 1991 Realignment funds expended for goods and services delivered during the reporting fiscal year for CFTN."]
["Row 8-27, Column H: Enter the amount of Behavioral Health Subaccount funds expended for goods and services delivered during the reporting fiscal year for CFTN."]
["Row 8-27, Column I: Enter the amount of Other funds expended for goods and services delivered during the reporting fiscal year for CFTN."]
["Row 8-27, Column J: No entry. This amount is the sum of Rows 8-27, Columns E-I."]

{"sheet":"8. Adjustment (MHSA)","index":15,"n_rows":80,"n_cols":8,"rows_kept":80}
["Press UP or DOWN arrow to input items into each row. Use LEFT or RIGHT arrow on Row 12 to read the headers for information needed. ","STATE OF CALIFORNIA",{"$nulls":5},"Department of Health Care Services"]
[null,"HEALTH AND HUMAN SERVICES AGENCY"]
[]
[null,"DHCS 1822 H (02/19)"]
[null,{"$f":"'1. Information'!B5","v":"Annual Mental Health Services Act (MHSA) Revenue and Expenditure Report"}]
[null,{"$f":"'1. Information'!B6","v":"Fiscal Year: 2018-19"}]
[null,"MHSA Adjustments Worksheet "]
[]
[null,"County:",null,{"$f":"IF(ISBLANK('1. Information'!D11),\"\",'1. Information'!D11)","v":"Kings"},null,"Date",{"$f":"IF(ISBLANK('1. Information'!D9),\"\",'1. Information'!D9)","v":"2019-12-10"}]
[]
[null,"SECTION ONE"]
[]
[null,null,"A","B","C","D","E","F"]
[null,"#","County Code","Account","Adjustment Type","Adjustment to Fiscal Year","Amount","Reason"]
[null,1,{"$f":"IF(G15<>0,VLOOKUP($D$9,Info_County_Code,2,FALSE),\"\")","v":""}]
[null,2,""]
[null,3,""]
[null,4,""]
[null,5,""]
[null,6,""]
[null,7,""]
[null,8,""]
[null,9,""]
[null,10,""]
[null,11,""]
[null,12,""]
[null,13,""]
[null,14,""]
[null,15,""]
[null,16,""]
[null,17,""]
[null,18,""]
[null,19,""]
[null,20,""]
[null,21,""]
[null,22,""]
[null,23,""]
[null,24,""]
[null,25,""]
[null,26,""]
[null,27,""]
[null,28,""]
[null,29,""]
[null,30,""]
[null,null,{"$f":"IF(NOT(COUNTA(E45:H45)),\"\",VLOOKUP(E23,Info_County_Code,2,FALSE))","v":""}]
[]
[null,"SECTION TWO"]
[]
[null,null,"A","B","C","D","E"]
[null,"#","County Code","Account","Adjustment to Fiscal Year","Amount","Reason"]
[null,31,{"$f":"IF(F51<>0,VLOOKUP($D$9,Info_County_Code,2,FALSE),\"\")","v":""},"Prudent Reserve"]
[null,32,"","Prudent Reserve"]
[null,33,"","Prudent Reserve"]
[null,34,"","Prudent Reserve"]
[null,35,"","Prudent Reserve"]
[null,36,"","Prudent Reserve"]
[null,37,"","Prudent Reserve"]
[null,38,"","Prudent Reserve"]
[null,39,"","Prudent Reserve"]
[null,40,"","Prudent Reserve"]
[null,41,"","Prudent Reserve"]
[null,42,"","Prudent Reserve"]
[null,43,"","Prudent Reserve"]
[null,44,"","Prudent Reserve"]
[null,45,"","Prudent Reserve"]
[null,46,"","Prudent Reserve"]
[null,47,"","Prudent Reserve"]
[null,48,"","Prudent Reserve"]
[null,49,"","Prudent Reserve"]
[null,50,"","Prudent Reserve"]
[null,51,"","Prudent Reserve"]
[null,52,"","Prudent Reserve"]
[null,53,"","Prudent Reserve"]
[null,54,"","Prudent Reserve"]
[null,55,"","Prudent Reserve"]
[null,56,"","Prudent Reserve"]
[null,57,"","Prudent Reserve"]
[null,58,"","Prudent Reserve"]
[null,59,"","Prudent Reserve"]
[null,60,"","Prudent Reserve"]

{"sheet":"Instructions 8. Adjust (MHSA)","index":16,"n_rows":13,"n_cols":1,"rows_kept":13}
["Use UP or DOWN arrow to navigate spreadsheet. "]
["County: No entry. This field will auto-populate from the Information worksheet."]
["Date: No entry. This field will auto-populate from the Information worksheet."]
["Rows 1-60, Column A: No entry. This field auto-populates as the County enters expenditure data and is determined according to the County Name entered on  Worksheet 1. Information, Row 3. The County Code corresponds to the numeric ID code used to identify the County in the Data Collection and Reporting system."]
["Rows 1-30, Column B: Selection only. Enter the Account  for which the MHSA adjustment is being reported. Options include CSS, PEI, INN, WET, or CFTN."]
["Rows 1-30, Column C: Selection only. Enter the adjustment type. Options include expenditure or interest revenue. "]
["Rows 1-30, Column D: Enter the Fiscal Year for which the adjustment is being reported."]
["Rows 1-30, Column E: Enter the amount of the adjustment. Enter a positive number to reflect an increase in MHSA expenditures or interest revenue and a negative number to reflect a decrease in MHSA expenditures or interest revenue."]
["Rows 1-30, Column F: Enter the reason for the adjustment."]
["Rows 31-60, Column B: No entry. "]
["Rows 31-60, Column C: Enter the Fiscal Year for which the adjustment is being reported."]
["Rows 31-60, Column D: Enter the amount of the adjustment.  Enter a positive number to reflect an increase to the Prudent Reserve and a negative number to reflect a decrease to the Prudent Reserve."]
["Rows 31-60, Column E: Enter the reason for the adjustment."]

{"sheet":"9. Adjustment (FFP)","index":17,"n_rows":54,"n_cols":9,"rows_kept":54}
["Press UP or DOWN arrow to input items into each row. Use LEFT or RIGHT arrow on Row 12 to read the headers for information needed. ","STATE OF CALIFORNIA",{"$nulls":6},"Department of Health Care Services"]
[null,"HEALTH AND HUMAN SERVICES AGENCY"]
[]
[null,"DHCS 1822 I (02/19)"]
[null,{"$f":"'1. Information'!B5","v":"Annual Mental Health Services Act (MHSA) Revenue and Expenditure Report"}]
[null,{"$f":"'1. Information'!B6","v":"Fiscal Year: 2018-19"}]
[null,"FFP Revenue Adjustment Worksheet"]
[]
[null,"County:",null,{"$f":"IF(ISBLANK('1. Information'!D11),\"\",'1. Information'!D11)","v":"Kings"},null,"Date:",{"$f":"IF(ISBLANK('1. Information'!D9),\"\",'1. Information'!D9)","v":"2019-12-10"}]
[]
[null,"SECTION ONE"]
[]
[null,null,"A","B","C","D","E","F","G"]
[null,"#","County Code","Adjustment to FY","Cost Report Stage","Account","Beginning Balance","Adjustment Amount","Ending Balance"]
[null,1,{"$f":"IF(I15<>0,VLOOKUP($D$9,Info_County_Code,2,FALSE),\"\")","v":""},{"$nulls":5},{"$f":"SUM(G15:H15)","v":{"v":0,"d":"$0.00"}}]
[null,2,"",{"$nulls":5},{"$f":"SUM(G16:H16)","v":{"v":0,"d":"$0.00"}}]
[null,3,"",{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,4,"",{"$nulls":5},{"$f":"SUM(G18:H18)","v":{"v":0,"d":"$0.00"}}]
[null,5,"",{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,6,"",{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,7,"",{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,8,"",{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,9,"",{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,10,"",{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,11,"",{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,12,"",{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,13,"",{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,14,"",{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,15,"",{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,16,"",{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,17,"",{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,18,"",{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,19,"",{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,20,"",{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,21,"",{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,22,"",{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,23,"",{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,24,"",{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,25,"",{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,26,"",{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,27,"",{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,28,"",{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,29,"",{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,30,"",{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,31,"",{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,32,"",{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,33,"",{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,34,"",{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,35,"",{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,36,"",{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,37,"",{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,38,"",{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,39,"",{"$nulls":5},{"v":0,"d":"$0.00"}]
[null,40,"",{"$nulls":5},{"v":0,"d":"$0.00"}]

{"sheet":"Instructions 9. Adjust (FFP)","index":18,"n_rows":10,"n_cols":1,"rows_kept":10}
["Use UP or DOWN arrow to navigate spreadsheet. "]
["County: No entry. This field will auto-populate from the Information worksheet."]
["Date: No entry. This field will auto-populate from the Information worksheet."]
["Rows 1-40, Column A: No entry. This field auto-populates as the County enters expenditure data and is determined according to the County Name entered on  Worksheet 1. Information, Row 3. The County Code corresponds to the numeric ID code used to identify the County in the Data Collection and Reporting system."]
["Rows 1-40, Column B: Enter the fiscal year for which the County is entering an adjustment to the amount of MHSA funds expended due to a change in FFP revenue."]
["Rows 1-40, Column C: Selection only. Enter cost report stage.  Options include Initial, Settled, Audited. Select Initial if the adjustment is due to a change to the amount of FFP revenue after the County filed its initial cost report for the Fiscal Year identified in Column B.  Select Settled, if the adjustment is due to a change to the amount of FFP revenue after the Department completed its interim cost report settlement for the Fiscal Year identified in Column B.  Select Audit, if the adjustment is due to a change to the amount of FFP revenue received after DHCS completed its audit of the cost report for the Fiscal Year identified in Column B."]
["Rows 1-40, Column D: Selection only. Enter the Account  for which the MHSA adjustment is being reported. Options include CSS, PEI, INN, WET, or CFTN."]
["Rows 1-40, Column E: Enter the amount of MHSA funds expended for the component identified in Column D as reported in the ARER filed for the fiscal year identified in Column B."]
["Rows 1-40, Column F: Enter the amount of the MHSA expenditures to be adjusted. Enter a positive number to report an increase to MHSA expenditures and a negative number to report a decrease to MHSA expenditures."]
["Rows 1-40, Column G: No entry. This amount is the sum of Rows 1-40, Columns E-F."]

{"sheet":"10. Comments","index":19,"n_rows":52,"n_cols":7,"rows_kept":52}
["Press UP or DOWN arrow to leave comments on the cell rows. ","STATE OF CALIFORNIA",{"$nulls":3},"Department of Health Care Services"]
[null,"HEALTH AND HUMAN SERVICES AGENCY"]
[]
[null,"DHCS 1822 J (02/19)"]
[null,{"$f":"'1. Information'!B5","v":"Annual Mental Health Services Act (MHSA) Revenue and Expenditure Report"}]
[null,{"$f":"'1. Information'!B6","v":"Fiscal Year: 2018-19"}]
[null,"Comments Worksheet"]
[]
[null,"County:",{"$f":"IF(ISBLANK('1. Information'!D11),\"\",'1. Information'!D11)","v":"Kings"},null,null,"Date:",{"$f":"IF(ISBLANK('1. Information'!D9),\"\",'1. Information'!D9)","v":"2019-12-10"}]
[]
[null,null,"A","B","C"]
[null,"#","Account","Fiscal Year","Comments"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[null,32]
[null,33]
[null,34]
[null,35]
[null,36]
[null,37]
[null,38]
[null,39]
[null,40]

{"sheet":"Instructions 10. Comments","index":20,"n_rows":6,"n_cols":1,"rows_kept":6}
["Use UP or DOWN arrow to navigate spreadsheet. "]
["County: No entry. This field will auto-populate from the Information worksheet."]
["Date: No entry. This field will auto-populate from the Information worksheet."]
["Rows 1-40, Column A: Selection only. Select the account for which the Comment is necessary."]
["Rows 1-40. Column B: Enter the Fiscal Year for which the Comment is necessary."]
["Rows 1-40, Column C: Enter the Comment."]

{"sheet":"Checks","index":21,"n_rows":64,"n_cols":9,"rows_kept":64,"hidden":true}
["SCO Distribution"]
["FY 2017-18"]
[null,null,"Total x 76%","Total x 19%","Total x 5%",null,"County Check:",{"$f":"'1. Information'!D11","v":"Kings"}]
["County","TOTAL","CSS","PEI","INN"]
["Alameda",{"v":70551654.33,"d":"$70,551,654.33"},{"$f":"B5*0.76","v":{"v":53619257.2908,"d":"$53,619,257.29"}},{"$f":"B5*0.19","v":{"v":13404814.3227,"d":"$13,404,814.32"}},{"$f":"B5*0.05","v":{"v":3527582.7165,"d":"$3,527,582.72"}},null,"Cell","Status","Notes"]
["Alpine",{"v":1499512.8499999999,"d":"$1,499,512.85"},{"$f":"B6*0.76","v":{"v":1139629.7659999998,"d":"$1,139,629.77"}},{"$f":"B6*0.19","v":{"v":284907.44149999996,"d":"$284,907.44"}},{"$f":"B6*0.05","v":{"v":74975.6425,"d":"$74,975.64"}},null,"='2. Component Summary'!I24",{"$f":"IF(SUM('2. Component Summary'!D27:H27)='2. Component Summary'!I27,\"OK\",\"ERROR\")","v":"OK"},"CSS Transfers to PEI, WET, CFTN, or Prudent Reserve must net to total 0"]
["Amador",{"v":2931915.6899999995,"d":"$2,931,915.69"},{"v":2228255.9243999994,"d":"$2,228,255.92"},{"v":557063.9810999999,"d":"$557,063.98"},{"v":146595.78449999998,"d":"$146,595.78"},null,"='2. Component Summary'!D37",{"$f":"IF('2. Component Summary'!D40*0.05>VLOOKUP(H3,SCO_Distribution,2,FALSE),\"ERROR\",\"OK\")","v":"OK"},"Total MHSA costs for planning for all components may not exceed 5 percent of the total annual MHSA revenues received by the County."]
["Berkeley",{"v":5994545.009999999,"d":"$5,994,545.01"},{"v":4555854.207599999,"d":"$4,555,854.21"},{"v":1138963.5518999998,"d":"$1,138,963.55"},{"v":299727.25049999997,"d":"$299,727.25"},null,"='2. Component Summary'!D43",{"$f":"IF(ISBLANK('2. Component Summary'!D46),\"ERROR\",\"OK\")","v":"OK"},"Counties must report total MHSA funds spent on mental health services provided to veterans for all programs and projects funded through the Community Services and Supports, Prevention and Early Intervention, and Innovation components, combined. ENTER $0 IF NO SPENDING."]
["Butte",{"v":11405471.799999999,"d":"$11,405,471.80"},{"v":8668158.568,"d":"$8,668,158.57"},{"v":2167039.642,"d":"$2,167,039.64"},{"v":570273.59,"d":"$570,273.59"},null,"='2. Component Summary'!G12",{"$f":"IF(ISBLANK('2. Component Summary'!I14),\"ERROR\",\"OK\")","v":"OK"},"Counties must report the total amount of interest earned on the local MHS fund"]
["Calaveras",{"v":3208867.31,"d":"$3,208,867.31"},{"v":2438739.1556,"d":"$2,438,739.16"},{"v":609684.7889,"d":"$609,684.79"},{"v":160443.3655,"d":"$160,443.37"},null,"='2. Component Summary'!F16",{"$f":"IF(ISBLANK('2. Component Summary'!F19),\"ERROR\",\"OK\")","v":"OK"},"Please report the beginning balance of the local prudent reserve. This amount must match the prudent reserve ending balance reported in the FY 2016-17 ARER"]
["Colusa",{"v":2568596.2199999997,"d":"$2,568,596.22"},{"v":1952133.1271999998,"d":"$1,952,133.13"},{"v":488033.28179999994,"d":"$488,033.28"},{"v":128429.81099999999,"d":"$128,429.81"}]
["Contra Costa",{"v":45360350.14000001,"d":"$45,360,350.14"},{"v":34473866.106400006,"d":"$34,473,866.11"},{"v":8618466.526600001,"d":"$8,618,466.53"},{"v":2268017.5070000007,"d":"$2,268,017.51"}]
["Del Norte",{"v":2728833.71,"d":"$2,728,833.71"},{"v":2073913.6196,"d":"$2,073,913.62"},{"v":518478.4049,"d":"$518,478.40"},{"v":136441.6855,"d":"$136,441.69"}]
["El Dorado",{"v":7928641.309999999,"d":"$7,928,641.31"},{"v":6025767.395599999,"d":"$6,025,767.40"},{"v":1506441.8488999999,"d":"$1,506,441.85"},{"v":396432.06549999997,"d":"$396,432.07"}]
["Fresno",{"v":49459289.239999995,"d":"$49,459,289.24"},{"v":37589059.822399996,"d":"$37,589,059.82"},{"v":9397264.955599999,"d":"$9,397,264.96"},{"v":2472964.462,"d":"$2,472,964.46"}]
["Glenn",{"v":2777161.3,"d":"$2,777,161.30"},{"v":2110642.588,"d":"$2,110,642.59"},{"v":527660.647,"d":"$527,660.65"},{"v":138858.065,"d":"$138,858.07"}]
["Humboldt",{"v":7058805.660000001,"d":"$7,058,805.66"},{"v":5364692.301600001,"d":"$5,364,692.30"},{"v":1341173.0754000002,"d":"$1,341,173.08"},{"v":352940.28300000005,"d":"$352,940.28"}]
["Imperial",{"v":9759832.08,"d":"$9,759,832.08"},{"v":7417472.3808,"d":"$7,417,472.38"},{"v":1854368.0952,"d":"$1,854,368.10"},{"v":487991.60400000005,"d":"$487,991.60"}]
["Inyo",{"v":1843374.33,"d":"$1,843,374.33"},{"v":1400964.4908,"d":"$1,400,964.49"},{"v":350241.1227,"d":"$350,241.12"},{"v":92168.71650000001,"d":"$92,168.72"}]
["Kern",{"v":42775932.49,"d":"$42,775,932.49"},{"v":32509708.6924,"d":"$32,509,708.69"},{"v":8127427.1731,"d":"$8,127,427.17"},{"v":2138796.6245000004,"d":"$2,138,796.62"}]
["Kings",{"v":8142509.42,"d":"$8,142,509.42"},{"v":6188307.1592,"d":"$6,188,307.16"},{"v":1547076.7898,"d":"$1,547,076.79"},{"v":407125.471,"d":"$407,125.47"}]
["Lake",{"v":3954947.83,"d":"$3,954,947.83"},{"v":3005760.3508,"d":"$3,005,760.35"},{"v":751440.0877,"d":"$751,440.09"},{"v":197747.39150000003,"d":"$197,747.39"}]
["Lassen",{"v":2718985.63,"d":"$2,718,985.63"},{"v":2066429.0788,"d":"$2,066,429.08"},{"v":516607.2697,"d":"$516,607.27"},{"v":135949.2815,"d":"$135,949.28"}]
["Los Angeles",{"v":562799427.95,"d":"$562,799,427.95"},{"v":427727565.24200004,"d":"$427,727,565.24"},{"v":106931891.31050001,"d":"$106,931,891.31"},{"v":28139971.397500005,"d":"$28,139,971.40"}]
["Madera",{"v":8618217.030000001,"d":"$8,618,217.03"},{"v":6549844.942800001,"d":"$6,549,844.94"},{"v":1637461.2357000003,"d":"$1,637,461.24"},{"v":430910.8515000001,"d":"$430,910.85"}]
["Marin",{"v":11207287.7,"d":"$11,207,287.70"},{"v":8517538.651999999,"d":"$8,517,538.65"},{"v":2129384.6629999997,"d":"$2,129,384.66"},{"v":560364.385,"d":"$560,364.39"}]
["Mariposa",{"v":1848530.92,"d":"$1,848,530.92"},{"v":1404883.4992,"d":"$1,404,883.50"},{"v":351220.8748,"d":"$351,220.87"},{"v":92426.546,"d":"$92,426.55"}]
["Mendocino",{"v":4823051.5200000005,"d":"$4,823,051.52"},{"v":3665519.1552000004,"d":"$3,665,519.16"},{"v":916379.7888000001,"d":"$916,379.79"},{"v":241152.57600000003,"d":"$241,152.58"}]
["Merced",{"v":14640569.48,"d":"$14,640,569.48"},{"v":11126832.8048,"d":"$11,126,832.80"},{"v":2781708.2012,"d":"$2,781,708.20"},{"v":732028.474,"d":"$732,028.47"}]
["Modoc",{"v":1685960.2599999998,"d":"$1,685,960.26"},{"v":1281329.7976,"d":"$1,281,329.80"},{"v":320332.4494,"d":"$320,332.45"},{"v":84298.01299999999,"d":"$84,298.01"}]
["Mono",{"v":1795078.7,"d":"$1,795,078.70"},{"v":1364259.812,"d":"$1,364,259.81"},{"v":341064.953,"d":"$341,064.95"},{"v":89753.935,"d":"$89,753.94"}]
["Monterey",{"v":23244033.94999999,"d":"$23,244,033.95"},{"v":17665465.801999994,"d":"$17,665,465.80"},{"v":4416366.450499998,"d":"$4,416,366.45"},{"v":1162201.6974999995,"d":"$1,162,201.70"}]
["Napa",{"v":6536717.39,"d":"$6,536,717.39"},{"v":4967905.2164,"d":"$4,967,905.22"},{"v":1241976.3041,"d":"$1,241,976.30"},{"v":326835.86950000003,"d":"$326,835.87"}]
["Nevada",{"v":5205259.92,"d":"$5,205,259.92"},{"v":3955997.5392,"d":"$3,955,997.54"},{"v":988999.3848,"d":"$988,999.38"},{"v":260262.996,"d":"$260,263.00"}]
["Orange",{"v":161768522.68,"d":"$161,768,522.68"},{"v":122944077.2368,"d":"$122,944,077.24"},{"v":30736019.3092,"d":"$30,736,019.31"},{"v":8088426.134000001,"d":"$8,088,426.13"}]
["Placer",{"v":13984445.129999997,"d":"$13,984,445.13"},{"v":10628178.298799997,"d":"$10,628,178.30"},{"v":2657044.5746999993,"d":"$2,657,044.57"},{"v":699222.2564999999,"d":"$699,222.26"}]
["Plumas",{"v":2467653.1999999997,"d":"$2,467,653.20"},{"v":1875416.4319999998,"d":"$1,875,416.43"},{"v":468854.10799999995,"d":"$468,854.11"},{"v":123382.65999999999,"d":"$123,382.66"}]
["Riverside",{"v":107758676.78999998,"d":"$107,758,676.79"},{"v":81896594.36039998,"d":"$81,896,594.36"},{"v":20474148.590099994,"d":"$20,474,148.59"},{"v":5387933.839499999,"d":"$5,387,933.84"}]
["Sacramento",{"v":64816236.61000001,"d":"$64,816,236.61"},{"v":49260339.82360001,"d":"$49,260,339.82"},{"v":12315084.955900002,"d":"$12,315,084.96"},{"v":3240811.8305000006,"d":"$3,240,811.83"}]
["San Benito",{"v":3734424.29,"d":"$3,734,424.29"},{"v":2838162.4604,"d":"$2,838,162.46"},{"v":709540.6151,"d":"$709,540.62"},{"v":186721.2145,"d":"$186,721.21"}]
["San Bernardino",{"v":105985451.15,"d":"$105,985,451.15"},{"v":80548942.87400001,"d":"$80,548,942.87"},{"v":20137235.718500003,"d":"$20,137,235.72"},{"v":5299272.557500001,"d":"$5,299,272.56"}]
["San Diego",{"v":162263869.35,"d":"$162,263,869.35"},{"v":123320540.706,"d":"$123,320,540.71"},{"v":30830135.1765,"d":"$30,830,135.18"},{"v":8113193.4675,"d":"$8,113,193.47"}]
["San Francisco",{"v":36784240.54000001,"d":"$36,784,240.54"},{"v":27956022.810400005,"d":"$27,956,022.81"},{"v":6989005.702600001,"d":"$6,989,005.70"},{"v":1839212.0270000005,"d":"$1,839,212.03"}]
["San Joaquin",{"v":34063364.47,"d":"$34,063,364.47"},{"v":25888156.9972,"d":"$25,888,157.00"},{"v":6472039.2493,"d":"$6,472,039.25"},{"v":1703168.2235,"d":"$1,703,168.22"}]
["San Luis Obispo",{"v":13341171.349999998,"d":"$13,341,171.35"},{"v":10139290.225999998,"d":"$10,139,290.23"},{"v":2534822.5564999995,"d":"$2,534,822.56"},{"v":667058.5674999999,"d":"$667,058.57"}]
["San Mateo",{"v":32446715.590000004,"d":"$32,446,715.59"},{"v":24659503.848400004,"d":"$24,659,503.85"},{"v":6164875.962100001,"d":"$6,164,875.96"},{"v":1622335.7795000002,"d":"$1,622,335.78"}]
["Santa Barbara",{"v":22984920.520000003,"d":"$22,984,920.52"},{"v":17468539.595200002,"d":"$17,468,539.60"},{"v":4367134.898800001,"d":"$4,367,134.90"},{"v":1149246.0260000003,"d":"$1,149,246.03"}]
["Santa Clara",{"v":89754925.08,"d":"$89,754,925.08"},{"v":68213743.0608,"d":"$68,213,743.06"},{"v":17053435.7652,"d":"$17,053,435.77"},{"v":4487746.254,"d":"$4,487,746.25"}]
["Santa Cruz",{"v":14340650.48,"d":"$14,340,650.48"},{"v":10898894.3648,"d":"$10,898,894.36"},{"v":2724723.5912,"d":"$2,724,723.59"},{"v":717032.5240000001,"d":"$717,032.52"}]
["Shasta",{"v":9451466.329999998,"d":"$9,451,466.33"},{"v":7183114.410799999,"d":"$7,183,114.41"},{"v":1795778.6026999997,"d":"$1,795,778.60"},{"v":472573.31649999996,"d":"$472,573.32"}]
["Sierra",{"v":1543875.5100000002,"d":"$1,543,875.51"},{"v":1173345.3876000002,"d":"$1,173,345.39"},{"v":293336.34690000006,"d":"$293,336.35"},{"v":77193.77550000002,"d":"$77,193.78"}]
["Siskiyou",{"v":3180379.8300000005,"d":"$3,180,379.83"},{"v":2417088.6708000004,"d":"$2,417,088.67"},{"v":604272.1677000001,"d":"$604,272.17"},{"v":159018.99150000003,"d":"$159,018.99"}]
["Solano",{"v":19695352.549999997,"d":"$19,695,352.55"},{"v":14968467.937999997,"d":"$14,968,467.94"},{"v":3742116.9844999993,"d":"$3,742,116.98"},{"v":984767.6275,"d":"$984,767.63"}]
["Sonoma",{"v":22448346.500000004,"d":"$22,448,346.50"},{"v":17060743.340000004,"d":"$17,060,743.34"},{"v":4265185.835000001,"d":"$4,265,185.84"},{"v":1122417.3250000002,"d":"$1,122,417.33"}]
["Stanislaus",{"v":25846252.59,"d":"$25,846,252.59"},{"v":19643151.9684,"d":"$19,643,151.97"},{"v":4910787.9921,"d":"$4,910,787.99"},{"v":1292312.6295,"d":"$1,292,312.63"}]
["Sutter",{"v":8720457.47,"d":"$8,720,457.47"},{"v":6627547.677200001,"d":"$6,627,547.68"},{"v":1656886.9193000002,"d":"$1,656,886.92"},{"v":436022.87350000005,"d":"$436,022.87"}]
["Tehama",{"v":3817793.55,"d":"$3,817,793.55"},{"v":2901523.0979999998,"d":"$2,901,523.10"},{"v":725380.7744999999,"d":"$725,380.77"},{"v":190889.6775,"d":"$190,889.68"}]
["Tri-City",{"v":11170390.67,"d":"$11,170,390.67"},{"v":8489496.9092,"d":"$8,489,496.91"},{"v":2122374.2273,"d":"$2,122,374.23"},{"v":558519.5335,"d":"$558,519.53"}]
["Trinity",{"v":1780320.58,"d":"$1,780,320.58"},{"v":1353043.6408000002,"d":"$1,353,043.64"},{"v":338260.91020000004,"d":"$338,260.91"},{"v":89016.02900000001,"d":"$89,016.03"}]
["Tulare",{"v":24328481.469999995,"d":"$24,328,481.47"},{"v":18489645.917199995,"d":"$18,489,645.92"},{"v":4622411.479299999,"d":"$4,622,411.48"},{"v":1216424.0734999997,"d":"$1,216,424.07"}]
["Tuolumne",{"v":3531297.5500000003,"d":"$3,531,297.55"},{"v":2683786.1380000003,"d":"$2,683,786.14"},{"v":670946.5345000001,"d":"$670,946.53"},{"v":176564.87750000003,"d":"$176,564.88"}]
["Ventura",{"v":40893418.26,"d":"$40,893,418.26"},{"v":31078997.8776,"d":"$31,078,997.88"},{"v":7769749.4694,"d":"$7,769,749.47"},{"v":2044670.913,"d":"$2,044,670.91"}]
["Yolo",{"v":10880652.61,"d":"$10,880,652.61"},{"v":8269295.9836,"d":"$8,269,295.98"},{"v":2067323.9959,"d":"$2,067,324.00"},{"v":544032.6305,"d":"$544,032.63"}]
["Grand Total",{"$f":"SUM(B5:B63)","v":{"v":1978857113.8699994,"d":"$1,978,857,113.87"}},{"$f":"SUM(C5:C63)","v":{"v":1503931406.5412004,"d":"$1,503,931,406.54"}},{"v":375982851.6353001,"d":"$375,982,851.64"},{"v":98942855.69349995,"d":"$98,942,855.69"}]

{"sheet":"drop down fields","index":22,"n_rows":60,"n_cols":14,"rows_kept":60,"hidden":true,"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","MHSA_Adjustment_FY","FFP_Adjustment_FY","Adjustment_Reason","Cost_Report_Stage"]
["Alameda",{"v":1,"d":"01"},"Yes","FSP","Combined","Prevention","Project","Workforce Staffing","Capital Facility","CSS","FY 2015-16","FY 2009-10","Cost Report Reconciliation","Audited"]
["Alpine",{"v":2,"d":"02"},"No","Non-FSP","Standalone","Early Intervention","Project Administration","Training/Technical Assistance","Technological Need","PEI","FY 2016-17","FY 2010-11","Cost Report Audit","Settled"]
["Amador",{"v":3,"d":"03"},{"$nulls":3},"Outreach","Project Evaluation","MH Career Pathways",null,"INN",null,"FY 2011-12","SDMC Chart Audit","Initial"]
["Berkeley City",65,{"$nulls":3},"Stigma & Discrimination Reduction",null,"Residency/Internship",null,"WET",null,"FY 2012-13","Local Quality Assurance Audit"]
["Butte",{"v":4,"d":"04"},{"$nulls":3},"Suicide Prevention",null,"Financial Incentive",null,"CFTN",null,"FY 2013-14","Error"]
["Calaveras",{"v":5,"d":"05"},{"$nulls":3},"Access and Linkage",{"$nulls":3},"WET RP",null,"FY 2014-15","Other"]
["Colusa",{"v":6,"d":"06"},{"$nulls":3},"Improving Timely Access",{"$nulls":3},"PEI SW",null,"FY 2015-16"]
["Contra Costa",{"v":7,"d":"07"},{"$nulls":3},"Combined Summary",{"$nulls":3},"MHSA HP",null,"FY 2016-17"]
["Del Norte",{"v":8,"d":"08"},{"$nulls":7},"Prudent Reserve"]
["El Dorado",{"v":9,"d":"09"}]
["Fresno",10]
["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":23,"n_rows":83,"n_cols":5,"rows_kept":83,"hidden":true,"merged":[[1,0,1,4],[2,0,2,4],[4,1,4,2]]}
[{"$nulls":3},"About the Data"]
["E-1: State/County Population Estimates with Annual Percent Change"]
["January 1, 2017 and 2018"]
[]
["State/County","           Total Population",null,"Percent"]
[null,"2017-01-01","2018-01-01","Change","County Population:  Over 200,000? (Yes or No)"]
[]
["California",{"v":39500973,"d":"39,500,973"},{"v":39809693,"d":"39,809,693"},0.8]
[]
["Alameda",{"v":1646405,"d":"1,646,405"},{"v":1660202,"d":"1,660,202"},0.8,{"$f":"IF(B10>=200000,\"Yes\", \"No\")","v":"Yes"}]
["Alpine",{"v":1156,"d":"1,156"},{"v":1154,"d":"1,154"},-0.2,{"$f":"IF(B11>=200000,\"Yes\", \"No\")","v":"No"}]
["Amador",{"v":38382,"d":"38,382"},{"v":38094,"d":"38,094"},-0.8,"No"]
["Butte",{"v":226403,"d":"226,403"},{"v":227621,"d":"227,621"},0.5,"Yes"]
["Calaveras",{"v":45175,"d":"45,175"},{"v":45157,"d":"45,157"},{"v":0,"d":"0.0"},"No"]
["Colusa",{"v":22050,"d":"22,050"},{"v":22098,"d":"22,098"},0.2,"No"]
["Contra Costa",{"v":1139313,"d":"1,139,313"},{"v":1149363,"d":"1,149,363"},0.9,"Yes"]
["Del Norte",{"v":27060,"d":"27,060"},{"v":27221,"d":"27,221"},0.6,"No"]
["El Dorado",{"v":186223,"d":"186,223"},{"v":188399,"d":"188,399"},1.2,"No"]
["Fresno",{"v":995233,"d":"995,233"},{"v":1007229,"d":"1,007,229"},1.2,"Yes"]
["Glenn",{"v":28730,"d":"28,730"},{"v":28796,"d":"28,796"},0.2,"No"]
["Humboldt",{"v":136430,"d":"136,430"},{"v":136002,"d":"136,002"},-0.3,"No"]
["Imperial",{"v":187921,"d":"187,921"},{"v":190624,"d":"190,624"},1.4,"No"]
["Inyo",{"v":18598,"d":"18,598"},{"v":18577,"d":"18,577"},-0.1,"No"]
["Kern",{"v":896101,"d":"896,101"},{"v":905801,"d":"905,801"},1.1,"Yes"]
["Kings",{"v":149559,"d":"149,559"},{"v":151662,"d":"151,662"},1.4,"No"]
["Lake",{"v":64740,"d":"64,740"},{"v":65081,"d":"65,081"},0.5,"No"]
["Lassen",{"v":30661,"d":"30,661"},{"v":30911,"d":"30,911"},0.8,"No"]
["Los Angeles",{"v":10231271,"d":"10,231,271"},{"v":10283729,"d":"10,283,729"},0.5,"Yes"]
["Madera",{"v":156963,"d":"156,963"},{"v":158894,"d":"158,894"},1.2,"No"]
["Marin",{"v":263262,"d":"263,262"},{"v":263886,"d":"263,886"},0.2,"Yes"]
["Mariposa",{"v":18137,"d":"18,137"},{"v":18129,"d":"18,129"},{"v":0,"d":"0.0"},"No"]
["Mendocino",{"v":89092,"d":"89,092"},{"v":89299,"d":"89,299"},0.2,"No"]
["Merced",{"v":275104,"d":"275,104"},{"v":279977,"d":"279,977"},1.8,"Yes"]
["Modoc",{"v":9562,"d":"9,562"},{"v":9612,"d":"9,612"},0.5,"No"]
["Mono",{"v":13759,"d":"13,759"},{"v":13822,"d":"13,822"},0.5,"No"]
["Monterey",{"v":442149,"d":"442,149"},{"v":443281,"d":"443,281"},0.3,"Yes"]
["Napa",{"v":141784,"d":"141,784"},{"v":141294,"d":"141,294"},-0.3,"No"]
["Nevada",{"v":98613,"d":"98,613"},{"v":99155,"d":"99,155"},0.5,"No"]
["Orange",{"v":3198968,"d":"3,198,968"},{"v":3221103,"d":"3,221,103"},0.7,"Yes"]
["Placer",{"v":383173,"d":"383,173"},{"v":389532,"d":"389,532"},1.7,"Yes"]
["Plumas",{"v":19818,"d":"19,818"},{"v":19773,"d":"19,773"},-0.2,"No"]
["Riverside",{"v":2382640,"d":"2,382,640"},{"v":2415955,"d":"2,415,955"},1.4,"Yes"]
["Sacramento",{"v":1513415,"d":"1,513,415"},{"v":1529501,"d":"1,529,501"},1.1,"Yes"]
["San Benito",{"v":56879,"d":"56,879"},{"v":57088,"d":"57,088"},0.4,"No"]
["San Bernardino",{"v":2155590,"d":"2,155,590"},{"v":2174938,"d":"2,174,938"},0.9,"Yes"]
["San Diego",{"v":3309509,"d":"3,309,509"},{"v":3337456,"d":"3,337,456"},0.8,"Yes"]
["San Francisco",{"v":874008,"d":"874,008"},{"v":883963,"d":"883,963"},1.1,"Yes"]
["San Joaquin",{"v":747263,"d":"747,263"},{"v":758744,"d":"758,744"},1.5,"Yes"]
["San Luis Obispo",{"v":279210,"d":"279,210"},{"v":280101,"d":"280,101"},0.3,"Yes"]
["San Mateo",{"v":770256,"d":"770,256"},{"v":774155,"d":"774,155"},0.5,"Yes"]
["Santa Barbara",{"v":450025,"d":"450,025"},{"v":453457,"d":"453,457"},0.8,"Yes"]
["Santa Clara",{"v":1937473,"d":"1,937,473"},{"v":1956598,"d":"1,956,598"},{"v":1,"d":"1.0"},"Yes"]
["Santa Cruz",{"v":276504,"d":"276,504"},{"v":276864,"d":"276,864"},0.1,"Yes"]
["Shasta",{"v":178148,"d":"178,148"},{"v":178271,"d":"178,271"},0.1,"No"]
["Sierra",{"v":3203,"d":"3,203"},{"v":3207,"d":"3,207"},0.1,"No"]
["Siskiyou",{"v":44655,"d":"44,655"},{"v":44612,"d":"44,612"},-0.1,"No"]
["Solano",{"v":436640,"d":"436,640"},{"v":439793,"d":"439,793"},0.7,"Yes"]
["Sonoma",{"v":504613,"d":"504,613"},{"v":503332,"d":"503,332"},-0.3,"Yes"]
["Stanislaus",{"v":549976,"d":"549,976"},{"v":555624,"d":"555,624"},{"v":1,"d":"1.0"},"Yes"]
["Sutter",{"v":96919,"d":"96,919"},{"v":97238,"d":"97,238"},0.3,"No"]
["Tehama",{"v":63949,"d":"63,949"},{"v":64039,"d":"64,039"},0.1,"No"]
["Trinity",{"v":13634,"d":"13,634"},{"v":13635,"d":"13,635"},{"v":0,"d":"0.0"},"No"]
["Tulare",{"v":470716,"d":"470,716"},{"v":475834,"d":"475,834"},1.1,"Yes"]
["Tuolumne",{"v":54725,"d":"54,725"},{"v":54740,"d":"54,740"},{"v":0,"d":"0.0"},"No"]
["Ventura",{"v":855910,"d":"855,910"},{"v":859073,"d":"859,073"},0.4,"Yes"]
["Yolo",{"v":218673,"d":"218,673"},{"v":221270,"d":"221,270"},1.2,"Yes"]
["Yuba",{"v":74645,"d":"74,645"},{"v":74727,"d":"74,727"},0.1,"No"]
[]
["Sutter/Yuba",{"$f":"B60+B67","v":{"v":171564,"d":"171,564"}},{"$f":"C60+C67","v":{"v":171965,"d":"171,965"}},null,"No"]
["Berkeley City",{"v":120700,"d":"120,700"},{"v":121874,"d":"121,874"},1,"No"]
["Tri-City",{"$f":"B73+B74+B75","v":{"v":224180,"d":"224,180"}},{"$f":"C73+C74+C75","v":{"v":225393,"d":"225,393"}},null,"Yes"]
[]
["Claremont",{"v":36293,"d":"36,293"},{"v":36446,"d":"36,446"},0.4]
["La Verne",{"v":33169,"d":"33,169"},{"v":33260,"d":"33,260"},0.3]
["Pomona",{"v":154718,"d":"154,718"},{"v":155687,"d":"155,687"},0.6]
[]
[]
["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"]