calc HP/TQ from EvoScan using Excel
#46
All that's needed is the standard rpm. Rearrange the logging parameters so that RPM is the first or second item logged. And log only the minimum number of items. Don't log such things as battery, fuel trims, baro, and other things that don't really matter for WOT tuning.
#47
Evolved Member
iTrader: (3)
I have loaded up 4 different 3rd gear pulls, and 3 of them have shown me in the 600's
Im still logging tps/rpm/load/boost/boost error/afr/knock/timing/WGDCC/gear. Is this too many data items to log?
Edit: I just used another log from this morning, and now Im only @ 330hp/410tq. :P Definitely a 3rd gear pull! I think its still a bit off for me though...
Im still logging tps/rpm/load/boost/boost error/afr/knock/timing/WGDCC/gear. Is this too many data items to log?
Edit: I just used another log from this morning, and now Im only @ 330hp/410tq. :P Definitely a 3rd gear pull! I think its still a bit off for me though...
Last edited by nonschlont; Apr 25, 2009 at 04:47 PM.
#48
Evolving Member
iTrader: (15)
Cool stuff, thanks MrFred!!
Now I just need to get rid of that compressor surge.
PD: If my calculations are correct, 5 speed users should change their 3rd gear rpm/mph to 87.27 and 4th gear to 66.26; asuming MrFred used his 6-speed to enter the data in the charts. The difference is not that big anyways.
Now I just need to get rid of that compressor surge.
PD: If my calculations are correct, 5 speed users should change their 3rd gear rpm/mph to 87.27 and 4th gear to 66.26; asuming MrFred used his 6-speed to enter the data in the charts. The difference is not that big anyways.
#49
I have loaded up 4 different 3rd gear pulls, and 3 of them have shown me in the 600's
Im still logging tps/rpm/load/boost/boost error/afr/knock/timing/WGDCC/gear. Is this too many data items to log?
Edit: I just used another log from this morning, and now Im only @ 330hp/410tq. :P Definitely a 3rd gear pull! I think its still a bit off for me though...
Im still logging tps/rpm/load/boost/boost error/afr/knock/timing/WGDCC/gear. Is this too many data items to log?
Edit: I just used another log from this morning, and now Im only @ 330hp/410tq. :P Definitely a 3rd gear pull! I think its still a bit off for me though...
Cool stuff, thanks MrFred!!
Now I just need to get rid of that compressor surge.
PD: If my calculations are correct, 5 speed users should change their 3rd gear rpm/mph to 87.27 and 4th gear to 66.26; asuming MrFred used his 6-speed to enter the data in the charts. The difference is not that big anyways.
Now I just need to get rid of that compressor surge.
PD: If my calculations are correct, 5 speed users should change their 3rd gear rpm/mph to 87.27 and 4th gear to 66.26; asuming MrFred used his 6-speed to enter the data in the charts. The difference is not that big anyways.
#50
Evolved Member
iTrader: (3)
[QUOTE=mrfred;6986036]You were on flat ground with no wind (or minimal wind), correct? Post one of the logs.
heres an old pull. (3rd gear) All my pulls are done in the same place, nice flat surface, w/ minimal wind. I just had a 30* weather change, so my pull from today, was less than desireable.
and heres how it looks for me.
heres an old pull. (3rd gear) All my pulls are done in the same place, nice flat surface, w/ minimal wind. I just had a 30* weather change, so my pull from today, was less than desireable.
and heres how it looks for me.
#51
Evolved Member
iTrader: (17)
I forgot to mention that I changed my rpm/mph multiplier to 84.65 for 3rd gear which was the value I got on a few online calculators (here is one) using a final gear of 4.529, a 3rd gear of 1.407 and a tire diameter of 25.3" since thats the ACTUAL tire diameter of the Yokohama advans that come factory on my car.
EDIT: I realized my vehicle weight was off too so my new figures are this:
RPM/MPH value= 84.65
Dyno Correction for Buschur MD Dyno= .990
Dyno Correction for Turbotrix Dynojet Dyno= 1.164
I always log my car while strapped on a dyno so at least I know my "road and load conditions" were the same lol.
I think some people forget that they need to only paste in the section of the actual 3rd or 4th gear pull from the second they mash the gas, til the very instant they let off. If I log anything else it will severely throw off my numbers sometimes. I also know the exact weight of my car with me in it which is 3300lbs, on average depending on how full my tank is...mine is nowhere NEAR 3500lbs you have as the default, so its important that the guys hit up anywhere they can to get a good base vehicle weight.
EDIT: I realized my vehicle weight was off too so my new figures are this:
RPM/MPH value= 84.65
Dyno Correction for Buschur MD Dyno= .990
Dyno Correction for Turbotrix Dynojet Dyno= 1.164
I always log my car while strapped on a dyno so at least I know my "road and load conditions" were the same lol.
I think some people forget that they need to only paste in the section of the actual 3rd or 4th gear pull from the second they mash the gas, til the very instant they let off. If I log anything else it will severely throw off my numbers sometimes. I also know the exact weight of my car with me in it which is 3300lbs, on average depending on how full my tank is...mine is nowhere NEAR 3500lbs you have as the default, so its important that the guys hit up anywhere they can to get a good base vehicle weight.
Last edited by Jack_of_Trades; Apr 25, 2009 at 07:48 PM.
#52
[QUOTE=nonschlont;6986354]
I got reasonable numbers from your log. See pic below. I posted the Excel file too. You'll get a better result too if you log fewer items. I always am for at least 70 lines of data at 100% TPS for a run from 2200 rpm to 7200 rpm. There's no need to calc IPW, but I guess that's being used for the EvoScan HP/TQ calc?
3500 lbs with you in it? That's pretty good. Mine always comes in at about 3450 lbs with me in it when I go to the scale at the local dump.
You were on flat ground with no wind (or minimal wind), correct? Post one of the logs.
heres an old pull. (3rd gear) All my pulls are done in the same place, nice flat surface, w/ minimal wind. I just had a 30* weather change, so my pull from today, was less than desireable.
and heres how it looks for me.
heres an old pull. (3rd gear) All my pulls are done in the same place, nice flat surface, w/ minimal wind. I just had a 30* weather change, so my pull from today, was less than desireable.
and heres how it looks for me.
...
I think some people forget that they need to only paste in the section of the actual 3rd or 4th gear pull from the second they mash the gas, til the very instant they let off. If I log anything else it will severely throw off my numbers sometimes. I also know the exact weight of my car with me in it which is 3300lbs, on average depending on how full my tank is...mine is nowhere NEAR 3500lbs you have as the default, so its important that the guys hit up anywhere they can to get a good base vehicle weight.
I think some people forget that they need to only paste in the section of the actual 3rd or 4th gear pull from the second they mash the gas, til the very instant they let off. If I log anything else it will severely throw off my numbers sometimes. I also know the exact weight of my car with me in it which is 3300lbs, on average depending on how full my tank is...mine is nowhere NEAR 3500lbs you have as the default, so its important that the guys hit up anywhere they can to get a good base vehicle weight.
Last edited by mrfred; Apr 25, 2009 at 09:17 PM.
#55
Evolved Member
iTrader: (17)
I forgot to mention that I use OpenOffice not Microsoft. I selected the Major grid lines for the x-axis but they only appear on the edge of the graph, not through it. If I highlight the graph, then select "format" on the dropdown list at the top I can select "GRID" but it only has the Y-axis MAJOR GRID highlighted, all other minor and major grids are greyed out so i cant choose them. Its not necessary, I just hate not being able to modify somethng the way I want it to work lol.
NVM: I had to select the "INSERT" dropdown and select "GRIDS" to shoose which axis' i wanted to intersect. Thanks anyways.
NVM: I had to select the "INSERT" dropdown and select "GRIDS" to shoose which axis' i wanted to intersect. Thanks anyways.
Last edited by Jack_of_Trades; Apr 26, 2009 at 04:20 PM.
#56
Evolved Member
iTrader: (17)
If anyone is interested, I modified this excel file so you can load 2 logs and do A/B comparisons. I also added SAE corrections and a dyno correction factor. A dyno correction factor of 1.02=Buschurs Mustang Dyno, 1.200= Turbotrix Dynojet Dyno.
Its set only for 3rd gear pulls with 5 speeds but I can get the rpm/mph value for any other gear and for the 6 speeds too if you guys need it. I also have the graphing resemble DLL's graph since i like the layout.
Its set only for 3rd gear pulls with 5 speeds but I can get the rpm/mph value for any other gear and for the 6 speeds too if you guys need it. I also have the graphing resemble DLL's graph since i like the layout.
#57
Evolving Member
iTrader: (4)
If anyone is interested, I modified this excel file so you can load 2 logs and do A/B comparisons. I also added SAE corrections and a dyno correction factor. A dyno correction factor of 1.02=Buschurs Mustang Dyno, 1.200= Turbotrix Dynojet Dyno.
Its set only for 3rd gear pulls with 5 speeds but I can get the rpm/mph value for any other gear and for the 6 speeds too if you guys need it. I also have the graphing resemble DLL's graph since i like the layout.
Its set only for 3rd gear pulls with 5 speeds but I can get the rpm/mph value for any other gear and for the 6 speeds too if you guys need it. I also have the graphing resemble DLL's graph since i like the layout.
If you could do the changes to allow for 6 speed box's & include both 3rd & 4th gear that would be really awesome & very much appreciated mate. At the moment I'm using this spread sheet to show the different changes my tuner is doing for me & with the A to B comparison it will highlight each tweak that's done. This will be an asset to see the base tune vs final tune....fantastic work. I road log in 3rd & get dynoed in 4th.
Have I read this correctly, your power & torque numbers with Mr Fred's chart match your MD & DJ power/torque figures? Or does your evoscan data correspond equally for your road logs to your evoscan data dyno runs/logs? If Mr Fred's power/torque graphs are equal to dyno figures this would save quite a few people having to book in for expensive dyno power runs.
Since you have the ability to compare DLL to this excel program using your evoscan data, is there a big difference between the two power/torque readings?
Thanks very much.
Cheers Steve
#58
Evolved Member
iTrader: (3)
Hey Jamie,
If you could do the changes to allow for 6 speed box's & include both 3rd & 4th gear that would be really awesome & very much appreciated mate. At the moment I'm using this spread sheet to show the different changes my tuner is doing for me & with the A to B comparison it will highlight each tweak that's done. This will be an asset to see the base tune vs final tune....fantastic work. I road log in 3rd & get dynoed in 4th.
Have I read this correctly, your power & torque numbers with Mr Fred's chart match your MD & DJ power/torque figures? Or does your evoscan data correspond equally for your road logs to your evoscan data dyno runs/logs? If Mr Fred's power/torque graphs are equal to dyno figures this would save quite a few people having to book in for expensive dyno power runs.
Since you have the ability to compare DLL to this excel program using your evoscan data, is there a big difference between the two power/torque readings?
Thanks very much.
Cheers Steve
If you could do the changes to allow for 6 speed box's & include both 3rd & 4th gear that would be really awesome & very much appreciated mate. At the moment I'm using this spread sheet to show the different changes my tuner is doing for me & with the A to B comparison it will highlight each tweak that's done. This will be an asset to see the base tune vs final tune....fantastic work. I road log in 3rd & get dynoed in 4th.
Have I read this correctly, your power & torque numbers with Mr Fred's chart match your MD & DJ power/torque figures? Or does your evoscan data correspond equally for your road logs to your evoscan data dyno runs/logs? If Mr Fred's power/torque graphs are equal to dyno figures this would save quite a few people having to book in for expensive dyno power runs.
Since you have the ability to compare DLL to this excel program using your evoscan data, is there a big difference between the two power/torque readings?
Thanks very much.
Cheers Steve
I just tested this one out... Seems to be quite accurate compared to my data logs from evoscan power wise, w/ corrections factor @ 1.200 Also is very close to the dynojet I was on out here. I also checked the output @ 1.02 correction factor, and that seems to be right around where it should be. (I havent been on a mustang dyno) I did notice that the graph is showing peak TQ @ 4000, rather than 3500 in my log though.
Last edited by nonschlont; May 14, 2009 at 12:34 AM.
#59
Evolving Member
iTrader: (4)
I had intended to use DLL to calc HP/TQ from my EvoScan logs, but after getting nowhere with the definition file to read my EvoScan logs, I decided to create my own Excel spreadsheet to calc HP/TQ. It uses the same principle as DLL to calc HP/TQ from rpm and time. I've got it setup to calc HP/TQ from either 3rd gear or 4th gear runs. If you're any good with Excel and all you want is HP/TQ, this will work for you.
Firstly thank you for all the work you have done to make such a great product (openecu) even better. Between yourself, JCBanks, Dave(Tephra), Jamie(JoT), Razorlab to name just a handful, you have given us an option to ecutek & other tuning software that is rather expensive & lacks the flexibility of ecuflash.
I have just started to use your excel power/torque graph & it's a fantastic tool. I downloaded the DLL trial software but couldn't get it to work for me, I also nearly purchased it & was going to bumble my way along until I could master it. Well that changed when I found this thread, thank you very much from the bottom of my heart.
I have a slight problem though, my 3rd gear pulls read higher than a 4th gear pull I recently did. Generally all my road logs are done in 3rd, however; I did this 4th gear run to compare to see if my tune produced identical outputs in both 3rd & 4th gear, like a dyno does. Any feedback will be appreciated, thank you.
Cheers Steve
#60
Evolved Member
iTrader: (21)
Very nice tool!!! Thanks a lot for this!! Can't someone have a lookup for the max calulated HP and TQ columns with their referenced RPM on the chart so It will plot the max TQ and HP? I personally am not the greatest at Excel but I wouldnt think that would be a very difficult feat. Thanks again guys!!
Last edited by SEEnoEVO; May 14, 2009 at 05:21 AM.