Spreadsheet: 105025d1302520842-automated-vlookup-from-csv-vm_licenseslog
Sheet: Sheet1

Date | Time | Total | CS_Crest_TestDefect | ICT_NWISC_TestDefect | ESBI_GB_Trading | ICT_SCC_TestDefect | PMO_TestDefect | ESBIE_ISC | ESBIE_SCC | NITA_TestDefect | Training_TestDefect | MOIP_Live_ReadOnly | ICT_R3_Upgrade_Test | PG_Gas_TestDefect
2011-03-07 00:00:00 | 17:40:00 | 13 | 6 | 3 | 4
2011-03-08 00:00:00 | 10:00:00 | 42 | 29 | 9 | 1 | 3
 | 11:00:00 | 33 | 21 | 8 | 2 | 1 |  |  | 1
 | 12:00:00 | 43 | 24 | 10 | 1 | 5 | 2 |  | 1
 | 14:00:00 | 29 | 21 | 5 | 1 | 1 |  |  | 1
 | 15:00:00 | 50 | 33 | 6 | 3 | 5 | 1 |  | 1 |  | 1
 | 16:00:00 | 43 | 25 | 11 | 1 | 4 | 1 | 1
 | 17:00:00 | 34 | 19 | 8 | 2 | 2 | 1 |  |  |  | 2
 | 18:00:00 | 10 | 6 | 3 |  | 1
2011-03-09 00:00:00 | 10:00:00 | 30 | 13 | 10 | 1 | 5 | 1
 | 11:00:00 | 33 | 21 | 8 | 2 | 1 |  |  | 1
 | 12:00:00 | 43 | 30 | 8 | 1 | 3 |  | 1
 | 14:00:00 | 34 | 26 | 6 | 2
 | 15:00:00 | 50 | 31 | 9 | 3 | 4 | 2 |  |  |  | 1
 | 16:00:00 | 44 | 29 | 8 | 3 | 4
 | 17:00:00 | 31 | 16 | 6 | 3 | 4 | 2
2011-03-10 00:00:00 | 10:00:00 | 37 | 23 | 6 | 5 | 3
 | 11:00:00 | 48 | 32 | 6 | 4 | 4 | 1 |  |  |  | 1
 | 12:00:00 | 46 | 26 | 7 | 5 | 4 | 4
 | 14:00:00 | 33 | 23 | 4 | 4 | 2
 | 15:00:00 | 49 | 32 | 6 | 5 | 3 | 1 |  |  |  | 1 | 1
 | 16:00:00 | 39 | 26 | 3 | 4 | 4 |  |  |  |  |  | 2
 | 17:00:00 | 30 | 16 | 5 | 3 | 4 | 1 |  |  |  |  | 1
2011-03-11 00:00:00 | 10:00:00 | 32 | 18 | 3 | 6 | 4 |  |  |  |  |  | 1
 | 11:00:00 | 30 | 21 | 6 | 3
 | 12:00:00 | 49 | 31 | 6 | 5 | 5 | 2
 | 14:00:00 | 41 | 28 | 4 | 3 | 4 | 1 |  |  |  |  | 1
 | 15:00:00 | 38 | 26 | 5 | 5 | 2
 | 16:00:00 | 35 | 24 | 2 | 6 | 3
 | 17:00:00 | 20 | 11 | 1 | 2 | 6
2011-03-14 00:00:00 | 10:00:00 | 40 | 27 | 7 | 3 | 2 | 1
 | 11:00:00 | 37 | 24 | 5 | 4 | 2 | 2
 | 12:00:00 | 45 | 29 | 5 | 4 | 2 | 4 | 1
 | 14:00:00 | 42 | 29 | 7 | 2 | 1 | 2 |  |  |  |  |  | 1
 | 15:00:00 | 48 | 32 | 7 | 1 | 5 | 2 | 1
 | 16:00:00 | 39 | 28 | 5 | 3 | 3
 | 17:00:00 | 30 | 16 | 5 | 3 | 4 | 1 |  |  |  |  | 1
2011-03-15 00:00:00 | 10:00:00 | 45 | 25 | 6 | 6 | 5 | 3
 | 11:00:00 | 46 | 26 | 7 | 5 | 6 | 2
 | 12:00:00 | 49 | 27 | 4 | 10 | 7 | 1
 | 14:00:00 | 41 | 28 | 4 | 3 | 4 | 1 |  |  |  |  | 1
 | 15:00:00 | 38 | 26 | 5 | 5 | 2
 | 16:00:00 | 39 | 28 | 5 | 3 | 3
 | 17:00:00 | 20 | 11 | 1 | 2 | 6
2011-03-16 00:00:00 | 10:00:00 | 30 | 18 | 6 | 4 |  | 1 | 1
 | 11:00:00 | 31 | 20 | 5 | 5 | 1
 | 12:00:00 | 32 | 22 | 5 | 2 | 3
 | 14:00:00 | 34 | 24 | 4 | 5 | 1
 | 15:00:00 | 28 | 20 | 2 | 3 | 2 | 1
 | 16:00:00 | 22 | 14 | 4 | 4
 | 17:00:00 | 15 | 9 | 1 | 1 | 4
2011-03-18 00:00:00 | 10:00:00 | 11 | 8 | 1 | 2
 | 11:00:00 | 21 | 17 | 1 | 2 |  | 1
 | 12:00:00 | 21 | 17 |  | 2 | 1 | 1
 | 14:00:00 | 9 | 8 |  | 1
 | 15:00:00 | 18 | 15 |  | 3
 | 16:00:00 | 17 | 14 |  | 2 | 1
 | 17:00:00 | 8 | 7 |  | 1
2011-03-21 00:00:00 | 08:00:00 | 2 | 1 | 1
 | 09:00:00 | 26 | 16 | 7 | 2 | 1
 | 10:00:00 | 37 | 27 | 5 | 2 | 3
 | 11:00:00 | 31 | 20 | 5 | 5 | 1
 | 12:00:00 | 32 | 22 | 5 | 2 | 3
 | 14:00:00 | 34 | 23 | 6 | 3 | 1 |  | 1
 | 15:00:00 | 28 | 20 | 2 | 3 | 2 | 1
 | 16:00:00 | 29 | 18 | 5 | 3 | 2 |  |  |  |  | 1
 | 17:00:00 | 16 | 9 | 2 | 3 | 2
2011-03-22 00:00:00 | 10:00:00 | 16 | 7 | 5 | 3 | 1
 | 11:00:00 | 31 | 20 | 5 | 5 | 1
 | 12:00:00 | 32 | 22 | 5 | 2 | 3
 | 14:00:00 | 34 | 24 | 4 | 5 | 1
 | 15:00:00 | 28 | 20 | 2 | 3 | 2 | 1
 | 16:00:00 | 22 | 14 | 4 | 4
 | 17:00:00 | 26 | 12 | 5 | 3 | 4 | 1 |  |  |  |  | 1
2011-03-24 00:00:00 | 10:00:00 | 25 | 16 | 4 |  | 3 | 2
 | 11:00:00 | 37 | 18 | 8 | 2 | 5 | 2 | 2
 | 12:00:00 | 31 | 16 | 7 | 3 | 3 | 2
 | 14:00:00 | 26 | 17 | 4 | 2 | 2 |  | 1
 | 15:00:00 | 34 | 19 | 7 |  | 6 | 2
 | 16:00:00 | 31 | 19 | 6 | 1 | 3 | 2
 | 17:00:00 | 18 | 8 | 3 | 2 | 3 | 2
2011-03-25 00:00:00 | 10:00:00 | 21 | 9 | 7 | 3 |  | 1 | 1
 | 11:00:00 | 22 | 14 | 5 | 1 | 2
 | 12:00:00 | 36 | 17 | 7 | 2 | 6 | 2 | 1 |  |  |  |  |  | 1
 | 14:00:00 | 26 | 16 | 3 | 2 | 2 | 1 | 2
 | 15:00:00 | 32 | 16 | 6 |  | 5 | 3 | 2
 | 16:00:00 | 36 | 21 | 5 |  | 6 | 2 | 2
 | 17:00:00 | 25 | 17 |  | 1 | 6 |  | 1
2011-03-28 00:00:00 | 10:00:00 | 33 | 17 | 6 | 2 | 4 | 4
 | 11:00:00 | 20 | 9 | 8 |  | 1 |  | 2
 | 12:00:00 | 27 | 16 | 8 | 1 | 2
 | 14:00:00 | 25 | 11 | 9 | 2 | 3
 | 15:00:00 | 22 | 11 | 4 | 3 | 4
 | 16:00:00 | 27 | 11 | 6 | 3 | 4 | 3
 | 17:00:00 | 21 | 9 | 4 | 2 | 6
2011-03-29 00:00:00 | 10:00:00 | 29 | 14 | 8 |  | 6 | 1
 | 11:00:00 | 22 | 10 | 8 |  | 3 | 1
 | 12:00:00 | 28 | 15 | 4 | 1 | 8
 | 14:00:00 | 27 | 13 | 6 | 1 | 6 |  |  |  |  | 1
 | 15:00:00 | 30 | 19 | 6 | 2 | 3
 | 16:00:00 | 23 | 9 | 8 | 2 | 4
 | 17:00:00 | 21 | 8 | 7 | 1 | 3 | 2
2011-03-30 00:00:00 | 10:00:00 | 19 | 9 | 7 | 1 | 1 | 1
 | 11:00:00 | 17 | 10 | 4 | 1 | 2
 | 12:00:00 | 25 | 15 | 4 |  | 6
 | 14:00:00 | 12 | 5 | 5 | 1 | 1
 | 15:00:00 | 25 | 12 | 6 |  | 5 | 1 | 1
 | 16:00:00 | 26 | 14 | 8 | 1 | 2 | 1
 | 17:00:00 | 15 | 6 | 3 | 1 | 2 | 3
2011-03-31 00:00:00 | 08:00:00 | 3 | 2 | 1
 | 09:00:00 | 7 | 4 | 2 | 1
 | 10:00:00 | 25 | 14 | 6 | 2 | 3
 | 11:00:00 | 17 | 9 | 3 | 2 | 3
 | 12:00:00 | 22 | 10 | 4 |  | 6 | 2
 | 13:00:00 | 17 | 6 | 2 |  | 4 | 4 |  |  |  |  | 1
 | 14:00:00 | 17 | 10 | 6 |  |  | 1
 | 15:00:00 | 19 | 11 | 3 |  | 4 | 1
 | 16:00:00 | 23 | 12 | 3 | 1 | 6 | 1
 | 17:00:00 | 11 | 3 | 4 | 1 | 2 | 1
2011-04-01 00:00:00 | 08:00:00 | 1 | 1
 | 09:00:00 | 7 | 1 | 4 |  | 2
 | 10:00:00 | 15 | 6 | 5 |  | 4
 | 11:00:00 | 14 | 6 | 6 |  | 2
 | 12:00:00 | 28 | 11 | 4 | 2 | 9 | 1 | 1
 | 13:00:00 | 18 | 6 | 2 | 1 | 8 |  | 1
 | 14:00:00 | 14 | 5 | 3 | 1 | 4 |  | 1
 | 15:00:00 | 30 | 12 | 7 | 2 | 7 | 1 | 1
 | 16:00:00 | 17 | 6 | 5 | 1 | 3 | 1 | 1
 | 17:00:00 | 12 | 4 | 3 | 1 | 2 | 1 | 1
2011-04-04 00:00:00 | 08:00:00 | 1 |  | 1
 | 09:00:00 | 5 | 1 | 2 | 1 | 1
 | 10:00:00 | 9 | 1 | 2 | 2 | 3 |  | 1
 | 11:00:00 | 19 | 3 | 4 | 3 | 6 | 1 | 2
 | 12:00:00 | 32 | 8 | 11 | 2 | 6 | 2 | 1 |  | 1 |  |  |  | 1
 | 13:00:00 | 21 | 7 | 9 | 1 | 3 | 1
 | 14:00:00 | 11 | 3 | 5 | 1 | 1 |  | 1
 | 15:00:00 | 24 | 9 | 8 |  | 5 | 2
 | 16:00:00 | 28 | 8 | 10 | 2 | 7 | 1
 | 17:00:00 | 22 | 4 | 10 | 2 | 4 | 1 | 1
2011-04-05 00:00:00 | 08:00:00 | 3 |  | 1 |  | 2
 | 09:00:00 | 10 |  | 7 | 1 | 1 | 1
 | 10:00:00 | 21 | 5 | 9 | 3 | 4
 | 11:00:00 | 22 | 5 | 11 | 2 | 3 | 1
 | 12:00:00 | 32 | 9 | 11 | 4 | 7 | 1
 | 13:00:00 | 23 | 5 | 8 | 3 | 2 | 4 | 1
 | 14:00:00 | 13 | 4 | 4 | 2 | 2 |  | 1
 | 15:00:00 | 27 | 7 | 11 | 3 | 5 | 1
 | 16:00:00 | 33 | 11 | 11 | 3 | 5 | 3
 | 17:00:00 | 26 | 10 | 7 | 4 | 3 | 2
2011-04-06 00:00:00 | 08:00:00 | 3 | 1 |  |  | 2
 | 09:00:00 | 12 | 2 | 4 | 4 | 1 | 1
 | 10:00:00 | 23 | 6 | 10 | 4 | 1 | 1 | 1
 | 11:00:00 | 21 | 7 | 10 | 2 | 1 | 1
 | 12:00:00 | 21 | 7 | 10 |  | 4
 | 13:00:00 | 18 | 5 | 12 |  | 1
 | 14:00:00 | 12 | 4 | 7 |  |  | 1
 | 15:00:00 | 18 | 5 | 9 | 1 | 2 | 1
 | 16:00:00 | 22 | 9 | 9 |  | 3 | 1
 | 17:00:00 | 0
2011-04-07 00:00:00 | 08:00:00 | 1 | 1
 | 09:00:00 | 7 | 1 | 4 |  | 2
 | 10:00:00 | 10 | 3 | 3 |  | 2 | 2
 | 11:00:00 | 7 | 2 | 2 |  | 3
 | 12:00:00 | 17 | 5 | 8 |  | 4
 | 13:00:00 | 0
 | 14:00:00 | 9 | 2 | 4 |  | 1 | 2
 | 15:00:00 | 17 | 4 | 10 |  | 1 | 2
 | 16:00:00 | 19 | 8 | 10 |  | 1
 | 17:00:00 | 14 | 5 | 6 |  | 1 | 2
2011-04-08 00:00:00 | 08:00:00 | 0
 | 09:00:00 | 5 | 1 | 3 |  |  | 1
 | 10:00:00 | 15 | 5 | 8 |  |  | 2
 | 11:00:00 | 22 | 7 | 9 | 1 | 2 | 3
 | 12:00:00 | 19 | 7 | 8 | 1 | 3
 | 13:00:00 | 12 | 7 | 3 |  | 2
 | 14:00:00 | 7 | 2 | 2 |  | 2 | 1
 | 15:00:00 | 11 | 4 | 4 |  | 1 | 1 |  |  |  | 1
 | 16:00:00 | 12 | 4 | 4 |  | 1 | 3
 | 17:00:00 | 9 | 4 | 1 | 1 | 3
2011-04-11 00:00:00 | 08:00:00 | 1 |  | 1
 | 09:00:00 | 4 |  | 4
 | 10:00:00 | 8 |  | 5 |  | 2 | 1
 | 11:00:00 | 15 | 3 | 5 |  | 6 | 1
 | 12:00:00 | 0
 | 13:00:00 | 0
 | 14:00:00 | 0
 | 15:00:00 | 0
 | 16:00:00 | 0
 | 17:00:00 | 0
2011-04-12 00:00:00 | 08:00:00 | 0
 | 09:00:00 | 0
 | 10:00:00 | 0
 | 11:00:00 | 0
 | 12:00:00 | 0
 | 13:00:00 | 0
 | 14:00:00 | 0
 | 15:00:00 | 0
 | 16:00:00 | 0
 | 17:00:00 | 0
2011-04-13 00:00:00 | 08:00:00 | 0
 | 09:00:00 | 0
 | 10:00:00 | 0
 | 11:00:00 | 0
 | 12:00:00 | 0
 | 13:00:00 | 0
 | 14:00:00 | 0
 | 15:00:00 | 0
 | 16:00:00 | 0
 | 17:00:00 | 0
2011-04-14 00:00:00 | 08:00:00 | 0
 | 09:00:00 | 0
 | 10:00:00 | 0
 | 11:00:00 | 0
 | 12:00:00 | 0
 | 13:00:00 | 0
 | 14:00:00 | 0
 | 15:00:00 | 0
 | 16:00:00 | 0
 | 17:00:00 | 0
2011-04-15 00:00:00 | 08:00:00 | 0
 | 09:00:00 | 0
 | 10:00:00 | 0
 | 11:00:00 | 0
 | 12:00:00 | 0
 | 13:00:00 | 0
 | 14:00:00 | 0
 | 15:00:00 | 0
 | 16:00:00 | 0
 | 17:00:00 | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0