NefMoto

Hello, friends!  ;)

Today I was programming stuff with MS Excel and came up with perfect solution for those, who do not understand or don't want to calculate KFMIOP based on KFMIRL (REMEMBER: You always have to reflect your changes in both maps!) :) With my calculator it's pretty straightforward -> just copy values from KFMIRL into special cells of the prepared tables and that's it! :) And this file is pretty dynamic, you can even change KFMIOP X axis to reflect one in your file!

I decided to make ALL-IN-ONE MS Excel file, dealing with basic tuning annoyances and calculation;) Please always use the latest version and report bugs! (for example calculations are wrong)

LATEST VERSION CAN BE FOUND @ http://github.com/masterjguscius/NefMotoOpenSourceCollaboration (http://github.com/masterjguscius/NefMotoOpenSourceCollaboration)

Very good, I spend alot of time trying to create one of this table. Thanks!

Can you make KFMIOP calculator for 12x16 KFMIRL?
Thanks!

Thanks for this! This is something that I will use.

I wish we had an injector wizard of the same type. :D

Are you sure that in your file it is 12x16?? In my it is 11x16 ;)

TFSI KFMIRL map is 12x16. Or, please, put here again the first version.

OLD VERSION! ;)

this can be usefull, nice one =)
is it possible to make it so that you can modify the rpm-axis on both kfmirl and kfmiop? these vary alot between different box-versions.
also if it could be possible to change the kfmirl percentage axis? since this one also varies.

You can change axes in your bin file ;)

thanks for this  ;)

UPDATED! Added KFMIRL ADVISER thingie! ;) Test and report... ;)

wow! amazing!  can't wait to try this in a few months lol :)

The natural next question is how does this relate to LDRXN?

I'd say the regions where LDRXN limits req load aren't as sensitive to IOP issues.

Would be interesting to apply LDRXN to IRL and use that to calc IOP. Not sure there would be significant differences

Yes, I agree on everything you just said, but my point was that this directly relates to the LDRXN table values itself.  Right, unless I'm missing something, this could auto-generate the proper LDXRN table for us.  Any idea?

If you give me the formula how to calculate LDXRN based on KFMIRL/KFMIOP I might be able to create the auto LDXRN thingie ;)

But basically if I understand everything correctly, you'd just have to find the highest load value in RPM range (KFMIRL) and then put it in LDRXN. And that's it :)

BTW: If you use my KFMIRL adviser and just put max bar it will auto generate kfmirl table. All you have to do then is just put (atmosphere+boost-300)/10 value where you want it to max out.

Sorry, autogenerating LDRXN makes absolutely no sense to me.

Yep it's pretty easy to do once you have KFMIRL and KFMIOP sorted out...

Maybe I'm missing something...its a load limiter. It limits filling. You can make KFMIRL whatever you want and if its below LDRXN, then LDRXN does nothing. If KFMIRL is above LDRXN, it will limit filling to the values in LDRXN.

It doesn't have any real/hard relationship to KFMIRL unless you want it to for some reason.

s4wiki:

"Specifically, on a full throttle pull, your boost profile will follow LDRXN. K03s and K04s have some severe flow limitations, so unlike big turbos, you will want your boost to taper (not ramp up) to redline. ECUxPlot has a pressure ratio/flow plotter that you can use to compare against your turbo's compressor map."

how then is it unrelated?  it sounds like the OP specified an algorithm to auto-generate it a few posts back...  is anything wrong with what he said?

back tracking P/R to req boost to req load is unrelated to coordinating IOP with IRL...

KFMIRL is not used to tune a curve to avoid surge/etc. Its used to correlate a torque to a filling at a speed. It doesn't care what turbo is on the car/ where the surge line is. LDRXN is used to tune the filling curve, and this is what you use to avoid surge, etc (or other boost limiters). There is no relation between the two where you would use KFMIRL to "generate" LDRXN.  KFMIRL is a description of the physical system. LDRXN is a tuning parameter.

OK, clearly I need to do my research on my comment earlier...

Is there a way to adapt to be used with the KFMIRL of the M-box for the S4?

The load points are less then what you have unless I am misunderstanding something?

Mbox KFMIRL load axis: 0,10,14.9,19.9,30,39.9,50,60,69.9,80,89.9,99.9

Thanks!

Are you talking about KFMIOP calculator v1.1 or KRMIRL adviser v1.0?

Both, since you have too many load sites in your excel file (16 vs 12 needed for the S4).

Oh snap.... Dunno, that would take a lot of time to remake everything, but looks like there is already KFMIOP calc for Mboxes ;)

http://nefariousmotorsports.com/forum/index.php?topic=1375.0title= (http://nefariousmotorsports.com/forum/index.php?topic=1375.0title=)

thats correct, the converter exists, but the adviser doesn't.  is there some way to edit all of those cells?

new version uploaded ;)

new features added: just cosmetics, title page with sheet index

BTW: If anyone wants to add their sheets then please update this excel file and upload it here :)

copy whole adviser sheet to a new excel file and you'll be able to edit every cell ;)

UPDATED!! KFMIRL adviser version now is 1.2.
New features:
* New interface
* Added turbo type logic
* Added low load generation

Great tool, thanks!

Although its really tough to use in the older versions of Excel (2003) with the fancy new graphics settings.

Please update office to 2007 to be able to use all functions ;)

Second that. I'm resolutely sticking to Office 2003 because it serves me well, although my wife's Macbook Pro has a 2008 version although I've never really used it for anything fancy.

TTQS

I was also long time Office 2003 user, but when docs started to float in docx, xlsx and such formats I had to go and upgrade. Anyway, my file is created with Office 2007 ;)

UPDATED!! KFMIOP calculator version now is 1.3.
New features:
* New interface to match KFMIRL adviser

how about support for the variously sized tables?  what about for variable rpm values?

Variable RPM will be in the next update. Variable table sizes won't be in near future.

Just curious, in v1.0 you could modify the load axis in KFMIOP and in v1.3, you cannot.  Was this an intentional change?

in 1.0 you could modify load, but it didn't reflect in calculations... It would be impossible to make variable load with my way of miop interpolation. You can very easily edit axis in your bin file to match with the calculator

very easily, BUT, the problem with that is, you wouldn't WANT to change the axis in your bin-file to something from a calculator, since this axis is of great importance and often unique for how different individuals tune their car.. youre thinking in reverse here.

other then that, its a really nice tool, and im sure someone can come up with a solution for this  :)

I think I might come up with the solution after all, but it will take some time :) BTW: Please do proper tutorial how you implemented NLS and real launch control ;) I'm very interested in this :)

my question regarding table sizing is that we have a few different populations on this site.

i know for a fact your tuner wizard can't be used for b5 s4's, unless i'm not understanding something, due to how your tables are sized.

would it be possible to have different versions of the spreadsheet for the differently sized tables?  this is a great tool but only part of the forum members can use it because you are using a table sizing for 1.8t engines on motronic 7.5, right?

I think we another worksheet to be worked on as well as the  ME7.5 that has been started (even though I've only been tuning 7.5's). Assuming however that this turns to a full on group project, as it should, to not overload J.

Being able to customize the load axis would certainly be an improvement.  Your load axis only goes up to 145.  Wouldn't this be an issue for folks who have load values in KFMIRL around 200?  You wouldn't be able to specify a torque value in KFMIOP for the load exceeding 145.  By the way, thanks so much for this utility.

BAM and BFV engines have a 16x16 KFMIRL, so it isn't suitable for TT 225PS 1.8T owners.  :(

TTQS

UPDATED!! KFMIOP calculator version now is 1.4.
New features:
* RPM axis is now editable

I wondered this too. Doesn't the load axis of KFMIOP have to reach the max calculated in KFMIRL?

No it doesn't, because ECU uses linear points. But I'll add the ability to edit load in kfmiop calculator in near future ;)

UPDATED!! KFMIOP calculator version now is 1.5.
New features:
* Completely rewritten algorithm of KFMIOP calculation. It is now about 200 times faster than in 1.4
* Calculations done in realtime / button removed

UPDATED!! KFMIRL adviser version now is 1.2a.
New features:
* Small adjustments to factors

UPDATED!! KFMIOP calculator version now is 1.6.
New features:
* Fully customizable axes!!!

I will create one more version of "KFMIRL calculator" for those who have different size of KFMIRL (current version: 16x16) or KFMIOP (current version: 11x16) tables.

Everyone, who can't use wizzard due to different size of tables please post these sizes and I'll create calculator for one more combination of tables which are most needed (most users have them).

b5s4 please:

kfmirl: 16x12
rpm axis (16):   440,720,1000,1240,1520,1760,2000,2520,3000,3520,4000,4520,5000,5520,6000,7000
percent axis (12):  0,10,15,20,30,40,50,60,70,80,90,99.9


kfmiop:  16x11
rpm axis (16):   440,720,1000,1240,1520,1760,2000,2520,3000,3520,4000,4520,5000,5520,6000,6520
load axis (11):  9.75,18.00,27.00,50.25,62.25,74.25,97.50,120.75,144.75,168.00,191.25

Using your 1.6 version with Microsoft Excel 2010.  I see the following error pop up any time I attempt to edit one of the editable fields.  It also pops up as soon as I open the excel sheet.

(http://i.imgur.com/dyTav.png)

Thank you, I will try to find this bug now

I have the same problem , and please if possible make KFMIOP axis editable. Thanks , GREAT TOOL !

This tool is very handy, thanks for posting it!

UPDATED!! KFMIOP calculator version now is 1.6a.
New features:
* Bugfixes mainly

KFMIRL adviser version now is 1.2b.
New features:
* Bugfixes mainly


ALSO MASSIVE UPDATE TO THE WHOLE PROGRAM. INCLUDING MORE OPTIMIZATIONS AND DATA FILTERING.

today i downloaded your program it is awesome thank you so much for this. I puted a stock boost 0,6bar to the advisor and the KFMIRL it gave me is very much different than the original. Then i put stock KFMIRL map and the KFMIOP that gave me was again different but not so much from the original. I have an 1.8t 180ps file to test.  I wrote that just for information purpuses i don't want to say that the program isn't working properly. I will continiou testing in my car and report back. Regards.

Yes it will show lower kfmirl in advisor, because stock is too high for only 0.6 boost, that's why bosch limits that with ldrxn. Try to put kfmirl that is suggested and just FF whole ldrxn table ;)

File is password protected, anyone know what it is?

powerpass

yes you are right because as i saw in stock setup ldrxn is lower than kfmirl. And also is to considered some slight increase in boost during overboost conditions

Why would you need password to open file? It is there for a reason, so no important calculation tables are compromised. I'm going to change it in the next version.

Dude sorry, that is a lame excuse. Of all the projects I have ever worked on, not ONCE has "important code" been "compromised".

Thats what SCM is for. Which, incidentally, can't be used on excel files LOL.

A large part of my hatred for excel spreadsheets is the demographic that uses them :/

no pun intended in your case ofc :)

I get this error message in Excel 2010 every time I try to edit one of the editable fields or if I switch to the other worksheet:

(http://i.imgur.com/b4Egw.png)

Looks like this will not work in Office 2010 as error says... I programmed in 2007 and have no office 2010

Office for Mac 2011: Gives compile error, but seems to still work.

That is good news :)

Sorry you miss understood, was just trying to use your spreadsheet, must be my old version of excell. it works ok in 2010.

Can I just ask, when I enter the KFMIRL data, is it supposed to generate the KFMIOP map for me?

Yes it should generate kfmiop ;)

Ah it doesn't on mine, is it done automatic after i (paste) fill the KFMIRL or do I hit a calculate button somewhere?

Jeezus... and I thought I was angry and cynical.  :o

That's me off the Christmas card list then because I love Excel and what can be done with it and VBA. I don't agree with protecting sheets though.

I presume masterj was simply referring to protection against someone inadvertently corrupting the code by curious fiddling then not knowing how to fix it (other than the rather obvious fix of just downloading a fresh copy) rather than trying to protect some rather simple functionality...?  :-\

TTQS

I get it for quick hacks, but not as a production tool, since it can't be kept usefully in SCM, nor can it be used for automated builds or regression testing.

yep, so they wouldn't put bad tables after that into winols or tunerpro and get torque monitor 2 DTC
BTW: I would really like that other people would also include their useful sheets into this doc, but I know that VBA can also be used for *bad things*. So if anyone wants to help me with this doc then please send me a copy of your xlsm or whatever extension the file has and I'll add it to main file (after checking for any possible *bad* vba). And then I'll upload new version in first post (crediting the author ofcourse). Also If anyone wants to port my current kfmiop calculator to diff sized tables then please do and send me copy, this will help others ;)

UPDATED!! NEW KFMIOP calculator 2 version now is 1.0.
New features:
* KFMIRL MAP - Load has 12 points, RPM - 16
* KFMIOP MAP - Load has 11 points, RPM - 16

Hope this one will work for those who had KFMIRL 12x16 ;)

I don't want to appear an idiot, but can someone help me with this wizzard, I've tried it in ecxell 2007 and 2010 and it just wont create the KFMIOP table, I paste into the KFMIRL and nothing happens?

Have you enabled macros?

Hi, yes I have but still no luck

Well, that is weird... Don't know what else could there be... maybe your antivirus blocks macros or something??

Works great for me... I made a new tune last night and will hopefully try it soon.

Thanks for your hard work on this stuff masterj

I'll have another bash tonight, it's well wierd, it works on my work pc running office 2010 just get the annoying compile error, it's just too inconvenient on that computer.

I don't have antivirus installed on my laptop, so it did dissable macros which I changed to allow.

UPDATED!! NEW LDRXN / LDRXNZK CALCULATOR v1.0.
New features:
This is for noobies only or if u're on a hurry ;)

Also small graphical fix in KFMIOP CALCULATORS.

Enjoy ;)

UPDATED!! NEW KFZWOP/KFZWOP2 CONVERTER v1.0.
New features:
Brand new experimental tool. I know that at least for some of us KFZWOP and KFMIOP maps share same X AXIS and if we want to change KFMIOP axis  (for example to remove torque limit) means that we get a lot of problems with ignition timing. So this tool tries to remodel your existing KFZWOP map with current x axis to new x axis, that you can define. I hope it will help you all!

masterj

Could you consider adding a worksheet that has a set of generic 3d interpolation tables for the common XY dimensions?

Also, did using this interpolated WOP table + rescaled IOP load axis resolve your own issues?

Oh, and thanks!

When I rescaled everything what happened was my idle consumption went down by 10% and idle is very smooth. Also I feel much better throttle response in part throttle situations... I mean, I can easily drive in 4th gear with about 1300 RPM! That was impossible before...

BUT I still have problem with torque monitor number 2! And I'm starting to think that it isn't the one checking kfmiop, it is using some other maps, that I still do not know. I believe it might be some kind of protection against aggressive tuning (transmission protection or something). If anyone else is having "17743/P1335 - Engine Torque Monitor 2: Control Limit Exceeded" then please respond... we'll have to find out what a f... is going on...

I will try to double check the assembly code tonight and verify for you which limit being exceeded causes that error code.

thank you very much!

I believe this error comes from MDKOG subfunction MDBEG if miszul_w - mizsolv_w < 0. You can try logging B_mibeg.

Edit: If it is actually torque monitoring intervening, then possibly it is function UFMVER.

I've found which maps were causing torque monitor no2 error!

It is one or few of these maps:
KFMIZUFIL -> FFs
KFMIZUOF -> 00s
KFMIZUNS -> FFs
KFMI_UM -> updated to reflect KFMIOP
KFMPNS_UM -> FFs
KFMDZOF_UM -> FFs
KFMPED_UM -> FFS

No more torque monitor 2 errors!

I'll have to investigate more to tell which one exactly causing it, but if you have problems try to change them as I've written

UPDATE: Although I see in logs that ChargeLimitEngineProtection gives me weird readings (min: 108, max: 118). Please download my logs

I don't suggest completely disabling torque limiting. Kinda scary IMO.

Also, I'm not sure what triggers the monitoring functions, but the FR specifically states NOT to change "under monitoring" tables. I believe others have had success with only modifying the MDZUL (iirc) tables.

I found the assembly code that is settings this error code, but I wasn't able to find what was calling into it. I will need to take another look tonight and cross reference it with was the FR is saying.

Is the P1335 error code the only one getting set? The assembly code I found setting that code appeared to always be setting another code at the same time as well.

I have only one more code which is set only during cold starts and it is o2 sensor circuit malfunction. But I just delete it and everything is OK, code appears only in cold temperatures during first cold start...

Also I've tried to find which map is specifically setting the code, but it looks like anyone of these can. First I tried only
KFMIZUFIL -> FFs
KFMIZUOF -> 00s
KFMIZUNS -> FFs

That set the code (but much much later than with original tables). Then I added these:
KFMI_UM -> updated to reflect KFMIOP
KFMPNS_UM -> FFs
KFMDZOF_UM -> FFs
KFMPED_UM -> FFS

And BAM - no more torque monitor exceeded errors.

I just thought Id try out the LDRXN calculator from the values I already have from my bin to compare it too the LDRXN I already have an using the calculator it suggests this,
(http://i305.photobucket.com/albums/nn238/danmlittle/LDRXN.jpg)

Which isn't good for the K04! Have I missed something when inputting the values?

for sure. ;)
look again to your kfmirl map

post screenshot of your kfmirl

I don't see a good reason to have LDRXN have ANYTHING to do with your IRL setup.

My calculator creates ldrxn from kfmirl ( resembles kfmirl ). Personally I've always did my tuning with KFMIRL. Everything else just to acompany this map

Not a good idea. LDRXN needs to be tuned to what the turbo/wg is capable of, not what the driver wants, or you're asking for all sorts of problems.

You can do this with kfmirl :) Only difference is that you're able to tune not only based on rpm but also on requested load. LDRXN is there only to ensure that you not overload your turbo... as in LIMIT over LIMIT.

In ideal situation you'd have to tune properly kfmirl first, but most people leave original kfmirl and just limit everything with ldrxn. That is bad way to do things... My kfmirl adviser gives a starting point to properly set up kfmirl first and then you can use my ldrxn calculator to set up ldrxn

the same think i was thinking my self. That's why i said about kfmirl. Regards.

for example, IRL is not tuned (stock) to avoid positive deviation... LDRXN is.

Heres a copy of the KFMIRL I used to create that LDRXN.

2 things to note are that I know the axis on the tuner program where the other way round and I put the data in as it is found on the wizzard and not as it's displayed here.

And also I changed the rpm to reflect what was in the xdf and not on the wizzard.

Just noticed as well the max load is 223 on the ldrxn wizzard where as my kfmirl is 222.

The kfmirl is a stock one from an audi tt as created by audi
(http://i305.photobucket.com/albums/nn238/danmlittle/kfmirl.jpg)

So my ldrxn calculator calculated OK, your kfmirl is weird... at low rpm it goes up then down and then goes up again... Normally if you have K03/K04 or other small turbo it should go up to about ~4000RPM and then start to drop

This is normal isn't it? Here's my AUQ 1.8t original KFMIRL...

That kfmirl is from an audi TT 6018cb ecu.. Completely stock as the day it left Audi.

Maybe your calc won't work on these versions?

my calc works, but it gives results from your kfmirl, so it will look a little bit weird... Please try my kfmirl adviser, then use kfmiop calculator and then finally ldrxn calculator. Because right now I think kfmirl is set too high. Do you have 1 or 2 turbos? Also please post your stock ldrxn.

With your current kfmirl setup you should boost up to 1.5 bar of boost. For one K03 turbo that would be way to much. But I suspect that LDRXN is limiting it, so please post it too

UPDATED!! KFMIOP calculator version now is 1.8, another KFMIOP calculator version now is 1.3.
New features:
* "Suggest OPTIMAL x-axis" button added. It will help you to change KFMIOP x-axis, so it wouldn't limit your torque if you're pushing more than ~1.2 bar of boost.

I tried out this wizard and it works great so far.....except for one thing.  After inputing my values for KFMIRL and KFMIOP (axes based on the Optimal suggested) I found that I was getting a surging issue at idle.  The revs would bounce up and down between 800 and 1000 at idle.  I have a feeling this is because of the reduced resolution around low load and idle RPMs that the "OPTIMAL" button seems to create.  I also had my revs shoot up on cold start and then they settled back down a few seconds after.


Other than those two issues......the car ran great.  I found it was MUCH easier to keep a constant part-throttle acceleration and I could also regulate boost with my foot at less than full boost.  Normally I could either keep boost at 5-8 PSI with the throttle.....or it would immediately jump to 25.  Now I can pretty much smoothly get anywhere in between if I'm careful enough on the pedal.


I forgot to mention this is on a 2005 Audi A4 1.8T w/ return fueling and GT2871R.



MasterJ could you give use a little insight on the algorithm for selecting the "optimal x-axis" values?

MmmBoost, did you use KFZWOP/2 converter (after generating new axis inf kfmiop)?

optimal x-axis values are selected based on biggest load difference between points.

No I didn't.  Think that could have been the cause of my issues?


I'm thinking it might be better for me to leave a little more resolution around idle/low load.

YOU HAVE TO READJUST KFZWOP MAPS BECAUSE THEY SHARE SAME X AXIS AS KFMIOP. If you use optimal axis suggestion then popup tells you that you have to readjust KFZWOP maps. Write down your original kfmiop x-axis to notepad or somewhere and then use kfzwop converter

Also for your other problem (high rpm for a few seconds during cold start) I'd recommend you adjust properly these maps:
KFMIZUFIL, KFMIZUNS, KFMIZUOF, KFMI_UM, KFMDZOF_UM, KFMPED_UM, KFMPNS_UM

I will adjust KFMZIOP accordingly and see if that makes a difference.


I have never had a high-rev on startup until I loaded my new file last night with the adjustments from the calculators so it must be these two maps affecting things.

Also I am not using WinOLS......I am unfortunately tuning my car with Eurodyne Maestro.....so I only have the ability to change certain maps unless I specifically ask for other maps.

The maps that I said earlier needs to be updated every time you change either pedal response or kfmiop or kfmirl... These maps are other limiters for torque. If you change only kfmirl and kfmiop you'll have some difference between optimal torque maps and get this high rev at start. Shouldn't be a biggie though

Thank you for the explanation.

What do you think about keeping the first few columns of KFMIOP the same  as stock to try and help prevent this?  (since I don't have access to any torque control maps)

I do have access to 3 Pedal maps......but that's about it

First use kfzwop converter. This should fix your jumping idle (800-1000). This happens because you changed x-axis and the timing now is crazy in kfzwop maps... ;)

UPDATED!! NEW KRKTE calculator 1.0! It should help you calculate starting point for KRKTE on Gas and E85.

Alright I made the necessary changes to the KFMIOP tables and the high-revs on startup have gone away and idle is fairly smooth.


the one thing that I still don't like though is load seems to be quite high at idle which means my timing is very low.  Normally I'm around 18-19% load and about 6-8° of advance.  On the way home I was at 24% and hovering right around TDC.

Try to fiddle with kfzw/2 maps at idle area...

question:

Should my maximum value in KFZW1/2 be the same as the max value in KFZWOP/KFMIOP?  or does it not really matter?

Are you talking about x-axis? If so, I'd change it to be same as kfzwop...

Mmmboost, what platform are you working on?

Many ECU's do not require these axis to be changed at all.

Working on an AMB 1.8T with ME7.5

I think that for ME7.5 you'll have to play with these axes... Atleast I had (my car also has 7.5)

Marius I sent you an email.  Just a heads up.


Also.....I am running quite a lot of boost on my tune so consequently my "optimal axis" calculator tends to want to skew all of the data to the high side in order to have them spread out evenly.  The problem I'm having with this is that the KFZWOP maps basically have no values for light load and cruise.  I'm finding that my timing is all over the place and in a lot of cases a lot lower than it should be.

I'm not sure if this is going to work for me running as much boost as I am.

I'll check my mail when I get back home. Could you please post your screenshot of your kfmiop map?

This is what the wizard comes up with for an ideal KFMIOP

(http://i.imgur.com/JyRKN.jpg)

......also, I wanted to point out that there looks like there is an error in the KRKTE calculator...or perhaps I just mis-interpreted it.

I am running ID725 injectors rated at 715cc @ 3bar.  When I put in my value for the calculations it seems off so I looked into the calculation.

n-heptane's density is 0.684 g/cc.......so the calculation should be either multiplying be 0.684 or dividing by 1.462 in order to get q-stat for the calculation.

Did you use KFMIRL adviser or is this based on kfmirl created by you? :)

krkte calculator gives me 0.03130  for your injectors, which seems to be OK

This based on the KFMIRL advisor.

2 bar boost
Big Turbo
4% agressiveness

KRKTE = 50.2624 * Vh / Qstat

Vh: Displacement of a cylinder in dmˆ3
Qstat:  Valve correction for petrol/n-Heptane (g/min)

density of n-heptane is 0.684g/cc

Qstat = 715 cc/min x 0.684 g/cc = 489.06 g/min
1.781 dm^3 engine
4 cylinders

KRKTE = 50.2624*(1.781/4)/489.06 = 0.0456

therefore KRKTE = 0.0456 ms/%

Yes, you're right. I've eliminated this bug from my wizzard

UPDATED!! KRKTE calculator version now is 1.1.
New features:
* Bugfix, now it should properly calculate KRKTE value

I think this kfmiop should work, but you can try to lower map values by 2 in the 20% load column. But you really have to update KFZWOP/2 maps and other maps that I've said earlier. Otherwise, leave stock x-axis values if you have no access to other maps ;)

I don't see anyone else mentioning this.. but copying FROM the wizzard to winOLS works.. but not the other way around for me?

For instance if I try to copy IOP or other maps into the wizzard, I just pastes the following into one cell: "Search text is to big for text clipboard"

I am running WinOLS in a VM, C&P works for other programs just fine though so I don't see how that is an issue.

I think you're copying tables that have , and . swapped... :) What is your decimal operator in excel? In mine it was , not . so I had to change it in settings. Also you could try to copy map from winols into notepad and then from notepad to excel and see if it works...

If it says that cell is protected than it means that either map dimensions are different or you're copying only part of map from winols..

The separator is correct.


I figured out the Macro part... Office 2007 will not open encrypted marcos unless you have anti-virus that will be checking the document... so I had to enable the document check part of my AV and now they run.

I have attached the notepad txt file of the paste from winols

just to clear things up.... It was indeed because of the VM...

I installed Office on the VM and C&P works as it should..

In order to disable the protection inside Excel, follow these instructions:

UPDATED!! NEW - INJECTORS DATABASE V1.0.
New features:
* Brand new sheet, filled with stock injectors info, such as: part no; flow rate g/min; flow rate cc; impedance; connector type

As you see there are a lot of blank fiels in the database, so I'm gonna need your help to fill these up ;) If you have info on missing injectors please write it here

Thank you, I couldn't figure out some of the details and didn't want to sound like a dummy.

UPDATED!! KRKTE CALCULATOR version now is 1.2.
New features:
* New option added - Fuel Pressure Regulator

can I make a little suggestion?

your IRL > IOP calculator seems to want to put 100% load on the last axis... but looking at most of the stock programmings it always seems like they load axis slightly exceeds the max req. load in IRL so that you never see the value 100 in IOP...

maybe you can do a small rework of your calculator to keep the max values under 99-99.5%?

Not sure if anyone else agrees with me, but I'm assuming there might be a reason for that?

Otherwise your file seems to work great in the limited scenarios I've used it for so far.

Right now I see no evidence why is this needed... It doesn't change anything, unless you're experiencing problems with torque when kfmiop is @ 100%?

BTW: Stock file doesn't mean it is etalon of tune ;) Also in stock file you can see that KFMIRL isn't direct inversion of KFMIOP... But I think that is because people at bosch were lazy and didn't use any linearisation tools to do it properly...

UPDATED!! NEW EXPERIMENTAL KFZWOP/2 GENERATOR v1.0
New features:
* New - should generate ignition angle based on RPM and charge

This is very experimental tool. If you have formulas on RPM vs Charge vs Ignition angle relationship, please post it here... Right now I've modeled whole generator based on my stock file.

Sorry for stupid question, but what is mean Aggressiveness in KFMIRL? how much % it should be?

Why would you calculate KFZWOP(2)?

IMO this is just asking for problems. The goal is to keep zwgru and zwist as close as possible to zwopt. I wouldn't change this table at all unless you are exceeding it, and in that case I would raise it slightly just to preserve the safegaurds that it provides.

You have to either generate it or recalculate it when your charge axis is changed in kfmiop...

More aggro -> more powerful part throtle

careful with agressivenes because you can come with with boost instability

Maybe I should actually look at your spreadsheet....

So you are only interpolating for the adjusted axis based on original values or trying to recalculate the entire table from other inputs?

I have made two sheets inside this excel file... one interpolates data from original kfzwop and the second tries to generate it (alpha version ;))

UPDATED!! KFZWOP/2 GENERATOR v1.1
New features:
* Completely rewritten sheet based on MIDAS solution

good work masterj!

Holy s... !
I don't want to seem like an ass and I really admire your enthusiasm to generate this tools, but what comes out of the KFZWOP/2 GENERATOR is complete bullshit.This is obvious just from looking at the values.
KFZWOP contains the ignition angle for 50% heat release@ 8°ATDC as a reference for the torque structure and can not be filled with some random calculated values.


 

Yep, just tried it and can confirm that MIDAS calculator as well produces bad values... Hm... So, if someone reads these posts then please DO NOT USE KFZWOP/2 GENERATOR unless I find a way to fix it

UPDATED!! KFZWOP/2 CONVERTER (NOT GENERATOR!) v1.1
New features:
* Remade this Sheet for 2D Inverse map (default in winols)
* Added "smoothing" option

I encourage you to try CONVERTER and not GENERATOR (which is also in me7 wizzard, but it is broken and produces bad ignition values at the moment!)

Trust me. Forget about the GENERATOR and invest your time in something more promising.
I have worked with "high end" engine simulation software like AVL BOOST and GT-POWER and even with a lot of test data from the dyno you will never get results that have the quality you think you can generate with a simple excel tool.

Yeap, I've invested my time into updating CONVERTER. Try it ;) It should work if you have original KFZWOP. It will recalculate this map to new load. If you want to be super accurate, then disable SMOOTHING.

UPDATED!! NEW FKKVS FIXER 1.0
New features:
* Brand new sheet which loads me7 logger csv file and tries to interpret it. For it to work you need to log RPM, injector open time and lambda correction.

I tried it last night... Actually I've been trying to use many versions of your converter for a while now... different setups, different cars.

I'm sorry to say, but silentbob is correct.  It doesn't work.  Or at least it doesn't work for where it counts.  Part throttle is terrible... I always get TQ corrections, and under full throttle pulls I get massive TQ interventions via ignition angle.

I will be posting up some logs shortly showing what I am talking about in my project thread.

EDIT: Here they are http://nefariousmotorsports.com/forum/index.php?topic=617.msg16796#msg16796
with a comparison directly to dropped in RS4 box TQ management values right after (no other changes to the tune).

Could you please recreate and post screenshots of the KFMIOP/KFMIRL and LDRXN maps when you were using my wizzard?

BTW: When you changed KFMIOP/KFMIRL did you reflect changes in these maps also: KFMIZUFIL, KFMIZUNS, KFMIZUOF, KFMI_UM, KFMDZOF_UM, KFMPED_UM, KFMPNS_UM? I had to edit them when I was editing my torque model... Otherwise my car was freaking out! Please post screenshots of these maps also...

Really great job!! :)

(http://i.imgur.com/frpKM.jpg)[/quote]


some not all... very minor changes

I forgot to ask, did you use the button "Suggest OPTIMAL x axis"?

If not then you have to update KFMIZUNS -> FF's; KFMIZUFIL -> FF's; KFMIZUOF -> 00's; KFMDZOF_UM -> FF's; KFMPNS_UM -> FF's; KFMPED_UM -> FF's
KFMI_UM you have to reflect it to KFMIOP! (for easier job -> edit rpm and/or load axes to be same as in kfmiop and then just copy values from kfmiop)

And do not forget to update LDRXN! Because right now I see that your LDRXN limits your KFMIOP map, thus eating you aggresivness! (suggestion: try to fill LDRXN with values -> 228)

if you used the button "Suggest OPTIMAL x axis" then you'll have additionaly to update KFZWOP/2 maps (because they share same axis with kfmiop).

Please edit maps as I said and tell me the results.

BTW: All the maps that I said to FF or 00 will need to be calculated later (just for proper torque protection monitor nr2). Right now please use 00 and FF as I said earlier.

Yes I did.


That was your programs suggestions


I did that as well

LDRXN isn't suggested by my program. Please recheck. Maybe you put original kfmirl map inside LDRXN calculator?

no that is the IRL map that your program suggested.  This issue was not LDRXN, as that only caps load.

I get very strange ingnition angels if I use the KFZWOP converter.

to understand it right: wasn't the meaning to scale (interpolate, may be extrapolate) the values for the new and extended load axis?
therefore angle should be the same for the same load row?!

and on low rpm it limits your load. Please compare your LDRXN to KFMIRL map at same RPM values. Also I think, I've found what is causing the problem.... When you are using kfmirl to kfmiop calculator please do not modify it's axis (do not use "suggest OPTIMAL x-axis") and leave stock kfzwop. I think that problem here is with the kfzwop/2 maps...

If you disable smoothing then it should be the same, except for situations where values in original kfzwop map are different between last two values in columns and rows, then my algorithm find difference between these two values and then apply it to the extended values.

ok, disable smoothing did eleminate the main strangeness! ;)

But the extrapolation of the last two value is not correct, at least not linear:

Example:


any idea?

I would trust your math over an automated template at this point

Guys cant use it on office 2010 x64.
"Compile error in hidden module: CHANGE_APP_ICON".
A protected module contains a compilation error. Because the error is in a protected module it cannot be displayed.
This error commonly occurs when code is incompatible with the version or architecture of this application (for example, code in a document targets 32-bit Microsoft Office applications but it is attempting to run on 64-bit Office).
This error has the following cause and solution:
Cause of the error:
The error is raised when a compilation error exists in the VBA code inside a protected (hidden) module. The specific compilation error is not exposed because the module is protected.

Possible solutions:
If you have access to the VBA code in the document or project, unprotect the module, and then run the code again to view the specific error.
If you do not have access to the VBA code in the document, then contact the document author to have the code in the hidden module updated.

Is it possible to upload it for x64 office versions?

Please use office 2007. For some odd reason 2010 version doesn;t work (problems in vba or something)

I have got it 'working' in 2010 in so much as it complains about a compilation error but still appears to change values etc... not checked it against 2007 yet to see if it creates nonsense data but will be installing 2007 on my XP VM where I use WinOLS and see what happens..

<tuffty/>

On office 2007 works well.
Thank you.

UPDATED!! FKKVS FIXER v1.1
New features:
* Brand new guessing algorithm of missing values

eurodyne maestro7 user here
just noticed that my KFZWOP map in maestro is 12x16
and on tuner wizzard that map is 11x16
how can i generate this map ?

Well, you could use 11 fields and the last one leave stock or just try to interpolate last field

UPDATED!! FKKVS FIXER v1.1a
New features:
+ Fixed a bug where user had to press on GUESS VALUES cell for it to work instead of auto-enable

UPDATED!! ME7 MAIN
New features:
+ UPGRADED to Office 2010
* Added RMB menu item: "Copy 2D Inverse Map", that allows easy transfer to WINOLS.

The latest version gives: Compile error in hidden module: CHANGE_APP_ICON.
This is with Excel 2010.

Also none of the calculation functions actually calculate anything (even if the variables are nulled the results remain the same).
With both Excel 2007 & 2010.

What am I missing?

Hm... now that is interesting... Have you enabled macros?

Yes, all macros have been enable.

I checked the "source" of your file.
The icon you are trying to use is not located in /system32/ on newer (64-bit) systems, instead in the sysroot.

Also for this specific script you must declare PtrSafe to make it run on 64-bit OS.

I am using 64bit win7 and no problems at all. If you know a fix for your specific case then try to implement somekind of precheck and add fix then upload here I'll try to check it and then if everything is ok I'll update first post

I just added "PtrSafe" to the three declares in APP_ICON function.
Now it works without giving the error all the time.

However I could not get the new icon (7) working even I relocated the source (explorer.exe).
Is is working for you then?

It is working for me... Maybe you could try to msgbox if your environment variable points to correct dir? Or atleast open explorer.exe with reshacker and see if there's icon with index 7... ;)

UPDATED!! BRAND NEW EEPROM MODDER v1.0
New features:
+ Autofix EEPROM checksums
+ Edit EXTRA INFO fields
+ Edit SKC KEY


NOTE: Checksums autofix isn't finished yet and doesn't always work 100%. Use with caution! :)

UPDATED!! KFMIRL ADVISER v1.3
New features:
+ Added preset option, which currently models K03 turbo from it's compressor map (1.8T only!, ALPHA VERSION - TESTING needed!)

very great work, but can you change the last Version so that i don`t get the Failur: Compile error in hidden module: CHANGE_APP_ICON.

can u help me i got message error
if u can have my kfmiop with good value that will be great
here is my project file kfmirl and kfmiop columns are good i need kfmiop modified.
let me know if u can help me

Hello very interesting excel and thread! How I have to consider a k04? Big turbo (respect to a k03) or small turbo (respect to a 2871 for example )? Checking the kfmirl adviser values with the boost and values of a tt bfv ecu seems that the suggested excel values are very lower than the original !

yes, they're lower because they're already calculated without LDRXN limit. After that try to use LDRXN sheet and you'll see different LDRXN limit. To me there's no point in using two limits since with kfmirl you can choose final load based not only on rpm (ldrxn limitation) but also on requested load.

Now to answer your other question: I would say try "big turbo" preset for K04 and see if turbo can keep up with the boost request....

ok thank you very much.
I will test the sheet and results and I will write again here ;)
bye

UPDATED!! KRKTE CALCULATOR v1.3
New features:
+Added KVB recalculation! ;)

Hi masterj

Any chance of a parallel version for us dinosaurs still using Excel 2003 please?  ;)

TTQS

Well, someone could port/update this version to work with earlier offices :) I'm sure there are only few things to change since almost everything is in vba :)

If someone will donate me 2003 version with cd key then I could try to update it ;)

Very cool and easy to use! I love this program so much already. The only thing I have noticed so far is that I cannot calculate KRKTE for a 5-bar FPR. It won't let me input the value.

Truth be told, I probably don't even need my 5-bar after switching from stage 3- to e85 with 750cc EV14's. I wanted to keep it in there because I might eventually be making a lot more HP and thought it wouldn't hurt to have the headroom (and lower duty cycles).

Edit: Trying the EEPROM modder and can't quite figure out how to get it to work. It detects errors on a stock b5 s4 m-box file when I load it.

EEPROM modder is still experimental :) It should work for ME7.5 eeproms... Please upload your eemprom dump and I will try to make it work for ME7 ;)

Same boat, but all sheets seem to work fine in Excel 2003.  Unprotect and change colors to something you can see, and ignore the occasional error message.

Hi,

just found this great wizard.
I played around with the eeprom-modder and it found a checksum error.
I fixed all the Checksums with another tool before i thought.
So please see attachment if there is something wrong with one of the two tools.
I also added some extra text which wont be displayed by vagcom :(

Is there something to pay attention to make it work?

Hi there! EEPROM MODDER is still in alpha version... basically is SHOULD fix checksums correctly, so I would just test this file and see what happens...

Good Job!!!!

Hi, everyone!
I've created a fork on github specifically for this wizzard so anyone could contribute :)

http://github.com/masterjguscius/NefMotoOpenSourceCollaboration (http://github.com/masterjguscius/NefMotoOpenSourceCollaboration)

Start contributing by adding new sheets, fixing compatability problems for older office versions and so on! :)

Hi - I'm getting a data-load error with your FKKVS fixer.  Could you recommend what I must do to fix this?  Perhaps I must edit the source-file's column headings?

Here is the screenshot and the log I'm trying to load.  Also, can you please advise how to set accurately set your Constant Parameters, "RPM Imperfection", "Injector Imperfection"?  Do you always use the "Try To Guess" option?

Cheers!

Have you logged these three variables with me7logger?

Does anyone have any suggestions of how to make this work in Open Office?

Yes, of course.  The attached spreadsheet has them.  Could you send me a log you have been able to get to work?  I can just take out the headers and replace mine with the ones that work.

P.S> I recommend watching me7 tunner wizz github's page @ http://github.com/masterjguscius/NefMotoOpenSourceCollaboration (http://github.com/masterjguscius/NefMotoOpenSourceCollaboration). I've already uploaded small update to the code which allows me7w to work on 32 and 64bit of office 2010 without any errors

Just uploaded new version, including updated KRKTE calculator (now it allows fuel pressure selection between 1 and 6 bar) and also fixed some startup errors on 64bit office ;)

From now on you can download latest version @ http://github.com/masterjguscius/NefMotoOpenSourceCollaboration (http://github.com/masterjguscius/NefMotoOpenSourceCollaboration)

NEW: CODEWORDS CONVERTER v1.0!
This will allow you to save some time by autoconverting decimal values to set bits! Easypeasy :)

You can do this in Tunerpro

Well, I'm not using tunerpro, so maybe this will be usable to people who use winols...

UPDATED: FKKVS FIXER v1.2

*New feature: combine old FKKVS table with new

Something wrong with my log file?

Try to use FKKVS fixer and cant open that file.
Excel says: Run time error '9' Subscript out of range

Try to log less data... (smaller size csv file)

I try with these and still no luck. I think its not size problem.

this one worked for me... try to compare to your file

There seems to be a problem with the KRKTE (plus TVUB) calculator.
I always get "value" in both KRKTE and TVUB. I think the problem is in the Bar section.
instead of puting `4.0 or `3.0  if I use the password and put manualy 3 or 4 (just like before the update)
it works again

What office version do you have?

I have same problem in office 2010

I have Office 2007 Enterprise ! The problem is exactly at the bar selection.Somehow it doesnt accept `3.0 `4.0 etc.

If I put manually just 3 or 4 it does the calculations correctly :)

I also have the problem with KRKTE, Run-time error "1004" when I try to edit any fields.
Use 2010 Office and the last ME7 TUNER WIZARD version.

Well in office 2010 you have to start with `, otherwise it goes nuts and converts these numbers to DATE  ;D

If you find a way to identify office version (maybe by some office global variable) you could add additional if/else that would change this field to integer without ` symbol ;)

you will have to google up what this runtime error means

Can anyone (other than the OP) chime in if the FKKVS "fixer" works?

This would save me so much time. I have no need for any of the other "calculators" as I already do everything manually.

Uses ti_b1, nmot and frm_w. Arranges the 02 correction and averages, fills up empty spots and smooths out the output.

I wrote a very similar sheet myself, but I use tevfakge_w instead which lets me rinse and repeat as I wish.

Can you please advice what is the address (and its size) for KFMIZUF, *ZUNS, *_UM, KFMPNS_UM, **DZOF_UM, **PED_UM? Also how to update KFMI_UM to refrect KFMIOP?

I am tuning my ORI of 06A***32LM MED7.5. Will post the result of a tune following your wizard, but my current .kp doesn't have those addresses. It has:
150CC : KFMIRL
16970 : KFMIOP
115BA : KFZWOP
1166A: KFZWOP 2

Or maybe you can share the address of your file? So, I might be able to search mine by comparing known addresses above.

ME7 TUNER WIZARD UPDATE!
Antilag and NLS helper added! No need to patch function manually anymore.

one z, not two, sir :)

fixed:)

In order to get the FVVKS fix to work how must you set up the log file? Can I just upload a maestro data log? I am figuring not. Thanks

me7logger with three variables

o2 correction, rpm and injector on time?

ti_b1, nmot and frm_w

I finally opened up the Wizard to check it out for the FKKVS fixer, and I'm having the same error.  I'm running Office 2010, and I have a feeling it's because you do the development on a different version of Office that there may be a few incompatibilities.  I know it's not the log file, cause I'm using your 'calibration FKKVS' log file that you verified works for you and you posted on the last page.

Has anyone who is using Office 2010 been able to successfully use the FKKVS fixer?

yes...me..microsoft office 2010...everything works flawless;)

keep up the good work masterj!

hi masterj,
thanks for this tool!
I'm learning to use WinOLS and I find it very useful

I'd like to import into KFMIRL adviser, the table kfmirl of wionls for my tt225.
is There a way to do this?
is big turbo a k04?
thanks
Daniele

K04 isnt big turbo :)

hi masterj
I'd use this tool to change my table kfmirl, but I did not understand how I should use the coefficients shown by the tool: (
can you help me to understand the formulas you use to change the data in the table according to the desired pressure?
thanks

why do I get a Run Time 52 Error?

I seem to have fixed that issue.

Using the LDRXN generator it makes some very high load levels very low.


RPM   1000   1500   1750   1950   2250   2500   3000   3500   4000   4500   5000   5500   5700   5900   6100   6700
LOAD   280   283   285   288   289   290   291   290   290   290   279   270   266   263   260   252

How did you fix the run time 52 error?

I opened the VB editor closed the excel doc then reopened the xls with the VB editor open and macros showing. Its prolly a bandaid but it worled

Screenshot your kfmirl

(http://i101.photobucket.com/albums/m56/ejgsjeep/LDRXN-KFMIRL_zpsdc2257a4.jpg) (http://s101.photobucket.com/user/ejgsjeep/media/LDRXN-KFMIRL_zpsdc2257a4.jpg.html)

Now that is interesting... if you change kfmirl table does the ldrxn table also change?

yea its responsive but the numbers don't seem to make any sense. ???

Yes you are right... hm... weird thing is that locally i get correct values. Have you encountered any error during start up?

just that run time error posted above but I seem to have fixed that.

Not in your sig :)

Oh yeah :) forgot about it completely

Uploaded antilag sheet patch by professor ;)

Thanks for this

Can be antilag implemented on 032AF flash? (512K)
i can`t find that sequence of bytes that is needed in my flash.

I been getting runtime error 52 also - I'll try what he did.

Im on 7 x64 with 2010. 

M7W dont work with Appache office 2013 ??


Because when I change table of KFMIRL, LRDXN Dont change :( ..

Anyone having trouble with the FKKVS fixer?  Ive got the nmot, T1-B1, and FRM_W values logged from ME7logger and go to upload a logfile and the file claims I havent logged them.

Really want to start scaling my injectors in.

Did you log nmot or nmot_w ? FKKVS works with nmot.

nmot_w.

I tried removing the _w from the end and it still never worked (in the log)  unless the values outputted are different.

What am i doing wrong?
I can not get KRKTE value, using Office 2010.(http://i1360.photobucket.com/albums/r658/Lion_32/krkte_zps1270217c.png)

Try to use dot . in numbers

doesnt work here with , and .  :-\

goto office options and set the dot as decimal divider
reload it and try with dots

perfect, thanks

So log nmot, FKKVS fixer wants intergers, not floating numbers.

Will do. Thanx!!

Hello everyone
has anyone tried to use me7 wizard with the MED9 ECU
thanks

Simply Awesome! Thanks a ton for not only making this happen, but for sharing it with users like me with a severe lack of programming knowledge as well as a limited, but growing, knowledge of tuning. Much appreciated!   :)

The tuner is linked to the cars PCM. If you use that handheld on your car without getting it linked to the PCM to load a tune..checking codes is fine, you will brick your car..pretty sure, at least.

Hi,

On FKKVS fixer, I can't choose smaller pulse than 1ms (I would like 0,8ms). Could you edit to allow it ?

Tried to use this today, all I am getting in the "New FKVSS" is a bunch of #### marks in all the cells.  Ive logged the correct variables, log is about 3mb

What data is the K03 Extreme Map based on?  Attached image...

Iirc based on compressor map

Just a quick note for everyone, if anyone is still having trouble with the runtime error 52 when opening in excel ive found the fix, go to the fkkvs fixer page and scroll to the bottom of the page where you should find a directory address something along the lines of "d:/sandbox/*** etc etc, remove this link and resave the document. job done, no more errors and everything working normally again.

Will this work with me7.5 1.8t??

mine is me7.5 1.8t aum and it worked for mine. so yes mate.

hi can some please check if my log is ok for the FVVKS Fixer?
cant get it work...

thanks

What version of office have i to use to open this file? Are there any settings to use? Couze i've tried but...seems didn't work well :(

Good evening, I downloaded your tool ME 7 tuner wizard and thank you for sharing, it is very useful. I would like to make a request, you can create a wizard to work with med 17 etc? the size of the tables (kfmirl & kfmiop etc is different) are willing to pay if you can fulfill this request. for example, I'm working with an ECU me 7_9_10 Abarth, the kfmiop size is 12x16, 16x12 is in your tool instead. It would be great to edit the wizard table with the size of the map on which you are working. in Waiting for your kind reply thank you very much .You excuse my language but use a translator.

i’m using the FKKVS fixer logging with ME7Logger (frm_w, nmot(not nmot_w), ti_b1), after having set NOLRA=3 (bits 0,1 set to true) with the log set up exactly like the examples posted and it’s still telling me i haven’t logged those variables.

I tried NOLRA=7 as well (bits 0,1,2 set to true)

Use the standalone fkkvs fixer, or better yet do it manually :).

The standalone fixer produces values that dont make sense and throw all my fueling values (AFR’s and trims) way off. The numbers are erratic and way too high (1.05 in areas)

I tried a log today with fr_w, frm_w, lamsbg_w, lamsoni_w, nmot, tevfakge_w, ti_b1 and the wizard fixer thought for a bit then spit out a runtime error 9 subscript out of range. I manually shortened the log from 2500+ sec to 1799 sec and it goes back to the error:
“you havent logged either frm_w or nmot or ti_b1!”

I used the attached .csv with a freshly downloaded version of the wizard FKKVS fixer, still getting a runtime error 9 subscript out of range.
Something is wrong.


*EDIT: Tried on office 2010, 2013, 2016 and mac using Masterj’s file. Runtime error 9.

I have a question of the right use of KFMIOP map. Im with 1.8T Me7.5 and my original KFMIOP map is with % axis 10,15,20,35% .... and the one on the Wizard is with axis % - 17,27,55,64%.
When i click Suggest Optimal X-axis i receive the message that i attached. What am i supposed to do? Write wizard axis on my kfmiop map? or some changes in KFZWOP axis ? Thanks

write the original numbers down on the x axis that you have from your current map (not the wizard), after you hit the button it will change those 17 27 etc... numbers. it's telling you that you will need them for the following page in the wizard to scale kfzwop maps to allow for the increased torque you are requesting

Hi all

I have found a big problem in KRKTE calculator (KVB actually).

I tried to write Marius direct messages here and using email (email address is invalid now) - no answer was received.
So I decided to fork an project at githab.
https://github.com/z1ck/ME7-Tuner-Wizard-2021
There is a new version of file.

UPDATED!! KRKTE calculator version now is 1.5.
New features:
* Bugfix, now it should properly calculate KVB value

antivirus swears at a trojan in your file

the same was for an original file. It is because it crypted.

UPDATED!! KFZWOP/2 CONVERTER version now is 1.3.
Bugfixes:
* last row was wrong scaled.
* rows where new load = old load was wrong scaled in some cases.
* added reminder to rescale KFMDS.
* accuracy increased.

https://github.com/z1ck/ME7-Tuner-Wizard-2021
There is a new version of file.

Hi
KFMIOP calc 12x16|11x16 wrong calculation?
Didint calculate KFMIOP map properly.

In z1ck's sheet i also wasnt able to do this calcs. I used masterj's old sheet for everything, except KFZWOP

This is a great tool! Thanks to MasterJ!

Though I notice that the KFMIOP Calculator is not EXACTLY inverse and is slightly off by 1 (sometimes even 2 units) on some cells.

Is this normal or I did something wrong?

Did you(or anyone) ever figure this one out?? I am having the same issue. Logging with ME7logger, and it keeps telling me I haven't logged them. Even when that was all I logged....  Really want to give this thing a try.... :(   I have tried Office '16 on WIN10, and Office '10 on Win7...

@Inlandviking i pm'd you.

As a newbie - this is a relief to have found.
This tool is epic.  Thanks MasterJ

I have an error in the KRKTE Calculator, (a value used in the formula has the wrong data type)


=SE(D22=“Gas”;(50,2624*E20/H20*0,001)/(H22*RAIZ(E24/3)*0,684);(67,7104*E20/H20*0,001)/(H22*RAIZ(E24/3)*0,684))

I think the error is in E20 and H22, but I haven't found a solution yet