The DispatchBot Trip Estimator allow you to calculate the distance between two addresses to help you see how much a trip will cost based on your own rates.  This workbook is especially helpful for giving trip quotes to customers for private pays!  The workbook can be found as an attachment at the bottom of this article.  The article itself will go over where you can customize the workbook to fit your needs.


When you first open the workbook, you may need to click "Enable Editing" in Excel for the workbook to work properly.


There are 3 tabs at the bottom of the workbook, QuoteSheet, Lists, and Rates.


QuoteSheet


This is your primary tab.  You will enter client and trip information into this workbook.  The fields entered in this workbook will be used to do your calculations for your quote. There are fields for the Rider name and address, Billing Name and Address, the pick up address and the destination address.  Typing in Addresses in the Pickup and Drop Off fields will automatically call out to Google Maps for the distance between the two addresses.  It uses this distance and the information in the "Rates" tab to calculate how much a trip will cost using your own rates and fees.


There are also other drop downs and options such as the Dispatcher name (who created the quote), the trip date, ambulatory or wheelchair, additional ambulatory passengers or additional wheelchair passengers, etc.


Rates


This tab is where you will enter your rates for ambulatory and wheelchair trips including drop/flag fees, mileage or additional passengers.  The cells highlighted in GREEN are the fields you want to enter your rates in.  The other fields are used for calculation purposes and should not be adjusted.


Lists


The Lists tab is primarily used for the dropdown menus.  The first column (A) gives you the option to enter any employee names that will be used in the QuoteSheet tab in the "Dispatcher" dropdown menu.  This is useful to help identify the person who gave a specific quote if you choose to print the quote out.