Spreadsheets: Set Routing Options (PCMSERVE.INI)

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), borders open/closed, the order of states/countries in the state/country summary report (alphabetical vs. travel order), and several others.

Default options may also be set in the PC*Miler user interface. The order of precedence for route option settings is as follows:

  • Options that are set directly in Spreadsheets prevail over the default options set in PC*Miler and the .INI file.

  • Options set in PCMSERVE.INI prevail over those set in PC*Miler.

  • Options set in PC*Miler as defaults take effect only in the absence of settings 1 and 2.

Excel must be closed and reopened for changes set in the .INI file or PC*Miler to take effect.