EBL WBO2 Tuning Spreadsheet - Third Generation F-Body Message Boards

Go Back  Third Generation F-Body Message Boards > Tech Boards > DIY PROM
Reload this Page >

EBL WBO2 Tuning Spreadsheet

DIY PROM Do It Yourself PROM chip burning help. No PROM begging. No PROMs for sale. No commercial exchange. Not a referral service.

EBL WBO2 Tuning Spreadsheet

Reply

Old 11-29-2018, 10:33 AM
  #1  
Member
Thread Starter
 
dave w's Avatar
 
Join Date: Nov 2008
Posts: 167
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







dave w is offline  
Reply With Quote
Old 11-29-2018, 12:51 PM
  #2  
Sponsor
iTrader: (80)
 
Tuned Performance's Avatar
 
Join Date: Dec 2004
Location: Mile High Country !!!
Posts: 10,872
Car: 1967 Camaro, 91 z28
Engine: Lb9
Transmission: M20
Axle/Gears: J65 pbr on stock posi 10bolt
Re: EBL WBO2 Tuning Spreadsheet

Very cool
Tuned Performance is offline  
Reply With Quote
Old 12-04-2018, 10:32 AM
  #3  
Junior Member
 
RJ IROC's Avatar
 
Join Date: Apr 2013
Location: Saint Louis, Missouri
Posts: 19
Car: 1985 Camaro IROC-Z
Engine: 383 HSR Comp XFI280HR Profiler 195s
Transmission: T5
Axle/Gears: 3.73 Posi
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!
RJ IROC is offline  
Reply With Quote
Old 12-04-2018, 12:17 PM
  #4  
Supreme Member
 
Join Date: Jan 2003
Posts: 2,607
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.
ULTM8Z is offline  
Reply With Quote
Old 12-04-2018, 02:56 PM
  #5  
Member
Thread Starter
 
dave w's Avatar
 
Join Date: Nov 2008
Posts: 167
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
dave w is offline  
Reply With Quote
Old 12-04-2018, 03:09 PM
  #6  
Junior Member
 
RJ IROC's Avatar
 
Join Date: Apr 2013
Location: Saint Louis, Missouri
Posts: 19
Car: 1985 Camaro IROC-Z
Engine: 383 HSR Comp XFI280HR Profiler 195s
Transmission: T5
Axle/Gears: 3.73 Posi
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.
RJ IROC is offline  
Reply With Quote
Old 12-04-2018, 05:30 PM
  #7  
Member
Thread Starter
 
dave w's Avatar
 
Join Date: Nov 2008
Posts: 167
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
dave w is offline  
Reply With Quote
Old 12-04-2018, 11:57 PM
  #8  
Junior Member
 
RJ IROC's Avatar
 
Join Date: Apr 2013
Location: Saint Louis, Missouri
Posts: 19
Car: 1985 Camaro IROC-Z
Engine: 383 HSR Comp XFI280HR Profiler 195s
Transmission: T5
Axle/Gears: 3.73 Posi
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!
RJ IROC is offline  
Reply With Quote
Old 12-05-2018, 10:19 AM
  #9  
Member
Thread Starter
 
dave w's Avatar
 
Join Date: Nov 2008
Posts: 167
Re: EBL WBO2 Tuning Spreadsheet

Originally Posted by RJ IROC View Post
I might play with this a little, and try to come up with something useful.
Interesting thought: Actual Spark Advance vs. Spark Table / Actual AFR vs. VE Learns .... something useful not provided by the WUD? Useful data that might or might not leave the competition looking at tail lights vs chasing tail lights.

Agreed, staying ahead of the competition is TEDIOUS!

dave w
dave w is offline  
Reply With Quote
Old 12-05-2018, 10:38 AM
  #10  
Junior Member
 
RJ IROC's Avatar
 
Join Date: Apr 2013
Location: Saint Louis, Missouri
Posts: 19
Car: 1985 Camaro IROC-Z
Engine: 383 HSR Comp XFI280HR Profiler 195s
Transmission: T5
Axle/Gears: 3.73 Posi
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!
RJ IROC is offline  
Reply With Quote
Old 12-05-2018, 01:48 PM
  #11  
Member
Thread Starter
 
dave w's Avatar
 
Join Date: Nov 2008
Posts: 167
Re: EBL WBO2 Tuning Spreadsheet

Originally Posted by RJ IROC View Post
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!
Some call that "Tuning"

dave w
dave w is offline  
Reply With Quote
Old 12-05-2018, 02:09 PM
  #12  
Supreme Member
 
Join Date: Jan 2003
Posts: 2,607
Re: EBL WBO2 Tuning Spreadsheet

Originally Posted by RJ IROC View Post
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.
Send me an e-mail... I'll e-mail you the file. Though, mine only works when using the S_AUJP suite of files... .bin, .adx, and .xdf

[email protected]
ULTM8Z is offline  
Reply With Quote
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
69sixpackbee
Engine/Drivetrain/Suspension Parts for Sale
5
07-01-2011 10:38 PM
BronYrAur
TBI
6
11-12-2007 07:45 PM
Scott T
DIY PROM
1
08-14-2003 08:42 PM
87_TA
DIY PROM
4
01-19-2003 12:15 AM
Damon
Carburetors
2
11-13-2000 11:32 AM


Thread Tools
Search this Thread
Quick Reply: EBL WBO2 Tuning Spreadsheet


Advertising
Featured Sponsors
Vendor Directory

Contact Us Advertising Cookie Policy Privacy Statement Terms of Service

We are a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for us to earn fees by linking to Amazon.com and affiliated sites.
 
  • Ask a Question
    Get answers from community experts
Question Title:
Description:
Your question will be posted in: