[Date Index] [Thread Index] [Author Index]

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