• 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!
 
Hi yes I saw the response. I also realise that I need ‘some kind of formula’ that’s the problem though, if I knew what formula I needed I wouldn’t really be asking for help. Good point about the decimal places though and will adjust to 2 Thanks
 
Okay, You saw ...
but You seems to skip below part of it.
You should able to show - Your valid expected values below 2026
Above means that You should also have some kind of great idea - what are those values?
Without that ... of course, eg I could give some kind of formula - which gives some kind of results.
Eg ... You could test with results £1 in 2026. Would it help You?
 
SpartacusTNT said:
Hi yes I saw the response. I also realise that I need ‘some kind of formula’ that’s the problem though, if I knew what formula I needed I wouldn’t really be asking for help. Good point about the decimal places though and will adjust to 2 Thanks
Click to expand...
You are not being asked to come up with a formula. You are being asked to tell us what results (values) you are expecting the formula to return. How else would we be able to test that a formula offered was calculating correctly?
 
AliGW said:
You are not being asked to come up with a formula. You are being asked to tell us what results (values) you are expecting the formula to return. How else would we be able to test that a formula offered was calculating correctly?
Click to expand...
Apologies for my misunderstanding. I was hoping the results for 2026 to show the escalated values from the base years for each country shown using the escalation table. For example if I have a cost in year 1990 for product 'Apples' against country 'France' what would the cost of that be at current economical conditions (2026). So Apples, France cost in 1990 was £25 escalated to 2026 would @ 121% would be £55.25 then in 1991 Apples, France was £33 escalated using the French escalation from 1991 to 2026 @ 119% would be £72.27. I would to do this for all Years from 1990 to 2026 against all the Countries and Products and show the results in the 2026 Column on the WBS sheet. I have updated the escalation excel file (V2) to include a results sheet which shows the expected results for the 1st line of the WBS. Thanks in advance and hopefully it makes sense.
 

Attachments

Last edited:
vletm said:
Okay, You saw ...
but You seems to skip below part of it.
You should able to show - Your valid expected values below 2026
Above means that You should also have some kind of great idea - what are those values?
Without that ... of course, eg I could give some kind of formula - which gives some kind of results.
Eg ... You could test with results £1 in 2026. Would it help You?
Click to expand...
Apologies for my misunderstanding. I have attached V2 of the escalation excel file with a Results sheet that shows the expected result in 2026 for the 1st line of the WBS. Thanks
 

Attachments

Hi,

1779356775684.png

1779356822893.png

£1428.25 is the cost escalated for all base Years as shown in the Result Sheet and that would be the expected result in WBS AN2

Thanks
 
Last edited:
Wow!
Most of previous years 'same-values' are about £25.17 and escalation values are about 3.27%.
... and now You write that for 2026 that value would be over 58 greater than previous values.
Of course, that would be possible ... but with which logic?
Is Your given the expected result valid?
What makes that huge step?
How to forecast next years? ... with which logic?
 
You must log in or register to reply here.
Back
Top