Top 25 ETCs after Week 3

[mwtidd]

Here are the top 25 ETC | ERC | EMCs after week 3...

I'm curious to hear various opinions and insights .

Top Minibots:
1676, 395, 2056, and 1507 (EMC 19)

Top Robot:
148 (ERC 35)

The bold number is ETC, then ERC and finally EMC.

[Adam Freeman]

I assume this factors in the entire season...

Anyway you can pull out a team results by regional?

[wynniethepooh]

I would also be curious to see this on a week by week basis. we played terribly at our first regional due to no deployment+limited driver practice, but at Peachtree our OPR was 57.8. It would be nice to see how we and everone else has improved.

[mwtidd]

great points guys, I will work on changing it for an event by event basis, obvious need based on 67's second performance

Originally Posted by Adam Freeman

I assume this factors in the entire season...

Anyway you can pull out a team results by regional?

67 at west michigan:
ETC: 45.5
ERC: 32.5
EMC: 12.8

apparently you guys were a monster.

Originally Posted by wynniethepooh

I would also be curious to see this on a week by week basis. we played terribly at our first regional due to no deployment+limited driver practice, but at Peachtree our OPR was 57.8. It would be nice to see how we and everone else has improved.

unfortunately because of the tweet issue I dont have number for peachtree... sorry. Its as much a disappointment to me as it is for you.

I'll be working on changing the algorithm to only take the latest event ETC rather than overall ETC.

[speedbuggy76]

Can you provide the algorithm to calculate it for a given team at a given regional? I realize that it would be too difficult to do for everyone at Peachtree since the data isn't on Twitter, but we'd love to calculate it for ourselves to see where we stand.

Thanks!

[mwtidd]

Originally Posted by speedbuggy76

Can you provide the algorithm to calculate it for a given team at a given regional? I realize that it would be too difficult to do for everyone at Peachtree since the data isn't on Twitter, but we'd love to calculate it for ourselves to see where we stand.

Thanks!

Well to get your ETC you have to go through almost every team...

but in case your feeling ambitious:

As each match gets added to a DB, add the alliance points to a running sum for each team.

Team's total average = teams total / num matches

Then once all the matches have been added
loop back through all the matches again, but this time
calculate your portion of the contribution:

so say for red1:

red alliances average = ( red 1's avg + red2's avg + red 3s avg ) / 3
red 1's contribution = redScore * (red 1's avg / red alliances avg)

then add up all of your contributions and divide by the number of matches.

note I am working on a script to get the matches from the first site for events not tweeted...
however for those events you will only see etc
erc and emc can only be calculated with the twitter feed.

[mwtidd]

Top ETCs using teams latest events:

[wynniethepooh]

wow didnt expect to see us all the way up to 7th. that feels pretty good

[mwtidd]

Originally Posted by wynniethepooh

wow didnt expect to see us all the way up to 7th. that feels pretty good

just for the record, where these are estimates I would place you as a top 10 team... not necessarily #7 as there is only +-1 ETC point separates teams 4-10

If anything its more of an achievement because you are grouped with some truly amazing teams.


Tier 1: top 3
Tier 2: top 10
Tier 3: top 25

[speedbuggy76]

Alright, I've spent some time trying to re-create your calculations using the data from Peachtree. However, I keep getting a different number for our team (2415) than you do.

Some sample data:
In match 5, blue alliance scored 39 points and was composed of 2415, 1683, and 3694
2415's average alliance score: 77.1
1683's average alliance score: 26.2
3694's average alliance score: 7.1

The average score of the teams on the alliance = (77.1+26.2+7.1)/3 = 36.8

2415's contribution = 39*77.1/36.8 = 81.7

Is this correct? I ran this calculation for all of our matches and found us to have an average contribution of 119.2. This disagrees with your value of 38. Any idea what I'm doing wrong/differently?

Also, how did you break up the Peachtree data for our robot into ERC and EMC? I'm just using the data set on the FIRST website which only contains total alliance scores.

Thanks for putting all this together and answering questions! You have my interest piqued.

[mwtidd]

Originally Posted by speedbuggy76

Alright, I've spent some time trying to re-create your calculations using the data from Peachtree. However, I keep getting a different number for our team (2415) than you do.

Some sample data:
In match 5, blue alliance scored 39 points and was composed of 2415, 1683, and 3694
2415's average alliance score: 77.1
1683's average alliance score: 26.2
3694's average alliance score: 7.1

The average score of the teams on the alliance = (77.1+26.2+7.1)/3 = 36.8

2415's contribution = 39*77.1/36.8 = 81.7

Is this correct? I ran this calculation for all of our matches and found us to have an average contribution of 119.2. This disagrees with your value of 38. Any idea what I'm doing wrong/differently?

Also, how did you break up the Peachtree data for our robot into ERC and EMC? I'm just using the data set on the FIRST website which only contains total alliance scores.

Thanks for putting all this together and answering questions! You have my interest piqued.

Sorry, that's my mistake in the representation of the algorithm. You should use the total score for your alliance not the average...

so
(77.1+26.2+7.1)

instead of
(77.1+26.2+7.1)/3

*trying to run through it off the top of my head doesn't always work out

I have also thought about generating highs and lows, by removing a teams highest and lowest matches, to give an ETC window rather than a set value.

every match is tweeted to the FRCFMS twitter feed and it contains one extra piece of information the red and blue bonus, which is the points put up in the race. by knowing this I can use the same algorithm i use for etc, but use it on the bonus score and then the alliance score - the bonus score (robot score)

[The Lucas]

Originally Posted by speedbuggy76

the Peachtree data for our robot into ERC and EMC? I'm just using the data set on the FIRST website which only contains total alliance scores.

The Twitter feed includes Bonus (minibot) and Penalty points for each alliance, the FIRST site does not. FRC-Spy also uses the Twitter feed to get this info.

Mike could you do an OPR calculation on the Minibot data for comparison since you already have the bonus data from the twitter feed. I imagine it will skew toward the extremes, and work a little better at identifying the best minibot.