Excel sheet that calculates a bunch of engine data...
Thread Starter
TECH Enthusiast
Joined: Nov 2001
Posts: 526
Likes: 0
From: Orange, TX
Excel sheet that calculates a bunch of engine data... I have been thinking about a big inch motor lately and it has generated all kinds of questions, and I got tired of screwing around on a calculator. So I worked up an Excel sheet that calculates all the things that I have been doing over and over.
It calculates:
- Engine size in C.I and liters
- compression ratio
- rod/stroke ratio
- piston C/D for zero deck height protrusion
You have to enter:
- bore
- stroke
- rod length
- deck height
- combustion chamber volume
- head gasket thickness
- piston relief/dome cc's
- actual piston C/D
The compression ratio calc takes into account head gasket thickness, valve reliefs or domes, and piston deck heights above or below zero deck height. It allows you to play with different C/D's, gaskets, and reliefs to get the compression ratio you're looking for.
If someone would help me figure out how to make this file available from my website, then I'll post it there. Otherwise I'll email it to anyone who wants it.
Use it at your own risk! I checked it against the Ross Pistons calc link on their website, and mine seems to work fine. It's basically the same as the Ross link, except mine produces a little more info.
<small>[ November 04, 2002, 09:59 PM: Message edited by: ScottyG ]</small>
It calculates:
- Engine size in C.I and liters
- compression ratio
- rod/stroke ratio
- piston C/D for zero deck height protrusion
You have to enter:
- bore
- stroke
- rod length
- deck height
- combustion chamber volume
- head gasket thickness
- piston relief/dome cc's
- actual piston C/D
The compression ratio calc takes into account head gasket thickness, valve reliefs or domes, and piston deck heights above or below zero deck height. It allows you to play with different C/D's, gaskets, and reliefs to get the compression ratio you're looking for.
If someone would help me figure out how to make this file available from my website, then I'll post it there. Otherwise I'll email it to anyone who wants it.
Use it at your own risk! I checked it against the Ross Pistons calc link on their website, and mine seems to work fine. It's basically the same as the Ross link, except mine produces a little more info.
<small>[ November 04, 2002, 09:59 PM: Message edited by: ScottyG ]</small>
The Bull
Joined: Jun 2002
Posts: 3,578
Likes: 2
From: Grand Rapids, MI
Re: Excel sheet that calculates a bunch of engine data... I'd like a copy too. I can add some gearing information and estimated HP from weight and ET as well as estimated ET from weight and HP, etc.
Re: Excel sheet that calculates a bunch of engine data... Trending Topics
Thread Starter
TECH Enthusiast
Joined: Nov 2001
Posts: 526
Likes: 0
From: Orange, TX
Re: Excel sheet that calculates a bunch of engine data... Damn chikn, you're serious about this, aren't you. <img border="0" title="" alt="[Smile]" src="gr_stretch.gif" /> Sounds like a nice application.
Mine's a pretty stupid little spreadsheet, but it does the job.... lets you play around with different combos. Like I said, it keeps me off the calculator.
If I have a copy of the sheet here at work I'll send it to all y'all right away, otherwise it'll be later on dis eenin' (that's "this evening" for you redneck-challenged folks).
Mine's a pretty stupid little spreadsheet, but it does the job.... lets you play around with different combos. Like I said, it keeps me off the calculator.
If I have a copy of the sheet here at work I'll send it to all y'all right away, otherwise it'll be later on dis eenin' (that's "this evening" for you redneck-challenged folks).
LS1 Tech Stories
The Best V8 Stories One Small Block at Time
Gas Monkey Built a 6-Wheel Ferrari Testarossa With a Corvette LT4 Engine
Verdad Gallardo
7 Most Reliable High-Performance Engines GM Has Ever Built
Verdad Gallardo
Amazing '71 Camaro Restomod Is Modern Muscle Car Under the Skin
Verdad Gallardo
6 Common C5 Corvette Failures and What's Involved In Repairing Them
Pouria Savadkouei
Retro Modern Bandit Pontiac Trans AM Comes With Burt Reynolds' Autograph
Verdad Gallardo
Top 10 Greatest Cadillac V Series Performance Models Ever, Ranked
Pouria Savadkouei
Top 10 Most Powerful Chevy Trucks Ever Made!
Hennessey's New Supercharged Silverado ZR2 Has 700 HP
Verdad Gallardo
Coachbuilt N2A Anteros Is an LS2-Powered C6 Corvette In Italian Clothes
Verdad Gallardo
Thanks guys! 
just search for "piano prodigy VE calculator". it's also an excel spreadsheet, does all the same stuff, plus some cool new stuff, ie. valve events...works really well and i play with it alot. if i were at work i could email it to you but i'm not, so you'll have to try your luck with the search...
calculates, calculator, compression, data, engine, event, excel, horsepower, ls1, motor, piano, prodigy, ratio, sheet, valve
