Community //
in

Transmission Worksheet *** Discontinued ***

Last post 05-04-2010, 6:51 AM by mnchkn. 325 replies.
Page 12 of 17 (326 items)   « First ... < Previous 10 11 12 13 14 Next > ... Last »
Sort Posts: Previous Next
  •  07-12-2007, 9:03 AM 520123 in reply to 518743

    Re: Transmission Calculator

    So I guess, close only counts in horseshoes, hand grenades, and car tuning?  lol
    FM3 Suspension Calculator
    http://forums.forzamotorsport.net/forums/thread/3073197.aspx

    iPHONE Calculator
    http://forzatune.com/

    DROID Calculator
    http://blog.synformation.com/2010/01/13/forzadroid
  •  07-12-2007, 9:56 AM 520374 in reply to 520123

    Re: Transmission Calculator

    well in order for my spreadsheet to match HP in the game based on the torque and RPM I had to change the value to 5249.8, and we all know that's wrong. I also just noticed that my GT500 PI B700 has BF-Goodwrench 225/50R 18's on it and that tire doesn't exist. Or atleast, I can't find it. Or maybe I'm missing something.
  •  07-12-2007, 12:31 PM 521513 in reply to 520374

    Re: Transmission Calculator

    poweredbynos:
    well in order for my spreadsheet to match HP in the game based on the torque and RPM I had to change the value to 5249.8, and we all know that's wrong. I also just noticed that my GT500 PI B700 has BF-Goodwrench 225/50R 18's on it and that tire doesn't exist. Or atleast, I can't find it. Or maybe I'm missing something.

    I've noticed a large number of tire sizes the game allows don't exist in the real world. It makes for a better game to allow more options for each car, but does get away from being a simulator.  They also don't seem to worry that many real world tires usually don't match stated size very closely.  I've experienced this with 2 different models of 285/75R16 tires on my Nissan Xterra.  One fit fine, the other needed a little trimming to the fenders with a sawzall to stuff in the wheel wells.



    My Gallery at Flickr - Updated Frequently
  •  07-12-2007, 1:13 PM 521864 in reply to 370040

    Re: Transmission Calculator V 1.1 - 06/28/07

    I wnat to tune my NUR with this but i can't totally figure it out?!
    I need to fined the tourque at the rpm's how do i do this?
    i have 1st and 6th set, but need to find torque to enter in?

    Can you point me in the direction of a post to help me with this, or a specific page in this post, Please?

    Peace
  •  07-13-2007, 1:36 AM 527031 in reply to 521864

    Re: Transmission Calculator V 1.1 - 06/28/07

    Try the first and second post in this thread.  Or go through the whole thread your questions have been asked numerous times.

     

    I am getting tired of seeing people asking Blooze to basically reexplain how to use his tool.  I can only imagine how he is feeling.  He said it very well in the first two posts. 

     

    If after you figure it out, you want to give suggestions to Blooze for how to change those posts in a way that would have made you understand faster, please do.


    --
    SBRL - http://www.sneakybuffalo.com/racing/
  •  07-13-2007, 8:09 AM 528558 in reply to 504092

    Re: Transmission Calculator V 1.1 - 06/28/07

    feuerdog:

    I haven't fully tested it yet, to be honest.  So, i'm not exactly sure how well it works.

    The constants are simple multipliers based on the spread between the .84 top gear and the 1st gear setting based on the size of the trans.

    I had to do some number crunching to get it accurate, and it still isn't perfect, but the spreads should work well enough.  The "arc" of how the gears layout is nice and smooth and progressive, and is no way based on power or torque directly, but based on real world ratios and the "feel" settings it should work well enough as a basic generic calc for most cars.  It is entirely unrefined though,....so feedback is welcome as usual.

    feuerdog – could you help me understand your calculations please?

     

    Step1.1.b - Determine an initial final drive setting by dividing weight by peak HP, and using the table

     

    Step 1.2.a - Set initial gear settings dependant on transmission size using the table

     

    Step 1.3.a - Adjust the direct drive gear as detailed

     

    Step 2 - Finalise the final drive settings as detailed

     

    Step 3 - Finalise 1st gear settings as detailed

     

    Step 4 - Find the gear spread multiplier as detailed

     

    Now this is the part I’m having trouble with:

    Step 5 - Tune the remaining gears as detailed

     

    Does this mean that I have to re-adjust every gear apart from the final drive and 1st gear (which I’ve already finalised)?

     

    Haven’t I already adjusted the direct drive gear back in step 1.3.a?

     

     

     

    Excellent work by the way - really looking forward to the suspension cal V3

     

    Thanks

     

  •  07-13-2007, 8:35 AM 528676 in reply to 528558

    Re: Transmission Calculator V 1.1 - 06/28/07

    Vinny:
    feuerdog:

    I haven't fully tested it yet, to be honest.  So, i'm not exactly sure how well it works.

    The constants are simple multipliers based on the spread between the .84 top gear and the 1st gear setting based on the size of the trans.

    I had to do some number crunching to get it accurate, and it still isn't perfect, but the spreads should work well enough.  The "arc" of how the gears layout is nice and smooth and progressive, and is no way based on power or torque directly, but based on real world ratios and the "feel" settings it should work well enough as a basic generic calc for most cars.  It is entirely unrefined though,....so feedback is welcome as usual.

    feuerdog – could you help me understand your calculations please?

     

    Step1.1.b - Determine an initial final drive setting by dividing weight by peak HP, and using the table

     

    Step 1.2.a - Set initial gear settings dependant on transmission size using the table

     

    Step 1.3.a - Adjust the direct drive gear as detailed

     

    Step 2 - Finalise the final drive settings as detailed

     

    Step 3 - Finalise 1st gear settings as detailed

     

    Step 4 - Find the gear spread multiplier as detailed

     

    Now this is the part I’m having trouble with:

    Step 5 - Tune the remaining gears as detailed

     

    Does this mean that I have to re-adjust every gear apart from the final drive and 1st gear (which I’ve already finalised)?

     

    Haven’t I already adjusted the direct drive gear back in step 1.3.a?

     

     

     

    Excellent work by the way - really looking forward to the suspension cal V3

     

    Thanks

     

    A bit of feedback in this as I tried it last night (not directly in response to Vinny but this seemed a better place than in the suspension calcs thread). My Class D Fairlady Z (lightened, added grip, stock HP) only got up to the top end of 4th, could not check out 5th or 6th... as if the car didn't have the power to push at direct ratios and deffinatly not at overdrive ones. I know it isn't perfect, I know it needs tweeking for all cars, Im not asking for help Im supplying a little feedback on what I found hoping that it may help... so no responce necessary really.


    My Forza Cars
    My Real Car

    Great Web Hosting/Design Deals
  •  07-13-2007, 10:54 AM 529397 in reply to 528676

    Re: Transmission Calculator V 1.1 - 06/28/07

    RichMR2  and  Vinny,

    I don't want to highjack Bloozes thread, so let's keep these questions in my suspension thread from now on,.....unless Blooze doesn't mind them being here.

    I'll answer this here for now though, just this once.....

    feuerdog – could you help me understand your calculations please?

     

    Step1.1.b - Determine an initial final drive setting by dividing weight by peak HP, and using the table

     

    Step 1.2.a - Set initial gear settings dependant on transmission size using the table

     

    Step 1.3.a - Adjust the direct drive gear as detailed

     

    Step 2 - Finalise the final drive settings as detailed

     

    Step 3 - Finalise 1st gear settings as detailed

     

    Step 4 - Find the gear spread multiplier as detailed

     

    Now this is the part I’m having trouble with:

    Step 5 - Tune the remaining gears as detailed

     

    Does this mean that I have to re-adjust every gear apart from the final drive and 1st gear (which I’ve already finalised)?

     

    Yes,.....you have to readjust every gear again, except the overdrive, because you haven't actually finalized them, you have merely established a basis for further calculations.

     

    Haven’t I already adjusted the direct drive gear back in step 1.3.a?

     

    No, this is just a starting point to avoid irregular gearing.

     

     

     

     

    A bit of feedback in this as I tried it last night (not directly in response to Vinny but this seemed a better place than in the suspension calcs thread). My Class D Fairlady Z (lightened, added grip, stock HP) only got up to the top end of 4th, could not check out 5th or 6th... as if the car didn't have the power to push at direct ratios and deffinatly not at overdrive ones. I know it isn't perfect, I know it needs tweeking for all cars, Im not asking for help Im supplying a little feedback on what I found hoping that it may help... so no responce necessary really.

    I'll investigate this, put it sounds like something isn't right.  Every vcar in the game can push a .84 overdrive with the right FD setting.  I suspect you FD wasn't set right initially during high speed testing.  Off the top of my head, your FD should be around 3.8 to 4.0 and that will be more than enough gearing to push a .84 OD.


    FM3 Suspension Calculator
    http://forums.forzamotorsport.net/forums/thread/3073197.aspx

    iPHONE Calculator
    http://forzatune.com/

    DROID Calculator
    http://blog.synformation.com/2010/01/13/forzadroid
  •  07-13-2007, 11:04 AM 529463 in reply to 529397

    Re: Transmission Calculator V 1.1 - 06/28/07

    Thanks feuerdog - will try it out tonight
  •  07-13-2007, 1:04 PM 530388 in reply to 527031

    Re: Transmission Calculator V 1.1 - 06/28/07

    Well thanks target17, i understand that, not looking for much other than a thread to find the tourque i understand it know just need to find tourque at certain rpm and he said their was a post about how to find it other than viewing a replay on a long straight away starting on 3rd gear and slowly accelerating.

    If there is no other way than that then i'll do that.
  •  07-13-2007, 3:43 PM 531775 in reply to 530388

    Re: Transmission Calculator V 1.1 - 06/28/07

     
    Which is the option you stated.
     
    Otherwise it's rough guess the numbers at the lines on the graph that shows during engine upgrades.  Then filling in spots to make the curve look the same.

    --
    SBRL - http://www.sneakybuffalo.com/racing/
  •  07-13-2007, 4:14 PM 531987 in reply to 531775

    Re: Transmission Calculator V 1.1 - 06/28/07

    Thank you very much, just want to make the best out of my cars, so thank you again.
    all is answered

    Peace
  •  07-17-2007, 6:29 PM 562793 in reply to 531987

    Gear Spreader

    A number of posts have shown up where folks felt more or less abandoned and has no idea how to proceed once they had established their terminal velocity and set their FD, and then set their first gear for a good launch.  What do I do with the rest of the gears?  It occurred to me as I was reading about Feuerdog's transmission calculator that all I need to is find the percentage each gear used of the gap between 1st and 6th of the stock transmission, then use these percentage values to create a new gear set that has the same spread relationaly as the stock transmission.  Not the best perhaps, but enough to get you out of the pits without a lot of strangiocities...

    For instance, here is the layout of the stock transmission's gears...

    1st gear is 2.89 and 6th is .85 so the gap is 2.89 - .85 or 2.04.

    Gear Ratio    Gap           % of 2.04
    2    1.99     (1-2) .90     .4412
    3    1.51     (2-3) .48     .2353
    4    1.20     (3-4) .31     .1520
    5    1.00     (4-5) .20     .0980

    So, now I have values that I can use to setup a new transmission, no matter what 1st and 6th are.

    I made the following changes to the spreadsheet...

    As you can see, there is now a colorful addition to cells C1 thru H1.  These are the calculations derived from the table above.  The way it is set now any change made to 1st or 6th gear in the pink/grey input area will change the 2 thru 5 gear ratios in cells D1:G1 to the values they need to be to re-establish the stock spacing.  If you want to implement them, all you need do is input them into the proper gear's ratio.  The reason for not doing it automagically is so that input gears could remain independent of calculated gears.  The purple values in cells C1 and H1 are just data transfer functions so that the entire transmission can be copied to another location.

    The simplest way to get the new functionality is to down load the sheet again (I have updated the link)and save it as your new template.  Then you can copy cells C1-H1 to existing worksheets and you will be in business.  But for you hardy souls who aren't afraid to get mussy, here is the layout...

    • cell c1: =C2
    • cell d1: =C1-(($C$1-$H$1)*0.4412)
    • cell e1: =D1-(($C$1-$H$1)*0.2353)
    • cell f1: =E1-(($C$1-$H$1)*0.152)
    • cell g1: =F1-(($C$1-$H$1)*0.098)
    • cell h1: =H2

    FYI - you can copy/paste the bold text above straight into the proper cells and save a bunch of ersatz typing.

    This can be extended in a number of ways, I will leave that to you...

    Smile [:)] $


    Forza-Tuning
  •  07-17-2007, 6:34 PM 562829 in reply to 520123

    Re: Transmission Calculator

    feuerdog:
    So I guess, close only counts in horseshoes, hand grenades, and car tuning?  lol

    Okay, you tell me when to quit and I'll put in with you... 10/3=3.33333333333333333333333333333333333333333333333333333333333333
    333333333333333333333333333333333333333333333333333333333333333333333
    333333333333333333333333333333333333333333333333333333333333333333333
    3333333333333333333333333333333333...

    How accurate do you want it?  Some times common sense has to prevail.

    Smile [:)] $

     


    Forza-Tuning
  •  07-17-2007, 8:51 PM 563759 in reply to 562829

    Re: Transmission Calculator

    Mods, I unpinned this - it is referenced in the Index should anyone feel a need to locate it ... Big Smile [:D]
    Forza-Tuning
  •  07-17-2007, 10:22 PM 564497 in reply to 375978

    Re: Transmission Calculator

    well I know this is a stupid problem, but I cant find a excel for my windows 2000 where I can input anything and not pay 200$ I cant download the version you have because it doesnt work on my comp. I have a few cars I want worked on. And was wondering if you can make a site that you can input the values in?
  •  07-18-2007, 12:03 AM 565110 in reply to 564497

    Re: Transmission Calculator

    Well, you could try Openoffice, 602 Office(I'd recommend this) or buy a PC Magazine with the new MS Office Trial on it's cover cd/dvd.

    Good luck bud, but one of these should suffice.


    max sig img size 115h x 480w. Thanks
  •  07-18-2007, 7:47 AM 566815 in reply to 564497

    Re: Transmission Calculator

    Anarchy_Thunder:
    well I know this is a stupid problem, but I cant find a excel for my windows 2000 where I can input anything and not pay 200$ I cant download the version you have because it doesnt work on my comp. I have a few cars I want worked on. And was wondering if you can make a site that you can input the values in?

    Sorry pard - someone else will have to undertake that.  I consider programming for the INet a train wreck and don't go near it if I can keep from it, and I don't feel like building a C# .exe for it - hell, I just retired from all that crap.

    Big Smile [:D] $


    Forza-Tuning
  •  07-18-2007, 8:02 AM 566872 in reply to 562793

    Re: Gear Spreader

    Blooze:

    For instance, here is the layout of the stock transmission's gears...

    1st gear is 2.89 and 6th is .85 so the gap is 2.89 - .85 or 2.04.

    Gear Ratio    Gap           % of 2.04
    2    1.99     (1-2) .90     .4412
    3    1.51     (2-3) .48     .2353
    4    1.20     (3-4) .31     .1520
    5    1.00     (4-5) .20     .0980

    So, now I have values that I can use to setup a new transmission, no matter what 1st and 6th are.

    Do you know if all cars with six gear transmissions use the same percentages (not actual ratios) as the example above, or would each transmission have a different set of percentages?


    Keep it clean
  •  07-18-2007, 8:08 AM 566893 in reply to 566872

    Re: Gear Spreader

    When you start out with the Race Transmission you have those exact ratios.  Whether they are right for your car is up for you to decide.

    Smile [:)] $


    Forza-Tuning
Page 12 of 17 (326 items)   « First ... < Previous 10 11 12 13 14 Next > ... Last »
View as RSS news feed in XML