U and sp classification worksheet prototype

[sachilles]

That would be no sweat to change.
I suppose you could also put the curb weight in, rather than the gvw and put zero in for the seats, and end up with the same calculation. Then note that instruction on the sheet.
Regardless, whatever folks want, I can probably make happen. The only thing that was any sort of a pain was box e41 and e42, went a little cross eyed making those.

[Rabbit Farmer]

Formula could test for either GVW - # of seats vs. curb weight entry; it would take one or the other based on completed fields.

[DaveEstey]

Shared link:
http://spreadsheets.google.com/ccc?key= ... PV3c&hl=en

I had valves set to 8 as well, which is most likely the problem.

Wheels are 15x7 stock a 14x6. Which do I go by when inserting the info? is it 2 inches bigger?

PS> I look forward to battling you in a new field Seth.

[walterclark]

Shared link:
Wheels are 15x7 stock a 14x6. Which do I go by when inserting the info? is it 2 inches bigger?

That is how I read it, enter 2 in the wheels box. You can also enter the gross weight in the GVW and 0 for passengers to get the correct GW.

[walterclark]

This is what I get for the CRX based on your info. I inserted the CW value from Wikipedia for the Si and set the passengers to 0, as well as using the correct wheel and valve numbers.

[Rabbit Farmer]

Seth. If the results are given in both U and SP below, there is another issue.... I get different percentages in U or SP (two different checkboxes). In the CRX example above, the U would be incorrect as the cage option is not selected.

[sachilles]

I can add some sort of check box to choose whether you are competing in U or SP, then only display the answer for that choice.
Otherwise, the logic is correct. There is no logic preventing someone from checking off a sp only option for U, or vice versa. I could certainly add some logic that if you choose u or sp, the only options that apply to you are valid.

[sachilles]

new and improved version
http://docs.google.com/fileview?id=0B90 ... Nzdl&hl=en
again, the link will give you an option to download it.

Edit: just replaced the last document in this post, as I had screwed something up.

[sachilles]

http://docs.google.com/fileview?id=0B90 ... NmIw&hl=en

Later revision. This link should take you to the page where you download it. You need excel or compatible program.

Just fill in the boxes with your weight, displacement and seats, and check the boxes that apply.

[dsldubn]

nice work on the worksheet.