DataPilot Tools for OpenOffice.org Calc

Adds some utility functions that make the life with DataPilots easier:

  • Display the current source range for a DataPilot
  • Change the source range for a DataPilot
  • Refresh all DataPilots on the current sheet

NEW in rel. 0.5.0: The functions are now in the menu Data -> DataPilot

DataPilotTools extends the DataPilot Menu
Wersja: 0.5.0
Data: 2009-VI-18
Licencja: opensource
(4 głosy)

Get Stock Price

This OO Calc Extension adds the GETPRICE function to the "Financial" category. This function returns the price of a stock using a service provided by YAHOO! Finance.

Example 1: Cell A1 contains =GETPRICE("HON"), and displays 35.6

Wersja: 0.0.2
Data: 2009-VI-20
Licencja: freeware
(8 głosów)

Magenta Anonymous

This little extension gives you an extra entry in the files menu Remove user information that removes all information about the user and user opdates from the current document. This is handy, if you send documents to others but don't want your personal information to be stored in the document.

This extension requires OpenOffice.org 3.1 or higher.

Magenta icon
Wersja: 20090629.0.1
Data: 2009-VI-29
Licencja: opensource
(0 głosów)

3-Period Balance Sheet Template for Open Office Calc

The Balance Sheet Template for Open Office is an Open Office template (Calc) for practitioners who wish to perform their own valuation and analysis but don't wish to invest the significant time necessary to create the financial statements.

It is designed to accommodate three periods of data, which can be entered from a firm's 10-K or 10-Q report (10-K and 10-Q reports are publicly available reports detailing a company's financial position). The spreadsheet comes pre-configured to accept the most popular asset and liability categories, and is easily expandable by anyone with a basic knowledge of Open Office Calc.

A common-size balance sheet is automatically calculated based on the input from the 10-K and 10-Q reports. (Common-size balance sheets are used to show the percentage of total assets and liabilities represented by each item in the balance sheet.)

Date and number fields may be re-formatted by the user (using Open Office Calc's built-in formatting capabilities) to accommodate non-US conventions.

The Balance Sheet Template for Open Office is an excellent tool to use as a basis for business valuation.

This Open Office template was developed by a CFA charterholder.

(3 głosy)

Numbertext

NUMBERTEXT and MONEYTEXT are spreadsheet functions for number to number name and currency name conversion proposed for OpenFormula standard. MONEYTEXT is functionally top-compliant with the ECMA/ISO standard BAHTTEXT function.

Wersja: 0.7.1
Data: 2009-XI-13
Licencja: opensource
(8 głosów)

decroise

transpose un tableau 2D ( avec 1 ou plusieurs ligne et colonnes d'entetes et supportant les cellules fusionnées en entete ) en une source de donnée (1D) utilisable pour les TCD ( pilote de données ) ou importation en BDD

unpivot a 2D tab with multiple header ( including merge celll ) into single data line format for data pilot (pivottable) or db import

instalation et mode d'emploi :

Capture1.png
Wersja: 1.8.2
Data: 2009-kw.-28
Licencja: opensource
(3 głosy)

EuroOffice Chart Map Professional

EuroOffice Chart Map Professional is a new chart type integrated into OpenOffice.org Calc and through the Sun Report Builder into OpenOffice.org Base that makes it possible to visualize geographically related data. Showcase your statistics over detailed maps of European regions, the United States or the world!

diagram_rainbow_pie.png
Wersja: 2.4.3
Data: 2009-X-31
Licencja: commercial
(0 głosów)

EuroOffice Chart Map

EuroOffice Chart Map is a new chart type integrated into OpenOffice.org Calc and through the Sun Report Builder into OpenOffice.org Base that makes it possible to visualize geographically related data. Showcase your statistics over detailed maps of the world!

diagram_rainbow_pie_0.png
Wersja: 2.4.3
Data: 2009-X-30
Licencja: freeware
(0 głosów)

OOcalc_multiple_sheets_export

This macro opens all calc files in one directory, and export each sheet of each file to one individual .csv file, named : filename_sheetname.csv

It is easy to customize to import/export from/to other format that OO can manage.

its is mostly copied from
http://www.oooforum.org/forum/viewtopic.phtml?p=194938#194938

Wersja: 0.9
Data: 2009-III-23
Licencja: opensource
(2 głosy)

Thousands Separator

Add the missing thousands separator button to OpenOffice.org Calc toolbar.

teaser-thousandseparator_0.png
Wersja: 1.0.1
Data: 2009-maj-12
Licencja: opensource
(2 głosy)
Subskrybuj zawartość