Programing History
-
Small Utility Pograms - C64 Basic - 1985ish
-
DLS3 - Gas Spring Life Predictor - Quick Basic & Visual Basic - 1988 to 2009
-
Wrote from scratch a utility program, with my father, to predict the life span of a gas spring.
-
-
TEMP, X4BAR, DOOR - Gas Spring Design Utilities - MBasic (CPM) & Quick Basic - 1988 to 2009
-
Updated a number of programs used in the design process for Gas Sping Company
-
-
FLATTEXT - Autocad LISP - 1998
-
Added command to autocad to take all selected text and flatten text to the same direction.
-
-
Membership Database - Access Database w/Visual Basic - 2002
-
Database to track and monitor membership for the Strand Theater.
-
-
Light Jockey Backup Utility - Visual Basic - 2005
-
External utility to copy data directory and create a backup for the Moving Light software Light Jockey
-
Performing Arts Center Manager (also known as Theater Management Database)
For my graduate thesis in 2000 I created, using Microsoft Access with Visual Basic, a database to track and manage the needs for each event/show at a performing arts center. It was modeled loosely on a large and difficult-to-use program that Rowan had used for some portion of the '90s. The concept was a basic template database that could then be customized for various venues. At the time of the presentation of the thesis, the core workings of the database were in place and working; however, as I noted during my presentation, to actually finish and get it working would take time and money beyond what I could do myself.
This is the first screen the user will see. Its main purpose is as a place for the user to enter a user name and password. When the user pushes the “Start Database” button, the program takes the user name and password along with information from the setup screen and starts Microsoft Access and the actual database itself. This screen is not actually needed to run the database, but it makes the starting process simpler. Eventually the licensed entries will be fille
Once the database is running, this is the central menu that the user uses to navigate to the different sections of the program. The title and logo on the right-hand side will be changed for each individual company. Also at the bottom will show the current user who is logged in, and in a future version will show their security level. The top three menu items are for accessing the main event form. The “Edit Events” button will open the form and allow you to search and filter the rec
Used during the initial setup to point to the databases files.
This is the first screen the user will see. Its main purpose is as a place for the user to enter a user name and password. When the user pushes the “Start Database” button, the program takes the user name and password along with information from the setup screen and starts Microsoft Access and the actual database itself. This screen is not actually needed to run the database, but it makes the starting process simpler. Eventually the licensed entries will be fille
Report in Calendar format of spaces used. Would also have printed out for a piece of equipment of even a crew persons calls.
This memo would be sent to an individual crew member to give them a list of what they are scheduled to work.
This report is meant for the staff to get ready for a show. It lists time the theater is in use and the people working the show and the rooms and equipment needed
Report in Calendar format of spaces used. Would also have printed out for a piece of equipment of even a crew persons calls.
From about 2001 to about 2006 I recreated a much simplified version of the Database for my personal use to manage events at the Strand Theater. First version was created using Access, the second using Filemaker Pro. In the end, all variations have been abandoned in favor of using Excel as an event-by-event setup.
File
Availble
Soon
FILE
NOT
AVAILIBLE
Strand Event Workbook (Excel)
-
PDF Printount of Blank Book
-
Excell Workbook used to create work orders, contract face, billing and other paperwork
-
One Workbook per show.
-
First page was data entry, most of rest of book was pages that just got printed
NJPAC Production Workbook (Excel)
-
PDF Printount of select pages from multiple shows.
-
Excell Workbook used to create Production Notes and Post show notes, track spending, estimate labor.
-
One Workbook per show.
-
Took existing workbook (prior to my employment) and updated connectivity between sheets to speed workflow.
-
Streamlined and made payroll estimating more accurate .
Production Tracking Workbook (Google Sheets)
-
Using Google sheets for ease of sharing with multiple people.
-
Used to track all budgets by prodution department.
-
Used to track all Purchase Orders and Contract Payroll.
-
Used to watch department-wide savings vs. budget.