Spreadsheet: 79713d1279900615-keeping-count-total-after-cells-have-been-deleted-service-dispatch-w-tabs
Sheet: LABOR

 |  | ASSIGNED | ADJUSTED | TOTAL INCOMPLETE
 | LAST UPDATED: |  |  |  |  | TOTAL HOURS WORK ASSIGNED TO TECH
 | 2010-07-23 10:56:42 |  |  |  |  |  | TOTAL HOURS OF WAITERS ASSIGNED TO TECH
BF | - FISHER, BRENT | 5.5 |  | 5.5 |  | 5.5 | 0 | 0
BS | - SCHINDEL, BOB | 6.5 |  | 6.5 |  | 5.5 | 0 | 1 |  |  |  |  |  |  |  |  | NOTE TO PROGRAMMERS: TEXT HIDDEN (FONT COLOR SET TO WHITE OR GRAY) AT F4:G14, [NAME]:K20, AND [NAME]:Q36. THE PURPOSE OF THESE FIELDS ARE TO PROVIDE CALCULATIONS TO BE DISPLAYED IN B4:B31 AND H18:I30.
DA | - BRATKOWSKI, DAN | 1 | 1 | 0 |  | 1 | 0 | 0
DB | - BILANSKY, DAN | 1.5 |  | 1.5 |  | 1.5 | 0 | 0
DH | - HAGEMANN, DEAN | 7.5 |  | 7.5 |  | 6.5 | 0 | 1
JZ | - MATYSZCZYK, JASON | 1 | 1 | 0 |  | 1 | 0 | 0
RA | - ACHTERHOF, RYAN | 13.5 |  | 13.5 |  | 13.5 | 0 | 0
RG | - GOTTFRIED, RICH | 5.9 |  | 5.9 |  | 5.9 | 0 | 0
TF | - FRITZ, TOM | 5.5 |  | 5.5 |  | 5.5 | 0 | 0
TP | - POLIZZI, [NAME] | 14.9 |  | 14.9 |  | 14.9 | 0 | 0
HB | - HAROUT | 0.5 | 0.5 | 0 |  | 0.5 | 0 | 0
 | TOTAL: | 63.3 | 2.5 | 60.8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | calculations
MH | - HOLLAND, [NAME] | 4.45 |  | 4.45 |  | FUTURE | WORK | HOURS | # of JOBS | [NAME] | [NAME] |  | 0 | 4.45 | 0 | total hours | [NAME] | WASHED | WARRANTIES
RS | - SLOWINSKI, RANDAL | 8.5 |  | 8.5 |  | MON: | 2010-07-19 00:00:00 | 0 | 0 | 12 | 4 | 4 | 0 | 8.5 | 0 | 0 | 0 | 0 | 0
AC | - CLAFLIN, ANDY | 2.1 |  | 2.1 |  | TUE: | 2010-07-20 00:00:00 | 9.5 | 4 | 14.5 | 8 | 8 | 0 | 2.1 | 0 | 9.5 | 0 | 0 | 0
 |  | 0 |  | 0 |  | WED: | 2010-07-21 00:00:00 | 6.4 | 5 | 17.6 | 8 | 8 | 0 | 0 | 0 | 6.4 | 0 | 0 | 0
 | TOTAL: | 15.05 | 0 | 15.05 |  | THU: | 2010-07-22 00:00:00 | 4.45 | 7 | 16.55 | 7 | 8 |  |  |  | 8.25 | 3.8 | 0 | 0
 |  |  |  |  |  | FRI: | 2010-07-23 00:00:00 | 37.8 | 17 | -16.8 | 7 | 8 |  |  |  | 42.9 | 5.1 | 0 | 0
 | TOTALS: | 78.35 | 2.5 | 75.85 |  | SAT: | 2010-07-24 00:00:00 | 1 | 1 | 11 | 4 | 4 |  |  |  | 1 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
 | UNASSIGNED WORK: | 1 hrs | 1 jobs | 0 waiters |  | MON: | 2010-07-26 00:00:00 | 2.76 | 2 | 9.24 | 4 | 4 |  |  |  | 1.76 | 0 | 0 | 1
 |  |  | 1 | 0 |  | TUE: | 2010-07-27 00:00:00 | 21.3 | 4 | -0.3000000000000007 | 7 | 8 |  |  |  | 21.3 | 0 | 0 | 0
 | AVAILABLE HOURS: | -5.799999999999997 | 0 | 0 |  | WED: | 2010-07-28 00:00:00 | 0 | 0 | 21 | 7 | 8 |  |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 |  | THU: | 2010-07-29 00:00:00 | 0 | 0 | 21 | 7 | 8 |  |  |  | 0 | 0 | 0 | 0
 | [NAME] AVAILABLE: | 7 |  |  |  | FRI: | 2010-07-30 00:00:00 | 0 | 0 | 21 | 7 | 8 |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | SAT: | 2010-07-31 00:00:00 | 0 | 0 | 12 | 4 | 4 |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | THIS ADDS THE TOTAL HOURS OF JOBS UNASSIGNED FOR THE CURRENT DAY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | THIS ADDS THE TOTAL HOURS OF WAITERS LEFT UNASSIGNED
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | THIS ADDS THE TOTAL HOURS OF INTERNALS LEFT UNASSIGNED
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | THIS ADDS 1 HOUR FOR EVERY WARRANTY JOB LEFT UNASSIGNED
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0