{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["login","facture","stock","TVA"],"not_rendered":{"charts":0,"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":"facture","index":1,"n_rows":40,"n_cols":18,"rows_kept":40,"cut":false,"hidden":false,"merged":[[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],[19,3,19,5],[20,3,20,5],[22,3,22,5],[21,3,21,5],[21,11,21,12],[22,11,22,12],[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]]}
[null,null,null,{"$f":"TODAY()","v":"2019-05-21"}]
[null,null,null,null,"NOMS:","MARC"]
[null,null,null,null,"ADRESSE:",{"$f":"IFERROR(IF(F2=\"\",\"\",VLOOKUP(F2,#REF!,4,0)),\"\")","v":""}]
[null,null,null,null,"CP/VILLE:",{"$f":"IFERROR(IF(F2=\"\",\"\",CONCATENATE(VLOOKUP(F2,#REF!,5,0),\" \",VLOOKUP(F2,#REF!,6,0))),\"\")","v":""}]
[null,null,null,null,"TEL:",{"$f":"IFERROR(IF(F2=\"\",\"\",VLOOKUP(F2,#REF!,7,0)),\"\")","v":""}]
[]
["         Nº :",null,1]
[]
["Ref","Qte","Designation","TVA","P.U ht","P.U ttc","Total ttc","REF","Qte",null,null,null,null,null,"TOTAL HT","TVA"]
[{"$f":"UPPER(H10)","v":"A021"},{"$f":"IF(I10=\"\",\"\",I10)","v":3},{"$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":"CHOUX"},{"$f":"IF(A10=\"\",\"\",VLOOKUP(A10,stock!A:C,3,0))","v":0},{"$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":""},{"$f":"IFERROR(IF(ISNUMBER(E10),F10*B10,\"\"),\"\")","v":""},"A021",3,null,null,null,null,null,{"$f":"IF(A10=\"\",\"\",B10*E10)","v":6000},{"$f":"IF(A10=\"\",\"\",VLOOKUP(D10,TVA!A:B,2,0)*E10*B10)","v":{"$error":"#N/A"}}]
[{"$f":"UPPER(H11)","v":""},"",{"$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":""},{"$f":"IF(A11=\"\",\"\",VLOOKUP(A11,stock!A:C,3,0))","v":""},{"$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":""},{"$f":"IFERROR(IF(A11=\"\",\"\",VLOOKUP(D11,TVA!A:B,2,0)*E11+E11),\"\")","v":""},"",null,null,null,null,null,null,null,{"$f":"IF(A11=\"\",\"\",B11*E11)","v":""},{"$f":"IF(A11=\"\",\"\",VLOOKUP(D11,TVA!A:B,2,0)*E11*B11)","v":""}]
["","",{"$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":""},{"$f":"IF(A12=\"\",\"\",VLOOKUP(A12,stock!A:C,3,0))","v":""},{"$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":""},{"$f":"IFERROR(IF(A12=\"\",\"\",VLOOKUP(D12,TVA!A:B,2,0)*E12+E12),\"\")","v":""},"",null,null,null,null,null,null,null,"",{"$f":"IF(A12=\"\",\"\",VLOOKUP(D12,TVA!A:B,2,0)*E12*B12)","v":""}]
["","",{"$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":""},{"$f":"IF(A13=\"\",\"\",VLOOKUP(A13,stock!A:C,3,0))","v":""},{"$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":""},{"$f":"IFERROR(IF(A13=\"\",\"\",VLOOKUP(D13,TVA!A:B,2,0)*E13+E13),\"\")","v":""},"",null,null,null,null,null,null,null,"",{"$f":"IF(A13=\"\",\"\",VLOOKUP(D13,TVA!A:B,2,0)*E13*B13)","v":""}]
["","",{"$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":""},{"$f":"IF(A14=\"\",\"\",VLOOKUP(A14,stock!A:C,3,0))","v":""},{"$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":""},{"$f":"IFERROR(IF(A14=\"\",\"\",VLOOKUP(D14,TVA!A:B,2,0)*E14+E14),\"\")","v":""},"",null,null,null,null,null,null,null,"",{"$f":"IF(A14=\"\",\"\",VLOOKUP(D14,TVA!A:B,2,0)*E14*B14)","v":""}]
["","",{"$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":""},{"$f":"IF(A15=\"\",\"\",VLOOKUP(A15,stock!A:C,3,0))","v":""},{"$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":""},{"$f":"IFERROR(IF(A15=\"\",\"\",VLOOKUP(D15,TVA!A:B,2,0)*E15+E15),\"\")","v":""},"",null,null,null,null,null,null,null,"",{"$f":"IF(A15=\"\",\"\",VLOOKUP(D15,TVA!A:B,2,0)*E15*B15)","v":""}]
["","",{"$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,null,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,null,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,null,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,null,null,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":6000}]
[{"$f":"UPPER(#REF!)","v":{"$error":"#REF!"}},null,null,"TVA",null,null,{"$f":"IFERROR(SUM(P10:P19),\"\")","v":""}]
[{"$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":""}]
[{"$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":2,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Ref","Designation","Code TVA","Prix HT","STOCK ACTUEL","Colonne1","Colonne2","STOCK INITIALE"]
["A001","LAIT",1,2000,50,null,null,50]
["A002","TOMATE",2,3000,50,null,null,50]
["A003","RIZ",1,1600,50,null,null,50]
["A004","POISSON",1,10000,50,null,null,50]
["A005","ORANGE",2,1500,50,null,null,50]
["A006","Oignon",2,6000,50,null,null,50]
["A007","RAMA",1,1000,50,null,null,50]
["A008","MARGARINE",1,2000,50,null,null,50]
["A009","SOJA",1,3000,50,null,null,50]
["A010","FARINE",1,2500,50,null,null,50]
["A011","BEURE",1,750,50,null,null,50]
["A012","FARINE",1,1200,50,null,null,50]
["A013","LEGUMES",1,1650,50,null,null,50]
["A014","PAINS",1,2100,50,null,null,50]
["A015","SUCRE",1,2550,50,null,null,50]
["A016","BEIGNETS",1,3000,50,null,null,50]
["A017","MANIOC",1,3450,50,null,null,50]
["A018","FRETIN",1,3900,50,null,null,50]
["A019","POMME",1,4350,50,null,null,50]
["A020","IGNAMES",1,4800,50,null,null,50]
["A021","CHOUX",null,2000,50,null,null,50]

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