Board Logo
Go To Bottom

Printable Version  
[ Total Views: 8598 | Total Replies: 12 | Thread Id: 18037 ]
Author: Subject: Cool acceleration / gear charts / shift points program!
MemberBaja Wes
Bishop of Volkswagenism
V6 Baja Pioneer
******


Avatar


Posts: 3119
Threads: 94
Registered: August 26th, 2002
Member Is Offline

Location: Brisbane
Theme: UltimaBB Pro Blue ( Default )
Mood: Content

rsvd_idea.gif posted on January 21st, 2004 at 11:37 AM
Cool acceleration / gear charts / shift points program!


Hi everyone,

Unfortunately this program requries Microsoft excel 2000 or better to run, as it is a fancy excel spreadsheet.

I made it because I wanted to see the effects on acceleration of differnt engines, also the effect of different gearing and tyre sizes. So I made this spreadsheet from hell. You can caculate just about anything from tyre sizes - gear ratio charts - best shift points - 1/4 mile times - top speed - plus heaps more.

Check it out, it's hours of fun if your into this sort of thing. It can be downloaded from here.

http://offroadvw.net/exceldyno/

Then if you like it join the new yahoo group I made. The yahoo group will mainly allow me to email the people in the group and tell them when I have released a new version. If enough people join we could share engine / car / gearbox databases.

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

So has anyone tried it, did they like it?




Wes - www.offroadvw.net - 200HP Quad Cam V6 in a VW Baja - with climate control... :)
www.taylorcycles.com.au - My DH MTB racing brothers shop.
Membermodulus
A.k.a.: Peter Hill
Veteran Volks Folk
*****


Avatar


Posts: 2009
Threads: 76
Registered: July 1st, 2003
Member Is Offline

Location: Melbourne
Theme: UltimaBB Pro White
Mood: modular

posted on January 21st, 2004 at 03:39 PM


Hi Wes,
I've played with it for over a year, and it rocks.

I've just downloaded the 1.0 version and created the Twin-Cab model for it; seems quite reasonable, even for low-performance applications; 1/4 mile in about 23 secs, 0-100 kph in about 25, top at around 130 kph using a CD of 0.45 (guessed...).

Is there a way to edit e.g. the HP at 5000 rpm that I've set up for the engine without creating a new engine model?

Lots of fun and I'm sure very handy for those with less aneamic cars to model!




Peter Hill
1975 Type 2 Double Cab
modulus.com.au
MemberBaja Wes
Bishop of Volkswagenism
V6 Baja Pioneer
******


Avatar


Posts: 3119
Threads: 94
Registered: August 26th, 2002
Member Is Offline

Location: Brisbane
Theme: UltimaBB Pro Blue ( Default )
Mood: Content

posted on January 21st, 2004 at 04:52 PM


the best way is to go to the engine worksheet, and play with the power figures there. once the curve looks right then I suggest adding it to the database for good.

but at the moment you can only delete and add from the database, and not modify. I will look into making that feature.

I've also had suggestions that I be able to save what is on the engine tab, instead of having to retype it on the add engine form. I am currently looking into this feature.

Thanks for the response :thumb




Wes - www.offroadvw.net - 200HP Quad Cam V6 in a VW Baja - with climate control... :)
www.taylorcycles.com.au - My DH MTB racing brothers shop.
Membergldgti
Learner Dubber
*


No Avatar


Posts: 14
Threads: 6
Registered: November 29th, 2004
Member Is Offline

Location: NSW
Theme: UltimaBB Pro Blue ( Default )
Mood: always happy

posted on December 1st, 2004 at 07:53 AM


you guys might like http://www.cartestsoftware.com/cartest4.5/  .

i got this years and years ago, and i highly recommend it. you put in car specific data, then run tests such as gear charts, fuel economy (surprisingly accurate) drag racing, optimum shift points, hp/torque curves, and lots of other things.

i can only vouch for the dos program, havnt tried their "windows version".

note - by dos program i mean that it will still run in windows, just in a dos box. also works on XP.




the only thing better than a new VW is an old VW! ;-) :-D
MemberVolkswagenboy
A.k.a.: Brenton Barry
Veteran Volks Folk
Staggers Automotive.
*****


Avatar


Posts: 2437
Threads: 92
Registered: July 28th, 2005
Member Is Offline

Location: Boronia Heights, Brisbane.
Theme: UltimaBB Pro Blue ( Default )
Mood: Indifferent

posted on March 9th, 2006 at 10:50 PM



So can I add my own vehicles stats?
-Staggers.




STAGGERS AUTOMOTIVE - Heavy Vehicle Diesel Specialist


JB CUSTOMS & CLASSICS - Car Builders


2/53 Tradelink Drive, Browns Plains

MemberNigel
Learner Dubber
*


No Avatar


Posts: 15
Threads: 7
Registered: February 19th, 2006
Member Is Offline

Theme: UltimaBB Pro Blue ( Default )

posted on March 24th, 2006 at 12:46 AM



As far as I am aware, the drag coefficient, for a 1968~79 VW Kombi, is about 0·75 to 0·80.

The CD for the split screen Kombi was quoted as 0·75, in one automotive technology book, that I read a few years ago.
MemberBaja Wes
Bishop of Volkswagenism
V6 Baja Pioneer
******


Avatar


Posts: 3119
Threads: 94
Registered: August 26th, 2002
Member Is Offline

Location: Brisbane
Theme: UltimaBB Pro Blue ( Default )
Mood: Content

posted on May 7th, 2006 at 07:47 PM



Quote:
Originally posted by Nigel
As far as I am aware, the drag coefficient, for a 1968~79 VW Kombi, is about 0·75 to 0·80.

The CD for the split screen Kombi was quoted as 0·75, in one automotive technology book, that I read a few years ago.


Those figures sound very high. Are you sure they were giving Cd and not CdxA or something else?

It is always hard to find these figures...




Wes - www.offroadvw.net - 200HP Quad Cam V6 in a VW Baja - with climate control... :)
www.taylorcycles.com.au - My DH MTB racing brothers shop.
MemberNigel
Learner Dubber
*


No Avatar


Posts: 15
Threads: 7
Registered: February 19th, 2006
Member Is Offline

Theme: UltimaBB Pro Blue ( Default )

posted on May 7th, 2006 at 11:26 PM



Yes Wes.

I am reasonably certain that 0·75~0·80 is a representative drag coefficient for the VW Kombi, bearing in mind that 1·0 is the value for a "bluff body", which one might interpret as a square-edged brick, with no edge curvature. Don't forget, that even aerodynamically efficient, modern saloon cars, have drag coefficients of about 0·29~0·33

If you multiplied the drag coefficient, by the frontal area in metres squared, you would obtain an answer of more than three to four times as large, for the VW Kombi.

Regards.

Nigel A. Skeet, M.Sc. (Applied Energy Engineering), B.Sc. (Applied Physics), B.A. (Applied Mathematics & Statistics), Pg.Dip. (Scientific Applications Software), P.G.C.E. (Physical Sciences & Mathematics Education)
MemberBaja Wes
Bishop of Volkswagenism
V6 Baja Pioneer
******


Avatar


Posts: 3119
Threads: 94
Registered: August 26th, 2002
Member Is Offline

Location: Brisbane
Theme: UltimaBB Pro Blue ( Default )
Mood: Content

posted on May 8th, 2006 at 10:08 PM



But a bluff body isn't long. By making something longer you can actually reduce the drag.

I know that in an old Road & Track review of the 1980 VW Vanagon Transporter they quoted "Starting at the front, the shape is more aerodynamically efficient despite its angular appearance, and VW claims a drag coefficient of 0.44 "

I have also heard many times that the kombi has a lower Cd than a beetle. This site agrees with that and states 0.42 for the VW Microbus.
http://www.velocissima.com/tech/drag.htm 

The problem with most stuff posted on the net is that it's from text books from the 50's, so the generic "car", "truck" etc values are really bad :o

And to return the courtesy, or if your interested ??? my qualifications are...
BE(Mech)Hons MIEAust CPEng :thumb

Pretty boring to most people :P




Wes - www.offroadvw.net - 200HP Quad Cam V6 in a VW Baja - with climate control... :)
www.taylorcycles.com.au - My DH MTB racing brothers shop.
MemberJudsons4eva
Officially Full-On Dubber
***


Avatar


Posts: 270
Threads: 24
Registered: October 30th, 2004
Member Is Offline

Location: Perth
Theme: UltimaBB Pro Blue ( Default )

posted on April 15th, 2007 at 12:51 AM



Jeez Nigel - i think you've been trumped! But don't worry I've seen many Phd's that have been wrong



550 Porsche Spyder
56 Oval mit Judson
96 Porsche 993 C2
MemberGolde60
Fahrvergnugen
****


Avatar


Posts: 858
Threads: 73
Registered: August 25th, 2002
Member Is Offline

Location: Back in Dubai
Theme: UltimaBB Pro Blue ( Default )
Mood: Searching for the next project

posted on April 13th, 2008 at 01:28 AM



hey wes

just wanted to say thanks for such and awesome program, I have been spending way too much time on it and am learning a fair bit about gear boxes, ratios and combinations at the same time.

Great program, I hope you dont mind, I have sent it to a few guys who are interested for them to have a play too.




...................( O \ l / O ).....................
Memberadlbeetle66
A.k.a.: Denver
Custom Title Time!
Under the car.........again!
*****


Avatar


Posts: 1476
Threads: 98
Registered: August 15th, 2014
Member Is Offline

Location: Capalaba, Brisbane, QLD
Theme: UltimaBB Streamlined2
Mood: ICH BIN VW NUSS

posted on April 15th, 2015 at 09:28 AM



BLAST FROM THE PAST!

This is mad Wes!

One thing i'll say, i used to consider myself as knowing how to use a computer fairly well, until i saw this!

How'd ya do it?
Memberreub
Veteran Volks Folk
VWRX is gone...
*****


No Avatar


Posts: 2053
Threads: 160
Registered: September 2nd, 2002
Member Is Offline

Theme: UltimaBB Pro Blue

posted on April 15th, 2015 at 10:15 AM



And look at that pic.. another blast from the past...

http://offroadvw.net/exceldyno/exceldynologo.gif




Reub


  Go To Top


Powered by GaiaBB, © 2011 The GaiaBB Group


[ Queries: 40 ] [ PHP: 17.1% - SQL: 82.9% ]