{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Note de frais"],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Note de frais","index":0,"n_rows":14,"n_cols":14,"rows_kept":14,"merged":[[0,1,0,5],[2,3,2,5],[2,6,2,7],[2,8,2,10],[4,3,4,5],[4,6,4,7],[4,8,4,10]]}
[null,"Note de frais de déplacement"]
[]
[null,"Nom","Marie Berthelette","Autorisé par",null,null,"David Beaulieu",null,"Indemnités au kilomètre",null,null,{"v":0.32,"d":"0.32 €"}]
[]
[null,"Service","Ventes","Date d’envoi",null,null,{"$f":"TODAY()","v":"2018-05-10"},null,"Remboursement total dû",null,null,{"$f":"RemboursementTotalDû","v":{"v":550.3846011865525,"d":"550.38 €"}}]
[]
[null,"Période",{"$f":"IF(MIN(B10:B13)=MAX(B10:B13),TEXT(MIN(B10:B13),\"j/m/aa\"),\"Du \"&TEXT(MIN(B10:B13),\"j/m/aa\")&\" au \"&TEXT(MAX(B10:B13),\"j/m/aa\"))","v":"Du 10/4/18 au 15/4/18"}]
[]
[null,"Date","Description des frais","Billets d’avion","Logement","Transport \nterrestre \n(carburant, véhicule de location, taxi)","Repas et pourboires","Conférences et séminaires","Kilométrage","Indemnités kilométriques","Divers","Taux de change","Devise","Total"]
[null,{"$f":"TODAY()-30","v":"2018-04-10"},"Déplacement sur le lieu de travail du client",{"v":350,"d":"350.00"},{"v":150,"d":"150.00"},{"v":45,"d":"45.00"},{"v":12,"d":"12.00"},{"v":50,"d":"50.00"},{"v":35,"d":"35.00"},{"$f":"IF('Note de frais'!I10<>\"\",'Note de frais'!I10*IndemnitésKilométriques,\"\")","v":{"v":11.200000000000001,"d":"11.20"}},null,{"v":1.517,"d":"1.52"},"CAD",{"$f":"IFERROR(IF(OR('Note de frais'!$L10=\"\",'Note de frais'!$L10=1),SUM('Note de frais'!$J10:$K10,'Note de frais'!$D10:$H10)*1,SUM('Note de frais'!$J10:$K10,'Note de frais'!$D10:$H10)/'Note de frais'!$L10),\"\")","v":{"v":407.5148319050759,"d":"407.51 €"}}]
[null,{"$f":"TODAY()-30","v":"2018-04-10"},"Déjeuner avec le client",{"$nulls":3},{"v":24.3,"d":"24.30"},null,{"v":12,"d":"12.00"},{"$f":"IF('Note de frais'!I11<>\"\",'Note de frais'!I11*IndemnitésKilométriques,\"\")","v":3.84},null,{"v":1.517,"d":"1.52"},"CAD",{"$f":"IFERROR(IF(OR('Note de frais'!$L11=\"\",'Note de frais'!$L11=1),SUM('Note de frais'!$J11:$K11,'Note de frais'!$D11:$H11)*1,SUM('Note de frais'!$J11:$K11,'Note de frais'!$D11:$H11)/'Note de frais'!$L11),\"\")","v":{"v":18.5497692814766,"d":"18.55 €"}}]
[null,"2018-04-10","Séminaire de l’après-midi",{"$nulls":4},{"v":100,"d":"100.00"},{"v":6,"d":"6.00"},{"$f":"IF('Note de frais'!I12<>\"\",'Note de frais'!I12*IndemnitésKilométriques,\"\")","v":1.92},null,{"v":1,"d":"1.00"},"EUR",{"$f":"IFERROR(IF(OR('Note de frais'!$L12=\"\",'Note de frais'!$L12=1),SUM('Note de frais'!$J12:$K12,'Note de frais'!$D12:$H12)*1,SUM('Note de frais'!$J12:$K12,'Note de frais'!$D12:$H12)/'Note de frais'!$L12),\"\")","v":{"v":101.92,"d":"101.92 €"}}]
[null,{"$f":"TODAY()-25","v":"2018-04-15"},"Trajet vers l’aéroport",{"$nulls":5},{"v":70,"d":"70.00"},{"$f":"IF('Note de frais'!I13<>\"\",'Note de frais'!I13*IndemnitésKilométriques,\"\")","v":{"v":22.400000000000002,"d":"22.40"}},null,{"v":1,"d":"1.00"},"EUR",{"$f":"IFERROR(IF(OR('Note de frais'!$L13=\"\",'Note de frais'!$L13=1),SUM('Note de frais'!$J13:$K13,'Note de frais'!$D13:$H13)*1,SUM('Note de frais'!$J13:$K13,'Note de frais'!$D13:$H13)/'Note de frais'!$L13),\"\")","v":{"v":22.400000000000002,"d":"22.40 €"}}]
[null,"Total",null,{"$f":"SUBTOTAL(109,Frais[Billets d’avion])","v":{"v":350,"d":"350.00"}},{"$f":"SUBTOTAL(109,Frais[Logement])","v":{"v":150,"d":"150.00"}},{"$f":"SUBTOTAL(109,Frais[Transport \nterrestre \n(carburant, véhicule de location, taxi)])","v":{"v":45,"d":"45.00"}},{"$f":"SUBTOTAL(109,Frais[Repas et pourboires])","v":{"v":36.3,"d":"36.30"}},{"$f":"SUBTOTAL(109,Frais[Conférences et séminaires])","v":{"v":150,"d":"150.00"}},{"$f":"SUBTOTAL(109,Frais[Kilométrage])","v":{"v":123,"d":"123.00"}},{"$f":"SUBTOTAL(109,Frais[Indemnités kilométriques])","v":39.36},{"$nulls":3},{"$f":"SUBTOTAL(109,Frais[Total])","v":{"v":550.3846011865525,"d":"550.38 €"}}]