Hi everyone

I am exporting results from gdx to excel. The gdx file to be exported

is created by DEA solver and it contains the objective value for each

slice (a column of values). I cannot create the gdx in other way since

DEA solver keeps the value of each run to write it in the gdx. If I

create the gdx at the end, it only keeps the value of the last slice.

My problem is that GDXXRW exports it to excel as a row, not as a

column. It is a problem since the number of columns is limited to 256

columns (but the rows are +65,000) and my dataset is considerebly

bigger (some 36,000).

I have check that if I reduce problem size to 256 slices or less, it

works properly.

Does anyone know any way to tell gdxxrw to write data in the same way

as in gdx (a column) o to force it to do it as a column. Any other

idea? I can not

Thank everybody in advance.

Best regards,

Antonio

\

Antonio,

You can experiment with the cdim/rdim options of GDXXRW. Also you

could store the data coming from DEA through GDX in a GAMS parameter

and write it out at the end.

Michael Bussieck - GAMSWorld Coordinator

On Mar 27, 12:51 pm, Antonio wrote:

Hi everyone

I am exporting results from gdx to excel. The gdx file to be exported

is created by DEA solver and it contains the objective value for each

slice (a column of values). I cannot create the gdx in other way since

DEA solver keeps the value of each run to write it in the gdx. If I

create the gdx at the end, it only keeps the value of the last slice.

My problem is that GDXXRW exports it to excel as a row, not as a

column. It is a problem since the number of columns is limited to 256

columns (but the rows are +65,000) and my dataset is considerebly

bigger (some 36,000).

I have check that if I reduce problem size to 256 slices or less, it

works properly.

Does anyone know any way to tell gdxxrw to write data in the same way

as in gdx (a column) o to force it to do it as a column. Any other

idea? I can not

Thank everybody in advance.

Best regards,

Antonio

\

Thank you for your help.

I have been studying your suggestions on how to deal with gdx to excel

but I guess that I have not get your point:

-Cdim and Rdim, helps to define the dimension of the gams object to

move it from excel to gdx, because departing from excel dimension is

unknown. But, cdim and rdim to go from gdx to excel are redundant

because in gdx dimensions are known, aren’t they? I do not know how to

use cdim/rdim to do it. I have study gdxutils.pdf again and I have not

found any example that uses cdim and rdim to go from gdx to exel. All

examples that uses cdim and rdim are for going from excel to gdx.

-I have try to store the data comming from DEA solver, but as far as

solver control slices generation and solving, if I state an

instruction to store variable values, I only get the values of the

last slice (I do not know if DEA overwrites values or if only wirte

the values after the last slice solving).

Thanks again,

Antonio

\