Last question: What Is Your Favorite Series?
This one is a bit of a bitch. Picrel is my spreadsheet from rearranging the votes in a more logical way than Google Forms allowed. As you can see, if we were doing a first-pass-the-post system, then the winners would be
a tie between Sun and Moon and X&Y. I can't imagine anyone being satisfied with that result, and since this was a ranked vote, there are a few options to figure out a true winner. Since we only had a few choices and respondents, I chose the "eliminate and reallocate" method, which you can read about here:
https://www.rankedvote.co/guides/applying-ranked-choice-voting/how-to-calculate-ranked-choice-voting-with-google-forms-and-google-sheets. In a nutshell:
>Count the number of 1st place votes>Eliminate lowest scoring series>Reallocate next choice for respondents to the remaining series to get an idea of the breadth of support.>Eliminate lowest scoring in next round and repeat(1/2)
