vote Pyure
And I feel it obligatory to say as I am officially Mewtwo in this game: HEIL MEWTWO!
And I feel it obligatory to say as I am officially Mewtwo in this game: HEIL MEWTWO!
And that's three.vote Pyure
And I feel it obligatory to say as I am officially Mewtwo in this game: HEIL MEWTWO!
All you say is correct. I probbably derped up a few.I guess I'll vote Trubbish, aka Nobody.
Also, Dylan, I don't understand how, exactly, you came up with your Vote Explanation spreadsheet. So far, I've discerned that for single-typed voters, their vote counts as zero if the votee is immune to their type, one if the votee is resistant or double-resistant, two if it's normally effective, three if the votee is weak to the voter's type, and four if the voter is doubly weak.
Based on this alone, I *think* there's an error on the Vote Explanation spreadsheet, specifically in the cell where ljfa votes for Shazam. ljfa is a pure Ice type, so I assume that his vote would count as an Ice-type attack. Shazam is a Rock/Flying type. Ice-type attacks are supereffective against Flying types, but not Rock types. So, to my understanding, ljfa's vote against Shazam would be worth three votes, not four.
Also, I have absolutely no idea how two-typed voters are handled. For instance, a Steel-type vote against Bug/Rock RJS would be supereffective, while a Fairy-type vote against him would be normally effective. According to the Vote Explanation sheet, my Steel/Fairy vote against him would be worth 3, consistent with a Steel vote.
However, Fairy-type votes, but not Steel-type votes, are supereffective against Fighting-type trajing. The Vote Explanation says my vote against him is worth 3, consistent with a Fairy-type vote. So it looks like the type of vote used can be either of the voter's types, whichever would be worth more.
Then I look at what would happen if I voted for Shazam... Steel is supereffective against Rock/Flying, so it should be worth 3. But I look at the Vote Explanation sheet and... 1 vote? How?
If any of these inconsistencies are due to Dylan derping, I can add a section to my spreadsheet that duplicates the Vote Explanation sheet by filling in all the relevant cells automatically, without derps. If I knew, with certainty, the rules used to fill in Dylan's sheet, at least...
Ok, good to know. Automation, engage!All you say is correct. I probbably derped up a few.
And done. I've added a section to my spreadsheet on the first page, below all the teambuilder-ey stuff that had been in there before. This section precisely replicates my understanding of the algorithm Dylan used to create the Vote Explanation sheet, but *should* not contain any single derps (because if one cell was derped, half of them would be, and I'd probably notice and fix it). It's all calculated dynamically from the pokemon listed in at the left side of the top chart, so if Striking mega-evolves, for instance, Dylan or I would just need to update his pokemon species from "Altaria" to "Mega Altaria", and the sheet will automatically change his secondary type from Flying to Fairy, and that change will be reflected in the rest of the sheet.Ok, good to know. Automation, engage!
I will try. I'm not sure how far I'll be able to go, but I'll try to implement as much of that as I can within Google's limitations.can you make something, Were i fill in who votes against who. And then i get a total of who will get lynched
Can't it check 2 couloms put them somewere and then add them all together?And done. I've added a section to my spreadsheet on the first page, below all the teambuilder-ey stuff that had been in there before. This section precisely replicates my understanding of the algorithm Dylan used to create the Vote Explanation sheet, but *should* not contain any single derps (because if one cell was derped, half of them would be, and I'd probably notice and fix it). It's all calculated dynamically from the pokemon listed in at the left side of the top chart, so if Striking mega-evolves, for instance, Dylan or I would just need to update his pokemon species from "Altaria" to "Mega Altaria", and the sheet will automatically change his secondary type from Flying to Fairy, and that change will be reflected in the rest of the sheet.
I even made it use the same color scheme as Dylan's sheet.
I will try. I'm not sure how far I'll be able to go, but I'll try to implement as much of that as I can within Google's limitations.
Ideally, I'd have it spit out a list of players who have been voted for sorted by how many effective votes they have against them, but I don't think Google will let me sort it or even compress it by removing the players with no votes.
I think I just did both.Can't it check 2 couloms put them somewere and then add them all together?
voter
pyure
voted
squid
it would be neutral, So you add 2 votes to squids name
Or something like that
You did since playerismc's vote ain't super effectiveI think I just did both.
If you look at the spreadsheet now, you'll see there's yet another brand-new section placed to the right of the initial one. The first column in this section is each player's name; the next column and all the wide columns after it are who that player voted for each day.
After each wide column is a pair of narrow columns. The first of these is how much the vote immediately to its left is worth. For example, the 3 in cell AL8 shows that HeilMewTwo's Psychic-type vote against Nobody (a Poison-type Trubbish) is worth three votes, because Psychic-type moves are supereffective against Poison types.
The second narrow column is how many effective votes each player has. The cell in Pyure's row for D1, for example, is currently 5, which sums Eruantien's normally-effective vote (worth 2) and playerismc's supereffective vote (worth 3).
This should be enough to determine fairly quickly who will be lynched each day after all the votes are entered in- just look for the biggest number in the last narrow column that isn't all zeros, and scan to the left. I could add a thing at the bottom for the player with the most votes fairly easily, but it wouldn't work right in the case of a tie, so I won't.
I've gone ahead and filled in all of today's votes; however, at this point, I think I'll leave filling in future votes to Dylan. If I derp somewhere, it would be... bad.
someone else is getting super complicated. Don't worry about it.Let's hope I can follow and understand this game...