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
Allegedly, on or about 22 March 2018, Antonio Olivares sent:
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.
Tangential approach: Use your script to create a webpage that they can view in their preferred web browser.
It is possible to put a Linux shell on a Windows PC (e.g. a port of BASH), so they could run your program. Though, unless you need other people to be able to enter data, than yourself, my first suggestion seems simpler to manage.
-
Antonio Olivares -
Tim