Re: [libreoffice-users] Calc formula ...

Brian Barker <b.m.barker@btinternet.com> wrote:

> At 10:28 11/03/2015 +1300, David Love wrote:
> > What I want, in simple terms, is to determine the average number of
> > steps I am taking every week. Hopefully, this explanation will answer
> > the questions reaided.
>
> Not really!
>
> I think you've confirmed that the 10000 figure is irrelevant in the
> calculation. But your earlier statements that "if day 1 reaches a
> production of 10,000 units I want this figure entered" and "If days
> 1+2+3+4 total, say, 42,500 I want ... to show the average of 10,265"
> both indicate that the required result does not depend on other daily
> values. These contradict the idea that you simply want the true average
> of all seven values.
>
> Unsurprisingly, you can calculate averages using the AVERAGE() function.
>
> Incidentally, doesn't all this cry out for a table instead of a list?
> Put a week date (or date range) in column A, as you suggest. Enter your
> data for the days of that week in columns B to H of the same row. It's
> then particularly simple to calculate averages in column I. At the
> bottom of the columns, you could calculate averages for each weekday -
> and perhaps discover that you need to be more active on Thursdays!

Ha!  I constructed a table, as you suggested and, yes, it does meet my
requirements.

Thanks for the suggestion, Brian.

David

-- 
David Love
Dogs wag their tail with their whole heart. 

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted