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]