Challenge No. 140: Work out the End of Day Stock.
Solved using: R.
⭐️⭐️⭐️⭐️⭐️Expert
Highly advanced challenges.
Unpivot and Merge Names
Challenge No. 132: Unpivot the problem table into result table.
Solved using: Python in Excel.
Text Mapping Between Tables
Challenge No. 130: For Table T2, look for value column of Table T1 in City/Country and Text columns of Table T2 and prepare the mapping shown in Result table.
Solved using: DAX.
Index by Department or Mail
Challenge No. 118: Assign Index starting with 1.
Solved using: Python in Excel.
Summarize Hours by Role Title
Challenge No. 112: Generate the result table from problem table where Hours are summation for a particular role.
Solved using: Python in Excel.
Company Totals for Items/Amount
Challenge No. 104: Prepare the result table from problem table.
Solved using: Python.
Code State-Branch Combinations
Challenge No. 101: Create codes for the combination of State and Branch.
Solved using: Power Query.
Calculate Quarterly Working Payment
Challenge No. 100: Per day rates for every person for a duration is given.
Solved using: Python in Excel.
Process Time Running Totals
Challenge No. 98: 1.
Solved using: Python.
Eight Knights Puzzle!
Challenge No. 160: The problem aims to place 8 knights (hours) on a chess board in such a way that each row/column is occupied by a single knight and no knight removes the other one from the chess board.
Solved using:Excel, Power Query, Python, Python in Excel, and R.