To sum up all the posts about the topic and following advice by ST member Aralo, I have written a program that some of you will find very helpful. This program is divided in two modules, the objective of the first one (product development) is to compute the yaw-independent CdA given probability distributions or general data of bike and wind speed and relative orientation. This parameter allows you to compare different iterations of a product and make a reasonable choice based on the real world conditions that the component will face. The second module is designed to help with equipment selection for a given course and bike and wind speed. It allows to import bike position and speed data obtained from GPS tracking or any other source and compare the average power consumption needed for each setup.
The program can be downloaded from the following link. I have enclosed some data samples in the file to show the data structure that the program handles.
Don't forget to run MCRInstaller before running the app. Have fun and please report any bugs