{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["DONNEES","LISTE FRS","RECAP 01-2022","JOURNAL 01-2022","MOTS DE PASSE"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":0,"defined_names":13,"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":"DONNEES","index":0,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[[8,0,9,0],[3,6,9,6],[0,3,9,3],[0,5,9,5],[0,1,9,1],[4,2,9,2]]}
["Mode de paiement",null,"CODE -TVA",null,"Type",null,"TITRE"]
["Par chèque",null,0.19,null,"Achats MP",null,"Sarl, ISO 9 INTERNATIONAL          :      SUIVI DES FACTURES FOURNISSEURS       :          EXERCICE  2022"]
["Virement",null,0.09,null,"Achats Emb",null,"Sarl, ISO 9 INTERNATIONAL          :      LISTE DES FACTURES FOURNISSEURS       :          EXERCICE  2022"]
["Verssement",null,0,null,"Autres Achats Stockés"]
["Espèce",null,null,null,"Achats non stockés"]
["A Terme",null,null,null,"Services"]
["Espèce (TEMP.)",null,null,null,"Immobilisations"]
["Compensation",null,null,null,"Location "]
[null,null,null,null,"Loyer leasing"]
[null,null,null,null,"Autres"]

{"sheet":"LISTE FRS","index":1,"n_rows":165,"n_cols":5,"rows_kept":165,"cut":false,"hidden":false,"merged":[]}
["Fournisseurs","N°","Code \nCompta","Adresse","Contacte"]
["AASTED  ABS  DANEMARK",{"$f":"ROW()-1","v":1},404906]
["ABDESLAM  NACERDINE",2,401725]
["ABINDUSTRIY, VTE MATERIEL",3,404200]
["ADE - BORDJ-MENAIEL, EPIC",4,401901]
["ADE - BOUMERDES, EPIC",5,401902]
["ADMIN INFORMATIQUE, VTES & MTENANCE",6,401698]
["AGRANA  FRUITS ALGERIA, SPA",7,401137]
["AGRANA FRUITS ALGERIA",8,403137]
["AGRIPINE, SARL",9,401455]
["AGRO  ALIMENTAIRE SARL",10,401447]
["AGRO  FILM PACKAGING, SARL",11,401103]
["AGROAL HHK, EURL",12,401435]
["AGRORAW,  SARL",13,401437]
["AIR ragon INDUSTRY, SPA",14,401612]
["AKSOUM  SLIMANE, GROS AL.GLE",15,401302]
["ALILECHE  MED LARBI, A.PUB.",16,401134]
["ALL   PLAST, SARL",17,401177]
["ALSOCHEM, SARL",18,401253]
["ALZYME, SARL",19,401417]
["AMLI  CONSTRUCTION, SARL",20,404173]
["AMNNA, SARL",21,401426]
["AMOUCHAS  YACINE,",22,401443]
["AQUASIM, SPA",23,401186]
["AROMATECH, SARL",24,401140]
["AROMES  D'ALGERIE, EURL",25,401164]
["AROMGEL ALGERO-ITALIENNE, SARL",26,401225]
["ATMCHYGIENE, SARL",27,401282]
["B 2 M  B O U C H E K I R, SARL",28,401166]
["B A L E H O U A N E  HAKIM, CHOCOLATIER",29,401193]
["B A P - L A I T, SARL",30,401202]
["B A T I C O M P O S, SPA",31,404019]
["B E I, SARL",32,401667]
["B E N S E K H R I  YACINE, ETS",{"$f":"ROW()-1","v":33},401747]
["B E R K A N I MADJID, DBK T.OUZOU",34,401418]
["B I O - F O O D, M.B.C",35,401183]
["B O U C H E L A G H E M  KAMAL, TIZI OUZOU",36,401640]
["B O U C I O U F  AMAR, EMBALLAGE",37,401180]
["B O U G H A L A D  SAID, PLOMBERIE",38,404206]
["B O U K E B B AL ABDELKARIM, ETS",39,404196]
["B O U Z I D I  AZIZ, C.EMBALLAGES",40,401176]
["B U H L E R  AG  SUISSE",41,404905]
["C A R G I LL  MALAISIE",42,401411]
["C A R I N S A  ALGERIE, EURL",43,401143]
["C H E F A  I N G R E D I E N T S, SARL",44,401288]
["C H E M I - P R O, SARL",45,401291]
["C O D A L  ALGERIE, SARL",46,401655]
["C O J H Y, SARL",47,401647]
["C O N F I C H O C, SARL",48,401181]
["C U R T  G E O R G I  M A G H R E B, EURL",49,401197]
["D A N I M E X, EURL",50,401211]
["D A R K O M , SARL",51,401675]
["D A Y M A CHIMIE, SARL",52,401218]
["D E L T A  CONTROL, SARL",53,401611]
["D I F  W A L I D",54,401439]
["D I S P O K E M, SARL",55,401423]
["D I S P R O C, SARL",56,401284]
["D I S T R I  F I R S T, EURL",57,401287]
["D I S T R I M, SPA",58,401109]
["D O U D A H  AISSAM, INSTAL. EQUIPTS FRIGOR.",59,404171]
["E D E L W E I S S  P L A S T SARL",60,401425]
["E F C  E Q U I P E M E N T S, SARL",61,401436]
["E L  B A R A K A  F O O D  INVESTMENT",62,401441]
["E N A S E L, SPA",63,401113]
["E P I B E N I E, SARL",64,401456]
["E T I Q A L, SARL",{"$f":"ROW()-1","v":65},401110]
["E T I Q U E T T E  D ' O R,  E.U.R.L",66,401429]
["EXPRESSIONS  AROMATIQUES, EURL",67,401102]
["F A C T  ALGERIE, SARL",68,404207]
["F B  - F O O D, SARL",69,401296]
["F L Y  C H E M I C A L S, EURL",70,401269]
["F O U R N I S S E U R S  N/SOUMIS A TVA",71,401500]
["G R D  LA BELLE, SPA",72,401124]
["G R O S  BERRAHAL GROUP, SPA",73,401344]
["H A D J  K A S S E M  A.MADJID, BEL EMB.",74,401116]
["H A M T E C H , SARL",75,401214]
["H A N I P A P, SARL",76,401416]
["H O C I N E  MOHAMED, B.E.T.A",77,404139]
["I M A F O R N I  G E A,  ITALIE",78,404900]
["I N D E F R I G O, SARL",79,404178]
["I N N O V E X  SUCCURSALE, SARL",80,401230]
["I N V E S T  I N O X, EURL",81,401627]
["I P A C, SARL",82,401440]
["I.T.E  A.ISSAKHEM",83,404907]
["J A B  C O M P A N Y, SARL",84,401236]
["K A R I M  IMPRIM. MODERNE, EURL",85,401139]
["K A R M A C, SARL",86,401693]
["K E R M O U D  ACHOUR, ETS",87,401696]
["K H A D E R  IMPORT/EXPORT, EURL",88,401265]
["K H I R E D D I N E  MOHAMED",89,404197]
["K R E A C H I M, EURL",90,401454]
["KFH  FRANCE",91,401011]
["L A  CASTELLANA  SAS, ITALIE",92,404904]
["L A  M A I S O N  DU  T E L E P H O N E, SARL",93,404210]
["L A B O F E E, SARL",94,401196]
["L A I T E R I E  LE  S E M E U R, SARL",95,401428]
["LA PLATFORME DE L'INDUSTERIE SARL",96,401434]
["M A G H R E B  EMBALLAGE, SPA",{"$f":"ROW()-1","v":97},401172]
["M A X I  STORE AGRO TRADING, EURL",98,401274]
["M A X I M INDUSTRIAL SERVICES, SARL",99,404203]
["M E D I U S EMBALLAGE, SPA AIN BENIAN",100,401112]
["M E Z H O U D I  Y O U C E F",101,401432]
["M E Z I N E  BOUDJEMA, ETS",102,401702]
["M I C A L, SARL",103,401695]
["M I C A L, SARL",104,404195]
["M I L O U D I - MOURAD M.DINE, ENTREPRISE",105,404177]
["M I T I M A  EMBALLAGE, SARL",106,401141]
["M O U L I N  S A Y A H  A L I ORAN",107,401430]
["M O U L I N S  DE LA CHORFA, SPA",108,401415]
["M O U Z A I A   PLASTIQUE, SARL",109,401174]
["MAGHREB EMBALLAGE",110,403172]
["MEDIUS EMBALLAGE SPA",111,403112]
["N A C H C O FOOD",112,401433]
["N A D A T E K SARL",113,401448]
["N A D A T E K, SARL",114,401638]
["N E O F A R, SARL",115,401132]
["N E V I A L  IMPORT EXPORT, SARL",116,401257]
["N L  K I M Y A, SARL",117,401438]
["N U M I D E X, SARL",118,404201]
["N U M I D I S, IMPRIMERIE",119,401697]
["O M N I C H E M, SARL",120,401221]
["O P R E D  IMP./EXP., SARL",121,401751]
["O P T I M A R O M E, EURL",122,401248]
["O R K I L A  ALGERIE, SPA",123,401205]
["O V O -  M E D I T E R R A  N E E, EURL",124,401151]
["O V O - G I D K Y, SARL",125,401147]
["O V O C U P, EURL",126,401442]
["OUEST IMPORT, BERRAHAL GPE, SPA",127,401343]
["P A C K I N T S.R.L - ITALIE",128,401403]
["P H O B O S, EURL",{"$f":"ROW()-1","v":129},401227]
["P L A N E T E  MESURE, EQUIPEMENTS",130,404182]
["P R A T I C  EMBALLAGE, SARL",131,401142]
["P R I N T  P L U S  O N E, SARL",132,401108]
["P R O C U B E, SARL",133,401422]
["P R O D E L A C, SARL",134,401285]
["P R O F I N T E C, EURL",135,404115]
["P R O LYSA EURL",136,401427]
["P Y  A T L A S, SARL",137,404167]
["R A C H I LAKHDAR",138,401107]
["R A C H I LAKHDAR, ELECTRO-MENAGER",139,401726]
["R A D I M E D GROS,EURL",140,401251]
["R A Y A N  HYGIENE SCES, SARL",141,401226]
["R E D  S E A  INVESTMENT, SARL",142,401246]
["R I C A R D O  MOLINA  ALGERIE, SARL",143,401292]
["S A B R I  AGRO INDUSTRIES, SARL",144,401165]
["S A D E G - D D  BOUMERDES, SPA",145,401900]
["S C H N E I D E R  ELECTRIC, SARL",146,404141]
["S C I E N T I  L A B O, SARL",147,401237]
["S I P C A, SARL",148,401213]
["S I R  I M P R I M E R I E, SARL",149,401133]
["S I T T E L L E INDUSTRIELS, SARL",150,401421]
["S O D I C H N, SARL",151,401349]
["S O G I C L I M, SARL",152,404198]
["S T R M, EURL",153,401244]
["T A B A R O U T  ABDENOUR",154,401711]
["T A G U E M O U T  NACIRA, ETS",155,401713]
["T E C H N I FROID, SNC",156,404193]
["T E C H N I M A T I C, SARL",157,401231]
["T E C N O  P A C K  ITALIE",158,404903]
["T H E R M O P L A S T, SARL",159,401130]
["T R A N S P A P,",160,401444]
["V E R A F L E X, EURL",161,401752]
["Z E B B O U D J  AMINE, ETP",162,404209]
["Z O U R D A N I  SALIM",163,401686]
["Z W I N E  D I S T R A, EURL",164,401350]

{"sheet":"RECAP 01-2022","index":2,"n_rows":22,"n_cols":11,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,10]]}
[{"$f":"DONNEES!G3","v":"Sarl, ISO 9 INTERNATIONAL          :      LISTE DES FACTURES FOURNISSEURS       :          EXERCICE  2022"}]
["N°.","Fournisseurs","N° \n Facture","Type","Date \nFacture","Mode  de\nRèglement","Total\nHT","Montant\nTVA","Timbre","Autres","Montant\nTTC"]
[{"$f":"Tableau4[[#This Row],[N°.]]","v":1},{"$f":"Tableau4[[#This Row],[Fournisseurs]]","v":"G R O S  BERRAHAL GROUP, SPA"},{"$f":"Tableau4[[#This Row],[N° \n Facture]]","v":"F 553"},{"$f":"Tableau4[[#This Row],[Type]]","v":"Services"},{"$f":"Tableau4[[#This Row],[Date \nFacture]]","v":"2022-01-30"},{"$f":"Tableau4[[#This Row],[Mode  de\nRèglement]]","v":"Par chèque"},{"$f":"Tableau4[[#This Row],[Total\nHT]]","v":18753},{"$f":"Tableau4[[#This Row],[Montant\nTVA]]","v":3563.07},{"$f":"Tableau4[[#This Row],[Timbre]]","v":0},{"$f":"Tableau4[[#This Row],[Autres]]","v":0},{"$f":"Tableau4[[#This Row],[Montant\nTTC]]","v":22316.07}]
[{"$f":"Tableau4[[#This Row],[N°.]]","v":2},{"$f":"Tableau4[[#This Row],[Fournisseurs]]","v":"P A C K I N T S.R.L - ITALIE"},{"$f":"Tableau4[[#This Row],[N° \n Facture]]","v":"F 543"},{"$f":"Tableau4[[#This Row],[Type]]","v":"Achats MP"},{"$f":"Tableau4[[#This Row],[Date \nFacture]]","v":"2022-01-31"},{"$f":"Tableau4[[#This Row],[Mode  de\nRèglement]]","v":"Espèce"},{"$f":"Tableau4[[#This Row],[Total\nHT]]","v":122868},{"$f":"Tableau4[[#This Row],[Montant\nTVA]]","v":23344.929999999997},{"$f":"Tableau4[[#This Row],[Timbre]]","v":1461.9992999999999},{"$f":"Tableau4[[#This Row],[Autres]]","v":200},{"$f":"Tableau4[[#This Row],[Montant\nTTC]]","v":147874.92929999999}]
[{"$f":"Tableau4[[#This Row],[N°.]]","v":3},{"$f":"Tableau4[[#This Row],[Fournisseurs]]","v":"G R O S  BERRAHAL GROUP, SPA"},{"$f":"Tableau4[[#This Row],[N° \n Facture]]","v":"F 545"},{"$f":"Tableau4[[#This Row],[Type]]","v":"Autres Achats Stockés"},{"$f":"Tableau4[[#This Row],[Date \nFacture]]","v":"2022-02-28"},{"$f":"Tableau4[[#This Row],[Mode  de\nRèglement]]","v":"Espèce"},{"$f":"Tableau4[[#This Row],[Total\nHT]]","v":564332},{"$f":"Tableau4[[#This Row],[Montant\nTVA]]","v":107223.08},{"$f":"Tableau4[[#This Row],[Timbre]]","v":2500},{"$f":"Tableau4[[#This Row],[Autres]]","v":0},{"$f":"Tableau4[[#This Row],[Montant\nTTC]]","v":674055.08}]
[{"$f":"Tableau4[[#This Row],[N°.]]","v":4},{"$f":"Tableau4[[#This Row],[Fournisseurs]]","v":"AASTED  ABS  DANEMARK"},{"$f":"Tableau4[[#This Row],[N° \n Facture]]","v":"F 549"},{"$f":"Tableau4[[#This Row],[Type]]","v":"Achats non stockés"},{"$f":"Tableau4[[#This Row],[Date \nFacture]]","v":"2022-03-31"},{"$f":"Tableau4[[#This Row],[Mode  de\nRèglement]]","v":"Espèce"},{"$f":"Tableau4[[#This Row],[Total\nHT]]","v":50000000},{"$f":"Tableau4[[#This Row],[Montant\nTVA]]","v":9500000},{"$f":"Tableau4[[#This Row],[Timbre]]","v":2500},{"$f":"Tableau4[[#This Row],[Autres]]","v":0},{"$f":"Tableau4[[#This Row],[Montant\nTTC]]","v":59502500}]
[{"$f":"Tableau4[[#This Row],[N°.]]","v":5},{"$f":"Tableau4[[#This Row],[Fournisseurs]]","v":"M A G H R E B  EMBALLAGE, SPA"},{"$f":"Tableau4[[#This Row],[N° \n Facture]]","v":"F 550"},{"$f":"Tableau4[[#This Row],[Type]]","v":"Achats MP"},{"$f":"Tableau4[[#This Row],[Date \nFacture]]","v":"2022-04-30"},{"$f":"Tableau4[[#This Row],[Mode  de\nRèglement]]","v":"Verssement"},{"$f":"Tableau4[[#This Row],[Total\nHT]]","v":12762},{"$f":"Tableau4[[#This Row],[Montant\nTVA]]","v":2424.7800000000002},{"$f":"Tableau4[[#This Row],[Timbre]]","v":0},{"$f":"Tableau4[[#This Row],[Autres]]","v":0},{"$f":"Tableau4[[#This Row],[Montant\nTTC]]","v":15186.78}]
[{"$f":"Tableau4[[#This Row],[N°.]]","v":6},{"$f":"Tableau4[[#This Row],[Fournisseurs]]","v":"AASTED  ABS  DANEMARK"},{"$f":"Tableau4[[#This Row],[N° \n Facture]]","v":"F 547"},{"$f":"Tableau4[[#This Row],[Type]]","v":"Immobilisations"},{"$f":"Tableau4[[#This Row],[Date \nFacture]]","v":"2022-05-15"},{"$f":"Tableau4[[#This Row],[Mode  de\nRèglement]]","v":"Espèce"},{"$f":"Tableau4[[#This Row],[Total\nHT]]","v":15628},{"$f":"Tableau4[[#This Row],[Montant\nTVA]]","v":2969.32},{"$f":"Tableau4[[#This Row],[Timbre]]","v":185.97319999999999},{"$f":"Tableau4[[#This Row],[Autres]]","v":0},{"$f":"Tableau4[[#This Row],[Montant\nTTC]]","v":18783.2932}]
[{"$f":"Tableau4[[#This Row],[N°.]]","v":7},{"$f":"Tableau4[[#This Row],[Fournisseurs]]","v":"E N A S E L, SPA"},{"$f":"Tableau4[[#This Row],[N° \n Facture]]","v":"F 553"},{"$f":"Tableau4[[#This Row],[Type]]","v":"Loyer leasing"},{"$f":"Tableau4[[#This Row],[Date \nFacture]]","v":"2022-07-30"},{"$f":"Tableau4[[#This Row],[Mode  de\nRèglement]]","v":"A Terme"},{"$f":"Tableau4[[#This Row],[Total\nHT]]","v":543287},{"$f":"Tableau4[[#This Row],[Montant\nTVA]]","v":103224.53},{"$f":"Tableau4[[#This Row],[Timbre]]","v":0},{"$f":"Tableau4[[#This Row],[Autres]]","v":0},{"$f":"Tableau4[[#This Row],[Montant\nTTC]]","v":646511.53}]
[{"$f":"Tableau4[[#This Row],[N°.]]","v":8},{"$f":"Tableau4[[#This Row],[Fournisseurs]]","v":"K E R M O U D  ACHOUR, ETS"},{"$f":"Tableau4[[#This Row],[N° \n Facture]]","v":"F 546"},{"$f":"Tableau4[[#This Row],[Type]]","v":"Services"},{"$f":"Tableau4[[#This Row],[Date \nFacture]]","v":"2022-08-05"},{"$f":"Tableau4[[#This Row],[Mode  de\nRèglement]]","v":"Espèce"},{"$f":"Tableau4[[#This Row],[Total\nHT]]","v":10000000},{"$f":"Tableau4[[#This Row],[Montant\nTVA]]","v":1900000},{"$f":"Tableau4[[#This Row],[Timbre]]","v":2500},{"$f":"Tableau4[[#This Row],[Autres]]","v":0},{"$f":"Tableau4[[#This Row],[Montant\nTTC]]","v":11902500}]
[{"$f":"Tableau4[[#This Row],[N°.]]","v":9},{"$f":"Tableau4[[#This Row],[Fournisseurs]]","v":"F O U R N I S S E U R S  N/SOUMIS A TVA"},{"$f":"Tableau4[[#This Row],[N° \n Facture]]","v":"F 551"},{"$f":"Tableau4[[#This Row],[Type]]","v":"Services"},{"$f":"Tableau4[[#This Row],[Date \nFacture]]","v":"2022-09-05"},{"$f":"Tableau4[[#This Row],[Mode  de\nRèglement]]","v":"Par chèque"},{"$f":"Tableau4[[#This Row],[Total\nHT]]","v":6765921},{"$f":"Tableau4[[#This Row],[Montant\nTVA]]","v":1285524.99},{"$f":"Tableau4[[#This Row],[Timbre]]","v":0},{"$f":"Tableau4[[#This Row],[Autres]]","v":0},{"$f":"Tableau4[[#This Row],[Montant\nTTC]]","v":8051445.9900000002}]
[{"$f":"Tableau4[[#This Row],[N°.]]","v":10},{"$f":"Tableau4[[#This Row],[Fournisseurs]]","v":"K A R I M  IMPRIM. MODERNE, EURL"},{"$f":"Tableau4[[#This Row],[N° \n Facture]]","v":"F 548"},{"$f":"Tableau4[[#This Row],[Type]]","v":"Loyer leasing"},{"$f":"Tableau4[[#This Row],[Date \nFacture]]","v":"2022-09-25"},{"$f":"Tableau4[[#This Row],[Mode  de\nRèglement]]","v":"Virement"},{"$f":"Tableau4[[#This Row],[Total\nHT]]","v":188822},{"$f":"Tableau4[[#This Row],[Montant\nTVA]]","v":35876.18},{"$f":"Tableau4[[#This Row],[Timbre]]","v":0},{"$f":"Tableau4[[#This Row],[Autres]]","v":0},{"$f":"Tableau4[[#This Row],[Montant\nTTC]]","v":224698.18}]
[{"$f":"Tableau4[[#This Row],[N°.]]","v":11},{"$f":"Tableau4[[#This Row],[Fournisseurs]]","v":"D I S T R I  F I R S T, EURL"},{"$f":"Tableau4[[#This Row],[N° \n Facture]]","v":"F 552"},{"$f":"Tableau4[[#This Row],[Type]]","v":"Immobilisations"},{"$f":"Tableau4[[#This Row],[Date \nFacture]]","v":"2022-10-29"},{"$f":"Tableau4[[#This Row],[Mode  de\nRèglement]]","v":"Espèce (TEMP.)"},{"$f":"Tableau4[[#This Row],[Total\nHT]]","v":1},{"$f":"Tableau4[[#This Row],[Montant\nTVA]]","v":0.19},{"$f":"Tableau4[[#This Row],[Timbre]]","v":0},{"$f":"Tableau4[[#This Row],[Autres]]","v":0},{"$f":"Tableau4[[#This Row],[Montant\nTTC]]","v":1.19}]
[{"$f":"Tableau4[[#This Row],[N°.]]","v":12},{"$f":"Tableau4[[#This Row],[Fournisseurs]]","v":0},{"$f":"Tableau4[[#This Row],[N° \n Facture]]","v":0},{"$f":"Tableau4[[#This Row],[Type]]","v":0},{"$f":"Tableau4[[#This Row],[Date \nFacture]]","v":"00:00:00"},{"$f":"Tableau4[[#This Row],[Mode  de\nRèglement]]","v":"Par chèque"},{"$f":"Tableau4[[#This Row],[Total\nHT]]","v":-42},{"$f":"Tableau4[[#This Row],[Montant\nTVA]]","v":0},{"$f":"Tableau4[[#This Row],[Timbre]]","v":0},{"$f":"Tableau4[[#This Row],[Autres]]","v":0},{"$f":"Tableau4[[#This Row],[Montant\nTTC]]","v":-42}]
[{"$f":"Tableau4[[#This Row],[N°.]]","v":13},{"$f":"Tableau4[[#This Row],[Fournisseurs]]","v":0},{"$f":"Tableau4[[#This Row],[N° \n Facture]]","v":0},{"$f":"Tableau4[[#This Row],[Type]]","v":0},{"$f":"Tableau4[[#This Row],[Date \nFacture]]","v":"00:00:00"},{"$f":"Tableau4[[#This Row],[Mode  de\nRèglement]]","v":0},{"$f":"Tableau4[[#This Row],[Total\nHT]]","v":0},{"$f":"Tableau4[[#This Row],[Montant\nTVA]]","v":0},{"$f":"Tableau4[[#This Row],[Timbre]]","v":0},{"$f":"Tableau4[[#This Row],[Autres]]","v":0},{"$f":"Tableau4[[#This Row],[Montant\nTTC]]","v":0}]
[{"$f":"Tableau4[[#This Row],[N°.]]","v":14},{"$f":"Tableau4[[#This Row],[Fournisseurs]]","v":0},{"$f":"Tableau4[[#This Row],[N° \n Facture]]","v":0},{"$f":"Tableau4[[#This Row],[Type]]","v":0},{"$f":"Tableau4[[#This Row],[Date \nFacture]]","v":"00:00:00"},{"$f":"Tableau4[[#This Row],[Mode  de\nRèglement]]","v":0},{"$f":"Tableau4[[#This Row],[Total\nHT]]","v":0},{"$f":"Tableau4[[#This Row],[Montant\nTVA]]","v":0},{"$f":"Tableau4[[#This Row],[Timbre]]","v":0},{"$f":"Tableau4[[#This Row],[Autres]]","v":0},{"$f":"Tableau4[[#This Row],[Montant\nTTC]]","v":0}]
[{"$f":"Tableau4[[#This Row],[N°.]]","v":15},{"$f":"Tableau4[[#This Row],[Fournisseurs]]","v":0},{"$f":"Tableau4[[#This Row],[N° \n Facture]]","v":0},{"$f":"Tableau4[[#This Row],[Type]]","v":0},{"$f":"Tableau4[[#This Row],[Date \nFacture]]","v":"00:00:00"},{"$f":"Tableau4[[#This Row],[Mode  de\nRèglement]]","v":0},{"$f":"Tableau4[[#This Row],[Total\nHT]]","v":0},{"$f":"Tableau4[[#This Row],[Montant\nTVA]]","v":0},{"$f":"Tableau4[[#This Row],[Timbre]]","v":0},{"$f":"Tableau4[[#This Row],[Autres]]","v":0},{"$f":"Tableau4[[#This Row],[Montant\nTTC]]","v":0}]
[{"$f":"Tableau4[[#This Row],[N°.]]","v":16},{"$f":"Tableau4[[#This Row],[Fournisseurs]]","v":0},{"$f":"Tableau4[[#This Row],[N° \n Facture]]","v":0},{"$f":"Tableau4[[#This Row],[Type]]","v":0},{"$f":"Tableau4[[#This Row],[Date \nFacture]]","v":"00:00:00"},{"$f":"Tableau4[[#This Row],[Mode  de\nRèglement]]","v":0},{"$f":"Tableau4[[#This Row],[Total\nHT]]","v":0},{"$f":"Tableau4[[#This Row],[Montant\nTVA]]","v":0},{"$f":"Tableau4[[#This Row],[Timbre]]","v":0},{"$f":"Tableau4[[#This Row],[Autres]]","v":0},{"$f":"Tableau4[[#This Row],[Montant\nTTC]]","v":0}]
[{"$f":"Tableau4[[#This Row],[N°.]]","v":17},{"$f":"Tableau4[[#This Row],[Fournisseurs]]","v":0},{"$f":"Tableau4[[#This Row],[N° \n Facture]]","v":0},{"$f":"Tableau4[[#This Row],[Type]]","v":0},{"$f":"Tableau4[[#This Row],[Date \nFacture]]","v":"00:00:00"},{"$f":"Tableau4[[#This Row],[Mode  de\nRèglement]]","v":0},{"$f":"Tableau4[[#This Row],[Total\nHT]]","v":0},{"$f":"Tableau4[[#This Row],[Montant\nTVA]]","v":0},{"$f":"Tableau4[[#This Row],[Timbre]]","v":0},{"$f":"Tableau4[[#This Row],[Autres]]","v":0},{"$f":"Tableau4[[#This Row],[Montant\nTTC]]","v":0}]
[{"$f":"Tableau4[[#This Row],[N°.]]","v":18},{"$f":"Tableau4[[#This Row],[Fournisseurs]]","v":0},{"$f":"Tableau4[[#This Row],[N° \n Facture]]","v":0},{"$f":"Tableau4[[#This Row],[Type]]","v":0},{"$f":"Tableau4[[#This Row],[Date \nFacture]]","v":"00:00:00"},{"$f":"Tableau4[[#This Row],[Mode  de\nRèglement]]","v":0},{"$f":"Tableau4[[#This Row],[Total\nHT]]","v":0},{"$f":"Tableau4[[#This Row],[Montant\nTVA]]","v":0},{"$f":"Tableau4[[#This Row],[Timbre]]","v":0},{"$f":"Tableau4[[#This Row],[Autres]]","v":0},{"$f":"Tableau4[[#This Row],[Montant\nTTC]]","v":0}]
[{"$f":"Tableau4[[#This Row],[N°.]]","v":19},{"$f":"Tableau4[[#This Row],[Fournisseurs]]","v":0},{"$f":"Tableau4[[#This Row],[N° \n Facture]]","v":0},{"$f":"Tableau4[[#This Row],[Type]]","v":0},{"$f":"Tableau4[[#This Row],[Date \nFacture]]","v":"00:00:00"},{"$f":"Tableau4[[#This Row],[Mode  de\nRèglement]]","v":0},{"$f":"Tableau4[[#This Row],[Total\nHT]]","v":0},{"$f":"Tableau4[[#This Row],[Montant\nTVA]]","v":0},{"$f":"Tableau4[[#This Row],[Timbre]]","v":0},{"$f":"Tableau4[[#This Row],[Autres]]","v":0},{"$f":"Tableau4[[#This Row],[Montant\nTTC]]","v":0}]
[null,"Total",null,null,null,null,{"$f":"SUBTOTAL(109,Tableau5[Total\nHT])","v":68232332},{"$f":"'JOURNAL 01-2022'!M22","v":12964151.069999998},{"$f":"'JOURNAL 01-2022'!O22","v":9147.9724999999999},{"$f":"'JOURNAL 01-2022'!P22","v":200},{"$f":"'JOURNAL 01-2022'!Q22","v":81205831.042500004}]

{"sheet":"JOURNAL 01-2022","index":3,"n_rows":22,"n_cols":19,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[{"$f":"+DONNEES!G2","v":"Sarl, ISO 9 INTERNATIONAL          :      SUIVI DES FACTURES FOURNISSEURS       :          EXERCICE  2022"}]
["N°.","Code\nCompta","Fournisseurs","N° \n Facture","Type","Date \nFacture","Mode  de\nRèglement","Montant \nHT","Remise","Total\nHT","Code\nTVA","Régul\nTVA","Montant\nTVA","Régul\nTmbr.","Timbre","Autres","Montant\nTTC","Échéance \nFacture","Date \nde Paiement"]
[{"$f":"ROW()-2","v":1},{"$f":"IFERROR(VLOOKUP(C3,Tableau1[],3,FALSE),\"\")","v":401344},"G R O S  BERRAHAL GROUP, SPA","F 553","Services","2022-01-30","Par chèque",18753,null,{"$f":"H3-I3","v":18753},0.19,null,{"$f":"L3+ROUND(J3*K3,2)","v":3563.07},null,{"$f":"IF(G3=\"Espèce\",MIN((J3+M3)*0.01+N3,2500),0)","v":0},null,{"$f":"P3+O3+M3+J3","v":22316.07}]
[2,{"$f":"IFERROR(VLOOKUP(C4,Tableau1[],3,FALSE),\"\")","v":401403},"P A C K I N T S.R.L - ITALIE","F 543","Achats MP","2022-01-31","Espèce",123543,675,122868,0.19,0.01,23344.929999999997,-0.13,1461.9992999999999,200,147874.92929999999]
[3,{"$f":"IFERROR(VLOOKUP(C5,Tableau1[],3,FALSE),\"\")","v":401344},"G R O S  BERRAHAL GROUP, SPA","F 545","Autres Achats Stockés","2022-02-28","Espèce",564332,null,564332,0.19,null,107223.08,null,2500,null,674055.08]
[4,{"$f":"IFERROR(VLOOKUP(C6,Tableau1[],3,FALSE),\"\")","v":404906},"AASTED  ABS  DANEMARK","F 549","Achats non stockés","2022-03-31","Espèce",50000000,null,50000000,0.19,null,9500000,null,2500,null,59502500]
[5,{"$f":"IFERROR(VLOOKUP(C7,Tableau1[],3,FALSE),\"\")","v":401172},"M A G H R E B  EMBALLAGE, SPA","F 550","Achats MP","2022-04-30","Verssement",12762,null,12762,0.19,null,2424.7800000000002,null,0,null,15186.78]
[6,{"$f":"IFERROR(VLOOKUP(C8,Tableau1[],3,FALSE),\"\")","v":404906},"AASTED  ABS  DANEMARK","F 547","Immobilisations","2022-05-15","Espèce",15628,null,15628,0.19,null,2969.32,null,185.97319999999999,null,18783.2932]
[7,{"$f":"IFERROR(VLOOKUP(C9,Tableau1[],3,FALSE),\"\")","v":401113},"E N A S E L, SPA","F 553","Loyer leasing","2022-07-30","A Terme",543287,null,543287,0.19,null,103224.53,null,0,null,646511.53]
[8,{"$f":"IFERROR(VLOOKUP(C10,Tableau1[],3,FALSE),\"\")","v":401696},"K E R M O U D  ACHOUR, ETS","F 546","Services","2022-08-05","Espèce",10000000,null,10000000,0.19,null,1900000,null,2500,null,11902500]
[9,{"$f":"IFERROR(VLOOKUP(C11,Tableau1[],3,FALSE),\"\")","v":401500},"F O U R N I S S E U R S  N/SOUMIS A TVA","F 551","Services","2022-09-05","Par chèque",6765921,null,6765921,0.19,null,1285524.99,null,0,null,8051445.9900000002]
[10,{"$f":"IFERROR(VLOOKUP(C12,Tableau1[],3,FALSE),\"\")","v":401139},"K A R I M  IMPRIM. MODERNE, EURL","F 548","Loyer leasing","2022-09-25","Virement",188822,null,188822,0.19,null,35876.18,null,0,null,224698.18]
[11,{"$f":"IFERROR(VLOOKUP(C13,Tableau1[],3,FALSE),\"\")","v":401287},"D I S T R I  F I R S T, EURL","F 552","Immobilisations","2022-10-29","Espèce (TEMP.)",1,null,1,0.19,null,0.19,null,0,null,1.19]
[12,{"$f":"IFERROR(VLOOKUP(C14,Tableau1[],3,FALSE),\"\")","v":""},null,null,null,null,"Par chèque",2,44,-42,null,null,0,null,0,null,-42]
[13,{"$f":"IFERROR(VLOOKUP(C15,Tableau1[],3,FALSE),\"\")","v":""},null,null,null,null,null,null,null,0,null,null,0,null,0,null,0]
[14,{"$f":"IFERROR(VLOOKUP(C16,Tableau1[],3,FALSE),\"\")","v":""},null,null,null,null,null,null,null,0,null,null,0,null,0,null,0]
[15,{"$f":"IFERROR(VLOOKUP(C17,Tableau1[],3,FALSE),\"\")","v":""},null,null,null,null,null,null,null,0,null,null,0,null,0,null,0]
[16,{"$f":"IFERROR(VLOOKUP(C18,Tableau1[],3,FALSE),\"\")","v":""},null,null,null,null,null,null,null,0,null,null,0,null,0,null,0]
[17,{"$f":"IFERROR(VLOOKUP(C19,Tableau1[],3,FALSE),\"\")","v":""},null,null,null,null,null,null,null,0,null,null,0,null,0,null,0]
[{"$f":"ROW()-2","v":18},{"$f":"IFERROR(VLOOKUP(C20,Tableau1[],3,FALSE),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"H20-I20","v":0},null,null,{"$f":"L20+ROUND(J20*K20,2)","v":0},null,{"$f":"IF(G20=\"Espèce\",MIN((J20+M20)*0.01+N20,2500),0)","v":0},null,{"$f":"P20+O20+M20+J20","v":0}]
[{"$f":"ROW()-2","v":19},{"$f":"IFERROR(VLOOKUP(C21,Tableau1[],3,FALSE),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"H21-I21","v":0},null,null,{"$f":"L21+ROUND(J21*K21,2)","v":0},null,{"$f":"IF(G21=\"Espèce\",MIN((J21+M21)*0.01+N21,2500),0)","v":0},null,{"$f":"P21+O21+M21+J21","v":0}]
[null,null,"Total",null,null,null,null,{"$f":"SUBTOTAL(109,Tableau4[Montant \nHT])","v":68233051},{"$f":"SUBTOTAL(109,Tableau4[Remise])","v":719},{"$f":"SUBTOTAL(109,Tableau4[Total\nHT])","v":68232332},null,{"$f":"SUBTOTAL(109,Tableau4[Régul\nTVA])","v":0.01},{"$f":"SUBTOTAL(109,Tableau4[Montant\nTVA])","v":12964151.069999998},{"$f":"SUBTOTAL(109,Tableau4[Régul\nTmbr.])","v":-0.13},{"$f":"SUBTOTAL(109,Tableau4[Timbre])","v":9147.9724999999999},{"$f":"SUBTOTAL(109,Tableau4[Autres])","v":200},{"$f":"SUBTOTAL(109,Tableau4[Montant\nTTC])","v":81205831.042500004}]

{"sheet":"MOTS DE PASSE","index":4,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"MOT DE PASSE",18163515]
[]
[]
[null,null,"Application.ExecuteExcel4Macro \"SHOW.TOOLBAR(\"\"Ribbon\"\",False)"]