All Case StudiesSales tool

Dispenser configurator

Configuring a custom machine shouldn't take hours.

Each machine can be built from several modules and slot sizes, each combination carrying its own technical constraints.

Try the tool — the demo is interactive

Configurateur de distributeurs

Outil réel — catalogue XTWR

1. Vos besoins par type de case

Ajoutez les quantités nécessaires — l'arrondi au palier se fait automatiquement.

H0

Palier ×12

H1

Palier ×12

H2

Palier ×24

H2H

Palier ×12

H3

Palier ×24

H4

Palier ×48

2. Aperçu du distributeur

cases disponibles

3. Résultat

Encodez vos besoins : la meilleure configuration compatible s'affiche instantanément, avec la vue du distributeur.

48 configurations réelles au catalogue

L'outil analyse le catalogue réel en temps réel pour proposer la solution la plus ajustée.

Real tool, built right in: the catalog, photos, and logic all come from the original Excel file.

01

The problem

The salesperson or client knew how many bins of each size they wanted, but not which module combinations were actually compatible. Checking that by hand took time and left room for error.

02

The solution

I built a file where you simply enter the desired number of bins per size: the tool automatically calculates and displays the available, compatible machine configurations.

03

How it works

  • Simple entry of the desired number of bins per size
  • Automatic calculation of compatible module combinations
  • Instant display of available machine configurations
  • Real catalog of 48 XTWR configurations, with a photo of each machine
04

The results

  • Configuration ready in minutes
  • No incompatible combination ever suggested
  • Full autonomy for both the salesperson and the client
05

What this project demonstrates

Advanced ExcelConstraint modelingBusiness tool

Tools: Advanced Excel · Advanced formulas