customized excel file within 2 hours
$10-30 USD
货到付款
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
项目ID： #5411182
关于项目
有16名威客正在参与此工作的竞标，均价$20/小时
Hi Being an associate at a Sales & Marketing consultancy, I have vast experience and expertise in data analysis on excel. Having said that, I believe I can provide you with the required deliverable in a span 2-2.5 h 更多
hey brother. ok I will do this work. but you are not verify for payment option. please meet me on call i want to talk with you then i will do it in 2 Hrs
Hi, I would like to work for you and I assure you that I will complete the work on time, within budget and with full accuracy. Regards, Freelancer2206
.......................................................................................................................................................................
It's a left hand trick for a veteran of excel. I have 15 years of working experience with Excel since Version Excel 5.0. I will complete the project within one night. You may contact me for further details on my cell n 更多
