Try my Ultimate Bitrate Spreadsheet.

[randallc]

Ok, Ultimate, maybe not...

But I got tired of not ever finding a bitrate calculator that I felt was worth its download time for VCD/SVCD so I made a spreadsheet that gives me what I want to see.

Please take a look and see if it works for you. Tell me if you like or where it could be improved.

www.TechPimp.com/videocd/VCD-SVCD%20bitrate%20spreadsheet.zip

Randy

[Kdiddy]

Didnt look at you spreadsheet but what problems did you have with the one provided by this site

http://www.vcdhelp.com/calc

or a excellent one provided with the software DV Tool?

http://www.musclesoft.de/~combatman/sindex.html

[randallc]

well the one at: http://www.vcdhelp.com/calc is extremely basic.

I'd suggest you take a second to look at mine and compare.

I've got 74, 80, and 90 minute cdr's I use. My spreadsheet helps me figure out the best fit and at what bitrate at a glance. The vcdhelp calc doens't give that sort of info without a lot of playing around and a stellar memory.

I'd try DV Tool but it won't download, the link is bad on their site.

Randy

[randallc]

I just found DV-Tool at another site and checked it out.

Its probably the best calculator I've seen yet, but still so difficult to get the info I want. My spreadsheet is much more informative and easier to use for the VCD/SVCD maker.

[Dunkem]

randallc,
Looks quite good at a quick glance but how about letting the user adjust the Audio bitrate. Changing the value in cell D4 has no effect on the results, surely cells D11, F11, H11, J11, D19, F19, H19, J19, D27, F27, H27 and J27 should all be set to equal D4. If this happened the Audio bitrate would then be accounted for in your calculations.

Dunkem

[Kdiddy]

Well like I said, I didnt look at it all, but will do it now. Honestly, I think the one this site & dvtool provide are quite enough and very straight forward for what the most people need especially when compared to dealing with a spreadsheet file. It gives the same options you mentioned, and one would key the variables as would they have to do for yours. Just because they do suit your every need doesnt neccessarily make them bad/useless calculators. This seems like something that works for you, but I dont know if I would recommend it over the others. there interfaces are simpler to understand, especially looking at it froma newbie standpoint.

Some things I noticed:

1) What about those who want to try fit something on 1 CD??
2) Changing the audio #1 bitrate & leaving audio #2 blank had no effect on total bitrate?
3) I didnt throughly check your calcualtions but off hand it appear that you didnt account for padding/data stream overhead, you values seema smudge hugh.


<font size=-1>[ This Message was edited by: Kdiddy on 2001-11-07 22:07:55 ]</font>

[randallc]

Dunkem - thanks for catching the audio bitrate not hitting the calculations. This has been fixed and uploaded to the site.

Kdiddy, if you prefer the others I understand. My 'thang' is that by entering 1 single number (minutes) I can see at a glance what bitrates fit to how many cd's. That's much faster and simpler than the other options for me. I also changed the calculations a bit to account for the overhead as you suggested. I also added a Single CD bitrate section for the SVCD. I guess I was thinking of putting DVD's into SVCD, but there are a lot of other purposes for SVCD that would fit on a single cd - thanks.

Do you guys think I should clean up the display and remove the: "Total kbits" and "Megs/Minute" lines? I had them there stictly for informatative purposes, maybe it'd be easier to read without it?

<font size=-1>[ This Message was edited by: randallc on 2001-11-08 00:19:46 ]</font>

<font size=-1>[ This Message was edited by: randallc on 2001-11-08 00:21:59 ]</font>

[Jerry]

Hi,

Thanks for the calculator, this one will work on my mac using excel. The others only work on pc.

Thanks, Jerry

[Peter]

The idea is real good, you can see how many cd's and what size cd's at once.

But why not make a nice little proggie of it, that's really easy to do

[randallc]

Peter, I'd gladly do it - but my expertise is Excel not coding.

If you'd like to take the idea of my spreadsheet and make it into a program you've got my blessing. Please let me know if you do.

Randy

[Big_Jit]

Hey man I wanna check out your Spreadsheet but i don't have excell can you make one in Microsoft Works or is there another way to view it

[Peter]

<TABLE BORDER=0 ALIGN=CENTER WIDTH=85%><TR><TD><font size=-1>Quote:</font><HR size=1 color=black></TD></TR><TR><TD><FONT SIZE=-1><BLOCKQUOTE>
On 2001-11-08 17:01:05, randallc wrote:
Peter, I'd gladly do it - but my expertise is Excel not coding.

If you'd like to take the idea of my spreadsheet and make it into a program you've got my blessing. Please let me know if you do.

Randy
</BLOCKQUOTE></FONT></TD></TR><TR><TD><HR size=1 color=black></TD></TR></TABLE>

I'll make a program of it tomorrow and will give it to you.

[flaninacupboard]

i don't like the one on this site either, because it gives the wrong results, every time! i've started doing:

795*8*1024/seconds-audio bitrate. works for me