Decimal point in parameters called from Excel

GAMS
1

Hi Everyone,

I have called certain parameters from Excel to GAMS.

My question is up to how many digits after decimal point GAMS consider?
For me, parameters in Excel has values up to 6 digits after the decimal point, however, GAMS has taken only up to 3 digits (at least it is showing that in .lst file).

What should I do to make GAMS consider all digits after the decimal point?

2

GAMS takes them all. The option command (see https://www.gams.com/latest/docs/UG_OptionStatement.html#UG_OptionStatement_DisplayControl) allows you to specify how many decimals the display statement will show in the listing file. Also with Excel you might have more than 6 decimals (there is the format cells business). GAMS will take the true (double) value of the cell not what Excel shows.

-Michael

3

Dear Bussieck,

Thanks for your reply.