Spreadsheet: 453645d1459392837-sumproduct-help-plt-example
Sheet: PLT

Personal Leave Tracker
1900-01-03 00:00:00
1905-07-08 00:00:00
1
NAME |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Leave Days | Next to RDO | Next To Week Day | Next To Week End | Next to Pay Day
Employee 1
Employee 2
Employee 3
Employee 4
Employee 5 | IDLE | TCSNR | IDLE | TCSNR | TCSNR | TCSNR | TCSNR | TCSNR | IDLE | IDLE | TCSNR | TCSNR | IDLE | TCSNR | TCSNR | TCSNR | TCSNR | TCSNR | IDLE | TCSNR | TCSNR | TCSNR | IDLE | IDLE | TCSNR | TCSNR | TCSNR | TCSNR | TCSNR | IDLE | IDLE
Employee 6
Employee 7
Employee 8
Employee 9 | TCSNR | TCSNR | TCSNR | TCSNR | TCSNR | TCSNR | TCSNR | IDLE | IDLE | TCSNR | TCSNR | TCSNR | TCSNR | personal leave | IDLE | IDLE | TCSNR | TCSNR | IDLE | personal leave | TCSNR | TCSNR | TCSNR | TCSNR | IDLE | TCSNR | TCSNR | PUBHOL | IDLE | IDLE | PUBHOL
Employee 10
Employee 11
Employee 12 | IDLE | IDLE | IDLE | IDLE | TCSNR | TCSNR | UNAVAILABLE | IDLE | IDLE | TCSNR | TCSNR | TCSNR | TCSNR | TCSNR | IDLE | IDLE | TCSNR | TCSNR | TCSNR | TCSNR | TCSNR | TCMULT | IDLE | PERSONAL LEAVE | PERSONAL LEAVE | TCSNR | TCSNR | PUBHOL | IDLE | IDLE | TCSNR
Employee 13
Employee 14 | ANNUAL LEAVE | ANNUAL LEAVE | ANNUAL LEAVE | ANNUAL LEAVE | TCSNR | TCSNR | TCSNR | IDLE | IDLE | TCSNR | TCSNR | TCSNR | TCSNR | TCSNR | IDLE | IDLE | TCSNR | TCSNR | TRAIN | TCSNR | TCSNR | IDLE | IDLE | TCSNR | TCSNR | TCSNR | TCSNR | TCSNR | IDLE | IDLE | PUBHOL
Employee 15
Employee 16 | IDLE | IDLE | IDLE | IDLE | TCSNR | TCSNR | TCSNR | TCSNR | TCSNR | IDLE | IDLE | TCSNR | TCSNR | IDLE | TCSNR | TCSNR | TCSNR | TCSNR | TCSNR | IDLE | TCSNR | TCSNR | TCSNR | IDLE | IDLE | TCSNR | TCSNR | TCSNR | TCSNR | TCSNR | IDLE
Employee 17 | TCSNR | TCSNR | TCSNR | TCSNR | TCSNR | IDLE | IDLE | TCSNR | TCSNR | TCSNR | TCSNR | TCSNR | IDLE | BUDDYING ON FLOOR | TCSNR | TCSNR | IDLE | ADMIN | TCSNR | TCSNR | TCSNR | TCSNR | TCSNR | IDLE | IDLE | TCSNR | TCSNR | TCSNR | TCSNR | TCSNR | IDLE
Employee 18 | IDLE | IDLE | IDLE | IDLE | TCSNR | TCSNR | BUDDYING ON FLOOR | TCSNR | TCSNR | IDLE | IDLE | TCSNR | TCSNR | TCSNR | TCSNR | TCSNR | IDLE | IDLE | TCSNR | TCSNR | TCSNR | TCSNR | TCSNR | IDLE | IDLE | TCSNR | TCSNR | TCSNR | TCSNR | TCSNR | IDLE
Employee 19 | IDLE | IDLE | IDLE | IDLE | TCSNR | UNAVAILABLE | TCSNR | TRAIN | UNAVAILABLE | IDLE | IDLE | TCSNR | TCSNR | TCSNR | TCSNR | TCSNR | IDLE | ADMIN | TCSNR | TCSNR | TCSNR | TCSNR | TCSNR | IDLE | IDLE | TRAIN | TCSNR | IDLE | TCSNR | TCSNR | TCSNR
Employee 20 | IDLE | IDLE | IDLE | IDLE | TCSNR | TCSNR | TCSNR | TCSNR | TCSNR | IDLE | IDLE | TCSNR | TCSNR | TCSNR | TCSNR | TCSNR | IDLE | IDLE | TCSNR | TCSNR | IDLE | TCSNR | TCSNR | TCSNR | TCSNR | TRAIN | IDLE | TCSNR | TCSNR | TCSNR | IDLE
Employee 21 | IDLE | IDLE | IDLE | IDLE | TCSNR | PERSONAL LEAVE | TCSNR | TCSNR | TCSNR | IDLE | IDLE | TCSNR | TCSNR | TCSNR | TCSNR | TCSNR | IDLE | ADMIN | TCSNR | TCSNR | TRAIN | TCSNR | TCSNR | IDLE | IDLE | TCSNR | PERSONAL LEAVE | TCSNR | TCSNR | PERSONAL LEAVE | IDLE
Employee 22
Employee 23
Employee 24
Employee 25
Employee 26
Employee 27
Employee 28
Employee 29
Employee 30
Employee 31
Employee 32
Employee 33
Employee 34
Employee 35
Employee 36
Employee 37
Employee 38
Employee 39
Employee 40
Employee 41
Employee 42
Employee 43
Employee 44
Employee 45
Employee 46
Employee 47
Employee 48
Employee 49
Employee 50
Employee 51
Employee 52
Employee 53
Employee 54
Employee 55
Employee 56
Employee 57
Employee 58
Employee 59
Employee 60
Employee 61
Employee 62
Employee 63
Employee 64
Employee 65
Employee 66
Employee 67
Employee 68