Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
1 reply Latest Post - ‏2012-10-23T11:38:05Z by SystemAdmin
CplexCui
CplexCui
1 Post
ACCEPTED ANSWER

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
    ACCEPTED ANSWER

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

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