Edit Spreadsheet Database

Đã Đóng

Mô tả

Hi,

We own a spreadsheet car database, I need it modified and formatted as follows:

I will categorize the jobs in 2 sections, one that can be automatized through Excel tools and formulas, and the other where manual labor is required:

The database has a total of 15000 rows.

A. Automated work:

1. Extract from the column “Model (platform) years” two columns:

a. “Model (platform)” will contain only the model name and the platform / generation (where available);

b. “Years” will contain the year period in the format xxxx-xxxx, where not available xxxx-____. Where the information is not available in column “Model (platform) years”, take the years from the columns “Main model”, if available.

2. Extract from the column "Model Name" only the engine type in column “Engine”. Basically, all is needed is to delete the model name.

Exceptions:

- BMW - it does not include the model name, so “Engine” will be exactly as “Model Name”.

- Mercedes - it does not include the model name, so “Engine” will be exactly as “Model Name”.

3. Concatenate and populate the column “Engine (Displacement, PS / KW)” the engine type (column “Engine”), displacement in cm3 (from the column “Displacement (cm³)”), PS (column “Power (PS)”), kW (this will need to be transformed from PS: 1 PS = [url removed, login to view] kW). Transformation in kW must be rounded (no decimals).

4. Remove all Vauxhall text from Opel / Vauxhall;

5. Replace all special characters: é > e, ó > o, etc.;

6. Replace the abbreviations from the column “Body Type” with the full name of the body type. The body type abbreviations can be found in the sheet “Legend”.

B. Manual work:

1. Update the column “Manufacturer Category” with the following data as described:

a. VAG - The Volkswagen group: Volkswagen, Audi, Skoda, Seat, Porsche

b. Mercedes - Mercedes and Smart;

c. PSA - Peugeot, Citroen;

d. Asia - All Asian makers without Hyundai and Kia;

e. Alfa Fiat - Alfa Romeo, Fiat, Lancia

f. Ford - Ford and Mazda

g. GM - Opel, Daewoo, Chevrolet, SAAB;

h. Hyundai Kia - Hyundai and Kia;

i. BMW - BMW, Mini and Rolls Royce;

j. Renault - Renault, Nissan, Dacia;

k. Croco - All the rest.

2. Line 830 to 896, separate Audi A6 from Audi 100.

Here is a link to a sample screenshot:

[url removed, login to view]

Please type 222090 if you are up for this job.

Thank you!

Kỹ năng: Nhập liệu, Xử lí dữ liệu, Excel

Xem thêm: database spreadsheet drupal, business card database spreadsheet excel, bid database spreadsheet, excel database spreadsheet template, inventory database spreadsheet, database spreadsheet products populate database, product database spreadsheet ecommerce, product database spreadsheet, database spreadsheet, copy paste database spreadsheet, wordpress plugin database member edit profile address, macros work excel internet, combine database spreadsheet, macro dont work excel 2000, freelance work excel vba, track work excel, php mysql database insert edit delete, macros written excel 2000 work excel 2007, contract work excel access, database spreadsheet work pricing, excel 2000 macros work excel 2007, article submission work excel, show project work excel, work excel file, contract work excel

Mã Dự Án: #13112336

Đã trao cho:

sajibdigital

222090 Hi, I am interested to work in your project. Please contact me on chat for more discussion, I am waiting for your response. You may visit my profile for more info.-https://www.freelancer.com/u/sajibdigita Thêm

$100 USD trong 3 ngày
(22 Đánh Giá)
4.5

73 freelancer đang chào giá trung bình $158 cho công việc này

jubair7

222090 Experienced FREELANCER HERE to work for your project. Let's discuss more and finalize the project and cost. Feel free to ask me questions, if any. I look forward to work with you. Have a good day and st Thêm

$200 USD trong 3 ngày
(287 Đánh Giá)
7.7
$300 USD trong 3 ngày
(166 Đánh Giá)
7.0
ponnarasiBabu

222090, I read and understood your requirements of both automation and manual process and can start the work asap. So i hope you would open a PM to discuss about the work . Regards, Ponsi

$250 USD trong 5 ngày
(315 Đánh Giá)
7.1
sobujprantor

HI I am ready to start the work.i can do this work easily.so if you are interested to me message me.Thanks.

$155 USD trong 3 ngày
(185 Đánh Giá)
7.0
diamond247

222090 I have gone through the project details, and understand what you are trying to achieve. We have completed a number of similar a projects to yours. And we are experienced critical data research. ## A littl Thêm

$150 USD trong 3 ngày
(192 Đánh Giá)
6.9
rangacbe

222090 Hi, Thanks for the opportunity to bid on this project. I have done such data gathering and research in the past for various clients so that I will provide good service. Regards, Jai

$95 USD trong 7 ngày
(260 Đánh Giá)
6.7
dpune

Hi, I have more than 14 years of Excel/VBA exp and I am expert in this kind of work. Let us discuss more details so that I can estimate cost and time better. I have completed more than 300 projects. Plea Thêm

$100 USD trong 3 ngày
(163 Đánh Giá)
6.4
rabiasagi

222090 - hi..i would love to do some sample work.. i work for 7 days a week.. lets talk? regards Rabia

$555 USD trong 30 ngày
(79 Đánh Giá)
6.3
cowboy14

222090 Hello sir, Consider it as done. Excel expert here. ABle to change / extract / edit all those changes on your car database file within next few hours. Able to start right now. Waiting for your reply. Tha Thêm

$80 USD trong 0 ngày
(92 Đánh Giá)
6.1
nagybatonyi

Hi, I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. In my approach you'll have opportunity to consult details Thêm

$88 USD trong 1 ngày
(59 Đánh Giá)
5.7
sonarkaushik

Sir,      I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you. Thêm

$111 USD trong 4 ngày
(92 Đánh Giá)
6.1
dynamitewebsol

222090 Hello, I read your requirements and understand very-well and ready to start work from now. Thank you

$250 USD trong 7 ngày
(26 Đánh Giá)
5.6
ksriniravi

222090. I am up for this job.I have reviewed the snapshot you have shared. Greetings! I have 17+ years experience in using Excel as part of my daily work life. In the process I have implemented lot of automation Thêm

$120 USD trong 3 ngày
(44 Đánh Giá)
5.2
standarditech

222090 Hi, I have taken a deep look on this project, and I am sure that we can work together. I have experienced in these kind of task. Please give me a chance to serve you and i will never let you down. I will compl Thêm

$100 USD trong 2 ngày
(74 Đánh Giá)
4.8
VnBestSolutions

Dear Sir. I had read your descriptions about project. Kindly give me a chance, i would like to discuss more about project and sure everything clear. Please drop me messages when you have free time. Any your queries and Thêm

$155 USD trong 3 ngày
(10 Đánh Giá)
4.0
$40 USD trong 1 ngày
(12 Đánh Giá)
3.9
DelowarHossen

Dear Sir, I read you post very carefully and very much interested to work your project. I am 100% confidence that I am perfect for this job because i already completed relevant project before that you can see my portfo Thêm

$250 USD trong 7 ngày
(5 Đánh Giá)
4.0
nimesha1994

222090 Hi, I'm very interested to do your project. I have great knowledge on about your project. I have already read your description and I feel like I would be a great fit for the project. I can start your pro Thêm

$150 USD trong 3 ngày
(6 Đánh Giá)
3.7
romanapanovich

222090 Hello As I understood You need result - not script I am developer and I can do a webscript that will automatize following tasks About 2nd part - manual working. I think I can do it AUTOMATIC but NOT EXCEL to Thêm

$120 USD trong 5 ngày
(1 Đánh Giá)
3.4
Peterpay

i can build this for you as soon as possible, so i can work out this format change on a simple and reliable wya for you. please provide more info to work this out for you asap.

$155 USD trong 1 ngày
(8 Đánh Giá)
3.7