<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal">Ladies and Gentlemen,<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal"> Many of you now are getting updated enrollment figures. Attached is a tool that some of you may find beneficial. I realize that ODE already has a tool to help you project your state aid and it is very useful. I believe
that many of you, like myself, want to know what the formulas are and where the data comes from that determines your funding. I believe that this tool gives you more of that information. Along with the template I have attached an example district that is
completed.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"> In order for this to work you need to enter a small amount of data from the reports selected below from the most current Foundation Funding Report.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><b><span style="font-size:9.0pt;font-family:"Arial",sans-serif">Payment Date (Select date for the July No.1 to June No. 2 payment from the drop down list):
</span></b><span style="font-size:9.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span style="font-size:9.0pt;font-family:"Arial",sans-serif">Choose Oct #1 or most recent report</span></b><span style="font-size:9.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span style="font-size:9.0pt;font-family:"Arial",sans-serif">Choose your District<o:p></o:p></span></b></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span style="font-size:9.0pt;font-family:"Arial",sans-serif">Choose three reports only:<o:p></o:p></span></b></p>
<p class="MsoNormal"><b><span style="font-size:9.0pt;font-family:"Arial",sans-serif">School Finance payment report Detail<o:p></o:p></span></b></p>
<p class="MsoNormal"><b><span style="font-size:9.0pt;font-family:"Arial",sans-serif">State Share Index<o:p></o:p></span></b></p>
<p class="MsoNormal"><b><span style="font-size:9.0pt;font-family:"Arial",sans-serif">Transportation<o:p></o:p></span></b></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse">
<tbody>
<tr>
<td width="4%" style="width:4.72%;padding:0in 0in 0in 0in">
<p class="MsoNormal" style="line-height:106%"><span style="font-size:9.0pt;line-height:106%;font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
</td>
<td width="47%" valign="top" style="width:47.64%;padding:0in 0in 0in 0in">
<p class="MsoNormal" style="line-height:106%"><span style="font-size:9.0pt;line-height:106%;font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
</td>
<td width="47%" style="width:47.64%;padding:0in 0in 0in 0in">
<p class="MsoNormal" style="line-height:106%"><span style="font-size:9.0pt;line-height:106%;font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><b><span style="font-size:9.0pt;font-family:"Arial",sans-serif">Step One</span></b><span style="font-size:9.0pt;font-family:"Arial",sans-serif">.
<b>Cells highlighted in green need to have data entered or remain as a 0.00. </b>
Click on the state share index tab. Enter your IRN into cell B11. Your district name will appear in cell F11. Enter the total ADM (E1) and the formula ADM (E2) into cells E14 and E15. All of the #N/A will now populate and you will see your state share index
in cell G49. It probably will not match perfectly to the state share you have on your SFPR but will come very close. Scroll down further and you will see the data used to calculate your targeted assistance. Again these numbers may or not be exactly what
is on your SFPR but should be very close.<o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:9.0pt;font-family:"Arial",sans-serif"><o:p> </o:p></span></b></p>
<p class="MsoNormal"><b><span style="font-size:9.0pt;font-family:"Arial",sans-serif">Step two</span></b><span style="font-size:9.0pt;font-family:"Arial",sans-serif">. Click on the SFPR tab. All of the cells highlighted in green need to be entered from your
school finance report detail. Once you finish entering the third grade guarantee numbers in m1 and m2 you will see that the formula amounts have all populated from A-Opportunity Grant down to F3-Intervention Specialist Funding. Transportation funding will
not be calculated. <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:9.0pt;font-family:"Arial",sans-serif">Step three</span></b><span style="font-size:9.0pt;font-family:"Arial",sans-serif">. Click on the Transportation tab. From the SFPR Transportation worksheet enter the riders,
miles and miles driven in their appropriate cells in column C. Lastly enter your district square mileage driven in cell C40.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:9.0pt;font-family:"Arial",sans-serif">Step four</span></b><span style="font-size:9.0pt;font-family:"Arial",sans-serif">. Go back to the SFPR tab. Scroll down to G117 and enter the funding guarantee base from the
SFPR detail worksheet in that cell. <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:9.0pt;font-family:"Arial",sans-serif">Step five</span></b><span style="font-size:9.0pt;font-family:"Arial",sans-serif">. Enter Q1 through Q9 from your SFPR detail worksheet in cells G121 to G129.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal">In column K I have put notes in some of the cells to show what those lines are used for.
<o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif">The results should be within a couple of hundred dollars of your SFPR. The biggest difference will be in gifted funding (F2 and F3) and Transportation (G3). If your results
are not close, double check the data you entered. If you did not find a mistake e-mail me the spreadsheet and I will take a look at it.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal">If you are doing this after the Oct#1 you may have to change the amounts in the cells that are formatted in blue. These amounts may change at any time when ODE gets updated info.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Look at the Youngstown example. I chose Youngstown because they are a high state share index district so enrollment changes have a great impact on them. Column G reflects the Oct #1. As you can see they are a formula district. Column
H cells H19 to H52 can be used to change the enrollment numbers. In this example I have chosen to show their enrollment going down by 200 students. I did this because over the past two years Youngstown has lost an average of 200 students. They lost 140
from FY14 to FY15 and 260 from FY15 to FY16. I have also reduced enrollment by about 2% on other lines. The effect of those changes show up in column J. The funding differences show up below in J69 down to J132<o:p></o:p></p>
<p class="MsoNormal">You can use this to show your Supt, administrative team, board members or just make yourself crazy seeing what happens when you lose or gain students. You can also use it to help determine how close you are to coming off the guarantee
or cap. It is not just the opportunity grant ($6,000 x state share index) but possibly special ed funding, targeted assistance, K-3 funding, etc that get effected and this is an easy way to show those audiences.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">In Youngstown’s case if they had enrollment changes as I have shown they will see a reduction of $2.3 million and be within $41,000 of the guarantee. If they lose a like amount of students as they lost from FY15 to FY16 they will be on
the guarantee. If they do not lose any students, they will receive what is on the Oct #1 and if they gain students they will gain revenue.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Please use carefully. If you are having trouble with it or results are not what you expect please give me a call or e-mail your spreadsheet with your question. If you choose to use it, I hope you find it useful.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:"Arial",sans-serif">Jack Pierson<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">Area Coordinator Region 7<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">614-403-3127<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif"><a href="mailto:John.Pierson@education.ohio.gov">John.Pierson@education.ohio.gov</a><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">Ohio Department of Education<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>