PC*MILER|Spreadsheets
(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...
Wed, 20 Jun, 2018 at 12:15 PM
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, 21 Jun, 2018 at 8:39 PM
Changing the Region (PC*MILER|Worldwide only) To enter location data for regions outside North America, you can change the region using the =SetDefaultRegi...
Wed, 20 Jun, 2018 at 12:19 PM
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, 21 Jun, 2018 at 8:38 PM
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....
Wed, 20 Jun, 2018 at 12:44 PM
The functions =Miles, =MilesEX, =Tolls, =TollsEx, =DiscountedTolls, and =DiscountedTollsEx can be used with eight optional parameters for custom vehicle dim...
Fri, 26 Jan, 2018 at 7:02 PM
(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...
Tue, 16 Oct, 2018 at 4:54 PM
Combined route types can be calculated in Spreadsheets by altering the CalcType setting in the pcmserve.ini file.
prac|toll (Practical and Toll Discourag...
Fri, 26 Jan, 2018 at 7:59 PM
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...
Thu, 21 Jun, 2018 at 8:43 PM
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...
Fri, 26 Jan, 2018 at 8:26 PM