{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Résultats","Paramètres","Données originales"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"comments":0,"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":"Résultats","index":0,"n_rows":30,"n_cols":10,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Numéro d'écriture","Compte","Compte Libellé","Date de pièce","Journal","Référence","Ecriture libellé","Débit","Crédit","Lettre"]
[{"$f":"CustomSplit('Données originales'!A2:A89962)","v":"2"},{"$f":"TRANSPOSE(CustomFormulaCompte(A2:A89963,Résultats!B:B,Paramètres!B3,Paramètres!B8))","v":"5121"},{"$f":"TRANSPOSE(CustomFormulaLibelle(A2:A89963,C:C,Paramètres!B4,Paramètres!B9))","v":"BANQUE"},{"$f":"TRANSPOSE(CustomFormulaDate('Données originales'!A2:A89962))","v":"01/01/2024"},{"$f":"TRANSPOSE(CustomFormulaJournal(A2:A89963,Paramètres!B5))","v":"BQ"},null,{"$f":"TRANSPOSE(CustomFormulaLibEcriture(A2:A89963,'Données originales'!B2:B89962))","v":"TEST"},{"$f":"TRIM(CustomFormulaDebitCredit(A2:A89963,'Données originales'!C2:C89962,'Données originales'!D2:D89962))","v":"10000"},{"$f":"TRIM(CustomFormulaDebitCredit(A2:A89963,'Données originales'!D2:D89962,'Données originales'!C2:C89962))","v":"0"}]
["2","473AFFECTATION-AUTOFRED","AFFECTATION AUTOMATIQUE IA FRED","01/01/2024","BQ",null,"TEST","0","10000"]
["3","5121","BANQUE","01/01/2024","BQ",null,"TEST","0","1500"]
["3","473AFFECTATION-AUTOFRED","AFFECTATION AUTOMATIQUE IA FRED","01/01/2024","BQ",null,"TEST","1500","0"]
["4","5121","BANQUE","02/01/2024","BQ",null,"TEST","0","1501"]
["4","473AFFECTATION-AUTOFRED","AFFECTATION AUTOMATIQUE IA FRED","02/01/2024","BQ",null,"TEST","1501","0"]
["5","5121","BANQUE","01/01/2024","BQ",null,"TEST","10000","0"]
["5","473AFFECTATION-AUTOFRED","AFFECTATION AUTOMATIQUE IA FRED","01/01/2024","BQ",null,"TEST","0","10000"]
["6","5121","BANQUE","01/01/2024","BQ",null,"TEST","0","1500"]
["6","473AFFECTATION-AUTOFRED","AFFECTATION AUTOMATIQUE IA FRED","01/01/2024","BQ",null,"TEST","1500","0"]
["7","5121","BANQUE","02/01/2024","BQ",null,"TEST","0","1501"]
["7","473AFFECTATION-AUTOFRED","AFFECTATION AUTOMATIQUE IA FRED","02/01/2024","BQ",null,"TEST","1501","0"]
["8","5121","BANQUE","01/01/2024","BQ",null,"TEST","10000","0"]
["8","473AFFECTATION-AUTOFRED","AFFECTATION AUTOMATIQUE IA FRED","01/01/2024","BQ",null,"TEST","0","10000"]
["9","5121","BANQUE","01/01/2024","BQ",null,"TEST","10000","0"]
["9","473AFFECTATION-AUTOFRED","AFFECTATION AUTOMATIQUE IA FRED","01/01/2024","BQ",null,"TEST","0","10000"]
["10","5121","BANQUE","01/01/2024","BQ",null,"TEST","0","1500"]
["10","473AFFECTATION-AUTOFRED","AFFECTATION AUTOMATIQUE IA FRED","01/01/2024","BQ",null,"TEST","1500","0"]
["11","5121","BANQUE","02/01/2024","BQ",null,"TEST LIBELLE JHA","0","1501"]
["11","473AFFECTATION-AUTOFRED","AFFECTATION AUTOMATIQUE IA FRED","02/01/2024","BQ",null,"TEST LIBELLE JHA","1501","0"]
["12","5121","BANQUE","01/01/2024","BQ",null,"TEST","10000","0"]
["12","473AFFECTATION-AUTOFRED","AFFECTATION AUTOMATIQUE IA FRED","01/01/2024","BQ",null,"TEST","0","10000"]
["13","5121","BANQUE","01/01/2024","BQ",null,"TEST","0","1500"]
["13","473AFFECTATION-AUTOFRED","AFFECTATION AUTOMATIQUE IA FRED","01/01/2024","BQ",null,"TEST","1500","0"]
["14","5121","BANQUE","02/01/2024","BQ",null,"TEST","0","1501"]
["14","473AFFECTATION-AUTOFRED","AFFECTATION AUTOMATIQUE IA FRED","02/01/2024","BQ",null,"TEST","1501","0"]
["15","5121","BANQUE","01/01/2024","BQ",null,"TEST","10000","0"]
["15","473AFFECTATION-AUTOFRED","AFFECTATION AUTOMATIQUE IA FRED","01/01/2024","BQ",null,"TEST","0","10000"]
[null,null,"",null,null,null,""]

{"sheet":"Paramètres","index":1,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Configuration des colonnes"]
["Colonne Inqom","Valeur par défaut"]
["Compte",5121]
["Compte Libellé","BANQUE"]
["Journal","BQ"]
["Référence"]
[]
["Compte de contre-partie","473AFFECTATION-AUTOFRED"]
["Libellé contre partie","AFFECTATION AUTOMATIQUE IA FRED"]

{"sheet":"Données originales","index":2,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Date","Libellé","Débit","Crédit"]
["2024-01-01","TEST",null,10000]
["2024-01-01","TEST",1500]
["2024-01-02","TEST",1501]
["2024-01-01","TEST",null,10000]
["2024-01-01","TEST",1500]
["2024-01-02","TEST",1501]
["2024-01-01","TEST",null,10000]
["2024-01-01","TEST",null,10000]
["2024-01-01","TEST",1500]
["2024-01-02","TEST LIBELLE JHA",1501]
["2024-01-01","TEST",null,10000]
["2024-01-01","TEST",1500]
["2024-01-02","TEST",1501]
["2024-01-01","TEST",null,10000]