Mathematica Link for EXCEL
- To: mathgroup at smc.vnet.net
- Subject: [mg64707] Mathematica Link for EXCEL
- From: actuary at mchsi.com
- Date: Tue, 28 Feb 2006 01:49:39 -0500 (EST)
- Sender: owner-wri-mathgroup at wolfram.com
I'm developing a Monte Carlo simulation in EXCEL using the @Risk add-in. At the end of each iteration of the simulation, I would like to use Mathematica to analyze the results of the iteration results, a column of 360 values. As I was developing the Mathematica code that I inended to use as EXCEL functions, I used a column of values designed to test my code. Everything worked to my satisfaction. As soon as I started using the data produced by the Monte Carlo simulation, my code still woked but the process trigged a recalculation of the values in the EXCEL spreadsheet. The time to run the Mathematica based analysis of a single iteration of the 10,000 iteration Monte Carlo Simulation was now considerably longer than when using the test data. Is there anything that I can do (programming-wise) to prevent the unnecessary recalculation of the EXCEL spreadsheet?. Thanks Larry