The 25-year roster
The Google Spreadsheet filters can be used to investigate the concert summary list and the 25-year roster. Let's start with a specific example using the roster.
To initiate sorting and filtering, click on Data in the spreadsheet menu, then select "Filter views ... Create new temporary filter view"
 |
| Click image for full size view |
Each column in the spreadsheet now has a filter arrow at the top of each column near the column label. Clicking on the arrow opens the filter menu for that column:
Sort A to Z
Sort Z to A
Select All
Clear
Checkmarks for selecting rows with specific values of the filtered variable.
Here are some examples:
1. Who has played oboe and who were the early oboists?
Click the small arrow in the "Section" header box. Select "Filter: Clear" from the Section filter menu, then select “04 Oboe” and click "OK".
 |
| Click image for full size view |
The result shows there were 21 oboe players between 1982 and 2005.
 |
| Click image for full size view |
To sort by year, select “Sort A --> Z” from the First Year filter menu.
 |
| Click image for full size view |
The result shows that Jim Carpetas, Jeff Flagg, and Stephen Peckham played oboe in the 1982 band.
 |
| Click image for full size view |
To undo the selections and sorts, select “Select All” from filters where specific values had been selected and select “Sort Ascending” from the Order filter menu. To close the filter view, click the "X" at the right of the dark gray "Temporary filter" header.
Here are some other examples you might try:
2. In what years was Kevin Sedatole (now Director of Bands at Michigan State University) in the band?
Select “Clear” in the Last Name filter menu. Then scroll down and click “Sedatole” so that a checkmark appears in front of it. The listing shows that Kevin was on the 1987 through 1990 rosters and played trumpet.
3. Who was in the 2001 band?
Select “1” from the 2001 menu.
Concerts Summary
In the same way, Google Spreadsheet filters can be used to investigate the Concerts Summary.
Here are some examples:
1. How many times and when have we played Bennet’s Triumphal?
Select “Clear” in the Selection Name filter menu. Then scroll down and click “Bennet’s Triumphal” so that a checkmark appears in front of it. The listing shows that Bennet’s Triumphal was played twice in the 1996-1997 and in the 2009-2010 seasons.
2. To undo the selections and sorts, select “Select All” from filters where specific values had been selected and select “Sort Ascending” from the Order filter menu.
3. What have we played by Mark Camphouse?
Select “Clear” in the Composer filter menu. Then scroll down and click “Camphouse, M.” so that a checkmark appears in front of it. The listing shows that we have played A Movement for Rosa, Whatsoever Things, and Symphonic Prelude “The Cemetery at Colleville-sur-Mer.”
4. Who has conducted the band?
Select the Conductor filter menu and look at the list of names in the menu.
