private VariableConditionTreeNode(VariableConditionTreeNode original, Cloner cloner)
: base(original, cloner)
{
threshold = original.threshold;
variableName = original.variableName;
slope = original.slope;
}
private string FormatRecursively(ISymbolicExpressionTreeNode node)
{
ISymbol symbol = node.Symbol;
StringBuilder stringBuilder = new StringBuilder();
if (symbol is ProgramRootSymbol)
{
stringBuilder.AppendLine(FormatRecursively(node.GetSubtree(0)));
}
else if (symbol is StartSymbol)
{
return(FormatRecursively(node.GetSubtree(0)));
}
else if (symbol is Addition)
{
stringBuilder.Append("(");
for (int i = 0; i < node.SubtreeCount; i++)
{
if (i > 0)
{
stringBuilder.Append("+");
}
stringBuilder.Append(FormatRecursively(node.GetSubtree(i)));
}
stringBuilder.Append(")");
}
else if (symbol is Average)
{
stringBuilder.Append("(1/");
stringBuilder.Append(node.SubtreeCount);
stringBuilder.Append(")*(");
for (int i = 0; i < node.SubtreeCount; i++)
{
if (i > 0)
{
stringBuilder.Append("+");
}
stringBuilder.Append("(");
stringBuilder.Append(FormatRecursively(node.GetSubtree(i)));
stringBuilder.Append(")");
}
stringBuilder.Append(")");
}
else if (symbol is Constant)
{
ConstantTreeNode constantTreeNode = node as ConstantTreeNode;
stringBuilder.Append(constantTreeNode.Value.ToString(CultureInfo.InvariantCulture));
}
else if (symbol is Cosine)
{
stringBuilder.Append("COS(");
stringBuilder.Append(FormatRecursively(node.GetSubtree(0)));
stringBuilder.Append(")");
}
else if (symbol is Division)
{
if (node.SubtreeCount == 1)
{
stringBuilder.Append("1/");
stringBuilder.Append(FormatRecursively(node.GetSubtree(0)));
}
else
{
stringBuilder.Append(FormatRecursively(node.GetSubtree(0)));
stringBuilder.Append("/(");
for (int i = 1; i < node.SubtreeCount; i++)
{
if (i > 1)
{
stringBuilder.Append("*");
}
stringBuilder.Append(FormatRecursively(node.GetSubtree(i)));
}
stringBuilder.Append(")");
}
}
else if (symbol is Exponential)
{
stringBuilder.Append("EXP(");
stringBuilder.Append(FormatRecursively(node.GetSubtree(0)));
stringBuilder.Append(")");
}
else if (symbol is Square)
{
stringBuilder.Append("POWER(");
stringBuilder.Append(FormatRecursively(node.GetSubtree(0)));
stringBuilder.Append(",2)");
}
else if (symbol is SquareRoot)
{
stringBuilder.Append("SQRT(");
stringBuilder.Append(FormatRecursively(node.GetSubtree(0)));
stringBuilder.Append(")");
}
else if (symbol is Logarithm)
{
stringBuilder.Append("LN(");
stringBuilder.Append(FormatRecursively(node.GetSubtree(0)));
stringBuilder.Append(")");
}
else if (symbol is Multiplication)
{
for (int i = 0; i < node.SubtreeCount; i++)
{
if (i > 0)
{
stringBuilder.Append("*");
}
stringBuilder.Append(FormatRecursively(node.GetSubtree(i)));
}
}
else if (symbol is Sine)
{
stringBuilder.Append("SIN(");
stringBuilder.Append(FormatRecursively(node.GetSubtree(0)));
stringBuilder.Append(")");
}
else if (symbol is Subtraction)
{
stringBuilder.Append("(");
if (node.SubtreeCount == 1)
{
stringBuilder.Append("-");
stringBuilder.Append(FormatRecursively(node.GetSubtree(0)));
}
else
{
stringBuilder.Append(FormatRecursively(node.GetSubtree(0)));
for (int i = 1; i < node.SubtreeCount; i++)
{
stringBuilder.Append("-");
stringBuilder.Append(FormatRecursively(node.GetSubtree(i)));
}
}
stringBuilder.Append(")");
}
else if (symbol is Tangent)
{
stringBuilder.Append("TAN(");
stringBuilder.Append(FormatRecursively(node.GetSubtree(0)));
stringBuilder.Append(")");
}
else if (symbol is Variable)
{
VariableTreeNode variableTreeNode = node as VariableTreeNode;
stringBuilder.Append(variableTreeNode.Weight.ToString(CultureInfo.InvariantCulture));
stringBuilder.Append("*");
stringBuilder.Append(GetColumnToVariableName(variableTreeNode.VariableName));// + LagToString(currentLag));
}
else if (symbol is Power)
{
stringBuilder.Append("POWER(");
stringBuilder.Append(FormatRecursively(node.GetSubtree(0)));
stringBuilder.Append(",ROUND(");
stringBuilder.Append(FormatRecursively(node.GetSubtree(1)));
stringBuilder.Append(",0))");
}
else if (symbol is Root)
{
stringBuilder.Append("(");
stringBuilder.Append(FormatRecursively(node.GetSubtree(0)));
stringBuilder.Append(")^(1 / ROUND(");
stringBuilder.Append(FormatRecursively(node.GetSubtree(1)));
stringBuilder.Append(",0))");
}
else if (symbol is IfThenElse)
{
stringBuilder.Append("IF(");
stringBuilder.Append("(" + FormatRecursively(node.GetSubtree(0)) + " ) > 0");
stringBuilder.Append(",");
stringBuilder.Append(FormatRecursively(node.GetSubtree(1)));
stringBuilder.Append(",");
stringBuilder.Append(FormatRecursively(node.GetSubtree(2)));
stringBuilder.Append(")");
}
else if (symbol is VariableCondition)
{
VariableConditionTreeNode variableConditionTreeNode = node as VariableConditionTreeNode;
double threshold = variableConditionTreeNode.Threshold;
double slope = variableConditionTreeNode.Slope;
string p = "(1 / (1 + EXP(-" + slope.ToString(CultureInfo.InvariantCulture) + " * (" + GetColumnToVariableName(variableConditionTreeNode.VariableName) + "-" + threshold.ToString(CultureInfo.InvariantCulture) + "))))";
stringBuilder.Append("((");
stringBuilder.Append(FormatRecursively(node.GetSubtree(0)));
stringBuilder.Append("*");
stringBuilder.Append(p);
stringBuilder.Append(") + (");
stringBuilder.Append(FormatRecursively(node.GetSubtree(1)));
stringBuilder.Append("*(");
stringBuilder.Append("1 - " + p + ")");
stringBuilder.Append("))");
}
else if (symbol is Xor)
{
stringBuilder.Append("IF(");
stringBuilder.Append("XOR(");
stringBuilder.Append("(" + FormatRecursively(node.GetSubtree(0)) + ") > 0,");
stringBuilder.Append("(" + FormatRecursively(node.GetSubtree(1)) + ") > 0");
stringBuilder.Append("), 1.0, -1.0)");
}
else if (symbol is Or)
{
stringBuilder.Append("IF(");
stringBuilder.Append("OR(");
stringBuilder.Append("(" + FormatRecursively(node.GetSubtree(0)) + ") > 0,");
stringBuilder.Append("(" + FormatRecursively(node.GetSubtree(1)) + ") > 0");
stringBuilder.Append("), 1.0, -1.0)");
}
else if (symbol is And)
{
stringBuilder.Append("IF(");
stringBuilder.Append("AND(");
stringBuilder.Append("(" + FormatRecursively(node.GetSubtree(0)) + ") > 0,");
stringBuilder.Append("(" + FormatRecursively(node.GetSubtree(1)) + ") > 0");
stringBuilder.Append("), 1.0, -1.0)");
}
else if (symbol is Not)
{
stringBuilder.Append("IF(");
stringBuilder.Append(FormatRecursively(node.GetSubtree(0)));
stringBuilder.Append(" > 0, -1.0, 1.0)");
}
else if (symbol is GreaterThan)
{
stringBuilder.Append("IF((");
stringBuilder.Append(FormatRecursively(node.GetSubtree(0)));
stringBuilder.Append(") > (");
stringBuilder.Append(FormatRecursively(node.GetSubtree(1)));
stringBuilder.Append("), 1.0, -1.0)");
}
else if (symbol is LessThan)
{
stringBuilder.Append("IF((");
stringBuilder.Append(FormatRecursively(node.GetSubtree(0)));
stringBuilder.Append(") < (");
stringBuilder.Append(FormatRecursively(node.GetSubtree(1)));
stringBuilder.Append("), 1.0, -1.0)");
}
else
{
throw new NotImplementedException("Excel export of " + node.Symbol + " is not implemented.");
}
return(stringBuilder.ToString());
}
private VariableConditionTreeNode(VariableConditionTreeNode original, Cloner cloner)
: base(original, cloner) {
threshold = original.threshold;
variableName = original.variableName;
slope = original.slope;
}
private string FormatRecursively(ISymbolicExpressionTreeNode node)
{
ISymbol symbol = node.Symbol;
StringBuilder stringBuilder = new StringBuilder();
if (symbol is ProgramRootSymbol)
{
stringBuilder.AppendLine(FormatRecursively(node.GetSubtree(0)));
}
else if (symbol is StartSymbol)
{
return(FormatRecursively(node.GetSubtree(0)));
}
else if (symbol is Addition)
{
stringBuilder.Append("(");
for (int i = 0; i < node.SubtreeCount; i++)
{
if (i > 0)
{
stringBuilder.Append("+");
}
stringBuilder.Append(FormatRecursively(node.GetSubtree(i)));
}
stringBuilder.Append(")");
}
else if (symbol is Absolute)
{
stringBuilder.Append($"ABS({FormatRecursively(node.GetSubtree(0))})");
}
else if (symbol is AnalyticQuotient)
{
stringBuilder.Append($"({FormatRecursively(node.GetSubtree(0))}) / SQRT(1 + POWER({FormatRecursively(node.GetSubtree(1))}, 2))");
}
else if (symbol is Average)
{
stringBuilder.Append("(1/(");
stringBuilder.Append(node.SubtreeCount);
stringBuilder.Append(")*(");
for (int i = 0; i < node.SubtreeCount; i++)
{
if (i > 0)
{
stringBuilder.Append("+");
}
stringBuilder.Append("(");
stringBuilder.Append(FormatRecursively(node.GetSubtree(i)));
stringBuilder.Append(")");
}
stringBuilder.Append("))");
}
else if (symbol is Constant)
{
ConstantTreeNode constantTreeNode = node as ConstantTreeNode;
stringBuilder.Append(constantTreeNode.Value.ToString(CultureInfo.InvariantCulture));
}
else if (symbol is Cosine)
{
stringBuilder.Append("COS(");
stringBuilder.Append(FormatRecursively(node.GetSubtree(0)));
stringBuilder.Append(")");
}
else if (symbol is Cube)
{
stringBuilder.Append($"POWER({FormatRecursively(node.GetSubtree(0))}, 3)");
}
else if (symbol is CubeRoot)
{
var arg_expr = FormatRecursively(node.GetSubtree(0));
stringBuilder.Append($"IF({arg_expr} < 0, -POWER(-{arg_expr}, 1/3), POWER({arg_expr}, 1/3))");
}
else if (symbol is Division)
{
if (node.SubtreeCount == 1)
{
stringBuilder.Append("1/(");
stringBuilder.Append(FormatRecursively(node.GetSubtree(0)));
stringBuilder.Append(")");
}
else
{
stringBuilder.Append(FormatRecursively(node.GetSubtree(0)));
stringBuilder.Append("/(");
for (int i = 1; i < node.SubtreeCount; i++)
{
if (i > 1)
{
stringBuilder.Append("*");
}
stringBuilder.Append(FormatRecursively(node.GetSubtree(i)));
}
stringBuilder.Append(")");
}
}
else if (symbol is Exponential)
{
stringBuilder.Append("EXP(");
stringBuilder.Append(FormatRecursively(node.GetSubtree(0)));
stringBuilder.Append(")");
}
else if (symbol is Square)
{
stringBuilder.Append("POWER(");
stringBuilder.Append(FormatRecursively(node.GetSubtree(0)));
stringBuilder.Append(",2)");
}
else if (symbol is SquareRoot)
{
stringBuilder.Append("SQRT(");
stringBuilder.Append(FormatRecursively(node.GetSubtree(0)));
stringBuilder.Append(")");
}
else if (symbol is Logarithm)
{
stringBuilder.Append("LN(");
stringBuilder.Append(FormatRecursively(node.GetSubtree(0)));
stringBuilder.Append(")");
}
else if (symbol is Multiplication)
{
for (int i = 0; i < node.SubtreeCount; i++)
{
if (i > 0)
{
stringBuilder.Append("*");
}
stringBuilder.Append(FormatRecursively(node.GetSubtree(i)));
}
}
else if (symbol is Sine)
{
stringBuilder.Append("SIN(");
stringBuilder.Append(FormatRecursively(node.GetSubtree(0)));
stringBuilder.Append(")");
}
else if (symbol is Subtraction)
{
stringBuilder.Append("(");
if (node.SubtreeCount == 1)
{
stringBuilder.Append("-");
stringBuilder.Append(FormatRecursively(node.GetSubtree(0)));
}
else
{
stringBuilder.Append(FormatRecursively(node.GetSubtree(0)));
for (int i = 1; i < node.SubtreeCount; i++)
{
stringBuilder.Append("-");
stringBuilder.Append(FormatRecursively(node.GetSubtree(i)));
}
}
stringBuilder.Append(")");
}
else if (symbol is Tangent)
{
stringBuilder.Append("TAN(");
stringBuilder.Append(FormatRecursively(node.GetSubtree(0)));
stringBuilder.Append(")");
}
else if (symbol is HyperbolicTangent)
{
stringBuilder.Append("TANH(");
stringBuilder.Append(FormatRecursively(node.GetSubtree(0)));
stringBuilder.Append(")");
}
else if (symbol is Variable)
{
VariableTreeNode variableTreeNode = node as VariableTreeNode;
stringBuilder.Append(variableTreeNode.Weight.ToString(CultureInfo.InvariantCulture));
stringBuilder.Append("*");
stringBuilder.Append(GetColumnToVariableName(variableTreeNode.VariableName));
}
else if (symbol is BinaryFactorVariable)
{
var binFactorNode = node as BinaryFactorVariableTreeNode;
stringBuilder.AppendFormat("IF({0}=\"{1}\", {2}, 0)",
GetColumnToVariableName(binFactorNode.VariableName),
binFactorNode.VariableValue,
binFactorNode.Weight.ToString(CultureInfo.InvariantCulture)
);
}
else if (symbol is FactorVariable)
{
var factorNode = node as FactorVariableTreeNode;
var values = factorNode.Symbol.GetVariableValues(factorNode.VariableName).ToArray();
var w = factorNode.Weights;
// create nested if
for (int i = 0; i < values.Length; i++)
{
stringBuilder.AppendFormat("IF({0}=\"{1}\", {2}, ",
GetColumnToVariableName(factorNode.VariableName),
values[i],
w[i].ToString(CultureInfo.InvariantCulture));
}
stringBuilder.Append("\"\""); // return empty string on unknown value
stringBuilder.Append(')', values.Length); // add closing parenthesis
}
else if (symbol is Power)
{
stringBuilder.Append("POWER(");
stringBuilder.Append(FormatRecursively(node.GetSubtree(0)));
stringBuilder.Append(",ROUND(");
stringBuilder.Append(FormatRecursively(node.GetSubtree(1)));
stringBuilder.Append(",0))");
}
else if (symbol is Root)
{
stringBuilder.Append("(");
stringBuilder.Append(FormatRecursively(node.GetSubtree(0)));
stringBuilder.Append(")^(1 / ROUND(");
stringBuilder.Append(FormatRecursively(node.GetSubtree(1)));
stringBuilder.Append(",0))");
}
else if (symbol is IfThenElse)
{
stringBuilder.Append("IF(");
stringBuilder.Append("(" + FormatRecursively(node.GetSubtree(0)) + " ) > 0");
stringBuilder.Append(",");
stringBuilder.Append(FormatRecursively(node.GetSubtree(1)));
stringBuilder.Append(",");
stringBuilder.Append(FormatRecursively(node.GetSubtree(2)));
stringBuilder.Append(")");
}
else if (symbol is VariableCondition)
{
VariableConditionTreeNode variableConditionTreeNode = node as VariableConditionTreeNode;
if (!variableConditionTreeNode.Symbol.IgnoreSlope)
{
double threshold = variableConditionTreeNode.Threshold;
double slope = variableConditionTreeNode.Slope;
string p = "(1 / (1 + EXP(-" + slope.ToString(CultureInfo.InvariantCulture) + " * (" +
GetColumnToVariableName(variableConditionTreeNode.VariableName) + "-" +
threshold.ToString(CultureInfo.InvariantCulture) + "))))";
stringBuilder.Append("((");
stringBuilder.Append(FormatRecursively(node.GetSubtree(0)));
stringBuilder.Append("*");
stringBuilder.Append(p);
stringBuilder.Append(") + (");
stringBuilder.Append(FormatRecursively(node.GetSubtree(1)));
stringBuilder.Append("*(");
stringBuilder.Append("1 - " + p + ")");
stringBuilder.Append("))");
}
else
{
stringBuilder.AppendFormat(CultureInfo.InvariantCulture, "(IF({0} <= {1}, {2}, {3}))",
GetColumnToVariableName(variableConditionTreeNode.VariableName),
variableConditionTreeNode.Threshold,
FormatRecursively(node.GetSubtree(0)),
FormatRecursively(node.GetSubtree(1))
);
}
}
else if (symbol is Xor)
{
stringBuilder.Append("IF(");
stringBuilder.Append("XOR(");
stringBuilder.Append("(" + FormatRecursively(node.GetSubtree(0)) + ") > 0,");
stringBuilder.Append("(" + FormatRecursively(node.GetSubtree(1)) + ") > 0");
stringBuilder.Append("), 1.0, -1.0)");
}
else if (symbol is Or)
{
stringBuilder.Append("IF(");
stringBuilder.Append("OR(");
stringBuilder.Append("(" + FormatRecursively(node.GetSubtree(0)) + ") > 0,");
stringBuilder.Append("(" + FormatRecursively(node.GetSubtree(1)) + ") > 0");
stringBuilder.Append("), 1.0, -1.0)");
}
else if (symbol is And)
{
stringBuilder.Append("IF(");
stringBuilder.Append("AND(");
stringBuilder.Append("(" + FormatRecursively(node.GetSubtree(0)) + ") > 0,");
stringBuilder.Append("(" + FormatRecursively(node.GetSubtree(1)) + ") > 0");
stringBuilder.Append("), 1.0, -1.0)");
}
else if (symbol is Not)
{
stringBuilder.Append("IF(");
stringBuilder.Append(FormatRecursively(node.GetSubtree(0)));
stringBuilder.Append(" > 0, -1.0, 1.0)");
}
else if (symbol is GreaterThan)
{
stringBuilder.Append("IF((");
stringBuilder.Append(FormatRecursively(node.GetSubtree(0)));
stringBuilder.Append(") > (");
stringBuilder.Append(FormatRecursively(node.GetSubtree(1)));
stringBuilder.Append("), 1.0, -1.0)");
}
else if (symbol is LessThan)
{
stringBuilder.Append("IF((");
stringBuilder.Append(FormatRecursively(node.GetSubtree(0)));
stringBuilder.Append(") < (");
stringBuilder.Append(FormatRecursively(node.GetSubtree(1)));
stringBuilder.Append("), 1.0, -1.0)");
}
else
{
throw new NotImplementedException("Excel export of " + node.Symbol + " is not implemented.");
}
return(stringBuilder.ToString());
}