Challenge No. 437: Bifid Cipher with Keyword
Suppose we want to encrypt the message “BATTLE” and keyword is “ROTORS”.
Solved using: Python in Excel.
By Topic
Challenges categorized by topic.
Match Deliveries with Calendar Dates
Challenge No. 186: Merge both the tables.
Solved using: Python in Excel.
Generate Employee Group Index
Challenge No. 185: For each group, generate the index.
Solved using: Excel VBA.
Split Delimited Text into Columns
Challenge No. 433: Split the given text into columns.
Solved using: R.
Encrypt with Bifid Cipher Method
Challenge No. 432: Bifid Cipher
Suppose we want to encrypt the message “BATTLE”.
Solved using: Python in Excel.
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.
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.
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.
Pivot for Time Entries by Date
Challenge No. 418: Pivot the given table for Date / Emp ID combinations with Min and Max Time.
Solved using: Python in Excel.
Split and Running Total Rows
Challenge No. 176: Generate the result table from problem table.
Solved using: Python in Excel.