{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["CD","DR","Tide","ETA","WIND","Rise&Set","cal"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"CD","index":0,"n_rows":4,"n_cols":9,"rows_kept":4,"cut":false,"hidden":false,"merged":[[1,8,2,8],[0,1,0,3],[0,4,0,6],[1,7,2,7]]}
[null,"lat",null,null,"Long",null,null,"Co.","Dist."]
["Dep.",35,10.42,"N",179,48.11,"W",{"$f":"cal!E19","v":181.99394952895128},{"$f":"cal!F19","v":1931.5895642382388}]
["Arr.",3,0,"n",179,0,"e"]
["Pass.",20,34.64,"S",{"$f":"IF(cal!C51<0,cal!C50*-1,cal!C50)","v":178},{"$f":"IF(cal!C51<0,cal!D50*-1,cal!D50)","v":10.119999999999999},{"$f":"IF(cal!C51<0,\"W\",\"E\")","v":"E"},"Fm Dep.",{"$f":"cal!F50","v":3347.0866380118123}]

{"sheet":"DR","index":1,"n_rows":6,"n_cols":8,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,0,2,0],[4,1,4,2],[4,5,4,6],[0,7,2,7],[0,6,1,6],[0,2,0,4],[1,2,1,4],[4,3,4,4]]}
["Time","Fm","2006-08-30",null,null,"02:27:00",{"$f":"IF(AND(C3=\"\",E3=\"\"),\"*\",\"\")","v":""},"←\nどちらかを入力\n←"]
[null,"To","2006-08-31",null,null,"19:00:00"]
[null,"For",1,"h",null,"min",{"$f":"IF(OR(C3<>\"\",E3<>\"\"),\"*\",\"\")","v":"*"}]
["Position",3,0,"n",179,0,"e"]
["Co.",350,null,"Speed",null,40]
["DR Positioin",{"$f":"IF(cal!J3<0,cal!J3*-1,cal!J3)","v":35},{"$f":"IF(cal!K3<0,cal!K3*-1,cal!K3)","v":10.42},{"$f":"IF(cal!J3<0,\"S\",\"N\")","v":"N"},{"$f":"IF(cal!L3<0,cal!L3*-1,cal!L3)","v":179},{"$f":"IF(cal!M3<0,cal!M3*-1,cal!M3)","v":48.11},{"$f":"IF(cal!L3<0,\"W\",\"E\")","v":"W"}]

{"sheet":"Tide","index":2,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,0,1,0],[2,0,4,0]]}
["標準港","Hight",37,"cm"]
[null,"Z0",1.38,"m"]
["調査港","Ratio",1.1100000000000001]
[null,"Z0",1.3,"m"]
[null,"Hight",{"$f":"(C1/100-C2)*C3+C4","v":0.17890000000000028},"m"]

{"sheet":"ETA","index":3,"n_rows":26,"n_cols":9,"rows_kept":26,"cut":false,"hidden":false,"merged":[[9,0,10,0],[6,4,6,6],[7,4,7,6],[6,1,6,3],[7,1,7,3],[4,0,7,0],[5,4,5,6],[25,1,25,6],[13,5,13,6],[21,1,21,6],[22,1,22,6],[23,1,23,6],[24,1,24,6],[20,1,20,6],[14,1,14,6],[15,1,15,6],[16,1,16,6],[17,1,17,6],[18,1,18,6],[19,1,19,6],[2,2,2,3],[0,2,0,3],[13,1,13,2],[13,3,13,4],[12,1,12,6],[8,1,8,6],[9,1,9,3],[1,1,1,3],[1,5,1,6],[5,1,5,3],[9,4,9,6],[10,1,10,3],[10,4,10,6]]}
["ETA","2022-11-01","02:00:00",null,"UTC",8,"h",null,{"$f":"(B1+C1)-F1/24","v":"2022-10-31T18:00:00"}]
["S/B hrs & dist","01:00:00",null,null,12,"miles",null,null,{"$f":"I1-B2","v":"2022-10-31T17:00:00"}]
["DATE","2022-10-23","06:00:00",null,"UTC",9,"h",null,{"$f":"(B3+C3)-F3/24","v":"2022-10-22T21:00:00"}]
["Position",35,10.42,"N",179,48.11,"W"]
["Next\nWay Point",32,0.5,"N",132,17,"E"]
[null,"Dist. to P.S.",null,null,120]
[null,"Co. to W.P.",null,null,{"$f":"cal!E35","v":265.48552380242609}]
[null,"Dist. to W.P.",null,null,{"$f":"cal!F35","v":2412.8783568776657}]
["Dist. to P.S.",{"$f":"E6+E8","v":2532.8783568776657}]
["REM. to S/B","hrs",null,null,{"$f":"I10","v":"8-20-0"},null,null,null,{"$f":"CONCATENATE(INT(I2-I3),\"-\",HOUR(I2-I3),\"-\",MINUTE(I2-I3))","v":"8-20-0"}]
[null,"dist.",null,null,{"$f":"B9-E2","v":2520.8783568776657},null,null,null,{"$f":"(E6+E8)-E2","v":2520.8783568776657}]
[]
["REQ. SPEED",{"$f":"I13","v":11.890935645646103},null,null,null,null,null,null,{"$f":"I11/I14","v":11.890935645646103}]
["ETA","Speed  >",null,18,null,"kt's",null,null,{"$f":"(I2-I3)*24","v":212.00000000005821}]
[{"$f":"D14","v":18},{"$f":"I15","v":"2022-10-29T02:02:55.671"},null,null,null,null,null,null,{"$f":"($I$11/A15)/24+$I$3+$F$1/24+$B$2","v":"2022-10-29T02:02:55.671"}]
[{"$f":"A15+0.25","v":18.25},{"$f":"I16","v":"2022-10-29T00:07:49.155"},null,null,null,null,null,null,"2022-10-29T00:07:49.155"]
[{"$f":"A16+0.25","v":18.5},"2022-10-28T22:15:49.302",null,null,null,null,null,null,"2022-10-28T22:15:49.302"]
[18.75,"2022-10-28T20:26:48.645",null,null,null,null,null,null,"2022-10-28T20:26:48.645"]
[19,"2022-10-28T18:40:40.110",null,null,null,null,null,null,"2022-10-28T18:40:40.110"]
[19.25,"2022-10-28T16:57:16.991",null,null,null,null,null,null,"2022-10-28T16:57:16.991"]
[19.5,"2022-10-28T15:16:32.927",null,null,null,null,null,null,"2022-10-28T15:16:32.927"]
[19.75,"2022-10-28T13:38:21.878",null,null,null,null,null,null,"2022-10-28T13:38:21.878"]
[20,"2022-10-28T12:02:38.104",null,null,null,null,null,null,"2022-10-28T12:02:38.104"]
[20.25,"2022-10-28T10:29:16.152",null,null,null,null,null,null,"2022-10-28T10:29:16.152"]
[20.5,"2022-10-28T08:58:10.833",null,null,null,null,null,null,"2022-10-28T08:58:10.833"]
[20.75,"2022-10-28T07:29:17.209",null,null,null,null,null,null,"2022-10-28T07:29:17.209"]

{"sheet":"WIND","index":4,"n_rows":38,"n_cols":7,"rows_kept":38,"cut":false,"hidden":false,"merged":[[5,2,5,3],[7,2,7,3],[0,0,1,0],[2,0,3,0],[4,0,7,0],[4,1,5,1]]}
["Rela.\nWind","Dir",45,"deg",{"$f":"IF(G1<D22,1,IF(G1<D23,2,IF(G1<D24,3,4)))","v":2},null,{"$f":"ABS(SIN(RADIANS(C1/2)))","v":0.38268343236508978}]
[null,"Speed",15,"kts",{"$f":"C2/3600*1852","v":7.7166666666666668}]
["Ship","Co",90,"deg"]
[null,"Speed",13,"kts"]
["True\nWind","Dir",{"$f":"B19","v":192.71592190031151},"deg",{"$f":"IF(G5<H5,1,IF(G5<H6,2,IF(G5<H7,3,4)))","v":4},null,{"$f":"ABS(SIN(RADIANS(B18/2)))","v":0.78106250926190712}]
[null,null,{"$f":"VLOOKUP(G6,A22:B38,2,FALSE)","v":"SSW"},null,null,null,{"$f":"ROUND(C5/22.5,0)","v":9}]
[null,"Speed",{"$f":"B17","v":10.873286317266118},"kts",{"$f":"C7/3600*1852","v":5.5937017387713466}]
[null,"BF",{"$f":"IF(B17<=16,C22,IF(B17<=40,C23,C24))","v":4}]
[]
["wind",{"$f":"C2","v":15}]
["deg",{"$f":"IF(C1=0,C1+360,C1)","v":45},{"$f":"RADIANS(B11)","v":0.78539816339744828}]
["Speed",{"$f":"C4","v":13}]
["Co",{"$f":"IF(C3=0,C3+360,C3)","v":90}]
["a",{"$f":"B10*SIN(C11)","v":10.606601717798211}]
["b",{"$f":"B10*COS(C11)","v":10.606601717798213}]
["c",{"$f":"B15-B12","v":-2.3933982822017867}]
["True ",{"$f":"B16/COS(C18)","v":10.873286317266118}]
["deg",{"$f":"IF(C18<0,DEGREES(C18)+360,DEGREES(C18))","v":102.71592190031153},{"$f":"ATAN2(B16,B14)","v":1.7927310313817868}]
[null,{"$f":"IF(C19>=360,C19-360,C19)","v":192.71592190031151},{"$f":"B13+B18","v":192.71592190031151}]
[]
["dir1","dir2","BF","Rel"]
[0,"NORTH",{"$f":"IF(B17<1,0,IF(B17<=3,1,IF(B17<=6,2,IF(B17<=10,3,4))))","v":4},{"$f":"SIN(RADIANS(11))","v":0.1908089953765448}]
[1,"NNE",{"$f":"IF(B17<=21,5,IF(B17<=27,6,IF(B17<=33,7,8)))","v":5},{"$f":"SIN(RADIANS(34))","v":0.5591929034707469}]
[2,"NE",{"$f":"IF(B17<=47,9,IF(B17<=55,10,IF(B17<=63,11,12)))","v":9},{"$f":"SIN(RADIANS(56))","v":0.82903757255504174}]
[3,"ENE"]
[4,"EAST"]
[5,"ESE"]
[6,"SE"]
[7,"SSE"]
[8,"SOUTH"]
[9,"SSW"]
[10,"SW"]
[11,"WSW"]
[12,"WEST"]
[13,"WNW"]
[14,"NW"]
[15,"NNW"]
[16,"NORTH"]

{"sheet":"Rise&Set","index":5,"n_rows":22,"n_cols":9,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,0,4,0],[3,1,3,4],[4,1,4,2],[4,3,4,4],[8,2,8,3],[12,2,12,3],[5,0,6,0],[5,3,5,4],[6,1,6,2],[6,3,6,4]]}
["Diff.","UTC",null,8,"h",null,null,"Time","Dir."]
["lat",8,null,45.8,"s",null,"Rise",{"$f":"E19","v":"06:36:56.747"},{"$f":"F19","v":67.633372685395372}]
["Long",115,null,43.3,"e",null,"Set",{"$f":"E20","v":"18:08:14.853"},{"$f":"F20","v":292.36662731460461}]
["E","11:54:31"]
[null,"p.p",null,"00:00:00",null,null,"<常用日出没>"]
["d","n",22,5.5,null,null,"眼高","Rise",{"$f":"E21","v":"06:32:59.540"}]
[null,"p.p",null,0,null,null,0,"Set",{"$f":"E22","v":"18:12:12.060"}]
[]
["E",null,{"$f":"(B4+D5)*24","v":11.908611111111112}]
["d",null,{"$f":"C6+(D6+D7)/60","v":22.091666666666665},{"$f":"IF(OR(B6=\"S\",B6=\"s\"),C10*-1,C10)","v":22.091666666666665}]
["l",null,{"$f":"IF(OR(E2=\"s\",E2=\"S\"), (B2+(D2/60))*-1,B2+(D2/60))","v":-8.7633333333333336}]
["L",null,{"$f":"IF(OR(E3=\"w\",E3=\"W\"),(B3+(D3/60))*-1,B3+(D3/60))","v":115.72166666666666}]
["L-ZONE",null,{"$f":"C12/15-D1","v":-0.28522222222222204}]
["眼高",null,{"$f":"G7","v":0},{"$f":"1.776*SQRT(C14)","v":0}]
["大気差",null,54.2,"⊿H",{"$f":"((C15+D14)/60)/(COS(RADIANS(C11))*COS(RADIANS(D10))*SIN(C18))","v":0.98835977696655175},{"$f":"E15/15","v":6.5890651797770122E-2}]
["MAX",null,{"$f":"IF(C9>=0, 24-C9, ABS(C9))","v":12.091388888888888},null,{"$f":"C16/24","v":"12:05:29"}]
["MAX ST",null,{"$f":"C16-C13","v":12.37661111111111},null,{"$f":"C17/24","v":"12:22:35.800"}]
["H.A.",null,{"$f":"ACOS(-TAN(RADIANS(C11))*TAN(RADIANS(D10)))","v":1.5081865225313262},{"$f":"DEGREES(C18)/15","v":5.7608481639704818}]
["SUN RISE",null,{"$f":"C16-D18","v":6.3305407249184062},{"$f":"C19-C13","v":6.6157629471406283},{"$f":"D19/24","v":"06:36:56.747"},{"$f":"IF(AND(I19>=0,H22<=90),H22,H21)","v":67.633372685395372},true,{"$f":"-COS(RADIANS(D10))*SIN(-C18)","v":0.92476783625366188},{"$f":"SIN(RADIANS(D10))/COS(RADIANS(C11))","v":0.38053179766048528}]
["SUN SET",null,{"$f":"C16+D18","v":17.852237052859369},{"$f":"C20-C13","v":18.137459275081589},{"$f":"D20/24","v":"18:08:14.853"},{"$f":"360-F19","v":292.36662731460461},true,{"$f":"-COS(RADIANS(D10))*SIN(C18)","v":-0.92476783625366188}]
["SUN RISE",null,{"$f":"D19-F15","v":6.5498722953428583},null,{"$f":"C21/24","v":"06:32:59.540"},null,"常用",{"$f":"IF(H22<0,-180-H22,180-H22)","v":112.36662731460463}]
["SUN SET",null,{"$f":"D20+F15","v":18.203349926879358},null,{"$f":"C22/24","v":"18:12:12.060"},null,"常用",{"$f":"DEGREES(ASIN(H19))","v":67.633372685395372}]

{"sheet":"cal","index":6,"n_rows":60,"n_cols":13,"rows_kept":60,"cut":false,"hidden":true,"merged":[[50,9,50,10],[17,0,17,1],[17,2,17,3],[19,0,19,1],[19,2,19,3],[33,2,33,3],[1,11,1,12],[1,6,1,7],[1,2,1,3],[1,0,1,1],[1,9,1,10],[48,0,48,1],[48,2,48,3],[50,0,50,1],[50,2,50,3],[21,0,21,1],[21,2,21,3],[37,0,37,1],[37,2,37,3],[33,0,33,1],[3,2,3,3],[3,0,3,1],[4,1,4,2],[5,1,5,2],[35,0,35,1],[35,2,35,3]]}
[]
["lat",null,"LONG",null,"CO","SPEED","HOUR",null,"DIST","lat",null,"LONG"]
[35,{"$f":"IF(OR(DR!D4=\"S\",DR!D4=\"s\"),DR!C4*-1,DR!C4)","v":0},{"$f":"IF(OR(DR!G4=\"W\",DR!G4=\"w\"),DR!E4*-1,DR!E4)","v":179},{"$f":"IF(OR(DR!G4=\"W\",DR!G4=\"w\"),DR!F4*-1,DR!F4)","v":0},80,60,{"$f":"IF(AND(DR!C3=\"\",DR!E3=\"\"),\"\",DR!C3)","v":1},{"$f":"IF(AND(DR!C3=\"\",DR!E3=\"\"),\"\",DR!E3)","v":0},{"$f":"IF(OR(G3<>\"\",H3<>\"\"),F3*(G3+H3/60),F3*(G4+H4/60))","v":60},{"$f":"ROUNDDOWN(B9,0)","v":35},{"$f":"ROUND((B9-J3)*60,2)","v":10.42},{"$f":"ROUNDDOWN(B15,0)","v":-179},{"$f":"ROUND((B15-L3)*60,2)","v":-48.11}]
[{"$f":"A3+B3/60","v":35},null,{"$f":"C3+D3/60","v":179},null,null,null,{"$f":"DAY(B6-B5)*24+HOUR(B6-B5)","v":40},{"$f":"MINUTE(B6-B5)","v":33}]
["Fm",{"$f":"DR!C1+DR!F1","v":"2006-08-30T02:27:00"}]
["To",{"$f":"DR!C2+DR!F2","v":"2006-08-31T19:00:00"}]
[]
["dlat",{"$f":"I3*COS(RADIANS(E3))/60","v":0.17364817766693041}]
["lat2",{"$f":"A4+B8","v":35.173648177666934}]
[]
["mp2",{"$f":"7915.7045*LOG10(TAN(RADIANS(45+B9*0.5)))-22.9448*SIN(RADIANS(B9))-0.051*(SIN(RADIANS(B9)))^3","v":2243.7922557595962}]
["mp1",{"$f":"7915.7045*LOG10(TAN(RADIANS(45+A4*0.5)))-22.9448*SIN(RADIANS(A4))-0.051*(SIN(RADIANS(A4)))^3","v":2231.1166325225445}]
["dmp",{"$f":"B11-B12","v":12.675623237051695}]
["dlong",{"$f":"TAN(RADIANS(E3))*B13/60","v":1.1981171936102506},{"$f":"I3/COS(RADIANS(A4))/60","v":1.2207745887614558}]
["long2",{"$f":"IF(C15>180,C15-360,IF(C15<-180,C15+360,C15))","v":-179.80188280638976},{"$f":"IF(ABS(B13)<0.0001,IF(COS(RADIANS(E3))>0,C4+C14,C4-C14),C4+B14)","v":180.19811719361024}]
[]
[]
["lat",null,"LONG",null,"Co.","Dist."]
[{"$f":"IF(OR(CD!D2=\"S\",CD!D2=\"s\"),CD!B2*-1,CD!B2)","v":35},{"$f":"IF(OR(CD!D2=\"S\",CD!D2=\"s\"),CD!C2*-1,CD!C2)","v":10.42},{"$f":"IF(OR(CD!G2=\"W\",CD!G2=\"w\"),CD!E2*-1,CD!E2)","v":-179},{"$f":"IF(OR(CD!G2=\"W\",CD!G2=\"w\"),CD!F2*-1,CD!F2)","v":-48.11},{"$f":"IF(DEGREES(E20)<0,DEGREES(E20)+360,DEGREES(E20))","v":181.99394952895128},{"$f":"IF(ABS(B26)<=0.0001,F20,B29/COS(RADIANS(E19))*60)","v":1931.5895642382388}]
[{"$f":"A19+B19/60","v":35.173666666666669},null,{"$f":"C19+D19/60","v":-179.80183333333332},null,{"$f":"ATAN2(B26,B27*60)","v":-3.1067916691910034},{"$f":"ABS(B27*COS(RADIANS(A20))*60)","v":58.763586370770625}]
[{"$f":"IF(OR(CD!D3=\"S\",CD!D3=\"s\"),CD!B3*-1,CD!B3)","v":3},{"$f":"IF(OR(CD!D3=\"S\",CD!D3=\"s\"),CD!C3*-1,CD!C3)","v":0},{"$f":"IF(OR(CD!G3=\"W\",CD!G3=\"w\"),CD!E3*-1,CD!E3)","v":179},{"$f":"IF(OR(CD!G3=\"W\",CD!G3=\"w\"),CD!F3*-1,CD!F3)","v":0}]
[{"$f":"A21+B21/60","v":3},null,{"$f":"C21+D21/60","v":179}]
[]
["mp2",{"$f":"7915.7045*LOG10(TAN(RADIANS(45+A22*0.5)))-22.9448*SIN(RADIANS(A22))-0.051*(SIN(RADIANS(A22)))^3","v":178.88145848989913}]
["mp1",{"$f":"7915.7045*LOG10(TAN(RADIANS(45+A20*0.5)))-22.9448*SIN(RADIANS(A20))-0.051*(SIN(RADIANS(A20)))^3","v":2243.793606834477}]
["dmp",{"$f":"B24-B25","v":-2064.9121483445779}]
["Dlong",{"$f":"HLOOKUP(MIN(C27:E27),C27:E28,2,FALSE)","v":-1.1981666666666797},{"$f":"ABS(C28)","v":358.80183333333332},{"$f":"ABS(D28)","v":718.80183333333332},{"$f":"ABS(E28)","v":1.1981666666666797}]
[null,null,{"$f":"C22-C20","v":358.80183333333332},{"$f":"(180-C20)+(180+C22)","v":718.80183333333332},{"$f":"((180+C20)+(180-C22))*-1","v":-1.1981666666666797}]
["dlat",{"$f":"A22-A20","v":-32.173666666666669}]
[]
[]
[]
[]
["lat",null,"LONG",null,"Co.","Dist."]
[{"$f":"IF(OR(ETA!D4=\"S\",ETA!D4=\"s\"),ETA!B4*-1,ETA!B4)","v":35},{"$f":"IF(OR(ETA!D4=\"S\",ETA!D4=\"s\"),ETA!C4*-1,ETA!C4)","v":10.42},{"$f":"IF(OR(ETA!G4=\"W\",ETA!G4=\"w\"),ETA!E4*-1,ETA!E4)","v":-179},{"$f":"IF(OR(ETA!G4=\"W\",ETA!G4=\"w\"),ETA!F4*-1,ETA!F4)","v":-48.11},{"$f":"IF(DEGREES(E36)<0,DEGREES(E36)+360,DEGREES(E36))","v":265.48552380242609},{"$f":"IF(ABS(B42)<=0.0001,F36,B45/COS(RADIANS(E35))*60)","v":2412.8783568776657}]
[{"$f":"A35+B35/60","v":35.173666666666669},null,{"$f":"C35+D35/60","v":-179.80183333333332},null,{"$f":"ATAN2(B42,B43*60)","v":-1.6495888004454751},{"$f":"ABS(B43*COS(RADIANS(A36))*60)","v":2349.9630939137987}]
[{"$f":"IF(OR(ETA!D5=\"S\",ETA!D5=\"s\"),ETA!B5*-1,ETA!B5)","v":32},{"$f":"IF(OR(ETA!D5=\"S\",ETA!D5=\"s\"),ETA!C5*-1,ETA!C5)","v":0.5},{"$f":"IF(OR(ETA!G5=\"W\",ETA!G5=\"w\"),ETA!E5*-1,ETA!E5)","v":132},{"$f":"IF(OR(ETA!G5=\"W\",ETA!G5=\"w\"),ETA!F5*-1,ETA!F5)","v":17}]
[{"$f":"A37+B37/60","v":32.008333333333333},null,{"$f":"C37+D37/60","v":132.28333333333333}]
[]
["mp2",{"$f":"7915.7045*LOG10(TAN(RADIANS(45+A38*0.5)))-22.9448*SIN(RADIANS(A38))-0.051*(SIN(RADIANS(A38)))^3","v":2016.8039813203627}]
["mp1",{"$f":"7915.7045*LOG10(TAN(RADIANS(45+A36*0.5)))-22.9448*SIN(RADIANS(A36))-0.051*(SIN(RADIANS(A36)))^3","v":2243.793606834477}]
["dmp",{"$f":"B40-B41","v":-226.98962551411432}]
["Dlong",{"$f":"HLOOKUP(MIN(C43:E43),C43:E44,2,FALSE)","v":-47.914833333333348},{"$f":"ABS(C44)","v":312.08516666666662},{"$f":"ABS(D44)","v":672.08516666666662},{"$f":"ABS(E44)","v":47.914833333333348}]
[null,null,{"$f":"C38-C36","v":312.08516666666662},{"$f":"(180-C36)+(180+C38)","v":672.08516666666662},{"$f":"((180+C36)+(180-C38))*-1","v":-47.914833333333348}]
["dlat",{"$f":"A38-A36","v":-3.1653333333333364}]
[]
[]
[]
["lat",null,"LONG",null,"CO","Dist."]
[{"$f":"IF(OR(CD!D4=\"S\",CD!D4=\"s\"),CD!B4*-1,CD!B4)","v":-20},{"$f":"IF(OR(CD!D4=\"S\",CD!D4=\"s\"),CD!C4*-1,CD!C4)","v":-34.64},{"$f":"IF(B59=\"N/A\",\"-\",ROUNDDOWN(B59,0))","v":178},{"$f":"IF(B59=\"N/A\",\"-\",ROUND((B59-C50)*60,2))","v":10.119999999999999},{"$f":"E19","v":181.99394952895128},{"$f":"IF(ABS(B57)<0.0001,F51,(B60/COS(RADIANS(E50)))*60)","v":3347.0866380118123}]
[{"$f":"A50+B50/60","v":-20.577333333333332},null,null,null,null,{"$f":"ABS(B58*COS(RADIANS(A51))*60)","v":114.00212467594855}]
[]
[]
[]
["mp2",{"$f":"7915.7*LOG10(TAN(RADIANS(45+A51*0.5)))-23.1*SIN(RADIANS(A51))","v":-1253.9508623826093}]
["mp1",{"$f":"7915.7*LOG10(TAN(RADIANS(45+A20*0.5)))-23.1*SIN(RADIANS(A20))","v":2243.7126688715257}]
["dmp",{"$f":"B55-B56","v":-3497.6635312541348}]
["Dlong",{"$f":"(B57*TAN(RADIANS(E50)))/60","v":-2.0295216228564876}]
["L2",{"$f":"IF(ABS(B57)<0.0001,\"N/A\",IF(C59>180,C59-360,IF(C59<-180,C59+360,C59)))","v":178.16864504381019},{"$f":"C20+B58","v":-181.83135495618981}]
["dlat",{"$f":"A51-A20","v":-55.751000000000005}]