ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Resources & Attribution:
2
Read John's post on his manager toolkit
3
4
All data in this spreadsheet is completely fabricated.
5
Created by John Cline
6
7
Instructions:
8
Create a copy of this spreadsheet (file -> make a copy). This WILL NOT copy the form, you will need to make a new form.
9
Update the spreadsheet location on A1 of the "Responses by Month" sheet to whatever your location is.
10
Create a new form for the responses sheet. You can view the current form here: https://docs.google.com/forms/d/e/1FAIpQLSeMjMlQ_Zw4D8FeI8sf0pGKs5oQkNaZD9EsHp2w_xoSK9P7HA/viewform
11
Columns Q-V on "Responses by Month" contain calculated values for each response to make for easier aggregation - if you change the questions, be sure to update those calculations.
12
Every survey period, add a new entry in the "Values" method and update your pivot table to include the new responses.
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100