{"text_format":"1","workbook":"xlsx","n_sheets":25,"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","Security","DiscountReasons","Report Results"],"not_rendered":{"charts":0,"images":65,"macros":1,"external_links":0,"defined_names":5,"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":8,"n_cols":10,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["SKU","Description","Gross Price","Tax Class","Deal Code","Qty Delivered","Qty In Stock","Qty Sold","Description 2","Description 3"]
[1,"Africa Bible BOOK",22.09,"T0","a",0,-4,4,"",""]
[2,"Agony Atkins BOOK",7.99,"T0","a",0,-2,2,"",""]
[3,"Women Elders in the Kirk? BOOK",4.99,"T0","a",0,-5,5,"",""]
[4,"What's in the Bible DVD",8.49,"T20","",0,-5,5,"",""]
[5,"It's a meaningful life DVD",8.99,"T20","",0,-5,5,"",""]
[6,"Agony Atkins DVD",7.99,"T20","a",0,-3,3,"",""]
[7,"Africa Bible DVD",22.09,"T20","a",0,-2,2,"",""]

{"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,"Sub Total: £0.00",null,"Sale No:",1]
["Item Code","Quantity","Item Price","Tax Class","Line Price","item deal code (hidden column)","Description",null,"Total Till Sales Today:",0]
[]
[null,null,null,null,null,null,null,null,"Previous Sale Change:",0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Time:",{"$f":"NOW()","v":41027.296529398147}]
[null,null,null,null,null,null,null,null,"Date:","2001-01-01"]
[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":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

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

{"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.2.3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"© Martin Stokley 2011-2012"]
[]
[]
[null,"Last Update Check:",null,"2012-04-16"]

{"sheet":"NarrowReceipt","index":5,"n_rows":25,"n_cols":3,"rows_kept":25,"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"]
["Africa Bible BOOK      0        £0.00 A",null,"The receipt template holds the details of the last generated receipt  until a new one is generated."]
[null,null,"Receipt Column Width = 35.29 for Star TSP 113 receipt printer"]
["Total: £0.00    "]
[]
["Payment:"]
["Change Due:   £0.00      "]
[]
["------------ VAT ------------"]
["Code:       VAT Rate:"]
["  A                      0%"]
["Excluding VAT: £0.00   VAT: £0.00"]
["-----------------------------"]
[]
["You were served by: Martin"]
["Till No:  1   TXN: BS01012001T1N1"]
["Date:  01/01/2001     Time:  16:44:53"]
[]
["Thank you for shopping with us.             Visit our website at www.ourwebsite.com"]

{"sheet":"Tax Class","index":6,"n_rows":28,"n_cols":3,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Tax Class","% Tax Rate"]
[null,"T0",0]
[null,"T1",17.5]
[null,"T10",10]
[null,"T11",11.9]
[null,"T13",13]
[null,"T14",4]
[null,"T15",15.35]
[null,"T18",18.465]
[null,"T2",0]
[null,"T20",20]
[null,"T3",5]
[null,"T31",3.1]
[null,"T38",3.86]
[null,"T5",15]
[null,"T53",5.3]
[null,"T5_",5.92]
[null,"T6",6]
[null,"T1-",14.7]
[null,"T1.",10.3]

{"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 (product list, deals list, receipt message)"]
[]
[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":10,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
[]
["Item Code","Description","Price","Tax Class","Deal Code","Qty Delivered","Qty in Stock","Qty Sold","Description 2","Description 3"]

{"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"]
["3 for 2","a",null,null,3,1]
["buy any 3 for £10",null,null,"b",2,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":3,"n_cols":9,"rows_kept":3,"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"]
[1,"","","","asdf","","","N","2012-03-31"]

{"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":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":true,"merged":[[24,5,24,9],[25,5,25,9]]}
[]
[]
[]
[]
[]
[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"]
[]
[null,null,null,"Description 2 Label:",null,"Description 2"]
[null,null,null,"Description 3 Label:",null,"Description 3"]

{"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":37,"n_cols":9,"rows_kept":37,"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 Sale Deal/Disc"]
[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 Sale Deal/Disc"]
[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,"Sale Deals/Discounts"]
[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 Sale Deal/Disc"]
[null,"Column AA:",null,null,"Fixed Column - No options",null,null,"Till Number"]
[null,"Column AB:",null,null,null,null,null,"Sales Assistant Name"]
[null,"Column AC:",null,null,null,null,null,"Item Price Change/Disc"]
[null,"Column AD:",null,null,null,null,null,"Transaction Number"]
[null,"Column AE:",null,null,null,null,null,"Item Product List Price"]
[null,"Column AF:",null,null,null,null,null,"Item Description 2"]
[null,"Column AG:",null,null,null,null,null,"Item Description 3"]

{"sheet":"WideReceipt","index":20,"n_rows":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Address","Date:"]
[null,"Address","Time:"]
[null,"Address","TXN:"]
[null,"Company number: 1234567890  VAT number:1234567890","Till No:"]
[null,null,"Sales Asst:",null,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"]
[null,null,null,null,null,null,"Do not alter layout below row 8"]
[null,null,null,null,null,null,"On the receipt item details will start from row 9 onwards"]
[null,"Till End of Day Reconciliation Totals",null,null,null,null,"Receipt template contains last generated receipt until a new one is generated"]
[]
[null,"Date:  04/03/2012"]
[null,"Till No: 1"]
[null,"No. Items sold: 20"]
[null,"Currency = £"]
[null,"Total Cash: 140.57"]
[null,"Total Card: 0.00"]
[null,"Total Book Token: 0.00"]
[null,"Total Cheque: 0.00"]
[null,"Total Gift Token: 0.00"]
[]
[null,"Final Till Total: 140.57"]
[null,"Final Till VAT Total: Gift Token13.43"]
[]
[null,"Starting TXN:    BS04032012T1N1"]
[null,"Finishing TXN: "]

{"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 at www.ourwebsite.com"]

{"sheet":"Security","index":22,"n_rows":28,"n_cols":14,"rows_kept":28,"cut":false,"hidden":true,"merged":[[23,2,23,5],[23,7,23,11],[23,13,23,17]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Sales Security Level Functions:",null,null,null,null,"Supervisor Security Level Functions:",null,null,null,null,null,"Administrator Security Level Functions:"]
[]
[null,null,"Make Sales",null,null,null,null,"Access sales level functions AND",null,null,null,null,null,"Access supervisor level functions AND"]
[null,null,"Create / Delete / Edit customer orders",null,null,null,null,"Refunds",null,null,null,null,null,"Access the EPOS 4 Excel Settings"]
[null,null,"Product Search",null,null,null,null,"Add / Edit product details functions",null,null,null,null,null,"Clear stock levels"]
[null,null,null,null,null,null,null,"Sales reports functions",null,null,null,null,null,"Delete products"]
[null,null,null,null,null,null,null,"Deals functions"]
[null,null,null,null,null,null,null,"Stock level functions (except clear stock levels)"]
[null,null,null,null,null,null,null,"Change till number"]
[null,null,null,null,null,null,null,"Sale discounts / Item price changes"]
[]
[]
[]
[]
[null,null,"Password:",null,null,null,null,"Password:",null,null,null,null,null,"Password:"]
[null,null,"sales",null,null,null,null,"supervisor",null,null,null,null,null,"administrator"]
[]
[]
[null,null,"NOTE: Passwords should be different for each user level. If not, then the entering the password will activate the "]
[null,null,"highest possible user level for that password."]

{"sheet":"DiscountReasons","index":23,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["Manager Discount"]
["Damaged"]
["Coupon"]
["Student Discount"]
["£3 off £30 Spend"]
["Till Price Wrong"]
["Loyalty Discount",null,"Enter all possible reasons for discounts in the cells to the left starting from the top"]
["Refund Adjustment",null,"One reason per row and don't leave blank rows"]
["Staff Discount"]
[null,null,"PLEASE NOTE: What you type here may appear on a receipt"]

{"sheet":"Report Results","index":24,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}