Challenge No. 437: Bifid Cipher with Keyword
Suppose we want to encrypt the message “BATTLE” and keyword is “ROTORS”.
Solved using: Python in Excel.
LET
Assigns names to values or calculations to simplify formulas 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.
Split Delimited Text into Columns
Challenge No. 433: Split the given text into columns.
Solved using: R.
Extract Ending Pattern Group
Challenge No. 184: Extract the last group of alphabets followed by numbers in each Text and concat them with a dash in between for each Set.
Solved using: Python.
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.
Create Alphabetic Searchlight Grid
Challenge No. 430: Create an alphabetic searchlight as shown.
Solved using: Python in Excel.
Find Missing Pythagorean Quadruple
Challenge No. 429: A Pythagorean quadruple is a set of 4 integers a, b, c, d such that d^2 = a^2+b^2+c^2.
Solved using: Python in Excel.
Reverse Data Splitting Problem
Challenge No. 182: Let’s do reverse of yesterday’s problem.
Solved using: Python.