Guides

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.

#StartLengthItemRoomOwnerOn stage / micNotes and fallback
15:30 PM45 minDoors and receptionPre-functionNameNoneWhat the crew needs to know. What to do if it goes wrong.

The columns, and why each one is there

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:

Columns planners forget

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.

#StartLengthItemRoomOwnerTimeNotes
112:00 PM3 hrAV and staging load-inDock, BallroomTechnical directorHardDock slot booked with venue. Staging and truss first, then audio, video and lighting.
23:00 PM1 hrCatering and decor load-inBallroomProducerSoftFloor must be clear of cases before tables go down.
34:00 PM45 minSound check and line checkBallroomAudio leadSoftBand first, then speaker mics. Room closed to vendors.
44:45 PM30 minRehearsal with presentersBallroomStage managerSoftWalk each presenter through entrances, slides and the award handoff.
55:15 PM15 minFinal walk-through, crew meal endsBallroomProducerSoftHouse to opening look. Walk-in music on. Radios checked.
65:30 PM60 minDoors, reception, silent auctionPre-functionProducerHardRegistration open. Background music only.
76:30 PM15 minBallroom doors, guests seatedBallroomStage managerHardAnnouncement at 6:25. Silent auction closes at 6:45.
86:45 PM10 minWelcome remarksBallroomStage managerSoftLectern mic. House lights to half.
96:55 PM50 minDinner serviceBallroomCatering captainHardKitchen fires to this time. No program during the main course.
107:45 PM25 minKeynoteBallroomStage managerSoftStarts once mains are cleared. Handheld plus backup. Slides on both screens.
118:10 PM30 minAwards presentationBallroomStage managerSoftWalk-up music per award. Dessert served during. Cut first: second video.
128:40 PM15 minLive appealBallroomProducerSoftGiving totals on centre screen. Spotters with handhelds.
138:55 PM10 minChangeover to bandBallroomAudio leadSoftBand is pre-set behind the drape. DJ covers the gap.
149:05 PM85 minBand and dancingBallroomAudio leadSoftDance floor look. Bar reopens.
1510:30 PM15 minLast song, guest departureBallroomProducerHardMusic off at 10:30 per venue. House lights up slowly. Transport at the entrance.
1610:45 PM2 hrLoad-outBallroom, DockTechnical directorHardDecor 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

  1. 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.
  2. 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.
  3. Enter durations, not only clock times. Durations are what let the schedule recalculate.
  4. Give every row one owner.
  5. Give simultaneous things their own rows. If the silent auction closes while guests are being seated, that is two rows, not one long note.
  6. 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:

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.

Adapting the template

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

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.

myROS is opening soon.Run of show software for event producers.
Join the waitlist