Each "RUG"(RUX, RUC,RUL....) has a rate associated with it. The first thing I need is a formula that can give me one blended rate. For example I want .75 of the rate to be from the RU category and .15 from RV etc. Next at the end of each rug is a letter A,B,C,V,X... I need to be able to say that of the .75 RU's .40 should be RUC and .15 should be RUB...
I need the formula to be dynamic so I can change the percentages. Hope this is clear enough