 PC
MILER SPREADSHEETS
Call
1-800-567-8385
For Our Best Price
PC MILER Spreadsheets gives you the ability to access
the powerful PC MILER database from within your own
spreadsheet software. Generate point-to-point or
street-level mileage and drive times, including
truck-specific toll costs, within a spreadsheet application
and use built-in functions to summarize and analyze your
data. PC MILER Spreadsheets provides a seamless interface
with PC MILER and Microsoft® Excel®, allowing users to
perform customized analysis in an environment specifically
designed for data analysis.
Benefits include:
-
Calculate weekly, monthly or even
yearly driver pay based on per mile costs
-
Analyze transportation costs to and
from customers, including accurate toll costs per each
leg of the trip (PC MILER Tolls Add On Module purchase
required.)
-
Audit freight bills to verify if
you’re being paid according to the distance traveled
-
Select loads based on location and
profitability – proximity analysis
-
Negotiate rates based on actual
mileage, not estimated values
-
Optimize lane analysis and perform
modal comparisons
-
Maximize your strategic planning and
forecasting methods
-
Provide price quotes, within seconds
SAMPLE APPLICATIONS
Instantly translate between geographical locations (i.e.
convert ZIP/Postal Codes, city, state and lat/long
coordinates), calculate mileage and drive times, and
determine rates for your customers. View and interact with
data in an environment specifically designed for data
analysis and calculations. Perform a
Proximity Analysis to determine the nearest and farthest
depot, customer or vehicle from a particular location. Set
up the formulas once and you only have to change the
Customer Locations. SAMPLE FUNCTION CALLS
NOTE: The examples
below are not a comprehensive list of all available PC MILER
Spreadsheets custom formulas. Please consult the Users Guide
for a comprehensive list.
=ZipCode( ) - Returns a 5-digit
ZIP Code from a corresponding City/State.
=Miles( ) - Returns mileage between two points
(City/State, Address, ZIP/Postal Code, SPLC, Lat/Long, or
Custom Place).
=Tolls( ) – Returns the total toll cost from the
origin to the destination (City/State, Address, ZIP/Postal
Code, SPLC, Lat/Long, or Custom Place). NOTE: PC MILER Tolls
purchase required. Toll amounts are available in the U.S.
and Canada.
=DiscountedTolls( ) – Returns the portion of the
tolls for the trip attributable to the specified discount
program and the specified state. The origin or destination
can be a City/State, Address, ZIP/Postal Code, SPLC,
Lat/Long, or Custom Place. NOTE: PC MILER Tolls purchase
required. Toll amounts are available in the U.S. and
Canada.NOTE: This example provides the E-ZPass toll charges
for NJ and DE only. All participating states using E-ZPass
available.
=DriveTime( ) - Returns a drive time between two
points (City/State, Address, ZIP/Postal Code, SPLC,
Lat/Long, or Custom Place).
=CityName( ) - Returns a City/State from a
corresponding ZIP/Postal Code or SPLC.
=CityNameWithCounty( ) – Returns the city with state
and county name for a City/State, ZIP Code, SPLC, Address,
or Custom Place.
=FullName( ) - Returns ZIP Code, City/State and
county name from a corresponding ZIP/Postal Code, SPLC, or
City/State).
SYSTEM REQUIREMENTS
Environment: PC with a minimum 700
MHz processor (1-2 GHz processor recommended)
Requirements: 2 MB of hard disk space, 256 MB RAM
Platforms: PC/LAN Windows (2000,
2003, Vista, XP, includes 64-bit support)
Other: Microsoft Excel V5.0+, CD-ROM Drive, Internet
connection for initial license activation
NOTE: PC MILER Tolls purchase required to
report truck-specific toll costs in North America.
NOTE: PC MILER Streets purchase required to report
street-level mileage and address information in North
America.
NOTE: PC MILER HazMat purchase required to report hazardous
materials mileage in North America.
NOTE: PC MILER Worldwide purchase required to report
worldwide mileage and locational information in North
America, South America, Africa, Asia, Europe and Oceania. |
