Just playing around with Excel to create a simple formula that calculates a blended churn average for mobile operators.

Some operators report contract churn and prepay churn but fail to provide a blended churn rate. Of course, given the variation in subscriber numbers on each plan type you need to work out a weighted average.

Anyway, here it is. Feel free to use it (values in red must be entered)!

https://r.office.microsoft.com/r/rlidExcelEmbed?su=720413751230544573&Fi=SD9FF6C7D65673ABD!164&ak=t%3d0%26s%3d0%26v%3d!AJ1mucIx7-ODGDA&kip=1&wdAllowInteractivity=False&Item='Sheet1'!A1%3AE8&wdHideGridlines=True&wdDownloadButton=True