| |||||||||||||||||||||||||||||||
Writing out solution values to text files, spreadsheets or databases Description Solution values of decision variables or constraints need to be copied into an array. The contents of this array can then be written to a spreadsheet or database using ODBC or software-specific drivers (or simply to text file using Mosel's default output).
Further explanation of this example: Xpress Whitepaper 'Using ODBC and other database interfaces with Mosel', Section Examples - Outputting solution values. 'Mosel User Guide', Section 10.2.4 Solution output with initializations to.
Source Files By clicking on a file name, a preview is opened at the bottom of this page.
Data Files
soleg3.mos (!****************************************************** Mosel Example Problems ====================== file soleg3.mos ``````````````` Writing out solution values to an Excel spreadsheet. - Using 'initializations to' with the excel driver - (c) 2008 Fair Isaac Corporation author: S. Heipcke, 2007, rev. Oct. 2017 *******************************************************!) model "Solution values output (3)" uses "mmxprs", "mmsheet" parameters CNCT = "soleg.xls" ! Use Excel spreadsheet `soleg.xls' end-parameters declarations R = 1..3 S = 1..2 SOL: array(R,S) of real ! Array for solution values x: array(R,S) of mpvar ! Decision variables end-declarations ! Define and solve the problem forall(i in R) sum(j in S) x(i,j) <= 4 forall(j in S) sum(i in R) x(i,j) <= 6 maximise( sum(i in R, j in S) (i*j)*x(i,j) ) ! Get solution values from LP into the array SOL forall(i in R, j in S) SOL(i,j) := getsol(x(i,j)) ! Data output using an initializations block with the excel driver initializations to "mmsheet.excel:"+CNCT SOL as "grow;MyOut3" end-initializations (! Alternative form: initializations to "mmmsheet.excel"+CNCT evaluation of array(i in R, j in S) x(i,j).sol as "grow;MyOut3" end-initializations !) end-model | |||||||||||||||||||||||||||||||
© Copyright 2023 Fair Isaac Corporation. |