Студопедия
Случайная страница | ТОМ-1 | ТОМ-2 | ТОМ-3
АрхитектураБиологияГеографияДругоеИностранные языки
ИнформатикаИсторияКультураЛитератураМатематика
МедицинаМеханикаОбразованиеОхрана трудаПедагогика
ПолитикаПравоПрограммированиеПсихологияРелигия
СоциологияСпортСтроительствоФизикаФилософия
ФинансыХимияЭкологияЭкономикаЭлектроника

Data Consolidation 101

Spelling out numbers | Datapilot Revisited | DataPilot Revisited II | Ranking and sorting data I | Conditional summation revisited | Regression analysis I : Basic linear formulas | Regression Analysis II : Basic functions, charting | Regression Analysis III : LINEST | Combining data in cells | Date & Time : Calculating Dates of Holidays |


March 22nd, 2005

An introduction to the data consolidation functionality that is built in to OOo Calc. This is a useful feature when merging similar data from different souces.


Consider the example below. We have sales data for each month for different regions. The company has two products, widgets and <gadgets< b=""> Each product’s sales data is on a separate sheet.</gadgets<>

We can use the data consolidation functionality of OOo Calc to combine the two sets of data into a single Totals sheet.

The Totals sheet will have same layout as the Widgets and Gadgets sheets.

The Consolidate data dialog is invoked as shown below.

Any source or result data ranges that will be needed here must be first declared as a named range

The named source data ranges are added - one at a time. Next, the results location is added. Please note while the full ranges of the source data are displayed, only the origin cell of the results is shown. This is probably an OOo Calc bug.

You may also want to check the Link to Source Data checkbox to ensure that the results are updated automatically if the source data changes.

The end result. Note the hidden rows in the sheet - which contain copies of the source data.


Дата добавления: 2015-08-03; просмотров: 51 | Нарушение авторских прав


<== предыдущая страница | следующая страница ==>
Financial Functions 3 : Complex Accumulation| Basic Functions: FREQUENCY

mybiblioteka.su - 2015-2024 год. (0.013 сек.)