Results 1 to 3 of 3

Thread: Engine modelling spread sheet is back and better. Readme file now uploaded

  1. #1
    The Evil Director Backyard Mechanic jfallen's Avatar
    Join Date
    Mar 2006
    Location
    SA
    Posts
    307

    Wink Engine modelling spread sheet is back and better. Readme file now uploaded

    Hello all,
    After landing the worlds most boring (yet oddly well paying) job I've had time to go back and work on this from a few years ago.

    Functions of the Data sheet include:
    -Determining engine airflow requirements for boosted applications for varying power and RPM situations
    -Intercooler efficiency and inlet temperatures
    -Injector sizing
    -Piston postion
    -Piston acceleration
    -Piston Velocity
    -Wheel speed calculations
    -Compression ratio calculator
    -Intercooler piping air velocity calculator.
    -Brake Mean Efficiency Pressure (BMEP)
    -Power to weight
    -Specific Power / power per cylinder
    -Engine airflow requirements in lbs/m, CFM, m^3/s, m^3/m, kg/s for varyiung RPM
    -Gearbox calculations
    -Complete list of Garrett, mid frame KKK and all Trust Turbochargers + a few other oddballs.
    -Turbocharger TRIM calculations
    -2 Very ruff Power curve charts that require significant effort to be accurate. The equations I've used are great for modeling peak power output and airflow requirements, but poor at transitional modeling.
    -Manual Dyno Sheet
    -Extensive comments describing various functions of the sheet as a whole
    -Using goal seek and solver you can work out all sorts of problems by defining certain specific conditions and constrains.

    I'm working on a proper readme file that will be uploaded once complete. Until then, have a play. See what you think. The sheet is totally open and free to modify. No locked cells.

    Cheers
    Jordan

    P.S: the layout is a bit all-over-the-place, but you get use to it on a big screen
    Attached Files Attached Files
    Last edited by jfallen; 13-12-2010 at 11:22 PM.
    Past rides: 86 Hilux, 3x ke55 rollas's (2coupes,) 5th Gen GT4 x2, RA28, TA22 x3, KE10, P610 datto, RT40 corona x3, RT132, MX13

    Currrent: , CA-A22 Celica living life as a Sports Sedan, 2000model ST215W Caldina GT-T manual, RT40 corona.

  2. #2
    Junior Member 1st year Apprentice topgun137's Avatar
    Join Date
    Jun 2007
    Location
    WA
    Posts
    41

    Default Re: Engine modelling spread sheet is back and better.

    epic win, great work!
    Quote Originally Posted by gold28
    I always found that mufflers are always useless weight.

  3. #3
    The Evil Director Backyard Mechanic jfallen's Avatar
    Join Date
    Mar 2006
    Location
    SA
    Posts
    307

    Default Re: Engine modelling spread sheet is back and better.

    Some minor updates

    but more importantly the Read-me file so that it's not such a jumble.

    Cheers
    Jordan
    Past rides: 86 Hilux, 3x ke55 rollas's (2coupes,) 5th Gen GT4 x2, RA28, TA22 x3, KE10, P610 datto, RT40 corona x3, RT132, MX13

    Currrent: , CA-A22 Celica living life as a Sports Sedan, 2000model ST215W Caldina GT-T manual, RT40 corona.

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •