Spreadsheet: 330797d1404853801-combining-a-if-function-and-lookup-function-irtest
Sheet: video

Reference No. | Project No | Project Name | Client | [NAME]. | Location Discription | Thermal/ IRVideo | Internal/External | Download No. | IR Number | Paired [NAME] | Date | Duration | Finish Time | Start time | [NAME] ([NAME]) | [NAME] (GB) | Analysed | Ecologist | Analyst | Date required | Date downloaded | Notes | Date time
38 | 494 days, 0:00:00 | unit 1 |  | L07 | Inside Crook barn | Infrared Video | Internal | D008 | IR0038 |  | 2014-05-14 00:00:00 | 00:51:00 | 20:32:00 | 19:41:00 | 2073094 | 1.98 |  |  |  |  |  |  | 2014-05-14 19:41:00 | 2014-05-14 20:32:00 | 1
39 | 494 days, 0:00:00 | unit 2 |  | L07 | Inside Crook barn | Infrared Video | Internal | D008 | IR0039 |  | 2014-05-14 00:00:00 | 00:39:20 | 21:11:00 | 20:31:40 | 1504730 | 1.44 |  |  |  |  |  |  | 2014-05-14 20:31:40 | 2014-05-14 21:11:00 | 2
40 | 494 days, 0:00:00 | unit 3 |  | L08 | Inside L shaped barn | Infrared Video | Internal | D009 | IR0040 |  | 2014-06-05 00:00:00 | 00:50:36 | 03:56:00 | 03:05:24 | 2069976 | 1.97 |  |  |  |  |  |  | 2014-06-05 03:05:24 | 2014-06-05 03:56:00 | 3
41 | 494 days, 0:00:00 | unit 4 |  | L08 | Inside L shaped barn | Infrared Video | Internal | D009 | IR0041 |  | 2014-06-05 00:00:00 | 00:50:34 | 04:46:00 | 03:55:26 | 2070822 | 1.97 |  |  |  |  |  |  | 2014-06-05 03:55:26 | 2014-06-05 04:46:00 | 4
42 | 494 days, 0:00:00 | unit 5 |  | L08 | Inside L shaped barn | Infrared Video | Internal | D009 | IR0042 |  | 2014-06-05 00:00:00 | 00:00:23 | 04:47:00 | 04:46:37 | 16898 | 0.02 |  |  |  |  |  |  | 2014-06-05 04:46:37 | 2014-06-05 04:47:00 | 5
43 | 494 days, 0:00:00 | unit 6 |  | L09 | Inside L shaped barn | Infrared Video | Internal | D010 | IR0043 |  | 2014-06-12 00:00:00 | 00:29:24 | 21:46:00 | 21:16:36 | 2069270 | 1.97 |  |  |  |  |  |  | 2014-06-12 21:16:36 | 2014-06-12 21:46:00 | 6
44 | 494 days, 0:00:00 | unit 7 |  | L09 | Inside L shaped barn | Infrared Video | Internal | D010 | IR0044 |  | 2014-06-12 00:00:00 | 00:29:22 | 22:15:00 | 21:45:38 | 2070896 | 1.97 |  |  |  |  |  |  | 2014-06-12 21:45:38 | 2014-06-12 22:15:00 | 7
45 | 494 days, 0:00:00 | unit 8 |  | L09 | Inside L shaped barn | Infrared Video | Internal | D010 | IR0045 |  | 2014-06-12 00:00:00 | 00:29:22 | 22:44:00 | 22:14:38 | 2070896 | 1.97 |  |  |  |  |  |  | 2014-06-12 22:14:38 | 2014-06-12 22:44:00 | 8
46 | 494 days, 0:00:00 | unit 9 |  | L09 | Inside L shaped barn | Infrared Video | Internal | D010 | IR0046 |  | 2014-06-12 00:00:00 | 00:29:22 | 22:51:00 | 22:21:38 | 449514 | 0.43 |  |  |  |  |  |  | 2014-06-12 22:21:38 | 2014-06-12 22:51:00 | 9
47 | 494 days, 0:00:00 | unit 10 |  | L09 | Inside L shaped barn | Infrared Video | Internal | D011 | IR0047 |  | 2014-06-13 00:00:00 | 00:29:24 | 03:36:00 | 03:06:36 | 2069778 | 1.97 |  |  |  |  |  |  | 2014-06-13 03:06:36 | 2014-06-13 03:36:00 | 10
48 | 494 days, 0:00:00 | unit 11 |  | L09 | Inside L shaped barn | Infrared Video | Internal | D011 | IR0048 |  | 2014-06-13 00:00:00 | 00:29:22 | 04:06:00 | 03:36:38 | 2070986 | 1.98 |  |  |  |  |  |  | 2014-06-13 03:36:38 | 2014-06-13 04:06:00 | 11
49 | 494 days, 0:00:00 | unit 12 |  | L09 | Inside L shaped barn | Infrared Video | Internal | D011 | IR0049 |  | 2014-06-13 00:00:00 | 00:26:06 | 04:32:00 | 04:05:54 | 1840836 | 1.76 |  |  |  |  |  |  | 2014-06-13 04:05:54 | 2014-06-13 04:32:00 | 12