GAMS World Forum

Hi
It is hard to help you with your question as you don't post any code. Please read the rules of the forum.
Cheers
Renger

Even then you should replace xlexport. But to answer your question, if a parameter has a value of zero, it is not exported. In order to have this zero exported, you should add EPS (The special value EPS is numerically equal to zero, so when used in the context of numerical comparisons, it behaves as...

Hi
If you are a newbie, I would strongly suggest to use the gdxxrw tool instead of xlexport, as gdxxrw has many more features.
Although xlexport is a great tool, it is superseded by gdxxrw (xlexport was developed in 1999 and the actual version is from 2002).
Cheers
Renger

Hi Josh You could write it like this: $setlocal site_number 813715 sets t 'time index' /000001*105120/ ; parameter s(t) 'solar capacity factor at timepoint t (5-min data)' / $ondelim $include /path_to_file/Site_%site_number%_SolarPV_Axis1_SolarPV_Lat_order.csv $offdelim / ; You can then run the gams...

Hi If I understand your question well, you just want to count the number of variables fixed to 1. The following code sums 1 every time the condition that Z is fixed to 1 is met (upperbound and lower bound equal to 1): set i 'samples' /1*10/; set k 'components' /k1*k3/; binary variable z(i,k); z.l(i,...

You shouldn't import all the rows. If you have all the rows, you probably want to summarize them. You should do that using a query and then import the data in an excel table.

Office 365 comes with PowerPivot. If you don't have a current version, you could always import the data in Access (or MySQL, which is free). You can, also in earlier versions of Excel, connect to a database, do queries and import these (so you don't have to import all the data). Once you have import...

Yes, by the limit of excel. Now you should use powerpivot to import the data into excel. Then you will have the possibility to make a pivot table of your data (I haven't used this, but checking powerpivot, I imported the data and produced a pivot table in 2 minutes)
Cheers
Renger

Hi Jarenka I used two separate gams files. If you put it all in one file, you don't need to load test (and if you would do, you should use execute_load as the gdx file is produced in execution time and not available in compile time). Just run: set t /1*15/; alias(t,t2,t3,t4,t5,t6) parameter test(t,t...

Hi Jarenka
On my machine, I tried with 15^6 (> 11 million lines) and it works fine. Produces a CSV file of 450Mb.
Cheers
Renger