Linear TrendAnalysisTool_temp Law Enforcement Attachment.xlsx

XLSX spreadsheet 40 KB Posted

Attached to
Indian Highway Safety Law Enforcement Grants
Opportunity number
BIA-IHSP-2024-003
Issued by

About this file

The document is a Microsoft Excel file containing a Linear Trend Analysis Tool template for a federal grant opportunity related to Indian Highway Safety Law Enforcement Grants. The template is meant to be used to track and analyze traffic safety data over a ten-year period, including annual counts, 3-year and 5-year moving averages, and linear trend analysis. The related federal grant opportunity is solicitation number BIA-IHSP-2024-003, which is administered by the Department of the Interior Bureau of Indian Affairs and Indian Education under the State and Community Highway Safety federal grant program (CFDA 20.600). The grant is intended to support traffic safety programs and projects to reduce crashes, deaths, injuries, and property damage within tribal populations. The grant application does not require submission of the Linear Trend Analysis Tool; it is only intended to be used internally to track and analyze the data.

Linear Trend Analysis

View the file

Other files

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Data Entry Sheet

Year Annual Count 3-Yr Moving Avg 5-Yr Moving Avg

Only Submit the Data Entry Sheet
ERROR:#DIV/0!ERROR:#DIV/0!with grant application
ERROR:#DIV/0!ERROR:#DIV/0!for each grant target
2019ERROR:#DIV/0!ERROR:#DIV/0!
2020ERROR:#DIV/0!ERROR:#DIV/0!
2021ERROR:#DIV/0!ERROR:#DIV/0!
2022ERROR:#DIV/0!ERROR:#DIV/0!
2023ERROR:#DIV/0!ERROR:#DIV/0!
2024
2025
2026
2027

Update years and event counts by replacing existing data to maintain a ten-year span. Udate the title

**Be sure to replace existing data. Do not move cells; this will cause errors in calculations!
Click on the tabs below to see your new charts and calculations

Annual and Moving Avg Chart

Annual Count 2019 2020 2021 2022 2023 2024 2025 2026 3-Yr Moving Avg 2019 2020 2021 2022 2023 2024 2025 2026 0 0 0 0 0 0 0 5-Yr Moving Avg 2019 2020 2021 2022 2023 2024 2025 2026 0 0 0 0 0 0 0

ChartSheet

5- yr
FATALITY SLOPEFATALITY TRENDLINE
ERROR:#VALUE!2019ERROR:#VALUE!
FATALITY INTERCEPT2020ERROR:#VALUE!
ERROR:#DIV/0!2021ERROR:#VALUE!
2022ERROR:#VALUE!
2023ERROR:#VALUE!
2024ERROR:#VALUE!
2025ERROR:#VALUE!
2026ERROR:#VALUE!
4-year0.83
FATALITY SLOPEFATALITY TRENDLINE
ERROR:#VALUE!2020ERROR:#VALUE!
FATALITY INTERCEPT2021ERROR:#VALUE!
ERROR:#DIV/0!2022ERROR:#VALUE!
2023ERROR:#VALUE!
2024ERROR:#VALUE!
2025ERROR:#VALUE!
2026ERROR:#VALUE!

5-Yr Linear Trend Chart

Linear Trend Analysis 5 Most Recent Years Annual Count 2019 2020 2021 2022 2023 2024 2025 2026 Trend

0 0 0 0 0 0 0 0 Annual Counts

4-Yr Linear Trend Chart

Linear Trend Analysis 4 Most Recent Years Annual Count

2020202120222023202420252026Trend
20202021202220232024202520260000000

Annual Counts

3-Yr Alt Baseline Calculation

Alternative Baseline Calculation: 3-Year Baseline Period
Baseline PeriodComparison Year% Change
(Multi-year average
calculated from annual data)(3 years later than last year in multi-year baseline period)(Comparison year versus baseline period)
(-) avg.ERROR:#DIV/0!(2021)0ERROR:#DIV/0!

(-2019) avg. ERROR:#DIV/0! (2022) 0 ERROR:#DIV/0!

(-2020) avg. ERROR:#DIV/0! (2023) 0 ERROR:#DIV/0!

Average % Change ERROR:#DIV/0!

Current Multi-Year Base2026 Projection
(2021-2023) avg.ERROR:#DIV/0!ERROR:#DIV/0!

5-Yr Alt Baseline Calculation

Alternative Baseline Calculation: 5-Year Baseline Period
Baseline PeriodComparison Year% Change
(Multi-year average
calculated from annual data)(3 years later than last year in multi-year baseline period)(Comparison year versus baseline period)
(-) avg.?(2021)0?

(-2019) avg. ? (2022) 0 ?

(-2020) avg. ? (2023) 0 ?

Average % Change ?

Current Multi-Year Base2026 Projection
(2019-2023) avg.ERROR:#DIV/0!?

File details come from the government source that posted it. Updated .