Here is the gist of what I want to accomplish.

I want excel to select from a list of workout programs based on a set of weighted averages. Below is a general set up of what I have.

Priority is based on the value that is calculated using an algorithm.

Priority Value Workout
1 4 Core
2 6 Legs
3 7 Arms
3 7 Back
4 9 Yoga
5 10 Plyo
5 10 Cardio
5 10 Agility
5 10 Running

Each workout program (I substituted generic workouts for the actual proprietary information) has a certain number of days such as 12, 24, 28, 30, 35 etc.

I think the next step would be to calculate the weighted average. The goal is to have priority 1 be scheduled twice as often as the priority 2 which will be scheduled twice as often as priority 3, etc. Also when multiple workouts share a priority like 3 and 5 do, then the priority 3 or 5 percentage would be divided evenly among all of the priority 5 workouts. What formula can i use to calculate these values. The formula needs to be able to expand as more workouts are added and the values automatically updated.

Once these weighted averages are calculated then is there a formula in excel that would use these percentages for each workout to randomly select a workout from the list.

If this is possible then can the first occurrence of that workout say Day 1 and then subsequent occurrences of that workout count the days sequentially.

Another thing that I would like to add into this process is the fact that once the workout is randomly scheduled the number of days stated above. Then it is completed, the priority value gets removed and the percentages get updated.