Language Selection

English French German Italian Portuguese Spanish

OpenOffice.org Calc: Pivot tables by another name

Filed under
OOo

DataPilots are OpenOffice.org 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

Nvidia 361.45.11 Graphics Driver Released for Linux, FreeBSD and Solaris Systems

Today, May 24, 2016, Nvidia released a new long-lived graphics drivers for Unix users, version 361.45.11, available now for GNU/Linux, FreeBSD, and Solaris operating systems. Read more Also: New NVIDIA 361 Linux Driver Released

Android Leftovers

NVIDIA vs. AMD OpenGL & Vulkan Benchmarks With Valve's Dota 2

Yesterday marked the public availability of Dota 2 with a Vulkan renderer after Valve had been showing it off for months. This is the second commercial Linux game (after The Talos Principle) to sport a Vulkan renderer and thus we were quite excited to see how this Dota 2 Vulkan DLC is performing for both NVIDIA GeForce and AMD Radeon graphics cards. Here are our initial Dota 2 benchmarks with Vulkan as well as OpenGL for reference when using the latest Linux graphics drivers on Ubuntu. Read more

Why Hyperledger wants to be the ‘Linux of blockchain’

Blockchain technology offers many different benefits to enterprise developers — but there’s no cross-industry open standard for how to develop it. That makes it difficult for vendors and CIO customers to place their bets and begin building it into their technology architecture. Hyperledger, a Linux Foundation project to produce a standard open-source blockchain, wants to solve that problem, and it just got an executive director, Brian Behlendorf, to help it on its way. He founded the Apache Software Foundation, was previously on the board of the Mozilla Foundation and the Electronic Frontier Foundation, and managed tech VC firm Mithril Capital Management. Read more