WBS (work breakdown structure) with costs
The project managers' WBS: coded phases and work packages (1, 1.1, 1.2...), planned vs. actual cost, the phase taken from the code with LEFT and a summary by phase.
Area: Project management. Level: Advanced.
Functions used: VALUE, LEFT, SUMIF, SUMPRODUCT, SUM.