(To be completed monthly)
The spreadsheets for these statistics is kept at: \corrina\departments$\Collection Management\Statistics (Millennium)
Spreadsheets are arranged in folders by fiscal year. Make a new copy for each month.
New Items
1. Enter the Statistics function in Sierra (in Database Management).
2. Select the “Items created” query and choose to edit it.
3. Change the starting month to the previous month (the month for which you are running the report)
4. Click "Run the Query!" (When asked if you want to accumulate in the background, select Yes.)
5. When the Query is finished, open the results and select the Location Report. Then, press Export. Choose to open the file in Excel.
6. Open the previous Items Added spreadsheet and save a new copy (if desired).
7. Copy the “Record Count” values from the report into the Items Added spreadsheet in the appropriate cells.
8. Return to the main tab and save.