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
_______________________________________________ users mailing list -- users@lists.fedoraproject.org To unsubscribe send an email to users-le...@lists.fedoraproject.org
