Member Ranking - Votes Counter

ver.2.14 database:2019.2
https://drive.google.com/open?id=1aw3annI9_A-uilxeVQ318iu9xZzNX5Q7
AKB48
Omori Myu -> Omori Miyu
Kamachi Yukina - added to Team8
Okumoto Hinano - added to Team8

NMB48
Horinouch Momoka -> Horinouchi Momoka
Azumi Yuki -> Azuma Yuki

HKT48
Murakawa Vivan -> Murakawa Bibian

NGT48
Takamura Moeka -> Takakura Moeka

STU48
Fujiwara Azua -> Fujiwara Azusa

JKT48 Academy
Chithlyn Gwynets Santoso -> Caithlyn Gwyneth Santoso
Nabila Gesmarli Putri -> Nabila Gusmarlia Putri
Tiara Hasyakyla Putri -> Tiara Sasi Kirana Putri

JKT48 Graduated members
Added:
Erika Sintia
Graciella Ruth Wiranto
Rifa Fatmasari
Reva Adriana
Calista Lea Jaya
Iris Vevina Prasetio

MNL Team NIV
Aubrey Ysabelle DelosReyes -> Aubrey Ysabelle Delos Reyes

Team SH
Zhou NianQ -> Zhou NianQi

SGO48 Graduated Members
Trần Nguyễn Phương Vy - removed

ver.2.14 database:2019.1
https://drive.google.com/open?id=1pzQtAPgmwYOZp7aE8kCtaxLFUjLm74Gp
MNL48
Removed from graduated members:
- Guinevere Muse
- Princess Rius Briquillo
- Ella Mae Amat
- Francese Therese Pinlac
- Anne Nicole Casitas
- Christina Samantha Tagana
- Ruth Carla Dela Paz
- Trisha Labrador


ver.2.14 database:2019.0
https://drive.google.com/file/d/1verzu4fGuhuuJWSOh06qGbWzZuwAQS4U/view?usp=sharing
- new database containing the list of the eligible members for the "The 2019 Stage48 Member Ranking"


ver.2.13 database:2018.4
https://drive.google.com/open?id=1IpbaaVmcKUjdMFHUUWb50GQI9ufclnUg
- short name of the groups changed
N46, K46, Y46, SH

member name changes:
- Harasawa Otohi
- Kamiyama Riho
- Yaguchi Moka
- Shoji Nagisa
- Umemoto Izumi


ver.2.13 database:2018.3
https://drive.google.com/open?id=1wvioiPtGf5uyuRkMpgk9NliIzWZuyUSm
member name changes:
- Nishimura Nanako


ver.2.13 database:2018.2
https://drive.google.com/open?id=1BGp878gWlGdhzeSBjGEXZN332TuRbBxs
- dialog window that prevents page close and refresh
- the location of the list of the members has changed: js/memberList.js

member name changes:
- Shoji Nagisa

ver.2.10 database:2018.1
https://drive.google.com/open?id=1dgs1AH9Ueaz9S7wiF1qVKpHZu6XeOPi-
member name changes:
- Tano Yuka

ver.2.10 database:2018
https://drive.google.com/open?id=1MjIM7fYHomB4K5BaB1sKmJqE_-qMFuSn
- new database containing the list of the eligible members for the "The 2018 Stage48 Member Ranking"

ver.2.9 database:2017.2
https://drive.google.com/open?id=1s2F0QhBGZWxfdjh3edlEztyyiOmbrcDv
- member name changes:
Michelle Chirsto Kusnadi --> Michelle Christo Kusnadi

ver.2.9 database:2017.1
https://drive.google.com/open?id=1rGKAY_obhFGo3sSBJ2A9-yb3HnMQ4xVr
- member name changes:
Arai Yuka - Arai Yuki
Murakumo Fuko - Murakumo Fuka

ver.2.9
https://drive.google.com/open?id=1SPZx5voKVVh0sRzfgxxK-1NDK8dlf1US
- new database containing the list of the eligible members for the "The 2017 Stage48 Member Ranking"
- new colors for the new groups

ver.2.8
https://drive.google.com/open?id=0BwoCX0Gh03Q9M1hJNkxVSi1wSHM
- when there is a tie the actual group order is:
(Top) JKT48 --> Keyakizaka46 --> Nogizaka46 --> NGT48 --> HKT48 --> NMB48 --> SKE48 --> AKB48 (bottom)

ver.2.7
https://drive.google.com/file/d/0BwoCX0Gh03Q9VE9BZEdDeUlHMjA
- member name changes:
Takahashi Ayanae - Takahashi Ayane
Kubo Shiori - Kubo Shiroi
Umeda Ayaka - new

ver.2.6
https://drive.google.com/open?id=0BwoCX0Gh03Q9SGt2cV9fMFhLd1U

- UI changes: recommended member and user names are clickable, previously deleted user votes, appearance
- shortcuts: add votes - ctrl+enter, delete votes - ctrl+del
- log messages are displayed when something goes wrong (for adding, deleting votes, loading saved votes)
- validation can handle names like Yokoyama Yui (Team 8)
- validation is much more strict, recognized vote format: 08. MEMBER NAME (+5), 03. MEMBER NAME (-3)
- group color changes
- result: ranking from the first member, rank: 1.1.3.4.5.5.7.7.9 etc...
- result: when there is a tie, sort members by group name then by member name, order: AKB, SKE, NMB, HKT, NGT, Nogi, KKK, JKT
- members' name eligible for 2017 are added.
special cases:
Member: name expected by the program
Yokoyama Yui - Team A: Yokoyama Yui
Yokoyama Yui - Team 8: Yokoyama Yui (Team 8)
Sato Shiori - Team 8: Sato Shiori (Team 8)
Sato Shiori - Keyakizaka46: Sato Shiori

Current outputs:
Export results to BBCode text

Spoiler

Overall Ranking​

The format is: This Year's Rank. (Last Year's Rank) [# of Positive Votes | # of Negative Votes] Member Name {+ Points, - Points}, Overall Points
25. (---) [0|2] Aramaki Misaki {+0,-10}, -10
24. (---) [0|2] Nakai Rika {+0,-8}, -8
23. (---) [0|2] Ikoma Rina {+0,-6}, -6
22. (---) [0|2] Akimoto Manatsu {+0,-4}, -4
17. (---) [1|1] Oguri Yui {+3,-1}, 2
17. (---) [2|0] Shibuya Nagisa {+2,0}, 2
17. (---) [2|0] Akiyoshi Yuka {+2,0}, 2
17. (---) [2|0] Tanaka Miku {+2,0}, 2
17. (---) [1|1] Maria Genoveva Natalia Desy Purnamasari Gunawan {+3,-1}, 2
14. (---) [2|0] Yokomichi Yuri {+4,0}, 4
14. (---) [2|0] Kato Yuuka {+4,0}, 4
14. (---) [2|0] Shiroma Miru {+4,0}, 4
12. (---) [2|0] Nishino Miki {+6,0}, 6
12. (---) [2|0] Sato Shiori (Team 8) {+6,0}, 6
9. (---) [2|0] Nozawa Rena {+8,0}, 8
9. (---) [2|0] Tani Marika {+8,0}, 8
9. (---) [2|0] Sato Shiori {+8,0}, 8
7. (---) [2|0] Suda Akari {+10,0}, 10
7. (---) [2|0] Syahfira Angela Nurhaliza {+10,0}, 10
6. (---) [2|0] Yokoyama Yui (Team 8) {+12,0}, 12
5. (---) [2|0] Yokoyama Yui {+14,0}, 14
4. (---) [2|0] Nagao Mariya {+16,0}, 16
3. (---) [2|0] Komiyama Haruka {+18,0}, 18
1. (---) [2|0] Kashiwagi Yuki {+25,0}, 25
1. (---) [2|0] Minegishi Minami {+25,0}, 25

Export grouped results to BBCode text
- Though, the result is correct, it needs a little clean up:
- group names are listed for every team - kind of redundant
- groups and teams are not in alphabetical order

Spoiler

Rankings Sorted by Team​

HKT48
TeamTII
25. [0|2] Aramaki Misaki {+0,-10}, -10
NGT48
TeamNIII
24. [0|2] Nakai Rika {+0,-8}, -8
Nogizaka46
Nogizaka46
23. [0|2] Ikoma Rina {+0,-6}, -6
22. [0|2] Akimoto Manatsu {+0,-4}, -4
AKB48
Team8
17. [1|1] Oguri Yui {+3,-1}, 2
14. [2|0] Yokomichi Yuri {+4,0}, 4
12. [2|0] Sato Shiori (Team 8) {+6,0}, 6
6. [2|0] Yokoyama Yui (Team 8) {+12,0}, 12
NMB48
TeamM
17. [2|0] Shibuya Nagisa {+2,0}, 2
14. [2|0] Kato Yuuka {+4,0}, 4
14. [2|0] Shiroma Miru {+4,0}, 4
HKT48
TeamH
17. [2|0] Akiyoshi Yuka {+2,0}, 2
17. [2|0] Tanaka Miku {+2,0}, 2
JKT48
TeamKIII
17. [1|1] Maria Genoveva Natalia Desy Purnamasari Gunawan {+3,-1}, 2
AKB48
Team4
12. [2|0] Nishino Miki {+6,0}, 6
9. [2|0] Nozawa Rena {+8,0}, 8
3. [2|0] Komiyama Haruka {+18,0}, 18
SKE48
TeamE
9. [2|0] Tani Marika {+8,0}, 8
7. [2|0] Suda Akari {+10,0}, 10
Keyakizaka46
Keyakizaka46
9. [2|0] Sato Shiori {+8,0}, 8
JKT48
TeamJ
7. [2|0] Syahfira Angela Nurhaliza {+10,0}, 10
AKB48
TeamA
5. [2|0] Yokoyama Yui {+14,0}, 14
AKB48
AKB48Graduates
4. [2|0] Nagao Mariya {+16,0}, 16
AKB48
TeamB
1. [2|0] Kashiwagi Yuki {+25,0}, 25
AKB48
TeamK
1. [2|0] Minegishi Minami {+25,0}, 25

ver.2.5
https://drive.google.com/open?id=0BwoCX0Gh03Q9NlZULU8tMlMtWjQ

- new feature: search votes by member name
the search textbox is not case sensitive
votes are displayed and ordered by points (descending)

ver.2.4
https://drive.google.com/open?id=0BwoCX0Gh03Q9TzRFMlEtNlJ3aW8

- corrected names in the db:
Kawago Rina -> Kawago Hina
Homma Hinata -> Honma Hinata
Ma Chia-Ling -> Ma Chia Ling

ver.2.3
https://drive.google.com/file/d/0BwoCX0Gh03Q9ZHVTSUdLdFhVdkk/view?usp=sharing

- grouped results (Rankings Sorted by Team) is added

Current outputs:
Export votes to TAB separated text

Spoiler

Oshima Yuko AKB48 TeamA 8 userA
Miyawaki Sakura HKT48 TeamH 4 userA
Yamamoto Sayaka NMB48 TeamN 2 userA
Yamauchi Suzuran SKE48 TeamS -1 userA
Maeda Ami AKB48 TeamB 1 userA
Kato Rumi SKE48 TeamS -1 userA
Ogasawara Mayu NMB48 TeamM -1 userA
Ogasawara Mayu NMB48 TeamM 8 userB
Yamamoto Sayaka NMB48 TeamN 4 userB
Kato Rumi SKE48 TeamS 2 userB
Maeda Ami AKB48 TeamB 1 userB
Oshima Yuko AKB48 TeamA 8 userC
Sato Sumire AKB48 TeamA 4 userC
Kato Rumi SKE48 TeamS 2 userC
Miyawaki Sakura HKT48 TeamH 1 userC
Ogasawara Mayu NMB48 TeamM -2 userC
Yamauchi Suzuran SKE48 TeamS -2 userC

Export results to BBCode text

Spoiler

Overall Ranking​

The format is: This Year's Rank. (Last Year's Rank) [# of Positive Votes | # of Negative Votes] Member Name {+ Points, - Points}, Overall Points
8. (---) [0|2] Yamauchi Suzuran {+0,-3}, -3
7. (---) [2|0] Maeda Ami {+2,0}, 2
6. (---) [2|1] Kato Rumi {+4,-1}, 3
5. (---) [1|0] Sato Sumire {+4,0}, 4
4. (---) [2|0] Miyawaki Sakura {+5,0}, 5
4. (---) [1|2] Ogasawara Mayu {+8,-3}, 5
2. (---) [2|0] Yamamoto Sayaka {+6,0}, 6
1. (---) [2|0] Oshima Yuko {+16,0}, 16

Export grouped results to BBCode text
- Though, the result is correct, it needs a little clean up:
- group names are listed for every team - kind of redundant now
- groups are not in alphabetical order and teams can appear anywhere, they are not sorted either
- team names don't contain the space character
- rank is the overall rank here - since i couldn't figure out what it should be exactly from last year's results

Spoiler

Rankings Sorted by Team​

SKE48
TeamS
8. [0|2] Yamauchi Suzuran {+0,-3}, -3
6. [2|1] Kato Rumi {+4,-1}, 3
AKB48
TeamB
7. [2|0] Maeda Ami {+2,0}, 2
AKB48
TeamA
5. [1|0] Sato Sumire {+4,0}, 4
1. [2|0] Oshima Yuko {+16,0}, 16
HKT48
TeamH
4. [2|0] Miyawaki Sakura {+5,0}, 5
NMB48
TeamM
4. [1|2] Ogasawara Mayu {+8,-3}, 5
NMB48
TeamN
2. [2|0] Yamamoto Sayaka {+6,0}, 6

ver.2.2
https://drive.google.com/file/d/0BwoCX0Gh03Q9R2pBaDZJQVQxcmc/view?usp=sharing

- members' name eligible for 2015 are added.
special cases:
Member: name expected by the program
Yokoyama Yui - Team A: Yokoyama Yui
Yokoyama Yui - Team 8: Yokoyama Yui Team 8
Sato Shiori - Team 8: Sato Shiori Team 8
Sato Shiori - Keyakizaka46: Sato Shiori
(in the result they will appear as Yokoyama Yui Team (without the 8) and Yokoyama Yui for example)

- better logging: when the votes cannot be added the reason is logged in the console
opening the console in firefox: right click on the page / inspect element / console

- the program doesn't brake when there are no votes added and Save Results is clicked


ver.2.1
https://drive.google.com/file/d/0BwoCX0Gh03Q9dVVpVjNVd3hpZk0/view?usp=sharing

- vote processing (as for now global only)

- converting results (processed votes) to bbCode using custom colors by groups
colors can be set in the userSettings.js file: /votesCounter2/js/userSettings.js
the bbcode output can be customized here too
(it can be edited in a text editor)

- saving result in bbcode format (Export results to BBCode text)
(load or put in votes first. otherwise refresh/reopen the local index.html then load votes etc...)

- new file added containing test votes, recommended for testing: /votesCounter2/json/test.votes.15.json
every row in the file represents one vote for one member
(it can be edited in a text editor and loaded using Load Votes)

- fix: sometimes it didn't save. it should be ok now on firefox and chrome

ver.2.0
https://www.dropbox.com/s/td3tqq9gv6ttrxx/votesCounter2.0.zip?dl=0

The main principles are the same as before. It's an app running in the browser locally: safe, transparent, easy to use stuff.

It has the "votes collector" feature, nothing more. However it lets you export the output to excel and, as I mentioned in the readme, from there pivot tables can be used to count the votes.

Content of the read me file:
the one in the zip file (readMe.html) is prettier, read that instead. : )

Spoiler: .

_STAGE48 Votes Counter_
====================
ver.2.0
####**Open**
Open the index.html in a browser.
_Note: this is a local JavaScript app running in the browser, no internet connection is needed._

####**File**

**Load votes:** opening previously saved json file that contains the raw votes
**Save votes:** downloading json file that contains the raw votes.
_Note: in this case the program will generate json data locally and prompt the browser to download it._
_Note: due to the security restrictions of the browser reading and writing files needs user interaction._

**Export votes to TAB separated text:** saving the votes to TAB separated text (UTF-8), that can be imported to Excel etc...
**Export results to TAB separated text:** not available yet
**Export results to BBCode text:** not available yet

####**Setup**
Not available yet

####**Add Votes**
**Input fields**

- Name: the name of the stage48 user
- Vote: votes - one line = one vote
- Search: search for user names, * character can be used for listing everyone whoes votes were added.

_Note: every field is case insensitive._
_Note: the app ignores the row number and the points for the votes, they have no meaning, only the name segment is interpreted. ex.: 02. **Aramaki Misaki** (+10) → Aramaki Misaki_

**Codes**

- OK: the name has been found in the database and can be added.
- Not Found (NF): the name wasn't found.
- Duplicate (D): the name is duplicated.
- Error (E): the line cannot be interpreted ex.: empty lines.

**Adding rules**
The votes cannot be added if the name field is empty or the name already exists in the database (it's been added before) or the votes aren't valid: NF, D, E or if there are more than 25 votes or less than 20.

####**Results**
Not available yet, however TAB separated text can be exported from the app, then it can be imported to [Excel](http://www.excel-easy.com/data-analysis/pivot-tables.html) or [Google Spreadsheets](https://support.google.com/docs/answer/1272898?hl=en) even and using the pivot table feature it can be counted.
[Google spreadsheets example](https://docs.google.com/spreadsheet...APq6V5IIf5Ga1I9hCv_E/edit?pli=1#gid=946467450).

_Note: using Google Spreadsheets can be slow if large number of votes are involved, I recommend using excel instead._
_Note: negative only or positive only votes can be counted by filtering the pivot table._
___
####**Compatibility**
- Latest Chrome: will crash when saving / downloading large number of votes (~10.000+)
- Latest Firefox: OK (tested with ~50.000 votes)
- Latest Opera: won't load large number of votes
- Latest Internet Explorer: wasn't tested, probably won't work
- Latest Safari: wasn't tested

Only Firefox is recommended.
___
####**Program**
**Directories**

- css/ - css styles for the index.html
- img/ - idols
- js/ - custom javascript files
- jsLibraries/ - javascript libraries
- json/ - votes in json for testing load/save features
- txt/ - test votes and the read me file in markdown

**Files**

- readMe.html - the readMe.txt file in html
- index.html - the opening page of the app
- /js/database.js - contains name of the members who are eligible for voting

**Database**
_/js/database.js_
The list of the members is based on the list ithebigc posted in the [Member Ranking thread](http://stage48.net/forum/index.php?...anking-voting-period-closed.8766/#post-988817).
_Note: the young Yokoyama Yui is **Yokoyama Yui TeamEight** in it and there is only one Takashima Yurina, it is duplicated in the original list._


**Json files**
_json/_
The json file is a text based file (can be viewed using ordinary text editors). In this case It's not very well formatted thought to conserve space because of a Chrome URI data bug (see Compatibility)
I recommend [jsoneditoronline.org](https://www.jsoneditoronline.org/) to view it with.

_Note: the jsoneditoronline site doesn't store the votes on it's server, it uses the [HTML5 Local Storage](http://www.w3schools.com/html/html5_webstorage.asp) feature which is a virtual local storage that can be accessed by the browser only, not even the user can access it from outside. It's a quite limited storage technique, that's why I couldn't use it for this app._

**JavaScipt libraries used**

- [AngularJs v1.3.14](https://angularjs.org/)
- [Underscore.js v1.8.2](http://underscorejs.org/)
- [Moment.js v2.9.0](http://momentjs.com/)

**Editors used**

- [Brackets](http://brackets.io/)
- [jsoneditoronline.org](https://www.jsoneditoronline.org/)
- [StackEdit](https://stackedit.io/)

**The code is licensed under**
[GNU General Public License, version 3 (GPL-3.0)](https://www.gnu.org/licenses/quick-guide-gplv3.html)

**Author**
[_@foodlfg_](https://twitter.com/foodlfg)
######[d^^b](
if the video does not show watch the video here)