FICO Xpress Optimization Examples Repository: Reading 3-dimensional arrays

FICO Xpress Optimization Examples Repository

Reading 3-dimensional arrays

Description

This example shows how to read a 3-dimensional array from an excel file (threedimarr.mos) and from a generic spreadsheet (threedimarr5.mos). Model versions (2) and (4) show the same example for databases, and model version (6) works with data in CSV format.

threedimarr.zip

[download all files]

Source Files

By clicking on a file name, a preview is opened at the bottom of this page.

threedimarr.mos	[download]
threedimarr2.mos	[download]
threedimarr3.mos	[download]
threedimarr4.mos	[download]
threedimarr5.mos	[download]
threedimarr6.mos	[download]

Data Files

threedim.csv	[download]
threedim.xls	[download]
threedim.xlsx	[download]
threedim.mdb	[download]
threedim.sqlite	[download]

threedim.csv

,,"Index 3",,,,
"Index1","Index2","Index3_1","Index3_2","Index3_3","Index3_4","Index3_5"
2,"A",211,212,213,214,215
2,"B",221,222,223,224,225
2,"C",231,232,233,234,235
1,"A",111,112,113,114,115
1,"D",121,122,123,124,125
1,"E",131,132,133,134,135