{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["計画","推測","太陽","正中時","恒星","計算","計（計画）","計（推測）","計（正中時）","計（太陽）","計（恒星）","予備"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":11,"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":"計画","index":0,"n_rows":65,"n_cols":12,"rows_kept":65,"cut":false,"hidden":false,"merged":[]}
[null,null,"１．太陽観測計画"]
[null,null,"正中時を求める",11,"月",null,9,"日"]
[null,null,"１２時の概経度",32,"度",null,50,"分",null,null,"符号"]
[null,null,{"$f":"D3+G3/60","v":32.833333333333336},{"$f":"C4/15","v":2.1888888888888891},{"$f":"ROUNDDOWN(D4,0)","v":2},null,{"$f":"D4-E4","v":0.18888888888888911},{"$f":"G4*60","v":11.333333333333346},{"$f":"ROUNDDOWN(H4,0)","v":11},{"$f":"H4-I4","v":0.33333333333334636},{"$f":"J4*60","v":20.000000000000782}]
[null,null,null,12,"時",null,0,"分",0,"秒",false,{"$f":"TIME(D5,G5,I5)","v":0.5}]
[null,null,null,12,"時",null,0,"分",0,"秒","24-Ｅ◎",{"$f":"TIME(D6,G6,I6)","v":0.5}]
[null,null,"Ｅ◎（Ｕ１２時）",12,"時",null,16,"分",12,"秒",{"$f":"L5+L6-L7","v":0.48875000000000002},{"$f":"TIME(D7,G7,I7)","v":0.51124999999999998}]
[null,null,"１２時の概経度",{"$f":"E4","v":2},null,null,{"$f":"I4","v":11},"分",{"$f":"K4","v":20.000000000000782},"秒",true,{"$f":"TIME(D8,G8,I8)","v":9.1203703703703717E-2}]
[null,null,"船内使用時",2,"時",null,0,"分",null,null,{"$f":"IF(K8,K7-L8,K7+L8)","v":0.39754629629629629},{"$f":"TIME(D9,G9,0)","v":8.3333333333333329E-2}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K8,K9+L9,K9-L9)","v":0.4808796296296296},{"$f":"ABS(K10)","v":0.4808796296296296}]
[null,null,null,"入力禁止"]
[null,null,"太陽子午線正中時",{"$f":"'計（計画）'!D12","v":11},"時",null,{"$f":"'計（計画）'!G12","v":32},"分","頃",null,true]
[]
[]
[]
[]
[null,null,"B.推測位置を求める"]
[null,null,"天測位置決定用図",11,"月",null,9,"日"]
[null,null,"による",9,"時",null,30,"分"]
[]
[null,null,"出発位置　　緯度",32,"度",null,23,"分",null,null,"符号"]
[null,null,"　　　　　　　　経度",32,"度",null,49,"分",null,null,"符号"]
[]
[null,null,"変緯",0,"度",null,1.8,"分",null,null,"符号"]
[null,null,"変経",{"$f":"計算!L36","v":0},"度",null,20.3,"分",null,null,"符号"]
[]
[null,null,"到着","入力禁止"]
[null,null,"推測位置　　　緯度",{"$f":"'計（計画）'!D27","v":32},"度",null,{"$f":"'計（計画）'!G27","v":24.80000000000004},"分",{"$f":"'計（計画）'!I27","v":"S"},"符号"]
[null,null,"経度",{"$f":"'計（計画）'!D28","v":32},"度",null,{"$f":"'計（計画）'!G28","v":28.70000000000033},"分",{"$f":"'計（計画）'!I28","v":"Ｅ"},"符号"]
[]
[]
[]
[]
[null,null,"2.針路（方位）改正"]
[null,null,null,null,"符号",null,null,null,null,"符号"]
[null,null,"コンパス針路",29,null,null,"真針路",null,170]
[null,null,"自差",2,"Ｗ",null,"自差",null,1,"Ｅ"]
[null,null,"偏差",6,"Ｅ",null,"偏差",null,3,"Ｗ"]
[]
[null,null,null,"入力禁止",null,null,null,null,"入力禁止"]
[null,null,"真針路",{"$f":"'計（計画）'!D39","v":33},null,null,"コンパス針路",null,{"$f":"'計（計画）'!I39","v":172}]
[]
[]
[]
[]
[null,null,"3.恒星観測計画","（索星）"]
[null,null,"星（恒星）の天測計画","年","月","日",null,"クロノメ－タ－","時","分","秒"]
[null,null,"観測日",0,10,12,null,"世界時（ＵＴ）",17,40,20]
[null,null,null,null,"度","分","符号",null,"度","分","符号"]
[null,null,"推測位置","推測緯度",25,10,"N","推測経度",158,48,"E"]
[]
[null,null,null,"例",null,null,"度","分"]
[null,null,"ＡＩＲ　ＮＡＶＩＧＡＴＩＯＮ","a表より","年，月",null,10,2,{"$f":"G53+H53/60","v":10.033333333333333}]
[null,null,"ＴＡＢＬＥ4より","ｂ表より","日、時",null,266,32,{"$f":"G54+H54/60","v":266.53333333333336}]
[null,null,null,"ｃ表より","分、秒",null,10,7,{"$f":"G55+H55/60","v":10.116666666666667}]
[null,null,null,"GHA",null,null,{"$f":"J56","v":286},{"$f":"J57*60","v":41.000000000003638},{"$f":"I53+I54+I55","v":286.68333333333339},{"$f":"ROUNDDOWN(I57,0)","v":286}]
[null,null,"ｗのときチェック入れる","加算","減算",null,null,null,{"$f":"IF(I56>=360,I56-360,I56)","v":286.68333333333339},{"$f":"I57-J56","v":0.68333333333339397}]
[null,null,"（E　+,　W　-）","推測経度",{"$f":"I50","v":158},null,{"$f":"I50","v":158},{"$f":"J50","v":48},{"$f":"G58+H58/60","v":158.80000000000001},false]
[null,null,null,"LHA",null,null,{"$f":"I60","v":85},{"$f":"J60","v":29.00000000000432},{"$f":"IF(J58,I56-I58,I56+I58)","v":445.48333333333341},{"$f":"IF(I59>=360,I59-360,I59)","v":85.483333333333405}]
[null,null,null,null,null,null,null,null,{"$f":"ROUNDDOWN(J59,0)","v":85},{"$f":"(J59-I60)*60","v":29.00000000000432}]
[null,null,"計算結果",null,"入力禁止"]
[null,null,"天測する星を見つける",null,null,null,null,null,{"$f":"ROUND(J59,1)","v":85.5}]
[null,null,"ＡＩＲ　ＮＡＶＩＧＡＴＩＯＮ","7個の","恒星の方位",null,"と高度が判明"]
[null,null,"ＳＩＧＨＴ　ＲＥＤＵＣＴＩＯＮ",null,{"$f":"'計（計画）'!E61","v":25},null,{"$f":"'計（計画）'!G61","v":"N"}]
[null,null,"ＴＡＢＬＥＳを利用する",null,"ＬＨＡ",null,{"$f":"'計（計画）'!G62","v":86}]

{"sheet":"推測","index":1,"n_rows":26,"n_cols":14,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[null,"90度式に変換",null,null,null,null,null,"ＫＨ式"]
[null,"針路・方位"]
[null,"360度式",250,null,{"$f":"IF(C3<90,\"Ｎ\",\"\")","v":""}]
[]
[null,null,"符号","度","符号"]
[null,"９０度式",{"$f":"'計（推測）'!C6","v":""},{"$f":"'計（推測）'!D6","v":""},{"$f":"'計（推測）'!E6","v":"Ｗ"}]
[null,null,{"$f":"'計（推測）'!C7","v":""},{"$f":"'計（推測）'!D7","v":""},{"$f":"IF(C3<180,180-C3,\"\")","v":""}]
[null,null,{"$f":"'計（推測）'!C8","v":"Ｓ"},{"$f":"'計（推測）'!D8","v":70},{"$f":"IF(270>C3,C3-180,\"\")","v":70}]
[null,null,{"$f":"'計（推測）'!C9","v":""},{"$f":"'計（推測）'!D9","v":""},{"$f":"IF(C3>270,360-C3,\"\")","v":""}]
[]
[]
[null,"推測位置を求める",null,null,null,null,null,"ＫＨ式"]
[null,"中分緯度航法",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M14,\"Ｎ\",\"Ｓ\")","v":"Ｎ"}]
[null,null,10,"月",28,"日",null,null,{"$f":"IF(I15,\"Ｎ\",\"Ｓ\")","v":"Ｓ"},null,"ｓｉｎ","ｃｏｓ",{"$f":"IF(I15,1,-2)","v":-2}]
[null,null,9,"時",0,"分",null,null,false,{"$f":"RADIANS(E17)","v":1.2217304763960306},{"$f":"SIN(J15)","v":0.93969262078590832},{"$f":"COS(J15)","v":0.34202014332566882},{"$f":"IF(M16,\"Ｅ\",\"Ｗ\")","v":"Ｅ"}]
[null,null,"符号",null,null,null,"符号",null,{"$f":"IF(I17,\"Ｅ\",\"Ｗ\")","v":"Ｅ"},null,null,null,{"$f":"IF(I17,1,-2)","v":1}]
[null,"針路",null,null,70,"度",null,null,true,"Ｄｌ","Ｄｅｐ","ｌ+ｌ/2",null,"cosｍｉｄｌ"]
[null,"航程",53,"海里",null,null,null,null,null,{"$f":"(C18*L15)/60","v":0.30211779327100746},{"$f":"C18*K15","v":49.803708901653138},{"$f":"(K21+M21)/2","v":27.098941103364496},{"$f":"RADIANS(L18)","v":0.47296574605773545},{"$f":"COS(M18)","v":0.89022122349054589}]
[]
[null,null,"度",null,"分",null,"符号",null,{"$f":"IF(I21,\"Ｎ\",\"Ｓ\")","v":"Ｎ"},null,null,{"$f":"I20","v":"Ｎ"},"符号"]
[null,"出発緯度",27,null,15,null,null,null,true,null,{"$f":"C21+E21/60","v":27.25},{"$f":"IF(I21,1,-2)","v":1},{"$f":"IF(M14-L21=0,K21+J18,K21-J18)","v":26.947882206728991}]
[null,"出発経度",138,null,40,null,null,null,{"$f":"IF(I23,\"Ｅ\",\"Ｗ\")","v":"Ｗ"},null,{"$f":"C22+E22/60","v":138.66666666666666},{"$f":"I22","v":"Ｗ"},{"$f":"IF(M16-L23=0,K22+K24,K22-K24)","v":137.73424471005131}]
[null,null,null,null,null,null,null,null,false,null,"ＤＬ",{"$f":"IF(I23,1,-2)","v":-2}]
[null,null,"度",null,"分",null,"符号",null,null,null,{"$f":"(K18/N18)/60","v":0.932421956615335}]
[null,"到達緯度",{"$f":"'計（推測）'!C25","v":26},null,{"$f":"'計（推測）'!E25","v":56.9},null,{"$f":"'計（推測）'!G25","v":"Ｎ"},null,null,null,{"$f":"ROUNDDOWN(M21,0)","v":26},{"$f":"(M21-K25)*60","v":56.872932403739469},{"$f":"ROUND(L25,1)","v":56.9}]
[null,"到達経度",{"$f":"'計（推測）'!C26","v":137},null,{"$f":"'計（推測）'!E26","v":44.1},null,{"$f":"'計（推測）'!G26","v":"Ｅ"},null,null,null,{"$f":"ROUNDDOWN(M22,0)","v":137},{"$f":"(M22-K26)*60","v":44.054682603078845},{"$f":"ROUND(L26,1)","v":44.1}]

{"sheet":"太陽","index":2,"n_rows":64,"n_cols":10,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
[]
[null,"天測太陽",null,null,null,"（","ＫＨメソッド","）"]
[null,"第",1,"回目","天測"]
[null,"観測天体","（太陽1、","恒星2）"]
[null,null,1]
[null,"観測日",2,"月",10,"日"]
[null,"観測時間",14,"時",50,"分頃"]
[null,null,null,null,null,null,"符号"]
[null,"観測時　　　緯度",27,"度",15,"分"]
[null,"推測位置　経度",138,"度",40,"分"]
[]
[null,"クロノメ－タ－",5,"時",23,"分",46,"秒"]
[null,"エラ－",null,null,11,"分",25,"秒"]
[null,null,"進む（-）",null,"遅れる（+）",null,"符号"]
[]
[null,"観測高度（下辺）",33,"度",34,"分"]
[null,"器差",null,null,0]
[]
[null,"天測暦、E◎ｏｒE*",11,"時",45,"分",43,"秒"]
[null,"赤緯（ｄ）",14,"度",38.700000000000003,"分"]
[null,"眼高",3,"ｍ",null,null,"符号"]
[null,"ログ指示値",217.3,"海里"]
[null,"気温",20,"度Ｃ"]
[null,"水温",20,"度Ｃ"]
[null,"天体概方位","N",58,"度","E","符号"]
[]
[null,null,"入力禁止"]
[null,"天測結果"]
[null,"修正差（I）",{"$f":"'計（太陽）'!C25","v":11.5},{"$f":"IF(C29>100,\"ミスがあるか、流されているので注意！\",\"\")","v":""}]
[]
[null,null,"符号"]
[null,null,{"$f":"'計（太陽）'!C28","v":"Ｓ"},"度","符号"]
[null,"方位角（Z）",{"$f":"'計（太陽）'!C29","v":""},{"$f":"'計（太陽）'!D29","v":47},{"$f":"'計（太陽）'!E29","v":"Ｗ"}]
[null,null,{"$f":"'計（太陽）'!C30","v":""}]
[]
[]
[]
[]
[null,"太陽の赤緯ｄ"]
[null,"比例部分の計算",null,null,null,null,"ｄ"]
[null,null,"時","分","秒",null,"度",null,"分"]
[null,1,8,null,null,null,20,null,14.5]
[null,null,{"$f":"TIME(C42,D42,E42)","v":0.33333333333333331},null,null,null,{"$f":"G42+I42/60","v":20.241666666666667}]
[null,2,10,null,null,null,20,null,13.4]
[null,null,{"$f":"TIME(C44,D44,E44)","v":0.41666666666666669},{"$f":"ABS(C45-C43)","v":8.333333333333337E-2},null,null,{"$f":"G44+I44/60","v":20.223333333333333},{"$f":"ABS(G45-G43)","v":1.8333333333334423E-2}]
[null,null,null,null,null,null,"入力禁止"]
[null,"求める比例部分",9,23,0,null,{"$f":"H49","v":20},null,{"$f":"J49","v":13.7}]
[]
[null,null,{"$f":"TIME(C47,D47,E47)","v":0.39097222222222222},{"$f":"ABS(C49-C43)","v":5.7638888888888906E-2},null,{"$f":"H45*D49/D45","v":1.2680555555556309E-2},{"$f":"IF(G45-G43>0,G43+F49,G43-F49)","v":20.228986111111112},{"$f":"ROUNDDOWN(G49,0)","v":20},{"$f":"(G49-H49)*60","v":13.739166666666733},{"$f":"ROUND(I49,1)","v":13.7}]
[]
[]
[]
[null,"太陽のE◎"]
[null,"比例部分の計算"]
[null,null,"時","分","秒",null,"時","分","秒"]
[null,1,4,0,0,null,12,2,32]
[null,null,{"$f":"TIME(C56,D56,E56)","v":0.16666666666666666},null,null,null,{"$f":"TIME(G56,H56,I56)","v":0.50175925925925924}]
[null,2,6,0,0,null,12,2,33]
[]
[null,null,{"$f":"TIME(C58,D58,E58)","v":0.25},{"$f":"ABS(C60-C57)","v":8.3333333333333343E-2},null,null,{"$f":"TIME(G58,H58,I58)","v":0.50177083333333339},{"$f":"ABS(G60-G57)","v":1.1574074074149898E-5}]
[null,null,null,null,null,null,"入力禁止"]
[null,"求める比例部分",4,50,0,null,{"$f":"HOUR(G64)","v":12},{"$f":"MINUTE(G64)","v":2},{"$f":"SECOND(G64)","v":32}]
[]
[null,null,{"$f":"TIME(C62,D62,E62)","v":0.20138888888888887},{"$f":"ABS(C64-C57)","v":3.472222222222221E-2},null,{"$f":"D64*H60/D60","v":4.8225308642291217E-6},{"$f":"IF(G60-G57>0,G57+F64,G57-F64)","v":0.50176408179012344}]

{"sheet":"正中時","index":3,"n_rows":57,"n_cols":10,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,"ＫＨ式"]
[null,"正中時を求める",11,"月",9,"日"]
[null,"１２時の概経度",32,"度",50,"分",null,null,"符号"]
[null,{"$f":"C3+E3/60","v":32.833333333333336},{"$f":"B4/15","v":2.1888888888888891},{"$f":"ROUNDDOWN(C4,0)","v":2},{"$f":"C4-D4","v":0.18888888888888911},{"$f":"E4*60","v":11.333333333333346},{"$f":"ROUNDDOWN(F4,0)","v":11},{"$f":"F4-G4","v":0.33333333333334636},{"$f":"H4*60","v":20.000000000000782}]
[null,null,12,"時",0,"分",0,"秒",false,{"$f":"TIME(C5,E5,G5)","v":0.5}]
[null,null,12,"時",0,"分",0,"秒","24-Ｅ◎",{"$f":"TIME(C6,E6,G6)","v":0.5}]
[null,"Ｅ◎（Ｕ１２時）",12,"時",16,"分",12,"秒",{"$f":"J5+J6-J7","v":0.48875000000000002},{"$f":"TIME(C7,E7,G7)","v":0.51124999999999998}]
[null,"１２時の概経度",{"$f":"D4","v":2},null,{"$f":"G4","v":11},"分",{"$f":"I4","v":20.000000000000782},"秒",true,{"$f":"TIME(C8,E8,G8)","v":9.1203703703703717E-2}]
[null,"船内使用時",2,"時",0,"分",null,null,{"$f":"IF(I8,I7-J8,I7+J8)","v":0.39754629629629629},{"$f":"TIME(C9,E9,0)","v":8.3333333333333329E-2}]
[null,null,null,null,null,null,null,null,{"$f":"IF(I8,I9+J9,I9-J9)","v":0.4808796296296296},{"$f":"ABS(I10)","v":0.4808796296296296}]
[null,"太陽子午線正中時",{"$f":"'計（正中時）'!C11","v":11},"時",{"$f":"'計（正中時）'!E11","v":32},"分","頃",null,true]
[]
[]
[]
[]
[null,"太陽子午線高度緯度法",null,null,null,null,"ＫＨ式"]
[]
[null,"観測日",11,"月",9,"日",null,"眼高",3,"ｍ"]
[null,null,null,null,null,null,null,"ログ指値",0]
[null,null,null,null,null,null,"気温",30,"水温",28]
[]
[null,"クロノメ－タ－",0,"時",0,"分",0,"秒",{"$f":"TIME(C22,E22,G22)","v":0}]
[null,"エラ－",null,null,0,null,0,null,{"$f":"TIME(0,E23,G23)","v":0}]
[null,"Ｕ",{"$f":"HOUR(I24)","v":0},null,{"$f":"MINUTE(I24)","v":0},null,{"$f":"SECOND(I24)","v":0},null,{"$f":"I22+I23","v":0}]
[null,null,null,null,null,null,"符号",null,true]
[null,"推測緯度（ｌ）",36,"度",26.7,"分",null,null,{"$f":"IF(I25,\"Ｎ\",\"Ｓ\")","v":"Ｎ"}]
[null,"　　　　　　　　経度",155,"度",30.2,"分",null,null,{"$f":"IF(I25,1,-2)","v":1},{"$f":"C26+E26/60","v":36.445}]
[null,null,null,null,null,null,"符号",null,{"$f":"IF(I29,\"Ｎ\",\"Ｓ\")","v":"Ｎ"}]
[null,"天測暦　→　赤緯（ｄ）",13,"度",1,"分",null,null,true]
[null,null,null,null,null,null,"符号"]
[null,null,null,"度",null,"分",null,null,"ｄ"]
[null,"観測高度",40,null,29,null,{"$f":"C32+E32/60","v":40.483333333333334},{"$f":"IF(I29,1,-2)","v":1},{"$f":"C29+E29/60","v":13.016666666666667},{"$f":"I32*-1","v":-13.016666666666667}]
[null,"器差",null,null,-2.5,null,{"$f":"C33+E33/60","v":-4.1666666666666664E-2},{"$f":"G32+G33","v":40.44166666666667}]
[null,null,{"$f":"G34","v":40},null,{"$f":"H34","v":26.500000000000199},null,{"$f":"ROUNDDOWN(H33,0)","v":40},{"$f":"(H33-G34)*60","v":26.500000000000199}]
[null,"改正1",0,null,{"$f":"C83","v":0},null,{"$f":"C35+E35/60","v":0}]
[null,"改正2",0,null,{"$f":"H69","v":0},null,{"$f":"C36+E36/60","v":0}]
[null,"改正3",0,null,{"$f":"J72","v":0},null,{"$f":"C37+E37/60","v":0},{"$f":"H33+G35+G36+G37","v":40.44166666666667}]
[null,"真高度　（ａ）",{"$f":"G38","v":40},null,{"$f":"H38","v":26.500000000000199},null,{"$f":"ROUNDDOWN(H37,0)","v":40},{"$f":"(H37-G38)*60","v":26.500000000000199}]
[null,null,90,null,null,null,{"$f":"C39-H37","v":49.55833333333333},{"$f":"ROUNDDOWN(G39,0)","v":49}]
[null,"９０－ａ",{"$f":"H39","v":49},null,{"$f":"G40","v":33.499999999999801},null,{"$f":"(G39-H39)*60","v":33.499999999999801},null,"ｌ-ｄ",{"$f":"J27-I32","v":23.428333333333335}]
[null,null,null,null,null,"ｌ、ｄ異名",{"$f":"IF(I41<0,G39+J32,1)","v":1},"ｌ、ｄ同名",{"$f":"IF(I27-H32=0,1,-1)","v":1}]
[null,null,null,null,null,{"$f":"ROUNDDOWN(G41,0)","v":1},{"$f":"(G41-F42)*60","v":0}]
[null,null,null,null,null,"ｌ＞ｄ",{"$f":"IF(J40>0,I32+G39,I32-G39)","v":62.574999999999996},{"$f":"ROUNDDOWN(G43,0)","v":62},{"$f":"(G43-H43)*60","v":34.499999999999744}]
[null,null,"（入力禁止）",null,null,"ｌ＜ｄ"]
[null,"正中時緯度（ｌ）",{"$f":"C53","v":0},null,{"$f":"E53","v":0},null,{"$f":"G53","v":""},"ｌ、ｄ同名の時",{"$f":"C45+E45/60","v":0}]
[null,"正中時緯度（ｌ）",{"$f":"C54","v":36},null,{"$f":"E54","v":20.199999999999534},null,{"$f":"G54","v":"Ｎ"},"ｌ、ｄ異名の時",{"$f":"C46+E46/60","v":36.336666666666659},{"$f":"I45+I46","v":36.336666666666659}]
[]
[null,"修正差（Ｉ）北半球の時",{"$f":"IF(E46>100,\"ミスがあるか、流されています\",\"\")","v":""},null,{"$f":"E56","v":6.5000000000004832},{"$f":"F56","v":"Ｓ"},{"$f":"IF(J48>0,\"Ｓ\",\"Ｎ\")","v":"Ｓ"},null,"ｌ－ａ",{"$f":"J27-J46","v":0.10833333333334139}]
[null,"修正差（Ｉ）南半球の時",{"$f":"IF(E49>100,\"ミスがあるか、流されています\",\"\")","v":""},null,{"$f":"E57","v":0},{"$f":"F57","v":"Ｎ"},{"$f":"IF(J48>0,\"Ｎ\",\"Ｓ\")","v":"Ｎ"},null,{"$f":"J49*60","v":6.5000000000004832},{"$f":"ABS(J48)","v":0.10833333333334139}]
[]
[]
[]
[null,"正中時緯度（ｌ）",{"$f":"'計（正中時）'!C45","v":0},null,{"$f":"'計（正中時）'!E45","v":0},null,{"$f":"'計（正中時）'!G45","v":""},"ｌ、ｄ同名の時",{"$f":"C53+E53/60","v":0}]
[null,"正中時緯度（ｌ）",{"$f":"'計（正中時）'!C46","v":36},null,{"$f":"'計（正中時）'!E46","v":20.199999999999534},null,{"$f":"'計（正中時）'!G46","v":"Ｎ"},"ｌ、ｄ異名の時",{"$f":"C54+E54/60","v":36.336666666666659},{"$f":"I53+I54","v":36.336666666666659}]
[]
[null,"修正差（Ｉ）北半球の時",{"$f":"IF(E54>100,\"ミスがあるか、流されています\",\"\")","v":""},null,{"$f":"'計（正中時）'!E48","v":6.5000000000004832},{"$f":"'計（正中時）'!F48","v":"Ｓ"},{"$f":"IF(J56>0,\"Ｓ\",\"Ｎ\")","v":"Ｎ"},null,"ｌ－ａ",{"$f":"J35-J54","v":-36.336666666666659}]
[null,"修正差（Ｉ）南半球の時",{"$f":"IF(E57>100,\"ミスがあるか、流されています\",\"\")","v":""},null,{"$f":"'計（正中時）'!E49","v":0},{"$f":"'計（正中時）'!F49","v":"Ｎ"},{"$f":"IF(J56>0,\"Ｎ\",\"Ｓ\")","v":"Ｓ"},null,{"$f":"J57*60","v":2180.1999999999994},{"$f":"ABS(J56)","v":36.336666666666659}]

{"sheet":"恒星","index":4,"n_rows":82,"n_cols":9,"rows_kept":82,"cut":false,"hidden":false,"merged":[]}
[]
[null,"天測恒星",null,null,null,"（","ＫＨメソッド","）"]
[null,null,1,"回目","天測"]
[null,"観測天体","（太陽1、","恒星2）",2,null,"恒星Ｎｏ",31]
[]
[null,"観測日",2,"月",10,"日"]
[null,"観測時間",18,"時",30,"分頃"]
[null,"観測高度",30,"度",55,"分"]
[null,"器差",null,null,3,null,"符号"]
[null,"観測時　　　緯度",26,"度",56.9,"分"]
[null,"推測位置　経度",137,"度",44.1,"分"]
[]
[null,"クロノメ－タ－",9,"時",4,"分",28,"秒"]
[null,"エラ－",null,null,11,"分",25,"秒"]
[null,null,"進む（-）",null,"遅れる（+）"]
[null,"天測暦、E◎ｏｒE*",1,"時",40,"分",28,"秒"]
[null,"赤緯（ｄ）",5,"度",18.5,"分"]
[null,"眼高",3,"ｍ",null,null,"符号"]
[null,"ログ指示値",151.19999999999999,"海里"]
[null,"気温",20,"度Ｃ"]
[null,"水温",20,"度Ｃ"]
[null,"天体概方位","Ｓ",20,"度","E","符号"]
[]
[null,null,"入力禁止"]
[null,"天測結果"]
[null,"修正差（I）",{"$f":"C77","v":14.2},{"$f":"IF(C26>100,\"ミスがあるか、流されているので注意！\",\"\")","v":""}]
[]
[null,null,"符号"]
[null,null,{"$f":"C80","v":""},"度","符号"]
[null,"方位角（Z）",{"$f":"C81","v":""},{"$f":"D81","v":80},{"$f":"E81","v":"Ｅ"}]
[null,null,{"$f":"C82","v":"Ｓ"}]
[]
[]
[]
[]
[]
[null,"任意の時間のＥ*を求める"]
[null,"Ｅ*　Ｕ＝0時（ｈ）",1,"ｈ",38,"ｍ",56,"ｓ","天測暦"]
[null,"求めるＥ*の時間",9,"ｈ",15,"ｍ",53,"ｓ"]
[null,null,{"$f":"HOUR(H74)","v":1},null,{"$f":"MINUTE(H74)","v":40},null,{"$f":"SECOND(H74)","v":28}]
[null,null,"入力禁止"]
[null,"求めるＥ*",{"$f":"C40","v":1},"ｈ",{"$f":"E40","v":40},"ｍ",{"$f":"G40","v":28},"ｓ"]
[null,"Ｅ*　比例部分","分　秒"]
[null,"Ｕ",0,10,20,30,40,50,60]
[null,0,"0ｍ00","0ｍ02","0ｍ03","0ｍ05","0ｍ07","0ｍ08","0ｍ10"]
[null,1,"0ｍ10","0ｍ11","0ｍ13","0ｍ15","0ｍ16","0ｍ18","0ｍ20"]
[null,2,"0ｍ20","0ｍ21","0ｍ23","0ｍ25","0ｍ26","0ｍ28","0ｍ30"]
[null,3,"0ｍ30","0ｍ31","0ｍ33","0ｍ34","0ｍ36","0ｍ38","0ｍ39"]
[null,4,"0ｍ39","0ｍ41","0ｍ43","0ｍ44","0ｍ46","0ｍ48","0ｍ49"]
[null,5,"0ｍ49","0ｍ51","0ｍ53","0ｍ54","0ｍ56","0ｍ57","0ｍ59"]
[null,6,"0ｍ59","1ｍ01","1ｍ02","1ｍ04","1ｍ06","1ｍ07","1ｍ09"]
[null,7,"1ｍ09","1ｍ11","1ｍ12","1ｍ14","1ｍ16","1ｍ17","1ｍ19"]
[null,8,"1ｍ19","1ｍ20","1ｍ22","1ｍ24","1ｍ25","1ｍ27","1ｍ29"]
[null,9,"1ｍ29","1ｍ30","1ｍ32","1ｍ34","1ｍ35","1ｍ37","1ｍ39"]
[null,10,"1ｍ39","1ｍ40","1ｍ42","1ｍ43","1ｍ45","1ｍ47","1ｍ48"]
[null,11,"1ｍ48","1ｍ50","1ｍ52","1ｍ53","1ｍ55","1ｍ57","1ｍ58"]
[null,12,"1ｍ58","2ｍ00","2ｍ02","2ｍ03","2ｍ05","2ｍ06","2ｍ08"]
[null,13,"2ｍ08","2ｍ10","2ｍ11","2ｍ13","2ｍ15","2ｍ16","2ｍ18"]
[null,14,"2ｍ18","2ｍ20","2ｍ21","2ｍ23","2ｍ25","2ｍ26","2ｍ28"]
[null,15,"2ｍ28","2ｍ29","2ｍ31","2ｍ33","2ｍ34","2ｍ36","2ｍ38"]
[null,16,"2ｍ38","2ｍ39","2ｍ41","2ｍ43","2ｍ44","2ｍ46","2ｍ47"]
[null,17,"2ｍ48","2ｍ49","2ｍ51","2ｍ52","2ｍ54","2ｍ56","2ｍ57"]
[null,18,"2ｍ57","2ｍ59","3ｍ01","3ｍ02","3ｍ04","3ｍ06","3ｍ07"]
[null,19,"3ｍ07","3ｍ09","3ｍ11","3ｍ12","3ｍ14","3ｍ15","3ｍ17"]
[null,20,"3ｍ17","3ｍ19","3ｍ20","3ｍ22","3ｍ24","3ｍ25","3ｍ27"]
[null,21,"3ｍ27","3ｍ29","3ｍ30","3ｍ32","3ｍ34","3ｍ35","3ｍ37"]
[null,22,"3ｍ37","3ｍ38","3ｍ40","3ｍ42","3ｍ43","3ｍ45","3ｍ47"]
[null,23,"3ｍ47","3ｍ48","3ｍ50","3ｍ52","3ｍ53","3ｍ55","3ｍ57"]
[]
[null,"Ｕ＝０","ｖｌｕｐ","ｖｌｕｐ","ｖｌｕｐ","ｖｌｕｐ","ｖｌｕｐ","ｖｌｕｐ","ｖｌｕｐ"]
[null,null,0,10,20,30,40,50,60]
[null,{"$f":"C39+E39/60+G39/3600","v":9.2647222222222219},{"$f":"VLOOKUP(B72,B45:I68,2,1)","v":"1ｍ29"},"1ｍ30","1ｍ32","1ｍ34","1ｍ35","1ｍ37","1ｍ39"]
[null,{"$f":"E39+G39/60","v":15.883333333333333},null,"ｍ","ｓ","ｈｍｓ（ｐｐ）","ｈｍｓ"]
[null,{"$f":"ROUND(B73,-1)","v":20},{"$f":"HLOOKUP(B74,C71:I72,2,1)","v":"1ｍ32"},{"$f":"LEFT(C74,1)","v":"1"},{"$f":"MID(C74,3,2)","v":"32"},{"$f":"TIME(0,D74,E74)","v":1.0648148148148147E-3},{"$f":"TIME(C38,E38,G38)","v":6.8703703703703697E-2},{"$f":"F74+G74","v":6.9768518518518507E-2}]
[]
[null,"天測結果"]
[null,"修正差（I）",{"$f":"'計（恒星）'!C25","v":14.2},{"$f":"IF(C77>100,\"ミスがあるか、流されているので注意！\",\"\")","v":""}]
[]
[null,null,"符号"]
[null,null,{"$f":"'計（恒星）'!C28","v":""},"度","符号"]
[null,"方位角（Z）",{"$f":"'計（恒星）'!C29","v":""},{"$f":"'計（恒星）'!D29","v":80},{"$f":"'計（恒星）'!E29","v":"Ｅ"}]
[null,null,{"$f":"'計（恒星）'!C30","v":"Ｓ"}]

{"sheet":"計算","index":5,"n_rows":67,"n_cols":15,"rows_kept":67,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"時間","ｈ","ｍ","ｓ",null,null,null,"時間",null,"ｈ","ｍ","ｓ"]
[null,null,null,12,0,0,null,null,null,"+",null,6,0,0]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TIME(L4,M4,N4)","v":0.25},{"$f":"L4+M4/60+N4/3600","v":6},{"$f":"IF(O6,0,L5+L8)","v":0}]
[null,null,null,{"$f":"D4*15","v":180},{"$f":"E4*15","v":0},{"$f":"F4*15","v":0},null,null,null,"(-)",null,{"$f":"IF(M5-M8<0,M5+24-M8,M5+M8)","v":19.439999999999998},{"$f":"IF(O6,N6,L5+L8)","v":19.439999999999998},{"$f":"IF(M5>M8,M5-M8,L6)","v":19.439999999999998},true]
[null,null,null,{"$f":"E8+D6","v":180},{"$f":"E6/60","v":0},{"$f":"F6/60","v":0},null,null,null,"時間",null,10,33,36]
[null,null,null,null,{"$f":"INT(E7)","v":0},{"$f":"ROUND(F7,1)","v":0},null,null,null,"チェック","する",{"$f":"TIME(L7,M7,N7)","v":0.44},{"$f":"L7+M7/60+N7/3600","v":10.56}]
[null,null,null,null,{"$f":"E7-E8","v":0},null,null,null,null,null,null,{"$f":"ROUNDDOWN(N6,0)","v":19},{"$f":"(N6-L9)*60","v":26.399999999999864},{"$f":"ROUNDDOWN(M9,0)","v":26},{"$f":"(M9-N9)*60","v":23.999999999991815}]
[null,null,null,null,{"$f":"E9*60","v":0},null,null,null,null,null,null,{"$f":"L9","v":19},{"$f":"N9","v":26},{"$f":"O9","v":23.999999999991815},{"$f":"IF(L10>=24,L10-24,L10)","v":19}]
[null,null,null,"入力禁止",null,null,null,null,null,null,null,"入力禁止"]
[null,null,null,"度","分",null,null,null,null,"答え","減算",{"$f":"IF(O6,L10,0)","v":19},{"$f":"IF(O6,M10,0)","v":26},{"$f":"IF(O6,N10,0)","v":23.999999999991815}]
[null,null,"角度",{"$f":"D7","v":180},{"$f":"E10+F8","v":0},null,null,null,null,"答え","加算",{"$f":"IF(O6,0,HOUR(N5))","v":0},{"$f":"IF(O6,0,MINUTE(N5))","v":0},{"$f":"IF(O6,0,SECOND(N5))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,false]
[]
[]
[null,null,"角度",300,0,null,null,null,null,null,"度","分"]
[null,null,"+",null,null,null,null,null,null,"角度",158,24,{"$f":"K18+L18/60","v":158.4},{"$f":"M18/15","v":10.56}]
[null,null,"角度",120,0,null,null,null,null,null,null,null,{"$f":"ROUNDDOWN(N18,0)","v":10},{"$f":"N18-M19","v":0.5600000000000005}]
[null,null,null,{"$f":"D17+D19","v":420},{"$f":"E17+E19","v":0},null,null,null,null,null,null,null,{"$f":"N19*60","v":33.60000000000003},{"$f":"ROUNDDOWN(M20,0)","v":33}]
[null,null,null,{"$f":"IF(E20>=60,D20+1,D20)","v":420},{"$f":"IF(E20>=60,E20-60,E20)","v":0},null,null,null,null,null,"入力禁止",null,{"$f":"M20-N20","v":0.60000000000002984},{"$f":"M21*60","v":36.000000000001791}]
[null,null,"答え",{"$f":"IF(D21>=360,D21-360,D21)","v":60},{"$f":"E21","v":0},"入力禁止",null,null,null,null,"ｈ","ｍ","ｓ"]
[null,null,null,{"$f":"D4*15","v":180},{"$f":"E4*15","v":0},{"$f":"F4*15","v":0}]
[null,null,null,{"$f":"INT(E24)","v":0},{"$f":"E23/60","v":0},{"$f":"F23/60","v":0}]
[null,null,null,{"$f":"D23+D24","v":180},{"$f":"(E24-D24)*60","v":0},{"$f":"ROUND(F24,1)","v":0}]
[null,null,null,null,{"$f":"E25+F25","v":0}]
[null,null,null,null,null,null,null,null,null,"時間",{"$f":"M19","v":10},{"$f":"N20","v":33},{"$f":"N21","v":36.000000000001791}]
[]
[]
[]
[]
[null,null,"計算",null,null,null,null,null,{"$f":"IF(I33,\"N\",\"S\")","v":"S"},{"$f":"IF(I37,\"N\",\"S\")","v":"S"},null,null,null,{"$f":"IF(N33,\"Ｅ\",\"Ｗ\")","v":"Ｅ"},{"$f":"IF(N37,\"E\",\"W\")","v":"W"}]
[null,null,null,"緯度","度","分",null,null,false,null,"経度","度","分",true]
[null,null,"基準",{"$f":"E34+F34/60","v":32.383333333333333},{"$f":"計画!D21","v":32},{"$f":"計画!G21","v":23},null,null,null,null,{"$f":"L34+M34/60","v":32.81666666666667},{"$f":"計画!D22","v":32},{"$f":"計画!G22","v":49}]
[null,null,"位置",{"$f":"E36+F36/60","v":3.0000000000000002E-2},"度","分",null,null,null,null,{"$f":"L36+M36/60","v":0.33833333333333332},"度","分"]
[null,null,null,"変緯",{"$f":"計画!D24","v":0},{"$f":"計画!G24","v":1.8},null,null,null,null,"変経",0,{"$f":"計画!G25","v":20.3}]
[null,null,null,{"$f":"IF(I33=I37,D34+D35,D34-D35)","v":32.413333333333334},{"$f":"ROUNDDOWN(D37,0)","v":32},{"$f":"(D37-E37)*60","v":24.80000000000004},null,null,false,null,{"$f":"IF(N33=N37,K34+K35,K34-K35)","v":32.478333333333339},{"$f":"ROUNDDOWN(K37,0)","v":32},{"$f":"(K37-L37)*60","v":28.70000000000033},false]
[]
[null,null,"推測","入力禁止","緯度","分",null,null,"符号",null,"経度","分","符号"]
[null,null,"位置",null,{"$f":"E37","v":32},{"$f":"ABS(F37)","v":24.80000000000004},null,null,{"$f":"D42","v":"S"},null,{"$f":"L37","v":32},{"$f":"ABS(M37)","v":28.70000000000033},{"$f":"K42","v":"Ｅ"}]
[]
[null,null,null,{"$f":"IF(D34>D35,I32,J32)","v":"S"},null,null,null,null,null,null,{"$f":"IF(K34>K35,N32,O32)","v":"Ｅ"}]
[]
[]
[null,null,"針路（方位）改正"]
[null,null,null,null,"符号",null,null,null,null,null,"符号"]
[null,null,"コンパス針路",{"$f":"計画!D36","v":29},null,"真針路",null,null,null,{"$f":"計画!I36","v":170}]
[null,null,"自差",{"$f":"計画!D37","v":2},{"$f":"計画!E37","v":"Ｗ"},null,null,null,"自差",{"$f":"計画!I37","v":1},{"$f":"計画!J37","v":"Ｅ"}]
[null,null,null,{"$f":"IF(E48=\"Ｗ\",D48*(-1),D48*1)","v":-2},null,null,null,null,null,{"$f":"IF(K48=\"Ｅ\",J48*(-1),J48)","v":-1}]
[null,null,"偏差",{"$f":"計画!D38","v":6},{"$f":"計画!E38","v":"Ｅ"},null,null,null,"偏差",{"$f":"計画!I38","v":3},{"$f":"計画!J38","v":"Ｗ"}]
[null,null,{"$f":"D47+D49+D51","v":33},{"$f":"IF(E50=\"Ｅ\",D50*1,D50*(-1))","v":6},null,null,null,null,{"$f":"J47+J49+J51","v":172},{"$f":"IF(K50=\"Ｗ\",J50,J50*(-1))","v":3}]
[null,null,null,"入力禁止",null,"入力禁止",null,null,null,"入力禁止"]
[null,null,"真針路",{"$f":"C51","v":33},null,"コンパス針路",null,null,null,{"$f":"I51","v":172}]
[]
[]
[]
[]
[null,null,"比例部分の計算"]
[null,null,null,"時","分","秒",null,null,null,"度",null,"分"]
[null,null,1,8,null,null,null,null,null,20,null,2.1]
[null,null,null,{"$f":"TIME(D60,E60,F60)","v":0.33333333333333331},null,null,null,null,null,{"$f":"J60+L60/60","v":20.035}]
[null,null,2,10,null,null,null,null,null,20,null,1]
[null,null,null,{"$f":"TIME(D62,E62,F62)","v":0.41666666666666669},{"$f":"ABS(D63-D61)","v":8.333333333333337E-2},null,null,null,null,{"$f":"J62+L62/60","v":20.016666666666666},{"$f":"ABS(J63-J61)","v":1.8333333333334423E-2}]
[null,null,null,null,null,null,null,null,null,"入力禁止"]
[null,null,"求める比例部分",8,45,0,null,null,null,{"$f":"K67","v":20},null,{"$f":"M67","v":1.7}]
[]
[null,null,null,{"$f":"TIME(D65,E65,F65)","v":0.36458333333333331},{"$f":"ABS(D67-D61)","v":3.125E-2},null,null,null,{"$f":"K63*E67/E63","v":6.8750000000004051E-3},{"$f":"IF(J63-J61>0,J61+I67,J61-I67)","v":20.028124999999999},{"$f":"ROUNDDOWN(J67,0)","v":20},{"$f":"(J67-K67)*60","v":1.6874999999999574},{"$f":"ROUND(L67,1)","v":1.7}]

{"sheet":"計（計画）","index":6,"n_rows":62,"n_cols":12,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
[null,null,"１．太陽観測計画",null,"入力禁止"]
[null,null,"正中時を求める",{"$f":"計画!D2","v":11},"月",null,{"$f":"計画!G2","v":9},"日"]
[null,null,"１２時の概経度",{"$f":"計画!D3","v":32},"度",null,{"$f":"計画!G3","v":50},"分",null,null,"符号"]
[null,null,{"$f":"D3+G3/60","v":32.833333333333336},{"$f":"C4/15","v":2.1888888888888891},{"$f":"ROUNDDOWN(D4,0)","v":2},null,{"$f":"D4-E4","v":0.18888888888888911},{"$f":"G4*60","v":11.333333333333346},{"$f":"ROUNDDOWN(H4,0)","v":11},{"$f":"H4-I4","v":0.33333333333334636},{"$f":"J4*60","v":20.000000000000782}]
[null,null,null,12,"時",null,0,"分",0,"秒",false,{"$f":"TIME(D5,G5,I5)","v":0.5}]
[null,null,null,12,"時",null,0,"分",0,"秒","24-Ｅ◎",{"$f":"TIME(D6,G6,I6)","v":0.5}]
[null,null,"Ｅ◎（Ｕ１２時）",{"$f":"計画!D7","v":12},"時",null,{"$f":"計画!G7","v":16},"分",{"$f":"計画!I7","v":12},"秒",{"$f":"L5+L6-L7","v":0.48875000000000002},{"$f":"TIME(D7,G7,I7)","v":0.51124999999999998}]
[null,null,"１２時の概経度",{"$f":"E4","v":2},null,null,{"$f":"I4","v":11},"分",{"$f":"K4","v":20.000000000000782},"秒",true,{"$f":"TIME(D8,G8,I8)","v":9.1203703703703717E-2}]
[null,null,"船内使用時",{"$f":"計画!D9","v":2},"時",null,{"$f":"計画!G9","v":0},"分",null,null,{"$f":"IF(K8,K7-L8,K7+L8)","v":0.39754629629629629},{"$f":"TIME(D9,G9,0)","v":8.3333333333333329E-2}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K8,K9+L9,K9-L9)","v":0.4808796296296296},{"$f":"ABS(K10)","v":0.4808796296296296}]
[]
[null,null,"太陽子午線正中時",{"$f":"HOUR(L10)","v":11},"時",null,{"$f":"MINUTE(L10)","v":32},"分","頃",null,true]
[]
[]
[]
[null,null,null,null,"入力禁止"]
[null,null,"B.推測位置を求める"]
[null,null,"天測位置決定用図",{"$f":"計画!D18","v":11},"月",null,{"$f":"計画!G18","v":9},"日"]
[null,null,"による",{"$f":"計画!D19","v":9},"時",null,{"$f":"計画!G19","v":30},"分"]
[]
[null,null,"出発位置　　緯度",{"$f":"計画!D21","v":32},"度",null,{"$f":"計画!G21","v":23},"分",null,null,"符号"]
[null,null,"　　　　　　　　経度",{"$f":"計画!D22","v":32},"度",null,{"$f":"計画!G22","v":49},"分",null,null,"符号"]
[]
[null,null,"変緯",{"$f":"計画!D24","v":0},"度",null,{"$f":"計画!G24","v":1.8},"分",null,null,"符号"]
[null,null,"変経",{"$f":"計画!D25","v":0},"度",null,{"$f":"計画!G25","v":20.3},"分",null,null,"符号"]
[null,null,"到着"]
[null,null,"推測位置　　　緯度",{"$f":"計算!E40","v":32},"度",null,{"$f":"計算!F40","v":24.80000000000004},"分",{"$f":"計算!I40","v":"S"},"符号"]
[null,null,"経度",{"$f":"計算!K40","v":32},"度",null,{"$f":"計算!L40","v":28.70000000000033},"分",{"$f":"計算!M40","v":"Ｅ"},"符号"]
[]
[]
[]
[null,null,null,"入力禁止"]
[null,null,"2.針路（方位）改正"]
[null,null,null,null,"符号",null,null,null,null,"符号"]
[null,null,"コンパス針路",{"$f":"計画!D36","v":29},null,null,"真針路",null,{"$f":"計画!I36","v":170}]
[null,null,"自差",{"$f":"計画!D37","v":2},{"$f":"計画!E37","v":"Ｗ"},null,"自差",null,{"$f":"計画!I37","v":1},{"$f":"計画!J37","v":"Ｅ"}]
[null,null,"偏差",{"$f":"計画!D38","v":6},{"$f":"計画!E38","v":"Ｅ"},null,"偏差",null,{"$f":"計画!I38","v":3},{"$f":"計画!J38","v":"Ｗ"}]
[]
[null,null,"真針路",{"$f":"計算!D53","v":33},null,null,"コンパス針路",null,{"$f":"計算!J53","v":172}]
[]
[]
[]
[null,null,"入力禁止"]
[null,null,"3.恒星観測計画","（索星）"]
[null,null,"星（恒星）の天測計画","年","月","日",null,"クロノメ－タ－","時","分","秒"]
[null,null,"観測日",{"$f":"計画!D48","v":0},{"$f":"計画!E48","v":10},{"$f":"計画!F48","v":12},null,"世界時（ＵＴ）",{"$f":"計画!I48","v":17},{"$f":"計画!J48","v":40},{"$f":"計画!K48","v":20}]
[null,null,null,null,"度","分","符号",null,"度","分","符号"]
[null,null,"推測位置","推測緯度",{"$f":"計画!E50","v":25},{"$f":"計画!F50","v":10},{"$f":"計画!G50","v":"N"},"推測経度",{"$f":"計画!I50","v":158},{"$f":"計画!J50","v":48},{"$f":"計画!K50","v":"E"}]
[]
[null,null,null,"例",null,null,"度","分"]
[null,null,"ＡＩＲ　ＮＡＶＩＧＡＴＩＯＮ","a表より","年，月",null,{"$f":"計画!G53","v":10},{"$f":"計画!H53","v":2},{"$f":"G51+H51/60","v":10.033333333333333}]
[null,null,"ＴＡＢＬＥ4より","ｂ表より","日、時",null,{"$f":"計画!G54","v":266},{"$f":"計画!H54","v":32},{"$f":"G52+H52/60","v":266.53333333333336}]
[null,null,null,"ｃ表より","分、秒",null,{"$f":"計画!G55","v":10},{"$f":"計画!H55","v":7},{"$f":"G53+H53/60","v":10.116666666666667}]
[null,null,null,"GHA",null,null,{"$f":"J54","v":286},{"$f":"J55*60","v":41.000000000003638},{"$f":"I51+I52+I53","v":286.68333333333339},{"$f":"ROUNDDOWN(I55,0)","v":286}]
[null,null,"ｗのときチェック入れる","加算","減算",null,null,null,{"$f":"IF(I54>=360,I54-360,I54)","v":286.68333333333339},{"$f":"I55-J54","v":0.68333333333339397}]
[null,null,"（E　+,　W　-）","推測経度",{"$f":"I48","v":158},null,{"$f":"計画!G58","v":158},{"$f":"計画!H58","v":48},{"$f":"G56+H56/60","v":158.80000000000001},false]
[null,null,null,"LHA",null,null,{"$f":"I58","v":85},{"$f":"J58","v":29.00000000000432},{"$f":"IF(J56,I54-I56,I54+I56)","v":445.48333333333341},{"$f":"IF(I57>=360,I57-360,I57)","v":85.483333333333405}]
[null,null,null,null,null,null,null,null,{"$f":"ROUNDDOWN(J57,0)","v":85},{"$f":"(J57-I58)*60","v":29.00000000000432}]
[null,null,"天測する星を見つける",null,null,null,null,null,{"$f":"ROUND(J57,1)","v":85.5}]
[null,null,"ＡＩＲ　ＮＡＶＩＧＡＴＩＯＮ","7個の","恒星の方位",null,"と高度が判明"]
[null,null,"ＳＩＧＨＴ　ＲＥＤＵＣＴＩＯＮ",null,{"$f":"E48","v":25},null,{"$f":"G48","v":"N"}]
[null,null,"ＴＡＢＬＥＳを利用する",null,"ＬＨＡ",null,{"$f":"ROUND(I59,0)","v":86}]

{"sheet":"計（推測）","index":7,"n_rows":26,"n_cols":14,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[null,"90度式に変換",null,"入力禁止"]
[null,"針路・方位"]
[null,"360度式",{"$f":"推測!C3","v":250},null,{"$f":"IF(C3<90,\"Ｎ\",\"\")","v":""}]
[]
[null,null,"符号","度","符号"]
[null,"９０度式",{"$f":"IF(D6<90,\"Ｎ\",\"\")","v":""},{"$f":"IF(C3<90,C3,\"\")","v":""},{"$f":"IF(C3>180,\"Ｗ\",\"Ｅ\")","v":"Ｗ"}]
[null,null,{"$f":"IF(D7<90,\"Ｓ\",\"\")","v":""},{"$f":"IF(C3>90,E7,\"\")","v":""},{"$f":"IF(C3<180,180-C3,\"\")","v":""}]
[null,null,{"$f":"IF(D8<90,\"Ｓ\",\"\")","v":"Ｓ"},{"$f":"IF(E8>0,E8,\"\")","v":70},{"$f":"IF(270>C3,C3-180,\"\")","v":70}]
[null,null,{"$f":"IF(D9<90,\"Ｎ\",\"\")","v":""},{"$f":"E9","v":""},{"$f":"IF(C3>270,360-C3,\"\")","v":""}]
[]
[]
[null,"推測位置を求める",null,"入力禁止"]
[null,"中分緯度航法",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M14,\"Ｎ\",\"Ｓ\")","v":"Ｎ"}]
[null,null,{"$f":"推測!C14","v":10},"月",{"$f":"推測!E14","v":28},"日",null,null,{"$f":"IF(I15,\"Ｎ\",\"Ｓ\")","v":"Ｓ"},null,"ｓｉｎ","ｃｏｓ",{"$f":"IF(I15,1,-2)","v":-2}]
[null,null,{"$f":"推測!C15","v":9},"時",{"$f":"推測!E15","v":0},"分",null,null,false,{"$f":"RADIANS(E17)","v":1.2217304763960306},{"$f":"SIN(J15)","v":0.93969262078590832},{"$f":"COS(J15)","v":0.34202014332566882},{"$f":"IF(M16,\"Ｅ\",\"Ｗ\")","v":"Ｅ"}]
[null,null,"符号",null,null,null,"符号",null,{"$f":"IF(I17,\"Ｅ\",\"Ｗ\")","v":"Ｗ"},null,null,null,{"$f":"IF(I17,1,-2)","v":-2}]
[null,"針路",null,null,{"$f":"推測!E17","v":70},"度",null,null,false,"Ｄｌ","Ｄｅｐ","ｌ+ｌ/2",null,"cosｍｉｄｌ"]
[null,"航程",{"$f":"推測!C18","v":53},"海里",null,null,null,null,null,{"$f":"(C18*L15)/60","v":0.30211779327100746},{"$f":"C18*K15","v":49.803708901653138},{"$f":"(K21+M21)/2","v":27.098941103364496},{"$f":"RADIANS(L18)","v":0.47296574605773545},{"$f":"COS(M18)","v":0.89022122349054589}]
[]
[null,null,"度",null,"分",null,"符号",null,{"$f":"IF(I21,\"Ｎ\",\"Ｓ\")","v":"Ｎ"},null,null,{"$f":"I20","v":"Ｎ"},"符号"]
[null,"出発緯度",{"$f":"推測!C21","v":27},null,{"$f":"推測!E21","v":15},null,null,null,true,null,{"$f":"C21+E21/60","v":27.25},{"$f":"IF(I21,1,-2)","v":1},{"$f":"IF(M14-L21=0,K21+J18,K21-J18)","v":26.947882206728991}]
[null,"出発経度",{"$f":"推測!C22","v":138},null,{"$f":"推測!E22","v":40},null,null,null,{"$f":"IF(I23,\"Ｅ\",\"Ｗ\")","v":"Ｅ"},null,{"$f":"C22+E22/60","v":138.66666666666666},{"$f":"I22","v":"Ｅ"},{"$f":"IF(M16-L23=0,K22+K24,K22-K24)","v":137.73424471005131}]
[null,null,null,null,null,null,null,null,true,null,"ＤＬ",{"$f":"IF(I23,1,-2)","v":1}]
[null,null,"度",null,"分",null,"符号",null,null,null,{"$f":"(K18/N18)/60","v":0.932421956615335}]
[null,"到達緯度",{"$f":"K25","v":26},null,{"$f":"M25","v":56.9},null,{"$f":"I20","v":"Ｎ"},null,null,null,{"$f":"ROUNDDOWN(M21,0)","v":26},{"$f":"(M21-K25)*60","v":56.872932403739469},{"$f":"ROUND(L25,1)","v":56.9}]
[null,"到達経度",{"$f":"K26","v":137},null,{"$f":"M26","v":44.1},null,{"$f":"I22","v":"Ｅ"},null,null,null,{"$f":"ROUNDDOWN(M22,0)","v":137},{"$f":"(M22-K26)*60","v":44.054682603078845},{"$f":"ROUND(L26,1)","v":44.1}]

{"sheet":"計（正中時）","index":8,"n_rows":83,"n_cols":12,"rows_kept":83,"cut":false,"hidden":false,"merged":[]}
[null,"入力禁止"]
[null,"正中時を求める",{"$f":"正中時!C2","v":11},"月",{"$f":"正中時!E2","v":9},"日"]
[null,"１２時の概経度",{"$f":"正中時!C3","v":32},"度",{"$f":"正中時!E3","v":50},"分",null,null,"符号"]
[null,{"$f":"C3+E3/60","v":32.833333333333336},{"$f":"B4/15","v":2.1888888888888891},{"$f":"ROUNDDOWN(C4,0)","v":2},{"$f":"C4-D4","v":0.18888888888888911},{"$f":"E4*60","v":11.333333333333346},{"$f":"ROUNDDOWN(F4,0)","v":11},{"$f":"F4-G4","v":0.33333333333334636},{"$f":"H4*60","v":20.000000000000782}]
[null,null,12,"時",0,"分",0,"秒",false,{"$f":"TIME(C5,E5,G5)","v":0.5}]
[null,null,12,"時",0,"分",0,"秒","24-Ｅ◎",{"$f":"TIME(C6,E6,G6)","v":0.5}]
[null,"Ｅ◎（Ｕ１２時）",{"$f":"正中時!C7","v":12},"時",{"$f":"正中時!E7","v":16},"分",{"$f":"正中時!G7","v":12},"秒",{"$f":"J5+J6-J7","v":0.48875000000000002},{"$f":"TIME(C7,E7,G7)","v":0.51124999999999998}]
[null,"１２時の概経度",{"$f":"D4","v":2},null,{"$f":"G4","v":11},"分",{"$f":"I4","v":20.000000000000782},"秒",true,{"$f":"TIME(C8,E8,G8)","v":9.1203703703703717E-2}]
[null,"船内使用時",{"$f":"正中時!C9","v":2},"時",{"$f":"正中時!E9","v":0},"分",null,null,{"$f":"IF(I8,I7-J8,I7+J8)","v":0.39754629629629629},{"$f":"TIME(C9,E9,0)","v":8.3333333333333329E-2}]
[null,null,null,null,null,null,null,null,{"$f":"IF(I8,I9+J9,I9-J9)","v":0.4808796296296296},{"$f":"ABS(I10)","v":0.4808796296296296}]
[null,"太陽子午線正中時",{"$f":"HOUR(J10)","v":11},"時",{"$f":"MINUTE(J10)","v":32},"分","頃",null,true]
[]
[]
[]
[]
[null,"太陽子午線高度緯度法",null,"入力禁止"]
[]
[null,"観測日",{"$f":"正中時!C18","v":11},"月",{"$f":"正中時!E18","v":9},"日",null,"眼高",{"$f":"正中時!I18","v":3},"ｍ"]
[null,null,null,null,null,null,null,"ログ指値",{"$f":"正中時!I19","v":0}]
[null,null,null,null,null,null,"気温",{"$f":"正中時!H20","v":30},"水温",{"$f":"正中時!J20","v":28}]
[]
[null,"クロノメ－タ－",{"$f":"正中時!C22","v":0},"時",{"$f":"正中時!E22","v":0},"分",{"$f":"正中時!G22","v":0},"秒",{"$f":"TIME(C22,E22,G22)","v":0}]
[null,"エラ－",null,null,{"$f":"正中時!E23","v":0},null,{"$f":"正中時!G23","v":0},null,{"$f":"TIME(0,E23,G23)","v":0}]
[null,"Ｕ",{"$f":"正中時!C24","v":0},null,{"$f":"正中時!E24","v":0},null,{"$f":"正中時!G24","v":0},null,{"$f":"I22+I23","v":0}]
[null,null,null,null,null,null,"符号",null,true]
[null,"推測緯度（ｌ）",{"$f":"正中時!C26","v":36},"度",{"$f":"正中時!E26","v":26.7},"分",null,null,{"$f":"IF(I25,\"Ｎ\",\"Ｓ\")","v":"Ｎ"}]
[null,"　　　　　　　　経度",{"$f":"正中時!C27","v":155},"度",{"$f":"正中時!E27","v":30.2},"分",null,null,{"$f":"IF(I25,1,-2)","v":1},{"$f":"C26+E26/60","v":36.445}]
[null,null,null,null,null,null,"符号",null,{"$f":"IF(I29,\"Ｎ\",\"Ｓ\")","v":"Ｓ"}]
[null,"天測暦　→　赤緯（ｄ）",{"$f":"正中時!C29","v":13},"度",{"$f":"正中時!E29","v":1},"分",null,null,false]
[null,null,null,null,null,null,"符号"]
[null,null,null,"度",null,"分",true,{"$f":"IF(G31,\"Ｅ\",\"Ｗ\")","v":"Ｅ"},"ｄ"]
[null,"観測高度",{"$f":"正中時!C32","v":40},null,{"$f":"正中時!E32","v":29},null,{"$f":"C32+E32/60","v":40.483333333333334},{"$f":"IF(I29,1,-2)","v":-2},{"$f":"C29+E29/60","v":13.016666666666667},{"$f":"I32*-1","v":-13.016666666666667}]
[null,"器差",null,null,{"$f":"正中時!E33","v":-2.5},null,{"$f":"C33+E33/60","v":-4.1666666666666664E-2},{"$f":"G32+G33","v":40.44166666666667}]
[null,null,{"$f":"G34","v":40},null,{"$f":"H34","v":26.500000000000199},null,{"$f":"ROUNDDOWN(H33,0)","v":40},{"$f":"(H33-G34)*60","v":26.500000000000199}]
[null,"改正1",0,null,{"$f":"C83","v":11.6},null,{"$f":"C35+E35/60","v":0.19333333333333333}]
[null,"改正2",0,null,{"$f":"H69","v":0.3},null,{"$f":"C36+E36/60","v":5.0000000000000001E-3}]
[null,"改正3",0,null,{"$f":"J72","v":0.4},null,{"$f":"C37+E37/60","v":6.6666666666666671E-3},{"$f":"H33+G35+G36+G37","v":40.646666666666675}]
[null,"真高度　（ａ）",{"$f":"G38","v":40},null,{"$f":"H38","v":38.800000000000523},null,{"$f":"ROUNDDOWN(H37,0)","v":40},{"$f":"(H37-G38)*60","v":38.800000000000523}]
[null,null,90,null,null,null,{"$f":"C39-H37","v":49.353333333333325},{"$f":"ROUNDDOWN(G39,0)","v":49}]
[null,"９０－ａ",{"$f":"H39","v":49},null,{"$f":"G40","v":21.199999999999477},null,{"$f":"(G39-H39)*60","v":21.199999999999477},null,"ｌ-ｄ",{"$f":"J27-I32","v":23.428333333333335}]
[null,null,null,null,null,"ｌ、ｄ異名",{"$f":"IF(I41<0,G39+J32,1)","v":36.336666666666659},"ｌ、ｄ同名",{"$f":"IF(I27-H32=0,1,-1)","v":-1}]
[null,null,null,null,null,{"$f":"ROUNDDOWN(G41,0)","v":36},{"$f":"(G41-F42)*60","v":20.199999999999534}]
[null,null,null,null,null,"ｌ＞ｄ",{"$f":"IF(J40>0,I32+G39,I32-G39)","v":62.36999999999999},{"$f":"ROUNDDOWN(G43,0)","v":62},{"$f":"(G43-H43)*60","v":22.19999999999942}]
[null,null,null,null,null,"ｌ＜ｄ"]
[null,"正中時緯度（Ａ）",{"$f":"IF(I41<0,0,H43)","v":0},null,{"$f":"IF(I41<0,0,I43)","v":0},null,{"$f":"IF(I41<0,\"\",I26)","v":""},"ｌ、ｄ同名の時",{"$f":"C45+E45/60","v":0}]
[null,"正中時緯度（Ａ）",{"$f":"IF(I41<0,F42,0)","v":36},null,{"$f":"IF(I41<0,G42,0)","v":20.199999999999534},null,{"$f":"IF(I41<0,I26,\"\")","v":"Ｎ"},"ｌ、ｄ異名の時",{"$f":"C46+E46/60","v":36.336666666666659},{"$f":"I45+I46","v":36.336666666666659}]
[]
[null,"修正差（Ｉ）北半球の時",{"$f":"IF(E46>100,\"ミスがあるか、流されています\",\"\")","v":""},null,{"$f":"IF(I27>0,I49,0)","v":6.5000000000004832},{"$f":"IF(I27>0,G48,\"\")","v":"Ｓ"},{"$f":"IF(J48>0,\"Ｓ\",\"Ｎ\")","v":"Ｓ"},null,"ｌ－ａ",{"$f":"J27-J46","v":0.10833333333334139}]
[null,"修正差（Ｉ）南半球の時",{"$f":"IF(E49>100,\"ミスがあるか、流されています\",\"\")","v":""},null,{"$f":"IF(I27<0,I49,0)","v":0},{"$f":"IF(H32<0,G49,\"\")","v":"Ｎ"},{"$f":"IF(J48>0,\"Ｎ\",\"Ｓ\")","v":"Ｎ"},null,{"$f":"J49*60","v":6.5000000000004832},{"$f":"ABS(J48)","v":0.10833333333334139}]
[]
[]
[]
[null,"改正1",null,null,null,null,"改正２","太陽",null,"改正3","太陽と","星"]
[null,"　太陽","眼高",null,"眼高",null,"月","下辺",null,"気温-","水温＝","差"]
[null,"高度","2ｍ","高度","3ｍ",null,1,0.5,null,"℃差","+","-"]
[null,15,9.8000000000000007,15,9.3000000000000007,null,2,0.5,null,0,0,0]
[null,16,10.1,16,9.5,null,3,0.4,null,1,0.2,-0.2]
[null,17,10.3,17,9.6999999999999993,null,4,0.2,null,2,0.4,-0.4]
[null,18,10.4,18,9.9,null,5,0.1,null,3,0.6,-0.6]
[null,20,10.7,20,10.199999999999999,null,6,0,null,4,0.8,-0.8]
[null,22,11,22,10.4,null,7,0,null,5,1,-1]
[null,24,11.2,24,10.7,null,8,0.1,null,6,1.2,-1.2]
[null,26,11.4,26,10.8,null,9,0.2,null,7,1.4,-1.4]
[null,28,11.6,28,11,null,10,0.3,null,8,1.6,-1.6]
[null,30,11.7,30,11.1,null,11,0.3,null,9,1.8,-1.8]
[null,32,11.8,32,11.3,null,12,0.5,null,10,2,-2]
[null,34,11.9,34,11.4,null,null,null,null,11,2.2000000000000002,-2.2000000000000002]
[null,36,12,36,11.5,null,{"$f":"C18+E18/30","v":11.3},null,null,12,2.4,-2.4]
[null,38,12.1,38,11.6,null,{"$f":"ROUND(G68,0)","v":11},{"$f":"VLOOKUP(G69,G55:H66,2,1)","v":0.3},null,13,2.6,-2.6]
[null,40,12.2,40,11.6,null,null,null,null,14,2.8,-2.8]
[null,45,12.4,45,11.8,null,null,null,null,{"$f":"ABS(J73)","v":2},{"$f":"VLOOKUP(J71,J56:L70,2,1)","v":0.4},{"$f":"VLOOKUP(J71,J56:L70,3,1)","v":-0.4}]
[null,50,12.5,50,12,null,null,null,null,{"$f":"IF(I71>=0,K71,L71)","v":0.4}]
[null,55,12.6,55,12.1,null,null,null,null,{"$f":"H20-J20","v":2}]
[null,60,12.8,60,12.2]
[null,65,12.9,65,12.3]
[null,70,12.9,70,12.4]
[null,75,13,75,12.5]
[null,80,13.1,80,12.5]
[null,85,13.2,85,12.6]
[null,90,13.2,90,12.7]
[]
[null,{"$f":"H33","v":40.44166666666667},{"$f":"VLOOKUP(B82,B56:C80,2,1)","v":12.2},{"$f":"H33","v":40.44166666666667},{"$f":"VLOOKUP(D82,D56:E80,2,1)","v":11.6}]
[null,null,{"$f":"IF(I18=3,E82,C82)","v":11.6}]

{"sheet":"計（太陽）","index":9,"n_rows":88,"n_cols":19,"rows_kept":88,"cut":false,"hidden":false,"merged":[]}
[null,"入力禁止",null,null,null,null,null,null,null,null,null,null,null,"ｈ＜0","時間ｈ","ｈ","ｍ","ｓ"]
[null,"天測太陽2",null,null,null,"（","ＫＨメソッド","）",null,null,null,null,null,{"$f":"IF(K18<0,K18+1,K18)","v":1.1080324074074073},null,{"$f":"HOUR(N2)","v":2},{"$f":"MINUTE(N2)","v":35},{"$f":"SECOND(N2)","v":34}]
[null,null,1,"回目","天測"]
[null,"観測天体","（太陽1、","恒星2）",1,null,null,null,null,null,null,null,null,null,null,{"$f":"P2*15","v":30},{"$f":"Q2*15","v":525},{"$f":"R2*15","v":510}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q6+P4","v":38},{"$f":"Q4/60","v":8.75},{"$f":"R4/60","v":8.5}]
[null,"観測日",{"$f":"太陽!C6","v":2},"月",{"$f":"太陽!E6","v":10},"日",null,null,null,null,null,null,null,null,null,null,{"$f":"INT(Q5)","v":8},{"$f":"ROUND(R5,1)","v":8.5}]
[null,"観測時間",{"$f":"太陽!C7","v":14},"時",{"$f":"太陽!E7","v":50},"分頃",null,null,null,"ｌ",{"$f":"IF(K10,\"Ｎ\",\"Ｓ\")","v":"Ｎ"},null,null,null,null,null,{"$f":"Q5-Q6","v":0.75}]
[null,"観測高度",{"$f":"太陽!C16","v":33},"度",{"$f":"太陽!E16","v":34},"分",null,null,null,"Ｌｏｎｇ",true,null,null,null,null,null,{"$f":"Q7*60","v":45}]
[null,"器差",null,null,{"$f":"太陽!E17","v":0},null,"符号",{"$f":"恒星!G10","v":0},null,"ｌ異符号",{"$f":"IF(K10,\"Ｓ\",\"Ｎ\")","v":"Ｓ"},null,null,"ｈ(D)",null,"度","分"]
[null,"観測時　　　緯度",{"$f":"太陽!C9","v":27},"度",{"$f":"太陽!E9","v":15},"分",null,null,null,"ｌ’",true,{"$f":"IF(K10,1,-2)","v":1},"ＤＬ",{"$f":"P10+Q10/60","v":38.891666666666666},"時角　ｈ",{"$f":"P5","v":38},{"$f":"Q8+R6","v":53.5}]
[null,"推測位置　経度",{"$f":"太陽!C10","v":138},"度",{"$f":"太陽!E10","v":40},"分",null,null,null,"ｄ’",false,{"$f":"IF(K11,1,-2)","v":-2},{"$f":"TIME(P22,Q22,R22)","v":0.38518518518518513}]
[null,"クロノメ－タ－",{"$f":"太陽!C12","v":5},"時",{"$f":"太陽!E12","v":23},"分",{"$f":"太陽!G12","v":46},"秒",null,"ＣＴ(S)",{"$f":"TIME(C12,E12,G12)","v":0.22483796296296296},null,null,null,null,"度","分"]
[null,"エラ－",null,null,{"$f":"太陽!E13","v":11},"分",{"$f":"太陽!G13","v":25},"秒",null,"ｅｒｏｒ(S)",{"$f":"TIME(C13,E13,G13)","v":7.9282407407407409E-3},null,"d,l同符号",null,"角度（ＤＬ）",{"$f":"C11","v":138},{"$f":"E11","v":40},{"$f":"P13+Q13/60","v":138.66666666666666},{"$f":"R13/15","v":9.2444444444444436}]
[null,null,"進む",null,"遅れる",null,null,null,null,true,{"$f":"IF(J14,K12+K13,K12-K13)","v":0.23276620370370371},null,{"$f":"SIN(L19)","v":0.25282931742565234},null,null,null,null,{"$f":"ROUNDDOWN(S13,0)","v":9},{"$f":"S13-R14","v":0.24444444444444358}]
[null,"天測暦、E◎ｏｒE*",{"$f":"太陽!C19","v":11},"時",{"$f":"太陽!E19","v":45},"分",{"$f":"太陽!G19","v":43},"秒",null,"E*(S)",{"$f":"TIME(C15,E15,G15)","v":0.49008101851851849},null,"d,l異符号",null,null,null,null,{"$f":"S14*60","v":14.666666666666615},{"$f":"ROUNDDOWN(R15,0)","v":14}]
[null,"赤緯（ｄ）",{"$f":"太陽!C20","v":14},"度",{"$f":"太陽!E20","v":38.700000000000003},"分",null,null,null,"ＧＨＡ(S)",{"$f":"K15+K14","v":0.7228472222222222},null,{"$f":"M14*-1","v":-0.25282931742565234},null,null,null,null,{"$f":"R15-S15","v":0.66666666666661456},{"$f":"R16*60","v":39.999999999996874}]
[null,"眼高",{"$f":"太陽!C21","v":3},"ｍ",null,null,"符号",null,null,"ＤＬ(S)",{"$f":"IF(K8,M11,M11*-1)","v":0.38518518518518513},"ｒａｄｉａｎ","ｓｉｎ","ｃｏｓ",null,"ｈ","ｍ","ｓ"]
[null,"ログ指示値",{"$f":"太陽!C22","v":217.3},"海里",null,null,null,null,null,"ｈ(S)",{"$f":"K16+K17","v":1.1080324074074073},{"$f":"RADIANS(N10)","v":0.67878763492146132},{"$f":"SIN(L18)","v":0.62784986013008504},{"$f":"COS(L18)","v":0.77833447381870002}]
[null,"気温",{"$f":"太陽!C23","v":20},"度Ｃ",null,null,null,null,null,"ｄ",{"$f":"C16+E16/60","v":14.645},{"$f":"RADIANS(K19)","v":0.25560346895456953},{"$f":"IF(L10-L11=0,M14,M16)","v":-0.25282931742565234},{"$f":"COS(L19)","v":0.96751089722549311}]
[null,"水温",{"$f":"太陽!C24","v":20},"度Ｃ",null,null,null,null,null,"ｌ",{"$f":"C10+E10/60","v":27.25},{"$f":"RADIANS(K20)","v":0.4756022211684548},{"$f":"SIN(L20)","v":0.45787391511695674},{"$f":"COS(L20)","v":0.88901714148573641}]
[null,"天体概方位",{"$f":"太陽!C25","v":"N"},{"$f":"太陽!D25","v":58},"度",{"$f":"太陽!F25","v":"E"},"符号",null,null,"ｌ、ｄ同異",{"$f":"M20*M19+N20*N19*N18","v":0.5537078175789486}]
[null,null,null,null,null,null,null,null,null,"Ａｃ",{"$f":"ASIN(K21)","v":0.58681038636107208},{"$f":"RADIANS(K23)","v":0.58681038636107208},null,{"$f":"COS(L22)","v":0.83271102595795965},"時間（ＤＬ）",{"$f":"R14","v":9},{"$f":"S15","v":14},{"$f":"IF(S16>=60,S16-60,S16)","v":39.999999999996874}]
[null,null,null,null,null,null,null,null,null,"ｄｅｇ",{"$f":"DEGREES(K22)","v":33.621758512930633},"Ｅ",{"$f":"M14/M20","v":0.55218108976806646},{"$f":"ASIN(M23)","v":0.58497805905712963}]
[null,"天測結果",null,null,null,null,null,null,null,"ＡＢＳｄｅｇ",{"$f":"ABS(K23)","v":33.621758512930633}]
[null,"修正差（I）",{"$f":"M28","v":11.5},{"$f":"IF(C25>100,\"ミスがあるか、流されているので注意！\",\"\")","v":""},null,null,null,null,null,null,{"$f":"ROUNDDOWN(K24,0)","v":33},{"$f":"(K24-K25)*60","v":37.305510775837973},{"$f":"ROUND(L25,1)","v":37.299999999999997},null,"ａｎｏｔｈｅｒ",{"$f":"IF(L10-L11=0,\"\",K9)","v":"Ｓ"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ｓａｍｅ"]
[null,null,"符号",null,null,null,null,null,null,"Ａｏ",{"$f":"C8+E8/60","v":33.56666666666667},"Ｉ",{"$f":"(K33-K24)*60","v":11.494489224161981},null,"ｄ-ｌ＞0","ｄ＜ｌ"]
[null,null,{"$f":"L33","v":"Ｓ"},"度","符号",null,null,null,null,"ＩＥ",{"$f":"恒星!E9/60","v":0.05},null,{"$f":"ROUND(M27,1)","v":11.5},null,{"$f":"K19-K20","v":-12.605}]
[null,"方位角（Z）",{"$f":"L34","v":""},{"$f":"M33","v":47},{"$f":"N33","v":"Ｗ"},null,null,null,null,"Ａｓ",{"$f":"K27+K28","v":33.616666666666667},"ｚ",{"$f":"M18*N19/N22","v":0.72948665570813132},null,{"$f":"IF(O28>0,'計（太陽）'!K7,\"\")","v":""},"Ｅ-Ａｃ","Ｅ＜Ａｃ"]
[null,null,{"$f":"L35","v":""},null,null,null,null,null,null,1,{"$f":"D59/60","v":0.18833333333333335},{"$f":"D59","v":11.3},{"$f":"ASIN(M29)","v":0.81757114116819829},null,null,{"$f":"N23-K29","v":-33.031688607609539}]
[null,null,null,null,null,null,null,null,null,2,{"$f":"G59/60","v":8.3333333333333332E-3},{"$f":"G59","v":0.5},{"$f":"DEGREES(M30)","v":46.843375840632191},null,{"$f":"IF(L10-L11=0,O32,\"\")","v":""},{"$f":"IF(P30>0,K7,K9)","v":"Ｓ"}]
[null,null,null,null,null,null,null,null,null,3,{"$f":"L59/60","v":0},{"$f":"L59","v":0},{"$f":"ABS(M31)","v":46.843375840632191},null,{"$f":"IF(O28<0,P31,\"\")","v":"Ｓ"}]
[null,null,null,null,null,null,null,null,null,"Ａｔ",{"$f":"K29+K30+K31+K32","v":33.813333333333333},{"$f":"IF(L10-L11=0,\"\",P25)","v":"Ｓ"},{"$f":"ROUND(M32,0)","v":47},{"$f":"IF(N10>180,\"Ｅ\",\"Ｗ\")","v":"Ｗ"},"Ａｔ",{"$f":"ROUNDDOWN(K33,0)","v":33},{"$f":"(K33-P33)*60","v":48.799999999999955}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L10-L11=0,O29,\"\")","v":""},null,null,"Ac",{"$f":"K25","v":33},{"$f":"M25","v":37.299999999999997}]
[null,"太陽の赤緯ｄ",null,"入力禁止",null,null,null,null,null,null,null,{"$f":"O31","v":""},null,null,"I",null,{"$f":"M28","v":11.5}]
[null,"比例部分の計算",null,null,null,null,"ｄ"]
[null,null,"時","分","秒",null,"度",null,"分",null,null,{"$f":"IF(K10+K11=0,O29,\"\")","v":""}]
[null,1,{"$f":"太陽!C42","v":8},{"$f":"太陽!D42","v":0},{"$f":"太陽!E42","v":0},null,{"$f":"太陽!G42","v":20},null,{"$f":"太陽!I42","v":14.5}]
[null,null,{"$f":"TIME(C38,D38,E38)","v":0.33333333333333331},null,null,null,{"$f":"G38+I38/60","v":20.241666666666667}]
[null,2,{"$f":"太陽!D44","v":0},null,{"$f":"太陽!E44","v":0},null,{"$f":"太陽!G44","v":20},null,{"$f":"太陽!I44","v":13.4}]
[null,null,{"$f":"TIME(C40,D40,E40)","v":0},{"$f":"ABS(C41-C39)","v":0.33333333333333331},null,null,{"$f":"G40+I40/60","v":20.223333333333333},{"$f":"ABS(G41-G39)","v":1.8333333333334423E-2}]
[null,"求める比例部分",{"$f":"太陽!C47","v":9},{"$f":"太陽!D47","v":23},{"$f":"太陽!E47","v":0},null,{"$f":"太陽!G47","v":20},null,{"$f":"太陽!I47","v":13.7}]
[null,null,{"$f":"TIME(C42,D42,E42)","v":0.39097222222222222},{"$f":"ABS(C43-C39)","v":5.7638888888888906E-2},null,{"$f":"H41*D43/D41","v":3.1701388888890785E-3},{"$f":"IF(G41-G39>0,G39+F43,G39-F43)","v":20.238496527777777},{"$f":"ROUNDDOWN(G43,0)","v":20},{"$f":"(G43-H43)*60","v":14.309791666666598},{"$f":"ROUND(I43,1)","v":14.3}]
[]
[]
[]
[null,"太陽のE◎",null,"入力禁止"]
[null,"比例部分の計算"]
[null,null,"時","分","秒",null,"時","分","秒"]
[null,1,{"$f":"太陽!C56","v":4},{"$f":"太陽!D56","v":0},{"$f":"太陽!E56","v":0},null,{"$f":"太陽!G56","v":12},{"$f":"太陽!H56","v":2},{"$f":"太陽!I56","v":32}]
[null,null,{"$f":"TIME(C50,D50,E50)","v":0.16666666666666666},null,null,null,{"$f":"TIME(G50,H50,I50)","v":0.50175925925925924}]
[null,2,{"$f":"太陽!C58","v":6},{"$f":"太陽!D58","v":0},{"$f":"太陽!E58","v":0},null,{"$f":"太陽!G58","v":12},{"$f":"太陽!H58","v":2},{"$f":"太陽!I58","v":33}]
[null,null,{"$f":"TIME(C52,D52,E52)","v":0.25},{"$f":"ABS(C53-C51)","v":8.3333333333333343E-2},null,null,{"$f":"TIME(G52,H52,I52)","v":0.50177083333333339},{"$f":"ABS(G53-G51)","v":1.1574074074149898E-5}]
[null,"求める比例部分",{"$f":"太陽!C62","v":4},{"$f":"太陽!D62","v":50},{"$f":"太陽!E62","v":0},null,{"$f":"太陽!G62","v":12},{"$f":"太陽!H62","v":2},{"$f":"太陽!I62","v":32}]
[null,null,{"$f":"TIME(C54,D54,E54)","v":0.20138888888888887},{"$f":"ABS(C55-C51)","v":3.472222222222221E-2},null,{"$f":"D55*H53/D53","v":4.8225308642291217E-6},{"$f":"IF(G53-G51>0,G51+F55,G51-F55)","v":0.50176408179012344}]
[]
[]
[]
["改正1","入力禁止","改正値",{"$f":"B88","v":11.3},null,"改正値",{"$f":"G74","v":0.5},"入力禁止",null,"入力禁止","改正値",{"$f":"K79","v":0}]
["　太陽","眼高",null,"眼高",null,"改正２","太陽",null,null,"改正3","太陽と","星"]
["高度","2ｍ","高度","3ｍ",null,"月","下辺",null,null,"気温-","水温＝","差"]
[15,9.8000000000000007,15,9.3000000000000007,null,1,0.5,null,null,"℃差","+","-"]
[16,10.1,16,9.5,null,2,0.5,null,null,0,0,0]
[17,10.3,17,9.6999999999999993,null,3,0.4,null,null,1,0.2,-0.2]
[18,10.4,18,9.9,null,4,0.2,null,null,2,0.4,-0.4]
[20,10.7,20,10.199999999999999,null,5,0.1,null,null,3,0.6,-0.6]
[22,11,22,10.4,null,6,0,null,null,4,0.8,-0.8]
[24,11.2,24,10.7,null,7,0,null,null,5,1,-1]
[26,11.4,26,10.8,null,8,0.1,null,null,6,1.2,-1.2]
[28,11.6,28,11,null,9,0.2,null,null,7,1.4,-1.4]
[30,11.7,30,11.1,null,10,0.3,null,null,8,1.6,-1.6]
[32,11.8,32,11.3,null,11,0.3,null,null,9,1.8,-1.8]
[34,11.9,34,11.4,null,12,0.5,null,null,10,2,-2]
[36,12,36,11.5,null,{"$f":"C6+E6/30","v":2.3333333333333335},{"$f":"VLOOKUP(F75,F62:G73,2,0)","v":0.5},null,null,11,2.2000000000000002,-2.2000000000000002]
[38,12.1,38,11.6,null,{"$f":"ROUND(F74,0)","v":2},null,null,null,12,2.4,-2.4]
[40,12.2,40,11.6,null,null,null,null,null,13,2.6,-2.6]
[45,12.4,45,11.8,null,null,null,null,null,14,2.8,-2.8]
[50,12.5,50,12,null,null,null,null,null,{"$f":"ABS(J79)","v":0},{"$f":"VLOOKUP(J78,J63:L77,2,1)","v":0},{"$f":"VLOOKUP(J78,J63:L77,3,1)","v":0}]
[55,12.6,55,12.1,null,null,null,null,null,{"$f":"C19-C20","v":0},{"$f":"IF(J79>0,K78,L78)","v":0}]
[60,12.8,60,12.2]
[65,12.9,65,12.3]
[70,12.9,70,12.4]
[75,13,75,12.5]
[80,13.1,80,12.5]
[85,13.2,85,12.6]
[90,13.2,90,12.7]
[{"$f":"K29","v":33.616666666666667},{"$f":"VLOOKUP(A87,A62:B86,2,1)","v":11.8},{"$f":"K27","v":33.56666666666667},{"$f":"VLOOKUP(C87,C62:D86,2,1)","v":11.3}]
[null,{"$f":"IF(C17=2,B87,D87)","v":11.3}]

{"sheet":"計（恒星）","index":10,"n_rows":115,"n_cols":24,"rows_kept":115,"cut":false,"hidden":false,"merged":[]}
[null,"入力禁止",null,null,null,null,null,null,null,null,null,null,null,"ｈ＜0","時間ｈ","ｈ","ｍ","ｓ"]
[null,"天測恒星",null,null,null,"（","Ｈメソッド","）",null,null,null,null,null,{"$f":"IF(K18<0,K18+1,K18)","v":0.83839120370370357},null,{"$f":"HOUR(N2)","v":20},{"$f":"MINUTE(N2)","v":7},{"$f":"SECOND(N2)","v":17}]
[null,null,1,"回目","天測"]
[null,"観測天体","（太陽1、","恒星2）",2,null,"恒星Ｎｏ",null,null,null,null,null,null,null,null,{"$f":"P2*15","v":300},{"$f":"Q2*15","v":105},{"$f":"R2*15","v":255}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q6+P4","v":301},{"$f":"Q4/60","v":1.75},{"$f":"R4/60","v":4.25}]
[null,"観測日",{"$f":"恒星!C6","v":2},"月",{"$f":"恒星!E6","v":10},"日",null,null,null,null,null,null,null,null,null,null,{"$f":"INT(Q5)","v":1},{"$f":"ROUND(R5,1)","v":4.3},null,null,null,null,null,0]
[null,"観測時間",{"$f":"恒星!C7","v":18},"時",{"$f":"恒星!E7","v":30},"分頃",null,null,null,"ｌ",{"$f":"IF(K10,\"Ｎ\",\"Ｓ\")","v":"Ｎ"},null,null,null,null,null,{"$f":"Q5-Q6","v":0.75}]
[null,"観測高度",{"$f":"恒星!C8","v":30},"度",{"$f":"恒星!E8","v":55},"分",null,null,null,"Ｌ",true,null,null,null,null,null,{"$f":"Q7*60","v":45}]
[null,"器差",null,null,{"$f":"恒星!E9","v":3},null,"符号",{"$f":"恒星!G10","v":0},null,"ｌ異符号",{"$f":"IF(K10,\"Ｓ\",\"Ｎ\")","v":"Ｓ"},null,null,"ｈ(D)",null,"度","分"]
[null,"観測時　　　緯度",{"$f":"恒星!C10","v":26},"度",{"$f":"恒星!E10","v":56.9},"分",null,null,null,"ｌ’",true,{"$f":"IF(K10,1,-2)","v":1},"ＤＬ",{"$f":"P10+Q10/60","v":301.82166666666666},"時角　ｈ",{"$f":"P5","v":301},{"$f":"Q8+R6","v":49.3}]
[null,"推測位置　経度",{"$f":"恒星!C11","v":137},"度",{"$f":"恒星!E11","v":44.1},"分",null,null,null,"ｄ’",true,{"$f":"IF(K11,1,-2)","v":1},{"$f":"TIME(P22,Q22,R22)","v":0.3825925925925926}]
[null,"クロノメ－タ－",{"$f":"恒星!C13","v":9},"時",{"$f":"恒星!E13","v":4},"分",{"$f":"恒星!G13","v":28},"秒",null,"ＣＴ(S)",{"$f":"TIME(C12,E12,G12)","v":0.3781018518518518},null,null,null,null,"度","分"]
[null,"エラ－",null,null,{"$f":"恒星!E14","v":11},"分",{"$f":"恒星!G14","v":25},"秒",null,"ｅｒｏｒ(S)",{"$f":"TIME(C13,E13,G13)","v":7.9282407407407409E-3},null,"d,l同符号",null,"角度（ＤＬ）",{"$f":"恒星!C11","v":137},{"$f":"恒星!E11","v":44.1},{"$f":"P13+Q13/60","v":137.73500000000001},{"$f":"R13/15","v":9.1823333333333341}]
[null,null,"進む",null,"遅れる",null,null,null,null,false,{"$f":"IF(J14,K12-K13,K12+K13)","v":0.38603009259259252},null,{"$f":"SIN(L19)","v":9.2515408755937431E-2},null,null,null,null,{"$f":"ROUNDDOWN(S13,0)","v":9},{"$f":"S13-R14","v":0.18233333333333412}]
[null,"天測暦、E◎ｏｒE*",{"$f":"恒星!C16","v":1},"時",{"$f":"恒星!E16","v":40},"分",{"$f":"恒星!G16","v":28},"秒",null,"E*(S)",{"$f":"TIME(C15,E15,G15)","v":6.9768518518518521E-2},null,"d,l異符号",null,null,null,null,{"$f":"S14*60","v":10.940000000000047},{"$f":"ROUNDDOWN(R15,0)","v":10}]
[null,"赤緯（ｄ）",{"$f":"恒星!C17","v":5},"度",{"$f":"恒星!E17","v":18.5},"分",null,null,null,"ＧＨＡ(S)",{"$f":"K15+K14","v":0.45579861111111103},null,{"$f":"M14*-1","v":-9.2515408755937431E-2},null,null,null,null,{"$f":"R15-S15","v":0.94000000000004746},{"$f":"R16*60","v":56.400000000002848}]
[null,"眼高",{"$f":"恒星!C18","v":3},"ｍ",null,null,"符号",null,null,"ＤＬ(S)",{"$f":"IF(K8,M11,M11*-1)","v":0.3825925925925926},"ｒａｄｉａｎ","ｓｉｎ","ｃｏｓ",null,"ｈ","ｍ","ｓ"]
[null,"ログ指示値",{"$f":"恒星!C19","v":151.19999999999999},"海里",null,null,null,null,null,"ｈ(S)",{"$f":"K16+K17","v":0.83839120370370357},{"$f":"RADIANS(N10)","v":5.2677818371901521},{"$f":"SIN(L18)","v":-0.84969336142826291},{"$f":"COS(L18)","v":0.5272771487033544}]
[null,"気温",{"$f":"恒星!C20","v":20},"度Ｃ",null,null,null,null,null,"ｄ",{"$f":"C16+E16/60","v":5.3083333333333336},{"$f":"RADIANS(K19)","v":9.2647894460032326E-2},{"$f":"IF(L10-L11=0,M14,M16)","v":9.2515408755937431E-2},{"$f":"COS(L19)","v":0.99571125289549767}]
[null,"水温",{"$f":"恒星!C21","v":20},"度Ｃ",null,null,null,null,null,"ｌ",{"$f":"C10+E10/60","v":26.948333333333334},{"$f":"RADIANS(K20)","v":0.47033714459160525},{"$f":"SIN(L20)","v":0.45318684706079193},{"$f":"COS(L20)","v":0.89141554936578171}]
[null,"天体概方位",{"$f":"恒星!C22","v":"Ｓ"},{"$f":"恒星!D22","v":20},"度",{"$f":"恒星!F22","v":"E"},"符号",null,null,"ｌ、ｄ同異",{"$f":"M20*M19+N20*N19*N18","v":0.50993400558684965}]
[null,null,null,null,null,null,null,null,null,"Ａｃ",{"$f":"ASIN(K21)","v":0.53510806988935045},{"$f":"RADIANS(K23)","v":0.53510806988935045},null,{"$f":"COS(L22)","v":0.86021352578656352},"時間（ＤＬ）",{"$f":"R14","v":9},{"$f":"S15","v":10},{"$f":"IF(S16>=60,S16-60,S16)","v":56.400000000002848}]
[null,null,null,null,null,null,null,null,null,"ｄｅｇ",{"$f":"DEGREES(K22)","v":30.659433988051269},"Ｅ",{"$f":"M14/M20","v":0.20414407292700426},{"$f":"ASIN(M23)","v":0.20558928750106578}]
[null,"天測結果",null,null,null,null,null,null,null,"ＡＢＳｄｅｇ",{"$f":"ABS(K23)","v":30.659433988051269}]
[null,"修正差（I）",{"$f":"M28","v":14.2},{"$f":"IF(C25>100,\"ミスがあるか、流されているので注意！\",\"\")","v":""},null,null,null,null,null,null,{"$f":"ROUNDDOWN(K24,0)","v":30},{"$f":"(K24-K25)*60","v":39.566039283076151},{"$f":"ROUND(L25,1)","v":39.6},null,"ａｎｏｔｈｅｒ",{"$f":"IF(L10-L11=0,\"\",K9)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ｓａｍｅ"]
[null,null,"符号",null,null,null,null,null,null,"Ａｏ",{"$f":"恒星!C8+恒星!E8/60","v":30.916666666666668},"Ｉ",{"$f":"(K33-K24)*60","v":14.233960716923946},null,"ｄ-ｌ＞0","ｄ＜ｌ"]
[null,null,{"$f":"L33","v":""},"度","符号",null,null,null,null,"ＩＥ",{"$f":"恒星!E9/60","v":0.05},null,{"$f":"ROUND(M27,1)","v":14.2},null,{"$f":"K19-K20","v":-21.64}]
[null,"方位角（Z）",{"$f":"L34","v":""},{"$f":"M33","v":80},{"$f":"N33","v":"Ｅ"},null,null,null,null,"Ａｓ",{"$f":"K27+K28","v":30.966666666666669},"ｚ",{"$f":"M18*N19/N22","v":-0.98353399025097943},null,{"$f":"IF(O28>0,'計（恒星）'!K7,\"\")","v":""},"Ｅ-Ａｃ","Ｅ＜Ａｃ"]
[null,null,{"$f":"L35","v":"Ｓ"},null,null,null,null,null,null,1,{"$f":"C105/60","v":-7.0000000000000007E-2},null,{"$f":"ASIN(M29)","v":-1.3890745753712599},null,null,{"$f":"N23-K29","v":-30.761077379165602}]
[null,null,null,null,null,null,null,null,null,2,null,null,{"$f":"DEGREES(M30)","v":-79.588110597700165},null,{"$f":"IF(L10-L11=0,O32,\"\")","v":"Ｓ"},{"$f":"IF(P30>0,K7,K9)","v":"Ｓ"}]
[null,null,null,null,null,null,null,null,null,3,{"$f":"G115/60","v":0},null,{"$f":"ABS(M31)","v":79.588110597700165},null,{"$f":"IF(O28<0,P31,\"\")","v":"Ｓ"}]
[null,null,null,null,null,null,null,null,null,"Ａｔ",{"$f":"K29+K30+K31+K32","v":30.896666666666668},{"$f":"IF(L10-L11=0,\"\",P25)","v":""},{"$f":"ROUND(M32,0)","v":80},{"$f":"IF(N10>180,\"Ｅ\",\"Ｗ\")","v":"Ｅ"},"Ａｔ",{"$f":"ROUNDDOWN(K33,0)","v":30},{"$f":"(K33-P33)*60","v":53.800000000000097}]
[null,"入力禁止",null,null,null,null,null,null,null,null,null,{"$f":"IF(L10-L11=0,O29,\"\")","v":""},null,null,"Ac",{"$f":"K25","v":30},{"$f":"M25","v":39.6}]
[null,"任意の時間のＥ*を求める",null,null,null,null,null,null,null,null,null,{"$f":"O31","v":"Ｓ"},null,null,"I",null,{"$f":"M28","v":14.2}]
[null,"Ｅ*　Ｕ＝0時（ｈ）",{"$f":"恒星!C38","v":1},"ｈ",{"$f":"恒星!E38","v":38},"ｍ",{"$f":"恒星!G38","v":56},"ｓ","天測暦"]
[null,"求めるＥ*の時間",{"$f":"恒星!C39","v":9},"ｈ",{"$f":"恒星!E39","v":15},"ｍ",{"$f":"恒星!G39","v":53},"ｓ",null,null,null,{"$f":"IF(K10+K11=0,O29,\"\")","v":""}]
[null,null,{"$f":"HOUR(H71)","v":1},null,{"$f":"MINUTE(H71)","v":40},null,{"$f":"SECOND(H71)","v":28},null,null,null,null,null,null,null,{"$f":"IF(O28<0,\"\",P31)","v":""}]
[null,"求めるＥ*",{"$f":"恒星!C42","v":1},"ｈ",{"$f":"恒星!E42","v":40},"ｍ",{"$f":"恒星!G42","v":28},"ｓ"]
[null,"Ｅ*　比例部分","分　秒"]
[null,"Ｕ",0,10,20,30,40,50,60]
[null,0,"0ｍ00","0ｍ02","0ｍ03","0ｍ05","0ｍ07","0ｍ08","0ｍ10"]
[null,1,"0ｍ10","0ｍ11","0ｍ13","0ｍ15","0ｍ16","0ｍ18","0ｍ20"]
[null,2,"0ｍ20","0ｍ21","0ｍ23","0ｍ25","0ｍ26","0ｍ28","0ｍ30"]
[null,3,"0ｍ30","0ｍ31","0ｍ33","0ｍ34","0ｍ36","0ｍ38","0ｍ39"]
[null,4,"0ｍ39","0ｍ41","0ｍ43","0ｍ44","0ｍ46","0ｍ48","0ｍ49"]
[null,5,"0ｍ49","0ｍ51","0ｍ53","0ｍ54","0ｍ56","0ｍ57","0ｍ59"]
[null,6,"0ｍ59","1ｍ01","1ｍ02","1ｍ04","1ｍ06","1ｍ07","1ｍ09"]
[null,7,"1ｍ09","1ｍ11","1ｍ12","1ｍ14","1ｍ16","1ｍ17","1ｍ19"]
[null,8,"1ｍ19","1ｍ20","1ｍ22","1ｍ24","1ｍ25","1ｍ27","1ｍ29"]
[null,9,"1ｍ29","1ｍ30","1ｍ32","1ｍ34","1ｍ35","1ｍ37","1ｍ39"]
[null,10,"1ｍ39","1ｍ40","1ｍ42","1ｍ43","1ｍ45","1ｍ47","1ｍ48"]
[null,11,"1ｍ48","1ｍ50","1ｍ52","1ｍ53","1ｍ55","1ｍ57","1ｍ58"]
[null,12,"1ｍ58","2ｍ00","2ｍ02","2ｍ03","2ｍ05","2ｍ06","2ｍ08"]
[null,13,"2ｍ08","2ｍ10","2ｍ11","2ｍ13","2ｍ15","2ｍ16","2ｍ18"]
[null,14,"2ｍ18","2ｍ20","2ｍ21","2ｍ23","2ｍ25","2ｍ26","2ｍ28"]
[null,15,"2ｍ28","2ｍ29","2ｍ31","2ｍ33","2ｍ34","2ｍ36","2ｍ38"]
[null,16,"2ｍ38","2ｍ39","2ｍ41","2ｍ43","2ｍ44","2ｍ46","2ｍ47"]
[null,17,"2ｍ48","2ｍ49","2ｍ51","2ｍ52","2ｍ54","2ｍ56","2ｍ57"]
[null,18,"2ｍ57","2ｍ59","3ｍ01","3ｍ02","3ｍ04","3ｍ06","3ｍ07"]
[null,19,"3ｍ07","3ｍ09","3ｍ11","3ｍ12","3ｍ14","3ｍ15","3ｍ17"]
[null,20,"3ｍ17","3ｍ19","3ｍ20","3ｍ22","3ｍ24","3ｍ25","3ｍ27"]
[null,21,"3ｍ27","3ｍ29","3ｍ30","3ｍ32","3ｍ34","3ｍ35","3ｍ37"]
[null,22,"3ｍ37","3ｍ38","3ｍ40","3ｍ42","3ｍ43","3ｍ45","3ｍ47"]
[null,23,"3ｍ47","3ｍ48","3ｍ50","3ｍ52","3ｍ53","3ｍ55","3ｍ57"]
[]
[null,"Ｕ＝０","ｖｌｕｐ","ｖｌｕｐ","ｖｌｕｐ","ｖｌｕｐ","ｖｌｕｐ","ｖｌｕｐ","ｖｌｕｐ"]
[null,null,0,10,20,30,40,50,60]
[null,{"$f":"C37+E37/60+G37/3600","v":9.2647222222222219},{"$f":"VLOOKUP(B69,B42:I65,2,1)","v":"1ｍ29"},{"$f":"VLOOKUP(C69,C42:J65,2,1)","v":"1ｍ30"},{"$f":"VLOOKUP(D69,D42:K65,2,1)","v":"1ｍ32"},{"$f":"VLOOKUP(E69,E42:L65,2,1)","v":"1ｍ34"},{"$f":"VLOOKUP(F69,F42:N65,2,1)","v":"1ｍ35"},{"$f":"VLOOKUP(G69,G42:O65,2,1)","v":"1ｍ37"},{"$f":"VLOOKUP(H69,H42:P65,2,1)","v":"1ｍ39"}]
[null,{"$f":"E37+G37/60","v":15.883333333333333},null,"ｍ","ｓ","ｈｍｓ（ｐｐ）","ｈｍｓ"]
[null,{"$f":"ROUND(B70,-1)","v":20},{"$f":"HLOOKUP(B71,C68:I69,2,1)","v":"1ｍ32"},{"$f":"LEFT(C71,1)","v":"1"},{"$f":"MID(C71,3,2)","v":"32"},{"$f":"TIME(0,D71,E71)","v":1.0648148148148147E-3},{"$f":"TIME(C36,E36,G36)","v":6.8703703703703697E-2},{"$f":"F71+G71","v":6.9768518518518507E-2}]
[]
[]
[null,null,null,null,null,null,"改正２"]
[null,"改正1","改正値",null,null,null,"視平視差","惑星","（恒星には使用しません）"]
[null,"星","眼高",null,"眼高",null,0.2,"観測","高度"]
[null,"高度","2ｍ","高度","3ｍ",null,"ＨＰ",10,30,50,70,90]
[null,15,-6.6,15,-6.1,null,0.1,0.1,0.1,0.1,0.1,0.1]
[null,16,-6.4,16,-5.8,null,0.2,0.2,0.2,0.2,0.1,0]
[null,17,-6.2,17,-5.6,null,0.3,0.3,0.3,0.2,0.1,0]
[null,18,-6,18,-5.5,null,0.4,0.4,0.3,0.2,0.1,0]
[null,20,-5.7,20,-5.0999999999999996,null,0.5,0.5,0.4,0.3,0.2,0]
[null,22,-5.5,22,-4.9000000000000004,null,0.6,0.6,0.5,0.4,0.2,0]
[null,24,-5.2,24,-4.7]
[null,26,-5,26,-4.5,null,{"$f":"G76","v":0.2},{"$f":"VLOOKUP(G85,G78:H83,2,1)","v":0.2},{"$f":"VLOOKUP(G85,G78:I83,3,1)","v":0.2},{"$f":"VLOOKUP(G85,G78:J83,4,1)","v":0.2},{"$f":"VLOOKUP(G85,G78:K83,5,1)","v":0.1},{"$f":"VLOOKUP(G85,G78:L83,6,1)","v":0}]
[null,28,-4.9000000000000004,28,-4.3,null,10,{"$f":"H85","v":0.2}]
[null,30,-4.7,30,-4.2,null,30,{"$f":"I85","v":0.2}]
[null,32,-4.5999999999999996,32,-4.0999999999999996,null,50,{"$f":"J85","v":0.2}]
[null,34,-4.5,34,-3.9,null,70,{"$f":"K85","v":0.1}]
[null,36,-4.4000000000000004,36,-3.8,null,90,{"$f":"L85","v":0}]
[null,38,-4.3,38,-3.7,null,{"$f":"K29","v":30.966666666666669},{"$f":"VLOOKUP(G91,G86:H91,2,1)","v":0.2}]
[null,40,-4.2,40,-3.7]
[null,45,-4,45,-3.5]
[null,50,-3.9,50,-3.3]
[null,55,-3.8,55,-3.2,null,"改正値",{"$f":"G115","v":0}]
[null,60,-3.6,60,-3.1,null,"改正3","太陽と","星"]
[null,65,-3.5,65,-3,null,"気温-","水温＝","差"]
[null,70,-3.4,70,-2.9,null,"℃差","+","-"]
[null,75,-3.3,75,-2.8,null,0,0,0]
[null,80,-3.2,80,-2.7,null,1,0.2,-0.2]
[null,85,-3.2,85,-2.6,null,2,0.4,-0.4]
[null,90,-3.1,90,-2.5,null,3,0.6,-0.6]
[null,{"$f":"K29","v":30.966666666666669},null,null,null,null,4,0.8,-0.8]
[null,{"$f":"ROUND(B103,0)","v":31},{"$f":"VLOOKUP(B104,B78:C102,2,1)","v":-4.7},{"$f":"B104","v":31},{"$f":"VLOOKUP(D104,D78:E102,2,1)","v":-4.2},null,5,1,-1]
[null,null,{"$f":"IF(恒星!C18=2,C104,E104)","v":-4.2},null,null,null,6,1.2,-1.2]
[null,null,null,null,null,null,7,1.4,-1.4]
[null,null,null,null,null,null,8,1.6,-1.6]
[null,null,null,null,null,null,9,1.8,-1.8]
[null,null,null,null,null,null,10,2,-2]
[null,null,null,null,null,null,11,2.2000000000000002,-2.2000000000000002]
[null,null,null,null,null,null,12,2.4,-2.4]
[null,null,null,null,null,null,13,2.6,-2.6]
[null,null,null,null,null,null,14,2.8,-2.8]
[null,null,null,null,null,null,{"$f":"ABS(H115)","v":0},{"$f":"VLOOKUP(G114,G99:I113,2,1)","v":0},{"$f":"VLOOKUP(G114,G99:I113,3,1)","v":0}]
[null,null,null,null,null,null,{"$f":"IF(H115>=0,H114,I114)","v":0},{"$f":"恒星!C20-恒星!C21","v":0}]

{"sheet":"予備","index":11,"n_rows":87,"n_cols":16,"rows_kept":87,"cut":false,"hidden":false,"merged":[]}
[null,"入力禁止"]
["第１回観測"]
[{"$f":"太陽!C5","v":1},"月","日",null,"気温","水温",null,null,"緯度","分",null,null,"経度","分"]
["観測月日",{"$f":"太陽!C6","v":2},{"$f":"太陽!E6","v":10},null,{"$f":"太陽!C23","v":20},{"$f":"太陽!C24","v":20},null,null,{"$f":"太陽!C9","v":27},{"$f":"太陽!E9","v":15},{"$f":"PROPER(太陽!G9)","v":""},null,{"$f":"太陽!C10","v":138},{"$f":"太陽!E10","v":40},{"$f":"PROPER(太陽!G10)","v":""},{"$f":"IF(O4=\"E\",\"W\",\"E\")","v":"E"}]
[null,"時","分",null,null,"眼高",null,{"$f":"I4*60+J4","v":1635},{"$f":"I6*60+J6","v":0},{"$f":"IF(K5,H5+I5,H5-I5)","v":1635},{"$f":"EXACT(K4,K6)","v":false},{"$f":"M4*60+N4","v":8320},{"$f":"M6*60+N6","v":0},{"$f":"IF(O5,L5+M5,L5-M5)","v":8320},{"$f":"EXACT(Q6,O6)","v":false}]
["観測時",{"$f":"太陽!C6","v":2},{"$f":"太陽!E7","v":50},"頃",null,{"$f":"太陽!C21","v":3},null,"変緯",null,0,"S","変経",0,0,"W"]
[null,null,"分","秒",null,null,null,null,{"$f":"J5/60","v":27.25},{"$f":"ROUNDDOWN(I7,0)","v":27},{"$f":"I7-J7","v":0.25},null,{"$f":"N5/60","v":138.66666666666666},{"$f":"ROUNDDOWN(M7,0)","v":138},{"$f":"M7-N7","v":0.66666666666665719}]
["クロノメ-タ－",{"$f":"太陽!C12","v":5},{"$f":"太陽!E12","v":23},{"$f":"太陽!G12","v":46},"遅れ","進む",null,null,null,null,{"$f":"K7*60","v":15},null,{"$f":"IF(M7>=180,N7-1,N7)","v":138},{"$f":"IF(M7>=180,60-O8,O8)","v":39.999999999999432},{"$f":"O7*60","v":39.999999999999432}]
["エラ－",null,{"$f":"太陽!E13","v":11},{"$f":"太陽!G13","v":25},null,null,"推測",null,"緯度","分",null,null,"経度","分"]
[null,{"$f":"TIME(B8,C8,D8)","v":0.22483796296296296},{"$f":"TIME(B9,C9,D9)","v":7.9282407407407409E-3},{"$f":"B10+C10","v":0.23276620370370371},"加算","減算","位置",null,{"$f":"J7","v":27},{"$f":"K8","v":15},{"$f":"H12","v":""},null,{"$f":"M8","v":138},{"$f":"N8","v":39.999999999999432},{"$f":"P12","v":""}]
[false,{"$f":"HOUR(D10)","v":5},{"$f":"MINUTE(D10)","v":35},{"$f":"SECOND(D10)","v":11}]
[{"$f":"IF(A11,B10-C10,D10)","v":0.23276620370370371},{"$f":"HOUR(A12)","v":5},{"$f":"MINUTE(A12)","v":35},{"$f":"SECOND(A12)","v":11},null,null,null,{"$f":"IF(H5>I5,K4,K6)","v":""},null,null,null,null,null,null,null,{"$f":"IF(N7>=180,P4,O4)","v":""}]
[null,null,null,null,"どちらか","チェック","時間","ｈ","ｍ","ｓ",null,"角度",{"$f":"H22","v":260},{"$f":"I22","v":13.5}]
["グリニッチ時","時","分","秒",null,null,null,{"$f":"B20","v":17},{"$f":"C20","v":20},{"$f":"D20","v":54},null,null,"+"]
["Ｕ",{"$f":"B16","v":5},{"$f":"C16","v":35},{"$f":"D16","v":11}]
["Ｕ",{"$f":"IF(A11,B12,B11)","v":5},{"$f":"IF(A11,C12,C11)","v":35},{"$f":"D12","v":11},null,null,null,{"$f":"H14*15","v":255},{"$f":"I14*15","v":300},{"$f":"J14*15","v":810},null,"角度",{"$f":"B22","v":138},{"$f":"C22","v":39.999999999999432},{"$f":"D22","v":""}]
["+",{"$f":"TIME(B16,C16,D16)","v":0.23276620370370371},{"$f":"TIME(B18,C18,D18)","v":0.49008101851851849},{"$f":"B17+C17","v":0.7228472222222222},null,null,null,{"$f":"I18+H16","v":260},{"$f":"I16/60","v":5},{"$f":"J16/60","v":13.5},null,{"$f":"M13*60+N13","v":15613.5},{"$f":"M16*60+N16","v":8320},{"$f":"IF(O16=\"Ｗ\",L17-M17,L17+M17)","v":23933.5}]
["Ｅ◎(時間）;",{"$f":"太陽!C19","v":11},{"$f":"太陽!E19","v":45},{"$f":"太陽!G19","v":43},null,"天",null,null,{"$f":"INT(I17)","v":5},{"$f":"ROUND(J17,1)","v":13.5},null,{"$f":"N17/60","v":398.89166666666665},{"$f":"ROUNDDOWN(L18,0)","v":398},{"$f":"(L18-M18)*60","v":53.499999999999091}]
[null,null,null,null,null,"測",null,null,{"$f":"I17-I18","v":0},null,null,null,{"$f":"IF(M18>=360,M18-360,M18)","v":38}]
["U+Ｅ◎",{"$f":"B25+HOUR(D17)","v":17},{"$f":"MINUTE(D17)","v":20},{"$f":"SECOND(D17)","v":54},null,"暦",null,null,{"$f":"I19*60","v":0},null,null,{"$f":"IF(O16=\"W\",L17-M17,L17+M17)","v":23933.5}]
["（角度）",{"$f":"H22","v":260},{"$f":"I22","v":13.5},null,null,null,null,"度","分",null,null,"答え",{"$f":"M19","v":38},{"$f":"N18","v":53.499999999999091}]
["推測経度",{"$f":"M10","v":138},{"$f":"N10","v":39.999999999999432},{"$f":"O10","v":""},null,null,"角度",{"$f":"H17","v":260},{"$f":"I20+J18","v":13.5}]
["Ｈ",{"$f":"M21","v":38},{"$f":"N21","v":53.499999999999091},"D；",{"$f":"E26","v":14},{"$f":"F26","v":38.700000000000003},{"$f":"G26","v":""},"Ｌ；",{"$f":"I26","v":27},{"$f":"J26","v":15},{"$f":"K26","v":""}]
[]
[]
["Ｈ；",{"$f":"B23","v":38},{"$f":"N21","v":53.499999999999091},"D；",{"$f":"太陽!C20","v":14},{"$f":"太陽!E20","v":38.700000000000003},{"$f":"PROPER(太陽!G20)","v":""},"Ｌ；",{"$f":"I10","v":27},{"$f":"J10","v":15},{"$f":"K10","v":""}]
[null,{"$f":"B26+C26/60","v":38.891666666666652},{"$f":"RADIANS(B27)","v":0.6787876349214611},null,{"$f":"E26+F26/60","v":14.645},{"$f":"RADIANS(E27)","v":0.25560346895456953},null,null,{"$f":"I26+J26/60","v":27.25},{"$f":"RADIANS(I27)","v":0.4756022211684548},{"$f":"IF(K26=\"N\",\"S\",\"N\")","v":"N"},null,{"$f":"IF(G26=K26,I26*60+J26-(E26*60+F26),\"緯度符号と反対符号\")","v":756.3}]
["sin",null,{"$f":"SIN(C27)","v":0.62784986013008492},null,null,{"$f":"SIN(F27)","v":0.25282931742565234},null,null,null,{"$f":"SIN(J27)","v":0.45787391511695674},null,"sinE",{"$f":"IF(M27<0,I46=K26,F28/J28)","v":0.55218108976806646},{"$f":"ASIN(M28)","v":0.58497805905712963}]
["cos",null,{"$f":"COS(C27)","v":0.77833447381870013},null,null,{"$f":"COS(F27)","v":0.96751089722549311},null,null,null,{"$f":"COS(J27)","v":0.88901714148573641},null,"cosAc",{"$f":"IF(M28-F31>0,G46=K26,\"N→Ｓ、Ｓ→Ｎ\")","v":"N→Ｓ、Ｓ→Ｎ"}]
["sun*sin",{"$f":"F28*J28","v":0.11576394942603126},null,{"$f":"IF(G26=K26,B30+B31,B30-B31)","v":0.78523571643101131},null,null,"rounddown",null,"round",null,null,{"$f":"COS(D31)","v":0.61919695545204056}]
["cos*cos*cos",{"$f":"C29*F29*J29","v":0.66947176700498001},"Asin",{"$f":"ASIN(D30)","v":0.90307671606480322},"degree",{"$f":"DEGREES(D31)","v":51.742484407047414},{"$f":"ROUNDDOWN(F31,0)","v":51},{"$f":"(F31-G31)*60","v":44.549064422844822},{"$f":"ROUND(H31,1)","v":44.5}]
[null,"度","分",null,null,{"$f":"ABS(F31)","v":51.742484407047414},null,null,null,"Asin"]
["計算高度",{"$f":"ABS(G31)","v":51},{"$f":"ABS(I31)","v":44.5},null,null,null,null,null,{"$f":"C28*F29/L30","v":0.98103127954479818},{"$f":"ASIN(I33)","v":1.3757117585453849}]
[null,null,null,null,null,null,null,null,null,{"$f":"DEGREES(J33)","v":78.822477591171122},{"$f":"ROUND(J34,1)","v":78.8}]
[null,"度","分",null,null,"same",{"$f":"EXACT(G26,K26)","v":true}]
["観測高度",{"$f":"太陽!C16","v":33},{"$f":"太陽!E16","v":34},{"$f":"B36+C36/60","v":33.56666666666667},null,"D>L",{"$f":"E27-I27","v":-12.605},{"$f":"IF(G36>0,K26,\"\")","v":""},{"$f":"IF(G35,H36,\"\")","v":""}]
["器差",null,{"$f":"太陽!E17","v":0},{"$f":"B37+C37/60","v":0},null,"E",{"$f":"F28/J28","v":0.55218108976806646},{"$f":"ASIN(G37)","v":0.58497805905712963},{"$f":"DEGREES(H37)","v":33.51677389172815}]
[null,{"$f":"D36+D37","v":33.56666666666667},{"$f":"ROUNDDOWN(B38,0)","v":33},{"$f":"B38-C38","v":0.56666666666666998},null,"E>Alt",{"$f":"I37-F32","v":-18.225710515319264},{"$f":"IF(G38>0,K26,K27)","v":"N"},{"$f":"IF(G35,H38,\"\")","v":"N"}]
[null,{"$f":"C38","v":33},{"$f":"D38*60","v":34.000000000000199},null,null,"another",{"$f":"IF(G35,\"\",G26)","v":""}]
["改正１",null,{"$f":"B81","v":11.3},{"$f":"B40+C40/60","v":0.18833333333333335},null,"d$L",{"$f":"G35","v":true},"d>L",{"$f":"G36","v":-12.605},null,null,"d,same"]
["改正2",null,{"$f":"K66","v":0.5},{"$f":"B41+C41/60","v":8.3333333333333332E-3},null,null,null,"d<L",null,"E>AL",{"$f":"G38","v":-18.225710515319264},"d,same"]
["改正3",null,{"$f":"N70","v":0},{"$f":"B42+C42/60","v":0},null,null,null,null,null,"E<AL",null,"d,other"]
[null,{"$f":"D40+D41+D42","v":0.19666666666666668},{"$f":"B38+B43","v":33.763333333333335},{"$f":"ROUNDDOWN(C43,0)","v":33},{"$f":"C43-D43","v":0.76333333333333542},null,"other","d,other"]
["真高度",{"$f":"D43","v":33},{"$f":"E44","v":45.800000000000125},{"$f":"B44+C44/60","v":33.763333333333335},{"$f":"E43*60","v":45.800000000000125},null,"符号","度","符号"]
["計算高度",{"$f":"B33","v":51},{"$f":"C33","v":44.5},{"$f":"B45+C45/60","v":51.741666666666667},null,"方",{"$f":"I36","v":""}]
["修正差（　Ｉ　）",null,{"$f":"E46","v":-1078.6999999999998},{"$f":"D44-D45","v":-17.978333333333332},{"$f":"D46*60","v":-1078.6999999999998},"位（Z)",{"$f":"I38","v":"N"},{"$f":"ABS(K34)","v":78.8},{"$f":"IF(B26+C26/60>180,\"Ｅ\",\"Ｗ\")","v":"Ｗ"}]
[null,null,null,null,null,"角",{"$f":"G39","v":""}]
[]
[]
["改正1",null,null,null,"改正1"]
["　太陽","眼高",null,"眼高","星","眼高",null,"眼高",null,"改正２","太陽",null,null,"改正3","太陽と","星"]
["高度","2ｍ","高度","3ｍ","高度","2ｍ","高度","3ｍ",null,"月","下辺",null,null,"気温-","水温＝","差"]
[15,9.8000000000000007,15,9.3000000000000007,15,-6.6,15,-6.1,null,1,0.5,null,null,"℃差","+","-"]
[16,10.1,16,9.5,16,-6.4,16,-5.8,null,2,0.5,null,null,0,0,0]
[17,10.3,17,9.6999999999999993,17,-6.2,17,-5.6,null,3,0.4,null,null,1,0.2,-0.2]
[18,10.4,18,9.9,18,-6,18,-5.5,null,4,0.2,null,null,2,0.4,-0.4]
[20,10.7,20,10.199999999999999,20,-5.7,20,-5.0999999999999996,null,5,0.1,null,null,3,0.6,-0.6]
[22,11,22,10.4,22,-5.5,22,-4.9000000000000004,null,6,0,null,null,4,0.8,-0.8]
[24,11.2,24,10.7,24,-5.2,24,-4.7,null,7,0,null,null,5,1,-1]
[26,11.4,26,10.8,26,-5,26,-4.5,null,8,0.1,null,null,6,1.2,-1.2]
[28,11.6,28,11,28,-4.9000000000000004,28,-4.3,null,9,0.2,null,null,7,1.4,-1.4]
[30,11.7,30,11.1,30,-4.7,30,-4.2,null,10,0.3,null,null,8,1.6,-1.6]
[32,11.8,32,11.3,32,-4.5999999999999996,32,-4.0999999999999996,null,11,0.3,null,null,9,1.8,-1.8]
[34,11.9,34,11.4,34,-4.5,34,-3.9,null,12,0.5,null,null,10,2,-2]
[36,12,36,11.5,36,-4.4000000000000004,36,-3.8,null,null,null,null,null,11,2.2000000000000002,-2.2000000000000002]
[38,12.1,38,11.6,38,-4.3,38,-3.7,null,{"$f":"J67","v":2},{"$f":"VLOOKUP(J66,J53:K64,2,0)","v":0.5},null,null,12,2.4,-2.4]
[40,12.2,40,11.6,40,-4.2,40,-3.7,null,{"$f":"IF(C4>=16,B4+1,B4)","v":2},null,null,null,13,2.6,-2.6]
[45,12.4,45,11.8,45,-4,45,-3.5,null,null,null,null,null,14,2.8,-2.8]
[50,12.5,50,12,50,-3.9,50,-3.3,null,null,null,null,{"$f":"E4-F4","v":0},{"$f":"ABS(M69)","v":0},{"$f":"VLOOKUP(N69,N54:P68,2,1)","v":0},{"$f":"VLOOKUP(N69,N54:P68,3,1)","v":0}]
[55,12.6,55,12.1,55,-3.8,55,-3.2,null,null,null,null,"ｄｉｆ",{"$f":"IF(M69>=0,O69,P69)","v":0}]
[60,12.8,60,12.2,60,-3.6,60,-3.1,null,"改正２"]
[65,12.9,65,12.3,65,-3.5,65,-3,null,"惑星","観測","高度"]
[70,12.9,70,12.4,70,-3.4,70,-2.9,null,"ＨＰ",10,30,50,70,90]
[75,13,75,12.5,75,-3.3,75,-2.8,null,0.1,0.1,0.1,0.1,0.1,0.1]
[80,13.1,80,12.5,80,-3.2,80,-2.7,null,0.2,0.2,0.2,0.2,0.1,0]
[85,13.2,85,12.6,85,-3.2,85,-2.6,null,0.3,0.3,0.3,0.2,0.1,0]
[90,13.2,90,12.7,90,-3.1,90,-2.5,null,0.4,0.4,0.3,0.2,0.1,0]
[null,null,null,null,null,null,null,null,null,0.5,0.5,0.4,0.3,0.2,0]
[{"$f":"B38","v":33.56666666666667},{"$f":"VLOOKUP(A79,A53:B77,2,1)","v":11.8},{"$f":"B38","v":33.56666666666667},{"$f":"VLOOKUP(C79,C53:D77,2,1)","v":11.3},{"$f":"B38","v":33.56666666666667},{"$f":"VLOOKUP(E79,E53:F77,2,1)","v":-4.5999999999999996},{"$f":"B38","v":33.56666666666667},{"$f":"VLOOKUP(G79,G53:H77,2,1)","v":-4.0999999999999996},null,0.6,0.6,0.5,0.4,0.2,0]
[null,{"$f":"IF(F6=2,B79,D79)","v":11.3},null,null,null,{"$f":"IF(F6=2,F79,H79)","v":-4.0999999999999996}]
[null,{"$f":"IF(A3=1,B80,F80)","v":11.3},null,null,null,null,null,null,null,0.2,{"$f":"VLOOKUP(J81,J74:K79,2,1)","v":0.2},{"$f":"VLOOKUP(J81,J74:L79,3,1)","v":0.2},{"$f":"VLOOKUP(J81,J74:M79,4,1)","v":0.2},{"$f":"VLOOKUP(J81,J74:N79,5,1)","v":0.1},{"$f":"VLOOKUP(J81,J74:O79,6,1)","v":0}]
[null,null,null,null,null,null,null,null,null,10,{"$f":"K81","v":0.2}]
[null,null,null,null,null,null,null,null,null,30,{"$f":"L81","v":0.2}]
[null,null,null,null,null,null,null,null,null,50,{"$f":"M81","v":0.2}]
[null,null,null,null,null,null,null,null,null,70,{"$f":"N81","v":0.1}]
[null,null,null,null,null,null,null,null,null,90,{"$f":"O81","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"B36","v":33},{"$f":"VLOOKUP(J87,J82:K87,2,1)","v":0.2}]