Chief Delphi

Chief Delphi (http://www.chiefdelphi.com/forums/index.php)
-   Extra Discussion (http://www.chiefdelphi.com/forums/forumdisplay.php?f=68)
-   -   paper: Rack & Roll Scoring Spreadsheet v1.0 (http://www.chiefdelphi.com/forums/showthread.php?t=51214)

cbudrecki 08-01-2007 01:02
paper: Rack & Roll Scoring Spreadsheet v1.0
 
Thread created automatically to discuss a document in CD-Media.

Rack & Roll Scoring Spreadsheet v1.0 by tb222

cbudrecki 08-01-2007 01:07
Re: paper: Rack & Roll Scoring Spreadsheet v1.0
 
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 08-01-2007 01:07
Re: paper: Rack & Roll Scoring Spreadsheet v1.0
 
Nice work. I was working on one earlier.

Pavan.

cbudrecki 08-01-2007 01:08
Re: paper: Rack & Roll Scoring Spreadsheet v1.0
 
Quote:
Originally Posted by Pavan (Post 550849)
Nice work. I was working on one earlier.

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

DanDon 08-01-2007 01:28
Re: paper: Rack & Roll Scoring Spreadsheet v1.0
 
YAY!! I've gotten the ENGINEERING AWARD!!! Woohoo!

Tri_Lam 08-01-2007 02:22
Re: paper: Rack & Roll Scoring Spreadsheet v1.0
 
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 08-01-2007 11:00
Re: paper: Rack & Roll Scoring Spreadsheet v1.0
 
Quote:
Originally Posted by Tri_Lam (Post 550903)
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 08-01-2007 11:22
Re: paper: Rack & Roll Scoring Spreadsheet v1.0
 
Looks good! I expect this to be wildly helpful in explaining my strategy! =)

Trample-Bot 08-01-2007 11:41
Re: paper: Rack & Roll Scoring Spreadsheet v1.0
 
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 08-01-2007 12:02
Re: paper: Rack & Roll Scoring Spreadsheet v1.0
 
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 08-01-2007 18:18
Re: paper: Rack & Roll Scoring Spreadsheet v1.0
 
Quote:
Originally Posted by fernandosci (Post 551110)
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.
Quote:
Originally Posted by fernandosci (Post 551110)
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.:cool:

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 08-01-2007 18:30
Re: paper: Rack & Roll Scoring Spreadsheet v1.0
 
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 08-01-2007 20:31
Re: paper: Rack & Roll Scoring Spreadsheet v1.0
 
Quote:
Originally Posted by tb222 (Post 551479)
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 09-01-2007 14:55
Re: paper: Rack & Roll Scoring Spreadsheet v1.0
 
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 09-01-2007 16:38
Re: paper: Rack & Roll Scoring Spreadsheet v1.0
 
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

Po-ser 09-01-2007 16:42
Re: paper: Rack & Roll Scoring Spreadsheet v1.0
 
Awesome! Thanks! :)

P.S. Since according to your spreadsheet, we get an engineering award for raising all three bots up, we decided to build a hover craft!

P.P.S. I wish.

cbudrecki 10-01-2007 10:27
CRITICAL UPDATE!!!
 
Version 2.0 is now posted.
I highly suggest trashing v1.0 and replace it with the new version. The scoring in version 2.0 is much more reliable than in 1.0. In 1.0, columns would add individual points from the tubes as well as the rows, this is no longer the case in 2.0. Also, column 3 just didn't work at all, this is now fixed. I've played around with it a little, but it seems to be working fine for me.

IF YOU FIND ANY PROBLEMS, PLEASE POST THEM AND I WILL GET THEM RESOLVED ASAP!!!

cbudrecki 10-01-2007 10:35
Re: paper: Rack & Roll Scoring Spreadsheet v1.0
 
Quote:
Originally Posted by wheeler (Post 552333)
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
If anybody knows VBA code and would be willing to help me out with a RESET, I'd really appreciate it. I've been trying to play with it, but it just isn't working out right. The Keeper rows (B:Q 2,9,16) need to reset to a value of 6(value of the "none" button) and the robot rows (R:T 3,11) need to reset to 1, along with clearing(or set to 0) R7 and T14.

Again, if anybody knows VBA or would be willing to point me in the right direction, I'd appreciate it.

cbudrecki 10-01-2007 10:50
CRITICAL UPDATE #2
 
of course, playing around with the more reliable 2.0, I realized it wasn't adding the top row in addition to the columns, a quick programming change and v2.1 is now released.

ENJOY!

Zach Wydick 10-01-2007 11:48
Re: paper: Rack & Roll Scoring Spreadsheet v1.0
 
I was just curious as to where V2.0 is posted

cbudrecki 10-01-2007 11:56
Re: paper: Rack & Roll Scoring Spreadsheet v1.0
 
Quote:
Originally Posted by Zach Wydick (Post 553089)
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 10-01-2007 12:09
Re: paper: Rack & Roll Scoring Spreadsheet v1.0
 
Thank you very much and the program is very nice and helpful.

cbudrecki 10-01-2007 12:40
CRITICAL UPDATE #3 (and hopefully the last...)
 
v2.2 is released.:eek: 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 10-01-2007 13:18
Re: paper: Rack & Roll Scoring Spreadsheet v1.0
 
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 10-01-2007 13:25
Re: paper: Rack & Roll Scoring Spreadsheet v1.0
 
This space is intentionally left blank...

cbudrecki 10-01-2007 13:39
Re: paper: Rack & Roll Scoring Spreadsheet v1.0
 
Quote:
Originally Posted by tb222 (Post 553128)
[SIZE="7v2.2"] is released.:eek:[/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

Quote:
Originally Posted by Oris (Post 553151)
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 10-01-2007 13:50
Re: paper: Rack & Roll Scoring Spreadsheet v1.0
 
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:

Code:
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 10-01-2007 14:12
Re: paper: Rack & Roll Scoring Spreadsheet v1.0
 
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 10-01-2007 15:48
Re: paper: Rack & Roll Scoring Spreadsheet
 
Version 3.0 is now posted. It's exactly the same as 2.2.1 only it has a RESET thanks to Spidey.

wheeler 10-01-2007 16:07
Re: paper: Rack & Roll Scoring Spreadsheet v1.0
 
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 10-01-2007 16:11
Re: paper: Rack & Roll Scoring Spreadsheet v1.0
 
Quote:
Originally Posted by wheeler (Post 553272)
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 10-01-2007 16:16
Re: paper: Rack & Roll Scoring Spreadsheet v1.0
 
wow these are awesome.. thanks for gettin them up so fast

cbudrecki 10-01-2007 16:22
Re: paper: Rack & Roll Scoring Spreadsheet
 
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 10-01-2007 16:28
Re: paper: Rack & Roll Scoring Spreadsheet v1.0
 
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.

cbudrecki 10-01-2007 19:05
Re: paper: Rack & Roll Scoring Spreadsheet v1.0
 
Quote:
Originally Posted by PandaMan (Post 553288)
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.
to get 144, you probably have other legs selected to add to the 128 for a 7-row - read the whole thread-

Quote:
Originally Posted by tb222 (Post 551470)
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.

PandaMan 10-01-2007 22:10
Re: paper: Rack & Roll Scoring Spreadsheet v1.0
 
Oh alright, thanks for the clarification.

cbudrecki 11-01-2007 14:30
Re: paper: Rack & Roll Scoring Spreadsheet v1.0
 
Quote:
Originally Posted by tb222 (Post 553408)
to get 144, you probably have other legs selected to add to the 128 for a 7-row - read the whole thread-
my apologies. of course you didn't have anything else selected. the program gave you the 128 for the seven row, however what I now have to work out is how to keep it from adding the four row that starts in column 1. thanks for the heads-up, expect a 3.2 soon.

cbudrecki 11-01-2007 15:09
Rack & Roll Scoring Spreadsheet v3.2
 
Rack & Roll Scoring v3.2 is now posted

this resolves the issue of adding rows starting at column 1 to a wrap-around row. Made rows, dropped tubes, added columns, all seems to be working OK.

cbudrecki 12-01-2007 12:19
Re: paper: Rack & Roll Scoring Spreadsheet v1.0
 
I am just kinda curious, if you've downloaded the scoresheet, check out this poll.

cbudrecki 12-01-2007 12:41
Re: paper: Rack & Roll Scoring Spreadsheet v1.0
 
Quote:
Originally Posted by tb222 (Post 551470)
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.
Well, that's one version that I won't have to release.

From FIRST Q&A-
Quote:
Originally Posted by GDC
The numbers on the top row of Spider Legs are for reference purposes only. Potential rows are determined solely by adjacency and "wrap around" the reference locations. So a set of scored Spider Legs 7, 8 and 1 would be considered a row of three.

Kuru Oujou 12-01-2007 13:09
Re: paper: Rack & Roll Scoring Spreadsheet v1.0
 
It appears on version 3.2 you reversed the Keepers and the Ringers.

I could be wrong, I didn't play with it a whole lot, and I didn't observe it closely.

cbudrecki 13-01-2007 17:52
Re: paper: Rack & Roll Scoring Spreadsheet v1.0
 
Quote:
Originally Posted by Kuru Oujou (Post 555039)
It appears on version 3.2 you reversed the Keepers and the Ringers.

I could be wrong, I didn't play with it a whole lot, and I didn't observe it closely.
no, just downloaded it on a different computer, all seems to be working OK.

mtaman02 13-01-2007 18:05
Re: paper: Rack & Roll Scoring Spreadsheet v1.0
 
The Reset button does nothing =( at least nothing to the current scoring scenarios or the score itself.

cbudrecki 13-01-2007 18:08
Rack & Roll Scoring Spreadsheet v3.3
 
v3.3 POSTED
Unfortunately, after playing yet some more, I noticed that columns 2-8 were scoring as 10 points, not 8. That issue is now fixed.

cbudrecki 13-01-2007 18:11
Re: paper: Rack & Roll Scoring Spreadsheet v1.0
 
Quote:
Originally Posted by mtaman02 (Post 555951)
The Reset button does nothing =( at least nothing to the current scoring scenarios or the score itself.
again, I just downloaded it onto a different computer than I've been using, and it works fine. Make sure your macros are enabled. Tools>Macro>Security

mtaman02 13-01-2007 18:36
Re: paper: Rack & Roll Scoring Spreadsheet v1.0
 
Ah I see. Believe it or not my Macros was on but they were set to maximum. Why I have no idea I just lowered it to medium or low and all works fine now.

cbudrecki 13-01-2007 18:38
QP & RP scoring in the Scoring Spreadsheet
 
v4.0 RELEASED

v3.3 with added QP and RP scoring. May be helpful in strategizing. Enjoy!

cbudrecki 13-01-2007 18:39
Re: paper: Rack & Roll Scoring Spreadsheet v1.0
 
Quote:
Originally Posted by mtaman02 (Post 555985)
Ah I see. Believe it or not my Macros was on but they were set to maximum. Why I have no idea I just lowered it to medium or low and all works fine now.
glad to here it!:D

cbudrecki 13-01-2007 19:23
Re: paper: Rack & Roll Scoring Spreadsheet v1.0
 
if anyone would like, I would gladly post a version with red and blue MAX score buttons(922 by the way). I have it done, but until I can get older versions of the score sheet deleted from the paper, though, I'd really rather not post any more than necessary.

cbudrecki 14-01-2007 20:50
Re: paper: Rack & Roll Scoring Spreadsheet v1.0
 
Quote:
Originally Posted by tb222 (Post 556036)
if anyone would like, I would gladly post a version with red and blue MAX score buttons(922 by the way). I have it done, but until I can get older versions of the score sheet deleted from the paper, though, I'd really rather not post any more than necessary.
well, now that the older versions are gone, I've posted this as v4.5. I felt it's more than just a .1 change, but not quite a full version, so I made it a 1/2. I do believe this will be the final version, but who knows...

v4.5 features:
- 8 revisions of scoring
- QP & RP scoring
- MAX blue and red score buttons
- RESET button

ENJOY!

wheeler 14-01-2007 22:14
Re: paper: Rack & Roll Scoring Spreadsheet v1.0
 
Here is one that I was working on to link to an access database for scouting purposes.

Let me know what you thinkhttp://www.chiefdelphi.com/media/papers/1907


All times are GMT -5. The time now is 08:16.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright © Chief Delphi