8 Replies Latest reply on Dec 5, 2016 10:10 PM by Sireesha J

    How to do Group multiplication

    nagesh aradhya

      Hi Friend ,

       

      Seeking your support to find the RTY(rolled throughput yield) calculation

       

      Sample data attached in Excel sheet.

       

                                                                                                                                                                                        

      Main groupSubgroupTestedPassedYield
      Filter testFilter-1 teste37436296.8%
      Filter-2 test34932492.8%
      Filter-3 test38437397.1%
      Module testeMFT test28326794.3%
      PA test64257789.9%
      OGI testVI test325325100.0%
      VI1 test34834198.0%
      VI-2 test33832596.2%
      Unit testUnit teste34529585.5%

                                                                                                                                                                                       

       

      I would like calculate in the below format

       

      Subgroup test: Sum of all individual tested of subgroup( ex: filter1+ Filter2+filter3)

      Subgroup yield : Subgroup passed/subgroup tested

      RY : Multiplication of all subgroup yield ( 95.75*91.2%*98%* 85%)=73%

       

       

      Main groupSubgroupTestedPassedYieldSubgroup testedSubgroup passedSubgroup yieldRTY
      Filter testFilter-1 teste37436296.8%1107105995.7%73.16%
      Filter-2 test34932492.8%
      Filter-3 test38437397.1%
      Module testeMFT test28326794.3%92584491.2%
      PA test64257789.9%
      OGI testVI test325325100.0%101199198.0%
      VI1 test34834198.0%
      VI-2 test33832596.2%
      Unit testUnit teste34529585.5%34529585.5%