Cpk takes the smaller distance from the mean to either specification, scaled by three within-process standard deviations. An off-center process can have a high Cp and a much lower Cpk. A negative one-sided index means the mean lies outside that specification. Do not replace the minimum with a maximum to make the result appear better.
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.
Use the nearer specification limit to evaluate centering.