"Project-Id-Version: PACKAGE VERSION\n"

"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"

"POT-Creation-Date: 2015-04-22 23:40+0200\n"

"Last-Translator: Samson B <sambelet@yahoo.com>\n"

"Language-Team: LANGUAGE <LL@li.org>\n"

"Language: am\n"

"Plural-Forms: nplurals=2; plural=n > 1;\n"

"X-Accelerator-Marker: ~\n"

"X-Generator: Pootle 2.7\n"

#: Strings.src

msgctxt ""

"STR_STATUS_PIE_SEGMENT_EXPLODED\n"

"string.text"

msgid "Pie exploded by %PERCENTVALUE percent"

#: Strings.src

msgctxt ""

"STR_PERCENT\n"

"string.text"

msgid "Percent Stacked"

#: Strings_ChartTypes.src

msgctxt ""

"Project-Id-Version: PACKAGE VERSION\n"

"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"

"POT-Creation-Date: 2016-05-07 21:35+0200\n"

"Last-Translator: Samson B <sambelet@yahoo.com>\n"

"Language-Team: LANGUAGE <LL@li.org>\n"

"Language: am\n"

"Plural-Forms: nplurals=2; plural=n > 1;\n"

"X-Accelerator-Marker: ~\n"

"X-Generator: Pootle 2.7\n"

#: cuires.src

msgctxt ""

"RID_STR_OVERFLOW_FORWARD\n"

"string.text"

msgid "Overflow, search continued at the beginning"

#: fmsearch.src

msgctxt ""

"RID_STR_OVERFLOW_BACKWARD\n"

"string.text"

msgid "Overflow, search continued at the end"

#: fmsearch.src

msgctxt ""

"Project-Id-Version: LibO 40l10n\n"

"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"

"POT-Creation-Date: 2016-05-25 13:27+0200\n"

"Last-Translator: Samson B <sambelet@yahoo.com>\n"

"Language-Team: none\n"

"Language: am\n"

"Plural-Forms: nplurals=2; plural=n > 1;\n"

"X-Accelerator-Marker: ~\n"

"X-Generator: Pootle 2.7\n"

#: aboutconfigdialog.ui

msgctxt ""

"label\n"

"string.text"

msgid "User interface elements"

#: optappearancepage.ui

msgctxt ""

"label\n"

"string.text"

msgid "User Interface"

#: optviewpage.ui

msgctxt ""

"title\n"

"string.text"

msgid "Combine"

#: percentdialog.ui

msgctxt ""

"label\n"

"string.text"

msgid "_Combine"

#: slantcornertabpage.ui

msgctxt ""

"Project-Id-Version: PACKAGE VERSION\n"

"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"

"POT-Creation-Date: 2015-05-11 16:12+0200\n"

"Last-Translator: Samson B <sambelet@yahoo.com>\n"

"Language-Team: LANGUAGE <LL@li.org>\n"

"Language: am\n"

"Plural-Forms: nplurals=2; plural=n > 1;\n"

"X-Accelerator-Marker: ~\n"

"X-Generator: Pootle 2.7\n"

#: strings.src

msgctxt ""

"RID_STR_DATASOURCE_NOT_STORED\n"

"string.text"

msgid "The data source was not saved. Please use the interface XStorable to save the data source."

#: strings.src

msgctxt ""

"Project-Id-Version: PACKAGE VERSION\n"

"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"

"POT-Creation-Date: 2015-04-22 23:40+0200\n"

"Last-Translator: Samson B <sambelet@yahoo.com>\n"

"Language-Team: LANGUAGE <LL@li.org>\n"

"Language: am\n"

"Content-Type: text/plain; charset=UTF-8\n"

"Content-Transfer-Encoding: 8bit\n"

"Plural-Forms: nplurals=2; plural=n > 1;\n"

"X-Accelerator-Marker: ~\n"

#: desktop.src

msgctxt ""

"STR_BOOTSTRAP_ERR_LANGUAGE_MISSING\n"

"string.text"

msgid "The user interface language cannot be determined."

#: desktop.src

msgctxt ""

"Project-Id-Version: PACKAGE VERSION\n"

"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"

"POT-Creation-Date: 2016-05-23 21:37+0200\n"

"Last-Translator: Samson B <sambelet@yahoo.com>\n"

"Language-Team: LANGUAGE <LL@li.org>\n"

"Language: am\n"

"Content-Transfer-Encoding: 8bit\n"

"Plural-Forms: nplurals=2; plural=n > 1;\n"

"X-Accelerator-Marker: ~\n"

#: updatehdl.src

msgctxt ""

"RID_UPDATE_STR_PERCENT\n"

"string.text"

msgid "%PERCENT%"

#: updatehdl.src

msgctxt ""

"Project-Id-Version: PACKAGE VERSION\n"

"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"

"POT-Creation-Date: 2016-05-23 21:37+0200\n"

"Last-Translator: Samson B <sambelet@yahoo.com>\n"

"Language-Team: LANGUAGE <LL@li.org>\n"

"Language: am\n"

"Plural-Forms: nplurals=2; plural=n > 1;\n"

"X-Accelerator-Marker: ~\n"

"X-Generator: Pootle 2.7\n"

#: impswfdialog.ui

msgctxt ""

"label\n"

"string.text"

msgid "User Interface"

#: pdfoptionsdialog.ui

msgctxt ""

msgstr ""

"Project-Id-Version: PACKAGE VERSION\n"

"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"

"PO-Revision-Date: YEAR-MO-DA HO:MI+ZONE\n"

"Last-Translator: FULL NAME <EMAIL@ADDRESS>\n"

"Language-Team: LANGUAGE <LL@li.org>\n"

"SC_OPCODE_SUM_X2DY2\n"

"string.text"

msgid "SUMX2PY2"

#: core_resource.src

msgctxt ""

"SC_OPCODE_IRR\n"

"string.text"

msgid "IRR"

#: core_resource.src

msgctxt ""

"SC_OPCODE_MIRR\n"

"string.text"

msgid "MIRR"

#: core_resource.src

msgctxt ""

"SC_OPCODE_ISPMT\n"

"string.text"

msgid "ISPMT"

#: core_resource.src

msgctxt ""

"SC_OPCODE_COMBIN\n"

"string.text"

msgid "COMBIN"

msgstr "መቀላቀያ"

#: core_resource.src

"SC_OPCODE_SYD\n"

"string.text"

msgid "SYD"

#: core_resource.src

msgctxt ""

"SC_OPCODE_DURATION\n"

"string.text"

msgid "DURATION"

#: core_resource.src

msgctxt ""

"SC_OPCODE_NPER\n"

"string.text"

msgid "NPER"

#: core_resource.src

msgctxt ""

"SC_OPCODE_CUM_IPMT\n"

"string.text"

msgid "CUMIPMT"

#: core_resource.src

msgctxt ""

"SC_OPCODE_CUM_PRINC\n"

"string.text"

msgid "CUMPRINC"

#: core_resource.src

msgctxt ""

"SC_OPCODE_EFFECTIVE\n"

"string.text"

msgid "EFFECTIVE"

#: core_resource.src

msgctxt ""

"SC_OPCODE_PERCENTILE\n"

"string.text"

msgid "PERCENTILE"

#: core_resource.src

msgctxt ""

"SC_OPCODE_PERCENT_RANK\n"

"string.text"

msgid "PERCENTRANK"

#: core_resource.src

msgctxt ""

"Project-Id-Version: PACKAGE VERSION\n"

"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"

"POT-Creation-Date: 2016-03-09 20:48+0100\n"

"Last-Translator: Samson B <sambelet@yahoo.com>\n"

"Language-Team: LANGUAGE <LL@li.org>\n"

"Language: am\n"

"Plural-Forms: nplurals=2; plural=n > 1;\n"

"X-Accelerator-Marker: ~\n"

"X-Generator: Pootle 2.7\n"

#: access2base.xhp

msgctxt ""

"par_idA2B010\n"

"help.text"

msgid "an API for database access with the <emph>table</emph>, <emph>query</emph>, <emph>recordset</emph> and <emph>field</emph> objects"

#: access2base.xhp

msgctxt ""

"par_idA2B011\n"

"help.text"

msgid "a number of <emph>actions</emph> with a syntax identical to their corresponding MSAccess macros/actions"

#: access2base.xhp

msgctxt ""

"par_idA2B013\n"

"help.text"

msgid "the support of the shortcut notations like <item type=\"literal\">Forms!myForm!myControl</item>"

#: access2base.xhp

msgctxt ""

"par_idA2B016\n"

"help.text"

msgid "facilities for programming form, dialog and control <emph>events</emph>"

#: access2base.xhp

msgctxt ""

"2\n"

"help.text"

msgid "In the <item type=\"productname\">%PRODUCTNAME</item> BASIC window for a dialog that you created, leave the dialog editor by clicking the name tab of the Module that the dialog is assigned to. The name tab is at the bottom of the window."

#: show_dialog.xhp

msgctxt ""

"par_id4601940\n"

"help.text"

msgid "The Language toolbar in the Basic IDE dialog editor shows controls to enable and manage localizable dialogs."

#: translation.xhp

msgctxt ""

"par_id5806756\n"

"help.text"

msgid "<ahelp hid=\".\" visibility=\"hidden\">Add UI languages for your dialog strings.</ahelp>"

#: translation.xhp

msgctxt ""

"hd_id6596881\n"

"help.text"

msgid "To enable localizable dialogs"

#: translation.xhp

msgctxt ""

"par_id8750572\n"

"help.text"

msgid "In the Basic IDE dialog editor, open the Language toolbar choosing <item type=\"menuitem\">View - Toolbars - Language</item>."

#: translation.xhp

msgctxt ""

"par_id4585100\n"

"help.text"

msgid "This adds string resources to contain the translated versions of all strings to the dialog properties. The set of dialog strings of the default language is copied to the new set of strings. Later, you can switch to the new language and then translate the strings."

#: translation.xhp

msgctxt ""

"par_id2334665\n"

"help.text"

msgid "Once you have added the resources for localizable strings in your dialogs, you can select the current language from the Current Language listbox on the Language toolbar."

#: translation.xhp

msgctxt ""

"par_id3682058\n"

"help.text"

msgid "The user of your dialog will see the strings of the user interface language of the user's version of %PRODUCTNAME, if you did provide strings in that language."

#: translation.xhp

msgctxt ""

"par_id3050325\n"

"help.text"

msgid "If the user has an older version of %PRODUCTNAME that does not know localizable string resources for Basic dialogs, the user will see the default language strings."

"Project-Id-Version: PACKAGE VERSION\n"

"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"

"POT-Creation-Date: 2016-07-04 16:53+0200\n"

"Last-Translator: Samson B <sambelet@yahoo.com>\n"

"Language-Team: LANGUAGE <LL@li.org>\n"

"Language: am\n"

"Plural-Forms: nplurals=2; plural=n > 1;\n"

"X-Accelerator-Marker: ~\n"

"X-Generator: Pootle 2.7\n"

#: 00000002.xhp

msgctxt ""

"4\n"

"help.text"

msgid "<emph>Sub</emph> is the short form of <emph>subroutine</emph>, that is used to handle a certain task within a program. Subs are used to split a task into individual procedures. Splitting a program into procedures and sub-procedures enhances readability and reduces the error-proneness. A sub possibly takes some arguments as parameters but does not return any values back to the calling sub or function, for example:"

#: 01010210.xhp

msgctxt ""

"10\n"

"help.text"

msgid "Variables that you declare within a sub or function are valid only inside this sub or function. These variables override global variables with the same name and local variables with the same name coming from superordinate subs or functions."

#: 01010210.xhp

msgctxt ""

"par_id3148797\n"

"help.text"

msgid "A variable name can consist of a maximum of 255 characters. The first character of a variable name <emph>must</emph> be a letter A-Z or a-z. Numbers can also be used in a variable name, but punctuation symbols and special characters are not permitted, with exception of the underscore character (\"_\"). In $[officename] Basic variable identifiers are not case-sensitive. Variable names may contain spaces but must be enclosed in square brackets if they do."

#: 01020100.xhp

msgctxt ""

"par_id3153368\n"

"help.text"

msgid "<emph>%:</emph> Multiplies the number by 100 and inserts the percent sign (%) where the number appears in the format code."

#: 03120301.xhp

msgctxt ""

"par_id3150715\n"

"help.text"

msgid "<emph>Percent:</emph> Multiplies the number by 100 and appends a percent sign to the number."

#: 03120301.xhp

msgctxt ""

"Project-Id-Version: PACKAGE VERSION\n"

"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"

"POT-Creation-Date: 2015-04-22 23:39+0200\n"

"Last-Translator: Samson B <sambelet@yahoo.com>\n"

"Language-Team: LANGUAGE <LL@li.org>\n"

"Language: am\n"

"Plural-Forms: nplurals=2; plural=n > 1;\n"

"X-Accelerator-Marker: ~\n"

"X-Generator: Pootle 2.7\n"

#: 11010000.xhp

msgctxt ""

"2\n"

"help.text"

msgid "<ahelp hid=\".uno:LoadBasic\">Opens the Basic source text in the Basic IDE window.</ahelp>"

#: 11140000.xhp

msgctxt ""

"par_id0929200903505320\n"

"help.text"

msgid "If the library contains additional languages compared to the imported dialog, or if the imported dialog is not localized at all, then the additional languages will silently be added to the imported dialog using the strings of the dialog's default locale."

#: 11180000.xhp

msgctxt ""

"par_id0929200903505383\n"

"help.text"

msgid "If the imported dialog contains additional languages compared to the library, or if the library is not localized at all, then you see a message box with Add, Omit, and Cancel buttons."

#: 11180000.xhp

msgctxt ""

"par_id0929200903505340\n"

"help.text"

msgid "Add: The additional languages from the imported dialog will be added to the already existing dialog. The resources from the library's default language will be used for the new languages. This is the same as if you add these languages manually."

#: 11180000.xhp

msgctxt ""

"par_id0929200903505367\n"

"help.text"

msgid "Omit: The library's language settings will stay unchanged. The imported dialog's resources for the omitted languages are not copied into the library, but they remain in the imported dialog's source files."

#: 11180000.xhp

msgctxt ""

"par_id9961851\n"

"help.text"

msgid "<ahelp hid=\".\">Adds a tree control that can show a hierarchical list. You can populate the list by your program, using API calls (XtreeControl).</ahelp>"

"Project-Id-Version: PACKAGE VERSION\n"

"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"

"POT-Creation-Date: 2016-07-04 16:53+0200\n"

"Last-Translator: Samson B <sambelet@yahoo.com>\n"

"Language-Team: LANGUAGE <LL@li.org>\n"

"Language: am\n"

"Plural-Forms: nplurals=2; plural=n > 1;\n"

"X-Accelerator-Marker: ~\n"

"X-Generator: Pootle 2.7\n"

#: 01120000.xhp

msgctxt ""

"55\n"

"help.text"

msgid "<ahelp hid=\"SC:PUSHBUTTON:RID_SCDLG_FORMULA:BTN_FORWARD\">Moves forward through the formula components in the formula window.</ahelp> This button can also be used to assign functions to the formula. If you select a function and click the <emph>Next </emph>button, the selection appears in the formula window."

#: 04060000.xhp

msgctxt ""

"4\n"

"help.text"

msgid "If you start the <emph>Function Wizard</emph> while the cell cursor is positioned in a cell that already contains a function, the <emph>Structure</emph> tab is opened and shows the composition of the current formula."

#: 04060000.xhp

msgctxt ""

"63\n"

"help.text"

msgid "Blue dots denote correctly entered arguments. Red dots indicate incorrect data types. For example: if the SUM function has one argument entered as text, this is highlighted in red as SUM only permits number entries."

#: 04060100.xhp

msgctxt ""

"187\n"

"help.text"

msgid "If the DatabaseField argument is omitted, DCOUNT returns the count of all records that satisfy Criteria. <embedvar href=\"text/scalc/01/04060101.xhp#quotes\"/>"

#: 04060101.xhp

msgctxt ""

"144\n"

"help.text"

msgid "With the birthday party example above (scroll up, please), there is no meaningful application of this function."

#: 04060101.xhp

msgctxt ""

"150\n"

"help.text"

msgid "To find the standard deviation of the weight for all children of the same age in the example (scroll up, please), enter the following formula in B16:"

#: 04060101.xhp

msgctxt ""

"158\n"

"help.text"

msgid "To find the standard deviation of the weight for all children of the same age at Joe's birthday party (scroll up, please), enter the following formula in B16:"

#: 04060101.xhp

msgctxt ""

"173\n"

"help.text"

msgid "DVAR(Database; DatabaseField; SearchCriteria)"

#: 04060101.xhp

msgctxt ""

"175\n"

"help.text"

msgid "To find the variance of the weight of all children of the same age of the above example (scroll up, please), enter the following formula in B16:"

#: 04060101.xhp

msgctxt ""

"181\n"

"help.text"

msgid "DVARP(Database; DatabaseField; SearchCriteria)"

#: 04060101.xhp

msgctxt ""

"183\n"

"help.text"

msgid "To find the variance of the weight for all children of the same age at Joe's birthday party (scroll up, please), enter the following formula in B16:"

#: 04060101.xhp

msgctxt ""

"170\n"

"help.text"

msgid "$[officename] internally handles a date/time value as a numerical value. If you assign the numbering format \"Number\" to a date or time value, it is converted to a number. For example, 01/01/2000 12:00 PM, converts to 36526.5. The value preceding the decimal point corresponds to the date; the value following the decimal point corresponds to the time. If you do not want to see this type of numerical date or time representation, change the number format (date or time) accordingly. To do this, select the cell containing the date or time value, call its context menu and select <emph>Format Cells</emph>. The <emph>Numbers</emph> tab page contains the functions for defining the number format."

#: 04060102.xhp

msgctxt ""

"bm_id3151276\n"

"help.text"

msgid "<bookmark_value>accrued interests;periodic payments</bookmark_value>"

#: 04060103.xhp

msgctxt ""

"336\n"

"help.text"

msgid "<ahelp hid=\"HID_AAI_FUNC_ACCRINT\">Calculates the accrued interest of a security in the case of periodic payments.</ahelp>"

#: 04060103.xhp

msgctxt ""

"338\n"

"help.text"

msgid "ACCRINT(Issue; FirstInterest; Settlement; Rate; Par; Frequency; Basis)"

#: 04060103.xhp

msgctxt ""

"342\n"

"help.text"

msgid "<emph>Rate</emph> (required) is the annual nominal rate of interest (coupon interest rate)"

#: 04060103.xhp

msgctxt ""

"343\n"

"help.text"

msgid "<emph>Par</emph> (optional) is the par value of the security."

#: 04060103.xhp

msgctxt ""

"346\n"

"help.text"

msgid "A security is issued on 2001-02-28. First interest is set for 2001-08-31. The settlement date is 2001-05-01. The Rate is 0.1 or 10% and Par is 1000 currency units. Interest is paid half-yearly (frequency is 2). The basis is the US method (0). How much interest has accrued?"

#: 04060103.xhp

msgctxt ""

"347\n"

"help.text"

msgid "<item type=\"input\">=ACCRINT(\"2001-02-28\";\"2001-08-31\";\"2001-05-01\";0.1;1000;2;0)</item> returns 16.94444."

#: 04060103.xhp

msgctxt ""

"bm_id3151240\n"

"help.text"

msgid "<bookmark_value>ACCRINTM function</bookmark_value> <bookmark_value>accrued interests;one-off payments</bookmark_value>"

#: 04060103.xhp

msgctxt ""

"349\n"

"help.text"

msgid "<ahelp hid=\"HID_AAI_FUNC_ACCRINTM\">Calculates the accrued interest of a security in the case of one-off payment at the settlement date.</ahelp>"

#: 04060103.xhp

msgctxt ""

"351\n"

"help.text"

msgid "ACCRINTM(Issue; Settlement; Rate; Par; Basis)"

#: 04060103.xhp

msgctxt ""

"353\n"

"help.text"

msgid "<emph>Settlement</emph> (required) is the date at which the interest accrued up until then is to be calculated."

#: 04060103.xhp

msgctxt ""

"354\n"

"help.text"

msgid "<emph>Rate</emph> (required) is the annual nominal rate of interest (coupon interest rate)."

#: 04060103.xhp

msgctxt ""

"355\n"

"help.text"

msgid "<emph>Par</emph> (optional) is the par value of the security."

#: 04060103.xhp

msgctxt ""

"357\n"

"help.text"

msgid "A security is issued on 2001-04-01. The maturity date is set for 2001-06-15. The Rate is 0.1 or 10% and Par is 1000 currency units. The basis of the daily/annual calculation is the daily balance (3). How much interest has accrued?"

#: 04060103.xhp

msgctxt ""

"358\n"

"help.text"

msgid "<item type=\"input\">=ACCRINTM(\"2001-04-01\";\"2001-06-15\";0.1;1000;3)</item> returns 20.54795."

#: 04060103.xhp

msgctxt ""

"391\n"

"help.text"

msgid "<ahelp hid=\"HID_AAI_FUNC_RECEIVED\">Calculates the amount received that is paid for a fixed-interest security at a given point in time.</ahelp>"

#: 04060103.xhp

msgctxt ""

"393\n"

"help.text"

msgid "RECEIVED(\"Settlement\"; \"Maturity\"; Investment; Discount; Basis)"

#: 04060103.xhp

msgctxt ""

"396\n"

"help.text"

msgid "<emph>Investment</emph> is the purchase sum."

#: 04060103.xhp

msgctxt ""

"399\n"

"help.text"

msgid "Settlement date: February 15 1999, maturity date: May 15 1999, investment sum: 1000 currency units, discount: 5.75 per cent, basis: Daily balance/360 = 2."

#: 04060103.xhp

msgctxt ""

"400\n"

"help.text"

msgid "The amount received on the maturity date is calculated as follows:"

#: 04060103.xhp

msgctxt ""

"bm_id3147556\n"

"help.text"

msgid "<bookmark_value>PV function</bookmark_value> <bookmark_value>present values</bookmark_value> <bookmark_value>calculating; present values</bookmark_value>"

#: 04060103.xhp

msgctxt ""

"4\n"

"help.text"

msgid "<ahelp hid=\"HID_FUNC_BW\">Returns the present value of an investment resulting from a series of regular payments.</ahelp>"

#: 04060103.xhp

msgctxt ""

"10\n"

"help.text"

msgid "<emph>NPer</emph> is the total number of periods (payment period)."

#: 04060103.xhp

msgctxt ""

"11\n"

"help.text"

msgid "<emph>Pmt</emph> is the regular payment made per period."

#: 04060103.xhp

msgctxt ""

"12\n"

"help.text"

msgid "<emph>FV</emph> (optional) defines the future value remaining after the final installment has been made."

#: 04060103.xhp

msgctxt ""

"13\n"

"help.text"

msgid "<emph>Type</emph> (optional) denotes due date for payments. Type = 1 means due at the beginning of a period and Type = 0 (default) means due at the end of the period."

#: 04060103.xhp

msgctxt ""

"16\n"

"help.text"

msgid "<item type=\"input\">=PV(8%/12;48;500;20000)</item> = -35,019.37 currency units. Under the named conditions, you must deposit 35,019.37 currency units today, if you want to receive 500 currency units per month for 48 months and have 20,000 currency units left over at the end. Cross-checking shows that 48 x 500 currency units + 20,000 currency units = 44,000 currency units. The difference between this amount and the 35,000 currency units deposited represents the interest paid."

#: 04060103.xhp

msgctxt ""

"17\n"

"help.text"

msgid "If you enter references instead of these values into the formula, you can calculate any number of \"If-then\" scenarios. Please note: references to constants must be defined as absolute references. Examples of this type of application are found under the depreciation functions."

#: 04060103.xhp

msgctxt ""

"bm_id3152978\n"

"help.text"

msgid "<bookmark_value>calculating; depreciations</bookmark_value> <bookmark_value>SYD function</bookmark_value> <bookmark_value>depreciations; arithmetic declining</bookmark_value> <bookmark_value>arithmetic declining depreciations</bookmark_value>"

#: 04060103.xhp

msgctxt ""

"20\n"

"help.text"

msgid "<ahelp hid=\"HID_FUNC_DIA\">Returns the arithmetic-declining depreciation rate.</ahelp>"

#: 04060103.xhp

msgctxt ""

"21\n"

"help.text"

msgid "Use this function to calculate the depreciation amount for one period of the total depreciation span of an object. Arithmetic declining depreciation reduces the depreciation amount from period to period by a fixed sum."

#: 04060103.xhp

msgctxt ""

"23\n"

"help.text"

msgid "SYD(Cost; Salvage; Life; Period)"

#: 04060103.xhp

msgctxt ""

"29\n"

"help.text"

msgid "A video system initially costing 50,000 currency units is to be depreciated annually for the next 5 years. The salvage value is to be 10,000 currency units. You want to calculate depreciation for the first year."

#: 04060103.xhp

msgctxt ""

"31\n"

"help.text"

msgid "To have an overview of depreciation rates per period, it is best to define a depreciation table. By entering the different depreciation formulas available in <item type=\"productname\">%PRODUCTNAME</item> Calc next to each other, you can see which depreciation form is the most appropriate. Enter the table as follows:"

#: 04060103.xhp

msgctxt ""

"84\n"

"help.text"

msgid "Cell E13 contains the formula used to check the total of the depreciation amounts. It uses the SUMIF function as the negative values in E8:E11 must not be considered. The condition >0 is contained in cell A13. The formula in E13 is as follows:"

#: 04060103.xhp

msgctxt ""

"86\n"

"help.text"

msgid "Now view the depreciation for a 10 year period, or at a salvage value of 1 currency unit, or enter a different initial cost, and so on."

#: 04060103.xhp

msgctxt ""

"bm_id3155104\n"

"help.text"

msgid "<bookmark_value>DISC function</bookmark_value> <bookmark_value>allowances</bookmark_value> <bookmark_value>discounts</bookmark_value>"

#: 04060103.xhp

msgctxt ""

"380\n"

"help.text"

msgid "<ahelp hid=\"HID_AAI_FUNC_DISC\">Calculates the allowance (discount) of a security as a percentage.</ahelp>"

#: 04060103.xhp

msgctxt ""

"382\n"

"help.text"

msgid "DISC(\"Settlement\"; \"Maturity\"; Price; Redemption; Basis)"

#: 04060103.xhp

msgctxt ""

"385\n"

"help.text"

msgid "<emph>Price</emph> is the price of the security per 100 currency units of par value."

#: 04060103.xhp

msgctxt ""

"386\n"

"help.text"

msgid "<emph>Redemption</emph> is the redemption value of the security per 100 currency units of par value."

#: 04060103.xhp

msgctxt ""

"bm_id3154695\n"

"help.text"

msgid "<bookmark_value>DURATION_ADD function</bookmark_value> <bookmark_value>Microsoft Excel functions</bookmark_value> <bookmark_value>durations;fixed interest securities</bookmark_value>"

#: 04060103.xhp

msgctxt ""

"402\n"

"help.text"

msgid "DURATION_ADD"

#: 04060103.xhp

msgctxt ""

"405\n"

"help.text"

msgid "DURATION_ADD(\"Settlement\"; \"Maturity\"; Coupon; Yield; Frequency; Basis)"

#: 04060103.xhp

msgctxt ""

"409\n"

"help.text"

msgid "<emph>Yield</emph> is the annual yield of the security."

#: 04060103.xhp

msgctxt ""

"413\n"

"help.text"

msgid "<item type=\"input\">=DURATION_ADD(\"2001-01-01\";\"2006-01-01\";0.08;0.09;2;3)</item>"

#: 04060103.xhp

msgctxt ""

"bm_id3159147\n"

"help.text"

msgid "<bookmark_value>annual net interest rates</bookmark_value> <bookmark_value>calculating; annual net interest rates</bookmark_value> <bookmark_value>net annual interest rates</bookmark_value> <bookmark_value>EFFECTIVE function</bookmark_value>"

#: 04060103.xhp

msgctxt ""

"88\n"

"help.text"

msgid "EFFECTIVE"

#: 04060103.xhp

msgctxt ""

"89\n"

"help.text"

msgid "<ahelp hid=\"HID_FUNC_EFFEKTIV\">Returns the net annual interest rate for a nominal interest rate.</ahelp>"

#: 04060103.xhp

msgctxt ""

"92\n"

"help.text"

msgid "EFFECTIVE(Nom; P)"

#: 04060103.xhp

msgctxt ""

"93\n"

"help.text"

msgid "<emph>Nom</emph> is the nominal interest."

#: 04060103.xhp

msgctxt ""

"94\n"

"help.text"

msgid "<emph>P</emph> is the number of interest payment periods per year."

#: 04060103.xhp

msgctxt ""

"97\n"

"help.text"

msgid "<item type=\"input\">=EFFECTIVE(9.75%;4)</item> = 10.11% The annual effective rate is therefore 10.11%."

#: 04060103.xhp

msgctxt ""

"bm_id3147241\n"

"help.text"

msgid "<bookmark_value>effective interest rates</bookmark_value> <bookmark_value>EFFECT_ADD function</bookmark_value>"

#: 04060103.xhp

msgctxt ""

"414\n"

"help.text"

msgid "EFFECT_ADD"

#: 04060103.xhp

msgctxt ""

"417\n"

"help.text"

msgid "EFFECT_ADD(NominalRate; NPerY)"

#: 04060103.xhp

msgctxt ""

"04060103.xhp\n"

"par_id3148907\n"

"418\n"

"help.text"

msgid "<emph>NominalRate</emph> is the annual nominal rate of interest."

#: 04060103.xhp

msgctxt ""

"419\n"

"help.text"

msgid "<emph>NPerY </emph>is the number of interest payments per year."

#: 04060103.xhp

msgctxt ""

"421\n"

"help.text"

msgid "What is the effective annual rate of interest for a 5.25% nominal rate and quarterly payment."

#: 04060103.xhp

msgctxt ""

"106\n"

"help.text"

msgid "<emph>Life</emph> is the number of periods (for example, years or months) defining how long the asset is to be used."

#: 04060103.xhp

msgctxt ""

"108\n"

"help.text"

msgid "<emph>Factor</emph> (optional) is the factor by which depreciation decreases. If a value is not entered, the default is factor 2."

#: 04060103.xhp

msgctxt ""

"110\n"

"help.text"

msgid "A computer system with an initial cost of 75,000 currency units is to be depreciated monthly over 5 years. The value at the end of the depreciation is to be 1 currency unit. The factor is 2."

#: 04060103.xhp

msgctxt ""

"117\n"

"help.text"

msgid "DB(Cost; Salvage; Life; Period; Month)"

#: 04060103.xhp

msgctxt ""

"120\n"

"help.text"

msgid "<emph>Life</emph> defines the period over which an asset is depreciated."

#: 04060103.xhp

msgctxt ""

"125\n"

"help.text"

msgid "<item type=\"input\">=DB(25000;1000;36;1;6)</item> = 1,075.00 currency units"

#: 04060103.xhp

msgctxt ""

"bm_id3153948\n"

"help.text"

msgid "<bookmark_value>IRR function</bookmark_value> <bookmark_value>calculating;internal rates of return, regular payments</bookmark_value> <bookmark_value>internal rates of return;regular payments</bookmark_value>"

#: 04060103.xhp

msgctxt ""

"128\n"

"help.text"

msgid "IRR"

#: 04060103.xhp

msgctxt ""

"131\n"

"help.text"

msgid "IRR(Values; Guess)"

#: 04060103.xhp

msgctxt ""

"132\n"

"help.text"

msgid "<emph>Values</emph> represents an array containing the values."

#: 04060103.xhp

msgctxt ""

"135\n"

"help.text"

msgid "Under the assumption that cell contents are A1=<item type=\"input\">-10000</item>, A2=<item type=\"input\">3500</item>, A3=<item type=\"input\">7600</item> and A4=<item type=\"input\">1000</item>, the formula <item type=\"input\">=IRR(A1:A4)</item> gives a result of 11,33%."

#: 04060103.xhp

msgctxt ""

"bm_id3151012\n"

"help.text"

msgid "<bookmark_value>calculating; interests for unchanged amortization installments</bookmark_value> <bookmark_value>interests for unchanged amortization installments</bookmark_value> <bookmark_value>ISPMT function</bookmark_value>"

#: 04060103.xhp

msgctxt ""

"314\n"

"help.text"

msgid "ISPMT"

#: 04060103.xhp

msgctxt ""

"315\n"

"help.text"

msgid "<ahelp hid=\"HID_FUNC_ISPMT\">Calculates the level of interest for unchanged amortization installments.</ahelp>"

#: 04060103.xhp

msgctxt ""

"317\n"

"help.text"

msgid "ISPMT(Rate; Period; TotalPeriods; Invest)"

#: 04060103.xhp

msgctxt ""

"321\n"

"help.text"

msgid "<emph>Invest</emph> is the amount of the investment."

#: 04060103.xhp

msgctxt ""

"323\n"

"help.text"

msgid "For a credit amount of 120,000 currency units with a two-year term and monthly installments, at a yearly interest rate of 12% the level of interest after 1.5 years is required."

#: 04060103.xhp

msgctxt ""

"324\n"

"help.text"

msgid "<item type=\"input\">=ISPMT(1%;18;24;120000)</item> = -300 currency units. The monthly interest after 1.5 years amounts to 300 currency units."

#: 04060103.xhp

msgctxt ""

"par_id9648731\n"

"help.text"

msgid "\"osversion\""

#: 04060104.xhp

msgctxt ""

"par_id908841\n"

"help.text"

msgid "Always \"Windows (32-bit) NT 5.01\", for compatibility reasons"

#: 04060104.xhp

msgctxt ""

"par_id9841608\n"

"help.text"

msgid "The type of the operating system. <br/>\"WNT\" for Microsoft Windows <br/>\"LINUX\" for Linux <br/>\"SOLARIS\" for Solaris"

#: 04060104.xhp

msgctxt ""

"par_id2136295\n"

"help.text"

msgid "The product release identifier, for example \"300m25(Build:9876)\""

#: 04060104.xhp

msgctxt ""

"par_id3145163\n"

"help.text"

msgid "<ahelp hid=\"HID_FUNC_ARCCOS\">Returns the inverse trigonometric cosine of a number.</ahelp>"

#: 04060106.xhp

msgctxt ""

"par_id3156296\n"

"help.text"

msgid "<ahelp hid=\"HID_FUNC_ARCSIN\">Returns the inverse trigonometric sine of a number.</ahelp>"

#: 04060106.xhp

msgctxt ""

"par_id6293527\n"

"help.text"

msgid "To return the angle in degrees, use the DEGREES function."

#: 04060106.xhp

msgctxt ""

"par_id3001800\n"

"help.text"

msgid "To return the angle in degrees, use the DEGREES function."

#: 04060106.xhp

msgctxt ""

msgstr "<item type=\"input\">=CSCH(1)</item> ይመልሳል በ ግምት 0.8509181282, the hyperbolic cosecant of 1."

#: 04060106.xhp

msgctxt ""

"04060106.xhp\n"

"bm_id3145314\n"

"help.text"

msgid "<bookmark_value>DEGREES function</bookmark_value> <bookmark_value>converting;radians, into degrees</bookmark_value>"

#: 04060106.xhp

msgctxt ""

"hd_id3145314\n"

"help.text"

msgid "DEGREES"

#: 04060106.xhp

msgctxt ""

"par_id3149939\n"

"help.text"

msgid "<ahelp hid=\"HID_FUNC_DEG\">Converts radians into degrees.</ahelp>"

#: 04060106.xhp

msgctxt ""

"par_id3149484\n"

"help.text"

msgid "<emph>Number</emph> is the angle in radians to be converted to degrees."

#: 04060106.xhp

msgctxt ""

"par_id3459578\n"

"help.text"

msgid "<item type=\"input\">=DEGREES(PI())</item> returns 180 degrees."

#: 04060106.xhp

msgctxt ""

"par_id3158441\n"

"help.text"

msgid "<ahelp hid=\"HID_FUNC_GANZZAHL\">Rounds a number down to the nearest integer.</ahelp>"

#: 04060106.xhp

msgctxt ""

msgstr "<item type=\"input\">=INT(5.7)</item> ይመልሳል 5."

#: 04060106.xhp

msgctxt ""

"04060106.xhp\n"

"par_id3147323\n"

"help.text"

msgid "<item type=\"input\">=INT(-1.3)</item> returns -2."

#: 04060106.xhp

msgctxt ""

"par_id6807458\n"

"help.text"

msgid "COMBIN returns the number of ordered ways to choose these items. For example if there are 3 items A, B and C in a set, you can choose 2 items in 3 different ways, namely AB, AC and BC."

#: 04060106.xhp

msgctxt ""

"par_id7414471\n"

"help.text"

msgid "COMBIN implements the formula: Count1!/(Count2!*(Count1-Count2)!)"

#: 04060106.xhp

msgctxt ""

"par_id3158069\n"

"help.text"

msgid "<emph>Number</emph> is the angle in degrees to be converted to radians."

#: 04060106.xhp

msgctxt ""

"par_id3939634\n"

"help.text"

msgid "<item type=\"input\">=RADIANS(90)</item> returns 1.5707963267949, which is PI/2 to Calc's accuracy."

#: 04060106.xhp

msgctxt ""

"par_id3156271\n"

"help.text"

msgid "MUNIT(Dimensions)"

#: 04060107.xhp

msgctxt ""

"par_id3150403\n"

"help.text"

msgid "You can also enter the <item type=\"input\">=Munit(5)</item> formula in the last cell of the selected range (E5), and press <switchinline select=\"sys\"><caseinline select=\"MAC\">Shift+Command+Enter</caseinline><defaultinline>Shift+Ctrl+Enter</defaultinline></switchinline>."

#: 04060107.xhp

msgctxt ""

"hd_id3148546\n"

"help.text"

msgid "MMULT"

#: 04060107.xhp

msgctxt ""

"par_id3148518\n"

"help.text"

msgid "<ahelp hid=\"HID_FUNC_MMULT\">Calculates the array product of two arrays.</ahelp> The number of columns for array 1 must match the number of rows for array 2. The square array has an equal number of rows and columns."

#: 04060107.xhp

msgctxt ""

"par_id3150798\n"

"help.text"

msgid "MMULT(Array; Array)"

#: 04060107.xhp

msgctxt ""

"par_id3150812\n"

"help.text"

msgid "<emph>Array</emph> at first place represents the first array used in the array product."

#: 04060107.xhp

msgctxt ""

"par_id3152553\n"

"help.text"

msgid "<emph>Array</emph> at second place represents the second array with the same number of rows."

#: 04060107.xhp

msgctxt ""

"par_id3146826\n"

"help.text"

msgid "Select a square range. Choose the MMULT function. Select the first <emph>Array</emph>, then select the second <emph>Array</emph>. Using <emph>Function Wizard</emph>, mark the <emph>Array</emph> check box. Click <emph>OK</emph>. The output array will appear in the first selected range."

#: 04060107.xhp

msgctxt ""

"par_id3154176\n"

"help.text"

msgid "This function returns an array and is handled in the same way as the other array functions. Select a range for the answers and then the function. Select <emph>data_Y</emph>. If you want, you can enter other parameters. Select <emph>Array</emph> and click <emph>OK</emph>."

#: 04060107.xhp

msgctxt ""

"par_id3158184\n"

"help.text"

msgid "G2: Intersection b with the y axis."

#: 04060107.xhp

msgctxt ""

"par_id3145845\n"

"help.text"

msgid "G3: The standard error of the intercept"

#: 04060107.xhp

msgctxt ""

"par_id3145880\n"

"help.text"

msgid "F4: The standard error of the regression calculated for the Y value."

#: 04060107.xhp

msgctxt ""

"par_id3145894\n"

"help.text"

msgid "E5: The F value from the variance analysis."

#: 04060107.xhp

msgctxt ""

"par_id3145915\n"

"help.text"

msgid "F5: The degrees of freedom from the variance analysis."

#: 04060107.xhp

msgctxt ""

"hd_id3145026\n"

"help.text"

msgid "SUMX2PY2"

#: 04060107.xhp

msgctxt ""

"par_id3163404\n"

"help.text"

msgid "SUMX2PY2(ArrayX; ArrayY)"

#: 04060107.xhp

msgctxt ""

"hd_id3163527\n"

"help.text"

msgid "SUMXMY2"

#: 04060107.xhp

msgctxt ""

"par_id3163588\n"

"help.text"

msgid "SUMXMY2(ArrayX; ArrayY)"

#: 04060107.xhp

msgctxt ""

"par_idN11798\n"

"help.text"

msgid "HYPERLINK"

#: 04060109.xhp

msgctxt ""

"par_idN1180E\n"

"help.text"

msgid "HYPERLINK(\"URL\") or HYPERLINK(\"URL\"; \"CellText\")"

#: 04060109.xhp

msgctxt ""

"24\n"

"help.text"

msgid "Any text containing numbers must be enclosed in quotation marks if you do not want it to be interpreted as a number and automatically converted to text."

#: 04060110.xhp

msgctxt ""

"72\n"

"help.text"

msgid "Output: Takes up the description of the parameter, for example, \"Value, at which the universe is to be calculated.\" Implemented in $[officename] Calc as char[256]."

#: 04060112.xhp

msgctxt ""

"156\n"

"help.text"

msgid "<link href=\"text/scalc/01/04060111.xhp\" name=\"Back to the Overview\">Back to the Overview</link>"

#: 04060115.xhp

msgctxt ""

msgstr ""

#: 04060115.xhp

msgctxt ""

"04060115.xhp\n"

"bm_id3153034\n"

"help.text"

msgid "<bookmark_value>BIN2DEC function</bookmark_value><bookmark_value>converting;binary numbers, into decimal numbers</bookmark_value>"

#: 04060115.xhp

msgctxt ""

msgstr "<item type=\"input\">=BIN2DEC(1100100)</item> ይመልሳል 100."

#: 04060115.xhp

msgctxt ""

"04060115.xhp\n"

"bm_id3149954\n"

"help.text"

msgid "<bookmark_value>BIN2HEX function</bookmark_value><bookmark_value>converting;binary numbers, into hexadecimal numbers</bookmark_value>"

#: 04060115.xhp

msgctxt ""

"135\n"

"help.text"

msgid "ERF"

#: 04060115.xhp

msgctxt ""

"138\n"

"help.text"

msgid "ERF(LowerLimit; UpperLimit)"

#: 04060115.xhp

msgctxt ""

"139\n"

"help.text"

msgid "<emph>LowerLimit</emph> is the lower limit of the integral."

#: 04060115.xhp

msgctxt ""

"140\n"

"help.text"

msgid "<emph>UpperLimit</emph> is optional. It is the upper limit of the integral. If this value is missing, the calculation takes places between 0 and the lower limit."

#: 04060115.xhp

msgctxt ""

"139\n"

"help.text"

msgid "<emph>LowerLimit</emph> is the lower limit of the integral."

#: 04060115.xhp

msgctxt ""

"140\n"

"help.text"

msgid "<emph>UpperLimit</emph> is optional. It is the upper limit of the integral. If this value is missing, the calculation takes places between 0 and the lower limit."

#: 04060115.xhp

msgctxt ""

"143\n"

"help.text"

msgid "ERFC"

#: 04060115.xhp

msgctxt ""

"146\n"

"help.text"

msgid "ERFC(LowerLimit)"

#: 04060115.xhp

msgctxt ""

"147\n"

"help.text"

msgid "<emph>LowerLimit</emph> is the lower limit of the integral"

#: 04060115.xhp

msgctxt ""

"150\n"

"help.text"

msgid "GESTEP"

#: 04060115.xhp

msgctxt ""

"150\n"

"help.text"

msgid "IMSUM"

#: 04060116.xhp

msgctxt ""

"153\n"

"help.text"

msgid "IMSUM(\"ComplexNumber1\"; \"ComplexNumber2\"; ...)"

#: 04060116.xhp

msgctxt ""

"157\n"

"help.text"

msgid "COMPLEX"

#: 04060116.xhp

msgctxt ""

msgstr ""

#: 04060116.xhp

msgctxt ""

"04060116.xhp\n"

"par_id3153984\n"

"175\n"

"help.text"

msgid "CONVERT_ADD"

#: 04060116.xhp

msgctxt ""

"par_id3148423\n"

"help.text"

msgid "Multiplier"

#: 04060116.xhp

msgctxt ""

"210\n"

"help.text"

msgid "CONVERT_ADD(Number; \"FromUnit\"; \"ToUnit\")"

#: 04060116.xhp

msgctxt ""

"212\n"

"help.text"

msgid "<emph>FromUnit</emph> is the unit from which conversion is taking place."

#: 04060116.xhp

msgctxt ""

"213\n"

"help.text"

msgid "<emph>ToUnit</emph> is the unit to which conversion is taking place. Both units must be of the same type."

#: 04060116.xhp

msgctxt ""

"216\n"

"help.text"

msgid "<item type=\"input\">=CONVERT_ADD(10;\"km\";\"mi\") </item>returns, rounded to two decimal places, 6.21. 10 kilometers equal 6.21 miles. The k is the permitted prefix character for the factor 10^3."

#: 04060116.xhp

msgctxt ""

"bm_id3145112\n"

"help.text"

msgid "<bookmark_value>ODDFPRICE function</bookmark_value> <bookmark_value>prices;securities with irregular first interest date</bookmark_value>"

#: 04060118.xhp

msgctxt ""

"hd_id3145112\n"

"help.text"

msgid "ODDFPRICE"

#: 04060118.xhp

msgctxt ""

"par_id3147250\n"

"help.text"

msgid "<ahelp hid=\"HID_AAI_FUNC_ODDFPRICE\">Calculates the price per 100 currency units par value of a security, if the first interest date falls irregularly.</ahelp>"

#: 04060118.xhp

msgctxt ""

"par_id3146098\n"

"help.text"

msgid "ODDFPRICE(Settlement; Maturity; Issue; FirstCoupon; Rate; Yield; Redemption; Frequency; Basis)"

#: 04060118.xhp

msgctxt ""

msgstr "<emph>የ ተሰጠበት</emph> ደህንነቱ የ ተሰጠበት ቀን ነው"

#: 04060118.xhp

msgctxt ""

"04060118.xhp\n"

"par_id3150393\n"

"help.text"

msgid "<emph>FirstCoupon</emph> is the first interest date of the security."

#: 04060118.xhp

msgctxt ""

"par_id3151387\n"

"help.text"

msgid "<emph>Yield</emph> is the annual yield of the security."

#: 04060118.xhp

msgctxt ""

"par_id3153023\n"

"help.text"

msgid "<emph>Redemption</emph> is the redemption value per 100 currency units of par value."

#: 04060118.xhp

msgctxt ""

"par_id3147414\n"

"help.text"

msgid "<ahelp hid=\"HID_AAI_FUNC_ODDFYIELD\">Calculates the yield of a security if the first interest date falls irregularly.</ahelp>"

#: 04060118.xhp

msgctxt ""

msgstr "<emph>የ ተሰጠበት</emph> ደህንነቱ የ ተሰጠበት ቀን ነው"

#: 04060118.xhp

msgctxt ""

"04060118.xhp\n"

"par_id3148725\n"

"help.text"

msgid "<emph>FirstCoupon</emph> is the first interest period of the security."

#: 04060118.xhp

msgctxt ""

"par_id3149893\n"

"help.text"

msgid "<emph>Redemption</emph> is the redemption value per 100 currency units of par value."

#: 04060118.xhp

msgctxt ""

"hd_id3153933\n"

"help.text"

msgid "ODDLPRICE"

#: 04060118.xhp

msgctxt ""

"par_id3145145\n"

"help.text"

msgid "<ahelp hid=\"HID_AAI_FUNC_ODDLPRICE\">Calculates the price per 100 currency units par value of a security, if the last interest date falls irregularly.</ahelp>"

#: 04060118.xhp

msgctxt ""

"par_id3155262\n"

"help.text"

msgid "ODDLPRICE(Settlement; Maturity; LastInterest; Rate; Yield; Redemption; Frequency; Basis)"

#: 04060118.xhp

msgctxt ""

"par_id3153328\n"

"help.text"

msgid "<emph>Yield</emph> is the annual yield of the security."

#: 04060118.xhp

msgctxt ""

"par_id3149186\n"

"help.text"

msgid "<emph>Redemption</emph> is the redemption value per 100 currency units of par value."

#: 04060118.xhp

msgctxt ""

"par_id3152999\n"

"help.text"

msgid "Settlement date: February 7 1999, maturity date: June 15 1999, last interest: October 15 1998. Interest rate: 3.75 per cent, yield: 4.05 per cent, redemption value: 100 currency units, frequency of payments: half-yearly = 2, basis: = 0"

#: 04060118.xhp

msgctxt ""

"par_id3148567\n"

"help.text"

msgid "The price per 100 currency units per value of a security, which has an irregular last interest date, is calculated as follows:"

#: 04060118.xhp

msgctxt ""

"par_id3158002\n"

"help.text"

msgid "<ahelp hid=\"HID_AAI_FUNC_ODDLYIELD\">Calculates the yield of a security if the last interest date falls irregularly.</ahelp>"

#: 04060118.xhp

msgctxt ""

"par_id3150018\n"

"help.text"

msgid "ODDLYIELD(Settlement; Maturity; LastInterest; Rate; Price; Redemption; Frequency; Basis)"

#: 04060118.xhp

msgctxt ""

"par_id3148880\n"

"help.text"

msgid "<emph>Redemption</emph> is the redemption value per 100 currency units of par value."

#: 04060118.xhp

msgctxt ""

"par_id3145350\n"

"help.text"

msgid "Settlement date: April 20 1999, maturity date: June 15 1999, last interest: October 15 1998. Interest rate: 3.75 per cent, price: 99.875 currency units, redemption value: 100 currency units, frequency of payments: half-yearly = 2, basis: = 0"

#: 04060118.xhp

msgctxt ""

"par_id3157990\n"

"help.text"

msgid "The yield of the security, that has an irregular last interest date, is calculated as follows:"

#: 04060118.xhp

msgctxt ""

"bm_id3147485\n"

"help.text"

msgid "<bookmark_value>calculating;internal rates of return, irregular payments</bookmark_value> <bookmark_value>internal rates of return;irregular payments</bookmark_value> <bookmark_value>XIRR function</bookmark_value>"

#: 04060118.xhp

msgctxt ""

"par_id3163821\n"

"help.text"

msgid "<emph>Values</emph> and <emph>Dates</emph> refer to a series of payments and the series of associated date values. The first pair of dates defines the start of the payment plan. All other date values must be later, but need not be in any order. The series of values must contain at least one negative and one positive value (receipts and deposits)."

#: 04060118.xhp

msgctxt ""

"par_id3149708\n"

"help.text"

msgid "<emph>Guess</emph> (optional) is a guess that can be input for the internal rate of return. The default is 10%."

#: 04060118.xhp

msgctxt ""

"par_id3149273\n"

"help.text"

msgid "Calculation of the internal rate of return for the following five payments:"

#: 04060118.xhp

msgctxt ""

"par_id3153100\n"

"help.text"

msgid "<emph>Rate</emph> is the internal rate of return for the payments."

#: 04060118.xhp

msgctxt ""

"par_id3155395\n"

"help.text"

msgid "<emph>Values</emph> and <emph>Dates</emph> refer to a series of payments and the series of associated date values. The first pair of dates defines the start of the payment plan. All other date values must be later, but need not be in any order. The series of values must contain at least one negative and one positive value (receipts and deposits)"

#: 04060118.xhp

msgctxt ""

"par_id3154293\n"

"help.text"

msgid "<ahelp hid=\"HID_FUNC_ZGZ\">Calculates the interest rate resulting from the profit (return) of an investment.</ahelp>"

#: 04060118.xhp

msgctxt ""

"par_id3154212\n"

"help.text"

msgid "For four periods (years) and a cash value of 7,500 currency units, the interest rate of the return is to be calculated if the future value is 10,000 currency units."

#: 04060118.xhp

msgctxt ""

"par_id3145413\n"

"help.text"

msgid "The interest rate must be 7.46 % so that 7,500 currency units will become 10,000 currency units."

#: 04060118.xhp

msgctxt ""

"par_id3151052\n"

"help.text"

msgid "<ahelp hid=\"HID_FUNC_ZINS\">Returns the constant interest rate per period of an annuity.</ahelp>"

#: 04060118.xhp

msgctxt ""

"par_id3158423\n"

"help.text"

msgid "RATE(NPer; Pmt; PV; FV; Type; Guess)"

#: 04060118.xhp

msgctxt ""

"par_id3148910\n"

"help.text"

msgid "<emph>NPer</emph> is the total number of periods, during which payments are made (payment period)."

#: 04060118.xhp

msgctxt ""

"par_id3148925\n"

"help.text"

msgid "<emph>Pmt</emph> is the constant payment (annuity) paid during each period."

#: 04060118.xhp

msgctxt ""

"par_id3166456\n"

"help.text"

msgid "<emph>FV</emph> (optional) is the future value, which is reached at the end of the periodic payments."

#: 04060118.xhp

msgctxt ""

"par_id3153243\n"

"help.text"

msgid "<emph>Type</emph> (optional) is the due date of the periodic payment, either at the beginning or at the end of a period."

#: 04060118.xhp

msgctxt ""

"par_id3146949\n"

"help.text"

msgid "<emph>Guess</emph> (optional) determines the estimated value of the interest with iterative calculation."

#: 04060118.xhp

msgctxt ""

"par_id3150706\n"

"help.text"

msgid "What is the constant interest rate for a payment period of 3 periods if 10 currency units are paid regularly and the present cash value is 900 currency units."

#: 04060118.xhp

msgctxt ""

"par_id3155586\n"

"help.text"

msgid "<item type=\"input\">=RATE(3;10;900)</item> = -121% The interest rate is therefore 121%."

#: 04060118.xhp

msgctxt ""

"hd_id3149106\n"

"help.text"

msgid "INTRATE"

#: 04060118.xhp

msgctxt ""

"par_id3154337\n"

"help.text"

msgid "<emph>Redemption</emph> is the selling price."

#: 04060118.xhp

msgctxt ""

"par_id3149426\n"

"help.text"

msgid "A painting is bought on 1990-01-15 for 1 million and sold on 2002-05-05 for 2 million. The basis is daily balance calculation (basis = 3). What is the average annual level of interest?"

#: 04060118.xhp

msgctxt ""

"par_id3149927\n"

"help.text"

msgid "<ahelp hid=\"HID_AAI_FUNC_COUPNCD\">Returns the date of the first interest date after the settlement date. Format the result as a date.</ahelp>"

#: 04060118.xhp

msgctxt ""

"par_id3149488\n"

"help.text"

msgid "<ahelp hid=\"HID_AAI_FUNC_COUPDAYS\">Returns the number of days in the current interest period in which the settlement date falls.</ahelp>"

#: 04060118.xhp

msgctxt ""

"par_id3147100\n"

"help.text"

msgid "<ahelp hid=\"HID_AAI_FUNC_COUPDAYSNC\">Returns the number of days from the settlement date until the next interest date.</ahelp>"

#: 04060118.xhp

msgctxt ""

"par_id3146795\n"

"help.text"

msgid "<ahelp hid=\"HID_AAI_FUNC_COUPDAYBS\">Returns the number of days from the first day of interest payment on a security until the settlement date.</ahelp>"

#: 04060118.xhp

msgctxt ""

"par_id3153678\n"

"help.text"

msgid "<ahelp hid=\"HID_AAI_FUNC_COUPPCD\">Returns the date of the interest date prior to the settlement date. Format the result as a date.</ahelp>"

#: 04060118.xhp

msgctxt ""

"par_id3154350\n"

"help.text"

msgid "<ahelp hid=\"HID_AAI_FUNC_COUPNUM\">Returns the number of coupons (interest payments) between the settlement date and the maturity date.</ahelp>"

#: 04060118.xhp

msgctxt ""

msgstr "አገባብ"

#: 04060118.xhp

msgctxt ""

"04060118.xhp\n"

"par_id3151283\n"

"help.text"

msgid "IPMT(Rate; Period; NPer; PV; FV; Type)"

#: 04060118.xhp

msgctxt ""

"par_id3145158\n"

"help.text"

msgid "<emph>Period</emph> is the period, for which the compound interest is calculated. Period=NPER if compound interest for the last period is calculated."

#: 04060118.xhp

msgctxt ""

"par_id3147577\n"

"help.text"

msgid "<emph>NPer</emph> is the total number of periods, during which annuity is paid."

#: 04060118.xhp

msgctxt ""

"par_id3151213\n"

"help.text"

msgid "<emph>FV</emph> (optional) is the desired value (future value) at the end of the periods."

#: 04060118.xhp

msgctxt ""

"par_id3154195\n"

"help.text"

msgid "<emph>Type</emph> is the due date for the periodic payments."

#: 04060118.xhp

msgctxt ""

"par_id3149438\n"

"help.text"

msgid "What is the interest rate during the fifth period (year) if the constant interest rate is 5% and the cash value is 15,000 currency units? The periodic payment is seven years."

#: 04060118.xhp

msgctxt ""

"par_id3150496\n"

"help.text"

msgid "<item type=\"input\">=IPMT(5%;5;7;15000)</item> = -352.97 currency units. The compound interest during the fifth period (year) is 352.97 currency units."

#: 04060118.xhp

msgctxt ""

"04060118.xhp\n"

"bm_id3151205\n"

"help.text"

msgid "<bookmark_value>calculating;future values</bookmark_value> <bookmark_value>future values;constant interest rates</bookmark_value> <bookmark_value>FV function</bookmark_value>"

#: 04060118.xhp

msgctxt ""

"hd_id3151205\n"

"help.text"

msgid "FV"

#: 04060118.xhp

msgctxt ""

"par_id3156029\n"

"help.text"

msgid "<emph>NPer</emph> is the total number of periods (payment period)."

#: 04060118.xhp

msgctxt ""

"par_id3151322\n"

"help.text"

msgid "<emph>Pmt</emph> is the annuity paid regularly per period."

#: 04060118.xhp

msgctxt ""

"par_id3145256\n"

"help.text"

msgid "<emph>PV</emph> (optional) is the (present) cash value of an investment."

#: 04060118.xhp

msgctxt ""

"par_id3150999\n"

"help.text"

msgid "<emph>Type</emph> (optional) defines whether the payment is due at the beginning or the end of a period."

#: 04060118.xhp

msgctxt ""

"par_id3146813\n"

"help.text"

msgid "What is the value at the end of an investment if the interest rate is 4% and the payment period is two years, with a periodic payment of 750 currency units. The investment has a present value of 2,500 currency units."

#: 04060118.xhp

msgctxt ""

"par_id3149302\n"

"help.text"

msgid "<item type=\"input\">=FV(4%;2;750;2500) </item>= -4234.00 currency units. The value at the end of the investment is 4234.00 currency units."

#: 04060118.xhp

msgctxt ""

"bm_id3155912\n"

"help.text"

msgid "<bookmark_value>FVSCHEDULE function</bookmark_value> <bookmark_value>future values;varying interest rates</bookmark_value>"

#: 04060118.xhp

msgctxt ""

"hd_id3155912\n"

"help.text"

msgid "FVSCHEDULE"

#: 04060118.xhp

msgctxt ""

"par_id3148891\n"

"help.text"

msgid "FVSCHEDULE(Principal; Schedule)"

#: 04060118.xhp

msgctxt ""

"par_id3148904\n"

"help.text"

msgid "<emph>Principal</emph> is the starting capital."

#: 04060118.xhp

msgctxt ""

"par_id3148562\n"

"help.text"

msgid "<emph>Schedule</emph> is a series of interest rates, for example, as a range H3:H5 or as a (List) (see example)."

#: 04060118.xhp

msgctxt ""

"par_id3148638\n"

"help.text"

msgid "1000 currency units have been invested in for three years. The interest rates were 3%, 4% and 5% per annum. What is the value after three years?"

#: 04060118.xhp

msgctxt ""

"par_id3156358\n"

"help.text"

msgid "<item type=\"input\">=FVSCHEDULE(1000;{0.03;0.04;0.05})</item> returns 1124.76."

#: 04060118.xhp

msgctxt ""

"bm_id3156435\n"

"help.text"

msgid "<bookmark_value>calculating;number of payment periods</bookmark_value> <bookmark_value>payment periods;number of</bookmark_value> <bookmark_value>number of payment periods</bookmark_value> <bookmark_value>NPER function</bookmark_value>"

#: 04060118.xhp

msgctxt ""

"hd_id3156435\n"

"help.text"

msgid "NPER"

#: 04060118.xhp

msgctxt ""

msgstr "አገባብ"

#: 04060118.xhp

msgctxt ""

"04060118.xhp\n"

"par_id3155934\n"

"help.text"

msgid "NPER(Rate; Pmt; PV; FV; Type)"

#: 04060118.xhp

msgctxt ""

"par_id3149042\n"

"help.text"

msgid "<emph>Pmt</emph> is the constant annuity paid in each period."

#: 04060118.xhp

msgctxt ""

"par_id3154398\n"

"help.text"

msgid "<emph>FV</emph> (optional) is the future value, which is reached at the end of the last period."

#: 04060118.xhp

msgctxt ""

"par_id3145127\n"

"help.text"

msgid "<emph>Type</emph> (optional) is the due date of the payment at the beginning or at the end of the period."

#: 04060118.xhp

msgctxt ""

"par_id3147378\n"

"help.text"

msgid "How many payment periods does a payment period cover with a periodic interest rate of 6%, a periodic payment of 153.75 currency units and a present cash value of 2.600 currency units."

#: 04060118.xhp

msgctxt ""

"par_id3156171\n"

"help.text"

msgid "<item type=\"input\">=NPER(6%;153.75;2600)</item> = -12,02. The payment period covers 12.02 periods."

#: 04060118.xhp

msgctxt ""

"244\n"

"help.text"

msgid "<emph>NPer</emph> is the total number of periods during which annuity is paid."

#: 04060119.xhp

msgctxt ""

"04060119.xhp\n"

"par_id3153035\n"

"246\n"

"help.text"

msgid "<emph>FV</emph> (optional) is the desired (future) value."

#: 04060119.xhp

msgctxt ""

"247\n"

"help.text"

msgid "<emph>Type</emph> (optional) defines the due date. F = 1 for payment at the beginning of a period and F = 0 for payment at the end of a period."

#: 04060119.xhp

msgctxt ""

msgstr ""

#: 04060119.xhp

msgctxt ""

"04060119.xhp\n"

"par_id3150007\n"

"259\n"

"help.text"

msgid "<emph>S</emph> is the first period."

#: 04060119.xhp

msgctxt ""

"260\n"

"help.text"

msgid "<emph>E</emph> is the last period."

#: 04060119.xhp

msgctxt ""

"261\n"

"help.text"

msgid "<emph>Type</emph> is the due date of the payment at the beginning or end of each period."

#: 04060119.xhp

msgctxt ""

msgstr ""

#: 04060119.xhp

msgctxt ""

"04060119.xhp\n"

"par_id3145302\n"

"189\n"

"help.text"

msgid "<emph>StartPeriod</emph> is the first payment period for the calculation."

#: 04060119.xhp

msgctxt ""

"190\n"

"help.text"

msgid "<emph>EndPeriod</emph> is the last payment period for the calculation."

#: 04060119.xhp

msgctxt ""

"191\n"

"help.text"

msgid "<emph>Type</emph> is the maturity of a payment at the end of each period (Type = 0) or at the start of the period (Type = 1)."

#: 04060119.xhp

msgctxt ""

"194\n"

"help.text"

msgid "Rate: 9.00 per cent per annum (9% / 12 = 0.0075), Duration: 30 years (payment periods = 30 * 12 = 360), NPV: 125000 currency units."

#: 04060119.xhp

msgctxt ""

msgstr ""

#: 04060119.xhp

msgctxt ""

"04060119.xhp\n"

"par_id3149394\n"

"196\n"

"help.text"

msgid "<item type=\"input\">=CUMPRINC_ADD(0.0075;360;125000;13;24;0)</item> returns -934.1071"

#: 04060119.xhp

msgctxt ""

"197\n"

"help.text"

msgid "In the first month you will be repaying the following amount:"

#: 04060119.xhp

msgctxt ""

"04060119.xhp\n"

"par_id3154636\n"

"198\n"

"help.text"

msgid "<item type=\"input\">=CUMPRINC_ADD(0.0075;360;125000;1;1;0)</item> returns -68.27827"

#: 04060119.xhp

msgctxt ""

"266\n"

"help.text"

msgid "CUMIPMT"

#: 04060119.xhp

msgctxt ""

msgstr "አገባብ"

#: 04060119.xhp

msgctxt ""

"04060119.xhp\n"

"par_id3147536\n"

"269\n"

"help.text"

msgid "CUMIPMT(Rate; NPer; PV; S; E; Type)"

#: 04060119.xhp

msgctxt ""

"271\n"

"help.text"

msgid "<emph>NPer</emph> is the payment period with the total number of periods. NPER can also be a non-integer value."

#: 04060119.xhp

msgctxt ""

"273\n"

"help.text"

msgid "<emph>S</emph> is the first period."

#: 04060119.xhp

msgctxt ""

"274\n"

"help.text"

msgid "<emph>E</emph> is the last period."

#: 04060119.xhp

msgctxt ""

"275\n"

"help.text"

msgid "<emph>Type</emph> is the due date of the payment at the beginning or end of each period."

#: 04060119.xhp

msgctxt ""

"277\n"

"help.text"

msgid "What are the interest payments at a yearly interest rate of 5.5 %, a payment period of monthly payments for 2 years and a current cash value of 5,000 currency units? The start period is the 4th and the end period is the 6th period. The payment is due at the beginning of each period."

#: 04060119.xhp

msgctxt ""

"278\n"

"help.text"

msgid "<item type=\"input\">=CUMIPMT(5.5%/12;24;5000;4;6;1)</item> = -57.54 currency units. The interest payments for between the 4th and 6th period are 57.54 currency units."

#: 04060119.xhp

msgctxt ""

"165\n"

"help.text"

msgid "CUMIPMT_ADD"

#: 04060119.xhp

msgctxt ""

"166\n"

"help.text"

msgid "<ahelp hid=\"HID_AAI_FUNC_CUMIPMT\">Calculates the accumulated interest for a period.</ahelp>"

#: 04060119.xhp

msgctxt ""

"168\n"

"help.text"

msgid "CUMIPMT_ADD(Rate; NPer; PV; StartPeriod; EndPeriod; Type)"

#: 04060119.xhp

msgctxt ""

"170\n"

"help.text"

msgid "<emph>NPer</emph> is the total number of payment periods. The rate and NPER must refer to the same unit, and thus both be calculated annually or monthly."

#: 04060119.xhp

msgctxt ""

"172\n"

"help.text"

msgid "<emph>StartPeriod</emph> is the first payment period for the calculation."

#: 04060119.xhp

msgctxt ""

"173\n"

"help.text"

msgid "<emph>EndPeriod</emph> is the last payment period for the calculation."

#: 04060119.xhp

msgctxt ""

"174\n"

"help.text"

msgid "<emph>Type</emph> is the maturity of a payment at the end of each period (Type = 0) or at the start of the period (Type = 1)."

#: 04060119.xhp

msgctxt ""

"177\n"

"help.text"

msgid "Rate: 9.00 per cent per annum (9% / 12 = 0.0075), Duration: 30 years (NPER = 30 * 12 = 360), Pv: 125000 currency units."

#: 04060119.xhp

msgctxt ""

"180\n"

"help.text"

msgid "How much interest must you pay in the first month?"

#: 04060119.xhp

msgctxt ""

"12\n"

"help.text"

msgid "PRICE(Settlement; Maturity; Rate; Yield; Redemption; Frequency; Basis)"

#: 04060119.xhp

msgctxt ""

"16\n"

"help.text"

msgid "<emph>Yield</emph> is the annual yield of the security."

#: 04060119.xhp

msgctxt ""

"20\n"

"help.text"

msgid "A security is purchased on 1999-02-15; the maturity date is 2007-11-15. The nominal rate of interest is 5.75%. The yield is 6.5%. The redemption value is 100 currency units. Interest is paid half-yearly (frequency is 2). With calculation on basis 0, the price is as follows:"

#: 04060119.xhp

msgctxt ""

"25\n"

"help.text"

msgid "PRICEDISC(Settlement; Maturity; Discount; Redemption; Basis)"

#: 04060119.xhp

msgctxt ""

"29\n"

"help.text"

msgid "<emph>Redemption</emph> is the redemption value per 100 currency units of par value."

#: 04060119.xhp

msgctxt ""

"31\n"

"help.text"

msgid "A security is purchased on 1999-02-15; the maturity date is 1999-03-01. Discount in per cent is 5.25%. The redemption value is 100. When calculating on basis 2 the price discount is as follows:"

#: 04060119.xhp

msgctxt ""

"bm_id3154693\n"

"help.text"

msgid "<bookmark_value>PRICEMAT function</bookmark_value><bookmark_value>prices;interest-bearing securities</bookmark_value>"

#: 04060119.xhp

msgctxt ""

"33\n"

"help.text"

msgid "PRICEMAT"

#: 04060119.xhp

msgctxt ""

"36\n"

"help.text"

msgid "PRICEMAT(Settlement; Maturity; Issue; Rate; Yield; Basis)"

#: 04060119.xhp

msgctxt ""

"41\n"

"help.text"

msgid "<emph>Yield</emph> is the annual yield of the security."

#: 04060119.xhp

msgctxt ""

"Project-Id-Version: PACKAGE VERSION\n"

"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"

"POT-Creation-Date: 2016-07-04 16:53+0200\n"

"Last-Translator: Samson B <sambelet@yahoo.com>\n"

"Language-Team: LANGUAGE <LL@li.org>\n"

"Language: am\n"

"Plural-Forms: nplurals=2; plural=n > 1;\n"

"X-Accelerator-Marker: ~\n"

"X-Generator: Pootle 2.7\n"

#: address_auto.xhp

msgctxt ""

"par_id266609688\n"

"help.text"

msgid "You can assign custom display names to fields, field members, subtotals (with some restrictions), and grand totals inside pivot tables. A custom display name is assigned to an item by overwriting the original name with another name."

#: datapilot_filtertable.xhp

msgctxt ""

"par_id3153192\n"

"help.text"

msgid "You can use filters to remove unwanted data from a pivot table."

#: datapilot_filtertable.xhp

msgctxt ""

"par_id3150441\n"

"help.text"

msgid "Click the <emph>Filter</emph> button in the sheet to call up the dialog for the filter conditions. Alternatively, call up the context menu of the pivot table and select the <emph>Filter</emph> command. The <link href=\"text/scalc/01/12090103.xhp\" name=\"Filter\"><emph>Filter</emph></link> dialog appears. Here you can filter the pivot table."

#: datapilot_filtertable.xhp

msgctxt ""

"par_id315044199\n"

"help.text"

msgid "You can also click the arrow on a button in the pivot table to show a pop-up window. In this pop-up window, you can edit the visibility settings of the associated field."

#: datapilot_filtertable.xhp

msgctxt ""

"par_id0720201001344485\n"

"help.text"

msgid "The pop-up window displays a list of field members associated with that field. A check box is placed to the left of each field member name. When a field has an alternative display name that differs from its original name, that name is displayed in the list."

#: datapilot_filtertable.xhp

msgctxt ""

"par_id0720201001344449\n"

"help.text"

msgid "Enable or disable a checkbox to show or hide the associated field member in the pivot table."

#: datapilot_filtertable.xhp

msgctxt ""

"par_id0720201001344431\n"

"help.text"

msgid "Select a field member in the pop-up window and click the <item type=\"menuitem\">Show only the current item</item> button to show only the selected field member. All other field members are hidden in the pivot table."

#: datapilot_filtertable.xhp

msgctxt ""

"par_id0720201001344484\n"

"help.text"

msgid "Select a field member in the pop-up window and click the <item type=\"menuitem\">Hide only the current item</item> button to hide only the selected field member. All other field members are shown in the pivot table."

#: datapilot_filtertable.xhp

msgctxt ""

"par_id0720201001344578\n"

"help.text"

msgid "Commands enable you to sort the field members in ascending order, descending order, or using a custom sort list."

#: datapilot_filtertable.xhp

msgctxt ""

"par_id0720201001344811\n"

"help.text"

msgid "The arrow to open the pop-up window is normally black. When the field contains one or more hidden field members, the arrow is blue and displays a tiny square at its lower-right corner."

#: datapilot_filtertable.xhp

msgctxt ""

"par_id0720201001344884\n"

"help.text"

msgid "You can also open the pop-up window by positioning the cell cursor at the button and pressing <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+D."

#: datapilot_grouping.xhp

msgctxt ""

"21\n"

"help.text"

msgid "You can select a named range in which the pivot table is to be created, from the <emph>Results to</emph> box. If the results range does not have a name, enter the coordinates of the upper left cell of the range into the field to the right of the <emph>Results to</emph> box. You can also click on the appropriate cell to have the coordinates entered accordingly."

#: datapilot_tipps.xhp

msgctxt ""

"23\n"

"help.text"

msgid "If you mark the <emph>Ignore empty rows</emph> check box, they will not be taken into account when the pivot table is created."

#: datapilot_tipps.xhp

msgctxt ""

"24\n"

"help.text"

msgid "If the <emph>Identify categories</emph> check box is marked, the categories will be identified by their headings and assigned accordingly when the pivot table is created."

#: datapilot_updatetable.xhp

msgctxt ""

"34\n"

"help.text"

msgid "If the data of the source sheet has been changed, $[officename] recalculates the pivot table. To recalculate the table, choose <emph>Data - Pivot Table - Refresh</emph>. Do the same after you have imported an Excel pivot table into $[officename] Calc."

#: dbase_files.xhp

msgctxt ""

"30\n"

"help.text"

msgid "It is also possible to nest functions in formulas, as shown in the example. You can also nest functions within functions. The Function Wizard assists you with nested functions."

#: formulas.xhp

msgctxt ""

"4\n"

"help.text"

msgid "To calculate annual interest (I), create a table with the values for the capital (C), number of years (n), and interest rate (i). The formula is:"

#: goalseek.xhp

msgctxt ""

"15\n"

"help.text"

msgid "Let us assume that the interest rate <item type=\"literal\">i</item> of 7.5% and the number of years <item type=\"literal\">n</item> (1) will remain constant. However, you want to know how much the investment capital <item type=\"literal\">C</item> would have to be modified in order to attain a particular return <item type=\"literal\">I</item>. For this example, calculate how much capital <item type=\"literal\">C</item> would be required if you want an annual return of $15,000."

#: goalseek.xhp

msgctxt ""

"6\n"

"help.text"

msgid "Enter each of the values for Capital <item type=\"literal\">C</item> (an arbitrary value like <item type=\"literal\">$100,000</item>), number of years <item type=\"literal\">n </item>(<item type=\"literal\">1</item>), and interest rate <item type=\"literal\">i</item> (<item type=\"literal\">7.5%</item>) in one cell each. Enter the formula to calculate the interest <item type=\"literal\">I</item> in another cell. Instead of <item type=\"literal\">C</item>, <item type=\"literal\">n</item>, and <item type=\"literal\">i</item> use the <link href=\"text/scalc/guide/relativ_absolut_ref.xhp\">reference to the cell</link> with the corresponding value."

#: goalseek.xhp

msgctxt ""

"Project-Id-Version: PACKAGE VERSION\n"

"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"

"POT-Creation-Date: 2016-05-23 21:37+0200\n"

"Last-Translator: Samson B <sambelet@yahoo.com>\n"

"Language-Team: LANGUAGE <LL@li.org>\n"

"Language: am\n"

"Plural-Forms: nplurals=2; plural=n > 1;\n"

"X-Accelerator-Marker: ~\n"

"X-Generator: Pootle 2.7\n"

#: 00000001.xhp

msgctxt ""

"44\n"

"help.text"

msgid "FTP stands for File Transfer Protocol and is the standard transfer protocol for files in the Internet. An FTP server is a program on a computer connected to the Internet which stores files to be transmitted with the aid of FTP. While FTP is responsible for transmitting and downloading Internet files, <link href=\"text/shared/00/00000002.xhp#http\" name=\"HTTP\">HTTP</link> (Hypertext Transfer Protocol) provides the connection setup and data transfer between WWW servers and clients."

#: 00000002.xhp

msgctxt ""

"58\n"

"help.text"

msgid "If you want to type HTML commands directly, for example when doing exercises from one of the many available HTML books, remember that HTML pages are pure text files. Save your document under the document type <emph>Text </emph>and give it the file name extension .HTML. Be sure there are no umlauts or other special characters of the extended character set. If you want to re-open this file in $[officename] and edit the HTML code, you must load it with the file type <emph>Text</emph> and not with the file type <emph>Web pages</emph>."

#: 00000002.xhp

msgctxt ""

"60\n"

"help.text"

msgid "The Hypertext Transfer Protocol is a record of transmission of WWW documents between WWW servers (hosts) and browsers (clients)."

#: 00000002.xhp

msgctxt ""

"62\n"

"help.text"

msgid "Hyperlinks are cross-references, highlighted in text in various colors and activated by mouse-click. With the aid of hyperlinks, readers can jump to specific information within a document as well as to related information in other documents."

#: 00000002.xhp

msgctxt ""

"63\n"

"help.text"

msgid "In $[officename] you can assign hyperlinks to text as well as to graphics and text frames (see the Hyperlink Dialog icon on the Standard bar)."

#: 00000002.xhp

msgctxt ""

"65\n"

"help.text"

msgid "An ImageMap is a reference-sensitive graphic or text frame. You can click on defined areas of the graphic or text frame to go to a target (<link href=\"text/shared/00/00000002.xhp#url\" name=\"URL\">URL</link>), which is linked with the area. The reference areas, along with the linked URLs and corresponding text displayed when resting the mouse pointer on these areas, are defined in the <link href=\"text/shared/01/02220000.xhp\" name=\"ImageMap Editor\">ImageMap Editor</link>."

#: 00000002.xhp

msgctxt ""

"66\n"

"help.text"

msgid "There are two different types of ImageMaps. A Client Side ImageMap is evaluated on the client computer, which loaded the graphic from the Internet, while a Server Side ImageMap is evaluated on the server computer which provides the <link href=\"text/shared/00/00000002.xhp#html\" name=\"HTML\">HTML</link> page on the Internet. In server evaluation, clicking an ImageMap sends the relative coordinates of the cursor within the image to the server, and a dedicated program on the server responds. In the client evaluation, clicking a defined hotspot of the ImageMap activates the URL, as if it were a normal text link. The URL appears below the mouse pointer when passing across the ImageMap."

#: 00000002.xhp

msgctxt ""

"69\n"

"help.text"

msgid "ImageMaps are basically divided between those that are analyzed on the server (i. e. your Internet provider) and those analyzed on the web browser of the reader's computer."

#: 00000002.xhp

msgctxt ""

"71\n"

"help.text"

msgid "Server Side ImageMaps appear for the reader as a picture or frame on the page. Click on the ImageMap with the mouse, and the coordinates of the relative position are sent to the server. Aided by an extra program, the server then determines the next step to take. There are several incompatible methods to define this process, the two most common being:"

#: 00000002.xhp

msgctxt ""

"76\n"

"help.text"

msgid "The area of the picture or frame where the reader can click is indicated by the appearance of the linked <link href=\"text/shared/00/00000002.xhp#url\" name=\"URL\">URL</link> when the mouse passes over the area. The ImageMap is stored in a layer below the picture and contains information about the referenced regions. The only disadvantage of Client Side ImageMaps is that older Web browsers cannot read them; a disadvantage that will, however, resolve itself in time."

#: 00000002.xhp

msgctxt ""

"114\n"

"help.text"

msgid "Plug-ins, generally speaking, are software additions to particular applications which provide enhanced functionality. Often import and export filters for various file formats are stored as plug-ins in a plug-in directory."

#: 00000002.xhp

msgctxt ""

"231\n"

"help.text"

msgid "<link href=\"text/shared/00/00000002.xhp#html\" name=\"HTML\">HTML</link> is a specialized application of SGML. This means that most Web browsers support only a limited range of SGML standards and that almost all SGML-enabled systems can produce attractive HTML pages."

#: 00000002.xhp

msgctxt ""

"139\n"

"help.text"

msgid "A search engine is a service in the Internet based on a software program used to explore a vast amount of information using key words."

#: 00000002.xhp

msgctxt ""

"142\n"

"help.text"

msgid "<link href=\"text/shared/00/00000002.xhp#html\" name=\"HTML\">HTML</link> pages contain certain structural and formatting instructions called tags. Tags are code words enclosed by brackets in the document description language HTML. Many tags contain text or hyperlink references between the opening and closing brackets. For example, titles are marked by the tags <h1> at the beginning and </h1> at the end of the title. Some tags only appear on their own such as <br> for a line break or <img ...> to link a graphic."

#: 00000002.xhp

msgctxt ""

"146\n"

"help.text"

msgid "The Uniform Resource Locator (URL) displays the address of a document or a server in the Internet. The general structure of a URL varies according to type and is generally in the form Service://Hostname:Port/Path/Page#Mark although not all elements are always required. An URL can be a FTP address, a WWW (HTTP) address, a file address or an e-mail address."

#: 00000003.xhp

msgctxt ""

"3\n"

"help.text"

msgid "Use the glossary to look up unfamiliar terms found in any $[officename] application."

#: 00000005.xhp

msgctxt ""

"23\n"

"help.text"

msgid "Abbreviation for American Standard Code for Information Interchange. ASCII is a character set for displaying fonts on personal computers. It consists of 128 characters including letters, numbers, punctuation and symbols. The extended ASCII character set contains 256 characters. Each character has been assigned a unique number, also referred to as ASCII Code."

#: 00000005.xhp

msgctxt ""

"30\n"

"help.text"

msgid "DDE stands for \"Dynamic Data Exchange,\" which is a predecessor of OLE, \"Object Linking and Embedding\". With DDE, objects are linked through file reference, but not embedded."

#: 00000005.xhp

msgctxt ""

"79\n"

"help.text"

msgid "You can create a DDE link using the following procedure: Select cells from a Calc spreadsheet, copy them into the clipboard and switch to another spreadsheet and select the <emph>Edit - Paste Special</emph> dialog. Select <emph>the Link</emph> option to insert the contents as a DDE link. When activating a link, the inserted cell area will be read from its original file."

#: 00000005.xhp

msgctxt ""

"7\n"

"help.text"

msgid "<variable id=\"andock1\">Some windows in $[officename], for example the Styles and Formatting window and the Navigator, are \"dockable\" windows. You can move these windows, re-size them or dock them to an edge. On each edge you can dock several windows on top of, or alongside each other; then, by moving the border lines, you can change the relative proportions of the windows.</variable>"

#: 00000005.xhp

msgctxt ""

"115\n"

"help.text"

msgid "On any window edge where another window is docked you will see a button which allows you to show or hide the window."

#: 00000005.xhp

msgctxt ""

"161\n"

"help.text"

msgid "If you click the button on the window edge to show the window, the window will remain visible until you manually hide it again (with the same button)."

#: 00000005.xhp

msgctxt ""

"Project-Id-Version: PACKAGE VERSION\n"

"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"

"POT-Creation-Date: 2016-07-04 16:53+0200\n"

"Last-Translator: Samson B <sambelet@yahoo.com>\n"

"Language-Team: LANGUAGE <LL@li.org>\n"

"Language: am\n"

"Plural-Forms: nplurals=2; plural=n > 1;\n"

"X-Accelerator-Marker: ~\n"

"X-Generator: Pootle 2.7\n"

#: 01010000.xhp

msgctxt ""

msgstr "ፖሊጎን"

#: 02220000.xhp

msgctxt ""

"02220000.xhp\n"

"hd_id3153140\n"

"2\n"

"help.text"

msgid "<variable id=\"dokzus\"><ahelp hid=\".uno:MergeDocuments\" visibility=\"visible\">Imports changes made to copies of the same document into the original document. Changes made to footnotes, headers, frames and fields are ignored.</ahelp></variable> Identical changes are merged automatically."

#: 02240000.xhp

msgctxt ""

"37\n"

"help.text"

msgid "<ahelp hid=\"modules/sbibliography/ui/mappingdialog/MappingDialog\">Select the data field that you want to map to the current <emph>Column name</emph>. To change the available data fields, select a different data source for your bibliography.</ahelp>"

#: 02250000.xhp

msgctxt ""

"par_id3157898\n"

"help.text"

msgid "Currently only the Internet/Intranet Input Method Protocol (IIIMP) under Unix is supported."

#: 03050000.xhp

msgctxt ""

"54\n"

"help.text"

msgid "Asian text font - Chinese, Japanese, or Korean character sets"

#: 05020100.xhp

msgctxt ""

"122\n"

"help.text"

msgid "Era, abbreviation"

#: 05020301.xhp

msgctxt ""

"par_id1002200811563430\n"

"help.text"

msgid "N"

#: 05020301.xhp

msgctxt ""

"par_id1002200811563488\n"

"help.text"

msgid "G"

#: 05020301.xhp

msgctxt ""

"par_id1002200811563518\n"

"help.text"

msgid "J"

#: 05020301.xhp

msgctxt ""

"par_id1002200811563735\n"

"help.text"

msgid "T"

#: 05020301.xhp

msgctxt ""

"par_id1002200811563852\n"

"help.text"

msgid "J"

#: 05020301.xhp

msgctxt ""

"par_id1002200811563827\n"

"help.text"

msgid "U"

#: 05020301.xhp

msgctxt ""

"par_id1002200811563970\n"

"help.text"

msgid "A"

#: 05020301.xhp

msgctxt ""

"par_id1002200811563980\n"

"help.text"

msgid "J"

#: 05020301.xhp

msgctxt ""

"par_id1002200811564065\n"

"help.text"

msgid "O"

#: 05020301.xhp

msgctxt ""

"par_id100220081156403\n"

"help.text"

msgid "A"

#: 05020301.xhp

msgctxt ""

"par_id1002200811564042\n"

"help.text"

msgid "G"

#: 05020301.xhp

msgctxt ""

"par_id100220081156412\n"

"help.text"

msgid "O"

#: 05020301.xhp

msgctxt ""

"par_id1002200811564119\n"

"help.text"

msgid "X"

#: 05020301.xhp

msgctxt ""

"par_id1002200811564272\n"

"help.text"

msgid "A"

#: 05020301.xhp

msgctxt ""

"par_id100220081156423\n"

"help.text"

msgid "O"

#: 05020301.xhp

msgctxt ""

"par_id1002200811564390\n"

"help.text"

msgid "A"

#: 05020301.xhp

msgctxt ""

"par_id1002200811564319\n"