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.