ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Marching Band Listening Vs Watching - Google Sheets Version
2
v.1.1.20190709
3
Mendel Lee
4
Credit:
5
This tool is based on the fine work of Brad Sparks and his interactive excel spreadsheet "Metronome Delay - Marching Band Listening Vs Watching".
6
A video explaining how his spreadsheet works and a link to his excel file is located at:
https://youtu.be/oWiXFYb2sqA
7
A video explaining how my spreadsheet works and the basics behind the Listening vs Watching concept is located at:
https://youtu.be/G2YNp5Va9DY
8
9
Overview:
10
In most competitive outdoor marching ensembles, the method for having the music ensemble sound together requires each performer to understand their listening versus watching responsibilities.
11
The defintiion of those responibilities is determined by where the Time Source is located on the field at any given point (most typically the battery percussion), where the Focal Point is located (i.e
12
where is the audience?), and where the conductor/drum major is located.
13
14
This spreadsheet defines those listening vs watching responsibilities in striped bands. This works under the assumption that the conductor is beating time according to the Time Source - typically,
15
conducting to the battery's feet or to their hands. This model does not work if the conductor *is* the Time Source or if the conductor is conducting to what they hear.
16
17
There are two versions of the spreadsheet - one in color and one in grayscale (to accommodate those that may be color blind).
18
19
This document is view-only to protect its original design, but you should be able to create a copy to use for your own purposes.
20
21
About:
22
Brad Spark's spreadsheet is amazing, but most of my productivity is centered around the Google Office Suite versus Microsoft Excel, so I wanted to create a Google Sheet version of his tool.
23
There are a few changes I made to Brad's original design:
24
25
1. Changed the formula design. Brad's formula threw every aspect of calculation into a single cell; I separated out different parts of the formula to different sheets (hidden) to make
26
it easier to debug/analyze/reverse engineer. I also optimized some of the data grabs relating to cell location by creating a "databox" which eliminated the need for the INDIRECT
27
object (which i personally hate).
28
2. This spreadsheet allows the conductor to be moved around in the same way that the focal point and the metronome does and adjusts the stripes accordingly.
29
3. The "Acceptable Error" paramater is looking for "number of notes that would evenly fill a 4/4 measure" instead of designating quarter notes as "1", eighth notes as "2", 16ths as
30
"4", etc. This felt more intuitive - entering "16" is 16th note Acceptable Error, entering "64" is a 64th note Acceptable error, etc.
31
32
This document is distributed under the CC BY SA-4.0 license.
https://creativecommons.org/licenses/by-sa/4.0/
33
Questions or issues can be directed to mendel at mendellee dot com.
34
35
Changelog:
36
0.9.091318.2113 - 95% complete.
37
0.91.091518.0730 - fixed 'cell bleed' that made black gridlines 'jagged'
38
0.92.091718.1230 - created color-blind friendly version of the sheet (but it's not yet linked to its own independent hidden sheets)
39
1.0.091818.1500 - color-blind friendly version complete. Expanded documention. First public launch.
40
1.1.20190609 - added video that explains this Google Sheet. Changed versioning model to something more standard
41
42
To Do:
43
-maybe try to find a way to dynamically label each stripe with performer directions?
44
-variable Hashes?
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