Excel sheet that calculates a bunch of engine data...
#1
TECH Enthusiast
Thread Starter
Join Date: Nov 2001
Location: Orange, TX
Posts: 526
Likes: 0
Received 0 Likes
on
0 Posts
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>
#4
The Bull
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.
Trending Topics
#8
TECH Enthusiast
Thread Starter
Join Date: Nov 2001
Location: Orange, TX
Posts: 526
Likes: 0
Received 0 Likes
on
0 Posts
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).
#12
TECH Regular
iTrader: (1)
Join Date: Jun 2005
Location: The Woodlands, TX
Posts: 445
Likes: 0
Received 0 Likes
on
0 Posts
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