Find Jobs
Hire Freelancers

Excel Formatting and Distance

$30-250 USD

Completed
Posted over 10 years ago

$30-250 USD

Paid on delivery
My project is kind of hard to explain in details. So I am going to give the basic information to get you an idea of what I need. I attached a couple of file to have you visualize the work needed. There are 2 files attached. the 1st one named FILE1 is the raw data. I need that data to be polished and formatted to look like the data on the 2nd file Named FILE3 The data on the 2nd file is arranged by Times, Take and Return. Then I need the distances calculated using google Map with display of the route. I think it would be best if we spoke on the phone so i can better explain it.
Project ID: 4892429

About the project

20 proposals
Remote project
Active 11 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've been working as programmer for years and very familiar with both VBA and Google Map API. My proposed workflow is simple for user with two step: 1/ process the raw data - User click on a button to run a macro, e.g getRawData - the macro display a open file dialog for user to select the raw data file ([login to view URL]) - it clear the exiting or create a new destination worksheet and populate the according to requirements: name, pickup address, destination address, time etc. and a route information to display in the map. 2/ Display route for any row of the above mentioned worksheet: - select any row of the destination worksheet - click on the button: the route will be displayed on browser of user choice (chrome, firefox or ie, depend on the user's system) I can provide working file for MS office 2010 (Windows) and MS office 2011 (Mac OSX) Best regards, Cuong NH
$125 USD in 10 days
4.7 (23 reviews)
4.8
4.8
20 freelancers are bidding on average $118 USD for this job
User Avatar
Hi, To calculate the distance between two addresses requires a macro or function that is integrated with google maps I can help you with that as well as the formatting issue. Will try to finish it by tomorrow this time if you can award me the job tonight PST
$150 USD in 1 day
4.9 (240 reviews)
7.5
7.5
User Avatar
Hi Macfaye. I am ready to start on your project right away. I am highly proficient in VB and Excel and seems like a piece of cake to me. Just needs a formatting macro to format the first sheet. Lets talk and kick off. Regards
$140 USD in 2 days
5.0 (63 reviews)
6.4
6.4
User Avatar
Hi, I have good hand in excel data formatting and I think I can do this job. I am ready to discuss over phone. My no. is +91 9830043606 I have done many big excel project so you can trust me and talk once for better clearification. Thanks, Ram
$155 USD in 3 days
5.0 (49 reviews)
5.1
5.1
User Avatar
Hi. I have reviewed both spreadsheets provided. It's a bit of confusing however I agree that it would be better to discuss it further over the phone. I can catch up things pretty easily and I am able to meet deadlines. I have been a Virtual Assistant for a year now and I hope you would consider me. More power!
$155 USD in 3 days
5.0 (4 reviews)
3.9
3.9
User Avatar
This sounds like a procedure that I have written and re-written dozens of times. I'll be glad to put this together for you.
$133 USD in 3 days
5.0 (1 review)
3.6
3.6
User Avatar
Hello, I saw the files attached and I got a very basic fundamental idea of what you want. Correct me if I am wrong, you want some sort of a distance and time mapping from one place to another considering other variables as well. With the data and description provided it is very difficult to understand about the project and the bid is also redundant . Rest assured if you can explain me the project I can do it. I am looking forward to do this project. Thanks Loki1
$155 USD in 3 days
4.7 (8 reviews)
3.2
3.2
User Avatar
Hi there! I would really like to work on your project, you can send me the full instruction or we can chat on this site. If you prefer, you may send first a sample file for me to work on, so you can be sure that I can deliver a file that meets your requirement, then you can award. Hoping for a positive response. Thank you for considering my bid.
$100 USD in 5 days
5.0 (5 reviews)
2.8
2.8
User Avatar
hi sir , i am expert in Excel , and i am intersted in your job , it seems easy to me without calling you, i wish you accept me and i promise you will not regret,regards.
$140 USD in 2 days
5.0 (2 reviews)
0.8
0.8
User Avatar
Lets Start now.. I think I am suitable for this ......You just provides us your project details and leave all other on me..
$111 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am proficient in excel & work prolong hours in excel Can complete the job with no errors & for low budget.
$122 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Our production team is well qualified and professionally trained by our specialized trainers. We assure quick turn around time even without prior reservation of capacity. Furthermore our overnight Exel support helps our clients to send their work before they leave the office in the evening and simply get their ready Exel presentation on the following day morning.
$150 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have excellent Excel skills and I am detail oriented. I have more than five years of experience in daily working with very large databases. I checked the files and I would like to help you with this project.
$100 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi I can help you with this project. If you want to contact me pls send me a PM and I'll send you my number or vice versa. Willing to start upon receiving the milestone payment.
$100 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, going through my profile might be thinking me reading a New Freelancer profile, yeah that's true but I would like to inform you that i have been using Excel from past 7 years for doing such kind of descriptive projects like yours one,I was going through your samples attached and trust you own some good transportation business and I am keen to serve you. Further more, it would be again good pleasure taking good reviews over my new profile towards your successful completion of work. Please hire me, i promise you no regretting Looking forward to hear from you and most eagerly waiting for your con call. Best Regards Sumit
$100 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi I can complete this work quickly and correctly. I love working in excel and would like to do this. Regards Nelis
$35 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
South Easton, United States
0.0
0
Payment method verified
Member since Sep 3, 2013

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.