So here's what we have so far:
Let's have an official start on Monday, and an unofficial start on Friday ... I suppose we'll take late comers until the end of the first round as per usual. We'll do the double blind on Thursday evening.
Downloads:
VD6 OFFICIAL SPREADSHEET
Upgrades from VD5:
The matrix now displays and individual breakdown alongside each team. This will tell you how many competitors still need letter/decade combos without having to scroll up to the main matrix.
Updated Career & Best Year Hitter Stats Sheet
I have added 2 new sheets with formatted Career and Best Year stats side by side. This should make your ranking and sorting much much easier. All the stats are there on the Combined Sheets ... the less important stats are in hidden columns. You can see where the hidden columns are by looking at the missing letters along the top Row.
Tips and Using the Filter Column Arrows:
1. Use this Career & Best Year Stat Sheet for your rankings and sorting. That will mean when there is a Scoring Spreadsheet update, you will be able to use the latest version without losing your ranking info.
2. It's better to use the drop down filter arrows on the columns for sorting, rather than using custom sorts (especially on slower machines). It will be much faster if you use the "letter" and/or "number" filters rather than re-sorting the whole sheets every time you want to check a different parameter.
3. Make use of the "Text Filter" / "Number Filter" > "Contains" feature to filter the Position and Decade columns. It's the fastest and less resource heavy option.
4. Use the "Text Filter" > "Begins With" feature to filter by letter.
5. You can combine filters i.e. Text Filter the Last Name column --> Begins With "S". Then Text Filter the Position column --> Contains "2B" ... this will filter only S's and 2B. You undo these filters by clicking the column arrows again and selecting "Clear Filter From ____"
Format:
Letters and Decades (as VD5)
2 Wildcard Letters Added, with 1 extra OF and P slot added from VD5
4 KO's added - use of KO's are optional, and must be used between rounds 6 and 13. No players starting with QUIZ ENVY can be KO'd.
Multiplicative scoring will be used
Changes from VD5:
2 Wildcards (25 players to be drafted in total)
14 of the 15 eligible hitting decades must be selected
11 of the 14 eligible pitching decades must be selected
1 extra OF slot added
1 extra Pitching slot added
4 KO's (no QUIZ ENVY players can be KO'd)
Scoring change:
As a trial, we have eliminated the 1 point from scoring system. Finishing last in any category will result a team scoring 2 points. Finishing second-last will result in 3 points etc etc.
Draft Order:
1 ElDiablo
2 Revo
3 Heyelander
4 Frae
5 Pogues
6 Controller Jacobs
7 Feral Slasher
8 Johnny
9 Knuckleballs
10 Hacko
11 Garp
Let's have an official start on Monday, and an unofficial start on Friday ... I suppose we'll take late comers until the end of the first round as per usual. We'll do the double blind on Thursday evening.
Downloads:
VD6 OFFICIAL SPREADSHEET
Upgrades from VD5:
The matrix now displays and individual breakdown alongside each team. This will tell you how many competitors still need letter/decade combos without having to scroll up to the main matrix.
Updated Career & Best Year Hitter Stats Sheet
I have added 2 new sheets with formatted Career and Best Year stats side by side. This should make your ranking and sorting much much easier. All the stats are there on the Combined Sheets ... the less important stats are in hidden columns. You can see where the hidden columns are by looking at the missing letters along the top Row.
Tips and Using the Filter Column Arrows:
1. Use this Career & Best Year Stat Sheet for your rankings and sorting. That will mean when there is a Scoring Spreadsheet update, you will be able to use the latest version without losing your ranking info.
2. It's better to use the drop down filter arrows on the columns for sorting, rather than using custom sorts (especially on slower machines). It will be much faster if you use the "letter" and/or "number" filters rather than re-sorting the whole sheets every time you want to check a different parameter.
3. Make use of the "Text Filter" / "Number Filter" > "Contains" feature to filter the Position and Decade columns. It's the fastest and less resource heavy option.
4. Use the "Text Filter" > "Begins With" feature to filter by letter.
5. You can combine filters i.e. Text Filter the Last Name column --> Begins With "S". Then Text Filter the Position column --> Contains "2B" ... this will filter only S's and 2B. You undo these filters by clicking the column arrows again and selecting "Clear Filter From ____"
Format:
Letters and Decades (as VD5)
2 Wildcard Letters Added, with 1 extra OF and P slot added from VD5
4 KO's added - use of KO's are optional, and must be used between rounds 6 and 13. No players starting with QUIZ ENVY can be KO'd.
Multiplicative scoring will be used
Changes from VD5:
2 Wildcards (25 players to be drafted in total)
14 of the 15 eligible hitting decades must be selected
11 of the 14 eligible pitching decades must be selected
1 extra OF slot added
1 extra Pitching slot added
4 KO's (no QUIZ ENVY players can be KO'd)
Scoring change:
As a trial, we have eliminated the 1 point from scoring system. Finishing last in any category will result a team scoring 2 points. Finishing second-last will result in 3 points etc etc.
Draft Order:
1 ElDiablo
2 Revo
3 Heyelander
4 Frae
5 Pogues
6 Controller Jacobs
7 Feral Slasher
8 Johnny
9 Knuckleballs
10 Hacko
11 Garp
Comment