Spreadsheet: 63764d1264625933-report-generation-using-drop-down-menu-help-dummydata01272010
Sheet: Attendance

 | Name | Phone | Cell Phone | E-Mail | Book # | Liability Form | Receipt of Property Form | 2010-01-05 00:00:00 | 2010-01-07 00:00:00 | 2010-01-12 00:00:00 | 2010-01-14 00:00:00 | 2010-01-16 00:00:00 | 2010-01-19 00:00:00 | 2010-01-21 00:00:00 | 2010-01-26 00:00:00 | 2010-01-29 00:00:00 | 2010-01-30 00:00:00 | 2010-02-02 00:00:00 | 2010-02-04 00:00:00 | 2010-02-09 00:00:00 | 2010-02-11 00:00:00 | 2010-02-13 00:00:00 | 2010-02-16 00:00:00 | 2010-02-18 00:00:00 | 2010-02-20 00:00:00 | 2010-02-23 00:00:00 | 2010-02-27 00:00:00 | 2010-03-02 00:00:00 | 2010-03-04 00:00:00 | 2010-03-09 00:00:00 | 2010-03-11 00:00:00 | 2010-03-13 00:00:00 | 2010-03-16 00:00:00 | 2010-03-18 00:00:00 | 2010-03-23 00:00:00 | 2010-03-25 00:00:00 | 2010-03-27 00:00:00 | 2010-03-30 00:00:00 | 2010-04-01 00:00:00 | 2010-04-06 00:00:00 | 2010-04-08 00:00:00 | 2010-04-10 00:00:00 | 2010-04-13 00:00:00 | 2010-04-15 00:00:00 | 2010-04-20 00:00:00 | 2010-04-22 00:00:00 | 2010-04-24 00:00:00 | 2010-04-27 00:00:00 | 2010-04-29 00:00:00 | 2010-05-04 00:00:00 | 2010-05-06 00:00:00 | 2010-05-08 00:00:00 | 2010-05-11 00:00:00 | 2010-05-13 00:00:00 | 2010-05-15 00:00:00 | 2010-05-18 00:00:00 | 2010-05-20 00:00:00 | 2010-05-25 00:00:00 | 2010-05-27 00:00:00 | 2010-05-29 00:00:00 | Name | Total Present | Total Absences
1 | Ares, [NAME] | [PHONE] |  | [EMAIL] | 10 | Y | Y | Y | Y |  | Y | Y | Y | X | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ares, [NAME] | 6 | 1 | 0.8571428571428571
2 | [NAME], [NAME] | [PHONE] |  | [EMAIL] | 54 | Y | Y | Y | Y |  | Y | Y | Y | Y | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], [NAME] | 7 | 0 | 1
3 | Beland, [NAME] | [PHONE] |  | [EMAIL] | 53 | Y | Y | Y | Y |  | Y | Y | Y | Y | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Beland, [NAME] | 7 | 0 | 1
4 | [NAME], [NAME] | [PHONE] | [PHONE] | [EMAIL] | 58 | Y | Y | Y | X |  | X | X | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], [NAME] | 1 | 6 | 0.1428571428571428
5 | Cheeks, [NAME] | [PHONE] | [PHONE] | [EMAIL] | 66 | Y | Y | Y | Y |  | X | X | Y | X | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cheeks, [NAME] | 4 | 3 | 0.5714285714285714
6 | Copollo, [NAME] | [PHONE] |  | [EMAIL] | 50 | Y | Y | Y | Y |  | Y | X | Y | Y | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Copollo, [NAME] | 6 | 1 | 0.8571428571428571
7 | Crist, [NAME] | [PHONE] |  | [EMAIL] | 46 | Y | Y | Y | Y |  | Y | Y | Y | Y | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crist, [NAME] | 6 | 1 | 0.8571428571428571
8 | Degrauwe, [NAME] |  |  |  |  |  |  | - | - | - | - | - | - | - | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 1
9 | Ditchcreek, [NAME] | [PHONE] |  | [EMAIL] | 70 | Y | Y | Y | Y |  | Y | Y | Y | Y | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ditchcreek, [NAME] | 7 | 0 | 1
10 | Donnelly, [NAME] | [PHONE] | [PHONE] | [EMAIL] |  | Y | Y | Y | Y |  | Y | X | Y | X | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Donnelly, [NAME] | 5 | 2 | 0.7142857142857143
11 | [NAME], [NAME] |  |  |  |  |  |  | - | - | - | - | - | - | - | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 1
12 | [NAME], [NAME] | [PHONE] |  | [EMAIL] | 55 | Y | Y | Y | Y |  | Y | X | Y | X | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], [NAME] | 5 | 2 | 0.7142857142857143
13 | Elwood, Chad | [PHONE] |  | [EMAIL] | 45 | Y | Y | Y | Y |  | Y | Y | Y | Y | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Elwood, Chad | 7 | 0 | 1
14 | [NAME], [NAME] | [PHONE] |  | [EMAIL] |  |  |  | X | X |  | X | X | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], [NAME] | 0 | 7 | 0
15 | Frum, [NAME] | [PHONE] |  | [EMAIL] |  | Y | Y | Y | Y |  | X | X | Y | Y | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Frum, [NAME] | 5 | 2 | 0.7142857142857143
16 | Garpow, Stephen | [PHONE] |  | [EMAIL] |  |  |  | X | X |  | X | X | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Garpow, Stephen | 0 | 7 | 0
17 | [NAME], [NAME] | [PHONE] | [PHONE] | [EMAIL] | 67 | Y | Y | Y | Y |  | Y | Y | X | Y | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], [NAME] | 6 | 1 | 0.8571428571428571
18 | Gluszewski, Bradley | [PHONE] | [PHONE] | [EMAIL] | 47 | Y | Y | Y | Y |  | Y | X | Y | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gluszewski, Bradley | 4 | 3 | 0.5714285714285714
19 | [NAME], [NAME] | [PHONE] |  | [EMAIL] | 41 | y | y | - | - | - | Y | Y | Y | Y | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], [NAME] | 4 | 1 | 0.8
20 | Hardin, Tyrone | [PHONE] |  | [EMAIL] | 60 | Y | Y | Y | Y |  | Y | X | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hardin, Tyrone | 3 | 4 | 0.4285714285714285
21 | Hofman, [NAME] | [PHONE] |  | [EMAIL] |  |  |  | X | X |  | X | X | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hofman, [NAME] | 0 | 7 | 0
22 | Horton, [NAME] | [PHONE] |  | [EMAIL] | 56 | Y | Y | Y | Y |  | Y | Y | Y | Y | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Horton, [NAME] | 7 | 0 | 1
23 | [NAME], [NAME] | [PHONE] |  | [EMAIL] | 48 | Y | Y | Y | Y |  | Y | X | Y | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], [NAME] | 4 | 3 | 0.5714285714285714
24 | Huff, [NAME] | [PHONE] |  | [EMAIL] | 43 | Y | Y | Y | Y |  | Y | Y | Y | Y | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Huff, [NAME] | 7 | 0 | 1
25 | Ingram, Reuben | [PHONE] |  | [EMAIL] | 49 | Y | Y | Y | Y |  | X | Y | Y | Y | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ingram, Reuben | 6 | 1 | 0.8571428571428571
26 | [NAME], [NAME] | [PHONE] | [PHONE] | [EMAIL] | 61 | Y | Y | Y | X |  | Y | Y | Y | X | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], [NAME] | 5 | 2 | 0.7142857142857143
27 | [NAME], [NAME] | [PHONE] | [PHONE] | [NAME] | 68 | Y | Y | Y | Y |  | Y | Y | Y | Y | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], [NAME] | 7 | 0 | 1
28 | [NAME], [NAME] | [PHONE] |  | [EMAIL] |  |  |  | X | X |  | X | X | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], [NAME] | 0 | 7 | 0
29 | Krieger, [NAME] | [PHONE] | [PHONE] | [EMAIL] | 63 | Y | Y | Y | X |  | Y | Y | Y | Y | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Krieger, [NAME] | 6 | 1 | 0.8571428571428571
30 | Long, [NAME] | [PHONE] | [PHONE] | [EMAIL] | None | Y | Y | Y | Y |  | Y | Y | Y | Y | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Long, [NAME] | 7 | 0 | 1
31 | Luft, [NAME] | [PHONE] | [PHONE] | [EMAIL] | 59 | Y | Y | Y | X |  | Y | Y | Y | Y | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Luft, [NAME] | 5 | 2 | 0.7142857142857143
32 | Maicach, Tyler | [PHONE] | [PHONE] | [EMAIL] |  | Y | Y | Y | Y |  | Y | Y | X | Y | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maicach, Tyler | 6 | 1 | 0.8571428571428571
33 | [NAME], [NAME] | [PHONE] |  | [EMAIL] | 69 | Y | Y | Y | Y |  | Y | Y | Y | Y | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], [NAME] | 7 | 0 | 1
34 | Morgan, [NAME] | [PHONE] |  | [EMAIL] | 62 | Y | Y | Y | X |  | Y | Y | Y | Y | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], [NAME] | 6 | 1 | 0.8571428571428571
35 | Moskalick, [NAME] | [PHONE] |  | [EMAIL] | 57 | Y | Y | Y | Y |  | Y | Y | Y | Y | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Moskalick, [NAME] | 7 | 0 | 1
36 | Pagels, [NAME] | [PHONE] |  | [EMAIL] |  |  |  | X | Y |  | X | X | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pagels, [NAME] | 1 | 6 | 0.1428571428571428
37 | Panek, [NAME] | [PHONE] | [PHONE] | [EMAIL] | 65 | Y | Y | Y | Y |  | Y | Y | Y | Y | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Panek, [NAME] | 7 | 0 | 1
38 | Piazzo, [NAME] | [PHONE] |  | [EMAIL] | 52 | Y | Y | Y | Y |  | Y | Y | Y | Y | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Piazzo, [NAME] | 7 | 0 | 1
39 | Plummer, [NAME] | [PHONE] |  | [EMAIL] |  |  |  | X | X |  | X | X | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Plummer, [NAME] | 0 | 7 | 0
40 | Reiter, Derek | [PHONE] |  | [EMAIL] | None | Y | Y | Y | Y |  | X | Y | Y | Y | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Reiter, Derek | 6 | 1 | 0.8571428571428571
41 | [NAME], [NAME] | [PHONE] |  | [EMAIL] | 71 | Y | Y | Y | Y |  | Y | Y | Y | Y | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], [NAME] | 7 | 0 | 1
42 | Shrick,[NAME] | [PHONE] |  |  | 0 | Y | Y | Y | Y |  | Y | Y | Y | Y | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shrick,[NAME] | 7 | 0 | 1
43 | Sloan, [NAME] | [PHONE] |  | [EMAIL] | 64 | Y | Y | Y | X |  | Y | Y | Y | Y | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sloan, [NAME] | 6 | 1 | 0.8571428571428571
44 | [NAME], [NAME] | [PHONE] | [PHONE] | [EMAIL] | 51 | Y | Y | Y | Y |  | Y | Y | Y | X | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], [NAME] | 6 | 1 | 0.8571428571428571
45 | Thedans, [NAME] | [PHONE] |  | [EMAIL] |  |  |  | X | X |  | X | X | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Thedans, [NAME] | 0 | 7 | 0
46 | Vasquez, Angelica | [PHONE] |  | [EMAIL] |  |  |  | X | X |  | X | X | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vasquez, Angelica | 0 | 7 | 0
47 | Wise, [NAME] | [PHONE] |  | [EMAIL] | 72 | Y | Y | X | Y |  | Y | Y | Y | Y | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wise, [NAME] | 6 | 1 | 0.8571428571428571
48 | [NAME], [NAME] | [PHONE] |  | [EMAIL] |  |  |  | X | X |  | X | X | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], [NAME] | 0 | 7 | 0
49 | [NAME], [NAME] | [PHONE] |  | [EMAIL] |  |  |  | X | X |  | X | X | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], [NAME] | 0 | 7 | 0
 |  |  |  |  |  |  | TOTAL ATTENDANCE | 35 | 31 |  | 32 | 28 | 33 | 27 | 32 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.6752186588921284