{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Menu","Menu1","POData","PO","Vendor","ProdData","Summary"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":1},"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":"Menu","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Menu1","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"POData","index":2,"n_rows":122,"n_cols":9,"rows_kept":122,"cut":false,"hidden":false,"merged":[]}
["PONo","PoDate","Vendor","Product","Qty","Cost","Amount","ReqDate","YM"]
["L-0423","2019-10-11","East","Pepsi",748,10,{"$f":"E2*F2","v":7480},"2020-12-21",{"$f":"TEXT(B2,\"yyyy/mm\")","v":"2019/10"}]
["L-0436","2019-10-11","West","S Cola",791,20,{"$f":"E3*F3","v":15820},"2020-12-22",{"$f":"TEXT(B3,\"yyyy/mm\")","v":"2019/10"}]
["L-0436","2019-10-13","West","Fanta",1033,0,0,"2020-12-23","2019/10"]
["L-0436","2019-10-13","West","M-100",1012,0,0,"2020-12-24","2019/10"]
["L-0437","2019-10-13","South","Coke",458,0,0,"2020-12-25","2019/10"]
["L-0438","2019-10-13","North","Fanta",159,0,0,"2020-12-26","2019/10"]
["L-0438","2019-10-13","North","S Cola",1399,0,0,"2020-12-27","2019/10"]
["L-0436","2019-10-13","West","Pepsi",1267,0,0,null,"2019/10"]
["L-0436","2019-10-13","West","M-100",1861,0,0,null,"2019/10"]
["L-0416","2019-10-13","South","Fanta",208,0,0,null,"2019/10"]
["L-0437","2019-10-13","South","M-100",1625,0,0,null,"2019/10"]
["L-0434","2019-10-23","West","Pepsi",1563,0,0,null,"2019/10"]
["L-0437","2019-10-23","South","Fanta",154,0,0,null,"2019/10"]
["L-0416","2019-10-23","South","Pepsi",690,0,0,null,"2019/10"]
["L-0434","2019-10-23","West","Coke",1618,0,0,null,"2019/10"]
["L-0436","2019-10-23","West","M-100",166,0,0,null,"2019/10"]
["L-0438","2019-10-23","North","Coke",1258,0,0,null,"2019/10"]
["L-0437","2019-10-30","South","Mirinda",1702,0,0,null,"2019/10"]
["L-0437","2019-10-31","South","S Cola",427,0,0,null,"2019/10"]
["L-0437","2019-11-01","South","Mirinda",1800,0,0,null,"2019/11"]
["L-0437","2019-11-01","South","Coke",707,0,0,null,"2019/11"]
["L-0437","2019-11-01","South","Coke",483,0,0,null,"2019/11"]
["L-0436","2019-11-01","West","Coke",827,0,0,null,"2019/11"]
["L-0436","2019-11-01","West","S Cola",1890,0,0,null,"2019/11"]
["L-0438","2019-11-01","North","Sprite",1864,0,0,null,"2019/11"]
["L-0438","2019-11-01","North","Pepsi",380,0,0,null,"2019/11"]
["L-0437","2019-11-01","South","S Cola",510,0,0,null,"2019/11"]
["L-0437","2019-11-01","South","Mirinda",580,0,0,null,"2019/11"]
["L-0437","2019-11-01","South","S Cola",891,0,0,null,"2019/11"]
["L-0437","2019-11-01","South","Sprite",359,0,0,null,"2019/11"]
["L-0416","2019-11-01","South","Coke",371,0,0,null,"2019/11"]
["L-0420","2019-11-01","North","Pepsi",1257,0,0,null,"2019/11"]
["L-0423","2019-11-01","East","M-100",1048,0,0,null,"2019/11"]
["L-0434","2019-11-01","West","Coke",1255,0,0,null,"2019/11"]
["L-0436","2019-11-01","West","Mirinda",702,0,0,null,"2019/11"]
["L-0436","2019-11-01","West","Mirinda",1534,0,0,null,"2019/11"]
["L-0436","2019-11-01","West","Sprite",190,0,0,null,"2019/11"]
["L-0436","2019-11-01","West","S Cola",120,0,0,null,"2019/11"]
["L-0436","2019-11-01","West","Coke",778,0,0,null,"2019/11"]
["L-0436","2019-11-01","West","Mirinda",543,0,0,null,"2019/11"]
["L-0437","2019-11-01","South","S Cola",1821,0,0,null,"2019/11"]
["L-0437","2019-11-01","South","Pepsi",1835,0,0,null,"2019/11"]
["L-0416","2019-11-26","South","Mirinda",126,0,0,null,"2019/11"]
["L-0436","2019-11-26","West","Coke",373,0,0,null,"2019/11"]
["L-0436","2019-11-26","West","M-100",1678,0,0,null,"2019/11"]
["L-0436","2019-11-26","West","M-100",783,0,0,null,"2019/11"]
["L-0437","2019-11-26","South","M-100",1545,0,0,null,"2019/11"]
["L-0437","2019-12-01","South","Mirinda",1463,0,0,null,"2019/12"]
["L-0437","2019-12-01","South","Pepsi",336,0,0,null,"2019/12"]
["L-0437","2019-12-01","South","Coke",918,0,0,null,"2019/12"]
["L-0438","2019-12-01","North","Sprite",509,0,0,null,"2019/12"]
["L-0437","2019-12-01","South","M-100",1346,0,0,null,"2019/12"]
["L-0416","2019-12-01","South","Sprite",1700,0,0,null,"2019/12"]
["L-0416","2019-12-07","South","S Cola",1731,0,0,null,"2019/12"]
["L-0420","2019-12-07","North","Sprite",1926,0,0,null,"2019/12"]
["L-0423","2019-12-07","East","Fanta",1361,0,0,null,"2019/12"]
["L-0423","2019-12-10","East","M-100",1380,0,0,null,"2019/12"]
["L-0434","2019-12-10","West","Fanta",1421,0,0,null,"2019/12"]
["L-0436","2019-12-10","West","Coke",1697,0,0,null,"2019/12"]
["L-0436","2019-12-10","West","Coke",1083,0,0,null,"2019/12"]
["L-0437","2020-01-01","South","Pepsi",1097,0,0,null,"2020/01"]
["L-0437","2020-01-02","South","M-100",1452,0,0,null,"2020/01"]
["L-0437","2020-01-03","South","Pepsi",1012,0,0,null,"2020/01"]
["L-0437","2020-01-04","South","Pepsi",373,0,0,null,"2020/01"]
["L-0437","2020-01-05","South","M-100",806,0,0,null,"2020/01"]
["L-0437","2020-01-06","South","Pepsi",1417,0,{"$f":"E67*F67","v":0},null,{"$f":"TEXT(B67,\"yyyy/mm\")","v":"2020/01"}]
["L-0416","2020-01-08","South","M-100",1906,0,0,null,"2020/01"]
["L-0416","2020-01-09","South","S Cola",1880,0,0,null,"2020/01"]
["L-0416","2020-01-10","South","Fanta",499,0,0,null,"2020/01"]
["L-0416","2020-01-11","South","Pepsi",1721,0,0,null,"2020/01"]
["L-0423","2020-01-12","East","Pepsi",1846,0,0,null,"2020/01"]
["L-0434","2020-01-13","West","Fanta",1462,0,0,null,"2020/01"]
["L-0437","2020-01-14","South","M-100",249,0,0,null,"2020/01"]
["L-0437","2020-01-15","South","Mirinda",1587,0,0,null,"2020/01"]
["L-0437","2020-01-16","South","Mirinda",565,0,0,null,"2020/01"]
["L-0437","2020-02-01","South","Sprite",751,0,0,null,"2020/02"]
["L-0437","2020-02-02","South","Fanta",1223,0,0,null,"2020/02"]
["L-0437","2020-02-03","South","Fanta",376,0,0,null,"2020/02"]
["L-0437","2020-02-04","South","Pepsi",1339,0,0,null,"2020/02"]
["L-0437","2020-02-05","South","Coke",486,0,0,null,"2020/02"]
["L-0437","2020-02-06","South","S Cola",1102,0,0,null,"2020/02"]
["L-0437","2020-02-07","South","Coke",1590,0,0,null,"2020/02"]
["L-0437","2020-02-08","South","Fanta",1951,0,0,null,"2020/02"]
["L-0437","2020-02-09","South","Sprite",1680,0,0,null,"2020/02"]
["L-0438","2020-03-10","North","Mirinda",293,0,0,null,"2020/03"]
["L-0438","2020-03-11","North","Fanta",231,0,0,null,"2020/03"]
["L-0438","2020-03-12","North","Sprite",1394,0,0,null,"2020/03"]
["L-0437","2020-03-14","South","M-100",209,0,0,null,"2020/03"]
["L-0436","2020-03-15","West","Mirinda",1915,0,0,null,"2020/03"]
["L-0436","2020-03-16","West","M-100",955,0,0,null,"2020/03"]
["L-0436","2020-03-17","West","M-100",1540,0,0,null,"2020/03"]
["L-0436","2020-03-18","West","Coke",1942,0,0,null,"2020/03"]
["L-0437","2020-03-19","South","Pepsi",997,0,0,null,"2020/03"]
["L-0436","2020-03-20","West","Fanta",1863,0,0,null,"2020/03"]
["L-0436","2020-03-21","West","Coke",828,0,0,null,"2020/03"]
["L-0436","2020-03-22","West","Sprite",278,0,0,null,"2020/03"]
["L-0436","2020-03-23","West","Sprite",965,0,0,null,"2020/03"]
["L-0438","2020-03-24","North","S Cola",172,0,0,null,"2020/03"]
["L-0442","2020-11-19","West","Sponser",100,0,0,null,"2020/11"]
["L-0442","2020-11-19","West","Sprite",278,0,0,null,"2020/11"]
["L-0442","2020-11-19","West","Sprite",965,0,0,null,"2020/11"]
["L-Test","2020-12-08","South","Coke",20,10,200,"2020-12-21","2020/12"]
["L-Test","2020-12-08","South","Fanta",10,20,200,"2020-12-21","2020/12"]
["L-Test","2020-12-08","South","Coke",null,null,0,null,"2020/12"]
["L-Test","2020-12-08","South","Fanta",null,null,0,null,"2020/12"]
["PO-001","2020-12-21","East","S Cola",20,10,200,"2021-02-21","2020/12"]
["PO-001","2020-12-21","East","Sprite",10,8,80,"2021-02-21","2020/12"]
["PO-001","2020-12-21","East","Fanta",1000,9,9000,"2021-02-21","2020/12"]
[null,null,null,null,null,null,0,null,"1900/01"]
[null,null,null,null,null,null,0,null,"1900/01"]
[null,null,null,null,null,null,0,null,"1900/01"]
[null,null,null,null,null,null,0,null,"1900/01"]
[null,null,null,null,null,null,0,null,"1900/01"]
[null,null,null,null,null,null,0,null,"1900/01"]
[null,null,null,null,null,null,0,null,"1900/01"]
[null,null,null,null,null,null,0,null,"1900/01"]
[null,null,null,null,null,null,0,null,"1900/01"]
[null,null,null,null,null,null,0,null,"1900/01"]
[null,null,null,null,null,null,0,null,"1900/01"]
[null,null,null,null,null,null,0,null,"1900/01"]
[null,null,null,null,null,null,0,null,"1900/01"]

{"sheet":"PO","index":3,"n_rows":42,"n_cols":5,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
[]
["ABC Co., Ltd."]
["18 Silom Road, Bangkok, Thailand."]
[]
[]
["PURCHASE ORDER"]
[]
["East"]
[{"$f":"VLOOKUP($A$9,VendorTbl[],2,FALSE)","v":"East Co., Ltd."},null,null,"PO No.","PO-001"]
[{"$f":"VLOOKUP($A$9,VendorTbl[],3,FALSE)","v":"18 Silom Rd.,"},null,null,"Date","2020-12-21"]
[{"$f":"VLOOKUP($A$9,VendorTbl[],4,FALSE)","v":"Bangkok, Thailand"},null,null,"Required Date","2021-02-21"]
[]
[]
["Item","Product Description","Quantity","Unit Price","Amount"]
[1,"S Cola",20,10,{"$f":"IFERROR(C16*D16,\"\")","v":200}]
[2,"Sprite",10,8,80]
[3,"Fanta",1000,9,9000]
[null,null,null,null,0]
[null,null,null,null,{"$f":"IFERROR(C20*D20,\"\")","v":0}]
[null,null,null,null,{"$f":"IFERROR(C21*D21,\"\")","v":0}]
[null,null,null,null,{"$f":"IFERROR(C22*D22,\"\")","v":0}]
[null,null,null,null,{"$f":"IFERROR(C23*D23,\"\")","v":0}]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[]
[]
[null,null,null,"Total",{"$f":"SUM(E16:E32)","v":9280}]
[null," ",null,"Vat",{"$f":"E33*0.07","v":649.6}]
[null,null,null,"Net",{"$f":"E33+E34","v":9929.6}]
[]
[null,{"$f":"BAHTTEXT(E35)","v":"เก้าพันเก้าร้อยยี่สิบเก้าบาทหกสิบสตางค์"}]
[]
[]
[]
[]
[null,null,null,"Authorized by"]

{"sheet":"Vendor","index":4,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["VENDOR LIST"]
["VShort","VFullName","VAdd1","VAdd2"]
["East","East Co., Ltd.","18 Silom Rd.,","Bangkok, Thailand"]
["West","West Co., Ltd.","65/1 Rama 9","Bangkok, Thailand"]
["South","South Co., Ltd.","1/112 Rama 4","Bangkok, Thailand"]
["North","North Co., Ltd.","7/18 Sukhumvit 23","Bangkok, Thailand"]
["Bunjong","Acc Base Co., Ltd.","14 Ladprao","Bangkok, Thailand"]

{"sheet":"ProdData","index":5,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["PRODUCT LIST"]
["PName","PPrice"]
["Pepsi",10]
["S Cola",7]
["Fanta",8]
["M-100",7]
["Coke",9]
["Mirinda",10]
["Sprite",8]
["Sponser",7]
["น้ำส้ม",8]

{"sheet":"Summary","index":6,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["YM","(All)"]
[]
["Sum of Amount","Column Labels"]
["Row Labels","East","North","South","West","(blank)","Grand Total"]
["Coke",null,0,200,0,null,200]
["Fanta",9000,0,200,0,null,9200]
["M-100",0,null,0,0,null,0]
["Mirinda",null,0,0,0,null,0]
["Pepsi",7480,0,0,0,null,7480]
["S Cola",200,0,0,15820,null,16020]
["Sponser",null,null,null,0,null,0]
["Sprite",80,0,0,0,null,80]
["(blank)",null,null,null,null,0,0]
["Grand Total",16760,0,400,15820,0,32980]