paper: Rack & Roll Scoring Spreadsheet v1.0

[Zach Wydick]

I was just curious as to where V2.0 is posted

[cbudrecki]

Originally Posted by Zach Wydick

I was just curious as to where V2.0 is posted

v2.0(now 2.1, soon to be 2.2) is posted on the same page as 1.0. The new paper system allows you to post multiple files into one paper, so all updates will be posted on the same page as the original. I didn't realize how the new paper system worked, or I just would have title the paper w/o the version #.

Here's the link: Rack & Roll scoring Spreadsheet

[Zach Wydick]

Thank you very much and the program is very nice and helpful.

[cbudrecki]

v2.2 is released. I've played with it thouroughly and all seems to be OK. The scoring definately throws you off looking at it quickly, but take a minute, sit back, and really think about what was counted and what is now getting counted, and it all makes sense. (I was driving myself nuts thinking things weren't adding up correctly...)

I do truly feel that v2.2 will give you a very accurate scoring and as always, if you find something wrong, don't hesitate to post it.

Also, once again, I would appreciate anyone who knows VBA code to help with a RESET button. What needs to be done is posted earlier in this thread.

[Clinton Bolinger]

In version 2.1, if you put a Red Keeper or Ringer on the Top and Middle Row of the 1st Column the score say 6, when it should be 4.

Might want to take a look at that.

-Oris-

[cbudrecki]

This space is intentionally left blank...

[cbudrecki]

Originally Posted by tb222

[SIZE="7v2.2"] is released.[/size] I've played with it thouroughly and all seems to be OK. The scoring definately throws you off looking at it quickly, but take a minute, sit back, and really think about what was counted and what is now getting counted, and it all makes sense. (I was driving myself nuts thinking things weren't adding up correctly...)

I do truly feel that v2.2 will give you a very accurate scoring and as always, if you find something wrong, don't hesitate to post it.

Also, once again, I would appreciate anyone who knows VBA code to help with a RESET button. What needs to be done is posted earlier in this thread.

make that 2.2.1

Originally Posted by Oris

In version 2.1, if you put a Red Keeper or Ringer on the Top and Middle Row of the 1st Column the score say 6, when it should be 4.

Might want to take a look at that.

-Oris-

good catch, i believe I got everything else covered in 2.2, but not that

try 2.2.1

[Spider-Man]

I was playing with v1.0 yesterday fixing it to work for me and adding extras.

Reset was something i was looking into, and this is the macro I came up with:

Sub Button1456_Click()

Range("B2:Q2,B9:Q9,B16:Q16").Select
Selection.Value = 6
Range("R3:T3,R11:T11").Select
Selection.Value = 1
Range("A1").Select

End Sub

It selects the the Radio buttons and changes the value to "NADA" for the spider legs and changes the value to "<4"" for the raising of the robots.

[Barry Bonzack]

Just an FYI for openoffice spreadsheet users, I am having problems getting this to do anything at all. I'll try it once I get to school with excel.

[cbudrecki]

Version 3.0 is now posted. It's exactly the same as 2.2.1 only it has a RESET thanks to Spidey.

[wheeler]

This is looking good. I am working on one with a student as well that we hope to complete this week.

I did notice that if you complete a column it is scoring 10 instead of 8 but then it corrects as more are added.

Keep up the good work

[cbudrecki]

Originally Posted by wheeler

This is looking good. I am working on one with a student as well that we hope to complete this week.

I did notice that if you complete a column it is scoring 10 instead of 8 but then it corrects as more are added.

Keep up the good work

Thanks, look forward to a 3.1 before long...

P.S.- Brandon, I've tried to delete older versions, but it just won't let me. I really don't mean to be taking up so much space...

[Zoheb N]

wow these are awesome.. thanks for gettin them up so fast

[cbudrecki]

v3.1 is now up

they're kicking me out of the computer lab for today, so I think I'll be able to check up on things tomorrow night, if not then Friday.

I must say THANX and GREAT JOB to all of you who have pointed out the problems and, of course, once again to Spider-Man who gave me the code for the RESET button.

TTFN!

[PandaMan]

V 3.1 still adds incorrectly. When you have a row of 8 it = 256, which is correct. But when I remove a tube from position 5, it shows 144, when it should really be a row of 3 and a row of 4 which = 24.