public static string FormatSunRayOnTilted(TotalSunHeat data) { var sb = new StringBuilder(); var listData = data.CalculateSunRayOnTiltedScreen(); sb.AppendLine(">>Overzicht zonnestraling op scheef vlak: "); foreach (var dat in listData) { var sbAwaplhaComb = new StringBuilder(); var aplh = dat.Item1; var Aw = dat.Item2; sbAwaplhaComb.AppendLine(">>aplha: " + TotalSunHeat.CalculateRadianToDegree(aplh)); sbAwaplhaComb.AppendLine(">>Aw: " + Aw); var list = dat.Item3; var sbHour = new StringBuilder(); var sbVal = new StringBuilder(); var sbVal2 = new StringBuilder(); var sbVal3 = new StringBuilder(); sbHour.AppendFormat("|{0,13}|", "uur"); sbVal.AppendFormat("|{0,13}|", "Qdir"); sbVal2.AppendFormat("|{0,13}|", "Qhem"); sbVal3.AppendFormat("|{0,13}|", "Qgr"); foreach (var tuple in list) { sbHour.AppendFormat("|{0,8}|", +tuple.Item1); sbVal.AppendFormat("|{0,8:N2}|", tuple.Item2); sbVal2.AppendFormat("|{0,8:N2}|", tuple.Item3); sbVal3.AppendFormat("|{0,8:N2}|", tuple.Item4); } sbAwaplhaComb.AppendLine(sbHour.ToString()); sbAwaplhaComb.AppendLine(sbVal.ToString()); sbAwaplhaComb.AppendLine(sbVal2.ToString()); sbAwaplhaComb.AppendLine(sbVal3.ToString()); sbAwaplhaComb.AppendLine(); sb.Append(sbAwaplhaComb.ToString()); } sb.Append("\n"); return(sb.ToString()); }
private int GenerateHelltilted(int rowIndex, ISheet sheet) { rowIndex++; rowIndex++; var row13 = sheet.CreateRow(rowIndex); row13.CreateCell(0).SetCellValue("overzicht scheef vlak"); rowIndex++; rowIndex++; var list = _calc.CalculateSunRayOnTiltedScreen(); foreach (var data in list) { var alpha = sheet.CreateRow(rowIndex); alpha.CreateCell(0).SetCellValue("Alpha"); alpha.CreateCell(1).SetCellValue(TotalSunHeat.CalculateRadianToDegree(data.Item1)); rowIndex++; var wandAzimuth = sheet.CreateRow(rowIndex); wandAzimuth.CreateCell(0).SetCellValue("wand azimuth"); wandAzimuth.CreateCell(1).SetCellValue(data.Item2); rowIndex++; int col_hoogte_zon = 2; var uur = sheet.CreateRow(rowIndex); uur.CreateCell(0).SetCellValue("uur"); uur.CreateCell(1).SetCellValue("uur"); rowIndex++; var Qdirv = sheet.CreateRow(rowIndex); Qdirv.CreateCell(0).SetCellValue("Qdir"); Qdirv.CreateCell(1).SetCellValue("graden"); rowIndex++; var QhemV = sheet.CreateRow(rowIndex); QhemV.CreateCell(0).SetCellValue("Qhem"); QhemV.CreateCell(1).SetCellValue("eenheid"); rowIndex++; var Qgrv = sheet.CreateRow(rowIndex); Qgrv.CreateCell(0).SetCellValue("Qgr"); Qgrv.CreateCell(1).SetCellValue("eenheid"); foreach (var yeet in data.Item3) { uur.CreateCell(col_hoogte_zon).SetCellValue(yeet.Item1); Qdirv.CreateCell(col_hoogte_zon).SetCellValue(yeet.Item2); QhemV.CreateCell(col_hoogte_zon).SetCellValue(yeet.Item3); Qgrv.CreateCell(col_hoogte_zon).SetCellValue(yeet.Item4); col_hoogte_zon++; } rowIndex++; rowIndex++; } return(rowIndex); }