FY2026 DLT SAMPLE Worksheets.xlsm

XLSM spreadsheet 402 KB Posted May 1, 2026

Attached to: Distance Learning and Telemedicine Grants
Opportunity number: RUS-26-01-DLT
Issued by: Department of Agriculture Rural Housing Service Washington Office Rural Utilities Services

About this file

Written by GovTribe AI · May 2, 2026

This file is a FY2026 Distance Learning and Telemedicine (DLT) Grants sample worksheets file in Excel format (.xlsm) designed to assist applicants in preparing budget and financial documentation for their grant applications. The worksheets serve as templates to help applicants organize and calculate project costs, match contributions, and other financial data required by the USDA Rural Utilities Service for the DLT Grant Program. These sample worksheets are intended to guide applicants through the financial planning process in compliance with the FY 2026 DLT Grant Program Application Guide requirements. The file supports applications for grants ranging from $50,000 to $1,000,000, with a deadline of March 6, 2025, and approximately $40 million in total funding available. Applicants must provide a minimum 15 percent matching contribution and will be evaluated based on rurality, economic need, service need and benefits, and special considerations such as serving distressed or tribal communities. The program, authorized under 7 U.S.C. 950aaa and regulated by 7 CFR Part 1734, funds telecommunications-enabled equipment and infrastructure to extend distance learning and telemedicine services to rural areas with populations under 20,000. Eligible applicants include small businesses, higher education institutions, county and local governments, independent school districts, nonprofit organizations, tribal governments, and state governments that are not RUS electric or telecommunications borrowers and are not delinquent on federal debt.

From the source

FY2026 DLT Worksheets

View the file

Other files

File	Type	Posted
FY2026 DLT Checklist.pdf	PDF	May 1, 2026
FY2026 DLT Application Guide.pdf	PDF	May 1, 2026
FY2026 DLT NOFO.pdf	PDF	May 1, 2026

On GovTribe

Work with this file

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

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Help – SAMPLE Workbook

How to Navigate the SAMPLE Worksheets to Input Project Details

The SAMPLE Workbook consists of five SAMPLE Worksheets (1) Description of Project Sites, (2) Rurality Calculation, (3) Economic Need Calculation, (4) Match Calculation and (5) Line-Item Budget. The use of the workbook can assist applicants with submitting complete and consistent project information. For the best results, complete each tab, beginning with Description of Project Sites.

If there are any questions regarding the context of required data, please refer to the FY2026 Application Guide and your Local General Field Representative.

It is strongly recommended that the SAMPLE Workbook be submitted as a single Excel file.

Do not submit worksheets as separate documents, and do not convert the worksheets to PDF or Word format.

SAMPLE Worksheets

Description of Project Sites

Rurality Calculation

Economic Need Calculation

Match Calculation

Budget

Completing the Description of Project Sites Tab

1. Enter the details for each participating hub, end user, or hub/end-user site.

2. Add or remove rows as needed using the Insert Row or Delete Row buttons at the top of the worksheet.

• “Insert Row" will add the specified number of rows below the active cell.

• “Delete Row” allows you to specify the number of rows you would like to remove and select whether you would like to delete rows above or below the active cell.

Refer to Section B and Appendix A of the Application Guide for additional guidance.

Completing the Rurality Calculation Tab

Columns A–D populate automatically based on the entries in the Description of Project Sites tab.

Note: Sites cannot be added or deleted on this tab. All changes must be made on the Description of Project Sites tab.

1. Enter the following for each site:

• Census Population (Column E)

• Is Site Contiguous to a City or Town > 50,000? (Column F)

• Name of Urban City or Town (Column G), if applicable

2. The worksheet will calculate the Rurality Score (Column H).

3. Calculate and enter the Project’s Estimated Rurality Score.

Refer to Section D, pages 14-16, and Appendix B of the Application Guide for additional guidance.

Completing the Economic Need Calculation Tab

Columns A–D populate automatically from the Description of Project Sites tab

Note: Sites cannot be added or deleted on this tab. All changes must be made on the Description of Project Sites tab.

1. Enter SAIPE data (Column E) according to the FY2026 Application Guide

2. The worksheet will calculate the Economic Score (Column F).

3. Calculate and enter the Project's Economic Need Score.

Refer to Section D, pages 17-18, and Appendix B of the Application Guide for additional guidance.

Completing the Match Calculation Tab

Refer to Section E, pages 20-23, of the Application Guide for additional guidance.

The worksheet will automatically populate: (non-editable cells)

• Total Proposed Matching Contribution (from Cash and In Kind amounts)

• Total DLT Grant Request (after the Budget tab entry is completed)

• Match Percent (based on the above values)

Note: If additional rows are needed, right‑click an Excel row and choose Insert from the list.

Completing the Budget Tab

Refer to Section F, pages 23-24, of the Application Guide for additional guidance

1. Enter the following information:

• Site Number (Column B)

• Description of Equipment (Column D)

• Unit Cost (Column E)

• Number of Units (Column F)

Note: Rows may be added or deleted using the “Insert Row” and/or “Delete Row” buttons found on the top of the worksheet.

• "Insert Row" will add the specified number of rows below the active cell.

• "Delete Row" allows you to specify the number of rows you would like to remove,

and select whether you would like to delete rows above or below the active cell

2. The worksheet will automcatically calculate the following: (non-editabele cells)

• Site Name (Column C)

• Extended Costs (Column G)

• Total Grant and Cash Match

• Total In-Kind

• Overall DLT Project Budget

• Less Proposed Cash Match (from Match Calculation tab)

• Less In-Kind Match

• DLT Grant Request

Description of Project Sites

SAMPLE Description of Project Sites Worksheet
Applicant's Legal Name
Site Number	Site Name	Site Designation

(Hub; End-User;Hub/End-User) (select from drop-down) Street Address Town County State 5 Digit ZIP Congressional District # Rural Residents Served at each Hub/End-User or End-User Site

Hub Site: A hub site is a facility that is part of a network or telecommunications system that provides educational or medical services to end-user sites. A pure hub receives no end-user benefits. The site is usually a connection management point or is exclusively an educational or medical source of distance learning or telemedicine. Hub sites located in non-rural areas are not eligible for grant assistance unless they are necessary to provide DLT services to rural residents at end-user sites.

End-User Site: An end-user site is a facility that is part of a network or telecommunications system that is utilized by end-users. For a site to be included as an end-user site for scoring purposes, the applicant must demonstrate equipment purchased will be installed or placed at the site.

Hub/End-User Site: performs both functions; the site is the connection management point and also directly serves end-users.

Delete Row See Application Guide Section B and Appendix A for additional information.

Hub (proxy) serving non-fixed End-user: This site is the hub site that is providing service or content to a non-fixed end-user or mobile facility. This site designation should only be selected if the project is a Non-fixed or Hy-brid project.

Insert Row Delete Row

US States and Terr

Alabama

Alaska

Arizona

Arkansas

California

Colorado

Connecticut

Delaware

Florida

Georgia

Hawaii

Idaho

Illinois

Indiana

Iowa

Kansas

Kentucky

Louisiana

Maine

Maryland

Massachusetts

Michigan

Minnesota

Mississippi

Missouri

Montana

Nebraska

Nevada

New Hampshire

New Jersey

New Mexico

New York

North Carolina

North Dakota

Ohio

Oklahoma

Oregon

Pennsylvania

Rhode Island

South Carolina

South Dakota

Tennessee

Texas

Utah

Vermont

Virginia

Washington

West Virginia

Wisconsin

Wyoming

American Samoa

Guam

Northern Mariana Islands

Puerto Rico

U.S. Virgin Islands

Sites Copy

SAMPLE Description of Project Sites Worksheet
Applicant's Legal Name
Site Number	Site Name	Site Designation

(Hub; End-User;Hub/End-User) (select from drop-down) Street Address Town County State 5 Digit ZIP Congressional District # Rural Residents Served at each Hub/End-User or End-User Site

1
2
3
4
5
6
7
8

Refresh Snapshot Export

Rurality Calculation

	SAMPLE Rurality Calculation Worksheet
	Applicant's Legal Name
	Site Number	Site Name	Site Designation
(Hub, End-User, Hub/End-User)	Town or Place Name	Census Population	Is the Site in a Town contiguous to City or Town > 50,000?	Name of Urban City or Town
(if Yes, in col. F )	Rurality Score
	1
					Project's Estimated Rurality Score
			Scoring Table
			Census Population	Points			0
			EXCEPTIONALLY RURAL AREA - 5,000 or less	40		0
			RURAL AREA - 5,001-10,000	30
			MID-RURAL AREA - 10,001-20,000	20
			URBAN AREA - Over 20,000 or
Adjacent to City > 50,000	0

To determine Rurality Score:

Sum of Points for all sites with End-Users / Total # of all sites with End-Users

Total # of all sites with End-Users) Total # of all sites with End-Users) Total # of all sites with End-Users) Total # of all sites with End-Users) Total # of all sites with End-Users) Total # of all sites with End-Users) Total # of all sites with End-Users) Total # of all sites with End-Users) Total # of all sites with End-Users) Total # of all sites with End-Users) Total # of all sites with End-Users) Total # of all sites with End-Users) Total # of all sites with End-Users) Total # of all sites with End-Users) Total # of all sites with End-Users) Total # of all sites with End-Users) Total # of all sites with End-Users) Total # of all sites with End-Users) Total # of all sites with End-Users) Total # of all sites with End-Users) Total # of all sites with End-Users) Total # of all sites with End-Users) Total # of all sites with End-Users) Total # of all sites with End-Users) Total # of all sites with End-Users) Total # of all sites with End-Users) Total # of all sites with End-Users) Total # of all sites with End-Users) Total # of all sites with End-Users) Total # of all sites with End-Users) Total # of all sites with End-Users) Total # of all sites with End-Users) Total # of all sites with End-Users) Total # of all sites with End-Users) Total # of all sites with End-Users) Total # of all sites with End-Users) Total # of all sites with End-Users) Total # of all sites with End-Users) Total # of all sites with End-Users) Total # of all sites with End-Users) Total # of all sites with End-Users) Total # of all sites with End-Users) Total # of all sites with End-Users) Total # of all sites with End-Users) Total # of all sites with End-Users)

Economic Need Calculation

	SAMPLE Economic Need Calculation Worksheet
	Applicant's Legal Name
	Site Number	Site Name	Site Designation
(Hub; End-User; Hub/End-User)	County	SAIPE
Percent Poverty, All Ages	Economic Need Score
	1
				Project's Estimated Economic Score
		Scoring Table
		SAIPE County Poverty Percentage:	Points
		Poverty % < 10%	0		0	0
		Poverty % 10% ≥ but < 20%	10
		Poverty % ≥ 20% but < 30%	20
		Poverty % ≥ 30%	30	≥

To determine Economic Score:

Sum of Economic Need Points / Sum of End-User + Hub/End-User Sites

Match Calculation

	SAMPLE Match Calculation Worksheet
	Applicant's Legal Name
	Name of Entity Providing Donor
(Documentation Letter from each donor must be provided)	Amount of Proposed Cash ($)	Amount of Proposed In-Kind ($)

1. Total Proposed Matching Contribution (must equal Line B + Line C in the Budget Worksheet)	$ - 0	$ - 0	$ - 0
2. Total DLT Grant Request (Must equal Line D in the Budget Worksheet)			$ - 0
Match Percent (Line 1 ÷ Line 2), must be at least 15% of Grant Request

Budget

			SAMPLE Line-Item Budget Worksheet				Do Not Delete
			Applicant's Legal Name				Do Not Delete
(Insert additional rows as needed)							Do Not Delete
Items being funded by Grant and Cash Match							Do Not Delete
Line Item #	Site Number	Site Name	Description of Equipment	Unit Cost	# of Units	Extended Costs	Do Not Delete
1						$ - 0
2						$ - 0
3						$ - 0
4						$ - 0
5						$ - 0
6						$ - 0
7						$ - 0
8						$ - 0
9						$ - 0
10						$ - 0
11						$ - 0
12						$ - 0
13						$ - 0
14						$ - 0
15						$ - 0
16						$ - 0
17						$ - 0
18						$ - 0
19						$ - 0
20						$ - 0
21						$ - 0
22						$ - 0
23						$ - 0
24						$ - 0
25						$ - 0
26						$ - 0
27						$ - 0
28						$ - 0
29						$ - 0
30						$ - 0
31						$ - 0
32						$ - 0
33						$ - 0
34						$ - 0
35						$ - 0
36						$ - 0
37						$ - 0
38						$ - 0
39						$ - 0
40						$ - 0
41						$ - 0
42						$ - 0
43						$ - 0
44						$ - 0
45						$ - 0
46						$ - 0
47						$ - 0
48						$ - 0
49						$ - 0
50						$ - 0
Total Grant and Cash Match						- 0	Do Not Delete
Items being Funded by In-Kind							Do Not Delete
Line Item #	Site Number	Site Name	Description of Equipment	Unit Cost	# of Units	Extended Costs	Do Not Delete
1						$ - 0
						$ - 0
1						$ - 0
2						$ - 0
3						$ - 0
4						$ - 0
5						$ - 0
6						$ - 0
7						$ - 0
8						$ - 0
Total In-Kind Match						0.00	Do Not Delete
A		Overall DLT Project Budget (Sum of Total Grant & Cash Match and Total In-Kind Match)				$ - 0	Do Not Delete
B		Less Proposed Cash Match (As documented on Match Calculation Worksheet)				$ - 0	Do Not Delete
C		Less In-Kind Match				$ - 0	Do Not Delete
D		DLT Grant Request (A-B-C)				$ - 0	Do Not Delete
					Grant to Match % (minimum of 15% required)		Do Not Delete

Insert Row Delete Row

Budget Copy

			SAMPLE Line-Item Budget Worksheet				Do Not Delete
			Applicant's Legal Name				Do Not Delete
(Insert additional rows as needed)							Do Not Delete
Items being funded by Grant and Cash Match							Do Not Delete
Line Item #	Site Number	Site Name	Description of Equipment	Unit Cost	# of Units	Extended Costs	Do Not Delete
1						$ - 0
2						$ - 0
3						$ - 0
4						$ - 0
5						$ - 0
6						$ - 0
7						$ - 0
8						$ - 0
9						$ - 0
10						$ - 0
11						$ - 0
12						$ - 0
13						$ - 0
14						$ - 0
15						$ - 0
16						$ - 0
17						$ - 0
18						$ - 0
19						$ - 0
20						$ - 0
21						$ - 0
22						$ - 0
23						$ - 0
24						$ - 0
25						$ - 0
26						$ - 0
27						$ - 0
28						$ - 0
29						$ - 0
30						$ - 0
31						$ - 0
32						$ - 0
33						$ - 0
34						$ - 0
35						$ - 0
36						$ - 0
37						$ - 0
38						$ - 0
39						$ - 0
40						$ - 0
41						$ - 0
42						$ - 0
43						$ - 0
44						$ - 0
45						$ - 0
46						$ - 0
47						$ - 0
48						$ - 0
49						$ - 0
50						$ - 0
Total Grant and Cash Match						$ - 0	Do Not Delete
Items being Funded by In-Kind							Do Not Delete
Line Item #	Site Number	Site Name	Description	Unit Cost	# of Units	Extended Costs	Do Not Delete
1						$ - 0
2						$ - 0
3						$ - 0
4						$ - 0
5						$ - 0
6						$ - 0
7						$ - 0
8						$ - 0
9						$ - 0
10						$ - 0
11						$ - 0
12						$ - 0
13						$ - 0
14						$ - 0
15						$ - 0
16						$ - 0
17						$ - 0
18						$ - 0
19						$ - 0
20						$ - 0
					Total In-Kind Match	$ - 0	Do Not Delete
A		Overall DLT Project Budget (Sum of Total Grant & Cash Match and Total In-Kind Match)				$ - 0	Do Not Delete
B		Less Proposed Cash Match (As documented on Match Calculation Worksheet)				$ - 0	Do Not Delete
C		Less In-Kind Match				$ - 0	Do Not Delete
D		DLT Grant Request (A-B-C)				$ - 0	Do Not Delete
					Grant to Match % (minimum of 15% required)		Do Not Delete

Refresh Export

File details come from the government source that posted it. Updated May 2, 2026.