In order to help make the league more competitive and help some of the stragglers, as well as make the draft run more quickly the Emperor is freely donating a statistical advantage to the group of coaches. He has trained Logistix who is now passing this on.
This year, in the HFFL 2023 Drafts spreadsheet you will find a new spreadsheet called “2022 Stats – Undrafted”.
This will show you live in real-time as the draft proceeds which players in the Stats sheet remain Undrafted so you can select them. This will make it very quick to find for example “the next best marker available”.
Note this will only work on desktops/laptops as the special filtering explained below you need to do to rank the stats by positions is not available on the smartphone version of googlesheets.
If you wish to use this sheet you must follow this rule – you are not allowed to sort or filter the sheet in any way that affects how other coaches view the sheet. I have full live audit view on the sheet so I can see if anyone breaches this rule – if you do, you will be banned from using the sheet for 1 year (i.e. I will remove your access live during the draft).
What this practically means is, do not use the following functions:
- Data – Create a Filter
- Data – Sort Sheet (or Range).
Instead there is a clever function that will let you alone filter the sheet how you want but won’t affect how any other people see the sheet. As mentioned above, this function only works on desktops/laptops. From the top menu do this:
- Data – Filter Views – “Rank by Stats”
- This puts the arrow button filters at the top of each column but only does it for your unique view, no one else’s
- Then choose the relevant stats category (e.g Ma for marker) and click on the arrow at the top and “Sort Z-A” to rank from highest to lowest.
Now that this is explained, the key point is that you choose Data-Filter Views and don’t choose “Data-Create a Filter”. I’m labouring this point as they are easily confused and right next to each other. The former only changes your view of the sheet, the latter changes everyone’s view.
I have also placed the above instructions about how to choose the Filter view in as a note in the little green cell (A1) on the sheet.
Now some of the more advanced spreadsheet users will prefer to create their own stats spreadsheet rather than use this one. If you are such a person, instead of using the above there is a special trick to be able to have a live data feed of the players who are drafted come into your own googlesheet of stats (not excel, only google. With that occurring, you can easily have those players removed from your stats list so you know who the best available players are.
Whoopah!!