Some of the office lives in Google Sheets and is not moving. G-Casper Pro writes the Days schedule, the breakdown, the BG list, the extras breakdown and Exhibit G into spreadsheets in your own Google Drive. Each one stays linked to the show, so when the schedule changes you update the sheet you already shared instead of sending round a new one.
Google Sheets export comes with every plan. It needs a Google account connected in your profile.
The Days tab exports the schedule day by day, with a START DAY row carrying the date and call time, the scenes in shooting order, the lunch and company move banners in their colours, and an END OF SHOOTING DAY row with the day's pages. Unscheduled scenes go in a Boneyard at the end. The Breakdown tab writes a row per scene with every element category as a column, scenes coloured, headers frozen. The Background tab writes two: the BG List with phone, rep, SAG number and food restrictions, and the Extras Breakdown by week and day with the head count and approximate lunch count under each day. The top row of each sheet names the show, links back to it, and says when it was exported and last updated.
Pick Export New Google Sheet.
Export New Google Sheet makes the spreadsheet and opens it in a new tab. From then on the menu offers Update Linked Sheet and Open in Google Sheets. Update rewrites the same spreadsheet at the same address, so the link in the production office's group chat keeps working, and the Exported date stays put while Updated moves. The update replaces the whole tab. Anything typed into the sheet by hand is overwritten, and nothing is read back into G-Casper Pro. The first export asks you to connect a Google account under Security & Connections in your profile, if you have not already. The spreadsheets are created in that account's Drive and belong to you.
Pick Export New Google Sheet.
Exhibit G goes out one shoot day at a time, filled into the SAG-AFTRA template and converted to a Google Sheet, with the minor, forced call and production type boxes as real checkboxes. Once a day has a sheet, Sync to Google Sheet rewrites the performer rows in place. Export to Excel is still there for a file you attach.
SELECT FROM DROP-DOWN LIST WORK - W REHEARSAL - R FITTING - FT TRAVEL - TR START - S HOLD - H TEST - T FINISH - F | Report Makeup Wardrobe | WORK TIME | Dismiss Makeup Wardrobe | MEALS | TRAVEL TIME | Stunt Adj. | Minors Tutoring Time | WARDROBE | Forced Call | MPVs | PERFORMER'S SIGNATURE | Objection | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Report On Set | Dismiss On Set | ND Meal | 1ST MEAL | 2ND MEAL | Leave for Location | Arrive on Location | Leave Location | Arrive at Studio | No. of Outfits Provided | |||||||||||||||
In | Out | Start | Finish | Start | Finish | |||||||||||||||||||
| CAST | MINOR? | CHARACTER | ||||||||||||||||||||||
| James Stewart | George Bailey | SW | 6:00 AM | 7:00 AM | 7:15 PM | 7:35 PM | 12:30 PM | 1:00 PM | 2 | 0/0 | ||||||||||||||
| Donna Reed | Mary Hatch | SW | 6:00 AM | 7:00 AM | 7:15 PM | 7:35 PM | 12:30 PM | 1:00 PM | 2 | 0/0 | ||||||||||||||
| Lionel Barrymore | Mr. Potter | W | 8:00 AM | 8:30 AM | 6:45 PM | 7:05 PM | 12:30 PM | 1:00 PM | 0/0 | |||||||||||||||
| Henry Travers | Clarence | W | 9:00 AM | 9:15 AM | 6:00 PM | 6:20 PM | 12:30 PM | 1:00 PM | 0/0 | |||||||||||||||
| Thomas Mitchell | Uncle Billy | W | 7:30 AM | 7:45 AM | 5:30 PM | 5:50 PM | 12:30 PM | 1:00 PM | 0/0 | |||||||||||||||
| Karolyn Grimes | Zuzu Bailey | W | 8:00 AM | 8:30 AM | 12:00 PM | 12:20 PM | 1 | 0/0 | ||||||||||||||||
| Frank Faylen | Ernie | WF | 8:30 AM | 8:45 AM | 4:00 PM | 4:20 PM | 12:30 PM | 1:00 PM | 0/0 | |||||||||||||||
| Ward Bond | Bert | H | ||||||||||||||||||||||