Challenge No. 212: Find the total commission of each sales person and sort it descending on total amount.
Solved using: Python.
⭐️⭐️ Easy
Slightly challenging problems for learners.
Carriage Return
Challenge No. 67: Split the data into separate rows
Combined data is separated by a carriage return
Not all rows have carriage returns
Dynamic array function allowed but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: Python.
Compute Pandovan Sequence Terms
Challenge No. 485: Pandovan Sequence – In number theory, the Pandovan sequence is the sequence of integers P(n) defined[1] by the initial values
P ( 0 ) = P ( 1 ) = P ( 2 ) = 1
and the recurrence relation
P ( n ) = P ( n − 2 ) + P ( n − 3 )
Find the nth term given in column A.
Solved using: R.
Group by Income Then Sort
Challenge No. 211: Append the groups one below the other and sort on Income descending, Name ascending within each group.
Solved using: R.
Find Pythagorean Triplets
Challenge No. 484: Pythagorean Triplets follow the rule a^2 + b^2 = c^2
Find a, b, c where a + b + c = Sum (which is column A).
Solved using: Python in Excel.
Generate 20×20 Number Matrix
Challenge No. 483: Generate a 20×20 matrix as given through a formula.
Solved using: Python in Excel.
Detect Hardy-Ramanujan Numbers
Challenge No. 481: A taxicab number (also known as Hardy Ramanujan Number) is a positive integer that can be expressed as the sum of two positive cubes in more than one way.
Solved using: R.
Decrypt Caesar Cipher Variation
Challenge No. 480: Decrypt the given Encrypted text.
Solved using: Python in Excel.
Generate Recaman’s Sequence
Challenge No. 479: Calculate first 10000 entries of Recaman’s sequence –
a(0) = 0,
for n > 0, a(n) = a(n-1) – n if nonnegative and not already in the sequence,
otherwise a(n) = a(n-1) + n.
Solved using: Python in Excel.
Merge Tables by Org and Year
Challenge No. 478: Merger the tables into a single table.
Solved using: Python.