PC*MILER Spreadsheets

Using Spreadsheets: Getting Location Information (Lat/Long)
PC*MILER Spreadsheets includes a number of functions that allow you to retrieve location information from the PC*MILER database. Getting a Latitude/Long...
Thu, 25 Jun, 2020 at 6:12 PM
Using Spreadsheets: Sites Routing
(Streets add-on required) A Site extends a location to include a boundary polygon around its perimeter, entry and exit points (gates), and other valuable in...
Tue, 20 Oct, 2020 at 3:21 PM
Using Spreadsheets: Getting State/Country Distances with Tolls
The State/Country Report lists toll, toll-free, ferry, and total distances by state/country. If the Tolls add-on module is installed with PC*MILER, the last...
Thu, 25 Jun, 2020 at 6:12 PM
Using Spreadsheets: Avoid, Favor or Override Roads
If the “Custom” option is turned on in the PCMSERVE.INI file, PC*MILER Spreadsheets will use the Route Modifiers (avoid/favor road settings) created in Cont...
Thu, 3 Jun, 2021 at 1:57 PM
Using Spreadsheets: HazMat Routing
(North America only)  If the HazMat add-on module has been purchased, PC*MILER Spreadsheets can calculate routes that are hazardous material compliant for v...
Tue, 20 Oct, 2020 at 3:22 PM
Spreadsheets Common Errors and Questions
‘Run-time error 1004’ If you get the error “Run-time error ‘1004’: Programmatic access to Visual Basic Project is not trusted”, follow these steps (or equi...
Tue, 20 Oct, 2020 at 3:27 PM