Please enable JavaScript.

Coggle requires JavaScript to display documents.

Incentive Data: Interns (June 1) - Coggle Diagram

- - - - 1.Copy of kam criteria
        
        columns
      - KAM Calc
        
        columns
      - RA Approved %
        
        columns
      - Downloads
        
        columns
      - Notice Board Dump
        
        columns
      - Onboarding
        
        columns
      - 7.Valid new mobile no. Dump
        
        columns
      - Summary
        
        columns
        
        Designation
        
        2.Total
        
        from sheet: 11.calc
        
        count unique formula:
        =COUNTUNIQUE(FILTER(Calc!A2:A3,Calc!T2:T3>)0)
        
        A - KAMEmail ID
        
        T - Total Amount
        
        Eligible
        
        =COUNTUNIQUE(FILTER(Calc!A2:A3,Calc!T2:T3>0))
        
        Column A
        
        KAM Email ID
        
        Column T
        
        Total Amount
        
        Eligibility %
        
        Eligible/Total
        
        Average (Total)
        
        Sheet calc
        
        column: Total Amount
        
        Take Average:
        =AVERAGE(Calc!T2:T3)
        
        Median (Total)
        
        Take Median of Total Amount (Column) in Calc Sheet:
        =MEDIAN(Calc!T2:T3)
        
        Average (Eligible)
        
        =AVERAGE)(FILTER(Calc!T2:T3,Calc!T2:T3>0)
        
        Median (Eligible)
        
        =MEDIAN(FILTER(Calc!T2:T3,Calc!T2:T3>0))
        
        Designation Variable Pay
        
        %PAYOUT TOTAL
        
        =L2/(I2*B2)
        
        L2- Incentive Earned
        
        I2-Designation Variable Pay
        
        B2 - Total
        
        %PAYOUT ELIGIBLE
        
        =iferror(L2/(I2*C2))
        
        I2
        
        Designation Variable Pay
        
        1 more item...
        
        C2
        
        Eligible
        
        1 more item...
        
        L2 - Incentive Earned
        
        =SUM(Calc!T2:T3)
        
        Incentive Earned
        
        =SUM(Calc!T2:T3)
        
        Sheet : Calc
        
        Column T - Total Amount
      - 9.CSAT RATING
        
        columns
      - 10.SR KAM
        
        columns
      - Calc
        
        columns:
        (No formula)
        
        1.A. KAM Email ID
        
        2.B.City
        
        3.C.Societies On-boarded with VMS (in particular month)
        
        F. Multiplier(VMS)
        
        G. Multiplier(VMS) according to TAT
        
        H. Amount(VMS)
        
        9.I. Adoption Onboarded flats
        
        10.J. Multiplier(Adop_On)
        
        11.K.Amount(Adop_On)
        
        12.L. Downloads
        
        M. Multiplier(Downloads)
        
        14.N. Amount(Downloads)
        
        O. Resident Data(Valid phone no. signed till 31st may)
        
        P.Multiplier(Resident_Data)
        
        Q. Amount(Resident_Data)
        
        18.R. Resident Entry %
        
        S. Multiplier(RA %)
        
        20.T. Total Amount :check:
        
        4.D.TAT
        
        5.E.Flats On-boarded with VMS (in particular month)
      - 12.Complain usage Dump
        
        columns
      - 13.Staff Count Dump
        
        columns