Intertwined spreadsheet matrices

Many spreadsheet tables can be represented in Scilab by 5 intertwined matrices:

a string matrix Tit for titles, sub-titles and comments,
a classical matrix Val for the numerical values,
a string matrix Nam for the column names of the Val matrix,
a string matrix Lab for the line labels of the Val matrix,
a string matrix NamLab for the names of the Lab matrix.

   Tit(1)    -> Title
   Tit(2)    -> Sub-title
   Tit(3)    -> Comments
NamLab(1,1)  Nam(1,1)  Nam(1,2)  NamLab(1,2)  Nam(1,3)  Nam(1,4)
   Lab(1,1)  Val(1,1)  Val(1,2)     Lab(1,2)  Val(1,3)  Val(1,4)
   Lab(2,1)  Val(2,1)  Val(2,2)     Lab(2,2)  Val(2,3)  Val(2,4)
NamLab(2,1)  Nam(2,1)  Nam(2,2)  NamLab(2,2)  Nam(2,3)  Nam(2,4)
   Lab(3,1)  Val(3,1)  Val(3,2)     Lab(3,2)  Val(3,3)  Val(3,4)
   Lab(4,1)  Val(4,1)  Val(4,2)     Lab(4,2)  Val(4,3)  Val(4,4)

Version 2004-12-12

W3C XHTML 1.0 CSS [^]