Pivot table

In data processing, a pivot table is a data summarization tool found in data visualization programs such as spreadsheets or business intelligence software. Among other functions, a pivot table can automatically sort, count total or give the average of the data stored in one table or spreadsheet, displaying the results in a second table showing the summarized data. Pivot tables are also useful for quickly creating unweighted cross tabulations. The user sets up and changes the summary's structure by dragging and dropping fields graphically. This "rotation" or pivoting of the summary table gives the concept its name.

The term pivot table is a generic phrase used by multiple vendors. In the United States, Microsoft Corporation has trademarked the specific compound word form, PivotTable.

Pivot tables can be seen as a simplification of the more complete and complex online analytical processing concepts (OLAP).

History

In their book Pivot Table Data Crunching, Bill Jelen and Mike Alexander refer to Pito Salas as the "father of pivot tables". While working on a concept for a new program that would eventually become Lotus Improv, Salas noted that spreadsheets have patterns of data. A tool that could help the user recognize these patterns would help to build advanced data models quickly. With Improv, users could define and store sets of categories, then change views by dragging category names with the mouse. This core functionality would provide the model for pivot tables.

The Know

The Know is an Australian talk show on Max. The pop culture show features Yumi Stynes, musician Jimmy Barnes and actress Lisa Hensley as the main show hosts along with former Machine Gun Fellatio keyboardist, Chit Chat Von Loopin Stab. The show discusses and reviews movies, music, television and the creative arts.

Former Panelists

External links

Project Mercury

Project Mercury was the first human spaceflight program of the United States running from 1958 through 1963. An early highlight of the Space Race, its goal was to put a human into Earth orbit and return the person safely, ideally before the Soviet Union. Taken over from the U.S. Air Force by the newly created civilian space agency NASA, it spanned twenty unmanned developmental missions involving test animals, and successful missions completed by six of the seven Mercury astronauts.

The Space Race had begun with the 1957 launch of the Soviet satellite Sputnik 1. This came as a shock to the American public, and led to the creation of NASA to expedite existing U.S. space exploration efforts, and place most of them under civilian control. After the successful launch of the Explorer 1 satellite in 1958, manned spaceflight became the next goal.

The Soviet Union put the first human, cosmonaut Yuri Gagarin, into a single orbit aboard Vostok 1 on April 12, 1961. Shortly after this, on May 5, the U.S. launched its first astronaut, Alan Shepard, on a suborbital flight. Soviet Gherman Titov followed with a day-long orbital flight in August, 1961. The U.S. reached its orbital goal on February 20, 1962, when John Glenn made three orbits around the Earth. When Mercury ended in May 1963, both nations had sent six people into space, but the U.S. was still behind the Soviets in terms of total time spent in space.

Tax form

A tax form is a blank document or template supplied by a government for use in the reporting of tax information to the government or to potential taxpayers. Specific tax forms are intended to be used by taxpayers, the government itself, or private entities that are required to report information on the tax liabilities of other private entities. Entities fill out the form and file it with the government as a tax return.

See also

Mutual fund

A mutual fund is a professionally managed investment fund that pools money from many investors to purchase securities. While there is no legal definition of the term "mutual fund", it is most commonly applied only to those collective investment vehicles that are regulated and sold to the general public. They are sometimes referred to as "investment companies" or "registered investment companies". Hedge funds are not mutual funds, primarily because they cannot be sold to the general public.

In the United States, mutual funds must be registered with the U.S. Securities and Exchange Commission, overseen by a board of directors or board of trustees, and managed by a Registered Investment Advisor. Mutual funds are subject to an extensive and detailed regulatory regime set forth in Investment Company Act of 1940. Mutual funds are not taxed on their income and profits if they comply with certain requirements under the U.S. Internal Revenue Code.

Mutual funds have both advantages and disadvantages compared to direct investing in individual securities. Today they play an important role in household finances, most notably in retirement planning.