Open your spreadsheet and mark six columns with these headings: cue number, act and scene, page number, cue point, description and time.
Label the cue numbers under the first column. Start with the number one and continue listing subsequent numbers based on the amount of effects in the performance.
Type the act and scene where the lighting effects occur under the heading of the second column, such as Act 1, Scene 1. List the exact page number where the effect appears in the script under the third column.
Write a short sentence that gives the signal for the effect in the fourth column. This should be a precise action. For instance, in Act 1, Scene 1 of "Hamlet" the cue for the lighting may occur when the character Bernardo enters.
Write a short summary of the lighting effect under the description column. In the above example from "Hamlet," the description may read, "Stage lights come up."
Type the length of the lighting effect in the sixth, and final, column. Suppose you want the stage lights to slowly fade in for 30 seconds when Bernardo comes onstage. You would list the duration of the effect in this column.