Challenge No. 47: Count the process groups as given.
Solved using: Power Query.
By Topic
Challenges categorized by topic.
Vernam Cipher Encrypt
Challenge No. 162: Vernam Cipher (also known as One time pad cipher)
1.
Solved using: Power Query (List.ReplaceMatchingItems, List.Transform, List.Zip).
Table Transformation! Part 11
Challenge No. 122: Transform the question table into the reult table format.
Solved using:Excel (DROP, FILTER, HSTACK), Google Sheets, Power Query (List.Transform, Text.Contains, Table.AddColumn), Python, Python in Excel, and R.
Create Date Range Based on Rules
Challenge No. 46: Generate the result table as shown.
Solved using: SQL.
Power!
Challenge No. 121: Create the given table for the continuous values of power and bases.
Solved using:Excel (LAMBDA, MAKEARRAY, ROW), Office Script, Power Query (List.Transform), and Python in Excel.
Workday Count Between Dates
Challenge No. 157: Find the number of workdays between two dates (From & To) for Weekends given in column E.
Solved using: Power Query (NETWORKDAYS.INTL).
Generate Unique Records Based on Rules
Challenge No. 45: Calculate Running Total for each dealer.
Solved using: SQL.
Find Pythagorean Dates
Challenge No. 156: Pythagorean dates are those dates where DD^2 + MM^2 = YY^2
For example: 16-Dec-2020 where 16^2 + 12 ^2 = 20^2
List all Pythagorean dates (in YYYYMMDD format) from current century.
Solved using: Python in Excel.
Polybius Cipher Encrypt
Challenge No. 155: Polybius cipher
Encrypt the text in column I as per grid in A2:G8.
Solved using: Python in Excel.
Payments Duration!
Challenge No. 120: In challenge 60, we attempted to calculate the source of payment for each receipt.
Solved using:Excel, Google Sheets, Power Query (List.Transform), Python in Excel, and R.