Challenge No. 683: Find the value corresponding to numbers given in column N from the grid given of left hand side.
Solved using: Python.
RIGHT
Extracts a specified number of characters from the end of a text string in Excel.
Bi And Trimorphic Numbers
Challenge No. 665: Bi & Trimorphic Numbers – List numbers (n<100000) if n^3 and n^2 both end with n. Solved using: Python.
Three Regex Pattern Tasks
Challenge No. 552: This time 3 challenges into one to hone your regex skills.
Solved using: Python in Excel.
Sort by Unit Digit
Challenge No. 513: Sort the numbers on the basis of unit digit (last digit).
Solved using: Python.
Decrypt Pig Latin Words
Challenge No. 511: Pig Latin Decrypter – Decrypt the given encrypted text where encryption logic was following –
A new encrypted word is created with 3 components –
Component 1 – String having all alphabets from first vowel occurrence till end of the word
Component 2 – String having all alphabets before first vowel occurrence
Component 3 – String “ay”
Anything other than the English alphabet will be left as it is.
Solved using: Python in Excel.
List First 10 Tech Numbers
Challenge No. 494: Generate the first 10 Tech Numbers.
Solved using: R.
Parasitic Number Identification
Challenge No. 452: Parasitic number – is a positive natural number which, when multiplied by single digit n, results in movement of the last digit to its front.
Solved using: Excel VBA.
Validate Chinese National IDs
Challenge No. 428: Chinese National ID Card Validation
The Chinese National ID Card is of 18 digits and has the format NNNNNN-YYYYMMDD-NNN-C (- is inserted for the sake of brevity, numbers will be without -).
Solved using: Python.
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.
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.