Spreadsheet: 697754d1601507206-date-formula-validation-to-true-false-mds-professional-services-dashboard-30sep2020-v2
Sheet: Calculation

For [NAME]-down selections
Security |  |  |  |  |  |  |  |  |  |  |  | 1
Infrastructure |  |  |  |  |  |  |  |  |  |  |  | 2
Prod&App |  |  |  |  |  |  |  |  |  |  |  | 3
PM |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  |  |  |  |  | 11
Practice | Resource | Billable % | Non-Billable % | Utilization % | Billable % | Non-Billable % | Utilization % | Unaccounted Hours | Start Date | End Date | Current | 12
Security | [NAME] |  |  |  |  |  |  |  | 2020-01-01 00:00:00 |  |  | 13
Security | [NAME] |  |  |  |  |  |  |  | 2020-01-01 00:00:00 | 2020-02-07 00:00:00 |  | 14
Security | [NAME] |  |  |  |  |  |  |  | 2020-01-01 00:00:00 |  |  | 15
Security | [NAME] |  |  |  |  |  |  |  | 2020-01-01 00:00:00 |  |  | 16
Infrastructure | [NAME] |  |  |  |  |  |  |  | 2020-01-01 00:00:00 |  |  | 17
Prod&App | [NAME] |  |  |  |  |  |  |  | 2020-01-01 00:00:00 |  |  | 18
Security | [NAME] |  |  |  |  |  |  |  | 2020-01-01 00:00:00 |  |  | 19
Infrastructure | [NAME] |  |  |  |  |  |  |  | 2020-01-01 00:00:00 |  |  | 20
Prod&App | [NAME] |  |  |  |  |  |  |  | 2020-01-01 00:00:00 |  |  | 21
Security | [NAME] |  |  |  |  |  |  |  | 2020-01-01 00:00:00 |  |  | 22
Prod&App | [NAME] |  |  |  |  |  |  |  | 2020-01-01 00:00:00 |  |  | 23
Infrastructure | [NAME] |  |  |  |  |  |  |  | 2020-01-01 00:00:00 |  |  | 24
Security | [NAME] |  |  |  |  |  |  |  | 2020-01-01 00:00:00 |  |  | 25
Prod&App | [NAME] |  |  |  |  |  |  |  | 2020-01-01 00:00:00 |  |  | 26
Security | [NAME] |  |  |  |  |  |  |  | 2020-01-01 00:00:00 |  |  | 27
Prod&App | [NAME] |  |  |  |  |  |  |  | 2020-01-01 00:00:00 |  |  | 28
Security | [NAME] |  |  |  |  |  |  |  | 2020-01-01 00:00:00 |  |  | 29
PM | Asif Iqbal |  |  |  |  |  |  |  | 2020-01-01 00:00:00 |  |  | 30
PM | [NAME] |  |  |  |  |  |  |  | 2020-01-01 00:00:00 |  |  | 31
PM | [NAME] |  |  |  |  |  |  |  | 2020-01-01 00:00:00 |  |  | 32
PM | [NAME] |  |  |  |  |  |  |  | 2020-01-01 00:00:00 |  |  | 33
Infrastructure | [NAME] |  |  |  |  |  |  |  | 2020-01-01 00:00:00 |  |  | 34
Prod&App | [NAME] |  |  |  |  |  |  |  | 2020-01-01 00:00:00 | 2020-09-08 00:00:00 |  | 35
Infrastructure | [NAME] |  |  |  |  |  |  |  | 2020-01-01 00:00:00 |  |  | 36
PM | [NAME] |  |  |  |  |  |  |  | 2020-01-02 00:00:00 |  |  | 37
Security | [NAME] |  |  |  |  |  |  |  | 2020-01-02 00:00:00 |  |  | 38
Infrastructure | Ezequiel Rosado |  |  |  |  |  |  |  | 2020-01-01 00:00:00 |  |  | 39
Infrastructure | [NAME] |  |  |  |  |  |  |  | 2020-02-03 00:00:00 |  |  | 40
PM | [NAME] |  |  |  |  |  |  |  | 2020-05-18 00:00:00 |  |  | 41
Prod&App | [NAME] |  |  |  |  |  |  |  | 2020-07-16 00:00:00 | 2020-09-08 00:00:00 |  | 42
Security | [NAME] |  |  |  |  |  |  |  | 2020-06-15 00:00:00 |  |  | 43
PM | [NAME] |  |  |  |  |  |  |  | 2020-08-03 00:00:00 |  |  | 44
Security | [NAME] |  |  |  |  |  |  |  | 2020-07-16 00:00:00 |  |  | 45
Prod&App | [NAME] |  |  |  |  |  |  |  | 2020-09-02 00:00:00 |  |  | 46
Security | [NAME] |  |  |  |  |  |  |  | 2020-09-14 00:00:00 |  |  | 47
 |  |  |  |  |  |  |  |  |  |  |  | 48
 |  |  |  |  |  |  |  |  |  |  |  | 49
 |  |  |  |  |  |  |  |  |  |  |  | 50
 |  |  |  |  |  |  |  |  |  |  |  | 51
 |  |  |  |  |  |  |  |  |  |  |  | 52