Go to Post It doesn't take money, just desire. - BillP [more]
Home
Go Back   Chief Delphi > CD-Media > White Papers
CD-Media   CD-Spy  
portal register members calendar search Today's Posts Mark Forums Read FAQ rules

photos

papers

everything



Event Qual Schedule Analysis

Ether

By: Ether
New: 13-03-2014 13:27
Updated: 16-04-2014 20:11
Total downloads: 1090 times


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


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

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.

Attached Files

  • zip Event Schedule Analysis Weeks 1 & 2

    Week 1 & 2 event schedule analysis.zip

    downloaddownload file

    uploaded: 13-03-2014 13:27
    filetype: zip
    filesize: 51.09kb
    downloads: 307


  • zip Event Schedule Analysis Week 3

    Week3 Event Schedule Analysis.zip

    downloaddownload file

    uploaded: 16-03-2014 13:16
    filetype: zip
    filesize: 32.16kb
    downloads: 161


  • zip Event Schedule Analysis Week5

    Event Schedule Analysis Week5 revA.zip

    downloaddownload file

    uploaded: 07-04-2014 15:57
    filetype: zip
    filesize: 42.45kb
    downloads: 103


  • zip Event Schedule Analysis Week6

    Event Schedule Analysis Week6 revA.zip

    downloaddownload file

    uploaded: 07-04-2014 16:01
    filetype: zip
    filesize: 34.66kb
    downloads: 191


  • zip Event Schedule Analysis Week4

    Event Schedule Analysis Week4 revA.zip

    downloaddownload file

    uploaded: 08-04-2014 10:12
    filetype: zip
    filesize: 32.09kb
    downloads: 93


  • zip Week6 Qual Schedule Summary

    Week6 qual schedule summary.zip

    downloaddownload file

    uploaded: 10-04-2014 17:03
    filetype: zip
    filesize: 3.07kb
    downloads: 87


  • zip Event Schedule Analysis Week7

    Event Schedule Analysis Week7.zip

    downloaddownload file

    uploaded: 11-04-2014 09:29
    filetype: zip
    filesize: 11.16kb
    downloads: 82


  • zip Week7 Qual Schedule Analysis Summary

    Week7 Event Schedule Analysis Summary.zip

    downloaddownload file

    uploaded: 16-04-2014 20:11
    filetype: zip
    filesize: 1.05kb
    downloads: 64



Recent Downloaders

  • Guest

Discussion

view entire thread

Reply

16-03-2014 13:18

Ether


Unread Re: paper: Event Schedule Analysis


Event Schedule Analysis for Week3 has been posted.

http://www.chiefdelphi.com/media/papers/2971




24-03-2014 18:23

Ether


Unread Re: paper: Event Schedule Analysis


Event Schedule Analysis for Week4 has been posted.

http://www.chiefdelphi.com/media/papers/2971





07-04-2014 14:56

Ether


Unread Re: paper: Event Schedule Analysis


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

http://www.chiefdelphi.com/media/papers/2971





07-04-2014 15:23

engunneer


Unread Re: paper: Event Schedule Analysis

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



07-04-2014 15:27

msaunders


Unread Re: paper: Event Schedule Analysis

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



07-04-2014 15:32

Debbie


Unread Re: paper: Event Schedule Analysis

Quote:
Originally Posted by engunneer View Post
MELEW data in wk 6 includes Elim matches. I did not look at others.
I believe MIBED does as well.



07-04-2014 15:39

jlmcmchl


Unread Re: paper: Event Schedule Analysis

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?



07-04-2014 15:39

Mastonevich


Unread Re: paper: Event Schedule Analysis

CO include elims for us.

Any way you could exclude elims?



07-04-2014 15:41

Ether


Unread Re: paper: Event Schedule Analysis

Quote:
Originally Posted by engunneer View Post
MELEW data in wk 6 includes Elim matches. I did not look at others.
Thanks for pointing that out.

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

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




07-04-2014 16:04

Ether


Unread Re: paper: Event Schedule Analysis


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...




08-04-2014 10:13

Ether


Unread Re: paper: Event Schedule Analysis

Quote:
Originally Posted by Ether View Post
Taking a look at Week4 next...
Week4 analysis is now posted.

http://www.chiefdelphi.com/media/papers/2971




08-04-2014 11:16

techtiger1


Unread Re: paper: Event Schedule Analysis

Ether,

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.



08-04-2014 11:23

Ether


Unread Re: paper: Event Schedule Analysis

Quote:
Originally Posted by techtiger1 View Post
Ether,

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.




08-04-2014 20:31

Joe Ross


Unread Re: paper: Event Schedule Analysis

Any plans to make a summary spreadsheet like last year?



09-04-2014 10:01

Ether


Unread Re: paper: Event Schedule Analysis

Quote:
Originally Posted by Joe Ross View Post
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.





10-04-2014 17:05

Ether


Unread Re: paper: Event Schedule Analysis

Quote:
Originally Posted by Joe Ross View Post
Any plans to make a summary spreadsheet like last year?
Joe,

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

http://www.chiefdelphi.com/media/papers/2971




11-04-2014 09:31

Ether


Unread Re: paper: Event Schedule Analysis


Week7 analysis is now posted.

http://www.chiefdelphi.com/media/papers/2971





view entire thread

Reply

Tags

loading ...



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

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