{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["InvoiceData","Printable_A4","Help & Macros","Controls"],"not_rendered":{"macros":1,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"InvoiceData","index":0,"n_rows":107,"n_cols":24,"rows_kept":107}
["Seller / Company Name:","Your Company Pvt Ltd"]
["Seller GSTIN:","27AAAAA0000A1Z7"]
["Seller State:","Gujarat"]
["Notes:","Fill invoice lines starting at row 8. Use Invoice No to group lines for the same invoice."]
[]
[]
["Invoice No.","Invoice Date","Reverse Charge (Y/N)","State","Place of Supply","GSTIN of Customer","Customer Name","Billing Address","Shipping Address","HSN/SAC","Product/Service Description","Quantity","Unit","Rate (₹)","Taxable Value (₹)","GST Rate %","CGST %","CGST Amount (₹)","SGST %","SGST Amount (₹)","IGST %","IGST Amount (₹)","Total Tax (₹)","Total Invoice Value (₹)"]
["INV-001","2025-09-20","N","Gujarat","Gujarat","24ABCDE1234F1Z5","ABC Enterprises","123, Ring Road, Surat, Gujarat - 395002","123, Ring Road, Surat, Gujarat - 395002","65061010","Safety Helmet",50,"Nos",150,{"$f":"L8*N8","v":7500},18,{"$f":"IF(E8=$B$3, P8/2, 0)","v":9},{"$f":"O8*Q8/100","v":675},{"$f":"IF(E8=$B$3, P8/2, 0)","v":9},{"$f":"O8*S8/100","v":675},{"$f":"IF(E8=$B$3, 0, P8)","v":0},{"$f":"O8*U8/100","v":0},{"$f":"R8+T8+V8","v":1350},{"$f":"O8+W8","v":8850}]
["INV-001","2025-09-20","N","Gujarat","Gujarat","24ABCDE1234F1Z5","ABC Enterprises","123, Ring Road, Surat, Gujarat - 395002","123, Ring Road, Surat, Gujarat - 395002","65061010","Safety Visor",20,"Nos",200,{"$f":"L9*N9","v":4000},18,9,360,9,360,0,0,720,4720]
["INV-003","2025-09-21","N","Gujarat","Goa","24ABCDE1234F1Z5","ABC Enterprises","123, Ring Road, Surat, Gujarat - 395002","123, Ring Road, Surat, Gujarat - 395002","65061010","Safety Visor",12,"Nos",200,{"$f":"L10*N10","v":2400},18,{"$f":"IF(E10=$B$3, P10/2, 0)","v":0},{"$f":"O10*Q10/100","v":0},{"$f":"IF(E10=$B$3, P10/2, 0)","v":0},{"$f":"O10*S10/100","v":0},{"$f":"IF(E10=$B$3, 0, P10)","v":18},{"$f":"O10*U10/100","v":432},{"$f":"R10+T10+V10","v":432},{"$f":"O10+W10","v":2832}]
[]
[{"$nulls":14},{"$f":"L12*N12","v":0},null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,{"$f":"IF(E40=$B$3, P40/2, 0)","v":0},{"$f":"O40*Q40/100","v":0},{"$f":"IF(E40=$B$3, P40/2, 0)","v":0},{"$f":"O40*S40/100","v":0},{"$f":"IF(E40=$B$3, 0, P40)","v":0},{"$f":"O40*U40/100","v":0},{"$f":"R40+T40+V40","v":0},{"$f":"O40+W40","v":0}]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},{"$f":"L42*N42","v":0},null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,{"$f":"IF(E72=$B$3, P72/2, 0)","v":0},{"$f":"O72*Q72/100","v":0},{"$f":"IF(E72=$B$3, P72/2, 0)","v":0},{"$f":"O72*S72/100","v":0},{"$f":"IF(E72=$B$3, 0, P72)","v":0},{"$f":"O72*U72/100","v":0},{"$f":"R72+T72+V72","v":0},{"$f":"O72+W72","v":0}]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},{"$f":"L74*N74","v":0},null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,{"$f":"IF(E104=$B$3, P104/2, 0)","v":0},{"$f":"O104*Q104/100","v":0},0,{"$f":"O104*S104/100","v":0},0,{"$f":"O104*U104/100","v":0},{"$f":"R104+T104+V104","v":0},{"$f":"O104+W104","v":0}]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]
[{"$nulls":14},{"$f":"L106*N106","v":0},null,0,0,0,0,0,0,0,0]
[{"$nulls":14},0,null,0,0,0,0,0,0,0,0]

{"sheet":"Printable_A4","index":1,"n_rows":55,"n_cols":26,"rows_kept":55,"merged":[[0,0,0,5]]}
["Your Company LOGO"]
["GST INVOICE (Print Ready - A4)"]
[]
["Enter Invoice No:","INV-001"]
[]
["Seller / Company Name:",{"$f":"InvoiceData!B1","v":"Your Company Pvt Ltd"}]
["Seller GSTIN:",{"$f":"InvoiceData!B2","v":"27AAAAA0000A1Z7"}]
["Seller State:",{"$f":"InvoiceData!B3","v":"Gujarat"}]
[]
["Invoice No.",{"$f":"B4","v":"INV-001"}]
["Invoice Date",{"$f":"IF($B$4=\"\",\"\", IFERROR(INDEX(InvoiceData!B8:B107, MATCH($B$4, InvoiceData!$A$8:$A$107, 0)), \"\"))","v":"2025-09-20"}]
["Customer Name",{"$f":"IF($B$4=\"\",\"\", IFERROR(INDEX(InvoiceData!G8:G107, MATCH($B$4, InvoiceData!$A$8:$A$107, 0)), \"\"))","v":"ABC Enterprises"}]
["Customer GSTIN",{"$f":"IF($B$4=\"\",\"\", IFERROR(INDEX(InvoiceData!F8:F107, MATCH($B$4, InvoiceData!$A$8:$A$107, 0)), \"\"))","v":"24ABCDE1234F1Z5"}]
["Billing Address",{"$f":"IF($B$4=\"\",\"\", IFERROR(INDEX(InvoiceData!H8:H107, MATCH($B$4, InvoiceData!$A$8:$A$107, 0)), \"\"))","v":"123, Ring Road, Surat, Gujarat - 395002"}]
["Place of Supply (State)",{"$f":"IF($B$4=\"\",\"\", IFERROR(INDEX(InvoiceData!E8:E107, MATCH($B$4, InvoiceData!$A$8:$A$107, 0)), \"\"))","v":"Gujarat"}]
[]
[]
["S.No","HSN/SAC","Description","Qty","Unit","Rate (₹)","Taxable Value (₹)","GST %","CGST Amt","SGST Amt","IGST Amt","Line Total"]
[1,{"$f":"IF($B$4=\"\", \"\", IF($Z19=\"\",\"\", INDEX(InvoiceData!J8:J107, $Z19-7)))","v":"65061010"},{"$f":"IF($B$4=\"\", \"\", IF($Z19=\"\",\"\", INDEX(InvoiceData!K8:K107, $Z19-7)))","v":"Safety Helmet"},{"$f":"IF($B$4=\"\", \"\", IF($Z19=\"\",\"\", INDEX(InvoiceData!L8:L107, $Z19-7)))","v":50},{"$f":"IF($B$4=\"\", \"\", IF($Z19=\"\",\"\", INDEX(InvoiceData!M8:M107, $Z19-7)))","v":"Nos"},{"$f":"IF($B$4=\"\", \"\", IF($Z19=\"\",\"\", INDEX(InvoiceData!N8:N107, $Z19-7)))","v":150},{"$f":"IF($B$4=\"\", \"\", IF($Z19=\"\",\"\", INDEX(InvoiceData!O8:O107, $Z19-7)))","v":7500},{"$f":"IF($B$4=\"\", \"\", IF($Z19=\"\",\"\", INDEX(InvoiceData!P8:P107, $Z19-7)))","v":18},{"$f":"IF($B$4=\"\", \"\", IF($Z19=\"\",\"\", INDEX(InvoiceData!R8:R107, $Z19-7)))","v":675},{"$f":"IF($B$4=\"\", \"\", IF($Z19=\"\",\"\", INDEX(InvoiceData!T8:T107, $Z19-7)))","v":675},{"$f":"IF($B$4=\"\", \"\", IF($Z19=\"\",\"\", INDEX(InvoiceData!V8:V107, $Z19-7)))","v":0},{"$f":"IF($B$4=\"\", \"\", IF($Z19=\"\",\"\", INDEX(InvoiceData!X8:X107, $Z19-7)))","v":8850},{"$nulls":13},{"$f":"IF($B$4=\"\",\"\", IFERROR(_xlfn.AGGREGATE(15,6,ROW(InvoiceData!$A$8:$A$207)/(InvoiceData!$A$8:$A$207=$B$4), ROWS($Z$19:Z19)), \"\"))","v":8}]
[{"$f":"+A19+1","v":2},{"$f":"IF($B$4=\"\", \"\", IF($Z20=\"\",\"\", INDEX(InvoiceData!J8:J107, $Z20-7)))","v":"65061010"},{"$f":"IF($B$4=\"\", \"\", IF($Z20=\"\",\"\", INDEX(InvoiceData!K8:K107, $Z20-7)))","v":"Safety Visor"},{"$f":"IF($B$4=\"\", \"\", IF($Z20=\"\",\"\", INDEX(InvoiceData!L8:L107, $Z20-7)))","v":20},{"$f":"IF($B$4=\"\", \"\", IF($Z20=\"\",\"\", INDEX(InvoiceData!M8:M107, $Z20-7)))","v":"Nos"},{"$f":"IF($B$4=\"\", \"\", IF($Z20=\"\",\"\", INDEX(InvoiceData!N8:N107, $Z20-7)))","v":200},{"$f":"IF($B$4=\"\", \"\", IF($Z20=\"\",\"\", INDEX(InvoiceData!O8:O107, $Z20-7)))","v":4000},{"$f":"IF($B$4=\"\", \"\", IF($Z20=\"\",\"\", INDEX(InvoiceData!P8:P107, $Z20-7)))","v":18},{"$f":"IF($B$4=\"\", \"\", IF($Z20=\"\",\"\", INDEX(InvoiceData!R8:R107, $Z20-7)))","v":360},{"$f":"IF($B$4=\"\", \"\", IF($Z20=\"\",\"\", INDEX(InvoiceData!T8:T107, $Z20-7)))","v":360},{"$f":"IF($B$4=\"\", \"\", IF($Z20=\"\",\"\", INDEX(InvoiceData!V8:V107, $Z20-7)))","v":0},{"$f":"IF($B$4=\"\", \"\", IF($Z20=\"\",\"\", INDEX(InvoiceData!X8:X107, $Z20-7)))","v":4720},{"$nulls":13},{"$f":"IF($B$4=\"\",\"\", IFERROR(_xlfn.AGGREGATE(15,6,ROW(InvoiceData!$A$8:$A$207)/(InvoiceData!$A$8:$A$207=$B$4), ROWS($Z$19:Z20)), \"\"))","v":9}]
[{"$f":"+A20+1","v":3},{"$f":"IF($B$4=\"\", \"\", IF($Z21=\"\",\"\", INDEX(InvoiceData!J8:J107, $Z21-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z21=\"\",\"\", INDEX(InvoiceData!K8:K107, $Z21-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z21=\"\",\"\", INDEX(InvoiceData!L8:L107, $Z21-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z21=\"\",\"\", INDEX(InvoiceData!M8:M107, $Z21-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z21=\"\",\"\", INDEX(InvoiceData!N8:N107, $Z21-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z21=\"\",\"\", INDEX(InvoiceData!O8:O107, $Z21-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z21=\"\",\"\", INDEX(InvoiceData!P8:P107, $Z21-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z21=\"\",\"\", INDEX(InvoiceData!R8:R107, $Z21-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z21=\"\",\"\", INDEX(InvoiceData!T8:T107, $Z21-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z21=\"\",\"\", INDEX(InvoiceData!V8:V107, $Z21-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z21=\"\",\"\", INDEX(InvoiceData!X8:X107, $Z21-7)))","v":""},{"$nulls":13},{"$f":"IF($B$4=\"\",\"\", IFERROR(_xlfn.AGGREGATE(15,6,ROW(InvoiceData!$A$8:$A$207)/(InvoiceData!$A$8:$A$207=$B$4), ROWS($Z$19:Z21)), \"\"))","v":""}]
[4,{"$f":"IF($B$4=\"\", \"\", IF($Z22=\"\",\"\", INDEX(InvoiceData!J8:J107, $Z22-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z22=\"\",\"\", INDEX(InvoiceData!K8:K107, $Z22-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z22=\"\",\"\", INDEX(InvoiceData!L8:L107, $Z22-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z22=\"\",\"\", INDEX(InvoiceData!M8:M107, $Z22-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z22=\"\",\"\", INDEX(InvoiceData!N8:N107, $Z22-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z22=\"\",\"\", INDEX(InvoiceData!O8:O107, $Z22-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z22=\"\",\"\", INDEX(InvoiceData!P8:P107, $Z22-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z22=\"\",\"\", INDEX(InvoiceData!R8:R107, $Z22-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z22=\"\",\"\", INDEX(InvoiceData!T8:T107, $Z22-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z22=\"\",\"\", INDEX(InvoiceData!V8:V107, $Z22-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z22=\"\",\"\", INDEX(InvoiceData!X8:X107, $Z22-7)))","v":""},{"$nulls":13},{"$f":"IF($B$4=\"\",\"\", IFERROR(_xlfn.AGGREGATE(15,6,ROW(InvoiceData!$A$8:$A$207)/(InvoiceData!$A$8:$A$207=$B$4), ROWS($Z$19:Z22)), \"\"))","v":""}]
[5,{"$f":"IF($B$4=\"\", \"\", IF($Z23=\"\",\"\", INDEX(InvoiceData!J8:J107, $Z23-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z23=\"\",\"\", INDEX(InvoiceData!K8:K107, $Z23-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z23=\"\",\"\", INDEX(InvoiceData!L8:L107, $Z23-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z23=\"\",\"\", INDEX(InvoiceData!M8:M107, $Z23-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z23=\"\",\"\", INDEX(InvoiceData!N8:N107, $Z23-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z23=\"\",\"\", INDEX(InvoiceData!O8:O107, $Z23-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z23=\"\",\"\", INDEX(InvoiceData!P8:P107, $Z23-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z23=\"\",\"\", INDEX(InvoiceData!R8:R107, $Z23-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z23=\"\",\"\", INDEX(InvoiceData!T8:T107, $Z23-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z23=\"\",\"\", INDEX(InvoiceData!V8:V107, $Z23-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z23=\"\",\"\", INDEX(InvoiceData!X8:X107, $Z23-7)))","v":""},{"$nulls":13},{"$f":"IF($B$4=\"\",\"\", IFERROR(_xlfn.AGGREGATE(15,6,ROW(InvoiceData!$A$8:$A$207)/(InvoiceData!$A$8:$A$207=$B$4), ROWS($Z$19:Z23)), \"\"))","v":""}]
[6,{"$f":"IF($B$4=\"\", \"\", IF($Z24=\"\",\"\", INDEX(InvoiceData!J8:J107, $Z24-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z24=\"\",\"\", INDEX(InvoiceData!K8:K107, $Z24-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z24=\"\",\"\", INDEX(InvoiceData!L8:L107, $Z24-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z24=\"\",\"\", INDEX(InvoiceData!M8:M107, $Z24-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z24=\"\",\"\", INDEX(InvoiceData!N8:N107, $Z24-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z24=\"\",\"\", INDEX(InvoiceData!O8:O107, $Z24-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z24=\"\",\"\", INDEX(InvoiceData!P8:P107, $Z24-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z24=\"\",\"\", INDEX(InvoiceData!R8:R107, $Z24-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z24=\"\",\"\", INDEX(InvoiceData!T8:T107, $Z24-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z24=\"\",\"\", INDEX(InvoiceData!V8:V107, $Z24-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z24=\"\",\"\", INDEX(InvoiceData!X8:X107, $Z24-7)))","v":""},{"$nulls":13},{"$f":"IF($B$4=\"\",\"\", IFERROR(_xlfn.AGGREGATE(15,6,ROW(InvoiceData!$A$8:$A$207)/(InvoiceData!$A$8:$A$207=$B$4), ROWS($Z$19:Z24)), \"\"))","v":""}]
[7,{"$f":"IF($B$4=\"\", \"\", IF($Z25=\"\",\"\", INDEX(InvoiceData!J8:J107, $Z25-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z25=\"\",\"\", INDEX(InvoiceData!K8:K107, $Z25-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z25=\"\",\"\", INDEX(InvoiceData!L8:L107, $Z25-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z25=\"\",\"\", INDEX(InvoiceData!M8:M107, $Z25-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z25=\"\",\"\", INDEX(InvoiceData!N8:N107, $Z25-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z25=\"\",\"\", INDEX(InvoiceData!O8:O107, $Z25-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z25=\"\",\"\", INDEX(InvoiceData!P8:P107, $Z25-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z25=\"\",\"\", INDEX(InvoiceData!R8:R107, $Z25-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z25=\"\",\"\", INDEX(InvoiceData!T8:T107, $Z25-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z25=\"\",\"\", INDEX(InvoiceData!V8:V107, $Z25-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z25=\"\",\"\", INDEX(InvoiceData!X8:X107, $Z25-7)))","v":""},{"$nulls":13},{"$f":"IF($B$4=\"\",\"\", IFERROR(_xlfn.AGGREGATE(15,6,ROW(InvoiceData!$A$8:$A$207)/(InvoiceData!$A$8:$A$207=$B$4), ROWS($Z$19:Z25)), \"\"))","v":""}]
[8,{"$f":"IF($B$4=\"\", \"\", IF($Z26=\"\",\"\", INDEX(InvoiceData!J8:J107, $Z26-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z26=\"\",\"\", INDEX(InvoiceData!K8:K107, $Z26-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z26=\"\",\"\", INDEX(InvoiceData!L8:L107, $Z26-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z26=\"\",\"\", INDEX(InvoiceData!M8:M107, $Z26-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z26=\"\",\"\", INDEX(InvoiceData!N8:N107, $Z26-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z26=\"\",\"\", INDEX(InvoiceData!O8:O107, $Z26-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z26=\"\",\"\", INDEX(InvoiceData!P8:P107, $Z26-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z26=\"\",\"\", INDEX(InvoiceData!R8:R107, $Z26-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z26=\"\",\"\", INDEX(InvoiceData!T8:T107, $Z26-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z26=\"\",\"\", INDEX(InvoiceData!V8:V107, $Z26-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z26=\"\",\"\", INDEX(InvoiceData!X8:X107, $Z26-7)))","v":""},{"$nulls":13},{"$f":"IF($B$4=\"\",\"\", IFERROR(_xlfn.AGGREGATE(15,6,ROW(InvoiceData!$A$8:$A$207)/(InvoiceData!$A$8:$A$207=$B$4), ROWS($Z$19:Z26)), \"\"))","v":""}]
[9,{"$f":"IF($B$4=\"\", \"\", IF($Z27=\"\",\"\", INDEX(InvoiceData!J8:J107, $Z27-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z27=\"\",\"\", INDEX(InvoiceData!K8:K107, $Z27-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z27=\"\",\"\", INDEX(InvoiceData!L8:L107, $Z27-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z27=\"\",\"\", INDEX(InvoiceData!M8:M107, $Z27-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z27=\"\",\"\", INDEX(InvoiceData!N8:N107, $Z27-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z27=\"\",\"\", INDEX(InvoiceData!O8:O107, $Z27-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z27=\"\",\"\", INDEX(InvoiceData!P8:P107, $Z27-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z27=\"\",\"\", INDEX(InvoiceData!R8:R107, $Z27-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z27=\"\",\"\", INDEX(InvoiceData!T8:T107, $Z27-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z27=\"\",\"\", INDEX(InvoiceData!V8:V107, $Z27-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z27=\"\",\"\", INDEX(InvoiceData!X8:X107, $Z27-7)))","v":""},{"$nulls":13},{"$f":"IF($B$4=\"\",\"\", IFERROR(_xlfn.AGGREGATE(15,6,ROW(InvoiceData!$A$8:$A$207)/(InvoiceData!$A$8:$A$207=$B$4), ROWS($Z$19:Z27)), \"\"))","v":""}]
[10,{"$f":"IF($B$4=\"\", \"\", IF($Z28=\"\",\"\", INDEX(InvoiceData!J8:J107, $Z28-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z28=\"\",\"\", INDEX(InvoiceData!K8:K107, $Z28-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z28=\"\",\"\", INDEX(InvoiceData!L8:L107, $Z28-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z28=\"\",\"\", INDEX(InvoiceData!M8:M107, $Z28-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z28=\"\",\"\", INDEX(InvoiceData!N8:N107, $Z28-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z28=\"\",\"\", INDEX(InvoiceData!O8:O107, $Z28-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z28=\"\",\"\", INDEX(InvoiceData!P8:P107, $Z28-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z28=\"\",\"\", INDEX(InvoiceData!R8:R107, $Z28-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z28=\"\",\"\", INDEX(InvoiceData!T8:T107, $Z28-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z28=\"\",\"\", INDEX(InvoiceData!V8:V107, $Z28-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z28=\"\",\"\", INDEX(InvoiceData!X8:X107, $Z28-7)))","v":""},{"$nulls":13},{"$f":"IF($B$4=\"\",\"\", IFERROR(_xlfn.AGGREGATE(15,6,ROW(InvoiceData!$A$8:$A$207)/(InvoiceData!$A$8:$A$207=$B$4), ROWS($Z$19:Z28)), \"\"))","v":""}]
[11,{"$f":"IF($B$4=\"\", \"\", IF($Z29=\"\",\"\", INDEX(InvoiceData!J8:J107, $Z29-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z29=\"\",\"\", INDEX(InvoiceData!K8:K107, $Z29-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z29=\"\",\"\", INDEX(InvoiceData!L8:L107, $Z29-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z29=\"\",\"\", INDEX(InvoiceData!M8:M107, $Z29-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z29=\"\",\"\", INDEX(InvoiceData!N8:N107, $Z29-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z29=\"\",\"\", INDEX(InvoiceData!O8:O107, $Z29-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z29=\"\",\"\", INDEX(InvoiceData!P8:P107, $Z29-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z29=\"\",\"\", INDEX(InvoiceData!R8:R107, $Z29-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z29=\"\",\"\", INDEX(InvoiceData!T8:T107, $Z29-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z29=\"\",\"\", INDEX(InvoiceData!V8:V107, $Z29-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z29=\"\",\"\", INDEX(InvoiceData!X8:X107, $Z29-7)))","v":""},{"$nulls":13},{"$f":"IF($B$4=\"\",\"\", IFERROR(_xlfn.AGGREGATE(15,6,ROW(InvoiceData!$A$8:$A$207)/(InvoiceData!$A$8:$A$207=$B$4), ROWS($Z$19:Z29)), \"\"))","v":""}]
[12,{"$f":"IF($B$4=\"\", \"\", IF($Z30=\"\",\"\", INDEX(InvoiceData!J8:J107, $Z30-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z30=\"\",\"\", INDEX(InvoiceData!K8:K107, $Z30-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z30=\"\",\"\", INDEX(InvoiceData!L8:L107, $Z30-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z30=\"\",\"\", INDEX(InvoiceData!M8:M107, $Z30-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z30=\"\",\"\", INDEX(InvoiceData!N8:N107, $Z30-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z30=\"\",\"\", INDEX(InvoiceData!O8:O107, $Z30-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z30=\"\",\"\", INDEX(InvoiceData!P8:P107, $Z30-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z30=\"\",\"\", INDEX(InvoiceData!R8:R107, $Z30-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z30=\"\",\"\", INDEX(InvoiceData!T8:T107, $Z30-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z30=\"\",\"\", INDEX(InvoiceData!V8:V107, $Z30-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z30=\"\",\"\", INDEX(InvoiceData!X8:X107, $Z30-7)))","v":""},{"$nulls":13},{"$f":"IF($B$4=\"\",\"\", IFERROR(_xlfn.AGGREGATE(15,6,ROW(InvoiceData!$A$8:$A$207)/(InvoiceData!$A$8:$A$207=$B$4), ROWS($Z$19:Z30)), \"\"))","v":""}]
[13,{"$f":"IF($B$4=\"\", \"\", IF($Z31=\"\",\"\", INDEX(InvoiceData!J8:J107, $Z31-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z31=\"\",\"\", INDEX(InvoiceData!K8:K107, $Z31-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z31=\"\",\"\", INDEX(InvoiceData!L8:L107, $Z31-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z31=\"\",\"\", INDEX(InvoiceData!M8:M107, $Z31-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z31=\"\",\"\", INDEX(InvoiceData!N8:N107, $Z31-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z31=\"\",\"\", INDEX(InvoiceData!O8:O107, $Z31-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z31=\"\",\"\", INDEX(InvoiceData!P8:P107, $Z31-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z31=\"\",\"\", INDEX(InvoiceData!R8:R107, $Z31-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z31=\"\",\"\", INDEX(InvoiceData!T8:T107, $Z31-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z31=\"\",\"\", INDEX(InvoiceData!V8:V107, $Z31-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z31=\"\",\"\", INDEX(InvoiceData!X8:X107, $Z31-7)))","v":""},{"$nulls":13},{"$f":"IF($B$4=\"\",\"\", IFERROR(_xlfn.AGGREGATE(15,6,ROW(InvoiceData!$A$8:$A$207)/(InvoiceData!$A$8:$A$207=$B$4), ROWS($Z$19:Z31)), \"\"))","v":""}]
[14,{"$f":"IF($B$4=\"\", \"\", IF($Z32=\"\",\"\", INDEX(InvoiceData!J8:J107, $Z32-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z32=\"\",\"\", INDEX(InvoiceData!K8:K107, $Z32-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z32=\"\",\"\", INDEX(InvoiceData!L8:L107, $Z32-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z32=\"\",\"\", INDEX(InvoiceData!M8:M107, $Z32-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z32=\"\",\"\", INDEX(InvoiceData!N8:N107, $Z32-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z32=\"\",\"\", INDEX(InvoiceData!O8:O107, $Z32-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z32=\"\",\"\", INDEX(InvoiceData!P8:P107, $Z32-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z32=\"\",\"\", INDEX(InvoiceData!R8:R107, $Z32-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z32=\"\",\"\", INDEX(InvoiceData!T8:T107, $Z32-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z32=\"\",\"\", INDEX(InvoiceData!V8:V107, $Z32-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z32=\"\",\"\", INDEX(InvoiceData!X8:X107, $Z32-7)))","v":""},{"$nulls":13},{"$f":"IF($B$4=\"\",\"\", IFERROR(_xlfn.AGGREGATE(15,6,ROW(InvoiceData!$A$8:$A$207)/(InvoiceData!$A$8:$A$207=$B$4), ROWS($Z$19:Z32)), \"\"))","v":""}]
[15,{"$f":"IF($B$4=\"\", \"\", IF($Z33=\"\",\"\", INDEX(InvoiceData!J8:J107, $Z33-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z33=\"\",\"\", INDEX(InvoiceData!K8:K107, $Z33-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z33=\"\",\"\", INDEX(InvoiceData!L8:L107, $Z33-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z33=\"\",\"\", INDEX(InvoiceData!M8:M107, $Z33-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z33=\"\",\"\", INDEX(InvoiceData!N8:N107, $Z33-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z33=\"\",\"\", INDEX(InvoiceData!O8:O107, $Z33-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z33=\"\",\"\", INDEX(InvoiceData!P8:P107, $Z33-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z33=\"\",\"\", INDEX(InvoiceData!R8:R107, $Z33-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z33=\"\",\"\", INDEX(InvoiceData!T8:T107, $Z33-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z33=\"\",\"\", INDEX(InvoiceData!V8:V107, $Z33-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z33=\"\",\"\", INDEX(InvoiceData!X8:X107, $Z33-7)))","v":""},{"$nulls":13},{"$f":"IF($B$4=\"\",\"\", IFERROR(_xlfn.AGGREGATE(15,6,ROW(InvoiceData!$A$8:$A$207)/(InvoiceData!$A$8:$A$207=$B$4), ROWS($Z$19:Z33)), \"\"))","v":""}]
[16,{"$f":"IF($B$4=\"\", \"\", IF($Z34=\"\",\"\", INDEX(InvoiceData!J8:J107, $Z34-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z34=\"\",\"\", INDEX(InvoiceData!K8:K107, $Z34-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z34=\"\",\"\", INDEX(InvoiceData!L8:L107, $Z34-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z34=\"\",\"\", INDEX(InvoiceData!M8:M107, $Z34-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z34=\"\",\"\", INDEX(InvoiceData!N8:N107, $Z34-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z34=\"\",\"\", INDEX(InvoiceData!O8:O107, $Z34-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z34=\"\",\"\", INDEX(InvoiceData!P8:P107, $Z34-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z34=\"\",\"\", INDEX(InvoiceData!R8:R107, $Z34-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z34=\"\",\"\", INDEX(InvoiceData!T8:T107, $Z34-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z34=\"\",\"\", INDEX(InvoiceData!V8:V107, $Z34-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z34=\"\",\"\", INDEX(InvoiceData!X8:X107, $Z34-7)))","v":""},{"$nulls":13},{"$f":"IF($B$4=\"\",\"\", IFERROR(_xlfn.AGGREGATE(15,6,ROW(InvoiceData!$A$8:$A$207)/(InvoiceData!$A$8:$A$207=$B$4), ROWS($Z$19:Z34)), \"\"))","v":""}]
[17,{"$f":"IF($B$4=\"\", \"\", IF($Z35=\"\",\"\", INDEX(InvoiceData!J8:J107, $Z35-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z35=\"\",\"\", INDEX(InvoiceData!K8:K107, $Z35-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z35=\"\",\"\", INDEX(InvoiceData!L8:L107, $Z35-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z35=\"\",\"\", INDEX(InvoiceData!M8:M107, $Z35-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z35=\"\",\"\", INDEX(InvoiceData!N8:N107, $Z35-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z35=\"\",\"\", INDEX(InvoiceData!O8:O107, $Z35-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z35=\"\",\"\", INDEX(InvoiceData!P8:P107, $Z35-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z35=\"\",\"\", INDEX(InvoiceData!R8:R107, $Z35-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z35=\"\",\"\", INDEX(InvoiceData!T8:T107, $Z35-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z35=\"\",\"\", INDEX(InvoiceData!V8:V107, $Z35-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z35=\"\",\"\", INDEX(InvoiceData!X8:X107, $Z35-7)))","v":""},{"$nulls":13},{"$f":"IF($B$4=\"\",\"\", IFERROR(_xlfn.AGGREGATE(15,6,ROW(InvoiceData!$A$8:$A$207)/(InvoiceData!$A$8:$A$207=$B$4), ROWS($Z$19:Z35)), \"\"))","v":""}]
[18,{"$f":"IF($B$4=\"\", \"\", IF($Z36=\"\",\"\", INDEX(InvoiceData!J8:J107, $Z36-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z36=\"\",\"\", INDEX(InvoiceData!K8:K107, $Z36-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z36=\"\",\"\", INDEX(InvoiceData!L8:L107, $Z36-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z36=\"\",\"\", INDEX(InvoiceData!M8:M107, $Z36-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z36=\"\",\"\", INDEX(InvoiceData!N8:N107, $Z36-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z36=\"\",\"\", INDEX(InvoiceData!O8:O107, $Z36-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z36=\"\",\"\", INDEX(InvoiceData!P8:P107, $Z36-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z36=\"\",\"\", INDEX(InvoiceData!R8:R107, $Z36-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z36=\"\",\"\", INDEX(InvoiceData!T8:T107, $Z36-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z36=\"\",\"\", INDEX(InvoiceData!V8:V107, $Z36-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z36=\"\",\"\", INDEX(InvoiceData!X8:X107, $Z36-7)))","v":""},{"$nulls":13},{"$f":"IF($B$4=\"\",\"\", IFERROR(_xlfn.AGGREGATE(15,6,ROW(InvoiceData!$A$8:$A$207)/(InvoiceData!$A$8:$A$207=$B$4), ROWS($Z$19:Z36)), \"\"))","v":""}]
[19,{"$f":"IF($B$4=\"\", \"\", IF($Z37=\"\",\"\", INDEX(InvoiceData!J8:J107, $Z37-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z37=\"\",\"\", INDEX(InvoiceData!K8:K107, $Z37-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z37=\"\",\"\", INDEX(InvoiceData!L8:L107, $Z37-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z37=\"\",\"\", INDEX(InvoiceData!M8:M107, $Z37-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z37=\"\",\"\", INDEX(InvoiceData!N8:N107, $Z37-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z37=\"\",\"\", INDEX(InvoiceData!O8:O107, $Z37-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z37=\"\",\"\", INDEX(InvoiceData!P8:P107, $Z37-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z37=\"\",\"\", INDEX(InvoiceData!R8:R107, $Z37-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z37=\"\",\"\", INDEX(InvoiceData!T8:T107, $Z37-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z37=\"\",\"\", INDEX(InvoiceData!V8:V107, $Z37-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z37=\"\",\"\", INDEX(InvoiceData!X8:X107, $Z37-7)))","v":""},{"$nulls":13},{"$f":"IF($B$4=\"\",\"\", IFERROR(_xlfn.AGGREGATE(15,6,ROW(InvoiceData!$A$8:$A$207)/(InvoiceData!$A$8:$A$207=$B$4), ROWS($Z$19:Z37)), \"\"))","v":""}]
[20,{"$f":"IF($B$4=\"\", \"\", IF($Z38=\"\",\"\", INDEX(InvoiceData!J8:J107, $Z38-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z38=\"\",\"\", INDEX(InvoiceData!K8:K107, $Z38-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z38=\"\",\"\", INDEX(InvoiceData!L8:L107, $Z38-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z38=\"\",\"\", INDEX(InvoiceData!M8:M107, $Z38-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z38=\"\",\"\", INDEX(InvoiceData!N8:N107, $Z38-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z38=\"\",\"\", INDEX(InvoiceData!O8:O107, $Z38-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z38=\"\",\"\", INDEX(InvoiceData!P8:P107, $Z38-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z38=\"\",\"\", INDEX(InvoiceData!R8:R107, $Z38-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z38=\"\",\"\", INDEX(InvoiceData!T8:T107, $Z38-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z38=\"\",\"\", INDEX(InvoiceData!V8:V107, $Z38-7)))","v":""},{"$f":"IF($B$4=\"\", \"\", IF($Z38=\"\",\"\", INDEX(InvoiceData!X8:X107, $Z38-7)))","v":""},{"$nulls":13},{"$f":"IF($B$4=\"\",\"\", IFERROR(_xlfn.AGGREGATE(15,6,ROW(InvoiceData!$A$8:$A$207)/(InvoiceData!$A$8:$A$207=$B$4), ROWS($Z$19:Z38)), \"\"))","v":""}]
[]
["Totals:",{"$f":"IF($B$4=\"\",\"\", SUMIF(InvoiceData!$A$8:$A$107, $B$4, InvoiceData!O8:O107))","v":11500}]
["Total CGST:",{"$f":"IF($B$4=\"\",\"\", SUMIF(InvoiceData!$A$8:$A$107, $B$4, InvoiceData!R8:R107))","v":1035}]
["Total SGST:",{"$f":"IF($B$4=\"\",\"\", SUMIF(InvoiceData!$A$8:$A$107, $B$4, InvoiceData!T8:T107))","v":1035}]
["Total IGST:",{"$f":"IF($B$4=\"\",\"\", SUMIF(InvoiceData!$A$8:$A$107, $B$4, InvoiceData!V8:V107))","v":0}]
["Total Tax:",{"$f":"IF($B$4=\"\",\"\", SUMIF(InvoiceData!$A$8:$A$107, $B$4, InvoiceData!W8:W107))","v":2070}]
["Invoice Total:",{"$f":"IF($B$4=\"\",\"\", SUMIF(InvoiceData!$A$8:$A$107, $B$4, InvoiceData!X8:X107))","v":13570}]
[]
[]
["Bank: Your Bank Name | A/C: 1234567890 | IFSC: ABCD0123456"]
[]
[]
[{"$nulls":4},"For Your Company Pvt Ltd"]
[]
[]
[{"$nulls":4},"__________________________"]
[{"$nulls":4},"Authorised Signatory"]

{"sheet":"Help & Macros","index":2,"n_rows":16,"n_cols":1,"rows_kept":16}
["How to use this workbook - Quick Steps"]
["1) Enter Invoice lines in the InvoiceData sheet starting row 8. Use Invoice No to group items."]
["2) Go to Printable_A4 sheet, type the Invoice No in cell B4 to generate print view."]
["3) To insert your logo, use the 'Insert Logo' macro (instructions below) or Insert -> Pictures."]
["4) To export the printable sheet to PDF named as the Invoice No, run the ExportPrintableToPDF macro."]
["5) To auto-insert the Next Invoice No into a new row, use the InsertNextInvoice macro."]
{"$rows_empty":9}
["IMPORTANT: Macros require this workbook to be saved as a Macro-Enabled Workbook (.xlsm). After adding macros, save as .xlsm."]

{"sheet":"Controls","index":3,"n_rows":8,"n_cols":1,"rows_kept":8}
["Next Invoice Number (example)"]
["If you have Excel 365, paste this in A8 to auto-generate next number:"]
[]
["If not using Excel 365, enter next invoice manually in A8."]
[]
[]
[]
[{"$f":"\"INV-\" & TEXT(IFERROR(MAX(--RIGHT(InvoiceData!A8:A107,3)),0)+1, \"000\")","v":"INV-002"}]