Challenge No. 442: Columnar Transposition Cipher
Write the keyword in a row
Rank the letters of keyword as per their position in English language in descending order.
Solved using: Python in Excel.
Generate Integers From Ranges
Challenge No. 441: Generate the integers corresponding to intervals.
Solved using: Python.
Allocate Amounts by Quarter Days
Challenge No. 188: Divide the amount across quarters falling in between From and To Date.
Solved using: Python in Excel.
Interpolate Grid Position Values
Challenge No. 440: Today’s challenge is proposed by Sunny Baggu
a is for row 1 and b is for column 1.
Solved using: Python in Excel.
Find Interpolated Grid Values
Challenge No. 439: Today’s challenge is proposed by Sunny Baggu
a is for row 1 and b is for column 1.
Solved using: Python in Excel.
Yearly Sales for All Continents
Challenge No. 187: Generate the result table from problem table.
Solved using: Python in Excel.
Convert Resistance to Ohms Unit
Challenge No. 438: Now, let’s express the derived values as K, M or G (Kilo, Mega or Giga).
Solved using: Python in Excel.
Encrypt Using Bifid Cipher
Challenge No. 437: Bifid Cipher with Keyword
Suppose we want to encrypt the message “BATTLE” and keyword is “ROTORS”.
Solved using: Python in Excel.
Match Deliveries with Calendar Dates
Challenge No. 186: Merge both the tables.
Solved using: Python in Excel.
List Prime Pandigital Numbers
Challenge No. 436: An n digit number is Pandigital if it makes use of all the digits 1 to n exactly once.
Solved using: Excel VBA.