The 2011-12 Pupil Projection Template provides several approaches to forecasting pupil attendance for future years.  The template is updated for school year 2010-11 enrollment and near-final summary of finances attendance data.  The template was last updated January 2012 and the next version will be released in Spring 2012.

Notice that, at this time, October 2011 (snapshot) enrollment by grade is to be entered to produce more meaningful results. 

The template requires Microsoft Excel and you must enable macros for it to work.  There is a link to a tutorial on enabling macros on the Getting Started tab. 

The template will automatically populate the data for past years but you must supply the enrollment by grade for school year 2011-12. 

Template (7.18 MB) 

Tempate version 2007.zip (3.61 MB)