[Eril-l] Spreadsheet for database renewals - Samples

[Electronic Resources in Libraries discussion list]

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.
We also use Google Sheets, not Excel, so our team can share it in real time.

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).
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.

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.

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.


Melissa Belvadi
mbelvadi at upei.ca
Make an appointment: https://mbelvadi.youcanbook.me/
________________________________
From: Eril-l <eril-l-bounces at lists.eril-l.org> on behalf of Electronic Resources in Libraries discussion list via Eril-l <eril-l at lists.eril-l.org>
Sent: Friday, November 17, 2023 12:01 PM
To: eril-l at lists.eril-l.org <eril-l at lists.eril-l.org>
Subject: [Eril-l] Spreadsheet for database renewals - Samples


CAUTION: 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 at upei.ca and delete this email.


WARNING: 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 at upei.ca and delete this email.

All:

I inherited the spreadsheet for all our subscription databases from the former ERL. I am now starting to create one for fiscal year 7/1/24 -6/30/25.  If you are okay with sharing your spreadsheet(s),  I would love to see how you keep track of your database subscription renewals.

Thank you for considering!

Maribel Castro, E-Resources Management Librarian
mcastro at excelsior.edu<mailto:mcastro at excelsior.edu> | (518) 608-8368
Excelsior University Library<https://library.excelsior.edu/>
Library FAQs<https://libanswers.excelsior.edu/>

[Excelsior University link to website]<http://www.excelsior.edu/>



[Excelsior Facebook link]<https://www.facebook.com/ExcelsiorU>  [Excelsior LinkedIn link] <https://www.linkedin.com/school/excelsioru>   [Excelsior Twitter link] <https://twitter.com/ExcelsiorUniv>   [Excelsior Instagram link] <https://www.instagram.com/excelsioruniv>

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.eril-l.org/pipermail/eril-l-eril-l.org/attachments/20231117/b53dbdc1/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Outlook-Excelsior .png
Type: image/png
Size: 10727 bytes
Desc: Outlook-Excelsior .png
URL: <http://lists.eril-l.org/pipermail/eril-l-eril-l.org/attachments/20231117/b53dbdc1/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Outlook-Excelsior .png
Type: image/png
Size: 1450 bytes
Desc: Outlook-Excelsior .png
URL: <http://lists.eril-l.org/pipermail/eril-l-eril-l.org/attachments/20231117/b53dbdc1/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Outlook-Excelsior .png
Type: image/png
Size: 1516 bytes
Desc: Outlook-Excelsior .png
URL: <http://lists.eril-l.org/pipermail/eril-l-eril-l.org/attachments/20231117/b53dbdc1/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Outlook-Excelsior .png
Type: image/png
Size: 1772 bytes
Desc: Outlook-Excelsior .png
URL: <http://lists.eril-l.org/pipermail/eril-l-eril-l.org/attachments/20231117/b53dbdc1/attachment-0003.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Outlook-Excelsior .png
Type: image/png
Size: 1869 bytes
Desc: Outlook-Excelsior .png
URL: <http://lists.eril-l.org/pipermail/eril-l-eril-l.org/attachments/20231117/b53dbdc1/attachment-0004.png>