Friday dispatch handoff | Native Excel for Mac | November 12, 2026
Inputs: orders.csv and scans.csv from dispatch-handoff.zip. IDs imported as Text; units numeric. Both wizard-imported ranges reproduced the reconciliation.
Orders columns A:F (record followed by Excel formulas C:F):
00127 | 5 | 5 | 2 | 0 | close
=SUMPRODUCT(--EXACT(A2,Scans!$B$2:$B$9),Scans!$C$2:$C$9) | =SUMPRODUCT(--EXACT(A2,Scans!$B$2:$B$9)) | =C2-B2 | =IF(D2=0,"no scan",IF(E2=0,"close",IF(E2<0,"short","over")))
0127 | 4 | 3 | 1 | -1 | short
=SUMPRODUCT(--EXACT(A3,Scans!$B$2:$B$9),Scans!$C$2:$C$9) | =SUMPRODUCT(--EXACT(A3,Scans!$B$2:$B$9)) | =C3-B3 | =IF(D3=0,"no scan",IF(E3=0,"close",IF(E3<0,"short","over")))
00008 | 3 | 5 | 1 | 2 | over
=SUMPRODUCT(--EXACT(A4,Scans!$B$2:$B$9),Scans!$C$2:$C$9) | =SUMPRODUCT(--EXACT(A4,Scans!$B$2:$B$9)) | =C4-B4 | =IF(D4=0,"no scan",IF(E4=0,"close",IF(E4<0,"short","over")))
00810 | 3 | 0 | 0 | -3 | no scan
=SUMPRODUCT(--EXACT(A5,Scans!$B$2:$B$9),Scans!$C$2:$C$9) | =SUMPRODUCT(--EXACT(A5,Scans!$B$2:$B$9)) | =C5-B5 | =IF(D5=0,"no scan",IF(E5=0,"close",IF(E5<0,"short","over")))
00042 | 4 | 4 | 2 | 0 | close
=SUMPRODUCT(--EXACT(A6,Scans!$B$2:$B$9),Scans!$C$2:$C$9) | =SUMPRODUCT(--EXACT(A6,Scans!$B$2:$B$9)) | =C6-B6 | =IF(D6=0,"no scan",IF(E6=0,"close",IF(E6<0,"short","over")))
00077 | 2 | 2 | 1 | 0 | close
=SUMPRODUCT(--EXACT(A7,Scans!$B$2:$B$9),Scans!$C$2:$C$9) | =SUMPRODUCT(--EXACT(A7,Scans!$B$2:$B$9)) | =C7-B7 | =IF(D7=0,"no scan",IF(E7=0,"close",IF(E7<0,"short","over")))
Scans columns A:D (record followed by Excel formula D):
S01 | 00127 | 2 | 1
=SUMPRODUCT(--EXACT(B2,Orders!$A$2:$A$7))
S02 | 0127 | 3 | 1
=SUMPRODUCT(--EXACT(B3,Orders!$A$2:$A$7))
S03 | 00127 | 3 | 1
=SUMPRODUCT(--EXACT(B4,Orders!$A$2:$A$7))
S04 | 00008 | 5 | 1
=SUMPRODUCT(--EXACT(B5,Orders!$A$2:$A$7))
S05 | 00042 | 1 | 1
=SUMPRODUCT(--EXACT(B6,Orders!$A$2:$A$7))
S06 | 00077 | 2 | 1
=SUMPRODUCT(--EXACT(B7,Orders!$A$2:$A$7))
S07 | 00042 | 3 | 1
=SUMPRODUCT(--EXACT(B8,Orders!$A$2:$A$7))
S08 | 00990 | 2 | 0
=SUMPRODUCT(--EXACT(B9,Orders!$A$2:$A$7))
Deliveries: close-list.csv and exceptions.csv were saved by Excel using CSV UTF-8. Their headers and all data fields matched the exercise answer files.
Fresh CSV import: order_id -> Text. 00127 / 5, 00042 / 4, 00077 / 2. IDs read as strings, units as numbers. Total 11.
