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 correctly
We only have two rounds and we only take care of our district we do not need more groups. Ideas are appreciated.
Best Regards,
Antonio
_______________________________________________ users mailing list -- users@xxxxxxxxxxxxxxxxxxxxxxx To unsubscribe send an email to users-leave@xxxxxxxxxxxxxxxxxxxxxxx
