Sign in with
Sign up | Sign in
Your question
Closed

Looking for best hardware and system settingsfor Excel calculations...

Last response: in Business Computing
Share
January 11, 2012 12:37:59 AM

At January 10 2012, what is the best recommended hardware I can buy to calculate a huge and complex EXCEL spreadsheet? ie, CPU, RAM, Boot Drive, other?

How about computer Windows 7 Ultimate OS settings?

How about EXCEL 2010 Office Professional settings?

Am doing a simulation model for a large hospital emergency department capacity design.

Thanks so much.
January 11, 2012 12:57:53 AM

Just about any modern office type PC with a multi-core CPU and 4GB or more of memory will meet your needs. The real question is how are you defining a "huge" spreadsheet and what is your budget? You really don't need to tweak Win7 or Office for spreadsheet manipulation.
Score
0
January 11, 2012 10:00:46 PM

Thank you for the response.

1,608,336,000,000 cells, all inter-related, each a 42 character formula.

I tried the absolute top of the line HP Off-The-Shelf, brand new this past weekend.

It stopped working.

Any other ideas?

Thanks.
Score
0
Related resources
January 11, 2012 10:15:19 PM

The current version of Excel (2010) only supports 1,048,576 rows by 16,384 columns, for a total of

17,179,869,184 cells. This is somewhat less than the
1,608,336,000,000 cells you require.

So, you are screwed, can't do it, sorry. Not sure how you managed to enter an Excel spreadsheet with 1,608,336,000,000 cells in the first place to test it on your top-of-the-line HP - are you certain those numbers are right? 1600 BILLION formulae?

regards

Stuart
Score
0
January 11, 2012 10:41:48 PM

toodles mcsnuff said:
Thank you for the response.

1,608,336,000,000 cells, all inter-related, each a 42 character formula.

I tried the absolute top of the line HP Off-The-Shelf, brand new this past weekend.

It stopped working.

Any other ideas?

Thanks.

Yes, that is huge, but seems unrealistic. How did you even build such a spreadsheet? In other words, what did you use to generate it?

Also, for ER simulation, it seems overkill by any stretch of the imagination. Please clarify.

The bottom line is this, that is an obscene amount of data to try to manipulate with any PC and certainly with Excel. You are going to have to reduce the data into digestible chunks or a use an alternate solution.

BTW, is this just a bunch of comma separate variables (CSV) outputs dumped into a spreadsheet?
Score
0
January 11, 2012 11:25:21 PM

Yes, sorry about that. I don't have the model in front of me.

Working from memory, I calculated in 1 second intervals as follows...

SECONDS 60
MINUTES x 60
HOURS x 24
DAYS x 365
PATIENTS x 51,000
# INTERVALS = 1,608,336,000,000

Whereas I will be working in 1 minute intervals as follows...

MINUTES x 60
HOURS x 24
DAYS x 365
PATIENTS x 51,000
# INTERVALS = 26,805,600,000

Only bits and pieces (~1%) of the model have been built because of the computing limitations I assumed may not be there. i.e., the quick and dirty brute force method with lots of RAM and CPU HP.

Any ideas are welcome.

Thanks.
Score
0
January 11, 2012 11:59:18 PM

For example, with CUDA tools.
Score
0

Best solution

January 12, 2012 2:03:18 AM

toodles mcsnuff said:
Yes, sorry about that. I don't have the model in front of me.

Working from memory, I calculated in 1 second intervals as follows...

SECONDS 60
MINUTES x 60
HOURS x 24
DAYS x 365
PATIENTS x 51,000
# INTERVALS = 1,608,336,000,000

Whereas I will be working in 1 minute intervals as follows...

MINUTES x 60
HOURS x 24
DAYS x 365
PATIENTS x 51,000
# INTERVALS = 26,805,600,000

Only bits and pieces (~1%) of the model have been built because of the computing limitations I assumed may not be there. i.e., the quick and dirty brute force method with lots of RAM and CPU HP.

Any ideas are welcome.

Thanks.

I would suggest you reduce your data set into intervals in order to be able to manipulate the data in a meaningful fashion. Also, what kind of emergency department needs to handle that level of load? This sounds more like FEMA level simulation and you need to use actual modeling/simulation tools vice a spreadsheet.
Share
January 30, 2012 10:42:17 AM

Best answer selected by mousemonkey.
Score
0
January 30, 2012 10:42:18 AM

This topic has been closed by Mousemonkey
Score
0
!