{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Select a customer","Customer data","Open amounts","Datasheet","Invoice","Invoice History","Sales analysis","Outstanding orders"],"not_rendered":{"charts":1,"images":2,"macros":1,"external_links":0,"defined_names":15,"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 customer","index":0,"n_rows":7,"n_cols":42,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[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","Area","Area name","Line code","Line description","Vat type","Vat number","Mail code","Selection code","Delivery terms","Delivery description","Payterms","Confirm sales orders","Number of invoice prints","Price list type","Info 1","Info 2","Info 3","Info 4","Info 5","Info 6","Info 7","Info 8","Info 9","Info 10"]

{"sheet":"Customer data","index":1,"n_rows":56,"n_cols":4,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Customer page"]
[]
[]
[]
[]
[null,"NAME",{"$f":"Datasheet!$D$8","v":0}]
[null,"Name 2",{"$f":"Datasheet!$E$8","v":0}]
[null,"Number",{"$f":"Datasheet!$B$8","v":0}]
[null,"Head office",{"$f":"Datasheet!$C$8","v":0}]
[null,"Street ",{"$f":"Datasheet!$H$8","v":0}]
[null,"City",{"$f":"Datasheet!$I$8","v":0}]
[null,"Postal address",{"$f":"Datasheet!$J$8","v":0}]
[null,"City",{"$f":"Datasheet!$K$8","v":0}]
[null,"Country",{"$f":"Datasheet!$G$8","v":0},{"$f":"Datasheet!$F$8","v":0}]
[null,"Phone",{"$f":"Datasheet!$K$8","v":0}]
[null,"Web site",{"$f":"HYPERLINK(CONCATENATE(IFERROR(FIND(\"://\",Datasheet!$M$8),\"http://\"),Datasheet!$M$8))","v":"http://"}]
[null,"Email",{"$f":"HYPERLINK(CONCATENATE(\"mailto:\",Datasheet!$N$8))","v":"mailto:"}]
[null,"Fax",{"$f":"Datasheet!$P$8","v":0}]
[null,"Currency",{"$f":"Datasheet!$Q$8","v":0}]
[null,"Search code",{"$f":"Datasheet!$R$8","v":0}]
[null,"Contact ",{"$f":"Datasheet!$S$8","v":0}]
[null,"Language",{"$f":"Datasheet!$T$8","v":0}]
[null,"Pay terms",{"$f":"Datasheet!$U$8","v":0}]
[null,"Administration",{"$f":"Datasheet!$V$8","v":0}]
[null,"Line code",{"$f":"Datasheet!$W$8","v":0},{"$f":"Datasheet!BK$8","v":0}]
[null,"Area code",{"$f":"Datasheet!$X$8","v":0},{"$f":"Datasheet!BJ$8","v":0}]
[null,"Credit limit",{"$f":"Datasheet!$Y$8/POWER(10,Datasheet!$BZ$8)","v":0}]
[null,"Delivery type",{"$f":"Datasheet!$Z$8","v":0}]
[null,"Delivery terms",{"$f":"Datasheet!$AA$8","v":0}]
[null,"Shipplan",{"$f":"Datasheet!$AB$8","v":0}]
[null,"Invoice type ",{"$f":"Datasheet!$AC$8","v":0}]
[null,"Invoice quantity",{"$f":"Datasheet!$AD$8","v":0}]
[null,"Confirm orders ",{"$f":"Datasheet!$AE$8","v":0}]
[null,"Vat type ",{"$f":"Datasheet!$AH$8","v":0}]
[null,"Vat number ",{"$f":"Datasheet!$AI$8","v":0}]
[null,"Retail price type",{"$f":"Datasheet!$AJ$8","v":0}]
[null,"Selection code ",{"$f":"Datasheet!$AK$8","v":0}]
[null,"Mail code",{"$f":"Datasheet!$AL$8","v":0}]
[null,"Bank account",{"$f":"Datasheet!$AM$8","v":0}]
[null,"Bank name ",{"$f":"Datasheet!$AN$8","v":0}]
[null,"Bank name 2",{"$f":"Datasheet!$AO$8","v":0}]
[null,"Pay type ",{"$f":"Datasheet!$AR$8","v":0}]
[null,"Document directory",{"$f":"HYPERLINK(Datasheet!$AY$8)","v":""}]
[null,{"$f":"IF(Datasheet!$CH8=0,\"  \",Datasheet!$CH8)","v":"  "},{"$f":"Datasheet!$AZ$8","v":0}]
[null,{"$f":"IF(Datasheet!$CH9=0,\"  \",Datasheet!$CH9)","v":"  "},{"$f":"Datasheet!$BA$8","v":0}]
[null,{"$f":"IF(Datasheet!$CH10=0,\"  \",Datasheet!$CH10)","v":"  "},{"$f":"Datasheet!$BB$8","v":0}]
[null,{"$f":"IF(Datasheet!$CH11=0,\"  \",Datasheet!$CH11)","v":"  "},{"$f":"Datasheet!$BC$8","v":0}]
[null,{"$f":"IF(Datasheet!$CH12=0,\"  \",Datasheet!$CH12)","v":"  "},{"$f":"Datasheet!$BD$8","v":0}]
[null,{"$f":"IF(Datasheet!$CH13=0,\"  \",Datasheet!$CH13)","v":"  "},{"$f":"Datasheet!$BE$8","v":0}]
[null,{"$f":"IF(Datasheet!$CH14=0,\"  \",Datasheet!$CH14)","v":"  "},{"$f":"Datasheet!$BF$8","v":0}]
[null,{"$f":"IF(Datasheet!$CH15=0,\"  \",Datasheet!$CH15)","v":"  "},{"$f":"Datasheet!$BG$8","v":0}]
[null,{"$f":"IF(Datasheet!$CH16=0,\"  \",Datasheet!$CH16)","v":"  "},{"$f":"Datasheet!$BH$8","v":0}]
[null,{"$f":"IF(Datasheet!$CH17=0,\"  \",Datasheet!$CH17)","v":"  "}]
[null,null,{"$f":"Datasheet!$BI$8","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":"Datasheet!$C$8","v":0},{"$f":"Datasheet!$D$8","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":127,"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,"100330"]
[]
[]
[]
[null,"CUNUMBER","CUHEAD","CUNAME","CUNAME2","CUCOUNTRY","CUCOUNTRYC","CUADRESS1","CUADRESS2","CUADRESS3","CUADRESS4","CUPHONE","CUWEB","CUEMAIL","CUTELEX","CUFAX","CUVAL","CUABC","CUCONTACT","CULANGUAGE","CUPAYTERMS","CUADMIN","CUBRANCH","CUREP","CUCREDIT","CUDELTYPE","CUDELTERMS","CUSHIPPLAN","CUINVTYPE","CUINVQUANT","CUCONFIRM","CUACCTYPE","CUDOCUNR","CUVAT","CUVATNR","CURETAIL","CUSELCODE","CUMAILCODE","CUBANKACC","CUBANKNAME","CUBANKTOWN","CUPAYDELAY","CUMULTIORD","CUPAYTYPE","CUDAYOFM","CUOVERDUE","CUPAYSPLIT","CUDISCPERC","CUDISCDAYS","CUREGISTER","CUDOCDIR","CUEXTRA01","CUEXTRA02","CUEXTRA03","CUEXTRA04","CUEXTRA05","CUEXTRA06","CUEXTRA07","CUEXTRA08","CUEXTRA09","CUEXTRA10","REDESCR","BRDESCR",null,null,null,null,null,null,"CONAME","COHOMEADR1","COHOMEADR2","COHOMEADR3","COCOUNTRY","COVALUTA","VANUMBER","VADESCR","VADECIMALS",null,null,null,null,null,"EXFILE","EXITEM","EXDESCR",null,null,null,null,null,"IVNUMBER","IVCONTACT","IVTRANSPNR","IVPAYTYPE","IVPAYTERMS","IVDELTERMS","IVDISCOUNT","IVDISCDAYS","IVCUSTREF","IVOWNREF","IVDATE","IVPERIOD","IVREP","IVVAL","IVPACKLIST","IVORDER","IVNAME","IVNAME2","IVADRESS1","IVADRESS2","IVADRESS3","IVADRESS4","IVCOUNTRY","IVDEPA","IVTRANSP","IVPACKNUM","IVBWEIGHT","IVTRANSP2","Invoice date","VADECIMALS","VARATE","IVSALES","IVVALUTA","SALES","VALUTA","Rate"]
[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,"StoreEleven","Juilanastraat 34","2045 CH  Alphen aan den Rijn"," ","NEDERLAND","EUR","EUR","Euro",2]

{"sheet":"Invoice","index":4,"n_rows":21,"n_cols":25,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Invoice",null,null,"Customer",{"$f":"Datasheet!$B$8","v":0}]
[]
[null,"Customer",{"$f":"Datasheet!$D$8","v":0},null,null,"Delivery",{"$f":"IF($C$3>\"  \",Datasheet!$DD$8,\"  \")","v":"  "}]
[null,null,{"$f":"Datasheet!$E$8","v":0},null,null,null,{"$f":"IF($C$3>\"  \",Datasheet!$DE$8,\"  \")","v":"  "}]
[null,null,{"$f":"Datasheet!$J$8","v":0},null,null,null,{"$f":"IF($C$3>\"  \",Datasheet!$DF$8,\"  \")","v":"  "}]
[null,null,{"$f":"Datasheet!$K$8","v":0},null,null,null,{"$f":"IF($C$3>\"  \",Datasheet!$DG$8,\"  \")","v":"  "}]
[null,null,{"$f":"Datasheet!$F$8","v":0},null,null,null,{"$f":"IF($C$3>\"  \",Datasheet!$DJ$8,\"   \" )","v":"   "}]
[null,null,{"$f":"Datasheet!$V$8","v":0},null,null,null,{"$f":"IF($C$3>\"  \",Datasheet!$CO$8,\"   \")","v":"   "}]
[null,"Head office",{"$f":"Datasheet!$C$8","v":0}]
[]
[null,"Info","Date",{"$f":"IF($C$3>\"  \",Datasheet!$DP$8,\"  \")","v":"  "},null,"Picking list",{"$f":"IF($C$3>\"  \",Datasheet!$DB$8,\"  \")","v":"  "},"Area",{"$f":"IF($C$3>\"  \",Datasheet!$CZ$8,\"   \")","v":"   "},null,"Currency",{"$f":"IF($C$3>\"  \",Datasheet!$DA$8,\"  \")","v":"  "}]
[null,null,"Our reference",{"$f":"IF($C$3>\"  \",Datasheet!$CW$8,\"  \")","v":"  "},null,"Customer ref",{"$f":"IF($C$3>\"  \",Datasheet!$CV$8,\"   \")","v":"   "},"Transport",{"$f":"IF($C$3>\"  \",Datasheet!$DL$8,\"   \")","v":"   "},null,"Hist.rate",{"$f":"IF($C$3=\"  \",\" \",Datasheet!$DW$8)","v":0}]
[null,null,"Order",{"$f":"IF($C$3>\"  \",Datasheet!$CX$8,\"  \")","v":"  "},null,"Pay type ",{"$f":"IF($C$3>\"  \",Datasheet!$CQ$8,\"  \")","v":"  "},"Weight",{"$f":"IF($C$3>\"  \",Datasheet!$DN$8,\"  \")","v":"  "},null,"Act. Rate",{"$f":"IF($C$3=\"  \",\" \",Datasheet!$DR$8)","v":0}]
[null,null,"Order date",null,null,"Pay terms",{"$f":"IF($C$3>\"  \",Datasheet!$CR$8,\"   \")","v":"   "},"Del terms",{"$f":"IF($C$3>\"  \",Datasheet!$CS$8,\"  \")","v":"  "},null,"Decimals",{"$f":"IF($C$3>\"  \",Datasheet!$DQ$8,\"  \")","v":"  "}]
[]
[null,null,null,null,null,null,null,{"$f":"Datasheet!$BW$8","v":"EUR"},null,null,null,null,null,"Estimated"]
[null,"Type","Quantity","Unit","Part","Cust. part","Description","Retail price","Discount","Unit price","Total excl. VAT","VAT","Total  amount","Cost price","Stock price","ILQUANT","ILAMOUNT","ILSTDCOST","ILCOSTPRIC","ILVALUTA","ILDISCOUNT","Nett ind","ILRETAIL","ILVAT","ILTYPE"]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(109,Invoice_details[Total excl. VAT])","v":0},{"$f":"SUBTOTAL(109,Invoice_details[VAT])","v":0},{"$f":"SUBTOTAL(109,Invoice_details[Total  amount])","v":0},{"$f":"SUBTOTAL(109,Invoice_details[Cost price])","v":0},{"$f":"SUBTOTAL(109,Invoice_details[Stock price])","v":0}]

{"sheet":"Invoice History","index":5,"n_rows":9,"n_cols":56,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Invoices",null,{"$f":"'Select a customer'!B3","v":0},{"$f":"'Select a customer'!C3","v":0}]
[]
[]
[]
[null,"Invoice","Date","Quantity","Unit","Part or group","Description","Retail price","Nett","Discount","Currency price","Currency","Local price","Total sales","VAT","To be paid","Line type","Head office","Area","Area description","Order","Month","Year","Delterms","Paytype","Payterms","Picklist","Country","Origin","Transporter","Part","Part description","Supplier","Supplier part","Weight","Volume","Part group","Part group description","Sales account","Sales account description","Part number and name","Group number and description","Sales account number and description","Area number and description","D","R","IVDEPOT","IVPERIOD","IVSEQNR","ILTYPE","ILRETAIL","ILVALUTA","ILVAT","ILCOSTPRIC","ILSTDCOST","ILAMOUNT"]
[null,null,null,null,null,null,null,{"$f":"Invoice_history[ILRETAIL]/POWER(10,SERA3150_Company_record[VADECIMALS])","v":0},null,null,{"$f":"Invoice_history[ILVALUTA]/POWER(10,Invoice_history[D])","v":0},null,{"$f":"Invoice_history[Currency price]*Invoice_history[R]","v":0},{"$f":"Invoice_history[Quantity]*Invoice_history[Local price]","v":0},{"$f":"(Invoice_history[ILVAT]/POWER(10,Invoice_history[D]))*Invoice_history[R]","v":0},{"$f":"Invoice_history[Total sales]+Invoice_history[VAT]","v":0},{"$f":"IF(Invoice_history[ILTYPE]=\"1\",\"Part line\",\"Cost line\")","v":"Cost line"},null,null,null,null,null,{"$f":"MID(Invoice_history[Month],1,4)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(Invoice_history[[#This Row],[Part]],\"   -   \",Invoice_history[[#This Row],[Part description]])","v":"   -   "},{"$f":"CONCATENATE(Invoice_history[Part group],\"   -   \",Invoice_history[Part group description])","v":"   -   "},{"$f":"CONCATENATE(Invoice_history[Sales account],\"  -   \",Invoice_history[Sales account description])","v":"  -   "},{"$f":"CONCATENATE(Invoice_history[Area],\"  -   \",Invoice_history[Area description])","v":"  -   "},null,{"$f":"IF(Invoice_history[ILVALUTA]<>0,(Invoice_history[ILAMOUNT]/POWER(10,SERA3150_Company_record[VADECIMALS])) / (Invoice_history[ILVALUTA]/POWER(10,Invoice_history[D])),1)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(109,Invoice_history[Total sales])","v":0},{"$f":"SUBTOTAL(109,Invoice_history[VAT])","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,{"$f":"SUBTOTAL(109,Invoice_history[ILAMOUNT])","v":0}]

{"sheet":"Sales analysis","index":6,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Sales analysis",{"$f":"Datasheet!$C$8","v":0},{"$f":"Datasheet!$D$8","v":0}]
[]
[]
[]
[null,"Group","*Total sales"]
[null,"   -   ",0]
[null,"Total",0]

{"sheet":"Outstanding orders","index":7,"n_rows":9,"n_cols":47,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Order details",null,{"$f":"'Select a customer'!B3","v":0},{"$f":"'Select a customer'!C3","v":0}]
[]
[]
[]
[null,"Days too late","Order","Type","Quantity","Unit","Part","Description","Retail price","Nett","Discount","Unit price","Currency","Local price","Total sales","Del.date","Month","Customer","Customer name","Group","Group description","Area","Area name","Part description","Delivery","Supplier","Paytype","Head office","Payterms","Date","Country","Customer number and name","OLAMOUNT","OLCOSTPRIC","OLVALUTA","OLCOSTPRIC2","OLRETAIL","OLVAT","OLVAL","OLAMOUNT3","PAGROUP","PASUPPPART","PAWEIGHT","PAVOLUME","R","D","OLTYPE"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(109,Order_details[Total sales])","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,{"$f":"SUBTOTAL(103,Order_details[OLTYPE])","v":0}]