Once you open it up, everything is color coded and tracks from the table to the chart
on the lower right are the steps in the process
you start with cols a-c and rows 1-14
and successively add the additional columns
as each new parameter is estimated
by highlighting the contents of each cell, you can see what each column of calculations is doing...
the only tricky piece is step 6 in cols g and h, rows 33-41
it's a 2-way excel table function for finding the point at which the "mape" is minimized
why don't you work with it and we can reconvene with your questions later?
