Obviously, the most user friendly way to go would be to have a table where we could click to sort all the TRs by date, state, author, etc... but I assume that would be too hard to set up!
Funny you should mention that because I'm working on an excel file that will allow just that type of sorting. One will be able to filter and sort by any column. Only downside is I need a place to host the file and one would have to download it before using it.
Found a way to automate grabbing a lot of the data yesterday only to discover there are over 800 trip reports! Of those, about 150 of have broken because of a change in the directory structure. Those will be fixed when the new TR sticky comes out sometime in May. Still have a lot of data manipulation to do but it's progressing nicely.