Welcome to the North American Subaru Impreza Owners Club Monday September 22, 2014
Home Forums WikiNASIOC Products Store Modifications Upgrade Garage
NASIOC
Here you can view your subscribed threads, work with private messages and edit your profile and preferences Home Registration is free! Visit the NASIOC Store NASIOC Rules Search Find other members Frequently Asked Questions Calendar Archive NASIOC Upgrade Garage Logout
Go Back   NASIOC > NASIOC Technical > Engine Management & Tuning

Welcome to NASIOC - The world's largest online community for Subaru enthusiasts!
Welcome to the NASIOC.com Subaru forum.

You are currently viewing our forum as a guest, which gives you limited access to view most discussions and access our other features. By joining our community, free of charge, you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is free, fast and simple, so please join our community today!

If you have any problems with the registration process or your account login, please contact us.
* Registered users of the site do not see these ads.
Reply
 
Thread Tools Display Modes
Old 02-21-2006, 06:25 PM   #1
J.Yo
Scooby Newbie
 
Member#: 26383
Join Date: Oct 2002
Default Road Dyno spreadsheet

I pulled together a spreadsheet that can estimate the wheel horsepower and torque, using datalogs from TARI DL1. I read the forum file attachment FAQ, and it seems Excel spreadsheets are not a file format that can be attached to a thread. Anyone have a suggestion on how I can share this spreadsheet with everyone?
* Registered users of the site do not see these ads.
J.Yo is offline   Reply With Quote
Old 02-21-2006, 07:22 PM   #2
STirocket
Scooby Specialist
 
Member#: 84006
Join Date: Mar 2005
Chapter/Region: NWIC
Location: Auburn, WA
Vehicle:
2005 Impreza WRX STi
WRB with Goldies

Default

I sent you a PM. Send me the file and I'll host it for you. Will it work with ECuexplorer data logs too?
STirocket is offline   Reply With Quote
Old 02-21-2006, 08:24 PM   #3
Don Arm
Scooby Specialist
 
Member#: 17520
Join Date: Apr 2002
Chapter/Region: MWSOC
Location: Indianapolis now Orlando
Vehicle:
2002 Impreza WRX
Midnight

Default

Please post it or would you mind emailing it to me? I'm definitely interested.
Don Arm is offline   Reply With Quote
Old 02-21-2006, 08:36 PM   #4
colby
Scooby Newbie
 
Member#: 15918
Join Date: Mar 2002
Chapter/Region: NWIC
Location: Seattle, WA
Vehicle:
08 STI/02 PGT WRX
DGM / Orange

Default

can you zip the file and attach that? otherwise, you are welcome to post it on the openecu.org website.

colby
colby is offline   Reply With Quote
Old 02-21-2006, 10:53 PM   #5
J.Yo
Scooby Newbie
 
Member#: 26383
Join Date: Oct 2002
Default

I emailed the file to STirocket. I hope he will be able to host it for everyone to try out. The description and instructions are on the first sheet of the workbook. This spreadsheet can be used for any datalogging program that can log a time stamp, vehicle speed, and engine rpm. I think you'll understand when you see it. I included some sample data from a run I did the other day. It was a 2nd gear pull from 2000 rpm up until about redline. I'm sure there will be a fair amount of discussion about what I'm calling the Road Dyno compared to other dyno plots. Perhaps we should call it the Poor Man's Dyno (PMD). It should be a fun tool for everyone.
J.Yo is offline   Reply With Quote
Old 02-21-2006, 11:02 PM   #6
STirocket
Scooby Specialist
 
Member#: 84006
Join Date: Mar 2005
Chapter/Region: NWIC
Location: Auburn, WA
Vehicle:
2005 Impreza WRX STi
WRB with Goldies

Default

Here's the file... Let's see if I can link to it on my web site.

Road Dyno

Give that a try. It worked for me, automatically downloaded it when I clicked on the link. Let me know if others have trouble and I can try something else.
STirocket is offline   Reply With Quote
Old 02-21-2006, 11:22 PM   #7
Bishop
NASIOC Supporter
 
Member#: 59993
Join Date: Apr 2004
Chapter/Region: International
Location: WWAAYY west of the Mississippi
Vehicle:
Ass, grass or cash
no one rides for free!!

Default

works for me.
Bishop is offline   Reply With Quote
Old 02-22-2006, 07:45 PM   #8
Jeramie
Scooby Newbie
 
Member#: 56995
Join Date: Mar 2004
Chapter/Region: MAIC
Location: PA
Vehicle:
2004 WRX
Blue

Default

Subscribe
Jeramie is offline   Reply With Quote
Old 02-22-2006, 07:53 PM   #9
rjrutzky
Scooby Specialist
 
Member#: 30367
Join Date: Nov 2002
Chapter/Region: South East
Location: nashville, tn
Vehicle:
2005 Legacy GT
NASA SE PTB Champ

Default

Were you in first gear or is the speed wrong? Try a 4th gear. On a closed course of course
rjrutzky is offline   Reply With Quote
Old 02-22-2006, 07:56 PM   #10
nhluhr
John Wayne Toilet Paper
Moderator
 
Member#: 7327
Join Date: Jun 2001
Chapter/Region: NWIC
Location: Seattle, WA
Vehicle:
2008 Mazdaspeed3
2006 Wrangler Sport

Default

Are the results better than DeltaDash's built-in road dyno?

The problem with Deltadash is the jaggies in the data that result from their crappy smoothing algorithm...

Example:
nhluhr is offline   Reply With Quote
Old 02-22-2006, 07:59 PM   #11
hondaeater69
Scooby Guru
 
Member#: 60324
Join Date: Apr 2004
Location: a pillow.
Default

so the formula basically extrapolates HP and TQ from time elapsed, vehicle speed and RPM?
hondaeater69 is offline   Reply With Quote
Old 02-22-2006, 07:59 PM   #12
nhluhr
John Wayne Toilet Paper
Moderator
 
Member#: 7327
Join Date: Jun 2001
Chapter/Region: NWIC
Location: Seattle, WA
Vehicle:
2008 Mazdaspeed3
2006 Wrangler Sport

Default

also, as a suggestion, why not have an input for the gear ratio, final drive, and tire diameter thus allowing you to calculate the vehicle speed instead of having to log it... this would give you faster logging and more datapoints for smoother plots.
nhluhr is offline   Reply With Quote
Old 02-22-2006, 08:41 PM   #13
Wazazell
Scooby Newbie
 
Member#: 84284
Join Date: Apr 2005
Chapter/Region: MAIC
Location: Richmond, Va.
Vehicle:
2006 Subaru WRX STi
WRB/Gold

Default

Quote:
Originally Posted by nhluhr
Are the results better than DeltaDash's built-in road dyno?

The problem with Deltadash is the jaggies in the data that result from their crappy smoothing algorithm...
since the data is in Excel you can add a trendline to the graph. I don't know if that's really what you're looking for, but it makes a nice smooth line. Here's a 6th order polynomial fitted to the HP curve. It would probably look a lot better if there were more data points.



I just tried out the ecuExplorer program! Man, it's awesome, it tells you everything! I'm really amazed by the info it can gather from the ecu. Can't wait till I get my car running again!
Wazazell is offline   Reply With Quote
Old 02-22-2006, 09:58 PM   #14
Legacy777
Scooby Guru
 
Member#: 4800
Join Date: Mar 2001
Chapter/Region: TXIC
Location: Houston, Tx
Vehicle:
1990 Legacy & 97 OBS
AWD 6MT EJ22T AWIC Swap

Default

Yeah.....this may get you in the ball park, but without gear ratios and final drive ratio, and even taking into account wind resistance, it's not going to be overly accurate.

This thing probably does the same thing, but accounts for the things I've mentioned.
http://www.charm.net/~mchaney/roaddyno/

I have one, however never got it to read engine rpm properly with the tachometer pickup.....and I haven't really found the initiative to tap into the ignition signal, but I'm sure if I did that, it'd work.
Legacy777 is offline   Reply With Quote
Old 02-22-2006, 11:02 PM   #15
STirocket
Scooby Specialist
 
Member#: 84006
Join Date: Mar 2005
Chapter/Region: NWIC
Location: Auburn, WA
Vehicle:
2005 Impreza WRX STi
WRB with Goldies

Default

I'm thinking the price of J.Yo's software and a Tactrix or AP cable is a better deal than $149.00... Even if you have to add some variables to improve the accuracy (variables not being too expensive on the open market).
STirocket is offline   Reply With Quote
Old 02-23-2006, 12:20 PM   #16
IndyRacer
Scooby Newbie
 
Member#: 15439
Join Date: Feb 2002
Chapter/Region: MWSOC
Location: Indianapolis, IN
Vehicle:
2002 WRX Cobb Stg 2
13.630@99.88 mph

Default

I am having trouble with the spreadsheet because I have multiple samples at the same vehicle speed. I am using EcuExplorer and speed is an integer - no decimal places. With my sample speed (not all that fast because I am sampling a lot of items) I get 2 or 3 samples at a given mph. That totally messes up the spreadsheet (no delta speed to calculate from).

Anyone else having the same problem?
IndyRacer is offline   Reply With Quote
Old 02-23-2006, 12:54 PM   #17
Quack
Scooby Specialist
 
Member#: 57264
Join Date: Mar 2004
Chapter/Region: MWSOC
Location: Aurora, OH
Vehicle:
2004 18g Wagon - WRB
PDX Tuned - 329whp/315wtq

Default

did you read the "READ ME" tab?
Quack is offline   Reply With Quote
Old 02-23-2006, 01:09 PM   #18
IndyRacer
Scooby Newbie
 
Member#: 15439
Join Date: Feb 2002
Chapter/Region: MWSOC
Location: Indianapolis, IN
Vehicle:
2002 WRX Cobb Stg 2
13.630@99.88 mph

Default

^ Now I did. With EcuExplorer, the vehicle speed samples aren't always 2 per second. I was getting 2 or 3 samples per mph. I tried deleting all but the first instance of each speed, but then I get very wavy results. Maybe I will try inserting decimal places into the speed values to improve the resolution.
IndyRacer is offline   Reply With Quote
Old 02-23-2006, 01:22 PM   #19
Jeramie
Scooby Newbie
 
Member#: 56995
Join Date: Mar 2004
Chapter/Region: MAIC
Location: PA
Vehicle:
2004 WRX
Blue

Default

Quote:
Originally Posted by IndyRacer
I am having trouble with the spreadsheet because I have multiple samples at the same vehicle speed. I am using EcuExplorer and speed is an integer - no decimal places. With my sample speed (not all that fast because I am sampling a lot of items) I get 2 or 3 samples at a given mph. That totally messes up the spreadsheet (no delta speed to calculate from).

Anyone else having the same problem?

Did you read the instructions. It says delete, the dups.



EDIT: Oppps suppose it too me to long to post, pesky "work" getting in the way.
Jeramie is offline   Reply With Quote
Old 02-23-2006, 02:06 PM   #20
IndyRacer
Scooby Newbie
 
Member#: 15439
Join Date: Feb 2002
Chapter/Region: MWSOC
Location: Indianapolis, IN
Vehicle:
2002 WRX Cobb Stg 2
13.630@99.88 mph

Default

Okay - I found a way to create smooth plots from the full data set. Try this:

1. Plot speed vs time for the full data set that you want to use for road dyno (include all duplicate speeds) using Excel's x-y chart option.
2. Fit a 3rd order polynomial trendline to the speed data.
3. Use the coefficients from the trendline to create new speed values as a funtion of time (time samples from your data set). This will produce vehicle speed values with much more resolution (and no duplicate values)
4. Use the new speed values along with all time and rpm data for the road dyno calculations.

I did this and was able to produce the following graph from a 3rd gear pull:



The graph I produced using the receommended method of deleting the duplicate speed values was very wavy. This new method eliminated the waves.

My next step is to try to automate the process of generating the new speed data within the spreadsheet. If I can get that done, I'll let you know.

Last edited by IndyRacer; 02-23-2006 at 02:25 PM.
IndyRacer is offline   Reply With Quote
Old 02-23-2006, 02:15 PM   #21
Jeramie
Scooby Newbie
 
Member#: 56995
Join Date: Mar 2004
Chapter/Region: MAIC
Location: PA
Vehicle:
2004 WRX
Blue

Default

Can you post what you have? If needed I can host.

jcavanaugh at computercablestore.com
Jeramie is offline   Reply With Quote
Old 02-23-2006, 02:23 PM   #22
J.Yo
Scooby Newbie
 
Member#: 26383
Join Date: Oct 2002
Default Poor Man's Road Dyno Rev 2

I just wanted to let everyone know that I revised the spreadsheet to include an "rpm only" based calculation. Thanks to nhluhr for the suggestion. I have asked STirocket to host the new file, and I will post an explanation soon after. I really like what Indyracer did, and I think we might be able to utilize that in a future revision.
J.Yo is offline   Reply With Quote
Old 02-23-2006, 02:29 PM   #23
Freon
Scooby Specialist
 
Member#: 88322
Join Date: Jun 2005
Chapter/Region: MWSOC
Location: Indianapolis, IN
Vehicle:
2009 BMW 135i

Default

There is always a limitation of the speed of the logging and accuracy/precision of the speed or RPM log. I long ago gave up on UTEC logs, but may try again with NBS's fast-speed enabled logger.

I created several windowing function to smooth data when I was playing with this for my SMT-6 logs on my last car. Same problem there, not fast enough for how inaccurate the RPM logs were. If RPM jumps around and doesnt seem to increase smoothly (if you see it go DOWN between two log points under WOT for instance), you'll either need to fix it, or log at incredibly speed.

If some people want to post a few good Tari logs with ONLY time, RPM, and speed, I'd like to experiment with two different models for calculating this. One is to solve for HP via delta of total kinetic energy, the other is to solve for torque by calculating the forward force. I know exactly how to accomplish both, with gear ratios and everything, I just need a few good logs to play with.
Freon is offline   Reply With Quote
Old 02-23-2006, 04:50 PM   #24
Freon
Scooby Specialist
 
Member#: 88322
Join Date: Jun 2005
Chapter/Region: MWSOC
Location: Indianapolis, IN
Vehicle:
2009 BMW 135i

Default

There is no reason an equal or better plot than Deltadash cannot be created by a log generated from Tari. They both have access to the same information, gathered at the same speed and from the same ECU. The data speed and quality are the limitations. The models are the easy part.

Last edited by Freon; 02-23-2006 at 04:50 PM. Reason: grammar owns me
Freon is offline   Reply With Quote
Old 02-23-2006, 05:25 PM   #25
NavyBlueSubaru
Scooby Specialist
 
Member#: 22127
Join Date: Jul 2002
Chapter/Region: South East
Location: Oviedo, FL
Vehicle:
2013 BMW 335i Sedan
Estoril Blue

Default

I have horsepower/torque calculations in mind when coding my fast-logging. I actually spent about 4 hours today going over the fast-logging code. The UTEC is not as constant as most people probably think it is.

Jeff
NavyBlueSubaru is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Hand fabbed 30R Road Dyno Spreadsheet TDagen Proven Power Bragging 15 07-12-2009 06:21 PM
Road Dyno Spreadsheet mpggomd Factory 2.0L Turbo Powertrain 14 02-23-2007 11:31 PM
Home Dyno/Road Dyno Thumper Factory 2.0L Turbo Powertrain 3 08-20-2002 09:23 PM
Road Dyno Opinions Stavros g Factory 2.0L Turbo Powertrain 0 05-24-2001 08:56 AM
Road Dyno? Anyone heard of this? Necromancer Bay Area Impreza Club Forum -- BAIC 4 02-15-2001 12:42 AM


All times are GMT -4. The time now is 11:49 PM.


Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Powered by Searchlight © 2014 Axivo Inc.
Copyright ©1999 - 2014, North American Subaru Impreza Owners Club, Inc.