Hi @djzelenko and everyone for the help and suggestions.
If there is a spreadsheet that would be really good, also if you have a method to compile it from the xml file that would be really good to know also - we had a look through the archicad xml files on the dulux page and i saw those color values but i found it difficult to scrape the data from it. It would be good to know the process as they do update colors etc.
thanks @jeremy5 also for providing that info regarding the 16-bit rgb values.
Once I have the color data we can make some grasshopper definitions to help others who want to do similar things.
Thanks,
A.
-grasshopper has so many obscure uses!-