{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Information générale","Barème IK et IGD","Note de Frais de fonctionnement","Frais refacturables client"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":0,"comments":2,"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":"Information générale","index":0,"n_rows":96,"n_cols":2,"rows_kept":96,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Données"]
["OUI","AVION"]
["NON","CARBURANT"]
[null,"FOURNITURES DIVERSES"]
[null,"HOTEL"]
[null,"PARKING"]
[null,"PEAGE"]
[null,"RESTAURANT"]
[null,"TAXI"]
[null,"TRAIN"]
[null,"VOITURE LOCATION"]

{"sheet":"Barème IK et IGD","index":1,"n_rows":29,"n_cols":4,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,0,0,3],[22,2,22,3],[23,2,25,2],[23,3,25,3],[22,0,25,0],[22,1,25,1]]}
["BAREMES 2024"]
["VOITURE \n(applicable au 01/04/2022)","Kilométrage parcouru à titre professionnel"]
["Puissance fiscale","Jusqu’à 5 000 km","De 5 001 à 20 000 km","Au-delà de 20 000 km"]
["3 cv et moins","d x 0,529","(d x 0,316) + 1065","d x 0,37"]
["4 cv","d x 0,606","(d x 0,340) + 1330","d x 0,407"]
["5 cv","d x 0,636","(d x 0,357) + 1395","d x 0,427"]
["6 cv","d x 0,665","(d x 0,374) + 1457","d x 0,447"]
["7 cv et plus","d x 0,697","(d x 0,394) + 1515","d x 0,470"]
["Pour les véhicules électriques, le montant des frais de déplacement est majoré de 20 %."]
["MOTO","Kilométrage parcouru à titre professionnel"]
[null,"Jusqu’à 3 000 km","De 3 001 à 6 000 km","Au-delà de 6 000 km"]
["De 1 à 2 cv","d x 0,395","(d x 0,099) + 891","d x 0,248"]
["De 3 à 5 cv","d x 0,468","(d x 0,082) + 1 158","d x 0,275"]
["Plus de 5 cv","d x 0,606","(d x 0,079) + 1 583","d x 0,343"]
["d = distance parcourue à titre professionnel en km"]
[]
["Deux roues de cylindrée inférieure à 50 cm3 ","Kilométrage parcouru à titre professionnel"]
[null,"Jusqu’à 3 000 km","De 3 001 à 6 000 km","Au-delà de 6 000 km"]
[null,"d x 0,315","(d x 0,079) + 711","d x 0,198"]
["d = distance parcourue à titre professionnel en km"]
[]
[]
["IGD\n","Repas","Logement et petit déjeuner"]
[null,null,"Paris, Hauts-de-Seine (92), Seine-Saint-Denis (93) et Val-de-Marne (94)","Autres départements"]
[]
[]
["Pour les 3 premiers mois",20.7,74.3,55.1]
["Au-delà du 3e mois et jusqu’au 24e mois",17.600000000000001,63.2,46.8]
["Au-delà du 24e mois et jusqu’au 72e mois",14.5,52,38.6]

{"sheet":"Note de Frais de fonctionnement","index":2,"n_rows":76,"n_cols":13,"rows_kept":76,"cut":false,"hidden":false,"merged":[[10,0,11,0],[39,3,40,3],[17,2,18,2],[17,3,18,3],[25,3,26,3],[32,2,33,2],[32,3,33,3],[17,1,18,1],[17,0,18,0],[25,0,26,0],[25,1,26,1],[10,2,11,2],[10,3,11,3],[14,0,15,0],[14,1,15,1],[14,2,15,2],[42,6,42,10],[1,1,2,6],[0,1,0,6],[4,6,4,10],[10,1,11,1],[25,2,26,2],[37,6,37,9],[14,3,15,3],[34,3,36,3],[34,2,36,2],[53,0,53,2],[39,0,40,0],[47,0,48,0],[47,3,48,3],[39,2,40,2],[47,2,48,2],[39,1,40,1],[47,1,48,1],[32,0,33,0],[32,1,33,1],[34,0,36,0],[34,1,36,1],[34,4,36,4]]}
[null,"Note de Frais "]
[null,"Ce document permet de gérer l'aspect \"Notes de frais\" de manière mensuelle; \nAttention : les règles de l'urssaff étant très précises, il est impératif de ne pas faire d'erreur dans ce tableau et de fournir l'intégralité des justificatifs nécessaires (le mémo, les règles relatives aux déplacements, les commentaires dans les cellules sont là pour vous aider, mais en cas de doute, n'hesitez pas à me contacter)"]
[]
[]
["Informations générales",null,null,null,null,null,"Détails des déplacements",null,null,null,null,null,"AUTO"]
["NOM ",null,null,null,null,null,"Date","Adresse départ","Adresse arrivée","Motif déplacement","Nombre de km",null,"MOTO"]
["Prénom "]
["Date de démarrage de la mission"]
["Mois concerné"]
[]
["Tickets Restaurant et Repas","Montant","Justificatifs ","Montant pris en compte"]
[]
["Je veux bénéficier des TR  (O/N)"]
["Nombre de Tickets Restaurant "]
["Montant total repas (Midi - restaurant-Min 2 pers)",null,null,{"$f":"IF(C15=\"oui\",B15,0)","v":0}]
[]
[]
["Remboursements récurrents","Montant","Justificatifs ","Montant pris en compte"]
[]
["Montant abonnement internet",null,null,{"$f":"IF(C20=\"oui\",B20/2,0)","v":0}]
["Facture téléphone mobile ",null,null,{"$f":"IF(C21=\"oui\",B21/2,0)","v":0}]
["Forfait Mobilité durable",20,null,{"$f":"IF(C22=\"oui\",B22,0)","v":0}]
["Abonnement transport en  commun",null,null,{"$f":"IF(C23=\"oui\",B23*0.75,0)","v":0}]
[]
[]
["Frais divers (type de frais)","Montant","Justificatifs ","Montant pris en compte"]
[]
[null,null,null,{"$f":"IF(C28=\"oui\",B28,0)","v":0}]
[null,null,null,{"$f":"IF(C29=\"oui\",B29,0)","v":0}]
[null,null,null,0]
[]
[]
["Matériel Professionnel","Montant","Justificatifs ","Montant pris en compte"]
[]
[null,null,null,{"$f":"IF(C35=\"OUI\",IF(B35<=500, B35/2, B35/4),0)","v":0},{"$f":"IF(C35=\"OUI\",IF(B35<>\"\",IF(B35<500,\"remboursement immédiat de \"&B35/2&\" euros\",\"remboursement immédiat de \"&B35/4&\" euros, et remboursement de \"&B35/4&\"€ complementaire en \"&TEXT(DATE(YEAR($B9)+1,MONTH($B9),DAY($B9)),\"MM/AA\")),\"\"),\"\")","v":""}]
[]
[]
[null,null,null,null,null,null,"Nombre de kilomètres dans le mois",null,null,null,{"$f":"SUM(K7:K37)","v":0}]
[]
["Indémnités de déplacements",null,"Justificatifs ","Montant pris en compte"]
[]
["Puissance fiscale du véhicule "]
["type de vehicule (Auto/moto)",null,null,null,null,null,"Indemnités de Grand Déplacements (IGD)"]
["Barème de l'indemnité km",null,null,null,null,null,"Suivi IGD","Nuit Déplacement","Repas déplacement","Jours Travaillés","Télétravail"]
["Indemnités kilométriques ",null,null,{"$f":"IF(C42=\"OUI\",K38*B44,0)","v":0},null,null,1]
[null,null,null,null,null,null,2]
[null,null,null,null,null,null,3]
["Indémnités Grands Déplacements","Quantité",null,"Montant pris en compte",null,null,4]
[null,null,null,null,null,null,5]
["IGD logement : nombre de jours ",{"$f":"H76","v":0},null,{"$f":"B50*C50","v":0},null,null,6]
["IGD repas : nombre repas",{"$f":"I76","v":0},null,{"$f":"B51*C51","v":0},null,null,7]
[null,null,null,null,null,null,8]
[null,null,null,null,null,null,9]
["TOTAL",null,null,{"$f":"SUM(D15,D20:D23,D28:D31,D35:D38,D45,D50:D51)","v":0},null,null,10]
[null,null,null,null,null,null,11]
[null,null,null,null,null,null,12]
[null,null,null,null,null,null,13]
[null,null,null,null,null,null,14]
[null,null,null,null,null,null,15]
[null,null,null,null,null,null,16]
[null,null,null,null,null,null,17]
[null,null,null,null,null,null,18]
[null,null,null,null,null,null,19]
[null,null,null,null,null,null,20]
[null,null,null,null,null,null,21]
[null,null,null,null,null,null,22]
[null,null,null,null,null,null,23]
[null,null,null,null,null,null,24]
[null,null,null,null,null,null,25]
[null,null,null,null,null,null,26]
[null,null,null,null,null,null,27]
[null,null,null,null,null,null,28]
[null,null,null,null,null,null,29]
[null,null,null,null,null,null,30]
[null,null,null,null,null,null,31]
[null,null,null,null,null,null,null,{"$f":"SUM(H45:H75)","v":0},{"$f":"SUM(I45:I75)","v":0},{"$f":"SUM(J45:J75)","v":0},{"$f":"SUM(K45:K75)","v":0}]

{"sheet":"Frais refacturables client","index":3,"n_rows":36,"n_cols":12,"rows_kept":36,"cut":false,"hidden":false,"merged":[[35,0,35,3],[4,0,5,0],[6,7,6,11],[29,7,29,10],[0,2,0,7],[1,2,2,7],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4]]}
[null,null,"Note de Frais refacturables "]
[null,null,"N'indiquez ici que les frais refacturables à votre Client "]
[]
[]
["Date","Type de Frais","Montant","Justificatifs ","Montant pris en compte"]
[]
[null,null,null,null,{"$f":"IF(D7=\"oui\",C7,0)","v":0},null,null,"Détails des déplacements"]
[null,null,null,null,{"$f":"IF(D8=\"oui\",C8,0)","v":0},null,null,"Date","Adresse départ","Adresse arrivée","Motif déplacement","Nombre de km"]
[null,null,null,null,0]
[null,null,null,null,{"$f":"IF(D10=\"oui\",C10,0)","v":0}]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0,null,null,"Nombre de kilomètres dans le mois",null,null,null,{"$f":"SUM(L9:L29)","v":0}]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,"Indémnités de déplacement KM",null,null,{"$f":"L30*'Note de Frais de fonctionnement'!B44","v":0}]
["TOTAL",null,null,null,{"$f":"SUM(E7:E35)","v":0}]