Good Morning Brittany,
If your institution has an enterprise license with Microsoft Office 365 then you can create a VERY effective application to cover your needs with Microsoft Power Apps. It's a lot easier than you might think... you can take that Excel document that you're maintaining and use it as a template to create a Sharepoint list (essentially an online version of the excel document). Once that's been created, you can select for Microsoft Power Apps to analyze the Sharepoint list and generate an App to fill data into the list. It will take less than a minute to build the app. From there, you can go into the Power App interface to change the look and feel... but you will basically have a view/search screen, data entry screen, and data editing screen.
We're taking inventory of our Cage Racks, BioSafetyCabinets, and Anesthesia Machines - so we can have real-time location data and effective space-use data - which we can combine with our Census data. The App won't win any UI/UX competitions but it's functional. Anyways, it was built in a single morning, using that same model... we took existing spreadsheet, convert to sharepoint list, auto-create Power app from Sharepoint list. From there, you could ask Microsoft CoPilot (their AI assistant for Power Apps) to add more functionality, if need be.
** The reason it asks for Cage Card number is that we created a "Vivarium" protocol - where the only species selected was "Vivarium" and the Per Diem/Housing rate descriptions were all the different hardware types & models. Now, while taking our RFID animal census - it's also counting & locating where our vivarium hardware resides.
------------------------------
Evins Wardlaw
Systems Analyst of Bioresources
St. Jude Children's Research Hospital
------------------------------
Original Message:
Sent: 09-04-2023 08:49
From: Brittany Roman
Subject: Animal Oversight and Noncompliance Reports
Good morning everyone
I was wondering how other institutions within cayuse animal oversight handle the reporting of deviations and/or adverse events? Any and all tips is welcomed!
------------------------------
Brittany Roman
IACUC Administrator
Ross University School of Veterinary Medicine
------------------------------