Beiträge: 18.686
Themen: 347
Registriert seit: Nov 2008
Bewertung:
11
Hallo@all,
heute nachmittag habe ich noch eine Anfrage zur Teilnahme in der BZ-TG erhalten
SOMIT SIND MOMENTAN ALLE PLÄTZE BELEGT !!!
bei Änderungen in der BZ-TG werde ich wieder aktualisieren hier..
Grüße, Liane
Beiträge: 18.686
Themen: 347
Registriert seit: Nov 2008
Bewertung:
11
Hallo@all,
habe hier etwas "aufgeräumt", so dass wir zum Abschluss unseres 14 WZ + 2 Banken-System noch je 1 Tabelle f. MI und SA zur Orientierung hier haben.
Ab diesen SA, 27.06. führe ich dann die neue Statistik des 5 HZ - 12 NZ - Systems.
Grüße, Liane
++++++++++++++++++++++++++++++++++++++
ABSCHLUSS-STATISTIK FÜR MITTWOCH:
<b>Tabelle2</b>
<table border="1" cellspacing="0" cellpadding="0" style="font-family:Arial,Arial; font-size:10pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:80px;" /><col style="width:90px;" /><col style="width:80px;" /><col style="width:80px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td><td >C</td><td >D</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td style="background-color:#ff99cc; font-weight:bold; ">STATISTIK</td><td style="background-color:#ff99cc; font-weight:bold; text-align:right; ">Dezember 08</td><td style="background-color:#ff99cc; font-weight:bold; ">MITTWOCH</td><td style="background-color:#ff99cc; font-weight:bold; ">Lotto-BZ-TG</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="background-color:#99cc00; font-weight:bold; ">MONAT</td><td style="background-color:#99cc00; font-weight:bold; ">EINSATZ €</td><td style="background-color:#99cc00; font-weight:bold; ">GEWINN €</td><td style="background-color:#99cc00; font-weight:bold; ">Rücklauf %</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="background-color:#ccffcc; font-weight:bold; ">Dezember</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">75,00</td><td style="background-color:#ffff00; font-weight:bold; text-align:right; ">11,90</td><td style="background-color:#ccffff; font-weight:bold; text-align:right; ">15,87%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td style="background-color:#ff99cc; font-weight:bold; ">STATISTIK</td><td style="background-color:#ff99cc; font-weight:bold; text-align:right; ">2009</td><td style="background-color:#ff99cc; font-weight:bold; ">MITTWOCH</td><td style="background-color:#ff99cc; font-weight:bold; ">Lotto-BZ-TG</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td style="background-color:#99cc00; font-weight:bold; ">MONAT</td><td style="background-color:#99cc00; font-weight:bold; ">EINSATZ €</td><td style="background-color:#99cc00; font-weight:bold; ">GEWINN €</td><td style="background-color:#99cc00; font-weight:bold; ">Rücklauf %</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td style="background-color:#ccffcc; font-weight:bold; ">Januar</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">60,05</td><td style="background-color:#ffff00; font-weight:bold; text-align:right; ">17,60</td><td style="background-color:#ccffff; font-weight:bold; text-align:right; ">29,31%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td style="background-color:#ccffcc; font-weight:bold; ">Februar</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">58,30</td><td style="background-color:#ffff00; font-weight:bold; text-align:right; ">0,00</td><td style="background-color:#ccffff; font-weight:bold; text-align:right; ">0,00%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td style="background-color:#ccffcc; font-weight:bold; ">März</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">56,60</td><td style="background-color:#ffff00; font-weight:bold; text-align:right; ">11,50</td><td style="background-color:#ccffff; font-weight:bold; text-align:right; ">20,32%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td style="background-color:#ccffcc; font-weight:bold; ">April</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">70,00</td><td style="background-color:#ffff00; font-weight:bold; text-align:right; ">0,00</td><td style="background-color:#ccffff; font-weight:bold; text-align:right; ">0,00%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td style="background-color:#ccffcc; font-weight:bold; ">Mai</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">56,00</td><td style="background-color:#ffff00; font-weight:bold; text-align:right; ">0,00</td><td style="background-color:#ccffff; font-weight:bold; text-align:right; ">0,00%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td style="background-color:#ccffcc; font-weight:bold; ">bis 17.06.09</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">42,00</td><td style="background-color:#ffff00; font-weight:bold; text-align:right; ">0,00</td><td style="background-color:#ccffff; font-weight:bold; text-align:right; ">0,00%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >12</td><td style="background-color:#ccffcc; font-weight:bold; ">Juli </td><td style="background-color:#ff9900; font-weight:bold; ">x</td><td style="background-color:#ffff00; font-weight:bold; ">x</td><td style="background-color:#ccffff; font-weight:bold; ">x</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >13</td><td style="background-color:#ccffcc; font-weight:bold; ">August</td><td style="background-color:#ff9900; font-weight:bold; ">x</td><td style="background-color:#ffff00; font-weight:bold; ">x</td><td style="background-color:#ccffff; font-weight:bold; ">x</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >14</td><td style="background-color:#ccffcc; font-weight:bold; ">September</td><td style="background-color:#ff9900; font-weight:bold; ">x</td><td style="background-color:#ffff00; font-weight:bold; ">x</td><td style="background-color:#ccffff; font-weight:bold; ">x</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >15</td><td style="background-color:#ccffcc; font-weight:bold; ">Oktober</td><td style="background-color:#ff9900; font-weight:bold; ">x</td><td style="background-color:#ffff00; font-weight:bold; ">x</td><td style="background-color:#ccffff; font-weight:bold; ">x</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >16</td><td style="background-color:#ccffcc; font-weight:bold; ">November</td><td style="background-color:#ff9900; font-weight:bold; ">x</td><td style="background-color:#ffff00; font-weight:bold; ">x</td><td style="background-color:#ccffff; font-weight:bold; ">x</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >17</td><td style="background-color:#ccffcc; font-weight:bold; ">Dezember</td><td style="background-color:#ff9900; font-weight:bold; ">x</td><td style="background-color:#ffff00; ">x</td><td style="background-color:#ccffff; ">x</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >18</td><td style="background-color:#ff99cc; font-weight:bold; ">TOTAL 09</td><td style="background-color:#ff99cc; font-weight:bold; text-align:right; ">342,95</td><td style="background-color:#ff99cc; font-weight:bold; text-align:right; ">29,10</td><td style="background-color:#ff99cc; font-weight:bold; text-align:right; ">8,49%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >19</td><td style="background-color:#ffcc99; font-weight:bold; ">Übertrag 08</td><td style="background-color:#ffcc99; font-weight:bold; text-align:right; ">75,00</td><td style="background-color:#ffcc99; font-weight:bold; text-align:right; ">11,90</td><td style="background-color:#ffcc99; font-weight:bold; text-align:right; ">15,87%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >20</td><td style="background-color:#ff9900; font-weight:bold; ">GESAMT</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">417,95</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">41,00</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">9,81%</td></tr></table>
<table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b>Formeln der Tabelle</b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Zelle</td><td >Formel</td></tr><tr><td >B18</td><td >=SUMME(B6:B17)</td></tr><tr><td >C18</td><td >=SUMME(C6:C17)</td></tr><tr><td >B20</td><td >=SUMME(B18:B19)</td></tr><tr><td >C20</td><td >=SUMME(C18:C19)</td></tr></table></td></tr></table>
Excel Tabellen im Web darstellen >> <a style ="font-family:Arial; font-size:9pt; color:#fcf507; background-color:#800040; font-weight:bold;" href="http://www.excel-jeanie-html.de" target="_blank"> Excel Jeanie HTML 4 </a>
ABSCHLUSS-STATISTIK FÜR SAMSTAG:
<b>Tabelle1</b>
<table border="1" cellspacing="0" cellpadding="0" style="font-family:Arial,Arial; font-size:10pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:80px;" /><col style="width:80px;" /><col style="width:80px;" /><col style="width:80px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td><td >C</td><td >D</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td style="background-color:#ff99cc; font-weight:bold; ">STATISTIK</td><td style="background-color:#ff99cc; font-weight:bold; ">Juli-Dez.08</td><td style="background-color:#ff99cc; font-weight:bold; ">SAMSTAG</td><td style="background-color:#ff99cc; font-weight:bold; ">Lotto-BZ-TG</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="background-color:#99cc00; font-weight:bold; ">MONAT</td><td style="background-color:#99cc00; font-weight:bold; ">EINSATZ €</td><td style="background-color:#99cc00; font-weight:bold; ">GEWINN €</td><td style="background-color:#99cc00; font-weight:bold; ">Rücklauf %</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="background-color:#ccffcc; font-weight:bold; ">Juli ab 12.7.</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">51,00</td><td style="background-color:#ffff00; font-weight:bold; text-align:right; ">0,00</td><td style="background-color:#ccffff; font-weight:bold; text-align:right; ">0,00%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td style="background-color:#ccffcc; font-weight:bold; ">August</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">83,25</td><td style="background-color:#ffff00; font-weight:bold; text-align:right; ">0,00</td><td style="background-color:#ccffff; font-weight:bold; text-align:right; ">0,00%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td style="background-color:#ccffcc; font-weight:bold; ">September</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">69,00</td><td style="background-color:#ffff00; font-weight:bold; text-align:right; ">0,00</td><td style="background-color:#ccffff; font-weight:bold; text-align:right; ">0,00%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td style="background-color:#ccffcc; font-weight:bold; ">Oktober</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">62,25</td><td style="background-color:#ffff00; font-weight:bold; text-align:right; ">50,30</td><td style="background-color:#ccffff; font-weight:bold; text-align:right; ">80,80%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td style="background-color:#ccffcc; font-weight:bold; ">November</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">97,50</td><td style="background-color:#ffff00; font-weight:bold; text-align:right; ">52,20</td><td style="background-color:#ccffff; font-weight:bold; text-align:right; ">53,54%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td style="background-color:#ccffcc; font-weight:bold; ">Dezember</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">62,75</td><td style="background-color:#ffff00; font-weight:bold; text-align:right; ">0,00</td><td style="background-color:#ccffff; font-weight:bold; text-align:right; ">0,00%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td style="background-color:#ff99cc; font-weight:bold; ">TOTAL 08</td><td style="background-color:#ff99cc; font-weight:bold; text-align:right; ">425,75</td><td style="background-color:#ff99cc; font-weight:bold; text-align:right; ">102,50</td><td style="background-color:#ff99cc; font-weight:bold; text-align:right; ">24,08%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td style="font-weight:bold; "> </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td style="background-color:#ff99cc; font-weight:bold; ">STATISTIK</td><td style="background-color:#ff99cc; font-weight:bold; text-align:right; ">2009</td><td style="background-color:#ff99cc; font-weight:bold; ">SAMSTAG</td><td style="background-color:#ff99cc; font-weight:bold; ">Lotto-BZ-TG</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >12</td><td style="background-color:#99cc00; font-weight:bold; ">MONAT</td><td style="background-color:#99cc00; font-weight:bold; ">EINSATZ €</td><td style="background-color:#99cc00; font-weight:bold; ">GEWINN €</td><td style="background-color:#99cc00; font-weight:bold; ">Rücklauf %</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >13</td><td style="background-color:#ccffcc; font-weight:bold; ">Januar</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">72,45</td><td style="background-color:#ffff00; font-weight:bold; text-align:right; ">28,20</td><td style="background-color:#ccffff; font-weight:bold; text-align:right; ">38,92%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >14</td><td style="background-color:#ccffcc; font-weight:bold; ">Februar</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">50,25</td><td style="background-color:#ffff00; font-weight:bold; text-align:right; ">10,20</td><td style="background-color:#ccffff; font-weight:bold; text-align:right; ">29,30%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >15</td><td style="background-color:#ccffcc; font-weight:bold; ">März</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">56,20</td><td style="background-color:#ffff00; font-weight:bold; text-align:right; ">80,40</td><td style="background-color:#ccffff; font-weight:bold; text-align:right; ">143,06%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >16</td><td style="background-color:#ccffcc; font-weight:bold; ">April</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">56,00</td><td style="background-color:#ffff00; font-weight:bold; text-align:right; ">0,00</td><td style="background-color:#ccffff; font-weight:bold; text-align:right; ">0,00%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >17</td><td style="background-color:#ccffcc; font-weight:bold; ">Mai</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">70,00</td><td style="background-color:#ffff00; font-weight:bold; text-align:right; ">0,00</td><td style="background-color:#ccffff; font-weight:bold; text-align:right; ">0,00%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >18</td><td style="background-color:#ccffcc; font-weight:bold; ">bis 20.06.09</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">42,00</td><td style="background-color:#ffff00; font-weight:bold; text-align:right; ">8,10</td><td style="background-color:#ccffff; font-weight:bold; text-align:right; ">19,29%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >19</td><td style="background-color:#ccffcc; font-weight:bold; ">Juli </td><td style="background-color:#ff9900; font-weight:bold; ">x</td><td style="background-color:#ffff00; font-weight:bold; ">x</td><td style="background-color:#ccffff; font-weight:bold; ">x</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >20</td><td style="background-color:#ccffcc; font-weight:bold; ">August</td><td style="background-color:#ff9900; font-weight:bold; ">x</td><td style="background-color:#ffff00; font-weight:bold; ">x</td><td style="background-color:#ccffff; font-weight:bold; ">x</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >21</td><td style="background-color:#ccffcc; font-weight:bold; ">September</td><td style="background-color:#ff9900; font-weight:bold; ">x</td><td style="background-color:#ffff00; font-weight:bold; ">x</td><td style="background-color:#ccffff; font-weight:bold; ">x</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >22</td><td style="background-color:#ccffcc; font-weight:bold; ">Oktober</td><td style="background-color:#ff9900; font-weight:bold; ">x</td><td style="background-color:#ffff00; font-weight:bold; ">x</td><td style="background-color:#ccffff; font-weight:bold; ">x</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >23</td><td style="background-color:#ccffcc; font-weight:bold; ">November</td><td style="background-color:#ff9900; font-weight:bold; ">x</td><td style="background-color:#ffff00; font-weight:bold; ">x</td><td style="background-color:#ccffff; font-weight:bold; ">x</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >24</td><td style="background-color:#ccffcc; font-weight:bold; ">Dezember</td><td style="background-color:#ff9900; font-weight:bold; ">x</td><td style="background-color:#ffff00; font-weight:bold; ">x</td><td style="background-color:#ccffff; font-weight:bold; ">x</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >25</td><td style="background-color:#ff99cc; font-weight:bold; ">TOTAL 09</td><td style="background-color:#ff99cc; font-weight:bold; text-align:right; ">346,90</td><td style="background-color:#ff99cc; font-weight:bold; text-align:right; ">126,90</td><td style="background-color:#ff99cc; font-weight:bold; text-align:right; ">36,58%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >26</td><td style="background-color:#ffcc99; font-weight:bold; ">Übertrag 08</td><td style="background-color:#ffcc99; font-weight:bold; text-align:right; ">425,75</td><td style="background-color:#ffcc99; font-weight:bold; text-align:right; ">102,50</td><td style="background-color:#ffcc99; font-weight:bold; text-align:right; ">24,08%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >27</td><td style="background-color:#ff9900; font-weight:bold; ">GESAMT</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">772,65</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">229,40</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">29,69%</td></tr></table>
<table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b>Formeln der Tabelle</b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Zelle</td><td >Formel</td></tr><tr><td >B9</td><td >=SUMME(B3:B8)</td></tr><tr><td >C9</td><td >=SUMME(C3:C8)</td></tr><tr><td >B25</td><td >=SUMME(B13:B24)</td></tr><tr><td >C25</td><td >=SUMME(C13:C24)</td></tr><tr><td >B27</td><td >=SUMME(B25:B26)</td></tr><tr><td >C27</td><td >=SUMME(C25:C26)</td></tr></table></td></tr></table>
Excel Tabellen im Web darstellen >> <a style ="font-family:Arial; font-size:9pt; color:#fcf507; background-color:#800040; font-weight:bold;" href="http://www.excel-jeanie-html.de" target="_blank"> Excel Jeanie HTML 4 </a>
Beiträge: 18.686
Themen: 347
Registriert seit: Nov 2008
Bewertung:
11
Hallo@all,
zur Orientierung für Euch hier die Statistik des neuen Systems, welche ich monatl. aktualisiere.
...naja, der Anfang war jetzt nicht ganz sooo gut.. :D
aktualisiert - Abschluss 12/09 sowie 01/2010
<b>Tabelle1</b>
<table border="1" cellspacing="0" cellpadding="0" style="font-family:Arial,Arial; font-size:10pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:80px;" /><col style="width:80px;" /><col style="width:80px;" /><col style="width:80px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td><td >C</td><td >D</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td style="background-color:#ff99cc; font-weight:bold; ">5 HZ-12 NZ</td><td style="background-color:#ff99cc; font-weight:bold; text-align:right; ">2009</td><td style="background-color:#ff99cc; font-weight:bold; ">SAMSTAG</td><td style="background-color:#ff99cc; font-weight:bold; ">Lotto-BZ-TG</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="background-color:#99cc00; font-weight:bold; ">MONAT</td><td style="background-color:#99cc00; font-weight:bold; ">EINSATZ €</td><td style="background-color:#99cc00; font-weight:bold; ">GEWINN €</td><td style="background-color:#99cc00; font-weight:bold; ">Rücklauf %</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="background-color:#ccffcc; font-weight:bold; text-align:right; ">27.06.</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">23,25</td><td style="background-color:#ffff00; font-weight:bold; text-align:right; ">0,00</td><td style="background-color:#ccffff; font-weight:bold; text-align:right; ">0,00%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td style="background-color:#ccffcc; font-weight:bold; ">Juli </td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">93,00</td><td style="background-color:#ffff00; font-weight:bold; text-align:right; ">29,70</td><td style="background-color:#ccffff; font-weight:bold; text-align:right; ">31,94%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td style="background-color:#ccffcc; font-weight:bold; ">August</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">116,25</td><td style="background-color:#ffff00; font-weight:bold; text-align:right; ">59,40</td><td style="background-color:#ccffff; font-weight:bold; text-align:right; ">51,10%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td style="background-color:#ccffcc; font-weight:bold; ">September</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">93,00</td><td style="background-color:#ffff00; font-weight:bold; text-align:right; ">0,00</td><td style="background-color:#ccffff; font-weight:bold; text-align:right; ">0,00%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td style="background-color:#ccffcc; font-weight:bold; ">Oktober</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">116,25</td><td style="background-color:#ffff00; font-weight:bold; text-align:right; ">0,00</td><td style="background-color:#ccffff; font-weight:bold; text-align:right; ">0,00%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td style="background-color:#ccffcc; font-weight:bold; ">November</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">93,00</td><td style="background-color:#ffff00; font-weight:bold; text-align:right; ">110,20</td><td style="background-color:#ccffff; font-weight:bold; text-align:right; ">118,49%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td style="background-color:#ccffcc; font-weight:bold; ">Dezember</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">93,00</td><td style="background-color:#ffff00; font-weight:bold; text-align:right; ">102,40</td><td style="background-color:#ccffff; font-weight:bold; text-align:right; ">110,11%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td style="background-color:#ff99cc; font-weight:bold; ">TOTAL 2009</td><td style="background-color:#ff99cc; font-weight:bold; text-align:right; ">627,75</td><td style="background-color:#ff99cc; font-weight:bold; text-align:right; ">301,70</td><td style="background-color:#ff99cc; font-weight:bold; text-align:right; ">48,06%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td style="font-weight:bold; "> </td><td style="font-weight:bold; "> </td><td style="font-weight:bold; "> </td><td style="font-weight:bold; "> </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >12</td><td style="background-color:#ff99cc; font-weight:bold; ">5 HZ-12 NZ</td><td style="background-color:#ff99cc; font-weight:bold; text-align:right; ">2010</td><td style="background-color:#ff99cc; font-weight:bold; ">SAMSTAG</td><td style="background-color:#ff99cc; font-weight:bold; ">Lotto-BZ-TG</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >13</td><td style="background-color:#99cc00; font-weight:bold; ">MONAT</td><td style="background-color:#99cc00; font-weight:bold; ">EINSATZ €</td><td style="background-color:#99cc00; font-weight:bold; ">GEWINN €</td><td style="background-color:#99cc00; font-weight:bold; ">Rücklauf %</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >14</td><td style="background-color:#ccffcc; font-weight:bold; ">Januar</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">116,25</td><td style="background-color:#ffff00; font-weight:bold; text-align:right; ">10,50</td><td style="background-color:#ccffff; font-weight:bold; text-align:right; ">9,03%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >15</td><td style="background-color:#ccffcc; font-weight:bold; ">Febraur</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">93,00</td><td style="background-color:#ffff00; font-weight:bold; "> </td><td style="background-color:#ccffff; font-weight:bold; "> </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >16</td><td style="background-color:#ccffcc; font-weight:bold; ">März</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">93,00</td><td style="background-color:#ffff00; font-weight:bold; "> </td><td style="background-color:#ccffff; font-weight:bold; "> </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >17</td><td style="background-color:#ccffcc; font-weight:bold; ">April</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">93,00</td><td style="background-color:#ffff00; font-weight:bold; "> </td><td style="background-color:#ccffff; font-weight:bold; "> </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >18</td><td style="background-color:#ccffcc; font-weight:bold; ">Mai</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">116,25</td><td style="background-color:#ffff00; font-weight:bold; "> </td><td style="background-color:#ccffff; font-weight:bold; "> </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >19</td><td style="background-color:#ccffcc; font-weight:bold; ">Juni</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">93,00</td><td style="background-color:#ffff00; font-weight:bold; "> </td><td style="background-color:#ccffff; font-weight:bold; "> </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >20</td><td style="background-color:#ccffcc; font-weight:bold; ">Juli</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">116,25</td><td style="background-color:#ffff00; font-weight:bold; "> </td><td style="background-color:#ccffff; font-weight:bold; "> </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >21</td><td style="background-color:#ccffcc; font-weight:bold; ">August</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">93,00</td><td style="background-color:#ffff00; font-weight:bold; "> </td><td style="background-color:#ccffff; font-weight:bold; "> </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >22</td><td style="background-color:#ccffcc; font-weight:bold; ">September</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">93,00</td><td style="background-color:#ffff00; font-weight:bold; "> </td><td style="background-color:#ccffff; font-weight:bold; "> </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >23</td><td style="background-color:#ccffcc; font-weight:bold; ">Oktober</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">116,25</td><td style="background-color:#ffff00; font-weight:bold; "> </td><td style="background-color:#ccffff; font-weight:bold; "> </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >24</td><td style="background-color:#ccffcc; font-weight:bold; ">November</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">93,00</td><td style="background-color:#ffff00; font-weight:bold; "> </td><td style="background-color:#ccffff; font-weight:bold; "> </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >25</td><td style="background-color:#ccffcc; font-weight:bold; ">Dezember</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">93,00</td><td style="background-color:#ffff00; font-weight:bold; "> </td><td style="background-color:#ccffff; font-weight:bold; "> </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >26</td><td style="background-color:#ff99cc; font-weight:bold; ">TOTAL 2010</td><td style="background-color:#ff99cc; font-weight:bold; text-align:right; ">1209,00</td><td style="background-color:#ff99cc; font-weight:bold; "> </td><td style="background-color:#ff99cc; font-weight:bold; "> </td></tr></table>
<table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b>Formeln der Tabelle</b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Zelle</td><td >Formel</td></tr><tr><td >B10</td><td >=SUMME(B3:B9)</td></tr></table></td></tr></table>
Excel Tabellen im Web darstellen >> <a style ="font-family:Arial; font-size:9pt; color:#fcf507; background-color:#800040; font-weight:bold;" href="http://www.excel-jeanie-html.de" target="_blank"> Excel Jeanie HTML 4 </a>
Beiträge: 18.686
Themen: 347
Registriert seit: Nov 2008
Bewertung:
11
Zitat:Original von Liane
Hallo@all,
zur Orientierung für Euch hier die Statistik des neuen Systems, welche ich monatl. aktualisiere.
...naja, der Anfang war jetzt nicht ganz sooo gut.. :D
aktualisiert - Abschluss 12/09 sowie 01/2010
<b>Tabelle1</b>
<table border="1" cellspacing="0" cellpadding="0" style="font-family:Arial,Arial; font-size:10pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:80px;" /><col style="width:80px;" /><col style="width:80px;" /><col style="width:80px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td><td >C</td><td >D</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td style="background-color:#ff99cc; font-weight:bold; ">5 HZ-12 NZ</td><td style="background-color:#ff99cc; font-weight:bold; text-align:right; ">2009</td><td style="background-color:#ff99cc; font-weight:bold; ">SAMSTAG</td><td style="background-color:#ff99cc; font-weight:bold; ">Lotto-BZ-TG</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="background-color:#99cc00; font-weight:bold; ">MONAT</td><td style="background-color:#99cc00; font-weight:bold; ">EINSATZ €</td><td style="background-color:#99cc00; font-weight:bold; ">GEWINN €</td><td style="background-color:#99cc00; font-weight:bold; ">Rücklauf %</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="background-color:#ccffcc; font-weight:bold; text-align:right; ">27.06.</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">23,25</td><td style="background-color:#ffff00; font-weight:bold; text-align:right; ">0,00</td><td style="background-color:#ccffff; font-weight:bold; text-align:right; ">0,00%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td style="background-color:#ccffcc; font-weight:bold; ">Juli </td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">93,00</td><td style="background-color:#ffff00; font-weight:bold; text-align:right; ">29,70</td><td style="background-color:#ccffff; font-weight:bold; text-align:right; ">31,94%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td style="background-color:#ccffcc; font-weight:bold; ">August</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">116,25</td><td style="background-color:#ffff00; font-weight:bold; text-align:right; ">59,40</td><td style="background-color:#ccffff; font-weight:bold; text-align:right; ">51,10%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td style="background-color:#ccffcc; font-weight:bold; ">September</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">93,00</td><td style="background-color:#ffff00; font-weight:bold; text-align:right; ">0,00</td><td style="background-color:#ccffff; font-weight:bold; text-align:right; ">0,00%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td style="background-color:#ccffcc; font-weight:bold; ">Oktober</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">116,25</td><td style="background-color:#ffff00; font-weight:bold; text-align:right; ">0,00</td><td style="background-color:#ccffff; font-weight:bold; text-align:right; ">0,00%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td style="background-color:#ccffcc; font-weight:bold; ">November</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">93,00</td><td style="background-color:#ffff00; font-weight:bold; text-align:right; ">110,20</td><td style="background-color:#ccffff; font-weight:bold; text-align:right; ">118,49%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td style="background-color:#ccffcc; font-weight:bold; ">Dezember</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">93,00</td><td style="background-color:#ffff00; font-weight:bold; text-align:right; ">102,40</td><td style="background-color:#ccffff; font-weight:bold; text-align:right; ">110,11%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td style="background-color:#ff99cc; font-weight:bold; ">TOTAL 2009</td><td style="background-color:#ff99cc; font-weight:bold; text-align:right; ">627,75</td><td style="background-color:#ff99cc; font-weight:bold; text-align:right; ">301,70</td><td style="background-color:#ff99cc; font-weight:bold; text-align:right; ">48,06%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td style="font-weight:bold; "> </td><td style="font-weight:bold; "> </td><td style="font-weight:bold; "> </td><td style="font-weight:bold; "> </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >12</td><td style="background-color:#ff99cc; font-weight:bold; ">5 HZ-12 NZ</td><td style="background-color:#ff99cc; font-weight:bold; text-align:right; ">2010</td><td style="background-color:#ff99cc; font-weight:bold; ">SAMSTAG</td><td style="background-color:#ff99cc; font-weight:bold; ">Lotto-BZ-TG</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >13</td><td style="background-color:#99cc00; font-weight:bold; ">MONAT</td><td style="background-color:#99cc00; font-weight:bold; ">EINSATZ €</td><td style="background-color:#99cc00; font-weight:bold; ">GEWINN €</td><td style="background-color:#99cc00; font-weight:bold; ">Rücklauf %</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >14</td><td style="background-color:#ccffcc; font-weight:bold; ">Januar</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">116,25</td><td style="background-color:#ffff00; font-weight:bold; text-align:right; ">10,50</td><td style="background-color:#ccffff; font-weight:bold; text-align:right; ">9,03%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >15</td><td style="background-color:#ccffcc; font-weight:bold; ">Febraur</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">93,00</td><td style="background-color:#ffff00; font-weight:bold; "> </td><td style="background-color:#ccffff; font-weight:bold; "> </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >16</td><td style="background-color:#ccffcc; font-weight:bold; ">März</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">93,00</td><td style="background-color:#ffff00; font-weight:bold; "> </td><td style="background-color:#ccffff; font-weight:bold; "> </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >17</td><td style="background-color:#ccffcc; font-weight:bold; ">April</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">93,00</td><td style="background-color:#ffff00; font-weight:bold; "> </td><td style="background-color:#ccffff; font-weight:bold; "> </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >18</td><td style="background-color:#ccffcc; font-weight:bold; ">Mai</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">116,25</td><td style="background-color:#ffff00; font-weight:bold; "> </td><td style="background-color:#ccffff; font-weight:bold; "> </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >19</td><td style="background-color:#ccffcc; font-weight:bold; ">Juni</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">93,00</td><td style="background-color:#ffff00; font-weight:bold; "> </td><td style="background-color:#ccffff; font-weight:bold; "> </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >20</td><td style="background-color:#ccffcc; font-weight:bold; ">Juli</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">116,25</td><td style="background-color:#ffff00; font-weight:bold; "> </td><td style="background-color:#ccffff; font-weight:bold; "> </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >21</td><td style="background-color:#ccffcc; font-weight:bold; ">August</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">93,00</td><td style="background-color:#ffff00; font-weight:bold; "> </td><td style="background-color:#ccffff; font-weight:bold; "> </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >22</td><td style="background-color:#ccffcc; font-weight:bold; ">September</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">93,00</td><td style="background-color:#ffff00; font-weight:bold; "> </td><td style="background-color:#ccffff; font-weight:bold; "> </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >23</td><td style="background-color:#ccffcc; font-weight:bold; ">Oktober</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">116,25</td><td style="background-color:#ffff00; font-weight:bold; "> </td><td style="background-color:#ccffff; font-weight:bold; "> </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >24</td><td style="background-color:#ccffcc; font-weight:bold; ">November</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">93,00</td><td style="background-color:#ffff00; font-weight:bold; "> </td><td style="background-color:#ccffff; font-weight:bold; "> </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >25</td><td style="background-color:#ccffcc; font-weight:bold; ">Dezember</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">93,00</td><td style="background-color:#ffff00; font-weight:bold; "> </td><td style="background-color:#ccffff; font-weight:bold; "> </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >26</td><td style="background-color:#ff99cc; font-weight:bold; ">TOTAL 2010</td><td style="background-color:#ff99cc; font-weight:bold; text-align:right; ">1209,00</td><td style="background-color:#ff99cc; font-weight:bold; "> </td><td style="background-color:#ff99cc; font-weight:bold; "> </td></tr></table>
<table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b>Formeln der Tabelle</b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Zelle</td><td >Formel</td></tr><tr><td >B10</td><td >=SUMME(B3:B9)</td></tr></table></td></tr></table>
Excel Tabellen im Web darstellen >> <a style ="font-family:Arial; font-size:9pt; color:#fcf507; background-color:#800040; font-weight:bold;" href="http://www.excel-jeanie-html.de" target="_blank"> Excel Jeanie HTML 4 </a>
@all,
am 01.05.2010 wurde der letzte Tipp in der BZ-TG abgegeben - hier die abschließende Statistik:
<b>Tabelle1</b>
<table border="1" cellspacing="0" cellpadding="0" style="font-family:Arial,Arial; font-size:10pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:80px;" /><col style="width:80px;" /><col style="width:80px;" /><col style="width:80px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td><td >C</td><td >D</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >12</td><td style="background-color:#ff99cc; font-weight:bold; ">5 HZ-12 NZ</td><td style="background-color:#ff99cc; font-weight:bold; text-align:right; ">2010</td><td style="background-color:#ff99cc; font-weight:bold; ">SAMSTAG</td><td style="background-color:#ff99cc; font-weight:bold; ">Lotto-BZ-TG</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >13</td><td style="background-color:#99cc00; font-weight:bold; ">MONAT</td><td style="background-color:#99cc00; font-weight:bold; ">EINSATZ €</td><td style="background-color:#99cc00; font-weight:bold; ">GEWINN €</td><td style="background-color:#99cc00; font-weight:bold; ">Rücklauf %</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >14</td><td style="background-color:#ccffcc; font-weight:bold; ">Januar</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">116,25</td><td style="background-color:#ffff00; font-weight:bold; text-align:right; ">10,50</td><td style="background-color:#ccffff; font-weight:bold; text-align:right; ">9,03%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >15</td><td style="background-color:#ccffcc; font-weight:bold; ">Febraur</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">93,00</td><td style="background-color:#ffff00; font-weight:bold; text-align:right; ">75,60</td><td style="background-color:#ccffff; font-weight:bold; text-align:right; ">81,29%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >16</td><td style="background-color:#ccffcc; font-weight:bold; ">März</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">93,00</td><td style="background-color:#ffff00; font-weight:bold; text-align:right; ">10,60</td><td style="background-color:#ccffff; font-weight:bold; text-align:right; ">11,40%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >17</td><td style="background-color:#ccffcc; font-weight:bold; ">April</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">93,00</td><td style="background-color:#ffff00; font-weight:bold; text-align:right; ">0,00</td><td style="background-color:#ccffff; font-weight:bold; text-align:right; ">0,00%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >18</td><td style="background-color:#ccffcc; font-weight:bold; text-align:right; ">01.05.</td><td style="background-color:#ff9900; font-weight:bold; text-align:right; ">23,25</td><td style="background-color:#ffff00; font-weight:bold; text-align:right; ">0,00</td><td style="background-color:#ccffff; font-weight:bold; text-align:right; ">0,00%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >19</td><td style="background-color:#ff99cc; font-weight:bold; ">01-1.5. 2010</td><td style="background-color:#ff99cc; font-weight:bold; text-align:right; ">418,50</td><td style="background-color:#ff99cc; font-weight:bold; text-align:right; ">96,70</td><td style="background-color:#ff99cc; font-weight:bold; text-align:right; ">23,11%</td></tr></table>
<table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b>Formeln der Tabelle</b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Zelle</td><td >Formel</td></tr><tr><td >B19</td><td >=SUMME(B14:B18)</td></tr><tr><td >C19</td><td >=SUMME(C14:C18)</td></tr></table></td></tr></table>
Excel Tabellen im Web darstellen >> <a style ="font-family:Arial; font-size:9pt; color:#fcf507; background-color:#800040; font-weight:bold;" href="http://www.excel-jeanie-html.de" target="_blank"> Excel Jeanie HTML 4 </a>
Grüße, Liane
|