Please enable JavaScript.

Coggle requires JavaScript to display documents.

FSD Expert Incentive, Sr FSD Experts, FSD USAGE, City Reps - Coggle Diagram

- - - - =(O10*1200)+N10
        
        O-Total Multiplier
        
        =sum(G10,L10)
        
        G -
        Onboarding multiplier
        
        =ifna(VLOOKUP(F10,'fsd expert'!$N$5:$P$12,3,1))
        
        F -
        ONboarding %
        
        2 more items...
        
        L - Reposting multipler
        
        =ifna(VLOOKUP(K10,'fsd expert'!$W$25:$Y$41,3,1))
        
        K-Reposting %
        
        1 more item...
        
        FSD Expert Page
        
        W (Slab) :red_cross:
        
        Y(slab) :red_cross:
        
        N - Online trans count multipler *sold flats
        
        =SUMIFS(Onboardings!I:I,Onboardings!H:H,A10)
        
        H: FSD Expert Email
        
        =ifna(VLOOKUP(B3,mapping!C:D,2,0)) :warning:
        
        B -Original Closure Number
        
        mapping
        
        2 more items...
        
        I:
        Online trans amount
        
        =D2*1.25 :red_cross:
        
        D-
        Sold Flats (ERP)
        
        A - Kibana ID
- - - - Eligible
    - - Total
- - - - L- Incentive Earned
        
        =sum('FSD Expert Calc'!P2:P)
        
        p- Final Amt
    - - Total
        
        =COUNTUNIQUE('FSD Expert Calc'!A2:A)
    - - I-Designation Variable Pay
        
        12000 :warning:
- - - - 0- Total multiplier
        
        =sum(F20,H20,L20,N20)
        
        F -Reposting multipler
        
        =ifna(VLOOKUP(E20,'fsd usage'!$J$18:$L$24,3,1))
        
        E - Reposting %
        
        =iferror(D20/C20,0)
        
        2 more items...
        
        fsd usage: Reposting points:
        
        J -
        Reposting slabs
        
        L -Multiplier
        
        H - OT Multipler
        
        =VLOOKUP(G20,{'Usage Calc'!G:G,'Usage Calc'!H:H},2,0)
        
        G - online Transactions %
        
        =ifna(VLOOKUP(B2,'Online Trans'!A:D,4,0))
        
        2 more items...
        
        H - OT Multiplier
        
        L - Failure multipler
        
        =ifna(VLOOKUP(K21,'fsd usage'!$N$57:$P$64,3,1))
        
        K - Reposting Failure %
        
        =iferror(J2/I2,0)
        
        2 more items...
        
        fsd usage
        
        N -Reposting Failure societies List :slab
        
        P - Multiplier
        
        N - Auto bill multipler
        
        =ifna(VLOOKUP(M20,'fsd usage'!$H$80:$J$84,3,1))
        
        M - Auto Bill Scheduler
        
        =COUNTUNIQUEIFS('Auto Bill generated'!A:A,'Auto Bill generated'!E:E,A20)
        
        fsd usage:
        :green_cross:
        New Feature usage( Guard collection, Reconciliation, Auto Bill scheduler) : if Multiple features added in ERP then points will be double as per criteria
        
        H - slab
        
        Guard Collection - Min 5% or 10 Transaction
        Reconciliation - MT940 Format upload
        Auto Bill Scheduler - As per Activation done in particular Month
        
        J - Multiplier
- - - - =O21*1200
        
        0 - Total multiplier
        
        =sum(F20,H20,L20,N20)
- - - - O- Total Multiplier
        
        =sum(F20,H20,L20,N20)