I think the sheet is fine. I remember going through the document and Xavier’s explanations and clarifications on the forum while writing the Processing, and modifying the validation to fit it all. I think I’ve covered all possibilities, but I’m not in the mood to do it all again without proof, so please, create an example officer to show me where the errors are.
I think it’s more likely you misunderstood what you need to do, especially considering what you wrote in point 2.