{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Frais de déplacement"],"not_rendered":{"images":1,"defined_names":2,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Frais de déplacement","index":0,"n_rows":86,"n_cols":16,"rows_kept":86,"merged":[[1,1,2,2],[1,3,1,9],[3,1,3,9],[5,1,5,3],[5,8,5,9],[13,1,13,4],[13,7,14,9],[14,1,14,4],[16,1,16,2],[16,4,16,6],[17,1,17,2],[17,4,17,6],[18,1,18,2],[18,4,18,6],[19,1,19,2],[19,4,19,6],[20,1,20,2],[20,4,20,6],[21,1,21,2],[21,4,21,6],[22,1,22,2],[22,4,22,6],[23,1,23,2],[23,4,23,6],[24,1,24,2],[24,4,24,6],[25,1,25,2],[25,4,25,6],[26,1,26,2],[26,4,26,6],[27,1,27,2],[27,4,27,6],[28,1,28,2],[28,4,28,6],[29,1,29,2],[29,4,29,6],[30,1,30,2],[30,4,30,6],[31,1,31,2],[31,4,31,6],[32,1,32,2],[32,4,32,6],[33,1,33,2],[33,4,33,6],[34,1,34,2],[34,4,34,6],[35,1,35,2],[35,4,35,6],[36,1,36,2],[36,4,36,6],[37,1,37,2],[37,4,37,6],[38,1,38,2],[38,4,38,6],[39,1,39,2],[39,4,39,6],[42,4,42,6],[46,1,46,2],[46,3,46,6],[46,7,46,9],[48,3,48,5],[50,3,51,9],[53,3,53,6],[62,1,62,9],[65,0,65,10]]}
[]
[{"$nulls":3},"COMITE DE HANDBALL DES DEUX-SEVRES"]
[]
[null,"FEUILLE DE FRAIS DE DEPLACEMENTS\nPOUR LES BENEVOLES"]
[]
[null,"Bénéficiaire :",{"$nulls":6},"date"]
[]
[null,"Nom :"]
[{"$nulls":8},"llll"]
[null,"Prénom : "]
[]
[null,"Fonction :",{"$nulls":9}," "]
[]
[null,"Taux de remboursement de l'association :",{"$nulls":3},0.33,"€/Km","* Pensez à mettre à jour le barème. Pour retrouver le barème en vigueur sur le site associations.gouv.fr"]
[null,"7 CV et plus",{"$nulls":3},{"$f":"_xlfn.SWITCH(B15,\"3 CV et moins\",0.529,\"4 CV\",0.606,\"5 CV\",0.636,\"6 CV\",0.665,\"7 CV et plus\",0.697,\"Remboursement tarif Comité\",0.33)","v":0.697},"€/Km*"]
[{"$nulls":8},"Cliquez ici"]
[null,"Date",null,"Lieu","Objet du déplacement ",null,null,"Autres Frais","kms A/R","Total"]
[{"$nulls":9},{"$f":"(I18*$F$15)+H18","v":{"v":0,"d":"0.00 €"}},null,null,{"$f":"IF(J18<>0,J18,\"\")","v":""},null,"Barème fiscal jusqu'à 5000 kms"]
[{"$nulls":9},{"$f":"(I19*$F$15)+H19","v":{"v":0,"d":"0.00 €"}},null,null,{"$f":"IF(J19<>0,J19,\"\")","v":""},null,"3 CV et moins",{"v":0.529,"d":"0.529 €"}]
[{"$nulls":9},{"$f":"(I20*$F$15)+H20","v":{"v":0,"d":"0.00 €"}},null,null,"",null,"4 CV",{"v":0.606,"d":"0.606 €"}]
[{"$nulls":9},{"v":0,"d":"0.00 €"},null,null,"",null,"5 CV",{"v":0.636,"d":"0.636 €"}]
[{"$nulls":9},{"v":0,"d":"0.00 €"},null,null,"",null,"6 CV",{"v":0.665,"d":"0.665 €"}]
[{"$nulls":9},{"v":0,"d":"0.00 €"},null,null,"",null,"7 CV et plus",{"v":0.697,"d":"0.697 €"}]
[{"$nulls":9},{"v":0,"d":"0.00 €"},null,null,"",null,"Remboursement tarif Comité",{"v":0.33,"d":"0.330 €"}]
[{"$nulls":9},{"v":0,"d":"0.00 €"},null,null,""]
[{"$nulls":9},{"v":0,"d":"0.00 €"},null,null,"",null,"Pour les véhicules électriques, le montant des frais de déplacement est majoré de 20 %"]
[{"$nulls":9},{"v":0,"d":"0.00 €"},null,null,""]
[{"$nulls":9},{"v":0,"d":"0.00 €"},null,null,""]
[{"$nulls":9},{"v":0,"d":"0.00 €"},null,null,""]
[{"$nulls":9},{"v":0,"d":"0.00 €"},null,null,""]
[{"$nulls":9},{"v":0,"d":"0.00 €"},null,null,""]
[{"$nulls":9},{"v":0,"d":"0.00 €"},null,null,""]
[{"$nulls":9},{"v":0,"d":"0.00 €"},null,null,""]
[{"$nulls":9},{"v":0,"d":"0.00 €"},null,null,""]
[{"$nulls":9},{"v":0,"d":"0.00 €"},null,null,""]
[{"$nulls":9},{"v":0,"d":"0.00 €"},null,null,""]
[{"$nulls":9},{"v":0,"d":"0.00 €"},null,null,""]
[{"$nulls":9},{"v":0,"d":"0.00 €"},null,null,""]
[{"$nulls":9},{"v":0,"d":"0.00 €"},null,null,""]
[{"$nulls":9},{"$f":"(I40*$F$15)+H40","v":{"v":0,"d":"0.00 €"}},null,null,""]
[{"$nulls":12},{"$f":"SUM(M18:M40)","v":0}]
[null,"Règlement par :"]
[{"$nulls":3},"CHEQUE","N° ",{"$nulls":3},"Total",{"$f":"SUM(J18:J40)","v":{"v":0,"d":"0.00 €"}}]
[]
[{"$nulls":3},"VIREMENT BANCAIRE"]
[]
[null,"Je, soussigné(e)",null,{"$f":"D8&\" \"&D10","v":" "},{"$nulls":3},", certifie l'exactitude des renseignements ci-dessus."]
[]
[{"$nulls":3},"Je demande le règlement de la somme de            ",null,null,{"$f":"J43","v":{"v":0,"d":"0.00 €"}}]
[]
[{"$nulls":3},"Je renonce au remboursement de mes frais ci-dessus et les laisse à l'association en tant que don.\nA ce titre, je demande que l'association me fournisse le \"reçu au titre des dons à certains organismes d'intérêt général\" (Code cerfa n° 11580*03) afin de pouvoir bénéficier et justifier d'une réduction d'impôts*. "]
[]
[{"$nulls":3},"Le don que je fais à l'association s'élève donc à **",{"$nulls":3},{"$f":"(SUM(I18:I40)*F15)+SUM(H18:H40)","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":3},"La réduction fiscale dont je bénéficierais s'élèvera à ***",{"$nulls":3},{"$f":"H53*0.66","v":{"v":0,"d":"0.00 €"}}]
[]
[null,"Date et Signature du bénéficiaire :",{"$nulls":5},"Signature du responsable de l'association :"]
[]
[]
[]
[]
[]
[]
[null,"*     Je ne peux bénéficier de cet avantage fiscal qu'au titre de mon engagement bénévole. \n**   Le don que je fais à l'association est calculé sur la base du nombre de kilomètres multiplié par le barême fiscal en vigueur. \n*** La réduction dont je peux bénéficier s'élève à 66 % du don dans la limite de 20% de mon Revenu Imposable"]
[]
[]
[{"$f":"\"Note de Frais \"&D12&\" : REPARTITION PAR COMMISSION\"","v":"Note de Frais  : REPARTITION PAR COMMISSION"}]
[]
[{"$nulls":6},"Arbitrage ",{"$f":"IF(SUMIF($L$18:$M$40,G68,$M$18:$M$40)<>0,SUMIF($L$18:$M$40,G68,$M$18:$M$40),\"\")","v":""}]
[{"$nulls":6},"Bureau ",{"$f":"IF(SUMIF($L$18:$M$40,G69,$M$18:$M$40)<>0,SUMIF($L$18:$M$40,G69,$M$18:$M$40),\"\")","v":""}]
[{"$nulls":6},"C.A. ",""]
[{"$nulls":6},"Communication ",""]
[{"$nulls":6},"CPER ",""]
[{"$nulls":6},"DEF ",""]
[{"$nulls":6},"Developpement ",""]
[{"$nulls":6},"Discipline ",""]
[{"$nulls":6},"Divers ",""]
[{"$nulls":6},"Equipement ",""]
[{"$nulls":6},"Finances et Emplois ",""]
[{"$nulls":6},"Formation ",""]
[{"$nulls":6},"Minihand ",""]
[{"$nulls":6},"Obligation ",""]
[{"$nulls":6},"Réclamation et litiges ",""]
[{"$nulls":6},"Sportive ",""]
[{"$nulls":6},"Statuts et règlements ",""]
[{"$nulls":6},"Technique ",""]
[{"$nulls":7},{"$f":"SUM(H68:H85)","v":{"v":0,"d":"0.00 €"}}]