Services
- Home
- Services
- Professionals
- Statistical and Econometrics Software
- Excel Macros
Excel Macros
TSWutil.xla is an Excel Add-in for use with TSW input and output files. The tool is easy to use and complements the TSW functionalities.
-
descTSWutil.pdf
(180 KB) contains a description of TSWutil.xla and installation instructions. -
TSWAddIn.zip
(2 MB) contains TSWutil.xla. (Date of version: 9 October 2009).
TSWutil provides you with the following Excel macros:
- ROG. Computes a battery of rates-of-growth -and of their forecast- for the original series, SA series, and trend-cycle component.The summary table it produces may be useful in short-term analysis.
- Problematic. Macro that picks up problematic series following an application of program TSW to a set of (perhaps many) time series.
- Xlsts. Transforms time series Excel files in various formats into Excel files ready for TSW and/or text files for TRAMO-SEATS in DOS.
- groupOutlier. Facilitates analysis of the outliers detected and corrected by TSW in sets with many series.