Moving Average

English
#1

ATTENDANCE SHEET.ods Hi

I hope somebody can help me out with my problem. I have looked around and not found a solution. There is one on the net for Excel but it is very drawn out and whilst it works I thought somebody on the Forum could come up with the Calc answer.

I have ODS file where I enter attendances on particular dates by individual sections. So my spreadsheet ends up with a lot of blank columns etc.

I like to look at the overall average but more importantly the averages over the last 2 or 3 are more important and relevant. Can somebody help me out here please. I currently have to manually update the calculaton.

Many thanks
Nev

#2

it is not very clear what you mean by “last 2 or 3 are more important”, rows, columns?
in general what about inserting in some cell: =AVERAGE(C60:H62) adapt the range according to your needs

#3

Moving averages require a way to designate a range for which the average shall be evaluated based on position and size. To get sufficient flexibility, the appropriate function is OFFSET().

All the lookup and matching in spreadsheets is done top down and/or left to right. If the “youngest” entries are of special interest it’s therefore often recommendable, to add new entries at the top of the data range. Details depend.

You didn’t tell of what numbers the average should be taken, and there’s lots of room for intrepretation. However I made a kind of “solution” also containing some hints how to make such a sheet more clear and efficient. You may study it, and tell what’s wrong with it.

ask316884anotherMovingAverage_1.ods

Regarding the recent comment by the OQ:
ask316884anotherMovingAverage_3.ods

#4

Thank you for taking the time to look at my problem. Sorry I didn’t explain more clearly when I posted but I was looking at the averages under the headings 701/712/715, 702/713,703/714 etc.

regards
Nev

#5

Please try to be more precise from the beginning next time.
Myself, and surely some more of the contributors are curious. You might therefore better also tell a bit about the use-case.

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.