Video Production Math: Frame Rates, Timecode, Bitrates, Storage & Delivery Specs

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• Turn camera timecodes into frame numbers, measure edit events from their in and out points, write a duration back as HH:MM:SS:FF with INT, MOD and TEXT, and total the length of a rough cut.
• Convert camera bitrates in megabits per second into megabytes per minute and gigabytes per hour, size one camera's footage for a shoot day and work out how many memory cards Ines must prepare.
• Estimate how long each evening's offload takes at the card reader's speed, when it finishes, how many backup drives the shoot needs for three copies and how much space is left on each.
• Work out the largest crop of the UHD master for vertical, square, portrait and cinema frames, round it to even pixel counts, measure how much of the picture each crop keeps and set the title-safe margin for the vertical cut.
• Convert shutter angles into shutter speeds, find the playback speed of each high-frame-rate shot on a 25 fps timeline, calculate how long a moment lasts on screen and the frame rate a director's slow-motion request needs.
• Count the characters of each subtitle with LEN, measure its duration, calculate the reading speed in characters per second and flag every subtitle that breaks the house rules with one IFS formula.
• Work out the highest video bitrate that keeps each deliverable under its file-size cap, estimate export times from the machine's speed factor, size the proxy files and total the export time for the whole delivery.
• Count delivered items with COUNTIFS, find the open deliverables due in the next seven days, compare storage used with the plan and chart planned against used storage by area.