All-
Now that we've established a good enough process to get the match results (next year we'll get more regionals LiVE) from the scoring db, the objective becomes let's turn all the "data" we have into useful "information."
The excel files and such that have been posted thus far are all a big step in the right direction. We're certainly glad to see the data being put to good use.
There are some charts SOAP does in excel also, but we haven't found a cool (and easy) way to do it Live on our site. Brio has plug-ins, coldfusion does have <cfgraph>, Java is an option, also Flash. If you have any good suggestions, let us know.
p.s. We had originally planned to allow a public read-only ODBC account straight into our DB, but that kinda got pushed back by higher priority stuff. So, if we did allow custom SQL statements to be executed in 2003, what creative (but useful) queries could you come up with?
(Don't worry, SQL SELECT statements are fairly easy and are written using plain english..... i.e. there's not to many fancy characters needed)
Regards,
SOAP Team - Team 108
Motorola & Dillard HS & Taravella HS
Plantation, FL
www.soap108.com