Re: [libreoffice-users] Frequency Distribution

[Brian Barker]

At 14:10 07/05/2017 -0600, Jorge Rodríguez wrote:
If I have a number of data about some topic, how 
can I get the type of distribution using the 
LibreOffice's formula ? How can I know if it is 
normal, gamma, etc. ? There is a way ? For example:

 Year   Inflation of CR
19775,24971553
19788,11274841
197913,15353384
198017,78618715
198165,09133166
198281,75212345
198310,70142566
198417,34945384
198510,9251405
198615,42534076
198716,42746458
198825,33576785
19899,95444378
199027,25437251
199125,31611285
199216,96883188
19939,04288357
199419,85608235
199522,56778373
199613,88867535
199711,20231467
199812,35570391
199910,11290162
200010,24738868
200110,95604456
20029,68294967
20039,86787054
200413,12895123
200514,07496016
20069,43371564
200710,80552431
200813,90233262
20094,04704133
20105,82431576
20114,73574866
20124,55053048
20133,67954067
20145,12718527
2015-0,80758134
20160,7651911
20171,08546538


I thought I had an answer to this, but I'm afraid 
it works only if the 2000 figure ends "8878", not "8868".


Sorry.

Brian Barker  



--
To unsubscribe e-mail to: users+unsubscr...@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

Re: [libreoffice-users] COUNTIF / DAYS / ?

[Steve Edmonds]

Hi.
Is the rainfall data regular (every day) or sporadic.
If sporadic, is the amount of rainfall cumulative since the previous date.

I also take it that you want 2 outputs. The total amount of rainfall 
over the desired period and the number of data points on which rainfall 
was recorded over that period.


Steve

On 08/05/17 07:55, Hylton Conacher (ZR1HPC) wrote:

Hi,

I have a spreadsheet I use to draw graphs and extract information 
about the rainfall in my area for the last two years.


I need to create a formula that will count how many days it rained 
between the start of the year, both last year and this year, so I can 
compare the amount of rainfall that was received during that time frame.


The example below is a sample dataset that shows how much rainfall was 
received in 2016 or 2017, on each of the four days


Example:
MonthDay20162017
Jan1015
Feb2910
May601
Sept22155

From this we can determine that 16mm of rain fell in 2016 over 2 days. 
Likewise we can determine that 21mm of rain fell in 2017 but over 3 days.


Today is the 7th of May 2017 and I would like a formula to work out 
how many days the rainfall received between(and incl) 2016/01/01 and 
the day before TODAY last year. The answer for 2016 is 1 i.e. it only 
rained once between the dates specified, however the answer for 2017 
is 16 as it rained twice between TODAY-1 and 2017/1/1. I had thought 
of using COUNTIF or DAYS or =COUNTIF(C2:SUM(TODAY()-1,">0")), however 
the problem is that I do not have a single date column, but three.


This formula will allow me to create a graph showing how much rainfall 
had fallen last year compared to this year between the beginning of 
the year(01/01) and the day prior to Today.


I had thought of converting the first two columns into a single and 
having the text name of the month with each successive line being a 
new date in that month until the month changed, however I was unable 
to get it to work i.e. automatically change month after 31 days in 
January to read February 01.
As you can imagine I have 367 rows of data per year, mostly with 0 as 
a value, however there are odd days it does rain.


Any comments, and if you want the original spreadsheet, just yell 
where to put it i.e. Nabble etc.


Regards
Hylton




--
To unsubscribe e-mail to: users+unsubscr...@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

Re: [libreoffice-users] COUNTIF / DAYS / ?

[Remy Gauthier]

Hi,

If you have one row per day of the year, you can find out easily where
the row corresponding to "TODAY()-1" is located by finding out the
number of days between Jan 1st of that year and "yesterday". This would
be something like (you may need to adjust based on the heading of your
column(s)):

=DAYS(YEAR(TODAY()-1)-1;MONTH(TODAY()-1);DAY(TODAY()-1);YEAR(TODAY()-
1)-1;1;1)

The formula above calculates the number of days between yesterday last
year and Jan 1st of last year. Now, you need to find in which column to
add. Since you seem to have a heading providing the year, you can use
the MATCH() function to locate the column:

=MATCH(YEAR(TODAY()-1)-1;$a$1:$z$1;0)

This should give you the column where last year's data is located (I
used a1 to z1, but any row reference will work).

To add the values, you now just need to use a combination of SUM() and
OFFSET():

=SUM(OFFSET($A$2;0;MATCH(YEAR(TODAY()-1)-1;$a$1:$z$1;0)-
1;DAYS(YEAR(TODAY()-1)-1;MONTH(TODAY()-1);DAY(TODAY()-1);YEAR(TODAY()-
1)-1;1;1);1))

What that does:

OFFSET() allows you to create dynamic arrays for functions like SUM().
I used the anchor point $A$2 (I supposed your heading is in row 1), and
told OFFSET to move from that reference 0 rows down and
"MATCH(YEAR(TODAY()-1)-1;$a$1:$z$1;0)-1" columns to the right; then,
from that new point, make an array that is "DAYS(YEAR(TODAY()-1)-
1;MONTH(TODAY()-1);DAY(TODAY()-1);YEAR(TODAY()-1)-1;1;1)" rows high and
1 column wide. The resulting array is then used by SUM() to calculate
the total rainfall.

This will probably need to be adjusted a bit to take into account the
position of your column heading and to correctly find the row where to
stop, but you should now have something to play with.

I hope this helps.

Rémy Gauthier.


Le dimanche 07 mai 2017 à 21:55 +0200, Hylton Conacher (ZR1HPC) a
écrit :
> Hi,
> 
> > I have a spreadsheet I use to draw graphs and extract information
about 
> the rainfall in my area for the last two years.
> 
> I need to create a formula that will count how many days it rained 
> > between the start of the year, both last year and this year, so I
can 
> > compare the amount of rainfall that was received during that time
frame.
> 
> > The example below is a sample dataset that shows how much rainfall
was 
> received in 2016 or 2017, on each of the four days
> 
> Example:
> > > > Month   Day 20162017
> > > > Jan 1   0   15
> > > > Feb 29  1   0   
> > > > May 6   0   1
> > > > Sept22  15  5
> 
> >  From this we can determine that 16mm of rain fell in 2016 over 2
days. 
> > Likewise we can determine that 21mm of rain fell in 2017 but over 3
days.
> 
> > Today is the 7th of May 2017 and I would like a formula to work out
how 
> > many days the rainfall received between(and incl) 2016/01/01 and the
day 
> before TODAY last year. The answer for 2016 is 1 i.e. it only rained 
> > once between the dates specified, however the answer for 2017 is 16
as 
> it rained twice between TODAY-1 and 2017/1/1. I had thought of using 
> > COUNTIF or DAYS or =COUNTIF(C2:SUM(TODAY()-1,">0")), however the
problem 
> is that I do not have a single date column, but three.
> 
> > This formula will allow me to create a graph showing how much
rainfall 
> > had fallen last year compared to this year between the beginning of
the 
> year(01/01) and the day prior to Today.
> 
> I had thought of converting the first two columns into a single and 
> > having the text name of the month with each successive line being a
new 
> > date in that month until the month changed, however I was unable to
get 
> > it to work i.e. automatically change month after 31 days in January
to 
> read February 01.
> > As you can imagine I have 367 rows of data per year, mostly with 0 as
a 
> value, however there are odd days it does rain.
> 
> > Any comments, and if you want the original spreadsheet, just yell
where 
> to put it i.e. Nabble etc.
> 
> Regards
> Hylton
> 

-- 
To unsubscribe e-mail to: users+unsubscr...@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

[libreoffice-users] Frecuency Distribution

[jorge]

Hi all:

Would you please help me with this ?

If I have a number of data about some topic, how can I get the type of
distribution using the LibreOffice's formula ? How can I know if it is
normal, gamma, etc. ? There is a way ?

For example:

YearInflation of CR
19775,24971553
19788,11274841
197913,15353384
198017,78618715
198165,09133166
198281,75212345
198310,70142566
198417,34945384
198510,9251405
198615,42534076
198716,42746458
198825,33576785
19899,95444378
199027,25437251
199125,31611285
199216,96883188
19939,04288357
199419,85608235
199522,56778373
199613,88867535
199711,20231467
199812,35570391
199910,11290162
200010,24738868
200110,95604456
20029,68294967
20039,86787054
200413,12895123
200514,07496016
20069,43371564
200710,80552431
200813,90233262
20094,04704133
20105,82431576
20114,73574866
20124,55053048
20133,67954067
20145,12718527
2015-0,80758134
20160,7651911
20171,08546538

Thanks and regards,


-- 
Atentamente,

Jorge Rodríguez


-- 
To unsubscribe e-mail to: users+unsubscr...@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

[libreoffice-users] COUNTIF / DAYS / ?

[Hylton Conacher (ZR1HPC)]

Hi,

I have a spreadsheet I use to draw graphs and extract information about 
the rainfall in my area for the last two years.


I need to create a formula that will count how many days it rained 
between the start of the year, both last year and this year, so I can 
compare the amount of rainfall that was received during that time frame.


The example below is a sample dataset that shows how much rainfall was 
received in 2016 or 2017, on each of the four days


Example:
Month   Day 20162017
Jan 1   0   15
Feb 29  1   0   
May 6   0   1
Sept22  15  5

From this we can determine that 16mm of rain fell in 2016 over 2 days. 
Likewise we can determine that 21mm of rain fell in 2017 but over 3 days.


Today is the 7th of May 2017 and I would like a formula to work out how 
many days the rainfall received between(and incl) 2016/01/01 and the day 
before TODAY last year. The answer for 2016 is 1 i.e. it only rained 
once between the dates specified, however the answer for 2017 is 16 as 
it rained twice between TODAY-1 and 2017/1/1. I had thought of using 
COUNTIF or DAYS or =COUNTIF(C2:SUM(TODAY()-1,">0")), however the problem 
is that I do not have a single date column, but three.


This formula will allow me to create a graph showing how much rainfall 
had fallen last year compared to this year between the beginning of the 
year(01/01) and the day prior to Today.


I had thought of converting the first two columns into a single and 
having the text name of the month with each successive line being a new 
date in that month until the month changed, however I was unable to get 
it to work i.e. automatically change month after 31 days in January to 
read February 01.
As you can imagine I have 367 rows of data per year, mostly with 0 as a 
value, however there are odd days it does rain.


Any comments, and if you want the original spreadsheet, just yell where 
to put it i.e. Nabble etc.


Regards
Hylton

--
To unsubscribe e-mail to: users+unsubscr...@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

Re: [libreoffice-users] Re: Libre Writer - special characters

[Dave]

On 07.05.2017 20:59, V Stuart Foote wrote:
> Dave-3 wrote
>> That's interesting. If I try every possible combination of this method
>> with Writer under Win 7, all I get is a lower case x. It this something
>> peculiar to Linux or OSX?
> 
> Added for the 5.1.0 release. It works with all OS, see  tdf#73691
>   , with some
> adjustments for locale.
> 
> Just verified the +x  functions  as intended on Windows 7 sp1  (a Right
> Alt key, will end up as AltGr on some keyboard mappings for some locals, but
> the l-Alt should always work).
> 
> Try with a reset user profile.

Hi Stuart,

Win 7 Ult SP1 - Fully updated.
LO Version: 5.3.2.2 (x64)
Build ID: 6cd4f1ef626f15116896b1d8e1398b56da0d0ee1
CPU Threads: 8; OS Version: Windows 6.1; UI Render: default; Layout
Engine: new;
Locale: en-AU (en_AU); Calc: group
Logitech K320/550 keyboard. No special mappings.


New user profile. Same lower case x result with Right Alt + x

However, for both original and new profiles _LEFT_ Alt + x works.

In other software Right Alt works as expected. Go figure?

Thanks anyway,
Dave
-- 
Please address any reply to the mailing list only. Any messages sent to
this noreply@ address are automatically deleted from the server and will
never be read.

-- 
To unsubscribe e-mail to: users+unsubscr...@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

[libreoffice-users] Re: Libre Writer - special characters

[V Stuart Foote]

Dave-3 wrote
> That's interesting. If I try every possible combination of this method
> with Writer under Win 7, all I get is a lower case x. It this something
> peculiar to Linux or OSX?

Added for the 5.1.0 release. It works with all OS, see  tdf#73691
  , with some
adjustments for locale.

Just verified the +x  functions  as intended on Windows 7 sp1  (a Right
Alt key, will end up as AltGr on some keyboard mappings for some locals, but
the l-Alt should always work).

Try with a reset user profile.



--
View this message in context: 
http://nabble.documentfoundation.org/Libre-Writer-special-characters-tp4213971p4214033.html
Sent from the Users mailing list archive at Nabble.com.

-- 
To unsubscribe e-mail to: users+unsubscr...@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

Re: [libreoffice-users] Re: Libre Writer - special characters

[Dave]

On 07.05.2017 20:01, Philip Jackson wrote:
> On 06/05/17 23:17, V Stuart Foote wrote:
>> Input the character via its Unicode value, and toggle.
>>
>> So, here enter "U+211e" and then use +X to toggle.
> Thank you Stuart for the key to the toggle.  I've wondered how to enter
> unicode characters for a long time. And have tried all the ctrl-shift +U
> stuff suggested so often but with absolutely no success.
>
> Yours is the first time I've seen mention of +X and it works
> for me a treat.  I don't even have to enter the U+ part of the unicode.
> It works with just 211e +X.

That's interesting. If I try every possible combination of this method
with Writer under Win 7, all I get is a lower case x. It this something
peculiar to Linux or OSX?

Dave
-- 
Please address any reply to the mailing list only. Any messages sent to
this noreply@ address are automatically deleted from the server and will
never be read.

-- 
To unsubscribe e-mail to: users+unsubscr...@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

Re: [libreoffice-users] Re: Libre Writer - special characters

[Philip Jackson]

On 06/05/17 23:17, V Stuart Foote wrote:
> Input the character via its Unicode value, and toggle.
> 
> So, here enter "U+211e" and then use +X to toggle.

Thank you Stuart for the key to the toggle.  I've wondered how to enter
unicode characters for a long time. And have tried all the ctrl-shift +U
stuff suggested so often but with absolutely no success.

Yours is the first time I've seen mention of +X and it works
for me a treat.  I don't even have to enter the U+ part of the unicode.
It works with just 211e +X.

-- 


-- 
To unsubscribe e-mail to: users+unsubscr...@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

Re: [libreoffice-users] LO base reference?

[Robert Großkopf]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hi Dave,
> 
> I'm involved in a project that will produce a dataset as its
> product. I'm considering using LO base so as to avoid vendor
> lock-in. I've found a base document from 2014 that seems promising,
> is there a more up-to-date place to start reading?

You could get the Base-Handbook here:
http://www.libreoffice.org/get-help/documentation/

... but it is only the first version. Translation of newer versions
seems to be a little problem ...

The German version from 2007 you could get here:
http://de.libreoffice.org/get-help/documentation/

I have written most of the content. So feel free to ask me. You could
also contact me directly.

Regards

Robert
- -- 
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3
-BEGIN PGP SIGNATURE-
Version: GnuPG v2

iQIcBAEBAgAGBQJZDs/2AAoJELDKYwaoS9AIFsQP+wdxyhAJTk7A+7Uk7ldU+Tx9
Us9SLOKSe2Jy1hE6sVhbo4QH+olW3lRIuiYOZuqD5AksINRCZLqSFEMnjGeTXgmN
Gd145qK2UttTXxB9AxgDDJsRy582/Z2rXHuEl7yBvUk3mhZ4LY0MjOBVgczAKlx3
m+T2ZNiWB2Sn0zwqa9nI91oVW+OMF5XrzuaQD31tyQi8kofgqQzmDUSJNQYit88X
xqVw+s16FLH9aZ0YI94oFPmT9CWOuXmbrqKMm8IXwfmQPVrcP8++hYw3nFrlVpIM
buOZRdsl5cqdvB12JGuESxk8zNnKFWAdWxDcHwkHUw5IA01NXLLjmXiSQe/jSnIt
jCKyYaFyO0cIRvVzX6D9U5tVZ4jmH6MoM4FxSNWL1FrODlY5HkHqrTiFHgmE35Hh
WCGGcsk74usy5wXXa4jkymZGwVVIUA0rHvdamRzqlC/NwIFq6g6EfRTvmcsLPVXG
nUkqFep8E8EKXZM93CxWMprdZBDJQPjHDr4rr9HkAe8lo0Zg1x/zBViLicwIy4x+
0O5nJlw3CSWCJLX0dNaunkr3oDqnLjBrCaw3gVuvob+oOzwh7gkARSJTieIRQMe4
9c3H5ZjW+ydQK2lzOc9GoSqx8nbQC0jLUws2A0gBqzH+Y2QywfS0OfESXoolWZ1w
4b63lkHB1Hfg3aysULXu
=C1Mx
-END PGP SIGNATURE-

-- 
To unsubscribe e-mail to: users+unsubscr...@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