For years I have been frustrated with the limitations of Excel.
I need to perform 'IF, AND, OR' etc formulas down 200,000+ rows by 10 columns wide, all cells in that range
contain formulas. Excel can accommodate around 40,000 rows making that 400,000 cells of formulas in an
acceptable time period. I would run about 20-30 simulations in the space of one hour.
When using Excel and rows of 70k + the CPU would run to 100%
I would like to know if Stata can carry out the above as I purchased version 10 about three years ago and it is
currently being unused. I was a user of Stata a few years ago but on pre programmed code. I am not a programmer
but willing to learn the basics required to perform these tasks.
The computer spec is as follows: Dell 7500 Inspiron Workstation with memory riser 24GB Ram and 8 processors.
Hard drive 450GB with 330GB free. I would consider increasing the RAM to say 96GB if it would speed things up.
Any advice you can give would be much appreciated.