Good evening.
Sorry for my poor English.
Inspired by this post: https://community.wanikani.com/t/self-updating-wanikani-statistics-data-spreadsheet, I made a Google SpreadSheet that lets you generate a chart of your SRS stage progression on any radical, kanji or vocabulary:
On the Y-axis are the ten SRS stages ( 0: Initiate, 1: Apprentice I, 2: Apprentice II, 3: Apprentice III, 4: Apprentice IV, 5: Guru I, 6: Guru II, 7: Master, 8: Enlightened and 9: Burned). The X-axis is for Time.
You can even compare your evolution on two or more subjects:
HOW DOES IT WORK?
On the sheet âSubjectsâ, all the radical, kanji and vocabulary are preloaded. Once you input your API key and load the data, you will see your SRS stage and Leech Score for each subject. I got the Leech Score from this post: https://community.wanikani.com/t/leech-detector. The formula is:
Max( meaning_incorrect / meaning_current_streak, reading_incorrect / reading_current_streak). You can filter the sheet by any of the available fields.
To generate the chart, you must select one or more rows. Your can click on any cell of the row. Then you must click on the menu option âWaniKani / Draw Chart From Selectionâ . A new sheet named âChartâ will be created. On this sheet, you can see the new chart.
Be careful when you select while using the filters. If you are pressing Shift, the hidden rows will be included.
WHERE DO I GET IT?
If you have a Google account, here:
HOW TO SET IT UP?
Click on âFileâ then on âMake a Copyâ. Save a copy on your Google Drive. On the copy, go to the sheet âConfigâ and input your API key V2 on the appropriate cell. Click on âToolsâ and then on âScript editorâ. Run the script âloadDataâ, so that Google can ask for your authorization.
To update your data, click on the menu item âWaniKani / Load Dataâ
The Loading takes a while. The video is accelerated.
Enjoy.
Feel free to ask any questions or make any suggestions.