Blendpipe homeSend a brief
Menu

Versioning matrix calculator

Count every file a campaign needs, and the edit and quality check hours behind them.

Send a brief
You enter
Concepts, lengths, ratios, languages, offers
You get
Deliverable count, extra versions, edit and check hours
Example
1 x 3 x 4 x 2 x 1 = 24 deliverables
Runs
In your browser; nothing is sent
A silicone ice cube tray on a kitchen counter with every square filled with water, and a drawn steel-blue ice cube sitting in one square.

Calculator

The values filled in come from the fictional Orlenna example campaign; money values are illustrations, not Blendpipe prices. Replace them with your own; results update as you type. Nothing you enter leaves your browser.

For example 30, 15 and 6 seconds.
For example 16:9, 9:16, 1:1 and 4:5.
Reframing, retiming type and captions, export.
Watching the file through, checking specs, loudness and captions.

Results

Deliverables
24 files
Extra versions beyond one hero master per concept
23
Edit hours
18.0 hours
Quality check hours
4.0 hours
Total hours
22.0 hours
Eight-hour days
2.8

Every added language, ratio or offer multiplies the whole matrix. Cut the matrix to the placements you will actually buy before you add another dimension.

A campaign is rarely one file. The hero spot becomes shorter cuts, each cut is reframed for vertical, square and portrait placements, and each of those may need another language or another offer. The deliverable matrix is the table of every combination, and it grows by multiplication, not addition. This calculator counts the files and the hours behind them, so the matrix can be agreed before anyone starts cutting.

How to use it

Enter a count for each dimension of the matrix and a time for each file.

  • Concepts or scripts. Different creative ideas or scripts, each with its own hero master.
  • Lengths per concept. For example 30, 15 and 6 seconds.
  • Aspect ratios. For example 16:9, 9:16, 1:1 and 4:5.
  • Languages. Each voiceover, caption or on-screen text language.
  • Offer or call-to-action variants. Different end cards, prices, dates or calls to action.
  • Edit time per version, in minutes. Reframing, retiming type and captions, and the export.
  • Quality check per version, in minutes. Watching the file through and checking the spec, loudness and captions.

How the calculation works

  • Deliverables = concepts x lengths x ratios x languages x call-to-action variants.
  • Extra versions = deliverables minus one hero master per concept.
  • Edit hours = deliverables x edit minutes / 60. Quality check hours = deliverables x check minutes / 60.
  • Total hours = edit hours + quality check hours. Eight-hour days = total hours / 8.

The worked example

Example (fictional). The Orlenna Ridge Bottle campaign has one concept in 3 lengths (30, 15 and 6 seconds), 4 aspect ratios (16:9, 9:16, 1:1 and 4:5), 2 languages (English and Spanish) and 1 call to action. That is 1 x 3 x 4 x 2 x 1 = 24 deliverables, or 23 extra versions beyond the hero master.

At 45 minutes of edit per version, 24 files take 18.0 edit hours. At 10 minutes of quality check each, they take 4.0 hours. The total is 22.0 hours, or 2.8 eight-hour days.

Reading the result

The count is the number to agree first. Every file in it has to be cut, checked, named and delivered, so a matrix that includes placements nobody will buy is work with no audience.

Small changes move the count a lot. In the example, a third language takes the matrix from 24 to 36 files and the hours from 22.0 to 33.0. A second offer doubles it to 48 files. Dropping one ratio instead brings it to 18 files and 16.5 hours. Cut the matrix to the placements you will actually buy before you add another dimension.

The extra versions figure (23 in the example) is the quantity for the versions line in the video budget calculator. The hours are a check on that line: if the cost per version does not cover the edit and check time, one of them is wrong.

Limits

  • Every version is given the same edit time. Often the first vertical cut of each length takes longest, because it sets the new layout, and the language swaps that follow are quicker. A 6-second cut may need new shots or type rather than a trim.
  • The hero edit is not counted here; it belongs in the post days of the budget.
  • Caption and subtitle files, stills and thumbnails are not counted as deliverables. Add them separately if a destination needs them.
  • Not every length needs every ratio. A 6-second bumper may run only in 16:9, and a 9:16 version may only be needed for the shorter cuts. Enter the matrix you will buy, or calculate each row of the plan separately and add the results.
  • Reframing is faster when it is planned. Footage shot for the tallest crop and graphics built to re-lay out need less work per version; the aspect ratio crop calculator shows how much of a 16:9 frame survives each crop.

The matrix decides what goes into campaign versioning and what you receive in the handover: masters and versions named to the matrix, as listed on deliverables. Each destination has its own frame size, length and file limits, so check the delivery specs checklist before export. The full Orlenna matrix appears in the example campaign.

Put the matrix in your brief: list the placements, lengths, ratios and languages you plan to buy, and send a brief. The production plan returns it as a deliverable matrix with the hours and cost of each row.