SUPPORT CENTER

PC*MILER


PC*MILER|Spreadsheets

What is PC*MILER|Spreadsheets?
PC*MILER|Spreadsheets is an add-in for Microsoft Excel that allows users to easily access PC*MILER distance information from within their spreadsheet progra...
Wed, 2 May, 2018 at 7:51 PM
PC*MILER|Spreadsheets Requirements, Installation and Licensing
PC*MILER|Spreadsheets requires a base installation of PC*MILER. More information on PC*MILER platforms and requirements is available here.  Additionally...
Wed, 6 Mar, 2019 at 6:41 PM
Demo Spreadsheets
The PC*MILER|Spreadsheets installation contains sample workbooks of all Spreadsheets functions. These files are located in the Excel folder in the PCMILERXX...
Thu, 21 Jun, 2018 at 8:38 PM
The Spreadsheets Excel Add-In: Enabling and Disabling
PC*MILER|Spreadsheets is an Add-In for Excel Version 5.0 or higher. To complete the installation, you must enable the Add-In manually from within Excel, or ...
Wed, 21 Nov, 2018 at 1:55 PM
Using Spreadsheets: Entering Formulas
There are two ways to use PC*MILER|Spreadsheets formulas in Excel: either type them directly into a cell or use the Insert Function option. All formulas wil...
Wed, 21 Nov, 2018 at 1:53 PM
Using Spreadsheets: Entering Locations
Depending on the types of data you are licensed to use with PC*MILER Spreadsheets, you can enter origins and destinations in the following ways. City/St...
Wed, 21 Nov, 2018 at 2:07 PM
Using Spreadsheets: Default Routing Options
Default routing options that can be edited in the PCMSERVE.INI file include the route type, the unit of distance used in calculations (miles vs. kilometers)...
Wed, 20 Jun, 2018 at 12:05 PM
Using Spreadsheets: Getting Mileage
The Miles function returns the driving distance from the origin to the destination. =Miles (origin, destination [, routing type]) The origin and des...
Fri, 22 Jun, 2018 at 7:26 PM
Using Spreadsheets: Getting the Drive Time
DriveTime returns the driving time (in minutes) from the origin to the destination. Stop entry formats and available route options are the same as for the M...
Wed, 20 Jun, 2018 at 12:13 PM
Using Spreadsheets: Postal Codes
U.S. ZIP Codes and Mexican Postal Codes share a similar naming convention. To ensure the entered ZIP/Postal Code matches the desired location, there are set...
Wed, 20 Jun, 2018 at 12:14 PM