Data Mining between two excel files

In Progress Posted Jan 11, 2012 Paid on delivery
In Progress Paid on delivery

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

Data Entry Data Processing Excel

Project ID: #1383044

About the project

20 proposals Remote project Active Jan 13, 2012

20 freelancers are bidding on average $47 for this job

vserv

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

$55 USD in 2 days
(62 Reviews)
5.8
inzaghi2006

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

$45 USD in 1 day
(24 Reviews)
5.1
DrTech76

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

$50 USD in 1 day
(27 Reviews)
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 in 3 days
(25 Reviews)
4.6
ruchipuri

Please check PM.

$45 USD in 2 days
(9 Reviews)
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 in 1 day
(12 Reviews)
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 in 2 days
(6 Reviews)
3.8
khanshabb

interested to work on your project check pm

$55 USD in 3 days
(2 Reviews)
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 More

$55 USD in 3 days
(3 Reviews)
2.2
Suregirl

Please see PMB

$50 USD in 1 day
(1 Review)
2.2
KVICC

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

$50 USD in 5 days
(0 Reviews)
0.0
gkord

Sir, Please see my professional cv. Regards George Kordosis

$50 USD in 15 days
(0 Reviews)
0.0
krank2

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

$45 USD in 5 days
(0 Reviews)
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 in 10 days
(0 Reviews)
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 More

$50 USD in 10 days
(0 Reviews)
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 in 1 day
(0 Reviews)
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 in 1 day
(0 Reviews)
0.0
deepalim

Quality of work assured.

$100 USD in 5 days
(0 Reviews)
0.0
kevipatil

i will be happy to get

$50 USD in 3 days
(0 Reviews)
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 More

$30 USD in 5 days
(0 Reviews)
0.0