{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Facturier d'Entrées","CoordonnéesClients","Facture","Historique_facture","JournaldesVentes"],"not_rendered":{"charts":0,"images":1,"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":"Facturier d'Entrées","index":0,"n_rows":35,"n_cols":15,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,14,1,14],[1,0,2,0],[1,1,2,1],[1,2,2,2],[0,3,2,3],[1,4,2,4],[0,0,0,2],[0,5,0,6],[0,7,0,10],[0,11,0,12]]}
["FACTURIER DES ACHATS",null,null,"Total facture +    ou note crédit - avec TVA % ",null,"Trimestre 1.",null,"NET de TVA",null,null,null,"BE",null,null,"Total de contrôle"]
["Date","N°","Fournisseurs",null,"00    06    21","Total TVA","Total sans TVA","Marchandises","Frais","Invest.","Privé","TVA non récupérable","TVA récupérable"]
[null,null,null,null,null,null,null,81,82,83,null,null,59]
["2020-06-12",1,"Machin",1000,21,{"$f":"D4-G4","v":173.55371900826447},{"$f":"IF(E4=21,D4/1.21,IF(E4=6,D4/1.06,D4/1))","v":826.44628099173553},826.45,null,null,null,{"$f":"F4-M4","v":3.7190082644542599E-3},173.55,null,{"$f":"H4+I4+J4+K4+L4+M4","v":1000.0037190082644}]
[null,2,"Chose",500,6,{"$f":"D5-G5","v":28.301886792452876},{"$f":"IF(E5=21,D5/1.21,IF(E5=6,D5/1.06,D5/1))","v":471.69811320754712},null,null,471.7,null,{"$f":"F5-M5","v":14.151886792452876},14.15,null,{"$f":"H5+I5+J5+K5+L5+M5","v":500.00188679245286}]
[null,3,"Proximus",187,21,32.454545454545439,154.54545454545456,null,154.55000000000001,null,null,4.5454545454362005E-3,32.450000000000003,null,187.00454545454545]
[null,4,"Brico",65,21,11.280991735537185,53.719008264462815,null,null,null,53.72,11.280991735537185,0,null,65.000991735537184]
[null,null,null,null,null,0,0,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,0,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,0,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,0,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"CoordonnéesClients","index":1,"n_rows":57,"n_cols":10,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
["NumClient","Nom","Prénom","Adresse","Code Postal","Localité","N° TVA","Téléphone","GSM","Email"]
[{"$f":"LEFT(B2,3)&LEFT(C2,1)","v":"KOUD"},"KOUSEN","Daniel","rue Buisson à la fleur, 91",4537,"Verlaine","BE0752.303.492","04/259.45.55","0495/23.05.74","daniel.kousen@skynet.be"]
[{"$f":"LEFT(B3,3)&LEFT(C3,1)","v":"ANCF"},"ANCION","Freddy"]
[{"$f":"LEFT(B4,3)&LEFT(C4,1)","v":"BOVE"},"BOVEROUL","Eric"]
[{"$f":"LEFT(B5,3)&LEFT(C5,1)","v":"BUTR"},"BUTERA","Raphaël"]
[{"$f":"LEFT(B6,3)&LEFT(C6,1)","v":"BUTF"},"BUTERA","Fréderic"]
[{"$f":"LEFT(B7,3)&LEFT(C7,1)","v":"CER"},"CERTINERGIE"]
[{"$f":"LEFT(B8,3)&LEFT(C8,1)","v":"CONP"},"CONING","Patrick"]
[{"$f":"LEFT(B9,3)&LEFT(C9,1)","v":"COOP"},"COONAERT","Philippe"]
[{"$f":"LEFT(B10,3)&LEFT(C10,1)","v":"DAOE"},"DAOUT","Egide","rue Trixhelette, 81",4537,"Verlaine",null,"04/259,43,84"]
[{"$f":"LEFT(B11,3)&LEFT(C11,1)","v":"DEBP"},"DEBECKER","Philippe"]
[{"$f":"LEFT(B12,3)&LEFT(C12,1)","v":"DEBL"},"DEBLIQUIS","Luc"]
[{"$f":"LEFT(B13,3)&LEFT(C13,1)","v":"DELP"},"DELVAUX","Patrick"]
[{"$f":"LEFT(B14,3)&LEFT(C14,1)","v":"det"},"dethioux"]
[{"$f":"LEFT(B15,3)&LEFT(C15,1)","v":"DEVH"},"DEVIGNE","Henry"]
[{"$f":"LEFT(B16,3)&LEFT(C16,1)","v":"D'HE"},"D'HOE","Eric",null,4537,"Verlaine"]
[{"$f":"LEFT(B17,3)&LEFT(C17,1)","v":"DUCL"},"DUCHENE","Laurent"]
[{"$f":"LEFT(B18,3)&LEFT(C18,1)","v":"DupC"},"Dupont","Charles","rue du Pont,28",null,"Villers le Bouillet","N/A","04/12345678"]
[{"$f":"LEFT(B19,3)&LEFT(C19,1)","v":"EVRR"},"EVRARD ","Roland"]
[{"$f":"LEFT(B20,3)&LEFT(C20,1)","v":"FEET"},"FEET","Thomas"]
[{"$f":"LEFT(B21,3)&LEFT(C21,1)","v":"FOUS"},"FOUCART","Sophie"]
[{"$f":"LEFT(B22,3)&LEFT(C22,1)","v":"GIAG"},"GIANQUINTO","Gloria"]
[{"$f":"LEFT(B23,3)&LEFT(C23,1)","v":"GRIB"},"GRINDORGE","Benoit"]
[{"$f":"LEFT(B24,3)&LEFT(C24,1)","v":"HALH"},"HALIN","Hervé"]
[{"$f":"LEFT(B25,3)&LEFT(C25,1)","v":"JOLG"},"JOLLY","Geoffrey"]
[{"$f":"LEFT(B26,3)&LEFT(C26,1)","v":"LABD"},"LABYE","Didier"]
[{"$f":"LEFT(B27,3)&LEFT(C27,1)","v":"LAML"},"LAMBERTY","Lionel"]
[{"$f":"LEFT(B28,3)&LEFT(C28,1)","v":"LAMM"},"LAMBERTY","Maud"]
[{"$f":"LEFT(B29,3)&LEFT(C29,1)","v":"LAMA"},"LAMOUREUX","Alexandre"]
[{"$f":"LEFT(B30,3)&LEFT(C30,1)","v":"LECM"},"LECOMPTE","Michel"]
[{"$f":"LEFT(B31,3)&LEFT(C31,1)","v":"LEFA"},"LEFEBVRE","Alain"]
[{"$f":"LEFT(B32,3)&LEFT(C32,1)","v":"LHEL"},"LHEUREUX","Lionel"]
[{"$f":"LEFT(B33,3)&LEFT(C33,1)","v":"LHOA"},"LHOMME","Alain","rue Basse Marquet, 126",4470,"Stockay","BE 0651.346.684",null,"0475/50 13 12","locahomeparty@outlook.be"]
[{"$f":"LEFT(B34,3)&LEFT(C34,1)","v":"MARG"},"MARTINE","Georges"]
[{"$f":"LEFT(B35,3)&LEFT(C35,1)","v":"MATC"},"MATYN","Claude"]
[{"$f":"LEFT(B36,3)&LEFT(C36,1)","v":"MHVL"},"MHVAL","Lise"]
[{"$f":"LEFT(B37,3)&LEFT(C37,1)","v":"MOIG"},"MOISSERON","Gérard"]
[{"$f":"LEFT(B38,3)&LEFT(C38,1)","v":"MORC"},"MORSAINT","Claude","fils"]
[{"$f":"LEFT(B39,3)&LEFT(C39,1)","v":"MUSC"},"MUSIQUE","Catherine"]
[{"$f":"LEFT(B40,3)&LEFT(C40,1)","v":"NOV"},"NOVIAT"]
[{"$f":"LEFT(B41,3)&LEFT(C41,1)","v":"PAZG"},"PAZIENZA","Gauthier"]
[{"$f":"LEFT(B42,3)&LEFT(C42,1)","v":"REMA"},"REMONT","Alain"]
[{"$f":"LEFT(B43,3)&LEFT(C43,1)","v":"RIGA"},"RIGA","André"]
[{"$f":"LEFT(B44,3)&LEFT(C44,1)","v":"ROSE"},"ROSE","Eric"]
[{"$f":"LEFT(B45,3)&LEFT(C45,1)","v":"saa"},"sa","arkos"]
[{"$f":"LEFT(B46,3)&LEFT(C46,1)","v":"SAIJ"},"SAINTE","Jean-Christophe"]
[{"$f":"LEFT(B47,3)&LEFT(C47,1)","v":"SAID"},"SAINTE","Dominique"]
[{"$f":"LEFT(B48,3)&LEFT(C48,1)","v":"SAML"},"SAMSON","Luc"]
[{"$f":"LEFT(B49,3)&LEFT(C49,1)","v":"SON"},"SONVILLE"]
[{"$f":"LEFT(B50,3)&LEFT(C50,1)","v":"SOUN"},"SOUDAIN","Nadine"]
[{"$f":"LEFT(B51,3)&LEFT(C51,1)","v":"TOUM"},"TOURNIQUET","Madame"]
[{"$f":"LEFT(B52,3)&LEFT(C52,1)","v":"ULIM"},"ULIANA","Maxime"]
[{"$f":"LEFT(B53,3)&LEFT(C53,1)","v":"VAN"},"VAN DEN BERGH"]
[{"$f":"LEFT(B54,3)&LEFT(C54,1)","v":"WALL"},"WALLRAF","Lionel"]
[{"$f":"LEFT(B55,3)&LEFT(C55,1)","v":"WELP"},"WELKENHUZEN","Patrick"]
[{"$f":"LEFT(B56,3)&LEFT(C56,1)","v":"WOLA"},"WOLWERTZ","Alain"]
[{"$f":"LEFT(B57,3)&LEFT(C57,1)","v":"WUYJ"},"WUYTS","Jean-Luc"]

{"sheet":"Facture","index":2,"n_rows":45,"n_cols":7,"rows_kept":45,"cut":false,"hidden":false,"merged":[[26,2,26,4],[27,2,27,4],[28,2,28,4],[29,2,29,4],[30,2,30,4],[38,1,39,1],[14,2,14,3],[15,2,15,4],[16,2,16,4],[17,2,17,4],[18,2,18,4],[19,2,19,4],[20,2,20,4],[21,2,21,4],[22,2,22,4],[23,2,23,4],[24,2,24,4],[25,2,25,4],[31,2,31,4],[32,2,32,4],[33,2,33,4],[3,4,3,6],[4,4,4,6],[5,4,5,6],[6,4,6,6],[7,4,7,6]]}
[]
[]
[]
[null,null,null,null,"126. rue Basse Marquet"]
[null,null,null,null,"4470 Saint-Georges-sur-Meuse"]
[null,null,null,null,"Tél : 0475/50 13 12"]
[null,null,null,null,"TVA : BE 0651.346.684"]
[null,null,null,null,"Banque : BE29 1325 5148 6164"]
[]
["FACTURE N° ",192,null,"Nom :","LHOMME",{"$f":"IF(E10=\"\",\"\",VLOOKUP(E10,CoordonnéesClients!B2:J97,2,FALSE))","v":"Alain"}]
["TVA Client :",{"$f":"IF(VLOOKUP(E10,CoordonnéesClients!B2:G98,6,0)=\"\",\"N/A\",(VLOOKUP(E10,CoordonnéesClients!B2:G98,6,0)))","v":"BE 0651.346.684"},null,"Adresse :",{"$f":"IFERROR(VLOOKUP(E10,CoordonnéesClients,3,FALSE),\"\")","v":"rue Basse Marquet, 126"}]
["DATE :",{"$f":"TODAY()","v":"2023-01-13"},null,"CP+Localité",{"$f":"IFERROR(VLOOKUP(E10,CoordonnéesClients,4,FALSE),\"\")","v":4470},{"$f":"IFERROR(VLOOKUP(E10,CoordonnéesClients,5,FALSE),\"\")","v":"Stockay"}]
[null,null,null,"Tél :",{"$f":"(VLOOKUP(E10,CoordonnéesClients,8,FALSE))","v":"0475/50 13 12"}]
[]
["Référence","Qtés/Nbre Heures","Désignation",null,null,"Prix Unit. HTVA","Total HTVA"]
["x4658",1,"Déplacement Hotton",null,null,125,{"$f":"IF(B16=\"\",\"\",(B16*F16))","v":125}]
[null,6,"Heures prestation",null,null,45,{"$f":"IF(B17=\"\",\"\",(B17*F17))","v":270}]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
["Acompte 1",null,null,null,null,"Total HTVA",{"$f":"SUM(G16:G34)","v":395}]
["Acompte 2",null,null,null,null,"TVA 21%",{"$f":"G35*21%","v":82.95}]
["Acompte 3",null,null,null,null,"Total TVAC",{"$f":"G35+G36","v":477.95}]
["Acompte 4"]
["Solde:",{"$f":"G37-B35-B36-B37-B38","v":477.95}]
[]
["CONDITIONS : Les présentes conditions sont applicables à toutes nos livraisons et prestations. Passé le délai de 8 jours plus aucunes contestations ne sra recevable. "]
["Toutes nos factures sont payables au grand comptant. A défaut de paiement, il nous sera dù de plein droit et sans mise en demeure des intérêts conventionnels de 1,5%"]
["par mois depuis la date de la facture avec un montant minimum de 50  EUR. Seuls les tribunaux de Huy sont compétents en cas de litige. Pour tout facture d'un montant"]
["inférieur à 25 EUR; 1,24 EUR seront demandés pour frais administratifs."]
["GSM: 0475/50.13.12",null,null,null,"Mail:","locahomeparty@outlook,be"]

{"sheet":"Historique_facture","index":3,"n_rows":269,"n_cols":15,"rows_kept":269,"cut":false,"hidden":false,"merged":[]}
["FACTURE N° ","DATE :","Nom :","Prénom :","Adresse :","Code Postal :","Localité:","Tél :","Total HTVA","Total TVAC","facture payée","Date paiement","Solde"]
["Colonne1","Colonne2","Colonne3","Colonne4","Colonne5","Colonne6","Colonne7","Colonne8","Colonne9","Colonne10","Colonne11","Colonne12","Colonne13",null,{"$f":"IF(I3=0,\"\",IF(J3-K3=0,\"\",J3-K3))","v":""}]
["2020/001","2020-05-11","Kousen","Daniel","rue Buisson à la fleur, 91","4537 Verlaine",null,null,341,412.61,412.61,"2020-05-11",{"$f":"IF(I3=0,\"\",IF(J3-K3=0,\"Payé\",J3-K3))","v":"Payé"}]
[144,"2020-06-29",null,null,null,null,null,null,0,0,null,null,{"$f":"IF(I4=0,\"\",IF(J4-K4=0,\"Payé\",J4-K4))","v":""}]
[173,"2021-07-11","KOUSEN","Daniel","rue Buisson à la fleur, 91",4537,"Verlaine","0495/23.05.74",2925,3539.25,null,null,{"$f":"IF(I5=0,\"\",IF(J5-K5=0,\"Payé\",J5-K5))","v":3539.25}]
[174,"2021-07-11","KOUSEN","Daniel","rue Buisson à la fleur, 91",4537,"Verlaine","0495/23.05.74",1000,1210,null,null,1210]
[175,"2021-07-11","KOUSEN","Daniel","rue Buisson à la fleur, 91",4537,"Verlaine","0495/23.05.74",1200,1452,null,null,1452]
[176,"2021-07-11","KOUSEN","Daniel","rue Buisson à la fleur, 91",4537,"Verlaine","0495/23.05.74",1250,1512.5,null,null,1512.5]
[177,"2021-07-11","Dupont","Charles","rue du Pont,28",0,"Villers le Bouillet",0,1000,1210,null,null,1210]
[178,"2021-07-11","KOUSEN","Daniel","rue Buisson à la fleur, 91",4537,"Verlaine","0495/23.05.74",549.6,665.02,null,null,665.02]
[179,"2021-07-11","CERTINERGIE",0,0,0,0,0,270,326.7,null,null,326.7]
[180,"2021-07-12","CONING","Patrick",0,0,0,0,750,907.5,null,null,907.5]
[181,"2021-07-12","BUTERA","Raphaël",0,0,0,0,1542,1865.82,null,null,1865.82]
[182,"2021-07-12","CONING","Patrick",0,0,0,0,540,653.4,null,null,653.4]
[183,"2021-07-12","WOLWERTZ","Alain",0,0,0,0,679.8,822.56,null,null,822.56]
[184,"2021-07-12","KOUSEN","Daniel","rue Buisson à la fleur, 91",4537,"Verlaine","0495/23.05.74",311,376.31,null,null,376.31]
[185,"2021-07-12","LHOMME","Alain","rue Basse Marquet, 126",4470,"Stockay","0475/50 13 12",595,719.95,719.95,"2021-07-12","Payé"]
[186,"2021-08-18","KOUSEN","Daniel","rue Buisson à la fleur, 91",4537,"Verlaine","0495/23.05.74",780,943.8,null,null,943.8]
[187,"2021-08-18",null,null,null,null,null,{"$error":"#N/A"},1200,1452,null,null,1452]
[187,"2021-08-18",null,null,null,null,null,{"$error":"#N/A"},1200,1452,1000,null,452]
[188,"2021-08-18",null,null,null,null,null,{"$error":"#N/A"},1000,1210,750,null,460]
[189,"2021-08-18",null,null,null,null,null,{"$error":"#N/A"},3250,3932.5,800,null,3132.5]
[190,"2021-08-18",null,null,null,null,null,{"$error":"#N/A"},540,653.4,150,null,503.4]
[191,"2021-08-18",null,null,null,null,null,{"$error":"#N/A"},300,363,363,"2023-08-18","Payé"]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[192,"2023-01-13","KOUSEN","Daniel","rue Buisson à la fleur, 91",4537,"Verlaine","0495/23.05.74",395,477.95,0]
[192,"2023-01-13","KOUSEN","Daniel","rue Buisson à la fleur, 91",4537,"Verlaine","0495/23.05.74",395,477.95,0]
[192,"2023-01-13","KOUSEN","Daniel","rue Buisson à la fleur, 91",4537,"Verlaine","0495/23.05.74",395,477.95,0]
[192,"2023-01-13","KOUSEN","Daniel","rue Buisson à la fleur, 91",4537,"Verlaine","0495/23.05.74",395,477.95,0]
[192,"2023-01-13","KOUSEN","Daniel","rue Buisson à la fleur, 91",4537,"Verlaine","0495/23.05.74",395,477.95,0]
[192,"2023-01-13","LHOMME","Alain","rue Basse Marquet, 126",4470,"Stockay","0475/50 13 12",395,477.95,0]

{"sheet":"JournaldesVentes","index":4,"n_rows":48,"n_cols":16,"rows_kept":48,"cut":false,"hidden":false,"merged":[[1,1,3,3],[4,1,5,1],[4,2,5,2],[4,3,5,3],[1,15,5,15],[2,6,5,6],[2,7,5,7],[2,8,4,8],[2,9,4,9],[2,10,4,10],[2,11,4,11],[2,12,4,12],[1,6,1,7],[1,8,1,11],[2,13,4,13],[1,12,1,13]]}
[]
[null,"FACTURIER DES VENTES",null,null,"  Total facture +",null,"Trimestre 1",null,"NET de TVA",null,null,null,"BE0651.346.584",null,null,"Total de Contrôle"]
[null,null,null,null,"  ou Note e Crédit -",null,"Total TVA","Total sans TVA",0.06,0.21,"Co-Contractant","Privé","TVA non due","TVA à payer"]
[null,null,null,null,"  avec TVA %",0]
[null,"Date","N°","Clients",null,6]
["Date",null,null,null,null,21,null,null,1,3,45,null,null,54]
[null,null,null,null,null,21,{"$f":"E7-H7","v":0},{"$f":"IF(F7=0,E7,IF(F7=6,(E7/1.06),(E7/1.21)))","v":0},{"$f":"IF(F7=6,H7,\"\")","v":""},{"$f":"IF(F7=21,H7,\"\")","v":0},null,null,null,{"$f":"G7-M7","v":0},null,{"$f":"SUM(I7:N7)","v":0}]
["2021-07-12","2021-07-12",182,"CONING Patrick",null,{"$f":"IF(E8=\"\",\"\",21)","v":""},{"$f":"IF(E8=\"\",\"\",E8-H8)","v":""},{"$f":"IF(E8=\"\",\"\",IF(F8=0,E8,IF(F8=6,(E8/1.06),(E8/1.21))))","v":""},{"$f":"IF(F8=6,H8,\"\")","v":""},{"$f":"IF(F8=21,H8,\"\")","v":""},null,null,null,{"$f":"IF(G8=\"\",\"\",G8-M8)","v":""},null,{"$f":"IF(E8=\"\",\"\",SUM(I8:N8))","v":""}]
["2021-07-12","2021-07-12",183,"WOLWERTZ Alain",822.56,{"$f":"IF(E9=\"\",\"\",21)","v":21},{"$f":"IF(E9=\"\",\"\",E9-H9)","v":142.758347107438},{"$f":"IF(E9=\"\",\"\",IF(F9=0,E9,IF(F9=6,(E9/1.06),(E9/1.21))))","v":679.80165289256195},{"$f":"IF(F9=6,H9,\"\")","v":""},{"$f":"IF(F9=21,H9,\"\")","v":679.80165289256195},null,null,null,{"$f":"IF(G9=\"\",\"\",G9-M9)","v":142.758347107438},null,{"$f":"IF(E9=\"\",\"\",SUM(I9:N9))","v":822.56}]
["2021-07-12","2021-07-12",184,"KOUSEN Daniel",376.31,21,65.31,311,"",311,null,null,null,65.31,null,376.31]
["2021-07-12","2021-07-12",185,"LHOMME Alain",719.95,21,124.95000000000005,595,"",595,null,null,null,124.95000000000005,null,719.95]
["2021-08-18","2021-08-18",186,"KOUSEN Daniel",943.8,21,163.79999999999995,780,"",780,null,null,null,163.79999999999995,null,943.8]
["2021-08-18","2021-08-18",187," ",1452,21,252,1200,"",1200,null,null,null,252,null,1452]
["2021-08-18","2021-08-18",188," ",1210,21,210,1000,"",1000,null,null,null,210,null,1210]
["2021-08-18","2021-08-18",189," ",3932.5,21,682.5,3250,"",3250,null,null,null,682.5,null,3932.5]
["2021-08-18","2021-08-18",190," ",653.4,21,113.39999999999998,540,"",540,null,null,null,113.39999999999998,null,653.4]
["2021-08-18","2021-08-18",191," ",363,21,63,300,"",300,null,null,null,63,null,363]
["2023-01-13","2023-01-13",192,"KOUSEN Daniel",477.95,21,82.949999999999989,395,"",395,null,null,null,82.949999999999989,null,477.95]
["2023-01-13","2023-01-13",192,"KOUSEN Daniel",477.95,21,82.949999999999989,395,"",395,null,null,null,82.949999999999989,null,477.95]
["2023-01-13","2023-01-13",192,"KOUSEN Daniel",477.95,21,82.949999999999989,395,"",395,null,null,null,82.949999999999989,null,477.95]
["2023-01-13","2023-01-13",192,"KOUSEN Daniel",477.95,21,82.949999999999989,395,"",395,null,null,null,82.949999999999989,null,477.95]
["2023-01-13","2023-01-13",192,"KOUSEN Daniel",477.95,21,82.949999999999989,395,"",395,null,null,null,82.949999999999989,null,477.95]
["2023-01-13","2023-01-13",192,"LHOMME Alain",477.95,21,82.949999999999989,395,"",395,null,null,null,82.949999999999989,null,477.95]
[null,null,null,null,null,"","","","","",null,null,null,"",null,""]
[null,null,null,null,null,"","","","","",null,null,null,"",null,""]
[null,null,null,null,null,"","","","","",null,null,null,"",null,""]
[null,null,null,null,null,"","","","","",null,null,null,"",null,""]
[null,null,null,null,null,"","","","","",null,null,null,"",null,""]
[null,null,null,null,null,"","","","","",null,null,null,"",null,""]
[null,null,null,null,null,"","","","","",null,null,null,"",null,""]
[null,null,null,null,null,"","","","","",null,null,null,"",null,""]
[null,null,null,null,null,"","","","","",null,null,null,"",null,""]
[null,null,null,null,null,"","","","","",null,null,null,"",null,""]
[null,null,null,null,null,"","","","","",null,null,null,"",null,""]
[null,null,null,null,null,"","","","","",null,null,null,"",null,""]
[null,null,null,null,null,"","","","","",null,null,null,"",null,""]
[null,null,null,null,null,"","","","","",null,null,null,"",null,""]
[null,null,null,null,null,"","","","","",null,null,null,"",null,""]
[null,null,null,null,null,"","","","","",null,null,null,"",null,""]
[null,null,null,null,null,"","","","","",null,null,null,"",null,""]
[null,null,null,null,null,"","","","","",null,null,null,"",null,""]
[null,null,null,null,null,"","","","","",null,null,null,"",null,""]
[null,null,null,null,null,"","","","","",null,null,null,"",null,""]
[null,null,null,null,null,"","","","","",null,null,null,"",null,""]
[null,null,null,null,null,"","","","","",null,null,null,"",null,""]
[null,null,null,null,null,"","","","","",null,null,null,"",null,""]
[null,null,null,null,null,"","","","","",null,null,null,"",null,""]
[null,null,null,null,null,"","","","","",null,null,null,"",null,""]