Closed

Need customized excel file

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

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
$250 - $750 USD
Total Bids
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

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

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