Spreadsheet: 765099d1643166919-calculate-multiple-agents-yearly-commissions-book2
Sheet: Total (2)

Rentals |  |  |  |  |  |  |  |  | Revenue
Address | Price | Commission | Office | Agent | Date | Paid | Agent |  | Sales
1 | 1950 |  |  | 975 | 2021-07-15 00:00:00 | Y | GS |  | Rentals
2 | 2000 |  |  | 1000 | 2021-07-15 00:00:00 | Y | GS |  | Commercial
3 | 2500 |  |  | 1250 | 2021-07-15 00:00:00 | Y | GS |  |  | 2021-01-01 00:00:00 | 2022-01-01 00:00:00 | 2023-01-01 00:00:00 | 2024-01-01 00:00:00 | 2025-01-01 00:00:00
4 | 2150 |  |  | 1075 | 2021-07-15 00:00:00 | Y | GS |  | Commissions
5 | 1800 |  |  | 900 | 2021-07-15 00:00:00 | Y | GS |  | Sales
6 | 2200 |  |  | 1760 | 2021-07-15 00:00:00 | Y | PE |  | Rentals
7 | 2100 |  |  | 1050 | 2021-07-15 00:00:00 | Y | GS |  | Commercial
8 | 1800 |  |  | 1440 | 2021-09-10 00:00:00 | Y | PE |  | Total
9 | 2600 | 1400 |  | 840 | 2021-07-15 00:00:00 | Y | GS |  |  | 2021-01-01 00:00:00 | 2022-01-01 00:00:00 | 2023-01-01 00:00:00 | 2024-01-01 00:00:00 | 2025-01-01 00:00:00
10 | 1700 |  |  | 1020 | 2021-07-15 00:00:00 | Y | GS
11 | 1674 |  |  | 1004.4 | 2021-09-29 00:00:00 | Y | GS |  |  |  | Gross | Net
12 | 1600 |  |  | 960 | 2021-10-15 00:00:00 | Y | GS |  | Total Commission Earned
13 | 2000 |  |  | 1200 | 2021-10-24 00:00:00 | Y | GS |  | Accepted Offers
14 | 2300 |  |  | 1380 | 2021-10-25 00:00:00 | Y | GS |  | Total Pending
15 | 2000 |  |  | 1600 | 2021-12-25 00:00:00 | Y | PE |  | Total in Contract
16 | 2000 |  |  | 1600 | 2021-11-15 00:00:00 | Y | PE |  | Total Received
17 | 2400 |  |  | 1440 | 2021-11-22 00:00:00 | Y | GS
18 | 2800 |  |  | 1680 | 2021-12-13 00:00:00 | Y | GS |  | AGENT SCORECARD
19 | 2400 | 2300 |  |  |  |  | CC |  | Agent Name |  | Split A | Total Earned
20 | 2400 | 2300 |  |  | 2022-01-28 00:00:00 | C | CC |  | PE |  | 0.8
21 | 2055 |  |  | 1644 | 2022-01-15 00:00:00 | N | PE |  | GS |  | 0.65
22 | 2300 |  |  | 1840 | 2022-01-15 00:00:00 | N | PE |  | CC |  | 0.6
23 | 1500 |  |  | 925 | 2022-01-10 00:00:00 | Y | GS
24 | 1800 |  |  |  | 2022-01-24 00:00:00 | C | CC
25 | 3000 |  |  |  | 2022-01-28 00:00:00 | C | GS
26 | 2400 |  |  |  |  |  | PE
 | 0
 | 0
 | 0 |  |  |  |  |  |  |  | Total
 | 0
Sales |  |  |  |  |  |  |  |  | Yearly Totals - PE
Address | Price | Commission | Office | Agent | Date | Paid | Agent |  | Rentals
1 | 430000 |  |  | 6880 | 2021-12-28 00:00:00 | Y | PE |  | Sales
2 | 825000 |  |  | 7425 | 2022-01-12 00:00:00 | Y | GS |  | Commercial
3 | 470000 |  |  | 9400 | 2022-01-04 00:00:00 | Y | PE |  |  | 2021-01-01 00:00:00 | 2022-01-01 00:00:00 | 2023-01-01 00:00:00 | 2024-01-01 00:00:00 | 2025-01-01 00:00:00
4 | 970000 |  |  | 23280 | 2022-01-24 00:00:00 | C | PE |  | Yearly Totals - GF
5 | 1125000 |  |  |  |  |  | PE |  | Rentals
6 | 860000 |  |  |  |  |  | PE |  | Sales
7 | 1950000 |  |  |  |  |  | GS |  | Commercial
8 | 0 |  |  |  |  |  | PE |  |  | 2021-01-01 00:00:00 | 2022-01-01 00:00:00 | 2023-01-01 00:00:00 | 2024-01-01 00:00:00 | 2025-01-01 00:00:00
9 | 420000 |  |  |  |  |  | PE |  | Yearly Totals - CC
10 | 810000 |  |  |  |  |  | PE |  | Rentals
11 | 510000 |  |  |  |  |  | GS |  | Sales
 | 0 |  |  |  |  |  |  |  | Commercial
 | 0 |  |  |  |  |  |  |  |  | 2021-01-01 00:00:00 | 2022-01-01 00:00:00 | 2023-01-01 00:00:00 | 2024-01-01 00:00:00 | 2025-01-01 00:00:00
 | 0
 | 0
 | 0
Moore | 0
[NAME] Yiayia | 0
Commercial - Lease
Address | Price | Commission | Office | Agent | Date | Paid | Agent
1 | 735 |  |  |  | 2021-11-15 00:00:00 | Y | PE
2 | 800 |  |  |  | 2021-11-15 00:00:00 | Y | PE
3 | 2400 |  |  |  | 2021-11-15 00:00:00 | Y | PE
4 | 4200 |  |  |  | 2022-01-20 00:00:00 | C | PE
5 | 0 |  |  |  |  |  | PE
6 | 0 |  |  |  |  |  | PE
7 | 0 |  |  |  |  |  | PE
8 | 0 |  |  |  |  |  | PE
 | 0
 | 0
 | 0
 | 0
 | 0
b |  |  |  | xcb.