{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Tide predict","Sea level frequency","Tide smear"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":9,"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":"Tide predict","index":0,"n_rows":691,"n_cols":5,"rows_kept":691,"cut":false,"hidden":false,"merged":[]}
["Tide prediction sheet",null,null,"limited to sites for which harmonic constants are known"]
[null,"w0","w1","w2","w3"]
[null,15,14.492054485000001,0.54901415360000005,4.1068638800000001E-2]
[]
[null,null,"amplitude (m)","w degrees/hr","phase degrees"]
[null,"M2",1.5680000000000001,{"$f":"2*C$3","v":28.984108970000001},188.11]
[null,"S2",0.53300000000000003,{"$f":"2*B$3","v":30},234.18]
[null,"K1",0.14499999999999999,{"$f":"2*(C$3+D$3)","v":30.082137277200001},300.95]
[null,"O1",0.158,{"$f":"2*(C$3-D$3)","v":27.886080662800001},132.54]
[]
[null,"Z0",2.92]
[]
[null,"step",0.98,"hours"]
[]
["t","height"]
[0,{"$f":"C$6*COS(RADIANS(D$6*A16-E$6))+C$7*COS(RADIANS(D$7*A16-E$7))+C$8*COS(RADIANS(D$8*A16-E$8))+C$9*COS(RADIANS(D$9*A16-E$9))","v":-1.8965043558653416}]
[{"$f":"A16+C$13","v":0.98},-1.9923245215061018]
[1.96,-1.6011074947711772]
[2.94,-0.81363836702448722]
[3.92,0.18114075574336122]
[4.9000000000000004,1.14149225307109]
[5.8800000000000008,1.8316855344070255]
[6.8600000000000012,2.0799224916168249]
[7.8400000000000016,1.8211364006913355]
[8.8200000000000021,1.1139927061884063]
[9.8000000000000025,0.1276612993689735]
[10.780000000000003,-0.89867685787657325]
[11.760000000000003,-1.7138908718667099]
[12.740000000000004,-2.1164196436854548]
[13.720000000000004,-2.0041619624560183]
[14.700000000000005,-1.4003745920879314]
[15.680000000000005,-0.44900855689746538]
[16.660000000000004,0.61962664642964749]
[17.640000000000004,1.5446775694658295]
[18.620000000000005,2.0984989675735362]
[19.600000000000005,2.1427434999863264]
[20.580000000000005,1.662951939572473]
[21.560000000000006,0.77298767281695191]
[22.540000000000006,-0.31199168468076693]
[23.520000000000007,-1.3276086030701946]
[24.500000000000007,-2.0247684247192841]
[25.480000000000008,-2.2308332211639845]
[26.460000000000008,-1.8924236670864785]
[27.440000000000008,-1.0892242705260495]
[28.420000000000009,-1.5226245319808068E-2]
[29.400000000000009,1.06817873615015]
[30.38000000000001,1.8958994365225856]
[31.36000000000001,2.2640965109335611]
[32.340000000000011,2.0804488021790437]
[33.320000000000007,1.3873222189522736]
[34.300000000000004,0.35202150053039349]
[35.28,-0.77363910430401195]
[36.26,-1.7146654502951857]
[37.239999999999995,-2.2401566979802308]
[38.219999999999992,-2.2200418829364872]
[39.199999999999989,-1.657318944564115]
[40.179999999999986,-0.68779476161417952]
[41.159999999999982,0.45272724331261738]
[42.139999999999979,1.4858752392634025]
[43.119999999999976,2.1587479100253781]
[44.099999999999973,2.3059109052744664]
[45.07999999999997,1.8901310360870605]
[46.059999999999967,1.0118036553018916]
[47.039999999999964,-0.11531561893548413]
[48.01999999999996,-1.2162021688369622]
[48.999999999999957,-2.0217651103982401]
[49.979999999999954,-2.3347172136255523]
[50.959999999999951,-2.0779644987809829]
[51.939999999999948,-1.3136289427109611]
[52.919999999999945,-0.22800289247282862]
[53.899999999999942,0.91391725068516849]
[54.879999999999939,1.8332067107700596]
[55.859999999999935,2.3052413243327283]
[56.839999999999932,2.2146658570189044]
[57.819999999999929,1.5836300738856806]
[58.799999999999926,0.56636992081073989]
[59.779999999999923,-0.58853993843926178]
[60.75999999999992,-1.5990118347997515]
[61.739999999999917,-2.2184443910483012]
[62.719999999999914,{"$f":"C$6*COS(RADIANS(D$6*A80-E$6))+C$7*COS(RADIANS(D$7*A80-E$7))+C$8*COS(RADIANS(D$8*A80-E$8))+C$9*COS(RADIANS(D$9*A80-E$9))","v":-2.2959937716005032}]
[{"$f":"A80+C$13","v":63.69999999999991},-1.8133643390862717]
[64.679999999999907,-0.8891315577390787]
[65.659999999999911,0.25042585474885659]
[66.639999999999915,1.3268008920496761]
[67.619999999999919,2.0774214691986623]
[68.599999999999923,2.3197956935600659]
[69.579999999999927,1.9959460134694347]
[70.559999999999931,1.18629697892851]
[71.539999999999935,8.9685395904793991E-2]
[72.519999999999939,-1.0255341435685268]
[73.499999999999943,-1.8872494570898595]
[74.479999999999947,-2.2860799784945103]
[75.459999999999951,-2.1263256438107101]
[76.439999999999955,-1.4489601164015553]
[77.419999999999959,-0.42113676295991731]
[78.399999999999963,0.70510797334886233]
[79.379999999999967,1.6547391089951637]
[80.359999999999971,2.196980416897051]
[81.339999999999975,2.2014746974835555]
[82.319999999999979,1.6696612327780391]
[83.299999999999983,0.7338083787787778]
[84.279999999999987,-0.37591226947601275]
[85.259999999999991,-1.3881063702623668]
[86.24,-2.056616833176276]
[87.22,-2.2204668223228574]
[88.2,-1.842669250175375]
[89.18,-1.0185350993916624]
[90.160000000000011,4.8374410385425448E-2]
[91.140000000000015,1.0965830654659086]
[92.120000000000019,1.8708617945976089]
[93.100000000000023,2.1844535195012496]
[94.080000000000027,1.9641709275384407]
[95.060000000000031,1.2674645250887384]
[96.040000000000035,0.26748429148320563]
[97.020000000000039,-0.78999034764011689]
[98.000000000000043,-1.6470291016178304]
[98.980000000000047,-2.0965386418710934]
[99.960000000000051,-2.0323590793663868]
[100.94000000000005,-1.4743372843599973]
[101.92000000000006,-0.56245522292568295]
[102.90000000000006,0.47830006429366034]
[103.88000000000007,1.3935042116480101]
[104.86000000000007,1.9615623278633745]
[105.84000000000007,2.04741854373317]
[106.82000000000008,1.6346767295592668]
[107.80000000000008,0.8284907250059631]
[108.78000000000009,-0.1712092102410093]
[109.76000000000009,-1.1193397753116854]
[110.74000000000009,-1.785810330505694]
[111.7200000000001,-2.0114150687280925]
[112.7000000000001,-1.745881308790421]
[113.68000000000011,-1.0589769114573624]
[114.66000000000011,-0.12224905710705469]
[115.64000000000011,0.83384084376551071]
[116.62000000000012,1.5766688335396872]
[117.60000000000012,1.9280982330041987]
[118.58000000000013,1.8072192961330251]
[119.56000000000013,1.2489194368907111]
[120.54000000000013,0.39403761691696715]
[121.52000000000014,-0.54616396742638151]
[122.50000000000014,-1.342247487071325]
[123.48000000000015,-1.802634530204773]
[124.46000000000015,-1.8197318144329968]
[125.44000000000015,{"$f":"C$6*COS(RADIANS(D$6*A144-E$6))+C$7*COS(RADIANS(D$7*A144-E$7))+C$8*COS(RADIANS(D$8*A144-E$8))+C$9*COS(RADIANS(D$9*A144-E$9))","v":-1.3950366826506304}]
[{"$f":"A144+C$13","v":126.42000000000016},-0.63737512195130142]
[127.40000000000016,0.26495240853239244]
[128.38000000000017,1.0909943828174147]
[129.36000000000016,1.6412904852373273]
[130.34000000000015,1.786055722640518]
[131.32000000000014,1.4957610923823219]
[132.30000000000013,0.84691308002852328]
[133.28000000000011,1.973786777075881E-3]
[134.2600000000001,-0.83132598829026338]
[135.24000000000009,-1.4510878890904606]
[136.22000000000008,-1.7101825662673504]
[137.20000000000007,-1.5511553753561085]
[138.18000000000006,-1.0188260843693648]
[139.16000000000005,-0.24785877782646981]
[140.14000000000004,0.5712927615980059]
[141.12000000000003,1.2394538119990004]
[142.10000000000002,1.5971730898765812]
[143.08000000000001,1.5627555700928049]
[144.06,1.1508170553628192]
[145.04,0.46717438374095677]
[146.01999999999998,-0.31829748414563042]
[146.99999999999997,-1.0138869820763108]
[147.97999999999996,-1.4528485745074486]
[148.95999999999995,-1.5333571511728499]
[149.93999999999994,-1.2420450229331883]
[150.91999999999993,-0.65570327508237813]
[151.89999999999992,7.887858919460447E-2]
[152.87999999999991,0.78165952261007698]
[153.8599999999999,1.2834804005058686]
[154.83999999999989,1.4667631841594178]
[155.81999999999988,1.2929878395294729]
[156.79999999999987,0.810544978303814]
[157.77999999999986,0.14143468160425657]
[158.75999999999985,-0.54956916452961857]
[159.73999999999984,-1.0954977830241295]
[160.71999999999983,-1.3675148126424597]
[161.69999999999982,-1.3052559232175667]
[162.67999999999981,-0.93005306711367441]
[163.6599999999998,-0.33819415961275762]
[164.63999999999979,0.32375222390758646]
[165.61999999999978,0.89523074077351583]
[166.59999999999977,1.24062404463261]
[167.57999999999976,1.2813754376240718]
[168.55999999999975,1.0137163164118939]
[169.53999999999974,0.50803603848547396]
[170.51999999999973,-0.1095622581559019]
[171.49999999999972,-0.6887013039579476]
[172.47999999999971,-1.0913269646331851]
[173.4599999999997,-1.2245600829756833]
[174.43999999999969,-1.0619997832544157]
[175.41999999999967,-0.64862482809078026]
[176.39999999999966,-8.8486175034514003E-2]
[177.37999999999965,0.48147109657985593]
[178.35999999999964,0.92487232214279613]
[179.33999999999963,1.138489885365964]
[180.31999999999962,1.0761635399545573]
[181.29999999999961,0.75855113194239665]
[182.2799999999996,0.26671439749580356]
[183.25999999999959,-0.27854815140571632]
[184.23999999999958,-0.74635622824204884]
[185.21999999999957,-1.0271131374912699]
[186.19999999999956,-1.0580770178346985]
[187.17999999999955,-0.83719904085269958]
[188.15999999999954,{"$f":"C$6*COS(RADIANS(D$6*A208-E$6))+C$7*COS(RADIANS(D$7*A208-E$7))+C$8*COS(RADIANS(D$8*A208-E$8))+C$9*COS(RADIANS(D$9*A208-E$9))","v":-0.42222730756926735}]
[{"$f":"A208+C$13","v":189.13999999999953},8.4350567999466788E-2]
[190.11999999999952,0.56060879827154753]
[191.09999999999951,0.8944841842316551]
[192.0799999999995,1.0100456501003046]
[193.05999999999949,0.88460012299796864]
[194.03999999999948,0.55282544111292442]
[195.01999999999947,9.7280168696206634E-2]
[195.99999999999946,-0.37213342738848143]
[196.97999999999945,-0.744645375906969]
[197.95999999999944,-0.93466387251369187]
[198.93999999999943,-0.90129067215454373]
[199.91999999999942,-0.65689699402727975]
[200.89999999999941,-0.26302734667377348]
[201.8799999999994,0.18509440852113077]
[202.85999999999939,0.5815566147944814]
[203.83999999999938,0.8347048021519059]
[204.81999999999937,0.88818711424674635]
[205.79999999999936,0.73330599738441116]
[206.77999999999935,0.41002260633501397]
[207.75999999999934,-3.3442105922106731E-3]
[208.73999999999933,-0.40907091813245966]
[209.71999999999932,-0.71305240533156911]
[210.69999999999931,-0.84649144660251685]
[211.6799999999993,-0.78129195353390513]
[212.65999999999929,-0.53576033114881838]
[213.63999999999928,-0.16952171204788027]
[214.61999999999927,0.23094973861089516]
[215.59999999999926,0.57267708261638994]
[216.57999999999925,0.77763457473827646]
[217.55999999999923,0.80039398417211394]
[218.53999999999922,0.6380182248056917]
[219.51999999999921,0.33009693212200125]
[220.4999999999992,-5.0907816125932447E-2]
[221.47999999999919,-0.41665076544200497]
[222.45999999999918,-0.68326077657695394]
[223.43999999999917,-0.79040912295791543]
[224.41999999999916,-0.71479799650911713]
[225.39999999999915,-0.47509806300563417]
[226.37999999999914,-0.12732558476098113]
[227.35999999999913,0.24819325177513693]
[228.33999999999912,0.5652516712378215]
[229.31999999999911,0.75139011385028742]
[230.2999999999991,0.76429732360140556]
[231.27999999999909,0.60131532178319258]
[232.25999999999908,0.29994382429682731]
[233.23999999999907,-7.0737983062333157E-2]
[234.21999999999906,-0.42578342243208867]
[235.19999999999905,-0.68368332917189667]
[236.17999999999904,-0.78492045671382793]
[237.15999999999903,-0.70559216500700361]
[238.13999999999902,-0.46301339505517164]
[239.11999999999901,-0.11199691380612255]
[240.099999999999,0.26740687034949867]
[241.07999999999899,0.58800261434556234]
[242.05999999999898,0.77533031114373452]
[243.03999999999897,0.78484327887446892]
[244.01999999999896,0.61245151102311413]
[244.99999999999895,0.29594751856207119]
[245.97999999999894,-9.313721508024142E-2]
[246.95999999999893,-0.46553042017786234]
[247.93999999999892,-0.73454004310059162]
[248.91999999999891,-0.83611602712066579]
[249.8999999999989,-0.74404191097990413]
[250.87999999999889,{"$f":"C$6*COS(RADIANS(D$6*A272-E$6))+C$7*COS(RADIANS(D$7*A272-E$7))+C$8*COS(RADIANS(D$8*A272-E$8))+C$9*COS(RADIANS(D$9*A272-E$9))","v":-0.47666771307750871}]
[{"$f":"A272+C$13","v":251.85999999999888},-9.3461956203277075E-2]
[252.83999999999887,0.31803389030377777]
[253.81999999999886,0.66203736275471259]
[254.79999999999885,0.8566957028839588]
[255.77999999999884,0.85349628987089299]
[256.75999999999885,0.649330391586455]
[257.73999999999887,0.28821592415791997]
[258.71999999999889,-0.1479809619836007]
[259.69999999999891,-0.5579306035400009]
[260.67999999999893,-0.84425000348620594]
[261.65999999999894,-0.93656423468568262]
[262.63999999999896,-0.80877605288252052]
[263.61999999999898,-0.48631194901917796]
[264.599999999999,-4.1359743873600738E-2]
[265.57999999999902,0.42310222508385081]
[266.55999999999904,0.79700347505781866]
[267.53999999999905,0.98918956638270739]
[268.51999999999907,0.94961436255626508]
[269.49999999999909,0.68232035851719286]
[270.47999999999911,0.24585128733566997]
[271.45999999999913,-0.25935328138396369]
[272.43999999999915,-0.71392866577680159]
[273.41999999999916,-1.0077059970783628]
[274.39999999999918,-1.066379397665455]
[275.3799999999992,-0.87027205320916357]
[276.35999999999922,-0.46046741365255428]
[277.33999999999924,6.9521647015502536E-2]
[278.31999999999925,0.59493774064885485]
[279.29999999999927,0.98906042882832701]
[280.27999999999929,1.1537341143280795]
[281.25999999999931,1.0437962542518242]
[282.23999999999933,0.67932954962512881]
[283.21999999999935,0.14244244010418905]
[284.19999999999936,-0.44105662645942617]
[285.17999999999938,-0.93104844578907664]
[286.1599999999994,-1.2067145405583803]
[287.13999999999942,-1.1963171296018107]
[288.11999999999944,-0.8958089581765476]
[289.09999999999945,-0.37145771451188753]
[290.07999999999947,0.25456354972543593]
[291.05999999999949,0.83254392418038958]
[292.03999999999951,1.220999717752236]
[293.01999999999953,1.321302590326505]
[293.99999999999955,1.1026961929294341]
[294.97999999999956,0.61136071045277962]
[295.95999999999958,-3.9075162801904775E-2]
[296.9399999999996,-0.69370345540569678]
[297.91999999999962,-1.1931898815825182]
[298.89999999999964,-1.412553486041203]
[299.87999999999965,-1.2924345221420592]
[300.85999999999967,-0.85502803048581288]
[301.83999999999969,-0.20043373977447598]
[302.81999999999971,0.51612658952119217]
[303.79999999999973,1.1210731040502731]
[304.77999999999975,1.4645170691492579]
[305.75999999999976,1.4574085028567967]
[306.73999999999978,1.0945726077935574]
[307.7199999999998,0.45768681397244348]
[308.69999999999982,-0.30295478064529358]
[309.67999999999984,-1.0038598348709318]
[310.65999999999985,-1.4726053144619591]
[311.63999999999987,-1.5902738226567268]
[312.61999999999989,-1.3216087934208096]
[313.59999999999991,{"$f":"C$6*COS(RADIANS(D$6*A336-E$6))+C$7*COS(RADIANS(D$7*A336-E$7))+C$8*COS(RADIANS(D$8*A336-E$8))+C$9*COS(RADIANS(D$9*A336-E$9))","v":-0.72524386586090761}]
[{"$f":"A336+C$13","v":314.57999999999993},5.8895250642494817E-2]
[315.55999999999995,0.84236559003865641]
[316.53999999999996,1.4334967680895552]
[317.52,1.6843103033053395]
[318.5,1.5275754988657446]
[319.48,0.99471872530170913]
[320.46000000000004,0.2098394368875186]
[321.44000000000005,-0.6391244223453596]
[322.42000000000007,-1.3454002487237053]
[323.40000000000009,-1.7337769343768503]
[324.38000000000011,-1.7041015863977527]
[325.36000000000013,-1.2570704304762546]
[326.34000000000015,-0.4956798042169504]
[327.32000000000016,0.3984196330824803]
[328.30000000000018,1.2082600082946664]
[329.2800000000002,1.7342462451904839]
[330.26000000000022,1.8433936304690381]
[331.24000000000024,1.5029551823878005]
[332.22000000000025,0.78993358201982034]
[333.20000000000027,-0.12622319215163763]
[334.18000000000029,-1.0238848245228114]
[335.16000000000031,-1.6828953902595725]
[336.14000000000033,-1.9386234118369787]
[337.12000000000035,-1.7231215445604919]
[338.10000000000036,-1.0830971240543978]
[339.08000000000038,-0.1699588242789373]
[340.0600000000004,0.79598776924656423]
[341.04000000000042,1.5787330547180995]
[342.02000000000044,1.9842912946915836]
[343.00000000000045,1.908827467595094]
[343.98000000000047,1.3652299958019751]
[344.96000000000049,0.48133121284232]
[345.94000000000051,-0.53012878724943757]
[346.92000000000053,-1.4227445926872955]
[347.90000000000055,-1.976542104668437]
[348.88000000000056,-2.0522552287577387]
[349.86000000000058,-1.6263737202691315]
[350.8400000000006,-0.79813525895786086]
[351.82000000000062,0.2335583547469558]
[352.80000000000064,1.2179424830618644]
[353.78000000000065,1.9134122749225542]
[354.76000000000067,2.1468995089700202]
[355.74000000000069,1.8569919628898031]
[356.72000000000071,1.1100394987812208]
[357.70000000000073,8.5033072633928869E-2]
[358.68000000000075,-0.9693149074377615]
[359.66000000000076,-1.7949907342886153]
[360.64000000000078,-2.1879046795447801]
[361.6200000000008,-2.0484072287155168]
[362.60000000000082,-1.4065753564542138]
[363.58000000000084,-0.41584883161343084]
[364.56000000000085,0.68367162478310983]
[365.54000000000087,1.6234810332803771]
[366.52000000000089,2.1723299071337636]
[367.50000000000091,2.1932086156532264]
[368.48000000000093,1.6775939013578434]
[369.46000000000095,0.7483863900663561]
[370.44000000000096,-0.36939288486748839]
[371.42000000000098,-1.4031581967108098]
[372.400000000001,-2.0993247497094751]
[373.38000000000102,-2.2856063807956808]
[374.36000000000104,-1.9137180513193333]
[375.34000000000106,-1.0718829750046797]
[376.32000000000107,{"$f":"C$6*COS(RADIANS(D$6*A400-E$6))+C$7*COS(RADIANS(D$7*A400-E$7))+C$8*COS(RADIANS(D$8*A400-E$8))+C$9*COS(RADIANS(D$9*A400-E$9))","v":3.6093416233083785E-2}]
[{"$f":"A400+C$13","v":377.30000000000109},1.140220336956606]
[378.28000000000111,1.9702032360273076]
[379.26000000000113,2.321711967383385]
[380.24000000000115,2.106764351687576]
[381.22000000000116,1.3757819676899194]
[382.20000000000118,0.30578091009599295]
[383.1800000000012,-0.84254169605810081]
[384.16000000000122,-1.7884106278756535]
[385.14000000000124,-2.2997265174889652]
[386.12000000000126,-2.250110017395333]
[387.10000000000127,-1.6501939251795377]
[388.08000000000129,-0.64540170675904163]
[389.06000000000131,0.51934003516797966]
[390.04000000000133,1.5593837228115415]
[391.02000000000135,2.2200264591665078]
[392.00000000000136,2.3389841369317175]
[392.98000000000138,1.8863262204170919]
[393.9600000000014,0.97202697303395047]
[394.94000000000142,-0.18077670969389628]
[395.92000000000144,-1.2903121941488487]
[396.90000000000146,-2.0851411171024603]
[397.88000000000147,-2.3706665828360922]
[398.86000000000149,-2.0768571748044797]
[399.84000000000151,-1.2754639540694557]
[400.82000000000153,-0.16248802911565288]
[401.80000000000155,0.98981461406886806]
[402.78000000000156,1.8996240038551131]
[403.76000000000158,2.344583926432982]
[404.7400000000016,2.2162340572199049]
[405.72000000000162,1.5465000934849127]
[406.70000000000164,0.49975927845560442]
[407.68000000000166,-0.66754802970800764]
[408.66000000000167,-1.6698260299073562]
[409.64000000000169,-2.2622981072673678]
[410.62000000000171,-2.3008791921801808]
[411.60000000000173,-1.7772784040947291]
[412.58000000000175,-0.82076506179660769]
[413.56000000000176,0.33377389396981483]
[414.54000000000178,1.403584860130177]
[415.5200000000018,2.1273903015804922]
[416.50000000000182,2.3292943079218471]
[417.48000000000184,1.9615973371434665]
[418.46000000000186,1.1160818072552272]
[419.44000000000187,1.094478792128456E-3]
[420.42000000000189,-1.1098496216616254]
[421.40000000000191,-1.9452488944218096]
[422.38000000000193,-2.3020597396889477]
[423.36000000000195,-2.09512027776079]
[424.34000000000196,-1.3775047688973667]
[425.32000000000198,-0.32693711279339971]
[426.300000000002,0.79826378952625321]
[427.28000000000202,1.722776231243665]
[428.26000000000204,2.2217317199447431]
[429.24000000000206,2.1754857637650225]
[430.22000000000207,1.5983444129347262]
[431.20000000000209,0.63434050555407495]
[432.18000000000211,-0.47873109904500599]
[433.16000000000213,-1.4680335051758262]
[434.14000000000215,-2.092647264444321]
[435.12000000000216,-2.2023159817119651]
[436.10000000000218,-1.7736349734416725]
[437.0800000000022,-0.91495672242837545]
[438.06000000000222,0.16098963512789941]
[439.04000000000224,{"$f":"C$6*COS(RADIANS(D$6*A464-E$6))+C$7*COS(RADIANS(D$7*A464-E$7))+C$8*COS(RADIANS(D$8*A464-E$8))+C$9*COS(RADIANS(D$9*A464-E$9))","v":1.1898464071567338}]
[{"$f":"A464+C$13","v":440.02000000000226},1.9206516588147005]
[441.00000000000227,2.1771275712308884]
[441.98000000000229,1.9002473809514804]
[442.96000000000231,1.161790649151643]
[443.94000000000233,0.14578216719100884]
[444.92000000000235,-0.89739581617669928]
[445.90000000000236,-1.7127678841325185]
[446.88000000000238,-2.1031548024153692]
[447.8600000000024,-1.9769051387457792]
[448.84000000000242,-1.3694028771482694]
[449.82000000000244,-0.43330687734059603]
[450.80000000000246,0.59981774670482757]
[451.78000000000247,1.4768302018219637]
[452.76000000000249,1.9851003556155797]
[453.74000000000251,2.0041080000002305]
[454.72000000000253,1.5340216745875281]
[455.70000000000255,0.69448038324557382]
[456.68000000000256,-0.30583503863738093]
[457.66000000000258,-1.2211053693419713]
[458.6400000000026,-1.8288328727030225]
[459.62000000000262,-1.983974031279043]
[460.60000000000264,-1.6535637274653503]
[461.58000000000266,-0.92356410022181157]
[462.56000000000267,2.3440034599292225E-2]
[463.54000000000269,0.95392452401763694]
[464.52000000000271,1.6410529043984476]
[465.50000000000273,1.9200154284277942]
[466.48000000000275,1.7275693581364615]
[467.46000000000276,1.1162919208990112]
[468.44000000000278,0.24035698639420222]
[469.4200000000028,-0.68334672557237286]
[470.40000000000282,-1.4289497054660376]
[471.38000000000284,-1.8168669515298068]
[472.36000000000286,-1.7570633051651277]
[473.34000000000287,-1.269892792002201]
[474.32000000000289,-0.47970419882615434]
[475.30000000000291,0.41687168144427067]
[476.28000000000293,1.1998705095103295]
[477.26000000000295,1.6799878399987511]
[478.24000000000296,1.7443564955096187]
[479.22000000000298,1.3830355192126533]
[480.200000000003,0.69000582358169615]
[481.18000000000302,-0.16121459030181906]
[482.16000000000304,-0.96102155414799584]
[483.14000000000306,-1.5153584490276188]
[484.12000000000307,-1.6928072599869115]
[485.10000000000309,-1.455707371575615]
[486.08000000000311,-0.86794310386350249]
[487.06000000000313,-7.7849293634357858E-2]
[488.04000000000315,0.71921644772968163]
[489.02000000000317,1.32919163174954]
[490.00000000000318,1.6065619445330601]
[490.9800000000032,1.4890419255541525]
[491.96000000000322,1.0114262037213049]
[492.94000000000324,0.29556842118258309]
[493.92000000000326,-0.48068279036089973]
[494.90000000000327,-1.1276762175061081]
[495.88000000000329,-1.4902947822109678]
[496.86000000000331,-1.4851140906626035]
[497.84000000000333,-1.1194890873967573]
[498.82000000000335,-0.48823059777757055]
[499.80000000000337,0.25093267622951548]
[500.78000000000338,0.91676605599399452]
[501.7600000000034,{"$f":"C$6*COS(RADIANS(D$6*A528-E$6))+C$7*COS(RADIANS(D$7*A528-E$7))+C$8*COS(RADIANS(D$8*A528-E$8))+C$9*COS(RADIANS(D$9*A528-E$9))","v":1.3489652680904383}]
[{"$f":"A528+C$13","v":502.74000000000342},1.4467212393702287]
[503.72000000000344,1.1921427877086206]
[504.70000000000346,0.65311904696636669]
[505.68000000000347,-3.4697243222961131E-2]
[506.66000000000349,-0.7020233500612667]
[507.64000000000351,-1.1876082940026758]
[508.62000000000353,-1.3771687911577479]
[509.60000000000355,-1.2302044228654394]
[510.58000000000357,-0.78842143975624224]
[511.56000000000358,-0.16407976214857314]
[512.5400000000036,0.48851978917825911]
[513.52000000000362,1.0111682301088103]
[514.50000000000364,1.2800765648396812]
[515.48000000000366,1.2351197574902795]
[516.46000000000367,0.89310723868155362]
[517.44000000000369,0.34219896119856325]
[518.42000000000371,-0.28079375380646654]
[519.40000000000373,-0.82438334409108383]
[520.38000000000375,-1.1592189199013687]
[521.36000000000377,-1.2087960317427817]
[522.34000000000378,-0.96679007886271184]
[523.3200000000038,-0.49712591899093728]
[524.30000000000382,8.2857016420142218E-2]
[525.28000000000384,0.63172183792180037]
[526.26000000000386,1.0184074594929586]
[527.24000000000387,1.1534593294514104]
[528.22000000000389,1.0095917818255185]
[529.20000000000391,0.62689059340018993]
[530.18000000000393,0.10175969206161321]
[531.16000000000395,-0.43736578730656034]
[532.14000000000397,-0.86142024035668774]
[533.12000000000398,-1.0715471589928243]
[534.100000000004,-1.0220230172645963]
[535.08000000000402,-0.72998170552823971]
[536.06000000000404,-0.26993582996399212]
[537.04000000000406,0.24523480574459833]
[538.02000000000407,0.69197644599452157]
[539.00000000000409,0.96564250606224022]
[539.98000000000411,1.0048927567181831]
[540.96000000000413,0.80525137730437657]
[541.94000000000415,0.41888009864286779]
[542.92000000000417,-5.9037691283699865E-2]
[543.90000000000418,-0.51375075498408063]
[544.8800000000042,-0.83845077548684832]
[545.86000000000422,-0.95925476851034119]
[546.84000000000424,-0.85184328798802333]
[547.82000000000426,-0.54605475547063331]
[548.80000000000427,-0.11766206020988425]
[549.78000000000429,0.33041757701794972]
[550.76000000000431,0.69281619142086959]
[551.74000000000433,0.88639483433254029]
[552.72000000000435,0.8691543144663324]
[553.70000000000437,0.64911925383259661]
[554.68000000000438,0.28138198599338277]
[555.6600000000044,-0.14571227769942471]
[556.64000000000442,-0.53176979076097242]
[557.62000000000444,-0.78785752685522148]
[558.60000000000446,-0.85683543696187714]
[559.58000000000447,-0.72590467067118136]
[560.56000000000449,-0.42867228220208009]
[561.54000000000451,-3.6505273033177202E-2]
[562.52000000000453,0.35859750633019188]
[563.50000000000455,0.66550669790545558]
[564.48000000000457,{"$f":"C$6*COS(RADIANS(D$6*A592-E$6))+C$7*COS(RADIANS(D$7*A592-E$7))+C$8*COS(RADIANS(D$8*A592-E$8))+C$9*COS(RADIANS(D$9*A592-E$9))","v":0.81483298139597682}]
[{"$f":"A592+C$13","v":565.46000000000458},0.77442668642069434]
[566.4400000000046,0.55609610618636385]
[567.42000000000462,0.21219986294348436]
[568.40000000000464,-0.17691431014643244]
[569.38000000000466,-0.5216096976998621]
[570.36000000000467,-0.74346644469612921]
[571.34000000000469,-0.79294042177921287]
[572.32000000000471,-0.66024822265531857]
[573.30000000000473,-0.37713676194713985]
[574.28000000000475,-9.2708037967403623E-3]
[575.26000000000477,0.35893214049262456]
[576.24000000000478,0.64353463208126382]
[577.2200000000048,0.78003559831592961]
[578.20000000000482,0.73781756750533678]
[579.18000000000484,0.52689571447484629]
[580.16000000000486,0.19551396068635002]
[581.14000000000487,-0.18082803793748051]
[582.12000000000489,-0.5164380237154127]
[583.10000000000491,-0.7347656957367521]
[584.08000000000493,-0.78569458038165485]
[585.06000000000495,-0.65693099517199716]
[586.04000000000497,-0.3769329356399046]
[587.02000000000498,-8.6904737525650977E-3]
[588.000000000005,0.36430252339920183]
[588.98000000000502,0.65680044679791127]
[589.96000000000504,0.80111920847162477]
[590.94000000000506,0.7626809483022674]
[591.92000000000507,0.54825132830628542]
[592.90000000000509,0.20491871020018115]
[593.88000000000511,-0.190088281060451]
[594.86000000000513,-0.54658752531053456]
[595.84000000000515,-0.78186073549229029]
[596.82000000000517,-0.83972546411383009]
[597.80000000000518,-0.70389654766470477]
[598.7800000000052,-0.40247291619723136]
[599.76000000000522,-2.3327249360806934E-3]
[600.74000000000524,0.40550696106628292]
[601.72000000000526,0.72641645481978601]
[602.70000000000528,0.88398480373290744]
[603.68000000000529,0.83815293751579822]
[604.66000000000531,0.59536068442137646]
[605.64000000000533,0.20814517723365419]
[606.62000000000535,-0.23600088318829315]
[607.60000000000537,-0.63421305206721268]
[608.58000000000538,-0.89194849659289377]
[609.5600000000054,-0.94536618359758062]
[610.54000000000542,-0.77711281397919418]
[611.52000000000544,-0.42161693057722471]
[612.50000000000546,4.1661764650644431E-2]
[613.48000000000548,0.50579268248334996]
[614.46000000000549,0.86091910655549919]
[615.44000000000551,1.0201900286771266]
[616.42000000000553,0.9409759365375916]
[617.40000000000555,0.6361914180069882]
[618.38000000000557,0.17273559131597518]
[619.36000000000558,-0.34296531506352973]
[620.3400000000056,-0.7892528445110738]
[621.32000000000562,-1.0578617115218145]
[622.30000000000564,-1.0801598514703366]
[623.28000000000566,-0.84464885925085842]
[624.26000000000568,-0.40126964598386294]
[625.24000000000569,0.14891004512293471]
[626.22000000000571,0.67657756187165141]
[627.20000000000573,{"$f":"C$6*COS(RADIANS(D$6*A656-E$6))+C$7*COS(RADIANS(D$7*A656-E$7))+C$8*COS(RADIANS(D$8*A656-E$8))+C$9*COS(RADIANS(D$9*A656-E$9))","v":1.0544888346723584}]
[{"$f":"A656+C$13","v":628.18000000000575},1.1881283467402737]
[629.16000000000577,1.0393337039172292]
[630.14000000000578,0.63698206063068841]
[631.1200000000058,7.1789295917674967E-2]
[632.10000000000582,-0.5239687503314755]
[633.08000000000584,-1.007327884197079]
[634.06000000000586,-1.2589177661385738]
[635.04000000000588,-1.2124401886068639]
[636.02000000000589,-0.87206337719419991]
[637.00000000000591,-0.31318494750604792]
[637.98000000000593,0.33406583800837281]
[638.96000000000595,0.91503360949832346]
[639.94000000000597,1.2874640988215504]
[640.92000000000598,1.3563426976459423]
[641.900000000006,1.0981101061664802]
[642.88000000000602,0.56808814569070298]
[643.86000000000604,-0.11111422579410463]
[644.84000000000606,-0.77785904811302953]
[645.82000000000608,-1.269917221776496]
[646.80000000000609,-1.4639532139998011]
[647.78000000000611,-1.306443196699359]
[648.76000000000613,-0.82827416670697251]
[649.74000000000615,-0.1390770532817891]
[650.72000000000617,0.59778815152803699]
[651.70000000000618,1.2039203280522848]
[652.6800000000062,1.5290848980412024]
[653.66000000000622,1.4884726779503108]
[654.64000000000624,1.084763518082434]
[655.62000000000626,0.40926675254339762]
[656.60000000000628,-0.37858661097537549]
[657.58000000000629,-1.0888336143000574]
[658.56000000000631,-1.5467990216801899]
[659.54000000000633,-1.6360889906489586]
[660.52000000000635,-1.3281675235141783]
[661.50000000000637,-0.69100060445762368]

{"sheet":"Sea level frequency","index":1,"n_rows":49,"n_cols":19,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
["Sea level frequency generator",null,null,null,null,"limited to sites for which harmonic constants are known"]
[]
[null,null,null,"w0","w1","w2","w3"]
[null,null,null,15,14.492054485000001,0.54901415360000005,4.1068638800000001E-2,null,"1. set up tide data in green panel",null,null,null,null,null,null,"Data store"]
[null,null,null,null,null,null,null,null,"2.  set sheet calculation mode to 'manual' for maximum speed"]
[null,null,null,null,"amplitude","frequency","phase",null,"3. launch macro 'sealevelfrequency'"]
[null,null,null,null,"metres","degs/hr","degrees",null,"4. use bin width 0.2 for most locations, 0.5 for high tide locations, for a wide enough distribution"]
[null,null,null,"Cromer:",null,null,null,null,"5. try interval = 0.2 ie sea level at 12 minute intervals",null,null,null,null,null,null,"Aberdeen:"]
[null,null,null,"M2",1.5680000000000001,28.984108970000001,188.11,null,"6. test first with 100 or 1000 points",null,null,null,null,null,null,"M2",1.3009999999999999,28.984108970000001,24.57]
[null,null,null,"S2",0.53300000000000003,30,234.18,null,"7. programme calculates tideheight (as sheet 1) for successive times and allots to frequency 'bins'",null,null,null,null,null,null,"S2",0.44,30,62.88]
[null,null,null,"K1",0.14499999999999999,30.082137277200001,300.95,null,"8.  then run with 45000 points for just over a year of data",null,null,null,null,null,null,"K1",0.113,30.082137277200001,204.56]
[null,null,null,"O1",0.158,27.886080662800001,132.54,null,"9. when finished, copy frequency data in pink columns to sheet 'Tidal smear'",null,null,null,null,null,null,"O1",0.127,27.886080662800001,51.1]
[null,null,null,null,null,null,null,null,"10. also copy site name to sheet 'Tidal smear'"]
[null,null,null,"Z0",2.92,"HAT",5.74,null,null,null,null,null,null,null,null,"Z0",2.5569999999999999,"HAT",4.8499999999999996]
[]
["height",null,null,"bin","midpt","frequency","normalised"]
[2.4000000953674316,"to",2.6000001430511475,1,2.500000037252903,0,{"$f":"F17/F$44","v":0}]
[2.2000000476837158,"to",2.4000000953674316,{"$f":"D17+1","v":2},2.3000000342726707,349,{"$f":"F18/F$44","v":7.7555555555555555E-3},null,null,null,null,null,null,null,null,"Stornoway:"]
[2,"to",2.2000000476837158,3,2.1000000312924385,830,1.8444444444444444E-2,null,null,null,null,null,null,null,null,"M2",1.39,28.984108970000001,197.54]
[1.8000000715255737,"to",2,4,1.9000000283122063,1385,3.0777777777777779E-2,null,null,null,null,null,null,null,null,"S2",0.54500000000000004,30,231.25]
[1.6000000238418579,"to",1.8000000715255737,5,1.700000025331974,1845,4.1000000000000002E-2,null,null,null,null,null,null,null,null,"K1",0.13100000000000001,30.082137277200001,135.34]
[1.3999999761581421,"to",1.6000000238418579,6,1.5000000223517418,2063,4.5844444444444445E-2,null,null,null,null,null,null,null,null,"O1",9.1999999999999998E-2,27.886080662800001,350.12]
[1.2000000476837158,"to",1.3999999761581421,7,1.3000000193715096,2456,5.4577777777777781E-2]
[1,"to",1.2000000476837158,8,1.1000000163912773,2587,5.7488888888888888E-2,null,null,null,null,null,null,null,null,"Z0",2.8929999999999998,"HAT",5.53]
[0.80000001192092896,"to",1,9,0.90000001341104507,2672,5.9377777777777779E-2]
[0.60000002384185791,"to",0.80000001192092896,10,0.70000001043081284,2362,5.248888888888889E-2,null,null,null,null,null,null,null,null,"Cromer:"]
[0.40000000596046448,"to",0.60000002384185791,11,0.5000000074505806,2074,4.6088888888888888E-2,null,null,null,null,null,null,null,null,"M2",1.5680000000000001,{"$f":"2*E$4","v":28.984108970000001},188.11]
[0.20000000298023224,"to",0.40000000596046448,12,0.30000000447034836,1978,4.3955555555555553E-2,null,null,null,null,null,null,null,null,"S2",0.53300000000000003,{"$f":"2*D$4","v":30},234.18]
[0,"to",0.20000000298023224,13,0.10000000149011612,1898,4.2177777777777779E-2,null,null,null,null,null,null,null,null,"K1",0.14499999999999999,{"$f":"2*(E$4+F$4)","v":30.082137277200001},300.95]
[-0.20000000298023224,"to",0,14,-0.10000000149011612,1906,4.2355555555555556E-2,null,null,null,null,null,null,null,null,"O1",0.158,{"$f":"2*(E$4-F$4)","v":27.886080662800001},132.54]
[-0.40000000596046448,"to",-0.20000000298023224,15,-0.30000000447034836,1972,4.3822222222222221E-2]
[-0.60000002384185791,"to",-0.40000000596046448,16,-0.5000000074505806,2070,4.5999999999999999E-2,null,null,null,null,null,null,null,null,"Z0",2.92,"HAT",5.74]
[-0.80000001192092896,"to",-0.60000002384185791,17,-0.70000001043081284,2371,5.2688888888888889E-2]
[-1,"to",-0.80000001192092896,18,-0.90000001341104507,2660,5.9111111111111114E-2]
[-1.2000000476837158,"to",-1,19,-1.1000000163912773,2606,5.7911111111111108E-2,null,"Interval",null,0.2,null,null,null,null,"Heysham:"]
[-1.3999999761581421,"to",-1.2000000476837158,20,-1.3000000193715096,2443,5.4288888888888887E-2,null,"No of data points",null,45000,null,null,null,null,"M2",3.1659999999999999,28.984108970000001,325.68]
[-1.6000000238418579,"to",-1.3999999761581421,21,-1.5000000223517418,2033,4.5177777777777775E-2,null,"Weeks",null,{"$f":"K36*K35/168","v":53.571428571428569},null,null,null,null,"S2",1.0269999999999999,30,8.7200000000000006]
[-1.8000000715255737,"to",-1.6000000238418579,22,-1.700000025331974,1876,4.1688888888888886E-2,null,null,null,null,null,null,null,null,"K1",0.123,30.082137277200001,192.45]
[-2,"to",-1.8000000715255737,23,-1.9000000283122063,1384,3.0755555555555557E-2,null,null,null,null,null,null,null,null,"O1",0.114,27.886080662800001,42.42]
[-2.2000000476837158,"to",-2,24,-2.1000000312924385,824,1.8311111111111111E-2]
[-2.4000000953674316,"to",-2.2000000476837158,25,-2.3000000342726707,356,7.9111111111111118E-3,null,null,null,null,null,null,null,null,"Z0",5.1760000000000002,"HAT",10.76]
[-2.6000001430511475,"to",-2.4000000953674316,26,-2.500000037252903,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Avonmouth:"]
[null,null,null,null,null,{"$f":"SUM(F18:F41)","v":45000},{"$f":"SUM(G18:G41)","v":1.0000000000000002},null,null,null,null,null,null,null,null,"M2",4.2690000000000001,28.984108970000001,200.53]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S2",1.5129999999999999,30,259.91000000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"K1",6.9000000000000006E-2,30.082137277200001,144.06]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"O1",7.4999999999999997E-2,27.886080662800001,3.35]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Z0",6.9550000000000001,"HAT",14.65]

{"sheet":"Tide smear","index":2,"n_rows":163,"n_cols":13,"rows_kept":163,"cut":false,"hidden":false,"merged":[[2,0,2,5],[2,7,2,8],[2,10,2,11]]}
["TIDAL SMEAR OF BIRD DATA"]
[]
["Data store: sea level frequency distributions - data in this panel does not form part of the calculations",null,null,null,null,null,null,"This is the sea level frequency distribution to be smeared",null,null,"This is the unsmeared flight height distribution",null,"This is the tide-smeared output"]
["bin width:",0.2,0.2,0.4,0.5,0.2,null,"Cromer:",null,null,"Bird data"]
[null,"Aberdeen","Cromer","Heysham","Avonmouth","Stornoway",null,"tide height","normalised freq",null,"KITTIWAKE","original flight height distribution","tide-smeared distribution"]
[null,0,0,0,0,0,null,2.500000037252903,0,null,null,null,"Cromer:"]
[null,0,7.7555555555555555E-3,0,1.7933333333333332E-2,0,null,2.3000000342726707,7.7555555555555555E-3,null,"height (m)"]
[null,0,1.8444444444444444E-2,1.7000000000000001E-2,3.4066666666666669E-2,4.2222222222222218E-3,null,2.1000000312924385,1.8444444444444444E-2,null,0,8.5709999999999995E-2]
[null,3.3333333333333332E-4,3.0777777777777779E-2,3.8266666666666664E-2,3.6355555555555558E-2,2.1399999999999999E-2,null,1.9000000283122063,3.0777777777777779E-2,null,{"$f":"K8+1","v":1},7.85E-2]
[null,3.1933333333333334E-2,4.1000000000000002E-2,4.1688888888888886E-2,3.9333333333333331E-2,4.0444444444444443E-2,null,1.700000025331974,4.1000000000000002E-2,null,2,7.1749999999999994E-2]
[null,4.7399999999999998E-2,4.5844444444444445E-2,4.6422222222222219E-2,4.3333333333333335E-2,4.3533333333333334E-2,null,1.5000000223517418,4.5844444444444445E-2,null,3,6.5259999999999999E-2]
[null,5.3133333333333331E-2,5.4577777777777781E-2,5.3288888888888886E-2,5.0511111111111111E-2,4.8644444444444442E-2,null,1.3000000193715096,5.4577777777777781E-2,null,4,5.987E-2,{"$f":"tidesmear(K12,\"birddata\")","v":6.0390181839466095E-2}]
[null,6.2288888888888887E-2,5.7488888888888888E-2,6.7822222222222228E-2,6.6222222222222224E-2,5.686666666666667E-2,null,1.1000000163912773,5.7488888888888888E-2,null,5,5.4989999999999997E-2,{"$f":"tidesmear(K13,\"birddata\")","v":5.5482096970081329E-2}]
[null,8.2866666666666672E-2,5.9377777777777779E-2,5.8733333333333332E-2,5.0177777777777779E-2,6.8133333333333337E-2,null,0.90000001341104507,5.9377777777777779E-2,null,6,5.0950000000000002E-2,{"$f":"tidesmear(K14,\"birddata\")","v":5.1005225628614426E-2}]
[null,6.5000000000000002E-2,5.248888888888889E-2,4.7800000000000002E-2,4.371111111111111E-2,6.5511111111111117E-2,null,0.70000001043081284,5.248888888888889E-2,null,7,4.6800000000000001E-2,{"$f":"tidesmear(K15,\"birddata\")","v":4.6860232949256897E-2}]
[null,5.5599999999999997E-2,4.6088888888888888E-2,4.4755555555555555E-2,4.0800000000000003E-2,5.3999999999999999E-2,null,0.5000000074505806,4.6088888888888888E-2,null,8,4.2630000000000001E-2,4.2994935065507889E-2]
[null,5.1377777777777779E-2,4.3955555555555553E-2,4.2755555555555554E-2,3.9311111111111109E-2,4.9022222222222224E-2,null,0.30000000447034836,4.3955555555555553E-2,null,9,3.9070000000000001E-2,3.9378497749567032E-2]
[null,4.9933333333333337E-2,4.2177777777777779E-2,4.1155555555555556E-2,3.8555555555555558E-2,4.8066666666666667E-2,null,0.10000000149011612,4.2177777777777779E-2,null,10,3.5900000000000001E-2,3.606048971414566E-2]
[null,5.0044444444444447E-2,4.2355555555555556E-2,4.097777777777778E-2,3.8444444444444448E-2,4.8177777777777778E-2,null,-0.10000000149011612,4.2355555555555556E-2,null,11,3.2930000000000001E-2,3.3023826777935028E-2]
[null,5.1444444444444445E-2,4.3822222222222221E-2,4.2222222222222223E-2,3.9066666666666666E-2,4.9244444444444445E-2,null,-0.30000000447034836,4.3822222222222221E-2,null,12,2.997E-2,3.0222587287425995E-2]
[null,5.5333333333333332E-2,4.5999999999999999E-2,4.4999999999999998E-2,4.0733333333333337E-2,5.4022222222222221E-2,null,-0.5000000074505806,4.5999999999999999E-2,null,13,2.7470000000000001E-2,2.7627799659967422E-2]
[null,6.4977777777777773E-2,5.2688888888888889E-2,4.8022222222222223E-2,4.3733333333333332E-2,6.54E-2,null,-0.70000001043081284,5.2688888888888889E-2,null,14,2.5049999999999999E-2,2.5296976789832115E-2]
[null,8.3333333333333329E-2,5.9111111111111114E-2,5.8888888888888886E-2,5.0066666666666669E-2,6.8066666666666664E-2,null,-0.90000001341104507,5.9111111111111114E-2,null,15,2.3050000000000001E-2,2.3171251639723778E-2]
[null,6.2044444444444444E-2,5.7911111111111108E-2,6.8222222222222226E-2,6.6133333333333336E-2,5.7066666666666668E-2,null,-1.1000000163912773,5.7911111111111108E-2,null,16,2.1180000000000001E-2,2.1220678463578224E-2]
[null,5.2822222222222222E-2,5.42888888888889E-2,5.3844444444444445E-2,5.0555555555555555E-2,4.873333333333333E-2,null,-1.3000000193715096,5.4288888888888887E-2,null,17,1.9290000000000002E-2,1.9398342818021774E-2]
[null,4.7800000000000002E-2,4.5177777777777775E-2,4.5977777777777777E-2,4.3577777777777778E-2,4.371111111111111E-2,null,-1.5000000223517418,4.5177777777777775E-2,null,18,1.7649999999999999E-2,1.7597157508134842E-2]
[null,3.1977777777777779E-2,4.1688888888888886E-2,4.1377777777777777E-2,3.8866666666666667E-2,0.04,null,-1.700000025331974,4.1688888888888886E-2,null,19,1.5869999999999999E-2,1.5846269205212593E-2]
[null,3.5555555555555557E-4,3.0755555555555557E-2,3.8666666666666669E-2,3.6311111111111113E-2,2.1444444444444443E-2,null,-1.9000000283122063,3.0755555555555557E-2,null,20,1.3979999999999999E-2,1.4187433756887913E-2]
[null,0,1.8311111111111111E-2,1.708888888888889E-2,3.4466666666666666E-2,4.288888888888889E-3,null,-2.1000000312924385,1.8311111111111111E-2,null,21,1.247E-2,1.2639562599360943E-2]
[null,0,7.9111111111111118E-3,2.2222222222222223E-5,1.7733333333333334E-2,0,null,-2.3000000342726707,7.9111111111111118E-3,null,22,1.115E-2,1.1275669559836388E-2]
[null,0,0,0,0,0,null,-2.500000037252903,0,null,23,9.9900000000000006E-3,1.0087271220982075E-2]
[null,null,null,null,null,null,null,null,null,null,24,8.9499999999999996E-3,9.0226605534553528E-3]
[null,null,"1.  Copy in sea level frequency data (pink) from Sheet Sea Level Frequency",null,null,null,null,null,null,null,25,8.0099999999999998E-3,8.0554960295557976E-3]
[null,null,"2. Check that Range 'tidefreq' is H6:I31",null,null,null,null,null,null,null,26,7.1000000000000004E-3,7.1834982372820377E-3]
[null,null,"3. Copy in bird distribution data (eg from Cook et al) to columns K and L",null,null,null,null,null,null,null,27,6.3099999999999996E-3,6.3899974338710308E-3]
[null,null,"4. Check that Range \"gannetdata\" (or whatever name you choose) is K8 to L158",null,null,null,null,null,null,null,28,5.6499999999999996E-3,5.6743877939879894E-3]
[null,null,"5. In column M, set up formulae  eg =tidesmear(k21,\"gannetdata\") in row 21 ",null,null,null,null,null,null,null,29,4.96E-3,5.043612327426672E-3]
[null,null,"6. Do not use formulae that go beyond the bounds, ie if tidal range is +/- 4m, then start at 4m to 146m",null,null,null,null,null,null,null,30,4.4400000000000004E-3,4.4665210880339146E-3]
[null,null,"7. Press calculate",null,null,null,null,null,null,null,31,3.9100000000000003E-3,3.953784704208374E-3]
[null,null,"8. Now copy new distribution D~(Y) (in blue) into collision risk spreadsheet 'Flightheight'",null,null,null,null,null,null,null,32,3.4499999999999999E-3,3.4981933422386646E-3]
[null,null,null,null,null,null,null,null,null,null,33,3.0500000000000002E-3,3.0909131746739149E-3]
[null,null,null,null,null,null,null,null,null,null,34,2.7100000000000002E-3,2.7337302453815937E-3]
[null,null,null,null,null,null,null,null,null,null,35,2.3800000000000002E-3,2.4193387944251299E-3]
[null,null,null,null,null,null,null,null,null,null,36,2.1299999999999999E-3,2.1343217231333256E-3]
[null,null,null,null,null,null,null,null,null,null,37,1.8500000000000001E-3,1.8853588262572885E-3]
[null,null,null,null,null,null,null,null,null,null,38,1.64E-3,1.662167371250689E-3]
[null,null,null,null,null,null,null,null,null,null,39,1.4499999999999999E-3,1.4660382876172662E-3]
[null,null,null,null,null,null,null,null,null,null,40,1.2800000000000001E-3,1.2971519026905298E-3]
[null,null,null,null,null,null,null,null,null,null,41,1.1299999999999999E-3,1.1521289125084877E-3]
[null,null,null,null,null,null,null,null,null,null,42,1.01E-3,1.0269792983308434E-3]
[null,null,null,null,null,null,null,null,null,null,43,9.2000000000000003E-4,9.1510236961767077E-4]
[null,null,null,null,null,null,null,null,null,null,44,8.0999999999999996E-4,8.152984082698822E-4]
[null,null,null,null,null,null,null,null,null,null,45,7.1000000000000002E-4,7.2163320146501064E-4]
[null,null,null,null,null,null,null,null,null,null,46,6.3000000000000003E-4,6.3402933301404119E-4]
[null,null,null,null,null,null,null,null,null,null,47,5.5000000000000003E-4,5.566613981500268E-4]
[null,null,null,null,null,null,null,null,null,null,48,4.8000000000000001E-4,4.8909086035564542E-4]
[null,null,null,null,null,null,null,null,null,null,49,4.2000000000000002E-4,4.3048596126027405E-4]
[null,null,null,null,null,null,null,null,null,null,50,3.8000000000000002E-4,3.8008528645150363E-4]
[null,null,null,null,null,null,null,null,null,null,51,3.3E-4,3.3785059349611402E-4]
[null,null,null,null,null,null,null,null,null,null,52,2.9999999999999997E-4,2.9876769986003637E-4]
[null,null,null,null,null,null,null,null,null,null,53,2.5999999999999998E-4,2.6522227562963963E-4]
[null,null,null,null,null,null,null,null,null,null,54,2.3000000000000001E-4,2.351797156734392E-4]
[null,null,null,null,null,null,null,null,null,null,55,2.1000000000000001E-4,2.0753424905706197E-4]
[null,null,null,null,null,null,null,null,null,null,56,1.8000000000000001E-4,1.8518183787818998E-4]
[null,null,null,null,null,null,null,null,null,null,57,1.6000000000000001E-4,1.6518100164830685E-4]
[null,null,null,null,null,null,null,null,null,null,58,1.4999999999999999E-4,1.4745144289918244E-4]
[null,null,null,null,null,null,null,null,null,null,59,1.2999999999999999E-4,1.3262811989989132E-4]
[null,null,null,null,null,null,null,null,null,null,60,1.2E-4,1.1741006892407313E-4]
[null,null,null,null,null,null,null,null,null,null,61,1E-4,1.0390562238171697E-4]
[null,null,null,null,null,null,null,null,null,null,62,9.0000000000000006E-5,9.1317197075113654E-5]
[null,null,null,null,null,null,null,null,null,null,63,8.0000000000000007E-5,8.1317935837432742E-5]
[null,null,null,null,null,null,null,null,null,null,64,6.9999999999999994E-5,7.3863797297235578E-5]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K72+1","v":65},6.9999999999999994E-5,6.6175554820802063E-5]
[null,null,null,null,null,null,null,null,null,null,66,6.0000000000000002E-5,5.9999776567565277E-5]
[null,null,null,null,null,null,null,null,null,null,67,5.0000000000000002E-5,5.3864132496528327E-5]
[null,null,null,null,null,null,null,null,null,null,68,5.0000000000000002E-5,4.7411020204890519E-5]
[null,null,null,null,null,null,null,null,null,null,69,4.0000000000000003E-5,{"$f":"tidesmear(K77,\"birddata\")","v":4.2629399104043841E-5}]
[null,null,null,null,null,null,null,null,null,null,70,4.0000000000000003E-5,3.741135515156202E-5]
[null,null,null,null,null,null,null,null,null,null,71,3.0000000000000001E-5,3.3906911994563416E-5]
[null,null,null,null,null,null,null,null,null,null,72,3.0000000000000001E-5,3.1234398193191737E-5]
[null,null,null,null,null,null,null,null,null,null,73,3.0000000000000001E-5,2.8764199669240043E-5]
[null,null,null,null,null,null,null,null,null,null,74,3.0000000000000001E-5,2.6134910513064824E-5]
[null,null,null,null,null,null,null,null,null,null,75,2.0000000000000002E-5,2.386519918218255E-5]
[null,null,null,null,null,null,null,null,null,null,76,2.0000000000000002E-5,2.1276444385875948E-5]
[null,null,null,null,null,null,null,null,null,null,77,2.0000000000000002E-5,2.0041710740770213E-5]
[null,null,null,null,null,null,null,null,null,null,78,2.0000000000000002E-5,1.9999999494757503E-5]
[null,null,null,null,null,null,null,null,null,null,79,2.0000000000000002E-5,1.9999999494757503E-5]
[null,null,null,null,null,null,null,null,null,null,80,2.0000000000000002E-5,1.9999999494757503E-5]
[null,null,null,null,null,null,null,null,null,null,81,2.0000000000000002E-5,1.9999999494757503E-5]
[null,null,null,null,null,null,null,null,null,null,82,2.0000000000000002E-5,1.9999999494757503E-5]
[null,null,null,null,null,null,null,null,null,null,83,2.0000000000000002E-5,1.9999999494757503E-5]
[null,null,null,null,null,null,null,null,null,null,84,2.0000000000000002E-5,1.9999999494757503E-5]
[null,null,null,null,null,null,null,null,null,null,85,2.0000000000000002E-5,1.9999999494757503E-5]
[null,null,null,null,null,null,null,null,null,null,86,2.0000000000000002E-5,1.9999999494757503E-5]
[null,null,null,null,null,null,null,null,null,null,87,2.0000000000000002E-5,1.9999999494757503E-5]
[null,null,null,null,null,null,null,null,null,null,88,2.0000000000000002E-5,1.9999999494757503E-5]
[null,null,null,null,null,null,null,null,null,null,89,2.0000000000000002E-5,1.9999999494757503E-5]
[null,null,null,null,null,null,null,null,null,null,90,2.0000000000000002E-5,1.9999999494757503E-5]
[null,null,null,null,null,null,null,null,null,null,91,2.0000000000000002E-5,1.9999999494757503E-5]
[null,null,null,null,null,null,null,null,null,null,92,2.0000000000000002E-5,1.9999999494757503E-5]
[null,null,null,null,null,null,null,null,null,null,93,2.0000000000000002E-5,1.9999999494757503E-5]
[null,null,null,null,null,null,null,null,null,null,94,2.0000000000000002E-5,1.9999999494757503E-5]
[null,null,null,null,null,null,null,null,null,null,95,2.0000000000000002E-5,1.9999999494757503E-5]
[null,null,null,null,null,null,null,null,null,null,96,2.0000000000000002E-5,1.9957955373683944E-5]
[null,null,null,null,null,null,null,null,null,null,97,2.0000000000000002E-5,1.876453279692214E-5]
[null,null,null,null,null,null,null,null,null,null,98,2.0000000000000002E-5,1.7412421584594995E-5]
[null,null,null,null,null,null,null,null,null,null,99,1.0000000000000001E-5,1.773028816387523E-5]
[null,null,null,null,null,null,null,null,null,null,100,2.0000000000000002E-5,1.7411244698450901E-5]
[null,null,null,null,null,null,null,null,null,null,101,2.0000000000000002E-5,1.8765265849651769E-5]
[null,null,null,null,null,null,null,null,null,null,102,2.0000000000000002E-5,1.9916244127671234E-5]
[null,null,null,null,null,null,null,null,null,null,103,2.0000000000000002E-5,1.8722488675848581E-5]
[null,null,null,null,null,null,null,null,null,null,104,2.0000000000000002E-5,1.6176954886759631E-5]
[null,null,null,null,null,null,null,null,null,null,105,1.0000000000000001E-5,1.5142711163207423E-5]
[null,null,null,null,null,null,null,null,null,null,106,1.0000000000000001E-5,1.5141533367568627E-5]
[null,null,null,null,null,null,null,null,null,null,107,2.0000000000000002E-5,1.6176511053345166E-5]
[null,null,null,null,null,null,null,null,null,null,108,2.0000000000000002E-5,1.8723554603639059E-5]
[null,null,null,null,null,null,null,null,null,null,109,2.0000000000000002E-5,1.9958288248744793E-5]
[null,null,null,null,null,null,null,null,null,null,110,2.0000000000000002E-5,1.9957955373683944E-5]
[null,null,null,null,null,null,null,null,null,null,111,2.0000000000000002E-5,1.8722488675848581E-5]
[null,null,null,null,null,null,null,null,null,null,112,2.0000000000000002E-5,1.6134910765686072E-5]
[null,null,null,null,null,null,null,null,null,null,113,1.0000000000000001E-5,1.3865199434803799E-5]
[null,null,null,null,null,null,null,null,null,null,114,1.0000000000000001E-5,1.1276444638497196E-5]
[null,null,null,null,null,null,null,null,null,null,115,1.0000000000000001E-5,1.0041710993391462E-5]
[null,null,null,null,null,null,null,null,null,null,116,1.0000000000000001E-5,9.9999997473787516E-6]
[null,null,null,null,null,null,null,null,null,null,117,1.0000000000000001E-5,9.9999997473787516E-6]
[null,null,null,null,null,null,null,null,null,null,118,1.0000000000000001E-5,9.9999997473787516E-6]
[null,null,null,null,null,null,null,null,null,null,119,1.0000000000000001E-5,9.9999997473787516E-6]
[null,null,null,null,null,null,null,null,null,null,120,1.0000000000000001E-5,9.9999997473787516E-6]
[null,null,null,null,null,null,null,null,null,null,121,1.0000000000000001E-5,9.9999997473787516E-6]
[null,null,null,null,null,null,null,null,null,null,122,1.0000000000000001E-5,9.9999997473787516E-6]
[null,null,null,null,null,null,null,null,null,null,123,1.0000000000000001E-5,9.9999997473787516E-6]
[null,null,null,null,null,null,null,null,null,null,124,1.0000000000000001E-5,9.9999997473787516E-6]
[null,null,null,null,null,null,null,null,null,null,125,1.0000000000000001E-5,9.9999997473787516E-6]
[null,null,null,null,null,null,null,null,null,null,126,1.0000000000000001E-5,9.9999997473787516E-6]
[null,null,null,null,null,null,null,null,null,null,127,1.0000000000000001E-5,9.9999997473787516E-6]
[null,null,null,null,null,null,null,null,null,null,128,1.0000000000000001E-5,9.9999997473787516E-6]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K136+1","v":129},1.0000000000000001E-5,9.9999997473787516E-6]
[null,null,null,null,null,null,null,null,null,null,130,1.0000000000000001E-5,9.9999997473787516E-6]
[null,null,null,null,null,null,null,null,null,null,131,1.0000000000000001E-5,9.9999997473787516E-6]
[null,null,null,null,null,null,null,null,null,null,132,1.0000000000000001E-5,9.9999997473787516E-6]
[null,null,null,null,null,null,null,null,null,null,133,1.0000000000000001E-5,{"$f":"tidesmear(K141,\"birddata\")","v":9.9999997473787516E-6}]
[null,null,null,null,null,null,null,null,null,null,134,1.0000000000000001E-5,9.9999997473787516E-6]
[null,null,null,null,null,null,null,null,null,null,135,1.0000000000000001E-5,9.9999997473787516E-6]
[null,null,null,null,null,null,null,null,null,null,136,1.0000000000000001E-5,9.9999997473787516E-6]
[null,null,null,null,null,null,null,null,null,null,137,1.0000000000000001E-5,9.9579538073157892E-6]
[null,null,null,null,null,null,null,null,null,null,138,1.0000000000000001E-5,8.7224871094804257E-6]
[null,null,null,null,null,null,null,null,null,null,139,1.0000000000000001E-5,6.1349123825493734E-6]
[null,null,null,null,null,null,null,null,null,null,140,0,3.8651987779303454E-6]
[null,null,null,null,null,null,null,null,null,null,141,0,1.2764464827341726E-6]
[null,null,null,null,null,null,null,null,null,null,142,0,4.17124752516429E-8]
[null,null,null,null,null,null,null,null,null,null,143,0,0]
[null,null,null,null,null,null,null,null,null,null,144,0,0]
[null,null,null,null,null,null,null,null,null,null,145,0,0]
[null,null,null,null,null,null,null,null,null,null,146,0,0]
[null,null,null,null,null,null,null,null,null,null,147,0]
[null,null,null,null,null,null,null,null,null,null,148,0]
[null,null,null,null,null,null,null,null,null,null,149,0]
[null,null,null,null,null,null,null,null,null,null,150,0]
[null,null,null,null,null,null,null,null,null,null,151,0]
[null,null,null,null,null,null,null,null,null,null,152,0]
[null,null,null,null,null,null,null,null,null,null,153,0]
[null,null,null,null,null,null,null,null,null,null,154,0]
[null,null,null,null,null,null,null,null,null,null,155,0]