View TWL ROSTERS
Summary:
There was an overwhelming response in Riverside's thread expressing the desire for more transparent TWL Rosters. Because of this response, I've created a public-facing TWL Squad Roster google sheet to be self-managed by each captain. Please note the following...
The pre-season purpose of this sheet is to increase transparency to the playerbase about each squad's taken / available TWL roster spots. For the regular season, this sheet will most likely serve as the official weekly-locked TWL Rosters.
Each squad will be given the ability to edit their team's roster sheet, and the main Overview tab will auto-update based on each squad's roster management. I am not making this a mandatory task for squad captains to update between now & the end of squad qualifications, however the intention is to increase transparency for all players during the qualifying period.
When the regular season begins it will become a mandatory task to update your TWL rosters should it change week-to-week. As a reminder to all players, the Roster Hardlock will go into effect after all week 3 matches have completed.
EDIT / P.S...
If anyone knows how to do Conditional Formatting using an indirect VLOOKUP, please let me know and I can make Captains / Assistant names stick out better on the Overview page.
EDIT#2
Thanks Markmrw for the conditional formatting help... the Overview tab will now show red / yellow colors for Captains and Assistants
Summary:
There was an overwhelming response in Riverside's thread expressing the desire for more transparent TWL Rosters. Because of this response, I've created a public-facing TWL Squad Roster google sheet to be self-managed by each captain. Please note the following...
The pre-season purpose of this sheet is to increase transparency to the playerbase about each squad's taken / available TWL roster spots. For the regular season, this sheet will most likely serve as the official weekly-locked TWL Rosters.
Each squad will be given the ability to edit their team's roster sheet, and the main Overview tab will auto-update based on each squad's roster management. I am not making this a mandatory task for squad captains to update between now & the end of squad qualifications, however the intention is to increase transparency for all players during the qualifying period.
When the regular season begins it will become a mandatory task to update your TWL rosters should it change week-to-week. As a reminder to all players, the Roster Hardlock will go into effect after all week 3 matches have completed.
EDIT / P.S...
If anyone knows how to do Conditional Formatting using an indirect VLOOKUP, please let me know and I can make Captains / Assistant names stick out better on the Overview page.
EDIT#2
Thanks Markmrw for the conditional formatting help... the Overview tab will now show red / yellow colors for Captains and Assistants
Comment