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


Please Support Zebra Huddle!

Recent Posts

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

Resources for new referees. by Destructor
November 26, 2019, 06:01:48 pm

Jammer Passing Inactive Jammers by hellvis
November 14, 2019, 03:37:30 am

October 03, 2019, 12:54:03 pm

Clover Cup 2020 - March 20-22 - North Richland Hills, TX USA by SodOff
September 28, 2019, 10:09:13 am

September 22, 2019, 12:35:26 pm

Re: "Pincer" blocks = multipayer? by Bluebeard
July 11, 2019, 06:30:49 pm

"Pincer" blocks = multipayer? by Rego_Derby
July 11, 2019, 01:08:36 am

Re: Jammer Scoring Theory by Major Wood
June 26, 2019, 09:59:33 pm

Jammer Scoring Theory by Rego_Derby
June 25, 2019, 04:30:03 am

Author Topic: Scrimmage Tracking Sheets  (Read 3713 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: 3985
Views: 6581
Filesize: 327.61KB
Date: January 17, 2017, 04:21:03 am
Comments (0)
By: AdamSmasher
June 2013 Ruleset situational questions
Rating: *****
Downloads: 2593
Views: 5368
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: 2793
Views: 6010
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: 3588
Views: 5994
Filesize: 28.07KB
Date: April 25, 2013, 05:45:34 pm
Comments (0)
By: Shaun Ketterman

Powered by EzPortal