{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Setup","Dashboard","Final Check","Drivers","SPSF Misloads","Left on Car","Audit List","NotFound","Misloads","DeliveryExceptions","Obarcode","7-Series","PM Car Audit","Check-In Audit","Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":22,"comments":5,"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":"Setup","index":0,"n_rows":32,"n_cols":2,"rows_kept":32,"cut":false,"hidden":false,"merged":[[25,1,25,6],[26,1,26,6],[27,1,27,6],[28,1,28,6],[31,1,31,6],[16,1,16,6],[17,1,17,6],[19,1,19,6],[20,1,20,6],[21,1,21,6],[22,1,22,6],[0,1,0,6],[1,1,1,6],[3,1,3,6],[13,1,13,6],[14,1,14,6],[15,1,15,6]]}
[null,"RouteBench  -  EOD REPORT"]
[null,"Quick start - just follow the 4 steps below."]
[]
[1,"STEP 1   -   Tell us who you are  (type in the highlighted boxes)"]
[]
[null,"Supervisor name"]
[null,"Employee ID"]
[null,"Title / Position"]
[null,"Center  (e.g. Westerville)"]
[null,"SLIC"]
[null,"Email"]
[null,"Phone"]
[]
[2,"STEP 2   -   Paste your reports  (no clean-up needed)"]
[null,"•  Click a tab at the BOTTOM of the window: NotFound, Misloads or DeliveryExceptions."]
[null,"•  Click cell A1, then paste with Ctrl+V. NotFound & Misloads accept the WHOLE export (headers and all) OR just a column of tracking numbers - whatever you have."]
[null,"•  Put O-barcode numbers on the Obarcode tab and 7-series numbers on the 7-Series tab (one per line)."]
[null,"•  You only need at least ONE tab filled in. Use whatever you have."]
[]
[3,"STEP 3   -   Build the report"]
[null,"Macro version (.xlsm): click the green  BUILD EOD REPORT  button below."]
[null,"Standard version (.xlsx): click  Data  on the top menu, then  Refresh All  (if a detail tab is still blank, click Refresh All once more)."]
[null,"(First time only: after downloading, right-click RouteBench.xlsm -> Properties -> tick Unblock -> OK. Then open it, click Enable Content on the yellow bar, and if asked about data privacy choose Public / Ignore.)"]
[]
[]
[4,"STEP 4   -   View results"]
[null,"•  Open the Dashboard for your recap (PM) text, the KPI summary and the No-Scan forecast."]
[null,"•  Open the Drivers, SPSF, Left on Car and Audit List tabs - every column sorts and filters, and each has a slicer to drill in."]
[null,"•  Open PM Car Audit and Check-In Audit, pick a driver from the dropdown, and print."]
[]
[]
[null,"RouteBench v1.0    -    Built by Christophe Mbomnda.  Not affiliated with United Parcel Service."]

{"sheet":"Dashboard","index":1,"n_rows":41,"n_cols":6,"rows_kept":41,"cut":false,"hidden":false,"merged":[[31,0,31,7],[33,0,33,7],[34,0,34,7],[36,0,36,7],[20,0,20,7],[21,0,21,7],[22,0,22,7],[23,0,23,7],[24,0,24,7],[26,0,26,7],[14,0,14,7],[15,0,15,7],[16,0,16,7],[17,0,17,7],[18,0,18,7],[19,0,19,7],[0,0,0,7],[1,0,1,7],[10,0,10,7],[11,0,11,7],[12,0,12,7],[13,0,13,7]]}
["RouteBench  -  EOD REPORT"]
[{"$f":"IF(supName=\"\",\"Fill in the Setup tab, paste your reports, then click BUILD.\",\"Center: \"&IF(center=\"\",\"-\",center)&\"      Supervisor: \"&supName&\"      \"&TEXT(TODAY(),\"yyyy-mm-dd\"))","v":"Fill in the Setup tab, paste your reports, then click BUILD."}]
[]
[{"$f":"IFERROR(INDEX(Data!$E:$E,MATCH(\"TILE#lates\",Data!$C:$C,0))+0,0)","v":0},{"$f":"IFERROR(INDEX(Data!$E:$E,MATCH(\"TILE#missed\",Data!$C:$C,0))+0,0)","v":0},{"$f":"IFERROR(INDEX(Data!$E:$E,MATCH(\"TILE#closed\",Data!$C:$C,0))+0,0)","v":0},{"$f":"IFERROR(INDEX(Data!$E:$E,MATCH(\"TILE#notFound\",Data!$C:$C,0))+0,0)","v":0},{"$f":"IFERROR(INDEX(Data!$E:$E,MATCH(\"TILE#ofd\",Data!$C:$C,0))+0,0)","v":0},{"$f":"IFERROR(INDEX(Data!$E:$E,MATCH(\"TILE#loc\",Data!$C:$C,0))+0,0)","v":0}]
["LATES","MISSED","CLOSED","NOT FOUND","OFD","LOC"]
[]
[{"$f":"IFERROR(INDEX(Data!$E:$E,MATCH(\"TILE#nfExc\",Data!$C:$C,0))+0,0)","v":0},{"$f":"IFERROR(INDEX(Data!$E:$E,MATCH(\"TILE#misloads\",Data!$C:$C,0))+0,0)","v":0},{"$f":"IFERROR(INDEX(Data!$E:$E,MATCH(\"TILE#spsf\",Data!$C:$C,0))+0,0)","v":0},{"$f":"IFERROR(INDEX(Data!$E:$E,MATCH(\"TILE#leftOnVehicle\",Data!$C:$C,0))+0,0)","v":0},{"$f":"IFERROR(INDEX(Data!$E:$E,MATCH(\"TILE#premierDelivered\",Data!$C:$C,0))+0,0)","v":0},{"$f":"IFERROR(INDEX(Data!$E:$E,MATCH(\"TILE#premierFlagged\",Data!$C:$C,0))+0,0)","v":0}]
["NF EXC","MISLOADS","SPSF","LEFT ON CAR","PREMIER OK","PREMIER FLAG"]
[]
[]
["RECAP  /  PM TEXT MESSAGE  (copy and send)"]
[{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"RECAP|1\",Data!$B:$B,0)),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"RECAP|2\",Data!$B:$B,0)),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"RECAP|3\",Data!$B:$B,0)),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"RECAP|4\",Data!$B:$B,0)),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"RECAP|5\",Data!$B:$B,0)),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"RECAP|6\",Data!$B:$B,0)),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"RECAP|7\",Data!$B:$B,0)),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"RECAP|8\",Data!$B:$B,0)),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"RECAP|9\",Data!$B:$B,0)),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"RECAP|10\",Data!$B:$B,0)),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"RECAP|11\",Data!$B:$B,0)),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"RECAP|12\",Data!$B:$B,0)),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"RECAP|13\",Data!$B:$B,0)),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"RECAP|14\",Data!$B:$B,0)),\"\")","v":""}]
[]
["NO-SCAN FORECAST   (goal: 1 in 1000 or better)"]
["Delivery volume:",null,null,"Pending volume (optional):"]
["Not-founds, no scan:",{"$f":"IFERROR(INDEX(Data!$E:$E,MATCH(\"TILE#nfNoScan\",Data!$C:$C,0))+0,0)","v":0},null,"Misloads, no scan:",{"$f":"IFERROR(INDEX(Data!$E:$E,MATCH(\"TILE#mlNoScan\",Data!$C:$C,0))+0,0)","v":0}]
["No-scan defects:",{"$f":"B29+E29+IF(E28=\"\",0,E28)","v":0},null,"Missed:",{"$f":"IFERROR(INDEX(Data!$E:$E,MATCH(\"TILE#missed\",Data!$C:$C,0))+0,0)","v":0}]
["No-scan freq (1 in N):",{"$f":"IF(AND(B28>0,B30>0),ROUND(B28/B30,0),\"\")","v":""},null,"Missed freq (1 in N):",{"$f":"IF(AND(B28>0,E30>0),ROUND(B28/E30,0),\"\")","v":""}]
["Enter delivery volume above to see the forecast. Higher N is better; red = under the 1-in-1000 goal. No-scan defects = not-founds + misloads with no delivery/exception scan, plus any pending volume."]
[]
["FINAL CHECK   (fix before you leave)"]
[{"$f":"IF(COUNTIF(Data!$B:$B,\"FINAL|*\")=0,\"Nothing flagged - you are clear to go.\",\"There are \"&COUNTIF(Data!$B:$B,\"FINAL|*\")&\" item(s) to fix. Open the Final Check tab to work them and check each off.\")","v":"Nothing flagged - you are clear to go."}]
[]
["DETAIL & DRILL-DOWN   (sortable tabs - click a column header to sort, use filters / slicers to drill in)"]
["Open:  NOT FOUND by driver  >"]
["Open:  SPSF Misloads  >"]
["Open:  Left on the Vehicle  >"]
["Open:  Check-In Audit Candidates  >"]

{"sheet":"Final Check","index":2,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,7],[1,0,1,7],[13,0,13,3]]}
["FINAL CHECK  -  before you leave"]
["Fix each item, then set Done to Y. Built from your reports: Ground Saver PO-transfer scans, Closed-Holiday audits, misloads with no scan, packages left on the vehicle, drivers with 3+ not-founds loaded on car, premier, and more."]
["Item","Count","Tracking # / drivers","Done?"]
[{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"FINAL|1\",Data!$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$E:$E,MATCH(\"FINAL|1\",Data!$B:$B,0))+0,\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$F:$F,MATCH(\"FINAL|1\",Data!$B:$B,0)),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"FINAL|2\",Data!$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$E:$E,MATCH(\"FINAL|2\",Data!$B:$B,0))+0,\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$F:$F,MATCH(\"FINAL|2\",Data!$B:$B,0)),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"FINAL|3\",Data!$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$E:$E,MATCH(\"FINAL|3\",Data!$B:$B,0))+0,\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$F:$F,MATCH(\"FINAL|3\",Data!$B:$B,0)),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"FINAL|4\",Data!$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$E:$E,MATCH(\"FINAL|4\",Data!$B:$B,0))+0,\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$F:$F,MATCH(\"FINAL|4\",Data!$B:$B,0)),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"FINAL|5\",Data!$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$E:$E,MATCH(\"FINAL|5\",Data!$B:$B,0))+0,\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$F:$F,MATCH(\"FINAL|5\",Data!$B:$B,0)),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"FINAL|6\",Data!$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$E:$E,MATCH(\"FINAL|6\",Data!$B:$B,0))+0,\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$F:$F,MATCH(\"FINAL|6\",Data!$B:$B,0)),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"FINAL|7\",Data!$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$E:$E,MATCH(\"FINAL|7\",Data!$B:$B,0))+0,\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$F:$F,MATCH(\"FINAL|7\",Data!$B:$B,0)),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"FINAL|8\",Data!$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$E:$E,MATCH(\"FINAL|8\",Data!$B:$B,0))+0,\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$F:$F,MATCH(\"FINAL|8\",Data!$B:$B,0)),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"FINAL|9\",Data!$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$E:$E,MATCH(\"FINAL|9\",Data!$B:$B,0))+0,\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$F:$F,MATCH(\"FINAL|9\",Data!$B:$B,0)),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"FINAL|10\",Data!$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$E:$E,MATCH(\"FINAL|10\",Data!$B:$B,0))+0,\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$F:$F,MATCH(\"FINAL|10\",Data!$B:$B,0)),\"\")","v":""}]
["(Blank rows = nothing flagged for that slot. Set Done to Y as you clear each item; a cleared item is struck through.)"]

{"sheet":"Drivers","index":3,"n_rows":3,"n_cols":8,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,0,0,7],[1,0,1,7]]}
["NOT FOUND - BY DRIVER"]
["Click any column header to sort. Use the filter buttons or the Route slicer to drill in. \"Still NF\" = not found and not yet scanned."]
["Driver","Route","Total","OFD","LOC","Exception","Delivered","Still NF"]

{"sheet":"SPSF Misloads","index":4,"n_rows":3,"n_cols":5,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,0,0,7],[1,0,1,7]]}
["SPSF MISLOADS"]
["Misloads found in the car that the driver did not report (SPSF). Sort/filter or use the Route slicer."]
["Driver","Route","Discovery","Tracking #","Status"]

{"sheet":"Left on Car","index":5,"n_rows":3,"n_cols":5,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,0,0,7],[1,0,1,7]]}
["LEFT ON THE VEHICLE"]
["Prior-day attempts still on the car. Count of 3+ is FLAGged - locate the car / do a yard walk. Filter with the Flag slicer."]
["Driver","Route","Count","Flag","Packages (last scan)"]

{"sheet":"Audit List","index":6,"n_rows":3,"n_cols":7,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,0,0,7],[1,0,1,7]]}
["CHECK-IN AUDIT CANDIDATES"]
["Drivers worth a check-in audit, ranked. Sort/filter or use the Route slicer; open PM Car Audit for the form."]
["Driver","Route","Why selected","NF ODSe","NF Located","SA ODSe","# Pkgs"]

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

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

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

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

{"sheet":"7-Series","index":11,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"PM Car Audit","index":12,"n_rows":41,"n_cols":27,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,0,0,4],[29,0,29,2]]}
[{"$f":"IF(center=\"\",\"PM PACKAGE CAR AUDIT\",\"PM PACKAGE CAR AUDIT - \"&center)","v":"PM PACKAGE CAR AUDIT"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"CAND|1\",Data!$B:$B,0)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"CAND|2\",Data!$B:$B,0)),\"\")","v":""}]
["DRIVER:",null,null,"% EFFECTIVE:",{"$f":"IFERROR(ROUND(COUNTIF($C$9:$C$28,\"Y\")/(COUNTIF($C$9:$C$28,\"Y\")+COUNTIF($C$9:$C$28,\"N\")),2),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"CAND|3\",Data!$B:$B,0)),\"\")","v":""}]
["VEHICLE #:",null,null,"ROUTE:",{"$f":"IFERROR(INDEX(Data!$E:$E,MATCH(\"CAND#\"&$B$3,Data!$C:$C,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"CAND|4\",Data!$B:$B,0)),\"\")","v":""}]
["DATE:",{"$f":"TODAY()","v":"2026-07-14"},null,"PENDING:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"CAND|5\",Data!$B:$B,0)),\"\")","v":""}]
["AUDITOR:",{"$f":"IF(supName=\"\",\"\",supName)","v":""},null,"# SEND AGAINS:",{"$f":"IFERROR(INDEX(Data!$J:$J,MATCH(\"CAND#\"&$B$3,Data!$C:$C,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"CAND|6\",Data!$B:$B,0)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"CAND|7\",Data!$B:$B,0)),\"\")","v":""}]
["SECTION","ITEM","Y/N","NOTES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"CAND|8\",Data!$B:$B,0)),\"\")","v":""}]
["CAB","Updated Insurance Card",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"CAND|9\",Data!$B:$B,0)),\"\")","v":""}]
[null,"LP / SPB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"CAND|10\",Data!$B:$B,0)),\"\")","v":""}]
[null,"Current Registration",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"CAND|11\",Data!$B:$B,0)),\"\")","v":""}]
[null,"Emergency Response Book",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"CAND|12\",Data!$B:$B,0)),\"\")","v":""}]
[null,"Cab Clean",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"CAND|13\",Data!$B:$B,0)),\"\")","v":""}]
["HAZMAT","Applicable",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"CAND|14\",Data!$B:$B,0)),\"\")","v":""}]
[null,"Loaded Properly",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"CAND|15\",Data!$B:$B,0)),\"\")","v":""}]
[null,"Placed in Designated Area",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"CAND|16\",Data!$B:$B,0)),\"\")","v":""}]
[null,"Pulled Off Car",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"CAND|17\",Data!$B:$B,0)),\"\")","v":""}]
[null,"Hazmat Papers Pulled",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"CAND|18\",Data!$B:$B,0)),\"\")","v":""}]
["LOAD QUALITY","NDA / Intl / High Value Pulled",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"CAND|19\",Data!$B:$B,0)),\"\")","v":""}]
[null,"Clerk Pkgs Pulled",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"CAND|20\",Data!$B:$B,0)),\"\")","v":""}]
[null,"Send Agains in Proper Area"]
[null,"PHS Properly Loaded"]
[null,"Service Cross Complete & Legible"]
["APPEARANCE","Uniform (complete, neat, clean)"]
[null,"Undergarments (white/brown/black)"]
[null,"Shoes (leather upper, socks)"]
[null,"Hair"]
[null,"Other"]
[]
["IVP TRACKING (send-agains / flagged packages)"]
["LAST 4","ADDRESS","IVP TRACKING"]
[{"$f":"IFERROR(INDEX(Data!$F:$F,MATCH(\"PKG#\"&$B$3&\"|1\",Data!$C:$C,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$J:$J,MATCH(\"PKG#\"&$B$3&\"|1\",Data!$C:$C,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$I:$I,MATCH(\"PKG#\"&$B$3&\"|1\",Data!$C:$C,0)),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Data!$F:$F,MATCH(\"PKG#\"&$B$3&\"|2\",Data!$C:$C,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$J:$J,MATCH(\"PKG#\"&$B$3&\"|2\",Data!$C:$C,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$I:$I,MATCH(\"PKG#\"&$B$3&\"|2\",Data!$C:$C,0)),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Data!$F:$F,MATCH(\"PKG#\"&$B$3&\"|3\",Data!$C:$C,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$J:$J,MATCH(\"PKG#\"&$B$3&\"|3\",Data!$C:$C,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$I:$I,MATCH(\"PKG#\"&$B$3&\"|3\",Data!$C:$C,0)),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Data!$F:$F,MATCH(\"PKG#\"&$B$3&\"|4\",Data!$C:$C,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$J:$J,MATCH(\"PKG#\"&$B$3&\"|4\",Data!$C:$C,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$I:$I,MATCH(\"PKG#\"&$B$3&\"|4\",Data!$C:$C,0)),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Data!$F:$F,MATCH(\"PKG#\"&$B$3&\"|5\",Data!$C:$C,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$J:$J,MATCH(\"PKG#\"&$B$3&\"|5\",Data!$C:$C,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$I:$I,MATCH(\"PKG#\"&$B$3&\"|5\",Data!$C:$C,0)),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Data!$F:$F,MATCH(\"PKG#\"&$B$3&\"|6\",Data!$C:$C,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$J:$J,MATCH(\"PKG#\"&$B$3&\"|6\",Data!$C:$C,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$I:$I,MATCH(\"PKG#\"&$B$3&\"|6\",Data!$C:$C,0)),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Data!$F:$F,MATCH(\"PKG#\"&$B$3&\"|7\",Data!$C:$C,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$J:$J,MATCH(\"PKG#\"&$B$3&\"|7\",Data!$C:$C,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$I:$I,MATCH(\"PKG#\"&$B$3&\"|7\",Data!$C:$C,0)),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Data!$F:$F,MATCH(\"PKG#\"&$B$3&\"|8\",Data!$C:$C,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$J:$J,MATCH(\"PKG#\"&$B$3&\"|8\",Data!$C:$C,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$I:$I,MATCH(\"PKG#\"&$B$3&\"|8\",Data!$C:$C,0)),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Data!$F:$F,MATCH(\"PKG#\"&$B$3&\"|9\",Data!$C:$C,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$J:$J,MATCH(\"PKG#\"&$B$3&\"|9\",Data!$C:$C,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$I:$I,MATCH(\"PKG#\"&$B$3&\"|9\",Data!$C:$C,0)),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Data!$F:$F,MATCH(\"PKG#\"&$B$3&\"|10\",Data!$C:$C,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$J:$J,MATCH(\"PKG#\"&$B$3&\"|10\",Data!$C:$C,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$I:$I,MATCH(\"PKG#\"&$B$3&\"|10\",Data!$C:$C,0)),\"\")","v":""}]

{"sheet":"Check-In Audit","index":13,"n_rows":30,"n_cols":4,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,3],[7,0,7,1],[8,0,8,1],[10,0,10,3],[15,0,15,3]]}
[{"$f":"IF(center=\"\",\"Check In Audit\",center&\" Check In Audit\")","v":"Check In Audit"}]
["In Vehicle Audit"]
[]
["Driver:",{"$f":"'PM Car Audit'!$B$3","v":0},"(set on the PM Car Audit tab)",{"$f":"IFERROR(\"Route \"&INDEX(Data!$E:$E,MATCH(\"CAND#\"&$B$4,Data!$C:$C,0)),\"\")","v":""}]
["Vehicle #:",null,null,{"$f":"TEXT(TODAY(),\"yyyy-mm-dd\")","v":"2026-07-14"}]
[]
["Item",null,"Y","N"]
["Have all Haz Mat coupons been removed from the pouch?"]
["Has all trash been removed from inside the cab and cargo area?"]
[]
["SERVICE"]
["Total Not Found in ODSe:",{"$f":"IFERROR(INDEX(Data!$G:$G,MATCH(\"CAND#\"&$B$4,Data!$C:$C,0)),\"\")","v":""},"Total Not Founds Located:",{"$f":"IFERROR(INDEX(Data!$H:$H,MATCH(\"CAND#\"&$B$4,Data!$C:$C,0)),\"\")","v":""}]
["Total Pending in ODSe:",null,"Total Pending Located:"]
["Total Send Agains in ODSe:",{"$f":"IFERROR(INDEX(Data!$I:$I,MATCH(\"CAND#\"&$B$4,Data!$C:$C,0)),\"\")","v":""},"Total Send Agains by Count:"]
[]
["At random, select five to ten send agains, record the necessary information below."]
["#","Address","1Z (Last 4)","Service Cross (D I R T)"]
[1,{"$f":"IFERROR(INDEX(Data!$J:$J,MATCH(\"PKG#\"&$B$4&\"|1\",Data!$C:$C,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$F:$F,MATCH(\"PKG#\"&$B$4&\"|1\",Data!$C:$C,0)),\"\")","v":""}]
[2,{"$f":"IFERROR(INDEX(Data!$J:$J,MATCH(\"PKG#\"&$B$4&\"|2\",Data!$C:$C,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$F:$F,MATCH(\"PKG#\"&$B$4&\"|2\",Data!$C:$C,0)),\"\")","v":""}]
[3,{"$f":"IFERROR(INDEX(Data!$J:$J,MATCH(\"PKG#\"&$B$4&\"|3\",Data!$C:$C,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$F:$F,MATCH(\"PKG#\"&$B$4&\"|3\",Data!$C:$C,0)),\"\")","v":""}]
[4,{"$f":"IFERROR(INDEX(Data!$J:$J,MATCH(\"PKG#\"&$B$4&\"|4\",Data!$C:$C,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$F:$F,MATCH(\"PKG#\"&$B$4&\"|4\",Data!$C:$C,0)),\"\")","v":""}]
[5,{"$f":"IFERROR(INDEX(Data!$J:$J,MATCH(\"PKG#\"&$B$4&\"|5\",Data!$C:$C,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$F:$F,MATCH(\"PKG#\"&$B$4&\"|5\",Data!$C:$C,0)),\"\")","v":""}]
[6,{"$f":"IFERROR(INDEX(Data!$J:$J,MATCH(\"PKG#\"&$B$4&\"|6\",Data!$C:$C,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$F:$F,MATCH(\"PKG#\"&$B$4&\"|6\",Data!$C:$C,0)),\"\")","v":""}]
[7,{"$f":"IFERROR(INDEX(Data!$J:$J,MATCH(\"PKG#\"&$B$4&\"|7\",Data!$C:$C,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$F:$F,MATCH(\"PKG#\"&$B$4&\"|7\",Data!$C:$C,0)),\"\")","v":""}]
[8,{"$f":"IFERROR(INDEX(Data!$J:$J,MATCH(\"PKG#\"&$B$4&\"|8\",Data!$C:$C,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$F:$F,MATCH(\"PKG#\"&$B$4&\"|8\",Data!$C:$C,0)),\"\")","v":""}]
[9,{"$f":"IFERROR(INDEX(Data!$J:$J,MATCH(\"PKG#\"&$B$4&\"|9\",Data!$C:$C,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$F:$F,MATCH(\"PKG#\"&$B$4&\"|9\",Data!$C:$C,0)),\"\")","v":""}]
[10,{"$f":"IFERROR(INDEX(Data!$J:$J,MATCH(\"PKG#\"&$B$4&\"|10\",Data!$C:$C,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$F:$F,MATCH(\"PKG#\"&$B$4&\"|10\",Data!$C:$C,0)),\"\")","v":""}]
[]
["Completed By:",{"$f":"IF(supName=\"\",\"\",supName)","v":""},"Date:",{"$f":"TEXT(TODAY(),\"yyyy-mm-dd\")","v":"2026-07-14"}]
["Comments:"]

{"sheet":"Data","index":14,"n_rows":20,"n_cols":14,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
["Sec","RowKey","NameKey","V1","V2","V3","V4","V5","V6","V7","V8",null,null,{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"CAND|1\",Data!$B:$B,0)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"CAND|2\",Data!$B:$B,0)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"CAND|3\",Data!$B:$B,0)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"CAND|4\",Data!$B:$B,0)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"CAND|5\",Data!$B:$B,0)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"CAND|6\",Data!$B:$B,0)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"CAND|7\",Data!$B:$B,0)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"CAND|8\",Data!$B:$B,0)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"CAND|9\",Data!$B:$B,0)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"CAND|10\",Data!$B:$B,0)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"CAND|11\",Data!$B:$B,0)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"CAND|12\",Data!$B:$B,0)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"CAND|13\",Data!$B:$B,0)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"CAND|14\",Data!$B:$B,0)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"CAND|15\",Data!$B:$B,0)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"CAND|16\",Data!$B:$B,0)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"CAND|17\",Data!$B:$B,0)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"CAND|18\",Data!$B:$B,0)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"CAND|19\",Data!$B:$B,0)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Data!$D:$D,MATCH(\"CAND|20\",Data!$B:$B,0)),\"\")","v":""}]