<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<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);">
I can't easily share the spreadsheet, because it's our entire acquisitions budget tracking system, not just for the one purpose of subscription dates.</div>
<div class="elementToProof" style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
We also use Google Sheets, not Excel, so our team can share it in real time.</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);">
But what we do is at the start of every fiscal year, we copy the old spreadsheet file over to a new file, and then move all of the subscription columns to the right (inserting new columns for the current fiscal year).</div>
<div class="elementToProof" style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
That way we have the complete history (including the date we processed the invoice last year, and the total cost) from the previous year or two right in the same rows. For awhile I had tried to keep many years together, but it got to be too much, so now we
just keep one year back.</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);">
I had also at one point written a Google Sheet script that would send an email to the appropriate person if the renewal reminder column in any of the subscription rows had a date that was older than "today". We stopped using that as our subscription list got
short enough for the technician to monitor manually, but that's another way to go with this.</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);">
If anyone is interested in seeing our Google Sheet script code, I'm happy to share it offline. Unfortunately, one of the few aspects of Google Sheets that is not compatible with MS Excel is the scripting language, so our code would only be relevant to other
Google Sheet users.</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);">
<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> Friday, November 17, 2023 12:01 PM<br>
<b>To:</b> eril-l@lists.eril-l.org <eril-l@lists.eril-l.org><br>
<b>Subject:</b> [Eril-l] 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)">
All:</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 class="x_elementToProof"><span style="font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Calibri,Helvetica,sans-serif; font-size:11pt; color:rgb(0,0,0)">I inherited the spreadsheet for all our subscription databases from the former ERL. I am now
starting to create one for fiscal year </span><span style="letter-spacing:normal; font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Calibri,Helvetica,sans-serif; font-size:14.6667px; font-weight:400; color:rgb(0,0,0); background-color:rgb(255,255,255)">7/1/24
-6/30/25</span><span style="font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Calibri,Helvetica,sans-serif; font-size:11pt; color:rgb(0,0,0)">. If you are okay with sharing your spreadsheet(s), I would love to see how you keep track of your database
subscription renewals.</span></div>
<div class="x_elementToProof"><span style="font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Calibri,Helvetica,sans-serif; font-size:11pt; color:rgb(0,0,0)"><br>
</span></div>
<div class="x_elementToProof"><span style="font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Calibri,Helvetica,sans-serif; font-size:11pt; color:rgb(0,0,0)">Thank you for considering!</span></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 style="font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Calibri,Helvetica,sans-serif; font-size:11pt; color:rgb(0,0,0)">
<span style="font-size:10pt; color:rgb(100,38,103); background-color:rgb(255,255,255)"><b>Maribel Castro, E-Resources Management Librarian</b></span></div>
<div style="margin:0px; background-color:rgb(255,255,255)"><span style="font-size:10pt; font-weight:400; color:rgb(32,31,30)"><a href="mailto:mcastro@excelsior.edu" title="mailto:mcastro@excelsior.edu">mcastro@excelsior.edu</a> </span><span style="font-size:10pt; color:rgb(100,38,103)">|
(518) 608-8368</span><span style="font-size:15.3333px; font-weight:400; color:rgb(32,31,30)"><br>
</span><span style="font-size:10pt; font-weight:400; color:rgb(0,0,0)"><a href="https://library.excelsior.edu/" class="x_ContentPasted1" title="https://library.excelsior.edu/" style="margin:0px">Excelsior University Library</a></span><span style="font-size:12pt; color:rgb(0,0,0)"><br>
</span><span style="font-size:10pt; font-weight:400; color:rgb(0,0,0)"><a href="https://libanswers.excelsior.edu/" class="x_ContentPasted1" title="https://libanswers.excelsior.edu/" style="margin:0px">Library FAQs</a></span></div>
<p style="font-size:12pt; background-color:rgb(255,255,255)"><span style="font-family:Montserrat; font-size:10pt; color:rgb(5,99,193)"><a href="http://www.excelsior.edu/" target="_blank" class="x_ContentPasted0" style="margin:0px; color:rgb(5,99,193)"><img alt="Excelsior University link to website" style="width:2.781in; height:0.708in; margin:0px" data-outlook-trace="F:2|T:2" src="cid:3371623f-0074-4696-8587-e2495445650b"></a></span></p>
<p style="font-size:12pt; background-color:rgb(255,255,255)"><span style="font-family:Verdana,sans-serif; font-size:8pt; color:black"> </span></p>
<p style="font-size:12pt; background-color:rgb(255,255,255)"><span style="font-family:Verdana,sans-serif; font-size:9pt; color:rgb(0,0,0)"><a href="https://www.facebook.com/ExcelsiorU" class="x_ContentPasted0" style="margin:0px"><img alt="Excelsior Facebook link" style="width:0.197in; height:0.197in; margin:0px" data-outlook-trace="F:2|T:2" src="cid:64f6c025-7704-452e-bb53-616cbf5d2f2d"></a>
<a href="https://www.linkedin.com/school/excelsioru" class="x_ContentPasted0" style="margin:0px">
<img alt="Excelsior LinkedIn link" style="width:0.197in; height:0.197in; margin:0px" data-outlook-trace="F:2|T:2" src="cid:42a260e6-e8ef-4909-832b-1de844555a13"></a>
<a href="https://twitter.com/ExcelsiorUniv" class="x_ContentPasted0" style="margin:0px">
<img alt="Excelsior Twitter link" style="width:0.197in; height:0.197in; margin:0px" data-outlook-trace="F:2|T:2" src="cid:922d889f-ab4a-42d2-b654-4d90193278e3"></a>
<a href="https://www.instagram.com/excelsioruniv" class="x_ContentPasted0" style="margin:0px">
<img alt="Excelsior Instagram link" style="width:0.197in; height:0.197in; margin:0px" data-outlook-trace="F:2|T:2" src="cid:687dcd0e-636a-4301-9bc8-3de0afd02c8d"></a></span></p>
<span style="font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Calibri,Helvetica,sans-serif; font-size:11pt; color:rgb(0,0,0)"><br>
</span></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>