Spreadsheet - League

Name and location

Located as first sheet in the main spreadsheet. This sheet is where a lot of the summarising is done. There is an onOpen macro that sorts some of these tables and this means that it sometimes opens slowly.

​

Tables in this sheet include:

• Leader Table -  It is autoSorted by onOpen macro. This is the main record of the standings at the end of each week. It is what I paste into the WhatsApp group when results are in. The Highest and lowest scores are highlighted.

• Weeks at top Summary Table - top right of the sheet. Sorted by # of weeks with highest score.

• Team Points Contribution - this table is autoSorted by highest total contributor it tries to show what team has benefitted players by giving up points.

• Case analysis Table - list of all 10 cases and their frequency by week and total

• Case Frequency Charts

• Goals Per week Chart

• Wins Lose Draw Predictions Tables - these can reveal interesting patters so for example who has never predicted a certain team to win.

• Weeks at the top Table - this is needed to feed the Weeks at the Top Summary table mentioned earlier.

• Finally there is a Detailed case by player analysis table used in the earlier summary of cases table.