ET Sheet / tool
ET Sheet / tool The other night was restless night. As I laid awake, exited that I am going to the track in a couple weeks I started wondering, what will the truck run. I started to play with excel and produce a prety detailed sheet that I would like to get you feedback on.
If you input your data, it does a lot of things.
1) Stores all your ET info so you can go back and look at it and sort it ect
2) Averages your ET's, mph, 60's, 330's yadda yadda
3) Shows how much time it took to get from say yhe 60' to the 330 or the 330' to the 1000'
4) I have a what if section. So "If I cut a x.xxx 60' what would my ET be based on my average. (There is a way to do best/worst scenerio too, but that's a little more elaborate and will have to give directions)
What I would love from all of you is feed back. Put in 6-12 slips. Play around with the what if section. Tell me how far off or how close it is. Obviously combo changes like going from a tiny converter to a big one, or NA to N20 runs might skew things a bit, so use you judgement. Try to put similar data in. N20 passes only or NA passes only.
Please let me know if there is something I could add, take away, enhance..
Thanks in advance.
Here is the blank sheet: http://73-ls1.com/spreadsheets/Blank_ETsheet_rev3.xls
Here is what it looks like filled out with my truck's info which has the best/worst case scenerio set up: http://73-ls1.com/spreadsheets/ETsheet.xls
If you input your data, it does a lot of things.
1) Stores all your ET info so you can go back and look at it and sort it ect
2) Averages your ET's, mph, 60's, 330's yadda yadda
3) Shows how much time it took to get from say yhe 60' to the 330 or the 330' to the 1000'
4) I have a what if section. So "If I cut a x.xxx 60' what would my ET be based on my average. (There is a way to do best/worst scenerio too, but that's a little more elaborate and will have to give directions)
What I would love from all of you is feed back. Put in 6-12 slips. Play around with the what if section. Tell me how far off or how close it is. Obviously combo changes like going from a tiny converter to a big one, or NA to N20 runs might skew things a bit, so use you judgement. Try to put similar data in. N20 passes only or NA passes only.
Please let me know if there is something I could add, take away, enhance..
Thanks in advance.
Here is the blank sheet: http://73-ls1.com/spreadsheets/Blank_ETsheet_rev3.xls
Here is what it looks like filled out with my truck's info which has the best/worst case scenerio set up: http://73-ls1.com/spreadsheets/ETsheet.xls
Last edited by LIL SS; Mar 24, 2008 at 12:20 PM.
Much more useful than the sheet I had been using. Thank you.
You might want to check your blank sheet VS your filled in one.
Something was missing. I can get it to work if I paste my numbers over yours.
As far as formatting, freeze your panes to make getting around the sheet a little easier.
Also, color the cells that should be filled in by the user to it's obvious.
You can even lock the rest to protect them from themselves LOL
You might want to check your blank sheet VS your filled in one.
Something was missing. I can get it to work if I paste my numbers over yours.
As far as formatting, freeze your panes to make getting around the sheet a little easier.
Also, color the cells that should be filled in by the user to it's obvious.
You can even lock the rest to protect them from themselves LOL
great sheet! very usefull in keeping track of your performance.
like daddy and girl said , i colomn with notes on the left would be handy to know stuff about the run .
thanks again!!!
like daddy and girl said , i colomn with notes on the left would be handy to know stuff about the run .
thanks again!!!
Trending Topics
Made some changes to clean it up a bit. Added a comment section..
The one thing I have noticed is it seems to get more inaccurate the further you get from the average. I'll be playing with it more to see if I can correct for that, but have fun with it for now and please let me know if you have more suggestions..
http://73-ls1.com/spreadsheets/Blank_ETsheet_rev5.xls
The one thing I have noticed is it seems to get more inaccurate the further you get from the average. I'll be playing with it more to see if I can correct for that, but have fun with it for now and please let me know if you have more suggestions..
http://73-ls1.com/spreadsheets/Blank_ETsheet_rev5.xls
LS1 Tech Stories
The Best V8 Stories One Small Block at Time
Amazing '71 Camaro Restomod Is Modern Muscle Car Under the Skin
Verdad Gallardo
6 Common C5 Corvette Failures and What's Involved In Repairing Them
Pouria Savadkouei
Retro Modern Bandit Pontiac Trans AM Comes With Burt Reynolds' Autograph
Verdad Gallardo
Top 10 Greatest Cadillac V Series Performance Models Ever, Ranked
Pouria Savadkouei
Top 10 Most Powerful Chevy Trucks Ever Made!
Hennessey's New Supercharged Silverado ZR2 Has 700 HP
Verdad Gallardo
Coachbuilt N2A Anteros Is an LS2-Powered C6 Corvette In Italian Clothes
Verdad Gallardo
Awesome K5 Blazer Restomod Comes With C7 Corvette Power
Verdad Gallardo