Closed

Need customized excel file

This project received 37 bids from talented freelancers with an average bid price of \$393 USD.

\$250 - \$750 USD
37
Project Description

Project Description:

Hello,

I Have a 3 Excel file with 16 columns (A to P) and about 850 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

I am sending a sample file for conversion

whoever will complete this sample file and send it to me

I will award the project to him/her with 100\$ as advance

Hire Freelancers who also bid on this project

• Forbes
• The New York Times
• Time
• Wall Street Journal
• Times Online