• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Maintenance interval predictor

Jagan_Deesh

New Member
Hello All,

I trying to create the upcoming service schedule for vehicles by providing current KM's and Date of sale as a input.

I have specified maintenance intervals (Kms an duration wise) with me, Pl help me with formula.
 

Attachments

  • Sample.xlsx
    8.5 KB · Views: 6
That was what I attempted. By calculating the average for km/month you can extrapolate to the expected date of the next service. Then take the minimum of the two dates. I think that you also should also record a service history. Later services should probably fall within 3 months of the previous service rather than being related back to the purchase date.
 
Back
Top