{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Select a supplier","Supplier data","Open amounts","Datasheet","Invoice","Purchase analysis","Invoice History","Outstanding orders"],"not_rendered":{"charts":1,"images":2,"macros":1,"external_links":0,"defined_names":16,"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":"Select a supplier","index":0,"n_rows":8,"n_cols":37,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"300300","Emco Wheaton UK Ltd."]
[]
[]
[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,"Number","Name","Name 2","Search code","Address","City","Postal address","Postal city","Country","Country code","Phone","Website","Email address","Fax","Contact","Language","Accounting dpt","Line code","Line description","Vat type","Vat number","Mail code","Selection code","Delivery terms","Delivery description","Payterms","Info 1","Info 2","Info 3","Info 4","Info 5","Info 6","Info 7","Info 8","Info 9","Info 10"]
[null,"2000","SERA Business design BV"," ","SERABUSINE","Raadhuisstraat 211","2406 AC  Alphen aan den Rijn","Raadhuisstraat 211","2406 AC  Alphen aan den Rijn","NEDERLAND","0031","0172 473430","www.serasoft.com","joost@serasoft.com"," ","Joost Schravendeel","NED","Afd. administratie","0000","Algemeen","IN"," ","0000+","0000+","NEDFRH","Franco huis",15," "," "," "," "," "," "," "," "," "," "]

{"sheet":"Supplier data","index":1,"n_rows":45,"n_cols":4,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Supplier page"]
[]
[]
[]
[]
[null,"NAME",{"$f":"SERA3250_Supplier_record[SUNAME]","v":0}]
[null,"Name 2",{"$f":"SERA3250_Supplier_record[SUNAME2]","v":0}]
[null,"Number",{"$f":"SERA3250_Supplier_record[SUNUMBER]","v":0}]
[null,"Head office",{"$f":"SERA3250_Supplier_record[SUHEAD]","v":0}]
[null,"Street ",{"$f":"SERA3250_Supplier_record[SUADRESS1]","v":0}]
[null,"City",{"$f":"SERA3250_Supplier_record[SUADRESS2]","v":0}]
[null,"Postal address",{"$f":"SERA3250_Supplier_record[SUADRESS3]","v":0}]
[null,"City",{"$f":"SERA3250_Supplier_record[SUADRESS4]","v":0}]
[null,"Country",{"$f":"SERA3250_Supplier_record[SUCOUNTRY]","v":0},{"$f":"SERA3250_Supplier_record[SUCOUNTRYC]","v":0}]
[null,"Phone",{"$f":"SERA3250_Supplier_record[SUPHONE]","v":0}]
[null,"Web site",{"$f":"HYPERLINK(CONCATENATE(IFERROR(FIND(\"://\",SERA3250_Supplier_record[SUWEB]),\"http://\"),SERA3250_Supplier_record[SUWEB]))","v":"http://"}]
[null,"Email",{"$f":"HYPERLINK(CONCATENATE(\"mailto:\",SERA3250_Supplier_record[SUEMAIL]))","v":"mailto:"}]
[null,"Fax",{"$f":"SERA3250_Supplier_record[SUFAX]","v":0}]
[null,"Currency",{"$f":"SERA3250_Supplier_record[SUVAL]","v":0}]
[null,"Search code",{"$f":"SERA3250_Supplier_record[SUABC]","v":0}]
[null,"Contact ",{"$f":"SERA3250_Supplier_record[SUCONTACT]","v":0}]
[null,"Language",{"$f":"SERA3250_Supplier_record[SULANGUAGE]","v":0}]
[null,"Administration",{"$f":"SERA3250_Supplier_record[SUADMIN]","v":0}]
[null,"Line code",{"$f":"SERA3250_Supplier_record[SUBRANCH]","v":0},{"$f":"SERA3250_Supplier_record[BRDESCR]","v":0}]
[null,"Delivery terms",{"$f":"SERA3250_Supplier_record[SUDELTERMS]","v":0}]
[null,"Shipplan",{"$f":"SERA3250_Supplier_record[SUSHIPPLAN]","v":0}]
[null,"Vat type ",{"$f":"SERA3250_Supplier_record[SUVAT]","v":0}]
[null,"Vat number ",{"$f":"SERA3250_Supplier_record[SUVATNR]","v":0}]
[null,"Selection code ",{"$f":"SERA3250_Supplier_record[SUSELCODE]","v":0}]
[null,"Mail code",{"$f":"SERA3250_Supplier_record[SUMAILCODE]","v":0}]
[null,"Bank account",{"$f":"SERA3250_Supplier_record[SUIBAN]","v":0},{"$f":"SERA3250_Supplier_record[SUBANKACC]","v":0}]
[null,"Bank name ",{"$f":"SERA3250_Supplier_record[SUBANKNAME]","v":0}]
[null,"Document directory",{"$f":"HYPERLINK(SERA3250_Supplier_record[SUDOCDIR])","v":""}]
[null,{"$f":"IF(Datasheet!$BO8=0,\"  \",Datasheet!$BO8)","v":"  "},{"$f":"SERA3250_Supplier_record[SUEXTRA01]","v":0}]
[null,{"$f":"IF(Datasheet!$BO9=0,\"  \",Datasheet!$BO9)","v":"  "},{"$f":"SERA3250_Supplier_record[SUEXTRA02]","v":0}]
[null,{"$f":"IF(Datasheet!$BO10=0,\"  \",Datasheet!$BO10)","v":"  "},{"$f":"SERA3250_Supplier_record[SUEXTRA03]","v":0}]
[null,{"$f":"IF(Datasheet!$BO11=0,\"  \",Datasheet!$BO11)","v":"  "},{"$f":"SERA3250_Supplier_record[SUEXTRA04]","v":0}]
[null,{"$f":"IF(Datasheet!$BO12=0,\"  \",Datasheet!$BO12)","v":"  "},{"$f":"SERA3250_Supplier_record[SUEXTRA05]","v":0}]
[null,{"$f":"IF(Datasheet!$BO13=0,\"  \",Datasheet!$BO13)","v":"  "},{"$f":"SERA3250_Supplier_record[SUEXTRA06]","v":0}]
[null,{"$f":"IF(Datasheet!$BO14=0,\"  \",Datasheet!$BO14)","v":"  "},{"$f":"SERA3250_Supplier_record[SUEXTRA07]","v":0}]
[null,{"$f":"IF(Datasheet!$BO15=0,\"  \",Datasheet!$BO15)","v":"  "},{"$f":"SERA3250_Supplier_record[SUEXTRA08]","v":0}]
[null,{"$f":"IF(Datasheet!$BO16=0,\"  \",Datasheet!$BO16)","v":"  "},{"$f":"SERA3250_Supplier_record[SUEXTRA09]","v":0}]
[null,{"$f":"IF(Datasheet!$BO17=0,\"  \",Datasheet!$BO17)","v":"  "},{"$f":"SERA3250_Supplier_record[SUEXTRA10]","v":0}]

{"sheet":"Open amounts","index":2,"n_rows":9,"n_cols":14,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Open amounts",null,{"$f":"SERA3250_Supplier_record[SUNUMBER]","v":0},{"$f":"SERA3250_Supplier_record[SUNAME]","v":0}]
[]
[]
[]
[null,"Invoice","Description","Curramount","Currency","Localamount","Posting date","Journal","Seq.nr","Order","Pay date","Days ","Allowed","Overdue"]
[]
[null,null,null,{"$f":"SUBTOTAL(109,Open_amounts[Curramount])","v":0},null,{"$f":"SUBTOTAL(109,Open_amounts[Localamount])","v":0}]

{"sheet":"Datasheet","index":3,"n_rows":8,"n_cols":161,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"Data sheet",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,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,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,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,"100330"]
[]
[]
[]
[null,"BRDESCR","SUNUMBER","SUHEAD","SUNAME","SUNAME2","SUCOUNTRY","SUCOUNTRYC","SUADRESS1","SUADRESS2","SUADRESS3","SUADRESS4","SUPHONE","SUWEB","SUEMAIL","SUTELEX","SUFAX","SUVAL","SUABC","SUCONTACT","SULANGUAGE","SUADMIN","SUBRANCH","SUDELTERMS","SUSHIPPLAN","SUDOCUNR","SUVAT","SUVATNR","SUSELCODE","SUMAILCODE","SUBANKACC","SUBANKNAME","SUDOCDIR","SUEXTRA01","SUEXTRA02","SUEXTRA03","SUEXTRA04","SUEXTRA05","SUEXTRA06","SUEXTRA07","SUEXTRA08","SUEXTRA09","SUEXTRA10","SUIBAN","VADECIMALS",null,null,null,null,null,"CONAME","COHOMEADR1","COHOMEADR2","COHOMEADR3","COCOUNTRY","COVALUTA","VANUMBER","VADESCR","VADECIMALS","COBKCOMP",null,null,null,null,"EXFILE","EXITEM","EXDESCR",null,null,null,null,null,"Invoice","Description","Period","Supplier","Supplier name","Country","Currency","BUVALUTA","BUAMOUNT","BUVAT","Date","Pay date","Year","VADECIMALS"]
[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,null,null,null,null,null,null,null,null,null,"StoreEleven","Juilanastraat 34","2045 CH  Alphen aan den Rijn"," ","NEDERLAND","EUR","EUR","Euro",2,"100"]

{"sheet":"Invoice","index":4,"n_rows":21,"n_cols":59,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Invoice",null,null,"Supplier",{"$f":"SERA3250_Supplier_record[SUNUMBER]","v":0}]
[]
[null,"Supplier",{"$f":"SERA3250_Supplier_record[SUNAME]","v":0},null,"Postal address",{"$f":"SERA3250_Supplier_record[SUADRESS3]","v":0}]
[null,null,{"$f":"SERA3250_Supplier_record[SUNAME2]","v":0},null,null,{"$f":"SERA3250_Supplier_record[SUADRESS4]","v":0}]
[null,null,{"$f":"SERA3250_Supplier_record[SUADRESS1]","v":0},null,null,{"$f":"SERA3250_Supplier_record[SUPHONE]","v":0}]
[null,null,{"$f":"SERA3250_Supplier_record[SUADRESS2]","v":0},null,null,{"$f":"SERA3250_Supplier_record[SUEMAIL]","v":0}]
[null,null,{"$f":"SERA3250_Supplier_record[SUCOUNTRY]","v":0},null,null,{"$f":"SERA3250_Supplier_record[SUWEB]","v":0}]
[null,null,{"$f":"SERA3250_Supplier_record[SUCONTACT]","v":0},null,null,{"$f":"SERA3250_Supplier_record[SUADMIN]","v":0}]
[null,"Head office",{"$f":"SERA3250_Supplier_record[SUNAME]","v":0},null,"Bank account",{"$f":"CONCATENATE(SERA3250_Supplier_record[SUIBAN],\" -  \",SERA3250_Supplier_record[SUBANKACC],\" - \",SERA3250_Supplier_record[SUBANKNAME])","v":" -   - "}]
[]
[null,"Info","Date",{"$f":"IF($C$3>\"  \",SERA3250_Invoice_record[Date],\"  \")","v":"  "},null,"Currency",{"$f":"IF($C$3>\"  \",SERA3250_Invoice_record[BUVALUTA],\"  \")","v":"  "}]
[null,null,"Paydate",{"$f":"IF($C$3>\"  \",SERA3250_Invoice_record[Pay date],\"  \")","v":"  "},null,"Decimals",{"$f":"SERA3250_Invoice_record[VADECIMALS]","v":0}]
[null,null,"Reference",{"$f":"IF($C$3>\"  \",SERA3250_Invoice_record[Description],\"  \")","v":"  "},null,"Total",{"$f":"IF($C$3>\"  \",0-SERA3250_Invoice_record[BUAMOUNT]/POWER(10,$G$14),\" \")","v":" "}]
[null,null,"Company",{"$f":"SERA3250_Company_record[COBKCOMP]","v":"100"},null,"Vat",{"$f":"IF($C$3>\"  \",SERA3250_Invoice_record[BUVAT]/POWER(10,$G$14),\" \")","v":" "}]
[null,null,"Period",{"$f":"IF($C$3>\"  \",SERA3250_Invoice_record[Period],\"  \")","v":"  "}]
[]
[null,"Account","Account name","Description","Purchase","Currency","Goods amount","Price difference","Invoice total","Quantity","Unit","Part","Part description","Currency price","Local price","Cost price","Pricedifference","Project","Department","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","BLVTAMOUNT","BLINVOICE","PACOMPUNIT"]
[]
[null,null,null,null,{"$f":"SUBTOTAL(109,Invoice[Purchase])","v":0},null,{"$f":"SUBTOTAL(109,Invoice[Goods amount])","v":0},{"$f":"SUBTOTAL(109,Invoice[Price difference])","v":0},{"$f":"SUBTOTAL(109,Invoice[Invoice total])","v":0},{"$f":"SUBTOTAL(109,Invoice[Quantity])","v":0}]

{"sheet":"Purchase analysis","index":5,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Purchase analysis"]
[]
[]
[]
[null,null,"Columns"]
[null,null,"(blank)"]
[null,"Invoicetotal"]

{"sheet":"Invoice History","index":6,"n_rows":9,"n_cols":63,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Invoice history",null,{"$f":"SERA3250_Supplier_record[SUNUMBER]","v":0},{"$f":"SERA3250_Supplier_record[SUNAME]","v":"00:00:00"}]
[]
[]
[]
[null,"Invoice","Period","Supplier Reference","Date","Account","Account name","Description","Purchase","Currency","Goods amount","Price difference","Invoice total","Quantity","Unit","Part","Part description","Currency price","Local price","Cost price","Pricedifference","Project","Department","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","BLVTAMOUNT","PACOMPUNIT","Year","Pay date"]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(109,Invoice_History[Purchase])","v":0},null,{"$f":"SUBTOTAL(109,Invoice_History[Goods amount])","v":0},{"$f":"SUBTOTAL(109,Invoice_History[Price difference])","v":0},{"$f":"SUBTOTAL(109,Invoice_History[Invoice total])","v":0},{"$f":"SUBTOTAL(109,Invoice_History[Quantity])","v":0}]

{"sheet":"Outstanding orders","index":7,"n_rows":9,"n_cols":33,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Order details",null,{"$f":"SERA3250_Supplier_record[SUNUMBER]","v":0},{"$f":"SERA3250_Supplier_record[SUNAME]","v":0}]
[]
[]
[]
[null,"Too late","Order","Type","Quantity","Unit","Part","Description","Unit price","Currency","Local price","Total purchase","Del.date","Month","Group","Group description","Supplier part","Part description","Delivery","Payterms","Date","Country","Weight","Volume","Days ","PAGROUP","PAWEIGHT","PAVOLUME","D","PLTYPE","PLAMOUNT","PLVALUTA","PLAMOUNT2"]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(109,Order_details[Total purchase])","v":0}]