SUPPORT CENTER

PC*MILER


PC*MILER|Spreadsheets

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, 24 Jun, 2019 at 3:57 PM
Using Spreadsheets: Entering Latitude/Longitude Points as Stops
Latitude/longitude points can be entered as stops on a route in degrees minutes seconds format or decimal degrees (e.g. 0401750N,0742131W or 40.297222N,74.3...
Thu, 30 May, 2019 at 7:25 PM
Using Spreadsheets: Worldwide Data
Changing the Region (PC*MILER|Worldwide only) To enter location data for regions outside North America, you can change the region using the =SetDefaultRegi...
Thu, 30 May, 2019 at 7:27 PM
Using Spreadsheets: Location Names with Special Characters
Some PC*MILER location names include one or more special characters, such as accent marks. lncluding those special characters can help ensure you are enteri...
Thu, 30 May, 2019 at 7:29 PM
Using Spreadsheets: Multi-Stop and Hub Routes
Multi-Stop Routes A good way to calculate a multi-stop route is to put all stops along the route, including the origin and destination, in the same column....
Mon, 24 Jun, 2019 at 3:58 PM
Using Spreadsheets: Routing with Vehicle Dimensions
The functions =Miles, =MilesEX, =Tolls, =TollsEx, =DiscountedTolls, and =DiscountedTollsEx can be used with eight optional parameters for custom vehicle dim...
Mon, 24 Jun, 2019 at 3:58 PM
Using Spreadsheets: Toll Costs
(North America Only)  If the PC*MILER|Tolls add-on module is installed with PC*MILER, Spreadsheets will include two functions that calculate accurate, up-to...
Mon, 24 Jun, 2019 at 3:59 PM
Using Spreadsheets: Combination Routing
Combined route types can be calculated in Spreadsheets by altering the CalcType setting in the pcmserve.ini file. prac|toll (Practical and Toll Discourage...
Mon, 24 Jun, 2019 at 3:59 PM
Using Spreadsheets: Getting Location Information (Postal Codes)
PC*MILER|Spreadsheets includes a number of functions that allow you to retrieve location information from the PC*MILER database. Getting the City Name f...
Mon, 24 Jun, 2019 at 3:59 PM
Using Spreadsheets: Getting Location Information (Names)
PC*MILER|Spreadsheets includes a number of functions that allow you to retrieve location information from the PC*MILER database. Getting the City Name/S...
Mon, 24 Jun, 2019 at 4:00 PM