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!
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.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
At this present moment, no. It's something others have tried in the past, but never without bugs to my knowledge.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!
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.
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)."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
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.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.
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
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.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.
Thank you! I put mine up there!Here, try this, there's a form to submit an advertisement and have it posted: https://www.smogon.com/forums/threads/draft-league-advertisement-thread.3710830/
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.On the draft sheet templates, how do I record kills and death without getting an error message?
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!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.
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.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?