Tables and Worksheets

Tables and worksheets are the primary means by which you work with data in 1010data.

A table is a collection of data that is stored as rows and columns in 1010data. A worksheet is an instance of a table that has been opened in 1010data and has had any number of operations applied to it (such as selecting rows, performing summaries, or creating computed columns). You may have multiple worksheets open at the same time. (Technically, a table that has been opened in 1010data but has no operations applied to it is still considered a table, not a worksheet.)

Worksheets provide an easy way to perform actions on individual tables and then link them. For example, you may tabulate two tables separately and link the results.

Typically, your company's data is initially loaded onto the system by the 1010data support team. In addition, you can also upload tables to 1010data through the 1010data web interface as well as a number of other 1010data tools, such as the Excel Add-in and TenUp, or using the 1010data API.

1010data pre-loads certain published data sets onto your system, such as hourly U.S. weather observations, Federal Reserve economic data, and unemployment statistics. You may also have access to third-party data sets that you license through 1010data.

All of the tables to which you have access can be found in the Folders and Tables browser.

To view a table, double-click its entry in the Folders and Tables browser. The table will open as a worksheet in a new tab.

For instance, if you want to view the table Monthly Statewide Non-Seasonally Adjusted Unemployment Statistics, double-click that item in the browser. A new tab will be opened (next to the Start Page tab), and the table will be displayed in that tab. Also, the Folders and Tables browser will be hidden (unless it is pinned).

At the top of the table you will see a toolbar that includes the path to the table you are viewing in the current tab. You can click on any of the elements to open the corresponding folder in the Folders and Tables browser.

The toolbar also includes icons that are used for moving backward or forward through the steps of your analysis, opening the tab in a new window, and cloning the tab.

Underneath the toolbar, there is a menu bar that provides a number of items that you will use as you interact with your tables and worksheets.

Below that, the table is displayed.
Note: The number of columns and rows shown is dependent on the size of your browser window. If you resize your browser window, the number of visible rows and columns will change.
Under the table heading, you will see which columns and rows are currently displayed.

If the entire table cannot be displayed in the browser window (which is most likely the case for tables of any substantial size), you will see scroll bars on the side or the bottom of the table.

If you have more than one worksheet open, you will see multiple tabs at the bottom of your 1010data session, each one corresponding to a worksheet.

You can switch between worksheets by clicking on the desired tab.