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: Scrimmage Tracking Sheets  (Read 4275 times)

Offline GlamGirl

  • Newbie
  • *
  • Posts: 7
  • Stats Sheet: 0
  • League Affiliation: Sheffield Steel Rollergirls
  • Referee Certification Level: Not Certified
  • NSO Certification Level: Not Certified
Scrimmage Tracking Sheets
« on: August 05, 2011, 12:11:47 pm »
The league I NSO with have just created 2 teams and we are beginning to play closed intra-league bouts, partly to assess the balance of the teams but also to give less experienced skaters scrimmaging practice in a 'real bout' situation.

The problem I have run into is that we sometimes have more than 14 skaters on each team which messes with the WFTDA standard recording sheets. Does anyone know if there is something like a scrimmaging sheet which can be used for more than 14. I think that the stats produced offer a valuable insight into the balance of the teams and the areas that need work but currently in info that comes from the sheets with more than the standard number of players is kind of useless.

Alternatively, how tricky would it be to alter the current sheets. I'm ok with excel but am nervous about breaking formulas that run across several pages.

Offline SilkenTofu

  • NSO
  • Full Member
  • *
  • Posts: 105
  • Stats Sheet: 4
  • League Affiliation: Bleeding Heartland Rollergirls
  • Referee Certification Level: Not Certified
  • NSO Certification Level: Level 5
Re: Scrimmage Tracking Sheets
« Reply #1 on: August 05, 2011, 01:48:43 pm »
The tournament statsbook allows for up to 20 skaters. This is what I usually use for scrimmages, even when I've been given a roster of 14 ahead of time. We all know there will always be changes!
Bloomington, IN
WFTDA Level 5 Certified NSO
WFTDA Clinic Instructor, WFTDA Officials Committee member
MRDA Certification Committee

Offline theMadStatter

  • Jr. Member
  • **
  • Posts: 67
  • Stats Sheet: 1
Re: Scrimmage Tracking Sheets
« Reply #2 on: August 05, 2011, 05:52:50 pm »
Some of the derived stats get screwed up if you use more than 16 skaters (and, in fact, in one place it gets screwed up for the second alternate, i.e., skater 16).

Short version: part of the LU sheet was change from 20 to 16 skaters, and the change broke skater 16, and support for 17-20 doesn't exist in some places on the SK sheet

For those wanting the gory details (ignore if you hate gore):
Look at LU!AE9 through LU!AE28 (which is used to calculate the lead for away skater in period 1).
For skater 1 (LU!AE9) it is: IF(T25="","",IF(OR(SK!AD120="",SK!AD120=0),"",SK!AG120))
Skater 2 (LU!AE10) it is: IF(T10="","",IF(OR(SK!AD123="",SK!AD123=0),"",SK!AG123))
Skater 15 (LU!AE23) it is: IF(T23="","",IF(OR(SK!AD162="",SK!AD162=0),"",SK!AG162))
So far so good (i.e., increase SK!AD and SK!AG by 3 for each row).

However, when you get to skater 16 (the second alternate) LU!AE24 is: IF(T24="","",IF(OR(SK!AD177="",SK!AD177=0),"",SK!AG177))
And then LU!AE25 is: IF(T25="","",IF(OR(SK!AD180="",SK!AD180=0),"",SK!AG180))

Going to SK, it only goes up to 179 rows - so for LU!AE25 you are looking off the table. This, isn't really a problem, since that would only cause errors for skater 17 (which, of course, there isn't - clearly the sheet was designed for a roster of 20 skaters, and the last 4 are just hidden in the IBRF). But, while skater 15's data comes from SK!AD162, skater 16's data comes from SK!AD177 (which is actually the data for skater 20), while it should come from SK!AD165 (3 rows below SK!AD162).

Similar issues exist for LU:M24 (lead for home skater 16, period 1), as well as LU:M123 (lead for home skater 16, period 2), and LU:AE123 (lead for away skater 16, period 2). There are also similar problems for the irrelevant skaters 17-20 in those spaces as well.

Offline Q

  • Newbie
  • *
  • Posts: 6
  • Stats Sheet: 0
  • Now pay attention, 007.
  • League Affiliation: Los Alamos Derby Dames
  • Referee Certification Level: Not Certified
  • NSO Certification Level: Not Certified
Re: Scrimmage Tracking Sheets
« Reply #3 on: January 22, 2014, 04:48:59 pm »
I've made a scrimmage form that I use to run scrimmages all by myself (in other words, I'm the only NSO). It's challenging, definitely easier with a second NSO, but doable.

Note, this is just for tracking the absolute minimum. You can forget about getting any useful statistics with this form :)


Featured Product


Zebra Huddle Head Referee Bout Booklet


Featured Classifieds

ZH Files

How to Score a Point in Roller Derby
Rating: *****
Downloads: 4564
Views: 7830
Filesize: 327.61KB
Date: January 17, 2017, 04:21:03 am
Comments (0)
By: AdamSmasher
June 2013 Ruleset situational questions
Rating: *****
Downloads: 3057
Views: 6374
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: 3269
Views: 7350
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: 4096
Views: 9362
Filesize: 28.07KB
Date: April 25, 2013, 05:45:34 pm
Comments (0)
By: Shaun Ketterman

Powered by EzPortal