+- Ottawafoos - Ottawa's Foosball Community (http://forums.ottawafoos.com)
+-- Forum: Ottawa Foosball (http://forums.ottawafoos.com/forumdisplay.php?fid=1)
+--- Forum: Leagues (http://forums.ottawafoos.com/forumdisplay.php?fid=4)
+--- Thread: STATS (/showthread.php?tid=1522)
RE: STATS - Jester - 28-Nov-2013
rofl.
RE: STATS - 5barwarrior - 28-Nov-2013
stats updated
somethings are broken. I need to adjust the queries for the current tier rotation to show only the rotation weeks. Also the Individual game stats are out of date and only showing up to week 4 (view to table work not done yet).
I don't have time to fix this at the moment as I'm studying for my P.Eng. exam. When I get more time after Dec 7 or help, things will improve.
I can also go live off the server, but again, i need time to transfer the files and set this up properly.
Basically stay tuned.
RE: STATS - Jessica - 29-Nov-2013
(28-Nov-2013, 05:22 PM)deliverance Wrote: Well the Packer residence is the unofficial training centre on some off-foos nights. We have setup practice sessions and mini DYPs there in the past. You ladies should come out sometime.
We're game
RE: STATS - Jon - 29-Nov-2013
Why is Retro foos show up in tier 1? They moved down
RE: STATS - 5barwarrior - 29-Nov-2013
(29-Nov-2013, 09:00 AM)Jon Wrote: Why is Retro foos show up in tier 1? They moved down
5barwarrior Wrote:somethings are broken. I need to adjust the queries for the current tier rotation to show only the rotation weeks. Also the Individual game stats are out of date and only showing up to week 4 (view to table work not done yet).
RE: STATS - Jester - 29-Nov-2013
So pretty.
RE: STATS - 5barwarrior - 05-Dec-2013
I'll try to get to the stats this weekend but it may not be until Monday.
Sorry for the delay.
RE: STATS - 5barwarrior - 09-Dec-2013
stats updated
- fixed the rotation stats
- added colour code for teams that can move
- missing the three man sheet from last week.
RE: STATS - 5barwarrior - 09-Dec-2013
updated the individual stats.
I need to remove manual intervention from this step
RE: STATS - 5barwarrior - 10-Dec-2013
looks like I am missing week 7 for Mary against Refoos to Lose.
RE: STATS - Howwitzer - 10-Dec-2013
I'm unsure where the three team sheet went from last week. I know the point totals were something like:
14 Refoose to Lose, 5 We're new, 1 Foosbelles.
As for goals per game and such, my memory isn't that superb.
RE: STATS - 5barwarrior - 10-Dec-2013
I have the sheet now and will update at lunch. It takes Vern a while to figure out how to scan things and then send them by email. Plus he forgets with all of the foosball excitement sometimes
RE: STATS - garbaggio - 10-Dec-2013
Are these individual stats used to determine the draft order next Wednesday?
Taha
RE: STATS - 5barwarrior - 10-Dec-2013
Yes. I'll prepare a list that aggregates all of the data and generates an overall win% standings.
I've entered the missing two sheets and will publish the stats tonight.
RE: STATS - 5barwarrior - 10-Dec-2013
all fixed.
Looks like the doubles query is giving funny results. I'll take a look at that next.