Pete,
Pardon me. I'm confused.
When you say C5 (for example) which do you mean, Row 5 in Column C or the fifth column?
Where is the calculation?
You speak of C1, C3, C5, C7, ... but what about C2, C4, C6, C8, ...?
Here is what I understand (my suppositions):
Row 1 is a ser of column headings.
Column A contains a set of names (of regions maybe).
Columns C, E, G, I, ... are headed by dates (e.g. Jan 1, Feb 14, etc.).
At the intersection of column C and row 2 is a number (maybe a counter of some kind) relating to
the first region from Jan 1 through Feb 13. Other cells in columns C, E, G, I, ... get filled
similarly.
Starting with the third time interval you want to calculate the average of the most recent three
vakues stored in those cilumns bur adjusted by some mystery constant for that region (column B
maybe) and maybe store that result in columns D, F, H, J ....
If I'm right, which is a mighty big IF, then the task is quite easily accomplished but I'll await
your response to my suppositions before going any further. Besides that I need some sleep.
--
Jim
-----Original Message-----
From: pete nikolic <pg.nikolic1@gmail.com>
To: James E Lang <jim+lou@lang.hm>
Sent: Fri, 24 Apr 2015 23:43
Subject: Re: [libreoffice-users] selecting cells in calc sheet
On Fri, 24 Apr 2015 20:36:10 -0700
James E Lang <jim+lou@lang.hm> wrote:
Pete,
You still leave a lot unsaid such as whether the result is in a single fixed
location, what if anything is in the even numbered rows of column C, whether any
other column can be used for identification purposes, what if anything is below
the most recent month's data, etc. You imply that there's no more than eight
months worth of data so I guess C17 ends the series.
Without some of the information vacuum filled I'm not sure what we can do for you.
Right let me see how i can put this without attaching a spreadsheet
coloums..
C1 name C3 date1 C5 date2 C7 date3 C9 date4 C11
date5
in those colums under the dates will be numbers of i would guess around the 40 to
60 region but only on or after the date ie under date 1 on row name 1 say 45 next
month it is date2 name1 say 48 then date3 name1 60, date4 name1 48 date5 name1 56
ect ect
Dates are columns rows are names there will be about 25 names 8 dates in total so
for date1 date2 both name1 there would be no result , then fill date3 name 1 i then
need to do the add date1 date2 date3 divide by .
Thats is the easy bit now when i fill date4 i need it to ignore date1 and add date
2 date3 date4 then divide when i fill date 5 i need it to ignore date1 date 2 add
date3 date4 date5 divide by 3 and carry on like that always only picking the last
3 dates ignoring any earlier .
does that help any
date1 data2 date3 date4 date5
name1 48 60 48 56
Pete
--
Illegitimi non carborundum . ro for the purists out there
Noli nothis permittere te terere.
--
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
Context
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.