abacon1960
Board Regular
- Joined
- Jul 28, 2014
- Messages
- 54
I just received a Structural Steel Estimate that is using this formula for future escalation.
=AR20*((1+AS20)^(DAYS($AU$12,$AU$11)/365))
Inputs are as follows: AR20 cell contains the total amount for the steel in this line item
AS20 cell contains a number of 6% formatted in the percent format.
AU12 is the end date
AU11 is the start date
End Date = 01/01/2024
Start Date = 03/27/2023
Outputs are:
Total Amount of Steel = $17,464
Annual Percentage Rate = 6%
Total Escalated Costs = $18,263
I am not quite sure I understand this formula. Is there a better way to do this based on what you see here?
=AR20*((1+AS20)^(DAYS($AU$12,$AU$11)/365))
Inputs are as follows: AR20 cell contains the total amount for the steel in this line item
AS20 cell contains a number of 6% formatted in the percent format.
AU12 is the end date
AU11 is the start date
End Date = 01/01/2024
Start Date = 03/27/2023
Outputs are:
Total Amount of Steel = $17,464
Annual Percentage Rate = 6%
Total Escalated Costs = $18,263
I am not quite sure I understand this formula. Is there a better way to do this based on what you see here?