Go to Post now now, there is no such thing as reading the manual too much. I read it every night just before I go to bed. - 663.keith [more]
Home
Go Back   Chief Delphi > ChiefDelphi.com Website > Extra Discussion
CD-Media   CD-Spy  
portal register members calendar search Today's Posts Mark Forums Read FAQ rules

 
Reply
Thread Tools Rate Thread Display Modes
  #16   Spotlight this post!  
Unread 09-01-2007, 16:42
Po-ser's Avatar
Po-ser Po-ser is offline
Registered User
AKA: Polina Danilyuk
FRC #0694 (Stuypulse)
Team Role: Mentor
 
Join Date: Mar 2006
Rookie Year: 2005
Location: New York City
Posts: 74
Po-ser has much to be proud ofPo-ser has much to be proud ofPo-ser has much to be proud ofPo-ser has much to be proud ofPo-ser has much to be proud ofPo-ser has much to be proud ofPo-ser has much to be proud ofPo-ser has much to be proud ofPo-ser has much to be proud of
Send a message via AIM to Po-ser
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.
__________________
Aim for the stars, land in Hawaii.

2003 - NYC Regional winner
2005 - NYC Regional Woodie Flowers Award
NYC Regional Chairman's Award
Championship Galileo Division semifinalist
Reply With Quote
  #17   Spotlight this post!  
Unread 10-01-2007, 10:27
cbudrecki's Avatar
cbudrecki cbudrecki is offline
Registered User
AKA: Carl Budrecki (buh-dre'-key)
FRC #0222 (Tigertrons)
Team Role: Alumni
 
Join Date: Oct 2002
Rookie Year: 2001
Location: Tunkhannock, PA
Posts: 275
cbudrecki is a name known to allcbudrecki is a name known to allcbudrecki is a name known to allcbudrecki is a name known to allcbudrecki is a name known to allcbudrecki is a name known to all
Exclamation 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!!!
Reply With Quote
  #18   Spotlight this post!  
Unread 10-01-2007, 10:35
cbudrecki's Avatar
cbudrecki cbudrecki is offline
Registered User
AKA: Carl Budrecki (buh-dre'-key)
FRC #0222 (Tigertrons)
Team Role: Alumni
 
Join Date: Oct 2002
Rookie Year: 2001
Location: Tunkhannock, PA
Posts: 275
cbudrecki is a name known to allcbudrecki is a name known to allcbudrecki is a name known to allcbudrecki is a name known to allcbudrecki is a name known to allcbudrecki is a name known to all
Re: paper: Rack & Roll Scoring Spreadsheet v1.0

Quote:
Originally Posted by wheeler View Post
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.

Last edited by cbudrecki : 10-01-2007 at 10:37.
Reply With Quote
  #19   Spotlight this post!  
Unread 10-01-2007, 10:50
cbudrecki's Avatar
cbudrecki cbudrecki is offline
Registered User
AKA: Carl Budrecki (buh-dre'-key)
FRC #0222 (Tigertrons)
Team Role: Alumni
 
Join Date: Oct 2002
Rookie Year: 2001
Location: Tunkhannock, PA
Posts: 275
cbudrecki is a name known to allcbudrecki is a name known to allcbudrecki is a name known to allcbudrecki is a name known to allcbudrecki is a name known to allcbudrecki is a name known to all
Exclamation 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!
Reply With Quote
  #20   Spotlight this post!  
Unread 10-01-2007, 11:48
Zach Wydick's Avatar
Zach Wydick Zach Wydick is offline
WOOT WOOT
FRC #1983 (Skunkworks)
Team Role: Leadership
 
Join Date: Oct 2006
Rookie Year: 2006
Location: Seattle
Posts: 25
Zach Wydick has a spectacular aura aboutZach Wydick has a spectacular aura aboutZach Wydick has a spectacular aura about
Re: paper: Rack & Roll Scoring Spreadsheet v1.0

I was just curious as to where V2.0 is posted
Reply With Quote
  #21   Spotlight this post!  
Unread 10-01-2007, 11:56
cbudrecki's Avatar
cbudrecki cbudrecki is offline
Registered User
AKA: Carl Budrecki (buh-dre'-key)
FRC #0222 (Tigertrons)
Team Role: Alumni
 
Join Date: Oct 2002
Rookie Year: 2001
Location: Tunkhannock, PA
Posts: 275
cbudrecki is a name known to allcbudrecki is a name known to allcbudrecki is a name known to allcbudrecki is a name known to allcbudrecki is a name known to allcbudrecki is a name known to all
Re: paper: Rack & Roll Scoring Spreadsheet v1.0

Quote:
Originally Posted by Zach Wydick View Post
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
Reply With Quote
  #22   Spotlight this post!  
Unread 10-01-2007, 12:09
Zach Wydick's Avatar
Zach Wydick Zach Wydick is offline
WOOT WOOT
FRC #1983 (Skunkworks)
Team Role: Leadership
 
Join Date: Oct 2006
Rookie Year: 2006
Location: Seattle
Posts: 25
Zach Wydick has a spectacular aura aboutZach Wydick has a spectacular aura aboutZach Wydick has a spectacular aura about
Re: paper: Rack & Roll Scoring Spreadsheet v1.0

Thank you very much and the program is very nice and helpful.
Reply With Quote
  #23   Spotlight this post!  
Unread 10-01-2007, 12:40
cbudrecki's Avatar
cbudrecki cbudrecki is offline
Registered User
AKA: Carl Budrecki (buh-dre'-key)
FRC #0222 (Tigertrons)
Team Role: Alumni
 
Join Date: Oct 2002
Rookie Year: 2001
Location: Tunkhannock, PA
Posts: 275
cbudrecki is a name known to allcbudrecki is a name known to allcbudrecki is a name known to allcbudrecki is a name known to allcbudrecki is a name known to allcbudrecki is a name known to all
Exclamation CRITICAL UPDATE #3 (and hopefully the last...)

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.

Last edited by cbudrecki : 10-01-2007 at 12:42.
Reply With Quote
  #24   Spotlight this post!  
Unread 10-01-2007, 13:18
Clinton Bolinger's Avatar
Clinton Bolinger Clinton Bolinger is offline
FF - PureMichigan
FRC #2337 (EngiNERDs)
Team Role: Coach
 
Join Date: Dec 2006
Rookie Year: 2001
Location: Grand Blanc, MI
Posts: 476
Clinton Bolinger has a reputation beyond reputeClinton Bolinger has a reputation beyond reputeClinton Bolinger has a reputation beyond reputeClinton Bolinger has a reputation beyond reputeClinton Bolinger has a reputation beyond reputeClinton Bolinger has a reputation beyond reputeClinton Bolinger has a reputation beyond reputeClinton Bolinger has a reputation beyond reputeClinton Bolinger has a reputation beyond reputeClinton Bolinger has a reputation beyond reputeClinton Bolinger has a reputation beyond repute
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-
Reply With Quote
  #25   Spotlight this post!  
Unread 10-01-2007, 13:25
cbudrecki's Avatar
cbudrecki cbudrecki is offline
Registered User
AKA: Carl Budrecki (buh-dre'-key)
FRC #0222 (Tigertrons)
Team Role: Alumni
 
Join Date: Oct 2002
Rookie Year: 2001
Location: Tunkhannock, PA
Posts: 275
cbudrecki is a name known to allcbudrecki is a name known to allcbudrecki is a name known to allcbudrecki is a name known to allcbudrecki is a name known to allcbudrecki is a name known to all
Re: paper: Rack & Roll Scoring Spreadsheet v1.0

This space is intentionally left blank...

Last edited by cbudrecki : 10-01-2007 at 15:50. Reason: repeat
Reply With Quote
  #26   Spotlight this post!  
Unread 10-01-2007, 13:39
cbudrecki's Avatar
cbudrecki cbudrecki is offline
Registered User
AKA: Carl Budrecki (buh-dre'-key)
FRC #0222 (Tigertrons)
Team Role: Alumni
 
Join Date: Oct 2002
Rookie Year: 2001
Location: Tunkhannock, PA
Posts: 275
cbudrecki is a name known to allcbudrecki is a name known to allcbudrecki is a name known to allcbudrecki is a name known to allcbudrecki is a name known to allcbudrecki is a name known to all
Re: paper: Rack & Roll Scoring Spreadsheet v1.0

Quote:
Originally Posted by tb222 View Post
[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

Quote:
Originally Posted by Oris View Post
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
Reply With Quote
  #27   Spotlight this post!  
Unread 10-01-2007, 13:50
Spider-Man's Avatar
Spider-Man Spider-Man is offline
Curling Rocks
AKA: Adam Jacobson
FRC #0467 (DTB/Shrewsbury Colonials); #0034 (Rocket City Robotics)
Team Role: Mentor
 
Join Date: Dec 2006
Rookie Year: 2000
Location: Shrewsbury, MA USA
Posts: 86
Spider-Man has a spectacular aura aboutSpider-Man has a spectacular aura about
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.
Reply With Quote
  #28   Spotlight this post!  
Unread 10-01-2007, 14:12
Barry Bonzack's Avatar
Barry Bonzack Barry Bonzack is offline
Impossible to rain on my parade.
FRC #1902 (Exploding Bacon)
 
Join Date: Apr 2004
Rookie Year: 2003
Location: Orlando, FL
Posts: 1,776
Barry Bonzack has a reputation beyond reputeBarry Bonzack has a reputation beyond reputeBarry Bonzack has a reputation beyond reputeBarry Bonzack has a reputation beyond reputeBarry Bonzack has a reputation beyond reputeBarry Bonzack has a reputation beyond reputeBarry Bonzack has a reputation beyond reputeBarry Bonzack has a reputation beyond reputeBarry Bonzack has a reputation beyond reputeBarry Bonzack has a reputation beyond reputeBarry Bonzack has a reputation beyond repute
Send a message via AIM to Barry Bonzack
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.
__________________


Chair of Florida FIRST Alumni
Orlando Regional Planning Committee
FIRST Tech Challenge Florida Leadership Team

Program Planner on the Orion Spacecraft at the Kennedy Space Center

Twitter: @FL_FIRST_Alumni













Events I'm Emceeing/Game Announcing:
1/10/2015 FTC Jacksonville League Championship
1/11/2015 FTC Central FL Tesla League Championship
1/17/2015 FTC South Florida League Championship
1/24/2015 FTC Tampa/St. Pete League Championship
2/7/2015 FLL Orlando Regional
2/14/2015 FTC State Championship
2/26-2/28/15 FRC South Florida Regional
3/8/2015 FLL State Championship
3/12-3/14/15 FRC Orlando Regional
4/22-4/25/15 FIRST World Championship Event - FTC Franklin Field
Reply With Quote
  #29   Spotlight this post!  
Unread 10-01-2007, 15:48
cbudrecki's Avatar
cbudrecki cbudrecki is offline
Registered User
AKA: Carl Budrecki (buh-dre'-key)
FRC #0222 (Tigertrons)
Team Role: Alumni
 
Join Date: Oct 2002
Rookie Year: 2001
Location: Tunkhannock, PA
Posts: 275
cbudrecki is a name known to allcbudrecki is a name known to allcbudrecki is a name known to allcbudrecki is a name known to allcbudrecki is a name known to allcbudrecki is a name known to all
Talking 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.

Last edited by cbudrecki : 10-01-2007 at 15:51.
Reply With Quote
  #30   Spotlight this post!  
Unread 10-01-2007, 16:07
wheeler wheeler is offline
Registered User
FRC #1002 (The CircuitRunners)
Team Role: Teacher
 
Join Date: Feb 2003
Rookie Year: 2003
Location: Marietta, GA
Posts: 80
wheeler is a jewel in the roughwheeler is a jewel in the roughwheeler is a jewel in the roughwheeler is a jewel in the rough
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
__________________
2007 Peachtree Engineering Inspiration & Vol. of Year
2007 NASA/VCU Engineering Inspiration
2007 Georgia Vex Inspire Award
2006 Peachtree Chairman's Award
2006 Peachtree VEX Champion & Challenge Award
2005 Peachtree Chairman's Award
2004 Championships Chairman's HM
2004 Peachtree Chairman's Award & Champions
2003 Peachtree Rookie All-Star
Reply With Quote
Reply


Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
RACK & ROLL Reaction Greg Perkins General Forum 219 10-01-2007 22:48
Rack N' Roll - 1 Page Rules Summary Cyberguy34000 Rules/Strategy 10 07-01-2007 22:42
Rack n Roll Animation Joe Matt General Forum 1 06-01-2007 14:28
White Paper Discuss: Triple Play Scoring Spreadsheet cbudrecki Extra Discussion 6 15-08-2005 10:49
White Paper Discuss: 2005 Scoring and Ranking spreadsheet Joe Ross Extra Discussion 2 17-03-2005 13:06


All times are GMT -5. The time now is 05:43.

The Chief Delphi Forums are sponsored by Innovation First International, Inc.


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