{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Aankoopbon"],"read":"whole","date_system":"1900"}

{"sheet":"Aankoopbon","index":0,"n_rows":29,"n_cols":7,"rows_kept":29,"merged":[[0,1,1,3],[0,5,1,6],[8,1,8,2],[9,1,9,2],[25,1,25,3],[25,4,25,5],[26,4,26,5],[27,4,27,5],[28,4,28,5],[33,1,33,3]]}
[null,"MODERN DESIGN CO.",{"$nulls":3},"AANKOOPBON"]
[]
[null,"ELEGANTE OPLOSSINGEN VOOR DE MODERNE ARTIEST"]
[null,"FACTUURADRES",null,"FACTUURNR.","DATUM"]
[null,"Sarah Teinema",null,"XYZ123","01-01-XX"]
[null,"BEDRIJF",null,"ADRES","TELEFOON"]
[null,"Create & Co.",null,"321 Sycamore","(415) 555-0123"]
[{"$nulls":3},"Albany, NY 12345","(415) 555-0124"]
[null,"BETALINGSWIJZE",null,"CHEQUENR.","TAAK"]
[null,"Overschrijving",null,987654,"Studio-opname ontwerpen"]
[]
[null,"HOEVEELHEID","ITEMNUMMER.","BESCHRIJVING","EENHEIDSPRIJS","KORTING","REGELTOTAAL"]
[null,3,"N.v.t.","Fotosessie (in uren)",{"v":100,"d":"€ 100.00"},{"v":0.1,"d":"10%"},{"$f":"IFERROR(IF(OR(Table_SalesReceiptDetails[[#This Row],[HOEVEELHEID]]=\"\",Table_SalesReceiptDetails[[#This Row],[EENHEIDSPRIJS]]=\"\"),\"\",Table_SalesReceiptDetails[[#This Row],[HOEVEELHEID]]*(1-Table_SalesReceiptDetails[[#This Row],[KORTING]])*Table_SalesReceiptDetails[[#This Row],[EENHEIDSPRIJS]]),\"\")","v":{"v":270,"d":"€ 270.00"}}]
[null,1,100,"USB-stick met foto's",{"v":45,"d":"€ 45.00"},null,{"$f":"IFERROR(IF(OR(Table_SalesReceiptDetails[[#This Row],[HOEVEELHEID]]=\"\",Table_SalesReceiptDetails[[#This Row],[EENHEIDSPRIJS]]=\"\"),\"\",Table_SalesReceiptDetails[[#This Row],[HOEVEELHEID]]*(1-Table_SalesReceiptDetails[[#This Row],[KORTING]])*Table_SalesReceiptDetails[[#This Row],[EENHEIDSPRIJS]]),\"\")","v":{"v":45,"d":"€ 45.00"}}]
[null,2.5,"N.v.t.","Bewerken (in uren)",{"v":35,"d":"€ 35.00"},null,{"$f":"IFERROR(IF(OR(Table_SalesReceiptDetails[[#This Row],[HOEVEELHEID]]=\"\",Table_SalesReceiptDetails[[#This Row],[EENHEIDSPRIJS]]=\"\"),\"\",Table_SalesReceiptDetails[[#This Row],[HOEVEELHEID]]*(1-Table_SalesReceiptDetails[[#This Row],[KORTING]])*Table_SalesReceiptDetails[[#This Row],[EENHEIDSPRIJS]]),\"\")","v":{"v":87.5,"d":"€ 87.50"}}]
[{"$nulls":6},{"$f":"IFERROR(IF(OR(Table_SalesReceiptDetails[[#This Row],[HOEVEELHEID]]=\"\",Table_SalesReceiptDetails[[#This Row],[EENHEIDSPRIJS]]=\"\"),\"\",Table_SalesReceiptDetails[[#This Row],[HOEVEELHEID]]*(1-Table_SalesReceiptDetails[[#This Row],[KORTING]])*Table_SalesReceiptDetails[[#This Row],[EENHEIDSPRIJS]]),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(OR(Table_SalesReceiptDetails[[#This Row],[HOEVEELHEID]]=\"\",Table_SalesReceiptDetails[[#This Row],[EENHEIDSPRIJS]]=\"\"),\"\",Table_SalesReceiptDetails[[#This Row],[HOEVEELHEID]]*(1-Table_SalesReceiptDetails[[#This Row],[KORTING]])*Table_SalesReceiptDetails[[#This Row],[EENHEIDSPRIJS]]),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(OR(Table_SalesReceiptDetails[[#This Row],[HOEVEELHEID]]=\"\",Table_SalesReceiptDetails[[#This Row],[EENHEIDSPRIJS]]=\"\"),\"\",Table_SalesReceiptDetails[[#This Row],[HOEVEELHEID]]*(1-Table_SalesReceiptDetails[[#This Row],[KORTING]])*Table_SalesReceiptDetails[[#This Row],[EENHEIDSPRIJS]]),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(OR(Table_SalesReceiptDetails[[#This Row],[HOEVEELHEID]]=\"\",Table_SalesReceiptDetails[[#This Row],[EENHEIDSPRIJS]]=\"\"),\"\",Table_SalesReceiptDetails[[#This Row],[HOEVEELHEID]]*(1-Table_SalesReceiptDetails[[#This Row],[KORTING]])*Table_SalesReceiptDetails[[#This Row],[EENHEIDSPRIJS]]),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(OR(Table_SalesReceiptDetails[[#This Row],[HOEVEELHEID]]=\"\",Table_SalesReceiptDetails[[#This Row],[EENHEIDSPRIJS]]=\"\"),\"\",Table_SalesReceiptDetails[[#This Row],[HOEVEELHEID]]*(1-Table_SalesReceiptDetails[[#This Row],[KORTING]])*Table_SalesReceiptDetails[[#This Row],[EENHEIDSPRIJS]]),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(OR(Table_SalesReceiptDetails[[#This Row],[HOEVEELHEID]]=\"\",Table_SalesReceiptDetails[[#This Row],[EENHEIDSPRIJS]]=\"\"),\"\",Table_SalesReceiptDetails[[#This Row],[HOEVEELHEID]]*(1-Table_SalesReceiptDetails[[#This Row],[KORTING]])*Table_SalesReceiptDetails[[#This Row],[EENHEIDSPRIJS]]),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(OR(Table_SalesReceiptDetails[[#This Row],[HOEVEELHEID]]=\"\",Table_SalesReceiptDetails[[#This Row],[EENHEIDSPRIJS]]=\"\"),\"\",Table_SalesReceiptDetails[[#This Row],[HOEVEELHEID]]*(1-Table_SalesReceiptDetails[[#This Row],[KORTING]])*Table_SalesReceiptDetails[[#This Row],[EENHEIDSPRIJS]]),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(OR(Table_SalesReceiptDetails[[#This Row],[HOEVEELHEID]]=\"\",Table_SalesReceiptDetails[[#This Row],[EENHEIDSPRIJS]]=\"\"),\"\",Table_SalesReceiptDetails[[#This Row],[HOEVEELHEID]]*(1-Table_SalesReceiptDetails[[#This Row],[KORTING]])*Table_SalesReceiptDetails[[#This Row],[EENHEIDSPRIJS]]),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(OR(Table_SalesReceiptDetails[[#This Row],[HOEVEELHEID]]=\"\",Table_SalesReceiptDetails[[#This Row],[EENHEIDSPRIJS]]=\"\"),\"\",Table_SalesReceiptDetails[[#This Row],[HOEVEELHEID]]*(1-Table_SalesReceiptDetails[[#This Row],[KORTING]])*Table_SalesReceiptDetails[[#This Row],[EENHEIDSPRIJS]]),\"\")","v":""}]
[]
[null,"ALS U VRAGEN HEBT OVER DEZE FACTUUR, GEBRUIKT U DE VOLGENDE CONTACTGEGEVENS:",null,null,"TOTALE KORTING"]
[null,"Nathan Rigby | (123) 456-7890 | nathan@example.com",null,null,"SUBTOTAAL",null,{"$f":"SUM(Table_SalesReceiptDetails[REGELTOTAAL])","v":{"v":402.5,"d":"€ 402.50"}}]
[{"$nulls":4},"BTW",null,{"v":0.06,"d":"6.00%"}]
[null,"BEDANKT VOOR UW BESTELLING.",null,null,"TOTAAL",null,{"$f":"(G27-(G27*G26))*(1+G28)","v":{"v":426.65000000000003,"d":"€ 426.65"}}]