Hello...I'm trying to set up a rolling weekly spreadsheet for AFR...I have the numbers, in terms of staff and hours worked, but I'm struggling to figure out how to enter this into a spreadsheet in order to work out a rolling weekly figure.....Tried a few youtube videos but nothing on AFR...Can anyone help, this would be greatly appreciated?

haha, thankfully we don't...I worked out a spreadsheet...was pretty simple when I finally figured it out....We have weekly management meetings, so if theres an accident, it'll affect the score, so my boss wants me to reflect that on the meetings....monthly would make more sense, but simply because of the weekly meetings, they want weekly scores...Got acountants to send the required information, so ill just do the calculation and compare to the previous week...thanks for the advice chris