I was curious if anyone would be willing to share their process for keeping track of standing orders (or continuations). I have around 1000 titles on an excel sheet that get distributed to 11 locations. It lists the title, the fund to charge, location receiving item, note field, bib number. On another tab we keep the history of costs, invoice numbers, date received, etc. This is fine until I need to crunch the numbers. For example: give me a list of titles purchased for Business Reference and the costs for each this past year. When I arrived the system was on sheets of paper so compiling date was basically impossible. I have put it on excel, but there has to be a better system or format that I am missing. I have been able to use some advanced (at least to me) excel functions to get some numbers, but I would like it to be more user friendly. Any thoughts or suggestions would be appreciated.
Thanks,
Todd Barrett
Acquisitions Manager
Richland County Public Library
tbarrett_at_myrcpl.com<mailto:tbarrett_at_myrcpl.com>
_______________________________________________
ACQNET-L mailing list
ACQNET-L_at_lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/acqnet-l
Received on Fri Feb 17 2012 - 12:38:44 EST