{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["MISSION","DONNEES"],"not_rendered":{"charts":0,"images":2,"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":"MISSION","index":0,"n_rows":115,"n_cols":14,"rows_kept":115,"cut":false,"hidden":false,"merged":[[9,0,9,1],[10,0,10,13],[12,0,12,2],[12,3,12,8],[12,11,12,13],[26,0,26,6],[4,11,4,13],[5,0,5,10],[4,0,4,8],[7,0,7,2],[7,3,7,10],[18,0,18,5],[20,0,20,5],[22,0,22,5],[24,0,24,5],[18,6,18,12],[20,6,20,12],[22,6,22,12],[24,6,24,12],[14,0,14,2],[14,3,14,8],[14,11,14,13],[16,0,16,6],[46,6,47,7],[46,8,47,10],[46,11,47,11],[46,12,47,13],[51,6,52,7],[51,11,52,11],[50,6,50,13],[44,0,44,5],[44,6,44,10],[44,11,44,13],[45,6,45,7],[45,8,45,10],[45,12,45,13],[39,0,39,13],[40,0,40,13],[43,0,43,2],[43,3,43,5],[43,12,43,13],[43,8,43,10],[28,0,28,5],[37,0,37,5],[35,0,35,5],[28,6,28,12],[30,6,30,12],[33,6,33,12],[35,6,35,12],[37,6,37,12],[33,0,33,5],[30,0,30,5],[31,0,31,1],[31,2,31,13],[53,11,54,11],[55,11,56,11],[51,12,52,13],[53,12,54,13],[55,12,56,13],[53,6,54,7],[55,6,56,7],[51,8,52,10],[53,8,54,10],[55,8,56,10],[68,6,68,13],[69,6,70,7],[69,8,70,10],[69,11,70,13],[58,11,59,11],[60,11,61,11],[62,11,63,11],[64,11,65,11],[58,12,59,13],[60,12,61,13],[62,12,63,13],[64,12,65,13],[58,6,59,7],[60,6,61,7],[62,6,63,7],[64,6,65,7],[58,8,59,10],[60,8,61,10],[62,8,63,10],[64,8,65,10],[77,6,77,11],[80,6,81,11],[80,12,81,12],[71,6,72,7],[71,8,72,10],[71,11,72,11],[71,12,72,13],[73,6,74,7],[73,8,74,10],[73,11,74,11],[73,12,74,13],[114,6,114,12],[82,6,82,11],[83,6,83,11],[84,6,84,11],[85,6,85,11],[86,6,86,11],[87,6,87,11],[88,6,88,11],[89,6,89,11],[90,6,90,11],[91,6,91,11],[92,6,92,11],[93,6,93,11],[94,6,94,11],[100,6,100,11],[101,6,101,11],[102,6,102,11],[103,6,103,11],[104,6,104,11],[105,6,105,11],[106,6,106,11],[107,6,107,11],[108,6,108,11],[109,6,109,11],[113,6,113,11],[78,6,79,12],[95,6,95,11],[96,6,96,11],[97,6,97,11],[98,6,98,11],[99,6,99,11],[78,13,79,13],[80,13,81,13],[110,6,110,11],[111,6,111,11],[112,6,112,11]]}
[]
[null,null,null,null,null,null,null,null,null,null,"FOUR",null,"FACT"]
[null,null,null,null,null,null,null,null,null,null,"DIR.",null,"SERV"]
[null,null,null,null,null,null,null,null,null,null,"LIQ.",null,"DATE"]
["6, rue Francoeur - 75018 Paris",null,null,null,null,null,null,null,null,null,"CPTE & ANA."]
["ETAT DE FRAIS DE MISSION",null,null,null,null,null,null,null,null,null,null,null,"M2017"]
[]
["Exposé par : ",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L8=DONNEES!B1,\"TK\",\"\")","v":""}]
[]
["Mission :"]
[]
[]
["Lieu :",null,null,null,null,null,null,null,null,null,"Pays :"]
[]
["Date début de mission :",null,null,null,null,null,null,null,null,null,"Date fin de mission :"]
[]
["Récapitulatif des frais exposés :"]
[]
["Total frais de mission :",null,null,null,null,null,"-------------------------------------------------------------------------------------------------------------------------------------------",null,null,null,null,null,null,{"$f":"IF(M56+M63+M65=0,\"\",(M56+M63+M65))","v":""}]
[]
["Total frais de transport :",null,null,null,null,null,"-------------------------------------------------------------------------------------------------------------------------------------------",null,null,null,null,null,null,{"$f":"IF(M74=0,\"\",M74)","v":""}]
[]
["Total frais complémentaires :",null,null,null,null,null,"-------------------------------------------------------------------------------------------------------------------------------------------",null,null,null,null,null,null,{"$f":"IF(N115=0,\"\",N115)","v":""}]
[]
["TOTAL DES FRAIS :",null,null,null,null,null,"-------------------------------------------------------------------------------------------------------------------------------------------",null,null,null,null,null,null,{"$f":"SUM(N19,N21,N23)","v":0}]
[]
["Récapitulatif des versements effectués :"]
[]
["Avance versée :",null,null,null,null,null,"-------------------------------------------------------------------------------------------------------------------------------------------"]
[]
["Remboursement préalable :",null,null,null,null,null,"-------------------------------------------------------------------------------------------------------------------------------------------"]
["Détail :"]
[]
["Frais de mission déjà remboursés :",null,null,null,null,null,"-------------------------------------------------------------------------------------------------------------------------------------------"]
[]
["TOTAL DÉJÀ VERSE :",null,null,null,null,null,"-------------------------------------------------------------------------------------------------------------------------------------------",null,null,null,null,null,null,{"$f":"SUM(N31,N34,N29)","v":0}]
[]
["TOTAL A REGLER :",null,null,null,null,null,"-------------------------------------------------------------------------------------------------------------------------------------------",null,null,null,null,null,null,{"$f":"N25-N36","v":0}]
[]
["Certifie sincère et véritable le présent état à la somme de :"]
[]
[]
[]
["DEVISE :",null,null,{"$f":"IF(L13=DONNEES!A2,\"EUR\",\"\")","v":""},null,null,null,"I.J.",null,null,null,"TAUX DE CHANCELLERIE :"]
["A = Avion",null,null,null,null,null,"DEPART DE LA RESIDENCE",null,null,null,null,"RETOUR A LA RESIDENCE"]
["Total",null,{"$f":"SUM(C48:C115)","v":0},{"$f":"SUM(D48:D115)","v":0},{"$f":"SUM(E48:E115)","v":0},null,"JOUR",null,"HEURE",null,null,"JOUR","HEURE"]
["date","jour","midi","soir","nuit",null,{"$f":"IF(D15=\"\",\"\",D15)","v":""},null,null,null,null,{"$f":"IF(L15=\"\",\"\",L15)","v":""}]
[{"$f":"IF(G47=\"\",\"\",G47)","v":""},{"$f":"IF(A48=\"\",\"\",A48)","v":""}]
[{"$f":"IF($L$47=\"\",\"\",IF($L$47=A48,\"\",IF(A48=\"\",\"\",A48+1)))","v":""},{"$f":"IF(A49=\"\",\"\",A49)","v":""}]
[{"$f":"IF($L$47=\"\",\"\",IF($L$47=A49,\"\",IF(A49=\"\",\"\",A49+1)))","v":""},""]
["","",null,null,null,null,"FRAIS DE MISSION"]
["","",null,null,null,null,"REPAS MISSION :",null,{"$f":"IF(C46+D46=0,\"\",C46+D46)","v":""},null,null,"REPAS A DEDUIRE :"]
["",""]
["","",null,null,null,null,"REPAS PRIS EN CHARGE PAR :",null,null,null,null,"NOMBRE REPAS :",{"$f":"IF(I52=\"\",\"\",I52-M52)","v":""}]
["",""]
["","",null,null,null,null,"TAUX :",null,{"$f":"IF(I44=\"\",\"\",PRODUCT(I44*0.175))","v":""},null,null,"SOMME DUE :",{"$f":"PRODUCT(M54,I56)","v":0}]
["",""]
["",""]
["","",null,null,null,null,"NUITEE MISSION :",null,{"$f":"IF(E46=0,\"\",E46)","v":""},null,null,"NUIT A DEDUIRE :"]
["",""]
["","",null,null,null,null,"HEB. PRIS EN CHARGE PAR :",null,null,null,null,"NOMBRE NUITEE :",{"$f":"IF(I59=\"\",\"\",I59-M59)","v":""}]
["",""]
["","",null,null,null,null,"TAUX :",null,{"$f":"IF(I44=\"\",\"\",PRODUCT(I44*0.65))","v":""},null,null,"SOMME DUE :",{"$f":"PRODUCT(M61,I63)","v":0}]
["",""]
["","",null,null,null,null,"REGLE A L'HOTEL :",null,null,null,null,"BOURSE DE VIE :"]
["",""]
["",""]
["",""]
["","",null,null,null,null,"FRAIS DE TRANSPORT"]
["","",null,null,null,null,"MODE TRANSPORT :"]
["",""]
["","",null,null,null,null,{"$f":"IF(OR(MISSION!I70=DONNEES!C1,MISSION!I70=DONNEES!C2,MISSION!I70=DONNEES!C3,MISSION!I70=DONNEES!C4),\"CLASSE :\",IF(MISSION!I70=DONNEES!C5,\"CV VEHICULE PERSO :\",\"\"))","v":""},null,null,null,null,{"$f":"IF(OR(MISSION!I70=DONNEES!C1,MISSION!I70=DONNEES!C2,MISSION!I70=DONNEES!C3,MISSION!I70=DONNEES!C4),\"REGLE AU VOYAGISTE:\",IF(MISSION!I70=DONNEES!C5,\"IDEMNITE KM :\",\"\"))","v":""}]
["",""]
["","",null,null,null,null,{"$f":"IF(OR(MISSION!I70=DONNEES!C1,MISSION!I70=DONNEES!C2,MISSION!I70=DONNEES!C3,MISSION!I70=DONNEES!C4),\"TRANSPORT PRIS EN CHARGE PAR :\",IF(MISSION!I70=DONNEES!C5,\"KM PARCOURUS :\",\"\"))","v":""},null,null,null,null,"SOMME DUE :",{"$f":"IF(I70=DONNEES!C5,PRODUCT(MISSION!I74:K75,MISSION!M72:N73),\"\")","v":""}]
["",""]
["",""]
["",""]
["","",null,null,null,null,"FRAIS COMPLEMENTAIRES",null,null,null,null,null,"DEVISE","EURO"]
["","",null,null,null,null,"Frais de taxi en euros"]
["",""]
["","",null,null,null,null,"Frais de taxi en devises",null,null,null,null,null,null,{"$f":"IF(M81=\"\",\"\",ROUND(PRODUCT(M81,$M$44),2))","v":""}]
["",""]
["","",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M83=\"\",\"\",ROUND(PRODUCT(M83,$M$44),2))","v":""}]
["","",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M84=\"\",\"\",ROUND(PRODUCT(M84,$M$44),2))","v":""}]
["","",null,null,null,null,null,null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M101=\"\",\"\",ROUND(PRODUCT(M101,$M$44),2))","v":""}]
["","",null,null,null,null,null,null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,""]
["",{"$f":"IF(A113=\"\",\"\",A113)","v":""},null,null,null,null,null,null,null,null,null,null,null,""]
[{"$f":"IF($L$47=\"\",\"\",IF($L$47=A113,\"\",IF(A113=\"\",\"\",A113+1)))","v":""},"",null,null,null,null,null,null,null,null,null,null,null,""]
["","",null,null,null,null,"TOTAL :",null,null,null,null,null,null,{"$f":"SUM(N79:N114)","v":0}]

{"sheet":"DONNEES","index":1,"n_rows":215,"n_cols":4,"rows_kept":215,"cut":false,"hidden":false,"merged":[]}
["LISTE PAYS","Permanent","Train","AMGAR Géraldine"]
["FRANCE","Elève ","Avion","BENASTRE Valérie"]
["AFGHANISTAN                         ","Intervenant","Bateau","BERREUR Laurence"]
["AFRIQUE DU SUD                      ",null,"Véhicule location","BORENSTEIN Pascale"]
["ALBANIE                             ",null,"Véhicule personnel","BOUFFLET Jossie"]
["ALGERIE                             ",null,null,"BRECHER Jonathan"]
["ALLEMAGNE (REPUBLIQUE FEDERALE D')  ",null,null,"BURSTEIN Carine"]
["ANDORRE                             ",null,null,"CANTIN Véronique"]
["ANGOLA                              ",null,null,"CHAGNARD Sylvie"]
["ANGUILLA                            ",null,null,"CHASSAGNE Sabine"]
["ANTIGUA                             ",null,null,"CHERRUAU Marc"]
["ARABIE SAOUDITE                     ",null,null,"CORREARD Sylvie "]
["ARGENTINE                           ",null,null,"COSTE CERDAN Nathalie"]
["ARMENIE                             ",null,null,"DEGRAEF Valérie"]
["ARUBA                               ",null,null,"DOARE Claude "]
["AUSTRALIE                           ",null,null,"DOISY Gilles"]
["AUTRICHE                            ",null,null,"DULAURENT Claire"]
["AZERBAIDJAN                         ",null,null,"ELANA Marie-José"]
["BAHAMAS                             ",null,null,"FANIER Caroline"]
["BAHREIN                             ",null,null,"FANTL Hélèna "]
["BANGLADESH                          ",null,null,"FAVROU Samuel"]
["BARBADE                             ",null,null,"FEUILLATRE Pierre"]
["BELGIQUE                            ",null,null,"FIGEAC Alain "]
["BELIZE                              ",null,null,"GABET Lionel"]
["BENIN                               ",null,null,"GANNAGE Myriam"]
["BERMUDES                            ",null,null,"GARRY Stéphane"]
["BHOUTAN                             ",null,null,"GHAZARIAN Christine"]
["BIELORUSSIE                         ",null,null,"JIAR Youssef"]
["BOLIVIE                             ",null,null,"KALONJI  Olivier"]
["BOSNIE-HERZEGOVINE                  ",null,null,"LAICHE Eric"]
["BOTSWANA                            ",null,null,"LE GONIDEC Anne"]
["BRESIL                              ",null,null,"LE XUAN Hoa "]
["BRUNEI DARUSSALAM                   ",null,null,"LEBELLE Anne"]
["BULGARIE                            ",null,null,"LEDANOIS Elisabeth"]
["BURKINA FASO                        ",null,null,"LEFEVRE Amélie"]
["BURUNDI                             ",null,null,"LEVASSEUR Fabienne "]
["CAIMANS (ILES)                      ",null,null,"MANIGNE Sarah"]
["CAMBODGE                            ",null,null,"MILOCHEVITCH Fabien"]
["CAMEROUN                            ",null,null,"MOLIERE Nadine"]
["CANADA                              ",null,null,"MULTIER Marine"]
["CAP-VERT                            ",null,null,"NKOUNKOU Alexis"]
["CARAIBES ORIENTALES                 ",null,null,"PANNETIER Arielle"]
["CENTRAFRICAINE (REPUBLIQUE)         ",null,null,"PAPON Frédéric"]
["CHILI                               ",null,null,"PASO Christian"]
["CHINE                               ",null,null,"PATY Florie Anne"]
["CHYPRE                              ",null,null,"PEDROSO Jacques "]
["COLOMBIE                            ",null,null,"PILLOIS Nicolas"]
["COMORES                             ",null,null,"PLUSS Agnès"]
["CONGO                               ",null,null,"POCHOLLE Jérôme"]
["CONGO (REPUBLIQUE DEMOCRATIQUE DU)  ",null,null,"POUECH Stéphanie"]
["COOK (ILES)                         ",null,null,"RABOURDIN Aube"]
["COREE DU NORD                       ",null,null,"ROGUET Michel"]
["COREE DU SUD                        ",null,null,"SICARD Hélène"]
["COSTA RICA                          ",null,null,"STAB Mickael"]
["COTE D'IVOIRE                       ",null,null,"TAHRI Said"]
["CROATIE                             ",null,null,"TEMPELAERE Hélène"]
["CUBA                                ",null,null,"TINGAUD Julie "]
["CURACAO                             ",null,null,"TRUONG Jacqueline"]
["DANEMARK                            ",null,null,"TURQUIER Barbara"]
["DJIBOUTI                            ",null,null,"URBAIN Karine"]
["DOMINICAINE (REPUBLIQUE)            ",null,null,"URTADO Marc"]
["DOMINIQUE                           ",null,null,"WATERLOT Lucille"]
["EGYPTE (REPUBLIQUE ARABE D')        "]
["EMIRATS ARABES UNIS                 "]
["EQUATEUR                            "]
["ERYTHREE                            "]
["ESPAGNE                             "]
["ESTONIE                             "]
["ETATS-UNIS                          "]
["ETHIOPIE                            "]
["FIDJI                               "]
["FINLANDE                            "]
["GABON                               "]
["GAMBIE                              "]
["GEORGIE                             "]
["GHANA                               "]
["GRANDE-BRETAGNE                     "]
["GRECE                               "]
["GRENADE                             "]
["GRENADINES                          "]
["GUATEMALA                           "]
["GUINEE (CONAKRY)                    "]
["GUINEE BISSAU                       "]
["GUINEE EQUATORIALE                  "]
["GUYANA (GEORGETOWN)                 "]
["HAITI                               "]
["HONDURAS                            "]
["HONG-KONG                           "]
["HONGRIE                             "]
["ILES PALAOS                         "]
["INDE                                "]
["INDONESIE                           "]
["IRAK                                "]
["IRAN                                "]
["IRLANDE                             "]
["ISLANDE                             "]
["ISRAEL                              "]
["ITALIE                              "]
["JAMAIQUE                            "]
["JAPON                               "]
["JORDANIE                            "]
["KAZAKHSTAN                          "]
["KENYA                               "]
["KIRGHIZIE                           "]
["KIRIBATI                            "]
["KOSOVO                              "]
["KOWEIT                              "]
["LAOS                                "]
["LESOTHO                             "]
["LETTONIE                            "]
["LIBAN                               "]
["LIBERIA                             "]
["LIBYE                               "]
["LIECHTENSTEIN                       "]
["LITUANIE                            "]
["LUXEMBOURG                          "]
["LUXEMBOURG (VILLE)                  "]
["MACAO                               "]
["MACEDOINE                           "]
["MADAGASCAR                          "]
["MALAISIE                            "]
["MALAWI                              "]
["MALDIVES                            "]
["MALI                                "]
["MALTE                               "]
["MAROC                               "]
["MARSHALL (ILES)                     "]
["MAURICE                             "]
["MAURITANIE                          "]
["MAYOTTE                             "]
["MEXIQUE                             "]
["MICRONESIE                          "]
["MOLDAVIE                            "]
["MONACO                              "]
["MONGOLIE EXTERIEURE                 "]
["MONTENEGRO                          "]
["MOZAMBIQUE                          "]
["MYANMAR (ANC.BIRMANIE)              "]
["NAMIBIE                             "]
["NAURU                               "]
["NEPAL                               "]
["NICARAGUA                           "]
["NIGER                               "]
["NIGERIA                             "]
["NIUE                                "]
["NORVEGE                             "]
["NOUVELLE-CALEDONIE                  "]
["NOUVELLE-GUINEE PAPOUASIE           "]
["NOUVELLE-ZELANDE                    "]
["OMAN                                "]
["OUGANDA                             "]
["OUZBEKISTAN                         "]
["PAKISTAN                            "]
["PANAMA                              "]
["PARAGUAY                            "]
["PAYS-BAS                            "]
["PEROU                               "]
["PHILIPPINES                         "]
["POLOGNE                             "]
["POLYNESIE FRANCAISE                 "]
["PORTUGAL                            "]
["QATAR                               "]
["RéPUBLIQUE DU SOUDAN DU SUD         "]
["ROUMANIE                            "]
["RUSSIE                              "]
["RWANDA                              "]
["SAINTE-LUCIE ET LES AUTRES PAYS DES CARAIBES DE L'EST  "]
["SAINT-KITTS-ET-NEVIS                "]
["SAINT-PIERRE-ET-MIQUELON            "]
["SAINT-VINCENT                       "]
["SALOMON (ILES)                      "]
["SALVADOR                            "]
["SAMOA OCCIDENTALES                  "]
["SAO TOME-ET-PRINCIPE                "]
["SENEGAL                             "]
["SERBIE                              "]
["SERBIE-MONTENEGRO                   "]
["SEYCHELLES                          "]
["SHANGHAI                            "]
["SIERRA LEONE                        "]
["SINGAPOUR                           "]
["SLOVAQUIE                           "]
["SLOVENIE                            "]
["SOMALIE                             "]
["SOUDAN                              "]
["SRI LANKA (EX CEYLAN)               "]
["SUEDE                               "]
["SUISSE                              "]
["SURINAM                             "]
["SWAZILAND                           "]
["SYRIE                               "]
["TADJIKISTAN                         "]
["TAIWAN (EX FORMOSE)                 "]
["TANZANIE                            "]
["TCHAD                               "]
["TCHEQUE (REPUBLIQUE)                "]
["THAILANDE                           "]
["TIMOR EST                           "]
["TOGO                                "]
["TONGA                               "]
["TRINITE ET TOBAGO                   "]
["TUNISIE                             "]
["TURKMENISTAN                        "]
["TURQUIE                             "]
["TUVALU                              "]
["UKRAINE                             "]
["URUGUAY                             "]
["VANUATU                             "]
["VENEZUELA                           "]
["VIETNAM                             "]
["WALLIS ET FUTUNA, ILES              "]
["YEMEN (REPUBLIQUE DU)               "]
["YOUGOSLAVIE (VOIR SERBIE-MONTENEGRO)"]
["ZAMBIE                              "]
["ZIMBABWE                            "]