Price 0 dkr
Model - Auto Weight 0 kg
Engine - Auto Horsepower 0 hp
Delivery time 0 days
Accessories Trims and paint
Automatic gear box - Auto
Trim - Auto
ABS brake - Auto
Trim colour - Auto
Air bag - Auto
Paint - Auto
Air condition - Auto
Audio system - Auto
After delivery accessories
Electric mirrors Auto Burglar alarm - Auto
Trailer hook - Auto
Cruise control - Auto
Tree panel - Auto
Sunroof - Auto
Configuration in Excel
The car configurator illustrates the possibilities of implementing a configuration system in an Excel spreadsheet.
The configurator has been developed with the Excel Configuration Modeller.
Excel Configuration Modeller is a generic tool for implementing a configuration system in an Excel spreadsheet.
A demo version of Excel Configuration Modeller may be obtained by sending an e-mail to the mailaddress
email@example.com with the subject Demo or ZIPdemo.
More information about Excel configuration may be obtained from the website www.teknologisk.dk/39
User guide for car configurator
A car is configured by selecting an option for each of the combo boxes.
If no option is selected, the combo box is marked with a minus-sign.
By default, none of the options are selected.
As options are selected, the consequences on price, weight, horse power, and delivery time
are shown at the top of the Frontpage.
According to the configurations guidelines mentioned below, the selection of
an option in one combo box may exclude the possibilities to select options in other combo boxes.
Options that cannot be selected, i.e. an invalid option, are marked with (brackets).
However, if an invalid option is selected, a message box will describe the conflict.
A conflict may be resolved by selecting a valid option in one or more of the combo boxes with invalid options.
If the selection of an option in a combo box excludes all but one option in another combo box,
this last option will automatically be selected.
A symbol is set to the left of the combo box to illustrate
if the given selection is made by the user and automatically by the system
(e.g. being the only option left in the combo box as described above).
The configuration may be reset at any time by pressing the 'Reset' button on the Frontpage.
A bill of material may be written to the file C:\BOM.txt by pressing the 'Bill of Material' button on the Frontpage.
It is impossible to have both air conditioning and automatic air conditioning.
The turbo cabriolet comes with turbo engine, metallic paint, leather trim and cruise control.
Ordinary cabriolets comes with a 2.1 litters engine.
For ordinary cabriolets the trim cannot be marine.
Models in red, grey or green cannot be ordered with marine trim.
Models in beige or green cannot be ordered with puma trim.
Cars with a turbo engine must be ordered with ABS-brakes.
Sunroof for cabriolets cannot be ordered.
Model 900 cannot be ordered in Monte Carlo yellow.
Data on prices, weights, delivery times, and horsepowers are fictive.
The example of a car is chosen to ease the comparison with other
constraint-based configuration systems, e.g. Invensys CRM (former Baan).
Furthermore, the configurator may be compared with the "Design your car"-configurator
at the homepage of Saab (www.saab.com) .
Danish Technological Institute
Centre for Production
P.O. Box 141
Direct: +45 7220 2923
Fax: +45 7220 2930