Results 1 to 5 of 5

Thread: Histogram viewing of xls files?

  1. #1
    Administrator
    Join Date
    May 2011
    Location
    Lakes Region, NH
    Age
    54
    Posts
    3,847

    Histogram viewing of xls files?

    Many people post recorded TunerPro data as Excel .xls data. It's nice because it's a somewhat universal format these days (there are free programs which will read this proprietary data format). Viewing this data in Excel provides a nice static way to look at what's happening but finding key events (changes in data) often requires several steps to re-order, re-group, and discard unwanted information. It doesn't take long for my poor mind to get bored and shut down during this process. Is there an easy method to view these sometimes large data files as a line graph or histogram? Or has all this been put to rest with the latest version of TunerPro?

    Tx.

  2. #2
    RIP EagleMark's Avatar
    Join Date
    Feb 2011
    Location
    North Idaho
    Age
    63
    Posts
    10,477
    Was there something like this in an old TunerPro?

    You can make a history table in TunerPro, like BLM and it even gives an option for History Standard Deviation for each cell (amount to change VE table by).

    Line graph would be monitors.

    1990 Chevy Suburban 5.7L Auto ECM 1227747 $42!
    1998 Chevy Silverado 5.7L Vortec 0411 Swap to RoadRunner!
    -= =-

  3. #3
    Administrator
    Join Date
    May 2011
    Location
    Lakes Region, NH
    Age
    54
    Posts
    3,847
    Does this work if you want to view data that someone else posted as an xls file?

  4. #4
    RIP EagleMark's Avatar
    Join Date
    Feb 2011
    Location
    North Idaho
    Age
    63
    Posts
    10,477
    No it would have to be the original TunerPro xdl file. Unless there is a way to convert xls back to xdl? TunerPro will spit out the xdl in several different spreadsheet formats, I forget which and don't remember ever seeing a way to import from spreadsheet?

    1990 Chevy Suburban 5.7L Auto ECM 1227747 $42!
    1998 Chevy Silverado 5.7L Vortec 0411 Swap to RoadRunner!
    -= =-

  5. #5
    Super Moderator dave w's Avatar
    Join Date
    Feb 2011
    Posts
    6,268
    Quote Originally Posted by 1project2many View Post
    Many people post recorded TunerPro data as Excel .xls data. It's nice because it's a somewhat universal format these days (there are free programs which will read this proprietary data format). Viewing this data in Excel provides a nice static way to look at what's happening but finding key events (changes in data) often requires several steps to re-order, re-group, and discard unwanted information. It doesn't take long for my poor mind to get bored and shut down during this process. Is there an easy method to view these sometimes large data files as a line graph or histogram? Or has all this been put to rest with the latest version of TunerPro?

    Tx.
    The Line Chart from the insert tab will do a graph. There are many options for graphs with Excel. Highlight a column and select the graph you would like. I use the simple line chart. Holding down the Ctrl key when selecting more than one column will get two or more lines in the chart.

    dave w
    Attached Images Attached Images

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •