Challenge No. 512: A number is called a Sparse number if its binary form doesn’t have any two adjacent 1s.
Solved using: Python in Excel.
⭐️⭐️⭐️ Intermediate
Moderate difficulty level.
Reshape Wide Table Format
Challenge No. 224: Transpose the problem table into result table.
Solved using: Python.
Sum Pascal Triangle Columns
Challenge No. 509: A Pascal Triangle starts with 1 at the top and each element is sum of two upper diagonal cells.
Solved using: R.
Draw Alphabet Triangle
Challenge No. 505: Draw the triangle of alphabets as shown.
Solved using: Python in Excel.
Generate Lynch Bell Numbers
Challenge No. 499: Lynch Bell Numbers – Generate the first 500 Lynch Bell Numbers starting with 2 digits.
Solved using: Excel VBA.
Palindrome Count and Sum by Digit
Challenge No. 495: Find the count and sum of Palindrome numbers for N digits Palindrome numbers.
Solved using: Python in Excel.
Outstanding Loan Day Count
Challenge No. 215: Assuming today’s date is 7-Sep-24, pivot the table as shown for Outstanding loans.
Solved using: Python in Excel.
Add Task Duration to Start
Challenge No. 209: Populate the End dates against all owners in a pivot format as shown.
Solved using: Python.
Compile Role Based Totals
Challenge No. 206: Generate the result table from problem table.
Solved using: Python in Excel.
Pivot Yes No Percentages
Challenge No. 205: From tables T1 and T2, generate the result table.
Solved using: Python in Excel.
