Skip to main content

Dorkinians Stats

Back to Documentation Intro Contents

Dorkinians Logo

Table of Contents

To Do List

Thursday

Saturday

  • Add results from the Dorkinians group chat or results from the FA Site to the sheet so that when captains add stats, they have the right number of goals to allocate (can also be Sunday)

Sunday/Monday

  • Chase the captains to complete their stats and fix any problems they have
  • ⁠Once all captains have done their stats, load the website, screenshot TOTW and post

Monthly

  • Post the Fantasy Player of the Month - by screenshotting the player below the TOTW

Back to top

All sheets can only be opened by people with added access

Main Stats Sheets

There is no need to view the second link - Online Stats, unless something has gone really wrong

Back to top

Team Stats Sheets

Back to top

Details

Sheets to maintain

There are only a few sheets that should ever need to be maintained, listed below.

Google SheetSheet NameMaintenance Needed
Dorkinians Stats 2016-25Control PanelRead regularly to check stat completion
Dorkinians Stats 2016-25Fixtures ListUpdate weekly with fixtures and results
Dorkinians Stats 2016-25Players ListUpdate infrequently when a new player is to be added
Dorkinians Stats 2016-25LookupUpdate infrequently when a new opposition team is to be added

All other documents and sheets should work without needing updates, or will need Luke's help to fix.

Control Panel

The control panel can be used to monitor that status of each team's stats. If there are any errors on a teams sheet, they will be flagged here.

Each column provides a specific error type to help debug where to look.

Stats Control Panel

Stats Abbreviations

Each team stat sheet has this detail on the first tab of their document
AbbreviationFull NameExplanation
MINAppearance MinutesThe number of minutes that the player played. Go up to 120 minutes if extra time played.
CLASSPosition ClassThe position that the player played the majority of the game in. Can either be "GK", "DEF", "MID" or "FWD". Up to the captains to decide what position they feel their players played in.
MOMMan of the MatchThe player who won man of the match. You are allowed more than 1 if required but we prefer 1.
GGoalsThe number of goals scored by the player. Please don't include penalties in this as there is a separate stat for that.
AAssistsThe number of assists that the player achieved.
YYellowsThe number of yellow cards that a player can get. Can only be 1 or 0. If two yellows, please select 0 and add 1 red. Sin bins count as yellows.
RRedsThe number of red cards that a player can get. Can only be 1 or 0.
SAVESSavesThe number of clear big saves by the keeper. Please add for memorable big saves in the game.
OGOwn GoalsThe number of own goals scored by the player.
PSCPenalties ScoredThe number of penalties scored by the player.
PMPenalties MissedThe number of penalties missed by the player.
PCOPenalties ConcededThe number of penalties conceded by the player.
PSVPenalties SavedThe number of penalties saved by the player.
OPPO OGOpposition Own GoalsFor opposition own goals, please contact Luke Bangs or Oli Goddard to have them logged correctly.

Back to top

How the stats site works

The stats are created from several interconnected Google Sheet files, where captains enter data and then the data is collated up into a single readable file, before being read into a machine readable file.

The website then reads in this data every time it loads, which is why the loading is so slow and you can see it loading section by section, as it loads in different required data tables.

Stats Sheets and Website Explained

Debugging Stats Problems

The first place to start with debugging the errors is to review the Control Panel as this is designed to catch as many errors as possible. If this doesn't help, read the next steps below.

Common Problems

Common problems that I've encountered are;

  • Captains accidentally adding columns to their stats sheet. Check other teams sheets to see if the layout and order of columns has changed. Delete any accidentally added columns
  • Captains assigning one player in the team to the wrong match. If one player is assigned to the wrong match, its likely the match will show the wrong number of goals scored etc so check over their players and matches
  • The opposition scored an OG so our stats flag an incorrect number of goals. To fix this, you can added that an opposition scored an OG on the Fixtures List on Dorkinians Stats 2016-25

Stat Errors

The below section explains what each error means. These errors will be displayed on each line of the Captain's documents.

Each team stat sheet has this detail on the first tab of their document
ErrorExplanation
BLANK ERRORA blank error means that one of the key bits of information for a player is missing (either name, date - match, APP or CLASS). Add the missing detail to clear the error.
NAME ERRORA name error means that the entered player name doesn't exist in the Dorkinians list of players. Try alternative names/spellings if you think this player should exist. If you think this is a new player, please contact your Stats Master to add the name.
MOM ERRORAn MoM error means that the current match doesn't have a MoM assigned to it. We prefer to have one. If you definitely don't have one, you can overrule the flagged error on the Games Checker tab.
GOALS ERRORA goals error means that the number of goals listed as being scored by the Dorkinians team on the Games Checker tab doesn't align with the number of goals awarded on the stats. Check the number of goals are correct. If the Games Checker tab is an incorrect scoreline, contact your stats master. If one of the goals Dorkinians scored was an opposition own goal, record that on the Games Checker tab.
DUPLICATE NAME ERRORA duplicate name error means that you have the same player listed twice against a fixture. Check this. If there is definitely not a mistake, you can overrule the flagged error on the Games Checker tab.

If after all, you're sure that the stats are right on a sheet, either for a line on one of the year tabs, or for a full match on the Games Checker tab, you can change the Overrule Checker to be "Mark As Ok". This will clear the errors but should be used as a last resort

Website Errors

If the website isn't loading for any reason, another check that can be done is to right click on the website (on a computer) and click "Inspect". Each browser has a "Debug Console" (or something named similar) that can viewed.

As the website loads, I log some statements such as "getPlayerStats" etc. which give some indication of what is happening on the site.

If there is an error, have a look at what the site was trying to do before it failed, as this may give some indication of what went wrong.

Debug Console

Back to top

Adding a Player

To add a player to the Dorkinians database, do the following steps;

  • Navigate to the Players List tab on the main stats sheet
  • Scroll to where to add the player (alphabetical is preferred for long term maintenance) and right click on the row numbers to add a row above or below the current row
  • Add the players name
  • Add a TRUE or FALSE value for if they should be shown on the website (can say false to hide players who don't want to be shown)
  • Optionally you can add a team (historically I've added the first team the player played for)
  • Add a Class
  • You can ignore the remaining details - we no longer use them
Stats Players List

Back to top

Adding an Opposition Team

Sometimes one of our teams will play a new team that isn't listed on the sheet. To add a team, do the following;

  • Navigate to the Lookup tab on the main stats sheet
  • In column H, add the new team name in alphabetical order
  • Find out their playing field address and add to column J
  • Use Google Maps to lookup the distance in miles from the opposition ground to Pixham Sports Ground - and use the lowest distance in miles by car x 2 for each way

This is how I calculate distance travelled for players

 Stats Teams List

Back to top

Back to top