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

[Noli Sicad]

Hi,

OK. Let try to run first the Sodoku example.

First we have to get the current GLPK 4.44. We Gusek IDE for GPLK. It
is easier to use and you can run your script and copy and paste the
logs and results very easily.

Download it here: http://sourceforge.net/projects/gusek/files/

Gusek site
http://gusek.sourceforge.net/gusek.html#2

You don't anything - GUSEK got glpsol.exe in the package.

Windows XP is very easy for ODBC.

Then try to run the Soduku example.

Noli




On 12/10/10, Christina Cignarale <address@hidden> wrote:
> Hi Noli,
>
> I am using Windows XP.  The Sodoku example did not work for me. The error I
> got when I ran that was
> Reading ti ...
> unable to open libiodbc.so
> can't open the module
>
> I'm using version 4.34 of GLPK. And the other parameters should be contained
> on the other sheets in that workbook.Thank you so much for your help. I am
> used to solving in AMPL and I do not have that much computer knowledge so it
> makes it hard sometimes to understand the instructions for GLPK.
>
> Also, how would I post the complete log? The only way I know to copy a
> command prompt is to use print screen. Is there an easier way?
>
> -Christina
>
> On Fri, Dec 10, 2010 at 12:07 AM, 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
>> >
>>
>
>
>
> --
> Christina Cignarale
>