{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Senarai Inventori","Senarai Pilih Inventori","Carian Tong"],"not_rendered":{"charts":0,"images":0,"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":"Senarai Inventori","index":0,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,"SENARAI INVENTORI GUDANG"]
[null,"JUMLAH NILAI INVENTORI:",null,"KIRAAN TONG:",null,"ITEM INVENTORI:"]
[null,{"$f":"SUM(InventoryTable[NILAI INVENTORI])","v":4649},null,{"$f":"SUMPRODUCT((1/COUNTIF(InventoryTable[TONG '#],InventoryTable[TONG '#]&\"\")))","v":6},null,{"$f":"COUNTA(InventoryTable[PERIHALAN])","v":11}]
[]
[null,"SKU","PERIHALAN","TONG #","LOKASI","UNIT","KTT","KTT PESAN SEMULA","KOS","NILAI INVENTORI","PESAN SEMULA"]
[null,"SP7875","Item 1","T345",{"$f":"IFERROR(VLOOKUP(InventoryTable[[#This Row],[TONG '#]],BinLookupTable[],3,FALSE),\"\")","v":"Baris 2, slot 1"},"Setiap",20,10,30,{"$f":"InventoryTable[[#This Row],[KTT]]*InventoryTable[[#This Row],[KOS]]","v":600},{"$f":"IF(InventoryTable[[#This Row],[KTT]]<=InventoryTable[[#This Row],[KTT PESAN SEMULA]],1,0)","v":0}]
[null,"TR87680","Item 2","T345",{"$f":"IFERROR(VLOOKUP(InventoryTable[[#This Row],[TONG '#]],BinLookupTable[],3,FALSE),\"\")","v":"Baris 2, slot 1"},"Setiap",30,15,40,{"$f":"InventoryTable[[#This Row],[KTT]]*InventoryTable[[#This Row],[KOS]]","v":1200},{"$f":"IF(InventoryTable[[#This Row],[KTT]]<=InventoryTable[[#This Row],[KTT PESAN SEMULA]],1,0)","v":0}]
[null,"MK676554","Item 3","T5789",{"$f":"IFERROR(VLOOKUP(InventoryTable[[#This Row],[TONG '#]],BinLookupTable[],3,FALSE),\"\")","v":"Baris 1, slot 1"},"Setiap",10,5,5,{"$f":"InventoryTable[[#This Row],[KTT]]*InventoryTable[[#This Row],[KOS]]","v":50},{"$f":"IF(InventoryTable[[#This Row],[KTT]]<=InventoryTable[[#This Row],[KTT PESAN SEMULA]],1,0)","v":0}]
[null,"YE98767","Item 4","T9876",{"$f":"IFERROR(VLOOKUP(InventoryTable[[#This Row],[TONG '#]],BinLookupTable[],3,FALSE),\"\")","v":"Baris 3, slot 2"},"Kotak (10 ct)",40,10,15,{"$f":"InventoryTable[[#This Row],[KTT]]*InventoryTable[[#This Row],[KOS]]","v":600},{"$f":"IF(InventoryTable[[#This Row],[KTT]]<=InventoryTable[[#This Row],[KTT PESAN SEMULA]],1,0)","v":0}]
[null,"XR23423","Item 5","T098",{"$f":"IFERROR(VLOOKUP(InventoryTable[[#This Row],[TONG '#]],BinLookupTable[],3,FALSE),\"\")","v":"Baris 3, slot 1"},"Setiap",12,10,26,{"$f":"InventoryTable[[#This Row],[KTT]]*InventoryTable[[#This Row],[KOS]]","v":312},{"$f":"IF(InventoryTable[[#This Row],[KTT]]<=InventoryTable[[#This Row],[KTT PESAN SEMULA]],1,0)","v":0}]
[null,"PW98762","Item 6","T345",{"$f":"IFERROR(VLOOKUP(InventoryTable[[#This Row],[TONG '#]],BinLookupTable[],3,FALSE),\"\")","v":"Baris 2, slot 1"},"Setiap",7,10,50,{"$f":"InventoryTable[[#This Row],[KTT]]*InventoryTable[[#This Row],[KOS]]","v":350},{"$f":"IF(InventoryTable[[#This Row],[KTT]]<=InventoryTable[[#This Row],[KTT PESAN SEMULA]],1,0)","v":1}]
[null,"BM87684","Item 7","T349",{"$f":"IFERROR(VLOOKUP(InventoryTable[[#This Row],[TONG '#]],BinLookupTable[],3,FALSE),\"\")","v":"Baris 1, slot 2"},"Setiap",10,5,10,{"$f":"InventoryTable[[#This Row],[KTT]]*InventoryTable[[#This Row],[KOS]]","v":100},{"$f":"IF(InventoryTable[[#This Row],[KTT]]<=InventoryTable[[#This Row],[KTT PESAN SEMULA]],1,0)","v":0}]
[null,"BH67655","Item 8","T5789",{"$f":"IFERROR(VLOOKUP(InventoryTable[[#This Row],[TONG '#]],BinLookupTable[],3,FALSE),\"\")","v":"Baris 1, slot 1"},"Setiap",19,10,3,{"$f":"InventoryTable[[#This Row],[KTT]]*InventoryTable[[#This Row],[KOS]]","v":57},{"$f":"IF(InventoryTable[[#This Row],[KTT]]<=InventoryTable[[#This Row],[KTT PESAN SEMULA]],1,0)","v":0}]
[null,"WT98768","Item 9","T9875",{"$f":"IFERROR(VLOOKUP(InventoryTable[[#This Row],[TONG '#]],BinLookupTable[],3,FALSE),\"\")","v":"Baris 2, slot 2"},"Pakej (5 ct)",20,30,14,{"$f":"InventoryTable[[#This Row],[KTT]]*InventoryTable[[#This Row],[KOS]]","v":280},{"$f":"IF(InventoryTable[[#This Row],[KTT]]<=InventoryTable[[#This Row],[KTT PESAN SEMULA]],1,0)","v":1}]
[null,"TS3456","Item 10","T349",{"$f":"IFERROR(VLOOKUP(InventoryTable[[#This Row],[TONG '#]],BinLookupTable[],3,FALSE),\"\")","v":"Baris 1, slot 2"},"Setiap",15,8,60,{"$f":"InventoryTable[[#This Row],[KTT]]*InventoryTable[[#This Row],[KOS]]","v":900},{"$f":"IF(InventoryTable[[#This Row],[KTT]]<=InventoryTable[[#This Row],[KTT PESAN SEMULA]],1,0)","v":0}]
[null,"WDG123","Item 11","T349",{"$f":"IFERROR(VLOOKUP(InventoryTable[[#This Row],[TONG '#]],BinLookupTable[],3,FALSE),\"\")","v":"Baris 1, slot 2"},"Setiap",25,15,8,{"$f":"InventoryTable[[#This Row],[KTT]]*InventoryTable[[#This Row],[KOS]]","v":200},{"$f":"IF(InventoryTable[[#This Row],[KTT]]<=InventoryTable[[#This Row],[KTT PESAN SEMULA]],1,0)","v":0}]

{"sheet":"Senarai Pilih Inventori","index":1,"n_rows":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[null,"SENARAI PILIH INVENTORI"]
[]
[null,"PESANAN #","SKU","KTT PILIH","KTT TERSEDIA","PERIHALAN ITEM","UNIT","TONG #","LOKASI"]
[null,"TP001-1","SP7875",3,{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU],InventoryTable[],6,FALSE),\"\")","v":20},{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU],InventoryTable[],2,FALSE),\"\")","v":"Item 1"},{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU],InventoryTable[],5,FALSE),\"\")","v":"Setiap"},{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU],InventoryTable[],3,FALSE),\"\")","v":"T345"},{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU],InventoryTable[],4,FALSE),\"\")","v":"Baris 2, slot 1"}]
[null,"TP001-1","YE98767",1,{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU],InventoryTable[],6,FALSE),\"\")","v":40},{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU],InventoryTable[],2,FALSE),\"\")","v":"Item 4"},{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU],InventoryTable[],5,FALSE),\"\")","v":"Kotak (10 ct)"},{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU],InventoryTable[],3,FALSE),\"\")","v":"T9876"},{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU],InventoryTable[],4,FALSE),\"\")","v":"Baris 3, slot 2"}]
[null,"TP001-1","BM87684",2,{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU],InventoryTable[],6,FALSE),\"\")","v":10},{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU],InventoryTable[],2,FALSE),\"\")","v":"Item 7"},{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU],InventoryTable[],5,FALSE),\"\")","v":"Setiap"},{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU],InventoryTable[],3,FALSE),\"\")","v":"T349"},{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU],InventoryTable[],4,FALSE),\"\")","v":"Baris 1, slot 2"}]
[null,"TP001-1","TS3456",6,{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU],InventoryTable[],6,FALSE),\"\")","v":15},{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU],InventoryTable[],2,FALSE),\"\")","v":"Item 10"},{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU],InventoryTable[],5,FALSE),\"\")","v":"Setiap"},{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU],InventoryTable[],3,FALSE),\"\")","v":"T349"},{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU],InventoryTable[],4,FALSE),\"\")","v":"Baris 1, slot 2"}]
[null,"TP001-1","MK676554",3,{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU],InventoryTable[],6,FALSE),\"\")","v":10},{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU],InventoryTable[],2,FALSE),\"\")","v":"Item 3"},{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU],InventoryTable[],5,FALSE),\"\")","v":"Setiap"},{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU],InventoryTable[],3,FALSE),\"\")","v":"T5789"},{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU],InventoryTable[],4,FALSE),\"\")","v":"Baris 1, slot 1"}]

{"sheet":"Carian Tong","index":2,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,6]]}
[null,"CARIAN TONG"]
[]
[null,"JADUAL INI MEMBEKALKAN DATA BAGI KEDUA-DUA HELAIAN SENARAI INVENTORI DAN SENARAI PILIH INVENTORI"]
[null,"TONG #","PERIHALAN","LOKASI","LEBAR","KETINGGIAN","KEPANJANGAN"]
[null,"T345","Tong besar","Baris 2, slot 1",50,10,10]
[null,"T5789","Tong kecil","Baris 1, slot 1",25,5,5]
[null,"T9876","Tong besar","Baris 3, slot 2",50,10,10]
[null,"T098","Tong sederhana","Baris 3, slot 1",30,7,10]
[null,"T349","Tong kecil","Baris 1, slot 2",25,5,5]
[null,"T5789","Tong besar","Baris 4, slot 5",50,10,10]
[null,"T9875","Tong besar","Baris 2, slot 2",50,10,10]