ZH Classifieds
ZH Files
ZH Staff
WFTDA 12/1/2014 Rules
WFTDA 3/1/2014 Rules


Please Support Zebra Huddle!

Recent Posts

London Roller Derby Referee Sessions by 3Beers
July 14, 2020, 01:34:46 pm

Re: Jammer's time in penalty box by 3Beers
April 26, 2020, 09:46:33 pm

Getting officials attention by Rego_Derby
March 03, 2020, 04:05:02 am

Re: Jammer's time in penalty box by Major Wood
February 05, 2020, 05:52:31 pm

Jammer's time in penalty box by 3Beers
January 29, 2020, 03:33:20 am

Nashville Roller Derby 2020 Scrimmage-A-Thon - 7/11/2020 by Major Wood
January 27, 2020, 09:36:38 pm

Re: Rule clarification by 3Beers
January 26, 2020, 08:09:00 pm

Re: Rule clarification by Bluebeard
January 17, 2020, 05:26:46 am

Rule clarification by 3Beers
December 28, 2019, 06:04:00 pm

Re: Resources for new referees. by Destructor
November 29, 2019, 01:13:40 pm

Author Topic: First time filling out the stats book - help please  (Read 1788 times)

Offline DocSkinner

  • Full Member
  • ***
  • Posts: 104
  • Stats Sheet: 2
  • League Affiliation: Kansas City Roller Warriors
  • Referee Certification Level: Not Certified
  • NSO Certification Level: Level 2
First time filling out the stats book - help please
« on: March 05, 2013, 07:10:33 pm »
OK, in the past I've just handed off all of the paperwork to our archivist who handled all of the data entry. Now I am attempting to fill in the stats book myself and am confused. I think I have it mostly figured out, but some of the numbers don't add up.

I have it narrowed down to what looks like a problem with a hidden worksheet called "SK". This is a space for the backend tabulation that needs to happen to get the summary stats. My problem is that it only has room for 38 jams.  Period 1 has 21 jams, and those stats are all correct. Then Period 2 has 21 more jams, but the last four don't get tabulated because there are only 38 rows and I have 42 jams. So while the final score is correct, none of the stats related to score are correct on the Bout Summary sheet.

One thing I noted is that the part of worksheet SK that calculates Period 2 includes 21 blank lines. That got me thinking that maybe the problem is that I numbered the jams in Period 2 starting with "22". Is that the problem? That pushes the data down to row 22 in the SK worksheet and it runs out of space. But I tried going back and renumbering my Period 2 jams as 1-21 and it didn't change the worksheet.

Edit: UGH, nevermind any of this.  I figured it out.  the spreadsheet was defaulted to not recalculate until saving.  As soon as I saved with the new jam numbers it was all right.

Lesson learned: restart jam numbers in the new period, even though our scoreboard keeps a running total.
« Last Edit: March 05, 2013, 07:14:29 pm by DocSkinner »

Offline Numb3r Crunch3r

  • Sr. Member
  • ****
  • Posts: 391
  • Stats Sheet: 13
  • League Affiliation: Sun State Roller Girls
  • Referee Certification Level: Level 2
  • NSO Certification Level: Not Certified
Re: First time filling out the stats book - help please
« Reply #1 on: March 05, 2013, 09:48:43 pm »
Also - if you're using the Carolina scoreboard, it has an option to tick which resets jam number count at half time - solves all the problems!


Featured Product


Zebra Huddle Head Referee Bout Booklet


Featured Classifieds

ZH Files

How to Score a Point in Roller Derby
Rating: *****
Downloads: 4506
Views: 7636
Filesize: 327.61KB
Date: January 17, 2017, 04:21:03 am
Comments (0)
By: AdamSmasher
June 2013 Ruleset situational questions
Rating: *****
Downloads: 3011
Views: 6189
Filesize: 29.71KB
Date: February 07, 2014, 04:57:32 pm
Comments (2)
By: Crash Test Ref
Rules Q&A and Publications for 6/15/13 Document
Rating: (None)
Downloads: 3215
Views: 7139
Filesize: 26.27KB
Date: August 02, 2013, 04:10:40 pm
Comments (0)
By: Shaun Ketterman
Rules Q&A and Publications for 1/1/13 Document (4/24/13 Updates)
Rating: *****
Downloads: 4038
Views: 9160
Filesize: 28.07KB
Date: April 25, 2013, 05:45:34 pm
Comments (0)
By: Shaun Ketterman

Powered by EzPortal