Your Data in a Sheet the Team Already Uses
Department heads and coordinators often want the schedule or the BG numbers in a spreadsheet they can filter and share. G-Casper Pro writes that sheet for you in your Google account, and rewrites the same sheet when things change, so the link you sent stays good.
What Gets Exported
Five datasets can go to Google Sheets. Each has its own sheet:
| Dataset | What's in it | Where |
|---|---|---|
| Breakdown | SC, PGS, D/N, I/E, SCRIPT DAY, SET, DESCRIPTION, CAST, EST HRS, the element categories, EXTRAS, NOTES and custom columns | Breakdown tab, File menu |
| Days Schedule | DAY#, SCENE#, PGS, SCENE HEADING, INT/EXT, D/N, CHARACTERS, NOTES, LOCATION, EST. TIME, with start and end-of-day banners and the boneyard | Days tab, File menu |
| BG List | One row per performer: ID, BG ROLE(S), BG PERFORMER, PHONE, EMAIL, rep details, SAG #, FOOD RESTRICTIONS, ON CS, NOTES | Background tab, File menu |
| Extras Breakdown | One row per scene: SCENE, SET, #, BACKGROUND, NOTES, REUSED, with week and day banners and daily totals | Background tab, File menu |
| Exhibit G | The day's Exhibit G | Exhibit G floating controls |
The Extras Breakdown Sheet
Weeks start with an Extras Breakdown - Week N banner and days with DAY N. Each day ends with a TOTALS row giving the BG Head Count and an Approx Lunch Count, and each week ends with Total BG this week. REUSED comes from the reuse notes you typed in the Background tab's Breakdown view.
New Sheet or Update
Each dataset's section in the File menu has up to three items:
- Export New Google Sheet: makes a new spreadsheet and links it to the production. It opens in a new tab
- Update Linked Sheet: clears the linked sheet and writes the current data into it. The URL stays the same
- Open in Google Sheets: opens the linked sheet
Connecting Google
Connect your Google account once, from Profile > Security & Connections. Until you do, the menus show "Connect your Google account in Settings to use Sheets." See Google Sign-In & Sheets Integration.