{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["MassTracker","Dashboard","Details","Analysis","Data"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":7,"comments":0,"pivot_tables":2},"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":"MassTracker","index":0,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[6,2,17,7],[20,2,20,7]]}
["MassTracker"]
["Paste UPS tracking numbers below - one per row. It auto-tracks a couple seconds after you paste; results appear on the Dashboard."]
[]
["Tracking #"]
[]
[]
[null,null,"How it works\n1.  Paste UPS tracking numbers in column A (one per row).\n2.  It tracks automatically a couple seconds after you paste, or click MASS TRACK.\n3.  Summary on the Dashboard, expandable scan history on Details, drill-down on Analysis.\n4.  Click CLEAR to start a new batch.\n\nIMPORTANT - first time only (Windows blocks macros in downloaded files):\n-  Close Excel.  In File Explorer, right-click MassTracker.xlsm, then Properties.\n-  Tick \"Unblock\" at the bottom of the General tab, then OK.\n-  Reopen the file and click \"Enable Content\" on the yellow security bar."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"MassTracker v1.0    -    Built by Christophe Mbomnda.  Not affiliated with United Parcel Service."]

{"sheet":"Dashboard","index":1,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,9],[1,0,1,9],[7,0,7,9]]}
["DASHBOARD"]
[{"$f":"\"Tracked \"&MAX(0,COUNTA($A$11:$A$10001))&\" packages.   Paste numbers on the MassTracker tab - it tracks automatically. Filter or sort the list below.\"","v":"Tracked 0 packages.   Paste numbers on the MassTracker tab - it tracks automatically. Filter or sort the list below."}]
[]
[{"$f":"COUNTA(tTrack[Tracking '#])","v":0},{"$f":"COUNTIF(tTrack[Sched today],\"Yes\")","v":0},{"$f":"COUNTIF(tTrack[Status],\"Delivered\")","v":0},{"$f":"COUNTIF(tTrack[Status],\"Out for Delivery\")","v":0},{"$f":"COUNTIF(tTrack[LOC],\"Yes\")","v":0},{"$f":"COUNTIF(tTrack[Status],\"Exception\")","v":0},{"$f":"COUNTIF(tTrack[Status],\"In Transit\")+COUNTIF(tTrack[Status],\"Label Created\")","v":0},{"$f":"COUNTIF(tTrack[Status],\"Not Found\")","v":0}]
["TOTAL","SCHEDULED TODAY","DELIVERED","OUT FOR DELIVERY","LOADED ON CAR","EXCEPTION","IN TRANSIT","NOT FOUND"]
[null,{"$f":"\"of \"&COUNTA(tTrack[Tracking '#])","v":"of 0"},{"$f":"COUNTIFS(tTrack[Status],\"Delivered\",tTrack[Sched today],\"Yes\")&\" today\"","v":"0 today"},{"$f":"COUNTIFS(tTrack[Status],\"Out for Delivery\",tTrack[Sched today],\"Yes\")&\" today\"","v":"0 today"},{"$f":"COUNTIFS(tTrack[LOC],\"Yes\",tTrack[Sched today],\"Yes\")&\" today\"","v":"0 today"},{"$f":"COUNTIFS(tTrack[Status],\"Exception\",tTrack[Sched today],\"Yes\")&\" today\"","v":"0 today"},null,{"$f":"COUNTIFS(tTrack[Status],\"Not Found\",tTrack[Sched today],\"Yes\")&\" today\"","v":"0 today"}]
[]
["PACKAGES      (LOC = Loaded on Car, from the scan history.  Filter any column; click a header to sort)"]
["Tracking #","Status","Latest Activity","Last Scan","Location","Scheduled","Delivered","Service","Sched today","LOC"]

{"sheet":"Details","index":2,"n_rows":4,"n_cols":6,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5]]}
["TRACKING DETAILS  -  SCAN EVENTS"]
["Each package with its full scan history. Click the + at the far left of a package row to expand its scan events - the \"Loaded on Delivery Vehicle\" scan lives here (usually not the latest status)."]
[]
["Lvl","Tracking # / scan","Date","Time","Activity","Location"]

{"sheet":"Analysis","index":3,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,0,11],[1,0,1,11]]}
["ANALYSIS  -  DRILL DOWN"]
["Slice by Status, Service or Scheduled-today; double-click any count to see the underlying packages."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Row Labels","Packages","% of total",null,"Row Labels","Packages"]
[null,"(blank)",null,null,null,"(blank)"]
[null,"Grand Total",null,null,null,"Grand Total"]

{"sheet":"Data","index":4,"n_rows":1,"n_cols":11,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Kind","Tracking","V1","V2","V3","V4","V5","V6","V7","V8","V9"]