ALK Technologies - Technology that Drives Transportation - GPS Navigation Evolved

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 use built-in functions to summarize and analyze your data.
OVERVIEW
FEATURES
SYSTEM REQUIREMENTS
SCREENSHOTS
Call 1.800.377.MILE
  • More Information
  • Feature Sheet
  • PC*MILER Product Catalog

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.

There are several formulas to choose from, allowing users 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 used are:

  • [=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 ). (PC*MILER|Tolls Add-On Module required.) ***LINK PC*MILER|Tolls text to the tolls page.
  • [=DiscountedTolls (Origin, Destination, Discount Toll Program, Corresponding State , "Routing Type)] : Returns the portion of the toll costs 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 . For example, calculate the E-ZPass toll costs by state for a trip. (PC*MILER|Tolls Add-On Module required.) ***LINK PC*MILER|Tolls text to the tolls page.

Application

Rate determination and negotiation, driver pay, billing, bid preparation, carrier selection, strategic planning and forecasting, logistical analysis, freight cost analysis, freight bill auditing and lane analysis

Download Sellsheet

 

Click on the image to download this product's sellsheet

 

Click on the image to download the PC*MILER Product Line Catalog

Case Study

Case Study text...

Inroad's Newsletter

Case Study text...