Closed

Data Entry of Air Conditioners Specs in Excel Sheet

This project was awarded to tj1368 for $100 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Project Budget
N/A
Total Bids
72
Project Description

I have 506 air conditioner models with ASIN codes imported from Amazon on the Excel sheet. Than I have 85 columns of specification data, like for example Model, Cooling Power, Room Size, Energy Efficiency Ratio, Air Flow Volume, Maximum Noise Level, Dehumidifier Capacity, Refrigerant Type, and so on. Majority of the data is already entered in the sheet (around 64%, all data fields [url removed, login to view], already filed 27469, still blank 15541), but the rest is missing.
I am looking for a freelancer, who will surf the web and try to fill the table with the missing data.

I have colored the columns so that it is easier to navigate and fill the data in the table. There are some data that absolutely MUST be collected no matter of the type of AC, and there are some data that must be collected only for a specific type of AC.

Freelancer should search for the data in the following order/sources (Important!!!):
[url removed, login to view] original website (this is the most reliable source, since many of third party websites do not operate with the correct data!!!)
2.Trust-worsted online shops and content related websites (like [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], and others)
[url removed, login to view] party websites.
[url removed, login to view] manufacturer by email and try to get the data this way.

Most of the data is easy to find on manufacturers websites, and you only have to re-type it in the Excel sheet. But be aware, that not all manufacturers clearly report specifications of their models, it is difficult to find some data and you should surf the web until the data is found. I am aware that maybe some data will not be found and you should try to get the it directly from the manufacturer by e-mail. If even this will give no result, you can mark it as not possible to get it and leave it blank.

It is very important, that only true data will be entered in the sheet!!! Do not consider this job as easy, and do not even think of typing in some imaginary data just to fill the table and finish the project as soon as possible. When the project will be finished, I will randomly pick every 10th model and check for the data if everything is entered, as it should be. Also, you have to provide in the last column of the Excel sheet, which is the primary source of the collected data (it is best for you that you write in also secondary source and so on...).

IMPORTANT: If I found one single fake data in the specification, I am not going to pay you for the job! Do not get me wrong, but it is better to leave the data blank as to fill in wrong data.

Since it is important for me to populate the sheet with as much data as it is available, you can provide us the bid for the whole project. What I will do is to calculate the price per data then and as much data as you will provide, that much you will be paid. Fair enough?

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online