Challenge No. 669: Tech Number – A number is a tech number if it has even number of digits and square of sum of first half and last half is equal to number itself.
Solved using: R.
LET
Assigns names to values or calculations to simplify formulas in Excel.
Draw Alphabet Z Pattern
Challenge No. 668: Create alphabetic Z for N values as shown.
Solved using: Python.
Pivot Data To Columns
Challenge No. 667: Pivot the data as shown.
Solved using: Python.
Fill Missing With Average
Challenge No. 666: Fill in the blanks with (Total – Sum of non Blanks Values)/Number of Blanks
Hence for row 3: (580-(170+150))/1 = 260
For row 7: (440-90)/2 = 175
For row 9: (360-0)/3 = 120.
Solved using: Python.
Bi And Trimorphic Numbers
Challenge No. 665: Bi & Trimorphic Numbers – List numbers (n<100000) if n^3 and n^2 both end with n. Solved using: Python.
Track Quality Test Rounds
Challenge No. 664: After 3 rounds of quality testing, list the remaining batches from Round0 after each Round.
Solved using: Python in Excel.
Pivot Hierarchical Sublevels
Challenge No. 663: Pivot the data as shown.
Solved using: Power Query.
Matrix Transformation Series
Challenge No. 661: Today’s challenge is contributed by 🇰🇷 Taeyong Shin
Converts the T1 matrix to a T2 matrix and the T2 matrix to a T3 matrix.
Solved using: Excel.
Insert Yearly Sum Totals
Challenge No. 660: Insert the sum for the year after the year ends.
Solved using: Python.
Cube With Equal Digits
Challenge No. 659: Find those 2 digits to 5 digits numbers whose cube results into numbers where frequency of appearing digits are same.
Solved using: Python.