Data Mining between two excel files

進行中 投稿 Jan 11, 2012 着払い
進行中 着払い

this is to describe the scope of the project:

please mark the items in fnet file that are listed in pca file

so source file is pca file

destination or target file is fnet file

you will be marking with "1" the fnet file

what will you be looking for in fnet file?

the items that are in pca file needs to be located in fnet file and marked with "1" on the

designated column.

how can you do the look up:

do not copy description cell from pca and look for in fnet file, read the item description

and use the lok up feature in fnet file and that will list you the related items and

manually you need to narrow it down to the exact items.

how about if the item is not listed or can not find it in fnet file?

that is possible if that is the case you need to mark it as "NA" meaning "not applicable"

the pca file has 1400 lines or items and fnet file has 7000 items, so we are looking for

1400 items inside 7000 items file.

what can mislead you in the look up process?

items are very similar and have very small differences:

ex: same item can be in different sizes like 1.7 oz 2.0 oz 3.4 oz and etc, different type

example: same item can be EDT (eau de toilette) or EDP (eau de perfume) meaning perfume is

more concentrated than toilette water and costs more

what is the item listed in pca is not in fnet?

you can disregard it and mark it in pca file under the "SKU" as "NL" meaning "not listed"

Please bid accordingly.

Thank you for reading this

Regards

eg

PS: the budget for this project is $55.00 flat

source and target excel files attached

データ入力 情報処理 エクセル

プロジェクトID: #1383044

プロジェクトについて

20個の提案 リモートプロジェクト アクティブ Jan 13, 2012

20人のフリーランサーが、平均$47 で、この仕事に入札しています。

vserv

Hi, dedicated worker. Would be very happy to work for you. Thanks

$55 USD 2日以内
(62件のレビュー)
5.8
inzaghi2006

Hi, This is a simple task, I can finish it quickly. please contact me

$45 USD 1日以内
(24件のレビュー)
5.1
DrTech76

Hi! I am sending you some thought of mine about the task. Regards

$50 USD 1日以内
(27件のレビュー)
4.7
karthik427

Hi,I have understood the project needs and attached a sample in the message box please check it.I will complete it on time with 100% results.

$55 USD 3日以内
(25件のレビュー)
4.6
ruchipuri

Please check PM.

$45 USD 2日以内
(9件のレビュー)
4.6
kulhanekd

I already started. I can have it complete same day you approve for me to complete it. I have 15 years exp in excel. Thanks Donna

$50 USD 1日以内
(12件のレビュー)
4.5
Shazk

Greetings, I have read & understood your project description carefully and had done few entries to show you as sample. Kindly check pm for details. Thanks

$55 USD 2日以内
(6件のレビュー)
3.8
khanshabb

interested to work on your project check pm

$55 USD 3日以内
(2件のレビュー)
3.1
saadrathore

Hello Sir I read all the description and understand what to do. I will complete this work as soon as possible but at the most in 3 days. I also accept your rate of $55 for the whole project. Best Regards Saad Ra もっと

$55 USD 3日以内
(3件のレビュー)
2.2
Suregirl

Please see PMB

$50 USD 1日以内
(レビュー1件)
2.2
KVICC

Hello, We can do this for you ! Pls see PMB. Thanks, KVICC

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

Sir, Please see my professional cv. Regards George Kordosis

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

hello i want to make this for you i'm ready

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

Give me the opportunity and you will never regret since you will receive value for your money and quality out put.

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

Hi, I would like to offer my service for this job. I am an engineer by profession and I have database searching/ comparison/entry experience in my work. I can use Microsoft Excel application well. I am available もっと

$50 USD 10日以内
(0件のレビュー)
0.0
weixing04

Hello Sir I understand what's your project. Already I started your work. Soon I will send you my result. thanks.

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

I assure u I shall provide u quality work and in given deadline time. I have a very efficient team for your work.

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

Quality of work assured.

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

i will be happy to get

$50 USD 3日以内
(0件のレビュー)
0.0
NafeesIdrees

I am very proficient in Excel & I hopeful that I will do everything in Excel, also I'm working in data entry and accounting (Maintaining Company’s Accounts) field for many years. I hope that will be completed in defau もっと

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