Decompiled Code For DVARP( B$2:E$8, "Profit", E$10:E$11 )
The expression
=DVARP( B$2:E$8, "Profit", E$10:E$11 )
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.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 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")) { i++; d += 105.0; d_0_ += 105.0 * 105.0; } if (get$2("Pear")) { i++; d += 96.0; d_0_ += 96.0 * 96.0; } if (get$2("Cherry")) { i++; d += 105.0; d_0_ += 105.0 * 105.0; } if (get$2("Apple")) { i++; d += 75.0; d_0_ += 75.0 * 75.0; } if (get$2("Pear")) { i++; d += 76.8; d_0_ += 76.8 * 76.8; } if (get$2("Apple")) { i++; d += 45.0; d_0_ += 45.0 * 45.0; } return (d_0_ - d * d / (double) i) / (double) i; } final boolean get$2(String string) { if (string.equalsIgnoreCase("Nonexistent")) return true; return false; } }