Closed Solved

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

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.
9 answers Last reply Best Answer
More about looking hardware system settingsfor excel calculations
  1. 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.
  2. 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.
  3. 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
  4. 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?
  5. 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.
  6. For example, with CUDA tools.
  7. Best answer
    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.
  8. Best answer selected by mousemonkey.
  9. This topic has been closed by Mousemonkey
Ask a new question

Read More

Management Hardware Excel Business Computing