Preparing Shelving Quality Control
Open the Quality Control Template
From the UNIV BUS Quality Control Template widget, click "Open in a new window."
Select the Date
Change "Loan Date" to the date for which you wish to create a Quality Control.
Export the List
Scroll to the bottom of the page and click "Export," then go to Excel > Excel 2007+.
Delete Columns
Hold CTRL down and select columns B, C, and E. Then right click on one of the columns and choose Delete.
Select Data
Select cell A5 then press CTRL+A to select the data.
Add Filter
Open the Data tab and click "Filter."
Filter Full Name
Click the down arrow next to Full Name (column F) and limit the list to people who work in Stacks. Then press OK.
Filter OK to Search
Click the down arrow next to OK to Search (column G) and uncheck "DO NOT SEARCH."
Sort by Check Call #
Click the down arrow next to Check Call # (column H) and select Sort A to Z.
Check Call #
Items are listed as "CHECK" to indicate their LC Classification Code and Number (which are needed for sorting) do not match the Full Call Number.
Fix Check Call #
Change the LC Classification Code and Number to match the Full Call Number.
Sort by LC Classification Number
Click the down arrow next to LC Classification Number (column B) and select Sort Smallest to Largest.
Sort by LC Classification Code
Click the down arrow next to LC Classification Code (column A) and select Sort A to Z.
Copy Barcode and Call Number
Select the items in the fields "Barcode" and "Full Call Number" (columns D & E), then press CTRL+C to copy the data.
Open Quality Control Template
Go to F:\Stacks\Stats\Quality Control\ and open the file called "ALMA Quality Control TEMPLATE."
Paste Barcode and Call Number
Right click cell C3 and click the "Paste as Text" symbol.
Add Date
Add the date of the list (the loan date in step 2) to the date cell.
Save File
Press CTRL+S to save the file at F:\Stacks\Stats\Quality Control\.
The file should be named QCYYYYMMDD where YYYYMMDD represent the date of the list (the loan date in step 2).
Print File
Press CTRL+P to print the file.
0 Comments
Add your comment