An individuals chart is useful when observations arrive one at a time. Consecutive-pair moving ranges estimate short-run variation. Keep the time order; sorting the data creates an artificial series with smaller changes. Check unusual patterns and data collection conditions rather than widening limits whenever an observation is inconvenient.
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.
Preserve time order when estimating individual-observation limits.