Open Office Calc
And they are now ease to create from OpenOffice.org Calc using EuroOffice Sparkline! Sparklines are simple things and now creating them is simple too. Just select the data series you want to use as the basis of the sparkline and click EuroOffice Sparkline in the Insert menu. Additional details of the sparkline can be customized in the. Trusted Windows (PC) download OpenOffice Calc 4.1.6. Virus-free and 100% clean download. Get OpenOffice Calc alternative downloads. This is a free video tutorial I will aim to give you a basic understanding of Open Office 4 – Calc Spreadsheet.The goal of this video tutorial is to give you.
| < Previous Section | Next Section > |
| < Previous Page | Next Page > |
Open Office Calc Formula
Open Office Calc Fit To Page
List of Calc Mathematical functions
| Trigonometric | |
| COS | Returns the cosine of an angle. |
| SIN | Returns the sine of an angle. |
| TAN | Returns the tangent of an angle. |
| COT | Returns the cotangent of an angle. |
| ACOS | Returns the inverse cosine of a number. |
| ACOT | Returns the inverse cotangent of a number. |
| ASIN | Returns the inverse sine of a number. |
| ATAN | Returns the inverse tangent of a number. |
| ATAN2 | Returns the inverse tangent for specified x and y coordinates. |
| DEGREES | Converts radians into degrees. |
| RADIANS | Converts degrees into radians. |
| PI | Returns the value of PI. |
| Hyperbolic | |
| COSH | Returns the hyperbolic cosine of an angle. |
| SINH | Returns the hyperbolic sine of an angle. |
| TANH | Returns the hyperbolic tangent of an angle. |
| COTH | Returns the hyperbolic cotangent of a given number (angle). |
| ACOSH | Returns the inverse hyperbolic cosine of a number. |
| ACOTH | Returns the inverse hyperbolic cotangent of the given number. |
| ASINH | Returns the inverse hyperbolic sine of a number. |
| ATANH | Returns the inverse hyperbolic tangent of a number. |
| Rounding and remainders | |
| TRUNC | Truncates a number by removing decimal places. |
| ROUND | Rounds a number to a certain precision. |
| ROUNDDOWN | Rounds a number down, toward zero, to a certain precision. |
| ROUNDUP | Rounds a number up, away from zero, to a certain precision. |
| CEILING | Returns a number rounded up to a multiple of another number. |
| FLOOR | Rounds a number down to the nearest multiple of another number. |
| EVEN | Rounds a number to the next even integer away from zero. |
| ODD | Rounds a number up to the next highest odd integer. |
| MROUND | Returns a number rounded to the nearest multiple of another number. |
| INT | Rounds a number down to the nearest integer. |
| QUOTIENT | Returns the integer result of a division operation. |
| MOD | Returns the remainder when one integer is divided by another. |
| Logarithm / powers | |
| EXP | Returns e raised to the power of a number. |
| POWER | Returns a number raised to a power. |
| LOG | Returns the natural logarithm of a number. |
| LN | Returns the logarithm of a number to the specified base. |
| LOG10 | Returns the base-10 logarithm of a number. |
| Bessel functions | |
| BESSELI | Calculates the modified Bessel function of the first kind. |
| BESSELJ | Calculates the Bessel function of the first kind. |
| BESSELK | Calculates the modified Bessel function of the second kind. |
| BESSELY | Calculates the Bessel function of the second kind (the Neumann or Weber function). |
| Miscellaneous | |
| ABS | Returns the absolute value of a number. |
| COMBIN | Returns the number of combinations of a subset of items. |
| COMBINA | Returns the number of ordered combinations of a subset of items. |
| CONVERT | Converts between legacy European currencies and Euros. |
| CONVERT_ADD | Converts a number from one measurement system to another. |
| COUNTBLANK | Returns the number of empty cells. |
| COUNTIF | Counts the number of cells in a range that meet a specified condition. |
| DELTA | Returns 1 if two numbers are equal, and 0 otherwise. |
| ERF | Calculates the error function (Gauss error function). |
| ERFC | Calculates the complementary error function (complementary Gauss error function). |
| FACT | Returns the factorial of a number, n!. |
| FACTDOUBLE | Returns the double factorial of a number, n!!. |
| GCD | Returns the greatest common divisor of two or more integers. |
| GCD_ADD | Returns the greatest common divisor of a list of numbers. |
| GESTEP | Returns 1 if a number is greater than or equal to a step number, or 0 otherwise. |
| ISEVEN | Returns TRUE if the value is an even number. |
| ISODD | Returns TRUE if the value is an odd number. |
| LCM | Returns the least common multiple of one or more integers. |
| LCM_ADD | Returns the lowest common multiple of a list of numbers. |
| MULTINOMIAL | Returns the factorial of the sum divided by the product of the factorials. |
| PRODUCT | Multiplies all the numbers given as arguments and returns the product. |
| RAND | Returns a random number between 0 and 1. |
| RANDBETWEEN | Returns an integer random number in a specified range. |
| SERIESSUM | Sums the first terms of a power series. |
| SIGN | Returns the sign of a number. |
| SQRT | Returns the positive square root of a number. |
| SQRTPI | Returns the square root of (PI times a number). |
| SUBTOTAL | Returns SUM, AVERAGE, STDDEV, etc. results for filtered data. |
| SUM | Sums the contents of cells. |
| SUMIF | Conditionally sums the contents of cells in a range. |
| SUMSQ | Returns the sum of the squares of numbers. |
- Functions listed alphabetically,
This is a checkbook register form that you can use to record and monitor your daily expenses. It consist of 2 worksheets. The first worksheet is a checkbook worksheet where you can put your daily income and expenses.
In the beginning, you should put your name, your checkbook period, your beginning balance and your final bank statement balance at the end of checkbook period. You don’t have to fill checkbook balance since it will be calculated automatically.
After that, you can start typing in your expenses in the daily columns correspond with the terms as follows :
* Date – Date of your transaction
* Item # – Your item number, if any
* Type – Type of your financial transaction. You can define your transaction type in the type and category worksheet
* Category – Category of your transaction. You can define your transaction Category in the type and category worksheet
* Payee – The party that you deal with during transaction
* Description – Explanation of your transaction
* C – Reconcile column which you can fill after compare your transaction with your bank statement. Put “C” inside if the value is reconciled and the color of the row will turn into blue, so it will be easier for you to see which rows that is different with your bank statement
* Debit – If your category is expenses, you should put your expenses here.
* Credit – If your category is income, you should put your income here.
* Balance – You don’t have to do anything here since this column contain a formula that will calculate your balance.
The second worksheet is type and category worksheet where you can define your transaction type and category for your income and expenses.