<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-2022-jp">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div class="elementToProof" style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Re year over year percent changes, think about currency issues too. We track the price in original currency, not just the finally paid price in our currency, because the currency fluctuates so much that it can easily make a sub's price increase seem a few percent
higher or lower than the publisher is actually asking for and could totally throw off our prediction for the next fiscal year. And then when we get those "rate adjustments" (we use EBSCO for many serials), we have to track the original currency of those too
in order to predict the price in the next year.</div>
<div class="elementToProof" style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class="elementToProof" style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
As a Canadian library, this issue affects the vast majority of our subs, but even American libraries probably have some subs in other currencies that this will be an issue for.</div>
<div class="elementToProof" style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div id="Signature">
<div><span style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);">Melissa Belvadi</span></div>
<div style="text-align: left; background-color: rgb(255, 255, 255);"><span style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">mbelvadi@upei.ca</span></div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Make an appointment: https://mbelvadi.youcanbook.me/</div>
</div>
<div id="appendonsend"></div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> Eril-l <eril-l-bounces@lists.eril-l.org> on behalf of Electronic Resources in Libraries discussion list via Eril-l <eril-l@lists.eril-l.org><br>
<b>Sent:</b> Monday, November 20, 2023 5:06 PM<br>
<b>To:</b> Electronic Resources in Libraries discussion list <eril-l@lists.eril-l.org><br>
<b>Subject:</b> Re: [Eril-l] I EXTERNAL I Spreadsheet for database renewals - Samples</font>
<div> </div>
</div>
<style type="text/css" style="display:none">
<!--
p
{margin-top:0;
margin-bottom:0}
-->
</style>
<div dir="ltr"><br>
<div style="background-color:#ffe599; padding:10px; margin-left:0px; margin-right:0px">
<span style="font-size:9pt; font-family:Arial,sans-serif; color:#17202A"><b>CAUTION:</b></span>
<span style="font-size:9pt; line-height:10pt; font-family:Arial,sans-serif; color:#17202A">
This email originated from outside of UPEI. Do not click links or open attachments unless you recognize the sender and know the content is safe. If you are uncertain, please forward to phishing@upei.ca and delete this email.
<p></p>
</span></div>
<br>
<div><br>
<div style="background-color:#ff9999; padding:10px; margin-left:0px; margin-right:0px">
<span style="font-size:9pt; font-family:Arial,sans-serif; color:#17202A"><b>WARNING:</b></span>
<span style="font-size:9pt; line-height:10pt; font-family:Arial,sans-serif; color:#17202A">
The sender of this email could not be verified and may not match the person in the 'FROM' field. Do not click links or open attachments unless you recognize the sender and know the content is safe. If you are uncertain, please forward to phishing@upei.ca and
delete this email.
<p></p>
</span></div>
<br>
<div>
<div class="x_elementToProof" style="font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Calibri,Helvetica,sans-serif; font-size:11pt; color:rgb(0,0,0)">
This is excellent, Michael! Thank you!<br>
<br>
I had yet to think about the percent changes year by year, which is valuable information.</div>
<div class="x_elementToProof" style="font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Calibri,Helvetica,sans-serif; font-size:11pt; color:rgb(0,0,0)">
<br>
</div>
<div id="x_Signature">
<div><span style="font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Calibri,Helvetica,sans-serif; font-size:11pt; color:rgb(0,0,0)">Thanks,</span></div>
<div><span style="font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Calibri,Helvetica,sans-serif; font-size:11pt; color:rgb(0,0,0)">Maribel Castro</span></div>
</div>
<div id="x_appendonsend"></div>
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="x_divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" color="#000000" style="font-size:11pt"><b>From:</b> Eril-l <eril-l-bounces@lists.eril-l.org> on behalf of Electronic Resources in Libraries discussion list via Eril-l <eril-l@lists.eril-l.org><br>
<b>Sent:</b> Friday, November 17, 2023 4:23 PM<br>
<b>To:</b> Electronic Resources in Libraries discussion list <eril-l@lists.eril-l.org><br>
<b>Subject:</b> Re: [Eril-l] I EXTERNAL I Spreadsheet for database renewals - Samples</font>
<div> </div>
</div>
<style>
<!--
@font-face
{font-family:"Cambria Math"}
@font-face
{font-family:Calibri}
@font-face
{font-family:Verdana}
@font-face
{font-family:"Segoe UI"}
@font-face
{font-family:Aptos}
@font-face
{font-family:Montserrat}
p.x_x_MsoNormal, li.x_x_MsoNormal, div.x_x_MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif}
a:link, span.x_x_MsoHyperlink
{color:blue;
text-decoration:underline}
span.x_x_EmailStyle19
{font-family:"Calibri",sans-serif;
color:windowtext}
.x_x_MsoChpDefault
{font-size:10.0pt}
@page WordSection1
{margin:1.0in 1.0in 1.0in 1.0in}
-->
</style>
<div lang="EN-US" style="word-wrap:break-word">
<p></p>
<div style="">
<p class="x_x_MsoNormal" style="background:#FFEB9C’"><b><span style="color:#9C6501′"></span></b><span style="color:black’">[USE CAUTION - EXTERNAL SENDER - TAKE EXTRA PRECAUTIONS WHEN OPENING ANY INCLUDED ATTACHMENTS AND/OR LINKS]</span></p>
</div>
<div>
<div class="x_x_WordSection1">
<p class="x_x_MsoNormal">Here is my template, I look over it monthly to make sure everything is on track. Adding current use data and percent changes year by year helps when you get those questions about a database out of the blue.
</p>
<p class="x_x_MsoNormal"> </p>
<div>
<p class="x_x_MsoNormal"><span style="color:#3B3838">Regards,</span></p>
<p class="x_x_MsoNormal"><span style="color:#3B3838"> </span></p>
<p class="x_x_MsoNormal"><span style="color:#3B3838">Michael </span></p>
<p class="x_x_MsoNormal"><span style="font-size:10.0pt; color:#3B3838"> </span></p>
<p class="x_x_MsoNormal"><span style="font-size:10.0pt; color:#3B3838">--------------------------------------------<br>
J. Michael Lindsay, MSIS, MBA, D-AHIP<br>
Head of Collections and Access Services, Associate Professor</span></p>
<p class="x_x_MsoNormal"><span style="font-size:10.0pt; color:#3B3838">ORCID: <a href="https://orcid.org/0000-0003-1941-8581">
0000-0003-1941-8581</a></span></p>
<p class="x_x_MsoNormal"><span style="font-size:10.0pt; color:#3B3838">Health Information Center</span></p>
<p class="x_x_MsoNormal"><span style="font-size:10.0pt; color:#3B3838">Preston Medical Library</span></p>
<p class="x_x_MsoNormal"><span style="font-size:10.0pt; color:#3B3838">UT Graduate School of Medicine, and UT Health Science Center, Knoxville</span></p>
<p class="x_x_MsoNormal"><span style="font-size:10.0pt; color:#3B3838">1924 Alcoa Hwy, Box U-111</span></p>
<p class="x_x_MsoNormal"><span style="font-size:10.0pt; color:#3B3838">Knoxville, TN 37920</span></p>
<p class="x_x_MsoNormal"><span style="font-size:10.0pt; color:#3B3838">P: 865-305-9528</span></p>
<p class="x_x_MsoNormal"><span style="font-size:10.0pt; color:#3B3838">F: 865-305-9527<br>
<a href="http://gsm.utmck.edu/med_library/main.htm" title="http://gsm.utmck.edu/med_library/main.htm"><span style="color:#3B3838">http://gsm.utmck.edu/med_library/main.htm</span></a></span></p>
<p class="x_x_MsoNormal"><span style="color:#1F497D"><img border="0" width="154" height="58" id="x_x_Picture_x0020_6" alt="logo" style="width:1.6041in; height:.6041in" data-outlook-trace="F:2|T:2" src="cid:image001.jpg@01DA1972.29888570"></span><span style="font-size:10.0pt; color:#3B3838"></span></p>
</div>
<p class="x_x_MsoNormal"> </p>
<div>
<div style="border:none; border-top:solid #E1E1E1 1.0pt; padding:3.0pt 0in 0in 0in">
<p class="x_x_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> Friday, November 17, 2023 11:02 AM<br>
<b>To:</b> eril-l@lists.eril-l.org<br>
<b>Subject:</b> I EXTERNAL I [Eril-l] Spreadsheet for database renewals - Samples</p>
</div>
</div>
<p class="x_x_MsoNormal"> </p>
<div>
<p class="x_x_MsoNormal"><span style="font-family:"Aptos",sans-serif; color:black">All:</span></p>
</div>
<div>
<p class="x_x_MsoNormal"><span style="font-family:"Aptos",sans-serif; color:black"> </span></p>
</div>
<div>
<p class="x_x_MsoNormal"><span style="font-family:"Aptos",sans-serif; color:black">I inherited the spreadsheet for all our subscription databases from the former ERL. I am now starting to create one for fiscal year
<span style="background:white">7/1/24 -6/30/25</span>. If you are okay with sharing your spreadsheet(s), I would love to see how you keep track of your database subscription renewals.</span></p>
</div>
<div>
<p class="x_x_MsoNormal"> </p>
</div>
<div>
<p class="x_x_MsoNormal"><span style="font-family:"Aptos",sans-serif; color:black">Thank you for considering!</span></p>
</div>
<div>
<p class="x_x_MsoNormal"><span style="font-family:"Aptos",sans-serif; color:black"> </span></p>
</div>
<div id="x_x_Signature">
<div>
<p class="x_x_MsoNormal"><b><span style="font-size:10.0pt; font-family:"Segoe UI",sans-serif; color:#642667; background:white">Maribel Castro, E-Resources Management Librarian</span></b><span style="font-family:"Aptos",sans-serif; color:black"></span></p>
</div>
<div>
<p class="x_x_MsoNormal" style="background:white"><span style="font-size:10.0pt; font-family:"Segoe UI",sans-serif; color:#201F1E"><a href="mailto:mcastro@excelsior.edu" title="mailto:mcastro@excelsior.edu">mcastro@excelsior.edu</a> </span><span style="font-size:10.0pt; font-family:"Segoe UI",sans-serif; color:#642667">|
(518) 608-8368</span><span style="font-size:11.5pt; font-family:"Segoe UI",sans-serif; color:#201F1E"><br>
</span><span style="font-size:10.0pt; font-family:"Segoe UI",sans-serif; color:black"><a href="https://library.excelsior.edu/" title="https://library.excelsior.edu/">Excelsior University Library</a></span><span style="font-size:12.0pt; font-family:"Segoe UI",sans-serif; color:black"><br>
</span><span style="font-size:10.0pt; font-family:"Segoe UI",sans-serif; color:black"><a href="https://libanswers.excelsior.edu/" title="https://libanswers.excelsior.edu/">Library FAQs</a></span></p>
</div>
<p style="background:white"><span style="color:black"><a href="http://www.excelsior.edu/" target="_blank"><span style="font-size:10.0pt; font-family:Montserrat; color:#0563C1; text-decoration:none"><img border="0" width="295" height="76" id="x_x_Picture_x0020_1" alt="Excelsior University link to website" style="width:3.0729in; height:.7916in" data-outlook-trace="F:2|T:2" src="cid:image002.png@01DA1972.29888570"></span></a></span><span style="font-size:12.0pt; font-family:"Segoe UI",sans-serif"></span></p>
<p style="background:white"><span style="font-size:8.0pt; font-family:"Verdana",sans-serif; color:black"> </span><span style="font-size:12.0pt; font-family:"Segoe UI",sans-serif"></span></p>
<p style="background:white"><span style="color:black"><a href="https://www.facebook.com/ExcelsiorU"><span style="font-size:9.0pt; font-family:"Verdana",sans-serif; text-decoration:none"><img border="0" width="44" height="44" id="x_x_Picture_x0020_2" alt="Excelsior Facebook link" style="width:.4583in; height:.4583in" data-outlook-trace="F:2|T:2" src="cid:image003.png@01DA1972.29888570"></span></a></span><span style="font-size:9.0pt; font-family:"Verdana",sans-serif; color:black">
</span><span style="color:black"><a href="https://www.linkedin.com/school/excelsioru"><span style="font-size:9.0pt; font-family:"Verdana",sans-serif; text-decoration:none"><img border="0" width="44" height="44" id="x_x_Picture_x0020_3" alt="Excelsior LinkedIn link" style="width:.4583in; height:.4583in" data-outlook-trace="F:2|T:2" src="cid:image004.png@01DA1972.29888570"></span></a></span><span style="font-size:9.0pt; font-family:"Verdana",sans-serif; color:black">
</span><span style="color:black"><a href="https://twitter.com/ExcelsiorUniv"><span style="font-size:9.0pt; font-family:"Verdana",sans-serif; text-decoration:none"><img border="0" width="44" height="44" id="x_x_Picture_x0020_4" alt="Excelsior Twitter link" style="width:.4583in; height:.4583in" data-outlook-trace="F:2|T:2" src="cid:image005.png@01DA1972.29888570"></span></a></span><span style="font-size:9.0pt; font-family:"Verdana",sans-serif; color:black">
</span><span style="color:black"><a href="https://www.instagram.com/excelsioruniv"><span style="font-size:9.0pt; font-family:"Verdana",sans-serif; text-decoration:none"><img border="0" width="44" height="44" id="x_x_Picture_x0020_5" alt="Excelsior Instagram link" style="width:.4583in; height:.4583in" data-outlook-trace="F:2|T:2" src="cid:image006.png@01DA1972.29888570"></span></a></span><span style="font-size:12.0pt; font-family:"Segoe UI",sans-serif"></span></p>
<p class="x_x_MsoNormal"> </p>
</div>
<p class="x_x_MsoNormal">This message and any attachments contain confidential Excelsior University information intended for the specific individual and purpose. If you are not the intended recipient, you should notify the University and delete this message.
Any disclosure, copying, distribution or inappropriate use of this message is strictly prohibited.
</p>
<div align="center">
<table class="x_x_MsoNormalTable" border="1" cellspacing="0" cellpadding="0" width="200" style="width:150.0pt; background:yellow">
<tbody>
<tr>
<td nowrap="" style="padding:7.5pt 7.5pt 7.5pt 7.5pt">
<p class="x_x_MsoNormal"><span style="color:black">[EXTERNAL]: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.</span></p>
</td>
</tr>
</tbody>
</table>
</div>
<p class="x_x_MsoNormal"> </p>
</div>
</div>
</div>
This message and any attachments contain confidential Excelsior University information intended for the specific individual and purpose. If you are not the intended recipient, you should notify the University and delete this message. Any disclosure, copying,
distribution or inappropriate use of this message is strictly prohibited. </div>
</div>
</div>
</body>
</html>