+1 vote
23 views

Hi Jonas,

I've had an error while exporting a 50 000 iterations Monte Carlo, and I'm guessing it has to do with the maximum number of columns in Excel (16 384 = column A stays blank + columns B-K containing the results for each parameter + 16 373 individual results).

Would there be any workaround?

Thanks, and keep up the awesome work!
Charles

asked by (160 points)
retagged by

1 Answer

0 votes
answered by (13.3k points)
selected ago by
 
Best answer
Hi Charles, the Excel export is build up in the memory. Probably, it is just full at some point. A workaround would be to use openLCA IPC. You can use openLCA IPC to run a Monte Carlo Simulation via the developer tools and export the results as CSV. A description on how to run a Monte Carlo Analysis is given here https://github.com/GreenDelta/olca-ipc.py
commented ago by (160 points)
Alright, I'll try that
Thanks, Jonas!

Charles
...