SUPPORT/
DOWNLOADS

REPORT KEY

* = Report requires OPAS Extended
= Word Document
= Excel Document
= Word 2007 Document
=OPAS Internal Report

= Information about the report, how to download, etc..
= PDF document
= Opens in new browser window
VFP = FOXPRO (standard OPAS) Users
SQL = SQL-Server Users

* Artist Fee History / Analysis - An all-in-one Excel document that uses a pivot table so you can view and analyze fee histories from virtually any perspective

Aug. 08

* Fee History  - Grouped by Artist, showing all fees and other expenses

Here

Nov 02

* Fee History by Agent - Similar to the report above but grouped by Agency / Management

Here

Nov.02

* Fee History Summary - Simple grid showing fees and expenses, ordered by Artist

Here

Nov.02

* Hotel Room Schedules  - A summary of hotel room needs showing the artist/guest, arrival night, number of nights and notes

Here

Mar.04

* Mailing Labels (artist contracts) - Avery 5160 and 5164 (shipping) formats

Here

Jan 09

Address Book Directory - Standard 2-column directory sorted by Last or Company Name

Here

May 05

Address Book Directory By Group - Similar content to the report above, but organized by Address Group

Here

May 05

Mailing Labels - 5160 format 

Here

Nov 03

Mailing Labels - 5161 format 

Here

Mailing Labels - 5162 format 

Here

Mailing Labels - 5164 format 

Here

Nov 03

Venue Performance History - Prints a concise list of performance dates and programs for the venue(s) you choose  

Here

Jul 03

Directories, Labels and General Documents

Mailing Labels - Services area - these reports print Avery 5160 and 5161 labels from the Services area (mailing labels for all those assigned to a service)

VFP

SQL

10.May.05

Concise Orchestra Roster/Directory - For orchestra musicians and/or substitutes; the report has a concise 4-column roster, organized by instrument. Roughly 40-musicians per page

Here

Mar. 09

Orchestra Roster by Musician Seniority - shows hire date and years of service

Apr. 03

Artist Phone List - a set of four reports:

• Musician Phone / Address List
• Musician Phone / Address / Instrument List
• Musician Phone / Email List
• Musician Phone / Email / Address List

Here

Feb. 09

Extra Musicians Required  - For any date range, the report compares the instrumentation required (based on programming) against your orchestra's core

Here

Mar. 09

Extra Musicians Required - Summary  - For any date range, the report compares the instrumentation required (based on programming) against your orchestra's core. This version is landscape-oriented and puts each project on one line.

Here

Mar. 09

Rosters and Attendance

* Personnel Worksheet Summary (Activity Roster) - A simple one-page activity roster with program information at the top.

Here

Feb. 09

* Mailing Labels for assigned musicians - Print Avery 5160 labels for musicians assigned to services (5 different options for which musicians to include)

Nov. 06 .

* Activity Roster/Attendance 

Call

Call

N/A

11.May.04

* Concert Roster (Winds/Brass/Percussion in Seat Order)

Call

Call

N/A

29.Mar.04

* Concert Roster (Full Orchestra in Seat Order)

Call

Call

N/A

11.May.04

* Leave / Absence Schedule (organized by Leave Type) - Prints a comprehensive list of each type of Musician Absence or Extended Leave, and all musicians on that leave.

Here

Jan. 09

* Leave / Absence Schedule (by Musician) - Prints a comprehensive leave history for each selected musician

Here

Jan. 09

* Personnel Attendance Reports (5-report packet) - FoxPro or Internal OPAS reports that show attendance overviews in various formats

Here

Feb.03

Service / Attendance Analysis

Service Analysis - An all-in-one Excel spreadsheet that allows you to view and analyze musician attendance and absense from almost any viewpoint.

Call
(why?)

May 08

Personnel Contracts

* Extra Musician Agreement - Prototype of a contract or letter of agreement for extra / substitute musicians.

Here

Mar. 09

* Mailing Labels (substitute contracts)

VFP

SQL

N/A

09.Dec.03

Ticket Sale Overview - Single grid of ticket sales sorted by Date/Project; each ticket category represents a row in the table  

Here

Dec. 02

Ticket Sale Summary - Single grid of ticket sales sorted by Date/Project; each row is a concert

Here

Dec. 02

Ticket Sales by Project - Detail  - Concerts are grouped chronolgically by Project. Sales / income are shown for each concert and ticket category, and subtotaled for Projects

Here

Dec. 02

Ticket Sales by Project - Summary - Similar to the report above, but sales/income breakdown by ticket category is not shown  

Here

Dec. 02

Ticket Sales by Ticket Category - Sales/Income grouped and subtotaled by Ticket Category, and showing concert breakdown within each category.

Here

Dec. 02

Unformatted Program page  

VFP

SQL

29.Sep.03

Unformatted Program Schedule

VFP

SQL

N/A

29.Sep.03

Carnet Forms - A preformatted ATA Carnet form

Here

Jan. 09

Hotel / Travel 'Cross-Table' - Shows all Tour Participants, with indication and notes as to their hotel and travel assignments. Offers the option to include Passport information.

here

Dec. 07