Insert binary table from excel file

26 views
Skip to first unread message

Komnas Kotsis

unread,
Apr 23, 2016, 6:03:57 AM4/23/16
to gamsworld
Hello everyone,

I am trying to insert a binary table data in my gams model  using an excel sheet. 

This is what I have written. But I have an error for overlapping row. Does anyone have any idea?

SETS
t                                 #set of time slots
        /1*10/
s                                 #set of different scenaria for DSM activation
        /1*10/


$setglobal path "C:\Users\Desktop\";

*##data for load profile##########
*#################################
$call =xls2gms r=j2:s11 i=%path%case_1.xls o=%path%binar.inc
*                                                        #binary activation input data
TABLE  binar(t,s)               
$include %path%binar.inc

;
Reply all
Reply to author
Forward
0 new messages