Hi,
i'm running a simulation of an insect and plant population dynamics. The simulation works perfctly with a small number of iterations (low values of UByear, UBday,nplants and Nsbb) however, it just occurred to me that entering the data with the intended number of iterations (UByear = 100, UBday = 120 and nplants = 300) will result in the data going over the 1048576 cell limit. Any suggestions as to how to enter all the data of interest? or put the data in a pivot table without entering into a worksheet?
attaching workbook for reference!
thanks in advance!
Bookmarks