Apr 7, 2021
Need help with cipher translator that I built in Google Sheets
Hello all,
I created a fictional language for a story that I'm writing. This language is essentially a cipher. How the cipher works is as follows. 1. the letters in the word are all separated. 2. the individual letters are converted to their number equivalents (a=1, b=2, etc.). 3. the number corresponding to each letter is added to the corresponding digit of pi (i.e. if the word is 'abc', it would become '1 2 3', after the pi addition it would be 1+first digit of pi, 2+second digit of pi, 3+third digit of pi). 4. if the resulting number is above 26 (number of letters in the alphabet) it runs a modulo on the number. 5. it converts the number back to a letter. 6. it combines the letters into one cell. I'm sorry if I explained this poorly.... Because the first letter of the word must always be matched to the first digit of pi, the second letter must be matched with the second digit of pi, etc... I'm not sure what to do to allow the translator to translate multiple words at once.
Here is the google sheet so that you can take a look at it: https://docs.google.com/spreadsheets/d/1JV6qUaZkk9bGZLdjmJy8kYyns_XaKMWasH2GbHpM-ik/edit?usp=sharing
Thanks for the help!
EDIT: the google sheet is now editable.
EDIT: Thank you Jon!
EDIT: link is now updated.
EDIT: Jon, you're a legend.
Details
Community content may not be verified or up-to-date. Learn more.
Last edited Apr 8, 2021
All Replies (2)