Language Selection

English French German Italian Portuguese Spanish Calc: Pivot tables by another name

Filed under

DataPilots are Calc's equivalent of what MS Excel and other spreadsheets call pivot tables. Under any name, they are a tool for extracting and summarizing the information contained in spreadsheet cells in a more convenient form. Using a DataPilot, you can immediately see relationships between different pieces of data that would be difficult -- if not impossible -- to find using formulas, and tedious to extract manually. In effect, a DataPilot gives you something of the power of using a database without actually switching out of a spreadsheet. Small wonder, then, that over half of spreadsheet users are said to use datapilots or pivot tables.

To understand the usefulness of DataPilots, imagine that you are a manufacturer selling Ogg Vorbis music players in the North American market. Your product comes in two colors, beige and black, and in 80, 150 and 300 megabyte sizes, and is sold in sales packs. For each sale, you record the number of display packs sold, and the total price. On a spreadsheet, some of your data might look like this:

More Here

Also: Pump up the Format Paintbrush with a double-click

More in Tux Machines

Android Leftovers

LG releases webOS Open Source Edition, looks to expand webOS usage

LG’s smart TVs ship with an operating system called webOS, which is the latest version of an operating system that was developed by Palm to run on phones, acquired by HP to use with tablets, and eventually sold to LG, which is still using it today. But now LG wants to expand the adoption of webOS and the company is working with the South Korean government to solicit business proposals from other companies interested in using webOS. LG has also released a webOS Open Source Edition version of the operating system. Read more

Test driving 4 open source music players and more

In my last article, I described my latest music problem: I need an additional stage of amplification to make proper use of my new phono cartridge. While my pre-amplifier contains a phono stage, its gain is only suitable for cartridges that output about 5mV, whereas my new cartridge has a nominal output of 0.4mV. Based on my investigation, I liked the looks of the Muffsy phono kits, so I ordered the head amplifier, the power supply, and the back panel. I also needed to obtain a case to hold the boards and the back panel, available online from many vendors. Muffsy does not sell the “wall wart” necessary to power the unit, so I ordered one of those from a supplier in California. Finally, inspecting my soldering iron, solder “sucker,” and solder, I’ve realized I need to do better—so a bit more shopping, online or local, is in order there. Finally, for those, like me, whose soldering skills may be rusty and perhaps were not all that great to begin with, Muffsy kindly offers links to two instructional videos. Read more

Today in Techrights