Hello,
I'm trying to identify the most efficient way to calculate individual component inflated costs (see columns AX and BA of the attached file). Inflated component costs are calculated by:
1) multiplying the uninflated costs in individual years (see UninflatedComponentCosts array in blue) by the compound inflation figure for that year located in row 85 at the very bottom
2) summarizing the individual annual inflated component costs across the array
Your help is most appreciated!
Regards,
Seattlite
Bookmarks