private static void CreateHeatMap(UIApplication app, CarboProject carboLifeProject)
{
UIDocument uidoc = app.ActiveUIDocument;
Document doc = uidoc.Document;
using (Transaction t = new Transaction(doc, "Create Heatmap"))
{
t.Start();
FilteredElementCollector elements = new FilteredElementCollector(doc);
FillPatternElement solidFillPattern = elements.OfClass(typeof(FillPatternElement)).Cast <FillPatternElement>().First(a => a.GetFillPattern().IsSolidFill);
List <CarboElement> elementsFromGroups = carboLifeProject.getElementsFromGroups().ToList();
foreach (CarboElement ce in elementsFromGroups)
{
ElementId id = new ElementId(ce.Id);
ElementId patid = solidFillPattern.Id; //Solid
OverrideGraphicSettings ogs = new OverrideGraphicSettings();
ogs.SetHalftone(false);
ogs.SetProjectionLineColor(new Color(ce.r, ce.g, ce.b));
ogs.SetSurfaceTransparency(0);
ogs.SetProjectionLineWeight(1);
//Solid Fill;
Color elementColour = new Color(ce.r, ce.g, ce.b);
ogs.SetProjectionLineWeight(1);
ogs.SetSurfaceForegroundPatternId(patid);
ogs.SetSurfaceForegroundPatternColor(elementColour);
ogs.SetSurfaceForegroundPatternVisible(true);
ogs.SetCutLineWeight(1);
ogs.SetCutForegroundPatternId(patid);
ogs.SetCutForegroundPatternVisible(true);
ogs.SetCutForegroundPatternColor(elementColour);
//Set the override
try
{
Element elementcheck = doc.GetElement(id);
if (elementcheck != null)
{
doc.ActiveView.SetElementOverrides(id, ogs);
Parameter carboPar = elementcheck.LookupParameter("EmbodiedCarbon");
if (carboPar != null)
{
carboPar.Set(ce.EC_Total);
}
else
{
CreateParameter(app, elementcheck);
}
}
}
catch
{
}
}
t.Commit();
}
}
private static void CreateExcelFile(CarboProject carboProject, Excel.Application xlApp, bool exportResults, bool exportElements, bool exportMaterials)
{
int row = 1;
int col = 1;
Excel.Workbook xlWorkBook;
Excel.Worksheet xlWorkSheet;
Excel.Worksheet xlWorkSheet2;
Excel.Worksheet xlWorkSheet3;
xlApp.DisplayAlerts = false;
object misValue = System.Reflection.Missing.Value;
xlWorkBook = xlApp.Workbooks.Add(misValue);
/////////////////////
///GroupTable
if (exportResults == true)
{
xlWorkSheet = (Excel.Worksheet)xlApp.Worksheets.Add();
if (xlWorkSheet != null)
{
xlWorkSheet.Name = "GroupData";
row = 1;
col = 1;
xlWorkSheet.Cells[row, col] = "Category";
xlWorkSheet.Cells[row + 1, col] = "";
xlWorkSheet.Cells[row, col + 1] = "Material";
xlWorkSheet.Cells[row + 1, col + 1] = "";
xlWorkSheet.Cells[row, col + 2] = "Description";
xlWorkSheet.Cells[row + 1, col + 2] = "";
xlWorkSheet.Cells[row, col + 3] = "Total Volume";
xlWorkSheet.Cells[row + 1, col + 3] = "m³";
xlWorkSheet.Cells[row, col + 4] = "Density";
xlWorkSheet.Cells[row + 1, col + 4] = "kg/m³";
xlWorkSheet.Cells[row, col + 5] = "Mass";
xlWorkSheet.Cells[row + 1, col + 5] = "kg";
xlWorkSheet.Cells[row, col + 6] = "ECI";
xlWorkSheet.Cells[row + 1, col + 6] = "kgCO₂e/kg";
xlWorkSheet.Cells[row, col + 7] = "EC";
xlWorkSheet.Cells[row + 1, col + 7] = "tCO₂e";
xlWorkSheet.Cells[row, col + 8] = "Total";
xlWorkSheet.Cells[row + 1, col + 8] = "%";
xlWorkSheet.Cells[row, col + 9] = "A1-A3";
xlWorkSheet.Cells[row + 1, col + 9] = "tCO₂e";
xlWorkSheet.Cells[row, col + 10] = "A4";
xlWorkSheet.Cells[row + 1, col + 10] = "tCO₂e";
xlWorkSheet.Cells[row, col + 11] = "A5";
xlWorkSheet.Cells[row + 1, col + 11] = "tCO₂e";
xlWorkSheet.Cells[row, col + 12] = "B1-B5";
xlWorkSheet.Cells[row + 1, col + 12] = "tCO₂e";
xlWorkSheet.Cells[row, col + 13] = "C1-C4";
xlWorkSheet.Cells[row + 1, col + 13] = "tCO₂e";
xlWorkSheet.Cells[row, col + 14] = "D";
xlWorkSheet.Cells[row + 1, col + 14] = "tCO₂e";
xlWorkSheet.Cells[row, col + 15] = "Mix";
xlWorkSheet.Cells[row + 1, col + 15] = "tCO₂e";
//Advanced
xlWorkSheet.Cells[row, col + 16] = "[Formula]";
xlWorkSheet.Cells[row + 1, col + 16] = "";
xlWorkSheet.Cells[row, col + 17] = "[Waste]";
xlWorkSheet.Cells[row + 1, col + 17] = "%";
xlWorkSheet.Cells[row, col + 18] = "[B4]";
xlWorkSheet.Cells[row + 1, col + 18] = "x";
xlWorkSheet.Cells[row, col + 19] = "[Additional]";
xlWorkSheet.Cells[row + 1, col + 19] = "kgCO₂e/kg";
xlWorkSheet.Cells[row, col + 20] = "Base Volume";
xlWorkSheet.Cells[row + 1, col + 20] = "m³";
row++;
i++;
foreach (CarboGroup grp in carboProject.getGroupList)
{
row++;
xlWorkSheet.Cells[row, col] = grp.Category;
xlWorkSheet.Cells[row, col + 1] = grp.MaterialName;
xlWorkSheet.Cells[row, col + 2] = grp.Description;
xlWorkSheet.Cells[row, col + 3] = grp.TotalVolume;
xlWorkSheet.Cells[row, col + 4] = grp.Density;
xlWorkSheet.Cells[row, col + 5] = grp.Mass;
xlWorkSheet.Cells[row, col + 6] = grp.ECI;
xlWorkSheet.Cells[row, col + 7] = grp.EC;
xlWorkSheet.Cells[row, col + 8] = grp.PerCent;
xlWorkSheet.Cells[row, col + 9] = (grp.Material.materialB1B5Properties.B4 * (grp.Material.ECI_A1A3 * grp.Mass)) / 1000;
xlWorkSheet.Cells[row, col + 10] = (grp.Material.materialB1B5Properties.B4 * (grp.Material.ECI_A4 * grp.Mass)) / 1000;
xlWorkSheet.Cells[row, col + 11] = (grp.Material.materialB1B5Properties.B4 * (grp.Material.ECI_A5 * grp.Mass)) / 1000;
xlWorkSheet.Cells[row, col + 12] = (grp.Material.materialB1B5Properties.B4 * (grp.Material.ECI_B1B5)) / 1000;
xlWorkSheet.Cells[row, col + 13] = (grp.Material.materialB1B5Properties.B4 * (grp.Material.ECI_C1C4 * grp.Mass)) / 1000;
xlWorkSheet.Cells[row, col + 14] = (grp.Material.materialB1B5Properties.B4 * (grp.Material.ECI_D * grp.Mass)) / 1000;
xlWorkSheet.Cells[row, col + 15] = (grp.Material.materialB1B5Properties.B4 * (grp.Material.ECI_Mix * grp.Mass)) / 1000;
xlWorkSheet.Cells[row, col + 16] = grp.Correction;
xlWorkSheet.Cells[row, col + 17] = grp.Waste;
xlWorkSheet.Cells[row, col + 18] = grp.B4Factor;
xlWorkSheet.Cells[row, col + 19] = grp.Additional;
xlWorkSheet.Cells[row, col + 20] = grp.Volume;
i++;
}
//Totals
row++;
xlWorkSheet.Cells[row, col + 7].Formula = string.Format("=SUM(H3:H{0})", (row - 1));
xlWorkSheet.Cells[row, col + 8].Formula = string.Format("=SUM(I3:I{0})", (row - 1));
xlWorkSheet.Cells[row, col + 9].Formula = string.Format("=SUM(J3:J{0})", (row - 1));
xlWorkSheet.Cells[row, col + 10].Formula = string.Format("=SUM(K3:K{0})", (row - 1));
xlWorkSheet.Cells[row, col + 11].Formula = string.Format("=SUM(L3:L{0})", (row - 1));
xlWorkSheet.Cells[row, col + 12].Formula = string.Format("=SUM(M3:M{0})", (row - 1));
xlWorkSheet.Cells[row, col + 13].Formula = string.Format("=SUM(N3:N{0})", (row - 1));
xlWorkSheet.Cells[row, col + 14].Formula = string.Format("=SUM(O3:O{0})", (row - 1));
xlWorkSheet.Cells[row, col + 15].Formula = string.Format("=SUM(P3:P{0})", (row - 1));
// xlWorkSheet.Cells[row, col + 15].Formula = string.Format("=SUM(U3:P{0})", (row - 1));
//Format the table
xlWorkSheet.Columns[1].ColumnWidth = 20;
xlWorkSheet.Columns[2].ColumnWidth = 40;
xlWorkSheet.Columns[3].ColumnWidth = 40;
Marshal.ReleaseComObject(xlWorkSheet);
}
}
////////////////////
///Element Table
if (exportElements == true)
{
xlWorkSheet2 = (Excel.Worksheet)xlApp.Worksheets.Add();
//newWorksheet = Excel.Worksheet)excelApp.Worksheets.Add(Missing.Value, Missing.Value, Missing.Value, Missing.Value);
if (xlWorkSheet2 != null)
{
xlWorkSheet2.Name = "ElementData";
row = 1;
col = 1;
xlWorkSheet2.Cells[row, col] = "Id";
xlWorkSheet2.Cells[row + 1, col] = "";
xlWorkSheet2.Cells[row, col + 1] = "Name";
xlWorkSheet2.Cells[row + 1, col + 1] = "";
xlWorkSheet2.Cells[row, col + 2] = "Material Name";
xlWorkSheet2.Cells[row + 1, col + 2] = "";
xlWorkSheet2.Cells[row, col + 3] = "Category";
xlWorkSheet2.Cells[row + 1, col + 3] = "";
xlWorkSheet2.Cells[row, col + 4] = "Sub Category";
xlWorkSheet2.Cells[row + 1, col + 4] = "";
xlWorkSheet2.Cells[row, col + 5] = "Volume";
xlWorkSheet2.Cells[row + 1, col + 5] = "m³";
xlWorkSheet2.Cells[row, col + 6] = "Mass";
xlWorkSheet2.Cells[row + 1, col + 6] = "kg";
xlWorkSheet2.Cells[row, col + 7] = "Level";
xlWorkSheet2.Cells[row + 1, col + 7] = "mm";
xlWorkSheet2.Cells[row, col + 8] = "IsDemolished";
xlWorkSheet2.Cells[row + 1, col + 8] = "";
xlWorkSheet2.Cells[row, col + 9] = "IsExisting";
xlWorkSheet2.Cells[row + 1, col + 9] = "";
xlWorkSheet2.Cells[row, col + 10] = "IsSubstructure";
xlWorkSheet2.Cells[row + 1, col + 10] = "";
xlWorkSheet2.Cells[row, col + 11] = "ECI";
xlWorkSheet2.Cells[row + 1, col + 11] = "kgCO₂e/kg";
xlWorkSheet2.Cells[row, col + 12] = "EC";
xlWorkSheet2.Cells[row + 1, col + 12] = "kgCO₂e";
xlWorkSheet2.Cells[row, col + 13] = "ECI Cumulative";
xlWorkSheet2.Cells[row + 1, col + 13] = "kgCO₂e/kg";
xlWorkSheet2.Cells[row, col + 14] = "EC Cumulative";
xlWorkSheet2.Cells[row + 1, col + 14] = "kgCO₂e";
xlWorkSheet2.Cells[row, col + 15] = "Volume Cumulative";
xlWorkSheet2.Cells[row + 1, col + 15] = "m³";
row++;
i++;
foreach (CarboElement el in carboProject.getElementsFromGroups())
{
row++;
xlWorkSheet2.Cells[row, col] = el.Id;
xlWorkSheet2.Cells[row, col + 1] = el.Name;
xlWorkSheet2.Cells[row, col + 2] = el.MaterialName;
xlWorkSheet2.Cells[row, col + 3] = el.Category;
xlWorkSheet2.Cells[row, col + 4] = el.SubCategory;
xlWorkSheet2.Cells[row, col + 5] = el.Volume;
xlWorkSheet2.Cells[row, col + 6] = el.Mass;
xlWorkSheet2.Cells[row, col + 7] = el.Level;
xlWorkSheet2.Cells[row, col + 8] = el.isDemolished;
xlWorkSheet2.Cells[row, col + 9] = el.isExisting;
xlWorkSheet2.Cells[row, col + 10] = el.isSubstructure;
xlWorkSheet2.Cells[row, col + 11] = el.ECI;
xlWorkSheet2.Cells[row, col + 12] = el.EC;
xlWorkSheet2.Cells[row, col + 13] = el.ECI_Total;
xlWorkSheet2.Cells[row, col + 14] = el.EC_Total;
xlWorkSheet2.Cells[row, col + 15] = el.Volume_Total;
i++;
}
//Totals
//Format the table
xlWorkSheet2.Columns[1].ColumnWidth = 15;
xlWorkSheet2.Columns[2].ColumnWidth = 40;
xlWorkSheet2.Columns[3].ColumnWidth = 40;
xlWorkSheet2.Columns[4].ColumnWidth = 20;
Marshal.ReleaseComObject(xlWorkSheet2);
}
}
/////////////////////
///MaterialTable
if (exportMaterials == true)
{
xlWorkSheet3 = (Excel.Worksheet)xlApp.Worksheets.Add();
if (xlWorkSheet3 != null)
{
xlWorkSheet3.Name = "MaterialData";
row = 1;
col = 1;
xlWorkSheet3.Cells[row, col] = "Id";
xlWorkSheet3.Cells[row + 1, col] = "";
xlWorkSheet3.Cells[row, col + 1] = "Name";
xlWorkSheet3.Cells[row + 1, col + 1] = "";
xlWorkSheet3.Cells[row, col + 2] = "Category";
xlWorkSheet3.Cells[row + 1, col + 2] = "";
xlWorkSheet3.Cells[row, col + 3] = "Description";
xlWorkSheet3.Cells[row + 1, col + 3] = "";
xlWorkSheet3.Cells[row, col + 4] = "Density";
xlWorkSheet3.Cells[row + 1, col + 4] = "kg/m³";
xlWorkSheet3.Cells[row, col + 5] = "ECI";
xlWorkSheet3.Cells[row + 1, col + 5] = "kgCO₂e/kg";
xlWorkSheet3.Cells[row, col + 6] = "ECI Volume";
xlWorkSheet3.Cells[row + 1, col + 6] = "kgCO₂e/n³";
xlWorkSheet3.Cells[row, col + 7] = "A1-A3";
xlWorkSheet3.Cells[row + 1, col + 7] = "kgCO₂e/kg";
xlWorkSheet3.Cells[row, col + 8] = "A4";
xlWorkSheet3.Cells[row + 1, col + 8] = "kgCO₂e/kg";
xlWorkSheet3.Cells[row, col + 9] = "A5";
xlWorkSheet3.Cells[row + 1, col + 9] = "kgCO₂e/kg";
xlWorkSheet3.Cells[row, col + 10] = "B1-B7";
xlWorkSheet3.Cells[row + 1, col + 10] = "kgCO₂e/kg";
xlWorkSheet3.Cells[row, col + 11] = "C1-C4";
xlWorkSheet3.Cells[row + 1, col + 11] = "kgCO₂e/kg";
xlWorkSheet3.Cells[row, col + 12] = "D";
xlWorkSheet3.Cells[row + 1, col + 12] = "kgCO₂e/kg";
xlWorkSheet3.Cells[row, col + 13] = "Mix";
xlWorkSheet3.Cells[row + 1, col + 13] = "kgCO₂e/kg";
xlWorkSheet3.Cells[row, col + 14] = "B4";
xlWorkSheet3.Cells[row + 1, col + 14] = "factor";
row++;
foreach (CarboMaterial material in carboProject.CarboDatabase.CarboMaterialList)
{
row++;
xlWorkSheet3.Cells[row, col] = material.Id;
xlWorkSheet3.Cells[row, col + 1] = material.Name;
xlWorkSheet3.Cells[row, col + 2] = material.Category;
xlWorkSheet3.Cells[row, col + 3] = material.Description;
xlWorkSheet3.Cells[row, col + 4] = material.Density;
xlWorkSheet3.Cells[row, col + 5] = material.ECI;
xlWorkSheet3.Cells[row, col + 6] = material.getVolumeECI;
xlWorkSheet3.Cells[row, col + 7] = material.ECI_A1A3;
xlWorkSheet3.Cells[row, col + 8] = material.ECI_A4;
xlWorkSheet3.Cells[row, col + 9] = material.ECI_A5;
xlWorkSheet3.Cells[row, col + 10] = material.ECI_B1B5;
xlWorkSheet3.Cells[row, col + 11] = material.ECI_C1C4;
xlWorkSheet3.Cells[row, col + 12] = material.ECI_D;
xlWorkSheet3.Cells[row, col + 13] = material.ECI_Mix;
xlWorkSheet3.Cells[row, col + 14] = material.materialB1B5Properties.B4;
}
xlWorkSheet3.Columns[1].ColumnWidth = 15;
xlWorkSheet3.Columns[2].ColumnWidth = 30;
xlWorkSheet3.Columns[3].ColumnWidth = 20;
xlWorkSheet3.Columns[4].ColumnWidth = 50;
Marshal.ReleaseComObject(xlWorkSheet3);
}
}
////////////////////
///Save File
xlWorkBook.SaveAs(reportpath, Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue);
xlWorkBook.Close(true, misValue, misValue);
xlApp.Quit();
Marshal.ReleaseComObject(xlWorkBook);
Marshal.ReleaseComObject(xlApp);
}
