The “targets” worksheet in lognormdelta.xls at the models link now completely

implements a gamma waiting time for the mean reversion target to switch to a

new value.

The key to that page (and now a few cells on other pages)

is the EXCEL function OFFSET(cell0, rows, columns).

It puts into the current cell the value it finds by starting at the

cell referenced by cell0 and then shifting by the number of

rows and columns indicated. I.e. it looks up the (rows, columns)

entry in an open-ended matrix extending down and to the right

from cell0. Note carefully, cell0 is NOT the (1,1) entry of

the matrix. That entry is one over and one down from cell0.

If you don’t know that function, finding it out will be worth your

price of admission to the whole computing course.

MC with Logarithm Indices.xlsm

Monte Carlo 2013 05 16xlsm.xlsm

Ig & Igh v7.2 + Mu08032011.xlsm

Ig Igh v7 4 + Mu (2)08092011.xlsm

------