Page 1 of 1

Decimal point in parameters called from Excel

Posted: Sun Oct 31, 2021 7:59 am
by Abhi140
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?

Re: Decimal point in parameters called from Excel

Posted: Mon Nov 01, 2021 12:15 pm
by bussieck
GAMS takes them all. The option command (see https://www.gams.com/latest/docs/UG_Opt ... layControl) 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

Re: Decimal point in parameters called from Excel

Posted: Tue Nov 02, 2021 4:28 am
by Abhi140
Dear Bussieck,

Thanks for your reply.