Spreadsheet: 58811d1259074467-extracting-and-calculating-types-of-leave-per-department-example-8
Sheet: Sheet1

Count of Leave Type Code |  | Leave Type Code
Location 3 | Date Captured | A | FR | L | NB | O | S | U | Grand Total
CORE CUTTING | 2009-01-12 00:00:00 |  |  |  |  |  |  | 3 | 3
 | 2009-01-15 00:00:00 |  |  |  |  |  |  | 1 | 1
 | 2009-02-02 00:00:00 |  |  |  |  |  |  | 1 | 1
 | 2009-03-25 00:00:00 |  |  |  |  |  |  | 1 | 1
 | 2009-04-24 00:00:00 |  |  |  |  |  |  | 1 | 1
 | 2009-06-12 00:00:00 |  |  |  |  |  | 1 |  | 1
 | 2009-08-07 00:00:00 |  |  |  |  |  | 1 | 1 | 2
 | 2009-08-17 00:00:00 |  |  |  |  |  |  | 1 | 1
 | 2009-08-24 00:00:00 |  |  |  |  |  |  | 1 | 1
 | 2009-09-21 00:00:00 |  |  |  |  |  | 1 | 1 | 2
 | 2009-09-28 00:00:00 |  |  |  |  |  |  | 2 | 2
 | 2009-10-12 00:00:00 |  |  |  |  |  | 1 |  | 1
 | 2009-10-23 00:00:00 |  |  |  |  |  | 1 |  | 1
CORE CUTTING Total |  |  |  |  |  |  | 5 | 13 | 18
FABRICATION | 2009-01-12 00:00:00 |  |  | 1 |  |  |  |  | 1
 | 2009-01-20 00:00:00 | 1 |  |  |  |  |  |  | 1
 | 2009-02-03 00:00:00 |  |  | 2 |  |  |  |  | 2
 | 2009-02-10 00:00:00 |  |  |  |  |  | 1 |  | 1
 | 2009-02-12 00:00:00 | 2 | 1 |  |  |  |  |  | 3
 | 2009-02-23 00:00:00 | 1 |  |  |  |  |  |  | 1
 | 2009-03-03 00:00:00 |  | 1 |  |  |  |  |  | 1
 | 2009-04-08 00:00:00 | 1 |  |  |  |  |  |  | 1
 | 2009-04-14 00:00:00 |  | 1 |  |  |  |  |  | 1
 | 2009-04-20 00:00:00 |  | 1 | 2 |  |  |  |  | 3
 | 2009-05-05 00:00:00 | 1 |  |  |  |  |  |  | 1
 | 2009-05-12 00:00:00 |  |  | 1 |  |  |  |  | 1
 | 2009-06-02 00:00:00 | 1 |  | 1 |  |  | 1 |  | 3
 | 2009-06-09 00:00:00 |  |  | 1 |  |  |  |  | 1
 | 2009-07-07 00:00:00 |  | 2 | 1 |  |  |  |  | 3
 | 2009-07-14 00:00:00 |  | 1 | 1 |  |  |  |  | 2
 | 2009-07-27 00:00:00 |  |  | 2 |  |  |  |  | 2
 | 2009-08-20 00:00:00 | 1 |  |  |  |  |  |  | 1
 | 2009-09-01 00:00:00 |  | 1 |  |  |  |  |  | 1
 | 2009-09-08 00:00:00 |  | 1 |  |  |  |  |  | 1
 | 2009-09-22 00:00:00 |  |  | 1 |  |  |  |  | 1
 | 2009-10-12 00:00:00 |  | 3 |  |  |  | 1 |  | 4
 | 2009-10-20 00:00:00 |  | 1 | 2 |  |  |  |  | 3
 | 2009-11-03 00:00:00 |  | 1 |  |  |  |  |  | 1
FABRICATION Total |  | 8 | 14 | 15 |  |  | 3 |  | 40
STEELYARD | 2009-01-12 00:00:00 |  |  | 2 |  |  |  | 1 | 3
 | 2009-01-20 00:00:00 |  |  |  |  |  | 1 |  | 1
 | 2009-01-27 00:00:00 |  | 1 |  |  |  |  |  | 1
 | 2009-01-29 00:00:00 |  |  |  |  |  |  | 1 | 1
 | 2009-02-04 00:00:00 | 1 |  |  |  |  |  |  | 1
 | 2009-02-10 00:00:00 |  |  |  |  |  | 1 |  | 1
 | 2009-02-17 00:00:00 |  |  |  |  |  | 1 |  | 1
 | 2009-02-24 00:00:00 |  |  |  |  |  | 1 |  | 1
 | 2009-03-03 00:00:00 | 1 |  |  |  |  | 1 |  | 2
 | 2009-03-10 00:00:00 | 1 |  | 2 |  |  |  |  | 3
 | 2009-03-17 00:00:00 |  |  |  |  |  | 1 |  | 1
 | 2009-03-24 00:00:00 |  |  |  |  |  | 2 |  | 2
 | 2009-03-31 00:00:00 |  |  |  |  |  | 1 |  | 1
 | 2009-04-09 00:00:00 |  |  |  |  |  | 1 |  | 1
 | 2009-04-14 00:00:00 |  |  |  |  | 1 | 1 |  | 2
 | 2009-04-20 00:00:00 |  |  |  |  |  | 3 |  | 3
 | 2009-04-29 00:00:00 |  |  |  | 1 |  |  |  | 1
 | 2009-05-05 00:00:00 | 1 |  |  |  |  | 1 |  | 2
 | 2009-05-11 00:00:00 |  |  |  | 2 |  |  |  | 2
 | 2009-05-12 00:00:00 |  | 1 | 1 |  |  | 1 |  | 3
 | 2009-05-19 00:00:00 |  |  |  |  |  | 1 |  | 1
 | 2009-05-26 00:00:00 |  |  |  |  |  | 1 |  | 1
 | 2009-05-27 00:00:00 |  |  | 1 |  |  |  |  | 1
 | 2009-06-02 00:00:00 |  |  |  |  |  | 1 |  | 1
 | 2009-06-03 00:00:00 |  | 1 |  |  |  |  |  | 1
 | 2009-06-09 00:00:00 |  | 1 |  |  |  |  |  | 1
 | 2009-06-15 00:00:00 |  |  | 1 |  |  | 1 |  | 2
 | 2009-06-23 00:00:00 |  |  |  |  |  | 1 |  | 1
 | 2009-06-30 00:00:00 |  |  | 1 |  |  | 1 |  | 2
 | 2009-07-07 00:00:00 |  |  |  |  |  | 2 |  | 2
 | 2009-07-08 00:00:00 |  |  |  | 1 |  |  |  | 1
 | 2009-07-14 00:00:00 |  | 1 |  |  |  |  |  | 1
 | 2009-07-20 00:00:00 |  |  |  |  |  | 1 |  | 1
 | 2009-07-21 00:00:00 |  |  |  | 1 |  |  |  | 1
 | 2009-07-27 00:00:00 |  |  | 1 |  |  |  |  | 1
 | 2009-08-04 00:00:00 |  |  |  |  |  | 2 |  | 2
 | 2009-08-18 00:00:00 |  |  | 2 |  |  | 2 |  | 4
 | 2009-08-25 00:00:00 | 1 |  |  |  |  |  |  | 1
 | 2009-09-08 00:00:00 |  |  |  |  |  | 4 |  | 4
 | 2009-09-29 00:00:00 |  |  | 2 |  |  |  |  | 2
 | 2009-10-05 00:00:00 |  |  |  | 2 |  |  |  | 2
 | 2009-10-12 00:00:00 |  |  |  |  |  | 3 |  | 3
 | 2009-10-20 00:00:00 |  |  | 1 |  | 1 |  |  | 2
 | 2009-10-27 00:00:00 |  | 1 | 3 |  |  | 2 |  | 6
 | 2009-11-03 00:00:00 |  |  | 1 |  | 1 | 1 |  | 3
 | 2009-11-09 00:00:00 |  |  |  | 1 |  |  |  | 1
STEELYARD Total |  | 5 | 6 | 18 | 8 | 3 | 39 | 2 | 81
SUB-ASSEMBLIES | 2009-01-12 00:00:00 |  |  | 1 |  |  | 3 |  | 4
 | 2009-01-20 00:00:00 |  |  |  | 1 |  | 3 | 1 | 5
 | 2009-01-26 00:00:00 |  |  |  |  |  | 1 |  | 1
 | 2009-01-27 00:00:00 |  | 1 |  |  |  |  |  | 1
 | 2009-02-03 00:00:00 |  |  |  | 2 |  | 2 |  | 4
 | 2009-02-10 00:00:00 |  |  | 3 |  |  | 6 |  | 9
 | 2009-02-11 00:00:00 |  |  |  | 1 |  |  |  | 1
 | 2009-02-12 00:00:00 |  | 1 |  |  |  |  |  | 1
 | 2009-02-16 00:00:00 | 1 |  |  |  |  |  |  | 1
 | 2009-02-17 00:00:00 |  | 1 | 1 |  |  | 3 |  | 5
 | 2009-02-23 00:00:00 | 1 | 1 |  |  |  |  |  | 2
 | 2009-02-24 00:00:00 |  |  |  |  |  | 3 |  | 3
 | 2009-02-25 00:00:00 |  |  |  | 1 |  |  |  | 1
 | 2009-03-02 00:00:00 | 1 |  |  |  |  |  |  | 1
 | 2009-03-03 00:00:00 |  |  |  |  |  | 1 |  | 1
 | 2009-03-10 00:00:00 | 1 | 1 | 2 |  |  |  |  | 4
 | 2009-03-17 00:00:00 | 1 |  |  |  |  | 1 |  | 2
 | 2009-03-24 00:00:00 |  |  |  |  |  | 1 |  | 1
 | 2009-03-25 00:00:00 |  | 1 |  |  |  |  |  | 1
 | 2009-03-31 00:00:00 |  |  | 2 |  |  | 2 |  | 4
 | 2009-04-01 00:00:00 |  | 1 |  |  |  |  |  | 1
 | 2009-04-08 00:00:00 |  | 2 |  |  |  |  |  | 2
 | 2009-04-09 00:00:00 |  |  | 2 |  |  |  |  | 2
 | 2009-04-20 00:00:00 |  |  |  | 1 |  | 2 |  | 3
 | 2009-04-24 00:00:00 |  |  |  |  |  | 2 |  | 2
 | 2009-05-05 00:00:00 | 2 | 2 | 1 |  |  | 2 | 1 | 8
 | 2009-05-11 00:00:00 |  |  |  | 2 |  | 2 |  | 4
 | 2009-05-19 00:00:00 | 1 |  |  | 2 |  | 3 |  | 6
 | 2009-05-26 00:00:00 |  |  |  |  |  | 2 |  | 2
 | 2009-05-27 00:00:00 |  | 1 |  |  |  |  |  | 1
 | 2009-06-02 00:00:00 | 1 |  |  |  |  | 3 |  | 4
 | 2009-06-03 00:00:00 |  | 1 |  |  |  |  |  | 1
 | 2009-06-09 00:00:00 |  |  |  |  |  | 5 |  | 5
 | 2009-06-12 00:00:00 |  |  |  | 2 |  |  |  | 2
 | 2009-06-15 00:00:00 |  | 2 |  |  |  | 4 |  | 6
 | 2009-06-23 00:00:00 |  |  |  |  |  | 3 |  | 3
 | 2009-06-30 00:00:00 |  |  |  |  |  | 2 |  | 2
 | 2009-07-07 00:00:00 |  |  |  |  |  | 4 |  | 4
 | 2009-07-14 00:00:00 |  |  | 2 |  |  | 1 |  | 3
 | 2009-07-20 00:00:00 |  | 1 |  |  |  | 4 |  | 5
 | 2009-07-27 00:00:00 |  | 1 |  |  |  |  |  | 1
 | 2009-07-28 00:00:00 |  |  |  |  |  | 2 |  | 2
 | 2009-08-04 00:00:00 | 1 |  | 1 |  |  | 4 |  | 6
 | 2009-08-07 00:00:00 |  |  |  |  |  | 4 |  | 4
 | 2009-08-18 00:00:00 |  |  |  |  |  | 3 | 1 | 4
 | 2009-08-25 00:00:00 |  |  |  |  |  | 5 |  | 5
 | 2009-09-01 00:00:00 |  |  | 2 |  |  | 5 |  | 7
 | 2009-09-08 00:00:00 |  | 2 |  |  |  | 2 |  | 4
 | 2009-09-15 00:00:00 |  |  |  |  |  | 1 |  | 1
 | 2009-09-16 00:00:00 |  |  |  |  |  | 2 |  | 2
 | 2009-09-22 00:00:00 |  | 2 | 1 |  |  | 6 |  | 9
 | 2009-09-29 00:00:00 | 1 |  | 4 |  |  | 1 |  | 6
 | 2009-10-05 00:00:00 |  |  |  |  |  | 4 |  | 4
 | 2009-10-06 00:00:00 |  | 1 | 1 |  |  |  |  | 2
 | 2009-10-12 00:00:00 |  |  |  |  |  | 3 |  | 3
 | 2009-10-13 00:00:00 |  |  |  |  |  | 1 |  | 1
 | 2009-10-20 00:00:00 |  |  |  |  |  | 1 |  | 1
 | 2009-10-27 00:00:00 |  | 3 | 1 |  |  | 3 |  | 7
SUB-ASSEMBLIES Total |  | 11 | 25 | 24 | 12 |  | 112 | 3 | 187
Grand Total |  | 24 | 45 | 57 | 20 | 3 | 159 | 18 | 326