Home - Click Here

Listserve Archives
2013
2012
2011
2010
2009
2008
2007
2006
2005
2004
2003
2002
2001
2000
1999
1998

2005-2006 NSLP Data Available on PA E-rate Website
Message Posted January 20, 2006

The PDE Bureau of Food and Nutrition has just released the raw National School Lunch Data that was submitted by schools to PDE in October 2005. The data can be found on the PA E-rate website under the Discount Calculations tab or directly at:

http://www.e-ratepa.org/discount_calc.htm

As in previous years, the data is in an Excel spreadsheet, listed in county order, then alpha order. To find the entity you want, I suggest you just do a 'save as' to a file on your hard drive. Then open with Excel and do a 'find.'

I also took the first district in the file and calculated their District's Shared E-rate Discount as an example. When you file online, however, the system automatically does these calculations for you.

A few important notes:

1) When the SLD's PIA staff reviews your applications, particularly your Block 4 discount calculations, they use this data. Therefore you may want to double check that the data that you submit in your E-rate application matches the data listed on this spreadsheet. Certainly, if you have other data, you can use it (such as from an income survey or more recent NSLP data), but you should expect a call from the PIA staff requesting thorough documentation as to why the figures do not match what was submitted to the State.

2) This spreadsheet only contains buildings that have students participating in the NSLP program. Your individual Form 471, Block 4's should contain all of the buildings that are receiving E-rate discounted services, including your non-instructional facilities (NIFs), such as bus barns, administration buildings, etc. And in order to list these buildings on the Block 4, they must have an E-rate entity number assigned to them. If they don't, call the SLD at 888-203-8100 and obtain entity numbers for these NIFs. Then in Block 4, you will list that they have 0 students enrolled, and 0 students eligible for NSLP. The discount for these buildings will be the district's shared E-rate discount.

3) Don't forget that the easiest way to complete a Block 4 is to use the "Copy Block 4" feature from a previous 471. Just don't forget to update the NSLP data and make sure the entities receiving the service described in Block 5 are all listed in that particular Block 4 worksheet. If you have only a few buildings that are receiving a particular service, add a separate Block 4 worksheet only listing those entities (and then refer to that specific worksheet in Item 23J of the Block 5).

4) If you have any questions about your NSLP information, contact Sandy Souder in the Bureau of Food and Nutrition 800-331-0129, Ext. 76833.

5) If you have any questions about calculating your E-rate discounts, please don't hesitate to contact me at jtschell@comcast.net.

Julie Tritt Schell

jtschell@comcast.net
(717) 730.7133 (voice)
(717) 730.9060 (fax)

Listserve Archives Main