|
|
|
|
|
|
|
ReliaSoft > Software > RENO > Definitions
|
|||
These pre-defined functions and reserved keywords can be typed into equations and are also accessible via the Function Wizard. RENO Intrinsic Functions GROUP: ENGINEERING
"BESSELI" Description: "Returns the modified Bessel function In(x)" Input: "(Number, Order)" Type: Engineering Example: BESSELI(1.5,1)=0.981666
"BESSELJ" Description: "Returns the Bessel function Jn(x)" Input: "(Number, Order)" Type: Engineering Example: BESSELJ(1.9,2)=0.329926
"BESSELK" Description: "Returns the modified Bessel function Kn(x)" Input: "(Number, Order)" Type: Engineering Example: BESSELK(1.5,1)=0.277388
"BESSELY" Description: "Returns the Bessel function Yn(x)" Input: "(Number, Order)" Type: Engineering Example: BESSELY(2.5,1)=0.145918
"DELTA" Description: "Tests whether two values are equal" Input: "(Number1, Number2)" Type: Engineering Example: DELTA(3,3)=1
"ERF" Description: "Returns the error function" Input: "(Lower_Limit, Upper_Limit)" Type: Engineering Example: ERF(0.1,1.2)=0.797851
"ERFC" Description: "Returns the complementary error function" Input: "(Number)" Type: Engineering Example: ERFC(1)=0.157299
GROUP: FINANCIAL
"CUMIPMT" Description: "Returns the cumulative interest paid between two periods" Input: "(Rate, NPer, PV, Start_Period, End_Period, Type)" Type: Financial Example: CUMIPMT(9%/12,30*12, 125000,13,24,0)=-11135.2
"CUMPRINC" Description: "Returns the cumulative principal paid on a loan between two periods" Input: "(Rate, NPer, Pv, Start_Period, End_Period, Type)" Type: Financial Example: CUMPRINC(9%/12,30*12,125000,13,24,0)=-934.107
"FV" Description: "Returns the future value of an investment" Input: "(Rate, NPer, Pmt, Type)" Type: Financial Example: FV(11%/12,35,-200,1) = 8284.62
"FVi" Description: "Returns the future value of an investment made at a given period" Input: "(Rate, CurPeriod, EndPeriod, Pmt, Type)" Type: Financial Example: FVI(3,12,15,0.2,3)= -51.2
"IPMT" Description: "Returns the interest payment for an investment for a given period" Input: "(Rate, Periods, N_Peridods, Pv, Fv, Type)" Type: Financial Example: IPMT(10%/12,1*3,3,8000,0,0)=-22.407
"PMT" Description: "Returns the periodic payment for an annuity" Input: "(Rate, N_Periods, Pv, Fv, Type)" Type: Financial Example: PMT(12%,3,3,-1000,0)=295.10
"PPMT" Description: "Returns the payment on the principal for an investment for a given period" Input: "(Rate, Periods, N_Periods, Pv, Fv, Type)" Type: Financial Example: : PPMT(12%,3,3,-1000,0,2)=331.91
"PV" Description: "Returns the present value of an investment" Input: "(Rate, N_Periods, PMT, Type)" Type: Financial Example: PV(12%,3,3,,0)= -7.21
"PVi" Description: "Returns the present value of an investment made at a given period" Input: "(Rate, CurPeriod, PMT, Type)" Type: Financial Example: PVI(12%,12,-100,1)= 28.7476
GROUP: MATH & TRIG
"ABS" Description: "Returns the absolute value of a number" Input: "(Number)" Type: Math & Trig Example: ABS(-2)=2
"ACOS" Description: "Returns the arccosine of a number" Input: "(Number)" Type: Math & Trig Example: ARCCOS(-0.5)=2.094395
"ACOSH" Description: "Returns the inverse hyperbolic cosine of a number" Input: "(Number)" Type: Math & Trig Example: ACOSH(10)=2.993223
"ASIN" Description: "Returns the arcsine of a number" Input: "(Number)" Type: Math & Trig Example: ASIN (-0.5)=-0.523599
"ASINH" Description: "Returns the inverse hyperbolic sine of a number" Input: "(Number)" Type: Math & Trig Example: ASINH(-2.5)=-1.64723
"ATAN" Description: "Returns the arctangent of a number" Input: "(Number)" Type: Math & Trig Example: ATAN(1)=0.785398
"ATAN2" Description: "Returns the arctangent from x- and y-coordinates" Input: "(x_Number, y_Number)" Type: Math & Trig Example: ATAN2(1,2)=1.107148
"ATANH" Description: "Returns the inverse hyperbolic tangent of a number" Input: "(Number)" Type: Math & Trig Example: ATANH(-0.1)=-0.100335
BISECTION Description: "Returns a root of a function of X, from XMIN to XMAX" Input: “(F(X), XMin, XMax, Accuracy, Iterations)” Type: Math & Trig Example: BISECTION(X^2 - 4,0,10,0.00001,100)=1.999998 Note that BISECTION(X^2 - 4,0,10,0.00001,10) results in an error since not enough iterations are used for the given accuracy of 0.00001.
"CEILING" Description: "Rounds a number to the nearest integer or to the nearest multiple of significance" Input: "(Number, Significance)" Type: Math & Trig Example: CEILING(-2.5, -2)=-4
"COMBIN" Description: "Returns the number of combinations for a given number of objects" Input: "(Number, Number_Chosen)" Type: Math & Trig Example: COMBIN(8,3)=56
"COS" Description: "Returns the cosine of a number" Input: "(Number)" Type: Math & Trig Example: COS(0.258)=0.966902
"COSH" Description: "Returns the hyperbolic cosine of a number" Input: "(Number)" Type: Math & Trig Example: COSH(0.258)=1.033467
"DEGREES" Description: "Converts radians to degrees" Input: "(Angle)" Type: Math & Trig Example: DEGREES(PI())=180
"DERIVATIVE" Description: "Returns the derivative of a function of X at Number" Input: "(F(X), Number)" Type: Math & Trig Example: DERIVATIVE(X^2-2,10)=20
"EVEN" Description: "Rounds a number up to the nearest even integer" Input: "(Number)" Type: Math & Trig Example: EVEN(3)=4
"EXP" Description: "Returns e raised to the power of a given number" Input: "(Number)" Type: Math & Trig Example: EXP(1)=2.718282
"FACT" Description: "Returns the factorial of a number" Input: "(Number)" Type: Math & Trig Example: FACT(5)=120
"FACTDOUBLE" Description: "Returns the double factorial of a number" Input: "(Number)" Type: Math & Trig Example: FACTDOUBLE(6)=48
"FLOOR" Description: "Rounds a number down, toward zero" Input: "(Number, Significance)" Type: Math & Trig Example: FLOOR(2.5, 1)=2
"INT" Description: "Rounds a number down to the nearest integer" Input: "(Number)" Type: Math & Trig Example: INT(8.9)=8
"INTEGRAL" Description: "Integrates a function of X from Start to End" Input: "(F(X), Start, End, Intervals)" Type: Math & Trig Example: INTEGRAL(X^2-2,3,6,10)=57
"LN" Description: "Returns the natural logarithm of a number" Input: "(Number)" Type: Math & Trig Example: LN(5)=1.609438
"LOG" Description: "Returns the logarithm of a number to a specified base" Input: "(Number, Base)" Type: Math & Trig Example: LOG(5,2)=2.321928
"LOG10" Description: "Returns the base-10 logarithm of a number" Input: "(Number)" Type: Math & Trig Example: LOG10(5)=0.69897
"MOD" Description: "Returns the remainder from division" Input: "(Number, Divisor)" Type: Math & Trig Example: MOD(3,2)=1
"MROUND" Description: "Returns a number rounded to the desired multiple" Input: "(Number, Num_Digits)" Type: Math & Trig Example: MROUND(8.02365985,5)=10
"ODD" Description: "Rounds a number up to the nearest odd integer" Input: "(Number)" Type: Math & Trig Example: ODD(10)=11
"PI" Description: "Returns the value of pi" Input: "" Type: Math & Trig Example: PI()=3.141593
"QUOTIENT" Description: "Returns the integer portion of a division" Input: "(Numerator, Denominator)" Type: Math & Trig Example: QUOTIENT(123,2)=61
"RADIANS" Description: "Converts degrees to radians" Input: "(Angle)" Type: Math & Trig Example: RADIANS(78)=1.361357
"RAND" Description: “Returns an evenly distributed random number greater than or equal to 0 and less than 1." Input: “” Type: Math & Trig Example: RAND()=0.516710
"ROUND" Description: "Rounds a number to a specified number of digits" Input: "(Number, Num_Digits)" Type: Math & Trig Example: ROUND(0.25227489,4)=0.2523
"ROUNDDOWN" Description: "Rounds a number down, toward zero" Input: "(Number, Num_Digits)" Type: Math & Trig Example: ROUNDDOWN(0.25227489,4)=0.2522
"ROUNDUP" Description: "Rounds a number up, away from zero" Input: "(Number, Num_Digits)" Type: Math & Trig Example: ROUNDUP(0.25227489,4)=0.2523
"SIN" Description: "Returns the sine of the given angle" Input: "(Number)" Type: Math & Trig Example: SIN(2)=0.909297
"SINH" Description: "Returns the hyperbolic sine of a number" Input: "(Number)" Type: Math & Trig Example: SINH(2)=3.62686
"SQRT" Description: "Returns a positive square root" Input: "(Number)" Type: Math & Trig Example: SQRT(256)=16
"TAN" Description: "Returns the tangent of a number" Input: "(Number)" Type: Math & Trig Example: TAN(0.25)=0.255342
"TANH" Description: "Returns the hyperbolic tangent of a number" Input: "(Number)" Type: Math & Trig Example: TANH(0.25)=0.244919
"TRUNC" Description: "Truncates a number to an integer" Input: "(Number)" Type: Math & Trig Example: TRUNC(543.8952)=543
GROUP: STATISTICAL
"BETADIST” Description: "Returns the cumulative beta probability density function" Input: "(Number, Alpha, Beta)" Type: Statistical Example: BETADIST(0.01,0.23,7)=0.581537
"BETAINV” Description: "Returns the inverse of the cumulative beta probability density function" Input: "(Probability, Alpha, Beta)" Type: Statistical Example: BETAINV(0.3,0.23,7)=0.000537
"BINOMDIST” Description: "Returns the individual term binomial distribution probability" Input: "(Number_S, Trials, Probability_S, Cumulative)" Type: Statistical Example: BINOM_DIST(6,10,0.5,FALSE)=0.205078
"CHIDIST” Description: "Returns the one-tailed probability of the chi-squared distribution" Input: "(Number, Degrees_Freedom)" Type: Statistical Example: CHIDIST(3,4)=0.557825
"CHIINV” Description: "Returns the inverse of the one-tailed probability of the chi-squared distribution" Input: "(Probability, Degrees_Freedom)" Type: Statistical Example: CHIINV(0.3,23)=26.01837
"CONFIDENCE" Description: "Returns the confidence interval for a population mean" Input: "(alpha,standard_dev,size)" Type: Statistical Example: CONFIDENCE(0.02,2.5,50)=0.822488
"CRITBINOM" Description: "Returns the smallest value for which the cumulative binomial dist. is less than or equal to a criterion value" Input: "(Trials, Probability_s, Alpha)" Type: Statistical Example: CRITBINOM(6,0.5,0.75)=4
"EXPONDIST” Description: "Returns the exponential distribution" Input: "(Number, Lambda, Gamma, Cumulative)" Type: Statistical Example: EXPONDIST(0.2,10,0,TRUE) =0.864665
"EXPONFR” Description: “Returns the Exponential failure rate at a given time” Input: “(Time, Lambda, Gamma)” Type: Statistical Example: EXPONFR(1,2,3)=2
"EXPONINV” Description: "Returns the inverse of the cumulative exponential distribution" Input: "(Probability, Lambda, Gamma)" Type: Statistical Example: EXPONINV(1,2,3)= 116.9779621
“EXPONMEAN” Description: “Returns the mean of an Exponential distribution” Input: Lambda, Gamma Type: Statistical Example: EXPONMEAN(1,2)=3
EXPONREL Returns the Exponential reliability at a given time Input: Time, Lambda, Gamma Type: Statistical Example: EXPONREL(0.2,10,0,TRUE) = 0.135335
"FDIST” Description: "Returns the F probability distribution" Input: "(Number, Deg_Freedom1, Deg_Freedom2)" Type: Statistical Example: FDIST(15.2,6,4)=0.010008
"FINV” Description: "Returns the inverse of the F probability distribution" Input: "(Probability, Deg_Freedom1, Deg_Freedom2)" Type: Statistical Example: FINV(0.01,6,4)=15.20686
"FISHER" Description: "Returns the Fisher transformation" Input: "(Number)" Type: Statistical Example: FISHER(0.5)=0.549306
"FISHERINV" Description: "Returns the inverse of the Fisher transformation" Input: "(Number)" Type: Statistical Example: FISHERINV(0.54)=0.492988
"GAMMADIST” Description: "Returns the gamma distribution" Input: "(Number, Alpha, Beta, Cumulative)" Type: Statistical Example: GAMMADIST(10,9,2,FALSE)=0.032639
"GAMMAINV” Description: "Returns the inverse of the gamma cumulative distribution" Input: "(Probability, Alpha, Beta) " Type: Statistical Example: GAMMAINV(0.07,9,2)=10.057904
"GAMMALN" Description: "Returns the natural logarithm of the gamma function, ?(x)" Input: "(Number)" Type: Statistical Example: GAMMALN(4)=1.791759
"HYPGEOMDIST” Description: "Returns the hypergeometric distribution" Input: "(Sample_S, N_Sample, Population_S, N_Population)" Type: Statistical Example: HYPGEOMDIST(1,4,8,20)=0.363261
"LOGNORMDIST” Description: "Returns the cumulative lognormal distribution" Input: "(Number, Mean, Standard_Dev, Cumulative)" Type: Statistical Example: LOGNORMDIST(4,3.5,1.2,TRUE)=0.039084
“LOGNORMFR” Description: "Returns the Lognormal failure rate at a given time” Input: "(Time, Mean, Standard_Dev) Type: Statistical Example: LOGNORMFR(1,2,3)= 0.142450
"LOGNORMINV” Description: "Returns the inverse of the lognormal cumulative distribution" Input: "(Probability, Mean, Standard_Dev)" Type: Statistical Example: LOGNORMINV(0.039,3.5,1.2)=3.995256
"LOGNORMMEAN” Description: "Returns the mean of an Lognormal distribution" Input: "(Mean, Standard_Dev)" Type: Statistical Example: LOGNORMMEAN(1,2)=20.085537
"LOGNORMREL” Description: "Returns the Lognormal reliability at a given time" Input: "(Time, Mean, Standard_Dev)" Type: Statistical Example: LOGNORMREL(4,3.5,1.2,TRUE)=0.960916
"NEGBINOMDIST” Description: "Returns the negative binomial distribution" Input: "(Number_F, Number_S, Probability_S)" Type: Statistical Example: NEGBINOMDIST(10,5,0.25)=0.055049
"NORMDIST” Description: "Returns the normal cumulative distribution" Input: "(Number, Mean, Standard_Dev, Cumulative)" Type: Statistical Example: NORMDIST(42,40,1.5,TRUE)=0.908789
"NORMFR” Description: Returns the Normal failure rate at a given time Input: Time, Mean, Standard_Dev Type: Statistical Example: NORMFR(42,40,1.5)= 1.198757
"NORMINV” Description: "Returns the inverse of the normal cumulative distribution" Input: "(Probability, Mean, Standard_Dev)" Type: Statistical Example: NORMINV(0.908789,40,1.5)=42 "NORMREL” Description: "Returns the Normal reliability at a given time" Input: "(Time, Mean, Standard_Dev)" Type: Statistical Example: NORMREL(42,40,1.5,TRUE)= 0.091211
"NORMSDIST” Description: "Returns the standard normal cumulative distribution" Input: "(Z)" Type: Statistical Example: NORMSDIST(1.333333333)=0.908789
"NORMSINV” Description: "Returns the inverse of the standard normal cumulative distribution" Input: "(Probability)" Type: Statistical Example: NORMS_INV(0.908789)=1.333335
"PERMUT" Description: "Returns the number of permutations for a given number of objects" Input: "(Number, Number_Chosen)" Type: Statistical Example: PERMUT(8.02365985,3)=336
"POISSON" Description: "Returns the Poisson distribution" Input: "(Number, Lambda, Cumulative)" Type: Statistical Example: POISSON(2,5,TRUE)=0.124652
"STANDARDIZE" Description: "Returns a normalized value" Input: "(Number, mean, standard_dev)" Type: Statistical Example: STANDARDIZE(8.02365985,4,2.5)=1.609464
"WEIBULLDIST” Description: "Returns the Weibull distribution" Input: "(Number, Beta, Eta, Gamma, Cumulative)" Type: Statistical Example: WEIBULLDIST(105,20,100,0, True)=0.929581
"WEIBULLFR” Description: "Returns the Weibull failure rate at a given time" Input: "(Time, Beta, Eta, Gamma)" Type: Statistical Example: WEIBULLFR(20, 1.65, 103.35, -9.92)=0.007133
"WEIBULLINV” Description: "Returns the inverse of the Weibull cumulative distribution" Input: "(Probability, Beta, Eta, Gamma)" Type: Statistical Example: WEIBULLINV(0.98, 1.65, 103.35, -9.92)=226.313581
"WEIBULLMEAN” Description: "Returns the mean of a Weibull distribution" Input: "(Beta, Eta, Gamma)" Type: Statistical Example: WEIBULLMEAN( 1.65, 103.35, -9.92)=82.496723
"WEIBULLREL” Description: "Returns the Weibull reliability at a given time" Input: "(Time, Beta, Eta, Gamma)" Type: Statistical Example: WEIBULLREL(20, 1.65, 103.35, -9.92)=0.878677
GROUP: LOGICAL
"FALSE” Description: "Returns the value zero" Input: “” Type: Logical Example: FALSE=0
"IF” Description: "Evaluates Test and returns ‘Value If True’ if Test is true and ‘Value If False’ if Test is false" Input: “(Test, Value If True, Value If False)” Type: Logical Example: IF(10>5,10,20)=10
"TRUE” Description: ""Returns the value one" Input: “” Type: Logical Example: TRUE
Reserved Keywords
General IN – Evaluates to the value of the constructs preceding the current construct. Simulation/RUN Info SIMS_CUR – Evaluates to the current execution index during a simulation. SIMS_TOTAL – Evaluates to the total number of execution defined during a simulation. RUNS_CUR – Evaluates to the current simulation index during a RUN. RUNS_TOTAL – Evaluates to the total number of simulations defined during a run. Tables REMOVE_ROW(Table Name, Row) – Deletes a row from an existing table. Rows (and their indexes) are shifted down to allow for adjustment. RESET_TABLE(Table Name) – Restores the table to its original values during a simulation. Note that this is done automatically after the end of a simulation by RENO, however there may be instances that one may wish to restore this within a simulation. ROW_COUNT(Table Name) – Returns the number of rows (with data) in the tables. SET_TABLE(Table Name, Column Index/Name, Row Index, New Value) – Sets a value in the table. Note that if the row exists, the existing value is replaced by the new value. If this is set to a row that greater than the current Row_Count, in between rows are filled with zeros to maintain continuity. Storage Variables SET_VAR(Stg. Variable Name, New Value) – Sets a value in a storage variable.
|
|
[Home] [Software] [Training] [Consulting] [Resources] [Corporate] |
