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 Nov 29, 2018 | 09:33 AM
  #1  
dave w's Avatar
Thread Starter
Member
15 Year Member
 
Joined: Nov 2008
Posts: 167
Likes: 0
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







Reply
Old Nov 29, 2018 | 11:51 AM
  #2  
Tuned Performance's Avatar
Sponsor
20 Year Member
Community Builder
Community Influencer
Community Favorite
iTrader: (94)
 
Joined: Dec 2004
Posts: 16,754
Likes: 996
From: Mile High Country !!!
Car: 1967 Camaro, 91 z28
Engine: Lb9
Transmission: M20
Axle/Gears: J65 pbr on stock posi 10bolt
Re: EBL WBO2 Tuning Spreadsheet

Very cool
Reply
Old Dec 4, 2018 | 09:32 AM
  #3  
RJ IROC's Avatar
Member
10 Year Member
 
Joined: Apr 2013
Posts: 128
Likes: 22
From: Saint Louis, Missouri
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!
Reply
Old Dec 4, 2018 | 11:17 AM
  #4  
ULTM8Z's Avatar
Supreme Member
20 Year Member
 
Joined: Jan 2003
Posts: 4,626
Likes: 311
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.
Reply
Old Dec 4, 2018 | 01:56 PM
  #5  
dave w's Avatar
Thread Starter
Member
15 Year Member
 
Joined: Nov 2008
Posts: 167
Likes: 0
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
Reply
Old Dec 4, 2018 | 02:09 PM
  #6  
RJ IROC's Avatar
Member
10 Year Member
 
Joined: Apr 2013
Posts: 128
Likes: 22
From: Saint Louis, Missouri
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.
Reply
Old Dec 4, 2018 | 04:30 PM
  #7  
dave w's Avatar
Thread Starter
Member
15 Year Member
 
Joined: Nov 2008
Posts: 167
Likes: 0
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
Reply
Old Dec 4, 2018 | 10:57 PM
  #8  
RJ IROC's Avatar
Member
10 Year Member
 
Joined: Apr 2013
Posts: 128
Likes: 22
From: Saint Louis, Missouri
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!
Reply
Old Dec 5, 2018 | 09:19 AM
  #9  
dave w's Avatar
Thread Starter
Member
15 Year Member
 
Joined: Nov 2008
Posts: 167
Likes: 0
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
Reply
Old Dec 5, 2018 | 09:38 AM
  #10  
RJ IROC's Avatar
Member
10 Year Member
 
Joined: Apr 2013
Posts: 128
Likes: 22
From: Saint Louis, Missouri
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!
Reply
Old Dec 5, 2018 | 12:48 PM
  #11  
dave w's Avatar
Thread Starter
Member
15 Year Member
 
Joined: Nov 2008
Posts: 167
Likes: 0
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
Reply
Old Dec 5, 2018 | 01:09 PM
  #12  
ULTM8Z's Avatar
Supreme Member
20 Year Member
 
Joined: Jan 2003
Posts: 4,626
Likes: 311
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
Reply
Old Feb 3, 2019 | 01:58 PM
  #13  
dfarr67's Avatar
Member
15 Year Member
Liked
iTrader: (2)
 
Joined: Sep 2009
Posts: 358
Likes: 5
Re: EBL WBO2 Tuning Spreadsheet

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




All times are GMT -5. The time now is 02:58 AM.