Spreadsheet: 851492d1701715285-nested-if-statement-for-slab-calculation-based-on-quota-rates-test_comm-donjuan28-
Sheet: Bobby.Digital (4)

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 | 934837.8578530162 | 621083.65 | 1132033.56 |  | 80-100% | 0.026 | YTD Achieved |  |  | Orders | Orders Target | Achievement
 |  |  |  |  | Q2 | 809754.5573645739 | 703988.2 | 595024.1 |  | above annual quota | 0.055 |  |  | Q1 | 484131.91 | 481000 | Yes
 |  |  |  |  | Q3 | 950027.8400112566 | 872387.94 | 706971.88
 |  |  |  |  | Q4 | 1111089.744771153 | 887054.6 |  |  |  |  |  |  | Example prior  YTD of >>>> | 2950391.230000001
 |  |  |  |  | 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 |  |  |  |  |  |  |  |  |  |  |  |  |  | 7731.89
1W |  |  |  |  |  |  |  |  |  |  |  |  |  | 8197.17
1W |  |  |  |  |  |  |  |  |  |  |  |  |  | 966.64
1W |  |  |  |  |  |  |  |  |  |  |  |  |  | 4988.71
1W |  |  |  |  |  |  |  |  |  |  |  |  |  | 892.49
1C |  |  |  |  |  |  |  |  |  |  |  |  |  | 46596.44
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 21634.9
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 104474.68
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5218.05
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3993.72
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3853.87
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3019.27
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 418.88
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2453.98
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 778.5
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
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 182573.08
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 6830.2
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 381.8
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 9142.28
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 148.72
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 564.8
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 59.8
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1600.79
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -3288.58
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 878433.66
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4579.98
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