• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Escalation from Base Years to Current Year by Country

S

SpartacusTNT

New Member
Problem! I am attempting to Escalate costs from multiple base years by Country using the Countries escalation table to the Current Year (2026) then forward escalate into the future. Any assistance would be greatly appreciated.
 

Attachments

Escalation-sheet has years and % - okay.
WBS-sheet's below has has currencies (without decimals) - okay.
What would be connection with those?
= You should able to show - Your valid expected values below 2026 with 'some-kind-of-formula' or so.
... as well as 2027 values.
 
Thanks for your response. I would like to from the base year costs in WBS (1990-2025) to escalate using the %ages in the Escalation sheet by country ie: France uses Column C in the escalation sheet to escalate the costs from D2:AM2 (Years 1990 - 2025). Hope that’s makes sense. Thanks
 
Did You noticed below writings?
You should able to show - Your valid expected values below 2026 with 'some-kind-of-formula' or so.
... as well as 2027 values.
And ... as You know, if those Your current values has NO decimals then it will affect results!
 
You must log in or register to reply here.
Back
Top