Printable View
is it possible?
i have tried .5 ,50% and 1/2 in the adjust box but it still strait pastes.
i am sick of using a calculator to make small adjustments.
sometimes a full paste throws off the tune quite a bit. (odd)
any suggestion that will make adjusting BENs in smaller increments
would be nice, or maybe this is something that can be looked at in the next update if it is not possible to do.
;) :)
To use it, log commanded AFR and WBO2 AFR in their own maps (vs. MAP pressure and RPM like the VE table is setup) instead of BEN's. Paste the averages in the first two boxes on the VE WBO2 tab for your application. Then, go back and copy the number of cell hits (n) and paste them into the 3rd box. As attached, the N Factor is set to 100 and 50. If you have less than 50 cell hits, the data will be ignored. If you have more than 50 but less than 100, the low N Factor correction will be used. If you have more than 100, the high N Factor correction will be used. So now, you can apply any percentage of a correct that you would like. :)
Hold your mouse over the yellow headers with a red triangle in the the upper right corner for further instructions.
cool, but personally i think 50 cells in some spots (wot and high rpm)
are a bit high.
how can that be adjusted to a desired amount of cells?
also how do you paste the cell count?
in what spot?
i pasted it in the top corner of the other 2 tables and that worked (like the interpolation sheet)
but i`m having trouble with the pasting of the cell counts for some reason it says its password protected
You can change the blue cells...so if you want to change it from 50, just change it. Same goes for the 100, 66% and 33% values. You can set them however you please.
As for the copy paste....looking at your log, you should have 2 maps as follows:
WB AFR vs. MAP vs. RPM
Data - WBO2 AFR with averages (x) displayed
Row - RPM's in VE table format
Column - MAP in VE table format
Commanded AFR vs. MAP vs. RPM
Data - Commanded AFR with averages (x) displayed
Row - RPM's in VE table format
Column - MAP in VE table format
To copy the table, simply right click on the blank grey box in the upper left corner of the map (where the RPM and MAP headers intersect) to highlight the entire table and select copy. Then, go to the spreadsheet, right click on the upper most left blue cell of the table you're pasting to, and select paste. Pretty straight forward. Again, you're copy/pasting averages for the first two and then switching over to cell counts (n) for the third.
Adjust the correcting factors as you see fit.
Then, highlight the entire Paste Factor table at the bottom (the blue numbers only - not the headers), copy, right click on that upper left grey cell again in your VE table, and paste multiply.
yeah i screwed up and pasted in the wrong spot.
Very interesting spreadsheet. I loved it. :) Very good job.
This is the sheet I use. Just paste in your ben factor and the percentage of correction you want. It isnt flash but it works.
SSpdDmon,
i am having trouble pasting to the IFR table.
i had to highlight and paste each value individually.
what am i doing wrong?
Attachment 2054
this is exactly what i was looking for!Quote:
Originally Posted by 5.7ute
thanks
Why are you using that tab? :nixweiss: I thought you were doing VE tuning?Quote:
Originally Posted by mr.prick
If you were going to use that tab, you would have to have two maps with WB and commanded AFR's (just like above). Only this time, you're logging:
GM.MANVAC from 0-80kPa (5 kPa increments) instead of RPM in the ROWS
and ONE COLUMN of RPM (labels=,8000) instead of MAP.
Pase your average data (commanded and WB AFRs) after filtering out DFCO, transitions, and what not. Then, it should spit out a correction to be pasted/multiplied to your IFR table. Remember, with IFR tunes, the lower the value in the IFR table, the more fuel delivered.
LOLQuote:
Originally Posted by SSpdDmon
i wanted to see how it would show my IFR table, and i didn`t like it.
but i had to paste each value to each square individually.
it tells me i can`t change part of a merged cell.
it is not letting me paste in bulk.
or am i supposed to paste each value separate from each other?
Error has been fixed. :)Quote:
Originally Posted by mr.prick
Re-download the file if you still wish to give it a try.
Personally, I paste each individually because I filter out kPa's that end x2, x3, x7, and x8. Focusing on the data that's closer to the 'center' of the cells helps prevent the interpolation from skewing the data.
Go into your V7\User Configuration\ folder and find the Filters.txt file. Paste this into it at the bottom.
Then, I do one cell at a time by changing the MANVAC parameters to:Quote:
[Data Filter - IFR Tuning]
Filter=Exclusive
X0000=SAE.TP,%,%,DXGT,2.00,500,OR
X0001=SAE.TP,%,%,LT,1.00,100,OR
X0002=SAE.SPARKADV,Deg,Degrees,DXGT,6.00,500,OR
X0003=SAE.SPARKADV,Deg,Degrees,LT,10.00,100,OR
X0004=SAE.RPM,rpm,RPM,LT,1800.00,100,OR
X0008=GM.MANVAC,kPa,kPa,GT,81.00,100,OR
X0009=GM.MANVAC,kPa,kPa,LT,79.00,100,
above 76 / below 74
above 71 / below 69
above 66 / below 64
above 61 / below 59
etc...