Calc dynamic running total in horizontal sequence

All,

I know the title may be a little confusing so hopefully I can clarify. I have forecast values in horizontal layout and all fractional values. I would like to add each cell till their sum = 1, and then have the calculation start all over again (accounting for any remainder >1). Is this possible without VBA?

I have attached a workbook with a row entitled "ideal output".

Thanks again for taking the time and consideration to look at this!

Administrative Note:

Welcome to the forum.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here. I am, therefore, closing this thread, but you may continue here in the original thread: link to be added here
https://www.excelforum.com/excel-for...-sequence.html