intruder

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: Errors in the March 2014 StatsBook  (Read 9221 times)

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: Errors in the March 2014 StatsBook
« Reply #15 on: March 19, 2014, 01:12:39 pm »
I guess that makes sense, but it sure was confusing when the B teams were playing the A game and the A teams were the B game.

That's why I just use 1 (for the first game of the evening) and 2 (for the second game of the evening).  Then I get the team names, and it's easy to see which game happens first, and therefore which paperwork I need to distribute first.
Bloomington, IN
WFTDA Level 5 Certified NSO
WFTDA Clinic Instructor, WFTDA Officials Committee member
MRDA Certification Committee

Offline Kilter The Grey

  • Newbie
  • *
  • Posts: 2
  • Stats Sheet: 0
  • League Affiliation: Raleigh Junior Rollers
Re: Errors in the March 2014 StatsBook
« Reply #16 on: March 20, 2014, 06:09:16 pm »
We are a new league (Raleigh Junior Rollers/JRDA) and had our first home bout last weekend. I download the new WFTDA Statsbook, entered the stats from the various NSO sheets and went to the LU tab and Bout Summary  - Data is not there.  The LU fields did not correctly populate, leading to all zero entries in bout summary.

Offline theMadStatter

  • Jr. Member
  • **
  • Posts: 67
  • Stats Sheet: 1
Re: Errors in the March 2014 StatsBook
« Reply #17 on: March 21, 2014, 06:53:53 pm »
The new standard practice for dealing with how to track box trips vs star passes is inconsistent with the new paperwork.
Quote
During a jam in which a Star Pass has been completed, the entry and/or exit of the Penalty Box on the Lineups sheet should only be recorded on the line of the current Jammer at the time they entered or exited the Penalty Box. For example, if a skater enters the Penalty Box during the initial Jammer’s time as Jammer, it gets recorded on that line. If they exit after the Star Pass has been completed, it gets recorded on the SP line as that of the current Jammer

The problem is there is no specified code for just "exiting" the box: There is "enter" (/), "enter + exit" (X), "start" (S), "start + exit" ($).

So should the SP line have just a "\" or "|" (the other half of the X or $)? (which seems correct, but not a valid code).

Or should that SP have the entire "X" or "$"? (which seems incorrect, since they didn't enter after the SP)

Offline Captain Emo

  • Newbie
  • *
  • Posts: 3
  • Stats Sheet: 0
  • League Affiliation: Independent
  • Referee Certification Level: Not Certified
  • NSO Certification Level: Not Certified
Re: Errors in the March 2014 StatsBook
« Reply #18 on: March 24, 2014, 06:16:04 pm »
The new standard practice for dealing with how to track box trips vs star passes is inconsistent with the new paperwork.
Quote
During a jam in which a Star Pass has been completed, the entry and/or exit of the Penalty Box on the Lineups sheet should only be recorded on the line of the current Jammer at the time they entered or exited the Penalty Box. For example, if a skater enters the Penalty Box during the initial Jammer’s time as Jammer, it gets recorded on that line. If they exit after the Star Pass has been completed, it gets recorded on the SP line as that of the current Jammer

The problem is there is no specified code for just "exiting" the box: There is "enter" (/), "enter + exit" (X), "start" (S), "start + exit" ($).

So should the SP line have just a "\" or "|" (the other half of the X or $)? (which seems correct, but not a valid code).

Or should that SP have the entire "X" or "$"? (which seems incorrect, since they didn't enter after the SP)

I am hardly the one to answer this, being the puppy I am, but this is what I get from this situation:
*If a skater goes in pre-Star Pass, I would say they get the "/" for "Skater entered the box this jam".
*Then as that skater is already in the box for the end of the Star Pass (not entering), they would either get a "S" or "$" based on their final position. "S" for "Skater began this jam from the box" if they didn't get out by the end of the jam, or "$" for "Skater began this jam from the box and then exited the box" if they served their time.

Obviously I'm happy to let someone correct me if I'm wrong. That's just how I see it.

~Emo
~Captain Emo

"It's better to be dead and cool, than alive and uncool" - Harley Davidson and the Marlboro Man

Offline Kilter The Grey

  • Newbie
  • *
  • Posts: 2
  • Stats Sheet: 0
  • League Affiliation: Raleigh Junior Rollers
Re: Errors in the March 2014 StatsBook
« Reply #19 on: March 25, 2014, 03:13:06 pm »
The workbook LU tab (and maybe others) doesn't handle a skater number "0" (Zero).  The totals for jammer and blocker occasions are summed incorrectly but the sheet.

If I change the skater number to another number and make corresponding changes in the score and lineup sheets the summing errors disappear.

Offline Sonny

  • Newbie
  • *
  • Posts: 2
  • Stats Sheet: 0
  • League Affiliation: Omaha Roller Girls
Re: Errors in the March 2014 StatsBook
« Reply #20 on: April 21, 2014, 05:13:58 pm »
One of our skaters found a bit of an issue with the "Points For/Against & Plus/Minus" section of the Bout Summary tab. Specifically, points were not registering for the second half. If you look at the LU cells that should provide that information, they're pulling from the wrong columns on the Lineup tab. They should be pulling jammer point totals from the hidden W and AW tabs, but they are instead looking at the X and AY tabs.

But don't make that correction. The points for the second half in the hidden Lineup tab columns add an extra 0 point jam and knock the last jam off the list. So the points are wrong on the Lineup tab. That's cool, though. You can work around it anyway. The corrections we made are below. I'm just giving you the first line of the range. You'll still need to change the $B### and  $U### numbers to match your current line.

LU O154 - O173
Are:
=IF($B154="","",SUMPRODUCT(--(Lineups!$C$50:$C$87=$B154),Lineups!$X$50:$X$87))
Should be:
=IF($B154="","",(SUMPRODUCT(--(SK!$C$88:$C$163=$B154),SK!$E$88:$E$163)))

LU AH154 - AH173
Are:
=IF($U154="","",SUMPRODUCT(--(Lineups!$AC$50:$AC$87=$U154),Lineups!$AY$50:$AY$87))
Should be:
=IF($U154="","",(SUMPRODUCT(--(SK!$S$88:$S$163=$U154),SK!$U$88:$U$163)))

LU O177 - O196
Are:
=IF($B177="","",SUMPRODUCT(--(Lineups!$C$50:$C$87=$B177),Lineups!$AY$50:$AY$87))
Should be:
=IF($B177="","",(SUMPRODUCT(--(SK!$C$88:$C$163=$B177),SK!$U$88:$U$163)))

LU AH177 - AH196
Are:
=IF($U177="","",SUMPRODUCT(--(Lineups!$AC$50:$AC$87=$U177),Lineups!$X$50:$X$87))
Should be:
=IF($U177="","",(SUMPRODUCT(--(SK!$S$88:$S$163=$U177),SK!$E$88:$E$163)))

Yes, there does appear to be an error here. We are investigating whether this is a desired solution. Please hold.....


Still Holding.... So what was the final verdict on this one?


 

Offline Sonny

  • Newbie
  • *
  • Posts: 2
  • Stats Sheet: 0
  • League Affiliation: Omaha Roller Girls
Re: Errors in the March 2014 StatsBook
« Reply #21 on: April 21, 2014, 05:21:02 pm »
The corrections I've made are below. I'm just giving you the first line of the range. You'll still need to change the $U### numbers to match your current line.



AH131 - AH150
Are:
=IF($B131="","",AH154-AH177)

Should be:
=IF($U131="","",AH154-AH177)

Offline Nick Bergus

  • Sr. Member
  • ****
  • Posts: 287
  • Stats Sheet: 10
  • League Affiliation: Old Capitol City Roller Girls
  • Referee Certification Level: Level 2
  • NSO Certification Level: Not Certified
Re: Errors in the March 2014 StatsBook
« Reply #22 on: April 22, 2014, 10:05:53 am »
I've locked this thread at the request of the masters of the StatsBook. The new versions have their own thread here
WFTDA-certified referee, level 2
Zebra Huddle moderator

 

Featured Product

 

Zebra Huddle Head Referee Bout Booklet

 

Featured Classifieds


ZH Files

How to Score a Point in Roller Derby
Rating: *****
Downloads: 3492
Views: 6313
Filesize: 327.61KB
Date: January 17, 2017, 04:21:03 am
Comments (0)
By: AdamSmasher
June 2013 Ruleset situational questions
Rating: *****
Downloads: 2504
Views: 5178
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: 2695
Views: 5787
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: 3478
Views: 5772
Filesize: 28.07KB
Date: April 25, 2013, 05:45:34 pm
Comments (0)
By: Shaun Ketterman

Powered by EzPortal