π§ 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β¦
The "Cost" column numbers are stored as text, so they can't be used as inputs to calculations or charts
The "Charge Duration" has the units (min) embedded so these cells can't be used in calculations or charts
The "distance" column has the units (mi) embedded so these cells can't be used in calculations or charts
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)
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
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.
Open
π‘ Feature Requests
Over 3 years ago

John Kitchen
Get notified by email when there are changes.
Open
π‘ Feature Requests
Over 3 years ago

John Kitchen
Get notified by email when there are changes.