Spreadsheet: 51292d1250819812-slow-array-formulas-test
Sheet: Sheet1

employee | department | shift | date
EMPLOYEE 1 | DEPARTMENT 1 |  | 2009-04-06 00:00:00
EMPLOYEE 1 | DEPARTMENT 1 | D | 2009-04-07 00:00:00
EMPLOYEE 1 | DEPARTMENT 1 | D | 2009-04-08 00:00:00
EMPLOYEE 1 | DEPARTMENT 1 | D | 2009-04-09 00:00:00
EMPLOYEE 1 | DEPARTMENT 1 |  | 2009-04-10 00:00:00
EMPLOYEE 1 | DEPARTMENT 1 |  | 2009-04-11 00:00:00
EMPLOYEE 1 | DEPARTMENT 1 |  | 2009-04-12 00:00:00
EMPLOYEE 1 | DEPARTMENT 1 | A | 2009-04-13 00:00:00
EMPLOYEE 1 | DEPARTMENT 1 | A | 2009-04-14 00:00:00
EMPLOYEE 1 | DEPARTMENT 1 | A | 2009-04-15 00:00:00
EMPLOYEE 1 | DEPARTMENT 1 |  | 2009-04-16 00:00:00
EMPLOYEE 1 | DEPARTMENT 1 | D | 2009-04-17 00:00:00
EMPLOYEE 1 | DEPARTMENT 1 | D | 2009-04-18 00:00:00
EMPLOYEE 1 | DEPARTMENT 1 | D | 2009-04-19 00:00:00
EMPLOYEE 1 | DEPARTMENT 1 | D | 2009-04-20 00:00:00
EMPLOYEE 1 | DEPARTMENT 1 |  | 2009-04-21 00:00:00
EMPLOYEE 1 | DEPARTMENT 1 |  | 2009-04-22 00:00:00
EMPLOYEE 1 | DEPARTMENT 1 | A | 2009-04-23 00:00:00
EMPLOYEE 1 | DEPARTMENT 1 | A | 2009-04-24 00:00:00
EMPLOYEE 1 | DEPARTMENT 1 | A | 2009-04-25 00:00:00
EMPLOYEE 1 | DEPARTMENT 1 | A | 2009-04-26 00:00:00
EMPLOYEE 1 | DEPARTMENT 1 |  | 2009-04-27 00:00:00
EMPLOYEE 1 | DEPARTMENT 1 | D | 2009-04-28 00:00:00
EMPLOYEE 1 | DEPARTMENT 1 | D | 2009-04-29 00:00:00
EMPLOYEE 1 | DEPARTMENT 1 | D | 2009-04-30 00:00:00
EMPLOYEE 1 | DEPARTMENT 1 |  | 2009-05-01 00:00:00
EMPLOYEE 1 | DEPARTMENT 1 |  | 2009-05-02 00:00:00
EMPLOYEE 1 | DEPARTMENT 1 |  | 2009-05-03 00:00:00
EMPLOYEE 2 | DEPARTMENT 2 | A | 2009-04-06 00:00:00
EMPLOYEE 2 | DEPARTMENT 2 | A | 2009-04-07 00:00:00
EMPLOYEE 2 | DEPARTMENT 2 | A | 2009-04-08 00:00:00
EMPLOYEE 2 | DEPARTMENT 2 |  | 2009-04-09 00:00:00
EMPLOYEE 2 | DEPARTMENT 2 | D | 2009-04-10 00:00:00
EMPLOYEE 2 | DEPARTMENT 2 | D | 2009-04-11 00:00:00
EMPLOYEE 2 | DEPARTMENT 2 | D | 2009-04-12 00:00:00
EMPLOYEE 2 | DEPARTMENT 2 | D | 2009-04-13 00:00:00
EMPLOYEE 2 | DEPARTMENT 2 |  | 2009-04-14 00:00:00
EMPLOYEE 2 | DEPARTMENT 2 |  | 2009-04-15 00:00:00
EMPLOYEE 2 | DEPARTMENT 2 | A | 2009-04-16 00:00:00
EMPLOYEE 2 | DEPARTMENT 2 | A | 2009-04-17 00:00:00
EMPLOYEE 2 | DEPARTMENT 2 | A | 2009-04-18 00:00:00
EMPLOYEE 2 | DEPARTMENT 2 | A | 2009-04-19 00:00:00
EMPLOYEE 2 | DEPARTMENT 2 |  | 2009-04-20 00:00:00
EMPLOYEE 2 | DEPARTMENT 2 | D | 2009-04-21 00:00:00
EMPLOYEE 2 | DEPARTMENT 2 | D | 2009-04-22 00:00:00
EMPLOYEE 2 | DEPARTMENT 2 | D | 2009-04-23 00:00:00
EMPLOYEE 2 | DEPARTMENT 2 |  | 2009-04-24 00:00:00
EMPLOYEE 2 | DEPARTMENT 2 |  | 2009-04-25 00:00:00
EMPLOYEE 2 | DEPARTMENT 2 |  | 2009-04-26 00:00:00
EMPLOYEE 2 | DEPARTMENT 2 | A | 2009-04-27 00:00:00
EMPLOYEE 2 | DEPARTMENT 2 | A | 2009-04-28 00:00:00
EMPLOYEE 2 | DEPARTMENT 2 | A | 2009-04-29 00:00:00
EMPLOYEE 2 | DEPARTMENT 2 |  | 2009-04-30 00:00:00
EMPLOYEE 2 | DEPARTMENT 2 | D | 2009-05-01 00:00:00
EMPLOYEE 2 | DEPARTMENT 2 | D | 2009-05-02 00:00:00
EMPLOYEE 2 | DEPARTMENT 2 | D | 2009-05-03 00:00:00
EMPLOYEE 3 | DEPARTMENT 3 |  | 2009-04-06 00:00:00
EMPLOYEE 3 | DEPARTMENT 3 |  | 2009-04-07 00:00:00
EMPLOYEE 3 | DEPARTMENT 3 | A | 2009-04-08 00:00:00
EMPLOYEE 3 | DEPARTMENT 3 | A | 2009-04-09 00:00:00
EMPLOYEE 3 | DEPARTMENT 3 | A | 2009-04-10 00:00:00
EMPLOYEE 3 | DEPARTMENT 3 | A | 2009-04-11 00:00:00
EMPLOYEE 3 | DEPARTMENT 3 | A | 2009-04-12 00:00:00
EMPLOYEE 3 | DEPARTMENT 3 |  | 2009-04-13 00:00:00
EMPLOYEE 3 | DEPARTMENT 3 |  | 2009-04-14 00:00:00
EMPLOYEE 3 | DEPARTMENT 3 | D | 2009-04-15 00:00:00
EMPLOYEE 3 | DEPARTMENT 3 | D | 2009-04-16 00:00:00
EMPLOYEE 3 | DEPARTMENT 3 | D | 2009-04-17 00:00:00
EMPLOYEE 3 | DEPARTMENT 3 | D | 2009-04-18 00:00:00
EMPLOYEE 3 | DEPARTMENT 3 |  | 2009-04-19 00:00:00
EMPLOYEE 3 | DEPARTMENT 3 | A | 2009-04-20 00:00:00
EMPLOYEE 3 | DEPARTMENT 3 | A | 2009-04-21 00:00:00
EMPLOYEE 3 | DEPARTMENT 3 | A | 2009-04-22 00:00:00
EMPLOYEE 3 | DEPARTMENT 3 | A | 2009-04-23 00:00:00
EMPLOYEE 3 | DEPARTMENT 3 | A | 2009-04-24 00:00:00
EMPLOYEE 3 | DEPARTMENT 3 |  | 2009-04-25 00:00:00
EMPLOYEE 3 | DEPARTMENT 3 |  | 2009-04-26 00:00:00
EMPLOYEE 3 | DEPARTMENT 3 | N | 2009-04-27 00:00:00
EMPLOYEE 3 | DEPARTMENT 3 | N | 2009-04-28 00:00:00
EMPLOYEE 3 | DEPARTMENT 3 | N | 2009-04-29 00:00:00
EMPLOYEE 3 | DEPARTMENT 3 |  | 2009-04-30 00:00:00
EMPLOYEE 3 | DEPARTMENT 3 |  | 2009-05-01 00:00:00
EMPLOYEE 3 | DEPARTMENT 3 | D | 2009-05-02 00:00:00
EMPLOYEE 3 | DEPARTMENT 3 | D | 2009-05-03 00:00:00