Hello,

I am trying to create a spreadsheet where I can get the capability percentages of members based on the courses in Disaster Management they have done. However I need it to take into consideration that they are also trained in other areas which means the probability of that functions capability would be lower.
For example a member may be trained in both House Repair operations and Chainsaw Operations but they wouldnt be able to do both at the same time and I need to capture this in the statistics

I hope this makes sense

Thanks heaps in advance