Changeset 9600 for trunk/sources/HeuristicLab.Problems.DataAnalysis.Symbolic.Views/3.4

Timestamp:

06/10/13 13:45:44 (11 years ago)

Author:

sforsten

Message:

#1730: added "ABS" again in the calculation of the relative error which was removed in r9585. If the target is negative, the absolute value prevents that the formula would result in a negative relative error.

File:

• trunk/sources/HeuristicLab.Problems.DataAnalysis.Symbolic.Views/3.4/MenuItems/ExportSymbolicSolutionToExcelMenuItem.cs (modified) (1 diff)

trunk/sources/HeuristicLab.Problems.DataAnalysis.Symbolic.Views/3.4/MenuItems/ExportSymbolicSolutionToExcelMenuItem.cs

@@ -304 +304 @@
 
       estimatedWorksheet.Cells["D2:D" + (rows + 1)].Formula = "ABS(B2 - C2)";
-      estimatedWorksheet.Cells["E2:E" + (rows + 1)].Formula = "D2 / B2";
+      estimatedWorksheet.Cells["E2:E" + (rows + 1)].Formula = "ABS(D2 / B2)";
       estimatedWorksheet.Cells["F2:F" + (rows + 1)].Formula = "C2 - B2";
       estimatedWorksheet.Cells["G2:G" + (rows + 1)].Formula = "POWER(F2, 2)";