?

Log in

No account? Create an account

Previous Entry | Next Entry

Argh...

Okay, so today's steaming pile of spreadsheet--a few years ago I helped make about 2000 library cards for our books, with information like titles and level indicating reading difficulty (from A to T).

Getting the charts together to make this involved a lot of lookup formulas to draw info from other spreadsheets. Now, most of the time, when I inserted a function to draw in the level of a book, say "N", I remembered to tell Excel to overwrite the cel value with the letter "N" intead of a lookup formula that returned the value "N", but to the unaided eye these are identical.

On a small number--say, 500 or so--I didn't replace the formula with its resulting value.

Generally, that's okay, it'll still read the same, until someone does a sloppy sort on the data. Then, cells on line 80 start referring to cells on line 64, or whatever.

Now, I'm checking through some 600 documents for these maladjusted numbers. This is taking forever...

Latest Month

August 2011
S M T W T F S
 123456
78910111213
14151617181920
21222324252627
28293031   
Powered by LiveJournal.com
Designed by Taylor Savvy