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.
Max Monthly Sales Change
Challenge No. 180: List the total sales, maximum change in sales month on month basis (absolute value) and From and To months when this maximum change occurred.
Solved using: Python.