fasttimes
22nd December 2002, 23:29
I have made a bitrate calculator spreadsheet, that will do most of the math for you. What is really nice about this calculator, is you can take into account multiple video tracks with differing audio and video bitrates, and calculate different scenarios, and you can set you own "file system overhead" percentage. It also has a field for quickly calculating the correct max video bitrate, taking into account the audio bitrate. It was developed, to make the methods I talk about here (http://forum.doom9.org/showthread.php?s=&threadid=40707), easier and faster.
I will write full instructions soon, but it should be no problem to use without them. This is my time creating a spreadsheet program, but it came together really nice. One improvement I would like to make, is the ability to enter the final file size you want, and let the spreadsheet calculate the correct average bitrate to use. Haven't figured out how to make it work, with the current way it's designed.
It comes in both an Excel 95, and OpenOffice 1.0 formats. You can get it by downloading from here (http://www.fasttimesatridgemonthigh.org/vidcap/files/BitrateCalc.zip). If you don't have Excel, you can download the FREE OpenOffice Suite, from here (http://www.openoffice.org), which includes the Excel-compatible "Calc" spreadsheet program.
I will write full instructions soon, but it should be no problem to use without them. This is my time creating a spreadsheet program, but it came together really nice. One improvement I would like to make, is the ability to enter the final file size you want, and let the spreadsheet calculate the correct average bitrate to use. Haven't figured out how to make it work, with the current way it's designed.
It comes in both an Excel 95, and OpenOffice 1.0 formats. You can get it by downloading from here (http://www.fasttimesatridgemonthigh.org/vidcap/files/BitrateCalc.zip). If you don't have Excel, you can download the FREE OpenOffice Suite, from here (http://www.openoffice.org), which includes the Excel-compatible "Calc" spreadsheet program.