macro 27 and other fuel stuff

Discussion in 'Prime' started by gatorbaiter, Nov 9, 2011.

  1. gatorbaiter

    gatorbaiter Medium Load Member

    600
    172
    Jun 23, 2011
    3rd Rock
    0
    In an effort not to hijack seeb's thread I thought I would move this over here. sazzok Thanks for the clairification

    IP I agree to use the fuel page. For a comparison I ran teh 27 then did my normal fuel plan. it was 1000 springmo time but the 27 pulled prices that were not current compared to the fuel site. Plus it had me stop for fuel 70 miles after a fuel stop that was 7 cents cheaper in the same state.

    IP you mentioned in an older thread about taking into account state taxes do you know a link that has those?
     
  2. Truckers Report Jobs

    Trucking Jobs in 30 seconds

    Every month 400 people find a job with the help of TruckersReport.

  3. Dix_

    Dix_ Light Load Member

    153
    61
    Dec 11, 2010
    W.Poland, ME
    0
    http://www.api.org/statistics/fueltaxes/upload/Diesel-Tax-Map.pdf

    What I found the most interesting is that even some of the higher tax states can still have a cheaper price in certain places than other lower tax states.

    Gary IN is a good example... it's usually cheaper than even in Ohio... which has a state tax of 21c/gal less.

    I've stopped using Macro 27 completely... I do a LOT better planning my own stops.
     
    Last edited: Nov 9, 2011
  4. ironpony

    ironpony Road Train Member

    17,502
    12,015
    Sep 23, 2007
    Ask my GPS...
    0
    Another great example of this is FL and GA (or any state bordering GA)... buy your fuel in FL coming out with a load of welfare juice. The pump price is usually higher in FL, but the IFTA tax is lower in GA so you're paying more for GA fuel - base rate, and getting less IFTA credit.

    They put a page in the drivers handbook with the state tax rates...

    The IFTA tax matrix is here...

    http://www.iftach.org/taxmatrix3/choose_tableq2.php

    Its a little funky, but with some editing is usable. The "Canadian" numbers refer to the rate for fuel sold in liters (I think) rather than gallons. You want to use the "Special Diesel" column... biodiesel is usually taxed at the same rate.

    I just put the IFTA table into a spreadsheet, then copy the fuel page data and paste it in HTML format. Add another column to it that is base rate fuel price. Calculate it by subtracting IFTA tax from the pump price shown on the fuel page. Sounds like a lot of trouble, but after you get used to the drill it only takes a couple of minutes.

    Sort by the location column, cut out the stuff you won't go near (if you want to go to that much trouble - I delete the cells rather than just erasing the data), then sort again by ascending base price.

    I use the OpenOffice.org office package. If you'd like a copy of my fuel spreadsheet, I'd be happy to mail it to you. PM me if you're interested.
     
    Last edited: Nov 9, 2011
    imyouroldman Thanks this.
  • Truckers Report Jobs

    Trucking Jobs in 30 seconds

    Every month 400 people find a job with the help of TruckersReport.