{{short description|Late 19th-century machine for summarizing information stored on punch cards}} thumb|Hollerith 1890 tabulating machine with sorting box.{{efn|The "sorting box" was controlled by the tabulator. The "sorter", an independent machine, was a later development. See: {{cite book |last=Austrian |first= Geoffrey D. |title= Herman Hollerith: Forgotten Giant of Information Processing |publisher= Columbia University Press |year= 1982 |isbn= 0-231-05146-8 |pages = 41, 178–179}}}} right|thumb|Hollerith punched card
The '''tabulating machine''' was an electromechanical machine designed to assist in summarizing information stored on punched cards. Invented by Herman Hollerith, the machine was developed to help process data for the 1890 U.S. Census. Later models were widely used for business applications such as accounting and inventory control. It spawned a class of machines, known as unit record equipment, and the data processing industry.
The term "Super Computing" was used by the ''New York World'' newspaper in 1931 to refer to a large custom-built tabulator that IBM made for Columbia University.<ref>{{cite book |last=Eames |first=Charles |author2=Eames, Ray |title=A Computer Perspective |year=1973 |publisher=Harvard University Press |location= Cambridge, Mass |page = 95 }} The 1920 date on page 95 is incorrect, see [http://www.columbia.edu/cu/computinghistory/packard.html The Columbia Difference Tabulator - 1931]</ref> <!--- from Supercomputing --->
==1890 census== The tabulating machine emerged in response to difficulties processing the rapidly growing volume of census data in the United States. In the census of 1860 the population was compiled under 14 age groups, in 1870 the ages were tallied under 25 groups, while in 1880 the census office, in compliance with numerous requests, tabulated the population with over 100 specifications. Each year the problem of compiling a census became more difficult. <ref>{{cite journal |last=Hollerith |first=Herman |title=An Electric Tabulating System |journal=The Quarterly, Columbia University School of Mines |volume=X |issue=16 |date=April 1889 |pages=238–255 |url=https://www.columbia.edu/cu/computinghistory/hh/index.html}}</ref> Since the U.S. Constitution mandates a census every ten years to apportion both congressional representatives and direct taxes among the states, a combination of larger staff and faster-recording systems was needed.The 1880 census required eight years to fully process, raising concerns that future censuses might not be completed before the next constitutionally mandated census was due.''' <ref>U.S. Census, 1880#Results</ref> '''John Shaw Billings, a physician and statistician serving as a director of the 1880 census, is credited with suggesting to Herman Hollerith that a machine modeled on the Jacquard loom (an automatic weaving device controlled by punched cards) could accelerate data processing. <ref>{{cite web |title=Mathematical Treasure: Scientific American on Hollerith's Tabulator |publisher=Mathematical Association of America |url=https://old.maa.org/press/periodicals/convergence/mathematical-treasure-scientific-american-on-holleriths-tabulator}}</ref>
In the late 1880s Herman Hollerith, inspired by conductors using holes punched in different positions on a railway ticket to record traveler details such as gender and approximate age, invented the recording of data on a machine-readable medium. Prior uses of machine-readable media had been for lists of instructions (not data) to drive programmed machines such as Jacquard looms. "After some initial trials with paper tape, he settled on punched cards..."<ref>{{Cite web|url=http://www.columbia.edu/cu/computinghistory/hollerith.html|title=Herman Hollerith Tabulating Machine|website=www.columbia.edu}}</ref> Hollerith used punched cards with round holes, 12 rows, and 24 columns. The cards measured {{convert|3+1/4|by|6+5/8|in|mm}}.<ref name= HollerithRSS /> His tabulator used electromechanical solenoids to increment mechanical counters. A set of spring-loaded wires were suspended over the card reader. The card sat over pools of mercury, pools corresponding to the possible hole positions in the card. When the wires were pressed onto the card, punched holes allowed wires to dip into the mercury pools, making an electrical contact<ref>{{cite book |last=Truesdell |first=Leon E.|author1-link=Leon E. Truesdell|title= The Development of Punch Card Tabulation in the Bureau of the Census 1890-1940|year=1965|publisher=US GPO |page = 51}}</ref><ref>[http://www.columbia.edu/cu/computinghistory/census-tabulator.html Hollerith 1890 Census Tabulator] Columbia University Computing History</ref> that could be used for counting, sorting, and setting off a bell to let the operator know the card had been read. The tabulator had 40 counters, each with a dial divided into 100 divisions, with two indicator hands; one which stepped one unit with each counting pulse, the other which advanced one unit every time the other dial made a complete revolution. This arrangement allowed a count of up to 9,999. During a given tabulating run, counters could be assigned to a specific hole or, by using relay logic, to a combination of holes, e.g. to count married couples.<ref name=minesquarterly>{{Cite web|url=http://www.columbia.edu/cu/computinghistory/hh/index.html#%5B-245-]|title=AN ELECTRIC TABULATING SYSTEM|website=www.columbia.edu}}</ref> If the card was to be sorted, a compartment lid of the sorting box would open for storage of the card, the choice of compartment depending on the data in the card.<ref>{{Cite web|url=https://www.ibm.com/ibm/history/exhibits/attic/attic_071.html|title=IBM Archives: Hollerith Tabulator and Sorter Box|date=January 23, 2003|website=www.ibm.com}}</ref>
Before the Census Bureau committed to Hollerith's system, it organized a formal competition in 1888 to evaluate rival approaches. Three systems were tested against each other on sample census data. Charles F. Pidgin, chief clerk of the Massachusetts Bureau of Labor Statistics, proposed a method based on color-coded cardboard chips on which census information was recorded using symbols representing different attributes. These chips were then physically sorted and counted, and a similar approach had previously been used in the 1885 Massachusetts State Census. William C. Hunt, who had also worked on the Massachusetts census, developed a simplified variation of this idea that used paper slips marked with colored inks instead of chips. Herman Hollerith, who had previously worked with the Census Office in 1880, proposed an electromechanical tabulating system that used punched cards. He had already applied similar methods to mortality statistics in several U.S. cities during the late 1880s.<ref>{{cite book |last=Truesdell |first=Leon Edgar |title=The Development of Punch Card Tabulation in the Bureau of the Census, 1890–1940: With Outlines of Actual Tabulation Programs |publisher=U.S. Department of Commerce, Bureau of the Census |year=1965 |url=https://books.google.com/books?id=tncFwqUew_EC}}</ref>
In performance tests, Hollerith completed the data capture phase in 72.5 hours, compared to 100.5 and 144.5 hours for the competing systems. For preparation of data for tabulation, his system required 5.5 hours, while the others required 44.5 and 55.5 hours respectively. The results were decisive, and the Census Bureau awarded Hollerith the contract. The trial is often described as one of the earliest formal government benchmarks for evaluating computational data processing systems, marking a significant milestone in the history of modern information processing.<ref>{{cite web |title=The Punched Card Tabulator |publisher=IBM |url=https://www.ibm.com/history/punched-card-tabulator}}</ref><ref>{{cite book |last=Cortada |first=James W. |year=1993 |title=Before the Computer: IBM, NCR, Burroughs, and Remington Rand and the Industry They Created, 1865–1956 |publisher=Princeton University Press |isbn=0-691-04807-X |page=48}}</ref>
Clerks used keypunches to punch holes in the cards entering age, state of residence, gender, and other information from the returns. Some 100 million cards were generated and "the cards were only passed through the machines four times during the whole of the operations."<ref name= HollerithRSS>*{{cite journal |last= Hollerith |first= Herman |title= The Electric Tabulating Machine |journal = Journal of the Royal Statistical Society |volume= 57 |issue= 4 |date=December 1894 |pages = 678–682 |doi = 10.2307/2979610 |jstor = 2979610 |publisher= Blackwell Publishing|url= https://zenodo.org/record/1449699 |quote= From (Randell, 1982) ''... brief... fascinating article... describes how tabulators and sorters were used on ... 100 million cards ... 1890 census.''}}</ref> According to the U.S. Census Bureau, the census results were "... finished months ahead of schedule and far under budget."<ref>{{cite web|url = https://www.census.gov/history/www/technology/010873.html |archive-url = https://web.archive.org/web/20090719073019/https://www.census.gov/history/www/technology/010873.html |archive-date = 19 July 2009|title = Tabulation and Processing|website = History|publisher = U.S. Census Bureau|date = 22 June 2009}}</ref> thumb|Cover of the August 30, 1890, Scientific American
The tabulating system also changed the organization of census labor. Large numbers of clerks were employed to transfer information from census returns onto punched cards using keypunch machines. Contemporary illustrations, including the August 30, 1890, cover of ''Scientific American'', depicted both male and female workers seated at rows of card-punch machines in large open rooms.<ref>{{cite web |title=Mathematical Treasure: Scientific American on Hollerith's Tabulator |publisher=Mathematical Association of America |url=https://old.maa.org/press/periodicals/convergence/mathematical-treasure-scientific-american-on-holleriths-tabulator}}</ref> Historians have described this system as an early form of large-scale clerical data processing that influenced later office and government record-keeping practices.<ref>{{cite book |last=Austrian |first=Geoffrey D. |year=1982 |title=Herman Hollerith: Forgotten Giant of Information Processing |publisher=Columbia University Press |isbn=0-231-05146-8}}</ref>
==Following the 1890 census== The commercial success of the 1890 census led to increased demand for punched-card tabulating systems in both government and business applications. During preparations for the 1900 census, disagreements arose between Hollerith and the Census Bureau regarding the cost of leasing tabulating equipment. The Census Bureau later supported the development of alternative tabulating systems, including those designed by James Legrand Powers, a former Census Bureau employee.<ref>{{cite book |last=Austrian |first=Geoffrey D. |year=1982 |title=Herman Hollerith: Forgotten Giant of Information Processing |publisher=Columbia University Press |isbn=0-231-05146-8}}</ref> Powers subsequently developed punched-card machines that were used during the 1910 United States Census.
The advantages of the technology were immediately apparent for accounting and tracking inventory. Hollerith started his own business as ''The Hollerith Electric Tabulating System'', specializing in punched card data processing equipment.<ref>{{cite book |last= Austrian |first=Geoffrey D. |title= Herman Hollerith: The Forgotten Giant of Information Processing |publisher= Columbia University Press |year= 1982 |page= 153 |isbn= 0-231-05146-8}}</ref> In 1896, he incorporated the Tabulating Machine Company. In that year he introduced the Hollerith Integrating Tabulator, which could add numbers coded on punched cards, not just count the number of holes. Punched cards were still read manually using the pins and mercury pool reader. 1900 saw the Hollerith Automatic Feed Tabulator used in that year's U.S. census. A control panel was incorporated in the 1906 Type 1.<ref>{{cite web|website = Columbia University Computing History |url = http://www.columbia.edu/cu/computinghistory/tabulator.html |title = IBM Tabulators and Accounting Machines|date = 26 December 2019 |first = Frank |last =da Cruz}}</ref>
In 1911, four corporations, including Hollerith's firm, were amalgamated (via stock acquisition) to form a fifth company, the Computing-Tabulating-Recording Company (CTR). The Powers Accounting Machine Company was formed that same year and, like Hollerith, with machines first developed at the Census Bureau. In 1919, the first Bull tabulator prototype was developed. Tabulators that could print, and with removable control panels, appeared in the 1920s. In 1924, CTR was renamed International Business Machines (IBM). In 1927, Remington Rand acquired the Powers Accounting Machine Company. In 1933, The Tabulating Machine Company was subsumed into IBM. These companies continued to develop faster and more sophisticated tabulators, culminating in tabulators such as 1949 IBM 407 and 1952 Remington Rand 409. Tabulating machines continued to be used well after the introduction of commercial electronic computers in the 1950s.
Many applications using unit record tabulators were migrated to computers such as the IBM 1401. Two programming languages, FARGO and RPG, were created to aid this migration. Since tabulator control panels were based on the machine cycle, both FARGO and RPG emulated the notion of the machine cycle and training material showed the control panel vs. programming language coding sheet relationships.
==Social impact== The adoption of tabulating machines contributed to changes in office labor during the late nineteenth and early twentieth centuries. Government agencies, insurance companies, railroads, and other large organizations increasingly relied on punched-card systems to efficiently process in influx of information.<ref>{{cite book |last=Campbell-Kelly |first=Martin |title=From Airline Reservations to Sonic the Hedgehog: A History of the Software Industry |publisher=MIT Press |year=2003}}</ref>
The use of punched-card equipment also expanded clerical employment, especially for women who were frequently employed as keypunch operators and data-entry clerks. <ref>{{cite book |last=Yates |first=JoAnne |title=Control through Communication: The Rise of System in American Management |publisher=Johns Hopkins University Press |year=1989 |pages=1–30}}</ref> Historians have described punched-card systems as part of a broader trend toward office mechanization and large-scale record keeping in the early 20th century.<ref>{{cite book |last=Ceruzzi |first=Paul E. |title=A History of Modern Computing |publisher=MIT Press |year=2003}}</ref> Furthermore, the methods developed around tabulating machines later influenced data processing practices used with electronic computers.<ref>{{cite book |last=Austrian |first=Geoffrey D. |year=1982 |title=Herman Hollerith: Forgotten Giant of Information Processing |publisher=Columbia University Press |isbn=0-231-05146-8}}</ref>
==Operation== {{main|Plugboard}} thumb|IBM Type 285<ref>{{cite web |website= Columbia University Computing History |title = The IBM 285 Tabulator |url= http://www.columbia.edu/cu/computinghistory/285.html |first = Frank |last =da Cruz|date= 16 December 2018}}</ref> tabulators in use at U.S. Social Security Administration circa 1936 thumb|Early IBM D11 tabulating machine, with covers removed thumb|Powers-Samas accounting machine In its basic form, a tabulating machine would read one card at a time, print portions (fields) of the card on fan-fold paper, possibly rearranged, and add one or more numbers punched on the card to one or more counters, called accumulators. On early models, the accumulator register dials would be read manually after a card run to get totals. Later models could print totals directly. Cards with a particular punch could be treated as master cards causing different behavior. For example, customer master cards could be merged with sorted cards recording individual items purchased. When read by the tabulating machine to create invoices, the billing address and customer number would be printed from the master card, and then individual items purchased and their price would be printed. When the next master card was detected, the total price would be printed from the accumulator and the page ejected to the top of the next page, typically using a carriage control tape.
With successive stages or cycles of punched-card processing, fairly complex calculations could be made if one had a sufficient set of equipment. (In modern data processing terms, one can think of each stage as an SQL clause: SELECT (filter columns), then WHERE (filter cards, or "rows"), then maybe a GROUP BY for totals and counts, then a SORT BY; and then perhaps feed those back to another set of SELECT and WHERE cycles again if needed.) A human operator had to retrieve, load, and store the various card decks at each stage.
==Selected models and timeline==
Hollerith's first tabulators were used to compile mortality statistics for Baltimore, Jersey City and New York City in 1886.<ref>{{cite web |title=The punched card tabulator |url=https://www.ibm.com/history/punched-card-tabulator |website=ibm.com |publisher=IBM |access-date=19 March 2024}}</ref>
The first Tabulating Machine Company (TMC) automatic feed tabulator, operating at 150 cards/minute, was developed in 1906.<ref>{{Cite web|url=https://www.ibm.com/ibm/history/history/year_1906.html|title=IBM Archives: 1906|date=January 23, 2003|website=www.ibm.com}}</ref>
The first TMC printing tabulator was developed in 1920.<ref>{{cite web |title = IBM Archives: 1920 |date= 23 January 2003 |publisher= IBM |url= http://www-03.ibm.com/ibm/history/history/year_1920.html|archive-url= https://web.archive.org/web/20050117192831/http://www-03.ibm.com/ibm/history/history/year_1920.html|url-status= dead|archive-date= January 17, 2005}}</ref>
TMC Type IV Accounting Machine (later renamed the IBM 301), from the [https://web.archive.org/web/20041217213509/http://www-03.ibm.com/ibm/history/reference/faq_0000000011.html IBM Archives]: <blockquote>The 301 (better known as the ''Type IV'') Accounting Machine was the first card-controlled machine to incorporate class selection, automatic subtraction, and printing of a net positive or negative balance. Dating to 1928, this machine exemplifies the transition from tabulating to accounting machines. The Type IV could list 100 cards per minute.</blockquote>
[http://www.feb-patrimoine.com/projet/bull_t30/tabu_t30.htm H.W.Egli - BULL Tabulator model T30], 1931
IBM 401: <blockquote>The 401, introduced in 1933, was an early entry in a long series of IBM alphabetic tabulators and accounting machines. It was developed by a team headed by J. R. Peirce and incorporated significant functions and features invented by A. W. Mills, F. J. Furman and E. J. Rabenda. The 401 added at a speed of 150 cards per minute and listed alphanumerical data at 80 cards per minute.<ref>{{Cite web|url=https://www.ibm.com/ibm/history/reference/faq_0000000011.html|title=IBM Archives -- FAQ's for Products and Services|website=www.ibm.com|date=11 June 2001 }}</ref></blockquote>
IBM 405: <blockquote>Introduced in 1934, the 405 Alphabetical Accounting Machine was the basic bookkeeping and accounting machine marketed by IBM for many years. Important features were expanded adding capacity, greater flexibility of counter grouping,{{efn|Later IBM tabulators provided multiple, small, counters of 2 to 8 positions. When a larger counter was needed multiple counters could be grouped to function as a single counter. For example, a control panel could be wired to group a 4 position and a 6 position counter, forming a 10 position counter.}} direct printing of the entire alphabet, direct subtraction{{efn|Before direct subtraction was available, negative numbers were entered as complements or were listed and totaled in separate columns.}} and printing of either debit or credit balance from any counter. Commonly called the 405 "tabulator," this machine remained the flagship of IBM's product line until after World War II.<ref>{{Cite web|url=http://www.columbia.edu/cu/computinghistory/405.html|title=IBM Archives: IBM Type 405 Alphabetic Accounting Machine|date=2001}}</ref><ref>{{Cite web|url=https://www.ibm.com/ibm/history/exhibits/attic3/attic3_049.html|title=IBM Archives: IBM Type 405 Alphabetic Accounting Machine|date=January 23, 2003|website=www.ibm.com}}</ref> The British at Hut 8 used Hollerith machinery to gain some knowledge of Known-plaintext attack cribs used by encrypted German messages.<ref>{{Cite web|url=http://www.ellsbury.com/hut8/hut8-021.htm|title=The History of Hut Eight}}</ref></blockquote>
IBM 402 and 403, from 1948, were modernized successors to the 405. thumb|250px|Control panel for an IBM 402 Accounting Machine <!-- Added from Computer Programming -->
<blockquote>The 1952 Bull Gamma 3 could be attached to this tabulator or to a card read/punch.<ref>{{Cite web|url=https://technikum29.de/en/computer/tabulating-machine|title=BULL Tabulating machine - technikum29|website=technikum29.de}}</ref><ref>{{Cite web|url=https://technikum29.de/en/computer/gamma3|title=A first generation tube calculator: BULL GAMMA 3 - technikum29|website=technikum29.de}}</ref></blockquote>
IBM 407<blockquote>Introduced in 1949, the 407 was the mainstay of the IBM unit record product line for almost three decades. It was later adapted to serve as an input/output peripheral for several early electronic calculators and computers. Its printing mechanism was used in the IBM 716 line printer for the IBM 700/7000 series and later with the IBM 1130 through the mid-1970s.</blockquote> <blockquote>The IBM 407 Accounting Machine was withdrawn from marketing in 1976, signaling the end of the unit record era.<ref>{{Cite web|url=https://www.ibm.com/ibm/history/exhibits/vintage/vintage_4506VV4007.html|title=IBM Archives: IBM 407 accounting machine|date=January 23, 2003|website=www.ibm.com}}</ref></blockquote>
==See also== * {{section link|List of IBM products|Tabulators, accounting machines, printers}} * British Tabulating Machine Company * Powers Accounting Machine Company, Powers Accounting Machine * Powers-Samas Accounting Machines Ltd aka. "Acc and Tab"
For early use of tabulators for scientific computations see
* Leslie Comrie * Wallace John Eckert
== Notes == {{Notelist}}
==References== {{reflist}}
==Further reading== *{{cite book |last= Fierheller |first= George A. |title= Do not fold, spindle or mutilate: the "hole" story of punched cards |publisher= Stewart Pub. |year= 2014 |isbn= 978-1-894183-86-4 |url =http://www.gfierheller.ca/wp-content/uploads/2014/02/Do-Not-Fold-Feb-7-2014-web.pdf|archive-url=https://web.archive.org/web/20160324204616/http://www.gfierheller.ca/wp-content/uploads/2014/02/Do-Not-Fold-Feb-7-2014-web.pdf|archive-date=2016-03-24}} An accessible book of recollections (sometimes with errors), with photographs and descriptions of many unit record machines. The chapter ''It all adds Up'' describes IBM tabulators and accounting machines. *{{cite journal |last= Kistermann |first= F.W. |title= The way to the first automatic sequence-controlled calculator: the 1935 DEHOMAG D 11 tabulator |journal= Annals of the History of Computing |volume= 17 |issue= 2 |date= Summer 1995 |pages= 33–49 |doi = 10.1109/85.380270}} *{{cite book |editor-last= Randell |editor-first= Brian |title= The Origins of Digital Computers, Selected Papers, 3rd ed |publisher= Springer-Verlag |year= 1982 |isbn = 0-387-11319-3}} Chapter 3, ''Tabulating Machines'', has excerpts of Hollerith's 1889 ''An Electric Tabulating System'' and Couffignal's 1933 ''Calculating Machines: Their Principles and Evolution''. *Black, Edwin (2001) ''IBM and the Holocaust: The Strategic Alliance Between Nazi Germany and America's Most Powerful Corporation,'' Crown Pub, {{ISBN|0-609-80899-0}}''.'' Assiduously footnoted using 20,000 hard copy documents and utilizing over 100 researchers, the book pieces together fragments of information from all of the world deliberately obscured to prevent the exposure of the extent to which IBM president Thomas J. Watson collaborated with the Nazis to identify Jews, locate them, determine what personal effects they owned, what businesses they controlled, their real estate, and anything else of value that could be seized by the Nazis. IBM tabulators also made it possible to move millions of Jews to their deaths in concentration camps using hundreds of thousands of rail cars and tons of coal in a process that would have been impossible without IBM. All the concentration camps contained offices specifically for the running and repair of the IBM tabulators which kept track of the age, gender and manner of death of every inmate. These machines, as well as other used by the German military, were leased to the Nazis in what became millions of dollars of profit for IBM.
==External links== {{commons category|Tabulating machines}} * [http://www.bitsavers.org/pdf/ibm/punchedCard/AccountingMachine IBM Accounting Machine manuals] {{Authority control}}
{{DEFAULTSORT:Tabulating Machine}} Category:Computer-related introductions in 1890 Category:American inventions Category:Mechanical calculators Category:Unit record equipment Category:IBM unit record equipment Category:Punched card