Lodging & Transpo

Who sleeps where, who rides in what,
and how much of the lot it all takes.
On the same calendar as the shoot.

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.

The Lodging Board

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.

Draw stays by dragging
Prep and wrap days included
Rooms per night per hotel
Uncovered work days flagged
Draw:
NameNtsPREP WK 1WEEK 1WEEK 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
Pick a hotel and drag across a row to book it. In Select, drag a bar to move it.Sloped ends are check-in and check-out.WWorking, no room booked.

Flights That Know What a Room Is For

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.

Inbound and outbound legs
Redeye arrival dates handled
Landing checked against the stay
Per-person itinerary emails
Flights · inbound
Marisol Vega
LAX → YVR · AC 566
Sep 7 · 6:05a → 8:52aRoom opens Sep 7
Dev Ramanathan
JFK → YVR · AS 1229
Sep 8 · 11:20p → Sep 9 6:40aRedeye lands Sep 9, room starts Sep 9
Priya Nair
ORD → YVR · UA 2216
Sep 6 · 4:15p → 6:38pLands 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.

Itineraries by Email

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.

Flights, room and vehicle
Send only what is ticked
Unconfirmed parts labelled
Room-mate offered alongside
Email itinerary

Pick what Marisol Vega should receive. Only the ticked parts are sent.

Flights
Accommodation
Vehicles

Anything not yet confirmed is labelled as such in the email, so nobody travels on a plan.

Cast Transpo and Holding

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.

Vehicles charted as bars
Day-by-day shuttle legs
Usual holding, painted exceptions
Background in Cast Holding
Marisol Vega
D4 · Oct 8 · Set (Rooftop) · the usual round trip; anything you change here becomes this day's own
Round trip · SH · Kimpton Riverside to Set (Rooftop)
Add a run
Draw:
NameUsual 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

The Basecamp Footprint

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.

Per-day space totals
Holding converts to trailers
Ratios set in Globals
Crew, cast and extras parking

Transpo Footprint

Peak D4: 64
NameFeetSpacesCategoryWEEK 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)172121211919
Cast Holding (spaces)121212121612
Crew Parking, from DOOD (spaces)222424262321
Cast Parking (spaces)344554
TOTAL VEHICLE SPACES NEEDED546161646356

Maps With the Traffic On

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.

Hotels against base camps
Runs from parking, hotels, home areas
Traffic at crew call or a set hour
Ten bars along each drive
21 mapped avg 28 min in traffic

Routes to base camp
4

Grid and Cards

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.

Crew, cast or both
One day or the whole schedule
Cards by vehicle or by lodging
Google listing on the hotel card
DayD4 · Oct 8 · Rooftop
7 people · 6 housed · 4 with transport
3 staying
  • Mike RodriguezDirector of Photography · CameraOct 4–10
  • Sarah Chen1st AC · CameraOct 4–10
  • Marisol Vega#1 · ANA · CastOct 4–10
3 staying
  • Tom WalshGaffer · Grip & ElectricOct 4–9
  • Dev Ramanathan#2 · GEORGE · CastOct 5–9
  • Priya Nair#3 · DET. HALE · CastOct 6–9
No lodging
  • Emily ParkScript Supervisor · Production

Hotel Listings From Google

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.

Photos, rating and reviews
Front desk number and website
Drive to each base camp
Directions in Google Maps
Kimpton Riverside
880 Riverside Dr, Burbank

On Google

Wilson LotD1 to D414 min · 4.9 mi

Blackwood StudiosD5 to D67 min · 2.1 mi

Wilson LotBlackwood StudiosKimpton Riverside
Staying here
  • Mike RodriguezDirector of PhotographyOct 4–10 · 6 nights
  • Sarah Chen1st ACOct 4–10 · 6 nights
  • Marisol Vega#1 · ANAOct 4–10 · 6 nights

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.

Booking Confirmations and Exports

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.

Booked dates stamped
Re-import reports, never moves
Per-hotel and per-person exports
Rates gated by plan
Kimpton Riverside · booking request
GuestInOutNtsConf
Marisol VegaSep 7Sep 136QK4T2L
Dev RamanathanSep 9Sep 134QK4T2M
Mike RodriguezSep 6Sep 137QK4T2N
Sarah ChenSep 6Sep 115pending
Rooms per night sheet included. Rates appear only for Producer and Company members.

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 Transpo Schedule on the Call Sheet

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.

Crew, BG and cast runs
Fed from the Transpo tab
Edited cells pin
Prints below the department grid
Transportation
RunVehicleDriverTime
Crew shuttle · KimptonPass Van 1Emile D.5:45A
Cast pickup · M. VegaSuburban 2Amanda R.6:10Apinned
BG shuttle · Wilson LotPass Van 2Kenji O.6:30A
Lunch run · basecampSuburban 1Emile D.12:15P

A pinned cell is the AD saying they know better than the tab. Nothing overwrites it after that.

Running a Distant Location?

Lodging and Transpo ship on the Company plan. Company is not yet officially available. Tell us about your show and we will let you know when it opens up.