Menu

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

Donate

Please Support Zebra Huddle!

Recent Posts

Re: JAMMER HELMET COVER by Stray Taco
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

JAMMER HELMET COVER by 3Beers
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

Re: Clamping down with the upper arm by bmd (2113)
June 12, 2019, 07:54:29 pm

Re: Ref facepaint by Major Wood
June 12, 2019, 04:16:34 pm

Re: Ref facepaint by Rego_Derby
June 11, 2019, 11:35:08 pm

Author Topic: Scrimmage Tracking Sheets  (Read 3601 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))
etc...
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.

http://woozle.org/derby/scrimmage.pdf

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: 3926
Views: 6408
Filesize: 327.61KB
Date: January 17, 2017, 04:21:03 am
Comments (0)
By: AdamSmasher
June 2013 Ruleset situational questions
Rating: *****
Downloads: 2550
Views: 5261
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: 2745
Views: 5874
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: 3537
Views: 5869
Filesize: 28.07KB
Date: April 25, 2013, 05:45:34 pm
Comments (0)
By: Shaun Ketterman

Powered by EzPortal