Notices
Vishnu Performance - California [Visit Site]

Any MS Excel wizards out there?

 
Thread Tools
 
Search this Thread
 
Old Apr 27, 2005 | 02:18 PM
  #1  
shiv@vishnu's Avatar
Thread Starter
Evolved Member
iTrader: (20)
 
Joined: Mar 2003
Posts: 4,941
Likes: 0
From: Danville/Blackhawk, California
Question Any MS Excel wizards out there?

Dustin has been working on road dyno software (designed in excel). It works but it could use some cleaning up. Any takers?

Shiv
Old Apr 27, 2005 | 02:20 PM
  #2  
jj_008's Avatar
Evolved Member
iTrader: (8)
 
Joined: Nov 2003
Posts: 2,064
Likes: 0
From: Salem, OR
I wouldn't say I am an "Expert" but I do use it a lot. Send it to JJ_008@hotmail.com
Old Apr 27, 2005 | 02:26 PM
  #3  
EV0lut10n_8's Avatar
Evolved Member
iTrader: (1)
 
Joined: Jul 2003
Posts: 666
Likes: 0
From: Chicago Burbs, USA
I have done alot in excel plus my wife is certified in excel. i will pm you my email address
Old Apr 27, 2005 | 02:30 PM
  #4  
erioshi's Avatar
Evolved Member
 
Joined: Mar 2003
Posts: 1,114
Likes: 0
I've also done some work with Xecel and and VBA (Visual Basic for Applications - Basically MS Office VB). I'd also be interested in taking a look. You can send it to m1_mtkg@yahoo.com
Old Apr 27, 2005 | 02:46 PM
  #5  
shiv@vishnu's Avatar
Thread Starter
Evolved Member
iTrader: (20)
 
Joined: Mar 2003
Posts: 4,941
Likes: 0
From: Danville/Blackhawk, California
Awesome guys. Thanks for being so willing to help. Attached is the spread sheet we've been working on so far. Give it a look and see if you can make heads or tails of what we are doing. Our deranged thought processes may be hard for healthy people to follow



shiv
Attached Files
Old Apr 27, 2005 | 03:00 PM
  #6  
Ludikraut's Avatar
Evolved Member
iTrader: (17)
 
Joined: Apr 2004
Posts: 6,224
Likes: 0
From: 41° 59' N, 87° 54' W
Interesting, some questions:

1. I assume all of the datapoints were generated by the XEDE ... what format were they originally in? plain text file?

2. Assuming 1. is correct, all you're looking for then is to convert and chart the initial values, right?

l8r)
Old Apr 27, 2005 | 03:00 PM
  #7  
MalibuJack's Avatar
EvoM Guru
20 Year Member
iTrader: (5)
 
Joined: Feb 2003
Posts: 10,572
Likes: 14
From: Royse City, TX
out of curiosity, I see how your calculating horsepower, but where is the torque value being determined?
Old Apr 27, 2005 | 03:02 PM
  #8  
Dustin@Vishnu's Avatar
Former Sponsor
iTrader: (1)
 
Joined: Jun 2004
Posts: 1,114
Likes: 0
From: Livermore, Ca
Yes, plain text file.

We have the initial values all plotted correctly, along with some formulas for Torque and HP.
Old Apr 27, 2005 | 03:02 PM
  #9  
shiv@vishnu's Avatar
Thread Starter
Evolved Member
iTrader: (20)
 
Joined: Mar 2003
Posts: 4,941
Likes: 0
From: Danville/Blackhawk, California
Originally Posted by MalibuJack
out of curiosity, I see how your calculating horsepower, but where is the torque value being determined?
Free Red Bull to the first person to figures that out

Shiv
Old Apr 27, 2005 | 03:03 PM
  #10  
Dustin@Vishnu's Avatar
Former Sponsor
iTrader: (1)
 
Joined: Jun 2004
Posts: 1,114
Likes: 0
From: Livermore, Ca
I almost posted how to do it....but shiv said free redbull, so i decided against it.



Originally Posted by MalibuJack
out of curiosity, I see how your calculating horsepower, but where is the torque value being determined?
Old Apr 27, 2005 | 03:09 PM
  #11  
jj_008's Avatar
Evolved Member
iTrader: (8)
 
Joined: Nov 2003
Posts: 2,064
Likes: 0
From: Salem, OR
who ever decided to use black cells should be shot.
Old Apr 27, 2005 | 03:12 PM
  #12  
jj_008's Avatar
Evolved Member
iTrader: (8)
 
Joined: Nov 2003
Posts: 2,064
Likes: 0
From: Salem, OR
Originally Posted by shiv@vishnu
Free Red Bull to the first person to figures that out

Shiv
Using RPM and time you should be able to determine the torque value.
Old Apr 27, 2005 | 03:13 PM
  #13  
Dustin@Vishnu's Avatar
Former Sponsor
iTrader: (1)
 
Joined: Jun 2004
Posts: 1,114
Likes: 0
From: Livermore, Ca
Originally Posted by jj_008
Using RPM and time you should be able to determine the torque value.
Free Red Bull goes to Jeremy.

Yay!!
Old Apr 27, 2005 | 03:13 PM
  #14  
Drews_WRX's Avatar
Evolving Member
 
Joined: Aug 2004
Posts: 430
Likes: 0
From: rancho cucamonga
Is it cause you only need one value to plot hp & trq due to the conversion factor? :

- HP = torque * RPM / 5252
- torque = HP * 5252 / RPM
Old Apr 27, 2005 | 03:13 PM
  #15  
jj_008's Avatar
Evolved Member
iTrader: (8)
 
Joined: Nov 2003
Posts: 2,064
Likes: 0
From: Salem, OR
F=ma or as Newton would have written it F=m*dV/Dt



All times are GMT -7. The time now is 12:57 AM.