Hi Christina, I think you have to start with CSV example in the glpk4.xx/example/csv. It is the transporation model then later on move to the excel if you really need to.
You can also look at the dbf example - my model. Noli On 12/10/10, Noli Sicad <[email protected]> wrote: > 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 <[email protected]> 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 <[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
