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 Free Trial For New Buyers
 

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/1010/1010/1010/1010/1010/1010/1010/1010/1010/10 (14 reviews)

Bid On This Project
 

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

Messages Posted:0 View project clarification board Post message on project clarification board

Bid On This Project
 

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

 

100

7 days

12-30-2006 18:06 EST

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.

help

 

35

1 day

01-01-2007 05:17 EST

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

help

 

100

2 days

12-31-2006 22:19 EST

Please see PMB for details.

help

 

30

1 day

12-31-2006 15:47 EST

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

help

 

50

0 days

12-30-2006 13:58 EST

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.

help

 

56

1 day

12-31-2006 23:29 EST

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

help

 

50

3 days

12-30-2006 16:27 EST

We will be glad to assist please

help

 

50

3 days

12-30-2006 13:28 EST

Please see PMB

help

 

50

5 days

12-31-2006 00:55 EST

we can do this assignment

help

 

100

4 days

12-31-2006 01:30 EST

Pls see PM

help

 

50

2 days

12-31-2006 07:28 EST

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.

help

 

40

3 days

12-30-2006 16:26 EST

(No Feedback Yet)

Could definitely do this

help

 

30

2 days

12-30-2006 18:29 EST

(No Feedback Yet)

Hi, real simple. can be done. regards

help

 

60

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.

help

 

40

10 days

01-01-2007 03:45 EST

(No Feedback Yet)

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

help

 

50

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....

help

 

80

7 days

01-01-2007 06:55 EST

(No Feedback Yet)

Hi, I can do this job. Thanks Lakshmaiah

help


    Bid on this Project