Generation III Internal Engine 1997-2006 LS1 | LS6
Sponsored by:
Sponsored by:

Excel sheet that calculates a bunch of engine data...

Thread Tools
 
Search this Thread
 
Old 11-04-2002, 09:13 PM
  #1  
TECH Enthusiast
Thread Starter
 
ScottyG's Avatar
 
Join Date: Nov 2001
Location: Orange, TX
Posts: 526
Likes: 0
Received 0 Likes on 0 Posts

Default 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>
Old 11-06-2002, 11:50 PM
  #2  
TECH Senior Member
iTrader: (4)
 
99 Black Bird T/A's Avatar
 
Join Date: Nov 2001
Posts: 8,583
Received 1,432 Likes on 992 Posts

Default Re: Excel sheet that calculates a bunch of engine data...

Sounds pretty cool, can you email me a copy?

Thanks
Old 11-07-2002, 06:42 AM
  #3  
TECH Enthusiast
Thread Starter
 
ScottyG's Avatar
 
Join Date: Nov 2001
Location: Orange, TX
Posts: 526
Likes: 0
Received 0 Likes on 0 Posts

Default Re: Excel sheet that calculates a bunch of engine data...

Sent it. If you make any corrections or enhancements, shoot me a copy back.
Old 11-07-2002, 06:48 AM
  #4  
The Bull
 
DERTY's Avatar
 
Join Date: Jun 2002
Location: Grand Rapids, MI
Posts: 3,578
Likes: 0
Received 2 Likes on 1 Post
Default 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.
Old 11-07-2002, 06:58 AM
  #5  
TECH Enthusiast
Thread Starter
 
ScottyG's Avatar
 
Join Date: Nov 2001
Location: Orange, TX
Posts: 526
Likes: 0
Received 0 Likes on 0 Posts

Default Re: Excel sheet that calculates a bunch of engine data...

Yeah, that's a good idea. Here it comes....
Old 11-07-2002, 07:10 AM
  #6  
TECH Fanatic
iTrader: (2)
 
99taws6's Avatar
 
Join Date: Nov 2001
Location: Killeen, Texas
Posts: 1,655
Likes: 0
Received 0 Likes on 0 Posts

Default Re: Excel sheet that calculates a bunch of engine data...

can I get a copy? my99taws6@knology.net
Old 11-07-2002, 07:18 AM
  #7  
Moderator
iTrader: (4)
 
JNorris's Avatar
 
Join Date: Nov 2001
Location: Montgomery, AL
Posts: 2,074
Likes: 0
Received 0 Likes on 0 Posts

Default Re: Excel sheet that calculates a bunch of engine data...

Please email a copy to jnorris404@aol.com

Thanks

John
Old 11-07-2002, 08:19 AM
  #8  
TECH Enthusiast
Thread Starter
 
ScottyG's Avatar
 
Join Date: Nov 2001
Location: Orange, TX
Posts: 526
Likes: 0
Received 0 Likes on 0 Posts

Default 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).
Old 02-08-2008, 01:21 PM
  #9  
TECH Fanatic
iTrader: (12)
 
joshua022's Avatar
 
Join Date: Apr 2007
Location: Douglasville, GA
Posts: 1,276
Likes: 0
Received 0 Likes on 0 Posts
Default

I know this thread is really old...but could someone email me a copy??
Old 02-08-2008, 01:27 PM
  #10  
TECH Enthusiast
iTrader: (1)
 
aaron653's Avatar
 
Join Date: Aug 2005
Posts: 728
Likes: 0
Received 0 Likes on 0 Posts

Default

Originally Posted by joshua022
I know this thread is really old...but could someone email me a copy??
lol..
Old 02-08-2008, 04:47 PM
  #11  
TECH Resident
iTrader: (21)
 
camaroguy26's Avatar
 
Join Date: Sep 2005
Location: New Jersey
Posts: 820
Likes: 0
Received 0 Likes on 0 Posts
Default

haha I wouldn't mind a copy either Thanks guys!
Old 02-08-2008, 05:32 PM
  #12  
TECH Regular
iTrader: (1)
 
wolfy's Avatar
 
Join Date: Jun 2005
Location: The Woodlands, TX
Posts: 445
Likes: 0
Received 0 Likes on 0 Posts

Default

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...




All times are GMT -5. The time now is 11:32 AM.