{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Company","customers","products","data","invoice2"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":7,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Company","index":0,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["ชื่อ บริษัท","บริษัทอะไรนะ จำกัด (สำนักงานใหญ่)"]
["ที่อยู่ 1","99/28 หมู่4 อาคารซอฟท์แวร์พาร์ค ถ.แจ้งวัฒนะ  ต.คลองเกลือ"]
["ที่อยู่ 2","อ.ปากเกร็ด จ.นนทบุรี 11120"]
["ที่อยู่ 3","โทร.02-9649713 แฟ็กซ์ 02-9622118"]
["ที่อยู่ 4","Email : sales@cdnex.co.th  Line ID : @cdnex"]
["เลขที่ผู้เสียภาษี","0105547148848"]

{"sheet":"customers","index":1,"n_rows":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["customers_id","pre_cusname","customer_name","address","address2","address3","tax_id","Tel"]
["a001","บริษัท","ซีดีเน็กซ์ จำกัด  (สำนักงานใหญ่) ","99/28 หมู่4 อาคารซอฟท์แวร์พาร์ค ถ.แจ้งวัฒนะ  ","ต.คลองเกลือ อ.ปากเกร็ด จ.นนทบุรี  11120","โทร. 02-9649713","0105547148848","029649713",{"$f":"B2","v":"บริษัท"}]
["f001","ห้างหุ้นส่วนจำกัด","Facebook Company","56/70 หมู่5 ลาดสวาย ลำลูกกา ปทุมธานี 12150",null,null,"0105555787411",null,{"$f":"B3","v":"ห้างหุ้นส่วนจำกัด"}]
["m001","บริษัท","เอส ที รีเสิร์ช แอนด์ คอนซัลแทนท์ กรุ๊ป จำกัด (สำนักงานใหญ่)","24/27 ซอย 12 ถนนลงหาดบางแสน ตำบลแสนสุข","อำเภอเมืองชลบุรี จังหวัดชลบุรี 20130","โทร. 080-913-4177, 080-981-3321","0102125855557",null,"บริษัท"]
["d001","โรงเรียน","ดีพอแม็กซ์ จำกัด","201/444 หมู่2 ซ.พหลโยธิน 54/1 ถ.พหลโยธิน","ต.คลองถนน อ.สายไหม กรุงเทพฯ 10220","โทร. 02-9649713","0505557001125","025868668","โรงเรียน"]
["v001","สมาคม","วีลูปท์","159/272 ซ.นาเกลือ 29/1  ต.นาเกลือ","อ.บางละมุง  จ.ชลบุรี    20150","โทร. 038-411991","0205555013028",null,"สมาคม"]
["d002","บริษัท","ดีเลิศ พาณิชย์ แอนด์ ซัพพลาย","999/99 ม.3 ",null,null,null,null,"บริษัท"]
[null,"นิติบุคคลอาคารชุด","เดอะลิ๊งค์ 3","208 ซ.สุขุมวิท 50 ถ.สุมวิท แขวงพระโขนง ","เขตคลองเตย กรุงเทพฯ  10260","โทร. 02-7428849","0105555658452",null,"นิติบุคคลอาคารชุด"]

{"sheet":"products","index":2,"n_rows":6,"n_cols":5,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["No","products_name","product_id","products_price","products_unit"]
[1,"คอมพิวเตอร์","a001",10000,"เครื่อง"]
[2,"bitcoin","b001",20000,"เหรียญ"]
[3,"การ์ดจอ","c001",3000,"ตัว"]
[4,"Harddisk","h001",4000,"ตัว"]
[5,"ใบกำกับภาษี","F001",3200,"กล่อง"]

{"sheet":"data","index":3,"n_rows":200,"n_cols":23,"rows_kept":200,"cut":false,"hidden":false,"merged":[]}
["เลขที่ IV.","Date(กดปุ่ม Ctrl + ;)","รหัสลูกค้า","ชื่อลูกค้า","สินค้า1","Qty","สินค้า2","Qty","สินค้า3","Qty","สินค้า4","Qty","สินค้า5","Qty","สินค้า6","Qty","สินค้า7","Qty","สินค้า8","Qty","วันที่สั่งซื้อ","ใบสั่งซื้อเลขที่","วันครบกำหนดชำระ"]
[1,"2018-03-07","d002","ซีดีเน็กซ์ จำกัด  (สำนักงานใหญ่) ","การ์ดจอ",2,"ใบกำกับภาษี",2]
[{"$f":"IF(OR(D3=\"\",B3=\"\"),\"\",A2+1)","v":2},"2018-07-10",null,"ดีพอแม็กซ์ จำกัด","bitcoin",2]
[3,"2018-07-31",null,"เอส ที รีเสิร์ช แอนด์ คอนซัลแทนท์ กรุ๊ป จำกัด (สำนักงานใหญ่)"]
[""]
[""]
[""]
[{"$f":"IF(OR(D8=\"\",B8=\"\"),\"\",A7+1)","v":""}]
[{"$f":"IF(OR(D9=\"\",B9=\"\"),\"\",A8+1)","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(OR(D67=\"\",B67=\"\"),\"\",A66+1)","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(OR(D131=\"\",B131=\"\"),\"\",A130+1)","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(OR(D195=\"\",B195=\"\"),\"\",A194+1)","v":""}]
[""]
[""]
[""]
[""]
[""]

{"sheet":"invoice2","index":4,"n_rows":27,"n_cols":9,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,"วันที่",{"$f":"IF(VLOOKUP(No,InvData,2,0)=\"\",\"\",VLOOKUP(No,InvData,2,0))","v":"2018-03-07"}]
[null,null,null,null,"เลขที่",{"$f":"No","v":1}]
[{"$f":"IF(Company!A9=\"\",\"\",Company!A9)","v":""}]
[{"$f":"IFERROR(VLOOKUP(B8,customers!$B$2:$G$200,1,0),\"\")","v":""}]
[null,null,null,null,null,null,null,"แสดงอินวอยส์เลขที่",1]
[{"$f":"IFERROR(VLOOKUP(B8,customers!$C$2:$I$200,7,0),\"\")","v":"บริษัท"},{"$f":"IFERROR(VLOOKUP(No,InvData,4,0),\"\")","v":"ซีดีเน็กซ์ จำกัด  (สำนักงานใหญ่) "},null,null,null,{"$f":"IF(VLOOKUP(No,InvData,23,0)=\"\",\"\",VLOOKUP(No,InvData,23,0))","v":""},null,"จำนวน Invoice ทั้งหมด",{"$f":"MAX(data!A:A)","v":3}]
[null,{"$f":"IF(VLOOKUP(B8,customers!$C$2:$G$200,2,0)=\"\",\"\",(VLOOKUP(B8,customers!$C$2:$G$200,2,0)))","v":"99/28 หมู่4 อาคารซอฟท์แวร์พาร์ค ถ.แจ้งวัฒนะ  "},{"$f":"IF(VLOOKUP(B8,customers!$C$2:$G200,3,0)=\"\",\"\",(VLOOKUP(B8,customers!$C$2:$G$200,3,0)))","v":"ต.คลองเกลือ อ.ปากเกร็ด จ.นนทบุรี  11120"},{"$f":"IF(VLOOKUP(B8,customers!$C$2:$G$200,4,0)=\"\",\"\",(VLOOKUP(B8,customers!$C$2:$G$200,4,0)))","v":"โทร. 02-9649713"},null,null,null,"เริ่มพิมพ์จากอินวอยส์เลขที่",7]
[null,{"$f":"IFERROR(VLOOKUP(B8,customers!$C$2:$G$200,5,0),\"\")","v":"0105547148848"},null,null,null,null,null,"สิ้นสุด",10]
["Item code","Item Description","QTY",null,"Unit Price ","Amount"]
[{"$f":"IF(B12<>\"\",1,\"\")","v":1},{"$f":"IF(VLOOKUP(No,InvData,5,0)=\"\",\"\",VLOOKUP(No,InvData,5,0))","v":"การ์ดจอ"},{"$f":"IF(VLOOKUP(No,InvData,6,0)=\"\",\"\",VLOOKUP(No,InvData,6,0))","v":2},{"$f":"IFERROR(VLOOKUP(B12,products!$B$2:$E$50,4,0),\"\")","v":"ตัว"},{"$f":"IFERROR(VLOOKUP(B12,products!$B$2:$D$50,3,0),\"\")","v":3000},{"$f":"IFERROR((E12*C12),\"\")","v":6000}]
[{"$f":"IF(B13<>\"\",A12+1,\"\")","v":2},{"$f":"IF(VLOOKUP(No,InvData,7,0)=\"\",\"\",VLOOKUP(No,InvData,7,0))","v":"ใบกำกับภาษี"},{"$f":"IF(VLOOKUP(No,InvData,8,0)=\"\",\"\",VLOOKUP(No,InvData,8,0))","v":2},{"$f":"IFERROR(VLOOKUP(B13,products!$B$2:$E$50,4,0),\"\")","v":"กล่อง"},{"$f":"IFERROR(VLOOKUP(B13,products!$B$2:$D$50,3,0),\"\")","v":3200},6400]
["",{"$f":"IF(VLOOKUP(No,InvData,9,0)=\"\",\"\",VLOOKUP(No,InvData,9,0))","v":""},{"$f":"IF(VLOOKUP(No,InvData,10,0)=\"\",\"\",VLOOKUP(No,InvData,10,0))","v":""},{"$f":"IFERROR(VLOOKUP(B14,products!$B$2:$E$50,4,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B14,products!$B$2:$D$50,3,0),\"\")","v":""},""]
["",{"$f":"IF(VLOOKUP(No,InvData,11,0)=\"\",\"\",VLOOKUP(No,InvData,11,0))","v":""},{"$f":"IF(VLOOKUP(No,InvData,12,0)=\"\",\"\",VLOOKUP(No,InvData,12,0))","v":""},{"$f":"IFERROR(VLOOKUP(B15,products!$B$2:$E$50,4,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B15,products!$B$2:$D$50,3,0),\"\")","v":""},""]
["",{"$f":"IF(VLOOKUP(No,InvData,13,0)=\"\",\"\",VLOOKUP(No,InvData,13,0))","v":""},{"$f":"IF(VLOOKUP(No,InvData,14,0)=\"\",\"\",VLOOKUP(No,InvData,14,0))","v":""},{"$f":"IFERROR(VLOOKUP(B16,products!$B$2:$E$50,4,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B16,products!$B$2:$D$50,3,0),\"\")","v":""},""]
["",{"$f":"IF(VLOOKUP(No,InvData,15,0)=\"\",\"\",VLOOKUP(No,InvData,15,0))","v":""},{"$f":"IF(VLOOKUP(No,InvData,16,0)=\"\",\"\",VLOOKUP(No,InvData,16,0))","v":""},{"$f":"IFERROR(VLOOKUP(B17,products!$B$2:$E$50,4,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B17,products!$B$2:$D$50,3,0),\"\")","v":""},""]
["",{"$f":"IF(VLOOKUP(No,InvData,17,0)=\"\",\"\",VLOOKUP(No,InvData,17,0))","v":""},{"$f":"IF(VLOOKUP(No,InvData,18,0)=\"\",\"\",VLOOKUP(No,InvData,18,0))","v":""},{"$f":"IFERROR(VLOOKUP(B18,products!$B$2:$E$50,4,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B18,products!$B$2:$D$50,3,0),\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(E18,products!$B$2:$D$50,3,0),\"\")","v":""}]
["",{"$f":"IF(VLOOKUP(No,InvData,19,0)=\"\",\"\",VLOOKUP(No,InvData,19,0))","v":""},{"$f":"IF(VLOOKUP(No,InvData,20,0)=\"\",\"\",VLOOKUP(No,InvData,20,0))","v":""},{"$f":"IFERROR(VLOOKUP(B19,products!$B$2:$E$50,4,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B19,products!$B$2:$D$50,3,0),\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(E19,products!$B$2:$D$50,3,0),\"\")","v":""}]
[]
[null,null,null,null,"Sub Total",{"$f":"SUM(F12:F19)","v":12400}]
[null,null,7.0000000000000007E-2,null,"Tax",{"$f":"F21*C22","v":868.00000000000011}]
[null,null,null,null,"Grand Total",{"$f":"F21+F22","v":13268}]
[]
[]
[]
[null,{"$f":"BAHTTEXT(F23)","v":"หนึ่งหมื่นสามพันสองร้อยหกสิบแปดบาทถ้วน"}]