Saturday, December 09, 2006

Directors' Station vs Unicorn Reports

All, I’ve fielded some questions about the difference between the numbers obtained in Unicorn Reports and those obtained in Directors’ Station. The attached excel file demonstrates this. I ran a circ report for November by User Profile in both Directors’ Station and in Unicorn Reports. The fist tab of the spreadsheet shows the results from Directors’ Station where we have a total circ of 145,466. The second tab shows the same report in Unicron Workflows with a total circ of 138,255. That is a difference of 7,211 or 4.96%. You can see both reports compared in the third tab. If we factor in the profiles that the Directors’ Station report is counting that the Unicorn one is not, such as Discard and Missing or Display along with the number of reserve item checkouts which also are not captured by the Unicorn report we get a difference of 12 or 0.0082%. Where did these 12 items slip through the crack? I cannot be certain from these numbers but since the only two profiles that don’t match are Del Tech Student and Faculty I can assume that these are reserve items that may have been renewed and not counted in the Unicorn Report. I can’t be certain because I cannot see what these 12 items were nor do I know if Del Tech allows renewals on reserve items. The fact still is we are not talking about a very significant number. If you have any other questions about this please email me.

No comments: