Trying to get a grid to spit out cost based on dimensions to work between

[cubeyy91]

Hi all,
I work at a glazier and I am trying to create a grid for the office girls to work from to be able to quote people over the phone easily.
We cut glass from standard sheet sizes that we stock so there is a size range to work from and here is an example:

600 x 600	$270
600 x 1000	$290
600 x 1500	$310

<colgroup><col width="206"><col width="65"></colgroup> <tbody>
</tbody>

So, if a customer asks for a bit of glass that would be 500x1200 we know we charge $310. I want them to be able to put sizes in and it just spit the price so there is no confusion.

To make it even better I would love to be able to have a drop down that allows you to choose the glass type which would vary the pricing. This is because 500x1200 in one type could be $310 but if it is lower to the ground it may require stronger glass and it might be $400.

I would be willing to have one setup just for the sizes and just create a different colour box to put dimensions into for the price to be spat out but all in one size section would be great.

I have been searching for hours but to no avail.

Thoughts?

 

[Paul Ked]

Hi and welcome to the Forum.

It would be best if you post a table of standard sizes and types of glass in the kind of format you would like. That way fewer changes to the first answers will need to be made.

Cheers

Paul Ked

 

[cubeyy91]

Hey Paul,

Thanks for taking the time to reply. Here is what I am working with

Ground Level Windows (Lowlite)
5mm Clear Glass
600 x 600	270
600 x 1000	290
600 x 1500	310
Standard Sliding and Fixed Glass Windows
1400 x 600	290
1400 x 1200	330
1400 x 1500	390
Bathroom Windows
Obscure Safety Glass
600 x 600	290
1400 x 600	370
1400 x 1200	490
Toilet Windows
Obscure Glass
600 x 600	290
600 x 1000	370
Door and fixed panel (Clear Glass)
2100 x 900	530
2100 x 1200	650
2300 x 900	770
2300 x 1200	880

<colgroup><col width="206"><col width="65"></colgroup> <tbody>
</tbody>