Challenge No. 430: Create an alphabetic searchlight as shown.
Solved using: Python in Excel.
⭐️ Beginner
Easy challenges for newcomers.
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.
Double Accumulated Cipher Encoding
Challenge No. 427: Double Accumulate Cipher
Step 1.
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.
Sales Year Monthly Summary
Challenge No. 179: Generate the result table from problem table.
Solved using: R.
Stack Matrix Diagonals in Rows
Challenge No. 421: Stack the diagonals read from left to right of a matrix in rows.
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.
Cyclops and Triangular Numbers
Challenge No. 415: A Cyclops number is a number that has a zero in the center (so, it needs to have odd number of digits and >=3 digits).
Solved using: Python in Excel.
Pivot Using Suffix Headers
Challenge No. 413: Pivot the given data with headers suffixed with 1, 2.
Solved using: Python.
Count Unique Letters in String
Challenge No. 399: Extract the unique alphabets from the given strings and count their frequencies of occurrence.
Solved using: Python.