{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["inv","client","MOD Vente Comptoir 2 et 3","2017605003"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":3,"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":100,"n_cols":7,"rows_kept":100,"cut":false,"hidden":false,"merged":[]}
["Inventaire du 12/04/2017 - Pour le magasin - CO3WIN"]
[]
["Code Article","Quantité","Genre","Description","Marque","Saison","PV"]
[]
["S800AQ",0,"ROBE                     B4 07","10-83                         ","GLOSS LINE                                      Y6","2015H ",39]
["S800AR",0,"TUNIQUE                     42","10-86                         ","GLOSS LINE                                      Y6","2015H ",39]
["S800AS",0,"CALECON                     26","10-08                         ","GLOSS LINE                                      Y6","2015H ",21]
["S800AW",0,"ROBE                     B4 07","10-29-2                       ","GLOSS LINE                                      Y6","2015H ",45]
["S800AX",0,"ROBE                     B4 07","10-29+                        ","GLOSS LINE                                      Y6","2015H ",46]
["S800AY",0,"ROBE                     B4 07","10-37+                        ","GLOSS LINE                                      Y6","2015H ",43]
["S800AZ",0,"ROBE                     B4 07","10-61+                        ","GLOSS LINE                                      Y6","2015H ",44]
["S800B0",0,"ROBE                     B4 07","10-80-1                       ","GLOSS LINE                                      Y6","2015H ",48]
["S800B1",0,"ROBE                     B4 07","10-88                         ","GLOSS LINE                                      Y6","2015H ",41]
["S800B2",0,"ROBE                     B4 07","10-89                         ","GLOSS LINE                                      Y6","2015H ",41]
["S800B3",0,"ROBE                     B4 07","10-90                         ","GLOSS LINE                                      Y6","2015H ",48]
["S800B4",0,"TUNIQUE                     42","10-91                         ","GLOSS LINE                                      Y6","2015H ",44]
["S800B5",0,"TOP             K9 H3 F8 F7 53","9-28                          ","GLOSS LINE                                      Y6","2015H ",7]
["S800B6",0,"ROBE                     B4 07","12-01                         ","GLOSS LINE                                      Y6","2016E ",37]
["S800B7",0,"TUNIQUE                     42","12-03                         ","GLOSS LINE                                      Y6","2016E ",40]
["S800B8",0,"TUNIQUE                     42","12-06                         ","GLOSS LINE                                      Y6","2016E ",42]
["S800B9",0,"TUNIQUE                     42","12-07                         ","GLOSS LINE                                      Y6","2016E ",44]
["S800BA",0,"ROBE                     B4 07","12-14                         ","GLOSS LINE                                      Y6","2016E ",42]
["S800BB",0,"GILET                    92 02","12-22                         ","GLOSS LINE                                      Y6","2016E ",42]
["S800BC",0,"TSHIRT          F9 91 55 36 25","12-23                         ","GLOSS LINE                                      Y6","2016E ",29]
["S800BD",0,"CALECON                     26","12-24                         ","GLOSS LINE                                      Y6","2016E ",24]
["S800BE",0,"ROBE                     B4 07","12-30                         ","GLOSS LINE                                      Y6","2016E ",39]
["S800BF",0,"ROBE                     B4 07","12-31                         ","GLOSS LINE                                      Y6","2016E ",34]
["S800BG",0,"TSHIRT          F9 91 55 36 25","12-31-2                       ","GLOSS LINE                                      Y6","2016E ",27]
["S800BH",0,"ROBE                     B4 07","12-32                         ","GLOSS LINE                                      Y6","2016E ",39]
["S800BI",0,"ROBE                     B4 07","12-37                         ","GLOSS LINE                                      Y6","2016E ",29]
["S800BJ",0,"ROBE                     B4 07","12-40                         ","GLOSS LINE                                      Y6","2016E ",54]
["S800BK",0,"ROBE                     B4 07","12-40-2                       ","GLOSS LINE                                      Y6","2016E ",35]
["S800BL",0,"ROBE                     B4 07","12-51                         ","GLOSS LINE                                      Y6","2016E ",44]
["S800BM",0,"ROBE                     B4 07","12-51-2                       ","GLOSS LINE                                      Y6","2016E ",44]
["S800BN",0,"ROBE                     B4 07","12-54                         ","GLOSS LINE                                      Y6","2016E ",34]
["S800BO",0,"ROBE                     B4 07","12-65                         ","GLOSS LINE                                      Y6","2016E ",39]
["S800BP",0,"TUNIQUE                     42","12-67                         ","GLOSS LINE                                      Y6","2016E ",44]
["S800BQ",0,"TUNIQUE                     42","12-71                         ","GLOSS LINE                                      Y6","2016E ",44]
["S800BR",0,"TSHIRT          F9 91 55 36 25","12-94                         ","GLOSS LINE                                      Y6","2016E ",27]
["S800BS",0,"CALECON                     26","12-95                         ","GLOSS LINE                                      Y6","2016E ",24]
["S800BT",0,"GILET                    92 02","12-95-2                       ","GLOSS LINE                                      Y6","2016E ",35]
["S800BU",0,"TUNIQUE                     42","12-102                        ","GLOSS LINE                                      Y6","2016E ",39]
["S800BV",0,"ROBE                     B4 07","12-112                        ","GLOSS LINE                                      Y6","2016E ",32]
["S800BW",0,"ROBE                     B4 07","12-113                        ","GLOSS LINE                                      Y6","2016E ",34]
["S800BX",0,"ROBE                     B4 07","12-114                        ","GLOSS LINE                                      Y6","2016E ",34]
["S800BY",0,"ROBE                     B4 07","12-115                        ","GLOSS LINE                                      Y6","2016E ",34]
["S800BZ",0,"TSHIRT          F9 91 55 36 25","12-117                        ","GLOSS LINE                                      Y6","2016E ",27]
["S800C0",0,"ROBE                     B4 07","12-125                        ","GLOSS LINE                                      Y6","2016E ",34]
["S800C1",0,"ROBE                     B4 07","12-16                         ","GLOSS LINE                                      Y6","2016E ",34]
["S800C2",0,"TSHIRT          F9 91 55 36 25","12-18                         ","GLOSS LINE                                      Y6","2016E ",27]
["S800C3",0,"ROBE                     B4 07","12-18-3                       ","GLOSS LINE                                      Y6","2016E ",31]
["S800C4",0,"ROBE                     B4 07","12-21                         ","GLOSS LINE                                      Y6","2016E ",35]
["S800C5",0,"TUNIQUE                     42","12-44                         ","GLOSS LINE                                      Y6","2016E ",34]
["S800C6",0,"TUNIQUE                     42","12-45                         ","GLOSS LINE                                      Y6","2016E ",34]
["S800C7",0,"ROBE                     B4 07","12-49                         ","GLOSS LINE                                      Y6","2016E ",49]
["S800C8",0,"ROBE                     B4 07","12-49-2                       ","GLOSS LINE                                      Y6","2016E ",34]
["S800C9",0,"ROBE                     B4 07","12-50                         ","GLOSS LINE                                      Y6","2016E ",44]
["S800CA",0,"ROBE                     B4 07","12-52                         ","GLOSS LINE                                      Y6","2016E ",32]
["S800CB",0,"ROBE                     B4 07","12-56-2                       ","GLOSS LINE                                      Y6","2016E ",40]
["S800CC",0,"TSHIRT          F9 91 55 36 25","12-56-3                       ","GLOSS LINE                                      Y6","2016E ",34]
["S800CD",0,"TUNIQUE                     42","12-02                         ","GLOSS LINE                                      Y6","2016E ",44]
["S800CE",0,"TUNIQUE                     42","12-06-2                       ","GLOSS LINE                                      Y6","2016E ",42]
["S800CF",0,"ROBE                     B4 07","12-08                         ","GLOSS LINE                                      Y6","2016E ",47]
["S800CG",0,"ROBE                     B4 07","12-16                         ","GLOSS LINE                                      Y6","2016E ",34]
["S800CH",0,"ROBE                     B4 07","12-18                         ","GLOSS LINE                                      Y6","2016E ",27]
["S800CI",0,"TSHIRT          F9 91 55 36 25","12-18-2                       ","GLOSS LINE                                      Y6","2016E ",25]
["S800CJ",0,"ROBE                     B4 07","12-18-3                       ","GLOSS LINE                                      Y6","2016E ",32]
["S800CK",0,"ROBE                     B4 07","12-19                         ","GLOSS LINE                                      Y6","2016E ",34]
["S800CL",0,"TSHIRT          F9 91 55 36 25","12-19-2                       ","GLOSS LINE                                      Y6","2016E ",27]
["S800CM",0,"ROBE                     B4 07","12-21                         ","GLOSS LINE                                      Y6","2016E ",35]
["S800CN",0,"TUNIQUE                     42","12-33                         ","GLOSS LINE                                      Y6","2016E ",40]
["S800CO",0,"TUNIQUE                     42","12-34                         ","GLOSS LINE                                      Y6","2016E ",44]
["S800CP",0,"TUNIQUE                     42","12-35                         ","GLOSS LINE                                      Y6","2016E ",35]
["S800CQ",0,"TUNIQUE                     42","12-44                         ","GLOSS LINE                                      Y6","2016E ",34]
["S800CR",0,"TUNIQUE                     42","12-45                         ","GLOSS LINE                                      Y6","2016E ",34]
["S800CS",0,"ROBE                     B4 07","12-49                         ","GLOSS LINE                                      Y6","2016E ",49]
["S800CT",0,"ROBE                     B4 07","12-49-2                       ","GLOSS LINE                                      Y6","2016E ",34]
["S800CU",0,"ROBE                     B4 07","12-50                         ","GLOSS LINE                                      Y6","2016E ",44]
["S800CV",0,"ROBE                     B4 07","12-52                         ","GLOSS LINE                                      Y6","2016E ",32]
["S800CW",0,"ROBE                     B4 07","12-56                         ","GLOSS LINE                                      Y6","2016E ",37]
["S800CX",0,"ROBE                     B4 07","12-56-2                       ","GLOSS LINE                                      Y6","2016E ",40]
["S800CY",0,"TSHIRT          F9 91 55 36 25","12-56-3                       ","GLOSS LINE                                      Y6","2016E ",34]
["S800CZ",0,"TUNIQUE                     42","12-66                         ","GLOSS LINE                                      Y6","2016E ",44]
["S800D0",0,"TSHIRT          F9 91 55 36 25","12-118                        ","GLOSS LINE                                      Y6","2016E ",24]
["S800D1",0,"ROBE                     B4 07","12-119                        ","GLOSS LINE                                      Y6","2016E ",35]
["S800D2",0,"TSHIRT          F9 91 55 36 25","12-49-3                       ","GLOSS LINE                                      Y6","2016E ",27]
["S800D3",0,"ROBE                     B4 07","12-17                         ","GLOSS LINE                                      Y6","2016E ",35]
["S800D4",0,"ROBE                     B4 07","12-20                         ","GLOSS LINE                                      Y6","2016E ",40]
["S800D5",0,"TOP             K9 H3 F8 F7 53","12.38                         ","GLOSS LINE                                      Y6","2016E ",27]
["S800D6",0,"ROBE                     B4 07","12-41                         ","GLOSS LINE                                      Y6","2016E ",49]
["S800D7",0,"ROBE                     B4 07","12-46                         ","GLOSS LINE                                      Y6","2016E ",45]
["S800D8",0,"ROBE                     B4 07","12-53                         ","GLOSS LINE                                      Y6","2016E ",32]
["S800D9",0,"ROBE                     B4 07","12-59                         ","GLOSS LINE                                      Y6","2016E ",47]
["S800DA",0,"ROBE                     B4 07","12-90                         ","GLOSS LINE                                      Y6","2016E ",55]
["S800DB",0,"ROBE                     B4 07","12-91                         ","GLOSS LINE                                      Y6","2016E ",55]
["S800DC",0,"ROBE                     B4 07","12-110                        ","GLOSS LINE                                      Y6","2016E ",32]
["S800DD",0,"ROBE                     B4 07","12-111                        ","GLOSS LINE                                      Y6","2016E ",30]
["S800DE",0,"ROBE                     B4 07","12-116                        ","GLOSS LINE                                      Y6","2016E ",50]
["S800DF",0,"ROBE                     B4 07","12-38-1                       ","GLOSS LINE                                      Y6","2016E ",44]
["S800DG",0,"ROBE                     B4 07","12-15                         ","GLOSS LINE                                      Y6","2016E ",47]

{"sheet":"client","index":1,"n_rows":58,"n_cols":30,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
["Extraction du fichier client"]
[]
["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"]
[]
[2002,"TOTO",null,null,null,"Belgique",null,null,null,"FR","FR654654654",null,null,"Client Pro 1",null,null,null,"Belgique","TUT","Oui (0% de TVA)",0,null,null,null,null,"Belgique",null,null,"Non"]
[2003,"R&C FASHION BVBA","MORKHOVENSEWEG, 7",2200,"NOORDERWIJK","Belgique","014/500222",null,null,"NL","BE0466608602",null,null,"Client Pro 1",null,null,null,"Belgique","MORKHOVENSEWEG, 7","Non (Avec TVA)",0,null,null,null,null,"Belgique",null,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"]
[2006,"BOSSUYT BERTRAND","ALLEE DES RENARDS, 28",5170,"PROFONDEVILLE","Belgique","081/411132",null,null,"FR","BE0875763411",null,null,"Client Pro 1",null,null,null,"Belgique","BOSSUYT BERTRAND","Non (Avec TVA)",0,475724927,null,null,null,"Belgique",null,null,"Non"]
[2009,"MARAMY MODE","BROEKHOVENSEWEG, 237","NL-5022 CC","TILBURG","Pays-Bas","+31135166275",null,null,"NL","NL152287875B01",null,null,"Client Pro 1",null,null,null,"Belgique","MARAMY MODE","Oui (0% de TVA)",0,null,null,null,null,"Belgique",null,null,"Non"]
[2010,"FRANTEXT","RUE DE LA STATION,9",4430,"ANS","Belgique",42475706,null,null,"FR","BE0445737665",null,null,"Client Pro 1",null,null,null,"Belgique","PASSIONNEL","Non (Avec TVA)",0,496450872,null,null,null,"Belgique",null,null,"Non"]
[2012,"SECRET FASHION","GALERIE DU 25 AOUT,15",1000,"BRUXELLES","Belgique",null,null,null,"FR","BE0830006234",null,null,"Client Pro 1",null,null,null,"Belgique","SECRET FASHION","Non (Avec TVA)",0,475517903,null,null,null,"Belgique",null,null,"Non"]
[2013,"CIPRIA BY CIOK SPRL","RUE PIERRE TIMMERMANS, 17",1090,"JETTE","Belgique","02/4264688","02/2704999    2BOUTI","anna.ghibellini@hotmail.com","FR","BE0811160916",null,null,"Client Pro 1",null,null,null,"Belgique","CIPRIA","Non (Avec TVA)",5,"0476/677083",null,null,null,"Belgique",null,null,"Non"]
[2015,"MUSH SYLVIANE",null,null,null,"Belgique",null,null,null,"FR",null,null,null,"Client Pro 1",null,null,null,"Belgique",null,"Vente personnel",17,null,null,null,null,"Belgique",null,null,"Non"]
[2016,"SONIA KUBIK","UL? NAWOJOWSKA, 1","PL 33-300","NOWY SA, CZ","Espagne",null,null,null,"EN","PL 734 344 97 43",null,null,"Client Pro 1",null,null,null,"Belgique","LOPPING MODE","Oui (0% de TVA)",0,null,null,null,null,"Belgique",null,null,"Non"]
[2017,"KINGS AND QUEENS","HOEVENZAVELLAAN, 38",3600,"GENK","Belgique",89382358,null,null,"NL","BE0638294939",null,null,"Client Pro 1",null,null,null,"Belgique","KINGS AND QUEENS","Non (Avec TVA)",0,null,null,null,null,"Belgique",null,null,"Non"]
[2018,"AFV DIFFUSION SPRL","CHAUSSEE DE TOURNAI.221",7801,"IRCHONWELZ","Belgique",null,null,"pettinellanto@skynet.be","FR","BE0467454678",null,null,"Client Pro 1",null,null,null,"Belgique","SCRUPULES","Non (Avec TVA)",0,475614096,null,null,null,"Belgique",null,null,"Non"]
[2019,"AMORE E PASSIONE","KWAGATSTRAAT.26","B 8020","RUDDERVOORDE","Belgique",null,null,"amore-passione@live.be","NL","BE0720179270",null,null,"Client Pro 1",null,null,null,"Belgique","AMORE E PASSIONE","Non (Avec TVA)",0,475758450,null,null,null,"Belgique",null,null,"Non"]
[2020,"GULDEN VLIES BVBA","ISABELLAPLEIN,1",3270,"SCHERPENHEUVEL","Belgique",13771359,null,null,"NL","BE0435967488",null,null,"Client Pro 1",null,null,null,"Belgique","GULDEN VLIES","Non (Avec TVA)",0,477613121,null,null,null,"Belgique",null,null,"Non"]
[2021,"EUFORIE BVBA","KORTRIJKSESTEENWEG,90D",9830,"SINT- MARTENS- LATEM","Belgique",null,"09 221 67 81","janique@euforiefashion.be","NL","BE0820409667","BIC:KREDBEBB",null,"Client Pro 1",null,null,null,"Belgique","EUFORIE","Non (Avec TVA)",0,"0477 44 31 69",null,null,null,"Belgique",null,null,"Non"]
[2022,"FEOL BVBA","BACCHUSLAAN,32",2140,"BORGERHOUT","Belgique",37070732,null,"info@magnolia-boetiek.be","NL","BE0883694546",null,null,"Client Pro 1",null,null,null,"Belgique","MAGNOLIA","Non (Avec TVA)",0,null,"ANVERS ET KAPELLEN",null,null,"Belgique",null,null,"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"]
[2025,"NGU SPRL NEVER GIVE UP","SENTIER ST JACQUES, 123",6060,"GILLY","Belgique",71228669,71401176,"xten patrick@aol.be","FR","BE0889494156",null,null,"Client Pro 1",null,null,null,"Belgique","XDEN","Non (Avec TVA)",0,"0477480620 OU 252554",null,null,null,"Belgique",null,null,"Non"]
[800142,"CLAEIS MYRIAM","268 CHAUSSEE DE DOUAI",7500,"TOURNAI","Belgique",69769045,null,"RIAM36@HOTMAIL.COM","FR",548894690,null,null,"Client Pro 1",null,null,null,"Belgique","AU CHAPEAU JAUNE","Non (Avec TVA)",0,null,null,null,null,"Belgique",null,null,"Non"]
[200019,"ARLO 27","RUE DES SAVOYARDS 16",6900,"MARCHE EN FAMENNE","Belgique","084 313213",null,"CARINE.BUGATTY@GMAIL;COM","FR","BE0831 884 470",null,null,"Client Pro 1","IDEM",null,null,"Belgique","BUGATTY","Non (Avec TVA)",0,"0478 595427","IDEM",null,null,"Belgique","BOCLINVILLE CARINE",null,"Non"]
[800143,"(nouveau client)"]
[{"$f":"A25+1","v":800144}]
[{"$f":"A26+1","v":800145}]
[800146]
[800147]
[800148]
[800149]
[800150]
[800151]
[800152]
[800153]
[800154]
[800155]
[800156]
[800157]
[800158]
[800159]
[800160]
[800161]
[800162]
[800163]
[800164]
[800165]
[800166]
[800167]
[800168]
[800169]
[800170]
[800171]
[800172]
[800173]
[800174]
[800175]
[800176]

{"sheet":"MOD Vente Comptoir 2 et 3","index":2,"n_rows":54,"n_cols":17,"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],[15,5,15,9],[15,15,16,16],[16,0,17,0],[16,1,17,2],[16,10,17,10],[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],[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]]}
[]
[]
[]
["Mot de passe: 23252325",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°",2017605002]
[]
[null,null,null,null,null,"Tailles",null,null,null,null,null,null,null,null,null,{"$f":"P14+1","v":2017605003}]
[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]
[null,{"$f":"IF(A21=0,\" \",VLOOKUP(A21,inv!$A$2:$G$100,4,FALSE))","v":" "},{"$f":"IF(A21=0,\" \",VLOOKUP(A21,inv!$A$2:$G$100,3,FALSE))","v":" "},"Poly 90% Elast 10%",null,null,null,null,null,null,{"$f":"IF(SUM(F21:J21)=0,\" \",SUM(F21:J21))","v":" "},{"$f":"IF(A21=0,\" \",VLOOKUP(A21,inv!$A$2:$G$100,7,FALSE))","v":" "},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":""},{"$f":"IF(A21=0,\" \",SUM(K21)*SUM(P21))","v":" "}]
[null,{"$f":"IF(A22=0,\" \",VLOOKUP(A22,inv!$A$2:$G$100,4,FALSE))","v":" "},{"$f":"IF(A22=0,\" \",VLOOKUP(A22,inv!$A$2:$G$100,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A22=0,\" \",VLOOKUP(A22,inv!$A$2:$G$100,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:$G$100,4,FALSE))","v":" "},{"$f":"IF(A23=0,\" \",VLOOKUP(A23,inv!$A$2:$G$100,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A23=0,\" \",VLOOKUP(A23,inv!$A$2:$G$100,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A24=0,\" \",VLOOKUP(A24,inv!$A$2:$G$100,4,FALSE))","v":" "},{"$f":"IF(A24=0,\" \",VLOOKUP(A24,inv!$A$2:$G$100,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A24=0,\" \",VLOOKUP(A24,inv!$A$2:$G$100,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A25=0,\" \",VLOOKUP(A25,inv!$A$2:$G$100,4,FALSE))","v":" "},{"$f":"IF(A25=0,\" \",VLOOKUP(A25,inv!$A$2:$G$100,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A25=0,\" \",VLOOKUP(A25,inv!$A$2:$G$100,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A26=0,\" \",VLOOKUP(A26,inv!$A$2:$G$100,4,FALSE))","v":" "},{"$f":"IF(A26=0,\" \",VLOOKUP(A26,inv!$A$2:$G$100,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A26=0,\" \",VLOOKUP(A26,inv!$A$2:$G$100,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A27=0,\" \",VLOOKUP(A27,inv!$A$2:$G$100,4,FALSE))","v":" "},{"$f":"IF(A27=0,\" \",VLOOKUP(A27,inv!$A$2:$G$100,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A27=0,\" \",VLOOKUP(A27,inv!$A$2:$G$100,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A28=0,\" \",VLOOKUP(A28,inv!$A$2:$G$100,4,FALSE))","v":" "},{"$f":"IF(A28=0,\" \",VLOOKUP(A28,inv!$A$2:$G$100,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A28=0,\" \",VLOOKUP(A28,inv!$A$2:$G$100,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A29=0,\" \",VLOOKUP(A29,inv!$A$2:$G$100,4,FALSE))","v":" "},{"$f":"IF(A29=0,\" \",VLOOKUP(A29,inv!$A$2:$G$100,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A29=0,\" \",VLOOKUP(A29,inv!$A$2:$G$100,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A30=0,\" \",VLOOKUP(A30,inv!$A$2:$G$100,4,FALSE))","v":" "},{"$f":"IF(A30=0,\" \",VLOOKUP(A30,inv!$A$2:$G$100,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A30=0,\" \",VLOOKUP(A30,inv!$A$2:$G$100,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A31=0,\" \",VLOOKUP(A31,inv!$A$2:$G$100,4,FALSE))","v":" "},{"$f":"IF(A31=0,\" \",VLOOKUP(A31,inv!$A$2:$G$100,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A31=0,\" \",VLOOKUP(A31,inv!$A$2:$G$100,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A32=0,\" \",VLOOKUP(A32,inv!$A$2:$G$100,4,FALSE))","v":" "},{"$f":"IF(A32=0,\" \",VLOOKUP(A32,inv!$A$2:$G$100,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A32=0,\" \",VLOOKUP(A32,inv!$A$2:$G$100,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A33=0,\" \",VLOOKUP(A33,inv!$A$2:$G$100,4,FALSE))","v":" "},{"$f":"IF(A33=0,\" \",VLOOKUP(A33,inv!$A$2:$G$100,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A33=0,\" \",VLOOKUP(A33,inv!$A$2:$G$100,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A34=0,\" \",VLOOKUP(A34,inv!$A$2:$G$100,4,FALSE))","v":" "},{"$f":"IF(A34=0,\" \",VLOOKUP(A34,inv!$A$2:$G$100,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A34=0,\" \",VLOOKUP(A34,inv!$A$2:$G$100,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A35=0,\" \",VLOOKUP(A35,inv!$A$2:$G$100,4,FALSE))","v":" "},{"$f":"IF(A35=0,\" \",VLOOKUP(A35,inv!$A$2:$G$100,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A35=0,\" \",VLOOKUP(A35,inv!$A$2:$G$100,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A36=0,\" \",VLOOKUP(A36,inv!$A$2:$G$100,4,FALSE))","v":" "},{"$f":"IF(A36=0,\" \",VLOOKUP(A36,inv!$A$2:$G$100,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A36=0,\" \",VLOOKUP(A36,inv!$A$2:$G$100,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A37=0,\" \",VLOOKUP(A37,inv!$A$2:$G$100,4,FALSE))","v":" "},{"$f":"IF(A37=0,\" \",VLOOKUP(A37,inv!$A$2:$G$100,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A37=0,\" \",VLOOKUP(A37,inv!$A$2:$G$100,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A38=0,\" \",VLOOKUP(A38,inv!$A$2:$G$100,4,FALSE))","v":" "},{"$f":"IF(A38=0,\" \",VLOOKUP(A38,inv!$A$2:$G$100,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A38=0,\" \",VLOOKUP(A38,inv!$A$2:$G$100,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A39=0,\" \",VLOOKUP(A39,inv!$A$2:$G$100,4,FALSE))","v":" "},{"$f":"IF(A39=0,\" \",VLOOKUP(A39,inv!$A$2:$G$100,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A39=0,\" \",VLOOKUP(A39,inv!$A$2:$G$100,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A40=0,\" \",VLOOKUP(A40,inv!$A$2:$G$100,4,FALSE))","v":" "},{"$f":"IF(A40=0,\" \",VLOOKUP(A40,inv!$A$2:$G$100,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A40=0,\" \",VLOOKUP(A40,inv!$A$2:$G$100,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A41=0,\" \",VLOOKUP(A41,inv!$A$2:$G$100,4,FALSE))","v":" "},{"$f":"IF(A41=0,\" \",VLOOKUP(A41,inv!$A$2:$G$100,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A41=0,\" \",VLOOKUP(A41,inv!$A$2:$G$100,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A42=0,\" \",VLOOKUP(A42,inv!$A$2:$G$100,4,FALSE))","v":" "},{"$f":"IF(A42=0,\" \",VLOOKUP(A42,inv!$A$2:$G$100,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A42=0,\" \",VLOOKUP(A42,inv!$A$2:$G$100,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A43=0,\" \",VLOOKUP(A43,inv!$A$2:$G$100,4,FALSE))","v":" "},{"$f":"IF(A43=0,\" \",VLOOKUP(A43,inv!$A$2:$G$100,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A43=0,\" \",VLOOKUP(A43,inv!$A$2:$G$100,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A44=0,\" \",VLOOKUP(A44,inv!$A$2:$G$100,4,FALSE))","v":" "},{"$f":"IF(A44=0,\" \",VLOOKUP(A44,inv!$A$2:$G$100,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A44=0,\" \",VLOOKUP(A44,inv!$A$2:$G$100,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A45=0,\" \",VLOOKUP(A45,inv!$A$2:$G$100,4,FALSE))","v":" "},{"$f":"IF(A45=0,\" \",VLOOKUP(A45,inv!$A$2:$G$100,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A45=0,\" \",VLOOKUP(A45,inv!$A$2:$G$100,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A46=0,\" \",VLOOKUP(A46,inv!$A$2:$G$100,4,FALSE))","v":" "},{"$f":"IF(A46=0,\" \",VLOOKUP(A46,inv!$A$2:$G$100,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A46=0,\" \",VLOOKUP(A46,inv!$A$2:$G$100,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A47=0,\" \",VLOOKUP(A47,inv!$A$2:$G$100,4,FALSE))","v":" "},{"$f":"IF(A47=0,\" \",VLOOKUP(A47,inv!$A$2:$G$100,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A47=0,\" \",VLOOKUP(A47,inv!$A$2:$G$100,7,FALSE))","v":" "},null,null,"",""," "]
["Total: ",{"$f":"SUM(K21:K47)","v":0},"pièce(s)",null,null,null,null,null,null,"Montant hors tva : ",null,null,{"$f":"SUM(Q21:Q47)+SUM(M50)","v":0}]
["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))*0.9091666","v":0}]
[null,null,null,null,null,null,null,null,null,"Tva 21% :",null,null,{"$f":"SUM(M52*0.21)","v":0}]
[null,null,null,null,null,null,null,null,null,"Total :",null,null,{"$f":"SUM(M52*1.21)","v":0}]

{"sheet":"2017605003","index":3,"n_rows":54,"n_cols":17,"rows_kept":54,"cut":false,"hidden":false,"merged":[[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],[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],[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],[0,0,0,16],[3,12,3,15],[4,9,4,16],[5,9,5,16],[6,9,6,16],[7,9,7,16]]}
[]
[]
[]
["Mot de passe: 23252325",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°",2017605003]
[]
[null,null,null,null,null,"Tailles",null,null,null,null,null,null,null,null,null,{"$f":"P14+1","v":2017605004}]
[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]
["S800B4",{"$f":"IF(A21=0,\" \",VLOOKUP(A21,inv!$A$2:$G$100,4,FALSE))","v":"10-91                         "},{"$f":"IF(A21=0,\" \",VLOOKUP(A21,inv!$A$2:$G$100,3,FALSE))","v":"TUNIQUE                     42"},"Poly 90% Elast 10%",null,null,null,null,null,null,{"$f":"IF(SUM(F21:J21)=0,\" \",SUM(F21:J21))","v":" "},{"$f":"IF(A21=0,\" \",VLOOKUP(A21,inv!$A$2:$G$100,7,FALSE))","v":44},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":44},{"$f":"IF(A21=0,\" \",SUM(K21)*SUM(P21))","v":0}]
[null,{"$f":"IF(A22=0,\" \",VLOOKUP(A22,inv!$A$2:$G$100,4,FALSE))","v":" "},{"$f":"IF(A22=0,\" \",VLOOKUP(A22,inv!$A$2:$G$100,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A22=0,\" \",VLOOKUP(A22,inv!$A$2:$G$100,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:$G$100,4,FALSE))","v":" "},{"$f":"IF(A23=0,\" \",VLOOKUP(A23,inv!$A$2:$G$100,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A23=0,\" \",VLOOKUP(A23,inv!$A$2:$G$100,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A24=0,\" \",VLOOKUP(A24,inv!$A$2:$G$100,4,FALSE))","v":" "},{"$f":"IF(A24=0,\" \",VLOOKUP(A24,inv!$A$2:$G$100,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A24=0,\" \",VLOOKUP(A24,inv!$A$2:$G$100,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A25=0,\" \",VLOOKUP(A25,inv!$A$2:$G$100,4,FALSE))","v":" "},{"$f":"IF(A25=0,\" \",VLOOKUP(A25,inv!$A$2:$G$100,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A25=0,\" \",VLOOKUP(A25,inv!$A$2:$G$100,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A26=0,\" \",VLOOKUP(A26,inv!$A$2:$G$100,4,FALSE))","v":" "},{"$f":"IF(A26=0,\" \",VLOOKUP(A26,inv!$A$2:$G$100,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A26=0,\" \",VLOOKUP(A26,inv!$A$2:$G$100,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A27=0,\" \",VLOOKUP(A27,inv!$A$2:$G$100,4,FALSE))","v":" "},{"$f":"IF(A27=0,\" \",VLOOKUP(A27,inv!$A$2:$G$100,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A27=0,\" \",VLOOKUP(A27,inv!$A$2:$G$100,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A28=0,\" \",VLOOKUP(A28,inv!$A$2:$G$100,4,FALSE))","v":" "},{"$f":"IF(A28=0,\" \",VLOOKUP(A28,inv!$A$2:$G$100,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A28=0,\" \",VLOOKUP(A28,inv!$A$2:$G$100,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A29=0,\" \",VLOOKUP(A29,inv!$A$2:$G$100,4,FALSE))","v":" "},{"$f":"IF(A29=0,\" \",VLOOKUP(A29,inv!$A$2:$G$100,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A29=0,\" \",VLOOKUP(A29,inv!$A$2:$G$100,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A30=0,\" \",VLOOKUP(A30,inv!$A$2:$G$100,4,FALSE))","v":" "},{"$f":"IF(A30=0,\" \",VLOOKUP(A30,inv!$A$2:$G$100,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A30=0,\" \",VLOOKUP(A30,inv!$A$2:$G$100,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A31=0,\" \",VLOOKUP(A31,inv!$A$2:$G$100,4,FALSE))","v":" "},{"$f":"IF(A31=0,\" \",VLOOKUP(A31,inv!$A$2:$G$100,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A31=0,\" \",VLOOKUP(A31,inv!$A$2:$G$100,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A32=0,\" \",VLOOKUP(A32,inv!$A$2:$G$100,4,FALSE))","v":" "},{"$f":"IF(A32=0,\" \",VLOOKUP(A32,inv!$A$2:$G$100,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A32=0,\" \",VLOOKUP(A32,inv!$A$2:$G$100,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A33=0,\" \",VLOOKUP(A33,inv!$A$2:$G$100,4,FALSE))","v":" "},{"$f":"IF(A33=0,\" \",VLOOKUP(A33,inv!$A$2:$G$100,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A33=0,\" \",VLOOKUP(A33,inv!$A$2:$G$100,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A34=0,\" \",VLOOKUP(A34,inv!$A$2:$G$100,4,FALSE))","v":" "},{"$f":"IF(A34=0,\" \",VLOOKUP(A34,inv!$A$2:$G$100,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A34=0,\" \",VLOOKUP(A34,inv!$A$2:$G$100,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A35=0,\" \",VLOOKUP(A35,inv!$A$2:$G$100,4,FALSE))","v":" "},{"$f":"IF(A35=0,\" \",VLOOKUP(A35,inv!$A$2:$G$100,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A35=0,\" \",VLOOKUP(A35,inv!$A$2:$G$100,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A36=0,\" \",VLOOKUP(A36,inv!$A$2:$G$100,4,FALSE))","v":" "},{"$f":"IF(A36=0,\" \",VLOOKUP(A36,inv!$A$2:$G$100,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A36=0,\" \",VLOOKUP(A36,inv!$A$2:$G$100,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A37=0,\" \",VLOOKUP(A37,inv!$A$2:$G$100,4,FALSE))","v":" "},{"$f":"IF(A37=0,\" \",VLOOKUP(A37,inv!$A$2:$G$100,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A37=0,\" \",VLOOKUP(A37,inv!$A$2:$G$100,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A38=0,\" \",VLOOKUP(A38,inv!$A$2:$G$100,4,FALSE))","v":" "},{"$f":"IF(A38=0,\" \",VLOOKUP(A38,inv!$A$2:$G$100,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A38=0,\" \",VLOOKUP(A38,inv!$A$2:$G$100,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A39=0,\" \",VLOOKUP(A39,inv!$A$2:$G$100,4,FALSE))","v":" "},{"$f":"IF(A39=0,\" \",VLOOKUP(A39,inv!$A$2:$G$100,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A39=0,\" \",VLOOKUP(A39,inv!$A$2:$G$100,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A40=0,\" \",VLOOKUP(A40,inv!$A$2:$G$100,4,FALSE))","v":" "},{"$f":"IF(A40=0,\" \",VLOOKUP(A40,inv!$A$2:$G$100,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A40=0,\" \",VLOOKUP(A40,inv!$A$2:$G$100,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A41=0,\" \",VLOOKUP(A41,inv!$A$2:$G$100,4,FALSE))","v":" "},{"$f":"IF(A41=0,\" \",VLOOKUP(A41,inv!$A$2:$G$100,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A41=0,\" \",VLOOKUP(A41,inv!$A$2:$G$100,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A42=0,\" \",VLOOKUP(A42,inv!$A$2:$G$100,4,FALSE))","v":" "},{"$f":"IF(A42=0,\" \",VLOOKUP(A42,inv!$A$2:$G$100,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A42=0,\" \",VLOOKUP(A42,inv!$A$2:$G$100,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A43=0,\" \",VLOOKUP(A43,inv!$A$2:$G$100,4,FALSE))","v":" "},{"$f":"IF(A43=0,\" \",VLOOKUP(A43,inv!$A$2:$G$100,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A43=0,\" \",VLOOKUP(A43,inv!$A$2:$G$100,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A44=0,\" \",VLOOKUP(A44,inv!$A$2:$G$100,4,FALSE))","v":" "},{"$f":"IF(A44=0,\" \",VLOOKUP(A44,inv!$A$2:$G$100,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A44=0,\" \",VLOOKUP(A44,inv!$A$2:$G$100,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A45=0,\" \",VLOOKUP(A45,inv!$A$2:$G$100,4,FALSE))","v":" "},{"$f":"IF(A45=0,\" \",VLOOKUP(A45,inv!$A$2:$G$100,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A45=0,\" \",VLOOKUP(A45,inv!$A$2:$G$100,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A46=0,\" \",VLOOKUP(A46,inv!$A$2:$G$100,4,FALSE))","v":" "},{"$f":"IF(A46=0,\" \",VLOOKUP(A46,inv!$A$2:$G$100,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A46=0,\" \",VLOOKUP(A46,inv!$A$2:$G$100,7,FALSE))","v":" "},null,null,"",""," "]
[null,{"$f":"IF(A47=0,\" \",VLOOKUP(A47,inv!$A$2:$G$100,4,FALSE))","v":" "},{"$f":"IF(A47=0,\" \",VLOOKUP(A47,inv!$A$2:$G$100,3,FALSE))","v":" "},null,null,null,null,null,null,null," ",{"$f":"IF(A47=0,\" \",VLOOKUP(A47,inv!$A$2:$G$100,7,FALSE))","v":" "},null,null,"",""," "]
["Total: ",{"$f":"SUM(K21:K47)","v":0},"pièce(s)",null,null,null,null,null,null,"Montant hors tva : ",null,null,{"$f":"SUM(Q21:Q47)+SUM(M50)","v":0}]
["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))*0.9091666","v":0}]
[null,null,null,null,null,null,null,null,null,"Tva 21% :",null,null,{"$f":"SUM(M52*0.21)","v":0}]
[null,null,null,null,null,null,null,null,null,"Total :",null,null,{"$f":"SUM(M52*1.21)","v":0}]