Go to Post I still believe that if we are legitimately trying to make FRC be recognized as a real sport, then the GDC must treat it like one. - Jim Zondag [more]
Home
Go Back   Chief Delphi > Other > Chit-Chat > Games/Trivia > Fantasy FIRST
CD-Media   CD-Spy  
portal register members calendar search Today's Posts Mark Forums Read FAQ rules

 
Reply
Thread Tools Rate Thread Display Modes
  #1   Spotlight this post!  
Unread 26-04-2014, 23:54
EricH's Avatar
EricH EricH is offline
New year, new team
FRC #1197 (Torbots)
Team Role: Engineer
 
Join Date: Jan 2005
Rookie Year: 2003
Location: SoCal
Posts: 19,823
EricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond repute
[FF]: Draft Organization Stuff To Do

As I mentioned in this post, I think some of the programming for future organization/draft running/scoring stuff should be done collectively. This is intended to be the organization thread. There's quite a few tasks to be done, improvements to be made, and all that good stuff.

So, there are two main categories. There's the Draft Assistant project, mainly in Excel macros (Visual Basic and the like), which is a big one but easily breakable into smaller chunks, and there's several smaller projects that one or more people can take on. If you want to work on something, put your name down on that so we know what still needs to be covered.

Draft Assistant V3 (EricH, coordinator)
-Rewrite original macros for speed/optimization. (EricH--I'll be modifying the code to set and use certain variables throughout the program, rather than having to reset 'em all, as the key part of the process)
-Rewrite for dynamic placement of team list. (Note: This ought to be pretty straightforward, so I might get to it when I do the other rewrite. Right now, it'd be a pain in the behind.)

-Add a 4th-round option, as that might be useful in the future. (There's an existing macro or two that can be modified to make this easier.)
-Incorporate list picks.
-Incorporate random picks.
-Incorporate error-checking.
-Automate format changes and error-checking.
-See if the various macros etc. work in Google Docs, or can be rewritten for same.

General Organization
--Work out single scoring sheet with alliances/scores--location, layout, automation level, all the gory details.
--Automatic team list pulling from FRC site.
--Automatic scoring (by team or by player)--I think there's an existing method, but IIRC it didn't work properly when I checked it for this year.
--Automatic waiver processing--if anybody wants to be so bold.


The plan on the Draft Assistant is: If someone wants to get a jump on it, there's a copy in CD-Media; I'll point you to it if you've forgotten (or you could search for me as the uploader). I'll use the development version, which is slightly different and do the above-mentioned rewrite there, then publish that (and I'll make sure to comment a lot within the macros). At which point, y'all see the list, y'all have some fun, and if you complete a section that seems to work, drop it on over to me and I'll republish the whole sheet.
__________________
Past teams:
2003-2007: FRC0330 BeachBots
2008: FRC1135 Shmoebotics
2012: FRC4046 Schroedinger's Dragons

"Rockets are tricky..."--Elon Musk


Last edited by EricH : 27-04-2014 at 19:16. Reason: Did some work.
Reply With Quote
  #2   Spotlight this post!  
Unread 27-04-2014, 01:31
ghostmachine360's Avatar
ghostmachine360 ghostmachine360 is offline
Kyle J. Fender
AKA: Kyle J. Fender
FRC #1002 (CircuitRunners Robotics)
Team Role: Mentor
 
Join Date: Dec 2010
Rookie Year: 2007
Location: Marietta, Georgia
Posts: 372
ghostmachine360 has a reputation beyond reputeghostmachine360 has a reputation beyond reputeghostmachine360 has a reputation beyond reputeghostmachine360 has a reputation beyond reputeghostmachine360 has a reputation beyond reputeghostmachine360 has a reputation beyond reputeghostmachine360 has a reputation beyond reputeghostmachine360 has a reputation beyond reputeghostmachine360 has a reputation beyond reputeghostmachine360 has a reputation beyond reputeghostmachine360 has a reputation beyond repute
Re: [FF]: Draft Organization Stuff To Do

I could work on general organization; I'll have a lot of free time over the next couple weeks or so.
__________________
Member of the Rotten Fruit Alliance
2013, 2015, & 2016 Fantasy FIRST Elgin Clock Award Winners [RFA]
2015 & 2016 Fantasy FIRST Champions [RFA]
GeorgiaFIRST Advisory Board & District Planning Commitee Member
SPSU Class of 2016: Robotics Engineering Major
GeorgiaFIRST FRC/FTC Emcee, FTC Head Referee, & FRC Referee
2010 CMP FRC Dean's List & 2010 Peachtree DLA Finalist
Reply With Quote
  #3   Spotlight this post!  
Unread 27-04-2014, 19:15
EricH's Avatar
EricH EricH is offline
New year, new team
FRC #1197 (Torbots)
Team Role: Engineer
 
Join Date: Jan 2005
Rookie Year: 2003
Location: SoCal
Posts: 19,823
EricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond repute
Re: [FF]: Draft Organization Stuff To Do

I have uploaded the rewritten Draft Assistant to http://www.chiefdelphi.com/media/papers/2881, under the "Group Development Copy" paper. ("Clean" setup versions remain available.)

I took care of the first two rewrites and added some comments.
__________________
Past teams:
2003-2007: FRC0330 BeachBots
2008: FRC1135 Shmoebotics
2012: FRC4046 Schroedinger's Dragons

"Rockets are tricky..."--Elon Musk

Reply With Quote
  #4   Spotlight this post!  
Unread 28-04-2014, 14:35
bam-bam bam-bam is offline
Registered User
no team
Team Role: Alumni
 
Join Date: Apr 2010
Rookie Year: 2010
Location: West Lafayette
Posts: 1,220
bam-bam has a reputation beyond reputebam-bam has a reputation beyond reputebam-bam has a reputation beyond reputebam-bam has a reputation beyond reputebam-bam has a reputation beyond reputebam-bam has a reputation beyond reputebam-bam has a reputation beyond reputebam-bam has a reputation beyond reputebam-bam has a reputation beyond reputebam-bam has a reputation beyond reputebam-bam has a reputation beyond repute
Re: [FF]: Draft Organization Stuff To Do

I can help with the general organization also.
__________________
FRC 1529: 2010-2011
FRC 1501: 2012-2013, 2012 BMR winners (thank you 1756 & 4028)
FRC 461: 2015
2014 FF Elgin Clock Award Winner(Automated Scoring)
Reply With Quote
  #5   Spotlight this post!  
Unread 08-05-2014, 11:52
BrennanB's Avatar
BrennanB BrennanB is offline
TBC is good at getting almost first
AKA: Brennan Bibic
FRC #4476 (W.A.F.F.L.E.S.)
Team Role: Mentor
 
Join Date: Jan 2012
Rookie Year: 2006
Location: Kingston
Posts: 1,300
BrennanB has a reputation beyond reputeBrennanB has a reputation beyond reputeBrennanB has a reputation beyond reputeBrennanB has a reputation beyond reputeBrennanB has a reputation beyond reputeBrennanB has a reputation beyond reputeBrennanB has a reputation beyond reputeBrennanB has a reputation beyond reputeBrennanB has a reputation beyond reputeBrennanB has a reputation beyond reputeBrennanB has a reputation beyond repute
Re: [FF]: Draft Organization Stuff To Do

Quote:
Originally Posted by EricH View Post
-See if the various macros etc. work in Google Docs, or can be rewritten for same.
I will take a look at this. Google spreadsheets just recently went through an overhaul and some new things were added.
__________________

Brennan Bibic - @b_bibic - Eh-Nalysis
10 years of inspiration compilation - W.A.F.F.L.E.S. #4476 YouTube Channel - 64 events and counting!

FRC 2013-2017 (W.A.F.F.L.E.S. Community Robotics #4476) - FLL 2006-2017 (W.A.F.F.L.E.S. #105) - VRC 2010-2013, 2015-2016 (W.A.F.F.L.E.S. #4476)
FRC 2009-2012 (K-Botics #2809)

Fantasy First 2014-2017 (The Breakfast Company) #TBCWin
2014 Dean's List Finalist

"Work until your idols become your rivals."
Reply With Quote
  #6   Spotlight this post!  
Unread 08-05-2014, 17:28
Brandon_L Brandon_L is offline
Back @ it again with the white vans
AKA: Brandon Liatys
FRC #2180 (Zero Gravity)
Team Role: Mentor
 
Join Date: Jan 2008
Rookie Year: 2007
Location: Newark, NJ
Posts: 1,207
Brandon_L has a reputation beyond reputeBrandon_L has a reputation beyond reputeBrandon_L has a reputation beyond reputeBrandon_L has a reputation beyond reputeBrandon_L has a reputation beyond reputeBrandon_L has a reputation beyond reputeBrandon_L has a reputation beyond reputeBrandon_L has a reputation beyond reputeBrandon_L has a reputation beyond reputeBrandon_L has a reputation beyond reputeBrandon_L has a reputation beyond repute
Re: [FF]: Draft Organization Stuff To Do

Quote:
Originally Posted by EricH View Post
--Automatic scoring (by team or by player)--I think there's an existing method, but IIRC it didn't work properly when I checked it for this year.
I'll take this on. Any specific ideas or requests?

Should I set it up so that you can look up points on teams by entering team number and week? i.e. like a get function such as get_points(2495,4) and it spits it right out? Any features you'd like to see?
__________________
FRC 2495 - Hamilton West Robotics [2007-2014] - whats a..."hive mind"?
FRC 3929 - Atomic Dragons [2012-2013]
FRC 2180 - Zero Gravity [2017-]

Just trying to collect all the possible team colors

Last edited by Brandon_L : 08-05-2014 at 17:31.
Reply With Quote
  #7   Spotlight this post!  
Unread 08-05-2014, 20:15
EricH's Avatar
EricH EricH is offline
New year, new team
FRC #1197 (Torbots)
Team Role: Engineer
 
Join Date: Jan 2005
Rookie Year: 2003
Location: SoCal
Posts: 19,823
EricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond repute
Re: [FF]: Draft Organization Stuff To Do

Quote:
Originally Posted by Brandon_L View Post
Should I set it up so that you can look up points on teams by entering team number and week? i.e. like a get function such as get_points(2495,4) and it spits it right out? Any features you'd like to see?
I'd go with a couple of different data access methods, namely by event, by team, and by team and week/event. There are various reasons to pull each of those.



What I'm currently working on: That random list pick. I think I can get it working in the next couple of weeks.


New projects, under Organization:
--I was just thinking it might be nice to be able to maintain an archive of all the drafts.
--And, for some of the Excel wizards out there: A method for updating an event's team list on command, highlighting new and removed teams.
--Something I might be able to do in off time would be to make a draft runner coverage calendar. Essentially, who's likely to be available on what night(s), and who's actually taking on the drafts, and who's NOT available. Low priority, mainly because it's pretty quick to set something like that up.



Question for going forwards: I've been thinking of tackling the list picks after I deal with the random list. Would folks prefer to view those in vertical or horizontal form, and would you rather have 'em on the main player list, in a separate tab, or right next to the drafting tier? (BTW, I don't think it'll be an issue to take lists in and swap 'em between vertical and horizontal. Excel has a method for going one way, I have a method for going the other way somewhere in an archive if I can find it.)
__________________
Past teams:
2003-2007: FRC0330 BeachBots
2008: FRC1135 Shmoebotics
2012: FRC4046 Schroedinger's Dragons

"Rockets are tricky..."--Elon Musk

Reply With Quote
  #8   Spotlight this post!  
Unread 08-05-2014, 21:33
Brandon_L Brandon_L is offline
Back @ it again with the white vans
AKA: Brandon Liatys
FRC #2180 (Zero Gravity)
Team Role: Mentor
 
Join Date: Jan 2008
Rookie Year: 2007
Location: Newark, NJ
Posts: 1,207
Brandon_L has a reputation beyond reputeBrandon_L has a reputation beyond reputeBrandon_L has a reputation beyond reputeBrandon_L has a reputation beyond reputeBrandon_L has a reputation beyond reputeBrandon_L has a reputation beyond reputeBrandon_L has a reputation beyond reputeBrandon_L has a reputation beyond reputeBrandon_L has a reputation beyond reputeBrandon_L has a reputation beyond reputeBrandon_L has a reputation beyond repute
Re: [FF]: Draft Organization Stuff To Do

Quote:
Originally Posted by EricH View Post
--I was just thinking it might be nice to be able to maintain an archive of all the drafts.
If a database is created through the draft managing program and uploaded somewhere easily accessible, that would be nice. That could further be combined with the scorer to create a live-updating ranking webpage
__________________
FRC 2495 - Hamilton West Robotics [2007-2014] - whats a..."hive mind"?
FRC 3929 - Atomic Dragons [2012-2013]
FRC 2180 - Zero Gravity [2017-]

Just trying to collect all the possible team colors
Reply With Quote
  #9   Spotlight this post!  
Unread 14-05-2014, 22:01
EricH's Avatar
EricH EricH is offline
New year, new team
FRC #1197 (Torbots)
Team Role: Engineer
 
Join Date: Jan 2005
Rookie Year: 2003
Location: SoCal
Posts: 19,823
EricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond repute
Re: [FF]: Draft Organization Stuff To Do

Status update: I *think* I have the random list pick functional. I'll pull a draft and see what it does before too long (read: sometime next week). If it works as planned, I can do some simplification elsewhere in the code.

OK, by "functional" I mean that it runs around and gets stuck on an empty list. Haven't tried it with teams or a draft loaded. I'm also trying to get the formatting to play nicely this time around.
__________________
Past teams:
2003-2007: FRC0330 BeachBots
2008: FRC1135 Shmoebotics
2012: FRC4046 Schroedinger's Dragons

"Rockets are tricky..."--Elon Musk

Reply With Quote
  #10   Spotlight this post!  
Unread 15-05-2014, 05:47
Brandon_L Brandon_L is offline
Back @ it again with the white vans
AKA: Brandon Liatys
FRC #2180 (Zero Gravity)
Team Role: Mentor
 
Join Date: Jan 2008
Rookie Year: 2007
Location: Newark, NJ
Posts: 1,207
Brandon_L has a reputation beyond reputeBrandon_L has a reputation beyond reputeBrandon_L has a reputation beyond reputeBrandon_L has a reputation beyond reputeBrandon_L has a reputation beyond reputeBrandon_L has a reputation beyond reputeBrandon_L has a reputation beyond reputeBrandon_L has a reputation beyond reputeBrandon_L has a reputation beyond reputeBrandon_L has a reputation beyond reputeBrandon_L has a reputation beyond repute
Re: [FF]: Draft Organization Stuff To Do

First run of the scorer, currently scrapes all the data needed using TBA API and builds it into a single array. I just need to start the actual scoring process. Replace the year and the event code with any valid combo. Please try to break it, and let me know if you find any inconsistencies or errors.

Planned features: Different scoring systems per year, each system is setup in an ini file. You'd be able to choose, for example, to look at the 2012 results with the 2012 FF scoring system or the current (2015?), whatever floats your boat.

Once the event scorer is done, I can create separate 'functions' such as pulling up only a specific team, ect. Suggestions welcome.

Because I'm flying by the seat of my pants and learning php as I go (this is my maybe my 3rd php project overall), criticism is welcome from anyone more knowledgeable. Source.
__________________
FRC 2495 - Hamilton West Robotics [2007-2014] - whats a..."hive mind"?
FRC 3929 - Atomic Dragons [2012-2013]
FRC 2180 - Zero Gravity [2017-]

Just trying to collect all the possible team colors

Last edited by Brandon_L : 15-05-2014 at 05:53.
Reply With Quote
  #11   Spotlight this post!  
Unread 20-05-2014, 09:47
BrennanB's Avatar
BrennanB BrennanB is offline
TBC is good at getting almost first
AKA: Brennan Bibic
FRC #4476 (W.A.F.F.L.E.S.)
Team Role: Mentor
 
Join Date: Jan 2012
Rookie Year: 2006
Location: Kingston
Posts: 1,300
BrennanB has a reputation beyond reputeBrennanB has a reputation beyond reputeBrennanB has a reputation beyond reputeBrennanB has a reputation beyond reputeBrennanB has a reputation beyond reputeBrennanB has a reputation beyond reputeBrennanB has a reputation beyond reputeBrennanB has a reputation beyond reputeBrennanB has a reputation beyond reputeBrennanB has a reputation beyond reputeBrennanB has a reputation beyond repute
Re: [FF]: Draft Organization Stuff To Do

Autodraft looks possible with Gdocs. Will investigate further. Sheets can remain hidden (I think) depending on who you are logged in as.

However if people have a problem with having a google account, that may be a problem.
__________________

Brennan Bibic - @b_bibic - Eh-Nalysis
10 years of inspiration compilation - W.A.F.F.L.E.S. #4476 YouTube Channel - 64 events and counting!

FRC 2013-2017 (W.A.F.F.L.E.S. Community Robotics #4476) - FLL 2006-2017 (W.A.F.F.L.E.S. #105) - VRC 2010-2013, 2015-2016 (W.A.F.F.L.E.S. #4476)
FRC 2009-2012 (K-Botics #2809)

Fantasy First 2014-2017 (The Breakfast Company) #TBCWin
2014 Dean's List Finalist

"Work until your idols become your rivals."
Reply With Quote
  #12   Spotlight this post!  
Unread 20-05-2014, 17:15
Brandon_L Brandon_L is offline
Back @ it again with the white vans
AKA: Brandon Liatys
FRC #2180 (Zero Gravity)
Team Role: Mentor
 
Join Date: Jan 2008
Rookie Year: 2007
Location: Newark, NJ
Posts: 1,207
Brandon_L has a reputation beyond reputeBrandon_L has a reputation beyond reputeBrandon_L has a reputation beyond reputeBrandon_L has a reputation beyond reputeBrandon_L has a reputation beyond reputeBrandon_L has a reputation beyond reputeBrandon_L has a reputation beyond reputeBrandon_L has a reputation beyond reputeBrandon_L has a reputation beyond reputeBrandon_L has a reputation beyond reputeBrandon_L has a reputation beyond repute
Re: [FF]: Draft Organization Stuff To Do

Quote:
Originally Posted by BrennanB View Post
Autodraft looks possible with Gdocs. Will investigate further. Sheets can remain hidden (I think) depending on who you are logged in as.

However if people have a problem with having a google account, that may be a problem.
How is the drafting program going to work? Is there any chance it could output the alliance(s) for a FF team into somewhere I can scrape it from? I'd be willing to work with whoever to make it happen
__________________
FRC 2495 - Hamilton West Robotics [2007-2014] - whats a..."hive mind"?
FRC 3929 - Atomic Dragons [2012-2013]
FRC 2180 - Zero Gravity [2017-]

Just trying to collect all the possible team colors
Reply With Quote
  #13   Spotlight this post!  
Unread 20-05-2014, 19:31
EricH's Avatar
EricH EricH is offline
New year, new team
FRC #1197 (Torbots)
Team Role: Engineer
 
Join Date: Jan 2005
Rookie Year: 2003
Location: SoCal
Posts: 19,823
EricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond repute
Re: [FF]: Draft Organization Stuff To Do

Quote:
Originally Posted by BrennanB View Post
Autodraft looks possible with Gdocs. Will investigate further. Sheets can remain hidden (I think) depending on who you are logged in as.
I'll see what I can do as far as getting the "backbone" in Excel macros. Found a trick the other day that ought to work wonders as far as automating some of the formatting/positioning. If hidden sheets can be done, it might be a good idea to have a "list input" sheet that will dump to a hidden sheet, if that can also be done.

Quote:
Originally Posted by Brandon_L View Post
How is the drafting program going to work? Is there any chance it could output the alliance(s) for a FF team into somewhere I can scrape it from? I'd be willing to work with whoever to make it happen
That would probably depend on exactly how it was set up. As-is, without an online component, I can probably set up a .csv file dump; copy/paste into a Gdoc, or some similar method. With an online component, shouldn't be too hard to rig one Gdoc to scrape another--bet I could do it with Excel, too, in terms of picking up data and dropping it off in a sheet.



BTW, random team macro testing has been delayed. I'll try and get to that later this week, then upload that version.
__________________
Past teams:
2003-2007: FRC0330 BeachBots
2008: FRC1135 Shmoebotics
2012: FRC4046 Schroedinger's Dragons

"Rockets are tricky..."--Elon Musk

Reply With Quote
  #14   Spotlight this post!  
Unread 21-05-2014, 08:00
BrennanB's Avatar
BrennanB BrennanB is offline
TBC is good at getting almost first
AKA: Brennan Bibic
FRC #4476 (W.A.F.F.L.E.S.)
Team Role: Mentor
 
Join Date: Jan 2012
Rookie Year: 2006
Location: Kingston
Posts: 1,300
BrennanB has a reputation beyond reputeBrennanB has a reputation beyond reputeBrennanB has a reputation beyond reputeBrennanB has a reputation beyond reputeBrennanB has a reputation beyond reputeBrennanB has a reputation beyond reputeBrennanB has a reputation beyond reputeBrennanB has a reputation beyond reputeBrennanB has a reputation beyond reputeBrennanB has a reputation beyond reputeBrennanB has a reputation beyond repute
Re: [FF]: Draft Organization Stuff To Do

Quote:
Originally Posted by EricH View Post
If hidden sheets can be done, it might be a good idea to have a "list input" sheet that will dump to a hidden sheet, if that can also be done.
I was considering having each FF team having their own hidden sheet so that they could make edits after without confusing the draft runner.


Quote:
Originally Posted by EricH View Post
With an online component, shouldn't be too hard to rig one Gdoc to scrape another--bet I could do it with Excel, too, in terms of picking up data and dropping it off in a sheet.
Yeah, I will look at scraping from on g-doc to another and if that is possible.

EDIT

So it seems hidden sheets are a no-go. However I did end up getting scraping working, so each team can have their own submission sheet. Currently I can pull from one sheet to another, and it updates pretty quickly, have a look.

Sample submission sheet #1
Sample submission sheet #2
Autodraft Testing

EDIT 2

I have it automatically removing already picked teams from the list for each team's first picks. It's not pretty work, but it's functional
__________________

Brennan Bibic - @b_bibic - Eh-Nalysis
10 years of inspiration compilation - W.A.F.F.L.E.S. #4476 YouTube Channel - 64 events and counting!

FRC 2013-2017 (W.A.F.F.L.E.S. Community Robotics #4476) - FLL 2006-2017 (W.A.F.F.L.E.S. #105) - VRC 2010-2013, 2015-2016 (W.A.F.F.L.E.S. #4476)
FRC 2009-2012 (K-Botics #2809)

Fantasy First 2014-2017 (The Breakfast Company) #TBCWin
2014 Dean's List Finalist

"Work until your idols become your rivals."

Last edited by BrennanB : 21-05-2014 at 09:31.
Reply With Quote
  #15   Spotlight this post!  
Unread 21-05-2014, 19:07
EricH's Avatar
EricH EricH is offline
New year, new team
FRC #1197 (Torbots)
Team Role: Engineer
 
Join Date: Jan 2005
Rookie Year: 2003
Location: SoCal
Posts: 19,823
EricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond repute
Re: [FF]: Draft Organization Stuff To Do

Quote:
Originally Posted by BrennanB View Post

EDIT 2

I have it automatically removing already picked teams from the list for each team's first picks. It's not pretty work, but it's functional
Any chance you can translate that into an Excel function, once you get the rest of the picks as well? That's on the to-do list--matter of fact, it's in a macro, but the macro never triggers for some reason, so I disabled it.
__________________
Past teams:
2003-2007: FRC0330 BeachBots
2008: FRC1135 Shmoebotics
2012: FRC4046 Schroedinger's Dragons

"Rockets are tricky..."--Elon Musk

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


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

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