Looking to continue with your existing report? Resume a Report

1Getting Started

2Overview

3Programs

4 Countywide findings

Name

This field is for validation purposes and should be left unchanged.

MAC Opioid Settlement Annual Impact Report Builder

Welcome to the Michigan Association of Counties (MAC) Annual Impact Report Builder, an interactive companion to the Local Government Guide to Evaluating Opioid Settlement Investments.

Thank you for using the Annual Impact Report Builder and for the work your local government is doing to address substance use disorders and strengthen your community.

This tool is designed to help local governments organize information from funded programs, evaluate progress toward goals, and communicate the impact of opioid settlement investments to local government leadership, community partners, and residents.

The goal is not to create additional administrative burden. Instead, the builder provides a practical step-by-step process for understanding what was accomplished, what was learned, and how future investments can be strengthened.

By the end of this process, you will have:

A local government Snapshot summarizing your opioid settlement investments and priorities
A Program Evaluation Worksheet that compares goals, expected results, and actual results
Local government findings, lessons learned, and recommendations for future planning
A draft, text-based Annual Opioid Settlement Impact Report that can be reviewed, personalized, and shared

The information you enter throughout the builder is reused in these final products, so each step helps build toward a report rather than creating a separate reporting task.

Questions or need support?

Please reach out to Dan Kelly , MSW, MAC Technical Assistance Specialist. MAC provides no-cost technical assistance with evaluation, reporting, planning, community engagement, and other opioid settlement-related needs. Request MAC Opioid Settlement Technical Assistance

Use Alongside the Evaluation Toolkit

For additional guidance, examples, and evaluation tips, use the full Guide to Evaluating Opioid Settlement Investments. View the full Evaluation Toolkit

What This Tool Will Build

As you answer questions, the builder will organize your information into:

A local government wide snapshot
A Program Evaluation Worksheet
Local lessons, results, and recommendations
A draft, text-based Annual Opioid Settlement Impact Report.

What is an Annual Impact Report ?

An Annual Impact Report brings together evaluation findings, community impact, and program stories to show how opioid settlement funds were used and what was accomplished. It can help demonstrate accountability, strengthen transparency and public trust, recognize accomplishments, and inform future funding decisions.

The builder is intended to save time by organizing information you have already gathered through the evaluation process into a clear report structure that can be shared with county leadership, community partners, and the public.

From Draft Report to Visual Report

This builder will produce a simple, text-based report that can serve as the foundation for your final Annual Impact Report. Counties that want a more polished, visual version can transfer the completed report into MAC's forthcoming Canva-based Annual Impact Report Design Template, which is designed to support graphics, photos, charts, and other visual elements.

Open the MAC Annual Impact Report Design Template

MAC can also provide direct, no-cost support to help your county turn the builder output into a visual report.

How This Connects to the Evaluation Toolkit

The builder follows the toolkit roadmap: gather information, review program goals, assess outputs, assess outcomes, evaluate results, consider collective impact, generate an impact report, and use what was learned to inform future funding and public communication.

Contact Information and Report Login Access

Report name(Required)

Choose a name for your report, this name will be used for your own reference. Example: Maple County — 2026 Annual Impact Report

Primary contact name(Required)

Please provide the primary contact's name responsible for this report.

Primary email address(Required)

An email address is required so you can resume, review, and save your report information. This is the email address that will be used to send you resume links.

Report passphrase(Required)

Choose a passphrase of at least 12 characters this will be used to resume your report at a later date.

Passphrase Confirm passphrase

Additional Team Members

Optional: add the name and email address of each additional report contact. Up to 10 people. These contacts will be emailed access to your report so they can contribute as well.

Name

Before You Begin

To complete this process, gather any information you have available about your county's opioid settlement investments and funded programs.

Helpful materials may include:

Annual reports from funded organizations
Grant applications or funding agreements/contracts
Program budgets
Grantee progress reports
Participant outcome data, if available
Community health or overdose data, if available
Success stories, testimonials, or case studies

Evaluation Tips

Strong evaluations do not require sophisticated data systems. The goal is to use available information to understand what was accomplished, what changed, and what should happen next.
If there is information you do not have this year that you think may be helpful in the future, now is a good time to reach out to funded organizations and discuss what additional data may be feasible for them to track in future years and how to do that.
MAC is also available to help with community health data. Counties can request a county-specific data report that compiles housing, treatment, overdose, mental health, and other key indicators to support planning, evaluation, and Annual Impact Report development.

Local Government Opioid Settlement Overview

Before evaluating individual programs, capture a high-level overview of your local government's opioid settlement investment strategy. This information establishes context for the evaluation and will be used to build your local government snapshot and Annual Impact Report.

Local Government Name(Required)

Reporting period type(Required)

Calendar Year

Fiscal Year

Other

Reporting year(Required)

Please enter a number from 2000 to 2100.

Fiscal year start(Required)

Fiscal year end(Required)

Describe the reporting period(Required)

Total opioid settlement funds expended over the reporting period

Calculated from linked program funding amounts when changes are saved.

Please enter a number greater than or equal to 0.

Number of funded programs

Total programs funded local government wide; this may differ from the number entered below.

Please enter a number greater than or equal to 0.

Governmental funding priorities

Investment will be calculated by priority area

There are 4 different priority areas, including prevention, harm reduction, treatment, and recovery. All programs should be attributed to one of these priority areas.

Prevention

Activities that educate and support individuals and communities to reduce initiation of substance use, misuse of substances, and the development of substance use disorders.

Examples include. media campaigns and primary prevention activities such as school-based programming.

Harm Reduction

A set of practical strategies and ideas aimed at reducing negative consequences associated with drug use.

Examples include. naloxone training and distribution, syringe service programs, and testing for communicable diseases.

Treatment

Programs and providers specifically designed and trained to address substance use disorders, substance misuse, and co-occurring substance use disorder and mental health conditions.

Examples include. withdrawal management, residential and outpatient treatment, treatment for co-occurring conditions, workforce supports, and medications for opioid use disorder.

Recovery

Supports that assist in a process of change through which individuals improve their health and wellness, live self-directed lives, and strive to reach their full potential.

Examples include. peer support, recovery housing, recovery community centers, transportation assistance, and job training or placement.

Multi-Area Programs

Some programs may support more than one priority area. For this high-level breakdown, place the program's full funding amount under the single priority area that most closely reflects its primary purpose. This provides a useful summary while avoiding double-counting the same investment across categories.

Evaluation Tip

Looking at your opioid settlement investments as a portfolio—not just individual grants—can help identify strengths, gaps, and opportunities for future funding.

Prevention

Calculated from linked program funding amounts when changes are saved.
Activities that educate and support individuals and communities to reduce initiation of substance use, misuse of substances, and the development of substance use disorders.
Examples include media campaigns and primary prevention activities such as school-based programming.

Please enter a number greater than or equal to 0.

Harm Reduction

Calculated from linked program funding amounts when changes are saved.
A set of practical strategies and ideas aimed at reducing negative consequences associated with drug use.
Examples include naloxone training and distribution, syringe service programs, and testing for communicable diseases.

Please enter a number greater than or equal to 0.

Treatment

Calculated from linked program funding amounts when changes are saved.
Programs and providers specifically designed and trained to address substance use disorders, substance misuse, and co-occurring substance use disorder and mental health conditions.
Examples include withdrawal management, residential and outpatient treatment, treatment for co-occurring conditions, workforce supports, and medications for opioid use disorder.

Please enter a number greater than or equal to 0.

Recovery

Calculated from linked program funding amounts when changes are saved.
Supports that assist in a process of change through which individuals improve their health and wellness, live self-directed lives, and strive to reach their full potential.
Examples include peer support, recovery housing, recovery community centers, transportation assistance, and job training or placement.

Please enter a number greater than or equal to 0.

Program name	Primary priority area	Actions

There are no Programs.

No linked programs are available for this report yet.

Build Measures

Review the program results above and look for measures that describe the same or very similar concepts, even when providers use slightly different wording.

Step 1: Look for Similar Measures

For example, one provider may report "clients enrolled," another "residents served," and another "individuals receiving services." These may be appropriate to group under a local government wide measure such as Individuals Served.

Step 2: Add Comparable Results

If the measures represent the same concept and do not duplicate the same people or activity, add the results together. For example, 40 + 35 + 25 could be reported as 100 Individuals Served.

Step 3: Explain the Grouping

Briefly document what was combined so readers understand where the local government wide number came from. Do not combine measures simply because they sound similar if they actually represent different things.

Local Government wide output summary

Enter one or more combined output measures you want to feature in the report. Include the measure name and total. Example: "Individuals Served — 100 across three funded programs."

Local government wide outcome summary

Review program outcomes for opportunities to summarize a shared result. Outcomes are often measured differently across programs, so only combine them when the measures are meaningfully comparable. If they are not comparable, summarize the most important shared changes or themes instead.

How were the local government wide measures combined?

Briefly note which program measures were grouped and any important limitations. Example: "Combined clients enrolled, residents served, and individuals receiving services from three programs under Individuals Served."

Evaluation Tip: Combining Measures

Programs will rarely measure outputs and outcomes in exactly the same way. When combining results, use your judgment, describe how measures were grouped, and avoid implying that different measures are directly equivalent. Focus on communicating meaningful community impact rather than creating perfect metrics.

What are the most important lessons learned?

Consider common accomplishments, implementation challenges, partnerships, service gaps, data limitations, or other themes that appeared across programs.

What should our local government continue, change, expand, or prioritize during the next funding period?

Evaluation Tip: Looking Ahead

As you compare programs, you may notice that funded organizations measure similar activities in different ways. Consider working with your steering committee or advisory council to establish a small set of shared performance measures for future funding rounds. Common measures can simplify annual reporting, reduce administrative burden, improve consistency across programs, strengthen countywide evaluation, and make future Annual Impact Reports easier to develop.

Examples may include unique individuals served, events or trainings conducted, referrals made, or organizations and community partners engaged. Programs can still report additional measures specific to their services.

Optional Context for the Annual Impact Report

Total settlement amount expected over the life of the settlements

Enter US dollars without a dollar sign. Leave blank if unknown.

Please enter a number greater than or equal to 0.

Total settlement funding received to date

Enter US dollars without a dollar sign. Leave blank if unknown.

Please enter a number greater than or equal to 0.

Settlement background or local context

Provide any brief background that may help readers understand your local government’s opioid settlement work, such as when settlement planning or investments began, how funding decisions are made, or other relevant local circumstances.

Community health context or trend

Examples include fatal or non-fatal overdose trends, treatment utilization, prescribing trends, recovery-support capacity, social drivers of health, or community survey findings.

Data source or limitation note for the community health information

Evaluation Tip: The Broader Picture

Community health indicators are influenced by many factors beyond opioid settlement investments. Use these data to provide context and identify trends rather than suggesting that funded programs caused changes in community-level outcomes.

MAC Opioid Settlement Annual Impact Report Builder

MAC Opioid Settlement Annual Impact Report Builder

Questions or need support?

Use Alongside the Evaluation Toolkit

What This Tool Will Build

What is an Annual Impact Report ?

From Draft Report to Visual Report

How This Connects to the Evaluation Toolkit

Contact Information and Report Login Access

Before You Begin

Helpful materials may include:

Evaluation Tips

Local Government Opioid Settlement Overview

Investment will be calculated by priority area

Prevention

Harm Reduction

Treatment

Recovery

Multi-Area Programs

Evaluation Tip

Program Information

Program Inventory

Build Measures

Step 1: Look for Similar Measures

Step 2: Add Comparable Results

Step 3: Explain the Grouping

Evaluation Tip: Combining Measures

Evaluation Tip: Looking Ahead

Optional Context for the Annual Impact Report

Evaluation Tip: The Broader Picture

Archives