{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Accueil","cfonb","prélèvements","A prélever","Message","Transactions","Mandats","Mandat","Facture","Traduction"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":54,"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":"Accueil","index":0,"n_rows":129,"n_cols":8,"rows_kept":129,"cut":false,"hidden":false,"merged":[[23,7,33,13]]}
[]
[null,{"$f":"Traduction!A2","v":"Vos informations bancaires utilisées pour le fichier banque et sur le mandat"}]
[]
[null,"Creditor Name","fournisseur",{"$f":"Traduction!$A$3","v":" (pas d'accent, uniquement les caractères autorisés)"}]
[null,"ICS","FR00ZZZ123456"]
[null,"IBAN","FR7 63006610 04100010 57380116"]
[null,"BIC","BNPAFRPPXXX"]
[]
[null,{"$f":"Traduction!$A$4","v":"Liste des mandats"},{"$f":"Traduction!A5","v":"Vous indiquez pour chaque client une RUM ainsi que les informations bancaires"},null,null,null,null,{"$f":"Traduction!A60","v":"Caractères autorisés"}]
[null,null,{"$f":"Traduction!A6","v":"RUM : référence Unique de mandat"},null,null,null,null,"a b c d e f g h i j k l m n o p q r s t u v w x y z "]
[null,null,{"$f":"Traduction!A7","v":"Pas d'espace ou de tiret dans l'IBAN"},null,null,null,null,"A B C D E F G H I J K L M N O P Q R S T U V W X Y Z "]
[null,null,{"$f":"Traduction!A8","v":"8 ou 11 caractères dans le BIC"},null,null,null,null,"0 1 2 3 4 5 6 7 8 9 "]
[null,null,{"$f":"Traduction!A9","v":"la date doit être valide"},null,null,null,null,"/ - ? : ( ) . , \" +  Espace/Space"]
[null,null,{"$f":"Traduction!A10","v":"Le nom du client doit respecter les caractères autorisés"}]
[null,{"$f":"Traduction!A12","v":"Un mandat"},{"$f":"Traduction!A13","v":"On récupère les informations d'un mandat pour en faire un document imprimable"}]
[null,null,{"$f":"Traduction!A14","v":"ce document une fois personnalisé permettra d'être présenté au "}]
[null,null,{"$f":"Traduction!A15","v":"client pour sa signature"}]
[null,{"$f":"Traduction!$A$16","v":"Fichiers CFONB"},{"$f":"Traduction!$A$17","v":"Importer des données d'un fichier cfonb pour créer une liste de paiements"}]
[]
[]
[]
[null,{"$f":"Traduction!$A$18","v":"Liste des paiements"},"Vous indiquez pour chaque paiement les informations suivantes"]
[null,{"$f":"Traduction!A19","v":"Colonne A"},"Sequence Type",{"$f":"Traduction!A30","v":"une valeur parmis RCUR/FRST/OOF/FNAL"}]
[null,{"$f":"Traduction!A20","v":"Colonne B"},"Id prélèvement",{"$f":"Traduction!A31","v":"valeur unique pour chaque prélèvement"},null,null,null,{"$f":"Traduction!A61","v":"1.11.    Format des montants \n ...\n     -    5 décimales maximum après le point \n     -   La longueur maximale d'un montant est de 18 caractères (séparateur de décimale compris) \n     -   Le nombre de décimales doit être compatible avec la norme ISO 4217 relative aux devises. \nPour les montants d'une longueur supérieure à 14 caractères, le client devra impérativement vérifier auprès de sa banque s'ils peuvent être traités."}]
[null,{"$f":"Traduction!A21","v":"Colonne C"},"Currency",{"$f":"Traduction!A32","v":"uniquement EUR"}]
[null,{"$f":"Traduction!A22","v":"Colonne D"},"Montant",{"$f":"Traduction!A33","v":"valeur sur moins de 18 caractères, 5 décimales maxi"}]
[]
[null,false,"nb cars maxi",{"$f":"IF(B28,18,14)","v":14},null,null,"Err sequence Monnaie <> EUR non valide RUM valide"]
[null,{"$f":"Traduction!A25","v":"Colonne E"},"RUM",{"$f":"Traduction!A36","v":"RUM telle que dans la liste des Mandats"}]
[null,{"$f":"Traduction!A26","v":"Colonne F"},{"$f":"Traduction!A28","v":"Infos complémentaires"},{"$f":"Traduction!A37","v":"Texte sur le relevé du client"}]
[null,{"$f":"Traduction!A27","v":"à partir de la colonne H"},{"$f":"Traduction!A29","v":"colonnes supplémentaires pour faire des factures"}]
[]
[]
[]
[]
[]
[null,{"$f":"Traduction!A39","v":"Une fois la liste des paiements complète, vous appuyez sur vérifier sur la feuille prélèvements."}]
[null,null,{"$f":"Traduction!A40","v":"s'il y a des erreurs, elles sont indiquées dans la colonne OK"}]
[null,null,{"$f":"Traduction!A41","v":"Sinon les feuilles sont masquées et on passe à la création des fichiers XML"}]
[]
[null,{"$f":"Traduction!A43","v":"Entête fichier XML"},{"$f":"Traduction!A42","v":"Information du mappage XML des entêtes"}]
[null,null,{"$f":"Traduction!A44","v":"3 infos sont utiles pour chaque liste"}]
[null,null,{"$f":"Traduction!A45","v":"titre"},{"$f":"Traduction!A49","v":"Sert d'identifiant de base"}]
[null,null,{"$f":"Traduction!A46","v":"+ Sequence Type"},{"$f":"Traduction!A50","v":"une valeur parmis RCUR/FRST/OOF/FNAL"}]
[null,null,{"$f":"Traduction!A47","v":"Date prélèvement"},{"$f":"Traduction!A51","v":"Date prévue"}]
[null,null,{"$f":"Traduction!A48","v":"Les autres infos sont soit fixes soit automatiques"}]
[]
[null,{"$f":"Traduction!A52","v":"Transactions"},{"$f":"Traduction!$A$59","v":"Information du mappage XML des prélèvements"}]
[null,null,{"$f":"Traduction!A53","v":"C'est une combinaison des informations des paiements et des mandats"}]
[]
[null,{"$f":"Traduction!A54","v":"Facture"},{"$f":"Traduction!A55","v":"A partir d'une liste de transactions, il est possible d'établir une liste de factures"}]
[null,null,{"$f":"Traduction!A56","v":"suivant un modèle que vous pouvez personnaliser"}]
[null,null,{"$f":"Traduction!A57","v":"Vous pourrez l'utiliser pour faire les factures au format pdf en une seule opération."}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"Traduction!$A$105","v":"Pour pouvoir utiliser ce document, vous devez activer les macros"}]
[]
[]
[]
[]
[null,"Accueil","$A$100","ici"]

{"sheet":"cfonb","index":1,"n_rows":2,"n_cols":20,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["init","type opération","id débiteur","NNE","B=Référence","Débiteur","banque","xxx","guichet","Compte","D=Montant","F=Libellé","Etablissement","texte 07","IBAN","E=RUM calculée","A=Sequence Type","C=Currency",null,"Accueil"]
["06","85",null,"654321",null,"Nom debiteur",null,null,"00804","00011199988",1,"RUMRUMR2MRUMRUMRUMRUMRUMRUMRUMR","30004","endtoend2","FR7630004008040001119998882","Iban non trouvé","FRST","EUR"]

{"sheet":"prélèvements","index":2,"n_rows":70,"n_cols":16,"rows_kept":70,"cut":false,"hidden":false,"merged":[]}
[{"$f":"OFFSET(Traduction!$A$110,COLUMN()-1,0)","v":"Sequence Type"},{"$f":"OFFSET(Traduction!$A$110,COLUMN()-1,0)","v":"Id prélèvement"},{"$f":"OFFSET(Traduction!$A$110,COLUMN()-1,0)","v":"Currency"},{"$f":"OFFSET(Traduction!$A$110,COLUMN()-1,0)","v":"Montant"},{"$f":"OFFSET(Traduction!$A$110,COLUMN()-1,0)","v":"RUM"},{"$f":"OFFSET(Traduction!$A$110,COLUMN()-1,0)","v":"Infos complémentaires"},{"$f":"OFFSET(Traduction!$A$110,COLUMN()-1,0)","v":"ok"},{"$f":"OFFSET(Traduction!$A$110,COLUMN()-1,0)","v":"numéro de facture"},{"$f":"OFFSET(Traduction!$A$110,COLUMN()-1,0)","v":"référence"},{"$f":"OFFSET(Traduction!$A$110,COLUMN()-1,0)","v":"libellé"},null,null,null,null,null,{"$f":"Traduction!$A$140","v":"Accueil"}]
["RCUR","P008","EUR",123,"R001","Facture F201401-008 janvier 2014",null,{"$f":"LEFT(F2,19)","v":"Facture F201401-008"}," janvier 2015","Abonnement service xxxx"]
["RCUR","P009","EUR",96.98,"R002","Facture F201401-009 janvier 2014",null,{"$f":"LEFT(F3,19)","v":"Facture F201401-009"}," janvier 2015","Abonnement service xxxx"]
["RCUR","P010","EUR",865.3900000000001,"R003","Facture F201401-010 janvier 2014",null,"Facture F201401-010"," janvier 2015","Abonnement service xxxx"]
["RCUR","P011","EUR",{"$f":"39.15/3","v":13.049999999999999},"R004","Facture F201401-011 janvier 2014",null,"Facture F201401-011"," janvier 2015","Abonnement service xxxx"]
["RCUR","P012","EUR",11.68,"R005","Facture F201401-012 janvier 2014",null,"Facture F201401-012"," janvier 2015","Abonnement service xxxx"]
["RCUR","P013","EUR",54.365450000000003,"R006","Facture F201401-013 janvier 2014",null,"Facture F201401-013"," janvier 2015","Abonnement service xxxx"]
["RCUR","P014","EUR",165.18,"R007","Facture F201401-014 janvier 2014",null,"Facture F201401-014"," janvier 2015","Abonnement service xxxx"]
["RCUR","P015","EUR",456,"R008","Facture F201401-015 janvier 2014",null,"Facture F201401-015"," janvier 2015","Abonnement service xxxx"]
["RCUR","P016","EUR",210.9787,"R009","Facture F201401-016 janvier 2014",null,"Facture F201401-016"," janvier 2015","Abonnement service xxxx"]
["RCUR","P017","EUR",769.32365000000004,"R010","Facture F201401-017 janvier 2014",null,"Facture F201401-017"," janvier 2015","Abonnement service xxxx"]
["RCUR","P018","EUR",462.22356000000002,"R011","Facture F201401-018 janvier 2014",null,"Facture F201401-018"," janvier 2015","Abonnement service xxxx"]
["RCUR","P019","EUR",792.61,"R012","Facture F201401-019 janvier 2014",null,"Facture F201401-019"," janvier 2015","Abonnement service xxxx"]
["RCUR","P020","EUR",61.410000000000004,"R013","Facture F201401-020 janvier 2014",null,"Facture F201401-020"," janvier 2015","Abonnement service xxxx"]
["RCUR","P021","EUR",49.86,"R014","Facture F201401-021 janvier 2014",null,"Facture F201401-021"," janvier 2015","Abonnement service xxxx"]
["RCUR","P022","EUR",181.07,"R015","Facture F201401-022 janvier 2014",null,"Facture F201401-022"," janvier 2015","Abonnement service xxxx"]
["RCUR","P023","EUR",60.79,"R016","Facture F201401-023 janvier 2014",null,"Facture F201401-023"," janvier 2015","Abonnement service xxxx"]
["RCUR","P024","EUR",129.54999999999998,"R017","Facture F201401-024 janvier 2014",null,"Facture F201401-024"," janvier 2015","Abonnement service xxxx"]
["RCUR","P025","EUR",127.17,"R018","Facture F201401-025 janvier 2014",null,"Facture F201401-025"," janvier 2015","Abonnement service xxxx"]
["RCUR","P026","EUR",246.18,"R019","Facture F201401-026 janvier 2014",null,"Facture F201401-026"," janvier 2015","Abonnement service xxxx"]
["RCUR","P027","EUR",365,"R020","Facture F201401-027 janvier 2014",null,"Facture F201401-027"," janvier 2015","Abonnement service xxxx"]
["RCUR","P028","EUR",30.5,"R021","Facture F201401-028 janvier 2014",null,"Facture F201401-028"," janvier 2015","Abonnement service xxxx"]
["RCUR","P029","EUR",50.510000000000005,"R022","Facture F201401-029 janvier 2014",null,"Facture F201401-029"," janvier 2015","Abonnement service xxxx"]
["RCUR","P030","EUR",375.1,"R023","Facture F201401-030 janvier 2014",null,"Facture F201401-030"," janvier 2015","Abonnement service xxxx"]
["RCUR","P031","EUR",100.61999999999999,"R001","Facture F201401-031 janvier 2014",null,"Facture F201401-031"," janvier 2015","Abonnement service xxxx"]
["RCUR","P032","EUR",605.80999999999995,"R002","Facture F201401-032 janvier 2014",null,"Facture F201401-032"," janvier 2015","Abonnement service xxxx"]
["RCUR","P033","EUR",64.81,"R003","Facture F201401-033 janvier 2014",null,"Facture F201401-033"," janvier 2015","Abonnement service xxxx"]
["RCUR","P034","EUR",37.119999999999997,"R004","Facture F201401-034 janvier 2014",null,"Facture F201401-034"," janvier 2015","Abonnement service xxxx"]
["RCUR","P035","EUR",10.19,"R005","Facture F201401-035 janvier 2014",null,"Facture F201401-035"," janvier 2015","Abonnement service xxxx"]
["RCUR","P036","EUR",11.370000000000001,"R006","Facture F201401-036 janvier 2014",null,"Facture F201401-036"," janvier 2015","Abonnement service xxxx"]
["RCUR","P037","EUR",607.04999999999995,"R007","Facture F201401-037 janvier 2014",null,"Facture F201401-037"," janvier 2015","Abonnement service xxxx"]
["RCUR","P038","EUR",14.56,"R008","Facture F201401-038 janvier 2014",null,"Facture F201401-038"," janvier 2015","Abonnement service xxxx"]
["RCUR","P039","EUR",6.85,"R009","Facture F201401-039 janvier 2014",null,"Facture F201401-039"," janvier 2015","Abonnement service xxxx"]
["FRST","P040","EUR",17.29,"R010","Facture F201401-040 janvier 2014",null,"Facture F201401-040"," janvier 2015","Abonnement service xxxx"]
["FRST","P041","EUR",9.7199999999999989,"R011","Facture F201401-041 janvier 2014",null,"Facture F201401-041"," janvier 2015","Abonnement service xxxx"]
["FRST","P042","EUR",0.99,"R012","Facture F201401-042 janvier 2014",null,"Facture F201401-042"," janvier 2015","Abonnement service xxxx"]
["FRST","P043","EUR",4.8099999999999996,"R013","Facture F201401-043 janvier 2014",null,"Facture F201401-043"," janvier 2015","Abonnement service xxxx"]
["FRST","P044","EUR",26.519999999999996,"R014","Facture F201401-044 janvier 2014",null,"Facture F201401-044"," janvier 2015","Abonnement service xxxx"]
["FRST","P045","EUR",1.61,"R015","Facture F201401-045 janvier 2014",null,"Facture F201401-045"," janvier 2015","Abonnement service xxxx"]
["FRST","P046","EUR",0.67,"R016","Facture F201401-046 janvier 2014",null,"Facture F201401-046"," janvier 2015","Abonnement service xxxx"]
["FRST","P047","EUR",1.73,"R017","Facture F201401-047 janvier 2014",null,"Facture F201401-047"," janvier 2015","Abonnement service xxxx"]
["FRST","P048","EUR",8.370000000000001,"R018","Facture F201401-048 janvier 2014",null,"Facture F201401-048"," janvier 2015","Abonnement service xxxx"]
["FRST","P049","EUR",2.9099999999999997,"R019","Facture F201401-049 janvier 2014",null,"Facture F201401-049"," janvier 2015","Abonnement service xxxx"]
["FRST","P050","EUR",431.42,"R020","Facture F201401-050 janvier 2014",null,"Facture F201401-050"," janvier 2015","Abonnement service xxxx"]
["FRST","P051","EUR",398.94000000000005,"R021","Facture F201401-051 janvier 2014",null,"Facture F201401-051"," janvier 2015","Abonnement service xxxx"]
["FRST","P052","EUR",106.89999999999999,"R022","Facture F201401-052 janvier 2014",null,"Facture F201401-052"," janvier 2015","Abonnement service xxxx"]
["RCUR","P053","EUR",79.39,"R023","Facture F201401-053 janvier 2014",null,"Facture F201401-053"," janvier 2015","Abonnement service xxxx"]
["RCUR","P054","EUR",284.08999999999997,"R001","Facture F201401-054 janvier 2014",null,"Facture F201401-054"," janvier 2015","Abonnement service xxxx"]
["RCUR","P055","EUR",42.300000000000004,"R002","Facture F201401-055 janvier 2014",null,"Facture F201401-055"," janvier 2015","Abonnement service xxxx"]
["RCUR","P056","EUR",94.169999999999987,"R003","Facture F201401-056 janvier 2014",null,"Facture F201401-056"," janvier 2015","Abonnement service xxxx"]
["OOFF","P057","EUR",19.899999999999999,"R004","Facture F201401-057 janvier 2014",null,"Facture F201401-057"," janvier 2015","Abonnement service xxxx"]
["OOFF","P058","EUR",92.97,"R005","Facture F201401-058 janvier 2014",null,"Facture F201401-058"," janvier 2015","Abonnement service xxxx"]
["OOFF","P059","EUR",462.22,"R006","Facture F201401-059 janvier 2014",null,"Facture F201401-059"," janvier 2015","Abonnement service xxxx"]
["OOFF","P060","EUR",39.410000000000004,"R007","Facture F201401-060 janvier 2014",null,"Facture F201401-060"," janvier 2015","Abonnement service xxxx"]
["OOFF","P061","EUR",160.26,"R008","Facture F201401-061 janvier 2014",null,"Facture F201401-061"," janvier 2015","Abonnement service xxxx"]
["OOFF","P062","EUR",85.57,"R009","Facture F201401-062 janvier 2014",null,"Facture F201401-062"," janvier 2015","Abonnement service xxxx"]
["OOFF","P063","EUR",267.51,"R010","Facture F201401-063 janvier 2014",null,"Facture F201401-063"," janvier 2015","Abonnement service xxxx"]
["OOFF","P064","EUR",87.97,"R011","Facture F201401-064 janvier 2014",null,"Facture F201401-064"," janvier 2015","Abonnement service xxxx"]
["RCUR","P065","EUR",12,"R012","Facture F201401-065 janvier 2014",null,"Facture F201401-065"," janvier 2015","Abonnement service xxxx"]
["RCUR","P066","EUR",96.98,"R013","Facture F201401-066 janvier 2014",null,"Facture F201401-066"," janvier 2015","Abonnement service xxxx"]
["RCUR","P067","EUR",865.3900000000001,"R014","Facture F201401-067 janvier 2014",null,"Facture F201401-067"," janvier 2015","Abonnement service xxxx"]
["OOFF","P068","EUR",{"$f":"39.15","v":39.15},"R015","Facture F201401-068 janvier 2014",null,"Facture F201401-068"," janvier 2015","Abonnement service xxxx"]
["RCUR","P069","EUR",11.68,"R016","Facture F201401-069 janvier 2014",null,"Facture F201401-069"," janvier 2015","Abonnement service xxxx"]
["RCUR","P070","EUR",54.365450000000003,"R017","Facture F201401-070 janvier 2014",null,"Facture F201401-070"," janvier 2015","Abonnement service xxxx"]
["RCUR","P071","EUR",165.98,"R018","Facture F201401-071 janvier 2014",null,"Facture F201401-071"," janvier 2015","Abonnement service xxxx"]
["RCUR","P072","EUR",8921.9500000000007,"R019","Facture F201401-072 janvier 2014",null,"Facture F201401-072"," janvier 2015","Abonnement service xxxx"]
["RCUR","P073","EUR",210.97,"R020","Facture F201401-073 janvier 2014",null,{"$f":"LEFT(F67,19)","v":"Facture F201401-073"}," janvier 2015","Abonnement service xxxx"]
["RCUR","P074","EUR",769.32365000000004,"R021","Facture F201401-074 janvier 2014",null,"Facture F201401-074"," janvier 2015","Abonnement service xxxx"]
["RCUR","P075","EUR",462.22356000000002,"R022","Facture F201401-075 janvier 2014",null,"Facture F201401-075"," janvier 2015","Abonnement service xxxx"]
["RCUR","P076","EUR",792.61,"R023","Facture F201401-076 janvier 2014",null,"Facture F201401-076"," janvier 2015","Abonnement service xxxx"]

{"sheet":"A prélever","index":3,"n_rows":70,"n_cols":24,"rows_kept":70,"cut":false,"hidden":true,"merged":[]}
[{"$f":"OFFSET(Traduction!$A$110,COLUMN()-1,0)","v":"Sequence Type"},{"$f":"OFFSET(Traduction!$A$110,COLUMN()-1,0)","v":"Id prélèvement"},{"$f":"OFFSET(Traduction!$A$110,COLUMN()-1,0)","v":"Currency"},{"$f":"OFFSET(Traduction!$A$110,COLUMN()-1,0)","v":"Montant"},{"$f":"OFFSET(Traduction!$A$110,COLUMN()-1,0)","v":"RUM"},{"$f":"OFFSET(Traduction!$A$110,COLUMN()-1,0)","v":"Infos complémentaires"},"ligne","Date accord prélèvement","IBAN","BIC","Client",null,{"$f":"$A$1","v":"Sequence Type"},{"$f":"$A$1","v":"Sequence Type"},null,{"$f":"B1","v":"Id prélèvement"},{"$f":"C1","v":"Currency"},{"$f":"D1","v":"Montant"},{"$f":"E1","v":"RUM"},{"$f":"H1","v":"Date accord prélèvement"},{"$f":"J1","v":"BIC"},{"$f":"K1","v":"Client"},{"$f":"I1","v":"IBAN"},{"$f":"F1","v":"Infos complémentaires"}]
["RCUR","P008","EUR",123,"R001","Facture F201401-008 janvier 2014",{"$f":"MATCH(E2,Mandats!A:A,0)","v":2},"2014-01-01","AL90208110080000001039531801","PSSTFRPPPAR","Rekall",null,"RCUR",{"$f":"Message!C8","v":"RCUR"},null,"P008","EUR",123,"R001","2014-01-01","PSSTFRPPPAR","Rekall","AL90208110080000001039531801","Facture F201401-008 janvier 2014"]
["RCUR","P009","EUR",96.98,"R002","Facture F201401-009 janvier 2014",{"$f":"MATCH(E3,Mandats!A:A,0)","v":3},"2014-01-01","AT131490022010010999","PSSTFRPPPAR","Le Developpement Industriel",null,"FRST",{"$f":"DCOUNTA(A:K,A1,krit1)","v":47},null,"P009","EUR",96.98,"R002","2014-01-01","PSSTFRPPPAR","Le Developpement Industriel","AT131490022010010999","Facture F201401-009 janvier 2014"]
["RCUR","P010","EUR",865.3900000000001,"R003","Facture F201401-010 janvier 2014",{"$f":"MATCH(E4,Mandats!A:A,0)","v":4},"2014-01-01","BE68844010370034","PSSTFRPPPAR","COGIP",null,"OOFF",null,null,"P010","EUR",865.3900000000001,"R003","2014-01-01","PSSTFRPPPAR","COGIP","BE68844010370034","Facture F201401-010 janvier 2014"]
["RCUR","P011","EUR",{"$f":"39.15/3","v":13.049999999999999},"R004","Facture F201401-011 janvier 2014",{"$f":"MATCH(E5,Mandats!A:A,0)","v":5},"2014-01-01","CZ4201000000195505030267","PSSTFRPPPAR","France Hebdo",null,null,null,null,"P011","EUR",13.049999999999999,"R004","2014-01-01","PSSTFRPPPAR","France Hebdo","CZ4201000000195505030267","Facture F201401-011 janvier 2014"]
["RCUR","P012","EUR",11.68,"R005","Facture F201401-012 janvier 2014",{"$f":"MATCH(E6,Mandats!A:A,0)","v":6},"2014-01-01","EE342200221034126658","PSSTFRPPPAR","Factory Mode",null,null,null,null,"P012","EUR",11.68,"R005","2014-01-01","PSSTFRPPPAR","Factory Mode","EE342200221034126658","Facture F201401-012 janvier 2014"]
["RCUR","P013","EUR",54.365450000000003,"R006","Facture F201401-013 janvier 2014",{"$f":"MATCH(E7,Mandats!A:A,0)","v":7},"2014-01-01","FI9814283500171141","PSSTFRPPPAR","Canapi",null,null,null,null,"P013","EUR",54.365450000000003,"R006","2014-01-01","PSSTFRPPPAR","Canapi","FI9814283500171141","Facture F201401-013 janvier 2014"]
["RCUR","P014","EUR",165.18,"R007","Facture F201401-014 janvier 2014",{"$f":"MATCH(E8,Mandats!A:A,0)","v":8},"2014-01-02","FR7630066100410001057380116","PSSTFRPPPAR","Santhe/Sienar Technologies",null,null,null,null,"P014","EUR",165.18,"R007","2014-01-02","PSSTFRPPPAR","Santhe/Sienar Technologies","FR7630066100410001057380116","Facture F201401-014 janvier 2014"]
["RCUR","P015","EUR",456,"R008","Facture F201401-015 janvier 2014",{"$f":"MATCH(E9,Mandats!A:A,0)","v":9},"2014-01-03","DE12500105170648489890","PSSTFRPPPAR","Rosserys  et  Wichcraft",null,null,null,null,"P015","EUR",456,"R008","2014-01-03","PSSTFRPPPAR","Rosserys  et  Wichcraft","DE12500105170648489890","Facture F201401-015 janvier 2014"]
["RCUR","P016","EUR",210.9787,"R009","Facture F201401-016 janvier 2014",{"$f":"MATCH(E10,Mandats!A:A,0)","v":10},"2014-01-04","HU29117080012054779400000000","PSSTFRPPPAR","Madone",null,null,null,null,"P016","EUR",210.9787,"R009","2014-01-04","PSSTFRPPPAR","Madone","HU29117080012054779400000000","Facture F201401-016 janvier 2014"]
["RCUR","P017","EUR",769.32365000000004,"R010","Facture F201401-017 janvier 2014",{"$f":"MATCH(E11,Mandats!A:A,0)","v":11},"2014-01-05","IE92BOFI90001710027952","PSSTFRPPPAR","Kiff",null,null,null,null,"P017","EUR",769.32365000000004,"R010","2014-01-05","PSSTFRPPPAR","Kiff","IE92BOFI90001710027952","Facture F201401-017 janvier 2014"]
["RCUR","P018","EUR",462.22356000000002,"R011","Facture F201401-018 janvier 2014",{"$f":"MATCH(E12,Mandats!A:A,0)","v":12},"2014-01-06","IT68D0300203280000400162854","PSSTFRPPPAR","Aaltra",null,null,null,null,"P018","EUR",462.22356000000002,"R011","2014-01-06","PSSTFRPPPAR","Aaltra","IT68D0300203280000400162854","Facture F201401-018 janvier 2014"]
["RCUR","P019","EUR",792.61,"R012","Facture F201401-019 janvier 2014",{"$f":"MATCH(E13,Mandats!A:A,0)","v":13},"2014-01-07","LI1008800000020176306","PSSTFRPPPAR","Geugene Industrie",null,null,null,null,"P019","EUR",792.61,"R012","2014-01-07","PSSTFRPPPAR","Geugene Industrie","LI1008800000020176306","Facture F201401-019 janvier 2014"]
["RCUR","P020","EUR",61.410000000000004,"R013","Facture F201401-020 janvier 2014",{"$f":"MATCH(E14,Mandats!A:A,0)","v":14},"2014-01-08","LU761111000872960000","PSSTFRPPPAR","6000 SUX",null,null,null,null,"P020","EUR",61.410000000000004,"R013","2014-01-08","PSSTFRPPPAR","6000 SUX","LU761111000872960000","Facture F201401-020 janvier 2014"]
["RCUR","P021","EUR",49.86,"R014","Facture F201401-021 janvier 2014",{"$f":"MATCH(E15,Mandats!A:A,0)","v":15},"2014-01-09","MT98MMEB44093000000009027293051","PSSTFRPPPAR","O.C.P.",null,null,null,null,"P021","EUR",49.86,"R014","2014-01-09","PSSTFRPPPAR","O.C.P.","MT98MMEB44093000000009027293051","Facture F201401-021 janvier 2014"]
["RCUR","P022","EUR",181.07,"R015","Facture F201401-022 janvier 2014",{"$f":"MATCH(E16,Mandats!A:A,0)","v":16},"2014-01-10","NL18ABNA0484869868","PSSTFRPPPAR","Groobad",null,null,null,null,"P022","EUR",181.07,"R015","2014-01-10","PSSTFRPPPAR","Groobad","NL18ABNA0484869868","Facture F201401-022 janvier 2014"]
["RCUR","P023","EUR",60.79,"R016","Facture F201401-023 janvier 2014",{"$f":"MATCH(E17,Mandats!A:A,0)","v":17},"2014-01-11","PL37109024020000000610000434","PSSTFRPPPAR","Somnolos",null,null,null,null,"P023","EUR",60.79,"R016","2014-01-11","PSSTFRPPPAR","Somnolos","PL37109024020000000610000434","Facture F201401-023 janvier 2014"]
["RCUR","P024","EUR",129.54999999999998,"R017","Facture F201401-024 janvier 2014",{"$f":"MATCH(E18,Mandats!A:A,0)","v":18},"2014-01-12","PT50003506830000000784311","PSSTFRPPPAR","Stay-Puft",null,null,null,null,"P024","EUR",129.54999999999998,"R017","2014-01-12","PSSTFRPPPAR","Stay-Puft","PT50003506830000000784311","Facture F201401-024 janvier 2014"]
["RCUR","P025","EUR",127.17,"R018","Facture F201401-025 janvier 2014",{"$f":"MATCH(E19,Mandats!A:A,0)","v":19},"2014-01-13","SE6412000000012170145230","PSSTFRPPPAR","Tricatel",null,null,null,null,"P025","EUR",127.17,"R018","2014-01-13","PSSTFRPPPAR","Tricatel","SE6412000000012170145230","Facture F201401-025 janvier 2014"]
["RCUR","P026","EUR",246.18,"R019","Facture F201401-026 janvier 2014",{"$f":"MATCH(E20,Mandats!A:A,0)","v":20},"2014-01-14","CH3908704016075473007","PSSTFRPPPAR","Radio Plus",null,null,null,null,"P026","EUR",246.18,"R019","2014-01-14","PSSTFRPPPAR","Radio Plus","CH3908704016075473007","Facture F201401-026 janvier 2014"]
["RCUR","P027","EUR",365,"R020","Facture F201401-027 janvier 2014",{"$f":"MATCH(E21,Mandats!A:A,0)","v":21},"2014-01-15","SK9311110000001057361004","PSSTFRPPPAR","Red Apple",null,null,null,null,"P027","EUR",365,"R020","2014-01-15","PSSTFRPPPAR","Red Apple","SK9311110000001057361004","Facture F201401-027 janvier 2014"]
["RCUR","P028","EUR",30.5,"R021","Facture F201401-028 janvier 2014",{"$f":"MATCH(E22,Mandats!A:A,0)","v":22},"2014-01-16","SI56031001001300933","PSSTFRPPPAR","Pyramid Transnational",null,null,null,null,"P028","EUR",30.5,"R021","2014-01-16","PSSTFRPPPAR","Pyramid Transnational","SI56031001001300933","Facture F201401-028 janvier 2014"]
["RCUR","P029","EUR",50.510000000000005,"R022","Facture F201401-029 janvier 2014",{"$f":"MATCH(E23,Mandats!A:A,0)","v":23},"2014-01-17","ES1020903200500041045040","PSSTFRPPPAR","HAL Labs",null,null,null,null,"P029","EUR",50.510000000000005,"R022","2014-01-17","PSSTFRPPPAR","HAL Labs","ES1020903200500041045040","Facture F201401-029 janvier 2014"]
["RCUR","P030","EUR",375.1,"R023","Facture F201401-030 janvier 2014",{"$f":"MATCH(E24,Mandats!A:A,0)","v":24},"2014-01-18","GB96MIDL40271522859882","PSSTFRPPPAR","Guide Duchemin",null,null,null,null,"P030","EUR",375.1,"R023","2014-01-18","PSSTFRPPPAR","Guide Duchemin","GB96MIDL40271522859882","Facture F201401-030 janvier 2014"]
["RCUR","P031","EUR",100.61999999999999,"R001","Facture F201401-031 janvier 2014",{"$f":"MATCH(E25,Mandats!A:A,0)","v":2},"2014-01-01","AL90208110080000001039531801","PSSTFRPPPAR","Rekall",null,null,null,null,"P031","EUR",100.61999999999999,"R001","2014-01-01","PSSTFRPPPAR","Rekall","AL90208110080000001039531801","Facture F201401-031 janvier 2014"]
["RCUR","P032","EUR",605.80999999999995,"R002","Facture F201401-032 janvier 2014",{"$f":"MATCH(E26,Mandats!A:A,0)","v":3},"2014-01-01","AT131490022010010999","PSSTFRPPPAR","Le Developpement Industriel",null,null,null,null,"P032","EUR",605.80999999999995,"R002","2014-01-01","PSSTFRPPPAR","Le Developpement Industriel","AT131490022010010999","Facture F201401-032 janvier 2014"]
["RCUR","P033","EUR",64.81,"R003","Facture F201401-033 janvier 2014",{"$f":"MATCH(E27,Mandats!A:A,0)","v":4},"2014-01-01","BE68844010370034","PSSTFRPPPAR","COGIP",null,null,null,null,"P033","EUR",64.81,"R003","2014-01-01","PSSTFRPPPAR","COGIP","BE68844010370034","Facture F201401-033 janvier 2014"]
["RCUR","P034","EUR",37.119999999999997,"R004","Facture F201401-034 janvier 2014",{"$f":"MATCH(E28,Mandats!A:A,0)","v":5},"2014-01-01","CZ4201000000195505030267","PSSTFRPPPAR","France Hebdo",null,null,null,null,"P034","EUR",37.119999999999997,"R004","2014-01-01","PSSTFRPPPAR","France Hebdo","CZ4201000000195505030267","Facture F201401-034 janvier 2014"]
["RCUR","P035","EUR",10.19,"R005","Facture F201401-035 janvier 2014",{"$f":"MATCH(E29,Mandats!A:A,0)","v":6},"2014-01-01","EE342200221034126658","PSSTFRPPPAR","Factory Mode",null,null,null,null,"P035","EUR",10.19,"R005","2014-01-01","PSSTFRPPPAR","Factory Mode","EE342200221034126658","Facture F201401-035 janvier 2014"]
["RCUR","P036","EUR",11.370000000000001,"R006","Facture F201401-036 janvier 2014",{"$f":"MATCH(E30,Mandats!A:A,0)","v":7},"2014-01-01","FI9814283500171141","PSSTFRPPPAR","Canapi",null,null,null,null,"P036","EUR",11.370000000000001,"R006","2014-01-01","PSSTFRPPPAR","Canapi","FI9814283500171141","Facture F201401-036 janvier 2014"]
["RCUR","P037","EUR",607.04999999999995,"R007","Facture F201401-037 janvier 2014",{"$f":"MATCH(E31,Mandats!A:A,0)","v":8},"2014-01-02","FR7630066100410001057380116","PSSTFRPPPAR","Santhe/Sienar Technologies",null,null,null,null,"P037","EUR",607.04999999999995,"R007","2014-01-02","PSSTFRPPPAR","Santhe/Sienar Technologies","FR7630066100410001057380116","Facture F201401-037 janvier 2014"]
["RCUR","P038","EUR",14.56,"R008","Facture F201401-038 janvier 2014",{"$f":"MATCH(E32,Mandats!A:A,0)","v":9},"2014-01-03","DE12500105170648489890","PSSTFRPPPAR","Rosserys  et  Wichcraft",null,null,null,null,"P038","EUR",14.56,"R008","2014-01-03","PSSTFRPPPAR","Rosserys  et  Wichcraft","DE12500105170648489890","Facture F201401-038 janvier 2014"]
["RCUR","P039","EUR",6.85,"R009","Facture F201401-039 janvier 2014",{"$f":"MATCH(E33,Mandats!A:A,0)","v":10},"2014-01-04","HU29117080012054779400000000","PSSTFRPPPAR","Madone",null,null,null,null,"P039","EUR",6.85,"R009","2014-01-04","PSSTFRPPPAR","Madone","HU29117080012054779400000000","Facture F201401-039 janvier 2014"]
["FRST","P040","EUR",17.29,"R010","Facture F201401-040 janvier 2014",{"$f":"MATCH(E34,Mandats!A:A,0)","v":11},"2014-01-05","IE92BOFI90001710027952","PSSTFRPPPAR","Kiff",null,null,null,null,"P053","EUR",79.39,"R023","2014-01-18","PSSTFRPPPAR","Guide Duchemin","GB96MIDL40271522859882","Facture F201401-053 janvier 2014"]
["FRST","P041","EUR",9.7199999999999989,"R011","Facture F201401-041 janvier 2014",{"$f":"MATCH(E35,Mandats!A:A,0)","v":12},"2014-01-06","IT68D0300203280000400162854","PSSTFRPPPAR","Aaltra",null,null,null,null,"P054","EUR",284.08999999999997,"R001","2014-01-01","PSSTFRPPPAR","Rekall","AL90208110080000001039531801","Facture F201401-054 janvier 2014"]
["FRST","P042","EUR",0.99,"R012","Facture F201401-042 janvier 2014",{"$f":"MATCH(E36,Mandats!A:A,0)","v":13},"2014-01-07","LI1008800000020176306","PSSTFRPPPAR","Geugene Industrie",null,null,null,null,"P055","EUR",42.300000000000004,"R002","2014-01-01","PSSTFRPPPAR","Le Developpement Industriel","AT131490022010010999","Facture F201401-055 janvier 2014"]
["FRST","P043","EUR",4.8099999999999996,"R013","Facture F201401-043 janvier 2014",{"$f":"MATCH(E37,Mandats!A:A,0)","v":14},"2014-01-08","LU761111000872960000","PSSTFRPPPAR","6000 SUX",null,null,null,null,"P056","EUR",94.169999999999987,"R003","2014-01-01","PSSTFRPPPAR","COGIP","BE68844010370034","Facture F201401-056 janvier 2014"]
["FRST","P044","EUR",26.519999999999996,"R014","Facture F201401-044 janvier 2014",{"$f":"MATCH(E38,Mandats!A:A,0)","v":15},"2014-01-09","MT98MMEB44093000000009027293051","PSSTFRPPPAR","O.C.P.",null,null,null,null,"P065","EUR",12,"R012","2014-01-07","PSSTFRPPPAR","Geugene Industrie","LI1008800000020176306","Facture F201401-065 janvier 2014"]
["FRST","P045","EUR",1.61,"R015","Facture F201401-045 janvier 2014",{"$f":"MATCH(E39,Mandats!A:A,0)","v":16},"2014-01-10","NL18ABNA0484869868","PSSTFRPPPAR","Groobad",null,null,null,null,"P066","EUR",96.98,"R013","2014-01-08","PSSTFRPPPAR","6000 SUX","LU761111000872960000","Facture F201401-066 janvier 2014"]
["FRST","P046","EUR",0.67,"R016","Facture F201401-046 janvier 2014",{"$f":"MATCH(E40,Mandats!A:A,0)","v":17},"2014-01-11","PL37109024020000000610000434","PSSTFRPPPAR","Somnolos",null,null,null,null,"P067","EUR",865.3900000000001,"R014","2014-01-09","PSSTFRPPPAR","O.C.P.","MT98MMEB44093000000009027293051","Facture F201401-067 janvier 2014"]
["FRST","P047","EUR",1.73,"R017","Facture F201401-047 janvier 2014",{"$f":"MATCH(E41,Mandats!A:A,0)","v":18},"2014-01-12","PT50003506830000000784311","PSSTFRPPPAR","Stay-Puft",null,null,null,null,"P069","EUR",11.68,"R016","2014-01-11","PSSTFRPPPAR","Somnolos","PL37109024020000000610000434","Facture F201401-069 janvier 2014"]
["FRST","P048","EUR",8.370000000000001,"R018","Facture F201401-048 janvier 2014",{"$f":"MATCH(E42,Mandats!A:A,0)","v":19},"2014-01-13","SE6412000000012170145230","PSSTFRPPPAR","Tricatel",null,null,null,null,"P070","EUR",54.365450000000003,"R017","2014-01-12","PSSTFRPPPAR","Stay-Puft","PT50003506830000000784311","Facture F201401-070 janvier 2014"]
["FRST","P049","EUR",2.9099999999999997,"R019","Facture F201401-049 janvier 2014",{"$f":"MATCH(E43,Mandats!A:A,0)","v":20},"2014-01-14","CH3908704016075473007","PSSTFRPPPAR","Radio Plus",null,null,null,null,"P071","EUR",165.98,"R018","2014-01-13","PSSTFRPPPAR","Tricatel","SE6412000000012170145230","Facture F201401-071 janvier 2014"]
["FRST","P050","EUR",431.42,"R020","Facture F201401-050 janvier 2014",{"$f":"MATCH(E44,Mandats!A:A,0)","v":21},"2014-01-15","SK9311110000001057361004","PSSTFRPPPAR","Red Apple",null,null,null,null,"P072","EUR",8921.9500000000007,"R019","2014-01-14","PSSTFRPPPAR","Radio Plus","CH3908704016075473007","Facture F201401-072 janvier 2014"]
["FRST","P051","EUR",398.94000000000005,"R021","Facture F201401-051 janvier 2014",{"$f":"MATCH(E45,Mandats!A:A,0)","v":22},"2014-01-16","SI56031001001300933","PSSTFRPPPAR","Pyramid Transnational",null,null,null,null,"P073","EUR",210.97,"R020","2014-01-15","PSSTFRPPPAR","Red Apple","SK9311110000001057361004","Facture F201401-073 janvier 2014"]
["FRST","P052","EUR",106.89999999999999,"R022","Facture F201401-052 janvier 2014",{"$f":"MATCH(E46,Mandats!A:A,0)","v":23},"2014-01-17","ES1020903200500041045040","PSSTFRPPPAR","HAL Labs",null,null,null,null,"P074","EUR",769.32365000000004,"R021","2014-01-16","PSSTFRPPPAR","Pyramid Transnational","SI56031001001300933","Facture F201401-074 janvier 2014"]
["RCUR","P053","EUR",79.39,"R023","Facture F201401-053 janvier 2014",{"$f":"MATCH(E47,Mandats!A:A,0)","v":24},"2014-01-18","GB96MIDL40271522859882","PSSTFRPPPAR","Guide Duchemin",null,null,null,null,"P075","EUR",462.22356000000002,"R022","2014-01-17","PSSTFRPPPAR","HAL Labs","ES1020903200500041045040","Facture F201401-075 janvier 2014"]
["RCUR","P054","EUR",284.08999999999997,"R001","Facture F201401-054 janvier 2014",{"$f":"MATCH(E48,Mandats!A:A,0)","v":2},"2014-01-01","AL90208110080000001039531801","PSSTFRPPPAR","Rekall",null,null,null,null,"P076","EUR",792.61,"R023","2014-01-18","PSSTFRPPPAR","Guide Duchemin","GB96MIDL40271522859882","Facture F201401-076 janvier 2014"]
["RCUR","P055","EUR",42.300000000000004,"R002","Facture F201401-055 janvier 2014",{"$f":"MATCH(E49,Mandats!A:A,0)","v":3},"2014-01-01","AT131490022010010999","PSSTFRPPPAR","Le Developpement Industriel"]
["RCUR","P056","EUR",94.169999999999987,"R003","Facture F201401-056 janvier 2014",{"$f":"MATCH(E50,Mandats!A:A,0)","v":4},"2014-01-01","BE68844010370034","PSSTFRPPPAR","COGIP"]
["OOFF","P057","EUR",19.899999999999999,"R004","Facture F201401-057 janvier 2014",{"$f":"MATCH(E51,Mandats!A:A,0)","v":5},"2014-01-01","CZ4201000000195505030267","PSSTFRPPPAR","France Hebdo"]
["OOFF","P058","EUR",92.97,"R005","Facture F201401-058 janvier 2014",{"$f":"MATCH(E52,Mandats!A:A,0)","v":6},"2014-01-01","EE342200221034126658","PSSTFRPPPAR","Factory Mode"]
["OOFF","P059","EUR",462.22,"R006","Facture F201401-059 janvier 2014",{"$f":"MATCH(E53,Mandats!A:A,0)","v":7},"2014-01-01","FI9814283500171141","PSSTFRPPPAR","Canapi"]
["OOFF","P060","EUR",39.410000000000004,"R007","Facture F201401-060 janvier 2014",{"$f":"MATCH(E54,Mandats!A:A,0)","v":8},"2014-01-02","FR7630066100410001057380116","PSSTFRPPPAR","Santhe/Sienar Technologies"]
["OOFF","P061","EUR",160.26,"R008","Facture F201401-061 janvier 2014",{"$f":"MATCH(E55,Mandats!A:A,0)","v":9},"2014-01-03","DE12500105170648489890","PSSTFRPPPAR","Rosserys  et  Wichcraft"]
["OOFF","P062","EUR",85.57,"R009","Facture F201401-062 janvier 2014",{"$f":"MATCH(E56,Mandats!A:A,0)","v":10},"2014-01-04","HU29117080012054779400000000","PSSTFRPPPAR","Madone"]
["OOFF","P063","EUR",267.51,"R010","Facture F201401-063 janvier 2014",{"$f":"MATCH(E57,Mandats!A:A,0)","v":11},"2014-01-05","IE92BOFI90001710027952","PSSTFRPPPAR","Kiff"]
["OOFF","P064","EUR",87.97,"R011","Facture F201401-064 janvier 2014",{"$f":"MATCH(E58,Mandats!A:A,0)","v":12},"2014-01-06","IT68D0300203280000400162854","PSSTFRPPPAR","Aaltra"]
["RCUR","P065","EUR",12,"R012","Facture F201401-065 janvier 2014",{"$f":"MATCH(E59,Mandats!A:A,0)","v":13},"2014-01-07","LI1008800000020176306","PSSTFRPPPAR","Geugene Industrie"]
["RCUR","P066","EUR",96.98,"R013","Facture F201401-066 janvier 2014",{"$f":"MATCH(E60,Mandats!A:A,0)","v":14},"2014-01-08","LU761111000872960000","PSSTFRPPPAR","6000 SUX"]
["RCUR","P067","EUR",865.3900000000001,"R014","Facture F201401-067 janvier 2014",{"$f":"MATCH(E61,Mandats!A:A,0)","v":15},"2014-01-09","MT98MMEB44093000000009027293051","PSSTFRPPPAR","O.C.P."]
["OOFF","P068","EUR",{"$f":"39.15","v":39.15},"R015","Facture F201401-068 janvier 2014",{"$f":"MATCH(E62,Mandats!A:A,0)","v":16},"2014-01-10","NL18ABNA0484869868","PSSTFRPPPAR","Groobad"]
["RCUR","P069","EUR",11.68,"R016","Facture F201401-069 janvier 2014",{"$f":"MATCH(E63,Mandats!A:A,0)","v":17},"2014-01-11","PL37109024020000000610000434","PSSTFRPPPAR","Somnolos"]
["RCUR","P070","EUR",54.365450000000003,"R017","Facture F201401-070 janvier 2014",{"$f":"MATCH(E64,Mandats!A:A,0)","v":18},"2014-01-12","PT50003506830000000784311","PSSTFRPPPAR","Stay-Puft"]
["RCUR","P071","EUR",165.98,"R018","Facture F201401-071 janvier 2014",{"$f":"MATCH(E65,Mandats!A:A,0)","v":19},"2014-01-13","SE6412000000012170145230","PSSTFRPPPAR","Tricatel"]
["RCUR","P072","EUR",8921.9500000000007,"R019","Facture F201401-072 janvier 2014",{"$f":"MATCH(E66,Mandats!A:A,0)","v":20},"2014-01-14","CH3908704016075473007","PSSTFRPPPAR","Radio Plus"]
["RCUR","P073","EUR",210.97,"R020","Facture F201401-073 janvier 2014",{"$f":"MATCH(E67,Mandats!A:A,0)","v":21},"2014-01-15","SK9311110000001057361004","PSSTFRPPPAR","Red Apple"]
["RCUR","P074","EUR",769.32365000000004,"R021","Facture F201401-074 janvier 2014",{"$f":"MATCH(E68,Mandats!A:A,0)","v":22},"2014-01-16","SI56031001001300933","PSSTFRPPPAR","Pyramid Transnational"]
["RCUR","P075","EUR",462.22356000000002,"R022","Facture F201401-075 janvier 2014",{"$f":"MATCH(E69,Mandats!A:A,0)","v":23},"2014-01-17","ES1020903200500041045040","PSSTFRPPPAR","HAL Labs"]
["RCUR","P076","EUR",792.61,"R023","Facture F201401-076 janvier 2014",{"$f":"MATCH(E70,Mandats!A:A,0)","v":24},"2014-01-18","GB96MIDL40271522859882","PSSTFRPPPAR","Guide Duchemin"]

{"sheet":"Message","index":4,"n_rows":42,"n_cols":9,"rows_kept":42,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Navigation"]
[null,null,"Accueil",null,null,null,"Activation licence"]
[null,null,"Transactions"]
[]
[null,{"$f":"Traduction!$A$139","v":"Titre"}]
[null,{"$f":"Traduction!$A$139","v":"Titre"},"Factures decembre"]
[null,"+ Sequence Type","RCUR",null,"Xpath = /Document/CstmrDrctDbtInitn/GrpHdr +"]
[null,{"$f":"Traduction!$A$138","v":"Date prélèvement"},"2024-01-24"]
[]
[null,"Message Group header"]
[null,"Message Identification:",{"$f":"C7&\" \"&sequence_type","v":"Factures decembre RCUR"},null,"/MsgId"]
[null,"Creation Date Time:",{"$f":"NOW()","v":"2024-01-24T10:50:47.750"},null,"/CreDtTm"]
[null,"Number Of Transactions:",{"$f":"COUNTA(tbTransactions[End To End Id])","v":47},null,"/NbOfTxs",null,"RCUR",{"$f":"SUMIF(prélèvements!A:A,G14,prélèvements!D:D)","v":20019.724020000001},{"$f":"COUNTIF(prélèvements!A:A,G14)","v":47}]
[null,"Control Sum:",{"$f":"SUM(tbTransactions[Instructed Amount])","v":20019.724020000001},null,"/CtrlSum",null,"FRST",{"$f":"SUMIF(prélèvements!A:A,G15,prélèvements!D:D)","v":1011.88},{"$f":"COUNTIF(prélèvements!A:A,G15)","v":13}]
[null,"Initiating Party Name",{"$f":"Accueil!C4","v":"fournisseur"},null,"/InitgPty/Nm",null,"OOFF",{"$f":"SUMIF(prélèvements!A:A,G16,prélèvements!D:D)","v":1254.96},{"$f":"COUNTIF(prélèvements!A:A,G16)","v":9}]
[null,null,null,null,null,null,"FNAL",{"$f":"SUMIF(prélèvements!A:A,G17,prélèvements!D:D)","v":0},{"$f":"COUNTIF(prélèvements!A:A,G17)","v":0}]
[null,null,null,true,null,null,"Total",{"$f":"SUM(H14:H17)","v":22286.564020000002},{"$f":"SUM(I14:I17)","v":69}]
[null,null,null,true]
[null,"Payment Information Header",null,true]
[null,null,null,{"$f":"AND(D18:D20)","v":true},"Xpath = /Document/CstmrDrctDbtInitn/PmtInf +"]
[null,"Payment Information Identification",{"$f":"Message!C12","v":"Factures decembre RCUR"},null,"/PmtInfId"]
[null,"Payment Method","DD",null,"/PmtMtd"]
[null,"Batch Booking","false",null,"/BtchBookg"]
[null,"Number Of Transactions",{"$f":"COUNTA(tbTransactions[End To End Id])","v":47},null,"/NbOfTxs"]
[null,"Control Sum",{"$f":"SUM(tbTransactions[Instructed Amount])","v":20019.724020000001},null,"/CtrlSum"]
[null,"Payment Type Information",null,null,""]
[null,"+ Service Level Code","SEPA","Sylvain http://sn1.chez-alice.fr","/PmtTpInf/SvcLvl/Cd"]
[null,"+ Local Instrument Code","CORE","Nicolas","/PmtTpInf/LclInstrm/Cd"]
[null,"+ Sequence Type",{"$f":"sequence_type","v":"RCUR"},"Sylvain NICOLAS","/PmtTpInf/SeqTp"]
[null,"Requested Collection Date",{"$f":"date_prelevement","v":"2024-01-24"},null,"/ReqdColltnDt"]
[null,"Creditor Name",{"$f":"C16","v":"fournisseur"},{"$f":"MIN(D33:D36)","v":4},"/Cdtr/Nm"]
[null,"Creditor Account Identification",{"$f":"SUBSTITUTE(Accueil!C6,\" \",\"\")","v":"FR7630066100410001057380116"},{"$f":"IF(D28=\"\",1,5)","v":5},"/CdtrAcct/Id/IBAN","IBAN"]
[null,"Creditor Agent Financial Institution Id",{"$f":"Accueil!C7","v":"BNPAFRPPXXX"},{"$f":"IF(D29=\"\",2,5)","v":5},"/CdtrAgt/FinInstnId/BIC","BIC"]
[null,"Charge Bearer","SLEV",{"$f":"IF(D30=\"\",3,5)","v":5},"/ChrgBr"]
[null,"Creditor Scheme Identification",null,{"$f":"IF(D31=\"\",4,5)","v":4},""]
[null,"+ Name",{"$f":"C16","v":"fournisseur"},null,"/CdtrSchmeId/Nm"]
[null,"+ Id",{"$f":"Accueil!C5","v":"FR00ZZZ123456"},null,"/CdtrSchmeId/Id/PrvtId/Othr/Id"]
[null,"+ Scheme Name Proprietary","SEPA",null,"/CdtrSchmeId/Id/PrvtId/Othr/SchmeNm/Prtry"]
[]
[]
[null,null,"Transactions"]

{"sheet":"Transactions","index":5,"n_rows":53,"n_cols":20,"rows_kept":53,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,{"$f":"Traduction!$A$132","v":"Feuille message"},null,null,null,null,{"$f":"Traduction!$A$133","v":"Informations supplémentaires : ajoutez les infos dans les feuilles mandats ou prélèvements puis mappez le fichier xml"}]
["Payment Direct Debit Transactions",null,null,null,null,null,{"$f":"Message!B14","v":"Number Of Transactions:"},{"$f":"Message!C14","v":47},null,{"$f":"Traduction!$A$134","v":"Aide en ligne"}]
[null,null,null,null,null,null,{"$f":"Message!B15","v":"Control Sum:"},{"$f":"Message!C15","v":20019.724020000001},null,"Mandats","Mandats","Mandats","Mandats","Mandats","Mandats","prélèvements","prélèvements","Pas de champ","Pas de champ","Pas de champ"]
["XPath = /Document/CstmrDrctDbtInitn/PmtInf +",null,null,null,null,null,null,null,"/DrctDbtTxInf/RmtInf/Ustrd","Société","Nom","prénom","adresse1","adresse2","cpville","numéro de facture","libellé"]
["/DrctDbtTxInf/PmtId/EndToEndId","/DrctDbtTxInf/InstdAmt/@Ccy","/DrctDbtTxInf/InstdAmt","/DrctDbtTxInf/DrctDbtTx/MndtRltdInf/MndtId","/DrctDbtTxInf/DrctDbtTx/MndtRltdInf/DtOfSgntr","/DrctDbtTxInf/DbtrAgt/FinInstnId/BIC","/DrctDbtTxInf/Dbtr/Nm","/DrctDbtTxInf/DbtrAcct/Id/IBAN",{"$f":"Traduction!$A$124","v":"Enlever les accents"},"Non","Non","Non","Non","Non","Non","Non","Non","Non","Non","Non"]
["End To End Id","Currency","Instructed Amount","Mandate Id","Date Of Signature","Financial Institution Id","Debtor Name","Debtor Account ID","Remittance Information","0","1","2","3","4","5","6","7","8","9","10"]
["P008","EUR",123,"R001","2014-01-01","PSSTFRPPPAR","Rekall","AL90208110080000001039531801","Facture F201401-008 janvier 2014","Rekall",null,null,null,null,null,"Facture F201401-008","Abonnement service xxxx"]
["P009","EUR",96.98,"R002","2014-01-01","PSSTFRPPPAR","Le Developpement Industriel","AT131490022010010999","Facture F201401-009 janvier 2014","Le Developpement Industriel",null,null,null,null,null,"Facture F201401-009","Abonnement service xxxx"]
["P010","EUR",865.3900000000001,"R003","2014-01-01","PSSTFRPPPAR","COGIP","BE68844010370034","Facture F201401-010 janvier 2014","COGIP",null,null,null,null,null,"Facture F201401-010","Abonnement service xxxx"]
["P011","EUR",13.049999999999999,"R004","2014-01-01","PSSTFRPPPAR","France Hebdo","CZ4201000000195505030267","Facture F201401-011 janvier 2014","France Hebdo",null,null,null,null,null,"Facture F201401-011","Abonnement service xxxx"]
["P012","EUR",11.68,"R005","2014-01-01","PSSTFRPPPAR","Factory Mode","EE342200221034126658","Facture F201401-012 janvier 2014","Factory Mode",null,null,null,null,null,"Facture F201401-012","Abonnement service xxxx"]
["P013","EUR",54.365450000000003,"R006","2014-01-01","PSSTFRPPPAR","Canapi","FI9814283500171141","Facture F201401-013 janvier 2014","Canapi",null,null,null,null,null,"Facture F201401-013","Abonnement service xxxx"]
["P014","EUR",165.18,"R007","2014-01-02","PSSTFRPPPAR","Santhe/Sienar Technologies","FR7630066100410001057380116","Facture F201401-014 janvier 2014","Santhe/Sienar Technologies",null,null,null,null,null,"Facture F201401-014","Abonnement service xxxx"]
["P015","EUR",456,"R008","2014-01-03","PSSTFRPPPAR","Rosserys  et  Wichcraft","DE12500105170648489890","Facture F201401-015 janvier 2014","Rosserys  et  Wichcraft",null,null,null,null,null,"Facture F201401-015","Abonnement service xxxx"]
["P016","EUR",210.9787,"R009","2014-01-04","PSSTFRPPPAR","Madone","HU29117080012054779400000000","Facture F201401-016 janvier 2014","Madone",null,null,null,null,null,"Facture F201401-016","Abonnement service xxxx"]
["P017","EUR",769.32365000000004,"R010","2014-01-05","PSSTFRPPPAR","Kiff","IE92BOFI90001710027952","Facture F201401-017 janvier 2014","Kiff",null,null,null,null,null,"Facture F201401-017","Abonnement service xxxx"]
["P018","EUR",462.22356000000002,"R011","2014-01-06","PSSTFRPPPAR","Aaltra","IT68D0300203280000400162854","Facture F201401-018 janvier 2014","Aaltra",null,null,null,null,null,"Facture F201401-018","Abonnement service xxxx"]
["P019","EUR",792.61,"R012","2014-01-07","PSSTFRPPPAR","Geugene Industrie","LI1008800000020176306","Facture F201401-019 janvier 2014","Geugene Industrie",null,null,null,null,null,"Facture F201401-019","Abonnement service xxxx"]
["P020","EUR",61.410000000000004,"R013","2014-01-08","PSSTFRPPPAR","6000 SUX","LU761111000872960000","Facture F201401-020 janvier 2014","6000 SUX",null,null,null,null,null,"Facture F201401-020","Abonnement service xxxx"]
["P021","EUR",49.86,"R014","2014-01-09","PSSTFRPPPAR","O.C.P.","MT98MMEB44093000000009027293051","Facture F201401-021 janvier 2014","O.C.P.",null,null,null,null,null,"Facture F201401-021","Abonnement service xxxx"]
["P022","EUR",181.07,"R015","2014-01-10","PSSTFRPPPAR","Groobad","NL18ABNA0484869868","Facture F201401-022 janvier 2014","Groobad",null,null,null,null,null,"Facture F201401-022","Abonnement service xxxx"]
["P023","EUR",60.79,"R016","2014-01-11","PSSTFRPPPAR","Somnolos","PL37109024020000000610000434","Facture F201401-023 janvier 2014","Somnolos",null,null,null,null,null,"Facture F201401-023","Abonnement service xxxx"]
["P024","EUR",129.54999999999998,"R017","2014-01-12","PSSTFRPPPAR","Stay-Puft","PT50003506830000000784311","Facture F201401-024 janvier 2014","Stay-Puft",null,null,null,null,null,"Facture F201401-024","Abonnement service xxxx"]
["P025","EUR",127.17,"R018","2014-01-13","PSSTFRPPPAR","Tricatel","SE6412000000012170145230","Facture F201401-025 janvier 2014","Tricatel",null,null,null,null,null,"Facture F201401-025","Abonnement service xxxx"]
["P026","EUR",246.18,"R019","2014-01-14","PSSTFRPPPAR","Radio Plus","CH3908704016075473007","Facture F201401-026 janvier 2014","Radio Plus",null,null,null,null,null,"Facture F201401-026","Abonnement service xxxx"]
["P027","EUR",365,"R020","2014-01-15","PSSTFRPPPAR","Red Apple","SK9311110000001057361004","Facture F201401-027 janvier 2014","Red Apple",null,null,null,null,null,"Facture F201401-027","Abonnement service xxxx"]
["P028","EUR",30.5,"R021","2014-01-16","PSSTFRPPPAR","Pyramid Transnational","SI56031001001300933","Facture F201401-028 janvier 2014","Pyramid Transnational",null,null,null,null,null,"Facture F201401-028","Abonnement service xxxx"]
["P029","EUR",50.510000000000005,"R022","2014-01-17","PSSTFRPPPAR","HAL Labs","ES1020903200500041045040","Facture F201401-029 janvier 2014","HAL Labs",null,null,null,null,null,"Facture F201401-029","Abonnement service xxxx"]
["P030","EUR",375.1,"R023","2014-01-18","PSSTFRPPPAR","Guide Duchemin","GB96MIDL40271522859882","Facture F201401-030 janvier 2014","Guide Duchemin","Duchemin","Louis","Rue Etienne Marcel",null,"75002 Paris","Facture F201401-030","Abonnement service xxxx"]
["P031","EUR",100.61999999999999,"R001","2014-01-01","PSSTFRPPPAR","Rekall","AL90208110080000001039531801","Facture F201401-031 janvier 2014","Rekall",null,null,null,null,null,"Facture F201401-031","Abonnement service xxxx"]
["P032","EUR",605.80999999999995,"R002","2014-01-01","PSSTFRPPPAR","Le Developpement Industriel","AT131490022010010999","Facture F201401-032 janvier 2014","Le Developpement Industriel",null,null,null,null,null,"Facture F201401-032","Abonnement service xxxx"]
["P033","EUR",64.81,"R003","2014-01-01","PSSTFRPPPAR","COGIP","BE68844010370034","Facture F201401-033 janvier 2014","COGIP",null,null,null,null,null,"Facture F201401-033","Abonnement service xxxx"]
["P034","EUR",37.119999999999997,"R004","2014-01-01","PSSTFRPPPAR","France Hebdo","CZ4201000000195505030267","Facture F201401-034 janvier 2014","France Hebdo",null,null,null,null,null,"Facture F201401-034","Abonnement service xxxx"]
["P035","EUR",10.19,"R005","2014-01-01","PSSTFRPPPAR","Factory Mode","EE342200221034126658","Facture F201401-035 janvier 2014","Factory Mode",null,null,null,null,null,"Facture F201401-035","Abonnement service xxxx"]
["P036","EUR",11.370000000000001,"R006","2014-01-01","PSSTFRPPPAR","Canapi","FI9814283500171141","Facture F201401-036 janvier 2014","Canapi",null,null,null,null,null,"Facture F201401-036","Abonnement service xxxx"]
["P037","EUR",607.04999999999995,"R007","2014-01-02","PSSTFRPPPAR","Santhe/Sienar Technologies","FR7630066100410001057380116","Facture F201401-037 janvier 2014","Santhe/Sienar Technologies",null,null,null,null,null,"Facture F201401-037","Abonnement service xxxx"]
["P038","EUR",14.56,"R008","2014-01-03","PSSTFRPPPAR","Rosserys  et  Wichcraft","DE12500105170648489890","Facture F201401-038 janvier 2014","Rosserys  et  Wichcraft",null,null,null,null,null,"Facture F201401-038","Abonnement service xxxx"]
["P039","EUR",6.85,"R009","2014-01-04","PSSTFRPPPAR","Madone","HU29117080012054779400000000","Facture F201401-039 janvier 2014","Madone",null,null,null,null,null,"Facture F201401-039","Abonnement service xxxx"]
["P053","EUR",79.39,"R023","2014-01-18","PSSTFRPPPAR","Guide Duchemin","GB96MIDL40271522859882","Facture F201401-053 janvier 2014","Guide Duchemin","Duchemin","Louis","Rue Etienne Marcel",null,"75002 Paris","Facture F201401-053","Abonnement service xxxx"]
["P054","EUR",284.08999999999997,"R001","2014-01-01","PSSTFRPPPAR","Rekall","AL90208110080000001039531801","Facture F201401-054 janvier 2014","Rekall",null,null,null,null,null,"Facture F201401-054","Abonnement service xxxx"]
["P055","EUR",42.300000000000004,"R002","2014-01-01","PSSTFRPPPAR","Le Developpement Industriel","AT131490022010010999","Facture F201401-055 janvier 2014","Le Developpement Industriel",null,null,null,null,null,"Facture F201401-055","Abonnement service xxxx"]
["P056","EUR",94.169999999999987,"R003","2014-01-01","PSSTFRPPPAR","COGIP","BE68844010370034","Facture F201401-056 janvier 2014","COGIP",null,null,null,null,null,"Facture F201401-056","Abonnement service xxxx"]
["P065","EUR",12,"R012","2014-01-07","PSSTFRPPPAR","Geugene Industrie","LI1008800000020176306","Facture F201401-065 janvier 2014","Geugene Industrie",null,null,null,null,null,"Facture F201401-065","Abonnement service xxxx"]
["P066","EUR",96.98,"R013","2014-01-08","PSSTFRPPPAR","6000 SUX","LU761111000872960000","Facture F201401-066 janvier 2014","6000 SUX",null,null,null,null,null,"Facture F201401-066","Abonnement service xxxx"]
["P067","EUR",865.3900000000001,"R014","2014-01-09","PSSTFRPPPAR","O.C.P.","MT98MMEB44093000000009027293051","Facture F201401-067 janvier 2014","O.C.P.",null,null,null,null,null,"Facture F201401-067","Abonnement service xxxx"]
["P069","EUR",11.68,"R016","2014-01-11","PSSTFRPPPAR","Somnolos","PL37109024020000000610000434","Facture F201401-069 janvier 2014","Somnolos",null,null,null,null,null,"Facture F201401-069","Abonnement service xxxx"]
["P070","EUR",54.365450000000003,"R017","2014-01-12","PSSTFRPPPAR","Stay-Puft","PT50003506830000000784311","Facture F201401-070 janvier 2014","Stay-Puft",null,null,null,null,null,"Facture F201401-070","Abonnement service xxxx"]
["P071","EUR",165.98,"R018","2014-01-13","PSSTFRPPPAR","Tricatel","SE6412000000012170145230","Facture F201401-071 janvier 2014","Tricatel",null,null,null,null,null,"Facture F201401-071","Abonnement service xxxx"]
["P072","EUR",8921.9500000000007,"R019","2014-01-14","PSSTFRPPPAR","Radio Plus","CH3908704016075473007","Facture F201401-072 janvier 2014","Radio Plus",null,null,null,null,null,"Facture F201401-072","Abonnement service xxxx"]
["P073","EUR",210.97,"R020","2014-01-15","PSSTFRPPPAR","Red Apple","SK9311110000001057361004","Facture F201401-073 janvier 2014","Red Apple",null,null,null,null,null,"Facture F201401-073","Abonnement service xxxx"]
["P074","EUR",769.32365000000004,"R021","2014-01-16","PSSTFRPPPAR","Pyramid Transnational","SI56031001001300933","Facture F201401-074 janvier 2014","Pyramid Transnational",null,null,null,null,null,"Facture F201401-074","Abonnement service xxxx"]
["P075","EUR",462.22356000000002,"R022","2014-01-17","PSSTFRPPPAR","HAL Labs","ES1020903200500041045040","Facture F201401-075 janvier 2014","HAL Labs",null,null,null,null,null,"Facture F201401-075","Abonnement service xxxx"]
["P076","EUR",792.61,"R023","2014-01-18","PSSTFRPPPAR","Guide Duchemin","GB96MIDL40271522859882","Facture F201401-076 janvier 2014","Guide Duchemin","Duchemin","Louis","Rue Etienne Marcel",null,"75002 Paris","Facture F201401-076","Abonnement service xxxx"]

{"sheet":"Mandats","index":6,"n_rows":24,"n_cols":15,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Traduction!A65","v":"RUM"},{"$f":"OFFSET(Traduction!$A$65,COLUMN()-1,0)","v":"Date accord prélèvement"},{"$f":"OFFSET(Traduction!B65,COLUMN()-1,0)","v":"IBAN"},{"$f":"OFFSET(Traduction!$A$65,COLUMN()-1,0)","v":"BIC"},{"$f":"OFFSET(Traduction!$A$65,COLUMN()-1,0)","v":"Client"},{"$f":"OFFSET(Traduction!$A$65,COLUMN()-1,0)","v":"ok"},{"$f":"OFFSET(Traduction!$A$65,COLUMN()-1,0)","v":"Type paiement"},{"$f":"OFFSET(Traduction!$A$65,COLUMN()-1,0)","v":"Société"},{"$f":"OFFSET(Traduction!$A$65,COLUMN()-1,0)","v":"Nom"},{"$f":"OFFSET(Traduction!$A$65,COLUMN()-1,0)","v":"prénom"},{"$f":"OFFSET(Traduction!$A$65,COLUMN()-1,0)","v":"adresse1"},{"$f":"OFFSET(Traduction!$A$65,COLUMN()-1,0)","v":"adresse2"},{"$f":"OFFSET(Traduction!$A$65,COLUMN()-1,0)","v":"cpville"},{"$f":"OFFSET(Traduction!$A$65,COLUMN()-1,0)","v":"autre"},{"$f":"Traduction!A80","v":"Accueil"}]
["R001","2014-01-01","AL90208110080000001039531801","PSSTFRPPPAR","Rekall",null,"Récurrent","Rekall"]
["R002","2014-01-01","AT131490022010010999","PSSTFRPPPAR","Le Developpement Industriel",null,"Récurrent","Le Developpement Industriel"]
["R003","2014-01-01","BE68844010370034","PSSTFRPPPAR","COGIP",null,"Ponctuel","COGIP"]
["R004","2014-01-01","CZ4201000000195505030267","PSSTFRPPPAR","France Hebdo",null,"Récurrent","France Hebdo"]
["R005","2014-01-01","EE342200221034126658","PSSTFRPPPAR","Factory Mode",null,"Ponctuel","Factory Mode"]
["R006","2014-01-01","FI9814283500171141","PSSTFRPPPAR","Canapi",null,"Récurrent","Canapi"]
["R007","2014-01-02","FR7630066100410001057380116","PSSTFRPPPAR","Santhe/Sienar Technologies",null,"Récurrent","Santhe/Sienar Technologies"]
["R008","2014-01-03","DE12500105170648489890","PSSTFRPPPAR","Rosserys  et  Wichcraft",null,"Récurrent","Rosserys  et  Wichcraft"]
["R009","2014-01-04","HU29117080012054779400000000","PSSTFRPPPAR","Madone",null,"Récurrent","Madone"]
["R010","2014-01-05","IE92BOFI90001710027952","PSSTFRPPPAR","Kiff",null,"Récurrent","Kiff"]
["R011","2014-01-06","IT68D0300203280000400162854","PSSTFRPPPAR","Aaltra",null,"Récurrent","Aaltra"]
["R012","2014-01-07","LI1008800000020176306","PSSTFRPPPAR","Geugene Industrie",null,"Récurrent","Geugene Industrie"]
["R013","2014-01-08","LU761111000872960000","PSSTFRPPPAR","6000 SUX",null,"Récurrent","6000 SUX"]
["R014","2014-01-09","MT98MMEB44093000000009027293051","PSSTFRPPPAR","O.C.P.",null,"Récurrent","O.C.P."]
["R015","2014-01-10","NL18ABNA0484869868","PSSTFRPPPAR","Groobad",null,"Récurrent","Groobad"]
["R016","2014-01-11","PL37109024020000000610000434","PSSTFRPPPAR","Somnolos",null,"Récurrent","Somnolos"]
["R017","2014-01-12","PT50003506830000000784311","PSSTFRPPPAR","Stay-Puft",null,"Ponctuel","Stay-Puft"]
["R018","2014-01-13","SE6412000000012170145230","PSSTFRPPPAR","Tricatel",null,"Récurrent","Tricatel"]
["R019","2014-01-14","CH3908704016075473007","PSSTFRPPPAR","Radio Plus",null,"Récurrent","Radio Plus"]
["R020","2014-01-15","SK9311110000001057361004","PSSTFRPPPAR","Red Apple",null,"Récurrent","Red Apple"]
["R021","2014-01-16","SI56031001001300933","PSSTFRPPPAR","Pyramid Transnational",null,"Récurrent","Pyramid Transnational"]
["R022","2014-01-17","ES1020903200500041045040","PSSTFRPPPAR","HAL Labs",null,"Récurrent","HAL Labs"]
["R023","2014-01-18","GB96MIDL40271522859882","PSSTFRPPPAR","Guide Duchemin",null,"Récurrent","Guide Duchemin","Duchemin","Louis","Rue Etienne Marcel",null,"75002 Paris","France"]

{"sheet":"Mandat","index":7,"n_rows":44,"n_cols":6,"rows_kept":44,"cut":false,"hidden":false,"merged":[[7,4,9,5],[35,4,37,5]]}
[null,{"$f":"Traduction!A90","v":"Mandat de prélèvement SEPA"},null,null,null,{"$f":"Traduction!$A$81","v":"Mandats"}]
[null,null,null,null,null,{"$f":"Traduction!$A$82","v":"ligne feuille mandats"}]
[null,{"$f":"Traduction!A89","v":"Référence unique de mandat (RUM)"},null,null,null,2]
[null,{"$f":"INDEX(Mandats!A:A,ligne)","v":"R001"},null,null,null,{"$f":"Traduction!$A$83","v":"Indiquez ici votre nom pour le texte"}]
[null,null,null,null,null,"XXXXXXXXX"]
[null,{"$f":"Traduction!A88&F5&\" à envoyer des instructions à votre banque pour débiter votre compte.\"","v":"En signant ce formulaire de mandat, vous autorisez XXXXXXXXX à envoyer des instructions à votre banque pour débiter votre compte."},null,null,null,{"$f":"Traduction!A85","v":"Nom pdf par défaut"}]
[null,{"$f":"Traduction!A87&F5","v":"Et vous autorisez votre banque à débiter votre compte conformément aux instructions de XXXXXXXXX"},null,null,null,{"$f":"\"Mandat \" &B4 & \" \"&INDEX(Mandats!E:E,ligne)","v":"Mandat R001 Rekall"}]
[null,{"$f":"Traduction!A86","v":"Vous bénéficiez du droit d'être remboursé par votre banque suivant les conditions décrites dans la convention que vous avez passée avec elle. Une demande de remboursement doit être présentée dans les 8 semaines suivant la date de débit de votre compte pour un prélèvement autorisé."},null,null,{"$f":"Traduction!$A$99","v":"Les informations concernant le débiteur doivent être mises dans la liste des mandats."}]
[]
[null,{"$f":"Traduction!$A$91","v":"Débiteur"}]
[]
[null,{"$f":"INDEX(Mandats!H:H,ligne)","v":"Rekall"}]
[null,{"$f":"INDEX(Mandats!I:I,ligne)","v":0},null,null,{"$f":"Traduction!A101","v":"Formules pour l'affichage d'espaces dans l'iban"}]
[null,{"$f":"INDEX(Mandats!J:J,ligne)","v":0},null,{"$f":"IF(INDEX(Mandats!C:C,ligne)=0,\"\",INDEX(Mandats!C:C,ligne))","v":"AL90208110080000001039531801"}]
[null,{"$f":"INDEX(Mandats!K:K,ligne)","v":0},null,1,{"$f":"MID($D$14,1+(D15-1)*4,4)","v":"AL90"}]
[null,{"$f":"INDEX(Mandats!L:L,ligne)","v":0},null,2,{"$f":"MID($D$14,1+(D16-1)*4,4)","v":"2081"},{"$f":"F15&\" \"&E15","v":" AL90"}]
[null,{"$f":"INDEX(Mandats!M:M,ligne)","v":0},null,3,"1008",{"$f":"F16&\" \"&E16","v":" AL90 2081"}]
[null,{"$f":"INDEX(Mandats!N:N,ligne)","v":0},null,4,"0000"," AL90 2081 1008"]
[null,{"$f":"INDEX(Mandats!O:O,ligne)","v":0},null,5,"0010"," AL90 2081 1008 0000"]
[null,{"$f":"Traduction!A92 &INDEX(Mandats!E:E,ligne)","v":"Identifiant : Rekall"},null,6,"3953"," AL90 2081 1008 0000 0010"]
[null,{"$f":"Traduction!$A$93","v":"Désignation du compte à débiter"},null,7,"1801"," AL90 2081 1008 0000 0010 3953"]
[null,{"$f":"\"IBAN : \"&F23","v":"IBAN :  AL90 2081 1008 0000 0010 3953 1801 "},null,8,""," AL90 2081 1008 0000 0010 3953 1801"]
[null,{"$f":"\"BIC : \"&INDEX(Mandats!D:D,ligne)","v":"BIC : PSSTFRPPPAR"},null,9,"",{"$f":"F22&\" \"&E22","v":" AL90 2081 1008 0000 0010 3953 1801 "}]
[null,{"$f":"Traduction!A94&INDEX(Mandats!G:G,ligne)","v":"Type de paiement : Récurrent"}]
[]
[null,{"$f":"Traduction!A95","v":"Créancier"}]
[null,{"$f":"F5","v":"XXXXXXXXX"}]
[null,"3 rue du général de Gaulle",null,null,null,{"$f":"Traduction!A102","v":"Indiquez ici votre adresse"}]
[null,"94000 Créteil"]
[]
[null,null,null,null,null,{"$f":"Traduction!A103","v":"Indiquez votre identifiant sur la feuille accueil"}]
[null,{"$f":"Traduction!A96&Message!C37","v":"Nom : fournisseur"},null,null,null,"Creditor Scheme Identification :"]
[null,{"$f":"Traduction!A100&Message!C38","v":"Identifiant créancier SEPA (ICS) : FR00ZZZ123456"},null,null,null,"Name et ID"]
[]
[null,{"$f":"Traduction!A97","v":"Fait à"}]
[null,{"$f":"INDEX(Mandats!B:B,ligne)","v":"2014-01-01"},null,null,{"$f":"Traduction!A99","v":"Les informations concernant le débiteur doivent être mises dans la liste des mandats."}]
[null,"Signature"]
[]
[null,{"$f":"Traduction!A98","v":"Document à renvoyer signé impérativement à :"}]
[]
[null,{"$f":"F5","v":"XXXXXXXXX"}]
[null,{"$f":"Traduction!$A$104","v":"Service comptabilité"}]
[null,"3 rue du général de Gaulle"]
[null,"94000 Créteil"]

{"sheet":"Facture","index":8,"n_rows":35,"n_cols":11,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,{"$f":"Traduction!$A$131","v":"Ligne"}]
[null,null,null,null,null,null,null,7,null,{"$f":"Traduction!$A$122","v":"fichier pdf par défaut"},{"$f":"SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(K5&\"-\"&K4&\"-\"&K11,\"/\",\"-\"),\":\",\"-\"),\"\\\",\"-\")","v":"P008-Factures decembre RCUR-Rekall"}]
[]
[null,null,null,null,null,null,null,null,null,"message id",{"$f":"message_id","v":"Factures decembre RCUR"}]
[null,null,null,null,null,null,null,null,null,{"$f":"INDEX(Transactions!$6:$6,ROW()-4)","v":"End To End Id"},{"$f":"INDEX(Transactions!A:A,ligne_facture)","v":"P008"}]
[null,null,null,null,null,null,null,null,null,{"$f":"INDEX(Transactions!$6:$6,ROW()-4)","v":"Currency"},{"$f":"INDEX(Transactions!B:B,ligne_facture)","v":"EUR"}]
["XXXXX",null,null,null,null,null,null,null,null,{"$f":"INDEX(Transactions!$6:$6,ROW()-4)","v":"Instructed Amount"},{"$f":"INDEX(Transactions!C:C,ligne_facture)","v":123}]
["3 rue du général de Gaulle",null,null,null,null,null,null,null,null,{"$f":"INDEX(Transactions!$6:$6,ROW()-4)","v":"Mandate Id"},{"$f":"INDEX(Transactions!D:D,ligne_facture)","v":"R001"}]
["94000 Créteil",null,null,null,null,null,null,null,null,{"$f":"INDEX(Transactions!$6:$6,ROW()-4)","v":"Date Of Signature"},{"$f":"INDEX(Transactions!E:E,ligne_facture)","v":41640}]
[null,null,null,null,null,null,null,null,null,{"$f":"INDEX(Transactions!$6:$6,ROW()-4)","v":"Financial Institution Id"},{"$f":"INDEX(Transactions!F:F,ligne_facture)","v":"PSSTFRPPPAR"}]
[{"$f":"TODAY()","v":"2024-01-24"},null,null,null,null,null,null,null,null,{"$f":"INDEX(Transactions!$6:$6,ROW()-4)","v":"Debtor Name"},{"$f":"INDEX(Transactions!G:G,ligne_facture)","v":"Rekall"}]
[null,null,null,{"$f":"K14","v":"Rekall"},null,null,null,null,null,{"$f":"INDEX(Transactions!$6:$6,ROW()-4)","v":"Debtor Account ID"},{"$f":"INDEX(Transactions!H:H,ligne_facture)","v":"AL90208110080000001039531801"}]
[null,null,null,{"$f":"IF(K16=0,\"\",K16&\" \")&IF(K15=0,\"\",K15)","v":""},null,null,null,null,null,{"$f":"INDEX(Transactions!$6:$6,ROW()-4)","v":"Remittance Information"},{"$f":"INDEX(Transactions!I:I,ligne_facture)","v":"Facture F201401-008 janvier 2014"}]
[null,null,null,{"$f":"K17","v":0},null,null,null,null,null,{"$f":"INDEX(Transactions!$6:$6,ROW()-4)","v":"0"},{"$f":"INDEX(Transactions!J:J,ligne_facture)","v":"Rekall"}]
[null,null,null,{"$f":"K18","v":0},null,null,null,null,null,{"$f":"INDEX(Transactions!$6:$6,ROW()-4)","v":"1"},{"$f":"INDEX(Transactions!K:K,ligne_facture)","v":0}]
[null,null,null,{"$f":"K19","v":0},null,null,null,null,null,{"$f":"INDEX(Transactions!$6:$6,ROW()-4)","v":"2"},{"$f":"INDEX(Transactions!L:L,ligne_facture)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"INDEX(Transactions!$6:$6,ROW()-4)","v":"3"},{"$f":"INDEX(Transactions!M:M,ligne_facture)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"INDEX(Transactions!$6:$6,ROW()-4)","v":"4"},{"$f":"INDEX(Transactions!N:N,ligne_facture)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"INDEX(Transactions!$6:$6,ROW()-4)","v":"5"},{"$f":"INDEX(Transactions!O:O,ligne_facture)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"INDEX(Transactions!$6:$6,ROW()-4)","v":"6"},{"$f":"INDEX(Transactions!P:P,ligne_facture)","v":"Facture F201401-008"}]
[null,null,null,null,null,null,null,null,null,{"$f":"INDEX(Transactions!$6:$6,ROW()-4)","v":"7"},{"$f":"INDEX(Transactions!Q:Q,ligne_facture)","v":"Abonnement service xxxx"}]
[null,null,null,null,null,null,null,null,null,{"$f":"INDEX(Transactions!$6:$6,ROW()-4)","v":"8"},{"$f":"INDEX(Transactions!R:R,ligne_facture)","v":0}]
[null,null,{"$f":"K20","v":"Facture F201401-008"},null,null,null,null,null,null,{"$f":"INDEX(Transactions!$6:$6,ROW()-4)","v":"9"},{"$f":"INDEX(Transactions!S:S,ligne_facture)","v":0}]
[null,null,{"$f":"K21","v":"Abonnement service xxxx"},null,null,null,null,null,null,{"$f":"INDEX(Transactions!$6:$6,ROW()-4)","v":"10"},{"$f":"INDEX(Transactions!T:T,ligne_facture)","v":0}]
[]
[]
[]
[null,null,{"$f":"Traduction!A128","v":"HT"},{"$f":"ROUND(D30/1.2,2)","v":102.5}]
[null,null,{"$f":"Traduction!A129","v":"TVA"},{"$f":"D30-D28","v":20.5}]
[null,null,{"$f":"Traduction!A130","v":"total"},{"$f":"K7","v":123}]
[]
[{"$f":"Traduction!A123","v":"Ce montant sera prélevé sur le compte"}]
[null,{"$f":"K12","v":"AL90208110080000001039531801"}]
[null,{"$f":"K10","v":"PSSTFRPPPAR"}]
["Le",{"$f":"date_prelevement","v":"2024-01-24"}]

{"sheet":"Traduction","index":9,"n_rows":176,"n_cols":3,"rows_kept":176,"cut":false,"hidden":false,"merged":[]}
[1,"FR","EN"]
[{"$f":"INDEX(B2:C2,$A$1)","v":"Vos informations bancaires utilisées pour le fichier banque et sur le mandat"},"Vos informations bancaires utilisées pour le fichier banque et sur le mandat","Your banking details used for bank file and mandate"]
[{"$f":"INDEX(B3:C3,$A$1)","v":" (pas d'accent, uniquement les caractères autorisés)"}," (pas d'accent, uniquement les caractères autorisés)"," (No accent, only the allowable characters)"]
["Liste des mandats","Liste des mandats","List of mandates"]
["Vous indiquez pour chaque client une RUM ainsi que les informations bancaires","Vous indiquez pour chaque client une RUM ainsi que les informations bancaires","For each customer, specify the UMR and bank details"]
["RUM : référence Unique de mandat","RUM : référence Unique de mandat","UMR: Unique mandate reference"]
["Pas d'espace ou de tiret dans l'IBAN","Pas d'espace ou de tiret dans l'IBAN","No spaces or dashes in the IBAN"]
["8 ou 11 caractères dans le BIC","8 ou 11 caractères dans le BIC","8 or 11 characters in the BIC"]
["la date doit être valide","la date doit être valide","the date must be valid"]
["Le nom du client doit respecter les caractères autorisés","Le nom du client doit respecter les caractères autorisés","The customer name must meet the allowable characters"]
["Voir les mandats et paiements","Voir les mandats et paiements","See the mandates and payments"]
["Un mandat","Un mandat","A mandate"]
["On récupère les informations d'un mandat pour en faire un document imprimable","On récupère les informations d'un mandat pour en faire un document imprimable","Mandate details are retrieved to convert it into a printable document"]
["ce document une fois personnalisé permettra d'être présenté au ","ce document une fois personnalisé permettra d'être présenté au ","Once this document is customized, it will be submitted to "]
["client pour sa signature","client pour sa signature","customer for signature"]
["Fichiers CFONB","Fichiers CFONB","CFONB Files"]
["Importer des données d'un fichier cfonb pour créer une liste de paiements","Importer des données d'un fichier cfonb pour créer une liste de paiements","Import data from a CFONB file to create a list of payments"]
["Liste des paiements","Liste des paiements","List of payments"]
["Colonne A","Colonne A","Column A"]
["Colonne B","Colonne B","Column B"]
["Colonne C","Colonne C","Column C"]
["Colonne D","Colonne D","Column D"]
["Import fichier CFONB","Import fichier CFONB","CFONB file import"]
[]
["Colonne E","Colonne E","Column E"]
["Colonne F","Colonne F","Column F"]
["à partir de la colonne H","à partir de la colonne H","from column H"]
["Infos complémentaires","Infos complémentaires","Additional info"]
["colonnes supplémentaires pour faire des factures","colonnes supplémentaires pour faire des factures","additional columns for generating invoices"]
["une valeur parmis RCUR/FRST/OOF/FNAL","une valeur parmis RCUR/FRST/OOF/FNAL","a value among RCUR/FRST/OOF/FNAL"]
["valeur unique pour chaque prélèvement","valeur unique pour chaque prélèvement","unique value for each DD"]
["uniquement EUR","uniquement EUR","only EUR"]
["valeur sur moins de 18 caractères, 5 décimales maxi","valeur sur moins de 18 caractères, 5 décimales maxi","value of less than 18 characters, max 5 decimal places"]
[0]
[0]
["RUM telle que dans la liste des Mandats","RUM telle que dans la liste des Mandats","UMR as in the list of Mandates"]
["Texte sur le relevé du client","Texte sur le relevé du client","Text on the customer statement"]
["Voir les paiements","Voir les paiements","See payments"]
["Une fois la liste des paiements complète, vous appuyez sur vérifier sur la feuille prélèvements.","Une fois la liste des paiements complète, vous appuyez sur vérifier sur la feuille prélèvements.","Once the list of payments is complete,you press Verify on DD worksheet"]
["s'il y a des erreurs, elles sont indiquées dans la colonne OK","s'il y a des erreurs, elles sont indiquées dans la colonne OK","if there are errors, they are listed in the OK column"]
["Sinon les feuilles sont masquées et on passe à la création des fichiers XML","Sinon les feuilles sont masquées et on passe à la création des fichiers XML","Otherwise worksheets are hidden and you go to Create XML files"]
["Information du mappage XML des entêtes","Information du mappage XML des entêtes","Header XML mapping details"]
["Entête fichier XML","Entête fichier XML","XML file header "]
["3 infos sont utiles pour chaque liste","3 infos sont utiles pour chaque liste","3 information items are useful for each list"]
["titre","titre","title"]
["+ Sequence Type","+ Sequence Type","+ Sequence Type"]
["Date prélèvement","Date prélèvement","DD date"]
["Les autres infos sont soit fixes soit automatiques","Les autres infos sont soit fixes soit automatiques","Other information is either fixed or automatic"]
["Sert d'identifiant de base","Sert d'identifiant de base","Used as a basic identifier"]
["une valeur parmis RCUR/FRST/OOF/FNAL","une valeur parmis RCUR/FRST/OOF/FNAL","a value among RCUR/FRST/OOF/FNAL"]
["Date prévue","Date prévue","Planned date"]
["Transactions","Transactions","Transactions"]
["C'est une combinaison des informations des paiements et des mandats","C'est une combinaison des informations des paiements et des mandats","It is a combination of payment and mandate details"]
["Facture","Facture","Invoice"]
["A partir d'une liste de transactions, il est possible d'établir une liste de factures","A partir d'une liste de transactions, il est possible d'établir une liste de factures","From a list of transactions, you can generate a list of invoices"]
["suivant un modèle que vous pouvez personnaliser","suivant un modèle que vous pouvez personnaliser","according to a customizable template"]
["Vous pourrez l'utiliser pour faire les factures au format pdf en une seule opération.","Vous pourrez l'utiliser pour faire les factures au format pdf en une seule opération.","You can use it to generate invoices under pdf format in a single operation."]
["Aide en ligne","Aide en ligne","Online help"]
["Information du mappage XML des prélèvements","Information du mappage XML des prélèvements","DD XML mapping details"]
["Caractères autorisés","Caractères autorisés","Allowable characters"]
["1.11.    Format des montants \n ...\n     -    5 décimales maximum après le point \n     -   La longueur maximale d'un montant est de 18 caractères (séparateur de décimale compris) \n     -   Le nombre de décimales doit être compatible avec la norme ISO 4217 relative aux devises. \nPour les montants d'une longueur supérieure à 14 caractères, le client devra impérativement vérifier auprès de sa banque s'ils peuvent être traités.","1.11.    Format des montants \n ...\n     -    5 décimales maximum après le point \n     -   La longueur maximale d'un montant est de 18 caractères (séparateur de décimale compris) \n     -   Le nombre de décimales doit être compatible avec la norme ISO 4217 relative aux devises. \nPour les montants d'une longueur supérieure à 14 caractères, le client devra impérativement vérifier auprès de sa banque s'ils peuvent être traités.","1.11.    Amount format \n ...\n     -    Up to 5 decimals after the dot \n     -   The maximum length of an amount is 18 characters (including decimal separator)  \n     -   The number of decimal places must be compatible with the ISO 4217 currency code list. \nFor amounts longer than 14 characters, the customer must check with their bank if they can be processed.\n"]
["< Précédent","< Précédent","< Previous"]
["Suivant >","Suivant >","Next >"]
["Voir Mandat","Voir Mandat","See Mandate"]
["RUM","RUM","UMR"]
["Date accord prélèvement","Date accord prélèvement","Debit agreement date"]
[{"$f":"INDEX(B67:C67,$A$1)","v":"IBAN"},"IBAN","IBAN"]
["BIC","BIC","BIC"]
["Client","Client","Customer"]
["ok","ok","ok"]
["Type paiement","Type paiement","Payment type"]
["Société","Société","Company"]
["Nom","Nom","Name"]
["prénom","prénom","first name"]
["adresse1","adresse1","address1"]
["adresse2","adresse2","address2"]
["cpville","cpville","zip code"]
["autre","autre","other"]
["Vérifier les mandats","Vérifier les mandats","Verify mandates"]
["Accueil","Accueil","Home"]
["Mandats","Mandats","Mandates"]
["ligne feuille mandats","ligne feuille mandats","mandates worksheet row"]
["Indiquez ici votre nom pour le texte","Indiquez ici votre nom pour le texte","Enter here your name for the text"]
["Faire mandat pdf","Faire mandat pdf","Generate pdf mandate"]
["Nom pdf par défaut","Nom pdf par défaut","Default pdf name"]
["Vous bénéficiez du droit d'être remboursé par votre banque suivant les conditions décrites dans la convention que vous avez passée avec elle. Une demande de remboursement doit être présentée dans les 8 semaines suivant la date de débit de votre compte pour un prélèvement autorisé.","Vous bénéficiez du droit d'être remboursé par votre banque suivant les conditions décrites dans la convention que vous avez passée avec elle. Une demande de remboursement doit être présentée dans les 8 semaines suivant la date de débit de votre compte pour un prélèvement autorisé.","You have the right to be reimbursed by your bank according to the terms described in the agreement entered into with your bank. A reimbursement request must be made within 8 weeks from the date an authorized DD was debited from your account"]
["Et vous autorisez votre banque à débiter votre compte conformément aux instructions de ","Et vous autorisez votre banque à débiter votre compte conformément aux instructions de ","And you authorize your bank to debit your account according to the instructions from "]
["En signant ce formulaire de mandat, vous autorisez ","En signant ce formulaire de mandat, vous autorisez ","By signing this mandate form, you authorize "]
["Référence unique de mandat (RUM)","Référence unique de mandat (RUM)","Unique Mandate Reference (UMR)"]
["Mandat de prélèvement SEPA","Mandat de prélèvement SEPA","SEPA Direct Debit Mandate"]
["Débiteur","Débiteur","Debtor"]
["Identifiant : ","Identifiant : ","Identifier: "]
["Désignation du compte à débiter","Désignation du compte à débiter","Designation of the account to be debited"]
["Type de paiement : ","Type de paiement : ","Payment type: "]
["Créancier","Créancier","Creditor"]
["Nom : ","Nom : ","Name: "]
["Fait à","Fait à","Done at"]
["Document à renvoyer signé impérativement à :","Document à renvoyer signé impérativement à :","Please return this signed document to:"]
["Les informations concernant le débiteur doivent être mises dans la liste des mandats.","Les informations concernant le débiteur doivent être mises dans la liste des mandats.","Debtor details must be entered in the list of mandates."]
["Identifiant créancier SEPA (ICS) : ","Identifiant créancier SEPA (ICS) : ","SEPA creditor identifier (SCI): "]
["Formules pour l'affichage d'espaces dans l'iban","Formules pour l'affichage d'espaces dans l'iban","Formulas for displaying spaces in the IBAN"]
["Indiquez ici votre adresse","Indiquez ici votre adresse","Enter your address here"]
["Indiquez votre identifiant sur la feuille accueil","Indiquez votre identifiant sur la feuille accueil","Enter your identifier on the Home worksheet"]
["Service comptabilité","Service comptabilité","Accounting department"]
["Pour pouvoir utiliser ce document, vous devez activer les macros","Pour pouvoir utiliser ce document, vous devez activer les macros","To use this document, you must enable macros"]
["Pas de problème trouvé","Pas de problème trouvé","No problems found"]
["X erreurs trouvées","X erreurs trouvées","X errors found"]
["Effacer","Effacer","Delete"]
["Vérification","Vérification","Check"]
["Sequence Type","Sequence Type","Sequence Type"]
["Id prélèvement","Id prélèvement","DD Id"]
["Currency","Currency","Currency"]
["Montant","Montant","Amount"]
["RUM","RUM","UMR"]
["Infos complémentaires","Infos complémentaires","Additional info"]
["ok","ok","ok"]
["numéro de facture","numéro de facture","invoice number"]
["référence","référence","reference"]
["libellé","libellé","label"]
["Faire facture pdf","Faire facture pdf","Generate pdf invoice"]
["Faire tous les pdf pour la feuille transactions","Faire tous les pdf pour la feuille transactions","Generate all pdfs for the transactions worksheet"]
["fichier pdf par défaut","fichier pdf par défaut","default pdf file"]
["Ce montant sera prélevé sur le compte","Ce montant sera prélevé sur le compte","This amount will be debited from the account"]
["Enlever les accents","Enlever les accents","Remove accents"]
["Informations supplémentaires : ajoutez les infos dans les feuilles mandats ou prélèvements puis mappez le fichier xml","Informations supplémentaires : ajoutez les infos dans les feuilles mandats ou prélèvements puis mappez le fichier xml","Additional information: add information to the mandates or DD worksheets and then map the xml file"]
["Facture","Facture","Invoice"]
["Feuille message","Feuille message","Message worksheet"]
["HT","HT","ex VAT"]
["TVA","TVA","VAT"]
["total","total","total"]
[{"$f":"INDEX(B131:C131,$A$1)","v":"Ligne"},"Ligne","Row"]
["Feuille message","Feuille message","Message worksheet"]
["Informations supplémentaires : ajoutez les infos dans les feuilles mandats ou prélèvements puis mappez le fichier xml","Informations supplémentaires : ajoutez les infos dans les feuilles mandats ou prélèvements puis mappez le fichier xml","Additional information: add information to the mandates or DD worksheets and then map the xml file"]
["Aide en ligne","Aide en ligne","Online help"]
["2.6.     Modes de comptabilisation des opérations \n\nDeux modes de comptabilisation des transactions sont possibles : \n     a) La   comptabilisation   par   lot   (pour   un   ensemble   de   transactions) :   ce   mode   doit   être   utilisé lorsque l‟émetteur souhaite que sa banque effectue un crédit global sur le compte à créditer pour l‟ensemble des transactions (DebitDirectTransactionInformation) contenues dans le lot    (PaymentInformation). \n     b) La   comptabilisation   unitaire   (par   transaction) :  ce mode  doit  être  utilisé  lorsque  l‟émetteur souhaite que sa banque effectue un crédit par transaction sur le compte à créditer. \n\nLe    choix  du   mode    de  comptabilisation  est  généralement géré  par un  accord bilatéral  convenu préalablement entre le client et sa banque . \n\nPar ailleurs, la donnée facultative « BatchBooking » (index 2.3) peut être utilisée pour indiquer cette option.    Cette  donnée figure  dans   le  corps  du   message    ISO   20022    et  se  caractérise  par  le  tag <BtchBookg> du bloc PaymentInformation du message. \n\nSi le choix est fixé par contrat, il prévaudra sur celui qui pourrait être indiqué dans le message. ","2.6.     Modes de comptabilisation des opérations \n\nDeux modes de comptabilisation des transactions sont possibles : \n     a) La   comptabilisation   par   lot   (pour   un   ensemble   de   transactions) :   ce   mode   doit   être   utilisé lorsque l‟émetteur souhaite que sa banque effectue un crédit global sur le compte à créditer pour l‟ensemble des transactions (DebitDirectTransactionInformation) contenues dans le lot    (PaymentInformation). \n     b) La   comptabilisation   unitaire   (par   transaction) :  ce mode  doit  être  utilisé  lorsque  l‟émetteur souhaite que sa banque effectue un crédit par transaction sur le compte à créditer. \n\nLe    choix  du   mode    de  comptabilisation  est  généralement géré  par un  accord bilatéral  convenu préalablement entre le client et sa banque . \n\nPar ailleurs, la donnée facultative « BatchBooking » (index 2.3) peut être utilisée pour indiquer cette option.    Cette  donnée figure  dans   le  corps  du   message    ISO   20022    et  se  caractérise  par  le  tag <BtchBookg> du bloc PaymentInformation du message. \n\nSi le choix est fixé par contrat, il prévaudra sur celui qui pourrait être indiqué dans le message. ","2.6.     Operations accounting methods \n\nTwo transaction accounting methods are available : \n     a) Batch accounting (for a set of transactions):   this mode should be used when the issuer wants that an overall credit be applied by the bank to the the account to be credited for all transactions (DebitDirectTransactionInformation) contained in the batch (PaymentInformation). \n     b) Single accounting (per transaction):  This mode should be used when the the issuer wants that a credit be applied by the bank to the the account to be credited per single transaction \n\nThe choice of accounting method is generally managed by a bilateral agreement previously entered into between the customer and the bank. \n\nIn addition, the optional \"BatchBooking\" (index 2.3) data can be used to indicate this option.    This data is contained in the ISO 20022 message body and is characterized by the <BtchBookg> tag of the PaymentInformation block of the message. \n\nIf the choice is contractually determined, it will prevail over the one which could be provided in the message. \n"]
["Les valeurs en italique servent à l'initialisation.\nLes autres sont soit calculées soit fixes","Les valeurs en italique servent à l'initialisation.\nLes autres sont soit calculées soit fixes","Values in italics are used for initialization.\nThe others are either fixed or calculated\n"]
["A chaque changement la liste des transactions se met à jour.\nIl faut alors vérifier les informations (en cochant à chaque fois la case correspondante).\nPuis il faut faire l'export en utilisant le bouton","A chaque changement la liste des transactions se met à jour.\nIl faut alors vérifier les informations (en cochant à chaque fois la case correspondante).\nPuis il faut faire l'export en utilisant le bouton","Upon each change the list of transactions is updated.\nInformation then must be verified (by selecting each time the appropriate checkbox).\nThen you have to export using the button\n"]
["Date prélèvement","Date prélèvement","DD date"]
["Titre","Titre","Title"]
["Accueil","Accueil","Home"]
["Confirmez l'effacement de la liste de prélèvement","Confirmez l'effacement de la liste de prélèvement","Confirm the deletion of the list of DDs"]
["Montant","Montant","Amount"]
["Infos complémentaires","Infos complémentaires","Additional info"]
["fiez les entêtes et les transactions puis cochez ok avant de créer le fichier xml","fiez les entêtes et les transactions puis cochez ok avant de créer le fichier xml","Check the headers and transactions and then select ok prior to creating the xml file"]
["Fin","Fin","End"]
["Erreur IBAN créditeur","Erreur IBAN créditeur","Creditor IBAN error"]
["Erreur BIC créditeur","Erreur BIC créditeur","Creditor BIC error"]
["Erreur date prélèvement incorrecte","Erreur date prélèvement incorrecte","Incorrect DD date error"]
["Erreur date prélèvement inférieure date du jour.","Erreur date prélèvement inférieure date du jour.","DD date earlier than today error"]
["Pas de transaction à exporter","Pas de transaction à exporter","No transaction to export"]
["Erreur","Erreur","Error"]
["Erreur total","Erreur total","Total error"]
["3 erreurs mandats trouvées","3 erreurs mandats trouvées","3 mandate errors found"]
["pas de prélèvement","pas de prélèvement","no DD"]
["Il y a 3 erreurs, faites les vérifications et relancez le test","Il y a 3 erreurs, faites les vérifications et relancez le test","There are 3 errors, perform the checks and run the test again"]
["Liste des prélèvements ok","Liste des prélèvements ok","List of DDs ok"]
["Pas de prélèvement","Pas de prélèvement","No DDs"]
["Vérification virements ","Vérification virements ","Checking of transfers "]
["Message original modifié","Message original modifié","Original message changed"]
["Erreur pas de transaction pour xxx","Erreur pas de transaction pour xxx","Error no transaction for xxx"]
["Limite du nombre d'utilisateurs atteinte","Limite du nombre d'utilisateurs atteinte","Maximum number of users reached"]
["Voir ici pour acheter d'autres licences","Voir ici pour acheter d'autres licences","See here to purchase additional licenses"]
["Pas de problème trouvé","Pas de problème trouvé","No problems found"]
["Pas de mandat","Pas de mandat","No mandate"]
["Fichier déjà ouvert","Fichier déjà ouvert","File already open"]
["Pas de facture à créer","Pas de facture à créer","No invoice to create"]
["Fichier fact.pdf déjà ouvert, voulez vous continuer les autres factures ?\"","Fichier fact.pdf déjà ouvert, voulez vous continuer les autres factures ?\"","fact.pdf file already open, do you still want to continue with other invoices?\""]
["Merci d'envoyer un bon de commande à destination de","Merci d'envoyer un bon de commande à destination de","# Merci d'envoyer un bon de commande à destination de"]
[null,"En indiquant les références suivantes : ","# En indiquant les références suivantes : "]
[null,"Indiquez une clef valide sous forme de caractères séparés par des -","# Indiquez une clef valide sous forme de caractères séparés par des -"]
[null,"validation","# validation"]
[null,"Combien font ","# Combien font "]
[null,"Question ","# Question "]
[null,"La réponse attendue était ","# La réponse attendue était "]
[null,"Réponse","# Réponse"]
[null,"Voulez-vous vraiment sortir sans terminer","# Voulez-vous vraiment sortir sans terminer"]