Among the features of anki the soft allows you to check your progress on joyo kanjis by displaying missing kanjis . Quite useful . And as long as I was studying KO2001 I wasn't asking for more as there was more than JPLT2 requirements and it was specifically designed for efficiency .
Now that I'm preparing for JPLT1 and that real japanese is my main SRS source I must hunt for kanjis ... Until a week ago I didn't mind much about this but now I'm clearly in a exam-battle mindset it's clearly unsatisfactory ,inadequate and deficient . I must cover the 2000 by 5th july ,that's it . KIC has sentences but unfortunetaly as I didn't convince anyone to work on it until the software release on the market everything must be typed .

So what I'm planning to do is copying the list of the missing kanji thanks to anki , put in a spreadsheet , add manually each sentence of the KIC for the missing kanji and then re import the list for anki to directly fill the gap .
Except that instead of having a line by character , it's a line by group (1st grade ,2nd grade , HS kanjis and so on) ! wich means for instance that the 6th line has hundreds of characters ....

Does anyone have some insight about how to sort out each character so that there is a line -a character ?

Problem with the Anki kanji list is it'll list kanji no matter where it's found in your deck. It's not able to limit it's search to one item of the fact. So for me, it'll look at the sentences and the vocabulary blocks.

Now, if you're wanting to get only the SENTENCES in KIC, then I can't think of an easy way to do that outside of creating a program to do it automatically. Doing something with a find/replace can work, but my thinking is apply it to the kanji column of the KIC list. After that you sort and are left with a line of kanji that were not used.

You could paste it into Word, and then write a very simple macro to just move the cursor 1 space to the right, and insert a carraige return (and repeat as many times as necessary)

It would look something like this, perhaps:

Selection.MoveRight Unit:=wdCharacter, Count:=1
Selection.TypeParagraph
Selection.MoveRight Unit:=wdCharacter, Count:=1
Selection.TypeParagraph

It is easy to get a list online of the KIC index (I have it saved somewhere), so you could then paste the resultant list into excel and do a vlookup to get the index number for each missing kanji in KiC.

Hope that helps.

Paste one set of missing kanji into cell A2.

Then put a 1 in cell B1, a 2 in cell C1, a 3 in cell D1, etc. So that all the columns are numbered.

Then put this formula in cell B2

=MID($A$2,B1,1)

Highlight cells B2 to Y2 or however far it goes. Press Ctrl+R.

Once you've done that, it's pretty easy to manipulate it to look like what you want. Make use of copy and paste with the rows and columns swapped. (Alternatively you could alter the above example so that you drag the formula vertically instead of horizontally)

Then, once every column represents a field in your chosen Anki model, and each row represents a fact, use these instructions:

http://ichi2.net/anki/wiki/FileImport

(see the bottom of that page)

wrightak Wrote:Paste one set of missing kanji into cell A2.

Then put a 1 in cell B1, a 2 in cell C1, a 3 in cell D1, etc. So that all the columns are numbered.

Then put this formula in cell B2

=MID($A$2,B1,1)

Highlight cells B2 to Y2 or however far it goes. Press Ctrl+R.

I have only Openoffice installed , are you using MicrosoftOffice:Excel? in which case shortcuts can be different
I tried your tip but didn't get any result . Ctrl+R only centered the text.
and typing =MID($A$2,B1,1) into B2 gets me #NAME? displayed in the case.

I'm using Microsoft Excel. It can definitely be done in Openoffice. The first thing you need to do is convert

=MID($A$2,B1,1)

to

=MID($A$2;B1;1)

and see if that works. If not, they must have a different name for the same function.

I'll look into it...

Paste one set of missing kanji into cell B1.

Then put a 1 in cell A2, a 2 in cell A3, a 3 in cell A4, etc. So that all the rows are numbered.

Then put this formula in cell B2

=MID($B$1;A2;1)

Select cell B2. Click on the small square in the bottom right corner of that cell, drag it downwards.

wrightak Wrote:Paste one set of missing kanji into cell B1.

Then put a 1 in cell A2, a 2 in cell A3, a 3 in cell A4, etc. So that all the rows are numbered.

Then put this formula in cell B2

=MID($B$1;A2;1)

Select cell B2. Click on the small square in the bottom right corner of that cell, drag it downwards.

Do I have to use Ctrl-R ?
otherwise I tried with your new instructions I didn't get more results.
Still have #name? displayed in every and each cells where I dragged the formula. (BTW the formula doesn't change no matter how much I drag the box selection)

Control R is just a shortcut for dragging.

The error you're getting indicates that one of the arguments isn't correct.

I changed the instructions this time, so that it can give you a vertical list of kanji instead of a horizontal one. Please make sure you follow all of the instructions exactly as I wrote them.

To check: Does the formula work correctly for cell B2? Does it give you the first kanji in the list?

Alternatively, send me an email and I'll reply and you can send me the file. I'll do it for you.

I had figure out that the argument is'nt right . What's puzzling me is why the formula doesn't change no matter how much I drag . There's something off.

Doesn't work even for B2.
I very closely followed your instruction .

EDIT OK for the mail.

Ok I found a way out.

Thanks .

On a side note does anybody have a list of KIC with reference numbers?

I sent you the file. I have no idea why it wasn't working for you.

For those that may wish to do the same thing, here's what I should have done last night:

http://spreadsheets.google.com/ccc?key=p...zlGHyDnjOw

wrightak Wrote:Paste one set of missing kanji into cell B1.

Then put a 1 in cell A2, a 2 in cell A3, a 3 in cell A4, etc. So that all the rows are numbered.

Then put this formula in cell B2

=MID($B$1;A2;1)

Select cell B2. Click on the small square in the bottom right corner of that cell, drag it downwards.

You can avoid the extra number column by using the ROW() (or COLUMN()) function. E.g. if your string is in A1 (top left cell), put this formula in A2:

=MID($A$1, ROW(A2)-1, 1)

or

=MID($A$1, ROW(A1), 1)

Drag down as far as needed: If there are 2042 characters, drag down to A2043. Dragging down in Excel is done either by pulling the + symbol as wrightak described or by selecting the top cell that contains the formula (in this case A2) and all cells up to the last one (shift+left-mouse-click comes in handy here), and then pressing Ctrl+D or go to the Edit menu -> Fill... -> Down. Ctrl+R is used to fill to the right.

OpenOffice's Calc application seems to prefer semi-colons between parameters of a function, but otherwise uses the same function names, according to these docs.

Personally I would use a text editor and a RegExp Find/Replace, putting "(.)" in the find box and "$1\n" in the replace box, and then replace all.

I wouldn't add the ROW() and COLUMN() elements to the function myself. It makes it harder to read and if you decide to insert a row to the top (to the label the columns), you'll have to alter all of the formulae. At the end of the day, you're just going to copy and paste what you want into a text file so you want to put it together in the simplest way possible.

In the spreadsheet I link to, if you click on file and then export, you can have openoffice or excel.

Nice tip with the Find/Replace arguments. Could be useful in the future.

The Kanji in Context index information is contained in the freely available Kanjidic file. It can be extracted into a standalone list without too much difficulty.

See any of these pages for further info:

http://www.google.co.uk/search?q=kanjidi...GB261GB261

[Katsuo]

NickT Wrote:The Kanji in Context index information is contained in the freely available Kanjidic file. It can be extracted into a standalone list without too much difficulty.

I converted Kanjidic into spreadsheet format, which makes such data very easy to extract. KIC info here.

wow great! it'll be very useful to everyone !

Katsuo, you wouldn't have a spreadsheet that lists the numbering scheme for Kanji.Odyssey.2001 would you?

[Katsuo]

Nukemarine Wrote:Katsuo, you wouldn't have a spreadsheet that lists the numbering scheme for Kanji.Odyssey.2001 would you?

Well I didn't, so I just quickly put this together. Is that what you need?

Katsuo, you got it. Thanks a lot. Now we can see if pubbie can use this to with his resort program.

[Katsuo]

I don't know if it will be of use to anybody, but I cross-referenced Kanji Odyssey 2001 numbers with KANJIDIC and RTK1 here.

Hi there,

great spreadsheets!
I was wondering how to make one, still from the kanjidic file, that includes not only the codes, the Japanese kun and on and the meaning, but also the Chinese and Korean pronunciations.
The best would be with the various on, kun, Chinese and Korean pronunciations all in separate cells.
Cheers!