<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 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: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.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@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:11.0pt;font-family:"Calibri",sans-serif">A good suggestion came from the COUNTER 5 Technology Advisory Board discussion list:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">Use the YOP filter to segment the report into workable chunks. You could apply the same YOP ranges consistently when you create Item Reports for easy comparison from year
to year and between platforms.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">Athena<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> Eril-l <eril-l-bounces@lists.eril-l.org>
<b>On Behalf Of </b>Leslie Burke<br>
<b>Sent:</b> Friday, July 5, 2019 1:02 PM<br>
<b>To:</b> Melissa Belvadi <mbelvadi@upei.ca>; eril-l <eril-l@lists.eril-l.org>; CRKN Collections List <collections@list.crkn-rcdr.ca><br>
<b>Subject:</b> Re: [Eril-l] COUNTER monthly data - how do you use, could it be separate by month?<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Personally, I would rather have reports that focus on the whole book/journal level than article or chapter level (for journals, I don’t mind splitting to archival
vs current). I typically use the monthly data to see if there are specific times of year things are being used when it might be related to a course offered that term or offered intermittently.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Arial",sans-serif;color:#1F497D">Leslie D. Burke</span><span style="color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Arial",sans-serif;color:#1F497D">Collection Services Librarian, Library</span><span style="color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Arial",sans-serif;color:#1F497D">Kalamazoo College</span><span style="color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Arial",sans-serif;color:#1F497D">1200 Academy St</span><span style="color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Arial",sans-serif;color:#1F497D">Kalamazoo, MI 49006</span><span style="color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Arial",sans-serif;color:#1F497D">p 269.337.7144</span><span style="color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Arial",sans-serif;color:#1F497D">f 269.337.7395</span><span style="color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><a href="mailto:Leslie.Burke@kzoo.edu" target="_blank"><span style="font-family:"Arial",sans-serif">Leslie.Burke@kzoo.edu</span></a><o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#E36C0A">More in Four. More in a Lifetime.</span></b><span style="color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal"><a name="webProfileURL"><i><span style="font-size:10.5pt;font-family:"Calibri",sans-serif;color:#008F00">No one has to do everything, but everyone has to do something – What’s your Green Dot?</span></i></a><span style="mso-bookmark:webProfileURL"><span style="font-size:10.5pt;font-family:"Calibri",sans-serif;color:black"><o:p></o:p></span></span></p>
<p class="MsoNormal"><span style="mso-bookmark:webProfileURL"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">LinkedIn:
</span></span><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><a href="https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.linkedin.com%2Fin%2Fleslieburke%2F&data=02%7C01%7Cathena%40ucf.edu%7C34accad4bbe044062f4e08d7016a8c55%7Cbb932f15ef3842ba91fcf3c59d5dd1f1%7C0%7C0%7C636979429444542328&sdata=2EYG70ab%2FY3HlmvlwLU7knVrxcbMSa5fzSNcCJP8muw%3D&reserved=0" target="_blank">www.linkedin.com/in/leslieburke/</a></span><span style="color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Arial",sans-serif;color:#1F497D">Twitter: librarygal2go</span><span style="color:#1F497D">;
</span><span style="font-size:11.0pt;font-family:"Arial",sans-serif;color:#1F497D">K’s Library on Facebook:
</span><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><a href="https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.facebook.com%2Fkalamazoocollegelibrary&data=02%7C01%7Cathena%40ucf.edu%7C34accad4bbe044062f4e08d7016a8c55%7Cbb932f15ef3842ba91fcf3c59d5dd1f1%7C0%7C0%7C636979429444542328&sdata=IarYO7a7iBiINxzuPQOpgQvIXcRdodxpeERYaueod3U%3D&reserved=0" target="_blank"><span style="font-family:"Arial",sans-serif">https://www.facebook.com/kalamazoocollegelibrary</span></a></span><span style="font-size:11.0pt;font-family:"Arial",sans-serif;color:#1F497D">
</span><span style="color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-left:.5in"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> Eril-l <<a href="mailto:eril-l-bounces@lists.eril-l.org">eril-l-bounces@lists.eril-l.org</a>>
<b>On Behalf Of </b>Melissa Belvadi<br>
<b>Sent:</b> Friday, July 05, 2019 12:24 PM<br>
<b>To:</b> eril-l <<a href="mailto:eril-l@lists.eril-l.org">eril-l@lists.eril-l.org</a>>; CRKN Collections List <<a href="mailto:collections@list.crkn-rcdr.ca">collections@list.crkn-rcdr.ca</a>><br>
<b>Subject:</b> [Eril-l] COUNTER monthly data - how do you use, could it be separate by month?<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:.5in"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-family:"Arial",sans-serif">Hi, all.<br clear="all">
<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-family:"Arial",sans-serif">This is for people who work with COUNTER reports.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-family:"Arial",sans-serif">One of the new R5 COUNTER reports is the IR master report, which gives usage at the article/chapter level rather than whole journal/book level.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-family:"Arial",sans-serif">One vendor is already starting to struggle with these reports getting too big, and the year is only half over.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-family:"Arial",sans-serif">I've gotten in a discussion with them and the Project COUNTER people about what to do about this and one idea is to provide very large reports only by month, instead
of "year to date" with separate columns per month.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-family:"Arial",sans-serif">My first take on this is that it would be incredibly inconvenient to get the usage data only one month per spreadsheet file. My alternative idea would be to split into
alpha ranges by title although I'm not thrilled with that either.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-family:"Arial",sans-serif">But I thought I'd ask you all what you even do with the monthly level data in the first place.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-family:"Arial",sans-serif">I've only had two use cases for it, neither of which would be supported by having every month in a separate file:<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-family:"Arial",sans-serif">1. looking for anomalous spikes caused by hackers, so I could eliminate them from my "true cost per use" calculations<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-family:"Arial",sans-serif">2. re-calculating totals over different date ranges (eg fiscal year rather than calendar year, or multiple years combined)<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-family:"Arial",sans-serif">What else do you look at the monthly level COUNTER data for?<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-family:"Arial",sans-serif">If a single report gets just too big for Excel, how would you want the vendor to split it up for you?<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-family:"Arial",sans-serif">Are you willing to have to use something like MS Access to work with some reports, so getting a zipped csv/tsv/json would be a good choice for you?<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
</div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal" style="margin-left:.5in">Melissa Belvadi<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:.5in">Collections Librarian<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:.5in">University of Prince Edward Island<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:.5in"><a href="mailto:mbelvadi@upei.ca" target="_blank">mbelvadi@upei.ca</a> 9<span style="font-size:9.5pt">02-566-0581</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:.5in">my <a href="https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.google.com%2Fcalendar%2Fembed%3Fsrc%3Dmbelvadi%2540upei.ca%26ctz%3DAmerica%2FHalifax%26mode%3Dweek&data=02%7C01%7Cathena%40ucf.edu%7C34accad4bbe044062f4e08d7016a8c55%7Cbb932f15ef3842ba91fcf3c59d5dd1f1%7C0%7C0%7C636979429444552325&sdata=nEzcIASNrcLR7lnTOkS%2Fl2f5jArqHXHrTut80lWo6VY%3D&reserved=0" target="_blank"><span style="font-family:"Arial",sans-serif;color:#1155CC">public calendar</span></a><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:.5in"><a href="https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fmbelvadi.youcanbook.me%2F&data=02%7C01%7Cathena%40ucf.edu%7C34accad4bbe044062f4e08d7016a8c55%7Cbb932f15ef3842ba91fcf3c59d5dd1f1%7C0%7C0%7C636979429444552325&sdata=lp3zSQR%2BlxI7z9cYmmvuVw3GGTx2dfK6%2F2J9qJGy2HQ%3D&reserved=0" target="_blank">Make
an appointment</a> via YouCanBookMe<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:.5in"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:12.0pt;margin-left:.5in">
<o:p> </o:p></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>