Spreadsheet: 62184d1263175280-max-and-perhaps-a-vlookup-ef-sample_sales
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | TARGET |  |  |  |  |  |  | ACTUAL |  |  |  |  |  |  | COMPARISON
Operator | Team |  |  |  |  | [NAME] | Commencement Date | FTE Incentive Budget | Adjustments | Standard Monthly Target | Notes | Product 1 | Product 2 | Product 3 | Product 4 | Product 5 | Product 6 | Notes | Product 1 | Product 2 | Product 3 | Product 4 | Product 5 | Product 6 | Notes | Product 1 | Product 2 | Product 3 | Product 4 | Product 5 | Product 6
Operator 1 | Team Leader |  |  |  |  | YES | 2010-01-11 00:00:00 | 0.7 | 1 | 31500 |  | 1865.76923076923 | 1238.192307692308 | 10962.85534615385 | 52.5 | 173.25 | 266.5384615384615 |  | 3334.42 | 1476.04 | 9691.94 |  | 308.81 | 1671 |  | 1468.65076923077 | 237.8476923076923 | -1270.915346153846 |  | 135.56 | 1404.461538461539
Operator 2 | Perth Sales & Service |  |  |  |  | NO | 2010-01-12 00:00:00 | 0.5 | 1 | 22500 |  | 1332.692307692308 | 884.4230769230769 | 7830.610961538462 | 37.5 | 123.75 | 190.3846153846154
Operator 3 | Perth Sales & Service |  |  |  |  | YES | 2010-01-13 00:00:00 | 0.6 | 1 | 27000 |  | 1599.230769230769 | 1061.307692307692 | 9396.733153846155 | 45 | 148.5 | 228.4615384615385 |  | 3823.61 | 2487.5 | 18911.94 | 26.97 | 852.37 | 1407 |  | 2224.379230769231 | 1426.192307692308 | 9515.206846153844 | -18.03 | 703.87 | 1178.538461538461
Operator 4 | Perth Sales & Service |  |  |  |  | YES | 2010-01-14 00:00:00 | 1 | 1 | 45000 |  | 2665.384615384615 | 1768.846153846154 | 15661.22192307692 | 75 | 247.5 | 380.7692307692308 |  | 6605.88 | 3701.41 | 23344.34 | 90.59 | 653.25 | 1396 |  | 3940.495384615385 | 1932.563846153846 | 7683.118076923076 | 15.59 | 405.75 | 1015.230769230769
Operator 5 | Perth Sales & Service |  |  |  |  | YES | 2010-01-15 00:00:00 | 1 | 1 | 45000 |  | 2665.384615384615 | 1768.846153846154 | 15661.22192307692 | 75 | 247.5 | 380.7692307692308 |  | 3653.75 | 2448.6 | 23596.68 | 303.68 | 471.35 |  |  | 988.3653846153848 | 679.7538461538461 | 7935.458076923076 | 228.68 | 223.85
Operator 6 | Perth Sales & Service |  |  |  |  | NO | 2010-01-16 00:00:00 | 0.6 | 1 | 27000 |  | 1599.230769230769 | 1061.307692307692 | 9396.733153846155 | 45 | 148.5 | 228.4615384615385
Operator 7 | Perth Sales & Service |  |  |  |  | YES | 2010-01-17 00:00:00 | 1 | 1 | 45000 |  | 2665.384615384615 | 1768.846153846154 | 15661.22192307692 | 75 | 247.5 | 380.7692307692308 |  | 5023.85 | 1932.9 | 14030.79 |  | 362.7 | 2279 |  | 2358.465384615385 | 164.0538461538463 | -1630.431923076923 |  | 115.2 | 1898.230769230769
Operator 8 | Perth Sales & Service |  |  |  |  | YES | 2010-01-18 00:00:00 | 1 | 1 | 45000 |  | 2665.384615384615 | 1768.846153846154 | 15661.22192307692 | 75 | 247.5 | 380.7692307692308 |  | 6560.82 | 4136.46 | 26328.33 |  | 483.59 | 974 |  | 3895.435384615384 | 2367.613846153846 | 10667.10807692308 |  | 236.09 | 593.2307692307693
Operator 9 | Perth Sales & Service |  |  |  |  | YES | 2010-01-19 00:00:00 | 1 | 1 | 45000 |  | 2665.384615384615 | 1768.846153846154 | 15661.22192307692 | 75 | 247.5 | 380.7692307692308 |  | 3090.98 | 1738.76 | 13502.18 |  | 272.33 |  |  | 425.5953846153848 | -30.08615384615382 | -2159.041923076924 |  | 24.83