{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Kassabon","Productenlijst"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":0,"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":"Kassabon","index":0,"n_rows":30,"n_cols":6,"rows_kept":30,"cut":false,"hidden":false,"merged":[[7,4,7,5],[0,1,0,5],[1,1,1,5],[3,0,3,4],[4,0,4,4],[6,1,6,4],[24,2,24,4],[25,0,25,2],[25,3,25,4],[26,0,26,1],[26,3,26,4]]}
[]
[]
[]
[]
[]
[]
[]
["Bonnr.",206,null,null,{"$f":"TODAY()","v":"2022-04-25"}]
[]
[]
["Nr","Naam",null,"Prijs","Aantal","Totaal"]
[null,{"$f":"IF(A12,VLOOKUP(A12,[1]Productenlijst!C4:F2193,2,FALSE),\"\")","v":""},null,{"$f":"IF(A12,VLOOKUP(A12,[1]Productenlijst!G2:H2193,2,FALSE),\"\")","v":""},null,{"$f":"IF(A12,D12*E12,\"\")","v":""}]
[null,{"$f":"IF(A13,VLOOKUP(A13,[1]Productenlijst!C4:F2193,2,FALSE),\"\")","v":""},null,{"$f":"IF(A13,VLOOKUP(A13,[1]Productenlijst!G3:H2193,2,FALSE),\"\")","v":""},null,""]
[null,{"$f":"IF(A14,VLOOKUP(A14,[1]Productenlijst!C4:F2193,2,FALSE),\"\")","v":""},null,{"$f":"IF(A14,VLOOKUP(A14,[1]Productenlijst!G4:H2193,2,FALSE),\"\")","v":""},null,""]
[null,{"$f":"IF(A15,VLOOKUP(A15,[1]Productenlijst!C4:F2193,2,FALSE),\"\")","v":""},null,{"$f":"IF(A15,VLOOKUP(A15,[1]Productenlijst!G4:H2193,2,FALSE),\"\")","v":""},null,""]
[null,{"$f":"IF(A16,VLOOKUP(A16,[1]Productenlijst!C4:F2193,2,FALSE),\"\")","v":""},null,{"$f":"IF(A16,VLOOKUP(A16,[1]Productenlijst!G4:H2193,2,FALSE),\"\")","v":""},null,""]
[null,{"$f":"IF(A17,VLOOKUP(A17,[1]Productenlijst!C4:F2193,2,FALSE),\"\")","v":""},null,{"$f":"IF(A17,VLOOKUP(A17,[1]Productenlijst!G4:H2193,2,FALSE),\"\")","v":""},null,""]
[null,{"$f":"IF(A18,VLOOKUP(A18,[1]Productenlijst!C4:F2193,2,FALSE),\"\")","v":""},null,{"$f":"IF(A18,VLOOKUP(A18,[1]Productenlijst!G4:H2193,2,FALSE),\"\")","v":""},null,""]
[null,{"$f":"IF(A19,VLOOKUP(A19,[1]Productenlijst!C4:F2193,2,FALSE),\"\")","v":""},null,{"$f":"IF(A19,VLOOKUP(A19,[1]Productenlijst!G4:H2193,2,FALSE),\"\")","v":""},null,""]
[null,{"$f":"IF(A20,VLOOKUP(A20,[1]Productenlijst!C4:F2193,2,FALSE),\"\")","v":""},null,{"$f":"IF(A20,VLOOKUP(A20,[1]Productenlijst!G4:H2193,2,FALSE),\"\")","v":""},null,""]
[null,{"$f":"IF(A21,VLOOKUP(A21,[1]Productenlijst!C4:F2193,2,FALSE),\"\")","v":""},null,{"$f":"IF(A21,VLOOKUP(A21,[1]Productenlijst!G4:H2193,2,FALSE),\"\")","v":""},null,""]
["Betaal gemakkelijk met payconiq of bancontact"]
[null,null,null,null,"Bedrag",{"$f":"SUMIF(F12:F21,\">0\",F12:F21)","v":0}]
[null,null,null,null,"Korting",{"$f":"SUMIF(F12:F21,\"<0\",F12:F21)","v":0}]
[null,null,"Te betalen bedrag",null,null,{"$f":"F23+F24","v":0}]
[]
[]
[]
["Er worden geen goederen terug genomen"]
["Bedankt voor je bestelling"]

{"sheet":"Productenlijst","index":1,"n_rows":20,"n_cols":15,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
["Producten"]
[null,"Nummer","Naam",null,"Prijs","Nummer","Prijs","Start voorraad","Verkoop","verkocht goederen","Voorraad","Inkoopprijs","Verkooprijs","Kostprijs","Winst"]
[null,1000000000108,"Mand strijk",null,10,1000000000108,10]
[null,1141121142015,"Alaska 4201",null,3.9,1141121142015,3.9,10,{"$f":"SUMIF(Kassabon!$A$12:$A$21,B5,Kassabon!$E$12:$E$21)","v":0},{"$f":"SUBTOTAL(9,I5)","v":0},{"$f":"H5-I5","v":10},2,{"$f":"G5*J5","v":0},{"$f":"L5*H5","v":20},{"$f":"M5-N5","v":-20}]
[null,1141121142084,"Alaska 4208",null,3.9,1141121142084,3.9,10,{"$f":"SUMIF(Kassabon!A13:A22,B6,Kassabon!E13:E22)","v":0},{"$f":"+I6","v":0},{"$f":"H6-I6","v":10},2,{"$f":"G6*J6","v":0},{"$f":"L6*H6","v":20},{"$f":"M6-N6","v":-20}]
[null,1141121142107,"Alaska 4210",null,3.9,1141121142107,3.9]
[null,1141121142235,"Alaska 4222",null,3.9,1141121142220,3.9]
[null,1141121142299,"Alaska 4229",null,3.9,1141121142299,3.9]
[null,1141121142329,"Alaska 4232",null,3.9,1141121142329,3.9]
[null,1141121142367,"Alaska 4236",null,3.9,1141121142367,3.9]
[null,1141121142411,"Alaska 4241",null,null,1141121142411,3.9]
[null,1141121142435,"Alaska 4243",null,null,1141121142435,3.9]
[null,1141121142497,"Alaska 4249",null,null,1141121142497,3.9]
[null,1141121142503,"Alaska 4250",null,null,1141121142503,3.9]
[null,1141121142565,"Alaska 4256",null,null,1141121142565,3.9]
[null,1141121142589,"Alaska 4258",null,null,1141121142589,3.9]
[null,1141121142596,"Alaska 4259",null,null,1141121142596,3.9]
[null,1141121142602,"Alaska 4260",null,null,114112142602,3.9]
[null,1141121142794,"Alaska 4279",null,null,1141121142794,3.9]