Challenge No. 427: Double Accumulate Cipher
Step 1.
Solved using: Python.
MID
Extracts a substring from a text string at a given position in Excel.
Insert Product Between Digits
Challenge No. 424: Take ith and (i+1)th digits, multiply them and insert the result between the same digits.
Solved using: Excel VBA.
Decode Color Band Resistance
Challenge No. 420: For the given color bands in Column E, work out the total resistance.
Solved using: Python in Excel.
Split by Alpha-Numeric Change
Challenge No. 417: Split the given strings whenever a changeover happens between English alphabets and numbers.
Solved using: Excel VBA.
Cyclops and Triangular Numbers
Challenge No. 415: A Cyclops number is a number that has a zero in the center (so, it needs to have odd number of digits and >=3 digits).
Solved using: Python in Excel.
Validate IMO Check Digit
Challenge No. 414: IMO Number of a Vessel – This is a 7 digit number where last digit is check digit.
Solved using: Python in Excel.
Square Digits Until Single Number
Challenge No. 412: Square the individual digits of a number and sum them.
Solved using: Python in Excel.
Roman Palindromic Numbers
Challenge No. 410: List all decimal numbers whose Roman equivalents are Palindromic.
Solved using: Python.
Reverse, Cipher and Shift Text
Challenge No. 407: Mirror Cipher with Caesar’s Shift – Reverse the words and then reverse the alphabets within the words.
Solved using: Python.
Validate Vehicle Registration Numbers
Challenge No. 163: Extract the valid vehicle registration numbers from given data table T2.
Solved using: R.