Price/Gallon Not Being Computed During Import

25 views
Skip to first unread message

white...@gmail.com

unread,
Nov 10, 2019, 8:19:51 PM11/10/19
to MyCars
I just noticed that when I import a file with refueling entries that have both number of gallons and total price (that app did not record both total and per/gallon price) the value of price per gallon is not being computed during import. Is this expected? Seems like the app should be able to do this pretty easily if no price/gallon is specified. Otherwise, in order to force the computation to happen, I must go into each entry, once imported, and touch the price field. With many records, this is not a viable option. I know I can redo my input spreadsheet to compute this prior to input. But why doesn't the app compute the a missing value (either per/gallon or total) if either is missing?

white...@gmail.com

unread,
Nov 10, 2019, 8:33:44 PM11/10/19
to MyCars
I notice that even when I modify my spreadsheet to computer the per gallon price from the quantity and total price and then import it, things are still not quite correct. In the refuel list, the per/gallon price looks something like this "?/1.51 USD/gal" (if I manually touch the total price as mentioned below, there is no leading "?". Also, when I edit an entry like this, I see that the price per gallon field is blank. This all seems rather odd. I know that importing is potentially fraught with trouble (for example, make sure that prices do NOT have a leading currency indicator) and that it happens to each user rarely if they are lucky. But this is sure painful.
Reply all
Reply to author
Forward
0 new messages