There was a small error on the second page which is fixed in the attached copy.
Also several hotels came up with some discrepancies which was due to some new channels which were not mapped on the tool. I have added them on the attached file.
Should you face any issue in the future
1) Unhide mapping table.
2) Go to this year or last year tab and find the Sec_ channel tab (* Column L) which is not present in the mapping table
3) Add the channel name and the major group in the mapping table.
Should you have any issues please do let me know.