Thread created automatically to discuss a document in the White Papers.
Championship 20004 results for all divisions by DougHogg
Hi all,
I uploaded a text file with all the championship matches in the one file. (There are 4 rows (records) for each match, one for each robot.) I figured this might come in handy for anyone making a video or wanting to review the results for some other reason.
The fields (columns) are separated by tabs and the rows (records) are separated by returns, so the file can easily be imported into a database program such as Filemaker, Access, Microsoft Works, Appleworks, etc. or into a spreadsheet or even a word processor. However a database would allow the most flexibility for sorting and searching.
The first field is a row number and if you sort the file by that number, everything will be back in order. The next field gives the division or championship, then comes match type (qualifying, elimination, championship), then match number, scheduled time, team# and score.
Examples:
To find a certain match in a certain division, you would have to find the division and the match as there will be 4 matches with the same number, one for each division.
If you want to find the total qualifying points for a team, find the team# and “Qualifying” in the Match Type column.
In Filemaker, I was able to have it give just the qualifying totals for each team and then sort by the results (which I posted earlier for the Teams averaging a 100 points per match).