Consider uing SPSS as a data exploratory tool for this type of analysis
http://www.spss.com

Cheers
Nigel


"ExcelMonkey " wrote in message
...
sorry for the hiatus. I am looking to forecast hourly data over 15 or
more years. Ignoring leaps years gives me 8670 hours per year. 8670*15
years = 131,400 elements.

I then want to do this stochastically. Thus my 1D array will need to
be 131,400 elements, and my 2D array will need to incorporate the
stochastic runs (i.e. 1,000 or so).

I justed used 65,000 becuase I was going to print the array data to
excel to see if I was doing it right. If 65,000 by 1,000 doesn't work
then I do not know how I will get around needing 131,400 by 1,000.

When you use hourly data over large time period, excel just doesn't cut
it due to its memory issues. Models get bogged down due to large
amount of data. I was hoping that VBA would be the answer for this.


---
Message posted from http://www.ExcelForum.com/





----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---