{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Geodesie","Conversions","Projections","Spheroides"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Geodesie","index":0,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,2,2,3],[2,5,2,6]]}
[]
[]
[null,null,"Sphéroïde",null,null,"Projection UTM"]
[null,42,"Sphéroïde",{"$f":"INDEX(Spheroides!C8:C56,B4)","v":"WGS 84"},1,"Projection",{"$f":"INDEX(Projections!F3:F4,Geodesie!E4)","v":"N"}]
[null,19,"Gd Axe:",{"$f":"INDEX(Spheroides!D8:D56,B4)","v":6378137},null,"Zone",{"$f":"IF(G6=TRUNC(G6,1),IF(G7=\"W\",(183-G6)/6,(183+G6)/6),\"\")","v":32}]
[null,null,"Pt Axe:",{"$f":"INDEX(Spheroides!E8:E56,B4)","v":6356752.3140000002},4,"Merid. Ctrl.",{"$f":"INDEX(Projections!A3:A33,Geodesie!E6)","v":9},{"$f":"G6","v":9}]
[null,null,"e2",{"$f":"INDEX(Spheroides!F8:F56,B4)","v":6.6943800667646578E-3},1,"E/W",{"$f":"INDEX(Projections!G3:G4,Geodesie!E7)","v":"E"},"E"]
[null,null,"n",{"$f":"INDEX(Spheroides!G8:G56,B4)","v":1.6792204056685965E-3},1,"Lat. Or.",{"$f":"INDEX(Projections!B3:B64,Geodesie!E8)","v":0},0]
[null,null,"1 / f",{"$f":"INDEX(Spheroides!H8:H56,B4)","v":298.25722014342756},1,"N/S",{"$f":"INDEX(Projections!F3:F4,Geodesie!E9)","v":"N"},"N"]
[null,null,null,null,2,"Aplat.",{"$f":"INDEX(Projections!E3:E6,Geodesie!E10)","v":0.99960000000000004},0.99960000000000004]
[null,null,null,null,3,"Faux E",{"$f":"INDEX(Projections!C3:C8,Geodesie!E11)","v":500000},500000]
[null,null,null,null,1,"Faux N",{"$f":"INDEX(Projections!D3:D4,Geodesie!E12)","v":0},0]

{"sheet":"Conversions","index":1,"n_rows":25,"n_cols":17,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,1,2,16],[5,1,5,8],[10,2,10,4],[10,6,10,8],[4,1,4,8],[7,10,7,16],[8,12,8,15],[7,1,7,8],[8,1,8,4],[8,5,8,8],[23,2,23,4],[23,6,23,8],[17,1,17,8],[20,1,20,8],[4,10,4,16],[5,10,5,16],[21,12,21,15],[20,10,20,16],[14,1,15,16],[18,1,18,8],[17,10,17,16],[18,10,18,16],[21,1,21,4],[21,5,21,8]]}
[]
[null,"Conversion de géographiques vers UTM"]
[]
[]
[null,"Sphéroïde",null,null,null,null,null,null,null,null,"Projection"]
[null,{"$f":"Geodesie!D4","v":"WGS 84"},null,null,null,null,null,null,null,null,{"$f":"\"UTM \"&Geodesie!G4&\" - Zone \"&Geodesie!G5","v":"UTM N - Zone 32"}]
[null,{"$f":"B10+C10/60+D10/3600","v":41.140155555555552},{"$f":"CaGeLon1(B25,F25)","v":{"$error":"#NAME?"}},{"$f":"(ABS(B7)-ABS(B10))*60","v":8.4093333333331088},null,{"$f":"F10+G10/60+H10/3600","v":10.191555000000001},null,{"$f":"(ABS(C7)-ABS(F10))*60","v":{"$error":"#NAME?"}}]
[null,"Coordonnées Géographiques",null,null,null,null,null,null,null,null,"UTM"]
[null,"Latitude",null,null,null,"Longitude",null,null,null,null,"Eastings","Northings","Convergence",null,null,null,"Fact. d'Echelle"]
[null,41,8,24.56,{"$f":"IF(B7<0,\"S\",\"N\")","v":"N"},10,11,29.597999999999999,{"$f":"IF(F7<0,\"W\",\"E\")","v":"E"},null,{"$f":"GeoUTMX(C12,D12,G12,H12)","v":600000.00432651443},{"$f":"GeoUTMY(C12,D12,G12,H12)","v":4555000.0068321023},{"$f":"ABS(TRUNC(M11,0))","v":0},{"$f":"TRUNC((ABS(M11)-M10)*60)","v":47},{"$f":"(ABS(N11)-N10)*60","v":2.3737431484410365},{"$f":"IF(M11<0,\"W\",\"E\")","v":"E"},{"$f":"FactEchelle(K10,M10)","v":0.99972378910413207}]
[null,null,"Latitude",null,null,null,"Longitude",null,null,null,null,null,{"$f":"convergence(K10,L10)","v":0.78399270643012253},{"$f":"(ABS(M11)-M10)*60","v":47.039562385807351}]
[null,null,{"$f":"TRUNC(B7,0)","v":41},{"$f":"ABS(B7-TRUNC(B7,0))*60","v":8.4093333333331088},{"$f":"IF(B7<0,\"S\",\"N\")","v":"N"},null,{"$f":"TRUNC(F7,0)","v":10},{"$f":"ABS(F7-F10)*60","v":11.493300000000062},{"$f":"IF(F7<0,\"W\",\"E\")","v":"E"}]
[]
[]
[null,"Conversion d'UTM vers géographiques"]
[]
[]
[null,"Sphéroïde",null,null,null,null,null,null,null,null,"Projection"]
[null,{"$f":"Geodesie!D4","v":"WGS 84"},null,null,null,null,null,null,null,null,{"$f":"\"UTM \"&Geodesie!G4&\" - Zone \"&Geodesie!G5","v":"UTM N - Zone 32"}]
[]
[null,"Coordonnées Géographiques",null,null,null,null,null,null,null,null,"UTM"]
[null,"Latitude",null,null,null,"Longitude",null,null,null,null,"Eastings","Northings","Convergeance",null,null,null,"Fact. d'Echelle"]
[null,{"$f":"ABS(C25)","v":41},{"$f":"TRUNC(D25,0)","v":8},{"$f":"(D25-C23)*60","v":24.559797607490168},{"$f":"IF(B20<0,\"S\",\"N\")","v":"N"},{"$f":"ABS(G25)","v":10},{"$f":"TRUNC(H25,0)","v":11},{"$f":"(H25-G23)*60","v":29.597810459812166},{"$f":"IF(F20<0,\"W\",\"E\")","v":"E"},null,600000,4555000,{"$f":"ABS(TRUNC(M24,0))","v":0},{"$f":"TRUNC((ABS(M24)-M23)*60)","v":47},{"$f":"(ABS(N24)-N23)*60","v":2.373614965495392},{"$f":"IF(M24<0,\"W\",\"E\")","v":"E"},{"$f":"FactEchelle(K23,M23)","v":0.99972378909342052}]
[null,null,"Latitude",null,null,null,"Longitude",null,null,null,null,null,{"$f":"convergence(K23,L23)","v":0.78399267082374868},{"$f":"(ABS(M24)-M23)*60","v":47.039560249424923}]
[null,{"$f":"lambgeolat(K23,L23)","v":{"$error":"#NAME?"}},{"$f":"TRUNC(UTMgeolat(K23,L23),0)","v":41},{"$f":"ABS((UTMgeolat(K23,L23)-C25)*60)","v":8.4093299601248361},{"$f":"IF(B20<0,\"S\",\"N\")","v":"N"},{"$f":"lambgeolon(K23,L23)","v":{"$error":"#NAME?"}},{"$f":"TRUNC(UTMgeolon(K23,L23))","v":10},{"$f":"ABS((UTMgeolon(K23,L23)-G25)*60)","v":11.493296840996869},{"$f":"IF(F20<0,\"W\",\"E\")","v":"E"}]

{"sheet":"Projections","index":2,"n_rows":64,"n_cols":7,"rows_kept":64,"cut":false,"hidden":true,"merged":[]}
["Ajouter les nouvelles data en fin de colonnes",null,null,null,"Ne pas editer cette feuille"]
["Meridien Central en degres","Latitude d'origine","Eastings d'origines","Nothings d'origines","Facteur d'echelle au M C","N/S","E/W"]
[0,0,0,0,1,"N","E"]
[2,1,300000,10000000,0.99960000000000004,"S","W"]
[3,2,500000]
[9,3,600000]
[15,4]
[21,5]
[27,6]
[33,7]
[39,8]
[45,9]
[51,10]
[57,11]
[63,12]
[69,13]
[75,14]
[81,15]
[87,16]
[93,17]
[103,18]
[109,19]
[115,20]
[121,21]
[127,22]
[133,23]
[139,24]
[145,25]
[151,26]
[157,27]
[163,28]
[169,29]
[175,30]
[null,31]
[null,32]
[null,33]
[null,34]
[null,35]
[null,36]
[null,37]
[null,38]
[null,39]
[null,40]
[null,41]
[null,42]
[null,43]
[null,44]
[null,45]
[null,46]
[null,47]
[null,48]
[null,49]
[null,50]
[null,51]
[null,52]
[null,53]
[null,54]
[null,55]
[null,56]
[null,57]
[null,58]
[null,59]
[null,60]
[null,61]

{"sheet":"Spheroides","index":3,"n_rows":56,"n_cols":8,"rows_kept":56,"cut":false,"hidden":true,"merged":[]}
["Liste des Ellipsoides Disponibles"]
[]
[]
[]
[]
[]
[null,null,"Nom","Demi Grand","Demi Petit","e2","n","1 / f"]
[null,1,"AIRY",6377563.3959999997,6356256.909,{"$f":"POWER(1/D8*(SQRT((D8*D8)-(E8*E8))),2)","v":6.6705400741490836E-3},1.6732202503250534E-3,{"$f":"1/((D8-E8)/D8)","v":299.32496126649505}]
[null,2,"AIRY MOD",6377340.1890000002,6356034.4479999999,6.6705399807736503E-3,1.6732203054869081E-3,299.32496546352854]
[null,3,"AUSTRALIAN NATIONAL 1967/84",6378160,6356774.7189999996,6.694541915624532E-3,null,{"$f":"1/((D10-E10)/D10)","v":298.24999727615801}]
[null,4,"BESSEL 1841",6377397.1550000003,6356078.9630000005,6.6743721749749326E-3,1.6741847868128074E-3,299.15281535132334]
[null,5,"BESSEL 1841 MOD",6377483.8650000002,6356165.3830000004,6.6743722212770787E-3,1.6741847984660181E-3,299.15281327254201]
[null,6,"BESSEL NGO",6377492.0180000002,6356173.5089999996,6.6743721420039794E-3,null,299.152816831601]
[null,7,"BESSEL RD / POTSDAM",6377397.1550000003,6356078.9630000005,6.6743721749749326E-3,null,299.15281535132334]
[null,8,"BROADCAST",6378135,6356750.5199999996,6.6943177832963279E-3,null,298.25999977553192]
[null,9,"CLARKE 1856",6378235.5999999996,6356560.1399999997,6.785145919996286E-3,null,294.26068005015861]
[null,10,"CLARKE 1866",6378206.4000000004,6356583.7999999998,6.7686579972911819E-3,1.6979156829769022E-3,294.97869821389821]
[null,11,"CLARKE 1880",6378249.1449999996,6356514.8700000001,6.8035111421552033E-3,1.7066884768653044E-3,293.46500607911531]
[null,12,"CLARKE 1880 IGN",6378249.2000000002,6356515,{"$f":"POWER(1/D19*(SQRT((D19*D19)-(E19*E19))),2)","v":6.8034876462998934E-3},null,293.46602129362691]
[null,13,"CLARKE 1880 MOD",6378249.1449999996,6356514.8700000001,{"$f":"POWER(1/D20*(SQRT((D20*D20)-(E20*E20))),2)","v":6.8035111421552033E-3},1.7066884768653044E-3,293.46500607911531]
[null,14,"CLARKE 1880 (PALESTINE)",6378300.7819999997,6356566.4270000001,{"$f":"POWER(1/D21*(SQRT((D21*D21)-(E21*E21))),2)","v":6.803481156342152E-3},null,293.46630171450414]
[null,15,"DANISH 1876  / ANDRAE",6377104.4299999997,6355847.415,6.6555556284901502E-3,null,299.99999670697417]
[null,16,"EVEREST (INDE) METRIQUE",6377301.2429999998,6356100.2300000004,6.6378461201175376E-3,null,300.80172315352098]
[null,17,"EVEREST (MALAYA)",6377295.6639999999,6356094.6679999996,6.637846603695206E-3,null,{"$f":"1/((D24-E24)/D24)","v":300.80170120309049}]
[null,18,"EVEREST 1830",6377276.3449999997,6356075.4129999997,6.6378466740345783E-3,1.6649922505031004E-3,300.80169801025681]
[null,19,"EVEREST 1830 (MOD.)",6377298.5609999998,6356097.5549999997,6.6378467190551368E-3,null,300.80169596669066]
[null,20,"EVEREST BORNEO",6377298.5559999999,6356097.5549999997,6.6378451614016471E-3,null,300.80176667129774]
[null,21,"EVEREST MOD.",6377304.0630000001,6356103.0389999999,6.6378466280601449E-3,null,300.80170009712441]
[null,22,"FISHER 1960 (MERCURY)",6378166,6356784.284,6.6934215001796154E-3,null,298.30000548131846]
[null,23,"FISHER 1968",6378150,6356768.3370000003,6.6934216993408307E-3,null,298.29999659054056]
[null,24,"FISCHER MOD",6378160,6356774.7189999996,6.694541915624532E-3,1.6792611404669755E-3,298.24999727615801]
[null,25,"FISHER MOD. 1960",6378155,6356773.3200000003,6.6934217738298723E-3,null,298.29999326526678]
[null,26,"GRS 67",6378160,6356774.5159999998,6.694605356917795E-3,null,298.24716616186703]
[null,27,"GRS 80",6378137,6356752.3140000002,6.6943800667646578E-3,null,298.25722014342756]
[null,28,"HELMERT 1906",6378200,6356818,6.6934746345492999E-3,1.6789925228217189E-3,298.29763352352444]
[null,29,"HOUGH",6378270,6356794.3430000003,6.7226701580694282E-3,1.6863406749730355E-3,296.99999399320365]
[null,30,"INTERNATIONAL",6378388,6356911.9460000005,{"$f":"POWER(1/D37*(SQRT((D37*D37)-(E37*E37))),2)","v":6.7226700623166684E-3},1.6863406508729228E-3,296.9999982305938]
[null,31,"JEFFREYS 1948",6378099,6356631,6.7204571463943836E-3,null,297.09795975405251]
[null,32,"KRASSOVSKY",6378245,6356863,6.6934274898192208E-3,1.6789806572508061E-3,298.29973809746514]
[null,33,"PRECISE",6378145,6356759.7690000003,6.6945420073107756E-3,1.6792611635429559E-3,{"$f":"1/((D40-E40)/D40)","v":298.2499931845532}]
[null,34,"REF ELLIPSOIDE 1967",6378160,6356774.7189999996,6.694541915624532E-3,1.6792611404669755E-3,298.24999727615801]
[null,35,"S AMERICA 1969",6378160,6356774.7189999996,6.694541915624532E-3,1.6792611404669755E-3,298.24999727615801]
[null,36,"STRUVE 1860",6378298.2999999998,6356657.1430000002,6.7743596975477745E-3,null,294.73000450022613]
[null,37,"SVANBERG",6376797,6355837.9709999999,6.5627258654816379E-3,null,304.25059290675966]
[null,38,"WAR OFFICE 1924",6378300,6356751.6890000002,6.7453433754114476E-3,null,295.99999740119182]
[null,39,"WGS 60",6378165,6356783.2869999995,6.6934216102894064E-3,null,298.30000056589779]
[null,40,"WGS 66",6378145,6356759.7690000003,6.6945420073107756E-3,null,298.2499931845532]
[null,41,"WGS 72",6378135,6356750.5199999996,6.6943177832963279E-3,1.6792047299063939E-3,298.25999977553192]
[null,42,"WGS 84",6378137,6356752.3140000002,6.6943800667646578E-3,1.6792204056685965E-3,298.25722014342756]
[null,43]
[null,44]
[null,45]
[null,46]
[]
[]
[null,null," "]