|
|
|
 Mentors are here to guide and explain not to decide and do. - Fe_Will [more] |
 |
|
|||||||
|
||||||||
This is a text file with the results for all the divisions plus the Championship Event matches in one file.
Every field (column) is separated by a Tab from the next field. Records (whole lines) are separated by Returns.
The file can be therefore be easily imported into a database program such ...
This is a text file with the results for all the divisions plus the Championship Event matches in one file.
Every field (column) is separated by a Tab from the next field. Records (whole lines) are separated by Returns.
The file can be therefore be easily imported into a database program such as Filemaker or Access, a spreadsheet or just opened with a word processing program. A database would probably provide the most flexibility as there are 2510 records (matches).
You can then search for any team, division, match type (qualifying, elimination, championship), etc.
The first field (column) counts the rows (records) and if you sort the file by the first field, all the records will be back in order.
The second field gives the Division or Championship.
The third field lists the Match Type.
The fourth field lists the Match Number.
The fifth field gives the scheduled time.
The sixth field gives the team number.
The seventh field gives the team's score.
Attached Files
-
Championship 20004 results for all divisions
1082618598championshipalldiv04.txt
download file
uploaded: 22-04-2004 03:23
filetype: txt
filesize: 131.26kb
downloads: 187
Discussion
view entire thread
23-04-2004 02:05
DougHogg
Re: White Paper Discuss: Championship 2004 results for all divisions
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).
view entire thread
Tags
loading ...