Trucking Formulas

Job ID: 35515794

Budget: $30 – $250 USD

I am currently working on as a spreadsheet that will be used to help evaluate truckloads. This spreadsheet should be able to web scrape from Google Maps the Origin, Destination, Trip Time, and Distance it should also be able to display the Map/Route the driver would take! The spreadsheet would calculate the amount of fuel need to pickup a load from Origin to Destination. Should web scrape the Diesel Average for FL, Ga, SC, NC, VA, AL, MS, LA, and TX . It should calculate total fuel cost, fuel cost per mile.

Most of the calculations I have done myself. What I'm have problems with plugging in is the Trip Origin, Trip Destination, Trip Time, Trip Distance and the Google Map into the spreadsheet. When I type in the Origin and Destination the fastest route should be chosen! IN google Maps this is usually the first route.
Related categories: Excel Web Scraping Data Mining JSON API