Challenge No. 183: Transpose the problem table into result table.
Solved using: Python in Excel.
LAMBDA
Creates custom reusable functions in Excel.
Create Alphabetic Searchlight Grid
Challenge No. 430: Create an alphabetic searchlight as shown.
Solved using: Python in Excel.
Find Missing Pythagorean Quadruple
Challenge No. 429: A Pythagorean quadruple is a set of 4 integers a, b, c, d such that d^2 = a^2+b^2+c^2.
Solved using: Python in Excel.
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.
Reverse Data Splitting Problem
Challenge No. 182: Let’s do reverse of yesterday’s problem.
Solved using: Python.
Double Accumulated Cipher Encoding
Challenge No. 427: Double Accumulate Cipher
Step 1.
Solved using: Python.
Evaluate Tic Tac Toe Results
Challenge No. 426: Find the results of given Tic Tac Toe (Noughts and Crosses) boards.
Solved using: Python.
Transform Input to Result Table
Challenge No. 181: Generate the result table from problem table.
Solved using: Python.
Blend RGB Colors into Hex
Challenge No. 425: To blend hex color, take the average (round to 0) of respective Rs, Gs and Bs of two colors and generate the Hex color for the result.
Solved using: Python 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.