{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Offerte"],"not_rendered":{"images":1,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Offerte","index":0,"n_rows":26,"n_cols":6,"rows_kept":26,"merged":[[10,1,10,5]]}
[]
[null,"Bedrijfsadres",null,null,"Datum",{"$f":"TODAY()","v":"2019-03-28"}]
[null,"Adres, postcode, plaats",null,null,"Offertenummer",1234]
[null,"Telefoonnummer: Voer hier uw telefoonnummer in  Fax: Voer hier uw faxnummer in",null,null,"Klantnummer","ABC123"]
[null,"Offerte voor"]
[null,"Klantnaam",null,null,"Offerte geldig tot:",{"$f":"F2+30","v":"2019-04-27"}]
[null,"Bedrijfsnaam",null,null,"Opgesteld door:","Naam"]
[null,"Adres, postcode, plaats"]
[null,"Telefoonnummer, faxnummer"]
[null,"Opmerkingen of speciale instructies"]
[null,"Geen"]
[null,"Verkoper","Postbus Nummer","Verzenddatum","F.O.B.- punt","Voorwaarden"]
[{"$nulls":5},"Te betalen bij ontvangst"]
[]
[null,"Aantal","Omschrijving","Prijs per eenheid","Belastbaar?","Bedrag"]
[null,{"v":1234,"d":"1,234"},"Artikel 1",{"v":12.34,"d":"€ 12.34"},"Ja",{"$f":"IFERROR(IF(OR(SaleItems_Table[[#This Row],[Aantal]]=\"\",SaleItems_Table[[#This Row],[Prijs per eenheid]]=\"\"),\"\",SaleItems_Table[[#This Row],[Aantal]]*SaleItems_Table[[#This Row],[Prijs per eenheid]]),\"\")","v":{"v":15227.56,"d":"€ 15,227.56"}}]
[{"$nulls":5},{"$f":"IFERROR(IF(OR(SaleItems_Table[[#This Row],[Aantal]]=\"\",SaleItems_Table[[#This Row],[Prijs per eenheid]]=\"\"),\"\",SaleItems_Table[[#This Row],[Aantal]]*SaleItems_Table[[#This Row],[Prijs per eenheid]]),\"\")","v":""}]
[{"$nulls":5},{"$f":"IFERROR(IF(OR(SaleItems_Table[[#This Row],[Aantal]]=\"\",SaleItems_Table[[#This Row],[Prijs per eenheid]]=\"\"),\"\",SaleItems_Table[[#This Row],[Aantal]]*SaleItems_Table[[#This Row],[Prijs per eenheid]]),\"\")","v":""}]
[{"$nulls":5},{"$f":"IFERROR(IF(OR(SaleItems_Table[[#This Row],[Aantal]]=\"\",SaleItems_Table[[#This Row],[Prijs per eenheid]]=\"\"),\"\",SaleItems_Table[[#This Row],[Aantal]]*SaleItems_Table[[#This Row],[Prijs per eenheid]]),\"\")","v":""}]
[{"$nulls":5},{"$f":"IFERROR(IF(OR(SaleItems_Table[[#This Row],[Aantal]]=\"\",SaleItems_Table[[#This Row],[Prijs per eenheid]]=\"\"),\"\",SaleItems_Table[[#This Row],[Aantal]]*SaleItems_Table[[#This Row],[Prijs per eenheid]]),\"\")","v":""}]
[]
[{"$nulls":4},"Subtotaal",{"$f":"SUM(SaleItems_Table[Bedrag])","v":{"v":15227.56,"d":"€ 15,227.56"}}]
[null,"Als u vragen hebt over deze offerte, kunt u contact opnemen met: ",null,null,"Btw-tarief",{"v":0.086,"d":"8.60%"}]
[null,"Voer uw contactgegevens in",null,null,"Btw",{"$f":"IFERROR(Btw_tarief*SUMIF(SaleItems_Table[Belastbaar?],\"Ja\",SaleItems_Table[Bedrag]), \"\")","v":{"v":1309.5701599999998,"d":"€ 1,309.57"}}]
[{"$nulls":4},"Overig"]
[null,"Bedankt voor uw bestelling.",null,null,"TOTAAL",{"$f":"SUM(F22,F24,F25)","v":{"v":16537.13016,"d":"€ 16,537.13"}}]