epic win, great work!
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![]()
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.
epic win, great work!
Originally Posted by gold28
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