<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)"><!--[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:"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.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.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;}
/* List Definitions */
@list l0
{mso-list-id:1160002358;
mso-list-type:hybrid;
mso-list-template-ids:1547104920 1740290188 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l0:level1
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
mso-ascii-font-family:"Times New Roman";
mso-fareast-font-family:Calibri;
mso-hansi-font-family:"Times New Roman";
mso-bidi-font-family:"Times New Roman";}
@list l0:level2
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level3
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level4
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level5
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level6
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level7
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level8
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level9
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
--></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=MsoListParagraph style='text-indent:-.25in;mso-list:l0 level1 lfo1'><![if !supportLists]><span style='mso-list:Ignore'>1.<span style='font:7.0pt "Times New Roman"'> </span></span><![endif]>How do you save the information of cancelled subscriptions? In a spreadsheet or in a different format? <o:p></o:p></p><p class=MsoListParagraph style='margin-left:1.0in;text-indent:-.25in;mso-list:l0 level2 lfo1'><![if !supportLists]><span style='mso-list:Ignore'>a.<span style='font:7.0pt "Times New Roman"'> </span></span><![endif]>Excel and Access<o:p></o:p></p><p class=MsoListParagraph style='margin-bottom:12.0pt;text-indent:-.25in;mso-list:l0 level1 lfo1'><![if !supportLists]><span style='mso-list:Ignore'>2.<span style='font:7.0pt "Times New Roman"'> </span></span><![endif]>What type of information do you keep for each cancelled subscription? Cost? Year subscription was cancelled? Other types of information?<o:p></o:p></p><p class=MsoNormal style='margin-left:.5in'>When I worked in a large health sciences research organization, we kept the cancellations in an excel file for each year and then downloaded to Access every year. <o:p></o:p></p><p class=MsoNormal style='margin-left:.5in'>Excel file contained <o:p></o:p></p><p class=MsoNormal style='margin-left:1.0in'>Journal Title<o:p></o:p></p><p class=MsoNormal style='margin-left:1.0in'>Publisher<o:p></o:p></p><p class=MsoNormal style='margin-left:1.0in'>ISSN (Print and Electronic)<o:p></o:p></p><p class=MsoNormal style='margin-left:1.0in'>Cost<o:p></o:p></p><p class=MsoNormal style='margin-left:1.0in'>Use<o:p></o:p></p><p class=MsoNormal style='margin-left:1.0in'>Cost/Use<o:p></o:p></p><p class=MsoNormal style='margin-left:1.0in'>Years subscribed<o:p></o:p></p><p class=MsoNormal style='margin-left:1.0in'>Perpetual Access Period (additional column if there was a break in service)<o:p></o:p></p><p class=MsoNormal style='margin-left:1.0in'>Core Subject Association (Y/N) – track the percentage of cuts in each core subject<o:p></o:p></p><p class=MsoNormal style='margin-bottom:12.0pt'><o:p> </o:p></p><p class=MsoNormal><span style='font-size:11.0pt;color:#1F497D'>Anu Moorthy<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:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><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 [mailto:eril-l-bounces@lists.eril-l.org] <b>On Behalf Of </b>Elizabeth Henry<br><b>Sent:</b> Tuesday, October 27, 2015 2:27 PM<br><b>To:</b> eril-l@lists.eril-l.org<br><b>Subject:</b> [Eril-l] How to track cancelled subscriptions?<o:p></o:p></span></p><p class=MsoNormal><o:p> </o:p></p><div><div><div><div><div><div><div><div><div><div><p class=MsoNormal style='margin-bottom:12.0pt'>Hello collective wisdom,<o:p></o:p></p></div><p class=MsoNormal style='margin-bottom:12.0pt'>I'm trying to figure out the best way to track all of the cancelled subscriptions outside of an ERM. Currently, I have all of the subscriptions in Serials Solutions, both active and cancelled. However, we've cancelled a fair number of subscriptions due to budget cutbacks and as a result, Serials Solutions is becoming cluttered with cancelled subscriptions alongside with the active subscriptions. <o:p></o:p></p></div><p class=MsoNormal style='margin-bottom:12.0pt'>I'd like to extract all of the cancelled subscriptions from Serials Solutions and save them somehow, so the Library can refer back to the cancelled subscriptions and see why this particular subscription was cancelled and when (trying to avoid institutional memory, which is not so reliable).<o:p></o:p></p></div><p class=MsoNormal>I'm curious about the following:<o:p></o:p></p></div><p class=MsoNormal>1. How do you save the information of cancelled subscriptions? In a spreadsheet or in a different format?<o:p></o:p></p></div><p class=MsoNormal style='margin-bottom:12.0pt'>2. What type of information do you keep for each cancelled subscription? Cost? Year subscription was cancelled? Other types of information?<o:p></o:p></p></div><p class=MsoNormal style='margin-bottom:12.0pt'>Any additional information will be appreciated.<o:p></o:p></p></div><p class=MsoNormal style='margin-bottom:12.0pt'>Thanks for your time and input.<o:p></o:p></p></div><p class=MsoNormal>Sincerely,<o:p></o:p></p></div><p class=MsoNormal>Elizabeth Henry <br clear=all><o:p></o:p></p><div><div><div><div><div><div><div><div><div><div><p class=MsoNormal><br>-- <o:p></o:p></p><div><div><p class=MsoNormal><img id="_x0000_i1025" src="http://www.gallaudet.edu/images/president/logo_email_icon.jpg"><br><br>Elizabeth Henry<o:p></o:p></p></div><div><p class=MsoNormal>Instruction and Reference/E-Resources Librarian<o:p></o:p></p></div><div><p class=MsoNormal>Gallaudet University Library<o:p></o:p></p></div><div><p class=MsoNormal>Merrill Learning Center, room 1302<o:p></o:p></p></div><div><p class=MsoNormal>800 Florida Ave, NE<o:p></o:p></p></div><div><p class=MsoNormal>Washington, D.C. 20002<br>202-250-2855<o:p></o:p></p></div><div><p class=MsoNormal><a href="mailto:elizabeth.henry@gallaudet.edu" target="_blank">elizabeth.henry@gallaudet.edu</a><o:p></o:p></p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></body></html>