{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Client receipts","Client details","Client Records","Price List"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Client receipts","index":0,"n_rows":40,"n_cols":5,"rows_kept":40,"cut":false,"hidden":false,"merged":[[28,0,28,3],[29,0,29,3],[30,0,30,3],[26,0,26,3],[6,1,6,3],[7,1,7,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[11,1,11,3],[12,0,12,3],[13,0,13,3],[14,0,14,3],[0,0,0,4],[1,0,1,4],[5,0,5,4],[15,0,15,4],[27,0,27,4],[23,0,23,3],[24,0,24,3],[25,0,25,3]]}
["RC's Hair Salon"]
["Customer Details and records"]
["Date",{"$f":"NOW()","v":"2011-07-28T12:49:56.220"}]
["Name"]
["Special discount:",{"$f":"IFERROR(VLOOKUP(B4,'Client details'!A5:D7,4,FALSE),\"\")","v":""}]
["Service Provided"]
["Code","Details",null,null,"Price"]
[null,{"$f":"IFERROR(VLOOKUP(A8,Service,2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(A8,Service,3,FALSE),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A9,Service,2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(A9,Service,3,FALSE),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A10,Service,2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(A10,Service,3,FALSE),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A11,Service,2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(A11,Service,3,FALSE),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP(A12,Service,2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(A12,Service,3,FALSE),\"\")","v":""}]
["Sub Total",null,null,null,{"$f":"IFERROR(SUM(E8:E12),0)","v":0}]
["Discount",null,null,null,{"$f":"IF(OR(B5=\"Pensioner\"),\"15%\",IF(OR(B5=\"Student\"),\"10%\",0))","v":0}]
["Total Services",null,null,null,{"$f":"E13-(E13*E14)","v":0}]
["Hair care range"]
["Code","Details","Item Price","Qty","Total Price"]
[null,{"$f":"IFERROR(VLOOKUP(A18,Hair,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A18,Hair,3,FALSE),\"\")","v":""},3,{"$f":"IFERROR(C18*D18,\"\")","v":""}]
[null,"","",null,{"$f":"IFERROR(C19*D19,\"\")","v":""}]
[null,"","",null,""]
[null,"","",null,""]
[null,"","",null,""]
[null,"","",null,""]
["Sub Total",null,null,null,{"$f":"SUM(E18:E23)","v":0}]
["Count",null,null,null,{"$f":"SUM(D18:D23)","v":3}]
["Discount",null,null,null,{"$f":"IF(E25>=3,\"5%\",0)","v":"5%"}]
["Total Hair Care",null,null,null,{"$f":"IFERROR(E24-E26,0)","v":-0.05}]
["SUMMARY OF SALE"]
["Total Services & Products",null,null,null,{"$f":"E15+E27","v":-0.05}]
["GST",null,null,null,{"$f":"E29*0.1","v":-5.000000000000001E-3}]
["TOTAL SALE",null,null,null,{"$f":"E29+E30","v":-5.5000000000000007E-2}]
[]
[]
[]
[]
[]
[]
[]
[]
[" "]

{"sheet":"Client details","index":1,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,0,1,4]]}
["RC's Hair Salon"]
["Customer Details and records"]
[]
["Name","Phone","DOB","Special discount","Details"]
["Henry Vo",412567412,"1980-09-22"]
["Muriel Howard",93346835,"1940-01-01","Pensioner","CRN 489-321-975H"]
["Janine Hopkins",414789345,"1988-07-13","Student"]

{"sheet":"Client Records","index":2,"n_rows":10,"n_cols":16,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,15,2,15],[0,0,0,15],[1,8,1,13],[1,3,1,7],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,14,2,14]]}
["Client Records"]
["Date","Name","Special Discount","Services",null,null,null,null,"Products Bought",null,null,null,null,null,"GST","Total Price"]
[null,null,null,1,2,3,"Discount","Price",1,2,3,4,"Discount","Price"]
[]
["2011-07-28T12:49:20.550","Laura Fihelly","","Lady haircut (Includes blow wave)","","","Discount","Total Services","Lustre Shampoo","","","","Discount","Total Hair Care","GST","TOTAL SALE"]
["2011-07-28T09:49:55.240","Muriel Howard","Pensioner","Hair Cut (Includes Blow Wave with Straightening or Curling Iron)","Semi Permanent Tint (Short - Medium)","","15%",42.5,"Lustre Shampoo","","","",0,12,5.45,59.95]
["2011-07-28T09:47:43.380","Janine Hopkins","Student","Lady haircut (fringe only)","Lady haircut (Includes blow wave)","","10%",18,"Lustre Shampoo","Lustre Conditioner","Lustre Leave in Conditioner Treatment","","5%",41.95,5.995000000000001,65.945000000000007]
["2011-07-28T09:43:34.370","Janine Hopkins","Student","Lady haircut (fringe only)","Lady haircut (Includes blow wave)","","10%",18,"Lustre Shampoo","Lustre Conditioner","Lustre Leave in Conditioner Treatment","","5%",41.95,5.995000000000001,65.945000000000007]
["2011-07-28T09:28:49.540","Henry Vo",0,"Men Haircut","","",0,15,"Lustre Shampoo","","","",0,12,2.7,29.7]
["2011-07-28T09:14:07.570","Janine Hopkins","Student","Lady haircut (fringe only)","Lady haircut (Includes blow wave)","Hair Cut (Includes Blow Wave with Straightening or Curling Iron)","10%",40.5,"Lustre Shampoo","Lustre Shampoo","","",0,24,6.45,70.95]

{"sheet":"Price List","index":3,"n_rows":34,"n_cols":8,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,0,0,2],[0,5,0,7]]}
["Service Menu",null,null,null,null,"Hair Care Range"]
["Code","Item","Price",null,null,"Code","Product","Price"]
[null,"Children (1-10 years)",null,null,null,"HC1","Lustre Shampoo",12]
["C1","Children Haircut",10,null,null,"HC2","Lustre Conditioner",12]
[null,"Men's Syling",null,null,null,"HC3","Lustre Leave in Conditioner Treatment",18]
["M1","Men Haircut",15,null,null,"HC4","Lustre Sculpt",18]
["M2","Men Clipper Cut",10,null,null,"HC5","Lustre Hairspray",15]
[null,"Ladies Styling",null,null,null,"HC6","Lustre Wax",16]
["L1","Lady haircut (fringe only)",5]
["L2","Lady haircut (Includes blow wave)",15]
["L3","Hair Cut (Includes Blow Wave with Straightening or Curling Iron)",25]
["L4","Straightening Iron (Includes Blow Wave)",20]
["L5","Curling Iron (Including Blow Wave)",20]
["L6","Blow Wave",15]
["L7","Special Occasion Upstyle",30]
["L8","Braiding",20]
[null,"Treatments (including Scalp Massage)",25]
[null,"Semi Permanent Tint"]
["SP1","Semi Permanent Tint (Short - Medium)",25]
["SP2","Semi Permanent Tint (Long)",40]
[null,"Permanent Tint"]
["P1","Permanent Tint (Short-Medium)",45]
["P2","Permanent Tint (Long)",60]
[null,"Tint and Foils"]
["T1","Tint and Foils (Short-Medium)",60]
["T2","Tint and Foils (Long)",75]
[null,"Permanent Straightening"]
["PS1","Permanent Staightening (Short)",150]
["PS2","Permanent Staightening (Medium)",200]
["PS3","Permanent Staightening (Long)",250]
[null,"Perm (includes Cut & Set/Blow Wave)"]
["PO1","Perm (Short-Medium)",50]
["PO2","Perm (Long-Length Hair)",60]
["PO3","Perm (Spiral)",100]