pianoprodigy

iTrader: (1)

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

Patrick G

iTrader: (14)

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!

Zick

iTrader: (18)

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

pianoprodigy

iTrader: (1)

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.

oange ss

iTrader: (50)

Thunder Racing uses a different lobe that is kinda in between an XE and XER..also the standard for LS1 deck height is -.008 not -.001....but a very cool spreadsheet nontheless

speedracer5532

iTrader: (8)

How about adding comps solid roller specs?

No Juice

iTrader: (11)

Yeah I made that post asking someone to verify these but no response

PREDATOR-Z

Stock chambers on LS1 are 67.3 ?/
I was under the impression they were 66.67 (I never measured though)?

SideStep

66.67 is what I have always been told also...

pianoprodigy

iTrader: (1)

That link I posted has conflicting info. One portion says "Stock LS1 Heads" and lists then as 66.67. Then, down the page, it says "General Specifications" and lists "Cylinder Head Specifications" then "Chamber Volume" as 67.3.

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?

DanZ28

iTrader: (5)

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

pianoprodigy

iTrader: (1)

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

DanZ28

iTrader: (5)

I tried selecting the cell, but no drop down appears for me. I use excell 2003.

Dan

DanZ28

iTrader: (5)

Never mind, I'm an idiot and can't read. I was selecting the the cell in the chart insted of the one high lighted in red.

What about the DCR and VE data not showing?

DanZ28

iTrader: (5)

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

SideStep

Here is this if it helps.... top half is XE, bottom half is XE-R

pianoprodigy

iTrader: (1)

Ok, this is going to get more complicated, but I can handle it. It seems that the simple +XX or -XX will not work since the numbers do not always change equally (for instance an increase of 2 in duration at .050 does not always equal an increase of 2 in duration at .006 or .200).

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.

fast98

iTrader: (16)

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"

J-Rod

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!

pianoprodigy

iTrader: (1)

Hmm, I see that the .050 durations are odd numbers (uncharacteristic). It seems that most people talk about cams on the even numbers (Patrick G comes to mind). I think I'll just enter the .050 durations +1 (219 would be 220, 223 would be 224). Anyone see a problem with this? Especially since those numbers aren't critical to the calculations at hand.