ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
UHC - SummaryTERMINO NODECB SALES NODEJB SALES NODEMIGO NODE
2
3
DateTotal CB Commish
(TCBC)		Total Gross Commission
(MIGO)		TCBCFormula
Mig Override - TCBC x 0.125		MIG Net Commish
(MIGNC)		JB Sales Override
(JBSO)		Formula
TCBC - MIGNC x JBSO		Month's TotalRemarks
4
4/30/265.84572.505.84( 572.5 - 5.84 ) x 0.125 = 70.832.025.84 + 70.83 + 2.02 =78.69
5
2/28/265.84620.42( 620.42 - ) x 0.125 = 2.025.84 + + 2.02 =7.86
6
1/31/265.84620.425.84( 620.42 - 5.84 ) x 0.125 = 76.822.025.84 + 76.82 + 2.02 =84.68
7
12/31/255.84679.955.84( 679.95 - 5.84 ) x 0.125 = 84.263.395.84 + 84.26 + 3.39 =93.49
8
11/30/255.84missing( missing - ) x 0.125 = 3.395.84 + + 3.39 =9.23
9
10/31/255.84488.585.84( 488.58 - 5.84 ) x 0.125 = 60.346.485.84 + 60.34 + 6.48 =72.66
10
9/30/255.84293.605.84( 293.6 - 5.84 ) x 0.125 = 35.977.705.84 + 35.97 + 7.70 =49.51
11
8/31/255.84651.735.84( 651.73 - 5.84 ) x 0.125 = 80.747.965.84 + 80.74 + 7.96 =94.54
12
7/31/255.84599.485.84( 599.48 - 5.84 ) x 0.125 = 74.2129.445.84 + 74.21 + 29.44 =109.49
13
6/30/255.781782.945.78
( 1782.94 - 5.78 ) x 0.125 =
222.1551.565.78 + 222.15 + 51.56 =279.48
14
5/31/255.781536.205.78( 1536.2 - 5.78 ) x 0.125 = 191.3051.565.78 + 191.30 + 51.56 =248.64
15
4/30/255.785.78manual input209.5741.345.78 + 209.57 + 41.34 =256.69
16
3/31/255.785.78manual input271.3762.115.78 + 271.37 + 62.11 =339.26
17
2/28/255.785.78manual input290.8868.415.78 + 290.88 + 68.41 =365.07
18
1/31/255.785.78manual input312.1475.455.78 + 312.14 + 75.45 =393.37 - 204 = 189.37204 = website exp
19
missing( missing - ) x 0.125 =
20
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