Results 1 to 4 of 4

How to take event intervals and use Excel to build a timeline?

Threaded View

  1. #1
    Registered User
    Join Date
    08-14-2012
    Location
    Seattle
    MS-Off Ver
    Excel 2003
    Posts
    3

    How to take event intervals and use Excel to build a timeline?

    Found this site while trying to search for an answer, but I'm not even entirely sure what to search for. I'm building an operations & maintenance model to predict major maintenance intervals based on how a machine is being used. I'll make up an analogy to illustrate.

    Let's say you have a bicycle, and you have to service it as follows:
    Every 3 rides, grease the chain
    Every 10 rides, overhaul the chain (resets the "grease" interval)
    Every 32 rides, replace the chain
    <repeat>

    I want Excel to list the timeline of events going forward. So if the bike has been ridden 11 times already (and thus an "overhaul" was performed at 10), I want the following:

    Column A____Column B (aka, how many more rides from today)
    grease______2
    grease______5
    grease______8
    overhaul_____9
    grease______12
    grease______15
    grease______18
    overhaul_____19
    replace______21

    Thank you!
    Last edited by MisterW; 08-15-2012 at 07:22 PM. Reason: formula looks robust

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1