WBO2-Tuning Spreadsheet

[Kitch]

Hi Dave,

I'd like to try and use your Wideband spreadsheet but I'm having a problem. I'm guessing your spreadsheet is designed to take the original "WBO2 AFR" .csv info from the "Data Log" but I'm using an Inovate MTX-L WB AFR gauge hooked up to my Autoprom, while I've managed to set up a history table showing my Wideband AFR's I haven't managed to get that information into the "Data Log" for export to your spreadsheet.
I'm not using the hack where the Wideband O2 sensor output is supplied to the PCM via re-tasked EGR output and I'm guessing that's thats what the Data Log is expecting.
I'm not sure how to get my MTX-L WB AFR outputs into the Data log in the "WBO2 AFR" location so that your spreadsheet can then use the data or is there another way to get the info into your spreadsheet?

[dave w]

I'm not sure how to get my MTX-L WB AFR outputs into the Data log in the "WBO2 AFR" location so that your spreadsheet can then use the data or is there another way to get the info into your spreadsheet?

The use of the Autoprom is not required to get the WBO2 information into the data log. The 0v ~ 5v output from the MTX-L has to be wired directly into the computer, pin B16. See attached screen shot.

The MTX-L will need to be re-programmed for 0v = 10 AFR / 5v = 20 AFR

dave w

[Kitch]

Hi Dave,

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

[dave w]

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

[Kitch]

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.

[dave w]

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

[Kitch]

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?

[De-stroker]

The use of the Autoprom is not required to get the WBO2 information into the data log. The 0v ~ 5v output from the MTX-L has to be wired directly into the computer, pin B16. See attached screen shot.

The MTX-L will need to be re-programmed for 0v = 10 AFR / 5v = 20 AFR

dave w

Im gonna try this with my lc-2

[dzidaV8]

Hi Dave, I'm wondering why are you filtering only closed loop data for WBO2 corrections? It doesn't make sense to me, as BLMs will change WB readout in CL.

[dave w]

Hi Dave, I'm wondering why are you filtering only closed loop data for WBO2 corrections? It doesn't make sense to me, as BLMs will change WB readout in CL.

I use WBO2 data from open loop AE and PE when the computer locks the BLM's to 128. CL WBO2 data will validate the corrections to the VE tables for rich or lean BLM's. A VE table causing rich or lean BLM's will also cause rich or lean WBO2 data in CL. BLM corrections have a limited ability to correct for rich or lean conditions. I've tuned several vehicles with AFR's. The WBO2 tuned vehicles run better, have fewer emissions, and achieve better MPG using CL WBO2 data.

dave w

[dzidaV8]

I've always disabled CL when tuning with WB to prevent BLMs messing up the calculations. I've never thought about doing it in CL but I guess it can make sense. By the way, some ECMs still use BLM corrections in PE, but only when BLM>128

[MAC]

Firstly let me say thanks to everyone for contributing to this thread. I am working through this and making changes to my tune.

I am trying to understand what I am actually doing and where this will get me. I think that this spreadsheet will help get my VE tables “correct”. It does this by using WBO2 readings when:

1. The computer is in closed loop
2. The computer is in open loop AND the BLM=128

The spreadsheet finds areas where the tune is not at stoich and then either adds or subtracts from the VE% table. This will subsequently add or subtract fuel to move everything towards stoich.

Is what I said above correct? Please set me straight if I am wrong.

My expectation is that I will end up with a tune that looks something like the attached picture. But I could be wrong.

afrtable.GIF

So my biggest question is this:

• I do not understand how this process will get me to a tune that looks like the attached picture because it seems like this process is moving everything towards stoich.

BTW – I set the spreadsheet to 14.1 because all of the gas around me is E10.

Thanks,

MAC

[tony-baroni]

HI Dave W, I've seen in many of your posts you're referring to screen shots, which I cannot see on my viewer. Any suggestions on how to enable that?

I am logged in.
I have set my "general settings" to show images.

[dave w]

Earlier this year there was a issue with some files / attachments missing after an update. What thread and post do you need the screen shots for? It's likely I need to report the missing screen shots.

dave w

[tony-baroni]

Thanks Dave W.

It's this thread, your posts, #5 and #15.

I'm interested in your use of the ECM as a way to use WBO2, as I'm about to purchase either a BURN2 and Ostrich 2.0, or a APU1. I'm leaning towards the lower cost BURN + Ostrich, especially if I can use the ECM for a future WBO2 sensor. Thank you for sharing your tools an expertise on this forum!