File: //lib64/libreoffice/program/resource/scen-US.res
a� R" ? Insert Delete Cut Insert � Drag and Drop Move Copy Delete Attributes " "Attributes/Lines Column Width
& &Optimal Column Width Row height $ $Optimal Row Height
Fill Merge Split AutoFormat Replace Attributes Input $ $Insert Column Break $ $Delete column break " "Insert Row Break " "Delete row break View Details Hide details Group Ungroup & &Select outline level View Details Hide details Clear Outline AutoOutline ! Subtotals " Sort # Filter $ & &Change Database Range % Importing & Refresh range � Edit Image � List names � $ $Create pivot table � " "Edit pivot table � $ $Delete pivot table � Consolidate � Use scenario � Create scenario W Edit scenario � " "Apply Cell Style e Edit Cell Style d " "Apply Page Style f Edit Page Style � " "Trace Precedents � " "Remove Precedent � " "Trace Dependents � " "Remove Dependent � Trace Error � " "Remove all Traces / " "Mark invalid data � Refresh Traces ( (Modify chart data range Original Size
Update Link Unlink ' Insert Link & &Insert Array Formula � Insert Comment � Delete Comment � Show Comment � Hide Comment Z Edit Comment b Decrease Indent c Increase Indent ? Protect sheet @ Unprotect sheet A " "Protect document B $ $Unprotect document a Print range H $ $Delete Page Breaks I Change Scale J Move Page Break ] " "Edit range names h Change Case u Import ' " "%PRODUCTNAME Calc ( Delete data? ) & &Unable to insert rows * * *No operations to execute + t tThe range does not contain column headers.
Do you want the first line to be used as column header? , , ,Error while importing data! _ 6 6The database '#' could not be opened. N 4 4The query '#' could not be opened. C & &# records imported... - & &Grouping not possible . ( (Ungrouping not possible / < <Insert into multiple selection not possible 0 B BCell merge not possible if cells already merged! 1 B BCell merge not possible if cells already merged! 2 : :Inserting into merged ranges not possible 3 8 8Deleting in merged ranges not possible 4 @ @Cell merge not possible if cells already merged D T TRanges containing merged cells can only be sorted without formats. 5 . .Goal Seek succeeded. Result: 6 < <
Insert the result into the variable cell? 7 $ $Goal Seek failed.
8 , ,Insert the closest value ( 9 2 2) into the variable cell anyway? : Grand Total ; Result < Spellcheck = AND > OR @ Sheet A * *- move to end position - B 0 0Not implemented in this build. C #REF! Q > >The data range must contain at least one row. } B BThe pivot table must contain at least one entry. ~ 4 4The data range can not be deleted. � 0 0Error creating the pivot table. L . .Pivot tables can not overlap. M R RThe destination range is not empty. Overwrite existing contents? g b bThe source range contains subtotals which may distort the results. Use it anyway? � $ $Create Pivot Table O Total P Data � Group R Sheet . .$1 rows, $2 columns selected ( ($1 of $2 records found S Column T Row � Page � Page %1 U Load document V Save document W * *<unknown table reference> X 6 6This range has already been inserted. Y * *Invalid sheet reference. Z < <This range does not contain a valid query. [ < <This range does not contain imported data. \ H HThis function cannot be used with multiple selections. ] Fill Row... ^ " "Unknown filter: d Thesaurus e Fill Sheets g : :Add selected ranges to current scenario? h d dThe scenario ranges must be selected in order to be able to create a new scenario. w 0 0A range has not been selected. k * *This name already exists. x � �Invalid sheet name.
The sheet name must not be a duplicate of an existing name
and may not contain the characters [ ] * ? : / \ i Scenario j Pivot Table l Sum Selection count m Count " CountA n Average Median o Max p Min q Product r StDev s Var v 2 2No chart found at this position. y 8 8No pivot table found at this position. | (empty) $ $Invalid print range � Page Style � Header � Footer � Text Attributes � \ � PAGE � PAGES � DATE � TIME � FILE � SHEET � 6 6Protected cells can not be modified. ` 4 4Document opened in read-only mode. $ : :You cannot change only part of an array. � Header � Footer z Err: � 0 0Error: Ranges do not intersect � ( (Error: Division by zero � ( (Error: Wrong data type � . .Error: Not a valid reference � $ $Error: Invalid name � . .Error: Invalid numeric value � , ,Error: Value not available i #ADDIN? j ( (Error: Add-in not found k #MACRO? l ( (Error: Macro not found � , ,Internal syntactical error � ( (Error: Invalid argument � ( (Error in parameter list � * *Error: Invalid character � * *Error: Invalid semicolon � & &Error: in bracketing � ( (Error: Operator missing � ( (Error: Variable missing � ( (Error: Formula overflow � ( (Error: String overflow � * *Error: Internal overflow � , ,Error: Array or matrix size � * *Error: Circular reference � 6 6Error: Calculation does not converge � Grid color � V VShould the contents of the hidden cells be moved into the first cell? � Filter � : :The target database range does not exist. � " "Invalid increment � $ $MULTIPLE.OPERATIONS � $ $Multiple operations � v vYou have entered an invalid name.
AutoFormat could not be created.
Try again using a different name. � Range � Yes � No � Protection � Formulas � Hide � Print � ^ ^To apply an AutoFormat,
a table range of at least
3x3 cells must be selected. � (nested) � (optional) � (required) � invalid � Edit Function � Comments � H HAre you sure you want to delete the selected sheet(s)? V H HAre you sure you want to delete the selected scenario? � , ,Thesaurus is not available � * *Spellcheck not available � " "Import text files � " "Export Text File � $ $Import Lotus files � $ $Import DBase files c DBase export Dif Export Dif Import � Default � Result � Result2 � Heading � Heading1 � Report � Report1 � � �is not available for spellchecking
Please check your installation and install
the desired language if necessary � : :Thesaurus can only be used in text cells! � Z ZShould the spellcheck be continued at the beginning of the current sheet? � � �is not available for the thesaurus.
Please check your installation and install
the desired language if necessary � B BThe spellcheck of this sheet has been completed. � No language set � Insert Sheet � Delete Sheets � Rename Sheet � Color Tab � Color Tabs � Move Sheets � Copy Sheet � Append sheet % Show Sheet � Show Sheets & Hide sheet � Hide sheets r Flip sheet � 0 0Toggle the use of R1C1 notation � Main Title � Subtitle � X axis title � Y axis title � Z axis title � d dThe new table contains absolute references to other tables which may be incorrect! � n nDue to identical names, an existing range name in the destination document has been altered! � ( (AutoFilter not possible � 2 2Replace existing definition of #? � 2 2Invalid selection for range names � F FReferences can not be inserted above the source data. � $ $Scenario not found � : :Do you really want to delete the entry #? � Objects/Images � Charts � Drawing Objects � Show � Hide � Top to bottom � Left-to-right � Comments � Grid � & &Row & Column Headers � Formulas � Zero Values Print direction " "First page number ( (Reduce/enlarge printout 6 6Fit print range(s) on number of pages m 4 4Fit print range(s) to width/height n Width o Height p %1 page(s) q automatic t Statistics 0 0The link could not be updated. File: Sheet:
Overview Doc.Information Created Modified Printed Subject Key words Comments by on R RThis file contains links to other files.
Should they be updated? ( � �This file contains queries. The results of these queries were not saved.
Do you want these queries to be repeated? $ $Too many conditions B BFilled cells cannot be shifted
beyond the sheet. 2 2The table could not be inserted. [ 2 2The sheets could not be deleted. D DThe contents of the clipboard could not be pasted. H HThere is not enough space on the sheet to insert here. a r rThe content of the clipboard is bigger than the range selected.
Do you want to insert it anyway? ! D DNo cell references are found in the selected cells. , : :Source and destination must not overlap. * Image + Invalid name. - * *Selected macro not found. . Invalid value. 0 calculating 1 sorting 2 " "Adapt row height P Compare # ) p pThe maximum number of invalid cells has been exceeded.
Not all invalid cells have been marked. 3 Delete contents K %1 R x %2 C 4 More... Invalid range 5 " "Pivot Table Value 6 $ $Pivot Table Result 7 & &Pivot Table Category 8 " "Pivot Table Title 9 " "Pivot Table Field : $ $Pivot Table Corner ; Filter < Sort = Subtotals > None : :Do you want to replace the contents of #? E Width: F Height: G Hide O 2 2The object could not be inserted. Q <empty> R 2 2Cell #1 changed from '#2' to '#3' S #1 inserted T #1 deleted U * *Range moved from #1 to #2 X Exit Recording Y � �This action will exit the change recording mode.
Any information about changes will be lost.
Exit change recording mode?
\ N NThe document can not be closed while a link is being updated. ^ " "Adapt array area _ , ,Array formula %1 R x %2 C b V VThis document contains macro function calls.
Do you want to run them? s ( (Hangul/Hanja Conversion u Select Cell v Select Range w & &Select Database Range x Go To Row y Go To Sheet z & &Define Name for Range { L LThe selection needs to be rectangular in order to name it. | ^ ^You must enter a valid reference or type a valid name for the selected range. } n nWARNING: This action may have resulted in unintended changes to cell references in formulas. ~ n nWARNING: This action may have resulted in references to the deleted area not being restored. t $ $Chinese conversion @ @You cannot change this part of the pivot table. � Manual � Automatic � 2 2Nested arrays are not supported. � Text to Columns � V VYour spreadsheet has been updated with changes saved by other users. � f fThe spreadsheet must be saved now to activate sharing mode.
Do you want to continue? � � �Already resolved merge conflicts will be lost and your changes to the shared spreadsheet will not be saved.
Do you want to continue? � � �Disabling shared mode of a spreadsheet hinders all other users of the shared spreadsheet to merge back their work.
Do you want to continue? � � �This spreadsheet is no longer in shared mode.
Save your spreadsheet to a separate file and merge your changes to the shared spreadsheet manually. � � �The spreadsheet is in shared mode. This allows multiple users to access and edit the spreadsheet at the same time.
Changes to formatting attributes like fonts, colors, and number formats will not be saved and some functionalities like editing charts and drawing objects are not available in shared mode. Turn off shared mode to get exclusive access needed for those changes and functionalities. � � �The shared spreadsheet file is locked due to a merge in progress by user: '%1'
Sharing mode of a locked file cannot be disabled. Try again later. � � �The shared spreadsheet file is locked due to a merge in progress by user: '%1'
Try again later to save your changes. � Unknown User � AutoShape � Rectangle � Line � Oval � Text Box � Button � Check Box � Option Button � Label � List Box � Group Box � Drop Down � Spinner � Scroll Bar � Cell Styles � Page Styles � 4 4Pivot table source data is invalid. � � �One or more fields appear to have an empty name. Check the first row of the data source to ensure there are no empty cells. � R RPivot table needs at least two rows of data to create or refresh. � � �Because the current formula separator settings conflict with the locale, the formula separators have been reset to their default values. � $ $Insert Current Date � $ $Insert Current Time � Manage Names... � Name � , ,Range or formula expression � Scope � (multiple) � " "Document (Global) � F FInvalid name. Already in use for the selected scope. � H HInvalid name. Only use letters, numbers and underscore. � l lThis Document contains external references to unsaved documents.
Do you want to continue? � � �This Document is referenced by another document and not yet saved. Closing it without saving will result in data loss. � Range � First Condition � Cell value is � ColorScale � DataBar � IconSet � between � not between � unique � duplicate � Formula is � Top Elements � Bottom Elements � Top Percent � Date is � Bottom Percent � Above Average � Below Average � ( (Above or equal Average � ( (Below or equal Average � an Error code � " "not an Error code � Begins with � Ends with � Contains � Not Contains � today � yesterday � tomorrow � $ $in the last 7 days � this week � last week � next week � this month � last month � next month � this year � last year � next year ` and � ` `Conditional Formats can not be created, deleted or changed in protected sheets! � � �The selected cell already contains conditional formatting. You can either edit the existing conditional format or you define a new overlapping conditional format.
Do you want to edit the existing conditional format? � � �This document was last saved by an application other than %PRODUCTNAME. Some formula cells may produce different results when recalculated.
Do you want to recalculate all formula cells in this document now? � � �This document was last saved by Excel. Some formula cells may produce different results when recalculated.
Do you want to recalculate all formula cells now? � B BAlways perform this without prompt in the future. � h hYou cannot insert or delete cells when the affected range intersects with pivot table. � Seconds � Minutes � Hours � Days � Months � Quarters � Years � & &Invalid target value. 2 2Undefined name for variable cell. 0 0Undefined name as formula cell. 6 6Formula cell must contain a formula. Invalid input. $ $Invalid condition. 0 0Should the entry
#
be deleted? Copy List List from 6 6Cells without text have been ignored.
* *%s-Click to follow link: * *click to open hyperlink:
No Data " "Print Range Empty $ $Conditional Format * *Convert Formula To Value N NStrings without quotes are interpreted as column/row labels. Enter a value! Sheet %1 of %2 %1 and %2 more General Number Percent Currency Date Time Scientific Fraction Boolean Value Text a� � 4 4Impossible to connect to the file. * *File could not be opened. 0 0An unknown error has occurred. 4 4Not enough memory while importing. 0 0Unknown Lotus1-2-3 file format. : :Error in file structure while importing. B BThere is no filter available for this file type. : :Unknown or unsupported Excel file format. 8 8Excel file format not yet implemented.
2 2This file is password-protected. ( (Internal import error. V VThe file contains data after row 8192 and therefore can not be read. b bFormat error discovered in the file in sub-document $(ARG1) at $(ARG2)(row,col). > >File format error found at $(ARG1)(row,col). B BConnection to the file could not be established. , ,Data could not be written. $(ARG1) | |Cell $(ARG1) contains characters that are not representable in the selected target character set "$(ARG2)". � �Cell $(ARG1) contains a string that is longer in the selected target character set "$(ARG2)" than the given field width. 2 2Only the active sheet was saved. ^ ^The maximum number of rows has been exceeded. Excess rows were not imported! t tThe data could not be loaded completely because the maximum number of rows per sheet was exceeded. v vThe data could not be loaded completely because the maximum number of columns per sheet was exceeded. � �Not all sheets have been loaded because the maximum number of sheets was exceeded.
Please be warned that re-saving this document will permanently delete those sheets that have not been loaded! x xThe data could not be loaded completely because the maximum number of characters per cell was exceeded.
< <Corresponding FM3-File could not be opened. D DError in file structure of corresponding FM3-File. Z ZDocument too complex for automatic calculation. Press F9 to recalculate. x xThe document contains more rows than supported in the selected format.
Additional rows were not saved. ~ ~The document contains more columns than supported in the selected format.
Additional columns were not saved. | |The document contains more sheets than supported in the selected format.
Additional sheets were not saved. � �The document contains information not recognized by this program version.
Resaving the document will delete this information! N NNot all cell contents could be saved in the specified format. � �The following characters could not be converted to the selected character set
and were written as Ӓ surrogates:
$(ARG1) b bFormat error discovered in the file in sub-document $(ARG1) at $(ARG2)(row,col). 2 2Not all attributes could be read. a� �" � 4 SC_HID_FUNC_DBANZAHL \ \Counts the cells of a data range whose contents match the search criteria. Database 4 4The range of cells containing data. Database field ` `Indicates which database field (column) is to be used for the search criteria. Search criteria H HDefines the cell range containing the search criteria.
� 4 SC_HID_FUNC_DBANZAHL2 r rCounts all non-blank cells of a data range where the content corresponds to the search criteria. Database 4 4The range of cells containing data. Database field ` `Indicates which database field (column) is to be used for the search criteria. Search criteria H HDefines the cell range containing the search criteria. � 8 SC_HID_FUNC_DBMITTELWERT v vReturns the average value of all the cells of a data range whose contents match the search criteria. Database 4 4The range of cells containing data. Database field ` `Indicates which database field (column) is to be used for the search criteria. Search criteria H HDefines the cell range containing the search criteria. � 4 SC_HID_FUNC_DBAUSZUG d dDefines the contents of the cell of a data range which matches the search criteria. Database 4 4The range of cells containing data. Database field ` `Indicates which database field (column) is to be used for the search criteria. Search criteria H HDefines the cell range containing the search criteria. � 0 SC_HID_FUNC_DBMAX z zReturns the maximum value from all of the cells of a data range which correspond to the search criteria. Database 4 4The range of cells containing data. Database field ` `Indicates which database field (column) is to be used for the search criteria. Search criteria H HDefines the cell range containing the search criteria. � 0 SC_HID_FUNC_DBMIN x xReturns the minimum of all cells of a data range where the contents correspond to the search criteria. Database 4 4The range of cells containing data. Database field ` `Indicates which database field (column) is to be used for the search criteria. Search criteria H HDefines the cell range containing the search criteria. � 4 SC_HID_FUNC_DBPRODUKT d dMultiplies all cells of a data range where the contents match the search criteria. Database 4 4The range of cells containing data. Database field ` `Indicates which database field (column) is to be used for the search criteria. Search criteria H HDefines the cell range containing the search criteria. � 4 SC_HID_FUNC_DBSTDABW z zCalculates the standard deviation of all cells in a data range whose contents match the search criteria. Database 4 4The range of cells containing data. Database field ` `Indicates which database field (column) is to be used for the search criteria. Search criteria H HDefines the cell range containing the search criteria. � 4 SC_HID_FUNC_DBSTDABWN � �Returns the standard deviation with regards to the population of all cells of a data range matching the search criteria. Database 4 4The range of cells containing data. Database field ` `Indicates which database field (column) is to be used for the search criteria. Search criteria H HDefines the cell range containing the search criteria. � 2 SC_HID_FUNC_DBSUMME b bAdds all the cells of a data range where the contents match the search criteria. Database 4 4The range of cells containing data. Database field ` `Indicates which database field (column) is to be used for the search criteria. Search criteria H HDefines the cell range containing the search criteria. � 4 SC_HID_FUNC_DBVARIANZ x xDetermines the variance of all the cells in a data range where the contents match the search criteria. Database 4 4The range of cells containing data. Database field ` `Indicates which database field (column) is to be used for the search criteria. Search criteria H HDefines the cell range containing the search criteria. � 6 SC_HID_FUNC_DBVARIANZEN � �Determines variance of a population based on all cells in a data range where contents match the search criteria. Database 4 4The range of cells containing data. Database field ` `Indicates which database field (column) is to be used for the search criteria. Search criteria H HDefines the cell range containing the search criteria. � � 0 SC_HID_FUNC_DATUM @ @Provides an internal number for the date given. year n nAn integer between 1583 and 9956 or 0 and 99 (19xx or 20xx depending on the defined option). month D DAn integer between 1 and 12 representing the month. day P PAn integer between 1 and 31 representing the day of the month. � . SC_HID_FUNC_DATWERT V VReturns an internal number for a text having a possible date format. text h hA text enclosed in quotation marks which returns a date in a %PRODUCTNAME date format. v � * SC_HID_FUNC_TAG n nReturns the sequential date of the month as an integer (1-31) in relation to the date value. Number 2 2The internal number for the date. � � 2 SC_HID_FUNC_TAGE360 Z ZCalculates the number of days between two dates based on a 360-day year. Date_1 H HThe start date for calculating the difference in days. Date_2 F FThe end date for calculating the difference in days. Type z zMethod used to form differences: Type = 0 denotes US method (NASD), Type = 1 denotes the European method. � L 8 SC_HID_FUNC_NETWORKDAYS x xReturns the number of workdays between two dates using arguments to indicate weekenddays and holidays. Start Date , ,Start date for calculation. End Date * *End date for calculation. list of dates P POptional set of one or more dates to be considered as holiday. array � �Optional list of numbers to indicate working (0) and weekend (non-zero) days. When omitted, weekend is Saturday and Sunday. � B < SC_HID_FUNC_NETWORKDAYS_MS x xReturns the number of workdays between two dates using arguments to indicate weekend days and holidays. Start Date , ,Start date for calculation. End Date * *End date for calculation. " "number or string z zOptional number or string to indicate when weekends occur. When omitted, weekend is Saturday and Sunday. array P POptional set of one or more dates to be considered as holiday. � n 8 SC_HID_FUNC_WORKDAY_MS � �Returns the serial number of the date before or after a number of workdays using arguments to indicate weekend days and holidays. Start Date , ,Start date for calculation. Days D DThe number of workdays before or after start date. " "number or string z zOptional number or string to indicate when weekends occur. When omitted, weekend is Saturday and Sunday. array P POptional set of one or more dates to be considered as holiday. w � . SC_HID_FUNC_STUNDE d dDetermines the sequential number of the hour of the day (0-23) for the time value. Number $ $Internal time value x � . SC_HID_FUNC_MINUTE h hDetermines the sequential number for the minute of the hour (0-59) for the time value. Number & &Internal time value. u � , SC_HID_FUNC_MONAT d dDetermines the sequential number of a month of the year (1-12) for the date value. Number 2 2The internal number of the date. P h * SC_HID_FUNC_JETZT > >Determines the current time of the computer. y � . SC_HID_FUNC_SEKUNDE f fDetermines the sequential number of the second of a minute (0-59) for the time value. Number * *The internal time value. � N 0 SC_HID_FUNC_ZEIT V VDetermines a time value from the details for hour, minute and second. hour * *The integer for the hour. minute , ,The integer for the minute. second , ,The integer for the second. � 0 SC_HID_FUNC_ZEITWERT ^ ^Returns a sequential number for a text shown in a possible time entry format. text h hA text enclosed in quotation marks which returns a time in a %PRODUCTNAME time format. O h * SC_HID_FUNC_HEUTE > >Determines the current date of the computer. n 8 2 SC_HID_FUNC_WOCHENTAG N NReturns the day of the week for the date value as an integer. Number 2 2The internal number for the date. Type X XFixes the beginning of the week and the type of calculation to be used. t � , SC_HID_FUNC_JAHR @ @Returns the year of a date value as an integer. Number . .Internal number of the date. � . . SC_HID_FUNC_TAGE B BCalculates the number of days between two dates. Date_2 F FThe end date for calculating the difference in days. Date_1 H HThe start date for calculating the difference in days. � ~ 2 SC_HID_FUNC_DATEDIF h hReturns the number of whole days, months or years between 'start date' and 'end date'. Start date The start date. End date The end date. Interval V VInterval to be calculated. Can be "d", "m", "y", "ym", "md" or "yd". m 0 6 SC_HID_FUNC_KALENDERWOCHE N NCalculates the calendar week corresponding to the given date. Number 2 2The internal number of the date. mode L LIndicates the first day of the week and when week 1 starts. � � 2 SC_HID_FUNC_ISOWEEKNUM J JCalculates the ISO 8601 calendar week for the given date. Number 2 2The internal number of the date. � � 4 SC_HID_FUNC_WEEKNUM_OOO � �Calculates the calendar week corresponding to the given date.
This function only provides interoperability with %PRODUCTNAME 5.0 and earlier and OpenOffice.org. Number 2 2The internal number of the date. mode Z ZIndicates the first day of the week (1 = Sunday, other values = Monday). | � 4 SC_HID_FUNC_OSTERSONNTAG F FCalculates the date of Easter Sunday in a given year. year j jAn integer between 1583 and 9956, or 0 and 99 (19xx or 20xx depending on the option set). � � 2 SC_HID_FUNC_BW N NPresent value. Calculates the present value of an investment. Rate < <The rate of interest for the period given. NPER ^ ^The payment period. The total number of periods in which the annuity is paid. PMT ^ ^Regular payments. The constant amount of annuity that is paid in each period. FV ^ ^Future value. The value (final value) to be attained after the last payment.
Type V VType = 1 denotes due at the beginning of the period, = 0 at the end. � 2 SC_HID_FUNC_ZW � �Future value. Returns the future value of an investment based on regular payments and a constant interest rate. Rate 2 2The rate of interest per period. NPER d dPayment period. The total number of periods in which the annuity (pension) is paid. PMT R RRegular payments. The constant annuity to be paid in each period. PV J JPresent value. The current value of a series of payments
Type V VType = 1 denotes due at the beginning of the period, = 0 at the end. � 2 SC_HID_FUNC_ZZR � �Payment period. Calculates the number of payment periods for an investment based on regular payments and a constant interest rate. Rate 2 2The rate of interest per period. PMT R RRegular payments. The constant annuity to be paid in each period. PV J JPresent value. The current value of a series of payments FV \ \Future value. The value (end value) to be attained after the final payment.
Type V VType = 1 denotes due at the beginning of the period, = 0 at the end. � � 2 SC_HID_FUNC_RMZ � �Regular payments. Returns the periodic payment of an annuity, based on regular payments and a fixed periodic interest rate. Rate 2 2The rate of interest per period. NPER d dPayment period. The total number of periods in which the annuity (pension) is paid. PV J JPresent value. The current value of a series of payments FV \ \Future value. The value (end value) to be attained after the final payment.
Type V VType = 1 denotes due at the beginning of the period, = 0 at the end. $ 6 SC_HID_FUNC_ZINS ^ ^Calculates the constant interest rate of an investment with regular payments. NPER d dPayment period. The total number of periods in which the annuity (pension) is paid. PMT R RRegular payments. The constant annuity to be paid in each period. PV J JPresent value. The current value of a series of payments FV \ \Future value. The value (end value) to be attained after the final payment.
Type V VType = 1 denotes due at the beginning of the period, = 0 at the end. Guess
` `Guess. The estimate of the interest rate for the iterative calculating method. � 6 SC_HID_FUNC_ZINSZ � �Compounded interest. Calculates the interest payment on the principal for an investment with regular payments and a constant interest rate for a given period. Rate 2 2The rate of interest per period. Period � �Periods. The periods for which the compounded interest is to be calculated. P = 1 denotes for the first period, P = NPER for the last one. NPER d dPayment period. The total number of periods in which the annuity (pension) is paid. pv J JPresent value. The current value of a series of payments
FV \ \Future value. The value (end value) to be attained after the final payment. Type
V VType = 1 denotes due at the beginning of the period, = 0 at the end. � 6 SC_HID_FUNC_KAPZ � �Repayment. Calculates the repayment amount for a period for an investment whereby the payments are at regular intervals and the interest rate constant. Rate . .The interest rate per period. Period � �Period. The period for which the repayments are to be calculated. Per = 1 denotes for the first period, P = NPER for the last NPER h hThe payment period. The total number of periods in which the annuity (pension) is paid. PV d dThe present value. The present value or the amount the annuity is currently worth.
FV d dFuture value. The value (end value) attained after the last payment has been made. Type
V VType = 1 denotes due at the beginning of the period, = 0 at the end. P < SC_HID_FUNC_KUMKAPITAL � �Cumulative Capital. Calculates the total amount of the repayment share in a period for an investment with constant interest rate. Rate 2 2The rate of interest per period. NPER d dPayment period. The total number of periods in which the annuity (pension) is paid. PV d dThe present value. The present value or the amount the annuity is currently worth. S r rThe start period. The first period to be taken into account. S = 1 denotes the very first period.
E F FEnd period. The last period to be taken into account. Type
V VType = 1 denotes due at the beginning of the period, = 0 at the end. ` : SC_HID_FUNC_KUMZINSZ � �Cumulative compounded interest. Calculates the total amount of the interest share in a period for an investment with a constant interest rate. Rate 2 2The rate of interest per period. NPER d dPayment period. The total number of periods in which the annuity (pension) is paid. pv d dThe present value. The present value or the amount the annuity is currently worth. S r rThe start period. The first period to be taken into account. S = 1 denotes the very first period.
E J JThe end period. The last period to be taken into account. Type
V VType = 1 denotes due at the beginning of the period, = 0 at the end. � R 0 SC_HID_FUNC_DIA r rCalculates the arithmetically declining value of an asset (depreciation) for a specified period. Cost B BAcquisition costs. The initial cost of the asset. Salvage R RSalvage: The remaining value of the asset at the end of its life. Life T TUseful life. The number of periods in the useful life of the asset. Period l lPeriod. The depreciation period which must have the same time unit as average useful life. � � . SC_HID_FUNC_LIA @ @Calculates the linear depreciation per period. Cost @ @Acquisition cost. The initial cost of an asset. Salvage R RSalvage: The remaining value of the asset at the end of its life. Life T TUseful life. The number of periods in the useful life of the asset. � � 2 SC_HID_FUNC_GDA � �Calculates the depreciation of an asset for a specific period using the double-declining balance method or declining balance factor. Cost B BAcquisition costs. The initial cost of the asset. Salvage R RSalvage: The remaining value of the asset at the end of its life. Life T TUseful life. The number of periods in the useful life of the asset. Period h hPeriod. The depreciation period in the same time unit as the average useful life entry.
Factor f fFactor. The factor for balance decline. F = 2 means a double declining balance factor � � 4 SC_HID_FUNC_GDA2 | |Returns the real depreciation of an asset for a specified period using the fixed-declining balance method. Cost B BAcquisition costs: The initial cost of the asset. Salvage R RSalvage: The remaining value of the asset at the end of its life. Life T TUseful life. The number of periods in the useful life of the asset. Period � �Periods: The period for which the depreciation is calculated. The time unit used for period must be the same as that for the useful life.
month P PMonths: The number of months in the first year of depreciation. � � 6 SC_HID_FUNC_VDB p pVariable declining balance. Returns the declining balance depreciation for a particular period. Cost 6 6Cost. The initial cost of the asset. Salvage V VSalvage. The salvage value of an asset at the end of its useful life. Life T TUseful life. The number of periods in the useful life of the asset. S d dStart. The first period for depreciation in the same time unit as the useful life.
end j jEnd. The last period of the depreciation using the same time unit as for the useful life. Factor
r rFactor. The factor for the reduction of the depreciation. F = 2 denotes double rate depreciation. Type f fDo not alter. Type = 1 denotes switch to linear depreciation, type = 0 do not switch. 2 SC_HID_FUNC_EFFEKTIV V VCalculates the annual net interest rate for a nominal interest rate. NOM " "Nominal Interest P D DPeriods. The number of interest payments per year. , 0 SC_HID_FUNC_NOMINAL \ \Calculates the yearly nominal interest rate as an effective interest rate. effect_rate , ,The effective interest rate npery B BPeriods. The number of interest payment per year. � � , SC_HID_FUNC_NBW � �Net present value. Calculates the net present value of an investment based on a series of periodic payments and a discount rate. RATE 6 6The rate of discount for one period. value ^ ^Value 1, value 2,... are 1 to 30 arguments representing payments and income. � � , SC_HID_FUNC_IKV d dReturns the actuarial rate of interest of an investment excluding costs or profits. Values \ \An array or reference to cells whose contents correspond to the payments. Guess j jGuess. An estimated value of the rate of return to be used for the iteration calculation. � � 0 SC_HID_FUNC_QIKV Z ZReturns the modified internal rate of return for a series of investments. Values Z ZAn array or reference to cells whose contents correspond to the payments. investment R RInterest rate for investments (the negative values in the array). reinvest_rate T Tinterest rate for reinvestments (the positive values in the array). � � 2 SC_HID_FUNC_ISPMT P PReturns the amount of interest for constant amortization rates. rate > >Interest rate for a single amortization rate. Period T TNumber of amortization periods for the calculation of the interest. total_periods 4 4Sum total of amortization periods. invest * *Amount of the investment. � � 4 SC_HID_FUNC_LAUFZEIT r rDuration. Calculates the number of periods required by an investment to attain the desired value. RATE 0 0The constant rate of interest. pv H HThe present value. The current value of the investment. FV 4 4The future value of the investment. � . SC_HID_FUNC_ZGZ p pInterest. Calculates the interest rate which represents the rate of return from an investment. P @ @The number of periods used in the calculation. pv D DPresent value. The current value of the investment. FV 4 4The future value of the investment. � � 0 SC_HID_FUNC_ISTBEZUG 6 6Returns TRUE if value is a reference. value ( (The value to be tested. � � . SC_HID_FUNC_ISTFEHL P PReturns TRUE if the value is an error value not equal to #N/A. value ( (The value to be tested. � � 0 SC_HID_FUNC_ISTFEHLER > >Returns TRUE if the value is an error value. value ( (The value to be tested. � . SC_HID_FUNC_ISTLEER @ @Returns TRUE if value refers to an empty cell. value ( (The value to be tested. � � . SC_HID_FUNC_ISTLOG L LReturns TRUE if the value carries a logical number format. value ( (The value to be tested. � � , SC_HID_FUNC_ISTNV 4 4Returns TRUE if value equals #N/A. value ( (The value to be tested. � � 0 SC_HID_FUNC_ISTKTEXT 8 8Returns TRUE if the value is not text. value ( (The value to be tested. � � . SC_HID_FUNC_ISTTEXT 0 0Returns TRUE if value is text. value ( (The value to be tested. � � . SC_HID_FUNC_ISTZAHL 4 4Returns TRUE if value is a number. value ( (The value to be tested. � � 0 SC_HID_FUNC_ISTFORMEL < <Returns TRUE if the cell is a formula cell. reference ( (The cell to be checked. � � . SC_HID_FUNC_FORMEL 8 8Returns the formula of a formula cell. Reference " "The formula cell. � � ( SC_HID_FUNC_N . .Converts a value to a number. value : :The value to be interpreted as a number. Q f ( SC_HID_FUNC_NV > >Not available. Returns the error value #N/A. � * SC_HID_FUNC_TYP � �Returns the data type of a value (1 = number, 2 = text, 4 = Boolean value, 8 = formula, 16 = error value, 64 = array). value H HThe value for which the data type is to be determined. � 8 . SC_HID_FUNC_ZELLE X XDetermines information about address, formatting or contents of a cell. info_type @ @String that specifies the type of information. Reference > >The position of the cell you want to examine. R � , SC_HID_FUNC_AKTUELL V VCalculates the current value of the formula at the present location. N ` , SC_HID_FUNC_FALSCH 4 4Defines the logical value as FALSE. F � , SC_HID_FUNC_NICHT 4 4Reverses the value of the argument. Logical value @ @An expression that can be either TRUE or FALSE. M Z * SC_HID_FUNC_WAHR 0 0Returns the logical value TRUE. � 0 SC_HID_FUNC_WENN : :Specifies a logical test to be performed. Test L LAny value or expression which can be either TRUE or FALSE. Then_value P PThe result of the function if the logical test returns a TRUE. Otherwise_value N NThe result of the function if the logical test returns FALSE. , 0 SC_HID_FUNC_IFERROR H HReturns value if not an error value, else alternative. value , ,The value to be calculated. " "alternative value P PThe alternative to be returned, should value be an error value. & . SC_HID_FUNC_IFNA F FReturns value if not a #N/A error, else alternative. value , ,The value to be calculated. " "alternative value N NThe alternative to be returned, should value be a #N/A error. ? , SC_HID_FUNC_ODER 6 6Returns TRUE if an argument is TRUE. Logical value � �Logical value 1, logical value 2,... are 1 to 30 conditions to be tested and which return either TRUE or FALSE. � * SC_HID_FUNC_XOR N NReturns TRUE if an odd number of arguments evaluates to TRUE. Logical value � �Logical value 1, logical value 2, ... are 1 to 30 conditions to be tested and which return either TRUE or FALSE. > * SC_HID_FUNC_UND 8 8Returns TRUE if all arguments are TRUE. Logical value � �Logical value 1, logical value 2;...are 1 to 30 conditions to be tested and each returns either TRUE or FALSE. { � * SC_HID_FUNC_ABS , ,Absolute value of a number. Number D DThe number whose absolute value is to be returned. � 0 SC_HID_FUNC_POTENZ H HReturns a^b, base a raised to the power of exponent b. Base . .The base a of the power a^b. Exponent 2 2The exponent b of the power a^b. � 8 SC_HID_FUNC_ANZAHLLEEREZELLEN > >Counts the blank cells in a specified range. range B BThe range in which empty cells are to be counted. K \ ( SC_HID_FUNC_PI 4 4Returns the value of the number Pi. � � , SC_HID_FUNC_SUMME 2 2Returns the sum of all arguments. number ` `Number 1, number 2, ... are 1 to 30 arguments whose total is to be calculated. � 4 SC_HID_FUNC_QUADRATESUMME B BReturns the sum of the squares of the arguments. number t tNumber 1, number 2,... are 1 to 30 arguments for which the sum of the squares is to be calculated. � � . SC_HID_FUNC_PRODUKT * *Multiplies the arguments. Number f fNumber 1, number 2, ... are 1 to 30 arguments to be multiplied and a result returned. | 4 SC_HID_FUNC_SUMMEWENN > >Totals the arguments that meet the condition. range B BThe range to be evaluated by the criteria given. criteria : :The criteria to be applied to the range. sum_range D DThe range from which the values are to be totalled. � � 4 SC_HID_FUNC_AVERAGEIF B BAverages the arguments that meet the conditions. range B BThe range to be evaluated by the criteria given. criteria : :The criteria to be applied to the range. average_range D DThe range from which the values are to be averaged. � � 2 SC_HID_FUNC_SUMIFS = f fTotals the values of cells in a range that meet multiple criteria in multiple ranges. sum_range D DThe range from which the values are to be totalled. range \ \Range 1, range 2,... are the ranges to be evaluated by the criteria given. criteria ` `Criteria 1, criteria 2,... are the criteria to be applied to the ranges given. � � 6 SC_HID_FUNC_AVERAGEIFS = ` `Averages the value of the cells that meet multiple criteria in multiple ranges. average_range D DThe range from which the values are to be averaged. range \ \Range 1, range 2,... are the ranges to be evaluated by the criteria given. criteria ` `Criteria 1, criteria 2,... are the criteria to be applied to the ranges given. � r 2 SC_HID_FUNC_COUNTIFS < R RCounts the cells that meet multiple criteria in multiple ranges. range \ \Range 1, range 2,... are the ranges to be evaluated by the criteria given. criteria ` `Criteria 1, criteria 2,... are the criteria to be applied to the ranges given. , 4 SC_HID_FUNC_ZAEHLENWENN D DCounts the arguments which meet the set conditions. range J JThe range of cells to be evaluated by the criteria given. criteria : :The criteria to be applied to the range. r � . SC_HID_FUNC_WURZEL 6 6Returns the square root of a number. number P PA positive value for which the square root is to be calculated. L j 0 SC_HID_FUNC_ZUFALLSZAHL : :Returns a random number between 0 and 1. � � 0 SC_HID_FUNC_ISTGERADE : :Returns TRUE if value is an even integer. value ( (The value to be tested. � � 2 SC_HID_FUNC_ISTUNGERADE : :Returns TRUE if value is an odd integer. value ( (The value to be tested. � " 6 SC_HID_FUNC_KOMBINATIONEN X XCalculates the number of combinations for elements without repetition. number_1 . .The total number of elements. number_2 2 2The number of elements selected. � $ 8 SC_HID_FUNC_KOMBINATIONEN2 X XCalculates the number of combinations of elements including repetition. number_1 . .The total number of elements. number_2 2 2The number of elements selected. a � . SC_HID_FUNC_ARCCOS 4 4Returns the arccosine of a number. Number T TA value between -1 and 1 for which the arccosine is to be returned. ` � . SC_HID_FUNC_ARCSIN 2 2Returns the arcsine of a number. Number R RA value between -1 and 1 for which the arcsine is to be returned. i � 0 SC_HID_FUNC_ARCOSHYP D DReturns the inverse hyperbolic cosine of a number. Number n nA value greater than or equal to 1 for which the inverse hyperbolic cosine is to be returned. h � 0 SC_HID_FUNC_ARSINHYP B BReturns the inverse hyperbolic sine of a number. Number T TThe value for which the inverse hyperbolic sine is to be returned. c � . SC_HID_FUNC_ARCCOT < <Returns the inverse cotangent of a number. Number N NThe value for which the inverse cotangent is to be returned. b � . SC_HID_FUNC_ARCTAN 4 4Returns the arctangent of a number. Number F FThe value for which the arctangent is to be returned. k 0 SC_HID_FUNC_ARCOTHYP F FReturns the inverse hyperbolic cotangent of a number. Number x xA value smaller than -1 or greater than 1 for which the inverse hyperbolic cotangent is to be returned. j � 0 SC_HID_FUNC_ARTANHYP D DReturns the inverse hyperbolic tangent of a number. Number f fA value between -1 and 1 for which the inverse hyperbolic tangent is to be returned. ] � * SC_HID_FUNC_COS 0 0Returns the cosine of a number. Number R RThe angle in the radians for which the cosine is to be returned. \ � * SC_HID_FUNC_SIN . .Returns the sine of a number. number N NThe angle in radians for which the sine is to be calculated. _ � * SC_HID_FUNC_COT 4 4Returns the cotangent of a number. Number N NThe angle in radians whose cotangent value is to be returned. ^ � * SC_HID_FUNC_TAN 2 2Returns the tangent of a number. number P PThe angle in radians for which the tangent is to be calculated. e � . SC_HID_FUNC_COSHYP < <Returns the hyperbolic cosine of a number. Number N NThe value for which the hyperbolic cosine is to be returned. d � . SC_HID_FUNC_SINHYP : :Returns the hyperbolic sine of a number. number N NThe value for which the hyperbolic sine is to be calculated. g � . SC_HID_FUNC_COTHYP > >Returns the hyperbolic cotangent of a number. Number ^ ^A value not equal to 0 for which the hyperbolic cotangent is to be returned. f � . SC_HID_FUNC_TANHYP < <Returns the hyperbolic tangent of a number. number P PThe value for which the hyperbolic tangent is to be calculated. �
0 SC_HID_FUNC_ARCTAN2 F FReturns the arctangent for the specified coordinates. number_x 0 0The value for the x coordinate. number_y 0 0The value for the y coordinate. l � 0 SC_HID_FUNC_COSECANT B BReturn the cosecant of an angle. CSC(x)=1/SIN(x) Angle R RThe angle in radians for which the cosecant is to be calculated. m � . SC_HID_FUNC_SECANT @ @Return the secant of an angle. SEC(x)=1/COS(x) Angle P PThe angle in radians for which the secant is to be calculated. n 2 SC_HID_FUNC_COSECANTHYP X XReturn the hyperbolic cosecant of a hyperbolic angle. CSCH(x)=1/SINH(x) Angle h hThe hyperbolic angle in radians for which the hyperbolic cosecant is to be calculated. o 0 SC_HID_FUNC_SECANTHYP V VReturn the hyperbolic secant of a hyperbolic angle. SECH(x)=1/COSH(x) Angle f fThe hyperbolic angle in radians for which the hyperbolic secant is to be calculated. Z � * SC_HID_FUNC_DEG . .Converts a radian to degrees Number & &The angle in a radian [ � * SC_HID_FUNC_RAD , ,Converts degrees to radians Number & &The angle in degrees. p � * SC_HID_FUNC_EXP 6 6Calculates the exponent for basis e. Number 0 0The exponent applied to base e. � B , SC_HID_FUNC_LOG @ @Calculates the logarithm to any specified base. Number T TA value greater than 0 for which the logarithm is to be calculated. Base T TThe base of the logarithm. If omitted, the base is regarded as 10. q � * SC_HID_FUNC_LN > >Calculates the natural logarithm of a number. Number \ \A value greater than 0 for which the natural logarithm is to be calculated. � � , SC_HID_FUNC_LOG10 > >Calculates the base-10 logarithm of a number. Number T TA value greater than 0 for which the logarithm is to be calculated. s � 0 SC_HID_FUNC_FAKULTAET 6 6Calculates the factorial of a number. Number H HThe number for which the factorial is to be calculated. � . SC_HID_FUNC_REST 8 8Calculates the remainder of a division. Dividend * *The number to be divided. Divisor > >The number by which the dividend is divided. z � 2 SC_HID_FUNC_VORZEICHEN 8 8Returns the algebraic sign of a number. Number N NThe number for which the algebraic sign is to be determined.
B 6 SC_HID_FUNC_TEILERGEBNIS 8 8Calculates subtotals in a spreadsheet. Function V VFunction index. Is an index of the possible functions Total, Max, ... range L LThe cells of the range which are to be taken into account. � J 6 SC_HID_FUNC_AGGREGATE ! : :Calculates an aggregate in a spreadsheet. Function V VFunction index. Is an index of the possible functions Total, Max, ... Options J JOption index. Is an index of the possible ignore options. Ref1 or array N NThe cell(s) of the range which are to be taken into account. Ref2..n or k | |The cells of the range which are to be taken into account or mandatory 2nd argument for certain functions. | � 0 SC_HID_FUNC_GANZZAHL > >Rounds a number down to the nearest integer. Number 0 0The number to be rounded down. � 0 SC_HID_FUNC_KUERZEN : :Truncates the decimal places of a number. number , ,The number to be truncated. count \ \The number of places after the decimal point that are not to be truncated. � 0 SC_HID_FUNC_RUNDEN : :Rounds a number to a predefined accuracy. number * *The number to be rounded. count J JThe number of places to which a number is to be rounded. � 2 SC_HID_FUNC_AUFRUNDEN @ @Rounds a number up to the predefined accuracy. number . .The number to be rounded up. count J JThe number of places to which a number is to be rounded. � 2 SC_HID_FUNC_ABRUNDEN @ @Rounds a number down to a predefined accuracy. number 0 0The number to be rounded down. count N NThe number of places down to which a number is to be rounded. � � . SC_HID_FUNC_GERADE b bRounds a positive number up and negative number down to the nearest even integer. Number . .The number to be rounded up. � � 0 SC_HID_FUNC_UNGERADE b bRounds a positive number up and negative number down to the nearest odd integer. Number . .The number to be rounded up. � � 0 SC_HID_FUNC_CEIL_MS � �Rounds a number away from zero to the nearest multiple of significance.
This function exists for interoperability with Microsoft Excel 2007 or older versions. Number . .The number to be rounded up. Significance D DThe number to whose multiple the value is rounded. � N 6 SC_HID_FUNC_CEIL_PRECISE p pRounds a number up to the nearest multiple of significance, regardless of sign of significance. Number . .The number to be rounded up. Significance D DThe number to whose multiple the value is rounded. � J 2 SC_HID_FUNC_CEIL_ISO p pRounds a number up to the nearest multiple of significance, regardless of sign of significance. Number . .The number to be rounded up. Significance D DThe number to whose multiple the value is rounded. � � 6 SC_HID_FUNC_OBERGRENZE L LRounds a number up to the nearest multiple of significance. Number . .The number to be rounded up. Significance v vIf given the number to whose multiple the value is rounded, else -1 or 1 depending on sign of Number. Mode | |If given and not equal to zero then rounded up according to amount when a negative number and significance. � � 4 SC_HID_FUNC_CEIL_MATH L LRounds a number up to the nearest multiple of significance. Number . .The number to be rounded up. Significance T TIf given the number to whose multiple the value is rounded, else 1. Mode | |For negative numbers; if given and not equal to zero then rounds away from zero, else rounds towards zero. � � 6 SC_HID_FUNC_UNTERGRENZE L LRounds number down to the nearest multiple of significance. Number 0 0The number to be rounded down. Significance N NThe number to whose multiple the value is to be rounded down. Mode p pIf given and not equal to zero then rounded towards zero with negative number and significance. � � 2 SC_HID_FUNC_FLOOR_MS � �Rounds number towards zero to the nearest multiple of absolute value of significance.
This function exists for interoperability with Microsoft Excel 2007 or older versions. Number 0 0The number to be rounded down. Significance N NThe number to whose multiple the value is to be rounded down. � � 6 SC_HID_FUNC_FLOOR_MATH p pRounds number down to the nearest multiple of significance, regardless of sign of significance. Number 0 0The number to be rounded down. Significance N NThe number to whose multiple the value is to be rounded down. Mode h hFor negative numbers; if given and not equal to or less than zero rounds towards zero. � \ 6 SC_HID_FUNC_FLOOR_PRECISE \ \Rounds number down (towards -∞) to the nearest multiple of significance. Number 0 0The number to be rounded down. Significance d dThe number to whose multiple the value is to be rounded down. Sign has no meaning. � � * SC_HID_FUNC_GGT ( (Greatest Common Divisor Integer r rInteger 1; integer 2,... are integers for which the greatest common divisor is to be calculated. � � * SC_HID_FUNC_KGV ( (Lowest common multiple Integer j jInteger 1; integer 2,... are integers whose smallest common multiple is to be calculated. 5 � . SC_HID_FUNC_MTRANS R RArray transposition. Exchanges the rows and columns of an array. array N NThe array in which the rows and columns have been transposed. 4 @ . SC_HID_FUNC_MMULT J JArray multiplication. Returns the product of two arrays. array_1 8 8The first array for the array product. array_2 ` `The second array having the same number of rows as the first array has columns. 2 � , SC_HID_FUNC_MDET 0 0Returns the array determinant. array J JThe array for which the determinant is to be determined. 3 � , SC_HID_FUNC_MINV 2 2Returns the inverse of an array. array * *The array to be inverted. 6 � 6 SC_HID_FUNC_EINHEITSMATRIX D DReturns the unitary square array of a certain size. Dimensions 0 0The size of the unitary array. � 4 SC_HID_FUNC_SUMMENPRODUKT V V(Inner products) Returns the sum of the products of array arguments. Array ` `Array 1, array 2, ... are up to 30 arrays whose arguments are to be multiplied. � P 4 SC_HID_FUNC_SUMMEX2MY2 L LReturns the sum of the difference of squares of two arrays. array_x L LFirst array where the square of the arguments are totalled. array_y T TSecond array where the square of the arguments is to be subtracted. � F 4 SC_HID_FUNC_SUMMEX2PY2 D DReturns the total of the square sum of two arrays. array_x L LFirst array where the square of the arguments are totalled. array_y R RSecond array where the square of the arguments is to be totalled. � . 2 SC_HID_FUNC_SUMMEXMY2 J JReturns the sum of squares of differences of two arrays. array_x > >First array for forming argument differences. array_y D DSecond array for forming the argument differences. a� @� P 4 SC_HID_FUNC_HAEUFIGKEIT F FReturns a frequency distribution as a vertical array. data ( (The array of the data. classes 0 0The array for forming classes. ` 0 SC_HID_FUNC_RGP L LCalculates parameters of the linear regression as an array. data_Y " "The Y data array. data_X " "The X data array. Linear_type j jIf type = 0 the linears will be calculated through the zero point, or else moved linears. stats z zIf parameter = 0 then only the regression coefficient will be calculated, otherwise other values as well. a " 0 SC_HID_FUNC_RKP \ \Calculates the parameters of the exponential regression curve as an array. data_Y " "The Y data array. data_X " "The X data array. Function_type t tIf type = 0 then the functions will be calculated in the form of y=m^x, or also functions y=b*m^x. stats z zIf parameter = 0 then only the regression coefficient will be calculated, otherwise other values as well. ^ � 2 SC_HID_FUNC_TREND < <Calculates points along a regression line. data_Y " "The Y data array. data_X B BThe X data array as the basis for the regression. new data_X B BThe array of X data for recalculating the values. Linear_type j jIf type = 0 the linears will be calculated through the zero point, or else moved linears. _ 6 SC_HID_FUNC_VARIATION J JCalculates points on the exponential regression function. data_Y " "The Y data array. data_X B BThe X data array as the basis for the regression. new_data_X B BThe array of X data for recalculating the values. Function_type t tIf type = 0 then the functions will be calculated in the form of y=m^x, or also functions y=b*m^x. � . SC_HID_FUNC_ANZAHL F FCounts how many numbers are in the list of arguments. value � �Value 1, value 2, ... are 1 to 30 arguments containing different data types but where only numbers are counted. � � . SC_HID_FUNC_ANZAHL2 F FCounts how many values are in the list of arguments. value d dValue 1, value 2, ... are 1 to 30 arguments representing the values to be counted. � � * SC_HID_FUNC_MAX B BReturns the maximum value in a list of arguments. number z zNumber 1, number 2, ... are 1 to 30 numerical arguments for which the largest number is to be determined. v , SC_HID_FUNC_MAXA ^ ^Returns the maximum value in a list of arguments. Text is evaluated as Zero. value d dValue 1, value 2, are 1 to 30 arguments whose largest value is to be determined. � * SC_HID_FUNC_MIN B BReturns the minimum value in a list of arguments. number | |Number 1, number 2, ... are 1 to 30 numerical arguments for which the smallest number is to be determined. u , SC_HID_FUNC_MINA ^ ^Returns the smallest value in a list of arguments. Text is evaluated as zero. value f fValue 1; value 2;... are 1 to 30 arguments whose smallest number is to be determined. � � . SC_HID_FUNC_VARIANZ < <Calculates the variance based on a sample. number p pNumber 1, number 2, ... are 1 to 30 numerical arguments which portray a sample of a population. � � , SC_HID_FUNC_VAR_S < <Calculates the variance based on a sample. number p pNumber 1, number 2, ... are 1 to 30 numerical arguments which portray a sample of a population. z 0 SC_HID_FUNC_VARIANZA T TReturns the variance based on a sample. Text is evaluated as zero. value x xValue 1; value 2; ... are 1 to 30 arguments representing a sample taken from a basic total population. � � 0 SC_HID_FUNC_VARIANZEN D DCalculates variance based on the entire population. number f fNumber 1, number 2, ... are 1 to 30 numerical arguments which represent a population. � � 0 SC_HID_FUNC_VAR_P_MS D DCalculates variance based on the entire population. number f fNumber 1, number 2, ... are 1 to 30 numerical arguments which represent a population. { 2 SC_HID_FUNC_VARIANZENA ` `Returns the variance based on the entire population. Text is evaluated as zero. value V VValue 1; value 2;... are 1 to 30 arguments representing a population. � � , SC_HID_FUNC_STABW F FCalculates the standard deviation based on a sample. number p pNumber 1, number 2, ... are 1 to 30 numerical arguments which portray a sample of a population. � � 0 SC_HID_FUNC_ST_DEV_S F FCalculates the standard deviation based on a sample. number p pNumber 1, number 2, ... are 1 to 30 numerical arguments which portray a sample of a population. x . SC_HID_FUNC_STABWA ^ ^Returns the standard deviation based on a sample. Text is evaluated as zero. value x xValue 1; value 2; ... are 1 to 30 arguments representing a sample taken from a basic total population. � � . SC_HID_FUNC_STABWN R RCalculates the standard deviation based on the entire population. number d dNumber 1, number 2, ... are 1 to 30 numerical arguments which portray a population. � 2 SC_HID_FUNC_ST_DEV_P_MS R RCalculates the standard deviation based on the entire population. number d dNumber 1, number 2, ... are 1 to 30 numerical arguments which portray a population. y
. SC_HID_FUNC_STABWNA j jReturns the standard deviation based on the entire population. Text is evaluated as zero. value Z ZValue 1; value 2;... are 1 to 30 arguments corresponding to a population. � � 2 SC_HID_FUNC_MITTELWERT 2 2Returns the average of a sample. number f fNumber 1, number 2;...are 1 to 30 numeric arguments representing a population sample. w 2 SC_HID_FUNC_MITTELWERTA T TReturns the average value for a sample. Text is evaluated as zero. value x xValue 1; value 2; ... are 1 to 30 arguments representing a sample taken from a basic total population. F � 2 SC_HID_FUNC_SUMQUADABW T TReturns the sum of squares of deviations from the sample mean value number ` `Number 1, number 2, ... are 1 to 30 numerical arguments which portray a sample. D 0 SC_HID_FUNC_MITTELABW Z ZReturns the average of the absolute deviations of a sample from the mean. number ^ ^Number 1, number 2;...are 1 to 30 numerical arguments representing a sample. E � . SC_HID_FUNC_SCHIEFE 8 8Returns the skewness of a distribution. number r rNumber 1, number 2, ... are 1 to 30 numerical arguments portraying a sample of the distribution. �
, SC_HID_FUNC_SKEWP b bReturns the skewness of a distribution using the population of a random variable. number d dNumber 1, number 2, ... are 1 to 30 numerical arguments portraying the population. @ � , SC_HID_FUNC_KURT 8 8Returns the kurtosis of a distribution. number t tNumber 1, number 2, ... are 1 to 30 numerical arguments, representing a sample of the distribution. B � 0 SC_HID_FUNC_GEOMITTEL 8 8Returns the geometric mean of a sample. number ` `Number 1, number 2, ... are 1 to 30 numerical arguments which portray a sample. A � 0 SC_HID_FUNC_HARMITTEL 8 8Returns the harmonic mean of a sample. number ` `Number 1, number 2, ... are 1 to 30 numerical arguments which portray a sample. H � 0 SC_HID_FUNC_MODALWERT < <Returns the most common value in a sample. number ` `Number 1, number 2, ... are 1 to 30 numerical arguments which portray a sample. � � 6 SC_HID_FUNC_MODAL_VALUE_MS < <Returns the most common value in a sample. number ` `Number 1, number 2, ... are 1 to 30 numerical arguments which portray a sample. � � 8 SC_HID_FUNC_MODAL_VALUE_MULTI < <Returns the most common value in a sample. number b bNumber 1, number 2, ... are 1 to 254 numerical arguments which portray a sample. G � . SC_HID_FUNC_MEDIAN 6 6Returns the median of a given sample. number ` `Number 1, number 2, ... are 1 to 30 numerical arguments which portray a sample. L 0 SC_HID_FUNC_QUANTIL 8 8Returns the alpha quantile of a sample. data 6 6The array of the data in the sample. Alpha F FThe percentage rate of the quantile between 0 and 1. � 8 SC_HID_FUNC_PERCENTILE_EXC : :Returns the alpha percentile of a sample. data 6 6The array of the data in the sample. Alpha > >The percentile value, range 0...1, exclusive. � 8 SC_HID_FUNC_PERCENTILE_INC : :Returns the alpha percentile of a sample. data 6 6The array of the data in the sample. Alpha > >The percentile value, range 0...1, inclusive. Q 2 SC_HID_FUNC_QUARTILE 2 2Returns the quartile of a sample. data 6 6The array of the data in the sample. Type X XThe type of the quartile (0 = MIN, 1 = 25%, 2 = 50%, 3 = 75%, 4 = MAX). � 6 SC_HID_FUNC_QUARTILE_EXC 2 2Returns the quartile of a sample. data 6 6The array of the data in the sample. Type F FThe type of the quartile (1 = 25%, 2 = 50%, 3 = 75%). � " 6 SC_HID_FUNC_QUARTILE_INC 2 2Returns the quartile of a sample. data 6 6The array of the data in the sample. Type X XThe type of the quartile (0 = MIN, 1 = 25%, 2 = 50%, 3 = 75%, 4 = MAX). N � 2 SC_HID_FUNC_KGROESSTE < <Returns the k-th largest value of a sample. data 6 6The array of the data in the sample. Rank_c * *The ranking of the value. O � 2 SC_HID_FUNC_KKLEINSTE > >Returns the k-th smallest value of a sample. data 6 6The array of the data in the sample. Rank_c * *The ranking of the value. M � 8 SC_HID_FUNC_QUANTILSRANG D DReturns the percentage rank of a value in a sample. data 6 6The array of the data in the sample. value L LThe value for which percentage ranking is to be determined. significance p pThe number of significant digits for the returned percentage: if omitted, a value of 3 is used. � � : SC_HID_FUNC_PERCENTRANK_EXC V VReturns the percentage rank (0..1, exclusive) of a value in a sample. data 6 6The array of the data in the sample. value L LThe value for which percentage ranking is to be determined. significance p pThe number of significant digits for the returned percentage: if omitted, a value of 3 is used. � � : SC_HID_FUNC_PERCENTRANK_INC V VReturns the percentage rank (0..1, inclusive) of a value in a sample. data 6 6The array of the data in the sample. value L LThe value for which percentage ranking is to be determined. significance p pThe number of significant digits for the returned percentage: if omitted, a value of 3 is used. K � 0 SC_HID_FUNC_RANG < <Returns the ranking of a value in a sample. value B BThe value for which the rank is to be determined. Data 6 6The array of the data in the sample. Type h hSequence order: 0 or omitted means descending, any other value than 0 means ascending. � � 2 SC_HID_FUNC_RANK_EQ � �Returns the ranking of a value in a sample; if more than one value has the same rank, the top rank of that set of values is returned. value B BThe value for which the rank is to be determined. Data 6 6The array of the data in the sample. Type h hSequence order: 0 or omitted means descending, any other value than 0 means ascending. � � 4 SC_HID_FUNC_RANK_AVG � �Returns the ranking of a value in a sample; if more than one value has the same rank, the average rank is returned. value B BThe value for which the rank is to be determined. Data 6 6The array of the data in the sample. Type h hSequence order: 0 or omitted means descending, any other value than 0 means ascending. U D 8 SC_HID_FUNC_GESTUTZTMITTEL T TReturns the mean of a sample without including the marginal values. data 6 6The array of the data in the sample. Alpha V VThe percentage of marginal data that is not to be taken into account. V � < SC_HID_FUNC_WAHRSCHBEREICH B BReturns the discrete probability of an interval. data ( (The sample data array. probability < <The array of the associated probabilities. Start X XThe start of the value interval whose probabilities is to be totalled. End Z ZThe end of the value interval where the probabilities are to be totalled. � � . SC_HID_FUNC_B X XReturns the probability of a trial result using binomial distribution. trials & &The number of trials. SP > >The individual probability of a trial result. T_1 6 6Lower limit for the number of trials. T_2 6 6Upper limit for the number of trials. } � * SC_HID_FUNC_PHI X XValues of the distribution function for a standard normal distribution. number Z ZThe value for which the standard normal distribution is to be calculated. ~ , SC_HID_FUNC_GAUSS \ \Returns the integral values of the standard normal cumulative distribution. Number p pThe value for which the integral value of the standard normal distribution is to be calculated. � � . SC_HID_FUNC_FISHER 4 4Returns the Fisher transformation. Number > >The value to be transformed (-1 < VALUE < 1). � � 0 SC_HID_FUNC_FISHERINV B BReturns the inverse of the Fisher transformation. Number : :The value that is to be transformed back. � � 6 SC_HID_FUNC_BINOMVERT 6 6Values of the binomial distribution. X @ @The number of successes in a series of trials. trials , ,The total number of trials. SP 4 4The success probability of a trial. C f fCumulated. C=0 calculates the individual probability, C=1 the cumulated probability. � � : SC_HID_FUNC_BINOM_DIST_MS 6 6Values of the binomial distribution. X @ @The number of successes in a series of trials. trials , ,The total number of trials. SP 4 4The success probability of a trial. C f fCumulated. C=0 calculates the individual probability, C=1 the cumulated probability. > ^ 8 SC_HID_FUNC_NEGBINOMVERT > >Values of the negative binomial distribution. X < <The number of failures in the trial range. R @ @The number of successes in the trial sequence. SP 4 4The success probability of a trial. � < SC_HID_FUNC_NEGBINOMDIST_MS > >Values of the negative binomial distribution. X < <The number of failures in the trial range. R @ @The number of successes in the trial sequence. SP 4 4The success probability of a trial. Cumulative � �0 or FALSE calculates the probability density function. Any other value or TRUE calculates the cumulative distribution function. ? � 4 SC_HID_FUNC_KRITBINOM � �Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value. trials , ,The total number of trials. SP 4 4The success probability of a trial. alpha F FThe border probability that is attained or exceeded. � � 8 SC_HID_FUNC_BINOM_INV_MS � �Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value. trials , ,The total number of trials. SP 4 4The success probability of a trial. alpha F FThe border probability that is attained or exceeded. � � 2 SC_HID_FUNC_POISSON 2 2Returns the Poisson distribution. Number R RThe value for which the Poisson distribution is to be calculated. mean B BMean. The mean value of the Poisson distribution. Cumulative � �0 or FALSE calculates the probability density function. Any other value or TRUE or omitted calculates the cumulative distribution function. � � : SC_HID_FUNC_POISSON_DIST_MS 2 2Returns the Poisson distribution. Number R RThe value for which the Poisson distribution is to be calculated. mean B BMean. The mean value of the Poisson distribution. Cumulative � �0 or FALSE calculates the probability density function. Any other value or TRUE or omitted calculates the cumulative distribution function. � R 6 SC_HID_FUNC_NORMVERT 4 4Values of the normal distribution. Number R RThe value for which the normal distribution is to be calculated. Mean L LThe mean value. The mean value of the normal distribution. STDEV X XStandard deviation. The standard deviation of the normal distribution. C � �0 or FALSE calculates the probability density function. Any other value or TRUE or omitted calculates the cumulative distribution function. � J 8 SC_HID_FUNC_NORMDIST_MS 4 4Values of the normal distribution. Number R RThe value for which the normal distribution is to be calculated. Mean L LThe mean value. The mean value of the normal distribution. STDEV X XStandard deviation. The standard deviation of the normal distribution. C � �0 or FALSE calculates the probability density function. Any other value or TRUE calculates the cumulative distribution function. R � 2 SC_HID_FUNC_NORMINV < <Values of the inverse normal distribution. number f fThe probability value for which the inverse normal distribution is to be calculated. mean L LThe mean value. The mean value of the normal distribution. STDEV X XStandard deviation. The standard deviation of the normal distribution. � � 6 SC_HID_FUNC_NORMINV_MS < <Values of the inverse normal distribution. number f fThe probability value for which the inverse normal distribution is to be calculated. mean L LThe mean value. The mean value of the normal distribution. STDEV X XStandard deviation. The standard deviation of the normal distribution. � � 4 SC_HID_FUNC_STANDNORMVERT L LThe values of the standard normal cumulative distribution. Number Z ZThe value for which the standard normal distribution is to be calculated. � � 8 SC_HID_FUNC_STD_NORMDIST_MS @ @The values of the standard normal distribution. Number Z ZThe value for which the standard normal distribution is to be calculated. Cumulative � �0 or FALSE calculates the probability density function. Any other value or TRUE calculates the cumulative distribution function. � � 4 SC_HID_FUNC_STANDNORMINV D DValues of the inverse standard normal distribution. number n nThe probability value for which the inverse standard normal distribution is to be calculated. � 6 SC_HID_FUNC_STD_NORMINV_MS D DValues of the inverse standard normal distribution. number n nThe probability value for which the inverse standard normal distribution is to be calculated. 9 ~ 8 SC_HID_FUNC_LOGNORMVERT 8 8Values of the log normal distribution. Number V VThe value for which the log normal distribution is to be calculated. mean Z ZThe mean value of the log normal distribution. It is set to 0 if omitted. STDEV b bThe standard deviation of the log normal distribution. It is set to 1 if omitted. Cumulative � �0 or FALSE calculates the probability density function. Any other value or TRUE or omitted calculates the cumulative distribution function. � D < SC_HID_FUNC_LOGNORMDIST_MS 8 8Values of the log normal distribution. Number V VThe value for which the log normal distribution is to be calculated. mean @ @The mean value of the log normal distribution. STDEV H HThe standard deviation of the log normal distribution. Cumulative � �0 or FALSE calculates the probability density function. Any other value or TRUE calculates the cumulative distribution function. i � 2 SC_HID_FUNC_LOGINV F FValues of the inverse of the lognormal distribution. number j jThe probability value for which the inverse log normal distribution is to be calculated. mean L LMean value. The mean value of the log normal distribution. STDEV \ \Standard deviation. The standard deviation of the log normal distribution. � � 2 SC_HID_FUNC_LOGINV F FValues of the inverse of the lognormal distribution. number j jThe probability value for which the inverse log normal distribution is to be calculated. mean L LMean value. The mean value of the log normal distribution. STDEV \ \Standard deviation. The standard deviation of the log normal distribution. � � 4 SC_HID_FUNC_EXPONVERT 8 8Values of the exponential distribution. Number V VThe value to which the exponential distribution is to be calculated. lambda @ @The parameters of the exponential distribution. C V VCumulated. C=0 calculates the density function, C=1 the distribution. � � 6 SC_HID_FUNC_EXP_DIST_MS 8 8Values of the exponential distribution. Number V VThe value to which the exponential distribution is to be calculated. lambda @ @The parameters of the exponential distribution. C V VCumulated. C=0 calculates the density function, C=1 the distribution. d � 6 SC_HID_FUNC_GAMMAVERT � �Returns the value of the probability density function or the cumulative distribution function for the Gamma distribution. Number P PThe value for which the gamma distribution is to be calculated. alpha @ @The Alpha parameter of the Gamma distribution. beta > >The Beta parameter of the Gamma distribution. Cumulative � �0 or FALSE calculates the probability density function. Any other value or TRUE or omitted calculates the cumulative distribution function. � � : SC_HID_FUNC_GAMMADIST_MS � �Returns the value of the probability density function or the cumulative distribution function for the Gamma distribution. Number P PThe value for which the gamma distribution is to be calculated. alpha @ @The Alpha parameter of the Gamma distribution. beta > >The Beta parameter of the Gamma distribution. Cumulative � �0 or FALSE calculates the probability density function. Any other value or TRUE calculates the cumulative distribution function. e � 4 SC_HID_FUNC_GAMMAINV : :Values of the inverse gamma distribution. Number d dThe probability value for which the inverse gamma distribution is to be calculated. alpha H HThe Alpha (shape) parameter of the Gamma distribution. beta F FThe Beta (scale) parameter of the Gamma distribution. � � 6 SC_HID_FUNC_GAMMAINV_MS : :Values of the inverse gamma distribution. Number d dThe probability value for which the inverse gamma distribution is to be calculated. alpha H HThe Alpha (shape) parameter of the Gamma distribution. beta F FThe Beta (scale) parameter of the Gamma distribution. � � . SC_HID_FUNC_GAMMALN F FReturns the natural logarithm of the gamma function. Number f fThe value for which the natural logarithm of the gamma function is to be calculated. � � 2 SC_HID_FUNC_GAMMALN_MS F FReturns the natural logarithm of the gamma function. Number f fThe value for which the natural logarithm of the gamma function is to be calculated. � � , SC_HID_FUNC_GAMMA : :Returns the value of the Gamma function. Number L LThe value for which the Gamma function is to be calculated. k � : SC_HID_FUNC_BETAVERT 2 2Values of the beta distribution. number P PThe value for which the beta distribution is to be calculated. alpha > >The Alpha parameter of the Beta distribution. beta > >The Beta parameter of the Beta distribution. Start P PThe starting value for the value interval of the distribution.
End L LThe final value for the value interval of the distribution. Cumulative
� �0 or FALSE for probability density function, any other value or TRUE or omitted for cumulative distribution function. l Z 6 SC_HID_FUNC_BETAINV : :Values of the inverse beta distribution. number d dThe probability value for which the inverse beta distribution is to be calculated. alpha > >The Alpha parameter of the Beta distribution. beta > >The Beta parameter of the Beta distribution. Start P PThe starting value for the value interval of the distribution.
End L LThe final value for the value interval of the distribution. � � < SC_HID_FUNC_BETADIST_MS 2 2Values of the beta distribution. number P PThe value for which the beta distribution is to be calculated. alpha > >The Alpha parameter of the Beta distribution. beta > >The Beta parameter of the Beta distribution. Cumulative � �0 or FALSE for probability density function, any other value or TRUE or omitted for cumulative distribution function.
Start P PThe starting value for the value interval of the distribution. End
L LThe final value for the value interval of the distribution. � ^ : SC_HID_FUNC_BETAINV_MS : :Values of the inverse beta distribution. number d dThe probability value for which the inverse beta distribution is to be calculated. alpha > >The Alpha parameter of the Beta distribution. beta > >The Beta parameter of the Beta distribution. Start P PThe starting value for the value interval of the distribution.
End L LThe final value for the value interval of the distribution. = � 4 SC_HID_FUNC_WEIBULL @ @Returns the values of the Weibull distribution. Number R RThe value for which the Weibull distribution is to be calculated. Alpha B BThe Alpha parameter of the Weibull distribution. beta @ @The Beta parameter of the Weibull distribution. C V VCumulated. C=0 calculates the density function, C=1 the distribution. � � < SC_HID_FUNC_WEIBULL_DIST_MS @ @Returns the values of the Weibull distribution. Number R RThe value for which the Weibull distribution is to be calculated. Alpha B BThe Alpha parameter of the Weibull distribution. beta @ @The Beta parameter of the Weibull distribution. C V VCumulated. C=0 calculates the density function, C=1 the distribution. 8 . : SC_HID_FUNC_HYPGEOMVERT < <Values of the hypergeometric distribution. X 8 8The number of successes in the sample. n_sample ( (The size of the sample. successes < <The number of successes in the population. n_population & &The population size.
Cumulative v vCumulated. TRUE calculates the cumulative distribution function, FALSE the probability mass function. � 4 @ SC_HID_FUNC_HYP_GEOM_DIST_MS < <Values of the hypergeometric distribution. X 8 8The number of successes in the sample. n_sample ( (The size of the sample. successes < <The number of successes in the population. n_population & &The population size.
Cumulative v vCumulated. TRUE calculates the cumulative distribution function, FALSE the probability mass function. : � 0 SC_HID_FUNC_TVERT , ,Returns the t-distribution. Number L LThe value for which the T distribution is to be calculated. degrees_freedom > >The degrees of freedom of the T distribution. mode V VMode = 1 calculates the one-tailed test, 2 = two-tailed distribution. � , 2 SC_HID_FUNC_TDIST_2T 8 8Returns the two-tailed t-distribution. Number L LThe value for which the T distribution is to be calculated. degrees_freedom > >The degrees of freedom of the T distribution. � � 4 SC_HID_FUNC_TDIST_MS , ,Returns the t-distribution. Number L LThe value for which the T distribution is to be calculated. degrees_freedom > >The degrees of freedom of the T distribution. cumulative n nTrue calculates the cumulative distribution function, false the probability density function. � . 2 SC_HID_FUNC_TDIST_RT : :Returns the right-tailed t-distribution. Number L LThe value for which the T distribution is to be calculated. degrees_freedom > >The degrees of freedom of the T distribution. f : . SC_HID_FUNC_TINV 6 6Values of the inverse t-distribution. number ` `The probability value for which the inverse T distribution is to be calculated. degrees_freedom > >The degrees of freedom of the T distribution. � H 0 SC_HID_FUNC_TINV_MS B BValues of the left-tailed inverse t-distribution. number ` `The probability value for which the inverse T distribution is to be calculated. degrees_freedom > >The degrees of freedom of the T distribution. � H 0 SC_HID_FUNC_TINV_2T B BValues of the two-tailed inverse t-distribution. number ` `The probability value for which the inverse T distribution is to be calculated. degrees_freedom > >The degrees of freedom of the T distribution. ; � 0 SC_HID_FUNC_FVERT : :Values of the F probability distribution. Number L LThe value for which the F distribution is to be calculated. " "degrees_freedom_1 P PThe degrees of freedom in the numerator of the F distribution. " "degrees_freedom_2 R RThe degrees of freedom in the denominator of the F distribution. � B 6 SC_HID_FUNC_F_DIST_LT D DValues of the left tail F probability distribution. Number L LThe value for which the F distribution is to be calculated. " "degrees_freedom_1 P PThe degrees of freedom in the numerator of the F distribution. " "degrees_freedom_2 R RThe degrees of freedom in the denominator of the F distribution. cumulative b bCumulative distribution function (TRUE) or probability density function (FALSE). � � 4 SC_HID_FUNC_F_DIST_RT F FValues of the right tail F probability distribution. Number L LThe value for which the F distribution is to be calculated. " "degrees_freedom_1 P PThe degrees of freedom in the numerator of the F distribution. " "degrees_freedom_2 R RThe degrees of freedom in the denominator of the F distribution. g � 0 SC_HID_FUNC_FINV 6 6Values of the inverse F distribution. number ` `The probability value for which the inverse F distribution is to be calculated. " "degrees_freedom_1 P PThe degrees of freedom in the numerator of the F distribution. " "degrees_freedom_2 R RThe degrees of freedom in the denominator of the F distribution. � � 4 SC_HID_FUNC_F_INV_LT @ @Values of the inverse left tail F distribution. number ` `The probability value for which the inverse F distribution is to be calculated. " "degrees_freedom_1 P PThe degrees of freedom in the numerator of the F distribution. " "degrees_freedom_2 R RThe degrees of freedom in the denominator of the F distribution. � � 4 SC_HID_FUNC_F_INV_RT B BValues of the inverse right tail F distribution. number ` `The probability value for which the inverse F distribution is to be calculated. " "degrees_freedom_1 P PThe degrees of freedom in the numerator of the F distribution. " "degrees_freedom_2 R RThe degrees of freedom in the denominator of the F distribution. < Z 0 SC_HID_FUNC_CHIVERT T TReturns the right-tail probability of the chi-square distribution. Number V VThe value for which the chi square distribution is to be calculated. degrees_freedom H HThe degrees of freedom of the chi square distribution. � ^ 4 SC_HID_FUNC_CHIVERT_MS T TReturns the right-tail probability of the chi-square distribution. Number V VThe value for which the chi square distribution is to be calculated. degrees_freedom H HThe degrees of freedom of the chi square distribution. � � 4 SC_HID_FUNC_CHISQDIST � �Returns left-tail probability of the cumulative distribution function or values of the probability density function of the chi-square distribution. Number ~ ~The value for which the probability density function or cumulative distribution function is to be calculated. $ $Degrees of Freedom H HThe degrees of freedom of the chi-square distribution. Cumulative � �0 or FALSE calculates the probability density function. Any other value or TRUE or omitted calculates the cumulative distribution function. � � 8 SC_HID_FUNC_CHISQDIST_MS � �Returns left-tail probability of the cumulative distribution function or values of the probability density function of the chi-square distribution. Number ~ ~The value for which the probability density function or cumulative distribution function is to be calculated. $ $Degrees of Freedom H HThe degrees of freedom of the chi-square distribution. Cumulative � �0 or FALSE calculates the probability density function. Any other value or TRUE calculates the cumulative distribution function. c b 0 SC_HID_FUNC_CHIINV H HValues of the inverse of CHIDIST(x; DegreesOfFreedom). number j jThe probability value for which the inverse chi square distribution is to be calculated. degrees_freedom H HThe degrees of freedom of the chi square distribution. � d 2 SC_HID_FUNC_CHIINV_MS H HValues of the inverse of CHIDIST(x; DegreesOfFreedom). number j jThe probability value for which the inverse chi square distribution is to be calculated. degrees_freedom H HThe degrees of freedom of the chi square distribution. � z 2 SC_HID_FUNC_CHISQINV P PValues of the inverse of CHISQDIST(x;DegreesOfFreedom;TRUE()). Probability p pThe probability value for which the inverse of the chi square distribution is to be calculated. $ $Degrees of Freedom H HThe degrees of freedom of the chi square distribution. � | 4 SC_HID_FUNC_CHISQINV_MS P PValues of the inverse of CHISQ.DIST(x;DegreesOfFreedom;TRUE()). Probability p pThe probability value for which the inverse of the chi square distribution is to be calculated. $ $Degrees of Freedom H HThe degrees of freedom of the chi square distribution. C Z < SC_HID_FUNC_STANDARDISIERUNG B BConverts a random variable to a normalized value. Number . .The value to be standardized. mean 0 0The mean value used for moving. STDEV : :The standard deviation used for scaling. � 6 4 SC_HID_FUNC_VARIATIONEN f fReturns the number of permutations for a given number of elements without repetition. Count_1 . .The total number of elements. Count_2 > >The selection number taken from the elements. � : 6 SC_HID_FUNC_VARIATIONEN2 h hReturns the number of permutations for a given number of objects (repetition allowed). Count_1 . .The total number of elements. Count_2 > >The selection number taken from the elements. S f 4 SC_HID_FUNC_KONFIDENZ T TReturns a (1-alpha) confidence interval for a normal distribution. alpha 6 6The level of the confidence interval. STDEV : :The standard deviation of the population. size , ,The size of the population. � j 8 SC_HID_FUNC_CONFIDENCE_N T TReturns a (1-alpha) confidence interval for a normal distribution. alpha 6 6The level of the confidence interval. STDEV : :The standard deviation of the population. size , ,The size of the population. � n 8 SC_HID_FUNC_CONFIDENCE_T X XReturns a (1-alpha) confidence interval for a Student's t distribution. alpha 6 6The level of the confidence interval. STDEV : :The standard deviation of the population. size , ,The size of the population. I � 0 SC_HID_FUNC_GTEST x xCalculates the probability of observing a z-statistic greater than the one computed based on a sample. data P PThe given sample, drawn from a normally distributed population. mu 2 2The known mean of the population. sigma � �The known standard deviation of the population. If omitted, the standard deviation of the given sample is used. � � 4 SC_HID_FUNC_Z_TEST_MS x xCalculates the probability of observing a z-statistic greater than the one computed based on a sample. data P PThe given sample, drawn from a normally distributed population. mu 2 2The known mean of the population. sigma � �The known standard deviation of the population. If omitted, the standard deviation of the given sample is used. h � 0 SC_HID_FUNC_CHITEST : :Returns the chi square independence test. Data_B * *The observed data array. data_E * *The expected data array. � � 4 SC_HID_FUNC_CHITEST_MS : :Returns the chi square independence test. Data_B * *The observed data array. data_E * *The expected data array. T � . SC_HID_FUNC_FTEST ( (Calculates the F test. data_1 ( (The first record array. data_2 * *The second record array. � � 2 SC_HID_FUNC_F_TEST_MS ( (Calculates the F test. data_1 ( (The first record array. data_2 * *The second record array. J � 2 SC_HID_FUNC_TTEST ( (Calculates the T test. data_1 ( (The first record array. data_2 * *The second record array. mode v vMode specifies the number of distribution tails to return. 1= one-tailed, 2 = two-tailed distribution Type ( (The type of the T test. � � 6 SC_HID_FUNC_TTEST_MS ( (Calculates the T test. data_1 ( (The first record array. data_2 * *The second record array. mode v vMode specifies the number of distribution tails to return. 1= one-tailed, 2 = two-tailed distribution Type ( (The type of the T test. Z : SC_HID_FUNC_BESTIMMTHEITSMASS Z ZReturns the square of the Pearson product moment correlation coefficient. data_Y " "The Y data array. data_X " "The X data array. ] 8 SC_HID_FUNC_ACHSENABSCHNITT T TReturns the intercept of the linear regression line and the Y axis. data_Y " "The Y data array. data_X " "The X data array. \ � 2 SC_HID_FUNC_STEIGUNG B BReturns the slope of the linear regression line. data_Y " "The Y data array. data_X " "The X data array. [ � 4 SC_HID_FUNC_STFEHLERYX F FReturns the standard error of the linear regression. data_Y " "The Y data array. data_X " "The X data array. Y � 0 SC_HID_FUNC_PEARSON L LReturns the Pearson product moment correlation coefficient. Data_1 ( (The first record array. Data_2 * *The second record array. W � 0 SC_HID_FUNC_KORREL 6 6Returns the correlation coefficient. Data_1 ( (The first record array. Data_2 * *The second record array. X � . SC_HID_FUNC_KOVAR 6 6Calculates the population covariance. Data_1 ( (The first record array. Data_2 * *The second record array. � � 6 SC_HID_FUNC_COVARIANCE_P 6 6Calculates the population covariance. Data_1 ( (The first record array. Data_2 * *The second record array. � � 6 SC_HID_FUNC_COVARIANCE_S 2 2Calculates the sample covariance. Data_1 ( (The first record array. Data_2 * *The second record array. b X 4 SC_HID_FUNC_SCHAETZER : :Returns a value along a linear regression value ` `The X value for which the Y value on the regression linear is to be calculated. data_Y " "The Y data array. data_X " "The X data array. � F B SC_HID_FUNC_FORECAST_ETS_ADD \ \Calculates future value(s) using additive Exponential Smoothing algorithm. target H HThe date (array) for which you want to predict a value. values @ @The data array from which you want to forecast. timeline X XThe date or numeric array; a consistent step between values is needed. period length Z ZNumber of Samples in Period (default 1); length of the seasonal pattern.
data completion ^ ^Data completion (default 1); 0 treats missing points as zero, 1 interpolates. aggregation
l lAggregation (default 1 = AVERAGE); method to be used to aggregate identical (time) values. � L B SC_HID_FUNC_FORECAST_ETS_MUL b bCalculates future value(s) using multiplicative Exponential Smoothing algorithm. target H HThe date (array) for which you want to predict a value. values @ @The data array from which you want to forecast. timeline X XThe date or numeric array; a consistent step between values is needed. period length Z ZNumber of Samples in Period (default 1); length of the seasonal pattern.
data completion ^ ^Data completion (default 1); 0 treats missing points as zero, 1 interpolates. aggregation
l lAggregation (default 1 = AVERAGE); method to be used to aggregate identical (time) values. � D SC_HID_FUNC_FORECAST_ETS_PIA z zReturns a prediction interval at the specified target value(s) for additive Exponential Smoothing method target H HThe date (array) for which you want to predict a value. values @ @The data array from which you want to forecast. timeline X XThe date or numeric array; a consistent step between values is needed. " "confidence level x xConfidence level (default 0.95); value 0 to 1 (exclusive) for 0 to 100% calculated prediction interval.
period length Z ZNumber of Samples in Period (default 1); length of the seasonal pattern. data completion
^ ^Data completion (default 1); 0 treats missing points as zero, 1 interpolates. aggregation l lAggregation (default 1 = AVERAGE); method to be used to aggregate identical (time) values. � D SC_HID_FUNC_FORECAST_ETS_PIM � �Returns a prediction interval at the specified target value(s) for multiplicative Exponential Smoothing method target H HThe date (array) for which you want to predict a value. values @ @The data array from which you want to forecast. timeline X XThe date or numeric array; a consistent step between values is needed. " "confidence level x xConfidence level (default 0.95); value 0 to 1 (exclusive) for 0 to 100% calculated prediction interval.
period length Z ZNumber of Samples in Period (default 1); length of the seasonal pattern. data completion
^ ^Data completion (default 1); 0 treats missing points as zero, 1 interpolates. aggregation l lAggregation (default 1 = AVERAGE); method to be used to aggregate identical (time) values. � � > SC_HID_FUNC_FORECAST_ETS_SEA | |Calculates the number of samples in period (season) using additive Exponential Triple Smoothing algorithm. values @ @The data array from which you want to forecast. timeline X XThe date or numeric array; a consistent step between values is needed. data completion ^ ^Data completion (default 1); 0 treats missing points as zero, 1 interpolates. aggregation l lAggregation (default 1 = AVERAGE); method to be used to aggregate identical (time) values. � � B SC_HID_FUNC_FORECAST_ETS_STA ^ ^Returns statistical value(s) using additive Exponential Smoothing algorithm. values @ @The data array from which you want to forecast. timeline X XThe date or numeric array; a consistent step between values is needed. statistic type x xValue (1-9) or array of values, indicating which statistic will be returned for the calculated forecast period length Z ZNumber of Samples in Period (default 1); length of the seasonal pattern.
data completion ^ ^Data completion (default 1); 0 treats missing points as zero, 1 interpolates. aggregation
l lAggregation (default 1 = AVERAGE); method to be used to aggregate identical (time) values. � � B SC_HID_FUNC_FORECAST_ETS_STM d dReturns statistical value(s) using multiplicative Exponential Smoothing algorithm. values @ @The data array from which you want to forecast. timeline X XThe date or numeric array; a consistent step between values is needed. statistic type x xValue (1-9) or array of values, indicating which statistic will be returned for the calculated forecast period length Z ZNumber Of Samples in Period (default 1); length of the seasonal pattern.
data completion ^ ^Data completion (default 1); 0 treats missing points as zero, 1 interpolates. aggregation
l lAggregation (default 1 = AVERAGE); method to be used to aggregate identical (time) values. � \ 8 SC_HID_FUNC_FORECAST_LIN : :Returns a value along a linear regression value ` `The X value for which the Y value on the regression linear is to be calculated. data_Y " "The Y data array. data_X " "The X data array. 2 6 SC_HID_FUNC_ADRESSE : :Returns the reference to a cell as text. row , ,The row number of the cell. column 0 0The column number of the cell. ABS R RSpecifies whether absolute or relative referencing is to be used. A1 n nThe reference style: 0 or FALSE means R1C1 style, any other value or omitted means A1 style.
sheet < <The spreadsheet name of the cell reference. # � 0 SC_HID_FUNC_BEREICHE \ \Returns the number of individual ranges that belong to a (multiple) range. reference 6 6The reference to a (multiple) range. : . SC_HID_FUNC_WAHL J JSelects a value from a list of up to 30 value arguments. Index : :The index of the value (1..30) selected. value Z ZValue 1, value 2,... The list of arguments from which a value is chosen. � � . SC_HID_FUNC_SPALTE D DReturns the internal column number of a reference. reference 4 4The reference to a cell or a range. � � , SC_HID_FUNC_ZEILE @ @Defines the internal row number of a reference. reference 4 4The reference to a cell or a range. s � . SC_HID_FUNC_TABELLE N NReturns the internal sheet number of a reference or a string. reference \ \The reference to a cell or a range or the character string of a sheet name. � � . SC_HID_FUNC_SPALTEN H HReturns the number of columns in an array or reference. array \ \The array (reference) for which the number of columns is to be determined. � � . SC_HID_FUNC_ZEILEN D DReturns the number of rows in a reference or array. array X XThe array (reference) for which the number of rows is to be determined. t 0 SC_HID_FUNC_TABELLEN � �Returns the number of sheets of a given reference. If no parameter has been entered, the total number of sheets in the document is returned. reference 4 4The reference to a cell or a range. � 6 SC_HID_FUNC_WVERWEIS L LHorizontal search and reference to the cells located below. search_criteria 8 8The value to be found in the first row. array : :The array or the range for the reference. Index , ,The row index in the array. sorted r rIf the value is TRUE or not given, the search row of the array must be sorted in ascending order. � 6 SC_HID_FUNC_SVERWEIS B BVertical search and reference to indicated cells. " "Search criterion < <The value to be found in the first column. array 4 4The array or range for referencing. Index 2 2Column index number in the array. sort order v vIf the value is TRUE or not given, the search column of the array must be sorted in ascending order. " � 2 SC_HID_FUNC_INDEX D DReturns a reference to a cell from a defined range. reference 6 6The reference to a (multiple) range. row & &The row in the range. column * *The column in the range. range L LThe index of the subrange if referring to a multiple range. � 2 SC_HID_FUNC_INDIREKT P PReturns the contents of a cell that is referenced in text form. ref j jThe cell whose contents are to be evaluated is to be referenced in text form (e.g. "A1"). A1 n nThe reference style: 0 or FALSE means R1C1 style, any other value or omitted means A1 style. � 2 SC_HID_FUNC_VERWEIS Z ZDetermines a value in a vector by comparison to values in another vector. " "Search criterion 6 6The value to be used for comparison. Search vector @ @The vector (row or column) in which to search. result_vector T TThe vector (row or range) from which the value is to be determined. � 4 SC_HID_FUNC_VERGLEICH F FDefines a position in a array after comparing values. " "Search criterion 6 6The value to be used for comparison. lookup_array @ @The array (range) in which the search is made. Type x xType can take the value 1, 0 or -1 and determines the criteria are to be used for comparison purposes. ! h < SC_HID_FUNC_VERSCHIEBUNG \ \Returns a reference which has been moved in relation to the starting point. reference F FThe reference (cell) from which to base the movement. rows B BThe number of rows to be moved either up or down. columns X XThe number of columns that are to be moved to the left or to the right. height < <The number of rows of the moved reference.
width > >The number of columns in the moved reference. � � 0 SC_HID_FUNC_FEHLERTYP @ @Returns a number corresponding to an error type reference B BThe reference (cell) in which the error occurred. � R 6 SC_HID_FUNC_ERROR_TYPE_ODF f fReturns a number corresponding to one of the error values or #N/A if no error exists expression � �The error value whose identifying number you want to find. Can be the actual error value or a reference to a cell that you want to test. p h 2 SC_HID_FUNC_VORLAGE 6 6Applies a Style to the formula cell. Style 6 6The name of the Style to be applied. Time J JThe time (in seconds) that the Style is to remain valid. Style2 < <The Style to be applied after time expires. q � 0 SC_HID_FUNC_DDE & &Result of a DDE link. server 4 4The name of the server application. File & &The name of the file. range : :The range from which data is to be taken. mode @ @Defines how data is to be converted to numbers. � � 2 SC_HID_FUNC_HYPERLINK Hyperlink. URL URL CellText Cell Text � � 8 SC_HID_FUNC_GETPIVOTDATA 6 6Extracts value(s) from a pivot table. Data Field > >The name of the pivot table field to extract. Pivot Table D DA reference to a cell or range in the pivot table. " "Field Name / Item B BField name/value pair to filter the target data. � � 0
SC_HID_FUNC_BAHTTEXT 2 2Converts a number to text (Baht). Number ( (The number to convert. � � *
SC_HID_FUNC_JIS R RConverts half-width ASCII and katakana characters to full-width. text & &The text to convert. � � *
SC_HID_FUNC_ASC R RConverts full-width ASCII and katakana characters to half-width. text & &The text to convert. � � ,
SC_HID_FUNC_CODE R RReturns a numeric code for the first character in a text string. text \ \This is the text for which the code of the first character is to be found. $ n ,
SC_HID_FUNC_DM > >Converts a number to text in currency format. value t tValue is a number, a reference to a cell containing a number or a formula that results in a number. decimals ` `Decimal places. Denotes the number of digits to the right of the decimal point. � � .
SC_HID_FUNC_ZEICHEN D DConverts a code number into a character or letter. number 2 2The code value for the character. � � 0
SC_HID_FUNC_SAEUBERN @ @Removes all nonprintable characters from text. text P PThe text from which nonprintable characters are to be removed. 0 � 0
SC_HID_FUNC_VERKETTEN 6 6Combines several text items into one. text , ,Text for the concatenation. � � 0
SC_HID_FUNC_CONCAT_MS X XCombines several text items into one, accepts cell ranges as arguments. text @ @Text and/or cell ranges for the concatenation. � � 6
SC_HID_FUNC_TEXTJOIN_MS v vCombines several text items into one, accepts cell ranges as arguments. Uses delimiter between items. delimiter 6 6Text string to be used as delimiter. " "skip empty cells 6 6If TRUE, empty cells will be ignored. text @ @Text and/or cell ranges for the concatenation. � R 0 SC_HID_FUNC_IFS_MS < l lChecks 1 or more conditions and returns a value corresponding to the first true condition. test L LAny value or expression which can be either TRUE or FALSE. result < <The result of the function if test is TRUE. � � 4 SC_HID_FUNC_SWITCH_MS = ~ ~Checks 1 or more values and returns a result corresponding to the first value equal to the given expression. expression D DValue that will be compared against value1-valueN. value @ @Value that will be compared against expression. result V VValue to return when corresponding value argument matches expression. � � 4 SC_HID_FUNC_MINIFS_MS = f fReturns the minimum value in a range that meet multiple criteria in multiple ranges. min_range F FThe range from which the minimum will be determined. range \ \Range 1, range 2,... are the ranges to be evaluated by the criteria given. criteria ` `Criteria 1, criteria 2,... are the criteria to be applied to the ranges given. � � 4 SC_HID_FUNC_MAXIFS_MS = f fReturns the maximum value in a range that meet multiple criteria in multiple ranges. max_range F FThe range from which the maximum will be determined. range \ \Range 1, range 2,... are the ranges to be evaluated by the criteria given. criteria ` `Criteria 1, criteria 2,... are the criteria to be applied to the ranges given. ( 2
SC_HID_FUNC_IDENTISCH < <Specifies whether two texts are identical. text_1 @ @The first text to be used for comparing texts. text_2 6 6The second text for comparing texts. ' p 2
SC_HID_FUNC_FINDEN L LLooks for a string of text within another (case sensitive) find_text & &The text to be found. text : :The text in which a search is to be made. position H HThe position in the text from which the search starts. + p 2
SC_HID_FUNC_SUCHEN N NLooks for one text value within another (not case-sensitive). find_text & &The text to be found. text : :The text in which a search is to be made. position F FThe position in the text where the search is started. � � 0
SC_HID_FUNC_GLAETTEN 0 0Removes extra spaces from text. text P PThe text in which extra spaces between words are to be deleted. � � .
SC_HID_FUNC_GROSS2 < <Capitalizes the first letter in all words. text ` `The text in which the beginning of words are to be replaced by capital letters. � � ,
SC_HID_FUNC_GROSS , ,Converts text to uppercase. text V VThe text in which lower case letters are to be converted to capitals. � � ,
SC_HID_FUNC_KLEIN , ,Converts text to lowercase. text P PThe text in which capitals are converted to lower case letters. � � ,
SC_HID_FUNC_WERT , ,Converts text to a number. text 6 6The text to be converted to a number. - .
SC_HID_FUNC_TEXT H HConverts a number to text according to a given format. number 4 4The numeric value to be converted. Format 4 4The text that describes the format. � � (
SC_HID_FUNC_T J JReturns a value if it is text, otherwise an empty string. value D DThe value to be checked and returned if it is text. % � 6
SC_HID_FUNC_ERSETZEN X XReplaces characters within a text string with a different text string. Text F FThe text in which some characters are to be replaced. position J JThe character position from which text is to be replaced. length : :The number of characters to be replaced. new text * *The text to be inserted. & � 0
SC_HID_FUNC_FEST p pFormats a number with a fixed number of places after the decimal point and thousands separator. number , ,The number to be formatted. Decimals ^ ^Decimal places. The number of fixed decimal places that are to be displayed. ( (No thousands separators z zThousands separator. If 0 or omitted the locale group separator is used else the separator is suppressed. � � .
SC_HID_FUNC_LAENGE 4 4Calculates length of a text string. text B BThe text in which the length is to be determined. ) 0 .
SC_HID_FUNC_LINKS F FReturns the first character or characters of a text. text P PThe text where the initial partial words are to be determined. number > >The number of characters for the start text. * , 0
SC_HID_FUNC_RECHTS D DReturns the last character or characters of a text. text N NThe text in which the end partial words are to be determined. number < <The number of characters for the end text. , x 0
SC_HID_FUNC_TEIL : :Returns a partial text string of a text. text F FThe text in which partial words are to be determined. start L LThe position from which the part word is to be determined. number 8 8The number of characters for the text. / 4
SC_HID_FUNC_WIEDERHOLEN 6 6Repeats text a given number of times. text * *The text to be repeated. number @ @The number of times the text is to be repeated. . � 6
SC_HID_FUNC_WECHSELN @ @Substitutes new text for old text in a string. text D DThe text in which partial words are to be replaced. search_text @ @The partial string to be (repeatedly) replaced. new text > >The text which is to replace the text string. occurrence D DWhich occurrence of the old text is to be replaced. r � 0
SC_HID_FUNC_BASIS ^ ^Converts a positive integer to text from a number system to the base defined. number , ,The number to be converted. radix L LThe base number for conversion must be in the range 2 - 36. Minimum length n nIf the text is shorter than the specified length, zeros are added to the left of the string. } 8 0
SC_HID_FUNC_DEZIMAL f fConverts a text of a specified number system to a positive integer in the base given. text * *The text to be converted. radix L LThe base number for conversion must be in the range 2 - 36. ~ � 4 SC_HID_FUNC_UMRECHNEN b bConverts a value according to a conversion table in the configuration (main.xcd). value , ,The value to be converted. text H HUnit from which something is converted, case-sensitive. text H HUnit into which something is converted, case-sensitive. t 2
SC_HID_FUNC_ROEMISCH 6 6Converts a number to a Roman numeral. Number ^ ^The number to be converted to a Roman numeral must be in the 0 - 3999 range. Mode � �The more this value increases, the more the Roman numeral is simplified. The value must be in the 0 - 4 range. � � 0
SC_HID_FUNC_ARABISCH : :Calculates the value of a Roman numeral. Text : :The text that represents a Roman numeral. � � , SC_HID_FUNC_INFO < <Returns information about the environment. Text R RCan be "osversion", "system", "release", "numfile", and "recalc". � � .
SC_HID_FUNC_UNICODE \ \Returns the numeric code for the first Unicode character in a text string. text \ \This is the text for which the code of the first character is to be found. � � .
SC_HID_FUNC_UNICHAR L LConverts a code number into a Unicode character or letter. number 2 2The code value for the character. � : SC_HID_FUNC_EUROCONVERT D DConverts a value from one to another Euro currency. value , ,The value to be converted. from_currency X XISO 4217 code of the currency from which is converted, case-sensitive. to_currency X XISO 4217 code of the currency into which is converted, case-sensitive. full_precision � �If omitted or 0 or FALSE, the result is rounded to the decimals of to_currency. Else the result is not rounded.
( (triangulation_precision � �If given and >=3, the intermediate result of a triangular conversion is rounded to that precision. If omitted, the result is not rounded. � � 6
SC_HID_FUNC_NUMBERVALUE H HConverts text to a number, in a locale-independent way. text 6 6The text to be converted to a number. " "decimal_separator F FDefines the character used as the decimal separator. group_separator F FDefines the character(s) used as the group separator. � � 0 SC_HID_FUNC_BITAND 0 0Bitwise "AND" of two integers. Number1 2 2Positive integer less than 2^48. Number2 2 2Positive integer less than 2^48. � � . SC_HID_FUNC_BITOR . .Bitwise "OR" of two integers. Number1 2 2Positive integer less than 2^48. Number2 2 2Positive integer less than 2^48. � � 0 SC_HID_FUNC_BITXOR 8 8Bitwise "exclusive OR" of two integers. Number1 2 2Positive integer less than 2^48. Number2 2 2Positive integer less than 2^48. � , 2 SC_HID_FUNC_BITRSHIFT : :Bitwise right shift of an integer value. Number J JThe value to be shifted. Positive integer less than 2^48. Shift H HThe integer number of bits the value is to be shifted. � * 2 SC_HID_FUNC_BITLSHIFT 8 8Bitwise left shift of an integer value. Number J JThe value to be shifted. Positive integer less than 2^48. Shift H HThe integer number of bits the value is to be shifted. � � ,
SC_HID_FUNC_LENB > >Calculates length of a text string, with DBCS text B BThe text in which the length is to be determined. � 6 0
SC_HID_FUNC_RIGHTB N NReturns the last character or characters of a text,with DBCS text N NThe text in which the end partial words are to be determined. number < <The number of characters for the end text. � 8 .
SC_HID_FUNC_LEFTB N NReturns the first character or characters of a text,with DBCS text P PThe text where the initial partial words are to be determined. number > >The number of characters for the start text. � � 0
SC_HID_FUNC_MIDB D DReturns a partial text string of a text, with DBCS text F FThe text in which partial words are to be determined. start L LThe position from which the part word is to be determined. number 8 8The number of characters for the text. � " 2
SC_HID_FUNC_FILTERXML > >Apply an XPath expression to an XML document XML Document 6 6String containing a valid XML stream " "XPath expression < <String containing a valid XPath expression � V 2 SC_HID_FUNC_COLOR R RReturns an implementation defined value representing a RGBA color Red Value of red Green Value of green Blue Value of blue Alpha Value of alpha � � 2
SC_HID_FUNC_WEBSERVICE 2 2Get some webcontent from an URI. URI & &URI of the webservice � � 0
SC_HID_FUNC_ENCODEURL . .Return a URL-encoded string. Text , ,A string to be URL-encoded � � . SC_HID_FUNC_ERF_MS , ,Returns the error function. Lower Limit 0 0The lower limit for integration � � . SC_HID_FUNC_ERFC_MS : :Returns the complementary error function. Lower Limit 0 0The lower limit for integration � � 6 SC_HID_FUNC_RAWSUBTRACT n nReturns the subtraction of numbers. Like a-b-c but without eliminating small roundoff errors. minuend F FNumber from which following arguments are subtracted. subtrahend f fSubtrahend 1, subtrahend 2, ... are numerical arguments subtracted from the minuend. a� , Database Date&Time Financial Information Logical Mathematical Array Statistical Spreadsheet
Text Add-in a� � A Moving Average @ & &Exponential Smoothing = & &Analysis of Variance n & &ANOVA - Single Factor z $ $ANOVA - Two Factor o Groups p Between Groups q Within Groups r $ $Source of Variation s SS t df u MS v F w P-value x F critical y Total > Correlation � Correlations ? Covariance � Covariances < ( (Descriptive Statistics ( Mean ) Standard Error * Mode + Median , Variance - $ $Standard Deviation . Kurtosis / Skewness 0 Range 1 Minimum 2 Maximum 3 Sum 4 Count 5 First Quartile 6 Third Quartile * *Random ($(DISTRIBUTION)) Uniform Uniform Integer Normal Cauchy Bernoulli Binomial " "Negative Binomial Chi Squared
Geometric Minimum Maximum Mean $ $Standard Deviation Median Sigma p Value " "Number of Trials nu Value ' Sampling F F-test G F-test D t-test E t-test H z-test I z-test J 2 2Test of Independence (Chi-Square) C Regression B Regression d Column %NUMBER% e Row %NUMBER% � Alpha � Variable 1 � Variable 2 � . .Hypothesized Mean Difference � Observations � * *Observed Mean Difference � df � P-value � Critical Value � Test Statistic � Linear � Logarithmic � Power � " "Regression Model � R^2 � Slope � Intercept � $ $P (F<=f) right-tail � & &F Critical right-tail � $ $P (F<=f) left-tail � & &F Critical left-tail � P two-tail � $ $F Critical two-tail � $ $Pearson Correlation � , ,Variance of the Differences � t Stat � " "P (T<=t) one-tail � $ $t Critical one-tail � " "P (T<=t) two-tail � $ $t Critical two-tail � z � Known Variance � " "P (Z<=z) one-tail � $ $z Critical one-tail � " "P (Z<=z) two-tail � $ $z Critical two-tail d� � Sort Ascending Sort Descending Custom Sort All , ,Show only the current item. , ,Hide only the current item. Search items... � Column inserted � Row inserted � Sheet inserted � Column deleted � Row deleted � Sheet deleted � Range moved � " "Changed contents � " "Changes rejected � Accepted � Rejected � No Entry � " "Changed contents � Changed to � Original � <empty> � Copy results to � Operator � Field Name � Condition � Value b Height b
Row Height b Add b $ $Optimal Row Height b Width b Column Width b Add b & &Optimal Column Width b - undefined - b unnamed b - none - b Empty b Not Empty b Column %1 b Row %1 b ~New b ~Delete b Cance~l b Show Sheet b! Hidden Sheets b$ Sheet b% Name b& Insert Sheet b' Append Sheet b( Rename Sheet b) Insert Image b1 - new sheet - b3 " "Protect Document b4 $ $Unprotect document b5 Protect Sheet b6 Unprotect sheet b7 Password: b8 & &Password (optional): b9 $ $Incorrect Password b; ~End b< Printing... b= Unknown b> Font Attributes b? - all - b@ $ $Standard Filter... bA System Options bB " "Document Options bC View Options bD " "Spelling Options bE Print Options bG System bH P PStandard;Text;Date (DMY);Date (MDY);Date (YMD);US English;Hide bI 6 6, 44 ; 59 : 58 {%TAB} 9 {%SPACE} 32 bJ " 34 ' 39 bK - multiple - bM Input Options bN Top 10 bO $ $Navigator Settings bY . .Image file can not be opened bZ , ,Image file can not be read b[ & &Unknown image format b\ : :This image file version is not supported b] ( (Image filter not found b^ > >Not enough memory available to insert image. b_ Image Filter b` . .Range contains column la~bels ba , ,Range contains ~row labels bb Protect Records bc " "Unprotect Records bd Text be Select Sheets bf " "~Selected sheets bg ~ ~You are pasting data into cells that already contain data.
Do you really want to overwrite the existing data? bj ~All bk More ~Options bl Fewer ~Options bp Align left bq & &Centered horizontally br Align right bs Justify bt " "Repeat alignment bu . .Horizontal alignment default bv Align to top bw $ $Centered vertically bx Align to bottom by , ,Vertical alignment default bz Top to bottom b{ Bottom to Top b| $ $Default orientation b� Pages b� 0 0~Suppress output of empty pages b� Print content b� ~All sheets b� " "~Selected sheets b� Selected cells b� " "From which print b� All ~pages b� Pa~ges b� %PRODUCTNAME %s b� Ruler b� @ @This ruler manages objects at fixed positions. b� Preview b� P PThis sheet shows how the data will be arranged in the document. b� Document view b� b� Sheet %1 b� b� Cell %1 b� b� Page preview b� b� b� b� Left area b� b� Center area b� b� Right area b� b� " "Header of page %1 b� b� " "Footer of page %1 b� b� Input line b� L LThis is where you enter or edit text, numbers and formulas. b� Cell %1 b� b� ^ ^Fields that you drop here will be displayed as rows in the final pivot table. b� b bFields that you drop here will be displayed as columns in the final pivot table. b� b bFields that you drop here will be used for calculations in the final pivot table. b� T TLists the fields that you can drag to one of the other three areas. b� r rFields that you drop here will be available as filter lists at the top of the final pivot table. b� " "Formula Tool Bar b� * *%PRODUCTNAME Spreadsheets b� (Preview mode) b� (read-only) b� Spreadsheet b� : :%PRODUCTNAME %PRODUCTVERSION Spreadsheet b� � �You have a large amount of data saved in the clipboard.
Do you want the clipboard contents to be available in other applications? b� � �%PRODUCTNAME Calc found an error in the formula entered.
Do you want to accept the correction proposed below?
b� Name Object b� Condition b� 2 2Warn me about this in the future. b� Sheet b� Cell b� Content b� Page Anchor b� Cell Anchor c Contents c Sheets c Range names c Database ranges c
Images c OLE objects c Comments c
Linked areas c Drawing objects c Drag Mode c Display c active c inactive c hidden c Active Window c Scenario Name c Comment c? Input line c@ Name Box cA Function Wizard cB Accept cC Cancel cD Sum cE Function cF ~Minimum cG ~Maximum cH ~Value cI ~Source cJ ~Entries cK Selection area c� Media Playback c� & &Mouse button pressed c� Tab Color c� Default c� � �The following DDE source could not be updated possibly because the source document was not open. Please launch the source document and try again. c� $ $Expand Formula Bar c� & &Collapse Formula Bar c� r rThe following external file could not be loaded. Data linked from this file did not get updated. c� Calc A1 c� Excel A1 c� Excel R1C1 c� Tab c� space c� Invalid value c� & &No formula specified. c� 2 2Neither row or column specified. c� * *Undefined name or range. c� 8 8Undefined name or wrong cell reference. c� . .Formulas don't form a column. c� , ,Formulas don't form a row. c� Add AutoFormat c� " "Rename AutoFormat c� Name c� " "Delete AutoFormat c� @ @Do you really want to delete the # AutoFormat? c� ~Close c� Jan c� Feb c� Mar c� North c� Mid c� South c� Total c� * *Updating external links. c� Not protected c� ( (Not password-protected c� " "Hash incompatible c� Hash compatible c� " "Hash re-generated c� Re-type c� Conflict c� Author c� Date c� Unknown User u1 Dummy1 u2 Dummy2 u6 Dummy3 bh y � � Sum Count Average Median Max Min Product Count (Numbers only) StDev (Sample) StDevP (Population) Var (Sample) VarP (Population) b~ y ~ ~ Millimeter Centimeter Meter Kilometer Inch Foot Miles
Pica Point d� y \ \ All Styles ��Hidden Styles Applied Styles @ Custom Styles � d� y H H All Styles ��Hidden Styles Custom Styles � � D D sc/res/icon-set-negative-yellow-smilie.png � D D sc/res/icon-set-positive-yellow-smilie.png � @ @ sc/res/icon-set-negative-red-smilie.png � B B sc/res/icon-set-neutral-yellow-smilie.png � B B sc/res/icon-set-positive-green-smilie.png � : : sc/res/icon-set-triangles-up.png � < < sc/res/icon-set-triangles-same.png � < < sc/res/icon-set-triangles-down.png � @ @ sc/res/icon-set-trafficlights-green.png � B B sc/res/icon-set-trafficlights-yellow.png � > >
sc/res/icon-set-trafficlights-red.png � < < sc/res/icon-set-symbols1-cross.png � F F sc/res/icon-set-symbols1-exclamation-mark.png � < <
sc/res/icon-set-symbols1-check.png � 8 8 sc/res/icon-set-stars-full.png � 8 8 sc/res/icon-set-stars-half.png � 8 8 sc/res/icon-set-stars-empty.png � : : sc/res/icon-set-squares-full.png � D D sc/res/icon-set-squares-three-quarters.png � : : sc/res/icon-set-squares-half.png � @ @ sc/res/icon-set-squares-one-quarter.png � : : sc/res/icon-set-squares-empty.png � < < sc/res/icon-set-shapes-diamond.png � < < sc/res/icon-set-shapes-triangle.png � : : sc/res/icon-set-shapes-circle.png � 6 6 sc/res/icon-set-pies-full.png � @ @ sc/res/icon-set-pies-three-quarters.png � 6 6 sc/res/icon-set-pies-half.png � > > sc/res/icon-set-pies-one-quarter.png � 8 8 sc/res/icon-set-pies-empty.png � : : sc/res/icon-set-grayarrows-up.png � D D sc/res/icon-set-grayarrows-slightly-up.png � < < sc/res/icon-set-grayarrows-same.png � F F !sc/res/icon-set-grayarrows-slightly-down.png � < < "sc/res/icon-set-grayarrows-down.png � 8 8 #sc/res/icon-set-flags-green.png � : : $sc/res/icon-set-flags-yellow.png � 6 6 %sc/res/icon-set-flags-red.png � < < &sc/res/icon-set-colorarrows-up.png � D D 'sc/res/icon-set-colorarrows-slightly-up.png � > > (sc/res/icon-set-colorarrows-same.png � F F )sc/res/icon-set-colorarrows-slightly-down.png � > > *sc/res/icon-set-colorarrows-down.png � > > +sc/res/icon-set-circles2-dark-red.png � @ @ ,sc/res/icon-set-circles2-light-red.png � @ @ -sc/res/icon-set-circles2-light-gray.png � @ @ .sc/res/icon-set-circles2-dark-gray.png � 6 6 /sc/res/icon-set-bars-full.png � @ @ 0sc/res/icon-set-bars-three-quarters.png � 6 6 1sc/res/icon-set-bars-half.png � > > 2sc/res/icon-set-bars-one-quarter.png � 8 8 3sc/res/icon-set-bars-empty.png � : : 4sc/res/icon-set-circles1-red.png � < < 5sc/res/icon-set-circles1-yellow.png � < < 6sc/res/icon-set-circles1-green.png � : : 7sc/res/icon-set-circles1-gray.png c� # @ @ , , 8sc/res/dropurl.png c� # @ @ , , 9sc/res/droplink.png c� # @ @ , , :sc/res/dropcopy.png c� # L L 8 8 ;sc/res/popup_select_current.png c� # N N : : <sc/res/popup_unselect_current.png c� # J J 6 6 =sc/res/sidebar/CellBorder.png c� # X X D D >sc/res/sidebar/CellBorderLineStyle_005.png c� # X X D D ?sc/res/sidebar/CellBorderLineStyle_250.png c� # X X D D @sc/res/sidebar/CellBorderLineStyle_400.png c� # X X D D Asc/res/sidebar/CellBorderLineStyle_500.png c� # X X D D Bsc/res/sidebar/CellBorderLineStyle_110.png c� # X X D D Csc/res/sidebar/CellBorderLineStyle_260.png c� # X X D D Dsc/res/sidebar/CellBorderLineStyle_450.png c� # X X D D Esc/res/sidebar/CellBorderLineStyle_505.png c� # X X D D Fsc/res/sidebar/CellBorderLineStyle_750.png c� # D D 0 0 Gsc/res/xml_element.png c� # J J 6 6 Hsc/res/xml_element_repeat.png c� # F F 2 2 Isc/res/xml_attribute.png dn # > > * * Jsc/res/lftrgt.png do # @ @ , , Ksc/res/topdown.png $ � � sc sc/imglst/sc26047.png e�sc/imglst/sc26048.png e�sc/imglst/sc26049.png e�sc/imglst/sc26050.png e�sc/imglst/sc26051.png e� $ � � lc sc/imglst/lc26047.png e�sc/imglst/lc26048.png e�sc/imglst/lc26049.png e�sc/imglst/lc26050.png e�sc/imglst/lc26051.png e� a� $ > > ou sc/imglst/ou01.png sc/imglst/ou02.png sc/imglst/ou03.png sc/imglst/ou04.png sc/imglst/ou05.png sc/imglst/ou06.png sc/imglst/ou07.png sc/imglst/ou08.png sc/imglst/ou09.png sc/imglst/ou010.png
sc/imglst/ou011.png sc/imglst/ou012.png a� $ � � nc sc/imglst/nc01.png sc/imglst/nc02.png sc/imglst/nc03.png sc/imglst/nc04.png sc/imglst/nc05.png sc/imglst/nc06.png sc/imglst/nc07.png sc/imglst/nc08.png d� $ D D sf sc/res/sf01.png sc/res/sf02.png d� � � H H N d� Insert as Hyperlink SC_HID_SC_DROPMODE_URL D D N d� Insert as Link SC_HID_SC_DROPMODE_LINK D D N d� Insert as Copy SC_HID_SC_DROPMODE_COPY d� � � : : J d�Delete SC_HID_SC_SCENARIO_DELETE > > J d�Properties... SC_HID_SC_SCENARIO_EDIT d� � � B B J 1Edit Comment... SC_HID_SC_CHANGES_COMMENT ^ ^
2Sorting > > : : N 3 Action SC_HID_SC_SORT_ACTION < < N 4 Position SC_HID_SORT_POSITION : : N 5 Author SC_HID_SC_SORT_AUTHOR 6 6 N 6 Date SC_HID_SC_SORT_DATE @ @ N 7 Description SC_HID_SC_SORT_COMMENT � Q � �� a� a� R" a� ]� a� * a� j� a� k� d� w� � x� � x� � x� � x� � y � y. � yL � yh � y� � y� � y� � y� � y� � z � z8 � zR � zj � z� � z� � z� � z� b z� b
{ b {$ b {8 b {\ b {r b {� b {� b {� b {� b | b | b |0 b |J b |d b || b |� b |� b |� b! |� b$ |� b% } b& }( b' }F b( }d b) }� b1 }� b3 }� b4 }� b5 ~ b6 ~" b7 ~B b8 ~\ b9 ~� b; ~� b< ~� b= ~� b> ~� b? b@ ( bA L bB l bC � bD � bE � bG � bH � bI �T bJ �� bK �� bM �� bN �� bO �� bY � bZ �J b[ �v b\ �� b] �� b^ �� b_ �< b` �Z ba �� bb �� bc �� bd �� be � bf �* bg �L bj �� bk �� bl �� bp � bq �: br �` bs �| bt �� bu �� bv �� bw � bx �& by �F bz �r b{ �� b| �� b� �� b� �� b� � b� �6 b� �R b� �t b� �� b� �� b� �� b� �� b� �
b� � b� �` b� �x b� �� b� �� b� �� b� � b� �$ b� �< b� �N b� �l b� �~ b� �� b� �� b� �� b� �� b� �� b� �� b� � b� �* b� �L b� �^ b� �� b� �� b� �� b� �� b� � b� �$ b� �� b� �� b� �F b� �� b� � b� �. b� �X b� �x b� �� b� �� b� �� b� �| b� �� b� � b� �4 b� �f b� �| b� �� b� �� b� �� c �� c �� c � c �0 c
�P c �h c �� c
�� c �� c �� c �� c � c �& c �@ c �X c �v c �� c? �� c@ �� cA �� cB � cC � cD �2 cE �F cF �` cG �z cH �� cI �� cJ �� cK �� c� �� c� � c� �D c� �^ c� �v c� � c� �< c� �b c� �� c� �� c� � c� �" c� �6 c� �L c� �j c� �� c� �� c� �� c� �$ c� �R c� �~ c� �� c� �� c� �� c� �� c� �8 c� �P c� �d c� �x c� �� c� �� c� �� c� �� c� �� c� � c� �* c� �R c� �t c� �� c� �� c� �� c� �� c� � c� � u1 �4 u2 �L u6 �d � �f � �� � �� � �. � �p � �� � �� � �( � �d � �� � �� � �$ � �` � �� � �� � � � �R � �� � �� � � � �B � �� � �� � �� � �4 � �n � �� � �� � � � �X � �� � �� � � � �J � �� � �� � � � �> � �t � �� � �� � �2 � �x � �� � �� � �4 � �t � �� � �� � �* � �` � �� � �� � � � �L � �� d� �p d� �X d� �� # c� �� # c� � # c� �B # c� �� # c� �� # c� � # c� �f # c� �� # c� � # c� �n # c� �� # c� � # c� �v # c� �� # c� �& # c� �~ # c� �� # c� � # dn �R # do �� $ �� $ �p $ a� � $ a� �N $ d� �, y bh �| y b~ �D y d� �� y d� � �