TPL Tables

TPL Tables

TPL Tables is a cross tabulation system used to generate statistical tables for analysis or publication.Infobox_Software| name = TPL Tables
developer = QQQ Software, Inc.
latest_release_version = 6.0
latest_release_date = 2006
operating_system = Microsoft Windows, Unix, Linux
genre = Data analysis, Data Publishing
license = Proprietary
website= [http://www.qqqsoftware.com www.qqqsoftware.com]

Background / History

TPL Tables has its roots in the Table Producing Language (TPL) system, developed at the Bureau of Labor Statistics (BLS) in the 1970s and early 1980s to run on IBM mainframes. [Mendelssohn. 1974. Description of an early version.] It was one of the first software languages that was task oriented rather than procedure oriented. To create a table in TPL, the user needed to specify his data and describe what his table should look like. He did not need to write procedures to create the table. This was in sharp contrast to the Cobol and PL/1 programs people were using at BLS to create tables before TPL. When statistical offices began moving to databases, TPL extended its non-procedural model to database access [http://portal.acm.org/citation.cfm?id=1115964]

The mainframe software gained international popularity during its time, particularly in government statistical offices [Survey Data Processing: A Review of Issues and Procedures. 1982: 84, 129.] , but at a substantial number of other sites as well. The BLS version of TPL was distributed by the United Nations. When TPL evolved into a commercial product, the UN connections remained. This led to such diverse customers as the census of the Comoros Islands [Population 600,000] and the census of the Peoples Republic of China [Population > 1,000,000,000]

BLS ceased major software development of the software in the early to mid-1980s. At that time, two developers of the mainframe product founded QQQ Software, Inc. [http://qqqsoftware.com/] and began development of TPL Tables, rewriting the system for PCs and Unix systems. The first version of TPL Tables was released in 1987. The current version is 6.0.

Uses

TPL Tables is used with many different types of data, from small surveys or other datasets to national level censuses. Its many formatting features allow creation of publication quality output that can be published on paper or on the web.

Text or Interactive Mode

TPL Tables has a language for specifying tabulations and controlling format details. This language is the same for both Windows and Unix versions of the software. The Windows version also has an interactive interface that can access most features and includes Ted, an editor used to display PostScript tables on the screen and edit them interactively.

Tabulation Features

TPL Tables can process an unlimited amount of data and produce tables that range in size from a few lines to hundreds of pages. Subsets of the data can be selected and new variables can be computed from incoming data or from tabulated values. Alternate computations can be performed depending on specified conditions being met. New variables can also be defined by recoding or grouping values of other variables. Table rows can be ordered (ranked) according to the values in a selected column. Other computational features include percent distributions, maximums, minimums, medians and other quantiles. Weighted values can be tabulated.

Inputs

TPL Tables can read files with data in fixed columns or delimited file types such as CSV Comma Separated Values . TPL-SQL, an optional add-on feature, provides direct access from TPL Tables to SQL databases produced by products such as Sybase and Oracle. In the Windows version, TPL-SQL can access databases for which there are ODBC drivers.

Outputs

TPL Tables automatically formats table output according to the table specification, available names and labels, and default settings. Tables can be created in PostScript or as text. Additional format features allow control of such things as page size, table orientation and column widths Rows or columns can be deleted, and labels and titles can be replaced. Display formats for data values can include alignment specifications and addition of special characters such as % and $. Footnotes can be included for both labels and data values. PostScript tables can contain proportional fonts in various styles and sizes.

Exports

Tables can be exported as PDF, HTML, or CSV. The Windows version also allows tables to be exported for use as input to PC-Axis [http://www.pc-axis.scb.se/] .

External links

* Home page for QQQ Software, Inc. and TPL Tables [http://qqqsoftware.com]
* QQQ Software, Inc. download page [http://www.qqqsoft.com/html/download/index.html] . Contains various documentation files, including the TPL Tables, Version 6.0 User Manual in PDF format.
* TPL Tables, The Professional Cross Tabulation System, Version 6.0, 2006, QQQ Software, Inc. Printed version of the user manual available from ondemandmanuals.com [http://www2.ondemandmanuals.com/4dcgi/odmdosearch?title=&author=&subject=&aisle=QQQ+Software&keyword=&user=] .

Notes

References

* Mendelssohn, Rudolph C., [http://portal.acm.org/citation.cfm?id=800182.810390 The Bureau of Labor Statistics' Table Producing Language (TPL)] , ACM Press, New York, NY, 1974
* [http://unstats.un.org/unsd/publication/unint/DP_UN_INT_81_041_1.pdf Survey Data Processing: A Review of Issues and Procedures] , United Nations Department of Technical Co-operation for Development and Statistical Office, New York, 1982


Wikimedia Foundation. 2010.

Игры ⚽ Поможем решить контрольную работу

Look at other dictionaries:

  • TPL — may refer to: * Toronto Public Library * Temporal Process Language * Third party logistics provider * The Trust for Public Land * Table Producing Language * TPL Tables * Trasporti pubblici luganesi, the public (bus) transportation system in… …   Wikipedia

  • Contingency table — In statistics, a contingency table (also referred to as cross tabulation or cross tab) is a type of table in a matrix format that displays the (multivariate) frequency distribution of the variables. It is often used to record and analyze the… …   Wikipedia

  • Table Producing Language — was a IBM mainframe program developed by the US Bureau of Labor Statistics for producing statistical tables. It has been superseded by the commercial product TPL Tables developed by QQQ Software. External links* [http://qqqsoftware.com QQQ… …   Wikipedia

  • Oxygene (programming language) — Oxygene Developer RemObjects Software Stable release 3.0.21 (August 29, 2009; 2 years ago (2009 08 29)) Influenced by Object Pas …   Wikipedia

  • United Kingdom — a kingdom in NW Europe, consisting of Great Britain and Northern Ireland: formerly comprising Great Britain and Ireland 1801 1922. 58,610,182; 94,242 sq. mi. (244,100 sq. km). Cap.: London. Abbr.: U.K. Official name, United Kingdom of Great… …   Universalium

  • Extensible Storage Engine — For JET Red storage engine of Microsoft Access, see Microsoft Jet Database Engine. For the teacher s term, Exceptional education. Extensible Storage Engine (ESE), also known as JET Blue, is an Indexed Sequential Access Method (ISAM) data storage… …   Wikipedia

  • Wooden toy train — Wooden toy trains are a system of small toy trains that run on wooden track. The tracks feature grooves which serve to guide the wheels of rolling stock. Traditionally parts are made of hardwoods which resemble anthropomorphical, fictional, and… …   Wikipedia

  • Traffic Message Channel — (TMC) is a technology for delivering traffic and travel information to drivers. It is typically digitally coded using the FM RDS system on conventional FM radio broadcasts. It can also be transmitted on DAB or satellite radio.It allows silent… …   Wikipedia

  • Copix — Développeur CopixTeam Dernière version …   Wikipédia en Français

  • Atlanta, Georgia — Infobox Settlement official name = City of Atlanta settlement type = City nicknames = Hotlanta, [cite web | last = Shelton | first = Stacy | title = Hotlanta not steamiest in Georgia this summer | publisher = The Atlanta Journal Constitution |… …   Wikipedia

Share the article and excerpts

Direct link
Do a right-click on the link above
and select “Copy Link”