Go to Post We're all human, we all make mistakes. How you deal with mistakes and problems, is what really elevates successful people, robotics teams, organizations, etc. above the rest. - artdutra04 [more]
Home
Go Back   Chief Delphi > FIRST > General Forum
CD-Media   CD-Spy  
portal register members calendar search Today's Posts Mark Forums Read FAQ rules

 
 
 
Thread Tools Rate Thread Display Modes
Prev Previous Post   Next Post Next
  #13   Spotlight this post!  
Unread 23-10-2003, 01:59
Unsung FIRST Hero
Karthik Karthik is offline
VEX Robotics GDC Chairman
no team
Team Role: Mentor
 
Join Date: Apr 2002
Rookie Year: 1998
Location: Toronto, Ontario, Canada
Posts: 2,349
Karthik has a reputation beyond reputeKarthik has a reputation beyond reputeKarthik has a reputation beyond reputeKarthik has a reputation beyond reputeKarthik has a reputation beyond reputeKarthik has a reputation beyond reputeKarthik has a reputation beyond reputeKarthik has a reputation beyond reputeKarthik has a reputation beyond reputeKarthik has a reputation beyond reputeKarthik has a reputation beyond repute
Quote:
Originally posted by Andrew

Looks like its going to get tough to track how many actual teams there are this year once second regional sign up opens in a few days.
If you want to get a count minus the duplicates, copy the table into Excel and do the following.

1. Start in a new column, say E, and give E1 the value 1.
2. Give E2 the formula: IF(E2=E1,0,1)
This sets the value to 1 if it's different than what's above, and 0 if it's a duplicate.
3. Paste this formula for all valid cells in E
4. In another cell, take the entire sum of column E
5. This value should be the current number of teams signed up to at least one event.

I'm pretty sure this is not the most efficient way of doing this. If anyone is quite savvy with Excel, a more direct formula would be appreciated.
__________________
:: Karthik Kanagasabapathy ::
"Enthusiasm is one of the most powerful engines of success. When you do a thing, do it with all your might. Put your whole soul into it. Stamp it with your own personality. Be active, be energetic, be enthusiastic and faithful and you will accomplish your object. Nothing great was ever achieved without enthusiasm" -- R.W. Emerson
My TEDx Talk - The Subtle Secrets of Success
Full disclosure: I work for IFI and VEX Robotics, and am the Chairman of the VEX Robotics and VEX IQ Game Design Committees
.
Reply With Quote
 


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
FALL FURY Registration Open DirtyBird213 Off-Season Events 1 09-09-2003 08:46
2nd regional registration is open Mike371 General Forum 13 05-11-2002 21:06
Duel on the Delaware Registration NOW OPEN TO ALL John Larock Off-Season Events 0 30-08-2002 07:24
Registration for 2000 is Now Open! archiver 2000 0 23-06-2002 21:57


All times are GMT -5. The time now is 03:59.

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