Find Jobs
Hire Freelancers

Do some Excel Work

$30-250 AUD

Completed
Posted almost 8 years ago

$30-250 AUD

Paid on delivery
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
Project ID: 11186660

About the project

9 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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 in 0 day
5.0 (11 reviews)
3.2
3.2
9 freelancers are bidding on average $122 AUD for this job
User Avatar
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 in 3 days
5.0 (99 reviews)
6.5
6.5
User Avatar
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 in 1 day
4.9 (203 reviews)
6.4
6.4
User Avatar
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 in 1 day
4.7 (99 reviews)
6.2
6.2
User Avatar
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 in 1 day
4.8 (20 reviews)
3.8
3.8
User Avatar
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 in 1 day
5.0 (2 reviews)
2.9
2.9
User Avatar
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 in 0 day
4.9 (9 reviews)
2.8
2.8

About the client

Flag of AUSTRALIA
Flemington, Australia
5.0
5
Payment method verified
Member since Feb 3, 2011

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.