Please disregard this posting. This problem is already solved by Xypron. http://lists.gnu.org/archive/html/help-glpk/2010-01/msg00010.html
My fault, I did not see the reply. Thanks again Xypron. Noli On 1/7/10, Noli Sicad <[email protected]> wrote: > Hi, > > I am having problems in formatting my LP result to represent into > maps. I need to show my LP results into maps or outputted in GIS. I > need to create 70 maps, each harvest period. This is multi period LP > model, 1 to 70 years planning period. > > Inorder to do this, I need to have one-to-one table relationship as > required by GIS file system (i.e. shapefile). Shapefile requires this > relationship to properly render the maps and polygon, one polygon, one > row of data. > > Here is my problem, I need the LP result transpose (I wish there is > transpose function in MathProg in results section). Now, I created 2 > matrixes / tables and put into one matrix / table. > > Here are the tables / matrixes (below). Someone suggested in R-help ML > that probably "matrix premultiplication" can do this. > > I think MathProg can do this, but I don't know how. > > Thanks in Advance. > > Noli > > ~~~~~~~~~~~~~~~~~~~~~~~ > Matrix A > > Harvest_LP_result_cut. > ~~~~~~~~~~~~~~~~~ > > Crop_ID Croptype Period Cut_Age > 1 SORI 1 31 > 1 SORI 1 32 > 1 SORI 1 33 > 1 SORI 1 34 > 2 SORI 2 30 > 2 SORI 2 31 > 2 SORI 2 32 > 2 SORM 2 37 > 3 OTRM 3 33 > 3 SORI 3 30 > 3 SORM 3 38 > 4 SORI 4 30 > 4 SORM 4 38 > 5 OTRI 5 30 > 5 OTRM 5 34 > 5 SORM 5 37 > 5 SORM 5 38 > 5 SORM 5 40 > 6 OTRI 6 28 > 6 OTRI 6 29 > 6 OTRI 6 30 > 6 OTRM 6 32 > 6 OTRM 6 33 > 6 OTRM 6 34 > 7 OTRM 7 33 > 8 OTRM 8 34 > 9 OTRM 9 35 > 10 OTRM 10 34 > 10 OTRM 10 35 > 10 OTRM 10 36 > 10 SORM 10 41 > ~~~~~~~~~~~~~~~~~~~~~~~~~~ > > Matrix B - template. > P1 P2 P3 P4 P5 P6 P7 P8 P9 > P10 > 1 1 0 0 0 0 0 0 0 0 > 0 > 2 1 0 0 0 0 0 0 0 0 > 0 > 3 1 0 0 0 0 0 0 0 0 > 0 > 4 1 0 0 0 0 0 0 0 0 > 0 > 5 0 2 0 0 0 0 0 0 0 > 0 > 6 0 2 0 0 0 0 0 0 0 > 0 > 7 0 2 0 0 0 0 0 0 0 > 0 > 8 0 2 0 0 0 0 0 0 0 > 0 > 9 0 0 3 0 0 0 0 0 0 > 0 > 10 0 0 3 0 0 0 0 0 0 > 0 > 11 0 0 3 0 0 0 0 0 0 > 0 > 12 0 0 0 4 0 0 0 0 0 > 0 > 13 0 0 0 4 0 0 0 0 0 > 0 > 14 0 0 0 0 5 0 0 0 0 > 0 > 15 0 0 0 0 5 0 0 0 0 > 0 > 16 0 0 0 0 5 0 0 0 0 > 0 > 17 0 0 0 0 5 0 0 0 0 > 0 > 18 0 0 0 0 5 0 0 0 0 > 0 > 19 0 0 0 0 0 6 0 0 0 > 0 > 20 0 0 0 0 0 6 0 0 0 > 0 > 21 0 0 0 0 0 6 0 0 0 > 0 > 22 0 0 0 0 0 6 0 0 0 > 0 > 23 0 0 0 0 0 6 0 0 0 > 0 > 24 0 0 0 0 0 6 0 0 0 > 0 > 25 0 0 0 0 0 0 7 0 0 > 0 > 26 0 0 0 0 0 0 0 8 0 > 0 > 27 0 0 0 0 0 0 0 0 9 > 0 > 28 0 0 0 0 0 0 0 0 0 > 10 > 29 0 0 0 0 0 0 0 0 0 > 10 > 30 0 0 0 0 0 0 0 0 0 > 10 > 31 0 0 0 0 0 0 0 0 0 > 10 > > Needed Table. > ~~~~~~~~~~ > Crop_ID Croptype P1 P2 P3 P4 P5 P6 > P7 P8 P9 P10 > 1 SORI 31 0 0 0 0 0 0 0 > 0 0 > 1 SORI 32 0 0 0 0 0 0 0 > 0 0 > 1 SORI 33 0 0 0 0 0 0 0 > 0 0 > 1 SORI 34 0 0 0 0 0 0 0 > 0 0 > 2 SORI 0 30 0 0 0 0 0 0 > 0 0 > 2 SORI 0 31 0 0 0 0 0 0 > 0 0 > 2 SORI 0 32 0 0 0 0 0 0 > 0 0 > 2 SORM 0 37 0 0 0 0 0 0 > 0 0 > 3 OTRM 0 0 33 0 0 0 0 0 > 0 0 > 3 SORI 0 0 30 0 0 0 0 0 > 0 0 > 3 SORM 0 0 38 0 0 0 0 0 > 0 0 > 4 SORI 0 0 0 30 0 0 0 0 > 0 0 > 4 SORM 0 0 0 38 0 0 0 0 > 0 0 > 5 OTRI 0 0 0 0 30 0 0 0 > 0 0 > 5 OTRM 0 0 0 0 34 0 0 0 > 0 0 > 5 SORM 0 0 0 0 37 0 0 0 > 0 0 > 5 SORM 0 0 0 0 38 0 0 0 > 0 0 > 5 SORM 0 0 0 0 40 0 0 0 > 0 0 > 6 OTRI 0 0 0 0 0 28 0 0 > 0 0 > 6 OTRI 0 0 0 0 0 29 0 0 > 0 0 > 6 OTRI 0 0 0 0 0 30 0 0 > 0 0 > 6 OTRM 0 0 0 0 0 32 0 0 > 0 0 > 6 OTRM 0 0 0 0 0 33 0 0 > 0 0 > 6 OTRM 0 0 0 0 0 34 0 0 > 0 0 > 7 OTRM 0 0 0 0 0 0 33 0 > 0 0 > 8 OTRM 0 0 0 0 0 0 0 34 > 0 0 > 9 OTRM 0 0 0 0 0 0 0 0 > 35 0 > 10 OTRM 0 0 0 0 0 0 0 0 > 0 34 > 10 OTRM 0 0 0 0 0 0 0 0 > 0 35 > 10 OTRM 0 0 0 0 0 0 0 0 > 0 36 > 10 SORM 0 0 0 0 0 0 0 0 > 0 41 > _______________________________________________ Help-glpk mailing list [email protected] http://lists.gnu.org/mailman/listinfo/help-glpk
