Skip to main content

Guide

When does an event production spreadsheet stop working?

A production spreadsheet stops working when the schedule, the crew roster and the budget live in separate tabs or files, so every date change is copied by hand and nobody sees the cost until the invoice.

By Pedro van Tol, founder of ShowOps.AI and an executive producer for 15 years

A production spreadsheet stops working when the schedule, the crew roster and the budget live in separate tabs or files: a date change has to be copied by hand into each one, and nobody sees what it cost until the invoice arrives. ShowOps.AI imports the workbook you already have and connects those pieces, so a confirmed date change shows which crew bookings move and what that does to staffing cost and the linked budget lines.

Spreadsheets are a fine way to run a show. Most production teams start there for good reasons: everyone can open them, clients send them, and a good one encodes years of habit. This page is about the point where the copying between tabs costs more than the sheet saves.

Signs you have outgrown the sheet

  • There are three versions of the run of show in circulation, and someone asks which one is current every day of build.
  • Per diem and day rates are recalculated by hand every time a call date moves.
  • A date change means editing the schedule, then the roster tab, then the budget tab, then calling the crew, in that order, and one of the four gets missed.
  • Budget actuals arrive a week after the show, because they live in someone's inbox until then.
  • Vendor contacts and contract status sit in one person's email, and the sheet has a column that says "ask the producer."
  • You cannot tell who changed a number, or when.

If three or more of these are true, the spreadsheet is no longer the plan. It is a record of the plan that someone keeps up to date by hand.

Spreadsheet vs ShowOps.AI, task by task

TaskIn a spreadsheetIn ShowOps.AI
Move a show dateEdit the schedule, then find every roster row and budget line it affects.

Confirm the timeline change and get a report of the crew bookings that move, the staffing cost change and the linked budget lines. A producer approves or rejects it, and it can be undone.

Work out crew costA formula per row, copied down and kept in step by hand.Each roster booking carries its days, day rate and per diem, so the cost follows the booking.
Track budget vs actualsA second column, filled in after the show.Each budget line shows budgeted, actual and variance, and where the actual came from.
Keep one current run of showFile names like "ROS_final_v3".A shared run of show, with segment times and the key times marked for the executive brief.
See who changed whatVersion history, if the file lives in the right place.Confirmed timeline versions are kept, and an audit log records changes for 24 months.
Control who sees whatShare settings on each file.Eight roles, from account owner to viewer, and venue managers see only their venues.

In ShowOps.AI the date-change approval is switched on for each organization during setup.

What stays in spreadsheets

Some things belong in a sheet, and ShowOps.AI does not try to replace them:

  • One-off calculations and what-ifs you build for yourself before anything is real.
  • Documents a client owns and sends you in their own format.
  • Payroll and timekeeping. ShowOps.AI has no time tracking or payroll, so those stay in the tools that do them.
  • Rental-gear quoting from an inventory. ShowOps.AI does not quote rental inventory.

How to move without stopping work

  1. Pick one live show, not your archive.
  2. Import the workbook you already use for it, from an .xlsx file or a Google Sheets link, and map each tab to the part of the plan it holds: schedule, crew, budget, vendors.
  3. Check the imported totals against your sheet. Formula results come in as values, so a mismatch points to a tab that needs a second look.
  4. Run the show's next date change through ShowOps.AI and compare the report with what you would have copied by hand.
  5. Keep the original file as the reference until that show is done.

When a spreadsheet is still the right tool

If you run a handful of small shows a year with one producer and a crew that rarely changes, a well-kept spreadsheet may be all you need. The copying only starts to hurt when several people edit the plan, dates move after crew are booked, and the budget has to answer to a client.

For how a single date change flows through crew and budget, see Produce. If you are comparing ShowOps.AI with a crew-first platform rather than a spreadsheet, read ShowOps.AI vs LASSO.

Frequently asked questions

Do I have to stop using Google Sheets?
No. ShowOps.AI imports Excel and Google Sheets workbooks, including straight from a Google Sheets link, and the vendor list can stay in sync with a Google Sheet in both directions. Other grids come in by import and do not write back yet.
Does it work with Excel?
Yes. You import .xlsx workbooks and map each tab to the part of the plan it holds.
What happens to my formulas?
ShowOps.AI imports the value each formula last calculated, not the formula itself. Totals that depended on formulas are worked out inside ShowOps.AI instead, for example crew cost from days, day rate and per diem. A formula cell that was never calculated comes in empty, so open and save the workbook before you import it.
Can I still send clients a spreadsheet?
Yes for budget actuals, which export to CSV. Itineraries export as a printable page. Ask in a walkthrough about the project-plan workbook export, which is set up per organization.
How long does it take to move a show over?
It depends on how many tabs your workbook has. Start with one live show, not your whole archive, and keep the old file as the reference until the first show runs from ShowOps.AI.

See it in your production

Talk to the team

We are happy to walk through how ShowOps.AI fits your productions, your tools, and your data requirements.