Chief Delphi
Page 2 of 4 < 1 2 34 >
Show 100 post(s) from this thread on one page

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)

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


All times are GMT -5. The time now is 08:16.
Page 2 of 4 < 1 2 34 >
Show 100 post(s) from this thread on one page

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