Tabellab
Creative Business Beginner

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

Convert timecode, size cards and drives from bitrates, reframe for every aspect ratio and hit delivery specs, with every cell checked as you go.

8 lessons 8 labs 2.1 h Certificate

One-time payment ยท lifetime access ยท lessons, labs, exam and certificate included ยท no subscription.

About this course

In this course you run the numbers of a fictional documentary production from shoot to delivery. You convert HH:MM:SS:FF timecode into frame numbers and back with INT, MOD and TEXT, turn camera bitrates into MB per minute and GB per hour, and plan memory cards per camera. You estimate offload and finish times, size backup drives for three copies, crop a UHD master to vertical, square and cinema frames with even pixel counts, convert shutter angles into shutter speeds and calculate slow-motion screen time. Finally you check subtitle reading speed with LEN and IFS, find the maximum bitrate for a file-size cap, estimate export times and build a delivery dashboard with COUNTIFS and a chart.

Lessons

  1. Frame Rates & Timecode: HH:MM:SS:FF, Frame Numbers and DurationsLab16 min Pro
  2. Bitrate to File Size: MB per Minute, GB per Hour and Cards per Shoot DayLab15 min Pro
  3. Offload & Backup Plan: Offload Times, Finish Times and Drives for Every CopyLab15 min Pro
  4. Resolution & Aspect Ratios: Crop Sizes, Even Pixel Counts and Safe MarginsLab16 min Pro
  5. Shutter Angle & Slow Motion: Shutter Speeds, Playback Speed and Screen TimeLab15 min Pro
  6. Subtitles: Characters, Durations, Reading Speed and an IFS Quality CheckLab16 min Pro
  7. Export & Delivery: Maximum Bitrate for a Size Cap, Export Times and Proxy StorageLab16 min Pro
  8. The Post-Production Dashboard: Delivery Status, Upcoming Deadlines, Storage Use and a ChartLab15 min Pro