PC*MILER|Spreadsheets

PC*MILER|Spreadsheets gives you access to PC*MILER from within your own spreadsheet software.

PC*MILER|Spreadsheets gives you the ability to access PC*MILER features and functionality 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 you to perform customized analyses of your data in an environment specifically designed for data analysis. Request More Information

Current Version: 26
  • Benefits
  • Features
  • System Requirements
  • Negotiate rates on actual mileage, not approximate values
  • Analyze transportation costs to and from customers
  • Calculate driver pay based on per mile wages
  • Audit freight bills for mileage discrepancies
  • Provide price quotes in seconds
  • Optimize lane analyses and perform modal comparisons
  • Perform proximity and rating analyses
  • Enhance strategic planning and forecasting

General Features

  • NEW! Geocode and route to Mexican Postal Codes
  • NEW! Toll costs* for two new discount programs: Leeway and Wabash Pass
  • Access to a custom Add-In within your spreadsheet program where formulas are exposed to gain access to PC*MILER data
  • Generate mileage calculations and conduct lane analyses
  • Geocode street-level addresses* in the U.S. and Canada
  • Calculate truck-specific toll costs* in the U.S. and Canada
  • Translate latitude/longitude points into city/state combinations and vice versa
  • Calculate drive times from one stop to another
  • Generate a state/country distance report to provide trip mileage information by state/jurisdiction
  • Calculate alternative rail intermodal routes and compare truck versus Rail Mileage*, fuel consumption, and carbon emissions per route (with PC*MILER Intermodal Analysis)

    • *Applicable licenses required.

Most Popular Formulas

    (not a comprehensive list)

  • =Miles() – returns mileage between two locations based on the routing type selected
  • =ZIPCode() – returns a 5-digit ZIP Code from a corresponding location
  • =CityName() – returns a city/state from a corresponding location
  • =FullName() – returns ZIP Code, city/state and county name from a corresponding location
  • =Tolls()* – returns the total toll cost from the origin to the destination
  • =DiscountedTolls ()* – returns the portion of the toll costs for the trip attributable to the specified discount program and the specified state.  For example, calculate the E-ZPass toll costs by state for a trip.

    • *Applicable licenses required.

Platforms

  • PC/LAN Windows® 2003, Vista, XP, and 7 running in 32-bit compatibility mode as well as support for 64-bit native applications on Windows 7 (not ported to IA-64 architecture although it is supported through a hardware compatibility mode)

Environment

  • 2 MB hard disk space
  • 512 MB RAM (minimum)

Other Requirements

  • Spreadsheet application (e.g. Microsoft® Excel® 5.0 or Higher)
  • DVD-ROM drive or DVD/CD-ROM drive
  • Internet Connection for License Activation (manual license activation also available)
  • Email Address for License Activation (manual license activation also available)
  • For full functionality of PC*MILER Intermodal Analysis a license for PC*MILER|Rail and PC*MILER|Rail-Connect is required
  • Optional licenses of the following to access select PC*MILER data features: PC*MILER|Streets, PC*MILER|HazMat, PC*MILER|Tolls, PC*MILER|Worldwide, Canadian Postal Codes, Standard Point Location Codes

Licensing Options

  • Single-User Local Non-Network License
  • Multi-User Network License
  • Enterprise License
  • Additional Copy License