Following on Kyle's suggestions,
One of my libraries ran a weeding project to cull 50% of the physical book collection. I created shelflist spreadsheets that included a two barcode columns -- one in 3of9 font and one in human readable font -- as well as usage stats.
I'm sure I'm not getting the exact order right; but there were four or five people in the project and 10K items were culled with a minimum of accidental loss. This also included having to pack everything in boxes and physically remove the items from the library for renovations.
1. The full shelflist report was printed with minimum information and the scannable barcode.
2. Shelf checker would take 5 sheets at a time to shelves.
A. Read shelf
B. Mark item NOS on list if not on shelf
C. Scan item barcode into Excel spreadsheet from laptop on a cart
D. Place item in box (keep) or on second cart (discard) as appropriate
3. Sheets were handed off to cataloger for review of NOS
A. Confirm NOS
B. Decide if lost or missing
C. Decide how to withdraw as appropriate
D. Pass to collections librarian for purchase in ebook or replacement physical copy as needed.
4. Excel spreadsheet was compared (by team lead) against original shelflist report via VLOOKUP (I think). This had to do with keepers vs. discards. In particular, were the discards really going to be recycled or sent to off-site storage project.
The information contained in this e-mail message may be privileged, confidential, and/or protected from disclosure. This e-mail message may contain protected health information (PHI); dissemination of PHI should comply with applicable federal and state laws. If you are not the intended recipient, or an authorized representative of the intended recipient, any further review, disclosure, use, dissemination, distribution, or copying of this message or any attachment (or the information contained therein) is strictly prohibited. If you think that you have received this e-mail message in error, please notify the sender by return e-mail and delete all references to it and its contents from your systems.