Spotty Logic (spottylogic) wrote,
Spotty Logic
spottylogic

  • Mood:

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...
Subscribe

  • Aww :)

    So for YEARS the University of Texas Pagan, Vampire Larp, and GLBT groups tended to cluster around a particular oak tree in the west mall. I think we…

  • cargrump

    Whoof. I've taken a few beatings over the last few days over this. My office is moving across town, which spells an end for my nice little commute…

  • Tonight's experiment--

    Okay, so it's Dogai's birthday tonight. Bauson said that D really liked "biscoff" cookies, which are buttery little things with a touch of spice, and…

  • Post a new comment

    Error

    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened

  • 0 comments