I thought I'd update this. I just realised that I was looking at the wrong diagrams in Elsawin when I worked out the above spreadsheet. The CEM pin assignments would have been correct if my car had the 8P0 907 279 CEM. However I figured that my car actually have the 8P0 907 063 A module with the 3x 52-pin connectors. I've added the corrected spreadsheet to the following thread as it will be more appropriate to be there:
Sorry about the confusion.