Help for moving average, commission of a day and yearly total commission of salesperson

I don't know how to set up a formular for calculating the moving average of the previous 5 days. The required formular should contain average(), index() and row(). What does the row() indicate?

Next, I don't know how to set up a formular for calculating the commission of a day. Commission rates of each salesperson are provided. The required formular should contain vlookup().

Finally, I don't know how to set up a formular for calculating the yearly total commission of salesperson on sheet 2. The required formular should contain sumif() and it has to refer to sheet 1.

Please help me!

Sheet 1

Date Staff-ID Revenue
31/12/2013 1145064553 76574
30/12/2013 1145075388 89894
29/12/2013 1145067356 143272
28/12/2013 1145064676 100832
27/12/2013 1145038743 109489
26/12/2013 1145074836 77879
25/12/2013 1145020988 87645
24/12/2013 1155074854 54643
23/12/2013 1145027684 97876
22/12/2013 1145028435 153768
21/12/2013 1145099899 97874
20/12/2013 1145011213 67669
19/12/2013 1145022134 112329
18/12/2013 1145029089 98889
17/12/2013 1155039494 70909
16/12/2013 1145049893 65479
15/12/2013 1145030903 122129
14/12/2013 1145029049 93432
13/12/2013 1145009054 77890
12/12/2013 1145015006 83504
11/12/2013 1145090934 75234
10/12/2013 1145017680 82149
9/12/2013 1145089789 82045
8/12/2013 1145022114 73746
7/12/2013 1145009234 109429
6/12/2013 1145028789 104843
5/12/2013 1145089787 92043
4/12/2013 1145019280 93400
3/12/2013 1145089898 73204
2/12/2013 1145000090 64200
1/12/2013 1145015890 109832
30/11/2013 1145015006 89041
29/11/2013 1145024393 100424
28/11/2013 1145027446 140989
27/11/2013 1145019264 90121
26/11/2013 1145015890 109232
25/11/2013 1145022190 120908
24/11/2013 1145000288 81210
23/11/2013 1145024370 72320
22/11/2013 1145000288 72190
21/11/2013 1145022190 91027
20/11/2013 1145024370 86355
19/11/2013 1145022190 90910
18/11/2013 1145012316 109203
17/11/2013 1145015890 62314
16/11/2013 1145022190 87885
15/11/2013 1145024370 66509
14/11/2013 1145098093 80901
13/11/2013 1145024393 109890
12/11/2013 1145015006 88797
11/11/2013 1145016876 92720
10/11/2013 1145043854 93240
9/11/2013 1145044344 92204
8/11/2013 1145024393 60435
7/11/2013 1145015006 120402
6/11/2013 1145022190 120903
5/11/2013 1145067867 110098
4/11/2013 1145012316 109898
3/11/2013 1145015006 89901
2/11/2013 1145019264 94029
1/11/2013 1145048979 120489

Please help me to calculate N-MA and Commission, where N is 5 days

Sheet 2

Staff-ID Staff-Name Commission-Rate
1145083282 Aimee 0.031
1145000943 Mo 0.25
1145089743 Clara 0.023
1145093789 Lara 0.027
1145015432 Amy 0.03
1145025463 Candy 0.012
1145032543 Sally 0.020
1145009898 Wilson 0.14
1145013451 Herman 0.12
1145078456 Sevara 0.24

Please help me to set up formular calculating the yearly total commission of salesperson.

Thanks a lot!!