Skip to main content

Using a Database to Manage Writing

I encourage writers, including my students, to imagine creative ways to use technology to support writing. Many aspiring writers keep logs of what they have written, to where they have submitted works, and when works have been published or produced. 

My magazine columns for one publisher are listed in a basic Excel spreadsheet. Sure, this is using the system as a database, but a list of almost 100 columns doesn't require a database. The spreadsheet column headings are: Column Number, Date Submitted, Date Published, Title, Slug, and Notes. The publication dates trail the submission dates by a month to three months. I thought about adding a "Word Count" column, since I'm paid by the word, but the columns are consistently 1000 words, give or take a few. 

Tracking scripts, however, requires more than a spreadsheet. That's because I might have nine or ten works submitted at any moment. Acceptance or rejection might come six months to a year after sending a work to a production company. Many producers prohibit multiple submissions of a work, so you can't send a script to three producers and hope for the best. As soon as a producer does reject a script, though, you want to send it out to the next possible producer. 

FileMaker Pro "Manuscript Tracker 2.0"

Scripts have complex contractual agreements that make traditional publishing look simple. Yes, there's an author's royalty, but there are also residual payments to the first production company, residuals to any dramaturg, flat payments to designers, and more. 

When I said that you need basic algebra skills to make sure royalties are accurate, a colleague laughed. How hard can calculating a percentage of ticket sales be?

The traditional royalty is 5 percent of 90 percent of the weighted average ticket price, assuming an 80 percent box office sales through (whether the theater fills 80 percent of seats or not). Remember that "subscribers" and "educational" ticket holders pay lower admission rates, too. You need to know the ticket prices, the number sold at each face value, and other variables. 
Other royalty rates include a flat percentage on gross ticket sales, a percentage of net ticket sales (which leads producers to claim all sorts of expenses), and a flat fee per performance. There are mix-and-match approaches to these royalties, too. I like to have a guaranteed minimum per show, but also the five percent royalty on gross, whichever is greater per show. 
If a show is being performed at more than one venue, and that is every playwright's dream, you have to track these agreements for every performance. Or, if you get lucky, your agent and publisher handle the royalty collection. 
Because I assign residual rights to others, including the first production company to develop a work, I have to track what I am due, then calculate how much of my royalty must be shared with others. Again, too much to track (for me) on paper. I'd lose the paper, anyway. Instead, I have a table of residuals by work. 
My database design links works to producers and publishers. It then links those business relationships to contract terms. There's more, but overall the system makes my life (and my wife's life) much easier. With a few mouse clicks or touches on the iPad, we can see a summary of all the complex terms and agreements associated with a script. 

Technology… letting me focus on writing instead of the business of writing. 

Enhanced by Zemanta


Popular posts from this blog

Comic Sans Is (Generally) Lousy: Letters and Reading Challenges

Specimen of the typeface Comic Sans. (Photo credit: Wikipedia) Personally, I support everyone being able to type and read in whatever typefaces individuals prefer. If you like Comic Sans, then change the font while you type or read online content. If you like Helvetica, use that.

The digital world is not print. You can change typefaces. You can change their sizes. You can change colors. There is no reason to argue over what you use to type or to read as long as I can use typefaces that I like.

Now, as a design researcher? I'll tell you that type matters a lot to both the biological act of reading and the psychological act of constructing meaning. Statistically, there are "better" and "worse" type for conveying messages. There are also typefaces that are more legible and more readable. Sometimes, legibility does not help readability, either, as a type with overly distinct letters (legibility) can hinder word shapes and decoding (readability).

One of the co…

Let’s Make a Movie: Digital Filmmaking on a Budget

Film camera collection. (Photo credit: Wikipedia) Visalia Direct: Virtual Valley
June 5, 2015 Deadline
July 2015 Issue

Every weekend a small group of filmmakers I know make at least one three-minute movie and share the short film on their YouTube channel, 3X7 Films.

Inspired by the 48-Hour Film Project (, my colleagues started to joke about entering a 48-hour contest each month. Someone suggested that it might be possible to make a three-minute movie every week. Soon, 3X7 Films was launched as a Facebook group and members started to assemble teams to make movies.

The 48-Hour Film Project, also known as 48HFP, launched in 2001 by Mark Ruppert. He convinced some colleagues in Washington, D.C., that they could make a movie in 48 hours. The idea became a friendly competition. Fifteen years later, 48HFP is an international phenomenon, with competitions in cities around the world. Regional winners compete in national and international festivals.

On a Friday night, teams gathe…

Edutainment: Move Beyond Entertaining, to Learning

A drawing made in Tux Paint using various brushes and the Paint tool. (Photo credit: Wikipedia) Visalia Direct: Virtual Valley
November 2, 2015 Deadline
December 2015 Issue

Randomly clicking on letters, the young boy I was watching play an educational game “won” each level. He paid no attention to the letters themselves. His focus was on the dancing aliens at the end of each alphabet invasion.

Situations like this occur in classrooms and homes every day. Technology appeals to parents, politicians and some educators as a path towards more effective teaching. We often bring technology into our schools and homes, imagining the latest gadgets and software will magically transfer skills and information to our children.

This school year, I left teaching business communications to return to my doctoral specialty in education, technology and language development. As a board member of an autism-related charity, I speak to groups on how technology both helps and hinders special education. Busin…