RomRaider

airboy/mickeyd2005: There's a serious issue trying to use the AFR interpolation, it doesn't take into account the minimum open loop fueling enrichment. If you do runs from cells that leaner than this value, you will get very incorrect and misleading results.

Also it would be neat to apply the correction directly to your MAF scale. Or am I just doing it wrong?

I don't understand your question. Are you talking about the Minimum Active Primary Open Loop Enrichment.

You shouldn't be scaling your MAF using the AFR interpolation in that range.

Yes.

"shouldn't" well... it's actually pretty close once you get the enrichment right. I wanted some overlap between using the Front O2 sensor and the wideband.

I love this spreadsheet, but I just cannot use it for very long because it becomes unusable. I think the problem comes in that I have to resize every sheet (to 80%) to view on my monitor. After re-sizing all sheets and loading all my tables, I can only use it 3-4 times until the "selector boxes" close up and keep me from getting anything done. I can't tell what is selected nor can I see the options. I have to start over, re-sizing, loading my tables, etc. Very cumbersome... worth it still.. but man I wish there was a fix.

Screenshot of what happens:




Screenshot of why I need to resize:

One way is to open the spreadsheet without activating the macros, then you can select all the text and description boxes and move them into a usable space, then save the spreadsheet. Re-open and it should be good from then on.

I find that if I change screen resolutions while the sheet is open the text boxes start going crazy .... mine get bigger though.

Hope this helps.

Jeff

You could open the spreadsheet in full size and then delete several columns to bring the buttons over so that you could continue to use it in full size.

I'll have to check the MS Excel forums to see if there is a fix.

Deleting and adding columns doesn't move the buttons and boxes for me.

Now that you mention it, it is not supposed to move Otherwise, filtering the data would mess up the location of the boxes and buttons.

You'd have to enable the "Controls Toolbox" (right click on the tool bar area) and then go into "Design mode" (1st button in the group) and then select and move the boxes/buttons. Hold "Ctrl" or "Shift" to select multiple items and then move them to where you want/need. Exit design mode and you are done.

My method isn't quite so elegant, but gets the job done.

Jeff

I did the "controls toolbox" method to move the boxes, but afer moving (and exiting design mode), the boxes failed to do anything. I'll have to try it again.

Also, maybe I am missing it but can the interpolations for timing and AFR draw a curve (a line based on engine load and rpm) rather than just highlight the cells? I think this would be particularly useful in the analysis of WOT runs in different gears. Highlighting the cells is awesome, but I'd love to have an exact curve plotted for interpolation also.

Excel can't do 3D scatter plots so no, you can't draw a line on the 3D surface.

and it only got worse in excel 2007

The spreadsheet does plot AFR and timing on the interpolate tabs, and highlights the appropriate cells in the tables ... and you can compare different runs by saving one as a reference.

Or I don't understand the problem you are having

Jeff

The interpolation and highlighting of cells works great, but it paints with a broad path. Sure, those cells highlighted are involved in the given set of data, but if a line were present I could see the degree of involvement of a particular cell. The path of a line (given by the coordinates of load vs. rpm) might go smack dab through the middle of some cells and just clip the corner of others. That would help in determining how to achieve a particular goal.

I have plotted these (load vs rpm on the timing or AFR table) by hand for each gear and it's nice to know the typical path a gear takes through the table. The utility of this has given me the easy out to fix knock in 4th gear by lowering timing in cells that are not used by 1st thru 3rd, as an example.

I'm still pretty new at this and am thankful for Airboy's and Mickey's time and work on this tool... if what I am saying really doesn't seem to offer any additional utility, then you pro's lemme know. I already know now it isn't possible, but just thought I'd clarify I am not having a problem with the interpolation functions, rather just inquiring about additional functionality. I like to see the lines, but perhaps it doesn't do me any additional good. Like I said, I am learning and I couldn't do any of this without these forums. Thanks guys.

I have wanted to draw a line on a 3D surface of the Ignition map for a long time but Excel just can't do it. As the "next best thing", I added the "Mark Anchor Cells" function to highlight only two cells that are used in the timing calculation for each RPM row in the map. In addition, the "bias" of which of the two cells is closer to the timing used is indicated by double vertical bars on the cell border.