{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Home","Scan Items","Inventory Report","Inventory Count","Item DB","Log View","Lists","Setup","Log"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":0,"defined_names":9,"comments":0,"pivot_tables":3},"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":"Home","index":0,"n_rows":24,"n_cols":7,"rows_kept":24,"cut":false,"hidden":false,"merged":[[17,1,17,6]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Last Activity"]
[null,"Timestamp","Barcode","Description","Quantity","Inbound/Outbound","Warehouse"]
[null,{"$f":"OFFSET(Setup!$H$1,3,,5,3)","v":"2026-04-20T09:27:49"},1009,"Cleaning Spray 500ml",{"$f":"OFFSET(Setup!$H$1,3,5,5,1)","v":1},{"$f":"OFFSET(Setup!$H$1,3,3,5,2)","v":"Inbound"},"Main"]
[null,"2026-04-20T09:23:23",1001,"USB Cable 1m",1,"Inbound","Main"]
[null,"2026-04-20T09:22:37",1001,"USB Cable 1m",1,"Inbound","Main"]
[null,"2026-04-20T09:15:29",1001,"USB Cable 1m",1,"Inbound","Main"]
[null,"2026-04-20T09:04:37",1002,"Wireless Mouse",7,"Count","Front"]

{"sheet":"Scan Items","index":1,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":false,"merged":[[6,1,6,3]]}
[]
[null,"Inbound/Outbound:",1]
[null,"Warehouse:","Main"]
[null,"Mode:"]
[]
[null,"Scan Barcode:"]

{"sheet":"Inventory Report","index":2,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
["Sum of Quantity",null,"Warehouse"]
["Barcode","Description","Back","Front","Main","Storage","(blank)","Grand Total"]
["(blank)","(blank)"]
[1001,"USB Cable 1m",null,null,18,null,null,18]
[1002,"Wireless Mouse",null,5,-15,null,null,-10]
[1005,"Notebook A5",null,-10,null,null,null,-10]
[1006,"Pen Blue (Pack of 10)",null,-5,2,null,null,-3]
[1007,"Packing Box Medium",30,null,1,null,null,31]
[1003,"Keyboard (Mechanical)",null,-1,14,null,null,13]
[1009,"Cleaning Spray 500ml",null,null,6,18,null,24]
[1004,"Laptop Stand",null,-2,null,null,null,-2]
[1008,"Barcode Labels Roll",null,null,1,25,null,26]
[1010,"Safety Gloves (Pair)",35,-3,null,null,null,32]
["Grand Total",null,65,-16,27,43,null,119]

{"sheet":"Inventory Count","index":3,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
["Barcode","Description","Warehouse","Quantity ","Counted Qty"]
["(blank)","(blank)","(blank)"]
[1001,"USB Cable 1m","Main",18]
[1002,"Wireless Mouse","Front",5]
[1002,"Wireless Mouse","Main",-15]
[1005,"Notebook A5","Front",-10]
[1006,"Pen Blue (Pack of 10)","Front",-5]
[1006,"Pen Blue (Pack of 10)","Main",2]
[1007,"Packing Box Medium","Back",30]
[1007,"Packing Box Medium","Main",1]
[1003,"Keyboard (Mechanical)","Front",-1]
[1003,"Keyboard (Mechanical)","Main",14]
[1009,"Cleaning Spray 500ml","Main",6]
[1009,"Cleaning Spray 500ml","Storage",18]
[1004,"Laptop Stand","Front",-2]
[1008,"Barcode Labels Roll","Main",1]
[1008,"Barcode Labels Roll","Storage",25]
[1010,"Safety Gloves (Pair)","Back",35]
[1010,"Safety Gloves (Pair)","Front",-3]

{"sheet":"Item DB","index":4,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
["SKU#","Description","Category","Min Inventory","Current Inventory","Need to Order?"]
[1001,"USB Cable 1m","Electronics",20,{"$f":"SUMIFS(Log!$D:$D,Log!$B:$B,tblItems[[#This Row],[SKU'#]])","v":18},{"$f":"IF(tblItems[[#This Row],[Min Inventory]]>tblItems[[#This Row],[Current Inventory]],\"Yes\",\"\")","v":"Yes"}]
[1002,"Wireless Mouse","Electronics",15,{"$f":"SUMIFS(Log!$D:$D,Log!$B:$B,tblItems[[#This Row],[SKU'#]])","v":-10},{"$f":"IF(tblItems[[#This Row],[Min Inventory]]>tblItems[[#This Row],[Current Inventory]],\"Yes\",\"\")","v":"Yes"}]
[1003,"Keyboard (Mechanical)","Electronics",10,{"$f":"SUMIFS(Log!$D:$D,Log!$B:$B,tblItems[[#This Row],[SKU'#]])","v":13},{"$f":"IF(tblItems[[#This Row],[Min Inventory]]>tblItems[[#This Row],[Current Inventory]],\"Yes\",\"\")","v":""}]
[1004,"Laptop Stand","Accessories",12,{"$f":"SUMIFS(Log!$D:$D,Log!$B:$B,tblItems[[#This Row],[SKU'#]])","v":-2},{"$f":"IF(tblItems[[#This Row],[Min Inventory]]>tblItems[[#This Row],[Current Inventory]],\"Yes\",\"\")","v":"Yes"}]
[1005,"Notebook A5","Stationery",50,{"$f":"SUMIFS(Log!$D:$D,Log!$B:$B,tblItems[[#This Row],[SKU'#]])","v":-10},{"$f":"IF(tblItems[[#This Row],[Min Inventory]]>tblItems[[#This Row],[Current Inventory]],\"Yes\",\"\")","v":"Yes"}]
[1006,"Pen Blue (Pack of 10)","Stationery",40,{"$f":"SUMIFS(Log!$D:$D,Log!$B:$B,tblItems[[#This Row],[SKU'#]])","v":-3},{"$f":"IF(tblItems[[#This Row],[Min Inventory]]>tblItems[[#This Row],[Current Inventory]],\"Yes\",\"\")","v":"Yes"}]
[1007,"Packing Box Medium","Packaging",20,{"$f":"SUMIFS(Log!$D:$D,Log!$B:$B,tblItems[[#This Row],[SKU'#]])","v":31},{"$f":"IF(tblItems[[#This Row],[Min Inventory]]>tblItems[[#This Row],[Current Inventory]],\"Yes\",\"\")","v":""}]
[1008,"Barcode Labels Roll","Packaging",18,{"$f":"SUMIFS(Log!$D:$D,Log!$B:$B,tblItems[[#This Row],[SKU'#]])","v":26},{"$f":"IF(tblItems[[#This Row],[Min Inventory]]>tblItems[[#This Row],[Current Inventory]],\"Yes\",\"\")","v":""}]
[1009,"Cleaning Spray 500ml","Maintenance",10,{"$f":"SUMIFS(Log!$D:$D,Log!$B:$B,tblItems[[#This Row],[SKU'#]])","v":24},{"$f":"IF(tblItems[[#This Row],[Min Inventory]]>tblItems[[#This Row],[Current Inventory]],\"Yes\",\"\")","v":""}]
[201,"Test","Maintenance",5,{"$f":"SUMIFS(Log!$D:$D,Log!$B:$B,tblItems[[#This Row],[SKU'#]])","v":0},{"$f":"IF(tblItems[[#This Row],[Min Inventory]]>tblItems[[#This Row],[Current Inventory]],\"Yes\",\"\")","v":"Yes"}]

{"sheet":"Log View","index":5,"n_rows":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Timestamp","Barcode","Description","Quantity","Inbound/Outbound","Warehouse"]
["4/18/26 09:05 AM",1001,"USB Cable 1m",14,"Inbound","Main"]
["4/18/26 10:02 AM",1001,"USB Cable 1m",-2,"Outbound","Main"]
["2026-04-20T09:02:37",1001,"USB Cable 1m",2,"Inbound","Main"]
["2026-04-20T09:03:26",1001,"USB Cable 1m",1,"Inbound","Main"]
["4/18/26 10:15 AM",1006,"Pen Blue (Pack of 10)",-5,"Outbound","Front"]
["4/18/26 10:45 AM",1007,"Packing Box Medium",30,"Inbound","Back"]
["4/18/26 11:10 AM",1003,"Keyboard (Mechanical)",10,"Inbound","Main"]
["4/18/26 11:25 AM",1003,"Keyboard (Mechanical)",-1,"Outbound","Front"]
["4/18/26 12:05 PM",1009,"Cleaning Spray 500ml",18,"Inbound","Storage"]
["4/18/26 12:30 PM",1004,"Laptop Stand",-2,"Outbound","Front"]
["4/18/26 01:15 PM",1008,"Barcode Labels Roll",25,"Inbound","Storage"]
["4/18/26 02:00 PM",1010,"Safety Gloves (Pair)",35,"Inbound","Back"]
["4/18/26 02:20 PM",1010,"Safety Gloves (Pair)",-3,"Outbound","Front"]
["4/18/26 03:10 PM",1002,"Wireless Mouse",-2,"Outbound","Front"]
["4/18/26 04:00 PM",1005,"Notebook A5",-10,"Outbound","Front"]
["2026-04-20T09:02:37",1002,"Wireless Mouse",5,"Inbound","Main"]
["2026-04-20T09:02:37",1003,"Keyboard (Mechanical)",4,"Inbound","Main"]
["2026-04-20T09:02:37",1008,"Barcode Labels Roll",1,"Inbound","Main"]
["2026-04-20T09:02:37",1006,"Pen Blue (Pack of 10)",2,"Inbound","Main"]
["2026-04-20T09:02:37",1007,"Packing Box Medium",1,"Inbound","Main"]
["2026-04-20T09:02:37",1009,"Cleaning Spray 500ml",4,"Inbound","Main"]
["2026-04-20T09:03:23",1009,"Cleaning Spray 500ml",1,"Inbound","Main"]
["2026-04-20T09:04:37",1002,"Wireless Mouse",7,"Count","Front"]
["2026-04-20T09:04:37",1002,"Wireless Mouse",-20,"Count","Main"]

{"sheet":"Lists","index":6,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
["Category",null,"Warehouse"]
["Electronics",null,"Main"]
["Accessories",null,"Back"]
["Stationery",null,"Front"]
["Packaging",null,"Storage"]
["Maintenance"]

{"sheet":"Setup","index":7,"n_rows":31,"n_cols":13,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
["Key","Value",null,"Home"]
["Version","Free",null,"KPIs",null,null,null,"Timestamp","Barcode","Description","Inbound/Outbound","Warehouse","Sum of Quantity"]
["Mode","Auto",null,"Total Items",{"$f":"COUNTA('Item DB'!A:A)-1","v":10},null,null,"(blank)","(blank)","(blank)","(blank)","(blank)"]
["In/Out","Inbound",null,"Warehouse Stock",{"$f":"SUM(Log!D:D)","v":119},null,null,"2026-04-20T09:27:49",1009,"Cleaning Spray 500ml","Inbound","Main",1]
["MaxItems",3,null,"Today's Scans",{"$f":"COUNTIFS(Log!A:A, \">=\"&TODAY(), Log!A:A, \"<\"&TODAY()+1)","v":15},null,null,"2026-04-20T09:23:23",1001,"USB Cable 1m","Inbound","Main",1]
["MaxScans",15,null,"Low Stock Alerts",{"$f":"COUNTIFS('Item DB'!F:F,\"Yes\")","v":6},null,null,"2026-04-20T09:22:37",1001,"USB Cable 1m","Inbound","Main",1]
["ScanCount",0,null,null,null,null,null,"2026-04-20T09:15:29",1001,"USB Cable 1m","Inbound","Main",1]
["LastScanTime","(optional)",null,null,null,null,null,"2026-04-20T09:04:37",1002,"Wireless Mouse","Count","Front",7]
[null,null,null,null,null,null,null,"2026-04-20T09:04:37",1002,"Wireless Mouse","Count","Main",-20]
[null,null,null,null,null,null,null,"2026-04-20T09:03:26",1001,"USB Cable 1m","Inbound","Main",1]
[null,null,null,null,null,null,null,"2026-04-20T09:03:23",1009,"Cleaning Spray 500ml","Inbound","Main",1]
[null,null,null,null,null,null,null,"2026-04-20T09:02:37",1001,"USB Cable 1m","Inbound","Main",2]
[null,null,null,null,null,null,null,"2026-04-20T09:02:37",1002,"Wireless Mouse","Inbound","Main",5]
[null,null,null,null,null,null,null,"2026-04-20T09:02:37",1003,"Keyboard (Mechanical)","Inbound","Main",4]
[null,null,null,null,null,null,null,"2026-04-20T09:02:37",1006,"Pen Blue (Pack of 10)","Inbound","Main",2]
[null,null,null,null,null,null,null,"2026-04-20T09:02:37",1007,"Packing Box Medium","Inbound","Main",1]
[null,null,null,null,null,null,null,"2026-04-20T09:02:37",1008,"Barcode Labels Roll","Inbound","Main",1]
[null,null,null,null,null,null,null,"2026-04-20T09:02:37",1009,"Cleaning Spray 500ml","Inbound","Main",4]
[null,null,null,null,null,null,null,"4/18/26 12:30 PM",1004,"Laptop Stand","Outbound","Front",-2]
[null,null,null,null,null,null,null,"4/18/26 12:05 PM",1009,"Cleaning Spray 500ml","Inbound","Storage",18]
[null,null,null,null,null,null,null,"4/18/26 11:25 AM",1003,"Keyboard (Mechanical)","Outbound","Front",-1]
[null,null,null,null,null,null,null,"4/18/26 11:10 AM",1003,"Keyboard (Mechanical)","Inbound","Main",10]
[null,null,null,null,null,null,null,"4/18/26 10:45 AM",1007,"Packing Box Medium","Inbound","Back",30]
[null,null,null,null,null,null,null,"4/18/26 10:15 AM",1006,"Pen Blue (Pack of 10)","Outbound","Front",-5]
[null,null,null,null,null,null,null,"4/18/26 10:02 AM",1001,"USB Cable 1m","Outbound","Main",-2]
[null,null,null,null,null,null,null,"4/18/26 09:05 AM",1001,"USB Cable 1m","Inbound","Main",14]
[null,null,null,null,null,null,null,"4/18/26 04:00 PM",1005,"Notebook A5","Outbound","Front",-10]
[null,null,null,null,null,null,null,"4/18/26 03:10 PM",1002,"Wireless Mouse","Outbound","Front",-2]
[null,null,null,null,null,null,null,"4/18/26 02:20 PM",1010,"Safety Gloves (Pair)","Outbound","Front",-3]
[null,null,null,null,null,null,null,"4/18/26 02:00 PM",1010,"Safety Gloves (Pair)","Inbound","Back",35]
[null,null,null,null,null,null,null,"4/18/26 01:15 PM",1008,"Barcode Labels Roll","Inbound","Storage",25]

{"sheet":"Log","index":8,"n_rows":29,"n_cols":6,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
["Timestamp","Barcode","Description","Quantity","Inbound/Outbound","Warehouse"]
["4/18/26 09:05 AM",1001,"USB Cable 1m",14,"Inbound","Main"]
["4/18/26 10:02 AM",1001,"USB Cable 1m",-2,"Outbound","Main"]
["2026-04-20T09:02:37",1001,"USB Cable 1m",2,"Inbound","Main"]
["2026-04-20T09:03:26",1001,"USB Cable 1m",1,"Inbound","Main"]
["4/18/26 10:15 AM",1006,"Pen Blue (Pack of 10)",-5,"Outbound","Front"]
["4/18/26 10:45 AM",1007,"Packing Box Medium",30,"Inbound","Back"]
["4/18/26 11:10 AM",1003,"Keyboard (Mechanical)",10,"Inbound","Main"]
["4/18/26 11:25 AM",1003,"Keyboard (Mechanical)",-1,"Outbound","Front"]
["4/18/26 12:05 PM",1009,"Cleaning Spray 500ml",18,"Inbound","Storage"]
["4/18/26 12:30 PM",1004,"Laptop Stand",-2,"Outbound","Front"]
["4/18/26 01:15 PM",1008,"Barcode Labels Roll",25,"Inbound","Storage"]
["4/18/26 02:00 PM",1010,"Safety Gloves (Pair)",35,"Inbound","Back"]
["4/18/26 02:20 PM",1010,"Safety Gloves (Pair)",-3,"Outbound","Front"]
["4/18/26 03:10 PM",1002,"Wireless Mouse",-2,"Outbound","Front"]
["4/18/26 04:00 PM",1005,"Notebook A5",-10,"Outbound","Front"]
["2026-04-20T09:02:37",1002,"Wireless Mouse",5,"Inbound","Main"]
["2026-04-20T09:02:37",1003,"Keyboard (Mechanical)",4,"Inbound","Main"]
["2026-04-20T09:02:37",1008,"Barcode Labels Roll",1,"Inbound","Main"]
["2026-04-20T09:02:37",1006,"Pen Blue (Pack of 10)",2,"Inbound","Main"]
["2026-04-20T09:02:37",1007,"Packing Box Medium",1,"Inbound","Main"]
["2026-04-20T09:02:37",1009,"Cleaning Spray 500ml",4,"Inbound","Main"]
["2026-04-20T09:03:23",1009,"Cleaning Spray 500ml",1,"Inbound","Main"]
["2026-04-20T09:04:37",1002,"Wireless Mouse",7,"Count","Front"]
["2026-04-20T09:04:37",1002,"Wireless Mouse",-20,"Count","Main"]
["2026-04-20T09:15:29",1001,"USB Cable 1m",1,"Inbound","Main"]
["2026-04-20T09:22:37",1001,"USB Cable 1m",1,"Inbound","Main"]
["2026-04-20T09:23:23",1001,"USB Cable 1m",1,"Inbound","Main"]
["2026-04-20T09:27:49",1009,"Cleaning Spray 500ml",1,"Inbound","Main"]