Garmin Dezl 770 and IFTA

Those of you using the Garmin Dezl 770 or equivalent for tracking your IFTA, how do you print out your trip reports? Or do you?

I'm not asking how to export the data, to me, that's the simple part. The summary is all you need to complete the IFTA filing, and that easily fits on a page of paper. The trip report however, is multiple page, over width, and over height! Need to flag the darned thing!

Before I was using the Garmin for IFTA, I was filling out trip reports. I'm not sure how others do it, but my trip report was per tank of fuel, and being a local to regional driver, it just... made sense. When it came time to file IFTA, each trip report had a fuel receipt stapled to it, they were stacked up, with a copy of the IFTA filing on top, all stapled or paper clipped into a nice neat bundle, and into a file folder to show an auditor if that ever came to be.

With the way the Garmin Dezl exports to the spreadsheet, its not really something that can be printed out worth a darn unless you do a lot of editing? This goes along with my assumption, that everyone DOES keep hard copies of trip reports, and not just in a file on the computer. Do you edit the heck out of it to print it so it makes sense looking at it? I'm far from a genius running a computer, do I just have formatting messed up? Settings somewhere to adjust?

This whole book I just wrote, is just to ask the simple question, "How do you print your trip reports" to keep hard copies.... Or.... do you?

 

No, my problem isn't with the exporting. Unless I'm really missing something, there is no way to save the file differently. The problem is, when the trip report is exported, and then opened in Excel, the field that contains the road numbers, lists all roads, which means that it can get to be a very, very long field. That field, stretches way off the page, even printed landscape, can be several pages long.

There may be a way to configure the field in Excel so it continues to the next row after it gets to a certain length of cell? But, if there is, I have no idea how. I guess I should be calling in the help of one of my teenagers for that.

The summary page, loads in a nice condensed way, that makes it very nice for using/getting the information needed to complete an IFTA filing.

All of this may be immaterial however. The folks that I was just talking to think that if I was to have an IFTA audit, to have those files on the computer would be just fine. I have always looked at it as needing to have a paper/hard copy. If this is the case, then there is no reason to print them out, and then none of this matters.