Some of you might remember @Raywes88 ’s WaniKani API + Google Docs Awesomeness spreadsheet from 2015. I’ve been using the spreadsheet from about that time, but I improved it over time and it can track a looooooot of data nowadays. [ETA: the version that I used was the one made by @Maxinoume here .] E…

@konekush I can’t figure out why these numbers don’t match. Please help, thank you! [image] [image] @OtakuShowboat Thank you so much for your help!

You likely did lessons after the initial running of the script (50, it seems). They should be reflected in a new entry the next time the scripts trigger. Edit: Misinterpreted the columns. See below.

I haven’t done any today though :thinking: I’ll see if the numbers match tomorrow

Note that it is including everything left for the current level in those columns, perhaps including what’s still locked. Edit: Aha, I see. It’s what’s left to guru.

Ah, so it’s including those I haven’t guru’d yet! I’ve unlocked and did lessons for all kanjis already, so that would be the right answer! AK and AL don’t make much sense to me though. Like what’s the difference between the two? AK is what’s left to guru? and the other? including the unlocked?

It’s the same as the kanji and radicals, telling what you have left to guru for vocab (current level) and all vocab you’ve yet to guru. As in, when you level up, you’ll have a bunch of vocab from the previous level to still do as well as new vocab with this new level. I’ll need to level up to really…

Aaaaargh, the numbers don’t add up though :c If AL is all vocab I’ve yet to guru (all levels up until now), I have technically over 236+ rather than 196 that the table is telling me. Unless it’s vocab I haven’t learned yet, which would remove a chunk of items already in apprentice. I wish the val…

Well, bear in mind, too, that some of those from previous levels that are apprentice now may have gone back from being guru at some point. Still counts as completed. Anyway, both AK and AL are the same value for me (78), which is exactly how many I have left available in lessons and currently locke…

I think I’ll grind everything down to 0/0 and then check the numbers to make sure I’m getting everything right! Thanks for helping me, I really appreciate it!

From what I understand I have to let the script run once, and then delete the word “formula” in the first line. I assume i’m doing something wrong, it might be me, or it might be the way it has been explained but after the “arrange sheet” part of the script ran, the formula is placed above the firs…

Self-updating WaniKani Statistics & Data Spreadsheet

WaniKani API And Third-Party Apps

UInt2048 September 9, 2020, 4:23pm 28

The sheet made by Viet might be a good start…

Topic		Replies	Views
WaniKani Google Sheet—Pull data from API version 2 to Sheet API And Third-Party Apps	35	5846	May 24, 2023
WaniKani API + Google Docs Awesomeness API And Third-Party Apps	55	23111	July 10, 2021
Self-Updating WaniKani Spreadsheet to Track Progress for API 2.0 API And Third-Party Apps	44	2890	November 5, 2021
[Unsupported] Progress Chart Script API And Third-Party Apps	43	6450	March 17, 2019
[Web App] WaniKani History + Timemachine API And Third-Party Apps	421	15604	August 5, 2026

Self-updating WaniKani Statistics & Data Spreadsheet

Related topics