Spreadsheet: 271531d1381963958-need-to-count-occurances-over-time-range-in-a-night-shift-providerproductivity_samplereport
Sheet: Control

[NAME] | ALPHA ORDER |  |  |  |  | SELECT PROVIDER NAME |  |  |  |  |  | SHIFTS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OCCUPANCY |  | Hour of day slots |  |  | 1900-01-01 00:00:00 | 00:30:00 | 01:00:00 | 01:30:00 | 02:00:00 | 02:30:00 | 03:00:00 | 03:30:00 | 04:00:00 | 04:30:00 | 05:00:00 | 05:30:00 | 06:00:00 | 06:30:00 | 07:00:00 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00 | 16:00:00 | 16:30:00 | 17:00:00 | 17:30:00 | 18:00:00 | 18:30:00 | 19:00:00 | 19:30:00 | 20:00:00 | 20:30:00 | 21:00:00 | 21:30:00 | 22:00:00 | 22:30:00 | 23:00:00 | 23:30:00
 |  |  |  | COUNT NUM | 1 |  |  |  |  |  |  |  | SUN | MON | TUES | WED | THUR | FRI | SAT |  | Shift | Length | Provider Type | Zone |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | to | to | to | to | to | to | to | to | to | to | to | to | to | to | to | to | to | to | to | to | to | to | to | to | to | to | to | to | to | to | to | to | to | to | to | to | to | to | to | to | to | to | to | to | to | to | to | to
 |  |  |  |  | 2 |  |  |  |  |  |  |  | 6a-4p (P) | 6a-4p (P) | 6a-4p (P) | 6a-4p (P) | 6a-4p (P) | 6a-4p (P) | 6a-4p (P) |  | 6a-4p (P) | 10 | Physician | Yellow |  |  |  |  |  | DAY 1 |  |  | DAY 2 |  |  |  |  |  |  |  |  | 00:30:00 | 01:00:00 | 01:30:00 | 02:00:00 | 02:30:00 | 03:00:00 | 03:30:00 | 04:00:00 | 04:30:00 | 05:00:00 | 05:30:00 | 06:00:00 | 06:30:00 | 07:00:00 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00 | 16:00:00 | 16:30:00 | 17:00:00 | 17:30:00 | 18:00:00 | 18:30:00 | 19:00:00 | 19:30:00 | 20:00:00 | 20:30:00 | 21:00:00 | 21:30:00 | 22:00:00 | 22:30:00 | 23:00:00 | 23:30:00 | 00:00:01
 |  |  |  |  | 3 |  |  |  |  |  |  |  | 7a-5p (P) | 7a-5p (P) | 7a-5p (P) | 7a-5p (P) | 7a-5p (P) | 7a-5p (P) | 7a-5p (P) |  | 7a-5p (P) | 10 | Physician | Blue |  |  |  |  |  | FOR [NAME] AND OCCUPANCY
 |  |  |  |  | 4 |  |  |  |  |  |  |  | 7a-7p (P) | 7a-7p (P) | 7a-7p (P) | 7a-7p (P) | 7a-7p (P) | 7a-7p (P) | 7a-7p (P) |  | 7a-7p (P) | 12 | Physician | Orange |  |  |  |  |  |  |  | Hour of Day | Arrivals | D2D Sum | Avg D2D (Mins) | D2D Target
 |  |  |  |  | 5 |  |  |  |  |  |  |  | 9a-6p (P) | 9a-6p (P) | 9a-6p (P) | 9a-6p (P) | 9a-6p (P) | 9a-6p (P) | 9a-6p (P) |  | 9a-6p (P) | 9 | Physician | Green |  |  |  |  |  | Same | Same6 |  |  |  |  | 30
 |  |  |  |  | 6 |  |  |  |  |  |  |  | 10a-8p (P) | 10a-8p (P) | 10a-8p (P) | 10a-8p (P) | 10a-8p (P) | 10a-8p (P) | 10a-8p (P) |  | 10a-8p (P) | 10 | Physician | Purple |  |  |  |  |  | Same | Same7 | 07:00:00 |  |  |  | 30 |  | Time | Occupancy | Arrivals
 |  |  |  |  | 7 |  |  |  |  |  |  |  | 4p-2a (P) | 4p-2a (P) | 4p-2a (P) | 4p-2a (P) | 4p-2a (P) | 4p-2a (P) | 4p-2a (P) |  | 4p-2a (P) | 10 | Physician | Yellow |  |  |  |  |  | Same | Same8 | 08:00:00 |  |  |  | 30 | Same | 06:00:00
 |  |  |  |  | 8 |  |  |  |  |  |  |  | 6p-4a (P) | 6p-4a (P) | 6p-4a (P) | 6p-4a (P) | 6p-4a (P) | 6p-4a (P) | 6p-4a (P) |  | 6p-4a (P) | 10 | Physician | Green |  |  |  |  |  | Same | Same9 | 09:00:00 |  |  |  | 30 | Same | 06:30:00 | #REF!
 |  |  |  |  | 9 |  |  |  |  |  |  |  | 7p-3a (P) | 7p-3a (P) | 7p-3a (P) | 7p-3a (P) | 7p-3a (P) | 7p-3a (P) | 7p-3a (P) |  | 7p-3a (P) | 8 | Physician | Blue |  |  |  |  |  | Same | Same10 | 10:00:00 |  |  |  | 30 | Same | 07:00:00 | #REF!
 |  |  |  |  | 10 |  |  |  |  |  |  |  | 7p-7a (P) | 7p-7a (P) | 7p-7a (P) | 7p-7a (P) | 7p-7a (P) | 7p-7a (P) | 7p-7a (P) |  | 7p-7a (P) | 12 | Physician | Orange |  |  |  |  |  | Same | Same11 | 11:00:00 |  |  |  | 30 | Same | 07:30:00 | #REF!
 |  |  |  |  | 11 |  |  |  |  |  |  |  | 8p-6a (P) | 8p-6a (P) | 8p-6a (P) | 8p-6a (P) | 8p-6a (P) | 8p-6a (P) | 8p-6a (P) |  | 8p-6a (P) | 10 | Physician | Purple |  |  |  |  |  | Same | Same12 | 12:00:00 |  |  |  | 30 | Same | 08:00:00 | #REF!
 |  |  |  |  | 12 |  |  |  |  |  |  |  | 6a-4p (MLP) | 6a-4p (MLP) | 6a-4p (MLP) | 6a-4p (MLP) | 6a-4p (MLP) | 6a-4p (MLP) | 6a-4p (MLP) |  | 6a-4p (MLP) | 10 | Mid-Level | Blue |  |  |  |  |  | Same | Same13 | 13:00:00 |  |  |  | 30 | Same | 08:30:00 | #REF!
 |  |  |  |  | 13 |  |  |  |  |  |  |  | 10a-7p (MLP) | 10a-7p (MLP) | 10a-7p (MLP) | 10a-7p (MLP) | 9a-7p (MLP) | 10a-7p (MLP) | 10a-7p (MLP) |  | 10a-7p (MLP) | 9 | Mid-Level | Purple/Blue |  |  |  |  |  | Same | Same14 | 14:00:00 |  |  |  | 30 | Same | 09:00:00 | #REF!
 |  |  |  |  | 14 |  |  |  |  |  |  |  | 11a-9p (MLP) | 11a-9p (MLP) | 11a-9p (MLP) | 11a-9p (MLP) | 11a-9p (MLP) | 11a-9p (MLP) | 11a-9p (MLP) |  | 11a-9p (MLP) | 10 | Mid-Level | Lavendar |  |  |  |  |  | Same | Same15 | 15:00:00 |  |  |  | 30 | Same | 09:30:00 | #REF!
 |  |  |  |  | 15 |  |  |  |  |  |  |  | 3p-1a (MLP) | 3p-1a (MLP) | 3p-1a (MLP) | 3p-1a (MLP) | 3p-1a (MLP) | 3p-1a (MLP) | 3p-1a (MLP) |  | 3p-1a (MLP) | 10 | Mid-Level | Purple |  |  |  |  |  | Same | Same16 | 16:00:00 |  |  |  | 30 | Same | 10:00:00 | #REF!
 |  |  |  |  | 16 |  |  |  |  |  |  |  | 5p-3a (MLP) | 5p-3a (MLP) | 5p-3a (MLP) | 5p-3a (MLP) | 5p-3a (MLP) | 5p-3a (MLP) | 5p-3a (MLP) |  | 5p-3a (MLP) | 10 | Mid-Level | Blue |  |  |  |  |  | Same | Same17 | 17:00:00 |  |  |  | 30 | Same | 10:30:00 | #REF!
 |  |  |  |  | 17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Same | Same18 | 18:00:00 |  |  |  | 30 | Same | 11:00:00 | #REF!
 |  |  |  |  | 18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Same | Same19 | 19:00:00 |  |  |  | 30 | Same | 11:30:00 | #REF!
 |  |  |  |  | 19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Same | Same20 | 20:00:00 |  |  |  | 30 | Same | 12:00:00 | #REF!
 |  |  |  |  | 20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Same | Same21 | 21:00:00 |  |  |  | 30 | Same | 12:30:00 | #REF!
 |  |  |  |  | 21 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Same | Same22 | 22:00:00 |  |  |  | 30 | Same | 13:00:00 | #REF!
 |  |  |  |  | 22 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Same | Same23 | 23:00:00 |  |  |  | 30 | Same | 13:30:00 | #REF!
 |  |  |  |  | 23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Same+10 | Same+100 |  |  |  |  | 30 | Same | 14:00:00 | #REF!
 |  |  |  |  | 24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Same+10 | Same+101 | 1900-01-01 01:00:00 |  |  |  | 30 | Same | 14:30:00 | #REF!
 |  |  |  |  | 25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Same+10 | Same+102 | 1900-01-01 02:00:00 |  |  |  | 30 | Same | 15:00:00 | #REF!
 |  |  |  |  | 26 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Same+10 | Same+103 | 1900-01-01 03:00:00 |  |  |  | 30 | Same | 15:30:00 | #REF!
 |  |  |  |  | 27 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Same+10 | Same+104 | 1900-01-01 04:00:00 |  |  |  | 30 | Same | 16:00:00 | #REF!
 |  |  |  |  | 28 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Same+10 | Same+105 | 1900-01-01 05:00:00 |  |  |  | 30 | Same | 16:30:00 | #REF!
 |  |  |  |  | 29 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Same+10 | Same+106 | 1900-01-01 06:00:00 |  |  |  | 30 | Same | 17:00:00 | #REF!
 |  |  |  |  | 30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Same+10 | Same+107 | 1900-01-01 07:00:00 |  |  |  | 30 | Same | 17:30:00 | #REF!
 |  |  |  |  | 31 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Same | 18:00:00 | #REF!
 |  |  |  |  | 32 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Same | 18:30:00 | #REF!
 |  |  |  |  | 33 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Same | 19:00:00 | #REF!
 |  |  |  |  | 34 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Same | 19:30:00 | #REF!
 |  |  |  |  | 35 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Same | 20:00:00 | #REF!
 |  |  |  |  | 36 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Same | 20:30:00 | #REF!
 |  |  |  |  | 37 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Same | 21:00:00 | #REF!
 |  |  |  |  | 38 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Same | 21:30:00 | #REF!
 |  |  |  |  | 39 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Same | 22:00:00 | #REF!
 |  |  |  |  | 40 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Same | 22:30:00 | #REF!
 |  |  |  |  | 41 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Same | 23:00:00 | #REF!
 |  |  |  |  | 42 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Same | 23:30:00 | #REF!
 |  |  |  |  | 43 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Same+1 | 1900-01-01 00:00:00
 |  |  |  |  | 44 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Same+1 | 1900-01-01 00:30:00 | #REF!
 |  |  |  |  | 45 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Same+1 | 1900-01-01 01:00:00 | #REF!
 |  |  |  |  | 46 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Same+1 | 1900-01-01 01:30:00 | #REF!
 |  |  |  |  | 47 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Same+1 | 1900-01-01 02:00:00 | #REF!
 |  |  |  |  | 48 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Same+1 | 1900-01-01 02:30:00 | #REF!
 |  |  |  |  | 49 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Same+1 | 1900-01-01 03:00:00 | #REF!
 |  |  |  |  | 50 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Same+1 | 1900-01-01 03:30:00 | #REF!
 |  |  |  |  | 51 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Same+1 | 1900-01-01 04:00:00 | #REF!
 |  |  |  |  | 52 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Same+1 | 1900-01-01 04:30:00 | #REF!
 |  |  |  |  | 53 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Same+1 | 1900-01-01 05:00:00 | #REF!
 |  |  |  |  | 54 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Same+1 | 1900-01-01 05:30:00 | #REF!
 |  |  |  |  | 55 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Same+1 | 1900-01-01 06:00:00 | #REF!
 |  |  |  |  | 56 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Same+1 | 1900-01-01 06:30:00 | #REF!
 |  |  |  |  | 57 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Same+1 | 1900-01-01 07:00:00 | #REF!
 |  |  |  |  | 58 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Same+1 | 1900-01-01 07:30:00 | #REF!
 |  |  |  |  | 59
 |  |  |  |  | 60
 |  |  |  |  | 61
 |  |  |  |  | 62
 |  |  |  |  | 63
 |  |  |  |  | 64
 |  |  |  |  | 65
 |  |  |  |  | 66
 |  |  |  |  | 67
 |  |  |  |  | 68
 |  |  |  |  | 69
 |  |  |  |  | 70
 |  |  |  |  | 71
 |  |  |  |  | 72
 |  |  |  |  | 73
 |  |  |  |  | 74
 |  |  |  |  | 75
 |  |  |  |  | 76
 |  |  |  |  | 77
 |  |  |  |  | 78
 |  |  |  |  | 79
 |  |  |  |  | 80
 |  |  |  |  | 81
 |  |  |  |  | 82
 |  |  |  |  | 83
 |  |  |  |  | 84
 |  |  |  |  | 85
 |  |  |  |  | 86
 |  |  |  |  | 87
 |  |  |  |  | 88
 |  |  |  |  | 89
 |  |  |  |  | 90
 |  |  |  |  | 91
 |  |  |  |  | 92
 |  |  |  |  | 93
 |  |  |  |  | 94
 |  |  |  |  | 95
 |  |  |  |  | 96
 |  |  |  |  | 97
 |  |  |  |  | 98
 |  |  |  |  | 99
 |  |  |  |  | 100