{"text_format":"1","workbook":"xlsx","n_sheets":22,"sheets":["Product List","Current Sale","Sales Data","EPOS Data","Options","NarrowReceipt","Tax Class","EPOS Data 2","Stock Management Options","Current Stock","File Settings","Products Options","Product Search Results","Deal Codes Setup","Orders Options","Customer Orders","Deal Options","EPOS Settings","Reports","Sale Data Settings","WideReceipt","Receipt Settings"],"not_rendered":{"charts":0,"images":41,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"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":"Product List","index":0,"n_rows":1,"n_cols":8,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["SKU","Description","Gross Price","Tax Class","Deal Code","Qty Delivered","Qty In Stock","Qty Sold"]

{"sheet":"Current Sale","index":1,"n_rows":101,"n_cols":10,"rows_kept":101,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,"",null,"Till No:",1]
[null,null,null,null,null,null,null,null,"Sale No:",1]
["Item Code","Quantity","Item Price","Tax Class","Line Price","item deal code (hidden column)",null,null,"Total Till Sales Today:",0]
[]
[null,null,null,null,null,null,null,null,"Previous Sale Change:",0]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Sale Discounts"]
[null,null,null,null,null,null,"% Discount:"]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Money Discount:"]
[null,null,null,null,null,null,0,null,"Time:",{"$f":"NOW()","v":40934.611649074075}]
[null,null,null,null,null,null,null,null,"Date:","2012-01-25"]
[null,null,null,null,null,null,null,null,"Sales Assistant:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"DO NOT ADD MORE ITEMS BELOW THIS POINT"]

{"sheet":"Sales Data","index":2,"n_rows":9,"n_cols":28,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["BS25012012T1N1",1,"NIV Bible",1,10.06,"Cash",43.21,null,null,null,null,null,null,null,null,12.07,43.21,"2012-01-25T11:17:19","Special Offer  -£10.00    \r\n\r\n","T20","£","2012-01-25",1,1,5.38,14.87,1,"Martin"]
["BS25012012T1N1",1,"NIV Bible",1,10.06,"Cash",null,null,null,null,null,null,null,null,null,12.07,null,"2012-01-25T11:17:19",null,"T20","£","2012-01-25",1,1,null,14.87,1,"Martin"]
["BS25012012T1N1",3,"Book",1,3.65,"Cash",null,null,null,null,null,null,null,null,null,3.65,null,"2012-01-25T11:17:19",null,"T0","£","2012-01-25",1,1,null,4.49,1,"Martin"]
["BS25012012T1N1",3,"Book",1,3.65,"Cash",null,null,null,null,null,null,null,null,null,3.65,null,"2012-01-25T11:17:19",null,"T0","£","2012-01-25",1,1,null,4.49,1,"Martin"]
["BS25012012T1N1",3,"Book",1,3.65,"Cash",null,null,null,null,null,null,null,null,null,3.65,null,"2012-01-25T11:17:19",null,"T0","£","2012-01-25",1,1,null,4.49,1,"Martin"]
["BS25012012T1N1",2,"DVD",1,1.69,"Cash",null,null,null,null,null,null,null,null,null,2.0299999999999998,null,"2012-01-25T11:17:19",null,"T20","£","2012-01-25",1,1,null,2.5,1,"Martin"]
["BS25012012T1N1",4,"DVD 2",1,1.69,"Cash",null,null,null,null,null,null,null,null,null,2.0299999999999998,null,"2012-01-25T11:17:19",null,"T20","£","2012-01-25",1,1,null,2.5,1,"Martin"]
["BS25012012T1N1",2,"DVD",1,1.69,"Cash",null,null,null,null,null,null,null,null,null,2.0299999999999998,null,"2012-01-25T11:17:19",null,"T20","£","2012-01-25",1,1,null,2.5,1,"Martin"]
["BS25012012T1N1",4,"DVD 2",1,1.69,"Cash",null,null,null,null,null,null,null,null,null,2.0299999999999998,null,"2012-01-25T11:17:19",null,"T20","£","2012-01-25",1,1,null,2.5,1,"Martin"]

{"sheet":"EPOS Data","index":3,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["This worksheet is used for various calculations in the EPOS program. Do not delete it!!"]
[1,1,14.87,"T20",12.07]
[1,1,14.87,"T20",12.07]
[3,1,4.49,"T0",3.65]
[3,1,4.49,"T0",3.65]
[3,1,4.49,"T0",3.65]
[2,1,2.5,"T20",2.0299999999999998]
[4,1,2.5,"T20",2.0299999999999998]
[2,1,2.5,"T20",2.0299999999999998]
[4,1,2.5,"T20",2.0299999999999998]

{"sheet":"Options","index":4,"n_rows":22,"n_cols":17,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EPOS4Excel version:",null,"1.1.0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"© Martin Stokley 2011-2012"]
[]
[]
[null,"Last Update Check:",null,"2012-01-26"]

{"sheet":"NarrowReceipt","index":5,"n_rows":30,"n_cols":3,"rows_kept":30,"cut":false,"hidden":true,"merged":[[11,2,11,11]]}
[]
["Company Address 1"]
["Company Address 2"]
["Company Phone number",null,"The receipt template is in Column A"]
["VAT No: 123456789     Company No: 123456789"]
[null,null,"Do not alter layout below row 7"]
["Item                                         Qty     Price     ",null,"On the receipt item details will start from row 8 onwards"]
["NIV Bible      2       £14.87 A",null,"The receipt template holds the details of the last generated receipt  until a new one is generated."]
["DVD      2        £2.50 A",null,"Receipt Column Width = 35.29 for Star TSP 113 receipt printer"]
["Book      3        £4.49 B"]
["DVD 2      2        £2.50 A"]
["Special Offer  -£10.00    \r\n"]
["Total: £43.21    "]
[]
["Payment:"]
["Cash: £43.21      "]
["Change Due:   £0.00      "]
[]
["------------ VAT ------------"]
["Code:       VAT Rate:"]
["  A                     20%"]
["  B                      0%"]
["Excluding VAT: £37.83   VAT: £5.38"]
["-----------------------------"]
[]
["You were served by: Martin"]
["Till No:  1   TXN: BS25012012T1N1"]
["Date:  25/01/2012     Time:  11:17:20"]
[]
["Thank you for shopping with us. Visit our website www.ourwebsite.co.uk and use this coupon code AXD34SD34HQ for a 10% discount on your next web order."]

{"sheet":"Tax Class","index":6,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Tax Class","% Tax Rate"]
[null,"T0",0]
[null,"T20",20]
[null,"T14",14]
[null,"T1",1]
[null,"T10",10]

{"sheet":"EPOS Data 2","index":7,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["This worksheet is used for various calculations in the EPOS program. Do not delete it!!"]

{"sheet":"Stock Management Options","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Current Stock","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"File Settings","index":10,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Please choose the folder where the:"]
[]
[null,null,null,"Sales data"]
[null,null,null,"Daily customer order data"]
[null,null,null,"System data"]
[]
[null,null,null,"files will be stored"]
[]
[null,null,null,"C:\\EPOS4ExcelData\\"]

{"sheet":"Products Options","index":11,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Product Search Results","index":12,"n_rows":2,"n_cols":8,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
[]
["SKU","Description","Price","Tax Class","Deal Code","Qty Delivered","Qty in Stock","Qty Sold"]

{"sheet":"Deal Codes Setup","index":13,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
["Deal Name (Max. 25 Characters)","Buy any X and get the cheapest Y free","Buy any X for £ Y","Buy X different for £ Y","X","Y"]
["buy 3 for £2",null,null,"a",3,2]
["buy any 3 for £10",null,"b",null,3,10]
["buy 2 for £10",null,null,"c",2,10]
["3 for 2","d",null,null,3,1]

{"sheet":"Orders Options","index":14,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Customer Orders","index":15,"n_rows":2,"n_cols":9,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
[]
["Order Number","Customer Name","Phone Number","Email Address","Postal Address","Enquiry / order details","Special instructions","Completed (Y/N)","Order Date"]

{"sheet":"Deal Options","index":16,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"EPOS Settings","index":17,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[null,"EPOS Currency:",null,null,"Payment Types:"]
[]
[null,"Current EPOS Currency =  ",{"$f":"C10","v":"£"},null,null,"Type","Nominal Code"]
[null,null,null,null,"1 -","Cash",1]
[null,"EPOS Currency Symbol:","£",null,"2 -","Card",2]
[null,null,null,null,"3 - ","Book Token",3]
[null,"For the € symbol use [alt gr] key + [4] key",null,null,"4 -","Cheque",4]
[null,null,null,null,"5 -","Gift Token",5]
[null,"Make sure the product prices stored in EPOS  "]
[null,"are in the current EPOS currency!",null,null,"Note: We have to have at least one payment"]
[null,null,null,null,"type so we nominate this to be cash."]
[null,null,null,null,"Cash is also nominated as the payment type"]
[null,null,null,null,"by which change will be given."]
[]
[null,"£1 buys this number of the current EPOS currency",1]
[]
[]
[null,"Screen lock password:","EPOS4excel"]

{"sheet":"Reports","index":18,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Sale Data Settings","index":19,"n_rows":32,"n_cols":9,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,"Sales Data Column:",null,null,"Column Options:",null,null,"Current Setting"]
[null,"Column A:",null,null,null,null,null,"Transaction Number"]
[null,"Column B:",null,null,null,null,null,"Item Code"]
[null,"Column C:",null,null,null,null,null,"Item Description"]
[null,"Column D:",null,null,null,null,null,"Quantity"]
[null,"Column E:",null,null,null,null,null,"Net Item Price After Discounts"]
[null,"Column F:",null,null,null,null,null,"Payment Method 1"]
[null,"Column G:",null,null,null,null,null,"Payment Amount 1"]
[null,"Column H:",null,null,null,null,null,"Payment Method 2","Transaction Number Prefix:"]
[null,"Column I:",null,null,null,null,null,"Payment Amount 2","BS"]
[null,"Column J:",null,null,null,null,null,"Payment Method 3"]
[null,"Column K:",null,null,null,null,null,"Payment Amount 3"]
[null,"Column L:",null,null,null,null,null,"Payment Method 4"]
[null,"Column M:",null,null,null,null,null,"Payment Amount 4"]
[null,"Column N:",null,null,null,null,null,"Payment Method 5"]
[null,"Column O:",null,null,null,null,null,"Payment Amount 5"]
[null,"Column P:",null,null,null,null,null,"Gross Item Price After Discounts"]
[null,"Column Q:",null,null,null,null,null,"Sale Total"]
[null,"Column R:",null,null,null,null,null,"Time of Sale"]
[null,"Column S:",null,null,null,null,null,"Sale Memo"]
[null,"Column T:",null,null,null,null,null,"Tax Class"]
[null,"Column U:",null,null,null,null,null,"Till Currency"]
[null,"Column V:",null,null,null,null,null,"Date of Sale"]
[null,"Column W:",null,null,null,null,null,"Till Number"]
[null,"Column X:",null,null,null,null,null,"Sale Number"]
[null,"Column Y:",null,null,null,null,null,"Sale Total VAT"]
[null,"Column Z:",null,null,null,null,null,"Gross Item Price Before Discounts"]
[null,"Column AA:",null,null,"Fixed Column - No options",null,null,"Till Number"]
[null,"Column AB:",null,null,"Fixed Column - No options",null,null,"Sales Assistant Name"]

{"sheet":"WideReceipt","index":20,"n_rows":30,"n_cols":7,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Address","Date:","22/01/2012"]
[null,"Address","Time:","09:07:07"]
[null,"Address","TXN:","BS22012012T1N6"]
[null,"Company number: 1234567890  VAT number:1234567890","Till No:",1]
[null,null,"Sales Asst:","Martin",null,null,"The receipt template is in Column A to E"]
[]
["Item Code","Description","Qty","Gross Price","VAT",null,"You can alter the layout in columns A to B between rows 1 and 7"]
[null,null,null,null,null,null,"Do not alter columns C to E apart from colum width"]
[1,"Test 1",1,"£10.00","A",null,"Do not alter layout below row 8"]
[2,"test 2",1,"£20.00","B",null,"On the receipt item details will start from row 9 onwards"]
[3,"test 3",1,"£30.00","A",null,"Receipt template contains last generated receipt until a new one is generated"]
[null,"buy any 3 for £10 -£50.00    \r\nSpecial Offer  -£2.00    \r\n 10% Discount  -£0.80    \r"]
[]
[null,null,null,"Total: £7.20"]
[]
["Payments:"]
[null,null,null,"Cash: £7.20"]
[]
[null,null,null,"Change Due:   £0.00"]
[]
[]
["VAT:"]
[null,"Code:       VAT Rate:"]
[null,"  A                      0%"]
[null,"  B                     20%"]
[]
[null,"Excluding VAT: £6.80   VAT: £0.40"]
[]
[null,"Thank you for shopping with us. Visit our website www.ourwebsite.co.uk and use this coupon code AXD34SD34HQ for a 10% discount on your next web order."]

{"sheet":"Receipt Settings","index":21,"n_rows":20,"n_cols":11,"rows_kept":20,"cut":false,"hidden":true,"merged":[[19,4,19,13]]}
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Receipt Style:"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"No. characters of item description to display on the receipt:",null,null,null,null,null,20]
[null,null,null,null,"(20 characters are recommended for the narrow receipt)"]
[]
[]
[null,null,null,null,"Receipt Message:"]
[null,null,null,null,"Thank you for shopping with us. Visit our website www.ourwebsite.co.uk and use this coupon code AXD34SD34HQ for a 10% discount on your next web order."]