{"id":34194,"date":"2022-04-08T01:06:04","date_gmt":"2022-04-08T01:06:04","guid":{"rendered":"http:\/\/e-ratepaorg.local\/?p=34194"},"modified":"2022-04-11T01:10:28","modified_gmt":"2022-04-11T01:10:28","slug":"e-rate-next-stepsfy-2022-data-analysis","status":"publish","type":"post","link":"https:\/\/e-ratepa.org\/?p=34194","title":{"rendered":"E-rate Next Steps\/FY 2022 Data Analysis"},"content":{"rendered":"<p><span style=\"color: #222222;\">April 8, 2022<\/span><\/p>\n<p>Attached:\u00a0<a href=\"https:\/\/e-ratepa.org\/wp-content\/uploads\/2022\/04\/Incomplete-471s-FY-2022.xlsx\" class=\"mtli_attachment mtli_xlsx\" target=\"_blank\">Incomplete 471s FY 2022<\/a><\/p>\n<p>Attached:\u00a0<a href=\"https:\/\/e-ratepa.org\/wp-content\/uploads\/2022\/04\/FRN-Simple-Data.xlsx\" class=\"mtli_attachment mtli_xlsx\" target=\"_blank\">FRN Simple Data<\/a><\/p>\n<p>Attached:\u00a0<a href=\"https:\/\/e-ratepa.org\/wp-content\/uploads\/2022\/04\/FY-2022-Form-471-Detailed-Data-as-of-April-5.xlsx\" class=\"mtli_attachment mtli_xlsx\" target=\"_blank\">FY 2022 Form 471 Detailed Data as of April 5<\/a><\/p>\n<p>Congratulations to the 911 PA schools and libraries that submitted their FY 2022 Form 471s by the E-rate deadline! \u00a0<strong><em>Outstanding job, everyone<\/em><\/strong>!<\/p>\n<p>For the E-rate data junkies among us, here\u2019s a breakdown of our stats:<\/p>\n<p><strong>Pennsylvania<\/strong>:<\/p>\n<ul>\n<li>Total Requested: $70,139,628.11\u00a0 ($69,827,232.83 in FY 2021 and $61,223,923.22 in FY 2020)<\/li>\n<li>2237 Total FRNs (2299 in FY 2021 and 2553 in FY 2020)<\/li>\n<li>1606 Form 471s (1565 in FY 2021 and 1702 in FY 2020)<\/li>\n<li>Filed by 911 PA entities (889 in FY 2021)<\/li>\n<\/ul>\n<ul>\n<li>Category 1 Requested:\u00a0 $35,884,472 ($36,124,973 in FY 2021)<\/li>\n<li>Category 1 Form 471s:\u00a0 1081 (1067 in FY 2021)<\/li>\n<li>Category 1 FRNs:\u00a0 1438 (1448 in FY 2021)<\/li>\n<li>Average Category 1 Discount:\u00a0 68%<\/li>\n<\/ul>\n<ul>\n<li>Category 2 Requested:\u00a0 $34,255,153 ($33,702,259 in FY 2021)<\/li>\n<li>Category 2 Form 471s: 525 (498 in FY 2021)<\/li>\n<li>Category 2 FRNs:\u00a0 799 (851 in FY 2021)<\/li>\n<li>Average Category 2 Discount: 66%<\/li>\n<\/ul>\n<p><strong>Nationwide<\/strong>:\u00a0 34,849 Form 471s were submitted, requesting $3,153,124,510.\u00a0 By comparison, 35,577 Form 471s were submitted in FY 2021, requesting $3.02B.<\/p>\n<ul>\n<li>C1:\u00a0 $1,642,662,922<\/li>\n<li>C2:\u00a0 $1,511,461,588<\/li>\n<\/ul>\n<p><strong>What are the next immediate steps?<\/strong><\/p>\n<p style=\"padding-left: 30px;\"><strong>1. Discard Unwanted 471s:<\/strong>\u00a0\u00a0Attached is a list of Form 471s that were started and then not submitted (abandoned).\u00a0 If your name is on the list, I recommend that you discard the form so the EPC system doesn\u2019t continue to send you annoying reminders.\u00a0 To do this, log into EPC, find the incomplete in your Tasks tab at the top of the page, click on the Task, then click \u2018Discard Form\u2019 in the bottom left corner of the page.\u00a0 Note:\u00a0 The list does not include nonpublic schools because I don\u2019t have access to that data.<br \/>\n<strong>2. Review Your Submitted Data:<\/strong>\u00a0\u00a0Attached are two Excel files.\u00a0 The first is a simple (one-tab) file showing all FRNs submitted by April 5 (the last day to submit a 471 and be considered for FCC waiver), including the current status of your application.\u00a0 The second is a very detailed (5-tabs) file that shows every piece of data submitted on the Form 471, including FRN Line Items, Recipients of Service, Discount Calculations, etc. \u00a0Please open one of these files, filter by your entity\u2019s name, and make sure that your data is accurate (hint: if you want to download a PDF of your application, click on the hyperlinked 471 # in the Basic Information tab of the detailed file).\u00a0 If you need to make any corrections to the data you may do so by using the RAL Modification Process up until the date you receive your Funding Commitment Decision Letter (FCDL), however with PIA reviews happening so quickly this year, it\u2019s very important that any corrections\/changes be made ASAP so the PIA reviewers can have them in-hand during their review. \u00a0\u00a0Note:\u00a0 You can also use the RAL to add an FRN or increase your funding request, but you will be asked to show documentation dated prior to the date you certified your Form 471 to substantiate the request.<\/p>\n<p style=\"padding-left: 30px;\">A RAL Modification Guide and Instructions are available at:\u00a0\u00a0<a href=\"https:\/\/nam10.safelinks.protection.outlook.com\/?url=http%3A%2F%2Fe-ratepa.org%2F%3Fp%3D34136&amp;data=04%7C01%7Cpl-erate%40lists.psu.edu%7C1d76675fa2074d96430208da1962747d%7C7cf48d453ddb4389a9c1c115526eb52e%7C0%7C0%7C637850208792329813%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&amp;sdata=%2Bqvvqk4tXLbxnoAFUB2z6DXNobWEY55ttn1hwOelctg%3D&amp;reserved=0\" data-saferedirecturl=\"https:\/\/www.google.com\/url?q=https:\/\/nam10.safelinks.protection.outlook.com\/?url%3Dhttp%253A%252F%252Fe-ratepa.org%252F%253Fp%253D34136%26data%3D04%257C01%257Cpl-erate%2540lists.psu.edu%257C1d76675fa2074d96430208da1962747d%257C7cf48d453ddb4389a9c1c115526eb52e%257C0%257C0%257C637850208792329813%257CUnknown%257CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%253D%257C3000%26sdata%3D%252Bqvvqk4tXLbxnoAFUB2z6DXNobWEY55ttn1hwOelctg%253D%26reserved%3D0&amp;source=gmail&amp;ust=1649725464493000&amp;usg=AOvVaw3kZGErr_alNTxT2hdgvr2g\">https:\/\/e-ratepa.org\/?p=34136<\/a>. \u00a0The RAL Modification Process also should be used if you wish to cancel an FRN or an entire Form 471.<\/p>\n<p style=\"padding-left: 30px;\"><strong>3. Prepare for PIA Review:<\/strong>\u00a0\u00a0USAC\u2019s PIA (Program Integrity Assurance) Team is busy reviewing applications and if they have questions or need additional information, they\u2019ll reach out to you via e-mail.\u00a0 The e-mail will contain a link to the PIA Inquiry but before you can see their questions, you must first log into EPC, THEN click on the link in the e-mail.\u00a0 Then click on \u201cRespond to Inquiries\u201d in the top right corner of the page, then click on the name of the inquiry (it will be hyperlinked).\u00a0 Complete instructions for navigating the PIA Review Process can be found at:\u00a0\u00a0<a href=\"https:\/\/nam10.safelinks.protection.outlook.com\/?url=http%3A%2F%2Fe-ratepa.org%2F%3Fp%3D34105&amp;data=04%7C01%7Cpl-erate%40lists.psu.edu%7C1d76675fa2074d96430208da1962747d%7C7cf48d453ddb4389a9c1c115526eb52e%7C0%7C0%7C637850208792329813%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&amp;sdata=R0Vs33mbIIOVxXWhII6vPz6Jj5zTvGHPFNgjbmaCUcM%3D&amp;reserved=0\" data-saferedirecturl=\"https:\/\/www.google.com\/url?q=https:\/\/nam10.safelinks.protection.outlook.com\/?url%3Dhttp%253A%252F%252Fe-ratepa.org%252F%253Fp%253D34105%26data%3D04%257C01%257Cpl-erate%2540lists.psu.edu%257C1d76675fa2074d96430208da1962747d%257C7cf48d453ddb4389a9c1c115526eb52e%257C0%257C0%257C637850208792329813%257CUnknown%257CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%253D%257C3000%26sdata%3DR0Vs33mbIIOVxXWhII6vPz6Jj5zTvGHPFNgjbmaCUcM%253D%26reserved%3D0&amp;source=gmail&amp;ust=1649725464493000&amp;usg=AOvVaw1RJ9EgFAK9pZYkkOru5WgV\">https:\/\/e-ratepa.org\/?p=34105<\/a>.<br \/>\n<strong>4. When Will USAC Begin Issuing FY 2022 Funding Commitment Decisions<\/strong><strong>?<\/strong>\u00a0 I expect the first wave of funding commitment letters to be issued in mid-late April.\u00a0 FCDLs are released on a weekly basis until all applications have been decided, with a goal of releasing all FCDLs by September 1.<\/p>\n<p><strong>Congratulations, E-raters!\u00a0 I\u2019m so so proud of you!<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-34202\" src=\"https:\/\/e-ratepa.org\/wp-content\/uploads\/2022\/04\/greatjob.jpg\" alt=\"greatjob\" width=\"371\" height=\"236\" \/><\/p>\n<p>&#8212; Julie<\/p>\n<p>Julie Tritt Schell<br \/>\nPennsylvania E-rate Coordinator<br \/>\n717-730-7133 &#8211; o<br \/>\n<a href=\"mailto:jtschell@comcast.net\">jtschell@comcast.net<\/a><br \/>\n<a href=\"https:\/\/nam10.safelinks.protection.outlook.com\/?url=http%3A%2F%2Fwww.e-ratepa.org%2F&amp;data=04%7C01%7Cpl-erate%40lists.psu.edu%7C1d76675fa2074d96430208da1962747d%7C7cf48d453ddb4389a9c1c115526eb52e%7C0%7C0%7C637850208792329813%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&amp;sdata=MQFyPT3v9Zz3Vju7ph9YQSj7BKyvCSl3d8ty9WmNuBE%3D&amp;reserved=0\" data-saferedirecturl=\"https:\/\/www.google.com\/url?q=https:\/\/nam10.safelinks.protection.outlook.com\/?url%3Dhttp%253A%252F%252Fwww.e-ratepa.org%252F%26data%3D04%257C01%257Cpl-erate%2540lists.psu.edu%257C1d76675fa2074d96430208da1962747d%257C7cf48d453ddb4389a9c1c115526eb52e%257C0%257C0%257C637850208792329813%257CUnknown%257CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%253D%257C3000%26sdata%3DMQFyPT3v9Zz3Vju7ph9YQSj7BKyvCSl3d8ty9WmNuBE%253D%26reserved%3D0&amp;source=gmail&amp;ust=1649725464493000&amp;usg=AOvVaw2Wi3kCDFMnDSDEx8Ky2bNU\">www.e-ratepa.org<\/a><\/p>\n\n<div class=\"twitter-share\"><a href=\"https:\/\/twitter.com\/intent\/tweet?via=eratepenn\" class=\"twitter-share-button\" data-size=\"large\">Tweet<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"<p>April 8, 2022<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[52],"tags":[],"class_list":["post-34194","post","type-post","status-publish","format-standard","hentry","category-listserve_archive"],"_links":{"self":[{"href":"https:\/\/e-ratepa.org\/index.php?rest_route=\/wp\/v2\/posts\/34194","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/e-ratepa.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/e-ratepa.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/e-ratepa.org\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/e-ratepa.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=34194"}],"version-history":[{"count":0,"href":"https:\/\/e-ratepa.org\/index.php?rest_route=\/wp\/v2\/posts\/34194\/revisions"}],"wp:attachment":[{"href":"https:\/\/e-ratepa.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=34194"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/e-ratepa.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=34194"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/e-ratepa.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=34194"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}