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 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