| [ Total Views: 8824 | Total Replies: 12 | Thread Id: 18037 ] |
|
|
 Baja Wes
Bishop of Volkswagenism
V6 Baja Pioneer
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 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?
|
|
|
modulus
A.k.a.: Peter Hill
Veteran Volks Folk
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!
|
|
|
Baja Wes
Bishop of Volkswagenism
V6 Baja Pioneer
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
|
|
|
gldgti
Learner Dubber
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
|
|
|
Volkswagenboy
A.k.a.: Brenton Barry
Veteran Volks Folk
Staggers Automotive.
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 |
|
|
Nigel
Learner Dubber
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.
|
|
|
Baja Wes
Bishop of Volkswagenism
V6 Baja Pioneer
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...
|
|
|
Nigel
Learner Dubber
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)
|
|
|
Baja Wes
Bishop of Volkswagenism
V6 Baja Pioneer
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
|
|
|
Judsons4eva
Officially Full-On Dubber
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
|
|
|
Golde60
Fahrvergnugen
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 ).....................
|
|
|
adlbeetle66
A.k.a.: Denver
Custom Title Time!
Under the car.........again!
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?
|
|
|
reub
Veteran Volks Folk
VWRX is gone...
Posts: 2054
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...
Reub
|
|
|
