Balance of OT calculation

[Janmy]

Hi

Please help to set the formula for the calculation of "Balance of". Thanks

3 a b c d e f g h I
4 Apr 04 May 04 Jun 04 Jul 04 Aug 04 Sep 04 Oct 04 Nov 04 Dec 0
5Overtime: 1st 3 hrs 10.0 0.0 10.0 0.0 10.0 10.0 10.0 10.0 10.0
6 4th hrs 0.0 5.0 1.0 0.0 2.0 2.0 2.0 2.0 2.0
7Total claim 10.0 5.0 11.0 0.0 12.0 12.0 12.0 12.0 12.0
8Total set-off 3.0 11.0 1.0 17.0 1.0 1.0 1.0 1.0 1.0
9
10 B/F 7.0 1.0 11.0 (6.0) 5.0 16.0 27.0 38.0 49.0
11
12 Balance of:
13 April 7.0 0.0 0.0 0.0
14 May 1.0 0.0 0.0
15 June 11.0 0.0
16 July (6.0
17 7.0 1.0 11.0 (6.0

OT claim can only accumulate for three months, on the fourth month the first month OT will be forfeited.

b13=April OT claim - April total set-off
c13=condition 1: balance of OT in April (b13)='0' and no OT claim in May (c8) show '0'
condition 2: balance of OT in April (b13) >0, first deduct April OT balance (b13) then deduct May OT (c8)
condition 3: c8>b13=0
c14=condition 1: c8, b13=0 show 0
condition 2: b13-c8=negative, c10-c13
condition 3: c13=0, c4+b4-c8-b8
d13=condition 1: c13=0 show 0
condition 2: d13>0, c13-d8
condition 3: c13-d8=negative, show 0
d14=condition 1: c14<0 show 0