+ Reply to Thread
Results 1 to 4 of 4

Need a moving average that will update every time new data is entered

  1. #1
    Registered User
    Join Date
    09-30-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    7

    Need a moving average that will update every time new data is entered

    I want to create a moving average, exponential, weighted or simple(my preferences in that order) of the times that individual dogs take to complete a task. The task is a timed run over a course. It would be a moving average of the time awarded to each dog for each heat it competes in for the last 50 heats that the dog competed in. There are up to 5 heats in each race and each dog may or may not run in any or all of the heats. The dogs on a team are not static. I would need the formula to search two sheets in a workbook to find the dogs and their times and to return the moving average result in a column next to the dogís name on a separate sheet. The formula would need to ignore any text that is in any cell instead of a time, example #NA or NA.

    Iíve enclosed a workbook with three sheets, two sheets contain the data for the two different teams of dogs, and the third sheet contains the names of the dogs, all of which are not yet included in the data but may be in the future. In years to come even more dogs will be added and as some retire they will be removed from the list.

    I am a beginner to Excel and any help would be appreciated.

    Thanks

    Doug
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    01-16-2013
    Location
    Oklahoma City, OK
    MS-Off Ver
    Excel 2010
    Posts
    40

    Re: Need a moving average that will update every time new data is entered

    Have you tried this: http://www.excel-easy.com/examples/moving-average.html. This was the tutorial I used to make a moving average for something I needed.

  3. #3
    Registered User
    Join Date
    09-30-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Need a moving average that will update every time new data is entered

    Thanks for the information on constructing a moving average. I can't figure out how to select the last 50 data points for each dog and have it update each time I enter the results of a new race.

  4. #4
    Registered User
    Join Date
    09-30-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Need a moving average that will update every time new data is entered

    Bump no response

+ 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. How to detrend time series, and how to use moving average
    By excel-noob in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-12-2013, 01:47 AM
  2. [SOLVED] How to apply a 30 second moving average to data with inconsistent time intervals
    By WE5T in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-13-2012, 05:58 AM
  3. Calculate an average as data is entered?
    By Ltat42a in forum Excel General
    Replies: 2
    Last Post: 08-26-2009, 10:11 PM
  4. [SOLVED] Set up formula to update when new column data is entered
    By Bushman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-02-2006, 12:15 PM
  5. Replies: 2
    Last Post: 10-06-2005, 02:05 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