Data Mining between two excel files
$30-250 USD
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
Project ID: #1383044
About the project
20 freelancers are bidding on average $47 for this job
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.
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
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
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
Give me the opportunity and you will never regret since you will receive value for your money and quality out put.
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
Hello Sir I understand what's your project. Already I started your work. Soon I will send you my result. thanks.
I assure u I shall provide u quality work and in given deadline time. I have a very efficient team for your work.
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