Menu

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

Donate

Please Support Zebra Huddle!

Recent Posts

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

Re: Jammer's time in penalty box by 3Beers
February 01, 2020, 02:47:10 am

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

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

Author Topic: Entering Lineups from paperwork to spreadsheet  (Read 3924 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
Entering Lineups from paperwork to spreadsheet
« on: April 28, 2014, 01:59:27 am »
When you are entering the lineup paperwork into the spreadsheet, do you faithfully reproduce the paperwork entries or will you occasionally reorganize in order to make the results easier to read?

For example, in jam 1 where the blue team fields no pivot, the blocker in the pivot column goes to the box. The jam ends with her in the box and the in jam 2 the blue team fields a pivot. Would you rearrange the columns in jam 1 on the spreadsheet?

Original
1 X J1  B1/  B2  B3  B4
2    J2  P1   B2  B3  B1$

Rearranged
1    J1  B4  B2  B3  B1/
2    J2  P1  B2  B3  B1$

Or perhaps the lineup tracker just isn't interested in keeping the columns neat, and they are all over the place.

Do you rearrange, or do you faithfully recreate the paperwork?

Offline Charles Dickins

  • Jr. Member
  • **
  • Posts: 97
  • Stats Sheet: 3
  • NHRDHNSO
  • League Affiliation: New Hampshire Roller Derby
  • Referee Certification Level: Not Certified
  • NSO Certification Level: Level 2
Re: Entering Lineups from paperwork to spreadsheet
« Reply #1 on: April 28, 2014, 03:29:05 am »
I match the paperwork. If I were to reorganize (which would make the process even longer than it already is), I'd inevitably need to cross-reference something and that would take even longer because the spreadsheet doesn't match the paperwork.

(As a lineup tracker, I try to put a skater in the same column, if possible, just because I know that makes data entry easier, but that's not always something that can be done.)
Charles Dickins
NHRD - HNSO

Offline theMadStatter

  • Jr. Member
  • **
  • Posts: 67
  • Stats Sheet: 1
Re: Entering Lineups from paperwork to spreadsheet
« Reply #2 on: April 28, 2014, 03:53:53 pm »
I asked this at the clinic last summer in Madison and was told to mimic the paperwork (I had been reordering them to make it easier to follow).

Offline ShoNuff

  • Sr. Member
  • ****
  • Posts: 351
  • Stats Sheet: 29
  • League Affiliation: Mad Rollin' Dolls
  • Referee Certification Level: Not Certified
  • NSO Certification Level: Level 4
Re: Entering Lineups from paperwork to spreadsheet
« Reply #3 on: April 28, 2014, 06:28:18 pm »
I reorder to make the game stats easier to read.


Offline FNZebra

  • Superhero Member
  • **********
  • Posts: 1408
  • Stats Sheet: 35
  • I'm a shitty ref.
  • League Affiliation: Bleeding Heartland Roller Derby
  • Referee Certification Level: Not Certified
  • NSO Certification Level: Level 2
Re: Entering Lineups from paperwork to spreadsheet
« Reply #4 on: April 28, 2014, 06:33:55 pm »
I reorder to make the game stats easier to read.

I have found attempts at re-ordering to usually be confounded by later jams somehow, and make reconciling during data-entry harder.
You will bout as you practice.


Cheers,

FN Zebra
Bleeding Heartland Roller Derby (WFTDA)
Bloomington, Indianer

Offline ShoNuff

  • Sr. Member
  • ****
  • Posts: 351
  • Stats Sheet: 29
  • League Affiliation: Mad Rollin' Dolls
  • Referee Certification Level: Not Certified
  • NSO Certification Level: Level 4
Re: Entering Lineups from paperwork to spreadsheet
« Reply #5 on: April 28, 2014, 06:57:12 pm »
I reorder to make the game stats easier to read.

I have found attempts at re-ordering to usually be confounded by later jams somehow, and make reconciling during data-entry harder.
You have to reorder as a block.

I go down several jams, figure out the total scope of the ordering issue and then reorder to keep skaters who earned penalties in the same column.  I have been stymied by jams where 3 blockers entered the jam serving penalties and the team fielded no pivot, only to have the 4th blocker get a penalty that bridged into the next jam where the team fielded a pivot.  No way to get everyone to lineup nicely in that scenario, but that's about what it takes to make it impossible to tidy up the columns.

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
Re: Entering Lineups from paperwork to spreadsheet
« Reply #6 on: April 28, 2014, 08:37:18 pm »
Good to hear. I've been tidying up the paperwork, but then had a concern that it might be frowned on.

I can live with the numbers not lining up, but I just can't stand having a / without a $ (or S) right below it. It always makes me wonder if the Lineup Tracker made a mistake.

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: Entering Lineups from paperwork to spreadsheet
« Reply #7 on: April 28, 2014, 08:46:57 pm »
For example, in jam 1 where the blue team fields no pivot, the blocker in the pivot column goes to the box. The jam ends with her in the box and the in jam 2 the blue team fields a pivot.

Not a helpful in anyway, but: in my experience, the lineup tracker almost certainly dooms the non-pivot blocker who gets noted in the pivot column to a penalty that spans jams.
WFTDA-certified referee, level 2
Zebra Huddle moderator

Offline FNZebra

  • Superhero Member
  • **********
  • Posts: 1408
  • Stats Sheet: 35
  • I'm a shitty ref.
  • League Affiliation: Bleeding Heartland Roller Derby
  • Referee Certification Level: Not Certified
  • NSO Certification Level: Level 2
Re: Entering Lineups from paperwork to spreadsheet
« Reply #8 on: April 28, 2014, 08:54:53 pm »
Wait. Are you saying someone is changing the column used for a skater who is already in the box? While they are still serving?

You will bout as you practice.


Cheers,

FN Zebra
Bleeding Heartland Roller Derby (WFTDA)
Bloomington, Indianer

Offline Charles Dickins

  • Jr. Member
  • **
  • Posts: 97
  • Stats Sheet: 3
  • NHRDHNSO
  • League Affiliation: New Hampshire Roller Derby
  • Referee Certification Level: Not Certified
  • NSO Certification Level: Level 2
Re: Entering Lineups from paperwork to spreadsheet
« Reply #9 on: April 28, 2014, 09:07:06 pm »
Wait. Are you saying someone is changing the column used for a skater who is already in the box? While they are still serving?



Sometimes you have to. Black 27 is part of a four-blocker no-pivot line and is on the lineup sheet in the pivot column. Next jam has a pivot. Black 27 has to move to a different column. It happens with some regularity, although not as much now with 30-second penalties.
Charles Dickins
NHRD - HNSO

Offline The Gorram Reaver

  • Referee
  • Hero Member
  • *
  • Posts: 875
  • Stats Sheet: 60
  • League Affiliation: Mad Rollin' Dolls
  • Referee Certification Level: Level 2
  • NSO Certification Level: Not Certified
Re: Entering Lineups from paperwork to spreadsheet
« Reply #10 on: April 28, 2014, 09:35:58 pm »
Wait.  Now I'm confused.  When I've been line-up tracking (on paper), I have always reordered the lineup entry on my paperwork when a blocker in the [non-pivot jam] pivot column has a penalty service spanning jams.  This is what pencils and erasers are for.  Also, reordering my paperwork to have the skater in a single column for the duration of their penalty service makes it much easier to quickly reconcile number of box entries & exits with number of penalties issues, especially when penalty service spans multiple jams.

Are you all saying I shouldn't be doing this?  Or is it still OK to do this, but data entry in the statsbook should always match what's on paper, however it's entered?
The Gorram Reaver
Mad Rollin' Dolls, Madison, WI

Offline FNZebra

  • Superhero Member
  • **********
  • Posts: 1408
  • Stats Sheet: 35
  • I'm a shitty ref.
  • League Affiliation: Bleeding Heartland Roller Derby
  • Referee Certification Level: Not Certified
  • NSO Certification Level: Level 2
Re: Entering Lineups from paperwork to spreadsheet
« Reply #11 on: April 28, 2014, 09:37:34 pm »
I believe this is all about personal practices and preferences, at this point.
You will bout as you practice.


Cheers,

FN Zebra
Bleeding Heartland Roller Derby (WFTDA)
Bloomington, Indianer

 

Featured Product

 

Zebra Huddle Head Referee Bout Booklet

 

Featured Classifieds


ZH Files

How to Score a Point in Roller Derby
Rating: *****
Downloads: 4214
Views: 7057
Filesize: 327.61KB
Date: January 17, 2017, 04:21:03 am
Comments (0)
By: AdamSmasher
June 2013 Ruleset situational questions
Rating: *****
Downloads: 2767
Views: 5707
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: 2974
Views: 6508
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: 3799
Views: 7391
Filesize: 28.07KB
Date: April 25, 2013, 05:45:34 pm
Comments (0)
By: Shaun Ketterman

Powered by EzPortal