Spreadsheet: 870249d1716798144-sumproduct-formula-not-giving-any-results-excel-help-with-formulas-2-
Sheet: 2024

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | contract
21 |  | DATE | 2024-05-20 00:00:00 | 2024-05-21 00:00:00 | 2024-05-22 00:00:00 | 2024-05-23 00:00:00 | 2024-05-24 00:00:00 | 2024-05-25 00:00:00 | 2024-05-26 00:00:00 |  | X | 21 | 2023-05-20 00:00:00 | 1 | V9 VPL | Mon - Tue |  | Agency | Agency | 3 | Q | -0.3474453888652783 | 4 | 0 | TRUCK BREAK DOWN | 0.5 | TRUCK BREAK DOWN | TRUCK BREAK DOWN | CREW TRAVEL | X | X | 0.5 |  | MACHINES OUT |  |  | MACHINES OUT |  |  | MACHINES OUT |  |  | MACHINES OUT |  |  | MACHINES OUT |  |  |  | 1 | 0 | 5 | 0 | 1
21 | 1 |  |  |  |  |  |  | Home | Home | 0 | WEATHER | 21 | 2023-05-20 00:00:00 | 1 | V15 VPL | Mon - Tue |  | Agency | Agency | 3 | M | 0.5520793590232735 | 2 | 0 | 1 | 0.5 | X | X | X | X | X | 1.5 | CONTRACT | WEEKLY PROFIT COMBINED |  | CONTRACT | WEEKLY PROFIT COMBINED |  | CONTRACT | WEEKLY PROFIT COMBINED |  | CONTRACT | WEEKLY PROFIT COMBINED |  | CONTRACT | WEEKLY PROFIT COMBINED |  |  |  | 2 | 0 | 2 | 0 | 0
21 | 2 |  |  |  |  |  |  | Home | Home | 0 | TRUCK BREAK DOWN | 21 | 2023-05-20 00:00:00 | 1 | V16 VPL | Mon - Tue |  | Agency | Agency | 3 | G | 0.5384615384615384 |  |  | 4 | 0.5 | X | X | X | X | X | 4.5 |  | Contract % | 0 |  | Contract % | 0 |  | Contract % | 0 |  | Contract % | 0 |  | Contract % | 0 | VELOCITY MACHINES | 0 | 2 | 0 | 2 | 0 | 0
21 | 3 |  |  |  |  |  |  | Home | Home | 0 | AGENCY CREW ISSUE | 21 | 2023-05-20 00:00:00 | 1 | V24 VPL | Mon - Thur |  | Agency | N/A | 2 | J | 0.5339903123434107 |  |  | 2 | 2 | 0.5 | 3 | CREW TRAVEL | X | X | 7.5 |  | Days Worked | 0 |  | Days Worked | 0 |  | Days Worked | 0 |  | Days Worked | 0 |  | Days Worked | 0 | DAYS WORK | 0 | 4 | 0 | 5 | 0 | 1
21 | 4 |  |  |  |  |  |  | Home | Home | 0 | CREW TRAVEL | 21 | 2023-05-20 00:00:00 | 1 | V25 VPL | Mon - Thur |  | Agency | Agency | 3 | G | -5.05454545454545 | 4 | 0 | TRUCK BREAK DOWN | TRUCK BREAK DOWN | TRUCK BREAK DOWN | TRUCK BREAK DOWN | CREW TRAVEL | X | X | 0 |  | Days Lost | 0 |  | Days Lost | 0 |  | Days Lost | 0 |  | Days Lost | 0 |  | Days Lost | 0 | DAYS LOST | 0 | 0 | 0 | 5 | 0 | 1
21 | 5 |  |  |  |  |  |  | Home | Home | 0 | DOWNTIME - CHARGEABLE | 21 | 2023-05-20 00:00:00 | 1 | V26 VPL | Mon - Thur |  | Agency | N/A | 2 | K | 0.5388158231410879 |  |  | 2.5 | 2 | 2.5 | 1.5 | CREW TRAVEL | X | X | 8.5 |  | Daily Average m3 | 0 |  | Daily Average m3 | 0 |  | Daily Average m3 | 0 |  | Daily Average m3 | 0 |  | Daily Average m3 | 0 | RRS OPS TARGET 95% |  | 4 | 0 | 5 | 0 | 1
21 | 6 |  |  |  |  |  |  | Home | Home | 0 | UNIT BREAKDOWN | 21 | 2023-05-20 00:00:00 | 1 | V27 VPL | Mon - Fri |  | Agency | Agency | 3 | I | 0.2984562607204116 |  |  | 4 | 2.5 | 1 | 4.5 | X | X | X | 12 |  | Reasons for Days Lost | N/A |  | Reasons for Days Lost | N/A |  | Reasons for Days Lost | N/A |  | Reasons for Days Lost | N/A |  | Reasons for Days Lost | N/A | WEATHER | 0 | 4 | 0 | 4 | 0 | 0
21 | 7 |  |  |  |  |  |  | Home | Home | 0 | MATERIAL ISSUE | 21 | 2023-05-20 00:00:00 | 1 | V28 VPL | Mon - Wed |  | Agency | N/A | 2 | K | 0.528481654165822 |  |  | 2 | 1.5 | WEATHER | X | X | X | X | 3.5 |  | Reasons for Days Lost | N/A |  | Reasons for Days Lost | N/A |  | Reasons for Days Lost | N/A |  | Reasons for Days Lost | N/A |  | Reasons for Days Lost | N/A | TRUCK BREAK DOWN | 0 | 2 | 0 | 3 | 0 | 1
21 | 8 |  |  |  |  |  |  | Home | Home | 0 | VELOCITY CREW ISSUE | 21 | 2023-05-20 00:00:00 | 1 | V29 VPL | Mon - Thur |  | Agency | N/A | 2 | R | 0.399272874166835 |  |  | VELOCITY CREW ISSUE | AGENCY CREW ISSUE | 1 | 3.5 | CREW TRAVEL | X | X | 4.5 |  | Contract Profit | 0 |  | Contract Profit | 0 |  | Contract Profit | 0 |  | Contract Profit | 0 |  | Contract Profit | 0 | AGENCY CREW ISSUE | 0 | 2 | 0 | 5 | 0 | 1
21 | 9 |  |  |  |  |  |  |  |  |  | SPARE ON CONTRACT | 21 | 2023-05-20 00:00:00 | 1 | V30 VPL | Mon - Thur |  | Agency | N/A | 2 | L | 0.5055384901796519 |  |  | 2.5 | 2.5 | WEATHER | 1.5 | CREW TRAVEL | X | X | 6.5 |  | Profit per Machine | 0 |  | Profit per Machine | 0 |  | Profit per Machine | 0 |  | Profit per Machine | 0 |  | Profit per Machine | 0 | UNIT BREAKDOWN | 0 | 3 | 0 | 5 | 0 | 2
21 | 10 |  |  |  |  |  |  | Home | Home | 0 | WORKSHOP OFF ROAD | 21 | 2023-05-20 00:00:00 | 1 | V31 VPL | Mon - Tue |  | Agency | Agency | 3 | N | 0.4183100137174212 | 4 | 0 | 3 | 1 | X | X | X | X | X | 4 |  | Daily Average Profit | 0 |  | Daily Average Profit | 0 |  | Daily Average Profit | 0 |  | Daily Average Profit | 0 |  | Daily Average Profit | 0 | VELOCITY CREW ISSUE | 0 | 2 | 0 | 2 | 0 | 0
21 | 11 |  |  |  |  |  |  | Home | Home | 0 | VOLVO OFF ROAD | 21 | 2023-05-20 00:00:00 | 1 | V33 VPL | Mon |  | Agency | N/A | 2 | B | 0 | 4 | 0 | VELOCITY CREW ISSUE | x | X | X | X | X | X | 0 |  | Contract % | 0 |  | Contract % | 0 |  | Contract % | 0 |  | Contract % | 0 |  | Contract % | 0 | MATERIAL ISSUE | 0 | 0 | 0 | 1 | 0 | 0
21 | 12 |  |  |  |  |  |  | Home | Home | 0 | AVAILABLE FOR CONTRACT | 21 | 2023-05-20 00:00:00 | 1 | V40 VPL | Mon - Sun |  | Agency | [NAME] | 3 | H | 0.4610992148465382 |  |  | 3 | 4.5 | 0.5 | 8 | X | X | X | 16 |  | Days Worked | 0 |  | Days Worked | 0 |  | Days Worked | 0 |  | Days Worked | 0 |  | Days Worked | 0 | WORKSHOP | 0 | 4 | 0 | 4 | 0 | 0
21 | 13 |  |  |  |  |  |  | Home | Home | 0 | CONTRACT | 21 | 2023-05-20 00:00:00 | 1 | [NAME] | Mon - Thur |  | Agency | N/A | 2 | A | 0.4323497014319671 |  |  | 3.5 | 2 | WEATHER | 3 | CREW TRAVEL | X | X | 8.5 |  | Days Lost | 0 |  | Days Lost | 0 |  | Days Lost | 0 |  | Days Lost | 0 |  | Days Lost | 0 | AVAILABLE FOR CONTRACT | 0 | 3 | 0 | 5 | 0 | 2
21 | 14 |  |  |  |  |  |  | Working Staying | Working Staying | 3 |  | 21 | 2023-05-20 00:00:00 | 1 | V50 VPL | Mon - Thur |  | Agency | Agency | 3 | G | 0.4460500963391137 | 4 | 0 | 0.5 | 1 | 4 | 4.5 | CREW TRAVEL | X | X | 10 |  | Daily Average m3 | 0 |  | Daily Average m3 | 0 |  | Daily Average m3 | 0 |  | Daily Average m3 | 0 |  | Daily Average m3 | 0 | CONTRACT CLIENT ISSUE | 0 | 4 | 0 | 5 | 0 | 1
21 | 15 |  |  |  |  |  |  | Home | Home | 0 |  | 21 | 2023-05-20 00:00:00 | 1 | V55 VPL | Mon - Thur |  | Agency | Agency | 3 | N | 0.5258524413852441 |  |  | 2 | 2 | 2 | 2 | CREW TRAVEL | X | X | 8 |  | Reasons for Days Lost | N/A |  | Reasons for Days Lost | N/A |  | Reasons for Days Lost | N/A |  | Reasons for Days Lost | N/A |  | Reasons for Days Lost | N/A |  |  | 4 | 0 | 5 | 0 | 1
21 | 16 |  |  |  |  |  |  | Home | Home | 0 |  | 21 | 2023-05-20 00:00:00 | 1 | V60 VPL | Mon - Thur |  | Client | Client | 1 | O | 0.6893036611629576 |  |  | 2 | 1 | 0.5 | 1.5 | CREW TRAVEL | X | X | 5 |  | Reasons for Days Lost | N/A |  | Reasons for Days Lost | N/A |  | Reasons for Days Lost | N/A |  | Reasons for Days Lost | N/A |  | Reasons for Days Lost | N/A | TOTAL WEEKLY PROFIT |  | 4 | 0 | 5 | 0 | 1
21 | 17 |  |  |  |  |  |  | Working Staying | Working Staying | 3 |  | 21 | 2023-05-20 00:00:00 | 1 | V66 VPL | Mon - Thur |  | Agency | N/A | 2 | E | 0.4986884850326427 |  |  | 3 | 3.5 | 3 | 2.5 | CREW TRAVEL | X | X | 12 |  | Contract Profit | 0 |  | Contract Profit | 0 |  | Contract Profit | 0 |  | Contract Profit | 0 |  | Contract Profit | 0 | WEEKLY AVERAGE PROFIT PER MACHINE |  | 4 | 0 | 5 | 0 | 1
21 | 18 |  |  |  |  |  |  | Home | Home | 0 |  | 21 | 2023-05-20 00:00:00 | 1 | V77 VPL | Mon - Tue |  | Agency | N/A | 2 | A | 0.4619043263514132 |  |  | 5 | 2.5 | X | X | X | X | X | 7.5 |  | Profit per Machine | 0 |  | Profit per Machine | 0 |  | Profit per Machine | 0 |  | Profit per Machine | 0 |  | Profit per Machine | 0 | WEEKLY DAILY AVERAGE PER MACHINE |  | 2 | 0 | 2 | 0 | 0
21 | 19 |  |  |  |  |  |  | Home | Home | 0 |  | 21 | 2023-05-20 00:00:00 | 1 | [NAME] | TBC  - OFF ROAD |  |  |  |  |  | 0 |  |  | X | X | X | X | X | X | X | 0 |  | Daily Average Profit | 0 |  | Daily Average Profit | 0 |  | Daily Average Profit | 0 |  | Daily Average Profit | 0 |  | Daily Average Profit | 0 |  |  | 0 | 0 | 0 | 0 | 0
21 | 20 |  |  |  |  |  |  | Home | Home | 0 |  | 21 | 2023-05-20 00:00:00 | 1 | V88 VPL | Mon - Thur |  | Agency | Agency | 3 | R | 0.4800673864767593 |  |  | 8 | 5 | 5 | 5 | CREW TRAVEL | X | X | 23 |  | Contract % | 0 |  | Contract % | 0 |  | Contract % | 0 |  | Contract % | 0 |  | Contract % | 0 |  |  | 4 | 0 | 5 | 0 | 1
21 | 21 |  |  |  |  |  |  | Home | Home | 0 |  | 21 | 2023-05-20 00:00:00 | 1 | SJ12 XVB | Mon - Sun |  | VR - G Ellis | Agency | 3 | P | 0.5522838807097018 |  |  | 0.5 | 0.5 | WEATHER | 1.5 | X | X | X | 2.5 |  | Days Worked | 0 |  | Days Worked | 0 |  | Days Worked | 0 |  | Days Worked | 0 |  | Days Worked | 0 |  |  | 3 | 0 | 4 | 0 | 1
21 | 22 |  |  |  |  |  |  | Home | Home | 0 |  | 21 | 2023-05-20 00:00:00 | 1 | VU57 YRV | Mon - Thur |  | Agency | N/A | 2 | F | -3.188679245283019 | 4 | 0 | TRUCK BREAK DOWN | TRUCK BREAK DOWN | TRUCK BREAK DOWN | TRUCK BREAK DOWN | CREW TRAVEL | X | X | 0 |  | Days Lost | 0 |  | Days Lost | 0 |  | Days Lost | 0 |  | Days Lost | 0 |  | Days Lost | 0 |  |  | 0 | 0 | 5 | 0 | 1
21 | 23 |  |  |  |  |  |  | Home | Home | 0 |  | 21 | 2023-05-20 00:00:00 | 1 | KY60 WUP | Mon - Thur |  | Agency | N/A | 2 | C | -0.0240430185085006 |  |  | TRUCK BREAK DOWN | TRUCK BREAK DOWN | TRUCK BREAK DOWN | 1 | CREW TRAVEL | X | X | 1 |  | Daily Average m3 | 0 |  | Daily Average m3 | 0 |  | Daily Average m3 | 0 |  | Daily Average m3 | 0 |  | Daily Average m3 | 0 |  |  | 1 | 0 | 5 | 0 | 1
21 | 24 |  |  |  |  |  |  | Home | Home | 0 |  | 21 | 2023-05-20 00:00:00 | 1 | GN59 GX | Mon - Wed |  | Agency | N/A | 2 | D | 0.5621419179755577 |  |  | 1 | 1.5 | 0.5 | CREW TRAVEL | X | X | X | 3 |  | Reasons for Days Lost | N/A |  | Reasons for Days Lost | N/A |  | Reasons for Days Lost | N/A |  | Reasons for Days Lost | N/A |  | Reasons for Days Lost | N/A |  |  | 3 | 0 | 4 | 0 | 1
21 | 25 |  |  |  |  |  |  | Home | Home | 0 |  | 21 | 2023-05-20 00:00:00 | 1 | Machine |  |  |  |  |  | na | 0 |  |  | X | X | X | X | X | X | X | 0 |  | Reasons for Days Lost | N/A |  | Reasons for Days Lost | N/A |  | Reasons for Days Lost | N/A |  | Reasons for Days Lost | N/A |  | Reasons for Days Lost | N/A |  |  | 0 | 0 | 0 | 0 | 0
21 | 26 |  |  |  |  |  |  | Working Staying | Working Staying | 3 |  | 21 | 2023-05-20 00:00:00 | 1 | V15 VPL | Wed - Thur |  | Agency | Agency | 3 | M | 0.5784877039760975 |  |  | X | X | 0.5 | 0.5 | CREW TRAVEL | X | X | 1 |  | Contract Profit | 0 |  | Contract Profit | 0 |  | Contract Profit | 0 |  | Contract Profit | 0 |  | Contract Profit | 0 |  |  | 2 | 0 | 3 | 0 | 1
21 | 27 |  |  |  |  |  |  | Home | Home | 0 |  | 21 | 2023-05-20 00:00:00 | 1 | Machine |  |  |  |  |  |  | 0 |  |  | X | X | X | X | X | X | X | 0 |  | Profit per Machine | 0 |  | Profit per Machine | 0 |  | Profit per Machine | 0 |  | Profit per Machine | 0 |  | Profit per Machine | 0 |  |  | 0 | 0 | 0 | 0 | 0
21 | 28 |  |  |  |  |  |  | Working Staying | Working Staying | 1 |  | 21 | 2023-05-20 00:00:00 | 1 | Machine |  |  |  |  |  |  | 0 |  |  | X | X | X | X | X | X | X | 0 |  | Daily Average Profit | 0 |  | Daily Average Profit | 0 |  | Daily Average Profit | 0 |  | Daily Average Profit | 0 |  | Daily Average Profit | 0 |  |  | 0 | 0 | 0 | 0 | 0
21 | 29 |  |  |  |  |  |  | Home | Home | 0 |  | 21 | 2023-05-20 00:00:00 | 1 | V33 VPL | Tue |  | Agency | N/A | 2 | B | 0.4549089610853267 |  |  | X | 4 | X | X | X | X | X | 4 |  | Contract % | 0 |  | Contract % | 0 |  | Contract % | 0 |  | Contract % | 0 |  | Contract % | 0 |  |  | 1 | 0 | 1 | 0 | 0
21 | 30 |  |  |  |  |  |  | Home | Home | 0 |  | 21 | 2023-05-20 00:00:00 | 1 | V33 VPL | Wed - Thur |  | Agency | N/A | 3 | B | 0.3506486486486487 |  |  | X | X | WEATHER | 3 | CREW TRAVEL | X | X | 3 |  | Days Worked | 0 |  | Days Worked | 0 |  | Days Worked | 0 |  | Days Worked | 0 |  | Days Worked | 0 |  |  | 1 | 0 | 3 | 0 | 2
21 | 31 |  |  |  |  |  |  | Home | Home | 0 |  | 21 | 2023-05-20 00:00:00 | 1 | V77 VPL | Wed - Thu |  | Agency | N/A | 2 | A | 0.3443618824142876 |  |  | X | X | WEATHER | 3.5 | CREW TRAVEL | X | X | 3.5 |  | Days Lost | 0 |  | Days Lost | 0 |  | Days Lost | 0 |  | Days Lost | 0 |  | Days Lost | 0 |  |  | 1 | 0 | 3 | 0 | 2
21 |  |  |  |  |  |  |  |  |  |  |  | 21 | 2023-05-20 00:00:00 | 1 | V16 VPL | Wed - Fri |  | Agency | Agency | 3 | G | 0.440684558537534 |  |  | X | X | 4.5 | 4 | CREW TRAVEL | X | X | 8.5 |  | Daily Average m3 | 0 |  | Daily Average m3 | 0 |  | Daily Average m3 | 0 |  | Daily Average m3 | 0 |  | Daily Average m3 | 0 |  |  | 2 | 0 | 3 | 0 | 1
21 |  |  |  |  |  |  |  |  |  |  |  | 21 | 2023-05-20 00:00:00 | 1 | V31 VPL | Wed - Fri |  | Agency | Agency | 3 | N | 0.5870438596491229 |  |  | X | X | 1.5 | 1 | X | X | X | 2.5 |  | Reasons for Days Lost | N/A |  | Reasons for Days Lost | N/A |  | Reasons for Days Lost | N/A |  | Reasons for Days Lost | N/A |  | Reasons for Days Lost | N/A |  |  | 2 | 0 | 2 | 0 | 0
21 |  |  |  |  |  |  |  |  |  |  |  | 21 | 2023-05-20 00:00:00 | 1 | Machine |  |  |  |  |  |  | 0 |  |  | X | X | X | X | X | X | X | 0 |  | Reasons for Days Lost | N/A |  | Reasons for Days Lost | N/A |  | Reasons for Days Lost | N/A |  | Reasons for Days Lost | N/A |  | Reasons for Days Lost | N/A |  |  | 0 | 0 | 0 | 0 | 0
21 |  |  |  |  |  |  |  |  |  |  |  | 21 | 2023-05-20 00:00:00 | 1 | Machine |  |  |  |  |  |  | 0 |  |  | X | X | X | X | X | X | X | 0 |  | Contract Profit | 0 |  | Contract Profit | 0 |  | Contract Profit | 0 |  | Contract Profit | 0 |  | Contract Profit | 0 |  |  | 0 | 0 | 0 | 0 | 0
21 |  |  |  |  |  |  |  |  |  |  |  | 21 | 2023-05-20 00:00:00 | 1 | Machine |  |  |  |  |  |  | 0 |  |  | X | X | X | X | X | X | X | 0 |  | Profit per Machine | 0 |  | Profit per Machine | 0 |  | Profit per Machine | 0 |  | Profit per Machine | 0 |  | Profit per Machine | 0 |  |  | 0 | 0 | 0 | 0 | 0
21 |  |  |  |  |  |  |  |  |  |  |  | 21 | 2023-05-20 00:00:00 | 1 | Preservation Machine |  |  |  |  |  |  | 0 |  |  | X | X | X | X | X | X | X | 0 |  | Daily Average Profit | 0 |  | Daily Average Profit | 0 |  | Daily Average Profit | 0 |  | Daily Average Profit | 0 |  | Daily Average Profit | 0 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 21 | 2023-05-20 00:00:00 | 1 | Preservation Machine |  |  |  |  |  |  | 0 |  |  | X | X | X | X | X | X | X | 0 |  | Daily Average Profit | 0 |  | Daily Average Profit | 0 |  | Daily Average Profit | 0 |  | Daily Average Profit | 0 |  | Daily Average Profit | 0 |  |  | 0 | 0 | 0 | 0 | 0