Capital Asset Planning Annual Cost Chart?

Hello all-

I'm working on capital asset replacement planning and would like to be able to visualize what assets need to be replaced each year, represented by their cost. Ideally, a table would have a list of assets on the left, and years across the top, and would automatically populate a replacement cost in the year that it falls. Here is an Excel sheet that shows the idea...

Any ideas on how to accomplish this?

Thanks very much!

~Jeff in North Carolina

Find more posts tagged with

Accepted answers

All comments

KPH

You can set up your smartsheet just like your excel sheet. Use row 2 as your column headings and put the inflation corrections into sheet summary fields so you can use those in your calculations.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.