Zebra Huddleâ„¢

Non-Skating Officials => General NSO Discussion => Topic started by: jmhgn on January 02, 2013, 08:39:59 pm

Title: New Statistics Package?
Post by: jmhgn on January 02, 2013, 08:39:59 pm
Has anyone created an updated Statistics Package in Excel for the new rule-set?  The latest version on wftda.com is from October and still has the minors in the Penalty Tracking section.  We are an unsanctioned league but use WFTDA rules and WFTDA paperwork.  We have a bout coming up in a couple of weeks and I want to be prepared.  I have some experience with Excel and I'm going to try and edit the existing workbook but I'm afraid my knowledge of Excel isn't where it needs to be.  I'm afraid that I am going to create something that will not total correctly.  If I am successful I will post my result.
Title: Re: New Statistics Package?
Post by: SilkenTofu on January 03, 2013, 12:58:33 pm
Worst-case scenario, you could use the old statsbook and just ignore the minor penalties section.  Then everything would still calculate properly.  You may have an issue if you need to record a Delay of Game penalty, but otherwise, it should still work.
Title: Re: New Statistics Package?
Post by: theMadStatter on January 03, 2013, 03:07:22 pm
I made a copy of the 1PT tab and then sliced and diced it up to hide the minors columns, condense into two pages, went to portrait mode, increased the size, swap the teams around (since the 1PT tab has period 1 and 2 for the same team horizontally adjacent) and then made some tweaks to get the jam number row to show up correctly.

The results are two pages, one for each period, with columns for each teams (filled in from ITRF page).

I still fill in the info into the main PT tab (since the info flows from there), but it works great otherwise.

If you want, I've added a link to to save you an hour or two of spreadsheet work:

NB:  This is not an official WFTDA statbook release in any way, shape or form, and I'd recommend only using it to prepare & print out the paperwork, and do not use it to submit the paperwork.

Never mind - use the real version now released!  It is chalk full of awesome (though portrait mode for the penalty tracker would let the rows be larger - I'm just saying...)
Title: Re: New Statistics Package?
Post by: Nick Bergus on January 04, 2013, 07:21:52 pm
The WFTDA has released its updated stats book (http://wftda.com/files/stats-book-01-2013.xlsx).
Title: Re: New Statistics Package?
Post by: Major Wood on January 04, 2013, 10:01:56 pm
Also available for download here.

http://www.zebrahuddle.com/index.php?action=downloads;sa=view;down=75 (http://www.zebrahuddle.com/index.php?action=downloads;sa=view;down=75)
Title: Re: New Statistics Package?
Post by: Insane Troll Logic on January 07, 2013, 10:44:17 pm
Please ignore the hint on the 'Call' column of the 'Score' page.

The hint can be found by hovering over the red square in the upper right corner of the first data box of the column and states:

Hint: Mark with "x" if jammer was declared lead and called jam before second pass.

Until WFTDA says otherwise, I would consider this to be incorrect and instead continue to use the instructions on bottom of the page which remain essentially unchanged from the previous stats package:

Call = Called Jam, when the listed jammer successfully calls off the jam before jam time runs out.  This is checked whether or not the jam was called legally.
Title: Re: New Statistics Package?
Post by: theMadStatter on January 08, 2013, 03:46:53 pm
We used the new paperwork for our bout last weekend and found a couple of minor heads up to be aware of:

Other niceties:

I have yet to explore the stat/calculation worksheets to see what's new or if there are any issues (we use a custom python script to parse the spreadsheets and produce internal webpages of stats).

And unrelated to the new paperwork, if the venue uses colored lighting to accent the bout theme (like say, red), expect any color coding to be useless

All in all, kudos to all involved in the improvements!!!
Title: Re: New Statistics Package?
Post by: Megapickle on January 08, 2013, 08:45:41 pm
Yep, all good stuff, except I dunno about the different colored Score sheet. Not experiencing that here (Win7, Office2010). All of ours came out the same shade of green.

Here is my "Print-Optimized" version, which per the advice on the last tab, I'll be using as my 'master' going forward. Bolded all white-on-black text. Minimized margins, maxed scaling uniquely on each sheet to 'just' fit. Fixed Action & Error periods.

(Disregard the wacky display of the doc there. Use "File > Download" to get the .xlsx file.)