{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Orthodromie"],"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":"Orthodromie","index":0,"n_rows":24,"n_cols":19,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,1,1,10],[15,1,16,10],[18,8,19,8]]}
[null,"Calcul d'une position orthodromique à partir d'un point, d'un cap et d'une distance"]
[]
[]
[null,null,"Position de Départ",null,null,null,null,null,"Distance (km)","Cap de"]
[null,null,"Latitude",null,null,"Longitude",null,null,"Imposée","au dépert"]
[null,"A",43,6,3,3,5,{"$f":"IF(OR(F6<0,AND(F6=0,G6<0)),\"W\",\"E\")","v":"E"},616,303.29199999999997]
[null,{"$f":"C7+D7/60","v":43.1},{"$f":"C6","v":43},{"$f":"IF(C6<0,-ABS(D6),ABS(D6))","v":6},{"$f":"F7+G7/60","v":3.0833333333333335},{"$f":"F6","v":3},{"$f":"IF(F6<0,-ABS(G6),ABS(G6))","v":5}]
[null,null,null,null,null,{"$f":"F7","v":3}]
[null,null,{"$f":"VincentyDirLat(C7,F7,J6,I7)","v":43},null,null,{"$f":"VincentyDirLon(C7,F7,J6,I7)","v":3}]
[null,null,"Position calculé",null,null,null,null,null,"Distance","Caps",null,null,null,null,null,null,null,null,0]
[null,null,"Latitude",null,null,"Longitude",null,null,"Calculée","Calculés"]
[null,"C",{"$f":"TRUNC(B13)","v":45},{"$f":"(B13-C12)*60","v":57.342991883207048},{"$f":"IF(OR(C12<0,AND(C12=0,D12<0)),\"S\",\"N\")","v":"N"},{"$f":"TRUNC(E13)","v":-3},{"$f":"(E13-F12)*60","v":-33.782853954479606},{"$f":"IF(OR(F12<0,AND(F12=0,G12<0)),\"W\",\"E\")","v":"W"},{"$f":"VincentyInvDistance(B7,E7,B13,E13)/1000","v":616.00000007175834},{"$f":"VincentyInvFwdAzimuth(B7,E7,B13,E13)","v":303.29200000019176},{"$f":"\"Point \"&B6","v":"Point A"}]
[null,{"$f":"VincentyDirLat(B7,E7,J6,I6*1000)","v":45.955716531386784},null,null,{"$f":"VincentyDirLon(B7,E7,J6,I6*1000)","v":-3.5630475659079934},null,{"$f":"IF(F12<0,-ABS(G12),ABS(G12))","v":-33.782853954479606},null,null,{"$f":"VincentyInvRevAzimuth(B7,E7,B13,E13)","v":298.62706917765763},{"$f":"\"Point \"&B12","v":"Point C"}]
[]
[]
[null,"Calcul d'une distance orthodromique à partir de deux positions"]
[]
[]
[null,null,"Positions des points",null,null,null,null,null,"Distance (km)"]
[null,null,"Latitude",null,null,"Longitude",null,null,null,"Caps"]
[null,"B",43,6,{"$f":"IF(OR(C21<0,AND(C21=0,D21<0)),\"S\",\"N\")","v":"N"},3,5,{"$f":"IF(OR(F21<0,AND(F21=0,G21<0)),\"W\",\"E\")","v":"E"},null,{"$f":"VincentyInvFwdAzimuth(B22,E22,B24,E24)","v":303.29199280745422},{"$f":"\"Point \"&B21","v":"Point B"}]
[null,{"$f":"C22+D22/60","v":43.1},{"$f":"C21","v":43},{"$f":"IF(C21<0,-ABS(D21),ABS(D21))","v":6},{"$f":"F22+G22/60","v":3.0833333333333335},{"$f":"F21","v":3},{"$f":"IF(F21<0,-ABS(G21),ABS(G21))","v":5},null,{"$f":"VincentyInvDistance(B22,E22,B24,E24)/1000","v":616.00017291128017}]
[null,"A",45,57.343000000000004,{"$f":"IF(OR(C23<0,AND(C23=0,D23<0)),\"S\",\"N\")","v":"N"},-3,33.783000000000001,{"$f":"IF(OR(F23<0,AND(F23=0,G23<0)),\"W\",\"E\")","v":"W"},null,{"$f":"VincentyInvRevAzimuth(B22,E22,B24,E24)","v":298.62706026880801},{"$f":"\"Point \"&B23","v":"Point A"}]
[null,{"$f":"C24+D24/60","v":45.955716666666667},{"$f":"C23","v":45},{"$f":"IF(C23<0,-ABS(D23),ABS(D23))","v":57.343000000000004},{"$f":"F24+G24/60","v":-3.5630500000000001},{"$f":"F23","v":-3},{"$f":"IF(F23<0,-ABS(G23),ABS(G23))","v":-33.783000000000001}]