|
Composition List and General Reports
|
| Name |
Type |
Download |
Info |
Sample |
Date |
ASCAP
/ BMI Programs for quarterly submission
|
 |
VFP
|
SQL
|
 |
|
19.Jul.02
|
MOLA
Repertoire Rept. Output
|
 |
VFP
|
SQL
|
 |
|
26.Jun.02
|
NEA "Representative
Programming" - list / schedule of performances and repertoire for grants such as those for
the NEA
|
 |
VFP
|
SQL
|
 |
|
12.Feb.04
|
Work
List - produces simple list of compositions
|
 |
here |
 |
|
Mar. 07
|
Work List Alphabetical by Title - primarily for Pops compositions, this version sorts first by title then by composer |

|
here |
 |
|
Mar. 07 |
Work List with Dates - simple list of compositions including composer and work date |

|
here |
 |
|
Mar. 07 |
Work List with Detailed Instrumentation - prints full percussion, keyboard, extra instrument lists and uses an asterisk (*) to indicate wind and brass doublings |

|
here |
 |

|
May 07 |
Work List with Detailed Instrumentation and with Library Shelf (Catalog) No. - prints full percussion, keyboard, extra instrument lists and uses an asterisk (*) to indicate wind and brass doublings |

|
here |
 |

|
June 07 |
Work List with Duration - simple list including work duration |

|
here |
 |
|
Apr. 07 |
Work List with Instrumentation Summary |

|
VFP |
SQL |

|

|
15.Mar.05 |
Work List with Instrumentation - spells out Wind and Brass doublings |

|
VFP |
SQL |

|

|
15.Mar.05 |
Work List with Library Shelf (Catalog) No. |

|
VFP |
SQL |

|
|
15.Mar.05 |
Work List with Most Recent Performance - Prints the compositions you select and indicates the most recent performance and conductor where applicable |
 |
VFP |
SQL |
|
 |
10-May-05 |
Work List with Movements - includes duration of movement(s) and works |

|
VFP |
SQL |

|
|
10.Mar.05 |
Work List with Publisher Information |

|
VFP |
SQL |

|
|
10.Mar.05 |
Work List with Specified Doublings and Detailed Instrumentation - includes detailed indication of doubling instruments, and detailed Percussion, Extra, Keyboard, Solo Instrument and Chorus information |

|
VFP |
SQL |

|

|
10.Mar.05 |
Works not performed - from the list of compositions you select, the report prints only those not performed |
 |
VFP |
SQL |
|

|
10-May-05 |
| |
|
|
|
|
|
|
|
Programs and Composers
|
| Name |
Type |
Download |
Info |
Sample |
Date |
Composer
Anniversary Chart showing major birth and death anniversaries of any set of composers up to 2013
|
 |
VFP
|
SQL
|
 |
 |
25.Apr.03
|
Proposed
or Hypothetical Program and Instrumentation sheet
|
 |
VFP
|
SQL
|
|
|
16.Feb.04
|
|
Performance Histories
|
| Name |
Type |
Download |
Info |
Sample |
Date |
Conductor Performance History - all works conducted by the conductor(s) you select in the Address Book. Includes season, soloist, performance dates and project.
|
 |
VFP
|
SQL
|
 |
|
02.Apr.05
|
Performance
Count (number of performances)
|
 |
VFP
|
SQL
|
|
 |
13.May.03
|
Program 'Context' report - when a certain work has been programmed, what other works were on the concert?
|
 |
VFP
|
SQL
|
 |
|
05.Apr.05
|
Season
Work List with Soloists - works being performed in a given season (or any other time period)
|
 |
VFP
|
SQL
|
 |
 |
21.Feb.03
|
Work
Performance History - Basic List - each performance of the work(s) selected constitutes a row in the table.
|
 |
VFP
|
SQL
|
 |
 |
20.Mar.05
|
Work Performance History - Detail - Includes the Dates, Season, Project, Venue, Conductor, Soloist(s), performance Timing and Other Works on that program
|
 |
VFP
|
SQL
|
 |
 |
24.Jul.03
|
Performance History Overview - performances are grouped by Project and Season
|
 |
VFP
|
SQL
|
 |

|
01.Oct.05
|
Performance History Overview with Orchestra - Same as the report above, but includes the Orchestra; use this version if you use OPAS to manage multiple ensembles |

|
VFP |
SQL |

|
|
01.Oct.05 |
| Name |
Type |
Download |
Info |
Sample |
Date |
Library
Catalog - Standard format with Instrumentation (Landscape format)
|
 |
here |
 |
 |
Oct. '07
|
Library Catalog - Standard format with Instrumentation (Portrait format)
|
 |
here |
 |
 |
Oct. '07
|
Library Catalog with most recent performance |
 |
here |
 |
 |
Oct. '07 |
Library Catalog with Score Information |

|
here |

|

|
Oct. '07 |
Rental
Contract Summary
|
 |
here |
 |
 |
Feb. '07
|
Rental
Contract Summary without cost information
|
 |
here |
 |

|
Feb. '07
|
Rental
Contract Summary by Project
|
 |
here |
 |
 |
Feb. '07
|
Library Expense Tracker - An all-in-one Excel spreadsheet that allows you to view and analyze library expenses over multiple seasons and expense typest. (a related how-to guide on library expenses can be found here)
|
 |
Call (why?) |
|

|
May '08
|
Rental Order form - Boosey & Hawkes |
 |
here |
 |
 |
June '07 |
Rental Order form - C.F. Peters |
 |
here |
 |
 |
June '07 |
Rental Order form - EAM |
 |
here |
 |
 |
June '07 |
Rental Order form - G. Schirmer |
 |
here |
 |
 |
June '07 |
Works
played in a Season with Publisher & Library info
|
 |
VFP
|
SQL
|
|
 |
27.Jul.03
|
Works
played in a Season with Publisher, Library and Instrumentation
info
|
 |
VFP
|
SQL
|
|
 |
27.Jul.03
|