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:
http://www.audi-sport.net/vb/a3-s3-...010-wireing-2010-cemc-module-please-help.html
Sorry about the confusion.
http://www.audi-sport.net/vb/a3-s3-...010-wireing-2010-cemc-module-please-help.html
Sorry about the confusion.