{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["EtatFrais","BDD"],"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":"EtatFrais","index":0,"n_rows":9,"n_cols":16,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
["Nom & Prénom"]
["Service",{"$f":"IF(ISNA(VLOOKUP(B2,BDD!$A$2:$F$130,4,FALSE)),0,VLOOKUP(B2,BDD!$A$2:$F$130,4,FALSE))","v":0}]
["Résidence administrative",{"$f":"IF(ISNA(VLOOKUP(B2,BDD!$A$2:$F$130,5,FALSE)),0,VLOOKUP(B2,BDD!$A$2:$F$130,5,FALSE))","v":0}]
["Résidence familiale",{"$f":"IF(ISNA(VLOOKUP(B2,BDD!$A$2:$F$130,3,FALSE)),0,VLOOKUP(B2,BDD!$A$2:$F$130,3,FALSE))","v":0}]
["Distance domicile-résidence",{"$f":"IF(ISNA(VLOOKUP(B2,BDD!$A$2:$F$130,6,FALSE)),0,VLOOKUP(B2,BDD!$A$2:$F$130,6,FALSE))","v":0},"KM"]
["Véhicule (CV fiscaux)"]
[]
["Date","Objet","Moyen de transport","Destination","Lieu de départ","Nb km aller","Lieu de retour","Nb Km Retour","Km parcourus","Km remboursés","Km (€)","Repas (€)","Nuitée (€)","Autres frais (€)","Total remboursé","Télétravail"]

{"sheet":"BDD","index":1,"n_rows":118,"n_cols":6,"rows_kept":118,"cut":false,"hidden":true,"merged":[]}
["Nom","Prénom","RF","Service","RA","KM"]
["ADLOFF Michèle","Michèle","NEUF BRISACH","PREVENTION GESTION DES DECHETS","BIESHEIM",3]
["ANIDO Aline","Aline","EBERSHEIM","PISCINE","ILE DU RHIN VOGELGRUN",40.4]
["AUBRY Alison","Alison","OBERSAASHEIM","LES MICKALAS","KUNHEIM",12.1]
["BAECHLER Nicolas","Nicolas","COLMAR","ESPACES VERTS","ILE DU RHIN VOGELGRUN",20.399999999999999]
["BALMER Olivier","Olivier","HORBOURG WIHR","COMPTABILITE","VOLGELSHEIM",15.1]
["BAUER Alexandra","Alexandra","ANDOLSHEIM","LES HARZALAS","VOLGELSHEIM",13]
["BEXON Juliette","Juliette","AMMERSCHWIHR","PREVENTION GESTION DES DECHETS","BIESHEIM",25.3]
["BILBAUT Laurène","Laurène","KUNHEIM","LES MICKALAS","KUNHEIM",0]
["BIZOT Lucie","Lucie","SUNDHOUSE","ASSISTANCE INSTANCE","VOLGELSHEIM",33.700000000000003]
["BRUNNER Natacha","Natacha","NIEDERHERGHEIM","ASSAINISSEMENT","VOLGELSHEIM",13.6]
["BURDLOFF Mélissa","Mélissa","STE CROIX EN PLAINE","RELAI PETITE ENFANCE","VOLGELSHEIM",15]
["CAGNON Claire","Claire","DESSENHEIM","ECOLE DE MUSIQUE THEATRE","ILE DU RHIN VOGELGRUN",10.5]
["CHERKAOUI Cindy","Cindy","WIDENSOLEN","LES MICKALAS","KUNHEIM",6.9]
["COHU Eloïse","Eloïse","KUNHEIM","RESSOURCES HUMAINES","VOLGELSHEIM",8.6999999999999993]
["CROVISIER Laurence","Laurence","BOLLWILLER","RELAI PETITE ENFANCE","VOLGELSHEIM",37]
["DA CUNHA Radmila","Radimila","WECKOLSHEIM","LES MICKALAS","KUNHEIM",10.4]
["DALSTEIN Jessica","Jessica","MARCKOLSHEIM","COMMUNICATION","VOLGELSHEIM",19.8]
["DELETROZ Claire","Claire","FREIBURG IM BREIGSAU","ENVIRONNEMENT","VOLGELSHEIM",43.6]
["DIETH Marine","Marine","APPENWIHR","RESSOURCES HUMAINES","VOLGELSHEIM",9.6999999999999993]
["EBER Catherine","Catherine","VOLGELSHEIM","MOYENS GENERAUX","VOLGELSHEIM",0]
["EDEL Ludovic","Ludovic","MARMOUTIER","SMO PORT RHENAN","VOLGELSHEIM",89.9]
["EHRLACHER Jean-Michel","Jean-Michel","ANDOLSHEIM","DIRECTION GENERALE","VOLGELSHEIM",13]
["ENAUX Isabelle","Isabelle","BIESHEIM","LES MICKALAS","KUNHEIM",4.9000000000000004]
["FLAESCH FELICE Laetitia","Laetitia","WIDENSOLEN","ASSAINISSEMENT","VOLGELSHEIM",10.5]
["FLOTA Corinne","Corinne","COLMAR","POLE AMENAGEMENT URBA ET ENVIR.","VOLGELSHEIM",18.399999999999999]
["FORISSIER Anne","Anne","KUNHEIM","LES MICKALAS","KUNHEIM",0]
["FREDERICH Carine","Carine","WESTHALTEN","PREVENTION GESTION DES DECHETS","BIESHEIM",32.1]
["FREY Caroline","Caroline","KUNHEIM","LES MICKALAS","KUNHEIM",0]
["FRITSCH Emmanuel","Emmanuel","KUNHEIM","Musicales du Rhin","ILE DU RHIN VOGELGRUN",9.5]
["FRITZ Carole","Carole","BLODELSHEIM","TOURISME","FESSENHEIM",3.5]
["GALLENNE Florence","Florence","ORBEY","LES HARZALAS","VOLGELSHEIM",39.4]
["GASSER Jennifer","Jennifer","FESSENHEIM","ACTION ECONOMIQUE","FESSENHEIM",0]
["GENSON Estelle","Estelle","BIESHEIM","ACCUEIL GED","VOLGELSHEIM",3.1]
["GERBER Giselle","Giselle","MULHOUSE","COMMUNICATION","VOLGELSHEIM",41.4]
["GERIG-THORR Sarah","Sarah","VOLGELSHEIM","LES HARZALAS","VOLGELSHEIM",0]
["GIUDILLI Carmen","Carmen","NIEDERENTZEN","DIRECTION ADMIN FIN PATRI","VOLGELSHEIM",18.5]
["GMAEHLE Céline","Céline","ROUFFACH","LES HARZALAS","VOLGELSHEIM",24.4]
["GOETZ Marine","Marine","COLMAR","ART'RHENA","ILE DU RHIN VOGELGRUN",20.399999999999999]
["GOGUET Valentine","Valentine","MULLHEIM","PISCINE","ILE DU RHIN VOGELGRUN",36]
["GOLTZENE Jérémy","Jérémy","HERRLISHEIM PRES COLMAR","ART'RHENA","ILE DU RHIN VOGELGRUN",23.4]
["GRAEHLING Patricia","Patricia","VOLGELSHEIM","PISCINE","ILE DU RHIN VOGELGRUN",2.8]
["GRINGER Katia","Katia","OBERSAASHEIM","LES HARZALAS","VOLGELSHEIM",3]
["GRUNENWALD Thomas","Thomas","GEISHOUSE","DIRECTION ADMIN FIN PATRI","VOLGELSHEIM",64.599999999999994]
["GSELL Justine","Justine","WIDENSOLEN","LA GAMINERIE","VOLGELSHEIM",10.5]
["HADANGUE David","David","DESSENHEIM","ESPACES VERTS","ILE DU RHIN VOGELGRUN",10.5]
["HAGENMULLER Léa","Léa","INGERSHEIM","PISCINE","ILE DU RHIN VOGELGRUN",25.6]
["HEITZLER Céline","Céline","VOGELGRUN","ART'RHENA","ILE DU RHIN VOGELGRUN",2.1]
["HERBERT-MOSER Anne","Anne","COLMAR","LES HARZALAS","VOLGELSHEIM",18.399999999999999]
["HERSBERGER Julien","Julien","VOGELGRUN","MAINTENANCE","VOLGELSHEIM",1.8]
["HOLDER Valérie","Valerie","COLMAR","COMPTABILITE","VOLGELSHEIM",18.399999999999999]
["HUG Nathalie","Nathalie","BIESHEIM","ACCUEIL GED","VOLGELSHEIM",3.1]
["HUSSER Michèle","Michèle","DURRENENTZEN","LES MICKALAS","KUNHEIM",3.1]
["HUSSER Béatrice","Béatrice","KUNHEIM","LES MICKALAS","KUNHEIM",0]
["HUSSER Thierry","Thierry","DURRENENTZEN","ECOLE DE MUSIQUE THEATRE","ILE DU RHIN VOGELGRUN",12.7]
["IGLESIAS Camille","Camille","BALTZENHEIM","LES MICKALAS","KUNHEIM",2.7]
["ISARD Emilie","Emilie","BIESHEIM","RESSOURCES HUMAINES","VOLGELSHEIM",3.1]
["JONAS Nadège","Nadège","CHATENOIS","LES MICKALAS","KUNHEIM",27.6]
["KASTENDEUCH Sébastien","Sébastien","KUNHEIM","ANIMATIONS - JEUNESSE","ILE DU RHIN VOGELGRUN",9.5]
["KAUFFMANN Camille","Camille","WIHR AU VAL","URBANISME HABITAT AMENAGEMENT","VOLGELSHEIM",32.5]
["KIEFFER Marion","Marion","DESSENHEIM","LES MICKALAS","KUNHEIM",14.2]
["KLEE-COUTURIER Isabelle","Isabelle","KATZENTHAL","COOPERATION TRANSFRONTALIERE","ILE DU RHIN VOGELGRUN",28.7]
["KULAJ Marie","Marie","KUNHEIM","LES MICKALAS","KUNHEIM",0]
["LALOUETTE Rachel","Rachel","RUSTENHART","PISCINE","ILE DU RHIN VOGELGRUN",14.9]
["LAPORTE Jérôme","Jérôme","BIESHEIM","MAINTENANCE","VOLGELSHEIM",3.1]
["LAUX Grégory","Grégory","MULHOUSE","ART'RHENA","ILE DU RHIN VOGELGRUN",43.3]
["LEVER Aurélie","Aurélie","ENSISHEIM","LES MICKALAS","KUNHEIM",31.3]
["LIEUREY Corentin","Corentin","KAYSERSBERG VIGNOBLE","ASSAINISSEMENT","VOLGELSHEIM",29.5]
["LOEWERT Denis","Denis","DESSENHEIM","ASSAINISSEMENT","VOLGELSHEIM",7.8]
["MANN Delphine","Delphine","COLMAR","GECT– Eurodistrict Eurhena","ILE DU RHIN VOGELGRUN",20.399999999999999]
["MARCHAL Laura","Laura","PORTE DU RIED","LES MICKALAS","KUNHEIM",9.6999999999999993]
["MARIN Maëlle","Maëlle","BIESHEIM","PREVENTION GESTION DES DECHETS","BIESHEIM",0]
["MARING Floriane","Floriane","BISCHWIHR","ACTION ECONOMIQUE","FESSENHEIM",26.2]
["MARY Céline","Céline","HEITEREN","COMPTABILITE","VOLGELSHEIM",6.6]
["MAVILLA Jean-Pierre","Jean-Pierre","COLMAR","SMO PORT RHENAN","VOLGELSHEIM",18.399999999999999]
["MEISTER Anthony","Anthony","HABSHEIM","URBANISME HABITAT AMENAGEMENT","VOLGELSHEIM",40.4]
["MOHR Maude","Maude","BIESHEIM","PATRIMOINE TRAVAUX","VOLGELSHEIM",3.1]
["MENDELIN Rachel","Rachel","PFAFFENHEIM","PREVENTION GESTION DES DECHETS","BIESHEIM",29.4]
["MULLER Adeline","Adeline","VOLGELSHEIM","LES HARZALAS","VOLGELSHEIM",0]
["OBERST Benoît","Benoît","HORBOURG WIHR","PISCINE","ILE DU RHIN VOGELGRUN",17.8]
["PARANT Emmanuelle","Emmanuelle","ARTZENHEIM","ART'RHENA","ILE DU RHIN VOGELGRUN",13.5]
["PERIO Nelly","Nelly","BIESHEIM","LA GAMINERIE","VOLGELSHEIM",3.1]
["PFEFEN Nathalie","Nathalie","DURRENENTZEN","ANIMATIONS - JEUNESSE","ILE DU RHIN VOGELGRUN",12.7]
["PINEL Frédérique","Frédérique","BALGAU","LES HARZALAS","VOLGELSHEIM",11.6]
["PINGUET Clémence","Clemence","JEBSHEIM","LES MICKALAS","KUNHEIM",8.8000000000000007]
["RAETH Jean-Baptiste","Jean-Baptiste","COLMAR","ART'RHENA","ILE DU RHIN VOGELGRUN",20.399999999999999]
["RANVIER Jean-Valère","Jean-Valère","BALTZENHEIM","PATRIMOINE TRAVAUX","VOLGELSHEIM",10.3]
["RAUCH Véronique","Véronique","MUNCHHOUSE","ASSISTANCE INSTANCE","VOLGELSHEIM",20.9]
["REIN Christa","Christa","BIESHEIM","POLE PE","VOLGELSHEIM",3.3]
["REITER Natalie","Natalie","BURKHEIM VOGTSBURG","GECT– Eurodistrict Eurhena","ILE DU RHIN VOGELGRUN",11.6]
["RIEKER Katia","Katia","FESSENHEIM","LES HARZALAS","VOLGELSHEIM",13.2]
["RINGLER Justine","Justine","NAMBSHEIM","LES HARZALAS","VOLGELSHEIM",10.1]
["RISTIC David","David","MULHOUSE","ART'RHENA","ILE DU RHIN VOGELGRUN",43.3]
["ROLLAND Karine","Karine","ARTOLSHEIM","DRH MOYENS GENERAUX","VOLGELSHEIM",26.3]
["ROUHIER Dany","Dany","BIESHEIM","PREVENTION GESTION DES DECHETS","BIESHEIM",0]
["SCHATZ Sandra","Sandra","MUTTERSHOLTZ","RELAI PETITE ENFANCE","VOLGELSHEIM",35.1]
["SCHEER Véronique","Véronique","KUNHEIM","LES MICKALAS","KUNHEIM",0]
["SCHMITT Pascal","Pascal","HORBOURG WIHR","PATRIMOINE TRAVAUX","VOLGELSHEIM",15.1]
["SCHMITTER Léonard","Léonard","FELDKIRCH","PREVENTION GESTION DES DECHETS","BIESHEIM",34.4]
["SCHWEBEL Yannick","Yannick","HARTMANNSWILLER","ACTION ECONOMIQUE","FESSENHEIM",30.5]
["SCOURZIC Katia","Katia","HEITEREN","RELAI PETITE ENFANCE","VOLGELSHEIM",6.6]
["SERRA Araceli","Araceli","MARCKOLSHEIM","LES MICKALAS","KUNHEIM",9.8000000000000007]
["STEMMLER Maryline","Maryline","OBERHERGHEIM","ASSAINISSEMENT","VOLGELSHEIM",15.8]
["STORK Mélanie","Mélanie","BREISACH AM RHEIN","INFOBEST","ILE DU RHIN VOGELGRUN",2]
["STOTZER-HUG Christel","Christel","BIESHEIM","ART'RHENA","ILE DU RHIN VOGELGRUN",4.5999999999999996]
["TAHAR Olfa","Olfa","COLMAR","SIG","VOLGELSHEIM",18.399999999999999]
["TYBURN Donald","Donald","SELESTAT","PISCINE","ILE DU RHIN VOGELGRUN",34.299999999999997]
["UHL Julien","Julien","LANDSER","MAINTENANCE","VOLGELSHEIM",47.3]
["VANPRAET Jérémy","Jérémy","RUMERSHEIM LE HAUT","MAINTENANCE","VOLGELSHEIM",20.6]
["VERNAND Marine","Marine","MACKENHEIM","LES HARZALAS","VOLGELSHEIM",23.8]
["VIVEAUD Nabila","Nabila","VOLGELSHEIM","LES HARZALAS","VOLGELSHEIM",0]
["VONARB Karine","Karine","OBERSAASHEIM","LES HARZALAS","VOLGELSHEIM",3]
["VONARX Myriam","Myriam","HEITEREN","LES HARZALAS","VOLGELSHEIM",6.6]
["WATHLE Florentin","Florentin","COLMAR","ENERGIE ET CLIMAT","VOLGELSHEIM",18.399999999999999]
["WEBER Louise-Theresia","Louise-Theresia","COLMAR","INFOBEST","ILE DU RHIN VOGELGRUN",20.399999999999999]
["WOOLPERT Pascal","Pascal","DESSENHEIM","ECOLE DE MUSIQUE THEATRE","ILE DU RHIN VOGELGRUN",10.5]
["WYMANN Céline","Céline","RIBEAUVILLE","ECOLE DE MUSIQUE THEATRE","ILE DU RHIN VOGELGRUN",36.1]
["XERRI Gilles","Gilles","OSTHEIM","ACTION ECONOMIQUE","FESSENHEIM",37.799999999999997]