Form 0920-21GB Special Emphasis Report Examples

---

Overview

Instructions
Populations
Health Regions Population
Totals
2016
2017
2018
2019
2020
Health Region Rates
Optional - 2016-2020 rates
Figure 1
Figure 2
Figure 3
Figure 4
Figure 5
Figure 6
Quick Facts
Report

---

Sheet 1: Instructions

Form Approved OMB NO: 0920-xxxx Exp. Date: X/XX/XXXX Public reporting burden of this collection of information is estimated at 10 hours per response, including the time for reviewing instructions, searching existing data sources, gathering and maintaining the data needed, and completing and reviewing the collection of information. An agency may not conduct or sponsor, and a person is not required to respond to a collection of information unless it displays a currently valid OMB control number. Send comments regarding this burden estimate or any other aspect of this collection of information, including suggestions for reducing this burden to CDC/Information Collection Review Office, 1600 Clifton Road, NE, MS D-74, Atlanta, GA 30333; Attn: PRA (0920-xxxx).

Step 1: Preparing State/Territory Data

Step 2: Entering Data

Step 3: Creating Special Emphasis Report

Name

ICD-10-CM code

ICD-10 notes

1a. Create Nonfatal MVT-Specific Injury Hospitalizations Data Set - The MVT-specific hospitalization indicators should be calculated based on first creating a MVT-related injury hospitalization subset. This is done using the ICD-10-CM codes for the MVT-related hospital discharge indicator in the State Injury Indicators listed below. For hospitalizations, one of these codes should be in the primary/principal diagnosis field for the case to be in the injury subset. *Only include cases if the 7th character of the code is A, B, C, or missing (reflects initial encounter, active treatment). T30-T32 do not have a 7th character. Create an injury hospitalization subset using the ICD-10-CM codes below:

Nonfatal injury hospitalization for all injuries

S00-S99

T07-T34

T36-T50

T36-T50 with a 6th character of 1, 2, 3, or 4 Note: Include T36.9, T37.9, T39.9, T41.4, T42.7, T43.9, T45.9, T47.9, and T49.9 with 5th character of 1, 2, 3, or 4) (Intent information for these codes is included in the 5thcharacter and not the 6th)

T51-T65

T66-T76

T79

O9A.2-O9A.5

T84.04

T84.04 was retired and replaced by M97 in the FY2017 version of ICD-10-CM which went into effect on Oct 1, 2016.

M97

1b. Select hospitalizations with any of the MVT ICD-10-CM codes in any diagnosis field listed below: *Only Include cases if the 7th character of the code is A or missing (reflects initial encounter, active treatment)

Nonfatal Motor vehicle traffic hospitalization

V02-V04 (.1, .9), V09.2, V09.3

MVT-Pedestrian

V12-V14 (.3-.9), V19.4-V19.6, V19.9

MVT-Pedal cyclist

V20-V28 (.3-.9), V29.4-V29.9

MVT-Motorcyclist

V30-V79 (.4-.9), V83-V86 (.0-.3), V87.0-V87.8, V89.2

MVT-Occupant (and unspecified)

V80.3-V80.5, V81.1, V82.1

MVT-Other

2a. Create Nonfatal MVT-Specific Injury Emergency Department (ED) Visit Data Set - These indicators should be calculated based on first creating a MVT-related injury emergency department visit subset. This is done using the instructions for ICD-10-CM codes for MVT-related emergency department indicator listed below: Include cases if the 7th character of the code is A, B, C, or missing (reflects initial encounter, active treatment)

Nonfatal Injury ED visit

S00-S99

T07-T34

T36-T50

T36-T50 with a 6th character of 1, 2, 3, or 4 Note: Include T36.9, T37.9, T39.9, T41.4, T42.7, T43.9, T45.9, T47.9, and T49.9 with 5th character of 1, 2, 3, or 4) (Intent information for these codes is included in the 5thcharacter and not the 6th)

T51-T65

T66-T76

T79

O9A.2-O9A.5

T84.04

M97

V00-V99

For ICD10CM Injury Cause Codes select only 7th character of A or missing **Only include cases if the 7th character is A or missing (reflects initial encounter, active treatment)

W00-X58

X71-X83

X92-Y09

Y21-Y33

Y35-Y38

2b. Select ED visits with any of the following MVT ICD-10-CM codes in any diagnosis field listed below: **Only Include cases if the 7th character of the code is A or missing (reflects initial encounter, active treatment)

Nonfatal Motor vehicle traffic ED visit

V02.1, V02.9, V03.1, V03.9, V04.1, V04.9, V09.2, V09.3

Pedestrian

V12-V14 (.3-.9), V19.4-V19.6, V19.9

Pedal cyclist

V20-V28 (.3-.9), V29.4-V29.9

Motorcyclist

V30-V79 (.4-.9), V83-V86 (.0-.3), V87.0-V87.8, V89.2

Occupant (and unspecified)

V80.3-V80.5, V81.1, V82.1

Other

3a. Create MVT-specific Deaths Data Set - The MVT-specific death indicators should be calculated based on first creating a MVT-related injury death subset. Limit deaths to those with an injury underlying cause of death:

Injury underlying cause of death

V01-Y36

Y85-Y87

Y89

U01-U03

3b. Then select deaths with any of the MVT ICD-10-CM codes in any field of the multiple cause of death file:

Motor vehicle traffic fatalities

V02-V04 (.1, .9)

MVT-Pedestrian

V09.2

V12-V14(.3-.9)

MVT-Pedal cyclist

V19(.4-.6)

V20-V28(.3-.9)

MVT-Motorcyclist

V29(.4–.9)

V30-V79(.4-.9)

MVT-Occupant

V83-V86(.0-.3)

V80(.3-.5)

MVT-Other

V81.1

V82.1

V87(.0-.8)

MVT-Unspecified

V89.2

---

Sheet 2: Populations

If you do not have population data for a certain year, please do not delete the rows so that formulas in other spreadsheet tabs will work.	MVT-Specific State Injury Indicators Report
	State/Territor Population Data
	State/Territory:			Data year:
			Enter your state name		2020				Since each state may use data for different race/ethnicity groups, states can edit the labels in columns I through U if necessary
		Enter total population data by age group below		Enter male population data by age group below		Enter female population data by age group below		Optional: Enter demographic population data		Optional: Enter demographic population data		Optional: Enter demographic population data		Optional: Enter demographic population data		Optional: Enter demographic population data		Optional: Enter demographic population data		Optional: Enter demographic population data
Modify year in row 9 if needed		Total		Male		Female		White-Not Hispanic		Hispanic		Black-Not Hispanic		Asian		American Indian/Alaska Native		Other		Other
2020	<1
Please note that age-adjusted rates per 100,000 in "2016", "2017", "2018", "2019", and "2020" tabs are generated using these age groups	1-4
	5-9
	10-14
	15-19
	20-24
	25-34
	35-44
	45-54
	55-64
	65-74
	75-84
	85+
	Total	0		0		0		0		0		0		0		0		0		0
		Enter total population data by age group below		Enter male population data by age group below		Enter female population data by age group below		Optional: Enter demographic population data		Optional: Enter demographic population data		Optional: Enter demographic population data		Optional: Enter demographic population data		Optional: Enter demographic population data		Optional: Enter demographic population data		Optional: Enter demographic population data
Modify year in row 27 if needed		Total		Male		Female		White-Not Hispanic		Hispanic		Black-Not Hispanic		Asian		American Indian/Alaska Native		Other		Other
2019	<1
	1-4
	5-9
	10-14
	15-19
	20-24
	25-34
	35-44
	45-54
	55-64
	65-74
	75-84
	85+
	Total	0		0		0		0		0		0		0		0		0		0
		Enter total population data by age group below		Enter male population data by age group below		Enter female population data by age group below		Optional: Enter demographic population data		Optional: Enter demographic population data		Optional: Enter demographic population data		Optional: Enter demographic population data		Optional: Enter demographic population data		Optional: Enter demographic population data		Optional: Enter demographic population data
Modify year in row 45 if needed		Total		Male		Female		White-Not Hispanic		Hispanic		Black-Not Hispanic		Asian		American Indian/Alaska Native		Other		Other
2018	<1
	1-4
	5-9
	10-14
	15-19
	20-24
	25-34
	35-44
	45-54
	55-64
	65-74
	75-84
	85+
	Total	0		0		0		0		0		0		0		0		0		0
		Enter total population data by age group below		Enter male population data by age group below		Enter female population data by age group below		Optional: Enter demographic population data		Optional: Enter demographic population data		Optional: Enter demographic population data		Optional: Enter demographic population data		Optional: Enter demographic population data		Optional: Enter demographic population data		Optional: Enter demographic population data
Modify year in row 63 if needed		Total		Male		Female		White-Not Hispanic		Hispanic		Black-Not Hispanic		Asian		American Indian/Alaska Native		Other		Other
2017	<1
	1-4
	5-9
	10-14
	15-19
	20-24
	25-34
	35-44
	45-54
	55-64
	65-74
	75-84
	85+
	Total	0		0		0		0		0		0		0		0		0		0
		Enter total population data by age group below		Enter male population data by age group below		Enter female population data by age group below		Optional: Enter demographic population data		Optional: Enter demographic population data		Optional: Enter demographic population data		Optional: Enter demographic population data		Optional: Enter demographic population data		Optional: Enter demographic population data		Optional: Enter demographic population data
Modify year in row 81 if needed		Total		Male		Female		White-Not Hispanic		Hispanic		Black-Not Hispanic		Asian		American Indian/Alaska Native		Other		Other
2016	<1
	1-4
	5-9
	10-14
	15-19
	20-24
	25-34
	35-44
	45-54
	55-64
	65-74
	75-84
	85+
	Total	0		0		0		0		0		0		0		0		0		0
Please enter 2000 standard population by age group. These populations will be used in "2016", "2017", "2018", "2019", and "2020" tabs with age weights to calculate age-adjusted rates per 100,000
2000	Age	Total
	<1
	1-4
	5-9
	10-14
	15-19
	20-24
	25-34
	35-44
	45-54
	55-64
	65-74
	75-84
	85+
	Total	0

---

Sheet 3: Health Regions Population

The most recent data year in the "Populations" tab will populate in A4	MVT-Specific State Injury Indicators Report
	Health Districts/Regions Data
		Rename Regions in row 4 if needed, please do not edit Region names in the "2020" tab
2020	Age	Region 1		Region 2		Region 3		Region 4		Region 5		Region 6		Region 7		Region 8		Region 9		Region 10		Region 11		Region 12		Region 13		Region 14		Region 15		Region 16		Region 17		Region 18		Region 19		Region 20
	<1
	1-4
	5-9
	10-14
	15-19
	20-24
	25-34
	35-44
	45-54
	55-64
	65-74
	75-84
	85+
	TOTAL	0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0

---

Sheet 4: Totals

Year 1 - Year 5 Totals	Data Input Tables Instructions: Enter your MVT-related injury data in the red cells below. The rates will automatically calculate in the results table.				Use columns F through L to enter demographic data							Optional: Unhide columns N through AG to show rate calculations	Results Table Rates per 100,1000. Results will calculate automatically.
			Sex Data		Demographic Data								Hospitalization rates per 100,000 population											Year 1 - Year 5 hospitalization rate change
	Years will populate below using years entered in the "Populations" tab	Number of hospitalizations- Total	Number of hospitalizations- Male	Number of hospitalizations- Female	White-Not Hispanic	Hispanic	Black-Not Hispanic	Asian	American Indian/Alaska Native	Other	Other		Total	Male	Female	White-Not Hispanic	Hispanic	Black-Not Hispanic	Asian	American Indian/Alaska Native	Other	Other		2016	2017	2018	2019	2020	average annual change in hospitalization rate per 100,000 over 5 years (not percentage change)
	2016												0	0	0	0	0	0	0	0	0	0		0.0	0.0	0.0	0.0	0.0	0.0
	2017												0	0	0	0	0	0	0	0	0	0
	2018												0	0	0	0	0	0	0	0	0	0
	2019												0	0	0	0	0	0	0	0	0	0
	2020												0	0	0	0	0	0	0	0	0	0
			Sex Data		Demographic Data								ED visit rates per 100,000 population
	Years will populate below using years entered in the "Populations" tab	Number of ED visits- Total	Number of ED visits- Male	Number of ED visits- Female	White-Not Hispanic	Hispanic	Black-Not Hispanic	Asian	American Indian/Alaska Native	Other	Other		Total	Male	Female	White-Not Hispanic	Hispanic	Black-Not Hispanic	Asian	American Indian/Alaska Native	Other	Other		Year 1 - Year 5 ED visit rate change
	2016												0	0	0	0	0	0	0	0	0	0		2016	2017	2018	2019	2020	average annual change in ED visit rate per 100,000 over 5 years (not percentage change)
	2017												0	0	0	0	0	0	0	0	0	0		0.0	0.0	0.0	0.0	0.0	0.0
	2018												0	0	0	0	0	0	0	0	0	0
	2019												0	0	0	0	0	0	0	0	0	0
	2020												0	0	0	0	0	0	0	0	0	0
			Sex Data		Demographic Data								Fatality rates per 100,000 population
	Years will populate below using years entered in the "Populations" tab	Number of deaths- Total	Number of deaths- Male	Number of deaths- Female	White-Not Hispanic	Hispanic	Black-Not Hispanic	Asian	American Indian/Alaska Native	Other	Other		Total	Male	Female	White-Not Hispanic	Hispanic	Black-Not Hispanic	Asian	American Indian/Alaska Native	Other	Other		Year 1 - Year 5 fatality rate change
	2016												0	0	0	0	0	0	0	0	0	0		2016	2017	2018	2019	2020	average annual change in ED visit rate per 100,000 over 5 years (not percentage change)
	2017												0	0	0	0	0	0	0	0	0	0		0.0	0.0	0.0	0.0	0.0	0.0
	2018												0	0	0	0	0	0	0	0	0	0
	2019												0	0	0	0	0	0	0	0	0	0
	2020												0	0	0	0	0	0	0	0	0	0

---

Sheet 5: 2016

2016	Data Input Tables Instructions: Enter your MVT-related injury data in the red cells below. The age-adjusted rates will automatically calculate in the results table.				Use columns F through L to enter demographic data								Optional: Unhide columns O through AK to show rate calculations and 2000 population weights	Columns AN through AW will automatically calculate age-adjusted rates per 100,000		Results Table Age Adjusted Rates per 100,1000. Results will calculate automatically.
			Sex Data		Demographic Data												Age-adjusted Rates per 100,000 population
	Age	Number of hospitalizations- Total	Number of hospitalizations- Male	Number of hospitalizations- Female	White-Not Hispanic	Hispanic	Black-Not Hispanic	Asian	American Indian/Alaska Native	Other	Other		State population - Total	2000 Standard population - from "Populations" tab		Age	Total	Male	Female	White-Not Hispanic	Hispanic	Black-Not Hispanic	Asian	American Indian/Alaska Native	Other	Other
	<1												0	0		<1	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	1-4												0	0		1-4	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	5-9												0	0		5-9	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	10-14												0	0		10-14	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	15-19												0	0		15-19	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	20-24												0	0		20-24	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	25-34												0	0		25-34	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	35-44												0	0		35-44	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	45-54												0	0		45-54	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	55-64												0	0		55-64	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	65-74												0	0		65-74	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	75-84												0	0		75-84	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	85+												0	0		85+	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	total	0	0	0	0	0	0	0	0	0	0		0	0		Total	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
			Sex Data		Demographic Data												Age-adjusted Rates per 100,000 population
	Age	Number of ED visits- Total	Number of ED visits- Male	Number of ED visits- Female	White-Not Hispanic	Hispanic	Black-Not Hispanic	Asian	American Indian/Alaska Native	Other	Other		State population - Total	2000 Standard population - from "Populations" tab		Age	Total	Male	Female	White-Not Hispanic	Hispanic	Black-Not Hispanic	Asian	American Indian/Alaska Native	Other	Other
	<1												0	0		<1	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	1-4												0	0		1-4	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	5-9												0	0		5-9	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	10-14												0	0		10-14	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	15-19												0	0		15-19	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	20-24												0	0		20-24	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	25-34												0	0		25-34	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	35-44												0	0		35-44	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	45-54												0	0		45-54	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	55-64												0	0		55-64	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	65-74												0	0		65-74	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	75-84												0	0		75-84	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	85+												0	0		85+	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	total	0	0	0	0	0	0	0	0	0	0		0	0		Total	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
			Sex Data		Demographic Data												Age-adjusted Rates per 100,000 population
	Age	Number of deaths- Total	Number of deaths- Male	Number of deaths- Female	White-Not Hispanic	Hispanic	Black-Not Hispanic	Asian	American Indian/Alaska Native	Other	Other		State population - Total	2000 Standard population - from "Populations" tab		Age	Total	Male	Female	White-Not Hispanic	Hispanic	Black-Not Hispanic	Asian	American Indian/Alaska Native	Other	Other
	<1												0	0		<1	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	1-4												0	0		1-4	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	5-9												0	0		5-9	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	10-14												0	0		10-14	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	15-19												0	0		15-19	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	20-24												0	0		20-24	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	25-34												0	0		25-34	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	35-44												0	0		35-44	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	45-54												0	0		45-54	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	55-64												0	0		55-64	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	65-74												0	0		65-74	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	75-84												0	0		75-84	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	85+												0	0		85+	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	total	0	0	0	0	0	0	0	0	0	0		0	0		Total	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0

---

Sheet 6: 2017

2017	Data Input Tables Instructions: Enter your MVT-related injury data in the red cells below. The age-adjusted rates will automatically calculate in the results table.				Use columns F through L to enter demographic data								Optional: Unhide columns O through AK to show rate calculations and 2000 population weights	Columns AM through AV will then autogenerate age adjusted rates per 100,000		Results Table Age Adjusted Rates per 100,1000. Results will calculate automatically.
			Sex Data		Demographic Data												Age-adjusted Rates per 100,000 population
	Age	Number of hospitalizations- Total	Number of hospitalizations- Male	Number of hospitalizations- Female	White-Not Hispanic	Hispanic	Black-Not Hispanic	Asian	American Indian/Alaska Native	Other	Other		State Population Total	2000 Standard population - from "Populations" tab		Age	Total	Male	Female	White-Not Hispanic	Hispanic	Black-Not Hispanic	Asian	American Indian/Alaska Native	Other	Other
	<1												0	0		<1	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	1-4												0	0		1-4	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	5-9												0	0		5-9	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	10-14												0	0		10-14	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	15-19												0	0		15-19	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	20-24												0	0		20-24	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	25-34												0	0		25-34	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	35-44												0	0		35-44	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	45-54												0	0		45-54	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	55-64												0	0		55-64	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	65-74												0	0		65-74	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	75-84												0	0		75-84	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	85+												0	0		85+	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	total	0	0	0	0	0	0	0	0	0	0		0	0		Total	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
			Sex Data		Demographic Data												Age-adjusted Rates per 100,000 population
	Age	Number of ED visits- Total	Number of ED visits- Male	Number of ED visits- Female	White-Not Hispanic	Hispanic	Black-Not Hispanic	Asian	American Indian/Alaska Native	Other	Other		State Population Total	2000 Standard population - from "Populations" tab		Age	Total	Male	Female	White-Not Hispanic	Hispanic	Black-Not Hispanic	Asian	American Indian/Alaska Native	Other	Other
	<1												0	0		<1	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	1-4												0	0		1-4	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	5-9												0	0		5-9	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	10-14												0	0		10-14	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	15-19												0	0		15-19	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	20-24												0	0		20-24	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	25-34												0	0		25-34	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	35-44												0	0		35-44	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	45-54												0	0		45-54	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	55-64												0	0		55-64	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	65-74												0	0		65-74	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	75-84												0	0		75-84	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	85+												0	0		85+	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	total	0	0	0	0	0	0	0	0	0	0		0	0		Total	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
			Sex Data		Demographic Data												Age-adjusted Rates per 100,000 population
	Age	Number of deaths- Total	Number of deaths- Male	Number of deaths- Female	White-Not Hispanic	Hispanic	Black-Not Hispanic	Asian	American Indian/Alaska Native	Other	Other		State Population Total	2000 Standard population - from "Populations" tab		Age	Total	Male	Female	White-Not Hispanic	Hispanic	Black-Not Hispanic	Asian	American Indian/Alaska Native	Other	Other
	<1												0	0		<1	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	1-4												0	0		1-4	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	5-9												0	0		5-9	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	10-14												0	0		10-14	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	15-19												0	0		15-19	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	20-24												0	0		20-24	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	25-34												0	0		25-34	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	35-44												0	0		35-44	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	45-54												0	0		45-54	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	55-64												0	0		55-64	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	65-74												0	0		65-74	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	75-84												0	0		75-84	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	85+												0	0		85+	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	total	0	0	0	0	0	0	0	0	0	0		0	0		Total	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0

---

Sheet 7: 2018

2018	Data Input Tables Instructions: Enter your MVT-related injury data in the red cells below. The age-adjusted rates will automatically calculate in the results table.				Use columns F through L to enter demographic data								Optional: Unhide columns O through AK to show rate calculations and 2000 population weights	Enter 2000 State population by age group. Columns AM through AV will then autogenerate age adjusted rates per 100,000		Results Table Age Adjusted Rates per 100,1000. Results will calculate automatically.
			Sex Data		Demographic Data												Age-adjusted Rates per 100,000 population
	Age	Number of hospitalizations- Total	Number of hospitalizations- Male	Number of hospitalizations- Female	White-Not Hispanic	Hispanic	Black-Not Hispanic	Asian	American Indian/Alaska Native	Other	Other		State Population Total	2000 Standard population - from "Populations" tab		Age	Total	Male	Female	White-Not Hispanic	Hispanic	Black-Not Hispanic	Asian	American Indian/Alaska Native	Other	Other
	<1												0	0		<1	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	1-4												0	0		1-4	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	5-9												0	0		5-9	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	10-14												0	0		10-14	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	15-19												0	0		15-19	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	20-24												0	0		20-24	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	25-34												0	0		25-34	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	35-44												0	0		35-44	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	45-54												0	0		45-54	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	55-64												0	0		55-64	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	65-74												0	0		65-74	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	75-84												0	0		75-84	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	85+												0	0		85+	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	total	0	0	0	0	0	0	0	0	0	0		0	0		Total	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
			Sex Data		Demographic Data												Age-adjusted Rates per 100,000 population
	Age	Number of ED visits- Total	Number of ED visits- Male	Number of ED visits- Female	White-Not Hispanic	Hispanic	Black-Not Hispanic	Asian	American Indian/Alaska Native	Other	Other		State Population Total	2000 Standard population - from "Populations" tab		Age	Total	Male	Female	White-Not Hispanic	Hispanic	Black-Not Hispanic	Asian	American Indian/Alaska Native	Other	Other
	<1												0	0		<1	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	1-4												0	0		1-4	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	5-9												0	0		5-9	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	10-14												0	0		10-14	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	15-19												0	0		15-19	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	20-24												0	0		20-24	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	25-34												0	0		25-34	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	35-44												0	0		35-44	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	45-54												0	0		45-54	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	55-64												0	0		55-64	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	65-74												0	0		65-74	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	75-84												0	0		75-84	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	85+												0	0		85+	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	total	0	0	0	0	0	0	0	0	0	0		0	0		Total	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
			Sex Data		Demographic Data												Age-adjusted Rates per 100,000 population
	Age	Number of deaths- Total	Number of deaths- Male	Number of deaths- Female	White-Not Hispanic	Hispanic	Black-Not Hispanic	Asian	American Indian/Alaska Native	Other	Other		State Population Total	2000 Standard population - from "Populations" tab		Age	Total	Male	Female	White-Not Hispanic	Hispanic	Black-Not Hispanic	Asian	American Indian/Alaska Native	Other	Other
	<1												0	0		<1	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	1-4												0	0		1-4	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	5-9												0	0		5-9	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	10-14												0	0		10-14	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	15-19												0	0		15-19	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	20-24												0	0		20-24	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	25-34												0	0		25-34	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	35-44												0	0		35-44	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	45-54												0	0		45-54	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	55-64												0	0		55-64	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	65-74												0	0		65-74	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	75-84												0	0		75-84	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	85+												0	0		85+	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	total	0	0	0	0	0	0	0	0	0	0		0	0		Total	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0

---

Sheet 8: 2019

2019	Data Input Tables Instructions: Enter your MVT-related injury data in the red cells below. The age-adjusted rates will automatically calculate in the results table.				Use columns F through L to enter demographic data								Optional: Unhide columns O through AK to show rate calculations and 2000 population weights	Columns AM through AV will then automatically calculate age-adjusted rates per 100,000			Results Table Age Adjusted Rates per 100,1000. Results will calculate automatically.
			Sex Data		Demographic Data												Age-adjusted Rates per 100,000 population
	Age	Number of hospitalizations- Total	Number of hospitalizations- Male	Number of hospitalizations- Female	White-Not Hispanic	Hispanic	Black-Not Hispanic	Asian	American Indian/Alaska Native	Other	Other		State population - Total	2000 Standard population - from "Populations" tab		Age	Total	Male	Female	White-Not Hispanic	Hispanic	Black-Not Hispanic	Asian	American Indian/Alaska Native	Other	Other
	<1												0	0		<1	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	1-4												0	0		1-4	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	5-9												0	0		5-9	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	10-14												0	0		10-14	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	15-19												0	0		15-19	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	20-24												0	0		20-24	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	25-34												0	0		25-34	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	35-44												0	0		35-44	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	45-54												0	0		45-54	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	55-64												0	0		55-64	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	65-74												0	0		65-74	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	75-84												0	0		75-84	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	85+												0	0		85+	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	total	0	0	0	0	0	0	0	0	0	0		0	0		Total	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
			Sex Data		Demographic Data												Age-adjusted Rates per 100,000 population
	Age	Number of ED visits- Total	Number of ED visits- Male	Number of ED visits- Female	White-Not Hispanic	Hispanic	Black-Not Hispanic	Asian	American Indian/Alaska Native	Other	Other		State population - Total	2000 Standard population - from "Populations" tab		Age	Total	Male	Female	White-Not Hispanic	Hispanic	Black-Not Hispanic	Asian	American Indian/Alaska Native	Other	Other
	<1												0	0		<1	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	1-4												0	0		1-4	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	5-9												0	0		5-9	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	10-14												0	0		10-14	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	15-19												0	0		15-19	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	20-24												0	0		20-24	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	25-34												0	0		25-34	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	35-44												0	0		35-44	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	45-54												0	0		45-54	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	55-64												0	0		55-64	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	65-74												0	0		65-74	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	75-84												0	0		75-84	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	85+												0	0		85+	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	total	0	0	0	0	0	0	0	0	0	0		0	0		Total	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
			Sex Data		Demographic Data												Age-adjusted Rates per 100,000 population
	Age	Number of deaths- Total	Number of deaths- Male	Number of deaths- Female	White-Not Hispanic	Hispanic	Black-Not Hispanic	Asian	American Indian/Alaska Native	Other	Other		State population - Total	2000 Standard population - from "Populations" tab		Age	Total	Male	Female	White-Not Hispanic	Hispanic	Black-Not Hispanic	Asian	American Indian/Alaska Native	Other	Other
	<1												0	0		<1	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	1-4												0	0		1-4	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	5-9												0	0		5-9	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	10-14												0	0		10-14	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	15-19												0	0		15-19	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	20-24												0	0		20-24	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	25-34												0	0		25-34	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	35-44												0	0		35-44	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	45-54												0	0		45-54	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	55-64												0	0		55-64	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	65-74												0	0		65-74	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	75-84												0	0		75-84	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	85+												0	0		85+	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	total	0	0	0	0	0	0	0	0	0	0		0	0		Total	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0

---

Sheet 9: 2020

2020	Data Input Tables Instructions: Enter your MVT-related injury data in the red cells below. The age-adjusted rates will automatically calculate in the results table.				Use columns F through L to enter demographic data								Optional: Unhide columns AI through CS to show rate calculations and 2000 population weights	Columns CV through DD will then autogenerate age-adjusted rates per 100,000			Results Table Age Adjusted Rates per 100,1000. Results will calculate automatically.
			Sex Data		Demographic Data												Age-adjusted Rates per 100,000 population
	Age	Number of hospitalizations- Total	Number of hospitalizations- Male	Number of hospitalizations- Female	White-Not Hispanic	Hispanic	Black-Not Hispanic	Asian	American Indian/Alaska Native	Other	Other		State population - Total	2000 Standard population - from "Populations" tab		Age	Total	Male	Female	White-Not Hispanic	Hispanic	Black-Not Hispanic	Asian	American Indian/Alaska Native	Other	Other
	<1												0	0		<1	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	1-4												0	0		1-4	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	5-9												0	0		5-9	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	10-14												0	0		10-14	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	15-19												0	0		15-19	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	20-24												0	0		20-24	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	25-34												0	0		25-34	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	35-44												0	0		35-44	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	45-54												0	0		45-54	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	55-64												0	0		55-64	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	65-74												0	0		65-74	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	75-84												0	0		75-84	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	85+												0	0		85+	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	total	0	0	0	0	0	0	0	0	0	0		0	0		Total	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
			Sex Data		Demographic Data												Age-adjusted Rates per 100,000 population
	Age	Number of ED visits- Total	Number of ED visits- Male	Number of ED visits- Female	White-Not Hispanic	Hispanic	Black-Not Hispanic	Asian	American Indian/Alaska Native	Other	Other		State population - Total	2000 Standard population - from "Populations" tab		Age	Total	Male	Female	White-Not Hispanic	Hispanic	Black-Not Hispanic	Asian	American Indian/Alaska Native	Other	Other
	<1												0	0		<1	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	1-4												0	0		1-4	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	5-9												0	0		5-9	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	10-14												0	0		10-14	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	15-19												0	0		15-19	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	20-24												0	0		20-24	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	25-34												0	0		25-34	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	35-44												0	0		35-44	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	45-54												0	0		45-54	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	55-64												0	0		55-64	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	65-74												0	0		65-74	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	75-84												0	0		75-84	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	85+												0	0		85+	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	total	0	0	0	0	0	0	0	0	0	0		0	0		Total	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
			Sex Data		Demographic Data												Age-adjusted Rates per 100,000 population
	Age	Number of deaths- Total	Number of deaths- Male	Number of deaths- Female	White-Not Hispanic	Hispanic	Black-Not Hispanic	Asian	American Indian/Alaska Native	Other	Other		State population - Total	2000 Standard population - from "Populations" tab		Age	Total	Male	Female	White-Not Hispanic	Hispanic	Black-Not Hispanic	Asian	American Indian/Alaska Native	Other	Other
	<1												0	0		<1	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	1-4												0	0		1-4	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	5-9												0	0		5-9	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	10-14												0	0		10-14	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	15-19												0	0		15-19	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	20-24												0	0		20-24	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	25-34												0	0		25-34	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	35-44												0	0		35-44	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	45-54												0	0		45-54	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	55-64												0	0		55-64	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	65-74												0	0		65-74	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	75-84												0	0		75-84	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	85+												0	0		85+	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	total	0	0	0	0	0	0	0	0	0	0		0	0		Total	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0

---

Sheet 10: Health Region Rates

Most recent data year	Data Input Tables Instructions: Enter your MVT-related injury data in the red cells below. The age-adjusted rates will automatically calculate in the results table.			Rename regions in the "Health Regions Populations" tab only. Please don't edit region names in this tab.			Optional - Right-click and select "Unhide" to see the "Table 1" tab that calculates top 5 health regions with highest hospitalization and ED visits.																Optional: Unhide columns AI through CS to show rate calculations and 2000 population weights		Columns CK through DE will then automaticall calculate age-adjusted rates per 100,000			Results Table Age Adjusted Rates per 100,1000. Results will calculate automatically.
		Region Data
	Age	Region 1	Region 2	Region 3	Region 4	Region 5	Region 6	Region 7	Region 8	Region 9	Region 10	Region 11	Region 12	Region 13	Region 14	Region 15	Region 16	Region 17	Region 18	Region 19	Region 20		State population - Total		2000 State population - from "Populations" tab		Age	Region 1	Region 2	Region 3	Region 4	Region 5	Region 6	Region 7	Region 8	Region 9	Region 10	Region 11	Region 12	Region 13	Region 14	Region 15	Region 16	Region 17	Region 18	Region 19	Region 20
	<1																						0		0		<1	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	1-4																						0		0		1-4	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	5-9																						0		0		5-9	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	10-14																						0		0		10-14	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	15-19																						0		0		15-19	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	20-24																						0		0		20-24	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	25-34																						0		0		25-34	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	35-44																						0		0		35-44	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	45-54																						0		0		45-54	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	55-64																						0		0		55-64	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	65-74																						0		0		65-74	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	75-84																						0		0		75-84	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	85+																						0		0		85+	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	total	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0		0		0		Total	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
		Rename regions in the "Health Regions" tab only
		Region Data
	Age	Region 1	Region 2	Region 3	Region 4	Region 5	Region 6	Region 7	Region 8	Region 9	Region 10	Region 11	Region 12	Region 13	Region 14	Region 15	Region 16	Region 17	Region 18	Region 19	Region 20		State population - Total		2000 State population - from "Populations" tab		Age	Region 1	Region 2	Region 3	Region 4	Region 5	Region 6	Region 7	Region 8	Region 9	Region 10	Region 11	Region 12	Region 13	Region 14	Region 15	Region 16	Region 17	Region 18	Region 19	Region 20
	<1																						0		0		<1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
	1-4																						0		0		1-4	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
	5-9																						0		0		5-9	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
	10-14																						0		0		10-14	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
	15-19																						0		0		15-19	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
	20-24																						0		0		20-24	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
	25-34																						0		0		25-34	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
	35-44																						0		0		35-44	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
	45-54																						0		0		45-54	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
	55-64																						0		0		55-64	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
	65-74																						0		0		65-74	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
	75-84																						0		0		75-84	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
	85+																						0		0		85+	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
	total	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0		0		0		Total	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0

---

Sheet 11: Optional - 2016-2020 rates

Data in this tab is optional and can be referenced to see trends in data to fill in text sections of the MVT SER PDF
This tab will automatically fill with data from the individual "2016", "2017", "2018", "2019", and "2020" tabs. The information in this tab can be used to complete the "Burden and Overview" section of the MVT Special Emphasis report. The average annual change in MVT injury age-adjusted rates per 100,000 over 5 years (not percentage change) is shown in this tab for hospitalizations, ED visits, and deaths across race/ethnicity, sex, and age groups.
Please edit years in the Populations tab, not this tab	Year 1 - Year 5 total MVT non-fatal and fatal injury rates
	Hopitalization	ED	Death
2016	0.0	0.0	0.0
2017	0.0	0.0	0.0
2018	0.0	0.0	0.0
2019	0.0	0.0	0.0
2020	0.0	0.0	0.0
	Year 1 - Year 5 hospitalization rates across age groups
age group	2016	2017	2018	2019	2020	average annual change in age-adjusted rate per 100,000 over 5 years (not percentage change)
<1	0.0	0.0	0.0	0.0	0.0	0.0
1-4	0.0	0.0	0.0	0.0	0.0	0.0
5-9	0.0	0.0	0.0	0.0	0.0	0.0
10-14	0.0	0.0	0.0	0.0	0.0	0.0
15-19	0.0	0.0	0.0	0.0	0.0	0.0
20-24	0.0	0.0	0.0	0.0	0.0	0.0
25-34	0.0	0.0	0.0	0.0	0.0	0.0
35-44	0.0	0.0	0.0	0.0	0.0	0.0
45-54	0.0	0.0	0.0	0.0	0.0	0.0
55-64	0.0	0.0	0.0	0.0	0.0	0.0
65-74	0.0	0.0	0.0	0.0	0.0	0.0
75-84	0.0	0.0	0.0	0.0	0.0	0.0
85+	0.0	0.0	0.0	0.0	0.0	0.0
	Year 1 - Year 5 ED rates across age groups
age group	2016	2017	2018	2019	2020	average annual change in age-adjusted rate per 100,000 over 5 years (not percentage change)
<1	0.0	0.0	0.0	0.0	0.0	0.0
1-4	0.0	0.0	0.0	0.0	0.0	0.0
5-9	0.0	0.0	0.0	0.0	0.0	0.0
10-14	0.0	0.0	0.0	0.0	0.0	0.0
15-19	0.0	0.0	0.0	0.0	0.0	0.0
20-24	0.0	0.0	0.0	0.0	0.0	0.0
25-34	0.0	0.0	0.0	0.0	0.0	0.0
35-44	0.0	0.0	0.0	0.0	0.0	0.0
45-54	0.0	0.0	0.0	0.0	0.0	0.0
55-64	0.0	0.0	0.0	0.0	0.0	0.0
65-74	0.0	0.0	0.0	0.0	0.0	0.0
75-84	0.0	0.0	0.0	0.0	0.0	0.0
85+	0.0	0.0	0.0	0.0	0.0	0.0
	Year 1 - Year 5 death rates across age groups
age group	2016	2017	2018	2019	2020	average annual change in age-adjusted rate per 100,000 over 5 years (not percentage change)
<1	0.0	0.0	0.0	0.0	0.0	0.0
1-4	0.0	0.0	0.0	0.0	0.0	0.0
5-9	0.0	0.0	0.0	0.0	0.0	0.0
10-14	0.0	0.0	0.0	0.0	0.0	0.0
15-19	0.0	0.0	0.0	0.0	0.0	0.0
20-24	0.0	0.0	0.0	0.0	0.0	0.0
25-34	0.0	0.0	0.0	0.0	0.0	0.0
35-44	0.0	0.0	0.0	0.0	0.0	0.0
45-54	0.0	0.0	0.0	0.0	0.0	0.0
55-64	0.0	0.0	0.0	0.0	0.0	0.0
65-74	0.0	0.0	0.0	0.0	0.0	0.0
75-84	0.0	0.0	0.0	0.0	0.0	0.0
85+	0.0	0.0	0.0	0.0	0.0	0.0
	Year 1 - Year 5 hospitalization rates across race/ethnicity and sex
	2016	2017	2018	2019	2020	average annual change in age-adjusted rate per 100,000 over 5 years (not percentage change)
White-Not Hispanic	0.0	0.0	0.0	0.0	0.0	0.0
Hispanic	0.0	0.0	0.0	0.0	0.0	0.0
Black-Not Hispanic	0.0	0.0	0.0	0.0	0.0	0.0
Asian	0.0	0.0	0.0	0.0	0.0	0.0
American Indian/Alaska Native	0.0	0.0	0.0	0.0	0.0	0.0
Other	0.0	0.0	0.0	0.0	0.0	0.0
Male	0.0	0.0	0.0	0.0	0.0	0.0
Female	0.0	0.0	0.0	0.0	0.0	0.0
	Year 1 - Year 5 ED rates across race/ethnicity and sex
	2016	2017	2018	2019	2020	average annual change in age-adjusted rate per 100,000 over 5 years (not percentage change)
White-Not Hispanic	0.0	0.0	0.0	0.0	0.0	0.0
Hispanic	0.0	0.0	0.0	0.0	0.0	0.0
Black-Not Hispanic	0.0	0.0	0.0	0.0	0.0	0.0
Asian	0.0	0.0	0.0	0.0	0.0	0.0
American Indian/Alaska Native	0.0	0.0	0.0	0.0	0.0	0.0
Other	0.0	0.0	0.0	0.0	0.0	0.0
Male	0.0	0.0	0.0	0.0	0.0	0.0
Female	0.0	0.0	0.0	0.0	0.0	0.0
	Year 1 - Year 5 death rates across race/ethnicity and sex
	2016	2017	2018	2019	2020	average annual change in age-adjusted rate per 100,000 over 5 years (not percentage change)
White-Not Hispanic	0.0	0.0	0.0	0.0	0.0	0.0
Hispanic	0.0	0.0	0.0	0.0	0.0	0.0
Black-Not Hispanic	0.0	0.0	0.0	0.0	0.0	0.0
Asian	0.0	0.0	0.0	0.0	0.0	0.0
American Indian/Alaska Native	0.0	0.0	0.0	0.0	0.0	0.0
Other	0.0	0.0	0.0	0.0	0.0	0.0
Male	0.0	0.0	0.0	0.0	0.0	0.0
Female	0.0	0.0	0.0	0.0	0.0	0.0

---

Sheet 12: Figure 1

Please enter ED Visits, Hospitalizations, and Fatalities for the most recent data year in row 6 to populate the pyramid
		ED Visits	Hospitalizations	Fatalities
	Item	58000	22315	32000

---

Sheet 13: Figure 2

Years 2009-2015 can be edit in column B given your dataset. Data for years 2016-2020 will automatically populate with years from the "Populations" tab. Figure 2 reflects MVT fatality rates over 10 years.
Year	Year label - modify years in this column to reflect in graph	Please enter fatality rates for each year to reflect in the graph. These rates can be age-adjusted if the data is available.	data year label
1	2009		0
2	2010		0
3	2011		0
4	2012		0
5	2013		0
6	2014		0
7	2015		0
8	2016		0
9	2017		0
10	2018		0
11	2019		0
12	2020		0

---

Sheet 14: Figure 3

FIGURE 3: Percent of Unintentional MTV Injuries by Type of Person, (Years, State)
The type of person type can be modified in rows A7, A8, A9, and A10 if necessary		Please enter fatality, hospitalization, and ED visit data in Rows 6 through 10
Number by person type
	Deaths	Hospitalizations	ED Visits
Occupant / Unspecified	2	6	5
Motorcyclist	3	9	15
Pedestrian	12	14	13
Pedal cyclist	5	6	7
Other	11	13	9
TOTAL	33	48	49
Percent by person type
	Deaths	Hospitalizations	ED Visits
Occupant / Unspecified	6.1	12.5	10.2
Motorcyclist	9.1	18.8	30.6
Pedestrian	36.4	29.2	26.5
Pedal cyclist	15.2	12.5	14.3
Other	33.3	27.1	18.4
TOTAL	100.0%	100.0%	100.0%
Please do not edit data in rows 27 through 29, they will autofill with data from rows 6 through 10
Values are shown as percentages	Occupant / Unspecified	Motorcyclist	Pedestrian	Pedal cyclist	Other
ED Visits	10.2	30.6	26.5	14.3	18.4
Hospitalizations	12.5	18.8	29.2	12.5	27.1
Fatalities	6.1	9.1	36.4	15.2	33.3

---

Sheet 15: Figure 4

Figure 4: Death or Non-fatal Unintentional Motor Vehicle Traffic-Occupant Injuries by Sex
Enter data in the tables below to populate graphs for Figure 4. States can select which graph they would like to include for Figure 4.
Death rates	total	male	female
2000
2001
2002
2003
2004
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018				2016-2020 hospitalization, ED visit, and death rates can be pulled from either "Totals" tab or "2016", "2017", "2018", "2019", and "2019" tabs
2019
2020
Hospitalizations rates	total	male	female
2016
2017
2018
2019
2020
ED Visits rates	total	male	female
2016
2017
2018
2019
2020

---

Sheet 16: Figure 5

Figure 5 - Please use the populations for these age groups to calculate age-specific hospitalization rates for data years you would like to include in the Figure 5 graph. Years in row 3 can be edited to reflect the data years you would like to see in the Figure 5 graph.
age group	2016	2017	2018	2019	2020
0-14
15-19
20-24
25-44
45-64
65+

---

Sheet 17: Figure 6

Modify race/ethnicity groups as needed below			Enter hospitalization rates for most recent data year. Rates can be pulled from the "Totals" tab, "2016" tab, "2017" tab, "2018" tab, "2019" tab, or "2020" tab
White-Not Hispanic	1
Hispanic	2
Black-Not Hispanic	3
Asian	4
American Indian/Alaska Native	5
Other	6
Other	7

---

Sheet 18: Quick Facts

The links below can be used to compile information for the Quick Facts section on Page 2 of the MVT Special Emphasis Report
MVT State Facts:		Data Source:	Web Link:	Sub-category	Table	Comments
Percent of State/Region drivers wearing seat belts		Fatal Analysis Reporting System (FARS)	https://cdan.nhtsa.gov/stsi.htm	State Traffic Safety Information (STSI)	Table: Traffic Safety Performance (Core Outcome) Measures	Website also includes county data
Percent of State/Region driver fatalities not restrained		Fatal Analysis Reporting System (FARS)	https://cdan.nhtsa.gov/tsftables/tsfar.htm	Traffic Safety Facts Annual Report Tables (TSFAR)	Table 84: Drivers Involved in Crashes, by Vehicle Type, Restraint Use, and Crash Severity, 2017	Located within “People – Restraints”
Number of lives saved if 100% of drivers wore seat belts		Fatal Analysis Reporting System (FARS)	https://cdan.nhtsa.gov/stsi.htm	State Traffic Safety Information (STSI)	Table: (State) Passenger Vehicle Occupant Fatalities by Restraint Use and Lives Saved Estimates (Ages 5+)
Percent of fatal drivers with BAC higher than .08		Fatal Analysis Reporting System (FARS)	https://cdan.nhtsa.gov/stsi.htm	State Traffic Safety Information (STSI)	Table: Alcohol-Impaired Driving Fatalities
Percent of seat belt use among teens (see below footnotes)		Youth Risk Behavioral Survey (YRBS)	https://www.cdc.gov/healthyyouth/data/yrbs	State Data can be downloaded		Check state public health department for reports
How many times did you ride with someone whose been drinking? (Percentage)		Youth Risk Behavioral Survey (YRBS)	https://www.cdc.gov/healthyyouth/data/yrbs	State Data can be downloaded
How many times did you text or e-mail? (Percentage)		Youth Risk Behavioral Survey (YRBS)	https://www.cdc.gov/healthyyouth/data/yrbs	State Data can be downloaded
Lifetime cost of MVT injuries in <State/Region>		National Center for Health Statistics (NCHS)	https://www.cdc.gov/injury/wisqars	Cost of Injury Data
Can also include whether your state has a primary or secondary seat belt law.		Governors Highway Safety Administration (GHSA)	https://www.ghsa.org/state-laws	All states have laws governing various driver behaviors, from distracted driving to motorcyle helmet use		Drop down menus by State and Topic
YRBS: 2017/2019 Youth Behavioral Survey provides seat belt use; driving and drinking (YRBS), rode w/driver who had been drinking (YRBS).
YRBS also has texting and marijuana driving questions too.
Please use percentages to report YRBS teen data
Q1) How often do you wear a seat belt when riding in a car driven by someone else?
Options: Never, Rarely, Sometimes, Most of the time, Always
Q2) During the past 30 days, how many times did you ride in a car or other vehicle driven by someone who had been drinking alcohol (0, 1, 2 or 3, 4 or 5, 6+).
Options: 0, 1, 2 or 3, 4 or 5, 6+
Q3) During the past 30 days, on how many days did you text or e-mail while driving a car or other vehicle
Options: I did not drive a car or other vehicle during the past 30 days, 0 days, 1 or 2 days, 3 to 5 days, 6 to 9 days, 10 to 19 days, 20 to 29 days, All 30 days

---

Sheet 19: Report

State
Data Year	2020																	Occupants percentage of deaths	6.1
							Occupants percentage of hospitalizations											12.5
							Occupants percentage of ED visits											10.2
																				This table shows data for your most recent year. Cells are populated with counts and rates calculated in the "Health Region Rates" tab.		Top 5 Regions for Hospitalizations	Hospitalization count	Age-adjusted hospitalization rate per 100k People	Top 5 Regions for ED Visits	ED visit count	Age-adjusted ED visit rate per 100k People
																					Region 1	0	0	Region 1	0	0
																					Region 2	0	0	Region 2	0	0
																					Region 3	0	0	Region 3	0	0
																					Region 4	0	0	Region 4	0	0
																					Region 5	0	0	Region 5	0	0