This is Excel macro for stage rehearsal plans.
You can import your play script (PSCML format) into the book, and generate Appearance Table at the same time.
Scene names in Appearance Table are linked to sluglines in the Script sheet.
If you put actors’ attendance info to Attendance sheet, it’s referred to by Appearance Table, and vice versa.
In Appearance Table, you can see actors’ attendance of scenes on a particular day.
In Attendance sheet, you can see actors’ attendance of rehearsal days for a particular scene.
In Plan sheet, you can overview approximate actors’ attendance of days/scenes.
And see attendance details of current cell by opening Inspector panel.
Check the “Instruction” sheet for more information.
Microsoft Excel 2016
(Could be working on lower versions.)