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

{"sheet":"BETALINGSOVERZICHT","index":0,"n_rows":27,"n_cols":8,"rows_kept":27,"merged":[[1,2,1,3],[1,6,1,7],[2,2,2,3],[2,6,2,7],[3,2,3,3],[3,6,3,7],[5,2,5,3],[5,6,5,7],[6,2,6,3],[6,6,6,7],[7,2,7,3],[7,6,7,7],[8,6,8,7],[9,6,9,7]]}
[null,"BEDRIJFSNAAM"]
[null,"Adres",{"$nulls":3},"Telefoon:"]
[null,"Adres 2",{"$nulls":3},"Fax:"]
[null,"Postcode en plaats",{"$nulls":3},"E-mail:"]
[null,"OVERZICHT"]
[null,"Overzichtsnummer:",null,null,"Factuur voor:","Naam"]
[null,"Datum:",{"$nulls":3},"Bedrijfsnaam"]
[null,"Klantnummer:",{"$nulls":3},"Adres"]
[{"$nulls":5},"Adres 2"]
[{"$nulls":5},"Postcode en plaats"]
[]
[null,"DATUM","TYPE","FACTUURNR.","OMSCHRIJVING","BEDRAG","BETALING","SALDO"]
[null,{"$f":"TODAY()","v":"2022-08-10"},"Verkoop",123,"Producten",{"v":200,"d":"€ 200.00"},{"v":100,"d":"€ 100.00"},{"$f":"IF(Gegevens[[#This Row],[BEDRAG]]>0,Gegevens[[#This Row],[BEDRAG]]-Gegevens[[#This Row],[BETALING]],\"\")","v":{"v":100,"d":"€ 100.00"}}]
[{"$nulls":7},{"$f":"IF(Gegevens[[#This Row],[BEDRAG]]>0,Gegevens[[#This Row],[BEDRAG]]-Gegevens[[#This Row],[BETALING]],\"\")","v":""}]
[{"$nulls":7},{"$f":"IF(Gegevens[[#This Row],[BEDRAG]]>0,Gegevens[[#This Row],[BEDRAG]]-Gegevens[[#This Row],[BETALING]],\"\")","v":""}]
[{"$nulls":7},{"$f":"IF(Gegevens[[#This Row],[BEDRAG]]>0,Gegevens[[#This Row],[BEDRAG]]-Gegevens[[#This Row],[BETALING]],\"\")","v":""}]
[{"$nulls":7},{"$f":"IF(Gegevens[[#This Row],[BEDRAG]]>0,Gegevens[[#This Row],[BEDRAG]]-Gegevens[[#This Row],[BETALING]],\"\")","v":""}]
[{"$nulls":6},"TOTAAL",{"$f":"SUBTOTAL(109,Gegevens[SALDO])","v":{"v":100,"d":"€ 100.00"}}]
[null,"Herinnering: Vermeld het overzichtsnummer op uw cheque."]
[null,"Voorwaarden: saldo verschuldigd binnen 30 dagen."]
[null,"OVERMAKING"]
[null,"Naam klant:"]
[null,"Klantnummer:"]
[null,"Overzichtsnummer:"]
[null,"Datum:"]
[null,"Verschuldigd bedrag:",{"$f":"Gegevens[[#Totals],[SALDO]]","v":{"v":100,"d":"€ 100.00"}}]
[null,"Bijgesloten bedrag:"]