Updated Valve event / DCR / SCR / Header length spreadsheet - LS1TECH - Camaro and Firebird Forum Discussion



Advanced Engineering Tech For the more hardcore LS1TECH residents
Sponsored by:
Sponsored by:

Updated Valve event / DCR / SCR / Header length spreadsheet

Reply
 
Thread Tools Search this Thread
Old 09-17-2004, 10:14 AM   #1
6600 rpm clutch dump of death Administrator
Thread Starter
 
J-Rod's Avatar
 
Join Date: Dec 2001
Location: Texas
Posts: 4,958
Default Updated Valve event / DCR / SCR / Header length spreadsheet

I have fixed a nagging error in the VE/DCR calculator that I needed to look at for a long time. I needed to convert angle to radians for excel to calculate properly. I had accidentally pointed a cell at the rod length instead of stroke, and I was missing a bracket that was causing a square root to be taken early (threw off the order of operation). So, anyhow, the sheet is broken up into several sections.


EDIT : [link removed, site down] I have uploaded it here as a .zip file

This is my quick and dirty VE calculator sheet with a few add ons:

Sheet 1 - compare two cams (forum post) this was an attempt to put _ in there to keep the spacing right on when posting specs on the forum. I have found a better way now is to use a fixed width font like courier which does the same thing without all the ___. This sheet compares two cams side by side so you can see how they stack up.

Sheet 2 - Compare 4 cams. No underscores in this one. It simply compares 4 cams instead of 2.

Sheet 3 - VE's. Shows where 93 pony was putting a lot of his cams compared to other folks. This was realy there as a reference for me when looking over some cams.

Sheet 4 - Single Cam. Valve Events for one cam.

Sheet 5 - Compare two cams. Compare the valve events, etc... for two cams.

Sheet 6 - Quick and Dirty Cam/SCR/DCR Calculator Spreadsheet. This sheet takes all the cam math and combines it with a bunch of other engine math like DCR and SCR, along with header length math to help you in optimizing your combo, or to give you the details on your combo.

Sheet 7 - Compare DCR. This allows you to compare two motor combos to look at Valve events, dynamic compression ratio, and header length and see where you want to be, or what you're going to end up at with a change...


I'll add sections as they warrant. Anything folks want added, or math they have / want to see.
Attached Files
File Type: txt VE calculator.txt (56.5 KB, 3936 views)

Last edited by J-Rod; 09-15-2009 at 01:58 PM.
J-Rod is offline   Reply With Quote
Old 09-17-2004, 10:57 AM   #2
TECH Senior Member
 
CHRISPY's Avatar
 
Join Date: Nov 2001
Posts: 10,348
Default

AWESOME MAN!

Thanks for doing this up!

CHRISPY is offline   Reply With Quote
Old 09-17-2004, 11:03 AM   #3
LS1 Tech Administrator
iTrader: (14)
 
Patrick G's Avatar
 
Join Date: Nov 2001
Location: Victoria, TX
Posts: 8,238
Default

I dig this stuff. Very interesting. Neat ways you can manipulate various cam grinds to give you the same desired intake closing points and overlap. It's just a matter of moving things around. I will bookmark this so I can use it to better choose my next cam.

Thanks. Good homework.
Patrick G is offline   Reply With Quote
Old 09-17-2004, 03:55 PM   #4
Super Moderator
iTrader: (8)
 
Reckless's Avatar
 
Join Date: Nov 2001
Location: Cumming, GA
Posts: 9,944
Default

Why does it keep asking for a user name and password? I tried to save it but could not
Reckless is offline   Reply With Quote
Old 09-17-2004, 09:28 PM   #5
6600 rpm clutch dump of death Administrator
Thread Starter
 
J-Rod's Avatar
 
Join Date: Dec 2001
Location: Texas
Posts: 4,958
Default

Quote:
Originally Posted by Reckless
Why does it keep asking for a user name and password? I tried to save it but could not

I don't know. I just tried D/l ing and it worked fine. I can mail it to you if you can't download it.
J-Rod is offline   Reply With Quote
Old 09-18-2004, 08:34 AM   #6
Super Moderator
iTrader: (8)
 
Reckless's Avatar
 
Join Date: Nov 2001
Location: Cumming, GA
Posts: 9,944
Default

OK, works now. I was opening it, and then trying to save it, and it asks for the info.
Reckless is offline   Reply With Quote
Old 10-17-2005, 12:11 PM   #7
LS1Tech Co-Founder
iTrader: (38)
 
Nine Ball's Avatar
 
Join Date: Nov 2001
Location: Houston, TX
Posts: 32,995
Default

TTT for new forum
Nine Ball is offline   Reply With Quote
Old 10-18-2005, 01:42 AM   #8
TECH Senior Member
iTrader: (14)
 
ArcticZ28's Avatar
 
Join Date: Jun 2004
Location: Alexandria, VA
Posts: 5,112
Default

Wow, that spreadsheet is pretty damn useful. Any word on whether all of those formulas still apply with the changing times (changing mindset to bigger bore engines, bigger cams, etc).
ArcticZ28 is offline   Reply With Quote
Old 11-16-2005, 11:16 AM   #9
LS1 Tech Administrator
iTrader: (14)
 
Patrick G's Avatar
 
Join Date: Nov 2001
Location: Victoria, TX
Posts: 8,238
Default

This is still the best spreadsheet I've found for cam timing, and calculating SCR and DCR. Thanks J-Rod.
Patrick G is offline   Reply With Quote
Old 11-16-2005, 11:32 AM   #10
Launching!
 
Join Date: Dec 2004
Location: Florida
Posts: 291
Default

its saying my 468 needs a 2.7" header tube. something tells me its not quite accurate on that one.
TrendSetter is offline   Reply With Quote
Old 11-18-2005, 08:38 PM   #11
TECH Regular
 
Join Date: Oct 2005
Posts: 430
Default

Great to have all this stuff in one place! Most of the results approach my 'reality check' values, with the exception of intake runner length. The results (e.g. 5"), are about 1/3 of what they should be. I looked in Bell's book, but the formula must be from elsewhere...
MadBill is offline   Reply With Quote
Old 11-19-2005, 03:46 AM   #12
Fast Mofo
iTrader: (18)
 
DONAIMIAN's Avatar
 
Join Date: Jun 2002
Location: NW Houston, TX
Posts: 10,036
Default

Does this account for the piston being out of the hole or not. I remember a while back I was trying to play around with excel to get it to do so, but I suck in excel.
DONAIMIAN is offline   Reply With Quote
Old 11-19-2005, 11:42 AM   #13
TECH Fanatic
iTrader: (14)
 
Join Date: Dec 2003
Location: Salisbury,MD
Posts: 1,729
Default

I didn't have a problem with the piston comming out of the whole but for some reason in mine it does not look at the piston volume no matter what you enter. My solution so far has just been to add the dish and combustion chamber volume (or subtract if you have a dome piston) and go about it that way. From the calculators standpoint I don't see why this would alter the numbers in comparison to correctly entering piston dish and combustion chamber sizes in the appropriate places.
DAPSUPRSLO is offline   Reply With Quote
Old 11-19-2005, 05:24 PM   #14
TECH Veteran
iTrader: (21)
 
Join Date: Apr 2003
Location: Shreveport, LA
Posts: 4,049
Default

Do you have to have Excel to run this program? For some reason I don't have it in my computer and this sheet won't work. If so, where do I get it?
Beast96Z is offline   Reply With Quote
Old 11-19-2005, 06:48 PM   #15
Fast Mofo
iTrader: (18)
 
DONAIMIAN's Avatar
 
Join Date: Jun 2002
Location: NW Houston, TX
Posts: 10,036
Default

Quote:
Originally Posted by Beast96Z
Do you have to have Excel to run this program? For some reason I don't have it in my computer and this sheet won't work. If so, where do I get it?
find someone who has microsoft office, or buy microsoft office (too expensive if you dont used atleast part of it on a daily basis) You can also look for it on a file sharing program.
DONAIMIAN is offline   Reply With Quote
Old 12-22-2005, 01:36 PM   #16
6600 rpm clutch dump of death Administrator
Thread Starter
 
J-Rod's Avatar
 
Join Date: Dec 2001
Location: Texas
Posts: 4,958
Default

I believe the piston volume issue is fixed. I had been playing around with one part of the sheet and had fixed values instead of looking at that field. When you change it now, it works. If anyone has a problem, or has other math, etc... you want me to add, post it up, and I'll try to integrate it.

I'm still working on the bottom of the sheet where we get into velocity/runner length/etc...
J-Rod is offline   Reply With Quote
Old 04-07-2006, 09:50 AM   #17
8 Second Club
iTrader: (3)
 
1fastWS6's Avatar
 
Join Date: Apr 2002
Location: Missouri
Posts: 1,461
Default

I was running the DCR on a solid roller and have a question. For the advertised duration numbers, they are taken at .020" not .006" for a solid roller according to Cam Motion. They use .006" for hyd. rollers. Will this affect the output of the spreadsheet? Cause I'm getting some bizarre numbers for header length/primary size and a seemingly low DCR. Thanks.
1fastWS6 is offline   Reply With Quote
Old 04-19-2006, 09:11 AM   #18
TECH Addict
iTrader: (11)
 
No Juice's Avatar
 
Join Date: Jan 2003
Location: Minnesota Corn Fields
Posts: 2,322
Default

How do we find the specs for a particular cam at .006 and .200 so I can use this spreadsheet? Also does it matter what type of lobe it has, is it important in order to use this?
No Juice is offline   Reply With Quote
Old 04-22-2006, 04:08 PM   #19
TECH Fanatic
iTrader: (2)
 
matts22's Avatar
 
Join Date: May 2003
Location: Missouri
Posts: 1,123
Default

Great stuff guys...

I did notice a problem though. When you go under the tab "Compare DCR" there is no formula in cells B42 and G42, clearance volume. This should be the same as in B42 of the "DCR" tab, which is =SUM(0.7853982*(B17^2)*B21) (and for the G column, just substitute G for B in that formula.

If this isn't fixed, it will throw off the SCR and DCR values in this tab.
matts22 is offline   Reply With Quote
Old 05-08-2006, 10:22 AM   #20
Staging Lane
 
Join Date: Jan 2006
Posts: 67
Default

Which book did you pull these equations from?
chirp_fourth is offline   Reply With Quote
Reply

Related Topics
Thread Thread Starter Forum Replies Last Post
Opinions on DCR and SCR mamead Generation III Internal Engine 34 03-13-2011 10:52 PM
Which Gaskets?????? Dmoney Generation IV Internal Engine 1 06-06-2007 12:47 AM
Intake Manifold Runner lenght Calculations sheet 11sHSV Advanced Engineering Tech 4 02-25-2007 06:15 AM
Modified & Simplified VE Calculator! - I need some input! pianoprodigy Generation III Internal Engine 50 11-01-2006 09:49 AM
Camshaft Discussion part II J-Rod Advanced Engineering Tech 409 10-17-2005 12:12 PM


Tags
bogart, calculations, calculator, calulator, cam, camshaft, d10, dcr, event, events, fbody, som, spreadsheet, timing, valve

Thread Tools Search this Thread
Search this Thread:

Advanced Search

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
Trackbacks are Off
Pingbacks are Off
Refbacks are Off



All times are GMT -5. The time now is 09:34 AM.


 
  • Ask a Question
    Get answers from community experts
Question Title:
Description:
Your question will be posted in: