終了

Need a script to sort & count numbers in a Excel file

We are looking for a script developed that can count the number of times a particular number appears in each column. The script need to load the data from a large csv file like:

email,word,powerpoint,sap,rdpi,inet,firefox,pcp,xltt,backup,antivirus,shareme

190,17941,17941,179101,233,233,190,3741,23321,310,156,233

741,179,109,12,122,2335,48,47,109,12,122,2335

1907,106,109,156,37,16,156741,122,13341,17941,233,400

831,17941,16,310,36,18,0,17941,16,23302,310,18

1907,106,109,1,2332,36,233,106,310,1,2332,106

831,12,2331,2339,190,156,156,12,2331,2339,190,156

133,179,16,13341,33,2333,133,47,16,13341,33,2333

831,133,2336,233,2330,12,8,133,2336,233,2330,12

710,310,2330,1,156,190741,17910,310,2330,1,156,1904

741,109,179,2337,2336,109,106,109,179,2337,2336,109

Result should show for each column, what are the top 3 most recurring number(s). For example, in the sample above, for column 1 (email), the results should be:

Top number(s): 831 (3 times)

2nd number(s): 741,1907 (2 times)

3nd number(s): 190,710,133 (1 time)

Please PMB if you have any questions.

Let's say I start populating the column with numbers one by one. Let's say the first number is 14, I want the script to start looking for three numbers 13,14,15 (+1, = ,-1) in that column.As soon as I enter one of those (3) target numbers before the desired sequence of numbers (i.e.60) is met, I need some sort of warning. I also want to know as soon as I have 60 numbers that exclude those 3. Every time the script finds of on "undesired" numbers before the goal of 60 numbers is reached, it should move to the next consecutive number in the column.









Please note that the first portion of the project was mistakenly copied into the field. I do not need the top numbers thing. Only the part about a sequence of 60 numbers.

スキル: ケーキPHP, PHP

さらに表示: top sort, sap script, 233, word script, sap a, excel powerpoint word, excel recurring, php csv sample, load excel, php excel csv, excel number word, excel count, number word excel, file sort, firefox amp, email excel file, word csv, large script, script load, count times word appears excel

採用者について:
( 5件のレビュー ) Oakland, United States

プロジェクトID: #1482469

7人のフリーランサーが、このジョブに平均$52で入札しています

srinichal

I can deliver the same asap

$80 USD 2日以内
(91件のレビュー)
7.1
bogdanperian

I understood the description ( both of them )

$70 USD 2日以内
(18件のレビュー)
5.2
phpSQLexpert

hi, this can be done immediately. Please check Inbox. thanks

$50 USD 0日以内
(21件のレビュー)
4.8
jasonbourne501

I'm highly interested. Please check pmb

$32 USD 1日以内
(12件のレビュー)
4.7
anuragcdot

HI, i will complete project in time with quality

$200 USD 15日以内
(0件のレビュー)
0.0
jakit1989

Please check the PMB.

$30 USD 1日以内
(0件のレビュー)
0.0
excelmacro

Serious and competent work. Check my solution on PMB.

$30 USD 0日以内
(0件のレビュー)
0.0
lamontef

There are a few ways to accomplish your task, I've sent questions very PM.

$75 USD 5日以内
(0件のレビュー)
0.0