(!*******************************************************
   Mosel Example Problems 
   ======================

   file multiout5.mos
   ``````````````````
   Output several data arrays into a single table.
   - Using 'initializations to' with the xls IO driver -
       
   (c) 2012 Fair Isaac Corporation
       author: S. Heipcke, Dec. 2012
*******************************************************!)

model "Output multiple data columns (generic spreadsheet)"
 uses "mmsheet"

 parameters
  CSTR= 'mmsheet.xls:'
  DFILE= 'multicol.xls'
!  CSTR= 'mmsheet.xlsx:'
!  DFILE= 'multicol.xlsx'
 end-parameters

 declarations
  PRODUCTS: set of string
  MACH: range
  COST: dynamic array(PRODUCTS,MACH) of real
  DUR: dynamic array(PRODUCTS,MACH) of integer
 end-declarations

! Read data
 initializations from "multiout.dat"
  COST DUR
 end-initializations

! **** Writing data to the spreadsheet multicol.xls ****

! Options:
! skiph - the range 'CombData' includes a header line
! grow  - only the starting line of the range is specified
 initializations to CSTR + "skiph;grow;" + DFILE
  [COST,DUR] as 'CombData'
 end-initializations

! Alternative: specify the range/worksheet
 initializations to CSTR + DFILE
  [COST,DUR] as 'grow;[Sheet1$L4:O4]'
 end-initializations

end-model