We need a lookup table integrated into our site that will 1. Calculate the square footage of a project from the customer's input of width and height, and 2. Return a price for the product. There are several accessory/ finishing options that will also need to be calculated into the price. I will provide the data in an excel spreadsheet, or txt format. A sample is here: [url removed, login to view] and a typical set of lookup tables is attached.
Assume a total of 20 product types, each with it's own price table. For the accessories/ finishing there will be some that are a percentage of the product's price, and others that are a flat cost per unit.
My hosting company is set up for MySQL databases
Please contact me if you have any questions.