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
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
| File | Type | Posted |
|---|---|---|
| Law Enforcement Grant Application & Instructions (exp.11-30-2024).pdf |
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 | |
| 2019 | ERROR:#DIV/0! | ERROR:#DIV/0! | |
| 2020 | ERROR:#DIV/0! | ERROR:#DIV/0! | |
| 2021 | ERROR:#DIV/0! | ERROR:#DIV/0! | |
| 2022 | ERROR:#DIV/0! | ERROR:#DIV/0! | |
| 2023 | ERROR:#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 SLOPE | FATALITY TRENDLINE | |
| ERROR:#VALUE! | 2019 | ERROR:#VALUE! |
| FATALITY INTERCEPT | 2020 | ERROR:#VALUE! |
| ERROR:#DIV/0! | 2021 | ERROR:#VALUE! |
| 2022 | ERROR:#VALUE! | |
| 2023 | ERROR:#VALUE! | |
| 2024 | ERROR:#VALUE! | |
| 2025 | ERROR:#VALUE! | |
| 2026 | ERROR:#VALUE! |
| 4-year | 0.83 | ||
| FATALITY SLOPE | FATALITY TRENDLINE | ||
| ERROR:#VALUE! | 2020 | ERROR:#VALUE! | |
| FATALITY INTERCEPT | 2021 | ERROR:#VALUE! | |
| ERROR:#DIV/0! | 2022 | ERROR:#VALUE! | |
| 2023 | ERROR:#VALUE! | ||
| 2024 | ERROR:#VALUE! | ||
| 2025 | ERROR:#VALUE! | ||
| 2026 | ERROR:#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
| 2020 | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | Trend | ||||||
| 2020 | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Annual Counts
3-Yr Alt Baseline Calculation
| Alternative Baseline Calculation: 3-Year Baseline Period | |||||||
| Baseline Period | Comparison 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) | 0 | ERROR:#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 Base | 2026 Projection | |
| (2021-2023) avg. | ERROR:#DIV/0! | ERROR:#DIV/0! |
5-Yr Alt Baseline Calculation
| Alternative Baseline Calculation: 5-Year Baseline Period | |||||||
| Baseline Period | Comparison 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 Base | 2026 Projection | |
| (2019-2023) avg. | ERROR:#DIV/0! | ? |
File details come from the government source that posted it. Updated .