4 Replies Latest reply on Nov 18, 2016 7:02 AM by erin.crean

    Need to calculate % overlap

    erin.crean

      We need to be able to look at various IT products and find duplication/overlap in what activities they perform.  Each tool owner selects from a set list and identifies what activities the particular system performs. In real world scenario we are talking about 1000+ systems and a list of 1500 activities to choose from. In my sample files, I have 3 tools and activities they are aligned to. I attached the excel and a workbook with the data in it as well.

       

      We want to be able to look at it several ways, but the most common question we need to answer is: How many activities do any selected tools have in common - their % of overlap? 

       

      Any assistance is appreciated.