It's my first time posting here, I hope this is a good place... but I wanted to share this, in case it could be useful to anyone.
For a little background, I've studied for a long time and have finally set my sights on taking either N1 or N2 next year (since I missed the deadline this year). However I'm not confident in my vocab, so I'm basically starting from 0 and making sure I have every single term burned into my head before I have to take it. I set up this sheet that will basically tell me if I'm on track for my weekly goals (including my stretch goal of N1) and how much progress I've made on each level.
It's still pretty rough and there are many things I want to add to it, but for now...
Here is the blank sheet. My goals are N2 or N1, so I have N2 on the left and N1 on the right.
Changing the blue areas under "Goals" will move the grey area up and down to show when you will meet your goal.
There are two spots for the two separate goals, obviously.
Changing these areas will change the increments for each week:
The grey area will update, too.
The date on the left can be changed to indicate your start date; the one on the right will change as well (I shouldn't have left that one blue, oh well).
It's set up to be one week at a time.
These areas are the current number of terms you have studied (and won't study below it, for those like me skipping katakana terms).
If you have met one of your goals...
...it will automatically check off that part of the week!
And if you meet both your kanji and vocabulary goals...
It will cross off the entire week so you know you don't have to worry about it anymore.
However, if you aren't completely caught up...
The week will highlight in yellow.
If you're way behind...
The overdue weeks will turn red!
Finally, there is a section that shows your progress on each of the levels according to your kanji and vocabulary counts.
When you've reached 100% for one part, it will turn green. (I may make 75% turn yellow, 50% orange, etc. but this works for now).
That's pretty much it for now.
Keep in mind I'm using the full version of Microsoft's Excel. I don't know if there will be problems if you use the online version or other software such as OpenOffice.
I've updated the sheet so that it bases the benchmarks on your desired end date instead of a manually inputted date, as well as the amount of terms you've already studied as of your start date. If you're starting from scratch, you can just put in 0 for the offset. :)