Here, you find some tools useful when working with STAN:

When data is exported from STAN to Excel, it can't be used directly to perform further calculations because it is text (value + space + unit). The VBA code in "SplitValueUnit.bas" transforms the data from text format into a numerical value with the unit displayed within the cell as user defined format. Additionally, the decimal seperator is changed to the settings used in Excel.

(1) Press ALT + F11 to open the VBA editor in Excel.
(2) Import "SplitValueUnit.bas" via "File > Import File".
(3) Select the cells on the Excel sheet to be transformed.
(4) Press CTRL + m.


Free business joomla templates