Find Jobs
Hire Freelancers

Cleanse data and lookup against database in Excel

£20-250 GBP

Cerrado
Publicado hace alrededor de 8 años

£20-250 GBP

Pagado a la entrega
See attachments for full instructions. Step 1 Verify whether the words entered in the columns of the "Data" tab appear in the corresponding columns in the "MVL" (database), and separate out any words that are not recognised terms in the MVL. Step 2 Look through the words that are not accepted and make a judgement whether the words are important or not, and take action. e.g. If the bodystyle in the data says "sedan" then this will not be recognised in the MVL as the MVL refers to this as "saloon". So this should be changed within the "Data" tab. e.g2. If the "Cars Type" says "1.9 JTDM 115" on the "Data" but the MVL only says "1.9 JTDM" then the term 115 can be removed. Step 3 Once a series of recognised terms is established then these should be treated like filters on the MVL. So the script should return the entries from the MVL which satisfy the filters in the relevant columns. There will usually be multiple lines returned for every line on the data sheet. Step 4 Check any entries that did not complete and establish why. I am not paying for the script - but I am paying for the service. I supply the raw data and you supply the results. Knowledge of car makes and models is preferable as some understanding is required. Generic bids will be ignored - provide specific bids that show understanding of the project. Also outline how you will achieve the results. Offer fixed price and timescale with an understanding of how long it will take you to complete. I will not accept add ons and people who make bids they cannot keep to will receive poor feedback scores. The initial project is for 1200 lines of data as in the file. If the project is successful, there is total 25000 lines of data for conversion, with possible ongoing work in the future - so it is important to establish a cost effective and efficient method to sort this data. NOTE TO FREELANCER THIS IS NOT AN ONGOING PROJECT - THIS PROJECT IS LIMITED TO THE DATA SHOWN ON THE ATTACHED FILE. Samples of work will be required before a bid is accepted.
ID del proyecto: 10223774

Información sobre el proyecto

25 propuestas
Proyecto remoto
Activo hace 8 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
25 freelancers están ofertando un promedio de £175 GBP por este trabajo
Avatar del usuario
Hi, I am interested to work on your project. I can verify the spreadsheet based on the instructions and provide you the formatted data. As the rules not completed automated using the script manual intervention is required to filter the data. I could not find the data sheet in the attachments. Could you please share the sample data sheet to have better understanding of the task? Based on the sample data I will revise my bid amount. Regards, Rajesh.
£100 GBP en 4 días
5,0 (52 comentarios)
6,6
6,6
Avatar del usuario
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 270 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
£100 GBP en 7 días
4,9 (157 comentarios)
6,5
6,5
Avatar del usuario
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 and will deliver flawless work. I am very much able to work on this. ***I am ready to start Waiting for further discussion.. with thanks and regards
£222 GBP en 5 días
4,6 (81 comentarios)
6,2
6,2
Avatar del usuario
Hi there, I’d like to be considered for your programmer position. I’m an Access/VBA developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, ADO, SQL including projects for start-up companies and small businesses For over the last 20 years I’ve worked in a variety of industries. I have a deep passion for coding and guarantee that all of developing is 100% original. I highly value professionalism and hold myself strictly accountable to represent my client’s brand. I aim to form a long-term working relationship. In my portfolio look at the screen of "Create sales and purchases database application". You will find the similarity.... Please, let me know what is needed to secure this bid! Thank you for your consideration. Zura
£150 GBP en 3 días
4,8 (38 comentarios)
5,8
5,8
Avatar del usuario
Pleasure to help you. Excel automation is my masterpiece in my accounting field. Feel free to message me to start the job. Thank you so much.
£100 GBP en 3 días
4,9 (75 comentarios)
5,7
5,7
Avatar del usuario
Hello, I have good Excel/VBA experience and can help you finish this task, but could you please provide the Excel file so I can understand your requirements?
£100 GBP en 5 días
4,9 (62 comentarios)
5,8
5,8
Avatar del usuario
Hello, I have been working as freelancer since last ~ 3 years,prior to this was working with a MNC as an Sr. Software Professional. The project is Product based development and integration of the product with various already existing Products and processes.. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applications -- Expert on C# using .NET framework using Visual Studio 2012 and 2013 -- Expert in ASP.NET,MVC -- Expert in VB.NET using VS2012/VS2013 -- WPF and Windows Forms Application I have experience in all the above areas and during my project work I have completed all of the above tasks. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. Delivering best & Customer satisfaction is the key for any individual and I always worked keeping these things during project execution. Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Abhinov
£150 GBP en 3 días
5,0 (55 comentarios)
5,5
5,5
Avatar del usuario
I have 6 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I have worked on extraction with websites like Amazon, Cellpex,Costco,Yellowpages,Yelp,etc., hope if awarded with this project I can make it best and better with maximum 100% accuracy and satisfaction, and the price is negotiable if required. please award me this project and contact me for further details
£150 GBP en 3 días
5,0 (60 comentarios)
5,1
5,1
Avatar del usuario
Let I handle this Project……………………………………………………………………………………………………………………….........................................................
£100 GBP en 3 días
4,8 (52 comentarios)
5,0
5,0
Avatar del usuario
I will complete all of your 1200 lines within a week. The price for the next 25000 lines will be 200 GBP as the task becomes easier after everything is established. I will not only cleanse the data but will provide you a tool using which even you can cleanse it. Looking forward for more discussion.
£95 GBP en 10 días
5,0 (22 comentarios)
4,2
4,2
Avatar del usuario
Hi. If you have your data in csv or excel files, I would be easily able to write a VBA macro or R script to provide you with the desired results. I have several years of data analysis (did a lot of in during my PhD research in applied maths :) ) Algorithms for matching data are pretty common, so there should be an efficient way of coding it. What is your time frame? What type of data file do you have? We can chat about the details.
£200 GBP en 3 días
5,0 (6 comentarios)
3,6
3,6
Avatar del usuario
I am an experienced data entry, processing and mining specialist with excellent knowledge in analyzing, transforming and presenting large volumes of data. I possess advanced knowledge of programming/scripting languages, excel and other supporting tools to accomplish my tasks in a timely manner. Additionally, I pay exceptional attention to the details and automate the process (wherever possible) to ensure 100% accuracy. For this assignment, I can write a script/program to automate the process
£222 GBP en 3 días
4,6 (3 comentarios)
2,5
2,5
Avatar del usuario
Hi, I have 6+ years experience with Excel (VBA) and databases. I can deliver your results in 3 days. Please send me a sample data (worksheet) to realy understand your needs. Glad to make a solution for you. Andre Leopoldino
£77 GBP en 3 días
5,0 (2 comentarios)
2,2
2,2
Avatar del usuario
I am a masters engineering student currently working as a research assistant at University of Houston where my primary responsibility is making presentations and reports for the Associate Dean of the college, so I guarantee you the best work. I have experience of publishing technical articles and making presentations for international conferences, so you work will be handled in the most professional way possible. I can show you some of the recent presentations I made so you can make an informed decision. I am a power user of Microsoft Office suite for more than six years and ensure quality work. Deadline will be set by you.
£111 GBP en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
i am an excel and DB expert. i hope u will prefer expertise over othrr to get the best result.
£238 GBP en 5 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Very familiar with this type of work as an engineer we have to standardize information on large projects all the time. You are basically looking to have the data standardized to your MVL tab and quanitified.
£150 GBP en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
The project is using the MVL export output file to lookup with vehicle details data file, recognize each field information. 1. Using the provided MLV Database export file (excel file format or cvs file format) to perform the vlookup action against with vehicle data file. 2. I will add 2 columns next with that need to validate data column, one column is record the vlookup result, one column for identify any variants found. Also the MVL Database export file will add no. of column to contains the vehicle data file source for reference. 3. If there is no variants found, accept the result and mark the record as clearly. 4. If there is a discrepancy records found, follow up, clarify with the vehicle data file. 5. If the discrepancy records need change, mark it down, need clarify with project employer to follow up, confirm it. I'm not familiar with vehicle field, but i can search related vehicle information from internet or if i still can't clarify by google, i will mark it down, clarify with the project owner. I've 8-years I.T Security Management & I.T Asset Management experience in Global I.T company. When i services in Asset Management team, i've an experience for perform the Hardware inventory checking. It is included the Wall-to-Wall physical on-site stock taking & perform the Hardware inventory recognition exercise with Hardware asset inventory and Wall-to-Wall taking result. Hardware & apps I'm using the Macbook pro & MS Office
£177 GBP en 5 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED KINGDOM
Chorley, United Kingdom
4,9
88
Forma de pago verificada
Miembro desde jul 19, 2013

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.