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 <[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 >> > _______________________________________________ Help-glpk mailing list [email protected] http://lists.gnu.org/mailman/listinfo/help-glpk
