C# Class Smrf.NodeXL.ExcelTemplate.TableColumnMapper

Object that maps the numbers in one table column to values in another column.
All methods are static.
Inheritance: Object
Exibir arquivo Open project: 2014-sed-team3/term-project

Public Methods

Method Description
MapToTwoStrings ( ListObject table, String sourceColumnName, String destinationColumnName, ComparisonOperator comparisonOperator, Double sourceNumberToCompareTo, String destinationString1, String destinationString2 ) : void
MapViaCopy ( ListObject table, String sourceColumnName, String destinationColumnName ) : void
TryMapAverageColor ( IEnumerable rowIDsOfRowsToAverage, Object>.Dictionary rowIDDictionary, Double sourceCalculationNumber1, Double sourceCalculationNumber2, Color destinationColor1, Color destinationColor2, System.Boolean useLogs, Color &mappedDestinationColor ) : System.Boolean
TryMapAverageNumber ( IEnumerable rowIDsOfRowsToAverage, Object>.Dictionary rowIDDictionary, Double sourceCalculationNumber1, Double sourceCalculationNumber2, Double destinationNumber1, Double destinationNumber2, System.Boolean useLogs, Double &mappedDestinationNumber ) : System.Boolean
TryMapToColor ( ListObject table, String sourceColumnName, String destinationColumnName, System.Boolean useSourceNumber1, System.Boolean useSourceNumber2, Double sourceNumber1, Double sourceNumber2, Color destinationColor1, Color destinationColor2, System.Boolean ignoreOutliers, System.Boolean useLogs, Double &sourceCalculationNumber1, Double &sourceCalculationNumber2, Int32 &decimalPlaces ) : System.Boolean
TryMapToColor ( ListObject table, String sourceColumnName, String destinationColumnName, ICollection &categoryNames ) : System.Boolean
TryMapToNumericRange ( ListObject table, String sourceColumnName, String destinationColumnName, System.Boolean useSourceNumber1, System.Boolean useSourceNumber2, Double sourceNumber1, Double sourceNumber2, Double destinationNumber1, Double destinationNumber2, System.Boolean ignoreOutliers, System.Boolean useLogs, Double &sourceCalculationNumber1, Double &sourceCalculationNumber2, Int32 &decimalPlaces ) : System.Boolean

Private Methods

Method Description
GetColorGradientMapper ( Double dSourceCalculationNumber1, Double dSourceCalculationNumber2, Color oDestinationColor1, Color oDestinationColor2 ) : ColorGradientMapper
GetDecimalPlaces ( ListObject oTable, String sSourceColumnName ) : Int32
GetLogIfRequested ( Double dNumber, System.Boolean bUseLog ) : Double
GetSourceRangeWithoutOutliers ( Range oVisibleSourceRange, Int32 iSourceNumbers, Double dMinimumSourceNumber, Double dMaximumSourceNumber, Double dMeanSourceNumber, System.Boolean bPositiveNumbersOnly, Double &dSourceRangeMinimum, Double &dSourceRangeMaximum ) : void
GetSourceStandardDeviation ( Range oVisibleSourceRange, Int32 iSourceNumbers, Double dMinimumSourceNumber, Double dMaximumSourceNumber, Double dMeanSourceNumber, System.Boolean bPositiveNumbersOnly ) : Double
GetVisibleNumbers ( Range oVisibleRange, System.Boolean bPositiveNumbersOnly ) : IEnumerable
MapSourceNumberToDestinationNumber ( Double dSourceNumberWithLog, Double dSourceCalculationNumberWithLog1, Double dSourceCalculationNumberWithLog2, Double dDestinationNumber1, Double dDestinationNumber2, System.Boolean bUseLogs ) : Double
TryGetAverageSourceNumber ( IEnumerable oRowIDsOfRowsToAverage, Object>.Dictionary oRowIDDictionary, System.Boolean bUseLogs, Double &dAverageSourceColumnNumberWithLog ) : System.Boolean
TryGetNumber ( Object oValue, System.Boolean bPositiveNumbersOnly, Double &dNumber ) : System.Boolean
TryGetNumber ( Object oValue, Double &dNumber ) : System.Boolean
TryGetSourceCalculationRange ( Range oVisibleSourceRange, System.Boolean bUseSourceNumber1, System.Boolean bUseSourceNumber2, Double dSourceNumber1, Double dSourceNumber2, System.Boolean bIgnoreOutliers, System.Boolean bPositiveNumbersOnly, Double &dSourceCalculationNumber1, Double &dSourceCalculationNumber2 ) : System.Boolean
TryGetSourceStatistics ( Range oVisibleSourceRange, System.Boolean bPositiveNumbersOnly, Int32 &iSourceNumbers, Double &dMinimumSourceNumber, Double &dMaximumSourceNumber, Double &dMeanSourceNumber ) : System.Boolean
TryGetVisibleSourceAndDestination ( ListObject oTable, String sSourceColumnName, String sDestinationColumnName, Range &oVisibleSourceRange, Range &oVisibleDestinationRange ) : System.Boolean

Method Details

MapToTwoStrings() public static method

public static MapToTwoStrings ( ListObject table, String sourceColumnName, String destinationColumnName, ComparisonOperator comparisonOperator, Double sourceNumberToCompareTo, String destinationString1, String destinationString2 ) : void
table ListObject
sourceColumnName String
destinationColumnName String
comparisonOperator ComparisonOperator
sourceNumberToCompareTo Double
destinationString1 String
destinationString2 String
return void

MapViaCopy() public static method

public static MapViaCopy ( ListObject table, String sourceColumnName, String destinationColumnName ) : void
table ListObject
sourceColumnName String
destinationColumnName String
return void

TryMapAverageColor() public static method

public static TryMapAverageColor ( IEnumerable rowIDsOfRowsToAverage, Object>.Dictionary rowIDDictionary, Double sourceCalculationNumber1, Double sourceCalculationNumber2, Color destinationColor1, Color destinationColor2, System.Boolean useLogs, Color &mappedDestinationColor ) : System.Boolean
rowIDsOfRowsToAverage IEnumerable
rowIDDictionary Object>.Dictionary
sourceCalculationNumber1 Double
sourceCalculationNumber2 Double
destinationColor1 Color
destinationColor2 Color
useLogs System.Boolean
mappedDestinationColor Color
return System.Boolean

TryMapAverageNumber() public static method

public static TryMapAverageNumber ( IEnumerable rowIDsOfRowsToAverage, Object>.Dictionary rowIDDictionary, Double sourceCalculationNumber1, Double sourceCalculationNumber2, Double destinationNumber1, Double destinationNumber2, System.Boolean useLogs, Double &mappedDestinationNumber ) : System.Boolean
rowIDsOfRowsToAverage IEnumerable
rowIDDictionary Object>.Dictionary
sourceCalculationNumber1 Double
sourceCalculationNumber2 Double
destinationNumber1 Double
destinationNumber2 Double
useLogs System.Boolean
mappedDestinationNumber Double
return System.Boolean

TryMapToColor() public static method

public static TryMapToColor ( ListObject table, String sourceColumnName, String destinationColumnName, System.Boolean useSourceNumber1, System.Boolean useSourceNumber2, Double sourceNumber1, Double sourceNumber2, Color destinationColor1, Color destinationColor2, System.Boolean ignoreOutliers, System.Boolean useLogs, Double &sourceCalculationNumber1, Double &sourceCalculationNumber2, Int32 &decimalPlaces ) : System.Boolean
table ListObject
sourceColumnName String
destinationColumnName String
useSourceNumber1 System.Boolean
useSourceNumber2 System.Boolean
sourceNumber1 Double
sourceNumber2 Double
destinationColor1 Color
destinationColor2 Color
ignoreOutliers System.Boolean
useLogs System.Boolean
sourceCalculationNumber1 Double
sourceCalculationNumber2 Double
decimalPlaces System.Int32
return System.Boolean

TryMapToColor() public static method

public static TryMapToColor ( ListObject table, String sourceColumnName, String destinationColumnName, ICollection &categoryNames ) : System.Boolean
table ListObject
sourceColumnName String
destinationColumnName String
categoryNames ICollection
return System.Boolean

TryMapToNumericRange() public static method

public static TryMapToNumericRange ( ListObject table, String sourceColumnName, String destinationColumnName, System.Boolean useSourceNumber1, System.Boolean useSourceNumber2, Double sourceNumber1, Double sourceNumber2, Double destinationNumber1, Double destinationNumber2, System.Boolean ignoreOutliers, System.Boolean useLogs, Double &sourceCalculationNumber1, Double &sourceCalculationNumber2, Int32 &decimalPlaces ) : System.Boolean
table ListObject
sourceColumnName String
destinationColumnName String
useSourceNumber1 System.Boolean
useSourceNumber2 System.Boolean
sourceNumber1 Double
sourceNumber2 Double
destinationNumber1 Double
destinationNumber2 Double
ignoreOutliers System.Boolean
useLogs System.Boolean
sourceCalculationNumber1 Double
sourceCalculationNumber2 Double
decimalPlaces System.Int32
return System.Boolean