First and foremost, I updated the spreadsheet a couple of days ago, so if you didn't get the update from the Hanzi forum, get the "original, unconverted Excel 2010 spreadsheet" now:
→
RevTH forum: Spreadsheet with RSH + RTH + RTK!
I suggest the unconverted one because it's already formatted as a table and ready to use, with all the right fonts, filters enabled and so on. There were also
many reliability updates so it's definitely worth it. The statistics I gave you before are still similar but not exactly the same anymore.
About what you've asked:
1. K<>H → Kanji <not equal to> Hanzi. The <> is a 'different' operator in some programming languages and actually what I was taught to use in math classes here (now that I think about it, I could use != in the spreadsheet but I don't know if that would be clearer or not.) These are the characters that are aligned in some way but are not the same; in the old spreadsheets there were some odd aligments with keywords but in the new one just means that the kanji are Japanese variants of the hanzi (and some Japanese variants are archaic versions of hanzi, things that were used before in China but not anymore. These are all indicated in the new
K and H Visual Check column [another non-descriptive column name, I know].)
2. The sort order I suggested was just that, a suggestion; you can do anything you want if you think it's better. Using the
RTH# (not RTK#) as the secondary sort was just so that you could get the RTH characters you have not seen in RTK in crescent order, as they are presented in the book.
Now, in the new spreadsheet, you can do some neat tricks such as these:
1/2. Hide the characters that were not covered in the Traditional Hanzi books by using a filter (the down arrow you see in the screenshot there) in the
K and TH keywords column and uncheck the
RTH key missing and
RTK key & RTH key missing boxes (you don't
need to do this, but if you don't then you'll get many characters that don't have keywords.)
2/2. Hide the kanji you've already seen in RTK by using a filter in the
K and H check column where you unselect the
K = TH = SH and
K = TH boxes.
These are simply filters to hide what you've "already seen", to make the spreadsheet cleaner; you can disable the filters if/when you want to see the hidden characters for some reason or another, such as to check the new keywords in case they are different or something like that.
Then just sort things in any way you want — I believe what you want to study are probably the
K <> H,
K = SH and
K missing characters defined in the
K and H check column. That's all, no need to differentiate them between "what was covered but it's different" and "what was not covered", it just complicates things.
K = SH are the Kanji that are simplified hanzi, that is, you know the simplified variant but need to study the traditional one. By "know" I mean that Excel says their codepoints are the same, which often means they look the same but there's a very small number of them that look different depending on which fonts you use.
I know these column names and values are a little hard to get at first but it was necessary to make the columns smaller and tidier, reducing the horizontal scroll and white space; the first versions, back in 2011, had full column names and values but that just didn't work out very well.