How to use this spreadsheet

Sometimes it’s easier to view this much data in a spreadsheet where it can be manipulated and sorted. For example, if you are looking specifically for works that include trumpet and trombone, or works that don’t include tuba, you’ll have a much easier time using this spreadsheet than using the database interface.

Steps to use this spreadsheet:

1. Open this link.
2. Click the blue “Make a copy” button. This requires you to have a Google account; the spreadsheet will be saved in Google Sheets.
3. The spreadsheet will display data and then go blank
   • Hover over any of the green cells that say “#REF”
   • Click the green “allow access” button.
   • The most recent database data will appear.

Spreadsheet functionality:

• Taking notes: Please use column P (User Notes).
• Sorting: You can sort by any column. This means the spreadsheet can be ordered by ascending or descending values (length, number of singers, etc) in that column. To do this, click the small triangle in the desired column’s header, and select “sort ascending/descending.”
• Filtering works for specific instruments: You can also choose to include or exclude certain values.
  • Columns Q to AV display whether the voice type/instrument in the column header is required for the piece. Standard orchestra instruments have been listed already. 
    • You may use columns AO to AV to input instruments that haven’t been listed (ex. b.cl, pipa, electronics). Please note that you must use the exact name the instrument uses in the “Performance Forces” column for this to work. For example, you must type “b.cl” to find works with bass clarinet.
  • To show only pieces which include trumpet, for example, click the small triangle in the column header of the “Tpt” column (column AD). By default, both “true” and “false” are checked. By unchecking “false”, you will display only works which use trumpet works. By leaving only “false” checked, you will display only works which do not include trumpet.
  • To show only pieces which use both trumpet and trombone, for example, leave only “true” checked in both the “Tpt” and “Tbn” columns.
  • To show works which include trumpet and trombone but not tuba, for example, leave only “true” checked in both the “Tpt” and “Tbn” columns, and only “false” checked in the “Tba” column.
  • N.B.: This filtering only works for works in which the instrument names appear in the “Performance Forces” column. Works for “orchestra (2.2.2.2 – 4.3.3.1 – timp, pno – str)” for example will not display instruments correctly.

If you alter or type in any column with a white background, it could cause the data to display incorrectly.

Happy programming!