13 week moving average calculation

[satya04]

I have weekly data available in the sheet and need to compute 13 week moving average. Please guide me on how this could be done.

Thank you for all the help.

[Qiu]

@satya04 
We can use the Multi-row formula and which will a lot formula. or we can use Batch Macro as below.

[satya04]

@Qiu Thank you for looking into this. I was checking the result but it's not calculating moving average for 13 weeks. If the data starts in January 2024 then moving average should be till the first week of March 2024. I am sharing the file here for your reference.

[Qiu]

@satya04 

The Join in your workflow changed the order of the Data and your original dataset is as per Date Accending order to me.

So I add one more RecordID tool to track the order and it should work based on the check of original Excel file.

[aatalai]

You can also use the crew macro with moving summarise that could help

http://www.chaosreignswithin.com/p/macros.html