Challenge No. 104: Monte Carlo simulation is a technique used to predict the outcome of decisions by simulating a process multiple times.
Solved using:Excel, Power Query, Python, Python in Excel, and R.
LET
Assigns names to values or calculations to simplify formulas in Excel.
Generate Italian Fiscal Code
Challenge No. 102: This is first part of 2 parts Italian Fiscal Code (Codice Fiscale) generation challenges.
Solved using: SQL.
Divide by 7 Recursively
Challenge No. 101: Divide the numbers given in column A by 7 and round it up.
Solved using: Python in Excel.
Companies with Positive Growth
Challenge No. 99: List the companies which have positive annual growth rate during all 3 period years and their Average Annual Growth Rate (AAGR) .
Solved using: Python.
Custom Average!
Challenge No. 103: Today is 20/08/2024, and we’re calculating the average delivery time per product in days.
Solved using:Excel (AVERAGE, CHOOSECOLS, FILTER), Google Sheets, Power Query (Table.AddColumn, Table.Group), Python, Python in Excel, and R.
Find Two Numbers with Sum
Challenge No. 98: From column A, find 2 numbers which when summed give the sum as in column C.
Solved using: Python.
Pair clubs so each team
Challenge No. 27: There are 9 clubs and every club has to play with remaining 8 clubs once only.
Solved using: Power Query (Table.AddColumn).
Compare Rows! Part 1
Challenge No. 102: In the historical sales table, identify and extract the dates where the sales value on that date is greater than the sales on the previous date.
Solved using:Excel (DROP, FILTER, IF), Google Sheets, Power Query (Table.AddColumn, Table.AddIndexColumn, Table.SelectColumns), Python, Python in Excel, R, and VBA.
Extract Middle Word(s)
Challenge No. 94: Extract the middle words in given data.
Solved using: SQL.
Avg Cost Between City Pairs
Challenge No. 92: Find the average cost between the pair of cities.
Solved using: Python in Excel.