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

[Noli Sicad]

I think the error is pointing on "ODBC"

Context: {NUTR, FOOD} >= 0; table f IN '...'...'...' NUTR <-

in

param amt {NUTR,FOOD} >= 0;

table f IN 'ODBC'

Have you run the Soduku excel example and got the right result?  Are
you using Windows XP or 7?

BTW, where are the other parameters amt[i,j] and cost[1] tables in the model?

Please post the complete log start with "GLPSOL: GLPK LP/MIP Solver,
v4.44" to the error

Example:

GLPSOL: GLPK LP/MIP Solver, v4.44
Parameter(s) specified in the command line:
 --cover --clique --gomory --mir -m EstateModel_sqlite3_1_Otago2_25.mod
Reading model section from EstateModel_sqlite3_1_Otago2_25.mod...
EstateModel_sqlite3_1_Otago2_25.mod:803: warning: unexpected end of
file; missing end statement inserted
803 lines were read
Reading tab...
Connected to SQLite 3.6.22 - Otago_p.sqlite
SELECT * FROM tblSpecies
Display statement at line 203
SPECIES:
   '???'
   FIR
   OTH
   RAD
...

Noli

On 12/10/10, Christina Cignarale <address@hidden> wrote:
> The error I am receiving is:
> diettable.mod 16:argument expression has invalid type
>
> Context: {NUTR, FOOD} >= 0; table f IN '...'...'...' NUTR <-
>
> I also attached the excel file I am trying to read from.
>
> On Thu, Dec 9, 2010 at 10:03 PM, Christina Cignarale <
> address@hidden> 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
>>
>
>
>
> --
> Christina Cignarale
>