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

Slowly Rebooting in 286 Mode

The lumbar radiculopathy, which sounds too much like "ridiculously" for me, hasn't faded completely. My left leg still cramps, tingles, and hurts with sharp pains. My mind remains cloudy, too, even as I stop taking painkillers for the back pain and a recent surgery.

Efforts to reboot and get back on track intellectually, physically, and emotionally are off to a slow, grinding start. It reminds me of an old 80286 PC, the infamously confused Intel CPU that wasn't sure what it was meant to be. And this was before the "SX" fiascos, which wedded 32-bit CPU cores with 16-bit connections. The 80286 was supposed to be able to multitask, but design flaws resulted in a first-generation that was useless to operating system vendors.

My back, my knees, my ankles are each making noises like those old computers.

If I haven't already lost you as a reader, the basic problem is that my mind cannot focus on one task for long without exhaustion and multitasking seems…

MarsEdit and Blogging

MarsEdit (Photo credit: Wikipedia) Mailing posts to blogs, a practice I adopted in 2005, allows a blogger like me to store copies of draft posts within email. If Blogger, WordPress, or the blogging platform of the moment crashes or for some other reason eats my posts, at least I have the original drafts of most entries. I find having such a nicely organized archive convenient — much easier than remembering to archive posts from Blogger or WordPress to my computer.

With this post, I am testing MarsEdit from Red Sweater Software based on recent reviews, including an overview on 9to5Mac.

Composing posts an email offers a fast way to prepare draft blogs, but the email does not always work well if you want to include basic formatting, images, and links to online resources. Submitting to Blogger via Apple Mail often produced complex HTML with unnecessary font and paragraph formatting styles. Problems with rich text led me to convert blog entries to plaintext in Apple Mail and then format th…

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…