I have the data in a spreadsheet so far, and i know the main operation will be a delta percent calculation.
Wisdom I gleaned from a FB HP calculator user group posting on the matter has reports,
well the equation is F=P(1+i)^N
Where F is the future value
P is the present value
i is the inflation per period
N is the number of periods.
You can program this in as an equation for the solver, and find values for any of these variables... but there's one problem. Inflation isn't constant, so 'i' won't be a constant value. You'd need to create a table of inflation values for each time period. I don't know if it would be possible to utilize the solver for that....
Well the thing is, it’s all based on empirical data from the years in question, gleaned afterward. So it’s simple, but I think you basically need to store the consumer price index for each year into its own register.
To calculate, you. Take the start and end year and subtract to get the delta. Starting with the CPI for the first year, (indirect addressing would help) find the first year, loop through however many years you are spanning and multiply by each successive year’s CPI in the series.
Yes this would work as well. The key is definitely storing the values in some kind of look-up table.
I hope I am asking the right questions, and will have few more after hearing others' wisdom.
Many kind thanks!