@All,
Here's a spreadsheet (Thanks to Gaudi) to calculate file size.
Please give me some feedback about whether to include it in
the
Guide to convert Divx (avi) to KVCD.
File Prediction
…………………......
A..........................
B…………………………………
..1..
Inputs…………………………………………………………………
..2……………………………………………………………………………….
..3 No. of CD’s.............................1…………………………………….
..4..Audio File Size.......................99,000,000…………………………
..5..Totals Frames........................152,255…………………………….
..6..Test Frames...........................2,544………………………………
..7..Movie Length (seconds).........6350…………………………….…
..8..Test File Size..........................24,053,987…………………………
..9..Current CQ............................100…………………………………
.10…………………………………………………………………………………
.11..
Results……………………………………………………………………….
.12………………………………………………………………………………...
.13..CD.File.Size............................=813, 019,155.*.B3………………...
.14..Factor.....................................=@ Round(( B5 / ( B7 / 60 ) / 24,2)
.15..Target File Size.......................=@Round((( B13 – B4 ) / B5 ) * B6,2)
.16..New CQ..................................=@Round(( B15 / B8 ) * B9,2)……..
.17..Diff %.....................................=@Round(( B15 – B8 ) / B15,2)…….
.18..Corrected CQ..........................=@Round(( B9 + B16 ) / 2,2)……….
Enter data in Inputs. Results will give you the calculations. Use Corrected
CQ for your next test. If Diff % is ~3% or less, you have come close to your
Target File Size. If Corrected CQ is greater than 100, than use 100 the limit of
Tmpgenc. Row 17 Diff % is format percentage, 2 decimal places. The other
rows are format numeric with 2 decimal places.
-black prince