{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Invoice","Product","Customer"],"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":"Invoice","index":0,"n_rows":28,"n_cols":21,"rows_kept":28,"cut":false,"hidden":false,"merged":[[10,7,11,7],[10,8,10,9],[10,10,10,11],[10,3,11,3],[10,1,11,1],[10,2,11,2],[10,4,11,4],[10,5,11,5],[10,6,11,6],[21,1,21,5],[18,6,18,11],[19,6,19,11],[20,6,20,11],[21,6,21,11],[3,4,3,5],[3,10,3,11],[3,8,3,9],[3,6,3,7],[1,1,1,11],[2,1,2,11],[3,1,3,2],[4,1,4,6],[4,7,4,11],[5,7,5,11],[6,7,6,11],[5,1,5,5],[6,1,6,5],[17,1,17,11],[25,1,26,11],[7,7,7,11],[8,8,8,11],[8,3,8,6],[7,1,7,5],[22,1,22,7],[22,8,22,10],[23,1,23,2],[23,3,23,7],[23,8,24,11],[24,1,24,2],[24,3,24,7],[18,1,18,5],[19,1,19,5],[20,1,20,5]]}
[]
[null,"The Blue Door Book Store"]
[null,"GST INVOICE "]
[null,"Invoice No",null,2,"State Code",null,"ON",null,"Date",null,{"$f":"TODAY()","v":"2022-08-29"}]
[null,"SHIP TO",null,null,null,null,null,"BILL FROM"]
[null,{"$f":"IFERROR(VLOOKUP($C$9,Customer!$B$5:$E$10,2,FALSE),\"\")","v":"Z "},null,null,null,null,null,"The Blue Door Book Store"]
[null,{"$f":"IFERROR(VLOOKUP($C$9,Customer!$B$5:$E$10,3,FALSE),\"\")","v":"Kingston"},null,null,null,null,null,"Ottawa, Ontario"]
[null,{"$f":"IFERROR(VLOOKUP($C$9,Customer!$B$5:$E$10,4,FALSE),\"\")","v":"+14378863136"},null,null,null,null,null,"Contect Number: +14378862659"]
[null,"GSTIN","ONFSDCXXXX5D1ZR",null,null,null,null,"GSTIN","ONAACXXXX5D1ET"]
[]
[null,"Serial","HSN Code","Book Name","Qty","Unit Price","Amount","Taxable Amount","CGST",null,"SGST"]
[null,null,null,null,null,null,null,null,"Rate","Amount","Rate","Amount"]
[null,1,801,{"$f":"IFERROR(VLOOKUP(C13,Product!B5:F9,2,FALSE),\"\")","v":"Divergent"},50,{"$f":"IFERROR(VLOOKUP(C13,Product!B5:F9,3,FALSE),\"\")","v":10},{"$f":"E13*F13","v":500},{"$f":"J13+L13","v":35},{"$f":"IFERROR(VLOOKUP(C13,Product!B5:F9,4,FALSE),\"\")","v":0.03},{"$f":"G13*I13","v":15},{"$f":"IFERROR(VLOOKUP(C13,Product!B5:F9,5,FALSE),\"\")","v":0.04},{"$f":"G13*K13","v":20}]
[null,2,810,{"$f":"IFERROR(VLOOKUP(C14,Product!B6:F10,2,FALSE),\"\")","v":"Speak"},45,{"$f":"IFERROR(VLOOKUP(C14,Product!B6:F10,3,FALSE),\"\")","v":12},{"$f":"E14*F14","v":540},{"$f":"J14+L14","v":32.400000000000006},{"$f":"IFERROR(VLOOKUP(C14,Product!B6:F10,4,FALSE),\"\")","v":0.02},{"$f":"G14*I14","v":10.8},{"$f":"IFERROR(VLOOKUP(C14,Product!B6:F10,5,FALSE),\"\")","v":0.04},{"$f":"G14*K14","v":21.6}]
[null,3,807,{"$f":"IFERROR(VLOOKUP(C15,Product!B7:F11,2,FALSE),\"\")","v":"Dawn"},75,{"$f":"IFERROR(VLOOKUP(C15,Product!B7:F11,3,FALSE),\"\")","v":8},600,66,{"$f":"IFERROR(VLOOKUP(C15,Product!B7:F11,4,FALSE),\"\")","v":0.05},30,{"$f":"IFERROR(VLOOKUP(C15,Product!B7:F11,5,FALSE),\"\")","v":0.06},36]
[null,4,808,{"$f":"IFERROR(VLOOKUP(C16,Product!B8:F12,2,FALSE),\"\")","v":"Vicious"},60,{"$f":"IFERROR(VLOOKUP(C16,Product!B8:F12,3,FALSE),\"\")","v":7},420,33.6,{"$f":"IFERROR(VLOOKUP(C16,Product!B8:F12,4,FALSE),\"\")","v":0.04},16.8,{"$f":"IFERROR(VLOOKUP(C16,Product!B8:F12,5,FALSE),\"\")","v":0.04},16.8]
[null,5,809,{"$f":"IFERROR(VLOOKUP(C17,Product!B9:F13,2,FALSE),\"\")","v":"Riggs"},40,{"$f":"IFERROR(VLOOKUP(C17,Product!B9:F13,3,FALSE),\"\")","v":9},360,39.599999999999994,{"$f":"IFERROR(VLOOKUP(C17,Product!B9:F13,4,FALSE),\"\")","v":0.05},18,{"$f":"IFERROR(VLOOKUP(C17,Product!B9:F13,5,FALSE),\"\")","v":0.06},21.599999999999998]
[null,"Total Amount"]
[null,"Amount",null,null,null,null,{"$f":"SUM(G13:G17)","v":2420}]
[null,"CGST",null,null,null,null,{"$f":"SUM(J13:J17)","v":90.6}]
[null,"SGST",null,null,null,null,{"$f":"SUM(L13:L17)","v":115.99999999999999}]
[null,"Total Amount",null,null,null,null,{"$f":"SUM(G19:L21)","v":2626.6}]
[null,"Bank Details"]
[null,"A/C Name",null,"Michael James",null,null,null,null,"Sign…......................................"]
[null," A/C No.",null,"0034567"]
[null,"Terms & Conditions:-"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"l"]

{"sheet":"Product","index":1,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Product Details"]
[]
[null,"HSN Code","Book Name","Unit Price","CGST","SGST"]
[null,801,"Divergent",10,0.03,0.04]
[null,810,"Speak",12,0.02,0.04]
[null,807,"Dawn",8,0.05,0.06]
[null,808,"Vicious",7,0.04,0.04]
[null,809,"Riggs",9,0.05,0.06]

{"sheet":"Customer","index":2,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Company Details"]
[]
[null,"GSTIN","Company Name","Area","Contact No"]
[null,"ONAAACXXXX5D1Z4","X ","Windsor","+14378863164"]
[null,"ONXCACXXXX5D1ZY","Y ","Toronto","+14378861224"]
[null,"ONFSDCXXXX5D1ZR","Z ","Kingston","+14378863136"]
[null,"ONAAACXXXX5D1E5","A ","Thunder Bay","+14378862847"]
[null,"ONAAACXXXX5D169","B ","Ottawa","+14378863124"]
[null,"ONAAACXXXX5D1G6","C ","Sarnia","+14378862656"]