+1While writing the suffices ProgramStatus and SolverStatus from a MathematicalProgram identifier to an Excel file using DEX I get numeric values rather than the lables indicated in this table:
Is there any way to write these labels rather than the corresponding numeric values?
Otherwise, where could I find the corresponding mapping between the numeric values and the labels (status) referred in the previous table?
Best answer by gdiepen
What are the numbers that you see being written to Excel? Are those the ordinal values of these elements by any chance?
I think you might need somebody from AIMMS help out to really fix it (or provide the way it should work).
As a work-around, you could create two parameters:
spMathematicalProgramProgramStatus with definition formatstring(“%e”, MathematicalProgram.ProgramStatus)
spMathematicalProgramSolverStatus with definition formatstring(“%e”, MathematicalProgram.SolverStatus)
and write those two items to the excel file?
+7Not sure what code you are using to write the values, but one way you could force it to be a string is to use something like:
formatstring(“%e”, mpProblem.ProgramStatus)
+1 Thank you
I am using DEX to write the values into an Excel file. The code is the following:
<AimmsExcelMapping>
<ExcelSheetMapping name="Summary">
<RowMapping>
...
<ColumnMapping name="Program Status" maps-to="MathematicalProgram.ProgramStatus" />
<ColumnMapping name="Solver Status" maps-to="MathematicalProgram.SolverStatus" />
...
</ExcelSheetMapping>
</AimmsExcelMapping>Note that I believe I cannot use formatstring(“%e”, MathematicalProgram.ProgramStatus) in DEX
+7What are the numbers that you see being written to Excel? Are those the ordinal values of these elements by any chance?
I think you might need somebody from AIMMS help out to really fix it (or provide the way it should work).
As a work-around, you could create two parameters:
spMathematicalProgramProgramStatus with definition formatstring(“%e”, MathematicalProgram.ProgramStatus)
spMathematicalProgramSolverStatus with definition formatstring(“%e”, MathematicalProgram.SolverStatus)
and write those two items to the excel file?
Already have an account? Login
Please use your business or academic e-mail address to register
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.