{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Facturier d'Entrées","Stock","CoordonnéesClients","Facture","Historique_facture","Historique_Client","Types pneus","bilan annuel"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":176,"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":"Stock","index":1,"n_rows":101,"n_cols":17,"rows_kept":101,"cut":false,"hidden":false,"merged":[]}
["Date","Fournisseur","Marque","type","Taille","Quantité","Prix Achat brut","Mon Prix Achat","Ma remise","taux de marge","taxe recyclage","Marge benef.","P.Vente HT","P.Vente TTC","Quantité Sortie","Date Sortie","Stock Ce Jour"]
["2/6/21","ParisPneus","Michelin","XZX","245/45/16","2","100","80",{"$f":"IF(G2=\"\",\"\",(H2-G2)/G2)","v":-0.2},{"$f":"IF(H2=\"\",\"\",(M2-H2)/H2)","v":0.5},{"$f":"IF(F2=\"\",\"\",F2*2.36)","v":4.72},{"$f":"IF(H2=\"\",\"\",M2-H2)","v":40},"120",{"$f":"IF(M2=\"\",\"\",M2*1.21)","v":145.19999999999999},null,null,{"$f":"IF(F2=\"\",\"\",F2-O2)","v":2}]
["2/6/21","ParisPneus","Good Year","Pluie","235/55/15","4","65","55",{"$f":"IF(G3=\"\",\"\",(H3-G3)/G3)","v":-0.15384615384615385},{"$f":"IF(H3=\"\",\"\",(M3-H3)/H3)","v":0.72727272727272729},{"$f":"IF(F3=\"\",\"\",F3*2.36)","v":9.44},{"$f":"IF(H3=\"\",\"\",M3-H3)","v":40},"95",{"$f":"IF(M3=\"\",\"\",M3*1.21)","v":114.95},null,null,{"$f":"IF(F3=\"\",\"\",F3-O3)","v":4}]
["2/6/21","Tournesol","Semperit","AKI","225/45/13","4","90","75",-0.16666666666666666,0.4,9.44,30,"105",127.05,null,null,4]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,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(G67=\"\",\"\",(H67-G67)/G67)","v":""},{"$f":"IF(H67=\"\",\"\",(M67-H67)/H67)","v":""},{"$f":"IF(F67=\"\",\"\",F67*2.36)","v":""},{"$f":"IF(H67=\"\",\"\",M67-H67)","v":""},null,{"$f":"IF(M67=\"\",\"\",M67*1.21)","v":""},null,null,{"$f":"IF(F67=\"\",\"\",F67-O67)","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,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]
[null,null,null,null,null,null,null,null,"","","","",null,"",null,null,""]

{"sheet":"CoordonnéesClients","index":2,"n_rows":56,"n_cols":10,"rows_kept":56,"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"]
["BOVE","BOVEROUL","Eric"]
["BUTR","BUTERA","Raphaël"]
["BUTF","BUTERA","Fréderic"]
["CER","CERTINERGIE"]
["CONP","CONING","Patrick"]
["COOP","COONAERT","Philippe"]
["DAOE","DAOUT","Egide","rue Trixhelette, 81",4537,"Verlaine",null,"04/259,43,84"]
["DEBP","DEBECKER","Philippe"]
["DEBL","DEBLIQUIS","Luc"]
["DELP","DELVAUX","Patrick"]
["det","dethioux"]
["DEVH","DEVIGNE","Henry"]
["D'HE","D'HOE","Eric",null,4537,"Verlaine"]
["DUCL","DUCHENE","Laurent"]
["DupC","Dupont","Charles","rue du Pont,28",null,"Villers le Bouillet","N/A","04/12345678"]
["EVRR","EVRARD ","Roland"]
["FEET","FEET","Thomas"]
["FOUS","FOUCART","Sophie"]
["GIAG","GIANQUINTO","Gloria"]
["GRIB","GRINDORGE","Benoit"]
["HALH","HALIN","Hervé"]
["JOLG","JOLLY","Geoffrey"]
["LABD","LABYE","Didier"]
["LAML","LAMBERTY","Lionel"]
["LAMM","LAMBERTY","Maud"]
["LAMA","LAMOUREUX","Alexandre"]
["LECM","LECOMPTE","Michel"]
["LEFA","LEFEBVRE","Alain"]
["LHEL","LHEUREUX","Lionel"]
["MARG","MARTINE","Georges"]
["MATC","MATYN","Claude"]
[{"$f":"LEFT(B35,3)&LEFT(C35,1)","v":"MHVL"},"MHVAL","Lise"]
["MOIG","MOISSERON","Gérard"]
["MORC","MORSAINT","Claude","fils"]
["MUSC","MUSIQUE","Catherine"]
["NOV","NOVIAT"]
["PAZG","PAZIENZA","Gauthier"]
["REMA","REMONT","Alain"]
["RIGA","RIGA","André"]
["ROSE","ROSE","Eric"]
["saa","sa","arkos"]
["SAIJ","SAINTE","Jean-Christophe"]
["SAID","SAINTE","Dominique"]
["SAML","SAMSON","Luc"]
["SON","SONVILLE"]
["SOUN","SOUDAIN","Nadine"]
["TOUM","TOURNIQUET","Madame"]
["ULIM","ULIANA","Maxime"]
["VAN","VAN DEN BERGH"]
["WALL","WALLRAF","Lionel"]
["WELP","WELKENHUZEN","Patrick"]
["WOLA","WOLWERTZ","Alain"]
["WUYJ","WUYTS","Jean-Luc"]

{"sheet":"Facture","index":3,"n_rows":40,"n_cols":9,"rows_kept":40,"cut":false,"hidden":false,"merged":[[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],[38,0,38,1],[24,2,24,4],[25,2,25,4],[26,2,26,4],[27,2,27,4],[28,2,28,4],[34,2,34,4],[35,2,35,4],[36,2,36,4],[29,2,29,4],[30,2,30,4],[31,2,31,4],[32,2,32,4],[33,2,33,4]]}
[]
[]
[]
[]
[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° ",156,null,"Nom :",null,{"$f":"IF(E10=\"\",\"\",VLOOKUP(E10,CoordonnéesClients!B2:J97,2,FALSE))","v":""}]
["TVA Client :",{"$f":"IF(VLOOKUP(E10,CoordonnéesClients!B2:G98,6,0)=\"\",\"N/A\",(VLOOKUP(E10,CoordonnéesClients!B2:G98,6,0)))","v":{"$error":"#N/A"}},null,"Adresse :",{"$f":"IFERROR(VLOOKUP(E10,CoordonnéesClients,3,FALSE),\"\")","v":""}]
["DATE :",{"$f":"TODAY()","v":"2021-06-02"},null,"CP+Localité",{"$f":"IFERROR(VLOOKUP(E10,CoordonnéesClients,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E10,CoordonnéesClients,5,FALSE),\"\")","v":""}]
[null,null,null,"Tél :",{"$f":"(VLOOKUP(E10,CoordonnéesClients,8,FALSE))","v":{"$error":"#N/A"}}]
[]
["Nr Article","Qtés","Désignation",null,null,"Prix Unit. TVAC","Total HTVA"]
[null,null,null,null,null,null,{"$f":"IF(B16=\"\",\"\",(B16*F16)/1.21)","v":""}]
[null,null,null,null,null,null,{"$f":"IF(B17=\"\",\"\",(B17*F17)/1.21)","v":""}]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,"Montage & Equilibrage",null,null,{"$f":"IF(B20=\"\",\"\",10)","v":""},""]
[null,null,"Taxe recyclage (2,36€/Pneu)",null,null,{"$f":"(B16+B17+B18+B19)*2.36","v":0},{"$f":"IF(F21=\"\",\"\",(F21)/1.21)","v":0}]
[null,null,null,null,null,{"$f":"IF(B22=\"\",\"\",E22*1.21)","v":""},""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"","",null,"** les quatres premières lignes sont"]
[null,null,null,null,null,"","",null,"destinées aux pneus"]
[null,null,null,null,null,"","",null,"*** pour autres services que pneus,"]
[null,null,null,null,null,"","",null,"débuter à la ligne22"]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,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,"",{"$f":"IF(B37=\"\",\"\",B37*E37)","v":""}]
["Immatriculation",null,null,null,null,"Total HTVA",{"$f":"SUM(G16:G37)","v":0}]
[null,null,null,null,null,"TVA 21%",{"$f":"G38*21%","v":0}]
["Kilometrage",null,null,null,null,"Total TVAC",{"$f":"G38+G39","v":0}]

{"sheet":"Historique_facture","index":4,"n_rows":101,"n_cols":15,"rows_kept":101,"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"]
["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(I2=0,\"\",IF(J2-K2=0,\"Payé\",J2-K2))","v":"Payé"},null,{"$f":"IF(I2=0,\"\",IF(J2-K2=0,\"\",J2-K2))","v":""}]
["2020/001","2020-05-11","Kousen","Daniel","rue Buisson à la fleur, 91","4537 Verlaine",null,null,341,412.61,null,null,{"$f":"IF(I3=0,\"\",IF(J3-K3=0,\"Payé\",J3-K3))","v":412.61}]
["2020/001","2020-05-11",null,null,null,null,null,null,0,0,null,null,""]
["2020/001","2020-05-11",null,null,null,null,null,null,0,0,null,null,""]
["2020/001","2020-05-11",null,null,null,null,null,null,0,0,null,null,""]
["2020/001","2020-05-11",null,null,null,null,null,null,0,0,null,null,""]
["2020/001","2020-05-11",null,null,null,null,null,null,0,0,null,null,""]
["2020/001","2020-05-11",null,null,null,null,null,null,0,0,null,null,""]
[101,"2020-05-11",null,null,null,null,null,null,0,0,null,null,""]
[102,"2020-05-11",null,null,null,null,null,null,0,0,null,null,""]
[103,"2020-05-11",null,null,null,null,null,null,0,0,null,null,""]
[104,"2020-05-11",null,null,null,null,null,null,0,0,null,null,""]
[105,"2020-05-11",null,null,null,null,null,null,0,0,null,null,""]
[106,"2020-05-11",null,null,null,null,null,null,0,0,null,null,""]
[107,"2020-05-11","Kousen","Daniel","rue Buisson à la fleur, 91","4537 - Verlaine",null,null,453.8,549.1,549.1,null,"Payé"]
[108,"2020-05-11","Kousen",null,"rue Buisson à la fleur, 91",4537,"Verlaine","0495/23,05,74",0,0,null,null,""]
[109,"2020-05-11","Kousen",null,null,null,null,null,326.5,395.07,null,null,395.07]
[110,"2020-05-11","Kousen",null,"rue Buisson à la fleur, 91",4537,"Verlaine","0495/23,05,74",755.28,913.89,null,null,913.89]
[111,"2020-05-11","Kousen",null,"rue Buisson à la fleur, 91",4537,"Verlaine","0495/23,05,74",2192.5500000000002,2652.99,null,null,2652.99]
[112,"2020-05-12","Kousen",null,"rue Buisson à la fleur, 91",4537,"Verlaine","0495/23.05.74",179.98,217.78,null,null,217.78]
[113,"2020-05-12","BUTERA",null,0,0,0,0,418.24,506.07,null,null,506.07]
[114,"2020-05-12",null,null,null,null,null,null,0,0,null,null,""]
[115,"2020-05-12","Dupont",null,"rue du Pont,28",0,"Villers le Bouillet",0,359.6,435.12,435.12,null,"Payé"]
[116,"2020-05-12","KOUSEN",null,"rue Buisson à la fleur, 91",4537,"Verlaine","0495/23.05.74",132.96,160.88,null,null,160.88]
[117,"2020-05-12","KOUSEN","                                                        ","rue Buisson à la fleur, 91",4537,"Verlaine","0495/23.05.74",0,0,null,null,""]
[118,"2020-05-23",null,null,null,null,null,null,0,0,null,null,""]
[126,"2020-06-01",null,null,null,null,null,null,0,0,null,null,""]
[127,"2020-06-01","KOUSEN",null,"rue Buisson à la fleur, 91",4537,"Verlaine","0495/23.05.74",748.8,906.05,null,null,906.05]
[129,"2020-06-01",null,null,null,null,null,null,0,0,null,null,""]
[131,"2020-06-01","Dupont",null,"rue du Pont,28",0,"Villers le Bouillet",0,448.4,542.55999999999995,null,null,542.55999999999995]
[132,"2020-06-01",null,null,null,null,null,null,0,0,null,null,""]
[134,"2020-06-11","KOUSEN",null,"rue Buisson à la fleur, 91",4537,"Verlaine","0495/23.05.74",266.39999999999998,322.33999999999997,null,null,322.33999999999997]
[135,"2020-06-11","KOUSEN",null,"rue Buisson à la fleur, 91",4537,"Verlaine","0495/23.05.74",609.6,737.62,null,null,737.62]
[136,"2020-06-11","Dupont",null,"rue du Pont,28",0,"Villers le Bouillet",0,748.8,906.05,null,null,906.05]
[137,"2020-06-11","Dupont",null,"rue du Pont,28",0,"Villers le Bouillet",0,1382,1672.22,null,null,1672.22]
[138,"2020-06-11","Dupont",null,"rue du Pont,28",0,"Villers le Bouillet",0,778.8,942.35,null,null,942.35]
[139,"2020-06-11",null,null,null,null,null,null,0,0,null,null,""]
[140,"2020-06-11","KOUSEN","Daniel","rue Buisson à la fleur, 91",4537,"Verlaine","0495/23.05.74",282,341.22,null,null,341.22]
[141,"2020-06-11",null,null,null,null,null,null,1238,1497.98,null,null,1497.98]
[142,"2020-06-11","ULIANA","Maxime",0,0,0,0,2766,3346.86,null,null,3346.86]
[143,"2020-06-29","KOUSEN","Daniel","rue Buisson à la fleur, 91",4537,"Verlaine","0495/23.05.74",157.83000000000001,190.98,150,null,40.97999999999999]
[144,"2020-06-29",null,null,null,null,null,null,0,0,null,null,""]
[145,"2020-06-29","DAOUT","Egide","rue Trixhelette, 81",4537,"Verlaine",0,377.06,456.24,456.24,null,"Payé"]
[146,"2020-07-10","TOURNIQUET","Madame",0,0,0,0,154.30000000000001,186.7,null,null,186.7]
[147,"2020-07-10","KOUSEN","Daniel","rue Buisson à la fleur, 91",4537,"Verlaine","0495/23.05.74",154.30000000000001,186.7,null,null,186.7]
[148,"2020-07-10",null,null,null,null,null,null,16.53,20,null,null,20]
[149,"2020-07-10",null,null,null,null,null,null,0,0,null,null,""]
[150,"2020-07-10","WELKENHUZEN","Patrick",0,0,0,0,460.03,556.64,null,null,556.64]
[151,"2020-07-18","TOURNIQUET","Madame",0,0,0,0,185.69,224.68,null,null,224.68]
[152,"2020-07-18","WALLRAF","Lionel",0,0,0,0,305.32,369.44,null,null,369.44]
[153,"2020-07-21","KOUSEN","Daniel","rue Buisson à la fleur, 91",4537,"Verlaine","0495/23.05.74",437.55,529.44000000000005,null,null,529.44000000000005]
[154,"2020-08-02","KOUSEN","Daniel","rue Buisson à la fleur, 91",4537,"Verlaine","0495/23.05.74",268.93,325.39999999999998,null,null,325.39999999999998]
[155,"2020-08-14","Dupont","Charles","rue du Pont,28",0,"Villers le Bouillet",0,172.5,208.72,null,null,208.72]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[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(I64=0,\"\",IF(J64-K64=0,\"Payé\",J64-K64))","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,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,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":"SUM(I2:I97)","v":17459.75},{"$f":"SUM(J2:J97)","v":21126.31},"total du crédit :",null,{"$f":"SUM(M2:M97)","v":19123.239999999998}]
[]
[]
[null,null,null,null,null,null,null,null,"TVA à Payer : ",null,{"$f":"J98-I98","v":3666.5600000000013}]

{"sheet":"Historique_Client","index":5,"n_rows":101,"n_cols":15,"rows_kept":101,"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"]
[113,"2020-05-12","BUTERA",null,0,0,0,0,418.24,506.07,null,null,{"$f":"IF(I2=0,\"\",IF(J2-K2=0,\"Payé\",J2-K2))","v":506.07},null,{"$f":"IF(I2=0,\"\",IF(J2-K2=0,\"\",J2-K2))","v":506.07}]
["2020/001","2020-05-11","Kousen","Daniel","rue Buisson à la fleur, 91","4537 Verlaine",null,null,341,412.61,412.61,"2020-05-11","Payé"]
["2020/001","2020-05-11","Kousen","Daniel","rue Buisson à la fleur, 91","4537 Verlaine",null,null,341,412.61,null,null,412.61]
[107,"2020-05-11","Kousen","Daniel","rue Buisson à la fleur, 91","4537 - Verlaine",null,null,453.8,549.1,549.1,null,"Payé"]
[108,"2020-05-11","Kousen",null,"rue Buisson à la fleur, 91",4537,"Verlaine","0495/23,05,74",0,0,null,null,""]
[109,"2020-05-11","Kousen",null,null,null,null,null,326.5,395.07,null,null,395.07]
[110,"2020-05-11","Kousen",null,"rue Buisson à la fleur, 91",4537,"Verlaine","0495/23,05,74",755.28,913.89,null,null,913.89]
[111,"2020-05-11","Kousen",null,"rue Buisson à la fleur, 91",4537,"Verlaine","0495/23,05,74",2192.5500000000002,2652.99,null,null,2652.99]
[112,"2020-05-12","Kousen",null,"rue Buisson à la fleur, 91",4537,"Verlaine","0495/23.05.74",179.98,217.78,null,null,217.78]
["2020/001","2020-05-11",null,null,null,null,null,null,0,0,null,null,""]
["2020/001","2020-05-11",null,null,null,null,null,null,0,0,null,null,""]
["2020/001","2020-05-11",null,null,null,null,null,null,0,0,null,null,""]
["2020/001","2020-05-11",null,null,null,null,null,null,0,0,null,null,""]
["2020/001","2020-05-11",null,null,null,null,null,null,0,0,null,null,""]
["2020/001","2020-05-11",null,null,null,null,null,null,0,0,null,null,""]
["2020/001","2020-05-11",null,null,null,null,null,null,0,0,null,null,""]
["2020/001","2020-05-11",null,null,null,null,null,null,0,0,null,null,""]
[100,"2020-05-11",null,null,null,null,null,null,0,0,null,null,""]
[101,"2020-05-11",null,null,null,null,null,null,0,0,null,null,""]
[102,"2020-05-11",null,null,null,null,null,null,0,0,null,null,""]
[103,"2020-05-11",null,null,null,null,null,null,0,0,null,null,""]
[104,"2020-05-11",null,null,null,null,null,null,0,0,null,null,""]
[105,"2020-05-11",null,null,null,null,null,null,0,0,null,null,""]
[106,"2020-05-11",null,null,null,null,null,null,0,0,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I26=0,\"\",IF(J26-K26=0,\"Payé\",J26-K26))","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,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[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(I67=0,\"\",IF(J67-K67=0,\"Payé\",J67-K67))","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,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,"total du crédit :",null,{"$f":"SUM(M2:M100)","v":5098.4099999999989}]

{"sheet":"Types pneus","index":6,"n_rows":194,"n_cols":11,"rows_kept":194,"cut":false,"hidden":false,"merged":[[118,12,119,12],[132,12,133,12],[134,12,135,12],[138,12,139,12],[141,12,142,12],[130,12,131,12],[153,12,154,12],[155,12,156,12],[159,12,160,12],[144,12,145,12],[147,12,148,12],[151,12,152,12],[175,12,176,12],[185,12,186,12],[162,12,163,12],[167,12,168,12],[169,12,170,12],[196,12,197,12],[198,12,199,12],[200,12,201,12],[188,12,189,12],[192,12,193,12],[194,12,195,12],[212,12,213,12],[214,12,215,12],[220,12,221,12],[203,12,204,12],[206,12,207,12],[208,12,209,12],[233,12,234,12],[240,12,241,12],[223,12,224,12],[228,12,229,12],[230,12,231,12],[251,12,252,12],[253,12,254,12],[260,12,261,12],[242,12,243,12],[246,12,247,12],[249,12,250,12]]}
[]
["Calcul du type de pneus",{"$f":"'Types pneus'!B8&\" \"","v":"94 "},"largeurs","hauteur","type","diamètre","charge","vitesse",null,null,"Marques"]
[null,null,125,25,"R",10,60,"B",null,null,"Accelera Pneus"]
["largeur",295,135,30,"ZR",11,61,"C",null,null,"Achilles Pneus"]
["Hauteur",35,145,35,"RF",12,62,"D",null,null,"Advance Pneus"]
["Type","R",155,40,"D",13,63,"E",null,null,"Aeolus Pneus"]
["Diamètre",21,165,45,null,14,64,"F",null,null,"Alliance Pneus"]
["Charge",94,175,50,null,15,65,"G",null,null,"Altura Pneus"]
["Vitesse","W",185,55,null,16,66,"H",null,null,"Antares Pneus"]
[null,null,195,60,null,17,67,"J",null,null,"Anteo Pneus"]
[null,null,205,65,null,18,68,"K",null,null,"APlus Pneus"]
[{"$f":"CONCATENATE(B4,\"/\",B5,\" \",B6,\" \",B7)","v":"295/35 R 21"},null,215,70,null,19,69,"L",null,null,"Apollo Pneus"]
[null,null,225,75,null,20,70,"M",null,null,"Arivo Pneus"]
[null,null,235,80,null,21,71,"N",null,null,"Armour Pneus"]
[null,null,245,null,null,null,72,"P",null,null,"Atlas Pneus"]
[null,null,255,null,null,null,73,"Q",null,null,"ATP Pneus"]
[null,null,265,null,null,null,74,"R",null,null,"Atturo Pneus"]
[null,null,275,null,null,null,75,"S",null,null,"Avon Pneus"]
[null,null,285,null,null,null,76,"T",null,null,"Avon Vintage Pneus"]
[null,null,295,null,null,null,77,"U",null,null,"Barum Pneus"]
[null,null,305,null,null,null,78,"V ",null,null,"Berliner Heissrunderneuerung Pneus"]
[null,null,315,null,null,null,79,"VR",null,null,"BF Goodrich Pneus"]
[null,null,null,null,null,null,80,"W",null,null,"BKT Pneus"]
[null,null,null,null,null,null,81,"Y",null,null,"Blacklion Pneus"]
[null,null,null,null,null,null,82,"ZR",null,null,"Boka Pneus"]
[null,null,null,null,null,null,83,null,null,null,"Bridgestone Pneus"]
[null,null,null,null,null,null,84,null,null,null,"Camac Pneus"]
[null,null,null,null,null,null,85,null,null,null,"Carlisle Pneus"]
[null,null,null,null,null,null,86,null,null,null,"Ceat Pneus"]
[null,null,null,null,null,null,87,null,null,null,"Coker Pneus"]
[null,null,null,null,null,null,88,null,null,null,"Comforser Pneus"]
[null,null,null,null,null,null,89,null,null,null,"Continental Pneus"]
[null,null,null,null,null,null,90,null,null,null,"Contire Pneus"]
[null,null,null,null,null,null,91,null,null,null,"Cooper Pneus"]
[null,null,null,null,null,null,92,null,null,null,"Cordiant Pneus"]
[null,null,null,null,null,null,93,null,null,null,"CST Pneus"]
[null,null,null,null,null,null,94,null,null,null,"Cultor Pneus"]
[null,null,null,null,null,null,95,null,null,null,"Dayton Pneus"]
[null,null,null,null,null,null,96,null,null,null,"Debica Pneus"]
[null,null,null,null,null,null,97,null,null,null,"Deestone Pneus"]
[null,null,null,null,null,null,98,null,null,null,"Deli Pneus"]
[null,null,null,null,null,null,99,null,null,null,"Dneproshina Pneus"]
[null,null,null,null,null,null,100,null,null,null,"Double Coin Pneus"]
[null,null,null,null,null,null,101,null,null,null,"Dunlop Pneus"]
[null,null,null,null,null,null,102,null,null,null,"Duraturn Pneus"]
[null,null,null,null,null,null,103,null,null,null,"Duro Pneus"]
[null,null,null,null,null,null,104,null,null,null,"Ecomega Pneus"]
[null,null,null,null,null,null,105,null,null,null,"Euro-Grip Pneus"]
[null,null,null,null,null,null,106,null,null,null,"Evergreen Pneus"]
[null,null,null,null,null,null,107,null,null,null,"Excelsior Pneus"]
[null,null,null,null,null,null,108,null,null,null,"Falken Pneus"]
[null,null,null,null,null,null,109,null,null,null,"Farm King Pneus"]
[null,null,null,null,null,null,110,null,null,null,"Federal Pneus"]
[null,null,null,null,null,null,111,null,null,null,"Fesite Pneus"]
[null,null,null,null,null,null,112,null,null,null,"Firemax Pneus"]
[null,null,null,null,null,null,113,null,null,null,"Firestone Pneus"]
[null,null,null,null,null,null,114,null,null,null,"Formula Pneus"]
[null,null,null,null,null,null,115,null,null,null,"Fortuna Pneus"]
[null,null,null,null,null,null,116,null,null,null,"Fulda Pneus"]
[null,null,null,null,null,null,117,null,null,null,"Fullrun Pneus"]
[null,null,null,null,null,null,118,null,null,null,"Galaxy Pneus"]
[null,null,null,null,null,null,119,null,null,null,"General Pneus"]
[null,null,null,null,null,null,120,null,null,null,"Gislaved Pneus"]
[null,null,null,null,null,null,121,null,null,null,"Giti Pneus"]
[null,null,null,null,null,null,122,null,null,null,"Goform Pneus"]
[null,null,null,null,null,null,123,null,null,null,"Goodride Pneus"]
[null,null,null,null,null,null,124,null,null,null,"Goodyear Pneus"]
[null,null,null,null,null,null,125,null,null,null,"Gripmax Pneus"]
[null,null,null,null,null,null,null,null,null,null,"GT Radial Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Haida Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Hankook Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Headway Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Heidenau Pneus"]
[null,null,null,null,null,null,null,null,null,null,"HI FLY Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Imperial Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Import Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Infinity Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Insa Turbo Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Jinyu Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Kabat Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Kaltrunderneuerung Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Kama Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Kelly Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Kenda Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Keter Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Kinforest Pneus"]
[null,null,null,null,null,null,null,null,null,null,"King Meiler Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Kings Tire Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Kleber Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Kormoran Pneus"]
[null,null,null,null,null,null,null,null,null,null,"KRM Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Kumho Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Landsail Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Lanvigator Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Lassa Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Laufenn Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Lexani Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Linglong Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Magna Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Malatesta Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Malhotra MRL Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Marshal Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Matador Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Maxfield Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Maximo Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Maxtrek Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Maxxis Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Mazzini Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Michelin Collection Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Michelin Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Michelin Remix Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Milestone Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Minerva Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Mitas Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Nankang Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Nexen Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Nitto Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Nokian Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Nordexx Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Nortenha Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Novio Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Orium Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Ovation Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Ozka Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Petlas Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Pirelli Pneus"]
[null,null,null,null,null,null,null,null,null,null,"PointS Pneus"]
[null,null,null,null,null,null,null,null,null,null,"PowerTrac Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Powertrac Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Premiorri Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Profil Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Radar Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Retro Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Riken Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Roadmarch Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Roadstone Pneus"]
[null,null,null,null,null,null,null,null,null,null,"RoadX Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Roadx Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Rosava Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Rotalla Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Royal Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Sailun Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Samson Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Sava Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Security Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Seha Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Seiberling Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Semi-Pro Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Semperit Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Shikari Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Silverstone Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Solideal Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Speedways Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Star Performer Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Star Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Starco Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Starmaxx Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Sunny Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Super King Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Superia Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Syron Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Taifa Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Taurus Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Techking Pneus"]
[null,null,null,null,null,null,null,null,null,null,"THREE-A Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Tianli Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Titan Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Tomket Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Torque Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Toyo Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Tracmax Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Trayal Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Trazano Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Trelleborg Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Triangle Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Tristar Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Unigrip Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Uniroyal Pneus"]
[null,null,null,null,null,null,null,null,null,null,"VeeRubber Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Veloce Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Viking Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Vitour Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Voltyre Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Vredestein Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Wanda Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Wanli Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Waymaster Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Westlake Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Windforce Pneus"]
[null,null,null,null,null,null,null,null,null,null,"WindPower Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Winrun Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Winter Tact Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Yokohama Pneus"]
[null,null,null,null,null,null,null,null,null,null,"Ziarelli Pneus"]

{"sheet":"bilan annuel","index":7,"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":"#REF!","v":{"$error":"#REF!"}},"recette sortie",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[null,"benefice",{"$f":"D3-B3","v":{"$error":"#REF!"}}]