🔍
Trucking dispatch scheduler for up to 15 trucks a day in Google Sheets: counts of available, urgent, booked, pending and out-of-service loads, revenue, and a daily schedule of drivers, trucks and loads.
Auto Miles Calculator and Manual Miles Input dispatch schedulers compared, with a video tutorial in the description: both include driver and truck setup, the scheduler, calendar view and automatic archiving; only the auto version calculates miles with the Google API, and only the manual version works in Excel.
Note: this item uses the Google Sheets API to calculate the distance between two locations; if the daily limit is reached, mileage does not fill in. The video in the description explains this. Another listing works in both Google Sheets and Excel.
Trucking dispatcher with the auto miles calculator: pick the week to schedule from drop-down lists; load status counts and revenue are shown, and 7 scheduling tables appear, one for each day of the week.
Automated distance calculator: Google API scripts calculate the miles between two locations from the city and state, including empty and loaded miles based on the truck's location and the load's origin and destination.
Truck status at a glance in the auto miles dispatcher: each truck's status is color-coded, and a selected truck turns green to show it is available for booking.
For owner-operators and independent dispatchers: the auto miles dispatcher calculates the week's revenue and a percentage of revenue for each load dispatched.
Status calendar in the auto miles dispatcher: choose a status to see the trucks with that status for each day of the week, with loads per day counted automatically.
Dispatch data is archived with one button, and cleared with another.
This is a digital product; no physical item is sent. One PDF with download instructions is provided after payment. Works with Google Sheets only.
  1. Trucking dispatch scheduler for up to 15 trucks a day in Google Sheets: counts of available, urgent, booked, pending and out-of-service loads, revenue, and a daily schedule of drivers, trucks and loads.
  2. Auto Miles Calculator and Manual Miles Input dispatch schedulers compared, with a video tutorial in the description: both include driver and truck setup, the scheduler, calendar view and automatic archiving; only the auto version calculates miles with the Google API, and only the manual version works in Excel.
  3. Note: this item uses the Google Sheets API to calculate the distance between two locations; if the daily limit is reached, mileage does not fill in. The video in the description explains this. Another listing works in both Google Sheets and Excel.
  4. Trucking dispatcher with the auto miles calculator: pick the week to schedule from drop-down lists; load status counts and revenue are shown, and 7 scheduling tables appear, one for each day of the week.
  5. Automated distance calculator: Google API scripts calculate the miles between two locations from the city and state, including empty and loaded miles based on the truck's location and the load's origin and destination.
  6. Truck status at a glance in the auto miles dispatcher: each truck's status is color-coded, and a selected truck turns green to show it is available for booking.
  7. For owner-operators and independent dispatchers: the auto miles dispatcher calculates the week's revenue and a percentage of revenue for each load dispatched.
  8. Status calendar in the auto miles dispatcher: choose a status to see the trucks with that status for each day of the week, with loads per day counted automatically.
  9. Dispatch data is archived with one button, and cleared with another.
  10. This is a digital product; no physical item is sent. One PDF with download instructions is provided after payment. Works with Google Sheets only.

Trucking Business

Trucking Dispatch Scheduler – 15 Trucks (Google Sheets)

$22.99

Digital Download
  • Instant download after payment
  • No sales tax, no hidden fees
  • Excel and/or Google Sheets files

This item auto calculates distance between two points using Google API

How does it work?

Check out the Youtube video on how to use it below.

What will I get?

You will receive 1 PDF instruction guide on how to save the file and enable Google Scripts. This template is exclusively compatible with Google Sheets ONLY and requires users to enable three Google Sheets scripts for full functionality

How will I get the files?

Once your payment is successfully processed, you will receive instant access to download links for your digital product. A confirmation email will also be sent with downloadable links.

Returns & Exchanges?

These are digital products and sales are final. If a template does not work as described, you may report the issue within 7 days of purchase and may be eligible for a refund under the Terms of Service.

About this template

This trucking dispatch scheduler works in Google Sheets. It is the Trucking Dispatch Scheduler – 15 Trucks (Google Sheets), designed by a licensed CPA.

What is in the trucking dispatch scheduler

The template includes counts of available, urgent, booked, pending and out-of-service loads, revenue, and a daily schedule of drivers, trucks and loads.

Who uses it

Dispatchers, owner-operators and small fleets that plan loads for several trucks. See all dispatch spreadsheets.

What you receive

One PDF guide with the link to the Google Sheets file and the steps to save it to your Google Drive and turn on its scripts. It works in Google Sheets only.

https://everreachcraft.com/product/trucking-scheduler-logistic-coordinator-scheduling-spreadsheet-by-the-trip-scheduling-tool-truck-dispatcher/

How does it work?

Check out the Youtube video on how to use it here:

Google API Limit/Risks:

Reviews

Reviews

There are no reviews yet.

Be the first to review “Trucking Dispatch Scheduler – 15 Trucks (Google Sheets)”

Your email address will not be published. Required fields are marked *