Statistics/sandbox
From UFFL Wiki
Mad is using this sandbox to review a variety of ways data can be imported from the DDSPF2021 MDB file (via MySQL) into meaningful information for the Wiki.
| Season Stats | ||||||
|---|---|---|---|---|---|---|
| Season | W | L | T | Win % | PF | PA |
| 2014 | 5 | 11 | 0 | 262 | 359 | |
| 2015 | 11 | 5 | 0 | 0.688 | 426 | 250 |
| 2016 | 10 | 6 | 0 | 0.625 | 378 | 266 |
| 2017 | 12 | 4 | 0 | 0.75 | 476 | 288 |
| 2018 | 10 | 6 | 0 | 0.625 | 407 | 305 |
| 2019 | 10 | 6 | 0 | 0.625 | 268 | 265 |
| 2021 | 9 | 4 | 1 | 0.679 | 350 | 298 |
| Total: | 67 | 42 | 1 | 0.665 | 2553 | 1733 |
| Records | |||||
|---|---|---|---|---|---|
| Record ID | Week | Season | Team | Versus | Value |
| 1 | 16 | 2019 | 8 | 5 | 28 |
| 2 | 9 | 2021 | 2 | 15 | 100 |
| 4 | 14 | 2015 | 8 | 9 | 444 |
| 5 | 14 | 2015 | 8 | 9 | 5 |
| 3 | 6 | 2016 | 8 | 10 | 3 |
| 6 | 10 | 2018 | 8 | 6 | 150 |
| 7 | 8 | 2016 | 8 | 12 | 87 |
| 0 | 16 | 2019 | 8 | 5 | 43 |
| 5 | 0 | 2019 | 8 | 0 | 26 |
| 7 | 0 | 2016 | 8 | 0 | 87 |
| 6 | 0 | 2018 | 8 | 0 | 97 |
| 3 | 0 | 2016 | 8 | 0 | 14 |
| 4 | 0 | 2015 | 8 | 0 | 3955 |
| 2 | 0 | 2016 | 8 | 0 | 63 |
| 1 | 0 | 2015 | 8 | 0 | 322 |
| 0 | 0 | 2015 | 8 | 0 | 532 |
| 0 | 0 | 2015 | 8 | 5 | 40 |
| 1 | 0 | 2015 | 8 | 9 | 27 |
| 2 | 0 | 2015 | 8 | 12 | 72 |
| 4 | 0 | 2015 | 8 | 12 | 523 |
| 5 | 0 | 2015 | 8 | 9 | 4 |
| 3 | 0 | 2015 | 8 | 5 | 2 |
| 6 | 0 | 2015 | 8 | 9 | 128 |
| 7 | 0 | 2015 | 8 | 12 | 98 |
Issues: - Convert/teamid is not working on the TeamID and VsTeamID columns - I do not know yet how to make the RecordID field meaningful (each number corresponds to a record type, and it may change depending on player position)
