Spreading to a consolidated cell

With the exception of functions that act on leaves, spreading to a consolidated cell means proportionally spreading to all updateable leaves that have no holds applied.

Procedure

  1. Get the value of the consolidated cell before spreading.
  2. Calculate the sum of all the consolidation's leaf cells that are updateable and do not have a hold applied.
  3. Calculate the non-updateable sum by subtracting <2> from <1>.
  4. Subtract <3> from the spreading value.
  5. Spread <4> to the leaf cells that are updateable and do not have a hold applied. Spread to these cells in proportion to their values before the spreading.