paper: Event Schedule Analysis

Thread created automatically to discuss a document in CD-Media.

Event Schedule Analysis
by: Ether

For each event there are 2 spreadsheets which show how many times each team played with and against the other teams at that event.

[center]The spreadsheets are in CSV format.
They can be opened directly in Excel if file association is set.[/center]

At the top of the spreadsheet is a matrix showing how many times each team played with or against each other team at the event (qual matches only). Below the matrix is a row which shows the total sum of games played for each team. Below that row is a series of rows showing how many zeros, ones, twos, and threes are in the corresponding column in the matrix.

Week 1 & 2 event schedule (51.1 KB)
Week3 Event Schedule (32.2 KB)
Event Schedule Analysis Week5 (42.4 KB)
Event Schedule Analysis Week6 (34.7 KB)
Event Schedule Analysis Week4 (32.1 KB)
Week6 qual schedule (3.07 KB)
Event Schedule Analysis (11.2 KB)
Week7 Event Schedule Analysis (1.05 KB)

***Event Schedule Analysis for Week3 has been posted.**

***Event Schedule Analysis for Week4 has been posted.**

***Event Schedule Analyses for Weeks 5 and 6 have been posted.**

MELEW data in wk 6 includes Elim matches. I did not look at others.

This appears to include elimination matches.

We were in the elimination alliance with 1023 at Michigan Bedford, that’s why we played 8 matches with them.

And why we played 20 matches with our selves… 12 quals and 8 eliminations.

862 1 1 1 9 0 0 0 1 20 1 8 1 1 0 1 1 1 0 0 1 1 1 0 0 1 0 1 0 1 1 1 1 0 1 0 1 0 1 1

I believe MIBED does as well.

It seems that Ether’s data started including eliminations data after Week 3. Ether, do you plan to update weeks 4,5 and 6 with just qualification matches?

CO include elims for us.

Any way you could exclude elims?

Thanks for pointing that out.

I used an automated script for Weeks 4, 5 & 6.

I’ll debug the script and re-run it.

*I just posted corrected versions for Weeks 5 and 6. I spot-checked them. Hold my feet to the fire if I didn’t get it right.

Taking a look at Week4 next…

Week4 analysis is now posted.


I want to take this opportunity to thank you for your great analysis of all things FRC. The time you put in as well as the thought to your papers is greatly recognized and appreciated.

Thanks for the words of encouragement.

Any plans to make a summary spreadsheet like last year?

Sure. I was going to wait till the end of the season, as I did last year.


I added a summary for Week6. If it’s useful, I’ll do the same for weeks 1 through 5.

***Week7 analysis is now posted.**