A distant location runs on two spreadsheets nobody wants to own: the rooming list and the transpo grid. Both are the shooting schedule wearing a different hat, and both go stale the moment a day moves. Lodging and Transpo are grids drawn against the same days as the call sheet, so a schedule change reaches the hotel bars and the basecamp count instead of waiting for somebody to notice.
Lodging and Transpo are Company plan features. Company is not yet officially available.
Every person who needs a bed gets a row. Every day of prep, shoot and wrap gets a column. Drag across the row to draw a stay at a hotel, and the check-in, the check-out and the night count come from the bar itself. Work days with no room under them show the person's work code, so a stay that ends a day early stands out.
| Name | Nts | PREP WK 1 | WEEK 1 | WEEK 2 | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
P2Sun10/4 | P1Mon10/5 | D1Tue10/6 | D2Wed10/7 | D3Thu10/8 | D4Fri10/9 | OffSat10/10 | OffSun10/11 | D5Mon10/12 | D6Tue10/13 | D7Wed10/14 | D8Thu10/15 | ||
Production | |||||||||||||
Dana Okafor Unit Production Manager | 11 | KIM | KIM | ||||||||||
Luis Ortega Production Coordinator | 11 | KIM | HMP | HMP | |||||||||
Camera | |||||||||||||
Mike Rodriguez Director of Photography | 10 | HMP | HMP | KIM | |||||||||
Sarah Chen 1st AC | 10 | HMP | HMP | WF | |||||||||
Grip & Electric | |||||||||||||
Tom Walsh Gaffer | 11 | CRW | KIM | ||||||||||
Jess Moreno Best Boy Electric | 9 | HMP | CRW | ||||||||||
Ana Rivera Key Grip | SW | W | W | W | W | W | W | WF | |||||
A flight is a point on the calendar, so it sits as a marker on the day it lands. The date somebody lands is the date the first night is needed, which is the check the Flights view runs: a redeye arriving the morning of D1 with a stay that starts on D1 is fine, and the same flight against a stay starting on D2 is a night in an airport. Itineraries go out by email per person, rooms and rides together.
Marisol Vega LAX → YVR · AC 566 | Sep 7 · 6:05a → 8:52a | Room opens Sep 7 |
Dev Ramanathan JFK → YVR · AS 1229 | Sep 8 · 11:20p → Sep 9 6:40a | Redeye lands Sep 9, room starts Sep 9 |
Priya Nair ORD → YVR · UA 2216 | Sep 6 · 4:15p → 6:38p | Lands Sep 6, room starts Sep 8 |
Two nights before the room opens is the kind of thing that gets found at 11pm by the person standing in the lobby. The Flights view finds it in the office.
From a person's row in Lodging, send them their trip: flights, the room, the ride to set. Tick the parts they need and leave the rest. Anything still unconfirmed is labelled that way in the email, so nobody boards on a hold. When the room is shared, G-Casper Pro asks whether the room-mate should get theirs too.
Pick what Marisol Vega should receive. Only the ticked parts are sent.
Anything not yet confirmed is labelled as such in the email, so nobody travels on a plan.
Cast Transpo charts the performers the way Crew Transpo charts the crew: vehicles as bars across the days, and how each person usually gets to set beside their name. A day that differs gets a shuttle code painted on it, or opens into its runs one leg at a time: round trip, call, location move, wrap, each with its own van, time and pickup. Cast Holding is the other half. Every performer has a usual space, and you paint the days that differ.
| Name | Usual Holding | WEEK 1 | |||||
|---|---|---|---|---|---|---|---|
110/52 | 210/63 | 310/73 | 410/83 | 510/92 | 610/102 | ||
Marisol Vega #1 · ANA | MHMotorhome / Star Trailer | MH | MH | MH | GR | MH | MH |
Dev Ramanathan #2 · GEORGE | PVTPrivate Room | PVT | PVT | PVT | PVT | ||
Priya Nair #3 · DET. HALE | PVTPrivate Room | PVT | PVT | PVT | PVT | PVT | |
Location managers ask one question: how many vehicle spaces do you need. The footprint answers it per day. Trucks and trailers contribute the spaces they occupy, cast holding converts into trailers at the ratios your show actually books, and parking adds a space per car. Move one performer into the location's own changing room and the total drops by four.
| Name | Feet | Spaces | Category | WEEK 1 | ||||||
|---|---|---|---|---|---|---|---|---|---|---|
D110/5 | D210/6 | D310/7 | D410/8 | D510/9 | D610/10 | |||||
G&E | G&E | |||||||||
CAME | CAME | |||||||||
GRIP | ||||||||||
WARD | WARD | |||||||||
MAKE | MAKE | |||||||||
PASS | PASS | |||||||||
CATE | ||||||||||
PORT | PORT | |||||||||
| Trucks / Trailers (spaces) | 17 | 21 | 21 | 21 | 19 | 19 | ||||
| Cast Holding (spaces) | 12 | 12 | 12 | 12 | 16 | 12 | ||||
| Crew Parking, from DOOD (spaces) | 22 | 24 | 24 | 26 | 23 | 21 | ||||
| Cast Parking (spaces) | 3 | 4 | 4 | 5 | 5 | 4 | ||||
| TOTAL VEHICLE SPACES NEEDED | 54 | 61 | 61 | 64 | 63 | 56 | ||||
The Lodging map pins every hotel against every base camp on the schedule, with the drive between them. The Transpo map draws each run to the day's base camp: a van from where it sleeps, a hotel, a home area. Pick a departure, crew call or a fixed hour, and click a run. Ten bars lay the traffic along the drive, origin on the left, so the slow stretch shows up where it is.
Grid puts the whole travelling unit on one sheet: name, room, ride, shuttle code, flights and notes, for one day or the whole schedule, sorted and filtered however you need it. Cards turns the same list inside out, one card per van or per hotel with the people on it. That is the list a driver or a front desk asks for. Open a hotel and its Google listing is there: photos, rating, front desk number, website, and the drive to each base camp.
Add a hotel by name and address and G-Casper Pro finds its Google listing: photos from the hotel and its guests, the rating with the review count, the price level, the front desk number and the website. Under it sits the drive to each base camp the guests work from, minutes first, with a link that opens the route in Google Maps. The contact you typed stays next to it, because the person who answers is not always the switchboard.
On Google
Hotels, ratings, numbers and drives here are made up and the photos are placeholders. In the app the listing, the photos and the drive times come from Google.
Tick a stay as booked and it stops being a plan. The dates it was booked for are stamped at that moment, so a bar edited afterwards can still say what the hotel was told. A re-import that moves the schedule reports a booked stay instead of moving it, because moving it costs a change fee somebody has to authorise. Exports come out per hotel, per rental house, or per person.
| Guest | In | Out | Nts | Conf |
|---|---|---|---|---|
| Marisol Vega | Sep 7 | Sep 13 | 6 | QK4T2L |
| Dev Ramanathan | Sep 9 | Sep 13 | 4 | QK4T2M |
| Mike Rodriguez | Sep 6 | Sep 13 | 7 | QK4T2N |
| Sarah Chen | Sep 6 | Sep 11 | 5 | pending |
The workbook is what gets forwarded to the hotel. It is built from the board, so there is no second list to keep in step.
The TRANSPORTATION table on the call sheet back is fed by the Transpo tab: crew shuttles, BG shuttles, and cast pickups for that day. Vehicle, driver and time keep updating from Transpo until the AD edits the cell, which pins it. Notes are always the AD's. Rows added by hand are never touched.
| Run | Vehicle | Driver | Time |
|---|---|---|---|
| Crew shuttle · Kimpton | Pass Van 1 | Emile D. | 5:45A |
| Cast pickup · M. Vega | Suburban 2 | Amanda R. | 6:10Apinned |
| BG shuttle · Wilson Lot | Pass Van 2 | Kenji O. | 6:30A |
| Lunch run · basecamp | Suburban 1 | Emile D. | 12:15P |
A pinned cell is the AD saying they know better than the tab. Nothing overwrites it after that.