Data values for leaf and consolidated cells in a sandbox

Leaf cell values in a sandbox are a combination of the values in the base and sandbox cells. The user-entered values in sandbox leaf cells override the values in the base. If the values are entered over a consolidated cell, the data will be automatically spread and immediately recalculated. Any leaf cell that has not been changed in a sandbox still shows the base data.

Consolidated cells in a sandbox contain values that are the sum of the leaf cells displayed in the sandbox.