Life In 19x19
http://www.lifein19x19.com/

Using functions in OpenDocument (ods)
http://www.lifein19x19.com/viewtopic.php?f=8&t=9986		 Page 1 of 1
Author:  cgbspender [ Mon Mar 10, 2014 10:25 am ]
Post subject:  Using functions in OpenDocument (ods)
Hey,

Does anyone know how to use a percentage function or a sum function in OpenDocument ?

I did manage to make the sum function work... but, I could only make it work one line by one line. And I have more than 1000 entries, so I'd like something that will make the sums all at once.

For now it looks like this :
Code:
              Column A      Column B        Column C            Column D (win ratio)
              Wins          Losses          Total of games

Player A       50              150            200                      25%
Player B



I don't have a D column yet. But I'd like one. How can I do it, so that it creates all the winratio for all players from player A to player Z, without having to re-write the same function again and again.
(and how to do with the "sum" function, in column C ?)

Thanks for the help.
edit : keep in mind, I'm really terrible at whatever uses numbers, let alone functions.. :)
Cgb'
Author:  LocoRon [ Mon Mar 10, 2014 11:32 am ]
Post subject:  Re: Using functions in OpenDocument (ods)
cgbspender wrote:
Hey,

Does anyone know how to use a percentage function or a sum function in OpenDocument ?

I did manage to make the sum function work... but, I could only make it work one line by one line. And I have more than 1000 entries, so I'd like something that will make the sums all at once.

For now it looks like this :
Code:
              Column A      Column B        Column C            Column D (win ratio)
              Wins          Losses          Total of games

Player A       50              150            200                      25%
Player B



I don't have a D column yet. But I'd like one. How can I do it, so that it creates all the winratio for all players from player A to player Z, without having to re-write the same function again and again.
(and how to do with the "sum" function, in column C ?)

Thanks for the help.
edit : keep in mind, I'm really terrible at whatever uses numbers, let alone functions.. :)
Cgb'


Ok, so first off I changed the structure a little bit to be like this:

Code:
Column A       Column B      Column C        Column D            Column E (win ratio)
Player         Wins          Losses          Total of games

Player A       50              150            =SUM(B2:C2)        =SUM(B2/D2*100)%
Player B


Now you have to manually enter the wins and losses for each player, but you can easily replicate the formulas by highlighting those two cells, holding down the left mouse button on the black square in the lower right corner, and dragging it down as far as you want to go.

I've also attached a sample sheet you can work off of, if you want.

Attachments:
File comment: Sample sheet.
Untitled 1.ods [9.88 KiB]
Downloaded 301 times
Author:  cgbspender [ Mon Mar 10, 2014 12:38 pm ]
Post subject:  Re: Using functions in OpenDocument (ods)
It seems it failed, or I did something wrong ?

Attachments:
somme.png
somme.png [ 4.76 KiB | Viewed 5218 times ]
Author:  LocoRon [ Mon Mar 10, 2014 1:03 pm ]
Post subject:  Re: Using functions in OpenDocument (ods)
cgbspender wrote:
It seems it failed, or I did something wrong ?

Change the D2 in the formula to E2.

Edit:

Also, change the ; to a /
Author:  cgbspender [ Mon Mar 10, 2014 1:08 pm ]
Post subject:  Re: Using functions in OpenDocument (ods)
errr, sure ?

Attachments:
somme.png
somme.png [ 4.79 KiB | Viewed 5214 times ]
Author:  LocoRon [ Mon Mar 10, 2014 1:36 pm ]
Post subject:  Re: Using functions in OpenDocument (ods)
cgbspender wrote:
errr, sure ?


=SOMME(C2/E2*100)%
Author:  cgbspender [ Mon Mar 10, 2014 1:47 pm ]
Post subject:  Re: Using functions in OpenDocument (ods)
hooray, worked perfect ! thanks for the help and for your patience !
Author:  LocoRon [ Tue Mar 11, 2014 12:36 am ]
Post subject:  Re: Using functions in OpenDocument (ods)
cgbspender wrote:
hooray, worked perfect ! thanks for the help and for your patience !


Not a problem! :)
Page 1 of 1 All times are UTC - 8 hours [ DST ]
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/