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

[Noli Sicad]

Hi Christina,

If you are using windows 7.

Read this posting regarding ODBC and Excel in Windows 7

http://social.answers.microsoft.com/Forums/en-US/w7hardware/thread/001c234b-dfd5-4378-a325-c4f1482fb6fd

Noli


On 12/10/10, Noli Sicad <address@hidden> wrote:
> 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
>>
>