Run of show template
A run of show template you can copy into any spreadsheet, with a full worked example for an evening gala and notes on what to do when the timing slips.
The template
Copy this header row into a spreadsheet. It is enough for most dinners, galas, receptions and single-room meetings.
| # | Start | Length | Item | Room | Owner | On stage / mic | Notes and fallback |
|---|---|---|---|---|---|---|---|
| 1 | 5:30 PM | 45 min | Doors and reception | Pre-function | Name | None | What the crew needs to know. What to do if it goes wrong. |
The columns, and why each one is there
- # (item number). Lets people say "we are on item 9" over a radio. Use decimals for late additions (9.1) so you never renumber.
- Start and Length. Keep both. With a length on every row you can see at once what moves when something runs long.
- Item. What happens, in a few words.
- Room. Where it happens. Add this column from the start, even for a one-room event. The second room always arrives later.
- Owner. The one person responsible. A name, not a department.
- On stage / mic. Who is up, and which microphone they are on.
- Notes and fallback. Audio, lighting and video in plain words, plus what happens if the plan fails.
Columns to add for bigger shows
Once a show has screens, a band or a show caller, the single notes column gets crowded. Production teams usually split it by department, so each operator reads down their own column:
- Audio. Sources, mic numbers, walk-on music.
- Video and screens. One column per screen if they show different things. Some teams add a column for the confidence monitor the speaker sees.
- Lighting. The look for each item.
- Script or voice of god. Any announcement that is read word for word.
Columns planners forget
- Hard or soft. Whether this start time is fixed or can slide. More on this below.
- Cut priority. What you would shorten or drop first if the night runs long.
- Status. Confirmed, pending, or changed since the last version.
Worked example: an evening gala
This is a sample awards gala in one ballroom with a reception space outside it. The times are illustrative. Replace the rows with your own, and check every service time with your venue and caterer.
| # | Start | Length | Item | Room | Owner | Time | Notes |
|---|---|---|---|---|---|---|---|
| 1 | 12:00 PM | 3 hr | AV and staging load-in | Dock, Ballroom | Technical director | Hard | Dock slot booked with venue. Staging and truss first, then audio, video and lighting. |
| 2 | 3:00 PM | 1 hr | Catering and decor load-in | Ballroom | Producer | Soft | Floor must be clear of cases before tables go down. |
| 3 | 4:00 PM | 45 min | Sound check and line check | Ballroom | Audio lead | Soft | Band first, then speaker mics. Room closed to vendors. |
| 4 | 4:45 PM | 30 min | Rehearsal with presenters | Ballroom | Stage manager | Soft | Walk each presenter through entrances, slides and the award handoff. |
| 5 | 5:15 PM | 15 min | Final walk-through, crew meal ends | Ballroom | Producer | Soft | House to opening look. Walk-in music on. Radios checked. |
| 6 | 5:30 PM | 60 min | Doors, reception, silent auction | Pre-function | Producer | Hard | Registration open. Background music only. |
| 7 | 6:30 PM | 15 min | Ballroom doors, guests seated | Ballroom | Stage manager | Hard | Announcement at 6:25. Silent auction closes at 6:45. |
| 8 | 6:45 PM | 10 min | Welcome remarks | Ballroom | Stage manager | Soft | Lectern mic. House lights to half. |
| 9 | 6:55 PM | 50 min | Dinner service | Ballroom | Catering captain | Hard | Kitchen fires to this time. No program during the main course. |
| 10 | 7:45 PM | 25 min | Keynote | Ballroom | Stage manager | Soft | Starts once mains are cleared. Handheld plus backup. Slides on both screens. |
| 11 | 8:10 PM | 30 min | Awards presentation | Ballroom | Stage manager | Soft | Walk-up music per award. Dessert served during. Cut first: second video. |
| 12 | 8:40 PM | 15 min | Live appeal | Ballroom | Producer | Soft | Giving totals on centre screen. Spotters with handhelds. |
| 13 | 8:55 PM | 10 min | Changeover to band | Ballroom | Audio lead | Soft | Band is pre-set behind the drape. DJ covers the gap. |
| 14 | 9:05 PM | 85 min | Band and dancing | Ballroom | Audio lead | Soft | Dance floor look. Bar reopens. |
| 15 | 10:30 PM | 15 min | Last song, guest departure | Ballroom | Producer | Hard | Music off at 10:30 per venue. House lights up slowly. Transport at the entrance. |
| 16 | 10:45 PM | 2 hr | Load-out | Ballroom, Dock | Technical director | Hard | Decor first, then AV. Dock reserved until 1:00 AM. |
Two things about the shape are worth copying. The program sits after the main course is cleared, so speakers are not competing with service. And dessert goes out during the awards, which keeps people in their seats for the part the client cares about most. A fundraising gala timeline published by the Chronicle of Philanthropy follows the same pattern.
How to fill it in
- Start with the fixed points. Doors, dinner service, the time the music has to stop, the dock booking. Put those in first and mark them hard.
- Work backwards from doors. Fit load-in, sound check and rehearsal in front of it. If they do not fit, you need an earlier load-in, and it is better to learn that now.
- Enter durations, not only clock times. Durations are what let the schedule recalculate.
- Give every row one owner.
- Give simultaneous things their own rows. If the silent auction closes while guests are being seated, that is two rows, not one long note.
- Keep logistics in the same sheet. Load-in and load-out are part of the day. A separate sheet is a second thing to keep in sync.
Buffers and changeovers
Every guide tells you to add buffer, and few say where. Put it where a delay costs the least and helps the most:
- After anything with a live speaker. People run long. Five minutes after a keynote is cheap insurance.
- Around anything that moves people. Seating a few hundred guests takes longer than anyone plans for.
- Before a hard time. If dinner service cannot move, the item before it needs slack.
You will see rules of thumb, such as keeping 10 to 15 percent of the running time as buffer. Treat those as starting points. The right number depends on the room, the speakers and how many moving parts sit between hard times.
Changeovers between acts vary just as much. A DJ handing over to another DJ can take a few minutes. A full band changing over onto its own equipment can take half an hour or more. The surest way to shorten one is to pre-set the next act out of sight, as in row 13 above. Ask the audio lead for a real number, and do not guess on their behalf.
For meal service, ask the banquet captain how long each course takes for your guest count in that room. They know, and it changes with the menu, the number of servers and how far the kitchen is from the ballroom.
When the timing slips
It will. The question is whether the document helps you recover.
- Change the length, not the later start times. When an item runs long, update its duration and let every later start follow. Retyping start times by hand is where mistakes come from.
- Look at the next hard time. That is your real deadline. Everything soft between now and then is where you find the minutes.
- Use the cut list. You decided before the show what goes first. Now you only have to say it.
- Tell the people it touches. The kitchen, the band and the transport desk all care about a fifteen-minute slide, and none of them are on your headset.
Adapting the template
- Conference. One run of show per room, plus a master row for anything shared: breaks, lunch, the move to the general session. Watch for crew and equipment that have to be in two rooms.
- Awards ceremony. One row per award is worth the length. Each has its own presenter, walk-up music and slide, and each is a chance for something to go missing.
- Wedding. The same columns work. The hard times are usually the ceremony start, sunset for photos and the venue's music cutoff.
- Festival stage. Changeovers become rows of their own, and they are the rows that decide whether the day runs on time.
The spreadsheet version, and where it breaks
In Google Sheets or Excel, a time is a fraction of a day. To make times follow each other, set the end of a row to its start plus its length in minutes divided by 1,440, then set the next row's start equal to that end. Enter one start time at the top and the rest calculate.
It works until someone inserts a row, drags a row to reorder it, or pastes over a formula. Then the chain breaks, often silently. If you build it this way, protect the formula columns, and check the last row's time after every edit. If it did not move when it should have, something above it broke.
Versions and sending it out
- Put a version number and the date and time at the top of page one.
- Add one line saying what changed since the last version.
- Keep one master. Nobody edits a copy.
- Print a few. Phones die, and ballrooms have dead spots.
When the template stops being enough
A spreadsheet works until several people need different views of the same schedule, or until times change on the day. myROS keeps the same information as this template, recalculates the times when one cue moves, and builds a day-of packet for each team from the same show.
Common questions
What columns should a run of show template have?
At minimum: item number, start time, length, item, room, owner, who is on stage, and notes. Larger shows split the notes into audio, video and lighting columns.
How far ahead should I build the run of show?
Start as soon as the fixed points are known: doors, meal service and the venue's hard out. It will keep changing, so start early and expect revisions.
How much buffer time should I include?
There is no standard. Some guides suggest 10 to 15 percent of the running time. It is more useful to place buffer after live speakers, around anything that moves guests, and before any time that cannot move.
Should I use Excel or Google Sheets?
Either works. Google Sheets makes it easier for several people to see the same version. Excel is easier to use offline. In both, protect the columns that hold time formulas.
How do I update the run of show during the event?
Change the length of the item that ran long and let later start times follow. Then tell the people outside your headset who are affected, such as the kitchen and transport.
Is there a wedding or conference version?
The same columns work for both. A conference needs one run of show per room. A wedding usually has fewer technical columns and a few fixed points such as the ceremony start and the music cutoff.