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 Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionbooleanWhen generating the pivot table, should algorithms be in rows or columns?booleanShow average percentage deviation to best known solution in pivot table.booleanShow average score column in pivot tablebooleanShow average time in seconds per iteration in pivot tablebooleanShow average time to the best solution in seconds in pivot table.booleanShow best (min or max) score column in pivot tablebooleanShow generated grand total for columns in pivot tablebooleanShow 1 if a given algorithm reaches the best solution for an instance, 0 otherwise.booleanShould the instance sheet be created in the experiment results workbook?booleanShow minimum percentage deviation to best known solution in pivot table.booleanShow generated grand total for rows in pivot tablebooleanShow standard deviation of solution score column in pivot tablebooleanShow number of times a given algorithm reaches the best known solution.booleanShow total time in seconds for a given (algorithm, instance) in pivot table.booleanShow total time to the best solution in seconds in pivot table.booleanShow variance of solution score column in pivot tablevoidsetAlgorithmsInColumns(boolean algorithmsInColumns) When generating the pivot table, should algorithms be in rows or columns?voidsetAvgDevToBestKnownEnabled(boolean avgDevToBestKnownEnabled) Show average percentage deviation to best known solution in pivot table.voidsetAvgScoreEnabled(boolean avgScoreEnabled) Show average score column in pivot tablevoidsetAvgTimeEnabled(boolean avgTimeEnabled) Show average time in seconds per iteration in pivot tablevoidsetAvgTTBEnabled(boolean avgTTBEnabled) Show average time to the best solution in seconds in pivot table.voidsetBestScoreEnabled(boolean bestScoreEnabled) Show best (min or max) score column in pivot tablevoidsetColumnGrandTotal(boolean columnGrandTotal) Show generated grand total for columns in pivot tablevoidsetHasBestKnownEnabled(boolean hasBestKnownEnabled) Setter for the fieldhasBestKnownEnabled.voidsetInstanceSheetEnabled(boolean instanceSheetEnabled) instanceSheetEnabledvoidsetMinDevToBestKnownEnabled(boolean minDevToBestKnownEnabled) Show minimum percentage deviation to best known solution in pivot table.voidsetRowGrandTotal(boolean rowGrandTotal) Show generated grand total for rows in pivot tablevoidsetStdScoreEnabled(boolean stdScoreEnabled) Show standard deviation of solution score column in pivot tablevoidsetSumBestKnownEnabled(boolean sumBestKnownEnabled) Show 1 if a given algorithm reaches the best solution for an instance, 0 otherwise.voidsetTotalTimeEnabled(boolean totalTimeEnabled) Show total time in seconds for a given (algorithm, instance) in pivot table.voidsetTotalTTBEnabled(boolean totalTTBEnabled) Show total time to the best solution in seconds in pivot table.voidsetVarScoreEnabled(boolean varScoreEnabled) Show variance of solution score column in pivot tableMethods inherited from class es.urjc.etsii.grafo.io.serializers.AbstractResultSerializerConfig
getFrequency, setFrequencyMethods inherited from class es.urjc.etsii.grafo.io.serializers.AbstractSerializerConfig
getFolder, getFormat, isEnabled, setEnabled, setFolder, setFormat
-
Constructor Details
-
ExcelConfig
public ExcelConfig()
-
-
Method Details
-
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
-