{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Invoice","Your Company Details","Customer Details","Product Details"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":10,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Invoice","index":0,"n_rows":37,"n_cols":14,"rows_kept":37,"cut":false,"hidden":false,"merged":[[9,2,9,8],[22,10,22,11],[27,10,27,11],[26,10,26,11],[23,10,23,11],[19,10,19,11],[17,10,17,11],[20,10,20,11],[21,10,21,11],[25,2,25,6],[1,15,1,20],[15,2,15,6],[16,2,16,6],[8,9,8,10],[14,10,14,11],[15,10,15,11],[16,10,16,11],[3,15,3,20],[5,15,6,20],[4,15,4,20],[8,15,8,20],[11,5,11,8],[2,9,2,12],[5,2,5,6],[6,2,7,8],[8,2,8,8],[0,0,0,12],[1,6,1,12],[6,0,8,0],[5,9,5,10],[6,1,8,1],[2,1,2,3],[2,5,2,7],[45,0,45,12],[14,2,14,6],[38,9,43,11],[10,9,11,10],[10,11,11,11],[38,2,43,7],[18,2,18,6],[19,2,19,6],[29,10,29,11],[17,2,17,6],[25,10,25,11],[20,2,20,6],[21,2,21,6],[35,1,35,2],[35,3,35,11],[22,2,22,6],[13,15,13,20],[14,15,14,20],[10,15,10,20],[29,1,29,8],[33,10,33,11],[15,15,15,20],[24,2,24,6],[26,2,26,6],[18,10,18,11],[11,2,11,3],[23,2,23,6],[24,10,24,11],[27,2,27,6],[31,10,31,11],[31,1,31,8],[33,1,33,8]]}
["INVOICE"]
[null,null,null,null,null,null,{"$f":"CompanyName & CHAR(10) & AddrLine1 & CHAR(10) & AddrLine2 & CHAR(10) & AddrLine3","v":"My Company Private Limited\n#795 E DRAGRAM\nTUCSON\nAZ 85705"}]
["( ",{"$f":"Phone1 & IF(Phone2<>\"\",CHAR(10) & Phone2,\"\")","v":"+31 - Phone 1 786 4354"},null,null," * ",{"$f":"emailID","v":"vishwamitra01@gmail.com"},null,null," :",{"$f":"webURL","v":"http://www.learnexcelmacro.com"}]
[]
[]
[null,null,"Enim Diam Vel Industries",null,null,null,null,null,null,"Invoice#",null,"A1234"]
[null,"G",{"$f":"INDEX('Customer Details'!$E$4:$E$33,MATCH(C6,'Customer Details'!$D$4:$D$33,0))","v":"Ap #950-5104 Dolor St."}]
[]
[null,null,{"$f":"INDEX('Customer Details'!$F$4:$F$33,MATCH(C6,'Customer Details'!$D$4:$D$33,0))","v":"Montpelier"},null,null,null,null,null,null,"Date",null,"2015-09-04"]
[null,null,{"$f":"INDEX('Customer Details'!$G$4:$G$33,MATCH(C6,'Customer Details'!$D$4:$D$33,0))","v":12771}]
[null,null,null,null,null,null,null,null,null,"Due Date",null,"2015-12-31"]
[null,"(",{"$f":"INDEX('Customer Details'!$H$4:$H$33,MATCH(C6,'Customer Details'!$D$4:$D$33,0))","v":"1-440-223-8336"},null,"*\n",{"$f":"INDEX('Customer Details'!$I$4:$I$33,MATCH(C6,'Customer Details'!$D$4:$D$33,0))","v":"scelerisque.sed@blanditcongueIn.net"}]
[]
[]
[null,"Sl#","Product Description",null,null,null,null,"Unit Price","Qty","Discount","Total"]
[null,{"$f":"IF(OFFSET(C16,,0)<>\"\",ROW()-15,\"\")","v":1},"Funtone",null,null,null,null,{"$f":"IFERROR(INDEX('Product Details'!$E$5:$E$25,MATCH(C16,'Product Details'!$D$5:$D$25,0)),0)","v":32.5},2,0.05,{"$f":"(H16*I16)-(H16*I16*J16)","v":61.75},null,null,{"$f":"IF(AND($C16<>\"\",OR($I16=0,$I16=\"\")),1,0)","v":0}]
[null,{"$f":"IF(OFFSET(C17,,0)<>\"\",ROW()-15,\"\")","v":2},"Softhome",null,null,null,null,{"$f":"IFERROR(INDEX('Product Details'!$E$5:$E$25,MATCH(C17,'Product Details'!$D$5:$D$25,0)),0)","v":101.5},1,null,{"$f":"(H17*I17)-(H17*I17*J17)","v":101.5},null,null,{"$f":"IF(AND($C17<>\"\",OR($I17=0,$I17=\"\")),1,0)","v":0}]
[null,3,"Lexiqvoair",null,null,null,null,{"$f":"IFERROR(INDEX('Product Details'!$E$5:$E$25,MATCH(C18,'Product Details'!$D$5:$D$25,0)),0)","v":4},null,null,{"$f":"(H18*I18)-(H18*I18*J18)","v":0},null,null,1]
[null,4,"Voya-Tip",null,null,null,null,{"$f":"IFERROR(INDEX('Product Details'!$E$5:$E$25,MATCH(C19,'Product Details'!$D$5:$D$25,0)),0)","v":34},1,null,34,null,null,0]
[null,5,"Subsing",null,null,null,null,{"$f":"IFERROR(INDEX('Product Details'!$E$5:$E$25,MATCH(C20,'Product Details'!$D$5:$D$25,0)),0)","v":45.7},1,0.06,{"$f":"(H20*I20)-(H20*I20*J20)","v":42.958000000000006},null,null,0]
[null,6,"Year Air",null,null,null,null,{"$f":"IFERROR(INDEX('Product Details'!$E$5:$E$25,MATCH(C21,'Product Details'!$D$5:$D$25,0)),0)","v":234.6},1,null,234.6,null,null,0]
[null,7,"Math Zenfax",null,null,null,null,{"$f":"IFERROR(INDEX('Product Details'!$E$5:$E$25,MATCH(C22,'Product Details'!$D$5:$D$25,0)),0)","v":45.6},null,null,0,null,null,1]
[null,8,"Zum Lamlab",null,null,null,null,{"$f":"IFERROR(INDEX('Product Details'!$E$5:$E$25,MATCH(C23,'Product Details'!$D$5:$D$25,0)),0)","v":100},1,null,100,null,null,0]
[null,9,"Mat Dankix",null,null,null,null,{"$f":"IFERROR(INDEX('Product Details'!$E$5:$E$25,MATCH(C24,'Product Details'!$D$5:$D$25,0)),0)","v":100},2,null,200,null,null,0]
[null,10,"Mat Dankix",null,null,null,null,{"$f":"IFERROR(INDEX('Product Details'!$E$5:$E$25,MATCH(C25,'Product Details'!$D$5:$D$25,0)),0)","v":100},1,null,{"$f":"(H25*I25)-(H25*I25*J25)","v":100},null,null,0]
[null,{"$f":"IF(OFFSET(C26,,0)<>\"\",ROW()-15,\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(INDEX('Product Details'!$E$5:$E$25,MATCH(C26,'Product Details'!$D$5:$D$25,0)),0)","v":0},null,null,{"$f":"(H26*I26)-(H26*I26*J26)","v":0},null,null,0]
[null,"",null,null,null,null,null,{"$f":"IFERROR(INDEX('Product Details'!$E$5:$E$25,MATCH(C27,'Product Details'!$D$5:$D$25,0)),0)","v":0},null,null,{"$f":"(H27*I27)-(H27*I27*J27)","v":0},null,null,0]
[null,"",null,null,null,null,null,{"$f":"IFERROR(INDEX('Product Details'!$E$5:$E$25,MATCH(C28,'Product Details'!$D$5:$D$25,0)),0)","v":0},null,null,{"$f":"(H28*I28)-(H28*I28*J28)","v":0},null,null,0]
[]
[null,"Sub Total",null,null,null,null,null,null,null,null,{"$f":"SUM(K16:L28)","v":874.80799999999999}]
[]
[null,"Tax",null,null,null,null,null,null,null,0.14000000000000001,{"$f":"J32*K30","v":122.47312000000001}]
[]
[null,"Grand Total",null,null,null,null,null,null,null,null,{"$f":"SUM(K30,K32)","v":997.28111999999999}]
[]
[null,"Amount in Words: ",null,{"$f":"Currency2Word(K34)","v":"Nine Hundred Ninety Seven Rupees and Twenty Eight Paise Only"}]
[null,"\n\n"]

{"sheet":"Your Company Details","index":1,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,9,6,15]]}
[]
[null,null,null,null,"Data to be filled in","Remaining ","Char Limit"]
[null,null,"Company Name",null,"My Company Private Limited",{"$f":"G3-LEN(E3)","v":28},54]
[]
[null,null,"Address Line 1",null,"#795 E DRAGRAM",{"$f":"G5-LEN(E5)","v":40},54]
[]
[null,null,"Address Line 2",null,"TUCSON",48,54]
[]
[null,null,"Zip Code",null,"AZ 85705",46,54]
[]
[null,null,"Phone 1",null,"+31 - Phone 1 786 4354",{"$f":"G11-LEN(E11)","v":8},30]
[]
[null,null,"Phone 2",null,null,{"$f":"G13-LEN(E13)","v":30},30]
[]
[null,null,"Email ID",null,"vishwamitra01@gmail.com",{"$f":"55-LEN(E15)","v":32},55]
[]
[null,null,"Website",null,"http://www.learnexcelmacro.com",{"$f":"G17-LEN(E17)","v":40},70]

{"sheet":"Customer Details","index":2,"n_rows":33,"n_cols":9,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Custmer ID#","Client Name/Company Name","Address line 1","Address Line 2","Zip Code","Phone Number","Email Address"]
[null,null,1,"Integer Id Magna Limited","396-4007 Luctus Rd.","Guelph",5379,"1-911-135-3100","eget@purusaccumsaninterdum.ca"]
[null,null,2,"Parturient Montes Institute","P.O. Box 308, 9291 Sit St.","Tufo",6551,"1-917-320-0160","nec.leo.Morbi@maurisrhoncus.edu"]
[null,null,3,"Sociis Natoque Consulting","P.O. Box 296, 6256 Dolor Rd.","Golspie",1805,"1-780-890-6741","rutrum@sedsapien.org"]
[null,null,4,"Vel Limited","Ap #648-9448 Odio. Rd.","Nässjö",19571,"1-354-428-1036","et@malesuada.ca"]
[null,null,5,"Sed Orci Corp.","985-8028 Sapien. Street","Wrexham",5873,"1-850-333-5885","Morbi@Etiamgravidamolestie.edu"]
[null,null,6,"Vel Arcu Incorporated","P.O. Box 767, 1238 Et, Street","Monte Santa Maria Tiberina",7215,"1-765-333-9844","vel.venenatis@neccursusa.ca"]
[null,null,7,"Dolor Nulla Associates","P.O. Box 864, 5729 Velit Av.","Sahiwal",2483,"1-805-751-6695","tristique.senectus.et@acnullaIn.org"]
[null,null,8,"Pede Cum Sociis Corporation","Ap #280-7193 Eu St.","Coleville Lake","K6N 5P9","1-716-272-6423","et@Pellentesque.edu"]
[null,null,9,"Mauris Ltd","8120 Donec Rd.","Cunco",86371,"1-508-332-9675","sollicitudin.commodo@egestasblanditNam.com"]
[null,null,10,"Eleifend Non PC","6027 Amet Road","Haverfordwest",25366,"1-309-992-3917","a.auctor.non@mi.co.uk"]
[null,null,11,"Lacinia Orci Consectetuer Company","4216 Eleifend Street","St. Petersburg",20318,"1-593-709-6492","tincidunt.adipiscing@faucibusleoin.edu"]
[null,null,12,"Euismod Enim Etiam LLC","7503 Maecenas Ave","Maria",91165,"1-833-426-7495","Cras.eu.tellus@necante.edu"]
[null,null,13,"Lorem Tristique PC","Ap #776-222 Nec, Street","Cardedu",19960,"1-434-776-0209","neque.Nullam@Curabitursed.ca"]
[null,null,14,"Tincidunt Aliquam Corporation","346-8289 Vel, Avenue","Avigliano Umbro",7242,"1-550-733-0486","Duis.at@ataugue.edu"]
[null,null,15,"Enim Consequat Industries","Ap #670-9742 Sed Av.","Grafton",1991,"1-108-215-2641","tellus@etmalesuada.com"]
[null,null,16,"Vitae Erat Company","Ap #928-4690 Elit, St.","Fogo",94097,"1-918-512-0064","egestas.rhoncus.Proin@risusat.edu"]
[null,null,17,"Donec Elementum Lorem Company","P.O. Box 332, 4893 Libero. Rd.","Tarvisio",3851,"1-166-996-4318","in@Suspendissedui.co.uk"]
[null,null,18,"Metus Eu Erat Inc.","Ap #742-4547 Vitae, St.","Pozo Almonte",27647,"1-206-102-2630","sem@eget.com"]
[null,null,19,"Nunc Lectus Corp.","3310 Orci Rd.","Meeuwen",46812,"1-545-465-8534","ut.pellentesque.eget@blanditviverraDonec.ca"]
[null,null,20,"Non Bibendum Sed Institute","Ap #617-8364 Non Street","Longvilly","21-946","1-160-943-0836","magna.tellus@eu.net"]
[null,null,21,"Vehicula Foundation","518-2359 Aliquet, Rd.","LaSalle",67520,"1-358-917-9226","ac.urna@Aliquam.co.uk"]
[null,null,22,"Dui Ltd","Ap #811-4468 Id St.","Missoula",4108,"1-159-788-9079","mollis@et.ca"]
[null,null,23,"Suspendisse Ac Company","8727 Eros St.","Hualaihué",38541,"1-332-766-1767","dolor.dapibus@elit.org"]
[null,null,24,"Enim Diam Vel Industries","Ap #950-5104 Dolor St.","Montpelier",12771,"1-440-223-8336","scelerisque.sed@blanditcongueIn.net"]
[null,null,25,"Et Limited","Ap #556-6531 Elit Avenue","Barasat","96-328","1-542-183-6288","tempus@felis.co.uk"]
[null,null,26,"Mauris Eu Turpis Corporation","651-1057 Sodales. St.","Shawville",4200,"1-515-809-3612","ante.dictum.mi@estmollisnon.org"]
[null,null,27,"Convallis Dolor Quisque Ltd","Ap #320-6127 Dolor Avenue","Habergy","P5M 8C8","1-525-391-6971","velit@felisDonectempor.com"]
[null,null,28,"Lorem Company","210-1661 Ante Ave","Montacuto","P1J 5V5","1-646-141-9013","egestas@euismodestarcu.edu"]
[null,null,29,"Dignissim PC","710-5567 Adipiscing Road","Hoeilaart",6298,"1-498-212-5967","sem.mollis@consequatenimdiam.com"]
[null,null,30,"Vitae Dolor Foundation","614-1078 Magnis Rd.","Biarritz",60073,"1-963-244-3239","pede.Nunc@fringillaornareplacerat.net"]

{"sheet":"Product Details","index":3,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,"Product ID#","Product Description","Unit Price"]
[null,null,1,"Zum Lamlab",100]
[null,null,2,"Quofresh",250]
[null,null,3,"S-zoocof",110]
[null,null,4,"It Ron",4000]
[null,null,5,"Funtone",32.5]
[null,null,6,"Voya-Tip",34]
[null,null,7,"Zensundox",5600]
[null,null,8,"Ton Zumdex",3.5]
[null,null,9,"Mat Dankix",100]
[null,null,10,"Softhome",101.5]
[null,null,11,"Zath Ing",99.9]
[null,null,12,"Holddom",41.4]
[null,null,13,"Zathfix",3987.5]
[null,null,14,"Lexiqvoair",4]
[null,null,15,"Opetom",10]
[null,null,16,"Vilastock",11.5]
[null,null,17,"Subsing",45.7]
[null,null,18,"Namkix",532.5]
[null,null,19,"Math Zenfax",45.6]
[null,null,20,"Year Air",234.6]
[null,null,21,"Geotraxzap",329.5]