Page 1 of 2 12 LastLast
Results 1 to 15 of 87

Thread: WBO2-Tuning Spreadsheet

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Super Moderator dave w's Avatar
    Join Date
    Feb 2011
    Posts
    6,268

    WBO2-Tuning Spreadsheet

    Attached in the .zip file is a '7427 Excel spreadsheet (Protected) that will allow pasting a .csv file into the spreadsheet to view the WBO2 averages for tuning. The WBO2 data is filtered and sorted, Closed Loop, Near Idle Flag (on / off), AE, and PE. See sample screen shots. After data logging with TunerPro RT, export the data log to a .csv file. To use the spreadsheet your data log must have WBO2 data, instruction included in the .zip file. WBO2 tuning is a must for any modified engine. dave w
    Attached Files Attached Files
    Last edited by dave w; 08-10-2020 at 07:06 PM.

  2. #2
    Fuel Injected!
    Join Date
    Jul 2012
    Location
    Fresno, CA
    Posts
    422
    Thanks Dave! I'll have to try this out soon.
    1973 K-5 Blazer, TBI 350, TH400, 1 ton axles & 38" SSRs'
    1975 280Z, TBI 350, 700R4
    1953 M-38A1, TBI Buick 231
    1951 Ford Panel, 5.3 with 4L80E

  3. #3
    Super Moderator dave w's Avatar
    Join Date
    Feb 2011
    Posts
    6,268
    Quote Originally Posted by fastacton View Post
    Thanks Dave! I'll have to try this out soon.
    Please update me with your thoughts / results after using the spreadsheet.

    dave w

  4. #4
    Fuel Injected!
    Join Date
    Sep 2018
    Posts
    43
    Quote Originally Posted by dave w View Post
    Please update me with your thoughts / results after using the spreadsheet.

    dave w
    I obviously have a lot of learning to do. I guess I need a chips for dummies course first.

  5. #5
    Fuel Injected! CDeeZ's Avatar
    Join Date
    May 2012
    Location
    Jokelahoma
    Posts
    422
    Dave, a few questions.

    What is the password to unprotect the spreadsheet. I can't edit or enter any data into it.

    And, I'm using Gregs Advanced $0E TP5 v252.xdf. It has only one WB02 table. It appears to resemble something close to Open Throttle in the 7427 with $0E. I can extrapolate data to come up with values to tune the idle table, I'd likely just copy what I have from the main Open Throttle VE table. This particular XDF also goes up in MAP in increments of 5 KPA... Which both tables in the 7427 start going up in increments of 10 KPA after what, 40 KPA?

  6. #6
    Fuel Injected! CDeeZ's Avatar
    Join Date
    May 2012
    Location
    Jokelahoma
    Posts
    422
    Nevermind I got past the password protect I had to enable editing, oops.


    I have tried pasting in the entire CSV file generated by TPRT into the spreadsheet, as well as pasting just the AFR data into it. Also pasted in the existing VE tables of course and the spreadsheet keeps spitting out the exact same values of the existing VE tables? What am I missing here?

  7. #7
    Super Moderator dave w's Avatar
    Join Date
    Feb 2011
    Posts
    6,268
    Please post the TPRT .ADX file and .XDL file you are working with.

    Gregs Advanced $OE TP5 v252.xdf definition file is for editing the .bin file, not data logging.

    dave w

  8. #8
    Fuel Injected!
    Join Date
    Oct 2013
    Posts
    1,022
    You can use a if(ISERROR(... test to set the cells to "" instead of displaying the div/0 errors. You do have to repeat the formula twice but it makes it much prettier to look at.

    The next thing to do is add a count and desired AFR cell and use those to create another table with the amount of error or correction factor.

  9. #9
    Super Moderator dave w's Avatar
    Join Date
    Feb 2011
    Posts
    6,268
    The cells count table is below the AFR tables.

    I'm working on the layout, see attached.

    dave w

  10. #10
    Fuel Injected!
    Join Date
    Oct 2013
    Posts
    1,022
    Not a counts table, a cell with the minimum number of records before you use the average so you don't get a small number of results messing up the data.

    You can then use the counts to add another table that shows either percentage error, or lambda which is basically the same thing.

  11. #11
    Super Moderator dave w's Avatar
    Join Date
    Feb 2011
    Posts
    6,268
    Quote Originally Posted by lionelhutz View Post
    Not a counts table, a cell with the minimum number of records before you use the average so you don't get a small number of results messing up the data.

    You can then use the counts to add another table that shows either percentage error, or lambda which is basically the same thing.
    I've been thinking deviation, minimum, maximum, & range information is available in TunerPro RT? Basically I wanted the spreadsheet cells to align with the VE tables / filter closed loop / near idle / off idle / power enrichment, which is not filtered in TunerPro RT.

    dave w

  12. #12
    LT1 specialist steveo's Avatar
    Join Date
    Aug 2013
    Posts
    4,007
    Not a counts table, a cell with the minimum number of records before you use the average so you don't get a small number of results messing up the data.
    i agree, without enforcing a minimum cell count, you will end up with erroneous spikes in your data from cells with only one or two records that averaging hasn't been able to smooth out.

    you should also provide a percentage against target AFR data, if any is available, people find that really handy.

    im not entirely sure how to do this stuff with a spreadsheet. this is the kind of stuff that always drove me towards programmed tools for analysis.

    really wish tunerpro had filtering in its history tables.....

  13. #13
    Super Moderator dave w's Avatar
    Join Date
    Feb 2011
    Posts
    6,268
    Quote Originally Posted by lionelhutz View Post
    You can use a if(ISERROR(... test to set the cells to "" instead of displaying the div/0 errors. You do have to repeat the formula twice but it makes it much prettier to look at.
    Updated spreadsheet to make it prettier to look at. see attached

    dave w
    Attached Files Attached Files

  14. #14
    Super Moderator dave w's Avatar
    Join Date
    Feb 2011
    Posts
    6,268
    Pics from using the spreadsheet to "CRUNCH" the data log.

    dave w
    Attached Images Attached Images

  15. #15
    Fuel Injected!
    Join Date
    Feb 2015
    Location
    New Zealand
    Age
    54
    Posts
    280
    Hi Dave,

    I'm sure there's an obvious answer but in the first two photos whats up with the values in the in the lower tables, they seem quite a bit different from the values in the upper tables?

Similar Threads

  1. TBI WBO2 Tuning- Dyno Results
    By dave w in forum GM EFI Systems
    Replies: 16
    Last Post: 04-28-2019, 10:34 PM
  2. quick question on ve tuning $0E with spreadsheet
    By skandolis in forum GM EFI Systems
    Replies: 1
    Last Post: 03-23-2018, 03:26 PM
  3. Tunerpro RT tuning VE table on the fly with WBO2
    By rsicard in forum GM EFI Systems
    Replies: 1
    Last Post: 11-12-2016, 06:33 AM
  4. VE BLM tuning via Dave’s spreadsheet
    By majacoby in forum GM EFI Systems
    Replies: 42
    Last Post: 11-07-2013, 04:31 AM
  5. part throttle VE tuning with WBo2
    By PJG1173 in forum GM EFI Systems
    Replies: 50
    Last Post: 11-16-2012, 12:10 AM

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
  •