### commercial diameter - declare

Posted:

**Tue Aug 13, 2019 8:32 pm**Hi,

I have a problem where I have to calculate the diameter of a pipe, using the equations I will find the diameter value that is a decimal number.

But the diameter I will use is the commercial value, always selecting the next commercial size of the value found by the equations.

Then I must analyze the cost of these pipes as a function of the diameter and the length of the mesh.

d (mm) preço($/m)

100 7,5

150 10,25

...

I don't know how to enter this information.

If I must use the dollar, table, scalar, equation or upper and lower limit condition.

which of these methods is the best practice to use in GAMS because I would use (VLOOKUP, ..., IF...) table between intervals in EXCEL.

I have a problem where I have to calculate the diameter of a pipe, using the equations I will find the diameter value that is a decimal number.

But the diameter I will use is the commercial value, always selecting the next commercial size of the value found by the equations.

Then I must analyze the cost of these pipes as a function of the diameter and the length of the mesh.

d (mm) preço($/m)

100 7,5

150 10,25

...

I don't know how to enter this information.

If I must use the dollar, table, scalar, equation or upper and lower limit condition.

which of these methods is the best practice to use in GAMS because I would use (VLOOKUP, ..., IF...) table between intervals in EXCEL.