{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Template","Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Template","index":0,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[[18,0,18,7],[19,0,20,7],[21,0,21,7],[5,0,5,2],[5,3,5,7],[6,5,7,5],[6,6,7,6],[6,7,7,7],[1,0,1,7],[2,0,2,2],[3,0,3,2],[4,0,4,2],[2,3,2,7],[3,3,3,7],[4,3,4,7],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,7,3],[6,4,7,4]]}
[]
["Price List"]
["Company Name",null,null,"XYZ"]
["Address",null,null,"Ottawa, Ontario"]
["Contact Number",null,null,14378862659]
["Date",null,null,{"$f":"TODAY()","v":"2022-02-10"}]
["Serial","Product Code","Product","Qty","Unit Price","Amount","VAT","Total Price"]
[]
[1,808,{"$f":"IFERROR(VLOOKUP(B9,Data!$B$4:$E$13,2,FALSE),\"\")","v":"Apple"},100,{"$f":"IFERROR(VLOOKUP(B9,Data!$B$4:$E$13,3,FALSE),\"\")","v":4},{"$f":"D9*E9","v":400},{"$f":"IFERROR(VLOOKUP(B9,Data!$B$4:$E$13,4,FALSE),\"\")","v":0.04},{"$f":"F9+F9*G9","v":416}]
[2,807,{"$f":"IFERROR(VLOOKUP(B10,Data!$B$4:$E$13,2,FALSE),\"\")","v":"Watermelon"},200,{"$f":"IFERROR(VLOOKUP(B10,Data!$B$4:$E$13,3,FALSE),\"\")","v":7},{"$f":"D10*E10","v":1400},{"$f":"IFERROR(VLOOKUP(B10,Data!$B$4:$E$13,4,FALSE),\"\")","v":0.05},{"$f":"F10+F10*G10","v":1470}]
[3,809,{"$f":"IFERROR(VLOOKUP(B11,Data!$B$4:$E$13,2,FALSE),\"\")","v":"Apricot"},300,{"$f":"IFERROR(VLOOKUP(B11,Data!$B$4:$E$13,3,FALSE),\"\")","v":3},900,{"$f":"IFERROR(VLOOKUP(B11,Data!$B$4:$E$13,4,FALSE),\"\")","v":0.05},945]
[4,811,{"$f":"IFERROR(VLOOKUP(B12,Data!$B$4:$E$13,2,FALSE),\"\")","v":"Jackfruit"},400,{"$f":"IFERROR(VLOOKUP(B12,Data!$B$4:$E$13,3,FALSE),\"\")","v":9},3600,{"$f":"IFERROR(VLOOKUP(B12,Data!$B$4:$E$13,4,FALSE),\"\")","v":0.05},3780]
[5,815,{"$f":"IFERROR(VLOOKUP(B13,Data!$B$4:$E$13,2,FALSE),\"\")","v":"Orange"},500,{"$f":"IFERROR(VLOOKUP(B13,Data!$B$4:$E$13,3,FALSE),\"\")","v":8},4000,{"$f":"IFERROR(VLOOKUP(B13,Data!$B$4:$E$13,4,FALSE),\"\")","v":0.06},4240]
[6,811,{"$f":"IFERROR(VLOOKUP(B14,Data!$B$4:$E$13,2,FALSE),\"\")","v":"Jackfruit"},600,{"$f":"IFERROR(VLOOKUP(B14,Data!$B$4:$E$13,3,FALSE),\"\")","v":9},5400,{"$f":"IFERROR(VLOOKUP(B14,Data!$B$4:$E$13,4,FALSE),\"\")","v":0.05},5670]
[7,814,{"$f":"IFERROR(VLOOKUP(B15,Data!$B$4:$E$13,2,FALSE),\"\")","v":"Guava"},700,{"$f":"IFERROR(VLOOKUP(B15,Data!$B$4:$E$13,3,FALSE),\"\")","v":4},2800,{"$f":"IFERROR(VLOOKUP(B15,Data!$B$4:$E$13,4,FALSE),\"\")","v":7.0000000000000007E-2},2996]
[8,814,{"$f":"IFERROR(VLOOKUP(B16,Data!$B$4:$E$13,2,FALSE),\"\")","v":"Guava"},800,{"$f":"IFERROR(VLOOKUP(B16,Data!$B$4:$E$13,3,FALSE),\"\")","v":4},3200,{"$f":"IFERROR(VLOOKUP(B16,Data!$B$4:$E$13,4,FALSE),\"\")","v":7.0000000000000007E-2},3424]
[9,815,{"$f":"IFERROR(VLOOKUP(B17,Data!$B$4:$E$13,2,FALSE),\"\")","v":"Orange"},900,{"$f":"IFERROR(VLOOKUP(B17,Data!$B$4:$E$13,3,FALSE),\"\")","v":8},7200,{"$f":"IFERROR(VLOOKUP(B17,Data!$B$4:$E$13,4,FALSE),\"\")","v":0.06},7632]
[]
["Discounts"]
["• Return customers get a 10% discount on all tax returns"]
[]
["• $20 discount on your next invoice for referring a new client"]

{"sheet":"Data","index":1,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Product Details"]
[]
[null,"Product Code","Product Name","Unit Price","VAT"]
[null,801,"Coconut",5,0.03]
[null,810,"Kiwi",3,0.02]
[null,807,"Watermelon",7,0.05]
[null,808,"Apple",4,0.04]
[null,809,"Apricot",3,0.05]
[null,811,"Jackfruit",9,0.05]
[null,815,"Orange",8,0.06]
[null,814,"Guava",4,7.0000000000000007E-2]
[null,813,"Lemon",7,0.05]