Decimal point in parameters called from Excel

Problems with modeling
Post Reply
Abhi140
User
User
Posts: 29
Joined: 3 years ago

Decimal point in parameters called from Excel

Post 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?
User avatar
bussieck
Moderator
Moderator
Posts: 1033
Joined: 7 years ago

Re: Decimal point in parameters called from Excel

Post 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
Abhi140
User
User
Posts: 29
Joined: 3 years ago

Re: Decimal point in parameters called from Excel

Post by Abhi140 »

Dear Bussieck,

Thanks for your reply.
Post Reply