Re: [Help-glpk] reading Excel table into GLPK

[Andrew Makhorin]

On Thu, 2010-12-09 at 22:03 -0500, Christina Cignarale wrote:
> Hi,
> 
> Thank everyone for your input. I put the table statement into the
> model file but, I am still getting an error. I was unsure how to
> define part of the statement for my problem. I referenced the soduku
> example that is posted. This is the model I am using
> 
> set NUTR;
> set FOOD;
> 
> param cost {FOOD} > 0;
> param f_min {FOOD} >= 0;
> param f_max {j in FOOD} >= f_min[j];
> 
> param n_min {NUTR} >= 0;
> param n_max {i in NUTR} >= n_min[i];
> 
> param amt {NUTR,FOOD} >= 0;
> 
> table f IN 'ODBC' 
> 'Driver={Microsoft Excel Driver (*.xls)};dbq=newdiet.xls'
> 'SELECT * FROM [Nutr$]'
> NUTR <- [NUTR],n_min,n_max;
> 
> var Buy {j in FOOD} >= f_min[j], <= f_max[j];
> 
> minimize Total_Cost:  sum {j in FOOD} cost[j] * Buy[j];
> 
> subject to Diet {i in NUTR}:
>    n_min[i] <= sum {j in FOOD} amt[i,j] * Buy[j] <= n_max[i];
> 
> 
> The highlited line is where I am getting the error. I know I do not
> have a WHERE statement but I was unsure how to include that.
> 
> Thank you for your help,
> Christina
> 
> On Mon, Dec 6, 2010 at 5:18 PM, Noli Sicad <address@hidden> wrote:
>         Browse glpk-help archive [[1] about Excel and GLPK. It has 10
>         pages
>         about Excel and MathProg.
>         
>         [1]
>         
> http://www.mail-archive.com/search?q=Excel&address@hidden&o=relevance&start=0
>         
>         Noli
>         
>         
>         
>         
>         On 12/7/10, glpk xypron <address@hidden> wrote:
>         > Hello Christina,
>         >
>         > please, have a look at
>         > http://sourceforge.net/projects/winglpk/
>         >
>         > The distribution includes example files
>         > glpk-4.44/examples/sql/sudoku_excel.mod and
>         > glpk-4.44/examples/sql/sudoku_xls
>         >
>         > Please, read
>         > http://en.wikibooks.org/wiki/GLPK/ODBC#Microsoft_Excel
>         >
>         > Best regards
>         >
>         > Xypron
>         
> 
> 
> 
> -- 
> Christina Cignarale