{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Home","Invoice Entry","Invoice","Invoice_2","All Invoices","Item List","Customers","Master Data","Reprint","Invoice_r"],"not_rendered":{"charts":0,"images":17,"macros":1,"external_links":0,"defined_names":7,"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":"row_number_cap","date_system":"1900"}

{"sheet":"Home","index":0,"n_rows":21,"n_cols":1,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Enter your Business Details: "]
["Name:"]
["Plot No:"]
["Area / Locality:"]
["City:"]
["State:"]
["Pincode:"]
["Phone:"]
["Email:"]
["GSTIN:"]
["PAN:"]
["Note: These will be displayed on Invoice"]
[]
[]
[]
[]
[]
[]
[]
["Coded by: Pratik D"]
["For Customisations / Improvements mail me at: easyexcel.prd@gmail.com"]

{"sheet":"Invoice Entry","index":1,"n_rows":29,"n_cols":51,"rows_kept":29,"cut":false,"hidden":false,"merged":[[28,0,28,1],[0,0,0,8]],"read":"row_number_cap"}
["New Invoice Entry",null,null,null,null,null,null,null,null,{"$f":"TEXT(TODAY(),\"dd/mm/yyyy\")","v":"05/01/2020"},"Customers",null,null,null,null,null,{"$f":"Home!B6","v":0},null,null,"Invoice Number","Date","Bill To Name","Plot No.","Area / Locality","City","Pincode","GSTIN","State","Phone Number","Ship To Name","Plot No.","Area / Locality","City","Pincode","GSTIN","State","Phone Number","Item Code","Description of Goods","HSN","Quantity","UoM","Rate","Taxable Value","IGST Rate","IGST","CGST Rate","CGST","SGST Rate","SGST","Total"]
[null,null,null,null,null,null,null,null,null,"04/01/2020",null,null,null,null,null,null,{"$f":"IFERROR(IF(Q1=Q9,\"Within_State\",\"Interstate\"),\"Within_State\")","v":"Within_State"},null,{"$f":"ISBLANK(A12)","v":true},{"$f":"$J$4","v":1},{"$f":"$J$2","v":"04/01/2020"},{"$f":"K$8","v":"One Time Customer"},{"$f":"L$8","v":"URD"},0,0,0,"URD",0,0,{"$f":"K$9","v":"One Time Customer"},{"$f":"L$9","v":"URD"},0,0,0,"URD",0,0,{"$f":"A12","v":0},{"$f":"B12","v":""},{"$f":"K12","v":""},{"$f":"C12","v":0},{"$f":"D12","v":""},"","",{"$f":"L12","v":0},{"$f":"IFERROR(AR2*AS2,0)","v":0},{"$f":"M12","v":0},{"$f":"IFERROR(AR2*AU2,0)","v":0},{"$f":"N12","v":0},{"$f":"IFERROR(AR2*AW2,0)","v":0},{"$f":"IFERROR(AR2+AT2+AV2+AX2,0)","v":0}]
["Date:",null,null,"Invoice Number:",null,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"ISBLANK(A13)","v":true},{"$f":"$J$4","v":1},{"$f":"$J$2","v":"04/01/2020"},{"$f":"K$8","v":"One Time Customer"},{"$f":"L$8","v":"URD"},{"$f":"M$8","v":0},{"$f":"N$8","v":0},{"$f":"O$8","v":0},{"$f":"P$8","v":"URD"},{"$f":"Q$8","v":0},{"$f":"R$8","v":0},{"$f":"K$9","v":"One Time Customer"},{"$f":"L$9","v":"URD"},{"$f":"M$9","v":0},{"$f":"N$9","v":0},{"$f":"O$9","v":0},{"$f":"P$9","v":"URD"},{"$f":"Q$9","v":0},{"$f":"R$9","v":0},{"$f":"A13","v":0},"",{"$f":"K13","v":""},{"$f":"C13","v":0},{"$f":"D13","v":""},{"$f":"E13","v":""},{"$f":"F13","v":""},{"$f":"L13","v":0},{"$f":"IFERROR(AR3*AS3,0)","v":0},{"$f":"M13","v":0},{"$f":"IFERROR(AR3*AU3,0)","v":0},{"$f":"N13","v":0},{"$f":"IFERROR(AR3*AW3,0)","v":0},{"$f":"IFERROR(AR3+AT3+AV3+AX3,0)","v":0}]
[null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,true,1,"04/01/2020","One Time Customer","URD",0,0,0,"URD",0,0,"One Time Customer","URD",0,0,0,"URD",0,0,0,"","",0,"","","",0,0,0,0,0,0,0]
["Bill To:",null,null,null,null,null,null,null,null,"",{"$f":"\"!A\"&$J$8+1","v":"!A2"},{"$f":"\"!B\"&$J$8+1","v":"!B2"},{"$f":"\"!C\"&$J$8+1","v":"!C2"},{"$f":"\"!D\"&$J$8+1","v":"!D2"},{"$f":"\"!E\"&$J$8+1","v":"!E2"},{"$f":"\"!F\"&$J$8+1","v":"!F2"},{"$f":"\"!G\"&$J$8+1","v":"!G2"},{"$f":"\"!H\"&$J$8+1","v":"!H2"},true,1,"04/01/2020","One Time Customer","URD",0,0,0,"URD",0,0,"One Time Customer","URD",0,0,0,"URD",0,0,0,"","",0,"","","",0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,"",{"$f":"\"!A\"&$J$9+1","v":"!A2"},{"$f":"\"!B\"&$J$9+1","v":"!B2"},{"$f":"\"!C\"&$J$9+1","v":"!C2"},{"$f":"\"!D\"&$J$9+1","v":"!D2"},{"$f":"\"!E\"&$J$9+1","v":"!E2"},{"$f":"\"!F\"&$J$9+1","v":"!F2"},{"$f":"\"!G\"&$J$9+1","v":"!G2"},{"$f":"\"!H\"&$J$9+1","v":"!H2"},true,1,"04/01/2020","One Time Customer","URD",0,0,0,"URD",0,0,"One Time Customer","URD",0,0,0,"URD",0,0,0,"","",0,"","","",0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,"Name","Plot No.","Area / Locality","City","Pincode","GSTIN","State","Phone Number",true,1,"04/01/2020","One Time Customer","URD",0,0,0,"URD",0,0,"One Time Customer","URD",0,0,0,"URD",0,0,0,"","",0,"","","",0,0,0,0,0,0,0]
["Ship To:",null,null,null,null,null,null,null,null,1,{"$f":"INDIRECT($K$1&K5)","v":"One Time Customer"},{"$f":"INDIRECT($K$1&L5)","v":"URD"},0,0,0,"URD",0,0,true,1,"04/01/2020","One Time Customer","URD",0,0,0,"URD",0,0,"One Time Customer","URD",0,0,0,"URD",0,0,0,"","",0,"","","",0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,1,{"$f":"INDIRECT($K$1&K6)","v":"One Time Customer"},{"$f":"INDIRECT($K$1&L6)","v":"URD"},0,0,0,"URD",0,0,true,1,"04/01/2020","One Time Customer","URD",0,0,0,"URD",0,0,"One Time Customer","URD",0,0,0,"URD",0,0,0,"","",0,"","","",0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,1,"04/01/2020","One Time Customer","URD",0,0,0,"URD",0,0,"One Time Customer","URD",0,0,0,"URD",0,0,0,"","",0,"","","",0,0,0,0,0,0,0]
["Item","Item Description","Qty","Unit","Rate","Taxable Value",null,null,null,null,"HSN","IGST","CGST","SGST",null,null,null,null,true,1,"04/01/2020","One Time Customer","URD",0,0,0,"URD",0,0,"One Time Customer","URD",0,0,0,"URD",0,0,0,"","",0,"","","",0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(VLOOKUP(A12,'Item List'!A:H,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(VLOOKUP(A12,'Item List'!A:H,4,0),'Master Data'!A:B,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A12,'Item List'!A:H,5,0),\"\")","v":""},{"$f":"IFERROR(C12*E12,\"\")","v":""},null,null,null,null,{"$f":"IFERROR(VLOOKUP(A12,'Item List'!A:H,3,0),\"\")","v":""},{"$f":"IF($Q$1=$Q$9,0,IFERROR(VLOOKUP(A12,'Item List'!A:H,6,0),0))","v":0},{"$f":"IF($Q$1=$Q$9,IFERROR(VLOOKUP(A12,'Item List'!A:H,7,0),0),0)","v":0},{"$f":"IF($Q$1=$Q$9,IFERROR(VLOOKUP(A12,'Item List'!A:H,8,0),0),0)","v":0},null,null,null,null,true,1,"04/01/2020","One Time Customer","URD",0,0,0,"URD",0,0,"One Time Customer","URD",0,0,0,"URD",0,0,0,"","",0,"","","",0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(VLOOKUP(A13,'Item List'!A:H,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(VLOOKUP(A13,'Item List'!A:H,4,0),'Master Data'!A:B,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A13,'Item List'!A:H,5,0),\"\")","v":""},{"$f":"IFERROR(C13*E13,\"\")","v":""},null,null,null,null,{"$f":"IFERROR(VLOOKUP(A13,'Item List'!A:H,3,0),\"\")","v":""},{"$f":"IF($Q$1=$Q$9,0,IFERROR(VLOOKUP(A13,'Item List'!A:H,6,0),0))","v":0},{"$f":"IF($Q$1=$Q$9,IFERROR(VLOOKUP(A13,'Item List'!A:H,7,0),0),0)","v":0},{"$f":"IF($Q$1=$Q$9,IFERROR(VLOOKUP(A13,'Item List'!A:H,8,0),0),0)","v":0},null,null,null,null,true,1,"04/01/2020","One Time Customer","URD",0,0,0,"URD",0,0,"One Time Customer","URD",0,0,0,"URD",0,0,0,"","",0,"","","",0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(VLOOKUP(A14,'Item List'!A:H,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(VLOOKUP(A14,'Item List'!A:H,4,0),'Master Data'!A:B,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A14,'Item List'!A:H,5,0),\"\")","v":""},{"$f":"IFERROR(C14*E14,\"\")","v":""},null,null,null,null,{"$f":"IFERROR(VLOOKUP(A14,'Item List'!A:H,3,0),\"\")","v":""},{"$f":"IF($Q$1=$Q$9,0,IFERROR(VLOOKUP(A14,'Item List'!A:H,6,0),0))","v":0},{"$f":"IF($Q$1=$Q$9,IFERROR(VLOOKUP(A14,'Item List'!A:H,7,0),0),0)","v":0},{"$f":"IF($Q$1=$Q$9,IFERROR(VLOOKUP(A14,'Item List'!A:H,8,0),0),0)","v":0},null,null,null,null,true,1,"04/01/2020","One Time Customer","URD",0,0,0,"URD",0,0,"One Time Customer","URD",0,0,0,"URD",0,0,0,"","",0,"","","",0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(VLOOKUP(A15,'Item List'!A:H,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(VLOOKUP(A15,'Item List'!A:H,4,0),'Master Data'!A:B,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A15,'Item List'!A:H,5,0),\"\")","v":""},"",null,null,null,null,{"$f":"IFERROR(VLOOKUP(A15,'Item List'!A:H,3,0),\"\")","v":""},{"$f":"IF($Q$1=$Q$9,0,IFERROR(VLOOKUP(A15,'Item List'!A:H,6,0),0))","v":0},{"$f":"IF($Q$1=$Q$9,IFERROR(VLOOKUP(A15,'Item List'!A:H,7,0),0),0)","v":0},{"$f":"IF($Q$1=$Q$9,IFERROR(VLOOKUP(A15,'Item List'!A:H,8,0),0),0)","v":0},null,null,null,null,true,1,"04/01/2020","One Time Customer","URD",0,0,0,"URD",0,0,"One Time Customer","URD",0,0,0,"URD",0,0,0,"","",0,"","","",0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(VLOOKUP(A16,'Item List'!A:H,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(VLOOKUP(A16,'Item List'!A:H,4,0),'Master Data'!A:B,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A16,'Item List'!A:H,5,0),\"\")","v":""},"",null,null,null,null,{"$f":"IFERROR(VLOOKUP(A16,'Item List'!A:H,3,0),\"\")","v":""},{"$f":"IF($Q$1=$Q$9,0,IFERROR(VLOOKUP(A16,'Item List'!A:H,6,0),0))","v":0},{"$f":"IF($Q$1=$Q$9,IFERROR(VLOOKUP(A16,'Item List'!A:H,7,0),0),0)","v":0},{"$f":"IF($Q$1=$Q$9,IFERROR(VLOOKUP(A16,'Item List'!A:H,8,0),0),0)","v":0},null,null,null,null,true,1,"04/01/2020","One Time Customer","URD",0,0,0,"URD",0,0,"One Time Customer","URD",0,0,0,"URD",0,0,0,"","",0,"","","",0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(VLOOKUP(A17,'Item List'!A:H,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(VLOOKUP(A17,'Item List'!A:H,4,0),'Master Data'!A:B,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A17,'Item List'!A:H,5,0),\"\")","v":""},"",null,null,null,null,{"$f":"IFERROR(VLOOKUP(A17,'Item List'!A:H,3,0),\"\")","v":""},{"$f":"IF($Q$1=$Q$9,0,IFERROR(VLOOKUP(A17,'Item List'!A:H,6,0),0))","v":0},{"$f":"IF($Q$1=$Q$9,IFERROR(VLOOKUP(A17,'Item List'!A:H,7,0),0),0)","v":0},{"$f":"IF($Q$1=$Q$9,IFERROR(VLOOKUP(A17,'Item List'!A:H,8,0),0),0)","v":0},null,null,null,null,true,1,"04/01/2020","One Time Customer","URD",0,0,0,"URD",0,0,"One Time Customer","URD",0,0,0,"URD",0,0,0,"","",0,"","","",0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(VLOOKUP(A18,'Item List'!A:H,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(VLOOKUP(A18,'Item List'!A:H,4,0),'Master Data'!A:B,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A18,'Item List'!A:H,5,0),\"\")","v":""},"",null,null,null,null,{"$f":"IFERROR(VLOOKUP(A18,'Item List'!A:H,3,0),\"\")","v":""},{"$f":"IF($Q$1=$Q$9,0,IFERROR(VLOOKUP(A18,'Item List'!A:H,6,0),0))","v":0},{"$f":"IF($Q$1=$Q$9,IFERROR(VLOOKUP(A18,'Item List'!A:H,7,0),0),0)","v":0},{"$f":"IF($Q$1=$Q$9,IFERROR(VLOOKUP(A18,'Item List'!A:H,8,0),0),0)","v":0},null,null,null,null,true,1,"04/01/2020","One Time Customer","URD",0,0,0,"URD",0,0,"One Time Customer","URD",0,0,0,"URD",0,0,0,{"$f":"B28","v":""},"",0,"","",0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(VLOOKUP(A19,'Item List'!A:H,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(VLOOKUP(A19,'Item List'!A:H,4,0),'Master Data'!A:B,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A19,'Item List'!A:H,5,0),\"\")","v":""},"",null,null,null,null,{"$f":"IFERROR(VLOOKUP(A19,'Item List'!A:H,3,0),\"\")","v":""},{"$f":"IF($Q$1=$Q$9,0,IFERROR(VLOOKUP(A19,'Item List'!A:H,6,0),0))","v":0},{"$f":"IF($Q$1=$Q$9,IFERROR(VLOOKUP(A19,'Item List'!A:H,7,0),0),0)","v":0},{"$f":"IF($Q$1=$Q$9,IFERROR(VLOOKUP(A19,'Item List'!A:H,8,0),0),0)","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(A20,'Item List'!A:H,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(VLOOKUP(A20,'Item List'!A:H,4,0),'Master Data'!A:B,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A20,'Item List'!A:H,5,0),\"\")","v":""},"",null,null,null,null,{"$f":"IFERROR(VLOOKUP(A20,'Item List'!A:H,3,0),\"\")","v":""},{"$f":"IF($Q$1=$Q$9,0,IFERROR(VLOOKUP(A20,'Item List'!A:H,6,0),0))","v":0},{"$f":"IF($Q$1=$Q$9,IFERROR(VLOOKUP(A20,'Item List'!A:H,7,0),0),0)","v":0},{"$f":"IF($Q$1=$Q$9,IFERROR(VLOOKUP(A20,'Item List'!A:H,8,0),0),0)","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(A21,'Item List'!A:H,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(VLOOKUP(A21,'Item List'!A:H,4,0),'Master Data'!A:B,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A21,'Item List'!A:H,5,0),\"\")","v":""},"",null,null,null,null,{"$f":"IFERROR(VLOOKUP(A21,'Item List'!A:H,3,0),\"\")","v":""},{"$f":"IF($Q$1=$Q$9,0,IFERROR(VLOOKUP(A21,'Item List'!A:H,6,0),0))","v":0},{"$f":"IF($Q$1=$Q$9,IFERROR(VLOOKUP(A21,'Item List'!A:H,7,0),0),0)","v":0},{"$f":"IF($Q$1=$Q$9,IFERROR(VLOOKUP(A21,'Item List'!A:H,8,0),0),0)","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(A22,'Item List'!A:H,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(VLOOKUP(A22,'Item List'!A:H,4,0),'Master Data'!A:B,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A22,'Item List'!A:H,5,0),\"\")","v":""},"",null,null,null,null,{"$f":"IFERROR(VLOOKUP(A22,'Item List'!A:H,3,0),\"\")","v":""},{"$f":"IF($Q$1=$Q$9,0,IFERROR(VLOOKUP(A22,'Item List'!A:H,6,0),0))","v":0},{"$f":"IF($Q$1=$Q$9,IFERROR(VLOOKUP(A22,'Item List'!A:H,7,0),0),0)","v":0},{"$f":"IF($Q$1=$Q$9,IFERROR(VLOOKUP(A22,'Item List'!A:H,8,0),0),0)","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(A23,'Item List'!A:H,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(VLOOKUP(A23,'Item List'!A:H,4,0),'Master Data'!A:B,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A23,'Item List'!A:H,5,0),\"\")","v":""},"",null,null,null,null,{"$f":"IFERROR(VLOOKUP(A23,'Item List'!A:H,3,0),\"\")","v":""},{"$f":"IF($Q$1=$Q$9,0,IFERROR(VLOOKUP(A23,'Item List'!A:H,6,0),0))","v":0},{"$f":"IF($Q$1=$Q$9,IFERROR(VLOOKUP(A23,'Item List'!A:H,7,0),0),0)","v":0},{"$f":"IF($Q$1=$Q$9,IFERROR(VLOOKUP(A23,'Item List'!A:H,8,0),0),0)","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(A24,'Item List'!A:H,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(VLOOKUP(A24,'Item List'!A:H,4,0),'Master Data'!A:B,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A24,'Item List'!A:H,5,0),\"\")","v":""},"",null,null,null,null,{"$f":"IFERROR(VLOOKUP(A24,'Item List'!A:H,3,0),\"\")","v":""},{"$f":"IF($Q$1=$Q$9,0,IFERROR(VLOOKUP(A24,'Item List'!A:H,6,0),0))","v":0},{"$f":"IF($Q$1=$Q$9,IFERROR(VLOOKUP(A24,'Item List'!A:H,7,0),0),0)","v":0},{"$f":"IF($Q$1=$Q$9,IFERROR(VLOOKUP(A24,'Item List'!A:H,8,0),0),0)","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(A25,'Item List'!A:H,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(VLOOKUP(A25,'Item List'!A:H,4,0),'Master Data'!A:B,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A25,'Item List'!A:H,5,0),\"\")","v":""},"",null,null,null,null,{"$f":"IFERROR(VLOOKUP(A25,'Item List'!A:H,3,0),\"\")","v":""},{"$f":"IF($Q$1=$Q$9,0,IFERROR(VLOOKUP(A25,'Item List'!A:H,6,0),0))","v":0},{"$f":"IF($Q$1=$Q$9,IFERROR(VLOOKUP(A25,'Item List'!A:H,7,0),0),0)","v":0},{"$f":"IF($Q$1=$Q$9,IFERROR(VLOOKUP(A25,'Item List'!A:H,8,0),0),0)","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(A26,'Item List'!A:H,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(VLOOKUP(A26,'Item List'!A:H,4,0),'Master Data'!A:B,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A26,'Item List'!A:H,5,0),\"\")","v":""},"",null,null,null,null,{"$f":"IFERROR(VLOOKUP(A26,'Item List'!A:H,3,0),\"\")","v":""},{"$f":"IF($Q$1=$Q$9,0,IFERROR(VLOOKUP(A26,'Item List'!A:H,6,0),0))","v":0},{"$f":"IF($Q$1=$Q$9,IFERROR(VLOOKUP(A26,'Item List'!A:H,7,0),0),0)","v":0},{"$f":"IF($Q$1=$Q$9,IFERROR(VLOOKUP(A26,'Item List'!A:H,8,0),0),0)","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(A27,'Item List'!A:H,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(VLOOKUP(A27,'Item List'!A:H,4,0),'Master Data'!A:B,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A27,'Item List'!A:H,5,0),\"\")","v":""},"",null,null,null,null,{"$f":"IFERROR(VLOOKUP(A27,'Item List'!A:H,3,0),\"\")","v":""},{"$f":"IF($Q$1=$Q$9,0,IFERROR(VLOOKUP(A27,'Item List'!A:H,6,0),0))","v":0},{"$f":"IF($Q$1=$Q$9,IFERROR(VLOOKUP(A27,'Item List'!A:H,7,0),0),0)","v":0},{"$f":"IF($Q$1=$Q$9,IFERROR(VLOOKUP(A27,'Item List'!A:H,8,0),0),0)","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(A28,'Item List'!A:H,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(VLOOKUP(A28,'Item List'!A:H,4,0),'Master Data'!A:B,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A28,'Item List'!A:H,5,0),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A28,'Item List'!A:H,3,0),\"\")","v":""},{"$f":"IF($Q$1=$Q$9,0,IFERROR(VLOOKUP(A28,'Item List'!A:H,6,0),0))","v":0},{"$f":"IF($Q$1=$Q$9,IFERROR(VLOOKUP(A28,'Item List'!A:H,7,0),0),0)","v":0},{"$f":"IF($Q$1=$Q$9,IFERROR(VLOOKUP(A28,'Item List'!A:H,8,0),0),0)","v":0}]
["Total",null,{"$f":"COUNT(C12:C28)","v":0},"Items",null,{"$f":"SUM(F12:F28)","v":0}]

{"sheet":"Invoice","index":2,"n_rows":37,"n_cols":19,"rows_kept":37,"cut":false,"hidden":true,"merged":[[0,16,1,18],[7,8,7,13],[8,8,8,13],[13,2,13,7],[14,2,14,7],[15,2,15,7],[16,2,16,7],[17,2,17,7],[12,12,12,14],[13,12,13,14],[14,12,14,14],[12,2,12,7],[9,10,9,13],[0,3,0,14],[1,3,1,14],[2,3,2,8],[2,9,2,14],[0,0,2,2],[31,15,31,18],[32,15,33,18],[32,9,33,14],[36,15,39,18],[35,15,35,18],[35,0,39,8],[31,0,33,8],[20,2,20,7],[35,12,35,14],[29,2,29,7],[30,2,30,7],[31,9,31,14],[26,2,26,7],[27,2,27,7],[28,2,28,7],[21,2,21,7],[22,2,22,7],[26,12,26,14],[23,2,23,7],[24,2,24,7],[25,2,25,7],[21,12,21,14],[24,12,24,14],[25,12,25,14],[46,2,46,7],[47,2,47,7],[48,2,48,7],[49,2,49,7],[50,2,50,7],[18,2,18,7],[19,2,19,7],[51,2,51,7],[41,2,41,7],[42,2,42,7],[43,2,43,7],[44,2,44,7],[45,2,45,7],[60,2,60,7],[61,2,61,7],[62,2,62,7],[63,2,63,7],[52,2,52,7],[53,2,53,7],[54,2,54,7],[55,2,55,7],[56,2,56,7],[57,2,57,7],[76,2,76,7],[77,2,77,7],[78,2,78,7],[36,12,36,14],[37,12,37,14],[38,12,38,14],[39,12,39,14],[40,12,40,14],[41,12,41,14],[42,12,42,14],[70,2,70,7],[71,2,71,7],[72,2,72,7],[73,2,73,7],[74,2,74,7],[75,2,75,7],[64,2,64,7],[65,2,65,7],[66,2,66,7],[67,2,67,7],[68,2,68,7],[69,2,69,7],[58,2,58,7],[59,2,59,7],[49,12,49,14],[50,12,50,14],[51,12,51,14],[52,12,52,14],[53,12,53,14],[54,12,54,14],[43,12,43,14],[44,12,44,14],[45,12,45,14],[46,12,46,14],[47,12,47,14],[48,12,48,14],[61,12,61,14],[62,12,62,14],[63,12,63,14],[64,12,64,14],[65,12,65,14],[66,12,66,14],[55,12,55,14],[56,12,56,14],[57,12,57,14],[58,12,58,14],[59,12,59,14],[60,12,60,14],[73,12,73,14],[74,12,74,14],[75,12,75,14],[76,12,76,14],[77,12,77,14],[78,12,78,14],[67,12,67,14],[68,12,68,14],[69,12,69,14],[70,12,70,14],[71,12,71,14],[72,12,72,14],[85,12,85,14],[79,2,79,7],[80,2,80,7],[81,2,81,7],[82,2,82,7],[83,2,83,7],[84,2,84,7],[79,12,79,14],[80,12,80,14],[81,12,81,14],[82,12,82,14],[83,12,83,14],[84,12,84,14],[30,0,30,1],[30,10,30,11],[6,16,6,17],[11,0,11,18],[5,1,5,6],[6,1,6,6],[7,1,7,6],[8,1,8,6],[9,2,9,6],[5,8,5,13],[6,8,6,13],[27,12,27,14],[28,12,28,14],[29,12,29,14],[30,12,30,14],[15,12,15,14],[16,12,16,14],[17,12,17,14],[18,12,18,14],[19,12,19,14],[20,12,20,14],[22,12,22,14],[23,12,23,14]]}
[null,null,null,{"$f":"Home!B2","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Tax Invoice"]
[null,null,null,{"$f":"\"Add: \"&Home!B3&\", \"&Home!B4&\", \"&Home!B5&\", \"&RIGHT(Home!B6,LEN(Home!B6)-3)&\", \"&Home!B7","v":{"$error":"#VALUE!"}}]
[null,null,null,{"$f":"\"Phone: \"&Home!B8","v":"Phone: "},null,null,null,null,null,{"$f":"\"Email: \"&Home!B9","v":"Email: "}]
[]
[null,"Bill To",null,null,null,null,null,null,"Ship To",null,null,null,null,null,null,{"$f":"\"Invoice No:   \"&'Invoice Entry'!J4","v":"Invoice No:   1"}]
[null,{"$f":"'Invoice Entry'!K8","v":"One Time Customer"},null,null,null,null,null,null,{"$f":"'Invoice Entry'!K9","v":"One Time Customer"}]
[null,{"$f":"'Invoice Entry'!L8","v":"URD"},null,null,null,null,null,null,{"$f":"'Invoice Entry'!L9","v":"URD"},null,null,null,null,null,null,"Date :",{"$f":"'Invoice Entry'!J2","v":"04/01/2020"}]
[null,{"$f":"'Invoice Entry'!M8","v":0},null,null,null,null,null,null,{"$f":"'Invoice Entry'!M9","v":0}]
[null,{"$f":"'Invoice Entry'!N8&\" - \"&'Invoice Entry'!O8","v":"0 - 0"},null,null,null,null,null,null,{"$f":"'Invoice Entry'!N9&\" - \"&'Invoice Entry'!O9","v":"0 - 0"}]
[null,"GSTIN:",{"$f":"'Invoice Entry'!P8","v":"URD"},null,null,null,null,null,"Place of Supply:",null,{"$f":"'Invoice Entry'!Q9","v":0}]
[null,null,null,null,null,null,null,null,null," "]
["Details of Supply"]
["No","Item Code","Description of Goods",null,null,null,null,null,"HSN","Quantity","UoM","Rate","Taxable Value",null,null,"CGST Rate","CGST","SGST Rate","SGST"]
[{"$f":"IF(ISBLANK(B14),\"\",1)","v":1},{"$f":"IF(ISBLANK('Invoice Entry'!A12),\"\",'Invoice Entry'!A12)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!B12),\"\",'Invoice Entry'!B12)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK('Invoice Entry'!K12),\"\",'Invoice Entry'!K12)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!C12),\"\",'Invoice Entry'!C12)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!D12),\"\",'Invoice Entry'!D12)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!E12),\"\",'Invoice Entry'!E12)","v":""},{"$f":"IFERROR(J14*L14,0)","v":0},null,null,{"$f":"IF(B14=\"\",\"\",'Invoice Entry'!M12)","v":""},{"$f":"IFERROR(M14*P14,0)","v":0},{"$f":"IF(B14=\"\",\"\",'Invoice Entry'!N12)","v":""},{"$f":"IFERROR(M14*R14,0)","v":0}]
[{"$f":"IF(B15=\"\",\"\",A14+1)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!A13),\"\",'Invoice Entry'!A13)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!B13),\"\",'Invoice Entry'!B13)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK('Invoice Entry'!K13),\"\",'Invoice Entry'!K13)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!C13),\"\",'Invoice Entry'!C13)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!D13),\"\",'Invoice Entry'!D13)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!E13),\"\",'Invoice Entry'!E13)","v":""},{"$f":"IFERROR(J15*L15,0)","v":0},null,null,{"$f":"IF(B15=\"\",\"\",'Invoice Entry'!M13)","v":""},{"$f":"IFERROR(M15*P15,0)","v":0},{"$f":"IF(B15=\"\",\"\",'Invoice Entry'!N13)","v":""},{"$f":"IFERROR(M15*R15,0)","v":0}]
[{"$f":"IF(B16=\"\",\"\",A15+1)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!A14),\"\",'Invoice Entry'!A14)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!B14),\"\",'Invoice Entry'!B14)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK('Invoice Entry'!K14),\"\",'Invoice Entry'!K14)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!C14),\"\",'Invoice Entry'!C14)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!D14),\"\",'Invoice Entry'!D14)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!E14),\"\",'Invoice Entry'!E14)","v":""},0,null,null,{"$f":"IF(B16=\"\",\"\",'Invoice Entry'!M14)","v":""},0,{"$f":"IF(B16=\"\",\"\",'Invoice Entry'!N14)","v":""},0]
[{"$f":"IF(B17=\"\",\"\",A16+1)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!A15),\"\",'Invoice Entry'!A15)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!B15),\"\",'Invoice Entry'!B15)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK('Invoice Entry'!K15),\"\",'Invoice Entry'!K15)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!C15),\"\",'Invoice Entry'!C15)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!D15),\"\",'Invoice Entry'!D15)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!E15),\"\",'Invoice Entry'!E15)","v":""},0,null,null,{"$f":"IF(B17=\"\",\"\",'Invoice Entry'!M15)","v":""},0,{"$f":"IF(B17=\"\",\"\",'Invoice Entry'!N15)","v":""},0]
[{"$f":"IF(B18=\"\",\"\",A17+1)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!A16),\"\",'Invoice Entry'!A16)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!B16),\"\",'Invoice Entry'!B16)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK('Invoice Entry'!K16),\"\",'Invoice Entry'!K16)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!C16),\"\",'Invoice Entry'!C16)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!D16),\"\",'Invoice Entry'!D16)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!E16),\"\",'Invoice Entry'!E16)","v":""},0,null,null,{"$f":"IF(B18=\"\",\"\",'Invoice Entry'!M16)","v":""},0,{"$f":"IF(B18=\"\",\"\",'Invoice Entry'!N16)","v":""},0]
["",{"$f":"IF(ISBLANK('Invoice Entry'!A17),\"\",'Invoice Entry'!A17)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!B17),\"\",'Invoice Entry'!B17)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK('Invoice Entry'!K17),\"\",'Invoice Entry'!K17)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!C17),\"\",'Invoice Entry'!C17)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!D17),\"\",'Invoice Entry'!D17)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!E17),\"\",'Invoice Entry'!E17)","v":""},0,null,null,{"$f":"IF(B19=\"\",\"\",'Invoice Entry'!M17)","v":""},0,{"$f":"IF(B19=\"\",\"\",'Invoice Entry'!N17)","v":""},0]
["",{"$f":"IF(ISBLANK('Invoice Entry'!A18),\"\",'Invoice Entry'!A18)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!B18),\"\",'Invoice Entry'!B18)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK('Invoice Entry'!K18),\"\",'Invoice Entry'!K18)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!C18),\"\",'Invoice Entry'!C18)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!D18),\"\",'Invoice Entry'!D18)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!E18),\"\",'Invoice Entry'!E18)","v":""},0,null,null,{"$f":"IF(B20=\"\",\"\",'Invoice Entry'!M18)","v":""},0,{"$f":"IF(B20=\"\",\"\",'Invoice Entry'!N18)","v":""},0]
["",{"$f":"IF(ISBLANK('Invoice Entry'!A19),\"\",'Invoice Entry'!A19)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!B19),\"\",'Invoice Entry'!B19)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK('Invoice Entry'!K19),\"\",'Invoice Entry'!K19)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!C19),\"\",'Invoice Entry'!C19)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!D19),\"\",'Invoice Entry'!D19)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!E19),\"\",'Invoice Entry'!E19)","v":""},0,null,null,{"$f":"IF(B21=\"\",\"\",'Invoice Entry'!M19)","v":""},0,{"$f":"IF(B21=\"\",\"\",'Invoice Entry'!N19)","v":""},0]
["",{"$f":"IF(ISBLANK('Invoice Entry'!A20),\"\",'Invoice Entry'!A20)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!B20),\"\",'Invoice Entry'!B20)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK('Invoice Entry'!K20),\"\",'Invoice Entry'!K20)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!C20),\"\",'Invoice Entry'!C20)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!D20),\"\",'Invoice Entry'!D20)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!E20),\"\",'Invoice Entry'!E20)","v":""},0,null,null,{"$f":"IF(B22=\"\",\"\",'Invoice Entry'!M20)","v":""},0,{"$f":"IF(B22=\"\",\"\",'Invoice Entry'!N20)","v":""},0]
["",{"$f":"IF(ISBLANK('Invoice Entry'!A21),\"\",'Invoice Entry'!A21)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!B21),\"\",'Invoice Entry'!B21)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK('Invoice Entry'!K21),\"\",'Invoice Entry'!K21)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!C21),\"\",'Invoice Entry'!C21)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!D21),\"\",'Invoice Entry'!D21)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!E21),\"\",'Invoice Entry'!E21)","v":""},0,null,null,{"$f":"IF(B23=\"\",\"\",'Invoice Entry'!M21)","v":""},0,{"$f":"IF(B23=\"\",\"\",'Invoice Entry'!N21)","v":""},0]
["",{"$f":"IF(ISBLANK('Invoice Entry'!A22),\"\",'Invoice Entry'!A22)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!B22),\"\",'Invoice Entry'!B22)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK('Invoice Entry'!K22),\"\",'Invoice Entry'!K22)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!C22),\"\",'Invoice Entry'!C22)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!D22),\"\",'Invoice Entry'!D22)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!E22),\"\",'Invoice Entry'!E22)","v":""},0,null,null,{"$f":"IF(B24=\"\",\"\",'Invoice Entry'!M22)","v":""},0,{"$f":"IF(B24=\"\",\"\",'Invoice Entry'!N22)","v":""},0]
["",{"$f":"IF(ISBLANK('Invoice Entry'!A23),\"\",'Invoice Entry'!A23)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!B23),\"\",'Invoice Entry'!B23)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK('Invoice Entry'!K23),\"\",'Invoice Entry'!K23)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!C23),\"\",'Invoice Entry'!C23)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!D23),\"\",'Invoice Entry'!D23)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!E23),\"\",'Invoice Entry'!E23)","v":""},0,null,null,{"$f":"IF(B25=\"\",\"\",'Invoice Entry'!M23)","v":""},0,{"$f":"IF(B25=\"\",\"\",'Invoice Entry'!N23)","v":""},0]
["",{"$f":"IF(ISBLANK('Invoice Entry'!A24),\"\",'Invoice Entry'!A24)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!B24),\"\",'Invoice Entry'!B24)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK('Invoice Entry'!K24),\"\",'Invoice Entry'!K24)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!C24),\"\",'Invoice Entry'!C24)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!D24),\"\",'Invoice Entry'!D24)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!E24),\"\",'Invoice Entry'!E24)","v":""},0,null,null,{"$f":"IF(B26=\"\",\"\",'Invoice Entry'!M24)","v":""},0,{"$f":"IF(B26=\"\",\"\",'Invoice Entry'!N24)","v":""},0]
["",{"$f":"IF(ISBLANK('Invoice Entry'!A25),\"\",'Invoice Entry'!A25)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!B25),\"\",'Invoice Entry'!B25)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK('Invoice Entry'!K25),\"\",'Invoice Entry'!K25)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!C25),\"\",'Invoice Entry'!C25)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!D25),\"\",'Invoice Entry'!D25)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!E25),\"\",'Invoice Entry'!E25)","v":""},0,null,null,{"$f":"IF(B27=\"\",\"\",'Invoice Entry'!M25)","v":""},0,{"$f":"IF(B27=\"\",\"\",'Invoice Entry'!N25)","v":""},0]
["",{"$f":"IF(ISBLANK('Invoice Entry'!A26),\"\",'Invoice Entry'!A26)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!B26),\"\",'Invoice Entry'!B26)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK('Invoice Entry'!K26),\"\",'Invoice Entry'!K26)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!C26),\"\",'Invoice Entry'!C26)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!D26),\"\",'Invoice Entry'!D26)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!E26),\"\",'Invoice Entry'!E26)","v":""},0,null,null,{"$f":"IF(B28=\"\",\"\",'Invoice Entry'!M26)","v":""},0,{"$f":"IF(B28=\"\",\"\",'Invoice Entry'!N26)","v":""},0]
["",{"$f":"IF(ISBLANK('Invoice Entry'!A27),\"\",'Invoice Entry'!A27)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!B27),\"\",'Invoice Entry'!B27)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK('Invoice Entry'!K27),\"\",'Invoice Entry'!K27)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!C27),\"\",'Invoice Entry'!C27)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!D27),\"\",'Invoice Entry'!D27)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!E27),\"\",'Invoice Entry'!E27)","v":""},0,null,null,{"$f":"IF(B29=\"\",\"\",'Invoice Entry'!M27)","v":""},0,{"$f":"IF(B29=\"\",\"\",'Invoice Entry'!N27)","v":""},0]
["",{"$f":"IF(ISBLANK('Invoice Entry'!A28),\"\",'Invoice Entry'!A28)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!B28),\"\",'Invoice Entry'!B28)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK('Invoice Entry'!K28),\"\",'Invoice Entry'!K28)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!C28),\"\",'Invoice Entry'!C28)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!D28),\"\",'Invoice Entry'!D28)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!E28),\"\",'Invoice Entry'!E28)","v":""},0,null,null,{"$f":"IF(B30=\"\",\"\",'Invoice Entry'!M28)","v":""},0,{"$f":"IF(B30=\"\",\"\",'Invoice Entry'!N28)","v":""},0]
[null,null,"Subtotal",null,null,null,null,null,null,{"$f":"SUM(J14:J30)","v":0},null,null,{"$f":"SUM(M14:O30)","v":0},null,null,null,{"$f":"SUM(Q14:Q30)","v":0},null,{"$f":"SUM(S14:S30)","v":0}]
[{"$f":"\"GSTIN: \"&Home!B10&\"\nPAN: \"&Home!B11","v":"GSTIN: \nPAN: "},null,null,null,null,null,null,null,null,"Total Invoice Value (INR)",null,null,null,null,null,{"$f":"M31+Q31+S31","v":0}]
[null,null,null,null,null,null,null,null,null,"Total Invoice Value (in words)",null,null,null,null,null,{"$f":"NumToWord(M31+Q31+S31)&\" Only\"","v":"Zero Only"}]
[]
[]
["Terms and Conditions\nCertified that the particulars given above are true and correct and the amount indicated represent the price actually charged and that there is no additional consideration flowing directly or indirectly from the buyer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"For \"&D1","v":"For 0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Authorised Signatory"]

{"sheet":"Invoice_2","index":3,"n_rows":37,"n_cols":17,"rows_kept":37,"cut":false,"hidden":true,"merged":[[2,3,2,8],[2,9,2,14],[0,3,0,14],[1,3,1,14],[0,15,1,16],[0,0,2,2],[15,2,15,7],[15,12,15,14],[16,2,16,7],[16,12,16,14],[7,1,7,6],[7,8,7,13],[8,1,8,6],[8,8,8,13],[9,2,9,6],[9,10,9,13],[5,1,5,6],[5,8,5,13],[6,1,6,6],[6,8,6,13],[17,2,17,7],[17,12,17,14],[12,2,12,7],[12,12,12,14],[13,2,13,7],[13,12,13,14],[14,2,14,7],[14,12,14,14],[21,2,21,7],[21,12,21,14],[22,2,22,7],[22,12,22,14],[23,2,23,7],[23,12,23,14],[18,2,18,7],[18,12,18,14],[19,2,19,7],[19,12,19,14],[20,2,20,7],[20,12,20,14],[27,2,27,7],[27,12,27,14],[28,2,28,7],[28,12,28,14],[29,2,29,7],[29,12,29,14],[24,2,24,7],[24,12,24,14],[25,2,25,7],[25,12,25,14],[26,2,26,7],[26,12,26,14],[35,0,39,8],[30,0,30,1],[30,2,30,7],[30,10,30,11],[30,12,30,14],[31,0,33,5],[35,12,35,16],[36,12,40,16],[32,11,33,16],[31,11,31,16],[31,6,31,10],[43,2,43,7],[43,12,43,14],[44,2,44,7],[44,12,44,14],[45,2,45,7],[45,12,45,14],[41,2,41,7],[41,12,41,14],[42,2,42,7],[42,12,42,14],[49,2,49,7],[49,12,49,14],[50,2,50,7],[50,12,50,14],[51,2,51,7],[51,12,51,14],[46,2,46,7],[46,12,46,14],[47,2,47,7],[47,12,47,14],[48,2,48,7],[48,12,48,14],[55,2,55,7],[55,12,55,14],[56,2,56,7],[56,12,56,14],[57,2,57,7],[57,12,57,14],[52,2,52,7],[52,12,52,14],[53,2,53,7],[53,12,53,14],[54,2,54,7],[54,12,54,14],[61,2,61,7],[61,12,61,14],[62,2,62,7],[62,12,62,14],[63,2,63,7],[63,12,63,14],[58,2,58,7],[58,12,58,14],[59,2,59,7],[59,12,59,14],[60,2,60,7],[60,12,60,14],[67,2,67,7],[67,12,67,14],[68,2,68,7],[68,12,68,14],[69,2,69,7],[69,12,69,14],[64,2,64,7],[64,12,64,14],[65,2,65,7],[65,12,65,14],[66,2,66,7],[66,12,66,14],[74,12,74,14],[75,2,75,7],[75,12,75,14],[70,2,70,7],[70,12,70,14],[71,2,71,7],[71,12,71,14],[72,2,72,7],[72,12,72,14],[85,12,85,14],[11,0,11,16],[82,2,82,7],[82,12,82,14],[83,2,83,7],[83,12,83,14],[84,2,84,7],[84,12,84,14],[79,2,79,7],[79,12,79,14],[80,2,80,7],[80,12,80,14],[81,2,81,7],[81,12,81,14],[32,6,33,10],[76,2,76,7],[76,12,76,14],[77,2,77,7],[77,12,77,14],[78,2,78,7],[78,12,78,14],[73,2,73,7],[73,12,73,14],[74,2,74,7]]}
[null,null,null,{"$f":"Home!B2","v":0},null,null,null,null,null,null,null,null,null,null,null,"Tax Invoice"]
[null,null,null,{"$f":"\"Add: \"&Home!B3&\", \"&Home!B4&\", \"&Home!B5&\", \"&RIGHT(Home!B6,LEN(Home!B6)-3)&\", \"&Home!B7","v":{"$error":"#VALUE!"}}]
[null,null,null,{"$f":"\"Phone: \"&Home!B8","v":"Phone: "},null,null,null,null,null,{"$f":"\"Email: \"&Home!B9","v":"Email: "}]
[]
[null,"Bill To",null,null,null,null,null,null,"Ship To",null,null,null,null,null,null,"Invoice No:",{"$f":"'Invoice Entry'!J4","v":1}]
[null,{"$f":"'Invoice Entry'!K8","v":"One Time Customer"},null,null,null,null,null,null,{"$f":"'Invoice Entry'!K9","v":"One Time Customer"}]
[null,{"$f":"'Invoice Entry'!L8","v":"URD"},null,null,null,null,null,null,{"$f":"'Invoice Entry'!L9","v":"URD"},null,null,null,null,null,null,"Date :",{"$f":"'Invoice Entry'!J2","v":"04/01/2020"}]
[null,{"$f":"'Invoice Entry'!M8","v":0},null,null,null,null,null,null,{"$f":"'Invoice Entry'!M9","v":0}]
[null,{"$f":"'Invoice Entry'!N8&\" - \"&'Invoice Entry'!O8","v":"0 - 0"},null,null,null,null,null,null,{"$f":"'Invoice Entry'!N9&\" - \"&'Invoice Entry'!O9","v":"0 - 0"}]
[null,"GSTIN:",{"$f":"'Invoice Entry'!P8","v":"URD"},null,null,null,null,null,"Place of Supply:",null,{"$f":"'Invoice Entry'!Q9","v":0}]
[]
["Details of Supply"]
["No","Item Code","Description of Goods",null,null,null,null,null,"HSN","Quantity","UoM","Rate","Taxable Value",null,null,"IGST Rate","IGST"]
[{"$f":"IF(ISBLANK(B14),\"\",1)","v":1},{"$f":"IF(ISBLANK('Invoice Entry'!A12),\"\",'Invoice Entry'!A12)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!B12),\"\",'Invoice Entry'!B12)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK('Invoice Entry'!K12),\"\",'Invoice Entry'!K12)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!C12),\"\",'Invoice Entry'!C12)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!D12),\"\",'Invoice Entry'!D12)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!E12),\"\",'Invoice Entry'!E12)","v":""},{"$f":"IFERROR(J14*L14,0)","v":0},null,null,{"$f":"IF(B14=\"\",\"\",'Invoice Entry'!L12)","v":""},{"$f":"IFERROR(M14*P14,0)","v":0}]
[{"$f":"IF(B15=\"\",\"\",A14+1)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!A13),\"\",'Invoice Entry'!A13)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!B13),\"\",'Invoice Entry'!B13)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK('Invoice Entry'!K13),\"\",'Invoice Entry'!K13)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!C13),\"\",'Invoice Entry'!C13)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!D13),\"\",'Invoice Entry'!D13)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!E13),\"\",'Invoice Entry'!E13)","v":""},{"$f":"IFERROR(J15*L15,0)","v":0},null,null,{"$f":"IF(B15=\"\",\"\",'Invoice Entry'!L13)","v":""},0]
[{"$f":"IF(B16=\"\",\"\",A15+1)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!A14),\"\",'Invoice Entry'!A14)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!B14),\"\",'Invoice Entry'!B14)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK('Invoice Entry'!K14),\"\",'Invoice Entry'!K14)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!C14),\"\",'Invoice Entry'!C14)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!D14),\"\",'Invoice Entry'!D14)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!E14),\"\",'Invoice Entry'!E14)","v":""},0,null,null,{"$f":"IF(B16=\"\",\"\",'Invoice Entry'!L14)","v":""},0]
[{"$f":"IF(B17=\"\",\"\",A16+1)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!A15),\"\",'Invoice Entry'!A15)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!B15),\"\",'Invoice Entry'!B15)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK('Invoice Entry'!K15),\"\",'Invoice Entry'!K15)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!C15),\"\",'Invoice Entry'!C15)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!D15),\"\",'Invoice Entry'!D15)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!E15),\"\",'Invoice Entry'!E15)","v":""},0,null,null,{"$f":"IF(B17=\"\",\"\",'Invoice Entry'!L15)","v":""},0]
[{"$f":"IF(B18=\"\",\"\",A17+1)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!A16),\"\",'Invoice Entry'!A16)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!B16),\"\",'Invoice Entry'!B16)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK('Invoice Entry'!K16),\"\",'Invoice Entry'!K16)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!C16),\"\",'Invoice Entry'!C16)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!D16),\"\",'Invoice Entry'!D16)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!E16),\"\",'Invoice Entry'!E16)","v":""},0,null,null,{"$f":"IF(B18=\"\",\"\",'Invoice Entry'!L16)","v":""},0]
["",{"$f":"IF(ISBLANK('Invoice Entry'!A17),\"\",'Invoice Entry'!A17)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!B17),\"\",'Invoice Entry'!B17)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK('Invoice Entry'!K17),\"\",'Invoice Entry'!K17)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!C17),\"\",'Invoice Entry'!C17)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!D17),\"\",'Invoice Entry'!D17)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!E17),\"\",'Invoice Entry'!E17)","v":""},0,null,null,{"$f":"IF(B19=\"\",\"\",'Invoice Entry'!L17)","v":""},0]
["",{"$f":"IF(ISBLANK('Invoice Entry'!A18),\"\",'Invoice Entry'!A18)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!B18),\"\",'Invoice Entry'!B18)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK('Invoice Entry'!K18),\"\",'Invoice Entry'!K18)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!C18),\"\",'Invoice Entry'!C18)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!D18),\"\",'Invoice Entry'!D18)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!E18),\"\",'Invoice Entry'!E18)","v":""},0,null,null,{"$f":"IF(B20=\"\",\"\",'Invoice Entry'!L18)","v":""},0]
["",{"$f":"IF(ISBLANK('Invoice Entry'!A19),\"\",'Invoice Entry'!A19)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!B19),\"\",'Invoice Entry'!B19)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK('Invoice Entry'!K19),\"\",'Invoice Entry'!K19)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!C19),\"\",'Invoice Entry'!C19)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!D19),\"\",'Invoice Entry'!D19)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!E19),\"\",'Invoice Entry'!E19)","v":""},0,null,null,{"$f":"IF(B21=\"\",\"\",'Invoice Entry'!L19)","v":""},0]
["",{"$f":"IF(ISBLANK('Invoice Entry'!A20),\"\",'Invoice Entry'!A20)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!B20),\"\",'Invoice Entry'!B20)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK('Invoice Entry'!K20),\"\",'Invoice Entry'!K20)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!C20),\"\",'Invoice Entry'!C20)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!D20),\"\",'Invoice Entry'!D20)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!E20),\"\",'Invoice Entry'!E20)","v":""},0,null,null,{"$f":"IF(B22=\"\",\"\",'Invoice Entry'!L20)","v":""},0]
["",{"$f":"IF(ISBLANK('Invoice Entry'!A21),\"\",'Invoice Entry'!A21)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!B21),\"\",'Invoice Entry'!B21)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK('Invoice Entry'!K21),\"\",'Invoice Entry'!K21)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!C21),\"\",'Invoice Entry'!C21)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!D21),\"\",'Invoice Entry'!D21)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!E21),\"\",'Invoice Entry'!E21)","v":""},0,null,null,{"$f":"IF(B23=\"\",\"\",'Invoice Entry'!L21)","v":""},0]
["",{"$f":"IF(ISBLANK('Invoice Entry'!A22),\"\",'Invoice Entry'!A22)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!B22),\"\",'Invoice Entry'!B22)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK('Invoice Entry'!K22),\"\",'Invoice Entry'!K22)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!C22),\"\",'Invoice Entry'!C22)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!D22),\"\",'Invoice Entry'!D22)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!E22),\"\",'Invoice Entry'!E22)","v":""},0,null,null,{"$f":"IF(B24=\"\",\"\",'Invoice Entry'!L22)","v":""},0]
["",{"$f":"IF(ISBLANK('Invoice Entry'!A23),\"\",'Invoice Entry'!A23)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!B23),\"\",'Invoice Entry'!B23)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK('Invoice Entry'!K23),\"\",'Invoice Entry'!K23)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!C23),\"\",'Invoice Entry'!C23)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!D23),\"\",'Invoice Entry'!D23)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!E23),\"\",'Invoice Entry'!E23)","v":""},0,null,null,{"$f":"IF(B25=\"\",\"\",'Invoice Entry'!L23)","v":""},0]
["",{"$f":"IF(ISBLANK('Invoice Entry'!A24),\"\",'Invoice Entry'!A24)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!B24),\"\",'Invoice Entry'!B24)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK('Invoice Entry'!K24),\"\",'Invoice Entry'!K24)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!C24),\"\",'Invoice Entry'!C24)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!D24),\"\",'Invoice Entry'!D24)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!E24),\"\",'Invoice Entry'!E24)","v":""},0,null,null,{"$f":"IF(B26=\"\",\"\",'Invoice Entry'!L24)","v":""},0]
["",{"$f":"IF(ISBLANK('Invoice Entry'!A25),\"\",'Invoice Entry'!A25)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!B25),\"\",'Invoice Entry'!B25)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK('Invoice Entry'!K25),\"\",'Invoice Entry'!K25)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!C25),\"\",'Invoice Entry'!C25)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!D25),\"\",'Invoice Entry'!D25)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!E25),\"\",'Invoice Entry'!E25)","v":""},0,null,null,{"$f":"IF(B27=\"\",\"\",'Invoice Entry'!L25)","v":""},0]
["",{"$f":"IF(ISBLANK('Invoice Entry'!A26),\"\",'Invoice Entry'!A26)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!B26),\"\",'Invoice Entry'!B26)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK('Invoice Entry'!K26),\"\",'Invoice Entry'!K26)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!C26),\"\",'Invoice Entry'!C26)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!D26),\"\",'Invoice Entry'!D26)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!E26),\"\",'Invoice Entry'!E26)","v":""},0,null,null,{"$f":"IF(B28=\"\",\"\",'Invoice Entry'!L26)","v":""},0]
["",{"$f":"IF(ISBLANK('Invoice Entry'!A27),\"\",'Invoice Entry'!A27)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!B27),\"\",'Invoice Entry'!B27)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK('Invoice Entry'!K27),\"\",'Invoice Entry'!K27)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!C27),\"\",'Invoice Entry'!C27)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!D27),\"\",'Invoice Entry'!D27)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!E27),\"\",'Invoice Entry'!E27)","v":""},0,null,null,{"$f":"IF(B29=\"\",\"\",'Invoice Entry'!L27)","v":""},0]
["",{"$f":"IF(ISBLANK('Invoice Entry'!A28),\"\",'Invoice Entry'!A28)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!B28),\"\",'Invoice Entry'!B28)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK('Invoice Entry'!K28),\"\",'Invoice Entry'!K28)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!C28),\"\",'Invoice Entry'!C28)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!D28),\"\",'Invoice Entry'!D28)","v":""},{"$f":"IF(ISBLANK('Invoice Entry'!E28),\"\",'Invoice Entry'!E28)","v":""},0,null,null,{"$f":"IF(B30=\"\",\"\",'Invoice Entry'!L28)","v":""},0]
[null,null,"Subtotal",null,null,null,null,null,null,{"$f":"SUM(J14:J30)","v":0},null,null,{"$f":"SUM(M14:O30)","v":0},null,null,null,{"$f":"SUM(Q14:Q30)","v":0}]
[{"$f":"\"GSTIN: \"&Home!B10&\"\nPAN: \"&Home!B11","v":"GSTIN: \nPAN: "},null,null,null,null,null,"Total Invoice Value (INR)",null,null,null,null,{"$f":"M31+Q31","v":0}]
[null,null,null,null,null,null,"Total Invoice Value (in words)",null,null,null,null,{"$f":"NumToWord(M31+Q31)&\" Only\"","v":"Zero Only"}]
[]
[]
["Terms and Conditions\nCertified that the particulars given above are true and correct and the amount indicated represent the price actually charged and that there is no additional consideration flowing directly or indirectly from the buyer",null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"For \"&D1","v":"For 0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Authorised Signatory"]

{"sheet":"All Invoices","index":4,"n_rows":1,"n_cols":32,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Invoice Number","Date","Bill To Name","Plot No.","Area / Locality","City","Pincode","GSTIN","State","Phone Number","Ship To Name","Plot No.","Area / Locality","City","Pincode","GSTIN","State","Phone Number","Item Code","Description of Goods","HSN","Quantity","UoM","Rate","Taxable Value","IGST Rate","IGST","CGST Rate","CGST","SGST Rate","SGST","Total"]

{"sheet":"Item List","index":5,"n_rows":1,"n_cols":8,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Item Code","Item Description","HSN","UoM","Rate","IGST Rate","CGST Rate","SGST Rate"]

{"sheet":"Customers","index":6,"n_rows":2,"n_cols":8,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Name","Plot No.","Area / Locality","City","Pincode","GSTIN","State","Phone Number"]
["One Time Customer","URD",null,{"$f":"Home!B5","v":0},{"$f":"Home!B7","v":0},"URD",{"$f":"Home!B6","v":0}]

{"sheet":"Master Data","index":7,"n_rows":37,"n_cols":11,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["Bags","bag",null,null,"01-Jammu & Kashmir",null,null,null,"Invoice Number","Date","Bill To Name"]
["Bale","bal",null,null,"02-Himachal Pradesh"]
["Bundles","bdl",null,null,"03-Punjab"]
["Box","box",null,null,"04-Chandigarh"]
["Bottles","btl",null,null,"05-Uttarakhand"]
["Bunches","bun",null,null,"06-Haryana"]
["Cans","can",null,null,"07-Delhi"]
["Cubic Meter","cbm",null,null,"08-Rajasthan"]
["Carton","ctn",null,null,"09-Uttar Pradesh"]
["Dozen","doz",null,null,"10-Bihar"]
["Drum","drm",null,null,"11-Sikkim"]
["Grams","gms",null,null,"12-Arunachal Pradesh"]
["Kilograms","kgs",null,null,"13-Nagaland"]
["Litres","ltr",null,null,"14-Manipur"]
["Millilitre","mlt",null,null,"15-Mizoram"]
["Meter","mtr",null,null,"16-Tripura"]
["Metric Ton","mts",null,null,"17-Meghalaya"]
["Numbers","nos",null,null,"18-Assam"]
["Packs","pac",null,null,"19-West Bengal"]
["Pairs","prs",null,null,"20-Jharkhand"]
["Pieces","pcs",null,null,"21-Orissa"]
["Quintal","qtl",null,null,"22-Chhattisgarh"]
["Rolls","rol",null,null,"23-Madhya Pradesh"]
["Sets","set",null,null,"24-Gujarat"]
["Square Feet","sqf",null,null,"25-Daman & Diu"]
["Square Meters","sqm",null,null,"26-Dadra & Nagar Haveli"]
["Thousands","thd",null,null,"27-Maharashtra"]
["Tonnes","ton",null,null,"28-Andhra Pradesh(Earlier)"]
["Units","unt",null,null,"29-Karnataka"]
["Others","oth",null,null,"30-Goa"]
[null,null,null,null,"31-Lakshadweep"]
[null,null,null,null,"32-Kerala"]
[null,null,null,null,"33-Tamil Nadu"]
[null,null,null,null,"34-Puducherry"]
[null,null,null,null,"35-Andaman & Nicobar Islands"]
[null,null,null,null,"36-Telangana"]
[null,null,null,null,"37-Andhra Pradesh(New)"]

{"sheet":"Reprint","index":8,"n_rows":2,"n_cols":32,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Invoice Number","Date","Bill To Name","Plot No.","Area / Locality","City","Pincode","GSTIN","State","Phone Number","Ship To Name","Plot No.","Area / Locality","City","Pincode","GSTIN","State","Phone Number","Item Code","Description of Goods","HSN","Quantity","UoM","Rate","Taxable Value","IGST Rate","IGST","CGST Rate","CGST","SGST Rate","SGST","Total"]
[16,"01/01/2020","Trial",12,"Near School","Hyderabad",451120,"28asdadddd1234n","28-Andhra Pradesh(Before Division)",254112536,"Trial",12,"Near School","Hyderabad",451120,"28asdadddd1234n","28-Andhra Pradesh(Before Division)",254112536,100123,"Laptop","080001",250,"nos",25500,6375000,0.28000000000000003,1785000.0000000002,0,0,0,0,8160000]

{"sheet":"Invoice_r","index":9,"n_rows":37,"n_cols":21,"rows_kept":37,"cut":false,"hidden":true,"merged":[[85,12,85,14],[31,9,31,15],[32,9,33,15],[32,16,33,20],[31,16,31,20],[36,16,39,20],[35,16,35,20],[82,2,82,7],[82,12,82,14],[83,2,83,7],[83,12,83,14],[84,2,84,7],[84,12,84,14],[79,2,79,7],[79,12,79,14],[80,2,80,7],[80,12,80,14],[81,2,81,7],[81,12,81,14],[76,2,76,7],[76,12,76,14],[77,2,77,7],[77,12,77,14],[78,2,78,7],[78,12,78,14],[73,2,73,7],[73,12,73,14],[74,2,74,7],[74,12,74,14],[75,2,75,7],[75,12,75,14],[70,2,70,7],[70,12,70,14],[71,2,71,7],[71,12,71,14],[72,2,72,7],[72,12,72,14],[67,2,67,7],[67,12,67,14],[68,2,68,7],[68,12,68,14],[69,2,69,7],[69,12,69,14],[64,2,64,7],[64,12,64,14],[65,2,65,7],[65,12,65,14],[66,2,66,7],[66,12,66,14],[61,2,61,7],[61,12,61,14],[62,2,62,7],[62,12,62,14],[63,2,63,7],[63,12,63,14],[58,2,58,7],[58,12,58,14],[59,2,59,7],[59,12,59,14],[60,2,60,7],[60,12,60,14],[55,2,55,7],[55,12,55,14],[56,2,56,7],[56,12,56,14],[57,2,57,7],[57,12,57,14],[52,2,52,7],[52,12,52,14],[53,2,53,7],[53,12,53,14],[54,2,54,7],[54,12,54,14],[49,2,49,7],[49,12,49,14],[50,2,50,7],[50,12,50,14],[51,2,51,7],[51,12,51,14],[46,2,46,7],[46,12,46,14],[47,2,47,7],[47,12,47,14],[48,2,48,7],[48,12,48,14],[43,2,43,7],[43,12,43,14],[44,2,44,7],[44,12,44,14],[45,2,45,7],[45,12,45,14],[39,12,39,14],[40,12,40,14],[41,2,41,7],[41,12,41,14],[42,2,42,7],[42,12,42,14],[35,0,39,8],[35,12,35,14],[36,12,36,14],[37,12,37,14],[38,12,38,14],[30,0,30,1],[30,2,30,7],[30,10,30,11],[30,12,30,14],[31,0,33,8],[27,2,27,7],[27,12,27,14],[28,2,28,7],[28,12,28,14],[29,2,29,7],[29,12,29,14],[24,2,24,7],[24,12,24,14],[25,2,25,7],[25,12,25,14],[26,2,26,7],[26,12,26,14],[21,2,21,7],[21,12,21,14],[22,2,22,7],[22,12,22,14],[23,2,23,7],[23,12,23,14],[18,2,18,7],[18,12,18,14],[19,2,19,7],[19,12,19,14],[20,2,20,7],[20,12,20,14],[15,2,15,7],[15,12,15,14],[16,2,16,7],[16,12,16,14],[17,2,17,7],[17,12,17,14],[11,0,11,20],[12,2,12,7],[12,12,12,14],[13,2,13,7],[13,12,13,14],[14,2,14,7],[14,12,14,14],[7,1,7,6],[7,8,7,13],[8,1,8,6],[8,8,8,13],[9,2,9,6],[9,10,9,13],[4,18,4,20],[5,1,5,6],[5,8,5,13],[6,1,6,6],[6,8,6,13],[6,18,6,19],[0,0,2,2],[0,3,0,14],[0,18,1,20],[1,3,1,14],[2,3,2,8],[2,9,2,14]]}
[null,null,null,{"$f":"Home!B2","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tax Invoice"]
[null,null,null,{"$f":"\"Add: \"&Home!B3&\", \"&Home!B4&\", \"&Home!B5&\", \"&RIGHT(Home!B6,LEN(Home!B6)-3)&\", \"&Home!B7","v":{"$error":"#VALUE!"}}]
[null,null,null,{"$f":"\"Phone: \"&Home!B8","v":"Phone: "},null,null,null,null,null,{"$f":"\"Email: \"&Home!B9","v":"Email: "}]
[]
[null,"Bill To",null,null,null,null,null,null,"Ship To",null,null,null,null,null,null,null,"Invoice No:",null,{"$f":"Reprint!A2","v":16},{"$f":"Reprint!B2","v":"01/01/2020"},{"$f":"Reprint!C2","v":"Trial"}]
[null,{"$f":"Reprint!C2","v":"Trial"},null,null,null,null,null,null,{"$f":"Reprint!K2","v":"Trial"}]
[null,{"$f":"Reprint!D2","v":12},null,null,null,null,null,null,{"$f":"Reprint!L2","v":12},null,null,null,null,null,null,null,"Date :",null,{"$f":"Reprint!B2","v":"01/01/2020"},{"$f":"Reprint!C2","v":"Trial"}]
[null,{"$f":"Reprint!E2","v":"Near School"},null,null,null,null,null,null,{"$f":"Reprint!M2","v":"Near School"}]
[null,{"$f":"Reprint!F2&\" - \"&Reprint!G2","v":"Hyderabad - 451120"},null,null,null,null,null,null,{"$f":"Reprint!N2&\" - \"&Reprint!O2","v":"Hyderabad - 451120"}]
[null,"GSTIN:",{"$f":"Reprint!H2","v":"28asdadddd1234n"},null,null,null,null,null,"Place of Supply:",null,{"$f":"Reprint!Q2","v":"28-Andhra Pradesh(Before Division)"}]
[null,null,null,null,null,null,null,null,null," "]
["Details of Supply"]
["No","Item Code","Description of Goods",null,null,null,null,null,"HSN","Quantity","UoM","Rate","Taxable Value",null,null,"IGST Rate","IGST","CGST Rate","CGST","SGST Rate","SGST"]
[{"$f":"IF(ISBLANK(B14),\"\",1)","v":1},{"$f":"IF(ISBLANK(Reprint!S2),\"\",Reprint!S2)","v":100123},{"$f":"IF(ISBLANK(Reprint!T2),\"\",Reprint!T2)","v":"Laptop"},{"$f":"IF(ISBLANK(Reprint!U2),\"\",Reprint!U2)","v":"080001"},{"$f":"IF(ISBLANK(Reprint!V2),\"\",Reprint!V2)","v":250},{"$f":"IF(ISBLANK(Reprint!W2),\"\",Reprint!W2)","v":"nos"},{"$f":"IF(ISBLANK(Reprint!X2),\"\",Reprint!X2)","v":25500},{"$f":"IF(ISBLANK(Reprint!Y2),\"\",Reprint!Y2)","v":6375000},{"$f":"IF(ISBLANK(Reprint!U2),\"\",Reprint!U2)","v":"080001"},{"$f":"IF(ISBLANK(Reprint!V2),\"\",Reprint!V2)","v":250},{"$f":"IF(ISBLANK(Reprint!W2),\"\",Reprint!W2)","v":"nos"},{"$f":"IF(ISBLANK(Reprint!X2),\"\",Reprint!X2)","v":25500},{"$f":"IFERROR(J14*L14,0)","v":6375000},null,null,{"$f":"IF(B14=\"\",\"\",Reprint!Z2)","v":0.28000000000000003},{"$f":"IFERROR(M14*P14,0)","v":1785000.0000000002},{"$f":"IF(B14=\"\",\"\",Reprint!AB2)","v":0},{"$f":"IFERROR(M14*R14,0)","v":0},{"$f":"IF(B14=\"\",\"\",Reprint!AD2)","v":0},{"$f":"IFERROR(M14*T14,0)","v":0}]
[{"$f":"IF(B15=\"\",\"\",A14+1)","v":""},{"$f":"IF(ISBLANK(Reprint!S3),\"\",Reprint!S3)","v":""},{"$f":"IF(ISBLANK(Reprint!T3),\"\",Reprint!T3)","v":""},{"$f":"IF(ISBLANK(Reprint!U3),\"\",Reprint!U3)","v":""},{"$f":"IF(ISBLANK(Reprint!V3),\"\",Reprint!V3)","v":""},{"$f":"IF(ISBLANK(Reprint!W3),\"\",Reprint!W3)","v":""},{"$f":"IF(ISBLANK(Reprint!X3),\"\",Reprint!X3)","v":""},{"$f":"IF(ISBLANK(Reprint!Y3),\"\",Reprint!Y3)","v":""},{"$f":"IF(ISBLANK(Reprint!U3),\"\",Reprint!U3)","v":""},{"$f":"IF(ISBLANK(Reprint!V3),\"\",Reprint!V3)","v":""},{"$f":"IF(ISBLANK(Reprint!W3),\"\",Reprint!W3)","v":""},{"$f":"IF(ISBLANK(Reprint!X3),\"\",Reprint!X3)","v":""},{"$f":"IFERROR(J15*L15,0)","v":0},null,null,{"$f":"IF(B15=\"\",\"\",Reprint!Z3)","v":""},{"$f":"IFERROR(M15*P15,0)","v":0},{"$f":"IF(B15=\"\",\"\",Reprint!AB3)","v":""},{"$f":"IFERROR(M15*R15,0)","v":0},{"$f":"IF(B15=\"\",\"\",Reprint!AD3)","v":""},{"$f":"IFERROR(M15*T15,0)","v":0}]
[{"$f":"IF(B16=\"\",\"\",A15+1)","v":""},{"$f":"IF(ISBLANK(Reprint!S4),\"\",Reprint!S4)","v":""},{"$f":"IF(ISBLANK(Reprint!T4),\"\",Reprint!T4)","v":""},{"$f":"IF(ISBLANK(Reprint!U4),\"\",Reprint!U4)","v":""},{"$f":"IF(ISBLANK(Reprint!V4),\"\",Reprint!V4)","v":""},{"$f":"IF(ISBLANK(Reprint!W4),\"\",Reprint!W4)","v":""},{"$f":"IF(ISBLANK(Reprint!X4),\"\",Reprint!X4)","v":""},{"$f":"IF(ISBLANK(Reprint!Y4),\"\",Reprint!Y4)","v":""},{"$f":"IF(ISBLANK(Reprint!U4),\"\",Reprint!U4)","v":""},{"$f":"IF(ISBLANK(Reprint!V4),\"\",Reprint!V4)","v":""},{"$f":"IF(ISBLANK(Reprint!W4),\"\",Reprint!W4)","v":""},{"$f":"IF(ISBLANK(Reprint!X4),\"\",Reprint!X4)","v":""},0,null,null,{"$f":"IF(B16=\"\",\"\",Reprint!Z4)","v":""},0,{"$f":"IF(B16=\"\",\"\",Reprint!AB4)","v":""},0,{"$f":"IF(B16=\"\",\"\",Reprint!AD4)","v":""},0]
[{"$f":"IF(B17=\"\",\"\",A16+1)","v":""},{"$f":"IF(ISBLANK(Reprint!S5),\"\",Reprint!S5)","v":""},{"$f":"IF(ISBLANK(Reprint!T5),\"\",Reprint!T5)","v":""},{"$f":"IF(ISBLANK(Reprint!U5),\"\",Reprint!U5)","v":""},{"$f":"IF(ISBLANK(Reprint!V5),\"\",Reprint!V5)","v":""},{"$f":"IF(ISBLANK(Reprint!W5),\"\",Reprint!W5)","v":""},{"$f":"IF(ISBLANK(Reprint!X5),\"\",Reprint!X5)","v":""},{"$f":"IF(ISBLANK(Reprint!Y5),\"\",Reprint!Y5)","v":""},{"$f":"IF(ISBLANK(Reprint!U5),\"\",Reprint!U5)","v":""},{"$f":"IF(ISBLANK(Reprint!V5),\"\",Reprint!V5)","v":""},{"$f":"IF(ISBLANK(Reprint!W5),\"\",Reprint!W5)","v":""},{"$f":"IF(ISBLANK(Reprint!X5),\"\",Reprint!X5)","v":""},0,null,null,{"$f":"IF(B17=\"\",\"\",Reprint!Z5)","v":""},0,{"$f":"IF(B17=\"\",\"\",Reprint!AB5)","v":""},0,{"$f":"IF(B17=\"\",\"\",Reprint!AD5)","v":""},0]
[{"$f":"IF(B18=\"\",\"\",A17+1)","v":""},{"$f":"IF(ISBLANK(Reprint!S6),\"\",Reprint!S6)","v":""},{"$f":"IF(ISBLANK(Reprint!T6),\"\",Reprint!T6)","v":""},{"$f":"IF(ISBLANK(Reprint!U6),\"\",Reprint!U6)","v":""},{"$f":"IF(ISBLANK(Reprint!V6),\"\",Reprint!V6)","v":""},{"$f":"IF(ISBLANK(Reprint!W6),\"\",Reprint!W6)","v":""},{"$f":"IF(ISBLANK(Reprint!X6),\"\",Reprint!X6)","v":""},{"$f":"IF(ISBLANK(Reprint!Y6),\"\",Reprint!Y6)","v":""},{"$f":"IF(ISBLANK(Reprint!U6),\"\",Reprint!U6)","v":""},{"$f":"IF(ISBLANK(Reprint!V6),\"\",Reprint!V6)","v":""},{"$f":"IF(ISBLANK(Reprint!W6),\"\",Reprint!W6)","v":""},{"$f":"IF(ISBLANK(Reprint!X6),\"\",Reprint!X6)","v":""},0,null,null,{"$f":"IF(B18=\"\",\"\",Reprint!Z6)","v":""},0,{"$f":"IF(B18=\"\",\"\",Reprint!AB6)","v":""},0,{"$f":"IF(B18=\"\",\"\",Reprint!AD6)","v":""},0]
["",{"$f":"IF(ISBLANK(Reprint!S7),\"\",Reprint!S7)","v":""},{"$f":"IF(ISBLANK(Reprint!T7),\"\",Reprint!T7)","v":""},{"$f":"IF(ISBLANK(Reprint!U7),\"\",Reprint!U7)","v":""},{"$f":"IF(ISBLANK(Reprint!V7),\"\",Reprint!V7)","v":""},{"$f":"IF(ISBLANK(Reprint!W7),\"\",Reprint!W7)","v":""},{"$f":"IF(ISBLANK(Reprint!X7),\"\",Reprint!X7)","v":""},{"$f":"IF(ISBLANK(Reprint!Y7),\"\",Reprint!Y7)","v":""},{"$f":"IF(ISBLANK(Reprint!U7),\"\",Reprint!U7)","v":""},{"$f":"IF(ISBLANK(Reprint!V7),\"\",Reprint!V7)","v":""},{"$f":"IF(ISBLANK(Reprint!W7),\"\",Reprint!W7)","v":""},{"$f":"IF(ISBLANK(Reprint!X7),\"\",Reprint!X7)","v":""},0,null,null,{"$f":"IF(B19=\"\",\"\",Reprint!Z7)","v":""},0,{"$f":"IF(B19=\"\",\"\",Reprint!AB7)","v":""},0,{"$f":"IF(B19=\"\",\"\",Reprint!AD7)","v":""},0]
["",{"$f":"IF(ISBLANK(Reprint!S8),\"\",Reprint!S8)","v":""},{"$f":"IF(ISBLANK(Reprint!T8),\"\",Reprint!T8)","v":""},{"$f":"IF(ISBLANK(Reprint!U8),\"\",Reprint!U8)","v":""},{"$f":"IF(ISBLANK(Reprint!V8),\"\",Reprint!V8)","v":""},{"$f":"IF(ISBLANK(Reprint!W8),\"\",Reprint!W8)","v":""},{"$f":"IF(ISBLANK(Reprint!X8),\"\",Reprint!X8)","v":""},{"$f":"IF(ISBLANK(Reprint!Y8),\"\",Reprint!Y8)","v":""},{"$f":"IF(ISBLANK(Reprint!U8),\"\",Reprint!U8)","v":""},{"$f":"IF(ISBLANK(Reprint!V8),\"\",Reprint!V8)","v":""},{"$f":"IF(ISBLANK(Reprint!W8),\"\",Reprint!W8)","v":""},{"$f":"IF(ISBLANK(Reprint!X8),\"\",Reprint!X8)","v":""},0,null,null,{"$f":"IF(B20=\"\",\"\",Reprint!Z8)","v":""},0,{"$f":"IF(B20=\"\",\"\",Reprint!AB8)","v":""},0,{"$f":"IF(B20=\"\",\"\",Reprint!AD8)","v":""},0]
["",{"$f":"IF(ISBLANK(Reprint!S9),\"\",Reprint!S9)","v":""},{"$f":"IF(ISBLANK(Reprint!T9),\"\",Reprint!T9)","v":""},{"$f":"IF(ISBLANK(Reprint!U9),\"\",Reprint!U9)","v":""},{"$f":"IF(ISBLANK(Reprint!V9),\"\",Reprint!V9)","v":""},{"$f":"IF(ISBLANK(Reprint!W9),\"\",Reprint!W9)","v":""},{"$f":"IF(ISBLANK(Reprint!X9),\"\",Reprint!X9)","v":""},{"$f":"IF(ISBLANK(Reprint!Y9),\"\",Reprint!Y9)","v":""},{"$f":"IF(ISBLANK(Reprint!U9),\"\",Reprint!U9)","v":""},{"$f":"IF(ISBLANK(Reprint!V9),\"\",Reprint!V9)","v":""},{"$f":"IF(ISBLANK(Reprint!W9),\"\",Reprint!W9)","v":""},{"$f":"IF(ISBLANK(Reprint!X9),\"\",Reprint!X9)","v":""},0,null,null,{"$f":"IF(B21=\"\",\"\",Reprint!Z9)","v":""},0,{"$f":"IF(B21=\"\",\"\",Reprint!AB9)","v":""},0,{"$f":"IF(B21=\"\",\"\",Reprint!AD9)","v":""},0]
["",{"$f":"IF(ISBLANK(Reprint!S10),\"\",Reprint!S10)","v":""},{"$f":"IF(ISBLANK(Reprint!T10),\"\",Reprint!T10)","v":""},{"$f":"IF(ISBLANK(Reprint!U10),\"\",Reprint!U10)","v":""},{"$f":"IF(ISBLANK(Reprint!V10),\"\",Reprint!V10)","v":""},{"$f":"IF(ISBLANK(Reprint!W10),\"\",Reprint!W10)","v":""},{"$f":"IF(ISBLANK(Reprint!X10),\"\",Reprint!X10)","v":""},{"$f":"IF(ISBLANK(Reprint!Y10),\"\",Reprint!Y10)","v":""},{"$f":"IF(ISBLANK(Reprint!U10),\"\",Reprint!U10)","v":""},{"$f":"IF(ISBLANK(Reprint!V10),\"\",Reprint!V10)","v":""},{"$f":"IF(ISBLANK(Reprint!W10),\"\",Reprint!W10)","v":""},{"$f":"IF(ISBLANK(Reprint!X10),\"\",Reprint!X10)","v":""},0,null,null,{"$f":"IF(B22=\"\",\"\",Reprint!Z10)","v":""},0,{"$f":"IF(B22=\"\",\"\",Reprint!AB10)","v":""},0,{"$f":"IF(B22=\"\",\"\",Reprint!AD10)","v":""},0]
["",{"$f":"IF(ISBLANK(Reprint!S11),\"\",Reprint!S11)","v":""},{"$f":"IF(ISBLANK(Reprint!T11),\"\",Reprint!T11)","v":""},{"$f":"IF(ISBLANK(Reprint!U11),\"\",Reprint!U11)","v":""},{"$f":"IF(ISBLANK(Reprint!V11),\"\",Reprint!V11)","v":""},{"$f":"IF(ISBLANK(Reprint!W11),\"\",Reprint!W11)","v":""},{"$f":"IF(ISBLANK(Reprint!X11),\"\",Reprint!X11)","v":""},{"$f":"IF(ISBLANK(Reprint!Y11),\"\",Reprint!Y11)","v":""},{"$f":"IF(ISBLANK(Reprint!U11),\"\",Reprint!U11)","v":""},{"$f":"IF(ISBLANK(Reprint!V11),\"\",Reprint!V11)","v":""},{"$f":"IF(ISBLANK(Reprint!W11),\"\",Reprint!W11)","v":""},{"$f":"IF(ISBLANK(Reprint!X11),\"\",Reprint!X11)","v":""},0,null,null,{"$f":"IF(B23=\"\",\"\",Reprint!Z11)","v":""},0,{"$f":"IF(B23=\"\",\"\",Reprint!AB11)","v":""},0,{"$f":"IF(B23=\"\",\"\",Reprint!AD11)","v":""},0]
["",{"$f":"IF(ISBLANK(Reprint!S12),\"\",Reprint!S12)","v":""},{"$f":"IF(ISBLANK(Reprint!T12),\"\",Reprint!T12)","v":""},{"$f":"IF(ISBLANK(Reprint!U12),\"\",Reprint!U12)","v":""},{"$f":"IF(ISBLANK(Reprint!V12),\"\",Reprint!V12)","v":""},{"$f":"IF(ISBLANK(Reprint!W12),\"\",Reprint!W12)","v":""},{"$f":"IF(ISBLANK(Reprint!X12),\"\",Reprint!X12)","v":""},{"$f":"IF(ISBLANK(Reprint!Y12),\"\",Reprint!Y12)","v":""},{"$f":"IF(ISBLANK(Reprint!U12),\"\",Reprint!U12)","v":""},{"$f":"IF(ISBLANK(Reprint!V12),\"\",Reprint!V12)","v":""},{"$f":"IF(ISBLANK(Reprint!W12),\"\",Reprint!W12)","v":""},{"$f":"IF(ISBLANK(Reprint!X12),\"\",Reprint!X12)","v":""},0,null,null,{"$f":"IF(B24=\"\",\"\",Reprint!Z12)","v":""},0,{"$f":"IF(B24=\"\",\"\",Reprint!AB12)","v":""},0,{"$f":"IF(B24=\"\",\"\",Reprint!AD12)","v":""},0]
["",{"$f":"IF(ISBLANK(Reprint!S13),\"\",Reprint!S13)","v":""},{"$f":"IF(ISBLANK(Reprint!T13),\"\",Reprint!T13)","v":""},{"$f":"IF(ISBLANK(Reprint!U13),\"\",Reprint!U13)","v":""},{"$f":"IF(ISBLANK(Reprint!V13),\"\",Reprint!V13)","v":""},{"$f":"IF(ISBLANK(Reprint!W13),\"\",Reprint!W13)","v":""},{"$f":"IF(ISBLANK(Reprint!X13),\"\",Reprint!X13)","v":""},{"$f":"IF(ISBLANK(Reprint!Y13),\"\",Reprint!Y13)","v":""},{"$f":"IF(ISBLANK(Reprint!U13),\"\",Reprint!U13)","v":""},{"$f":"IF(ISBLANK(Reprint!V13),\"\",Reprint!V13)","v":""},{"$f":"IF(ISBLANK(Reprint!W13),\"\",Reprint!W13)","v":""},{"$f":"IF(ISBLANK(Reprint!X13),\"\",Reprint!X13)","v":""},0,null,null,{"$f":"IF(B25=\"\",\"\",Reprint!Z13)","v":""},0,{"$f":"IF(B25=\"\",\"\",Reprint!AB13)","v":""},0,{"$f":"IF(B25=\"\",\"\",Reprint!AD13)","v":""},0]
["",{"$f":"IF(ISBLANK(Reprint!S14),\"\",Reprint!S14)","v":""},{"$f":"IF(ISBLANK(Reprint!T14),\"\",Reprint!T14)","v":""},{"$f":"IF(ISBLANK(Reprint!U14),\"\",Reprint!U14)","v":""},{"$f":"IF(ISBLANK(Reprint!V14),\"\",Reprint!V14)","v":""},{"$f":"IF(ISBLANK(Reprint!W14),\"\",Reprint!W14)","v":""},{"$f":"IF(ISBLANK(Reprint!X14),\"\",Reprint!X14)","v":""},{"$f":"IF(ISBLANK(Reprint!Y14),\"\",Reprint!Y14)","v":""},{"$f":"IF(ISBLANK(Reprint!U14),\"\",Reprint!U14)","v":""},{"$f":"IF(ISBLANK(Reprint!V14),\"\",Reprint!V14)","v":""},{"$f":"IF(ISBLANK(Reprint!W14),\"\",Reprint!W14)","v":""},{"$f":"IF(ISBLANK(Reprint!X14),\"\",Reprint!X14)","v":""},0,null,null,{"$f":"IF(B26=\"\",\"\",Reprint!Z14)","v":""},0,{"$f":"IF(B26=\"\",\"\",Reprint!AB14)","v":""},0,{"$f":"IF(B26=\"\",\"\",Reprint!AD14)","v":""},0]
["",{"$f":"IF(ISBLANK(Reprint!S15),\"\",Reprint!S15)","v":""},{"$f":"IF(ISBLANK(Reprint!T15),\"\",Reprint!T15)","v":""},{"$f":"IF(ISBLANK(Reprint!U15),\"\",Reprint!U15)","v":""},{"$f":"IF(ISBLANK(Reprint!V15),\"\",Reprint!V15)","v":""},{"$f":"IF(ISBLANK(Reprint!W15),\"\",Reprint!W15)","v":""},{"$f":"IF(ISBLANK(Reprint!X15),\"\",Reprint!X15)","v":""},{"$f":"IF(ISBLANK(Reprint!Y15),\"\",Reprint!Y15)","v":""},{"$f":"IF(ISBLANK(Reprint!U15),\"\",Reprint!U15)","v":""},{"$f":"IF(ISBLANK(Reprint!V15),\"\",Reprint!V15)","v":""},{"$f":"IF(ISBLANK(Reprint!W15),\"\",Reprint!W15)","v":""},{"$f":"IF(ISBLANK(Reprint!X15),\"\",Reprint!X15)","v":""},0,null,null,{"$f":"IF(B27=\"\",\"\",Reprint!Z15)","v":""},0,{"$f":"IF(B27=\"\",\"\",Reprint!AB15)","v":""},0,{"$f":"IF(B27=\"\",\"\",Reprint!AD15)","v":""},0]
["",{"$f":"IF(ISBLANK(Reprint!S16),\"\",Reprint!S16)","v":""},{"$f":"IF(ISBLANK(Reprint!T16),\"\",Reprint!T16)","v":""},{"$f":"IF(ISBLANK(Reprint!U16),\"\",Reprint!U16)","v":""},{"$f":"IF(ISBLANK(Reprint!V16),\"\",Reprint!V16)","v":""},{"$f":"IF(ISBLANK(Reprint!W16),\"\",Reprint!W16)","v":""},{"$f":"IF(ISBLANK(Reprint!X16),\"\",Reprint!X16)","v":""},{"$f":"IF(ISBLANK(Reprint!Y16),\"\",Reprint!Y16)","v":""},{"$f":"IF(ISBLANK(Reprint!U16),\"\",Reprint!U16)","v":""},{"$f":"IF(ISBLANK(Reprint!V16),\"\",Reprint!V16)","v":""},{"$f":"IF(ISBLANK(Reprint!W16),\"\",Reprint!W16)","v":""},{"$f":"IF(ISBLANK(Reprint!X16),\"\",Reprint!X16)","v":""},0,null,null,{"$f":"IF(B28=\"\",\"\",Reprint!Z16)","v":""},0,{"$f":"IF(B28=\"\",\"\",Reprint!AB16)","v":""},0,{"$f":"IF(B28=\"\",\"\",Reprint!AD16)","v":""},0]
["",{"$f":"IF(ISBLANK(Reprint!S17),\"\",Reprint!S17)","v":""},{"$f":"IF(ISBLANK(Reprint!T17),\"\",Reprint!T17)","v":""},{"$f":"IF(ISBLANK(Reprint!U17),\"\",Reprint!U17)","v":""},{"$f":"IF(ISBLANK(Reprint!V17),\"\",Reprint!V17)","v":""},{"$f":"IF(ISBLANK(Reprint!W17),\"\",Reprint!W17)","v":""},{"$f":"IF(ISBLANK(Reprint!X17),\"\",Reprint!X17)","v":""},{"$f":"IF(ISBLANK(Reprint!Y17),\"\",Reprint!Y17)","v":""},{"$f":"IF(ISBLANK(Reprint!U17),\"\",Reprint!U17)","v":""},{"$f":"IF(ISBLANK(Reprint!V17),\"\",Reprint!V17)","v":""},{"$f":"IF(ISBLANK(Reprint!W17),\"\",Reprint!W17)","v":""},{"$f":"IF(ISBLANK(Reprint!X17),\"\",Reprint!X17)","v":""},0,null,null,{"$f":"IF(B29=\"\",\"\",Reprint!Z17)","v":""},0,{"$f":"IF(B29=\"\",\"\",Reprint!AB17)","v":""},0,{"$f":"IF(B29=\"\",\"\",Reprint!AD17)","v":""},0]
["",{"$f":"IF(ISBLANK(Reprint!S18),\"\",Reprint!S18)","v":""},{"$f":"IF(ISBLANK(Reprint!T18),\"\",Reprint!T18)","v":""},{"$f":"IF(ISBLANK(Reprint!U18),\"\",Reprint!U18)","v":""},{"$f":"IF(ISBLANK(Reprint!V18),\"\",Reprint!V18)","v":""},{"$f":"IF(ISBLANK(Reprint!W18),\"\",Reprint!W18)","v":""},{"$f":"IF(ISBLANK(Reprint!X18),\"\",Reprint!X18)","v":""},{"$f":"IF(ISBLANK(Reprint!Y18),\"\",Reprint!Y18)","v":""},{"$f":"IF(ISBLANK(Reprint!U18),\"\",Reprint!U18)","v":""},{"$f":"IF(ISBLANK(Reprint!V18),\"\",Reprint!V18)","v":""},{"$f":"IF(ISBLANK(Reprint!W18),\"\",Reprint!W18)","v":""},{"$f":"IF(ISBLANK(Reprint!X18),\"\",Reprint!X18)","v":""},0,null,null,{"$f":"IF(B30=\"\",\"\",Reprint!Z18)","v":""},0,{"$f":"IF(B30=\"\",\"\",Reprint!AB18)","v":""},0,{"$f":"IF(B30=\"\",\"\",Reprint!AD18)","v":""},0]
[null,null,"Subtotal",null,null,null,null,null,null,{"$f":"SUM(J14:J30)","v":250},null,null,{"$f":"SUM(M14:O30)","v":6375000},null,null,null,{"$f":"SUM(Q14:Q30)","v":1785000.0000000002},null,{"$f":"SUM(S14:S30)","v":0},null,{"$f":"SUM(U14:U30)","v":0}]
[{"$f":"\"GSTIN: \"&Home!B10&\"\nPAN: \"&Home!B11","v":"GSTIN: \nPAN: "},null,null,null,null,null,null,null,null,"Total Invoice Value (INR)",null,null,null,null,null,null,{"$f":"M31+S31+U31+Q31","v":8160000}]
[null,null,null,null,null,null,null,null,null,"Total Invoice Value (in words)",null,null,null,null,null,null,{"$f":"NumToWord(M31+S31+U31+Q31)&\" Only\"","v":" Eighty One Lakh Sixty Thousand Only"}]
[]
[]
["Terms and Conditions\nCertified that the particulars given above are true and correct and the amount indicated represent the price actually charged and that there is no additional consideration flowing directly or indirectly from the buyer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"For \"&D1","v":"For 0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Authorised Signatory"]