{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Actual outstanding","Historic outstanding","Invoice details","Cash forecast","Background","History details"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":6,"comments":0,"pivot_tables":1},"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":"Actual outstanding","index":0,"n_rows":9,"n_cols":25,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Creditors as per today"]
[]
[]
[]
[null,"Invoice","Account","Name","Posting date","Orginal amount","Currency","Description","Outstanding","Rate","Localamount","Journal","Seqnr","Pay date","Contact","Phone","Email","Supplier","Days old","Days overdue","Months old","Months overdue","Accumulating amount","Earliest paydate","Earliest payweek"]
[]
[null,"Total",null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(109,ActualDebtors[Localamount])","v":0}]

{"sheet":"Historic outstanding","index":1,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Creditors",null,"as per end",201302]
[]
[]
[]
[null,"Invoice","Account","Name","Outstanding","Currency","Localamount","Invoicedate"]
[]
[null,"Total",null,null,null,null,{"$f":"SUBTOTAL(109,HistoricDebtors[Localamount])","v":0}]

{"sheet":"Invoice details","index":2,"n_rows":26,"n_cols":60,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Invoice","  9810","LANSIGT"]
[]
[null,"Date",{"$f":"Invoice_data[Date]","v":"00:00:00"}]
[null,"Supplier  ",{"$f":"$D$3","v":"LANSIGT"}]
[null,"Name",{"$f":"Invoice_data[Name]","v":0}]
[null,"Address",{"$f":"Invoice_data[Address 1]","v":0}]
[null,null,{"$f":"Invoice_data[Address 2]","v":0}]
[null,null,{"$f":"Invoice_data[Address 2]","v":0}]
[null,"Country",{"$f":"Invoice_data[Country]","v":0}]
[null,"Despatched from",{"$f":"Invoice_data[Despatch Country]","v":0}]
[null,"Bank account"]
[null,"Supplier ref.",{"$f":"Invoice_data[Supplier reference]","v":0}]
[null,"Pay date",{"$f":"Invoice_data[Pay date]","v":"00:00:00"}]
[null,"Approved",{"$f":"Invoice_data[Approved]","v":0}]
[null,"Booking period",{"$f":"Invoice_data[Period]","v":0}]
[null,"Currency",{"$f":"Invoice_data[Currency]","v":0}]
[]
[]
[null,null,"Invoice total",{"$f":"0-Invoice_data[BUAMOUNT]/POWER(10,Invoice_data[D])","v":0}]
[null,null,"VAT",{"$f":"Invoice_data[BUVAT]/POWER(10,Invoice_data[D])","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C$18","v":0}]
[null,"Account","Account name","Currency amount","Local amount","Price difference","Description","Project","Reference","Department","Quantity","Unit","Part","Part description","Currency price","Local price","Costprice","Pricedifference","Period 1","Period 2","Period 3","Period 4","Period 5","Period 6","Period 7","Period 8","Period 9","Period 10","Period 11","Period 12","Period 14","BLAMOUNT","BLPURCHASE","BLPRICDIFF","BLAMOUNT1","BLAMOUNT2","BLAMOUNT3","BLAMOUNT4","BLAMOUNT5","BLAMOUNT6","BLAMOUNT7","BLAMOUNT8","BLAMOUNT9","BLAMOUNT10","BLAMOUNT11","BLAMOUNT12","BLAMOUNT13","BLQUANT","BLUNIT","BLPRICDIFF2","GHQUANT","GHAMOUNTIN","GHVALUTAIN","GHAMOUNTPU","GHVALUTAPU","PACOMPUNIT","BLSEQ","Check","BLAMOUNT14","BLAMOUNT15"]
[]
[null,null,null,{"$f":"SUBTOTAL(109,Invoice_details[Currency amount])","v":0},{"$f":"SUBTOTAL(109,Invoice_details[Local amount])","v":0},{"$f":"SUBTOTAL(109,Invoice_details[Price difference])","v":0},null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(109,Invoice_details[Currency price])","v":0},{"$f":"SUBTOTAL(109,Invoice_details[Local price])","v":0},{"$f":"SUBTOTAL(109,Invoice_details[Costprice])","v":0},{"$f":"SUBTOTAL(109,Invoice_details[Pricedifference])","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(103,Invoice_details[BLAMOUNT15])","v":0}]

{"sheet":"Cash forecast","index":3,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Cash forecast"]
[]
[]
[null,"Week","Pay obligation"]
[null,"(blank)"]
[null,"Total"]

{"sheet":"Background","index":4,"n_rows":8,"n_cols":28,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"Invoice","Supplier number","Name","Name2","Address 1","Address 2","Country","Despatch Country","Date","Pay date","Supplier reference","Period","Approved","BUVAT","BUAMOUNT","Currency","D","Company",null,null,null,null,"CONAME","COVALUTA","VANUMBER","VADECIMALS","COBKCOMP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"StoreEleven","EUR","EUR",2,"100"]

{"sheet":"History details","index":5,"n_rows":8,"n_cols":15,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Creditors history details"]
[]
[]
[null,"Journal","Seq","Invoice","Description","Postingdate","Period","Currency","Amount","Supplier","Outstanding","Account","Name","Invoicedate","Status"]
[]
[null,"Totaal",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(103,Tabel_Query_van_seralive[Status])","v":0}]