I was a little bored....ok, a lot bored.
So I took the classification worksheet and created a version in excel.
You just put in your displacement, GVW and seats, then check off your modifciations, and it spits out your class.
Anyone care to have a look at it, and test/break it? I can email it to whomever, or perhaps Steve can post it.
It's only 28 kb.
Not perfect mind you, but might make it a lot less confusing for some folks.
I'd love to get some feedback. I'll make it more pretty as the bugs are worked out.
-Seth
U and sp classification worksheet prototype
U and sp classification worksheet prototype
Last edited by sachilles on Fri Feb 12, 2010 3:02 pm, edited 1 time in total.
Sachilles
02 Subaru impreza (Donut) #66
02 Subaru impreza (Donut) #66
- Rabbit Farmer
- Posts: 2260
- Joined: Wed Jun 25, 2003 11:37 pm
- AntiSpam: No
- Location: Earth
- Contact:
Re: U and sp classification worksheet prototype
Seth. Send me a copy and I will post up (and try to break it at the same time). As you know, numbers will change (potentially) based on the results of the annual banquet. If you know VBA, I can send you the old sheet that Brad Martin put together.
Go Fast VW & Audi parts at FastAddiction.com
Re: U and sp classification worksheet prototype
sent to your aol email address
No worries if things change at the rules meeting. It's easy enough to change or add things.
Only thing that took any time was the logic interpreting what class somebody falls into, and that was a good learning experience.
No worries if folks don't care for it.
-Seth
No worries if things change at the rules meeting. It's easy enough to change or add things.
Only thing that took any time was the logic interpreting what class somebody falls into, and that was a good learning experience.
No worries if folks don't care for it.
-Seth
Sachilles
02 Subaru impreza (Donut) #66
02 Subaru impreza (Donut) #66
- Rabbit Farmer
- Posts: 2260
- Joined: Wed Jun 25, 2003 11:37 pm
- AntiSpam: No
- Location: Earth
- Contact:
Re: U and sp classification worksheet prototype
Got it. I'll take a look at it tonight. We can discuss here (forums) and at the meeting on Tuesday if needed.
Go Fast VW & Audi parts at FastAddiction.com
Re: U and sp classification worksheet prototype
not sure if this works or not, but lets see if sharing it on google documents will work
http://spreadsheets.google.com/ccc?key= ... wQWc&hl=en
http://spreadsheets.google.com/ccc?key= ... wQWc&hl=en
Sachilles
02 Subaru impreza (Donut) #66
02 Subaru impreza (Donut) #66
Re: U and sp classification worksheet prototype
looks like when it gets converted on google docs, it loses the check boxes. Without the checkboxes the spreadsheet is worthless. Oh well.
Sachilles
02 Subaru impreza (Donut) #66
02 Subaru impreza (Donut) #66
Re: U and sp classification worksheet prototype
let's try this again
http://docs.google.com/fileview?id=0B90 ... MTli&hl=en
edit: one last try with google
seems like this one works. should bring you to a screen where you can download it. It will only work if you have excel or compatible program.
http://docs.google.com/fileview?id=0B90 ... MTli&hl=en
edit: one last try with google
seems like this one works. should bring you to a screen where you can download it. It will only work if you have excel or compatible program.
Sachilles
02 Subaru impreza (Donut) #66
02 Subaru impreza (Donut) #66
- Rabbit Farmer
- Posts: 2260
- Joined: Wed Jun 25, 2003 11:37 pm
- AntiSpam: No
- Location: Earth
- Contact:
Re: U and sp classification worksheet prototype
You don't need checkboxes.... just put a formula that tests for any character in the cell; if true (like the checkbox) then calculate the formula. An array might be the way to go or VlookUp.
Oh, and Dirty Penny Ale is good!
Steve
Oh, and Dirty Penny Ale is good!
Steve
Go Fast VW & Audi parts at FastAddiction.com
Re: U and sp classification worksheet prototype
You don't think a check box is more intuitive, as opposed to an open cell?
Sachilles
02 Subaru impreza (Donut) #66
02 Subaru impreza (Donut) #66
- Rabbit Farmer
- Posts: 2260
- Joined: Wed Jun 25, 2003 11:37 pm
- AntiSpam: No
- Location: Earth
- Contact:
Re: U and sp classification worksheet prototype
Oh, I agree it is, but you said you were having issues posting it with the checkbox.
Go Fast VW & Audi parts at FastAddiction.com