• Check out the relaunch of our general collection, with classic designs and new ones by our very own Pissog!

Resource Draft League Simple Questions, Simple Answers

For those running their own draft league, is there an automated way (e.g. a script) to get the Kills/Deaths from a showdown replay? For MVP boards.

Thanks for your help!
 
For those running their own draft league, is there an automated way (e.g. a script) to get the Kills/Deaths from a showdown replay? For MVP boards.

Thanks for your help!

i know im a bum in this thread also asking shit but i wasted time on a few online tools that didnt function like i wanted and eventually settled on analyzing the replays with the discord Porygon bot's /analyze tool. still have to manually enter data but it's honestly not that bad, especially with bo1. data entry is the wage of running a draft league.
 
this is probably a stupid question with an obvious answer but i cant figure out how to make a free agent acquisition/trade function on the bog standard draft league template sheet. i'm trying, on the Transactions tab, to have a coach drop one pokemon in favor of picking up another on the draft board.... how do i do this? thanks in advance
The Transactions page is effectively used for record keeping. To actually edit someone's team, just edit the Draft page as you would during the draft proper.

For those running their own draft league, is there an automated way (e.g. a script) to get the Kills/Deaths from a showdown replay? For MVP boards.

Thanks for your help!
At this present moment, no. It's something others have tried in the past, but never without bugs to my knowledge.
 
The Transactions page is effectively used for record keeping. To actually edit someone's team, just edit the Draft page as you would during the draft proper.

the reason i assumed there was some sort of automated functionality for roster changes is because the pokemon stats tab includes a section for dropped mons - is that just not actual functionality or something, because it doesnt populate like that when you just swap a mon on the draft tab lol

edit: omfg there's a teensy column that hides the mon names that populate the stat sheet with sprites and shit.... i wish that was labeled so i knew you're just supposed to manually do the drop/adds yourself so i didnt spend like an hour fussing with this
 
the reason i assumed there was some sort of automated functionality for roster changes is because the pokemon stats tab includes a section for dropped mons - is that just not actual functionality or something, because it doesnt populate like that when you just swap a mon on the draft tab lol
You add those in manually. From the Setup tab on the doc: "Pokémon Stats: In the 5px wide columns, in the rows with grey sprite cells, put the names of any dropped Pokémon (e.g. G18:G27)."
 
Hello, I am trying to organize a draft league with friends using the spreadsheet I found around here. It works fantastically but I seem to be running into a couple issues with the newest pokemons introduced in the 2 DLCs (Ogerpon, Archaludon, poison legendaries....). I have no issue erasing and adding them manually but the draft sheet doesn't allow them to be typed in. Is there anyway around it or certain spelling I should use? Thanks in advance.
 
Hello, I am trying to organize a draft league with friends using the spreadsheet I found around here. It works fantastically but I seem to be running into a couple issues with the newest pokemons introduced in the 2 DLCs (Ogerpon, Archaludon, poison legendaries....). I have no issue erasing and adding them manually but the draft sheet doesn't allow them to be typed in. Is there anyway around it or certain spelling I should use? Thanks in advance.
This should be fixed; it was working on every tab bar Match Stats from what I can see. Feel free to make a new copy.
 
Nyx and abriel, thank you so much for the awesome draft sheet templates. I used the older version for an ORAS draft with friends and now I'm setting up this new version for an USUM draft.

I've run into an issue though. I have a group of 12 people, which means the league will take 11 weeks. For some reason, the Match Stats tab does not show the coach names for Week 11 matches, though it correctly populates everything for Weeks 1-10.

On the Data tab, columns L through V all look good. The Week 11 matchups are correctly shown there. The Schedule tab does show the Week 11 matchups correctly as well. However, Data column BE does NOT populate the Week 11 teams, just like the Match Stats tab does not.

What Match Stats and Data column BE have in common is a VLOOKUP formula that I have tried to understand but I don't have any experience with Sheets.
The Match Stats tab and the BE column in Data both use a VLOOKUP formula that seems like it should fetch Week 11 correctly, but for some reason it just skips right over that week. Any idea what the problem is or how to fix it? I can't add the Week 11 coach names in manually to column BE of the Data tab, because then it interrupts the second half of the VLOOKUP function that fetches the righthand side of the coach names for Weeks 1-10. I couldn't find any extra whitespace in columns L-V, where these VLOOKUs are trying to search (and it does so correctly for weeks 1-10).

This problem remains whether or not I use the Setup or Reset custom scripts.
I apologize if this is the wrong place to ask, I am not a Sheets expert and couldn't find a good answer on my own.

https://docs.google.com/spreadsheets/d/1-WCvVaA4stxFYTTm-P9InWa1d5CYVWr0OAzrVr5yxKU/edit?usp=sharing
 
Hey everyone! I'm pretty new to draft league and competitive in general - a lot of my experience comes from random battles. Does anyone have advice on how to know what to draft, when to draft those mons, etc? With being new to draft league, I don't have much of a clue on the entire draft process - both prep wise and during the draft itself.

Thanks, y'all have a lovely day
 
Hey everyone! I'm pretty new to draft league and competitive in general - a lot of my experience comes from random battles. Does anyone have advice on how to know what to draft, when to draft those mons, etc? With being new to draft league, I don't have much of a clue on the entire draft process - both prep wise and during the draft itself.

Thanks, y'all have a lovely day

In my experience, the best course of action is to build a team around a strong, central win condition and pick supportive, synergistic partners for that Pokemon that cover its weaknesses and accentuate its strengths. It's good practice to make this win condition one of, if not the most expensive Pokemon you draft points-wise (or tier-wise depending on the draft league you're joining). Your gameplan should not be totally linear and match-up dependent though, so it's important to plan more than one path to victory and be able to switch your team's style depending on the opponent you face.

Battling in a draft league is very different than a random battle or even a ladder battle because of the amount of knowledge you both have. You need to determine which Pokemon and which sets on your opponent's teams are most threatening to you, find a way to counter it, and build sets that you think prey on your opponent's weaknesses the best. Many strategies that function well in an environment where you don't know your opponents Pokemon going in completely fall apart in draft. (The best example of this is Garganacl, who has been an OU mainstay for most of Gen 9 with its signature move Salt Cure. But since any opponent can just bring the item Covert Cloak, which deactivates the secondary effect of Salt Cure, to hard counter Garganacl specifically, the Pokemon is far from top tier in a draft format.) Typically, the Pokemon who succeed the best in a draft league are the ones with the most set variety, unpredictability, and role compression to adapt to any match-up you need. Movesets can become very specialized just to defeat highly specific enemy threats, and you'll often see moves and items used which have almost no niche in any other competitive format.

All of this is to say that the best course of action is to boil down Pokemon to the roles they fulfill and try and have as many of your bases covered as possible, both in drafting and in battling. You can't always get everything you want, and there's going to be tough choices on what to take or leave. Try and pick a balanced team that has room to become more experimental in any given matchup, and learn your opponent's style so you can capitalize on it with surprising or off-meta choices. Most importantly, have fun and good luck!
 
Nyx and abriel, thank you so much for the awesome draft sheet templates. I used the older version for an ORAS draft with friends and now I'm setting up this new version for an USUM draft.

I've run into an issue though. I have a group of 12 people, which means the league will take 11 weeks. For some reason, the Match Stats tab does not show the coach names for Week 11 matches, though it correctly populates everything for Weeks 1-10.

On the Data tab, columns L through V all look good. The Week 11 matchups are correctly shown there. The Schedule tab does show the Week 11 matchups correctly as well. However, Data column BE does NOT populate the Week 11 teams, just like the Match Stats tab does not.

What Match Stats and Data column BE have in common is a VLOOKUP formula that I have tried to understand but I don't have any experience with Sheets.
The Match Stats tab and the BE column in Data both use a VLOOKUP formula that seems like it should fetch Week 11 correctly, but for some reason it just skips right over that week. Any idea what the problem is or how to fix it? I can't add the Week 11 coach names in manually to column BE of the Data tab, because then it interrupts the second half of the VLOOKUP function that fetches the righthand side of the coach names for Weeks 1-10. I couldn't find any extra whitespace in columns L-V, where these VLOOKUs are trying to search (and it does so correctly for weeks 1-10).

This problem remains whether or not I use the Setup or Reset custom scripts.
I apologize if this is the wrong place to ask, I am not a Sheets expert and couldn't find a good answer on my own.

https://docs.google.com/spreadsheets/d/1-WCvVaA4stxFYTTm-P9InWa1d5CYVWr0OAzrVr5yxKU/edit?usp=sharing
I looked into it and this was a bug. Basically, the references used to retrieve the data used on the Match Stats tab was not unique specifically for Week 11, which resulted in the empty cells you saw. This has now been fixed, and if it's not too much trouble, you can make a new copy of the sheet.
 
I looked into it and this was a bug. Basically, the references used to retrieve the data used on the Match Stats tab was not unique specifically for Week 11, which resulted in the empty cells you saw. This has now been fixed, and if it's not too much trouble, you can make a new copy of the sheet.

Thank you! I would have never figured out how to fix that.
FYI it looks like the problem still exists on column BE on the Data tab. I was able to make the same fix you did for my sheet, but atm it looks like it's still on the original sheet.
 
They are released when the previous slate of Pokemon are almost all out of the quality checking process. There are no strict requirements, however QC may reassign a Pokemon if they feel that the writer doesn't understand what the Pokemon is used for.
 
What error exactly are you receiving? You record kills and deaths on a per-match basis in the designated columns in the Match Stats tab.
I think the problem was that I put kills and deaths before I put Games Played in, my mistake but thank you for the info!
 
I hate asking another question, but for the 6th matchup in Week 1, no Kills or Deaths are being converted to Pokemon Stats or MVP Race. Is this a Bug? Screenshot 2024-07-22 212939.pngScreenshot 2024-07-22 212951.pngScreenshot 2024-07-22 220525.png
 
Hello, why is Mega Gallade listed at 19 points on the sample NatDex sheet? What makes it so much better in this format compared to regular NatDex singles, is it just a powered-up version of what it does in ORAS?
 
Hello, why is Mega Gallade listed at 19 points on the sample NatDex sheet? What makes it so much better in this format compared to regular NatDex singles, is it just a powered-up version of what it does in ORAS?
Mega Gallade’s entire “gimmick” so to speak is being insanely customisable to any given matchup. It’s not comparable to standard tiers where that customisability is far less value, you’d rather Mega Medicham who’s good enough into most teams. When you have the luxury of knowing exactly what can come, Mega Gallade’s stupidly deep offensive and support movepools make it that much better in any given matchup. As for whether it’s the same as ORAS/USUM, kinda but notably Agility turns it into a disgusting cleaner since it lacked Speed control until this gen.
 
I hope that Natdex draft analyses open up sometime soon, 'cause there's a lot of Pokemon like Mega Gallade who could use a detailed breakdown.
 
Guertena

We're currently focusing on SV and USUM. ORAS and SWSH are formats we hope to do down the line once USUM is much further along. Past that, perhaps a new generation will have arrived for us to focus on, but non-generational formats may be considered once those four (or five!) are at or near completion. It may also be that we do not do NatDex or other non-standard formats.
 
Back
Top