Large Model Question

S

semantina

Hello!

I have a few excel model files of the following sizes - 200 megabytes, 320 megabytes and 650 megabytes. I have 4 sets of data to be calculated by these models and combined in a single file. They can be either recalculated 4 times for each of the data sets - their results stored in a single file and then combined in a report after the final calculation. Or - I am thinking of buying more ram for my excel 64 and open up 4 instances of the aforementioned model files for each of the data set - so that all can be calculated at once. I calculated the total size of the models in memory would be 1600 megabytes - in the last case 6500 megabytes. I have Xeon e5-1650 - not sure if the last setup would work better - please let me know. It would allow tobypass the intervening stage of storing the separate results and combiningthem afterwards.

Will be happy to hear what you think!

D
 
D

Don Guillett

Hello!



I have a few excel model files of the following sizes - 200 megabytes, 320 megabytes and 650 megabytes. I have 4 sets of data to be calculated by these models and combined in a single file. They can be either recalculated 4times for each of the data sets - their results stored in a single file and then combined in a report after the final calculation. Or - I am thinkingof buying more ram for my excel 64 and open up 4 instances of the aforementioned model files for each of the data set - so that all can be calculatedat once. I calculated the total size of the models in memory would be 1600megabytes - in the last case 6500 megabytes. I have Xeon e5-1650 - not sure if the last setup would work better - please let me know. It would allow to bypass the intervening stage of storing the separate results and combining them afterwards.



Will be happy to hear what you think!



D
Click to expand...

I think a report file could be created that would use macros to fetch then necessary info from each to that file.

BTW, have you cleaned out the sludge in your files and changed formulas that are no longer needed to values?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA not adding elements to Solver model 0
Lookup Table 1
Xbox Slim 4GB model (1439) Mod 8
Entity Framework on large model 8
pass object from model to view in event 4
userform label.caption 1
Parent / Child Query Assistance 7
Paasing Values from one Array to another 2

Top