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...
Thu, 25 Jun, 2020 at 6:08 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...
Thu, 25 Jun, 2020 at 6:08 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, 25 Jun, 2020 at 6:10 PM
The Spreadsheets Excel Add-In: Enabling and Disabling
PC*MILER Spreadsheets is an Add-In for Excel Version 5.0 or higher that must be purchased in addition to PC*MILER. To complete the installation, you must en...
Thu, 25 Jun, 2020 at 6:09 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...
Thu, 25 Jun, 2020 at 6:10 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, 4 Dec, 2019 at 1:20 PM
Using Spreadsheets: Setting Routing Options (PCMSERVE.INI)
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)...
Tue, 20 Oct, 2020 at 3:20 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 dest...
Tue, 20 Oct, 2020 at 3:28 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...
Thu, 30 May, 2019 at 7:24 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...
Tue, 20 Oct, 2020 at 3:17 PM