Beiträge: 1.063
Themen: 28
Registriert seit: Nov 2008
Bewertung:
0
Meine Zugehörigkeit in Harve's Power-TG´s ist mit sofortiger Wirkung beendet .
Ich wünsche Euch viel Glück.
Viele Grüße
Dieter
PS. Liane, ich steige nur bei Harve aus. Dem Forum bleibe ich erhalten!
Wer nicht wagt, der nicht gewinnt!
Leben und leben lassen.
Beiträge: 18.680
Themen: 347
Registriert seit: Nov 2008
Bewertung:
11
@all,
hier die TN für SAMSTAGLOTTO nach meinem derzeitigen Kenntnis-Stand:
<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;" /></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></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td style="background-color:#ffff00; ">TN-Liste</td><td style="background-color:#ffff00; ">Top-Gew.-TG</td><td style="background-color:#ffff00; ">SAMSTAG</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="background-color:#ffcc99; text-align:right; ">01.</td><td style="background-color:#ffcc00; ">Juliett</td><td style="background-color:#ff9900; "> </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="background-color:#ffcc99; text-align:right; ">02.</td><td style="background-color:#ffcc00; ">Karin</td><td style="background-color:#ff9900; "> </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td style="background-color:#ffcc99; text-align:right; ">03.</td><td style="background-color:#ffcc00; ">Liane</td><td style="background-color:#ff9900; "> </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td style="background-color:#ffcc99; text-align:right; ">04.</td><td style="background-color:#ffcc00; ">Peter</td><td style="background-color:#ff9900; "> </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td style="background-color:#ffcc99; text-align:right; ">05.</td><td style="background-color:#ffcc00; ">astralus</td><td style="background-color:#ff9900; "> </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td style="background-color:#ffcc99; text-align:right; ">06. </td><td style="background-color:#ffcc00; ">hessen-haas</td><td style="background-color:#ff9900; "> </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td style="background-color:#ffcc99; text-align:right; ">07.</td><td style="background-color:#ffcc00; ">Thomas</td><td style="background-color:#ff9900; "> </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td style="background-color:#ffcc99; text-align:right; ">08.</td><td style="background-color:#ffcc00; ">Macks68</td><td style="background-color:#ff9900; "> </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td style="background-color:#ffcc99; text-align:right; ">09.</td><td style="background-color:#ffcc00; ">ochjoo</td><td style="background-color:#ff9900; "> </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td style="background-color:#ffcc99; text-align:right; ">10.</td><td style="background-color:#ffcc00; ">Werner99</td><td style="background-color:#ff9900; "> </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >12</td><td style="background-color:#ffff99; text-align:right; ">11.</td><td style="background-color:#ffff99; ">Peter31</td><td style="background-color:#ffff99; ">bis Guth.weg</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >13</td><td style="background-color:#ffff99; text-align:right; ">12.</td><td style="background-color:#ffff99; ">erich</td><td style="background-color:#ffff99; ">bis Ende 08</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>
@Peter31 u. erich, es wäre toll, wenn Ihr weiterhin dabei bleiben würdet!
Conquistador (Peter) wird in Kürze sein neues System für SA hier vorstellen - eine Variante mit insg. 200 Reihen und alternativ mit 155 Reihen
Was das Organisatorische um SA betrifft (Systeme, Zahlen, Scheinabgabe, etc.) so möchte ich dies Peter überlassen, da ich bereits schon den MITTWOCH übernommen habe mit der System- u. Zahlenwahl u. Scheinabgabe.
also Peter - "die Bühne gehört Dir" :D
Grüße@all, Liane
Beiträge: 1.063
Themen: 28
Registriert seit: Nov 2008
Bewertung:
0
Hallo miteinander,
event. würde ich auch (wieder)einsteigen.
Schau mer mal, was Peter "aus dem Hut zaubert" :lol1: :huegli:
Viele Grüße
Dieter
Wer nicht wagt, der nicht gewinnt!
Leben und leben lassen.
Beiträge: 18.680
Themen: 347
Registriert seit: Nov 2008
Bewertung:
11
Zitat:Original von katzenkopf
Hallo miteinander,
event. würde ich auch (wieder)einsteigen.
Schau mer mal, was Peter "aus dem Hut zaubert" :lol1: :huegli:
Viele Grüße
Dieter
Dieter,
ich hab Dich schon mal in d. Tab. "platziert"
Grüße, Liane
<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;" /></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></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td style="background-color:#ffff00; ">TN-Liste</td><td style="background-color:#ffff00; ">Top-Gew.-TG</td><td style="background-color:#ffff00; ">SAMSTAG</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="background-color:#ffcc99; text-align:right; ">01.</td><td style="background-color:#ffcc00; ">Juliett</td><td style="background-color:#ff9900; "> </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="background-color:#ffcc99; text-align:right; ">02.</td><td style="background-color:#ffcc00; ">Karin</td><td style="background-color:#ff9900; "> </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td style="background-color:#ffcc99; text-align:right; ">03.</td><td style="background-color:#ffcc00; ">Liane</td><td style="background-color:#ff9900; "> </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td style="background-color:#ffcc99; text-align:right; ">04.</td><td style="background-color:#ffcc00; ">Peter</td><td style="background-color:#ff9900; "> </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td style="background-color:#ffcc99; text-align:right; ">05.</td><td style="background-color:#ffcc00; ">astralus</td><td style="background-color:#ff9900; "> </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td style="background-color:#ffcc99; text-align:right; ">06. </td><td style="background-color:#ffcc00; ">hessen-haas</td><td style="background-color:#ff9900; "> </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td style="background-color:#ffcc99; text-align:right; ">07.</td><td style="background-color:#ffcc00; ">Thomas</td><td style="background-color:#ff9900; "> </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td style="background-color:#ffcc99; text-align:right; ">08.</td><td style="background-color:#ffcc00; ">Macks68</td><td style="background-color:#ff9900; "> </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td style="background-color:#ffcc99; text-align:right; ">09.</td><td style="background-color:#ffcc00; ">ochjoo</td><td style="background-color:#ff9900; "> </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td style="background-color:#ffcc99; text-align:right; ">10.</td><td style="background-color:#ffcc00; ">Werner99</td><td style="background-color:#ff9900; "> </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >12</td><td style="background-color:#ffff99; text-align:right; ">11.</td><td style="background-color:#ffff99; ">Peter31</td><td style="background-color:#ffff99; ">bis Guth.weg</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >13</td><td style="background-color:#ffff99; text-align:right; ">12.</td><td style="background-color:#ffff99; ">erich</td><td style="background-color:#ffff99; ">bis Ende 08</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >14</td><td style="background-color:#ffff99; text-align:right; ">13.</td><td style="background-color:#ffff99; ">katzenkopf</td><td style="background-color:#ffff99; ">evtl</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: 7.037
Themen: 78
Registriert seit: Nov 2008
Bewertung:
2
Hallo @all
Zitat:also Peter - "die Bühne gehört Dir" :D
Danke Liane
Habe es ja schon im geschützten Bereich geschrieben, hier noch mal für alle:
nachfolgend unser System für Samstag
Nach einem Vorschlag von Juliett werden 5 Zahlenpools a´15 Zahlen gespielt.
10 fixe Zahlen, die mit Zahlen aus jeweils einer Dekade aufgefüllt werden.
Es wird also mit 35 Zahlen gespielt
Jeder Pool wird mit einem 40 Reihensystem kombiniert. Insgesamt also 200 Reihen
Jedes der 5 Systeme wurde nach folgenden Kriterien erstellt:
Endziffern
G/U
T/H
Primzahlen
Dekaden
Nach Möglichkeit wurden jeweils die statistisch am häufigtsen vorkommenden Kombinationen ermittelt.
Es wurde versucht eine Garantie mit einzubeziehen, was aber aufgrund der Filtereinstellungen nicht 100%ig gelang.
Aus diesem Grund wurde jedes der 5 Systeme mit den fehlenden Reihen ergänzt um folgende Garantie einzuhalten:
3 aus 4
3 aus 5
3 aus 6
zu jeweils 100%
dadurch ergibt sich eine unterschiedliche Reihengröße
Pool 1 + 2 = jeweils 44 Reihen
Pool 3 = 45 Reihen
Pool 4 = 41 Reihen
Pool 5 = 42 Reihen
insgesamt 216 Reihen. Kosten 168,30€
Die 10 fixen Zahlen wurden aus den Zahlen der letzten 30 Ziehungen ermittelt.
Nach ca. 6 Wochen könnte man über eine Anpassung der Zahlen nachdenken.
<b>Zahlenpools</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:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:32px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >C</td><td >D</td><td >E</td><td >F</td><td >G</td><td >H</td><td >I</td><td >J</td><td >K</td><td >L</td><td >M</td><td >N</td><td >O</td><td >P</td><td >Q</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">1</td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">2</td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">3</td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">4</td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">5</td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">6</td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">7</td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">8</td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">9</td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">10</td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">11</td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">12</td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">13</td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">14</td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">15</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">5</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">10</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">11</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">15</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">20</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">24</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">27</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">35</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">36</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">49</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">2</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">3</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">4</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">6</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">9</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">5</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">10</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">11</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">15</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">20</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">24</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">27</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">35</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">36</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">49</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">12</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">13</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">17</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">16</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">14</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">5</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">10</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">11</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">15</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">20</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">24</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">27</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">35</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">36</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">49</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">21</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">22</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">26</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">28</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">29</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >12</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">5</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">10</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">11</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">15</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">20</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">24</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">27</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">35</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">36</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">49</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">34</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">37</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">39</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">33</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">31</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >13</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">5</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">10</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">11</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">15</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">20</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">24</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">27</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">35</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">36</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">49</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">41</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">46</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">47</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">45</td><td style="color:#0000ff; background-color:#ffffcc; font-weight:bold; font-size:12pt; text-align:center; ">48</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>
Gruß Peter
Erfahrung ist eine nützliche Sache.
Leider macht man sie immer erst kurz nachdem man sie brauchte.
Beiträge: 18.680
Themen: 347
Registriert seit: Nov 2008
Bewertung:
11
<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:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >16</td><td style="background-color:#ffff00; ">TN-Liste</td><td style="background-color:#ffff00; ">Top-Gew.-TG</td><td style="background-color:#ffff00; ">SAMSTAG</td><td style="background-color:#ffff00; ">Anteile/TN</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >17</td><td style="background-color:#ffcc99; text-align:right; ">01.</td><td style="background-color:#ffcc00; ">Juliett</td><td style="background-color:#ff9900; text-align:right; "> 19,12 € </td><td style="background-color:#ccffcc; text-align:right; ">1,25</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >18</td><td style="background-color:#ffcc99; text-align:right; ">02.</td><td style="background-color:#ffcc00; ">Peter</td><td style="background-color:#ff9900; text-align:right; "> 19,12 € </td><td style="background-color:#ccffcc; text-align:right; ">1,25</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >19</td><td style="background-color:#ffcc99; text-align:right; ">03.</td><td style="background-color:#ffcc00; ">astralus</td><td style="background-color:#ff9900; text-align:right; "> 19,12 € </td><td style="background-color:#ccffcc; text-align:right; ">1,25</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >20</td><td style="background-color:#ffcc99; text-align:right; ">04.</td><td style="background-color:#ffcc00; ">erich</td><td style="background-color:#ff9900; text-align:right; "> 19,12 € </td><td style="background-color:#ccffcc; text-align:right; ">1,25</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >21</td><td style="background-color:#ffcc99; text-align:right; ">05.</td><td style="background-color:#ffcc00; ">Liane</td><td style="background-color:#ff9900; text-align:right; "> 15,29 € </td><td style="background-color:#ccffcc; text-align:right; ">1,00</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >22</td><td style="background-color:#ffcc99; text-align:right; ">06.</td><td style="background-color:#ffcc00; ">Karin</td><td style="background-color:#ff9900; text-align:right; "> 15,29 € </td><td style="background-color:#ccffcc; text-align:right; ">1,00</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >23</td><td style="background-color:#ffcc99; text-align:right; ">07.</td><td style="background-color:#ffcc00; ">hessen-haas</td><td style="background-color:#ff9900; text-align:right; "> 11,48 € </td><td style="background-color:#ccffcc; text-align:right; ">0,75</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >24</td><td style="background-color:#ffcc99; text-align:right; ">08.</td><td style="background-color:#ffcc00; ">Thomas</td><td style="background-color:#ff9900; text-align:right; "> 11,48 € </td><td style="background-color:#ccffcc; text-align:right; ">0,75</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >25</td><td style="background-color:#ffcc99; text-align:right; ">09.</td><td style="background-color:#ffcc00; ">Peter31</td><td style="background-color:#ff9900; text-align:right; "> 11,48 € </td><td style="background-color:#ccffcc; text-align:right; ">0,75</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >26</td><td style="background-color:#ffcc99; text-align:right; ">10.</td><td style="background-color:#ffcc00; ">katzenkopf</td><td style="background-color:#ff9900; text-align:right; "> 11,48 € </td><td style="background-color:#ccffcc; text-align:right; ">0,75</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >27</td><td style="background-color:#ffcc99; text-align:right; ">11.</td><td style="background-color:#ffcc00; ">Werner99</td><td style="background-color:#ff9900; text-align:right; "> 3,83 € </td><td style="background-color:#ccffcc; text-align:right; ">0,25</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >28</td><td style="background-color:#ffcc99; text-align:right; ">12.</td><td style="background-color:#ffcc00; ">Macks68</td><td style="background-color:#ff9900; text-align:right; "> 3,83 € </td><td style="background-color:#ccffcc; text-align:right; ">0,25</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >29</td><td style="background-color:#ffcc99; text-align:right; ">13.</td><td style="background-color:#ffcc00; ">ochjoo</td><td style="background-color:#ff9900; text-align:right; "> 3,83 € </td><td style="background-color:#ccffcc; text-align:right; ">0,25</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >30</td><td style="background-color:#ffcc99; text-align:right; ">14.</td><td style="background-color:#ffcc00; ">Daniel</td><td style="background-color:#ff9900; text-align:right; "> 3,83 € </td><td style="background-color:#ccffcc; text-align:right; ">0,25</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >31</td><td style="background-color:#ff0000; ">insgesamt</td><td style="background-color:#ff0000; "> </td><td style="background-color:#ff0000; text-align:right; "> 168,30 € </td><td style="background-color:#ff0000; text-align:right; ">11,00</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 >C31</td><td >=SUMME(C17:C30)</td></tr><tr><td >D31</td><td >=SUMME(D17:D30)</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,
hier die TN-Liste gemäß Peters Angaben - ich habe unsre Anteile anlehnend an die frühere Verteilung entspr. verteilt und hoffe, dass das so OK für alle ist...
Grüße, Liane
Beiträge: 18.680
Themen: 347
Registriert seit: Nov 2008
Bewertung:
11
durch Harve´s Wunsch, ab Samstag bei uns teilzunehmen, ergibt sich nachfolgend kleine Anteils-Veränderung wie folgt:
- katzenkopf = 0,50 Anteile
- Harve = 0,25 Anteile
Grüße, Liane
<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:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >16</td><td style="background-color:#ffff00; ">TN-Liste</td><td style="background-color:#ffff00; ">Top-Gew.-TG</td><td style="background-color:#ffff00; ">SAMSTAG</td><td style="background-color:#ffff00; ">Anteile/TN</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >17</td><td style="background-color:#ffcc99; text-align:right; ">01.</td><td style="background-color:#ffcc00; ">Juliett</td><td style="background-color:#ff9900; text-align:right; "> 19,12 € </td><td style="background-color:#ccffcc; text-align:right; ">1,25</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >18</td><td style="background-color:#ffcc99; text-align:right; ">02.</td><td style="background-color:#ffcc00; ">Peter</td><td style="background-color:#ff9900; text-align:right; "> 19,12 € </td><td style="background-color:#ccffcc; text-align:right; ">1,25</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >19</td><td style="background-color:#ffcc99; text-align:right; ">03.</td><td style="background-color:#ffcc00; ">astralus</td><td style="background-color:#ff9900; text-align:right; "> 19,12 € </td><td style="background-color:#ccffcc; text-align:right; ">1,25</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >20</td><td style="background-color:#ffcc99; text-align:right; ">04.</td><td style="background-color:#ffcc00; ">erich</td><td style="background-color:#ff9900; text-align:right; "> 19,12 € </td><td style="background-color:#ccffcc; text-align:right; ">1,25</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >21</td><td style="background-color:#ffcc99; text-align:right; ">05.</td><td style="background-color:#ffcc00; ">Liane</td><td style="background-color:#ff9900; text-align:right; "> 15,29 € </td><td style="background-color:#ccffcc; text-align:right; ">1,00</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >22</td><td style="background-color:#ffcc99; text-align:right; ">06.</td><td style="background-color:#ffcc00; ">Karin</td><td style="background-color:#ff9900; text-align:right; "> 15,29 € </td><td style="background-color:#ccffcc; text-align:right; ">1,00</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >23</td><td style="background-color:#ffcc99; text-align:right; ">07.</td><td style="background-color:#ffcc00; ">hessen-haas</td><td style="background-color:#ff9900; text-align:right; "> 11,48 € </td><td style="background-color:#ccffcc; text-align:right; ">0,75</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >24</td><td style="background-color:#ffcc99; text-align:right; ">08.</td><td style="background-color:#ffcc00; ">Thomas</td><td style="background-color:#ff9900; text-align:right; "> 11,48 € </td><td style="background-color:#ccffcc; text-align:right; ">0,75</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >25</td><td style="background-color:#ffcc99; text-align:right; ">09.</td><td style="background-color:#ffcc00; ">Peter31</td><td style="background-color:#ff9900; text-align:right; "> 11,48 € </td><td style="background-color:#ccffcc; text-align:right; ">0,75</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >26</td><td style="background-color:#ffcc99; text-align:right; ">10.</td><td style="background-color:#ffcc00; ">katzenkopf</td><td style="background-color:#ff9900; text-align:right; "> 7,65 € </td><td style="background-color:#ccffcc; text-align:right; ">0,50</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >27</td><td style="background-color:#ffcc99; text-align:right; ">11.</td><td style="background-color:#ffcc00; ">Werner99</td><td style="background-color:#ff9900; text-align:right; "> 3,83 € </td><td style="background-color:#ccffcc; text-align:right; ">0,25</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >28</td><td style="background-color:#ffcc99; text-align:right; ">12.</td><td style="background-color:#ffcc00; ">Macks68</td><td style="background-color:#ff9900; text-align:right; "> 3,83 € </td><td style="background-color:#ccffcc; text-align:right; ">0,25</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >29</td><td style="background-color:#ffcc99; text-align:right; ">13.</td><td style="background-color:#ffcc00; ">ochjoo</td><td style="background-color:#ff9900; text-align:right; "> 3,83 € </td><td style="background-color:#ccffcc; text-align:right; ">0,25</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >30</td><td style="background-color:#ffcc99; text-align:right; ">14.</td><td style="background-color:#ffcc00; ">Daniel</td><td style="background-color:#ff9900; text-align:right; "> 3,83 € </td><td style="background-color:#ccffcc; text-align:right; ">0,25</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >31</td><td style="background-color:#ffcc99; text-align:right; ">15.</td><td style="background-color:#ffcc00; ">Harve</td><td style="background-color:#ff9900; text-align:right; "> 3,83 € </td><td style="background-color:#ccffcc; text-align:right; ">0,25</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >32</td><td style="background-color:#ff0000; ">insgesamt</td><td style="background-color:#ff0000; "> </td><td style="background-color:#ff0000; text-align:right; "> 168,30 € </td><td style="background-color:#ff0000; text-align:right; ">11,00</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 >C32</td><td >=SUMME(C17:C31)</td></tr><tr><td >D32</td><td >=SUMME(D17:D31)</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.680
Themen: 347
Registriert seit: Nov 2008
Bewertung:
11
@all,
Peter31´s 0,75 Anteile sind AB SOFORT frei, da er aussteigt.
Da ich an Daniel bereits die Überweisung der SA-Einsätze mit Datum v. 18.08. veranlasst habe, müssen die 0,75 Anteile bis SA gebucht werden!!!
Falls keiner übernehme möchte, würde ich vorschlagen, die 11,48 Euro auf uns restl. 14 TN gleichmäßig zu verteilen - was dann 0,82 Euro mehr proTN wären
:was: vielleicht die beste Option..
Grüße, Liane
Beiträge: 18.680
Themen: 347
Registriert seit: Nov 2008
Bewertung:
11
@all,
wie bereits angekündigt, hier die leicht erhöhten Einsätze für SA-Lotto
Grüße, Liane
<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;" /><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><td >E</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >16</td><td style="background-color:#ffff00; ">TN-Liste</td><td style="background-color:#ffff00; ">Top-Gew.-TG</td><td style="background-color:#ffff00; ">SAMSTAG</td><td style="background-color:#ffff00; ">Anteile/TN</td><td style="background-color:#ffff00; ">%uale Vert.</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >17</td><td style="background-color:#ffcc99; text-align:right; ">01.</td><td style="background-color:#ffcc00; ">Juliett</td><td style="background-color:#ff9900; text-align:right; "> 19,94 € </td><td style="background-color:#ccffcc; text-align:right; ">1,30</td><td style="background-color:#ccffff; text-align:right; ">11,85%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >18</td><td style="background-color:#ffcc99; text-align:right; ">02.</td><td style="background-color:#ffcc00; ">Peter</td><td style="background-color:#ff9900; text-align:right; "> 19,94 € </td><td style="background-color:#ccffcc; text-align:right; ">1,30</td><td style="background-color:#ccffff; text-align:right; ">11,85%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >19</td><td style="background-color:#ffcc99; text-align:right; ">03.</td><td style="background-color:#ffcc00; ">astralus</td><td style="background-color:#ff9900; text-align:right; "> 19,94 € </td><td style="background-color:#ccffcc; text-align:right; ">1,30</td><td style="background-color:#ccffff; text-align:right; ">11,85%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >20</td><td style="background-color:#ffcc99; text-align:right; ">04.</td><td style="background-color:#ffcc00; ">erich</td><td style="background-color:#ff9900; text-align:right; "> 19,94 € </td><td style="background-color:#ccffcc; text-align:right; ">1,30</td><td style="background-color:#ccffff; text-align:right; ">11,85%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >21</td><td style="background-color:#ffcc99; text-align:right; ">05.</td><td style="background-color:#ffcc00; ">Liane</td><td style="background-color:#ff9900; text-align:right; "> 16,11 € </td><td style="background-color:#ccffcc; text-align:right; ">1,05</td><td style="background-color:#ccffff; text-align:right; ">9,57%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >22</td><td style="background-color:#ffcc99; text-align:right; ">06.</td><td style="background-color:#ffcc00; ">Karin</td><td style="background-color:#ff9900; text-align:right; "> 16,11 € </td><td style="background-color:#ccffcc; text-align:right; ">1,05</td><td style="background-color:#ccffff; text-align:right; ">9,57%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >23</td><td style="background-color:#ffcc99; text-align:right; ">07.</td><td style="background-color:#ffcc00; ">hessen-haas</td><td style="background-color:#ff9900; text-align:right; "> 12,30 € </td><td style="background-color:#ccffcc; text-align:right; ">0,80</td><td style="background-color:#ccffff; text-align:right; ">7,31%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >24</td><td style="background-color:#ffcc99; text-align:right; ">08.</td><td style="background-color:#ffcc00; ">Thomas</td><td style="background-color:#ff9900; text-align:right; "> 12,30 € </td><td style="background-color:#ccffcc; text-align:right; ">0,80</td><td style="background-color:#ccffff; text-align:right; ">7,31%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >25</td><td style="background-color:#ffcc99; text-align:right; ">09.</td><td style="background-color:#ffcc00; ">katzenkopf</td><td style="background-color:#ff9900; text-align:right; "> 8,47 € </td><td style="background-color:#ccffcc; text-align:right; ">0,60</td><td style="background-color:#ccffff; text-align:right; ">5,04%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >26</td><td style="background-color:#ffcc99; text-align:right; ">10.</td><td style="background-color:#ffcc00; ">Werner99</td><td style="background-color:#ff9900; text-align:right; "> 4,65 € </td><td style="background-color:#ccffcc; text-align:right; ">0,30</td><td style="background-color:#ccffff; text-align:right; ">2,76%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >27</td><td style="background-color:#ffcc99; text-align:right; ">11.</td><td style="background-color:#ffcc00; ">Macks68</td><td style="background-color:#ff9900; text-align:right; "> 4,65 € </td><td style="background-color:#ccffcc; text-align:right; ">0,30</td><td style="background-color:#ccffff; text-align:right; ">2,76%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >28</td><td style="background-color:#ffcc99; text-align:right; ">12.</td><td style="background-color:#ffcc00; ">ochjoo</td><td style="background-color:#ff9900; text-align:right; "> 4,65 € </td><td style="background-color:#ccffcc; text-align:right; ">0,30</td><td style="background-color:#ccffff; text-align:right; ">2,76%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >29</td><td style="background-color:#ffcc99; text-align:right; ">13.</td><td style="background-color:#ffcc00; ">Daniel</td><td style="background-color:#ff9900; text-align:right; "> 4,65 € </td><td style="background-color:#ccffcc; text-align:right; ">0,30</td><td style="background-color:#ccffff; text-align:right; ">2,76%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >30</td><td style="background-color:#ffcc99; text-align:right; ">14.</td><td style="background-color:#ffcc00; ">Harve</td><td style="background-color:#ff9900; text-align:right; "> 4,65 € </td><td style="background-color:#ccffcc; text-align:right; ">0,30</td><td style="background-color:#ccffff; text-align:right; ">2,76%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >31</td><td style="background-color:#ff0000; font-weight:bold; ">insgesamt</td><td style="background-color:#ff0000; font-weight:bold; "> </td><td style="background-color:#ff0000; font-weight:bold; text-align:right; "> 168,30 € </td><td style="background-color:#ff0000; font-weight:bold; text-align:right; ">11,00</td><td style="background-color:#ff0000; font-weight:bold; text-align:right; ">100,00%</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 >C31</td><td >=SUMME(C17:C30)</td></tr><tr><td >D31</td><td >=SUMME(D17:D30)</td></tr><tr><td >E31</td><td >=SUMME(E17:E30)</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.680
Themen: 347
Registriert seit: Nov 2008
Bewertung:
11
@all,
da Thomas seine Teilnahme beenden möchte - s. u. "Small Talk" - ergibt sich hieraus folgende neue Verteilung:
<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;" /><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><td >E</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >33</td><td style="background-color:#ffff00; ">TN-Liste</td><td style="background-color:#ffff00; ">Top-Gew.-TG</td><td style="background-color:#ffff00; ">SAMSTAG</td><td style="background-color:#ffff00; ">Anteile/TN</td><td style="background-color:#ffff00; ">%uale Vert.</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >34</td><td style="background-color:#ffcc99; text-align:right; ">01.</td><td style="background-color:#ffcc00; ">Juliett</td><td style="background-color:#ff9900; text-align:right; "> 20,88 € </td><td style="background-color:#ccffcc; text-align:right; ">1,36</td><td style="background-color:#ccffff; text-align:right; ">12,36%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >35</td><td style="background-color:#ffcc99; text-align:right; ">02.</td><td style="background-color:#ffcc00; ">Peter</td><td style="background-color:#ff9900; text-align:right; "> 20,88 € </td><td style="background-color:#ccffcc; text-align:right; ">1,36</td><td style="background-color:#ccffff; text-align:right; ">12,36%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >36</td><td style="background-color:#ffcc99; text-align:right; ">03.</td><td style="background-color:#ffcc00; ">astralus</td><td style="background-color:#ff9900; text-align:right; "> 20,88 € </td><td style="background-color:#ccffcc; text-align:right; ">1,36</td><td style="background-color:#ccffff; text-align:right; ">12,36%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >37</td><td style="background-color:#ffcc99; text-align:right; ">04.</td><td style="background-color:#ffcc00; ">erich</td><td style="background-color:#ff9900; text-align:right; "> 20,88 € </td><td style="background-color:#ccffcc; text-align:right; ">1,36</td><td style="background-color:#ccffff; text-align:right; ">12,36%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >38</td><td style="background-color:#ffcc99; text-align:right; ">05.</td><td style="background-color:#ffcc00; ">Liane</td><td style="background-color:#ff9900; text-align:right; "> 17,06 € </td><td style="background-color:#ccffcc; text-align:right; ">1,12</td><td style="background-color:#ccffff; text-align:right; ">10,19%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >39</td><td style="background-color:#ffcc99; text-align:right; ">06.</td><td style="background-color:#ffcc00; ">Karin</td><td style="background-color:#ff9900; text-align:right; "> 17,06 € </td><td style="background-color:#ccffcc; text-align:right; ">1,12</td><td style="background-color:#ccffff; text-align:right; ">10,19%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >40</td><td style="background-color:#ffcc99; text-align:right; ">07.</td><td style="background-color:#ffcc00; ">hessen-haas</td><td style="background-color:#ff9900; text-align:right; "> 13,25 € </td><td style="background-color:#ccffcc; text-align:right; ">0,86</td><td style="background-color:#ccffff; text-align:right; ">7,83%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >41</td><td style="background-color:#ffcc99; text-align:right; ">08.</td><td style="background-color:#ffcc00; ">katzenkopf</td><td style="background-color:#ff9900; text-align:right; "> 9,41 € </td><td style="background-color:#ccffcc; text-align:right; ">0,66</td><td style="background-color:#ccffff; text-align:right; ">6,00%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >42</td><td style="background-color:#ffcc99; text-align:right; ">09.</td><td style="background-color:#ffcc00; ">Werner99</td><td style="background-color:#ff9900; text-align:right; "> 5,60 € </td><td style="background-color:#ccffcc; text-align:right; ">0,36</td><td style="background-color:#ccffff; text-align:right; ">3,27%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >43</td><td style="background-color:#ffcc99; text-align:right; ">10.</td><td style="background-color:#ffcc00; ">Macks68</td><td style="background-color:#ff9900; text-align:right; "> 5,60 € </td><td style="background-color:#ccffcc; text-align:right; ">0,36</td><td style="background-color:#ccffff; text-align:right; ">3,27%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >44</td><td style="background-color:#ffcc99; text-align:right; ">11.</td><td style="background-color:#ffcc00; ">ochjoo</td><td style="background-color:#ff9900; text-align:right; "> 5,60 € </td><td style="background-color:#ccffcc; text-align:right; ">0,36</td><td style="background-color:#ccffff; text-align:right; ">3,27%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >45</td><td style="background-color:#ffcc99; text-align:right; ">12.</td><td style="background-color:#ffcc00; ">Daniel</td><td style="background-color:#ff9900; text-align:right; "> 5,60 € </td><td style="background-color:#ccffcc; text-align:right; ">0,36</td><td style="background-color:#ccffff; text-align:right; ">3,27%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >46</td><td style="background-color:#ffcc99; text-align:right; ">13.</td><td style="background-color:#ffcc00; ">Harve</td><td style="background-color:#ff9900; text-align:right; "> 5,60 € </td><td style="background-color:#ccffcc; text-align:right; ">0,36</td><td style="background-color:#ccffff; text-align:right; ">3,27%</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >47</td><td style="background-color:#ff0000; font-weight:bold; ">insgesamt</td><td style="background-color:#ff0000; font-weight:bold; "> </td><td style="background-color:#ff0000; font-weight:bold; text-align:right; "> 168,30 € </td><td style="background-color:#ff0000; font-weight:bold; text-align:right; ">11,00</td><td style="background-color:#ff0000; font-weight:bold; text-align:right; ">100,00%</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 >C47</td><td >=SUMME(C33:C46)</td></tr><tr><td >D47</td><td >=SUMME(D34:D46)</td></tr><tr><td >E47</td><td >=SUMME(E33:E46)</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>
DIE EINSÄTZE WURDEN IN DER ABRECHNUNG PER 08.09. ABGEZOGEN !!!
Grüße, Liane
|