Population Based Strategy Reach Tool

Note:  Visit the Help Desk Article that includes Power Point Slides and a video of a webinar held on November 15, 2018 designed to support this tool.  The webinar can be found here.

A complete manual may be found at: https://ncpreventiontta.zendesk.com/hc/en-us/articles/360021723431-Population-Based-Strategy-Reach-Tool-Manual

The Excel Spreadsheet attached to the current article provides a Population-Based Strategy Reach Tool.  

This tool is for estimating participant reach for population-based strategies when you do not have exact counts, such as a communication campaign or a county-wide merchant education effort. Use exact counts when available. 

Instructions

1) Go to the most recent American Communities Survey at: 

https://factfinder.census.gov/faces/nav/jsf/pages/community_facts.xhtml

2) Enter up to 10 counties, cities, or zip codes, one place at a time. 

3) In the Excel sheet, update the American Community Survey year if appropriate. 

4) In the excel sheet, type the place in the first row, and then enter it's census data in that column, exactly matching the words in the excel worksheet with American Community Survey data. 

5)Block grant reporting reach numbers will be populated below the "Block Grant Conversions" line. Round to a whole number and enter reach number in ECCO. 

6) Confirm correct data entry by checking that the totals for Race, Ethnicity, and Sex are equal. 

NOTE: If you would like assistance contact Melinda Pankratz at [e-mail]

Melinda can also be reached via phone at: 336.716.1318