<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;}
@font-face
{font-family:Georgia;
panose-1:2 4 5 2 5 4 5 2 3 3;}
@font-face
{font-family:"Freestyle Script";
panose-1:3 8 4 2 3 2 5 11 4 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: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:11.0pt;
font-family:"Calibri",sans-serif;}
span.gmailsignatureprefix
{mso-style-name:gmail_signature_prefix;}
span.EmailStyle20
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle21
{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>
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal">I have a spreadsheet of all of our databases. They are listed in expiration date order example:<o:p></o:p></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="1118" style="width:11.65in;border-collapse:collapse">
<tbody>
<tr style="height:14.6pt">
<td width="317" nowrap="" valign="bottom" style="width:237.8pt;padding:0in 5.4pt 0in 5.4pt;height:14.6pt">
<p class="MsoNormal" align="center" style="text-align:center"><span style="color:black">Name of Database<o:p></o:p></span></p>
</td>
<td width="97" nowrap="" valign="bottom" style="width:72.8pt;padding:0in 5.4pt 0in 5.4pt;height:14.6pt">
<p class="MsoNormal" align="center" style="text-align:center"><span style="color:black">Provider<o:p></o:p></span></p>
</td>
<td width="98" nowrap="" valign="bottom" style="width:73.8pt;padding:0in 5.4pt 0in 5.4pt;height:14.6pt">
<p class="MsoNormal"><span style="color:black">FY 2024 Amt<o:p></o:p></span></p>
</td>
<td width="113" nowrap="" valign="bottom" style="width:84.8pt;padding:0in 5.4pt 0in 5.4pt;height:14.6pt">
<p class="MsoNormal"><span style="color:black">Expiration Date <o:p></o:p></span></p>
</td>
<td width="30" nowrap="" valign="bottom" style="width:22.8pt;padding:0in 5.4pt 0in 5.4pt;height:14.6pt">
</td>
<td width="462" nowrap="" valign="bottom" style="width:346.8pt;padding:0in 5.4pt 0in 5.4pt;height:14.6pt">
<p class="MsoNormal" align="center" style="text-align:center"><span style="color:black">Notes<o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Every time I renew a database I change the date of expiration and then sort by oldest date to newest so the ones that are renewing next are always on top. I have one spreadsheet with tabs for the different years so I have easy access to
see how much was paid for a certain item in past years.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="font-size:18.0pt;font-family:"Freestyle Script"">Betsy Dalstra<o:p></o:p></span></p>
<p class="MsoNormal">Library Associate (Serials)<o:p></o:p></p>
<p class="MsoNormal">University of Houston – Clear Lake<o:p></o:p></p>
<p class="MsoNormal">Neumann Library <o:p></o:p></p>
<p class="MsoNormal">2700 Bay Area Blvd<o:p></o:p></p>
<p class="MsoNormal">Houston Tx 77058<o:p></o:p></p>
<p class="MsoNormal">281-283-3940<o:p></o:p></p>
<p class="MsoNormal"><a href="mailto:dalstra@uhcl.edu"><span style="color:#0563C1">mailto:dalstra@uhcl.edu</span></a><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><b>From:</b> Eril-l <eril-l-bounces@lists.eril-l.org> <b>On Behalf Of
</b>Electronic Resources in Libraries discussion list via Eril-l<br>
<b>Sent:</b> Monday, January 8, 2024 4:39 PM<br>
<b>To:</b> eril-l@lists.eril-l.org<br>
<b>Subject:</b> [Eril-l] Database Renewal Spreadsheet example<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">Hello All, <o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">I am new to this listserv so if this has been asked before my apologies for redundancy. I have two questions. <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">1. I am curious if anyone has any miracle success stories that they might be willing to share/post regarding a quality "system" they use for database renewals reminders? A spreadsheet of sorts that helps for efficiency? <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Is that something that you all use and if you find it successful and helpful might you share that with me? <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">2. Does anyone use or have they created a "cancellation review process" showing a list of criteria that you consider if and when a database is up for possible cut. Not a collection development policy but more a rubric list that you follow
to cover your tail if a resource gets the chopping block? <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Many thanks! And Happy New Year! <br clear="all">
<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p class="MsoNormal"><span class="gmailsignatureprefix">-- </span><o:p></o:p></p>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:14.0pt;font-family:"Georgia",serif;color:#1A1A1A">Tracy M. Cole</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:14.0pt;font-family:"Georgia",serif;color:#1A1A1A">Assistant Librarian, Acquisitions</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:14.0pt;font-family:"Georgia",serif;color:#1A1A1A">USA Libraries Collections</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:14.0pt;font-family:"Georgia",serif;color:#103CC0"><a href="mailto:tmcole@southalabama.edu" target="_blank">tmcole@southalabama.edu</a></span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:14.0pt;font-family:"Georgia",serif;color:#1A1A1A">P: (251) 461-1563</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:14.0pt;font-family:"Georgia",serif;color:#1A1A1A">—</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:14.0pt;font-family:"Georgia",serif;color:#02205B">University of South Alabama</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:14.0pt;font-family:"Georgia",serif;color:#02205B">Marx Library </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:14.0pt;font-family:"Georgia",serif;color:#02205B">5901 USA Drive North</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:14.0pt;font-family:"Georgia",serif;color:#02205B">Mobile, AL 36688</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:"Georgia",serif;color:#103CC0"><a href="https://urldefense.com/v3/__https:/www.southalabama.edu/libraries/__;!!BCR0FSePrR4x!ANBSlU8Ns0TJstTvmEb21yFql-4S27fygtiSjBs-1toErgcSDQlwWOWG9VWm9I0yvEkKA6PlGypNGCQbSxk$" target="_blank">https://www.southalabama.edu/libraries/</a></span><o:p></o:p></p>
<p style="mso-margin-top-alt:10.0pt;margin-right:0in;margin-bottom:0in;margin-left:0in;margin-bottom:.0001pt">
<img border="0" id="_x0000_i1025" src="https://ci3.googleusercontent.com/mail-sig/AIorK4zrufsgeL5MQZxpG6cZ3sEEITDtAP9_lbJie-zRhF5j9Xt2D_tjR5sPeuNJV01Cxzk9YJLkmq4"><o:p></o:p></p>
</div>
</div>
</div>
</div>
</div>
</body>
</html>