Duff750
Computer
- Nov 27, 2008
- 2
First of all, how's everyone doing. I'm new here, and very new to fuel engineering...but I've been googling AFR and stoicheometrics and this and that like crazy lately learning as much as I possibly can. I still have a LONG way to go for sure.
I ride a motorcycle (2006 GSX-R 750) and I've got a Power Commander (fuel injection mapper) installed on it. I recently learned that DynoJet (the company that makes the Power Commander) also has a Wideband Commander that will datalog your real time AFR per RPM and throttle position, and save it to a memory card or to an internal memory, which in turn you can take to your PC and make an analysis of said datalog to make adjustments to fuel change percentages on the fuel map for the Power Commander.
I downloaded the software for the Wideband Commander and also a couple sample datalogs and put myself to work in Excel when I would get bored at work. From everything I've read about AFR's and a lot of trial and error in the spreadsheet, figuring out what percentage of fuel to add or subtract to get your desired AFR, I THINK I have finally come up with a virtually automatic tuning device for the Power Commander fuel map.
I've been trying to find someone that could take a look at the spreadsheet for me, and take a look at the formulas and functions to see if I had done anything wrong, or maybe if there is something I could do better? Can someone here help me out? Anything is much appreciated!
On the spreadsheet...
The WB2 Tab is the datalog .txt imported into Excel...no formulas or functions on this sheet.
The Analyze tab is where the throttle positions are broke down to the available throttle positions in the Power Commander control center. The RPM's "floored" to a significance of 250. and the in the hidden cells, the AFR's are averaged per throttle position and rpm.
The PCIII tab..
The Analyzed AFR per TP and RPM is brought over to the "Current AFR" table.
The "Desired AFR" table, self explanatory
The "Current Fuel Map" table, where you would paste your current fuel map from the power commander if you already have a "base map".
And the "New Fuel Map" table is where the Current AFR is calculated to the desired AFR, and changes are made to the exsisting map if there is one.
There are probably MUCH less sloppy ways of making this spreadsheet than the method I used... such as VBScript and Macros...but I don't know a whole lot about VBScript and Macros so I left it to formulas and functions.
I ride a motorcycle (2006 GSX-R 750) and I've got a Power Commander (fuel injection mapper) installed on it. I recently learned that DynoJet (the company that makes the Power Commander) also has a Wideband Commander that will datalog your real time AFR per RPM and throttle position, and save it to a memory card or to an internal memory, which in turn you can take to your PC and make an analysis of said datalog to make adjustments to fuel change percentages on the fuel map for the Power Commander.
I downloaded the software for the Wideband Commander and also a couple sample datalogs and put myself to work in Excel when I would get bored at work. From everything I've read about AFR's and a lot of trial and error in the spreadsheet, figuring out what percentage of fuel to add or subtract to get your desired AFR, I THINK I have finally come up with a virtually automatic tuning device for the Power Commander fuel map.
I've been trying to find someone that could take a look at the spreadsheet for me, and take a look at the formulas and functions to see if I had done anything wrong, or maybe if there is something I could do better? Can someone here help me out? Anything is much appreciated!
On the spreadsheet...
The WB2 Tab is the datalog .txt imported into Excel...no formulas or functions on this sheet.
The Analyze tab is where the throttle positions are broke down to the available throttle positions in the Power Commander control center. The RPM's "floored" to a significance of 250. and the in the hidden cells, the AFR's are averaged per throttle position and rpm.
The PCIII tab..
The Analyzed AFR per TP and RPM is brought over to the "Current AFR" table.
The "Desired AFR" table, self explanatory
The "Current Fuel Map" table, where you would paste your current fuel map from the power commander if you already have a "base map".
And the "New Fuel Map" table is where the Current AFR is calculated to the desired AFR, and changes are made to the exsisting map if there is one.
There are probably MUCH less sloppy ways of making this spreadsheet than the method I used... such as VBScript and Macros...but I don't know a whole lot about VBScript and Macros so I left it to formulas and functions.