@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