Modified & Simplified VE Calculator! - I need some input!
#1
Thread Starter
TECH Apprentice
iTrader: (1)
Joined: Apr 2005
Posts: 315
Likes: 0
From: Tampa Bay Area, FL
Modified & Simplified VE Calculator! - I need some input!
In an effort to be able to make DCR calculations on my own and to allow others to do the same, I modified and simplified the Excel Spreadsheet that is available on the forum called VE Calculator.xls.
You will notice that most cells are not editable because those values should not be changed since they are calculated. This keeps someone from accidentally changing something that does not need to be changed.
I got most of my statistics either from the original VE Calculator or from this page http://www.smokemup.com/tech/ls1.php
Also, I got my information for duration @ .006 and .200 from this post: https://ls1tech.com/forums/showpost....3&postcount=16
I can easily modify if those values are not correct. Also, I can add more cam grinds to the list as well. I just need the specs.
I'm certainly open to suggestions. A few things that I was unsure about was head chamber volume which seems to conflict on that link I provided. Additionally, I'm not sure what the average deck height would be. I was once told to assume .007 out of the hole (which would be -.007 for our calculations), but someone correct me if I'm wrong on that.
This spreadsheet can eventually be modified so that the person can select what head castings they have which will automatically select the chamber volume. Also, it could easily be modified to include not only LS1s but any other factory displacement engine simply by changing a drop down. I think this is important so that people can experiment with different cam selections since many people are only interested in doing a "cam only" setup (at least at first).
Also, this could be used to compile a list of popular cams on various LSAs and you could compare the DCR and swap out the cam by simply choosing it from a drop-down menu.
The possibilities are practically endless. I love playing with Excel, especially when it involves car stuff.
Anyways, you can download the file here: http://www.alantripp.com/VE Calculat...igy Lookup.xls
Please post any comments, concerns, suggestions, etc.
-Alan
You will notice that most cells are not editable because those values should not be changed since they are calculated. This keeps someone from accidentally changing something that does not need to be changed.
I got most of my statistics either from the original VE Calculator or from this page http://www.smokemup.com/tech/ls1.php
Also, I got my information for duration @ .006 and .200 from this post: https://ls1tech.com/forums/showpost....3&postcount=16
I can easily modify if those values are not correct. Also, I can add more cam grinds to the list as well. I just need the specs.
I'm certainly open to suggestions. A few things that I was unsure about was head chamber volume which seems to conflict on that link I provided. Additionally, I'm not sure what the average deck height would be. I was once told to assume .007 out of the hole (which would be -.007 for our calculations), but someone correct me if I'm wrong on that.
This spreadsheet can eventually be modified so that the person can select what head castings they have which will automatically select the chamber volume. Also, it could easily be modified to include not only LS1s but any other factory displacement engine simply by changing a drop down. I think this is important so that people can experiment with different cam selections since many people are only interested in doing a "cam only" setup (at least at first).
Also, this could be used to compile a list of popular cams on various LSAs and you could compare the DCR and swap out the cam by simply choosing it from a drop-down menu.
The possibilities are practically endless. I love playing with Excel, especially when it involves car stuff.
Anyways, you can download the file here: http://www.alantripp.com/VE Calculat...igy Lookup.xls
Please post any comments, concerns, suggestions, etc.
-Alan
Last edited by pianoprodigy; 05-24-2006 at 04:53 PM.
#2
Very slick spreadsheet Alan. Makes calculating very easy. Nice drop down menu of Comp lobes. The only issue I see is the calculations for SCR and DCR. They vary quite a bit (especially DCR) from J-Rod's quick and dirty spreadsheet calculator. If you're not using those formulas, I would recommend that you switch. Using your calculations put my DCR at 9.07:1. It's not that high. It's probably closer to 8.7 or 8.8:1.
Check the math between the two spreadsheets. I trust J-Rod's math more than any other spreasheet I've seen. Again, make a few tweaks to this and I'll make it a sticky!
Nice work. You are definitely an excel wizard!
Check the math between the two spreadsheets. I trust J-Rod's math more than any other spreasheet I've seen. Again, make a few tweaks to this and I'll make it a sticky!
Nice work. You are definitely an excel wizard!
__________________
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.
#3
Not bad, but the only thing I don't like is that you have only the four lobe types that basically determines your duration @ .006. I tried all four lobe styles and it didn't match my cam card for my TR230/224. It was off by a few numbers @.006 and @ .200
I really don't know which lobe style Thunder uses. I would like to be able to enter in my own known .006 duration.
Anyways this threw off my final DCR by quite a bit comparing it this; https://ls1tech.com/forums/generation-iii-internal-engine/504665-gasket-choice-quick-help.html
I really don't know which lobe style Thunder uses. I would like to be able to enter in my own known .006 duration.
Anyways this threw off my final DCR by quite a bit comparing it this; https://ls1tech.com/forums/generation-iii-internal-engine/504665-gasket-choice-quick-help.html
#4
Thread Starter
TECH Apprentice
iTrader: (1)
Joined: Apr 2005
Posts: 315
Likes: 0
From: Tampa Bay Area, FL
Ok, then. We have to figure out what figures are wrong. I need someone to verify these specs first before I change anything else.
.006, .050., .200
XE = +53, 0, -82
XE-R = +49, 0, -79
XFI = +50, 0, -75
LSK = +50, 0, -74
Patrick, the formula is the same as J-Rod's. There must be something wrong in the durations.
.006, .050., .200
XE = +53, 0, -82
XE-R = +49, 0, -79
XFI = +50, 0, -75
LSK = +50, 0, -74
Patrick, the formula is the same as J-Rod's. There must be something wrong in the durations.
#7
Originally Posted by pianoprodigy
Ok, then. We have to figure out what figures are wrong. I need someone to verify these specs first before I change anything else.
.006, .050., .200
XE = +53, 0, -82
XE-R = +49, 0, -79
XFI = +50, 0, -75
LSK = +50, 0, -74
Patrick, the formula is the same as J-Rod's. There must be something wrong in the durations.
.006, .050., .200
XE = +53, 0, -82
XE-R = +49, 0, -79
XFI = +50, 0, -75
LSK = +50, 0, -74
Patrick, the formula is the same as J-Rod's. There must be something wrong in the durations.
Trending Topics
#10
Thread Starter
TECH Apprentice
iTrader: (1)
Joined: Apr 2005
Posts: 315
Likes: 0
From: Tampa Bay Area, FL
Originally Posted by SideStep
66.67 is what I have always been told also...
I tried going on Comps website to see if I could find the information. The only thing I could find was this: http://compcams.com/Technical/Catalo...obeCatalog.pdf
I can find what seems to be XE grinds as well as XE-R grinds; however, I don't see XFI or LSK anywhere. Any clues?
#11
I can open the spreadsheet fine but I have no drop down menu choice for the Lobes. I also have this "#VALUE!" in all the .006 and .200 sections of the valve event area and also for the DCR. My SCR comes out right though .
Dan
Dan
#12
Thread Starter
TECH Apprentice
iTrader: (1)
Joined: Apr 2005
Posts: 315
Likes: 0
From: Tampa Bay Area, FL
Originally Posted by DanZ28
I can open the spreadsheet fine but I have no drop down menu choice for the Lobes. I also have this "#VALUE!" in all the .006 and .200 sections of the valve event area and also for the DCR. My SCR comes out right though .
Dan
Dan
Did you first select the cell? When you do, the drop down should appear at the right edge of the cell. What version of Excel are you using?
-Alan
#15
Again, I'm a moron, lol! Once I selected the Lobe, the other data showed up.
Sorry about that!
I really like this calculator and how simple it is to use (now that a few brain cells work).
Sorry about that!
I really like this calculator and how simple it is to use (now that a few brain cells work).
#16
Originally Posted by pianoprodigy
I can find what seems to be XE grinds as well as XE-R grinds; however, I don't see XFI or LSK anywhere. Any clues?
#17
Thread Starter
TECH Apprentice
iTrader: (1)
Joined: Apr 2005
Posts: 315
Likes: 0
From: Tampa Bay Area, FL
Originally Posted by SideStep
Here is this if it helps.... top half is XE, bottom half is XE-R
I'm going to have to take all of those values and do a lookup. Not a big deal. I have 6 hours of class today, so I have plenty of time.
SideStep or anyone else,
Could you see if you could get me the exact same chart for the XFI and LSK lobes? Also, if you would like any other lobes added, I will need the same chart setup (Thunder, Comp solid roller, CamMotion, etc).
Also, it would be even cooler to allow the person to input the duration and the lift and let the spreadsheet figure out which type of lobe the cam has (since it can be different on Intake and Exhaust).
Wow, endless possibilities.
#18
Comp Cams LSK lobes
Lobe#, Dur. @ .006", .050", .200", & Lift w/1.7 rocker
2124 265 215 142 .629"
2125 269 219 145 .632"
2126 273 223 149 .636"
2127 277 227 153 .639"
2128 281 231 156 .643"
2129 285 235 160 .646"
2130 289 239 164 .649"
2131 293 243 168 .653"
2132 297 247 171 .656"
2133 301 251 175 .660"
2134 305 255 179 .663"
2135 309 259 183 .663"
2136 313 263 186 .663"
Lobe#, Dur. @ .006", .050", .200", & Lift w/1.7 rocker
2124 265 215 142 .629"
2125 269 219 145 .632"
2126 273 223 149 .636"
2127 277 227 153 .639"
2128 281 231 156 .643"
2129 285 235 160 .646"
2130 289 239 164 .649"
2131 293 243 168 .653"
2132 297 247 171 .656"
2133 301 251 175 .660"
2134 305 255 179 .663"
2135 309 259 183 .663"
2136 313 263 186 .663"
#19
Good work. Yours looks prettier than mine
Maybe you can give some excel lessons sometime
Anyhow, thanks for taking the time to help the forum out. We can always use input and improvement to any of these things. I still have some stuff to add to mine. I'm working on trying to integrate calculate intake manifold length, etc...
Also looking at how to use it to predict more optimal valve events. I've been playing with Dplot trying to make some more of this more digestable.
I have a feeling there is another long thread around the corner.
Anyhow, great work!
Maybe you can give some excel lessons sometime
Anyhow, thanks for taking the time to help the forum out. We can always use input and improvement to any of these things. I still have some stuff to add to mine. I'm working on trying to integrate calculate intake manifold length, etc...
Also looking at how to use it to predict more optimal valve events. I've been playing with Dplot trying to make some more of this more digestable.
I have a feeling there is another long thread around the corner.
Anyhow, great work!
#20
Thread Starter
TECH Apprentice
iTrader: (1)
Joined: Apr 2005
Posts: 315
Likes: 0
From: Tampa Bay Area, FL
Originally Posted by fast98
Comp Cams LSK lobes
Lobe#, Dur. @ .006", .050", .200", & Lift w/1.7 rocker
2124 265 215 142 .629"
2125 269 219 145 .632"
2126 273 223 149 .636"
2127 277 227 153 .639"
2128 281 231 156 .643"
2129 285 235 160 .646"
2130 289 239 164 .649"
2131 293 243 168 .653"
2132 297 247 171 .656"
2133 301 251 175 .660"
2134 305 255 179 .663"
2135 309 259 183 .663"
2136 313 263 186 .663"
Lobe#, Dur. @ .006", .050", .200", & Lift w/1.7 rocker
2124 265 215 142 .629"
2125 269 219 145 .632"
2126 273 223 149 .636"
2127 277 227 153 .639"
2128 281 231 156 .643"
2129 285 235 160 .646"
2130 289 239 164 .649"
2131 293 243 168 .653"
2132 297 247 171 .656"
2133 301 251 175 .660"
2134 305 255 179 .663"
2135 309 259 183 .663"
2136 313 263 186 .663"