[gnumeric] 1.10.6
- From: Morten Welinder <mortenw src gnome org>
- To: commits-list gnome org
- Cc:
- Subject: [gnumeric] 1.10.6
- Date: Thu, 17 Jun 2010 00:19:16 +0000 (UTC)
commit 06c4b14394f776346f2311656b37458533e8b091
Author: Morten Welinder <terra gnome org>
Date: Wed Jun 16 20:19:09 2010 -0400
1.10.6
ChangeLog | 4 +
doc/C/ChangeLog | 4 +
doc/C/func.defs | 467 ++++++++++++++++++-----------------
doc/C/functions.xml | 463 +++++++++++++++++-----------------
doc/ChangeLog | 4 +
doc/de/ChangeLog | 4 +
plugins/applix/ChangeLog | 4 +
plugins/corba/ChangeLog | 4 +
plugins/dif/ChangeLog | 4 +
plugins/excel/ChangeLog | 4 +
plugins/fn-christian-date/ChangeLog | 4 +
plugins/fn-complex/ChangeLog | 4 +
plugins/fn-database/ChangeLog | 4 +
plugins/fn-date/ChangeLog | 4 +
plugins/fn-derivatives/ChangeLog | 4 +
plugins/fn-eng/ChangeLog | 4 +
plugins/fn-erlang/ChangeLog | 4 +
plugins/fn-financial/ChangeLog | 4 +
plugins/fn-hebrew-date/ChangeLog | 4 +
plugins/fn-info/ChangeLog | 4 +
plugins/fn-logical/ChangeLog | 4 +
plugins/fn-lookup/ChangeLog | 4 +
plugins/fn-math/ChangeLog | 4 +
plugins/fn-numtheory/ChangeLog | 4 +
plugins/fn-numtheory/doc/ChangeLog | 4 +
plugins/fn-r/ChangeLog | 4 +
plugins/fn-random/ChangeLog | 4 +
plugins/fn-stat/ChangeLog | 4 +
plugins/fn-string/ChangeLog | 4 +
plugins/fn-tsa/ChangeLog | 4 +
plugins/gda/ChangeLog | 4 +
plugins/glpk/ChangeLog | 4 +
plugins/gnome-db/ChangeLog | 4 +
plugins/gnome-glossary/ChangeLog | 4 +
plugins/guile/ChangeLog | 4 +
plugins/html/ChangeLog | 4 +
plugins/lotus-123/ChangeLog | 4 +
plugins/lpsolve/ChangeLog | 4 +
plugins/mps/ChangeLog | 4 +
plugins/nlsolve/ChangeLog | 4 +
plugins/oleo/ChangeLog | 4 +
plugins/openoffice/ChangeLog | 4 +
plugins/paradox/ChangeLog | 4 +
plugins/perl-func/ChangeLog | 4 +
plugins/perl-loader/ChangeLog | 4 +
plugins/plan-perfect/ChangeLog | 4 +
plugins/psiconv/ChangeLog | 4 +
plugins/py-func/ChangeLog | 4 +
plugins/python-loader/ChangeLog | 4 +
plugins/qpro/ChangeLog | 4 +
plugins/sample_datasource/ChangeLog | 4 +
plugins/sc/ChangeLog | 4 +
plugins/sylk/ChangeLog | 4 +
plugins/uihello/ChangeLog | 4 +
plugins/xbase/ChangeLog | 4 +
po-functions/ChangeLog | 4 +
po/ChangeLog | 4 +
src/dialogs/ChangeLog | 4 +
src/tools/ChangeLog | 4 +
src/widgets/ChangeLog | 4 +
test/ChangeLog | 4 +
tools/ChangeLog | 4 +
62 files changed, 708 insertions(+), 462 deletions(-)
---
diff --git a/ChangeLog b/ChangeLog
index 0201a82..9db69db 100644
--- a/ChangeLog
+++ b/ChangeLog
@@ -1,3 +1,7 @@
+2010-06-16 Morten Welinder <terra gnome org>
+
+ * Release 1.10.6
+
2010-06-16 Andreas J. Guelzow <aguelzow pyrshep ca>
* src/func.h (gnm_func_convert_markup_to_pango): new
diff --git a/doc/C/ChangeLog b/doc/C/ChangeLog
index 796b522..41aba48 100644
--- a/doc/C/ChangeLog
+++ b/doc/C/ChangeLog
@@ -1,3 +1,7 @@
+2010-06-16 Morten Welinder <terra gnome org>
+
+ * Release 1.10.6
+
2010-05-30 Morten Welinder <terra gnome org>
* Release 1.10.5
diff --git a/doc/C/func.defs b/doc/C/func.defs
index 3ce1751..5ef77ae 100644
--- a/doc/C/func.defs
+++ b/doc/C/func.defs
@@ -47,11 +47,11 @@
@CATEGORY=Complex
@FUNCTION=COMPLEX
- SHORTDESC=a complex number of the form @{x} + @{y} {i}
+ SHORTDESC=a complex number of the form @{x} + @{y} {i}
@SYNTAX=COMPLEX(x,y,i)
@ARGUMENTDESCRIPTION= {x}: real part
@{y}: imaginary part
- {i}: the suffix for the complex number, either "i" or "j"; defaults to "i".
+ {i}: the suffix for the complex number, either "i" or "j"; defaults to "i"
@NOTE=If @{i} is neither "i" nor "j", COMPLEX returns #VALUE!
@EXCEL=This function is Excel compatible.
@@ -308,7 +308,7 @@ The natural logarithm is not uniquely defined on complex numbers. You may need t
@CATEGORY=Complex
@FUNCTION=IMPOWER
- SHORTDESC= the complex number @{z1} raised to the @{z2}th power
+ SHORTDESC=the complex number @{z1} raised to the @{z2}th power
@SYNTAX=IMPOWER(z1,z2)
@ARGUMENTDESCRIPTION= {z1}: a complex number
@{z2}: a complex number
@@ -318,7 +318,7 @@ The natural logarithm is not uniquely defined on complex numbers. You may need t
@CATEGORY=Complex
@FUNCTION=IMPRODUCT
- SHORTDESC=the product of the given complex numbers.
+ SHORTDESC=the product of the given complex numbers
@SYNTAX=IMPRODUCT(z1,z2)
@ARGUMENTDESCRIPTION= {z1}: a complex number
@{z2}: a complex number
@@ -380,7 +380,7 @@ The natural logarithm is not uniquely defined on complex numbers. You may need t
@CATEGORY=Complex
@FUNCTION=IMSUB
- SHORTDESC=the difference of two complex numbers.
+ SHORTDESC=the difference of two complex numbers
@SYNTAX=IMSUB(z1,z2)
@ARGUMENTDESCRIPTION= {z1}: a complex number
@{z2}: a complex number
@@ -751,7 +751,7 @@ The natural logarithm is not uniquely defined on complex numbers. You may need t
@FUNCTION=HOUR
@SHORTDESC=compute hour part of fractional day
@SYNTAX=HOUR(time)
- ARGUMENTDESCRIPTION=@{time}: time of day as fractional day.
+ ARGUMENTDESCRIPTION=@{time}: time of day as fractional day
@DESCRIPTION=The HOUR function computes the hour part of the fractional day given by @{time}.
@EXCEL=This function is Excel compatible.
@SEEALSO=TIME,MINUTE,SECOND
@@ -778,7 +778,7 @@ The natural logarithm is not uniquely defined on complex numbers. You may need t
@FUNCTION=MINUTE
@SHORTDESC=compute minute part of fractional day
@SYNTAX=MINUTE(time)
- ARGUMENTDESCRIPTION=@{time}: time of day as fractional day.
+ ARGUMENTDESCRIPTION=@{time}: time of day as fractional day
@DESCRIPTION=The MINUTE function computes the minute part of the fractional day given by @{time}.
@EXCEL=This function is Excel compatible.
@SEEALSO=TIME,HOUR,SECOND
@@ -823,7 +823,7 @@ The natural logarithm is not uniquely defined on complex numbers. You may need t
@FUNCTION=SECOND
@SHORTDESC=compute seconds part of fractional day
@SYNTAX=SECOND(time)
- ARGUMENTDESCRIPTION=@{time}: time of day as fractional day.
+ ARGUMENTDESCRIPTION=@{time}: time of day as fractional day
@DESCRIPTION=The SECOND function computes the seconds part of the fractional day given by @{time}.
@EXCEL=This function is Excel compatible.
@SEEALSO=TIME,HOUR,MINUTE
@@ -978,7 +978,7 @@ The natural logarithm is not uniquely defined on complex numbers. You may need t
@CATEGORY=Engineering
@FUNCTION=BIN2HEX
- SHORTDESC= hexadecimal representation of the binary number @{x}
+ SHORTDESC=hexadecimal representation of the binary number @{x}
@SYNTAX=BIN2HEX(x,places)
@ARGUMENTDESCRIPTION= {x}: a binary number, either as a string or as a number involving only the digits 0 and 1
@{places}: number of digits
@@ -988,7 +988,7 @@ The natural logarithm is not uniquely defined on complex numbers. You may need t
@CATEGORY=Engineering
@FUNCTION=BIN2OCT
- SHORTDESC= octal representation of the binary number @{x}
+ SHORTDESC=octal representation of the binary number @{x}
@SYNTAX=BIN2OCT(x,places)
@ARGUMENTDESCRIPTION= {x}: a binary number, either as a string or as a number involving only the digits 0 and 1
@{places}: number of digits
@@ -1100,7 +1100,7 @@ For metric units any of the following prefixes can be used:
@CATEGORY=Engineering
@FUNCTION=DEC2BIN
- SHORTDESC= binary representation of the decimal number @{x}
+ SHORTDESC=binary representation of the decimal number @{x}
@SYNTAX=DEC2BIN(x,places)
@ARGUMENTDESCRIPTION= {x}: integer
@{places}: number of digits
@@ -1110,7 +1110,7 @@ For metric units any of the following prefixes can be used:
@CATEGORY=Engineering
@FUNCTION=DEC2HEX
- SHORTDESC= hexadecimal representation of the decimal number @{x}
+ SHORTDESC=hexadecimal representation of the decimal number @{x}
@SYNTAX=DEC2HEX(x,places)
@ARGUMENTDESCRIPTION= {x}: integer
@{places}: number of digits
@@ -1120,7 +1120,7 @@ For metric units any of the following prefixes can be used:
@CATEGORY=Engineering
@FUNCTION=DEC2OCT
- SHORTDESC= octal representation of the decimal number @{x}
+ SHORTDESC=octal representation of the decimal number @{x}
@SYNTAX=DEC2OCT(x,places)
@ARGUMENTDESCRIPTION= {x}: integer
@{places}: number of digits
@@ -1168,7 +1168,7 @@ For metric units any of the following prefixes can be used:
@CATEGORY=Engineering
@FUNCTION=GESTEP
- SHORTDESC=Step function with step at @{x1} evaluated at @{x0}
+ SHORTDESC=step function with step at @{x1} evaluated at @{x0}
@SYNTAX=GESTEP(x0,x1)
@ARGUMENTDESCRIPTION= {x0}: number
@{x1}: number, defaults to 0
@@ -1285,16 +1285,19 @@ If any argument is zero, the result is zero.
@CATEGORY=Finance
@FUNCTION=ACCRINT
@SHORTDESC=accrued interest
- SYNTAX=ACCRINT(issue,first_interest,settlement,rate,par,frequency,basis)
+ SYNTAX=ACCRINT(issue,first_interest,settlement,rate,par,frequency,basis,calc_method)
@ARGUMENTDESCRIPTION= {issue}: date of issue
@{first_interest}: date of first interest payment
@{settlement}: settlement date
@{rate}: nominal annual interest rate
- {par}: par value
+ {par}: par value, defaults to $1000
@{frequency}: number of interest payments per year
- {basis}: calendar basis
- DESCRIPTION=ACCRINT calculates the accrued interest for a security that pays periodic interest.
- NOTE=@{par} defaults to $1000. @{frequency} may be 1 (annual), 2 (semi-annual), or 4 (quarterly). If @{basis} is 0, then the US 30/360 method is used. If @{basis} is 1, then actual number of days is used. If @{basis} is 2, then actual number of days is used within a month, but years are considered only 360 days. If @{basis} is 3, then actual number of days is used within a month, but years are always considered 365 days. If @{basis} is 4, then the European 30/360 method is used.
+ {basis}: calendar basis, defaults to 0
+ {calc_method}: calculation method, defaults to TRUE
+ DESCRIPTION=If @{first_interest} < @{settlement} and @{calc_method} is TRUE, then ACCRINT returns the sum of the interest accrued in all coupon periods from @{issue} date until @{settlement} date.
+If @{first_interest} < @{settlement} and @{calc_method} is FALSE, then ACCRINT returns the sum of the interest accrued in all coupon periods from @{first_interest} date until @{settlement} date.
+Otherwise ACCRINT returns the sum of the interest accrued in all coupon periods from @{issue} date until @{settlement} date.
+ NOTE=@{frequency} must be one of 1, 2 or 4, but the exact value does not affect the result. @{issue} must precede both @{first_interest} and @{settlement}. @{frequency} may be 1 (annual), 2 (semi-annual), or 4 (quarterly). If @{basis} is 0, then the US 30/360 method is used. If @{basis} is 1, then actual number of days is used. If @{basis} is 2, then actual number of days is used within a month, but years are considered only 360 days. If @{basis} is 3, then actual number of days is used within a month, but years are always considered 365 days. If @{basis} is 4, then the European 30/360 method is used.
@SEEALSO=ACCRINTM
@CATEGORY=Finance
@@ -1549,10 +1552,10 @@ If any argument is zero, the result is zero.
@ARGUMENTDESCRIPTION= {n}: amount
@{source}: three-letter source currency code
@{target}: three-letter target currency code
- {full_precision}: if true, the result is not rounded; if false the result is rounded to 0 or 2 decimals depending on the target currency; defaults to false.
- {triangulation_precision}: number of digits (at least 3) to be rounded to after the source currency has been converted to euro; omitting this argument results in no rounding.
+ {full_precision}: whether to provide the full precision; defaults to false
+ {triangulation_precision}: number of digits (at least 3) to be rounded to after conversion of the source currency to euro; defaults to no rounding
@DESCRIPTION=EUROCONVERT converts @{n} units of currency @{source} to currency @{target}. The rates used are the official ones used on the introduction of the Euro.
- NOTE=@{source} and @{target} must be one of the currencies listed for the EURO function. This function is not likely to be useful anymore.
+ NOTE=If @{full_precision} is true, the result is not rounded; if it false the result is rounded to 0 or 2 decimals depending on the target currency; defaults to false. @{source} and @{target} must be one of the currencies listed for the EURO function. This function is not likely to be useful anymore.
@SEEALSO=EURO
@CATEGORY=Finance
@@ -1945,7 +1948,7 @@ If any argument is zero, the result is zero.
@SHORTDESC=theoretical price of a complex chooser option
@SYNTAX=OPT_COMPLEX_CHOOSER(spot,strike_call,strike_put,time,time_call,time_put,rate,cost_of_carry,volatility)
@ARGUMENTDESCRIPTION= {spot}: spot price
- {strike_call}: strike price, if exercised as a call option.
+ {strike_call}: strike price, if exercised as a call option
@{strike_put}: strike price, if exercised as a put option
@{time}: time in years until the holder chooses a put or a call option
@{time_call}: time in years to maturity of the call option if chosen
@@ -2117,16 +2120,16 @@ If any argument is zero, the result is zero.
@FUNCTION=OPT_ON_OPTIONS
@SHORTDESC=theoretical price of options on options
@SYNTAX=OPT_ON_OPTIONS(type_flag,spot,strike1,strike2,time1,time2,rate,cost_of_carry,volatility)
- ARGUMENTDESCRIPTION=@{type_flag}: 'cc' for calls on calls, 'cp' for calls on puts, and so on for 'pc', and 'pp'.
+ ARGUMENTDESCRIPTION=@{type_flag}: 'cc' for calls on calls, 'cp' for calls on puts, and so on for 'pc', and 'pp'
@{spot}: spot price
@{strike1}: strike price at which the option being valued is struck
@{strike2}: strike price at which the underlying option is struck
@{time1}: time in years to maturity of the option
@{time2}: time in years to the maturity of the underlying option
@{rate}: annualized risk-free interest rate
- {cost_of_carry}: net cost of holding the underlying asset of the underlying option (for common stocks, the risk free rate less the dividend yield)
+ {cost_of_carry}: net cost of holding the underlying asset of the underlying option
@{volatility}: annualized volatility in price of the underlying asset of the underlying option
- NOTE=@{time2} â?¥ @{time1}
+ NOTE=For common stocks, @{cost_of_carry} is the risk free rate less the dividend yield. @{time2} â?¥ @{time1}
@SEEALSO=OPT_BS,OPT_BS_DELTA,OPT_BS_RHO,OPT_BS_THETA,OPT_BS_GAMMA
@CATEGORY=Finance
@@ -2520,7 +2523,7 @@ If any argument is zero, the result is zero.
@CATEGORY=Information
@FUNCTION=GET.FORMULA
- SHORTDESC=The formula in @{cell} as a string.
+ SHORTDESC=the formula in @{cell} as a string
@SYNTAX=GET.FORMULA(cell)
@ARGUMENTDESCRIPTION= {cell}: the referenced cell
@ODF=GET.FORMULA is the OpenFormula function FORMULA.
@@ -2528,7 +2531,7 @@ If any argument is zero, the result is zero.
@CATEGORY=Information
@FUNCTION=GET.LINK
- SHORTDESC=The target of the hyperlink attached to @{cell} as a string.
+ SHORTDESC=the target of the hyperlink attached to @{cell} as a string
@SYNTAX=GET.LINK(cell)
@ARGUMENTDESCRIPTION= {cell}: the referenced cell
@NOTE=The value return is not updated automatically when the link attached to @{cell} changes but requires a recalculation.
@@ -2560,7 +2563,7 @@ If any argument is zero, the result is zero.
@CATEGORY=Information
@FUNCTION=ISBLANK
- SHORTDESC=TRUE if @{value} is blank.
+ SHORTDESC=TRUE if @{value} is blank
@SYNTAX=ISBLANK(value)
@ARGUMENTDESCRIPTION= {value}: a value
@DESCRIPTION=This function checks if a value is blank. Empty cells are blank, but empty strings are not.
@@ -2584,7 +2587,7 @@ If any argument is zero, the result is zero.
@CATEGORY=Information
@FUNCTION=ISEVEN
- SHORTDESC=TRUE if @{n} is even.
+ SHORTDESC=TRUE if @{n} is even
@SYNTAX=ISEVEN(n)
@ARGUMENTDESCRIPTION= {n}: number
@EXCEL=This function is Excel compatible.
@@ -2592,7 +2595,7 @@ If any argument is zero, the result is zero.
@CATEGORY=Information
@FUNCTION=ISFORMULA
- SHORTDESC=TRUE if @{cell} contains a formula.
+ SHORTDESC=TRUE if @{cell} contains a formula
@SYNTAX=ISFORMULA(cell)
@ARGUMENTDESCRIPTION= {cell}: the referenced cell
@ODF=ISFORMULA is OpenFormula compatible.
@@ -2600,7 +2603,7 @@ If any argument is zero, the result is zero.
@CATEGORY=Information
@FUNCTION=ISLOGICAL
- SHORTDESC=TRUE if @{value} is a logical value.
+ SHORTDESC=TRUE if @{value} is a logical value
@SYNTAX=ISLOGICAL(value)
@ARGUMENTDESCRIPTION= {value}: a value
@DESCRIPTION=This function checks if a value is either TRUE or FALSE.
@@ -2608,7 +2611,7 @@ If any argument is zero, the result is zero.
@CATEGORY=Information
@FUNCTION=ISNA
- SHORTDESC=TRUE if @{value} is the #N/A error value.
+ SHORTDESC=TRUE if @{value} is the #N/A error value
@SYNTAX=ISNA(value)
@ARGUMENTDESCRIPTION= {value}: a value
@EXCEL=This function is Excel compatible.
@@ -2616,7 +2619,7 @@ If any argument is zero, the result is zero.
@CATEGORY=Information
@FUNCTION=ISNONTEXT
- SHORTDESC=TRUE if @{value} is not text.
+ SHORTDESC=TRUE if @{value} is not text
@SYNTAX=ISNONTEXT(value)
@ARGUMENTDESCRIPTION= {value}: a value
@EXCEL=This function is Excel compatible.
@@ -2624,7 +2627,7 @@ If any argument is zero, the result is zero.
@CATEGORY=Information
@FUNCTION=ISNUMBER
- SHORTDESC=TRUE if @{value} is a number.
+ SHORTDESC=TRUE if @{value} is a number
@SYNTAX=ISNUMBER(value)
@ARGUMENTDESCRIPTION= {value}: a value
@DESCRIPTION=This function checks if a value is a number. Neither TRUE nor FALSE are numbers for this purpose.
@@ -2632,7 +2635,7 @@ If any argument is zero, the result is zero.
@CATEGORY=Information
@FUNCTION=ISODD
- SHORTDESC=TRUE if @{n} is odd.
+ SHORTDESC=TRUE if @{n} is odd
@SYNTAX=ISODD(n)
@ARGUMENTDESCRIPTION= {n}: number
@EXCEL=This function is Excel compatible.
@@ -2640,7 +2643,7 @@ If any argument is zero, the result is zero.
@CATEGORY=Information
@FUNCTION=ISREF
- SHORTDESC=TRUE if @{value} is a reference.
+ SHORTDESC=TRUE if @{value} is a reference
@SYNTAX=ISREF(value)
@ARGUMENTDESCRIPTION= {value}: a value
@DESCRIPTION=This function checks if a value is a cell reference.
@@ -2648,7 +2651,7 @@ If any argument is zero, the result is zero.
@CATEGORY=Information
@FUNCTION=ISTEXT
- SHORTDESC=TRUE if @{value} is text.
+ SHORTDESC=TRUE if @{value} is text
@SYNTAX=ISTEXT(value)
@ARGUMENTDESCRIPTION= {value}: a value
@EXCEL=This function is Excel compatible.
@@ -2695,7 +2698,7 @@ If any argument is zero, the result is zero.
@CATEGORY=Logic
@FUNCTION=FALSE
- SHORTDESC=the value FALSE.
+ SHORTDESC=the value FALSE
@SYNTAX=FALSE()
@DESCRIPTION=FALSE returns the value FALSE.
@EXCEL=This function is Excel compatible.
@@ -2703,29 +2706,29 @@ If any argument is zero, the result is zero.
@CATEGORY=Logic
@FUNCTION=IF
- SHORTDESC=conditional expression.
+ SHORTDESC=conditional expression
@SYNTAX=IF(cond,trueval,falseval)
- ARGUMENTDESCRIPTION=@{cond}: condition.
- {trueval}: value to use if condition is true.
- {falseval}: value to use if condition is false.
+ ARGUMENTDESCRIPTION=@{cond}: condition
+ {trueval}: value to use if condition is true
+ {falseval}: value to use if condition is false
@DESCRIPTION=This function first evaluates the condition. If the result is true, it will then evaluate and return the second argument. Otherwise, it will evaluate and return the last argument.
@SEEALSO=AND,OR,XOR,NOT,IFERROR
@CATEGORY=Logic
@FUNCTION=IFERROR
- SHORTDESC=Test for error.
+ SHORTDESC=test for error
@SYNTAX=IFERROR(x,y)
- ARGUMENTDESCRIPTION=@{x}: value to test for error.
- {y}: alternate value.
+ ARGUMENTDESCRIPTION=@{x}: value to test for error
+ {y}: alternate value
@DESCRIPTION=This function returns the first value, unless that is an error, in which case it returns the second.
@SEEALSO=IF,ISERROR
@CATEGORY=Logic
@FUNCTION=IFNA
- SHORTDESC=Test for #NA! error.
+ SHORTDESC=test for #NA! error
@SYNTAX=IFNA(x,y)
- ARGUMENTDESCRIPTION=@{x}: value to test for #NA! error.
- {y}: alternate value.
+ ARGUMENTDESCRIPTION=@{x}: value to test for #NA! error
+ {y}: alternate value
@DESCRIPTION=This function returns the first value, unless that is #NA!, in which case it returns the second.
@SEEALSO=IF,ISERROR
@@ -2752,7 +2755,7 @@ If any argument is zero, the result is zero.
@CATEGORY=Logic
@FUNCTION=TRUE
- SHORTDESC=the value TRUE.
+ SHORTDESC=the value TRUE
@SYNTAX=TRUE()
@DESCRIPTION=TRUE returns the value TRUE.
@EXCEL=This function is Excel compatible.
@@ -2848,7 +2851,7 @@ If any argument is zero, the result is zero.
@FUNCTION=INDEX
@SHORTDESC=reference to a cell in the given @{array}
@SYNTAX=INDEX(array,row,col,area)
- ARGUMENTDESCRIPTION=@{array}:
+ ARGUMENTDESCRIPTION=@{array}: cell or inline array
@{row}: desired row, defaults to 1
@{col}: desired column, defaults to 1
@{area}: from which area to select a cell, defaults to 1
@@ -2859,7 +2862,7 @@ If any argument is zero, the result is zero.
@FUNCTION=INDIRECT
@SHORTDESC=contents of the cell pointed to by the @{ref_text} string
@SYNTAX=INDIRECT(ref_text,format)
- ARGUMENTDESCRIPTION=@{ref_text}:
+ ARGUMENTDESCRIPTION=@{ref_text}: textual reference
@{format}: if true, @{ref_text} is given in A1-style, otherwise it is given in R1C1 style; defaults to true
@NOTE=If @{ref_text} is not a valid reference in the style determined by @{format}, INDIRECT returns #REF!
@SEEALSO=AREAS,INDEX,CELL
@@ -2979,21 +2982,21 @@ If any argument is zero, the result is zero.
@CATEGORY=Mathematics
@FUNCTION=ACOT
- SHORTDESC=inverse cotangent of a value
+ SHORTDESC=inverse cotangent of @{x}
@SYNTAX=ACOT(x)
@ARGUMENTDESCRIPTION= {x}: value
@SEEALSO=COT,TAN
@CATEGORY=Mathematics
@FUNCTION=ACOTH
- SHORTDESC=inverse hyperbolic cotangent of a value
+ SHORTDESC=the inverse hyperbolic cotangent of @{x}
@SYNTAX=ACOTH(x)
@ARGUMENTDESCRIPTION= {x}: number
@SEEALSO=COTH,TANH
@CATEGORY=Mathematics
@FUNCTION=ARABIC
- SHORTDESC=The Roman numeral @{roman} as number
+ SHORTDESC=the Roman numeral @{roman} as number
@SYNTAX=ARABIC(roman)
@ARGUMENTDESCRIPTION= {roman}: Roman numeral
@DESCRIPTION=Any Roman symbol to the left of a larger symbol (directly or indirectly) reduces the final value by the symbol amount, otherwise, it increases the final amount by the symbol's amount.
@@ -3030,7 +3033,7 @@ If any argument is zero, the result is zero.
@CATEGORY=Mathematics
@FUNCTION=ATAN2
- SHORTDESC=arc tangent of the ratio of @{y} and @{x}
+ SHORTDESC=the arc tangent of the ratio of @{y} and @{x}
@SYNTAX=ATAN2(y,x)
@ARGUMENTDESCRIPTION= {y}: y-coordinate
@{x}: x-coordinate
@@ -3054,8 +3057,8 @@ If any argument is zero, the result is zero.
@SHORTDESC=average of the cells in @{actual range} for which the corresponding cells in the range meet the given @{criteria}
@SYNTAX=AVERAGEIF(range,criteria,actual_range)
@ARGUMENTDESCRIPTION= {range}: cell area
- {criteria}: condition for a cell to be included
- {actual_range}: cell area, defaults to @{range}
+ {criteria}: condition for a cell to be included
+ {actual_range}: cell area, defaults to @{range}
@EXCEL=This function is Excel compatible.
@SEEALSO=SUMIF,COUNTIF
@@ -3071,7 +3074,7 @@ If any argument is zero, the result is zero.
@CATEGORY=Mathematics
@FUNCTION=BETALN
- SHORTDESC=Natural logarithm of the absolute value of the Euler beta function
+ SHORTDESC=natural logarithm of the absolute value of the Euler beta function
@SYNTAX=BETALN(x,y)
@ARGUMENTDESCRIPTION= {x}: number
@{y}: number
@@ -3110,7 +3113,7 @@ If any argument is zero, the result is zero.
@CATEGORY=Mathematics
@FUNCTION=COMBIN
- SHORTDESC=Binomial coefficient
+ SHORTDESC=binomial coefficient
@SYNTAX=COMBIN(n,k)
@ARGUMENTDESCRIPTION= {n}: non-negative integer
@{k}: non-negative integer
@@ -3130,7 +3133,7 @@ If any argument is zero, the result is zero.
@CATEGORY=Mathematics
@FUNCTION=COS
- SHORTDESC=Cosine function
+ SHORTDESC=the cosine of @{x}
@SYNTAX=COS(x)
@ARGUMENTDESCRIPTION= {x}: angle in radians
@DESCRIPTION=This function is Excel compatible.
@@ -3138,7 +3141,7 @@ If any argument is zero, the result is zero.
@CATEGORY=Mathematics
@FUNCTION=COSH
- SHORTDESC=Hyperbolic cosine function
+ SHORTDESC=the hyperbolic cosine of @{x}
@SYNTAX=COSH(x)
@ARGUMENTDESCRIPTION= {x}: number
@EXCEL=This function is Excel compatible.
@@ -3146,14 +3149,14 @@ If any argument is zero, the result is zero.
@CATEGORY=Mathematics
@FUNCTION=COT
- SHORTDESC=cotangent of a value
+ SHORTDESC=the cotangent of @{x}
@SYNTAX=COT(x)
@ARGUMENTDESCRIPTION= {x}: number
@SEEALSO=TAN,ACOT
@CATEGORY=Mathematics
@FUNCTION=COTH
- SHORTDESC=hyperbolic cotangent of a value
+ SHORTDESC=the hyperbolic cotangent of @{x}
@SYNTAX=COTH(x)
@ARGUMENTDESCRIPTION= {x}: number
@SEEALSO=TANH,ACOTH
@@ -3163,13 +3166,13 @@ If any argument is zero, the result is zero.
@SHORTDESC=count of the cells meeting the given @{criteria}
@SYNTAX=COUNTIF(range,criteria)
@ARGUMENTDESCRIPTION= {range}: cell area
- {criteria}: condition for a cell to be counted
+ {criteria}: condition for a cell to be counted
@EXCEL=This function is Excel compatible.
@SEEALSO=COUNT,SUMIF
@CATEGORY=Mathematics
@FUNCTION=CSC
- SHORTDESC=Cosecant
+ SHORTDESC=the cosecant of @{x}
@SYNTAX=CSC(x)
@ARGUMENTDESCRIPTION= {x}: angle in radians
@EXCEL=This function is not Excel compatible.
@@ -3178,7 +3181,7 @@ If any argument is zero, the result is zero.
@CATEGORY=Mathematics
@FUNCTION=CSCH
- SHORTDESC=Hyperbolic cosecant
+ SHORTDESC=the hyperbolic cosecant of @{x}
@SYNTAX=CSCH(x)
@ARGUMENTDESCRIPTION= {x}: number
@EXCEL=This function is not Excel compatible.
@@ -3187,7 +3190,7 @@ If any argument is zero, the result is zero.
@CATEGORY=Mathematics
@FUNCTION=DEGREES
- SHORTDESC=Equivalent degrees to @{x} radians.
+ SHORTDESC=equivalent degrees to @{x} radians
@SYNTAX=DEGREES(x)
@ARGUMENTDESCRIPTION= {x}: angle in radians
@EXCEL=This function is Excel compatible.
@@ -3202,7 +3205,7 @@ If any argument is zero, the result is zero.
@CATEGORY=Mathematics
@FUNCTION=EVEN
- SHORTDESC= @{x} rounded away from 0 to the next even integer
+ SHORTDESC=@{x} rounded away from 0 to the next even integer
@SYNTAX=EVEN(x)
@ARGUMENTDESCRIPTION= {x}: number
@EXCEL=This function is Excel compatible.
@@ -3253,9 +3256,9 @@ If any argument is zero, the result is zero.
@CATEGORY=Mathematics
@FUNCTION=FLOOR
- SHORTDESC=nearest multiple of @{significance} whose absolute value is at most ABS(@{x}).
+ SHORTDESC=nearest multiple of @{significance} whose absolute value is at most ABS(@{x})
@SYNTAX=FLOOR(x,significance)
- ARGUMENTDESCRIPTION=@{x}: number.
+ ARGUMENTDESCRIPTION=@{x}: number
@{significance}: base multiple (defaults to 1 for @{x} > 0 and -1 for @{x} <0)
@DESCRIPTION=FLOOR(@{x},@{significance}) is the nearest multiple of @{significance} whose absolute value is at most ABS(@{x})
@EXCEL=This function is Excel compatible.
@@ -3280,7 +3283,7 @@ If any argument is zero, the result is zero.
@CATEGORY=Mathematics
@FUNCTION=GAMMALN
- SHORTDESC=natural logarithm of the Gamma function.
+ SHORTDESC=natural logarithm of the Gamma function
@SYNTAX=GAMMALN(x)
@ARGUMENTDESCRIPTION= {x}: number
@EXCEL=This function is Excel compatible.
@@ -3306,7 +3309,7 @@ If any argument is zero, the result is zero.
@CATEGORY=Mathematics
@FUNCTION=HYPOT
- SHORTDESC=the square root of the sum of the squares of the arguments.
+ SHORTDESC=the square root of the sum of the squares of the arguments
@SYNTAX=HYPOT(n0,n1)
@ARGUMENTDESCRIPTION= {n0}: number
@{n1}: number
@@ -3314,7 +3317,7 @@ If any argument is zero, the result is zero.
@CATEGORY=Mathematics
@FUNCTION=INT
- SHORTDESC= largest integer not larger than @{x}
+ SHORTDESC=largest integer not larger than @{x}
@SYNTAX=INT(x)
@ARGUMENTDESCRIPTION= {x}: number
@EXCEL=This function is Excel compatible.
@@ -3333,7 +3336,7 @@ If any argument is zero, the result is zero.
@CATEGORY=Mathematics
@FUNCTION=LN
- SHORTDESC=the natural logarithm of @{x}.
+ SHORTDESC=the natural logarithm of @{x}
@SYNTAX=LN(x)
@ARGUMENTDESCRIPTION= {x}: positive number
@NOTE=If @{x} â?¤ 0, LN returns #NUM! error.
@@ -3352,7 +3355,7 @@ If any argument is zero, the result is zero.
@CATEGORY=Mathematics
@FUNCTION=LOG
- SHORTDESC=Logarithm
+ SHORTDESC=logarithm of @{x} with base @{base}
@SYNTAX=LOG(x,base)
@ARGUMENTDESCRIPTION= {x}: positive number
@{base}: base of the logarithm, defaults to 10
@@ -3362,7 +3365,7 @@ If any argument is zero, the result is zero.
@CATEGORY=Mathematics
@FUNCTION=LOG10
- SHORTDESC=the base-10 logarithm of @{x}.
+ SHORTDESC=the base-10 logarithm of @{x}
@SYNTAX=LOG10(x)
@ARGUMENTDESCRIPTION= {x}: positive number
@NOTE=If @{x} â?¤ 0, LOG10 returns #NUM!
@@ -3370,7 +3373,7 @@ If any argument is zero, the result is zero.
@CATEGORY=Mathematics
@FUNCTION=LOG2
- SHORTDESC=the base-2 logarithm of @{x}.
+ SHORTDESC=the base-2 logarithm of @{x}
@SYNTAX=LOG2(x)
@ARGUMENTDESCRIPTION= {x}: positive number
@NOTE=If @{x} â?¤ 0, LOG2 returns #NUM!
@@ -3404,7 +3407,7 @@ If any argument is zero, the result is zero.
@CATEGORY=Mathematics
@FUNCTION=MOD
- SHORTDESC= the remainder of @{x} under division by @{n}
+ SHORTDESC=the remainder of @{x} under division by @{n}
@SYNTAX=MOD(x,n)
@ARGUMENTDESCRIPTION= {x}: integer
@{n}: integer
@@ -3425,7 +3428,7 @@ If any argument is zero, the result is zero.
@CATEGORY=Mathematics
@FUNCTION=MULTINOMIAL
- SHORTDESC=Multinomial coefficient (@{x1}+â?¯+ {xn}) choose (@{x1},...,@{xn})
+ SHORTDESC=multinomial coefficient (@{x1}+â?¯+ {xn}) choose (@{x1},â?¦,@{xn})
@SYNTAX=MULTINOMIAL(x1,x2,xn)
@ARGUMENTDESCRIPTION= {x1}: first number
@{x2}: second number
@@ -3443,7 +3446,7 @@ If any argument is zero, the result is zero.
@CATEGORY=Mathematics
@FUNCTION=ODD
- SHORTDESC= @{x} rounded away from 0 to the next odd integer
+ SHORTDESC=@{x} rounded away from 0 to the next odd integer
@SYNTAX=ODD(x)
@ARGUMENTDESCRIPTION= {x}: number
@EXCEL=This function is Excel compatible.
@@ -3458,7 +3461,7 @@ If any argument is zero, the result is zero.
@CATEGORY=Mathematics
@FUNCTION=POWER
- SHORTDESC=the value of @{x} raised to the power @{y}.
+ SHORTDESC=the value of @{x} raised to the power @{y}
@SYNTAX=POWER(x,y)
@ARGUMENTDESCRIPTION= {x}: number
@{y}: number
@@ -3490,7 +3493,7 @@ QUOTIENT (@{numerator},@{denominator})� {denominator}+MOD(@{numerator},@{denom
@CATEGORY=Mathematics
@FUNCTION=RADIANS
- SHORTDESC=the number of radians equivalent to @{x} degrees.
+ SHORTDESC=the number of radians equivalent to @{x} degrees
@SYNTAX=RADIANS(x)
@ARGUMENTDESCRIPTION= {x}: angle in degrees
@EXCEL=This function is Excel compatible.
@@ -3521,7 +3524,7 @@ If @{d} is less than zero, @{x} is rounded to the left of the decimal point
@CATEGORY=Mathematics
@FUNCTION=ROUNDDOWN
- SHORTDESC=@{x} rounded towards 0.
+ SHORTDESC=@{x} rounded towards 0
@SYNTAX=ROUNDDOWN(x,d)
@ARGUMENTDESCRIPTION= {x}: number
@{d}: integer, defaults to 0
@@ -3533,7 +3536,7 @@ If @{d} is less than zero, @{x} is rounded toward 0 to the left of the decimal p
@CATEGORY=Mathematics
@FUNCTION=ROUNDUP
- SHORTDESC=@{x} rounded away from 0.
+ SHORTDESC=@{x} rounded away from 0
@SYNTAX=ROUNDUP(x,d)
@ARGUMENTDESCRIPTION= {x}: number
@{d}: integer, defaults to 0
@@ -3554,7 +3557,7 @@ If @{d} is less than zero, @{x} is rounded away from 0 to the left of the decima
@CATEGORY=Mathematics
@FUNCTION=SECH
- SHORTDESC=Hyperbolic secant
+ SHORTDESC=the hyperbolic secant of @{x}
@SYNTAX=SECH(x)
@ARGUMENTDESCRIPTION= {x}: number
@EXCEL=This function is not Excel compatible.
@@ -3583,7 +3586,7 @@ If @{d} is less than zero, @{x} is rounded away from 0 to the left of the decima
@CATEGORY=Mathematics
@FUNCTION=SIN
- SHORTDESC=Sine function
+ SHORTDESC=the sine of @{x}
@SYNTAX=SIN(x)
@ARGUMENTDESCRIPTION= {x}: angle in radians
@EXCEL=This function is Excel compatible.
@@ -3638,14 +3641,14 @@ If @{d} is less than zero, @{x} is rounded away from 0 to the left of the decima
@SHORTDESC=sum of the cells in @{actual_range} for which the corresponding cells in the range meet the given @{criteria}
@SYNTAX=SUMIF(range,criteria,actual_range)
@ARGUMENTDESCRIPTION= {range}: cell area
- {criteria}: condition for a cell to be summed
- {actual_range}: cell area, defaults to @{range}
+ {criteria}: condition for a cell to be summed
+ {actual_range}: cell area, defaults to @{range}
@EXCEL=This function is Excel compatible.
@SEEALSO=SUM,COUNTIF
@CATEGORY=Mathematics
@FUNCTION=SUMPRODUCT
- SHORTDESC=Multiplies components and adds the results.
+ SHORTDESC=multiplies components and adds the results
@SYNTAX=SUMPRODUCT()
@DESCRIPTION=Multiplies corresponding data entries in the given arrays or ranges, and then returns the sum of those products.
@NOTE=If an entry is not numeric, the value zero is used instead. If arrays or range arguments do not have the same dimensions, return #VALUE! error. SUMPRODUCTs arguments are arrays or ranges. Attempting to use A1:A5>0 will not work, implicit intersection will kick in. Instead use --(A1:A5>0)
@@ -3662,7 +3665,7 @@ If @{d} is less than zero, @{x} is rounded away from 0 to the left of the decima
@CATEGORY=Mathematics
@FUNCTION=SUMX2MY2
- SHORTDESC= sum of the difference of squares
+ SHORTDESC=sum of the difference of squares
@SYNTAX=SUMX2MY2(array0,array1)
@ARGUMENTDESCRIPTION= {array0}: first cell area
@{array1}: second cell area
@@ -3672,7 +3675,7 @@ If @{d} is less than zero, @{x} is rounded away from 0 to the left of the decima
@CATEGORY=Mathematics
@FUNCTION=SUMX2PY2
- SHORTDESC= sum of the sum of squares
+ SHORTDESC=sum of the sum of squares
@SYNTAX=SUMX2PY2(array0,array1)
@ARGUMENTDESCRIPTION= {array0}: first cell area
@{array1}: second cell area
@@ -3684,7 +3687,7 @@ Strings and empty cells are simply ignored.
@CATEGORY=Mathematics
@FUNCTION=SUMXMY2
- SHORTDESC= sum of the squares of differences
+ SHORTDESC=sum of the squares of differences
@SYNTAX=SUMXMY2(array0,array1)
@ARGUMENTDESCRIPTION= {array0}: first cell area
@{array1}: second cell area
@@ -3696,7 +3699,7 @@ Strings and empty cells are simply ignored.
@CATEGORY=Mathematics
@FUNCTION=TAN
- SHORTDESC=tangent
+ SHORTDESC=the tangent of @{x}
@SYNTAX=TAN(x)
@ARGUMENTDESCRIPTION= {x}: angle in radians
@EXCEL=This function is Excel compatible.
@@ -3704,7 +3707,7 @@ Strings and empty cells are simply ignored.
@CATEGORY=Mathematics
@FUNCTION=TANH
- SHORTDESC=hyperbolic tangent
+ SHORTDESC=the hyperbolic tangent of @{x}
@SYNTAX=TANH(x)
@ARGUMENTDESCRIPTION= {x}: number
@EXCEL=This function is Excel compatible.
@@ -3787,7 +3790,7 @@ Strings and empty cells are simply ignored.
@CATEGORY=Random Numbers
@FUNCTION=RAND
- SHORTDESC=a random number between zero and one.
+ SHORTDESC=a random number between zero and one
@SYNTAX=RAND()
@EXCEL=This function is Excel compatible.
@SEEALSO=RANDBETWEEN
@@ -3982,7 +3985,7 @@ For @{α} = 2, @{β}=0, the Lévy distribution reduces to the normal distributio
@CATEGORY=Random Numbers
@FUNCTION=RANDNORMTAIL
- SHORTDESC=a random variates from the upper tail of a normal distribution with mean 0
+ SHORTDESC=random variate from the upper tail of a normal distribution with mean 0
@SYNTAX=RANDNORMTAIL(a,Ï?)
@ARGUMENTDESCRIPTION= {a}: lower limit of the tail
@{Ï?}: standard deviation of the normal distribution
@@ -4024,7 +4027,7 @@ For @{α} = 2, @{β}=0, the Lévy distribution reduces to the normal distributio
@FUNCTION=RANDSNORM
@SHORTDESC=random variate from a skew normal distribution
@SYNTAX=RANDSNORM(a,μ,Ï?)
- ARGUMENTDESCRIPTION=@{a}: amount of skew, defaults to 0
+ ARGUMENTDESCRIPTION=@{a}: amount of skew, defaults to 0
@{μ}: mean of the underlying normal distribution, defaults to 0
@{Ï?}: standard deviation of the underlying normal distribution, defaults to 1
@NOTE=If @{Ï?} < 0, RANDSNORM returns #NUM!
@@ -4035,7 +4038,7 @@ For @{α} = 2, @{β}=0, the Lévy distribution reduces to the normal distributio
@SHORTDESC=random variate from a skew t distribution
@SYNTAX=RANDSTDIST(df,a)
@ARGUMENTDESCRIPTION= {df}: degrees of freedom
- {a}: amount of skew, defaults to 0
+ {a}: amount of skew, defaults to 0
@SEEALSO=RANDTDIST
@CATEGORY=Random Numbers
@@ -4064,7 +4067,7 @@ For @{α} = 2, @{β}=0, the Lévy distribution reduces to the normal distributio
@CATEGORY=Random Numbers
@FUNCTION=SIMTABLE
- SHORTDESC=one of the values in the given argument list depending on the round number of the simulation tool.
+ SHORTDESC=one of the values in the given argument list depending on the round number of the simulation tool
@SYNTAX=SIMTABLE(d1,d2)
@ARGUMENTDESCRIPTION= {d1}: first value
@{d2}: second value
@@ -4113,7 +4116,7 @@ The successive use of the simulation tool also requires that you give to the too
@FUNCTION=BERNOULLI
@SHORTDESC=probability mass function of a Bernoulli distribution
@SYNTAX=BERNOULLI(k,p)
- ARGUMENTDESCRIPTION=@{k}:
+ ARGUMENTDESCRIPTION=@{k}: integer
@{p}: probability of success
@NOTE=If @{k} != 0 and @{k} != 1 this function returns a #NUM! error. If @{p} < 0 or @{p} > 1 this function returns a #NUM! error.
@SEEALSO=RANDBERNOULLI
@@ -4122,7 +4125,7 @@ The successive use of the simulation tool also requires that you give to the too
@FUNCTION=BETADIST
@SHORTDESC=cumulative distribution function of the beta distribution
@SYNTAX=BETADIST(x,alpha,beta,a,b)
- ARGUMENTDESCRIPTION=@{x}:
+ ARGUMENTDESCRIPTION=@{x}: number
@{alpha}: scale parameter
@{beta}: scale parameter
@{a}: optional lower bound, defaults to 0
@@ -4151,14 +4154,14 @@ The successive use of the simulation tool also requires that you give to the too
@ARGUMENTDESCRIPTION= {trials}: number of trials
@{p}: probability of success in each trial
@{start}: start of the interval
- {end}: start of the interval, defaults to @{start}
+ {end}: end of the interval, defaults to @{start}
@NOTE=If @{start}, @{end} or @{trials} are non-integer they are truncated. If @{trials} < 0 this function returns a #NUM! error. If @{p} < 0 or @{p} > 1 this function returns a #NUM! error. If @{start} > @{end} this function returns 0.
- ODF=This function is the OpenFormula function B
+ ODF=This function is OpenFormula compatible.
@SEEALSO=BINOMDIST,R.PBINOM
@CATEGORY=Statistics
@FUNCTION=BINOMDIST
- SHORTDESC=(cumulative) probability mass function of the binomial distribution
+ SHORTDESC=probability mass of cumulative distribution function of the binomial distribution
@SYNTAX=BINOMDIST(n,trials,p,cumulative)
@ARGUMENTDESCRIPTION= {n}: number of successes
@{trials}: number of trials
@@ -4170,9 +4173,9 @@ The successive use of the simulation tool also requires that you give to the too
@CATEGORY=Statistics
@FUNCTION=CAUCHY
- SHORTDESC=(cumulative) probability density function of the Cauchy, Lorentz or Breit-Wigner distribution
+ SHORTDESC=probability density or cumulative distribution function of the Cauchy, Lorentz or Breit-Wigner distribution
@SYNTAX=CAUCHY(x,a,cumulative)
- ARGUMENTDESCRIPTION=@{x}:
+ ARGUMENTDESCRIPTION=@{x}: number
@{a}: scale parameter
@{cumulative}: whether to evaluate the density function or the cumulative distribution function
@NOTE=If @{a} < 0 this function returns a #NUM! error. If @{cumulative} is neither TRUE nor FALSE this function returns a #VALUE! error.
@@ -4182,7 +4185,7 @@ The successive use of the simulation tool also requires that you give to the too
@FUNCTION=CHIDIST
@SHORTDESC=survival function of the chi-squared distribution
@SYNTAX=CHIDIST(x,dof)
- ARGUMENTDESCRIPTION=@{x}:
+ ARGUMENTDESCRIPTION=@{x}: number
@{dof}: number of degrees of freedom
@DESCRIPTION=The survival function is 1 minus the cumulative distribution function.
@NOTE=If @{dof} is non-integer it is truncated. If @{dof} < 1 this function returns a #NUM! error.
@@ -4283,7 +4286,7 @@ The successive use of the simulation tool also requires that you give to the too
@CATEGORY=Statistics
@FUNCTION=CVMTEST
- SHORTDESC= Cramér-von Mises Test of Normality
+ SHORTDESC=Cramér-von Mises Test of Normality
@SYNTAX=CVMTEST(x)
@ARGUMENTDESCRIPTION= {x}: array of sample values
@DESCRIPTION=This function returns an array with the first row giving the p-value of the Cramér-von Mises Test, the second row the test statistic of the test, and the third the number of observations in the sample.
@@ -4302,9 +4305,9 @@ The successive use of the simulation tool also requires that you give to the too
@CATEGORY=Statistics
@FUNCTION=EXPONDIST
- SHORTDESC=(cumulative)density function of the exponential distribution
+ SHORTDESC=porbaility density or cumulative distribution function of the exponential distribution
@SYNTAX=EXPONDIST(x,y,cumulative)
- ARGUMENTDESCRIPTION=@{x}:
+ ARGUMENTDESCRIPTION=@{x}: number
@{y}: scale parameter
@{cumulative}: whether to evaluate the density function or the cumulative distribution function
@DESCRIPTION=If @{cumulative} is false it will return: @{y} * exp (- {y}*@{x}),otherwise it will return 1 - exp (- {y}*@{x}).
@@ -4314,9 +4317,9 @@ The successive use of the simulation tool also requires that you give to the too
@CATEGORY=Statistics
@FUNCTION=EXPPOWDIST
- SHORTDESC= the probability density function of the Exponential Power distribution
+ SHORTDESC=the probability density function of the Exponential Power distribution
@SYNTAX=EXPPOWDIST(x,a,b)
- ARGUMENTDESCRIPTION=@{x}:
+ ARGUMENTDESCRIPTION=@{x}: number
@{a}: scale parameter
@{b}: scale parameter
@DESCRIPTION=This distribution has been recommended for lifetime analysis when a U-shaped hazard function is desired. This corresponds to rapid failure once the product starts to wear out after a period of steady or even improving reliability.
@@ -4326,7 +4329,7 @@ The successive use of the simulation tool also requires that you give to the too
@FUNCTION=FDIST
@SHORTDESC=survival function of the F distribution
@SYNTAX=FDIST(x,dof_of_num,dof_of_denom)
- ARGUMENTDESCRIPTION=@{x}:
+ ARGUMENTDESCRIPTION=@{x}: number
@{dof_of_num}: numerator degrees of freedom
@{dof_of_denom}: denominator degrees of freedom
@DESCRIPTION=The survival function is 1 minus the cumulative distribution function.
@@ -4352,7 +4355,7 @@ The successive use of the simulation tool also requires that you give to the too
@FUNCTION=FISHER
@SHORTDESC=Fisher transformation
@SYNTAX=FISHER(x)
- ARGUMENTDESCRIPTION=@{x}:
+ ARGUMENTDESCRIPTION=@{x}: number
@NOTE=If @{x} is not a number, this function returns a #VALUE! error. If @{x} <= -1 or @{x} >= 1, this function returns a #NUM! error.
@EXCEL=This function is Excel compatible.
@SEEALSO=FISHERINV,ATANH
@@ -4361,7 +4364,7 @@ The successive use of the simulation tool also requires that you give to the too
@FUNCTION=FISHERINV
@SHORTDESC=inverse of the Fisher transformation
@SYNTAX=FISHERINV(x)
- ARGUMENTDESCRIPTION=@{x}:
+ ARGUMENTDESCRIPTION=@{x}: number
@NOTE=If @{x} is a non-number this function returns a #VALUE! error.
@EXCEL=This function is Excel compatible.
@SEEALSO=FISHER,TANH
@@ -4369,18 +4372,18 @@ The successive use of the simulation tool also requires that you give to the too
@CATEGORY=Statistics
@FUNCTION=FORECAST
@SHORTDESC=estimates a future value according to existing values using simple linear regression
- SYNTAX=FORECAST(x,known_y's,known_x's)
+ SYNTAX=FORECAST(x,known_ys,known_xs)
@ARGUMENTDESCRIPTION= {x}: x-value whose matching y-value should be forecast
- {known_y's}: known y-values
- {known_x's}: known x-values
+ {known_ys}: known y-values
+ {known_xs}: known x-values
@DESCRIPTION=This function estimates a future value according to existing values using simple linear regression.
- NOTE=If @{known_x} or @{known_y} contains no data entries or different number of data entries, this function returns a #N/A error. If the variance of the @{known_x} is zero, this function returns a #DIV/0 error.
+ NOTE=If @{known_xs} or @{known_ys} contains no data entries or different number of data entries, this function returns a #N/A error. If the variance of the @{known_xs} is zero, this function returns a #DIV/0 error.
@EXCEL=This function is Excel compatible.
@SEEALSO=INTERCEPT,TREND
@CATEGORY=Statistics
@FUNCTION=FREQUENCY
- SHORTDESC=the frequency table
+ SHORTDESC=frequency table
@SYNTAX=FREQUENCY(data_array,bins_array)
@ARGUMENTDESCRIPTION= {data_array}: data values
@{bins_array}: array of cutoff values
@@ -4399,9 +4402,9 @@ If the @{bin_array} is empty, this function returns the number of data points in
@CATEGORY=Statistics
@FUNCTION=GAMMADIST
- SHORTDESC=(cumulative) density function of the gamma distribution
+ SHORTDESC=probability density or cumulative distribution function of the gamma distribution
@SYNTAX=GAMMADIST(x,alpha,beta,cumulative)
- ARGUMENTDESCRIPTION=@{x}:
+ ARGUMENTDESCRIPTION=@{x}: number
@{alpha}: scale parameter
@{beta}: scale parameter
@{cumulative}: whether to evaluate the density function or the cumulative distribution function
@@ -4422,7 +4425,7 @@ If the @{bin_array} is empty, this function returns the number of data points in
@CATEGORY=Statistics
@FUNCTION=GEOMDIST
- SHORTDESC=(cumulative) probability mass function of the hypergeometric distribution
+ SHORTDESC=probability mass or cumulative distribution function of the hypergeometric distribution
@SYNTAX=GEOMDIST(k,p,cumulative)
@ARGUMENTDESCRIPTION= {k}: number of trials
@{p}: probability of success in any trial
@@ -4442,15 +4445,15 @@ If the @{bin_array} is empty, this function returns the number of data points in
@CATEGORY=Statistics
@FUNCTION=GROWTH
- SHORTDESC= predicts the exponential growth
- SYNTAX=GROWTH(known_y's,known_x's,new_x's,const)
- ARGUMENTDESCRIPTION=@{known_y's}: known y-values
- {known_x's}: known x-values; if @{known_x}'s is omitted, an array {1, 2, 3, ...} is used.
- {new_x's}: x-values for which you want to estimate the y-values; defaults to @{known_x}'s
- {const}: if this is false the line will be forced to go through the origin; defaults to TRUE
- DESCRIPTION=GROWTH function applies the ``least squares'' method to fit an exponential curve to your data and predicts the exponential growth by using this curve.
-GROWTH returns an array having one column and a row for each data point in @{new_x}.
- NOTE=If @{known_y}'s and @{known_x}'s have unequal number of data points, this function returns a #NUM! error.
+ SHORTDESC=exponential growth prediction
+ SYNTAX=GROWTH(known_ys,known_xs,new_xs,affine)
+ ARGUMENTDESCRIPTION=@{known_ys}: known y-values
+ {known_xs}: known x-values; defaults to the array {1, 2, 3, â?¦}
+ {new_xs}: x-values for which to estimate the y-values; defaults to @{known_xs}
+ {affine}: if true, the model contains a constant term, defaults to true
+ DESCRIPTION=GROWTH function applies the â??least squaresâ?? method to fit an exponential curve to your data and predicts the exponential growth by using this curve.
+GROWTH returns an array having one column and a row for each data point in @{new_xs}.
+ NOTE=If @{known_ys} and @{known_xs} have unequal number of data points, this function returns a #NUM! error.
@SEEALSO=LOGEST,GROWTH,TREND
@CATEGORY=Statistics
@@ -4465,7 +4468,7 @@ GROWTH returns an array having one column and a row for each data point in @{new
@CATEGORY=Statistics
@FUNCTION=HYPGEOMDIST
- SHORTDESC=(cumulative) probability mass function of the hypergeometric distribution
+ SHORTDESC=probability mass or cumulative distribution function of the hypergeometric distribution
@SYNTAX=HYPGEOMDIST(x,n,M,N,cumulative)
@ARGUMENTDESCRIPTION= {x}: number of successes
@{n}: sample size
@@ -4479,16 +4482,16 @@ GROWTH returns an array having one column and a row for each data point in @{new
@CATEGORY=Statistics
@FUNCTION=INTERCEPT
@SHORTDESC=the intercept of a linear regression line
- SYNTAX=INTERCEPT(known_y's,known_x's)
- ARGUMENTDESCRIPTION=@{known_y's}: known y-values
- {known_x's}: known x-values
- NOTE=If @{known_x} or @{known_y} contains no data entries or different number of data entries, this function returns a #N/A error. If the variance of the @{known_x} is zero, this function returns #DIV/0 error.
+ SYNTAX=INTERCEPT(known_ys,known_xs)
+ ARGUMENTDESCRIPTION=@{known_ys}: known y-values
+ {known_xs}: known x-values
+ NOTE=If @{known_xs} or @{known_ys} contains no data entries or different number of data entries, this function returns a #N/A error. If the variance of the @{known_xs} is zero, this function returns #DIV/0 error.
@EXCEL=This function is Excel compatible.
@SEEALSO=FORECAST,TREND
@CATEGORY=Statistics
@FUNCTION=KURT
- SHORTDESC=unbiased estimate of the kurtosis of a data set.
+ SHORTDESC=unbiased estimate of the kurtosis of a data set
@SYNTAX=KURT(number1,number2)
@ARGUMENTDESCRIPTION= {number1}: first value
@{number2}: second value
@@ -4511,14 +4514,14 @@ GROWTH returns an array having one column and a row for each data point in @{new
@FUNCTION=LANDAU
@SHORTDESC=approximate probability density function of the Landau distribution
@SYNTAX=LANDAU(x)
- ARGUMENTDESCRIPTION=@{x}:
+ ARGUMENTDESCRIPTION=@{x}: number
@SEEALSO=RANDLANDAU
@CATEGORY=Statistics
@FUNCTION=LAPLACE
@SHORTDESC=probability density function of the Laplace distribution
@SYNTAX=LAPLACE(x,a)
- ARGUMENTDESCRIPTION=@{x}:
+ ARGUMENTDESCRIPTION=@{x}: number
@{a}: mean
@SEEALSO=RANDLAPLACE
@@ -4534,16 +4537,16 @@ GROWTH returns an array having one column and a row for each data point in @{new
@CATEGORY=Statistics
@FUNCTION=LINEST
- SHORTDESC=determines multiple linear regression coefficients and statistics.
- SYNTAX=LINEST(known_y's,known_x's,affine,stats)
- ARGUMENTDESCRIPTION=@{known_y's}: vector of values of dependent variable.
- {known_x's}: array of values of independent variables, defaults to a single vector 1,...,n.
- {affine}: if true, the model contains a constant term, defaults to true.
+ SHORTDESC=multiple linear regression coefficients and statistics
+ SYNTAX=LINEST(known_ys,known_xs,affine,stats)
+ ARGUMENTDESCRIPTION=@{known_ys}: vector of values of dependent variable
+ {known_xs}: array of values of independent variables, defaults to a single vector {1,â?¦,n}
+ {affine}: if true, the model contains a constant term, defaults to true
@{stats}: if true, some additional statistics are provided, defaults to false
- DESCRIPTION=This function returns an array with the first row giving the regression coefficients for the independent variables x_m, x_(m-1),...,x_2, x_1 followed by the y-intercept if @{affine} is true.
+ DESCRIPTION=This function returns an array with the first row giving the regression coefficients for the independent variables x_m, x_(m-1),â?¦,x_2, x_1 followed by the y-intercept if @{affine} is true.
If @{stats} is true, the second row contains the corresponding standard errors of the regression coefficients.In this case, the third row contains the R^2 value and the standard error for the predicted value. The fourth row contains the observed F value and its degrees of freedom. Finally, the fifth row contains the regression sum of squares and the residual sum of squares.
If @{affine} is false, R^2 is the uncentered version of the coefficient of determination; that is the proportion of the sum of squares explained by the model.
- NOTE=If the length of @{known_y's} does not match the corresponding length of @{known_x's}, this function returns a #NUM! error.
+ NOTE=If the length of @{known_ys} does not match the corresponding length of @{known_xs}, this function returns a #NUM! error.
@SEEALSO=LOGEST,TREND
@CATEGORY=Statistics
@@ -4558,23 +4561,23 @@ If @{affine} is false, R^2 is the uncentered version of the coefficient of deter
@CATEGORY=Statistics
@FUNCTION=LOGEST
@SHORTDESC=exponential least square fit
- SYNTAX=LOGEST(known_y's,known_x's,const,stat)
- ARGUMENTDESCRIPTION=@{known_y's}: known y-values
- {known_x's}: known x-values; if @{known_x}'s is omitted, an array {1, 2, 3, ...} is used.
- {const}: if this is false the line will be forced to go through (0,1); defaults to TRUE
- {stat}: If @{stat} is TRUE, extra statistical information will be returned; defaults to FALSE.
- DESCRIPTION=LOGEST function applies the ``least squares'' method to fit an exponential curve of the form y = b * m{1}^x{1} * m{2}^x{2}... to your data.
+ SYNTAX=LOGEST(known_ys,known_xs,affine,stat)
+ ARGUMENTDESCRIPTION=@{known_ys}: known y-values
+ {known_xs}: known x-values; default to an array {1, 2, 3, â?¦}
+ {affine}: if true, the model contains a constant term, defaults to true
+ {stat}: if true, extra statistical information will be returned; defaults to FALSE
+ DESCRIPTION=LOGEST function applies the â??least squaresâ?? method to fit an exponential curve of the form y = b * m{1}^x{1} * m{2}^x{2}... to your data.
LOGEST returns an array { m{n},m{n-1}, ...,m{1},b }.
- NOTE=Extra statistical information is written below the regression line coefficients in the result array. Extra statistical information consists of four rows of data. In the first row the standard error values for the coefficients m1, (m2, ...), b are represented. The second row contains the square of R and the standard error for the y estimate. The third row contains the F-observed value and the degrees of freedom. The last row contains the regression sum of squares and the residual sum of squares. If @{known_y}'s and @{known_x}'s have unequal number of data points, this function returns a #NUM! error.
+ NOTE=Extra statistical information is written below the regression line coefficients in the result array. Extra statistical information consists of four rows of data. In the first row the standard error values for the coefficients m1, (m2, ...), b are represented. The second row contains the square of R and the standard error for the y estimate. The third row contains the F-observed value and the degrees of freedom. The last row contains the regression sum of squares and the residual sum of squares. If @{known_ys} and @{known_xs} have unequal number of data points, this function returns a #NUM! error.
@SEEALSO=GROWTH,TREND
@CATEGORY=Statistics
@FUNCTION=LOGFIT
@SHORTDESC=logarithmic least square fit (using a trial and error method)
- SYNTAX=LOGFIT(known_y's,known_x's)
- ARGUMENTDESCRIPTION=@{known_y's}: known y-values
- {known_x's}: known x-values
- DESCRIPTION=LOGFIT function applies the ``least squares'' method to fit the logarithmic equation y = a + b * ln(sign * (x - c)) , sign = +1 or -1 to your data. The graph of the equation is a logarithmic curve moved horizontally by c and possibly mirrored across the y-axis (if sign = -1).
+ SYNTAX=LOGFIT(known_ys,known_xs)
+ ARGUMENTDESCRIPTION=@{known_ys}: known y-values
+ {known_xs}: known x-values
+ DESCRIPTION=LOGFIT function applies the â??least squaresâ?? method to fit the logarithmic equation y = a + b * ln(sign * (x - c)) , sign = +1 or -1 to your data. The graph of the equation is a logarithmic curve moved horizontally by c and possibly mirrored across the y-axis (if sign = -1).
LOGFIT returns an array having five columns and one row. `Sign' is given in the first column, `a', `b', and `c' are given in columns 2 to 4. Column 5 holds the sum of squared residuals.
@NOTE=An error is returned when there are less than 3 different x's or y's, or when the shape of the point cloud is too different from a ``logarithmic'' one. You can use the above formula = a + b * ln(sign * (x - c)) or rearrange it to = (exp((y - a) / b)) / sign + c to compute unknown y's or x's, respectively. This is non-linear fitting by trial-and-error. The accuracy of `c' is: width of x-range -> rounded to the next smaller (10^integer), times 0.000001. There might be cases in which the returned fit is not the best possible.
@SEEALSO=LOGREG,LINEST,LOGEST
@@ -4594,7 +4597,7 @@ LOGFIT returns an array having five columns and one row. `Sign' is given in the
@FUNCTION=LOGISTIC
@SHORTDESC=probability density function of the logistic distribution
@SYNTAX=LOGISTIC(x,a)
- ARGUMENTDESCRIPTION=@{x}:
+ ARGUMENTDESCRIPTION=@{x}: number
@{a}: scale parameter
@SEEALSO=RANDLOGISTIC
@@ -4602,7 +4605,7 @@ LOGFIT returns an array having five columns and one row. `Sign' is given in the
@FUNCTION=LOGNORMDIST
@SHORTDESC=cumulative distribution function of the lognormal distribution
@SYNTAX=LOGNORMDIST(x,mean,stddev)
- ARGUMENTDESCRIPTION=@{x}:
+ ARGUMENTDESCRIPTION=@{x}: number
@{mean}: mean
@{stddev}: standard deviation
@NOTE=If @{stddev} = 0 LOGNORMDIST returns a #DIV/0! error. If @{x} <= 0, @{mean} < 0 or @{stddev} <= 0 this function returns a #NUM! error.
@@ -4612,19 +4615,19 @@ LOGFIT returns an array having five columns and one row. `Sign' is given in the
@CATEGORY=Statistics
@FUNCTION=LOGREG
@SHORTDESC=the logarithmic regression
- SYNTAX=LOGREG(known_y's,known_x's,const,stat)
- ARGUMENTDESCRIPTION=@{known_y's}: known y-values
- {known_x's}: known x-values; if @{known_x}'s is omitted, an array {1, 2, 3, ...} is used.
- {const}: If this is FALSE, the curve will be forced to go through [1; 0], i.e., b will be zero. The default is TRUE.
- {stat}: If @{stat} is TRUE, extra statistical information will be returned; defaults to FALSE.
- DESCRIPTION=LOGREG function transforms your x's to z=ln(x) and applies the ``least squares'' method to fit the linear equation y = m * z + b to your y's and z's --- equivalent to fitting the equation y = m * ln(x) + b to y's and x's. LOGREG returns an array having two columns and one row. m is given in the first column and b in the second.
+ SYNTAX=LOGREG(known_ys,known_xs,affine,stat)
+ ARGUMENTDESCRIPTION=@{known_ys}: known y-values
+ {known_xs}: known x-values; defaults to the array {1, 2, 3, â?¦}
+ {affine}: if true, the model contains a constant term, defaults to true
+ {stat}: if true, extra statistical information will be returned; defaults to FALSE
+ DESCRIPTION=LOGREG function transforms your x's to z=ln(x) and applies the â??least squaresâ?? method to fit the linear equation y = m * z + b to your y's and z's --- equivalent to fitting the equation y = m * ln(x) + b to y's and x's. LOGREG returns an array having two columns and one row. m is given in the first column and b in the second.
Any extra statistical information is written below m and b in the result array. This extra statistical information consists of four rows of data: In the first row the standard error values for the coefficients m, b are given. The second row contains the square of R and the standard error for the y estimate. The third row contains the F-observed value and the degrees of freedom. The last row contains the regression sum of squares and the residual sum of squares.The default of @{stat} is FALSE.
- NOTE=If @{known_y}'s and @{known_x}'s have unequal number of data points, this function returns a #NUM! error.
+ NOTE=If @{known_ys} and @{known_xs} have unequal number of data points, this function returns a #NUM! error.
@SEEALSO=LOGFIT,LINEST,LOGEST
@CATEGORY=Statistics
@FUNCTION=MAX
- SHORTDESC=largest value, with negative numbers considered smaller than positive numbers.
+ SHORTDESC=largest value, with negative numbers considered smaller than positive numbers
@SYNTAX=MAX(number1,number2)
@ARGUMENTDESCRIPTION= {number1}: first value
@{number2}: second value
@@ -4633,7 +4636,7 @@ Any extra statistical information is written below m and b in the result array.
@CATEGORY=Statistics
@FUNCTION=MAXA
- SHORTDESC=largest value, with negative numbers considered smaller than positive numbers.
+ SHORTDESC=largest value, with negative numbers considered smaller than positive numbers
@SYNTAX=MAXA(number1,number2)
@ARGUMENTDESCRIPTION= {number1}: first value
@{number2}: second value
@@ -4695,9 +4698,9 @@ If the data set does not contain any duplicates this function returns a #N/A err
@CATEGORY=Statistics
@FUNCTION=NORMDIST
- SHORTDESC=(cumulative) probability density function of a normal distribution
+ SHORTDESC=probability density or cumulative distribution function of a normal distribution
@SYNTAX=NORMDIST(x,mean,stddev,cumulative)
- ARGUMENTDESCRIPTION=@{x}:
+ ARGUMENTDESCRIPTION=@{x}: number
@{mean}: mean of the distribution
@{stddev}: standard deviation of the distribution
@{cumulative}: whether to evaluate the density function or the cumulative distribution function
@@ -4720,7 +4723,7 @@ If the data set does not contain any duplicates this function returns a #N/A err
@FUNCTION=NORMSDIST
@SHORTDESC=cumulative density function of the standard normal distribution
@SYNTAX=NORMSDIST(x)
- ARGUMENTDESCRIPTION=@{x}:
+ ARGUMENTDESCRIPTION=@{x}: number
@EXCEL=This function is Excel compatible.
@ODF=NORMSDIST is the OpenFormula function LEGACY.NORMSDIST.
@SEEALSO=NORMDIST
@@ -4739,7 +4742,7 @@ If the data set does not contain any duplicates this function returns a #N/A err
@FUNCTION=PARETO
@SHORTDESC=probability density function of the pareto distribution
@SYNTAX=PARETO(x,a,b)
- ARGUMENTDESCRIPTION=@{x}:
+ ARGUMENTDESCRIPTION=@{x}: number
@{a}: exponent
@{b}: scale parameter
@SEEALSO=RANDPARETO
@@ -4766,7 +4769,7 @@ If the data set does not contain any duplicates this function returns a #N/A err
@CATEGORY=Statistics
@FUNCTION=PERCENTRANK
- SHORTDESC=rank of a data point in a data set.
+ SHORTDESC=rank of a data point in a data set
@SYNTAX=PERCENTRANK(array,x,significance)
@ARGUMENTDESCRIPTION= {array}: range of numeric values
@{x}: data point to be ranked
@@ -4786,7 +4789,7 @@ If the data set does not contain any duplicates this function returns a #N/A err
@CATEGORY=Statistics
@FUNCTION=PERMUTATIONA
- SHORTDESC=the number of permutations of @{y} objects chosen from @{x} objects with repetition allowed.
+ SHORTDESC=the number of permutations of @{y} objects chosen from @{x} objects with repetition allowed
@SYNTAX=PERMUTATIONA(x,y)
@ARGUMENTDESCRIPTION= {x}: total number of objects
@{y}: number of selected objects
@@ -4796,7 +4799,7 @@ If the data set does not contain any duplicates this function returns a #N/A err
@CATEGORY=Statistics
@FUNCTION=POISSON
- SHORTDESC=(cumulative) probability mass function of the Poisson distribution
+ SHORTDESC=probability mass or cumulative distribution function of the Poisson distribution
@SYNTAX=POISSON(x,mean,cumulative)
@ARGUMENTDESCRIPTION= {x}: number of events
@{mean}: mean of the distribution
@@ -4822,8 +4825,8 @@ If the data set does not contain any duplicates this function returns a #N/A err
@SHORTDESC=the @{k}-th quartile of the data points
@SYNTAX=QUARTILE(array,quart)
@ARGUMENTDESCRIPTION= {array}: data points
- {quart}: A number from 0 to 4, indicating which quartile to calculate. A value of 0 causes the smallest value of @{array} to be returned.
- NOTE=If @{array} is empty, this function returns a #NUM! error. If @{quart} < 0 or @{quart} > 4, this function returns a #NUM! error. If @{quart} is not an integer, it is truncated.
+ {quart}: a number from 0 to 4, indicating which quartile to calculate
+ NOTE=If @{array} is empty, this function returns a #NUM! error. If @{quart} < 0 or @{quart} > 4, this function returns a #NUM! error. If @{quart} = 0, the smallest value of @{array} to be returned. If @{quart} is not an integer, it is truncated.
@EXCEL=This function is Excel compatible.
@SEEALSO=LARGE,MAX,MEDIAN,MIN,PERCENTILE,SMALL
@@ -5384,7 +5387,7 @@ If the data set does not contain any duplicates this function returns a #N/A err
@SYNTAX=RANK(x,ref,order)
@ARGUMENTDESCRIPTION= {x}: number whose rank you want to find
@{ref}: list of numbers
- {order}: If this is 0, numbers are ranked in descending order, otherwise numbers are ranked in ascending order. Defaults to 0.
+ {order}: 0 (descending order) or non-zero (ascending order); defaults to 0
@NOTE=In case of a tie, RANK returns the largest possible rank.
@EXCEL=This function is Excel compatible.
@SEEALSO=PERCENTRANK,RANK.AVG
@@ -5395,7 +5398,7 @@ If the data set does not contain any duplicates this function returns a #N/A err
@SYNTAX=RANK.AVG(x,ref,order)
@ARGUMENTDESCRIPTION= {x}: number whose rank you want to find
@{ref}: list of numbers
- {order}: If this is 0, numbers are ranked in descending order, otherwise numbers are ranked in ascending order. Defaults to 0.
+ {order}: 0 (descending order) or non-zero (ascending order); defaults to 0
@NOTE=In case of a tie, RANK returns the average rank.
@EXCEL=This function is Excel 2010 compatible.
@SEEALSO=PERCENTRANK,RANK
@@ -5404,7 +5407,7 @@ If the data set does not contain any duplicates this function returns a #N/A err
@FUNCTION=RAYLEIGH
@SHORTDESC=probability density function of the Rayleigh distribution
@SYNTAX=RAYLEIGH(x,sigma)
- ARGUMENTDESCRIPTION=@{x}:
+ ARGUMENTDESCRIPTION=@{x}: number
@{sigma}: scale parameter
@SEEALSO=RANDRAYLEIGH
@@ -5412,7 +5415,7 @@ If the data set does not contain any duplicates this function returns a #N/A err
@FUNCTION=RAYLEIGHTAIL
@SHORTDESC=probability density function of the Rayleigh tail distribution
@SYNTAX=RAYLEIGHTAIL(x,a,sigma)
- ARGUMENTDESCRIPTION=@{x}:
+ ARGUMENTDESCRIPTION=@{x}: number
@{a}: lower limit
@{sigma}: scale parameter
@SEEALSO=RANDRAYLEIGHTAIL
@@ -5460,16 +5463,16 @@ If the data set does not contain any duplicates this function returns a #N/A err
@CATEGORY=Statistics
@FUNCTION=SLOPE
@SHORTDESC=the slope of a linear regression line
- SYNTAX=SLOPE(known_y's,known_x's)
- ARGUMENTDESCRIPTION=@{known_y's}: known y-values
- {known_x's}: known x-values
- NOTE=If @{known_x} or @{known_y} contains no data entries or different number of data entries, this function returns a #N/A error. If the variance of the @{known_x} is zero, this function returns #DIV/0 error.
+ SYNTAX=SLOPE(known_ys,known_xs)
+ ARGUMENTDESCRIPTION=@{known_ys}: known y-values
+ {known_xs}: known x-values
+ NOTE=If @{known_xs} or @{known_ys} contains no data entries or different number of data entries, this function returns a #N/A error. If the variance of the @{known_xs} is zero, this function returns #DIV/0 error.
@EXCEL=This function is Excel compatible.
@SEEALSO=STDEV,STDEVPA
@CATEGORY=Statistics
@FUNCTION=SMALL
- SHORTDESC= @{k}-th smallest value in a data set.
+ SHORTDESC=@{k}-th smallest value in a data set
@SYNTAX=SMALL(data,k)
@ARGUMENTDESCRIPTION= {data}: data set
@{k}: which value to find
@@ -5511,7 +5514,7 @@ To obtain the population standard deviation of a whole population use STDEVP.
@CATEGORY=Statistics
@FUNCTION=STDEVA
- SHORTDESC=sample standard deviation of the given sample.
+ SHORTDESC=sample standard deviation of the given sample
@SYNTAX=STDEVA(area1,area2)
@ARGUMENTDESCRIPTION= {area1}: first cell area
@{area2}: second cell area
@@ -5533,7 +5536,7 @@ Numbers, text and logical values are included in the calculation too. If the cel
@CATEGORY=Statistics
@FUNCTION=STDEVPA
- SHORTDESC=population standard deviation of an entire population.
+ SHORTDESC=population standard deviation of an entire population
@SYNTAX=STDEVPA(area1,area2)
@ARGUMENTDESCRIPTION= {area1}: first cell area
@{area2}: second cell area
@@ -5545,10 +5548,10 @@ Numbers, text and logical values are included in the calculation too. If the cel
@CATEGORY=Statistics
@FUNCTION=STEYX
@SHORTDESC=standard error of the predicted y-value in the regression
- SYNTAX=STEYX(known_y's,known_x's)
- ARGUMENTDESCRIPTION=@{known_y's}: known y-values
- {known_x's}: known x-values
- NOTE=If @{known_y}'s and @{known_x}'s are empty or have a different number of arguments then this function returns a #N/A error.
+ SYNTAX=STEYX(known_ys,known_xs)
+ ARGUMENTDESCRIPTION=@{known_ys}: known y-values
+ {known_xs}: known x-values
+ NOTE=If @{known_ys} and @{known_xs} are empty or have a different number of arguments then this function returns a #N/A error.
@EXCEL=This function is Excel compatible.
@SEEALSO=PEARSON,RSQ,SLOPE
@@ -5577,9 +5580,9 @@ Numbers, text and logical values are included in the calculation too. If the cel
@FUNCTION=TDIST
@SHORTDESC=survival function of the Student t-distribution
@SYNTAX=TDIST(x,dof,tails)
- ARGUMENTDESCRIPTION=@{x}:
+ ARGUMENTDESCRIPTION=@{x}: number
@{dof}: number of degrees of freedom
- {tails}: 1 or 2.
+ {tails}: 1 or 2
@DESCRIPTION=The survival function is 1 minus the cumulative distribution function.
This function is Excel compatible for non-negative @{x}.
@NOTE=If @{dof} < 1 this function returns a #NUM! error. If @{tails} is neither 1 or 2 this function returns a #NUM! error. The parameterization of this function is different from what is used for, e.g., NORMSDIST. This is a common source of mistakes, but necessary for compatibility.
@@ -5599,12 +5602,12 @@ This function is Excel compatible for non-negative @{x}.
@CATEGORY=Statistics
@FUNCTION=TREND
@SHORTDESC=estimates future values of a given data set using a least squares approximation
- SYNTAX=TREND(known_y's,known_x's,new_x's,const)
- ARGUMENTDESCRIPTION=@{known_y's}: known y-values
- {known_x's}: known x-values; if @{known_x}'s is omitted, an array {1, 2, 3, ...} is used.
- {new_x's}: x-values for which you want to estimate the y-values; defaults to @{known_x}'s
- {const}: if this is false the line will be forced to go through the origin; defaults to TRUE
- NOTE=If @{known_y's} and @{known_x's} have unequal number of data points, this function returns a #NUM! error.
+ SYNTAX=TREND(known_ys,known_xs,new_xs,affine)
+ ARGUMENTDESCRIPTION=@{known_ys}: known y-values
+ {known_xs}: known x-values; defaults to the array {1, 2, 3, â?¦}
+ {new_xs}: x-values for which to estimate the y-values; defaults to @{known_xs}
+ {affine}: if true, the model contains a constant term, defaults to true
+ NOTE=If @{known_ys} and @{known_xs} have unequal number of data points, this function returns a #NUM! error.
@SEEALSO=LINEST
@CATEGORY=Statistics
@@ -5675,9 +5678,9 @@ Numbers, text and logical values are included in the calculation too. If the cel
@CATEGORY=Statistics
@FUNCTION=WEIBULL
- SHORTDESC=(cumulative) probability density function of the Weibull distribution
+ SHORTDESC=probability density or cumulative distribution function of the Weibull distribution
@SYNTAX=WEIBULL(x,alpha,beta,cumulative)
- ARGUMENTDESCRIPTION=@{x}:
+ ARGUMENTDESCRIPTION=@{x}: number
@{alpha}: scale parameter
@{beta}: scale parameter
@{cumulative}: whether to evaluate the density function or the cumulative distribution function
@@ -5701,7 +5704,7 @@ Numbers, text and logical values are included in the calculation too. If the cel
@CATEGORY=String
@FUNCTION=ASC
- SHORTDESC=text with full-width katakana and ASCII characters converted to half-width.
+ SHORTDESC=text with full-width katakana and ASCII characters converted to half-width
@SYNTAX=ASC(text)
@ARGUMENTDESCRIPTION= {text}: string
@DESCRIPTION=ASC converts full-width katakana and ASCII characters to half-width equivalent characters, copying all others.
@@ -5713,7 +5716,7 @@ The distinction between half-width and full-width characters is described in htt
@CATEGORY=String
@FUNCTION=CHAR
- SHORTDESC=the CP1252 (Windows-1252) character for the code point @{x}.
+ SHORTDESC=the CP1252 (Windows-1252) character for the code point @{x}
@SYNTAX=CHAR(x)
@ARGUMENTDESCRIPTION= {x}: code point
@DESCRIPTION=CHAR(@{x}) returns the CP1252 (Windows-1252) character with code @{x}.
@@ -5746,7 +5749,7 @@ This function is Excel compatible.
@CATEGORY=String
@FUNCTION=CONCATENATE
- SHORTDESC=the concatenation of the strings @{s1}, @{s2},...
+ SHORTDESC=the concatenation of the strings @{s1}, @{s2},â?¦
@SYNTAX=CONCATENATE(s1,s2)
@ARGUMENTDESCRIPTION= {s1}: first string
@{s2}: second string
@@ -5755,7 +5758,7 @@ This function is Excel compatible.
@CATEGORY=String
@FUNCTION=DOLLAR
- SHORTDESC=@{num} formatted as currency.
+ SHORTDESC=@{num} formatted as currency
@SYNTAX=DOLLAR(num,decimals)
@ARGUMENTDESCRIPTION= {num}: number
@{decimals}: decimals
@@ -5806,7 +5809,7 @@ This function is Excel compatible.
@CATEGORY=String
@FUNCTION=JIS
- SHORTDESC=text with half-width katakana and ASCII characters converted to full-width.
+ SHORTDESC=text with half-width katakana and ASCII characters converted to full-width
@SYNTAX=JIS(text)
@ARGUMENTDESCRIPTION= {text}: original text
@DESCRIPTION=JIS converts half-width katakana and ASCII characters to full-width equivalent characters, copying all others.
@@ -5856,7 +5859,7 @@ The distinction between half-width and full-width characters is described in htt
@CATEGORY=String
@FUNCTION=LOWER
- SHORTDESC=a lower-case version of the string @{text}.
+ SHORTDESC=a lower-case version of the string @{text}
@SYNTAX=LOWER(text)
@ARGUMENTDESCRIPTION= {text}: string
@EXCEL=This function is Excel compatible.
@@ -5897,7 +5900,7 @@ The distinction between half-width and full-width characters is described in htt
@CATEGORY=String
@FUNCTION=PROPER
- SHORTDESC=@{text} with initial of each word capitalised.
+ SHORTDESC=@{text} with initial of each word capitalised
@SYNTAX=PROPER(text)
@ARGUMENTDESCRIPTION= {text}: string
@EXCEL=This function is Excel compatible.
@@ -5905,7 +5908,7 @@ The distinction between half-width and full-width characters is described in htt
@CATEGORY=String
@FUNCTION=REPLACE
- SHORTDESC=String @{old} with @{num} characters starting at @{start} replaced by @{new}
+ SHORTDESC=string @{old} with @{num} characters starting at @{start} replaced by @{new}
@SYNTAX=REPLACE(old,start,num,new)
@ARGUMENTDESCRIPTION= {old}: original text
@{start}: starting position
@@ -6014,7 +6017,7 @@ The distinction between half-width and full-width characters is described in htt
@CATEGORY=String
@FUNCTION=TRIM
- SHORTDESC=@{text} with only single spaces between words.
+ SHORTDESC=@{text} with only single spaces between words
@SYNTAX=TRIM(text)
@ARGUMENTDESCRIPTION= {text}: string
@EXCEL=This function is Excel compatible.
@@ -6022,7 +6025,7 @@ The distinction between half-width and full-width characters is described in htt
@CATEGORY=String
@FUNCTION=UNICHAR
- SHORTDESC=the Unicode character represented by the Unicode code point @{x}.
+ SHORTDESC=the Unicode character represented by the Unicode code point @{x}
@SYNTAX=UNICHAR(x)
@ARGUMENTDESCRIPTION= {x}: Unicode code point
@SEEALSO=CHAR,UNICODE,CODE
@@ -6036,7 +6039,7 @@ The distinction between half-width and full-width characters is described in htt
@CATEGORY=String
@FUNCTION=UPPER
- SHORTDESC=an upper-case version of the string @text.
+ SHORTDESC=an upper-case version of the string @text
@SYNTAX=UPPER(text)
@ARGUMENTDESCRIPTION= {text}: string
@EXCEL=This function is Excel compatible.
@@ -6052,9 +6055,9 @@ The distinction between half-width and full-width characters is described in htt
@CATEGORY=Time Series Analysis
@FUNCTION=FOURIER
- SHORTDESC=Fourier or inverse Fourier transform.
+ SHORTDESC=Fourier or inverse Fourier transform
@SYNTAX=FOURIER(Sequence,Inverse)
- ARGUMENTDESCRIPTION=@{Sequence}: the data sequence to be transformed
+ ARGUMENTDESCRIPTION=@{Sequence}: the data sequence to be transformed
@{Inverse}: if false, the inverse Fourier transform is calculated. Defaults to false
@DESCRIPTION=This array function returns the Fourier or inverse Fourier transform of the given data sequence.
The output consists always of one column of complex numbers.
@@ -6062,12 +6065,12 @@ The output consists always of one column of complex numbers.
@CATEGORY=Time Series Analysis
@FUNCTION=INTERPOLATION
- SHORTDESC=interpolated values corresponding to the given abscissa targets.
- SYNTAX=INTERPOLATION(abscissas,ordinates,targets,interpolation)
- ARGUMENTDESCRIPTION=@{abscissas}: The abscissas of the data to interpolate.
- {ordinates}: The ordinates of the data to interpolate.
- {targets}: The abscissas of the interpolated data.
- {interpolation}: The method of interpolation to be used, defaults to no interpolation
+ SHORTDESC=interpolated values corresponding to the given abscissa targets
+ SYNTAX=INTERPOLATION(abscissae,ordinates,targets,interpolation)
+ ARGUMENTDESCRIPTION=@{abscissae}: abscissae of the given data points
+ {ordinates}: ordinates of the given data points
+ {targets}: abscissae of the interpolated data
+ {interpolation}: method of interpolation, defaults to none
@DESCRIPTION=If an interpolation method is used, the number of returned values is one less than the number of targets and the targets values must be given in increasing order.
The output consists always of one column of numbers.
Possible interpolation methods are:
@@ -6077,18 +6080,18 @@ Possible interpolation methods are:
3: staircase with averaging;
4: natural cubic spline;
5: natural cubic spline with averaging.
- NOTE=Strings and empty cells in @{abscissas} and @{ordinates} are ignored. If several target data are provided they must be in the same column in consecutive cells.
+ NOTE=Strings and empty cells in @{abscissae} and @{ordinates} are ignored. If several target data are provided they must be in the same column in consecutive cells.
@SEEALSO=PERIODOGRAM
@CATEGORY=Time Series Analysis
@FUNCTION=PERIODOGRAM
- SHORTDESC= Periodogram of the given data.
- SYNTAX=PERIODOGRAM(ordinates,filter,abscissas,interpolation,number)
- ARGUMENTDESCRIPTION=@{ordinates}: The ordinates of the data to interpolate.
- {filter}: Window function to be used, defaults to no window function.
- {abscissas}: The abscissas of the data to interpolate, defaults to regularly spaced abscissa.
- {interpolation}: The method of interpolation to be used, defaults to no interpolation
- {number}: Number of interpolated data points to be used.
+ SHORTDESC=periodogram of the given data
+ SYNTAX=PERIODOGRAM(ordinates,filter,abscissae,interpolation,number)
+ ARGUMENTDESCRIPTION=@{ordinates}: ordinates of the given data
+ {filter}: windowing function to be used, defaults to no filter
+ {abscissae}: abscissae of the given data, defaults to regularly spaced abscissae
+ {interpolation}: method of interpolation, defaults to none
+ {number}: number of interpolated data points
@DESCRIPTION=If an interpolation method is used, the number of returned values is one less than the number of targets and the targets values must be given in increasing order.
The output consists always of one column of numbers.
Possible interpolation methods are:
@@ -6103,6 +6106,6 @@ Possible window functions are:
1: Bartlett (triangular window)
2: Hahn (cosine window)
3: Welch (parabolic window)
- NOTE=Strings and empty cells in @{abscissas} and @{ordinates} are ignored. If several target data are provided they must be in the same column in consecutive cells.
+ NOTE=Strings and empty cells in @{abscissae} and @{ordinates} are ignored. If several target data are provided they must be in the same column in consecutive cells.
@SEEALSO=INTERPOLATION
diff --git a/doc/C/functions.xml b/doc/C/functions.xml
index d44a396..c23493e 100644
--- a/doc/C/functions.xml
+++ b/doc/C/functions.xml
@@ -194,7 +194,7 @@
<function>COMPLEX</function>
</refname>
<refpurpose>
- a complex number of the form <parameter>x</parameter> + <parameter>y</parameter><parameter>i</parameter>.
+ a complex number of the form <parameter>x</parameter> + <parameter>y</parameter><parameter>i</parameter>
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -204,7 +204,7 @@
<title>Arguments</title>
<para><parameter>x</parameter>: real part</para>
<para><parameter>y</parameter>: imaginary part</para>
- <para><parameter>i</parameter>: the suffix for the complex number, either "i" or "j"; defaults to "i".</para>
+ <para><parameter>i</parameter>: the suffix for the complex number, either "i" or "j"; defaults to "i"</para>
</refsect1>
<refsect1>
<title>Note</title>
@@ -1216,7 +1216,7 @@
<function>IMPOWER</function>
</refname>
<refpurpose>
- the complex number <parameter>z1</parameter> raised to the <parameter>z2</parameter>th power
+ the complex number <parameter>z1</parameter> raised to the <parameter>z2</parameter>th power
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -1252,7 +1252,7 @@
<function>IMPRODUCT</function>
</refname>
<refpurpose>
- the product of the given complex numbers.
+ the product of the given complex numbers
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -1494,7 +1494,7 @@
<function>IMSUB</function>
</refname>
<refpurpose>
- the difference of two complex numbers.
+ the difference of two complex numbers
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -2743,7 +2743,7 @@
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
- <para><parameter>time</parameter>: time of day as fractional day.</para>
+ <para><parameter>time</parameter>: time of day as fractional day</para>
</refsect1>
<refsect1>
<title>Description</title>
@@ -2852,7 +2852,7 @@
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
- <para><parameter>time</parameter>: time of day as fractional day.</para>
+ <para><parameter>time</parameter>: time of day as fractional day</para>
</refsect1>
<refsect1>
<title>Description</title>
@@ -3025,7 +3025,7 @@
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
- <para><parameter>time</parameter>: time of day as fractional day.</para>
+ <para><parameter>time</parameter>: time of day as fractional day</para>
</refsect1>
<refsect1>
<title>Description</title>
@@ -3609,7 +3609,7 @@
<function>BIN2HEX</function>
</refname>
<refpurpose>
- hexadecimal representation of the binary number <parameter>x</parameter>
+ hexadecimal representation of the binary number <parameter>x</parameter>
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -3647,7 +3647,7 @@
<function>BIN2OCT</function>
</refname>
<refpurpose>
- octal representation of the binary number <parameter>x</parameter>
+ octal representation of the binary number <parameter>x</parameter>
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -3812,7 +3812,7 @@
<function>DEC2BIN</function>
</refname>
<refpurpose>
- binary representation of the decimal number <parameter>x</parameter>
+ binary representation of the decimal number <parameter>x</parameter>
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -3850,7 +3850,7 @@
<function>DEC2HEX</function>
</refname>
<refpurpose>
- hexadecimal representation of the decimal number <parameter>x</parameter>
+ hexadecimal representation of the decimal number <parameter>x</parameter>
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -3888,7 +3888,7 @@
<function>DEC2OCT</function>
</refname>
<refpurpose>
- octal representation of the decimal number <parameter>x</parameter>
+ octal representation of the decimal number <parameter>x</parameter>
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -4066,7 +4066,7 @@
<function>GESTEP</function>
</refname>
<refpurpose>
- Step function with step at <parameter>x1</parameter> evaluated at <parameter>x0</parameter>
+ step function with step at <parameter>x1</parameter> evaluated at <parameter>x0</parameter>
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -4515,7 +4515,7 @@
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>ACCRINT</function>(<parameter>issue</parameter>,<parameter>first_interest</parameter>,<parameter>settlement</parameter>,<parameter>rate</parameter>,<parameter>par</parameter>,<parameter>frequency</parameter>,<parameter>basis</parameter>)</synopsis>
+ <synopsis><function>ACCRINT</function>(<parameter>issue</parameter>,<parameter>first_interest</parameter>,<parameter>settlement</parameter>,<parameter>rate</parameter>,<parameter>par</parameter>,<parameter>frequency</parameter>,<parameter>basis</parameter>,<parameter>calc_method</parameter>)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
@@ -4523,17 +4523,20 @@
<para><parameter>first_interest</parameter>: date of first interest payment</para>
<para><parameter>settlement</parameter>: settlement date</para>
<para><parameter>rate</parameter>: nominal annual interest rate</para>
- <para><parameter>par</parameter>: par value</para>
+ <para><parameter>par</parameter>: par value, defaults to $1000</para>
<para><parameter>frequency</parameter>: number of interest payments per year</para>
- <para><parameter>basis</parameter>: calendar basis</para>
+ <para><parameter>basis</parameter>: calendar basis, defaults to 0</para>
+ <para><parameter>calc_method</parameter>: calculation method, defaults to TRUE</para>
</refsect1>
<refsect1>
<title>Description</title>
- <para><function>ACCRINT</function> calculates the accrued interest for a security that pays periodic interest.</para>
+ <para>If <parameter>first_interest</parameter> < <parameter>settlement</parameter> and <parameter>calc_method</parameter> is TRUE, then <function>ACCRINT</function> returns the sum of the interest accrued in all coupon periods from <parameter>issue</parameter> date until <parameter>settlement</parameter> date.</para>
+ <para>If <parameter>first_interest</parameter> < <parameter>settlement</parameter> and <parameter>calc_method</parameter> is FALSE, then <function>ACCRINT</function> returns the sum of the interest accrued in all coupon periods from <parameter>first_interest</parameter> date until <parameter>settlement</parameter> date.</para>
+ <para>Otherwise <function>ACCRINT</function> returns the sum of the interest accrued in all coupon periods from <parameter>issue</parameter> date until <parameter>settlement</parameter> date.</para>
</refsect1>
<refsect1>
<title>Note</title>
- <para><parameter>par</parameter> defaults to $1000. <parameter>frequency</parameter> may be 1 (annual), 2 (semi-annual), or 4 (quarterly). If <parameter>basis</parameter> is 0, then the US 30/360 method is used. If <parameter>basis</parameter> is 1, then actual number of days is used. If <parameter>basis</parameter> is 2, then actual number of days is used within a month, but years are considered only 360 days. If <parameter>basis</parameter> is 3, then actual number of days is used within a month, but years are always considered 365 days. If <parameter>basis</parameter> is 4, then the European 30/360 method is used.</para>
+ <para><parameter>frequency</parameter> must be one of 1, 2 or 4, but the exact value does not affect the result. <parameter>issue</parameter> must precede both <parameter>first_interest</parameter> and <parameter>settlement</parameter>. <parameter>frequency</parameter> may be 1 (annual), 2 (semi-annual), or 4 (quarterly). If <parameter>basis</parameter> is 0, then the US 30/360 method is used. If <parameter>basis</parameter> is 1, then actual number of days is used. If <parameter>basis</parameter> is 2, then actual number of days is used within a month, but years are considered only 360 days. If <parameter>basis</parameter> is 3, then actual number of days is used within a month, but years are always considered 365 days. If <parameter>basis</parameter> is 4, then the European 30/360 method is used.</para>
</refsect1>
<refsect1>
<title>See also</title>
@@ -5317,8 +5320,8 @@
<para><parameter>n</parameter>: amount</para>
<para><parameter>source</parameter>: three-letter source currency code</para>
<para><parameter>target</parameter>: three-letter target currency code</para>
- <para><parameter>full_precision</parameter>: if true, the result is not rounded; if false the result is rounded to 0 or 2 decimals depending on the target currency; defaults to false.</para>
- <para><parameter>triangulation_precision</parameter>: number of digits (at least 3) to be rounded to after the source currency has been converted to euro; omitting this argument results in no rounding.</para>
+ <para><parameter>full_precision</parameter>: whether to provide the full precision; defaults to false</para>
+ <para><parameter>triangulation_precision</parameter>: number of digits (at least 3) to be rounded to after conversion of the source currency to euro; defaults to no rounding</para>
</refsect1>
<refsect1>
<title>Description</title>
@@ -5326,7 +5329,7 @@
</refsect1>
<refsect1>
<title>Note</title>
- <para><parameter>source</parameter> and <parameter>target</parameter> must be one of the currencies listed for the EURO function. This function is not likely to be useful anymore.</para>
+ <para>If <parameter>full_precision</parameter> is true, the result is not rounded; if it false the result is rounded to 0 or 2 decimals depending on the target currency; defaults to false. <parameter>source</parameter> and <parameter>target</parameter> must be one of the currencies listed for the EURO function. This function is not likely to be useful anymore.</para>
</refsect1>
<refsect1>
<title>See also</title>
@@ -6487,7 +6490,7 @@
<refsect1>
<title>Arguments</title>
<para><parameter>spot</parameter>: spot price</para>
- <para><parameter>strike_call</parameter>: strike price, if exercised as a call option.</para>
+ <para><parameter>strike_call</parameter>: strike price, if exercised as a call option</para>
<para><parameter>strike_put</parameter>: strike price, if exercised as a put option</para>
<para><parameter>time</parameter>: time in years until the holder chooses a put or a call option</para>
<para><parameter>time_call</parameter>: time in years to maturity of the call option if chosen</para>
@@ -6948,19 +6951,19 @@
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
- <para><parameter>type_flag</parameter>: 'cc' for calls on calls, 'cp' for calls on puts, and so on for 'pc', and 'pp'.</para>
+ <para><parameter>type_flag</parameter>: 'cc' for calls on calls, 'cp' for calls on puts, and so on for 'pc', and 'pp'</para>
<para><parameter>spot</parameter>: spot price</para>
<para><parameter>strike1</parameter>: strike price at which the option being valued is struck</para>
<para><parameter>strike2</parameter>: strike price at which the underlying option is struck</para>
<para><parameter>time1</parameter>: time in years to maturity of the option</para>
<para><parameter>time2</parameter>: time in years to the maturity of the underlying option</para>
<para><parameter>rate</parameter>: annualized risk-free interest rate</para>
- <para><parameter>cost_of_carry</parameter>: net cost of holding the underlying asset of the underlying option (for common stocks, the risk free rate less the dividend yield)</para>
+ <para><parameter>cost_of_carry</parameter>: net cost of holding the underlying asset of the underlying option</para>
<para><parameter>volatility</parameter>: annualized volatility in price of the underlying asset of the underlying option</para>
</refsect1>
<refsect1>
<title>Note</title>
- <para><parameter>time2</parameter> â?¥ <parameter>time1</parameter></para>
+ <para>For common stocks, <parameter>cost_of_carry</parameter> is the risk free rate less the dividend yield. <parameter>time2</parameter> â?¥ <parameter>time1</parameter></para>
</refsect1>
<refsect1>
<title>See also</title>
@@ -8137,7 +8140,7 @@
<function>GET.FORMULA</function>
</refname>
<refpurpose>
- The formula in <parameter>cell</parameter> as a string.
+ the formula in <parameter>cell</parameter> as a string
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -8169,7 +8172,7 @@
<function>GET.LINK</function>
</refname>
<refpurpose>
- The target of the hyperlink attached to <parameter>cell</parameter> as a string.
+ the target of the hyperlink attached to <parameter>cell</parameter> as a string
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -8269,7 +8272,7 @@
<function>ISBLANK</function>
</refname>
<refpurpose>
- TRUE if <parameter>value</parameter> is blank.
+ TRUE if <parameter>value</parameter> is blank
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -8362,7 +8365,7 @@
<function>ISEVEN</function>
</refname>
<refpurpose>
- TRUE if <parameter>n</parameter> is even.
+ TRUE if <parameter>n</parameter> is even
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -8393,7 +8396,7 @@
<function>ISFORMULA</function>
</refname>
<refpurpose>
- TRUE if <parameter>cell</parameter> contains a formula.
+ TRUE if <parameter>cell</parameter> contains a formula
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -8424,7 +8427,7 @@
<function>ISLOGICAL</function>
</refname>
<refpurpose>
- TRUE if <parameter>value</parameter> is a logical value.
+ TRUE if <parameter>value</parameter> is a logical value
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -8454,7 +8457,7 @@
<function>ISNA</function>
</refname>
<refpurpose>
- TRUE if <parameter>value</parameter> is the #N/A error value.
+ TRUE if <parameter>value</parameter> is the #N/A error value
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -8485,7 +8488,7 @@
<function>ISNONTEXT</function>
</refname>
<refpurpose>
- TRUE if <parameter>value</parameter> is not text.
+ TRUE if <parameter>value</parameter> is not text
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -8516,7 +8519,7 @@
<function>ISNUMBER</function>
</refname>
<refpurpose>
- TRUE if <parameter>value</parameter> is a number.
+ TRUE if <parameter>value</parameter> is a number
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -8546,7 +8549,7 @@
<function>ISODD</function>
</refname>
<refpurpose>
- TRUE if <parameter>n</parameter> is odd.
+ TRUE if <parameter>n</parameter> is odd
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -8577,7 +8580,7 @@
<function>ISREF</function>
</refname>
<refpurpose>
- TRUE if <parameter>value</parameter> is a reference.
+ TRUE if <parameter>value</parameter> is a reference
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -8607,7 +8610,7 @@
<function>ISTEXT</function>
</refname>
<refpurpose>
- TRUE if <parameter>value</parameter> is text.
+ TRUE if <parameter>value</parameter> is text
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -8774,7 +8777,7 @@
<function>FALSE</function>
</refname>
<refpurpose>
- the value <function>FALSE</function>.
+ the value <function>FALSE</function>
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -8806,7 +8809,7 @@
<function>IF</function>
</refname>
<refpurpose>
- conditional expression.
+ conditional expression
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -8814,9 +8817,9 @@
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
- <para><parameter>cond</parameter>: condition.</para>
- <para><parameter>trueval</parameter>: value to use if condition is true.</para>
- <para><parameter>falseval</parameter>: value to use if condition is false.</para>
+ <para><parameter>cond</parameter>: condition</para>
+ <para><parameter>trueval</parameter>: value to use if condition is true</para>
+ <para><parameter>falseval</parameter>: value to use if condition is false</para>
</refsect1>
<refsect1>
<title>Description</title>
@@ -8843,7 +8846,7 @@
<function>IFERROR</function>
</refname>
<refpurpose>
- Test for error.
+ test for error
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -8851,8 +8854,8 @@
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
- <para><parameter>x</parameter>: value to test for error.</para>
- <para><parameter>y</parameter>: alternate value.</para>
+ <para><parameter>x</parameter>: value to test for error</para>
+ <para><parameter>y</parameter>: alternate value</para>
</refsect1>
<refsect1>
<title>Description</title>
@@ -8876,7 +8879,7 @@
<function>IFNA</function>
</refname>
<refpurpose>
- Test for #NA! error.
+ test for #NA! error
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -8884,8 +8887,8 @@
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
- <para><parameter>x</parameter>: value to test for #NA! error.</para>
- <para><parameter>y</parameter>: alternate value.</para>
+ <para><parameter>x</parameter>: value to test for #NA! error</para>
+ <para><parameter>y</parameter>: alternate value</para>
</refsect1>
<refsect1>
<title>Description</title>
@@ -8993,7 +8996,7 @@
<function>TRUE</function>
</refname>
<refpurpose>
- the value <function>TRUE</function>.
+ the value <function>TRUE</function>
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -9344,7 +9347,7 @@
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
- <para><parameter>array</parameter>: </para>
+ <para><parameter>array</parameter>: cell or inline array</para>
<para><parameter>row</parameter>: desired row, defaults to 1</para>
<para><parameter>col</parameter>: desired column, defaults to 1</para>
<para><parameter>area</parameter>: from which area to select a cell, defaults to 1</para>
@@ -9377,7 +9380,7 @@
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
- <para><parameter>ref_text</parameter>: </para>
+ <para><parameter>ref_text</parameter>: textual reference</para>
<para><parameter>format</parameter>: if true, <parameter>ref_text</parameter> is given in A1-style, otherwise it is given in R1C1 style; defaults to true</para>
</refsect1>
<refsect1>
@@ -9831,7 +9834,7 @@
<function>ACOT</function>
</refname>
<refpurpose>
- inverse cotangent of a value
+ inverse cotangent of <parameter>x</parameter>
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -9859,7 +9862,7 @@
<function>ACOTH</function>
</refname>
<refpurpose>
- inverse hyperbolic cotangent of a value
+ the inverse hyperbolic cotangent of <parameter>x</parameter>
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -9887,7 +9890,7 @@
<function>ARABIC</function>
</refname>
<refpurpose>
- The Roman numeral <parameter>roman</parameter> as number
+ the Roman numeral <parameter>roman</parameter> as number
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -10042,7 +10045,7 @@
<function>ATAN2</function>
</refname>
<refpurpose>
- arc tangent of the ratio of <parameter>y</parameter> and <parameter>x</parameter>
+ the arc tangent of the ratio of <parameter>y</parameter> and <parameter>x</parameter>
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -10135,8 +10138,8 @@
<refsect1>
<title>Arguments</title>
<para><parameter>range</parameter>: cell area</para>
- <para><parameter>criteria</parameter>: condition for a cell to be included</para>
- <para><parameter>actual_range</parameter>: cell area, defaults to <parameter>range</parameter></para>
+ <para><parameter>criteria</parameter>: condition for a cell to be included</para>
+ <para><parameter>actual_range</parameter>: cell area, defaults to <parameter>range</parameter></para>
</refsect1>
<refsect1>
<title>Microsoft Excel Compatibility</title>
@@ -10197,7 +10200,7 @@
<function>BETALN</function>
</refname>
<refpurpose>
- Natural logarithm of the absolute value of the Euler beta function
+ natural logarithm of the absolute value of the Euler beta function
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -10354,7 +10357,7 @@
<function>COMBIN</function>
</refname>
<refpurpose>
- Binomial coefficient
+ binomial coefficient
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -10425,7 +10428,7 @@
<function>COS</function>
</refname>
<refpurpose>
- Cosine function
+ the cosine of <parameter>x</parameter>
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -10462,7 +10465,7 @@
<function>COSH</function>
</refname>
<refpurpose>
- Hyperbolic cosine function
+ the hyperbolic cosine of <parameter>x</parameter>
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -10497,7 +10500,7 @@
<function>COT</function>
</refname>
<refpurpose>
- cotangent of a value
+ the cotangent of <parameter>x</parameter>
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -10525,7 +10528,7 @@
<function>COTH</function>
</refname>
<refpurpose>
- hyperbolic cotangent of a value
+ the hyperbolic cotangent of <parameter>x</parameter>
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -10562,7 +10565,7 @@
<refsect1>
<title>Arguments</title>
<para><parameter>range</parameter>: cell area</para>
- <para><parameter>criteria</parameter>: condition for a cell to be counted</para>
+ <para><parameter>criteria</parameter>: condition for a cell to be counted</para>
</refsect1>
<refsect1>
<title>Microsoft Excel Compatibility</title>
@@ -10586,7 +10589,7 @@
<function>CSC</function>
</refname>
<refpurpose>
- Cosecant
+ the cosecant of <parameter>x</parameter>
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -10629,7 +10632,7 @@
<function>CSCH</function>
</refname>
<refpurpose>
- Hyperbolic cosecant
+ the hyperbolic cosecant of <parameter>x</parameter>
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -10671,7 +10674,7 @@
<function>DEGREES</function>
</refname>
<refpurpose>
- Equivalent degrees to <parameter>x</parameter> radians.
+ equivalent degrees to <parameter>x</parameter> radians
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -10927,7 +10930,7 @@
<function>FLOOR</function>
</refname>
<refpurpose>
- nearest multiple of <parameter>significance</parameter> whose absolute value is at most ABS(<parameter>x</parameter>).
+ nearest multiple of <parameter>significance</parameter> whose absolute value is at most ABS(<parameter>x</parameter>)
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -10935,7 +10938,7 @@
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
- <para><parameter>x</parameter>: number.</para>
+ <para><parameter>x</parameter>: number</para>
<para><parameter>significance</parameter>: base multiple (defaults to 1 for <parameter>x</parameter> > 0 and -1 for <parameter>x</parameter> <0)</para>
</refsect1>
<refsect1>
@@ -11031,7 +11034,7 @@
<function>GAMMALN</function>
</refname>
<refpurpose>
- natural logarithm of the Gamma function.
+ natural logarithm of the Gamma function
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -11130,7 +11133,7 @@
<function>HYPOT</function>
</refname>
<refpurpose>
- the square root of the sum of the squares of the arguments.
+ the square root of the sum of the squares of the arguments
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -11159,7 +11162,7 @@
<function>INT</function>
</refname>
<refpurpose>
- largest integer not larger than <parameter>x</parameter>
+ largest integer not larger than <parameter>x</parameter>
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -11234,7 +11237,7 @@
<function>LN</function>
</refname>
<refpurpose>
- the natural logarithm of <parameter>x</parameter>.
+ the natural logarithm of <parameter>x</parameter>
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -11312,7 +11315,7 @@
<function>LOG</function>
</refname>
<refpurpose>
- Logarithm
+ logarithm of <parameter>x</parameter> with base <parameter>base</parameter>
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -11350,7 +11353,7 @@
<function>LOG10</function>
</refname>
<refpurpose>
- the base-10 logarithm of <parameter>x</parameter>.
+ the base-10 logarithm of <parameter>x</parameter>
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -11383,7 +11386,7 @@
<function>LOG2</function>
</refname>
<refpurpose>
- the base-2 logarithm of <parameter>x</parameter>.
+ the base-2 logarithm of <parameter>x</parameter>
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -11517,7 +11520,7 @@
<function>MOD</function>
</refname>
<refpurpose>
- the remainder of <parameter>x</parameter> under division by <parameter>n</parameter>
+ the remainder of <parameter>x</parameter> under division by <parameter>n</parameter>
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -11599,7 +11602,7 @@
<function>MULTINOMIAL</function>
</refname>
<refpurpose>
- Multinomial coefficient (<parameter>x1</parameter>+â?¯+<parameter>xn</parameter>) choose (<parameter>x1</parameter>,...,<parameter>xn</parameter>)
+ multinomial coefficient (<parameter>x1</parameter>+â?¯+<parameter>xn</parameter>) choose (<parameter>x1</parameter>,â?¦,<parameter>xn</parameter>)
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -11723,7 +11726,7 @@
<function>POWER</function>
</refname>
<refpurpose>
- the value of <parameter>x</parameter> raised to the power <parameter>y</parameter>.
+ the value of <parameter>x</parameter> raised to the power <parameter>y</parameter>
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -11841,7 +11844,7 @@
<function>RADIANS</function>
</refname>
<refpurpose>
- the number of radians equivalent to <parameter>x</parameter> degrees.
+ the number of radians equivalent to <parameter>x</parameter> degrees
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -11943,7 +11946,7 @@
<refname>
<function>ROUNDDOWN</function>
</refname>
- <refpurpose><parameter>x</parameter> rounded towards 0.
+ <refpurpose><parameter>x</parameter> rounded towards 0
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -11981,7 +11984,7 @@
<refname>
<function>ROUNDUP</function>
</refname>
- <refpurpose><parameter>x</parameter> rounded away from 0.
+ <refpurpose><parameter>x</parameter> rounded away from 0
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -12064,7 +12067,7 @@
<function>SECH</function>
</refname>
<refpurpose>
- Hyperbolic secant
+ the hyperbolic secant of <parameter>x</parameter>
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -12176,7 +12179,7 @@
<function>SIN</function>
</refname>
<refpurpose>
- Sine function
+ the sine of <parameter>x</parameter>
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -12397,8 +12400,8 @@
<refsect1>
<title>Arguments</title>
<para><parameter>range</parameter>: cell area</para>
- <para><parameter>criteria</parameter>: condition for a cell to be summed</para>
- <para><parameter>actual_range</parameter>: cell area, defaults to <parameter>range</parameter></para>
+ <para><parameter>criteria</parameter>: condition for a cell to be summed</para>
+ <para><parameter>actual_range</parameter>: cell area, defaults to <parameter>range</parameter></para>
</refsect1>
<refsect1>
<title>Microsoft Excel Compatibility</title>
@@ -12422,7 +12425,7 @@
<function>SUMPRODUCT</function>
</refname>
<refpurpose>
- Multiplies components and adds the results.
+ multiplies components and adds the results
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -12488,7 +12491,7 @@
<function>SUMX2MY2</function>
</refname>
<refpurpose>
- sum of the difference of squares
+ sum of the difference of squares
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -12525,7 +12528,7 @@
<function>SUMX2PY2</function>
</refname>
<refpurpose>
- sum of the sum of squares
+ sum of the sum of squares
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -12567,7 +12570,7 @@
<function>SUMXMY2</function>
</refname>
<refpurpose>
- sum of the squares of differences
+ sum of the squares of differences
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -12610,7 +12613,7 @@
<function>TAN</function>
</refname>
<refpurpose>
- tangent
+ the tangent of <parameter>x</parameter>
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -12647,7 +12650,7 @@
<function>TANH</function>
</refname>
<refpurpose>
- hyperbolic tangent
+ the hyperbolic tangent of <parameter>x</parameter>
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -12988,7 +12991,7 @@
<function>RAND</function>
</refname>
<refpurpose>
- a random number between zero and one.
+ a random number between zero and one
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -13700,7 +13703,7 @@
<function>RANDNORMTAIL</function>
</refname>
<refpurpose>
- a random variates from the upper tail of a normal distribution with mean 0
+ random variate from the upper tail of a normal distribution with mean 0
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -13856,7 +13859,7 @@
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
- <para><parameter>a</parameter>: amount of skew, defaults to 0</para>
+ <para><parameter>a</parameter>: amount of skew, defaults to 0</para>
<para>@{μ}: mean of the underlying normal distribution, defaults to 0</para>
<para>@{Ï?}: standard deviation of the underlying normal distribution, defaults to 1</para>
</refsect1>
@@ -13890,7 +13893,7 @@
<refsect1>
<title>Arguments</title>
<para><parameter>df</parameter>: degrees of freedom</para>
- <para><parameter>a</parameter>: amount of skew, defaults to 0</para>
+ <para><parameter>a</parameter>: amount of skew, defaults to 0</para>
</refsect1>
<refsect1>
<title>See also</title>
@@ -13997,7 +14000,7 @@
<function>SIMTABLE</function>
</refname>
<refpurpose>
- one of the values in the given argument list depending on the round number of the simulation tool.
+ one of the values in the given argument list depending on the round number of the simulation tool
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -14176,7 +14179,7 @@
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
- <para><parameter>k</parameter>: </para>
+ <para><parameter>k</parameter>: integer</para>
<para><parameter>p</parameter>: probability of success</para>
</refsect1>
<refsect1>
@@ -14208,7 +14211,7 @@
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
- <para><parameter>x</parameter>: </para>
+ <para><parameter>x</parameter>: number</para>
<para><parameter>alpha</parameter>: scale parameter</para>
<para><parameter>beta</parameter>: scale parameter</para>
<para><parameter>a</parameter>: optional lower bound, defaults to 0</para>
@@ -14289,7 +14292,7 @@
<para><parameter>trials</parameter>: number of trials</para>
<para><parameter>p</parameter>: probability of success in each trial</para>
<para><parameter>start</parameter>: start of the interval</para>
- <para><parameter>end</parameter>: start of the interval, defaults to <parameter>start</parameter></para>
+ <para><parameter>end</parameter>: end of the interval, defaults to <parameter>start</parameter></para>
</refsect1>
<refsect1>
<title>Note</title>
@@ -14297,7 +14300,7 @@
</refsect1>
<refsect1>
<title>OpenDocument Format (ODF) Compatibility</title>
- <para>This function is the OpenFormula function B</para>
+ <para>This function is OpenFormula compatible.</para>
</refsect1>
<refsect1>
<title>See also</title>
@@ -14317,7 +14320,7 @@
<function>BINOMDIST</function>
</refname>
<refpurpose>
- (cumulative) probability mass function of the binomial distribution
+ probability mass of cumulative distribution function of the binomial distribution
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -14355,7 +14358,7 @@
<function>CAUCHY</function>
</refname>
<refpurpose>
- (cumulative) probability density function of the Cauchy, Lorentz or Breit-Wigner distribution
+ probability density or cumulative distribution function of the Cauchy, Lorentz or Breit-Wigner distribution
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -14363,7 +14366,7 @@
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
- <para><parameter>x</parameter>: </para>
+ <para><parameter>x</parameter>: number</para>
<para><parameter>a</parameter>: scale parameter</para>
<para><parameter>cumulative</parameter>: whether to evaluate the density function or the cumulative distribution function</para>
</refsect1>
@@ -14396,7 +14399,7 @@
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
- <para><parameter>x</parameter>: </para>
+ <para><parameter>x</parameter>: number</para>
<para><parameter>dof</parameter>: number of degrees of freedom</para>
</refsect1>
<refsect1>
@@ -14766,7 +14769,7 @@
<function>CVMTEST</function>
</refname>
<refpurpose>
- Cramér-von Mises Test of Normality
+ Cramér-von Mises Test of Normality
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -14840,7 +14843,7 @@
<function>EXPONDIST</function>
</refname>
<refpurpose>
- (cumulative)density function of the exponential distribution
+ porbaility density or cumulative distribution function of the exponential distribution
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -14848,7 +14851,7 @@
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
- <para><parameter>x</parameter>: </para>
+ <para><parameter>x</parameter>: number</para>
<para><parameter>y</parameter>: scale parameter</para>
<para><parameter>cumulative</parameter>: whether to evaluate the density function or the cumulative distribution function</para>
</refsect1>
@@ -14881,7 +14884,7 @@
<function>EXPPOWDIST</function>
</refname>
<refpurpose>
- the probability density function of the Exponential Power distribution
+ the probability density function of the Exponential Power distribution
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -14889,7 +14892,7 @@
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
- <para><parameter>x</parameter>: </para>
+ <para><parameter>x</parameter>: number</para>
<para><parameter>a</parameter>: scale parameter</para>
<para><parameter>b</parameter>: scale parameter</para>
</refsect1>
@@ -14922,7 +14925,7 @@
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
- <para><parameter>x</parameter>: </para>
+ <para><parameter>x</parameter>: number</para>
<para><parameter>dof_of_num</parameter>: numerator degrees of freedom</para>
<para><parameter>dof_of_denom</parameter>: denominator degrees of freedom</para>
</refsect1>
@@ -15012,7 +15015,7 @@
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
- <para><parameter>x</parameter>: </para>
+ <para><parameter>x</parameter>: number</para>
</refsect1>
<refsect1>
<title>Note</title>
@@ -15048,7 +15051,7 @@
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
- <para><parameter>x</parameter>: </para>
+ <para><parameter>x</parameter>: number</para>
</refsect1>
<refsect1>
<title>Note</title>
@@ -15080,13 +15083,13 @@
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>FORECAST</function>(<parameter>x</parameter>,<parameter>known_y</parameter>'s,<parameter>known_x</parameter>'s)</synopsis>
+ <synopsis><function>FORECAST</function>(<parameter>x</parameter>,<parameter>known_ys</parameter>,<parameter>known_xs</parameter>)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
<para><parameter>x</parameter>: x-value whose matching y-value should be forecast</para>
- <para>@{known_y's}: known y-values</para>
- <para>@{known_x's}: known x-values</para>
+ <para><parameter>known_ys</parameter>: known y-values</para>
+ <para><parameter>known_xs</parameter>: known x-values</para>
</refsect1>
<refsect1>
<title>Description</title>
@@ -15094,7 +15097,7 @@
</refsect1>
<refsect1>
<title>Note</title>
- <para>If <parameter>known_x</parameter> or <parameter>known_y</parameter> contains no data entries or different number of data entries, this function returns a #N/A error. If the variance of the <parameter>known_x</parameter> is zero, this function returns a #DIV/0 error.</para>
+ <para>If <parameter>known_xs</parameter> or <parameter>known_ys</parameter> contains no data entries or different number of data entries, this function returns a #N/A error. If the variance of the <parameter>known_xs</parameter> is zero, this function returns a #DIV/0 error.</para>
</refsect1>
<refsect1>
<title>Microsoft Excel Compatibility</title>
@@ -15118,7 +15121,7 @@
<function>FREQUENCY</function>
</refname>
<refpurpose>
- the frequency table
+ frequency table
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -15183,7 +15186,7 @@
<function>GAMMADIST</function>
</refname>
<refpurpose>
- (cumulative) density function of the gamma distribution
+ probability density or cumulative distribution function of the gamma distribution
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -15191,7 +15194,7 @@
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
- <para><parameter>x</parameter>: </para>
+ <para><parameter>x</parameter>: number</para>
<para><parameter>alpha</parameter>: scale parameter</para>
<para><parameter>beta</parameter>: scale parameter</para>
<para><parameter>cumulative</parameter>: whether to evaluate the density function or the cumulative distribution function</para>
@@ -15258,7 +15261,7 @@
<function>GEOMDIST</function>
</refname>
<refpurpose>
- (cumulative) probability mass function of the hypergeometric distribution
+ probability mass or cumulative distribution function of the hypergeometric distribution
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -15331,27 +15334,27 @@
<function>GROWTH</function>
</refname>
<refpurpose>
- predicts the exponential growth
+ exponential growth prediction
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>GROWTH</function>(<parameter>known_y</parameter>'s,<parameter>known_x</parameter>'s,<parameter>new_x</parameter>'s,<parameter>const</parameter>)</synopsis>
+ <synopsis><function>GROWTH</function>(<parameter>known_ys</parameter>,<parameter>known_xs</parameter>,<parameter>new_xs</parameter>,<parameter>affine</parameter>)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
- <para>@{known_y's}: known y-values</para>
- <para>@{known_x's}: known x-values; if <parameter>known_x</parameter>'s is omitted, an array {1, 2, 3, ...} is used.</para>
- <para>@{new_x's}: x-values for which you want to estimate the y-values; defaults to <parameter>known_x</parameter>'s</para>
- <para><parameter>const</parameter>: if this is false the line will be forced to go through the origin; defaults to TRUE</para>
+ <para><parameter>known_ys</parameter>: known y-values</para>
+ <para><parameter>known_xs</parameter>: known x-values; defaults to the array {1, 2, 3, â?¦}</para>
+ <para><parameter>new_xs</parameter>: x-values for which to estimate the y-values; defaults to <parameter>known_xs</parameter></para>
+ <para><parameter>affine</parameter>: if true, the model contains a constant term, defaults to true</para>
</refsect1>
<refsect1>
<title>Description</title>
- <para><function>GROWTH</function> function applies the ``least squares'' method to fit an exponential curve to your data and predicts the exponential growth by using this curve.</para>
- <para><function>GROWTH</function> returns an array having one column and a row for each data point in <parameter>new_x</parameter>.</para>
+ <para><function>GROWTH</function> function applies the â??least squaresâ?? method to fit an exponential curve to your data and predicts the exponential growth by using this curve.</para>
+ <para><function>GROWTH</function> returns an array having one column and a row for each data point in <parameter>new_xs</parameter>.</para>
</refsect1>
<refsect1>
<title>Note</title>
- <para>If <parameter>known_y</parameter>'s and <parameter>known_x</parameter>'s have unequal number of data points, this function returns a #NUM! error.</para>
+ <para>If <parameter>known_ys</parameter> and <parameter>known_xs</parameter> have unequal number of data points, this function returns a #NUM! error.</para>
</refsect1>
<refsect1>
<title>See also</title>
@@ -15412,7 +15415,7 @@
<function>HYPGEOMDIST</function>
</refname>
<refpurpose>
- (cumulative) probability mass function of the hypergeometric distribution
+ probability mass or cumulative distribution function of the hypergeometric distribution
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -15456,16 +15459,16 @@
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>INTERCEPT</function>(<parameter>known_y</parameter>'s,<parameter>known_x</parameter>'s)</synopsis>
+ <synopsis><function>INTERCEPT</function>(<parameter>known_ys</parameter>,<parameter>known_xs</parameter>)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
- <para>@{known_y's}: known y-values</para>
- <para>@{known_x's}: known x-values</para>
+ <para><parameter>known_ys</parameter>: known y-values</para>
+ <para><parameter>known_xs</parameter>: known x-values</para>
</refsect1>
<refsect1>
<title>Note</title>
- <para>If <parameter>known_x</parameter> or <parameter>known_y</parameter> contains no data entries or different number of data entries, this function returns a #N/A error. If the variance of the <parameter>known_x</parameter> is zero, this function returns #DIV/0 error.</para>
+ <para>If <parameter>known_xs</parameter> or <parameter>known_ys</parameter> contains no data entries or different number of data entries, this function returns a #N/A error. If the variance of the <parameter>known_xs</parameter> is zero, this function returns #DIV/0 error.</para>
</refsect1>
<refsect1>
<title>Microsoft Excel Compatibility</title>
@@ -15489,7 +15492,7 @@
<function>KURT</function>
</refname>
<refpurpose>
- unbiased estimate of the kurtosis of a data set.
+ unbiased estimate of the kurtosis of a data set
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -15579,7 +15582,7 @@
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
- <para><parameter>x</parameter>: </para>
+ <para><parameter>x</parameter>: number</para>
</refsect1>
<refsect1>
<title>See also</title>
@@ -15606,7 +15609,7 @@
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
- <para><parameter>x</parameter>: </para>
+ <para><parameter>x</parameter>: number</para>
<para><parameter>a</parameter>: mean</para>
</refsect1>
<refsect1>
@@ -15664,28 +15667,28 @@
<function>LINEST</function>
</refname>
<refpurpose>
- determines multiple linear regression coefficients and statistics.
+ multiple linear regression coefficients and statistics
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>LINEST</function>(<parameter>known_y</parameter>'s,<parameter>known_x</parameter>'s,<parameter>affine</parameter>,<parameter>stats</parameter>)</synopsis>
+ <synopsis><function>LINEST</function>(<parameter>known_ys</parameter>,<parameter>known_xs</parameter>,<parameter>affine</parameter>,<parameter>stats</parameter>)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
- <para>@{known_y's}: vector of values of dependent variable.</para>
- <para>@{known_x's}: array of values of independent variables, defaults to a single vector 1,...,n.</para>
- <para><parameter>affine</parameter>: if true, the model contains a constant term, defaults to true.</para>
+ <para><parameter>known_ys</parameter>: vector of values of dependent variable</para>
+ <para><parameter>known_xs</parameter>: array of values of independent variables, defaults to a single vector {1,â?¦,n}</para>
+ <para><parameter>affine</parameter>: if true, the model contains a constant term, defaults to true</para>
<para><parameter>stats</parameter>: if true, some additional statistics are provided, defaults to false</para>
</refsect1>
<refsect1>
<title>Description</title>
- <para>This function returns an array with the first row giving the regression coefficients for the independent variables x_m, x_(m-1),...,x_2, x_1 followed by the y-intercept if <parameter>affine</parameter> is true.</para>
+ <para>This function returns an array with the first row giving the regression coefficients for the independent variables x_m, x_(m-1),â?¦,x_2, x_1 followed by the y-intercept if <parameter>affine</parameter> is true.</para>
<para>If <parameter>stats</parameter> is true, the second row contains the corresponding standard errors of the regression coefficients.In this case, the third row contains the R^2 value and the standard error for the predicted value. The fourth row contains the observed F value and its degrees of freedom. Finally, the fifth row contains the regression sum of squares and the residual sum of squares.</para>
<para>If <parameter>affine</parameter> is false, R^2 is the uncentered version of the coefficient of determination; that is the proportion of the sum of squares explained by the model.</para>
</refsect1>
<refsect1>
<title>Note</title>
- <para>If the length of @{known_y's} does not match the corresponding length of @{known_x's}, this function returns a #NUM! error.</para>
+ <para>If the length of <parameter>known_ys</parameter> does not match the corresponding length of <parameter>known_xs</parameter>, this function returns a #NUM! error.</para>
</refsect1>
<refsect1>
<title>See also</title>
@@ -15747,23 +15750,23 @@
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>LOGEST</function>(<parameter>known_y</parameter>'s,<parameter>known_x</parameter>'s,<parameter>const</parameter>,<parameter>stat</parameter>)</synopsis>
+ <synopsis><function>LOGEST</function>(<parameter>known_ys</parameter>,<parameter>known_xs</parameter>,<parameter>affine</parameter>,<parameter>stat</parameter>)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
- <para>@{known_y's}: known y-values</para>
- <para>@{known_x's}: known x-values; if <parameter>known_x</parameter>'s is omitted, an array {1, 2, 3, ...} is used.</para>
- <para><parameter>const</parameter>: if this is false the line will be forced to go through (0,1); defaults to TRUE</para>
- <para><parameter>stat</parameter>: If <parameter>stat</parameter> is TRUE, extra statistical information will be returned; defaults to FALSE.</para>
+ <para><parameter>known_ys</parameter>: known y-values</para>
+ <para><parameter>known_xs</parameter>: known x-values; default to an array {1, 2, 3, â?¦}</para>
+ <para><parameter>affine</parameter>: if true, the model contains a constant term, defaults to true</para>
+ <para><parameter>stat</parameter>: if true, extra statistical information will be returned; defaults to FALSE</para>
</refsect1>
<refsect1>
<title>Description</title>
- <para><function>LOGEST</function> function applies the ``least squares'' method to fit an exponential curve of the form y = b * m{1}^x{1} * m{2}^x{2}... to your data.</para>
+ <para><function>LOGEST</function> function applies the â??least squaresâ?? method to fit an exponential curve of the form y = b * m{1}^x{1} * m{2}^x{2}... to your data.</para>
<para><function>LOGEST</function> returns an array { m{n},m{n-1}, ...,m{1},b }.</para>
</refsect1>
<refsect1>
<title>Note</title>
- <para>Extra statistical information is written below the regression line coefficients in the result array. Extra statistical information consists of four rows of data. In the first row the standard error values for the coefficients m1, (m2, ...), b are represented. The second row contains the square of R and the standard error for the y estimate. The third row contains the F-observed value and the degrees of freedom. The last row contains the regression sum of squares and the residual sum of squares. If <parameter>known_y</parameter>'s and <parameter>known_x</parameter>'s have unequal number of data points, this function returns a #NUM! error.</para>
+ <para>Extra statistical information is written below the regression line coefficients in the result array. Extra statistical information consists of four rows of data. In the first row the standard error values for the coefficients m1, (m2, ...), b are represented. The second row contains the square of R and the standard error for the y estimate. The third row contains the F-observed value and the degrees of freedom. The last row contains the regression sum of squares and the residual sum of squares. If <parameter>known_ys</parameter> and <parameter>known_xs</parameter> have unequal number of data points, this function returns a #NUM! error.</para>
</refsect1>
<refsect1>
<title>See also</title>
@@ -15787,16 +15790,16 @@
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>LOGFIT</function>(<parameter>known_y</parameter>'s,<parameter>known_x</parameter>'s)</synopsis>
+ <synopsis><function>LOGFIT</function>(<parameter>known_ys</parameter>,<parameter>known_xs</parameter>)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
- <para>@{known_y's}: known y-values</para>
- <para>@{known_x's}: known x-values</para>
+ <para><parameter>known_ys</parameter>: known y-values</para>
+ <para><parameter>known_xs</parameter>: known x-values</para>
</refsect1>
<refsect1>
<title>Description</title>
- <para><function>LOGFIT</function> function applies the ``least squares'' method to fit the logarithmic equation y = a + b * ln(sign * (x - c)) , sign = +1 or -1 to your data. The graph of the equation is a logarithmic curve moved horizontally by c and possibly mirrored across the y-axis (if sign = -1).</para>
+ <para><function>LOGFIT</function> function applies the â??least squaresâ?? method to fit the logarithmic equation y = a + b * ln(sign * (x - c)) , sign = +1 or -1 to your data. The graph of the equation is a logarithmic curve moved horizontally by c and possibly mirrored across the y-axis (if sign = -1).</para>
<para><function>LOGFIT</function> returns an array having five columns and one row. `Sign' is given in the first column, `a', `b', and `c' are given in columns 2 to 4. Column 5 holds the sum of squared residuals.</para>
</refsect1>
<refsect1>
@@ -15871,7 +15874,7 @@
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
- <para><parameter>x</parameter>: </para>
+ <para><parameter>x</parameter>: number</para>
<para><parameter>a</parameter>: scale parameter</para>
</refsect1>
<refsect1>
@@ -15899,7 +15902,7 @@
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
- <para><parameter>x</parameter>: </para>
+ <para><parameter>x</parameter>: number</para>
<para><parameter>mean</parameter>: mean</para>
<para><parameter>stddev</parameter>: standard deviation</para>
</refsect1>
@@ -15932,23 +15935,23 @@
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>LOGREG</function>(<parameter>known_y</parameter>'s,<parameter>known_x</parameter>'s,<parameter>const</parameter>,<parameter>stat</parameter>)</synopsis>
+ <synopsis><function>LOGREG</function>(<parameter>known_ys</parameter>,<parameter>known_xs</parameter>,<parameter>affine</parameter>,<parameter>stat</parameter>)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
- <para>@{known_y's}: known y-values</para>
- <para>@{known_x's}: known x-values; if <parameter>known_x</parameter>'s is omitted, an array {1, 2, 3, ...} is used.</para>
- <para><parameter>const</parameter>: If this is FALSE, the curve will be forced to go through [1; 0], i.e., b will be zero. The default is TRUE.</para>
- <para><parameter>stat</parameter>: If <parameter>stat</parameter> is TRUE, extra statistical information will be returned; defaults to FALSE.</para>
+ <para><parameter>known_ys</parameter>: known y-values</para>
+ <para><parameter>known_xs</parameter>: known x-values; defaults to the array {1, 2, 3, â?¦}</para>
+ <para><parameter>affine</parameter>: if true, the model contains a constant term, defaults to true</para>
+ <para><parameter>stat</parameter>: if true, extra statistical information will be returned; defaults to FALSE</para>
</refsect1>
<refsect1>
<title>Description</title>
- <para><function>LOGREG</function> function transforms your x's to z=ln(x) and applies the ``least squares'' method to fit the linear equation y = m * z + b to your y's and z's --- equivalent to fitting the equation y = m * ln(x) + b to y's and x's. <function>LOGREG</function> returns an array having two columns and one row. m is given in the first column and b in the second. </para>
+ <para><function>LOGREG</function> function transforms your x's to z=ln(x) and applies the â??least squaresâ?? method to fit the linear equation y = m * z + b to your y's and z's --- equivalent to fitting the equation y = m * ln(x) + b to y's and x's. <function>LOGREG</function> returns an array having two columns and one row. m is given in the first column and b in the second. </para>
<para>Any extra statistical information is written below m and b in the result array. This extra statistical information consists of four rows of data: In the first row the standard error values for the coefficients m, b are given. The second row contains the square of R and the standard error for the y estimate. The third row contains the F-observed value and the degrees of freedom. The last row contains the regression sum of squares and the residual sum of squares.The default of <parameter>stat</parameter> is FALSE.</para>
</refsect1>
<refsect1>
<title>Note</title>
- <para>If <parameter>known_y</parameter>'s and <parameter>known_x</parameter>'s have unequal number of data points, this function returns a #NUM! error.</para>
+ <para>If <parameter>known_ys</parameter> and <parameter>known_xs</parameter> have unequal number of data points, this function returns a #NUM! error.</para>
</refsect1>
<refsect1>
<title>See also</title>
@@ -15969,7 +15972,7 @@
<function>MAX</function>
</refname>
<refpurpose>
- largest value, with negative numbers considered smaller than positive numbers.
+ largest value, with negative numbers considered smaller than positive numbers
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -16002,7 +16005,7 @@
<function>MAXA</function>
</refname>
<refpurpose>
- largest value, with negative numbers considered smaller than positive numbers.
+ largest value, with negative numbers considered smaller than positive numbers
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -16234,7 +16237,7 @@
<function>NORMDIST</function>
</refname>
<refpurpose>
- (cumulative) probability density function of a normal distribution
+ probability density or cumulative distribution function of a normal distribution
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -16242,7 +16245,7 @@
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
- <para><parameter>x</parameter>: </para>
+ <para><parameter>x</parameter>: number</para>
<para><parameter>mean</parameter>: mean of the distribution</para>
<para><parameter>stddev</parameter>: standard deviation of the distribution</para>
<para><parameter>cumulative</parameter>: whether to evaluate the density function or the cumulative distribution function</para>
@@ -16321,7 +16324,7 @@
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
- <para><parameter>x</parameter>: </para>
+ <para><parameter>x</parameter>: number</para>
</refsect1>
<refsect1>
<title>Microsoft Excel Compatibility</title>
@@ -16399,7 +16402,7 @@
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
- <para><parameter>x</parameter>: </para>
+ <para><parameter>x</parameter>: number</para>
<para><parameter>a</parameter>: exponent</para>
<para><parameter>b</parameter>: scale parameter</para>
</refsect1>
@@ -16496,7 +16499,7 @@
<function>PERCENTRANK</function>
</refname>
<refpurpose>
- rank of a data point in a data set.
+ rank of a data point in a data set
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -16571,7 +16574,7 @@
<function>PERMUTATIONA</function>
</refname>
<refpurpose>
- the number of permutations of <parameter>y</parameter> objects chosen from <parameter>x</parameter> objects with repetition allowed.
+ the number of permutations of <parameter>y</parameter> objects chosen from <parameter>x</parameter> objects with repetition allowed
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -16607,7 +16610,7 @@
<function>POISSON</function>
</refname>
<refpurpose>
- (cumulative) probability mass function of the Poisson distribution
+ probability mass or cumulative distribution function of the Poisson distribution
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -16693,11 +16696,11 @@
<refsect1>
<title>Arguments</title>
<para><parameter>array</parameter>: data points</para>
- <para><parameter>quart</parameter>: A number from 0 to 4, indicating which quartile to calculate. A value of 0 causes the smallest value of <parameter>array</parameter> to be returned.</para>
+ <para><parameter>quart</parameter>: a number from 0 to 4, indicating which quartile to calculate</para>
</refsect1>
<refsect1>
<title>Note</title>
- <para>If <parameter>array</parameter> is empty, this function returns a #NUM! error. If <parameter>quart</parameter> < 0 or <parameter>quart</parameter> > 4, this function returns a #NUM! error. If <parameter>quart</parameter> is not an integer, it is truncated.</para>
+ <para>If <parameter>array</parameter> is empty, this function returns a #NUM! error. If <parameter>quart</parameter> < 0 or <parameter>quart</parameter> > 4, this function returns a #NUM! error. If <parameter>quart</parameter> = 0, the smallest value of <parameter>array</parameter> to be returned. If <parameter>quart</parameter> is not an integer, it is truncated.</para>
</refsect1>
<refsect1>
<title>Microsoft Excel Compatibility</title>
@@ -18440,7 +18443,7 @@
<title>Arguments</title>
<para><parameter>x</parameter>: number whose rank you want to find</para>
<para><parameter>ref</parameter>: list of numbers</para>
- <para><parameter>order</parameter>: If this is 0, numbers are ranked in descending order, otherwise numbers are ranked in ascending order. Defaults to 0.</para>
+ <para><parameter>order</parameter>: 0 (descending order) or non-zero (ascending order); defaults to 0</para>
</refsect1>
<refsect1>
<title>Note</title>
@@ -18478,7 +18481,7 @@
<title>Arguments</title>
<para><parameter>x</parameter>: number whose rank you want to find</para>
<para><parameter>ref</parameter>: list of numbers</para>
- <para><parameter>order</parameter>: If this is 0, numbers are ranked in descending order, otherwise numbers are ranked in ascending order. Defaults to 0.</para>
+ <para><parameter>order</parameter>: 0 (descending order) or non-zero (ascending order); defaults to 0</para>
</refsect1>
<refsect1>
<title>Note</title>
@@ -18514,7 +18517,7 @@
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
- <para><parameter>x</parameter>: </para>
+ <para><parameter>x</parameter>: number</para>
<para><parameter>sigma</parameter>: scale parameter</para>
</refsect1>
<refsect1>
@@ -18542,7 +18545,7 @@
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
- <para><parameter>x</parameter>: </para>
+ <para><parameter>x</parameter>: number</para>
<para><parameter>a</parameter>: lower limit</para>
<para><parameter>sigma</parameter>: scale parameter</para>
</refsect1>
@@ -18731,16 +18734,16 @@
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>SLOPE</function>(<parameter>known_y</parameter>'s,<parameter>known_x</parameter>'s)</synopsis>
+ <synopsis><function>SLOPE</function>(<parameter>known_ys</parameter>,<parameter>known_xs</parameter>)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
- <para>@{known_y's}: known y-values</para>
- <para>@{known_x's}: known x-values</para>
+ <para><parameter>known_ys</parameter>: known y-values</para>
+ <para><parameter>known_xs</parameter>: known x-values</para>
</refsect1>
<refsect1>
<title>Note</title>
- <para>If <parameter>known_x</parameter> or <parameter>known_y</parameter> contains no data entries or different number of data entries, this function returns a #N/A error. If the variance of the <parameter>known_x</parameter> is zero, this function returns #DIV/0 error.</para>
+ <para>If <parameter>known_xs</parameter> or <parameter>known_ys</parameter> contains no data entries or different number of data entries, this function returns a #N/A error. If the variance of the <parameter>known_xs</parameter> is zero, this function returns #DIV/0 error.</para>
</refsect1>
<refsect1>
<title>Microsoft Excel Compatibility</title>
@@ -18763,7 +18766,7 @@
<refname>
<function>SMALL</function>
</refname>
- <refpurpose><parameter>k</parameter>-th smallest value in a data set.
+ <refpurpose><parameter>k</parameter>-th smallest value in a data set
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -18917,7 +18920,7 @@
<function>STDEVA</function>
</refname>
<refpurpose>
- sample standard deviation of the given sample.
+ sample standard deviation of the given sample
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -18994,7 +18997,7 @@
<function>STDEVPA</function>
</refname>
<refpurpose>
- population standard deviation of an entire population.
+ population standard deviation of an entire population
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -19036,16 +19039,16 @@
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>STEYX</function>(<parameter>known_y</parameter>'s,<parameter>known_x</parameter>'s)</synopsis>
+ <synopsis><function>STEYX</function>(<parameter>known_ys</parameter>,<parameter>known_xs</parameter>)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
- <para>@{known_y's}: known y-values</para>
- <para>@{known_x's}: known x-values</para>
+ <para><parameter>known_ys</parameter>: known y-values</para>
+ <para><parameter>known_xs</parameter>: known x-values</para>
</refsect1>
<refsect1>
<title>Note</title>
- <para>If <parameter>known_y</parameter>'s and <parameter>known_x</parameter>'s are empty or have a different number of arguments then this function returns a #N/A error.</para>
+ <para>If <parameter>known_ys</parameter> and <parameter>known_xs</parameter> are empty or have a different number of arguments then this function returns a #N/A error.</para>
</refsect1>
<refsect1>
<title>Microsoft Excel Compatibility</title>
@@ -19123,9 +19126,9 @@
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
- <para><parameter>x</parameter>: </para>
+ <para><parameter>x</parameter>: number</para>
<para><parameter>dof</parameter>: number of degrees of freedom</para>
- <para><parameter>tails</parameter>: 1 or 2.</para>
+ <para><parameter>tails</parameter>: 1 or 2</para>
</refsect1>
<refsect1>
<title>Description</title>
@@ -19199,18 +19202,18 @@
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>TREND</function>(<parameter>known_y</parameter>'s,<parameter>known_x</parameter>'s,<parameter>new_x</parameter>'s,<parameter>const</parameter>)</synopsis>
+ <synopsis><function>TREND</function>(<parameter>known_ys</parameter>,<parameter>known_xs</parameter>,<parameter>new_xs</parameter>,<parameter>affine</parameter>)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
- <para>@{known_y's}: known y-values</para>
- <para>@{known_x's}: known x-values; if <parameter>known_x</parameter>'s is omitted, an array {1, 2, 3, ...} is used.</para>
- <para>@{new_x's}: x-values for which you want to estimate the y-values; defaults to <parameter>known_x</parameter>'s</para>
- <para><parameter>const</parameter>: if this is false the line will be forced to go through the origin; defaults to TRUE</para>
+ <para><parameter>known_ys</parameter>: known y-values</para>
+ <para><parameter>known_xs</parameter>: known x-values; defaults to the array {1, 2, 3, â?¦}</para>
+ <para><parameter>new_xs</parameter>: x-values for which to estimate the y-values; defaults to <parameter>known_xs</parameter></para>
+ <para><parameter>affine</parameter>: if true, the model contains a constant term, defaults to true</para>
</refsect1>
<refsect1>
<title>Note</title>
- <para>If @{known_y's} and @{known_x's} have unequal number of data points, this function returns a #NUM! error.</para>
+ <para>If <parameter>known_ys</parameter> and <parameter>known_xs</parameter> have unequal number of data points, this function returns a #NUM! error.</para>
</refsect1>
<refsect1>
<title>See also</title>
@@ -19467,7 +19470,7 @@
<function>WEIBULL</function>
</refname>
<refpurpose>
- (cumulative) probability density function of the Weibull distribution
+ probability density or cumulative distribution function of the Weibull distribution
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -19475,7 +19478,7 @@
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
- <para><parameter>x</parameter>: </para>
+ <para><parameter>x</parameter>: number</para>
<para><parameter>alpha</parameter>: scale parameter</para>
<para><parameter>beta</parameter>: scale parameter</para>
<para><parameter>cumulative</parameter>: whether to evaluate the density function or the cumulative distribution function</para>
@@ -19562,7 +19565,7 @@
<function>ASC</function>
</refname>
<refpurpose>
- text with full-width katakana and ASCII characters converted to half-width.
+ text with full-width katakana and ASCII characters converted to half-width
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -19606,7 +19609,7 @@
<function>CHAR</function>
</refname>
<refpurpose>
- the CP1252 (Windows-1252) character for the code point <parameter>x</parameter>.
+ the CP1252 (Windows-1252) character for the code point <parameter>x</parameter>
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -19712,7 +19715,7 @@
<function>CONCATENATE</function>
</refname>
<refpurpose>
- the concatenation of the strings <parameter>s1</parameter>, <parameter>s2</parameter>,...
+ the concatenation of the strings <parameter>s1</parameter>, <parameter>s2</parameter>,â?¦
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -19745,7 +19748,7 @@
<refname>
<function>DOLLAR</function>
</refname>
- <refpurpose><parameter>num</parameter> formatted as currency.
+ <refpurpose><parameter>num</parameter> formatted as currency
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -19936,7 +19939,7 @@
<function>JIS</function>
</refname>
<refpurpose>
- text with half-width katakana and ASCII characters converted to full-width.
+ text with half-width katakana and ASCII characters converted to full-width
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -20137,7 +20140,7 @@
<function>LOWER</function>
</refname>
<refpurpose>
- a lower-case version of the string <parameter>text</parameter>.
+ a lower-case version of the string <parameter>text</parameter>
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -20293,7 +20296,7 @@
<refname>
<function>PROPER</function>
</refname>
- <refpurpose><parameter>text</parameter> with initial of each word capitalised.
+ <refpurpose><parameter>text</parameter> with initial of each word capitalised
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -20325,7 +20328,7 @@
<function>REPLACE</function>
</refname>
<refpurpose>
- String <parameter>old</parameter> with <parameter>num</parameter> characters starting at <parameter>start</parameter> replaced by <parameter>new</parameter>
+ string <parameter>old</parameter> with <parameter>num</parameter> characters starting at <parameter>start</parameter> replaced by <parameter>new</parameter>
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -20720,7 +20723,7 @@
<refname>
<function>TRIM</function>
</refname>
- <refpurpose><parameter>text</parameter> with only single spaces between words.
+ <refpurpose><parameter>text</parameter> with only single spaces between words
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -20754,7 +20757,7 @@
<function>UNICHAR</function>
</refname>
<refpurpose>
- the Unicode character represented by the Unicode code point <parameter>x</parameter>.
+ the Unicode character represented by the Unicode code point <parameter>x</parameter>
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -20812,7 +20815,7 @@
<function>UPPER</function>
</refname>
<refpurpose>
- an upper-case version of the string <parameter>text</parameter>.
+ an upper-case version of the string <parameter>text</parameter>
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -20879,7 +20882,7 @@
<function>FOURIER</function>
</refname>
<refpurpose>
- Fourier or inverse Fourier transform.
+ Fourier or inverse Fourier transform
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -20887,7 +20890,7 @@
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
- <para><parameter>Sequence</parameter>: the data sequence to be transformed</para>
+ <para><parameter>Sequence</parameter>: the data sequence to be transformed</para>
<para><parameter>Inverse</parameter>: if false, the inverse Fourier transform is calculated. Defaults to false</para>
</refsect1>
<refsect1>
@@ -20911,18 +20914,18 @@
<function>INTERPOLATION</function>
</refname>
<refpurpose>
- interpolated values corresponding to the given abscissa targets.
+ interpolated values corresponding to the given abscissa targets
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>INTERPOLATION</function>(<parameter>abscissas</parameter>,<parameter>ordinates</parameter>,<parameter>targets</parameter>,<parameter>interpolation</parameter>)</synopsis>
+ <synopsis><function>INTERPOLATION</function>(<parameter>abscissae</parameter>,<parameter>ordinates</parameter>,<parameter>targets</parameter>,<parameter>interpolation</parameter>)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
- <para><parameter>abscissas</parameter>: The abscissas of the data to interpolate.</para>
- <para><parameter>ordinates</parameter>: The ordinates of the data to interpolate.</para>
- <para><parameter>targets</parameter>: The abscissas of the interpolated data.</para>
- <para><parameter>interpolation</parameter>: The method of interpolation to be used, defaults to no interpolation</para>
+ <para><parameter>abscissae</parameter>: abscissae of the given data points</para>
+ <para><parameter>ordinates</parameter>: ordinates of the given data points</para>
+ <para><parameter>targets</parameter>: abscissae of the interpolated data</para>
+ <para><parameter>interpolation</parameter>: method of interpolation, defaults to none</para>
</refsect1>
<refsect1>
<title>Description</title>
@@ -20938,7 +20941,7 @@
</refsect1>
<refsect1>
<title>Note</title>
- <para>Strings and empty cells in <parameter>abscissas</parameter> and <parameter>ordinates</parameter> are ignored. If several target data are provided they must be in the same column in consecutive cells.</para>
+ <para>Strings and empty cells in <parameter>abscissae</parameter> and <parameter>ordinates</parameter> are ignored. If several target data are provided they must be in the same column in consecutive cells.</para>
</refsect1>
<refsect1>
<title>See also</title>
@@ -20957,19 +20960,19 @@
<function>PERIODOGRAM</function>
</refname>
<refpurpose>
- Periodogram of the given data.
+ periodogram of the given data
</refpurpose>
</refnamediv>
<refsynopsisdiv>
- <synopsis><function>PERIODOGRAM</function>(<parameter>ordinates</parameter>,<parameter>filter</parameter>,<parameter>abscissas</parameter>,<parameter>interpolation</parameter>,<parameter>number</parameter>)</synopsis>
+ <synopsis><function>PERIODOGRAM</function>(<parameter>ordinates</parameter>,<parameter>filter</parameter>,<parameter>abscissae</parameter>,<parameter>interpolation</parameter>,<parameter>number</parameter>)</synopsis>
</refsynopsisdiv>
<refsect1>
<title>Arguments</title>
- <para><parameter>ordinates</parameter>: The ordinates of the data to interpolate.</para>
- <para><parameter>filter</parameter>: Window function to be used, defaults to no window function.</para>
- <para><parameter>abscissas</parameter>: The abscissas of the data to interpolate, defaults to regularly spaced abscissa.</para>
- <para><parameter>interpolation</parameter>: The method of interpolation to be used, defaults to no interpolation</para>
- <para><parameter>number</parameter>: Number of interpolated data points to be used.</para>
+ <para><parameter>ordinates</parameter>: ordinates of the given data</para>
+ <para><parameter>filter</parameter>: windowing function to be used, defaults to no filter</para>
+ <para><parameter>abscissae</parameter>: abscissae of the given data, defaults to regularly spaced abscissae</para>
+ <para><parameter>interpolation</parameter>: method of interpolation, defaults to none</para>
+ <para><parameter>number</parameter>: number of interpolated data points</para>
</refsect1>
<refsect1>
<title>Description</title>
@@ -20990,7 +20993,7 @@
</refsect1>
<refsect1>
<title>Note</title>
- <para>Strings and empty cells in <parameter>abscissas</parameter> and <parameter>ordinates</parameter> are ignored. If several target data are provided they must be in the same column in consecutive cells.</para>
+ <para>Strings and empty cells in <parameter>abscissae</parameter> and <parameter>ordinates</parameter> are ignored. If several target data are provided they must be in the same column in consecutive cells.</para>
</refsect1>
<refsect1>
<title>See also</title>
diff --git a/doc/ChangeLog b/doc/ChangeLog
index fbf28e5..5f5a7a0 100644
--- a/doc/ChangeLog
+++ b/doc/ChangeLog
@@ -1,3 +1,7 @@
+2010-06-16 Morten Welinder <terra gnome org>
+
+ * Release 1.10.6
+
2010-05-30 Morten Welinder <terra gnome org>
* Release 1.10.5
diff --git a/doc/de/ChangeLog b/doc/de/ChangeLog
index 926eb7a..774863b 100644
--- a/doc/de/ChangeLog
+++ b/doc/de/ChangeLog
@@ -1,3 +1,7 @@
+2010-06-16 Morten Welinder <terra gnome org>
+
+ * Release 1.10.6
+
2010-05-30 Morten Welinder <terra gnome org>
* Release 1.10.5
diff --git a/plugins/applix/ChangeLog b/plugins/applix/ChangeLog
index 59f6d47..664bf31 100644
--- a/plugins/applix/ChangeLog
+++ b/plugins/applix/ChangeLog
@@ -1,3 +1,7 @@
+2010-06-16 Morten Welinder <terra gnome org>
+
+ * Release 1.10.6
+
2010-05-30 Morten Welinder <terra gnome org>
* Release 1.10.5
diff --git a/plugins/corba/ChangeLog b/plugins/corba/ChangeLog
index bf4c149..aab6b14 100644
--- a/plugins/corba/ChangeLog
+++ b/plugins/corba/ChangeLog
@@ -1,3 +1,7 @@
+2010-06-16 Morten Welinder <terra gnome org>
+
+ * Release 1.10.6
+
2010-05-30 Morten Welinder <terra gnome org>
* Release 1.10.5
diff --git a/plugins/dif/ChangeLog b/plugins/dif/ChangeLog
index b9cd0f6..a195779 100644
--- a/plugins/dif/ChangeLog
+++ b/plugins/dif/ChangeLog
@@ -1,3 +1,7 @@
+2010-06-16 Morten Welinder <terra gnome org>
+
+ * Release 1.10.6
+
2010-05-30 Morten Welinder <terra gnome org>
* Release 1.10.5
diff --git a/plugins/excel/ChangeLog b/plugins/excel/ChangeLog
index 4bcac03..5484b3f 100644
--- a/plugins/excel/ChangeLog
+++ b/plugins/excel/ChangeLog
@@ -1,3 +1,7 @@
+2010-06-16 Morten Welinder <terra gnome org>
+
+ * Release 1.10.6
+
2010-05-30 Morten Welinder <terra gnome org>
* Release 1.10.5
diff --git a/plugins/fn-christian-date/ChangeLog b/plugins/fn-christian-date/ChangeLog
index 7fa8e10..336157b 100644
--- a/plugins/fn-christian-date/ChangeLog
+++ b/plugins/fn-christian-date/ChangeLog
@@ -1,3 +1,7 @@
+2010-06-16 Morten Welinder <terra gnome org>
+
+ * Release 1.10.6
+
2010-05-30 Morten Welinder <terra gnome org>
* Release 1.10.5
diff --git a/plugins/fn-complex/ChangeLog b/plugins/fn-complex/ChangeLog
index f500ba4..b861f8d 100644
--- a/plugins/fn-complex/ChangeLog
+++ b/plugins/fn-complex/ChangeLog
@@ -1,3 +1,7 @@
+2010-06-16 Morten Welinder <terra gnome org>
+
+ * Release 1.10.6
+
2010-06-14 Andreas J. Guelzow <aguelzow pyrshep ca>
* functions.c: remove inconsistent periods, etc.
diff --git a/plugins/fn-database/ChangeLog b/plugins/fn-database/ChangeLog
index 4d2ab7d..1886b61 100644
--- a/plugins/fn-database/ChangeLog
+++ b/plugins/fn-database/ChangeLog
@@ -1,3 +1,7 @@
+2010-06-16 Morten Welinder <terra gnome org>
+
+ * Release 1.10.6
+
2010-05-30 Morten Welinder <terra gnome org>
* Release 1.10.5
diff --git a/plugins/fn-date/ChangeLog b/plugins/fn-date/ChangeLog
index 3a44268..78b9514 100644
--- a/plugins/fn-date/ChangeLog
+++ b/plugins/fn-date/ChangeLog
@@ -1,3 +1,7 @@
+2010-06-16 Morten Welinder <terra gnome org>
+
+ * Release 1.10.6
+
2010-06-14 Andreas J. Guelzow <aguelzow pyrshep ca>
* functions.c: remove inconsistent periods, etc.
diff --git a/plugins/fn-derivatives/ChangeLog b/plugins/fn-derivatives/ChangeLog
index c51c64d..802fcdc 100644
--- a/plugins/fn-derivatives/ChangeLog
+++ b/plugins/fn-derivatives/ChangeLog
@@ -1,3 +1,7 @@
+2010-06-16 Morten Welinder <terra gnome org>
+
+ * Release 1.10.6
+
2010-06-14 Andreas J. Guelzow <aguelzow pyrshep ca>
* functions.c: remove inconsistent periods, etc.
diff --git a/plugins/fn-eng/ChangeLog b/plugins/fn-eng/ChangeLog
index 6d23d08..76669ab 100644
--- a/plugins/fn-eng/ChangeLog
+++ b/plugins/fn-eng/ChangeLog
@@ -1,3 +1,7 @@
+2010-06-16 Morten Welinder <terra gnome org>
+
+ * Release 1.10.6
+
2010-06-10 Andreas J. Guelzow <aguelzow pyrshep ca>
* functions.c: remove superfluous spaces, inconsitent periods, etc.
diff --git a/plugins/fn-erlang/ChangeLog b/plugins/fn-erlang/ChangeLog
index 3a6abdc..b4aaa49 100644
--- a/plugins/fn-erlang/ChangeLog
+++ b/plugins/fn-erlang/ChangeLog
@@ -1,3 +1,7 @@
+2010-06-16 Morten Welinder <terra gnome org>
+
+ * Release 1.10.6
+
2010-05-30 Morten Welinder <terra gnome org>
* Release 1.10.5
diff --git a/plugins/fn-financial/ChangeLog b/plugins/fn-financial/ChangeLog
index 587a889..2808e29 100644
--- a/plugins/fn-financial/ChangeLog
+++ b/plugins/fn-financial/ChangeLog
@@ -1,3 +1,7 @@
+2010-06-16 Morten Welinder <terra gnome org>
+
+ * Release 1.10.6
+
2010-06-14 Andreas J. Guelzow <aguelzow pyrshep ca>
* functions.c: remove inconsistent periods, etc.
diff --git a/plugins/fn-hebrew-date/ChangeLog b/plugins/fn-hebrew-date/ChangeLog
index a5b2241..655a95f 100644
--- a/plugins/fn-hebrew-date/ChangeLog
+++ b/plugins/fn-hebrew-date/ChangeLog
@@ -1,3 +1,7 @@
+2010-06-16 Morten Welinder <terra gnome org>
+
+ * Release 1.10.6
+
2010-05-30 Morten Welinder <terra gnome org>
* Release 1.10.5
diff --git a/plugins/fn-info/ChangeLog b/plugins/fn-info/ChangeLog
index 051f771..5bb0a43 100644
--- a/plugins/fn-info/ChangeLog
+++ b/plugins/fn-info/ChangeLog
@@ -1,3 +1,7 @@
+2010-06-16 Morten Welinder <terra gnome org>
+
+ * Release 1.10.6
+
2010-06-10 Andreas J. Guelzow <aguelzow pyrshep ca>
* functions.c: remove superfluous spaces, inconsitent periods, etc.
diff --git a/plugins/fn-logical/ChangeLog b/plugins/fn-logical/ChangeLog
index 5cd6c18..9c69212 100644
--- a/plugins/fn-logical/ChangeLog
+++ b/plugins/fn-logical/ChangeLog
@@ -1,3 +1,7 @@
+2010-06-16 Morten Welinder <terra gnome org>
+
+ * Release 1.10.6
+
2010-06-14 Andreas J. Guelzow <aguelzow pyrshep ca>
* functions.c: remove inconsistent periods, etc.
diff --git a/plugins/fn-lookup/ChangeLog b/plugins/fn-lookup/ChangeLog
index aab5eec..e9c92ea 100644
--- a/plugins/fn-lookup/ChangeLog
+++ b/plugins/fn-lookup/ChangeLog
@@ -1,3 +1,7 @@
+2010-06-16 Morten Welinder <terra gnome org>
+
+ * Release 1.10.6
+
2010-06-15 Andreas J. Guelzow <aguelzow pyrshep ca>
* functions.c: fix empty argument descriptions
diff --git a/plugins/fn-math/ChangeLog b/plugins/fn-math/ChangeLog
index 2af0d2d..f1ff956 100644
--- a/plugins/fn-math/ChangeLog
+++ b/plugins/fn-math/ChangeLog
@@ -1,3 +1,7 @@
+2010-06-16 Morten Welinder <terra gnome org>
+
+ * Release 1.10.6
+
2010-06-10 Andreas J. Guelzow <aguelzow pyrshep ca>
* functions.c (help_multinomial): fix invalid utf-8.
diff --git a/plugins/fn-numtheory/ChangeLog b/plugins/fn-numtheory/ChangeLog
index c93becf..31a86a8 100644
--- a/plugins/fn-numtheory/ChangeLog
+++ b/plugins/fn-numtheory/ChangeLog
@@ -1,3 +1,7 @@
+2010-06-16 Morten Welinder <terra gnome org>
+
+ * Release 1.10.6
+
2010-05-30 Morten Welinder <terra gnome org>
* Release 1.10.5
diff --git a/plugins/fn-numtheory/doc/ChangeLog b/plugins/fn-numtheory/doc/ChangeLog
index 4363350..2d689d9 100644
--- a/plugins/fn-numtheory/doc/ChangeLog
+++ b/plugins/fn-numtheory/doc/ChangeLog
@@ -1,3 +1,7 @@
+2010-06-16 Morten Welinder <terra gnome org>
+
+ * Release 1.10.6
+
2010-05-30 Morten Welinder <terra gnome org>
* Release 1.10.5
diff --git a/plugins/fn-r/ChangeLog b/plugins/fn-r/ChangeLog
index fa4783b..90e398d 100644
--- a/plugins/fn-r/ChangeLog
+++ b/plugins/fn-r/ChangeLog
@@ -1,3 +1,7 @@
+2010-06-16 Morten Welinder <terra gnome org>
+
+ * Release 1.10.6
+
2010-05-30 Morten Welinder <terra gnome org>
* Release 1.10.5
diff --git a/plugins/fn-random/ChangeLog b/plugins/fn-random/ChangeLog
index bd83dd6..1d12eea 100644
--- a/plugins/fn-random/ChangeLog
+++ b/plugins/fn-random/ChangeLog
@@ -1,3 +1,7 @@
+2010-06-16 Morten Welinder <terra gnome org>
+
+ * Release 1.10.6
+
2010-06-11 Morten Welinder <terra gnome org>
* functions.c (gnumeric_randlevy): Fix extraction of beta.
diff --git a/plugins/fn-stat/ChangeLog b/plugins/fn-stat/ChangeLog
index fba162c..3c5f1c5 100644
--- a/plugins/fn-stat/ChangeLog
+++ b/plugins/fn-stat/ChangeLog
@@ -1,3 +1,7 @@
+2010-06-16 Morten Welinder <terra gnome org>
+
+ * Release 1.10.6
+
2010-06-15 Morten Welinder <terra gnome org>
* functions.c (gnumeric_growth): Handle missing data.
diff --git a/plugins/fn-string/ChangeLog b/plugins/fn-string/ChangeLog
index 1762634..f5f9f71 100644
--- a/plugins/fn-string/ChangeLog
+++ b/plugins/fn-string/ChangeLog
@@ -1,3 +1,7 @@
+2010-06-16 Morten Welinder <terra gnome org>
+
+ * Release 1.10.6
+
2010-06-10 Andreas J. Guelzow <aguelzow pyrshep ca>
* functions.c: remove superfluous spaces, inconsitent periods, etc.
diff --git a/plugins/fn-tsa/ChangeLog b/plugins/fn-tsa/ChangeLog
index 2e089c5..047cf2d 100644
--- a/plugins/fn-tsa/ChangeLog
+++ b/plugins/fn-tsa/ChangeLog
@@ -1,3 +1,7 @@
+2010-06-16 Morten Welinder <terra gnome org>
+
+ * Release 1.10.6
+
2010-06-14 Andreas J. Guelzow <aguelzow pyrshep ca>
* functions.c: remove inconsistent periods, etc.
diff --git a/plugins/gda/ChangeLog b/plugins/gda/ChangeLog
index a52c1b4..7f6bcb0 100644
--- a/plugins/gda/ChangeLog
+++ b/plugins/gda/ChangeLog
@@ -1,3 +1,7 @@
+2010-06-16 Morten Welinder <terra gnome org>
+
+ * Release 1.10.6
+
2010-05-30 Morten Welinder <terra gnome org>
* Release 1.10.5
diff --git a/plugins/glpk/ChangeLog b/plugins/glpk/ChangeLog
index 363205d..649df6d 100644
--- a/plugins/glpk/ChangeLog
+++ b/plugins/glpk/ChangeLog
@@ -1,3 +1,7 @@
+2010-06-16 Morten Welinder <terra gnome org>
+
+ * Release 1.10.6
+
2010-05-30 Morten Welinder <terra gnome org>
* Release 1.10.5
diff --git a/plugins/gnome-db/ChangeLog b/plugins/gnome-db/ChangeLog
index 11acfe8..6cbfdb1 100644
--- a/plugins/gnome-db/ChangeLog
+++ b/plugins/gnome-db/ChangeLog
@@ -1,3 +1,7 @@
+2010-06-16 Morten Welinder <terra gnome org>
+
+ * Release 1.10.6
+
2010-05-30 Morten Welinder <terra gnome org>
* Release 1.10.5
diff --git a/plugins/gnome-glossary/ChangeLog b/plugins/gnome-glossary/ChangeLog
index 71411fc..23d926b 100644
--- a/plugins/gnome-glossary/ChangeLog
+++ b/plugins/gnome-glossary/ChangeLog
@@ -1,3 +1,7 @@
+2010-06-16 Morten Welinder <terra gnome org>
+
+ * Release 1.10.6
+
2010-05-30 Morten Welinder <terra gnome org>
* Release 1.10.5
diff --git a/plugins/guile/ChangeLog b/plugins/guile/ChangeLog
index 0ff922c..01b0f48 100644
--- a/plugins/guile/ChangeLog
+++ b/plugins/guile/ChangeLog
@@ -1,3 +1,7 @@
+2010-06-16 Morten Welinder <terra gnome org>
+
+ * Release 1.10.6
+
2010-05-30 Morten Welinder <terra gnome org>
* Release 1.10.5
diff --git a/plugins/html/ChangeLog b/plugins/html/ChangeLog
index d0803d8..4ccf5b0 100644
--- a/plugins/html/ChangeLog
+++ b/plugins/html/ChangeLog
@@ -1,3 +1,7 @@
+2010-06-16 Morten Welinder <terra gnome org>
+
+ * Release 1.10.6
+
2010-05-30 Morten Welinder <terra gnome org>
* Release 1.10.5
diff --git a/plugins/lotus-123/ChangeLog b/plugins/lotus-123/ChangeLog
index 9577c88..07fca9f 100644
--- a/plugins/lotus-123/ChangeLog
+++ b/plugins/lotus-123/ChangeLog
@@ -1,3 +1,7 @@
+2010-06-16 Morten Welinder <terra gnome org>
+
+ * Release 1.10.6
+
2010-05-30 Morten Welinder <terra gnome org>
* Release 1.10.5
diff --git a/plugins/lpsolve/ChangeLog b/plugins/lpsolve/ChangeLog
index adfc76c..e721ec8 100644
--- a/plugins/lpsolve/ChangeLog
+++ b/plugins/lpsolve/ChangeLog
@@ -1,3 +1,7 @@
+2010-06-16 Morten Welinder <terra gnome org>
+
+ * Release 1.10.6
+
2010-05-30 Morten Welinder <terra gnome org>
* Release 1.10.5
diff --git a/plugins/mps/ChangeLog b/plugins/mps/ChangeLog
index 823c48c..33b3e9c 100644
--- a/plugins/mps/ChangeLog
+++ b/plugins/mps/ChangeLog
@@ -1,3 +1,7 @@
+2010-06-16 Morten Welinder <terra gnome org>
+
+ * Release 1.10.6
+
2010-05-30 Morten Welinder <terra gnome org>
* Release 1.10.5
diff --git a/plugins/nlsolve/ChangeLog b/plugins/nlsolve/ChangeLog
index 14d2b31..148335a 100644
--- a/plugins/nlsolve/ChangeLog
+++ b/plugins/nlsolve/ChangeLog
@@ -1,3 +1,7 @@
+2010-06-16 Morten Welinder <terra gnome org>
+
+ * Release 1.10.6
+
2010-06-01 Morten Welinder <terra gnome org>
* gnm-nlsolve.c (rosenbrock_iter): Only allow first newton
diff --git a/plugins/oleo/ChangeLog b/plugins/oleo/ChangeLog
index 73535d8..2046d63 100644
--- a/plugins/oleo/ChangeLog
+++ b/plugins/oleo/ChangeLog
@@ -1,3 +1,7 @@
+2010-06-16 Morten Welinder <terra gnome org>
+
+ * Release 1.10.6
+
2010-05-30 Morten Welinder <terra gnome org>
* Release 1.10.5
diff --git a/plugins/openoffice/ChangeLog b/plugins/openoffice/ChangeLog
index c7faf8c..da60cbd 100644
--- a/plugins/openoffice/ChangeLog
+++ b/plugins/openoffice/ChangeLog
@@ -1,3 +1,7 @@
+2010-06-16 Morten Welinder <terra gnome org>
+
+ * Release 1.10.6
+
2010-05-30 Morten Welinder <terra gnome org>
* Release 1.10.5
diff --git a/plugins/paradox/ChangeLog b/plugins/paradox/ChangeLog
index d5e16ba..3964405 100644
--- a/plugins/paradox/ChangeLog
+++ b/plugins/paradox/ChangeLog
@@ -1,3 +1,7 @@
+2010-06-16 Morten Welinder <terra gnome org>
+
+ * Release 1.10.6
+
2010-05-30 Morten Welinder <terra gnome org>
* Release 1.10.5
diff --git a/plugins/perl-func/ChangeLog b/plugins/perl-func/ChangeLog
index a71f060..4580740 100644
--- a/plugins/perl-func/ChangeLog
+++ b/plugins/perl-func/ChangeLog
@@ -1,3 +1,7 @@
+2010-06-16 Morten Welinder <terra gnome org>
+
+ * Release 1.10.6
+
2010-05-30 Morten Welinder <terra gnome org>
* Release 1.10.5
diff --git a/plugins/perl-loader/ChangeLog b/plugins/perl-loader/ChangeLog
index 230764e..6a3bb91 100644
--- a/plugins/perl-loader/ChangeLog
+++ b/plugins/perl-loader/ChangeLog
@@ -1,3 +1,7 @@
+2010-06-16 Morten Welinder <terra gnome org>
+
+ * Release 1.10.6
+
2010-05-30 Morten Welinder <terra gnome org>
* Release 1.10.5
diff --git a/plugins/plan-perfect/ChangeLog b/plugins/plan-perfect/ChangeLog
index 4ab76bd..06f088d 100644
--- a/plugins/plan-perfect/ChangeLog
+++ b/plugins/plan-perfect/ChangeLog
@@ -1,3 +1,7 @@
+2010-06-16 Morten Welinder <terra gnome org>
+
+ * Release 1.10.6
+
2010-05-30 Morten Welinder <terra gnome org>
* Release 1.10.5
diff --git a/plugins/psiconv/ChangeLog b/plugins/psiconv/ChangeLog
index 8364875..a5dc2aa 100644
--- a/plugins/psiconv/ChangeLog
+++ b/plugins/psiconv/ChangeLog
@@ -1,3 +1,7 @@
+2010-06-16 Morten Welinder <terra gnome org>
+
+ * Release 1.10.6
+
2010-05-30 Morten Welinder <terra gnome org>
* Release 1.10.5
diff --git a/plugins/py-func/ChangeLog b/plugins/py-func/ChangeLog
index 0c996f2..0989126 100644
--- a/plugins/py-func/ChangeLog
+++ b/plugins/py-func/ChangeLog
@@ -1,3 +1,7 @@
+2010-06-16 Morten Welinder <terra gnome org>
+
+ * Release 1.10.6
+
2010-05-30 Morten Welinder <terra gnome org>
* Release 1.10.5
diff --git a/plugins/python-loader/ChangeLog b/plugins/python-loader/ChangeLog
index 5d36644..c34fc33 100644
--- a/plugins/python-loader/ChangeLog
+++ b/plugins/python-loader/ChangeLog
@@ -1,3 +1,7 @@
+2010-06-16 Morten Welinder <terra gnome org>
+
+ * Release 1.10.6
+
2010-05-30 Morten Welinder <terra gnome org>
* Release 1.10.5
diff --git a/plugins/qpro/ChangeLog b/plugins/qpro/ChangeLog
index 18e8dd6..3fe554e 100644
--- a/plugins/qpro/ChangeLog
+++ b/plugins/qpro/ChangeLog
@@ -1,3 +1,7 @@
+2010-06-16 Morten Welinder <terra gnome org>
+
+ * Release 1.10.6
+
2010-05-30 Morten Welinder <terra gnome org>
* Release 1.10.5
diff --git a/plugins/sample_datasource/ChangeLog b/plugins/sample_datasource/ChangeLog
index 5b19a27..9babc49 100644
--- a/plugins/sample_datasource/ChangeLog
+++ b/plugins/sample_datasource/ChangeLog
@@ -1,3 +1,7 @@
+2010-06-16 Morten Welinder <terra gnome org>
+
+ * Release 1.10.6
+
2010-05-30 Morten Welinder <terra gnome org>
* Release 1.10.5
diff --git a/plugins/sc/ChangeLog b/plugins/sc/ChangeLog
index 0bcedd4..fbddad6 100644
--- a/plugins/sc/ChangeLog
+++ b/plugins/sc/ChangeLog
@@ -1,3 +1,7 @@
+2010-06-16 Morten Welinder <terra gnome org>
+
+ * Release 1.10.6
+
2010-05-30 Morten Welinder <terra gnome org>
* Release 1.10.5
diff --git a/plugins/sylk/ChangeLog b/plugins/sylk/ChangeLog
index 5dd8e1c..4ee1c46 100644
--- a/plugins/sylk/ChangeLog
+++ b/plugins/sylk/ChangeLog
@@ -1,3 +1,7 @@
+2010-06-16 Morten Welinder <terra gnome org>
+
+ * Release 1.10.6
+
2010-05-30 Morten Welinder <terra gnome org>
* Release 1.10.5
diff --git a/plugins/uihello/ChangeLog b/plugins/uihello/ChangeLog
index a9f2f67..1473fca 100644
--- a/plugins/uihello/ChangeLog
+++ b/plugins/uihello/ChangeLog
@@ -1,3 +1,7 @@
+2010-06-16 Morten Welinder <terra gnome org>
+
+ * Release 1.10.6
+
2010-05-30 Morten Welinder <terra gnome org>
* Release 1.10.5
diff --git a/plugins/xbase/ChangeLog b/plugins/xbase/ChangeLog
index 8aa33c0..26fab8c 100644
--- a/plugins/xbase/ChangeLog
+++ b/plugins/xbase/ChangeLog
@@ -1,3 +1,7 @@
+2010-06-16 Morten Welinder <terra gnome org>
+
+ * Release 1.10.6
+
2010-05-30 Morten Welinder <terra gnome org>
* Release 1.10.5
diff --git a/po-functions/ChangeLog b/po-functions/ChangeLog
index fc3b46e..3357d5f 100644
--- a/po-functions/ChangeLog
+++ b/po-functions/ChangeLog
@@ -1,3 +1,7 @@
+2010-06-16 Morten Welinder <terra gnome org>
+
+ * Release 1.10.6
+
2010-06-06 Andreas J. Guelzow <aguelzow pyrshep ca>
* POTFILES.in: removed src/dialogs/dialog-paste-names.c
diff --git a/po/ChangeLog b/po/ChangeLog
index 013aa17..b06485b 100644
--- a/po/ChangeLog
+++ b/po/ChangeLog
@@ -1,3 +1,7 @@
+2010-06-16 Morten Welinder <terra gnome org>
+
+ * Release 1.10.6
+
2010-06-06 Andreas J. Guelzow <aguelzow pyrshep ca>
* POTFILES.in: removed src/dialogs/dialog-paste-names.c and
diff --git a/src/dialogs/ChangeLog b/src/dialogs/ChangeLog
index 47672fe..5e4d719 100644
--- a/src/dialogs/ChangeLog
+++ b/src/dialogs/ChangeLog
@@ -1,3 +1,7 @@
+2010-06-16 Morten Welinder <terra gnome org>
+
+ * Release 1.10.6
+
2010-06-16 Andreas J. Guelzow <aguelzow pyrshep ca>
* dialog-formula-guru.c (dialog_formula_guru_adjust_children): use
diff --git a/src/tools/ChangeLog b/src/tools/ChangeLog
index fcf0d58..d154293 100644
--- a/src/tools/ChangeLog
+++ b/src/tools/ChangeLog
@@ -1,3 +1,7 @@
+2010-06-16 Morten Welinder <terra gnome org>
+
+ * Release 1.10.6
+
2010-06-16 Andreas J. Guelzow <aguelzow pyrshep ca>
* filter.c (filter_show_all): fix the colrow_foreach call
diff --git a/src/widgets/ChangeLog b/src/widgets/ChangeLog
index 64de6d3..7690118 100644
--- a/src/widgets/ChangeLog
+++ b/src/widgets/ChangeLog
@@ -1,3 +1,7 @@
+2010-06-16 Morten Welinder <terra gnome org>
+
+ * Release 1.10.6
+
2010-06-16 Andreas J. Guelzow <aguelzow pyrshep ca>
* gnumeric-expr-entry.c (gee_create_tooltip): use
diff --git a/test/ChangeLog b/test/ChangeLog
index a536b99..a7e746d 100644
--- a/test/ChangeLog
+++ b/test/ChangeLog
@@ -1,3 +1,7 @@
+2010-06-16 Morten Welinder <terra gnome org>
+
+ * Release 1.10.6
+
2010-05-30 Morten Welinder <terra gnome org>
* Release 1.10.5
diff --git a/tools/ChangeLog b/tools/ChangeLog
index 0fa4ca9..6c02b17 100644
--- a/tools/ChangeLog
+++ b/tools/ChangeLog
@@ -1,3 +1,7 @@
+2010-06-16 Morten Welinder <terra gnome org>
+
+ * Release 1.10.6
+
2010-06-05 Morten Welinder <terra gnome org>
* win32/build (archive_dir): Download and install NSIS.
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]
