Web-based scouting program

[Nibbles]

Originally Posted by SteveGPage

Can you share the algorithm that you used to do the match predictions? Thanks!
Best regards,
Steve

For the strength of team T, find all the matches played by team T (set B), find all the teams they played against or with (set C), and all the matches they played (set D), then find the average of their score minus opponents score (set E). Subtract the team T's average match score minus opponents score.

I have refined it several times over the last year, but that is how it works more or less. It also assumes that each team has an equal chance of competing against each other, which was not the case, as rookie teams always played with better teams boosting their score, and in a few cases the same alliance played together, It still fared very good however.

Let me try explaining another way: It takes into account the scores of your opponents and allies.

This is the exact SQL query used to find the strength for each team:

SELECT
  ROUND(AVG(IF(b.teamnum=c.teamnum ,2,-1)*IF(d.alliance="red",e.redscore-e.bluescore,e.bluescore-e.redscore)*IF(b.alliance=c.alliance,1,-1))*100) AS score2
FROM team_match b JOIN team_match c JOIN team_match d JOIN matches e
ON (b.matchid=c.matchid)
  AND (d.teamnum=c.teamnum AND d.matchid!=b.matchid)
  AND (d.matchid=e.matchid)
GROUP BY q.teamnum

This is in pages/strength.act.strength_2.php .

This is how I get the team strengths. Match predicting is a new area for me, I implemented it just a few month ago.
For matches, I found that the sum of the teams strengths on the target alliance, minus the sum of the opponent's alliance, works well enough.
I can calculate the chance a team will win with a cumulative logistic distribution, who's parent function is f(x) = 1/(1+e^(-x)).

My most recent tests show it is only 80% to 85% accurate, based on how I add the strengths together (add the square roots, etc). I don't really care too much, it isn't the most important part of the program.

[sebas2mil]

I am looking at it for 1251 as a scouting system

we are attending the florida regional and the palmetto regional

If it is useful at florida we will deff use it at palmetto

The only thing is that I'm having trouble setting it up

could I use access 2007

would that do the same thing as using that other software you wanted to use

thanks a lot

sebas

[Nibbles]

I'll summarize the PM I replied to for everyone else:
There is no reason Access couldn't work, however I can't vouch for it's standards support, and I have no clue how to set it up. It is possible though, since I use a database library (ADODB) that supports many types of databases.
I think installing a web server package such as XAMPP or WAMP, which contains Apache and MySQL, is much easier to set up and use.

[synth3tk]

Originally Posted by Nibbles

I'll summarize the PM I replied to for everyone else:
There is no reason Access couldn't work, however I can't vouch for it's standards support, and I have no clue how to set it up. It is possible though, since I use a database library (ADODB) that supports many types of databases.
I think installing a web server package such as XAMPP or WAMP, which contains Apache and MySQL, is much easier to set up and use.

I'm using XAMPP for Windows to build a network, so I'll try it out and see what happens. I've been looking for a good scouting database to integrate into our intranet. Hopefully it'll work out, I'll let you know.

[SteveGPage]

Originally Posted by Nibbles

I have refined it several times over the last year, but that is how it works more or less. It also assumes that each team has an equal chance of competing against each other, which was not the case, as rookie teams always played with better teams boosting their score, and in a few cases the same alliance played together, It still fared very good however.

Thanks! I will certainly incorporate this approach into how I do scouting! Thanks for sharing this!

Good luck this season!

Steve