{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["entrées","sorties","bilan annuel","stock","tableau_clients","suivi factures","facturier","Facture","Historique_facture"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"entrées","index":0,"n_rows":55,"n_cols":9,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
["fournisseurs","montant","reference facture","payer le ","quantitée",null,"taille","marque","type"]
["cpt(3-4 tri2016+declfis)",1179.75,20170002,"2017-03-29"]
["decoba",150.96,84055,null,2,2,"205/55r16-91h","mi","energye saver"]
["decoba",87.8,84008,null,2,2,"175/65r14-82t","kleb","hp3"]
["decoba",139,82397,null,2,2,"205/55r16-94w","vred","ultra satin xl"]
["decoba",99.03,81986,"2017-01-25",2,2,"175/65/r14-82t","vred","snow trac 5"]
["decoba",272.25,81861,null,2,2,"235/65r16-115r","vred","comtrac all sea"]
["decoba",119.26,81332,"2017-11-25",2,2,"175/65r15-84h","vred","quatrac5"]
["tiptop",232.76,3700535,"2017-01-25"]
["tiptop",185.64,3702523,"2017-03-29"]
["tiptop",166.88,3702677]
["wuth",223.73,4006328792,"2017-03-08"]
["deloge",271.68,170125,"2017-03-08"]
["deloge",139.25,170225]
["oh green",123.98,20170013]
["c2mro-k-sab",259,18882]
["société des eaux",51.76,222005435033]
["société des eaux",70.53,212001903352]
["dats24",24.74,"6s0413190"]
["dats24",25.2,"6s0458418"]
["dats24",19.079999999999998,"6s0504322"]
["eni",52.89,132200489310]
["eni",52.89,182113455466]
["eni",52.89,182044486651]
["orange",104.06,1700000893]
["orange",104.3,1700197265]
["orange",104.52,1700373973]
["proximus",74.95,6701135332,"2017-01-25"]
["proximus",74.95,6701659285," "]
["proximus",75.95,6701659285]
["proximus",89.95,6702183927,"2017-03-20"]
["decoba",139.77000000000001,84604,null,2,2,"175/65r14-90/88t","kleb","transpro"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"SUM(B2:B54)","v":4769.4000000000005},null,null,{"$f":"SUM(E2:E54)","v":14}]

{"sheet":"sorties","index":1,"n_rows":59,"n_cols":9,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
["clients","facture numéro","montants","payer le ","quantitée",null,"marque","taille","type"]
["sa arkos",17000001,194.88,null,2,null,"mi","175/65r14-82t","saver"]
["dethioux",17000002,894.36,null,4,null,"kl","205/75r16c-110","transalp2"]
[null,null,null,null,3,null,"nexen","235/65r16c-115"]
["DAOUT Egide",17000003,19.989999999999998]
["VAN DEN BERGH",17000004,79.959999999999994]
["GIANQUINTO Gloria",17000005,19.989999999999998]
["EVRARDRoland",17000006,19.989999999999998]
["JOLLY Geoffrey",17000007,39.979999999999997]
["SAINTE Jean-Christophe",17000008,19.989999999999998]
["MHVAL Lise",17000009,19.989999999999998]
["WOLWERTZ Alain",17000010,19.989999999999998]
["SAINTE Dominique",17000011,39.979999999999997]
["RIGA André",17000012,39.979999999999997]
["DEBLIQUIS Luc",17000013,19.989999999999998]
["BUTERA Raphaël",17000014,39.979999999999997]
["DEVIGNE Henry",17000015,19.989999999999998]
["DELVAUX Patrick",17000016,19.989999999999998]
["FEET Thomas",17000017,39.979999999999997]
["GRINDORGE Benoit",17000018,39.979999999999997]
["LECOMPTE Michel",17000019,39.979999999999997]
["WELKENHUZEN Patrick",17000020,39.979999999999997]
["LAMOUREUX Alexandre",17000021,19.989999999999998]
["LEFEBVRE Alain",17000022,39.979999999999997]
["BUTERA Fréderic",17000023,4.99]
["DUCHENE Laurent",17000024,39.979999999999997]
["CERTINERGIE",17000025,19.989999999999998]
["BOVEROUL Eric",17000026,39.979999999999997]
["ULIANA Maxime",17000027,39.979999999999997]
["DEBECKER Philippe",17000028,19.989999999999998]
["ROSE Eric",17000029,19.989999999999998]
["LHEUREUX Lionel",17000030,19.989999999999998]
["LAMBERTY Lionel",17000031,19.989999999999998]
["LAMBERTY Lionel",17000032,19.989999999999998]
["WUYTS Jean-Luc",17000033,19.989999999999998]
["ANCION Freddy",17000034,39.979999999999997]
["PAZIENZA Gauthier",17000035,39.979999999999997]
["LAMBERTY Maud",17000036,39.979999999999997]
["MUSIQUE Catherine",17000037,19.989999999999998]
["LABYE Didier",17000038,39.979999999999997]
["MATYN Claude",17000039,39.979999999999997]
["WALLRAF Lionel",17000040,19.989999999999998]
["SAINTE Dominique",17000041,19.989999999999998]
["FOUCART Sophie",17000042,19.989999999999998]
["HALIN Hervé",17000043,19.989999999999998]
["SONVILLE",17000044,39.979999999999997]
["MARTINE Georges",17000045,39.979999999999997]
["SOUDAIN Nadine",17000046,49.97]
["SAMSON Luc",17000047,39.979999999999997]
["REMONT Alain",17000048,39.979999999999997]
["MOISSERON Gérard",17000049,174.77,null,2,null,"VREDESTEIN ","175/65R15-84H"]
["MORSAINT Claude fils",17000050,221.87,null,2,null,"MICHELIN","205/55R16-94V"]
["NOVIAT",17000051,19.989999999999998]
["TOURNIQUET Madame",17000052,149.97999999999999,null,2,null,"VREDESTEIN","175/65R12-84T"]
["COONAERT Philippe",17000053,39.979999999999997]
["CONING Patrick",17000054,19.989999999999998]
[]
[]
[null,null,{"$f":"SUM(C2:C56)","v":3130.0999999999985},null,{"$f":"SUM(E2:E54)","v":15}]

{"sheet":"bilan annuel","index":2,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["bilan entrée et sortie"]
[]
["recette entrer",{"$f":"entrées!B55","v":4769.4000000000005},"recette sortie",{"$f":"sorties!C59","v":3130.0999999999985}]
[]
[null,"benefice",{"$f":"D3-B3","v":-1639.300000000002}]

{"sheet":"stock","index":3,"n_rows":1,"n_cols":17,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["taille","indice\nvitesse et \ncharge","marque","type","quantité","prix d'achat\nbrut","mon prix  d'achat htc","totalprix d'achat\nhtc","marge","taux de marge","taxe recyclage","Marge benef.","prix de vente htc","prix de vente\nttc","fournisseur","date","référence \nfournisseur"]

{"sheet":"tableau_clients","index":4,"n_rows":1,"n_cols":8,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Num. Fact","Date fact","Nom+Prénom","rue","CP+Localité","N° TVA","Total HT","Total TTC"]

{"sheet":"suivi factures","index":5,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Facture numéro","NOM","MONTANT","Payer le"]
[17000001,"sa arkos",194.88]
[17000002,"dethioux",894.36]
[17000049,"MOISSERON Gérard",174.77]
[17000050,"MORSAINT Claude fils",221.87]
[17000052,"TOURNIQUET Madame",149.97999999999999]

{"sheet":"facturier","index":6,"n_rows":45,"n_cols":5,"rows_kept":45,"cut":false,"hidden":false,"merged":[[40,0,40,1],[40,2,40,3],[41,2,42,3],[42,0,42,1],[44,1,44,2]]}
[null,null,"FACTURE"]
[]
["PNEUS D'HOE",null,null,"client :   Nom"]
["rue trixhelette 13",null,null,"Prénom"]
["4537 VERLAINE",null,null,"adresse"]
["GSM. 0475832835",null,null,"code postal"]
["T.V.A.: BE0867233448",null,null,"téléphone"]
[null,null,null,"G.S.M."]
[null,null,null,"T.V.A."]
[]
[]
[]
[]
[null,"référence facture:"]
[]
[]
[]
[]
[]
["ARTICLE","Quantitée","Prix unitaire","T.V.A.","prix T.V.A. C."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"SUM(A21:A34)","v":0},{"$f":"SUM(B21:B34)","v":0},{"$f":"SUM(C21:C34)","v":0},null,"TOTALS"]
[]
[]
[null,"T.V.A.",{"$f":"C35*21%","v":0},"TOTAL A PAYER",{"$f":"SUM(E21:E34)","v":0}]
[]
[]
["Numéro de plaque:"]
[]
["Numéro de chassis:"]
[]
["Kilométrage: "]

{"sheet":"Facture","index":7,"n_rows":42,"n_cols":7,"rows_kept":42,"cut":false,"hidden":false,"merged":[[25,2,25,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[19,2,19,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[26,2,26,3],[27,2,27,3],[28,2,28,3],[29,2,29,3],[30,2,30,3],[34,2,34,3],[35,2,35,3],[36,2,36,3],[31,2,31,3],[32,2,32,3],[33,2,33,3]]}
[]
[]
[]
[]
[null,null,null,"rue Trixhelette, 13     -  4537 - Verlaine (Bodegnée)"]
[]
[null,null,null,"GSM. 0475/83 28 35",null,"T.V.A.: BE0867.233.448"]
[]
[]
["FACTURE N° ","2020/001",null,"Nom :","Kousen","Prénom :","Daniel"]
["TVA Client :","752,303,492",null,"Adresse :","rue Buisson à la fleur, 91"]
["DATE :",{"$f":"TODAY()","v":"2020-05-11"},null,"CP+Localité","4537 Verlaine"]
[null,null,null,"Tél :"]
[]
["Nr Article","Qtés","Désignation",null,"Prix Unit. HTVA","Prix Unit. TVAC","Total HTVA"]
[null,null,null,null,null,{"$f":"IF(B16=\"\",\"\",E16*1.21)","v":""},{"$f":"IF(B16=\"\",\"\",B16*E16)","v":""}]
["4zy23T",4,"Pirelli",null,85.25,{"$f":"IF(B17=\"\",\"\",E17*1.21)","v":103.1525},{"$f":"IF(B17=\"\",\"\",B17*E17)","v":341}]
[null,null,null,null,null,{"$f":"IF(B18=\"\",\"\",E18*1.21)","v":""},""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,{"$f":"IF(B36=\"\",\"\",E36*1.21)","v":""},""]
[null,null,null,null,null,"",""]
["N° Immatriculation :",null,null,null,null,"Total HTVA",{"$f":"SUM(G16:G37)","v":341}]
[null,null,null,null,null,"TVA 21%",{"$f":"G38*21%","v":71.61}]
["N° Chassis :",null,null,null,null,"Total TVAC",{"$f":"G38+G39","v":412.61}]
[]
["Kilométrage :"]

{"sheet":"Historique_facture","index":8,"n_rows":1,"n_cols":10,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["FACTURE N° ","DATE :","Nom :","Prénom :","Adresse :","Code Postal :","Localité:","Tél :","Total HTVA","Total TVAC"]