Challenge No. 29: — This week is FIFA world cup challenges —
If a country has appeared more than once in finals, find the maximum gap in years for next – previous appearance for that country.
Solved using: SQL.
Weekday Count of Christmas
Challenge No. 105: Find the counts of weekday names of Christmas during last n years mentioned in A1.
Solved using: SQL.
Generate Fibonacci Strings
Challenge No. 104: Generate n Fibonacci strings for given first two terms.
Solved using: SQL.
Lookingup Common Data
Challenge No. 24: Put the applicants on either shortlist, longlist or disqualify them
Use the required technologies for long or shortlist
Dynamic array function allowed, but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: Python in Excel.
Caesar Cipher Multi Shift
Challenge No. 103: This is the 3rd in series of Caesar’s Cipher Challenges.
Solved using: SQL.
Simuilation!
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.
Generate Italian Fiscal Code
Challenge No. 102: This is first part of 2 parts Italian Fiscal Code (Codice Fiscale) generation challenges.
Solved using: SQL.
Repeat Greek alphabets to match
Challenge No. 28: You will need to see which Greek alphabet appears maximum no.
Solved using: Power Query.
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.
Replace with Past Vowels
Challenge No. 100: The string contains only English alphabets.
Solved using: SQL.