####################### Meta Data Part ############################# Column Name Data Type Description Label Validation Text Unit 1 EXPEDITION Numeric expedition number Expedition Number # # 2 SITE Numeric "site number, integer" Site Number # # 3 HOLE Text "code for hole, one character (A_Z)" Hole # # 4 REPORT_DATE Date date of report Report Date report date is a required value <>0 # 5 REPORT_NUMBER Integer number of report for selected date Report Number report number is a required value between 1 and 5 # 6 SHIFT_COUNT Integer number of shifts per 24 hours Shift Count required integer value >0 # 7 SHIFT_FROM Integer starting shift of report Shift From required integer value >0 # 8 SHIFT_TO Integer ending shift of report Shift To required integer value >0 # 9 TIME_START Text starting time of report Begin text string of max. 10 chararcters hh:mm 10 TIME_END Text ending time of report End text string of max. 10 chararcters hh:mm 11 START_DEPTH Double measured starting depth of report Start Depth required real value m 12 END_DEPTH Double measured ending depth of report End Depth required real value m 13 DRILLED_LENGTH Double drilled length (calculated) Drilled Length real value >=0 m 14 TRUE_START_DEPTH Double start true vertical depth Start True Vertical Depth real value m 15 TRUE_END_DEPTH Double end true vetical depth End True Vertical Depth real value m 16 TRUE_DRILLED_LENGTH Double true vertical drilled length (calculated) True Vertical Drilled Length real value >=0 m 17 DRIFT Double vertical drift of hole Drift real value between 0 and 90 degrees 18 AZIMUTH Double horizontal drift of hole Azimuth real value between 0 and 360 degrees 19 DAYS_CORING Integer days of coring Days Coring integer value >=0 # 20 CORE_RECOVERY Double core recovery of report Core Recovery real value >=0 m 21 MAIN_ACTIVITY Text main activity Main Activity text string of max. 30 chararcters # 22 TOTAL_CORE_RECOVERY Double total core recovery of hole Total Core Recovery real value >=0 # 23 DRILLING_ENGINEER Text drilling engineer Drilling Engineer text string of max. 50 chararcters # 24 CONTROLLING_ENGINEER Text controlling engineer Controlling Engineer text string of max. 50 chararcters # 25 DRILLING_METHOD Text drilling method Drilling Method text string of max. 50 chararcters # ####################### Data Part ############################# EXPEDITION SITE HOLE REPORT_DATE REPORT_NUMBER SHIFT_COUNT SHIFT_FROM SHIFT_TO TIME_START TIME_END START_DEPTH END_DEPTH DRILLED_LENGTH TRUE_START_DEPTH TRUE_END_DEPTH TRUE_DRILLED_LENGTH DRIFT AZIMUTH DAYS_CORING CORE_RECOVERY MAIN_ACTIVITY TOTAL_CORE_RECOVERY DRILLING_ENGINEER CONTROLLING_ENGINEER DRILLING_METHOD 5056 1 A 28-Jun-2015 1 1 1 1 07:00 19:00 0 0 0 0 0 0 0 0 0 0 rig up 0 Rich Szentmiklosi Beau Marshall hydraulic piston coring 5056 1 A 29-Jun-2015 1 1 1 1 07:00 19:00 0 0 0 0 0 0 0 0 0 0 rig up 0 Rich Szentmiklosi Beau Marshall hydraulic piston coring 5056 1 A 30-Jun-2015 1 1 1 1 07:00 19:00 0 0 0 0 0 0 0 0 0 0 rig up 0 Rich Szentmiklosi Beau Marshall hydraulic piston coring 5056 1 A 01-Jul-2015 1 1 1 1 07:00 19:00 0 0 0 0 0 0 0 0 0 0 rig up 0 Rich Szentmiklosi Beau Marshall hydraulic piston coring 5056 1 A 02-Jul-2015 1 1 1 1 07:00 19:00 0 0 0 0 0 0 0 0 0 0 rig up 0 Rich Szentmiklosi Beau Marshall hydraulic piston coring 5056 1 A 03-Jul-2015 1 1 1 1 07:00 19:00 0 0 0 0 0 0 0 0 0 0 rig up 0 Rich Szentmiklosi Beau Marshall hydraulic piston coring 5056 1 A 04-Jul-2015 1 1 1 1 07:00 19:00 0 0 0 0 0 0 0 0 0 0 rig up 0 Rich Szentmiklosi Beau Marshall hydraulic piston coring 5056 1 A 05-Jul-2015 1 1 1 1 07:00 19:00 0 0 0 0 0 0 0 0 0 0 rig up 0 Rich Szentmiklosi Beau Marshall hydraulic piston coring 5056 1 A 06-Jul-2015 1 1 1 1 07:00 19:00 0 0 0 0 0 0 0 0 0 0 rig up 0 Rich Szentmiklosi Beau Marshall hydraulic piston coring 5056 1 A 07-Jul-2015 1 1 1 1 07:00 19:00 0 0 0 0 0 0 0 0 0 0 rig up 0 Rich Szentmiklosi Beau Marshall hydraulic piston coring 5056 1 A 08-Jul-2015 1 1 1 1 07:00 19:00 0 0 0 0 0 0 0 0 0 0 rig up 0 Rich Szentmiklosi Beau Marshall hydraulic piston coring 5056 1 A 09-Jul-2015 1 1 1 1 07:00 19:00 0 0 0 0 0 0 0 0 0 0 rig up 0 Rich Szentmiklosi Beau Marshall hydraulic piston coring 5056 1 A 10-Jul-2015 1 1 1 1 07:00 19:00 0 0 0 0 0 0 0 0 0 0 rig up 0 Rich Szentmiklosi Beau Marshall hydraulic piston coring 5056 1 A 11-Jul-2015 1 1 1 1 07:00 19:00 0 0 0 0 0 0 0 0 0 0 rig up 0 Rich Szentmiklosi Beau Marshall hydraulic piston coring 5056 1 A 12-Jul-2015 1 1 1 1 07:00 19:00 0 0 0 0 0 0 0 0 0 0 rig up 0 "Rich Szentmiklosi, Jess Valeda" Beau Marshall hydraulic piston coring 5056 1 A 13-Jul-2015 1 1 1 1 07:00 19:00 0 0 0 0 0 0 0 0 0 0 rig up 0 "Rich Szentmiklosi, Jess Valeda" Beau Marshall hydraulic piston coring 5056 1 A 14-Jul-2015 1 1 1 1 07:00 19:00 0 0 0 0 0 0 0 0 0 0 rig up 0 "Rich Szentmiklosi, Jess Valeda" Beau Marshall hydraulic piston coring 5056 1 A 15-Jul-2015 1 1 1 1 07:00 19:00 0 0 0 0 0 0 0 0 0 0 rig up 0 "Rich Szentmiklosi, Jess Valeda" Beau Marshall hydraulic piston coring 5056 1 A 16-Jul-2015 1 1 1 1 07:00 19:00 0 0 0 0 0 0 0 0 0 0 rig up 0 "Rich Szentmiklosi, Jess Valeda" Beau Marshall hydraulic piston coring 5056 1 A 17-Jul-2015 1 1 1 1 07:00 19:00 0 0 0 0 0 0 0 0 0 0 rig up 0 "Rich Szentmiklosi, Jess Valeda" Beau Marshall hydraulic piston coring 5056 1 A 18-Jul-2015 1 1 1 1 07:00 19:00 0 0 0 0 0 0 0 0 0 0 rig up 0 "Rich Szentmiklosi, Jess Valeda" Beau Marshall hydraulic piston coring 5056 1 A 19-Jul-2015 1 1 1 1 07:00 19:00 0 0 0 0 0 0 0 0 0 0 rig up 0 "Rich Szentmiklosi, Jess Valeda" Beau Marshall hydraulic piston coring 5056 1 A 20-Jul-2015 1 1 1 1 07:00 19:00 0 0 0 0 0 0 0 0 0 0 rig up 0 "Rich Szentmiklosi, Jess Valeda" Beau Marshall hydraulic piston coring 5056 1 A 21-Jul-2015 1 1 1 1 12:00 19:30 0 0 0 0 0 0 0 0 0 0 rig up 0 Jess Valeda Beau Marshall hydraulic piston coring 5056 1 A 22-Jul-2015 1 1 1 1 08:30 20:20 0 0 0 0 0 0 0 0 0 0 rig up 0 "Jess Valeda, Steve Cole" Beau Marshall hydraulic piston coring 5056 1 A 23-Jul-2015 1 1 1 1 00:00 19:45 0 0 0 0 0 0 0 0 0 0 rig up 0 "Jess Valeda, Steve Cole" Beau Marshall hydraulic piston coring 5056 1 A 24-Jul-2015 1 1 1 1 07:30 19:30 0 0 0 0 0 0 0 0 0 0 rig up 0 "Jess Valeda, Steve Cole" Beau Marshall hydraulic piston coring 5056 1 A 25-Jul-2015 1 1 1 1 07:30 20:30 0 0 0 0 0 0 0 0 0 0 rig up 0 "Jess Valeda, Steve Cole" Beau Marshall hydraulic piston coring 5056 1 A 26-Jul-2015 1 1 1 1 07:30 20:15 0 0 0 0 0 0 0 0 0 0 rig up 0 "Jess Valeda, Steve Cole" Beau Marshall hydraulic piston coring 5056 1 A 27-Jul-2015 1 1 1 1 07:30 18:30 0 0 0 0 0 0 0 0 0 0 rig up 0 "Jess Valeda, Steve Cole" Beau Marshall hydraulic piston coring 5056 1 A 28-Jul-2015 1 1 1 1 08:00 20:00 0 0 0 0 0 0 0 0 0 0 rig up 0 "Jess Valeda, Steve Cole" Beau Marshall hydraulic piston coring 5056 1 A 29-Jul-2015 1 1 1 1 07:45 20:00 0 0 0 0 0 0 0 0 0 0 rig up 0 "Jess Valeda, Steve Cole" Beau Marshall hydraulic piston coring 5056 1 A 30-Jul-2015 1 2 1 1 06:00 18:00 10.48 13.48 3 0 0 0 0 0 1 0 spud in 0 "Jess Valeda, Steve Cole" Valeda hydraulic piston coring 5056 1 A 30-Jul-2015 2 2 2 2 18:00 06:00 13.48 34.48 21 0 0 0 0 0 1 17.37 coring 17.37 "Jess Valeda, Steve Cole" Valeda hydraulic piston coring 5056 1 A 31-Jul-2015 1 1 1 1 06:00 18:00 34.48 73.48 39 0 0 0 0 0 2 27.61 coring 44.98 Geotec Cole hydraulic piston coring 5056 1 A 31-Jul-2015 2 2 2 2 18:00 06:00 73.48 97.48 24 0 0 0 0 0 2 19 coring 63.98 Geotec Valeda hydraulic piston coring 5056 1 A 01-Aug-2015 1 2 1 1 06:00 18:00 97.48 109.48 12 0 0 0 0 0 3 6.46 coring 70.44 Geotec Cole hydraulic piston coring 5056 1 A 01-Aug-2015 2 2 2 2 18:00 06:00 109.48 115.28 5.8 0 0 0 0 0 3 2.56 coring 73 Geotec Cole hydraulic piston coring 5056 1 A 02-Aug-2015 1 2 1 1 06:00 18:00 115.28 115.28 0 0 0 0 0 0 3 0 logging 73 Geotec Cole hydraulic piston coring 5056 1 A 02-Aug-2015 2 2 2 2 18:00 06:00 115.28 115.28 0 0 0 0 0 0 3 0 rig service 73 Geotec Valeda hydraulic piston coring 5056 1 B 03-Aug-2015 1 2 1 1 06:00 18:00 11.48 44.48 33 0 0 0 0 0 1 32.36 coring 32.36 Geotec Cole 5056 1 B 03-Aug-2015 2 2 2 2 06:00 21:30 44.48 44.48 0 0 0 0 0 0 1 0 coring 32.36 Geotec Valeda hydraulic piston coring 5056 1 C 03-Aug-2015 3 2 1 1 21:30 06:00 12.48 39.48 27 0 0 0 0 0 1 26.96 coring 26.96 Geotec Valeda hydraulic piston coring 5056 1 C 04-Aug-2015 1 2 1 1 06:00 18:00 39.48 84.48 45 0 0 0 0 0 2 43.44 coring 70.4 Geotec Cole hydraulic piston coring 5056 1 C 04-Aug-2015 2 2 2 2 18:00 06:00 84.48 105.48 21 0 0 0 0 0 2 16.03 coring 86.43 Geotec Valeda hydraulic piston coring 5056 1 C 05-Aug-2015 1 2 1 1 06:00 18:00 105.48 105.48 0 0 0 0 0 0 2 0 logging 86.43 Geotec Cole hydraulic piston coring 5056 1 C 05-Aug-2015 2 2 2 2 18:00 06:00 105.48 105.48 0 logging 86.43 Geotec Cole hydraulic piston coring 5056 1 D 05-Aug-2015 2 2 2 2 18:00 06:00 12.58 42.58 30 0 0 0 0 0 1 29.23 coring 29.23 Geotec Valeda hydraulic piston coring 5056 1 D 06-Aug-2015 1 2 1 1 06:00 18:00 40.48 76.48 36 0 0 0 0 0 2 35 coring 64.23 Geotec Cole hydraulic piston coring 5056 1 D 06-Aug-2015 2 2 2 2 18:00 06:00 76.48 120.48 44 0 0 0 0 0 2 25.1 coring 89.33 Geotec Valeda hydraulic piston coring 5056 1 D 07-Aug-2015 1 2 1 1 06:00 18:00 120.48 120.48 0 0 0 0 0 0 2 0 logging 89.33 Geotec Cole hydraulic piston coring 5056 1 D 07-Aug-2015 2 2 2 2 18:00 06:00 120.48 120.48 0 0 0 0 0 0 2 0 logging 89.33 Geotec Valeda hydraulic piston coring 5056 1 E 08-Aug-2015 1 2 1 1 06:00 18:00 37.48 59.48 22 0 0 0 0 0 1 19.55 coring 19.55 Geotec Cole hydraulic piston coring 5056 1 E 08-Aug-2015 2 2 2 2 18:00 06:00 59.48 59.48 0 0 0 0 0 0 1 0 stand by 19.55 Geotec Valeda hydraulic piston coring 5056 1 E 09-Aug-2015 1 2 1 1 06:00 18:00 59.48 59.48 0 0 0 0 0 0 1 0 stand by 19.55 Geotec Valeda hydraulic piston coring 5056 1 E 09-Aug-2015 2 2 2 2 18:00 06:00 59.48 59.48 0 0 0 0 0 0 1 0 stand by 19.55 Geotec Valeda hydraulic piston coring 5056 1 E 10-Aug-2015 1 2 1 1 06:00 18:00 59.48 59.48 0 0 0 0 0 0 2 stand by 19.55 Geotec Valeda hydraulic piston coring 5056 1 E 10-Aug-2015 2 2 2 2 18:00 06:00 59.48 86.46 26.98 0 0 0 0 0 2 23.67 coring 43.22 Geotec Cole hydraulic piston coring 5056 1 E 11-Aug-2015 1 2 1 1 06:00 09:00 86.46 86.46 0 0 0 0 0 0 2 0 rig down 43.22 Geotec Cole hydraulic piston coring 5056 2 A 11-Aug-2015 1 2 1 1 09:00 18:00 6.1 27.1 21 0 0 0 0 0 1 17.13 coring 17.13 Geotec Cole hydraulic piston coring 5056 2 A 11-Aug-2015 2 2 2 2 18:00 23:34 27.1 30.1 3 0 0 0 0 0 1 0.91 coring 18.04 Geotec Cole hydraulic piston coring 5056 2 B 11-Aug-2015 2 2 2 2 23:34 06:00 7.9 34.9 27 0 0 0 0 0 1 20.1 coring 20.1 Geotec Cole hydraulic piston coring 5056 2 B 12-Aug-2015 1 2 1 1 06:00 11:00 34.9 34.9 0 0 0 0 0 0 1 0 logging 20.1 Geotec Cole hydraulic piston coring 5056 2 C 12-Aug-2015 1 2 1 1 11:00 18:00 5.48 14.48 9 0 0 0 0 0 1 5.595 coring 5.595 Geotec Cole hydraulic piston coring 5056 2 C 12-Aug-2015 2 2 2 2 18:00 06:00 14.48 14.48 0 0 0 0 0 0 1 0 stand by 5.595 Geotec Valeda hydraulic piston coring 5056 2 C 13-Aug-2015 1 2 1 1 06:00 09:30 14.48 14.48 0 0 0 0 0 0 1 0 rig up 5.595 Geotec Cole hydraulic piston coring 5056 3 A 13-Aug-2015 1 2 1 1 09:30 18:00 7.4 37.2 29.8 0 0 0 0 0 1 23.89 coring 23.89 Geotec Cole hydraulic piston coring 5056 3 A 13-Aug-2015 2 2 2 2 18:00 20:00 37.2 37.2 0 0 0 0 0 0 1 0 rig up 23.89 Geotec Valeda hydraulic piston coring 5056 3 B 13-Aug-2015 2 2 2 2 20:00 06:00 8.48 47.48 39 0 0 0 0 0 1 30.23 coring 30.23 Geotec Valeda hydraulic piston coring 5056 3 B 14-Aug-2015 1 2 1 1 06:00 18:00 47.48 58.52 11.04 0 0 0 0 0 2 9.16 coring 39.39 Geotec Cole hydraulic piston coring 5056 3 B 14-Aug-2015 2 2 2 2 18:00 01:15 58.52 58.52 0 0 0 0 0 0 2 0 logging 39.39 Geotec Valeda hydraulic piston coring 5056 3 C 14-Aug-2015 2 2 2 2 01:15 06:00 40.48 46.48 6 0 0 0 0 0 1 2.95 coring 2.95 Geotec Valeda hydraulic piston coring 5056 3 C 15-Aug-2015 1 2 1 1 06:00 18:00 46.48 58.1 11.62 0 0 0 0 0 2 10.95 coring 13.9 Geotec Valeda hydraulic piston coring 5056 3 C 15-Aug-2015 2 2 2 2 18:00 06:00 58.1 58.1 0 0 0 0 0 0 1 0 stand by 13.9 Geotec Valeda hydraulic piston coring 5056 3 C 16-Aug-2015 1 1 1 1 09:00 19:45 0 0 0 0 0 0 0 0 0 0 rig down 13.9 "Geotec, Valeda, Cole" Valeda hydraulic piston coring 5056 3 C 17-Aug-2015 1 1 1 1 08:00 16:30 0 0 0 0 0 0 0 0 0 0 rig down 13.9 "Geotec, Valeda, Cole" Valeda hydraulic piston coring