EBL WBO2 Tuning Spreadsheet
#1
EBL WBO2 Tuning Spreadsheet
Sample screen shots of an EBL WBO2 tuning spreadsheet I've been working on. Copy paste the exported EBL .csv into a spreadsheet for "Closed Loop" tuning data. I'm trying to figure out the Knock Retard worksheet.
Thoughts / Suggestions are welcomed.
dave w
Thoughts / Suggestions are welcomed.
dave w
#3
Member
Re: EBL WBO2 Tuning Spreadsheet
This is super cool. Any interest in sharing? I'm good with excel, just haven't tried anything like this before.
I think it would be worthwhile to create a sheet that can give you the average difference in observed AFR, or even a difference in BLMs, versus airflow over the course of a log. That has the potential to make tuning IAT values incredibly straightforward.
I'd also be interested in a sheet that could analyze acceleration enrichment, or at least compare average differences of delta TPS AE effects on the AFR.
I'm sure I could come up with more over time. Really digging your spreadsheet though! Let me know if you mind sharing!
I think it would be worthwhile to create a sheet that can give you the average difference in observed AFR, or even a difference in BLMs, versus airflow over the course of a log. That has the potential to make tuning IAT values incredibly straightforward.
I'd also be interested in a sheet that could analyze acceleration enrichment, or at least compare average differences of delta TPS AE effects on the AFR.
I'm sure I could come up with more over time. Really digging your spreadsheet though! Let me know if you mind sharing!
#4
Re: EBL WBO2 Tuning Spreadsheet
i did something with a IAT tuning tool a while ago...
https://www.thirdgen.org/forums/diy-prom/747591-mat-analysis-tool.html
it basically eliminates all other variables and reduces the data down to just AFR vs IAT.
https://www.thirdgen.org/forums/diy-prom/747591-mat-analysis-tool.html
it basically eliminates all other variables and reduces the data down to just AFR vs IAT.
#5
Re: EBL WBO2 Tuning Spreadsheet
The spreadsheet is for the Dynamic EFI - EBL System, still interested?
I was commissioned to author the Spreadsheet, so I'm only comfortable sharing the "Base Formulas" to build / create / author a spreadsheet.
Hint:
Average If ... https://support.office.com/en-us/art...9-f5576d8ac642
Count If ... https://support.office.com/en-us/art...4-1f464816df34
dave w
I was commissioned to author the Spreadsheet, so I'm only comfortable sharing the "Base Formulas" to build / create / author a spreadsheet.
Hint:
Average If ... https://support.office.com/en-us/art...9-f5576d8ac642
Count If ... https://support.office.com/en-us/art...4-1f464816df34
dave w
#6
Member
Re: EBL WBO2 Tuning Spreadsheet
Still interested Dave. I've been tuning with the EBL for a few years now, and this would be a great tool to work with. I checked out the the tool that ULTM8Z talked about, and I'm interested in that as well. The link for the ULTM8Z MAT tool wasn't working, so I haven't been able to download it yet. I would imagine the MCC works similar to the IAT calculations of the EBL. Not sure exactly how the bias term of EBL works with an inverse MAT/MCC; it couldn't be as easy as inverting it could it? I'm lacking in knowledge of that part of the fueling calc.
#7
Re: EBL WBO2 Tuning Spreadsheet
The formula for WBO2 averaging "lower RPM cell 1200 RPM @ 50 Kpa" is: =AVERAGEIFS('Pasted CSV'!AW:AW,'Pasted CSV'!D: D,">=47.5",'Pasted CSV'!D: D,"<=52.49",'Pasted CSV'!B:B,">=1150",'Pasted CSV'!B:B,"<=1249",'Pasted CSV'!AC:AC,"=Y")
The formula for WBO2 averaging "upper RPM cell 3600 RPM @ 70 Kpa" is: =AVERAGEIFS('Pasted CSV'!AW:AW,'Pasted CSV'!D: D,">=67.5",'Pasted CSV'!D: D,"<=74.99",'Pasted CSV'!B:B,">=3500",'Pasted CSV'!B:B,"<=3799",'Pasted CSV'!AC:AC,"=Y")
The formula filters for closed loop WBO2 data which is column AW "IF" column AC = Y
The formula is specific to the VE table, meaning every cell in the VE table has it's own formula.
dave w
The formula for WBO2 averaging "upper RPM cell 3600 RPM @ 70 Kpa" is: =AVERAGEIFS('Pasted CSV'!AW:AW,'Pasted CSV'!D: D,">=67.5",'Pasted CSV'!D: D,"<=74.99",'Pasted CSV'!B:B,">=3500",'Pasted CSV'!B:B,"<=3799",'Pasted CSV'!AC:AC,"=Y")
The formula filters for closed loop WBO2 data which is column AW "IF" column AC = Y
The formula is specific to the VE table, meaning every cell in the VE table has it's own formula.
dave w
Trending Topics
#8
Member
Re: EBL WBO2 Tuning Spreadsheet
Thanks for that Dave!. I can see how the functions work, only averaging the values in between the RPM and KPA thresholds for each cell. The tedious part appears to be having to change the four thresholds in the formula of each cell. I might play with this a little, and try to come up with something useful. I'll post back here with any updates. Thanks again!
#9
Re: EBL WBO2 Tuning Spreadsheet
Agreed, staying ahead of the competition is TEDIOUS!
dave w
#10
Member
Re: EBL WBO2 Tuning Spreadsheet
Dave, that's a great idea. Leaving fueling constant, you could analyze how WOT AFR is affected by a change in timing. Visual display of a delta AFR for each of the RPM points among multiple advance curves would be interesting to see. Procedure would be pretty simple; make a few .bins with the only change being the advance at WOT, flash them, do a WOT pull, change to other bin, another pull, another WOT pull, another change...etc. Once done, chuck the three logs into a spreadsheet, Use fancy excel functions to grab relevant data from each log, and display the differences. Neat stuff!
#11
Re: EBL WBO2 Tuning Spreadsheet
Dave, that's a great idea. Leaving fueling constant, you could analyze how WOT AFR is affected by a change in timing. Visual display of a delta AFR for each of the RPM points among multiple advance curves would be interesting to see. Procedure would be pretty simple; make a few .bins with the only change being the advance at WOT, flash them, do a WOT pull, change to other bin, another pull, another WOT pull, another change...etc. Once done, chuck the three logs into a spreadsheet, Use fancy excel functions to grab relevant data from each log, and display the differences. Neat stuff!
dave w
#12
Re: EBL WBO2 Tuning Spreadsheet
Still interested Dave. I've been tuning with the EBL for a few years now, and this would be a great tool to work with. I checked out the the tool that ULTM8Z talked about, and I'm interested in that as well. The link for the ULTM8Z MAT tool wasn't working, so I haven't been able to download it yet. I would imagine the MCC works similar to the IAT calculations of the EBL. Not sure exacetly how the bias term of EBL works with an inverse MAT/MCC; it couldn't be as easy as inverting it could it? I'm lacking in knowledge of that part of the fueling calc.
ultm8z@yahoo.com
Thread
Thread Starter
Forum
Replies
Last Post
69sixpackbee
Engine/Drivetrain/Suspension Parts for Sale
5
07-01-2011 09:38 PM