Find Jobs
Hire Freelancers

Do some Excel Work

$30-250 AUD

Terminado
Publicado hace más de 7 años

$30-250 AUD

Pagado a la entrega
Hello, I am wanting to create an excel macro (VBA) that allows us to determine: a) the distance between 2 addresses (in km's) b) the time to travel (in minutes) for up to 100 addresses at a given time. It will need to link with the google maps API. It should be reasonably easy as I have found some code that can be used here: [login to view URL] I estimate that it should not take more than a few hours. What we need is: - the excel VBA code ready - instructructions on integrating it with google maps - an ability for us to copy and paste addresses next to each other (columns a and b), have a person's name (in column c) and have the next cell show travel distance (column d) and travel time (column e) - we will use this to determine if we pay a travel allowance. As part of this, we need to calculate how much will be paid as an initial formula of (travel distance - 30km) x 0.6 (but we want to be able to change the variables of 30 km and 0.6) - an ability to consolidate how much we need to pay per person (referencing column c) as a single number We are looking a quick turnaround time on this so I will make a decision to the right person reasonably quickly. What I need from you is: a) how long you think it will take to turn this around b) cost Regards
ID del proyecto: 11186660

Información sobre el proyecto

9 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
Adjudicado a:
Avatar del usuario
Hi, I have worked with this kind of calculations using VBA in Excel integrated with google api. I can deliver the solution right away. I just need less than an hour to have your request done.
$50 AUD en 0 día
5,0 (11 comentarios)
3,2
3,2
9 freelancers están ofertando un promedio de $122 AUD por este trabajo
Avatar del usuario
Yes we can use that code but it depends how you will input your addresses. Are you gonna select from dropdowns (which I recommend) Or just in some address text (which is hard to render) Anyway, we can discuss..
$263 AUD en 3 días
5,0 (99 comentarios)
6,5
6,5
Avatar del usuario
I can create simple macro which you can use in your formulas (one for the distance and another one for the time): something like '=GetDistance("A1") - 30' etc I can complete it in 2-4 hours and I can offer you best price here. Thanks. Roman
$94 AUD en 1 día
4,9 (203 comentarios)
6,4
6,4
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
$98 AUD en 1 día
4,7 (99 comentarios)
6,2
6,2
Avatar del usuario
Dear Project poster, I have 5 years of experience. I have good knowledge of excel. Price is not a concern for me. I am looking for projects. Let me give an opportunity to work. We can talk further when you message me.
$30 AUD en 1 día
4,8 (20 comentarios)
3,8
3,8
Avatar del usuario
Hi there! I have read what you exactly need, however I would like to ask you a few questions. I wouldn't call myself a master but I do work smart and do not rest until I get the job done. Please feel free to ping me anytime so we can have a detailed discussion.
$222 AUD en 1 día
5,0 (2 comentarios)
2,9
2,9
Avatar del usuario
COMPLETED THE EXCEL, CAN SEND YOU SNAPSHOT WHEN AVAILABLE Have good expertise in Excel Macros, automation. My skills below - I have good skills in Excel automation and used extensively the macros/VBA to automate: - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells,, data camparision using formulas, lookups and bringing up summaries. - With summary data plotting graphs, bringing pivot tables etc. - Outlook autoamtion - Peforming different actions other that using the existing rules, updating calendars based on logic. - MS Access - Expert in designing table, user input forms and also reporting from data. - Excel to MS access data porting and conversion and designing new system for use. - Please review my portfolio on recent projects completed.
$30 AUD en 0 día
4,9 (9 comentarios)
2,8
2,8

Sobre este cliente

Bandera de AUSTRALIA
Flemington, Australia
5,0
5
Forma de pago verificada
Miembro desde feb 3, 2011

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.