Dear kind folks,
I asked for a little bit of help regarding a spreadsheet sports template. We have a
different system than the regular 3 points for a win, 1 point for a draw and 0 points for
a loss. In our system we have 3 points for a win(in regulation), 2 points for a win(in
OT/PKS-penalty kick shootout), 1 point for a loss(in OT/PKS), and 0 for a loss in
regulation. There is a website that has some nice templates to use and all we need is to
cut the competition to two rounds only as we play round-robin and we need to modify the
existing templates to figure this out for us.
In the comments section, the question has been asked in the comments section but no
replies to that question. Usually the scores are entered as
Use 1- first half 2- second half OT1 overtime 1st period, OT2- 2nd Overtime period and
Team1 1-0 2-0 OT1-0 OT2-0 PKS-3
Team2 1-0 2-0 OT1-0 OT2-0 PKS-2
so Team1 wins 1 to 0 in PKS there are 0 goals added to the GF and 0 goals added to GA and
earns 2 points
Team2 looses 1 to 0 in PKS and gets 0 goals in favor and 0 goals against and earns 1 point
This should happen for all the games to be played. We were in a 6 team district and now
we will be moved to an 8 team district.
We can open the spreadsheet with LibreOffice and keep using xlsx and/or convert it to
Thanks for any help/advice/suggestions.