Page 2 of 6 FirstFirst 123456 LastLast
Results 16 to 30 of 87

Thread: WBO2-Tuning Spreadsheet

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

    So unless I want to disable my EGR there is no other way to use your spreadsheet?

  2. #17
    Super Moderator dave w's Avatar
    Join Date
    Feb 2011
    Posts
    6,369
    Quote Originally Posted by Kitch View Post
    Hi Dave,

    So unless I want to disable my EGR there is no other way to use your spreadsheet?
    Can you post a .csv file with the Autoprom data? I might be able make changes to the spreadsheet allowing the Autoprom WBO2 data.

    dave w

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

    That would be great if you could.
    I've attached the full .csv file from a logged run, the "MTX-L WB AFR" output is in column "EV".
    Hopefully you can successfully unzip the compressed .csv file.

  4. #19
    Super Moderator dave w's Avatar
    Join Date
    Feb 2011
    Posts
    6,369
    The spreadsheet formulas are set up for the following columns:

    Column AJ=Closed (Closed Loop Status) - Open loop data will not be calculated - your Test csv1.csv has all open loop data in Column AK, so even if Column AK data was copy / pasted in Column AJ the spreadsheet would not show data. The spreadsheet filters out open loop data.

    Column DT=On (Idle Flag Status) On = Near Idle data ~ Off = Off Idle (the main motivation for the spreadsheet in the first place!)

    Column FD=Inactive (Power Enrichment) PE - Active ~ Inactive - The spreadsheet has a separate sheet that will calculate the AFR's when PE is Active.

    Column O=Inactive ( Acceleration Enrichment) AE - Active ~ Inactive - The spreadsheet filters out AE active data.

    Column HK = AFR Data

    You could copy / paste your spreadsheet columns so they will align with the spreadsheet formulas?

    dave w

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

    I played around with my data log and moved things around so that the csv file could be copied directly into your spreadsheet without cutting and pasting.
    The only manual change I had to make was to change all the AJ "open" loop cells to "closed" to make it work.

    On a side note I also managed to break my dashboard slightly, any idea how to add the missing block?

  6. #21
    Super Moderator dave w's Avatar
    Join Date
    Feb 2011
    Posts
    6,369
    Quote Originally Posted by Kitch View Post
    On a side note I also managed to break my dashboard slightly, any idea how to add the missing block?
    Nice work, figuring out the .csv configuration for the WBO2 spreadsheet!

    Maybe you need to reconfigure a gauge and set a value, using the Acquisition edit menu, see attached pics.

  7. #22
    Fuel Injected!
    Join Date
    Feb 2015
    Location
    New Zealand
    Age
    54
    Posts
    280
    Yep, you were right.
    I'd tried to do it before but I couldn't figure it out (must have been too late at night!), I had another look at it and straight away I could see the segment percentage values. All I had to do was create another gauge and figure out what percentages were needed based on the surrounding segment values and there it was!

  8. #23
    Fuel Injected!
    Join Date
    Dec 2016
    Location
    Colorado
    Age
    39
    Posts
    120
    Hey Dave, I was wondering if I could get a copy of the WBo2 spreadsheet? I looked through this thread and couldnt find any files. Also, does the spreadsheet allow for WBo2 through the autoprom? or do I have to wire to egr pintle?Thanks in advance

  9. #24
    Super Moderator dave w's Avatar
    Join Date
    Feb 2011
    Posts
    6,369
    I re-posted the .zip file, look back at post #1 of this thread. ... dave w

  10. #25
    Super Moderator dave w's Avatar
    Join Date
    Feb 2011
    Posts
    6,369
    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

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

    dave w
    Attached Images Attached Images

  12. #27
    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?

  13. #28
    Super Moderator dave w's Avatar
    Join Date
    Feb 2011
    Posts
    6,369
    Quote Originally Posted by Kitch View Post
    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?
    The values in the lower tables of the first two photo's are counts of how many records (data points) were recorded in that cell. For example the first photo "Near Idle" had 814 data points at 600 RPM's / 40 Kpa.

    dave w

  14. #29
    Fuel Injected!
    Join Date
    Feb 2015
    Location
    Ogden, UT
    Age
    40
    Posts
    139
    Awesome work on the spreadsheet Dave! I have a few questions - What filters are you using for the averageifs on WBO2 and SA history tables? I copied in a set of data from a log I had to try it out and I'm not seeing any data populating in the history tables? The columns in the Insert Datalog sheet match up. Also for this log, I forced Open Loop and PE is disabled.
    1990 Chevrolet K2500, RCLB, Blueprint 383 TBI (16197427 ECM / 61 lb/hr / 16 psi FP), NV4500, NP241C, 4.10

  15. #30
    Fuel Injected!
    Join Date
    Feb 2015
    Location
    New Zealand
    Age
    54
    Posts
    280
    Thanks for the simple answer Dave and nice work with the spreadsheet.

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 Daves 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
  •