Can you help? Alliance per Genus List needed

[cbuchman]

I'm hoping someone has already done this or can point me in the right direction. I am building an Excel spreadsheet to facilitate plant registration at my Orchid Society shows. I have a list of abbreviations for genus names, and I've already written the code to look up one from the other.

What I am looking for is the orchid Alliance for each genus so that I can "error proof" the class registration such that the user can only choose a class that is appropriate for the orchid alliance. My goal is to reduce obvious errors in registration such as a Phal ending up in a Cattleya class

Alliances I've seen used are Cattleya Alliance, Paphiopedilum Alliance, Sarcanthinae Alliance, Phalaenopsis Alliance, Oncidium Alliance, Cymbidium Alliance, Dendrobium Alliance, Pleurothalid Alliance, etc.

I hope this makes sense and someone know where to find such a list! Otherwise, I have a lot of work to do....

Thanks in advance for any help you can provide!