4 ms·
> 200k by 50 line Excel 2007 spreadsheet on a IBM Core Duo laptop with only 1GB of RAM and XGA scren. It would take ten minutes to apply a single filter. This
by MagnumOpus 10y ago
> 200k by 50 line Excel 2007 spreadsheet on a IBM Core Duo laptop with only 1GB of RAM and XGA scren. It would take ten minutes to apply a single filter.
This is implausible. I worked with far bigger datasets, and far more complex calculations, and it didn't take minutes - several seconds, maybe.
- phonon 10y ago"1 GB RAM"
- dx034 10y agoThat's the key point here. We recently upgraded all computers to at least 16GB ram solely because of huge Excel spreadsheets that we use.
- orbitingpluto 10y agoI'm talking about a filter, not calculations. And I'm so glad you mystically decided that your calculations were much more complex than whatever I was doing.