Hello all,
I'm wondering whether there is a single report that can be run, perhaps in ACCOORD role, in order to come up with the details needed to calculate the average daily census for a given period?
For calculating an average daily census for a given year, what I typically do is run 12 separate Cage Reports, picking a given day per month (e.g., the 15th), and export each as an Excel file,. For each of the 12 files, I sum the active count by species, then across files I sum the the 12 active counts per species, then divide each of those sums by 12 to get an average per species for the year. I'm hopeful there's an easier way that someone has figured out and is willing to share.
Cheers,
Cheryl
------------------------------
Cheryl Cheney, CPIA
IACUC Coordinator/Compliance Specialist
Biogen
Cambridge, MA
------------------------------