Search found 7 matches
Search found 7 matches • Page 1 of 1
- 8 months ago
- Forum: Modeling
- Topic: Index control with change of variable in MIP programming
- Replies: 0
- Views: 1093
I have a difficulties with assigning the adequate index. I want that index t starts to increment when variable u(i, t) changes state from 0 to 1 for variable i. $title Service restoration using MIP $oneolcom set t ,i, r, t_total; parameter cons(i), clpu(t,i), p(r), s, h; $if not set gdxin $set gdxin...
Thank you Fred, this really helped. It is now much more clear how to transfer data from excel. I use time to calculate h, so that I know from which row I should read data for customers. However, it is only partially solving my problem. I still don't know how to use this data :( . I have problem with...
- 11 months ago
- Forum: Tools
- Topic: Excel - reading different data from same file
- Replies: 2
- Views: 1110
Hi, I have one excel file with data that should be loaded in different variables, one scalar and one table. The only way I succeeded in reading them is by creating two .xls files with different names, and load data in different .gdx files. This is not so elegant solution so I wanted to ask whether t...
Hi, I have difficulties in reading data that I need from .gdx file. I have succeeded in loading file from Excel, but I get an error when I try to access index that I need: Sets t time intervals / t1*t12 / [b] !! set definition[/b] i customers / c1*c5 / r row labels /r1*r97/ c column labels /c1,c2,c3...