Attribute Calculation Formula

[slabadoo]

I have 1700 products. each of these 1700 products will eventually have a different price based on multiple factors.

For the sake of a visual, the product is a blade that is used in machinery to manufacture hand railings and other wood parts, mostly stair parts.

The price of the blade is determined by this equation:

Length of steel + 0.750 x 2 x The Steel type (this value is always different but we will say it is $22 for this calculation)

Here is an example:

If the length of steel is 3 inches then the first part of the calculation would be (3+0.750 = 3.750)
now take (3.750 x 2 which equals 7.5)
then multiply (7.5 and the value of the steel type which in this case we will say the value is $22 and that equals $165.00)

So basically, we were able to produce this calculation in excell but from the looks of it, i don't see how we can produce this calculation in zencart attributes. Is there a way someone can tell me how they would approch this or if there is a calculation feature I am not aware.

Thanks,
Slabadoo

[matteoraggi]

Do youhave a website to understand it better?

[slabadoo]

I may have figured this out. I will indeed share the answer when I am done developing it.

Thanks,
Slabadoo