When does your spreadsheet apply the turbo torque to the engine? Because after a quick read through of the game lua, it seems like the turbo coef has friction and dynamic friction applied to it separately
That version might not be even in operational order, but formula is like this currently it seems =(K3/(F3*J3*0.06+1)+($B$7+$B$8*$B$2*D3)-E3)*IF(F3>0,$C$8,1) it is almost a year since I did play around with that and I might need to put few hours figuring out what I have done there I need to look into that lua, there could be even changes to game that have happened in almost a year, so maybe that friction stuff solves it. I remember that I did play around a lot with how to apply friction. Definitely would need to calculate friction after have removed added power by turbo, not sure but I think that does it already or then it is just buggered. Update: Yeah, it does first reduce torque by amount of turbo, then calculates friction from NA power, so that should be correct way, at least in theory. Also 6% torque increase for each PSI, now that makes things tough of course, 6% reduction for each PSI is not same as 6% increase and there it goes all wrong. Say 10 psi would be 60%, increase 100hp by 60% and you are at 160hp. Reduce 60% from 160hp and you are not at 100hp though. So we have: Percent of increase Y Percent of decrease X New torque Z X = Z ??? Y??? Need to study more math, but maybe there just is one unknown too many? Update 2: Nope, I had actually studied same math year ago, just forgot all about it, calculation should be correct according to this http://web.mnstate.edu/peil/MDEV102/U4/S34/S344.html Needs more scalp scratching I guess.
hey there I figured out an issue with the sheet that i fixed right after on the data exporter ! it showed code that points to next cell instead of the correct cell we needed... i mean that for example it showed 1000 rpm then right under 1000 rpm again and it crashed all the curve like this so i fixed this then reincremented for the rest of the curve no need to thank that i also put the rpm incrementation to 100 up to 9000 rpm for those who take care of this thanks in advance... arno64160
