Welcome to the North American Subaru Impreza Owners Club Tuesday July 29, 2014
Home Forums WikiNASIOC Products Store Modifications Upgrade Garage
NASIOC
Here you can view your subscribed threads, work with private messages and edit your profile and preferences Home Registration is free! Visit the NASIOC Store NASIOC Rules Search Find other members Frequently Asked Questions Calendar Archive NASIOC Upgrade Garage Logout
Go Back   NASIOC > NASIOC Technical > Built Motor Discussion

Welcome to NASIOC - The world's largest online community for Subaru enthusiasts!
Welcome to the NASIOC.com Subaru forum.

You are currently viewing our forum as a guest, which gives you limited access to view most discussions and access our other features. By joining our community, free of charge, you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is free, fast and simple, so please join our community today!

If you have any problems with the registration process or your account login, please contact us.
* Registered users of the site do not see these ads.
Reply
 
Thread Tools Display Modes
Old 04-11-2009, 08:30 PM   #1
Team Scream
Scooby Specialist
 
Member#: 121532
Join Date: Jul 2006
Chapter/Region: SCIC
Vehicle:
2006 FXT/STi 6MT
01 Aerosim GC8 Coupe

Default Engine Build Spreadsheet attached - PLEASE LOOK

I created a spreadsheet for those who want to track everything to do with your engine build.
Here is a link for it, I really need someone to have a look at it and let me know if it works the way you would like it to work.
Thanks.

Password is "1234"

Excel 2007 or newer version below:
http://www.teamscream.net/Scooby Log...rksheet-L.xlsx

Excel 2003 or newer version below.
http://www.teamscream.net/Scooby Log...rksheet-Lx.xls

Basically you input all of your measured data into the YELLOW cells in the sheet, and the sheet will use this information to calculate your compression ratio and a few other things for you.
These are all measurements that you would be taking anyway if you are building an engine, so this way you can enter that data in this sheet and have a permanent record of that build, And you don't have to do a bunch of math to figure out your compression ratio.
I have one small change I want to make.....see post #8 for the details.
* Registered users of the site do not see these ads.

Last edited by Team Scream; 04-17-2009 at 05:24 PM. Reason: Edited
Team Scream is offline   Reply With Quote
Old 04-12-2009, 06:07 PM   #2
Team Scream
Scooby Specialist
 
Member#: 121532
Join Date: Jul 2006
Chapter/Region: SCIC
Vehicle:
2006 FXT/STi 6MT
01 Aerosim GC8 Coupe

Default Created one Let me know what you think.

Ooops double post really,.

Last edited by Team Scream; 04-13-2009 at 09:29 PM.
Team Scream is offline   Reply With Quote
Old 04-13-2009, 11:04 PM   #3
XanRules
NASIOC Supporter
 
Member#: 157348
Join Date: Aug 2007
Chapter/Region: NWIC
Location: Rustletech Headquarters
Vehicle:
1996 JNCO Jorts
Stonewashed Denim

Default

This looks like it would be really useful. I don't know how it works.
XanRules is offline   Reply With Quote
Old 04-13-2009, 11:08 PM   #4
FuJi K
Scooby Guru
 
Member#: 3687
Join Date: Jan 2001
Chapter/Region: MWSOC
Location: St. Paul, MN
Vehicle:
MY99 GF4 JDM 6spd
NF Performance

Default

This is what you would call "BLUE PRINTING." .....I think.
FuJi K is offline   Reply With Quote
Old 04-13-2009, 11:09 PM   #5
XanRules
NASIOC Supporter
 
Member#: 157348
Join Date: Aug 2007
Chapter/Region: NWIC
Location: Rustletech Headquarters
Vehicle:
1996 JNCO Jorts
Stonewashed Denim

Default

Quote:
Originally Posted by FuJi K View Post
This is what you would call "BLUE PRINTING." .....I think.
Oh man. My engine build is mostly me buying parts, laying them out, bouncing ideas off people, and hoping everyone else knows what I'm talking about.
XanRules is offline   Reply With Quote
Old 04-13-2009, 11:45 PM   #6
FuJi K
Scooby Guru
 
Member#: 3687
Join Date: Jan 2001
Chapter/Region: MWSOC
Location: St. Paul, MN
Vehicle:
MY99 GF4 JDM 6spd
NF Performance

Default

Quote:
Originally Posted by XanRules View Post
Oh man. My engine build is mostly me buying parts, laying them out, bouncing ideas off people, and hoping everyone else knows what I'm talking about.
I'm gathering my parts as we speak. I have a '05 Legacy NA upper manifold coming in this Wednesday to go over '06 WRX TGVs. JDM 12mm oil pump sits next to my pillow. I'll be picking it up from the Dealer this Thursday morning before taking one of the ported STi head to get flow tested. Should be an awesome morning!!! I'm excited to see how horrible I did on my port job with that head.
FuJi K is offline   Reply With Quote
Old 04-13-2009, 11:51 PM   #7
XanRules
NASIOC Supporter
 
Member#: 157348
Join Date: Aug 2007
Chapter/Region: NWIC
Location: Rustletech Headquarters
Vehicle:
1996 JNCO Jorts
Stonewashed Denim

Default

Here's my insane project.
http://forums.nasioc.com/forums/show....php?t=1707369

Twin Turbo 2.5L.
XanRules is offline   Reply With Quote
Old 04-13-2009, 11:55 PM   #8
Team Scream
Scooby Specialist
 
Member#: 121532
Join Date: Jul 2006
Chapter/Region: SCIC
Vehicle:
2006 FXT/STi 6MT
01 Aerosim GC8 Coupe

Default

Quote:
Originally Posted by XanRules View Post
This looks like it would be really useful. I don't know how it works.
I am still working on making it a little better, with instructions for example

Anyway, you fill in all of the information in the yellow areas.
The spreadsheet will do the calculations for compression ratio, and if I am correct in my formulas it uses everything to give you true static compression ratio with one exception, and that is it does not account for the volume between the top ring and the top lip of the piston.
I am going to add that cell so that the volume there will be calculated.
For now, it uses the top lip of the piston as the reference.....if that makes any sense.

The other items that are not used in calculations, are just part of the build sheet, and there so you can document the build completely.

If I missed anything, please chime in and let me know.

Also, the numbers that are already in some of the yellow cells is just data I input as an example.
Delete it all before you start your sheet.

DO NOT DELETE any of the numbers which are NOT in the yellow cells.....
I have not figured out how to lock those cells so the formulas wont get deleted.

****EDIT**** just figured out how to lock specific cells, got it done, download the newest version and toss the older one to keep you out of trouble.

Last edited by Team Scream; 04-15-2009 at 09:01 PM.
Team Scream is offline   Reply With Quote
Old 04-14-2009, 01:56 PM   #9
Team Scream
Scooby Specialist
 
Member#: 121532
Join Date: Jul 2006
Chapter/Region: SCIC
Vehicle:
2006 FXT/STi 6MT
01 Aerosim GC8 Coupe

Default

Ok I updated the sheet quite a bit.
I added a formula that calculates the valve stem to guide clearance and cleaned up a few other areas.
I really need a builder to look this thing over and tell me if it will work for them.
Thanks.
Link is in the first post.
Team Scream is offline   Reply With Quote
Old 04-14-2009, 02:49 PM   #10
methaddict
Scooby Specialist
 
Member#: 159738
Join Date: Sep 2007
Chapter/Region: SCIC
Location: Socal
Vehicle:
2004 WRB STi
Full Race TS, BW 8374 EFR

Default

Pretty cool Dauv. This would help us, a novice like me in understanding all of the important specifications that go into controlling the tolerances of an engine. Even if you're not the actual builder this gives us a guide instead of trusting that the machinist knows everything about a subaru motor. Still as a consumer you still have to be diligent and research the manufacturer's recommended clearances and go over it with your machinist. These recommended clearances will also be in a range. There are different effects of having tighter or looser clearances which should be determined by the your goals of your build and the predominant use of your car.
methaddict is offline   Reply With Quote
Old 04-14-2009, 07:23 PM   #11
SlickRick51586
Scooby Newbie
 
Member#: 66735
Join Date: Jul 2004
Chapter/Region: South East
Location: Parkland, Florida.
Vehicle:
2004 WRX
PSM

Default

for the total displacement formula you have

=C62+D62+E62+H62

should it not be:

=C62+D62+E62+F62

I'm running open office so it could be an issue on my side.
SlickRick51586 is offline   Reply With Quote
Old 04-14-2009, 11:43 PM   #12
Team Scream
Scooby Specialist
 
Member#: 121532
Join Date: Jul 2006
Chapter/Region: SCIC
Vehicle:
2006 FXT/STi 6MT
01 Aerosim GC8 Coupe

Default

Quote:
Originally Posted by SlickRick51586 View Post
for the total displacement formula you have

=C62+D62+E62+H62

should it not be:

=C62+D62+E62+F62

I'm running open office so it could be an issue on my side.
You are absolutely correct!
missed that one.
IT is fixed now, just re-download it and you will be good.
Team Scream is offline   Reply With Quote
Old 04-15-2009, 03:25 AM   #13
howfast?
Scooby Specialist
 
Member#: 102027
Join Date: Dec 2005
Chapter/Region: SCIC
Location: oc
Vehicle:
BugI Tsx retro lamps
for sale not listed pm me

Subaru Stars

Nice Dauv that build sheet is sick! I can't wait till I get to start filling it in
howfast? is offline   Reply With Quote
Old 04-15-2009, 06:02 AM   #14
jaxscuby
Sammo Hung
Moderator
 
Member#: 10613
Join Date: Sep 2001
Chapter/Region: South East
Location: F L O R I D A
Vehicle:
2002 USDM WRX
WRB

Default

which spread sheet?
xlsx extension?
jaxscuby is offline   Reply With Quote
Old 04-15-2009, 11:45 AM   #15
kevinh211
Scooby Specialist
 
Member#: 56297
Join Date: Mar 2004
Chapter/Region: Tri-State
Location: Long Island NY
Vehicle:
2004 STi HTA Green
28psi, MSPT Tuned

Default

very cool! i am definitely going to use this.
what is the password so i can unprotect it and make some chances my self?
kevinh211 is offline   Reply With Quote
Old 04-15-2009, 02:31 PM   #16
bucket7788
Scooby Specialist
 
Member#: 124263
Join Date: Aug 2006
Chapter/Region: MAIC
Location: Now with DB Super 16g and WI!
Vehicle:
2004 WRX Wagon
RomRaider + UTEC Tuned

Default

Quote:
Originally Posted by jaxscuby View Post
which spread sheet?
xlsx extension?
I'm wondering the same thing. Excel won't open it for me.

Buck
bucket7788 is offline   Reply With Quote
Old 04-15-2009, 02:37 PM   #17
mick_the_ginge
Citizen Mick
 
Member#: 27646
Join Date: Oct 2002
Chapter/Region: NWIC
Location: Portland, Oregon
Vehicle:
2003 Sleeved 2.5
Oil Dry Sump Goodness

Default

xlsx is Office 2007 and above
mick_the_ginge is offline   Reply With Quote
Old 04-15-2009, 02:49 PM   #18
Homemade WRX
Scooby Guru
 
Member#: 33782
Join Date: Mar 2003
Chapter/Region: MAIC
Location: 3MI Racing LLC
Vehicle:
96 bastard child
search FIRST, then PM!!!

Default

yeah, I had to use my laptop to open it up...my desktop is still 03 format.

It looks pretty good to me but I didn't spend a lot of time poking with it. I'll have to do that later.

I must say, the one I made isn't nearly as 'pretty' with colors and all the borders. Gives me ideas that I've been needing to do. I need to make mine more 'professional' and print friendly.

Thanks for the motivation

Last edited by Homemade WRX; 04-15-2009 at 02:54 PM.
Homemade WRX is offline   Reply With Quote
Old 04-15-2009, 02:57 PM   #19
~snowman~
Scooby Newbie
 
Member#: 207011
Join Date: Mar 2009
Location: In the clouds.
Default

Thanks Team Scream!
~snowman~ is offline   Reply With Quote
Old 04-15-2009, 03:05 PM   #20
kevinh211
Scooby Specialist
 
Member#: 56297
Join Date: Mar 2004
Chapter/Region: Tri-State
Location: Long Island NY
Vehicle:
2004 STi HTA Green
28psi, MSPT Tuned

Default

I got it open with Office 2003, but their was some update through windows i had to do to read the newier file types.
kevinh211 is offline   Reply With Quote
Old 04-15-2009, 05:27 PM   #21
Team Scream
Scooby Specialist
 
Member#: 121532
Join Date: Jul 2006
Chapter/Region: SCIC
Vehicle:
2006 FXT/STi 6MT
01 Aerosim GC8 Coupe

Default

Sorry guys, as soon as I have a minute I will save it as an Office 2003 file as well so those that are on earlier versions can play with it.
I am at work right now and do not have Office on this particular machine.
I should have thought of that.....
Team Scream is offline   Reply With Quote
Old 04-15-2009, 08:59 PM   #22
Team Scream
Scooby Specialist
 
Member#: 121532
Join Date: Jul 2006
Chapter/Region: SCIC
Vehicle:
2006 FXT/STi 6MT
01 Aerosim GC8 Coupe

Default

Ok there are now 2 versions.
The first one is for Office 2007 or newer users
The 2nd one is for Office 2003 or newer users.

Both in the first post.
Team Scream is offline   Reply With Quote
Old 04-16-2009, 12:15 AM   #23
bucket7788
Scooby Specialist
 
Member#: 124263
Join Date: Aug 2006
Chapter/Region: MAIC
Location: Now with DB Super 16g and WI!
Vehicle:
2004 WRX Wagon
RomRaider + UTEC Tuned

Default

Thanks! I guess I should pry my wallet open for a newer version of Office.
bucket7788 is offline   Reply With Quote
Old 04-16-2009, 01:47 AM   #24
Team Scream
Scooby Specialist
 
Member#: 121532
Join Date: Jul 2006
Chapter/Region: SCIC
Vehicle:
2006 FXT/STi 6MT
01 Aerosim GC8 Coupe

Default

Quote:
Originally Posted by bucket7788 View Post
Thanks! I guess I should pry my wallet open for a newer version of Office.
Or just download OpenOffice for free and run with it...!
Works like a charm for those that can live without Office.
Team Scream is offline   Reply With Quote
Old 04-16-2009, 01:06 PM   #25
CoolRex
*** Banned ***
 
Member#: 85813
Join Date: Apr 2005
Chapter/Region: South East
Location: Myrtle Beach, SC
Vehicle:
2002 E46 M3
2006 RC51

Default

Nice sheet.
CoolRex is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Engine build questions? Engine Builders help!! awdeclipseguy Built Motor Discussion 7 01-03-2010 03:54 AM
Looking for information on engine build CUNNINGHAM Normally Aspirated with bolt-on Forced Induction Powertrain 1 06-09-2002 04:19 PM
anyone have one of those dyno or engine build up software kits? funscooby Motorsports 0 01-17-2002 01:44 AM
SomeTorque specifications needed for engine build. DJIMPREZA Technical Forum Archive 2 09-20-2000 11:51 AM
Tech Section Update - SOHC Engine Build Trey Technical Forum Archive 27 07-04-2000 12:26 AM


All times are GMT -4. The time now is 09:45 AM.


Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Powered by Searchlight © 2014 Axivo Inc.
Copyright ©1999 - 2014, North American Subaru Impreza Owners Club, Inc.