Jump to content


Photo

[Google Drive] AKB48 Senbatsu Election Results 2009-2017 Spreadsheet

spreadsheet akb48 senbatsu google drive excel request hour tables statistics 2009 2017

  • Please log in to reply
3 replies to this topic

#1 idolfire777

idolfire777

    Auditioning...

  • Shinmem
  • 2 posts

Posted 30 November 2017 - 08:12 AM

Good day all,

I couldn't find a compiled spreadsheet with all the past senbatsu election results displayed together. So here is one I made and shared on Google Drive. I hope someone else finds this helpful, and if you have any suggestions, please let me know. Basically I wanted a spreadsheet that had all the rankings available in one place, as opposed to having to view the results of each separate senbatsu based on year on websites such as Stage48. There are also a few other statistics and tables included (request hour setlist '08-'17, group statistics, average positions, percentage of total votes, etc). Check out the file regularly as I may add new things. I am also still working on the layout; designing isn't my strong suite. 

This is a direct link to the document. No adverts, waiting or survey rubbish.

https://goo.gl/NZJbQv

Regards,
Idolfire777



#2 minaeshi

minaeshi

    Mahou Idoru Shoujo ♥

  • Senpai
  • 4278 posts

Posted 30 November 2017 - 08:04 PM

Very interesting doc, my only suggestion would be, adding a spread showing the rankings of all the votes numbers, for example the amount of votes acchan needed to rank 2nd in the 2nd election is a lot higher than when it took her to rank 1st in the 1st election. if you do a chart showing the ranking of the number of votes, who those votes when to, in which election etc that would be a very interesting chart! 

 

Everything else was great, especially loved the percentage of total votes. it shows how great certain members buying power was when you see them still in the top 20 despite not even being part of half of the elections. 

 

Thanks for creating this! 


 tumblr_lygzzoSBD21r56dlh.gif
   sato masaki • murota mizuki • tanimoto ami   ❤ 

 


#3 idolfire777

idolfire777

    Auditioning...

  • Shinmem
  • 2 posts

Posted 01 December 2017 - 09:56 AM

Hi Minaeshi. Thanks for the suggestion and compliment. Do you mean something like this:

 

Total # | Year # | Name | Votes | Year | Group | Membership

1 | 1 | Sashihara Rino | 246376 | 2017 | HKT48 | Senbatsu Center

2 | 1 | Sashihara Rino | 243011 | 2016 | HKT48 | Senbatsu Center

3 | 1 | Sashihara Rino | 194049 | 2015 | HKT48 | Senbatsu Center

4 | 2 | Watanabe Mayu | 175613 | 2016 | AKB48 | Senbatsu Member

5 | 2 | Kashiwagi Yuki | 167183 | 2015 | AKB48 | Senbatsu Member

6 | 3 | Watanabe Mayu | 165789 | 2015 | AKB48 | Senbatsu Member

7 | 1 | Watanabe Mayu | 159854 | 2014 | AKB48 | Senbatsu Center

8 | 1 | Sashihara Rino | 150570 | 2013 | HKT48 | Senbatsu Center

9 | 2 | Watanabe Mayu | 149132 | 2017 | AKB48 | Senbatsu Member

10 | 2 | Sashihara Rino | 141954 | 2014 | HKT48 | Senbatsu Member

 

I could add this as an additional table, athough this can also be achieved by resorting one of the other tables by largest to smallest votes. That way you can then just use the row number as position indicator. But let me know if this is what you mean, otherwise just send me a picture or illustration and I'll see what I can do.

 

Regards



#4 minaeshi

minaeshi

    Mahou Idoru Shoujo ♥

  • Senpai
  • 4278 posts

Posted 01 December 2017 - 07:34 PM

Yes that's exactly what i mean! would be very interesting to see the rise and decline in votes for to attain certain positions each year. 


 tumblr_lygzzoSBD21r56dlh.gif
   sato masaki • murota mizuki • tanimoto ami   ❤ 

 





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users