Cells populated on slip sheet. Calculating formulas... E6 ( Gaji Pokok): Val='3500000' => CalcValue='3500000' E7 ( Tunjangan): Val='152500' => CalcValue='152500' E8 ( Lembur (Left)): Val='=I8' => CalcValue='170000' E9 ( Kehadiran): Val='100000' => CalcValue='100000' E10 ( Survey): Val='=I9' => CalcValue='200000' E11 ( Konsultasi (Left)): Val='=SUM(L25:L25)' => CalcValue='60000' E12 ( Bonus): Val='100000' => CalcValue='100000' E13 ( Jumlah (Left)): Val='=SUM(E6:E12)' => CalcValue='4282500' E15 ( Zakat): Val='=0.025*E13' => CalcValue='107062.5' E16 ( Denda): Val='50000' => CalcValue='50000' E17 ( TOTAL PENERIMAAN (Left)): Val='=E13-E15-E16' => CalcValue='4125437.5' I6 ( Gaji/Honor (Right Mirror)): Val='=E6' => CalcValue='3500000' I7 ( Tunjangan (Right Mirror)): Val='=E7' => CalcValue='152500' I8 ( Lembur total (Right)): Val='=SUM(L18:L19)' => CalcValue='170000' I9 ( Survey total (Right)): Val='=SUM(L22:L22)' => CalcValue='200000' I10 ( Total Right): Val='=SUM(I6:I9)' => CalcValue='4022500' I12 ( Zakat Right): Val='=E15' => CalcValue='107062.5' I13 ( Transfer Bank (Right)): Val='=I10-I12' => CalcValue='3915437.5' C42 ( Lembur Base (C42)): Val='=E6' => CalcValue='3500000' E42 ( Lembur Day (E42)): Val='=C42/25' => CalcValue='140000' E43 ( Lembur Hour (E43)): Val='=E42/8' => CalcValue='17500' L18 ( Lembur 1 total): Val='=E$43 * 4' => CalcValue='70000' L19 ( Lembur 2 total): Val='100000' => CalcValue='100000'