Jump to content
SAU Community

Recommended Posts

Hey all,

Do you want to be able to estimate (for any car):

1) 60ft time

2) 200ft time

3) 1/4 mile time

4) 1/4 mile speed

5) Wheel spin / traction graphs

6) Most efficient shift points for best ET or best terminal speed.

7) Accleleration graphs

8) Distasnce v time

9) Gradient charts

10) and see what effect varying hundreds of vehicle parameters has on all the above.

and more...

Then take a look at the Excel dyno (excell file) that can be downloaded in the following location.

http://autos.groups.yahoo.com/group/exceldyno/

It is a really cool excell file based on visual basic macros that allows you to enter data about a car and accuratly estimate heaps of performance parameters. Inputs include, engine dyno data, car parameters (CD, weight..etc), tyre setup and more. It allows you to set shift points or have it calculate the most efficient points.

All credit for its creation goes to Wez, a mate form work. He is a mechanical engineer and has had a fair bit of experence playing around with cars - he also seems to have a lot of spare time :P He has set up a Yahoo group for all things Excel dyno, if your interested take a look.

It has been tested with a number of different cars and it has proven to return supprisingly accurate results.

Of most intrest to people on this forum would be the R32 GTR data that is already entered in the program - this data was based on another workmates car and gives very accurate results when tested at the drags. Just enter your dyno chart and car details and you can start dropping those 1/4 times.

You can always add any car that is not already in the program as long as you know all the parameters.

Here is a list of car/bike data that is already entered in the database:

93 MR2 Turbo

95 200SX SE-R

Ford Falcon AUIII

Ford Telstar 92,95

MX6 - Gen II V6

Subaru WRX

VW Baja

VW drag manx

R32 GTR

Suzuki DL650

Suzuki Hayabusa

It is all free but if you want to give Wez cash I'm sure he will not refuse:) just email him on the address at the website above.

Ray Hall also has a similar thing.....

http://www.turbofast.com.au/Drag.html

:)

Except that is more a rule of thumb than any sort of remotely accurate calculation.

If people want to find car specs and send them to me then I will post a new version of the sheet with the new cars up on the net.

The cars that are in there are just a few that I had some good data for so entered to check the accuracy of everything. Finding the aero data is the hardest.

Hey Wez, did not take you long to find the thread!

Ray Hall also has a similar thing.....

http://www.turbofast.com.au/Drag.html

Like Wez said, his program is in another ballpark.

I thought I'd post up the calculated best shift points for a R32 GTR, that should get things going:

For best km/h: (this gives 11.155 @ 202.7km/h)

RPM GEAR km/h

4000 stall speed 36

8500 first 77

8200 second 124.2

8010 third 179

8020 fourth 234

8500 fifth 330

For best ET: (this gives 11.144 @ 201.8 km/h)

RPM GEAR km/h

4000 stall speed 36

8500 (redline) first 77

8500 (redline) second 128.8

8500 (redline) third 190

8500 (redline) fourth 248

8500 (redline) fifth 330

Here is a bit of an explination of why the shift points are different when chasing high trap speeds or Low ET's (from the Excell dyno)

These shift points will give you the max terminal speed for the 1/4 mile. These points are essentially where the torque curves cross each other on the Traction chart. Note these points are not always exactly right as the wind slows the vehicle during gear shift making the best shift point estimation more difficult.

However, to achieve the best ET you generally need to change gears a little later. This is because shifting later means you are going faster for the during of the shift time. This means more distance will be covered. The optimum shift point is when the advantage of shifting later if offset by the loss of being too far past where the torque curves cross. These points are easily found by trial and error. Start with the best shift points for terminal speed and increase the shift rpm from there. For most engines the best ET will be achieved by revving to redline.

Well when the car had the 291HP dyno chart it ran the quarter and ran an 11.9. The Excel Dyno predicts that run perfectly.

With the extra 85 wheel hp it should easily push the car into the low 11's. I can't remember if he got a time slip before that engine spat the ceramic turbines through the engine.

I had a quick look - R32 GTR with 375RWHP running 11.1@125mph? i doubt it...

Does that mean you entered your car data? Is that what the excell sheet returned?

Well when the car had the 291HP dyno chart it ran the quarter and ran an 11.9. The Excel Dyno predicts that run perfectly.  

With the extra 85 wheel hp it should easily push the car into the low 11's. I can't remember if he got a time slip before that engine spat the ceramic turbines through the engine.

220rwkw (291rwhp) ran an 11.9? what mph? that must be a low dyno reading, what boost was he running?

Ferni,

That was my car. I'm pretty sure I have told you about it before.

When my car arrived from Japan it made 217 rwkw. That was on a dyno dynamics dyno (non shootout mode). I ran an 11.99 @ 115.4 mph at our drag strip here in Townsville.

I have been involved in the development of excel dyno and I can say that it is very accurate, as long as you give it accurate data. It's in a league of its own compared to most other programs out there.

I will write more later when I have more time...

Hey Gary,

Didn't know you had a 32 GTR last time I was up on site, prolly a good thing, I would have spent more time talking about cars than getting the full "QNI experence". I have to take a look next time I'm sent up there.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


  • Similar Content

  • Latest Posts

    • Well, that's kinda the point. The calipers might interfere with the inside of the barrels 16" rims are only about 14" inside the barrels, which is ~350mm, and 334mm rotors only leave about 8mm outboard for the caliper before you get to 350, And.... that;s not gunna be enough. If the rims have a larger ID than that, you might sneak it in. I'd be putting a measuring stick inside the wheel and eyeballing the extra required for the caliper outboard of the rotor before committing to bolting it all on.
    • OK, so again it has been a bit of a break but it was around researching what had been done since I didn't have access to Neil's records and not everything is obvious without pulling stuff apart. Happily the guy who assembled the engine had kept reasonable records, so we now know the final spec is: Bottom end: Standard block and crank Ross 86.5mm forgies, 9:1 compression Spool forged rods Standard main bolts Oil pump Spool billet gears in standard housing Aeroflow extended and baffled sump Head Freshly rebuilt standard head with new 80lb valve springs Mild porting/port match Head oil feed restrictor VCT disabled Tighe 805C reground cams (255 duration, 8.93 lift)  Adjustable cam gears on inlet/exhaust Standard head bolts, gasket not confirmed but assumed MLS External 555cc Nismo injectors Z32 AFM Bosch 023 Intank fuel pump Garret 2871 (factory housings and manifold) Hypertune FFP plenum with standard throttle   Time to book in a trip to Unigroup
    • I forgot about my shiny new plates!
    • Well, apparently they do fit, however this wont be a problem if not because the car will be stationary while i do the suspension work. I was just going to use the 16's to roll the old girl around if I needed to. I just need to get the E90 back on the road first. Yes! I'm a believer! 🙌 So, I contacted them because the site kinda sucks and I was really confused about what I'd need. They put together a package for me and because I was spraying all the seat surfaces and not doing spot fixes I decided not to send them a headrest to colour match, I just used their colour on file (and it was spot on).  I got some heavy duty cleaner, 1L of colour, a small bottle of dye hardener and a small bottle of the dye top coat. I also got a spray gun as I needed a larger nozzle than the gun I had and it was only $40 extra. From memory the total was ~$450 ish. Its not cheap but the result is awesome. They did add repair bits and pieces to the quote originally and the cost came down significantly when I said I didn't need any repair products. I did it over a weekend. The only issues I had were my own; I forgot to mix the hardener into the dye two coats but I had enough dye for 2 more coats with the hardener. I also just used up all the dye because why not and i rushed the last coat which gave me some runs. Thankfully the runs are under the headrests. The gun pattern wasn't great, very round and would have been better if it was a line. It made it a little tricky to get consistent coverage and I think having done the extra coats probably helped conceal any coverage issues. I contacted them again a few months later so I could get our X5 done (who the f**k thought white leather was a good idea for a family car?!) and they said they had some training to do in Sydney and I could get a reduced rate on the leather fix in the X5 if I let them demo their product on our car. So I agreed. When I took Bec in the E39 to pick it up, I showed them the job I'd done in my car and they were all (students included) really impressed. Note that they said the runs I created could be fixed easily at the time with a brush or an air compressor gun. So, now with the two cars done I can absolutely recommend Colourlock.  I'll take pics of both interiors and create a new thread.
    • Power is fed to the ECU when the ignition switch is switched to IGN, at terminal 58. That same wire also connects to the ECCS relay to provide both the coil power and the contact side. When the ECU sees power at 58 it switches 16 to earth, which pulls the ECCS relay on, which feeds main power into the ECU and also to a bunch of other things. None of this is directly involved in the fuel pump - it just has to happen first. The ECU will pull terminal 18 to earth when it wants the fuel pump to run. This allows the fuel pump relay to pull in, which switches power on into the rest of the fuel pump control equipment. The fuel pump control regulator is controlled from terminal 104 on the ECU and is switched high or low depending on whether the ECU thinks the pump needs to run high or low. (I don't know which way around that is, and it really doesn't matter right now). The fuel pump control reg is really just a resistor that controls how the power through the pump goes to earth. Either straight to earth, or via the resistor. This part doesn't matter much to us today. The power to the fuel pump relay comes from one of the switched wires from the IGN switch and fusebox that is not shown off to the left of this page. That power runs the fuel pump relay coil and a number of other engine peripherals. Those peripherals don't really matter. All that matters is that there should be power available at the relay when the key is in the right position. At least - I think it's switched. If it's not switched, then power will be there all the time. Either way, if you don't have power there when you need it (ie, key on) then it won't work. The input-output switching side of the relay gains its power from a line similar (but not the same as) the one that feeds the ECU. SO I presume that is switched. Again, if there is not power there when you need it, then you have to look upstream. And... the upshot of all that? There is no "ground" at the fuel pump relay. Where you say: and say that pin 1 Black/Pink is ground, that is not true. The ECU trigger is AF73, is black/pink, and is the "ground". When the ECU says it is. The Blue/White wire is the "constant" 12V to power the relay's coil. And when I say "constant", I mean it may well only be on when the key is on. As I said above. So, when the ECU says not to be running the pump (which is any time after about 3s of switching on, with no crank signal or engine speed yet), then you should see 12V at both 1 and 2. Because the 12V will be all the way up to the ECU terminal 18, waiting to be switched to ground. When the ECU switches the fuel pump on, then AF73 should go to ~0V, having been switched to ground and the voltage drop now occurring over the relay coil. 3 & 5 are easy. 5 is the other "constant" 12V, that may or may not be constant but will very much want to be there when the key is on. Same as above. 3 goes to the pump. There should never be 12V visible at 3 unless the relay is pulled in. As to where the immobiliser might have been spliced into all this.... It will either have to be on wire AF70 or AF71, whichever is most accessible near the alarm. Given that all those wires run from the engine bay fusebox or the ECU, via the driver's area to the rear of the car, it could really be either. AF70 will be the same colour from the appropriate fuse all the way to the pump. If it has been cut and is dangling, you should be able to see that  in that area somewhere. Same with AF71.   You really should be able to force the pump to run. Just jump 12V onto AF72 and it should go. That will prove that the pump itself is willing to go along with you when you sort out the upstream. You really should be able to force the fuel pump relay on. Just short AF73 to earth when the key is on. If the pump runs, then the relay is fine, and all the power up to both inputs on the relay is fine. If it doesn't run (and given that you checked the relay itself actually works) then one or both of AF70 and AF71 are not bringing power to the game.
×
×
  • Create New...