http://excel-example.com/templates/sport-tournament-template
Dear fellow fedora users,
I have a script that uses awk to generate reports for our soccer team. This script was
corrected by Jon LaBadie a very helpful person. Unfortunately my colleagues do not have
linux on their machines and they would like a spreadsheet to do the same so they can keep
track of the season and to check how many PTS/GF/GA/DIF they have as a team. I created
one, but they do not understand it, uses decimals and integer part, and they get
confused. I am modifying the spreadsheet a bit to more as to what they want.
However, I do not understand how to use countif/vlookup/hlookup to look for how many PTS
they have, GF and GA so they can be tallied like SUMIF? command. If anyone is willing to
help I can send you spreadsheet. Last email I tried bounced because it had HTML and was
big :(
for example
PTS TG REG OT PKS : PKS OT REG TG PTS
3 TEAM1 2 1 1 0 2:1 0 0 1 1 TEAM3
0
there are 10 games for each team and the team earns 3 PTS for a win in REGULATION, 2 PTS
for a win in OT or PKS, 1 PT for a loss in OT/PKS and 0 PTS for a loss in REGULATION.
The PTS are tallied, the TG are the total goals: REG + OT as the PKS do not count in this
area, they only determine who gets the 2 PTS.
the spreadsheet should tally the information
TEAM GP 3-PTS 2-PTS 1-PT 0-PTS GF GA DIF PTS
TEAM1 5 2 2 1 0 5 3 +2 11
There are some online examples, but they only contain W-win L-loss D-draw. We do not have
draws as the game has to be decided and we play OT and/or shoot PKS if the game is still
tied.
The examples are here:
Sport tournament template in the site above, i cannot copy+paste correctlyWe only have two
rounds and we only take care of our district we do not need more groups. Ideas are
appreciated.
Best Regards,
Antonio