{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","TimesheetDownload","Invoice"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":12,"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":"Instructions","index":0,"n_rows":37,"n_cols":2,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Generate PDF Invoices and auto-email by Scissors "]
[]
[]
[null,"Instructions"]
[null,"     1. Prepare your timesheet data in the format set out in TimesheetDownload."]
[null,"     2. Check configuration below in the green cells."]
[]
[]
[null,"Invoice email subject"]
[null,"Thanks for your business - invoice for you!"]
[]
[null,"Invoice email body"]
[]
[null,"Hello,\n\nWe hope you had a good experience with our staff. Attached is your latest invoice.\n\nPlease let us know of any feedback.\n\nThanks\nScissors Agency"]
[]
[null,"Value Added Tax (or Goods Services Tax)% "]
[null,0.15]
[]
[]
[null,"3. Click the button below and save your time!"]
[]
[]
[]
[]
[]
[null,"© 2023 Scissors App - All rights reserved"]

{"sheet":"TimesheetDownload","index":1,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null," Invoices  DATA"]
[]
["ClientName","ClientStreet","ClientCity","ClientState","ClientPostcode","ClientEmail","InvoiceNumber","InvoiceDate","DueDate","Description","Hours","Rate","PK"]
["People Care","1 Skool Street","George","Western Cape",6529,"alan@scissorsapp.com","48_20220124","2022-01-24","2022-01-31","Derek Chandler ( 10-Jan-22 )","8.5",20,{"$f":"LOWER(Tab_Invoice[[#This Row],[ClientEmail]]&Tab_Invoice[[#This Row],[Description]])","v":"alan@scissorsapp.comderek chandler ( 10-jan-22 )"}]
["Wellness Care","11 Bousfield Street","George","Western Cape",6530,"alan@scissorsapp.com","49_20220124","2022-01-24","2022-01-31","Gloria Fisher ( 11-Jan-22 )","8.5",404,{"$f":"LOWER(Tab_Invoice[[#This Row],[ClientEmail]]&Tab_Invoice[[#This Row],[Description]])","v":"alan@scissorsapp.comgloria fisher ( 11-jan-22 )"}]
["Wellness Care","11 Bousfield Street","George","Western Cape",6530,"alan@scissorsapp.com","49_20220124","2022-01-24","2022-01-31","Gloria Fisher ( 12-Jan-22 )","8.5",34,{"$f":"LOWER(Tab_Invoice[[#This Row],[ClientEmail]]&Tab_Invoice[[#This Row],[Description]])","v":"alan@scissorsapp.comgloria fisher ( 12-jan-22 )"}]
["Wellness Care","11 Bousfield Street","George","Western Cape",6530,"alan@scissorsapp.com","49_20220124","2022-01-24","2022-01-31","Gloria Fisher ( 13-Jan-22 )","8.5",3,{"$f":"LOWER(Tab_Invoice[[#This Row],[ClientEmail]]&Tab_Invoice[[#This Row],[Description]])","v":"alan@scissorsapp.comgloria fisher ( 13-jan-22 )"}]
["Wellness Care","11 Bousfield Street","George","Western Cape",6530,"alan@scissorsapp.com","49_20220124","2022-01-24","2022-01-31","Gloria Fisher ( 11-Jan-22 )","8.5",404]
["Wellness Care","11 Bousfield Street","George","Western Cape",6530,"alan@scissorsapp.com","49_20220124","2022-01-24","2022-01-31","Gloria Fisher ( 12-Jan-22 )","8.5",34]
["Wellness Care","11 Bousfield Street","George","Western Cape",6530,"alan@scissorsapp.com","49_20220124","2022-01-24","2022-01-31","Gloria Fisher ( 13-Jan-22 )","8.5",3]
["Wellness Care","11 Bousfield Street","George","Western Cape",6530,"alan@scissorsapp.com","49_20220124","2022-01-24","2022-01-31","Gloria Fisher ( 11-Jan-22 )","8.5",404]
["Wellness Care","11 Bousfield Street","George","Western Cape",6530,"alan@scissorsapp.com","49_20220124","2022-01-24","2022-01-31","Gloria Fisher ( 12-Jan-22 )","8.5",34]
["Wellness Care","11 Bousfield Street","George","Western Cape",6530,"alan@scissorsapp.com","49_20220124","2022-01-24","2022-01-31","Gloria Fisher ( 13-Jan-22 )","8.5",3]
["Wellness Care","11 Bousfield Street","George","Western Cape",6530,"alan@scissorsapp.com","49_20220124","2022-01-24","2022-01-31","Gloria Fisher ( 11-Jan-22 )","8.5",404]
["Wellness Care","11 Bousfield Street","George","Western Cape",6530,"alan@scissorsapp.com","49_20220124","2022-01-24","2022-01-31","Gloria Fisher ( 12-Jan-22 )","8.5",34]
["Wellness Care","11 Bousfield Street","George","Western Cape",6530,"alan@scissorsapp.com","49_20220124","2022-01-24","2022-01-31","Gloria Fisher ( 13-Jan-22 )","8.5",3]
["Wellness Care","11 Bousfield Street","George","Western Cape",6530,"alan@scissorsapp.com","49_20220124","2022-01-24","2022-01-31","Gloria Fisher ( 11-Jan-22 )","8.5",404]
["Wellness Care","11 Bousfield Street","George","Western Cape",6530,"alan@scissorsapp.com","49_20220124","2022-01-24","2022-01-31","Gloria Fisher ( 12-Jan-22 )","8.5",34]
["Wellness Care","11 Bousfield Street","George","Western Cape",6530,"alan@scissorsapp.com","49_20220124","2022-01-24","2022-01-31","Gloria Fisher ( 13-Jan-22 )","8.5",3]
["Wellness Care","11 Bousfield Street","George","Western Cape",6530,"alan@scissorsapp.com","49_20220124","2022-01-24","2022-01-31","Gloria Fisher ( 11-Jan-22 )","8.5",404]
["Wellness Care","11 Bousfield Street","George","Western Cape",6530,"alan@scissorsapp.com","49_20220124","2022-01-24","2022-01-31","Gloria Fisher ( 12-Jan-22 )","8.5",34]
["Wellness Care","11 Bousfield Street","George","Western Cape",6530,"alan@scissorsapp.com","49_20220124","2022-01-24","2022-01-31","Gloria Fisher ( 12-Jan-22 )","8.5",3]
["Wellness Care","11 Bousfield Street","George","Western Cape",6530,"alan@scissorsapp.com","49_20220124","2022-01-24","2022-01-31","Gloria Fisher ( 11-Jan-22 )","8.5",404]
["Wellness Care","11 Bousfield Street","George","Western Cape",6530,"alan@scissorsapp.com","49_20220124","2022-01-24","2022-01-31","Gloria Fisher ( 12-Jan-22 )","8.5",34]
["Wellness Care","11 Bousfield Street","George","Western Cape",6530,"alan@scissorsapp.com","49_20220124","2022-01-24","2022-01-31","Gloria Fisher ( 13-Jan-22 )","8.5",3]

{"sheet":"Invoice","index":2,"n_rows":39,"n_cols":5,"rows_kept":39,"cut":false,"hidden":false,"merged":[[1,3,2,4]]}
[]
["Scissors Demo Agency"]
[]
[]
[null,"Invoice Date 24/01/2022",null,"Invoice Number","49_20220124"]
[]
[null,"Wellness Care"]
[null,"alan@scissorsapp.com"]
[null,"George"]
[null,"Western Cape"]
[null,6530]
[]
[null,"Description","Hours","Rate","Amount"]
[null,"Derek Chandler ( 10-Jan-22 )",8.5,20,{"$f":"Tab_addinvoice[[#This Row],[Rate]]*Tab_addinvoice[[#This Row],[Hours]]","v":170}]
[null,"Gloria Fisher ( 11-Jan-22 )",8.5,404,{"$f":"Tab_addinvoice[[#This Row],[Rate]]*Tab_addinvoice[[#This Row],[Hours]]","v":3434}]
[null,"Gloria Fisher ( 12-Jan-22 )",8.5,34,{"$f":"Tab_addinvoice[[#This Row],[Rate]]*Tab_addinvoice[[#This Row],[Hours]]","v":289}]
[null,"Gloria Fisher ( 13-Jan-22 )",8.5,3,{"$f":"Tab_addinvoice[[#This Row],[Rate]]*Tab_addinvoice[[#This Row],[Hours]]","v":25.5}]
[null,"Gloria Fisher ( 11-Jan-22 )",8.5,404,{"$f":"Tab_addinvoice[[#This Row],[Rate]]*Tab_addinvoice[[#This Row],[Hours]]","v":3434}]
[null,"Gloria Fisher ( 12-Jan-22 )",8.5,34,{"$f":"Tab_addinvoice[[#This Row],[Rate]]*Tab_addinvoice[[#This Row],[Hours]]","v":289}]
[null,"Gloria Fisher ( 13-Jan-22 )",8.5,3,{"$f":"Tab_addinvoice[[#This Row],[Rate]]*Tab_addinvoice[[#This Row],[Hours]]","v":25.5}]
[null,"Gloria Fisher ( 11-Jan-22 )",8.5,404,{"$f":"Tab_addinvoice[[#This Row],[Rate]]*Tab_addinvoice[[#This Row],[Hours]]","v":3434}]
[null,"Gloria Fisher ( 12-Jan-22 )",8.5,34,{"$f":"Tab_addinvoice[[#This Row],[Rate]]*Tab_addinvoice[[#This Row],[Hours]]","v":289}]
[null,"Gloria Fisher ( 13-Jan-22 )",8.5,3,{"$f":"Tab_addinvoice[[#This Row],[Rate]]*Tab_addinvoice[[#This Row],[Hours]]","v":25.5}]
[null,"Gloria Fisher ( 11-Jan-22 )",8.5,404,{"$f":"Tab_addinvoice[[#This Row],[Rate]]*Tab_addinvoice[[#This Row],[Hours]]","v":3434}]
[null,"Gloria Fisher ( 12-Jan-22 )",8.5,34,{"$f":"Tab_addinvoice[[#This Row],[Rate]]*Tab_addinvoice[[#This Row],[Hours]]","v":289}]
[null,"Gloria Fisher ( 13-Jan-22 )",8.5,3,{"$f":"Tab_addinvoice[[#This Row],[Rate]]*Tab_addinvoice[[#This Row],[Hours]]","v":25.5}]
[null,"Gloria Fisher ( 11-Jan-22 )",8.5,404,{"$f":"Tab_addinvoice[[#This Row],[Rate]]*Tab_addinvoice[[#This Row],[Hours]]","v":3434}]
[null,"Gloria Fisher ( 12-Jan-22 )",8.5,34,{"$f":"Tab_addinvoice[[#This Row],[Rate]]*Tab_addinvoice[[#This Row],[Hours]]","v":289}]
[null,"Gloria Fisher ( 13-Jan-22 )",8.5,3,{"$f":"Tab_addinvoice[[#This Row],[Rate]]*Tab_addinvoice[[#This Row],[Hours]]","v":25.5}]
[null,"Gloria Fisher ( 11-Jan-22 )",8.5,404,{"$f":"Tab_addinvoice[[#This Row],[Rate]]*Tab_addinvoice[[#This Row],[Hours]]","v":3434}]
[null,"Gloria Fisher ( 12-Jan-22 )",8.5,34,{"$f":"Tab_addinvoice[[#This Row],[Rate]]*Tab_addinvoice[[#This Row],[Hours]]","v":289}]
[null,"Gloria Fisher ( 12-Jan-22 )",8.5,3,{"$f":"Tab_addinvoice[[#This Row],[Rate]]*Tab_addinvoice[[#This Row],[Hours]]","v":25.5}]
[null,"Gloria Fisher ( 11-Jan-22 )",8.5,404,{"$f":"Tab_addinvoice[[#This Row],[Rate]]*Tab_addinvoice[[#This Row],[Hours]]","v":3434}]
[null,"Gloria Fisher ( 12-Jan-22 )",8.5,34,{"$f":"Tab_addinvoice[[#This Row],[Rate]]*Tab_addinvoice[[#This Row],[Hours]]","v":289}]
[null,"Gloria Fisher ( 13-Jan-22 )",8.5,3,{"$f":"Tab_addinvoice[[#This Row],[Rate]]*Tab_addinvoice[[#This Row],[Hours]]","v":25.5}]
[]
[null,"Thank you for your business!",null,"Sub Total",{"$f":"SUM(Tab_addinvoice[Amount])","v":26409.5}]
[null,"Our payment terms are 14 days.",null,{"$f":"CONCATENATE(\"Tax (\", Instructions!B28*100, \"%)\")","v":"Tax (15%)"},{"$f":"E37*Instructions!B28","v":3961.4249999999997}]
[null,null,null,"Total",{"$f":"E37+E38","v":30370.924999999999}]