Paired data link the same unit before and after a change. Form one difference per pair in a declared order, then analyze the differences. The number of pairs is the sample size. Pairing can remove stable differences between units, but it does not remove time trends or concurrent changes that could explain the result.
You work with original records from fictional operations teams. Start by checking what each column means and which cases belong in the denominator. A precise calculation can still answer the wrong business question if the population or time boundary changes. Use the worksheet to leave an audit trail: preserve the inputs, record the intermediate outputs and check the stated exception. The transfer case uses new data so you must apply the method again.
Analyze matched differences rather than treating pairs as independent groups.