Please enable JavaScript.
Coggle requires JavaScript to display documents.
FSD Expert Incentive, Sr FSD Experts, FSD USAGE, City Reps - Coggle Diagram
FSD Expert Incentive
-
=COUNTUNIQUE(FILTER('FSD Expert Calc'!A2:A,'FSD Expert Calc'!P2:P>0))
-
P-Final Amt
=(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...
-
-
-
-
-
=AVERAGE(FILTER('FSD Expert Calc'!P2:P,'FSD Expert Calc'!P2:P>0))
-
=MEDIAN(FILTER('FSD Expert Calc'!P2:P,'FSD Expert Calc'!P2:P>0))
-
-
-
-
-
-
-
FSD USAGE
-
-
Eligible
=COUNTUNIQUE(filter('new usage calc'!A2:A,'new usage calc'!P2:P>0)) :
-
-
-
Average(Eligible)
=AVERAGE(FILTER('new usage calc'!P2:P,'new usage calc'!P2:P>0))
-
-
-
-
-
-
-
-
-
-