Spreadsheet: 461656d1463673428-formula-when-drag-should-use-horizontal-values-eda-resource-allocaiton-sheet-copy2
Sheet: Monthly Workload

Names | Dates |  | 2016-06-01 00:00:00 | 2016-06-02 00:00:00 | 2016-06-03 00:00:00 | 2016-06-04 00:00:00 | 2016-06-05 00:00:00 | 2016-06-06 00:00:00 | 2016-06-07 00:00:00 | 2016-06-08 00:00:00 | 2016-06-09 00:00:00 | 2016-06-10 00:00:00 | 2016-06-11 00:00:00 | 2016-06-12 00:00:00 | 2016-06-13 00:00:00 | 2016-06-14 00:00:00 | 2016-06-15 00:00:00 | 2016-06-16 00:00:00 | 2016-06-17 00:00:00 | 2016-06-18 00:00:00 | 2016-06-19 00:00:00 | 2016-06-20 00:00:00 | 2016-06-21 00:00:00 | 2016-06-22 00:00:00 | 2016-06-23 00:00:00 | 2016-06-24 00:00:00 | 2016-06-25 00:00:00 | 2016-06-26 00:00:00 | 2016-06-27 00:00:00 | 2016-06-28 00:00:00 | 2016-06-29 00:00:00 | 2016-06-30 00:00:00 | Total
 | Studies
[NAME] | 20062004 |  | 1 |  | 1 |  |  | 1 |  | 1 |  |  |  |  | 1 |  | 1 |  |  |  |  | 1 |  | 1 |  |  |  |  |  | 1 |  | 1
[NAME] | 20070509 |  | 1 |  | 1 |  |  | 1 |  | 1 |  |  |  |  | 1 |  | 1 |  |  |  |  | 1 |  | 1 |  |  |  |  |  | 1 |  | 1
[NAME] | NE20070782 | MONTHLY_1st Day | 1 |  | 1 |  |  | 1 |  | 1 |  |  |  |  | 1 |  | 1 |  |  |  |  | 1 |  | 1 |  |  |  |  |  | 1 |  | 1
[NAME] | NE20090160 | MONTHLY_1st Day | 1 |  | 1 |  |  | 1 |  | 1 |  |  |  |  | 1 |  | 1 |  |  |  |  | 1 |  | 1
[NAME] | Leave
Gokul G | 103311 |  | 1 |  | 1 |  |  | 1 |  | 1 |  |  |  |  | 1 |  | 1 |  |  |  |  | 1 |  | 1 |  |  |  |  | 1 |  | 1
Gokul G | 20110113 | MONTHLY_1st Day | 1 |  | 1 |  |  | 1 |  | 1 |  |  |  |  | 1 |  | 1 |  |  |  |  | 1 |  | 1 |  |  |  |  | 1 |  | 1
Gokul G | 20120216 |  | 1 |  | 1 |  |  | 1 |  | 1 |  |  |  |  | 1 |  | 1 |  |  |  |  | 1 |  | 1 |  |  |  |  | 1 |  | 1
Gokul G | 20120295 |  |  | 1 |  |  |  | 1
Gokul G | Leave
Nataraj Padashetty | 20060342 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1
Nataraj Padashetty | 20090505 |  | 1 |  | 1 |  |  | 1 |  | 1 |  |  |  |  | 1 |  | 1 |  | 1 |  |  | 1 |  |  |  |  |  |  | 1 |  | 1
Nataraj Padashetty | 20120296 |  |  |  |  |  |  | 1 |  | 1
Nataraj Padashetty | 20120297 |  | 1 |  | 1 |  |  |  | 1 |  | 1
Nataraj Padashetty | 20130255 |  |  |  |  |  |  |  | 1 |  | 1
Nataraj Padashetty | Leave |  |  | 8 |  |  |  |  |  |  |  | 8
Niranjan Kumar | 20060359 |  | 1 |  | 1
Niranjan Kumar | 20060517
Niranjan Kumar | 20070337
Niranjan Kumar | 20080560
Niranjan Kumar | 20090482
Niranjan Kumar | 20090508
Niranjan Kumar | 20100007
Niranjan Kumar | 20101103
Niranjan Kumar | 20101217
Niranjan Kumar | 20110110 | Monthly_3rd Monday
Niranjan Kumar | 20110142 | Monthly_1st day, Second Monday, Every Wednesday
Niranjan Kumar | 20110166
Niranjan Kumar | 20110174
Niranjan Kumar | 20110232
Niranjan Kumar | 20110271
Niranjan Kumar | 20110226
Niranjan Kumar | Leave |  |  |  | 8 |  |  |  |  |  |  | 8
[NAME] | 20080016 |  |  |  |  |  |  | 1 |  | 1
[NAME] | 20101132 |  | 1 |  | 1 |  |  | 1 |  | 1 |  |  |  |  | 1 |  | 1 |  |  |  |  | 1 |  | 1 |  |  |  |  | 1 |  | 1
[NAME] | 20101262 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1
[NAME] | 20120106 |  | 1 |  | 1 |  |  | 1 |  | 1 |  |  |  |  | 1 |  | 1 |  |  |  |  | 1 |  | 1 |  |  |  |  | 1 |  | 1
[NAME] | 20120178 |  |  | 1 |  |  |  | 1 |  |  |  |  |  |  | 1 |  | 1 |  |  |  |  |  | 1 |  | 1 |  |  |  |  | 1 |  | 1
[NAME] | Leave |  | 8 | 8
Tanmay Das | 20080579 |  | 1 |  | 1 |  |  | 1 |  | 1 |  |  |  |  | 1 |  | 1 |  |  |  |  |  | 1 |  | 1 |  |  |  | 1 |  | 1
Tanmay Das | 20090340 |  | 1 |  | 1 |  |  |  | 1 |  | 1 |  |  |  |  | 1 |  | 1 |  |  |  | 1 |  | 1 |  |  |  |  | 1 |  | 1
Tanmay Das | 20110100 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1
Tanmay Das | 20130113 |  | 1 |  | 1 |  |  |  |  |  |  |  |  |  | 1 |  | 1 |  |  |  |  | 1 |  | 1 |  |  |  |  |  | 1 |  | 1
Tanmay Das | Leave |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  |  |  | 4