{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["inv","client","MOD FACTURE","MOD Vente Comptoir 2 et 3","FA201860001","VC2018650001"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":8,"comments":4,"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":"inv","index":0,"n_rows":113,"n_cols":13,"rows_kept":113,"cut":false,"hidden":false,"merged":[]}
["Code Article","Quantité","Genre","Description","Marque","Saison","PV"]
["S800HF",15,"TOP             K9 H3 F8 F7 53","15-014                        ","GLOSS LINE                                      S8","2018E ",25]
[null,null,1,2,3,4,5,6,"UNI","---",null,"XXX","tailles"]
["DIVERS",null,4,5,2,1,3,null,null,null,null,null,"Quantités par taille"]
[]
["S800HH",3,"ROBE                     B4 07","15-018                        ","GLOSS LINE                                      S8","2018E ",35]
[null,null,1,2,3,4,5,6,"UNI","---",null,"XXX"]
["DIVERS",null,null,1,null,1,1]
[]
["S800HO",4,"ROBE                     B4 07","15-066                        ","GLOSS LINE                                      S8","2018E ",32]
[null,null,1,2,3,4,5,6,"UNI","---",null,"XXX"]
["DIVERS",null,2,1,null,null,1]
[]
["S800HP",12,"ROBE                     B4 07","15-075                        ","GLOSS LINE                                      S8","2018E ",32]
[null,null,1,2,3,4,5,6,"UNI","---",null,"XXX"]
["DIVERS",null,2,1,1,1,1]
["BLEU",null,2,3,1]
[]
["S800HQ",27,"ROBE                     B4 07","15-078                        ","GLOSS LINE                                      S8","2018E ",32]
[null,null,1,2,3,4,5,6,"UNI","---",null,"XXX"]
["DIVERS",null,5,6,5,5,6]
[]
["S800HS",25,"ROBE                     B4 07","15-084                        ","GLOSS LINE                                      S8","2018E ",30]
[null,null,1,2,3,4,5,6,"UNI","---",null,"XXX"]
["DIVERS",null,10,11,2,-1,3]
[]
["S800HT",29,"ROBE                     B4 07","16-207 LONGUE                 ","GLOSS LINE                                      S8","2018E ",43]
[null,null,1,2,3,4,5,6,"UNI","---",null,"XXX"]
["DIVERS",null,8,5,6,7,3]
[]
["S800HU",36,"CHEMISE               87 37 04","16-209                        ","GLOSS LINE                                      S8","2018E ",33]
[null,null,1,2,3,4,5,6,"UNI","---",null,"XXX"]
["DIVERS",null,8,8,8,8,4]
[]
["S800HV",24,"TSHIRT          F9 91 55 36 25","16-208                        ","GLOSS LINE                                      S8","2018E ",23]
[null,null,1,2,3,4,5,6,"UNI","---",null,"XXX"]
["DIVERS",null,7,4,4,2,7]
[]
["S800HW",25,"ROBE                     B4 07","16-203  LONGUE                ","GLOSS LINE                                      S8","2018E ",38]
[null,null,1,2,3,4,5,6,"UNI","---",null,"XXX"]
["DIVERS",null,3,6,6,5,5]
[]
["S800HX",10,"TUNIQUE                     42","16-039                        ","GLOSS LINE                                      S8","2018E ",35]
[null,null,1,2,3,4,5,6,"UNI","---",null,"XXX"]
["DIVERS",null,1,2,-3,1,9]
[]
["S800HY",12,"ROBE                     B4 07","16-204                        ","GLOSS LINE                                      S8","2018E ",25]
[null,null,1,2,3,4,5,6,"UNI","---",null,"XXX"]
["DIVERS",null,4,4,1,null,3]
[]
["S800HZ",2,"TOP             K9 H3 F8 F7 53","16-204-2                      ","GLOSS LINE                                      S8","2018E ",18]
[null,null,1,2,3,4,5,6,"UNI","---",null,"XXX"]
["DIVERS",null,null,null,null,2]
[]
["S800I0",3,"JUPE                          ","16-204-3                      ","GLOSS LINE                                      S8","2018E ",13]
[null,null,1,2,3,4,5,6,"UNI","---",null,"XXX"]
["DIVERS",null,2,1]
[]
["S800I1",24,"ROBE                     B4 07","16-206                        ","GLOSS LINE                                      S8","2018E ",30]
[null,null,1,2,3,4,5,6,"UNI","---",null,"XXX"]
["DIVERS",null,6,5,3,6,4]
[]
["S800I2",12,"ROBE                     B4 07","16-077                        ","GLOSS LINE                                      S8","2018E ",25]
[null,null,1,2,3,4,5,6,"UNI","---",null,"XXX"]
["DIVERS",null,6,5,1]
[]
["S800I3",30,"GILET                    92 02","16-078                        ","GLOSS LINE                                      S8","2018E ",20]
[null,null,1,2,3,4,5,6,"UNI","---",null,"XXX"]
["DIVERS",null,7,7,7,3,6]
[]
["S800I4",19,"ROBE                     B4 07","16-210                        ","GLOSS LINE                                      S8","2018E ",30]
[null,null,1,2,3,4,5,6,"UNI","---",null,"XXX"]
["DIVERS",null,4,5,3,4,3]
[]
["S800I5",34,"GILET                    92 02","16-200                        ","GLOSS LINE                                      S8","2018E ",30]
[null,null,1,2,3,4,5,6,"UNI","---",null,"XXX"]
["DIVERS",null,8,7,7,7,5]
[]
["S800I6",12,"TSHIRT          F9 91 55 36 25","16-201                        ","GLOSS LINE                                      S8","2018E ",23]
[null,null,1,2,3,4,5,6,"UNI","---",null,"XXX"]
["DIVERS",null,3,3,3,2,1]
[]
["S800I7",20,"ROBE                     B4 07","16-034                        ","GLOSS LINE                                      S8","2018E ",25]
[null,null,1,2,3,4,5,6,"UNI","---",null,"XXX"]
["DIVERS",null,5,3,5,3,4]
[]
["S800I8",20,"GILET                    92 02","16-035                        ","GLOSS LINE                                      S8","2018E ",23]
[null,null,1,2,3,4,5,6,"UNI","---",null,"XXX"]
["DIVERS",null,6,4,3,1,6]
[]
["S800I9",27,"ENSEMBLE                    06","16-204-2+16-204-3 TOP+JUPE    ","GLOSS LINE                                      S8","2018E ",31]
[null,null,1,2,3,4,5,6,"UNI","---",null,"XXX"]
["DIVERS",null,5,2,7,7,6]
[]
["Z4000P",31,"ROBE                     B4 07","15-056                        ","GLOSS LINE                                      Z4","2018E ",30]
[null,null,1,2,3,4,5,6,"UNI","---",null,"XXX"]
["DIVERS",null,8,4,6,5,8]
[]
["Z4000Q",8,"ROBE                     B4 07","15-008                        ","GLOSS LINE                                      Z4","2018E ",30]
[null,null,1,2,3,4,5,6,"UNI","---",null,"XXX"]
["DIVERS",null,-2,-3,-2,7,8]
[]
["Z4000R",26,"ROBE                     B4 07","14-118                        ","GLOSS LINE                                      Z4","2018E ",24]
[null,null,1,2,3,4,5,6,"UNI","---",null,"XXX"]
["DIVERS",null,5,5,6,4,6]
[]
["Z4000S",10,"ROBE                     B4 07","15-061                        ","GLOSS LINE                                      Z4","2018E ",27]
[null,null,1,2,3,4,5,6,"UNI","---",null,"XXX"]
["DIVERS",null,5,1,null,1,3]
[]
["Z4000T",38,"ROBE                     B4 07","15-055                        ","GLOSS LINE                                      Z4","2018E ",21]
[null,null,1,2,3,4,5,6,"UNI","---",null,"XXX"]
["DIVERS",null,9,9,9,6,5]

{"sheet":"client","index":1,"n_rows":78,"n_cols":30,"rows_kept":78,"cut":false,"hidden":false,"merged":[]}
["Extraction du fichier client",null,"DERNIER CLIENT  17-04-2018",1100264,"L&L FASHION"]
[]
["NUM","NOM","ADRESSE","CP","LOCALITE","PAYS","TEL","FAX","EMAIL","LANGUE","TVA","INFOS BANQUE","CPT BANQUE","CATEGORIE","ADRESSE LIV","CP LIV","LOC LIV","PAYS LIV","BOUTIQUE","INTRA","REMISE","GSM","ADRESSE ENVOI","CP ENVOI","LOC ENVOI","PAYS ENVOI","CONTACT","INFO FACT","EXO","KVN NUMMER"]
[40017,"TENDANCE SARL","LE COURS",83560,"VINON SUR VERDON","France",null,null,"carlacorella@sfr.fr","FR",null,null,null,"Client Pro 1",null,null,null,"Belgique","TENDANCE BOUTIQUE","Non (Avec TVA)",0,624788602,null,null,null,"Belgique","CARLA",null,"Non"]
[1100109,"TERZI MELINA","5 IMPASSE DU SIROCCO",31140,"LAUNAGUET","France","07 77 08 89 35",null,null,null,"FR522077908",null,null,"Client Pro 1",null,null,null,"France",null,"Non (Avec TVA)",0,null,null,null,null,"France",null,null,"Non"]
[2194,"TEX SCRL","RUE DES DOMINICAINS,6",4000,"LIEGE","Belgique",42237939,null,null,"FR","BE0429519760",null,null,"Client Pro 1","IDEM",null,null,"Belgique","BOUTIQUE BIANCHI","Non (Avec TVA)",3,null,"IDEM",null,null,"Belgique",null,null,"Non"]
[2102,"THDM","CHAUSSEE DE NINOVE,555",1070,"BRUXELLES","Belgique",23515748,475478473,"helene1971@hotmail.be","FR","BE0475033546",null,null,"Client Pro 1",null,null,null,"Belgique","B52","Non (Avec TVA)",5,476021042,"PASSAGE WELLINGTON,47",1410,"WATERLOO","Belgique","NIKOLETTOS",null,"Non"]
[2051,"THE FAMOUS BVBA","DAALSTRAAT 129",3690,"ZUTENDAAL","Belgique",null,null,null,null,"BE0411976618",null,null,"Client Pro 1",null,null,null,"Belgique","GOGO CLUB","Non (Avec TVA)",0,476546776,null,null,null,"Belgique",null,null,"Non"]
[2110,"THE FAMOUS BVBA","DAALSTRAAT,129",3690,"ZUTENDAAL","Belgique",null,null,null,"NL","BE0411976618",null,null,"Client Pro 1",null,null,null,"Belgique","GOGO CLUB","Non (Avec TVA)",0,476546776,null,null,null,"Belgique",null,null,"Non"]
[1100276,"THE STYLE CLOSET","02-23 I12 KATONG MALL EAST COAST ROAD",428802,"SINGAPORE","Singapour","+65 93803376",null,null,null,null,null,null,"Client Pro 1",null,null,null,"France","THE STYLE CLOSET","Non (Avec TVA)",0,null,null,null,null,"France","PENNY LOH",null,"Non"]
[1100108,"TIEGRA LTD","18 NIKIFOROU FOKA STREET FLAT 201",2039,"NICOSIA","Chypre",45799614868,null,"photini@mavrides.info",null,"CY101462800",null,null,"Client Pro 1",null,null,null,"France","TIEGRA LTD","Oui (0% de TVA)",0,null,null,null,null,"France","FOTINI",null,"Non"]
[1100094,"TIGER ROSE","15 HIGH ST PETERSPEILD","GU323JT","HAMPSHIRE","Royaume-Uni",null,null,null,null,874501421,null,null,"Client Pro 1",null,null,null,"France","IDEM","Oui (0% de TVA)",0,null,null,null,null,"France","VOSIEOGRAM",null,"Non"]
[1100164,"TILIA","4 BOULEVARD EDOUARD BAUDOUIN",6160,"JUAN LES PINS","France",492940836,null,null,null,null,null,null,"Client Pro 1",null,null,null,"France","TILIA","Non (Avec TVA)",0,null,null,null,null,"France","CAVALIER BABETTE",null,"Non"]
[1100137,"TIN TINO FASHION AB","KORSGATAN 3","SE-411 16","GOTHENBURG","Suede","+4631446320",null,"ingela@tintino.se",null,"SE 556649532001",null,null,"Client Pro 1",null,null,null,"France","TIN TINO","Oui (0% de TVA)",0,"+46705755813",null,null,null,"France","INGELA",null,"Non"]
[1100117,"TMI DISCONAILS","PARNUNKATU 5G26",980,"HELSINKI","France",null,null,null,null,"FL 1849904-9",null,null,"Client Pro 1",null,null,null,"France",null,"Oui (0% de TVA)",0,null,null,null,null,"France","KRISTIIN",null,"Non"]
[2237,"TO HAVE SUN SPRL","ROUTE DE PHILIPPEVILLE,3",6120,"NALINNES","Belgique",71228669,null,"laeti@pardelaleshaies.be",null,"BE0500540190",null,363112105061,"Client Pro 1","ROUTE DE PHILIPPEVILLE,3",null,null,"Belgique","X-TEN","Non (Avec TVA)",0,477642072,"ROUTE DE PHILIPPEVILLE,3",null,null,"Belgique","LAETITIA PUPPIN",null,"Non"]
[2275,"TOMBER DANS LES POMMES","RUE DES ECOLES,2",5620,"FLORENNES","Belgique",71614807,71614582,"tomberdanslespommes @hotmail.com","FR","BE0889 929 270",null,null,"Client Pro 1","IDEM",null,null,"Belgique","TOMBER DANS LES POMMES","Non (Avec TVA)",0,478209916,"IDEM",null,null,"Belgique","DENEUMOUSTIER SYLVIE",null,"Non"]
[400003,"TOP MODELE","2 RUE ST VINCENT",30100,"ALES","France",null,null,null,"FR",null,null,null,"Client Pro 1",null,null,null,"Belgique","TOP MODELE","Non (Avec TVA)",0,null,null,null,null,"Belgique",null,null,"Non"]
[2184,"TRADO","RUE ADOLPHE BUYL 14",8400,"OOSTENDE","Belgique",59803791,null,"trado.nv.@telenet.be",null,"BE0426148813",null,null,"Client Pro 1",null,null,null,"Belgique","SAIL & COUNTRY","Non (Avec TVA)",0,498310395,null,null,null,"Belgique","ROETS MARINA",null,"Non"]
[200071,"TRES CHOUETTE FASHION BVBA","SINT IGNATUSSTRAAT 55",9120,"KALLO","Belgique",null,null,"vickydeckx@gmail.com","NL","BE0817 353 078",null,null,"Client Pro 1",null,null,null,"Belgique",null,"Non (Avec TVA)",0,477555890,null,null,null,"Belgique","VICKY DECKX",null,"Non"]
[2059,"TRESORS DES DAMES","RUE DES SUREAUX,23",4000,"LIEGE","Belgique",null,null,"gd-aurore@hotmail.com","FR","BE0844296314",null,null,"Client Pro 1",null,null,null,"Belgique","TRESORS DES DAMES","Non (Avec TVA)",0,495143297,null,null,null,"Belgique","GODFROID AURORE",null,"Non"]
[1100163,"TRISAP EXPLORATEUR","29 RUE DES MOUETTES",97434,"SALINE LES BAINS","France",692609607,null,null,null,null,null,null,"Client Pro 1","36 RUE PASTEUR",97400,"SAINT DENIS","France","EXPLORATEUR","Oui (0% de TVA)",0,null,null,null,null,"France","GERARD CHARPENTIER","aireno 0148625251 mr guillaumart","Non"]
[1100202,"TROUILLE EMMANUELLE","PARQUE SANTIAGO 3 LOCAL 126 AVENIDA DE LAS AMERICA",38660,"PLAYA DE LAS AMERICA TENERIFE","Espagne","+34 922083614",null,"manuela-35@hotmail.es",null,"ES -X2467038N",null,null,"Client Pro 1",null,null,null,"France","TROUILLE EMMANUELLE","Oui (0% de TVA)",5,null,null,null,null,"France","EMMANUELLE",null,"Non"]
[40056,"TRUC DE OUF","81 COURS LAFAYETTE",83000,"TOULON","France",619235516,null,null,"FR",null,null,null,"Client Pro 1",null,null,null,"Belgique","TRUC DE OUF","Non (Avec TVA)",0,null,null,null,null,"Belgique","GARNERO JEAN LOUIS",null,"Non"]
[40147,"TURCAN MARIE GABRIELLE","177 ROUTE DE VOLONNE",4200,"SISTERON","France",492614795,null,null,"FR",null,null,null,"Client Pro 1",null,null,null,"Belgique","TURCAN MARIE GABRIELLE","Non (Avec TVA)",0,null,null,null,null,"Belgique",null,null,"Non"]
[2144,"TUTTO UOMO","BOULEVARD  TIROU 34",6000,"CHARLEROI","Belgique","071 322 496",null,null,null,"0877 974 813",null,null,"Client Pro 1",null,null,null,"Belgique","TUTTO UOMO","Non (Avec TVA)",0,"0474 824 387",null,null,null,"Belgique","JERMOUNI NORA",null,"Non"]
[1100237,"UB CREATIVE","49 OXFORD  ROAD KENSINGTON",2094,"AFRIQUE DU SUD","France",null,null,null,null,null,null,null,"Client Pro 1",null,null,null,"France","UB CREATIVE","Non (Avec TVA)",0,null,null,null,null,"France","TALI",null,"Non"]
[40090,"UN JOUR OU L AUTRE SARL","24 BOULEVARD DE CREISSEL",11100,"NARBONNE","France",null,null,null,"FR",null,null,null,"Client Pro 1",null,null,null,"Belgique","UN JOUR OU L AUTRE SARL","Non (Avec TVA)",0,null,null,null,null,"Belgique",null,null,"Non"]
[40142,"UN TEMPS POUR ELLE BOUTIQUE","86 AVENUE DES FRERES LUMIERES",83160,"LA VALETTE","France",489966151,null,null,"FR",null,null,null,"Client Pro 1",null,null,null,"Belgique","UN TEMPS POUR ELLE BOUTIQUE","Non (Avec TVA)",0,615445589,null,null,null,"Belgique",null,null,"Non"]
[200007,"UNE FEMME , UN STYLE ...","14 PLACE CHARLES DE GAULLE",59870,"MARCHIENNES","France","03 27 97 10 07",null,null,"FR","FR 00 518 000 948",null,null,"Client Pro 1","IDEM",null,null,"Belgique","UNE FEMME , UN STYLE....","Oui (0% de TVA)",0,null,"IDEM",null,null,"Belgique",null,null,"Non"]
[2211,"URBAIN FASHION TEAM","A. VAN   LANDEGHEMSTRAAT  12",2830,"WILLEBROEK","Belgique","03 866 39 65",null,"urbainfashion@hotmail.com",null,"BE0466502791",null,null,"Client Pro 1",null,null,null,"Belgique",null,"Non (Avec TVA)",0,null,null,null,null,"Belgique",null,null,"Non"]
[2220,"V & J BOUTIQUE","CHAUSSEE DE LIEGE,1005",5101,"LIVES/SUR/MEUSE","Belgique",null,null,"micheledessart02@gmail.com","FR","BE 0690353651","CREDIT  AGRICOLE",103027478754,"Client Pro 1","AVENUE J.MATERNE,34",5100,"JAMBES","Belgique",null,"Non (Avec TVA)",0,494768850,null,null,null,"Belgique","DESSART MICHELE",null,"Non"]
[200058,"V.O.F VER VENNE VERLINDE","ST ARNOLDOLAAN 47",8200,"ST MICHIELS","Belgique",null,null,null,"NL",894279226,null,null,"Client Pro 1",null,null,null,"Belgique","V.O.F","Non (Avec TVA)",0,null,null,null,null,"Belgique","MADAME VER LINDE CATHERINE",null,"Non"]
[400017,"VALENTIN  MARRO SAS","14 TRAVERSE PICARON",13016,"MARSEILLE","France",673405368,null,null,"FR",null,null,null,"Client Pro 1",null,null,null,"Belgique","VALENTIN MARRO SAS","Non (Avec TVA)",0,null,null,null,null,"Belgique",null,null,"Non"]
[40118,"VALENTINA BOUTIQUE","CTRE CMCIALE GRAND V 117 TRAVERSE DE LA MONTE",13011,"MARSEILLE","France",null,null,null,"FR",null,null,null,"Client Pro 1",null,null,null,"Belgique","VALENTINA BOUTIQUE","Non (Avec TVA)",0,null,null,null,null,"Belgique",null,null,"Non"]
[200048,"VALKENAERS YVETTE","PASTORIEPLEIN 3",8020,"OOSTKAMP","Belgique",null,null,null,"NL","BE0537 168 974",null,null,"Client Pro 1",null,null,null,"Belgique","KLEURENFASHION","Non (Avec TVA)",0,null,null,null,null,"Belgique",null,null,"Non"]
[1100216,"VALVIC ST","RUE COPERNIC",62000,"ARRAS","France",668989009,null,null,null,"FR 74793541533",null,null,"Client Pro 1",null,null,null,"France","WEARE","Non (Avec TVA)",0,null,null,null,null,"France","BOULANGER SOPHIE",null,"Non"]
[40115,"VALY BOUTIQUE","18 BD CARNOT",83780,"FLAYOSC","France",646352208,null,null,"FR",null,null,null,"Client Pro 1",null,null,null,"Belgique","VALY BOUTIQUE","Non (Avec TVA)",0,null,null,null,null,"Belgique",null,null,"Non"]
[2032,"VAN DEN BRANDE STAF","KERKSTRAAT.22",2450,"LAAKDAL","Belgique",null,null,null,"NL","BE0629335592",null,null,"Client Pro 1",null,null,null,"Belgique","UNICA DONNA","Non (Avec TVA)",0,null,null,null,null,"Belgique",null,null,"Non"]
[200020,"VAN DOOREN CONNY","KORENSTRAAT 9",3740,"BILZEN","Belgique",null,null,"vdconny@skynet.be","NL","BE0730 161 956",null,null,"Client Pro 1","IDEM",null,null,"Belgique","BUGGY FASHION","Non (Avec TVA)",0,"0496/289268","IDEM",null,null,"Belgique",null,null,"Non"]
[200031,"VAN GENECHTEN CINDY","BALEN-NEETLAAN 23",2490,"BALEN","Belgique","014:810725",null,null,"NL","BE0728 365 971",null,null,"Client Pro 1",null,null,null,"Belgique","CINDY' S HOMESHOP","Non (Avec TVA)",0,null,null,null,null,"Belgique","CINDY",null,"Non"]
[200012,"VAN VROENHOVEN STEPHANIE","PAGELAAN 58","5641 CD","EINDHOVEN","Pays-Bas",null,null,null,"NL","NL 207946152B01",null,null,"Client Pro 1",null,null,null,"Belgique",null,"Oui (0% de TVA)",0,null,null,null,null,"Belgique",null,null,"Non"]
[2254,"VAN.HOUT  NATHALIE","34 CHAUSSEE DE FLEURUS",6060,"GILLY","Belgique",null,"071 414256",null,null,"BE 0654 682 989",null,null,"Client Pro 1","18 RUE NEUVE",6000,"CHARLEROI","Belgique","CRISTAL MODE","Non (Avec TVA)",0,"0488/28 49 57",null,null,null,"Belgique",null,null,"Non"]
[2277,"VANDENBULTE","HOOG STRAAT 30",9620,"ZOTTEGEM","Belgique",null,null,null,"F","BE 735 258 317",null,null,"Client Pro 1",null,null,null,"Belgique",null,"Non (Avec TVA)",0,"0475 558 362",null,null,null,"Belgique",null,null,"Non"]
[2195,"VANDEPOPELIERE ANNICK","KORTRIJKSTRAAT,110",8700,"TIELT","Belgique",51406742,null,"info@florinefashion.be",null,"BE0883874391",null,null,"Client Pro 1","IDEM",null,null,"Belgique","BOUTIQUE FLORINE FASHION","Non (Avec TVA)",3,485435450,"IDEM",null,null,"Belgique",null,null,"Non"]
[2139,"VANDEVELDE CAROLINE","WALLENSTRAAT,53",8800,"ROESELARE","Belgique",null,null,"luc.wallays@proximedia.be","FR","BE0530948801",null,null,"Client Pro 1","WALLENSTRAAT, 3",8800,"ROESELARE","Belgique",null,"Non (Avec TVA)",3,492691584,null,null,null,"Belgique",null,null,"Non"]
[1100150,"VANITY","2 RUE DES ANCIENNES MAIRIES",77700,"MAGNY LE HONGRE","France",671583900,null,null,null,null,null,null,"Client Pro 1",null,null,null,"France","VANITY","Non (Avec TVA)",0,null,null,null,null,"France","VERNET",null,"Non"]
[1100266,"VELVET S.L.","C/CONDE DE ROMANONES,10",28012,"MADRID","Espagne","0034 913692924",null,"velvet@brasiliamoda.net",null,"ESB78408838",null,null,"Client Pro 1",null,null,null,"France","VELVET S.L.","Oui (0% de TVA)",20,null,null,null,null,"France",null,"   GROSSITE","Non"]
[1150001,"VENTE COMPTOIR PARIS DETAIL FA",null,null,null,"France",null,null,null,"FR",null,null,null,"Client Pro 1",null,null,null,"France",null,"Vente comptoir",0,null,null,null,null,"France",null,null,"Non"]
[2052,"VERA GIELIS","KONTICHSTRAAT,76",2650,"EDEGEM","Belgique",null,null,"vegielis@gmail.com","NL","BE0830843404",null,null,"Client Pro 1",null,null,null,"Belgique","FASHION@HOME","Non (Avec TVA)",0,473642231,null,null,null,"Belgique",null,null,"Non"]
[2028,"VERMEYLEN MANUELA","WELKOMSTRAAT 56",2160,"WOMMELGEM","Belgique",null,null,"manuelalain@skynet.be",null,"BE0635425620",null,null,"Client Pro 1",null,null,null,"Belgique",null,"Non (Avec TVA)",0,null,null,null,null,"Belgique",null,null,"Non"]
[40064,"VETEMODE BOUTIQUE","5 RUE EMERIC DAVID",13100,"AIX EN PROVENCE","France",442386628,null,null,"FR",null,null,null,"Client Pro 1",null,null,null,"Belgique","VETEMODE BOUTIQUE","Non (Avec TVA)",0,null,null,null,null,"Belgique",null,null,"Non"]
[1100088,"VIA CORINA","15 RUE RAYMOND BOTTE",76380,"CANTELEU","France",null,null,"corinnelm@orange.fr","FR","FR5744842180",null,null,"Client Pro 1",null,null,null,"France","IDEM","Non (Avec TVA)",0,687773303,null,null,null,"France","CORINE LEROY",null,"Non"]
[40008,"VIA MILANO","6 MONTE ANDRE VIALLAT",13300,"SALON DE PROVENCE","France",490558705,null,null,"FR","514 307 495 00010","CREDIT AGRICOLLE",null,"Client Pro 1","IDEM",null,null,"Belgique","VIA MILANO","Non (Avec TVA)",0,661774048,"IDEM",null,null,"Belgique","STRIPPOLI ISABELLE",null,"Non"]
[1100135,"VIP ST GERMAIN","8 RUE DES COCHES",78100,"ST GERMAIN EN LAYE","France",null,null,null,null,null,null,null,"Client Pro 1",null,null,null,"France","VIP ST GERMAIN","Non (Avec TVA)",0,621417391,null,null,null,"France","DANNY",null,"Non"]
[40074,"VIVIANE BOUTIQUE","18 COURS DE LA PLACE",34725,"SAINT ANDRE DE SANGONIS","France",467540887,null,null,"FR",null,null,null,"Client Pro 1",null,null,null,"Belgique","VIVIANE BOUTIQUE","Non (Avec TVA)",0,null,null,null,null,"Belgique",null,null,"Non"]
[2228,"W.V.G SERVIVE COMM.V.","HOOIDONKSTRAAT,50B",2560,"NIJLEN","Belgique",null,null,"W.V.G.service@hotmail.be","NL","BE0845774771",null,null,"Client Pro 1","IDEM",null,null,"Belgique","TIGRI FASHION","Non (Avec TVA)",0,479274397,null,null,null,"Belgique","WIM VAN GENECHTEN",null,"Non"]
[2185,"WINDOW FASHION",null,3740,"BILZEN","Belgique",89511903,null,null,"NL",0,null,null,"Client Pro 1",null,null,null,"Belgique","WINDOW FASHION","Non (Avec TVA)",0,null,null,null,null,"Belgique","MATT BROUWERS",null,"Non"]
[1100074,"WOMAN FASHION","CC CARREFOUR 5 RUE DE LA CROIX ST JACQUES",91620,"LA VILLE DU BOIS","France",169014640,null,"ma-citywoman@live.fr","FR",null,null,null,"Client Pro 1","IDEM",null,null,"France","CITY WOMAN","Non (Avec TVA)",0,617016122,"IDEM",null,null,"France","MURIEL",null,"Non"]
[1100218,"WOMAN SLIRT SL","BRUC 34",8010,"BARCELONE","Espagne",null,null,null,null,"B64771272",null,null,"Client Pro 1",null,null,null,"France","WOMAN SLIRT SL","Oui (0% de TVA)",25,"+34 691 441 656",null,null,null,"France","EMILIA DIAZ",null,"Non"]
[1100049,"WOMANCOLLECTION","VIA COLOMBARE 123",25019,"SIRMIONE","Italie",393409117969,null,"womancollection@virgilio.it","IT",3471490981,null,null,"Client Pro 1",null,null,null,"France","WOMANCOLLECTION","Oui (0% de TVA)",0,null,null,null,null,"France","ANNA MARIA NARDIELLO",null,"Non"]
[200005,"XIM GCV","SINT ANTONIUSSTRAAT 31",2300,"TURNHOUT","Belgique",null,null,null,"NL","BE0538 564 586",null,null,"Client Pro 1","IDEM",null,null,"Belgique","XIM","Non (Avec TVA)",0,494544643,"IDEM",null,null,"Belgique","VERVAECKE MARNIX",null,"Non"]
[1100103,"Y STRENA","AVENIDA JUAN MELGAREJO CC VISTAHERMOSA",11500,"EL PUERTODE SANTA MARIA CADIZ","Espagne","+34663774814",null,null,null,"ES 44967490Y",null,null,"Client Pro 1","IDEM",null,null,"France","Y STRENA","Oui (0% de TVA)",0,null,null,null,null,"France","ALBERTO NIETO","EUROTRANS","Non"]
[1100271,"YASMINE","13 RUE NATIONALE",72000,"LE MANS","France",243243598,null,null,null,null,null,null,"Client Pro 1",null,null,null,"France","YASMINE","Non (Avec TVA)",0,null,null,null,null,"France","FAURE CHANTALE",null,"Non"]
[40041,"YLANG YLANG","9 BD FREDERIC MISTRAL",13800,"ISTRES","France",442550193,null,null,"FR",38994366300036,null,null,"Client Pro 1",null,null,null,"Belgique","YLANG YLANG","Non (Avec TVA)",0,null,null,null,null,"Belgique","BETTY",null,"Non"]
[1100099,"YLISTARON HALPA-AITTA OY","KAUKOLANRAITTI 38",61400,"YLISTARO","Finlande",null,358400761578,null,null,"FI0913098-7",null,null,"Client Pro 1",null,null,null,"France","YLISTARON HALPA-AITTA OY","Oui (0% de TVA)",0,null,null,null,null,"France",null,null,"Non"]
[40009,"YOJE STORY","5 RUE JACQUES D'ARAGON",34000,"MONTPELLIER","France",null,null,null,"FR",791376114,null,null,"Client Pro 1","22 TER RUE SAINT ROCH",34250,"PALAVAS LES FLOTS","Belgique","3 COULEURS","Non (Avec TVA)",0,609056832,null,null,null,"Belgique","LAURENCE OU JEROME",null,"Non"]
[2004,"YORKA","GENUTSTRAAT 1B3",3740,"BILZEN","Belgique",89492072,null,null,"NL","BE0838792157",null,null,"Client Pro 1",null,null,null,"Belgique","YORKA","Non (Avec TVA)",0,495149322,null,null,null,"Belgique",null,null,"Non"]
[2035,"YVANNA BOUTIQUE","RUE SYLVAIN GUYAUX 41",7100,"LA LOUVIERE","Belgique",null,null,null,"FR","BE0822315817",null,null,"Client Pro 1",null,null,null,"Belgique","BOUTIQUE YVANNA","Non (Avec TVA)",3,499193099,null,null,null,"Belgique",null,null,"Non"]
[2036,"YVANNA BOUTIQUE","RUE SYLVAIN GUYAUX 41",7100,"LA LOUVIERE","Belgique",499193099,null,null,null,"BE0822315817",null,null,"Client Pro 1",null,null,null,"Belgique","BOUTIQUE YVANNA","Non (Avec TVA)",0,null,null,null,null,"Belgique",null,null,"Non"]
[2120,"YVANNA BOUTIQUE","RUE SYLVAIN GUYAUX,41",7100,"LA LOUVIERE","Belgique",null,null,null,"FR","BE0822315817",null,null,"Client Pro 1",null,null,null,"Belgique",null,"Non (Avec TVA)",0,499193099,null,null,null,"Belgique",null,null,"Non"]
[40076,"ZABEH BOUTIQUE","9 RUE DE LA COQUILLE",34500,"BEZIERS","France",467493974,null,"zabeh@hotmail.com","FR",null,null,null,"Client Pro 1",null,null,null,"Belgique","ZABEH BOUTIQUE","Non (Avec TVA)",0,null,null,null,null,"Belgique",null,null,"Non"]
[40191,"ZAZA DU CAP BOUTIQUE","PORT EN BONNE",34300,"CAP D AGDE","France",null,null,null,"FR",null,null,null,"Client Pro 1",null,null,null,"Belgique","ZAZA DU CAP BOUTIQUE","Non (Avec TVA)",0,null,null,null,null,"Belgique",null,null,"Non"]
[40139,"ZENITHA BOUTIQUE","63 GRANDE RUE",39800,"POLIGNY","France",384737197,null,null,"FR",null,null,null,"Client Pro 1",null,null,null,"Belgique","ZENITHA BOUTIQUE","Non (Avec TVA)",0,null,null,null,null,"Belgique","PAGEARD MADAME",null,"Non"]
[2197,"ZIEZA","LAAR,,11",2400,"MOL","Belgique",null,null,"ziezamol@gmail.com","NL","BE0829098689",null,null,"Client Pro 1",null,null,null,"Belgique",null,"Non (Avec TVA)",0,479537551,null,null,null,"Belgique",null,null,"Non"]
[1100126,"ZOE","FLORASTRASSE 32",8008,"ZURICH","Suisse","0041 443832988","0041 443832977",null,null,"CHE 105922278",null,null,"Client Pro 1",null,null,null,"France","ZOE","Oui (0% de TVA)",0,null,null,null,null,"France","MICHEL SCHNEIDER","LA POSTE","Non"]
[2023,"ZOE ET BRAEGA","RUE JOSEPH  WAUTERS 29",4300,"WAREMME","Belgique",null,null,"maud-ina@hotmail.com","FR","BE0893524309",null,null,"Client Pro 1",null,null,null,"Belgique","BOUTIQUE MAUD-INA","Non (Avec TVA)",0,494764372,null,null,null,"Belgique","VIRGINIE REMY",null,"Non"]
[1100029,"ZOE X  BVBA","MEEUWENLAAN 11",8434,"WESTENDE","Belgique","+32478224252",null,"WIM.VG@hotmail.com","FR","BE 0477268407",null,null,"Client Pro 1","IDEM","IDEM","IDEM","Belgique","ZOE TREND","Oui (0% de TVA)",0,null,null,null,null,"Belgique","WIM VAN GASSEN",null,"Non"]

{"sheet":"MOD FACTURE","index":2,"n_rows":60,"n_cols":24,"rows_kept":60,"cut":false,"hidden":false,"merged":[[23,17,23,26],[24,17,24,26],[25,17,25,26],[26,17,26,26],[1,0,1,15],[3,12,3,14],[4,9,4,10],[5,9,5,15],[5,17,5,23],[7,9,7,10],[7,11,7,15],[7,17,7,18],[8,9,8,10],[6,9,6,15],[9,9,9,15],[9,17,9,20],[16,0,17,3],[10,9,10,15],[10,17,10,20],[11,9,11,15],[11,17,11,20],[12,9,12,15],[12,17,12,20],[14,4,15,11],[14,13,15,13],[14,14,15,16],[16,5,16,9],[17,10,18,10],[19,16,20,16],[19,1,20,1],[19,11,20,11],[19,12,20,12],[19,13,20,13],[19,14,20,14],[19,15,20,15],[48,10,49,12],[48,13,49,16],[50,0,50,1],[50,4,50,5],[50,6,50,7],[50,10,50,12],[50,13,50,16],[53,0,53,2],[53,13,53,16],[54,10,54,12],[54,13,54,16],[51,0,51,1],[51,4,51,5],[51,6,51,7],[51,10,51,12],[51,13,51,16],[52,0,52,1],[52,4,52,5],[52,6,52,7],[52,10,52,12],[52,13,52,16],[53,4,56,9]]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Date:"]
[null,null,null,null,null,null,null,"Numéro: "]
[null,null,null,null,null,null,null,"Nom: ",null,{"$f":"IF($J$5=0,\" \",R6)","v":" "},null,null,null,null,null,null,null,{"$f":"IF(J5=0,\" \",VLOOKUP(J5,client!$A$4:$AD$79309,2,FALSE))","v":" "}]
[null,null,null,null,null,null,null,"Adresse: ",null,{"$f":"IF($J$5=0,\" \",R7)","v":" "},null,null,null,null,null,null,null,{"$f":"IF($J$5=0,\" \",VLOOKUP($J$5,client!$A$4:$AD$79309,3,FALSE))","v":" "}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF($J$5=0,\"\",R8)","v":""},null,{"$f":"IF($J$5=0,\" \",VLOOKUP($J$5,client!$A$4:$AD$79309,5,FALSE))","v":" "},null,null,null,null,null,{"$f":"IF($J$5=0,\" \",VLOOKUP($J$5,client!$A$4:$AD$79309,4,FALSE))","v":" "},null,{"$f":"IF($J$5=0,\" \",VLOOKUP($J$5,client!$A$4:$AD$79309,5,FALSE))","v":" "}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF($J$5=0,\"\",R9)","v":""},null,null,null,null,null,null,null,{"$f":"IF($J$5=0,\" \",VLOOKUP($J$5,client!$A$4:$AD$79309,6,FALSE))","v":" "}]
[null,null,null,null,null,null,null,"T.V.A: ",null,{"$f":"IF($J$5=0,\" \",R10)","v":" "},{"$f":"IF(K6=0,\" \",VLOOKUP(K6,client!$A$4:$AD$79309,6,FALSE))","v":" "},{"$f":"IF(L6=0,\" \",VLOOKUP(L6,client!$A$4:$AD$79309,6,FALSE))","v":" "},{"$f":"IF(M6=0,\" \",VLOOKUP(M6,client!$A$4:$AD$79309,6,FALSE))","v":" "},{"$f":"IF(N6=0,\" \",VLOOKUP(N6,client!$A$4:$AD$79309,6,FALSE))","v":" "},{"$f":"IF(O6=0,\" \",VLOOKUP(O6,client!$A$4:$AD$79309,6,FALSE))","v":" "},{"$f":"IF(P6=0,\" \",VLOOKUP(P6,client!$A$4:$AD$79309,6,FALSE))","v":" "},null,{"$f":"IF($J$5=0,\" \",VLOOKUP($J$5,client!$A$4:$AD$79309,11,FALSE))","v":" "},null,null,null,{"$f":"IF(V6=0,\" \",VLOOKUP(V6,client!$A$4:$AD$79309,6,FALSE))","v":" "},{"$f":"IF(W6=0,\" \",VLOOKUP(W6,client!$A$4:$AD$79309,6,FALSE))","v":" "},{"$f":"IF(X6=0,\" \",VLOOKUP(X6,client!$A$4:$AD$79309,6,FALSE))","v":" "}]
[null,null,null,null,null,null,null,"Tél: ",null,{"$f":"IF(J5=0,\" \",R11)","v":" "},{"$f":"IF(K7=0,\" \",VLOOKUP(K7,client!$A$4:$AD$79309,6,FALSE))","v":" "},{"$f":"IF(L7=0,\" \",VLOOKUP(L7,client!$A$4:$AD$79309,6,FALSE))","v":" "},{"$f":"IF(M7=0,\" \",VLOOKUP(M7,client!$A$4:$AD$79309,6,FALSE))","v":" "},{"$f":"IF(N7=0,\" \",VLOOKUP(N7,client!$A$4:$AD$79309,6,FALSE))","v":" "},{"$f":"IF(O7=0,\" \",VLOOKUP(O7,client!$A$4:$AD$79309,6,FALSE))","v":" "},{"$f":"IF(P7=0,\" \",VLOOKUP(P7,client!$A$4:$AD$79309,6,FALSE))","v":" "},null,{"$f":"IF($J$5=0,\" \",VLOOKUP($J$5,client!$A$4:$AD$79309,7,FALSE))","v":" "}]
[null,null,null,null,null,null,null,"Mob: ",null,{"$f":"IF(J5=0,\" \",R12)","v":" "},{"$f":"IF(K8=0,\" \",VLOOKUP(K8,client!$A$4:$AD$79309,6,FALSE))","v":" "},{"$f":"IF(L8=0,\" \",VLOOKUP(L8,client!$A$4:$AD$79309,6,FALSE))","v":{"$error":"#N/A"}},{"$f":"IF(M8=0,\" \",VLOOKUP(M8,client!$A$4:$AD$79309,6,FALSE))","v":" "},{"$f":"IF(N8=0,\" \",VLOOKUP(N8,client!$A$4:$AD$79309,6,FALSE))","v":" "},{"$f":"IF(O8=0,\" \",VLOOKUP(O8,client!$A$4:$AD$79309,6,FALSE))","v":" "},{"$f":"IF(P8=0,\" \",VLOOKUP(P8,client!$A$4:$AD$79309,6,FALSE))","v":" "},null,{"$f":"IF($J$5=0,\" \",VLOOKUP($J$5,client!$A$4:$AD$79309,22,FALSE))","v":" "}]
[null,null,null,null,null,null,null,"Mail: ",null,{"$f":"IF(J5=0,\" \",R13)","v":" "},{"$f":"IF(K9=0,\" \",VLOOKUP(K9,client!$A$4:$AD$79309,6,FALSE))","v":" "},{"$f":"IF(L9=0,\" \",VLOOKUP(L9,client!$A$4:$AD$79309,6,FALSE))","v":" "},{"$f":"IF(M9=0,\" \",VLOOKUP(M9,client!$A$4:$AD$79309,6,FALSE))","v":" "},{"$f":"IF(N9=0,\" \",VLOOKUP(N9,client!$A$4:$AD$79309,6,FALSE))","v":" "},{"$f":"IF(O9=0,\" \",VLOOKUP(O9,client!$A$4:$AD$79309,6,FALSE))","v":" "},{"$f":"IF(P9=0,\" \",VLOOKUP(P9,client!$A$4:$AD$79309,6,FALSE))","v":" "},null,{"$f":"IF($J$5=0,\" \",VLOOKUP($J$5,client!$A$4:$AD$79309,9,FALSE))","v":" "}]
[]
[null,null,null,null,"F A C T U R E",null,null,null,null,null,null,null,null," N°","FA201860000"]
[]
[null,null,null,null,null,"Tailles"]
[null,null,null,null,null,"S","M","L","XL","XXL"]
[null,null,null,null,null,"SM","ML","LX",null,"U"]
["Code","Descrip.","GENRE","COMP","coul",36,38,40,42,44,"Qté","Prix Unit","Rem %","Rem *","Rem","Prix Unit","TOT Prix"]
["CO",null,null,null,null,1,2,3,4,5]
["S800HP",{"$f":"IF(A22=0,\" \",VLOOKUP(A22,inv!$A$2:$L$113,4,FALSE))","v":"15-075                        "},{"$f":"IF(A22=0,\" \",VLOOKUP(A22,inv!$A$2:$L$113,3,FALSE))","v":"ROBE                     B4 07"},"Poly 90% Elast 10%","DIVERS",null,null,null,null,null,{"$f":"IF(SUM(F22:J22)=0,\" \",SUM(F22:J22))","v":" "},{"$f":"IF(A22=0,\" \",VLOOKUP(A22,inv!$A$1:$L$113,7,FALSE))","v":32},null,null,{"$f":"IF((SUM(L22)-SUM(P22)=0),\"\",(SUM(L22)-SUM(P22))*SUM(K22))","v":""},{"$f":"IF(N22>0,N22,IF(A22=0,\"\",SUM(L22)-(SUM(L22)*SUM(M22))))","v":32},{"$f":"IF(A22=0,\" \",SUM(K22)*SUM(P22))","v":0},"Légende des couleurs d'onglets:"]
["S800HP",{"$f":"IF(A23=0,\" \",VLOOKUP(A23,inv!$A$2:$L$113,4,FALSE))","v":"15-075                        "},{"$f":"IF(A23=0,\" \",VLOOKUP(A23,inv!$A$2:$L$113,3,FALSE))","v":"ROBE                     B4 07"},"Poly 90% Elast 10%","BLEU",null,null,null,null,null," ",{"$f":"IF(A23=0,\" \",VLOOKUP(A23,inv!$A$1:$L$113,7,FALSE))","v":32},null,null,{"$f":"IF((SUM(L23)-SUM(P23)=0),\"\",(SUM(L23)-SUM(P23))*SUM(K23))","v":""},{"$f":"IF(N23>0,N23,IF(A23=0,\"\",SUM(L23)-(SUM(L23)*SUM(M23))))","v":32},{"$f":"IF(A23=0,\" \",SUM(K23)*SUM(P23))","v":0}]
[null,{"$f":"IF(A24=0,\" \",VLOOKUP(A24,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A24=0,\" \",VLOOKUP(A24,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A24=0,\" \",VLOOKUP(A24,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," ","En rouge: Les Ventes Comptoir 2 et 3"]
[null,{"$f":"IF(A25=0,\" \",VLOOKUP(A25,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A25=0,\" \",VLOOKUP(A25,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A25=0,\" \",VLOOKUP(A25,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," ","En turquoise: Les Factures, Factures Simplifiées et Notes de Crédit"]
[null,{"$f":"IF(A26=0,\" \",VLOOKUP(A26,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A26=0,\" \",VLOOKUP(A26,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A26=0,\" \",VLOOKUP(A26,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A27=0,\" \",VLOOKUP(A27,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A27=0,\" \",VLOOKUP(A27,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A27=0,\" \",VLOOKUP(A27,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A28=0,\" \",VLOOKUP(A28,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A28=0,\" \",VLOOKUP(A28,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A28=0,\" \",VLOOKUP(A28,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A29=0,\" \",VLOOKUP(A29,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A29=0,\" \",VLOOKUP(A29,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A29=0,\" \",VLOOKUP(A29,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A30=0,\" \",VLOOKUP(A30,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A30=0,\" \",VLOOKUP(A30,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A30=0,\" \",VLOOKUP(A30,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A31=0,\" \",VLOOKUP(A31,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A31=0,\" \",VLOOKUP(A31,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A31=0,\" \",VLOOKUP(A31,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A32=0,\" \",VLOOKUP(A32,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A32=0,\" \",VLOOKUP(A32,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A32=0,\" \",VLOOKUP(A32,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A33=0,\" \",VLOOKUP(A33,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A33=0,\" \",VLOOKUP(A33,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A33=0,\" \",VLOOKUP(A33,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A34=0,\" \",VLOOKUP(A34,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A34=0,\" \",VLOOKUP(A34,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A34=0,\" \",VLOOKUP(A34,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A35=0,\" \",VLOOKUP(A35,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A35=0,\" \",VLOOKUP(A35,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A35=0,\" \",VLOOKUP(A35,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A36=0,\" \",VLOOKUP(A36,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A36=0,\" \",VLOOKUP(A36,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A36=0,\" \",VLOOKUP(A36,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A37=0,\" \",VLOOKUP(A37,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A37=0,\" \",VLOOKUP(A37,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A37=0,\" \",VLOOKUP(A37,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A38=0,\" \",VLOOKUP(A38,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A38=0,\" \",VLOOKUP(A38,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A38=0,\" \",VLOOKUP(A38,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A39=0,\" \",VLOOKUP(A39,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A39=0,\" \",VLOOKUP(A39,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A39=0,\" \",VLOOKUP(A39,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A40=0,\" \",VLOOKUP(A40,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A40=0,\" \",VLOOKUP(A40,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A40=0,\" \",VLOOKUP(A40,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A41=0,\" \",VLOOKUP(A41,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A41=0,\" \",VLOOKUP(A41,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A41=0,\" \",VLOOKUP(A41,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A42=0,\" \",VLOOKUP(A42,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A42=0,\" \",VLOOKUP(A42,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A42=0,\" \",VLOOKUP(A42,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A43=0,\" \",VLOOKUP(A43,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A43=0,\" \",VLOOKUP(A43,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A43=0,\" \",VLOOKUP(A43,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A44=0,\" \",VLOOKUP(A44,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A44=0,\" \",VLOOKUP(A44,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A44=0,\" \",VLOOKUP(A44,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A45=0,\" \",VLOOKUP(A45,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A45=0,\" \",VLOOKUP(A45,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A45=0,\" \",VLOOKUP(A45,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A46=0,\" \",VLOOKUP(A46,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A46=0,\" \",VLOOKUP(A46,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A46=0,\" \",VLOOKUP(A46,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A47=0,\" \",VLOOKUP(A47,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A47=0,\" \",VLOOKUP(A47,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A47=0,\" \",VLOOKUP(A47,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A48=0,\" \",VLOOKUP(A48,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A48=0,\" \",VLOOKUP(A48,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A48=0,\" \",VLOOKUP(A48,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
["Total: ",{"$f":"SUM(K22:K48)","v":0},"pièce(s)",null,null,null,null,null,null,null,"Montant hors tva : ",null,null,{"$f":"SUM(Q22:Q48)+SUM(N51)","v":0}]
["Paiement :",null,"N° de Paiement utilisé :"]
["1. Bancontact :",null,null,"4. Cheque n° :  ",null,null,null,null,null,null,"Rem :",null,null,{"$f":"IF(SUM(Q22:Q48)=0,\"\",SUM(O22:O48))","v":""}]
["2. Cash :",null,null,"5. Virem. x Jours :  ",null,null,null,null,null,null,"Transport :"]
["3. Carte de Crédit :",null,null,"6. Traite:  ",null,null,null,null,null,null,"Sous-Total :",null,null,{"$f":"IF(N51=0,N49,SUM(N49)-SUM(N51)+SUM(N52))","v":0}]
["Signature client/ Handtekening klant :",null,null,null,null,null,null,null,null,null,"Tva:",20,"%",{"$f":"SUM(N53*L54)/100","v":0}]
[null,null,null,null,null,null,null,null,null,null,"TOTAL :",null,null,{"$f":"SUM(N53+N54)","v":0}]
[]
[]
[]
["Exportation (hors UE) exonérée de T.V.A. avec document d'exportation par un transitaire agréé."]
["Exonération de T.V.A. suivant article 39bis, alinéa premier, 1° du Code TVA  – Livraison Intracommunautaire."]

{"sheet":"MOD Vente Comptoir 2 et 3","index":3,"n_rows":54,"n_cols":18,"rows_kept":54,"cut":false,"hidden":false,"merged":[[22,17,22,26],[23,17,23,26],[24,17,24,26],[25,17,25,26],[52,0,52,2],[52,9,52,11],[52,12,52,16],[53,9,53,11],[53,12,53,16],[50,0,50,1],[50,5,50,6],[50,9,50,11],[50,12,50,16],[51,0,51,1],[51,5,51,6],[51,9,51,11],[51,12,51,16],[18,15,19,15],[18,16,19,16],[47,9,48,11],[47,12,48,16],[49,0,49,1],[49,5,49,6],[49,9,49,11],[49,12,49,16],[18,1,19,1],[18,11,19,11],[18,12,19,12],[18,13,19,13],[18,14,19,14],[15,5,15,9],[15,15,16,16],[16,0,17,0],[16,1,17,2],[16,10,17,10],[8,9,8,16],[9,9,9,16],[10,9,10,16],[11,9,11,16],[13,3,14,11],[13,14,14,14],[13,15,14,16],[7,9,7,16],[0,0,0,16],[3,12,3,15],[4,9,4,16],[5,9,5,16],[6,9,6,16]]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Date:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"VENTE COMPTOIR",null,null,null,null,null,null,null,null,null,null," N°","VC201865000"]
[]
[null,null,null,null,null,"Tailles"]
[null,null,null,null,null,"S","M","L","XL","XXL"]
[null,null,null,null,null,"SM","ML","LX",null,"U"]
["Code","Descrip.","GENRE","COMP","coul",36,38,40,42,44,"Qté","Prix Unit","Rem %","Rem *","Rem","Prix Unit","TOT Prix"]
["CO",null,null,null,null,1,2,3,4,5]
["S800HP",{"$f":"IF(A21=0,\" \",VLOOKUP(A21,inv!$A$2:$L$113,4,FALSE))","v":"15-075                        "},{"$f":"IF(A21=0,\" \",VLOOKUP(A21,inv!$A$2:$L$113,3,FALSE))","v":"ROBE                     B4 07"},"Poly 90% Elast 10%",null,null,null,1,null,null,{"$f":"IF(SUM(F21:J21)=0,\" \",SUM(F21:J21))","v":1},{"$f":"IF(A21=0,\" \",VLOOKUP(A21,inv!$A$1:$L$113,7,FALSE))","v":32},null,null,{"$f":"IF((SUM(L21)-SUM(P21)=0),\"\",(SUM(L21)-SUM(P21))*SUM(K21))","v":""},{"$f":"IF(N21>0,N21,IF(A21=0,\"\",SUM(L21)-(SUM(L21)*SUM(M21))))","v":32},{"$f":"IF(A21=0,\" \",SUM(K21)*SUM(P21))","v":32},"Légende des couleurs d'onglets:"]
[null,{"$f":"IF(A22=0,\" \",VLOOKUP(A22,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A22=0,\" \",VLOOKUP(A22,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A22=0,\" \",VLOOKUP(A22,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,{"$f":"IF((SUM(L22)-SUM(P22)=0),\"\",(SUM(L22)-SUM(P22))*SUM(K22))","v":""},{"$f":"IF(N22>0,N22,IF(A22=0,\"\",SUM(L22)-(SUM(L22)*SUM(M22))))","v":""},{"$f":"IF(A22=0,\" \",SUM(K22)*SUM(P22))","v":" "}]
[null,{"$f":"IF(A23=0,\" \",VLOOKUP(A23,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A23=0,\" \",VLOOKUP(A23,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A23=0,\" \",VLOOKUP(A23,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," ","En rouge: Les Ventes Comptoir 2 et 3"]
[null,{"$f":"IF(A24=0,\" \",VLOOKUP(A24,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A24=0,\" \",VLOOKUP(A24,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A24=0,\" \",VLOOKUP(A24,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," ","En turquoise: Les Factures, Factures Simplifiées et Notes de Crédit"]
[null,{"$f":"IF(A25=0,\" \",VLOOKUP(A25,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A25=0,\" \",VLOOKUP(A25,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A25=0,\" \",VLOOKUP(A25,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A26=0,\" \",VLOOKUP(A26,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A26=0,\" \",VLOOKUP(A26,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A26=0,\" \",VLOOKUP(A26,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A27=0,\" \",VLOOKUP(A27,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A27=0,\" \",VLOOKUP(A27,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A27=0,\" \",VLOOKUP(A27,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A28=0,\" \",VLOOKUP(A28,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A28=0,\" \",VLOOKUP(A28,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A28=0,\" \",VLOOKUP(A28,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A29=0,\" \",VLOOKUP(A29,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A29=0,\" \",VLOOKUP(A29,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A29=0,\" \",VLOOKUP(A29,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A30=0,\" \",VLOOKUP(A30,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A30=0,\" \",VLOOKUP(A30,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A30=0,\" \",VLOOKUP(A30,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A31=0,\" \",VLOOKUP(A31,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A31=0,\" \",VLOOKUP(A31,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A31=0,\" \",VLOOKUP(A31,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A32=0,\" \",VLOOKUP(A32,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A32=0,\" \",VLOOKUP(A32,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A32=0,\" \",VLOOKUP(A32,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A33=0,\" \",VLOOKUP(A33,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A33=0,\" \",VLOOKUP(A33,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A33=0,\" \",VLOOKUP(A33,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A34=0,\" \",VLOOKUP(A34,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A34=0,\" \",VLOOKUP(A34,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A34=0,\" \",VLOOKUP(A34,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A35=0,\" \",VLOOKUP(A35,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A35=0,\" \",VLOOKUP(A35,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A35=0,\" \",VLOOKUP(A35,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A36=0,\" \",VLOOKUP(A36,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A36=0,\" \",VLOOKUP(A36,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A36=0,\" \",VLOOKUP(A36,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A37=0,\" \",VLOOKUP(A37,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A37=0,\" \",VLOOKUP(A37,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A37=0,\" \",VLOOKUP(A37,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A38=0,\" \",VLOOKUP(A38,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A38=0,\" \",VLOOKUP(A38,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A38=0,\" \",VLOOKUP(A38,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A39=0,\" \",VLOOKUP(A39,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A39=0,\" \",VLOOKUP(A39,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A39=0,\" \",VLOOKUP(A39,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A40=0,\" \",VLOOKUP(A40,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A40=0,\" \",VLOOKUP(A40,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A40=0,\" \",VLOOKUP(A40,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A41=0,\" \",VLOOKUP(A41,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A41=0,\" \",VLOOKUP(A41,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A41=0,\" \",VLOOKUP(A41,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A42=0,\" \",VLOOKUP(A42,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A42=0,\" \",VLOOKUP(A42,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A42=0,\" \",VLOOKUP(A42,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A43=0,\" \",VLOOKUP(A43,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A43=0,\" \",VLOOKUP(A43,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A43=0,\" \",VLOOKUP(A43,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A44=0,\" \",VLOOKUP(A44,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A44=0,\" \",VLOOKUP(A44,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A44=0,\" \",VLOOKUP(A44,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A45=0,\" \",VLOOKUP(A45,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A45=0,\" \",VLOOKUP(A45,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A45=0,\" \",VLOOKUP(A45,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A46=0,\" \",VLOOKUP(A46,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A46=0,\" \",VLOOKUP(A46,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A46=0,\" \",VLOOKUP(A46,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A47=0,\" \",VLOOKUP(A47,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A47=0,\" \",VLOOKUP(A47,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A47=0,\" \",VLOOKUP(A47,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
["Total: ",{"$f":"SUM(K21:K47)","v":1},"pièce(s)",null,null,null,null,null,null,"Montant hors tva : ",null,null,{"$f":"SUM(Q21:Q47)+SUM(M50)","v":32}]
["Paiement :"]
[null,null,null,null,null,null,null,null,null,"Rem :",null,null,{"$f":"IF(SUM(O21:O47)=0,\"\",SUM(O21:O47))","v":""}]
["2. Cash :",null,null,null,null,null,null,null,null,"Transport :"]
[null,null,null,null,null,null,null,null,null,"Sous-Total :",null,null,{"$f":"(SUM(M48)-SUM(M50)+SUM(M51))","v":32}]
[null,null,null,null,null,null,null,null,null,"Tva 20% :",null,null,{"$f":"SUM(M52*0.2)","v":6.4}]
[null,null,null,null,null,null,null,null,null,"Total :",null,null,{"$f":"SUM(M52*1.2)","v":38.4}]

{"sheet":"FA201860001","index":4,"n_rows":60,"n_cols":24,"rows_kept":60,"cut":false,"hidden":false,"merged":[[6,9,6,15],[1,0,1,15],[3,12,3,14],[4,9,4,10],[5,9,5,15],[5,17,5,23],[7,9,7,10],[7,11,7,15],[7,17,7,18],[8,9,8,10],[9,9,9,15],[9,17,9,20],[10,9,10,15],[10,17,10,20],[11,9,11,15],[11,17,11,20],[12,9,12,15],[12,17,12,20],[14,4,15,11],[14,13,15,13],[14,14,15,16],[16,0,17,3],[16,5,16,9],[17,10,18,10],[48,10,49,12],[48,13,49,16],[19,1,20,1],[19,11,20,11],[19,12,20,12],[19,13,20,13],[19,14,20,14],[19,15,20,15],[19,16,20,16],[23,17,23,26],[24,17,24,26],[25,17,25,26],[26,17,26,26],[51,0,51,1],[51,4,51,5],[51,6,51,7],[51,10,51,12],[51,13,51,16],[50,0,50,1],[50,4,50,5],[50,6,50,7],[50,10,50,12],[50,13,50,16],[53,0,53,2],[53,4,56,9],[53,13,53,16],[54,10,54,12],[54,13,54,16],[52,0,52,1],[52,4,52,5],[52,6,52,7],[52,10,52,12],[52,13,52,16]]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Date:"]
[null,null,null,null,null,null,null,"Numéro: "]
[null,null,null,null,null,null,null,"Nom: ",null,{"$f":"IF($J$5=0,\" \",R6)","v":" "},null,null,null,null,null,null,null,{"$f":"IF(J5=0,\" \",VLOOKUP(J5,client!$A$4:$AD$79309,2,FALSE))","v":" "}]
[null,null,null,null,null,null,null,"Adresse: ",null,{"$f":"IF($J$5=0,\" \",R7)","v":" "},null,null,null,null,null,null,null,{"$f":"IF($J$5=0,\" \",VLOOKUP($J$5,client!$A$4:$AD$79309,3,FALSE))","v":" "}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF($J$5=0,\"\",R8)","v":""},null,{"$f":"IF($J$5=0,\" \",VLOOKUP($J$5,client!$A$4:$AD$79309,5,FALSE))","v":" "},null,null,null,null,null,{"$f":"IF($J$5=0,\" \",VLOOKUP($J$5,client!$A$4:$AD$79309,4,FALSE))","v":" "},null,{"$f":"IF($J$5=0,\" \",VLOOKUP($J$5,client!$A$4:$AD$79309,5,FALSE))","v":" "}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF($J$5=0,\"\",R9)","v":""},null,null,null,null,null,null,null,{"$f":"IF($J$5=0,\" \",VLOOKUP($J$5,client!$A$4:$AD$79309,6,FALSE))","v":" "}]
[null,null,null,null,null,null,null,"T.V.A: ",null,{"$f":"IF($J$5=0,\" \",R10)","v":" "},{"$f":"IF(K6=0,\" \",VLOOKUP(K6,client!$A$4:$AD$79309,6,FALSE))","v":" "},{"$f":"IF(L6=0,\" \",VLOOKUP(L6,client!$A$4:$AD$79309,6,FALSE))","v":" "},{"$f":"IF(M6=0,\" \",VLOOKUP(M6,client!$A$4:$AD$79309,6,FALSE))","v":" "},{"$f":"IF(N6=0,\" \",VLOOKUP(N6,client!$A$4:$AD$79309,6,FALSE))","v":" "},{"$f":"IF(O6=0,\" \",VLOOKUP(O6,client!$A$4:$AD$79309,6,FALSE))","v":" "},{"$f":"IF(P6=0,\" \",VLOOKUP(P6,client!$A$4:$AD$79309,6,FALSE))","v":" "},null,{"$f":"IF($J$5=0,\" \",VLOOKUP($J$5,client!$A$4:$AD$79309,11,FALSE))","v":" "},null,null,null,{"$f":"IF(V6=0,\" \",VLOOKUP(V6,client!$A$4:$AD$79309,6,FALSE))","v":" "},{"$f":"IF(W6=0,\" \",VLOOKUP(W6,client!$A$4:$AD$79309,6,FALSE))","v":" "},{"$f":"IF(X6=0,\" \",VLOOKUP(X6,client!$A$4:$AD$79309,6,FALSE))","v":" "}]
[null,null,null,null,null,null,null,"Tél: ",null,{"$f":"IF(J5=0,\" \",R11)","v":" "},{"$f":"IF(K7=0,\" \",VLOOKUP(K7,client!$A$4:$AD$79309,6,FALSE))","v":" "},{"$f":"IF(L7=0,\" \",VLOOKUP(L7,client!$A$4:$AD$79309,6,FALSE))","v":" "},{"$f":"IF(M7=0,\" \",VLOOKUP(M7,client!$A$4:$AD$79309,6,FALSE))","v":" "},{"$f":"IF(N7=0,\" \",VLOOKUP(N7,client!$A$4:$AD$79309,6,FALSE))","v":" "},{"$f":"IF(O7=0,\" \",VLOOKUP(O7,client!$A$4:$AD$79309,6,FALSE))","v":" "},{"$f":"IF(P7=0,\" \",VLOOKUP(P7,client!$A$4:$AD$79309,6,FALSE))","v":" "},null,{"$f":"IF($J$5=0,\" \",VLOOKUP($J$5,client!$A$4:$AD$79309,7,FALSE))","v":" "}]
[null,null,null,null,null,null,null,"Mob: ",null,{"$f":"IF(J5=0,\" \",R12)","v":" "},{"$f":"IF(K8=0,\" \",VLOOKUP(K8,client!$A$4:$AD$79309,6,FALSE))","v":" "},{"$f":"IF(L8=0,\" \",VLOOKUP(L8,client!$A$4:$AD$79309,6,FALSE))","v":{"$error":"#N/A"}},{"$f":"IF(M8=0,\" \",VLOOKUP(M8,client!$A$4:$AD$79309,6,FALSE))","v":" "},{"$f":"IF(N8=0,\" \",VLOOKUP(N8,client!$A$4:$AD$79309,6,FALSE))","v":" "},{"$f":"IF(O8=0,\" \",VLOOKUP(O8,client!$A$4:$AD$79309,6,FALSE))","v":" "},{"$f":"IF(P8=0,\" \",VLOOKUP(P8,client!$A$4:$AD$79309,6,FALSE))","v":" "},null,{"$f":"IF($J$5=0,\" \",VLOOKUP($J$5,client!$A$4:$AD$79309,22,FALSE))","v":" "}]
[null,null,null,null,null,null,null,"Mail: ",null,{"$f":"IF(J5=0,\" \",R13)","v":" "},{"$f":"IF(K9=0,\" \",VLOOKUP(K9,client!$A$4:$AD$79309,6,FALSE))","v":" "},{"$f":"IF(L9=0,\" \",VLOOKUP(L9,client!$A$4:$AD$79309,6,FALSE))","v":" "},{"$f":"IF(M9=0,\" \",VLOOKUP(M9,client!$A$4:$AD$79309,6,FALSE))","v":" "},{"$f":"IF(N9=0,\" \",VLOOKUP(N9,client!$A$4:$AD$79309,6,FALSE))","v":" "},{"$f":"IF(O9=0,\" \",VLOOKUP(O9,client!$A$4:$AD$79309,6,FALSE))","v":" "},{"$f":"IF(P9=0,\" \",VLOOKUP(P9,client!$A$4:$AD$79309,6,FALSE))","v":" "},null,{"$f":"IF($J$5=0,\" \",VLOOKUP($J$5,client!$A$4:$AD$79309,9,FALSE))","v":" "}]
[]
[null,null,null,null,"F A C T U R E",null,null,null,null,null,null,null,null," N°","FA201860001"]
[]
[null,null,null,null,null,"Tailles"]
[null,null,null,null,null,"S","M","L","XL","XXL"]
[null,null,null,null,null,"SM","ML","LX",null,"U"]
["Code","Descrip.","GENRE","COMP","coul",36,38,40,42,44,"Qté","Prix Unit","Rem %","Rem *","Rem","Prix Unit","TOT Prix"]
["CO",null,null,null,null,1,2,3,4,5]
["S800HP",{"$f":"IF(A22=0,\" \",VLOOKUP(A22,inv!$A$2:$L$113,4,FALSE))","v":"15-075                        "},{"$f":"IF(A22=0,\" \",VLOOKUP(A22,inv!$A$2:$L$113,3,FALSE))","v":"ROBE                     B4 07"},"Poly 90% Elast 10%","DIVERS",null,null,1,null,null,{"$f":"IF(SUM(F22:J22)=0,\" \",SUM(F22:J22))","v":1},{"$f":"IF(A22=0,\" \",VLOOKUP(A22,inv!$A$1:$L$113,7,FALSE))","v":32},null,null,{"$f":"IF((SUM(L22)-SUM(P22)=0),\"\",(SUM(L22)-SUM(P22))*SUM(K22))","v":""},{"$f":"IF(N22>0,N22,IF(A22=0,\"\",SUM(L22)-(SUM(L22)*SUM(M22))))","v":32},{"$f":"IF(A22=0,\" \",SUM(K22)*SUM(P22))","v":32},"Légende des couleurs d'onglets:"]
["S800HP",{"$f":"IF(A23=0,\" \",VLOOKUP(A23,inv!$A$2:$L$113,4,FALSE))","v":"15-075                        "},{"$f":"IF(A23=0,\" \",VLOOKUP(A23,inv!$A$2:$L$113,3,FALSE))","v":"ROBE                     B4 07"},"Poly 90% Elast 10%","BLEU",null,1,null,null,null,1,{"$f":"IF(A23=0,\" \",VLOOKUP(A23,inv!$A$1:$L$113,7,FALSE))","v":32},null,null,{"$f":"IF((SUM(L23)-SUM(P23)=0),\"\",(SUM(L23)-SUM(P23))*SUM(K23))","v":""},{"$f":"IF(N23>0,N23,IF(A23=0,\"\",SUM(L23)-(SUM(L23)*SUM(M23))))","v":32},{"$f":"IF(A23=0,\" \",SUM(K23)*SUM(P23))","v":32}]
[null,{"$f":"IF(A24=0,\" \",VLOOKUP(A24,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A24=0,\" \",VLOOKUP(A24,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A24=0,\" \",VLOOKUP(A24,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," ","En rouge: Les Ventes Comptoir 2 et 3"]
[null,{"$f":"IF(A25=0,\" \",VLOOKUP(A25,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A25=0,\" \",VLOOKUP(A25,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A25=0,\" \",VLOOKUP(A25,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," ","En turquoise: Les Factures, Factures Simplifiées et Notes de Crédit"]
[null,{"$f":"IF(A26=0,\" \",VLOOKUP(A26,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A26=0,\" \",VLOOKUP(A26,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A26=0,\" \",VLOOKUP(A26,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A27=0,\" \",VLOOKUP(A27,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A27=0,\" \",VLOOKUP(A27,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A27=0,\" \",VLOOKUP(A27,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A28=0,\" \",VLOOKUP(A28,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A28=0,\" \",VLOOKUP(A28,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A28=0,\" \",VLOOKUP(A28,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A29=0,\" \",VLOOKUP(A29,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A29=0,\" \",VLOOKUP(A29,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A29=0,\" \",VLOOKUP(A29,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A30=0,\" \",VLOOKUP(A30,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A30=0,\" \",VLOOKUP(A30,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A30=0,\" \",VLOOKUP(A30,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A31=0,\" \",VLOOKUP(A31,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A31=0,\" \",VLOOKUP(A31,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A31=0,\" \",VLOOKUP(A31,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A32=0,\" \",VLOOKUP(A32,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A32=0,\" \",VLOOKUP(A32,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A32=0,\" \",VLOOKUP(A32,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A33=0,\" \",VLOOKUP(A33,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A33=0,\" \",VLOOKUP(A33,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A33=0,\" \",VLOOKUP(A33,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A34=0,\" \",VLOOKUP(A34,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A34=0,\" \",VLOOKUP(A34,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A34=0,\" \",VLOOKUP(A34,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A35=0,\" \",VLOOKUP(A35,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A35=0,\" \",VLOOKUP(A35,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A35=0,\" \",VLOOKUP(A35,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A36=0,\" \",VLOOKUP(A36,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A36=0,\" \",VLOOKUP(A36,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A36=0,\" \",VLOOKUP(A36,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A37=0,\" \",VLOOKUP(A37,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A37=0,\" \",VLOOKUP(A37,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A37=0,\" \",VLOOKUP(A37,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A38=0,\" \",VLOOKUP(A38,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A38=0,\" \",VLOOKUP(A38,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A38=0,\" \",VLOOKUP(A38,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A39=0,\" \",VLOOKUP(A39,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A39=0,\" \",VLOOKUP(A39,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A39=0,\" \",VLOOKUP(A39,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A40=0,\" \",VLOOKUP(A40,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A40=0,\" \",VLOOKUP(A40,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A40=0,\" \",VLOOKUP(A40,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A41=0,\" \",VLOOKUP(A41,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A41=0,\" \",VLOOKUP(A41,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A41=0,\" \",VLOOKUP(A41,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A42=0,\" \",VLOOKUP(A42,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A42=0,\" \",VLOOKUP(A42,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A42=0,\" \",VLOOKUP(A42,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A43=0,\" \",VLOOKUP(A43,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A43=0,\" \",VLOOKUP(A43,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A43=0,\" \",VLOOKUP(A43,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A44=0,\" \",VLOOKUP(A44,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A44=0,\" \",VLOOKUP(A44,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A44=0,\" \",VLOOKUP(A44,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A45=0,\" \",VLOOKUP(A45,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A45=0,\" \",VLOOKUP(A45,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A45=0,\" \",VLOOKUP(A45,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A46=0,\" \",VLOOKUP(A46,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A46=0,\" \",VLOOKUP(A46,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A46=0,\" \",VLOOKUP(A46,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A47=0,\" \",VLOOKUP(A47,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A47=0,\" \",VLOOKUP(A47,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A47=0,\" \",VLOOKUP(A47,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A48=0,\" \",VLOOKUP(A48,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A48=0,\" \",VLOOKUP(A48,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A48=0,\" \",VLOOKUP(A48,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
["Total: ",{"$f":"SUM(K22:K48)","v":2},"pièce(s)",null,null,null,null,null,null,null,"Montant hors tva : ",null,null,{"$f":"SUM(Q22:Q48)+SUM(N51)","v":64}]
["Paiement :",null,"N° de Paiement utilisé :"]
["1. Bancontact :",null,null,"4. Cheque n° :  ",null,null,null,null,null,null,"Rem :",null,null,{"$f":"IF(SUM(Q22:Q48)=0,\"\",SUM(O22:O48))","v":0}]
["2. Cash :",null,null,"5. Virem. x Jours :  ",null,null,null,null,null,null,"Transport :"]
["3. Carte de Crédit :",null,null,"6. Traite:  ",null,null,null,null,null,null,"Sous-Total :",null,null,{"$f":"IF(N51=0,N49,SUM(N49)-SUM(N51)+SUM(N52))","v":64}]
["Signature client/ Handtekening klant :",null,null,null,null,null,null,null,null,null,"Tva:",20,"%",{"$f":"SUM(N53*L54)/100","v":12.8}]
[null,null,null,null,null,null,null,null,null,null,"TOTAL :",null,null,{"$f":"SUM(N53+N54)","v":76.8}]
[]
[]
[]
["Exportation (hors UE) exonérée de T.V.A. avec document d'exportation par un transitaire agréé."]
["Exonération de T.V.A. suivant article 39bis, alinéa premier, 1° du Code TVA  – Livraison Intracommunautaire."]

{"sheet":"VC2018650001","index":5,"n_rows":54,"n_cols":18,"rows_kept":54,"cut":false,"hidden":false,"merged":[[7,9,7,16],[0,0,0,16],[3,12,3,15],[4,9,4,16],[5,9,5,16],[6,9,6,16],[8,9,8,16],[9,9,9,16],[10,9,10,16],[11,9,11,16],[13,3,14,11],[13,14,14,14],[13,15,14,16],[25,17,25,26],[15,5,15,9],[15,15,16,16],[16,0,17,0],[16,1,17,2],[16,10,17,10],[18,1,19,1],[18,11,19,11],[18,12,19,12],[18,13,19,13],[18,14,19,14],[18,15,19,15],[18,16,19,16],[22,17,22,26],[23,17,23,26],[24,17,24,26],[47,9,48,11],[47,12,48,16],[49,0,49,1],[49,5,49,6],[49,9,49,11],[49,12,49,16],[50,0,50,1],[50,5,50,6],[50,9,50,11],[50,12,50,16],[51,0,51,1],[51,5,51,6],[51,9,51,11],[51,12,51,16],[52,0,52,2],[52,9,52,11],[52,12,52,16],[53,9,53,11],[53,12,53,16]]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Date:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"VENTE COMPTOIR",null,null,null,null,null,null,null,null,null,null," N°","VC2018650001"]
[]
[null,null,null,null,null,"Tailles"]
[null,null,null,null,null,"S","M","L","XL","XXL"]
[null,null,null,null,null,"SM","ML","LX",null,"U"]
["Code","Descrip.","GENRE","COMP","coul",36,38,40,42,44,"Qté","Prix Unit","Rem %","Rem *","Rem","Prix Unit","TOT Prix"]
["CO",null,null,null,null,1,2,3,4,5]
["S800HP",{"$f":"IF(A21=0,\" \",VLOOKUP(A21,inv!$A$2:$L$113,4,FALSE))","v":"15-075                        "},{"$f":"IF(A21=0,\" \",VLOOKUP(A21,inv!$A$2:$L$113,3,FALSE))","v":"ROBE                     B4 07"},"Poly 90% Elast 10%",null,null,null,1,null,null,{"$f":"IF(SUM(F21:J21)=0,\" \",SUM(F21:J21))","v":1},{"$f":"IF(A21=0,\" \",VLOOKUP(A21,inv!$A$1:$L$113,7,FALSE))","v":32},null,null,{"$f":"IF((SUM(L21)-SUM(P21)=0),\"\",(SUM(L21)-SUM(P21))*SUM(K21))","v":""},{"$f":"IF(N21>0,N21,IF(A21=0,\"\",SUM(L21)-(SUM(L21)*SUM(M21))))","v":32},{"$f":"IF(A21=0,\" \",SUM(K21)*SUM(P21))","v":32},"Légende des couleurs d'onglets:"]
[null,{"$f":"IF(A22=0,\" \",VLOOKUP(A22,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A22=0,\" \",VLOOKUP(A22,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A22=0,\" \",VLOOKUP(A22,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,{"$f":"IF((SUM(L22)-SUM(P22)=0),\"\",(SUM(L22)-SUM(P22))*SUM(K22))","v":""},{"$f":"IF(N22>0,N22,IF(A22=0,\"\",SUM(L22)-(SUM(L22)*SUM(M22))))","v":""},{"$f":"IF(A22=0,\" \",SUM(K22)*SUM(P22))","v":" "}]
[null,{"$f":"IF(A23=0,\" \",VLOOKUP(A23,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A23=0,\" \",VLOOKUP(A23,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A23=0,\" \",VLOOKUP(A23,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," ","En rouge: Les Ventes Comptoir 2 et 3"]
[null,{"$f":"IF(A24=0,\" \",VLOOKUP(A24,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A24=0,\" \",VLOOKUP(A24,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A24=0,\" \",VLOOKUP(A24,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," ","En turquoise: Les Factures, Factures Simplifiées et Notes de Crédit"]
[null,{"$f":"IF(A25=0,\" \",VLOOKUP(A25,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A25=0,\" \",VLOOKUP(A25,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A25=0,\" \",VLOOKUP(A25,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A26=0,\" \",VLOOKUP(A26,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A26=0,\" \",VLOOKUP(A26,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A26=0,\" \",VLOOKUP(A26,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A27=0,\" \",VLOOKUP(A27,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A27=0,\" \",VLOOKUP(A27,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A27=0,\" \",VLOOKUP(A27,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A28=0,\" \",VLOOKUP(A28,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A28=0,\" \",VLOOKUP(A28,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A28=0,\" \",VLOOKUP(A28,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A29=0,\" \",VLOOKUP(A29,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A29=0,\" \",VLOOKUP(A29,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A29=0,\" \",VLOOKUP(A29,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A30=0,\" \",VLOOKUP(A30,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A30=0,\" \",VLOOKUP(A30,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A30=0,\" \",VLOOKUP(A30,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A31=0,\" \",VLOOKUP(A31,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A31=0,\" \",VLOOKUP(A31,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A31=0,\" \",VLOOKUP(A31,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A32=0,\" \",VLOOKUP(A32,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A32=0,\" \",VLOOKUP(A32,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A32=0,\" \",VLOOKUP(A32,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A33=0,\" \",VLOOKUP(A33,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A33=0,\" \",VLOOKUP(A33,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A33=0,\" \",VLOOKUP(A33,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A34=0,\" \",VLOOKUP(A34,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A34=0,\" \",VLOOKUP(A34,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A34=0,\" \",VLOOKUP(A34,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A35=0,\" \",VLOOKUP(A35,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A35=0,\" \",VLOOKUP(A35,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A35=0,\" \",VLOOKUP(A35,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A36=0,\" \",VLOOKUP(A36,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A36=0,\" \",VLOOKUP(A36,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A36=0,\" \",VLOOKUP(A36,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A37=0,\" \",VLOOKUP(A37,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A37=0,\" \",VLOOKUP(A37,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A37=0,\" \",VLOOKUP(A37,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A38=0,\" \",VLOOKUP(A38,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A38=0,\" \",VLOOKUP(A38,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A38=0,\" \",VLOOKUP(A38,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A39=0,\" \",VLOOKUP(A39,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A39=0,\" \",VLOOKUP(A39,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A39=0,\" \",VLOOKUP(A39,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A40=0,\" \",VLOOKUP(A40,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A40=0,\" \",VLOOKUP(A40,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A40=0,\" \",VLOOKUP(A40,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A41=0,\" \",VLOOKUP(A41,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A41=0,\" \",VLOOKUP(A41,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A41=0,\" \",VLOOKUP(A41,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A42=0,\" \",VLOOKUP(A42,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A42=0,\" \",VLOOKUP(A42,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A42=0,\" \",VLOOKUP(A42,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A43=0,\" \",VLOOKUP(A43,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A43=0,\" \",VLOOKUP(A43,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A43=0,\" \",VLOOKUP(A43,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A44=0,\" \",VLOOKUP(A44,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A44=0,\" \",VLOOKUP(A44,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A44=0,\" \",VLOOKUP(A44,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A45=0,\" \",VLOOKUP(A45,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A45=0,\" \",VLOOKUP(A45,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A45=0,\" \",VLOOKUP(A45,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A46=0,\" \",VLOOKUP(A46,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A46=0,\" \",VLOOKUP(A46,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A46=0,\" \",VLOOKUP(A46,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A47=0,\" \",VLOOKUP(A47,inv!$A$2:$L$113,4,FALSE))","v":" "},{"$f":"IF(A47=0,\" \",VLOOKUP(A47,inv!$A$2:$L$113,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A47=0,\" \",VLOOKUP(A47,inv!$A$1:$L$113,7,FALSE))","v":" "},null,null,"",""," "]
["Total: ",{"$f":"SUM(K21:K47)","v":1},"pièce(s)",null,null,null,null,null,null,"Montant hors tva : ",null,null,{"$f":"SUM(Q21:Q47)+SUM(M50)","v":32}]
["Paiement :"]
[null,null,null,null,null,null,null,null,null,"Rem :",null,null,{"$f":"IF(SUM(O21:O47)=0,\"\",SUM(O21:O47))","v":""}]
["2. Cash :",null,null,null,null,null,null,null,null,"Transport :"]
[null,null,null,null,null,null,null,null,null,"Sous-Total :",null,null,{"$f":"(SUM(M48)-SUM(M50)+SUM(M51))","v":32}]
[null,null,null,null,null,null,null,null,null,"Tva 20% :",null,null,{"$f":"SUM(M52*0.2)","v":6.4}]
[null,null,null,null,null,null,null,null,null,"Total :",null,null,{"$f":"SUM(M52*1.2)","v":38.4}]