Bitrate Calculator for Magic Lantern Raw Video

Started by Frank7D, March 05, 2015, 11:09:29 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Frank7D

Hi,

I made myself an Excel spreadsheet that calculates RAW bitrates and recording times for various card capacities, so I thought I'd share it.
Mainly you would be plugging numbers in A3, B3 and C3.
Please let me know if you have any ideas for improvements.

https://docs.google.com/spreadsheets/d/1QftEHOB9VbtIGZSUD0qFXI0sfN3lVK4-/edit?usp=sharing&ouid=116848902431971067017&rtpof=true&sd=true

Audionut


Frank7D

I just updated it so that if you change the color depth (which you probably wouldn't normally do) it will plug into the formula (I had it hard-coded to "14" before).

saeed2vfx

Quote from: Frank7D on March 06, 2015, 02:14:02 AM
I just updated it so that if you change the color depth (which you probably wouldn't normally do) it will plug into the formula (I had it hard-coded to "14" before).

nice work !

ewinemiller

Hey Frank,

Are you handy with a compiler? Would you consider making it a module?

I put a module out recently that presents some menus, does some math, and shows the results at

http://www.magiclantern.fm/forum/index.php?topic=17874.0

It seems the pattern could be adapted to a bitrate calculator.

Regards.

Frank7D

Hi ewinemiller,

I don't have experience doing that sort of thing, but if someone who does wants to try I would be glad to explain any of the formulas that aren't clear from the spreadsheet. The math isn't complicated.

Frank7D


NJ_filmmaker

This has helped to plan storage needs for an upcoming video shoot. Greatly appreciated.

Frank7D

Updated with compression ratio field ("Comp ratio").
At =1 there is no compression. From what I understand, ML lossless tends to run from .4 to .6, depending on the nature of the subject being shot, so .5 might be a good value to get an estimate.