Abstract
You need to smoothen inner-period values, keeping the book-end values and the overall (total) average?
Here you go:
Download
Please read my Disclaimer.
smoothing_inner_period_values.xlsx [17 KB Excel file, open and use at your own risk]
Smoothing Inner Period Values (Excel)
Smoothe Inner Period Values And Keep Total Average
Published by Bernd Plumhoff