Decompiled Code For DSTDEV( B$2:E$8, "Profit", B$10:D$12 )

The expression

=DSTDEV( B$2:E$8, "Profit", B$10:D$12 )

is compiled to the following class(es):

package org.formulacompiler.gen;
import org.formulacompiler.runtime.Computation;
import org.formulacompiler.runtime.internal.Environment;
import org.formulacompiler.runtime.internal.RuntimeDouble_v2;
import org.formulacompiler.tests.reference.base.Inputs;
import org.formulacompiler.tests.reference.base.Outputs;

final class $Root extends Outputs implements Computation
{
    private final Inputs $inputs;
    final Environment $environment;

    $Root(Inputs inputs, Environment environment) {
        $environment = environment;
        $inputs = inputs;
    }

    final double get$0() {
        return RuntimeDouble_v2.fun_SQRT(get$1());
    }

    public final double dbl() {
        return get$0();
    }

    final double get$1() {
        double d = 0.0;
        double d_0_ = 0.0;
        int i = 0;
        if (get$2("Apple", 18.0)) {
            i++;
            d += 105.0;
            d_0_ += 105.0 * 105.0;
        }
        if (get$2("Pear", 12.0)) {
            i++;
            d += 96.0;
            d_0_ += 96.0 * 96.0;
        }
        if (get$2("Cherry", 13.0)) {
            i++;
            d += 105.0;
            d_0_ += 105.0 * 105.0;
        }
        if (get$2("Apple", 14.0)) {
            i++;
            d += 75.0;
            d_0_ += 75.0 * 75.0;
        }
        if (get$2("Pear", 9.0)) {
            i++;
            d += 76.8;
            d_0_ += 76.8 * 76.8;
        }
        if (get$2("Apple", 8.0)) {
            i++;
            d += 45.0;
            d_0_ += 45.0 * 45.0;
        }
        return (d_0_ - d * d / (double) i) / ((double) i - 1.0);
    }

    final boolean get$2(String string, double d) {
        if (string.equalsIgnoreCase("Apple") && d > 10.0 && !(d >= 16.0)
            || string.equalsIgnoreCase("Pear") &#38;&#38; d < 1000.0)
            return true;
        return false;
    }
}