Tabellen in Webfront

Ich hätte auch noch einen Vorschlag, ist für die statistische Betrachtung einer Zählervariable gedacht (die letzten 12 Monate ab heute, Tagesdurchschnitt/Monat, Verbrauch pro Monat und kumulierter Zählerstand), vom Anwender müssen nur die beiden ersten Variablen im Script angepasst werden.

Installation:

  1. Contend-Variable anlegen (String, Profil: ~HTML)
    2, Script anlegen und Inhalt aus diesem Posting reinkopieren
  2. Variablen anpassen
  3. Link von der Contend-Variable ins WFE legen
  4. Script ausführen

<?

// +++++++++++++++ Konfig ++++++++++++++++++++++++++++++++++++++++++++++++++++++

$objectID = 12130 /*[Smart Metering\IPS EKM-868\EKM-868 I Hausverteilung\EKM-868 #01 Zentraleinspeisung\Energieverbrauch]*/ ; // Variablen-ID der Zähler-Variable
$contend_var_id = 55821  /*[Smart Metering\berechnete Werte\gleitender Durchschnitt\HTML Tabelle Jahresübersicht]*/;

// ab hier nichts mehr ändern
$archiveID = IPS_GetInstanceIDByName("Archive Handler", 0);   // Archive-Handler-ID
$verbrauch_akt=getvalue($objectID);
$year_startdate = mktime(0, 0, 0, date("m")-12, 1, date("Y")); //Startzeit am 1. des Monats vor einem Jahr
$year_enddate = time(); //Endzeit heute
$end_month_format = date("H:i:s d.m.Y",$year_enddate);

// +++++++++++++++ Konfig Ende +++++++++++++++++++++++++++++++++++++++++++++++++

// Ermitteln der Spaltenüberschriften (Monate)
$M_00 = date("M",time());
$M_01 = date("M",mktime(0, 0, 0, date("m")-1, 1, date("Y")));
$M_02 = date("M",mktime(0, 0, 0, date("m")-2, 1, date("Y")));
$M_03 = date("M",mktime(0, 0, 0, date("m")-3, 1, date("Y")));
$M_04 = date("M",mktime(0, 0, 0, date("m")-4, 1, date("Y")));
$M_05 = date("M",mktime(0, 0, 0, date("m")-5, 1, date("Y")));
$M_06 = date("M",mktime(0, 0, 0, date("m")-6, 1, date("Y")));
$M_07 = date("M",mktime(0, 0, 0, date("m")-7, 1, date("Y")));
$M_08 = date("M",mktime(0, 0, 0, date("m")-8, 1, date("Y")));
$M_09 = date("M",mktime(0, 0, 0, date("m")-9, 1, date("Y")));
$M_10 = date("M",mktime(0, 0, 0, date("m")-10, 1, date("Y")));
$M_11 = date("M",mktime(0, 0, 0, date("m")-11, 1, date("Y")));

// Ermitteln der Anzahl Tage pro Monat
$M_Anzahl_00 = date("d");
$M_Anzahl_01 = date("t",mktime(0, 0, 0, date("m")-1, 1, date("Y")));
$M_Anzahl_02 = date("t",mktime(0, 0, 0, date("m")-2, 1, date("Y")));
$M_Anzahl_03 = date("t",mktime(0, 0, 0, date("m")-3, 1, date("Y")));
$M_Anzahl_04 = date("t",mktime(0, 0, 0, date("m")-4, 1, date("Y")));
$M_Anzahl_05 = date("t",mktime(0, 0, 0, date("m")-5, 1, date("Y")));
$M_Anzahl_06 = date("t",mktime(0, 0, 0, date("m")-6, 1, date("Y")));
$M_Anzahl_07 = date("t",mktime(0, 0, 0, date("m")-7, 1, date("Y")));
$M_Anzahl_08 = date("t",mktime(0, 0, 0, date("m")-8, 1, date("Y")));
$M_Anzahl_09 = date("t",mktime(0, 0, 0, date("m")-9, 1, date("Y")));
$M_Anzahl_10 = date("t",mktime(0, 0, 0, date("m")-10, 1, date("Y")));
$M_Anzahl_11 = date("t",mktime(0, 0, 0, date("m")-11, 1, date("Y")));
echo "Anzahl tage: $M_Anzahl_00 
";

// Abfrage Monatswerte der letzten 12 Monate

$month_values = AC_GetAggregatedValues($archiveID, $objectID, 3, $year_startdate, $year_enddate, 15);
	@$c_zentral_00 = round($month_values[11]['Avg'], 1);
	@$c_zentral_01 = round($month_values[10]['Avg'] + $c_zentral_00, 1);
	@$c_zentral_02 = round($month_values[9]['Avg'] + $c_zentral_01, 1);
	@$c_zentral_03 = round($month_values[8]['Avg'] + $c_zentral_02, 1);
	@$c_zentral_04 = round($month_values[7]['Avg'] + $c_zentral_03, 1);
	@$c_zentral_05 = round($month_values[6]['Avg'] + $c_zentral_04, 1);
	@$c_zentral_06 = round($month_values[5]['Avg'] + $c_zentral_05, 1);
	@$c_zentral_07 = round($month_values[4]['Avg'] + $c_zentral_06, 1);
	@$c_zentral_08 = round($month_values[3]['Avg'] + $c_zentral_07, 1);
	@$c_zentral_09 = round($month_values[2]['Avg'] + $c_zentral_08, 1);
	@$c_zentral_10 = round($month_values[1]['Avg'] + $c_zentral_09, 1);
	@$c_zentral_11 = round($month_values[0]['Avg'] + $c_zentral_10, 1);

// Abfrage Monatswerte (Summe pro Monat) der letzten 12 Monate

	@$s_zentral_00 = round($month_values[0]['Avg'], 1);
	@$s_zentral_01 = round($month_values[1]['Avg'], 1);
	@$s_zentral_02 = round($month_values[2]['Avg'], 1);
	@$s_zentral_03 = round($month_values[3]['Avg'], 1);
	@$s_zentral_04 = round($month_values[4]['Avg'], 1);
	@$s_zentral_05 = round($month_values[5]['Avg'], 1);
	@$s_zentral_06 = round($month_values[6]['Avg'], 1);
	@$s_zentral_07 = round($month_values[7]['Avg'], 1);
	@$s_zentral_08 = round($month_values[8]['Avg'], 1);
	@$s_zentral_09 = round($month_values[9]['Avg'], 1);
	@$s_zentral_10 = round($month_values[10]['Avg'], 1);
	@$s_zentral_11 = round($month_values[11]['Avg'], 1);
	
// Abfrage Durchschnittswerte der letzten 12 Monate

	@$d_zentral_00 = round($month_values[0]['Avg']/$M_Anzahl_00, 1);
	@$d_zentral_01 = round($month_values[1]['Avg']/$M_Anzahl_01, 1);
	@$d_zentral_02 = round($month_values[2]['Avg']/$M_Anzahl_02, 1);
	@$d_zentral_03 = round($month_values[3]['Avg']/$M_Anzahl_03, 1);
	@$d_zentral_04 = round($month_values[4]['Avg']/$M_Anzahl_04, 1);
	@$d_zentral_05 = round($month_values[5]['Avg']/$M_Anzahl_05, 1);
	@$d_zentral_06 = round($month_values[6]['Avg']/$M_Anzahl_06, 1);
	@$d_zentral_07 = round($month_values[7]['Avg']/$M_Anzahl_07, 1);
	@$d_zentral_08 = round($month_values[8]['Avg']/$M_Anzahl_08, 1);
	@$d_zentral_09 = round($month_values[9]['Avg']/$M_Anzahl_09, 1);
	@$d_zentral_10 = round($month_values[10]['Avg']/$M_Anzahl_10, 1);
	@$d_zentral_11 = round($month_values[11]['Avg']/$M_Anzahl_11, 1);

// Ermitteln der Spaltenüberschriften (Monate)


// ++++++++++++++++ Table-Factory ++++++++++++++++++++++++++++++++++++++++++++++
// Den Anfang der Tabelle definieren
$content = '<table style="text-align: left; background-color: rgb(32, 49, 67); width: 888px; height: 172px;" border="0" cellpadding="2" cellspacing="2">
				<tbody>';
				
// Die erste Zeile (Überschriften)
$content .= '<tr>
      		<th style="text-align: left;" colspan="2" rowspan="1">Verbrauch in kWh</th>
		      <td style="text-align: center; font-weight: bold;">'.$M_11.'</td>
		      <td style="text-align: center; font-weight: bold;">'.$M_10.'</td>
		      <td style="text-align: center; font-weight: bold;">'.$M_09.'</td>
		      <td style="text-align: center; font-weight: bold;">'.$M_08.'</td>
		      <td style="text-align: center; font-weight: bold;">'.$M_07.'</td>
		      <td style="text-align: center; font-weight: bold;">'.$M_06.'</td>
		      <td style="text-align: center; font-weight: bold;">'.$M_05.'</td>
		      <td style="text-align: center; font-weight: bold;">'.$M_04.'</td>
		      <td style="text-align: center; font-weight: bold;">'.$M_03.'</td>
		      <td style="text-align: center; font-weight: bold;">'.$M_02.'</td>
		      <td style="text-align: center; font-weight: bold;">'.$M_01.'</td>
		      <td style="text-align: center; font-weight: bold;">'.$M_00.'</td>
				</tr>';

// Zeile 3: Zentral, cumulativ Power Consumption
$content .=	'<tr>
			      <td style="background-color: rgb(20, 32, 43); font-weight: bold;" colspan="2" rowspan="1"></small>Zentral</small></td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43); font-weight: bold;"><small>'.$c_zentral_00.'</small></td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43); font-weight: bold;"><small>'.$c_zentral_01.'</small></td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43); font-weight: bold;"><small>'.$c_zentral_02.'</small></td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43); font-weight: bold;"><small>'.$c_zentral_03.'</small></td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43); font-weight: bold;"><small>'.$c_zentral_04.'</small></td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43); font-weight: bold;"><small>'.$c_zentral_05.'</small></td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43); font-weight: bold;"><small>'.$c_zentral_06.'</small></td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43); font-weight: bold;"><small>'.$c_zentral_07.'</small></td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43); font-weight: bold;"><small>'.$c_zentral_08.'</small></td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43); font-weight: bold;"><small>'.$c_zentral_09.'</small></td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43); font-weight: bold;"><small>'.$c_zentral_10.'</small></td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43); font-weight: bold;"><small>'.$c_zentral_11.'</small></td>
			    </tr>';
			    
// Zeile 3: Zentral, Monatsverbrauch
$content .=	'<tr>
			      <td></td>
					<td style="text-align: center; background-color: rgb(13, 23, 36);"><small>Monat</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$s_zentral_11.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$s_zentral_10.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$s_zentral_09.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$s_zentral_08.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$s_zentral_07.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$s_zentral_06.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$s_zentral_05.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$s_zentral_04.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$s_zentral_03.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$s_zentral_02.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$s_zentral_01.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$s_zentral_00.'</small></td>
			    </tr>';
// Zeile 4: Zentral, Tagesdurchschnitt
$content .=	'<tr>
			      <td></td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43);"><small>Ø Tag</td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43);"><small>'.$d_zentral_11.'</small></td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43);"><small>'.$d_zentral_10.'</small></td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43);"><small>'.$d_zentral_09.'</small></td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43);"><small>'.$d_zentral_08.'</small></td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43);"><small>'.$d_zentral_07.'</small></td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43);"><small>'.$d_zentral_06.'</small></td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43);"><small>'.$d_zentral_05.'</small></td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43);"><small>'.$d_zentral_04.'</small></td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43);"><small>'.$d_zentral_03.'</small></td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43);"><small>'.$d_zentral_02.'</small></td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43);"><small>'.$d_zentral_01.'</small></td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43);"><small>'.$d_zentral_00.'</small></td>
			    </tr>';
// Tabellenende
$content .= "</table>";

SetValueString($contend_var_id,$content);
?>

…Danke Raketenschnecke…werd ich auf jeden Fall ausprobieren :smiley:

MfG, kabo63.

es fängt an, Spaß zu machen :smiley:

hier noch 2 Beispiele:

…aufpassen - Suchtgefahr… :wink:

Vielen Dank, kabo63.

Naja von Suchtgefahr merke ich noch nix, mir reicht Excel auf dem Rechner. Vielleicht kann ja noch einer Word und Powerpoint im WFE nachbauen. :stuck_out_tongue:

ne Pivot im WFE nachbauen, das wäre die Krönung! Alles Andere ist doch nur Spielkram:D

Binde doch einfach LibreOffice mit ein :D.

Hallo Raketenschnecke,

Dein Script aus #21 funktioniert einwandfrei…könntest Du noch das Script vom Ersten Deiner Folgebeispiele noch reinstellen? :smiley:
Vielen Dank im voraus, kabo63.

ich hoffe, Du weißt was Du dir damit antust :smiley:


<?

// +++++++++++++++ Konfig ++++++++++++++++++++++++++++++++++++++++++++++++++++++

$object_central_ID = 12130 /*[Smart Metering\IPS EKM-868\EKM-868 I Hausverteilung\EKM-868 #01 Zentraleinspeisung\Energieverbrauch]*/ ; // Variablen-ID der Zähler-Variable
$object_og_ID = 13483 /*[Smart Metering\IPS EKM-868\EKM-868 I Hausverteilung\EKM-868 #02 Licht_Strom oben\Energieverbrauch]*/ ; // Variablen-ID der Zähler-Variable
$object_mg_ID = 21446 /*[Smart Metering\IPS EKM-868\EKM-868 I Hausverteilung\EKM-868 #03 Licht_Stom mitte\Energieverbrauch]*/ ; // Variablen-ID der Zähler-Variable
$object_ug_ID = 33424 /*[Smart Metering\IPS EKM-868\EKM-868 I Hausverteilung\EKM-868 #04 Licht_Strom unten\Energieverbrauch]*/ ; // Variablen-ID der Zähler-Variable
$contend_var_id = 55821 /*[Smart Metering\berechnete Werte\gleitender Durchschnitt\HTML Tabelle Jahresübersicht]*/ ;

// ab hier nichts mehr ändern
$archiveID = IPS_GetInstanceIDByName("Archive Handler", 0);   // Archive-Handler-ID
$timestamp = date("H:i:s d.m.Y");
$year_startdate = mktime(0, 0, 0, date("m")-12, 1, date("Y")); //Startzeit am 1. des Monats vor einem Jahr
$year_enddate = mktime(23, 59, 59, date("m"), date("d")-1, date("Y")); //Endzeit heute
$end_month_format = date("H:i:s d.m.Y",$year_enddate);

// +++++++++++++++ Konfig Ende +++++++++++++++++++++++++++++++++++++++++++++++++

// Ermitteln der Spaltenüberschriften (Monate)
$M_00 = date("M",time());
$M_01 = date("M",mktime(0, 0, 0, date("m")-1, 1, date("Y")));
$M_02 = date("M",mktime(0, 0, 0, date("m")-2, 1, date("Y")));
$M_03 = date("M",mktime(0, 0, 0, date("m")-3, 1, date("Y")));
$M_04 = date("M",mktime(0, 0, 0, date("m")-4, 1, date("Y")));
$M_05 = date("M",mktime(0, 0, 0, date("m")-5, 1, date("Y")));
$M_06 = date("M",mktime(0, 0, 0, date("m")-6, 1, date("Y")));
$M_07 = date("M",mktime(0, 0, 0, date("m")-7, 1, date("Y")));
$M_08 = date("M",mktime(0, 0, 0, date("m")-8, 1, date("Y")));
$M_09 = date("M",mktime(0, 0, 0, date("m")-9, 1, date("Y")));
$M_10 = date("M",mktime(0, 0, 0, date("m")-10, 1, date("Y")));
$M_11 = date("M",mktime(0, 0, 0, date("m")-11, 1, date("Y")));

// Ermitteln der Anzahl Tage pro Monat
$M_Anzahl_00 = date("d")-1;
$M_Anzahl_01 = date("t",mktime(0, 0, 0, date("m")-1, 1, date("Y")));
$M_Anzahl_02 = date("t",mktime(0, 0, 0, date("m")-2, 1, date("Y")));
$M_Anzahl_03 = date("t",mktime(0, 0, 0, date("m")-3, 1, date("Y")));
$M_Anzahl_04 = date("t",mktime(0, 0, 0, date("m")-4, 1, date("Y")));
$M_Anzahl_05 = date("t",mktime(0, 0, 0, date("m")-5, 1, date("Y")));
$M_Anzahl_06 = date("t",mktime(0, 0, 0, date("m")-6, 1, date("Y")));
$M_Anzahl_07 = date("t",mktime(0, 0, 0, date("m")-7, 1, date("Y")));
$M_Anzahl_08 = date("t",mktime(0, 0, 0, date("m")-8, 1, date("Y")));
$M_Anzahl_09 = date("t",mktime(0, 0, 0, date("m")-9, 1, date("Y")));
$M_Anzahl_10 = date("t",mktime(0, 0, 0, date("m")-10, 1, date("Y")));
$M_Anzahl_11 = date("t",mktime(0, 0, 0, date("m")-11, 1, date("Y")));

// central: Abfrage Monatswerte der letzten 12 Monate

$month_values = AC_GetAggregatedValues($archiveID, $object_central_ID, 3, $year_startdate, $year_enddate, 15);
	@$c_central_00 = round($month_values[11]['Avg'], 1);
	@$c_central_01 = round($month_values[10]['Avg'] + $c_central_00, 1);
	@$c_central_02 = round($month_values[9]['Avg'] + $c_central_01, 1);
	@$c_central_03 = round($month_values[8]['Avg'] + $c_central_02, 1);
	@$c_central_04 = round($month_values[7]['Avg'] + $c_central_03, 1);
	@$c_central_05 = round($month_values[6]['Avg'] + $c_central_04, 1);
	@$c_central_06 = round($month_values[5]['Avg'] + $c_central_05, 1);
	@$c_central_07 = round($month_values[4]['Avg'] + $c_central_06, 1);
	@$c_central_08 = round($month_values[3]['Avg'] + $c_central_07, 1);
	@$c_central_09 = round($month_values[2]['Avg'] + $c_central_08, 1);
	@$c_central_10 = round($month_values[1]['Avg'] + $c_central_09, 1);
	@$c_central_11 = round($month_values[0]['Avg'] + $c_central_10, 1);

// central: Abfrage Monatswerte (Summe pro Monat) der letzten 12 Monate

	@$s_central_00 = round($month_values[0]['Avg'], 1);
	@$s_central_01 = round($month_values[1]['Avg'], 1);
	@$s_central_02 = round($month_values[2]['Avg'], 1);
	@$s_central_03 = round($month_values[3]['Avg'], 1);
	@$s_central_04 = round($month_values[4]['Avg'], 1);
	@$s_central_05 = round($month_values[5]['Avg'], 1);
	@$s_central_06 = round($month_values[6]['Avg'], 1);
	@$s_central_07 = round($month_values[7]['Avg'], 1);
	@$s_central_08 = round($month_values[8]['Avg'], 1);
	@$s_central_09 = round($month_values[9]['Avg'], 1);
	@$s_central_10 = round($month_values[10]['Avg'], 1);
	@$s_central_11 = round($month_values[11]['Avg'], 1);

// central: Abfrage Durchschnittswerte der letzten 12 Monate

	@$d_central_00 = round($month_values[0]['Avg']/$M_Anzahl_00, 1);
	@$d_central_01 = round($month_values[1]['Avg']/$M_Anzahl_01, 1);
	@$d_central_02 = round($month_values[2]['Avg']/$M_Anzahl_02, 1);
	@$d_central_03 = round($month_values[3]['Avg']/$M_Anzahl_03, 1);
	@$d_central_04 = round($month_values[4]['Avg']/$M_Anzahl_04, 1);
	@$d_central_05 = round($month_values[5]['Avg']/$M_Anzahl_05, 1);
	@$d_central_06 = round($month_values[6]['Avg']/$M_Anzahl_06, 1);
	@$d_central_07 = round($month_values[7]['Avg']/$M_Anzahl_07, 1);
	@$d_central_08 = round($month_values[8]['Avg']/$M_Anzahl_08, 1);
	@$d_central_09 = round($month_values[9]['Avg']/$M_Anzahl_09, 1);
	@$d_central_10 = round($month_values[10]['Avg']/$M_Anzahl_10, 1);
	@$d_central_11 = round($month_values[11]['Avg']/$M_Anzahl_11, 1);

// OG: Abfrage Monatswerte der letzten 12 Monate

$month_values = AC_GetAggregatedValues($archiveID, $object_og_ID, 3, $year_startdate, $year_enddate, 15);
	@$c_og_00 = round($month_values[11]['Avg'], 1);
	@$c_og_01 = round($month_values[10]['Avg'] + $c_og_00, 1);
	@$c_og_02 = round($month_values[9]['Avg'] + $c_og_01, 1);
	@$c_og_03 = round($month_values[8]['Avg'] + $c_og_02, 1);
	@$c_og_04 = round($month_values[7]['Avg'] + $c_og_03, 1);
	@$c_og_05 = round($month_values[6]['Avg'] + $c_og_04, 1);
	@$c_og_06 = round($month_values[5]['Avg'] + $c_og_05, 1);
	@$c_og_07 = round($month_values[4]['Avg'] + $c_og_06, 1);
	@$c_og_08 = round($month_values[3]['Avg'] + $c_og_07, 1);
	@$c_og_09 = round($month_values[2]['Avg'] + $c_og_08, 1);
	@$c_og_10 = round($month_values[1]['Avg'] + $c_og_09, 1);
	@$c_og_11 = round($month_values[0]['Avg'] + $c_og_10, 1);

// OG: Abfrage Monatswerte (Summe pro Monat) der letzten 12 Monate

	@$s_og_00 = round($month_values[0]['Avg'], 1);
	@$s_og_01 = round($month_values[1]['Avg'], 1);
	@$s_og_02 = round($month_values[2]['Avg'], 1);
	@$s_og_03 = round($month_values[3]['Avg'], 1);
	@$s_og_04 = round($month_values[4]['Avg'], 1);
	@$s_og_05 = round($month_values[5]['Avg'], 1);
	@$s_og_06 = round($month_values[6]['Avg'], 1);
	@$s_og_07 = round($month_values[7]['Avg'], 1);
	@$s_og_08 = round($month_values[8]['Avg'], 1);
	@$s_og_09 = round($month_values[9]['Avg'], 1);
	@$s_og_10 = round($month_values[10]['Avg'], 1);
	@$s_og_11 = round($month_values[11]['Avg'], 1);

// OG: Abfrage Durchschnittswerte der letzten 12 Monate

	@$d_og_00 = round($month_values[0]['Avg']/$M_Anzahl_00, 1);
	@$d_og_01 = round($month_values[1]['Avg']/$M_Anzahl_01, 1);
	@$d_og_02 = round($month_values[2]['Avg']/$M_Anzahl_02, 1);
	@$d_og_03 = round($month_values[3]['Avg']/$M_Anzahl_03, 1);
	@$d_og_04 = round($month_values[4]['Avg']/$M_Anzahl_04, 1);
	@$d_og_05 = round($month_values[5]['Avg']/$M_Anzahl_05, 1);
	@$d_og_06 = round($month_values[6]['Avg']/$M_Anzahl_06, 1);
	@$d_og_07 = round($month_values[7]['Avg']/$M_Anzahl_07, 1);
	@$d_og_08 = round($month_values[8]['Avg']/$M_Anzahl_08, 1);
	@$d_og_09 = round($month_values[9]['Avg']/$M_Anzahl_09, 1);
	@$d_og_10 = round($month_values[10]['Avg']/$M_Anzahl_10, 1);
	@$d_og_11 = round($month_values[11]['Avg']/$M_Anzahl_11, 1);

// MG: Abfrage Monatswerte der letzten 12 Monate

$month_values = AC_GetAggregatedValues($archiveID, $object_mg_ID, 3, $year_startdate, $year_enddate, 15);
	@$c_mg_00 = round($month_values[11]['Avg'], 1);
	@$c_mg_01 = round($month_values[10]['Avg'] + $c_mg_00, 1);
	@$c_mg_02 = round($month_values[9]['Avg'] + $c_mg_01, 1);
	@$c_mg_03 = round($month_values[8]['Avg'] + $c_mg_02, 1);
	@$c_mg_04 = round($month_values[7]['Avg'] + $c_mg_03, 1);
	@$c_mg_05 = round($month_values[6]['Avg'] + $c_mg_04, 1);
	@$c_mg_06 = round($month_values[5]['Avg'] + $c_mg_05, 1);
	@$c_mg_07 = round($month_values[4]['Avg'] + $c_mg_06, 1);
	@$c_mg_08 = round($month_values[3]['Avg'] + $c_mg_07, 1);
	@$c_mg_09 = round($month_values[2]['Avg'] + $c_mg_08, 1);
	@$c_mg_10 = round($month_values[1]['Avg'] + $c_mg_09, 1);
	@$c_mg_11 = round($month_values[0]['Avg'] + $c_mg_10, 1);

// MG: Abfrage Monatswerte (Summe pro Monat) der letzten 12 Monate

	@$s_mg_00 = round($month_values[0]['Avg'], 1);
	@$s_mg_01 = round($month_values[1]['Avg'], 1);
	@$s_mg_02 = round($month_values[2]['Avg'], 1);
	@$s_mg_03 = round($month_values[3]['Avg'], 1);
	@$s_mg_04 = round($month_values[4]['Avg'], 1);
	@$s_mg_05 = round($month_values[5]['Avg'], 1);
	@$s_mg_06 = round($month_values[6]['Avg'], 1);
	@$s_mg_07 = round($month_values[7]['Avg'], 1);
	@$s_mg_08 = round($month_values[8]['Avg'], 1);
	@$s_mg_09 = round($month_values[9]['Avg'], 1);
	@$s_mg_10 = round($month_values[10]['Avg'], 1);
	@$s_mg_11 = round($month_values[11]['Avg'], 1);

// MG: Abfrage Durchschnittswerte der letzten 12 Monate

	@$d_mg_00 = round($month_values[0]['Avg']/$M_Anzahl_00, 1);
	@$d_mg_01 = round($month_values[1]['Avg']/$M_Anzahl_01, 1);
	@$d_mg_02 = round($month_values[2]['Avg']/$M_Anzahl_02, 1);
	@$d_mg_03 = round($month_values[3]['Avg']/$M_Anzahl_03, 1);
	@$d_mg_04 = round($month_values[4]['Avg']/$M_Anzahl_04, 1);
	@$d_mg_05 = round($month_values[5]['Avg']/$M_Anzahl_05, 1);
	@$d_mg_06 = round($month_values[6]['Avg']/$M_Anzahl_06, 1);
	@$d_mg_07 = round($month_values[7]['Avg']/$M_Anzahl_07, 1);
	@$d_mg_08 = round($month_values[8]['Avg']/$M_Anzahl_08, 1);
	@$d_mg_09 = round($month_values[9]['Avg']/$M_Anzahl_09, 1);
	@$d_mg_10 = round($month_values[10]['Avg']/$M_Anzahl_10, 1);
	@$d_mg_11 = round($month_values[11]['Avg']/$M_Anzahl_11, 1);
	
	// UG: Abfrage Monatswerte der letzten 12 Monate

$month_values = AC_GetAggregatedValues($archiveID, $object_ug_ID, 3, $year_startdate, $year_enddate, 15);
	@$c_ug_00 = round($month_values[11]['Avg'], 1);
	@$c_ug_01 = round($month_values[10]['Avg'] + $c_ug_00, 1);
	@$c_ug_02 = round($month_values[9]['Avg'] + $c_ug_01, 1);
	@$c_ug_03 = round($month_values[8]['Avg'] + $c_ug_02, 1);
	@$c_ug_04 = round($month_values[7]['Avg'] + $c_ug_03, 1);
	@$c_ug_05 = round($month_values[6]['Avg'] + $c_ug_04, 1);
	@$c_ug_06 = round($month_values[5]['Avg'] + $c_ug_05, 1);
	@$c_ug_07 = round($month_values[4]['Avg'] + $c_ug_06, 1);
	@$c_ug_08 = round($month_values[3]['Avg'] + $c_ug_07, 1);
	@$c_ug_09 = round($month_values[2]['Avg'] + $c_ug_08, 1);
	@$c_ug_10 = round($month_values[1]['Avg'] + $c_ug_09, 1);
	@$c_ug_11 = round($month_values[0]['Avg'] + $c_ug_10, 1);

// UG: Abfrage Monatswerte (Summe pro Monat) der letzten 12 Monate

	@$s_ug_00 = round($month_values[0]['Avg'], 1);
	@$s_ug_01 = round($month_values[1]['Avg'], 1);
	@$s_ug_02 = round($month_values[2]['Avg'], 1);
	@$s_ug_03 = round($month_values[3]['Avg'], 1);
	@$s_ug_04 = round($month_values[4]['Avg'], 1);
	@$s_ug_05 = round($month_values[5]['Avg'], 1);
	@$s_ug_06 = round($month_values[6]['Avg'], 1);
	@$s_ug_07 = round($month_values[7]['Avg'], 1);
	@$s_ug_08 = round($month_values[8]['Avg'], 1);
	@$s_ug_09 = round($month_values[9]['Avg'], 1);
	@$s_ug_10 = round($month_values[10]['Avg'], 1);
	@$s_ug_11 = round($month_values[11]['Avg'], 1);

// UG: Abfrage Durchschnittswerte der letzten 12 Monate

	@$d_ug_00 = round($month_values[0]['Avg']/$M_Anzahl_00, 1);
	@$d_ug_01 = round($month_values[1]['Avg']/$M_Anzahl_01, 1);
	@$d_ug_02 = round($month_values[2]['Avg']/$M_Anzahl_02, 1);
	@$d_ug_03 = round($month_values[3]['Avg']/$M_Anzahl_03, 1);
	@$d_ug_04 = round($month_values[4]['Avg']/$M_Anzahl_04, 1);
	@$d_ug_05 = round($month_values[5]['Avg']/$M_Anzahl_05, 1);
	@$d_ug_06 = round($month_values[6]['Avg']/$M_Anzahl_06, 1);
	@$d_ug_07 = round($month_values[7]['Avg']/$M_Anzahl_07, 1);
	@$d_ug_08 = round($month_values[8]['Avg']/$M_Anzahl_08, 1);
	@$d_ug_09 = round($month_values[9]['Avg']/$M_Anzahl_09, 1);
	@$d_ug_10 = round($month_values[10]['Avg']/$M_Anzahl_10, 1);
	@$d_ug_11 = round($month_values[11]['Avg']/$M_Anzahl_11, 1);

// ++++++++++++++++ Table-Factory ++++++++++++++++++++++++++++++++++++++++++++++
// Den Anfang der Tabelle definieren
$content = '<table style="text-align: left; background-color: rgb(32, 49, 67);" border="0" cellpadding="4" cellspacing="1">
				<tbody>';
				
// Die erste Zeile (Überschriften)
$content .= '<tr>
      		<th style="text-align: left;" colspan="2" rowspan="1">Verbrauch in kWh<br><small><small><span style="font-weight: normal;">'.$timestamp.'</span></small></small></th>
		      <td style="text-align: center; font-weight: bold;">'.$M_11.'</td>
		      <td style="text-align: center; font-weight: bold;">'.$M_10.'</td>
		      <td style="text-align: center; font-weight: bold;">'.$M_09.'</td>
		      <td style="text-align: center; font-weight: bold;">'.$M_08.'</td>
		      <td style="text-align: center; font-weight: bold;">'.$M_07.'</td>
		      <td style="text-align: center; font-weight: bold;">'.$M_06.'</td>
		      <td style="text-align: center; font-weight: bold;">'.$M_05.'</td>
		      <td style="text-align: center; font-weight: bold;">'.$M_04.'</td>
		      <td style="text-align: center; font-weight: bold;">'.$M_03.'</td>
		      <td style="text-align: center; font-weight: bold;">'.$M_02.'</td>
		      <td style="text-align: center; font-weight: bold;">'.$M_01.'</td>
		      <td style="text-align: center; font-weight: bold;">'.$M_00.'</td>
				</tr>';

// Zeile 3: central, cumulativ Power Consumption
$content .=	'<tr>
			      <td style="background-color: rgb(20, 32, 43); font-weight: bold;" colspan="2" rowspan="1">Gesamt</td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43); font-weight: bold;">'.$c_central_00.'</td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43); font-weight: bold;">'.$c_central_01.'</td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43); font-weight: bold;">'.$c_central_02.'</td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43); font-weight: bold;">'.$c_central_03.'</td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43); font-weight: bold;">'.$c_central_04.'</td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43); font-weight: bold;">'.$c_central_05.'</td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43); font-weight: bold;">'.$c_central_06.'</td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43); font-weight: bold;">'.$c_central_07.'</td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43); font-weight: bold;">'.$c_central_08.'</td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43); font-weight: bold;">'.$c_central_09.'</td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43); font-weight: bold;">'.$c_central_10.'</td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43); font-weight: bold;">'.$c_central_11.'</td>
			    </tr>';

// Zeile 3: central, Monatsverbrauch
$content .=	'<tr>
			      <td></td>
					<td style="text-align: center; background-color: rgb(13, 23, 36);">Monat</td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);">'.$s_central_11.'</td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);">'.$s_central_10.'</td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);">'.$s_central_09.'</td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);">'.$s_central_08.'</td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);">'.$s_central_07.'</td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);">'.$s_central_06.'</td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);">'.$s_central_05.'</td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);">'.$s_central_04.'</td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);">'.$s_central_03.'</td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);">'.$s_central_02.'</td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);">'.$s_central_01.'</td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);">'.$s_central_00.'</td>
			    </tr>';
// Zeile 4: central, Tagesdurchschnitt
$content .=	'<tr>
			      <td></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);">Ø Tag</td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);">'.$d_central_11.'</td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);">'.$d_central_10.'</td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);">'.$d_central_09.'</td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);">'.$d_central_08.'</td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);">'.$d_central_07.'</td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);">'.$d_central_06.'</td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);">'.$d_central_05.'</td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);">'.$d_central_04.'</td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);">'.$d_central_03.'</td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);">'.$d_central_02.'</td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);">'.$d_central_01.'</td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);">'.$d_central_00.'</td>
			    </tr>';

// Zeile 5: OG, cumulativ Power Consumption
$content .=	'<tr>
			      <td style="background-color: rgb(20, 32, 43); font-weight: bold;" colspan="2" rowspan="1"></small>OG</small></td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43); font-weight: bold;"><small>'.$c_og_00.'</small></td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43); font-weight: bold;"><small>'.$c_og_01.'</small></td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43); font-weight: bold;"><small>'.$c_og_02.'</small></td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43); font-weight: bold;"><small>'.$c_og_03.'</small></td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43); font-weight: bold;"><small>'.$c_og_04.'</small></td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43); font-weight: bold;"><small>'.$c_og_05.'</small></td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43); font-weight: bold;"><small>'.$c_og_06.'</small></td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43); font-weight: bold;"><small>'.$c_og_07.'</small></td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43); font-weight: bold;"><small>'.$c_og_08.'</small></td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43); font-weight: bold;"><small>'.$c_og_09.'</small></td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43); font-weight: bold;"><small>'.$c_og_10.'</small></td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43); font-weight: bold;"><small>'.$c_og_11.'</small></td>
			    </tr>';

// Zeile 6: OG, Monatsverbrauch
$content .=	'<tr>
			      <td></td>
					<td style="text-align: center; background-color: rgb(13, 23, 36);"><small>Monat</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$s_og_11.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$s_og_10.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$s_og_09.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$s_og_08.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$s_og_07.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$s_og_06.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$s_og_05.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$s_og_04.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$s_og_03.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$s_og_02.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$s_og_01.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$s_og_00.'</small></td>
			    </tr>';
// Zeile 7: OG Tagesdurchschnitt
$content .=	'<tr>
			      <td></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>Ø Tag</td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$d_og_11.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$d_og_10.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$d_og_09.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$d_og_08.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$d_og_07.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$d_og_06.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$d_og_05.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$d_og_04.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$d_og_03.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$d_og_02.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$d_og_01.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$d_og_00.'</small></td>
			    </tr>';
			    
// Zeile 8: MG, cumulativ Power Consumption
$content .=	'<tr>
			      <td style="background-color: rgb(20, 32, 43); font-weight: bold;" colspan="2" rowspan="1"></small>MG</small></td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43); font-weight: bold;"><small>'.$c_mg_00.'</small></td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43); font-weight: bold;"><small>'.$c_mg_01.'</small></td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43); font-weight: bold;"><small>'.$c_mg_02.'</small></td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43); font-weight: bold;"><small>'.$c_mg_03.'</small></td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43); font-weight: bold;"><small>'.$c_mg_04.'</small></td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43); font-weight: bold;"><small>'.$c_mg_05.'</small></td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43); font-weight: bold;"><small>'.$c_mg_06.'</small></td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43); font-weight: bold;"><small>'.$c_mg_07.'</small></td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43); font-weight: bold;"><small>'.$c_mg_08.'</small></td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43); font-weight: bold;"><small>'.$c_mg_09.'</small></td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43); font-weight: bold;"><small>'.$c_mg_10.'</small></td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43); font-weight: bold;"><small>'.$c_mg_11.'</small></td>
			    </tr>';

// Zeile 9: MG, Monatsverbrauch
$content .=	'<tr>
			      <td></td>
					<td style="text-align: center; background-color: rgb(13, 23, 36);"><small>Monat</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$s_mg_11.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$s_mg_10.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$s_mg_09.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$s_mg_08.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$s_mg_07.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$s_mg_06.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$s_mg_05.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$s_mg_04.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$s_mg_03.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$s_mg_02.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$s_mg_01.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$s_mg_00.'</small></td>
			    </tr>';
// Zeile 9: MG Tagesdurchschnitt
$content .=	'<tr>
			      <td></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>Ø Tag</td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$d_mg_11.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$d_mg_10.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$d_mg_09.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$d_mg_08.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$d_mg_07.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$d_mg_06.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$d_mg_05.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$d_mg_04.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$d_mg_03.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$d_mg_02.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$d_mg_01.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$d_mg_00.'</small></td>
			    </tr>';
			    
// Zeile 10: UG, cumulativ Power Consumption
$content .=	'<tr>
			      <td style="background-color: rgb(20, 32, 43); font-weight: bold;" colspan="2" rowspan="1"></small>UG</small></td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43); font-weight: bold;"><small>'.$c_ug_00.'</small></td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43); font-weight: bold;"><small>'.$c_ug_01.'</small></td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43); font-weight: bold;"><small>'.$c_ug_02.'</small></td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43); font-weight: bold;"><small>'.$c_ug_03.'</small></td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43); font-weight: bold;"><small>'.$c_ug_04.'</small></td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43); font-weight: bold;"><small>'.$c_ug_05.'</small></td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43); font-weight: bold;"><small>'.$c_ug_06.'</small></td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43); font-weight: bold;"><small>'.$c_ug_07.'</small></td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43); font-weight: bold;"><small>'.$c_ug_08.'</small></td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43); font-weight: bold;"><small>'.$c_ug_09.'</small></td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43); font-weight: bold;"><small>'.$c_ug_10.'</small></td>
			      <td style="text-align: center; background-color: rgb(20, 32, 43); font-weight: bold;"><small>'.$c_ug_11.'</small></td>
			    </tr>';

// Zeile 11: UG, Monatsverbrauch
$content .=	'<tr>
			      <td></td>
					<td style="text-align: center; background-color: rgb(13, 23, 36);"><small>Monat</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$s_ug_11.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$s_ug_10.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$s_ug_09.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$s_ug_08.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$s_ug_07.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$s_ug_06.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$s_ug_05.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$s_ug_04.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$s_ug_03.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$s_ug_02.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$s_ug_01.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$s_ug_00.'</small></td>
			    </tr>';
// Zeile 12: UG Tagesdurchschnitt
$content .=	'<tr>
			      <td></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>Ø Tag</td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$d_ug_11.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$d_ug_10.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$d_ug_09.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$d_ug_08.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$d_ug_07.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$d_ug_06.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$d_ug_05.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$d_ug_04.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$d_ug_03.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$d_ug_02.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$d_ug_01.'</small></td>
			      <td style="text-align: center; background-color: rgb(13, 23, 36);"><small>'.$d_ug_00.'</small></td>
			    </tr>';
			    
// Tabellenende
$content .= "</table>";

SetValueString($contend_var_id,$content);
?>

…yupp…und ich weiß genau, was Du meinst :rolleyes:

Vielen Dank und schönen Abend noch, kabo63.

Hallo,
ich wollte noch kurz das Ergebnis der Tabellendarstellung für einige wichtige Leistungsparameter(Realdaten) meiner WP kurz vorstellen und mich auf diesem Wege auch bei allen Beteiligten für die tolle Unterstützung bedanken.
MfG, kabo63. :loveips:

Bis auf die Farbwahl schaut das doch richtig gut aus. Prima.

Hallo Kabo,

würdest Du Dein Script zur Tabellenkonfig mal posten? Darüber hinaus bin ich sehr neugierig, wie du die Kompressorstarts oder ev. auch die Abtauvorgänge ermittelst.

Neugierige Grüße, Stromer

Hallo Stromer,
öhm, das ist nicht wirklich ein Script…eher eine formatierte Werteausgabe - erwarte also nicht allzuviel…und die Kompressorstarts ermittle ich über die Daten aus meiner Wärmepumpe und einer Adaption von steiners Script zum „Smart Metering“ - also recht easy…Da ich eine Sole-WP habe benötige ich keine Abtauung.

„Script“ Leistungskennziffern:

//Variablen Gesamt
$GA1 = sprintf("%4.2f",GetValue(53752 /*[Heizraum\WP Stromzähler\Stromverbrauch Wärmepumpe gesamt\Arbeitszahlen\1AZ_Gesamt Tag]*/));
$GA2 = sprintf("%4.2f",GetValue(49198 /*[Heizraum\WP Stromzähler\Stromverbrauch Wärmepumpe gesamt\Arbeitszahlen\2AZ_Gesamt Woche]*/));
$GA3 = sprintf("%4.2f",GetValue(45604 /*[Heizraum\WP Stromzähler\Stromverbrauch Wärmepumpe gesamt\Arbeitszahlen\3AZ_Gesamt Monat]*/));
$GA4 = sprintf("%4.2f",GetValue(58938 /*[Heizraum\WP Stromzähler\Stromverbrauch Wärmepumpe gesamt\Arbeitszahlen\4AZ_Gesamt Jahr]*/));
$GB1 = GetValue(48232 /*[Heizraum\Wärmepumpe\Einschaltzyklen\Gesamt\1SZ Tag]*/);
$GB2 = GetValue(50093 /*[Heizraum\Wärmepumpe\Einschaltzyklen\Gesamt\2SZ Woche]*/);
$GB3 = GetValue(53908 /*[Heizraum\Wärmepumpe\Einschaltzyklen\Gesamt\3SZ_Monat]*/);
$GB4 = GetValue(50147 /*[Heizraum\Wärmepumpe\Einschaltzyklen\Gesamt\4SZ_Jahr]*/);
$GC1 = sprintf("%4.2f kwh",GetValue(22635 /*[Heizraum\WMZ WP gesamt\erzeugte Wärmemengen gesamt\1Wärmemenge Tag]*/));
$GC2 = sprintf("%4.2f kwh",GetValue(49042 /*[Heizraum\WMZ WP gesamt\erzeugte Wärmemengen gesamt\2Wärmemenge Woche]*/));
$GC3 = sprintf("%4.2f kwh",GetValue(37233 /*[Heizraum\WMZ WP gesamt\erzeugte Wärmemengen gesamt\3Wärmemenge Monat]*/));
$GC4 = sprintf("%4.2f kwh",GetValue(48737 /*[Heizraum\WMZ WP gesamt\erzeugte Wärmemengen gesamt\4Wärmemenge Jahr]*/));
$GD1 = sprintf("%4.2f kwh",GetValue(58714 /*[Heizraum\WP Stromzähler\Stromverbrauch Wärmepumpe gesamt\1Verbrauch Tag]*/));
$GD2 = sprintf("%4.2f kwh",GetValue(59415 /*[Heizraum\WP Stromzähler\Stromverbrauch Wärmepumpe gesamt\2Verbrauch Woche]*/));
$GD3 = sprintf("%4.2f kwh",GetValue(49877 /*[Heizraum\WP Stromzähler\Stromverbrauch Wärmepumpe gesamt\3Verbrauch Monat]*/));
$GD4 = sprintf("%4.2f kwh",GetValue(33805 /*[Heizraum\WP Stromzähler\Stromverbrauch Wärmepumpe gesamt\4Verbrauch Jahr]*/));
$GE1 = sprintf("%4.2f €",GetValue(51637 /*[Heizraum\WP Stromzähler\Stromverbrauch Wärmepumpe gesamt\_1Kosten Tag]*/));
$GE2 = sprintf("%4.2f €",GetValue(48971 /*[Heizraum\WP Stromzähler\Stromverbrauch Wärmepumpe gesamt\_2Kosten Woche]*/));
$GE3 = sprintf("%4.2f €",GetValue(24727 /*[Heizraum\WP Stromzähler\Stromverbrauch Wärmepumpe gesamt\_3Kosten Monat]*/));
$GE4 = sprintf("%4.2f €",GetValue(25700 /*[Heizraum\WP Stromzähler\Stromverbrauch Wärmepumpe gesamt\_4Kosten Jahr]*/));

//Variablen Heizen
$HA1 = sprintf("%4.2f",GetValue(43185 /*[Heizraum\Wärmepumpe\WP Arbeitszahlen\AZ heizen\1AZ_Heizen Tag]*/));
$HA2 = sprintf("%4.2f",GetValue(19086 /*[Heizraum\Wärmepumpe\WP Arbeitszahlen\AZ heizen\2AZ_Heizen Woche]*/));
$HA3 = sprintf("%4.2f",GetValue(46744 /*[Heizraum\Wärmepumpe\WP Arbeitszahlen\AZ heizen\3AZ_Heizen Monat]*/));
$HA4 = sprintf("%4.2f",GetValue(20960 /*[Heizraum\Wärmepumpe\WP Arbeitszahlen\AZ heizen\4AZ_Heizen Jahr]*/));
$HB1 = GetValue(44592 /*[Heizraum\Wärmepumpe\Einschaltzyklen\Heizen\1SZ Tag]*/);
$HB2 = GetValue(41292 /*[Heizraum\Wärmepumpe\Einschaltzyklen\Heizen\2SZ Woche]*/);
$HB3 = GetValue(13561 /*[Heizraum\Wärmepumpe\Einschaltzyklen\Heizen\3SZ Monat]*/);
$HB4 = GetValue(19221 /*[Heizraum\Wärmepumpe\Einschaltzyklen\Heizen\4SZ Jahr]*/);
$HC1 = sprintf("%4.2f kwh",GetValue(20159 /*[Heizraum\WMZ WP Heizung\erzeugte Wärmemengen Heizen\1Wärmemenge Tag]*/));
$HC2 = sprintf("%4.2f kwh",GetValue(14651 /*[Heizraum\WMZ WP Heizung\erzeugte Wärmemengen Heizen\2Wärmemenge Woche]*/));
$HC3 = sprintf("%4.2f kwh",GetValue(28745 /*[Heizraum\WMZ WP Heizung\erzeugte Wärmemengen Heizen\3Wärmemenge Monat]*/));
$HC4 = sprintf("%4.2f kwh",GetValue(34265 /*[Heizraum\WMZ WP Heizung\erzeugte Wärmemengen Heizen\4Wärmemenge Jahr]*/));
$HD1 = sprintf("%4.2f kwh",GetValue(48149 /*[Heizraum\WP Stromzähler\Stromverbrauch Wärmepumpe Heizen\Strom heizen\1Strom Tag]*/));
$HD2 = sprintf("%4.2f kwh",GetValue(37808 /*[Heizraum\WP Stromzähler\Stromverbrauch Wärmepumpe Heizen\Strom heizen\2Strom Woche]*/));
$HD3 = sprintf("%4.2f kwh",GetValue(54625 /*[Heizraum\WP Stromzähler\Stromverbrauch Wärmepumpe Heizen\Strom heizen\3Strom Monat]*/));
$HD4 = sprintf("%4.2f kwh",GetValue(47996 /*[Heizraum\WP Stromzähler\Stromverbrauch Wärmepumpe Heizen\Strom heizen\4Strom Jahr]*/));
$HE1 = sprintf("%4.2f €",GetValue(50538 /*[Heizraum\WP Stromzähler\Stromverbrauch Wärmepumpe Heizen\Strom heizen\_1Kosten Tag]*/));
$HE2 = sprintf("%4.2f €",GetValue(16291 /*[Heizraum\WP Stromzähler\Stromverbrauch Wärmepumpe Heizen\Strom heizen\_2Kosten Woche]*/));
$HE3 = sprintf("%4.2f €",GetValue(34150 /*[Heizraum\WP Stromzähler\Stromverbrauch Wärmepumpe Heizen\Strom heizen\_3Kosten Monat]*/));
$HE4 = sprintf("%4.2f €",GetValue(33361 /*[Heizraum\WP Stromzähler\Stromverbrauch Wärmepumpe Heizen\Strom heizen\_4Kosten Jahr]*/));

$content  = '<style type="text/css">table.stundenplan { width: 100%; border-collapse: true; } table.stundenplan td { border: 3px solid #444455; }</style>';
$content .= '<table class="stundenplan">';
$content .= '<tr><td style="border: 0 none;"> </td><td style="background: #774477;" colspan="5"><div align="center">WP-Kennziffern gesamt</td></tr>';
$content .= '<tr><td><div align="center">Zeitraum</td><td><div align="center">Arbeitszahl gesamt</div></td><td><div align="center">Kompressorstarts gesamt</td><td><div align="center">Wärmemenge gesamt</td><td><div align="center">Stromverbrauch gesamt</td><td><div align="center">Kosten gesamt</td></tr>';
$content .= '<tr><td>Tag</td><td><div align="center">'.$GA1.'</td><td><div align="center">'.$GB1.'<td><div align="center">'.$GC1.'</td><td><div align="center">'.$GD1.'</td><td><div align="center">'.$GE1.'</td></tr>';
$content .= '<tr><td>Woche</td><td><div align="center">'.$GA2.'</td><td><div align="center">'.$GB2.'</td><td><div align="center">'.$GC2.'</td><td><div align="center">'.$GD2.'</td><td><div align="center">'.$GE2.'</td></tr>';
$content .= '<tr><td>Monat</td><td><div align="center">'.$GA3.'</td><td><div align="center">'.$GB3.'</td><td><div align="center">'.$GC3.'</td><td><div align="center">'.$GD3.'</td><td><div align="center">'.$GE3.'</td></tr>';
$content .= '<tr><td>Jahr</td><td><div align="center">'.$GA4.'</td><td><div align="center">'.$GB4.'</td><td><div align="center">'.$GC4.'</td><td><div align="center">'.$GD4.'</td><td><div align="center">'.$GE4.'</td></tr>';
$content .= '<tr><td style="border: 0 none;"> </td><td style="background: #8B1A1A;" colspan="5"><div align="center">WP-Kennziffern Heizen</td></tr>';
$content .= '<tr><td><div align="center">Zeitraum</td><td><div align="center">Arbeitszahl heizen</div></td><td><div align="center">Kompressorstarts heizen</td><td><div align="center">Wärmemenge heizen</td><td><div align="center">Stromverbrauch heizen</td><td><div align="center">Kosten heizen</td></tr>';
$content .= '<tr><td>Tag</td><td><div align="center">'.$HA1.'</td><td><div align="center">'.$HB1.'<td><div align="center">'.$HC1.'</td><td><div align="center">'.$HD1.'</td><td><div align="center">'.$HE1.'</td></tr>';
$content .= '<tr><td>Woche</td><td><div align="center">'.$HA2.'</td><td><div align="center">'.$HB2.'</td><td><div align="center">'.$HC2.'</td><td><div align="center">'.$HD2.'</td><td><div align="center">'.$HE2.'</td></tr>';
$content .= '<tr><td>Monat</td><td><div align="center">'.$HA3.'</td><td><div align="center">'.$HB3.'</td><td><div align="center">'.$HC3.'</td><td><div align="center">'.$HD3.'</td><td><div align="center">'.$HE3.'</td></tr>';
$content .= '<tr><td>Jahr</td><td><div align="center">'.$HA4.'</td><td><div align="center">'.$HB4.'</td><td><div align="center">'.$HC4.'</td><td><div align="center">'.$HD4.'</td><td><div align="center">'.$HE4.'</td></tr>';
$content .= '</table>';

SetValueString(23602 /*[WP Tabelle2\Übersichtstabelle Leistungkennziffern Wärmepumpe ]*/, $content);

Gruß, kabo63.

Hallo zusammen,

habe in meine Tabellen eine Ampeldarstellung der Werte eingebaut.
So sieht man auf einen Blick, ob die Verbrauchswerte innerhalb der Prognose sind.

Gasverbrauch wird anhand der Gradtagszahlen, Strom anhand des durchschnittlichen Verbrauchsverlaufes einen Haushaltes prognostiziert.

Wert gleich oder kleiner Prognose -> grün
Wert größer als Prognose und Abweichung kleiner 10% -> gelb
Wert größer als Prognose und Abweichung größer 10% -> rot


<?
$debug = true;
// +++++++++++++++ Konfig ++++++++++++++++++++++++++++++++++++++++++++++++++++++

$objectID = 35459 /*[Verbrauch\Strom\PV  / Verbrauch\ZZ E-on]*/; // Variablen-ID der Zähler-Variable
$contend_var_id = 22631 /*[Verbrauch\Strom - Tabelle - in Arbeit]*/;

// Hintergrundfarben definieren
define( "rot","rgb(178,34,34)");
define( "gelb","rgb(255,139,37)");
define( "grün","rgb(0,139,0)");
define( "Standard", "rgb(20, 32, 43)");

// Schwelle für gelben Hintergrund
define( "Schwelle", 1.1);

// Durchschnittsstromverbrauch
define("Verbrauch",6500);

// Suffix
define( "Suffix", "kWh");


// ab hier nichts mehr ändern
$archiveID = IPS_GetInstanceIDByName("Archive Handler", 0);   // Archive-Handler-ID
$verbrauch_akt = getvalue($objectID);

$year_startdate = mktime(0, 0, 0, 1, 1, date("Y")); //Startzeit am 1. des Monats vor einem Jahr
$year_enddate = mktime(0, 0, 0, 12, 31, date("Y"));  //Endzeit heute

$end_month_format = date("H:i:s d.m.Y",$year_enddate);

// +++++++++++++++ Konfig Ende +++++++++++++++++++++++++++++++++++++++++++++++++

// Spaltenüberschriften
$M_0 = "Jan";
$M_1 = "Feb";
$M_2 = "Mär";
$M_3 = "Apr";
$M_4 = "Mai";
$M_5 = "Jun";
$M_6 = "Jul";
$M_7 = "Aug";
$M_8 = "Sep";
$M_9 = "Okt";
$M_10 = "Nov";
$M_11 = "Dez";

// Ermitteln der Anzahl Tage pro Monat
$M_Anzahl_0 	= date("t",mktime(0, 0, 0, 1, 1, date("Y")));
$M_Anzahl_1 	= date("t",mktime(0, 0, 0, 2, 1, date("Y")));
$M_Anzahl_2 	= date("t",mktime(0, 0, 0, 3, 1, date("Y")));
$M_Anzahl_3 	= date("t",mktime(0, 0, 0, 4, 1, date("Y")));
$M_Anzahl_4 	= date("t",mktime(0, 0, 0, 5, 1, date("Y")));
$M_Anzahl_5 	= date("t",mktime(0, 0, 0, 6, 1, date("Y")));
$M_Anzahl_6 	= date("t",mktime(0, 0, 0, 7, 1, date("Y")));
$M_Anzahl_7 	= date("t",mktime(0, 0, 0, 8, 1, date("Y")));
$M_Anzahl_8 	= date("t",mktime(0, 0, 0, 9, 1, date("Y")));
$M_Anzahl_9 	= date("t",mktime(0, 0, 0, 10, 1, date("Y")));
$M_Anzahl_10 	= date("t",mktime(0, 0, 0, 11, 1, date("Y")));
$M_Anzahl_11 	= date("t",mktime(0, 0, 0, 12, 1, date("Y")));


// Abfrage Monatswerte


$month_values = AC_GetAggregatedValues($archiveID, $objectID, 3,  $year_startdate, $year_enddate, 15);
$A = count( $month_values );

@$M_Werte_0 	=    $month_values[$A-1]['Max'] 	- $month_values[$A-1]['Min'];		//Januar
@$M_Werte_1 	=    $month_values[$A-2]['Max'] 	- $month_values[$A-2]['Min'];		//Februar
@$M_Werte_2 	=    $month_values[$A-3]['Max'] 	- $month_values[$A-3]['Min'];		//März
@$M_Werte_3 	=    $month_values[$A-4]['Max'] 	- $month_values[$A-4]['Min'];		//April
@$M_Werte_4 	=    $month_values[$A-5]['Max'] 	- $month_values[$A-5]['Min'];		//Mai
@$M_Werte_5 	=    $month_values[$A-6]['Max'] 	- $month_values[$A-6]['Min'];		//Juni
@$M_Werte_6 	=    $month_values[$A-7]['Max'] 	- $month_values[$A-7]['Min'];		//Juli
@$M_Werte_7 	=    $month_values[$A-8]['Max'] 	- $month_values[$A-8]['Min'];		//August
@$M_Werte_8 	=    $month_values[$A-9]['Max'] 	- $month_values[$A-9]['Min'];		//September
@$M_Werte_9 	=    $month_values[$A-10]['Max'] - $month_values[$A-10]['Min'];	//Oktober
@$M_Werte_10 	=    $month_values[$A-11]['Max'] - $month_values[$A-11]['Min'];	//November
@$M_Werte_11 	=    $month_values[$A-12]['Max'] - $month_values[$A-12]['Min'];	//Dezember


If ($debug == true){
echo "Monatswerte; ";
print_r($month_values);
//echo $at."
";
}



	// Monatswerte aufsummieren

	@$M_Sum_0  = @$M_Werte_0;
	@$M_Sum_1  = @$M_Sum_0 + @$M_Werte_1;
	@$M_Sum_2  = @$M_Sum_1 + @$M_Werte_2;
	@$M_Sum_3  = @$M_Sum_2 + @$M_Werte_3;
	@$M_Sum_4  = @$M_Sum_3 + @$M_Werte_4;
	@$M_Sum_5  = @$M_Sum_4 + @$M_Werte_5;
	@$M_Sum_6  = @$M_Sum_5 + @$M_Werte_6;
	@$M_Sum_7  = @$M_Sum_6 + @$M_Werte_7;
	@$M_Sum_8  = @$M_Sum_7 + @$M_Werte_8;
   @$M_Sum_9  = @$M_Sum_8 + @$M_Werte_9;
   @$M_Sum_10 = @$M_Sum_9 + @$M_Werte_10;
   @$M_Sum_11 = @$M_Sum_10 + @$M_Werte_11;



// Abfrage Durchschnittswerte der letzten 12 Monate

    @$D_Werte_0  = round(@$M_Werte_0/$M_Anzahl_0, 2);
    @$D_Werte_1  = round(@$M_Werte_1/$M_Anzahl_1, 2);
    @$D_Werte_2  = round(@$M_Werte_2/$M_Anzahl_2, 2);
    @$D_Werte_3  = round(@$M_Werte_3/$M_Anzahl_3, 2);
    @$D_Werte_4  = round(@$M_Werte_4/$M_Anzahl_4, 2);
    @$D_Werte_5  = round(@$M_Werte_5/$M_Anzahl_5, 2);
    @$D_Werte_6  = round(@$M_Werte_6/$M_Anzahl_6, 2);
    @$D_Werte_7  = round(@$M_Werte_7/$M_Anzahl_7, 2);
    @$D_Werte_8  = round(@$M_Werte_8/$M_Anzahl_8, 2);
    @$D_Werte_9  = round(@$M_Werte_9/$M_Anzahl_9, 2);
    @$D_Werte_10 = round(@$M_Werte_10/$M_Anzahl_10, 2);
    @$D_Werte_11 = round(@$M_Werte_11/$M_Anzahl_11, 2);


	// Durchschnittlicher Verlauf des Stromverbrauches im Privathaushalt p.a. ; Quelle SWM

	$Prog[0] 	= 0.093 	* Verbrauch;
	$Prog[1] 	= 0.085 	* Verbrauch;
	$Prog[2] 	= 0.088 	* Verbrauch;
	$Prog[3] 	= 0.079 	* Verbrauch;
	$Prog[4] 	= 0.077 	* Verbrauch;
	$Prog[5] 	= 0.074 	* Verbrauch;
	$Prog[6] 	= 0.078 	* Verbrauch;
	$Prog[7] 	= 0.074 	* Verbrauch;
	$Prog[8] 	= 0.079 	* Verbrauch;
	$Prog[9] 	= 0.087 	* Verbrauch;
	$Prog[10] 	= 0.091 	* Verbrauch;
	$Prog[11] 	= 0.095 	* Verbrauch;




	$ProgSum[0] 	= 	$Prog[0];
 	$ProgSum[1] 	=  $ProgSum[0] + $Prog[1];
 	$ProgSum[2] 	=  $ProgSum[1] + $Prog[2];
	$ProgSum[3] 	=  $ProgSum[2] + $Prog[3];
	$ProgSum[4] 	=  $ProgSum[3] + $Prog[4];
	$ProgSum[5] 	=  $ProgSum[4] + $Prog[5];
	$ProgSum[6] 	=  $ProgSum[5] + $Prog[6];
	$ProgSum[7] 	=  $ProgSum[6] + $Prog[7];
	$ProgSum[8] 	=  $ProgSum[7] + $Prog[8];
	$ProgSum[9] 	=  $ProgSum[8] + $Prog[9];
	$ProgSum[10] 	=  $ProgSum[9] + $Prog[0];
	$ProgSum[11] 	=  $ProgSum[10] + $Prog[1];



	//Hintergrundfarbe Monatssummen einstellen
	$I = 0;

	do {
      settype($I, "string");
		if ($ProgSum[$I] >= ${"M_Sum_".$I}) {
			${"M_Sum_C".$I} = grün;

		}else {

				if( ${"M_Sum_".$I} >= (Schwelle * $ProgSum[$I] ) ) {
			 		${"M_Sum_C".$I} = rot;
   			}else {
   	  			${"M_Sum_C".$I} = gelb;
 				}

		}
		++ $I;
	}while ($I < 12);


	//Hintergrundfarbe Monatswerte einstellen
	$I = 0;

	do {
      settype($I, "string");
		if ($Prog[$I] >= ${"M_Werte_".$I}) {
			${"M_Werte_C".$I} = grün;

		}else {

				if( ${"M_Werte_".$I} >= (Schwelle * $Prog[$I] ) ) {
			 		${"M_Werte_C".$I} = rot;
   			}else {
   	  			${"M_Werte_C".$I} = gelb;
 				}

		}
		++ $I;
	}while ($I < 12);


	//Ausgaben formatieren

	@$M_Sum_0  = number_format(@$M_Sum_0, 2, ',', '.');
	@$M_Sum_1  = number_format(@$M_Sum_1, 2, ',', '.');
	@$M_Sum_2  = number_format(@$M_Sum_2, 2, ',', '.');
	@$M_Sum_3  = number_format(@$M_Sum_3, 2, ',', '.');
	@$M_Sum_4  = number_format(@$M_Sum_4, 2, ',', '.');
	@$M_Sum_5  = number_format(@$M_Sum_5, 2, ',', '.');
	@$M_Sum_6  = number_format(@$M_Sum_6, 2, ',', '.');
	@$M_Sum_7  = number_format(@$M_Sum_7, 2, ',', '.');
	@$M_Sum_8  = number_format(@$M_Sum_8, 2, ',', '.');
	@$M_Sum_9  = number_format(@$M_Sum_9, 2, ',', '.');
	@$M_Sum_10 = number_format(@$M_Sum_10, 2, ',', '.');
	@$M_Sum_11 = number_format(@$M_Sum_11, 2, ',', '.');






	@$M_Sum_0.= "<br>".Suffix;
	@$M_Sum_1.= "<br>".Suffix;
	@$M_Sum_2.= "<br>".Suffix;
	@$M_Sum_3.= "<br>".Suffix;
	@$M_Sum_4.= "<br>".Suffix;
	@$M_Sum_5.= "<br>".Suffix;
	@$M_Sum_6.= "<br>".Suffix;
	@$M_Sum_7.= "<br>".Suffix;
	@$M_Sum_8.= "<br>".Suffix;
	@$M_Sum_9.= "<br>".Suffix;
	@$M_Sum_10.= "<br>".Suffix;
	@$M_Sum_11.= "<br>".Suffix;


	@$M_Werte_0  = number_format(@$M_Werte_0, 2, ',', '.');
	@$M_Werte_1  = number_format(@$M_Werte_1, 2, ',', '.');
	@$M_Werte_2  = number_format(@$M_Werte_2, 2, ',', '.');
	@$M_Werte_3  = number_format(@$M_Werte_3, 2, ',', '.');
	@$M_Werte_4  = number_format(@$M_Werte_4, 2, ',', '.');
	@$M_Werte_5  = number_format(@$M_Werte_5, 2, ',', '.');
	@$M_Werte_6  = number_format(@$M_Werte_6, 2, ',', '.');
	@$M_Werte_7  = number_format(@$M_Werte_7, 2, ',', '.');
	@$M_Werte_8  = number_format(@$M_Werte_8, 2, ',', '.');
	@$M_Werte_9  = number_format(@$M_Werte_9, 2, ',', '.');
	@$M_Werte_10 = number_format(@$M_Werte_10, 2, ',', '.');
	@$M_Werte_11 = number_format(@$M_Werte_11, 2, ',', '.');

	@$M_Werte_0.= "<br>".Suffix;
	@$M_Werte_1.= "<br>".Suffix;
	@$M_Werte_2.= "<br>".Suffix;
	@$M_Werte_3.= "<br>".Suffix;
	@$M_Werte_4.= "<br>".Suffix;
	@$M_Werte_5.= "<br>".Suffix;
	@$M_Werte_6.= "<br>".Suffix;
	@$M_Werte_7.= "<br>".Suffix;
	@$M_Werte_8.= "<br>".Suffix;
	@$M_Werte_9.= "<br>".Suffix;
	@$M_Werte_10.= "<br>".Suffix;
	@$M_Werte_11.= "<br>".Suffix;

 	@$D_Werte_0  = number_format(@$D_Werte_0, 2, ',', '.');
	@$D_Werte_1  = number_format(@$D_Werte_1, 2, ',', '.');
	@$D_Werte_2  = number_format(@$D_Werte_2, 2, ',', '.');
	@$D_Werte_3  = number_format(@$D_Werte_3, 2, ',', '.');
	@$D_Werte_4  = number_format(@$D_Werte_4, 2, ',', '.');
	@$D_Werte_5  = number_format(@$D_Werte_5, 2, ',', '.');
	@$D_Werte_6  = number_format(@$D_Werte_6, 2, ',', '.');
	@$D_Werte_7  = number_format(@$D_Werte_7, 2, ',', '.');
	@$D_Werte_8  = number_format(@$D_Werte_8, 2, ',', '.');
	@$D_Werte_9  = number_format(@$D_Werte_9, 2, ',', '.');
	@$D_Werte_10 = number_format(@$D_Werte_10, 2, ',', '.');
	@$D_Werte_11 = number_format(@$D_Werte_11, 2, ',', '.');

	@$D_Werte_0.= "<br>".Suffix;
	@$D_Werte_1.= "<br>".Suffix;
	@$D_Werte_2.= "<br>".Suffix;
	@$D_Werte_3.= "<br>".Suffix;
   @$D_Werte_4.= "<br>".Suffix;
   @$D_Werte_5.= "<br>".Suffix;
   @$D_Werte_6.= "<br>".Suffix;
   @$D_Werte_7.= "<br>".Suffix;
   @$D_Werte_8.= "<br>".Suffix;
   @$D_Werte_9.= "<br>".Suffix;
   @$D_Werte_10.= "<br>".Suffix;
   @$D_Werte_11.= "<br>".Suffix;


	$Prog[0] = number_format($Prog[0], 2, ',', '.');
	$Prog[1] = number_format($Prog[1], 2, ',', '.');
	$Prog[2] = number_format($Prog[2], 2, ',', '.');
	$Prog[3] = number_format($Prog[3], 2, ',', '.');
	$Prog[4] = number_format($Prog[4], 2, ',', '.');
	$Prog[5] = number_format($Prog[5], 2, ',', '.');
	$Prog[6] = number_format($Prog[6], 2, ',', '.');
	$Prog[7] = number_format($Prog[7], 2, ',', '.');
	$Prog[8] = number_format($Prog[8], 2, ',', '.');
	$Prog[9] = number_format($Prog[9], 2, ',', '.');
	$Prog[10] = number_format($Prog[10], 2, ',', '.');
	$Prog[11] = number_format($Prog[11], 2, ',', '.');

	$Prog[0].= "<br>".Suffix;
	$Prog[1].= "<br>".Suffix;
	$Prog[2].= "<br>".Suffix;
	$Prog[3].= "<br>".Suffix;
	$Prog[4].= "<br>".Suffix;
	$Prog[5].= "<br>".Suffix;
	$Prog[6].= "<br>".Suffix;
	$Prog[7].= "<br>".Suffix;
	$Prog[8].= "<br>".Suffix;
	$Prog[9].= "<br>".Suffix;
	$Prog[10].= "<br>".Suffix;
	$Prog[11].= "<br>".Suffix;


	$ProgSum[0] = number_format($ProgSum[0], 2, ',', '.');
	$ProgSum[1] = number_format($ProgSum[1], 2, ',', '.');
	$ProgSum[2] = number_format($ProgSum[2], 2, ',', '.');
	$ProgSum[3] = number_format($ProgSum[3], 2, ',', '.');
	$ProgSum[4] = number_format($ProgSum[4], 2, ',', '.');
	$ProgSum[5] = number_format($ProgSum[5], 2, ',', '.');
	$ProgSum[6] = number_format($ProgSum[6], 2, ',', '.');
	$ProgSum[7] = number_format($ProgSum[7], 2, ',', '.');
	$ProgSum[8] = number_format($ProgSum[8], 2, ',', '.');
	$ProgSum[9] = number_format($ProgSum[9], 2, ',', '.');
	$ProgSum[10] = number_format($ProgSum[10], 2, ',', '.');
	$ProgSum[11] = number_format($ProgSum[11], 2, ',', '.');

	$ProgSum[0].= "<br>".Suffix;
	$ProgSum[1].= "<br>".Suffix;
	$ProgSum[2].= "<br>".Suffix;
	$ProgSum[3].= "<br>".Suffix;
	$ProgSum[4].= "<br>".Suffix;
	$ProgSum[5].= "<br>".Suffix;
	$ProgSum[6].= "<br>".Suffix;
	$ProgSum[7].= "<br>".Suffix;
	$ProgSum[8].= "<br>".Suffix;
	$ProgSum[9].= "<br>".Suffix;
	$ProgSum[10].= "<br>".Suffix;
	$ProgSum[11].= "<br>".Suffix;



// Ermitteln der Spaltenüberschriften (Monate)

// ++++++++++++++++ Table-Factory ++++++++++++++++++++++++++++++++++++++++++++++
// Den Anfang der Tabelle definieren
$content = '<table style="white-space:nowrap; text-align: left; background-color: rgb(32, 49, 67); width: 888px; height: 172px;" border="0" cellpadding="2" cellspacing="2">
                <tbody>';

// Die erste Zeile (Überschriften)
$content .= '<tr>
              <th style="white-space:nowrap; text-align: center;" colspan="2" rowspan="1">Summe</th>
				  <td style="white-space:nowrap; text-align: center; font-weight: small;">'.$M_0.'</td>
              <td style="white-space:nowrap; text-align: center; font-weight: small;">'.$M_1.'</td>
              <td style="white-space:nowrap; text-align: center; font-weight: small;">'.$M_2.'</td>
              <td style="white-space:nowrap; text-align: center; font-weight: small;">'.$M_3.'</td>
              <td style="white-space:nowrap; text-align: center; font-weight: small;">'.$M_4.'</td>
              <td style="white-space:nowrap; text-align: center; font-weight: small;">'.$M_5.'</td>
              <td style="white-space:nowrap; text-align: center; font-weight: small;">'.$M_6.'</td>
              <td style="white-space:nowrap; text-align: center; font-weight: small;">'.$M_7.'</td>
              <td style="white-space:nowrap; text-align: center; font-weight: small;">'.$M_8.'</td>
              <td style="white-space:nowrap; text-align: center; font-weight: small;">'.$M_9.'</td>
              <td style="white-space:nowrap; text-align: center; font-weight: small;">'.$M_10.'</td>
              <td style="white-space:nowrap; text-align: center; font-weight: small;">'.$M_11.'</td>
              </tr>';


// Zeile 2: Prognostizierter Ertrag

$content .=    '<tr>

						<td style="white-space:nowrap; text-align: right; background-color: rgb(20, 32, 43); font-weight: small;" colspan="2" rowspan="1"></small>Prognose*</small></td>
						<td nowrap; style="text-align: right; background-color: rgb(20, 32, 43); font-weight: small;"><small>'.$ProgSum[0].'</small></td>
                  <td style="text-align: right; background-color: rgb(20, 32, 43); font-weight: small;"><small>'.$ProgSum[1].'</small></td>
                  <td style="text-align: right; background-color: rgb(20, 32, 43); font-weight: small;"><small>'.$ProgSum[2].'</small></td>
                  <td style="text-align: right; background-color: rgb(20, 32, 43); font-weight: small;"><small>'.$ProgSum[3].'</small></td>
                  <td style="text-align: right; background-color: rgb(20, 32, 43); font-weight: small;"><small>'.$ProgSum[4].'</small></td>
                  <td style="text-align: right; background-color: rgb(20, 32, 43); font-weight: small;"><small>'.$ProgSum[5].'</small></td>
                  <td style="text-align: right; background-color: rgb(20, 32, 43); font-weight: small;"><small>'.$ProgSum[6].'</small></td>
                  <td style="text-align: right; background-color: rgb(20, 32, 43); font-weight: small;"><small>'.$ProgSum[7].'</small></td>
                  <td style="text-align: right; background-color: rgb(20, 32, 43); font-weight: small;"><small>'.$ProgSum[8].'</small></td>
                  <td style="text-align: right; background-color: rgb(20, 32, 43); font-weight: small;"><small>'.$ProgSum[9].'</small></td>
                  <td style="text-align: right; background-color: rgb(20, 32, 43); font-weight: small;"><small>'.$ProgSum[10].'</small></td>
                  <td style="text-align: right; background-color: rgb(20, 32, 43); font-weight: small;"><small>'.$ProgSum[11].'</small></td>
                </tr>';



// Zeile 3: Ist-Ertrag
$content .=    '<tr>
                  <td style="white-space:nowrap; text-align: right; background-color: rgb(20, 32, 43); font-weight: small;" colspan="2" rowspan="1"></small>Ist*</small></td>
  						<td style="white-space:nowrap; text-align: right; background-color: '.$M_Sum_C0.'; font-weight: small;"><small>'.$M_Sum_0.'</small></td>
                  <td style="white-space:nowrap; text-align: right; background-color: '.$M_Sum_C1.'; font-weight: small;"><small>'.$M_Sum_1.'</small></td>
                  <td style="white-space:nowrap; text-align: right; background-color: '.$M_Sum_C2.'; font-weight: small;"><small>'.$M_Sum_2.'</small></td>
                  <td style="white-space:nowrap; text-align: right; background-color: '.$M_Sum_C3.'; font-weight: small;"><small>'.$M_Sum_3.'</small></td>
                  <td style="white-space:nowrap; text-align: right; background-color: '.$M_Sum_C4.'; font-weight: small;"><small>'.$M_Sum_4.'</small></td>
                  <td style="white-space:nowrap; text-align: right; background-color: '.$M_Sum_C5.'; font-weight: small;"><small>'.$M_Sum_5.'</small></td>
                  <td style="white-space:nowrap; text-align: right; background-color: '.$M_Sum_C6.'; font-weight: small;"><small>'.$M_Sum_6.'</small></td>
                  <td style="white-space:nowrap; text-align: right; background-color: '.$M_Sum_C7.'; font-weight: small;"><small>'.$M_Sum_7.'</small></td>
                  <td style="white-space:nowrap; text-align: right; background-color: '.$M_Sum_C8.'; font-weight: small;"><small>'.$M_Sum_8.'</small></td>
                  <td style="white-space:nowrap; text-align: right; background-color: '.$M_Sum_C9.'; font-weight: small;"><small>'.$M_Sum_9.'</small></td>
                  <td style="white-space:nowrap; text-align: right; background-color: '.$M_Sum_C10.'; font-weight: small;"><small>'.$M_Sum_10.'</small></td>
                  <td style="white-space:nowrap; text-align: right; background-color: '.$M_Sum_C11.'; font-weight: small;"><small>'.$M_Sum_11.'</small></td>
                </tr>';

// Zeile 4: Einzelwerte
$content .= '<tr>
              <th style="white-space:nowrap; text-align: center;" colspan="2" rowspan="1">Werte</th>
				  <td style="white-space:nowrap; text-align: center; font-weight: small;">'.$M_0.'</td>
              <td style="white-space:nowrap; text-align: center; font-weight: small;">'.$M_1.'</td>
              <td style="white-space:nowrap; text-align: center; font-weight: small;">'.$M_2.'</td>
              <td style="white-space:nowrap; text-align: center; font-weight: small;">'.$M_3.'</td>
              <td style="white-space:nowrap; text-align: center; font-weight: small;">'.$M_4.'</td>
              <td style="white-space:nowrap; text-align: center; font-weight: small;">'.$M_5.'</td>
              <td style="white-space:nowrap; text-align: center; font-weight: small;">'.$M_6.'</td>
              <td style="white-space:nowrap; text-align: center; font-weight: small;">'.$M_7.'</td>
              <td style="white-space:nowrap; text-align: center; font-weight: small;">'.$M_8.'</td>
              <td style="white-space:nowrap; text-align: center; font-weight: small;">'.$M_9.'</td>
              <td style="white-space:nowrap; text-align: center; font-weight: small;">'.$M_10.'</td>
              <td style="white-space:nowrap; text-align: center; font-weight: small;">'.$M_11.'</td>
              </tr>';

// Zeile 5: Prognose Monatsertrag
$content .=    '<tr>
                  <td></td>
                  <td style="white-space:nowrap; text-align: right; background-color: rgb(13, 23, 36);"><small>Prognose*</small></td>
                  <td style="white-space:nowrap; text-align: right; background-color: rgb(13, 23, 36);"><small>'.$Prog[0].'</small></td>
                  <td style="white-space:nowrap; text-align: right; background-color: rgb(13, 23, 36);"><small>'.$Prog[1].'</small></td>
                  <td style="white-space:nowrap; text-align: right; background-color: rgb(13, 23, 36);"><small>'.$Prog[2].'</small></td>
                  <td style="white-space:nowrap; text-align: right; background-color: rgb(13, 23, 36);"><small>'.$Prog[3].'</small></td>
                  <td style="white-space:nowrap; text-align: right; background-color: rgb(13, 23, 36);"><small>'.$Prog[4].'</small></td>
                  <td style="white-space:nowrap; text-align: right; background-color: rgb(13, 23, 36);"><small>'.$Prog[5].'</small></td>
                  <td style="white-space:nowrap; text-align: right; background-color: rgb(13, 23, 36);"><small>'.$Prog[6].'</small></td>
                  <td style="white-space:nowrap; text-align: right; background-color: rgb(13, 23, 36);"><small>'.$Prog[7].'</small></td>
                  <td style="white-space:nowrap; text-align: right; background-color: rgb(13, 23, 36);"><small>'.$Prog[8].'</small></td>
                  <td style="white-space:nowrap; text-align: right; background-color: rgb(13, 23, 36);"><small>'.$Prog[9].'</small></td>
                  <td style="white-space:nowrap; text-align: right; background-color: rgb(13, 23, 36);"><small>'.$Prog[10].'</small></td>
                  <td style="white-space:nowrap; text-align: right; background-color: rgb(13, 23, 36);"><small>'.$Prog[11].'</small></td>
                </tr>';




// Zeile 6: Ist Monatsertrag
$content .=    '<tr>
                  <td></td>
                  <td style="white-space:nowrap; text-align: right; background-color: rgb(13, 23, 36);"><small>Ist*</small></td>
                  <td style="white-space:nowrap; text-align: right; background-color: '.$M_Werte_C0.';"><small>'.$M_Werte_0.'</small></td>
                  <td style="white-space:nowrap; text-align: right; background-color: '.$M_Werte_C1.';"><small>'.$M_Werte_1.'</small></td>
                  <td style="white-space:nowrap; text-align: right; background-color: '.$M_Werte_C2.';"><small>'.$M_Werte_2.'</small></td>
                  <td style="white-space:nowrap; text-align: right; background-color: '.$M_Werte_C3.';"><small>'.$M_Werte_3.'</small></td>
                  <td style="white-space:nowrap; text-align: right; background-color: '.$M_Werte_C4.';"><small>'.$M_Werte_4.'</small></td>
                  <td style="white-space:nowrap; text-align: right; background-color: '.$M_Werte_C5.';"><small>'.$M_Werte_5.'</small></td>
                  <td style="white-space:nowrap; text-align: right; background-color: '.$M_Werte_C6.';"><small>'.$M_Werte_6.'</small></td>
                  <td style="white-space:nowrap; text-align: right; background-color: '.$M_Werte_C7.';"><small>'.$M_Werte_7.'</small></td>
                  <td style="white-space:nowrap; text-align: right; background-color: '.$M_Werte_C8.';"><small>'.$M_Werte_8.'</small></td>
                  <td style="white-space:nowrap; text-align: right; background-color: '.$M_Werte_C9.';"><small>'.$M_Werte_9.'</small></td>
                  <td style="white-space:nowrap; text-align: right; background-color: '.$M_Werte_C10.';"><small>'.$M_Werte_10.'</small></td>
                  <td style="white-space:nowrap; text-align: right; background-color: '.$M_Werte_C11.';"><small>'.$M_Werte_11.'</small></td>
                </tr>';
// Zeile 4: Zentral, Tagesdurchschnitt
$content .=    '<tr>
                  <td></td>
                  <td style="white-space:nowrap; text-align: right; background-color: rgb(20, 32, 43);"><small>Ø Tag*</td>
                  <td style="white-space:nowrap; text-align: right; background-color: rgb(20, 32, 43);"><small>'.$D_Werte_0.'</small></td>
                  <td style="white-space:nowrap; text-align: right; background-color: rgb(20, 32, 43);"><small>'.$D_Werte_1.'</small></td>
                  <td style="white-space:nowrap; text-align: right; background-color: rgb(20, 32, 43);"><small>'.$D_Werte_2.'</small></td>
                  <td style="white-space:nowrap; text-align: right; background-color: rgb(20, 32, 43);"><small>'.$D_Werte_3.'</small></td>
                  <td style="white-space:nowrap; text-align: right; background-color: rgb(20, 32, 43);"><small>'.$D_Werte_4.'</small></td>
                  <td style="white-space:nowrap; text-align: right; background-color: rgb(20, 32, 43);"><small>'.$D_Werte_5.'</small></td>
                  <td style="white-space:nowrap; text-align: right; background-color: rgb(20, 32, 43);"><small>'.$D_Werte_6.'</small></td>
                  <td style="white-space:nowrap; text-align: right; background-color: rgb(20, 32, 43);"><small>'.$D_Werte_7.'</small></td>
                  <td style="white-space:nowrap; text-align: right; background-color: rgb(20, 32, 43);"><small>'.$D_Werte_8.'</small></td>
                  <td style="white-space:nowrap; text-align: right; background-color: rgb(20, 32, 43);"><small>'.$D_Werte_9.'</small></td>
                  <td style="white-space:nowrap; text-align: right; background-color: rgb(20, 32, 43);"><small>'.$D_Werte_10.'</small></td>
                  <td style="white-space:nowrap; text-align: right; background-color: rgb(20, 32, 43);"><small>'.$D_Werte_11.'</small></td>
                </tr>';
// Tabellenende
$content .= "</table>";

SetValueString($contend_var_id,$content);

?>