Originally posted by: BEA123
I am attempting to get better at incorporating access into CPLEX. I have created the following strings and tupels:
{string} Product = ...;
{string} Resource = ...;
tuple Demand
{
float Dj; //Demand of product j
}
tuple Capacity
{
float Ri; //Capacity of resource i
}
I would like to read the cost information from access as well. That is cost[resource][product] -->the cost to use resource i to produce product j.
Are you even able to load data from access like that, that is, can the cost be populated by reading across the columns and then reading down the rows?
I am looking to have one rectangular table that the column headers is the product and the row headers in the resource. Inside the table is the cost associated with resource i for product j. I want it to look similar to the Transportation LP tableau. Thanks.
#DecisionOptimization#OPLusingCPLEXOptimizer