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

{"sheet":"saisie","index":0,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Renseigner les cellules des lignes : 5, 6 et 7 , dans les colones B, C, D et E , ainsi que la cellule F5"]
[null,"         Point de départ",null,"         Point d'arrivée"]
[57.295779510000003,"N1","E1","N2","E2","SENS : Aller (A)"]
[1.570796327,"d m s","d m s","d m s","d m s","ou Retour (R) :"]
["Dégrés",43,3,43,4,"a"]
["minutes",6,7,26.512,25.28]
["secondes",32,61,0,0]
["Degrés Décimaux",{"$f":"(B5+(B6/60)+(B7/3600))","v":43.108888888888892},3.1336111111111111,43.44186666666667,4.4213333333333331]
["radians :",{"$f":"B8/$A3","v":0.75239204802798731},5.469183136890899E-2,0.7582036065864961,7.7166823998993939E-2]
[null,null,null,null,null,"\"Résultat : \""]
[]
[null,"cap =",{"$f":"calculs!F17","v":70.006508125599268},"degrés",null,"Distance (km) : "]
[null,null,null,null,null,{"$f":"IF(AND(B9=D9,C9=E9),0,A23)","v":110.54551116313623}]
[null,null,{"$f":"TRUNC(C12)","v":70},"Dégrés"]
[null,"Soit :",{"$f":"TRUNC((C12-C14)*60)","v":0},"minutes",null,"Distance (miles ) : "]
[null,null,{"$f":"(C12*3600)-((C14*3600)+(C15*60))","v":23.429252157366136},"secondes",null,{"$f":"F13*540/1000","v":59.694576028093564}]
["cellule F5 :renseigner le sens : a ou A pour l'aller, r ou R pour le retour"]
["N1 = Latitude du point de départ",null,null," E1 = longitude du point de départ"]
["N2 = Latitude du point d'arrivée",null,"      E2 = longitude du point d'arrivée"]
[]
[]
["Calcul intermédiaire"]
[{"$f":"A3*(1000/9)*ACOS((SIN(B9)*SIN(D9))+(COS(B9)*COS(D9)*COS(C9-E9)))","v":110.54551116313623}]

{"sheet":"cap","index":1,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["étape intermédiaire","Fonction Aller / Retour",null,"Ne rien renseigner dans cette feuille"]
[{"$f":"saisie!F5","v":"a"}]
[57.295779510000003,"N1","E1","N2","E2"]
[{"$f":" IF(A2=\"a\",\"r\",\"a\")","v":"r"},"d m s","d m s","d m s","d m s"]
["Dégrés",{"$f":"IF(A10=\"A\",saisie!B5,saisie!D5)","v":43},{"$f":"IF(A10=\"A\",saisie!C5,saisie!E5)","v":3},{"$f":"IF(A10=\"A\",saisie!D5,saisie!B5)","v":43},{"$f":"IF(A10=\"A\",saisie!E5,saisie!C5)","v":4}]
["minutes",{"$f":"IF(A10=\"A\",saisie!B6,saisie!D6)","v":6},{"$f":"IF(A10=\"A\",saisie!C6,saisie!E6)","v":7},{"$f":"IF(A10=\"A\",saisie!D6,saisie!B6)","v":26.512},{"$f":"IF(A10=\"A\",saisie!E6,saisie!C6)","v":25.28}]
["secondes",{"$f":"IF(A10=\"A\",saisie!B7,saisie!D7)","v":32},{"$f":"IF(A10=\"A\",saisie!C7,saisie!E7)","v":61},{"$f":"IF(A10=\"A\",saisie!D7,saisie!B7)","v":0},{"$f":"IF(A10=\"A\",saisie!E7,saisie!C7)","v":0}]
["Degrés Décimaux",{"$f":"(B5+(B6/60)+(B7/3600))","v":43.108888888888892},3.1336111111111111,43.44186666666667,4.4213333333333331]
["radians :",{"$f":"B8/$A3","v":0.75239204802798731},5.469183136890899E-2,0.7582036065864961,7.7166823998993939E-2]
[{"$f":"IF(AND(ABS(saisie!C8-saisie!E8)>180,ABS(saisie!E8)>90),A4,A2)","v":"a"}]
[]
[null,null,"en feuille saisie :"]
[null,null,"Sélection : ",{"$f":"IF(saisie!F5=\"a\",\"Aller\",\"Retour\")","v":"Aller"}]
[]
[]
[]
[]
["rem : A2, A4, A10 : prise en compte des méridiens > 90 ° ou < -90° ( ½ sphère Antipode )"]

{"sheet":"calculs","index":2,"n_rows":24,"n_cols":8,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[null,"N1 =",{"$f":"cap!B9","v":0.75239204802798731},"rad",null,"un radian =",57.295779510000003,"degrés"]
[null,"E1 =",{"$f":"cap!C9","v":5.469183136890899E-2},"rad",null,"Ne rien renseigner dans cette feuille"]
[null,"N2 =",{"$f":"cap!D9","v":0.7582036065864961},"rad"]
[null,"E2 =",{"$f":"cap!E9","v":7.7166823998993939E-2},"rad"]
[null,"N \"pôle\" =",1.570796327,"rad"]
[null,"a =",{"$f":"C5-C3","v":0.81259272041350394},"rad"]
[null,"cos a =",{"$f":"COS(C6)","v":0.68761824344183586}]
[null,"b =",{"$f":"C5-C1","v":0.81840427897201273},"rad"]
[null,"sin b =",{"$f":"SIN(C8)","v":0.73005626459521722}]
[null,"cos b =",{"$f":"COS(C8)","v":0.68338704298902109}]
[null,"c =",{"$f":"ACOS(SIN(C1)*SIN(C3)+COS(C1)*COS(C3)*COS(C2-C4))","v":1.7364448288806011E-2},"rad"]
[null,"sin c =",{"$f":"SIN(C11)","v":1.7363575668791303E-2}]
[null,"cos c =",{"$f":"COS(C11)","v":0.99984924175597301}]
[null,"Avant correction trigonométrique",null,null,"Cos A (+/- e )"]
[null,"Cos A =",{"$f":"IF(E15>1,1,IF(E15<-1,-1,E15))","v":0.34191340304571599},null,{"$f":"(C7-(C10*C13))/(C9*C12)","v":0.34191340304571599},"   Après correction éventuelle,"]
[null,"A = ",{"$f":"ACOS(C15)","v":1.2218440646816022},"rad",null,"   le cap est :"]
[null,"Cap = ",{"$f":"C16*G1","v":70.006508125599268},"deg·",null,{"$f":"IF(AND(C2=C4,C3>C1),0,IF(AND(C2=C4,C3<C1),180,IF(AND(C2=C4,C3=C1),0,IF(C2<C4,C17,360-C17))))","v":70.006508125599268},"degrés"]
["La correction trigonométrique est effectuée si le \"triangle de cap\" se trouve inversé : ( par exemple"]
["si le trajet a lieu vers l'ouest dans l'hémisphère nord )."]
[]
[]
[" Si #NOMBRE ! s'affiche dans quelque(s) cellule(s), cela signifie : point de départ = point d'arrivée   ( L ? )"]
[]
[" Si #DIV/0 ! s'affiche dans quelque(s) cellule(s), cela signifie : point de départ = point d'arrivée   ( L ? )"]

{"sheet":"SUITE","index":3,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[[3,1,3,2],[6,1,6,2],[4,1,5,1],[4,2,5,2],[7,2,8,2],[7,1,8,1]]}
[]
[null,"cap fond (vrais)",{"$f":"saisie!C12","v":70.006508125599268},"année carte",1985]
[null,"déviation (d)",5,"année actuelle",2017]
[null,"déclinaison avec une correction ",null,"Degrée","minute","seconde","Position"]
[null,"C avec correction",{"$f":"((IF(G5=\"-\",-1,1)*(D5+E5/60+F5/3600))*(E3-E2))/60","v":4.8},9,null,null,"+"]
[]
[null,"la déclinaison  Carte",null,"Degrée","minute","seconde","Position"]
[null,"Déclinaision(D)",{"$f":"IF(G8=\"-\",-1,1)*(D8+E8/60+F8/3600)","v":-2.5},2,30,null,"-"]
[]
[null,"W = d + D",{"$f":"SUM(C3,C8)","v":2.5}]
[null,"Cap compas (Cc)",{"$f":"ROUNDDOWN(C2-C10,0)+0.6*((C2-C10)-ROUNDDOWN(C2-C10,0))","v":67.303904875359564}]
[]
[]
[null,"Degré rosecarte",4]
[null,"Minute rose carte",10]
[null,"MINUTE corigée",{"$f":"SUM(C15,(C17*(E3-E2))/60)","v":12.133333333333333}]
[null,"C (+- E ou W)",4]