|
From: | Nigel Galloway |
Subject: | [Help-glpk] Using glpk with open office spreadsheets |
Date: | Sun, 27 Jul 2008 13:08:03 +0100 |
It is possible to use glpk_vfs to enable glpsol to interwork with an open office spreadsheet. Open office is not required to run the following examples, but obviously if you wish to change them or use your own it is. For convenience the examples are displayed in F.html.tar.bz2. The examples are run with: glpsol --math KuKu.mathprog --data glpk_vfs/<sheet name> Attached: KuKu.Sudoku.ods and KuKu.FutoshickiFicki.ods the open office spreadsheets in ods.zip KuKu_vfs.rb the base class for interworking with the spreadsheets in KuKu_vfs.zip FutoshickiFicki_vfs.rb and Sudoku_vfs.rb classes which extend KuKu_vfs.rb to understand the content of the spreadsheets in KuKu_vfs.zip KuKu.mathprog a mathprog model for solving the problems F.html.tar.bz2 Example output from running the software with pictures. I'll assume everyone understands Sudoku. For FutoshickiFicki the numbers 1 to 5 have to be arranged in each row and column such that cells attached by / and \ have the same value. '<' '>' 'A' and 'V' indicate that the cell at the pointy end has to be less than the other. -- _______________________________________________ Surf the Web in a faster, safer and easier way: Download Opera 9 at http://www.opera.com Powered by Outblaze
F.html.tar.bz2
Description: Binary data
KuKu.mathprog
Description: Binary data
KuKu_vfs.zip
Description: Zip compressed data
ods.zip
Description: Zip compressed data
[Prev in Thread] | Current Thread | [Next in Thread] |