-------- Forwarded Message --------
From: Christina Cignarale <[email protected]>
To: Noli Sicad <[email protected]>
Cc: CHRISTINA CIGNARALE (RIT Student) <[email protected]>,
[email protected]
Subject: Re: [Help-glpk] reading Excel table into GLPK
Date: Thu, 9 Dec 2010 22:03:22 -0500
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 <[email protected]> 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&[email protected]&o=relevance&start=0
Noli
On 12/7/10, glpk xypron <[email protected]> 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
_______________________________________________
Help-glpk mailing list
[email protected]
http://lists.gnu.org/mailman/listinfo/help-glpk
