<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - CALC addressing Enhancement"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=142954#c3">Comment # 3</a>
on <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - CALC addressing Enhancement"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=142954">bug 142954</a>
from <span class="vcard"><a class="email" href="mailto:simon2@smcalister.me.uk" title="Simon <simon2@smcalister.me.uk>"> <span class="fn">Simon</span></a>
</span></b>
<pre>(In reply to Uwe Auer from <a href="show_bug.cgi?id=142954#c2">comment #2</a>)
<span class="quote">> I can't see the benefit of "=apples@34" over "=INDEX(apples;34)"</span >
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)) )</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>