![]() |
What's the best formula for figuring out LOAD?
I can't get the load calc program to work, it keeps getting an error. So I figured someone knows what the best function to use in Excel is to calculate LOAD.
All the data logger programs have one cool function but not another, it's hard to find a complete package. Would be cool to be able to log: Wideband AFR (from multiple sources ie: LM-1, Zeitronix, etc) Boost RPM LOAD TPS Injector Duty % EGT Knock All in one program... Does this exist? Evoscan is pretty good, there's just no LOAD calculated. |
5*InjectorScale*(InjPulseWidth-InjectorLatency)/AFRMAP
But you can just digest your logs using my log analyzer and it will do it for you.. In my logger it already supports this (this is directly from the XML data in the program) and Evoscan 0.96 when its released will also have load calculation built in (so you won't need my log analyzer anymore for the new version) Evoscan has some widebands supported, My program will support different ones (TurboXS Tuner, PLX products, and others), and Epifan's ECUEdit has some widebands supported with its new MUT logging, and you can ad load calculation to his program too.. Only I'm not sure if the trial version can do everything.. |
If the Wideband has alternative inputs, then my logger will support the alternate inputs also, I'm pretty sure the others will too..
|
I've tried Ecuedit and it will display my wideband afr but it will not log it.
Do you know how to make Excel spit out a chart with the data from evoscan that would mimic the look of the ECUflash fuel map charts for the EVO.... So it would list LOAD at the top horizontally and RPM's down the left side vertically and then show you the actual or avg afr #'s per cell? Thanks for the formula too... |
MJ have you traced the maps when you calculate the load ??
I find the fuel maps (using AFRMAP as basis like ignition timing) lagging behind the timing maps .. there are cases where the timing does match what is being calculated too .. so how accurate is this load ?? |
Oh yeah, what's the trick to getting your calc. to work? I drag my evoscan log files onto it and it gives me an error every time and doesn't do anything.
The Error says: Unhandled exception has occurred in your application. If you click continue the application will ignore this error and attempt to continue. Conversion from String "201.6176" to type 'Date' is not valid. If I hit continue it spits out a .dll file but when I open it, it's blank, no data. |
Are you using v 0.9? Be sure to enable AFRMAP before you log.. and do not edit the log and save it, before attempting to digest.
|
Originally Posted by Dus10
I've tried Ecuedit and it will display my wideband afr but it will not log it.
Do you know how to make Excel spit out a chart with the data from evoscan that would mimic the look of the ECUflash fuel map charts for the EVO.... So it would list LOAD at the top horizontally and RPM's down the left side vertically and then show you the actual or avg afr #'s per cell? Thanks for the formula too... You can also do this in Excel by creating a chart that uses scatter values, using calculated load (either after running it through my analyzer, or calculating it yourself) and RPM.. |
Originally Posted by Dus10
Oh yeah, what's the trick to getting your calc. to work? I drag my evoscan log files onto it and it gives me an error every time and doesn't do anything.
The Error says: Unhandled exception has occurred in your application. If you click continue the application will ignore this error and attempt to continue. Conversion from String "201.6176" to type 'Date' is not valid. If I hit continue it spits out a .dll file but when I open it, it's blank, no data. Since the log analyzer is fairly dependent on delimiters in the date/time columns, if you loaded it in Excel and saved it, BEFORE running it, it will fail with that error.. I always run the log analyzer before I put the files into any other app since the default timestamps make reading the logs fairly difficult, so the analyzer rewrites the seconds column to start at 0 and count from there, and removes the time column.. |
I've noticed that if I turn on the AFRMAP my wideband readings are way screwy. When it should be around 14.7 it reads 128 point whatever. Is it supposed to do that?
|
Is this in the raw logs from Evoscan? Or after you put them into the Log analyzer?
Unfortunately Evoscan doesn't always output data predictably when you have the wideband stuff enabled.. And in turn my app doesnt always recognize the last column and forgets to add a comma. It has to do with how many commas appear in the logs.. My app doesnt care how many, only that there are the same amount of items in the log lines, as there are in the header.. If not, you get columns that shift around.. Evoscan occasionally has the same glitch that my app has, and that is under some circumstances, if there is no data, the logged item is dropped, and it forgets to delimit that missing column and the whole line is compressed.. Not important for programs like Excel (where you just see the data shifted over) but it is a problem for tools to analyze the logs where the data is in the wrong place. I'm fixing it in my program, and I'll pass the word along to the author of EvoScan too so he can look at it in his program.. |
BTW Now that I'm releasing betas of my Logger, I will no longer be releasing new versions of the Evoscan log Analyzer, so hopefully when he releases his new version, it will no longer be needed.
|
Hey MJ -- I logged onto activematrix, see the posts about the new MitsuLogger, but cannot seem to find the download. I know it is early, but am I really this tired ? Did you remove the download link? Thanks
|
Since it was an early beta, its in the thread (first message in the thread) But you have to be logged on to see it.. Otherwise you won't see the attachment.. I don't put the early beta stuff in the regular download section because I don't want them to get downloaded by mistake.
Hold off on Downloading V1 Beta 2... I will be releasing a bugfix tonight or tomorrow which will be v1 Beta 3... Once I get the bugs out, I'll disable some of the incomplete stuff (the map tracing) and make an official release.. |
| All times are GMT -7. The time now is 07:06 PM. |
© 2026 MH Sub I, LLC dba Internet Brands