Spreadsheet edition

[bnordgren]

I'm pretty new to this, just learning the names (and sounds) of the letters and sounding out words. For practice, I took your TSV file, imported it into a spreadsheet using LibreOffice, and made a practice tool with little more than an IF statement and conditional formatting. I don't know if it's useful for anyone else, but it might be. It basically allows you to guess the Latin spelling of the shavian script and reveal the answer later. (Letters too, for those who are really really just starting.) The answer will remain hidden until the "Show" column contains something other than "N". Wrong answers are highlighted red, correct answers are green.

For the words, I've sorted by frequency descending. I figure that takes me to the most popular words right off the bat. For the letters, I have an order column that you can get new values for by clicking recalculate. So if you want to try the letters again without running the risk of just learning the pattern, you'd:

• Click on the Letters sheet
• Click on Recalculate
• Sort by the order column
• Copy this Letter column over the Letter column in the "Guess Letter" sheet.
• Start guessing letter names

Eventually I may add the ability to exercise "writing" in shavian instead of just reading it. Right now, I don't want to deal with hunting and pecking on an unfamiliar keyboard on top of the mental wrangling.

kingsleyreadlexicon.ods