Things to notice with this example:
●
This is a simple calculator that uses the standard Excel VLOOKUP function to update the price based on user selections.
●
All the data is stored in hidden rows.
Close
Product Configurator
Please select your desired system configuration from the following options:
Base Price:
$1,000.00
Processor:
P521 2.80 GHz ($0)
P630 3.00 GHz ($45)
P640 3.20 GHz ($70)
P650 3.40 GHz ($120)
D930 3.00 GHz ($80)
D940 3.20 GHz ($115)
Option 7: D950 3.40 GHz ($190)
Memory:
1GB ($0)
2GB ($120)
Display:
17" Dell 1706FPV LCD Flat Panel ($0)
19" Dell 1907FP LCD Flat Panel ($10)
20" Dell 2007FP LCD Flat Panel ($190)
20" Dell 2007FPW Widescreen LCD Flat Panel ($180)
24" Dell 2407FPW Widescreen LCD Flat Panel ($550)
No Display ($-220)
Video:
Integrated Intel GMA950 ($0)
Integrated + DVI Adapter Card ($120)
128MB ATI Radeon X600SE DVI TV out ($145)
256MB ATI Radeon X600 Dual VGA Full Height ($180)
256MB ATI Radeon X600 Dual DVI VGA Full Height ($203)
Hard Drive:
80GB SATA 3.0b/s ($0)
160GB SATA 3.0b/s ($20)
250GB SATA 3.0b/s ($50)
Second Drive:
None ($0)
80GB SATA 3.0b/s ($100)
160GB SATA 3.0b/s ($149)
250GB SATA 3.0b/s ($211)
Removable Media:
24X DVD-CDRW Combo ($0)
48X DVD-CDRW Combo ($29)
8X DVD+/-RW w/Sonic Digital Media ($25)
16X DVD+/-RW ($43)
Floppy: ($10)
Speakers:
None ($0)
Dell A225 ($10)
Dell A525 ($40)
Dell AS501 Sound Bar for UltraSharp ($20)
Total:
Processor:
P521 2.80 GHz ($0)
0.00
P630 3.00 GHz ($45)
45.00
P640 3.20 GHz ($70)
70.00
P650 3.40 GHz ($120)
120.00
D930 3.00 GHz ($80)
80.00
D940 3.20 GHz ($115)
115.00
Option 7: D950 3.40 GHz ($190)
190.00
Memory:
1GB ($0)
0.00
2GB ($120)
120.00
Display:
17" Dell 1706FPV LCD Flat Panel ($0)
0.00
19" Dell 1907FP LCD Flat Panel ($10)
10.00
20" Dell 2007FP LCD Flat Panel ($190)
190.00
20" Dell 2007FPW Widescreen LCD Flat Panel ($180)
180.00
24" Dell 2407FPW Widescreen LCD Flat Panel ($550)
550.00
No Display ($-220)
-220.00
Video:
Integrated Intel GMA950 ($0)
0.00
Integrated + DVI Adapter Card ($120)
120.00
128MB ATI Radeon X600SE DVI TV out ($145)
145.00
256MB ATI Radeon X600 Dual VGA Full Height ($180)
180.00
256MB ATI Radeon X600 Dual DVI VGA Full Height ($203)
203.00
Hard Drive:
80GB SATA 3.0b/s ($0)
0.00
160GB SATA 3.0b/s ($20)
20.00
250GB SATA 3.0b/s ($50)
50.00
Second Hard Drive:
None ($0)
0.00
80GB SATA 3.0b/s ($100)
100.00
160GB SATA 3.0b/s ($149)
149.00
250GB SATA 3.0b/s ($211)
211.00
Removable:
24X DVD-CDRW Combo ($0)
0.00
48X DVD-CDRW Combo ($29)
29.00
8X DVD+/-RW w/Sonic Digital Media ($25)
25.00
16X DVD+/-RW ($43)
43.00
Floppy: ($10)
10.00
Speakers:
None ($0)
0.00
Dell A225 ($10)
10.00
Dell A525 ($40)
40.00
Dell AS501 Sound Bar for UltraSharp ($20)
20.00