<div dir="ltr"><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small">If this were three years from now, I'd completely agree. However, we don't yet know how many of our vendors are going to opt to provide previous year data in R5, as opposed to providing R4 and R5 concurrently for the next 2-3 years.  I was thrilled that EBSCO opted to provide the 2016-2018 data in R5 but so far they are the only major vendor I know of doing that.</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small">If you, like we, consider that any decisions on usage data should involve more than a single year's data, we're going to continue to need to analyze R4 data for up to 3 more years.</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small">This is a tough year to be a new e-resources librarian, having to learn the old and new COUNTER data definitions and formats all at the same time.</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small"></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small">Kathleen, if you can tell us WHY you're trying to put all your data into a single file, we may be able to help you further. I assume by the way that you mean all per type of data, e.g. all BR2s in one file, all JR1s in another, etc. It would make no sense at all to try to mix different report formats into a single file.</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small">Also if your institution can afford it, you should look at commercial services like Redlink to help you manage it all and generate useful reports.</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small">I've got a team of computer science students working right now on a project to SUSHI-harvest and integrate R4 and R5 data for reporting, but I have no idea at this time if they will complete the project successfully by the end of this semester. If they do, I will absolutely share it with everyone (they've agreed to that). It's being built for Google Sheets, not Excel.</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small"><br clear="all"></div><div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><div dir="ltr"><div>Melissa Belvadi</div><div>Collections Librarian</div><div>University of Prince Edward Island</div><div><a href="mailto:mbelvadi@upei.ca" target="_blank">mbelvadi@upei.ca</a>  9<span style="font-size:12.8px">02-566-0581</span></div><div>my <a href="http://www.google.com/calendar/embed?src=mbelvadi%40upei.ca&ctz=America/Halifax&mode=week" style="font-family:arial,helvetica,sans-serif;font-size:small;color:rgb(17,85,204)" target="_blank">public calendar</a></div><div><a href="https://mbelvadi.youcanbook.me/" target="_blank">Make an appointment</a> via YouCanBookMe</div><div><br></div><div><br><br></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, Jan 25, 2019 at 5:26 PM Athena Hoeppner <<a href="mailto:athena@ucf.edu">athena@ucf.edu</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">





<div lang="EN-US">
<div class="gmail-m_-8413634002439903710WordSection1">
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black">My sage advice:  use COUNTER 5 as the basis for any templates, formulas, and other Excel massaging of COUNTER­­ usage data.  COUNTER 5 will greatly improve the consistency
 of the reports, and the mandatory transition period is Jan-April 2019.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black">You can see Sample COUNTER 5 reports here:<u></u><u></u></span></p>
<table class="gmail-m_-8413634002439903710MsoNormalTable" border="0" cellpadding="0">
<tbody>
<tr>
<td style="border:1pt solid black;padding:0.75pt">
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black">Report_ID<u></u><u></u></span></p>
</td>
<td style="border:1pt solid black;padding:0.75pt">
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black">Report_Name<u></u><u></u></span></p>
</td>
<td style="border:1pt solid black;padding:0.75pt">
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black">Tabular Sample<u></u><u></u></span></p>
</td>
</tr>
<tr>
<td style="border:1pt solid black;padding:0.75pt">
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black">PR<u></u><u></u></span></p>
</td>
<td style="border:1pt solid black;padding:0.75pt">
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black">Platform Master Report<u></u><u></u></span></p>
</td>
<td style="border:1pt solid black;padding:0.75pt">
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black"><a href="https://docs.google.com/spreadsheets/d/1fsF_JCuOelUs9s_cvu7x_Yn8FNsi5xK0CR3bu2X_dVI/edit#gid=56158149" target="_blank">view</a><u></u><u></u></span></p>
</td>
</tr>
<tr>
<td style="border:1pt solid black;padding:0.75pt">
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black">PR_P1<u></u><u></u></span></p>
</td>
<td style="border:1pt solid black;padding:0.75pt">
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black">Platform Usage<u></u><u></u></span></p>
</td>
<td style="border:1pt solid black;padding:0.75pt">
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black"><a href="https://docs.google.com/spreadsheets/d/1fsF_JCuOelUs9s_cvu7x_Yn8FNsi5xK0CR3bu2X_dVI/edit#gid=1932253188" target="_blank">view</a><u></u><u></u></span></p>
</td>
</tr>
<tr>
<td style="border:1pt solid black;padding:0.75pt">
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black">DR<u></u><u></u></span></p>
</td>
<td style="border:1pt solid black;padding:0.75pt">
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black">Database Master Report<u></u><u></u></span></p>
</td>
<td style="border:1pt solid black;padding:0.75pt">
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black"><a href="https://docs.google.com/spreadsheets/d/1fsF_JCuOelUs9s_cvu7x_Yn8FNsi5xK0CR3bu2X_dVI/edit#gid=306697142" target="_blank">view</a><u></u><u></u></span></p>
</td>
</tr>
<tr>
<td style="border:1pt solid black;padding:0.75pt">
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black">DR_D1<u></u><u></u></span></p>
</td>
<td style="border:1pt solid black;padding:0.75pt">
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black">Database Search and Item Usage<u></u><u></u></span></p>
</td>
<td style="border:1pt solid black;padding:0.75pt">
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black"><a href="https://docs.google.com/spreadsheets/d/1fsF_JCuOelUs9s_cvu7x_Yn8FNsi5xK0CR3bu2X_dVI/edit#gid=2078630487" target="_blank">view</a><u></u><u></u></span></p>
</td>
</tr>
<tr>
<td style="border:1pt solid black;padding:0.75pt">
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black">DR_D2<u></u><u></u></span></p>
</td>
<td style="border:1pt solid black;padding:0.75pt">
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black">Database Access Denied<u></u><u></u></span></p>
</td>
<td style="border:1pt solid black;padding:0.75pt">
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black"><a href="https://docs.google.com/spreadsheets/d/1fsF_JCuOelUs9s_cvu7x_Yn8FNsi5xK0CR3bu2X_dVI/edit#gid=1814899913" target="_blank">view</a><u></u><u></u></span></p>
</td>
</tr>
<tr>
<td style="border:1pt solid black;padding:0.75pt">
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black">TR<u></u><u></u></span></p>
</td>
<td style="border:1pt solid black;padding:0.75pt">
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black">Title Master Report<u></u><u></u></span></p>
</td>
<td style="border:1pt solid black;padding:0.75pt">
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black"><a href="https://docs.google.com/spreadsheets/d/1fsF_JCuOelUs9s_cvu7x_Yn8FNsi5xK0CR3bu2X_dVI/edit#gid=1709631407" target="_blank">view</a><u></u><u></u></span></p>
</td>
</tr>
<tr>
<td style="border:1pt solid black;padding:0.75pt">
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black">TR_B1<u></u><u></u></span></p>
</td>
<td style="border:1pt solid black;padding:0.75pt">
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black">Book Requests (Excluding OA_Gold)<u></u><u></u></span></p>
</td>
<td style="border:1pt solid black;padding:0.75pt">
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black"><a href="https://docs.google.com/spreadsheets/d/1fsF_JCuOelUs9s_cvu7x_Yn8FNsi5xK0CR3bu2X_dVI/edit#gid=1559300549" target="_blank">view</a><u></u><u></u></span></p>
</td>
</tr>
<tr>
<td style="border:1pt solid black;padding:0.75pt">
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black">TR_B2<u></u><u></u></span></p>
</td>
<td style="border:1pt solid black;padding:0.75pt">
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black">Book Access Denied<u></u><u></u></span></p>
</td>
<td style="border:1pt solid black;padding:0.75pt">
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black"><a href="https://docs.google.com/spreadsheets/d/1fsF_JCuOelUs9s_cvu7x_Yn8FNsi5xK0CR3bu2X_dVI/edit#gid=273489278" target="_blank">view</a><u></u><u></u></span></p>
</td>
</tr>
<tr>
<td style="border:1pt solid black;padding:0.75pt">
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black">TR_B3<u></u><u></u></span></p>
</td>
<td style="border:1pt solid black;padding:0.75pt">
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black">Book Usage by Access Type<u></u><u></u></span></p>
</td>
<td style="border:1pt solid black;padding:0.75pt">
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black"><a href="https://docs.google.com/spreadsheets/d/1fsF_JCuOelUs9s_cvu7x_Yn8FNsi5xK0CR3bu2X_dVI/edit#gid=11711129" target="_blank">view</a><u></u><u></u></span></p>
</td>
</tr>
<tr>
<td style="border:1pt solid black;padding:0.75pt">
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black">TR_J1<u></u><u></u></span></p>
</td>
<td style="border:1pt solid black;padding:0.75pt">
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black">Journal Requests (Excluding OA_Gold)<u></u><u></u></span></p>
</td>
<td style="border:1pt solid black;padding:0.75pt">
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black"><a href="https://docs.google.com/spreadsheets/d/1fsF_JCuOelUs9s_cvu7x_Yn8FNsi5xK0CR3bu2X_dVI/edit#gid=717003541" target="_blank">view</a><u></u><u></u></span></p>
</td>
</tr>
<tr>
<td style="border:1pt solid black;padding:0.75pt">
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black">TR_J2<u></u><u></u></span></p>
</td>
<td style="border:1pt solid black;padding:0.75pt">
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black">Journal Access Denied<u></u><u></u></span></p>
</td>
<td style="border:1pt solid black;padding:0.75pt">
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black"><a href="https://docs.google.com/spreadsheets/d/1fsF_JCuOelUs9s_cvu7x_Yn8FNsi5xK0CR3bu2X_dVI/edit#gid=922660693" target="_blank">view</a><u></u><u></u></span></p>
</td>
</tr>
<tr>
<td style="border:1pt solid black;padding:0.75pt">
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black">TR_J3<u></u><u></u></span></p>
</td>
<td style="border:1pt solid black;padding:0.75pt">
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black">Journal Usage by Access Type<u></u><u></u></span></p>
</td>
<td style="border:1pt solid black;padding:0.75pt">
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black"><a href="https://docs.google.com/spreadsheets/d/1fsF_JCuOelUs9s_cvu7x_Yn8FNsi5xK0CR3bu2X_dVI/edit#gid=1946782958" target="_blank">view</a><u></u><u></u></span></p>
</td>
</tr>
<tr>
<td style="border:1pt solid black;padding:0.75pt">
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black">TR_J4<u></u><u></u></span></p>
</td>
<td style="border:1pt solid black;padding:0.75pt">
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black">Journal Request by YOP (Excluding OA_Gold)<u></u><u></u></span></p>
</td>
<td style="border:1pt solid black;padding:0.75pt">
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black"><a href="https://docs.google.com/spreadsheets/d/1fsF_JCuOelUs9s_cvu7x_Yn8FNsi5xK0CR3bu2X_dVI/edit#gid=1963232177" target="_blank">view</a><u></u><u></u></span></p>
</td>
</tr>
<tr>
<td style="border:1pt solid black;padding:0.75pt">
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black">IR<u></u><u></u></span></p>
</td>
<td style="border:1pt solid black;padding:0.75pt">
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black">Item Master Report<u></u><u></u></span></p>
</td>
<td style="border:1pt solid black;padding:0.75pt">
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black"><a href="https://docs.google.com/spreadsheets/d/1fsF_JCuOelUs9s_cvu7x_Yn8FNsi5xK0CR3bu2X_dVI/edit#gid=816022274" target="_blank">view</a><u></u><u></u></span></p>
</td>
</tr>
<tr>
<td style="border:1pt solid black;padding:0.75pt">
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black">IR_A1<u></u><u></u></span></p>
</td>
<td style="border:1pt solid black;padding:0.75pt">
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black">Journal Article Requests<u></u><u></u></span></p>
</td>
<td style="border:1pt solid black;padding:0.75pt">
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black"><a href="https://docs.google.com/spreadsheets/d/1fsF_JCuOelUs9s_cvu7x_Yn8FNsi5xK0CR3bu2X_dVI/edit#gid=1398783371" target="_blank">view</a><u></u><u></u></span></p>
</td>
</tr>
<tr>
<td style="border:1pt solid black;padding:0.75pt">
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black">IR_M1<u></u><u></u></span></p>
</td>
<td style="border:1pt solid black;padding:0.75pt">
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black">Multimedia Item Requests<u></u><u></u></span></p>
</td>
<td style="border:1pt solid black;padding:0.75pt">
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black"><a href="https://docs.google.com/spreadsheets/d/1fsF_JCuOelUs9s_cvu7x_Yn8FNsi5xK0CR3bu2X_dVI/edit#gid=1200249140" target="_blank">view</a><u></u><u></u></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black"><a href="https://www.projectcounter.org/appendix-i-sample-counter-repor/" target="_blank">https://www.projectcounter.org/appendix-i-sample-counter-repor/</a>
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black">A couple of things to note:<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black">There are several basic reports types:<u></u><u></u></span></p>
<ul style="margin-top:0in" type="disc">
<li class="gmail-m_-8413634002439903710MsoListParagraph" style="color:black;margin-left:0in">
<span style="font-size:12pt;font-family:Arial,sans-serif">Platforms Reports (PR)<u></u><u></u></span></li><li class="gmail-m_-8413634002439903710MsoListParagraph" style="color:black;margin-left:0in">
<span style="font-size:12pt;font-family:Arial,sans-serif">Databases Reports (DR)<u></u><u></u></span></li><li class="gmail-m_-8413634002439903710MsoListParagraph" style="color:black;margin-left:0in">
<span style="font-size:12pt;font-family:Arial,sans-serif">Title Reports (i.e. journals, books) (TR)<u></u><u></u></span></li><li class="gmail-m_-8413634002439903710MsoListParagraph" style="color:black;margin-left:0in">
<span style="font-size:12pt;font-family:Arial,sans-serif">Item Reports (i.e. articles, multimedia items, etc.)<u></u><u></u></span></li></ul>
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black">For each report type there is a Master Report, one or more Standard Reports, and, ideally, customizable reports. 
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black"><u></u> <u></u></span></p>
<ul style="margin-top:0in" type="disc">
<li class="gmail-m_-8413634002439903710MsoListParagraph" style="color:black;margin-left:0in">
<b><span style="font-size:12pt;font-family:Arial,sans-serif">Master Reports</span></b><span style="font-size:12pt;font-family:Arial,sans-serif"> include all the available data elements, with no filters applied.<u></u><u></u></span></li><li class="gmail-m_-8413634002439903710MsoListParagraph" style="color:black;margin-left:0in">
<b><span style="font-size:12pt;font-family:Arial,sans-serif">Standard Reports</span></b><span style="font-size:12pt;font-family:Arial,sans-serif"> are based on the Master Report, with a consistent set of filters applied.  The resulting can be useful
 to ensure that the same filters are applied for comparing year-to-year, resource-to-resource, or institution-to-institution. You may notice their similarity to COUNTER 4 Reports (i.e. TR_B2 is similar to BR2 for Book Access Denied)<u></u><u></u></span></li><li class="gmail-m_-8413634002439903710MsoListParagraph" style="color:black;margin-left:0in">
<b><span style="font-size:12pt;font-family:Arial,sans-serif">Customized Reports</span></b><span style="font-size:12pt;font-family:Arial,sans-serif"> should be widely available for COUNTER 5, because if the vendor’s Reports interface should let you apply
 filters at the time of requesting the report.  See the screenshot below for an example report request form from EBSCO.<u></u><u></u></span></li></ul>
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black">COUNTER 5 comes with some new terminology and some nuances that I’m still wrapping my head around, but I am very excited about the improvements this version will
 bring!<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black">Athena<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black"><u></u> <u></u></span></p>
<p class="MsoNormal"><img border="0" width="669" height="847" style="width: 6.9687in; height: 8.8229in;" id="gmail-m_-8413634002439903710Picture_x0020_1" src="cid:16894e5090c4ce8e91"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black">
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black"><u></u> <u></u></span></p>
<p class="MsoNormal"><b><span style="font-size:10pt;font-family:Arial,sans-serif;color:black">Athena Hoeppner<u></u><u></u></span></b></p>
<p class="MsoNormal"><span style="font-size:9pt;font-family:Arial,sans-serif;color:black">Discovery Services Librarian<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:9pt;font-family:Arial,sans-serif;color:black">University of Central Florida, Orlando<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:9pt;font-family:Arial,sans-serif;color:black">407-683-5019 | <a href="mailto:athena@ucf.edu" target="_blank">athena@ucf.edu</a><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:12pt;font-family:Arial,sans-serif;color:black"><u></u> <u></u></span></p>
<div>
<div style="border-right:none;border-bottom:none;border-left:none;border-top:1pt solid rgb(225,225,225);padding:3pt 0in 0in">
<p class="MsoNormal"><b>From:</b> Eril-l <<a href="mailto:eril-l-bounces@lists.eril-l.org" target="_blank">eril-l-bounces@lists.eril-l.org</a>> <b>On Behalf Of
</b>Whittemore, Kathleen<br>
<b>Sent:</b> Friday, January 25, 2019 3:37 PM<br>
<b>To:</b> '<a href="mailto:eril-l@lists.eril-l.org" target="_blank">eril-l@lists.eril-l.org</a>' <<a href="mailto:eril-l@lists.eril-l.org" target="_blank">eril-l@lists.eril-l.org</a>><br>
<b>Subject:</b> [Eril-l] Usage Statistics Spreadsheet Templates<u></u><u></u></p>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><span style="font-size:12pt;font-family:"Calibri Light",sans-serif;color:rgb(31,73,125)">Hello all,<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12pt;font-family:"Calibri Light",sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:12pt;font-family:"Calibri Light",sans-serif;color:rgb(31,73,125)">I am both new to Electronic Resources Librarianship and to this list. I’m hoping that some of you might be willing to share your usage statistics templates
 with me. <br>
<br>
I have created a couple of crude templates in order to keep usage statistics for all e-resources in one Excel workbook; however, none are functionally quite as smoothly as I hoped and require quite a bit of copy and pasting from countless COUNTER reports.
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12pt;font-family:"Calibri Light",sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:12pt;font-family:"Calibri Light",sans-serif;color:rgb(31,73,125)">Any sage advice or examples would be so greatly appreciated!<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12pt;font-family:"Calibri Light",sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:12pt;font-family:"Calibri Light",sans-serif;color:rgb(31,73,125)">Happy Friday,
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12pt;font-family:"Calibri Light",sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:12pt;font-family:"Calibri Light",sans-serif;color:rgb(31,73,125)">Kathleen Whittemore, MLIS<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12pt;font-family:"Calibri Light",sans-serif;color:rgb(127,127,127)">Electronic Resources Librarian<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12pt;font-family:"Calibri Light",sans-serif;color:rgb(127,127,127)">Hollis Health Sciences Library<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12pt;font-family:"Calibri Light",sans-serif;color:gray">NYU Winthrop Hospital<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12pt;font-family:"Calibri Light",sans-serif;color:gray">259 First Street<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12pt;font-family:"Calibri Light",sans-serif;color:gray">Mineola, NY 11501</span><span style="font-size:12pt;font-family:"Calibri Light",sans-serif;color:rgb(31,73,125)">
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12pt;font-family:"Calibri Light",sans-serif;color:rgb(127,127,127)">(516)663-6974<br>
</span><span style="font-size:12pt;font-family:"Calibri Light",sans-serif;color:rgb(31,73,125)"><a href="mailto:Kathleen.Whittemore@NYULangone.org" target="_blank">Kathleen.Whittemore@NYULangone.org</a>
</span><span style="font-size:12pt;font-family:"Calibri Light",sans-serif;color:rgb(127,127,127)"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Calibri Light",sans-serif;color:rgb(31,73,125)"><a href="https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.nyuwinthrop.org%2Flibrary&data=02%7C01%7Cathena%40ucf.edu%7C2c8b6fe7a98e4e63069008d68304e644%7Cbb932f15ef3842ba91fcf3c59d5dd1f1%7C0%7C1%7C636840454402775429&sdata=eKfosJYxU4q%2FgiS11ll6k8FYjrET1MxFcp3xZDXQOFc%3D&reserved=0" target="_blank">http://www.nyuwinthrop.org/library</a></span><span style="font-size:12pt;font-family:"Calibri Light",sans-serif;color:rgb(127,127,127)"><u></u><u></u></span></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p><br>
------------------------------------------------------------<br>
This email message, including any attachments, is for the sole use of the intended recipient(s) and may contain information that is proprietary, confidential, and exempt from disclosure under applicable law. Any unauthorized review, use, disclosure, or distribution
 is prohibited. If you have received this email in error please notify the sender by return email and delete the original message. Please note, the recipient should check this email and any attachments for the presence of viruses. The organization accepts no
 liability for any damage caused by any virus transmitted by this email.<br>
=================================<u></u><u></u></p>
</div>
</div>

_______________________________________________<br>
Eril-l mailing list<br>
<a href="mailto:Eril-l@lists.eril-l.org" target="_blank">Eril-l@lists.eril-l.org</a><br>
<a href="http://lists.eril-l.org/listinfo.cgi/eril-l-eril-l.org" rel="noreferrer" target="_blank">http://lists.eril-l.org/listinfo.cgi/eril-l-eril-l.org</a><br>
</blockquote></div>