Little random note
Jan. 25th, 2006 02:53 pm![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
selenayI have a feeling that Excel taking ten minutes to calculate all the cells in the spreadsheet that I'm building implies that I've got way too many cells with formulas in.
It's only 3000 rows. With eleven columns. Of VLOOKUPs.
Erm.
I think that I need to figure out another way to do this. 'Cos my super whizzy, 2GB of RAM machine is almost falling over each time the cells calculate, so the rest of the office on their 256MB of RAM may have problems.
Did you know that it's possible to get 100% CPU usage in your task manager that way?
I think that I need a break. I've obviously gone insane. Or possibly I just need an insanity icon.
It's only 3000 rows. With eleven columns. Of VLOOKUPs.
Erm.
I think that I need to figure out another way to do this. 'Cos my super whizzy, 2GB of RAM machine is almost falling over each time the cells calculate, so the rest of the office on their 256MB of RAM may have problems.
Did you know that it's possible to get 100% CPU usage in your task manager that way?
I think that I need a break. I've obviously gone insane. Or possibly I just need an insanity icon.
no subject
Date: 2006-01-26 11:09 am (UTC)And thanks for the reassurance on all counts ;-)