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
Project Budget$250 - $750 USD
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
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.
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
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online