WIP MATCHING
Upload the Base WIP workbook first and the SKY / source workbook second. Review the first 7 rows, correct headers if needed, save the header map, run the same CUT + style/vendor/color + quantity allocation logic used in the Colab workflow, sort up to four levels, then download one clean result sheet using the Excel 1 columns you kept in HEAD(7): selected Excel 1 columns, exactly one blank column, then Excel 2 values mapped into those same selected headers.
Base WIP
This workbook defines the form and left-side data.
SKY / Source
This workbook is matched into the Base form.
Header review · HEAD(7)
The detected header row is editable. Matched headers use the same pastel color. Default pairing follows the uploaded Colab logic; making two headers identical also pairs them.
Matching rules
Build reusable comparison rules by choosing a data type, two headers, and any combination of cleanup options. The selected options are all applied before comparison.
Run WIP Matching
Matching key order: CUT → STYLE + VENDOR → STYLE + COMPANY. Within a matched group, QTY/COLOR + IH Q'TY align Source COLOR/RECEIVED rows. Default pairs: IHD → first IN-HOUSE date, FOB → COST, ACTUAL Q'TY → RECEIVED, IH Q'TY → color + RECEIVED. Vendor/company containment and formatting-only differences are ignored. Color comparison also handles operational aliases/notes such as RUST≈WINE≈BURGUNDY, V BROWN≈BROWN, and LT≈LIGHT while preserving original display values. If Source includes SHIP BY, Base INHOUSE automatically compares BOAT/AIR against it; without SHIP BY, INHOUSE defaults to NA rather than comparing against a date. Source rows are not reused.
Result preview
The downloaded comparison uses only the Excel 1 columns currently kept in HEAD(7), followed by exactly one blank column and the same headers populated from Excel 2. Mapped values that match are black text. Only mapped cells that actually differ are yellow with red text.