Notices
ECU Flash

calc HP/TQ from EvoScan using Excel

Thread Tools
 
Search this Thread
 
Old Jun 9, 2009 | 11:47 AM
  #346  
SEEnoEVO's Avatar
Evolved Member
iTrader: (21)
 
Joined: Dec 2006
Posts: 544
Likes: 1
From: D
Originally Posted by Jack_of_Trades
This app is no different than the DLL concept, just freeware basically. It was my first attempt playing around with Excel and it will get better as I learn more, but as Bryan mentioned...just another tool. If Evoscan's HP/TQ simulator worked, or DLL was easier for the evoscan users (and cheaper) I wouldnt have bothered. I basically made it for the fun of it.
And for that....we thank you!!

Great job man!! This thing has progressed very nicely and I am sure it will only get better. Very impressive work to all the people that have put time into refining it.
Reply
Old Jun 9, 2009 | 04:20 PM
  #347  
fostytou's Avatar
EvoM Community Team
iTrader: (15)
 
Joined: Sep 2006
Posts: 3,143
Likes: 7
From: Aurora, IL
Thanks for the update

The only thing I'm not as fond of with this version is that I can't modify final ratio for a different tire size. I know you are "done" but if you ever hop back to it the ability to put in actual gear/tire/etc would be nice
Reply
Old Jun 9, 2009 | 04:26 PM
  #348  
Jack_of_Trades's Avatar
Evolved Member
iTrader: (17)
 
Joined: Jun 2007
Posts: 3,523
Likes: 2
From: Opelika,AL
Originally Posted by fostytou
Thanks for the update

The only thing I'm not as fond of with this version is that I can't modify final ratio for a different tire size. I know you are "done" but if you ever hop back to it the ability to put in actual gear/tire/etc would be nice
That can be added easy enough. Gimme a few days
Reply
Old Jun 10, 2009 | 10:57 AM
  #349  
rolly1818's Avatar
Registered User
 
Joined: Nov 2007
Posts: 1,507
Likes: 2
From: Trinidad
That can be added easy enough. Gimme a few days
...and the saga continues

good work on the program though!

two questions:

1. smoothing really changes the numbers on a car that much (i thinking i am logging to much!)
2. when i enable the SAE corrections i get no change in the curves....i am thinking after i enable it i need to change the temperature and pressure conditions to those of SAE - what are they?
Reply
Old Jun 10, 2009 | 11:20 AM
  #350  
Jack_of_Trades's Avatar
Evolved Member
iTrader: (17)
 
Joined: Jun 2007
Posts: 3,523
Likes: 2
From: Opelika,AL
I just got the program to have over 20x the resolution so keep your eyes out for my newest update
Reply
Old Jun 10, 2009 | 11:44 AM
  #351  
nonschlont's Avatar
Evolved Member
iTrader: (3)
 
Joined: Mar 2007
Posts: 1,760
Likes: 2
From: Ca
Reply
Old Jun 10, 2009 | 12:53 PM
  #352  
Jack_of_Trades's Avatar
Evolved Member
iTrader: (17)
 
Joined: Jun 2007
Posts: 3,523
Likes: 2
From: Opelika,AL
Could someone do a 3rd gear pull with the following conditions:

-wide open throttle pass from 3000 rpm to 7500 rpm

-datalog RPM ONLYYYYY

-'log to screen' feature disabled in evoscan

-super logging speed enabled in evoscan

-multi-threading disabled in evoscan


This would be of greathelp,thanks guys
Reply
Old Jun 10, 2009 | 02:22 PM
  #353  
nonschlont's Avatar
Evolved Member
iTrader: (3)
 
Joined: Mar 2007
Posts: 1,760
Likes: 2
From: Ca
Originally Posted by Jack_of_Trades
Could someone do a 3rd gear pull with the following conditions:

-wide open throttle pass from 3000 rpm to 7500 rpm

-datalog RPM ONLYYYYY

-'log to screen' feature disabled in evoscan

-super logging speed enabled in evoscan

-multi-threading disabled in evoscan


This would be of greathelp,thanks guys
here ya go... from today. It cooled down ~ 15-20* out here, (~65) so there was a couple slight corrections taking place...
all pre-requisites have been met.
Attached Files

Last edited by nonschlont; Jun 10, 2009 at 06:52 PM.
Reply
Old Jun 10, 2009 | 02:38 PM
  #354  
fostytou's Avatar
EvoM Community Team
iTrader: (15)
 
Joined: Sep 2006
Posts: 3,143
Likes: 7
From: Aurora, IL
Originally Posted by Jack_of_Trades
Could someone do a 3rd gear pull with the following conditions:

-wide open throttle pass from 3000 rpm to 7500 rpm

-datalog RPM ONLYYYYY

-'log to screen' feature disabled in evoscan

-super logging speed enabled in evoscan

-multi-threading disabled in evoscan


This would be of greathelp,thanks guys
I'll see if traffic is calm enough at the closed course I use on the way home
Reply
Old Jun 10, 2009 | 04:34 PM
  #355  
fostytou's Avatar
EvoM Community Team
iTrader: (15)
 
Joined: Sep 2006
Posts: 3,143
Likes: 7
From: Aurora, IL
Originally Posted by fostytou
I'll see if traffic is calm enough at the closed course I use on the way home
http://thefrost.net/randomfiles/tuni...0_17.38.58.csv

Note that there was a NLTS to 4th at the end... I just couldn't resist. Looks like the RPM jumped about 150 RPM, so you might want to remove that.

68 °F
Barometer: 29.82"

EDIT: here is 3rd isolated from that log
http://thefrost.net/randomfiles/tuni...olated.csv.xls

Also, it would be nice if you could take the names of everything from one place IE so I can replace "base" somewhere with a more meaningful label (for later comparison) and have it populate through the spreadsheet. You can just use "Concatenate( text1, text2, ... text_n )" to make it look right in the other cells.

Last edited by fostytou; Jun 10, 2009 at 04:48 PM.
Reply
Old Jun 12, 2009 | 10:01 AM
  #356  
Jack_of_Trades's Avatar
Evolved Member
iTrader: (17)
 
Joined: Jun 2007
Posts: 3,523
Likes: 2
From: Opelika,AL
Well, so far the best combo is version 5.0 that I posted already. I can get the resolution to be ASTOUNDING but there are too many variances in datalog data per second to make it consistent. The software in a real dyno has a 'set in stone' pre-determined amount of data per second so its easy to have their graphs the same regardless of the pull. The thing that ruins the data is repeated RPM values. With a data file with poor resolution, the largest gap between RPM values is between 200-250 RPM, which is why I chose to have the data recorded every 250 RPM so no matter what size file you load, it'll work.

From 3000-8000 RPM we only have 160 possible RPM values when using the standard 1-byte RPM. If we use the 2-byte RPM instead we will have 1280 RPM values from 3000-8000 RPM but I'm not sure how the infamous 2-byte spikes will affect the data.

What I might do is have 2 seperate simulators built-in to one with a dropdown box for 1-byte or 2-byte RPM. What I will need is some logs from 3k-7+k RPM while logging ONLYYYY 2-byte RPM, hopefully some logs with the infamous 2-byte spikes in them. If I can prove that the smoothing will remove the spikes then I can make one VERY accurate simulator for us. Thanks to everyone who has contributed data files thus far!

I have the tire diameter stuff all figured out and I will make a label window so the users can change the base pull/comparison pulls.
Reply
Old Jun 13, 2009 | 03:09 AM
  #357  
acamus's Avatar
Evolved Member
 
Joined: Mar 2008
Posts: 730
Likes: 3
From: Lattitude 48.38°, Longitude 17.58°, Altitude 146m = Slovakia, for common dude
Very neat tool, thank you for sharing.

My wish list would include setting of custom gear ratio's (non-evo mitsu)
and metric unit system....

If it was not password protected I would do it myself... ,
And I am not in the mood to crack the password

Last edited by acamus; Jun 13, 2009 at 03:16 AM.
Reply
Old Jun 13, 2009 | 12:08 PM
  #358  
nonschlont's Avatar
Evolved Member
iTrader: (3)
 
Joined: Mar 2007
Posts: 1,760
Likes: 2
From: Ca
Originally Posted by Jack_of_Trades
So I found a nice way to standardize how many lines of data gets inoutted thru the formulas by using the 'lookup' feature I can have the spreadsheet find the closest data at RPM intervals. So it will look in column 'B' for the closest value to 3000 rpm, then 3050 rpm,then 3100 rpm, etc... and also have it lookup the LogEntrySeconds in that same row. I will set it to check from 3000 rpm to 8000 rpm in 50 rpm intervals which will give us a constant 100 lines of data regardless of the file size. This should help make the spreadsheet more consistent between large and small datalogs, and make it easier to have the smoothing factor be consistent as well. I just need to do some more testing to find the best smoothing values to use and such.
instead of trying to find a compromise in consistancy between shorter log files and a longer log files, would it make things easier on you to create it to be consistent w/ just "longer" log files? And the user would need to log 10 data items or less to get accurate readings... The spreadsheet is set up for logging 2 items, so as long as we keep it to a "minimum" of data items being logged, it will work fine...
Just a thought....

This is an awesome tuning tool, and you/we're soo close...
Reply
Old Jun 13, 2009 | 02:19 PM
  #359  
RAbishi's Avatar
Evolved Member
iTrader: (4)
 
Joined: Mar 2006
Posts: 942
Likes: 0
From: South Dakota
This version 5.0 is working great! Thanks for all the effort everyone has put into it.
Reply
Old Jun 14, 2009 | 04:23 PM
  #360  
racer135's Avatar
Evolved Member
iTrader: (2)
 
Joined: Nov 2007
Posts: 819
Likes: 1
From: Puerto Rico
I notice that in Ver 4.1 if I start a pull at 2500 the plot pretty much starts at 2500 (just a little higher). On Ver 5 with the same data (pull starting at 2500 or even 2250) the plot starts at approx 3300 and by that time the stock 9.8 was almost full boost so I do not see the torque curve goingup like the earlier versions. Ver 5 has some nice features but in my case the plot look more complete and more like a dyno readout on ver 4.1 because of the late plot graph on ver 5. Also ver 4.1 it can be modified (not password protected like ver 5).
Reply



All times are GMT -7. The time now is 07:43 PM.