Author Topic: Compression ratio vs. efficiency Excel program  (Read 15019 times)

0 Members and 1 Guest are viewing this topic.

Offline panic

  • Sr. Member
  • ****
  • Posts: 845
    • My tech papers
Compression ratio vs. efficiency Excel program
« on: December 06, 2009, 12:25:00 PM »
This is an .xls to compare changes in static CR (in .01 ratio increments) old vs. new as efficiency for each, an compares % nominal change and efficiency % change.
Based on the usual Otto math: E = 1-(1/CR^K-1), where K=1.4. If you need another value just substitute, it's not locked in.

Just use the spin buttons to input your CR (arrow = .01 ratio, open space = 1 ratio).

LMK if you think of any useful changes?

Offline pookie

  • Full Member
  • ***
  • Posts: 129
Re: Compression ratio vs. efficiency Excel program
« Reply #1 on: December 06, 2009, 12:48:04 PM »
HUH...????????    At least I did not need spell check for this one!!!!!!
« Last Edit: December 06, 2009, 12:56:25 PM by pookie »

Offline fredvance

  • FVANCE
  • Hero Member
  • *****
  • Posts: 2297
    • Vance and Forstall Racing
Re: Compression ratio vs. efficiency Excel program
« Reply #2 on: December 06, 2009, 01:16:52 PM »
So if your thermal effeciency is 10% higher this meas what in terms of horsepower?
WORLDS FASTEST PRODUCTION MOTORCYCLE 213.470
Vance&Forstall Racing
WOS 2011 235+MPH
Engine by Knecum, Tuned by Johnny Cheese.
Sponsers Catalyst Composites, Johnny Cheese Perf, Knecum Racing Engines, Murray Headers, Carpenter Racing

Offline Peter Jack

  • Hero Member
  • *****
  • Posts: 3776
Re: Compression ratio vs. efficiency Excel program
« Reply #3 on: December 06, 2009, 02:47:00 PM »
Panic:

Just so you know, when you try and open the spreadsheet on the MAC with Microsoft Office installed you get a message which says the spreadsheet contains Visual Basic macros and Microsoft EXEL for MAC cannot process Visual Basic macros. I can switch to a PC but some may not have that convenience.

Pete

Offline Milwaukee Midget

  • Global Moderator
  • Hero Member
  • ***
  • Posts: 6662
    • Milwaukee Midget Racing
Re: Compression ratio vs. efficiency Excel program
« Reply #4 on: December 06, 2009, 03:20:58 PM »
Hey, Peter -

I had success by downloading it to my desktop and opening it with Appleworks, if you have that.

Thanks for the spreadsheet, Panic.
"Problems are almost always a sign of progress."  Harold Bettes
Well, I guess we're making a LOT of progress . . .  :roll:

Offline Freud

  • Hero Member
  • *****
  • Posts: 5419
Re: Compression ratio vs. efficiency Excel program
« Reply #5 on: December 06, 2009, 03:22:46 PM »
Download OpenOffice.org for the Mac and it will open it instantly, after the virus warning.

FREUD
Since '63

Offline panic

  • Sr. Member
  • ****
  • Posts: 845
    • My tech papers
Re: Compression ratio vs. efficiency Excel program
« Reply #6 on: December 06, 2009, 03:56:53 PM »
Assuming that the basic chamber shape isn't changed much (which will only be true with small changes, not going from 10 to 12, etc.) you'll get close to that as power.
Obviously, a dome intrusion or chamber masking will reduce the net.
This also does not compare engines re-optimized for higher ratio, such as different intake/exhaust bias, later IVC, narrower LSA, etc.

Offline panic

  • Sr. Member
  • ****
  • Posts: 845
    • My tech papers
Re: Compression ratio vs. efficiency Excel program
« Reply #7 on: January 10, 2011, 11:41:55 AM »
Sorry, spreadsheet is not available.

Offline AHG

  • Full Member
  • ***
  • Posts: 243
Re: Compression ratio vs. efficiency Excel program
« Reply #8 on: January 15, 2011, 02:17:13 PM »
http://www.youtube.com/watch?v=5hMAaOdNkgI
Come on now, you know as well as I do, that sometimes funny things
just need to be shared.

:|   :-)   :-o   :-D   :cheers:
~ I CAN COUNT MY LIFE ON ONE HAND ~
Faith, Family, Friends, & Fast Motorcycles

Offline Stan Back

  • Hero Member
  • *****
  • Posts: 5879
Re: Compression ratio vs. efficiency Excel program
« Reply #9 on: January 15, 2011, 06:36:53 PM »
Prof. Irwin Corey's kid?
Past (Only) Member of the San Berdoo Roadsters -- "California's Most-Exclusive Roadster Club" -- 19 Years of Bonneville and/or El Mirage Street Roadster Records