×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
• Talk With Other Members
• Be Notified Of Responses
• Keyword Search
Favorite Forums
• Automated Signatures
• 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.

# 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

### 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,

Just traded in my OLD subtlety...
for a NUance!

"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...

---- 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

Skip,

Just traded in my OLD subtlety...
for a NUance!

"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)

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.

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:

• Talk To Other Members
• Notification Of Responses To Questions
• Favorite Forums One Click Access
• Keyword Search Of All Posts, And More...

Register now while it's still free!