This sounds like a perfect job for a unix/linux system.  I'd export this
xls into a nice tab separated csv.  Then sort the column that contains the
call no.  Then compare the sorted columns to the original column with diff.

something along the lines of

diff -Nau <(original.csv | sort -k[[whatever field you want to sort by]])
original.csv

For the dewey titles you could add the -n flag to sort.

This is just a rough sketch, but with a little work I think it will work
for you and what's better it won't cost you dime. :)

On Thu, Jan 15, 2015 at 1:32 PM, Cab Vinton <[log in to unmask]> wrote:

> We're doing inventory here and would love to combine this with finding
> items out of call number order. (The inventory process simply updates the
> datelastseen field.)
>
> Koha's inventory tool generates an XLS file in the following format
> (barcodes, too, actually):
>
>   Title Author Call number  The last jihad : Rosenberg, Joel, FIC ROSEN
> Home
> repair / Rosenbarg, Liz. FIC ROSEN  Abuse of power / Rosen, Fred. FIC
> ROSEN  California
> angel / Rosenberg, Nancy Taylor. FIC ROSEN
> What we'd ideally like is a programmatic method of:
>
> 1./ identifying items like Home Repair and Abuse of Power, and
>
> 2./ specifying where such misshelved titles are currently located.
>
> For fiction, we're mostly concerned with authors out of order (i.e., title
> order *within* the same author can be ignored). For non-fiction, Dewey/
> call number order is, of course, the desired result.
>
> Thoughts on how best to tackle this? And no, shelf-reading while scanning
> is not an acceptable solution :-)
>
> My VBA skills are seriously rusty at this point, and there are some
> complicating factors (e.g,. how to handle to books in a row which are
> misshelved -- the second book's location should be compared to the last
> correctly shelved book; see Rosen/ Rosenberg above).
>
> Has this wheel already been invented?
>
> Grateful for any & all suggestions!
>
> Best,
>
> Cab Vinton, Director
> Plaistow Public Library
> Plaistow, NH
>



-- 
Ronald Houk
Assistant Director
Ottumwa Public Library
102 W. Fourth Street
Ottumwa, IA 52501
(641)682-7563x203
[log in to unmask]