# Need customized excel file

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

Skills: Data Entry, Data Processing, Excel

Project ID: #5425022

## 35 freelancers are bidding on average \$395 for this job

happy2helpp

Respected sir, We are experts in Data Entry, Data Processing, Data Research, Web Search, Web Scraping, Copy Typing, MS Office and many other tasks. We saw the project description and got complete idea about it. We have More

\$515 USD in 10 days
(64 Reviews)
6.9
BrothersTeam

A proposal has not yet been provided

\$555 USD in 10 days
(74 Reviews)
5.1
carivera

Hello I have understood your requirement, I assure you accuracy and speed to get this done. I will build you a user form for you to add new rows. and a summary tab for the reports you're asking. 6+ Years of ex More

\$333 USD in 2 days
(6 Reviews)
4.2
samin59

\$250 USD in 10 days
(10 Reviews)
4.0
tomislav1975

Hello, One of my customers have named me Excel Guru. That I am not but I know very much about Excel and VBA. Please check my reviews, profile and portfolio and award me with trust. With regards, Tom

\$444 USD in 7 days
(4 Reviews)
3.4
srdas2012

Hi, We are Expert in Excel & Excel based programming Macro VBA/VB6/VB.Net .We have seen your requirement Ready to make the changes as per your Requirement..(We will be able to send you any message or Sample files On More

\$250 USD in 7 days
(5 Reviews)
3.1
pedrumj

\$250 USD in 4 days
(6 Reviews)
2.9
Ricklnd

Hi, I'm Expert in Excel (+8 years exp), and I can do it, of course... But, I know how do all it WITHOUT VBA, just using formulas/functions, please, let me show you.

\$300 USD in 1 day
(4 Reviews)
2.4
swatsgupts123

Kindly share the sample file with me. I will get the same customized as per your requirement and get back to you. In case you are satisfied with the work delivered then only award it to me. I know i can deliver that is More

\$277 USD in 5 days
(3 Reviews)
2.1
elqueabandona

Hi, I have a degree in business and I work with excel every day, I love to create formulas and interpreting the results. Send me an attachment and I'll send you a sample. Best regards.

\$555 USD in 4 days
(1 Review)
1.4
indu0806

Hello, I found your job post and I’m very interested in your project. As a Microsoft professional with experience in data entry, I think you’ll find I have the skills you’re looking for. Please take a look at my port More

\$250 USD in 7 days
(1 Review)
0.4
thashma

I am Thashma Manori. I have a bachelor’s degree in Applied Sciences at Wayamba University of Sri Lanka.My major subjects are Computing & Information System and Statistic as Major I and Major II respectively. And I fol More

\$250 USD in 3 days
(0 Reviews)
0.0
hellosk

I can do your work because I love to work on excel. I have excellent knowledge of works of Data Entry, Office Admin. I am also expert in Microsoft excel, word, access & other software which basically used for data entr More

\$272 USD in 10 days
(0 Reviews)
0.0
nifferboy

\$455 USD in 3 days
(0 Reviews)
0.0
mukeshbarik

A strategic and logical thinker with excellent knowledge in identifying and defining marketing opportunities and problem having rich experience of 12 years in Market Research Analysis & Project Management • Experience More

\$555 USD in 10 days
(0 Reviews)
0.0
ahas89

hello, Respected Sir/Madam, It is my pleasure to be able to bid on your project. I am not going to show my skills but I am serious with my work which I responsible for. I can do your project very successfully. More

\$250 USD in 3 days
(0 Reviews)
0.0
mytym

Please send through the sample file and I'll show you what I can do. From your description the task is well within my capability. Let me know if you're interested.

\$250 USD in 10 days
(0 Reviews)
0.0
Sudhamaran

A proposal has not yet been provided

\$250 USD in 2 days
(0 Reviews)
0.0