Data Rate Calc Sheet for BMD Camera Codecs ODT/XLSX v4b

The place for questions about shooting with Blackmagic Cameras.
  • Author
  • Message
Offline
User avatar

Robert Niessner

  • Posts: 3510
  • Joined: Thu Feb 21, 2013 9:51 am
  • Location: Graz, Austria

Data Rate Calc Sheet for BMD Camera Codecs ODT/XLSX v4b

PostTue Jul 21, 2020 3:36 pm

This is a calc sheet for quickly getting the data rates of the most used resolutions and codecs in Blackmagic cameras. You'll get the data rates per second to see if your storage media is fast enough. And the data rates per hour, so you know how much storage you will need.

Update v4b 08.04.2021: Bugfixes and additions
  • Added: now the new Pocket 6k Pro (PCC6k Pro) can be selected. Including its Q1 and Q3 BRAW modes
  • Fixed: Kilobytes conversion for some BRAW rows where it did not switch to base 1000 from 1024
  • Fixed: some BRAW constant quality compression values do differ from camera to camera, for example Q0 has a different range on the PCC4k than on the PCC6k. I've changed the calculations in the list to reflect this

Update v4a 09.02.2021: Major rework
  • added a custom column where you can select from a predefined list of Blackmagic cameras and their respective available shooting resolutions and ratios. This makes Calc Sheet much more flexible. For example you can now also calculate the data rates for 2.40:1 or anamorphic modes.
  • Input fields for Bytes Conversion / Camera Model / Shooting Resolution are now drop down menus where you can select from a list. Horizontal and Vertical Resolution cells are then auto-populated with the correct values.
  • The increased flexibility should make it even more useful. And I can now easily add upcoming cameras and shooting modes

Update v3b 22.07.2020:
  • added the extra 16 pixels around the sensor which BMD uses for demosaicing and other stuff to the calculation
  • it is possible to change the Byte conversion from 1024 (Win PC) to 1000 (Apple OS), the latter reflects exactly the way BMD calculates the data rates - the Apple OS way.
  • Sheet PW protected against manipulation except for the two input fields. If you need to edit for your own needs, send me a PM

Initial Release v3a 21.07.2020:
LibreOffice ODT and MS Excel XLSX included.
  • It not only shows MB/s now, but also calculates the GB/h for most codecs.
    (not for BRAW Q0 - Q5, because of cell space constraints).
  • And I have added several of the resolutions of the latest UMP 12K
You can type in your FPS in the sunny yellow cell and the sheet will auto-recalculate all data rates.

Datarates for Blackmagic Camera Codecs v4a 2021.png
Datarates for Blackmagic Camera Codecs v4a 2021.png (107.46 KiB) Viewed 392 times


* I haven't included audio stream data into the calculation - because honestly it doesn't matter.


Download latest calc sheet here:
Datarates for Blackmagic Camera Codecs v4b 2021.zip
(44.22 KiB) Downloaded 14 times

Please post your feedback / found errors in this thread.
Last edited by Robert Niessner on Thu Apr 08, 2021 2:52 pm, edited 11 times in total.
Saying "Thx for help!" is not a crime.
--------------------------------
Robert Niessner
LAUFBILDkommission
Graz / Austria
--------------------------------
Blackmagic Camera Blog (German):
http://laufbildkommission.wordpress.com

Read the blog in English via Google Translate:
http://tinyurl.com/pjf6a3m
Offline

jallen0

  • Posts: 447
  • Joined: Sun Jun 21, 2020 7:04 pm
  • Real Name: Justin Allen

Re: Data Rate Calc Sheet for BMD Camera Codecs ODT/XLS

PostTue Jul 21, 2020 3:58 pm

Robert Niessner wrote:
** I haven't found a way yet to implement a clickable checkbox for more select-able features like Res = anamorphic or so in the sheet, every way I tried did not work out the way I intended it to be.


Excellent sheet! I'll download it once you get the 12K numbers.

As to your problem look at the concatenate function, that may solve it for you, based on how your sheet is set up.
2019 MacPro Ver 11.1, 160GB Mem, 4TB Drive, 4TB Internal Sonnet Raid, Dual Radeon Pro W5700X 16GB
LG UF 5k, 27" Thunderbolt Display, 55" LG C8 OLED
Resolve Editor Keyboard, Mini Panel, Ultrastudio 4K Mini
Resolve Studio Ver. 17.1
Offline

Chris Leutger

  • Posts: 310
  • Joined: Fri Mar 01, 2013 1:00 am

Re: Data Rate Calc Sheet for BMD Camera Codecs ODT/XLS

PostTue Jul 21, 2020 11:37 pm

Thanks Robert, that's super useful!
Amateur Auteur

i7 8700k 6c 3.7 GHz - Crucial DDR4-2666 16x2
GTX 1080 8GB Ver 456.38 - Windows 10 Pro 19042.746
Resolve 16.2.8.005 - SSD 250GB-cache
Offline

javier forza

  • Posts: 109
  • Joined: Wed Apr 10, 2019 12:34 pm
  • Real Name: javier forza

Re: Data Rate Calc Sheet for BMD Camera Codecs ODT/XLS

PostWed Jul 22, 2020 3:49 am

Congrats! Lot of work.
Works very good in Apple Numbers.
I see 18:1 in BMPCC 4k. It's an anticipation of the next firmware? :lol:
Offline
User avatar

carlomacchiavello

  • Posts: 1392
  • Joined: Tue Aug 28, 2012 6:04 pm
  • Location: italy

Re: Data Rate Calc Sheet for BMD Camera Codecs ODT/XLS

PostWed Jul 22, 2020 7:34 am

Great work Robert


Inviato dal mio iPhone utilizzando Tapatalk
Offline
User avatar

Robert Niessner

  • Posts: 3510
  • Joined: Thu Feb 21, 2013 9:51 am
  • Location: Graz, Austria

Re: Data Rate Calc Sheet for BMD Camera Codecs ODT/XLS

PostWed Jul 22, 2020 11:03 am

OK, CaptainHook send me an answer which explains the discrepancies:

1. BMD cameras do have an extra 16px around the sensor extra to the nominal resolution for demosaicing purposes. So that means to add 2x16px to the horizontal and vertical resolution

2. It seems the team was using 1 MB = 1000 Bytes while I was using 1 MB = 1024 Bytes

So I will add the extra pixels to the sheet in an update, but I will keep it at 1 MB = 1024 Bytes and might add this as a user set-able later.
Last edited by Robert Niessner on Fri Jul 24, 2020 3:35 pm, edited 1 time in total.
Saying "Thx for help!" is not a crime.
--------------------------------
Robert Niessner
LAUFBILDkommission
Graz / Austria
--------------------------------
Blackmagic Camera Blog (German):
http://laufbildkommission.wordpress.com

Read the blog in English via Google Translate:
http://tinyurl.com/pjf6a3m
Offline
User avatar

Robert Niessner

  • Posts: 3510
  • Joined: Thu Feb 21, 2013 9:51 am
  • Location: Graz, Austria

Re: Data Rate Calc Sheet for BMD Camera Codecs ODT/XLS v3b

PostWed Jul 22, 2020 12:02 pm

Update v3b released.
Saying "Thx for help!" is not a crime.
--------------------------------
Robert Niessner
LAUFBILDkommission
Graz / Austria
--------------------------------
Blackmagic Camera Blog (German):
http://laufbildkommission.wordpress.com

Read the blog in English via Google Translate:
http://tinyurl.com/pjf6a3m
Offline
User avatar

robedge

  • Posts: 2000
  • Joined: Tue Dec 24, 2019 1:24 am
  • Location: U.S.
  • Warnings: 2
  • Real Name: Rob Edge

Re: Data Rate Calc Sheet for BMD Camera Codecs ODT/XLS v3b

PostTue Aug 11, 2020 4:29 pm

Robert Niessner wrote:Update v3b released.


Thanks for sharing this.

No problem opening it in Numbers.
Image: Fujinon MK 18-55mm, Leica M primes, Pocket 4K

Sound: DPA & Schoeps mikes, Sound Devices recorder

Post Monitors: Eizo 27" UHD, Focal Solo6 Be
Offline
User avatar

Robert Niessner

  • Posts: 3510
  • Joined: Thu Feb 21, 2013 9:51 am
  • Location: Graz, Austria

Re: Data Rate Calc Sheet for BMD Camera Codecs ODT/XLS v3b

PostTue Feb 09, 2021 6:31 pm

Update v4a released. Major rework of the whole sheet interna.
Saying "Thx for help!" is not a crime.
--------------------------------
Robert Niessner
LAUFBILDkommission
Graz / Austria
--------------------------------
Blackmagic Camera Blog (German):
http://laufbildkommission.wordpress.com

Read the blog in English via Google Translate:
http://tinyurl.com/pjf6a3m
Offline

Joaquin Torrents

  • Posts: 53
  • Joined: Wed Aug 22, 2012 7:08 am

Re: Data Rate Calc Sheet for BMD Camera Codecs ODT/XLS v4a

PostWed Feb 10, 2021 5:05 pm

Excellent! Thanks for the work! Very useful!
Joaquin Torrents
Offline
User avatar

robedge

  • Posts: 2000
  • Joined: Tue Dec 24, 2019 1:24 am
  • Location: U.S.
  • Warnings: 2
  • Real Name: Rob Edge

Re: Data Rate Calc Sheet for BMD Camera Codecs ODT/XLS v3b

PostWed Feb 10, 2021 5:19 pm

Robert Niessner wrote:Update v4a released. Major rework of the whole sheet interna.


This would make a very useful forum sticky.
Image: Fujinon MK 18-55mm, Leica M primes, Pocket 4K

Sound: DPA & Schoeps mikes, Sound Devices recorder

Post Monitors: Eizo 27" UHD, Focal Solo6 Be
Offline
User avatar

Robert Niessner

  • Posts: 3510
  • Joined: Thu Feb 21, 2013 9:51 am
  • Location: Graz, Austria

Re: Data Rate Calc Sheet for BMD Camera Codecs ODT/XLSX v4b

PostThu Apr 08, 2021 2:51 pm

Update v4b released. Numerous bugfixes and PCC6k Pro with its new options has been added.
Saying "Thx for help!" is not a crime.
--------------------------------
Robert Niessner
LAUFBILDkommission
Graz / Austria
--------------------------------
Blackmagic Camera Blog (German):
http://laufbildkommission.wordpress.com

Read the blog in English via Google Translate:
http://tinyurl.com/pjf6a3m
Offline

Ellory Yu

  • Posts: 2148
  • Joined: Wed Jul 30, 2014 5:25 pm

Re: Data Rate Calc Sheet for BMD Camera Codecs ODT/XLSX v4b

PostThu Apr 08, 2021 3:11 pm

Robert Niessner wrote:Update v4b released. Numerous bugfixes and PCC6k Pro with its new options has been added.

Thank you for your kind work and contribution to this. It has been very helpful to have such a calc tool.
MSI Raider X99 MB / Intel i7 5280 6 core CPU / 2 x AMD R9 390X 8Gb GPU / 32Gb 3200 RAM / Decklink 4K Mini Monitor / 240Gb SSD OS Drive / 4Tb RAID 0 SSD Cache/Scratch Drive / 24Tb 7200rpm Data Drive / Win 10 Pro 64bit / Resolve 17
Offline

Marshall Harrington

  • Posts: 483
  • Joined: Tue Sep 04, 2012 5:48 pm
  • Location: San Diego, California

Re: Data Rate Calc Sheet for BMD Camera Codecs ODT/XLSX v4b

PostThu Apr 08, 2021 4:24 pm

Super helpful Robert. Really amazing. Thank you.

Return to Cinematography

Who is online

Users browsing this forum: Google [Bot], randyd and 14 guests