Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenTue, 06 Dec 2016 12:06:57 +0100calc - CALCulate mathematical formulaehttps://ask.libreoffice.org/en/question/83258/calc-calculate-mathematical-formulae/ 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"
Tue, 06 Dec 2016 12:06:57 +0100https://ask.libreoffice.org/en/question/83258/calc-calculate-mathematical-formulae/