Life In 19x19

Posted: **Mon Mar 10, 2014 10:25 am**

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: Select all

              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'

Posted: **Mon Mar 10, 2014 11:32 am**

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: Select all
              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: Select all

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.

Posted: **Mon Mar 10, 2014 12:38 pm**

It seems it failed, or I did something wrong ?

Posted: **Mon Mar 10, 2014 1:03 pm**

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 /

Posted: **Mon Mar 10, 2014 1:08 pm**

errr, sure ?

Posted: **Mon Mar 10, 2014 1:36 pm**

cgbspender wrote:errr, sure ?

=SOMME(C2/E2*100)%

Posted: **Mon Mar 10, 2014 1:47 pm**

hooray, worked perfect ! thanks for the help and for your patience !

Posted: **Tue Mar 11, 2014 12:36 am**

cgbspender wrote:hooray, worked perfect ! thanks for the help and for your patience !

Not a problem!

Life In 19x19

Using functions in OpenDocument (ods)

Using functions in OpenDocument (ods)

Re: Using functions in OpenDocument (ods)

Re: Using functions in OpenDocument (ods)

Re: Using functions in OpenDocument (ods)

Re: Using functions in OpenDocument (ods)

Re: Using functions in OpenDocument (ods)

Re: Using functions in OpenDocument (ods)

Re: Using functions in OpenDocument (ods)