[Deptheads] Info Sheets

[Ken Schrepfer]

Column can be added for the signup sheet.  We'll need to adjust procedure to make sure it gets utilized.
We can also extract data for no paperwork at any time.  Simply a matter of filtering out the games that have not been played and then finding which games don't have any data input into the standard columns. You could do this at your leisure as I always give your email full access to the payout sheets on google docs so that you have the ability to see where we are at any given time.
I'm working on trying to get the data in a local database so that I can access it better, but it needs to be local as I'm not sure what internet access will ever be available.  My plans are to be able to have local access but then write that data to the cloud for backup purposes and future access to past data.
DNRs are usually categorized in the Remarks section at the end of each line, provided we are given a reason.  We don't ever list that a game had no payout as the planned payout data on the sheet always shows 0s all the way though.  We mostly ignore event/sponsored/demo payout information which makes the data quicker to input.
Ken

> From: tparry at strategicon.net
> Date: Tue, 21 May 2013 22:39:07 -0700
> To: Deptheads at strategicon.net
> CC: 
> Subject: [Deptheads] Info Sheets
> 
> Hi All,
> 
> Based on the Payout data + additional info emailed to me, here is the progress on the paperwork.
> 
> 		# Events in system
> 		/# Events in sheet	#Winners data	#w no winners/yes paperwork	#no paperwork	% with no data
> BGs		427/429			253			77						99			23%
> CCGs	84/19			35			0						5			13%
> LARPs	8/0				0			0						0			100%
> Minis		49/8				7			0						1			13%
> RPGs	113/7			0			0						7			100%
> RPGAs	31/9				8			0						1			11%
> VGs		19/20			4			0						16			80%
> Paint		13				11			0						2			15%
> Costume	1				0			0						1			100%
> 
> Notice the "no paperwork" column. Ken, is there a way you could print out at least once a day (more often as requested) the events with no paperwork at that point.
> 
> GMs need to be accountable. We need to figure out a way for each department to track the paperwork, and get the point across that incomplete paperwork is grounds for no badge reimbursement.
> 
> Also, Ken, on a related note, can you have a column on the spreadsheet that you can just x when the signup sheet for an event crosses your path with or without a winners sheet. Or, if you are willing a head count number from the sheet, with 0 being blank sheet and blank field being no sheet.
> 
> While the Payout Crew's primary task is processing and paying out tournaments, they also enter certain data for non-paying events.
> 
> Everyone, it doesn't matter what the event is, a signup sheet should be submitted to payouts, this includes demos, RPGs, LARPs, etc.
> Also, there should be a sheet with the winners names and numbers, or why no winners. Why, you ask, because, we want to know things like which events did and didn't run and why. Things like demos, rpgs and larps should just note somewhere (and make sure the payouts crew is aware of where) that the event ran or not.
> 
> Examples of why not:
> DNR - No players
> DNR - Not enough players
> DNR - No GM
> Ran - no winners
> 
> Now, all this being said, some of this paperwork probably exists and just hasn't come to my attention for one reason or another, and being as I wasn't at Orccon, it's even harder to tell.
> 
> Thanks for all the help in getting this far.
> 
> Tanya
> _______________________________________________
> Deptheads mailing list
> Deptheads at strategicon.net
> http://mordred.punk.net/mailman/listinfo/deptheads
 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mordred.punk.net/pipermail/deptheads/attachments/20130522/21cbc313/attachment.htm