+ Reply to Thread
Results 1 to 4 of 4

Work out Yearly values

  1. #1
    Registered User
    Join Date
    05-21-2015
    Location
    england
    MS-Off Ver
    2013
    Posts
    8

    Work out Yearly values

    Hi Guys,

    Hoping someone who is a whiz at excel can help.

    So I want to find out yearly mileage increases of my car. I have ten years of mileage entries, but they are at random times a year an not one year apart each time.

    Is there a way I can get excel to calculate a estimated annual mileage for each year?

    I'm guessing I could just plot a graph and use a trend line and pick out the same time of year, but I'm sure there is a smarter way!

    I tend to come across this problem a lot!

    Here is my data if that helps

    I'm hoping this makes sense....

    Mileage Date
    10168 04/09/2007
    19906 05/03/2008
    30601 01/10/2008
    40405 05/10/2009
    40577 08/10/2009
    49782 05/07/2010
    50434 27/07/2010
    54499 09/06/2011
    68732 31/05/2012
    83197 17/12/2014
    90225 11/12/2015
    95623 23/02/2016

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,899

    Re: Work out Yearly values

    mean miles per year:

    =SLOPE(A2:A13,B2:B13)*365
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Registered User
    Join Date
    05-21-2015
    Location
    england
    MS-Off Ver
    2013
    Posts
    8

    Re: Work out Yearly values

    Quote Originally Posted by Glenn Kennedy View Post
    mean miles per year:

    =SLOPE(A2:A13,B2:B13)*365
    Hi there,

    Thats great thank you.

    That certainly gives me a good indication of milage each year taking into consideration the increases and decreases over the years.

    Do you know of a way I can get excel to fill in predicted values for a certain point of year, each year.

    For example,

    Say I want to present how many miles are acheived on the 1st Jan each year. But I only have data for various points throught the year. Can I get excel to fill in as best as possible? This would be really helpful as sometimes I don't have any data for certain years, so would help me fill in the predicted value for that year on the 1st jan.

    I have a feeling I am not explaining myself very well.

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,899

    Re: Work out Yearly values

    Like this (using the equation of a straight line...)
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Average values in Settlement into Yearly Average.
    By Jim15 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-24-2014, 04:56 PM
  2. Average values in Settlement into Yearly Average.
    By Jim15 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-24-2014, 02:16 PM
  3. Adding a Worksheet to work out my Weekly/Monthly/Quarterly/yearly income
    By DaleWinton in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-15-2014, 08:21 PM
  4. Replies: 2
    Last Post: 03-17-2014, 07:58 AM
  5. Replies: 1
    Last Post: 03-08-2013, 04:18 PM
  6. Replies: 5
    Last Post: 03-07-2013, 11:38 AM
  7. Replies: 13
    Last Post: 08-17-2011, 02:16 PM

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