STEM help / Appendices

11.2 External Reference Labels for databases

This appendix is a comprehensive listing of the labels required for linking time-series and defaults for whole elements in STEM to data in an Excel ODBC data source through button formulae. For example:

'XLS:MODELDB.XLS'!InterpSeries

'XLS:MODELDB.XLS'!Resource

For more details, see 6.6 Linking input data via ODBC. These labels are also presented in the Microsoft Excel spreadsheet MODELDB.XLS which is supplied with STEM.

When constructing sheets of your own, you only need include labels for the fields you want to set, and the order is not important. Some more compact examples are provided in EXAMPLE.XLS. EXCEL.DTL is a sample model which contains references to both sheets.

 

© Implied Logic Limited