I need to calculate the weighted-av-rate using the table below. The
groupings is the TX. The wieghted-av-rate, WVR for 1st day in a TX
group remains same as the rate. E.g in TX A, weighted-av-rate = 1. for
day 2 in TX A, the WVR = ((30*1)+(40*5))/(30+40) and so on. The WVR for
TX B, day 4 is same as the rate,i.e 9. day 5 is obtained using the same
formulae in TX A

pls generate a macro to accomplish this.



DAY TX BALANCE RATE WEIGHTED-AV-RATE
1 A 30 1
2 A 40 5
3 A 10 6
4 B 20 9
5 B 50 5
6 B 30 3
7 C 20 3

thanks.