{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Base de Calcul","Calcul","Fonction Distance","Fonction Position","Fonction Cap"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Calcul","index":1,"reason":"part_missing"},{"sheet":"Fonction Distance","index":2,"reason":"part_missing"},{"sheet":"Fonction Position","index":3,"reason":"part_missing"},{"sheet":"Fonction Cap","index":4,"reason":"part_missing"}],"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":"Base de Calcul","index":0,"n_rows":33,"n_cols":13,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Route du","Positions des A/C",null,null,null,null,null,"Distance","Cap"]
["Câble","Latitude",null,null,"Longitude",null,null,"(km)","(D°)",null,null,"WGS 84"]
["TGN AC",41,42,{"$f":"IF(OR(B3<0,AND(B3=0,C3<0)),\"S\",\"N\")","v":"N"},40,15,{"$f":"IF(OR(E3<0,AND(E3=0,F3<0)),\"W\",\"E\")","v":"E"},null,null,null,null,"a",6378137]
[null,null,null,null,null,null,null,{"$f":"Distance(B3,C3,E3,F3,B5,C5,E5,F5)","v":54.129973747814184},{"$f":"Cap(B3,C3,E3,F3,B5,C5,E5,F5)","v":187.39006203641392},null,null,"b",6356752.3140000002]
["TGN AC",41,13,{"$f":"IF(OR(B5<0,AND(B5=0,C5<0)),\"S\",\"N\")","v":"N"},40,10,{"$f":"IF(OR(E5<0,AND(E5=0,F5<0)),\"W\",\"E\")","v":"E"},null,{"$f":"Cap(B5,C5,E5,F5,B3,C3,E3,F3)","v":7.3900620364139309},"Angle croisant"]
[null,null,null,null,null,null,null,null,null,{"$f":"M21","v":86.070627939559117}]
["Câble","Positions connues",null,null,null,null,null,"Distance","Cap"]
["Croisant","Latitude",null,null,"Longitude",null,null,"(km)","(D°)"]
["P1",41,31,{"$f":"IF(OR(B9<0,AND(B9=0,C9<0)),\"S\",\"N\")","v":"N"},40,8,{"$f":"IF(OR(E9<0,AND(E9=0,F9<0)),\"W\",\"E\")","v":"E"}]
[null,null,null,null,null,null,null,{"$f":"Distance(B9,C9,E9,F9,B11,C11,E11,F11)","v":15.33258639203196},{"$f":"Cap(B9,C9,E9,F9,B11,C11,E11,F11)","v":93.46068997597304}]
["P2",41,30.5,{"$f":"IF(OR(B11<0,AND(B11=0,C11<0)),\"S\",\"N\")","v":"N"},40,19,{"$f":"IF(OR(E11<0,AND(E11=0,F11<0)),\"W\",\"E\")","v":"E"},null,{"$f":"Cap(B11,C11,E11,F11,B9,C9,E9,F9)","v":273.46068997597303}]
[]
[]
[null,"Position du Croisement",null,null,null,null,null,"Distance ","Cap"]
[null,"Latitude",null,null,"Longitude",null,null,{"$f":"\"de \" &A3","v":"de TGN AC"},{"$f":"\"de \" &A3","v":"de TGN AC"}]
[null,{"$f":"TRUNC(B21)","v":41},{"$f":"(B21-B16)*60","v":30.770037993766408},{"$f":"IF(OR(B16<0,AND(B16=0,C16<0)),\"S\",\"N\")","v":"N"},{"$f":"TRUNC(E21)","v":40},{"$f":"(E21-E16)*60","v":13.059341333892291},{"$f":"IF(OR(E16<0,AND(E16=0,F16<0)),\"W\",\"E\")","v":"E"},{"$f":"Distance(B3,C3,E3,F3,B16,C16,E16,F16)","v":20.961836270823195},{"$f":"Cap(B3,C3,E3,F3,B16,C16,E16,F16)","v":187.39006203641407}]
[null,null,null,null,null,null,null,"Distance ","Cap"]
[null,null,null,null,null,null,null,{"$f":"\"de \" &A9","v":"de P1"},{"$f":"\"de \" &A9","v":"de P1"}]
[null,null,null,null,null,null,null,{"$f":"Distance(B9,C9,E9,F9,B16,C16,E16,F16)","v":7.0518274216405112},{"$f":"Cap(B9,C9,E9,F9,B16,C16,E16,F16)","v":93.460689976970485}]
["Version du 10/03/19"]
["Christian Auroux",{"$f":"Latitude(B3,C3,E3,F3,I4,H21)","v":41.512833966562773},null,null,{"$f":"Longitude(B3,C3,E3,F3,I4,H21)","v":40.217655688898205},null,null,20.96183627082323,null,{"$f":"ABS(I4-I10)","v":93.929372060440883},{"$f":"IF(L21>90,180-L21,L21)","v":86.070627939559117},{"$f":"IF(J21>90,180-J21,J21)","v":86.070627939559117},{"$f":"IF(K21>90,ABS(180-K21),ABS(K21))","v":86.070627939559117}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"1/SIN(60*PI()/180)","v":1.1547005383792517}]
["Distance de sécurité d'enssouillage"]
["(km)"]
[0.5]
[null,"Positions Recherchées",null,null,null,null,null,"Distance (km)","Cap"]
[null,"Latitude",null,null,"Longitude",null,null,"Calculée","Calculé"]
["Arrêt ensouillage",{"$f":"TRUNC(Latitude(B16,C16,E16,F16,15,A29))","v":41},{"$f":"(Latitude(B16,C16,E16,F16,I5,A29)-B32)*60","v":31.037909112075539},{"$f":"IF(OR(B32<0,AND(B32=0,C32<0)),\"S\",\"N\")","v":"N"},{"$f":"TRUNC(Longitude(B16,C16,E16,F16,I5,A29))","v":40},{"$f":"(Longitude(B16,C16,E16,F16,I5,A29)-E32)*60","v":13.105566419763335},{"$f":"IF(OR(E32<0,AND(E32=0,F32<0)),\"W\",\"E\")","v":"E"},{"$f":"Distance(B16,C16,E16,F16,B32,C32,E32,F32)","v":0.49999999999962375},{"$f":"Cap(B3,C3,E3,F3,B32,C32,E32,F32)","v":187.39006203641412}]
["Reprise ensouillage",{"$f":"TRUNC(Latitude(B16,C16,E16,F16,14,A29))","v":41},{"$f":"(Latitude(B16,C16,E16,F16,I4,A29)-B32)*60","v":30.502166666797734},{"$f":"IF(OR(B33<0,AND(B33=0,C33<0)),\"S\",\"N\")","v":"N"},{"$f":"TRUNC(Longitude(B16,C16,E16,F16,I4,A29))","v":40},{"$f":"(Longitude(B16,C16,E16,F16,I4,A29)-E32)*60","v":13.013119424027906},{"$f":"IF(OR(E33<0,AND(E33=0,F33<0)),\"W\",\"E\")","v":"E"},{"$f":"Distance(B16,C16,E16,F16,B33,C33,E33,F33)","v":0.49999999999959821},{"$f":"Cap(B3,C3,E3,F3,B33,C33,E33,F33)","v":187.3900620364137}]