Staff Counts - Revision history

Sammich: update for 2018

2019-06-08T14:59:22Z

update for 2018

← Older revision		Revision as of 07:59, 8 June 2019
Line 1:		Line 1:
	[[File:~~Staff_over_Time_2016~~.png]]		[[File:Staff_over_Time_2018.png]]


			<!--
			select year, sum(staff) as staff, sum(volunteer) as volunteers, count(user_id) as total
			from (
			select year, user_id, MIN(rank) < 7 as staff, MIN(rank) = 7 as volunteer
			from staff
			where active = 1
			group by year, user_id
			) as agg
			group by year
			order by year desc
			-->

	{\| class="wikitable" style="text-align: right;"		{\| class="wikitable" style="text-align: right;"
Line 9:		Line 21:
	\|-		\|-
	\| 2018		\| 2018
	\| 66		\| 56
	\| 40		\| 38
	\| ~~106~~		\| 94
	\|-		\|-
	\| 2017		\| 2017
	\| 80		\| 74
	\| 52		\| 51
	\| ~~132~~		\| 125
	\|-		\|-
	\| 2016		\| 2016
	\| 72		\| 72
	\| 50		\| 49
	\| ~~122~~		\| 121
	\|-		\|-
	\| 2015		\| 2015
	\| 73		\| 73
	\| 71		\| 68
	\| ~~144~~		\| 141
	\|-		\|-
	\| 2014		\| 2014
Line 45:		Line 57:
	\| 2011		\| 2011
	\| 77		\| 77
	\| 22		\| 20
	\| 99		\| 97
	\|-		\|-
	\| 2010		\| 2010
	\| 44		\| 44
	\| 54		\| 52
	\| 98		\| 96
	\|}		\|}

Beta: update staff figures

2019-06-08T14:22:12Z

update staff figures

@@ Line 7: / Line 7: @@
   ! Volunteers
   ! Total
   |-
   | 2016

Sammich: add a chart

2017-03-28T21:03:12Z

add a chart

← Older revision		Revision as of 14:03, 28 March 2017
Line 1:		Line 1:
			[[File:Staff_over_Time_2016.png]]


	{\| class="wikitable" style="text-align: right;"		{\| class="wikitable" style="text-align: right;"

Beta: create table

2017-03-28T21:01:07Z

create table

New page

{| class="wikitable" style="text-align: right;"
! Year
! Staff
! Volunteers
! Total
|-
| 2016
| 72
| 50
| 122
|-
| 2015
| 73
| 71
| 144
|-
| 2014
| 77
| 60
| 137
|-
| 2013
| 68
| 75
| 143
|-
| 2012
| 70
| 47
| 117
|-
| 2011
| 77
| 22
| 99
|-
| 2010
| 44
| 54
| 98
|}