TPL Tables

TPL Tables is a powerful and flexible cross tabulation system used for both data analysis and publication. It automatically produces professional quality tables in PostScript and HTML.

Powerful Tabulation Engine

	Nesting -- Allows an unlimited number of levels or dimensions. For example, your table could show unemployed people by gender by race by age by marital status.
	Concatenation -- Allows you to simultaneously tabulate many different items and show them in a single table. Your table could show both the number of employees and the average salary for industry then age then gender then race then marital status.
	Layering -- Allows you to produce a table and then layer it by numerous factors. For example, you could repeat the same table for each region of the country.

In addition to structuring tables, you can also use TPL Tables to:

	Compute new variables and statistics
	Group values into ranges or other categories of your choice (i.e., group states into regions or incomes into ranges)
	Select data with the characteristics that interest you (i.e., age less than 30, income greater than $50,000, or both together)
	Include totals, subtotals and percent distributions
	Calculate medians, percentiles, deciles, and other quantiles

Extensive Formatting Options
TPL Tables has extensive formatting options that make it easy for you to both present your tables in an easy-to-read format and conform to those pesky publication requirements. You control table structure and content by choosing your own settings for:   

	Page breaks, orientation and paper size
	Color of text, lines and data
	Labels, titles, footnotes, page numbers and table placement
	Column widths
	Label break points
	Data value formats, including currency signs, percent signs, commas and decimals
	Placement and thickness of lines
	Type sizes and styles

Features in Version 6.0

New Input and Output Options

	CSV input files -- CSV (comma separated values) and other types of delimited files can now be used as input. Creating new codebooks for delimited files is quick and easy with the wizard-like interface in Codebook Builder. If the first line of data has variable names, you can choose to have them automatically used as the variable names in the codebook.
	CSV output files -- Outputs can be exported as CSV files.
	Tables can be exported in pdf format from within TPL
	Tables can be exported in PC-Axis format. The PC-Axis family consists of a number of programs for the Windows and Internet environment. PC-Axis is aimed at any organisation interested in publishing tabular statistical data, and is used by a number of Statistical Offices in different countries to let their users retrieve statistics.
	Major enhancements have been made to HTML output. These include: * HTML can be exported in CSS (cascading style sheets) format with style names that describe table parts. * Stub indentation more closely matches the table as displayed in Ted. Stub continuation and stub increment work. * All other label alignment and spacing options now work also. Labels with multiple alignments will retain these alignments. * Label wrapping matches the table as displayed in Ted. * There are no extra rules in stubs. * Shading is supported for of all or parts of a table. * End users can scale tables in all commonly used browsers. * There is an Excel option for better display in Excel. * The Autosize option allows an entire table to fit in a single html page (no automatic banking or skipping to a new page because the table is too long). * Table cells are now aligned based on mask (decimal points line up).

New Functions

	Row Banking -- allows narrow tables to be broken at the bottom of a page, or after a selected row, and "wrapped" to the top of the page so that the sections (banks) are displayed side by side.
	Statements have been added for built-in statistical functions so that you do not need to enter the formulas with Computes and Post Computes. * MEAN weighted or unweighted * VAR - variance of sample (n - 1) * VARP - variance of whole population (n) * STDERR - standard error of means * STDEV - standard deviation of sample (n - 1) * STDEVP - standard deviation of whole population (n)
	Ranking -- Table rows can be ranked (sorted) based on the values in a selected data column. Different groups or rows can be ranked differently. The ranking can be descending or ascending. Optionally, a rank column can be added to the table to display the rank number for each row. Another option lets you keep only the top (or bottom) n rows for a particular ranking. With this option, you can request a row to display the residual.

Other New Features

	Table requests are no longer limited to 2 billion potential cells.
	PostScript tables can now be scaled so that more rows and columns will fit on a page. This gives much finer control than you can get by changing font sizes.
	Comments are now retained in approximately their original location for both table requests and format statements even when the requests are generated by an external editor.
	A new quick label editor has been added to Ted, Table Builder, and Codebook builder. You can add simple text in the box or, if you are familiar with the syntax of TPL labels, you can enter entire labels using label grammar. The label entries are checked for validity.
	If you have a Postscript printer, you can now print directly to it in Ted instead of going through the normal print conversions. This produces more accurate output especially for scaled tables.
	Table Builder now supports simpler select, compute, and post compute windows for less experienced users.
	Multiple TPL jobs can be run simultaneously on a single machine. A locking mechanism has been added to assure the jobs do not interfere with each other.
	For organizations where users are not free to modify their Windows directories (e.g. c:\winnt or c:\windows) the tpl.ini file can be stored in some other location.
	Building Codebooks -- A new Unix program called tpl conditions can be used to assist in building codebooks for any type of data that can be used with TPL. It converts partial codebook sources into complete codebook sources, creating condition value lists based on the values in the data. In doing so, it saves you work in creating codebooks and also assures that the codebook source accurately describes the data. The program can also be used to update a codebook source when the data has changed in such a way that additional condition values are needed. This new program replaces the old codebook generator that could only be used with sequential fixed width data files.

Features New to Version 5.2

Accessible HTML Table Output Meets Section 508 Standards
You can request HTML output in a format that can be used by visually impaired persons. The HTML meets the standards of Section 508 of the Americans with Disabilites Act which requires that U.S. government web sites be accessible. The new JAWS reader software works successfully with TPL HTML output. Sample accessible table.

Tabulation Features
A new rounding option has been added to provide a choice between rounding data values up and rounding them according to the "round even" rule.
When there are multiple tables in a table request, data selection can now be applied on a table by table basis so that different subsets of the data can more easily be selected for different tables.
Computations that take place after tabulation, called Post Computes, can now reference variables created by other Post Computes. This can greatly simplify some computations.

Format Features
Page Markers can contain a count of the number of pages in the table output so that pages can be labeled with both the individual page number and the count, for example Page 3 of 10.
Specific instances of a label, for example on a particular row or column of a table, can be replaced without affecting other instances of the label. This eliminates the need to have different sets of labels for unique and unusual situations.
You can control the minimum number of dots displayed as the dot leader for stub labels on rows with data.

Label Lists
(for TPL-SQL databases)
For category variables, lists of value/label pairs can be loaded into databases. Now, instead of containing only simple text, the labels can contain any of TPL's advanced label formatting features, for example font choices, indentations, and line breaks.

TPL Scripts for Batch Jobs
(Windows version)
TPL scripts can be run in background with job status displayed on the task bar. This means that work can be done in other applications while large batches of TPL jobs are running.
Wild cards (* and ?) can be used in script lines for TED so that fewer commands are required.
The CHDIR command in scripts now applies to TED as well as to other commands, so there is no need to provide full paths for files in TED commands.
New arguments for TED let you choose the core file names and destination locations for exported files such as HTML and Encapsulated PostScript.

Interactive Features
(Windows version)
In addition to the Format Features listed elsewhere:
To speed up interactive editing of PostScript tables in TED, the TPL editor, many new features have been added to give detailed control of items to be changed. For example, instead of editing column by column, you can click or otherwise select multiple specific columns or ranges of columns to change the column width.
In the label editor, cut and paste can be used and special (non-keyboard) characters can be pasted from the Windows Character Map or entered with the numeric keypad.
In menus for running jobs, there is a new menu to let you set file extensions so that when you browse for files you will initially see only the files that are suitable for the particular situation.

Features New to Version 5.1.6

Subfields (for TPL-SQL databases) Subfields let you describe variables that are subparts of variables in your database. In non-database codebooks, this functionality is provided by Redefine. Examples of variables that could be divided into subfields are codes such as a commodity or industry codes where the first digit of the code gives a major category and additional digits provide additional detail. Codebook Builder (Windows version) For ODBC databases, Codebook Builder has been optimized to speed up processing of condition values, both in creating codebooks and in checking the condition values for old codebooks. The change can result in huge reductions in processing time for large databases that have control variables. Codebook Builder and Table Builder (Windows version) In Codebook Builder, when getting or editing conditions (unique values) for a control variable, a count of the number of conditions is displayed on the screen. In Table Builder, this count is shown on the "About var-name" screen when control variable information is displayed. HTML Output In exported HTML tables, you can control alignment in data cells by using TEXT masks. For regular masks, the data are still right-aligned to maintain alignment of decimal positions. For multi-page tables, there are additional footnote controls. You can request that footnotes be displayed at the bottom of each page rather than only on the last page of the table and delete the built-in footnote that says, "See footnotes at end of table.". TPL Scripts for Running Batch Jobs (Windows version) You can now set up a script with % substitution arguments. These substitutions let you run the same sequence of jobs for different files by passing file names, or parts of file names, to be substituted in the script. For ODBC databases, new arguments let you specify ODBC database information in a script so that you can run the script without being prompted for the ODBC Data Source, user name, or password.

Features New to Version 5.1.4

[to download page]