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 within a spreadsheet program and then 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 a customized analysis in an environment specifically designed for data analysis.

BENEFITS

NEW! PC*MILER Intermodal Analysis. Calculate alternative rail intermodal routes between an origin and destination, allowing quick comparisons of truck vs. rail mileage, fuel consumption, and carbon emissions per route.

Negotiate rates on actual mileage, not approximate values.

Enhance strategic planning and forecasting.

Provide price quotes in seconds.

Analyze transportation costs to and from customers, including exact toll costs per each leg of the trip. (PC*MILER|Tolls purchase required to calculate toll costs.)

Calculate driver pay based on per mile wages.

Audit freight bills for mileage discrepancies to verify if you’re being paid according to the distance traveled or if you’re charging for the correct mileage.

Perform proximity and rating analyses.

Optimize lane analyses and perform modal comparisons.

Instantly translate between geographic locations by converting ZIP/Postal Codes, city/state pairs, and latitude/longitude coordinates into locations accessible in the PC*MILER database.

Run mileage summaries in an instant. Compare Shortest, Practical, Toll Discouraged, National Network, or 53'/102'' Trailer mileage in North America, South America, Africa, Asia, Oceania, and Europe. (PC*MILER|Worldwide purchase required to access regions outside of North America.)

Perform a Proximity Analysis to determine the nearest and farthest depot, customer or vehicle from a particular location. Set up the PC*MILER-specific formulas once and you only have to change the customer locations.

FEATURES
PC*MILER|Spreadsheets allows users to view and interact with PC*MILER data in an environment specifically designed for data analysis and calculation. Through a custom Add-In into your spreadsheet program, formulas are exposed to gain access to PC*MILER data. Choose from several formulas, including the ability to generate mileage calculations, geocode street-level addresses, translate latitude/longitude points into city/state combinations, calculate drive times from one stop to another, and generate a State/Country Distance Report that provides trip mileage information by state/jurisdiction.

The most popular formulas are as follows (other formulas are also available):

=Miles(Origin, Destination, “Routing Type”): Returns mileage
between two locations based on the routing type selected.

=ZIPCode(City, State): Returns a 5-digit ZIP Code from a corresponding
City/State.

=CityName(Location): Returns a City/State from a corresponding
ZIP/Postal Code or SPLC.

=FullName(Location): Returns ZIP Code, City/State and county
name from a corresponding ZIP/Postal Code, SPLC, or City/State.

=Tolls(Origin, Destination, “Toll Reporting Option”, “Routing Type”): Returns the total toll cost from the origin to the destination (City, State, Address, ZIP/Postal Code, SPLC, Lat/Long, or Custom Place).

For Cash Tolls:

For Discount Program Tolls:

=DiscountedTolls (Origin, Destination, Discount Toll Program,
Corresponding State, “Routing Type”):
Returns the portion of the
toll costs for a trip attributable to the specified discount program
and the specified state. For example, calculate the E-ZPass toll costs
by state for a trip.

NOTES:

  • Where applicable, a purchase of Canadian Post Codes and/or Standard Point Locations Codes (SPLC) are required.

  • PC*MILER|Tolls purchase required to calculate toll costs in the U.S. and Canada.

  • PC*MILER|Streets purchase required to report street-level mileage and address information in North America.

  • PC*MILER|HazMat purchase required to report hazardous materials and dangerous goods mileage in North America.

  • PC*MILER|Worldwide purchase required to report worldwide mileage and locational information in South America, Africa, Asia, Europe and Oceania.