Excel printing problem

GAMS
1

Dear all users,

I am using GAMS to solve an optimisation problem and I am printing the results to an excel sheet. I wold ask you if there is a way to print in excel all the entries of a variable included the zero entries.

Thanks in advance. Best regards,
Luca

2

Hi Luca

The trick is to add the Gams value EPS (a very small number) to your parameter:
myparameter(s) = X.L(s) + EPS;
and then use the GDXXRW option EPSOUT = 0 to change the EPS into 0 when you export them to Excel.

You can find the solution here: https://support.gams.com/gams:export_all_elements_of_parameter_including_zeros_from_gams_into_excel.

Cheers
Renger

3

Thanks very much. Now it works.
Best regards,
Luca

4

Just a small clarification:
EPS is not a small value, as I was informed by GAMS. EPS is a stored zero value.
Furthermore: If the dollar control option onEPS is active, zeros in a parameter or table statement are treated as EPS
Cheers
Renger