This is a scouting program I have been working on for the last year. It is fully tested and mature, it does statistics, match records, handles multiple events over multiple years (you can switch the database at least), and multiple people can work at the same time, with multiple devices (with a router or wireless router).
It is a PHP program that uses any CGI web server (I use apache2 and mod_php) and MySQL on Gentoo Linux (with no GUI or X11 to keep it fast, MySQL LOVES memory). I have been keeping version control with Git for only the last three months.
I have dedicated much focus to a great user interface that is simple and quick for stuff that needs to be fast (entering match data, looking up teams).
The
temporary demo is online (probably) from the laptop at
http://labs.redjacket.ws/. Please be kind to it, I haven't put it through any sort of stress testing yet. Select a database first, there are five databases with actual data (frc_2007_
whatever), and a sixth with all combined (frc_everything_2007, disabled for now).
A few features: Robot pictures can be viewed (and uploaded), SQL backups, match predicting can be done for all matches (future and completed) by clicking the "MP" link below the table on a match page (it predicts the correct team 90% of the time, and also gives a % certainty), a strength algorithm that shows how much a team contributes to their alliance's score (0 means average for that event, 1000 means 10 points roughly?), search for teams across all databases by number, official name/sponsor (
rookie teams), or nickname from the front page. The "query" page lets you execute real SQL (SELECT statements on databases starting with "frc_" only, haha) across the database. Very useful if you want refined statistics. You can sort teams by the official FIRST ranking or my own strength algorithm clicking on the headers on the team list.
I know it is great, please don't waste a post to say that
Please do post if you want to use it at a regional or suggest a feature. I want to have all match data for every regional entered this year, if you are able to record and upload all stats (penalties, per-team scores which there may be with live scoring this year, etc), please make that available.
If you want the source, you will need Git for now: git clone
http://labs.redjacket.ws/tools/scouting.git/
If you just want to view the source, try
Git-php, linked to on the front page.