The new forums will be named Coin Return (based on the most recent vote)! You can check on the status and timeline of the transition to the new forums here.
The Guiding Principles and New Rules document is now in effect.
games results recording.... is a spreadsheet the only way?
Conroy Bumpas
Registered User regular
Registered User regular
i have posted something like this before, but this is slightly diffrent
basicly i want to record the results of of a few players that are playing pub games to see who has most wins over a space of time (likly to be a year). all the torny and stat tracking apps ive found eather arnt compatable with diffrent games or diffrent amounts of time.
what i need is something lake a spredsheet that i can add the results every time we play. E.G
so
15/1/13 player 1 player 2 .
darts 18 21 .
pool 0 3 .
foosball 3 0 .
20/1/15 player 1 player 2
darts 10 15 .
pool 1 2 .
foosball 3 0 .
total darts 28 36
total pool 1 5
total foos 6 0
days won 0 2
and i want it to total up total wins for each game for the year and who won indevidual days etc
i tryed doing something in a spreadsheet but it means i have to copy the little table above and then add all those boxes to the formula ever time we play to get a total.
anyone got any idear to make this simpler
basicly i want to record the results of of a few players that are playing pub games to see who has most wins over a space of time (likly to be a year). all the torny and stat tracking apps ive found eather arnt compatable with diffrent games or diffrent amounts of time.
what i need is something lake a spredsheet that i can add the results every time we play. E.G
so
15/1/13 player 1 player 2 .
darts 18 21 .
pool 0 3 .
foosball 3 0 .
20/1/15 player 1 player 2
darts 10 15 .
pool 1 2 .
foosball 3 0 .
total darts 28 36
total pool 1 5
total foos 6 0
days won 0 2
and i want it to total up total wins for each game for the year and who won indevidual days etc
i tryed doing something in a spreadsheet but it means i have to copy the little table above and then add all those boxes to the formula ever time we play to get a total.
anyone got any idear to make this simpler
Please note I cannot be held responsible for any mental, physical, emotional, spiritual, karma, dharma, metaphysical, religious, philosophical, Logical , Ethical, Aesthetical, or financial damage caused by this post
Conroy Bumpas on
0
Posts
player-a darts pool foos
date-a 18 0 0
date-b 28 1 6
Do this for each player, maybe on a different sheet if you want. Then on your main sheet you can total it up.
Players darts pool foos
player-a =sum('players'!b2:b20) =sum('players'!c2:c20) =sum('players'!d2:d20)
You can begin a formula and then switch sheets to select what to input. The formulas I've shown would be done by entering =sum( then switching to the "players" sheet and selecting your cells which would be the columns for each game type. I can throw something together really quick if you aren't sure what I mean.
Took about 5 minutes to do. Change the cell range on the first sheet to cover the columns on the second sheet. It will auto-total the daily wins based on the COUNTIF formula that counts the number of Ws that are entered automatically by the IF formula on the second sheet.