Solve : My New Machine is Ssssslllloooowwwww?

1.	Solve : My New Machine is Ssssslllloooowwwww?
Answer» So corporate just bought us all new laptops. Most people use them for email and PowerPoint. I do lots of data analysis. For instance, I have one spreadsheet with four worksheets with 120+ columns and 55,000 rows of data, each. With calculations. Not enough horsepower to run Subtotals, and Access is hanging on me. I've been up til 3 last few nights, waiting for this thing to try to cook through my data. So... Stupid question. Is there anything I can do, like adding RAM, to HELP? Doubtful I'll get a new computer for 34 more months. Dell Latitude E6400 Win XP Pro SP 3 Intel Core 2 Duo CPU P 8600 @ 2.40 GHx 2.39 GHz, 2.98 GB of RAMThe RAM is pretty much maxed out for a 32 bit OPERATING system. This is not a problem of Computing power but rather insufficient allocation of that computing power and bad design on the part of the data management: Quote I have one spreadsheet with four worksheets with 120+ columns and 55,000 rows of data, each. With calculations. This is simply ludicrous. However did companies manage before Excel existed or before Excel was able to manage more then 32768 rows? Split the Excel file into multiple files. Five hours last night trying to split one file into its usable components. About 30 minutes time on task, rest waiting for recalcs, saves, crashes, etc. I have to take what the client gives me, you know? ("How did companies exist?" You weren't around then, were you?)Quote from: rjbinney on April 09, 2010, 12:04:44 AM I have to take what the client gives me, you know? that's true. I suppose that for every limitation they break with every new version, there are people that will use them, heh. Quote ("How did companies exist?" You weren't around then, were you?) Actually, I was being sarcastic. Obviously, with the limitation of 32768 rows they didn't have spreadsheets with 55,000 rows. But I guess every time they lift a limitation some silly person (client, in your case) takes it as an invitation that they should use that many rows Aside from that, you've got a lot of data to process and that's simply going to take a long time. no matter how you slice it. BEST I can think of is to somehow make your formulae faster, but that will probably not yield a huge speed GAIN.

Answer»

So corporate just bought us all new laptops. Most people use them for email and PowerPoint.

I do lots of data analysis.

For instance, I have one spreadsheet with four worksheets with 120+ columns and 55,000 rows of data, each. With calculations.

Not enough horsepower to run Subtotals, and Access is hanging on me.

I've been up til 3 last few nights, waiting for this thing to try to cook through my data.

So... Stupid question. Is there anything I can do, like adding RAM, to HELP? Doubtful I'll get a new computer for 34 more months.

Dell Latitude E6400
Win XP Pro SP 3
Intel Core 2 Duo CPU
P 8600 @ 2.40 GHx
2.39 GHz, 2.98 GB of RAMThe RAM is pretty much maxed out for a 32 bit OPERATING system.

This is not a problem of Computing power but rather insufficient allocation of that computing power and bad design on the part of the data management:

Quote

I have one spreadsheet with four worksheets with 120+ columns and 55,000 rows of data, each. With calculations.

This is simply ludicrous. However did companies manage before Excel existed or before Excel was able to manage more then 32768 rows?

Split the Excel file into multiple files.
Five hours last night trying to split one file into its usable components.

About 30 minutes time on task, rest waiting for recalcs, saves, crashes, etc.

I have to take what the client gives me, you know?

("How did companies exist?" You weren't around then, were you?)Quote from: rjbinney on April 09, 2010, 12:04:44 AM

I have to take what the client gives me, you know?

that's true. I suppose that for every limitation they break with every new version, there are people that will use them, heh.

Quote

("How did companies exist?" You weren't around then, were you?)

Actually, I was being sarcastic. Obviously, with the limitation of 32768 rows they didn't have spreadsheets with 55,000 rows. But I guess every time they lift a limitation some silly person (client, in your case) takes it as an invitation that they should use that many rows

Aside from that, you've got a lot of data to process and that's simply going to take a long time. no matter how you slice it. BEST I can think of is to somehow make your formulae faster, but that will probably not yield a huge speed GAIN.

Solve : My New Machine is Ssssslllloooowwwww?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment