Spreadsheet: 857144d1706198658-nested-if-statement-for-adding-quarterly-data-qtr-data-test
Sheet: 1

Back to Index
 |  |  |  |  |  |  |  |  |  | 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
 | [NAME] | Confocal
January
February
March
April
May
June
July
August
September
October
November
December
Total
 |  |  |  |  |  | 2024 QUOTA |  |  |  | Commission Rate 2023 |  | [NAME]
 |  |  |  |  |  | Sales | Orders | Orders | Achievement | 0-80% | 0.018 | 1320000
 |  |  |  |  | Q1 |  | 50000 | 2000 |  | 80-100% | 0.026 | YTD Achieved
 |  |  |  |  | Q2 |  | 1000000 | 1000000 |  | above annual quota | 0.055
 |  |  |  |  | Q3 |  | 50000 | 0
 |  |  |  |  | Q4 |  | 10000000 | 0
 |  |  |  |  | TOTAL
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
1W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.02
1W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.02
1W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.02
1W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.02
1W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.02
1W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.02
1W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.02
1W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.02
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
2W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.02
2W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.02
2W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.02
2W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.02
2W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.02
2W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.02
2C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.02
2C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.02
2C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.02
2C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.02
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
3W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
3W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
3W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
3W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
3W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
3W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
3W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
3W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
3W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
3W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
3W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
3OTH |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
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
4W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
4W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
4W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
4W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
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
5W | 0554260-F | 15701759 | Skuba, [NAME] | 1363048 | CHILDRENS HOSP OF PHILADELPHIA | [NAME] | 4243307 | MQ | 2023-05-26 00:00:00 | 19104 | 2023-02-28 00:00:00 | 1010 | PA |  |  |  | 0.018
5W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
5W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
5W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
5W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
5W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
5W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
5C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
5W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
5W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
5W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
5W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
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 | Net Revenue | YTD | % to quota | Rate | Total
6W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
6W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
6W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
6W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
6W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
6W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
6W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
6W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
6W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
6W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
6W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
6W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
6C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
6C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
6TOS | 4243307 |  |  | 1363048 | CHILDRENS HOSP OF PHILADELPHIA |  |  |  |  |  |  |  |  |  |  |  | 0.018
6TOS | 4243307 |  |  | 1363048 | CHILDRENS HOSP OF PHILADELPHIA |  |  |  |  |  |  |  |  |  |  |  | 0.018
[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
7W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
7W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
7W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
7W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
7W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
7W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
7W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
7C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
7C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
7W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
7W
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 | Net Revenue | YTD | % to quota | Rate | Total
8W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
8W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
8W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
8W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
8W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
8W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
8C
8C
8C
AUGUST
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
9W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
9W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
9W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
9W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
9W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
9W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
9W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
9W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
9W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
9W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
9W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
9W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
9C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
9C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
9C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
9C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
SEPTEMBER
Period | Collective number | Sales rep.no. | Sales rep.no. description | Customer | Customer description | Contact Name or Contract # | [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
10W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
10W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
10W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
10W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
10W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
10W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
10W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
10W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
10W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
10W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
10W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
10W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
10W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
10C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
10C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
10C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
10C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
10C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
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 | Net Revenue | YTD | % to quota | Rate | Total
11W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
11W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
11W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
11W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
11W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
11W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
11W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
11W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
11W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
11W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
11W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
11W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
11W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
11W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
11SP
11C
11C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
11C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
11C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
11C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
11OT
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 | Net Revenue | YTD | % to quota | Rate | Total
12W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
12W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
12W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
12W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
12W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
12W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
12W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
12W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
12W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
12W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
12C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
12C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
12C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
12C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
12C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
12C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
12C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
12C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
12C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
12C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
12C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
12C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018
DECEMBER