2016 match data

[Ether]

For the benefit of those who would like to analyze the scoring data but don't know how to access the API and/or parse the XML/JSON responses, I've posted Excel CSV files here, so you don't have to "scrape" web pages to get the data you need.

[Cothron Theiss]

You're a gift, thank you.

[antillies85]

This is amazing! But I have a very newbie question for you. So looking at say MIKE's qualification match data, how would you use data to build a profile of which matches a team was involved with and the scores from that particular match? Would it be a pretty complicated set of vlookups to build that profile?

Thanks so much for compiling this! And we've been trying to look for ways to learn how to interact with the API but the tutorials are pretty thin. If you have any suggestions, that would be awesome.

[Ether]

Originally Posted by antillies85

So looking at say MIKE's qualification match data, how would you use data to build a profile of which matches a team was involved with and the scores from that particular match?

In the qual match CSV, Columns E thru J contain the Team Numbers r1,r2,r3,b1,b2,b3.

Say you want to find all of Team 469's matches in Week2 MIKE2 event.

Insert a new column right after Column J. Now you will have a new blank column K.

Put the heading "Team469" in cell K1.

Put the following formula in cell K2:

=IF(COUNTIF(E2:J2,"469"),1,0)

Copy cell K2 all the way down.

Now each cell in column K contains the value "1" if 469 played in that match, or a "0" if they did not.

Select all the cells in the spreadsheet, and sort by column K descending. All the matches that 469 played in will be displayed at the top of the spreadsheet.

Is that what you were asking?

[Ether]

There was an error in the original "Week1 Matches raw data". That file attachment has been removed, and a corrected version uploaded. Sorry for any confusion or inconvenience.

[antillies85]

Thank you! Yes, my brother mentioned doing that as well. Thank you for confirming that this is a good way to go about this. I'm trying to use Tableau to compile data and visualize it all.

Thank you for your help!

[Ether]

Originally Posted by antillies85

Thank you! Yes, my brother mentioned doing that as well. Thank you for confirming that this is a good way to go about this.

I'm not so sure it's a "good" way, but it's an quick-n-easy way.

In Excel, a better way would be to write a simple macro to pick each match that 469 played in, and copy it to a new sheet.

I'm trying to use Tableau to compile data and visualize it all.

I've never used Tableau. Does it have a macro language? If so, you might want to investigate that.

Thank you for your help!

You're welcome. Feel free to ask questions any time.

[Ether]

I should have mentioned in the OP:

Hat tip to Phil Lopreiato and Alex Herreid for their patient help.

[Firgreen]

I'm trying to use Tableau to compile data and visualize it all

There's no equivalent of macro calculations to VBA in Excel, though it does have some kind of data blending between different CSV sheets, as well as some flexibility in their table calculations.
But I've found the best way is to blend the data in Excel and then import into Tableau, which does require calculations and possibly macros.

[Caleb Sykes]

Originally Posted by Ether

For the benefit of those who would like to analyze the scoring data but don't know how to access the API and/or parse the XML/JSON responses, I've posted Excel CSV files here, so you don't have to "scrape" web pages to get the data you need.

Thank you very much.

[plnyyanks]

Originally Posted by Ether

For the benefit of those who would like to analyze the scoring data but don't know how to access the API and/or parse the XML/JSON responses, I've posted Excel CSV files here, so you don't have to "scrape" web pages to get the data you need.

Nice results! I've always appreciated your love of data and am always a fan of more numbers

Originally Posted by Ether

I should have mentioned in the OP:

Hat tip to Phil Lopreiato and Alex Herreid for their patient help.

Not a problem - I'm always happy to help! Glad you were able to find a solution that worked for you!

[Ether]

Just to let you all know:

I will be posting the complete Week3 raw data^* in CSV format within 18 hours after the last playoff match has been completed.


^*qual match schedule with surrogates; qual match final, foul, and auto scores; qual match scoring details; qual match team rankings with wins, losses, ties, and DQ; alliance selection with substitutions; playoff match schedule; playoff match scoring details; and awards

[Ether]

I wrote a script to scan through all the Scoring Details data (component scores) and pick out the high value in each category for week1 and week2. See attached.

I've not manually vetted this yet but I thought I'd post it for review by anyone interested.

[Ether]

Originally Posted by Ether

Just to let you all know:

I will be posting the complete Week3 raw data in CSV format within 18 hours after the last playoff match has been completed.

Week3 Raw Data CSV files have been compiled and posted here:

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


EDIT: attached is a compilation of hi component scores for week3.

[Ether]

Just posted Week3 District Rankings CSV files here.