{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Read Me","Company Setup","Customer Setup","Sales Input","Invoice","cbo"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":5,"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":"Read Me","index":0,"n_rows":11,"n_cols":1,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,0,1,8],[3,0,3,8],[10,0,10,8]]}
[]
["Smart Invoice"]
[]
["Welcome to Smart Invoice, an invoice generator tool to help your business with quick & smart billing & invoice documentation process. Here are some features you can enjoy :"]
["  [] Handle 20 products, 2 customers & 300 sales transactions."]
["  [] Taxable / non-taxable items option (sales tax only calculated on taxable items)."]
["  [] Automatic invoice issuance & tracking using drop down navigation."]
["  [] Use your business logo for the invoice."]
["  [] Invoice auto numbering with your pre-defined setup."]
["  [] Invoice wording customization."]
["If you find any difficulties in using this tool, or if you want to any further customization, please contact me at baskoro.prasetyo@aripra-consulting.com."]

{"sheet":"Company Setup","index":1,"n_rows":44,"n_cols":6,"rows_kept":44,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[5,4,5,5],[6,1,6,2],[7,1,7,2],[23,4,23,5],[10,1,10,2],[11,1,11,2],[5,0,5,2],[3,1,3,2],[8,1,8,2],[9,1,9,2],[13,4,13,5]]}
[{"$f":"B4","v":"Aripra Worldwide"}]
["Company Data Setup"]
[]
["Company Name :","Aripra Worldwide"]
[]
["Company Registration Information",null,null,null,"Company Bank Information"]
["Company Address - Line 1 :","Kencana Loka",null,null,"Beneficiary Name",{"$f":"B4","v":"Aripra Worldwide"}]
["Company Address - Line 2 :","BSD City - Banten",null,null,"Bank Name","Bank GGG WORLDWIDE"]
["Company Address - Line 3 :","Indonesia",null,null,"Bank Branch Name/Code :",775]
["Email :","email@email.com",null,null,"Account Number :",271883749]
["Phone No :","+62 21 555555",null,null,"IBAN Number :","IBAN 453672271883749"]
["Company Tax ID :",2788199749,null,null,"Swift Code :","JHHSIIX"]
[]
["Invoice Number Format :","AC 201500",null,null,"Customize the invoice bottom line wording below"]
[]
["Invoice Currency :","USD",null,null,"Total Sales","Total Sales (USD)"]
[]
["Sales Tax Rate :",0.1,null,null,"Sales Tax","VAT on Taxable Items (10%)"]
[]
[null,null,null,null,"Total Invoice Balance","Total Invoice (USD)"]
[]
[null,null,null,null,"Thank you comments","[ THANK YOU FOR YOUR BUSINESS ]"]
[]
["Product Description","Unit Price","Put \"x\" mark for taxable item",null,"Create your company logo between this box & below line"]
["Product 1",200,"X"]
["Product 2",400,"X"]
["Product 3",600,"X"]
["Product 4",100,"X"]
["Product 5",50,"X"]
["Product 6",44,"X"]
["Product 7",100.5,"X"]
["Product 8",250.5,"X"]
["Product 9",350,"X"]
["Product 10",150,"X"]
["Product 11",110,"X"]
["Product 12",90,"X"]
["Product 13",40,"X"]
["Product 14",30,"X"]
["Product 15",20,"X"]
["Product 16",10,"X"]
["Product 17",15,"X"]
["Product 18",20,"X"]
["Product 19",60,"X"]
["Product 20",70,"X"]

{"sheet":"Customer Setup","index":2,"n_rows":70,"n_cols":4,"rows_kept":70,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Company Setup'!B4","v":"Aripra Worldwide"}]
["Customer Data Setup"]
[]
[]
["Customer Name",":","Customer Name 1","Customer Name 2"]
[]
["Address Line 1",":","Customer 1 Address Line 1","Customer 2 Address Line 1"]
["Address Line 2",":","Customer 1 Address Line 2","Customer 2 Address Line 2"]
["Address Line 3",":","Customer 1 Address Line 3","Customer 2 Address Line 3"]
["Email",":","email@email.com","email2@email.com"]
["Phone",":","+001-188475","+001-188444"]
["Contact Person",":","Mr. Joe Him","Mrs. Jane Her"]
[]
["Payment Terms",":","Cash on Delivery",30]
[]
[]
[]
[]
[{"$f":"COUNTA(C5:AZ5)","v":2}]
[null,null,"<<<>>>"]
[1,null,{"$f":"IF($A21>$A$19,\"\",INDEX($C$5:$AZ$5,A21))","v":"Customer Name 1"}]
[{"$f":"A21+1","v":2},null,{"$f":"IF($A22>$A$19,\"\",INDEX($C$5:$AZ$5,A22))","v":"Customer Name 2"}]
[{"$f":"A22+1","v":3},null,""]
[4,null,""]
[5,null,""]
[6,null,""]
[7,null,""]
[8,null,""]
[9,null,""]
[10,null,""]
[11,null,""]
[12,null,""]
[13,null,""]
[14,null,""]
[15,null,""]
[16,null,""]
[17,null,""]
[18,null,""]
[19,null,""]
[20,null,""]
[21,null,""]
[22,null,""]
[23,null,""]
[24,null,""]
[25,null,""]
[26,null,""]
[27,null,""]
[28,null,""]
[29,null,""]
[30,null,""]
[31,null,""]
[32,null,""]
[33,null,""]
[34,null,""]
[35,null,""]
[36,null,""]
[37,null,""]
[38,null,""]
[39,null,""]
[40,null,""]
[41,null,""]
[42,null,""]
[43,null,""]
[44,null,""]
[45,null,""]
[46,null,""]
[47,null,""]
[48,null,""]
[49,null,""]
[50,null,""]

{"sheet":"Sales Input","index":3,"n_rows":360,"n_cols":302,"rows_kept":360,"cut":false,"hidden":false,"merged":[[28,0,28,1]]}
[{"$f":"'Company Setup'!B4","v":"Aripra Worldwide"}]
["Sales Data Input Form"]
[null,null,{"$f":"IF(C8<10,TEXT(C8,\"00#\"),IF(C8<100,TEXT(C8,\"0##\"),TEXT(C8,\"#\")))","v":"001"},{"$f":"IF(D8<10,TEXT(D8,\"00#\"),IF(D8<100,TEXT(D8,\"0##\"),TEXT(D8,\"#\")))","v":"002"},"003","004","005","006","007","008","009","010","011","012","013","014","015","016","017","018","019","020","021","022","023","024","025","026","027","028","029","030","031","032","033","034","035","036","037","038","039","040","041","042","043","044","045","046","047","048","049","050","051","052","053","054","055","056","057","058","059","060","061","062","063","064","065",{"$f":"IF(BP8<10,TEXT(BP8,\"00#\"),IF(BP8<100,TEXT(BP8,\"0##\"),TEXT(BP8,\"#\")))","v":"066"},"067","068","069","070","071","072","073","074","075","076","077","078","079","080","081","082","083","084","085","086","087","088","089","090","091","092","093","094","095","096","097","098","099","100","101","102","103","104","105","106","107","108","109","110","111","112","113","114","115","116","117","118","119","120","121","122","123","124","125","126","127","128","129",{"$f":"IF(EB8<10,TEXT(EB8,\"00#\"),IF(EB8<100,TEXT(EB8,\"0##\"),TEXT(EB8,\"#\")))","v":"130"},"131","132","133","134","135","136","137","138","139","140","141","142","143","144","145","146","147","148","149","150","151","152","153","154","155","156","157","158","159","160","161","162","163","164","165","166","167","168","169","170","171","172","173","174","175","176","177","178","179","180","181","182","183","184","185","186","187","188","189","190","191","192","193",{"$f":"IF(GN8<10,TEXT(GN8,\"00#\"),IF(GN8<100,TEXT(GN8,\"0##\"),TEXT(GN8,\"#\")))","v":"194"},"195","196","197","198","199","200","201","202","203","204","205","206","207","208","209","210","211","212","213","214","215","216","217","218","219","220","221","222","223","224","225","226","227","228","229","230","231","232","233","234","235","236","237","238","239","240","241","242","243","244","245","246","247","248","249","250","251","252","253","254","255","256","257",{"$f":"IF(IZ8<10,TEXT(IZ8,\"00#\"),IF(IZ8<100,TEXT(IZ8,\"0##\"),TEXT(IZ8,\"#\")))","v":"258"},"259","260","261","262","263","264","265","266","267","268","269","270","271","272","273","274","275","276","277","278","279","280","281","282","283","284","285","286","287","288","289","290","291","292","293","294","295","296","297","298","299","300"]
[null,"Invoice No >>>>>",{"$f":"'Company Setup'!$B$14&\"-\"&C3","v":"AC 201500-001"},{"$f":"'Company Setup'!$B$14&\"-\"&D3","v":"AC 201500-002"},{"$f":"'Company Setup'!$B$14&\"-\"&E3","v":"AC 201500-003"},{"$f":"'Company Setup'!$B$14&\"-\"&F3","v":"AC 201500-004"},{"$f":"'Company Setup'!$B$14&\"-\"&G3","v":"AC 201500-005"},{"$f":"'Company Setup'!$B$14&\"-\"&H3","v":"AC 201500-006"},{"$f":"'Company Setup'!$B$14&\"-\"&I3","v":"AC 201500-007"},{"$f":"'Company Setup'!$B$14&\"-\"&J3","v":"AC 201500-008"},{"$f":"'Company Setup'!$B$14&\"-\"&K3","v":"AC 201500-009"},{"$f":"'Company Setup'!$B$14&\"-\"&L3","v":"AC 201500-010"},{"$f":"'Company Setup'!$B$14&\"-\"&M3","v":"AC 201500-011"},{"$f":"'Company Setup'!$B$14&\"-\"&N3","v":"AC 201500-012"},{"$f":"'Company Setup'!$B$14&\"-\"&O3","v":"AC 201500-013"},{"$f":"'Company Setup'!$B$14&\"-\"&P3","v":"AC 201500-014"},{"$f":"'Company Setup'!$B$14&\"-\"&Q3","v":"AC 201500-015"},{"$f":"'Company Setup'!$B$14&\"-\"&R3","v":"AC 201500-016"},{"$f":"'Company Setup'!$B$14&\"-\"&S3","v":"AC 201500-017"},{"$f":"'Company Setup'!$B$14&\"-\"&T3","v":"AC 201500-018"},{"$f":"'Company Setup'!$B$14&\"-\"&U3","v":"AC 201500-019"},{"$f":"'Company Setup'!$B$14&\"-\"&V3","v":"AC 201500-020"},{"$f":"'Company Setup'!$B$14&\"-\"&W3","v":"AC 201500-021"},{"$f":"'Company Setup'!$B$14&\"-\"&X3","v":"AC 201500-022"},{"$f":"'Company Setup'!$B$14&\"-\"&Y3","v":"AC 201500-023"},{"$f":"'Company Setup'!$B$14&\"-\"&Z3","v":"AC 201500-024"},{"$f":"'Company Setup'!$B$14&\"-\"&AA3","v":"AC 201500-025"},{"$f":"'Company Setup'!$B$14&\"-\"&AB3","v":"AC 201500-026"},{"$f":"'Company Setup'!$B$14&\"-\"&AC3","v":"AC 201500-027"},{"$f":"'Company Setup'!$B$14&\"-\"&AD3","v":"AC 201500-028"},{"$f":"'Company Setup'!$B$14&\"-\"&AE3","v":"AC 201500-029"},{"$f":"'Company Setup'!$B$14&\"-\"&AF3","v":"AC 201500-030"},{"$f":"'Company Setup'!$B$14&\"-\"&AG3","v":"AC 201500-031"},{"$f":"'Company Setup'!$B$14&\"-\"&AH3","v":"AC 201500-032"},{"$f":"'Company Setup'!$B$14&\"-\"&AI3","v":"AC 201500-033"},{"$f":"'Company Setup'!$B$14&\"-\"&AJ3","v":"AC 201500-034"},{"$f":"'Company Setup'!$B$14&\"-\"&AK3","v":"AC 201500-035"},{"$f":"'Company Setup'!$B$14&\"-\"&AL3","v":"AC 201500-036"},{"$f":"'Company Setup'!$B$14&\"-\"&AM3","v":"AC 201500-037"},{"$f":"'Company Setup'!$B$14&\"-\"&AN3","v":"AC 201500-038"},{"$f":"'Company Setup'!$B$14&\"-\"&AO3","v":"AC 201500-039"},{"$f":"'Company Setup'!$B$14&\"-\"&AP3","v":"AC 201500-040"},{"$f":"'Company Setup'!$B$14&\"-\"&AQ3","v":"AC 201500-041"},{"$f":"'Company Setup'!$B$14&\"-\"&AR3","v":"AC 201500-042"},{"$f":"'Company Setup'!$B$14&\"-\"&AS3","v":"AC 201500-043"},{"$f":"'Company Setup'!$B$14&\"-\"&AT3","v":"AC 201500-044"},{"$f":"'Company Setup'!$B$14&\"-\"&AU3","v":"AC 201500-045"},{"$f":"'Company Setup'!$B$14&\"-\"&AV3","v":"AC 201500-046"},{"$f":"'Company Setup'!$B$14&\"-\"&AW3","v":"AC 201500-047"},{"$f":"'Company Setup'!$B$14&\"-\"&AX3","v":"AC 201500-048"},{"$f":"'Company Setup'!$B$14&\"-\"&AY3","v":"AC 201500-049"},{"$f":"'Company Setup'!$B$14&\"-\"&AZ3","v":"AC 201500-050"},{"$f":"'Company Setup'!$B$14&\"-\"&BA3","v":"AC 201500-051"},{"$f":"'Company Setup'!$B$14&\"-\"&BB3","v":"AC 201500-052"},{"$f":"'Company Setup'!$B$14&\"-\"&BC3","v":"AC 201500-053"},{"$f":"'Company Setup'!$B$14&\"-\"&BD3","v":"AC 201500-054"},{"$f":"'Company Setup'!$B$14&\"-\"&BE3","v":"AC 201500-055"},{"$f":"'Company Setup'!$B$14&\"-\"&BF3","v":"AC 201500-056"},{"$f":"'Company Setup'!$B$14&\"-\"&BG3","v":"AC 201500-057"},{"$f":"'Company Setup'!$B$14&\"-\"&BH3","v":"AC 201500-058"},{"$f":"'Company Setup'!$B$14&\"-\"&BI3","v":"AC 201500-059"},{"$f":"'Company Setup'!$B$14&\"-\"&BJ3","v":"AC 201500-060"},{"$f":"'Company Setup'!$B$14&\"-\"&BK3","v":"AC 201500-061"},{"$f":"'Company Setup'!$B$14&\"-\"&BL3","v":"AC 201500-062"},{"$f":"'Company Setup'!$B$14&\"-\"&BM3","v":"AC 201500-063"},{"$f":"'Company Setup'!$B$14&\"-\"&BN3","v":"AC 201500-064"},{"$f":"'Company Setup'!$B$14&\"-\"&BO3","v":"AC 201500-065"},{"$f":"'Company Setup'!$B$14&\"-\"&BP3","v":"AC 201500-066"},{"$f":"'Company Setup'!$B$14&\"-\"&BQ3","v":"AC 201500-067"},{"$f":"'Company Setup'!$B$14&\"-\"&BR3","v":"AC 201500-068"},{"$f":"'Company Setup'!$B$14&\"-\"&BS3","v":"AC 201500-069"},{"$f":"'Company Setup'!$B$14&\"-\"&BT3","v":"AC 201500-070"},{"$f":"'Company Setup'!$B$14&\"-\"&BU3","v":"AC 201500-071"},{"$f":"'Company Setup'!$B$14&\"-\"&BV3","v":"AC 201500-072"},{"$f":"'Company Setup'!$B$14&\"-\"&BW3","v":"AC 201500-073"},{"$f":"'Company Setup'!$B$14&\"-\"&BX3","v":"AC 201500-074"},{"$f":"'Company Setup'!$B$14&\"-\"&BY3","v":"AC 201500-075"},{"$f":"'Company Setup'!$B$14&\"-\"&BZ3","v":"AC 201500-076"},{"$f":"'Company Setup'!$B$14&\"-\"&CA3","v":"AC 201500-077"},{"$f":"'Company Setup'!$B$14&\"-\"&CB3","v":"AC 201500-078"},{"$f":"'Company Setup'!$B$14&\"-\"&CC3","v":"AC 201500-079"},{"$f":"'Company Setup'!$B$14&\"-\"&CD3","v":"AC 201500-080"},{"$f":"'Company Setup'!$B$14&\"-\"&CE3","v":"AC 201500-081"},{"$f":"'Company Setup'!$B$14&\"-\"&CF3","v":"AC 201500-082"},{"$f":"'Company Setup'!$B$14&\"-\"&CG3","v":"AC 201500-083"},{"$f":"'Company Setup'!$B$14&\"-\"&CH3","v":"AC 201500-084"},{"$f":"'Company Setup'!$B$14&\"-\"&CI3","v":"AC 201500-085"},{"$f":"'Company Setup'!$B$14&\"-\"&CJ3","v":"AC 201500-086"},{"$f":"'Company Setup'!$B$14&\"-\"&CK3","v":"AC 201500-087"},{"$f":"'Company Setup'!$B$14&\"-\"&CL3","v":"AC 201500-088"},{"$f":"'Company Setup'!$B$14&\"-\"&CM3","v":"AC 201500-089"},{"$f":"'Company Setup'!$B$14&\"-\"&CN3","v":"AC 201500-090"},{"$f":"'Company Setup'!$B$14&\"-\"&CO3","v":"AC 201500-091"},{"$f":"'Company Setup'!$B$14&\"-\"&CP3","v":"AC 201500-092"},{"$f":"'Company Setup'!$B$14&\"-\"&CQ3","v":"AC 201500-093"},{"$f":"'Company Setup'!$B$14&\"-\"&CR3","v":"AC 201500-094"},{"$f":"'Company Setup'!$B$14&\"-\"&CS3","v":"AC 201500-095"},{"$f":"'Company Setup'!$B$14&\"-\"&CT3","v":"AC 201500-096"},{"$f":"'Company Setup'!$B$14&\"-\"&CU3","v":"AC 201500-097"},{"$f":"'Company Setup'!$B$14&\"-\"&CV3","v":"AC 201500-098"},{"$f":"'Company Setup'!$B$14&\"-\"&CW3","v":"AC 201500-099"},{"$f":"'Company Setup'!$B$14&\"-\"&CX3","v":"AC 201500-100"},{"$f":"'Company Setup'!$B$14&\"-\"&CY3","v":"AC 201500-101"},{"$f":"'Company Setup'!$B$14&\"-\"&CZ3","v":"AC 201500-102"},{"$f":"'Company Setup'!$B$14&\"-\"&DA3","v":"AC 201500-103"},{"$f":"'Company Setup'!$B$14&\"-\"&DB3","v":"AC 201500-104"},{"$f":"'Company Setup'!$B$14&\"-\"&DC3","v":"AC 201500-105"},{"$f":"'Company Setup'!$B$14&\"-\"&DD3","v":"AC 201500-106"},{"$f":"'Company Setup'!$B$14&\"-\"&DE3","v":"AC 201500-107"},{"$f":"'Company Setup'!$B$14&\"-\"&DF3","v":"AC 201500-108"},{"$f":"'Company Setup'!$B$14&\"-\"&DG3","v":"AC 201500-109"},{"$f":"'Company Setup'!$B$14&\"-\"&DH3","v":"AC 201500-110"},{"$f":"'Company Setup'!$B$14&\"-\"&DI3","v":"AC 201500-111"},{"$f":"'Company Setup'!$B$14&\"-\"&DJ3","v":"AC 201500-112"},{"$f":"'Company Setup'!$B$14&\"-\"&DK3","v":"AC 201500-113"},{"$f":"'Company Setup'!$B$14&\"-\"&DL3","v":"AC 201500-114"},{"$f":"'Company Setup'!$B$14&\"-\"&DM3","v":"AC 201500-115"},{"$f":"'Company Setup'!$B$14&\"-\"&DN3","v":"AC 201500-116"},{"$f":"'Company Setup'!$B$14&\"-\"&DO3","v":"AC 201500-117"},{"$f":"'Company Setup'!$B$14&\"-\"&DP3","v":"AC 201500-118"},{"$f":"'Company Setup'!$B$14&\"-\"&DQ3","v":"AC 201500-119"},{"$f":"'Company Setup'!$B$14&\"-\"&DR3","v":"AC 201500-120"},{"$f":"'Company Setup'!$B$14&\"-\"&DS3","v":"AC 201500-121"},{"$f":"'Company Setup'!$B$14&\"-\"&DT3","v":"AC 201500-122"},{"$f":"'Company Setup'!$B$14&\"-\"&DU3","v":"AC 201500-123"},{"$f":"'Company Setup'!$B$14&\"-\"&DV3","v":"AC 201500-124"},{"$f":"'Company Setup'!$B$14&\"-\"&DW3","v":"AC 201500-125"},{"$f":"'Company Setup'!$B$14&\"-\"&DX3","v":"AC 201500-126"},{"$f":"'Company Setup'!$B$14&\"-\"&DY3","v":"AC 201500-127"},{"$f":"'Company Setup'!$B$14&\"-\"&DZ3","v":"AC 201500-128"},{"$f":"'Company Setup'!$B$14&\"-\"&EA3","v":"AC 201500-129"},{"$f":"'Company Setup'!$B$14&\"-\"&EB3","v":"AC 201500-130"},{"$f":"'Company Setup'!$B$14&\"-\"&EC3","v":"AC 201500-131"},{"$f":"'Company Setup'!$B$14&\"-\"&ED3","v":"AC 201500-132"},{"$f":"'Company Setup'!$B$14&\"-\"&EE3","v":"AC 201500-133"},{"$f":"'Company Setup'!$B$14&\"-\"&EF3","v":"AC 201500-134"},{"$f":"'Company Setup'!$B$14&\"-\"&EG3","v":"AC 201500-135"},{"$f":"'Company Setup'!$B$14&\"-\"&EH3","v":"AC 201500-136"},{"$f":"'Company Setup'!$B$14&\"-\"&EI3","v":"AC 201500-137"},{"$f":"'Company Setup'!$B$14&\"-\"&EJ3","v":"AC 201500-138"},{"$f":"'Company Setup'!$B$14&\"-\"&EK3","v":"AC 201500-139"},{"$f":"'Company Setup'!$B$14&\"-\"&EL3","v":"AC 201500-140"},{"$f":"'Company Setup'!$B$14&\"-\"&EM3","v":"AC 201500-141"},{"$f":"'Company Setup'!$B$14&\"-\"&EN3","v":"AC 201500-142"},{"$f":"'Company Setup'!$B$14&\"-\"&EO3","v":"AC 201500-143"},{"$f":"'Company Setup'!$B$14&\"-\"&EP3","v":"AC 201500-144"},{"$f":"'Company Setup'!$B$14&\"-\"&EQ3","v":"AC 201500-145"},{"$f":"'Company Setup'!$B$14&\"-\"&ER3","v":"AC 201500-146"},{"$f":"'Company Setup'!$B$14&\"-\"&ES3","v":"AC 201500-147"},{"$f":"'Company Setup'!$B$14&\"-\"&ET3","v":"AC 201500-148"},{"$f":"'Company Setup'!$B$14&\"-\"&EU3","v":"AC 201500-149"},{"$f":"'Company Setup'!$B$14&\"-\"&EV3","v":"AC 201500-150"},{"$f":"'Company Setup'!$B$14&\"-\"&EW3","v":"AC 201500-151"},{"$f":"'Company Setup'!$B$14&\"-\"&EX3","v":"AC 201500-152"},{"$f":"'Company Setup'!$B$14&\"-\"&EY3","v":"AC 201500-153"},{"$f":"'Company Setup'!$B$14&\"-\"&EZ3","v":"AC 201500-154"},{"$f":"'Company Setup'!$B$14&\"-\"&FA3","v":"AC 201500-155"},{"$f":"'Company Setup'!$B$14&\"-\"&FB3","v":"AC 201500-156"},{"$f":"'Company Setup'!$B$14&\"-\"&FC3","v":"AC 201500-157"},{"$f":"'Company Setup'!$B$14&\"-\"&FD3","v":"AC 201500-158"},{"$f":"'Company Setup'!$B$14&\"-\"&FE3","v":"AC 201500-159"},{"$f":"'Company Setup'!$B$14&\"-\"&FF3","v":"AC 201500-160"},{"$f":"'Company Setup'!$B$14&\"-\"&FG3","v":"AC 201500-161"},{"$f":"'Company Setup'!$B$14&\"-\"&FH3","v":"AC 201500-162"},{"$f":"'Company Setup'!$B$14&\"-\"&FI3","v":"AC 201500-163"},{"$f":"'Company Setup'!$B$14&\"-\"&FJ3","v":"AC 201500-164"},{"$f":"'Company Setup'!$B$14&\"-\"&FK3","v":"AC 201500-165"},{"$f":"'Company Setup'!$B$14&\"-\"&FL3","v":"AC 201500-166"},{"$f":"'Company Setup'!$B$14&\"-\"&FM3","v":"AC 201500-167"},{"$f":"'Company Setup'!$B$14&\"-\"&FN3","v":"AC 201500-168"},{"$f":"'Company Setup'!$B$14&\"-\"&FO3","v":"AC 201500-169"},{"$f":"'Company Setup'!$B$14&\"-\"&FP3","v":"AC 201500-170"},{"$f":"'Company Setup'!$B$14&\"-\"&FQ3","v":"AC 201500-171"},{"$f":"'Company Setup'!$B$14&\"-\"&FR3","v":"AC 201500-172"},{"$f":"'Company Setup'!$B$14&\"-\"&FS3","v":"AC 201500-173"},{"$f":"'Company Setup'!$B$14&\"-\"&FT3","v":"AC 201500-174"},{"$f":"'Company Setup'!$B$14&\"-\"&FU3","v":"AC 201500-175"},{"$f":"'Company Setup'!$B$14&\"-\"&FV3","v":"AC 201500-176"},{"$f":"'Company Setup'!$B$14&\"-\"&FW3","v":"AC 201500-177"},{"$f":"'Company Setup'!$B$14&\"-\"&FX3","v":"AC 201500-178"},{"$f":"'Company Setup'!$B$14&\"-\"&FY3","v":"AC 201500-179"},{"$f":"'Company Setup'!$B$14&\"-\"&FZ3","v":"AC 201500-180"},{"$f":"'Company Setup'!$B$14&\"-\"&GA3","v":"AC 201500-181"},{"$f":"'Company Setup'!$B$14&\"-\"&GB3","v":"AC 201500-182"},{"$f":"'Company Setup'!$B$14&\"-\"&GC3","v":"AC 201500-183"},{"$f":"'Company Setup'!$B$14&\"-\"&GD3","v":"AC 201500-184"},{"$f":"'Company Setup'!$B$14&\"-\"&GE3","v":"AC 201500-185"},{"$f":"'Company Setup'!$B$14&\"-\"&GF3","v":"AC 201500-186"},{"$f":"'Company Setup'!$B$14&\"-\"&GG3","v":"AC 201500-187"},{"$f":"'Company Setup'!$B$14&\"-\"&GH3","v":"AC 201500-188"},{"$f":"'Company Setup'!$B$14&\"-\"&GI3","v":"AC 201500-189"},{"$f":"'Company Setup'!$B$14&\"-\"&GJ3","v":"AC 201500-190"},{"$f":"'Company Setup'!$B$14&\"-\"&GK3","v":"AC 201500-191"},{"$f":"'Company Setup'!$B$14&\"-\"&GL3","v":"AC 201500-192"},{"$f":"'Company Setup'!$B$14&\"-\"&GM3","v":"AC 201500-193"},{"$f":"'Company Setup'!$B$14&\"-\"&GN3","v":"AC 201500-194"},{"$f":"'Company Setup'!$B$14&\"-\"&GO3","v":"AC 201500-195"},{"$f":"'Company Setup'!$B$14&\"-\"&GP3","v":"AC 201500-196"},{"$f":"'Company Setup'!$B$14&\"-\"&GQ3","v":"AC 201500-197"},{"$f":"'Company Setup'!$B$14&\"-\"&GR3","v":"AC 201500-198"},{"$f":"'Company Setup'!$B$14&\"-\"&GS3","v":"AC 201500-199"},{"$f":"'Company Setup'!$B$14&\"-\"&GT3","v":"AC 201500-200"},{"$f":"'Company Setup'!$B$14&\"-\"&GU3","v":"AC 201500-201"},{"$f":"'Company Setup'!$B$14&\"-\"&GV3","v":"AC 201500-202"},{"$f":"'Company Setup'!$B$14&\"-\"&GW3","v":"AC 201500-203"},{"$f":"'Company Setup'!$B$14&\"-\"&GX3","v":"AC 201500-204"},{"$f":"'Company Setup'!$B$14&\"-\"&GY3","v":"AC 201500-205"},{"$f":"'Company Setup'!$B$14&\"-\"&GZ3","v":"AC 201500-206"},{"$f":"'Company Setup'!$B$14&\"-\"&HA3","v":"AC 201500-207"},{"$f":"'Company Setup'!$B$14&\"-\"&HB3","v":"AC 201500-208"},{"$f":"'Company Setup'!$B$14&\"-\"&HC3","v":"AC 201500-209"},{"$f":"'Company Setup'!$B$14&\"-\"&HD3","v":"AC 201500-210"},{"$f":"'Company Setup'!$B$14&\"-\"&HE3","v":"AC 201500-211"},{"$f":"'Company Setup'!$B$14&\"-\"&HF3","v":"AC 201500-212"},{"$f":"'Company Setup'!$B$14&\"-\"&HG3","v":"AC 201500-213"},{"$f":"'Company Setup'!$B$14&\"-\"&HH3","v":"AC 201500-214"},{"$f":"'Company Setup'!$B$14&\"-\"&HI3","v":"AC 201500-215"},{"$f":"'Company Setup'!$B$14&\"-\"&HJ3","v":"AC 201500-216"},{"$f":"'Company Setup'!$B$14&\"-\"&HK3","v":"AC 201500-217"},{"$f":"'Company Setup'!$B$14&\"-\"&HL3","v":"AC 201500-218"},{"$f":"'Company Setup'!$B$14&\"-\"&HM3","v":"AC 201500-219"},{"$f":"'Company Setup'!$B$14&\"-\"&HN3","v":"AC 201500-220"},{"$f":"'Company Setup'!$B$14&\"-\"&HO3","v":"AC 201500-221"},{"$f":"'Company Setup'!$B$14&\"-\"&HP3","v":"AC 201500-222"},{"$f":"'Company Setup'!$B$14&\"-\"&HQ3","v":"AC 201500-223"},{"$f":"'Company Setup'!$B$14&\"-\"&HR3","v":"AC 201500-224"},{"$f":"'Company Setup'!$B$14&\"-\"&HS3","v":"AC 201500-225"},{"$f":"'Company Setup'!$B$14&\"-\"&HT3","v":"AC 201500-226"},{"$f":"'Company Setup'!$B$14&\"-\"&HU3","v":"AC 201500-227"},{"$f":"'Company Setup'!$B$14&\"-\"&HV3","v":"AC 201500-228"},{"$f":"'Company Setup'!$B$14&\"-\"&HW3","v":"AC 201500-229"},{"$f":"'Company Setup'!$B$14&\"-\"&HX3","v":"AC 201500-230"},{"$f":"'Company Setup'!$B$14&\"-\"&HY3","v":"AC 201500-231"},{"$f":"'Company Setup'!$B$14&\"-\"&HZ3","v":"AC 201500-232"},{"$f":"'Company Setup'!$B$14&\"-\"&IA3","v":"AC 201500-233"},{"$f":"'Company Setup'!$B$14&\"-\"&IB3","v":"AC 201500-234"},{"$f":"'Company Setup'!$B$14&\"-\"&IC3","v":"AC 201500-235"},{"$f":"'Company Setup'!$B$14&\"-\"&ID3","v":"AC 201500-236"},{"$f":"'Company Setup'!$B$14&\"-\"&IE3","v":"AC 201500-237"},{"$f":"'Company Setup'!$B$14&\"-\"&IF3","v":"AC 201500-238"},{"$f":"'Company Setup'!$B$14&\"-\"&IG3","v":"AC 201500-239"},{"$f":"'Company Setup'!$B$14&\"-\"&IH3","v":"AC 201500-240"},{"$f":"'Company Setup'!$B$14&\"-\"&II3","v":"AC 201500-241"},{"$f":"'Company Setup'!$B$14&\"-\"&IJ3","v":"AC 201500-242"},{"$f":"'Company Setup'!$B$14&\"-\"&IK3","v":"AC 201500-243"},{"$f":"'Company Setup'!$B$14&\"-\"&IL3","v":"AC 201500-244"},{"$f":"'Company Setup'!$B$14&\"-\"&IM3","v":"AC 201500-245"},{"$f":"'Company Setup'!$B$14&\"-\"&IN3","v":"AC 201500-246"},{"$f":"'Company Setup'!$B$14&\"-\"&IO3","v":"AC 201500-247"},{"$f":"'Company Setup'!$B$14&\"-\"&IP3","v":"AC 201500-248"},{"$f":"'Company Setup'!$B$14&\"-\"&IQ3","v":"AC 201500-249"},{"$f":"'Company Setup'!$B$14&\"-\"&IR3","v":"AC 201500-250"},{"$f":"'Company Setup'!$B$14&\"-\"&IS3","v":"AC 201500-251"},{"$f":"'Company Setup'!$B$14&\"-\"&IT3","v":"AC 201500-252"},{"$f":"'Company Setup'!$B$14&\"-\"&IU3","v":"AC 201500-253"},{"$f":"'Company Setup'!$B$14&\"-\"&IV3","v":"AC 201500-254"},{"$f":"'Company Setup'!$B$14&\"-\"&IW3","v":"AC 201500-255"},{"$f":"'Company Setup'!$B$14&\"-\"&IX3","v":"AC 201500-256"},{"$f":"'Company Setup'!$B$14&\"-\"&IY3","v":"AC 201500-257"},{"$f":"'Company Setup'!$B$14&\"-\"&IZ3","v":"AC 201500-258"},{"$f":"'Company Setup'!$B$14&\"-\"&JA3","v":"AC 201500-259"},{"$f":"'Company Setup'!$B$14&\"-\"&JB3","v":"AC 201500-260"},{"$f":"'Company Setup'!$B$14&\"-\"&JC3","v":"AC 201500-261"},{"$f":"'Company Setup'!$B$14&\"-\"&JD3","v":"AC 201500-262"},{"$f":"'Company Setup'!$B$14&\"-\"&JE3","v":"AC 201500-263"},{"$f":"'Company Setup'!$B$14&\"-\"&JF3","v":"AC 201500-264"},{"$f":"'Company Setup'!$B$14&\"-\"&JG3","v":"AC 201500-265"},{"$f":"'Company Setup'!$B$14&\"-\"&JH3","v":"AC 201500-266"},{"$f":"'Company Setup'!$B$14&\"-\"&JI3","v":"AC 201500-267"},{"$f":"'Company Setup'!$B$14&\"-\"&JJ3","v":"AC 201500-268"},{"$f":"'Company Setup'!$B$14&\"-\"&JK3","v":"AC 201500-269"},{"$f":"'Company Setup'!$B$14&\"-\"&JL3","v":"AC 201500-270"},{"$f":"'Company Setup'!$B$14&\"-\"&JM3","v":"AC 201500-271"},{"$f":"'Company Setup'!$B$14&\"-\"&JN3","v":"AC 201500-272"},{"$f":"'Company Setup'!$B$14&\"-\"&JO3","v":"AC 201500-273"},{"$f":"'Company Setup'!$B$14&\"-\"&JP3","v":"AC 201500-274"},{"$f":"'Company Setup'!$B$14&\"-\"&JQ3","v":"AC 201500-275"},{"$f":"'Company Setup'!$B$14&\"-\"&JR3","v":"AC 201500-276"},{"$f":"'Company Setup'!$B$14&\"-\"&JS3","v":"AC 201500-277"},{"$f":"'Company Setup'!$B$14&\"-\"&JT3","v":"AC 201500-278"},{"$f":"'Company Setup'!$B$14&\"-\"&JU3","v":"AC 201500-279"},{"$f":"'Company Setup'!$B$14&\"-\"&JV3","v":"AC 201500-280"},{"$f":"'Company Setup'!$B$14&\"-\"&JW3","v":"AC 201500-281"},{"$f":"'Company Setup'!$B$14&\"-\"&JX3","v":"AC 201500-282"},{"$f":"'Company Setup'!$B$14&\"-\"&JY3","v":"AC 201500-283"},{"$f":"'Company Setup'!$B$14&\"-\"&JZ3","v":"AC 201500-284"},{"$f":"'Company Setup'!$B$14&\"-\"&KA3","v":"AC 201500-285"},{"$f":"'Company Setup'!$B$14&\"-\"&KB3","v":"AC 201500-286"},{"$f":"'Company Setup'!$B$14&\"-\"&KC3","v":"AC 201500-287"},{"$f":"'Company Setup'!$B$14&\"-\"&KD3","v":"AC 201500-288"},{"$f":"'Company Setup'!$B$14&\"-\"&KE3","v":"AC 201500-289"},{"$f":"'Company Setup'!$B$14&\"-\"&KF3","v":"AC 201500-290"},{"$f":"'Company Setup'!$B$14&\"-\"&KG3","v":"AC 201500-291"},{"$f":"'Company Setup'!$B$14&\"-\"&KH3","v":"AC 201500-292"},{"$f":"'Company Setup'!$B$14&\"-\"&KI3","v":"AC 201500-293"},{"$f":"'Company Setup'!$B$14&\"-\"&KJ3","v":"AC 201500-294"},{"$f":"'Company Setup'!$B$14&\"-\"&KK3","v":"AC 201500-295"},{"$f":"'Company Setup'!$B$14&\"-\"&KL3","v":"AC 201500-296"},{"$f":"'Company Setup'!$B$14&\"-\"&KM3","v":"AC 201500-297"},{"$f":"'Company Setup'!$B$14&\"-\"&KN3","v":"AC 201500-298"},{"$f":"'Company Setup'!$B$14&\"-\"&KO3","v":"AC 201500-299"},{"$f":"'Company Setup'!$B$14&\"-\"&KP3","v":"AC 201500-300"}]
[null,"Sales Date Input >>>>>","2015-01-10","2015-01-10"]
[null,"Customer PO Number Input  >>>>>","PO 33459","PO 12345"]
[null,"Choose Customer Name >>>>>","Customer Name 1","Customer Name 2","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>","<<<>>>"]
["No","Product Description",1,{"$f":"C8+1","v":2},{"$f":"D8+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,{"$f":"BP8+1","v":67},68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,{"$f":"CX8+1","v":101},102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,{"$f":"FJ8+1","v":165},166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,{"$f":"FZ8+1","v":181},182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,{"$f":"IL8+1","v":245},246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300]
[1,{"$f":"'Company Setup'!A25","v":"Product 1"},null,2]
[{"$f":"A9+1","v":2},{"$f":"'Company Setup'!A26","v":"Product 2"},10,2]
[{"$f":"A10+1","v":3},{"$f":"'Company Setup'!A27","v":"Product 3"},null,3]
[4,{"$f":"'Company Setup'!A28","v":"Product 4"},5,4]
[5,{"$f":"'Company Setup'!A29","v":"Product 5"}]
[6,{"$f":"'Company Setup'!A30","v":"Product 6"},3]
[7,{"$f":"'Company Setup'!A31","v":"Product 7"}]
[8,{"$f":"'Company Setup'!A32","v":"Product 8"},1,7]
[9,{"$f":"'Company Setup'!A33","v":"Product 9"},null,8]
[10,{"$f":"'Company Setup'!A34","v":"Product 10"},4]
[11,{"$f":"'Company Setup'!A35","v":"Product 11"},null,12]
[12,{"$f":"'Company Setup'!A36","v":"Product 12"},5]
[13,{"$f":"'Company Setup'!A37","v":"Product 13"}]
[14,{"$f":"'Company Setup'!A38","v":"Product 14"},7]
[15,{"$f":"'Company Setup'!A39","v":"Product 15"},null,1]
[16,{"$f":"'Company Setup'!A40","v":"Product 16"}]
[17,{"$f":"'Company Setup'!A41","v":"Product 17"},null,3]
[18,{"$f":"'Company Setup'!A42","v":"Product 18"},12]
[19,{"$f":"'Company Setup'!A43","v":"Product 19"}]
[20,{"$f":"'Company Setup'!A44","v":"Product 20"}]
["Total Sales Quantity",null,{"$f":"SUM(C9:C28)","v":47},{"$f":"SUM(D9:D28)","v":42},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(BP9:BP28)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(EB9:EB28)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(GN9:GN28)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(IZ9:IZ28)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,{"$f":"cbo!A2","v":1},{"$f":"INDEX(invoiceno,B32)","v":"AC 201500-001"}]
[1,{"$f":"B9","v":"Product 1"},{"$f":"INDEX($C9:$KP9,MATCH($C$32,$C$4:$KP$4,0))","v":0},null,{"$f":"C33+(A33/1000000)","v":9.9999999999999995E-7},{"$f":"LARGE($E$33:$E$52,A33)","v":12.000018000000001},{"$f":"MATCH($F33,$E$33:$E$52,0)","v":18},{"$f":"INDEX($B$33:$B$52,G33)","v":"Product 18"},{"$f":"SUMIF($B$33:$B$52,H33,$C$33:$C$52)","v":12},null,{"$f":"IF(I33=0,\"\",H33)","v":"Product 18"}]
[{"$f":"A33+1","v":2},"Product 2",10,null,{"$f":"C34+(A34/1000000)","v":10.000002},{"$f":"LARGE($E$33:$E$52,A34)","v":10.000002},{"$f":"MATCH($F34,$E$33:$E$52,0)","v":2},{"$f":"INDEX($B$33:$B$52,G34)","v":"Product 2"},{"$f":"SUMIF($B$33:$B$52,H34,$C$33:$C$52)","v":10},null,{"$f":"IF(I34=0,\"\",H34)","v":"Product 2"}]
[{"$f":"A34+1","v":3},"Product 3",0,null,3.0000000000000001E-6,7.0000140000000002,14,"Product 14",7,null,"Product 14"]
[4,"Product 4",5,null,5.0000039999999997,5.0000119999999999,12,"Product 12",5,null,"Product 12"]
[5,"Product 5",0,null,5.0000000000000004E-6,5.0000039999999997,4,"Product 4",5,null,"Product 4"]
[6,"Product 6",3,null,3.000006,4.0000099999999996,10,"Product 10",4,null,"Product 10"]
[7,"Product 7",0,null,6.9999999999999999E-6,3.000006,6,"Product 6",3,null,"Product 6"]
[8,"Product 8",1,null,1.000008,1.000008,8,"Product 8",1,null,"Product 8"]
[9,"Product 9",0,null,9.0000000000000002E-6,2.0000000000000002E-5,20,"Product 20",0,null,""]
[10,"Product 10",4,null,4.0000099999999996,1.9000000000000001E-5,19,"Product 19",0,null,""]
[{"$f":"A42+1","v":11},"Product 11",0,null,1.1E-5,1.7E-5,17,"Product 17",0,null,""]
[12,"Product 12",5,null,5.0000119999999999,1.5999999999999999E-5,16,"Product 16",0,null,""]
[13,"Product 13",0,null,1.2999999999999999E-5,1.5E-5,15,"Product 15",0,null,""]
[14,"Product 14",7,null,7.0000140000000002,1.2999999999999999E-5,13,"Product 13",0,null,""]
[15,"Product 15",0,null,1.5E-5,1.1E-5,11,"Product 11",0,null,""]
[16,"Product 16",0,null,1.5999999999999999E-5,9.0000000000000002E-6,9,"Product 9",0,null,""]
[17,"Product 17",0,null,1.7E-5,6.9999999999999999E-6,7,"Product 7",0,null,""]
[18,"Product 18",12,null,12.000018000000001,5.0000000000000004E-6,5,"Product 5",0,null,""]
[19,"Product 19",0,null,1.9000000000000001E-5,3.0000000000000001E-6,3,"Product 3",0,null,""]
[20,"Product 20",0,null,2.0000000000000002E-5,9.9999999999999995E-7,1,"Product 1",0,null,""]
[]
[null,null,null,null,null,null,null,{"$f":"INDEX(C6:KP6,B32)","v":"PO 33459"},{"$f":"INDEX(C5:KP5,B32)","v":42014}]
[null,null,null,null,null,null,null,{"$f":"INDEX(C7:KP7,B32)","v":"Customer Name 1"}]
[null,null,null,null,null,null,null,{"$f":"IF(H55=\"<<<>>>\",\"\",HLOOKUP($H$55,'Customer Setup'!$C$5:$AZ$14,3,FALSE))","v":"Customer 1 Address Line 1"}]
[null,null,null,null,null,null,null,{"$f":"IF(H55=\"<<<>>>\",\"\",HLOOKUP($H$55,'Customer Setup'!$C$5:$AZ$14,4,FALSE))","v":"Customer 1 Address Line 2"}]
[null,null,null,null,null,null,null,{"$f":"IF(H55=\"<<<>>>\",\"\",HLOOKUP($H$55,'Customer Setup'!$C$5:$AZ$14,5,FALSE))","v":"Customer 1 Address Line 3"}]
[null,null,null,null,null,null,null,{"$f":"IF(H55=\"<<<>>>\",\"\",HLOOKUP($H$55,'Customer Setup'!$C$5:$AZ$14,6,FALSE))","v":"email@email.com"}]
[null,null,null,null,null,null,null,{"$f":"IF(H55=\"<<<>>>\",\"\",HLOOKUP($H$55,'Customer Setup'!$C$5:$AZ$14,7,FALSE))","v":"+001-188475"}]
[1,{"$f":"INDEX(invoiceno,A61)","v":"AC 201500-001"},null,null,null,null,null,{"$f":"IF(H55=\"<<<>>>\",\"\",HLOOKUP($H$55,'Customer Setup'!$C$5:$AZ$14,8,FALSE))","v":"Mr. Joe Him"}]
[{"$f":"A61+1","v":2},"AC 201500-002",null,null,null,null,null,{"$f":"IF(H55=\"<<<>>>\",\"\",HLOOKUP($H$55,'Customer Setup'!$C$5:$AZ$14,10,FALSE))","v":"Cash on Delivery"}]
[{"$f":"A62+1","v":3},"AC 201500-003"]
[4,"AC 201500-004"]
[5,"AC 201500-005"]
[6,"AC 201500-006"]
[7,"AC 201500-007"]
[8,"AC 201500-008"]
[9,"AC 201500-009"]
[10,"AC 201500-010"]
[11,"AC 201500-011"]
[12,"AC 201500-012"]
[13,"AC 201500-013"]
[14,"AC 201500-014"]
[15,"AC 201500-015"]
[16,"AC 201500-016"]
[17,"AC 201500-017"]
[18,"AC 201500-018"]
[19,"AC 201500-019"]
[20,"AC 201500-020"]
[21,"AC 201500-021"]
[22,"AC 201500-022"]
[23,"AC 201500-023"]
[24,"AC 201500-024"]
[25,"AC 201500-025"]
[26,"AC 201500-026"]
[27,"AC 201500-027"]
[28,"AC 201500-028"]
[29,"AC 201500-029"]
[30,"AC 201500-030"]
[31,"AC 201500-031"]
[32,"AC 201500-032"]
[33,"AC 201500-033"]
[34,"AC 201500-034"]
[35,"AC 201500-035"]
[36,"AC 201500-036"]
[37,"AC 201500-037"]
[38,"AC 201500-038"]
[39,"AC 201500-039"]
[40,"AC 201500-040"]
[41,"AC 201500-041"]
[42,"AC 201500-042"]
[43,"AC 201500-043"]
[44,"AC 201500-044"]
[45,"AC 201500-045"]
[46,"AC 201500-046"]
[47,"AC 201500-047"]
[48,"AC 201500-048"]
[49,"AC 201500-049"]
[50,"AC 201500-050"]
[51,"AC 201500-051"]
[52,"AC 201500-052"]
[53,"AC 201500-053"]
[54,"AC 201500-054"]
[55,"AC 201500-055"]
[56,"AC 201500-056"]
[57,"AC 201500-057"]
[58,"AC 201500-058"]
[59,"AC 201500-059"]
[60,"AC 201500-060"]
[61,"AC 201500-061"]
[62,"AC 201500-062"]
[63,"AC 201500-063"]
[64,"AC 201500-064"]
[65,{"$f":"INDEX(invoiceno,A125)","v":"AC 201500-065"}]
[66,"AC 201500-066"]
[{"$f":"A126+1","v":67},"AC 201500-067"]
[68,"AC 201500-068"]
[69,"AC 201500-069"]
[70,"AC 201500-070"]
[71,"AC 201500-071"]
[72,"AC 201500-072"]
[73,"AC 201500-073"]
[74,"AC 201500-074"]
[75,"AC 201500-075"]
[76,"AC 201500-076"]
[77,"AC 201500-077"]
[78,"AC 201500-078"]
[79,"AC 201500-079"]
[80,"AC 201500-080"]
[81,"AC 201500-081"]
[82,"AC 201500-082"]
[83,"AC 201500-083"]
[84,"AC 201500-084"]
[85,"AC 201500-085"]
[86,"AC 201500-086"]
[87,"AC 201500-087"]
[88,"AC 201500-088"]
[89,"AC 201500-089"]
[90,"AC 201500-090"]
[91,"AC 201500-091"]
[92,"AC 201500-092"]
[93,"AC 201500-093"]
[94,"AC 201500-094"]
[95,"AC 201500-095"]
[96,"AC 201500-096"]
[97,"AC 201500-097"]
[98,"AC 201500-098"]
[99,"AC 201500-099"]
[100,"AC 201500-100"]
[101,"AC 201500-101"]
[102,"AC 201500-102"]
[103,"AC 201500-103"]
[104,"AC 201500-104"]
[105,"AC 201500-105"]
[106,"AC 201500-106"]
[107,"AC 201500-107"]
[108,"AC 201500-108"]
[109,"AC 201500-109"]
[110,"AC 201500-110"]
[111,"AC 201500-111"]
[112,"AC 201500-112"]
[113,"AC 201500-113"]
[114,"AC 201500-114"]
[115,"AC 201500-115"]
[116,"AC 201500-116"]
[117,"AC 201500-117"]
[118,"AC 201500-118"]
[119,"AC 201500-119"]
[120,"AC 201500-120"]
[121,"AC 201500-121"]
[122,"AC 201500-122"]
[123,"AC 201500-123"]
[124,"AC 201500-124"]
[125,"AC 201500-125"]
[126,"AC 201500-126"]
[127,"AC 201500-127"]
[128,"AC 201500-128"]
[129,{"$f":"INDEX(invoiceno,A189)","v":"AC 201500-129"}]
[130,"AC 201500-130"]
[{"$f":"A190+1","v":131},"AC 201500-131"]
[132,"AC 201500-132"]
[133,"AC 201500-133"]
[134,"AC 201500-134"]
[135,"AC 201500-135"]
[136,"AC 201500-136"]
[137,"AC 201500-137"]
[138,"AC 201500-138"]
[139,"AC 201500-139"]
[140,"AC 201500-140"]
[141,"AC 201500-141"]
[142,"AC 201500-142"]
[143,"AC 201500-143"]
[144,"AC 201500-144"]
[145,"AC 201500-145"]
[146,"AC 201500-146"]
[147,"AC 201500-147"]
[148,"AC 201500-148"]
[149,"AC 201500-149"]
[150,"AC 201500-150"]
[151,"AC 201500-151"]
[152,"AC 201500-152"]
[153,"AC 201500-153"]
[154,"AC 201500-154"]
[155,"AC 201500-155"]
[156,"AC 201500-156"]
[157,"AC 201500-157"]
[158,"AC 201500-158"]
[159,"AC 201500-159"]
[160,"AC 201500-160"]
[161,"AC 201500-161"]
[162,"AC 201500-162"]
[163,"AC 201500-163"]
[164,"AC 201500-164"]
[165,"AC 201500-165"]
[166,"AC 201500-166"]
[167,"AC 201500-167"]
[168,"AC 201500-168"]
[169,"AC 201500-169"]
[170,"AC 201500-170"]
[171,"AC 201500-171"]
[172,"AC 201500-172"]
[173,"AC 201500-173"]
[174,"AC 201500-174"]
[175,"AC 201500-175"]
[176,"AC 201500-176"]
[177,"AC 201500-177"]
[178,"AC 201500-178"]
[179,"AC 201500-179"]
[180,"AC 201500-180"]
[181,"AC 201500-181"]
[182,"AC 201500-182"]
[183,"AC 201500-183"]
[184,"AC 201500-184"]
[185,"AC 201500-185"]
[186,"AC 201500-186"]
[187,"AC 201500-187"]
[188,"AC 201500-188"]
[189,"AC 201500-189"]
[190,"AC 201500-190"]
[191,"AC 201500-191"]
[192,"AC 201500-192"]
[193,{"$f":"INDEX(invoiceno,A253)","v":"AC 201500-193"}]
[194,"AC 201500-194"]
[{"$f":"A254+1","v":195},"AC 201500-195"]
[196,"AC 201500-196"]
[197,"AC 201500-197"]
[198,"AC 201500-198"]
[199,"AC 201500-199"]
[200,"AC 201500-200"]
[201,"AC 201500-201"]
[202,"AC 201500-202"]
[203,"AC 201500-203"]
[204,"AC 201500-204"]
[205,"AC 201500-205"]
[206,"AC 201500-206"]
[207,"AC 201500-207"]
[208,"AC 201500-208"]
[209,"AC 201500-209"]
[210,"AC 201500-210"]
[211,"AC 201500-211"]
[212,"AC 201500-212"]
[213,"AC 201500-213"]
[214,"AC 201500-214"]
[215,"AC 201500-215"]
[216,"AC 201500-216"]
[217,"AC 201500-217"]
[218,"AC 201500-218"]
[219,"AC 201500-219"]
[220,"AC 201500-220"]
[221,"AC 201500-221"]
[222,"AC 201500-222"]
[223,"AC 201500-223"]
[224,"AC 201500-224"]
[225,"AC 201500-225"]
[226,"AC 201500-226"]
[227,"AC 201500-227"]
[228,"AC 201500-228"]
[229,"AC 201500-229"]
[230,"AC 201500-230"]
[231,"AC 201500-231"]
[232,"AC 201500-232"]
[233,"AC 201500-233"]
[234,"AC 201500-234"]
[235,"AC 201500-235"]
[236,"AC 201500-236"]
[237,"AC 201500-237"]
[238,"AC 201500-238"]
[239,"AC 201500-239"]
[240,"AC 201500-240"]
[241,"AC 201500-241"]
[242,"AC 201500-242"]
[243,"AC 201500-243"]
[244,"AC 201500-244"]
[245,"AC 201500-245"]
[246,"AC 201500-246"]
[247,"AC 201500-247"]
[248,"AC 201500-248"]
[249,"AC 201500-249"]
[250,"AC 201500-250"]
[251,"AC 201500-251"]
[252,"AC 201500-252"]
[253,"AC 201500-253"]
[254,"AC 201500-254"]
[255,"AC 201500-255"]
[256,"AC 201500-256"]
[257,{"$f":"INDEX(invoiceno,A317)","v":"AC 201500-257"}]
[258,"AC 201500-258"]
[{"$f":"A318+1","v":259},"AC 201500-259"]
[260,"AC 201500-260"]
[261,"AC 201500-261"]
[262,"AC 201500-262"]
[263,"AC 201500-263"]
[264,"AC 201500-264"]
[265,"AC 201500-265"]
[266,"AC 201500-266"]
[267,"AC 201500-267"]
[268,"AC 201500-268"]
[269,"AC 201500-269"]
[270,"AC 201500-270"]
[271,"AC 201500-271"]
[272,"AC 201500-272"]
[273,"AC 201500-273"]
[274,"AC 201500-274"]
[275,"AC 201500-275"]
[276,"AC 201500-276"]
[277,"AC 201500-277"]
[278,"AC 201500-278"]
[279,"AC 201500-279"]
[280,"AC 201500-280"]
[281,"AC 201500-281"]
[282,"AC 201500-282"]
[283,"AC 201500-283"]
[284,"AC 201500-284"]
[285,"AC 201500-285"]
[286,"AC 201500-286"]
[287,"AC 201500-287"]
[288,"AC 201500-288"]
[289,"AC 201500-289"]
[290,"AC 201500-290"]
[291,"AC 201500-291"]
[292,"AC 201500-292"]
[293,"AC 201500-293"]
[294,"AC 201500-294"]
[295,"AC 201500-295"]
[296,"AC 201500-296"]
[297,"AC 201500-297"]
[298,"AC 201500-298"]
[299,"AC 201500-299"]
[300,"AC 201500-300"]

{"sheet":"Invoice","index":4,"n_rows":57,"n_cols":6,"rows_kept":57,"cut":false,"hidden":false,"merged":[[16,2,19,3],[56,0,56,3]]}
[]
["Invoice Number to Display :"]
[]
[null,null,null,{"$f":"'Company Setup'!B4","v":"Aripra Worldwide"}]
[null,null,null,{"$f":"\"Tax ID : \"&'Company Setup'!B12","v":"Tax ID : 2788199749"}]
[null,null,null,{"$f":"'Company Setup'!B7","v":"Kencana Loka"}]
[null,null,null,{"$f":"'Company Setup'!B8","v":"BSD City - Banten"}]
[null,null,null,{"$f":"'Company Setup'!B9","v":"Indonesia"}]
[null,null,null,{"$f":"\"Email : \"&'Company Setup'!B10","v":"Email : email@email.com"}]
[null,null,null,{"$f":"\"Phone : \"&'Company Setup'!B11","v":"Phone : +62 21 555555"}]
[]
["Bill To :"]
[{"$f":"'Sales Input'!H55","v":"Customer Name 1"},null,null,{"$f":"\"Invoice No : \"&'Sales Input'!C32","v":"Invoice No : AC 201500-001"}]
["Address :",null,null,{"$f":"\"Date : \"&TEXT('Sales Input'!I54,\"DD mmm yyy\")","v":"Date : 10 Jan 2015"}]
[{"$f":"'Sales Input'!H56","v":"Customer 1 Address Line 1"},null,null,{"$f":"\"Customer PO No : \"&'Sales Input'!H54","v":"Customer PO No : PO 33459"}]
[{"$f":"'Sales Input'!H57","v":"Customer 1 Address Line 2"},null,null,{"$f":"\"Payment Terms : \"&'Sales Input'!H62","v":"Payment Terms : Cash on Delivery"}]
[{"$f":"'Sales Input'!H58","v":"Customer 1 Address Line 3"},null,{"$f":"'Company Setup'!B16&\" \"&TEXT(D48,\"##,0.00\")","v":"USD 7,020.75"}]
[{"$f":"\"Email : \"&'Sales Input'!H59","v":"Email : email@email.com"}]
[{"$f":"\"Phone : \"&'Sales Input'!H60","v":"Phone : +001-188475"}]
[{"$f":"\"Contact Person : \"&'Sales Input'!H61","v":"Contact Person : Mr. Joe Him"}]
[]
["Qty","Description",{"$f":"\"Unit Price (\"&'Company Setup'!B16&\")\"","v":"Unit Price (USD)"},{"$f":"\"Total Price (\"&'Company Setup'!B16&\")\"","v":"Total Price (USD)"}]
[{"$f":"'Sales Input'!I33","v":12},{"$f":"'Sales Input'!K33","v":"Product 18"},{"$f":"IF(B23=\"\",0,VLOOKUP(B23,'Company Setup'!$A$25:$B$44,2,FALSE))","v":20},{"$f":"A23*C23","v":240},null,{"$f":"IF(B23=\"\",0,(IF(VLOOKUP($B23,'Company Setup'!$A$25:$C$44,3,FALSE)=\"x\",$D23,0)))","v":240}]
[{"$f":"'Sales Input'!I34","v":10},{"$f":"'Sales Input'!K34","v":"Product 2"},{"$f":"IF(B24=\"\",0,VLOOKUP(B24,'Company Setup'!$A$25:$B$44,2,FALSE))","v":400},{"$f":"A24*C24","v":4000},null,{"$f":"IF(B24=\"\",0,(IF(VLOOKUP($B24,'Company Setup'!$A$25:$C$44,3,FALSE)=\"x\",$D24,0)))","v":4000}]
[{"$f":"'Sales Input'!I35","v":7},{"$f":"'Sales Input'!K35","v":"Product 14"},{"$f":"IF(B25=\"\",0,VLOOKUP(B25,'Company Setup'!$A$25:$B$44,2,FALSE))","v":30},210,null,{"$f":"IF(B25=\"\",0,(IF(VLOOKUP($B25,'Company Setup'!$A$25:$C$44,3,FALSE)=\"x\",$D25,0)))","v":210}]
[{"$f":"'Sales Input'!I36","v":5},{"$f":"'Sales Input'!K36","v":"Product 12"},{"$f":"IF(B26=\"\",0,VLOOKUP(B26,'Company Setup'!$A$25:$B$44,2,FALSE))","v":90},450,null,{"$f":"IF(B26=\"\",0,(IF(VLOOKUP($B26,'Company Setup'!$A$25:$C$44,3,FALSE)=\"x\",$D26,0)))","v":450}]
[{"$f":"'Sales Input'!I37","v":5},{"$f":"'Sales Input'!K37","v":"Product 4"},{"$f":"IF(B27=\"\",0,VLOOKUP(B27,'Company Setup'!$A$25:$B$44,2,FALSE))","v":100},500,null,{"$f":"IF(B27=\"\",0,(IF(VLOOKUP($B27,'Company Setup'!$A$25:$C$44,3,FALSE)=\"x\",$D27,0)))","v":500}]
[{"$f":"'Sales Input'!I38","v":4},{"$f":"'Sales Input'!K38","v":"Product 10"},{"$f":"IF(B28=\"\",0,VLOOKUP(B28,'Company Setup'!$A$25:$B$44,2,FALSE))","v":150},600,null,{"$f":"IF(B28=\"\",0,(IF(VLOOKUP($B28,'Company Setup'!$A$25:$C$44,3,FALSE)=\"x\",$D28,0)))","v":600}]
[{"$f":"'Sales Input'!I39","v":3},{"$f":"'Sales Input'!K39","v":"Product 6"},{"$f":"IF(B29=\"\",0,VLOOKUP(B29,'Company Setup'!$A$25:$B$44,2,FALSE))","v":44},132,null,{"$f":"IF(B29=\"\",0,(IF(VLOOKUP($B29,'Company Setup'!$A$25:$C$44,3,FALSE)=\"x\",$D29,0)))","v":132}]
[{"$f":"'Sales Input'!I40","v":1},{"$f":"'Sales Input'!K40","v":"Product 8"},{"$f":"IF(B30=\"\",0,VLOOKUP(B30,'Company Setup'!$A$25:$B$44,2,FALSE))","v":250.5},250.5,null,{"$f":"IF(B30=\"\",0,(IF(VLOOKUP($B30,'Company Setup'!$A$25:$C$44,3,FALSE)=\"x\",$D30,0)))","v":250.5}]
[{"$f":"'Sales Input'!I41","v":0},{"$f":"'Sales Input'!K41","v":""},{"$f":"IF(B31=\"\",0,VLOOKUP(B31,'Company Setup'!$A$25:$B$44,2,FALSE))","v":0},0,null,{"$f":"IF(B31=\"\",0,(IF(VLOOKUP($B31,'Company Setup'!$A$25:$C$44,3,FALSE)=\"x\",$D31,0)))","v":0}]
[{"$f":"'Sales Input'!I42","v":0},{"$f":"'Sales Input'!K42","v":""},{"$f":"IF(B32=\"\",0,VLOOKUP(B32,'Company Setup'!$A$25:$B$44,2,FALSE))","v":0},0,null,{"$f":"IF(B32=\"\",0,(IF(VLOOKUP($B32,'Company Setup'!$A$25:$C$44,3,FALSE)=\"x\",$D32,0)))","v":0}]
[{"$f":"'Sales Input'!I43","v":0},{"$f":"'Sales Input'!K43","v":""},{"$f":"IF(B33=\"\",0,VLOOKUP(B33,'Company Setup'!$A$25:$B$44,2,FALSE))","v":0},0,null,{"$f":"IF(B33=\"\",0,(IF(VLOOKUP($B33,'Company Setup'!$A$25:$C$44,3,FALSE)=\"x\",$D33,0)))","v":0}]
[{"$f":"'Sales Input'!I44","v":0},{"$f":"'Sales Input'!K44","v":""},{"$f":"IF(B34=\"\",0,VLOOKUP(B34,'Company Setup'!$A$25:$B$44,2,FALSE))","v":0},0,null,{"$f":"IF(B34=\"\",0,(IF(VLOOKUP($B34,'Company Setup'!$A$25:$C$44,3,FALSE)=\"x\",$D34,0)))","v":0}]
[{"$f":"'Sales Input'!I45","v":0},{"$f":"'Sales Input'!K45","v":""},{"$f":"IF(B35=\"\",0,VLOOKUP(B35,'Company Setup'!$A$25:$B$44,2,FALSE))","v":0},0,null,{"$f":"IF(B35=\"\",0,(IF(VLOOKUP($B35,'Company Setup'!$A$25:$C$44,3,FALSE)=\"x\",$D35,0)))","v":0}]
[{"$f":"'Sales Input'!I46","v":0},{"$f":"'Sales Input'!K46","v":""},{"$f":"IF(B36=\"\",0,VLOOKUP(B36,'Company Setup'!$A$25:$B$44,2,FALSE))","v":0},0,null,{"$f":"IF(B36=\"\",0,(IF(VLOOKUP($B36,'Company Setup'!$A$25:$C$44,3,FALSE)=\"x\",$D36,0)))","v":0}]
[{"$f":"'Sales Input'!I47","v":0},{"$f":"'Sales Input'!K47","v":""},{"$f":"IF(B37=\"\",0,VLOOKUP(B37,'Company Setup'!$A$25:$B$44,2,FALSE))","v":0},0,null,{"$f":"IF(B37=\"\",0,(IF(VLOOKUP($B37,'Company Setup'!$A$25:$C$44,3,FALSE)=\"x\",$D37,0)))","v":0}]
[{"$f":"'Sales Input'!I48","v":0},{"$f":"'Sales Input'!K48","v":""},{"$f":"IF(B38=\"\",0,VLOOKUP(B38,'Company Setup'!$A$25:$B$44,2,FALSE))","v":0},0,null,{"$f":"IF(B38=\"\",0,(IF(VLOOKUP($B38,'Company Setup'!$A$25:$C$44,3,FALSE)=\"x\",$D38,0)))","v":0}]
[{"$f":"'Sales Input'!I49","v":0},{"$f":"'Sales Input'!K49","v":""},{"$f":"IF(B39=\"\",0,VLOOKUP(B39,'Company Setup'!$A$25:$B$44,2,FALSE))","v":0},0,null,{"$f":"IF(B39=\"\",0,(IF(VLOOKUP($B39,'Company Setup'!$A$25:$C$44,3,FALSE)=\"x\",$D39,0)))","v":0}]
[{"$f":"'Sales Input'!I50","v":0},{"$f":"'Sales Input'!K50","v":""},{"$f":"IF(B40=\"\",0,VLOOKUP(B40,'Company Setup'!$A$25:$B$44,2,FALSE))","v":0},0,null,{"$f":"IF(B40=\"\",0,(IF(VLOOKUP($B40,'Company Setup'!$A$25:$C$44,3,FALSE)=\"x\",$D40,0)))","v":0}]
[{"$f":"'Sales Input'!I51","v":0},{"$f":"'Sales Input'!K51","v":""},{"$f":"IF(B41=\"\",0,VLOOKUP(B41,'Company Setup'!$A$25:$B$44,2,FALSE))","v":0},0,null,{"$f":"IF(B41=\"\",0,(IF(VLOOKUP($B41,'Company Setup'!$A$25:$C$44,3,FALSE)=\"x\",$D41,0)))","v":0}]
[{"$f":"'Sales Input'!I52","v":0},{"$f":"'Sales Input'!K52","v":""},{"$f":"IF(B42=\"\",0,VLOOKUP(B42,'Company Setup'!$A$25:$B$44,2,FALSE))","v":0},0,null,{"$f":"IF(B42=\"\",0,(IF(VLOOKUP($B42,'Company Setup'!$A$25:$C$44,3,FALSE)=\"x\",$D42,0)))","v":0}]
[]
[null,null,{"$f":"'Company Setup'!F16","v":"Total Sales (USD)"},{"$f":"SUM(D23:D43)","v":6382.5},null,{"$f":"SUM(F23:F42)","v":6382.5}]
[]
[null,null,{"$f":"'Company Setup'!F18","v":"VAT on Taxable Items (10%)"},{"$f":"F44*'Company Setup'!B18","v":638.25}]
[]
[null,null,{"$f":"'Company Setup'!F20","v":"Total Invoice (USD)"},{"$f":"SUM(D44:D47)","v":7020.75}]
[]
["Please send your payment to our bank account :"]
[{"$f":"\"Bank Name : \"&'Company Setup'!F8","v":"Bank Name : Bank GGG WORLDWIDE"}]
[{"$f":"\"Branch : \"&'Company Setup'!F9","v":"Branch : 775"}]
[{"$f":"\"Account No : \"&'Company Setup'!F10","v":"Account No : 271883749"}]
[{"$f":"\"IBAN No : \"&'Company Setup'!F11","v":"IBAN No : IBAN 453672271883749"}]
[{"$f":"\"Swift Code : \"&'Company Setup'!F12","v":"Swift Code : JHHSIIX"}]
[{"$f":"\"Beneficiary Name : \"&'Company Setup'!F7","v":"Beneficiary Name : Aripra Worldwide"}]
[{"$f":"'Company Setup'!F22","v":"[ THANK YOU FOR YOUR BUSINESS ]"}]

{"sheet":"cbo","index":5,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["DO NOT DELETE THIS SHEET !!!!"]
[1]