{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Report","GK","Activity","Rep_Act","Data","Usuarios"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":1,"defined_names":6,"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":"Report","index":0,"n_rows":13,"n_cols":9,"rows_kept":13,"cut":false,"hidden":false,"merged":[[12,1,12,3],[12,5,12,6]]}
[null,{"$f":"Usuarios!A2","v":"xfguzman"},null,null,null,null,null,{"$f":"GK!B3","v":"Shipping 1"},{"$f":"Usuarios!D2","v":"2025-02-04"}]
[null,"Disposition","Shipping 1","Shipping 2","Shipping 3","Shipping 4",null,"SOS","Qty"]
[null,"Leaking",{"$f":"COUNTIFS(GK!I3:I200, \"Leaking\",GK!B3:B200,\"Shipping 1\")","v":1},{"$f":"COUNTIFS(GK!I3:I200, \"Leaking\",GK!B3:B200,\"Shipping 2\")","v":0},{"$f":"COUNTIFS(GK!I3:I200, \"Leaking\",GK!B3:B200,\"Shipping 3\")","v":0},{"$f":"COUNTIFS(GK!I3:I200, \"Leaking\",GK!B3:B200,\"Shipping 4\")","v":0},null,"Low",0]
[null,"Broken Set",{"$f":"COUNTIFS(GK!I3:I200, \"Broken Set\",GK!B3:B200,\"Shipping 1\")","v":0},{"$f":"COUNTIFS(GK!I3:I200, \"Broken Set\",GK!B3:B200,\"Shipping 2\")","v":1},{"$f":"COUNTIFS(GK!I3:I200, \"Broken Set\",GK!B3:B200,\"Shipping 3\")","v":0},{"$f":"COUNTIFS(GK!I3:I200, \"Broken Set\",GK!B3:B200,\"Shipping 4\")","v":0},null,"Escalate",0]
[null,"Defective",{"$f":"COUNTIFS(GK!I3:I200, \"Defective\",GK!B3:B200,\"Shipping 1\")","v":0},{"$f":"COUNTIFS(GK!I3:I200, \"Defective\",GK!B3:B200,\"Shipping 2\")","v":0},{"$f":"COUNTIFS(GK!I3:I200, \"Defective\",GK!B3:B200,\"Shipping 3\")","v":1},{"$f":"COUNTIFS(GK!I3:I200, \"Defective\",GK!B3:B200,\"Shipping 4\")","v":0},null,"Hi",0]
[null,"Expired",{"$f":"COUNTIFS(GK!I3:I200, \"Expired\",GK!B3:B200,\"Shipping 1\")","v":0},{"$f":"COUNTIFS(GK!I3:I200, \"Expired\",GK!B3:B200,\"Shipping 2\")","v":0},{"$f":"COUNTIFS(GK!I3:I200, \"Expired\",GK!B3:B200,\"Shipping 3\")","v":0},{"$f":"COUNTIFS(GK!I3:I200, \"Expired\",GK!B3:B200,\"Shipping 4\")","v":2},null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[]
[]
[null,{"$f":"(\"GateKeeper: \"&B1)","v":"GateKeeper: xfguzman"},null,null,"Floor:",{"$f":"Usuarios!F2","v":"1W"},null,"Date:",{"$f":"I1","v":"2025-02-04"}]

{"sheet":"GK","index":1,"n_rows":7,"n_cols":11,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
["Floor","Shipping","Container","Barcode","Problem Solve","GateKeeper","Date","Lane Manager","Disposition","Qty","Nota"]
["1W","Shipping 1",11,12,"PEDRO","xfguzman","2025-04-02","cochachi","Leaking",4]
["1W","Shipping 2",14,5,"PEDRO","xfguzman","2025-04-02","cochachi","Broken Set",5]
["1W","Shipping 3",15,34,"LUIS","xfguzman","2025-04-02","cochachi","Defective",7]
["1W","Shipping 4",15,34,"LUIS","xfguzman","2025-04-03","cochachi","Expired",8]
["1W","Shipping 4",16,"45e","tttt","xfguzman","2025-04-02","cochachi","Expired",5]

{"sheet":"Activity","index":2,"n_rows":1,"n_cols":16,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Estation","Floor","Period","User","Description IN","Qty IN","Status In","Unit","Hour IN","Description OUT","Qty OUT","Status Out","Unit","End","Time","Fecha"]

{"sheet":"Rep_Act","index":3,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
[{"$f":"VLOOKUP(A3,B,4)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A3,B,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A3,B,16)","v":{"$error":"#N/A"}}]
["Estation","Hour In","Hour Out"]
[1348,{"$f":"VLOOKUP(A3,B,9)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A3,B,14)","v":{"$error":"#N/A"}}]
["Period","Status IN","Status Out"]
[{"$f":"VLOOKUP(A3,B,3)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A3,B,7)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A3,B,12)","v":{"$error":"#N/A"}}]

{"sheet":"Data","index":4,"n_rows":40,"n_cols":2,"rows_kept":40,"cut":false,"hidden":true,"merged":[]}
["No","Status"]
[0,"Clean"]
[1,"Low"]
[2,"Low"]
[3,"Low"]
[4,"Low"]
[5,"Low"]
[6,"Escalate"]
[7,"Escalate"]
[8,"Escalate"]
[9,"Escalate"]
[10,"Escalate"]
[11,"Hi"]
[12,"Hi"]
[13,"Hi"]
[14,"Hi"]
[15,"Hi"]
[16,"Hi"]
[17,"Hi"]
[18,"Hi"]
[19,"Hi"]
[20,"Hi"]
[21,"Hi"]
[22,"Hi"]
[23,"Hi"]
[24,"Hi"]
[25,"Hi"]
[26,"Hi"]
[27,"Hi"]
[28,"Hi"]
[29,"Hi"]
[30,"Hi"]
[31,"Hi"]
[32,"Hi"]
[33,"Hi"]
[34,"Hi"]
[35,"Hi"]
[36,"Hi"]
[37,"Hi"]
[38,"Hi"]

{"sheet":"Usuarios","index":5,"n_rows":2,"n_cols":7,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Gate  Keeper","Lane Manager","Status","Date",null,"Floor","Shipping"]
["xfguzman","cochachi","Activo","2025-02-04",null,"1W","Shipping 4"]