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.
LET
Assigns names to values or calculations to simplify formulas in Excel.
Double Accumulated Cipher Encoding
Challenge No. 427: Double Accumulate Cipher
Step 1.
Solved using: Python.
Transform Input to Result Table
Challenge No. 181: Generate the result table from problem table.
Solved using: Python.
Evaluate Tic Tac Toe Results
Challenge No. 426: Find the results of given Tic Tac Toe (Noughts and Crosses) boards.
Solved using: Python.
Max Monthly Sales Change
Challenge No. 180: List the total sales, maximum change in sales month on month basis (absolute value) and From and To months when this maximum change occurred.
Solved using: Python.
Insert Product Between Digits
Challenge No. 424: Take ith and (i+1)th digits, multiply them and insert the result between the same digits.
Solved using: Excel VBA.
Sales Year Monthly Summary
Challenge No. 179: Generate the result table from problem table.
Solved using: R.
Find Disagreeing Leap Years
Challenge No. 422: Revised Julian Calendar Leap Year Rules
1.
Solved using: Python in Excel.
Stack Matrix Diagonals in Rows
Challenge No. 421: Stack the diagonals read from left to right of a matrix in rows.
Solved using: Python.
Track Org Role Changes
Challenge No. 178: Create a corresponding row in result table if there is a change in either role or org.
Solved using: R.