Film Production Software vs Spreadsheets

Most articles comparing spreadsheets to production software are written by people selling production software, and they all make the same move: spreadsheets are primitive, software is professional, here is a free trial.

We do sell production software, so read this accordingly. But that argument is wrong, and it is wrong in a way that wastes people's money. A spreadsheet is a serious scheduling tool. Films get made on them. The real question is not whether it is professional, it is whether your production has crossed one specific line.

What a spreadsheet is genuinely good at

It is free and it is already open. No procurement, no trial expiring mid-shoot, no explaining to a producer why there is a new subscription.

Everybody can read it. Hand a spreadsheet to any department and they will open it. Hand them a login and roughly a third of them will not.

It does exactly what you tell it. No opinions about how a shooting day should be structured, no feature you have to work around, no update that moves a button.

It is infinitely shapeable. Odd shoot, unusual constraints, something nobody built a feature for? You just add a column.

For a short film, a contained feature with one location and six actors, a commercial with a two-day shoot, or anything where the plan is unlikely to change much, a spreadsheet plus a printed breakdown sheet is a completely respectable way to work. We publish free templates precisely because that is true.

The one thing it cannot do

A spreadsheet holds information. It does not hold relationships between information.

Concretely: your shooting schedule tab does not know that scene 14 has three cast members in it. You know. You typed it in both places. Which means when scene 14 moves from Tuesday to Thursday, the spreadsheet changes nothing on its own. You change:

1. The scene's row in the schedule tab.
2. Tuesday's page total, and Thursday's.
3. The Day Out of Days grid, for all three actors, which may have changed one of them from a work day to a hold day.
4. The cast call times on both days' call sheets.
5. The location list, if Thursday now needs a location Tuesday did not.

Five edits, from one change. Every one of them a place to make a mistake.

Where the line actually is

Not at a crew size, and not at a budget. The line is the third schedule change.

The first change, you do carefully and correctly. The second, you do quickly because you have done it before. By the third, under pressure, with the call sheet due, somebody updates the schedule tab and not the DOOD. Nobody notices for four days, and what surfaces it is an actor arriving for a day they were on hold for, or not arriving for a day they were meant to work.

If your production is genuinely unlikely to change, the line never arrives and the spreadsheet is the correct tool. If scenes, cast, locations or dates are going to move more than twice, you are choosing between paying for software and paying for the reconciliation by hand, in the worst hours of the day, accurately.

The things that break first, in order

From productions that have moved off spreadsheets, the failure order is consistent:

The DOOD goes stale first. It is the most tedious document to rebuild and the one whose errors cost actual money, because hold days are usually paid. What a DOOD is and how it works.

Then the call sheet disagrees with the schedule. Usually a call time that was changed in one place. This is the one the crew notices.

Then the element lists drift. The prop that was tagged to a scene that has since moved, still listed on the wrong day, so it turns up in the wrong place.

Then version control collapses. Four people have four copies named SCHEDULE_v3_FINAL_REVISED, and the one being shot from is not the newest.

That last one is the real killer, and it is not a spreadsheet flaw. It is what happens when a file has to be emailed to be shared.

What software actually buys you

Not intelligence. Not automation. One thing: the documents are views of the same underlying production rather than copies of each other. Move the scene once, and the schedule, the reports and tomorrow's call sheet are all reading the new arrangement, because there is only one arrangement.

Be clear about what that does not include. A PDF you exported yesterday is still a file, and it does not change. A call sheet already emailed to forty people is forty frozen copies, and if the day changes you generate a revision and send it again. Software shortens the gap between a change and everyone knowing; it does not close it.

A fair way to decide

Count the number of times your last production's schedule changed after it was first distributed. Not scenes, schedules.

• Zero to two: stay on the spreadsheet. Genuinely. Use our shooting schedule and DOOD templates, keep one copy in shared storage rather than in email, and spend the money on something that ends up on screen.
• Three to six: borderline, and it depends on how many people have to be told about each change. If it is you and one other person, a spreadsheet still works. If it is a producer, a coordinator and a first AD, the reconciliation cost is already higher than a subscription.
• More than six: you are already paying for software, in hours, at the worst time of day.

The honest summary

Spreadsheets fail at exactly one thing, and it is not a small thing but it is a specific thing: keeping several documents in agreement while the plan changes underneath them. Everything else about them is fine.

If your production will not change much, do not buy software. If it will, buy on that one property and ignore the rest of the feature list.

If you want to see what the connected version looks like, we wrote it up in detail, including the parts that still have to be done by hand. And if you are weighing specific tools, the buyer's guide has current prices with sources.