Collapse All

November 26, 2018


The E-Rate Central News for the Week is prepared by E-Rate Central. E-Rate Central specializes in providing consulting, compliance, and forms processing services to E-rate applicants. To learn more about our services, please contact us by phone (516-801-7804), fax (516-801-7814), or through our Contact Us web form. Additional E-rate information is located on the E-Rate Central website.

FY 2018:

USAC issued Wave 33 on Wednesday, November 21st.  Cumulative funding as of Wave 33 is $1.92 billion.

FY 2019:

The FY 2019 administrative window is open and will remain open until at least January 7th.  EPC entity profiles will be locked for the duration of the Form 471 application window (expected to open mid-January).

Identifying Form 470 Category 1 Service Option Errors:

Last week’s newsletter dated November 19th noted that Form 470s for FY 2019 are still reflecting confusion on the part of some applicants regarding the proper use of the Category 1 pulldown menu options for requesting Internet and/or transmission services.  Although Form 470 problems are ultimately the individual applicants’ responsibility, it may be helpful for state and regional E‑rate coordinators to identify likely Form 470 errors and to encourage applicants to refile corrected Form 470s.

The most common problem we’re seeing is among smaller applicants that are requesting Internet access,  typically via cable modem services.  Too many Form 470s are requesting “Internet Access: ISP Service Only (No Transport Circuit included)” without any requests covering the associated circuit costs themselves.  With the growing number of filings for FY 2019, finding and reviewing Form 470s requesting only ISP service is not a trivial exercise for state or regional coordinators.

Here’s one way to manipulate USAC’s database to highlight applicants requesting only ISP service:

  1. Download the state’s list of Form 470s posted for FY 2019 using USAC’s Download 470 Information (FY2016 and later).  To focus only on potential Internet posting problems, constrain the download (in Excel) to Category 1 “Data Transmission and/or Internet Access” service types.

  2. The download file contains a wealth of Form 470 data with one row per “Function” request and multiple columns.  For ease of use — reflected in the examples below — you may want to “Hide” unneccesary columns.
  3. Sort the file by Billed Entity Name.  If an entity has filed more than one Form 470, the sort will group the entity’s Form 470s together.
  4. Insert a column (the new Col. S in the following example) and add the following Excel formula to each data cell in that column:


    Note that the first argument in this formula covers the full fixed range of applicant names from Row 2 down to the end of the rows (in this case Row 335).  The formula will count the number of rows (i.e., the number of “Function” requests made by each applicant).  Applicant 10661, for example, has two requests.


  5. To easily find applicants only requesting “Internet Access:  ISP Service Only (No Transport Circuit included),” filter the spreadsheet for:
    1. Entities with only one request (as shown in Col. S); and

    2. Requests for ISP Service Only (as shown in Col. U).

  6. Resulting in the following list of applicants with potentially misleading Form 470s:

State and regional E-rate coordinators may wish to reach out to these applicants to review their full Internet requirements and to make sure that their Form 470s are properly posted.

Upcoming E-Rate Dates:

November 26 Form 486 deadline for FY 2018 funding committed in Wave 16.  More generally, the Form 486 deadline is 120 days from the FCDL date or the service start date (typically July 1st), whichever is later.  Other FY 2018 Form 486 deadlines this year are:

Wave 17            12/03/2018
Wave 18            12/10/2018
Wave 19            12/17/2018
Wave 20            12/24/2018
Wave 21            12/31/2018

Note:  Applicants missing any Form 486 deadline should watch carefully for “Form 486 Urgent Reminder Letters” in their EPC News Feed.  These Reminder Letters afford applicants 15-day extensions to submit their Form 486s without penalty (see last week’s USAC News Brief references below).

November 28-29   Next in the series of two-day USAC annual fall training workshops in Atlanta, GA.  Full-day Tribal workshops will also be held November 28th in Spokane, WA, and November 30th in Farmington, NM.

USAC did not issue a Schools and Libraries Program News Brief on Friday, November 23rd, due to the Thanksgiving holiday.