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

KDE vs GNOME vs XFCE Desktop

Over many years, many people spent a long time with Linux desktop using either KDE or GNOME. These two environments have grown through the previous years and each of these desktops continued to expand their current user-base. For example, sleeper desktop environment has been XFCE as XFCE offers more robustness than LXDE that lacks much of XFCE’s polish in the default configuration. The XFCE provides all benefits which users enjoyed in the GNOME 2, but with some lightweight experiences which made it a hit on the older computers. Read more

Being Thankful for Open Source Software

At the end of every year I always like to donate some small amount of money to the open source projects I spend the most time using. If everyone donated even 1/10th of the money free software saved them each year to the projects that they use, I have no doubt that a lot more open source software would exist today. Read more

IO Visor: Bringing the Network to the Linux Kernel

The IO Visor project is a Linux Foundation Collaborative Project chartered to create an open source, technical community where industry participants easily contribute to and adopt the IO Visor project's technology for an open programmable data plane for modern IO and networking applications. Read more

2015: The very best Android smartphones

2015 has been an epic year for Android smartphones, and we're closing off the year with nine awesome devices from a range of manufacturers. Read more