01-31-2024, 12:40 PM
(This post was last modified: 02-05-2024, 10:43 AM by lemonoppy. Edited 6 times in total.)
Introducing the Lemon Draft Boards! Mostly just giving teams options to use these if they want, or to introduce some tooling that may be helpful for people wanting to do some mocks. I made these generally out of cool features from the Minny and AZ draft boards that I’d been using, and creating some new features to help.
What it does:
1. First off, it pulls data from the TPE Tracker endpoint directly instead of pulling from the Google Sheets sheet that pulls from the tracker. This improves reliability, no more sheet going down because you’re waiting for data to load. (It might go down but like, it's Sheets, only so much I can do)
1b. Sometimes sheets will still go down since Google does some background stuff, what you do to fix is go to the `Tracker JSON` sheet, copy the cell's value in A1, delete it and then paste it back in
2. Draft sheet that you can use to track the draft which smartly crosses off prospects from the list if they’ve been taken. You just need to select the player in the dropdown.
3. “Big Board” - This isn’t a true big board, I don’t think, but it’s close to it for a spreadsheet. This sorts all prospects by position, the number grade you give them, and then by TPE. It also pulls data from the Draft sheet to cross em out if they’ve been taken.
4. Automated with an Overview page! Well, I say automated, but basically if you put in the season you’re scouting for, it just changes the season you’re pulling prospects from.
Feel free to copy these sheets for your use, let me know any bugs, I'll fix em up for you.
ISFL Sheet: https://docs.google.com/spreadsheets/d/1...sp=sharing
DSFL Sheet: https://docs.google.com/spreadsheets/d/1...sp=sharing
Example pictures with arbitrary grades input to show functionality:
Overview page, you can update your scout names to populate the dropdown and change what season you're looking at
Draft Sheet, this is where you track the draft, copy and paste team names so you know who took who.
Your Prospects sheet that updates based on the TPE tracker and the Draft sheet
The "cool" sheet, the Big Board that updates based on your Prospect grades, and if they've been drafted.
Kickers scroll down to see yourselves
The sort order for position groups is:
1. Prospect Grade
2. TPE level
FIXING THE LOADING BUG.
1. Copy the value in this cell
2. Hit delete on it, and then press enter
3. Wait like 2 seconds and then put it back in, it should load back in
NOTES
What it does:
1. First off, it pulls data from the TPE Tracker endpoint directly instead of pulling from the Google Sheets sheet that pulls from the tracker. This improves reliability, no more sheet going down because you’re waiting for data to load. (It might go down but like, it's Sheets, only so much I can do)
1b. Sometimes sheets will still go down since Google does some background stuff, what you do to fix is go to the `Tracker JSON` sheet, copy the cell's value in A1, delete it and then paste it back in
2. Draft sheet that you can use to track the draft which smartly crosses off prospects from the list if they’ve been taken. You just need to select the player in the dropdown.
3. “Big Board” - This isn’t a true big board, I don’t think, but it’s close to it for a spreadsheet. This sorts all prospects by position, the number grade you give them, and then by TPE. It also pulls data from the Draft sheet to cross em out if they’ve been taken.
4. Automated with an Overview page! Well, I say automated, but basically if you put in the season you’re scouting for, it just changes the season you’re pulling prospects from.
Feel free to copy these sheets for your use, let me know any bugs, I'll fix em up for you.
ISFL Sheet: https://docs.google.com/spreadsheets/d/1...sp=sharing
DSFL Sheet: https://docs.google.com/spreadsheets/d/1...sp=sharing
Example pictures with arbitrary grades input to show functionality:
Overview page, you can update your scout names to populate the dropdown and change what season you're looking at
Draft Sheet, this is where you track the draft, copy and paste team names so you know who took who.
Your Prospects sheet that updates based on the TPE tracker and the Draft sheet
The "cool" sheet, the Big Board that updates based on your Prospect grades, and if they've been drafted.
Kickers scroll down to see yourselves
The sort order for position groups is:
1. Prospect Grade
2. TPE level
FIXING THE LOADING BUG.
1. Copy the value in this cell
2. Hit delete on it, and then press enter
3. Wait like 2 seconds and then put it back in, it should load back in
NOTES
- There are still some VLOOKUPs, this is a holdover from some older code I copied from the Ducks page and I kinda hate it but too lazy to fix with a better lookup function.
- There’s a possibility of the Big Board sheet “breaking” if there are more than 14 creates at a single position. I will probably not fix this but it’s easy to manually update to add more rows, and you can always DM on Discord and I will fix it for you.
- The ISFL version is slightly AZ themed, and the DSFL one is slightly Ducks themed from a colour standpoint, feel free to change it!
- Oh bigger note, this sheet uses sorting based on number comparisons, so grades should be in number form (aka from 0-3). If you use letters, S is gonna end up wonky, also probably any +/-s
Ultimus: S46, S47
ISFL Most Dedicated Member: S46
Gemini Awards: S42 Best Article (Series), S44 Best Article (Limited), S46 Best Author, S47 Best Author, S48 Best Article (Limited)
DSFL Most Dedicated Member: S42
Getting Defensive Podcast: S42 New Player Silver Medalist
ISFL All-Rookie Team: WR1 (S45)
DSFL Offensive Player of the Year: S43
DSFL First-team All-Pro: S43, S44
DSFL Pro Bowl: S42, S43, S44
S43 R1.01 - Arizona Outlaws
S42 R1.04 - Minnesota Grey Ducks
-----
Try out the Player Updater tool!
lemonoppy.com/isfl/player-updater
lemonoppy.com/isfl/player-updater