{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["calculator"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"calculator","index":0,"n_rows":53,"n_cols":16,"rows_kept":53,"cut":false,"hidden":false,"merged":[[4,0,4,8],[5,0,5,8],[6,0,6,8]]}
["Nautical twilight times"]
["CCAMLR Calculator v2018"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Language","Paragraph1","Paragraph2","Paragraph3"]
["About twilight and the calculator",null,"Select a language from the dropdown menu (click on cell) >",null,null,null,"English",null,null,null,null,null,"English","Nautical twilight is defined as the time in the morning and evening when the centre of the sun is 12° below the horizon.At high latitudes, the sun will not be lower than 12° below the horizon for a period in summer, and will not rise above 12° below the horizon for a period in winter.","This calculator provides the times of nautical twilight at a user-defined position, for today and at fortnightly intervals during a selected calendar year. The times of sunrise and sunset are included, and all times are adjusted to reflect the UTC offset of the user's clock.","The calculator is intended for use with CCAMLR's Conservation Measure 25-02 (Minimisation of the incidental mortality of seabirds in the course of longline fishing). In fisheries where this conservation measure applies, longlines must be set at night only (i.e. during the hours of darkness between the times of nautical twilight) and, wherever possible, the setting of lines should be completed at least three hours before sunrise."]
[{"$f":"IF($G$4=\"English\",N$4,IF($G$4=\"French\",N$5,IF($G$4=\"Russian\",N$6,IF($G$4=\"Spanish\",N$7,N$4))))","v":"Nautical twilight is defined as the time in the morning and evening when the centre of the sun is 12° below the horizon.At high latitudes, the sun will not be lower than 12° below the horizon for a period in summer, and will not rise above 12° below the horizon for a period in winter."},null,null,null,null,null,null,null,null,null,null,null,"French","Le crépuscule nautique est défini comme correspondant au moment du matin et du soir où le centre du disque solaire est à 12° au-dessous de l'horizon. Dans les hautes latitudes, à une certaine période de l'été, le soleil ne descendra pas sous 12° au-dessous de l'horizon et, à une certaine période de l'hiver, il ne dépassera pas 12° au-dessous de l'horizon.","Ce logiciel de calcul fournit les heures du crépuscule nautique à une position définie par l'utilisateur, pour le jour même et toutes les deux semaines d'une année civile sélectionnée. Les heures de lever et de coucher de soleil sont affichées et toutes les heures sont ajustées pour correspondre au décalage horaire de l'utilisateur par rapport à l'UTC.","Ce logiciel de calcul est destiné à être utilisé pour l'application de la mesure de conservation 25-02 de la CCAMLR (Réduction de la mortalité accidentelle des oiseaux de mer au cours de la pêche à la palangre). Dans les pêcheries auxquelles s'applique cette mesure de conservation, les palangres ne doivent être posées que la nuit (à savoir, dans l'obscurité, entre les crépuscules nautiques) et dans la mesure du possible, les lignes ne doivent pas être posées pendant les trois heures, voire davantage, qui précèdent le lever du soleil."]
[{"$f":"IF($G$4=\"English\",O$4,IF($G$4=\"French\",O$5,IF($G$4=\"Russian\",O$6,IF($G$4=\"Spanish\",O$7,O$4))))","v":"This calculator provides the times of nautical twilight at a user-defined position, for today and at fortnightly intervals during a selected calendar year. The times of sunrise and sunset are included, and all times are adjusted to reflect the UTC offset of the user's clock."},null,null,null,null,null,null,null,null,null,null,null,"Russian","Навигационные сумерки – утреннее и вечернее время, когда центр Солнца находится под углом -12° к горизонту. На высоких широтах в течение определенного периода в летние месяцы Солнце не опускается ниже -12° к горизонту, а в течение определенного периода в зимние месяцы оно не поднимается выше -12° к горизонту.","Этот калькулятор показывает времена навигационных сумерек на координатах, задаваемых пользователем, на сегодня и через двухнедельные интервалы в течение выбранного календарного года. Показываются времена восхода и заката Солнца; все значения времени корректируются с тем, чтобы отразить смещение относительно времени по UTC на часах пользователя.","Калькулятор должен использоваться при соблюдении Меры по сохранению 25-02 АНТКОМ (Сведение к минимуму побочной смертности морских птиц при ярусном промысле). На промыслах, к которым применяется данная мера по сохранению, ярусы должны устанавливаться только в ночное время (т.е. в период темноты в промежутке между навигационными сумерками) и, по возможности, постановка ярусов должна заканчиваться как минимум за три часа до восхода Солнца."]
[{"$f":"IF($G$4=\"English\",P$4,IF($G$4=\"French\",P$5,IF($G$4=\"Russian\",P$6,IF($G$4=\"Spanish\",P$7,P$4))))","v":"The calculator is intended for use with CCAMLR's Conservation Measure 25-02 (Minimisation of the incidental mortality of seabirds in the course of longline fishing). In fisheries where this conservation measure applies, longlines must be set at night only (i.e. during the hours of darkness between the times of nautical twilight) and, wherever possible, the setting of lines should be completed at least three hours before sunrise."},null,null,null,null,null,null,null,null,null,null,null,"Spanish","Se define crepúsculo náutico como la hora de la mañana y de la tarde cuando el centro del sol está a un ángulo de 12° por debajo del horizonte. En altas latitudes, el sol no se pondrá a un ángulo mayor de 12° por debajo del horizonte durante cierto período en el verano y no saldrá a un ángulo menor de 12° por debajo del horizonte durante cierto período en el invierno.","Este calculador proporciona las horas de crepúsculo náutico en una posición definida por el usuario, para hoy y cada dos semanas durante un año calendario seleccionado. Se incluyen las horas de la salida y de la puesta del sol, y todas han sido ajustadas para reflejar la diferencia UTC con respecto al reloj del usuario.","El calculador se proporciona a fin de facilitar la implementación de la Medida de Conservación 25-02 (Reducción de la mortalidad incidental de aves marinas durante la pesquería de palangre) de la CCRVMA. En pesquerías sujetas a las disposiciones de esta medida de conservación, los palangres deben ser calados solamente por la noche, es decir, en las horas de oscuridad entre las horas del crepúsculo náutico y, en la medida de lo posible, la maniobra de calado debiera finalizar como mínimo tres horas antes de la salida del sol."]
[]
["User-defined position where twilight is observed",null,null,null,"User-defined input",null,null,null,"Example data input"]
["Latitude","degrees (-DD for south)",null,null,-50,null,{"$f":"IF(E10<0,\"South\",\"North\")","v":"South"},"<",-62]
[null,"minutes and fraction of minutes (MM.mm)",null,null,0,null,{"$f":"IF(E11>60,\"enter MM.mm\",\"\")","v":""},"<",43.75]
["Longitude","degrees (DD for east or  -DD for west)",null,null,null,null,{"$f":"IF(E12<0,\"West\",\"East\")","v":"East"},"<",147]
[null,"minutes and fraction of minutes (MM.mm)",null,null,0,null,{"$f":"IF(E13>60,\"enter MM.mm\",\"\")","v":""},"<",10.050000000000001]
[]
["UTC offset of the user's clock"]
["UTC offset","+/– hour",null,null,0,null,{"$f":"IF(ABS(E16-E12/15)>2,\"check UTC offset\",\"\")","v":""},"<",10]
[]
[]
["Nautical twilight times for today"]
["Today",{"$f":"IF($E$16=0,\"Morning (hh:mm UTC)\",\"    Morning (hh:mm local time)\")","v":"Morning (hh:mm UTC)"},null,{"$f":"IF($E$16=0,\"Evening (hh:mm UTC)\",\"    Evening (hh:mm local time)\")","v":"Evening (hh:mm UTC)"}]
[null,"Twilight","Sunrise","Sunset","Twilight"]
[{"$f":"TODAY()","v":"2018-08-29"},{"$f":"IF(ISERROR((M28)/24),M28,M28/24)","v":"05:30:48.941"},{"$f":"IF(ISERROR((O28)/24),O28,O28/24)","v":"06:40:54.030"},{"$f":"IF(ISERROR((P28)/24),P28,P28/24)","v":"17:21:46.015"},{"$f":"IF(ISERROR((N28)/24),N28,N28/24)","v":"18:31:58.728"},null,null,null,null,null,null,null,"For calculation purposes only"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Decimalised positions and times"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Latitude",{"$f":"IF(E10<0,-1*(ABS(E10)+(E11/60)),(ABS(E10)+(E11/60)))","v":-50}]
["Nautical twilight times for a user-defined calendar year",null,null,null,null,null,null,null,null,null,null,null,"Longitude",{"$f":"IF(E12<0,-1*(ABS(E12)+(E13/60)),(ABS(E12)+(E13/60)))","v":0}]
["Select a calendar year from the dropdown menu (click on cell) >",null,null,null,2018,null,null,"<",2019,null,null,null,"UTC offset",{"$f":"E16","v":0}]
["Date",{"$f":"IF($E$16=0,\"Morning (hh:mm UTC)\",\"    Morning (hh:mm local time)\")","v":"Morning (hh:mm UTC)"},null,{"$f":"IF($E$16=0,\"Evening (hh:mm UTC)\",\"    Evening (hh:mm local time)\")","v":"Evening (hh:mm UTC)"},null,null,null,null,null,null,null,null,"Twilight(m)","Twilight(e)","Sun(r)","Sun(s)"]
[null,"Twilight","Sunrise","Sunset","Twilight",null,null,null,null,null,null,null,{"$f":"IF(ISERROR(MOD(Sunrise(DaysPriorTo2k(YEAR($A22),MONTH($A22),DAY($A22),0,0,0,1), $N$24, $N$25, 1, -12)/15 + $N$26,24)),\"no twilight\",MOD(Sunrise(DaysPriorTo2k(YEAR($A22),MONTH($A22),DAY($A22),0,0,0,1), $N$24, $N$25, 1, -12)/15 + $N$26,24))","v":5.5135947054349623},{"$f":"IF(ISERROR((MOD(Sunrise(DaysPriorTo2k(YEAR($A22),MONTH($A22),DAY($A22),0,0,0,1), $N$24, $N$25, 2, -12)/15 + $N$26,24))),\"no twilight\",MOD(Sunrise(DaysPriorTo2k(YEAR($A22),MONTH($A22),DAY($A22),0,0,0,1), $N$24, $N$25, 2, -12)/15 + $N$26,24))","v":18.532980098211979},{"$f":"IF(ISERROR((MOD(Sunrise(DaysPriorTo2k(YEAR($A22),MONTH($A22),DAY($A22),0,0,0,1), $N$24, $N$25, 1, -0.83)/15 + $N$26,24))),\"no sunrise\",MOD(Sunrise(DaysPriorTo2k(YEAR($A22),MONTH($A22),DAY($A22),0,0,0,1), $N$24, $N$25, 1, -0.83)/15 + $N$26,24))","v":6.6816749776151623},{"$f":"IF(ISERROR((MOD(Sunrise(DaysPriorTo2k(YEAR($A22),MONTH($A22),DAY($A22),0,0,0,1), $N$24, $N$25, 2, -0.83)/15 + $N$26,24))),\"no sunset\",MOD(Sunrise(DaysPriorTo2k(YEAR($A22),MONTH($A22),DAY($A22),0,0,0,1), $N$24, $N$25, 2, -0.83)/15 + $N$26,24))","v":17.362781890816787}]
[{"$f":"DATE($E$26,1,1)","v":"2018-01-01"},{"$f":"IF(ISERROR((M29)/24),M29,M29/24)","v":"02:07:24.161"},{"$f":"IF(ISERROR((O29)/24),O29,O29/24)","v":"03:55:21.909"},{"$f":"IF(ISERROR((P29)/24),P29,P29/24)","v":"20:11:21.943"},{"$f":"IF(ISERROR((N29)/24),N29,N29/24)","v":"21:58:52.263"},null,null,null,null,null,null,null,{"$f":"IF(ISERROR(MOD(Sunrise(DaysPriorTo2k(YEAR($A29),MONTH($A29),DAY($A29),0,0,0,1), $N$24, $N$25, 1, -12)/15 + $N$26,24)),\"no twilight\",MOD(Sunrise(DaysPriorTo2k(YEAR($A29),MONTH($A29),DAY($A29),0,0,0,1), $N$24, $N$25, 1, -12)/15 + $N$26,24))","v":2.1233781624423385},{"$f":"IF(ISERROR((MOD(Sunrise(DaysPriorTo2k(YEAR($A29),MONTH($A29),DAY($A29),0,0,0,1), $N$24, $N$25, 2, -12)/15 + $N$26,24))),\"no twilight\",MOD(Sunrise(DaysPriorTo2k(YEAR($A29),MONTH($A29),DAY($A29),0,0,0,1), $N$24, $N$25, 2, -12)/15 + $N$26,24))","v":21.981184084928486},{"$f":"IF(ISERROR((MOD(Sunrise(DaysPriorTo2k(YEAR($A29),MONTH($A29),DAY($A29),0,0,0,1), $N$24, $N$25, 1, -0.83)/15 + $N$26,24))),\"no sunrise\",MOD(Sunrise(DaysPriorTo2k(YEAR($A29),MONTH($A29),DAY($A29),0,0,0,1), $N$24, $N$25, 1, -0.83)/15 + $N$26,24))","v":3.9227524826434101},{"$f":"IF(ISERROR((MOD(Sunrise(DaysPriorTo2k(YEAR($A29),MONTH($A29),DAY($A29),0,0,0,1), $N$24, $N$25, 2, -0.83)/15 + $N$26,24))),\"no sunset\",MOD(Sunrise(DaysPriorTo2k(YEAR($A29),MONTH($A29),DAY($A29),0,0,0,1), $N$24, $N$25, 2, -0.83)/15 + $N$26,24))","v":20.189428548266683}]
[{"$f":"DATE($E$26,1,15)","v":"2018-01-15"},{"$f":"IF(ISERROR((M30)/24),M30,M30/24)","v":"02:33:54.224"},{"$f":"IF(ISERROR((O30)/24),O30,O30/24)","v":"04:13:22.875"},{"$f":"IF(ISERROR((P30)/24),P30,P30/24)","v":"20:04:39.696"},{"$f":"IF(ISERROR((N30)/24),N30,N30/24)","v":"21:43:24.562"},null,null,null,null,null,null,null,2.5650623547759648,21.723489444589166,4.2230209087488024,20.077693288493197]
[{"$f":"DATE($E$26,2,1)","v":"2018-02-01"},{"$f":"IF(ISERROR((M31)/24),M31,M31/24)","v":"03:14:01.834"},{"$f":"IF(ISERROR((O31)/24),O31,O31/24)","v":"04:41:38.746"},{"$f":"IF(ISERROR((P31)/24),P31,P31/24)","v":"19:44:29.215"},{"$f":"IF(ISERROR((N31)/24),N31,N31/24)","v":"21:11:25.784"},null,null,null,null,null,null,null,3.2338426627132058,21.190495567177948,4.6940962039071641,19.741448560817698]
[{"$f":"DATE($E$26,2,15)","v":"2018-02-15"},"03:46:35.863","05:06:23.074","19:20:46.382","20:40:01.839",null,null,null,null,null,null,null,3.7766287268571044,20.667177623430895,5.1064094788079579,19.346217315244708]
[{"$f":"DATE($E$26,3,1)","v":"2018-03-01"},"04:16:11.014","05:30:31.882","18:53:04.855","20:07:02.174",null,null,null,null,null,null,null,4.2697260243298381,20.117270548828362,5.5088561314355076,18.884681950959649]
[{"$f":"DATE($E$26,3,15)","v":"2018-03-15"},"04:42:28.446","05:53:35.879","18:23:16.298","19:34:06.802",null,null,null,null,null,null,null,4.7079015528119674,19.56855610775801,5.8932996228162713,18.387860527181974]
[{"$f":"DATE($E$26,4,1)","v":"2018-04-01"},"05:10:42.962","06:20:27.834","17:46:25.821","18:55:59.719",null,null,null,null,null,null,null,5.1786005804685722,18.933255285010954,6.3410651235515259,17.773839214034187]
[{"$f":"DATE($E$26,4,15)","v":"2018-04-15"},"05:31:44.537","06:42:05.886","17:17:13.641","18:27:27.599",null,null,null,null,null,null,null,5.5290379847433977,18.457666283153248,6.7016350158158193,17.287122503329329]
[{"$f":"DATE($E$26,5,1)","v":"2018-05-01"},"05:53:50.850","07:06:23.175","16:47:10.024","17:59:37.926",null,null,null,null,null,null,null,5.8974582585196327,17.993868429477615,7.1064375791455268,16.786117671370381]
[{"$f":"DATE($E$26,5,15)","v":"2018-05-15"},"06:11:15.812","07:26:29.907","16:25:41.979","17:40:53.475",null,null,null,null,null,null,null,6.1877255270235469,17.681520969352512,7.4416409482063575,16.428327557458378]
[{"$f":"DATE($E$26,6,1)","v":"2018-06-01"},"06:28:27.988","07:46:53.663","16:08:30.283","17:26:54.842",null,null,null,null,null,null,null,6.4744411176652177,17.448567212570666,7.7815731872494229,16.141745340934911]
[{"$f":"DATE($E$26,6,15)","v":"2018-06-15"},"06:37:27.100","07:57:24.376","16:03:29.835","17:23:26.813",null,null,null,null,null,null,null,6.6241945447278381,17.390781513500269,7.9567710230915472,16.058287422715367]
[{"$f":"DATE($E$26,7,1)","v":"2018-07-01"},"06:39:47.728","07:59:26.700","16:08:27.014","17:28:06.492",null,null,null,null,null,null,null,6.6632577036671625,17.468470073245886,7.9907500078003464,16.140837189097958]
[{"$f":"DATE($E$26,7,15)","v":"2018-07-15"},"06:33:56.660","07:51:39.735","16:20:39.783","17:38:24.261",null,null,null,null,null,null,null,6.5657389521803449,17.640072448418248,7.8610374949858395,16.344384075433492]
[{"$f":"DATE($E$26,8,1)","v":"2018-08-01"},"06:17:09.299","07:31:32.375","16:41:42.947","17:56:09.010",null,null,null,null,null,null,null,6.2859164791385664,17.935836013192429,7.5256597153194456,16.695262918920928]
[{"$f":"DATE($E$26,8,15)","v":"2018-08-15"},"05:56:26.168","07:08:15.335","17:01:25.514","18:13:19.636",null,null,null,null,null,null,null,5.9406020891386015,18.222121025029384,7.1375930726564665,17.023753839690773]
[{"$f":"DATE($E$26,9,1)","v":"2018-09-01"},"05:24:48.634","06:34:40.353","17:26:09.144","18:36:09.170",null,null,null,null,null,null,null,5.4135094796180825,18.602547088746533,6.5778757926374132,17.435873203444956]
[{"$f":"DATE($E$26,9,15)","v":"2018-09-15"},"04:54:55.346","06:04:34.702","17:46:44.851","18:56:36.319",null,null,null,null,null,null,null,4.9153738622139729,18.94342194482423,6.0763061915440311,17.779125238543958]
[{"$f":"DATE($E$26,10,1)","v":"2018-10-01"},"04:18:04.407","05:29:26.138","18:10:53.553","19:22:33.271",null,null,null,null,null,null,null,4.3012242172350419,19.375908700747242,5.4905939453933987,18.181542524991361]
[{"$f":"DATE($E$26,10,15)","v":"2018-10-15"},"03:44:41.938","04:59:34.218","18:33:02.582","19:48:19.608",null,null,null,null,null,null,null,3.7449827312496837,19.805446619876122,4.992838426933929,18.550717125020704]
[{"$f":"DATE($E$26,11,1)","v":"2018-11-01"},"03:04:39.941","04:26:45.900","19:01:26.150","20:24:07.038",null,null,null,null,null,null,null,3.0777614638791873,20.401954930235533,4.4460833729136162,19.023930426000263]
[{"$f":"DATE($E$26,11,15)","v":"2018-11-15"},"02:34:18.960","04:04:54.930","19:25:11.169","20:56:29.720",null,null,null,null,null,null,null,2.5719333245424272,20.941588799112488,4.0819251343204659,19.419769276802388]
[{"$f":"DATE($E$26,12,1)","v":"2018-12-01"},"02:07:02.227","03:48:53.460","19:49:47.095","21:32:19.263",null,null,null,null,null,null,null,2.1172853577338535,21.538684063596779,3.8148498842111187,19.829748559706083]
[{"$f":"DATE($E$26,12,15)","v":"2018-12-15"},"01:56:02.179","03:45:14.821","20:05:11.893","21:54:41.870",null,null,null,null,null,null,null,1.9339385641450975,21.911630580293739,3.7541169106604286,20.086636827043677]
[{"$f":"DATE($E$26,12,31)","v":"2018-12-31"},"02:05:40.450","03:54:08.489","20:11:26.916","21:59:30.165",null,null,null,null,null,null,null,2.094569348617993,21.991712432937888,3.9023581442647384,20.190810060840612]