Community //
in

Transmission Worksheet *** Discontinued ***

Last post 08-28-2009, 12:33 AM by Trident Tristar. 323 replies.
Page 2 of 17 (324 items)   < Previous 1 2 3 4 5 Next > ... Last »
Sort Posts: Previous Next
  •  06-26-2007, 2:40 PM 378210 in reply to 377726

    Re: Transmission Calculator

    i'd jus turn off TCS and kinda do a burnout. find the right gear that would let me get down low enough, and high enough at full throttle with the engine under load. i've never tried to get exact readings this way, but i've done it just outta curiousity.
    [Mod edit: Sig size exceeds forum limits, 480x115 pixels max - D]
    CLICK THIS PIC TO FIND OUT WHY IT'S HERE...
  •  06-26-2007, 3:23 PM 378686 in reply to 377449

    Re: Transmission Calculator

    Flying Scot AD:

    Tonka Crash:

    I chose taller gears when recording a run for playback to give the slowest acceleration, making it easier to get values close to the target torque values from the playback of telemetry.

    That's how I used to tune my gears on Forza 1 on the Test Track Oval. Works great.

    Blooze, another work of art has been produced for the masses to destroy. At this point you should have the thread locked and only modified when new developments arise. Another thread should be started for comments and conjecture. One thing I might add is when updates are made, the thread title should be adjusted to add - Updated 06/26/07 then we would know an update has occured.

    Okay, which one of the internet savy people want to add this to the Web. Similar to the Tuning Calculator of Fuerdog's. That way all the regular Joe's and Josephine's who are not able to dabble with Excel can benefit from this exceptional tool.

    Thanks Scotty... Smile [:)]

    Well, they can't get at the original post at least.  We might as well keep it all in here rather than scatter it all around the board...  Big Smile [:D]

    WHAT!!? Surprise [:O] 

    You mean everybody doesn't have MS Office Pro on every PC in the house?  How do they live?

    Big Smile [:D] $


    Forza-Tuning
  •  06-26-2007, 4:42 PM 379435 in reply to 378686

    Re: Transmission Calculator

    Some of us struggle with our day to day lives since we no longer have a company nice enough to supply it.

    I have been sitting on my Vista upgrade for a few months now but it might be time to do it as I have a need for Office Pro again. Can't wait to rebuild from scratch my Forza Access Database......


    WARNING - Spamming, Trolling or Flaming is about to hurt.


    My Only Livery attempt
  •  06-26-2007, 6:53 PM 380570 in reply to 370040

    Re: Transmission Calculator

    Thanks for an excellent post Blooze. Its always a pleasure to read posts that educate me, and give a good foundation for future experiments.

    Keep up the excellent posts, and don't let Feuerdog convert you from using Excel :D
  •  06-26-2007, 6:57 PM 380608 in reply to 380570

    Re: Transmission Calculator

    LOL - oh you needn't worry about that.  I think in terms of a spreadsheet.  Or a database.  Anytime I have a quandry, I fire up Excel and start looking at the data - looking for relationships and and ways to modify them... Big Smile [:D]

    Thanks for the kind words.

    Smile [:)] $


    Forza-Tuning
  •  06-26-2007, 7:02 PM 380657 in reply to 379435

    Re: Transmission Calculator

    Flying Scot AD:

    Some of us struggle with our day to day lives since we no longer have a company nice enough to supply it.

    I have been sitting on my Vista upgrade for a few months now but it might be time to do it as I have a need for Office Pro again. Can't wait to rebuild from scratch my Forza Access Database......

    Boy, it will be from scratch almost.  So much has changed.

    I wonder should I call up SSA and say, Since they're paying the bills now, any chance I could borrow a copy of Office 2007 for the night... Wink [;)]

    Ever wonder how many instances of purloined Office there are out there?  I know the copy I have now is the first one I ever paid for.  I swapped all the dumb software that usually comes on a new computer for a copy of Office Pro.  Of course I had to toss in an extra $200 to boot... Tongue Tied [:S]

    Smile [:)] $


    Forza-Tuning
  •  06-26-2007, 7:17 PM 380776 in reply to 380657

    Re: Transmission Calculator

    docs.google.com and staroffice are both free, and with the calc's on this spreadsheet should be fully compatiable.

     

    Thanks for the spreadsheet - having to rewrite a whole bunch of the cells in the formula's was a bit annoying, but I will live. :)

     

    Now to find time tonight to actually use it.


    --
    SBRL - http://www.sneakybuffalo.com/racing/
  •  06-26-2007, 8:10 PM 381290 in reply to 380776

    Re: Transmission Calculator

    I thought "Having to rewrite a bunch of cells... wtf?"  Then it occurred to me that I had not checked all of the Absolute Addressing... Tongue Tied [:S]

    Another guy had mentioned something about cells not working but it was with something else and I really didn't understand his complaint (I thought it was because I didn't tell him where to find the tire's Aspect ratio).  I am so sorry. Embarrassed [:$]

    I corrected the error and pushed a new file to the download site.  The link is fixed in the OP

    Sorry everybody, if you haven't already gone through the pain of straightening all the screwed up address, get this one.

    Embarrassed [:$] $


    Forza-Tuning
  •  06-26-2007, 8:50 PM 381698 in reply to 380776

    Re: Transmission Calculator

    I'm just here to second Target's post.

    Google Documents (docs.google.com) does a great job of working with Excel spreadsheets, completely free.  I confirmed that it uploads correctly and seems to be functional, but I haven't actually done any real testing with it...although I would say it should work.

    Definitely use this, openoffice.org, or staroffice if you don't have Excel.

    Bret - EXOR Serial
    Exodus Racing
    NO ASSISTS FORZA "CLUB"
  •  06-26-2007, 10:04 PM 382374 in reply to 381698

    Re: Transmission Calculator

    Just post a link to Open Office in your post for those people who don't have excel. It can open and use excel format spreadsheets with very little problems and is completely free. The only problem I've ever seen from Open Office and excel spreadsheets is sometimes fancy formating can get messed up, but your spreadsheet is pretty simple in visual design.


  •  06-27-2007, 12:26 AM 383480 in reply to 370987

    Re: Transmission Calculator

    A kind of instruction sheet for setting up the calculator is now posted on the second post of the thread.  Maybe it will smooth some of the bumps in using this thing.

    Smile [:)] $


    Forza-Tuning
  •  06-27-2007, 1:49 AM 383985 in reply to 383480

    Re: Transmission Calculator

    thx blooze, this really helps me!

     

  •  06-27-2007, 6:25 AM 385104 in reply to 383985

    Re: Transmission Calculator

    All this talk about HP v Torque is doing my head in. All I want to know is how to set up gears in Forza 2 not in a real car  from what I can gather from the posts you don’t want to really drop below Peak Torque  when you change gear, thus maximising the performance of the gears . The problem I have with the posts on this subject is that no one seems to explain how you fin Peak Torque in  a Forza Car ( Not a real one, after all this is a Forza Site)

     

    An example:

     

    I have a B Class Car (B697) FWD Peugeot

    Power = 257hp

    Power RPM = 7000RPM

    Torque = 217 lb –ft

    Torque RPM = 4700

    Redline RPM = 7400

    Weight = 1963

    Tyres = 235/25R19

    My Engine Graph

     

    So the Big question is how do I set up my gears in a FORZA car NOT a real one?

     

    How do you find Peak Torque in a FORZA car NOT a real one?

  •  06-27-2007, 6:33 AM 385127 in reply to 385104

    Re: Transmission Calculator

    Thanks for that, keen to give it a go tonight Wink [;)]

    File is unavailable Embarrassed [:$] Any idea why ?

  •  06-27-2007, 7:14 AM 385252 in reply to 370040

    Re: Transmission Calculator V 1.0 - 06/25/07

    Blooze

    Here are some questions about the posted sheet

    A little further up you will see RPM values for Peak Torque, Peak Power and Red Line.  Write these down if you need to, to remember them.  (1. These are found in the car detals section?)

    Now go to the Dyno graph for your car.  Be sure that you have the selector sitting on a part that you own.  Look the curves over and take a SWAG at where you are going to need to run.  What you are looking for is how far on the Low RPM side of the Torque curve you expect to get.  (2. In Forza how do u find this when you are racing? Im sure it ties into the rev counter some how but how?)

     With the Muscle cars, the only time you get that low is when you are in first gear and just taking off.  For my car the peak Torque is 3400, the Power is 5200, and the Redline is 6300 (3. are these figures taken from the car details screen in Forza 2?)

     and I know from having driven it I can hit 6400 without pinging the rev limiter.  So what I want is the RPM column set so that 3400 to 6400 is somewhere in the middle of the column.  Go to cell A5 and try a few values until the peak torque and redline values are in the column.  I chose 2400. (4. where are you looking on the excel sheet for the peak torque and redline values are in the column what cell ref?)

    Now down a the bottom at cell A40, this is where you input the RPM levels that you will be shifting at.  I have found that one increment past your decided max is good here.  I said that was 6400, so I input 6600. (5. On automatic am I right in saying this should be set at 8000 in Forza?)

    This is what the spreadsheet looks like with the RPMs in place and the Tire info entered.  Notice that the speeds make more sense.  Also, we have one known value.  Max torque is at 3400 RPM.  Max Torque for this car is 483, so entered that value.  The rest of the row fills out when I do. (6. Above you say Max torque is at 3400 RPM then say Max Torque for this car is 483. Where do you get 483 and what is it?)

    7. On your sheet what do cells C5:i29 represent?

    8. On your sheet what do cells K5:P29 represent?

    9. On your sheet what do cells D33:H40 represent?

    Headings to these sections and some notes on the cells giving descriptions would also.

    Looks like this could some great work in the making

     

  •  06-27-2007, 7:24 AM 385277 in reply to 385252

    Re: Transmission Calculator V 1.0 - 06/25/07

    Robin, when you're driving your car, turn on the real time telemetry and check the diff. screens, you'll find a lot of the info you need in there. If you're not sure how to do so, the little FM2 manual that came with the games explains it. Smile [:)]

    Cheers mate,

    Pistol


    max sig img size 115h x 480w. Thanks
  •  06-27-2007, 8:00 AM 385385 in reply to 385104

    Re: Transmission Calculator

    Corp Robin:

    All this talk about HP v Torque is doing my head in. All I want to know is how to set up gears in Forza 2 not in a real car  from what I can gather from the posts you don’t want to really drop below Peak Torque  when you change gear, thus maximising the performance of the gears . The problem I have with the posts on this subject is that no one seems to explain how you fin Peak Torque in  a Forza Car ( Not a real one, after all this is a Forza Site)

     

    An example:

     

    I have a B Class Car (B697) FWD Peugeot

    Power = 257hp

    Power RPM = 7000RPM

    Torque = 217 lb –ft

    Torque RPM = 4700

    Redline RPM = 7400

    Weight = 1963

    Tyres = 235/25R19

    My Engine Graph

     

    So the Big question is how do I set up my gears in a FORZA car NOT a real one?

     

    How do you find Peak Torque in a FORZA car NOT a real one?

    Holy Smokes - I can't believe this.   Take a look at you list above.   The part in the Quoted section..  Okay now find the part where you say "An Example"  Have you got that?  Okay, now  keep looking down... that's it.  Keep reading, now - do you see the bright read text - the big letters?  That my young friend is your Peak Torque and the RPM where it occurs.

    So the answer to your questions at the end there is OPEN YOUR EYES!

    It just so happens that there is no difference between gearing a real car and a Forza 2 car.  The physics and principles are the same.  That is a really cool thing about this game.  In the instructions, when I said, "my Car"  I was talking about a '69 Shelby GT-500.  The reason I didn't mention that is because I didn't want some nebbish trying the gearing in the example and coming back on me cause his friend in a Camaro whipped his butt.  I didn't think somebody would go off thinking I was detailing the 6 speed gearing in my grocery getter.

    I see a great big post of yours down below, I bet that is going to be fun... Tongue Tied [:S]

    Big Smile [:D] $


    Forza-Tuning
  •  06-27-2007, 8:36 AM 385498 in reply to 385252

    Re: Transmission Calculator V 1.0 - 06/25/07

    Corp Robin:

    Blooze

    Here are some questions about the posted sheet

    A little further up you will see RPM values for Peak Torque, Peak Power and Red Line.  Write these down if you need to, to remember them.  (1. These are found in the car detals section?)

    I suspect that the question here is "where is the car details section?"  I am just guessing from the wording.  Go to My Cars and select the car you are working on.  By select, I mean "hit the A"   Notice that the third item on the list is "View Details'.

    Now go to the Dyno graph for your car.  Be sure that you have the selector sitting on a part that you own.  Look the curves over and take a SWAG at where you are going to need to run.  What you are looking for is how far on the Low RPM side of the Torque curve you expect to get.  (2. In Forza how do u find this when you are racing? Im sure it ties into the rev counter some how but how?)

    You find it on the Dyno graph - it is any of the area to the left of the Peak Torque.

     With the Muscle cars, the only time you get that low is when you are in first gear and just taking off.  For my car the peak Torque is 3400, the Power is 5200, and the Redline is 6300 (3. are these figures taken from the car details screen in Forza 2?)

    Yes

     and I know from having driven it I can hit 6400 without pinging the rev limiter.  So what I want is the RPM column set so that 3400 to 6400 is somewhere in the middle of the column.  Go to cell A5 and try a few values until the peak torque and redline values are in the column.  I chose 2400. (4. where are you looking on the excel sheet for the peak torque and redline values are in the column what cell ref?)

    They, aren't in the spreadsheet, I told you to write them down, remember?

    Now down a the bottom at cell A40, this is where you input the RPM levels that you will be shifting at.  I have found that one increment past your decided max is good here.  I said that was 6400, so I input 6600. (5. On automatic am I right in saying this should be set at 8000 in Forza?)

    I haven't the foggiest idea what car you are talking about.  You would have to drive it and find out where the tach needle starts bouncing off the Rev Limiter.

    This is what the spreadsheet looks like with the RPMs in place and the Tire info entered.  Notice that the speeds make more sense.  Also, we have one known value.  Max torque is at 3400 RPM.  Max Torque for this car is 483, so entered that value.  The rest of the row fills out when I do. (6. Above you say Max torque is at 3400 RPM then say Max Torque for this car is 483. Where do you get 483 and what is it?)

    I think we covered that in another post. Big Smile [:D]

    7. On your sheet what do cells C5:i29 represent?

    The area C5:H29 is the Torque at the wheel for each gear for each RPM increment.  The whole reason for the spreadsheet.  I5:H29 is the Horsepower at each RPM increment.

    8. On your sheet what do cells K5:P29 represent?

    That is the speed in mph for each gear in each RPM increment.  I said that in the first post.

    9. On your sheet what do cells D33:H40 represent?

    That is the entry RPM for each of the shift changes for each of the RPM increments.  Hence the label 1-2.  This is detailed in the first post as well.

    Headings to these sections and some notes on the cells giving descriptions would also.

    You have a copy, you are welcome to do what ever you want to with it.   I wanted it all to fit into a certain area.  That is why I didn't clutter it up with a bunch of superflous labels and descriptions.

    Looks like this could some great work in the making

    You arrogant little twit.  I have been using this thing like it is for d*mn near 4 years.  If you think I'm going to hop to and clutter it all up with cr*p because your precious self is confused, you have another think coming.  People like you are the reason I never posted it before - I knew I would run into a PDU that couldn't read.  My first suggestion is that you slow down, read things carefully and think about them.  I am amazed that you are going through all of this to work for an automatic transmission??  90% of it doesn't apply to you - you can't control your shift points.

    My second suggestion, the one that hope you will truly take to heart.  Delete the spreadsheet and don't bother me again.

    And just in case you are wondering why I got all pissy with you, I will tell you.  It is your attitude son.  You act like I owe this to you.  And sonny boy, I don't owe you sh*t!

     


    Forza-Tuning
  •  06-27-2007, 9:02 AM 385615 in reply to 385127

    Re: Transmission Calculator

    Carn:
    Thanks for that, keen to give it a go tonight Wink [;)]

    File is unavailable Embarrassed [:$] Any idea why ?

    You are welcome Big Smile [:D]

    The file is being hosted by MegaUpload.   There have been 15 hits on it in the last hour so it is up.  I don't know what happened to you.  Try again.

    Smile [:)] $


    Forza-Tuning
  •  06-27-2007, 9:38 AM 385786 in reply to 383985

    Re: Transmission Calculator

    Stan Getz:

    thx blooze, this really helps me!

    You're welcome.  I'm glad it is working out for you.

    Smile [:)] $


    Forza-Tuning
Page 2 of 17 (324 items)   < Previous 1 2 3 4 5 Next > ... Last »
View as RSS news feed in XML