Spotty Logic (spottylogic) wrote,
Spotty Logic

  • Mood:
  • Music:


Trying to 'port data from one spreadsheet to another. I have 8000 rows and 124 columns to transfer data from, for a total of 992000 independent lookups. Each time I do more than about a hundred rows or 4-5 columns, it causes the system to crash.

So, I get clever, and I transfer the source data spreadsheet to "sheet 2" of the spreadsheet I'm working from, hoping if I'm not referencing another file, it'll work faster. It's a *little* faster. I notice it's re-checking each lookup as I paste in another 100 rows, so I write over each of the 3000x124 cells with its value (replacing an equation that looks up "425" with just "425.") This will speed things up immensely--except that in doing this, I've erased ALL my lookup equations.

So, I "Ctrl-Z" undo.

System crash--it looks up all the rows, and stalls.

MUCH more carefully, I set all the sheets up for the 'port again, and start doing things 3-4 columns at a time. I've gotten up to row "AG" of "DW" rows--and it's going pretty smoothly. I think scanning a few columns is much easier than scanning a few rows, since I'm using a vertical lookup.

And then...

Autosave kicks in. Crash.

(pounds head against blissfully unaware computer)

  • 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


    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened