Challenge No. 554: Kaprekar Number = Take an n digit number, square it, divide it into 2 parts such that part1 + part 2 = n where part1 or part2 should not be 0, then it is a Kaprekar number.
Solved using: Excel VBA.
SEQUENCE
Generates a sequence of numbers in an array in Excel.
Draw ASCII Abacus Display
Challenge No. 553: Draw an ASCII abacus.
Solved using: Python in Excel.
Find Watson-Crick Palindromes
Challenge No. 551: Watson-Crick (WK) Palindromes – A DNA string is a Watson-Crick (WK) Palindrome when the complement of its reverse is equal to itself.
Solved using: Python in Excel.
Odd Numbers All Directions
Challenge No. 550: Last week, we had this challenge.
Solved using: Python in Excel.
Transpose problem table into result
Challenge No. 249: Transpose problem table into result table.
Solved using: Python.
Tap Code Cipher Generator
Challenge No. 548: Since long, I didn’t post a cipher challenge.
Solved using: Python in Excel.
Transpose the problem table into
Challenge No. 248: Transpose the problem table into result table.
Solved using: Python.
Rank Players by Uppercase
Challenge No. 545: There are 6 players (q, w, e, r, t, y) and if a player wins, it appears in upper case and if it loses, then it appears in lower case.
Solved using: Python.
Create Text-Based Square
Challenge No. 542: Generate the given squares from the given strings.
Solved using: Excel VBA.
Five-Weekend Month Finder
Challenge No. 541: List the months and years having 5 Fridays, 5 Saturdays and 5 Sundays in a month for the years 2000 to 2999.
Solved using: Python in Excel.