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 v4c 26.04.2021: Bugfixes and additions
Update v4b 08.04.2021: Bugfixes and additions
Update v4a 09.02.2021: Major rework
Update v3b 22.07.2020:
Initial Release v3a 21.07.2020:
LibreOffice ODT and MS Excel XLSX included.
* I haven't included audio stream data into the calculation - because honestly it doesn't matter.
Download latest calc sheet here:
Previous version for pre firmware 7.3 users:
Please post your feedback / found errors in this thread.
Update v4c 26.04.2021: Bugfixes and additions
- Added: Parallel to the release of Camera Firmware 7.3 now the new Q1 and Q3 BRAW modes are calculated for PCC6k and PCC4k; and Q0 and Q5 have been adapted to the new compression schemes
- Added: .xls version for fans of very old Excel 97-2003 (together with Open/Libreoffice .ods and modern Excel .xlsx versions)
- Fixed: first 2 columns and rows are set to "fixed" now so they don't scroll with the rest of the sheet
- Fixed: a few minor formula bugs have been fixed
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
- Datarates for Blackmagic Camera Codecs v4a 2021.png (107.46 KiB) Viewed 10046 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 v4c 2021.zip
- (83.76 KiB) Downloaded 835 times
Previous version for pre firmware 7.3 users:
- Datarates for Blackmagic Camera Codecs v4b 2021.zip
- (44.22 KiB) Downloaded 269 times
Please post your feedback / found errors in this thread.
Last edited by Robert Niessner on Mon Apr 26, 2021 5:08 pm, edited 12 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
--------------------------------
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