ET Sheet

[Super73]

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

[Super73]

There was an error. It is now fixed (hopefully).

[Outlaw72]

I like it!

[Super73]

Did you play with it? How is it working for you?

[Super73]

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