{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Feuil1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":1,"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":"Feuil1","index":0,"n_rows":143,"n_cols":35,"rows_kept":143,"cut":false,"hidden":false,"merged":[[142,1,142,25],[118,1,118,25],[128,1,128,25],[129,1,129,25],[130,1,130,25],[132,1,132,25],[135,1,135,25],[131,1,131,25],[127,1,127,25],[139,1,139,25],[125,1,125,25],[136,1,136,25],[134,1,134,25],[137,1,137,25],[138,1,138,25],[141,1,141,25],[140,1,140,25],[121,1,121,25],[120,26,120,27],[126,1,126,25],[123,1,123,25],[121,26,121,27],[141,26,141,27],[139,26,139,27],[122,26,122,27],[133,1,133,25],[131,26,131,27],[132,26,132,27],[130,26,130,27],[136,26,136,27],[138,26,138,27],[140,26,140,27],[137,26,137,27],[129,26,129,27],[133,26,133,27],[135,26,135,27],[134,26,134,27],[124,31,124,33],[106,12,106,19],[106,20,106,26],[124,26,124,27],[122,31,122,33],[123,26,123,27],[107,27,108,29],[98,21,99,23],[106,27,106,32],[118,29,118,30],[99,6,99,18],[98,30,99,32],[118,31,118,33],[105,4,105,32],[104,4,104,32],[121,31,121,33],[111,6,114,33],[118,26,118,27],[120,29,120,30],[122,1,122,25],[124,1,124,25],[107,21,108,23],[107,24,108,26],[119,29,119,30],[72,0,72,33],[71,0,71,33],[79,12,79,19],[79,4,79,11],[97,27,97,32],[76,4,76,32],[73,0,73,8],[77,4,77,32],[88,20,88,26],[96,4,96,32],[86,4,86,32],[97,20,97,26],[89,27,90,29],[97,4,97,11],[119,1,119,25],[120,1,120,25],[103,4,103,32],[106,4,106,11],[78,4,78,32],[79,27,79,32],[98,24,99,26],[87,4,87,32],[85,4,85,32],[81,6,81,18],[89,30,90,32],[88,27,88,32],[107,30,108,32],[79,20,79,26],[120,31,120,33],[119,26,119,27],[108,6,108,18],[119,31,119,33],[89,21,90,23],[89,24,90,26],[34,0,34,2],[48,9,48,20],[27,4,27,14],[26,4,26,14],[26,0,27,2],[44,26,44,27],[47,0,47,20],[44,1,44,25],[45,1,45,25],[46,1,46,25],[34,6,34,14],[36,0,36,33],[40,1,40,25],[45,26,45,27],[42,1,42,25],[42,29,42,30],[42,31,42,33],[70,0,70,33],[69,0,69,33],[57,0,57,33],[64,6,67,33],[63,8,63,22],[59,0,59,33],[60,0,60,33],[61,0,61,2],[49,0,49,19],[51,0,51,20],[50,0,50,25],[50,26,50,30],[50,31,50,33],[54,13,54,15],[53,0,53,2],[51,29,51,33],[52,0,52,33],[53,4,53,17],[53,21,53,32],[54,6,54,8],[54,9,54,11],[49,26,49,30],[49,31,49,33],[28,4,28,14],[28,26,28,27],[26,18,26,25],[11,18,11,22],[13,23,13,32],[18,18,18,33],[27,17,27,33],[28,0,28,2],[10,0,10,2],[13,0,13,2],[20,4,20,14],[16,4,17,14],[12,4,12,14],[12,18,12,22],[10,4,10,14],[11,4,11,14],[26,26,26,27],[22,1,22,2],[0,0,0,33],[4,0,4,9],[22,4,22,14],[21,18,22,33],[12,0,12,2],[16,30,16,33],[11,0,11,2],[16,18,16,23],[17,18,17,33],[13,4,13,14],[1,10,4,33],[16,26,16,28],[18,0,18,16],[7,4,7,14],[6,4,6,15],[9,0,9,16],[88,12,88,19],[80,24,81,26],[80,27,81,29],[98,27,99,29],[61,4,61,25],[62,0,62,33],[41,29,41,30],[41,1,41,25],[1,0,3,9],[10,23,10,32],[11,23,11,32],[12,23,12,32],[6,18,6,24],[7,18,8,33],[6,25,6,32],[13,17,13,22],[9,17,9,33],[10,18,10,22],[20,26,20,27],[40,31,40,33],[24,0,24,16],[24,17,24,33],[31,0,31,33],[32,0,32,32],[145,26,145,28],[143,26,143,28],[142,26,142,27],[146,26,146,28],[144,26,144,28],[146,29,146,33],[142,31,142,33],[140,29,140,30],[133,29,133,30],[137,29,137,30],[138,31,138,33],[139,31,139,33],[139,29,139,30],[137,31,137,33],[138,29,138,30],[140,31,140,33],[136,29,136,30],[133,31,133,33],[134,31,134,33],[135,29,135,30],[134,29,134,30],[135,31,135,33],[136,31,136,33],[130,31,130,33],[128,26,128,27],[129,29,129,30],[126,31,126,33],[127,26,127,27],[143,29,143,33],[141,31,141,33],[142,29,142,30],[141,29,141,30],[131,29,131,30],[127,31,127,33],[128,29,128,30],[128,31,128,33],[129,31,129,33],[132,31,132,33],[127,29,127,30],[132,29,132,30],[130,29,130,30],[131,31,131,33],[126,29,126,30],[122,29,122,30],[124,29,124,30],[45,29,45,30],[46,29,46,30],[121,29,121,30],[123,31,123,33],[125,31,125,33],[125,26,125,27],[126,26,126,27],[123,29,123,30],[125,29,125,30],[46,31,46,33],[46,26,46,27],[55,0,55,33],[48,31,48,33],[48,26,48,30],[97,12,97,19],[90,6,90,18],[95,4,95,32],[94,4,94,32],[88,4,88,11],[80,21,81,23],[80,30,81,32],[51,26,51,28],[15,0,15,16],[15,17,15,33],[28,18,28,25],[42,26,42,27],[40,26,40,27],[41,31,41,33],[33,0,33,33],[23,0,23,16],[20,0,20,2],[21,4,21,14],[17,0,17,2],[39,0,39,33],[43,29,43,30],[43,31,43,33],[43,26,43,27],[43,1,43,25],[41,26,41,27],[44,31,44,33],[45,31,45,33],[44,29,44,30],[38,0,38,33],[40,29,40,30],[34,21,34,32]]}
["Veuillez remplir ce formulaire directement sur votre ordinateur afin de bénéficier des calculs automatiques et des liens web."]
[null,null,null,null,null,null,null,null,null,null,"REMBOURSEMENT DE FRAIS\npour les membres du personnel, les personnes externes,\nle paiement de factures de voyages et de réceptions et autres frais"]
[]
[]
["Division des Finances"]
[]
["Personne de contact :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N° de téléphone :",null,null,null,null,null,null,96369]
["Adresse courrier (géographique) :",null,null,null,"Ecole de physique - DPNC"]
[]
["Bénéficiaire de la prestation :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prestations :"]
["Nom et prénom :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Destination :"]
["Fonction :"]
["Adresse privée :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Motif :"]
[]
[]
["Si remboursement au bénéficiaire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pour les voyages"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dates de la manifestation :",null,null,null,null,null,null,"du",null,null,null,"au"]
["Nom de la banque ou CCP :"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nombre de jours du déplacement effectués à titre non professionnel * :"]
[]
["Adresse :"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"* lorsque le déplacement nécessite des nuitées, au maximum, le jour précédant la manifestation et celui suivant la manifestation peuvent être pris en considération.\n"]
["N° IBAN :"]
[]
["Si paiement au fournisseur",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pour les repas ou les réceptions"]
[]
["Nom et adresse :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nombre de personnes internes :"]
[]
["N° de facture :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nombre de personnes externes :"]
[]
[]
["J'atteste du bien-fondé de la dépense, de sa conformité aux règles de l'Université et que les frais dont le remboursement est sollicité ne sont pas"]
["pris en charge, même partiellement, par un tiers."]
[]
["Signature du bénéficiaire ou de l'organisateur :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date : "]
[]
[" Lien: en cas d'absence de justificatif de change, les taux se trouvent sur www.Oanda.com . Chaque dépense doit être justifiée par un document original"]
[]
["Justificatifs de la demande de remboursement remis pour déplacements, voyages ou autres frais"]
[]
["N° ","LIBELLE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Indiquer montant initial",null,"devise","Taux change",null,"Montant \nen CHF"]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHF",1,null,{"$f":"AA42*AD42","v":0},null,null,"CHF"]
[{"$f":"A42+1","v":2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHF",1,null,0,null,null,"Euro"]
[{"$f":"A43+1","v":3},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHF",1,null,0,null,null,"USD"]
[{"$f":"A44+1","v":4},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHF",1,null,0,null,null,"GBP"]
[{"$f":"A45+1","v":5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHF",1,null,0,null,null,"JPY"]
[{"$f":"A46+1","v":6},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHF",1,null,0,null,null,"CAD"]
["*si vous avez plus de justificatifs prière de vous rendre en 3ème page -> les calculs sont automatiques",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AUD"]
["En cas d'écart de conformité avec la ",null,null,null,"procédure 0083",null,null,null,null,"le contresignataire doit obligatoirement ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total des dépenses *",null,null,null,null,{"$f":"SUM(AF42:AH47)+SUM(AF120:AH143)","v":0}]
["signer l'annexe : \"Justification des écarts de conformité\" (p.2) et les expliquer .",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Avances reçues"]
[null,null,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(AF51>0,\"à rembourser\",\"somme à restituer\")","v":"somme à restituer"},{"$f":"IF(AF50=0,\"en ordre\", IF(AF50>0,\"à rembourser\",\"à restituer par le titulaire\"))","v":"en ordre"},{"$f":"IF(AG50=0,\"en ordre\", IF(AG50>0,\"à rembourser\",\"à restituer par le titulaire\"))","v":"en ordre"},{"$f":"IF(AH50=0,\"en ordre\", IF(AH50>0,\"à rembourser\",\"à restituer par le titulaire\"))","v":"en ordre"},{"$f":"IF(AA50=0,\"en ordre\", IF(AA50>0,\"à rembourser\",\"à restituer par le titulaire\"))","v":"à rembourser"},{"$f":"AF49-AF50","v":0}]
["Contresignataire :"]
[]
["Nom et prénom :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fonction :"]
[]
["J'atteste ne pas avoir pris part à la manifestation et être le supérieur hiérarchique direct au sens de la directive : "]
[]
["0069 : Signature d'un contrat ou d'un accord au nom de l'Université"]
[]
["Explication lorsque le contresignataire n'est pas le supérieur hiérarchique direct."]
[]
["Date et contresignature :"]
[]
[null,null,null,null,null,null,null,null,"ETIQUETTE COMPTABLE SOUS LE TRAIT SVP"]
[null,null,null,null,null,null,{"$f":"K2","v":"REMBOURSEMENT DE FRAIS\npour les membres du personnel, les personnes externes,\nle paiement de factures de voyages et de réceptions et autres frais"}]
[]
[]
[]
[]
["Le bénéficiaire doit signaler tout écart de conformité aux normes de remboursement à son contresignataire."]
["Le contresignataire doit valider spécifiquement par sa signature les écarts de conformité."]
["Si les écarts de conformité ne sont pas spécifiquement validés par le contresignataire, la comptabilité corrige la demande"]
["de remboursement à concurrence du montant conforme ou, dans le cas d'un dépassement de délai et de manque de justificatif,"]
["la retourne au titulaire de fonds."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ou"]
["Ecart 1"]
["Libellé de l'écart:"]
["Justification:"]
[]
[]
[]
["Date et contresignature:"]
[]
[]
["Ecart 2"]
["Libellé de l'écart:"]
["Justification:"]
[]
[]
[]
["Date et contresignature:"]
[]
[]
["Ecart 3"]
["Libellé de l'écart:"]
["Justification:"]
[]
[]
[]
["Date et contresignature:"]
[]
[]
["Ecart 4"]
["Libellé de l'écart:"]
["Justification:"]
[]
[]
[]
["Date et contresignature:"]
[]
[]
[null,null,null,null,null,null,{"$f":"K2","v":"REMBOURSEMENT DE FRAIS\npour les membres du personnel, les personnes externes,\nle paiement de factures de voyages et de réceptions et autres frais"}]
[]
[]
[]
[]
["Complément de justificatifs",null,null,null,null,null,null,null,null,null,null,null,null,"ou"]
[]
["N° ","LIBELLE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Indiquer montant initial",null,"devise","Taux change",null,"Montant en CHF"]
[{"$f":"A47+1","v":7},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHF",1,null,{"$f":"AA120*AD120","v":0}]
[{"$f":"A120+1","v":8},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHF",1,null,{"$f":"AA121*AD121","v":0}]
[{"$f":"A121+1","v":9},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHF",1,null,0]
[{"$f":"A122+1","v":10},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHF",1,null,0]
[11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHF",1,null,0]
[12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHF",1,null,0]
[13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHF",1,null,0]
[14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHF",1,null,0]
[15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHF",1,null,0]
[16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHF",1,null,0]
[17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHF",1,null,{"$f":"AA130*AD130","v":0}]
[18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHF",1,null,{"$f":"AA131*AD131","v":0}]
[19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHF",1,null,0]
[20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHF",1,null,0]
[21,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHF",1,null,0]
[22,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHF",1,null,0]
[23,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHF",1,null,{"$f":"AA136*AD136","v":0}]
[24,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHF",1,null,0]
[25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHF",1,null,0]
[26,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHF",1,null,0]
[27,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHF",1,null,0]
[28,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHF",1,null,0]
[29,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHF",1,null,0]
[30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHF",1,null,0]