[quote="rank"]
Quote:
I understand how you use Streets and Trips for IFTA, but how do you get from there to something you can share with others for their IFTA? I'm real curious because I'd like to ditch my service.
|
I saved the instructions to a text file and now all I have to do is write a program that reads every line. If the text of the line does not contain the word "Entering" then I ignore it. If it does, then I save it to a storage area in memory called an array.
Now I have an area in memory that looks like this.
100 Entering Massachusetts
200 Entering Pennsylvania
300 Entering Ohio
400 Entering Indiana
500 Entering Ohio
600 Entering Pennsylvania
700 Entering Massachusetts
800 Arrive New Hampshire
I would have to enter into the program the state that I was starting from and in the case above, that would be New Hampshire.
So now I run through my memory array and read the first line then subtract that from the previous line and now I have the mileage for that state. In the case of the first line it would be 100 miles for New Hampshire then 100 miles for for Mass then 100 miles for PA and so on. As I encountered another state that I've already run across I would just add that to my running total.
When I was done I would output an ascii file that looked like this. It is know ahead of time that each location between commas represents a certain state like AL,AK,AZ,
,,,200,,300,100,,,500,,,,,,,,,,,600,,,,,,,,,,,,,,, ,,,,,,,,,,,,,,,,,,,,,,,
This is what is referred to as a coma separated file that can be imported to a spreadsheet as data. There are already tons of spreadsheets out there for IFTA that are free to download.
Just stopping here would be the biggest savings in time for me knowing the mileage for all the states. I could sort and output the data like this
AL
AR
AK
VT 200
MO
MA 200
OH 300
KY
NV
I've already done a little looking and found some states post an updated spreadsheet for IFTA for their state. The data that I extracted above could be imported to the spreadsheet then the only thing would be to enter the gallons purchased and the states and it would be done.
I'll do a little looking but will probably stop at just extracting a mileage total for all the states. That's my biggest pain trying to figure out all the states and miles.