5YOP Validation

Data Input & Normalization

Data Validation

Data Input (Not Implemented for now)

Data Output

User Instructions

• Excel Reader

  • Before running the full flow, always load the most up-to-date GPL file.

• GroupBy nodes (each new quarter / cycle)

  • Open the node → Manual Aggregation tab

  • Remove the 5 columns from the previous cycle

  • Add the 5 columns for the current cycle

  • Set aggregation for all 5 columns to Sum

• Expression node: “Quarter Total Sum”

  • Update the TCO quarter columns to the new cycle

  • This node creates the summed quarter value used for comparison

• Expression node: “Compare Quarter Sum”

  • Update the original quarter sum column (not the derived one)

  • Use the column corresponding to the current cycle