Ignition/Tuner/ECM/Fuel Injection Need advice on ignition issues? Questions about a tuner? Have questions about a EFI calibration or Fuel Injection? Tips on Engine Diagnostics, how to get codes, and what they mean. Find your answers here.

Spreadsheet.

Thread Tools
 
Search this Thread
 
Old Feb 11, 2010 | 09:53 AM
  #1  
jluvs2ride's Avatar
jluvs2ride
Thread Starter
|
Elite HDF Member
Joined: Apr 2008
Posts: 4,718
Likes: 11
From: Back in the Good Ole USA. South Carolina to be exact.
Default Spreadsheet.

Anyone use the Spreadsheet that comes with the SERT Pro software? If so can you describe it's use and your experience?
 
Reply
Old Feb 12, 2010 | 07:45 AM
  #2  
jluvs2ride's Avatar
jluvs2ride
Thread Starter
|
Elite HDF Member
Joined: Apr 2008
Posts: 4,718
Likes: 11
From: Back in the Good Ole USA. South Carolina to be exact.
Default

Bump.
 
Reply
Old Feb 12, 2010 | 09:17 AM
  #3  
Shovelhead Bob's Avatar
Shovelhead Bob
Outstanding HDF Member
Joined: Apr 2006
Posts: 2,537
Likes: 21
Default

That spreadsheet is for use by a person that is gathering data via wideband o2 sensors...

You have to plug in the Target AFR, as well as the observed AFR, and it generates a set of NEW VE's....

Useful if you are on a dyno and want to rapidly synch the VE's, vice doing the multiple runs....
 
Reply
Old Feb 12, 2010 | 10:42 AM
  #4  
jluvs2ride's Avatar
jluvs2ride
Thread Starter
|
Elite HDF Member
Joined: Apr 2008
Posts: 4,718
Likes: 11
From: Back in the Good Ole USA. South Carolina to be exact.
Default

Originally Posted by Shovelhead Bob
That spreadsheet is for use by a person that is gathering data via wideband o2 sensors...
Of what use is it to some one using the SEST?
 
Reply
Old Feb 12, 2010 | 10:48 AM
  #5  
Shovelhead Bob's Avatar
Shovelhead Bob
Outstanding HDF Member
Joined: Apr 2006
Posts: 2,537
Likes: 21
Default

It isn't really.... It is a carryover from prior to the Smarttune generation....

BTW, there IS an instruction tab on the bottom of the spreadsheet.. guess you missed that little tip.....
 

Last edited by Shovelhead Bob; Feb 12, 2010 at 11:16 AM.
Reply
Old Feb 12, 2010 | 12:56 PM
  #6  
jluvs2ride's Avatar
jluvs2ride
Thread Starter
|
Elite HDF Member
Joined: Apr 2008
Posts: 4,718
Likes: 11
From: Back in the Good Ole USA. South Carolina to be exact.
Default

Originally Posted by Shovelhead Bob
It isn't really.... It is a carryover from prior to the Smarttune generation....

BTW, there IS an instruction tab on the bottom of the spreadsheet.. guess you missed that little tip.....
Oooops. Guess I did.

Ok, here is my thought. I've used smart tune to synch my ve tables, so in the spreadsheet......

I put 13.5 in the desired AFR
Copy my current corrected VE table to the spreadsheet
Copy my current AFR table to the Observed AFR

Do I now have a newly calculated VE table that will give me the desired AFR?

I am assuming (perhaps wrongly) that if my VE tables are correct, then my AFR tables should be very close to what would actually be observed.

I understand that this is not the intended use, but could this work or am I just crazy?
 
Reply
Old Feb 12, 2010 | 01:57 PM
  #7  
eddfive's Avatar
eddfive
Cruiser
Joined: Apr 2008
Posts: 141
Likes: 2
Default

If you Smart Tuned correctly then you do not need the Spreadsheet. What you are proposing is that your current Smart Tune AFR Table is the same as live AFR data. This spreadsheet was designed so you set the entire AFR Table to 13.5, flash the bike, and run the bike this way to capture the live AFR data and compare this live data to 13.5 AFR Table. This spreadsheet would then make the adjustment/calculation to move your new VE table to 13.5 everywhere. When you are satisfied you have all the VE cells correlated to the AFR Table at 13.5 then you can adjust your AFR Table back to what you want and the Delphi system will adjust to the AFR Table value. The key thing here is that the VE tables are calibrated to a known AFR value. An example: If you are satisfied your VE tables are calibrated, then you can change the crusie area to 14.2 and the WOT line to 13.1 then the ECU will adjust the fuel in these areas. Once the VE table and AFR table is calibrated you can put the AFR Table where you want it and the ECU will adjust fuel to achieve that value. Hppefully this make sense.
 
Reply
Old Feb 12, 2010 | 03:31 PM
  #8  
jluvs2ride's Avatar
jluvs2ride
Thread Starter
|
Elite HDF Member
Joined: Apr 2008
Posts: 4,718
Likes: 11
From: Back in the Good Ole USA. South Carolina to be exact.
Default

Originally Posted by eddfive
If you Smart Tuned correctly then you do not need the Spreadsheet. What you are proposing is that your current Smart Tune AFR Table is the same as live AFR data. This spreadsheet was designed so you set the entire AFR Table to 13.5, flash the bike, and run the bike this way to capture the live AFR data and compare this live data to 13.5 AFR Table. This spreadsheet would then make the adjustment/calculation to move your new VE table to 13.5 everywhere. When you are satisfied you have all the VE cells correlated to the AFR Table at 13.5 then you can adjust your AFR Table back to what you want and the Delphi system will adjust to the AFR Table value. The key thing here is that the VE tables are calibrated to a known AFR value. An example: If you are satisfied your VE tables are calibrated, then you can change the crusie area to 14.2 and the WOT line to 13.1 then the ECU will adjust the fuel in these areas. Once the VE table and AFR table is calibrated you can put the AFR Table where you want it and the ECU will adjust fuel to achieve that value. Hppefully this make sense.
I'll have to read this a couple more times.
 
Reply
HD Forum Stories

The Best of Harley-Davidson for Lifelong Riders

story-0

8 Best Harley-Davidson Motorcycles Ever

 Pouria Savadkouei
story-1

10 Worst Harley-Davidson Motorcycles Ever

 Pouria Savadkouei
story-2

Killer Custom's Jail Break Is The Breakout That Refused to Blend In

 Verdad Gallardo
story-3

Crazy Bunderbike Build Looks Amazing, But Is It Impossible to Ride?

 Verdad Gallardo
story-4

Harley-Davidson Reveals Super Cool Cafe Racer Concept

 Verdad Gallardo
story-5

Engraved Rebellion: Inside Bundnerbike's Glam Rock II

 Verdad Gallardo
story-6

10 Motorcycles You Should Never Buy

 Joe Kucinski
story-7

10 Things Harley-Davidson Needs to Fix in 2026

 Verdad Gallardo
story-8

Southpaw Super Glide: A Left-Hand-Drive 1979 Harley FXE Built to Fit the Rider

 Verdad Gallardo
story-9

The Best and Worst Harley-Davidson Moves of 2025

 Verdad Gallardo
Old Feb 13, 2010 | 02:50 PM
  #9  
Shovelhead Bob's Avatar
Shovelhead Bob
Outstanding HDF Member
Joined: Apr 2006
Posts: 2,537
Likes: 21
Default

Look... The spreadsheet is for use ON A DYNO, WITH WIDEBAND o2 SENSORS.....

You CANNOT Smarttune with the spreadsheet.....

Smarttune is a completely different avenue.....
 
Reply
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
jmg343
Ignition/Tuner/ECM/Fuel Injection
4
Jun 18, 2009 07:52 AM
ct555
Dyna Glide Models
22
Apr 2, 2009 10:00 AM
SE120RG
Touring Models
13
Nov 12, 2008 02:22 PM
nmfxstc
Ignition/Tuner/ECM/Fuel Injection
2
Jun 15, 2008 10:59 AM
CCPD
Dyna Glide Models
7
Mar 8, 2008 12:55 AM




All times are GMT -5. The time now is 09:13 AM.

story-0
8 Best Harley-Davidson Motorcycles Ever

Slideshow: Not every Harley gets it right, but these are the ones that genuinely earned their reputation.

By Pouria Savadkouei | 2026-04-15 14:23:21


VIEW MORE
story-1
10 Worst Harley-Davidson Motorcycles Ever

Slideshow: From the troubled AMF years to modern misfires, these bikes earned reputations for reliability issues, questionable engineering, or disappointing performance.

By Pouria Savadkouei | 2026-04-01 20:01:09


VIEW MORE
story-2
Killer Custom's Jail Break Is The Breakout That Refused to Blend In

Slideshow: Killer Custom's "Jail Breaker" build focuses more on stance and visual aggression than mechanical overhaul.

By Verdad Gallardo | 2026-03-18 19:20:32


VIEW MORE
story-3
Crazy Bunderbike Build Looks Amazing, But Is It Impossible to Ride?

Slideshow: The Swiss custom shop has taken a Harley Softail and stretched it into something so long and low that it looks closer to a rolling sculpture than a conventional motorcycle.

By Verdad Gallardo | 2026-03-07 16:15:30


VIEW MORE
story-4
Harley-Davidson Reveals Super Cool Cafe Racer Concept

Slideshow: Harley-Davidson's new RMCR concept revives the café racer formula with modern hardware-and it may be exactly the reset the company needs.

By Verdad Gallardo | 2026-03-04 12:23:37


VIEW MORE
story-5
Engraved Rebellion: Inside Bundnerbike's Glam Rock II

Slideshow: A standard cruiser becomes an intricate metal canvas in the hands of a Swiss custom house known for pushing Harley-Davidson platforms far beyond their factory brief.

By Verdad Gallardo | 2026-02-24 18:19:44


VIEW MORE
story-6
10 Motorcycles You Should Never Buy

Slideshow: There is no shortage of great motorcycles to buy, but we would avoid these ten.

By Joe Kucinski | 2026-02-19 14:50:51


VIEW MORE
story-7
10 Things Harley-Davidson Needs to Fix in 2026

Slideshow: Harley-Davidson's challenges aren't abstract; they show up in dropping shipments, shrinking dealer traffic, and strategic decisions that aren't yet translating into growth.

By Verdad Gallardo | 2026-01-13 18:33:17


VIEW MORE
story-8
Southpaw Super Glide: A Left-Hand-Drive 1979 Harley FXE Built to Fit the Rider

Slideshow: Graeme Billington's left-hand-drive Shovelhead is as much about problem-solving as it is about classic Harley form.

By Verdad Gallardo | 2025-12-30 11:27:08


VIEW MORE
story-9
The Best and Worst Harley-Davidson Moves of 2025

Slideshow: A clear-eyed look at what actually worked for Harley this year, and what quietly undermined its progress.

By Verdad Gallardo | 2025-12-29 17:10:48


VIEW MORE