1. SpineOMatic has the option to print labels in a batch. This is the method used to print full sheets of labels, instead of one-at-a-time.
2. You can have up to three different batches. The program will also indicate how many items are in each batch.

1. After you have created a batch with call numbers in it, click on the Reports Tab (Panel)
2. There is a grey box where items can be configured.

1. If you don't change any settings, and just click on the Run button,
2. you will see a count of the number of labels made for the date range specified.

You can also see statistics based on the different locations of the items. If the Alpha radio button is selected, these locations will be displayed in Alphabetical order. if Count is displayed, the items will be in highest quantity to lowest.

1. To get the specific barcode information for a specific day (it may contain more than one batch), use the From and to fields to find the date you want.
2. Set the Sort by radio button to Count, to have the items display in the order they show up in the batch. If you choose Alpha, it will reorder the barcodes - not what you want.
3. Click the radio button next to Details. You do not have to put anything in the filtered by field.
4. Click on the Run button.
5. In the lower pane, you will see the date & time the items were scanned, the barcode numbers, the owning libraries, and the locations where the items live.
6. The Total labels printed in date range should match the number of entries in the batch you are working with. If the number is different, you may need to delete items if they were scanned earlier in the day, before you created the batch (check the times)
7. Click on Copy to clipboard.

Open Excel.

Select Blank workbook.

In order for the barcode numbers to be formatted properly, before you paste the information from the clipboard, you must tell Excel that you would like the columns to formatted as Text.

1. Highlight at least five columns.

2.     With the columns still highlighted, right click

3.     Navigate to Format Cells...

4.     Under the Number Tab, select Text.

5.     Click on OK.

Now click on Paste.

You may see a message that there are size differences. This is not a problem. Click on OK.

You will see the data from SpineOMatic appear. Some columns may be squashed a bit.

You can delete rows and columns that you do not need.

In this case, the entry for 6/3/2016, 15:22:37 is being deleted because it was scanned earlier in the day than the rest of items.

The User column is being deleted because it is not relevant.

You can see the different libraries and locations of the items.

21 July 2016 version