Projects‎ > ‎

Show paperwork creation

Excel


One of the first steps in creating paperwork is to do all of the planning and layout of the rig. I found that creating an Excel master workbook is the most efficient way of organizing all pertinent information for the show. 

Below is the DMX Addressing layout for the entire rig. This is done before a patch is created in the console, because this is easier than unpatching and repatching. From here, this data is used to help determine cable paths.


Below is another example of paperwork created in Excel. This shows how the fixtures are circuited. During creation, care is taken to insure that the phases of the power distribution system are balanced.





Once the rig has been laid out, the information is moved to a master sheet, where all of the data for the fixtures is represented. It's not laid out with borders or anything, as it is not intended for printing. I will omit it here. I have found that this is the easiest way to export the information into an Access database.


Access Database

Here is what a laid out version of the paperwork looks like. This is from the Annaul Daniel Island  Hootie and the Blowfish rig, 2012. There are many different variations of this paperwork, which displays more or less the same information sorted in different ways. The example below is sorted by position, and gives relevant information. This is intended to be used mostly for troubleshooting in the field.



One of my favorite layouts is the DMX address labels, these can be printed on standard Avery brand labels and adhered to the lights or truss.



Other variations on the Access paperwork include:

-DMX Patch sheet for the console, Organized by universe.
-DMX Patch sheer for fixtures, Organized by Fixture type
-Serial number + SES ID, Internal paperwork for inventory control
-Circuit Hookup, Useful for labeling distros and breakouts

Truck Packs

Coming soon!




Comments