Challenge No. 397: Tri Numeral Alphabet Cipher – English alphabets are divided into groups containing 3 alphabets each and last group contain only 2 alphabets i.
Solved using: Python in Excel.
By Topic
Challenges categorized by topic.
Fill Missing Months Default
Challenge No. 159: For a give name and year combination, if a month is missing between 1 and 12 then enter that month number with a default sales of 100.
Solved using: Python in Excel.
Encrypt with Autokey Cipher
Challenge No. 393: AUTOKEY CIPHER – Key is written beneath Plaintext and if key is shorter than Plaintext, then remaining slots beneath Plaintext are filled by letters from Plaintext starting from beginning.
Solved using: R.
Log Changes Within Group
Challenge No. 157: Except the Group column, for every other column, log the value within a group if value changes.
Solved using: R.
Kamasutra Cipher with Digits
Challenge No. 388: Kamasutra Cipher 2 – Generate 13 random pairs from English alphabets and 5 random pairs from 0-9 digits and use that to encrypt the plain text.
Solved using: R.
Last Weekday of Each Month
Challenge No. 387: For a date given in cell A1, generate the last Mon through Sun of the month
-1 : Last
-2 : 2nd Last.
Solved using: Python.
Slice Numbers with Greater Rules
Challenge No. 384: Take position 1 in given number as first slice (I am following index 1 notation of Excel not index 0) and cut the slice starting from position 2 in such a way that the slice is > previous slice.
Solved using: Python in Excel.
Generate Kamasutra Cipher Encryption
Challenge No. 382: Kamasutra Cipher – Generate 13 random pairs from English alphabets and use that to encrypt the plain text.
Solved using: Python.
Leave Days by Priority
Challenge No. 152: The table contains dates of only one year.
Solved using: R.
Billable Hours by Weekday
Challenge No. 151: Work out the total hours spent by an employee (Table T1).
Solved using: Python in Excel.