ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
This spreadsheet allows a user to enter information in the records tab, either as a date of the last physical exam or a checkbox to signify the information has been submitted. Conditional formatting is used to make it more clear who is missing what, especially as the data gets more complete.
2
3
The missing record list filters students if they are missing at least one record, then the total records missing are listed. The list can be enhanced to either automatically email parents with the information that is missing or use a button to generate the email for one or more parents.
4
5
6
7
8
9
10
11
12
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