calc - CALCulate mathematical formulae

asked 2016-12-06 12:06:57 +0100

DiesNuts gravatar image

Say I have three parameters:

m (in cell B2)
lambda (in cell B7)
mu (in cell B8)

where I can easily calculate

rho = lambda/(m*mu)  (in cell B10)

I now want to calculate

p0 = 1/(1 + (m * rho)^m/(m!*(1-rho)) + sum[n=1 to m-1]( (m*rho)^n / n!) )

How do I enter the sum?

(1/(1+(B2 * (B7/(B2*B8)))^B2/(FACT(B2) * (1-(B7/(B2*B8)))) + ???))

note: I'm generating these formulae in bash so I don't need to use named cells and can re-use the generated formulae by copying the column and changing the parameters for your convenience:

lambda="B7"
mu="B8"
m="B2"

rho="($lambda/($m*$mu))"
echo -e "rho =\n\t$rho"

p0="(1/(1+($m * $rho)^$m/(FACT($m) * (1-$rho)) + ???))"
echo -e "p0 =\n\t$p0"
edit retag flag offensive close merge delete