Please enable JavaScript.

Coggle requires JavaScript to display documents.

Incentive Earned KAM =sum('KAM Calc'!S5:S185), 2.Regular Sr. KAM…

- - - - Yes
        
        sum(H5,K5,N5)
        
        H5 = Amount
        
        F5*G5
        
        F5-Total Flats
        
        Flats On-boarded + Adoption Flats
        
        2 more items...
        
        G5 - Multiplier
        
        KAM Criteria for different cities
        Sheet
        
        1 more item...
        
        K5 =Amount
        
        I5*J5
        
        I5-Dowloads Increased
        =ifna(VLOOKUP(A13,'Downloads increased'!A:C,3,0),0)
        
        1 more item...
        
        J5-Multiplier
        
        N5=Amount
        
        L5*M5
        
        L5
        
        (Unique CMs to be Resolved of Unique residents per Sold flats in a Society) in Aug month
        
        1 more item...
        
        M5
        
        Multiplier
      - No
        
        sum(H5,K5,N5)*R5
      - KAM Criteria
        
        % of Entries per sold flats (entries < 5%) reduced as per numbers at start of month
        
        Multiplier
- - - - =F8*G8
        
        F-
        Total Flats/KAM
        =iferror(ROUNDUP(SUM(D5:E5)/C5),0)
        
        D-
        VMS Flats ONboarded
        
        E-
        Adoption ONboarded
        
        C-
        No Of KAMs
        
        G-Onboarding Multiplier
    - - =ROUNDUP(I8*J8)
        
        I-Downloads increase/KAM
        
        J- Multiplier
        
        SR.KAM Criteria
    - - SR KAM
        sheet
        
        =iferror(if(B5="Ahmedabad", VLOOKUP(P5,'SR KAM '!$L$3:$N$8,3,1), if(B5="Bangalore", VLOOKUP(P5,'SR KAM '!$L$10:$N$15,3,1), if(B5="Chennai", VLOOKUP(P5,'SR KAM '!$L$17:$N$22,3,1), if(B5="Gurgaon", VLOOKUP(P5,'SR KAM '!$L$24:$N$29,3,1), if(B5="Hyderabad", VLOOKUP(P5,'SR KAM '!$L$31:$N$35,3,1), if(B5="Jaipur", VLOOKUP(P5,'SR KAM '!$L$38:$N$43,3,1), if(B5="Kochi", VLOOKUP(P5,'SR KAM '!$L$45:$N$50,3,1), if(B5="Kolkata", VLOOKUP(P5,'SR KAM '!$L$52:$N$57,3,1), if(B5="Mumbai", VLOOKUP(P5,'SR KAM '!$L$59:$N$64,3,1), if(B5="Nagpur", VLOOKUP(P5,'SR KAM '!$L$66:$N$71,3,1), if(B5="Navi Mumbai - Nmt", VLOOKUP(P5,'SR KAM '!$L$73:$N$78,3,1), if(B5="Navi Mumbai - Thane", VLOOKUP(P5,'SR KAM '!$L$80:$N$85,3,1), if(B5="Noida", VLOOKUP(P5,'SR KAM '!$L$87:$N$92,3,1), if(B5="Pune", VLOOKUP(P5,'SR KAM '!$L$94:$N$99,3,1), if(B5="South Mumbai", VLOOKUP(P5,'SR KAM '!$L$101:$N$106,3,1)))))))))))))))))
        
        CSAT Rating
        
        L slab Origin
        
        N-Rate
- - - - As per july incentive structure
        
        =sum(D2,F2)
        
        D-Multiplier
        
        F - Rate
    - - As per city ops
        
        =VLOOKUP(A2,$A$10:$D$15,4,0)
        
        A-KAM EmailID
        
        D-Multiplier