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, 12 Apr, 2018 at 8:05 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.  Additionall...
Thu, 8 Feb, 2018 at 2:10 PM
Demo Spreadsheets
The PC*MILER|Spreadsheets installation contains sample workbooks of all PC*MILER|Spreadsheets functions. These files are located in the Excel folder in the ...
Fri, 26 Jan, 2018 at 1:16 PM
The Spreadsheets Excel Add-In: Enabling and Disabling
PC*MILER|Spreadsheets is an Add-In for Excel Version 5.0 or greater. To complete the installation, you must enable the Add-In manually from within Excel, or...
Wed, 7 Feb, 2018 at 12:40 PM
Using Spreadsheets: Entering Data
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, 7 Feb, 2018 at 12:42 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)...
Fri, 26 Jan, 2018 at 7:06 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, 26 Jan, 2018 at 3:35 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...
Fri, 26 Jan, 2018 at 7:41 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...
Fri, 26 Jan, 2018 at 7:44 PM
Using Spreadsheets: Entering SPLCs as Stops
(North America only – SPLC data must be installed)  To use SPLCs when entering origins/destinations, each number needs to be preceded by “SPLC”, e.g. “SPLC1...
Mon, 29 Jan, 2018 at 2:07 PM