-------- 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: Fri, 10 Dec 2010 00:27:28 -0500
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 <[email protected]> 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 <[email protected]> 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 < > [email protected]> 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 <[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 >> > > > > -- > Christina Cignarale > -- Christina Cignarale _______________________________________________ Help-glpk mailing list [email protected] http://lists.gnu.org/mailman/listinfo/help-glpk
