Hello I’m having problem in running my code. I’m using data from the excel sheet and having errors. please help I’ve been stuck on this for two weeks now.
$call gdxxrw.exe i=Messer_data_MP.xlsx output=Calendar.gdx set=t rng=Calendar!A11:A754 rdim=1 set=scn rng=Calendar!B759:CV760 cdim=1 par=ECONCOST rng=Calendar!A761:CV1000 rdim=1 cdim=0 trace=3
set
scn /199/
t()
;
parameter
ECONCOST(t,scn)
;
variable
Profit(scn)
;
equations
OF
Profit_eq
;
Profit_eq… loop(scn, Profit(scn)=E=ECONCOST(t,scn)) display Profit(scn)$(Profit(scn)=g=Profit(scn-1) or display Profit(scn-1)
OF… OF=E=Profit(scn)*2
;
Now, i actually have two queries.
- I’m getting errors 495(Load Dimensions are different) and 141 (symbol declared but no values have been assigned) and many other errors after that but these first two errors i think may have been causing others.
- here ECONCOST parameter is a 2-D matrix of size (168 = t,99 = scn). I want to run the program in such a way that the profit is calculated for 99 times that is for each column but only the greatest value of the profit associated with the particular column is saved and displayed. Eg. like program can not jump from one scn column to another scn column for any value of row ‘t’
scn 1 2 3 4 …
t 1 a e i m
2 b f j n
3 c g k o
4 d h l p
.
.
.
so i want to first calculate the profit for scn 1 ( i.e for a b c d as value of t) and then calculate it for scn 2 (i.e for e f g h as value of t) compare the profit for scn1 and scn 2. keep the greater value and again run it for scn 3 and repeat the process.
how do i do this?