Challenge No. 160: x, y coordinates are given for different cities.
Solved using: Python in Excel.
Table.AddColumn
Adds a new column to a table with computed values in Power Query.
Pilot Flight Rest Hours
Challenge No. 153: This time this problem will appear on both Sat and Sun with variations.
Solved using: Python in Excel.
Billable Hours by Weekday
Challenge No. 151: Work out the total hours spent by an employee (Table T1).
Solved using: Python in Excel.
Fill Missing Time Fields
Challenge No. 150: You need to fill in the blanks.
Solved using: Python.
Monthly Per Diem Calculation
Challenge No. 149: The data is for business trip start and end dates of employees.
Solved using: Python.
Fill Down and Up by Customer
Challenge No. 147: Fill down / up all 4 columns for different customer IDs.
Solved using: Python.
Map Groups to Company
Challenge No. 137: Generate result table on the basis of 2 problem tables.
Solved using: Python in Excel.
Assign Groups to Value Bins
Challenge No. 135: Generate the result table which is as per bin size.
Solved using: R.
Daily Stock Closing Value
Challenge No. 134: Yesterday’s challenge was a tough one.
Solved using: Python in Excel.
Create half-yearly sorted table from data
Challenge No. 340: From dataset in column A, create the table under Answer Expected.
Solved using: Python in Excel.