Input and output files from X-13ARIMA-SEATS(X-13A-S) (U.S. Census Bureau, 2015) must be text files; however, many users store their data in Microsoft Excel files and would like their output in Microsoft Excel format.
X-13-Data is a tool that can:
Licensing information for this software can be found here:
X-13-Data has been tested on Windows XP, Windows 7, and Windows 8. To run the program, Microsoft.NET Framework 3.5 must be installed on your computer. It can be downloaded here.
X-13-Data also requires Microsoft Excel installed on your computer and has been tested with Microsoft Excel 2007, Microsoft Excel 2010, and Microsoft Excel 2013.
X-13-Data will read data in a Microsoft Excel file in a variety of formats (all described in Section 6) and convert them to an X-13 data file in datevalue format. (See the X-13ARIMA-SEATS Reference Manual (2015) for more information about datevalue and other accepted formats.)
The exact format of the Excel file varies depending on the type of file being converted and how many series are being converted at a time. But the general format will include:
To convert X-13 output files to Excel files.
Series can be grouped by series or file type. Each grouping will be on its own worksheet in the Excel file. X-13ARIMA-SEATS can accommodate series with one of five periods: annual, biannual, quarterly, bimonthly, and monthly. X-13-Data can convert files of all four periods at once if requested by the user. When organizing the output by series, this doesn't present a problem since all file types for a single series will have the same period. However, when organizing the output by file types; there is the potential for different periods for the same file type. In this case, X-13-Data creates a separate worksheet for each combination of file type and period. In this case, the worksheet name will be the file type followed by the period.
The dates are in one or two columns and the data is in another column.
Data is in a table, with each row containing one year of data. Each column contains data for one period.
Similar to Vertical for single series, each series is in its own column. There is a row containing the names of each series. These are used to name the data files created by X-13-Data.
One column contains the series names. (Here it is column A.) Each series is presented in its entirety before the next series begins. Each row contains one year of data. Each month (quarter) is in its own column.
X-13-Data will create a data file for each unadjusted series from the MRTS report. You do not need to specify any parameters when the MRTS format has been selected.
This is similar to Vertical Multiple format except that entire matrix will be saved into one data file. This type of file can be read into X-13ARIMA-SEATS as a user-defined regressor.
Use the controls to specify the start and end rows and columns of the regression matrix. Data Start Column and Data Start Row are required. Leave Data End Column and Data End Row at their default values to read the entire matrix. Otherwise, use Data End Column and Data End Row to read a subset of the data in the Excel file.
For more information or to report bugs, please contact Demetra Lytras.
Phone: (301) 763-7426