Do some Excel Work

Project Description: Hello, I Have a Excel file with 16 columns (A to P) and 1625 rows Column A is date Columns B to P are 14 numbers (Randomly from 1 to 25) WHAT IS NEEDED: I need a Dynamic Excel file that allows me the following: - Add future records in the same format in the future (More Rows, same columns) And Calculate the following: A- Top 10 Most repeated numbers of all rows / columns including the date that they appeared B- Max separation between numbers of each ROW: Each row will have 14 numbers, i need the biggest separation between numbers on each row, for example if we have 3 , 6 the separation number would be 2. 1 , 3 = separation 1 With that information on each row, i also need top 3(most repeated) SEPARATION numbers according to the results of all ROWS. C- SUM of all numbers of each ROW: I need the SUM of all numbers in each ROW. With that information i need the top 3 ranges between numbers For example 1 - 2 - 3 - 6 - 9 - 11 - 12 - 13 - 14 - 17 - 18 - 19 - 24 - 25 = 174 59% have values between 174 and 192 80% have values between 193 and 200 etc.. D- Pair and Impair numbers: Since we only have numbers between 1 to 25 and only 14 digits We have 12 pair numbers (2 - 4 - 6 - 8 - 10 - 12 - 14 - 16 - 18 - 20 - 22 - 24) 13 impair numbers (1 - 3 - 5 - 7 - 9 - 11 - 13 - 15 - 17 - 19 - 21 - 23 - 25) I need to know the "top 3" % of which we see pair and impair numbers. For example 40% of the 14 digits of each ROW have 6 pair numbers and 8 impair numbers. E- Prime Numbers Since we have 14 numbers from 1 to 25 in each ROW i need: Top 3 Quantity of prime numbers on EACH ROW F- Numbers with one digit and two digits I need the top 3 '%' of one digit and two digit numbers that appear on each ROW. For example 68% have 4 one digit numbers repeteated 79% have two digit numbers repeated G- PREVIOUS ROW COMPARISSION Compare all rows with their previous to see how many digits repeat and show the TOP 3 digits repeat quantity for example 87% repeat 5 numbers from previous row 50% repeat 2 numbers from previous row 40% repeat 4 numbers from previous row answer with "goal" for attention