Package es.urjc.etsii.grafo.io.serializers.excel

Class ExcelConfig

java.lang.Object
es.urjc.etsii.grafo.io.serializers.AbstractSerializerConfig
es.urjc.etsii.grafo.io.serializers.AbstractResultSerializerConfig
es.urjc.etsii.grafo.io.serializers.excel.ExcelConfig
@SerializerSource @ConfigurationProperties(prefix="serializers.xlsx") public class ExcelConfig extends AbstractResultSerializerConfig
This class is used to configure the Excel serializer by the properties specified in the application.yml Exports the results of each experiment.

  • Constructor Details

    • ExcelConfig

      public ExcelConfig()

  • Method Details

    • getCalculationMode

      public ExcelConfig.CalculationMode getCalculationMode()
      Defines how to handle calculated values when serializing to Excel 2007+
      Returns:
      a value from CalculationMode enum

    • getRowThreshold

      public int getRowThreshold()
      When calculationMode is AUTO, less than the threshold will use Excel mode, more than threshold will use Java mode (much faster).
      Returns:
      row threshold to change mode automatically

    • setCalculationMode

      public void setCalculationMode(ExcelConfig.CalculationMode calculationMode)
      Defines how to handle calculated values when serializing to Excel 2007+
      Parameters:
      calculationMode - new calculation mode

    • isAlgorithmsInColumns

      public boolean isAlgorithmsInColumns()
      When generating the pivot table, should algorithms be in rows or columns?
      Returns:
      True: Instances per row, algorithms in columns False: Algorithms in rows, instances in columns

    • setAlgorithmsInColumns

      public void setAlgorithmsInColumns(boolean algorithmsInColumns)
      When generating the pivot table, should algorithms be in rows or columns?
      Parameters:
      algorithmsInColumns - True: Instances per row, algorithms in columns False: Algorithms in rows, instances in columns

    • isBestScoreEnabled

      public boolean isBestScoreEnabled()
      Show best (min or max) score column in pivot table
      Returns:
      true to show, false to hide

    • setBestScoreEnabled

      public void setBestScoreEnabled(boolean bestScoreEnabled)
      Show best (min or max) score column in pivot table
      Parameters:
      bestScoreEnabled - true to show, false to hide

    • isAvgScoreEnabled

      public boolean isAvgScoreEnabled()
      Show average score column in pivot table
      Returns:
      true to show, false to hide

    • setAvgScoreEnabled

      public void setAvgScoreEnabled(boolean avgScoreEnabled)
      Show average score column in pivot table
      Parameters:
      avgScoreEnabled - true to show, false to hide

    • isStdScoreEnabled

      public boolean isStdScoreEnabled()
      Show standard deviation of solution score column in pivot table
      Returns:
      true to show, false to hide

    • setStdScoreEnabled

      public void setStdScoreEnabled(boolean stdScoreEnabled)
      Show standard deviation of solution score column in pivot table
      Parameters:
      stdScoreEnabled - true to show, false to hide

    • isVarScoreEnabled

      public boolean isVarScoreEnabled()
      Show variance of solution score column in pivot table
      Returns:
      true to show, false to hide

    • setVarScoreEnabled

      public void setVarScoreEnabled(boolean varScoreEnabled)
      Show variance of solution score column in pivot table
      Parameters:
      varScoreEnabled - true to show, false to hide

    • isAvgTimeEnabled

      public boolean isAvgTimeEnabled()
      Show average time in seconds per iteration in pivot table
      Returns:
      true to show, false to hide

    • setAvgTimeEnabled

      public void setAvgTimeEnabled(boolean avgTimeEnabled)
      Show average time in seconds per iteration in pivot table
      Parameters:
      avgTimeEnabled - true to show, false to hide

    • isTotalTimeEnabled

      public boolean isTotalTimeEnabled()
      Show total time in seconds for a given (algorithm, instance) in pivot table.
      Returns:
      true to show, false to hide

    • setTotalTimeEnabled

      public void setTotalTimeEnabled(boolean totalTimeEnabled)
      Show total time in seconds for a given (algorithm, instance) in pivot table.
      Parameters:
      totalTimeEnabled - true to show, false to hide

    • isAvgTTBEnabled

      public boolean isAvgTTBEnabled()
      Show average time to the best solution in seconds in pivot table.
      Returns:
      true to show, false to hide

    • setAvgTTBEnabled

      public void setAvgTTBEnabled(boolean avgTTBEnabled)
      Show average time to the best solution in seconds in pivot table.
      Parameters:
      avgTTBEnabled - true to show, false to hide

    • isTotalTTBEnabled

      public boolean isTotalTTBEnabled()
      Show total time to the best solution in seconds in pivot table.
      Returns:
      true to show, false to hide

    • setTotalTTBEnabled

      public void setTotalTTBEnabled(boolean totalTTBEnabled)
      Show total time to the best solution in seconds in pivot table.
      Parameters:
      totalTTBEnabled - true to show, false to hide

    • isSumBestKnownEnabled

      public boolean isSumBestKnownEnabled()
      Show number of times a given algorithm reaches the best known solution.
      Returns:
      true to show, false to hide

    • setSumBestKnownEnabled

      public void setSumBestKnownEnabled(boolean sumBestKnownEnabled)
      Show 1 if a given algorithm reaches the best solution for an instance, 0 otherwise.
      Parameters:
      sumBestKnownEnabled - true to show, false to hide

    • isHasBestKnownEnabled

      public boolean isHasBestKnownEnabled()
      Show 1 if a given algorithm reaches the best solution for an instance, 0 otherwise.
      Returns:
      true to show, false to hide

    • setHasBestKnownEnabled

      public void setHasBestKnownEnabled(boolean hasBestKnownEnabled)

      Setter for the field hasBestKnownEnabled.

      Parameters:
      hasBestKnownEnabled - true to show, false to hide

    • isAvgDevToBestKnownEnabled

      public boolean isAvgDevToBestKnownEnabled()
      Show average percentage deviation to best known solution in pivot table.
      Returns:
      true to show, false to hide

    • setAvgDevToBestKnownEnabled

      public void setAvgDevToBestKnownEnabled(boolean avgDevToBestKnownEnabled)
      Show average percentage deviation to best known solution in pivot table.
      Parameters:
      avgDevToBestKnownEnabled - true to show, false to hide

    • isMinDevToBestKnownEnabled

      public boolean isMinDevToBestKnownEnabled()
      Show minimum percentage deviation to best known solution in pivot table.
      Returns:
      true to show, false to hide

    • setMinDevToBestKnownEnabled

      public void setMinDevToBestKnownEnabled(boolean minDevToBestKnownEnabled)
      Show minimum percentage deviation to best known solution in pivot table.
      Parameters:
      minDevToBestKnownEnabled - true to show, false to hide

    • isRowGrandTotal

      public boolean isRowGrandTotal()
      Show generated grand total for rows in pivot table
      Returns:
      true to show, false to hide

    • setRowGrandTotal

      public void setRowGrandTotal(boolean rowGrandTotal)
      Show generated grand total for rows in pivot table
      Parameters:
      rowGrandTotal - true to show, false to hide

    • isColumnGrandTotal

      public boolean isColumnGrandTotal()
      Show generated grand total for columns in pivot table
      Returns:
      true to show, false to hide

    • setColumnGrandTotal

      public void setColumnGrandTotal(boolean columnGrandTotal)
      Show generated grand total for columns in pivot table
      Parameters:
      columnGrandTotal - true to show, false to hide

    • isInstanceSheetEnabled

      public boolean isInstanceSheetEnabled()
      Should the instance sheet be created in the experiment results workbook?
      Returns:
      true if enabled, false if disabled

    • setInstanceSheetEnabled

      public void setInstanceSheetEnabled(boolean instanceSheetEnabled)
      instanceSheetEnabled
      Parameters:
      instanceSheetEnabled - true to enable, false to disable