Updated Valve event / DCR / SCR / Header length spreadsheet
#1
6600 rpm clutch dump of death Administrator
Thread Starter
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.
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.
Last edited by J-Rod; 09-15-2009 at 01:58 PM.
#3
LS1 Tech Administrator
iTrader: (14)
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.
Thanks. Good homework.
__________________
2013 Corvette Grand Sport A6 LME forged 416, Greg Good ported TFS 255 LS3 heads, 222/242 .629"/.604" 121LSA Pat G blower cam, ARH 1 7/8" headers, ESC Novi 1500 Supercharger w/8 rib direct drive conversion, 747rwhp/709rwtq on 93 octane, 801rwhp/735rwtq on race fuel, 10.1 @ 147.25mph 1/4 mile, 174.7mph Half Mile.
2016 Corvette Z51 M7 Magnuson Heartbeat 2300 supercharger, TSP LT headers, Pat G tuned, 667rwhp, 662rwtq, 191mph TX Mile.
2009.5 Pontiac G8 GT 6.0L, A6, AFR 230v2 heads. 506rwhp/442rwtq. 11.413 @ 121.29mph 1/4 mile, 168.7mph TX Mile
2000 Pewter Ram Air Trans Am M6 heads/cam 508 rwhp/445 rwtq SAE, 183.092 TX Mile
2022 Cadillac Escalade 6.2L A10 S&B CAI, Corsa catback.
2023 Corvette 3LT Z51 soon to be modified.
Custom LSX tuning in person or via email press here.
2013 Corvette Grand Sport A6 LME forged 416, Greg Good ported TFS 255 LS3 heads, 222/242 .629"/.604" 121LSA Pat G blower cam, ARH 1 7/8" headers, ESC Novi 1500 Supercharger w/8 rib direct drive conversion, 747rwhp/709rwtq on 93 octane, 801rwhp/735rwtq on race fuel, 10.1 @ 147.25mph 1/4 mile, 174.7mph Half Mile.
2016 Corvette Z51 M7 Magnuson Heartbeat 2300 supercharger, TSP LT headers, Pat G tuned, 667rwhp, 662rwtq, 191mph TX Mile.
2009.5 Pontiac G8 GT 6.0L, A6, AFR 230v2 heads. 506rwhp/442rwtq. 11.413 @ 121.29mph 1/4 mile, 168.7mph TX Mile
2000 Pewter Ram Air Trans Am M6 heads/cam 508 rwhp/445 rwtq SAE, 183.092 TX Mile
2022 Cadillac Escalade 6.2L A10 S&B CAI, Corsa catback.
2023 Corvette 3LT Z51 soon to be modified.
Custom LSX tuning in person or via email press here.
#5
6600 rpm clutch dump of death Administrator
Thread Starter
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.
Trending Topics
#11
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...
#13
TECH Fanatic
iTrader: (14)
Join Date: Dec 2003
Location: Salisbury,MD
Posts: 1,729
Likes: 0
Received 0 Likes
on
0 Posts
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.
#15
TECH Senior Member
iTrader: (18)
Join Date: Jun 2002
Location: NW Houston, TX
Posts: 10,036
Likes: 0
Received 0 Likes
on
0 Posts
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?
#16
6600 rpm clutch dump of death Administrator
Thread Starter
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...
I'm still working on the bottom of the sheet where we get into velocity/runner length/etc...
#17
8 Second Club
iTrader: (3)
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.
#18
TECH Addict
iTrader: (11)
Join Date: Jan 2003
Location: Minnesota Corn Fields
Posts: 2,452
Likes: 0
Received 10 Likes
on
9 Posts
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?
#19
TECH Fanatic
iTrader: (2)
Join Date: May 2003
Location: Missouri
Posts: 1,123
Likes: 0
Received 0 Likes
on
0 Posts
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.
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.