[Libreoffice-bugs] [Bug 142954] CALC addressing Enhancement

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=142954

--- Comment #3 from Simon <simon2 at smcalister.me.uk> ---
(In reply to Uwe Auer from comment #2)
> I can't see the benefit of "=apples at 34" over "=INDEX(apples;34)"

No you can't because you know nothing of what I am doing. Why don't you tell me
that this equation (one of the shorter ones) is simple and clear and then I can
safely ignore you forever.


=EXP( DMOD_0  +   DMOD_1 * LN(INDEX( CaseSw1_F, $B7) / INDEX( CaseSw1_F, $B7
-1)) * (1 + Variant_DEA2 * INDEX( Variant_DEA_F, $B7)) +    DMOD_2 * LN(INDEX(
CaseSw1_F, $B7 -1)) +    DMOD_3 * LN(MAX(1%, INDEX( HospLoad_F, $B7 -2)))  +   
DMOD_4 * LN(MAX(1, INDEX( Deaths_F, $B7 -1))) *(1 + Variant_DEA1 * INDEX(
Variant_DEA_F, $B7)) +     DMOD_5 * LN(INDEX( Vac_Delayed_F, $B7)) +     DMOD_6
* LN(INDEX( Health_Trend_F, $B7)) )

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210621/781180c9/attachment.htm>