Suggestions to Mileage Logs

Discussion in 'Website news & discussions' started by Dan, Mar 21, 2007.

  1. SSixty

    SSixty Gas Miser

    I went back and updated my avgTemps in my mileage logs (as per HCHCIN's thread re and it ended up being rather tedious. Click my car's log, Click tank, make change, Click Save, and repeat.

    Not a big deal, and not a problem for me now, but for anyone else wishing to edit several tanks - perhaps. Would you consider adding another button next to 'Add another tank' maybe called 'Edit another tank' which simply brings you right back to the car's log to select another tank to edit?

  2. tbaleno

    tbaleno Well-Known Member

    Sounds like a good idea.
  3. Shiba3420

    Shiba3420 Well-Known Member

    Its already been said and 2nd, but I'd like to add a 3rd....%EPA MPG so that the list can be more competitive for those who like that sort of thing.
  4. psic

    psic Well-Known Member

    Hm, well a couple of things: I've just now noticed that clicking on a person's ID takes you to the 'profile' page... I've uploaded a couple of pics but can't seem to make heads or tails of the rest of the blocks. I wanted to link the 'mileage retriever' to my mileage but couldn't find the car's ID anywhere. In the end I found it in the URL when you click on the car in the Mileage logs. Kind of user-un-friendly :(

    Also, when I first joined up and added my car to the mileage logs, I chose L/100 Km as the default view. I'd like to change it to MPG but can't find where to change this, I have to select it every time I go to the mileage logs...
  5. desdemona

    desdemona Well-Known Member

    Ok, this has more to do with looking at the files but it would be cool to be able to sort them. For instance, sort by transmission type, liter engine, brand/model, etc.

  6. Dan

    Dan KiloTanked in post 153451

    I've posted a few threads on the CO2 cost (absolutely worse possible case coal scenario) of a kWh of electricity. I figure it comes out to somewhere between 2-10 oz of gasoline GHG-wise. There are wildly varying cost analysis of earth-to-outlet GHG emmisions for 1 kWh as well as cost analysis of well-to-wheel GHG emissions for a gallon of gas.

    Suffice to say that 1 kWh = ? oz of petroleum CHG-wise (where ? is between 2-10).

    I think it cool would be if we could put in kWh consumed (already there) and a conversion factor (not yet there) so that we can calculate MPG equivalent. As more and more people get a PHEV, it would be nice to have a way to compare efficiencies.

    An example would be if I burned 10gal of gas and 50 kWh of electricity over a span of 1500 miles my MPG would be 150 MPG, but if I factored in the 50 kWh using a conversion factor of ? = 10 then it would be closer to 107 MPG. That way my numbers don't skew as badly if I get lots of plug in trips.

  7. xcel

    xcel PZEV, there's nothing like it :) Staff Member

    Hi Dan:

    ___A bit OT … Oh how any of us would die to drive a mid-sized 4-door at 107 all-in or 150 mpg the old fashion way minus the electricity costs ;) No matter how we slice it, the PHEV’s are going to kick all our @$$’es and thank goodness they will too!

    ___Good Luck

  8. tbaleno

    tbaleno Well-Known Member

    You can do that already. If it doesn't work then it is broke, but in theory it should work. Have you tried it? It converts electricity to mpg using the same calculation as the government does I believe. (It has been over a year since I wrote that bit of code so I don't remember the details).
  9. MnFocus

    MnFocus hanging member :)

    I was wondering if the column 'headers' could be made user selectable? ie I drive a gas powered vehicle but yet all the ev vehicle info has to be waded through to make/read an entry. It may be something simple such as allowing a user to toggle the headers.
  10. MnFocus

    MnFocus hanging member :)

    I don't think I'd die ...but I would be in my own lil heaven with such a choice .
  11. tbaleno

    tbaleno Well-Known Member

    I intend on doing it that way. If anyone is familiar with the standings page on, what they do/did is what I have always planned on. Toggle off and on which columns you want to see.
  12. MnFocus

    MnFocus hanging member :)

    :) Good deal then ...I'm glad to not be alone with that thought. I'll be patient ;)
  13. Devinator

    Devinator Hypermilin Fugitive

    Hi, I am kind of new here and have only logged a few tanks in the mileage logs. It looks like the system calculates the combined EPA estimate by averaging the city and highway estimates which is not always the same as the combined EPA estimate. For example my car gets 18 city and 24 highway which the mileage logs calculate to be 21, but the EPA combined estimate is 20. So instead of saying 128.22% of combined EPA, my signature should say 134.63%. Maybe you could change it so members could manually enter the combined EPA estimate when they add their car to the garage.

    Thank you
  14. xcel

    xcel PZEV, there's nothing like it :) Staff Member

    Hi Devinator:

    ___What shows up in your sig s the 85-07 EPA city/highway but we calc your actual FE as a % against a 50/50 mix vs. the EPA’s 45/55% mix. When looking at the real world, there is no way to actually come up with a mix as every singe persons commute is different from the EPA’s mix even if (2) members were neighbors and worked at the same building for the same company. The vehicles will never follow the same path as one goes to get grocery’s or the HW store and the other drives to pick up videos. Tom and I were having discussions about this before the Mileage DBase was built and decided to make it simple for everyone by using a 50/50 split vs. the actual to calculate your %’s.

    ___You can enter in whatever EPA numbers you want as it can be overridden but please enter in the 85 – 07 other then those owning the 08’s for now as we have two separate criteria for the older models vs. the 08’s and later.

    ___Good Luck

  15. Devinator

    Devinator Hypermilin Fugitive

    That makes sense. Thanks Wayne
  16. PaleMelanesian

    PaleMelanesian Beat the System Staff Member

    About the much-requested "sort by %epa" feature, what about just making the Status column sortable? El(ite) comes before Ex(pert) comes before S(killed). That should be a quick change to implement, right?
  17. nhbubba

    nhbubba Truckzilla driver

    Mass tank entry/import

    Forgive me if this has been asked and answered already, but I am striking out w/ the search feature. Quite frankly I'm not even sure what terms to use when searching.

    I am meticulous about keeping a fuel log for my vehicles. I have a log of nearly every drop of fuel run through my current vehicles as well as over 2 years of data for my previous vehicle. I keep a pen and paper log in each vehicle that is updated at each fill-up. Periodically I manually enter this data into an MS Excel spreadsheet. I would like to contribute this data to the database, however I have literally several hundred tank entries. Is there a way to import or enter a large number of 'tanks' at a time?

    In my pen & paper log I keep date, total cost of fill-up, total volume of fuel pumped, and current odometer reading. From this I can calculate (and export) date, volume, change in mileage, and cost/volume of the fuel.

  18. xcel

    xcel PZEV, there's nothing like it :) Staff Member

    Hi Nhbubba:

    ___I wish I had better news. Tom built a conversion for some types of web based data but not a straight up spreadsheet and into the DBase unfortunately :( It is back to the manual entry method for now.

    ___Good Luck

  19. Dan

    Dan KiloTanked in post 153451

    Anyone feeling ambitions with their WSH Muscles?

    ExcelApp = new ActiveXObject("Excel.Application");
    IEApp = new ActiveXObject("InternetExplorer.Application");
    // Open spread sheet
    oWorkBook = ExcelApp.Workbooks.Open("c:\MyTankData.xls);
    // TODO: Figure out your Excel topology and determine how many tanks there are,
    //       dump value in iTanks
    // TODO: Figure out your car id and fill it into iCar
    var iTanks;
    for(i = 0; i < iTanks; i++)
       // TODO: For each tank, dump correct values into 
                sMonth, sDay, sYear, sDistance and sGallons
       var sMonth = IEApp....
       var sDay = IEApp....
       var sYear = IEApp....
       var sDistance = IEApp....
       var sGallons = IEApp....
       // TODO: Figure out your car id and fill it into iCar
       var iCar;
       IEApp.Navigate("" + iCar);
       // TODO: Find which event fires on "done" and spin till it fires.
       // Grab FORM with id "main"
       oMainForm = IEApp.Document.getElementsByTagName("form").item("main");
       oMainForm.month.Value = sMonth; = sDay;
       oMainForm.year.Value = sYear;
       oMainForm.distance.Value = sDistance;
       oMainForm.fuel_used.Value = sGallons;

  20. nd4speed7

    nd4speed7 Well-Known Member

    Could the EPA standards be calculated on the % city/highway driving? My last tank was completely city so it makes my mileage look worse since I couldn't make it to my cars average.

Share This Page