Forum Discussion
Apply An escalation rate depending on the year
Define "Net Calc". Is it dollars? Days? The description made it sound like you would enter the initial fee or rate which in my case would be $/hr and Net Calc would be the average rate over the duration. No?
| start date | end date | rate | escalation | Holidays | Net Calc |
| 2/20/2023 | 4/14/2023 | $1.00 | 0.04 | 40.00 | |
| 2/20/2023 | 4/14/2024 | $1.00 | 0.04 | 303.00 | |
| 2/20/2023 | 4/14/2028 | $1.00 | 0.04 | 1469.95 |
MegArchSTN Basically the original posting requested a formula that would increase the rate each new year by the escalation amount. So in your example line 1 is at $1/day and 40 workdays. Line 2 is a little more than a year so for 225 workdays of the initial year it is billed at $1/day but then the 75 workdays of the next year it is billed at 1.04/day resulting in 303 instead of 300. see this example:
line 1 shows same as yours. line 2 shows days in year 2023. line 3 shows days in year 2024 (because the start date is 1/1/2024 the rate on line 3 stays $1/day) and then line 4 shows your line 2 and how the total changes because it crossed over to a new year. Hope that helps you understand what this formula does. If you need something else, feel free to post a new message/thread.
- Got it. Makes sense.
What happens when you have a phase that doesn't start for say 2 years? Escalation is still increasing before the phase starts. Looks like escalation currently starts in the start year which isn't always the case.- yeah I don't know what you expect there. A formula can't guess at the start time. You could add another column called Contract Date or Initiation Date or something and use that column instead of Start Date.
- I'm thinking of calculating the formula using TODAY as the start date, and then subtracting the time from TODAY to the start date.