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.
⭐️⭐️ Easy
Slightly challenging problems for learners.
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.
Draw Boat Using Grid
Challenge No. 435: Draw the given boat..
Solved using: Excel VBA.
Generate Employee Group Index
Challenge No. 185: For each group, generate the index.
Solved using: Excel VBA.
Encrypt with Bifid Cipher Method
Challenge No. 432: Bifid Cipher
Suppose we want to encrypt the message “BATTLE”.
Solved using: Python in Excel.
Rank Regions by Yearly Scores
Challenge No. 431: Rank regions on the basis of values given for each year and list the regions for maximum occurrences of Rank 1, 2 and 3 in different years.
Solved using: Python in Excel.
Reverse Data Splitting Problem
Challenge No. 182: Let’s do reverse of yesterday’s problem.
Solved using: Python.
Validate Chinese National IDs
Challenge No. 428: Chinese National ID Card Validation
The Chinese National ID Card is of 18 digits and has the format NNNNNN-YYYYMMDD-NNN-C (- is inserted for the sake of brevity, numbers will be without -).
Solved using: Python.
Transform Input to Result Table
Challenge No. 181: Generate the result table from problem table.
Solved using: Python.