{"text_format":"1","workbook":"xlsx","n_sheets":20,"sheets":["Instruction","Terms & Definitions","Data Source","Geographical Service Area","Geographical Service Area Tab 2","Regional Demographic Data","Prevalence MH & SUD","Stakeholder Engagement","Stakeholder Engagement Summary","Assessment of Staffing","Accessibility Availability Serv","Cultural & Linguistic","Care Coordination","SDOH","Free Response Questions","EBP Consideration","Summary Findings Nxt S ","Summary Continuation Tab","Attestation","Drop-Down List"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":3,"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":"Instruction","index":0,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[11,1,11,10],[12,1,12,10],[13,1,13,10],[14,1,14,10],[15,1,15,10],[7,1,7,4],[8,1,8,4],[9,1,9,4],[4,1,4,10],[5,1,5,4],[9,5,9,10],[8,5,8,10],[7,5,7,10],[6,5,6,10],[6,1,6,4],[2,5,2,7],[2,8,2,10],[1,1,1,10],[3,6,3,10],[5,5,5,10],[3,3,3,4],[2,2,2,4],[3,1,3,2]]}
[]
[null,"KENTUCKY CCBHC COMMUNITY NEEDS ASSESSMENT TEMPLATE"]
[null,"Clinic Name",null,null,null,"Start Date of Needs Assessment"]
[null,"Primary Contact Name",null,null,null,"Email"]
[null,"Agency Community Needs Assessment Guiding Team Members"]
[null,"Name",null,null,null,"Agency Title"]
[]
[]
[]
[]
[]
[null,"Completion of the Certified Community Behavioral Health Clinic (CCBHC) Community Needs Assessment (CNA) process is in alignment with CCBHC Criteria Program Requirement 1.a.1 as included in SAMHSA CCBHC Certification Criteria updated March 2023. Additional data points are added at the discretion of the state. Additional local or state data sources may be used in completing your CNA. The CNA process should be thoughtful, well informed and will likely take a period of three (3) to five (5) months to complete. Response to all questions included in the Free Response Tab are required.\n\nThe Completion of this Community Needs Assessment is required of all CCBHCs participating in the Kentucky CCBHC Demonstration and supports your agency’s state certification. "]
[null,"The purpose of this document is to:\n   • Inform the Staffing Plan to ensure the CCBHC maintains a core workforce comprised of employed and contracted staff for both clinical and non-clinical services provided by your agency;\n   • Ensure access and availability of services to meet the needs of the populations served;\n   • Identify outreach, engagement, and retention activities to support inclusion and access for underserved individuals and populations;\n   • Inform cultural, linguistic, physical health, and behavioral health treatment needs;\n   • Inform evidence-based practices and behavioral health crisis services; \n   • Identify potential barriers to care such as geographic barriers, transportation challenges, economic hardship, lack of culturally responsive services and workforce shortages; and\n   • Inform the agency Continuous Quality Improvement (CQI) plan and processes."]
[null,"This template provides the data points to support the completion of your comprehensive CNA and serves to record your CNA findings. The Data Source tab provides links to resources for use in completing your CNA. These links offer pertinent quantitative data essential for populating the designated tables and addressing the free response questions."]
[null,"The CNA Stakeholder Engagement document is a companion document to this template and is a resource to assist with completing your CNA."]
[null,"Disclaimer: Please note that it might be necessary to explore supplementary resources beyond the provided links to acquire qualitative and/or quantitative data requisite for completing your CNA. "]

{"sheet":"Terms & Definitions","index":1,"n_rows":34,"n_cols":2,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Definitions and Terms"]
[null,"Access to Healthcare: the lack of ability to obtain healthcare services for prevention, diagnosis, treatment, and the management of diseases, illnesses, disorders, and other health-impacting conditions."]
[null,"Agency Action Plan: Agency plan to address or remediate identified needs and barriers."]
[null,"Agency Forms: agency forms translated to accommodate specific languages"]
[null,"AMI (Any Mental Illness): Any individual having any mental, behavior, or emotional disorder in the past year that met DSM-IV criteria (excluding developmental and substance use disorders)."]
[null,"Assistive Technology: equipment, software program, or product used to improve patient communication."]
[null,"Behavioral Health: encompasses the promotion of emotional health; the prevention of mental illnesses and substance use disorders; and treatments and services for mental and/or substance use disorders."]
[null,"Bilingual Therapist: professional accommodation for linguistic characteristics including bilingual or multilingual factors for patients."]
[null,"Braille Materials: documents available by people who are visually impaired."]
[null,"Care Coordination: an activity instead of a service. Intentionally coordinating a person’s care by helping them gain access to needed supports and services. "]
[null,"Comorbidities: two disorders/Illnesses present in a person with a Serious Mental Illness (SMI) or SUD"]
[null,"Culture: a group or community, which shares common experiences that shape the way its members understand the world."]
[null,"Economic Instability: a person or family lacks the resources to provide life necessities (e.g., affordable housing, employment that provides a living wage, childcare, and access to reliable transportation)."]
[null,"Evidence-Based Practice: Treatments that are supported by clinical research."]
[null,"Food Insecurity: not having access to sufficient food or quality/notorious food to meet one’s basic needs. "]
[null,"Gender-Concordant Care: the provider of care and the patient are the same sex"]
[null,"Health Behaviors: actions taken by individuals that affect their health or mortality"]
[null,"Health Equity: the state in which everyone has a fair and just opportunity to attain their highest level of health."]
[null,"Identified Barriers: Any barriers identified as a result of stakeholder engagement activities and data analysis. "]
[null,"Identified Needs: Any needs identified as a result of stakeholder engagement activities and data analysis.   "]
[null,"Large Print Materials: printed materials in large print so a person with limited vision can read the document."]
[null,"Limited Support System: having limited or no network of family/friends or resources"]
[null,"Promote Cultural Awareness: agency ensures staff and providers can appropriately acknowledge and respond to cultural difference and needs "]
[null,"Racial/Cultural Disparity: Imbalances and/or incongruities between the treatment of racial and cultural groups"]
[null,"Religious Accommodations: agency identifies and appropriately accommodates a person’s religious beliefs."]
[null,"Serious Emotional Disturbance (SED): An individual with a designated mental illness diagnosis."]
[null,"Serious Mental illness (SMI): A mental, behavioral, or emotional disorder resulting in serious functional impairment, which substantially interferes with or limits one or more major life activities. The burden of mental illnesses is particularly concentrated among those who experience disability due to SMI."]
[null,"Social Drivers of Health (SDOH):  are the nonmedical (non-clinical) factors or conditions that influence health outcomes."]
[null,"Specific, Measurable, Achievable, Relevant, and Time-Bound (SMART Goal): list agency measurable goals for advancement in related areas."]
[null,"Staff Support: agency staff is available to assist patients with their care."]
[null,"Staff Training: staff receive training specific to identified cultures (to include appropriate staff behaviors and skills) to deliver high-quality culturally appropriate care "]
[null,"SUD (Substance use Disorder): An Individual with alcohol or illicit drug dependence or abuse."]
[null,"Telehealth/telemedicine: Includes video conferencing, digital therapeutics, remote patient monitoring, asynchronous interventions, and other technologies to the extent possible in alignment with the preferences of the person receiving services. "]

{"sheet":"Data Source","index":2,"n_rows":72,"n_cols":6,"rows_kept":72,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[]
[]
[null,"DATA RESOURCES"]
[null,"Website","Link","Data Source","Data Content","Data Type"]
[null,"2022-2023 National Survey on Drug Use and Health","https://www.samhsa.gov/data/report/2022-2023-nsduh-estimated-totals-state","SAMHSA","2022-2023 National Surveys on Drug Use and Health (NSDUH) state-level estimates for measures of both substance use and mental health, by age group.","National, State"]
[null,"2022-2023 NSDUH: Model-Based Estimated Prevalence For States","https://www.samhsa.gov/data/report/2022-2023-nsduh-state-prevalence-estimates","SAMHSA","2022-2023 National Surveys on Drug Use and Health (NSDUH) state-level  prevalence estimates for measures of both substance use and mental health, by age group.","National, State"]
[null,"America's Health Rankings","https://www.americashealthrankings.org/","United Health Foundation","Analyzes more than 340 measures of behaviors, social and economic factors, and physical environment and clinical care data, based on public-use data sets. Reports are released on key national areas of health. ","National, State"]
[null,"Appalachian Regional Commission (ARC)","https://www.arc.gov/about-the-appalachian-region/","Various government sites","Economic development partnership entity of 13 state governments focusing on 423 counties. ","County"]
[null,"Behavioral Risk Factor Surveillance System (BRFSS)","https://www.cdc.gov/brfss/brfssprevalence/index.html","BRFSS Prevalence & Trends Data","Prevalence estimates and trends of health-related risk behaviors, chronic health conditions, and use of preventive services.","National, State"]
[null,"BRFSS Selected Metropolitan/Micropolitan Area Risk Trends (SMART): City and County Data","https://data.cdc.gov/browse?category=Behavioral+Risk+Factors&sortBy=relevance&page=1&pageSize=20","CDC","Combined landline and cellphone survey data on modifiable risk factors for chronic disease and other leading causes of death in select areas.","Selected Metropolitan Statistical Areas (MMSAs)"]
[null,"BRFSS Web Enabled Analysis Tool (WEAT) ","https://nccd.cdc.gov/weat/#/","CDC","Users create custom cross-tabulation tables for health indicators.","State"]
[null,"Buprenorphine Practitioner Locator","https://www.samhsa.gov/medication-assisted-treatment/find-treatment/treatment-practitioner-locator","U.S. Substance Abuse and Mental Health Services Administration","Location and information for practitioners by city, state, or zip code who previously held a DATA-2000 waiver to prescribe Buprenorphine for the treatment of opioid use disorder.","State, Local"]
[null,"Bureau of Justice Statistics","https://bjs.ojp.gov/data/data-analysis-tools","Bureau of Justice Statistics","Range of tools providing data on people in prison, parolees and juvenile justice.","National, State, County"]
[null,"Calculator","https://www.calculator.net/average-calculator.html","Calculator","Calculator to get the average of a group of numbers."]
[null,"CARES Map","https://careshq.org/map-room/?bboxGeo=-83.51172899999995,36.66479300000003,-82.85573499999998,37.02121100000005&def={%22t11%22:%22FIPS=%2721095%27%22}&ids=39711,t11","University of Missouri Extension map","Custom assessments from civic, health, and economic indicators e.g., agricultural, environmental, opioids, food security, housing.","National, State, County"]
[null,"CDC Data, Trends, and Maps","https://dnpao-dtm.cdc.gov/","CDC","Interactive database on national, state, and county-level data about the health status and behaviors of Americans as well as environmental or policy supports.","National, State, County"]
[null,"CDC WONDER","https://wonder.cdc.gov/","CDC","Wide array of public health data","National, State, County"]
[null,"Child Trends","https://www.childtrends.org/","Child Trends","Research and data on children, youth, and special populations.","National, State, County"]
[null,"Chronic Disease Indicators","https://www.cdc.gov/cdi/","CDC","Chronic Diseases and Risk Factor Indicators","National, State and Territory"]
[null,"County Health Rankings","https://www.countyhealthrankings.org/explore-health-rankings","University of Wisconsin Population Health Institute","Health Data, evidence, guidance and examples of multiple factors influencing health. ","State, County, Zip Code"]
[null,"County Health Rankings","https://www.countyhealthrankings.org/health-data/kentucky?year=2025","University of Wisconsin Population Health Institute","Population Health and Well-being Data","National, State, County"]
[null,"County Health Rankings","https://www.countyhealthrankings.org/health-data/kentucky?measure=Population+Health+and+Well-being&year=2024","University of Wisconsin Population Health Institute","Health Outcomes Data","National, State, County"]
[null,"Data USA","https://datausa.io/profile/geo/kentucky","Data USA","Data-search and -visualization website on demographic, population, diversity, etc.","State, County"]
[null,"Data.HRSA.Gov","https://data.hrsa.gov/maps/map-tool/","Build your own map.","Select and plot facilities, providers, site/area's, and population and public health data. ","National"]
[null,"Data.HRSA.Gov","https://data.hrsa.gov/tools/data-reporting/program-data/state/KY","Various data sites","Health Center Program Uniform Data System (UDS) data tables.","National"]
[null,"Department for Behavioral Health, Developmental and Intellectual Disabilities (DBHDID) Data Reports","https://dbhdid.ky.gov/cmhc/datareports","Community Mental Health Basic Statistical  Reports","Various reports to include SUD, SED, SMI, Crisis Stabilization, Deaf and Hard of Hearing, Mental Health, etc. ","State, County"]
[null,"Drug Overdose Mortality Rates","https://www.cdc.gov/nchs/state-stats/deaths/drug-overdose.html?CDC_AAref_Val=https://www.cdc.gov/nchs/pressroom/sosmap/drug_poisoning_mortality/drug_poisoning.htm","CDC","Overdose age-adjusted mortality rates","State"]
[null,"Federal Communications Commission","https://www.fcc.gov/reports-research/maps/connect2health/map.html#ll=31.5,-96.4&z=4&t=broadband&hmt=opioid&bbm=fixed_access&dmf=none&ino=none&zlt=county","Federal Communications Commission","Interactive map linking broadband and health data","County and State"]
[null,"Health Workforce Shortage Area","https://data.hrsa.gov/topics/health-workforce/shortage-areas","U.S. Health Resources and Services Administration","Data by geographic area, population, and facility Health Professions Shortage Area (HPSA) designations for primary care, dental health and mental health. ","State, County, Local Area"]
[null,"Housing Needs By State","https://nlihc.org/housing-needs-by-state/kentucky","National Low Income Housing Coalition","Data on low-income renter households, capacity of affordable and available rental housing, household income, and percentages of cost-burdened renters.","State"]
[null,"Housing Shelter Resources","https://www.hud.gov/findshelter","U.S. Department of Housing and Urban Development","Provides information about housing, shelter, health care, food pantries, and clothing resources in communities across the country","Location, Zip Code, Key Word"]
[null,"Hunger in America","https://nihcm.org/publications/hunger-in-america","National Institute for Health Care Management Foundation","Infographic that shows the connection between food security and health.","National"]
[null,"Kaiser XX Foundation","https://www.kff.org/state-category/mental-health/","Various data sources","Various mental health and substance use indicators","State "]
[null,"Kentucky - Demographics, Analytics, Trends and Access (KDATA)","https://medicine.uky.edu/sites/default/files/2024-04/K%20DATA%20_%202024.pdf","University of Kentucky","Statewide mental health data","State, Regional, "]
[null,"Kentucky Health Map","https://www.arcgis.com/apps/webappviewer/index.html?id=f6f5da6093bb4f6ebdbee7b9140b0838","EnviroHealthLink Community Snapshot\nEnvironmental Public Health Tracking Info.\nCounty Health Rankings\nCensus Quick Facts\nSalud America! - Health Equity Report","Various data sets from Environmental Public Health Tracking, QuickFacts census counts, data on health equity, etc. ","State, County, Health Department Info, Local Health Jurisdiction"]
[null,"Kentucky Injury Prevention and Research Center (KIPRC) ","https://kiprc.uky.edu/resources","Data on injury and violence-related research, data, services, outreach, communications, interventions, evaluation techniques, and policy development, at both the state government and academic levels.","Statewide and academic level data.","State, County"]
[null,"Kids Count","https://www.aecf.org/work/kids-count","The Annie E. Casey Foundation","Data on the educational, social, economic and physical well-being of children.","National, State, Local"]
[null,"KSPAN","https://www.safekentucky.org/index.php/tbi-2","U.S. Census Bureau","Traumatic Brain Injury data","State"]
[null,"Medically Underserved Areas","https://data.hrsa.gov/tools/shortage-area/mua-find","U.S. Health Resources and Services Administration","Tool for data by geographic area, population, and facility Medically Underserved Area (MUA) or population (MUA/P) designations.","State, County, Local Area"]
[null,"Mental Health America","https://mhanational.org/mhamapping/mha-state-county-data","Various data sources","Mental health data including anxiety, depression, suicide, PTSD, trauma or psychosis","Zip code, county, state data"]
[null,"Movement Advancement Project","https://www.lgbtmap.org/equality_maps/profile_state/KY","Movement Advancement Project (MAP)","Tally and breakdown of laws and policies that support people who identify as LGBTQ+. ","State, District of Columbia, and Territory"]
[null,"Movement Advancement Project","https://www.lgbtmap.org/equality-maps/profile_state","Various data sources","Democracy, equity, and policy. LGBTQ+","State data"]
[null,"National Center for Drug Abuse Statistics","https://drugabusestatistics.org/drug-overdose-deaths/#kentucky","Various data sources","Drug overdose death rates.","National, State"]
[null,"National Center for Health Statistics","https://www.cdc.gov/nchs/fastats/adolescent-health.htm","CDC","Adolescent Health Data","State"]
[null,"National Survey of Children's Health","https://mchb.hrsa.gov/data-research/national-survey-childrens-health","U.S. Health Resources and Services Administration","Datasets and resources on household survey conducted annually that produces key measures of child health and well-being.","National, State"]
[null,"National Survey on Drug Use and Health (NSDUH)","https://www.samhsa.gov/data/data-we-collect/nsduh-national-survey-drug-use-and-health ","U.S. Substance Abuse and Mental Health Services Administration (SAMHSA)","Data on the use of tobacco, alcohol and illicit drugs; substance use disorders; receipt of substance use treatment; mental health issues; and the use of mental health services among the civilian, noninstitutionalized population aged 12 or older. ","National, State, County"]
[null,"Nutrition, Physical Activity and Obesity: Data, Trends and Maps","https://www.cdc.gov/nccdphp/dnpao/data-trends-maps","CDC","Demographic data on health status and behaviors to include fruits and vegetables, physical activity, sugar drinks, television watching, and obesity","National, State and Territory"]
[null,"Pregnancy Risk Assessment Monitoring System (PRAMS)","https://www.cdc.gov/prams/index.html","U.S. Centers for Disease Control and Prevention","Identify groups of women and infants at high risk for health problems, to monitor changes in health status, and to measure progress towards goals in improving the health of mothers and infants through ongoing, site-specific, and population-based surveillance system.","National"]
[null,"Rural Health Information Hub (RHI) ","https://www.ruralhealthinfo.org/data-explorer?state=KY","U.S. Census Small Area Income and Poverty Estimates","Wide range of data on health disparities, health workforce, demographics, etc. ","National, State, County"]
[null,"SAMHSA Data Tools","https://datatools.samhsa.gov/","SAMHSA","Various types of behavioral health data through SAMHSA data tools.","Nation, State, Regional"]
[null,"SAMHSA Interactive NSDUH State Estimates","https://datatools.samhsa.gov/saes/state","SAMHSA","Prevalence of mental illness and substance use disorders Behavioral health service provision and use Evaluation data. ","Nation, State, Regional"]
[null,"SAMHSA Uniform Reporting System (URS)","https://www.samhsa.gov/data/data-we-collect/urs-uniform-reporting-system","URS, State Mental Health agencies","Sociodemographic characteristics of clients served, outcomes of care, use of selected evidence-based practices, client assessment of care, insurance status, living situation, employment status, and readmission to psychiatric hospitals","National, State"]
[null,"State Health Facts","https://www.kff.org/statedata/","Kaiser Family Foundation (KFF)","More than 800 health indicators from insurance status, population demographics, chronic disease(s), birth, death, mental health and substance use disorders, etc. ","National, State"]
[null,"State Unintentional Drug Overdose Reporting System (SUDORS) Dashboard: Fatal Overdose Data ","https://www.cdc.gov/overdose-prevention/data-research/facts-stats/sudors-dashboard-fatal-overdose-data.html?CDC_AAref_Val=https://www.cdc.gov/drugoverdose/fatal/dashboard","CDC","Unintentional and undetermined intent drug overdose deaths collected from death certificates and medical examiner or coroner reports (including scene findings, autopsy reports, and full postmortem toxicology findings).","National, State"]
[null,"Statistical Atlas","https://statisticalatlas.com/state/Kentucky/Population","Florida Atlantic University using U.S. Census Bureau data","Detailed demographic information on race, ethnicity, ancestry, income, employment, educational attainment, etc.","National, State, and County"]
[null,"Suicide Mortality Rates","https://www.cdc.gov/nchs/pressroom/sosmap/suicide-mortality/suicide.htm","CDC","Suicide age-adjusted death rates","State"]
[null,"The Housing and Transportation (H+T)  Affordability Index","https://htaindex.cnt.org/","The Center for Neighborhood Technology","Housing and transportation data using a cost model and drawing from national census, employer-household and transit data. ","Regional, Local"]
[null,"The Trevor Project","https://www.thetrevorproject.org/survey-2023/","Survey Data","National Survey on LGBTQ Youth Mental Health","National"]
[null,"The Trevor Project","https://www.thetrevorproject.org/survey-2021/?section=SuicideMentalHealth","Survey Data","National Survey on LGBTQ Youth Mental Health","National"]
[null,"The Trevor Project","https://www.thetrevorproject.org/wp-content/uploads/2022/12/The-Trevor-Project-2022-National-Survey-on-LGBTQ-Youth-Mental-Health-by-State-Kentucky.pdf","Survey Data","National Survey on LGBTQ Youth Mental Health","State"]
[null,"T-MSIS Substance Use Disorder (SUD) Data Book: Treatment of SUD in Medicaid, 2019","https://www.medicaid.gov/medicaid/data-systems/macbis/medicaid-chip-research-files/transformed-medicaid-statistical-information-system-t-msis-analytic-files-taf#pbhi","U.S. Health and Human Services","Several data sources tailored for a broad research of Medicaid and CHIP data user community.","State "]
[null,"U.S. Census Bureau","https://data.census.gov/all?q=kentucky","U.S. Census Bureau","Demographics survey with tables, such as (selected) social characteristics, housing characteristics, economic characteristics, and demographic and housing estimates.","National, State, County, Census Tract, Zip Code"]
[null,"U.S. Census Bureau","https://www.census.gov/programs-surveys/acs/data.html","American Community Survey ","Data Profiles with social, economic, housing, and demographic data for a single geographic area. The Data Profiles summarize the data, providing both estimates and percentages, to cover the most basic data on all American Community Survey topics. ","Geographic, State, National"]
[null,"U.S. Census Bureau","https://www.census.gov/quickfacts/fact/table/KY,US/PST045224","U.S. Census Bureau","Demographics from the U.S. Census.","National, State, County, City, and Town (populations of 5,000 or more)"]
[null,"U.S. Department of Veterans Affair","https://www.mentalhealth.va.gov/about/index.asp","U.S. Department of Veterans Affair","Mental health, suicide  data reporting","National, State"]
[null,"United States Census Bureau","https://data.census.gov/profile/Kentucky?g=040XX00US21","United States Census Bureau","Demographic and population data on income, education, housing, employment, veteran status","National, State, County"]
[null,"United States Zip Codes","https://www.unitedstateszipcodes.org/ky/","United States Zip Codes","ZIP Codes and Counties in Kentucky","National, State, County, Zip Code"]
[null,"University of Louisville, Kentucky State Data Center","https://centers.louisville.edu/kentucky-state-data-center","U.S. Census Bureau with federal-state cooperative program","Data Center at the University of Louisville is Kentucky's lead agency in the United States Census Bureau's State Data Center Program.","County and State data"]
[null,"USDA Economic Research Service U.S. Department of Agriculture","https://www.ers.usda.gov/topics/food-nutrition-assistance/food-security-in-the-u-s/key-statistics-graphics/","U.S. Department of Agriculture","Information on food security, food and nutrition assistance food security's effect on the well-being of children, adults, families and communities; food security's relationship to public policies, public assistance programs and the economy.\nin U.S. households","National, State"]
[null,"Web-based Injury Statistics Query and Reporting System (WISQARS)","https://www.cdc.gov/injury/wisqars/","CDC","Data on fatal and nonfatal injury, violent death, and cost of injury.","National, Region, State"]
[null,"Williams Institute LGBT Data and Demographic","https://williamsinstitute.law.ucla.edu/visualization/lgbt-stats/?topic=LGBT#density","Various data sources"," LGBT Data and Demographic","National, State"]
[null,"Youth Risk Behavioral Surveillance System (YRBSS)","https://www.cdc.gov/healthyyouth/data/yrbs/","CDC","A set of surveys that track behaviors that can lead to poor health in students grades 9 through 12.","National, State, and Local School Districts"]

{"sheet":"Geographical Service Area","index":3,"n_rows":31,"n_cols":8,"rows_kept":31,"cut":false,"hidden":false,"merged":[[33,1,33,7],[18,1,18,7],[0,1,0,2],[1,1,1,7],[32,1,32,6],[2,1,2,7],[3,1,3,7],[4,1,4,7],[5,1,5,6],[19,1,19,7],[17,1,17,7]]}
[]
[null,"GEOGRAPHICAL SERVICE AREA"]
[null,"Having an understanding of the geographical distribution of behavioral health needs and resources within the community is crucial for a CCBHC. This information enables effective resource allocation, precise targeting of interventions, the identification of disparities, and ensuring the CCBHC can provide equitable and impactful services to all segments of the community."]
[null," Provide the required information in Table 1 and Table 2 relative to all agency service sites (CCBHC state-certified and non state-certified), including any contracted Designated Collaborating Organizations, (DCO), (if applicable). "]
[null,"Instructions: Table 1: In Column 1, please provide the Department of Medicaid Services (DMS) location identifier (if applicable), as well as all other requested information. If additional space is needed, please use the \"Geographical Service Area Tab 2\". For your convenience, a link to the United States Zip Codes is provided in the Data Source Tab. \nSee \"Free Response Tab\" for additional Geographical Service Area information required.\n\nIf your agency has more than ten(10) provider and/or DCO sites, please provide additional site information in the Geographical Service Area Tab 2. "]
[null,"Table 1: Provider CCBHC Site Information"]
[null,"DMS Location Identifier, if applicable ","Provider Site Address","Hours of Operation \n(include after hours and weekends)","List County(s) Served\n(box will expand to accommodate multiple counties)","Is this location CCBHC State Certified: \nSelect Y or N","List Zip Codes Served\n(box will expand to accommodate multiple ZIP codes)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Instructions: Table 2, provide all requested information. If additional space is needed, please use the \"Geographical Boundaries Tab 2\". In the Contracted Core Services(s), you may select more than one core service from the drop-down list.\n                                                                                                                                                                                                                          \nNote: CCBHC criteria (updated March 2023) requires the CCBHC to deliver the majority of services by volume  (51% or more) across all service categories (excluding Crisis Services)."]
[null,"Table 2: DCO Site Information"]
[null,"DCO Provider Name","DCO Location Address","Hours of Operation    \n(include after hours and weekends)","List County(s) Served\n(box will expand to accommodate multiple counties)","Select the Contracted Core Service(s) Provided by this DCO\n(box will expand to accommodate multiple Core Service Selection)","List Zip Codes Served\n(box will expand to accommodate multiple ZIP codes)","Percentage of expected overall CCBHC Service Delivery"]
[null,null,null,null,null,null,null,"%"]
[null,null,null,null,null,null,null,"%"]
[null,null,null,null,null,null,null,"%"]
[null,null,null,null,null,null,null,"%"]
[null,null,null,null,null,null,null,"%"]
[null,null,null,null,null,null,null,"%"]
[null,null,null,null,null,null,null,"%"]
[null,null,null,null,null,null,null,"%"]
[null,null,null,null,null,null,null,"%"]
[null,null,null,null,null,null,null,"%"]

{"sheet":"Geographical Service Area Tab 2","index":4,"n_rows":28,"n_cols":8,"rows_kept":28,"cut":false,"hidden":false,"merged":[[3,1,3,6],[16,1,16,7],[1,1,1,6]]}
[]
[null,"GEOGRAPHICAL SERVICE AREA TAB 2"]
[]
[null,"Table 1: Provider CCBHC Site Information"]
[null,"DMS Location Identifier, \nif applicable ","Provider Site Address","Hours of Operation \n(include after hours and weekends)","List County(s) Served\n(box will expand to accommodate multiple counties)","Is this location CCBHC State Certified: \nSelect Y or N","List Zip Codes Served\n(box will expand to accommodate multiple ZIP codes)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Table 2: DCO Site Information"]
[null,"DCO Provider Name","DCO Location Address","Hours of Operation    \n(include after hours and weekends)","List County(s) Served\n(box will expand to accommodate multiple counties)","Select the Contracted Core Service(s) Provided by this DCO\n(box will expand to accommodate multiple Core Service Selection)","List Zip Codes Served\n(box will expand to accommodate multiple ZIP codes)","Percentage of expected overall CCBHC Service Delivery"]
[null,null,null,null,null,null,null,"%"]
[null,null,null,null,null,null,null,"%"]
[null,null,null,null,null,null,null,"%"]
[null,null,null,null,null,null,null,"%"]
[null,null,null,null,null,null,null,"%"]
[null,null,null,null,null,null,null,"%"]
[null,null,null,null,null,null,null,"%"]
[null,null,null,null,null,null,null,"%"]
[null,null,null,null,null,null,null,"%"]
[null,null,null,null,null,null,null,"%"]

{"sheet":"Regional Demographic Data","index":5,"n_rows":103,"n_cols":25,"rows_kept":103,"cut":false,"hidden":false,"merged":[[65,25,72,25],[1,1,1,24],[64,25,64,28],[2,1,2,24],[3,1,3,24],[53,1,53,4],[7,1,7,15],[67,1,67,23]]}
[]
[null,"REGIONAL DEMOGRAPHICS DATA"]
[null,"Understanding the demographic profile of your service area is essential for tailoring behavioral health services to meet the unique needs of the community you serve. This data supports the identification of specific population groups that may require specialized support and ensures the services are inclusive and responsive to the diversity of the community. Capturing demographic data within your service area is essential to tailoring CCBHC services, allocating resources effectively, addressing disparities, and to ultimately improve the accessibility and quality of care for people receiving CCBHC services."]
[null," Instructions: The table below captures demographic information for all populations within your service area. Please update the \"County\" column headers with the names of all counties in your service area. \nNote: For the \"Population Total\", provide the population for each \"County\" and \"Statewide Total.\" (A link is provided in the \"Data Source\" tab for this information.) The \"Service Area Population Total\" will auto populate. When entering Statewide Total the average of \"Service Area\" box will auto populate.\n\n**If the \"Service Area Population\" total does not auto populate, you can calculate the overall total of service area population by adding the sum of all the County totals and including this total in the \"Service Area Population.\nIf the \"Average of Service Area to Statewide Totals\" box does not auto populate, you can calculate this average by dividing the \"Service Area Population Total\" by the \"Statewide Total\" to obtain this percentage.\n\nSee \"Free Response Questions\" Tab for additional Demographics information required. Include assessment of all positive and/or negative trends identified. \n\nThe data needed to complete the below requested information does not come from your E.H.R. or internal data sources. This information will be obtained from applicable links contained in the \"Data Source\" tab. The Data Source tab has a list of data resources with source, content, and data type to help complete this section. Please complete this section in its entirety. You may use estimated 2022 data for completion of this table. "]
[null,"Table 3: CCBHC Service Area Demographics Data"]
[null,null,"County 1","County 2","County 3","County 4","County 5","County 6","County 7","County 8","County 9","County 10","County 11","County 12","County 13","County 14","County 15","County 16","County 17","County 18","County 19","County 20","Service Area Population Total","Statewide Total \n(obtain from Data Source)","Average (%) of service area to statewide totals"]
[null,"Population total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C7:V7)","v":0},4526154,{"$f":"AVERAGE(W7/X7)","v":0}]
[]
[null,"Gender Assigned at Birth"]
[null,"Male",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(C10:V10)","v":{"$error":"#DIV/0!"}},0.495]
[null,"Female",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(C11:V11)","v":{"$error":"#DIV/0!"}},0.505]
[null,"Age "]
[null,"Persons under 18 years old",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C13:V13)","v":0},1011480]
[null,"Adult: 18 - 64 years old",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"X7-X15","v":3769715}]
[null,"Senior: 65+",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C15:V15)","v":0},756439]
[null,"Race and Hispanic Origin"]
[null,"White alone  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(C17:V17)","v":{"$error":"#DIV/0!"}},0.86899999999999999]
[null,"Black or African American alone  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},8.6999999999999994E-2]
[null,"American Indian and Alaska Native alone  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},3.0000000000000001E-3]
[null,"Asian  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},1.7999999999999999E-2]
[null,"Native Hawaiian and Other Pacific Islander  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},0.01]
[null,"Two or More Races  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},2.3E-2]
[null,"Hispanic or Latino  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},4.2999999999999997E-2]
[null,"White alone, not Hispanic or Latino ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},0.83199999999999996]
[null,"Other identified Ethnicity within your E.H.R. (Insert name)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},0]
[null,"Underserved Populations"]
[null,"Veterans ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},244703]
[null,"Homeless",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},3984]
[null,"Unsheltered",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},1084]
[null,"Emergency Shelter",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},2410]
[null,"Veteran Households",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},324]
[null,"Transitional Housing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},490]
[null,"LGBTQA+ ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},0.105]
[null,"Transgender",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},5.1000000000000004E-3]
[null,"Persons with disability, under the age of 65 years, 2018-2022",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},0.13300000000000001]
[null,"Internet/Broadband Access"]
[null,"Households with a broadband internet subscription ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},0.85599999999999998]
[null,"Households, 2018-2022 ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},0.91600000000000004]
[null,"Education"]
[null,"No High School Diploma ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},0.109]
[null,"High School Diploma ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},0.89100000000000001]
[null,"Bachelors Degree or higher",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},0.34300000000000003]
[null,"Household Income, Health Insurance, and Poverty"]
[null,"Median household income, $ amount",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},75149]
[null,"Average Persons per household (Insert number)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},2.57]
[null,"Person's in poverty",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},0.115]
[null,"Persons without health insurance, under the age of 65 years",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},9.2999999999999999E-2]
[null,"Language Spoken at Home"]
[null,"English ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},0.94099999999999995]
[null,"Spanish ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},2.8000000000000001E-2]
[null,"Asian and Pacific Islander Language",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},0.01]
[null,"Other Language (Please insert, if applicable) Statewide Indo-European Language",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},1.4999999999999999E-2]
[null,"Other Language (Please insert, if applicable) ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},7.0000000000000001E-3]
[null,"Frequent Suicidal Ideation Rates by County and Poor Mental Health in Service Area"]
[null,"Number of Individuals Reporting Frequent Suicidal Ideation (per 100,000 of County Population)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},171]
[null,"Percent of adults reporting poor mental health for 14 or more of the last 30 days",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},0.161]
[null,"Percent of adults reporting poor physical health for 14 or more of the last 30 days",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},0.219]
[null,"Employment Status"]
[null,"Armed Forces ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},34457]
[null,"Employed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},0.56799999999999995]
[null,"Unemployed ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},4.2999999999999997E-2]
[null,"Transportation "]
[null,"Patients who do not have access to transportation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},0.23200000000000001]
[null,"Food Insecurity "]
[null,"Patients reporting lack of access to healthy foods",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},0.14399999999999999]
[null,"Suicide Deaths"]
[null,"Average Deaths per 100,000 population across regional counties",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},0.17899999999999999]
[null,"Instructions: The table below captures information related to your 2021 Community Needs Assessment. Please update the “clients served” (highlighted in grey) for each diagnosis. The remaining cells will auto calculate. \n\nNote: If the cells below do not auto calculate here is the methodology used:\nMethodology:\nFor SMI, an estimated 23.77% of Kentucky adults have experienced any mental illness in the past 12 months (NSDUH). This estimate was used as proxy to measure behavioral health need among the adult population in each county. To calculate the overall penetration rate, the total number of adult clients who received behavioral health services at the CMHC was divided by the total number of adults estimated to have a behavioral health need.\n\n\n"]
[null,"Serious Mental Illness (SMI) - Overall penetration"]
[null,"Estimated Adult Census",{"$f":"C14+C15","v":0},{"$f":"D14+D15","v":0},{"$f":"E14+E15","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C70:V70)","v":0},{"$f":"X7","v":4526154}]
[null,"Estimated SMI Prevalence 23.77%",{"$f":"SUM(C70*0.2377)","v":0},{"$f":"SUM(D70*0.2377)","v":0},{"$f":"SUM(E70*0.2377)","v":0},{"$f":"SUM(F70*0.2377)","v":0},{"$f":"SUM(G70*0.2377)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C71:V71)","v":0},{"$f":"X70*0.2377","v":1075866.8058}]
[null,"Number of BH Clients Served",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C72:V72)","v":0},{"$f":"X71*0.2377","v":255733.53973865998}]
[null,"Penetration Rate (%)",{"$f":"SUM(C72/C71)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D72/D71)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(M72/M71)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(N72/N71)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(R72/R71)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"AVERAGEIF(C73:V73, \">0\")","v":{"$error":"#DIV/0!"}},0.23769999999999999]
[null,"Serious Mental Illness (SMI) Penetration by Race and Ethnicity "]
[null,"White alone  ",{"$f":"SUM(C17*0.2377)","v":0},{"$f":"SUM(D17*0.2377)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AVERAGEIF(C75:V75,\">0\")","v":{"$error":"#DIV/0!"}},{"$f":"X17*0.2377","v":0.2065613}]
[null,"Black or African American alone  ",{"$f":"SUM(C18*0.2377)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AVERAGEIF(C76:V76,\">0\")","v":{"$error":"#DIV/0!"}},{"$f":"X18*0.2377","v":2.0679899999999998E-2}]
[null,"American Indian and Alaska Native alone  ",{"$f":"SUM(C19*0.2377)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},7.1310000000000004E-4]
[null,"Asian  ",{"$f":"SUM(C20*0.2377)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},4.2785999999999996E-3]
[null,"Native Hawaiian and Other Pacific Islander  ",{"$f":"SUM(C21*0.2377)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},2.3770000000000002E-3]
[null,"Two or More Races  ",{"$f":"SUM(C22*0.2377)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},5.4670999999999999E-3]
[null,"Hispanic or Latino  ",{"$f":"SUM(C23*0.2377)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},1.0221099999999999E-2]
[null,"White alone, not Hispanic or Latino ",{"$f":"SUM(C24*0.2377)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},0.19776639999999998]
[null,"Other identified Ethnicity within your E.H.R. (Insert name)",{"$f":"SUM(C25*0.2377)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},{"$f":"W25*0.2377","v":{"$error":"#DIV/0!"}}]
[null,"Serious Mental Illness (SMI)"]
[null,"Estimated Adult Census",{"$f":"C14+C15","v":0},{"$f":"D14+D15","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C85:V85)","v":0},4526154]
[null,"Estimated SMI Prevalence 7.08%",{"$f":"C85*0.0708","v":0},{"$f":"D85*0.0708","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C86:V86)","v":0},{"$f":"X85*0.0708","v":320451.70319999999}]
[null,"Number of SMI Clients Served",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"X86*0.0708","v":22687.980586559999}]
[null,"Penetration Rate (%)",{"$f":"C87/C86","v":{"$error":"#DIV/0!"}},{"$f":"D87/D86","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"AVERAGEIF(C88:V88,\">0\")","v":{"$error":"#DIV/0!"}},{"$f":"X87/X86","v":7.0800000000000002E-2}]
[null,"Serious Emotional Disturbance (SED)"]
[null,"Estimated Child Census",{"$f":"SUM(C14+C15)","v":0},{"$f":"SUM(D14+D15)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C90:V90)","v":0},1011480]
[null,"Estimated SED Prevalence 8%",{"$f":"SUM(C90*0.08)","v":0},{"$f":"SUM(D90*0.08)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C91:V91)","v":0},{"$f":"X90*0.08","v":80918.400000000009}]
[null,"Number of SED Clients Served",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,22621]
[null,"Penetration Rate",{"$f":"C92/C91","v":{"$error":"#DIV/0!"}},{"$f":"D92/D91","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"AVERAGEIF(C93:V93,\">0\")","v":{"$error":"#DIV/0!"}},{"$f":"SUM(X92/X91)","v":0.27955322893186219}]
[null,"Substance Use Disorder (SUD), Adult"]
[null,"Estimated Adult Census",{"$f":"C14+C15","v":0},{"$f":"D14+D15","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C95:V95)","v":0},4526154]
[null,"Estimated Adult SUD Prevalence 17.41%",{"$f":"C95*0.1741","v":0},{"$f":"D95*0.1741","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C96:V96)","v":0},{"$f":"X95*0.1741","v":788003.41139999998}]
[null,"Number of SUD Adult Clients Served",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C97:V97)","v":0},{"$f":"X96*0.1741","v":137191.39392474}]
[null,"Penetration Rate",{"$f":"C97/C96","v":{"$error":"#DIV/0!"}},{"$f":"D97/D96","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"AVERAGEIF(C98:V98,\">0\")","v":{"$error":"#DIV/0!"}},{"$f":"X97/X96","v":0.1741}]
[null,"Substance Use Disorder (SUD), Youth (12-17)"]
[null,"Youth Census (12-17)",{"$f":"C13","v":0},{"$f":"D13","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AVERAGE(C100:V100)","v":0},1011480]
[null,"Estimated Youth SUD Prevalence 8.40%",{"$f":"C100*0.084","v":0},{"$f":"D100*0.084","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"X100*0.084","v":84964.32}]
[null,"Number of SUD Youth Clients Served",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$f":"X101*0.084","v":7137.0028800000009}]
[null,"Penetration Rate",{"$f":"C102/C101","v":{"$error":"#DIV/0!"}},{"$f":"D102/D101","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"AVERAGEIF(C103:V103,\">0\")","v":{"$error":"#DIV/0!"}},{"$f":"X102/X101","v":8.4000000000000005E-2}]

{"sheet":"Prevalence MH & SUD","index":6,"n_rows":110,"n_cols":9,"rows_kept":110,"cut":false,"hidden":false,"merged":[[1,9,7,9],[15,1,15,8],[16,1,16,8],[17,1,17,8],[7,7,7,8],[7,5,7,6],[8,3,8,4],[9,3,9,4],[10,3,10,4],[11,3,11,4],[13,5,13,6],[9,7,9,8],[10,7,10,8],[11,7,11,8],[12,7,12,8],[13,3,13,4],[8,7,8,8],[8,5,8,6],[10,1,10,2],[11,1,11,2],[7,3,7,4],[8,1,8,2],[2,12,3,12],[35,3,35,4],[30,3,30,4],[31,3,31,4],[109,6,109,7],[108,6,108,7],[34,3,34,4],[33,3,33,4],[32,3,32,4],[34,7,34,8],[32,7,32,8],[33,5,33,6],[33,7,33,8],[31,7,31,8],[30,7,30,8],[31,5,31,6],[34,5,34,6],[40,1,40,8],[34,1,34,2],[30,1,30,2],[25,1,25,8],[6,1,6,8],[2,1,2,8],[18,3,18,4],[21,7,21,8],[24,5,24,6],[23,5,23,6],[24,1,24,2],[23,1,23,2],[22,1,22,2],[21,1,21,2],[20,1,20,2],[19,1,19,2],[22,5,22,6],[24,7,24,8],[23,7,23,8],[22,7,22,8],[24,3,24,4],[23,3,23,4],[22,3,22,4],[21,3,21,4],[20,3,20,4],[21,5,21,6],[20,5,20,6],[20,7,20,8],[0,1,0,2],[19,3,19,4],[19,5,19,6],[9,5,9,6],[10,5,10,6],[11,5,11,6],[9,1,9,2],[1,1,1,8],[3,1,3,8],[4,1,4,8],[12,5,12,6],[19,7,19,8],[13,7,13,8],[13,1,13,2],[12,1,12,2],[12,3,12,4],[18,5,18,6],[18,7,18,8],[5,1,5,8],[107,6,107,7],[108,2,108,3],[106,6,106,7],[105,6,105,7],[104,6,104,7],[103,6,103,7],[102,6,102,7],[101,6,101,7],[107,4,107,5],[106,4,106,5],[105,4,105,5],[103,4,103,5],[106,2,106,3],[105,2,105,3],[103,2,103,3],[102,2,102,3],[101,2,101,3],[109,4,109,5],[108,4,108,5],[102,4,102,5],[101,4,101,5],[104,4,104,5],[104,2,104,3],[100,4,100,5],[99,4,99,5],[98,4,98,5],[107,2,107,3],[99,2,99,3],[98,2,98,3],[109,2,109,3],[100,2,100,3],[96,2,96,7],[61,2,61,4],[97,2,97,3],[100,6,100,7],[99,6,99,7],[98,6,98,7],[97,6,97,7],[95,1,95,7],[94,1,94,8],[78,2,78,4],[78,6,78,8],[97,4,97,5],[77,1,77,8],[69,6,69,8],[65,6,65,8],[76,1,76,8],[61,6,61,8],[79,2,79,4],[79,6,79,8],[60,2,60,4],[60,6,60,8],[59,1,59,8],[26,1,26,8],[29,3,29,4],[33,1,33,2],[31,1,31,2],[32,1,32,2],[38,1,38,8],[35,7,35,8],[35,1,35,2],[43,2,43,4],[43,6,43,8],[42,6,42,8],[42,2,42,4],[58,1,58,8],[25,12,26,12],[40,10,41,20],[39,1,39,8],[29,5,29,6],[29,7,29,8],[37,1,37,8],[27,1,27,8],[35,5,35,6],[32,5,32,6],[30,5,30,6]]}
[]
[null,"PREVALENCE OF MENTAL HEALTH AND SUBSTANCE USE DISORDER(S)"]
[null,"Understanding the occurrence of mental health and substance use conditions in your service area is essential to identifying the most crucial behavioral health needs. By examining pertinent behavioral health data, the CCBHC can focus their services accordingly."]
[null,"*Data for this table may be obtained from your agency's electronic health record (EHR) as well as stakeholder engagement activities* "]
[null,"Instructions: Utilize agency-specific data to identified the primary behavioral health diagnoses identified from the last three (3) consecutive calendar years e.g., Years 1 (2021). The Primary Behavioral Health Diagnoses should be documented broadly not specifically (e.g., depressive disorders, mood [affective] disorders, anxiety, etc.) Please update the column headers to reflect the years reported.\nSee\" Free Response Questions\" Tab for additional \"Prevalence of Mental Health and Substance Use\" information required."]
[null,"*Data for this table may be obtained from your agency EHR as well as stakeholder engagement activities* "]
[null,"Table 4: Primary Behavioral Health Diagnoses"]
[null,null,null,"Year 1 (2021)",null,"Year 2 (2022)",null,"Year 3 (2023)"]
[null,"Primary Behavioral Health Diagnoses",null,"Total % of your service population",null,"Total % of your service population",null,"Total % of your service population"]
[]
[]
[]
[]
[]
[]
[null,"Instructions: For this table, utilize agency-specific data to identify the primary substances associated with substance use disorder from the last three (3) consecutive calendar years e.g., Years 1 (2021). The Substances Associated with Substance Use Disorder should be documented broadly not specifically (e.g., alcohol, opioids, stimulants, etc.) Please update the column headers to reflect the years reported."]
[null,"*Data for this table may be obtained from your agency EHR as well as stakeholder engagement activities* "]
[null,"Table 5: Substances Associated with Substance Use Disorder "]
[null,null,null,"Year 1 (XXXX)",null,"Year 2 (XXXX)",null,"Year 3 (XXXX)"]
[null,"Substances Associated with Substance Use Disorders",null,"Total % of your service population",null,"Total % of your service population",null,"Total % of your service population"]
[]
[]
[]
[]
[]
[]
[null,"Instructions: For this table, utilize agency-specific data to list the primary comorbid conditions identified from the last three consecutive calendar years e.g., Years 1 (2021). Please update the column headers to reflect the years reported.\n\nComorbid conditions definition: two disorders/Illnesses present in a person with a Serious Mental Illness (SMI) or SUD (including physical conditions.)"]
[null,"*Data for this table may be obtained from your agency EHR as well as stakeholder engagement activities* "]
[null,"Table 6: Comorbidities"]
[null,null,null,"Year 1 (XXXX)",null,"Year 2 (XXXX)",null,"Year 3 (XXXX)"]
[null,"Comorbidities",null,"Total % of people within your service area",null,"Total % of people within your service area",null,"Total % of people within your service area"]
[]
[null,2]
[null,3]
[null,4]
[null,5]
[]
[null,"Instructions: Table 7 will calculate your overall behavioral health penetration rates for each of the last three calendar years. By entering the total number of people served for each population, this table will calculate your overall penetration rates. \n\nThe total population should be obtained from the \"Regional Demographics Tab\" and entered into the total population cell. Please update the column headers to reflect the years reported. \n\nNote: If the cells in Table 7 do not auto populate the \"Overall Percent of Service Area Population\", you may calculate this number by dividing the sum of people served by the total population.\n\nSerious Mental illness (SMI): A mental, behavioral, or emotional disorder resulting in serious functional impairment, which substantially interferes with or limits one or more major life activities. \nSerious Emotional Disturbance (SED): An individual with a designated mental illness diagnosis.\nSubstance Use Disorder (SUD): An Individual with alcohol or illicit drug dependence or abuse."]
[null,"*Data for this table may be obtained from your agency EHR as well as stakeholder engagement activities* "]
[null,"Table 7: Current Consecutive Behavioral Health Penetration Rates"]
[null,"Year 1 (2021)"]
[]
[null,"Total Population",0]
[null,null,"# of People Served",null,null,null,"Overall % of Service Area Population"]
[null,"Gender","SMI","SED","SUD",null,"SMI","SED","SUD"]
[null,"Female",0,0,0,null,{"$f":"C46/C43","v":{"$error":"#DIV/0!"}},{"$f":"D46/C43","v":{"$error":"#DIV/0!"}},{"$f":"E46/C43","v":{"$error":"#DIV/0!"}}]
[null,"Male",0,0,0,null,{"$f":"C47/C43","v":{"$error":"#DIV/0!"}},{"$f":"D47/C43","v":{"$error":"#DIV/0!"}},{"$f":"E47/C43","v":{"$error":"#DIV/0!"}}]
[null,"Age"]
[null,"Age Group 0-17 ",0,0,0,null,{"$f":"C49/C43","v":{"$error":"#DIV/0!"}},{"$f":"D49/C43","v":{"$error":"#DIV/0!"}},{"$f":"E49/C43","v":{"$error":"#DIV/0!"}}]
[null,"Age Group 18 - 64 ",0,0,0,null,{"$f":"SUM(C50/C43)","v":{"$error":"#DIV/0!"}},{"$f":"D50/C43","v":{"$error":"#DIV/0!"}},{"$f":"E50/C43","v":{"$error":"#DIV/0!"}}]
[null,"Age Group 65+ ",0,0,0,null,{"$f":"C51/C43","v":{"$error":"#DIV/0!"}},{"$f":"D51/C43","v":{"$error":"#DIV/0!"}},{"$f":"E51/C43","v":{"$error":"#DIV/0!"}}]
[null,"Race/Ethnicity"]
[null,"White",0,0,0,null,{"$f":"C53/C43","v":{"$error":"#DIV/0!"}},{"$f":"D53/C43","v":{"$error":"#DIV/0!"}},{"$f":"E53/C43","v":{"$error":"#DIV/0!"}}]
[null,"Black",0,0,0,null,{"$f":"C54/C43","v":{"$error":"#DIV/0!"}},{"$f":"D54/C43","v":{"$error":"#DIV/0!"}},{"$f":"E54/C43","v":{"$error":"#DIV/0!"}}]
[null,"Asian",0,0,0,null,{"$f":"C55/C43","v":{"$error":"#DIV/0!"}},{"$f":"D55/C43","v":{"$error":"#DIV/0!"}},{"$f":"E55/C43","v":{"$error":"#DIV/0!"}}]
[null,"Hispanic",0,0,0,null,{"$f":"C56/C43","v":{"$error":"#DIV/0!"}},{"$f":"D56/C43","v":{"$error":"#DIV/0!"}},{"$f":"E56/C43","v":{"$error":"#DIV/0!"}}]
[null,"Other",0,0,0,null,{"$f":"C57/C43","v":{"$error":"#DIV/0!"}},{"$f":"D57/C43","v":{"$error":"#DIV/0!"}},{"$f":"E57/C43","v":{"$error":"#DIV/0!"}}]
[]
[null,"Year 2 (XXXX)"]
[]
[null,"Total Population",0]
[null,null,"# of People Served",null,null,null,"Overall % of Service Area Population"]
[null,"Gender","SMI","SED","SUD",null,"SMI","SED","SUD"]
[null,"Female",0,0,0,null,{"$f":"C64/C61","v":{"$error":"#DIV/0!"}},{"$f":"D64/C61","v":{"$error":"#DIV/0!"}},{"$f":"E64/C61","v":{"$error":"#DIV/0!"}}]
[null,"Male",0,0,0,null,{"$f":"C65/C61","v":{"$error":"#DIV/0!"}},{"$f":"D65/C61","v":{"$error":"#DIV/0!"}},{"$f":"E65/C61","v":{"$error":"#DIV/0!"}}]
[null,"Age"]
[null,"Age Group 0-17 ",0,0,0,null,{"$f":"C67/C61","v":{"$error":"#DIV/0!"}},{"$f":"D67/C61","v":{"$error":"#DIV/0!"}},{"$f":"E67/C61","v":{"$error":"#DIV/0!"}}]
[null,"Age Group 18 - 64 ",0,0,0,null,{"$f":"SUM(C68/C61)","v":{"$error":"#DIV/0!"}},{"$f":"D68/C61","v":{"$error":"#DIV/0!"}},{"$f":"E68/C61","v":{"$error":"#DIV/0!"}}]
[null,"Age Group 65+ ",0,0,0,null,{"$f":"C69/C61","v":{"$error":"#DIV/0!"}},{"$f":"D69/C61","v":{"$error":"#DIV/0!"}},{"$f":"E69/C61","v":{"$error":"#DIV/0!"}}]
[null,"Race/Ethnicity"]
[null,"White",0,0,0,null,{"$f":"C71/C61","v":{"$error":"#DIV/0!"}},{"$f":"D71/C61","v":{"$error":"#DIV/0!"}},{"$f":"E71/C61","v":{"$error":"#DIV/0!"}}]
[null,"Black",0,0,0,null,{"$f":"C72/C61","v":{"$error":"#DIV/0!"}},{"$f":"D72/C61","v":{"$error":"#DIV/0!"}},{"$f":"E72/C61","v":{"$error":"#DIV/0!"}}]
[null,"Asian",0,0,0,null,{"$f":"C73/C61","v":{"$error":"#DIV/0!"}},{"$f":"D73/C61","v":{"$error":"#DIV/0!"}},{"$f":"E73/C61","v":{"$error":"#DIV/0!"}}]
[null,"Hispanic",0,0,0,null,{"$f":"C74/C61","v":{"$error":"#DIV/0!"}},{"$f":"D74/C61","v":{"$error":"#DIV/0!"}},{"$f":"E74/C61","v":{"$error":"#DIV/0!"}}]
[null,"Other",0,0,0,null,{"$f":"C75/C61","v":{"$error":"#DIV/0!"}},{"$f":"D75/C61","v":{"$error":"#DIV/0!"}},{"$f":"E75/C61","v":{"$error":"#DIV/0!"}}]
[]
[null,"Year 3 (XXXX)"]
[]
[null,"Total Population",0]
[null,null,"# of People Served",null,null,null,"Overall % of Service Area Population"]
[null,"Gender","SMI","SED","SUD",null,"SMI","SED","SUD"]
[null,"Female",0,0,0,null,{"$f":"C82/C79","v":{"$error":"#DIV/0!"}},{"$f":"D82/C79","v":{"$error":"#DIV/0!"}},{"$f":"E82/C79","v":{"$error":"#DIV/0!"}}]
[null,"Male",0,0,0,null,{"$f":"C83/C79","v":{"$error":"#DIV/0!"}},{"$f":"D83/C79","v":{"$error":"#DIV/0!"}},{"$f":"E83/C79","v":{"$error":"#DIV/0!"}}]
[null,"Age"]
[null,"Age Group 0-17 ",0,0,0,null,{"$f":"SUM(C85/C79)","v":{"$error":"#DIV/0!"}},{"$f":"D85/C79","v":{"$error":"#DIV/0!"}},{"$f":"E85/C79","v":{"$error":"#DIV/0!"}}]
[null,"Age Group 18 - 64 ",0,0,0,null,{"$f":"SUM(C86/C79)","v":{"$error":"#DIV/0!"}},{"$f":"D86/C79","v":{"$error":"#DIV/0!"}},{"$f":"E86/C79","v":{"$error":"#DIV/0!"}}]
[null,"Age Group 65+ ",0,0,0,null,{"$f":"SUM(C87/C79)","v":{"$error":"#DIV/0!"}},{"$f":"D87/C79","v":{"$error":"#DIV/0!"}},{"$f":"E87/C79","v":{"$error":"#DIV/0!"}}]
[null,"Race/Ethnicity"]
[null,"White",0,0,0,null,{"$f":"C89/C79","v":{"$error":"#DIV/0!"}},{"$f":"D89/C79","v":{"$error":"#DIV/0!"}},{"$f":"E89/C79","v":{"$error":"#DIV/0!"}}]
[null,"Black",0,0,0,null,{"$f":"C90/C79","v":{"$error":"#DIV/0!"}},{"$f":"D90/C79","v":{"$error":"#DIV/0!"}},{"$f":"E90/C79","v":{"$error":"#DIV/0!"}}]
[null,"Asian",0,0,0,null,{"$f":"C91/C79","v":{"$error":"#DIV/0!"}},{"$f":"D91/C79","v":{"$error":"#DIV/0!"}},{"$f":"E91/C79","v":{"$error":"#DIV/0!"}}]
[null,"Hispanic",0,0,0,null,{"$f":"C92/C79","v":{"$error":"#DIV/0!"}},{"$f":"D92/C79","v":{"$error":"#DIV/0!"}},{"$f":"E92/C79","v":{"$error":"#DIV/0!"}}]
[null,"Other",0,0,0,null,{"$f":"C93/C79","v":{"$error":"#DIV/0!"}},{"$f":"D93/C79","v":{"$error":"#DIV/0!"}},{"$f":"E93/C79","v":{"$error":"#DIV/0!"}}]
[]
[null,"Instructions: The three (3) year average penetration rate will auto populate based on the data provided in Table 7.\n\nNote: If the links in Table 8 do not calculate, you may calculate the three (3) year average by adding each year total together (Year 1 + Year 2 + Year 3) then divide the total by three (3). The total will be the three (3) year average penetration rate. "]
[null,"Table 8: Three (3) Year Average Penetration Rate"]
[null,null,"Three Year Overall Average Penetration Rates"]
[null,"Gender","SMI",null,"SED",null,"SUD"]
[null,"Female",{"$f":"(G46+G64+G82)/3","v":{"$error":"#DIV/0!"}},null,{"$f":"(H46+H64+H82)/3","v":{"$error":"#DIV/0!"}},null,{"$f":"(I46+I64+I82)/3","v":{"$error":"#DIV/0!"}}]
[null,"Male",{"$f":"(G47+G65+G83)/3","v":{"$error":"#DIV/0!"}},null,{"$f":"(H47+H65+H83)/3","v":{"$error":"#DIV/0!"}},null,{"$f":"(I47+I65+I83)/3","v":{"$error":"#DIV/0!"}}]
[null,"Age"]
[null,"Age Group 0-17 ",{"$f":"(G49+G67+G85)/3","v":{"$error":"#DIV/0!"}},null,{"$f":"(H49+H67+H85)/3","v":{"$error":"#DIV/0!"}},null,{"$f":"(I49+I67+I85)/3","v":{"$error":"#DIV/0!"}}]
[null,"Age Group 18 - 64 ",{"$f":"(G50+G68+G86)/3","v":{"$error":"#DIV/0!"}},null,{"$f":"(H50+H68+H86)/3","v":{"$error":"#DIV/0!"}},null,{"$f":"(I50+I68+I86)/3","v":{"$error":"#DIV/0!"}}]
[null,"Age Group 65+ ",{"$f":"(G51+G69+G87)/3","v":{"$error":"#DIV/0!"}},null,{"$f":"(H51+H69+H87)/3","v":{"$error":"#DIV/0!"}},null,{"$f":"(I51+I69+I87)/3","v":{"$error":"#DIV/0!"}}]
[null,"Race/Ethnicity"]
[null,"White",{"$f":"(G53+G71+G89)/3","v":{"$error":"#DIV/0!"}},null,{"$f":"(H53+H71+H89)/3","v":{"$error":"#DIV/0!"}},null,{"$f":"(I53+I71+I89)/3","v":{"$error":"#DIV/0!"}}]
[null,"Black",{"$f":"(G54+G72+G90)/3","v":{"$error":"#DIV/0!"}},null,{"$f":"(H54+H72+H90)/3","v":{"$error":"#DIV/0!"}},null,{"$f":"(I54+I72+I90)/3","v":{"$error":"#DIV/0!"}}]
[null,"Asian",{"$f":"(G55+G73+G91)/3","v":{"$error":"#DIV/0!"}},null,{"$f":"(H55+H73+H91)/3","v":{"$error":"#DIV/0!"}},null,{"$f":"(I55+I73+I91)/3","v":{"$error":"#DIV/0!"}}]
[null,"Hispanic",{"$f":"(G56+G74+G92)/3","v":{"$error":"#DIV/0!"}},null,{"$f":"(H56+H74+H92)/3","v":{"$error":"#DIV/0!"}},null,{"$f":"(I56+I74+I92)/3","v":{"$error":"#DIV/0!"}}]
[null,"Other",{"$f":"(G57+G75+G93)/3","v":{"$error":"#DIV/0!"}},null,{"$f":"(H57+H75+H93)/3","v":{"$error":"#DIV/0!"}},null,{"$f":"(I57+I75+I93)/3","v":{"$error":"#DIV/0!"}}]

{"sheet":"Stakeholder Engagement","index":7,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":false,"merged":[[50,1,50,3],[51,1,51,3],[30,1,30,3],[1,1,1,3],[5,1,5,3],[4,1,4,3],[3,1,3,3],[2,1,2,3],[32,2,32,3],[33,2,33,3],[34,2,34,3],[35,2,35,3],[36,2,36,3],[37,2,37,3]]}
[]
[null,"STAKEHOLDER ENGAGEMENT"]
[null,"The purpose of stakeholder engagement is to ensure that interested stakeholders within the community are given the opportunity to provide valuable insight into the behavioral health and socio economic needs of the people within their community. Stakeholder engagement should gather input in regards to:\n     • Cultural, linguistic, physical health, and behavioral health treatment needs; \n     • Evidence-based practices and behavioral health crisis services; \n     • Access and availability of CCBHC services including days, times, and locations, and telehealth options; and \n     • Potential barriers to care such as geographic barriers, transportation challenges, economic hardship, lack of culturally responsive services, and workforce shortages.\n"]
[null,"It is expected that the CCBHC will conduct at least two or more separate and different types of stakeholder engagement activities (interview, survey, focus group, meetings) with the identified stakeholder engagement types to include:\n     • Representative from different agencies, \n     • Persons with lived experience, \n     • People receiving services from a CCBHC, and\n     • People not engaging with health services, etc.  "]
[null,"The CCBHCs are required to document their findings from these stakeholder engagement efforts and/or data analysis. The findings from stakeholder engagement activities can provide valuable insights and assist the CCBHC in gathering comprehensive information to further advance the CCBHC model. "]
[null,"Instructions: For Table 9, from the drop-down box select the type of outreach conducted during the stakeholder engagement activities. You may select more than one type of outreach activity. If the type of outreach activity is not listed, select \"Other\" and describe the outreach activity conducted in the \"Other\" column. \n\nSee \"Free Response Questions\" Tab for additional \"Stakeholder Engagement\" information required."]
[null,"Table 9: Stakeholder Engagement Type"]
[null,"Recommended Stakeholder Types","Type of Outreach\n(box will expand to accommodate multiple Stakeholder Types)","If Other, please provide description"]
[null,"Aging and Disability Resource Centers "]
[null,"Child welfare agencies, state licensed, and national accredited child placing agencies for therapeutic foster care service"]
[null,"Criminal justice and/or juvenile justice agencies and facilities "]
[null,"Crisis response partners (hospital emergency departments, emergency responders, crisis stabilization settings, crisis call centers, and warmlines)"]
[null,"Employment services systems "]
[null,"Food Banks "]
[null,"Health centers (including FQHCs in the service area)"]
[null,"Homeless shelters and housing agencies "]
[null,"Housing Authority "]
[null,"Inpatient psychiatric facilities, inpatient acute care hospitals, and hospital outpatient clinics"]
[null,"Local health departments (Note: these departments also develop community needs assessments that may be helpful)"]
[null,"One or more Department of Veterans Affairs facilities"]
[null,"Organizations operated by people with lived experience of mental health and substance use conditions "]
[null,"Other mental health and SUD treatment providers in the community "]
[null,"Other social and human services (e.g., domestic violence centers, pastoral services, grief counseling, Affordable Care Act navigators, food and transportation programs) "]
[null,"Peer-run and operated service providers"]
[null,"People with lived experience of mental and substance use conditions and individuals who have received/are receiving services from the clinic conducting the needs assessment"]
[null,"Representatives from local K-12 school systems"]
[null,"Residential programs "]
[null,"Services for older adults, such as Area Agencies on Aging "]
[null,"Specialty providers of medications for treatment of opioid and alcohol use disorders "]
[null,"Other identified community stakeholder(s)"]
[null,"Instructions: For Table 10, collate the number and types of engagements performed in Table 9 (Other, Focus Groups, Interviews, Meetings, and Surveys) and put the number in the \"Number of Engagements\" column."]
[null,"Table 10: Stakeholder Engagement Overview Type "]
[null,"Type of Engagement","Number of Engagements"]
[null,"Focus Groups"]
[null,"Interviews"]
[null,"Meetings"]
[null,"Surveys"]
[null,"Other"]

{"sheet":"Stakeholder Engagement Summary","index":8,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,"STAKEHOLDER ENGAGEMENT ACTIVITIES SUMMARY"]
[]
[null,"Instructions:  For Table 11, summarize your agency’s stakeholder engagement activities. Please provide the following in your response. \n      • The agenda topics discussed for each stakeholder engagement, \n      • Detailed Summary of findings, (The agenda topics discussed for each stakeholder engagement)\n      • Key Takeaways including any identified barriers, concerns and suggestions, and noteworthy insights. "]
[null,"Include an action plan on how your agency will incorporate these findings into the agency Continuous Quality Improvement (CQI) activities and/or agency business practices."]
[null,"Table 11: Stakeholder Engagement Activities Summary"]
[null,"Primary Agenda Items/Themes"]
[]
[null,"Detailed Summary of findings"]
[]
[null,"Key Takeaways"]
[]
[null,"Action Plan"]

{"sheet":"Assessment of Staffing","index":9,"n_rows":34,"n_cols":3,"rows_kept":34,"cut":false,"hidden":false,"merged":[[33,1,33,2],[1,1,1,2],[4,3,4,8],[2,1,2,2],[3,1,3,2],[4,1,4,2]]}
[]
[null,"ASSESSMENT OF STAFFING / STAFFING PLAN"]
[null,"Assessing your agency's general staffing requirements and needs will help to ensure a core workforce is comprised of clinical, peer, and other staff. Assessing staffing levels on a regular basis allows your agency to identify potential gaps in service delivery and treatment needs and ensures appropriate resources are allocated to meet the behavioral health needs of the community effectively and efficiently. Aligning the staffing plan with the findings of the needs assessment ensures that the CCBHC has the right workforce to meet the community’s needs. It helps identify potential gaps or areas where additional training and resources may be needed. "]
[null,"Instructions:  In the table below, provide the number of current staff by Position Title. Also, please include the number of position vacancies. If there are no vacant positions, please put a 0 in the cell.  Please provide the requested information in the \"Other Positions not listed\" section, if applicable.\n\nComparative assessment of staffing levels, allows for the opportunity to identify any trends or barriers related to staffing needs. Agency should review 2021 staffing data and compare to current report. Any identified trends or barriers related to staffing levels/needs should be reported in the Summary of Findings tab. \n\nSee \"Free Response Questions\" Tab for additional \"Assessment of Staffing / Staffing Plan\" information required.\n"]
[null,"Staffing \n(Provide staffing level counts within the previous three (3) months of Community Needs Assessment completion)"]
[null,"Position Title","Number of Staff by Position(s)"]
[null,"Therapist"]
[null,"Certified Alcohol and Drug Counselor (CADC) I or II"]
[null,"Certified Alcohol and Drug Counselor Associate (CADCA)"]
[null,"Certified Social Worker (CSW)"]
[null,"Clinical Psychologist (PHD)"]
[null,"Licensed Alcohol and Drug Counselor (LADC)"]
[null,"Licensed Clinical Alcohol and Drug Counselor (LCADC)"]
[null,"Licensed Clinical Alcohol and Drug Counselor Associate (LCADCA)"]
[null,"Licensed Clinical Service Worker (LCSW)"]
[null,"Licensed Marriage and Family Therapist (LMFT)"]
[null,"Licensed Professional Clinical Counselor (LPCC)"]
[null,"Licensed Professional Counselor Associate (LPCA)"]
[null,"Licensed Psychological Associate (LPA)"]
[null,"Licensed Social Worker (LSW)"]
[null,"Marriage and Family Therapy Associates (MFTA)"]
[null,"Prescribers"]
[null,"Advanced Practice Registered Nurse"]
[null,"MD/DO"]
[null,"Physician Assistant"]
[null,"Psychiatrist"]
[null,"Clinic Staff and Support"]
[null,"Community Health Worker"]
[null,"Community Support Associates"]
[null,"Mental Health Associates"]
[null,"Nurse / Registered Nurse (RN)"]
[null,"Peer Support Specialist"]
[null,"Targeted Case Manager"]
[null,"Other Positions not Listed"]

{"sheet":"Accessibility Availability Serv","index":10,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[[11,1,11,2],[8,3,8,4],[10,3,10,4],[3,14,3,15],[4,14,4,15],[5,14,5,15],[6,14,6,15],[7,14,7,15],[10,1,10,2],[9,1,9,2],[8,1,8,2],[3,1,3,2]]}
[]
[null,"ACCESSIBLITY AND AVAILABILITY OF SERVICES "]
[null,"The understanding of how available and accessible behavioral health services are to people in your community is a critical step for a CCBHC. This comprehension empowers the CCBHC to effectively bridge service gaps, diminish accessibility barriers, and tailor interventions to meet the unique requirements of the population, thus promoting equitable and impactful healthcare provision."]
[null,"Instructions: Please provide clear detailed responses that directly address the request(s) for information below. Be specific with details to the best of your ability."]
[null,"Provide examples of how the agency provides easily accessible and available services to all individuals in the community including underserved populations."]
[]
[null,"Discuss the identified obstacles or barriers that hinder the accessibility and availability of behavioral health services in your service area. "]

{"sheet":"Cultural & Linguistic","index":11,"n_rows":29,"n_cols":5,"rows_kept":29,"cut":false,"hidden":false,"merged":[[29,1,29,2],[28,1,28,2],[18,1,18,2],[27,1,27,4],[20,1,20,2],[19,1,19,2],[6,1,6,4],[7,1,7,4],[15,1,15,4],[25,1,25,4],[26,1,26,4],[12,1,12,2],[23,1,23,2],[21,1,21,2],[22,1,22,2],[13,1,13,2],[10,1,10,2],[9,1,9,2],[8,1,8,2],[11,1,11,2],[17,1,17,5],[16,1,16,4],[2,1,2,4],[1,1,1,4],[4,1,4,4],[3,1,3,4],[5,1,5,4],[37,6,37,8],[32,1,32,2],[31,1,31,2],[30,1,30,2],[33,1,33,2]]}
[]
[null,"CULTURAL AND LINGUISTIC DIVERSITY NEEDS"]
[null,"Cultural and linguistically appropriate services are respectful of and responsive to the health beliefs, practices, and needs of diverse consumers. The Cultural and Linguistic assessment aims to ensure services provided by the CCBHC are in alignment with the principles of Cultural and Linguistic Appropriate Services (CLAS). CLAS refers to a set of standards and practices designed to ensure that healthcare services are respectful of and responsive to the diverse cultural and linguistic needs of the communities served. "]
[null,"*Data for this table may be obtained from your agency's EHR as well as stakeholder engagement activities* "]
[null,"Instructions: For Table 12, from the drop-down list provide the cultural populations identified within your service area and the accommodations your agency provides for each population. If \"Other\" is selected, please provide the type of accommodation in the appropriate column.  See \"Free Response Questions\" Tab for additional information required."]
[null,"* An expanded list and definition of cultural, non-English, and linguistic diversity can be found in the \"Terms & Definitions\" tab."]
[null,"Column 1: Cultural Populations: provide the name of the various populations identified in the agency service area e.g. Asian, Military culture, ethnicity, religious beliefs, etc.\nColumn 2: Accommodations: Select current accommodations for the cultural population identified. (You may select more than one)\n     Gender-Concordant Care: the provider of care and the patient are the same sex.\n     Promote Cultural Awareness: agency ensures staff and providers can appropriately acknowledge and respond to cultural difference and needs. \n     Religious Accommodations: agency identifies and appropriately accommodates a person’s religious beliefs.\n     Staff Training: staff receive training specific to identified cultures (to include appropriate staff behaviors and skills) to deliver high-quality culturally appropriate care. \n     Other: e.g. intake forms/interpreters (sign language)/bilingual therapist, staff training.\n"]
[null,"Table 12: Most recent 1 Year Data on Cultural Populations within your Service Area"]
[null,"Identified Cultural Populations Prevalent within the Service Area",null,"How does the agency currently accommodate the identified population \n(box will expand to accommodate multiple selections)","If \"Other\", please list specific accommodation(s) provided"]
[]
[]
[]
[]
[]
[]
[null,"Instructions: For Table 13, provide any identified Non-English languages spoken in your service region and what accommodations are in place for people who speak the identified language. Choose the type(s) of accommodation(s) from the drop-down box. You may choose multiple accommodation(s). If \"Other\" is selected, provide the identified Non-English language and the type(s) of accommodation(s) in the appropriate column(s)."]
[null,"Column 1: Non-English Languages Spoken: provide the name of the Non-English languages identified as spoken in the agency service area.\nColumn 2: Accommodations: Select current accommodations for the Non-English languages identified as spoken. (You may select more than one). \n     Agency Forms: agency forms translated to accommodate specific languages.\n     Bilingual Therapist: professional accommodation for linguistic characteristics including bilingual or multilingual factors for patients.\n     Interpreter: professional or service who communicates to the patients regarding their medical care if their primary language is not English.  \n     Staff Support: agency staff who support and provide language accommodation to patients.\n     Visual Aids: using visual content in other languages for patient education e.g., infographic on how to hand wash in other language(s).\n     Other: any other accommodation provided."]
[null,"Table 13: Most recent 1 Year Data on Non-English Languages spoken within your Service Area"]
[null,"Identified Non-English Languages Prevalent within the Service Area",null,"How does the agency currently accommodate the identified population\n(box will expand to accommodate multiple selections)","If \"Other\", please list specific accommodation(s) provided"]
[]
[]
[]
[]
[]
[]
[null,"Instructions: For Table 14, column 1, provide all populations identified as having communication barriers identified within your service population. From the dropdown, select the types of accommodations your agency provides to assist that population. You may select more than one type of accommodation. If \"Other\" is selected, provide the population name and the type of accommodation in the appropriate column."]
[null,"Column 1: Populations with Communication Barriers: the type of populations identified e.g. hard of hearing, non-verbal, limited vision, people who cannot read or write, etc. \nColumn 2: Accommodations: Select current accommodations for the populations with communications barriers identified. (You may select more than one)\n     Assistive Technology: equipment, software program, or product used to improve patient communication.\n     Braille Materials: documents available by people who are visually impaired.\n     Interpreters: services or agency staff who communicate with patients regarding their care.\n     Large Print Materials: printed materials in large print so a person with limited vision can read the document.\n     Staff Support: agency staff is available to assist patients with their care.\n    Other: any other accommodation provided.\n"]
[null,"Table 14: Most recent 1 Year Data on Populations with Other Communication Barriers within your Service Area"]
[null,"Identified Populations Prevalent within the Service Area",null,"How does the agency currently accommodate the identified population\n(box will expand to accommodate multiple selections)","If \"Other\" is selected, provide the type of accommodation your agency provides"]

{"sheet":"Care Coordination","index":12,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[6,1,6,2],[5,1,5,2],[0,1,0,3],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2]]}
[]
[null,"CARE COORDINATION"]
[null,"By understanding which groups may face greater challenges in accessing needed services, as well as understanding any integrated care needs, your agency can implement targeted outreach and support efforts. Identifying health and social factors in underserved populations will help your agency to address disparities in access to care. Care Coordination should be viewed as an activity, not a service, and incorporated throughout agency activities."]
[null,"*Information for this table may be obtained from the \"Regional Demographics Data\" tab, your agency's EHR, as well as stakeholder engagement activities* "]
[null,"Instructions: For Table 15, provide information on the underserved populations identified within your service area and the type of activities your agency engages in to support the underserved populations. See \"Free Response Questions\" Tab for additional information required."]
[null,"Underserved Populations: Populations with limited or no access to care or resources."]
[null,"Table 15: Identified Underserved Populations Prevalent within your Service Area"]
[null,"Identified Underserved Populations Prevalent within the Service Area","Provide the type of outreach, engagement, and support(s) your agency currently provides to this population(s)"]

{"sheet":"SDOH","index":13,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[28,14,28,15],[25,14,25,15],[26,14,26,15],[27,14,27,15],[2,12,2,17],[0,1,0,10],[2,1,2,2],[1,1,1,2],[7,3,9,5],[5,1,5,2],[4,1,4,2],[3,1,3,2],[6,1,6,2]]}
[]
[null,"SOCIAL DRIVERS OF HEALTH"]
[null,"Social Drivers of Health (SDOH) are the nonmedical (non-clinical) factors or conditions that influence health outcomes. SDOH influenced by nonmedical factors may include inadequate access to care, food insecurity, living in poverty, limited support system, violence, and unhealthy behaviors. "]
[null,"*Information for this table may be obtained from your agency's EHR as well as stakeholder engagement activities* "]
[null,"Instructions: For Table 16, select the predominant SDOH identified, from the drop-down list, impacting your service region. If \"Other\" is selected, provide any additional health disparities identified. See \"Free Response Questions\" Tab for additional information required."]
[null,"Access to Healthcare: the lack of ability to obtain healthcare services for prevention, diagnosis, treatment, and the management of diseases, illnesses, disorders, and other health-impacting conditions.\nEconomic Instability: a person or family lacks the resources to provide life necessities (e.g., affordable housing, employment that provides a living wage, child care, and access to reliable transportation).\nFood Insecurity: not having access to sufficient food or quality/nutritious food to meet one’s basic needs. \nHealth Behaviors: smoking, substance use, diet, lack of physical activity. \nLimited Support System: having limited or no network of family/friends or resources.\nPersonal Safety: a pattern of assault or coercive behaviors including physical, sexual, and/or psychological abuse.\nRacial/Cultural Disparity: imbalances and/or incongruities between the treatment of racial and cultural groups.\nOther: any other identified causes negatively impacting the health of the population. "]
[null,"Table 16: Predominant Social Drivers of Health impacting your Service Region"]
[null,"Predominant Social Drivers of Health","If Other, provide any additional health disparities identified"]

{"sheet":"Free Response Questions","index":14,"n_rows":78,"n_cols":2,"rows_kept":78,"cut":false,"hidden":false,"merged":[]}
[]
[null,"RESPONSE TO THE FOLLOWING QUESTIONS IS REQUIRED"]
[null,"Instructions: Please provide clear detailed responses that directly address the request(s) for information below. The responses should be clear and specific with details, to the best of your ability. This is a required section to complete, refrain from using “N/A” and ensure all responses are comprehensive."]
[null,"GEOGRAPHIC SERVICE AREA"]
[null,"Please include examples of locations where your agency historically provides services outside of specific clinic locations e.g., libraries, homeless shelter, patient home, schools."]
[]
[null,"Describe how your agency determines hours of operation including evening and weekend hours for individual locations."]
[]
[null,"Specific to those agency locations reported as not CCBHC certified, please provide information on what services/programs are provided."]
[]
[]
[null,"REGIONAL DEMOGRAPHIC DATA"]
[null,"What barriers are associated with delivering CCBHC services within your service area (e.g., location of CCBHC, privacy concerns, transportation, inability to collaborate with other providers, etc.)? "]
[]
[null,"Describe identified trends within your service area related to the number of clients served. Please describe all (positive and negative) trends impacting your service area."]
[]
[null,"Describe any specific additional demographic factors identified which pose challenges or unique considerations to address mental health and substance use needs in the CCBHC’s service area(s), e.g., race/ethnicity, age, culture, rural location, low socioeconomic status, religious beliefs. "]
[]
[]
[]
[null,"PREVALENCE OF MENTAL HEALTH AND SUBSTANCE USE DISORDER(S)"]
[null,"Describe any trends identified in the occurrence of mental health and substance use conditions within the service area (consider year over year changes). Discuss if the penetration rate meets the expectations of the CCBHC. "]
[]
[null,"Describe how the CCBHC plans to address gaps/needs in service penetration rates identified in the behavioral health penetration data. (i.e.: expansion of EBPs, marketing activities, outreach activities, increase in staff and/or additional locations, etc.). "]
[]
[null,"In review of your agency CQI plan and activities, discuss how the data collected and monitored regarding rates of suicide, suicide attempts, and overdose is used to inform identified needs, as well as corresponding service delivery within you service region. Discuss the current rates of suicide, suicide attempts, and overdose within your service region for the past three calendar years. "]
[]
[]
[null,"STAKEHOLDER ENGAGEMENT"]
[null,"Describe any partnerships or collaborations your agency has established with community organizations or stakeholders to address racial health disparities."]
[]
[null,"Describe any feedback received from any cultural and/or racially diverse stakeholders regarding your services, and how your agency has used, or will use this feedback to make improvements."]
[]
[null,"Identify the steps your agency takes to actively engage and involve culturally and/or racially diverse communities in the planning and implementation of behavioral health services at your CCBHC."]
[]
[]
[null,"CULTURAL AND LINGUISTIC DIVERSITY NEEDS"]
[null,"Provide the methods used to assess the cultural and linguistic needs within your service region."]
[]
[null,"Document any languages and cultures that are prevalent within the local community, but currently not represented among clinic staff or in printed materials."]
[]
[null,"Identify and provide the challenges related to cultural and linguistic factors that impact the effective provision of integrated behavioral health care."]
[]
[]
[null,"CARE COORDINATION"]
[null,"Describe how your care coordination activities promote access to high-quality physical health care (both acute and chronic) and behavioral health care."]
[]
[null,"Describe how your care coordination activities support a person's access to social services, housing, educational systems, and employment opportunities to facilitate wellness and recovery of the whole person."]
[]
[null,"What are the potential barriers the underserved communities and individuals face to enrolling in and accessing needed benefits and services? "]
[]
[null,"Describe the care coordination strategies used to address and promote racial equity."]
[]
[null,"Describe how your agency utilizes electronic communication within care coordination activities."]
[]
[]
[null,"SOCIAL DRIVERS OF HEALTH"]
[null,"Describe the steps your agency takes to continually assess the SDOH needs within your service area."]
[]
[null,"How does your agency currently provide outreach and engagement to those in your service region impacted by the SDOH in Table 15 (refer to SDOH tab)."]
[]
[null,"Explain which strategies your agency plans to implement to further increase outreach and engagement activities to support those impacted by the SDOH in Table 15 with accessing and engaging in needed services (refer to SDOH tab)."]
[]
[]
[null,"ASSESSMENT OF STAFFING / STAFFING PLAN"]
[null,"Based on data collection and stakeholder engagement activities, discuss all identified staffing-related challenges which pose barriers to delivering integrated behavioral health services. "]
[]
[null,"Based on the reported population demographics, discuss any staffing barriers, challenges, or training needs identified in providing integrated behavioral health services in your region."]
[]
[null,"Based on the reported population demographics, discuss any staffing barriers, challenges, or training needs identified to serve these populations with cultural responsiveness and to ensure equitable services for all racial and ethnic groups."]
[]
[null,"Based on data collection and stakeholder engagement activities, discuss any staffing needs for expansion of programming and/or need for evidence based practices not currently required by the state."]
[]
[null,"Based on stakeholder engagement activities and assessment of current staffing levels, discuss any barriers, challenges, or training needs identified in providing comprehensive SUD services."]
[]
[null,"Based on stakeholder engagement activities and assessment of current staffing levels, discuss any barriers, challenges, or training needs identified in providing comprehensive services to veterans."]
[]
[null,"Based on the information collected from your community needs assessment activities, how does your agency determine staffing levels are appropriate for the population receiving services, in terms of size and composition, and providing the types of services the CCBHC is required to and proposes to offer."]

{"sheet":"EBP Consideration","index":15,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"EVIDENCE-BASED PRACTICE CONSIDERATIONS "]
[null,"In understanding the significance of evidence-based practices (EBPs) in providing effective behavioral health services, this section seeks to illuminate the current and planned integration of the required CCBHC EBPs within your agency, as well as additional EBPs integrated within agency activities."]
[null,"Instructions: Please provide information on additional EBPs in use by your agency to meet the needs of consumers in your service area."]
[null,"Detail strategies the CCBHC employs to continually monitor and evaluate the effectiveness of EBPs in meeting the needs of your service population."]
[]
[null,"Please explain how your agency identifies additional EBP needs within your service area. Provide any specific instances, if applicable, where community members have suggested recommendations aimed at supporting their behavioral health needs."]
[]
[null,"Describe any obstacles or challenges you have encountered related to the identification, adoption, or implementation of EBPs."]

{"sheet":"Summary Findings Nxt S ","index":16,"n_rows":57,"n_cols":2,"rows_kept":57,"cut":false,"hidden":false,"merged":[[9,1,9,2],[16,1,16,2],[23,1,23,2],[30,1,30,2],[51,1,51,2],[44,1,44,2],[37,1,37,2],[27,1,27,2],[3,3,4,3],[6,1,6,2],[1,1,1,2],[4,1,4,2],[2,1,2,2],[3,1,3,2],[20,1,20,2],[13,1,13,2],[41,1,41,2],[34,1,34,2],[55,1,55,2],[48,1,48,2]]}
[]
[null,"SUMMARY OF FINDINGS AND NEXT STEPS"]
[null,"The purpose of the Summary of Findings and Next Steps section is to collect and analyze the data/information included in each section of the Community Needs Assessment. The summary of findings will inform the agency CQI plan and processes, as well as inform agency services and staffing. \n\nPlease provide the information requested in each section below. If additional space is needed please use the \"Continuation\" tab."]
[null,"Instructions: Use the data/information included in each section of the community needs assessment to complete the tables below."]
[null,"Identified Needs: Any needs identified as a result of stakeholder engagement activities and data collection/analysis.\nIdentified Barriers: Any barriers identified as a result of stakeholder engagement activities and data collection/analysis.\nAgency Action Plan: Agency plan to address or remediate identified needs and barriers. Action Plan activities should be included in agency CQI Plan, as appropriate.\n\nBased on the information collected and analyzed by your agency during this needs assessment process, please provide agency goals (SMART GOALS) to support implementation of the agency action plan. SMART Goals should be regularly reviewed and progress assessed within agency CQI activities."]
[]
[]
[]
[]
[null,"Prevalence of Mental Health and Substance Use Conditions"]
[null,"Summary of Identified Needs"]
[null,"Summary of Identified Barriers"]
[null,"Agency Action Plan"]
[null,"SMART Goal "]
[null,"Agency Smart Goal"]
[]
[null,"Accessibility and Availability of Services"]
[null,"Summary of Identified Needs"]
[null,"Summary of Identified Barriers"]
[null,"Agency Action Plan"]
[null,"SMART Goal "]
[null,"Agency Smart Goal"]
[]
[null,"Cultural and Linguistic Diversity Needs"]
[null,"Summary of Identified Needs"]
[null,"Summary of Identified Barriers"]
[null,"Agency Action Plan"]
[null,"SMART Goal "]
[null,"Agency Smart Goal"]
[]
[null,"Needs of the Underserved Population"]
[null,"Summary of Identified Needs"]
[null,"Summary of Identified Barriers"]
[null,"Agency Action Plan"]
[null,"SMART Goal "]
[null,"Agency Smart Goal"]
[]
[null,"Social Drivers of Health"]
[null,"Summary of Identified Needs"]
[null,"Summary of Identified Barriers"]
[null,"Agency Action Plan"]
[null,"SMART Goal "]
[null,"Agency Smart Goal"]
[]
[null,"Assessment of Staffing"]
[null,"Summary of Identified Needs"]
[null,"Summary of Identified Barriers"]
[null,"Agency Action Plan"]
[null,"SMART Goal "]
[null,"Agency Smart Goal"]
[]
[null,"Evidence Based Practices Considerations"]
[null,"Summary of Identified Needs"]
[null,"Summary of Identified Barriers"]
[null,"Agency Action Plan"]
[null,"SMART Goal "]
[null,"Agency Smart Goal"]

{"sheet":"Summary Continuation Tab","index":17,"n_rows":53,"n_cols":2,"rows_kept":53,"cut":false,"hidden":false,"merged":[[1,1,1,2],[5,1,5,2],[51,1,51,2],[47,1,47,2],[16,1,16,2],[9,1,9,2],[23,1,23,2],[30,1,30,2],[37,1,37,2],[44,1,44,2],[12,1,12,2],[19,1,19,2],[26,1,26,2],[33,1,33,2],[40,1,40,2]]}
[]
[null,"CONTINUATION TAB SUMMARY OF FINDINGS AND NEXT STEPS"]
[]
[]
[]
[null,"Prevalence of Mental Health and Substance Use Conditions"]
[null,"Summary of Identified Needs"]
[null,"Summary of Identified Barriers"]
[null,"Agency Action Plan"]
[null,"SMART Goal "]
[null,"Agency Smart Goal"]
[]
[null,"Accessibility and Availability of Services"]
[null,"Summary of Identified Needs"]
[null,"Summary of Identified Barriers"]
[null,"Agency Action Plan"]
[null,"SMART Goal "]
[null,"Agency Smart Goal"]
[]
[null,"Cultural and Linguistic Diversity Needs"]
[null,"Summary of Identified Needs"]
[null,"Summary of Identified Barriers"]
[null,"Agency Action Plan"]
[null,"SMART Goal "]
[null,"Agency Smart Goal"]
[]
[null,"Needs of the Underserved Population"]
[null,"Summary of Identified Needs"]
[null,"Summary of Identified Barriers"]
[null,"Agency Action Plan"]
[null,"SMART Goal "]
[null,"Agency Smart Goal"]
[]
[null,"Social Drivers of Health"]
[null,"Summary of Identified Needs"]
[null,"Summary of Identified Barriers"]
[null,"Agency Action Plan"]
[null,"SMART Goal "]
[null,"Agency Smart Goal"]
[]
[null,"Assessment of Staffing"]
[null,"Summary of Identified Needs"]
[null,"Summary of Identified Barriers"]
[null,"Agency Action Plan"]
[null,"SMART Goal "]
[null,"Agency Smart Goal"]
[]
[null,"Evidence Based Practices Considerations"]
[null,"Summary of Identified Needs"]
[null,"Summary of Identified Barriers"]
[null,"Agency Action Plan"]
[null,"SMART Goal "]
[null,"Agency Smart Goal"]

{"sheet":"Attestation","index":18,"n_rows":11,"n_cols":12,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,8,2,10],[2,11,2,13],[3,8,3,10],[3,11,3,13],[1,1,1,13],[2,2,2,7],[3,1,3,7],[4,4,4,13],[4,1,4,3],[10,11,10,13],[7,1,7,13],[6,1,6,13],[5,1,5,13],[9,1,9,2],[9,3,9,13],[10,2,10,9]]}
[]
[null,"Attestation"]
[null,"Agency Name",null,null,null,null,null,null,"Start date of Needs Assessment",null,null,"XX/XX/XXXX"]
[null,null,null,null,null,null,null,null,"Completion date of Needs Assessment",null,null,"XX/XX/XXXX"]
[null,"Primary Contact Name and Email"]
[]
[null,"(Agency name - fill in) agrees to update their community needs assessment and staffing plan no less than every three years in full compliance with the Substance Abuse and Mental Health Services Administration (SAMHSA) regulations. Our agency understands the importance of regular updates to ensure the accuracy and relevance of our assessment in addressing the evolving needs of the community and enhancing the quality of our services. "]
[null,"Regular update of the needs assessment ensures the CCBHC stays responsive to evolving community needs. This plan outlines a structured approach to gather up-to-date data, enabling the program to continuously review and improve its services to meet identified needs within their service region."]
[]
[null,"Authorized Signer Name"]
[null,"Signature",null,null,null,null,null,null,null,null,"Date"]

{"sheet":"Drop-Down List","index":19,"n_rows":56,"n_cols":2,"rows_kept":56,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Table 1: Provider CCBHC Site Information"]
[null,"No"]
[null,"Yes"]
[]
[null,"Table 2: DCO Site Information"]
[null,"Outpatient Mental Health & Substance Use Service"]
[null,"Outpatient Primary Care Screening and Monitoring"]
[null,"Peer, Family Support, & Counselor Services"]
[null,"Psychiatric Rehabilitation Services"]
[null,"Screening, Assessment, Diagnosis & Risk Assessment"]
[null,"Targeted Case Management"]
[null,"Treatment Planning"]
[]
[]
[null,"Table 7: Stakeholder Engagement Type"]
[null,"Type of Outreach"]
[null,"Focus Groups"]
[null,"Interview"]
[null,"Meetings"]
[null,"Survey"]
[null,"Other"]
[null,"None"]
[]
[null,"Table 12: Most recent (1 Year) Data on Cultural Diversity within your service area"]
[null,"Gender-Concordant Care"]
[null,"Promote Cultural Awareness"]
[null,"Religious Accommodations"]
[null,"Staff Training"]
[null,"Other"]
[]
[null,"Table 13: Most recent 1 Year Data on Non-English Speaking Households within your Service Area"]
[null,"Bilingual Therapist"]
[null,"Agency Forms"]
[null,"Interpreter"]
[null,"Staff Support"]
[null,"Visual Aids "]
[null,"Other"]
[]
[null,"Table 14 Most recent 1 Year Data on Linguistic Diversity within your Service Area"]
[null,"Assistive Technology"]
[null,"Braille Materials"]
[null,"Interpreters"]
[null,"Large Print Materials"]
[null,"Staff Assisted Support"]
[null,"Other"]
[]
[null,"Table 16: Predominant Social Drivers of Health impacting your Service Region"]
[null,"Access to Healthcare"]
[null,"Economic Instability"]
[null,"Food Insecurity"]
[null,"Health Behaviors"]
[null,"Limited Support System"]
[null,"Personal Safety"]
[null,"Racial/Cultural Disparity"]
[null,"Other"]