{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["login","members","tableau de bord","facture","stock","historique factures","clients","TVA"],"not_rendered":{"charts":1,"images":2,"macros":1,"external_links":0,"defined_names":13,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"login","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"members","index":1,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
[]
[null,"user","password","role"]
[null,"KANKOER","KANkoer1987,","KANKONDE ERIC"]
[null,"CELINE",1234,"USER"]
[null,"BENJAMIN",1234,"USER"]
[null,"RACHEL",1234,"USER"]

{"sheet":"tableau de bord","index":2,"n_rows":24,"n_cols":16,"rows_kept":24,"cut":false,"hidden":true,"merged":[[16,0,16,1],[0,0,0,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[14,0,14,1]]}
["Nouveau client",null,null,null,1,2,3,4,5,6,7,8,9,10,11,12]
["Nom",null,null,null,"janvier","février","mars","avril","mai","juin","juillet","août","septembre","octobre","novembre","décembre"]
["Prenom",null,null,"Total/mois",{"$f":"SUMIF('historique factures'!$E:$E,E1,'historique factures'!$D:$D)","v":0},{"$f":"SUMIF('historique factures'!$E:$E,F1,'historique factures'!$D:$D)","v":0},{"$f":"SUMIF('historique factures'!$E:$E,G1,'historique factures'!$D:$D)","v":0},{"$f":"SUMIF('historique factures'!$E:$E,H1,'historique factures'!$D:$D)","v":0},{"$f":"SUMIF('historique factures'!$E:$E,I1,'historique factures'!$D:$D)","v":0},{"$f":"SUMIF('historique factures'!$E:$E,J1,'historique factures'!$D:$D)","v":0},{"$f":"SUMIF('historique factures'!$E:$E,K1,'historique factures'!$D:$D)","v":0},{"$f":"SUMIF('historique factures'!$E:$E,L1,'historique factures'!$D:$D)","v":0},{"$f":"SUMIF('historique factures'!$E:$E,M1,'historique factures'!$D:$D)","v":0},{"$f":"SUMIF('historique factures'!$E:$E,N1,'historique factures'!$D:$D)","v":0},{"$f":"SUMIF('historique factures'!$E:$E,O1,'historique factures'!$D:$D)","v":0},{"$f":"SUMIF('historique factures'!$E:$E,P1,'historique factures'!$D:$D)","v":0}]
["Adresse"]
["Code postal"]
["Tel"]
["ville"]
[]
[]
["Menu"]
["Facture"]
["Stock"]
["historique"]
["Client"]
["TVA"]
[]
["Recapitulatif"]
["Montant Max",{"$f":"MAX(clients!I:I)","v":0}]
["le melleur client",{"$f":"VLOOKUP(B18,clients!I:J,2,0)","v":"MULENGA LUCIEN"}]
["Montant Min",{"$f":"MIN('historique factures'!D:D)","v":699630}]
["Montant moyen",{"$f":"IFERROR(AVERAGE('historique factures'!D:D),\"\")","v":699630}]
["Montant median",{"$f":"IFERROR(MEDIAN('historique factures'!D:D),\"\")","v":699630}]
["Montant total",{"$f":"SUM('historique factures'!D:D)","v":699630}]
["Nombre de facture",{"$f":"COUNT('historique factures'!D:D)","v":1}]

{"sheet":"facture","index":3,"n_rows":40,"n_cols":18,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,0,0,2],[6,0,6,1],[0,3,0,6],[1,5,1,6],[2,5,2,6],[3,5,3,6],[4,5,4,6],[19,3,19,5],[20,3,20,5],[22,3,22,5],[21,3,21,5],[21,11,21,12],[22,11,22,12],[5,7,6,8],[19,11,19,12],[31,10,31,12],[20,10,20,12],[0,10,0,11],[23,11,23,12],[24,11,24,12],[25,11,25,12],[26,11,26,12],[27,11,27,12],[3,7,4,8]]}
[null,null,null,{"$f":"TODAY()","v":"2019-04-11"}]
[]
[]
[]
[]
[]
["         Nº :",null,1]
[]
["Ref","Qte","Designation","TVA","P.U ht","P.U ttc","Total ttc","REF","Qte","EN STOCK",null,null,null,null,"TOTAL HT","TVA"]
[{"$f":"UPPER(H10)","v":"A001"},{"$f":"IF(I10=\"\",\"\",I10)","v":51},{"$f":"IFERROR(IF(VLOOKUP(A10,OFFSET(stock!$A$1:$E$1,0,0,COUNTA(stock!$A:$E)),5,FALSE)=0,\"rupture de stock\", VLOOKUP(A10,OFFSET(stock!$A$1:$E$1,0,0,COUNTA(stock!$A:$E)),2,FALSE)),\"\")","v":"SUCRE"},{"$f":"IF(A10=\"\",\"\",VLOOKUP(A10,stock!A:C,3,0))","v":1},{"$f":"IF(B10=\"\",\"\",IFERROR(IF(VLOOKUP(A10,OFFSET(stock!$A$1:$E$1,0,0,COUNTA(stock!$A:$E)),5,FALSE)=0,\"-\", VLOOKUP(A10,OFFSET(stock!$A$1:$E$1,0,0,COUNTA(stock!$A:$E)),4,FALSE)),\"\"))","v":2000},{"$f":"IFERROR(IF(A10=\"\",\"\",VLOOKUP(D10,TVA!A:B,2,0)*E10+E10),\"\")","v":2100},{"$f":"IFERROR(IF(ISNUMBER(E10),F10*B10,\"\"),\"\")","v":107100},"A001",51,{"$f":"IFERROR(VLOOKUP(H10,stock!A:E,5,0),\"\")","v":50},null,null,null,null,{"$f":"IF(A10=\"\",\"\",B10*E10)","v":102000},{"$f":"IF(A10=\"\",\"\",VLOOKUP(D10,TVA!A:B,2,0)*E10*B10)","v":5100}]
[{"$f":"UPPER(H11)","v":"A002"},49,{"$f":"IFERROR(IF(VLOOKUP(A11,OFFSET(stock!$A$1:$E$1,0,0,COUNTA(stock!$A:$E)),5,FALSE)=0,\"rupture de stock\", VLOOKUP(A11,OFFSET(stock!$A$1:$E$1,0,0,COUNTA(stock!$A:$E)),2,FALSE)),\"\")","v":"RAMA"},{"$f":"IF(A11=\"\",\"\",VLOOKUP(A11,stock!A:C,3,0))","v":2},{"$f":"IF(B11=\"\",\"\",IFERROR(IF(VLOOKUP(A11,OFFSET(stock!$A$1:$E$1,0,0,COUNTA(stock!$A:$E)),5,FALSE)=0,\"-\", VLOOKUP(A11,OFFSET(stock!$A$1:$E$1,0,0,COUNTA(stock!$A:$E)),4,FALSE)),\"\"))","v":3000},{"$f":"IFERROR(IF(A11=\"\",\"\",VLOOKUP(D11,TVA!A:B,2,0)*E11+E11),\"\")","v":3300},161700,"A002",49,{"$f":"IFERROR(VLOOKUP(H11,stock!A:E,5,0),\"\")","v":48},null,null,null,null,{"$f":"IF(A11=\"\",\"\",B11*E11)","v":147000},{"$f":"IF(A11=\"\",\"\",VLOOKUP(D11,TVA!A:B,2,0)*E11*B11)","v":14700}]
["A003",51,{"$f":"IFERROR(IF(VLOOKUP(A12,OFFSET(stock!$A$1:$E$1,0,0,COUNTA(stock!$A:$E)),5,FALSE)=0,\"rupture de stock\", VLOOKUP(A12,OFFSET(stock!$A$1:$E$1,0,0,COUNTA(stock!$A:$E)),2,FALSE)),\"\")","v":"RIZ"},{"$f":"IF(A12=\"\",\"\",VLOOKUP(A12,stock!A:C,3,0))","v":1},{"$f":"IF(B12=\"\",\"\",IFERROR(IF(VLOOKUP(A12,OFFSET(stock!$A$1:$E$1,0,0,COUNTA(stock!$A:$E)),5,FALSE)=0,\"-\", VLOOKUP(A12,OFFSET(stock!$A$1:$E$1,0,0,COUNTA(stock!$A:$E)),4,FALSE)),\"\"))","v":1600},{"$f":"IFERROR(IF(A12=\"\",\"\",VLOOKUP(D12,TVA!A:B,2,0)*E12+E12),\"\")","v":1680},85680,"A003",51,{"$f":"IFERROR(VLOOKUP(H12,stock!A:E,5,0),\"\")","v":50},null,null,null,null,81600,{"$f":"IF(A12=\"\",\"\",VLOOKUP(D12,TVA!A:B,2,0)*E12*B12)","v":4080}]
["A004",6,{"$f":"IFERROR(IF(VLOOKUP(A13,OFFSET(stock!$A$1:$E$1,0,0,COUNTA(stock!$A:$E)),5,FALSE)=0,\"rupture de stock\", VLOOKUP(A13,OFFSET(stock!$A$1:$E$1,0,0,COUNTA(stock!$A:$E)),2,FALSE)),\"\")","v":"Tomate"},{"$f":"IF(A13=\"\",\"\",VLOOKUP(A13,stock!A:C,3,0))","v":1},{"$f":"IF(B13=\"\",\"\",IFERROR(IF(VLOOKUP(A13,OFFSET(stock!$A$1:$E$1,0,0,COUNTA(stock!$A:$E)),5,FALSE)=0,\"-\", VLOOKUP(A13,OFFSET(stock!$A$1:$E$1,0,0,COUNTA(stock!$A:$E)),4,FALSE)),\"\"))","v":10000},{"$f":"IFERROR(IF(A13=\"\",\"\",VLOOKUP(D13,TVA!A:B,2,0)*E13+E13),\"\")","v":10500},63000,"A004",6,{"$f":"IFERROR(VLOOKUP(H13,stock!A:E,5,0),\"\")","v":5},null,null,null,null,60000,{"$f":"IF(A13=\"\",\"\",VLOOKUP(D13,TVA!A:B,2,0)*E13*B13)","v":3000}]
["A005",51,{"$f":"IFERROR(IF(VLOOKUP(A14,OFFSET(stock!$A$1:$E$1,0,0,COUNTA(stock!$A:$E)),5,FALSE)=0,\"rupture de stock\", VLOOKUP(A14,OFFSET(stock!$A$1:$E$1,0,0,COUNTA(stock!$A:$E)),2,FALSE)),\"\")","v":"JUS"},{"$f":"IF(A14=\"\",\"\",VLOOKUP(A14,stock!A:C,3,0))","v":2},{"$f":"IF(B14=\"\",\"\",IFERROR(IF(VLOOKUP(A14,OFFSET(stock!$A$1:$E$1,0,0,COUNTA(stock!$A:$E)),5,FALSE)=0,\"-\", VLOOKUP(A14,OFFSET(stock!$A$1:$E$1,0,0,COUNTA(stock!$A:$E)),4,FALSE)),\"\"))","v":1500},{"$f":"IFERROR(IF(A14=\"\",\"\",VLOOKUP(D14,TVA!A:B,2,0)*E14+E14),\"\")","v":1650},84150,"A005",51,{"$f":"IFERROR(VLOOKUP(H14,stock!A:E,5,0),\"\")","v":50},null,null,null,null,76500,{"$f":"IF(A14=\"\",\"\",VLOOKUP(D14,TVA!A:B,2,0)*E14*B14)","v":7650}]
["A006",30,{"$f":"IFERROR(IF(VLOOKUP(A15,OFFSET(stock!$A$1:$E$1,0,0,COUNTA(stock!$A:$E)),5,FALSE)=0,\"rupture de stock\", VLOOKUP(A15,OFFSET(stock!$A$1:$E$1,0,0,COUNTA(stock!$A:$E)),2,FALSE)),\"\")","v":"ORANGE"},{"$f":"IF(A15=\"\",\"\",VLOOKUP(A15,stock!A:C,3,0))","v":2},{"$f":"IF(B15=\"\",\"\",IFERROR(IF(VLOOKUP(A15,OFFSET(stock!$A$1:$E$1,0,0,COUNTA(stock!$A:$E)),5,FALSE)=0,\"-\", VLOOKUP(A15,OFFSET(stock!$A$1:$E$1,0,0,COUNTA(stock!$A:$E)),4,FALSE)),\"\"))","v":6000},{"$f":"IFERROR(IF(A15=\"\",\"\",VLOOKUP(D15,TVA!A:B,2,0)*E15+E15),\"\")","v":6600},198000,"A006",30,{"$f":"IFERROR(VLOOKUP(H15,stock!A:E,5,0),\"\")","v":29},null,null,null,null,180000,{"$f":"IF(A15=\"\",\"\",VLOOKUP(D15,TVA!A:B,2,0)*E15*B15)","v":18000}]
["","",{"$f":"IFERROR(IF(VLOOKUP(A16,OFFSET(stock!$A$1:$E$1,0,0,COUNTA(stock!$A:$E)),5,FALSE)=0,\"rupture de stock\", VLOOKUP(A16,OFFSET(stock!$A$1:$E$1,0,0,COUNTA(stock!$A:$E)),2,FALSE)),\"\")","v":""},{"$f":"IF(A16=\"\",\"\",VLOOKUP(A16,stock!A:C,3,0))","v":""},{"$f":"IF(B16=\"\",\"\",IFERROR(IF(VLOOKUP(A16,OFFSET(stock!$A$1:$E$1,0,0,COUNTA(stock!$A:$E)),5,FALSE)=0,\"-\", VLOOKUP(A16,OFFSET(stock!$A$1:$E$1,0,0,COUNTA(stock!$A:$E)),4,FALSE)),\"\"))","v":""},{"$f":"IFERROR(IF(A16=\"\",\"\",VLOOKUP(D16,TVA!A:B,2,0)*E16+E16),\"\")","v":""},"",null,null,{"$f":"IFERROR(VLOOKUP(H16,stock!A:E,5,0),\"\")","v":""},null,null,null,null,"",{"$f":"IF(A16=\"\",\"\",VLOOKUP(D16,TVA!A:B,2,0)*E16*B16)","v":""}]
["","",{"$f":"IFERROR(IF(VLOOKUP(A17,OFFSET(stock!$A$1:$E$1,0,0,COUNTA(stock!$A:$E)),5,FALSE)=0,\"rupture de stock\", VLOOKUP(A17,OFFSET(stock!$A$1:$E$1,0,0,COUNTA(stock!$A:$E)),2,FALSE)),\"\")","v":""},{"$f":"IF(A17=\"\",\"\",VLOOKUP(A17,stock!A:C,3,0))","v":""},{"$f":"IF(B17=\"\",\"\",IFERROR(IF(VLOOKUP(A17,OFFSET(stock!$A$1:$E$1,0,0,COUNTA(stock!$A:$E)),5,FALSE)=0,\"-\", VLOOKUP(A17,OFFSET(stock!$A$1:$E$1,0,0,COUNTA(stock!$A:$E)),4,FALSE)),\"\"))","v":""},{"$f":"IFERROR(IF(A17=\"\",\"\",VLOOKUP(D17,TVA!A:B,2,0)*E17+E17),\"\")","v":""},"",null,null,{"$f":"IFERROR(VLOOKUP(H17,stock!A:E,5,0),\"\")","v":""},null,null,null,null,"",{"$f":"IF(A17=\"\",\"\",VLOOKUP(D17,TVA!A:B,2,0)*E17*B17)","v":""}]
["","",{"$f":"IFERROR(IF(VLOOKUP(A18,OFFSET(stock!$A$1:$E$1,0,0,COUNTA(stock!$A:$E)),5,FALSE)=0,\"rupture de stock\", VLOOKUP(A18,OFFSET(stock!$A$1:$E$1,0,0,COUNTA(stock!$A:$E)),2,FALSE)),\"\")","v":""},{"$f":"IF(A18=\"\",\"\",VLOOKUP(A18,stock!A:C,3,0))","v":""},{"$f":"IF(B18=\"\",\"\",IFERROR(IF(VLOOKUP(A18,OFFSET(stock!$A$1:$E$1,0,0,COUNTA(stock!$A:$E)),5,FALSE)=0,\"-\", VLOOKUP(A18,OFFSET(stock!$A$1:$E$1,0,0,COUNTA(stock!$A:$E)),4,FALSE)),\"\"))","v":""},{"$f":"IFERROR(IF(A18=\"\",\"\",VLOOKUP(D18,TVA!A:B,2,0)*E18+E18),\"\")","v":""},"",null,null,{"$f":"IFERROR(VLOOKUP(H18,stock!A:E,5,0),\"\")","v":""},null,null,null,null,"",{"$f":"IF(A18=\"\",\"\",VLOOKUP(D18,TVA!A:B,2,0)*E18*B18)","v":""},null,{"$f":"LOWER(R16)","v":""}]
["","",{"$f":"IFERROR(IF(VLOOKUP(A19,OFFSET(stock!$A$1:$E$1,0,0,COUNTA(stock!$A:$E)),5,FALSE)=0,\"rupture de stock\", VLOOKUP(A19,OFFSET(stock!$A$1:$E$1,0,0,COUNTA(stock!$A:$E)),2,FALSE)),\"\")","v":""},{"$f":"IF(A19=\"\",\"\",VLOOKUP(A19,stock!A:C,3,0))","v":""},{"$f":"IF(B19=\"\",\"\",IFERROR(IF(VLOOKUP(A19,OFFSET(stock!$A$1:$E$1,0,0,COUNTA(stock!$A:$E)),5,FALSE)=0,\"-\", VLOOKUP(A19,OFFSET(stock!$A$1:$E$1,0,0,COUNTA(stock!$A:$E)),4,FALSE)),\"\"))","v":""},{"$f":"IFERROR(IF(A19=\"\",\"\",VLOOKUP(D19,TVA!A:B,2,0)*E19+E19),\"\")","v":""},"",null,null,{"$f":"IFERROR(VLOOKUP(H19,stock!A:E,5,0),\"\")","v":""},null,null,null,null,"",{"$f":"IF(A19=\"\",\"\",VLOOKUP(D19,TVA!A:B,2,0)*E19*B19)","v":""}]
[{"$f":"UPPER(#REF!)","v":{"$error":"#REF!"}},null,null,"Total ht",null,null,{"$f":"IFERROR(SUM(O10:O19),\"\")","v":647100}]
[{"$f":"UPPER(#REF!)","v":{"$error":"#REF!"}},null,null,"TVA",null,null,{"$f":"IFERROR(SUM(P10:P19),\"\")","v":52530}]
[{"$f":"UPPER(#REF!)","v":{"$error":"#REF!"}},null,null,"Frais de port"]
[{"$f":"UPPER(#REF!)","v":{"$error":"#REF!"}},null,null,"TOtal TTC",null,null,{"$f":"IFERROR(IF(G21=\"\",\"\",SUM(G20:G21)),\"\")","v":699630}]
[{"$f":"UPPER(#REF!)","v":{"$error":"#REF!"}}]
[{"$f":"UPPER(#REF!)","v":{"$error":"#REF!"}}]
[{"$f":"UPPER(#REF!)","v":{"$error":"#REF!"}}]
[{"$f":"UPPER(#REF!)","v":{"$error":"#REF!"}}]
[{"$f":"UPPER(#REF!)","v":{"$error":"#REF!"}}]
[{"$f":"UPPER(#REF!)","v":{"$error":"#REF!"}}]
[{"$f":"UPPER(#REF!)","v":{"$error":"#REF!"}}]
[{"$f":"UPPER(#REF!)","v":{"$error":"#REF!"}}]
[{"$f":"UPPER(#REF!)","v":{"$error":"#REF!"}}]
[{"$f":"UPPER(#REF!)","v":{"$error":"#REF!"}}]
[{"$f":"UPPER(#REF!)","v":{"$error":"#REF!"}}]
[{"$f":"UPPER(#REF!)","v":{"$error":"#REF!"}}]
[{"$f":"UPPER(#REF!)","v":{"$error":"#REF!"}}]
[{"$f":"UPPER(#REF!)","v":{"$error":"#REF!"}}]
[{"$f":"UPPER(#REF!)","v":{"$error":"#REF!"}}]
[{"$f":"UPPER(#REF!)","v":{"$error":"#REF!"}}]
[{"$f":"UPPER(#REF!)","v":{"$error":"#REF!"}}]

{"sheet":"stock","index":4,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Ref","Designation","Code TVA","Prix HT","STOCK ACTUEL"]
["A001","SUCRE",1,2000,50]
["A002","RAMA",2,3000,48]
["A003","RIZ",1,1600,50]
["A004","Tomate",1,10000,5]
["A005","JUS",2,1500,50]
["A006","ORANGE",2,6000,29]

{"sheet":"historique factures","index":5,"n_rows":2,"n_cols":21,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["N° facture","client","date","montant","mois",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(A:A)","v":2}]
[1,null,"2019-04-11",699630]

{"sheet":"clients","index":6,"n_rows":6,"n_cols":10,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["identifiant","nom ","prenom","adresse","code postal","ville","telephone","facture","Montant total","Identifiant2"]
[{"$f":"CONCATENATE(B2,\" \",C2)","v":"MULENGA LUCIEN"},"MULENGA","LUCIEN","RUASHI, ",8793,"LUBUMBASHI",812347456,{"$f":"COUNTIF('historique factures'!B:B,A2)","v":0},{"$f":"SUMIF('historique factures'!B:B,A2,'historique factures'!D:D)","v":0},{"$f":"A2","v":"MULENGA LUCIEN"}]
[{"$f":"CONCATENATE(B3,\" \",C3)","v":"JEAN ROBERT ILUNGA"},"JEAN ROBERT","ILUNGA","34. Q. DAV KALEMIE",54628,"GOMA",995422254,{"$f":"COUNTIF('historique factures'!B:B,A3)","v":0},{"$f":"SUMIF('historique factures'!B:B,A3,'historique factures'!D:D)","v":0},{"$f":"A3","v":"JEAN ROBERT ILUNGA"}]
[{"$f":"CONCATENATE(B4,\" \",C4)","v":"benjamim lubala"},"benjamim","lubala","n 5 av kongolo Q. Congo C. Ruashi",263,"kolwezi",995422254,{"$f":"COUNTIF('historique factures'!B:B,A4)","v":0},{"$f":"SUMIF('historique factures'!B:B,A4,'historique factures'!D:D)","v":0},{"$f":"A4","v":"benjamim lubala"}]
[{"$f":"CONCATENATE(B5,\" \",C5)","v":"KANKOER ERIC"},"KANKOER","ERIC","23 av dilolo Ruashi",54628,"LUBUMBASHI","099 58 222 58",{"$f":"COUNTIF('historique factures'!B:B,A5)","v":0},{"$f":"SUMIF('historique factures'!B:B,A5,'historique factures'!D:D)","v":0},{"$f":"A5","v":"KANKOER ERIC"}]
[{"$f":"CONCATENATE(B6,\" \",C6)","v":"CELINE KANKOER"},"CELINE","KANKOER","45 Av kasapa, Kamalondo",28640,"LIKASI","097 095 80 37",{"$f":"COUNTIF('historique factures'!B:B,A6)","v":0},{"$f":"SUMIF('historique factures'!B:B,A6,'historique factures'!D:D)","v":0},{"$f":"A6","v":"CELINE KANKOER"}]

{"sheet":"TVA","index":7,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Code TVA","Taux"]
[1,0.05]
[2,0.1]