DIR Return Create A Forum - Home
---------------------------------------------------------
Haxball Club Divisionals
HTML https://hcd.createaforum.com
---------------------------------------------------------
*****************************************************
DIR Return to: General Discussion
*****************************************************
#Post#: 7113--------------------------------------------------
Smart Statistics
DIR By: LimitedWard
Date: April 27, 2013, 6:05 pm
---------------------------------------------------------
[center]I present to you:
SMART STATISTICS 1.0[/center]
Demo program:
[img]
HTML https://docs.google.com/spreadsheet/oimg?key=0AgHR-hPqOz8-dHpEdHVrV2VBdjVmUnVZYzhJdUpKRUE&oid=1&zx=fuxm01xzz46a[/img]
To test this demo, go to
HTML https://docs.google.com/forms/d/1ZNAwpfUYzIYHZGwx_Agh6LFziXkqQOydqw--DZzMBCk/viewform#start=embed
HTML https://docs.google.com/forms/d/1ZNAwpfUYzIYHZGwx_Agh6LFziXkqQOydqw--DZzMBCk/viewform#start=embed.
What you are looking at is a table generated through the use of
Google Spreadsheets and the Google Chart Tools. The way it works
is there is a spreadsheet I made stored on Google Drive with
custom code to allow for increased ease of data tracking and
analysis. In other words, by submitting an answer to the form
(linked above under the demo program), the table shown above
will update it's information automatically. Because this is a
static image, you will have to reload this page after submitting
to the form in order to view your changes.
I will add yellow and red card functionality soon along with
point tracking because those appear to be the most complicated
of the bunch to make.
#Post#: 7114--------------------------------------------------
Re: Smart Statistics
DIR By: Lord of Fail
Date: April 27, 2013, 6:36 pm
---------------------------------------------------------
dosent seem that hard - just for the points column where you
have 3 pts for a win, 2 points for ot win, etc, have -1 pts for
yellow amd -2 for red. unless thats not how it works in which
case my comment is invalid
#Post#: 7115--------------------------------------------------
Re: Smart Statistics
DIR By: LimitedWard
Date: April 27, 2013, 6:52 pm
---------------------------------------------------------
--- Quote from: Lord of Fail link ---
>
> dosent seem that hard - just for the points column where you
have 3 pts for a win, 2 points for ot win, etc, have -1 pts for
yellow amd -2 for red. unless thats not how it works in which
case my comment is invalid
>
--- End Quote ---
Easier said than done, unfortunately. First it has to count how
many times a team receives a yellow/red card. Then it has to
convert that into a numerical value that the spreadsheet can
understand. Then it has to multiply those values as well as
wins/OT wins by their corresponding value in terms of points,
and finally it has to combine them all together.
#Post#: 7116--------------------------------------------------
Re: Smart Statistics
DIR By: LimitedWard
Date: April 27, 2013, 6:57 pm
---------------------------------------------------------
By the way someone calculated the standings incorrectly for both
United Talent (should be 3 pts) and for Detroit Recession
(should be 12). Unless the penalties were entered incorrectly,
of course.
#Post#: 7118--------------------------------------------------
Re: Smart Statistics
DIR By: Lord of Fail
Date: April 27, 2013, 7:29 pm
---------------------------------------------------------
--- Quote from: LimitedWard link ---
>
> By the way someone calculated the standings incorrectly for
both United Talent (should be 3 pts) and for Detroit Recession
(should be 12). Unless the penalties were entered incorrectly,
of course.
>
--- End Quote ---
no, its right
UT and DR both got 1 point in a draw
*****************************************************
Page 1 of 1