Units become comparable
Euros and cents, millimetres and centimetres are reconciled. Missing data, duplicates and ambiguous prices are flagged, without inventing facts.
This fictional exercise brings together thirty references from two different files. Prices and quantities illustrate the work; they do not represent a real offer.
| Reference | Colour | cm | Fictional price | Fictional quantity |
|---|---|---|---|---|
| OR-01 | Sand | 15 × 22 | 14.00 € | 11 |
| OR-02 | Plum | 18 × 26 | 16.00 € | 12 |
| OR-03 | Night | 12 × 18 | 12.00 € | 13 |
| OR-04 | Sand | 15 × 22 | 14.00 € | 14 |
| OR-05 | Plum | 18 × 26 | 16.00 € | 15 |
| OR-06 | Night | 12 × 18 | 12.00 € | 16 |
| Reference | Colour | cm | Fictional price | Fictional quantity |
|---|---|---|---|---|
| OR-07 | Sand | 15 × 22 | 14.00 € | 17 |
| OR-08 | Plum | 18 × 26 | 16.00 € | 18 |
| OR-09 | Night | 12 × 18 | 12.00 € | 19 |
| OR-10 | Sand | 15 × 22 | 14.00 € | 20 |
| OR-11 | Plum | 18 × 26 | 16.00 € | 21 |
| OR-12 | Night | 12 × 18 | 12.00 € | 22 |
| OR-13 | Sand | 15 × 22 | 14.00 € | 23 |
| OR-14 | Plum | 18 × 26 | 16.00 € | 24 |
| OR-15 | Night | 12 × 18 | 12.00 € | 25 |
| OR-16 | Sand | 15 × 22 | 14.00 € | 26 |
| OR-17 | Plum | 18 × 26 | 16.00 € | 27 |
| OR-18 | Night | 12 × 18 | 12.00 € | 28 |
| OR-19 | Sand | 15 × 22 | 14.00 € | 29 |
| OR-20 | Plum | 18 × 26 | 16.00 € | 30 |
| OR-21 | Night | 12 × 18 | 12.00 € | 31 |
| OR-22 | Sand | 15 × 22 | 14.00 € | 32 |
| OR-23 | Plum | 18 × 26 | 16.00 € | 33 |
| OR-24 | Night | 12 × 18 | 12.00 € | 34 |
| OR-25 | Sand | 15 × 22 | 14.00 € | 35 |
| OR-26 | Plum | 18 × 26 | 16.00 € | 36 |
| OR-27 | Night | 12 × 18 | 12.00 € | 37 |
| OR-28 | Sand | 15 × 22 | 14.00 € | 38 |
| OR-29 | Plum | 18 × 26 | 16.00 € | 39 |
| OR-30 | Night | 12 × 18 | 12.00 € | 40 |
Euros and cents, millimetres and centimetres are reconciled. Missing data, duplicates and ambiguous prices are flagged, without inventing facts.
This presentation shows how the information is organised. It is not connected to a shop and does not update stock. Any import into your tools would require a trial and your approval before implementation.
The sources and checks from the exercise are available below. They do not demonstrate an installation for a client.
Describe your situation. Jérémie replies in writing; you decide after receiving a proposal.
Tell us about your project ↗Free first conversation, in writing and without commitment.