paper: Rack & Roll Scoring Spreadsheet v1.0

[cbudrecki]

Thread created automatically to discuss a document in CD-Media.

Rack & Roll Scoring Spreadsheet v1.0 by tb222

[cbudrecki]

OK, v1.0 is officially posted. I see it as a BETA version. I'd like to switch to drop-down lists, but that'll take some studying. Please inform me of any bugs that you find so I can fix them ASAP!

If you play around with it enough you just may find an easter egg

[Pavan Dave]

Nice work. I was working on one earlier.

Pavan.

[cbudrecki]

Originally Posted by Pavan

Nice work. I was working on one earlier.

Pavan.

I've basically taken this and made it my yearly project.

[DanDon]

YAY!! I've gotten the ENGINEERING AWARD!!! Woohoo!

[Tri_Lam]

some possible errors:
i have to double cheack it but spoilers are not countering the score plus
also when 2 ringers of same aliance are on a leg i think scores are supose to be null.

[cbudrecki]

Originally Posted by Tri_Lam

some possible errors:
i have to double cheack it but spoilers are not countering the score plus
also when 2 ringers of same aliance are on a leg i think scores are supose to be null.

Yes, two like ringers should cancel, nothing should cancel a keeper, and a spoiler ONLY cancels if it is the 2nd (right) ring.
I thought I made it to do that, I'll have to wait till the weekend when I'm at work to check it.

[BandChick]

Looks good! I expect this to be wildly helpful in explaining my strategy! =)

[Trample-Bot]

my elite maglev system has come into place quite well.... engineering award for me

also, nice job. That is some serious skill in excel


+1

[fernandosci]

hi there!

that was a great job...

it is working well... but i didn't understand what is written in the white fields...

and i have a doubt about the pontuation... my team didn't found any examples with a row formed in the spider legs #8 and #1... so after a lot of discussions, we still don't know if it will be acepted..

thank you

bye, and good lucky!

Fernando Ito- ETEPTeam#1382, Brazil

[cbudrecki]

Originally Posted by fernandosci

hi there!

that was a great job...

it is working well... but i didn't understand what is written in the white fields...

white fields? Ahh, yes, the bottom row of buttons... it says 'NADA' which is English slang for NOTHING. -sorry about that.

Originally Posted by fernandosci

and i have a doubt about the pontuation... my team didn't found any examples with a row formed in the spider legs #8 and #1... so after a lot of discussions, we still don't know if it will be acepted..

thank you

bye, and good lucky!

Fernando Ito- ETEPTeam#1382, Brazil

Yes, I know there is currently debates as to the whole wrap-around issue. I did design this scoresheet to count the wrap-arounds and if updates state that all rows scored end at 8, then I will be sure to update the scoring ASAP and get a new version reposted.

I'm glad that some of you are getting a kick out of the 'three elevated bot' bonus. I'm not saying that 3 bots in the air is impossible, just award-worthy in my mind.

Just out of curiousity, has anyone else noticed any issues with the scoring? I'd like to be sure what I'm looking for when I go to debug.

[cbudrecki]

I must also add that I am quite proud to have the First scoring program to be posted in the papers for the 2nd year in a row...

[Greg Needel]

Originally Posted by tb222

I must also add that I am quite proud to have the First scoring program to be posted in the papers for the 2nd year in a row...

column #3 doesn't seem to be working for me. More specifically when you are just doing a single on column 3, the rows appear to work.

[cbudrecki]

I must say, I did release v1.0 without any major testing. I was able to play with it for about an hour last night, and I must send my apologies to the 300+ downloaders of this BETA version. If you haven't picked up on the problems, here they are:

-column 3 does not work (simple programming error)

-in addition to scoring the columns, it also adds the points per tube (ie, a 2-tube column would equal 8 pts(4-row + 2 per tube)) This was purely an overlooked point in the original programming and will be fixed.

Unfortunately, I don't have a computer at home. I made it while I was at work (which is weekends only), and I'm at the library now (which is internet only), and then school doesn't start until next week. However, I will head down to school tomorrow to see if I can use thier computers, if so, v2.0 will be released tomorrow fixing many of the errors that have been found in v1.0, otherwise, it'll have to wait until Saturday.

So please, keep your eyes open for a CRITICAL UPDATE post, hopefully sometime tomorrow.

[wheeler]

This looks great.
I am assuming that the double is to account for spoilers and what is then behind it?

Also in the next release could you add a easy reset button?

Great work