Forum Discussion
Creating/generating simple codes (cyphers) for kids using Excel
See the attached demo.
You're a genius!! This is exactly what I needed and wanted.
I'm now going to study the formulas used to see if I can discover how they work.
I'm very grateful!!
Many regards
I took a little while to upgrade every so slightly the way the spreadsheet works, and added a second tab with a visible and easy way to come up with ever more difficult to crack codes.
- Thanks for your reply Mathetes, I like what you've done and I think I will be able to use it for something else I'm working on!
Some time ago, I came up with a method to generate those often needed 4-digit codes we might need for such things as bike locks. I'm sure now, with the advent of, and my better understanding of, some of the newer functions, I could make this work more elegantly. Unlike the cyphers you were looking for, this does not necessarily generate unique codes for any given word; that wasn't my goal, which was to just come up with a code based on a word I could associate with the application. BIKE, therefore, becomes 2-9-2-5, and if it's been a long time since I last used my bike, I can quickly reconstruct the code.
My approach is a bit less straight forward than your second one, so a bit less "crack-able." Essentially, I reduce every letter to a single digit. The number 7 represents G, the 7th letter, and Q, the 16th, and Y, the 25th. T, the 19th letter becomes 10, which becomes 1.
But I love what HansVogelaar did with your request. He's a superstar in these parts.
