Project Detail

Excel Expert Needed (Repost)

Excel Expert Needed (Repost) is project number 116216
posted at Freelancer.com. Click here to post your own project.

| More

Status:

Selected Providers: best4best

Budget: $30-100

Created: 12/30/2006 at 13:09 EST

Bid Count: 17

Average Bid:
$ 57

02/03/2007 at 13:09 EST

Project Creator: Ashtonhome
Employer Rating: 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 (14 reviews)

Description

I have a 7000+ product csv excel file that contains product info from various(5+) dropshippers. Many of the products have been discontinued and need to be removed from the site. My dropshippers provide current csv excel files. I need to reconcile the information without losing the info in the current csv excel file being used. Project consists of editing the current csv file to edit items no longer available and also creating a second csv file with the items that are not currently on the site and need to be added. Please see attached files as a reference. The 2006 file has the products currently on the site, the 2007 file is the file with currently available items. There is one item in common.. the code. (Note in examples that the code in the 2006 file has three letters in front of it... very easy to remove to reconcile the files and then needs to be added back.) For items no longer available, need to change Orderable to "No" and replace the headline with "Discontinued please make another selection". I am sure this can easily be done quickly with an excel formula. Bid is to do the work and provide me with the formula / teach me how to update. Bid is to reconcile all data files. I have already divided up the main data file into subsections based on dropshipper and downloaded the new dropship files... eliminating products I don't need.

1. Reconcile all data files with current inventory by changing Orderable to "No" and replacing Headline with "Discontinued..."

2. Give me the formula / teach me to reconcile two excel documents with one thing in common (code).

3. Create second file for each dropshipper with products that need to be added.

Will be working with FOUR dropshippers and files. Not all products from dropshippers are on site or will be added... just camping related products.

Please only bid if you can do the work. I am having to repost as previous bidders did not accept the job in a timely manner.

Additional files submitted:
cwr2006sample.xls
cwr2007sample.txt

Report Violation

Job Type

See more: bid, code, csv, data, easy, edit, editing, excel, excel expert, excel expert needed, expert, file, inventory, job, make, product, project, remove, site, work

Messages Posted:0

If you are the project creator or one of the bidders Log In for more options

PMB

100

7 days

12-30-2006 18:06 EST

9.8825/10
(383 reviews)

Hi sir, I'm an excel expert, I can teach you the formula and I can do the work for you. I can start right now. My bid is only $100.00 for 7 days. I'm detailed oriented. Quality work and accuracy in a timely manner is assured. Best regards.

asaikiran1979

1 day

01-01-2007 05:17 EST

9.1071/10
(56 reviews)

Hi, I can complete ASAP. Pls check PM ASAP. Thanks, Sai Kiran

bsoist

100

2 days

12-31-2006 22:19 EST

9.5349/10
(43 reviews)

Please see PMB for details.

best4best

1 day

12-31-2006 15:47 EST

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(34 reviews)

Hi, I have gone through both the files and read carefully the description. I had previously made a bid for this project, but unfortunately not the winner. I can definitely do this job. It is easy for me. Instead I can add some more features in the sheet , if you want. Please consider positively. I have done very complex calculations and have good IQ level and logics to make the work easy. I will provide and explain all the formulas and functions used in this project. Thanks

phaseonemedia

0 days

12-30-2006 13:58 EST

9.5926/10
(27 reviews)

I can write you a script that will update your list automatically everyday. I can even have it all automated. Ive done it many times before, so long as your dropshippers provide you with live xml or csv feeds.

ajay192

1 day

12-31-2006 23:29 EST

9.3333/10
(6 reviews)

I suspect you are having to repost your project several times since the price band selected for this class of project in perhaps not adequate. Please see PMB for details of our proposal. Ajay

cheungkc

3 days

12-30-2006 16:27 EST

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(5 reviews)

We will be glad to assist please

omnisite

3 days

12-30-2006 13:28 EST

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(4 reviews)

Please see PMB

ramvinod

5 days

12-31-2006 00:55 EST

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(1 reviews)

we can do this assignment

prakashpatodia

100

4 days

12-31-2006 01:30 EST

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(1 reviews)

Pls see PM

anupamsinghi

2 days

12-31-2006 07:28 EST

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(1 reviews)

Hi, I am very keen to do your project. I have understood your project and I would be able to provide you required data. I will also provide you step by step process and formula to reconcilation of spreadsheet. looking forward for your work.

Alamo2000

3 days

12-30-2006 16:26 EST

(No Feedback Yet)

Could definitely do this

hundredrabh

2 days

12-30-2006 18:29 EST

(No Feedback Yet)

Hi, real simple. can be done. regards

anuramn

4 days

12-31-2006 01:51 EST

(No Feedback Yet)

I can accomplish the task that you have asked for. I've good work experience and knowledge in MS Excel.

sunil2007

10 days

01-01-2007 03:45 EST

(No Feedback Yet)

Get it done accuretely.pls let me know if you are intrested. Thanks.

dhawalupadhye

4 days

01-01-2007 05:21 EST

(No Feedback Yet)

i able to do the work in four days i am expert to do this work before and i had an idea to this work bysimplest way if you are intersted .i do the job....

lakshmaiahv1108

7 days

01-01-2007 06:55 EST

(No Feedback Yet)

Hi, I can do this job. Thanks Lakshmaiah

Bid on this Project

WHAT IS FREELANCER.COM?

Freelancer.com is a global outsourcing solution and freelance jobs website. Here you can find freelance coders, writers, programmers, designers, marketers and more. You can also outsource projects and save a lot of money in the process. Getting the best web design, professional programming, custom writing or affordable marketing has never been easier!

We have thousands of satisfied clients from every corner of the world. Would you like to outsource your next project? Would you like to find freelance jobs and make money online? Just sign up to get started! Outsourcing jobs is the process of hiring an outside company or individual to complete your projects. We have created a safe environment for both service buyers and service providers via our secure payment system. You outsource the project and don't release any money until you're satisfied! Try outsourcing for free today! Don't forget to bookmark our homepage for your next project or job.