Challenge No. 154: This problem is a variation of yesterday’s problem.
Solved using: Power Query.
⭐️⭐️⭐️⭐️⭐️⭐️Complex
Leave Days by Priority
Challenge No. 152: The table contains dates of only one year.
Solved using: R.
Fill Down and Up by Customer
Challenge No. 147: Fill down / up all 4 columns for different customer IDs.
Solved using: Python.
Meter Reading Consumption Split
Challenge No. 133: Find out the electricity consumption for all 3 meters for given dates.
Solved using: R.
People Connection!
Challenge No. 200: In the question table, direct connections between people are provided.
Solved using:Excel (IF, IFNA, INDEX), Power Query (List.Transform, Text.End), Python, Python in Excel, and R.
Mark Min/Max Date From Today
Challenge No. 129: Generate the result shown above.
Solved using: DAX.
Split Time into Weekly Blocks
Challenge No. 123: Calculate Start and Finish date times along-with duration in hours for all weeks.
Solved using: Python in Excel.
Calculate Vehicle Daily Usage
Challenge No. 122: Transform the problem table into result table and work out the total number of hours a vehicle has run on a particular date.
Solved using: Power Query (List.Transform).
Categorize Time Intervals Status
Challenge No. 114: Count Early, On Time, Late and Out of Limit for T2 against T1.
Solved using: DAX.
The Knight’S Tour!
Challenge No. 170: Given a N*N board with the Knight placed on the first block of an empty board.
Solved using:Excel, Python, and Python in Excel.