<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=utf-8">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
        {font-family:Calibri;
        panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
        {font-family:Tahoma;
        panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
        {font-family:"Century Gothic";
        panose-1:2 11 5 2 2 2 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0in;
        margin-bottom:.0001pt;
        font-size:12.0pt;
        font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
        {mso-style-priority:99;
        color:blue;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {mso-style-priority:99;
        color:purple;
        text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
        {mso-style-priority:99;
        mso-style-link:"Balloon Text Char";
        margin:0in;
        margin-bottom:.0001pt;
        font-size:8.0pt;
        font-family:"Tahoma","sans-serif";}
span.EmailStyle17
        {mso-style-type:personal-reply;
        font-family:"Century Gothic","sans-serif";
        color:black;
        font-weight:normal;
        font-style:normal;}
span.BalloonTextChar
        {mso-style-name:"Balloon Text Char";
        mso-style-priority:99;
        mso-style-link:"Balloon Text";
        font-family:"Tahoma","sans-serif";}
.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="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Century Gothic","sans-serif";color:black">Hi all,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Century Gothic","sans-serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Century Gothic","sans-serif";color:black">From Lorrie Germann, the State eRate Coordinator:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Century Gothic","sans-serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-bottom:12.0pt">The MR-81 CEP document from Department of Ed includes the raw data the schools will need when completing the 471, where the form will apply the factor of 1.6. The libraries however, would need to calculate the
 NSLP count on their own.   So, I've done that for them!  I've applied the necessary formulas that will list the Student and NSLP counts they will use for each of the schools. 
<br>
<br>
Please remind the libraries if not all schools in the district participate in CEP, they will need to add the  student and NSLP counts from both the "Traditional" MR-81 document from ODE, and the "CEP" document to come up with the totals.
<o:p></o:p></p>
<p class="MsoNormal" style="margin-bottom:12.0pt">Hope that makes sense!<o:p></o:p></p>
<div style="mso-element:para-border-div;border:none;border-bottom:solid windowtext 1.5pt;padding:0in 0in 1.0pt 0in">
<p class="MsoNormal" style="margin-bottom:12.0pt;border:none;padding:0in"><o:p> </o:p></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><o:p> </o:p></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Century Gothic","sans-serif";color:black">The spreadsheet is available here:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Century Gothic","sans-serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Century Gothic","sans-serif";color:black"><a href="https://library.ohio.gov/sites/default/files/Copy%20of%20October_2014_MR81_CEP%20Data%20for%20Libraries.xlsx">https://library.ohio.gov/sites/default/files/Copy%20of%20October_2014_MR81_CEP%20Data%20for%20Libraries.xlsx</a><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Century Gothic","sans-serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Century Gothic","sans-serif";color:black">Please let me know if you have any trouble downloading it.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Century Gothic","sans-serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Century Gothic","sans-serif";color:black">Take care on this cold day!<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Century Gothic","sans-serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Century Gothic","sans-serif";color:#002E62"><img border="0" width="120" height="126" id="Picture_x0020_11" src="cid:image001.jpg@01D04C1C.C5B6C830"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Century Gothic","sans-serif";color:#002E62">Mandy Knapp<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Century Gothic","sans-serif";color:#002E62">Library Consultant<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Century Gothic","sans-serif";color:#002E62">274 E. 1<sup>st</sup> Avenue<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Century Gothic","sans-serif";color:#002E62">Columbus, OH 43201<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Century Gothic","sans-serif";color:#002E62">Tel: 614-466-1710<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Century Gothic","sans-serif";color:#002E62">Toll Free:800-686-1532 (Ohio Only)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Century Gothic","sans-serif";color:#002E62">Fax: 614-466-3584<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:black"><a href="http://library.ohio.gov"><span style="font-size:9.0pt;font-family:"Century Gothic","sans-serif";color:blue">library.ohio.gov</span></a></span><span style="font-size:9.0pt;font-family:"Century Gothic","sans-serif";color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><a href="https://www.facebook.com/StateLibraryOhio"><b><i><span style="font-size:13.5pt;color:black;text-decoration:none"><img border="0" width="30" height="30" id="Picture_x0020_7" src="cid:image002.png@01D04C1C.C5B6C830"></span></i></b></a><b><i><span style="font-size:13.5pt;color:black"> 
</span></i></b><a href="http://twitter.com/statelibohio" target="_blank"><b><i><span style="font-size:13.5pt;color:blue;text-decoration:none"><img border="0" width="32" height="32" id="Picture_x0020_3" src="cid:image003.png@01D04C1C.C5B6C830" alt="Description: Twitter logo - links to the State Library of Ohio's Twitter page"></span></i></b></a><b><i><span style="font-size:13.5pt;color:black">  </span></i></b><a href="http://library.ohio.gov/blog/" target="_blank"><b><i><span style="font-size:13.5pt;color:blue;text-decoration:none"><img border="0" width="31" height="31" id="Picture_x0020_2" src="cid:image004.jpg@01D04C1C.C5B6C830" alt="Description: Blog logo - Links to the State Library of Ohio's blog"></span></i></b></a><b><i><span style="font-size:13.5pt;color:black"> </span></i></b><b><span style="font-size:13.5pt;color:black"> </span></b><a href="http://pinterest.com/stlibohio/"><b><span style="font-size:13.5pt;color:black;text-decoration:none"><img border="0" width="31" height="31" id="Picture_x0020_1" src="cid:image005.png@01D04C1C.C5B6C830"></span></b></a><b><span style="font-size:13.5pt;color:black"><br>
</span></b><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:black"><a href="http://library.ohio.gov/state-librarian/share-your-story"><span style="font-size:9.0pt;font-family:"Century Gothic","sans-serif";color:blue">Share Your Story</span></a></span><span style="font-size:9.0pt;font-family:"Century Gothic","sans-serif";color:#002E62">
 by </span><span style="font-size:9.0pt;font-family:"Century Gothic","sans-serif";color:#002E62">telling us how a
<br>
State Library service or resource helped <br>
you or your library.</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Century Gothic","sans-serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> Lorrie Germann [mailto:lorrie.germann@gmail.com]
<br>
<b>Sent:</b> Wednesday, February 18, 2015 10:16 PM<br>
<b>To:</b> Hedges, Stephen; Knapp, Mandy<br>
<b>Subject:</b> CEP Data for Libraries<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt">Hi Stephen and Mandy,<o:p></o:p></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt">Would you please send the CEP file I've attached to the OPLIN list? 
<br>
<br>
The MR-81 CEP document from Department of Ed includes the raw data the schools will need when completing the 471, where the form will apply the factor of 1.6. The libraries however, would need to calculate the NSLP count on their own.   So, I've done that for
 them!  I've applied the necessary formulas that will list the Student and NSLP counts they will use for each of the schools. 
<br>
<br>
Please remind the libraries if not all schools in the district participate in CEP, they will need to add the  student and NSLP counts from both the "Traditional" MR-81 document from ODE, and the "CEP" document I've attached to come up with the totals.
<o:p></o:p></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt">Hope that makes sense!<o:p></o:p></p>
</div>
<p class="MsoNormal">Thanks,<br>
<br>
Lorrie<o:p></o:p></p>
</div>
</div>
</body>
</html>