Improvements to Excel file export

🚧 THIS IS A TICKET MIGRATED FROM UPVOTY. The original ticket and comments will be available for a limited time over at:
https://abrp.upvoty.com/b/request-a-feature/improvements-to-excel-file-export/
β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”β€”
It's a great idea to provide the "export to Excel" function. It just needs some polishing…

  1. The "Cost" column numbers are stored as text, so they can't be used as inputs to calculations or charts

  2. The "Charge Duration" has the units (min) embedded so these cells can't be used in calculations or charts

  3. The "distance" column has the units (mi) embedded so these cells can't be used in calculations or charts

  4. Calculations can't be performed on the entries in the "Drive duration" column. (I'd like to be able to calculate average speed on each leg, but that's not possible)

  5. The "Arrival" and "Departure" columns CAN be used as calculation inputs, however, if the trip spans midnight, things get messed up. These columns should contain DATE & TIME

  6. Trip legs where the algorithm has chosen to provide a speed limitation in the interests of range should be flagged as such, and there should be a column containing the suggested speed limit

I know I can transfer speed limits from the app to the Excel files, and I can write VBA code to fix the other issues, but I'd prefer not to have to.

Thanks!!

Please authenticate to join the conversation.

Upvoters
Status

Open

Board

πŸ’‘ Feature Requests

Date

Over 3 years ago

Author

John Kitchen

Subscribe to post

Get notified by email when there are changes.