Template Name: SLFRF Broadband Location Template — Instructions to Reporter — - Do not change the cell formatting

Summary

The Treasury's SLFRF Broadband Location Template, Version 2023.5.25, a reporting spreadsheet for SLFRF-funded broadband projects. Instructions tell reporters not to change the formatting, to enter all data as text from row 8, and to download the .xlsx from the portal, save it as .csv and upload the populated file. Fields follow, each with help text: the FCC Fabric ID of the broadband serviceable location, its latitude and longitude, the FCC-issued provider ID, technology type (Fiber, Coaxial Cable, Terrestrial Fixed Wireless or Other), location type (Residential, Business or Community Anchor Institution), housing units, speed before investment, and maximum download and upload speeds offered and delivered and latency after investment, confirmed by speed tests at the location under the FCC's Performance Measures Order, 33 FCC Rcd 6509.

Summary drafted by a model from the document's text below and checked by script against that text before publication. It is a navigation aid, not a reading of what the document proves. Where AI is used

Full text

Text extracted from the spreadsheet file: one line per row, cells separated by tabs, each sheet headed by its name. Numbers appear as stored, without the workbook’s formatting.

Sheet: Sheet1
Version: 2023.5.25
Template Name: SLFRF Broadband Location Template
Instructions to Reporter: - Do not change the cell formatting - Do not reformat the template - All data should be as text  - Enter your data starting on row 8 - Prior to populating the template with data: a: download the .xlsx file from the portal b: open the file c: save the template as .csv file and rename the file as needed d: populate your data in the .csv file, save the file, and upload the .csv file to the portal
Field ID	Fabric_ID_Number__c	Latitude__c	Longitude__c	Provider_ID__c	Technology_Type_at_Location__c	Technology_Type_Other__c	Location_Type__c	Housing_Units_at_Location__c	Speed_Pre_Investment__c	Max_Download_Speed_Offered__c	Max_Download_Speed_Delivered__c	Max_Upload_Speed_Offered__c	Max_Upload_Speed_Delivered__c	Latency_Delivered_at_Location__c
Required/Optional	Required	Required	Required	Required	Required	Conditional	Required	Conditional	Required	Required	Required	Required	Required	Required
Field Name	Fabric ID Number	Location Latitude	Location Longitude	FCC Issued Provider ID #	Technology Type at Location	if Other, Specify (Actual)	Location Type	Housing Units at Location	Speed Pre-Investment	Maximum Download Speed Offered at Location Post-Investment	Maximum Download Speed Delivered at Location Post-Investment	Maximum Upload Speed Offered at Location Post-Investment	Maximum Upload Speed Delivered at Location Post-Investment	Latency Delivered at Location Post-Investment
Help Text	Enter the site specific fabric identification number (Fabric ID) from the FCC broadband funded locations map that corresponds with the location in the field provided. This is the Broadband Serviceable Fabric Location (Max length - 20 characters)	Enter the latitude data for the location to which service is installed.  The highly preferred and Treasury-encouraged method for generating latitude/longitude data for each location to which service is to be installed is through the use of a commercially available GPS-encoded device physically present at the location. More guidance regarding this preferred method, Geolocation with GPS in the Field, can be found in Geolocation Methods (https://www.usac.org/wp-content/uploads/high-cost/documents/Tools/HUBBGeolocationMethods.pdf).  The latitude/longitude data for each location to which service is designed to be installed should be situated at the structure that is the broadband serviceable location.	Enter the longitude data for the location to which service is installed.  The highly preferred and Treasury-encouraged method for generating latitude/longitude data for each location to which service is to be installed is through the use of a commercially available GPS-encoded device physically present at the location. More guidance regarding this preferred method, Geolocation with GPS in the Field, can be found in Geolocation Methods (https://www.usac.org/wp-content/uploads/high-cost/documents/Tools/HUBBGeolocationMethods.pdf).  The latitude/longitude data for each location to which service is designed to be installed should be situated at the structure that is the broadband serviceable location.	The FCC-provided ID that will align with the entity that files or will file Broadband Data Collection data	Please select one of the following options from the following picklist:       "Fiber" "Coaxial Cable" "Terrestrial Fixed Wireless" "Other" If Project Status has a value of "Other", recipients will be prompted to respond to the next question.	If Other is selected from the picklist, please explain in the textbox provided.	Please select one of the following options from the following picklist:             "Residential" "Business" "Community Anchor Institution"  Specific definitions of each type can be found in the Compliance and Reporting Guidance User Guide.	If Location_Category_Type is equal to 1. Residential, provide the number of housing units at this location.	Select one of the following options from a picklist: "Below 25/3 Mbps" "25/3 Mbps or greater but less than 100/20 Mbps"	Provide the maximum download speed offered/advertised at this location.	Provide the maximum download speed delivered at this location as confirmed by speed tests at the location, conducted upon completion of the construction and initiation of operations. Speed tests should be conducted in a manner consistent with industry best practices to account for the actual speeds delivered during peak use times in the given area.  More details regarding the required approach for gathering maximum download speed delivered can be found in the Connect America Fund, WC Docket No. 10-90, Order, 33 FCC Rcd 6509 (WCB/WTB/OET 2018) (Performance Measures Order); Connect America Fund, Order on Reconsideration, WC Docket No. 10-90, 34 FCC Rcd 10109 (2019) (Performance Measures Reconsideration Order).	Provide the maximum upload speed offered/advertised at this location.	Provide the maximum upload speed delivered at this location as confirmed by speed tests at the location, conducted upon completion of the construction and initiation of operations. Speed tests should be conducted in a manner consistent with industry best practices to account for the actual speeds delivered during peak use times in the given area.  More details regarding the required approach for gathering maximum upload speed delivered can be found in the Connect America Fund, WC Docket No. 10-90, Order, 33 FCC Rcd 6509 (WCB/WTB/OET 2018) (Performance Measures Order); Connect America Fund, Order on Reconsideration, WC Docket No. 10-90, 34 FCC Rcd 10109 (2019) (Performance Measures Reconsideration Order).	Provide data describing latency at this location as confirmed by latency tests at the location, conducted upon completion of the construction and initiation of operations.  More details regarding the required approach for gathering latency data can be found in the Connect America Fund, WC Docket No. 10-90, Order, 33 FCC Rcd 6509 (WCB/WTB/OET 2018) (Performance Measures Order); Connect America Fund, Order on Reconsideration, WC Docket No. 10-90, 34 FCC Rcd 10109 (2019) (Performance Measures Reconsideration Order).

File and source

File

department-of-the-treasury-updated-broadband-template-home-treasury-gov-dd29d195aa.xlsx

Size

12,695 bytes

SHA-256

b4251359c28ba6c23196cd61433e720094d7ca1352fa999bfa6d4ffd113f5790

Our copy

department-of-the-treasury-updated-broadband-template-home-treasury-gov-dd29d195aa.xlsx

Original

home.treasury.gov