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

Thread Tools
 
Search this Thread
 
Old 11-29-2018, 09:33 AM
  #1  
Member

Thread Starter
 
dave w's Avatar
 
Join Date: Nov 2008
Posts: 167
Likes: 0
Received 0 Likes on 0 Posts
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







Old 11-29-2018, 11:51 AM
  #2  
Sponsor

iTrader: (92)
 
Tuned Performance's Avatar
 
Join Date: Dec 2004
Location: Mile High Country !!!
Posts: 15,408
Received 649 Likes on 573 Posts
Car: 1967 Camaro, 91 z28
Engine: Lb9
Transmission: M20
Axle/Gears: J65 pbr on stock posi 10bolt
Re: EBL WBO2 Tuning Spreadsheet

Very cool
Old 12-04-2018, 09:32 AM
  #3  
Member

 
RJ IROC's Avatar
 
Join Date: Apr 2013
Location: Saint Louis, Missouri
Posts: 120
Received 15 Likes on 13 Posts
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!
Old 12-04-2018, 11:17 AM
  #4  
Supreme Member

 
ULTM8Z's Avatar
 
Join Date: Jan 2003
Posts: 4,035
Received 193 Likes on 167 Posts
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.
Old 12-04-2018, 01:56 PM
  #5  
Member

Thread Starter
 
dave w's Avatar
 
Join Date: Nov 2008
Posts: 167
Likes: 0
Received 0 Likes on 0 Posts
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
Old 12-04-2018, 02:09 PM
  #6  
Member

 
RJ IROC's Avatar
 
Join Date: Apr 2013
Location: Saint Louis, Missouri
Posts: 120
Received 15 Likes on 13 Posts
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.
Old 12-04-2018, 04:30 PM
  #7  
Member

Thread Starter
 
dave w's Avatar
 
Join Date: Nov 2008
Posts: 167
Likes: 0
Received 0 Likes on 0 Posts
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
Old 12-04-2018, 10:57 PM
  #8  
Member

 
RJ IROC's Avatar
 
Join Date: Apr 2013
Location: Saint Louis, Missouri
Posts: 120
Received 15 Likes on 13 Posts
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!
Old 12-05-2018, 09:19 AM
  #9  
Member

Thread Starter
 
dave w's Avatar
 
Join Date: Nov 2008
Posts: 167
Likes: 0
Received 0 Likes on 0 Posts
Re: EBL WBO2 Tuning Spreadsheet

Originally Posted by RJ IROC
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
Old 12-05-2018, 09:38 AM
  #10  
Member

 
RJ IROC's Avatar
 
Join Date: Apr 2013
Location: Saint Louis, Missouri
Posts: 120
Received 15 Likes on 13 Posts
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!
Old 12-05-2018, 12:48 PM
  #11  
Member

Thread Starter
 
dave w's Avatar
 
Join Date: Nov 2008
Posts: 167
Likes: 0
Received 0 Likes on 0 Posts
Re: EBL WBO2 Tuning Spreadsheet

Originally Posted by RJ IROC
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
Old 12-05-2018, 01:09 PM
  #12  
Supreme Member

 
ULTM8Z's Avatar
 
Join Date: Jan 2003
Posts: 4,035
Received 193 Likes on 167 Posts
Re: EBL WBO2 Tuning Spreadsheet

Originally Posted by RJ IROC
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

ultm8z@yahoo.com
Old 02-03-2019, 01:58 PM
  #13  
Member

iTrader: (2)
 
dfarr67's Avatar
 
Join Date: Sep 2009
Posts: 330
Received 2 Likes on 1 Post
Re: EBL WBO2 Tuning Spreadsheet

Any updates?
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
69sixpackbee
Engine/Drivetrain/Suspension Parts for Sale
5
07-01-2011 09:38 PM
BronYrAur
TBI
6
11-12-2007 06:45 PM
Scott T
DIY PROM
1
08-14-2003 07:42 PM
87_TA
DIY PROM
4
01-18-2003 11:15 PM
Damon
Carburetors
2
11-13-2000 10:32 AM



Quick Reply: EBL WBO2 Tuning Spreadsheet



All times are GMT -5. The time now is 07:35 PM.