×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Data Table needs Inflated Value of Base cost x Inflation Factor from 2nd Table

Data Table needs Inflated Value of Base cost x Inflation Factor from 2nd Table

Data Table needs Inflated Value of Base cost x Inflation Factor from 2nd Table

(OP)
Condo Assoc. future replacements budget:

Table 1 (elements)
Element, year of replacement, # years away, Current Cost, est. future cost.
roof1 2026 4 25000 ?
deck2 2028 6 7000 ?

Table 2 (assumed price inflation)
year0, year1, year2, year3 year4
0, 5%, 5%, 2.5%, 2.5% inflation
1 1.05 1.1025 1.1300625 1.158314063

Assume roof1 needed in 4 years, and the inflation table shows a multiplier in year 4 of 1.158314063

formula that reads # years until replacement, and based on that, plant the est. future cost in the table? (Current cost x inflation multiplier based on years away)
Or, another method to tackle this table which will be pivoted for cash flow needs.

Thanks
Replies continue below

Recommended for you

RE: Data Table needs Inflated Value of Base cost x Inflation Factor from 2nd Table

Hi,

Is there a question?

Suggestions:

1) use Structured Tables Insert > Tables > Table
2) your lookup table is not structured to be useful in Excel
3) do not include years away in you table, cuz that changes EVERY YEAR.

Having done that in my workbook, here's a simple solution:

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

You Matter...
unless you multiply yourself by the speed of light squared, then...
You Energy!

RE: Data Table needs Inflated Value of Base cost x Inflation Factor from 2nd Table

(OP)
Thank you for the formula, Skip, you found and answered the question, now I have some work to do!

BFClem

RE: Data Table needs Inflated Value of Base cost x Inflation Factor from 2nd Table

How about a Star for Skip... ponder

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson

RE: Data Table needs Inflated Value of Base cost x Inflation Factor from 2nd Table

(OP)
Thanks, I did click the star before, but I now see the confirmation click that was missed, thanks for pointing it out!

Skip's help was invaluable.

BFClem

RE: Data Table needs Inflated Value of Base cost x Inflation Factor from 2nd Table

Glad that solved your problem.

I've uploaded my version of your example.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

You Matter...
unless you multiply yourself by the speed of light squared, then...
You Energy!

RE: Data Table needs Inflated Value of Base cost x Inflation Factor from 2nd Table

(OP)
Thank you again, Skip. Received.

BFClem

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close