Spreadsheet: 851317d1701532137-nested-if-statement-for-slab-calculation-based-on-quota-rates-test_comm-donjuan28-
Sheet: Bobby.Digital

Back to Index
Southwest Region |  |  |  |  |  |  |  |  |  | Net Revenue
Commission Earned | Based on Sales Quota |  | Time of Sale Service | Spiffs | [NAME] | Open Territory | Quarterly Order Achievement | Other | Total | YTD WF | YTD CONFOCAL | YTD SALES | % QUOTA ACHIEVED | Paid | Balance |  | Nested If statement for slab calculation based on quota rates (excelforum.com)
 | [NAME] | Confocal
January
February
March
April
May
June
July
August
September
October
November
December
Total
 |  |  |  |  |  | 2023 QUOTA |  |  |  | Commission Rate 2023 |  | [NAME]
 |  |  |  |  |  | Sales | Orders | Orders | Achievement | 0-80% | 0.018 | 1184320 |  |  | Q1 Orders SPIFF
 |  |  |  |  | Q1 | 724657.72 | 621083.65 | 1132033.56 |  | 80-100% | 0.026 | YTD Achieved |  |  | Orders | Orders Target | Achievement
 |  |  |  |  | Q2 | 627696.97 | 703988.2 | 595024.1 |  | above annual quota | 0.055 |  |  | Q1 | 484131.91 | 481000 | Yes
 |  |  |  |  | Q3 | 736432.53 | 872387.94 | 706971.88
 |  |  |  |  | Q4 | 861282.79 | 887054.6
 |  |  |  |  | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  | 80% of G25
Period | Collective number | Sales rep.no. | Sales rep.no. description | Customer | Customer description | Contact Name | [NAME] | Product group | Posting date | Ship-to post/zip code | Created on | Customer segment 1 (Order) | Ship-to State | Net Revenue | YTD | % to quota | Rate | Total | 0.018 | 0.026 | 0.055 | Total
1W |  |  |  |  |  |  |  |  |  |  |  |  |  | 173143.81
1W
1W |  |  |  |  |  |  |  |  |  |  |  |  |  | 460000
1W |  |  |  |  |  |  |  |  |  |  |  |  |  | 10000
1W |  |  |  |  |  |  |  |  |  |  |  |  |  | 762.27
1C |  |  |  |  |  |  |  |  |  |  |  |  |  | 60000
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 100000
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 500000
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 600000
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 80000
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 90000
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 100000
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 50000
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 60000
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 11000
1W |  |  |  |  |  |  |  |  |  |  |  |  |  | 4500
1W |  |  |  |  |  |  |  |  |  |  |  |  |  | 5000
1W |  |  |  |  |  |  |  |  |  |  |  |  |  | 4306.5
1C |  |  |  |  |  |  |  |  |  |  |  |  |  | 80000
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 600000
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5000
JANUARY
Period | Collective number | Sales rep.no. | Sales rep.no. description | Customer | Customer description | Contact Name | [NAME] | Product group | Posting date | Ship-to post/zip code | Created on | Customer segment 1 (Order) | Ship-to State | Net Revenue | YTD | % to quota | Rate | Total
2C
2C
FEBRUARY
Period | Collective number | Sales rep.no. | Sales rep.no. description | Customer | Customer description | Contact Name | [NAME] | Product group | Posting date | Ship-to post/zip code | Created on | Customer segment 1 (Order) | Ship-to State | Net Revenue | YTD | % to quota | Rate | Total
3C
3C
3C
3C
3C
3TOS
3TOS
3TOS
3OTH
[NAME]
Period | Collective number | Sales rep.no. | Sales rep.no. description | Customer | Customer description | Contact Name | [NAME] | Product group | Posting date | Ship-to post/zip code | Created on | Customer segment 1 (Order) | Ship-to State | Net Revenue | YTD | % to quota | Rate | Total
4SP
APRIL
Period | Collective number | Sales rep.no. | Sales rep.no. description | Customer | Customer description | Contact Name | [NAME] | Product group | Posting date | Ship-to post/zip code | Created on | Customer segment 1 (Order) | Ship-to State | Net Revenue | YTD | % to quota | Rate | Total
MAY
Period | Collective number | Sales rep.no. | Sales rep.no. description | Customer | Customer description | Contact Name | [NAME] | Product group | Posting date | Ship-to post/zip code | Created on | Customer segment 1 (Order) | Ship-to State
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Paid out in July on special payment
[NAME]
Period | Collective number | Sales rep.no. | Sales rep.no. description | Customer | Customer description | Contact Name | [NAME] | Product group | Posting date | Ship-to post/zip code | Created on | Customer segment 1 (Order) | Ship-to State
7W
7W
7W
7W
7W
7W
7W
7W
7W
7W
7W
7W
7C
7OT
JULY
Period | Collective number | Sales rep.no. | Sales rep.no. description | Customer | Customer description | Contact Name | [NAME] | Product group | Posting date | Ship-to post/zip code | Created on | Customer segment 1 (Order) | Ship-to State
8W
8W
8W
8W
8W
8W
8W
8W
8W
8W
8W
8W
8W
8W
8W
8W
8SP
AUGUST |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4373.940000000001
Period | Collective number | Sales rep.no. | Sales rep.no. description | Customer | Customer description | Contact Name | [NAME] | Product group | Posting date | Ship-to post/zip code | Created on | Customer segment 1 (Order) | Ship-to State
9W
9W
9W
9W
9W
9W
9W
9W
9W
9C
9C
9W
9W
9OT
9OT
9OT
9OT
9OT
9OT
9OT
9OT
9OT
9C
9C
9SP
9SP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Amt due
SEPTEMBER
Period | Collective number | Sales rep.no. | Sales rep.no. description | Customer | Customer description | Contact Name/Contract # | [NAME] | Product group | Posting date | Ship-to post/zip code | Created on | Customer segment 1 (Order) | Ship-to State
10W
10W
10W
10W
10W
10W
10W
10W
10W
10W
10W
10W
10C
10W
10C
10C
10OT
10OT
10OT
10OT
10OT
10OT
10OT
10SP
10OTH
OCTOBER
Period | Collective number | Sales rep.no. | Sales rep.no. description | Customer | Customer description | Contact Name | [NAME] | Product group | Posting date | Ship-to post/zip code | Created on | Customer segment 1 (Order) | Ship-to State
11W
11W
11W
11W
11W
11W
11W
11W
11W
11W
11W
11W
11OT
11OT
11OT
11OT
11OT
11OT
11OT
11OT
11OT
11OT
11OT
11C
11C
11SP
NOVEMBER
Period | Collective number | Sales rep.no. | Sales rep.no. description | Customer | Customer description | Contact Name | [NAME] | Product group | Posting date | Ship-to post/zip code | Created on | Customer segment 1 (Order) | Ship-to State
12W
12W
12W
12W
12W
12W
12W
12W
12W
12C
12C
12C
12C
12C
12C
12C
12C
12C
12C
DECEMBER