Coin flipping - logic formulas

Given a stack of n coins, flip the top coin, then the stack of the top two coins, then the stack of the top three etc... starting again with the top coin after flipping all n coins. A flip of m coins reverses their order and inverts their state. This is the number of flips required to restore the stack to its original configuration.

Hi,

I have been solving/modelling this problem using different ways (imperative, oop, funtional etc). I have solved it using vba but now want to try solving it using only worksheet functions.

I have attached a rough copy that I did manually (I have too much time on my hands!). The problem models quite easily this way but I want a formula that can pasted to allow any size stack of coins. I have played around with OFFSET() but this so far has become too complicated and unwieldy. The manual formula entry is simple see entries beginning J30.
Any pointers?

Thanks in advance.