private FormattedTable GetMainTable()
{
var data = this.GetMainData();
// Default sorting
var view = data.DefaultView;
view.Sort = data.Columns["treatment"].ColumnName;
// Create formatted table
var table = new FormattedTable(view.ToTable());
table.AddTableFormatting(true);
// Column renaming
table.AddColumnRenaming("attribute_", "ATTRIBUTE");
table.AddColumnRenaming("change_", "CHANGE");
table.AddColumnRenaming("beforeany", "YEARS BEFORE ANY TREATMENT");
table.AddColumnRenaming("beforesame", "YEARS BEFORE SAME TREATMENT");
table.AddColumnRenaming("treatmentid", "TREATMENT ID");
table.AddColumnRenaming("simulationid", "SIMULATION ID");
return(table);
}
private FormattedTable GetMainTable()
{
var data = this.GetMainData();
// Default sorting
var view = data.DefaultView;
view.Sort = data.Columns["prioritylevel"].ColumnName;
// Create formatted table
var table = new FormattedTable(view.ToTable());
table.AddTableFormatting(true);
// Column renaming
table.AddColumnRenaming("prioritylevel", "PRIORITY LEVEL");
// Other formatting
table.AddFormatting(new RangeFormatting(
Format.Currency,
0,
2,
data.Rows.Count,
data.Columns.Count - 2));
return(table);
}
private FormattedTable GetMainTable()
{
var data = this.GetMainData();
// Default sorting
var view = data.DefaultView;
view.Sort = data.Columns["year_"].ColumnName;
// Create formatted table
var table = new FormattedTable(view.ToTable());
table.AddTableFormatting(true);
// Column renaming
table.AddColumnRenaming("year_", "YEAR");
// Other formatting
table.AddFormatting(new RangeFormatting(
Format.Currency,
0,
1,
data.Rows.Count,
data.Columns.Count - 1));
return(table);
}
private List <ExcelRangeBase> AddNextRange(
List <ExcelRangeBase> ranges,
FormattedTable nextItem)
{
var prevRange = ranges.Last();
var prevRows = prevRange.End.Row - prevRange.Start.Row + 1;
var nextRange = prevRange.Offset(
prevRows + 1,
0,
nextItem.RowCount,
nextItem.ColumnCount);
ranges.Add(nextRange);
return(ranges);
}
private FormattedTable GetHeadingTable()
{
var data = this.GetHeadingData();
// Create formatted table w/o autofiltering
var table = new FormattedTable(data);
table.AddTableFormatting(false);
// Column renaming
table.AddColumnRenaming("firstyear", "START YEAR");
table.AddColumnRenaming("numberyears", "ANALYSIS PERIOD");
table.AddColumnRenaming("inflationrate", "INFLATION RATE (%)");
table.AddColumnRenaming("discountrate", "DISCOUNT RATE (%)");
return(table);
}
private FormattedTable GetHeadingTable()
{
var data = GetHeadingData();
// Create formatted table
var table = new FormattedTable(data);
table.AddTableFormatting(false);
// Column renaming
table.AddColumnRenaming("analysis", "OPTIMIZATION METHOD");
table.AddColumnRenaming("budget_constraint", "BUDGET");
table.AddColumnRenaming("benefit_variable", "BENEFIT");
table.AddColumnRenaming("benefit_limit", "BENEFIT LIMIT");
table.AddColumnRenaming("comments", "DESCRIPTION");
table.AddColumnRenaming("jurisdiction", "JURISDICTION CRITERIA");
return(table);
}
private FormattedTable GetMainTable()
{
var data = this.GetMainData();
// Default sorting
var view = data.DefaultView;
view.Sort = data.Columns["attribute_"].ColumnName;
// Create formatted table
var table = new FormattedTable(view.ToTable());
table.AddTableFormatting(true);
// Column renaming
table.AddColumnRenaming("attribute_", "ATTRIBUTE");
table.AddColumnRenaming("equationname", "EQUATION NAME");
return(table);
}
private FormattedTable GetMainTable()
{
var data = this.GetMainData();
// Default sorting
var view = data.DefaultView;
view.Sort = data.Columns["treatment"].ColumnName;
// Create formatted table
var table = new FormattedTable(view.ToTable());
table.AddTableFormatting(true);
// Column renaming
table.AddColumnRenaming("beforeany", "YEARS BEFORE ANY TREATMENT");
table.AddColumnRenaming("beforesame", "YEARS BEFORE SAME TREATMENT");
return(table);
}
private FormattedTable GetMainTable()
{
var data = this.GetMainData();
// Default sorting
var view = data.DefaultView;
view.Sort = data.Columns["attribute_"].ColumnName;
// Create formatted table
var table = new FormattedTable(view.ToTable());
table.AddTableFormatting(true);
// Column renaming
table.AddColumnRenaming("attribute_", "ATTRIBUTE");
table.AddColumnRenaming("deficientname", "DEFICIENT NAME");
table.AddColumnRenaming("deficient", "DEFICIENT LEVEL");
table.AddColumnRenaming("percentdeficient", "ALLOWED DEFICIENT (%)");
return(table);
}
