Help with a cost calculator based on different options.

[Mchgh9]

Hi,

I am trying to compile a calculator based on a set of options selected by the user. I want to use validation to allow a list of 3 choices which then determines what further options are available.

This is the table.

[TABLE="width: 748"]
<TBODY>[TR]
[TD][/TD]
[TD="colspan: 2"]Area 1</SPAN>[/TD]
[TD="colspan: 4"]Area 2</SPAN>[/TD]
[TD="colspan: 2"]Area 3</SPAN>[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]0-2 & TS</SPAN>[/TD]
[TD]3-4 & Non-TS</SPAN>[/TD]
[TD]0-2</SPAN>[/TD]
[TD]3-4 Sometime TS at TS time</SPAN>[/TD]
[TD]3-4 Sometime TS at Non-TS time</SPAN>[/TD]
[TD]3-4 Non TS</SPAN>[/TD]
[TD]SSS Streets</SPAN>[/TD]
[TD]Non-SSS Strets</SPAN>[/TD]
[/TR]
[TR]
[TD]MAJOR PAA</SPAN>[/TD]
[TD="align: right"]£103.00</SPAN>[/TD]
[TD="align: right"]£63.00</SPAN>[/TD]
[TD="align: right"]105</SPAN>[/TD]
[TD="align: right"]105</SPAN>[/TD]
[TD="align: right"]70</SPAN>[/TD]
[TD="align: right"]60</SPAN>[/TD]
[TD="align: right"]105</SPAN>[/TD]
[TD="align: right"]75</SPAN>[/TD]
[/TR]
[TR]
[TD]MAJOR</SPAN>[/TD]
[TD="align: right"]£208.00</SPAN>[/TD]
[TD="align: right"]£108.00</SPAN>[/TD]
[TD="align: right"]240</SPAN>[/TD]
[TD="align: right"]240</SPAN>[/TD]
[TD="align: right"]170</SPAN>[/TD]
[TD="align: right"]110</SPAN>[/TD]
[TD]-</SPAN>[/TD]
[TD]-</SPAN>[/TD]
[/TR]
[TR]
[TD]STANDARD</SPAN>[/TD]
[TD="align: right"]£122.00</SPAN>[/TD]
[TD="align: right"]£63.00</SPAN>[/TD]
[TD="align: right"]130</SPAN>[/TD]
[TD="align: right"]130</SPAN>[/TD]
[TD="align: right"]90</SPAN>[/TD]
[TD="align: right"]40</SPAN>[/TD]
[TD="align: right"]130</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[/TR]
[TR]
[TD]MINOR</SPAN>[/TD]
[TD="align: right"]£61.00</SPAN>[/TD]
[TD="align: right"]£31.00</SPAN>[/TD]
[TD="align: right"]65</SPAN>[/TD]
[TD="align: right"]65</SPAN>[/TD]
[TD="align: right"]45</SPAN>[/TD]
[TD="align: right"]10</SPAN>[/TD]
[TD="align: right"]64</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[/TR]
[TR]
[TD]IMMEDIATE</SPAN>[/TD]
[TD="align: right"]£57.00</SPAN>[/TD]
[TD="align: right"]£28.00</SPAN>[/TD]
[TD="align: right"]60</SPAN>[/TD]
[TD="align: right"]60</SPAN>[/TD]
[TD="align: right"]30</SPAN>[/TD]
[TD="align: right"]10</SPAN>[/TD]
[TD="align: right"]60</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[/TR]
[TR]
[TD]PERMIT VARIATION</SPAN>[/TD]
[TD="align: right"]£45.00</SPAN>[/TD]
[TD="align: right"]£35.00</SPAN>[/TD]
[TD]?</SPAN>[/TD]
[TD]?</SPAN>[/TD]
[TD]?</SPAN>[/TD]
[TD]?</SPAN>[/TD]
[TD="align: right"]45</SPAN>[/TD]
[TD="align: right"]35</SPAN>[/TD]
[/TR]
[TR]
[TD]Mjor PA >10 days</SPAN>[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]240</SPAN>[/TD]
[TD="align: right"]150</SPAN>[/TD]
[/TR]
[TR]
[TD]Major PA 4-10 days</SPAN>[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]130</SPAN>[/TD]
[TD="align: right"]75</SPAN>[/TD]
[/TR]
[TR]
[TD]Major PA <4days</SPAN>[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]65</SPAN>[/TD]
[TD="align: right"]45</SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL><COL><COL><COL><COL><COL><COL span=2><COL></COLGROUP>[/TABLE]

As you can see, area 1 has 12 possible combinations 2x6. Area 2 4 x 5 and then Area 3 has 8x 2 combinations.

Basically, there is the initial question of what area from a dropdown, then whether it is Major, Minor, Standard etc and finally which column out of the possible options does it fall in.

Any help much appreciated.

Thanks

David