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...
Mon, 24 Jun, 2019 at 3:57 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, 30 May, 2019 at 7:25 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...
Tue, 20 Oct, 2020 at 3:23 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, 30 May, 2019 at 7:29 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....
Mon, 24 Jun, 2019 at 3:58 PM
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
(North America Only) If the Tolls add-on module is installed with PC*MILER, Spreadsheets will include two functions that calculate accurate, up-to-date tol...
Thu, 25 Jun, 2020 at 6:11 PM
When entering formulas in PC*MILER Spreadsheets, the only required arguments are Origin and Destination. There are optional arguments for vehicle dimensions...
Thu, 20 Jul, 2023 at 7:12 PM
Combined route types can be calculated in Spreadsheets by altering the CalcType setting in the pcmserve.ini file. prac|toll (Practical and Toll Discourage...
Tue, 20 Oct, 2020 at 3:23 PM
(Requires license for PC*MILER Spreadsheets add-on. Contact us to learn more.) Use Excel's Insert Function option to easily call PC*MILER functions ...
Tue, 6 Dec, 2022 at 1:44 PM