Forum: SolidWorks
03-11-2016, 17:10
|
|
Replies: 3
Views: 308
|
Forum: General Forum
29-10-2016, 18:18
|
|
Replies: 19
Views: 1,447
Re: Google Sheets OPR Calculator
I could do something like set A to the number of matches. I'm not sure if it's really worth it, or how much longer it'd take to set that many cells, but I guess that's the alternative.
Array values...
|
Forum: General Forum
28-10-2016, 17:50
|
|
Replies: 19
Views: 1,447
Re: Google Sheets OPR Calculator
Yep...I realized what you meant after I posted it.
I also figured out what's taking so much time: it's the repeated .getRange().setValue(). There's another function, setValues() that allows me to...
|
Forum: General Forum
28-10-2016, 01:40
|
|
Replies: 54
Views: 5,344
|
Forum: General Forum
27-10-2016, 21:43
|
|
Replies: 19
Views: 1,447
Re: Google Sheets OPR Calculator
Thank you both for your suggestions--I really appreciate the help. I finally had some time to go through them, and combined both suggestions (or at least think I did) in the code below. I'm not sure...
|
Forum: General Forum
25-10-2016, 20:43
|
|
Replies: 19
Views: 1,447
Re: Google Sheets OPR Calculator
My last run took about 50 seconds to finish, approximately broken down as follows:
1sec: get sheets, get ranges, initialize arrays, etc.
23sec: get unique team list, get alliance teams (T) and...
|
Forum: General Forum
25-10-2016, 19:47
|
|
Replies: 40
Views: 4,609
Re: The Best Team(s) in need of an event win/
I think for California, 696 is an obvious answer to this question:
They last won an event in 2007 at San Diego, but they've won a whole list of other awards since--3 quality, 3 industrial design, 1...
|
Forum: General Forum
25-10-2016, 18:58
|
|
Replies: 74
Views: 8,659
|
Forum: General Forum
25-10-2016, 15:48
|
|
Replies: 19
Views: 1,447
Re: Google Sheets OPR Calculator
Thank you! I'd found the UrlFetchApp class but it sounds like this might be easier, and I'll definitely look into including it.
|
Forum: General Forum
25-10-2016, 15:39
|
|
Replies: 19
Views: 1,447
Re: Google Sheets OPR Calculator
I'm forming matrices A, b, and T: T is the list of teams (Tx1), b is the list of scores (2Mx1), and A is a matrix of which teams were playing which matches represented as 0s and 1s (2MxT). I think...
|
Forum: General Forum
25-10-2016, 00:30
|
|
Replies: 19
Views: 1,447
Google Sheets OPR Calculator
I've been trying to find an easy way to calculate OPR (type in data, press a button, get OPRs) that would run on any device without requiring you to buy/download any program. After testing a couple...
|
Forum: Extra Discussion
21-10-2016, 19:48
|
|
Replies: 98
Views: 10,572
Re: paper: Stop the Stop Build
I beg to disagree.
*FRC* is a competition.
*FIRST* includes a competition (FRC).
There may be methods to pursue the FIRST mission that do not include a competition.
However, the method FRC chose...
|
Forum: General Forum
21-10-2016, 19:42
|
|
Replies: 69
Views: 6,380
Re: [FRC Blog] Stop Build Day Survey Results
I guess I was thinking of it more like teams who build practice robots presumably have the time/resources to work through bag and tag (compared to some single-robot teams who may not be able to...
|
Forum: General Forum
21-10-2016, 16:11
|
|
Replies: 69
Views: 6,380
Re: [FRC Blog] Stop Build Day Survey Results
Here's a visual representation of some of the breakdowns they provided but didn't graph (build one/multiple robots, in regionals/districts, rookie year).
I find it very interesting (and very weird)...
|
Forum: General Forum
18-10-2016, 14:53
|
|
Replies: 3
Views: 600
Re: Robot Build Log
TBA does currently let you add pictures/videos and link to social media sites. I thought there was some discussion previously about linking to CAD / code, but I can't find it so I might be wrong.
I...
|
Forum: Regional Competitions
15-10-2016, 00:21
|
|
Replies: 14
Views: 1,082
|
Forum: Off-Season Events
11-10-2016, 15:28
|
|
Replies: 30
Views: 3,959
Re: CalGames 2016
They are definitely firmer, which actually worked out for us since they were less likely to get stuck in the robot, but I could see that being a potential problem. I thought they also felt a bit...
|
Forum: Regional Competitions
07-10-2016, 01:56
|
|
Replies: 317
Views: 71,803
Re: Registration 2017
This appears to be fixed: 599 is now registered for Ventura, and I don't see 511 anywhere.
And quick summary of registered teams at CA regionals, as of 10:50pm using the old site (registered/total...
|
Forum: General Forum
29-09-2016, 16:56
|
|
Replies: 32
Views: 4,222
Re: Dream Alliance of Stronghold
I was going on about palindrome alliances at Chezy Champs for quite a long time. It's nice to know I'm not the only one into this.
Other alliances from common number series / number patterns:...
|
Forum: Off-Season Events
26-09-2016, 19:21
|
|
Replies: 134
Views: 34,019
Re: Chezy Champs 2016
Thank you to 254 for another amazing event. It's strange to think that this was the last Chezy Champs I'd attend as a student, but it was definitely a great last event and I hope to be back in the...
|
Forum: Off-Season Events
23-09-2016, 19:22
|
|
Replies: 134
Views: 34,019
Re: Chezy Champs 2016
For anyone interested in some last minute predictions/stats:
Using the preliminary match schedule and some component OPR / averages calculations, I ran some match predictions, which I used to...
|
Forum: General Forum
21-09-2016, 17:38
|
|
Replies: 5
Views: 651
Re: [C^3] Predicting Offseason Performance
I couldn't find an easy way to do that in excel, but I'll try to do that next time. The data is noisy, but it'd still be nice to have that to compare.
Thanks!
I totally blanked on that, but rule...
|
Forum: General Forum
20-09-2016, 00:16
|
|
Replies: 5
Views: 651
|
Forum: General Forum
20-09-2016, 00:14
|
|
Replies: 5
Views: 651
[C^3] Predicting Offseason Performance
Predicting Offseason Performance
The first regionals are still 163 days away, but Chezy Champs is coming up this weekend, marking the first of California's offseasons. Offseasons provide the...
|
Forum: General Forum
12-09-2016, 02:04
|
|
Replies: 7
Views: 1,100
Re: [C^3] 2016 CA Regionals Analysis
Yes, this is correct. Sorry for the bad wording on my part--it should say weakening not breaching for the colored lines.
Thank you to everyone else for your comments. I'm glad you guys like this!
|