Topic
  • 1 reply
  • Latest Post - ‏2012-10-23T11:38:05Z by SystemAdmin
CplexCui
CplexCui
1 Post

Pinned topic multi dimension data input from Microsoft Excel and handling index in OPL

‏2012-10-19T13:49:22Z |
I have following index and corresponding ranges:
t {1, 2, …, 7}

u {-3, -2, -1, 0, 1, 2, 3}

v {1, 2, 3}

w {1, 2, 3}

m {1, 2, 3}

and a parameter P(v,w,m) whose elements are all integer values.

How can I read corresponding data from Excel file since this parameter is 3 dimension, and furthermore, the parameter with multi-dimension (>2)?

Now I want to define a variable M(t, u, P(v,w,m)) where the elements of P(v,w,m) can be used as the index in this variable, how can I do this in OPL?

Thanks in advance!
Updated on 2012-10-23T11:38:05Z at 2012-10-23T11:38:05Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    754 Posts

    Re: multi dimension data input from Microsoft Excel and handling index in OPL

    ‏2012-10-23T11:38:05Z  
    You best post this question in the OPL Forum. The OPL experts can be found there.