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

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

{"sheet":"Instructions","index":1,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":false,"merged":[[13,1,15,1],[11,1,12,1],[11,2,12,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2]]}
[]
[null,{"$f":"'1. Information'!B2","v":"Version 7/1/2018"}]
[null,{"$f":"'1. Information'!B3","v":"Annual Mental Health Services Act Revenue and Expenditure Report"}]
[null,{"$f":"'1. Information'!B4","v":"Fiscal Year 2017-18"}]
[null,"ARER Instructions "]
[]
[null,"• For detailed instructions, see Enclosure 2: Instruction Manual for Fiscal Year 2017-18 of the MHSA Annual Revenue and Expenditure Report. "]
[null,"• These worksheets are used to report the total expenditures for each MHSA-funded program. Expenditures should be recognized in the period that the fund liability is incurred. (Accounting Standards and Procedures for Counties, State Controller’s Office (SCO), February 2018). "]
[null,"• Counties must report any expenditure that occurred between July 1, 2017 and June 30, 2018, on the appropriate component worksheet."]
[null,"• Counties should reflect total (gross) program expenditures for each MHSA program on the MHSA Component Expenditure Worksheets."]
[]
[null,"Step 1: Complete the Information worksheet","The information provided on the Information worksheet automatically links to worksheets in the ARER.  This worksheet eliminates the redundant entry of county name, code, and date on worksheets. "]
[]
[null,"Step 2: Complete section one and two of the Component Summary worksheet","Section one: Enter the balance of Prudent Reserve and the Interest earned on the Local Mental Health Fund. Interest earned on local MHS fund is to be reported in total.  "]
[null,null,"Section two: Enter the component revenue received from prudent reserve transfers. Additionally, the worksheet is set up to distribute the interest reported in section one across CSS, PEI, and INN components according to 76%, 19% and 5%."]
[null,null,"Section three and four: These sections are linked to the remaining component worksheets and will auto populate as the county completes each individual worksheet."]
[null,"Step 3: Complete each component and adjustment worksheet","In general, counties will enter expenditure data in the blue boxes throughout the workbook. Cells shaded gray will require no data entry because it is an excel formula or data is not relevant for that particular cell."]
[null,"Step 4: Review the Component Summary worksheet","Counties should verify that each section of the Component Summary worksheet accurately reflect the expenditures reported on the component and adjustment worksheets."]

{"sheet":"1. Information","index":2,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Version 7/1/2018"]
[null,"Annual Mental Health Services Act Revenue and Expenditure Report"]
[null,"Fiscal Year 2017-18"]
[null,"Information"]
[]
[null,1,"Date:","2018-12-31"]
[null,2,"County:","Sierra"]
[null,3,"County Code:",{"$f":"IF(ISBLANK(D8),\"\",VLOOKUP(D8,Info_County_Code,2))","v":46}]
[null,4,"Address:","P.O. Box 265, 207 Front Street"]
[null,5,"City:","Loyalton"]
[null,6,"Zip:",96118]
[null,7,"County Population:  Over 200,000? (Yes or No)",{"$f":"IF(ISBLANK(D8),\"\",VLOOKUP(D8,County_Population,5,FALSE))","v":"No"}]
[null,8,"Name of Preparer:","Judy Blakney"]
[null,9,"Title of Preparer:","Fiscal Officer"]
[null,10,"Preparer Contact Email:","jblakney@sierracounty.ca.gov"]
[null,11,"Preparer Contact Telephone","(530) 993-6730"]

{"sheet":"2. Component Summary","index":3,"n_rows":41,"n_cols":14,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"'1. Information'!B2","v":"Version 7/1/2018"}]
[null,{"$f":"'1. Information'!B3","v":"Annual Mental Health Services Act Revenue and Expenditure Report"}]
[null,{"$f":"'1. Information'!B4","v":"Fiscal Year 2017-18"}]
[null,"Component Summary "]
[]
[null,"County:",{"$f":"IF(ISBLANK('1. Information'!D8),\"\",'1. Information'!D8)","v":"Sierra"},null,null,"Date:",{"$f":"IF(ISBLANK('1. Information'!D7),\"\",'1. Information'!D7)","v":"2018-12-31"}]
[]
[]
[]
[]
[]
[]
[null,"SECTION 1: Interest and Prudent Reserve",null,"TOTAL"]
[null,1,"Interest Earned on local MHS Fund",71779]
[null,2,"Local Prudent Reserve Beginning Balance",741451.88]
[null,3,"Local Prudent Reserve Ending Balance",{"$f":"D16+M22+M27+SUM('9. Adjustment (MHSA)'!F83:F112)","v":741451.88}]
[]
[null,null,null,"A","B","C","D","E","F","G","H","I","J","K"]
[null,null,null,"CSS","PEI","INN","WET","CFTN","TTACB","WET RP","PEI SW","MHSA HP","PR","TOTAL"]
[null,"SECTION 2: Transfers from Prudent Reserve and Interest Earned"]
[null,4,"Transfer from Local Prudent Reserve",null,null,null,null,null,null,null,null,null,{"$f":"(-D22-E22)","v":0},{"$f":"SUM(D22:M22)","v":0}]
[null,5,"FY 2017-18 Interest Earned on local MHS Fund",{"$f":"D15*0.76","v":54552.04},{"$f":"D15*0.19","v":13638.01},{"$f":"D15*0.05","v":3588.9500000000003},null,null,null,null,null,null,null,{"$f":"SUM(D23:M23)","v":71779}]
[null,6,"TOTAL",{"$f":"SUM(D22:D23)","v":54552.04},13638.01,3588.9500000000003,0,0,0,0,0,0,0,{"$f":"SUM(D24:M24)","v":71779}]
[]
[null,"SECTION 3: Transfers to Prudent Reserve, WET or CFTN"]
[null,7,"Transfers",{"$f":"(G27+H27+M27)*-1","v":-227631},null,null,{"$f":"'3. CSS'!F20","v":227631},{"$f":"'3. CSS'!F21","v":0},null,null,null,null,{"$f":"'3. CSS'!F22","v":0},{"$f":"SUM(D27:M27)","v":0}]
[]
[null,"SECTION 4: Program Expenditures and Sources of Funding 2017-18"]
[null,8,"MHSA Funds (Including Interest)",{"$f":"'3. CSS'!F25","v":821725},{"$f":"'4. PEI'!F21","v":297593},{"$f":"'5. INN'!F22","v":0},{"$f":"'6. WET'!F20","v":41186},{"$f":"'7. CFTN'!F21","v":12519},null,{"$f":"'8. WET RP, HP'!E14","v":0},{"$f":"'4. PEI'!F17","v":0},{"$f":"'8. WET RP, HP'!E15","v":0},null,{"$f":"SUM(D30:M30)","v":1173023}]
[null,9,"Medi-Cal FFP",{"$f":"'3. CSS'!G25","v":0},{"$f":"'4. PEI'!G21","v":0},{"$f":"'5. INN'!G22","v":0},{"$f":"'6. WET'!G20","v":0},{"$f":"'7. CFTN'!G21","v":0},null,{"$f":"'8. WET RP, HP'!F14","v":0},{"$f":"'4. PEI'!G17","v":0},{"$f":"'8. WET RP, HP'!F15","v":0},null,0]
[null,10,"1991 Realignment",{"$f":"'3. CSS'!H25","v":0},{"$f":"'4. PEI'!H21","v":0},{"$f":"'5. INN'!H22","v":0},{"$f":"'6. WET'!H20","v":0},{"$f":"'7. CFTN'!H21","v":0},null,{"$f":"'8. WET RP, HP'!G14","v":0},{"$f":"'4. PEI'!H17","v":0},{"$f":"'8. WET RP, HP'!G15","v":0},null,0]
[null,11,"Behavioral Health Subaccount",{"$f":"'3. CSS'!I25","v":0},{"$f":"'4. PEI'!I21","v":0},{"$f":"'5. INN'!I22","v":0},{"$f":"'6. WET'!I20","v":0},{"$f":"'7. CFTN'!I21","v":0},null,{"$f":"'8. WET RP, HP'!H14","v":0},{"$f":"'4. PEI'!I17","v":0},{"$f":"'8. WET RP, HP'!H15","v":0},null,0]
[null,12,"Other",{"$f":"'3. CSS'!J25","v":46293},{"$f":"'4. PEI'!J21","v":8450},{"$f":"'5. INN'!J22","v":0},{"$f":"'6. WET'!J20","v":0},{"$f":"'7. CFTN'!J21","v":0},null,{"$f":"'8. WET RP, HP'!I14","v":0},{"$f":"'4. PEI'!J17","v":0},{"$f":"'8. WET RP, HP'!I15","v":0},null,54743]
[null,13,"TOTAL",{"$f":"SUM(D30:D34)","v":868018},{"$f":"SUM(E30:E34)","v":306043},0,41186,12519,0,0,0,0,null,1227766]
[]
[]
[null,"SECTION 5: MHSA Planning Costs",null,"TOTAL"]
[null,14,"Total Annual Planning Costs",{"$f":"'3. CSS'!K14+'4. PEI'!K14+'5. INN'!K14+'6. WET'!K14+'7. CFTN'!K14","v":13310}]
[null,15,"Total Evaluation Costs",{"$f":"'3. CSS'!K15+'4. PEI'!K15+'5. INN'!K19+'6. WET'!K15+'7. CFTN'!K16+'7. CFTN'!K17","v":0}]
[null,16,"Total Administration",{"$f":"'3. CSS'!K16+'4. PEI'!K16+'5. INN'!K15+'5. INN'!K18+'6. WET'!K16+'7. CFTN'!K18+'7. CFTN'!K19","v":338379}]

{"sheet":"3. CSS","index":4,"n_rows":132,"n_cols":12,"rows_kept":132,"cut":false,"hidden":false,"merged":[[23,2,23,4],[30,7,30,10],[30,3,30,5],[24,2,24,4],[11,6,11,9],[19,2,19,4],[20,2,20,4],[21,2,21,4],[22,2,22,4],[18,2,18,4],[16,2,16,4],[17,2,17,4],[0,1,0,3],[6,1,6,2],[13,2,13,4],[14,2,14,4],[15,2,15,4]]}
[]
[null,{"$f":"'1. Information'!B2","v":"Version 7/1/2018"}]
[null,{"$f":"'1. Information'!B3","v":"Annual Mental Health Services Act Revenue and Expenditure Report"}]
[null,{"$f":"'1. Information'!B4","v":"Fiscal Year 2017-18"}]
[null,"Community Services and Supports (CSS) Summary  "]
[]
[null,"County:",null,{"$f":"IF(ISBLANK('1. Information'!D8),\"\",'1. Information'!D8)","v":"Sierra"},null,"Date:",{"$f":"IF(ISBLANK('1. Information'!D7),\"\",'1. Information'!D7)","v":"2018-12-31"}]
[]
[null,"SECTION ONE"]
[]
[null,null,null,null,null,"A","B","C","D","E","F"]
[null,null,null,null,null,"MHSA Funds","Other Funds"]
[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,5597,null,null,null,null,{"$f":"SUM(F14:J14)","v":5597}]
[null,2,"CSS Evaluation Costs",null,null,null,null,null,null,null,{"$f":"SUM(F15:J15)","v":0}]
[null,3,"CSS Administration Costs",null,null,184220,null,null,null,null,184220]
[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 WET",null,null,227631,null,null,null,null,227631]
[null,8,"CSS Funds Transferred to CFTN",null,null,null,null,null,null,null,0]
[null,9,"CSS Funds Transferred to PR",null,null,null,null,null,null,null,0]
[null,10,"CSS Program Expenditures",null,null,{"$f":"SUM(G33:G132)","v":631908},{"$f":"SUM(H33:H132)","v":0},{"$f":"SUM(I33:I132)","v":0},{"$f":"SUM(J33:J132)","v":0},{"$f":"SUM(K33:K132)","v":46293},678201]
[null,11,"Total CSS Expenditures (Excluding Funds Transferred to JPA)",null,null,{"$f":"SUM(F14:F16,F18:F23)","v":1049356},{"$f":"SUM(G14:G16,G18:G23)","v":0},{"$f":"SUM(H14:H16,H18:H23)","v":0},0,46293,{"$f":"SUM(K14:K16,K18:K23)","v":1095649}]
[null,12,"Total CSS Expenditures (Excluding Funds Transferred)",null,null,{"$f":"SUM(F14:F16,F18,F23)","v":821725},{"$f":"SUM(G14:G16,G18,G23)","v":0},0,0,46293,{"$f":"SUM(K14:K16,K18,K23)","v":868018}]
[]
[]
[null,"SECTION TWO"]
[]
[null,null,"A","B","C","D","E","F","G","H","I","J"]
[null,null,null,"CSS Component",null,null,"MHSA Funds","Other Funds"]
[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(L33<>0,VLOOKUP($D$7,Info_County_Code,2,FALSE),\"\")","v":46},"Wellness Center",null,"Non-FSP",74841,null,null,null,null,{"$f":"SUM(G33:K33)","v":74841}]
[null,2,46,"Ways to Wellness",null,"Non-FSP",1351,null,null,null,null,{"$f":"SUM(G34:K34)","v":1351}]
[null,3,46,"General Service Delivery",null,"Non-FSP",342009,null,null,null,46293,388302]
[null,4,46,"Front Porch Program",null,"Non-FSP",420,null,null,null,null,420]
[null,5,46,"Full Service Partnership",null,"FSP",213287,null,null,null,null,213287]
[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(L65<>0,VLOOKUP($D$7,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(G77:K77)","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(L97<>0,VLOOKUP($D$7,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(G98:K98)","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(G110:K110)","v":0}]
[null,79,"",null,null,null,null,null,null,null,null,{"$f":"SUM(G111:K111)","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(G120:K120)","v":0}]
[null,89,"",null,null,null,null,null,null,null,null,{"$f":"SUM(G121:K121)","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(G123:K123)","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(G127:K127)","v":0}]
[null,96,"",null,null,null,null,null,null,null,null,{"$f":"SUM(G128:K128)","v":0}]
[null,97,"",null,null,null,null,null,null,null,null,{"$f":"SUM(G129:K129)","v":0}]
[null,98,"",null,null,null,null,null,null,null,null,{"$f":"SUM(G130:K130)","v":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":5,"n_rows":135,"n_cols":19,"rows_kept":135,"cut":false,"hidden":false,"merged":[[33,3,33,10],[33,12,33,15],[28,2,28,4],[6,1,6,2],[12,2,12,4],[13,2,13,4],[14,2,14,4],[15,2,15,4],[16,2,16,4],[25,6,27,6],[11,6,11,9],[25,5,27,5],[20,2,20,4],[19,2,19,4],[17,2,17,4],[18,2,18,4]]}
[]
[null,{"$f":"'1. Information'!B2","v":"Version 7/1/2018"}]
[null,{"$f":"'1. Information'!B3","v":"Annual Mental Health Services Act Revenue and Expenditure Report"}]
[null,{"$f":"'1. Information'!B4","v":"Fiscal Year 2017-18"}]
[null,"Prevention and Early Intervention (PEI) Summary"]
[]
[null,"County:",null,{"$f":"IF(ISBLANK('1. Information'!D8),\"\",'1. Information'!D8)","v":"Sierra"},null,"Date:",{"$f":"IF(ISBLANK('1. Information'!D7),\"\",'1. Information'!D7)","v":"2018-12-31"}]
[]
[null,"SECTION ONE"]
[]
[null,null,null,null,null,"A","B","C","D","E","F"]
[null,null,null,null,null,"MHSA Funds","Other Funds"]
[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,7713,null,null,null,null,{"$f":"SUM(F14:J14)","v":7713}]
[null,2,"PEI Evaluation Costs",null,null,null,null,null,null,null,{"$f":"SUM(F15:J15)","v":0}]
[null,3,"PEI Administration Costs",null,null,138612,null,null,null,null,138612]
[null,4,"PEI Funds Expended by CalMHSA for PEI SW ",null,null,null,null,null,null,null,0]
[null,5,"PEI Funds Transferred to JPA",null,null,null,null,null,null,null,0]
[null,6,"PEI Expenditure Incurred by JPA",null,null,null,null,null,null,null,0]
[null,7,"PEI Program Expenditures",null,null,{"$f":"SUMIF($G$36:$G$135,\"Combined Summary\",L$36:L$135) + SUMIF($F$36:$F$135,\"Standalone\",L$36:L$135)","v":151268},{"$f":"SUMIF($G$36:$G$135,\"Combined Summary\",M$36:M$135) + SUMIF($F$36:$F$135,\"Standalone\",M$36:M$135)","v":0},{"$f":"SUMIF($G$36:$G$135,\"Combined Summary\",N$36:N$135) + SUMIF($F$36:$F$135,\"Standalone\",N$36:N$135)","v":0},{"$f":"SUMIF($G$36:$G$135,\"Combined Summary\",O$36:O$135) + SUMIF($F$36:$F$135,\"Standalone\",O$36:O$135)","v":0},{"$f":"SUMIF($G$36:$G$135,\"Combined Summary\",P$36:P$135) + SUMIF($F$36:$F$135,\"Standalone\",P$36:P$135)","v":8450},159718]
[null,8,"Total PEI Expenditures (Excluding Transfers and PEI SW)",null,null,{"$f":"SUM(F14:F16,F19:F20)","v":297593},{"$f":"SUM(G14:G16,G19:G20)","v":0},0,0,8450,306043]
[]
[null,"SECTION TWO"]
[]
[null,null,null,null,null,"A","B"]
[null,null,null,null,null,"Percent Expended for Clients 25 and Under, All PEI","Percent Expended for Clients 25 and Under, JPA"]
[]
[]
[null,1,"MHSA PEI Fund Expenditures in Program to Clients 25 and Under (calculated from weighted program values) divided by Total MHSA PEI Expenditures",null,null,{"$f":"IF(F21=0,\"\",((SUMPRODUCT($K$36:$K$135,$L$36:$L$135)+(F19*G29))/$F$21))","v":0.1614336466247526}]
[]
[null,"SECTION THREE"]
[]
[null,null,"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O"]
[null,null,null,"PEI Component",null,null,null,null,null,null,null,"MHSA Funds","Other Funds"]
[null,"#","County","Program Name","Prior Program Name","Combined/ Standalone","Program Type","Program Activity Name (in Combined Program)","Subtotal Percentage for Combined Program","% of PEI Expended on Clients 25 & Under (Standalone and Program Activities in Combined Program)","% of PEI Expended on Clients 25 & Under (Combined Summary and Standalone)","Total MHSA (Including Interest)","Medi-Cal FFP","1991 Realignment","Behavioral Health Subaccount","Other","Grand Total","Check","Check"]
[null,1,{"$f":"IF(AND(NOT(COUNTA(D36:J36)),(NOT(COUNTA(L36:P36)))),\"\",VLOOKUP($D$7,Info_County_Code,2,FALSE))","v":46},"Music Together",null,"Standalone","Early Intervention",null,1,1,{"$f":"IF(OR(G36=\"Combined Summary\",F36=\"Standalone\"),(SUMPRODUCT(--(D$36:D$135=D36),I$36:I$135,J$36:J$135)),\"\")","v":1},110,null,null,null,null,{"$f":"SUM(L36:P36)","v":110},{"$f":"IF(OR(G36=\"Combined Summary\",F36=\"Standalone\"),(SUMIF(D$36:D$135,D36,I$36:I$135)),\"\")","v":1},{"$f":"IF(AND(F36=\"Standalone\",NOT(R36=1)),\"ERROR\",IF(AND(G36=\"Combined Summary\",NOT(R36=1)),\"ERROR\",\"\"))","v":""}]
[null,2,46,"Nurturing Parenting",null,"Combined","Combined Summary","Prevention",0.66,1,{"$f":"IF(OR(G37=\"Combined Summary\",F37=\"Standalone\"),(SUMPRODUCT(--(D$36:D$135=D37),I$36:I$135,J$36:J$135)),\"\")","v":0.66},22471,null,null,null,null,{"$f":"SUM(L37:P37)","v":22471},{"$f":"IF(OR(G37=\"Combined Summary\",F37=\"Standalone\"),(SUMIF(D$36:D$135,D37,I$36:I$135)),\"\")","v":0.66},{"$f":"IF(AND(F37=\"Standalone\",NOT(R37=1)),\"ERROR\",IF(AND(G37=\"Combined Summary\",NOT(R37=1)),\"ERROR\",\"\"))","v":"ERROR"}]
[null,3,46,"Wellness Center",null,"Combined","Combined Summary","Prevention",0.85,0.15,0.1275,86535,null,null,null,null,86535,0.85,"ERROR"]
[null,4,46,"Early Intervention Treatment",null,"Standalone","Early Intervention",null,1,1,1,15024,null,null,null,null,15024,1,""]
[null,5,46,"Veteran's Peer Support",null,"Combined","Combined Summary","Prevention",0.97,0.03,2.9099999999999997E-2,13177,null,null,null,null,13177,0.97,"ERROR"]
[null,6,46,"Student Parent Navigation",null,"Combined","Combined Summary","Early Intervention",0.8,0.75,0.60000000000000009,11100,null,null,null,8450,19550,0.8,"ERROR"]
[null,7,46,"Mental Health First Aid",null,"Combined","Combined Summary","Prevention",0.5,null,0,2851,null,null,null,null,2851,0.5,"ERROR"]
[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(D68:J68)),(NOT(COUNTA(L68:P68)))),\"\",VLOOKUP($D$7,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(L93:P93)","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(D100:J100)),(NOT(COUNTA(L100:P100)))),\"\",VLOOKUP($D$7,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(G101=\"Combined Summary\",F101=\"Standalone\"),(SUMPRODUCT(--(D$36:D$135=D101),I$36:I$135,J$36:J$135)),\"\")","v":""},null,null,null,null,null,{"$f":"SUM(L101:P101)","v":0},{"$f":"IF(OR(G101=\"Combined Summary\",F101=\"Standalone\"),(SUMIF(D$36:D$135,D101,I$36:I$135)),\"\")","v":""},{"$f":"IF(AND(F101=\"Standalone\",NOT(R101=1)),\"ERROR\",IF(AND(G101=\"Combined Summary\",NOT(R101=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(L107:P107)","v":0},"",""]
[null,73,"",null,null,null,null,null,null,null,"",null,null,null,null,null,{"$f":"SUM(L108:P108)","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(L123:P123)","v":0},"",""]
[null,89,"",null,null,null,null,null,null,null,"",null,null,null,null,null,{"$f":"SUM(L124:P124)","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(D132:J132)),(NOT(COUNTA(L132:P132)))),\"\",VLOOKUP($D$7,Info_County_Code,2,FALSE))","v":""},null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,98,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,99,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]
[null,100,"",null,null,null,null,null,null,null,"",null,null,null,null,null,0,"",""]

{"sheet":"5. INN","index":6,"n_rows":132,"n_cols":16,"rows_kept":132,"cut":false,"hidden":false,"merged":[[21,2,21,4],[11,6,11,9],[26,3,26,9],[26,11,26,14],[0,1,0,3],[14,2,14,4],[18,2,18,4],[19,2,19,4],[20,2,20,4],[17,2,17,4],[6,1,6,2],[13,2,13,4],[12,2,12,4],[15,2,15,4],[16,2,16,4]]}
[]
[null,{"$f":"'1. Information'!B2","v":"Version 7/1/2018"}]
[null,{"$f":"'1. Information'!B3","v":"Annual Mental Health Services Act Revenue and Expenditure Report"}]
[null,{"$f":"'1. Information'!B4","v":"Fiscal Year 2017-18"}]
[null,"Innovation (INN) Summary"]
[]
[null,"County:",null,{"$f":"IF(ISBLANK('1. Information'!D8),\"\",'1. Information'!D8)","v":"Sierra"},null,"Date:",{"$f":"IF(ISBLANK('1. Information'!D7),\"\",'1. Information'!D7)","v":"2018-12-31"}]
[]
[null,"SECTION ONE"]
[]
[null,null,null,null,null,"A","B","C","D","E","F"]
[null,null,null,null,null,"MHSA Funds","Other Funds"]
[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,null,null,null,null,null,{"$f":"SUM(F14:J14)","v":0}]
[null,2,"INN Indirect Administration",null,null,null,null,null,null,null,{"$f":"SUM(F15:J15)","v":0}]
[null,3,"INN Funds Transferred to JPA",null,null,null,null,null,null,null,{"$f":"SUM(F16:J16)","v":0}]
[null,4,"INN Expenditure Incurred by JPA",null,null,null,null,null,null,null,{"$f":"SUM(F17:J17)","v":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},{"$f":"SUM(F18:J18)","v":0}]
[null,6,"INN Project Evaluation",null,null,{"$f":"SUMIF($J$29:$J$132,\"Project Evaluation\",K$29:K$132)","v":0},{"$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},0]
[null,7,"INN Project Direct",null,null,{"$f":"SUMIF($J$29:$J$132,\"Project Direct\",K$29:K$132)","v":0},{"$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},0]
[null,8,"INN Project Subtotal",null,null,{"$f":"SUM(F18:F20)","v":0},{"$f":"SUM(G18:G20)","v":0},{"$f":"SUM(H18:H20)","v":0},{"$f":"SUM(I18:I20)","v":0},{"$f":"SUM(J18:J20)","v":0},{"$f":"SUM(K18:K20)","v":0}]
[null,9,"Total Innovation Expenditures  (Excluding Transfers to JPA)",null,null,{"$f":"SUM(F14:F15,F17,F18:F20)","v":0},0,0,0,0,0]
[]
[null,"SECTION TWO"]
[]
[null,null,"A","B","C","D","E","F","G","H","I","J","K","L","M","N"]
[null,null,null,"INN Component",null,null,null,null,null,null,"MHSA Funds","Other Funds"]
[null,"#","County","Project Name","Prior Project Name","Project MHSOAC Approval Date","Project Start Date","MHSOAC-Authorized MHSA INN Project Budget","Amended MHSOAC-Authorized MHSA INN Project Budget","Project Expenditure Type","Total MHSA (Including Interest)","Medi-Cal FFP","1991 Realignment","BH Subaccount","Other","Grand Total"]
[null,1,{"$f":"IF(P32<>0,VLOOKUP($D$7,Info_County_Code,2,FALSE),\"\")","v":""},null,null,null,null,null,null,"Project Administration",null,null,null,null,null,{"$f":"SUM(K29:O29)","v":0}]
[null,1,{"$f":"IF(ISBLANK(C29),\"\",C29)","v":""},"","","","","","","Project Evaluation",null,null,null,null,null,0]
[null,1,{"$f":"IF(ISBLANK(C29),\"\",C29)","v":""},"","","","","","","Project Direct",null,null,null,null,null,0]
[null,1,{"$f":"IF(ISBLANK(C29),\"\",C29)","v":""},"","","","","","","Project Subtotal",{"$f":"SUM(K29:K31)","v":0},{"$f":"SUM(L29:L31)","v":0},{"$f":"SUM(M29:M31)","v":0},0,0,0]
[null,2,{"$f":"IF(P36<>0,VLOOKUP($D$7,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,0]
[null,2,{"$f":"IF(ISBLANK(C33),\"\",C33)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D33)),$J$31,\"\")","v":""},null,null,null,null,null,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},0,0,0]
[null,2,{"$f":"IF(P40<>0,VLOOKUP($D$7,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$7,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$7,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$7,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$7,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$7,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$7,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$7,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$7,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$7,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$7,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$7,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$7,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$7,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},0,0,0]
[null,16,{"$f":"IF(P96<>0,VLOOKUP($D$7,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},0,0,0]
[null,17,{"$f":"IF(P100<>0,VLOOKUP($D$7,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},0,0,0]
[null,18,{"$f":"IF(P104<>0,VLOOKUP($D$7,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,0]
[null,18,{"$f":"IF(ISBLANK(C101),\"\",C101)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D101)),$J$31,\"\")","v":""},null,null,null,null,null,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},0,0,0]
[null,19,{"$f":"IF(P108<>0,VLOOKUP($D$7,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},0,0,0]
[null,20,{"$f":"IF(P112<>0,VLOOKUP($D$7,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,0]
[null,20,{"$f":"IF(ISBLANK(C109),\"\",C109)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D109)),$J$31,\"\")","v":""},null,null,null,null,null,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},0,0,0]
[null,21,{"$f":"IF(P116<>0,VLOOKUP($D$7,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},0,0,0]
[null,22,{"$f":"IF(P120<>0,VLOOKUP($D$7,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,0]
[null,22,{"$f":"IF(ISBLANK(C117),\"\",C117)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D117)),$J$31,\"\")","v":""},null,null,null,null,null,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},0,0,0]
[null,23,{"$f":"IF(P124<>0,VLOOKUP($D$7,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},0,0,0]
[null,24,{"$f":"IF(P128<>0,VLOOKUP($D$7,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,0]
[null,24,{"$f":"IF(ISBLANK(C125),\"\",C125)","v":""},"","","","","","",{"$f":"IF(NOT(ISBLANK(D125)),$J$31,\"\")","v":""},null,null,null,null,null,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},0,0,0]
[null,25,{"$f":"IF(P132<>0,VLOOKUP($D$7,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},0,0,0]

{"sheet":"6. WET","index":7,"n_rows":32,"n_cols":11,"rows_kept":32,"cut":false,"hidden":false,"merged":[[11,6,11,9],[25,5,25,8],[13,2,13,4],[16,2,16,4],[17,2,17,4],[14,2,14,4],[15,2,15,4],[19,2,19,4],[18,2,18,4]]}
[]
[null,{"$f":"'1. Information'!B2","v":"Version 7/1/2018"}]
[null,{"$f":"'1. Information'!B3","v":"Annual Mental Health Services Act Revenue and Expenditure Report"}]
[null,{"$f":"'1. Information'!B4","v":"Fiscal Year 2017-18"}]
[null,"Workforce Education and Training (WET) Summary"]
[]
[null,null,"County:",{"$f":"IF(ISBLANK('1. Information'!D8),\"\",'1. Information'!D8)","v":"Sierra"},null,"Date:",{"$f":"IF(ISBLANK('1. Information'!D7),\"\",'1. Information'!D7)","v":"2018-12-31"}]
[]
[null,"SECTION ONE"]
[]
[null,null,null,null,null,"A","B","C","D","E","F"]
[null,null,null,null,null,"MHSA Fund","Other Fund"]
[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,null,null,null,null,null,{"$f":"SUM(F14:J14)","v":0}]
[null,2,"WET Evaluation Costs",null,null,null,null,null,null,null,{"$f":"SUM(F15:J15)","v":0}]
[null,3,"WET Administration Costs",null,null,15547,null,null,null,null,15547]
[null,4,"WET Funds Transferred to JPA",null,null,null,null,null,null,null,0]
[null,5,"WET Expenditure Incurred by JPA",null,null,null,null,null,null,null,0]
[null,6,"WET Program Expenditures",null,null,{"$f":"SUM(E28:E32)","v":25639},{"$f":"SUM(F28:F32)","v":0},0,0,{"$f":"SUM(I28:I32)","v":0},25639]
[null,7,"Total WET Expenditures (Excluding Transfers to JPA)",null,null,{"$f":"SUM(F14:F16,F18:F19)","v":41186},{"$f":"SUM(G14:G16,G18:G19)","v":0},0,0,0,{"$f":"SUM(K14:K16,K18:K19)","v":41186}]
[]
[]
[null,"SECTION TWO"]
[]
[null,null,"A","B","C","D","E","F","G","H"]
[null,null,null,"Wet Component","MHSA Funds","Other Funds"]
[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$7,Info_County_Code,2,FALSE),\"\")","v":""},"Workforce Staffing",null,null,null,null,null,{"$f":"SUM(E28:I28)","v":0}]
[null,2,{"$f":"IF(J29<>0,VLOOKUP($D$7,Info_County_Code,2,FALSE),\"\")","v":46},"Training/Technical Assistance",25639,null,null,null,null,{"$f":"SUM(E29:I29)","v":25639}]
[null,3,{"$f":"IF(J30<>0,VLOOKUP($D$7,Info_County_Code,2,FALSE),\"\")","v":""},"MH Career Pathways",null,null,null,null,null,0]
[null,4,{"$f":"IF(J31<>0,VLOOKUP($D$7,Info_County_Code,2,FALSE),\"\")","v":""},"Residency/Internship",null,null,null,null,null,0]
[null,5,{"$f":"IF(J32<>0,VLOOKUP($D$7,Info_County_Code,2,FALSE),\"\")","v":""},"Financial Incentive",null,null,null,null,null,0]

{"sheet":"7. CFTN","index":8,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[25,7,25,10],[11,6,11,9],[0,1,0,3],[13,2,13,4],[15,2,15,4],[16,2,16,4],[17,2,17,4],[20,2,20,4],[19,2,19,4],[14,2,14,4],[18,2,18,4],[25,3,25,5]]}
[]
[null,{"$f":"'1. Information'!B2","v":"Version 7/1/2018"}]
[null,{"$f":"'1. Information'!B3","v":"Annual Mental Health Services Act Revenue and Expenditure Report"}]
[null,{"$f":"'1. Information'!B4","v":"Fiscal Year 2017-18"}]
[null,"Capital Facility Technological Needs (CFTN) Summary"]
[]
[null,"County:",null,{"$f":"IF(ISBLANK('1. Information'!D8),\"\",'1. Information'!D8)","v":"Sierra"},null,"Date:",{"$f":"IF(ISBLANK('1. Information'!D7),\"\",'1. Information'!D7)","v":"2018-12-31"}]
[]
[null,"SECTION ONE"]
[]
[null,null,null,null,null,"A","B","C","D","E","F"]
[null,null,null,null,null,"MHSA Funds","Other Fund"]
[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,null,null,null,null,null,{"$f":"SUM(F14:J14)","v":0}]
[null,2,"TN Annual Planning Costs",null,null,null,null,null,null,null,{"$f":"SUM(F15:J15)","v":0}]
[null,3,"CF Evaluation Costs",null,null,null,null,null,null,null,0]
[null,4,"TN Evaluation Costs",null,null,null,null,null,null,null,0]
[null,5,"CF Administration",null,null,null,null,null,null,null,0]
[null,6,"TN Administration",null,null,null,null,null,null,null,0]
[null,7,"CFTN Program Expenditure",null,null,{"$f":"SUM(G28:G47)","v":12519},{"$f":"SUM(H28:H47)","v":0},{"$f":"SUM(I28:I47)","v":0},{"$f":"SUM(J28:J47)","v":0},{"$f":"SUM(K28:K47)","v":0},12519]
[null,8,"Total CFTN Expenditures",null,null,{"$f":"SUM(F14:F20)","v":12519},{"$f":"SUM(G14:G20)","v":0},{"$f":"SUM(H14:H20)","v":0},0,0,{"$f":"SUM(K14:K20)","v":12519}]
[]
[null,"SECTION TWO"]
[]
[null,null,"A","B","C","D","E","F","G","H","I","J"]
[null,null,null,"CFTN Component",null,null,"MHSA Fund","Other Fund"]
[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$7,Info_County_Code,2,FALSE),\"\")","v":46},"207 Front Street - Addition to Wellness Center",null,"Capital Facility",12519,null,null,null,null,{"$f":"SUM(G28:K28)","v":12519}]
[null,2,"",null,null,null,null,null,null,null,null,{"$f":"SUM(G29:K29)","v":0}]
[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. WET RP, HP","index":9,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,1,0,3],[6,1,6,2],[11,5,11,8]]}
[]
[null,{"$f":"'1. Information'!B2","v":"Version 7/1/2018"}]
[null,{"$f":"'1. Information'!B3","v":"Annual Mental Health Services Act Revenue and Expenditure Report"}]
[null,{"$f":"'1. Information'!B4","v":"Fiscal Year 2017-18"}]
[null,"WET RP and MHSA HP Summary"]
[]
[null,"County:",null,{"$f":"IF(ISBLANK('1. Information'!D8),\"\",'1. Information'!D8)","v":"Sierra"},null,"Date:",{"$f":"IF(ISBLANK('1. Information'!D7),\"\",'1. Information'!D7)","v":"2018-12-31"}]
[]
[null,"SECTION ONE"]
[]
[null,null,"A","B","C","D","E","F","G","H"]
[null,null,null," WET RP, HP Component","MHSA Funds","Other Funds"]
[null,"#","County Code","Funding Type","Total MHSA (Including Interest)","Medi-Cal FFP","1991 Realignment","Behavioral Health Subaccount","Other","Grand Total"]
[null,1,{"$f":"IF(J14<>0,VLOOKUP($D$7,Info_County_Code,2,FALSE),\"\")","v":""},"WET Regional Partnerships (WET RP)",null,null,null,null,null,{"$f":"SUM(E14:I14)","v":0}]
[null,2,{"$f":"IF(J15<>0,VLOOKUP($D$7,Info_County_Code,2,FALSE),\"\")","v":""},"MHSA Housing Program (Unencumbered Funds)",null,null,null,null,null,{"$f":"SUM(E15:I15)","v":0}]

{"sheet":"9. Adjustment (MHSA)","index":10,"n_rows":112,"n_cols":7,"rows_kept":112,"cut":false,"hidden":false,"merged":[[6,1,6,2]]}
[]
[null,{"$f":"'1. Information'!B2","v":"Version 7/1/2018"}]
[null,{"$f":"'1. Information'!B3","v":"Annual Mental Health Services Act Revenue and Expenditure Report"}]
[null,{"$f":"'1. Information'!B4","v":"Fiscal Year 2017-18"}]
[null,"Adjustments Worksheet (MHSA)"]
[]
[null,"County:",null,{"$f":"IF(ISBLANK('1. Information'!D8),\"\",'1. Information'!D8)","v":"Sierra"},null,"Date",{"$f":"IF(ISBLANK('1. Information'!D7),\"\",'1. Information'!D7)","v":"2018-12-31"}]
[]
[null,"SECTION ONE"]
[]
[null,null,"A","B","C","D","E"]
[null,"#","County","Component","Adjustment to FY","Amount","Reason"]
[null,1,{"$f":"IF(F13<>0,VLOOKUP($D$7,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(D43:G43)),\"\",VLOOKUP(D21,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(F48<>0,VLOOKUP($D$7,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(F83<>0,VLOOKUP($D$7,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":"10. Adjustment (FFP)","index":11,"n_rows":52,"n_cols":9,"rows_kept":52,"cut":false,"hidden":false,"merged":[[6,1,6,2],[0,1,0,3]]}
[]
[null,{"$f":"'1. Information'!B2","v":"Version 7/1/2018"}]
[null,{"$f":"'1. Information'!B3","v":"Annual Mental Health Services Act Revenue and Expenditure Report"}]
[null,{"$f":"'1. Information'!B4","v":"Fiscal Year 2017-18"}]
[null,"FFP Revenue Adjustment"]
[]
[null,"County:",null,{"$f":"IF(ISBLANK('1. Information'!D8),\"\",'1. Information'!D8)","v":"Sierra"},null,"Date:",{"$f":"IF(ISBLANK('1. Information'!D7),\"\",'1. Information'!D7)","v":"2018-12-31"}]
[]
[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(I13<>0,VLOOKUP($D$7,Info_County_Code,2,FALSE),\"\")","v":""},null,null,null,null,null,{"$f":"SUM(G13:H13)","v":0}]
[null,2,"",null,null,null,null,null,{"$f":"SUM(G14:H14)","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":"11. Comments","index":12,"n_rows":47,"n_cols":3,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"'1. Information'!B2","v":"Version 7/1/2018"}]
[null,{"$f":"'1. Information'!B3","v":"Annual Mental Health Services Act Revenue and Expenditure Report"}]
[null,{"$f":"'1. Information'!B4","v":"Fiscal Year 2017-18"}]
[null,"Comments"]
[]
[null,null,"Comments"]
[null,1,"Evaluation Costs for all programs are embedded in Administration.  "]
[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":"drop down fields","index":13,"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":14,"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"]