BNI Alabama - Individual Member Traffic Light Tool
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
$
%
123
 
 
 
 
 
 
 
 
 
ABCDEFGHIJKLMNOPQRACAD
1
HOW TO USE THIS TOOL:
1. Log into BNI Connect.
2a. Find data on a CURRENT member by running a PERSONAL PALMS or SUMMARY PALMS report for date range desired.
2b. Find data on a PRIOR member by running a SUMMARY PALMS report for date range desired. REMEMBER TO CHECK BOX THAT INCLUDES DROPPED MEMBERS!
3. From your generated PALMS report, input the member totals into BLUE CELLS below. Their overall Traffic Light color will display when all blue cells have data.

***EXAMPLES ARE FOUND IN ROWS 3-6

Want to understand how points are calculated? View the 2nd tab below: "Calculating Points"
2
PALMS report END datePALMS report END datePALMSRGIRGORRIRROV1-2-1sTYFCBCEUTotal # of meetingsRGI & RGO sumRRI & RRO sumTOTAL POINTS EARNEDTRAFFIC LIGHT COLOR
3
1/1/201804/30/1817000216145308102$9,327621930359501-GREEN
4
7/1/201704/30/18292033022516432$10,102213722215002-YELLOW
5
7/1/201704/30/181800020421013$2,61220204124003-RED
6
7/1/201704/30/182912500110523$1,5521055251504-GRAY
7
60000320305$1,59416535002-YELLOW
8
000#DIV/0!#DIV/0!
9
000#DIV/0!#DIV/0!
10
000#DIV/0!#DIV/0!
11
000#DIV/0!#DIV/0!
12
000#DIV/0!#DIV/0!
13
000#DIV/0!#DIV/0!
14
000#DIV/0!#DIV/0!
15
000#DIV/0!#DIV/0!
16
000#DIV/0!#DIV/0!
17
000#DIV/0!#DIV/0!
18
000#DIV/0!#DIV/0!
19
000#DIV/0!#DIV/0!
20
000#DIV/0!#DIV/0!
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...