{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["DHCS Only","1. Information","2. Component Summary","3. CSS","4. PEI","5. INN","6. WET","7. CFTN","8. Adjustment (MHSA)","9. Adjustment (FFP)","10. Comments","Checks","drop down fields","E-1 CountyState2017"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":41,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

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

{"sheet":"1. Information","index":1,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[null,"STATE OF CALIFORNIA",null,null,"Department of Health Care Services"]
[null,"HEALTH AND HUMAN SERVICES AGENCY"]
[]
[null,"DHCS 1822 A (Rev. 10/18)"]
[null,"Annual Mental Health Services Act Revenue and Expenditure Report"]
[null,{"$f":"\"Fiscal Year: \"&D10","v":"Fiscal Year: 2022-23"}]
[null,"Information"]
[]
[null,1,"Date:","2024-03-07"]
[null,2,"RER Fiscal Year (20YY-YY):","2022-23"]
[null,3,"County:","San Benito"]
[null,4,"County Code:",{"$f":"IF(ISBLANK(D11),\"\",VLOOKUP(D11,Info_County_Code,2))","v":35}]
[null,5,"Address:","1131 Community Parkway"]
[null,6,"City:","Hollister, CA"]
[null,7,"Zip:",95023]
[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:","Sandra Urbina"]
[null,10,"Title of Preparer:","Accountant III"]
[null,11,"Preparer Contact Email:","saurbina@sbcmh.org"]
[null,12,"Preparer Contact Telephone","(831)836-4020"]

{"sheet":"2. Component Summary","index":2,"n_rows":46,"n_cols":10,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[null,"STATE OF CALIFORNIA",null,null,null,null,null,null,"Department of Health Care Services"]
[null,"HEALTH AND HUMAN SERVICES AGENCY"]
[]
[null,"DHCS 1822 B (Rev. 10/18)"]
[null,{"$f":"'1. Information'!B5","v":"Annual Mental Health Services Act Revenue and Expenditure Report"}]
[null,{"$f":"'1. Information'!B6","v":"Fiscal Year: 2022-23"}]
[null,"Component Summary "]
[]
[null,"County:",{"$f":"IF(ISBLANK('1. Information'!D11),\"\",'1. Information'!D11)","v":"San Benito"},null,null,"Date:",{"$f":"IF(ISBLANK('1. Information'!D9),\"\",'1. Information'!D9)","v":"2024-03-07"}]
[]
[]
[null,null,null,"A","B","C","D","E","F"]
[null,"SECTION 1: Interest",null,"CSS","PEI","INN","WET","CFTN","TOTAL"]
[null,1,"Component Interest Earned",{"$f":"231207.69+20601.18","v":251808.87},57801.919999999998,15211.03,3647.66,29509.64,{"$f":"SUM(D14:H14)","v":357979.12}]
[null,2,"Joint Powers Authority Interest Earned",null,null,null,null,null,{"$f":"SUM(D15:H15)","v":0}]
[]
[null,null,null,"A","B","C"]
[null,"SECTION 2: Prudent Reserve",null,"CSS","PEI","TOTAL"]
[null,3,"Local Prudent Reserve Beginning Balance",null,null,790759]
[null,4,"Transfer from Local Prudent Reserve",null,null,{"$f":"-D20-E20","v":0}]
[null,5,"CSS Funds Transferred to Local Prudent Reserve",{"$f":"'3. CSS'!F24","v":0},null,{"$f":"SUM(D21:E21)","v":0}]
[null,6,"Local Prudent Reserve Adjustments",null,null,{"$f":"SUM('8. Adjustment (MHSA)'!F85:F114)","v":0}]
[null,7,"Local Prudent Reserve Ending Balance",null,null,{"$f":"F19+F20+F21+F22","v":790759}]
[]
[null,null,null,"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":-784932.05},{"$f":"'3. CSS'!F21","v":0},{"$f":"'3. CSS'!F22","v":0},{"$f":"'3. CSS'!F23","v":784932.05},{"$f":"'3. CSS'!F24","v":0},{"$f":"SUM(D27:H27)","v":0},{"$f":"IF(SUM(D27:H27)=I27,\"\",\"ERROR\")","v":""}]
[]
[null,null,null,"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":2126307.6},{"$f":"'4. PEI'!F22","v":690210.4},{"$f":"'5. INN'!F23","v":396170.66000000003},{"$f":"'6. WET'!F21","v":102577.7},{"$f":"'7. CFTN'!F22","v":1304136.79},{"$f":"SUM(D31:H31)","v":4619403.1500000004}]
[null,10,"Medi-Cal FFP",{"$f":"'3. CSS'!G27","v":2663513.96},{"$f":"'4. PEI'!G22","v":0},{"$f":"'5. INN'!G23","v":0},{"$f":"'6. WET'!G21","v":0},{"$f":"'7. CFTN'!G22","v":0},2663513.96]
[null,11,"1991 Realignment",{"$f":"'3. CSS'!H27","v":560864.52},{"$f":"'4. PEI'!H22","v":0},{"$f":"'5. INN'!H23","v":0},{"$f":"'6. WET'!H21","v":0},{"$f":"'7. CFTN'!H22","v":0},560864.52]
[null,12,"Behavioral Health Subaccount",{"$f":"'3. CSS'!I27","v":260449.18},{"$f":"'4. PEI'!I22","v":0},{"$f":"'5. INN'!I23","v":0},{"$f":"'6. WET'!I21","v":0},{"$f":"'7. CFTN'!I22","v":0},260449.18]
[null,13,"Other",{"$f":"'3. CSS'!J27","v":1107819.8799999999},{"$f":"'4. PEI'!J22","v":0},{"$f":"'5. INN'!J23","v":0},{"$f":"'6. WET'!J21","v":0},{"$f":"'7. CFTN'!J22","v":0},1107819.8799999999]
[null,14,"TOTAL",{"$f":"SUM(D31:D35)","v":6718955.1399999997},{"$f":"SUM(E31:E35)","v":690210.4},{"$f":"SUM(F31:F35)","v":396170.66000000003},{"$f":"SUM(G31:G35)","v":102577.7},{"$f":"SUM(H31:H35)","v":1304136.79},9212050.6900000013]
[]
[null,null,null,"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":18461}]
[null,16,"Total Evaluation Costs",{"$f":"'3. CSS'!K16+'4. PEI'!K16+'5. INN'!K20+'6. WET'!K16+'7. CFTN'!K17+'7. CFTN'!K18","v":19360}]
[null,17,"Total Administration",{"$f":"'3. CSS'!K17+'4. PEI'!K17+'5. INN'!K16+'5. INN'!K19+'6. WET'!K17+'7. CFTN'!K19+'7. CFTN'!K20","v":962866.05999999994}]
[null,18,"Total WET RP",{"$f":"'6. WET'!J33","v":0}]
[null,19,"Total PEI SW",{"$f":"'4. PEI'!K18","v":18017}]
[null,20,"Total MHSA HP",0]
[null,21,"Total Mental Health Services For Veterans",21454.61]

{"sheet":"3. CSS","index":3,"n_rows":133,"n_cols":12,"rows_kept":133,"cut":false,"hidden":false,"merged":[]}
[null,"STATE OF CALIFORNIA",null,null,null,null,null,null,null,null,null,"Department of Health Care Services"]
[null,"HEALTH AND HUMAN SERVICES AGENCY"]
[]
[null,"DHCS 1822 C (Rev. 10/18)"]
[null,{"$f":"'1. Information'!B5","v":"Annual Mental Health Services Act Revenue and Expenditure Report"}]
[null,{"$f":"'1. Information'!B6","v":"Fiscal Year: 2022-23"}]
[null,"Community Services and Supports (CSS) Summary  "]
[]
[null,"County:",null,{"$f":"IF(ISBLANK('1. Information'!D11),\"\",'1. Information'!D11)","v":"San Benito"},null,"Date:",{"$f":"IF(ISBLANK('1. Information'!D9),\"\",'1. Information'!D9)","v":"2024-03-07"}]
[]
[null,"SECTION ONE"]
[]
[null,null,null,null,null,"A","B","C","D","E","F"]
[null,null,null,null,null,"Total MHSA (Including Interest)","Medi-Cal FFP","1991 Realignment","Behavioral Health Subaccount","Other","Grand Total"]
[null,1,"CSS Annual Planning Costs",null,null,6424,0,0,0,0,{"$f":"SUM(F15:J15)","v":6424}]
[null,2,"CSS Evaluation Costs",null,null,2816,0,0,0,0,{"$f":"SUM(F16:J16)","v":2816}]
[null,3,"CSS Administration Costs",null,null,165448.93,344492.49,159742.44,0,0,669683.86]
[null,4,"CSS Funds Transferred to JPA",null,null,null,null,null,null,null,0]
[null,5,"CSS Expenditure Incurred by JPA",null,null,null,null,null,null,null,0]
[null,6,"CSS Funds Transferred to CalHFA",null,null,null,null,null,null,null,0]
[null,7,"CSS Funds Transferred to PEI",null,null,null,null,null,null,null,0]
[null,8,"CSS Funds Transferred to WET",null,null,null,null,null,null,null,0]
[null,9,"CSS Funds Transferred to CFTN",null,null,784932.05,null,null,null,null,784932.05]
[null,10,"CSS Funds Transferred to PR",null,null,null,null,null,null,null,0]
[null,11,"CSS Program Expenditures",null,null,{"$f":"SUM(G34:G133)","v":1951618.67},{"$f":"SUM(H34:H133)","v":2319021.4700000002},{"$f":"SUM(I34:I133)","v":401122.08},{"$f":"SUM(J34:J133)","v":260449.18},{"$f":"SUM(K34:K133)","v":1107819.8799999999},6040031.2800000003]
[null,12,"Total CSS Expenditures (Excluding Funds Transferred to JPA)",null,null,{"$f":"SUM(F15:F17,F19:F25)","v":2911239.65},2663513.96,560864.52,260449.18,1107819.8799999999,7503887.1900000004]
[null,13,"Total CSS Expenditures (Excluding Funds Transferred)",null,null,{"$f":"SUM(F15:F17,F19,F25)","v":2126307.6},2663513.96,560864.52,260449.18,1107819.8799999999,6718955.1400000006]
[]
[]
[null,"SECTION TWO"]
[]
[null,null,"A","B","C","D","E","F","G","H","I","J"]
[null,"#","County Code","Program Name","Prior Program Name","Service Category","Total MHSA (Including Interest)","Medi-Cal FFP","1991 Realignment","Behavioral Health Subaccount","Other","Grand Total"]
[null,1,{"$f":"IF(L34<>0,VLOOKUP($D$9,Info_County_Code,2,FALSE),\"\")","v":35},"Integrated FSP",null,"FSP",121364.71,184098.85,185781.63,0,0,{"$f":"SUM(G34:K34)","v":491245.19}]
[null,2,35,"General System Development",null,"Non-FSP",1220120.03,2134922.62,215340.45,260449.18,1107819.8799999999,{"$f":"SUM(G35:K35)","v":4938652.16}]
[null,3,35,"Outreach and Engagement",null,"Non-FSP",610133.93000000005,0,0,0,0,610133.93000000005]
[null,4,"",null,null,null,null,null,null,null,null,0]
[null,5,"",null,null,null,null,null,null,null,null,0]
[null,6,"",null,null,null,null,null,null,null,null,0]
[null,7,"",null,null,null,null,null,null,null,null,0]
[null,8,"",null,null,null,null,null,null,null,null,0]
[null,9,"",null,null,null,null,null,null,null,null,0]
[null,10,"",null,null,null,null,null,null,null,null,0]
[null,11,"",null,null,null,null,null,null,null,null,0]
[null,12,"",null,null,null,null,null,null,null,null,0]
[null,13,"",null,null,null,null,null,null,null,null,0]
[null,14,"",null,null,null,null,null,null,null,null,0]
[null,15,"",null,null,null,null,null,null,null,null,0]
[null,16,"",null,null,null,null,null,null,null,null,0]
[null,17,"",null,null,null,null,null,null,null,null,0]
[null,18,"",null,null,null,null,null,null,null,null,0]
[null,19,"",null,null,null,null,null,null,null,null,0]
[null,20,"",null,null,null,null,null,null,null,null,0]
[null,21,"",null,null,null,null,null,null,null,null,0]
[null,22,"",null,null,null,null,null,null,null,null,0]
[null,23,"",null,null,null,null,null,null,null,null,0]
[null,24,"",null,null,null,null,null,null,null,null,0]
[null,25,"",null,null,null,null,null,null,null,null,0]
[null,26,"",null,null,null,null,null,null,null,null,0]
[null,27,"",null,null,null,null,null,null,null,null,0]
[null,28,"",null,null,null,null,null,null,null,null,0]
[null,29,"",null,null,null,null,null,null,null,null,0]
[null,30,"",null,null,null,null,null,null,null,null,0]
[null,31,"",null,null,null,null,null,null,null,null,0]
[null,32,"",null,null,null,null,null,null,null,null,0]
[null,33,{"$f":"IF(L66<>0,VLOOKUP($D$9,Info_County_Code,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,0]
[null,34,"",null,null,null,null,null,null,null,null,0]
[null,35,"",null,null,null,null,null,null,null,null,0]
[null,36,"",null,null,null,null,null,null,null,null,0]
[null,37,"",null,null,null,null,null,null,null,null,0]
[null,38,"",null,null,null,null,null,null,null,null,0]
[null,39,"",null,null,null,null,null,null,null,null,0]
[null,40,"",null,null,null,null,null,null,null,null,0]
[null,41,"",null,null,null,null,null,null,null,null,0]
[null,42,"",null,null,null,null,null,null,null,null,0]
[null,43,"",null,null,null,null,null,null,null,null,0]
[null,44,"",null,null,null,null,null,null,null,null,0]
[null,45,"",null,null,null,null,null,null,null,null,{"$f":"SUM(G78:K78)","v":0}]
[null,46,"",null,null,null,null,null,null,null,null,0]
[null,47,"",null,null,null,null,null,null,null,null,0]
[null,48,"",null,null,null,null,null,null,null,null,0]
[null,49,"",null,null,null,null,null,null,null,null,0]
[null,50,"",null,null,null,null,null,null,null,null,0]
[null,51,"",null,null,null,null,null,null,null,null,0]
[null,52,"",null,null,null,null,null,null,null,null,0]
[null,53,"",null,null,null,null,null,null,null,null,0]
[null,54,"",null,null,null,null,null,null,null,null,0]
[null,55,"",null,null,null,null,null,null,null,null,0]
[null,56,"",null,null,null,null,null,null,null,null,0]
[null,57,"",null,null,null,null,null,null,null,null,0]
[null,58,"",null,null,null,null,null,null,null,null,0]
[null,59,"",null,null,null,null,null,null,null,null,0]
[null,60,"",null,null,null,null,null,null,null,null,0]
[null,61,"",null,null,null,null,null,null,null,null,0]
[null,62,"",null,null,null,null,null,null,null,null,0]
[null,63,"",null,null,null,null,null,null,null,null,0]
[null,64,"",null,null,null,null,null,null,null,null,0]
[null,65,{"$f":"IF(L98<>0,VLOOKUP($D$9,Info_County_Code,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,0]
[null,66,"",null,null,null,null,null,null,null,null,{"$f":"SUM(G99:K99)","v":0}]
[null,67,"",null,null,null,null,null,null,null,null,0]
[null,68,"",null,null,null,null,null,null,null,null,0]
[null,69,"",null,null,null,null,null,null,null,null,0]
[null,70,"",null,null,null,null,null,null,null,null,0]
[null,71,"",null,null,null,null,null,null,null,null,0]
[null,72,"",null,null,null,null,null,null,null,null,0]
[null,73,"",null,null,null,null,null,null,null,null,0]
[null,74,"",null,null,null,null,null,null,null,null,0]
[null,75,"",null,null,null,null,null,null,null,null,0]
[null,76,"",null,null,null,null,null,null,null,null,0]
[null,77,"",null,null,null,null,null,null,null,null,0]
[null,78,"",null,null,null,null,null,null,null,null,{"$f":"SUM(G111:K111)","v":0}]
[null,79,"",null,null,null,null,null,null,null,null,{"$f":"SUM(G112:K112)","v":0}]
[null,80,"",null,null,null,null,null,null,null,null,0]
[null,81,"",null,null,null,null,null,null,null,null,0]
[null,82,"",null,null,null,null,null,null,null,null,0]
[null,83,"",null,null,null,null,null,null,null,null,0]
[null,84,"",null,null,null,null,null,null,null,null,0]
[null,85,"",null,null,null,null,null,null,null,null,0]
[null,86,"",null,null,null,null,null,null,null,null,0]
[null,87,"",null,null,null,null,null,null,null,null,0]
[null,88,"",null,null,null,null,null,null,null,null,{"$f":"SUM(G121:K121)","v":0}]
[null,89,"",null,null,null,null,null,null,null,null,{"$f":"SUM(G122:K122)","v":0}]
[null,90,"",null,null,null,null,null,null,null,null,0]
[null,91,"",null,null,null,null,null,null,null,null,{"$f":"SUM(G124:K124)","v":0}]
[null,92,"",null,null,null,null,null,null,null,null,0]
[null,93,"",null,null,null,null,null,null,null,null,0]
[null,94,"",null,null,null,null,null,null,null,null,0]
[null,95,"",null,null,null,null,null,null,null,null,{"$f":"SUM(G128:K128)","v":0}]
[null,96,"",null,null,null,null,null,null,null,null,0]
[null,97,"",null,null,null,null,null,null,null,null,0]
[null,98,"",null,null,null,null,null,null,null,null,0]
[null,99,"",null,null,null,null,null,null,null,null,0]
[null,100,"",null,null,null,null,null,null,null,null,0]

{"sheet":"4. PEI","index":4,"n_rows":133,"n_cols":20,"rows_kept":133,"cut":false,"hidden":false,"merged":[]}
[null,"STATE OF CALIFORNIA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Department of Health Care Services"]
[null,"HEALTH AND HUMAN SERVICES AGENCY"]
[]
[null,"DHCS 1822 D (Rev. 10/18)"]
[null,{"$f":"'1. Information'!B5","v":"Annual Mental Health Services Act Revenue and Expenditure Report"}]
[null,{"$f":"'1. Information'!B6","v":"Fiscal Year: 2022-23"}]
[null,"Prevention and Early Intervention (PEI) Summary"]
[]
[null,"County:",null,{"$f":"IF(ISBLANK('1. Information'!D11),\"\",'1. Information'!D11)","v":"San Benito"},null,"Date:",{"$f":"IF(ISBLANK('1. Information'!D9),\"\",'1. Information'!D9)","v":"2024-03-07"}]
[]
[null,"SECTION ONE"]
[]
[null,null,null,null,null,"A","B","C","D","E","F"]
[null,null,null,null,null,"Total MHSA (Including Interest)","Medi-Cal FFP","1991 Realignment","Behavioral Health Subaccount","Other","Grand Total"]
[null,1,"PEI Annual Planning Costs",null,null,{"$f":"2728","v":2728},0,0,0,0,{"$f":"SUM(F15:J15)","v":2728}]
[null,2,"PEI Evaluation Costs",null,null,13992,0,0,0,0,{"$f":"SUM(F16:J16)","v":13992}]
[null,3,"PEI Administration Costs",null,null,{"$f":"80882.89","v":80882.89},0,0,0,0,80882.89]
[null,4,"PEI Funds Expended by CalMHSA for PEI SW ",null,null,18017,null,null,null,null,18017]
[null,5,"PEI Funds Transferred to JPA",null,null,0,null,null,null,null,0]
[null,6,"PEI Expenditure Incurred by JPA",null,null,0,null,null,null,null,0]
[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":592607.51},{"$f":"SUMIF($G$34:$G$133,\"Combined Summary\",M$34:M$133) + SUMIF($F$34:$F$133,\"Standalone\",M$34:M$133)","v":0},{"$f":"SUMIF($G$34:$G$133,\"Combined Summary\",N$34:N$133) + SUMIF($F$34:$F$133,\"Standalone\",N$34:N$133)","v":0},{"$f":"SUMIF($G$34:$G$133,\"Combined Summary\",O$34:O$133) + SUMIF($F$34:$F$133,\"Standalone\",O$34:O$133)","v":0},{"$f":"SUMIF($G$34:$G$133,\"Combined Summary\",P$34:P$133) + SUMIF($F$34:$F$133,\"Standalone\",P$34:P$133)","v":0},592607.51]
[null,8,"Total PEI Expenditures (Excluding Transfers and PEI SW)",null,null,{"$f":"SUM(F15:F17,F20:F21)","v":690210.4},0,0,0,0,690210.4]
[]
[null,"SECTION TWO"]
[]
[null,null,null,null,"A","B"]
[null,null,null,null,"Percent Expended for Clients 25 and Under, All PEI","Percent Expended for Clients 25 and Under, JPA"]
[null,1,null,"MHSA PEI Fund Expenditures in Program to Clients 25 and Under (calculated from weighted program values) divided by Total MHSA PEI Expenditures",{"$f":"IF(F22=0,\"\",((SUMPRODUCT($K$34:$K$133,$L$34:$L$133)+(F20*F28))/$F$22))","v":0.8215048857565751},0]
[]
[null,"SECTION THREE"]
[]
[null,null,"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O"]
[null,"#","County","Program Name","Prior Program Name","Combined/ Standalone","Program Type","Program Activity Name (in Combined Program)","Subtotal Percentage for Combined Program","% of PEI Expended on Clients 25 & Under (Standalone and Program Activities in Combined Program)","% of PEI Expended on Clients 25 & Under (Combined Summary and Standalone)","Total MHSA (Including Interest)","Medi-Cal FFP","1991 Realignment","Behavioral Health Subaccount","Other","Grand Total","Check","Check"]
[null,1,{"$f":"IF(AND(NOT(COUNTA(D34:J34)),(NOT(COUNTA(L34:P34)))),\"\",VLOOKUP($D$9,Info_County_Code,2,FALSE))","v":35},"Community Solutions",null,"Standalone","Prevention",null,1,1,{"$f":"IF(OR(G34=\"Combined Summary\",F34=\"Standalone\"),(SUMPRODUCT(--(D$34:D$133=D34),I$34:I$133,J$34:J$133)),\"\")","v":1},306452.18,0,0,0,0,{"$f":"SUM(L34:P34)","v":306452.18},{"$f":"IF(OR(G34=\"Combined Summary\",F34=\"Standalone\"),(SUMIF(D$34:D$133,D34,I$34:I$133)),\"\")","v":1},{"$f":"IF(AND(F34=\"Standalone\",NOT(R34=1)),\"ERROR\",IF(AND(G34=\"Combined Summary\",NOT(R34=1)),\"ERROR\",\"\"))","v":""},"NOTE TO COUNTY: For Programs designated as Standalone in Column D, enter 100. "]
[null,2,35,"Transcend - C. Henriquez",null,"Standalone","Early Intervention",null,1,0,{"$f":"IF(OR(G35=\"Combined Summary\",F35=\"Standalone\"),(SUMPRODUCT(--(D$34:D$133=D35),I$34:I$133,J$34:J$133)),\"\")","v":0},2966.46,0,0,0,0,{"$f":"SUM(L35:P35)","v":2966.46},{"$f":"IF(OR(G35=\"Combined Summary\",F35=\"Standalone\"),(SUMIF(D$34:D$133,D35,I$34:I$133)),\"\")","v":1},{"$f":"IF(AND(F35=\"Standalone\",NOT(R35=1)),\"ERROR\",IF(AND(G35=\"Combined Summary\",NOT(R35=1)),\"ERROR\",\"\"))","v":""},"The sum of percentages reported for Program Activities in a Combined Program must equal 100. If ERROR, recheck and correct. "]
[null,3,35,"Suicide Prevention Services",null,"Standalone","Suicide Prevention",null,1,0.82,0.82,23502.5,0,0,0,0,23502.5,1,""]
[null,4,35,"San Benito Clinical Services - Older Adult",null,"Standalone","Suicide Prevention",null,1,0,0,15592.7,0,0,0,0,15592.7,1,""]
[null,5,35,"San Benito Clinical Services - LGBTQ",null,"Standalone","Stigma & Discrimination Reduction",null,1,1,1,15592.7,0,0,0,0,15592.7,1,""]
[null,6,35,"San Benito Clinical Services - School Based",null,"Standalone","Prevention",null,1,1,1,212908.28,0,0,0,0,212908.28,1,""]
[null,7,35,"San Benito Clinical Services - SAFE",null,"Standalone","Early Intervention",null,1,0.82,0.82,15592.69,0,0,0,0,15592.69,1,""]
[null,8,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,9,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,10,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,11,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,12,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,13,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,14,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,15,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,16,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,17,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,18,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,19,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,20,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,21,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,22,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,23,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,24,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,25,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,26,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,27,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,28,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,29,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,30,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,31,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,32,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,33,{"$f":"IF(AND(NOT(COUNTA(D66:J66)),(NOT(COUNTA(L66:P66)))),\"\",VLOOKUP($D$9,Info_County_Code,2,FALSE))","v":""},null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,34,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,35,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,36,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,37,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,38,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,39,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,40,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,41,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,42,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,43,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,44,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,45,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,46,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,47,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,48,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,49,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,50,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,51,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,52,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,53,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,54,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,55,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,56,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,57,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,58,"",null,null,null,null,null,null,null,"",null,null,null,null,null,{"$f":"SUM(L91:P91)","v":0},"",""]
[null,59,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,60,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,61,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,62,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,63,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,64,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,65,{"$f":"IF(AND(NOT(COUNTA(D98:J98)),(NOT(COUNTA(L98:P98)))),\"\",VLOOKUP($D$9,Info_County_Code,2,FALSE))","v":""},null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,66,"",null,null,null,null,null,null,null,{"$f":"IF(OR(G99=\"Combined Summary\",F99=\"Standalone\"),(SUMPRODUCT(--(D$34:D$133=D99),I$34:I$133,J$34:J$133)),\"\")","v":""},null,null,null,null,null,{"$f":"SUM(L99:P99)","v":0},{"$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,67,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,68,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,69,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,70,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,71,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,72,"",null,null,null,null,null,null,null,"",null,null,null,null,null,{"$f":"SUM(L105:P105)","v":0},"",""]
[null,73,"",null,null,null,null,null,null,null,"",null,null,null,null,null,{"$f":"SUM(L106:P106)","v":0},"",""]
[null,74,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,75,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,76,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,77,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,78,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,79,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,80,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,81,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,82,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,83,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,84,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,85,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,86,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,87,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,88,"",null,null,null,null,null,null,null,"",null,null,null,null,null,{"$f":"SUM(L121:P121)","v":0},"",""]
[null,89,"",null,null,null,null,null,null,null,"",null,null,null,null,null,{"$f":"SUM(L122:P122)","v":0},"",""]
[null,90,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,91,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,92,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,93,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,94,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,95,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,96,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,97,{"$f":"IF(AND(NOT(COUNTA(D130:J130)),(NOT(COUNTA(L130:P130)))),\"\",VLOOKUP($D$9,Info_County_Code,2,FALSE))","v":""},null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,98,{"$f":"IF(AND(NOT(COUNTA(D131:J131)),(NOT(COUNTA(L131:P131)))),\"\",VLOOKUP($D$9,Info_County_Code,2,FALSE))","v":""},null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,99,{"$f":"IF(AND(NOT(COUNTA(D132:J132)),(NOT(COUNTA(L132:P132)))),\"\",VLOOKUP($D$9,Info_County_Code,2,FALSE))","v":""},null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,100,{"$f":"IF(AND(NOT(COUNTA(D133:J133)),(NOT(COUNTA(L133:P133)))),\"\",VLOOKUP($D$9,Info_County_Code,2,FALSE))","v":""},null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]

{"sheet":"5. INN","index":5,"n_rows":132,"n_cols":16,"rows_kept":132,"cut":false,"hidden":false,"merged":[]}
[null,"STATE OF CALIFORNIA"]
[null,"HEALTH AND HUMAN SERVICES AGENCY"]
[]
[null,"DHCS 1822 E (Rev. 10/18)"]
[null,{"$f":"'1. Information'!B5","v":"Annual Mental Health Services Act Revenue and Expenditure Report"}]
[null,{"$f":"'1. Information'!B6","v":"Fiscal Year: 2022-23"}]
[null,"Innovation (INN) Summary"]
[]
[null,"County:",null,{"$f":"IF(ISBLANK('1. Information'!D11),\"\",'1. Information'!D11)","v":"San Benito"},null,"Date:",{"$f":"IF(ISBLANK('1. Information'!D9),\"\",'1. Information'!D9)","v":"2024-03-07"}]
[]
[null,"SECTION ONE"]
[]
[null,null,null,null,null,"A","B","C","D","E","F"]
[null,null,null,null,null,"Total MHSA (Including Interest)","Medi-Cal FFP","1991 Realignment","Behavioral Health Subaccount","Other","Grand Total"]
[null,1,"INN Annual Planning Costs",null,null,172,0,0,0,0,{"$f":"SUM(F15:J15)","v":172}]
[null,2,"INN Indirect Administration",null,null,46434.12,0,0,0,0,46434.12]
[null,3,"INN Funds Transferred to JPA",null,null,null,null,null,null,null,0]
[null,4,"INN Expenditure Incurred by JPA",null,null,null,null,null,null,null,0]
[null,5,"INN Project Administration",null,null,{"$f":"SUMIF($J$29:$J$132,\"Project Administration\",K$29:K$132)","v":0},{"$f":"SUMIF($J$29:$J$132,\"Project Administration\",L$29:L$132)","v":0},{"$f":"SUMIF($J$29:$J$132,\"Project Administration\",M$29:M$132)","v":0},{"$f":"SUMIF($J$29:$J$132,\"Project Administration\",N$29:N$132)","v":0},{"$f":"SUMIF($J$29:$J$132,\"Project Administration\",O$29:O$132)","v":0},0]
[null,6,"INN Project Evaluation",null,null,{"$f":"SUMIF($J$29:$J$132,\"Project Evaluation\",K$29:K$132)","v":2552},{"$f":"SUMIF($J$29:$J$132,\"Project Evaluation\",L$29:L$132)","v":0},{"$f":"SUMIF($J$29:$J$132,\"Project Evaluation\",M$29:M$132)","v":0},{"$f":"SUMIF($J$29:$J$132,\"Project Evaluation\",N$29:N$132)","v":0},{"$f":"SUMIF($J$29:$J$132,\"Project Evaluation\",O$29:O$132)","v":0},2552]
[null,7,"INN Project Direct",null,null,{"$f":"SUMIF($J$29:$J$132,\"Project Direct\",K$29:K$132)","v":347012.54000000004},{"$f":"SUMIF($J$29:$J$132,\"Project Direct\",L$29:L$132)","v":0},{"$f":"SUMIF($J$29:$J$132,\"Project Direct\",M$29:M$132)","v":0},{"$f":"SUMIF($J$29:$J$132,\"Project Direct\",N$29:N$132)","v":0},{"$f":"SUMIF($J$29:$J$132,\"Project Direct\",O$29:O$132)","v":0},347012.54000000004]
[null,8,null,null,"INN Project Subtotal",{"$f":"SUM(F19:F21)","v":349564.54000000004},0,0,0,0,349564.54000000004]
[null,9,"Total Innovation Expenditures  (Excluding Transfers to JPA)",null,null,{"$f":"SUM(F15:F16,F18,F19:F21)","v":396170.66000000003},0,0,0,0,396170.66000000003]
[]
[null,"SECTION TWO"]
[]
[null,null,"A","B","C","D","E","F","G","H","I","J","K","L","M","N"]
[null,"#","County","Project Name","Prior Project Name","Project MHSOAC Approval Date","Project Start Date","MHSOAC-Authorized MHSA INN Project Budget","Amended MHSOAC-Authorized MHSA INN Project Budget","Project Expenditure Type","Total MHSA (Including Interest)","Medi-Cal FFP","1991 Realignment","BH Subaccount","Other","Grand Total"]
[null,1,{"$f":"IF(P32<>0,VLOOKUP($D$9,Info_County_Code,2,FALSE),\"\")","v":35},"Behavioral Health Diversion & Reentry Court Intervention",null,"2019-01-24","2019-05-01",2264566,null,"Project Administration",0,0,0,0,0,{"$f":"SUM(K29:O29)","v":0}]
[null,1,{"$f":"IF(ISBLANK(C29),\"\",C29)","v":35},"Behavioral Health Diversion & Reentry Court Intervention","","2019-01-24","2019-05-01",2264566,"","Project Evaluation",2552,0,0,0,0,2552]
[null,1,{"$f":"IF(ISBLANK(C29),\"\",C29)","v":35},"Behavioral Health Diversion & Reentry Court Intervention","","2019-01-24","2019-05-01",2264566,"","Project Direct",{"$f":"273122.37+38048.2+35841.96+0.01","v":347012.54000000004},0,0,0,0,347012.54000000004]
[null,1,{"$f":"IF(ISBLANK(C29),\"\",C29)","v":35},"Behavioral Health Diversion & Reentry Court Intervention","","2019-01-24","2019-05-01",2264566,"","Project Subtotal",{"$f":"SUM(K29:K31)","v":349564.54000000004},{"$f":"SUM(L29:L31)","v":0},{"$f":"SUM(M29:M31)","v":0},{"$f":"SUM(N29:N31)","v":0},{"$f":"SUM(O29:O31)","v":0},349564.54000000004]
[null,2,{"$f":"IF(P36<>0,VLOOKUP($D$9,Info_County_Code,2,FALSE),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(NOT(ISBLANK(D33)),$J$29,\"\")","v":""},null,null,null,null,null,{"$f":"SUM(K33:O33)","v":0}]
[null,2,{"$f":"IF(ISBLANK(C33),\"\",C33)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D33)),$J$30,\"\")","v":""},null,null,null,null,null,{"$f":"SUM(K34:O34)","v":0}]
[null,2,{"$f":"IF(ISBLANK(C33),\"\",C33)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D33)),$J$31,\"\")","v":""},null,null,null,null,null,{"$f":"SUM(K35:O35)","v":0}]
[null,2,{"$f":"IF(ISBLANK(C33),\"\",C33)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D33)),$J$32,\"\")","v":""},{"$f":"SUM(K33:K35)","v":0},{"$f":"SUM(L33:L35)","v":0},{"$f":"SUM(M33:M35)","v":0},{"$f":"SUM(N33:N35)","v":0},{"$f":"SUM(O33:O35)","v":0},{"$f":"SUM(K36:O36)","v":0}]
[null,2,{"$f":"IF(P40<>0,VLOOKUP($D$9,Info_County_Code,2,FALSE),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(NOT(ISBLANK(D37)),$J$29,\"\")","v":""},null,null,null,null,null,0]
[null,2,{"$f":"IF(ISBLANK(C37),\"\",C37)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D37)),$J$30,\"\")","v":""},null,null,null,null,null,0]
[null,2,{"$f":"IF(ISBLANK(C37),\"\",C37)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D37)),$J$31,\"\")","v":""},null,null,null,null,null,0]
[null,2,{"$f":"IF(ISBLANK(C37),\"\",C37)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D37)),$J$32,\"\")","v":""},{"$f":"SUM(K37:K39)","v":0},{"$f":"SUM(L37:L39)","v":0},{"$f":"SUM(M37:M39)","v":0},{"$f":"SUM(N37:N39)","v":0},{"$f":"SUM(O37:O39)","v":0},0]
[null,3,{"$f":"IF(P44<>0,VLOOKUP($D$9,Info_County_Code,2,FALSE),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(NOT(ISBLANK(D41)),$J$29,\"\")","v":""},null,null,null,null,null,0]
[null,3,{"$f":"IF(ISBLANK(C41),\"\",C41)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D41)),$J$30,\"\")","v":""},null,null,null,null,null,0]
[null,3,{"$f":"IF(ISBLANK(C41),\"\",C41)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D41)),$J$31,\"\")","v":""},null,null,null,null,null,0]
[null,3,{"$f":"IF(ISBLANK(C41),\"\",C41)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D41)),$J$32,\"\")","v":""},{"$f":"SUM(K41:K43)","v":0},{"$f":"SUM(L41:L43)","v":0},{"$f":"SUM(M41:M43)","v":0},{"$f":"SUM(N41:N43)","v":0},{"$f":"SUM(O41:O43)","v":0},0]
[null,4,{"$f":"IF(P48<>0,VLOOKUP($D$9,Info_County_Code,2,FALSE),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(NOT(ISBLANK(D45)),$J$29,\"\")","v":""},null,null,null,null,null,0]
[null,4,{"$f":"IF(ISBLANK(C45),\"\",C45)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D45)),$J$30,\"\")","v":""},null,null,null,null,null,0]
[null,4,{"$f":"IF(ISBLANK(C45),\"\",C45)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D45)),$J$31,\"\")","v":""},null,null,null,null,null,0]
[null,4,{"$f":"IF(ISBLANK(C45),\"\",C45)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D45)),$J$32,\"\")","v":""},{"$f":"SUM(K45:K47)","v":0},{"$f":"SUM(L45:L47)","v":0},{"$f":"SUM(M45:M47)","v":0},{"$f":"SUM(N45:N47)","v":0},{"$f":"SUM(O45:O47)","v":0},0]
[null,5,{"$f":"IF(P52<>0,VLOOKUP($D$9,Info_County_Code,2,FALSE),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(NOT(ISBLANK(D49)),$J$29,\"\")","v":""},null,null,null,null,null,0]
[null,5,{"$f":"IF(ISBLANK(C49),\"\",C49)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D49)),$J$30,\"\")","v":""},null,null,null,null,null,0]
[null,5,{"$f":"IF(ISBLANK(C49),\"\",C49)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D49)),$J$31,\"\")","v":""},null,null,null,null,null,0]
[null,5,{"$f":"IF(ISBLANK(C49),\"\",C49)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D49)),$J$32,\"\")","v":""},{"$f":"SUM(K49:K51)","v":0},{"$f":"SUM(L49:L51)","v":0},{"$f":"SUM(M49:M51)","v":0},{"$f":"SUM(N49:N51)","v":0},{"$f":"SUM(O49:O51)","v":0},0]
[null,6,{"$f":"IF(P56<>0,VLOOKUP($D$9,Info_County_Code,2,FALSE),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(NOT(ISBLANK(D53)),$J$29,\"\")","v":""},null,null,null,null,null,0]
[null,6,{"$f":"IF(ISBLANK(C53),\"\",C53)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D53)),$J$30,\"\")","v":""},null,null,null,null,null,0]
[null,6,{"$f":"IF(ISBLANK(C53),\"\",C53)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D53)),$J$31,\"\")","v":""},null,null,null,null,null,0]
[null,6,{"$f":"IF(ISBLANK(C53),\"\",C53)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D53)),$J$32,\"\")","v":""},{"$f":"SUM(K53:K55)","v":0},{"$f":"SUM(L53:L55)","v":0},{"$f":"SUM(M53:M55)","v":0},{"$f":"SUM(N53:N55)","v":0},{"$f":"SUM(O53:O55)","v":0},0]
[null,7,{"$f":"IF(P60<>0,VLOOKUP($D$9,Info_County_Code,2,FALSE),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(NOT(ISBLANK(D57)),$J$29,\"\")","v":""},null,null,null,null,null,0]
[null,7,{"$f":"IF(ISBLANK(C57),\"\",C57)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D57)),$J$30,\"\")","v":""},null,null,null,null,null,0]
[null,7,{"$f":"IF(ISBLANK(C57),\"\",C57)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D57)),$J$31,\"\")","v":""},null,null,null,null,null,0]
[null,7,{"$f":"IF(ISBLANK(C57),\"\",C57)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D57)),$J$32,\"\")","v":""},{"$f":"SUM(K57:K59)","v":0},{"$f":"SUM(L57:L59)","v":0},{"$f":"SUM(M57:M59)","v":0},{"$f":"SUM(N57:N59)","v":0},{"$f":"SUM(O57:O59)","v":0},0]
[null,8,{"$f":"IF(P64<>0,VLOOKUP($D$9,Info_County_Code,2,FALSE),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(NOT(ISBLANK(D61)),$J$29,\"\")","v":""},null,null,null,null,null,0]
[null,8,{"$f":"IF(ISBLANK(C61),\"\",C61)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D61)),$J$30,\"\")","v":""},null,null,null,null,null,0]
[null,8,{"$f":"IF(ISBLANK(C61),\"\",C61)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D61)),$J$31,\"\")","v":""},null,null,null,null,null,0]
[null,8,{"$f":"IF(ISBLANK(C61),\"\",C61)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D61)),$J$32,\"\")","v":""},{"$f":"SUM(K61:K63)","v":0},{"$f":"SUM(L61:L63)","v":0},{"$f":"SUM(M61:M63)","v":0},{"$f":"SUM(N61:N63)","v":0},{"$f":"SUM(O61:O63)","v":0},0]
[null,9,{"$f":"IF(P68<>0,VLOOKUP($D$9,Info_County_Code,2,FALSE),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(NOT(ISBLANK(D65)),$J$29,\"\")","v":""},null,null,null,null,null,{"$f":"SUM(K65:O65)","v":0}]
[null,9,{"$f":"IF(ISBLANK(C65),\"\",C65)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D65)),$J$30,\"\")","v":""},null,null,null,null,null,0]
[null,9,{"$f":"IF(ISBLANK(C65),\"\",C65)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D65)),$J$31,\"\")","v":""},null,null,null,null,null,0]
[null,9,{"$f":"IF(ISBLANK(C65),\"\",C65)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D65)),$J$32,\"\")","v":""},{"$f":"SUM(K65:K67)","v":0},{"$f":"SUM(L65:L67)","v":0},{"$f":"SUM(M65:M67)","v":0},{"$f":"SUM(N65:N67)","v":0},{"$f":"SUM(O65:O67)","v":0},0]
[null,10,{"$f":"IF(P72<>0,VLOOKUP($D$9,Info_County_Code,2,FALSE),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(NOT(ISBLANK(D69)),$J$29,\"\")","v":""},null,null,null,null,null,0]
[null,10,{"$f":"IF(ISBLANK(C69),\"\",C69)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D69)),$J$30,\"\")","v":""},null,null,null,null,null,0]
[null,10,{"$f":"IF(ISBLANK(C69),\"\",C69)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D69)),$J$31,\"\")","v":""},null,null,null,null,null,0]
[null,10,{"$f":"IF(ISBLANK(C69),\"\",C69)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D69)),$J$32,\"\")","v":""},{"$f":"SUM(K69:K71)","v":0},{"$f":"SUM(L69:L71)","v":0},{"$f":"SUM(M69:M71)","v":0},{"$f":"SUM(N69:N71)","v":0},{"$f":"SUM(O69:O71)","v":0},0]
[null,11,{"$f":"IF(P76<>0,VLOOKUP($D$9,Info_County_Code,2,FALSE),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(NOT(ISBLANK(D73)),$J$29,\"\")","v":""},null,null,null,null,null,0]
[null,11,{"$f":"IF(ISBLANK(C73),\"\",C73)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D73)),$J$30,\"\")","v":""},null,null,null,null,null,0]
[null,11,{"$f":"IF(ISBLANK(C73),\"\",C73)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D73)),$J$31,\"\")","v":""},null,null,null,null,null,0]
[null,11,{"$f":"IF(ISBLANK(C73),\"\",C73)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D73)),$J$32,\"\")","v":""},{"$f":"SUM(K73:K75)","v":0},{"$f":"SUM(L73:L75)","v":0},{"$f":"SUM(M73:M75)","v":0},{"$f":"SUM(N73:N75)","v":0},{"$f":"SUM(O73:O75)","v":0},0]
[null,12,{"$f":"IF(P80<>0,VLOOKUP($D$9,Info_County_Code,2,FALSE),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(NOT(ISBLANK(D77)),$J$29,\"\")","v":""},null,null,null,null,null,0]
[null,12,{"$f":"IF(ISBLANK(C77),\"\",C77)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D77)),$J$30,\"\")","v":""},null,null,null,null,null,0]
[null,12,{"$f":"IF(ISBLANK(C77),\"\",C77)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D77)),$J$31,\"\")","v":""},null,null,null,null,null,0]
[null,12,{"$f":"IF(ISBLANK(C77),\"\",C77)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D77)),$J$32,\"\")","v":""},{"$f":"SUM(K77:K79)","v":0},{"$f":"SUM(L77:L79)","v":0},{"$f":"SUM(M77:M79)","v":0},{"$f":"SUM(N77:N79)","v":0},{"$f":"SUM(O77:O79)","v":0},0]
[null,13,{"$f":"IF(P84<>0,VLOOKUP($D$9,Info_County_Code,2,FALSE),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(NOT(ISBLANK(D81)),$J$29,\"\")","v":""},null,null,null,null,null,0]
[null,13,{"$f":"IF(ISBLANK(C81),\"\",C81)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D81)),$J$30,\"\")","v":""},null,null,null,null,null,0]
[null,13,{"$f":"IF(ISBLANK(C81),\"\",C81)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D81)),$J$31,\"\")","v":""},null,null,null,null,null,0]
[null,13,{"$f":"IF(ISBLANK(C81),\"\",C81)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D81)),$J$32,\"\")","v":""},{"$f":"SUM(K81:K83)","v":0},{"$f":"SUM(L81:L83)","v":0},{"$f":"SUM(M81:M83)","v":0},{"$f":"SUM(N81:N83)","v":0},{"$f":"SUM(O81:O83)","v":0},0]
[null,14,{"$f":"IF(P88<>0,VLOOKUP($D$9,Info_County_Code,2,FALSE),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(NOT(ISBLANK(D85)),$J$29,\"\")","v":""},null,null,null,null,null,0]
[null,14,{"$f":"IF(ISBLANK(C85),\"\",C85)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D85)),$J$30,\"\")","v":""},null,null,null,null,null,0]
[null,14,{"$f":"IF(ISBLANK(C85),\"\",C85)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D85)),$J$31,\"\")","v":""},null,null,null,null,null,0]
[null,14,{"$f":"IF(ISBLANK(C85),\"\",C85)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D85)),$J$32,\"\")","v":""},{"$f":"SUM(K85:K87)","v":0},{"$f":"SUM(L85:L87)","v":0},{"$f":"SUM(M85:M87)","v":0},{"$f":"SUM(N85:N87)","v":0},{"$f":"SUM(O85:O87)","v":0},0]
[null,15,{"$f":"IF(P92<>0,VLOOKUP($D$9,Info_County_Code,2,FALSE),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(NOT(ISBLANK(D89)),$J$29,\"\")","v":""},null,null,null,null,null,{"$f":"SUM(K89:O89)","v":0}]
[null,15,{"$f":"IF(ISBLANK(C89),\"\",C89)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D89)),$J$30,\"\")","v":""},null,null,null,null,null,0]
[null,15,{"$f":"IF(ISBLANK(C89),\"\",C89)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D89)),$J$31,\"\")","v":""},null,null,null,null,null,0]
[null,15,{"$f":"IF(ISBLANK(C89),\"\",C89)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D89)),$J$32,\"\")","v":""},{"$f":"SUM(K89:K91)","v":0},{"$f":"SUM(L89:L91)","v":0},{"$f":"SUM(M89:M91)","v":0},{"$f":"SUM(N89:N91)","v":0},{"$f":"SUM(O89:O91)","v":0},0]
[null,16,{"$f":"IF(P96<>0,VLOOKUP($D$9,Info_County_Code,2,FALSE),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(NOT(ISBLANK(D93)),$J$29,\"\")","v":""},null,null,null,null,null,0]
[null,16,{"$f":"IF(ISBLANK(C93),\"\",C93)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D93)),$J$30,\"\")","v":""},null,null,null,null,null,0]
[null,16,{"$f":"IF(ISBLANK(C93),\"\",C93)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D93)),$J$31,\"\")","v":""},null,null,null,null,null,0]
[null,16,{"$f":"IF(ISBLANK(C93),\"\",C93)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D93)),$J$32,\"\")","v":""},{"$f":"SUM(K93:K95)","v":0},{"$f":"SUM(L93:L95)","v":0},{"$f":"SUM(M93:M95)","v":0},{"$f":"SUM(N93:N95)","v":0},{"$f":"SUM(O93:O95)","v":0},0]
[null,17,{"$f":"IF(P100<>0,VLOOKUP($D$9,Info_County_Code,2,FALSE),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(NOT(ISBLANK(D97)),$J$29,\"\")","v":""},null,null,null,null,null,0]
[null,17,{"$f":"IF(ISBLANK(C97),\"\",C97)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D97)),$J$30,\"\")","v":""},null,null,null,null,null,0]
[null,17,{"$f":"IF(ISBLANK(C97),\"\",C97)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D97)),$J$31,\"\")","v":""},null,null,null,null,null,0]
[null,17,{"$f":"IF(ISBLANK(C97),\"\",C97)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D97)),$J$32,\"\")","v":""},{"$f":"SUM(K97:K99)","v":0},{"$f":"SUM(L97:L99)","v":0},{"$f":"SUM(M97:M99)","v":0},{"$f":"SUM(N97:N99)","v":0},{"$f":"SUM(O97:O99)","v":0},0]
[null,18,{"$f":"IF(P104<>0,VLOOKUP($D$9,Info_County_Code,2,FALSE),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(NOT(ISBLANK(D101)),$J$29,\"\")","v":""},null,null,null,null,null,{"$f":"SUM(K101:O101)","v":0}]
[null,18,{"$f":"IF(ISBLANK(C101),\"\",C101)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D101)),$J$30,\"\")","v":""},null,null,null,null,null,{"$f":"SUM(K102:O102)","v":0}]
[null,18,{"$f":"IF(ISBLANK(C101),\"\",C101)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D101)),$J$31,\"\")","v":""},null,null,null,null,null,{"$f":"SUM(K103:O103)","v":0}]
[null,18,{"$f":"IF(ISBLANK(C101),\"\",C101)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D101)),$J$32,\"\")","v":""},{"$f":"SUM(K101:K103)","v":0},{"$f":"SUM(L101:L103)","v":0},{"$f":"SUM(M101:M103)","v":0},{"$f":"SUM(N101:N103)","v":0},{"$f":"SUM(O101:O103)","v":0},{"$f":"SUM(K104:O104)","v":0}]
[null,19,{"$f":"IF(P108<>0,VLOOKUP($D$9,Info_County_Code,2,FALSE),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(NOT(ISBLANK(D105)),$J$29,\"\")","v":""},null,null,null,null,null,0]
[null,19,{"$f":"IF(ISBLANK(C105),\"\",C105)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D105)),$J$30,\"\")","v":""},null,null,null,null,null,0]
[null,19,{"$f":"IF(ISBLANK(C105),\"\",C105)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D105)),$J$31,\"\")","v":""},null,null,null,null,null,0]
[null,19,{"$f":"IF(ISBLANK(C105),\"\",C105)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D105)),$J$32,\"\")","v":""},{"$f":"SUM(K105:K107)","v":0},{"$f":"SUM(L105:L107)","v":0},{"$f":"SUM(M105:M107)","v":0},{"$f":"SUM(N105:N107)","v":0},{"$f":"SUM(O105:O107)","v":0},0]
[null,20,{"$f":"IF(P112<>0,VLOOKUP($D$9,Info_County_Code,2,FALSE),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(NOT(ISBLANK(D109)),$J$29,\"\")","v":""},null,null,null,null,null,{"$f":"SUM(K109:O109)","v":0}]
[null,20,{"$f":"IF(ISBLANK(C109),\"\",C109)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D109)),$J$30,\"\")","v":""},null,null,null,null,null,{"$f":"SUM(K110:O110)","v":0}]
[null,20,{"$f":"IF(ISBLANK(C109),\"\",C109)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D109)),$J$31,\"\")","v":""},null,null,null,null,null,{"$f":"SUM(K111:O111)","v":0}]
[null,20,{"$f":"IF(ISBLANK(C109),\"\",C109)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D109)),$J$32,\"\")","v":""},{"$f":"SUM(K109:K111)","v":0},{"$f":"SUM(L109:L111)","v":0},{"$f":"SUM(M109:M111)","v":0},{"$f":"SUM(N109:N111)","v":0},{"$f":"SUM(O109:O111)","v":0},{"$f":"SUM(K112:O112)","v":0}]
[null,21,{"$f":"IF(P116<>0,VLOOKUP($D$9,Info_County_Code,2,FALSE),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(NOT(ISBLANK(D113)),$J$29,\"\")","v":""},null,null,null,null,null,0]
[null,21,{"$f":"IF(ISBLANK(C113),\"\",C113)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D113)),$J$30,\"\")","v":""},null,null,null,null,null,0]
[null,21,{"$f":"IF(ISBLANK(C113),\"\",C113)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D113)),$J$31,\"\")","v":""},null,null,null,null,null,0]
[null,21,{"$f":"IF(ISBLANK(C113),\"\",C113)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D113)),$J$32,\"\")","v":""},{"$f":"SUM(K113:K115)","v":0},{"$f":"SUM(L113:L115)","v":0},{"$f":"SUM(M113:M115)","v":0},{"$f":"SUM(N113:N115)","v":0},{"$f":"SUM(O113:O115)","v":0},0]
[null,22,{"$f":"IF(P120<>0,VLOOKUP($D$9,Info_County_Code,2,FALSE),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(NOT(ISBLANK(D117)),$J$29,\"\")","v":""},null,null,null,null,null,{"$f":"SUM(K117:O117)","v":0}]
[null,22,{"$f":"IF(ISBLANK(C117),\"\",C117)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D117)),$J$30,\"\")","v":""},null,null,null,null,null,{"$f":"SUM(K118:O118)","v":0}]
[null,22,{"$f":"IF(ISBLANK(C117),\"\",C117)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D117)),$J$31,\"\")","v":""},null,null,null,null,null,{"$f":"SUM(K119:O119)","v":0}]
[null,22,{"$f":"IF(ISBLANK(C117),\"\",C117)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D117)),$J$32,\"\")","v":""},{"$f":"SUM(K117:K119)","v":0},{"$f":"SUM(L117:L119)","v":0},{"$f":"SUM(M117:M119)","v":0},{"$f":"SUM(N117:N119)","v":0},{"$f":"SUM(O117:O119)","v":0},{"$f":"SUM(K120:O120)","v":0}]
[null,23,{"$f":"IF(P124<>0,VLOOKUP($D$9,Info_County_Code,2,FALSE),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(NOT(ISBLANK(D121)),$J$29,\"\")","v":""},null,null,null,null,null,0]
[null,23,{"$f":"IF(ISBLANK(C121),\"\",C121)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D121)),$J$30,\"\")","v":""},null,null,null,null,null,0]
[null,23,{"$f":"IF(ISBLANK(C121),\"\",C121)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D121)),$J$31,\"\")","v":""},null,null,null,null,null,0]
[null,23,{"$f":"IF(ISBLANK(C121),\"\",C121)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D121)),$J$32,\"\")","v":""},{"$f":"SUM(K121:K123)","v":0},{"$f":"SUM(L121:L123)","v":0},{"$f":"SUM(M121:M123)","v":0},{"$f":"SUM(N121:N123)","v":0},{"$f":"SUM(O121:O123)","v":0},0]
[null,24,{"$f":"IF(P128<>0,VLOOKUP($D$9,Info_County_Code,2,FALSE),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(NOT(ISBLANK(D125)),$J$29,\"\")","v":""},null,null,null,null,null,{"$f":"SUM(K125:O125)","v":0}]
[null,24,{"$f":"IF(ISBLANK(C125),\"\",C125)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D125)),$J$30,\"\")","v":""},null,null,null,null,null,{"$f":"SUM(K126:O126)","v":0}]
[null,24,{"$f":"IF(ISBLANK(C125),\"\",C125)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D125)),$J$31,\"\")","v":""},null,null,null,null,null,{"$f":"SUM(K127:O127)","v":0}]
[null,24,{"$f":"IF(ISBLANK(C125),\"\",C125)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D125)),$J$32,\"\")","v":""},{"$f":"SUM(K125:K127)","v":0},{"$f":"SUM(L125:L127)","v":0},{"$f":"SUM(M125:M127)","v":0},{"$f":"SUM(N125:N127)","v":0},{"$f":"SUM(O125:O127)","v":0},{"$f":"SUM(K128:O128)","v":0}]
[null,25,{"$f":"IF(P132<>0,VLOOKUP($D$9,Info_County_Code,2,FALSE),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(NOT(ISBLANK(D129)),$J$29,\"\")","v":""},null,null,null,null,null,0]
[null,25,{"$f":"IF(ISBLANK(C129),\"\",C129)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D129)),$J$30,\"\")","v":""},null,null,null,null,null,0]
[null,25,{"$f":"IF(ISBLANK(C129),\"\",C129)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D129)),$J$31,\"\")","v":""},null,null,null,null,null,0]
[null,25,{"$f":"IF(ISBLANK(C129),\"\",C129)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D129)),$J$32,\"\")","v":""},{"$f":"SUM(K129:K131)","v":0},{"$f":"SUM(L129:L131)","v":0},{"$f":"SUM(M129:M131)","v":0},{"$f":"SUM(N129:N131)","v":0},{"$f":"SUM(O129:O131)","v":0},0]

{"sheet":"6. WET","index":6,"n_rows":33,"n_cols":11,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[null,"STATE OF CALIFORNIA",null,null,null,null,null,null,null,null,"Department of Health Care Services"]
[null,"HEALTH AND HUMAN SERVICES AGENCY"]
[]
[null,"DHCS 1822 F (Rev. 10/18)"]
[null,{"$f":"'1. Information'!B5","v":"Annual Mental Health Services Act Revenue and Expenditure Report"}]
[null,{"$f":"'1. Information'!B6","v":"Fiscal Year: 2022-23"}]
[null,"Workforce Education and Training (WET) Summary"]
[]
[null,null,"County:",{"$f":"IF(ISBLANK('1. Information'!D11),\"\",'1. Information'!D11)","v":"San Benito"},null,"Date:",{"$f":"IF(ISBLANK('1. Information'!D9),\"\",'1. Information'!D9)","v":"2024-03-07"}]
[]
[null,"SECTION ONE"]
[]
[null,null,null,null,null,"A","B","C","D","E","F"]
[null,null,null,null,null,"Total MHSA (Including Interest)","Medi-Cal FFP","1991 Realignment","Behavioral Health Subaccount","Other","Grand Total"]
[null,1,"WET Annual Planning Costs",null,null,9137,0,0,0,0,{"$f":"SUM(F15:J15)","v":9137}]
[null,2,"WET Evaluation Costs",null,null,null,0,0,0,0,0]
[null,3,"WET Administration Costs",null,null,12022.86,0,0,0,0,12022.86]
[null,4,"WET Funds Transferred to JPA",null,null,0,null,null,null,null,0]
[null,5,"WET Expenditure Incurred by JPA",null,null,0,null,null,null,null,0]
[null,6,"WET Program Expenditures",null,null,{"$f":"SUM(E28:E32)","v":81417.84},{"$f":"SUM(F28:F32)","v":0},{"$f":"SUM(G28:G32)","v":0},{"$f":"SUM(H28:H32)","v":0},{"$f":"SUM(I28:I32)","v":0},81417.84]
[null,7,"Total WET Expenditures (Excluding Transfers to JPA)",null,null,{"$f":"SUM(F15:F17,F19:F20)","v":102577.7},0,0,0,0,102577.7]
[]
[]
[null,"SECTION TWO"]
[]
[null,null,"A","B","C","D","E","F","G","H"]
[null,"#","County","Funding Category","Total MHSA (Including Interest)","Medi-Cal FFP","1991 Realignment","Behavioral Health Subaccount","Other","Grand Total"]
[null,1,{"$f":"IF(J28<>0,VLOOKUP($D$9,Info_County_Code,2,FALSE),\"\")","v":""},"Workforce Staffing",null,null,null,null,null,{"$f":"SUM(E28:I28)","v":0}]
[null,2,35,"Training/Technical Assistance",{"$f":"72137.53+9280.31","v":81417.84},null,null,null,null,81417.84]
[null,3,"","MH Career Pathways",null,null,null,null,null,0]
[null,4,"","Residency/Internship",null,null,null,null,null,0]
[null,5,"","Financial Incentive",null,null,null,null,null,0]
[null,6,"","WET Regional Partnerships (WET RP)",null,null,null,null,null,0]

{"sheet":"7. CFTN","index":7,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[null,"STATE OF CALIFORNIA",null,null,null,null,null,null,null,null,null,"Department of Health Care Services"]
[null,"HEALTH AND HUMAN SERVICES AGENCY"]
[]
[null,"DHCS 1822 G (Rev. 10/18)"]
[null,{"$f":"'1. Information'!B5","v":"Annual Mental Health Services Act Revenue and Expenditure Report"}]
[null,{"$f":"'1. Information'!B6","v":"Fiscal Year: 2022-23"}]
[null,"Capital Facility Technological Needs (CFTN) Summary"]
[]
[null,"County:",null,{"$f":"IF(ISBLANK('1. Information'!D11),\"\",'1. Information'!D11)","v":"San Benito"},null,"Date:",{"$f":"IF(ISBLANK('1. Information'!D9),\"\",'1. Information'!D9)","v":"2024-03-07"}]
[]
[null,"SECTION ONE"]
[]
[null,null,null,null,null,"A","B","C","D","E","F"]
[null,null,null,null,null,"Total MHSA (Including Interest)","Medi-Cal FFP","1991 Realignment","Behavioral Health Subaccount","Other","Grand Total"]
[null,1,"CF Annual Planning Costs",null,null,0,0,0,0,0,{"$f":"SUM(F15:J15)","v":0}]
[null,2,"TN Annual Planning Costs",null,null,0,0,0,0,0,{"$f":"SUM(F16:J16)","v":0}]
[null,3,"CF Evaluation Costs",null,null,0,0,0,0,0,0]
[null,4,"TN Evaluation Costs",null,null,0,0,0,0,0,0]
[null,5,"CF Administration",null,null,153842.32999999999,0,0,0,0,153842.32999999999]
[null,6,"TN Administration",null,null,0,0,0,0,0,0]
[null,7,"CFTN Program Expenditure",null,null,{"$f":"SUM(G28:G47)","v":1150294.46},{"$f":"SUM(H28:H47)","v":0},{"$f":"SUM(I28:I47)","v":0},{"$f":"SUM(J28:J47)","v":0},{"$f":"SUM(K28:K47)","v":0},1150294.46]
[null,8,"Total CFTN Expenditures",null,null,{"$f":"SUM(F15:F21)","v":1304136.79},0,0,0,0,1304136.79]
[]
[null,"SECTION TWO"]
[]
[null,null,"A","B","C","D","E","F","G","H","I","J"]
[null,"#","County","Project Name","Prior Project Name","Project Type","Total MSHA (Including Interest)","Medi-Cal FFP","1991 Realignment","Behavioral Health Subaccount","Other","Grand Total"]
[null,1,{"$f":"IF(L28<>0,VLOOKUP($D$9,Info_County_Code,2,FALSE),\"\")","v":35},"New BH Building",null,"Capital Facility",{"$f":"360745.77+38268.01","v":399013.78},0,0,0,0,{"$f":"SUM(G28:K28)","v":399013.78}]
[null,2,35,"Electronic Health Record (E.H.R.) Implementation",null,"Technological Need",{"$f":"679228+72052.68","v":751280.67999999993},null,null,null,null,{"$f":"SUM(G29:K29)","v":751280.67999999993}]
[null,3,"",null,null,null,null,null,null,null,null,0]
[null,4,"",null,null,null,null,null,null,null,null,0]
[null,5,"",null,null,null,null,null,null,null,null,0]
[null,6,"",null,null,null,null,null,null,null,null,0]
[null,7,"",null,null,null,null,null,null,null,null,0]
[null,8,"",null,null,null,null,null,null,null,null,0]
[null,9,"",null,null,null,null,null,null,null,null,0]
[null,10,"",null,null,null,null,null,null,null,null,0]
[null,11,"",null,null,null,null,null,null,null,null,0]
[null,12,"",null,null,null,null,null,null,null,null,0]
[null,13,"",null,null,null,null,null,null,null,null,0]
[null,14,"",null,null,null,null,null,null,null,null,0]
[null,15,"",null,null,null,null,null,null,null,null,0]
[null,16,"",null,null,null,null,null,null,null,null,0]
[null,17,"",null,null,null,null,null,null,null,null,0]
[null,18,"",null,null,null,null,null,null,null,null,0]
[null,19,"",null,null,null,null,null,null,null,null,0]
[null,20,"",null,null,null,null,null,null,null,null,0]

{"sheet":"8. Adjustment (MHSA)","index":8,"n_rows":114,"n_cols":7,"rows_kept":114,"cut":false,"hidden":false,"merged":[]}
[null,"STATE OF CALIFORNIA",null,null,null,null,"Department of Health Care Services"]
[null,"HEALTH AND HUMAN SERVICES AGENCY"]
[]
[null,"DHCS 1822 H (Rev. 10/18)"]
[null,{"$f":"'1. Information'!B5","v":"Annual Mental Health Services Act Revenue and Expenditure Report"}]
[null,{"$f":"'1. Information'!B6","v":"Fiscal Year: 2022-23"}]
[null,"Adjustments Worksheet (MHSA)"]
[]
[null,"County:",null,{"$f":"IF(ISBLANK('1. Information'!D11),\"\",'1. Information'!D11)","v":"San Benito"},null,"Date",{"$f":"IF(ISBLANK('1. Information'!D9),\"\",'1. Information'!D9)","v":"2024-03-07"}]
[]
[null,"SECTION ONE"]
[]
[null,null,"A","B","C","D","E"]
[null,"#","County","Component","Adjustment to FY","Amount","Reason"]
[null,1,{"$f":"IF(F15<>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(D45:G45)),\"\",VLOOKUP(D23,Info_County_Code,2,FALSE))","v":""}]
[null,"SECTION TWO"]
[]
[null,null,"A","B","C","D","E"]
[null,"#","County","Adjustment to","Adjustment to FY","Amount","Reason"]
[null,1,{"$f":"IF(F50<>0,VLOOKUP($D$9,Info_County_Code,2,FALSE),\"\")","v":""},"Interest Revenue"]
[null,2,"","Interest Revenue"]
[null,3,"","Interest Revenue"]
[null,4,"","Interest Revenue"]
[null,5,"","Interest Revenue"]
[null,6,"","Interest Revenue"]
[null,7,"","Interest Revenue"]
[null,8,"","Interest Revenue"]
[null,9,"","Interest Revenue"]
[null,10,"","Interest Revenue"]
[null,11,"","Interest Revenue"]
[null,12,"","Interest Revenue"]
[null,13,"","Interest Revenue"]
[null,14,"","Interest Revenue"]
[null,15,"","Interest Revenue"]
[null,16,"","Interest Revenue"]
[null,17,"","Interest Revenue"]
[null,18,"","Interest Revenue"]
[null,19,"","Interest Revenue"]
[null,20,"","Interest Revenue"]
[null,21,"","Interest Revenue"]
[null,22,"","Interest Revenue"]
[null,23,"","Interest Revenue"]
[null,24,"","Interest Revenue"]
[null,25,"","Interest Revenue"]
[null,26,"","Interest Revenue"]
[null,27,"","Interest Revenue"]
[null,28,"","Interest Revenue"]
[null,29,"","Interest Revenue"]
[null,30,"","Interest Revenue"]
[]
[null,"SECTION THREE"]
[]
[null,null,"A","B","C","D","E"]
[null,"#","County","Adjustment to","Adjustment to FY","Amount","Reason"]
[null,1,{"$f":"IF(F85<>0,VLOOKUP($D$9,Info_County_Code,2,FALSE),\"\")","v":""},"Prudent Reserve"]
[null,2,"","Prudent Reserve"]
[null,3,"","Prudent Reserve"]
[null,4,"","Prudent Reserve"]
[null,5,"","Prudent Reserve"]
[null,6,"","Prudent Reserve"]
[null,7,"","Prudent Reserve"]
[null,8,"","Prudent Reserve"]
[null,9,"","Prudent Reserve"]
[null,10,"","Prudent Reserve"]
[null,11,"","Prudent Reserve"]
[null,12,"","Prudent Reserve"]
[null,13,"","Prudent Reserve"]
[null,14,"","Prudent Reserve"]
[null,15,"","Prudent Reserve"]
[null,16,"","Prudent Reserve"]
[null,17,"","Prudent Reserve"]
[null,18,"","Prudent Reserve"]
[null,19,"","Prudent Reserve"]
[null,20,"","Prudent Reserve"]
[null,21,"","Prudent Reserve"]
[null,22,"","Prudent Reserve"]
[null,23,"","Prudent Reserve"]
[null,24,"","Prudent Reserve"]
[null,25,"","Prudent Reserve"]
[null,26,"","Prudent Reserve"]
[null,27,"","Prudent Reserve"]
[null,28,"","Prudent Reserve"]
[null,29,"","Prudent Reserve"]
[null,30,"","Prudent Reserve"]

{"sheet":"9. Adjustment (FFP)","index":9,"n_rows":54,"n_cols":9,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
[null,"STATE OF CALIFORNIA",null,null,null,null,null,null,"Department of Health Care Services"]
[null,"HEALTH AND HUMAN SERVICES AGENCY"]
[]
[null,"DHCS 1822 I (Rev. 10/18)"]
[null,{"$f":"'1. Information'!B5","v":"Annual Mental Health Services Act Revenue and Expenditure Report"}]
[null,{"$f":"'1. Information'!B6","v":"Fiscal Year: 2022-23"}]
[null,"FFP Revenue Adjustment"]
[]
[null,"County:",null,{"$f":"IF(ISBLANK('1. Information'!D11),\"\",'1. Information'!D11)","v":"San Benito"},null,"Date:",{"$f":"IF(ISBLANK('1. Information'!D9),\"\",'1. Information'!D9)","v":"2024-03-07"}]
[]
[null,"SECTION ONE"]
[]
[null,null,"A","B","C","D","E","F","G"]
[null,"#","County","Fiscal Year","Cost Report Stage","Component","Beginning Balance","Adjustment Amount","Ending Balance"]
[null,1,{"$f":"IF(I15<>0,VLOOKUP($D$9,Info_County_Code,2,FALSE),\"\")","v":""},null,null,null,null,null,{"$f":"SUM(G15:H15)","v":0}]
[null,2,"",null,null,null,null,null,{"$f":"SUM(G16:H16)","v":0}]
[null,3,"",null,null,null,null,null,0]
[null,4,"",null,null,null,null,null,0]
[null,5,"",null,null,null,null,null,0]
[null,6,"",null,null,null,null,null,0]
[null,7,"",null,null,null,null,null,0]
[null,8,"",null,null,null,null,null,0]
[null,9,"",null,null,null,null,null,0]
[null,10,"",null,null,null,null,null,0]
[null,11,"",null,null,null,null,null,0]
[null,12,"",null,null,null,null,null,0]
[null,13,"",null,null,null,null,null,0]
[null,14,"",null,null,null,null,null,0]
[null,15,"",null,null,null,null,null,0]
[null,16,"",null,null,null,null,null,0]
[null,17,"",null,null,null,null,null,0]
[null,18,"",null,null,null,null,null,0]
[null,19,"",null,null,null,null,null,0]
[null,20,"",null,null,null,null,null,0]
[null,21,"",null,null,null,null,null,0]
[null,22,"",null,null,null,null,null,0]
[null,23,"",null,null,null,null,null,0]
[null,24,"",null,null,null,null,null,0]
[null,25,"",null,null,null,null,null,0]
[null,26,"",null,null,null,null,null,0]
[null,27,"",null,null,null,null,null,0]
[null,28,"",null,null,null,null,null,0]
[null,29,"",null,null,null,null,null,0]
[null,30,"",null,null,null,null,null,0]
[null,31,"",null,null,null,null,null,0]
[null,32,"",null,null,null,null,null,0]
[null,33,"",null,null,null,null,null,0]
[null,34,"",null,null,null,null,null,0]
[null,35,"",null,null,null,null,null,0]
[null,36,"",null,null,null,null,null,0]
[null,37,"",null,null,null,null,null,0]
[null,38,"",null,null,null,null,null,0]
[null,39,"",null,null,null,null,null,0]
[null,40,"",null,null,null,null,null,0]

{"sheet":"10. Comments","index":10,"n_rows":51,"n_cols":6,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[null,"STATE OF CALIFORNIA",null,null,null,"Department of Health Care Services"]
[null,"HEALTH AND HUMAN SERVICES AGENCY"]
[]
[null,"DHCS 1822 J (Rev. 10/18)"]
[null,{"$f":"'1. Information'!B5","v":"Annual Mental Health Services Act Revenue and Expenditure Report"}]
[null,{"$f":"'1. Information'!B6","v":"Fiscal Year: 2022-23"}]
[null,"Comments"]
[]
[null,"County:",{"$f":"IF(ISBLANK('1. Information'!D11),\"\",'1. Information'!D11)","v":"San Benito"},null,"Date:",{"$f":"IF(ISBLANK('1. Information'!D9),\"\",'1. Information'!D9)","v":"2024-03-07"}]
[]
[null,null,"Component","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":"Checks","index":11,"n_rows":64,"n_cols":9,"rows_kept":64,"cut":false,"hidden":true,"merged":[]}
["SCO Distribution"]
["FY 2017-18"]
[null,null,"Total x 76%","Total x 19%","Total x 5%",null,"County Check:",{"$f":"'1. Information'!D11","v":"San Benito"}]
["County","TOTAL","CSS","PEI","INN"]
["Alameda",70551654.329999998,{"$f":"B5*0.76","v":53619257.290799998},{"$f":"B5*0.19","v":13404814.322699999},{"$f":"B5*0.05","v":3527582.7165000001},null,"Cell","Status","Notes"]
["Alpine",1499512.8499999999,{"$f":"B6*0.76","v":1139629.7659999998},{"$f":"B6*0.19","v":284907.44149999996},{"$f":"B6*0.05","v":74975.642500000002},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",2931915.6899999995,2228255.9243999994,557063.98109999986,146595.78449999998,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",5994545.0099999988,4555854.2075999994,1138963.5518999998,299727.25049999997,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",11405471.799999999,8668158.568,2167039.642,570273.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",3208867.31,2438739.1556000002,609684.78890000004,160443.36550000001,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",2568596.2199999997,1952133.1271999998,488033.28179999994,128429.81099999999]
["Contra Costa",45360350.140000008,34473866.106400006,8618466.5266000014,2268017.5070000007]
["Del Norte",2728833.71,2073913.6196000001,518478.40490000002,136441.68549999999]
["El Dorado",7928641.3099999987,6025767.3955999995,1506441.8488999999,396432.06549999997]
["Fresno",49459289.239999995,37589059.822399996,9397264.9555999991,2472964.4619999998]
["Glenn",2777161.3,2110642.588,527660.647,138858.065]
["Humboldt",7058805.6600000011,5364692.3016000008,1341173.0754000002,352940.28300000005]
["Imperial",9759832.0800000001,7417472.3808000004,1854368.0952000001,487991.60400000005]
["Inyo",1843374.33,1400964.4908,350241.12270000001,92168.71650000001]
["Kern",42775932.490000002,32509708.692400001,8127427.1731000002,2138796.6245000004]
["Kings",8142509.4199999999,6188307.1591999996,1547076.7897999999,407125.47100000002]
["Lake",3954947.83,3005760.3508000001,751440.08770000003,197747.39150000003]
["Lassen",2718985.63,2066429.0788,516607.2697,135949.28150000001]
["Los Angeles",562799427.95000005,427727565.24200004,106931891.31050001,28139971.397500005]
["Madera",8618217.0300000012,6549844.9428000012,1637461.2357000003,430910.85150000011]
["Marin",11207287.699999999,8517538.6519999988,2129384.6629999997,560364.38500000001]
["Mariposa",1848530.92,1404883.4992,351220.87479999999,92426.546000000002]
["Mendocino",4823051.5200000005,3665519.1552000004,916379.7888000001,241152.57600000003]
["Merced",14640569.48,11126832.8048,2781708.2012,732028.47400000005]
["Modoc",1685960.2599999998,1281329.7975999999,320332.44939999998,84298.012999999992]
["Mono",1795078.7,1364259.8119999999,341064.95299999998,89753.934999999998]
["Monterey",23244033.949999992,17665465.801999994,4416366.4504999984,1162201.6974999995]
["Napa",6536717.3899999997,4967905.2164000003,1241976.3041000001,326835.86950000003]
["Nevada",5205259.92,3955997.5392,988999.3848,260262.99600000001]
["Orange",161768522.68000001,122944077.2368,30736019.3092,8088426.1340000005]
["Placer",13984445.129999997,10628178.298799997,2657044.5746999993,699222.2564999999]
["Plumas",2467653.1999999997,1875416.4319999998,468854.10799999995,123382.65999999999]
["Riverside",107758676.78999998,81896594.360399976,20474148.590099994,5387933.8394999988]
["Sacramento",64816236.610000007,49260339.823600009,12315084.955900002,3240811.8305000006]
["San Benito",3734424.29,2838162.4604000002,709540.61510000005,186721.2145]
["San Bernardino",105985451.15000001,80548942.874000013,20137235.718500003,5299272.557500001]
["San Diego",162263869.34999999,123320540.706,30830135.1765,8113193.4675000003]
["San Francisco",36784240.540000007,27956022.810400005,6989005.7026000014,1839212.0270000005]
["San Joaquin",34063364.469999999,25888156.997200001,6472039.2493000003,1703168.2235000001]
["San Luis Obispo",13341171.349999998,10139290.225999998,2534822.5564999995,667058.56749999989]
["San Mateo",32446715.590000004,24659503.848400004,6164875.9621000011,1622335.7795000002]
["Santa Barbara",22984920.520000003,17468539.595200002,4367134.8988000005,1149246.0260000003]
["Santa Clara",89754925.079999998,68213743.060800001,17053435.7652,4487746.2539999997]
["Santa Cruz",14340650.48,10898894.364800001,2724723.5912000001,717032.52400000009]
["Shasta",9451466.3299999982,7183114.4107999988,1795778.6026999997,472573.31649999996]
["Sierra",1543875.5100000002,1173345.3876000002,293336.34690000006,77193.775500000018]
["Siskiyou",3180379.8300000005,2417088.6708000004,604272.16770000011,159018.99150000003]
["Solano",19695352.549999997,14968467.937999997,3742116.9844999993,984767.62749999994]
["Sonoma",22448346.500000004,17060743.340000004,4265185.8350000009,1122417.3250000002]
["Stanislaus",25846252.59,19643151.968400002,4910787.9921000004,1292312.6295]
["Sutter",8720457.4700000007,6627547.6772000007,1656886.9193000002,436022.87350000005]
["Tehama",3817793.55,2901523.0979999998,725380.77449999994,190889.67749999999]
["Tri-City",11170390.67,8489496.9091999996,2122374.2272999999,558519.53350000002]
["Trinity",1780320.58,1353043.6408000002,338260.91020000004,89016.02900000001]
["Tulare",24328481.469999995,18489645.917199995,4622411.4792999988,1216424.0734999997]
["Tuolumne",3531297.5500000003,2683786.1380000003,670946.53450000007,176564.87750000003]
["Ventura",40893418.259999998,31078997.877599999,7769749.4693999998,2044670.9129999999]
["Yolo",10880652.609999999,8269295.9835999999,2067323.9959,544032.63049999997]
["Grand Total",{"$f":"SUM(B5:B63)","v":1978857113.8699994},{"$f":"SUM(C5:C63)","v":1503931406.5412004},{"$f":"SUM(D5:D63)","v":375982851.6353001},{"$f":"SUM(E5:E63)","v":98942855.693499953}]

{"sheet":"drop down fields","index":12,"n_rows":60,"n_cols":14,"rows_kept":60,"cut":false,"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",1,"Yes","FSP","Combined","Prevention","Project","Workforce Staffing","Capital Facility","CSS","FY 2015-16","FY 2009-10","Cost Report Reconciliation","Audited"]
["Alpine",2,"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",3,null,null,null,"Outreach","Project Evaluation","MH Career Pathways",null,"INN",null,"FY 2011-12","SDMC Chart Audit","Initial"]
["Berkeley City",65,null,null,null,"Stigma & Discrimination Reduction",null,"Residency/Internship",null,"WET",null,"FY 2012-13","Local Quality Assurance Audit"]
["Butte",4,null,null,null,"Suicide Prevention",null,"Financial Incentive",null,"CFTN",null,"FY 2013-14","Error"]
["Calaveras",5,null,null,null,"Access and Linkage",null,null,null,"WET RP",null,"FY 2014-15","Other"]
["Colusa",6,null,null,null,"Improving Timely Access",null,null,null,"PEI SW",null,"FY 2015-16"]
["Contra Costa",7,null,null,null,"Combined Summary",null,null,null,"MHSA HP",null,"FY 2016-17"]
["Del Norte",8,null,null,null,null,null,null,null,"Prudent Reserve"]
["El Dorado",9]
["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":13,"n_rows":83,"n_cols":5,"rows_kept":83,"cut":false,"hidden":true,"merged":[[4,1,4,2],[1,0,1,4],[2,0,2,4]]}
[null,null,null,"About the Data"]
["E-1: State/County Population Estimates with Annual Percent Change"]
["January 1, 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",39500973,39809693,0.8]
[]
["Alameda",1646405,1660202,0.8,{"$f":"IF(B10>=200000,\"Yes\", \"No\")","v":"Yes"}]
["Alpine",1156,1154,-0.2,{"$f":"IF(B11>=200000,\"Yes\", \"No\")","v":"No"}]
["Amador",38382,38094,-0.8,"No"]
["Butte",226403,227621,0.5,"Yes"]
["Calaveras",45175,45157,0,"No"]
["Colusa",22050,22098,0.2,"No"]
["Contra Costa",1139313,1149363,0.9,"Yes"]
["Del Norte",27060,27221,0.6,"No"]
["El Dorado",186223,188399,1.2,"No"]
["Fresno",995233,1007229,1.2,"Yes"]
["Glenn",28730,28796,0.2,"No"]
["Humboldt",136430,136002,-0.3,"No"]
["Imperial",187921,190624,1.4,"No"]
["Inyo",18598,18577,-0.1,"No"]
["Kern",896101,905801,1.1000000000000001,"Yes"]
["Kings",149559,151662,1.4,"No"]
["Lake",64740,65081,0.5,"No"]
["Lassen",30661,30911,0.8,"No"]
["Los Angeles",10231271,10283729,0.5,"Yes"]
["Madera",156963,158894,1.2,"No"]
["Marin",263262,263886,0.2,"Yes"]
["Mariposa",18137,18129,0,"No"]
["Mendocino",89092,89299,0.2,"No"]
["Merced",275104,279977,1.8,"Yes"]
["Modoc",9562,9612,0.5,"No"]
["Mono",13759,13822,0.5,"No"]
["Monterey",442149,443281,0.3,"Yes"]
["Napa",141784,141294,-0.3,"No"]
["Nevada",98613,99155,0.5,"No"]
["Orange",3198968,3221103,0.7,"Yes"]
["Placer",383173,389532,1.7,"Yes"]
["Plumas",19818,19773,-0.2,"No"]
["Riverside",2382640,2415955,1.4,"Yes"]
["Sacramento",1513415,1529501,1.1000000000000001,"Yes"]
["San Benito",56879,57088,0.4,"No"]
["San Bernardino",2155590,2174938,0.9,"Yes"]
["San Diego",3309509,3337456,0.8,"Yes"]
["San Francisco",874008,883963,1.1000000000000001,"Yes"]
["San Joaquin",747263,758744,1.5,"Yes"]
["San Luis Obispo",279210,280101,0.3,"Yes"]
["San Mateo",770256,774155,0.5,"Yes"]
["Santa Barbara",450025,453457,0.8,"Yes"]
["Santa Clara",1937473,1956598,1,"Yes"]
["Santa Cruz",276504,276864,0.1,"Yes"]
["Shasta",178148,178271,0.1,"No"]
["Sierra",3203,3207,0.1,"No"]
["Siskiyou",44655,44612,-0.1,"No"]
["Solano",436640,439793,0.7,"Yes"]
["Sonoma",504613,503332,-0.3,"Yes"]
["Stanislaus",549976,555624,1,"Yes"]
["Sutter",96919,97238,0.3,"No"]
["Tehama",63949,64039,0.1,"No"]
["Trinity",13634,13635,0,"No"]
["Tulare",470716,475834,1.1000000000000001,"Yes"]
["Tuolumne",54725,54740,0,"No"]
["Ventura",855910,859073,0.4,"Yes"]
["Yolo",218673,221270,1.2,"Yes"]
["Yuba",74645,74727,0.1,"No"]
[]
["Sutter/Yuba",{"$f":"B60+B67","v":171564},{"$f":"C60+C67","v":171965},null,"No"]
["Berkeley City",120700,121874,1,"No"]
["Tri-City",{"$f":"B73+B74+B75","v":224180},{"$f":"C73+C74+C75","v":225393},null,"Yes"]
[]
["Claremont",36293,36446,0.4]
["La Verne",33169,33260,0.3]
["Pomona",154718,155687,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"]