March 26, 2025
A new version of the PC*Miler Web Services Spreadsheets add-in for Microsoft Excel is now available. If you are licensed for the application, contact us to receive the latest version. If you're interested in licensing the app, please reach out to our sales team.
Updates in the Latest Version
- Enhanced Location Matching: New function arguments allow you to specify countries and regions for origins and destinations. These settings help improve location matches and may improve performance by narrowing the search scope.
- Comprehensive Examples and Test Cases: The download includes an Excel file titled Instructions and Samples.xlsx, which provides detailed explanations of each function along with sample calls using all available arguments.
- Improved Performance: The overall performance of the add-in has been optimized, ensuring a smoother user experience.
March 13, 2025
Enhancements
New route reports view
Route reports have been overhauled to provide better functionality and efficiency. Key changes and improvements are listed below. For additional information on running and viewing reports, click here.
- A new Reports button has been added to the lower right corner of the map pane. Select the Reports button to open the route report pane.
Note: This button can only be selected once a valid route has been generated. If a valid route is not selected, the button is grayed out. - The Reports pane is now displayed below the map pane. This double pane view allows you to view the report details and map without needing to navigate between separate windows. Whenever a route is selected from the Routes tab, both panes update to display information for the currently selected route.
- You can print the currently selected report, or all reports for the route you are viewing by selecting the respective buttons in the upper-right corner of the Reports pane. Additionally, you can also select
to export the route report to a .csv file, or select
to open the Reports pane in a new window.
Overview image of new double pane report layout (click on image to enlarge).
Route costs customization
Route costs can now be set to $0.00 for simplified cost calculations when creating and saving a route. Saved routes will retain the route cost settings that were set when the route was initially saved. Route costs are changed within the Application Settings tab > Route Costs fields. Route costs are retained for your user profile and are saved for future log-ins. For additional information on how to set route costs, click here.
Improved Arrive/Depart time entry
Arrival and departure time entry has been updated to give you the ability to select a time using your mouse in addition to the existing keyboard inputs. To set an arrival/departure time using a mouse, select the time field and use the directional arrows to set the hour and minute values. Then, select the AM or PM button to switch between AM and PM.
Search function added to data version dropdown
A search field has been added to the data version dropdown list. You can now enter a version number into the search field in addition to using the existing dropdown list.
Bug Fixes
- Fixed an issue where the "State + National Network" option would be enabled for the "Auto" vehicle profile when making changes to route options.
- Corrected an invalid payment issue with customers using credit card for their PC*Miler Web subscription.
- Improved function of various warning messages and prompts in preparation for new the double pane Reports window.
Feb. 25, 2025
Enhancements
Location search is now set to display results only after three or more characters have been entered. When less than three characters are entered, the results field displays "Please enter at least 3 characters". This changed is intended to minimize the load time for search results.
Feb. 11, 2025
New Features
When requesting a route report for a specific version of PC*Miler Web, the report and route path now reflect the selected version. Previously, only the report reflected the selected version while the route path defaulted to the current version. This would occasionally result in situations where the route path did not fully align with the report data due to roadway changes or updates to the PC*Miler routing algorithm.
Example
Resulting path of a route report using current version:
Resulting path of the same route report using version 37:
Note: The map itself will always show the current layout of roadways and intersections. As a result, there will be instances where a previous version's route path does not align with the roadways displayed in the current map version. This outcome should be expected as the goal is to show the original route path of the selected version.
Enhancements
Routing Profile field
- Search functionality has been added to the Routing Profile dropdown field. The dropdown field displays results based on user input text. If no relevant profile is found, the dropdown field displays a "No Results Found" message.
- A Create Vehicle Routing Profile button now appears in the dropdown field if no custom profiles have been created. Select this button to open the Vehicle Routing Profiles tab and create a custom profile by following the custom profile setup process.
Route reports
Similar to the legacy version of PC*Miler Web, route reports now open in a separate window when the Reports button is selected for a specific route. This gives users the ability to compare multiple route reports at a time and move the report window to prevent it from obstructing the displayed route path on the map.
Bug Fixes
- Fixed an issue where editing a previously saved route would result in the route being duplicated instead of replaced.
- Fixed an issue where using the Portuguese language version of PC*Miler Web would result in the incorrect time notation. Time stamps are now standardized to display the AM/PM notation for all languages.
- Corrected a behavior in custom routing profiles where opening a profile and not performing any edits would mistakenly enable the Save button and trigger an “Unsaved Changes” warning when selecting Done.
- Improved route optimization to ensure stops reflect the correct order after reordering.
Jan. 22, 2025
Enhancement
The maximum number of saved routes per user has been increased to 3,000.
Jan. 9, 2025
Removed Features
The banner that allowed users to toggle between the legacy and modern versions of PC*Miler has been removed. On Jan. 22, 2025, the PC*Miler legacy version will be permanently shut down.
Bug Fixes
Fixed display issues with the Routes panel.