I got some time to work on my FIRSTXMLdb project (after catching up on some other projects) and I got the Fantasy FIRST automated scoring working. I scored it as described in
this post .
I uploaded the file (CMPff.xml) which has the current data about Championship with a FFscoring element. I assume FIRST has all the award data in the Saturday Awards since the Friday, & Thursday Award links don't work.
NOTE: My Program doesn't handle the WFA (worth 40pts) since it can't tell which team the winner mentors. Any award with a "-" for team number is thrown out.
The FF Categories Excel file shows how the FF pts were earned by category. It also demonstrates how the xml file can be read into excel and used as raw data.
A couple notes on categories:
- Divisions and Champ Winners and Finalists get their pts as awards (since they are listed as awards).
- Champ Winners (75 pts) and Finalists (60 pts) awards have 30 pts subtracted from them (so they are worth 45 & 30 pts) since a team has to win a Division Winner award (30 pts) to get there.
- Div Elim Level only awards 4pts to Divisional Quarter Finalists and 10 pts to Semifinalists. Finalists and Winners are handled by awards.
Please tell me if you find any errors in my calculations. I am still testing all this code and prepping it for an open-source release. I was going to release the .class file that does the scoring but it is a little confusing to use with the FFScoring template xml file (PM me if you want it)