{"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":26,"n_cols":13,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Route","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,44.7,{"$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":59.089725083755887},{"$f":"Cap(B3,C3,E3,F3,B5,C5,E5,F5)","v":186.76437465887616},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,null,"Angle de Croisement"]
[null,null,null,null,null,null,null,null,null,{"$f":"M21","v":79.775383045473063}]
["Autre","Positions",null,null,null,null,null,"Distance","Cap"]
["Câble","Latitude",null,null,"Longitude",null,null,"(km)","(D°)"]
["P1",41,30,{"$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.334545387914552},{"$f":"Cap(B9,C9,E9,F9,B11,C11,E11,F11)","v":86.539757704349228}]
["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,"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.214101581275088},{"$f":"IF(OR(B16<0,AND(B16=0,C16<0)),\"S\",\"N\")","v":"N"},{"$f":"TRUNC(E21)","v":40},{"$f":"(E21-E16)*60","v":12.710060176283662},{"$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":27.002813142211629},{"$f":"Cap(B3,C3,E3,F3,B16,C16,E16,F16)","v":186.7643746588767}]
[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":6.5662981037538302},{"$f":"Cap(B9,C9,E9,F9,B16,C16,E16,F16)","v":86.539757705301312}]
["Version du 01/05/19"]
["Christian Auroux",{"$f":"Latitude(B3,C3,E3,F3,I4,H21)","v":41.503568359687918},null,null,{"$f":"Longitude(B3,C3,E3,F3,I4,H21)","v":40.211834336271394},null,null,27.002813142212499,null,{"$f":"ABS(I4-I10)","v":100.22461695452694},{"$f":"IF(L21>90,180-L21,L21)","v":79.775383045473063},{"$f":"IF(J21>90,180-J21,J21)","v":79.775383045473063},{"$f":"IF(K21>90,ABS(180-K21),ABS(K21))","v":79.775383045473063}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"1/SIN(60*PI()/180)","v":1.1547005383792517}]