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.
LEFT
Extracts a specified number of characters from the beginning of a text string in Excel.
Convert to Pig Latin Cipher
Challenge No. 348: Pig Latin Cipher – 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: R.
Generate Soundex Codes
Challenge No. 128: Every Soundex code consists of a letter and three numbers, such as W-252.
Solved using: R.
Extract string before any letter repeats
Challenge No. 333: Extract the string before any alphabet is repeated.
Solved using: R.
Pattern Length!
Challenge No. 194: For each date, samples are evaluated based on quality and marked with a “+” sign if they are within range and a “-” sign if they are out of range.
Solved using:Excel (DROP, HSTACK, IF), Google Sheets, Power Query (List.Transform, Text.Remove, Text.Split), Python, Python in Excel, and R.
Swap first and last letters unless vowels
Challenge No. 317: Swap the first and last letter of each words in given names.
Solved using: DAX.
Convert ISBN10 to ISBN13 Numbers
Challenge No. 309: Convert ISBN10 to ISBN13 Numbers
1.
Solved using: Python in Excel.
List Portmanteau words
Challenge No. 308: List Portmanteau words.
Solved using: Python in Excel.
Rank Teams by Total Points
Challenge No. 304: Wins (W), Drawn (D) and Lost (L) have weightages of 1, 0 & -1.
Solved using: Python in Excel.
List the Polydivisible numbers
Challenge No. 301: List the Polydivisible numbers.
Solved using: Python in Excel.
