# SOME DESCRIPTIVE TITLE. # Copyright (C) YEAR THE PACKAGE'S COPYRIGHT HOLDER # This file is distributed under the same license as the PACKAGE package. # FIRST AUTHOR , YEAR. # #, fuzzy msgid "" msgstr "" "Project-Id-Version: PACKAGE VERSION\n" "Report-Msgid-Bugs-To: \n" "POT-Creation-Date: 2008-09-07 04:19+0000\n" "PO-Revision-Date: YEAR-MO-DA HO:MI+ZONE\n" "Last-Translator: FULL NAME \n" "Language-Team: LANGUAGE \n" "MIME-Version: 1.0\n" "Content-Type: text/plain; charset=UTF-8\n" "Content-Transfer-Encoding: 8bit\n" #: ../plugins/derivatives/options.c:174 #, no-c-format msgid "" "@FUNCTION=CUM_BIV_NORM_DIST\n" "@SYNTAX=CUM_BIV_NORM_DIST(a,b,rho)\n" "@DESCRIPTION=CUM_BIV_NORM_DIST calculates the cumulative bivariate normal " "distribution from parameters a, b & rho.\n" "The return value is the probability that two random variables with " "correlation @rho are respectively each less than @a and @b.\n" "\n" "@EXAMPLES=\n" "\n" "@SEEALSO=NORMDIST,NORMSDIST,NORMSINV" msgstr "" #: ../plugins/derivatives/options.c:234 msgid "" "@FUNCTION=OPT_BS\n" "@SYNTAX=OPT_BS(call_put_flag,spot,strike,time,rate,volatility [," "cost_of_carry])\n" "@DESCRIPTION=OPT_BS uses the Black-Scholes model to calculate the price of a " "European option using call_put_flag, @call_put_flag, 'c' or 'p' struck at " "@strike on an asset with spot price @spot.\n" "@time is the time to maturity of the option expressed in years.\n" "@rate is the risk-free interest rate.\n" "@volatility is the annualized volatility, in percent, of the asset for the " "period through to the exercise date. \n" "@cost_of_carry is the leakage in value of the underlying asset, for common " "stocks, this would be the dividend yield.\n" "* The returned value will be expressed in the same units as @strike and " "@spot.\n" "\n" "@EXAMPLES=\n" "\n" "@SEEALSO=OPT_BS_DELTA, OPT_BS_RHO, OPT_BS_THETA, OPT_BS_VEGA, OPT_BS_GAMMA" msgstr "" #: ../plugins/derivatives/options.c:303 msgid "" "@FUNCTION=OPT_BS_DELTA\n" "@SYNTAX=OPT_BS_DELTA(call_put_flag,spot,strike,time,rate,volatility[," "cost_of_carry])\n" "@DESCRIPTION=OPT_BS_DELTA uses the Black-Scholes model to calculate the " "'delta' of a European option with call_put_flag, @call_put_flag, 'c' or 'p' " "struck at @strike on an asset with spot price @spot.\n" "Where @time is the time to maturity of the option expressed in years.\n" "@rate is the risk-free interest rate.\n" "@volatility is the annualized volatility, in percent, of the asset for the " "period through to the exercise date. \n" "@cost_of_carry is the leakage in value of the underlying asset, for common " "stocks, this would be the dividend yield.\n" "* The returned value will be expressed in the same units as @strike and " "@spot.\n" "\n" "@EXAMPLES=\n" "\n" "@SEEALSO=OPT_BS, OPT_BS_RHO, OPT_BS_THETA, OPT_BS_VEGA, OPT_BS_GAMMA" msgstr "" #: ../plugins/derivatives/options.c:358 msgid "" "@FUNCTION=OPT_BS_GAMMA\n" "@SYNTAX=OPT_BS_GAMMA(spot,strike,time,rate,volatility[,cost_of_carry])\n" "@DESCRIPTION=OPT_BS_GAMMA uses the Black-Scholes model to calculate the " "'gamma' of a European option struck at @strike on an asset with spot price " "@spot.\n" "\n" "(The gamma of an option is the second derivative of its price with respect " "to the price of the underlying asset, and is the same for calls and puts.)\n" "\n" "@time is the time to maturity of the option expressed in years.\n" "@rate is the risk-free interest rate to the exercise date, in percent.\n" "@volatility is the annualized volatility, in percent, of the asset for the " "period through to the exercise date.\n" "@cost_of_carry is the leakage in value of the underlying asset, for common " "stocks, this would be the dividend yield.\n" "* The returned value will be expressed as the rate of change of delta per " "unit change in @spot.\n" "\n" "@EXAMPLES=\n" "\n" "@SEEALSO=OPT_BS, OPT_BS_DELTA, OPT_BS_RHO, OPT_BS_THETA, OPT_BS_VEGA" msgstr "" #: ../plugins/derivatives/options.c:428 msgid "" "@FUNCTION=OPT_BS_THETA\n" "@SYNTAX=OPT_BS_THETA(call_put_flag,spot,strike,time,rate,volatility[," "cost_of_carry])\n" "@DESCRIPTION=OPT_BS_THETA uses the Black-Scholes model to calculate the " "'theta' of a European option with call_put_flag, @call_put_flag struck at " "@strike on an asset with spot price @spot.\n" "\n" "(The theta of an option is the rate of change of its price with respect to " "time to expiry.)\n" "\n" "@time is the time to maturity of the option expressed in years\n" "and @rate is the risk-free interest rate to the exercise date, in percent.\n" "@volatility is the annualized volatility, in percent, of the asset for the " "period through to the exercise date.\n" "@cost_of_carry is the leakage in value of the underlying asset, for common " "stocks, this would be the dividend yield.\n" "* The returned value will be expressed as minus the rate of change of option " "value, per 365.25 days.\n" "\n" "@EXAMPLES=\n" "\n" "@SEEALSO=OPT_BS, OPT_BS_DELTA, OPT_BS_RHO, OPT_BS_VEGA, OPT_BS_GAMMA" msgstr "" #: ../plugins/derivatives/options.c:485 #, no-c-format msgid "" "@FUNCTION=OPT_BS_VEGA\n" "@SYNTAX=OPT_BS_VEGA(spot,strike,time,rate,volatility[,cost_of_carry])\n" "@DESCRIPTION=OPT_BS_VEGA uses the Black-Scholes model to calculate the " "'vega' of a European option struck at @strike on an asset with spot price " "@spot.\n" "(The vega of an option is the rate of change of its price with respect to " "volatility, and is the same for calls and puts.)\n" "@volatility is the annualized volatility, in percent, of the asset for the " "period through to the exercise date.\n" " @time is the time to maturity of the option expressed in years.\n" "@rate is the risk-free interest rate to the exercise date, in percent.\n" "@cost_of_carry is the leakage in value of the underlying asset, for common " "stocks, this would be the dividend yield.\n" "\n" "* The returned value will be expressed as the rate of change of option " "value, per 100% volatility.\n" "\n" "@EXAMPLES=\n" "\n" "@SEEALSO=OPT_BS, OPT_BS_DELTA, OPT_BS_RHO, OPT_BS_THETA, OPT_BS_GAMMA" msgstr "" #: ../plugins/derivatives/options.c:560 #, no-c-format msgid "" "@FUNCTION=OPT_BS_RHO\n" "@SYNTAX=OPT_BS_RHO(call_put_flag,spot,strike,time,rate,volatility[," "cost_of_carry])\n" "@DESCRIPTION=OPT_BS_RHO uses the Black-Scholes model to calculate the 'rho' " "of a European option with call_put_flag, @call_put_flag struck at @strike on " "an asset with spot price @spot.\n" "@call_put_flag is 'c' or 'p' to indicate whether the option is a call or a " "put.\n" "\n" "(The rho of an option is the rate of change of its price with respect to the " "risk free interest rate.)\n" "@time is the time to maturity of the option expressed in years.\n" "@rate is the risk-free interest rate to the exercise date, in percent.\n" "@cost_of_carry is the leakage in value of the underlying asset, for common " "stocks, this would be the dividend yield.\n" "* The returned value will be expressed as the rate of change of option " "value, per 100% change in @rate.\n" "\n" "@EXAMPLES=\n" "\n" "@SEEALSO=OPT_BS, OPT_BS_DELTA, OPT_BS_THETA, OPT_BS_VEGA, OPT_BS_GAMMA" msgstr "" #: ../plugins/derivatives/options.c:628 #, no-c-format msgid "" "@FUNCTION=OPT_BS_CARRYCOST\n" "@SYNTAX=OPT_BS_CARRYCOST(call_put_flag,spot,strike,time,rate,volatility[," "cost_of_carry])\n" "@DESCRIPTION=OPT_BS_CARRYCOST uses the Black-Scholes model to calculate the " "'elasticity' of a European option struck at @strike on an asset with spot " "price @spot.\n" "@call_put_flag is 'c' or 'p' to indicate whether the option is a call or a " "put.\n" "\n" "(The elasticity of an option is the rate of change of its price with respect " "to its cost of carry.)\n" "\n" "@volatility is the annualized volatility, in percent, of the asset for the " "period through to the exercise date. @time is the time to maturity of the " "option expressed in years.\n" "@rate is the risk-free interest rate to the exercise date, in percent.\n" "@cost_of_carry is the leakage in value of the underlying asset, for common " "stocks, this would be the dividend yield.\n" "\n" "* The returned value will be expressed as the rate of change of option " "value, per 100% volatility.\n" "\n" "@EXAMPLES=\n" "\n" "@SEEALSO=OPT_BS, OPT_BS_DELTA, OPT_BS_RHO, OPT_BS_THETA, OPT_BS_GAMMA" msgstr "" #: ../plugins/derivatives/options.c:700 #, no-c-format msgid "" "@FUNCTION=OPT_GARMAN_KOHLHAGEN\n" "@SYNTAX=OPT_GARMAN_KOHLHAGEN(call_put_flag,spot,strike,time,domestic_rate," "foreign_rate,volatility[,cost_of_carry])\n" "@DESCRIPTION=OPT_GARMAN_KOHLHAGEN values the theoretical price of a European " "currency option struck at @strike on an asset with spot price @spot.\n" "@call_put_flag is 'c' or 'p' to indicate whether the option is a call or a " "put.\n" "@volatility is the annualized volatility, in percent, of the asset for the " "period through to the exercise date. \n" "@time the number of days to exercise.\n" "@domestic_rate is the domestic risk-free interest rate to the exercise " "date.\n" "@foreign_rate is the foreign risk-free interest rate to the exercise date, " "in percent.\n" "@cost_of_carry is the leakage in value of the underlying asset, for common " "stocks, this would be the dividend yield.\n" "* The returned value will be expressed as the rate of change of option " "value, per 100% volatility.\n" "\n" "@EXAMPLES=\n" "\n" "@SEEALSO=OPT_BS, OPT_BS_DELTA, OPT_BS_RHO, OPT_BS_THETA, OPT_BS_GAMMA" msgstr "" #: ../plugins/derivatives/options.c:771 #, no-c-format msgid "" "@FUNCTION=OPT_FRENCH\n" "@SYNTAX=OPT_FRENCH(call_put_flag,spot,strike,time,t2,rate,volatility[," "cost_of_carry])\n" "@DESCRIPTION=OPT_FRENCH values the theoretical price of a European option " "adjusted for trading day volatility, struck at @strike on an asset with spot " "price @spot.\n" "@call_put_flag is 'c' or 'p' to indicate whether the option is a call or a " "put.\n" "@volatility is the annualized volatility, in percent, of the asset for the " "period through to the exercise date.\n" " @time the number of calendar days to exercise divided by calendar days in " "the year.\n" "@t2 is the number of trading days to exercise divided by trading days in the " "year.\n" "@rate is the risk-free interest rate.\n" "@cost_of_carry is the leakage in value of the underlying asset, to the " "exercise date, in percent.\n" "For common stocks, this would be the dividend yield.\n" "\n" "@EXAMPLES=\n" "\n" "@SEEALSO=OPT_BS, OPT_BS_DELTA, OPT_BS_RHO, OPT_BS_THETA, OPT_BS_GAMMA" msgstr "" #: ../plugins/derivatives/options.c:835 #, no-c-format msgid "" "@FUNCTION=OPT_JUMP_DIFF\n" "@SYNTAX=OPT_JUMP_DIFF(call_put_flag,spot,strike,time,rate,volatility,lambda," "gamma)\n" "@DESCRIPTION=OPT_JUMP_DIFF models the theoretical price of an option " "according to the Jump Diffusion process (Merton).\n" "@call_put_flag is 'c' or 'p' to indicate whether the option is a call or a " "put.\n" "@spot is the spot price of the underlying asset.\n" "@strike is the strike price of the option.\n" "@time is the time to maturity of the option expressed in years.\n" "@rate is the annualized rate of interest.\n" "@volatility is the annualized volatility of the underlying asset.\n" "@lambda is expected number of 'jumps' per year.\n" "@gamma is proportion of volatility explained by the 'jumps.'\n" "\n" "@EXAMPLES=\n" "\n" "@SEEALSO=OPT_BS, OPT_BS_DELTA, OPT_BS_RHO, OPT_BS_THETA, OPT_BS_GAMMA" msgstr "" #: ../plugins/derivatives/options.c:934 #, no-c-format msgid "" "@FUNCTION=OPT_MILTERSEN_SCHWARTZ\n" "@SYNTAX=OPT_MILTERSEN_SCHWARTZ(call_put_flag,p_t,f_t,x,t1,t2,v_s,v_e,v_f," "rho_se,rho_sf,rho_ef,kappa_e,kappa_f)\n" "@DESCRIPTION=OPT_MILTERSEN_SCHWARTZ models the theoretical price of options " "on commodities futures according to Miltersen & Schwartz. \n" "@call_put_flag is 'c' or 'p' to indicate whether the option is a call or a " "put.\n" "@p_t is a zero coupon bond with expiry at option maturity.\n" "@f_t is the futures price.\n" "@x is the strike price.\n" "@t1 is the time to maturity of the option.\n" "@t2 is the time to maturity of the underlying commodity futures contract.\n" "@v_s is the volatility of the spot commodity price.\n" "@v_e is the volatility of the future convenience yield.\n" "@v_f is the volatility of the forward rate of interest.\n" "@rho_se is correlation between the spot commodity price and the convenience " "yield.\n" "@rho_sf is correlation between the spot commodity price and the forward " "interest rate.\n" "@rho_ef is correlation between the forward interest rate and the convenience " "yield.\n" "@kappa_e is the speed of mean reversion of the convenience yield.\n" "@kappa_f is the speed of mean reversion of the forward interest rate.\n" "\n" "@EXAMPLES=\n" "\n" "@SEEALSO=OPT_BS, OPT_BS_DELTA, OPT_BS_RHO, OPT_BS_THETA, OPT_BS_GAMMA" msgstr "" #: ../plugins/derivatives/options.c:1050 #, no-c-format msgid "" "@FUNCTION=OPT_RGW\n" "@SYNTAX=OPT_RGW(spot,strike,t1,t2,rate,d,volatility)\n" "@DESCRIPTION=OPT_RGW models the theoretical price of an american option " "according to the Roll-Geske-Whaley approximation where: \n" "@spot is the spot price of the underlying asset.\n" "@strike is the strike price at which the option is struck.\n" "@t1 is the time to the dividend payout.\n" "@t2 is the time to option expiration.\n" "@rate is the annualized rate of interest.\n" "@d is the amount of the dividend to be paid expressed in currency.\n" "@volatility is the annualized rate of volatility of the underlying asset.\n" "\n" "@EXAMPLES=\n" "\n" "@SEEALSO=OPT_BS, OPT_BS_DELTA, OPT_BS_RHO, OPT_BS_THETA, OPT_BS_GAMMA" msgstr "" #: ../plugins/derivatives/options.c:1106 #, no-c-format msgid "" "@FUNCTION=OPT_BAW_AMER\n" "@SYNTAX=OPT_BAW_AMER(call_put_flag,spot,strike,time,rate,cost_of_carry," "volatility)\n" "@DESCRIPTION=OPT_BAW_AMER models the theoretical price of an option " "according to the Barone Adesie & Whaley approximation. \n" "@call_put_flag is 'c' or 'p' to indicate whether the option is a call or a " "put.\n" "@spot is the spot price of the underlying asset.\n" "@strike is the strike price at which the option is struck.\n" "@time is the number of days to maturity of the option.\n" "@rate is the annualized risk-free rate of interest.\n" "@cost_of_carry is the leakage in value of the underlying asset, for common " "stocks, this would be the dividend yield.\n" "@volatility is the annualized volatility in price of the underlying asset.\n" "\n" "@EXAMPLES=\n" "\n" "@SEEALSO=OPT_BS, OPT_BS_DELTA, OPT_BS_RHO, OPT_BS_THETA, OPT_BS_GAMMA" msgstr "" #: ../plugins/derivatives/options.c:1292 #, no-c-format msgid "" "@FUNCTION=OPT_BJER_STENS\n" "@SYNTAX=OPT_BJER_STENS(call_put_flag,spot,strike,time,rate,volatility[," "cost_of_carry])\n" "@DESCRIPTION=OPT_BJER_STENS models the theoretical price of american options " "according to the Bjerksund & Stensland approximation technique.\n" "@call_put_flag is 'c' or 'p' to indicate whether the option is a call or a " "put.\n" "@spot is the spot price of the underlying asset.\n" "@strike is the strike price at which the option is struck.\n" "@time is the number of days to maturity of the option.\n" "@rate is the annualized risk-free rate of interest.\n" "@volatility is the annualized volatility in price of the underlying asset.\n" "@cost_of_carry is the leakage in value of the underlying asset, for common " "stocks, this would be the dividend yield.\n" "\n" "@EXAMPLES=\n" "\n" "@SEEALSO=OPT_BS, OPT_BS_DELTA, OPT_BS_RHO, OPT_BS_THETA, OPT_BS_GAMMA" msgstr "" #: ../plugins/derivatives/options.c:1379 #, no-c-format msgid "" "@FUNCTION=OPT_EXEC\n" "@SYNTAX=OPT_EXEC(call_put_flag,spot,strike,time,rate,volatility," "cost_of_carry,lambda)\n" "@DESCRIPTION=OPT_EXEC models the theoretical price of executive stock " "options @call_put_flag is 'c' or 'p' to indicate whether the option is a " "call or a put.\n" "One would expect this to always be a call option.\n" "@spot is the spot price of the underlying asset.\n" "@strike is the strike price at which the option is struck.\n" "@time is the number of days to maturity of the option.\n" "@rate is the annualized risk-free rate of interest.\n" "@volatility is the annualized volatility in price of the underlying asset.\n" "@cost_of_carry is the leakage in value of the underlying asset, for common " "stocks, this would be the dividend yield.\n" "@lambda is the jump rate for executives. The model assumes executives " "forfeit their options if they leave the company.\n" "\n" "@EXAMPLES=\n" "\n" "@SEEALSO=OPT_BS, OPT_BS_DELTA, OPT_BS_RHO, OPT_BS_THETA, OPT_BS_GAMMA" msgstr "" #: ../plugins/derivatives/options.c:1430 #, no-c-format msgid "" "@FUNCTION=OPT_FORWARD_START\n" "@SYNTAX=OPT_FORWARD_START(call_put_flag,spot,alpha,time1,time,rate," "volatility,cost_of_carry)\n" "@DESCRIPTION=OPT_FORWARD_START models the theoretical price of forward start " "options\n" " @call_put_flag is 'c' or 'p' to indicate whether the option is a call or a " "put.\n" "@spot is the spot price of the underlying asset.\n" "@alpha is a fraction that set the strike price the future date @time1.\n" "@time1 is the number of days until the option starts.\n" "@time is the number of days to maturity of the option.\n" "@rate is the annualized risk-free rate of interest.\n" "@volatility is the annualized volatility in price of the underlying asset.\n" "@cost_of_carry is the leakage in value of the underlying asset, for common " "stocks, this would be the dividend yield.\n" "@EXAMPLES=\n" "\n" "@SEEALSO=OPT_BS, OPT_BS_DELTA, OPT_BS_RHO, OPT_BS_THETA, OPT_BS_GAMMA" msgstr "" #: ../plugins/derivatives/options.c:1496 #, no-c-format msgid "" "@FUNCTION=OPT_TIME_SWITCH\n" "@SYNTAX=OPT_TIME_SWITCH(call_put_flag,spot,strike,a,time,m,dt,rate," "cost_of_carry,volatility)\n" "@DESCRIPTION=OPT_TIME_SWITCH models the theoretical price of time switch " "options. (Pechtl 1995)\n" "The holder receives @a * @dt for each period dt that the asset price was " "greater than the strike price (for a call) or below it (for a put). \n" "@call_put_flag is 'c' or 'p' to indicate whether the option is a call or a " "put.\n" "@spot is the spot price of the underlying asset.\n" "@strike is the strike price at which the option is struck.\n" "@a is the amount received for each time period as discussed above.\n" "@time is the maturity of the option in years.\n" "@m is the number of time units the option has already met the condition.\n" "@dt is the agreed upon discrete time period (often a day) expressed as a " "fraction of a year.\n" "@rate is the annualized risk-free rate of interest.\n" "@cost_of_carry is the leakage in value of the underlying asset, for common " "stocks, this would be the dividend yield.\n" "@EXAMPLES=\n" "\n" "@SEEALSO=OPT_BS, OPT_BS_DELTA, OPT_BS_RHO, OPT_BS_THETA, OPT_BS_GAMMA" msgstr "" #: ../plugins/derivatives/options.c:1550 #, no-c-format msgid "" "@FUNCTION=OPT_SIMPLE_CHOOSER\n" "@SYNTAX=OPT_SIMPLE_CHOOSER(call_put_flag,spot,strike,time1,time2,rate," "cost_of_carry,volatility)\n" "@DESCRIPTION=OPT_SIMPLE_CHOOSER models the theoretical price of simple " "chooser options.\n" "@call_put_flag is 'c' or 'p' to indicate whether the option is a call or a " "put.\n" "@spot is the spot price of the underlying asset.\n" "@strike is the strike price at which the option is struck.\n" "@time1 is the time in years until the holder chooses a put or a call " "option.\n" "@time2 is the time in years until the chosen option expires.\n" "@rate is the annualized risk-free rate of interest.\n" "@cost_of_carry is the leakage in value of the underlying asset, for common " "stocks, this would be the dividend yield.\n" "@EXAMPLES=\n" "\n" "@SEEALSO=OPT_BS, OPT_BS_DELTA, OPT_BS_RHO, OPT_BS_THETA, OPT_BS_GAMMA" msgstr "" #: ../plugins/derivatives/options.c:1613 #, no-c-format msgid "" "@FUNCTION=OPT_COMPLEX_CHOOSER\n" "@SYNTAX=OPT_COMPLEX_CHOOSER(call_put_flag,spot,strike_call,strike_put,time," "time_call,time_put,rate,cost_of_carry,volatility)\n" "@DESCRIPTION=OPT_COMPLEX_CHOOSER models the theoretical price of complex " "chooser options.\n" "@call_put_flag is 'c' or 'p' to indicate whether the option is a call or a " "put.\n" "@spot is the spot price of the underlying asset.\n" "@strike_call is the strike price at which the option is struck, applicable " "if exercised as a call option.\n" "@strike_put is the strike price at which the option is struck, applicable if " "exercised as a put option.\n" "@time is the time in years until the holder chooses a put or a call " "option. \n" "@time_call is the time in years to maturity of the call option if chosen.\n" "@time_put is the time in years to maturity of the put option if chosen.\n" "@rate is the annualized risk-free rate of interest.\n" "@cost_of_carry is the leakage in value of the underlying asset, for common " "stocks, this would be the dividend yield.\n" "@volatility is the annualized volatility in price of the underlying asset.\n" "\n" "@EXAMPLES=\n" "\n" "@SEEALSO=OPT_BS, OPT_BS_DELTA, OPT_BS_RHO, OPT_BS_THETA, OPT_BS_GAMMA" msgstr "" #: ../plugins/derivatives/options.c:1730 #, no-c-format msgid "" "@FUNCTION=OPT_ON_OPTIONS\n" "@SYNTAX=OPT_ON_OPTIONS(type_flag,spot,strike1,strike2,time1,time2,rate," "cost_of_carry,volatility)\n" "@DESCRIPTION=OPT_ON_OPTIONS models the theoretical price of options on " "options.\n" "@type_flag is 'cc' for calls on calls, 'cp' for calls on puts, and so on for " "'pc', and 'pp'.\n" "@spot is the spot price of the underlying asset.\n" "@strike1 is the strike price at which the option being valued is struck.\n" "@strike2 is the strike price at which the underlying option is struck.\n" "@time1 is the time in years to maturity of the option.\n" "@time2 is the time in years to the maturity of the underlying option.\n" "(@time2 >= @time1).\n" "@rate is the annualized risk-free rate of interest.\n" "@cost_of_carry is the leakage in value of the underlying asset of the " "underlying option.for common stocks, this would be the dividend yield.\n" "@volatility is the annualized volatility in price of the underlying asset of " "the underlying option.\n" "\n" "@EXAMPLES=\n" "\n" "@SEEALSO=OPT_BS, OPT_BS_DELTA, OPT_BS_RHO, OPT_BS_THETA, OPT_BS_GAMMA" msgstr "" #: ../plugins/derivatives/options.c:1818 #, no-c-format msgid "" "@FUNCTION=OPT_EXTENDIBLE_WRITER\n" "@SYNTAX=OPT_EXTENDIBLE_WRITER(call_put_flag,spot,strike1,strike2,time1,time2," "rate,cost_of_carry,volatility)\n" "@DESCRIPTION=OPT_EXTENDIBLE_WRITER models the theoretical price of " "extendible writer options. These are options that can be exercised at an " "initial period, @time1, or their maturity extended to @time2 if the option " "is out of the money at @time1.\n" "@call_put_flag is 'c' or 'p' to indicate whether the option is a call or a " "put.\n" "@spot is the spot price of the underlying asset.\n" "@strike1 is the strike price at which the option is struck.\n" "@strike2 is the strike price at which the option is re-struck if out of the " "money at @time1.\n" "@time1 is the initial maturity of the option in years.\n" "@time2 is the is the extended maturity in years if chosen.\n" "@rate is the annualized risk-free rate of interest.\n" "@cost_of_carry is the leakage in value of the underlying asset, for common " "stocks, this would be the dividend yield.\n" "@volatility is the annualized volatility in price of the underlying asset.\n" "\n" "@EXAMPLES=\n" "\n" "@SEEALSO=OPT_BS, OPT_BS_DELTA, OPT_BS_RHO, OPT_BS_THETA, OPT_BS_GAMMA" msgstr "" #: ../plugins/derivatives/options.c:1882 #, no-c-format msgid "" "@FUNCTION=OPT_2_ASSET_CORRELATION\n" "@SYNTAX=OPT_2_ASSET_CORRELATION(call_put_flag,spot1,spot2,strike1,strike2," "time,cost_of_carry1,cost_of_carry2,rate,volatility1,volatility2,rho)\n" "@DESCRIPTION=OPT_2_ASSET_CORRELATION models the theoretical price of " "options on 2 assets with correlation @rho.\n" "The payoff for a call is max(@spot2 - @strike2,0) if @spot1 > @strike1 or 0 " "otherwise.\n" "The payoff for a put is max (@strike2 - @spot2, 0) if @spot1 < @strike1 or 0 " "otherwise.\n" "@call_put_flag is 'c' or 'p' to indicate whether the option is a call or a " "put.\n" "@spot1 & @spot2 are the spot prices of the underlying assets.\n" "@strike1 & @strike2 are the strike prices at which the option is struck.\n" "@time is the initial maturity of the option in years.\n" "@rate is the annualized risk-free rate of interest.\n" "@cost_of_carry1 & @cost_of_carry2 are the leakage in value of the underlying " "assets, for common stocks, this would be the dividend yield.\n" "@volatility1 & @volatility2 are the annualized volatility in price of the " "underlying assets.\n" "\n" "@EXAMPLES=\n" "\n" "@SEEALSO=OPT_BS, OPT_BS_DELTA, OPT_BS_RHO, OPT_BS_THETA, OPT_BS_GAMMA" msgstr "" #: ../plugins/derivatives/options.c:1939 #, no-c-format msgid "" "@FUNCTION=OPT_EURO_EXCHANGE\n" "@SYNTAX=OPT_EURO_EXCHANGE(spot1,spot2,qty1,qty2,time,rate,cost_of_carry1," "cost_of_carry2,volatility1,volatility2,rho)\n" "@DESCRIPTION=OPT_EURO_EXCHANGE models the theoretical price of a European " "option to exchange one asset with quantity @qty2 and spot price @spot2 for " "another, with quantity @qty1 and spot price @spot1.\n" "@time is the initial maturity of the option in years.\n" "@rate is the annualized risk-free rate of interest.\n" "@cost_of_carry1 & @cost_of_carry2 are the leakage in value of the underlying " "assets, for common stocks, this would be the dividend yield.\n" "@volatility1 & @volatility2 are the annualized volatility in price of the " "underlying assets.\n" "@rho is the correlation between the two assets.\n" "\n" "@EXAMPLES=\n" "\n" "@SEEALSO=OPT_AMER_EXCHANGE, OPT_BS, OPT_BS_DELTA, OPT_BS_RHO, OPT_BS_THETA, " "OPT_BS_GAMMA" msgstr "" #: ../plugins/derivatives/options.c:1986 #, no-c-format msgid "" "@FUNCTION=OPT_AMER_EXCHANGE\n" "@SYNTAX=OPT_AMER_EXCHANGE(spot1,spot2,qty1,qty2,time,rate,cost_of_carry1," "cost_of_carry2,volatility1, volatility2, rho)\n" "@DESCRIPTION=OPT_AMER_EXCHANGE models the theoretical price of an American " "option to exchange one asset with quantity @qty2 and spot price @spot2 for " "another, with quantity @qty1 and spot price @spot1.\n" "@time is the initial maturity of the option in years.\n" "@rate is the annualized risk-free rate of interest.\n" "@cost_of_carry1 & @cost_of_carry2 are the leakage in value of the underlying " "assets, for common stocks, this would be the dividend yield.\n" "@volatility1 & @volatility2 are the annualized volatility in price of the " "underlying assets.\n" "@rho is the correlation between the two assets.\n" "\n" "@EXAMPLES=\n" "\n" "@SEEALSO=OPT_EURO_EXCHANGE, OPT_BS, OPT_BS_DELTA, OPT_BS_RHO, OPT_BS_THETA, " "OPT_BS_GAMMA" msgstr "" #: ../plugins/derivatives/options.c:2031 #, no-c-format msgid "" "@FUNCTION=OPT_SPREAD_APPROX\n" "@SYNTAX=OPT_SPREAD_APPROX(call_put_flag,fut_price1,fut_price2,strike,time, " "rate,volatility1,volatility2,rho)\n" "@DESCRIPTION=OPT_SPREAD_APPROX models the theoretical price of a European " "option on the spread between two futures contracts.\n" "@call_put_flag is 'c' or 'p' to indicate whether the option is a call or a " "put.\n" "@fut_price1 & @fut_price2 are the prices of the two futures contracts.\n" "@strike is the strike price at which the option is struck \n" "@time is the initial maturity of the option in years.\n" "@rate is the annualized risk-free rate of interest.\n" "@volatility1 & @volatility2 are the annualized volatility in price of the " "underlying futures contracts.\n" "@rho is the correlation between the two futures contracts.\n" "\n" "@EXAMPLES=\n" "\n" "@SEEALSO=OPT_BS, OPT_BS_DELTA, OPT_BS_RHO, OPT_BS_THETA, OPT_BS_GAMMA" msgstr "" #: ../plugins/derivatives/options.c:2093 #, no-c-format msgid "" "@FUNCTION=OPT_FLOAT_STRK_LKBK\n" "@SYNTAX=OPT_FLOAT_STRK_LKBK(call_put_flag,spot,spot_min,spot_max,time,rate," "cost_of_carry,volatility)\n" "@DESCRIPTION=OPT_FLOAT_STRK_LKBK models the theoretical price of an option " "where the holder of the option may exercise on expiry at the most favourable " "price observed during the options life of the underlying asset.\n" "@call_put_flag is 'c' or 'p' to indicate whether the option is a call or a " "put.\n" "@spot is the spot price of the underlying asset.\n" "@spot_min is the minimum spot price of the underlying asset so far " "observed.\n" "@spot_max is the maximum spot price of the underlying asset so far " "observed.\n" "@time is the initial maturity of the option in years.\n" "@rate is the annualized risk-free rate of interest.\n" "@cost_of_carry is the leakage in value of the underlying asset, for common " "stocks, this would be the dividend yield.\n" "@volatility is the annualized volatility in price of the underlying asset.\n" "\n" "@EXAMPLES=\n" "\n" "@SEEALSO=OPT_BS, OPT_BS_DELTA, OPT_BS_RHO, OPT_BS_THETA, OPT_BS_GAMMA" msgstr "" #: ../plugins/derivatives/options.c:2163 #, no-c-format msgid "" "@FUNCTION=OPT_FIXED_STRK_LKBK\n" "@SYNTAX=OPT_FIXED_STRK_LKBK(call_put_flag,spot,spot_min,spot_max,strike,time," "rate,cost_of_carry,volatility)\n" "@DESCRIPTION=OPT_FIXED_STRK_LKBK models the theoretical price of an option " "where the holder of the option may exercise on expiry at the most favourable " "price observed during the options life of the underlying asset.\n" "@call_put_flag is 'c' or 'p' to indicate whether the option is a call or a " "put.\n" "@spot is the spot price of the underlying asset.\n" "@spot_min is the minimum spot price of the underlying asset so far " "observed.\n" "@spot_max is the maximum spot price of the underlying asset so far " "observed.\n" "@strike is the strike prices at which the option is struck.\n" "@time is the initial maturity of the option in years.\n" "@rate is the annualized risk-free rate of interest.\n" "@cost_of_carry is the leakage in value of the underlying asset, for common " "stocks, this would be the dividend yield.\n" "@volatility is the annualized volatility in price of the underlying asset.\n" "\n" "@EXAMPLES=\n" "\n" "@SEEALSO=OPT_BS, OPT_BS_DELTA, OPT_BS_RHO, OPT_BS_THETA, OPT_BS_GAMMA" msgstr "" #: ../plugins/derivatives/options.c:2253 #, no-c-format msgid "" "@FUNCTION=OPT_BINOMIAL\n" "@SYNTAX=OPT_BINOMIAL(amer_euro_flag,call_put_flag,num_time_steps, spot, " "strike, time, rate, volatility, cost_of_carry)\n" "@DESCRIPTION=OPT_ models the theoretical price of either an American or " "European style option using a binomial tree.\n" "@amer_euro_flag is either 'a' or 'e' to indicate whether the option being " "valued is an American or European style option respectively.\n" "@call_put_flag is 'c' or 'p' to indicate whether the option is a call or a " "put.\n" "@num_time_steps is the number of time steps used in the valuation, a greater " "number of time steps yields greater accuracy however is slower to " "calculate.\n" "@spot is the spot price of the underlying asset.\n" "@strike is the strike price at which the option is struck.\n" "@time is the initial maturity of the option in years.\n" "@rate is the annualized risk-free rate of interest.\n" "@volatility is the annualized volatility in price of the underlying asset.\n" "@cost_of_carry is the leakage in value of the underlying asset.\n" "\n" "@EXAMPLES=\n" "\n" "@SEEALSO=OPT_BS, OPT_BS_DELTA, OPT_BS_RHO, OPT_BS_THETA, OPT_BS_GAMMA" msgstr "" #: ../plugins/fn-complex/functions.c:80 msgid "" "@FUNCTION=COMPLEX\n" "@SYNTAX=COMPLEX(real,im[,suffix])\n" "@DESCRIPTION=COMPLEX returns a complex number of the form x + yi.\n" "\n" "@real is the real and @im is the imaginary part of the complex number. " "@suffix is the suffix for the imaginary part. If it is omitted, COMPLEX " "uses 'i' by default.\n" "\n" "* If @suffix is neither 'i' nor 'j', COMPLEX returns #VALUE! error.\n" "* This function is Excel compatible.\n" "\n" "@EXAMPLES=\n" "COMPLEX(1,-1) equals 1-i.\n" "\n" "@SEEALSO=" msgstr "" #: ../plugins/fn-complex/functions.c:122 msgid "" "@FUNCTION=IMAGINARY\n" "@SYNTAX=IMAGINARY(inumber)\n" "@DESCRIPTION=IMAGINARY returns the imaginary part of a complex number.\n" "\n" "* If @inumber is not a valid complex number, IMAGINARY returns #VALUE! " "error.\n" "* This function is Excel compatible.\n" "\n" "@EXAMPLES=\n" "IMAGINARY(\"132-j\") equals -1.\n" "\n" "@SEEALSO=IMREAL" msgstr "" #: ../plugins/fn-complex/functions.c:158 msgid "" "@FUNCTION=IMABS\n" "@SYNTAX=IMABS(inumber)\n" "@DESCRIPTION=IMABS returns the absolute value of a complex number.\n" "\n" "* If @inumber is not a valid complex number, IMABS returns #VALUE! error.\n" "* This function is Excel compatible.\n" "\n" "@EXAMPLES=\n" "IMABS(\"2-j\") equals 2.23606798.\n" "\n" "@SEEALSO=IMAGINARY,IMREAL" msgstr "" #: ../plugins/fn-complex/functions.c:191 msgid "" "@FUNCTION=IMREAL\n" "@SYNTAX=IMREAL(inumber)\n" "@DESCRIPTION=IMREAL returns the real part of a complex number.\n" "\n" "* If @inumber is not a valid complex number, IMREAL returns #VALUE! error.\n" "* This function is Excel compatible.\n" "\n" "@EXAMPLES=\n" "imreal(\"132-j\") equals 132.\n" "\n" "@SEEALSO=IMAGINARY" msgstr "" #: ../plugins/fn-complex/functions.c:227 msgid "" "@FUNCTION=IMCONJUGATE\n" "@SYNTAX=IMCONJUGATE(inumber)\n" "@DESCRIPTION=IMCONJUGATE returns the complex conjugate of a complex number.\n" "\n" "* If @inumber is not a valid complex number, IMCONJUGATE returns #VALUE! " "error.\n" "* This function is Excel compatible.\n" "\n" "@EXAMPLES=\n" "IMCONJUGATE(\"1-j\") equals 1+j.\n" "\n" "@SEEALSO=IMAGINARY,IMREAL" msgstr "" #: ../plugins/fn-complex/functions.c:261 msgid "" "@FUNCTION=IMINV\n" "@SYNTAX=IMINV(inumber)\n" "@DESCRIPTION=IMINV returns the inverse, or reciprocal, of the complex number " "z (@inumber), where\n" "\n" "\t1/z = (x - i y)/(x^2 + y^2).\n" "\n" "* If @inumber is not a valid complex number, IMINV returns #VALUE! error.\n" "\n" "@EXAMPLES=\n" "IMINV(\"1-j\") equals 0.5+0.5j.\n" "\n" "@SEEALSO=" msgstr "" #: ../plugins/fn-complex/functions.c:295 msgid "" "@FUNCTION=IMNEG\n" "@SYNTAX=IMNEG(inumber)\n" "@DESCRIPTION=IMNEG returns the negative of the complex number z (@inumber), " "where\n" "\n" "\t-z = (-x) + i(-y).\n" "\n" "* If @inumber is not a valid complex number, IMNEG returns #VALUE! error.\n" "\n" "@EXAMPLES=\n" "IMNEG(\"1-j\") equals -1+j.\n" "\n" "@SEEALSO=" msgstr "" #: ../plugins/fn-complex/functions.c:329 msgid "" "@FUNCTION=IMCOS\n" "@SYNTAX=IMCOS(inumber)\n" "@DESCRIPTION=IMCOS returns the cosine of a complex number.\n" "\n" "* If @inumber is not a valid complex number, IMCOS returns #VALUE! error.\n" "* This function is Excel compatible.\n" "\n" "@EXAMPLES=\n" "IMCOS(\"1+j\") equals 0.833730-0.988898j.\n" "\n" "@SEEALSO=IMSIN,IMTAN" msgstr "" #: ../plugins/fn-complex/functions.c:363 msgid "" "@FUNCTION=IMTAN\n" "@SYNTAX=IMTAN(inumber)\n" "@DESCRIPTION=IMTAN returns the tangent of a complex number.\n" "\n" "* If @inumber is not a valid complex number, IMTAN returns #VALUE! error.\n" "* This function is Excel compatible.\n" "\n" "@EXAMPLES=\n" "IMTAN(\"2-j\") equals -0.2434582-1.1667363j.\n" "\n" "@SEEALSO=IMSIN,IMCOS" msgstr "" #: ../plugins/fn-complex/functions.c:397 msgid "" "@FUNCTION=IMSEC\n" "@SYNTAX=IMSEC(inumber)\n" "@DESCRIPTION=IMSEC returns the complex secant of the complex number z " "(@inumber), where\n" "\n" "\tsec(z) = 1/cos(z).\n" "\n" "* If @inumber is not a valid complex number, IMSEC returns #VALUE! error.\n" "\n" "@EXAMPLES=\n" "IMSEC(\"2-j\") equals -0.413149-0.687527j.\n" "\n" "@SEEALSO=IMCSC,IMCOT" msgstr "" #: ../plugins/fn-complex/functions.c:433 msgid "" "@FUNCTION=IMCSC\n" "@SYNTAX=IMCSC(inumber)\n" "@DESCRIPTION=IMCSC returns the complex cosecant of the complex number z " "(@inumber), where\n" "\n" "\tcsc(z) = 1/sin(z).\n" "\n" "* If @inumber is not a valid complex number, IMCSC returns #VALUE! error.\n" "\n" "@EXAMPLES=\n" "IMCSC(\"2-j\") equals 0.635494-0.221501j.\n" "\n" "@SEEALSO=IMSEC,IMCOT" msgstr "" #: ../plugins/fn-complex/functions.c:469 msgid "" "@FUNCTION=IMCOT\n" "@SYNTAX=IMCOT(inumber)\n" "@DESCRIPTION=IMCOT returns the complex cotangent of the complex number z " "(@inumber), where\n" "\n" "\tcot(z) = 1/tan(z).\n" "\n" "* If @inumber is not a valid complex number, IMCOT returns #VALUE! error.\n" "\n" "@EXAMPLES=\n" "IMCOT(\"2-j\") equals -0.171384+0.821330j.\n" "\n" "@SEEALSO=IMSEC,IMCSC" msgstr "" #: ../plugins/fn-complex/functions.c:505 msgid "" "@FUNCTION=IMEXP\n" "@SYNTAX=IMEXP(inumber)\n" "@DESCRIPTION=IMEXP returns the exponential of a complex number.\n" "\n" "* If @inumber is not a valid complex number, IMEXP returns #VALUE! error.\n" "* This function is Excel compatible.\n" "\n" "@EXAMPLES=\n" "IMEXP(\"2-j\") equals 3.992324-6.217676j.\n" "\n" "@SEEALSO=IMLN" msgstr "" #: ../plugins/fn-complex/functions.c:539 msgid "" "@FUNCTION=IMARGUMENT\n" "@SYNTAX=IMARGUMENT(inumber)\n" "@DESCRIPTION=IMARGUMENT returns the argument theta of a complex number, i.e. " "the angle in radians from the real axis to the representation of the number " "in polar coordinates.\n" "\n" "* If @inumber is not a valid complex number, IMARGUMENT returns #VALUE! " "error.\n" "* This function is Excel compatible.\n" "\n" "@EXAMPLES=\n" "IMARGUMENT(\"2-j\") equals -0.463647609.\n" "\n" "@SEEALSO=" msgstr "" #: ../plugins/fn-complex/functions.c:574 msgid "" "@FUNCTION=IMLN\n" "@SYNTAX=IMLN(inumber)\n" "@DESCRIPTION=IMLN returns the natural logarithm of a complex number.\n" "\n" "The result will have an imaginary part between -pi and +pi. The natural " "logarithm is not uniquely defined on complex numbers. You may need to add or " "subtract an even multiple of pi to the imaginary part.\n" "\n" "* If @inumber is not a valid complex number, IMLN returns #VALUE! error.\n" "* This function is Excel compatible.\n" "\n" "@EXAMPLES=\n" "IMLN(\"3-j\") equals 1.15129-0.32175j.\n" "\n" "@SEEALSO=IMEXP,IMLOG2,IMLOG10" msgstr "" #: ../plugins/fn-complex/functions.c:613 msgid "" "@FUNCTION=IMLOG2\n" "@SYNTAX=IMLOG2(inumber)\n" "@DESCRIPTION=IMLOG2 returns the logarithm of a complex number in base 2.\n" "\n" "* If @inumber is not a valid complex number, IMLOG2 returns #VALUE! error.\n" "* This function is Excel compatible.\n" "\n" "@EXAMPLES=\n" "IMLOG2(\"3-j\") equals 1.66096-0.46419j.\n" "\n" "@SEEALSO=IMLN,IMLOG10" msgstr "" #: ../plugins/fn-complex/functions.c:648 msgid "" "@FUNCTION=IMLOG10\n" "@SYNTAX=IMLOG10(inumber)\n" "@DESCRIPTION=IMLOG10 returns the logarithm of a complex number in base 10.\n" "\n" "* If @inumber is not a valid complex number, IMLOG10 returns #VALUE! error.\n" "* This function is Excel compatible.\n" "\n" "@EXAMPLES=\n" "IMLOG10(\"3-j\") equals 0.5-0.13973j.\n" "\n" "@SEEALSO=IMLN,IMLOG2" msgstr "" #: ../plugins/fn-complex/functions.c:683 msgid "" "@FUNCTION=IMPOWER\n" "@SYNTAX=IMPOWER(inumber1,inumber2)\n" "@DESCRIPTION=IMPOWER returns a complex number raised to a power. @inumber1 " "is the complex number to be raised to a power and @inumber2 is the power to " "which you want to raise it.\n" "\n" "* If @inumber1 or @inumber2 are not valid complex numbers, IMPOWER returns " "#VALUE! error.\n" "* This function is Excel compatible.\n" "\n" "@EXAMPLES=\n" "IMPOWER(\"4-j\",2) equals 15-8j.\n" "\n" "@SEEALSO=IMSQRT" msgstr "" #: ../plugins/fn-complex/functions.c:725 msgid "" "@FUNCTION=IMDIV\n" "@SYNTAX=IMDIV(inumber1,inumber2)\n" "@DESCRIPTION=IMDIV returns the quotient of two complex numbers.\n" "\n" "* If @inumber1 or @inumber2 are not valid complex numbers, IMDIV returns " "#VALUE! error.\n" "* This function is Excel compatible.\n" "\n" "@EXAMPLES=\n" "IMDIV(\"2-j\",\"2+j\") equals 0.6-0.8j.\n" "\n" "@SEEALSO=IMPRODUCT" msgstr "" #: ../plugins/fn-complex/functions.c:765 msgid "" "@FUNCTION=IMSIN\n" "@SYNTAX=IMSIN(inumber)\n" "@DESCRIPTION=IMSIN returns the sine of a complex number.\n" "\n" "* If @inumber is not a valid complex number, IMSIN returns #VALUE! error.\n" "* This function is Excel compatible.\n" "\n" "@EXAMPLES=\n" "IMSIN(\"1+j\") equals 1.29846+0.63496j.\n" "\n" "@SEEALSO=IMCOS,IMTAN" msgstr "" #: ../plugins/fn-complex/functions.c:798 msgid "" "@FUNCTION=IMSINH\n" "@SYNTAX=IMSINH(inumber)\n" "@DESCRIPTION=IMSINH returns the complex hyperbolic sine of the complex " "number z (@inumber), where\n" "\n" "\tsinh(z) = (exp(z) - exp(-z))/2.\n" "\n" "* If @inumber is not a valid complex number, IMSINH returns #VALUE! error.\n" "\n" "@EXAMPLES=\n" "IMSINH(\"1+j\") equals 0.63496+1.29846j.\n" "\n" "@SEEALSO=IMCOSH,IMTANH" msgstr "" #: ../plugins/fn-complex/functions.c:833 msgid "" "@FUNCTION=IMCOSH\n" "@SYNTAX=IMCOSH(inumber)\n" "@DESCRIPTION=IMCOSH returns the complex hyperbolic cosine of the complex " "number z (@inumber), where\n" "\n" "\tcosh(z) = (exp(z) + exp(-z))/2.\n" "\n" "* If @inumber is not a valid complex number, IMCOSH returns #VALUE! error.\n" "\n" "@EXAMPLES=\n" "IMCOSH(\"1+j\") equals 0.83373+0.988898j.\n" "\n" "@SEEALSO=IMSINH,IMTANH" msgstr "" #: ../plugins/fn-complex/functions.c:867 msgid "" "@FUNCTION=IMTANH\n" "@SYNTAX=IMTANH(inumber)\n" "@DESCRIPTION=IMTANH returns the complex hyperbolic tangent of the complex " "number z (@inumber), where\n" "\n" "\ttanh(z) = sinh(z)/cosh(z).\n" "\n" "* If @inumber is not a valid complex number, IMTANH returns #VALUE! error.\n" "\n" "@EXAMPLES=\n" "IMTANH(\"1+j\") equals 1.083923+0.2717526j.\n" "\n" "@SEEALSO=IMSINH,IMCOSH" msgstr "" #: ../plugins/fn-complex/functions.c:901 msgid "" "@FUNCTION=IMSECH\n" "@SYNTAX=IMSECH(inumber)\n" "@DESCRIPTION=IMSECH returns the complex hyperbolic secant of the complex " "number z (@inumber), where\n" "\n" "\tsech(z) = 1/cosh(z).\n" "\n" "* If @inumber is not a valid complex number, IMSECH returns #VALUE! error.\n" "\n" "@EXAMPLES=\n" "IMSECH(\"1+j\") equals 0.498337-0.5910838j.\n" "\n" "@SEEALSO=IMCSCH,IMCOTH" msgstr "" #: ../plugins/fn-complex/functions.c:935 msgid "" "@FUNCTION=IMCSCH\n" "@SYNTAX=IMCSCH(inumber)\n" "@DESCRIPTION=IMCSCH returns the complex hyperbolic cosecant of the complex " "number z (@inumber), where\n" "\n" "\tcsch(z) = 1/sinh(z).\n" "\n" "* If @inumber is not a valid complex number, IMCSCH returns #VALUE! error.\n" "\n" "@EXAMPLES=\n" "IMCSCH(\"1+j\") equals 0.303931-0.621518j.\n" "\n" "@SEEALSO=IMSECH,IMCOTH" msgstr "" #: ../plugins/fn-complex/functions.c:969 msgid "" "@FUNCTION=IMCOTH\n" "@SYNTAX=IMCOTH(inumber)\n" "@DESCRIPTION=IMCOTH returns the complex hyperbolic cotangent of the complex " "number z (@inumber) where,\n" "\n" "\tcoth(z) = 1/tanh(z).\n" "\n" "* If @inumber is not a valid complex number, IMCOTH returns #VALUE! error.\n" "\n" "@EXAMPLES=\n" "IMCOTH(\"1+j\") equals 0.868014-0.217622j.\n" "\n" "@SEEALSO=IMSECH,IMCSCH" msgstr "" #: ../plugins/fn-complex/functions.c:1003 msgid "" "@FUNCTION=IMARCSIN\n" "@SYNTAX=IMARCSIN(inumber)\n" "@DESCRIPTION=IMARCSIN returns the complex arcsine of the complex number " "@inumber. The branch cuts are on the real axis, less than -1 and greater " "than 1.\n" "\n" "* If @inumber is not a valid complex number, IMARCSIN returns #VALUE! " "error.\n" "\n" "@EXAMPLES=\n" "IMARCSIN(\"1+j\") equals 0.6662394+1.061275j.\n" "\n" "@SEEALSO=IMARCCOS,IMARCTAN" msgstr "" #: ../plugins/fn-complex/functions.c:1038 msgid "" "@FUNCTION=IMARCCOS\n" "@SYNTAX=IMARCCOS(inumber)\n" "@DESCRIPTION=IMARCCOS returns the complex arccosine of the complex number " "@inumber. The branch cuts are on the real axis, less than -1 and greater " "than 1.\n" "\n" "* If @inumber is not a valid complex number, IMARCCOS returns #VALUE! " "error.\n" "\n" "@EXAMPLES=\n" "IMARCCOS(\"1+j\") equals 0.9045569-1.061275j.\n" "\n" "@SEEALSO=IMARCSIN,IMARCTAN" msgstr "" #: ../plugins/fn-complex/functions.c:1073 msgid "" "@FUNCTION=IMARCTAN\n" "@SYNTAX=IMARCTAN(inumber)\n" "@DESCRIPTION=IMARCTAN returns the complex arctangent of the complex number " "@inumber. The branch cuts are on the imaginary axis, below -i and above i.\n" "\n" "* If @inumber is not a valid complex number, IMARCTAN returns #VALUE! " "error.\n" "\n" "@EXAMPLES=\n" "IMARCTAN(\"1+j\") equals 1.0172220+0.4023595j.\n" "\n" "@SEEALSO=IMARCSIN,IMARCCOS" msgstr "" #: ../plugins/fn-complex/functions.c:1108 msgid "" "@FUNCTION=IMARCSEC\n" "@SYNTAX=IMARCSEC(inumber)\n" "@DESCRIPTION=IMARCSEC returns the complex arcsecant of the complex number z " "(@inumber), where\n" "\n" "\tarcsec(z) = arccos(1/z).\n" "\n" "* If @inumber is not a valid complex number, IMARCSEC returns #VALUE! " "error.\n" "\n" "@EXAMPLES=\n" "IMARCSEC(\"1+j\") equals 1.1185179+0.5306375j.\n" "\n" "@SEEALSO=IMARCCSC,IMARCCOT" msgstr "" #: ../plugins/fn-complex/functions.c:1142 msgid "" "@FUNCTION=IMARCCSC\n" "@SYNTAX=IMARCCSC(inumber)\n" "@DESCRIPTION=IMARCCSC returns the complex arccosecant of the complex number " "z (@inumber), where\n" "\n" "\tarccsc(z) = arcsin(1/z).\n" "\n" "* If @inumber is not a valid complex number, IMARCCSC returns #VALUE! " "error.\n" "\n" "@EXAMPLES=\n" "IMARCCSC(\"1+j\") equals 0.45227845-0.5306375j.\n" "\n" "@SEEALSO=IMARCSEC,IMARCCOT" msgstr "" #: ../plugins/fn-complex/functions.c:1176 msgid "" "@FUNCTION=IMARCCOT\n" "@SYNTAX=IMARCCOT(inumber)\n" "@DESCRIPTION=IMARCCOT returns the complex arccotangent of the complex number " "z (@inumber), where\n" "\n" "\tarccot(z) = arctan(1/z).\n" "\n" "* If @inumber is not a valid complex number, IMARCCOT returns #VALUE! " "error.\n" "\n" "@EXAMPLES=\n" "IMARCCOT(\"1+j\") equals 0.553574+0.4023595j.\n" "\n" "@SEEALSO=IMARCSEC,IMARCCSC" msgstr "" #: ../plugins/fn-complex/functions.c:1210 msgid "" "@FUNCTION=IMARCSINH\n" "@SYNTAX=IMARCSINH(inumber)\n" "@DESCRIPTION=IMARCSINH returns the complex hyperbolic arcsine of the complex " "number @inumber. The branch cuts are on the imaginary axis, below -i and " "above i.\n" "\n" "* If @inumber is not a valid complex number, IMARCSINH returns #VALUE! " "error.\n" "\n" "@EXAMPLES=\n" "IMARCSINH(\"1+j\") equals 1.061275+0.6662394j.\n" "\n" "@SEEALSO=IMARCCOSH,IMARCTANH" msgstr "" #: ../plugins/fn-complex/functions.c:1245 msgid "" "@FUNCTION=IMARCCOSH\n" "@SYNTAX=IMARCCOSH(inumber)\n" "@DESCRIPTION=IMARCCOSH returns the complex hyperbolic arccosine of the " "complex number @inumber. The branch cut is on the real axis, less than 1.\n" "\n" "* If @inumber is not a valid complex number, IMARCCOSH returns #VALUE! " "error.\n" "\n" "@EXAMPLES=\n" "IMARCCOSH(\"1+j\") equals 1.06127506+0.904557j.\n" "\n" "@SEEALSO=IMARCSINH,IMARCTANH" msgstr "" #: ../plugins/fn-complex/functions.c:1280 msgid "" "@FUNCTION=IMARCTANH\n" "@SYNTAX=IMARCTANH(inumber)\n" "@DESCRIPTION=IMARCTANH returns the complex hyperbolic arctangent of the " "complex number @inumber. The branch cuts are on the real axis, less than -1 " "and greater than 1.\n" "\n" "* If @inumber is not a valid complex number, IMARCTANH returns #VALUE! " "error.\n" "\n" "@EXAMPLES=\n" "IMARCTANH(\"1+j\") equals 0.4023595+1.0172220j.\n" "\n" "@SEEALSO=IMARCSINH,IMARCCOSH" msgstr "" #: ../plugins/fn-complex/functions.c:1315 msgid "" "@FUNCTION=IMARCSECH\n" "@SYNTAX=IMARCSECH(inumber)\n" "@DESCRIPTION=IMARCSECH returns the complex hyperbolic arcsecant of the " "complex number z (@inumber), where\n" "\n" "\tarcsech(z) = arccosh(1/z).\n" "\n" "* If @inumber is not a valid complex number, IMARCSECH returns #VALUE! " "error.\n" "\n" "@EXAMPLES=\n" "IMARCSECH(\"1+j\") equals 0.5306375-1.118518j.\n" "\n" "@SEEALSO=IMARCCSCH,IMARCCOTH" msgstr "" #: ../plugins/fn-complex/functions.c:1350 msgid "" "@FUNCTION=IMARCCSCH\n" "@SYNTAX=IMARCCSCH(inumber)\n" "@DESCRIPTION=IMARCCSCH returns the complex hyperbolic arccosecant of the " "complex number z (@inumber), where\n" "\n" "\tarccsch(z) = arcsinh(1/z).\n" "\n" "* If @inumber is not a valid complex number, IMARCCSCH returns #VALUE! " "error.\n" "\n" "@EXAMPLES=\n" "IMARCCSCH(\"1+j\") equals 0.5306375-0.452278j.\n" "\n" "@SEEALSO=IMARCSECH,IMARCCOTH" msgstr "" #: ../plugins/fn-complex/functions.c:1384 msgid "" "@FUNCTION=IMARCCOTH\n" "@SYNTAX=IMARCCOTH(inumber)\n" "@DESCRIPTION=IMARCCOTH returns the complex hyperbolic arccotangent of the " "complex number z (@inumber), where\n" "\n" "\tarccoth(z) = arctanh(1/z).\n" "\n" "* If @inumber is not a valid complex number, IMARCCOTH returns #VALUE! " "error.\n" "\n" "@EXAMPLES=\n" "IMARCCOTH(\"1+j\") equals 0.40235948-0.5535744j.\n" "\n" "@SEEALSO=IMARCSECH,IMARCCSCH" msgstr "" #: ../plugins/fn-complex/functions.c:1419 msgid "" "@FUNCTION=IMSQRT\n" "@SYNTAX=IMSQRT(inumber)\n" "@DESCRIPTION=IMSQRT returns the square root of a complex number.\n" "\n" "* If @inumber is not a valid complex number, IMSQRT returns #VALUE! error.\n" "* This function is Excel compatible.\n" "\n" "@EXAMPLES=\n" "IMSQRT(\"1+j\") equals 1.09868+0.4550899j.\n" "\n" "@SEEALSO=IMPOWER" msgstr "" #: ../plugins/fn-complex/functions.c:1453 msgid "" "@FUNCTION=IMSUB\n" "@SYNTAX=IMSUB(inumber1,inumber2)\n" "@DESCRIPTION=IMSUB returns the difference of two complex numbers.\n" "\n" "* If @inumber1 or @inumber2 are not valid complex numbers, IMSUB returns " "#VALUE! error.\n" "* This function is Excel compatible.\n" "\n" "@EXAMPLES=\n" "IMSUB(\"3-j\",\"2+j\") equals 1-2j.\n" "\n" "@SEEALSO=IMSUM" msgstr "" #: ../plugins/fn-complex/functions.c:1490 msgid "" "@FUNCTION=IMPRODUCT\n" "@SYNTAX=IMPRODUCT(inumber1[,inumber2,...])\n" "@DESCRIPTION=IMPRODUCT returns the product of given complex numbers.\n" "\n" "* If any of the @inumbers are not valid complex numbers, IMPRODUCT returns " "#VALUE! error.\n" "* This function is Excel compatible.\n" "\n" "@EXAMPLES=\n" "IMPRODUCT(\"2-j\",\"4-2j\") equals 6-8j.\n" "\n" "@SEEALSO=IMDIV" msgstr "" #: ../plugins/fn-complex/functions.c:1567 msgid "" "@FUNCTION=IMSUM\n" "@SYNTAX=IMSUM(inumber1,inumber2)\n" "@DESCRIPTION=IMSUM returns the sum of two complex numbers.\n" "\n" "* If @inumber1 or @inumber2 are not valid complex numbers, IMSUM returns " "#VALUE! error.\n" "* This function is Excel compatible.\n" "\n" "@EXAMPLES=\n" "IMSUM(\"2-4j\",\"9-j\") equals 11-5j.\n" "\n" "@SEEALSO=IMSUB" msgstr "" #: ../plugins/fn-database/functions.c:280 msgid "" "@FUNCTION=DAVERAGE\n" "@SYNTAX=DAVERAGE(database,field,criteria)\n" "@DESCRIPTION=DAVERAGE function returns the average of the values in a list " "or database that match conditions specified.\n" "\n" "@database is a range of cells in which rows of related information are " "records and columns of data are fields. The first row of a database contains " "labels for each column. \n" "\n" "@field specifies which column is used in the function. If @field is an " "integer, for example 2, the second column is used. Field can also be the " "label of a column. For example, ``Age'' refers to the column with the label " "``Age'' in @database range. \n" "\n" "@criteria is the range of cells which contains the specified conditions. " "The first row of a @criteria should contain the labels of the fields for " "which the criteria are for. Cells below the labels specify conditions, for " "example, ``>3'' or ``<9''. Equality condition can be given simply by " "specifying a value, e.g. ``3'' or ``John''. \n" "Each row in @criteria specifies a separate condition. If a row in @database " "matches a row in @criteria, then that row is counted. Technically speaking, " "this a boolean OR operation between the rows in @criteria.\n" "If @criteria specifies more than one column, then each of the conditions in " "the specified columns must be true for the row in @database to match. " "Technically speaking, this is a boolean AND operation between the columns in " "@criteria.\n" "\n" "@EXAMPLES=\n" "Let us assume that the range A1:C7 contain the following values:\n" "Name Age Salary\n" "John 34 54342\n" "Bill 35 22343\n" "Clark 29 34323\n" "Bob 43 47242\n" "Susan 37 42932\n" "Jill 45 45324\n" "\n" "In addition, the cells A9:B11 contain the following values:\n" "Age Salary\n" "<30\n" ">40 >46000\n" "\n" "DAVERAGE(A1:C7, \"Salary\", A9:A11) equals 42296.3333.\n" "DAVERAGE(A1:C7, \"Age\", A9:A11) equals 39.\n" "DAVERAGE(A1:C7, \"Salary\", A9:B11) equals 40782.5.\n" "DAVERAGE(A1:C7, \"Age\", A9:B11) equals 36.\n" "\n" "@SEEALSO=DCOUNT" msgstr "" #: ../plugins/fn-database/functions.c:357 msgid "" "@FUNCTION=DCOUNT\n" "@SYNTAX=DCOUNT(database,field,criteria)\n" "@DESCRIPTION=DCOUNT function counts the cells that contain numbers in a " "database that match conditions specified.\n" "\n" "@database is a range of cells in which rows of related information are " "records and columns of data are fields. The first row of a database contains " "labels for each column. \n" "\n" "@field specifies which column is used in the function. If @field is an " "integer, for example 2, the second column is used. Field can also be the " "label of a column. For example, ``Age'' refers to the column with the label " "``Age'' in @database range. \n" "\n" "@criteria is the range of cells which contains the specified conditions. " "The first row of a @criteria should contain the labels of the fields for " "which the criteria are for. Cells below the labels specify conditions, for " "example, ``>3'' or ``<9''. Equality condition can be given simply by " "specifying a value, e.g. ``3'' or ``John''. \n" "Each row in @criteria specifies a separate condition. If a row in @database " "matches a row in @criteria, then that row is counted. Technically speaking, " "this a boolean OR operation between the rows in @criteria.\n" "If @criteria specifies more than one column, then each of the conditions in " "the specified columns must be true for the row in @database to match. " "Technically speaking, this is a boolean AND operation between the columns in " "@criteria.\n" "\n" "@EXAMPLES=\n" "Let us assume that the range A1:C7 contain the following values:\n" "Name Age Salary\n" "John 34 54342\n" "Bill 35 22343\n" "Clark 29 34323\n" "Bob 43 47242\n" "Susan 37 42932\n" "Jill 45 45324\n" "\n" "In addition, the cells A9:B11 contain the following values:\n" "Age Salary\n" "<30\n" ">40 >46000\n" "\n" "DCOUNT(A1:C7, \"Salary\", A9:A11) equals 3.\n" "DCOUNT(A1:C7, \"Salary\", A9:B11) equals 2.\n" "DCOUNT(A1:C7, \"Name\", A9:B11) equals 0.\n" "\n" "@SEEALSO=DAVERAGE" msgstr "" #: ../plugins/fn-database/functions.c:433 msgid "" "@FUNCTION=DCOUNTA\n" "@SYNTAX=DCOUNTA(database,field,criteria)\n" "@DESCRIPTION=DCOUNTA function counts the cells that contain data in a " "database that match conditions specified.\n" "\n" "@database is a range of cells in which rows of related information are " "records and columns of data are fields. The first row of a database contains " "labels for each column. \n" "\n" "@field specifies which column is used in the function. If @field is an " "integer, for example 2, the second column is used. Field can also be the " "label of a column. For example, ``Age'' refers to the column with the label " "``Age'' in @database range. \n" "\n" "@criteria is the range of cells which contains the specified conditions. " "The first row of a @criteria should contain the labels of the fields for " "which the criteria are for. Cells below the labels specify conditions, for " "example, ``>3'' or ``<9''. Equality condition can be given simply by " "specifying a value, e.g. ``3'' or ``John''. \n" "Each row in @criteria specifies a separate condition. If a row in @database " "matches a row in @criteria, then that row is counted. Technically speaking, " "this a boolean OR operation between the rows in @criteria.\n" "If @criteria specifies more than one column, then each of the conditions in " "the specified columns must be true for the row in @database to match. " "Technically speaking, this is a boolean AND operation between the columns in " "@criteria.\n" "\n" "@EXAMPLES=\n" "Let us assume that the range A1:C7 contain the following values:\n" "Name Age Salary\n" "John 34 54342\n" "Bill 35 22343\n" "Clark 29 34323\n" "Bob 43 47242\n" "Susan 37 42932\n" "Jill 45 45324\n" "\n" "In addition, the cells A9:B11 contain the following values:\n" "Age Salary\n" "<30\n" ">40 >46000\n" "\n" "DCOUNTA(A1:C7, \"Salary\", A9:A11) equals 3.\n" "DCOUNTA(A1:C7, \"Salary\", A9:B11) equals 2.\n" "DCOUNTA(A1:C7, \"Name\", A9:B11) equals 2.\n" "\n" "@SEEALSO=DCOUNT" msgstr "" #: ../plugins/fn-database/functions.c:507 msgid "" "@FUNCTION=DGET\n" "@SYNTAX=DGET(database,field,criteria)\n" "@DESCRIPTION=DGET function returns a single value from a column that match " "conditions specified.\n" "\n" "@database is a range of cells in which rows of related information are " "records and columns of data are fields. The first row of a database contains " "labels for each column. \n" "\n" "@field specifies which column is used in the function. If @field is an " "integer, for example 2, the second column is used. Field can also be the " "label of a column. For example, ``Age'' refers to the column with the label " "``Age'' in @database range. \n" "\n" "@criteria is the range of cells which contains the specified conditions. " "The first row of a @criteria should contain the labels of the fields for " "which the criteria are for. Cells below the labels specify conditions, for " "example, ``>3'' or ``<9''. Equality condition can be given simply by " "specifying a value, e.g. ``3'' or ``John''. \n" "Each row in @criteria specifies a separate condition. If a row in @database " "matches a row in @criteria, then that row is counted. Technically speaking, " "this a boolean OR operation between the rows in @criteria.\n" "If @criteria specifies more than one column, then each of the conditions in " "the specified columns must be true for the row in @database to match. " "Technically speaking, this is a boolean AND operation between the columns in " "@criteria.\n" "\n" "@EXAMPLES=\n" "Let us assume that the range A1:C7 contain the following values:\n" "Name Age Salary\n" "John 34 54342\n" "Bill 35 22343\n" "Clark 29 34323\n" "Bob 43 47242\n" "Susan 37 42932\n" "Jill 45 45324\n" "\n" "In addition, the cells A9:B11 contain the following values:\n" "Age Salary\n" "<30\n" ">40 >46000\n" "\n" "* If none of the items match the conditions, DGET returns #VALUE! error.\n" "* If more than one items match the conditions, DGET returns #NUM! error.\n" "\n" "DGET(A1:C7, \"Salary\", A9:A10) equals 34323.\n" "DGET(A1:C7, \"Name\", A9:A10) equals \"Clark\".\n" "\n" "@SEEALSO=DCOUNT" msgstr "" #: ../plugins/fn-database/functions.c:593 msgid "" "@FUNCTION=DMAX\n" "@SYNTAX=DMAX(database,field,criteria)\n" "@DESCRIPTION=DMAX function returns the largest number in a column that match " "conditions specified.\n" "\n" "@database is a range of cells in which rows of related information are " "records and columns of data are fields. The first row of a database contains " "labels for each column. \n" "\n" "@field specifies which column is used in the function. If @field is an " "integer, for example 2, the second column is used. Field can also be the " "label of a column. For example, ``Age'' refers to the column with the label " "``Age'' in @database range. \n" "\n" "@criteria is the range of cells which contains the specified conditions. " "The first row of a @criteria should contain the labels of the fields for " "which the criteria are for. Cells below the labels specify conditions, for " "example, ``>3'' or ``<9''. Equality condition can be given simply by " "specifying a value, e.g. ``3'' or ``John''. \n" "Each row in @criteria specifies a separate condition. If a row in @database " "matches a row in @criteria, then that row is counted. Technically speaking, " "this a boolean OR operation between the rows in @criteria.\n" "If @criteria specifies more than one column, then each of the conditions in " "the specified columns must be true for the row in @database to match. " "Technically speaking, this is a boolean AND operation between the columns in " "@criteria.\n" "\n" "@EXAMPLES=\n" "Let us assume that the range A1:C7 contain the following values:\n" "Name Age Salary\n" "John 34 54342\n" "Bill 35 22343\n" "Clark 29 34323\n" "Bob 43 47242\n" "Susan 37 42932\n" "Jill 45 45324\n" "\n" "In addition, the cells A9:B11 contain the following values:\n" "Age Salary\n" "<30\n" ">40 >46000\n" "\n" "DMAX(A1:C7, \"Salary\", A9:A11) equals 47242.\n" "DMAX(A1:C7, \"Age\", A9:A11) equals 45.\n" "DMAX(A1:C7, \"Age\", A9:B11) equals 43.\n" "\n" "@SEEALSO=DMIN" msgstr "" #: ../plugins/fn-database/functions.c:671 msgid "" "@FUNCTION=DMIN\n" "@SYNTAX=DMIN(database,field,criteria)\n" "@DESCRIPTION=DMIN function returns the smallest number in a column that " "match conditions specified.\n" "\n" "@database is a range of cells in which rows of related information are " "records and columns of data are fields. The first row of a database contains " "labels for each column. \n" "\n" "@field specifies which column is used in the function. If @field is an " "integer, for example 2, the second column is used. Field can also be the " "label of a column. For example, ``Age'' refers to the column with the label " "``Age'' in @database range. \n" "\n" "@criteria is the range of cells which contains the specified conditions. " "The first row of a @criteria should contain the labels of the fields for " "which the criteria are for. Cells below the labels specify conditions, for " "example, ``>3'' or ``<9''. Equality condition can be given simply by " "specifying a value, e.g. ``3'' or ``John''. \n" "Each row in @criteria specifies a separate condition. If a row in @database " "matches a row in @criteria, then that row is counted. Technically speaking, " "this a boolean OR operation between the rows in @criteria.\n" "If @criteria specifies more than one column, then each of the conditions in " "the specified columns must be true for the row in @database to match. " "Technically speaking, this is a boolean AND operation between the columns in " "@criteria.\n" "\n" "@EXAMPLES=\n" "Let us assume that the range A1:C7 contain the following values:\n" "Name Age Salary\n" "John 34 54342\n" "Bill 35 22343\n" "Clark 29 34323\n" "Bob 43 47242\n" "Susan 37 42932\n" "Jill 45 45324\n" "\n" "In addition, the cells A9:B11 contain the following values:\n" "Age Salary\n" "<30\n" ">40 >46000\n" "\n" "DMIN(A1:C7, \"Salary\", A9:B11) equals 34323.\n" "DMIN(A1:C7, \"Age\", A9:B11) equals 29.\n" "\n" "@SEEALSO=DMAX" msgstr "" #: ../plugins/fn-database/functions.c:746 msgid "" "@FUNCTION=DPRODUCT\n" "@SYNTAX=DPRODUCT(database,field,criteria)\n" "@DESCRIPTION=DPRODUCT function returns the product of numbers in a column " "that match conditions specified.\n" "\n" "@database is a range of cells in which rows of related information are " "records and columns of data are fields. The first row of a database contains " "labels for each column. \n" "\n" "@field specifies which column is used in the function. If @field is an " "integer, for example 2, the second column is used. Field can also be the " "label of a column. For example, ``Age'' refers to the column with the label " "``Age'' in @database range. \n" "\n" "@criteria is the range of cells which contains the specified conditions. " "The first row of a @criteria should contain the labels of the fields for " "which the criteria are for. Cells below the labels specify conditions, for " "example, ``>3'' or ``<9''. Equality condition can be given simply by " "specifying a value, e.g. ``3'' or ``John''. \n" "Each row in @criteria specifies a separate condition. If a row in @database " "matches a row in @criteria, then that row is counted. Technically speaking, " "this a boolean OR operation between the rows in @criteria.\n" "If @criteria specifies more than one column, then each of the conditions in " "the specified columns must be true for the row in @database to match. " "Technically speaking, this is a boolean AND operation between the columns in " "@criteria.\n" "\n" "@EXAMPLES=\n" "Let us assume that the range A1:C7 contain the following values:\n" "Name Age Salary\n" "John 34 54342\n" "Bill 35 22343\n" "Clark 29 34323\n" "Bob 43 47242\n" "Susan 37 42932\n" "Jill 45 45324\n" "\n" "In addition, the cells A9:B11 contain the following values:\n" "Age Salary\n" "<30\n" ">40 >46000\n" "\n" "DPRODUCT(A1:C7, \"Age\", A9:B11) equals 1247.\n" "\n" "@SEEALSO=DSUM" msgstr "" #: ../plugins/fn-database/functions.c:821 msgid "" "@FUNCTION=DSTDEV\n" "@SYNTAX=DSTDEV(database,field,criteria)\n" "@DESCRIPTION=DSTDEV function returns the estimate of the standard deviation " "of a population based on a sample. The population consists of numbers that " "match conditions specified.\n" "\n" "@database is a range of cells in which rows of related information are " "records and columns of data are fields. The first row of a database contains " "labels for each column. \n" "\n" "@field specifies which column is used in the function. If @field is an " "integer, for example 2, the second column is used. Field can also be the " "label of a column. For example, ``Age'' refers to the column with the label " "``Age'' in @database range. \n" "\n" "@criteria is the range of cells which contains the specified conditions. " "The first row of a @criteria should contain the labels of the fields for " "which the criteria are for. Cells below the labels specify conditions, for " "example, ``>3'' or ``<9''. Equality condition can be given simply by " "specifying a value, e.g. ``3'' or ``John''. \n" "Each row in @criteria specifies a separate condition. If a row in @database " "matches a row in @criteria, then that row is counted. Technically speaking, " "this a boolean OR operation between the rows in @criteria.\n" "If @criteria specifies more than one column, then each of the conditions in " "the specified columns must be true for the row in @database to match. " "Technically speaking, this is a boolean AND operation between the columns in " "@criteria.\n" "\n" "@EXAMPLES=\n" "Let us assume that the range A1:C7 contain the following values:\n" "Name Age Salary\n" "John 34 54342\n" "Bill 35 22343\n" "Clark 29 34323\n" "Bob 43 47242\n" "Susan 37 42932\n" "Jill 45 45324\n" "\n" "In addition, the cells A9:B11 contain the following values:\n" "Age Salary\n" "<30\n" ">40 >46000\n" "\n" "DSTDEV(A1:C7, \"Age\", A9:B11) equals 9.89949.\n" "DSTDEV(A1:C7, \"Salary\", A9:B11) equals 9135.112506.\n" "\n" "@SEEALSO=DSTDEVP" msgstr "" #: ../plugins/fn-database/functions.c:897 msgid "" "@FUNCTION=DSTDEVP\n" "@SYNTAX=DSTDEVP(database,field,criteria)\n" "@DESCRIPTION=DSTDEVP function returns the standard deviation of a population " "based on the entire population. The population consists of numbers that " "match conditions specified.\n" "\n" "@database is a range of cells in which rows of related information are " "records and columns of data are fields. The first row of a database contains " "labels for each column. \n" "\n" "@field specifies which column is used in the function. If @field is an " "integer, for example 2, the second column is used. Field can also be the " "label of a column. For example, ``Age'' refers to the column with the label " "``Age'' in @database range. \n" "\n" "@criteria is the range of cells which contains the specified conditions. " "The first row of a @criteria should contain the labels of the fields for " "which the criteria are for. Cells below the labels specify conditions, for " "example, ``>3'' or ``<9''. Equality condition can be given simply by " "specifying a value, e.g. ``3'' or ``John''. \n" "Each row in @criteria specifies a separate condition. If a row in @database " "matches a row in @criteria, then that row is counted. Technically speaking, " "this a boolean OR operation between the rows in @criteria.\n" "If @criteria specifies more than one column, then each of the conditions in " "the specified columns must be true for the row in @database to match. " "Technically speaking, this is a boolean AND operation between the columns in " "@criteria.\n" "\n" "@EXAMPLES=\n" "Let us assume that the range A1:C7 contain the following values:\n" "Name Age Salary\n" "John 34 54342\n" "Bill 35 22343\n" "Clark 29 34323\n" "Bob 43 47242\n" "Susan 37 42932\n" "Jill 45 45324\n" "\n" "In addition, the cells A9:B11 contain the following values:\n" "Age Salary\n" "<30\n" ">40 >46000\n" "\n" "DSTDEVP(A1:C7, \"Age\", A9:B11) equals 7.\n" "DSTDEVP(A1:C7, \"Salary\", A9:B11) equals 6459.5.\n" "\n" "@SEEALSO=DSTDEV" msgstr "" #: ../plugins/fn-database/functions.c:973 msgid "" "@FUNCTION=DSUM\n" "@SYNTAX=DSUM(database,field,criteria)\n" "@DESCRIPTION=DSUM function returns the sum of numbers in a column that match " "conditions specified.\n" "\n" "@database is a range of cells in which rows of related information are " "records and columns of data are fields. The first row of a database contains " "labels for each column. \n" "\n" "@field specifies which column is used in the function. If @field is an " "integer, for example 2, the second column is used. Field can also be the " "label of a column. For example, ``Age'' refers to the column with the label " "``Age'' in @database range. \n" "\n" "@criteria is the range of cells which contains the specified conditions. " "The first row of a @criteria should contain the labels of the fields for " "which the criteria are for. Cells below the labels specify conditions, for " "example, ``>3'' or ``<9''. Equality condition can be given simply by " "specifying a value, e.g. ``3'' or ``John''. \n" "Each row in @criteria specifies a separate condition. If a row in @database " "matches a row in @criteria, then that row is counted. Technically speaking, " "this a boolean OR operation between the rows in @criteria.\n" "If @criteria specifies more than one column, then each of the conditions in " "the specified columns must be true for the row in @database to match. " "Technically speaking, this is a boolean AND operation between the columns in " "@criteria.\n" "\n" "@EXAMPLES=\n" "Let us assume that the range A1:C7 contain the following values:\n" "Name Age Salary\n" "John 34 54342\n" "Bill 35 22343\n" "Clark 29 34323\n" "Bob 43 47242\n" "Susan 37 42932\n" "Jill 45 45324\n" "\n" "In addition, the cells A9:B11 contain the following values:\n" "Age Salary\n" "<30\n" ">40 >46000\n" "\n" "DSUM(A1:C7, \"Age\", A9:B11) equals 72.\n" "DSUM(A1:C7, \"Salary\", A9:B11) equals 81565.\n" "\n" "@SEEALSO=DPRODUCT" msgstr "" #: ../plugins/fn-database/functions.c:1049 msgid "" "@FUNCTION=DVAR\n" "@SYNTAX=DVAR(database,field,criteria)\n" "@DESCRIPTION=DVAR function returns the estimate of variance of a population " "based on a sample. The population consists of numbers that match conditions " "specified.\n" "\n" "@database is a range of cells in which rows of related information are " "records and columns of data are fields. The first row of a database contains " "labels for each column. \n" "\n" "@field specifies which column is used in the function. If @field is an " "integer, for example 2, the second column is used. Field can also be the " "label of a column. For example, ``Age'' refers to the column with the label " "``Age'' in @database range. \n" "\n" "@criteria is the range of cells which contains the specified conditions. " "The first row of a @criteria should contain the labels of the fields for " "which the criteria are for. Cells below the labels specify conditions, for " "example, ``>3'' or ``<9''. Equality condition can be given simply by " "specifying a value, e.g. ``3'' or ``John''. \n" "Each row in @criteria specifies a separate condition. If a row in @database " "matches a row in @criteria, then that row is counted. Technically speaking, " "this a boolean OR operation between the rows in @criteria.\n" "If @criteria specifies more than one column, then each of the conditions in " "the specified columns must be true for the row in @database to match. " "Technically speaking, this is a boolean AND operation between the columns in " "@criteria.\n" "\n" "@EXAMPLES=\n" "Let us assume that the range A1:C7 contain the following values:\n" "Name Age Salary\n" "John 34 54342\n" "Bill 35 22343\n" "Clark 29 34323\n" "Bob 43 47242\n" "Susan 37 42932\n" "Jill 45 45324\n" "\n" "In addition, the cells A9:B11 contain the following values:\n" "Age Salary\n" "<30\n" ">40 >46000\n" "\n" "DVAR(A1:C7, \"Age\", A9:B11) equals 98.\n" "DVAR(A1:C7, \"Salary\", A9:B11) equals 83450280.5.\n" "\n" "@SEEALSO=DVARP" msgstr "" #: ../plugins/fn-database/functions.c:1125 msgid "" "@FUNCTION=DVARP\n" "@SYNTAX=DVARP(database,field,criteria)\n" "@DESCRIPTION=DVARP function returns the variance of a population based on " "the entire population. The population consists of numbers that match " "conditions specified.\n" "\n" "@database is a range of cells in which rows of related information are " "records and columns of data are fields. The first row of a database contains " "labels for each column. \n" "\n" "@field specifies which column is used in the function. If @field is an " "integer, for example 2, the second column is used. Field can also be the " "label of a column. For example, ``Age'' refers to the column with the label " "``Age'' in @database range. \n" "\n" "@criteria is the range of cells which contains the specified conditions. " "The first row of a @criteria should contain the labels of the fields for " "which the criteria are for. Cells below the labels specify conditions, for " "example, ``>3'' or ``<9''. Equality condition can be given simply by " "specifying a value, e.g. ``3'' or ``John''. \n" "Each row in @criteria specifies a separate condition. If a row in @database " "matches a row in @criteria, then that row is counted. Technically speaking, " "this a boolean OR operation between the rows in @criteria.\n" "If @criteria specifies more than one column, then each of the conditions in " "the specified columns must be true for the row in @database to match. " "Technically speaking, this is a boolean AND operation between the columns in " "@criteria.\n" "\n" "@EXAMPLES=\n" "Let us assume that the range A1:C7 contain the following values:\n" "Name Age Salary\n" "John 34 54342\n" "Bill 35 22343\n" "Clark 29 34323\n" "Bob 43 47242\n" "Susan 37 42932\n" "Jill 45 45324\n" "\n" "In addition, the cells A9:B11 contain the following values:\n" "Age Salary\n" "<30\n" ">40 >46000\n" "\n" "DVARP(A1:C7, \"Age\", A9:B11) equals 49.\n" "DVARP(A1:C7, \"Salary\", A9:B11) equals 41725140.25.\n" "\n" "@SEEALSO=DVAR" msgstr "" #: ../plugins/fn-database/functions.c:1201 msgid "" "@FUNCTION=GETPIVOTDATA\n" "@SYNTAX=GETPIVOTDATA(pivot_table,field_name)\n" "@DESCRIPTION=GETPIVOTDATA function fetches summary data from a pivot table. " "@pivot_table is a cell range containing the pivot table. @field_name is the " "name of the field of which you want the summary data.\n" "\n" "* If the summary data is unavailable, GETPIVOTDATA returns #REF! error.\n" "\n" "@EXAMPLES=\n" "\n" "@SEEALSO=" msgstr "" #: ../plugins/fn-date/functions.c:99 msgid "" "@FUNCTION=DATE\n" "@SYNTAX=DATE (year,month,day)\n" "@DESCRIPTION=DATE returns the number of days since the 1st of January of 1900" "(the date serial number) for the given year, month and day.\n" "\n" "* If @month < 1 or @month > 12, the year will be corrected. A similar " "correction takes place for days.\n" "* The @years should be at least 1900. If @years < 1900, it is assumed to be " "1900 + @years.\n" "* If the given date is not valid, DATE returns #NUM! error.\n" "* This function is Excel compatible.\n" "\n" "@EXAMPLES=\n" "DATE(2001, 3, 30) returns 'Mar 30, 2001'.\n" " \n" "@SEEALSO=TODAY, NOW" msgstr "" #: ../plugins/fn-date/functions.c:166 msgid "" "@FUNCTION=UNIX2DATE\n" "@SYNTAX=UNIX2DATE(unixtime)\n" "@DESCRIPTION=UNIX2DATE converts a unix time into a spreadsheet date and " "time.\n" "\n" "A unix time is the number of seconds since midnight January 1, 1970.\n" "\n" "@EXAMPLES=\n" "\n" "@SEEALSO=NOW, DATE, DATE2UNIX" msgstr "" #: ../plugins/fn-date/functions.c:200 msgid "" "@FUNCTION=DATE2UNIX\n" "@SYNTAX=DATE2UNIX(serial)\n" "@DESCRIPTION=DATE2UNIX converts a spreadsheet date and time serial number " "into a unix time.\n" "\n" "A unix time is the number of seconds since midnight January 1, 1970.\n" "\n" "@EXAMPLES=\n" "DATE2UNIX(\"01/01/2000\") equals 946656000.\n" "\n" "@SEEALSO=NOW, DATE, UNIX2DATE" msgstr "" #: ../plugins/fn-date/functions.c:237 msgid "" "@FUNCTION=DATEVALUE\n" "@SYNTAX=DATEVALUE(date_str)\n" "@DESCRIPTION=DATEVALUE returns the serial number of the date. @date_str is " "the string that contains the date. The value depends on the date " "convention. The MS Excel 1900 convention dates things from Jan 1 1900 while " "the 1904 convention uses Jan 1 1904.\n" "\n" "* This function is Excel compatible.\n" "\n" "@EXAMPLES=\n" "DATEVALUE(\"1/1/1999\") equals 36161 (in the 1900 convention).\n" "@SEEALSO=DATE" msgstr "" #: ../plugins/fn-date/functions.c:265 msgid "" "@FUNCTION=DATEDIF\n" "@SYNTAX=DATEDIF(date1,date2,interval)\n" "@DESCRIPTION=DATEDIF returns the difference between two dates. @interval is " "one of six possible values: \"y\", \"m\", \"d\", \"ym\", \"md\", and \"yd" "\".\n" "\n" "The first three options will return the number of complete years, months, or " "days, respectively, between the two dates specified.\n" "\n" " \"ym\" will return the number of full months between the two dates, not " "including the difference in years.\n" " \"md\" will return the number of full days between the two dates, not " "including the difference in months.\n" " \"yd\" will return the number of full days between the two dates, not " "including the difference in years.\n" "\n" "* This function is Excel compatible.\n" "\n" "@EXAMPLES=\n" "DATEDIF(DATE(2000,4,30),DATE(2003,8,4),\"d\") equals 1191.\n" "DATEDIF(DATE(2000,4,30),DATE(2003,8,4),\"y\") equals 3.\n" "\n" "@SEEALSO=DATE" msgstr "" #: ../plugins/fn-date/functions.c:417 msgid "" "@FUNCTION=EDATE\n" "@SYNTAX=EDATE(date,months)\n" "@DESCRIPTION=EDATE returns the serial number of the date that is the " "specified number of months before or after a given date. @date is the " "serial number of the initial date and @months is the number of months before " "(negative number) or after (positive number) the initial date.\n" "\n" "* If @months is not an integer, it is truncated.\n" "* This function is Excel compatible.\n" "\n" "@EXAMPLES=\n" "EDATE(DATE(2001,12,30),2) returns 'Feb 28, 2002'.\n" "\n" "@SEEALSO=DATE" msgstr "" #: ../plugins/fn-date/functions.c:466 msgid "" "@FUNCTION=TODAY\n" "@SYNTAX=TODAY()\n" "@DESCRIPTION=TODAY returns the serial number for today (the number of days " "elapsed since the 1st of January of 1900).\n" "\n" "* This function is Excel compatible.\n" "\n" "@EXAMPLES=\n" "TODAY() returns 'Nov 6, 2001' on that particular day.\n" " \n" "@SEEALSO=NOW" msgstr "" #: ../plugins/fn-date/functions.c:492 msgid "" "@FUNCTION=NOW\n" "@SYNTAX=NOW ()\n" "@DESCRIPTION=NOW returns the serial number for the date and time at the time " "it is evaluated.\n" "\n" "Serial Numbers in Gnumeric are represented as follows: The integral part is " "the number of days since the 1st of January of 1900. The decimal part " "represent the fraction of the day and is mapped into hour, minutes and " "seconds.\n" "\n" "For example: .0 represents the beginning of the day, and 0.5 represents " "noon.\n" "\n" "* This function is Excel compatible.\n" "\n" "@EXAMPLES=\n" "NOW().\n" "\n" "@SEEALSO=TODAY" msgstr "" #: ../plugins/fn-date/functions.c:526 msgid "" "@FUNCTION=TIME\n" "@SYNTAX=TIME (hours,minutes,seconds)\n" "@DESCRIPTION=TIME returns a fraction representing the time of day.\n" "\n" "* This function is Excel compatible.\n" "\n" "@EXAMPLES=\n" "TIME(3, 5, 23) equals 3:05AM.\n" "\n" "@SEEALSO=HOUR" msgstr "" #: ../plugins/fn-date/functions.c:558 msgid "" "@FUNCTION=TIMEVALUE\n" "@SYNTAX=TIMEVALUE (timetext)\n" "@DESCRIPTION=TIMEVALUE returns a fraction representing the time of day, a " "number between 0 and 1.\n" "\n" "* This function is Excel compatible.\n" "\n" "@EXAMPLES=\n" "TIMEVALUE(\"3:05\") equals 0.128472.\n" "TIMEVALUE(\"2:24:53 PM\") equals 0.600613.\n" "\n" "@SEEALSO=HOUR,MINUTE" msgstr "" #: ../plugins/fn-date/functions.c:586 msgid "" "@FUNCTION=HOUR\n" "@SYNTAX=HOUR (date)\n" "@DESCRIPTION=HOUR converts a serial number to an hour. The hour is returned " "as an integer in the range 0 (12:00 A.M.) to 23 (11:00 P.M.).\n" "\n" "* Note that Gnumeric will perform regular string to serial number conversion " "for you, so you can enter a date as a string.\n" "* This function is Excel compatible.\n" "\n" "@EXAMPLES=\n" "HOUR(0.128472) equals 3.\n" "\n" "@SEEALSO=MINUTE, NOW, TIME, SECOND" msgstr "" #: ../plugins/fn-date/functions.c:623 msgid "" "@FUNCTION=MINUTE\n" "@SYNTAX=MINUTE (date)\n" "@DESCRIPTION=MINUTE converts a serial number to a minute. The minute is " "returned as an integer in the range 0 to 59.\n" "\n" "* Note that Gnumeric will perform regular string to serial number conversion " "for you, so you can enter a date as a string.\n" "* This function is Excel compatible.\n" "\n" "@EXAMPLES=\n" "MINUTE(0.128472) equals 5.\n" "\n" "@SEEALSO=HOUR, NOW, TIME, SECOND" msgstr "" #: ../plugins/fn-date/functions.c:660 msgid "" "@FUNCTION=SECOND\n" "@SYNTAX=SECOND (date)\n" "@DESCRIPTION=SECOND converts a serial number to a second. The second is " "returned as an integer in the range 0 to 59.\n" "\n" "* Note that Gnumeric will perform regular string to serial number conversion " "for you, so you can enter a date as a string.\n" "* This function is Excel compatible.\n" "\n" "@EXAMPLES=\n" "SECOND(0.600613) equals 53.\n" "\n" "@SEEALSO=HOUR, MINUTE, NOW, TIME" msgstr "" #: ../plugins/fn-date/functions.c:697 msgid "" "@FUNCTION=YEAR\n" "@SYNTAX=YEAR (date)\n" "@DESCRIPTION=YEAR converts a serial number to a year.\n" "\n" "* Note that Gnumeric will perform regular string to serial number conversion " "for you, so you can enter a date as a string.\n" "* This function is Excel compatible.\n" "\n" "@EXAMPLES=\n" "YEAR(DATE(2003, 4, 30)) equals 2003.\n" "\n" "@SEEALSO=DAY, MONTH, TIME, NOW" msgstr "" #: ../plugins/fn-date/functions.c:731 msgid "" "@FUNCTION=MONTH\n" "@SYNTAX=MONTH (date)\n" "@DESCRIPTION=MONTH converts a serial number to a month.\n" "\n" "* Note that Gnumeric will perform regular string to serial number conversion " "for you, so you can enter a date as a string.\n" "* This function is Excel compatible.\n" "\n" "@EXAMPLES=\n" "MONTH(DATE(2003, 4, 30)) equals 4.\n" "\n" "@SEEALSO=DAY, TIME, NOW, YEAR" msgstr "" #: ../plugins/fn-date/functions.c:765 msgid "" "@FUNCTION=DAY\n" "@SYNTAX=DAY (date)\n" "@DESCRIPTION=DAY converts a serial number to a day of month.\n" "\n" "* Note that Gnumeric will perform regular string to serial number conversion " "for you, so you can enter a date as a string.\n" "* This function is Excel compatible.\n" "\n" "@EXAMPLES=\n" "DAY(\"10/24/1968\") equals 24.\n" "\n" "@SEEALSO=MONTH, TIME, NOW, YEAR" msgstr "" #: ../plugins/fn-date/functions.c:799 msgid "" "@FUNCTION=WEEKDAY\n" "@SYNTAX=WEEKDAY (date[, method])\n" "@DESCRIPTION=WEEKDAY converts a serial number to a weekday.\n" "\n" "This function returns an integer indicating the day of week.\n" "@METHOD indicates the numbering system. It defaults to 1.\n" "\n" " For @METHOD=1: Sunday is 1, Monday is 2, etc.\n" " For @METHOD=2: Monday is 1, Tuesday is 2, etc.\n" " For @METHOD=3: Monday is 0, Tuesday is 1, etc.\n" "\n" "* Note that Gnumeric will perform regular string to serial number conversion " "for you, so you can enter a date as a string.\n" "* This function is Excel compatible.\n" "\n" "@EXAMPLES=\n" "WEEKDAY(\"10/24/1968\") equals 5 (Thursday).\n" "\n" "@SEEALSO=DAY, MONTH, TIME, NOW, YEAR" msgstr "" #: ../plugins/fn-date/functions.c:853 msgid "" "@FUNCTION=DAYS360 \n" "@SYNTAX=DAYS360 (date1,date2,method)\n" "@DESCRIPTION=DAYS360 returns the number of days from @date1 to @date2 " "following a 360-day calendar in which all months are assumed to have 30 " "days.\n" "\n" "* If @method is 1, the European method will be used. In this case, if the " "day of the month is 31 it will be considered as 30.\n" "* If @method is 0 or omitted, the MS Excel (tm) US method will be used. " "This is a somewhat complicated industry standard method where the last day " "of February is considered to be the 30th day of the month, but only for the " "first date.\n" "* If @method is 2, a saner version of the US method is used in which both " "dates get the same February treatment.\n" "* Note that Gnumeric will perform regular string to serial number conversion " "for you, so you can enter a date as a string.\n" "* This function is mostly Excel compatible.\n" "\n" "@EXAMPLES=\n" "DAYS360(DATE(2003, 2, 3), DATE(2007, 4, 2)) equals 1499.\n" "\n" "@SEEALSO=MONTH, TIME, NOW, YEAR" msgstr "" #: ../plugins/fn-date/functions.c:913 msgid "" "@FUNCTION=EOMONTH\n" "@SYNTAX=EOMONTH (start_date,months)\n" "@DESCRIPTION=EOMONTH returns the last day of the month which is @months from " "the @start_date.\n" "\n" "* EOMONTH returns #NUM! if @start_date or @months are invalid.\n" "* This function is Excel compatible.\n" "\n" "@EXAMPLES=\n" "If A1 contains 12/21/00 then EOMONTH(A1,0)=12/31/00, EOMONTH(A1,5)=5/31/01, " "and EOMONTH(A1,2)=2/28/01\n" "\n" "@SEEALSO=MONTH" msgstr "" #: ../plugins/fn-date/functions.c:963 msgid "" "@FUNCTION=WORKDAY\n" "@SYNTAX=WORKDAY (start_date,days[,holidays])\n" "@DESCRIPTION=WORKDAY returns the date which is @days working days from the " "@start_date. Weekends and holidays optionally supplied in @holidays are " "respected.\n" "\n" "* WORKDAY returns #NUM! if @start_date or @days are invalid.\n" "* This function is Excel compatible.\n" "\n" "@EXAMPLES=\n" "DAY(WORKDAY(DATE(2001,1,5),30)) equals 16 and\n" "MONTH(WORKDAY(DATE(2001,1,5),30)) equals 2.\n" "\n" "@SEEALSO=NETWORKDAYS" msgstr "" #: ../plugins/fn-date/functions.c:1136 msgid "" "@FUNCTION=NETWORKDAYS\n" "@SYNTAX=NETWORKDAYS (start_date,end_date[,holidays])\n" "@DESCRIPTION=NETWORKDAYS returns the number of non-weekend non-holidays " "between @start_date and @end_date including these dates. Holidays are " "optionally supplied in @holidays.\n" "\n" "* NETWORKDAYS returns #NUM! if @start_date or @end_date are invalid.\n" "* This function is Excel compatible.\n" "\n" "@EXAMPLES=\n" "NETWORKDAYS(DATE(2001,1,2),DATE(2001,2,15)) equals 33.\n" "\n" "@SEEALSO=WORKDAY" msgstr "" #: ../plugins/fn-date/functions.c:1265 msgid "" "@FUNCTION=ISOWEEKNUM\n" "@SYNTAX=ISOWEEKNUM (date)\n" "@DESCRIPTION=ISOWEEKNUM returns the ISO 8601 week number of @date.\n" "\n" "An ISO 8601 week starts on Monday. Weeks are numbered from 1. A week " "including days from two different years is assigned to the year which " "includes the most days. This means that Dec 31 could be in week 1 of the " "following year, and Jan 1 could be in week 52 or 53 of the previous year. " "ISOWEEKNUM returns the week number.\n" "\n" "* ISOWEEKNUM returns #NUM! if date is invalid.\n" "\n" "@EXAMPLES=\n" "If A1 contains 12/21/00 then ISOWEEKNUM(A1)=51\n" "@SEEALSO=WEEKNUM, ISOYEAR" msgstr "" #: ../plugins/fn-date/functions.c:1302 msgid "" "@FUNCTION=ISOYEAR\n" "@SYNTAX=ISOYEAR (date)\n" "@DESCRIPTION=ISOYEAR returns the year of the ISO 8601 week number of @date.\n" "\n" "An ISO 8601 week starts on Monday. Weeks are numbered from 1. A week " "including days from two different years is assigned to the year which " "includes the most days. This means that Dec 31 could be in week 1 of the " "following year, and Jan 1 could be in week 52 or 53 of the previous year. " "ISOYEAR returns the year the week is assigned to.\n" "\n" "* ISOYEAR returns #NUM! if date is invalid.\n" "@EXAMPLES=\n" "If A1 contains 12/31/2001 then ISOYEAR(A1)=2002\n" "@SEEALSO=ISOWEEKNUM" msgstr "" #: ../plugins/fn-date/functions.c:1352 msgid "" "@FUNCTION=WEEKNUM\n" "@SYNTAX=WEEKNUM (date[,method])\n" "@DESCRIPTION=WEEKNUM returns the week number of @date according to the given " "@method.\n" "\n" "@method defaults to 1.\n" "\n" " For @method=1, week starts on Sunday, and days before first Sunday are in " "week 0.\n" " For @method=2, week starts on Monday, and days before first Monday are in " "week 0.\n" " For @method=150, the ISO 8601 week number is returned.\n" "\n" "* WEEKNUM returns #NUM! if @date or @method is invalid.\n" "* This function is Excel compatible, except that Excel does not support ISO " "8601 week numbers.\n" "\n" "@EXAMPLES=\n" "If A1 contains 12/21/00 then WEEKNUM(A1,2)=51\n" "@SEEALSO=ISOWEEKNUM" msgstr "" #: ../plugins/fn-date/functions.c:1400 msgid "" "@FUNCTION=YEARFRAC\n" "@SYNTAX=YEARFRAC (start_date, end_date [,basis])\n" "@DESCRIPTION=YEARFRAC returns the number of full days between @start_date " "and @end_date according to the @basis.\n" "\n" "@EXAMPLES=\n" "\n" "@SEEALSO=DATEDIF" msgstr "" #: ../plugins/fn-eng/functions.c:205 msgid "" "@FUNCTION=BASE\n" "@SYNTAX=BASE(number,base[,length])\n" "@DESCRIPTION=BASE function converts a number to a string representing that " "number in base @base.\n" "\n" "* @base must be an integer between 2 and 36.\n" "* This function is OpenOffice.Org compatible.\n" "* Optional argument @length specifies the minimum result length. Leading " "zeroes will be added to reach this length.\n" "\n" "@EXAMPLES=\n" "BASE(255,16,4) equals \"00FF\".\n" "\n" "@SEEALSO=DECIMAL" msgstr "" #: ../plugins/fn-eng/functions.c:243 msgid "" "@FUNCTION=BIN2DEC\n" "@SYNTAX=BIN2DEC(x)\n" "@DESCRIPTION=BIN2DEC function converts a binary number in string or number " "to its decimal equivalent.\n" "\n" "* This function is Excel compatible.\n" "\n" "@EXAMPLES=\n" "BIN2DEC(101) equals 5.\n" "\n" "@SEEALSO=DEC2BIN, BIN2OCT, BIN2HEX" msgstr "" #: ../plugins/fn-eng/functions.c:272 msgid "" "@FUNCTION=BIN2OCT\n" "@SYNTAX=BIN2OCT(number[,places])\n" "@DESCRIPTION=BIN2OCT function converts a binary number to an octal number. " "@places is an optional field, specifying to zero pad to that number of " "spaces.\n" "\n" "* If @places is too small or negative #NUM! error is returned.\n" "* This function is Excel compatible.\n" "\n" "@EXAMPLES=\n" "BIN2OCT(110111) equals 67.\n" "\n" "@SEEALSO=OCT2BIN, BIN2DEC, BIN2HEX" msgstr "" #: ../plugins/fn-eng/functions.c:304 msgid "" "@FUNCTION=BIN2HEX\n" "@SYNTAX=BIN2HEX(number[,places])\n" "@DESCRIPTION=BIN2HEX function converts a binary number to a hexadecimal " "number. @places is an optional field, specifying to zero pad to that number " "of spaces.\n" "\n" "* If @places is too small or negative #NUM! error is returned.\n" "* This function is Excel compatible.\n" "\n" "@EXAMPLES=\n" "BIN2HEX(100111) equals 27.\n" "\n" "@SEEALSO=HEX2BIN, BIN2OCT, BIN2DEC" msgstr "" #: ../plugins/fn-eng/functions.c:336 msgid "" "@FUNCTION=DEC2BIN\n" "@SYNTAX=DEC2BIN(number[,places])\n" "@DESCRIPTION=DEC2BIN function converts a decimal number to a binary number. " "@places is an optional field, specifying to zero pad to that number of " "spaces.\n" "\n" "* If @places is too small or negative #NUM! error is returned.\n" "* This function is Excel compatible.\n" "\n" "@EXAMPLES=\n" "DEC2BIN(42) equals 101010.\n" "\n" "@SEEALSO=BIN2DEC, DEC2OCT, DEC2HEX" msgstr "" #: ../plugins/fn-eng/functions.c:368 msgid "" "@FUNCTION=DEC2OCT\n" "@SYNTAX=DEC2OCT(number[,places])\n" "@DESCRIPTION=DEC2OCT function converts a decimal number to an octal number. " "@places is an optional field, specifying to zero pad to that number of " "spaces.\n" "\n" "* If @places is too small or negative #NUM! error is returned.\n" "* This function is Excel compatible.\n" "\n" "@EXAMPLES=\n" "DEC2OCT(42) equals 52.\n" "\n" "@SEEALSO=OCT2DEC, DEC2BIN, DEC2HEX" msgstr "" #: ../plugins/fn-eng/functions.c:400 msgid "" "@FUNCTION=DEC2HEX\n" "@SYNTAX=DEC2HEX(number[,places])\n" "@DESCRIPTION=DEC2HEX function converts a decimal number to a hexadecimal " "number. @places is an optional field, specifying to zero pad to that number " "of spaces.\n" "\n" "* If @places is too small or negative #NUM! error is returned.\n" "* This function is Excel compatible.\n" "\n" "@EXAMPLES=\n" "DEC2HEX(42) equals 2A.\n" "\n" "@SEEALSO=HEX2DEC, DEC2BIN, DEC2OCT" msgstr "" #: ../plugins/fn-eng/functions.c:432 msgid "" "@FUNCTION=DECIMAL\n" "@SYNTAX=DECIMAL(text,base)\n" "@DESCRIPTION=DECIMAL function converts a number in base @base to decimal.\n" "\n" "* @base must be an integer between 2 and 36.\n" "* This function is OpenOffice.Org compatible.\n" "\n" "@EXAMPLES=\n" "DECIMAL(\"A1\",16) equals 161.\n" "\n" "@SEEALSO=BASE" msgstr "" #: ../plugins/fn-eng/functions.c:464 msgid "" "@FUNCTION=OCT2DEC\n" "@SYNTAX=OCT2DEC(x)\n" "@DESCRIPTION=OCT2DEC function converts an octal number in a string or number " "to its decimal equivalent.\n" "\n" "* This function is Excel compatible.\n" "\n" "@EXAMPLES=\n" "OCT2DEC(\"124\") equals 84.\n" "\n" "@SEEALSO=DEC2OCT, OCT2BIN, OCT2HEX" msgstr "" #: ../plugins/fn-eng/functions.c:493 msgid "" "@FUNCTION=OCT2BIN\n" "@SYNTAX=OCT2BIN(number[,places])\n" "@DESCRIPTION=OCT2BIN function converts an octal number to a binary number. " "@places is an optional field, specifying to zero pad to that number of " "spaces.\n" "\n" "* If @places is too small or negative #NUM! error is returned.\n" "* This function is Excel compatible.\n" "\n" "@EXAMPLES=\n" "OCT2BIN(\"213\") equals 10001011.\n" "\n" "@SEEALSO=BIN2OCT, OCT2DEC, OCT2HEX" msgstr "" #: ../plugins/fn-eng/functions.c:525 msgid "" "@FUNCTION=OCT2HEX\n" "@SYNTAX=OCT2HEX(number[,places])\n" "@DESCRIPTION=OCT2HEX function converts an octal number to a hexadecimal " "number. @places is an optional field, specifying to zero pad to that number " "of spaces.\n" "\n" "* If @places is too small or negative #NUM! error is returned.\n" "* This function is Excel compatible.\n" "\n" "@EXAMPLES=\n" "OCT2HEX(132) equals 5A.\n" "\n" "@SEEALSO=HEX2OCT, OCT2BIN, OCT2DEC" msgstr "" #: ../plugins/fn-eng/functions.c:557 msgid "" "@FUNCTION=HEX2BIN\n" "@SYNTAX=HEX2BIN(number[,places])\n" "@DESCRIPTION=HEX2BIN function converts a hexadecimal number to a binary " "number. @places is an optional field, specifying to zero pad to that number " "of spaces.\n" "\n" "* If @places is too small or negative #NUM! error is returned.\n" "* This function is Excel compatible.\n" "\n" "@EXAMPLES=\n" "HEX2BIN(\"2A\") equals 101010.\n" "\n" "@SEEALSO=BIN2HEX, HEX2OCT, HEX2DEC" msgstr "" #: ../plugins/fn-eng/functions.c:589 msgid "" "@FUNCTION=HEX2OCT\n" "@SYNTAX=HEX2OCT(number[,places])\n" "@DESCRIPTION=HEX2OCT function converts a hexadecimal number to an octal " "number. @places is an optional field, specifying to zero pad to that number " "of spaces.\n" "\n" "* If @places is too small or negative #NUM! error is returned.\n" "* This function is Excel compatible.\n" "\n" "@EXAMPLES=\n" "HEX2OCT(\"2A\") equals 52.\n" "\n" "@SEEALSO=OCT2HEX, HEX2BIN, HEX2DEC" msgstr "" #: ../plugins/fn-eng/functions.c:621 msgid "" "@FUNCTION=HEX2DEC\n" "@SYNTAX=HEX2DEC(x)\n" "@DESCRIPTION=HEX2DEC function converts a hexadecimal number to its decimal " "equivalent.\n" "\n" "* This function is Excel compatible.\n" "\n" "@EXAMPLES=\n" "HEX2DEC(\"2A\") equals 42.\n" "\n" "@SEEALSO=DEC2HEX, HEX2BIN, HEX2OCT" msgstr "" #: ../plugins/fn-eng/functions.c:650 msgid "" "@FUNCTION=BESSELI\n" "@SYNTAX=BESSELI(x,y)\n" "@DESCRIPTION=BESSELI function returns the Neumann, Weber or Bessel " "function.\n" "\n" "@x is where the function is evaluated. @y is the order of the Bessel " "function.\n" "\n" "* If @x or @y are not numeric a #VALUE! error is returned.\n" "* If @y < 0 a #NUM! error is returned.\n" "* This function extends the Excel function of the same name to non-integer " "orders.\n" "\n" "@EXAMPLES=\n" "BESSELI(0.7,3) equals 0.007367374.\n" "\n" "@SEEALSO=BESSELJ,BESSELK,BESSELY" msgstr "" #: ../plugins/fn-eng/functions.c:701 msgid "" "@FUNCTION=BESSELK\n" "@SYNTAX=BESSELK(x,y)\n" "@DESCRIPTION=BESSELK function returns the Neumann, Weber or Bessel function. " "@x is where the function is evaluated. @y is the order of the Bessel " "function.\n" "\n" "* If @x or @y are not numeric a #VALUE! error is returned.\n" "* If @y < 0 a #NUM! error is returned.\n" "* This function extends the Excel function of the same name to non-integer " "orders.\n" "\n" "@EXAMPLES=\n" "BESSELK(3,9) equals 397.95880.\n" "\n" "@SEEALSO=BESSELI,BESSELJ,BESSELY" msgstr "" #: ../plugins/fn-eng/functions.c:736 msgid "" "@FUNCTION=BESSELJ\n" "@SYNTAX=BESSELJ(x,y)\n" "@DESCRIPTION=BESSELJ function returns the Bessel function with @x is where " "the function is evaluated. @y is the order of the Bessel function, if non-" "integer it is truncated.\n" "\n" "* If @x or @y are not numeric a #VALUE! error is returned.\n" "* If @y < 0 a #NUM! error is returned.\n" "* This function is Excel compatible.\n" "\n" "@EXAMPLES=\n" "BESSELJ(0.89,3) equals 0.013974004.\n" "\n" "@SEEALSO=BESSELI,BESSELK,BESSELY" msgstr "" #: ../plugins/fn-eng/functions.c:774 msgid "" "@FUNCTION=BESSELY\n" "@SYNTAX=BESSELY(x,y)\n" "@DESCRIPTION=BESSELY function returns the Neumann, Weber or Bessel " "function.\n" "\n" "@x is where the function is evaluated. @y is the order of the Bessel " "function, if non-integer it is truncated.\n" "\n" "* If @x or @y are not numeric a #VALUE! error is returned.\n" "* If @y < 0 a #NUM! error is returned.\n" "* This function is Excel compatible.\n" "\n" "@EXAMPLES=\n" "BESSELY(4,2) equals 0.215903595.\n" "\n" "@SEEALSO=BESSELI,BESSELJ,BESSELK" msgstr "" #: ../plugins/fn-eng/functions.c:816 msgid "" "@FUNCTION=CONVERT\n" "@SYNTAX=CONVERT(number,from_unit,to_unit)\n" "@DESCRIPTION=CONVERT returns a conversion from one measurement system to " "another. For example, you can convert a weight in pounds to a weight in " "grams. @number is the value you want to convert, @from_unit specifies the " "unit of the @number, and @to_unit is the unit for the result.\n" "\n" "@from_unit and @to_unit can be any of the following:\n" "\n" "Weight and mass:\n" "\t'g' \t\tGram\n" "\t'sg' \t\tSlug\n" "\t'lbm'\t\tPound\n" "\t'u' \t\tU (atomic mass)\n" "\t'ozm'\t\tOunce\n" "\n" "Distance:\n" "\t'm' \t\tMeter\n" "\t'mi' \t\tStatute mile\n" "\t'Nmi' \t\tNautical mile\n" "\t'in' \t\tInch\n" "\t'ft' \t\tFoot\n" "\t'yd' \t\tYard\n" "\t'ang' \t\tAngstrom\n" "\t'Pica'\t\tPica\n" "\n" "Time:\n" "\t'yr' \t\tYear\n" "\t'day' \t\tDay\n" "\t'hr' \t\tHour\n" "\t'mn' \t\tMinute\n" "\t'sec' \t\tSecond\n" "\n" "Pressure:\n" "\t'Pa' \t\tPascal\n" "\t'atm' \t\tAtmosphere\n" "\t'mmHg'\tmm of Mercury\n" "\n" "Force:\n" "\t'N' \t\tNewton\n" "\t'dyn' \t\tDyne\n" "\t'lbf' \t\tPound force\n" "\n" "Energy:\n" "\t'J' \t\tJoule\n" "\t'e' \t\tErg\n" "\t'c' \t\tThermodynamic calorie\n" "\t'cal' \t\tIT calorie\n" "\t'eV' \tElectron volt\n" "\t'HPh' \tHorsepower-hour\n" "\t'Wh' \tWatt-hour\n" "\t'flb' \t\tFoot-pound\n" "\t'BTU' \tBTU\n" "\n" "Power:\n" "\t'HP' \tHorsepower\n" "\t'W' \tWatt\n" "\n" "Magnetism:\n" "\t'T' \t\tTesla\n" "\t'ga' \tGauss\n" "\n" "Temperature:\n" "\t'C' \t\tDegree Celsius\n" "\t'F' \t\tDegree Fahrenheit\n" "\t'K' \t\tDegree Kelvin\n" "\n" "Liquid measure:\n" "\t'tsp' \t\tTeaspoon\n" "\t'tbs' \t\tTablespoon\n" "\t'oz' \t\tFluid ounce\n" "\t'cup' \tCup\n" "\t'pt' \t\tPint\n" "\t'qt' \t\tQuart\n" "\t'gal' \t\tGallon\n" "\t'l' \t\tLiter\n" "\n" "For metric units any of the following prefixes can be used:\n" "\t'Y' \tyotta \t1E+24\n" "\t'Z' \tzetta \t1E+21\n" "\t'E' \texa \t1E+18\n" "\t'P' \tpeta \t1E+15\n" "\t'T' \ttera \t\t1E+12\n" "\t'G' \tgiga \t1E+09\n" "\t'M' \tmega \t1E+06\n" "\t'k' \tkilo \t\t1E+03\n" "\t'h' \thecto \t1E+02\n" "\t'e' \tdeka \t1E+01\n" "\t'd' \tdeci \t1E-01\n" "\t'c' \tcenti \t\t1E-02\n" "\t'm' \tmilli \t\t1E-03\n" "\t'u' \tmicro \t1E-06\n" "\t'n' \tnano \t1E-09\n" "\t'p' \tpico \t1E-12\n" "\t'f' \tfemto \t1E-15\n" "\t'a' \tatto \t\t1E-18\n" "\t'z' \tzepto \t\t1E-21\n" "\t'y' \tyocto \t\t1E-24\n" "\n" "* If @from_unit and @to_unit are different types, CONVERT returns #N/A " "error.\n" "* This function is Excel compatible.\n" "\n" "@EXAMPLES=\n" "CONVERT(3,\"lbm\",\"g\") equals 1360.7769.\n" "CONVERT(5.8,\"m\",\"in\") equals 228.3465.\n" "CONVERT(7.9,\"cal\",\"J\") equals 33.07567.\n" "\n" "@SEEALSO=" msgstr "" #: ../plugins/fn-eng/functions.c:1233 msgid "" "@FUNCTION=ERF\n" "@SYNTAX=ERF([lower limit,]upper_limit)\n" "@DESCRIPTION=ERF returns the error function. With a single argument ERF " "returns the error function, defined as\n" "\n" "\terf(x) = 2/sqrt(pi)* integral from 0 to x of exp(-t*t) dt.\n" "\n" "If two arguments are supplied, they are the lower and upper limits of the " "integral.\n" "\n" "* If either @lower_limit or @upper_limit is not numeric a #VALUE! error is " "returned.\n" "* This function is upward-compatible with that in Excel. (If two arguments " "are supplied, Excel will not allow either to be negative.)\n" "\n" "@EXAMPLES=\n" "ERF(0.4) equals 0.428392355.\n" "ERF(1.6448536269515/SQRT(2)) equals 0.90.\n" "\n" "The second example shows that a random variable with a normal distribution " "has a 90 percent chance of falling within approximately 1.645 standard " "deviations of the mean.\n" "@SEEALSO=ERFC" msgstr "" #: ../plugins/fn-eng/functions.c:1284 msgid "" "@FUNCTION=ERFC\n" "@SYNTAX=ERFC(x)\n" "@DESCRIPTION=ERFC function returns the complementary error function, defined " "as\n" "\n" "\t1 - erf(x).\n" "\n" "erfc(x) is calculated more accurately than 1 - erf(x) for arguments larger " "than about 0.5.\n" "\n" "* If @x is not numeric a #VALUE! error is returned. \n" "@EXAMPLES=\n" "ERFC(6) equals 2.15197367e-17.\n" "\n" "@SEEALSO=ERF" msgstr "" #: ../plugins/fn-eng/functions.c:1315 msgid "" "@FUNCTION=DELTA\n" "@SYNTAX=DELTA(x[,y])\n" "@DESCRIPTION=DELTA function tests for numerical equivalence of two " "arguments, returning 1 in case of equality.\n" "\n" "* @y is optional, and defaults to 0.\n" "* If either argument is non-numeric returns a #VALUE! error.\n" "* This function is Excel compatible.\n" "\n" "@EXAMPLES=\n" "DELTA(42.99,43) equals 0.\n" "\n" "@SEEALSO=EXACT,GESTEP" msgstr "" #: ../plugins/fn-eng/functions.c:1347 msgid "" "@FUNCTION=GESTEP\n" "@SYNTAX=GESTEP(x[,y])\n" "@DESCRIPTION=GESTEP function tests if @x is >= @y, returning 1 if it is so, " "and 0 otherwise. @y is optional, and defaults to 0.\n" "\n" "* If either argument is non-numeric returns a #VALUE! error.\n" "* This function is Excel compatible.\n" "@EXAMPLES=\n" "GESTEP(5,4) equals 1.\n" "\n" "@SEEALSO=DELTA" msgstr "" #: ../plugins/fn-eng/functions.c:1378 msgid "" "@FUNCTION=INVSUMINV\n" "@SYNTAX=INVSUMINV(x1,x2,...)\n" "@DESCRIPTION=INVSUMINV sum calculates the inverse of the sum of inverses.\n" "\n" "The primary use of this is for calculating equivalent resistance for " "parallel resistors or equivalent capacitance of a series of capacitors.\n" "\n" "* All arguments must be non-negative, or else a #VALUE! result is returned.\n" "* If any argument is zero, the result is zero.\n" "\n" "@EXAMPLES=\n" "INVSUMINV(2000,2000) equals 1000.\n" "\n" "@SEEALSO=HARMEAN" msgstr "" #: ../plugins/fn-erlang/functions.c:107 msgid "" "@FUNCTION=PROBBLOCK\n" "@SYNTAX=PROBBLOCK(traffic,circuits)\n" "@DESCRIPTION=PROBBLOCK returns probability of blocking when a number of " "@traffic loads into a number of @circuits (servers).\n" "\n" "* @traffic cannot exceed @circuits\n" "\n" "@EXAMPLES=\n" "PROBBLOCK(24,30) returns 0.4012.\n" "\n" "@SEEALSO=OFFTRAF, DIMCIRC, OFFCAP" msgstr "" #: ../plugins/fn-erlang/functions.c:139 msgid "" "@FUNCTION=OFFTRAF\n" "@SYNTAX=OFFTRAF(traffic,circuits)\n" "@DESCRIPTION=OFFTRAF returns a predicted number of offered traffic from a " "number of carried @traffic (taken from measurements) on a number of " "@circuits.\n" "\n" "* @traffic cannot exceed @circuits\n" "\n" "@EXAMPLES=\n" "OFFTRAF(24,30) returns 25.527.\n" "\n" "@SEEALSO=PROBBLOCK, DIMCIRC, OFFCAP" msgstr "" #: ../plugins/fn-erlang/functions.c:208 msgid "" "@FUNCTION=DIMCIRC\n" "@SYNTAX=DIMCIRC(traffic,gos)\n" "@DESCRIPTION=DIMCIRC returns a number of circuits required from a number of " "@traffic loads with @gos grade of service.\n" "\n" "@EXAMPLES=\n" "DIMCIRC(24,1%) returns 35.\n" "\n" "@SEEALSO=OFFCAP, OFFTRAF, PROBBLOCK" msgstr "" #: ../plugins/fn-erlang/functions.c:253 msgid "" "@FUNCTION=OFFCAP\n" "@SYNTAX=OFFCAP(circuits,gos)\n" "@DESCRIPTION=OFFCAP returns a number of traffic capacity given by a number " "of @circuits with @gos grade of service.\n" "\n" "@EXAMPLES=\n" "OFFCAP(30,1%) returns 20.337.\n" "\n" "@SEEALSO=DIMCIRC, OFFTRAF, PROBBLOCK" msgstr "" #: ../plugins/fn-financial/functions.c:353 msgid "" "@FUNCTION=ACCRINT\n" "@SYNTAX=ACCRINT(issue,first_interest,settlement,rate,par,frequency[,basis])\n" "@DESCRIPTION=ACCRINT calculates the accrued interest for a security that " "pays periodic interest.\n" "\n" "@issue is the issue date of the security. @first_interest is the first " "interest date of the security. @settlement is the settlement date of the " "security. The settlement date is always after the issue date (the date when " "the security is bought). @rate is the annual rate of the security and @par " "is the par value of the security. @frequency is the number of coupon " "payments per year.\n" "\n" "Allowed frequencies are:\n" " 1 = annual,\n" " 2 = semi,\n" " 4 = quarterly.\n" "\n" "@basis is the type of day counting system you want to use:\n" "\n" " 0 US 30/360\n" " 1 actual days/actual days\n" " 2 actual days/360\n" " 3 actual days/365\n" " 4 European 30/360\n" "\n" "* If @issue date, @first_interest date, or @settlement date is not valid, " "ACCRINT returns #NUM! error.\n" "* The dates must be @issue < @first_interest < @settlement, or ACCRINT " "returns #NUM! error.\n" "* If @rate <= 0 or @par <= 0 , ACCRINT returns #NUM! error.\n" "* If @basis is omitted, US 30/360 is applied.\n" "* If @basis < 0 or @basis > 4, ACCRINT returns #NUM! error.\n" "* If @issue date is after @settlement date or they are the same, ACCRINT " "returns #NUM! error.\n" "\n" "@EXAMPLES=\n" "\n" "@SEEALSO=ACCRINTM" msgstr "" #: ../plugins/fn-financial/functions.c:442 msgid "" "@FUNCTION=ACCRINTM\n" "@SYNTAX=ACCRINTM(issue,maturity,rate[,par,basis])\n" "@DESCRIPTION=ACCRINTM calculates and returns the accrued interest for a " "security from @issue to @maturity date.\n" "\n" "@issue is the issue date of the security. @maturity is the maturity date of " "the security. @rate is the annual rate of the security and @par is the par " "value of the security. If you omit @par, ACCRINTM applies $1,000 instead. " "@basis is the type of day counting system you want to use:\n" "\n" " 0 US 30/360\n" " 1 actual days/actual days\n" " 2 actual days/360\n" " 3 actual days/365\n" " 4 European 30/360\n" "\n" "* If @issue date or @maturity date is not valid, ACCRINTM returns #NUM! " "error.\n" "* If @rate <= 0 or @par <= 0, ACCRINTM returns #NUM! error.\n" "* If @basis is omitted, US 30/360 is applied.\n" "* If @basis < 0 or @basis > 4, ACCRINTM returns #NUM! error.\n" "* If @issue date is after @maturity date or they are the same, ACCRINTM " "returns #NUM! error.\n" "\n" "@EXAMPLES=\n" "\n" "@SEEALSO=ACCRINT" msgstr "" #: ../plugins/fn-financial/functions.c:500 msgid "" "@FUNCTION=INTRATE\n" "@SYNTAX=INTRATE(settlement,maturity,investment,redemption[,basis])\n" "@DESCRIPTION=INTRATE calculates and returns the interest rate of a fully " "vested security.\n" "\n" "@settlement is the settlement date of the security. @maturity is the " "maturity date of the security. @investment is the price of the security paid " "at @settlement date and @redemption is the amount to be received at " "@maturity date.\n" "\n" "@basis is the type of day counting system you want to use:\n" "\n" " 0 US 30/360\n" " 1 actual days/actual days\n" " 2 actual days/360\n" " 3 actual days/365\n" " 4 European 30/360\n" "\n" "* If @settlement date or @maturity date is not valid, INTRATE returns #NUM! " "error.\n" "* If @basis is omitted, US 30/360 is applied.\n" "* If @basis < 0 or @basis > 4, INTRATE returns #NUM! error.\n" "* If @settlement date is after @maturity date or they are the same, INTRATE " "returns #NUM! error.\n" "\n" "@EXAMPLES=\n" "\n" "If you had a bond with a settlement date of April 15, 2000, maturity date " "September 30, 2000, investment of $100,000, redemption value $103,525, using " "the actual/actual basis, the bond discount rate is:\n" "=INTRATE(36631, 36799, 100000, 103525, 1) which equals 0.0648 or 6.48%\n" "@SEEALSO=RECEIVED, DATE" msgstr "" #: ../plugins/fn-financial/functions.c:565 msgid "" "@FUNCTION=RECEIVED\n" "@SYNTAX=RECEIVED(settlement,maturity,investment,rate[,basis])\n" "@DESCRIPTION=RECEIVED calculates and returns the amount to be received at " "maturity date for a security bond.\n" "\n" "@settlement is the settlement date of the security. @maturity is the " "maturity date of the security. The amount of investment is specified in " "@investment. @rate is the security's discount rate.\n" "\n" "@basis is the type of day counting system you want to use:\n" "\n" " 0 US 30/360\n" " 1 actual days/actual days\n" " 2 actual days/360\n" " 3 actual days/365\n" " 4 European 30/360\n" "\n" "* If @settlement date or @maturity date is not valid, RECEIVED returns #NUM! " "error.\n" "* If @basis is omitted, US 30/360 is applied.\n" "* If @basis < 0 or @basis > 4, RECEIVED returns #NUM! error.\n" "* If @settlement date is after @maturity date or they are the same, RECEIVED " "returns #NUM! error.\n" "\n" "@EXAMPLES=\n" "\n" "@SEEALSO=INTRATE" msgstr "" #: ../plugins/fn-financial/functions.c:627 msgid "" "@FUNCTION=PRICEDISC\n" "@SYNTAX=PRICEDISC(settlement,maturity,discount,redemption[,basis])\n" "@DESCRIPTION=PRICEDISC calculates and returns the price per $100 face value " "of a security bond. The security does not pay interest at maturity.\n" "\n" "@settlement is the settlement date of the security. @maturity is the " "maturity date of the security. @discount is the rate for which the security " "is discounted. @redemption is the amount to be received on @maturity date.\n" "\n" "@basis is the type of day counting system you want to use:\n" "\n" " 0 US 30/360\n" " 1 actual days/actual days\n" " 2 actual days/360\n" " 3 actual days/365\n" " 4 European 30/360\n" "\n" "* If @settlement date or @maturity date is not valid, PRICEDISC returns " "#NUM! error.\n" "* If @basis is omitted, US 30/360 is applied.\n" "* If @basis < 0 or @basis > 4, PRICEDISC returns #NUM! error.\n" "* If @settlement date is after @maturity date or they are the same, " "PRICEDISC returns #NUM! error.\n" "\n" "@EXAMPLES=\n" "\n" "@SEEALSO=PRICEMAT" msgstr "" #: ../plugins/fn-financial/functions.c:684 msgid "" "@FUNCTION=PRICEMAT\n" "@SYNTAX=PRICEMAT(settlement,maturity,issue,rate,yield[,basis])\n" "@DESCRIPTION=PRICEMAT calculates and returns the price per $100 face value " "of a security. The security pays interest at maturity.\n" "\n" "@settlement is the settlement date of the security. @maturity is the " "maturity date of the security. @issue is the issue date of the security. " "@rate is the discount rate of the security. @yield is the annual yield of " "the security. @basis is the type of day counting system you want to use:\n" "\n" " 0 US 30/360\n" " 1 actual days/actual days\n" " 2 actual days/360\n" " 3 actual days/365\n" " 4 European 30/360\n" "\n" "* If @settlement date or @maturity date is not valid, PRICEMAT returns #NUM! " "error.\n" "* If @basis is omitted, US 30/360 is applied.\n" "* If @basis < 0 or @basis > 4, PRICEMAT returns #NUM! error.\n" "* If @settlement date is after @maturity date or they are the same, PRICEMAT " "returns #NUM! error.\n" "\n" "@EXAMPLES=\n" "\n" "@SEEALSO=PRICEDISC" msgstr "" #: ../plugins/fn-financial/functions.c:748 msgid "" "@FUNCTION=DISC\n" "@SYNTAX=DISC(settlement,maturity,par,redemption[,basis])\n" "@DESCRIPTION=DISC calculates and returns the discount rate for a security. " "@settlement is the settlement date of the security.\n" "\n" "@maturity is the maturity date of the security. @par is the price per $100 " "face value of the security. @redemption is the redemption value per $100 " "face value of the security.\n" "\n" "@basis is the type of day counting system you want to use:\n" "\n" " 0 US 30/360\n" " 1 actual days/actual days\n" " 2 actual days/360\n" " 3 actual days/365\n" " 4 European 30/360\n" "\n" "* If @settlement date or @maturity date is not valid, DISC returns #NUM! " "error.\n" "* If @basis is omitted, US 30/360 is applied.\n" "* If @basis < 0 or @basis > 4, DISC returns #NUM! error.\n" "* If @settlement date is after @maturity date or they are the same, DISC " "returns #NUM! error.\n" "\n" "@EXAMPLES=\n" "\n" "@SEEALSO=" msgstr "" #: ../plugins/fn-financial/functions.c:804 msgid "" "@FUNCTION=EFFECT\n" "@SYNTAX=EFFECT(r,nper)\n" "@DESCRIPTION=EFFECT calculates the effective interest rate from a given " "nominal rate.\n" "\n" "Effective interest rate is calculated using this formula:\n" "\n" " (1 + @r / @nper) ^ @nper - 1\n" "\n" "where:\n" "\n" "@r = nominal interest rate (stated in yearly terms)\n" "@nper = number of periods used for compounding\n" "\n" "* If @rate < 0, EFFECT returns #NUM! error.\n" "* If @nper <= 0, EFFECT returns #NUM! error.\n" "\n" "@EXAMPLES=\n" "For example credit cards will list an APR (annual percentage rate) which is " "a nominal interest rate.\n" "For example if you wanted to find out how much you are actually paying " "interest on your credit card that states an APR of 19% that is compounded " "monthly you would type in:\n" "=EFFECT(.19,12) and you would get .2075 or 20.75%. That is the effective " "percentage you will pay on your loan.\n" "@SEEALSO=NOMINAL" msgstr "" #: ../plugins/fn-financial/functions.c:854 msgid "" "@FUNCTION=NOMINAL\n" "@SYNTAX=NOMINAL(r,nper)\n" "@DESCRIPTION=NOMINAL calculates the nominal interest rate from a given " "effective rate.\n" "\n" "Nominal interest rate is given by a formula:\n" "\n" "@nper * (( 1 + @r ) ^ (1 / @nper) - 1 )\n" "where:\n" "\n" "@r = effective interest rate\n" "@nper = number of periods used for compounding\n" "\n" "* If @rate < 0, NOMINAL returns #NUM! error.\n" "* If @nper <= 0, NOMINAL returns #NUM! error.\n" "\n" "@EXAMPLES=\n" "\n" "@SEEALSO=EFFECT" msgstr "" #: ../plugins/fn-financial/functions.c:895 msgid "" "@FUNCTION=ISPMT\n" "@SYNTAX=ISPMT(rate,per,nper,pv)\n" "@DESCRIPTION=ISPMT function returns the interest paid on a given period.\n" "\n" "* If @per < 1 or @per > @nper, ISPMT returns #NUM! error. \n" "@EXAMPLES=\n" "\n" "@SEEALSO=PV" msgstr "" #: ../plugins/fn-financial/functions.c:935 msgid "" "@FUNCTION=DB\n" "@SYNTAX=DB(cost,salvage,life,period[,month])\n" "@DESCRIPTION=DB calculates the depreciation of an asset for a given period " "using the fixed-declining balance method. @cost is the initial value of the " "asset. @salvage is the value after the depreciation.\n" "\n" "@life is the number of periods overall. @period is the period for which you " "want the depreciation to be calculated. @month is the number of months in " "the first year of depreciation.\n" "\n" "* If @month is omitted, it is assumed to be 12.\n" "* If @cost = 0, DB returns #NUM! error.\n" "* If @life <= 0, DB returns #NUM! error.\n" "* If @salvage / @cost < 0, DB returns #NUM! error.\n" "\n" "@EXAMPLES=\n" "\n" "@SEEALSO=DDB,SLN,SYD" msgstr "" #: ../plugins/fn-financial/functions.c:999 msgid "" "@FUNCTION=DDB\n" "@SYNTAX=DDB(cost,salvage,life,period[,factor])\n" "@DESCRIPTION=DDB returns the depreciation of an asset for a given period " "using the double-declining balance method or some other similar method you " "specify.\n" "\n" "@cost is the initial value of the asset, @salvage is the value after the " "last period, @life is the number of periods, @period is the period for which " "you want the depreciation to be calculated, and @factor is the factor at " "which the balance declines.\n" "\n" "* If @factor is omitted, it is assumed to be two (double-declining balance " "method).\n" "* If @life <= 0, DDB returns #NUM! error.\n" "\n" "@EXAMPLES=\n" "\n" "@SEEALSO=SLN,SYD" msgstr "" #: ../plugins/fn-financial/functions.c:1062 msgid "" "@FUNCTION=SLN\n" "@SYNTAX=SLN(cost,salvage_value,life)\n" "@DESCRIPTION=SLN function will determine the straight line depreciation of " "an asset for a single period.\n" "\n" "The formula is:\n" "\n" "Depreciation expense = ( @cost - @salvage_value ) / @life\n" "\n" "@cost is the cost of an asset when acquired (market value).\n" "@salvage_value is the amount you get when asset is sold at the end of the " "asset's useful life.\n" "@life is the anticipated life of an asset.\n" "\n" "* If @life <= 0, SLN returns #NUM! error.\n" "\n" "@EXAMPLES=\n" "For example, lets suppose your company purchases a new machine for $10,000, " "which has a salvage value of $700 and will have a useful life of 10 years. " "The SLN yearly depreciation is computed as follows:\n" "=SLN(10000, 700, 10)\n" "This will return the yearly depreciation figure of $930.\n" "@SEEALSO=SYD" msgstr "" #: ../plugins/fn-financial/functions.c:1115 msgid "" "@FUNCTION=SYD\n" "@SYNTAX=SYD(cost,salvage_value,life,period)\n" "@DESCRIPTION=SYD function calculates the sum-of-years digits depreciation " "for an asset based on its cost, salvage value, anticipated life and a " "particular period. This method accelerates the rate of the depreciation, so " "that more depreciation expense occurs in earlier periods than in later ones. " "The depreciable cost is the actual cost minus the salvage value. The useful " "life is the number of periods (typically years) over which the asset is " "depreciated.\n" "\n" "The Formula used for sum-of-years digits depreciation is:\n" "\n" "Depreciation expense =\n" "\n" "\t ( @cost - @salvage_value ) * (@life - @period + 1) * 2 / @life * (@life + " "1).\n" "\n" "@cost is the cost of an asset when acquired (market value).\n" "@salvage_value is the amount you get when asset sold at the end of its " "useful life.\n" "@life is the anticipated life of an asset.\n" "@period is the period for which we need the expense.\n" "\n" "* If @life <= 0, SYD returns #NUM! error.\n" "\n" "@EXAMPLES=\n" "For example say a company purchases a new computer for $5000 which has a " "salvage value of $200, and a useful life of five years. We would use the " "following to calculate the second year's depreciation using the SYD method:\n" "=SYD(5000, 200, 5, 2) which returns 1,280.00.\n" "@SEEALSO=SLN" msgstr "" #: ../plugins/fn-financial/functions.c:1176 msgid "" "@FUNCTION=DOLLARDE\n" "@SYNTAX=DOLLARDE(fractional_dollar,fraction)\n" "@DESCRIPTION=DOLLARDE converts a dollar price expressed as a fraction into a " "dollar price expressed as a decimal number.\n" "\n" "@fractional_dollar is the fractional number to be converted. @fraction is " "the denominator of the fraction.\n" "\n" "* If @fraction is non-integer it is truncated.\n" "* If @fraction <= 0, DOLLARDE returns #NUM! error.\n" "\n" "@EXAMPLES=\n" "\n" "@SEEALSO=DOLLARFR" msgstr "" #: ../plugins/fn-financial/functions.c:1235 msgid "" "@FUNCTION=DOLLARFR\n" "@SYNTAX=DOLLARFR(decimal_dollar,fraction)\n" "@DESCRIPTION=DOLLARFR converts a decimal dollar price into a dollar price " "expressed as a fraction.\n" "\n" "* If @fraction is non-integer it is truncated.\n" "* If @fraction <= 0, DOLLARFR returns #NUM! error.\n" "\n" "@EXAMPLES=\n" "\n" "@SEEALSO=DOLLARDE" msgstr "" #: ../plugins/fn-financial/functions.c:1289 msgid "" "@FUNCTION=MIRR\n" "@SYNTAX=MIRR(values,finance_rate,reinvest_rate)\n" "@DESCRIPTION=MIRR function returns the modified internal rate of return for " "a given periodic cash flow. \n" "@EXAMPLES=\n" "\n" "@SEEALSO=NPV" msgstr "" #: ../plugins/fn-financial/functions.c:1352 msgid "" "@FUNCTION=TBILLEQ\n" "@SYNTAX=TBILLEQ(settlement,maturity,discount)\n" "@DESCRIPTION=TBILLEQ function returns the bond-yield equivalent (BEY) for a " "treasury bill. TBILLEQ is equivalent to\n" "\n" "\t(365 * @discount) / (360 - @discount * DSM),\n" "\n" "where DSM is the days between @settlement and @maturity.\n" "\n" "* If @settlement is after @maturity or the @maturity is set to over one year " "later than the @settlement, TBILLEQ returns #NUM! error.\n" "* If @discount is negative, TBILLEQ returns #NUM! error.\n" "\n" "@EXAMPLES=\n" "\n" "@SEEALSO=TBILLPRICE,TBILLYIELD" msgstr "" #: ../plugins/fn-financial/functions.c:1403 msgid "" "@FUNCTION=TBILLPRICE\n" "@SYNTAX=TBILLPRICE(settlement,maturity,discount)\n" "@DESCRIPTION=TBILLPRICE function returns the price per $100 value for a " "treasury bill where @settlement is the settlement date and @maturity is the " "maturity date of the bill. @discount is the treasury bill's discount rate.\n" "\n" "* If @settlement is after @maturity or the @maturity is set to over one year " "later than the @settlement, TBILLPRICE returns #NUM! error.\n" "* If @discount is negative, TBILLPRICE returns #NUM! error.\n" "\n" "@EXAMPLES=\n" "\n" "@SEEALSO=TBILLEQ,TBILLYIELD" msgstr "" #: ../plugins/fn-financial/functions.c:1449 msgid "" "@FUNCTION=TBILLYIELD\n" "@SYNTAX=TBILLYIELD(settlement,maturity,pr)\n" "@DESCRIPTION=TBILLYIELD function returns the yield for a treasury bill. " "@settlement is the settlement date and @maturity is the maturity date of the " "bill. @discount is the treasury bill's discount rate.\n" "\n" "* If @settlement is after @maturity or the @maturity is set to over one year " "later than the @settlement, TBILLYIELD returns #NUM! error.\n" "* If @pr is negative, TBILLYIELD returns #NUM! error.\n" "\n" "@EXAMPLES=\n" "\n" "@SEEALSO=TBILLEQ,TBILLPRICE" msgstr "" #: ../plugins/fn-financial/functions.c:1495 msgid "" "@FUNCTION=RATE\n" "@SYNTAX=RATE(nper,pmt,pv[,fv,type,guess])\n" "@DESCRIPTION=RATE calculates the rate of an investment.\n" "\n" "* If @pmt is ommitted it defaults to 0\n" "* If @nper <= 0, RATE returns #NUM! error.\n" "* If @type != 0 and @type != 1, RATE returns #VALUE! error.\n" "\n" "@EXAMPLES=\n" "\n" "@SEEALSO=PV,FV" msgstr "" #: ../plugins/fn-financial/functions.c:1611 msgid "" "@FUNCTION=IRR\n" "@SYNTAX=IRR(values[,guess])\n" "@DESCRIPTION=IRR calculates and returns the internal rate of return of an " "investment. This function is closely related to the net present value " "function (NPV). The IRR is the interest rate for a series of cash flows " "where the net preset value is zero.\n" "\n" "@values contains the series of cash flows generated by the investment. The " "payments should occur at regular intervals. The optional @guess is the " "initial value used in calculating the IRR. You do not have to use that, it " "is only provided for the Excel compatibility.\n" "\n" "* This function is Excel compatible.\n" "\n" "@EXAMPLES=\n" "Let us assume that the cells A1:A8 contain the numbers -32432, 5324, 7432, " "9332, 12324, 4334, 1235, -3422. Then\n" "IRR(A1:A8) returns 0.04375. \n" "@SEEALSO=FV,NPV,PV" msgstr "" #: ../plugins/fn-financial/functions.c:1745 msgid "" "@FUNCTION=PV\n" "@SYNTAX=PV(rate,nper,pmt[,fv,type])\n" "@DESCRIPTION=PV calculates the present value of an investment. @rate is the " "periodic interest rate, @nper is the number of periods used for compounding. " "@pmt is the payment made each period, @fv is the future value and @type is " "when the payment is made.\n" "\n" "* If @type = 1 then the payment is made at the beginning of the period.\n" "* If @type = 0 (or omitted) it is made at the end of each period.\n" "@EXAMPLES=\n" "\n" "@SEEALSO=FV" msgstr "" #: ../plugins/fn-financial/functions.c:1793 msgid "" "@FUNCTION=NPV\n" "@SYNTAX=NPV(rate,v1,v2,...)\n" "@DESCRIPTION=NPV calculates the net present value of an investment " "generating periodic payments. @rate is the periodic interest rate and @v1, " "@v2, ... are the periodic payments. If the schedule of the cash flows are " "not periodic use the XNPV function. \n" "@EXAMPLES=\n" "NPV(0.17,-10000,3340,2941,2493,3233,1732,2932) equals 186.30673.\n" "\n" "@SEEALSO=PV,XNPV" msgstr "" #: ../plugins/fn-financial/functions.c:1844 msgid "" "@FUNCTION=XNPV\n" "@SYNTAX=XNPV(rate,values,dates)\n" "@DESCRIPTION=XNPV calculates the net present value of an investment. The " "schedule of the cash flows is given in @dates array. The first date " "indicates the beginning of the payment schedule. @rate is the interest rate " "and @values are the payments.\n" "\n" "* If @values and @dates contain unequal number of values, XNPV returns the " "#NUM! error.\n" "\n" "@EXAMPLES=\n" "\n" "@SEEALSO=NPV,PV" msgstr "" #: ../plugins/fn-financial/functions.c:1906 msgid "" "@FUNCTION=XIRR\n" "@SYNTAX=XIRR(values,dates[,guess])\n" "@DESCRIPTION=XIRR calculates and returns the internal rate of return of an " "investment that has not necessarily periodic payments. This function is " "closely related to the net present value function (NPV and XNPV). The XIRR " "is the interest rate for a series of cash flows where the XNPV is zero.\n" "\n" "@values contains the series of cash flows generated by the investment. " "@dates contains the dates of the payments. The first date describes the " "payment day of the initial payment and thus all the other dates should be " "after this date. The optional @guess is the initial value used in " "calculating the XIRR. You do not have to use that, it is only provided for " "the Excel compatibility.\n" "\n" "* This function is Excel compatible.\n" "\n" "@EXAMPLES=\n" "Let us assume that the cells A1:A5 contain the numbers -6000, 2134, 1422, " "1933, and 1422, and the cells B1:B5 contain the dates \"1999-01-15\", \"1999-" "04-04\", \"1999-05-09\", \"2000-03-12\", and \"2000-05-1\". Then\n" "XIRR(A1:A5,B1:B5) returns 0.224838. \n" "@SEEALSO=IRR,XNPV" msgstr "" #: ../plugins/fn-financial/functions.c:2026 msgid "" "@FUNCTION=FV\n" "@SYNTAX=FV(rate,nper,pmt[,pv,type])\n" "@DESCRIPTION=FV computes the future value of an investment. This is based on " "periodic, constant payments and a constant interest rate. The interest rate " "per period is @rate, @nper is the number of periods in an annuity, @pmt is " "the payment made each period, @pv is the present value and @type is when the " "payment is made.\n" "\n" "* If @type = 1 then the payment is made at the beginning of the period.\n" "* If @type = 0 it is made at the end of each period.\n" "\n" "@EXAMPLES=\n" "\n" "@SEEALSO=PV,PMT,PPMT" msgstr "" #: ../plugins/fn-financial/functions.c:2070 msgid "" "@FUNCTION=PMT\n" "@SYNTAX=PMT(rate,nper,pv[,fv,type])\n" "@DESCRIPTION=PMT returns the amount of payment for a loan based on a " "constant interest rate and constant payments (each payment is equal " "amount).\n" "\n" "@rate is the constant interest rate.\n" "@nper is the overall number of payments.\n" "@pv is the present value.\n" "@fv is the future value.\n" "@type is the type of the payment: 0 means at the end of the period and 1 " "means at the beginning of the period.\n" "\n" "* If @fv is omitted, Gnumeric assumes it to be zero.\n" "* If @type is omitted, Gnumeric assumes it to be zero.\n" "\n" "@EXAMPLES=\n" "\n" "@SEEALSO=PPMT,PV,FV" msgstr "" #: ../plugins/fn-financial/functions.c:2113 msgid "" "@FUNCTION=IPMT\n" "@SYNTAX=IPMT(rate,per,nper,pv[,fv,type])\n" "@DESCRIPTION=IPMT calculates the amount of a payment of an annuity going " "towards interest.\n" "\n" "Formula for IPMT is:\n" "\n" "IPMT(PER) = -PRINCIPAL(PER-1) * INTEREST_RATE\n" "\n" "where:\n" "\n" "PRINCIPAL(PER-1) = amount of the remaining principal from last period\n" "\n" "* If @fv is omitted, it is assumed to be 0.\n" "* If @type is omitted, it is assumed to be 0.\n" "\n" "@EXAMPLES=\n" "\n" "@SEEALSO=PPMT,PV,FV" msgstr "" #: ../plugins/fn-financial/functions.c:2165 msgid "" "@FUNCTION=PPMT\n" "@SYNTAX=PPMT(rate,per,nper,pv[,fv,type])\n" "@DESCRIPTION=PPMT calculates the amount of a payment of an annuity going " "towards principal.\n" "\n" "Formula for it is:\n" "PPMT(per) = PMT - IPMT(per)\n" "where:\n" "\n" "PMT = Payment received on annuity\n" "IPMT(per) = amount of interest for period @per\n" "\n" "* If @fv is omitted, it is assumed to be 0.\n" "* If @type is omitted, it is assumed to be 0.\n" "\n" "@EXAMPLES=\n" "\n" "@SEEALSO=IPMT,PV,FV" msgstr "" #: ../plugins/fn-financial/functions.c:2221 msgid "" "@FUNCTION=NPER\n" "@SYNTAX=NPER(rate,pmt,pv[,fv,type])\n" "@DESCRIPTION=NPER calculates number of periods of an investment based on " "periodic constant payments and a constant interest rate.\n" "\n" "The interest rate per period is @rate, @pmt is the payment made each period, " "@pv is the present value, @fv is the future value and @type is when the " "payments are due. If @type = 1, payments are due at the beginning of the " "period, if @type = 0, payments are due at the end of the period.\n" "\n" "* If @rate <= 0, NPER returns #DIV0 error.\n" "\n" "@EXAMPLES=\n" "For example, if you deposit $10,000 in a savings account that earns an " "interest rate of 6%. To calculate how many years it will take to double your " "investment use NPER as follows:\n" "=NPER(0.06, 0, -10000, 20000,0)returns 11.895661046 which indicates that you " "can double your money just before the end of the 12th year.\n" "@SEEALSO=PPMT,PV,FV" msgstr "" #: ../plugins/fn-financial/functions.c:2281 msgid "" "@FUNCTION=DURATION\n" "@SYNTAX=DURATION(settlement,maturity,coup,yield,frequency[,basis])\n" "@DESCRIPTION=DURATION calculates the duration of a security.\n" "\n" "@settlement is the settlement date of the security.\n" "@maturity is the maturity date of the security.\n" "@coup The annual coupon rate as a percentage.\n" "@yield The annualized yield of the security as a percentage.\n" "@frequency is the number of coupon payments per year. Allowed frequencies " "are: 1 = annual, 2 = semi, 4 = quarterly. @basis is the type of day counting " "system you want to use:\n" "\n" " 0 US 30/360\n" " 1 actual days/actual days\n" " 2 actual days/360\n" " 3 actual days/365\n" " 4 European 30/360\n" "\n" "* If @frequency is other than 1, 2, or 4, DURATION returns #NUM! error.\n" "* If @basis is omitted, US 30/360 is applied.\n" "* If @basis is not in between 0 and 4, #NUM! error is returned.\n" "\n" "@EXAMPLES=\n" "\n" "@SEEALSO=G_DURATION,MDURATION" msgstr "" #: ../plugins/fn-financial/functions.c:2343 msgid "" "@FUNCTION=G_DURATION\n" "@SYNTAX=G_DURATION(rate,pv,fv)\n" "@DESCRIPTION=G_DURATION calculates number of periods needed for an " "invest