{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Invoice","Customers","Invoices - Main","Invoice Details"],"not_rendered":{"images":6,"defined_names":8},"read":"whole","date_system":"1900"}

{"sheet":"Invoice","index":0,"n_rows":40,"n_cols":8,"rows_kept":40,"merged":[[0,3,0,6],[3,5,3,6],[35,4,35,5],[36,1,36,2],[36,4,36,5],[37,4,37,5],[38,4,38,5],[39,4,39,5]]}
[{"$nulls":3},"Tired of doing invoices manually? Do you want to get paid earlier? Sign up for Microsoft Invoicing today"]
[{"$nulls":7}," "]
[]
[]
[null,null,"YOUR COMPANY NAME"]
[null,null," Street address"]
[null,null," Town/City, County/Region, Postcode"]
[]
[null,"BILL TO ",{"$f":"IFERROR(VLOOKUP(VLOOKUP(rngInvoice,InvoicesMain[],2,FALSE),CustomerList[],3,TRUE),\"\")","v":"Contoso, Ltd"},{"$f":"\"Phone number: \"&IFERROR(VLOOKUP(VLOOKUP(rngInvoice,InvoicesMain[],2,FALSE),CustomerList[],9,FALSE),\"\")","v":"Phone number: 0121 496 0234"},null,"INVOICE NO.","3-456-2"]
[null,null,{"$f":"IFERROR(IF((VLOOKUP(VLOOKUP(rngInvoice,InvoicesMain[],2,FALSE),CustomerList[],5,FALSE))=\"\",\"\",(VLOOKUP(VLOOKUP(rngInvoice,InvoicesMain[],2,FALSE),CustomerList[],5,FALSE))),\"\")","v":"89 Yewtree Crescent"},{"$f":"\"Fax no.: \"&IFERROR(VLOOKUP(VLOOKUP(rngInvoice,InvoicesMain[],2,FALSE),CustomerList[],11,FALSE),\"\")","v":"Fax no.: 0121 496 0243"},null,"Invoice Date:",{"$f":"IFERROR(IF(VLOOKUP(rngInvoice,InvoicesMain[],3,FALSE)=\"\",\"\",VLOOKUP(rngInvoice,InvoicesMain[],3,FALSE)),\"\")","v":"2019-11-27"}]
[null,null,{"$f":"IFERROR(VLOOKUP(VLOOKUP(rngInvoice,InvoicesMain[],2,FALSE),CustomerList[],6,FALSE)&\", \"& VLOOKUP(VLOOKUP(G9,InvoicesMain[],2,FALSE),CustomerList[],7,FALSE)&\" \"&VLOOKUP(VLOOKUP(G9,InvoicesMain[],2,FALSE),CustomerList[],8,FALSE),\"\")","v":"Sheffield, South Yorkshire 98765"},{"$f":"\"Email: \"&IFERROR(VLOOKUP(VLOOKUP(rngInvoice,InvoicesMain[],2,FALSE),CustomerList[],10,FALSE),\"\")","v":"Email: someone@example.com"}]
[]
[]
[null,"Item no.","Description","Qty","Unit price","Discount","Price"]
[null,{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(2:2)), MATCH($B$14, InvoiceDetails[#Headers], 0)),\"\")","v":"Z4568"},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(2:2)), MATCH($C$14, InvoiceDetails[#Headers], 0)),\"\")","v":"Invoice 3-456-2 Data 2"},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(2:2)), MATCH($D$14, InvoiceDetails[#Headers], 0)),\"\")","v":40},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(2:2)), MATCH($E$14, InvoiceDetails[#Headers], 0)),\"\")","v":{"v":4,"d":"£4.00"}},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(2:2)), MATCH($F$14, InvoiceDetails[#Headers], 0)),\"\")","v":{"v":5,"d":"£5.00"}},{"$f":"IFERROR((D15*E15)-F15,\"\")","v":{"v":155,"d":"£155.00"}}]
[null,{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(3:3)), MATCH($B$14, InvoiceDetails[#Headers], 0)),\"\")","v":"Z4569"},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(3:3)), MATCH($C$14, InvoiceDetails[#Headers], 0)),\"\")","v":"Invoice 3-456-2 Data 3"},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(3:3)), MATCH($D$14, InvoiceDetails[#Headers], 0)),\"\")","v":30},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(3:3)), MATCH($E$14, InvoiceDetails[#Headers], 0)),\"\")","v":{"v":6,"d":"£6.00"}},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(3:3)), MATCH($F$14, InvoiceDetails[#Headers], 0)),\"\")","v":{"v":7,"d":"£7.00"}},{"$f":"IFERROR((D16*E16)-F16,\"\")","v":{"v":173,"d":"£173.00"}}]
[null,{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(4:4)), MATCH($B$14, InvoiceDetails[#Headers], 0)),\"\")","v":"Z4570"},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(4:4)), MATCH($C$14, InvoiceDetails[#Headers], 0)),\"\")","v":"Invoice 3-456-2 Data 4"},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(4:4)), MATCH($D$14, InvoiceDetails[#Headers], 0)),\"\")","v":40},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(4:4)), MATCH($E$14, InvoiceDetails[#Headers], 0)),\"\")","v":{"v":7,"d":"£7.00"}},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(4:4)), MATCH($F$14, InvoiceDetails[#Headers], 0)),\"\")","v":{"v":0,"d":"£0.00"}},{"v":280,"d":"£280.00"}]
[null,{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(5:5)), MATCH($B$14, InvoiceDetails[#Headers], 0)),\"\")","v":"Z4571"},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(5:5)), MATCH($C$14, InvoiceDetails[#Headers], 0)),\"\")","v":"Invoice 3-456-2 Data 5"},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(5:5)), MATCH($D$14, InvoiceDetails[#Headers], 0)),\"\")","v":10},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(5:5)), MATCH($E$14, InvoiceDetails[#Headers], 0)),\"\")","v":{"v":4,"d":"£4.00"}},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(5:5)), MATCH($F$14, InvoiceDetails[#Headers], 0)),\"\")","v":{"v":0,"d":"£0.00"}},{"v":40,"d":"£40.00"}]
[null,{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(6:6)), MATCH($B$14, InvoiceDetails[#Headers], 0)),\"\")","v":"Z4572"},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(6:6)), MATCH($C$14, InvoiceDetails[#Headers], 0)),\"\")","v":"Invoice 3-456-2 Data 6"},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(6:6)), MATCH($D$14, InvoiceDetails[#Headers], 0)),\"\")","v":5},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(6:6)), MATCH($E$14, InvoiceDetails[#Headers], 0)),\"\")","v":{"v":8,"d":"£8.00"}},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(6:6)), MATCH($F$14, InvoiceDetails[#Headers], 0)),\"\")","v":{"v":0,"d":"£0.00"}},{"v":40,"d":"£40.00"}]
[null,{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(7:7)), MATCH($B$14, InvoiceDetails[#Headers], 0)),\"\")","v":"Z4573"},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(7:7)), MATCH($C$14, InvoiceDetails[#Headers], 0)),\"\")","v":"Invoice 3-456-2 Data 7"},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(7:7)), MATCH($D$14, InvoiceDetails[#Headers], 0)),\"\")","v":70},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(7:7)), MATCH($E$14, InvoiceDetails[#Headers], 0)),\"\")","v":{"v":6,"d":"£6.00"}},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(7:7)), MATCH($F$14, InvoiceDetails[#Headers], 0)),\"\")","v":{"v":0,"d":"£0.00"}},{"v":420,"d":"£420.00"}]
[null,{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(8:8)), MATCH($B$14, InvoiceDetails[#Headers], 0)),\"\")","v":"Z4574"},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(8:8)), MATCH($C$14, InvoiceDetails[#Headers], 0)),\"\")","v":"Invoice 3-456-2 Data 8"},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(8:8)), MATCH($D$14, InvoiceDetails[#Headers], 0)),\"\")","v":25},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(8:8)), MATCH($E$14, InvoiceDetails[#Headers], 0)),\"\")","v":{"v":4,"d":"£4.00"}},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(8:8)), MATCH($F$14, InvoiceDetails[#Headers], 0)),\"\")","v":{"v":0,"d":"£0.00"}},{"v":100,"d":"£100.00"}]
[null,{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(9:9)), MATCH($B$14, InvoiceDetails[#Headers], 0)),\"\")","v":"Z4575"},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(9:9)), MATCH($C$14, InvoiceDetails[#Headers], 0)),\"\")","v":"Invoice 3-456-2 Data 9"},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(9:9)), MATCH($D$14, InvoiceDetails[#Headers], 0)),\"\")","v":5},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(9:9)), MATCH($E$14, InvoiceDetails[#Headers], 0)),\"\")","v":{"v":7,"d":"£7.00"}},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(9:9)), MATCH($F$14, InvoiceDetails[#Headers], 0)),\"\")","v":{"v":3,"d":"£3.00"}},{"v":32,"d":"£32.00"}]
[null,{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(10:10)), MATCH($B$14, InvoiceDetails[#Headers], 0)),\"\")","v":"Z4576"},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(10:10)), MATCH($C$14, InvoiceDetails[#Headers], 0)),\"\")","v":"Invoice 3-456-2 Data 10"},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(10:10)), MATCH($D$14, InvoiceDetails[#Headers], 0)),\"\")","v":80},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(10:10)), MATCH($E$14, InvoiceDetails[#Headers], 0)),\"\")","v":{"v":1,"d":"£1.00"}},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(10:10)), MATCH($F$14, InvoiceDetails[#Headers], 0)),\"\")","v":{"v":0,"d":"£0.00"}},{"v":80,"d":"£80.00"}]
[null,{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(11:11)), MATCH($B$14, InvoiceDetails[#Headers], 0)),\"\")","v":"Z4577"},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(11:11)), MATCH($C$14, InvoiceDetails[#Headers], 0)),\"\")","v":"Invoice 3-456-2 Data 11"},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(11:11)), MATCH($D$14, InvoiceDetails[#Headers], 0)),\"\")","v":65},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(11:11)), MATCH($E$14, InvoiceDetails[#Headers], 0)),\"\")","v":{"v":7,"d":"£7.00"}},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(11:11)), MATCH($F$14, InvoiceDetails[#Headers], 0)),\"\")","v":{"v":0,"d":"£0.00"}},{"v":455,"d":"£455.00"}]
[null,{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(12:12)), MATCH($B$14, InvoiceDetails[#Headers], 0)),\"\")","v":"Z4578"},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(12:12)), MATCH($C$14, InvoiceDetails[#Headers], 0)),\"\")","v":"Invoice 3-456-2 Data 12"},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(12:12)), MATCH($D$14, InvoiceDetails[#Headers], 0)),\"\")","v":44},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(12:12)), MATCH($E$14, InvoiceDetails[#Headers], 0)),\"\")","v":{"v":1,"d":"£1.00"}},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(12:12)), MATCH($F$14, InvoiceDetails[#Headers], 0)),\"\")","v":{"v":0,"d":"£0.00"}},{"v":44,"d":"£44.00"}]
[null,{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(13:13)), MATCH($B$14, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(13:13)), MATCH($C$14, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(13:13)), MATCH($D$14, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(13:13)), MATCH($E$14, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(13:13)), MATCH($F$14, InvoiceDetails[#Headers], 0)),\"\")","v":""},""]
[null,{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(14:14)), MATCH($B$14, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(14:14)), MATCH($C$14, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(14:14)), MATCH($D$14, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(14:14)), MATCH($E$14, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(14:14)), MATCH($F$14, InvoiceDetails[#Headers], 0)),\"\")","v":""},""]
[null,{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(15:15)), MATCH($B$14, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(15:15)), MATCH($C$14, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(15:15)), MATCH($D$14, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(15:15)), MATCH($E$14, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(15:15)), MATCH($F$14, InvoiceDetails[#Headers], 0)),\"\")","v":""},""]
[null,{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(16:16)), MATCH($B$14, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(16:16)), MATCH($C$14, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(16:16)), MATCH($D$14, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(16:16)), MATCH($E$14, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(16:16)), MATCH($F$14, InvoiceDetails[#Headers], 0)),\"\")","v":""},""]
[null,{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(17:17)), MATCH($B$14, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(17:17)), MATCH($C$14, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(17:17)), MATCH($D$14, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(17:17)), MATCH($E$14, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(17:17)), MATCH($F$14, InvoiceDetails[#Headers], 0)),\"\")","v":""},""]
[null,{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(18:18)), MATCH($B$14, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(18:18)), MATCH($C$14, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(18:18)), MATCH($D$14, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(18:18)), MATCH($E$14, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(18:18)), MATCH($F$14, InvoiceDetails[#Headers], 0)),\"\")","v":""},""]
[null,{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(19:19)), MATCH($B$14, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(19:19)), MATCH($C$14, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(19:19)), MATCH($D$14, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(19:19)), MATCH($E$14, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(19:19)), MATCH($F$14, InvoiceDetails[#Headers], 0)),\"\")","v":""},""]
[null,{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(20:20)), MATCH($B$14, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(20:20)), MATCH($C$14, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(20:20)), MATCH($D$14, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(20:20)), MATCH($E$14, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(20:20)), MATCH($F$14, InvoiceDetails[#Headers], 0)),\"\")","v":""},""]
[null,{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(21:21)), MATCH($B$14, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(21:21)), MATCH($C$14, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(21:21)), MATCH($D$14, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(21:21)), MATCH($E$14, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[Invoice no.]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(21:21)), MATCH($F$14, InvoiceDetails[#Headers], 0)),\"\")","v":""},""]
[]
[{"$nulls":4},"Invoice Subtotal",null,{"$f":"SUM(ProjectInvoice[Price])","v":{"v":1819,"d":"£1,819.00"}}]
[null,"Total due in <#> days. Overdue accounts subject to a service charge of <#>% per month.",null,null,{"$f":"IFERROR(\"Sales Tax (\" & TEXT(VLOOKUP(rngInvoice,InvoicesMain[],5),\"0.00%\") & \")\",\"Sales Tax Rate\")","v":"Sales Tax (8.75%)"},null,{"$f":"IFERROR(G36*VLOOKUP(rngInvoice,InvoicesMain[],5),0)","v":{"v":159.1625,"d":"£159.16"}}]
[{"$nulls":4},"Other",null,{"$f":"IFERROR(VLOOKUP(rngInvoice,InvoicesMain[],6),0)","v":{"v":0,"d":"£0.00"}}]
[null,{"$f":"\"Make all checks payable to \"&CompanyName&\".\"","v":"Make all checks payable to YOUR COMPANY NAME."},null,null,"Deposit Received",null,{"$f":"IFERROR(VLOOKUP(rngInvoice,InvoicesMain[],7),0)","v":{"v":0,"d":"£0.00"}}]
[null,"Thank you for your business.",null,null,"TOTAL",null,{"$f":"(G36+G37+G38)-G39","v":{"v":1978.1625,"d":"£1,978.16"}}]

{"sheet":"Customers","index":1,"n_rows":7,"n_cols":13,"rows_kept":7}
[{"$nulls":12}," "]
[]
[]
[null,"Lookup","Company #","Company name","Contact name","Address","Town/city","County","Postcode","Phone number","Email","Fax no."]
[null,{"$f":"C5& \" - \"&D5","v":"1 - Tailspin Toys "},1,"Tailspin Toys ","Mirjam Nilsson","987 Birch Street","Birmingham","West Midlands",12345,"0114 496 0345","someone@example.com","0114 496 0354"]
[null,"2 - Contoso, Ltd",2,"Contoso, Ltd","Angelica Astrom","89 Yewtree Crescent","Sheffield","South Yorkshire",98765,"0121 496 0234","someone@example.com","0121 496 0243"]
[null,"Total",{"$f":"\"Total Customers: \"&SUBTOTAL(103,CustomerList[Company '#])","v":"Total Customers: 2"}]

{"sheet":"Invoices - Main","index":2,"n_rows":7,"n_cols":12,"rows_kept":7}
[{"$nulls":11}," "]
[]
[]
[null,"Invoice no.","Company","Invoice date","Project description","VAT rate","Other","Deposit","Detail Total","Invoice total","Notes"]
[null,"3-456-1","1 - Tailspin Toys ",{"$f":"TODAY()","v":"2019-11-17"},"Project 1",{"v":0.0875,"d":"8.75%"},{"v":100,"d":"£100.00"},{"v":100,"d":"£100.00"},{"$f":"SUMIF(InvoiceDetails[Invoice no.],\"=\"&InvoicesMain[[#This Row],[Invoice no.]],InvoiceDetails[Total])","v":{"v":2660,"d":"£2,660.00"}},{"$f":"(InvoicesMain[[#This Row],[Detail Total]]*(1+InvoicesMain[[#This Row],[VAT rate]]))+InvoicesMain[[#This Row],[Other]]-InvoicesMain[[#This Row],[Deposit]]","v":{"v":2892.7499999999995,"d":"£2,892.75"}}]
[null,"3-456-2","2 - Contoso, Ltd",{"$f":"TODAY()+10","v":"2019-11-27"},"Project 2",{"v":0.0875,"d":"8.75%"},null,null,{"$f":"SUMIF(InvoiceDetails[Invoice no.],\"=\"&InvoicesMain[[#This Row],[Invoice no.]],InvoiceDetails[Total])","v":{"v":2014,"d":"£2,014.00"}},{"$f":"(InvoicesMain[[#This Row],[Detail Total]]*(1+InvoicesMain[[#This Row],[VAT rate]]))+InvoicesMain[[#This Row],[Other]]-InvoicesMain[[#This Row],[Deposit]]","v":{"v":2190.225,"d":"£2,190.23"}}]
[null,{"$f":"\"Total Invoices: \"&SUBTOTAL(103,InvoicesMain[Invoice no.])","v":"Total Invoices: 2"},{"$nulls":3},"Totals:",{"$f":"SUBTOTAL(109,InvoicesMain[Other])","v":{"v":100,"d":"£100.00"}},{"$f":"SUBTOTAL(109,InvoicesMain[Deposit])","v":{"v":100,"d":"£100.00"}},{"$f":"SUBTOTAL(109,InvoicesMain[Detail Total])","v":{"v":4674,"d":"£4,674.00"}},{"$f":"SUBTOTAL(109,InvoicesMain[Invoice total])","v":{"v":5082.974999999999,"d":"£5,082.98"}}]

{"sheet":"Invoice Details","index":3,"n_rows":36,"n_cols":9,"rows_kept":36}
[{"$nulls":8}," "]
[]
[]
[null,"Description","Invoice no.","Item no.","Qty","Unit price","Discount","Total"]
[null,"Invoice 3-456-1 Data 1","3-456-1",1,1,{"v":1,"d":"£1.00"},{"v":1,"d":"£1.00"},{"$f":"(InvoiceDetails[[#This Row],[Qty]]*InvoiceDetails[[#This Row],[Unit price]])-InvoiceDetails[[#This Row],[Discount]]","v":{"v":0,"d":"£0.00"}}]
[null,"Invoice 3-456-1 Data 2","3-456-1",2,2,{"v":2,"d":"£2.00"},{"v":2,"d":"£2.00"},{"$f":"(InvoiceDetails[[#This Row],[Qty]]*InvoiceDetails[[#This Row],[Unit price]])-InvoiceDetails[[#This Row],[Discount]]","v":{"v":2,"d":"£2.00"}}]
[null,"Invoice 3-456-1 Data 3","3-456-1",3,3,{"v":3,"d":"£3.00"},{"v":3,"d":"£3.00"},{"$f":"(InvoiceDetails[[#This Row],[Qty]]*InvoiceDetails[[#This Row],[Unit price]])-InvoiceDetails[[#This Row],[Discount]]","v":{"v":6,"d":"£6.00"}}]
[null,"Invoice 3-456-1 Data 4","3-456-1",4,4,{"v":4,"d":"£4.00"},{"v":4,"d":"£4.00"},{"$f":"(InvoiceDetails[[#This Row],[Qty]]*InvoiceDetails[[#This Row],[Unit price]])-InvoiceDetails[[#This Row],[Discount]]","v":{"v":12,"d":"£12.00"}}]
[null,"Invoice 3-456-1 Data 5","3-456-1",5,5,{"v":5,"d":"£5.00"},{"v":5,"d":"£5.00"},{"$f":"(InvoiceDetails[[#This Row],[Qty]]*InvoiceDetails[[#This Row],[Unit price]])-InvoiceDetails[[#This Row],[Discount]]","v":{"v":20,"d":"£20.00"}}]
[null,"Invoice 3-456-1 Data 6","3-456-1",6,6,{"v":6,"d":"£6.00"},{"v":6,"d":"£6.00"},{"$f":"(InvoiceDetails[[#This Row],[Qty]]*InvoiceDetails[[#This Row],[Unit price]])-InvoiceDetails[[#This Row],[Discount]]","v":{"v":30,"d":"£30.00"}}]
[null,"Invoice 3-456-1 Data 7","3-456-1",7,7,{"v":7,"d":"£7.00"},{"v":7,"d":"£7.00"},{"$f":"(InvoiceDetails[[#This Row],[Qty]]*InvoiceDetails[[#This Row],[Unit price]])-InvoiceDetails[[#This Row],[Discount]]","v":{"v":42,"d":"£42.00"}}]
[null,"Invoice 3-456-1 Data 8","3-456-1",8,8,{"v":8,"d":"£8.00"},{"v":8,"d":"£8.00"},{"$f":"(InvoiceDetails[[#This Row],[Qty]]*InvoiceDetails[[#This Row],[Unit price]])-InvoiceDetails[[#This Row],[Discount]]","v":{"v":56,"d":"£56.00"}}]
[null,"Invoice 3-456-1 Data 9","3-456-1",9,9,{"v":9,"d":"£9.00"},{"v":9,"d":"£9.00"},{"$f":"(InvoiceDetails[[#This Row],[Qty]]*InvoiceDetails[[#This Row],[Unit price]])-InvoiceDetails[[#This Row],[Discount]]","v":{"v":72,"d":"£72.00"}}]
[null,"Invoice 3-456-1 Data 10","3-456-1",10,10,{"v":10,"d":"£10.00"},{"v":10,"d":"£10.00"},{"$f":"(InvoiceDetails[[#This Row],[Qty]]*InvoiceDetails[[#This Row],[Unit price]])-InvoiceDetails[[#This Row],[Discount]]","v":{"v":90,"d":"£90.00"}}]
[null,"Invoice 3-456-1 Data 11","3-456-1",11,11,{"v":11,"d":"£11.00"},{"v":11,"d":"£11.00"},{"$f":"(InvoiceDetails[[#This Row],[Qty]]*InvoiceDetails[[#This Row],[Unit price]])-InvoiceDetails[[#This Row],[Discount]]","v":{"v":110,"d":"£110.00"}}]
[null,"Invoice 3-456-1 Data 12","3-456-1",12,12,{"v":12,"d":"£12.00"},{"v":12,"d":"£12.00"},{"$f":"(InvoiceDetails[[#This Row],[Qty]]*InvoiceDetails[[#This Row],[Unit price]])-InvoiceDetails[[#This Row],[Discount]]","v":{"v":132,"d":"£132.00"}}]
[null,"Invoice 3-456-1 Data 13","3-456-1",13,13,{"v":13,"d":"£13.00"},{"v":13,"d":"£13.00"},{"$f":"(InvoiceDetails[[#This Row],[Qty]]*InvoiceDetails[[#This Row],[Unit price]])-InvoiceDetails[[#This Row],[Discount]]","v":{"v":156,"d":"£156.00"}}]
[null,"Invoice 3-456-1 Data 14","3-456-1",14,14,{"v":14,"d":"£14.00"},{"v":14,"d":"£14.00"},{"$f":"(InvoiceDetails[[#This Row],[Qty]]*InvoiceDetails[[#This Row],[Unit price]])-InvoiceDetails[[#This Row],[Discount]]","v":{"v":182,"d":"£182.00"}}]
[null,"Invoice 3-456-1 Data 15","3-456-1",15,15,{"v":15,"d":"£15.00"},{"v":15,"d":"£15.00"},{"$f":"(InvoiceDetails[[#This Row],[Qty]]*InvoiceDetails[[#This Row],[Unit price]])-InvoiceDetails[[#This Row],[Discount]]","v":{"v":210,"d":"£210.00"}}]
[null,"Invoice 3-456-1 Data 16","3-456-1",16,16,{"v":16,"d":"£16.00"},{"v":16,"d":"£16.00"},{"$f":"(InvoiceDetails[[#This Row],[Qty]]*InvoiceDetails[[#This Row],[Unit price]])-InvoiceDetails[[#This Row],[Discount]]","v":{"v":240,"d":"£240.00"}}]
[null,"Invoice 3-456-1 Data 17","3-456-1",17,17,{"v":17,"d":"£17.00"},{"v":17,"d":"£17.00"},{"$f":"(InvoiceDetails[[#This Row],[Qty]]*InvoiceDetails[[#This Row],[Unit price]])-InvoiceDetails[[#This Row],[Discount]]","v":{"v":272,"d":"£272.00"}}]
[null,"Invoice 3-456-1 Data 18","3-456-1",18,18,{"v":18,"d":"£18.00"},{"v":18,"d":"£18.00"},{"$f":"(InvoiceDetails[[#This Row],[Qty]]*InvoiceDetails[[#This Row],[Unit price]])-InvoiceDetails[[#This Row],[Discount]]","v":{"v":306,"d":"£306.00"}}]
[null,"Invoice 3-456-1 Data 19","3-456-1",19,19,{"v":19,"d":"£19.00"},{"v":19,"d":"£19.00"},{"$f":"(InvoiceDetails[[#This Row],[Qty]]*InvoiceDetails[[#This Row],[Unit price]])-InvoiceDetails[[#This Row],[Discount]]","v":{"v":342,"d":"£342.00"}}]
[null,"Invoice 3-456-1 Data 20","3-456-1",20,20,{"v":20,"d":"£20.00"},{"v":20,"d":"£20.00"},{"$f":"(InvoiceDetails[[#This Row],[Qty]]*InvoiceDetails[[#This Row],[Unit price]])-InvoiceDetails[[#This Row],[Discount]]","v":{"v":380,"d":"£380.00"}}]
[null,"Invoice 3-456-2 Data 1","3-456-2","Z4567",39,{"v":5,"d":"£5.00"},null,{"$f":"(InvoiceDetails[[#This Row],[Qty]]*InvoiceDetails[[#This Row],[Unit price]])-InvoiceDetails[[#This Row],[Discount]]","v":{"v":195,"d":"£195.00"}}]
[null,"Invoice 3-456-2 Data 2","3-456-2","Z4568",40,{"v":4,"d":"£4.00"},{"v":5,"d":"£5.00"},{"$f":"(InvoiceDetails[[#This Row],[Qty]]*InvoiceDetails[[#This Row],[Unit price]])-InvoiceDetails[[#This Row],[Discount]]","v":{"v":155,"d":"£155.00"}}]
[null,"Invoice 3-456-2 Data 3","3-456-2","Z4569",30,{"v":6,"d":"£6.00"},{"v":7,"d":"£7.00"},{"$f":"(InvoiceDetails[[#This Row],[Qty]]*InvoiceDetails[[#This Row],[Unit price]])-InvoiceDetails[[#This Row],[Discount]]","v":{"v":173,"d":"£173.00"}}]
[null,"Invoice 3-456-2 Data 4","3-456-2","Z4570",40,{"v":7,"d":"£7.00"},null,{"$f":"(InvoiceDetails[[#This Row],[Qty]]*InvoiceDetails[[#This Row],[Unit price]])-InvoiceDetails[[#This Row],[Discount]]","v":{"v":280,"d":"£280.00"}}]
[null,"Invoice 3-456-2 Data 5","3-456-2","Z4571",10,{"v":4,"d":"£4.00"},null,{"$f":"(InvoiceDetails[[#This Row],[Qty]]*InvoiceDetails[[#This Row],[Unit price]])-InvoiceDetails[[#This Row],[Discount]]","v":{"v":40,"d":"£40.00"}}]
[null,"Invoice 3-456-2 Data 6","3-456-2","Z4572",5,{"v":8,"d":"£8.00"},null,{"$f":"(InvoiceDetails[[#This Row],[Qty]]*InvoiceDetails[[#This Row],[Unit price]])-InvoiceDetails[[#This Row],[Discount]]","v":{"v":40,"d":"£40.00"}}]
[null,"Invoice 3-456-2 Data 7","3-456-2","Z4573",70,{"v":6,"d":"£6.00"},null,{"$f":"(InvoiceDetails[[#This Row],[Qty]]*InvoiceDetails[[#This Row],[Unit price]])-InvoiceDetails[[#This Row],[Discount]]","v":{"v":420,"d":"£420.00"}}]
[null,"Invoice 3-456-2 Data 8","3-456-2","Z4574",25,{"v":4,"d":"£4.00"},null,{"$f":"(InvoiceDetails[[#This Row],[Qty]]*InvoiceDetails[[#This Row],[Unit price]])-InvoiceDetails[[#This Row],[Discount]]","v":{"v":100,"d":"£100.00"}}]
[null,"Invoice 3-456-2 Data 9","3-456-2","Z4575",5,{"v":7,"d":"£7.00"},{"v":3,"d":"£3.00"},{"$f":"(InvoiceDetails[[#This Row],[Qty]]*InvoiceDetails[[#This Row],[Unit price]])-InvoiceDetails[[#This Row],[Discount]]","v":{"v":32,"d":"£32.00"}}]
[null,"Invoice 3-456-2 Data 10","3-456-2","Z4576",80,{"v":1,"d":"£1.00"},null,{"$f":"(InvoiceDetails[[#This Row],[Qty]]*InvoiceDetails[[#This Row],[Unit price]])-InvoiceDetails[[#This Row],[Discount]]","v":{"v":80,"d":"£80.00"}}]
[null,"Invoice 3-456-2 Data 11","3-456-2","Z4577",65,{"v":7,"d":"£7.00"},null,{"$f":"(InvoiceDetails[[#This Row],[Qty]]*InvoiceDetails[[#This Row],[Unit price]])-InvoiceDetails[[#This Row],[Discount]]","v":{"v":455,"d":"£455.00"}}]
[null,"Invoice 3-456-2 Data 12","3-456-2","Z4578",44,{"v":1,"d":"£1.00"},null,{"$f":"(InvoiceDetails[[#This Row],[Qty]]*InvoiceDetails[[#This Row],[Unit price]])-InvoiceDetails[[#This Row],[Discount]]","v":{"v":44,"d":"£44.00"}}]