Any chance at supporting wankle/rotary engines?

Simply go here - http://autos.groups.yahoo.com/group/exceldyno/files/
and click on calc_v2_2.zip file. It will ask if you want to save or
open the file. Just save it somewhere.

Wes

--- In exceldyno@yahoogroups.com, m m <heviman@...> wrote:
>
> hi
> i just joined your group however i clicked on the link shown to
download the dyno spread sheet but couldnt find a download button or
command .can you help please?
> tnx .
> moon
>

Great works fine thanks :-)

Regards
Ben


--- In exceldyno@yahoogroups.com, "Wes" <bajawes@...> wrote:
>
> Hi Ben,
>
> Yes, you've found a problem. It is calculating the rpm in gear
wrong
> for mph. I don't have many mph users so no-ones really noticed
> before.
>
> I'll fix it and post up a new version of the spreadsheet soon.
>
> If you want to fix it yourself, do the following;
> * Select columns R and U, right click and select unhide.
> * Change cell T33 from =IF($J$23="kph",J33,J33/mtokm)
>                     to =IF($J$23="kph",J33,J33*mtokm)
> * Select columns S and T, right click and select hide
>
> There you go, all fixed and ready to calculate in mph.
>
> Cheers,
> Wes
>
> --- In exceldyno@yahoogroups.com, "Ben Spray" <ben@> wrote:
> >
> > Hi All
> >
> > Just found this spreadsheet this week. really is great...
> > Im using it to try to work out a gearbox / reduction (transfer)
> ratio
> > on my land rover expedition truck which has been converted to a
> diesel
> > engine.
> >
> > One thing which Ive noticed may just be something Im doing but
the
> bit
> > on the input sheet that works out the RPM ina certain gear at a
> certain
> > speed seems to work fine in KPH but not in MPH? trying to find a
> good
> > ratio to cruise at 2500rpm in top gear (can see it on the gearing
> graph
> > anyway but would be good to figure out what Im doing on the input
> page)
> >
> > Cheers
> > Ben
> >
>

Hi Ben,

Yes, you've found a problem. It is calculating the rpm in gear wrong
for mph. I don't have many mph users so no-ones really noticed
before.

I'll fix it and post up a new version of the spreadsheet soon.

If you want to fix it yourself, do the following;
* Select columns R and U, right click and select unhide.
* Change cell T33 from =IF($J$23="kph",J33,J33/mtokm)
                     to =IF($J$23="kph",J33,J33*mtokm)
* Select columns S and T, right click and select hide

There you go, all fixed and ready to calculate in mph.

Cheers,
Wes

--- In exceldyno@yahoogroups.com, "Ben Spray" <ben@...> wrote:
>
> Hi All
>
> Just found this spreadsheet this week. really is great...
> Im using it to try to work out a gearbox / reduction (transfer)
ratio
> on my land rover expedition truck which has been converted to a
diesel
> engine.
>
> One thing which Ive noticed may just be something Im doing but the
bit
> on the input sheet that works out the RPM ina certain gear at a
certain
> speed seems to work fine in KPH but not in MPH? trying to find a
good
> ratio to cruise at 2500rpm in top gear (can see it on the gearing
graph
> anyway but would be good to figure out what Im doing on the input
page)
>
> Cheers
> Ben
>

Hi All

Just found this spreadsheet this week. really is great...
Im using it to try to work out a gearbox / reduction (transfer) ratio
on my land rover expedition truck which has been converted to a diesel
engine.

One thing which Ive noticed may just be something Im doing but the bit
on the input sheet that works out the RPM ina certain gear at a certain
speed seems to work fine in KPH but not in MPH? trying to find a good
ratio to cruise at 2500rpm in top gear (can see it on the gearing graph
anyway but would be good to figure out what Im doing on the input page)

Cheers
Ben

Hi All,

I've changed the membership setting for this group so I have to
approve new members. Hopefully this will stop the spamming problems
that the group seems to have developed lately.

Cheers,
Wes

Hi SHIRAKAWA (do you hane a nickname?),

Sounds interesting. Feel free to post a link to your program or add
it to the file section for others to use and enjoy.

Cheers,
Wes

--- In exceldyno@yahoogroups.com, "SHIRAKAWA Akira"
<shirakawa.akira@...> wrote:
>
> Hi Wes,
>
> I'm SHIRAKAWA Akira, you've probably never heard of me.
> I'm writing to this group because I've recently found out that in
> these years I wrote a spreadsheet file which almost does the same
> things as yours without having ever seen it before!
>
> However my approach has been different. Basically:
> - It's less user friendly because it wasn't initially intended for
> public use
> - Has been made for OpenOffice's Calc spreadsheet application
> - It doesn't (at least not yet) make use of macros
> - It only has a very basic simulation of car acceleration
> - Its main purpose is to make wheel power/torque charts from gps,
obd
> or videocamera data of rpm over time (filtered for clarity) and to
use
> them to plot a chart with optimal shift points, top speed
calculation,
> gradient calculation basing on user-imputed data, all in one
>
> My main source of inspiration has been the old CarTest 4.5 for DOS
but
> at glance it could seem a blatant case of plagiarism from your
> spreadsheet. I assure you it's not, even if I can't prove myself.
>
> http://www.shirakawaakira.net/foto/calcolmarc01.jpg
> http://www.shirakawaakira.net/foto/calcolmarc02.jpg
> http://www.shirakawaakira.net/foto/calcolmarc03.jpg
> http://www.shirakawaakira.net/foto/calcolmarc04.jpg
> http://www.shirakawaakira.net/foto/calcolmarc05.jpg
>
> Torque/power chart calculated from digital tachometer video:
>
> http://www.shirakawaakira.net/img/10proveconinterpolazione.png
> http://www.shirakawaakira.net/img/10provecurveaccregimiottimali.png
>
> Torque/power chart calculated from OBD data:
>
> http://www.shirakawaakira.net/img/bmw120d_nicco_03_good.png
> http://www.shirakawaakira.net/img/bmw120d_nicco_04.png
>
> The problem is that now that I have seen your spreadsheet file I
came
> up with new ideas to improve mine ^_^'
>

--- In exceldyno@yahoogroups.com, "SHIRAKAWA Akira"
<shirakawa.akira@...> wrote:

> Torque/power chart calculated from digital tachometer video:
>
> http://www.shirakawaakira.net/img/10proveconinterpolazione.png
> http://www.shirakawaakira.net/img/10provecurveaccregimiottimali.png
>
> Torque/power chart calculated from OBD data:
>
> http://www.shirakawaakira.net/img/bmw120d_nicco_03_good.png
> http://www.shirakawaakira.net/img/bmw120d_nicco_04.png

Actually the first was from OBD and the second from two videos.

--- In exceldyno@yahoogroups.com, "Wes" <bajawes@...> wrote:

> Since any values you'd put in would be a guess, then it isn't really
> making the calculation any more accurate anyway....

My spreadsheet file partially accounts for flywheel and wheel inertia.
Engine and flywheel inertia subtly affect car acceleration expecially
in the first gears.

I agree it wouldn't be accurate to use average or estimated values,
but in my opinion it's better than not account them at all. In your
spreadsheet there is already estimated data for other things.

Hi Wes,

I'm SHIRAKAWA Akira, you've probably never heard of me.
I'm writing to this group because I've recently found out that in
these years I wrote a spreadsheet file which almost does the same
things as yours without having ever seen it before!

However my approach has been different. Basically:
- It's less user friendly because it wasn't initially intended for
public use
- Has been made for OpenOffice's Calc spreadsheet application
- It doesn't (at least not yet) make use of macros
- It only has a very basic simulation of car acceleration
- Its main purpose is to make wheel power/torque charts from gps, obd
or videocamera data of rpm over time (filtered for clarity) and to use
them to plot a chart with optimal shift points, top speed calculation,
gradient calculation basing on user-imputed data, all in one

My main source of inspiration has been the old CarTest 4.5 for DOS but
at glance it could seem a blatant case of plagiarism from your
spreadsheet. I assure you it's not, even if I can't prove myself.

http://www.shirakawaakira.net/foto/calcolmarc01.jpg
http://www.shirakawaakira.net/foto/calcolmarc02.jpg
http://www.shirakawaakira.net/foto/calcolmarc03.jpg
http://www.shirakawaakira.net/foto/calcolmarc04.jpg
http://www.shirakawaakira.net/foto/calcolmarc05.jpg

Torque/power chart calculated from digital tachometer video:

http://www.shirakawaakira.net/img/10proveconinterpolazione.png
http://www.shirakawaakira.net/img/10provecurveaccregimiottimali.png

Torque/power chart calculated from OBD data:

http://www.shirakawaakira.net/img/bmw120d_nicco_03_good.png
http://www.shirakawaakira.net/img/bmw120d_nicco_04.png

The problem is that now that I have seen your spreadsheet file I came
up with new ideas to improve mine ^_^'

Are you a black single looking to meet a white singles for dating? Or a
single white woman with a preference for dating black men? If this is
you and you have always has a preference for dating mixed singles or
other singles outside your race then it is the only dating and
personals site that you should join! We have created an online
interracial dating network full of single men and women in search of
black white dating and black white relationships. Join our interracial
singles site today to kick start your love life!

http://www.aboutme.com/users/latinsingles/Datingsite.htm

Thanks, Everything does check out as you described, but still no sheet tabs.
I recently had to completely reload windows due to the Vundo virus. Not
everything is working properly yet.

-----Original Message-----
From: exceldyno@yahoogroups.com [mailto:exceldyno@yahoogroups.com]On
Behalf Of Wes
Sent: Sunday, November 12, 2006 10:26 PM
To: exceldyno@yahoogroups.com
Subject: [exceldyno] Re: New version of Excel Dyno coming soon


> When I download the dyno the tabs are missing at the bottom of the
page for
> input, engine, traction, etc.  Am I missing a step?

Have you had that problem before? I know someone did...

When you open Excel, go to Tools?Options.

Then go to the "view" tab. The bottom section of that tab is
called "window options". Basically everything in that lower section
should be "ticked" except for the "page breaks" and the "formulas".

Your problem sounds like the "sheet tabs" box is unchecked.

Wes





Yahoo! Groups Links






--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.409 / Virus Database: 268.14.3/530 - Release Date: 11/11/2006

> When I download the dyno the tabs are missing at the bottom of the
page for
> input, engine, traction, etc.  Am I missing a step?

Have you had that problem before? I know someone did...

When you open Excel, go to Tools?Options.

Then go to the "view" tab. The bottom section of that tab is
called "window options". Basically everything in that lower section
should be "ticked" except for the "page breaks" and the "formulas".

Your problem sounds like the "sheet tabs" box is unchecked.

Wes

When I download the dyno the tabs are missing at the bottom of the page for
input, engine, traction, etc.  Am I missing a step?

thanks
Ron

-----Original Message-----
From: exceldyno@yahoogroups.com [mailto:exceldyno@yahoogroups.com]On
Behalf Of Wes
Sent: Wednesday, November 08, 2006 2:57 PM
To: exceldyno@yahoogroups.com
Subject: [exceldyno] New version of Excel Dyno coming soon


Hi,

I just wanted to let everyone know that I will be releasing a new
version of the Excel Dyno in the next few days. Changes include;

* Addition of a "ghost car" feature, to lock the current settings as a
ghost car, and enable easy comparison to changes.

* More imperial unit support - basically every graph now has a
secondary axis with imperial units (even though metric is the best)

* Hopefully the ability to import g and other data from GPS or race
data loggers (working on this part now).

Wes





Yahoo! Groups Links






--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.409 / Virus Database: 268.14.0/524 - Release Date: 11/8/2006

Hi all,

I've been busy and haven't quite finished the next release (haven't
added the GPS feature yet), but have released it as is anyway (as V2.2
in the file section) so people can play with the new ghost feature and
enhanced imperial unit support.

If anyone is keen to do some quick testing and has any additional feed
back then that would be great.

Cheers,
Wes

Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the exceldyno
group.

   File        : /calc_v2_2.zip
   Uploaded by : baja_wes <bajawes@...>
   Description : Excel Dyno v2.2 - new Beta release

You can access this file at the URL:
http://groups.yahoo.com/group/exceldyno/files/calc_v2_2.zip

To learn more about file sharing for your group, please visit:
http://help.yahoo.com/help/us/groups/files

Regards,

baja_wes <bajawes@...>

Hi,

I just wanted to let everyone know that I will be releasing a new
version of the Excel Dyno in the next few days. Changes include;

* Addition of a "ghost car" feature, to lock the current settings as a
ghost car, and enable easy comparison to changes.

* More imperial unit support - basically every graph now has a
secondary axis with imperial units (even though metric is the best)

* Hopefully the ability to import g and other data from GPS or race
data loggers (working on this part now).

Wes

Hi,

There are a few problems with making it compatible with the older
versions. The first is file size. The file ends up 5 times bigger. The
main problem is that the old version of excel doesn't have all the
features needed to make the sheet work properly. So some thing won't
work, and some will result in a visualbasic error. The other problem
is I don't have 97 so can't test if it works at all.

If your still keen, I have save an older 97 version for you to try.

http://offroadvw.net/exceldyno/calc_97.zip

Let me know how you go.

I'm not that interested in market or anything, as it's free. I made it
because I was bored and the paid software sucked.

It is funny the people that are using it though. Design engineers in
large trucking companies, large car companies, uni students with their
thesis and heaps of others. They have all told me it's very accurate.

Cheers,
Wes

--- In exceldyno@yahoogroups.com, "fxdx2k" <fxdx2k@...> wrote:
> a few of us "oldies" out here who haven't graduated beyond Office 97
> and Windows 98 SE. I know of several motorcycle types who were
> interested in playing with it (me included), but without the right
> version of Excel it's of no use.

You might get more coverage, usage, and feedback if you had a version
that was compatible with earlier versions of Excel. There's still quite
a few of us "oldies" out here who haven't graduated beyond Office 97
and Windows 98 SE. I know of several motorcycle types who were
interested in playing with it (me included), but without the right
version of Excel it's of no use. Just a thought, I've found some other
tools to work with, but having one tool that does it all would be nice,
thus my attraction to your ExcelDyno.

Hi Ron,

I will start with the easy one first. As you can find out by
hovering the mouse of the red triangle in the spreadsheet, I
describe the stall speed as "The rpm held off the line until the
clutch/torque convertor fully engages". This is because you always
use the clutch to take off, and you will slip the clutch at first
and only let it fully engage at a certain speed. The rpm and kph
that the clutch finally fully engages is the stall speed. If you
normally get wheelspin here then you can put the speed the wheelspin
normally stops here.

If your curves on the traction curve never cross, then it means a
combination of things. Either your engine breathes fantastically
well and the torque never flattens off, or your gears are spaced too
widely apart. It means you will need to rev it out to redline to get
the best time. The best gear shift point calc should reflect this.

As for imperial units, welcome to the new millenium and metric
units :)

I have made some attempt for you US/UK guys. The input and engine
sheets have unit toggles, but the other sheets don't yet. Maybe next
version :)

Cheers,
Wes

--- In exceldyno@yahoogroups.com, "Ron Roberts" <4bluemoon2@...>
wrote:
>
> Hi Wes,
> I haven't played with the dyno in a long time as I was unable to
down load
> it for a while. But now I can again. The newer format seems to
work well. I
> had to figure out how to plug in my own data since that was one of
the
> changes, but once I figured it out it was easier to make small
changes and
> see the results. I have a few questions though in interpreting
data. On the
> traction chart, my gears never cross, but rather each higher gear
falls a
> meter or so per sec^2 lower than where the previous gear left off.
What does
> that tell you about the gearing? Gears spaced too far for the
power band?
>
> Also, can you explain about "stall" It is the first item on the
shift rpm
> chart on the input page.
>
> Just a suggestion: it would be nice for us that are metricly
challanged, if
> we could have a box to click to convert to SAE units. for some of
the
> charts. Yeah,, BOO HOO HOO!   LOL
>
> BTW, All that help you gave me with converting torque to
accellaration has
> been usefull, or at least interseting, in tuning my new 2270 T4. I
make
> changes and then clock accelaration every 1000 RPM and can chart
the torque.
>
> Take care,
>  Ron
>

Hi Wes,
I haven't played with the dyno in a long time as I was unable to down load
it for a while. But now I can again. The newer format seems to work well. I
had to figure out how to plug in my own data since that was one of the
changes, but once I figured it out it was easier to make small changes and
see the results. I have a few questions though in interpreting data. On the
traction chart, my gears never cross, but rather each higher gear falls a
meter or so per sec^2 lower than where the previous gear left off. What does
that tell you about the gearing? Gears spaced too far for the power band?

Also, can you explain about "stall" It is the first item on the shift rpm
chart on the input page.

Just a suggestion: it would be nice for us that are metricly challanged, if
we could have a box to click to convert to SAE units. for some of the
charts. Yeah,, BOO HOO HOO!   LOL

BTW, All that help you gave me with converting torque to accellaration has
been usefull, or at least interseting, in tuning my new 2270 T4. I make
changes and then clock accelaration every 1000 RPM and can chart the torque.

Take care,
  Ron

--- In exceldyno@yahoogroups.com, "runner1jzgte" <bobbybuch@...> wrote:
>
> Hi, very handy sheet!!
> Have you considered accounting for engine inertia for the traction
and
> accel calc?
>
> Bobby
>

H Bobby,

Yeah I have thought about it, but it makes the sheet too complicated.
Adding it to the sheet is easy enough, but knowing what values to put
in is the hard part. For example, tail shaft inertia, rear diff,
wheels and rear axles are all directly related to car speed. So you
could use one value for all those parts (but who has any idea what the
moment of inertia for all that on their car is).
Then the engine would have to be seperate because it is effected by
what gear your in at the time, and you need more than just a flywheel
weight. You need a moment of inertia for the entire engine. I don't
think you'd be able to find that sort of info anywhere.

Since any values you'd put in would be a guess, then it isn't really
making the calculation any more accurate anyway....

Cheers,
Wes

Hi, very handy sheet!!
Have you considered accounting for engine inertia for the traction and
accel calc?

Bobby

Wes

Thank you very much... the spreadsheet works now...

Robert



--- In exceldyno@yahoogroups.com, "Wes" <bajawes@h...> wrote:
>
> Hi,
>
> You need to enable macros.
>
> When you open Excel it should ask you whether you want to run
macros or
> not, and you should say "yes".
>
> If it doesn't ask you then the security is set too high. Go to
> Tools>macro>security in the menu. Set the macro security
to "Medium".
> It will now ask you if you want to run macros or not.
>
> Cheers,
> Wes
>
> --- In exceldyno@yahoogroups.com, "robertocarrillo439"
> <robertocarrillo439@y...> wrote:
> >
> > Hi
> >
> > I download the spreadsheet, but It acn not run, I push expand
button
> as
> > you recoment before calculate, but the program say macros are
disable.
> >
> > Regards
> >
> > Roberto
> >
>

Hi,

You need to enable macros.

When you open Excel it should ask you whether you want to run macros or
not, and you should say "yes".

If it doesn't ask you then the security is set too high. Go to
Tools>macro>security in the menu. Set the macro security to "Medium".
It will now ask you if you want to run macros or not.

Cheers,
Wes

--- In exceldyno@yahoogroups.com, "robertocarrillo439"
<robertocarrillo439@y...> wrote:
>
> Hi
>
> I download the spreadsheet, but It acn not run, I push expand button
as
> you recoment before calculate, but the program say macros are disable.
>
> Regards
>
> Roberto
>

Hi

I download the spreadsheet, but It acn not run, I push expand button as
you recoment before calculate, but the program say macros are disable.

Regards

Roberto

Hi

I download the spreadsheet, but It acn not run, I push expand button as
you recoment before calculate, but the program say macros are disable.

Regards

Roberto

Sorry I have been so slow to reply. I have been absolutely flat out
at work.

I don't where too much about load cells, other than some different
types and what they do. I don't know enough to recommend one. Try
reading about them on the web and maybe talking to a supplier. This
site has some good info;
http://www.omega.com/prodinfo/loadcells.html

If your torque arm restraining bolt is in tension then you probably
want a simple tension load cell like this one;
http://www.transducertechniques.com/TLL-Load-Cell.cfm

I have added a spreadsheet for you in the files section. You will
notice I typically calculate everything in SI units, as then you
don't have all the crazy multipliers needed to make imperial units
work. For example, if you know the force in N and the velocity in m/s
then you just multiply the together and get power in Watts.

Have a play with the excel sheet and tell me if it makes sense.

Wes

--- In exceldyno@yahoogroups.com, "Todd" <narider@t...> wrote:
> > A load cell is a good accurate way of getting the torque in the
> > roller reading (the hydraulic brake isn't driven through a
gearbox
> > by the roller I assume).
>
> The hydraulic brake is direct drive from the end of the drum's
shaft.
>
>
> > It's easy to set-up if the hydraulic brake is
> > already mounted using a torque arm.
>
> I'm not sure what is meant by a torque arm. There is a tab with a
> bolt going up to the floor of the dyno coming off the mounting
flange
> area of the pump that appearantly keeps it from being spun?
>
>
> > Then you multiply the load by the
> > torque arm radius and you have the roller torque.
>
> I'd have to look but I'm not sure that the mounting arm I speak of
is
> the only thing keeping the brake from spinning, but if it is then
> what you're saying is I could simply measure out from the center of
> the pump to the end of this arm to get the radius, and a load ceell
> opf some sort would mount at this point?
>
>
> > Now just use the torque at the roller and speed of the roller (in
> > RPM) together to calculate the power at the roller.
>
> Speed at the roller is no problem(I currently have that in MPH,
which
> could be converted to rpm easy enough). The torque I have also, but
> it is in PSI, and at any given rpm is different depending on GPM of
> the hydraulic brake.
> IE: TQ=(((PSIxGPM)/1714)x5252)/RPM
> The above(at the HP versus ground speed level) is the formula I
> believe my charts are figured from by the OEM.
>
> So to find GPM(as it's ever changing with psi and mph) is rather
> tough so my first thought was be to put a flow meter in rather then
> try to back figure(as I don't know horsepower in the first place
and
> it is putting too much data in the mix to input).
> IE: GPM=(1714/PSI)xHP (so adding this to the above formula jsut
keeps
> adding more and more room for error that I was hoping to bypass
with
> a load cell.
>
>
> > The roller power will be you vehicle power at the wheels. You can
> > then divide this back through by the engine rpm at any point and
> > get the engine torque.
>
> > These two powers and torques you have are as measured at the rear
> > wheels. Just divide back through by expected driveline efficiency
> > to estimate the power and torque at the flywheel.
> > Did that make any sense?
>
> Absolutley, these last 3 parts I understand very well and would be
> the easy part to have the program do once the data was input, and
if
> I understand correctly you agree that a load cell would be the way
to
> get that data?
>
>
> > Would you like me to give some equations as an example?
>
> That would be great Wes, but more importantly(as I'm not familiar
> with load cells), i'd be curious of what type of load cell I would
use
> (do you have a reccomendation?), and what type of data or reading
it
> puts out(can it be fed into my data-aq system in a 0-5v signal?).
>
> If I could get these figures into my data logger in a 0-5v signal,
I
> can program it to put it out(visually on screen) in any way I want
> via a chart trace or a gauge reading. And my system allows data to
be
> exported to Excel also.. would this be something a program such as
> yours would be able to have inpout to give printouts like a normal
HP
> or TQ versus a MPH or RPM chart as well as an A/F chart via RPM?
>
> Thanks Wes(hope I'm not burning you out or asking stupid questions
on
> this),
> Todd

> A load cell is a good accurate way of getting the torque in the
> roller reading (the hydraulic brake isn't driven through a gearbox
> by the roller I assume).

The hydraulic brake is direct drive from the end of the drum's shaft.


> It's easy to set-up if the hydraulic brake is
> already mounted using a torque arm.

I'm not sure what is meant by a torque arm. There is a tab with a
bolt going up to the floor of the dyno coming off the mounting flange
area of the pump that appearantly keeps it from being spun?


> Then you multiply the load by the
> torque arm radius and you have the roller torque.

I'd have to look but I'm not sure that the mounting arm I speak of is
the only thing keeping the brake from spinning, but if it is then
what you're saying is I could simply measure out from the center of
the pump to the end of this arm to get the radius, and a load ceell
opf some sort would mount at this point?


> Now just use the torque at the roller and speed of the roller (in
> RPM) together to calculate the power at the roller.

Speed at the roller is no problem(I currently have that in MPH, which
could be converted to rpm easy enough). The torque I have also, but
it is in PSI, and at any given rpm is different depending on GPM of
the hydraulic brake.
IE: TQ=(((PSIxGPM)/1714)x5252)/RPM
The above(at the HP versus ground speed level) is the formula I
believe my charts are figured from by the OEM.

So to find GPM(as it's ever changing with psi and mph) is rather
tough so my first thought was be to put a flow meter in rather then
try to back figure(as I don't know horsepower in the first place and
it is putting too much data in the mix to input).
IE: GPM=(1714/PSI)xHP (so adding this to the above formula jsut keeps
adding more and more room for error that I was hoping to bypass with
a load cell.


> The roller power will be you vehicle power at the wheels. You can
> then divide this back through by the engine rpm at any point and
> get the engine torque.

> These two powers and torques you have are as measured at the rear
> wheels. Just divide back through by expected driveline efficiency
> to estimate the power and torque at the flywheel.
> Did that make any sense?

Absolutley, these last 3 parts I understand very well and would be
the easy part to have the program do once the data was input, and if
I understand correctly you agree that a load cell would be the way to
get that data?


> Would you like me to give some equations as an example?

That would be great Wes, but more importantly(as I'm not familiar
with load cells), i'd be curious of what type of load cell I would use
(do you have a reccomendation?), and what type of data or reading it
puts out(can it be fed into my data-aq system in a 0-5v signal?).

If I could get these figures into my data logger in a 0-5v signal, I
can program it to put it out(visually on screen) in any way I want
via a chart trace or a gauge reading. And my system allows data to be
exported to Excel also.. would this be something a program such as
yours would be able to have inpout to give printouts like a normal HP
or TQ versus a MPH or RPM chart as well as an A/F chart via RPM?

Thanks Wes(hope I'm not burning you out or asking stupid questions on
this),
Todd