Find Jobs
Hire Freelancers

Do some Excel Work

£20-250 GBP

Cerrado
Publicado hace casi 10 años

£20-250 GBP

Pagado a la entrega
I have 2 excel files. One is of specific addresses I am interested in and the other one is a bigger master file of addresses and phone numbers. \r\n\r\n\r\n I need to append the phone numbers to the specific addresses I require. \r\n\r\nNot all of the phone numbers will be available in the master file and the addresses are in slightly different formats but with some good excel skills they could be matched up.\r\n\r\nEdit: Thanks for responses so far. I should say that i havent bought the whole master file yet but i wanted to ensure that what i was hoping to do was possible. I believe the differences in the addresses will create issues so would like to test the theory first and for someone to explain how they intend to do it as if it is not done correctly then it will result in a lower \'hit rate\' and its the hit rate I need to be as high as possible This wil in part be down to the completeness of the master file but also on the strategy someone uses to match/append the phone numbers.\r\n\r\nFor example - see the 2 files attached. This is not the actual \'master file\' but a smaller sample so not many numbers will match up but it will give an idea of what will be required. \r\n\r\nSorry to require a test first but the master file will cost several hundred pounds so i need to be sure what i need can be done\r\n\r\nthanks!
ID del proyecto: 5857646

Información sobre el proyecto

43 propuestas
Proyecto remoto
Activo hace 10 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
43 freelancers están ofertando un promedio de £93 GBP por este trabajo
Avatar del usuario
Hello, I have read and understood the project. I can match up the phone numbers with specific addresses file. About me: I am working as individual at Freelancer and I have vast experience of data entry, Research, web scraping & copy/paste projects as I am working from past 10 years in data processing field. I will be very happy if you give us an opportunity work on your project. providing accuracy is my priority. Please contact. Thanks, Swapnil
£20 GBP en 1 día
5,0 (329 comentarios)
8,0
8,0
Avatar del usuario
Hi, your 5-star excel and vba coding (macro) expert is ready to help your project. pls check my profile and feedbacks first to have some idea about the quality of my work... I had many excel macro tasks, all achieved with 5/5 rating...I read your project descriptions, I reviewed your templates as well...I exactly got what you need and ready to go ahead if you wish to proceed with a top-rated and reliable partner here...I bid a very competitive amount for you..kindly note that I only deliver best quality at a reasonable price...awaiting your (+) reply to start....regards,
£73 GBP en 3 días
5,0 (333 comentarios)
8,1
8,1
Avatar del usuario
Hello, I am top excel developer on this forum with 200+ five star reviews and with a completion rate of 90%. I have understood your requirement and I am sure I can implement this. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.
£80 GBP en 0 día
4,9 (335 comentarios)
7,7
7,7
Avatar del usuario
Dear, I alredy coded a function that I called "score" which I used to make a match between columns that are not really the same. So it calculates the similarity between 2 fields and generate a score. So the higher score is the more probably correct match. The calculation is based on the fact that I split the address into words and compare the words with the other fields. So no problem if they are not in the same order. Can talk to you more if you start a chat. Thanks
£42 GBP en 3 días
4,9 (309 comentarios)
7,8
7,8
Avatar del usuario
Sir I'm expert on Data Entry and Product Upload and Excel. I have done many project like this . I will give you within time and best service. Looking forward working with you. I'm ready to start now . Thanks
£50 GBP en 1 día
4,9 (335 comentarios)
7,2
7,2
Avatar del usuario
I will really love to do this job for you. I have a strategy to match them up. The best strategy to use is to match the postcodes and address, in this case the most probable one is address line 1. Those are the 2 common ones i can use to match. In "BL1 Append data", I need to have column J show the value of "Bolton Med size business data(geoff)" column I (telephone), IF the values of A and D (on "BL1 Append data") match the values of D and H (on "Bolton Med size business data(geoff)"). If this is the understanding then the rest is just to put in the formula to do the match up. It's simple. I have tried it with the sample so be rest assured it will work. Looking forward to your reply Thanks Claudia
£111 GBP en 1 día
4,9 (86 comentarios)
6,9
6,9
Avatar del usuario
Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality output. I am an excel/access VBA automation professional having 7+ years of experience and can do it with the required quality. Lets discuss more online on chat. Thanks, Abhinav
£49 GBP en 0 día
4,9 (167 comentarios)
6,5
6,5
Avatar del usuario
Hi, I can do this for you. Please send a massage in the PMB for details.......Best Regards flashsaiful
£142 GBP en 2 días
4,9 (167 comentarios)
6,7
6,7
Avatar del usuario
Yes I can, and I will help you if you pick me for your project. Check my profile, see my reviews and award me now. Thanks, Tom
£75 GBP en 3 días
4,9 (34 comentarios)
5,3
5,3
Avatar del usuario
Hi, My name is Dan. I am an expert in excel and such advanced lookup and match functions. I have reviewed your file and understood some logic which I can work with to get the accurate result of phone number. Please message me so that we can discuss and proceed further, Thanks ! Regards Dan
£44 GBP en 1 día
5,0 (11 comentarios)
4,6
4,6
Avatar del usuario
Dear PatRoach01, I think the strategy is to use script to look for key address words as human would. Excel is not powerful enough to do lookup of such inconsistencies. Other than wrong columns, uppercase (easy to solve), your data have problems such as "UNIT OF3." I will show you that my approach should yield the highest hits. 1. Correct the columns. Currently, the specific address file is mixing up Address3, Address4, and Post code (town info in wrong column sometimes). This can be easily done by working the columns backward. 2. Concatenate Address1+Address2+Address3 and AddressLIne1+AddressLIne2+Locality. 3. Eliminate common words, such as Street, Road, Unit, and duplicates, etc. Set to lower case. Now we have "cleaned" and relevant working address phrases A1s and A2s to compare. 5. Now the tough part. Use script to start from each A1. For each word, look into all of A2, filter by the same Post Code (targets). For each word it finds, score 1 point. Divide points by number of words in A1 for accuracy. Rank all "target" scores for this A1. Accept the top score, but only if score is >40% (top ranking, plus at least 2/5 words match). We can change this threshold. I've worked with voter's rolls checking for possible frauds, errors, and duplication, as well as Web scripts. I'm a financial analyst strong in Excel formula, but I think Excel alone is inadequate in this case. I say 5 days to ensure enough time for quality control. Thanks for the opportunity, Regards, Jason
£100 GBP en 5 días
5,0 (9 comentarios)
4,7
4,7
Avatar del usuario
i have 14 years of excel experience. i knew lot of formulas. i can do it with formula in no time. will u please share the sample data to view ill do it using vlookup lets discuss it in detail
£20 GBP en 0 día
5,0 (19 comentarios)
4,2
4,2
Avatar del usuario
Pat, As I work from home in the East Midlands, communication will be straightforward. I have constructed several similar comparators, and would be delighted to work on this for you, I can work under a Confidentiality and Non-Disclosure Agreement if required, and start as soon as you pay the fee into the site. I designed dashboards, reports and interactive spreadsheets and managed databases for twenty years at a leading multinational. Now work across five freelance sites with good reviews from international clients who have utilised my expertise in VBA Coding, Formulae and Conditional Formatting. My approach to matching the two files will be to "tidy and tabulate" the address structure on each one first, and then use Index and Match to run through each parameter and "pull out" those matches where telephone numbers exist. I normally provide samples to let you judge my Excel skill for yourself, but you made this a "restricted" project. I can't send you an attachment unless you send me a Private Message first. And please note the samples will not use the attachments you provided, because I never "give work away". Hope you find this of interest and look forward to hearing from you Bob Allen-Turl Bob Allen-Turl
£123 GBP en 2 días
4,6 (12 comentarios)
4,6
4,6
Avatar del usuario
I have skill work with excel program,i can build system with excel for make simply report with nice view, please check my portfolio, and I am graduated in accounting courses. In Microsoft Excel formulas I am confident in using Vlookup, If, And, Or, Sumif(s), Countif(s), and how to combine multiple formulas and use Sort, Filters, Data Validation, Conditional Formatting, Pivot tables. So I very confidence can give you what you want as soon as possible, I can start my work in any time.
£28 GBP en 3 días
4,7 (43 comentarios)
4,6
4,6
Avatar del usuario
Hi, I could do this for you, but we need to discuss more on the way how we do it. First I realize that your address file is not correctly parsed (you can see the postcode is appear on column D,E and F. So do you have a raw version of the address or we need to work with that file? Second, do you only have the exact address file (921 lines) or this file could be change in the future? Third, could you give me an example of a match between your two file? Regards,
£250 GBP en 3 días
5,0 (6 comentarios)
4,0
4,0
Avatar del usuario
* OM SAI RAM * Respected Sir/Mam, I have read the project completely and I have understood my responsibilities (If awarded) clearly. To tell more about myself, I am dedicated and sincere in working on the projects awarded to me here. I can understand the urgency of the employers and work to finish the project in time. Moreover, As you can see my profile, I am quite a new freelancer. I love to keep my reputation up to the mark. If you wish to award the project to me trusting my abilities, you are always welcome to contact me anytime of the day. Let us have a chat on the project details before I take the responsibilities, As this will help me understand the project clearly. So that We won't be in a situation where our time won't be wasted later. Lastly, I would like to tell that I stand by my words and I assure you that your expectations will be satisfied completely by my work. You will be happy with my work at the end. As a request, I ask you kindly to offer me this project's responsibilities and pave me a path to stand out of the crowd in Freelancer. Thanks in advance. With regards, SathyaNarayana Singh. J.
£50 GBP en 3 días
4,9 (9 comentarios)
3,5
3,5
Avatar del usuario
Hello, I made ​​the connection between the two files you sent. There are 4 entries which match. If you accept my offer, I am ready to do the work. Thank you.
£23 GBP en 0 día
5,0 (4 comentarios)
3,1
3,1
Avatar del usuario
I am from china,and familar with excel /vba script to do any data input/output/analysize/combine/chart etc. would you like to let me have a try? thank you very much.
£150 GBP en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hello, I am interested to work for this project and I will provide you within or before 3 days . Of course, I know you could be in doubt about my real ability. It would be important for me to prove my ability through real project. I hope this project would be the first step in long term partnership with you. I await your favorable reply with interest. I feel confident my execution of this order will be to your complete satisfaction. I ready to start right now . Please feel free to ask any questions and we would be happy to assist you. Regards,
£142 GBP en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
£150 GBP en 3 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED KINGDOM
Bolton, United Kingdom
5,0
4
Forma de pago verificada
Miembro desde abr 25, 2014

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.