The MROUND function allows you to round to any value you want and is particularly useful in financial/commerce applications where rounding to the nearest nickel/dime/quarter is required. This function is only available if Analysis AddIn is installed. It rounds the target value to any multiple that you specify.
To round the value in A1 to the nearest nickel we use =MROUND(A1; 0.05)
Unlike the equivalent Excel function, MROUND in Calc allows negative numbers.
In fact, MROUND() is so useful – it can even be used to round the time to the nearest quarter hour. An example of this is shown below.
Version 2.0 of OOo Calc will feature significant improvements to the DataPlot functionality. For this reason, we will revisit this powerful feature over the next few days.
First, the basics…
Consider the table of data below. There are numerous ways we may want to analyse this data. By using the DataPilot functionality in OOo Calc, we can perform the different analyses quite easily – with a bit of practice.
We first select the table we wish to analyze. Then Data-DataPilot-Start as is illustrated below.
We first are presented with the popup dialog below. We have already selected the data we are interested in – so we just select OK.
The next dialog box allow us to choose the layout of the DataPilot table. In our example, we are interested in knowing how each broker performed in each exchange.
Normally, at least one of the columns in our data source is numerical data that will be processed against the variables we are interested in.
Finally, we get to decide how the data is processed against the input variables. By default, the data is SUMmed, but that may not necessarily always be the case. This dialog is activated by double-clicking on the data field button.
Finally, the output DataPIlot table (or Pivot Table in Excel speak). It isplaced by OOo Calc just below the original data in this example.
I have plans to implement a Keno game in the OOo basic language – but first a simple Lotto number generator. If you go into the source, you can configure to your own requirements. Generating a random number between 1 and 49 is really simple. Making sure that number has not already been picked slightly complicates matters.
How many of us have paid any attention to the row of small windows at the bottom of the OpenOffice Calc window? In this article, we will explore the Status Bar in more depth.
The Status Bar displays information about the current sheet. It is shown below in the default configuration with the different fields tagged.
The fields in the default configuration are:
1 : Position The number of the current sheet and the total number of sheets in the document.
2 : Page Style The Page Style of the currently open sheet. You can double-click in this field to call up the Page Style Editor.
3 : Zoom The current page display zoom factor.
4 : Insert Mode The current insert mode. This field is active when the cursor is in the input line of a formula or cell. By clicking in this field, you can toggle between INSRT = insert and OVER = overwrite.
5 : Selection Mode The current selection mode. By clicking in this field, you can toggle between STD = Standard (default), EXT = Extend and ADD = Add.
6 : Modified Flag If modifications to the current document have not been saved, a * is displayed here.
7 : Formula A basic evaluation of a simple formula for the currently selected range is displayed here. Default is SUM
The Status Bar can be customized by clicking Tools – Configure and selecting the Status Bar tab. The Status Bar configurtion dialog window is shown below.