9 Jahre LTS Extra TG (aktueller Stand)

[Peter K.]

Hi Tower,

natürlich hast Du recht, daß man mit einem Fangsystem aus 65 Reihen 7er-Vollsystemen
kaum einen Fisch vom Teller ziehen kann.

Deswegen bin ich ja auch KEIN Freund von Fangsystemen.


Und trotzdem habe ich diese TG gepuscht.


Nach der Schließung des Foren-Konto vor einem Jahr,
ist dies wieder das erste Mal, daß was größeres auf die Beine gestellt wird.


Und außerdem ist diese Geburtstags-TG reiner Spaß an der Freude.


Bei 3 Treffern wird KEIN großer Spaß aufkommen.
Da kann Liane den Rücklauf gleich für die Serverkosten an Norbert überweisen.

Ab 4 Treffern kann man dann schon mal genauer hingucken.
Da kommt man dann schon mal in den Bereich von 50 % Rücklauf.


Beste Grüße

Peter K.
.

[snickers0879]

Original von Liane

Original von Liane
Tabelle1  ABCDEF2 TeilnehmerAnteileEinsatz / TN%ualer Ant.Geldeingang31markus7310         72,00 €  Abrg. Privat42Ecart10         72,00 €  06.11.201753Peter K.5         36,00 €   64Liane5         36,00 €  KASSE75Lustiger Astronaut4         28,80 €  verrechnet mit Sylvester-TG86tommyk3         21,60 €  Abrg. Privat97snickers08793         21,60 €   108Matrix3         21,60 €   119lo-lue3         21,60 €  06.11.20171210Meggie3         21,60 €   1311Maximus2         14,40 €  Abrg. Privat1412skodakeule1            7,20 €  06.11.20171513didi19521            7,20 €  06.11.20171614Oli1            7,20 €   1715Olibe1            7,20 €   1816Hujuk1            7,20 €  Verrechnung mit HQ-Gewinn nach 08.11.1917Norbert1            7,20 €   20      21      22GESAMT 57       410,40 €   Formeln der TabelleZelleFormelC22=SUMME(C3:C21)D22=SUMME(D3:D21) Excel Tabellen im Web darstellen >> Excel Jeanie HTML 4


VG, Liane

Maximus, Peter K. und alle (zukünftigen) TN der Forum-Geburtststag-TG,

danke für euer Feedback

folgende "Spielregeln" gelten nun für unsere TG :

1.
Maximus hat Recht - "Vor-Feiern bringt Unglück und ist ein NOGO" ....es wird somit KEINE Abgabe am 15.11.2017 erfolgen

2.
gespielt wird am 18.11.2017 - "Geburstag" - NUR unter der Voraussetzung, dass an diesem Tag der JP immer noch besteht !!

3.
sollte der JP weg sein, so wird die Abgabe verschoben, bis der JP die "10-Mio-Marke" wieder erreicht hat !!

4.
d. h. dass ihr eure Anteile "JP-gemäß" buchen könnt :D


5.
den Annahmeschluss lege ich nun auf

Montag, 13.11.2017

spätere Bestellungen bzw. Anteile-Änderungen können aus zeitlichen Gründen nicht mehr berücksichtigt werden.


VG, Liane

falls der Annahmeschluss vorgezogen wird, bitte Bescheid geben, ich liege schon die ganze Woche mit einer fetten Erkältung flach und komm daher erst Morgen am Freitag zur Bank um den Einsatz zu überweisen.
Falls das zu spät ist, bitte meine Anteile stornieren.

[Peter K.]

:tor:


Hier nun noch die Gewinntabellen für das 65-Reihen-7er-System :











Die jeweils linken Tabellen sind in der Wertigkeit aufsteigend sortiert.

Die jeweils rechten Tabellen sind nach der prozentualen Häufigkeit absteigend sortiert.


Lesebeispiel 3 Treffer im Zahlenpool :

In 96,1 % der Fälle werden in 1 bezw. 2 Vollsystemen 3 Richtige erzielt.

Das 7er-Vollsystem bringt bei 3 Treffern 4 x 3 Richtige.

Die Ergebnisse der obigen Tabellen müssen also noch mit 4 multipliziert werden.


Das Gesamtergebnis bei 3 Treffern im Zahlenpool ist also zu 96,1 %

4 x 3 Richtige bezw. 8 x 3 Richtige



Trotzdem lassen wir uns den Spaß an der Freude nicht verderben

und hoffen natürlich auf mehr Treffer in unserem Zahlenpool


Beste Grüße und viel Spaß beim Mehren der Erkenntnisse.

Peter K.
.

[Snuffx]

Ich nehme bitte 3 Anteile

danke

[Liane]

Original von Snuffx
Ich nehme bitte 3 Anteile

danke

:danke:


++++++++++


<b>Tabelle1</b>

<table border="1" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:79px;" /><col style="width:121px;" /><col style="width:53px;" /><col style="width:79px;" /><col style="width:85px;" /><col style="width:182px;" /></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><td >F</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="font-weight:bold; "> </td><td style="font-weight:bold; ">Teilnehmer</td><td style="font-weight:bold; ">Anteile</td><td style="font-weight:bold; ">Einsatz / TN</td><td style="font-weight:bold; ">%ualer Ant.</td><td style="background-color:#ffff00; font-weight:bold; ">Geldeingang</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td > </td><td style="background-color:#ffff00; ">markus73</td><td style="background-color:#ffff00; text-align:right; ">10</td><td style="background-color:#ffff00; text-align:right; ">         72,00 € </td><td style="background-color:#ffff00; "> </td><td style="background-color:#ffff00; ">Abrg. Privat</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td > </td><td style="background-color:#ffff00; ">Ecart</td><td style="background-color:#ffff00; text-align:right; ">10</td><td style="background-color:#ffff00; text-align:right; ">         72,00 € </td><td style="background-color:#ffff00; "> </td><td style="background-color:#ffff00; text-align:right; ">06.11.2017</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td > </td><td >Peter K.</td><td style="text-align:right; ">5</td><td style="text-align:right; ">         36,00 € </td><td > </td><td > </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td > </td><td >Liane</td><td style="text-align:right; ">5</td><td style="text-align:right; ">         36,00 € </td><td > </td><td >KASSE</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td > </td><td style="background-color:#ffff00; ">Lustiger Astronaut</td><td style="background-color:#ffff00; text-align:right; ">4</td><td style="background-color:#ffff00; text-align:right; ">         28,80 € </td><td style="background-color:#ffff00; "> </td><td style="background-color:#ffff00; ">verrechnet mit Sylvester-TG</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td > </td><td style="background-color:#ffff00; ">tommyk</td><td style="background-color:#ffff00; text-align:right; ">3</td><td style="background-color:#ffff00; text-align:right; ">         21,60 € </td><td style="background-color:#ffff00; "> </td><td style="background-color:#ffff00; ">Abrg. Privat</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td > </td><td >snickers0879</td><td style="text-align:right; ">3</td><td style="text-align:right; ">         21,60 € </td><td > </td><td > </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td > </td><td >Matrix</td><td style="text-align:right; ">3</td><td style="text-align:right; ">         21,60 € </td><td > </td><td > </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td > </td><td style="background-color:#ffff00; ">lo-lue</td><td style="background-color:#ffff00; text-align:right; ">3</td><td style="background-color:#ffff00; text-align:right; ">         21,60 € </td><td style="background-color:#ffff00; "> </td><td style="background-color:#ffff00; text-align:right; ">06.11.2017</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >12</td><td > </td><td >Meggie</td><td style="text-align:right; ">3</td><td style="text-align:right; ">         21,60 € </td><td > </td><td > </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >13</td><td > </td><td style="background-color:#ffff00; ">Maximus</td><td style="background-color:#ffff00; text-align:right; ">2</td><td style="background-color:#ffff00; text-align:right; ">         14,40 € </td><td style="background-color:#ffff00; "> </td><td style="background-color:#ffff00; ">Abrg. Privat</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >14</td><td > </td><td style="background-color:#ffff00; ">Bruder Maximus</td><td style="background-color:#ffff00; text-align:right; ">2</td><td style="background-color:#ffff00; text-align:right; ">         14,40 € </td><td style="background-color:#ffff00; "> </td><td style="background-color:#ffff00; ">Abrg. Privat</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >15</td><td > </td><td style="background-color:#ffff00; ">skodakeule</td><td style="background-color:#ffff00; text-align:right; ">1</td><td style="background-color:#ffff00; text-align:right; ">            7,20 € </td><td style="background-color:#ffff00; "> </td><td style="background-color:#ffff00; text-align:right; ">06.11.2017</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >16</td><td > </td><td style="background-color:#ffff00; ">didi1952</td><td style="background-color:#ffff00; text-align:right; ">1</td><td style="background-color:#ffff00; text-align:right; ">            7,20 € </td><td style="background-color:#ffff00; "> </td><td style="background-color:#ffff00; text-align:right; ">06.11.2017</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >17</td><td > </td><td >Oli</td><td style="text-align:right; ">1</td><td style="text-align:right; ">            7,20 € </td><td > </td><td > </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >18</td><td > </td><td >Olibe</td><td style="text-align:right; ">1</td><td style="text-align:right; ">            7,20 € </td><td > </td><td > </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >19</td><td > </td><td style="background-color:#ffcc99; ">Hujuk</td><td style="background-color:#ffcc99; text-align:right; ">1</td><td style="background-color:#ffcc99; text-align:right; ">            7,20 € </td><td style="background-color:#ffcc99; "> </td><td style="background-color:#ffcc99; ">Verrechnung mit HQ-Gewinn nach 08.11.</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >20</td><td > </td><td style="background-color:#ffff00; ">Norbert</td><td style="background-color:#ffff00; text-align:right; ">1</td><td style="background-color:#ffff00; text-align:right; ">            7,20 € </td><td style="background-color:#ffff00; "> </td><td style="background-color:#ffff00; text-align:right; ">09.11.2017</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >21</td><td > </td><td style="background-color:#ffff00; ">fatimi</td><td style="background-color:#ffff00; text-align:right; ">3</td><td style="background-color:#ffff00; text-align:right; ">         21,60 € </td><td style="background-color:#ffff00; "> </td><td style="background-color:#ffff00; text-align:right; ">09.11.2017</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >22</td><td style="font-weight:bold; "> </td><td >Snuffx</td><td style="text-align:right; ">3</td><td style="text-align:right; ">         21,60 € </td><td > </td><td > </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >23</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >24</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >25</td><td style="font-weight:bold; ">GESAMT</td><td style="font-weight:bold; "> </td><td style="font-weight:bold; text-align:right; ">65</td><td style="font-weight:bold; text-align:right; ">       468,00 € </td><td style="font-weight:bold; "> </td><td style="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 >C25</td><td >=SUMME(C3:C24)</td></tr><tr><td >D25</td><td >=SUMME(D3:D24)</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=



VG, Liane

[Liane]

Original von didi1952
Hallo Liane
Ich nehme noch 1.Anteil wenn es geht.
didi

didi,

sorry, hab ich fast übersehen !

klar geht das, die Bankverbindung hast ja schon !

danke dir und VG

Liane

+++++++++++++++++


<b>Tabelle1</b>

<table border="1" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:79px;" /><col style="width:121px;" /><col style="width:53px;" /><col style="width:79px;" /><col style="width:85px;" /><col style="width:182px;" /></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><td >F</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="font-weight:bold; "> </td><td style="font-weight:bold; ">Teilnehmer</td><td style="font-weight:bold; ">Anteile</td><td style="font-weight:bold; ">Einsatz / TN</td><td style="font-weight:bold; ">%ualer Ant.</td><td style="background-color:#ffff00; font-weight:bold; ">Geldeingang</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td > </td><td style="background-color:#ffff00; ">markus73</td><td style="background-color:#ffff00; text-align:right; ">10</td><td style="background-color:#ffff00; text-align:right; ">         72,00 € </td><td style="background-color:#ffff00; "> </td><td style="background-color:#ffff00; ">Abrg. Privat</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td > </td><td style="background-color:#ffff00; ">Ecart</td><td style="background-color:#ffff00; text-align:right; ">10</td><td style="background-color:#ffff00; text-align:right; ">         72,00 € </td><td style="background-color:#ffff00; "> </td><td style="background-color:#ffff00; text-align:right; ">06.11.2017</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td > </td><td >Peter K.</td><td style="text-align:right; ">5</td><td style="text-align:right; ">         36,00 € </td><td > </td><td > </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td > </td><td >Liane</td><td style="text-align:right; ">5</td><td style="text-align:right; ">         36,00 € </td><td > </td><td >KASSE</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td > </td><td style="background-color:#ffff00; ">Lustiger Astronaut</td><td style="background-color:#ffff00; text-align:right; ">4</td><td style="background-color:#ffff00; text-align:right; ">         28,80 € </td><td style="background-color:#ffff00; "> </td><td style="background-color:#ffff00; ">verrechnet mit Sylvester-TG</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td > </td><td style="background-color:#ffff00; ">tommyk</td><td style="background-color:#ffff00; text-align:right; ">3</td><td style="background-color:#ffff00; text-align:right; ">         21,60 € </td><td style="background-color:#ffff00; "> </td><td style="background-color:#ffff00; ">Abrg. Privat</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td > </td><td >snickers0879</td><td style="text-align:right; ">3</td><td style="text-align:right; ">         21,60 € </td><td > </td><td > </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td > </td><td >Matrix</td><td style="text-align:right; ">3</td><td style="text-align:right; ">         21,60 € </td><td > </td><td > </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td > </td><td style="background-color:#ffff00; ">lo-lue</td><td style="background-color:#ffff00; text-align:right; ">3</td><td style="background-color:#ffff00; text-align:right; ">         21,60 € </td><td style="background-color:#ffff00; "> </td><td style="background-color:#ffff00; text-align:right; ">06.11.2017</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >12</td><td > </td><td >Meggie</td><td style="text-align:right; ">3</td><td style="text-align:right; ">         21,60 € </td><td > </td><td > </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >13</td><td > </td><td style="background-color:#ffff00; ">Maximus</td><td style="background-color:#ffff00; text-align:right; ">2</td><td style="background-color:#ffff00; text-align:right; ">         14,40 € </td><td style="background-color:#ffff00; "> </td><td style="background-color:#ffff00; ">Abrg. Privat</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >14</td><td > </td><td style="background-color:#ffff00; ">Bruder Maximus</td><td style="background-color:#ffff00; text-align:right; ">2</td><td style="background-color:#ffff00; text-align:right; ">         14,40 € </td><td style="background-color:#ffff00; "> </td><td style="background-color:#ffff00; ">Abrg. Privat</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >15</td><td > </td><td style="background-color:#ffff00; ">skodakeule</td><td style="background-color:#ffff00; text-align:right; ">1</td><td style="background-color:#ffff00; text-align:right; ">            7,20 € </td><td style="background-color:#ffff00; "> </td><td style="background-color:#ffff00; text-align:right; ">06.11.2017</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >16</td><td > </td><td style="background-color:#ffff00; ">didi1952</td><td style="background-color:#ffff00; text-align:right; ">1</td><td style="background-color:#ffff00; text-align:right; ">            7,20 € </td><td style="background-color:#ffff00; "> </td><td style="background-color:#ffff00; text-align:right; ">06.11.2017</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >17</td><td > </td><td >Oli</td><td style="text-align:right; ">1</td><td style="text-align:right; ">            7,20 € </td><td > </td><td > </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >18</td><td > </td><td >Olibe</td><td style="text-align:right; ">1</td><td style="text-align:right; ">            7,20 € </td><td > </td><td > </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >19</td><td > </td><td style="background-color:#ffcc99; ">Hujuk</td><td style="background-color:#ffcc99; text-align:right; ">1</td><td style="background-color:#ffcc99; text-align:right; ">            7,20 € </td><td style="background-color:#ffcc99; "> </td><td style="background-color:#ffcc99; ">Verrechnung mit HQ-Gewinn nach 08.11.</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >20</td><td > </td><td style="background-color:#ffff00; ">Norbert</td><td style="background-color:#ffff00; text-align:right; ">1</td><td style="background-color:#ffff00; text-align:right; ">            7,20 € </td><td style="background-color:#ffff00; "> </td><td style="background-color:#ffff00; text-align:right; ">09.11.2017</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >21</td><td > </td><td style="background-color:#ffff00; ">fatimi</td><td style="background-color:#ffff00; text-align:right; ">3</td><td style="background-color:#ffff00; text-align:right; ">         21,60 € </td><td style="background-color:#ffff00; "> </td><td style="background-color:#ffff00; text-align:right; ">09.11.2017</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >22</td><td style="font-weight:bold; "> </td><td >Snuffx</td><td style="text-align:right; ">3</td><td style="text-align:right; ">         21,60 € </td><td > </td><td > </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >23</td><td > </td><td >didi1952</td><td style="text-align:right; ">1</td><td style="text-align:right; ">            7,20 € </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >24</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >25</td><td style="font-weight:bold; ">GESAMT</td><td style="font-weight:bold; "> </td><td style="font-weight:bold; text-align:right; ">66</td><td style="font-weight:bold; text-align:right; ">       475,20 € </td><td style="font-weight:bold; "> </td><td style="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 >C25</td><td >=SUMME(C3:C24)</td></tr><tr><td >D25</td><td >=SUMME(D3:D24)</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>

[Liane]

<b>Tabelle1</b>

<table border="1" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:79px;" /><col style="width:121px;" /><col style="width:53px;" /><col style="width:79px;" /><col style="width:85px;" /><col style="width:182px;" /></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><td >F</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="font-weight:bold; "> </td><td style="font-weight:bold; ">Teilnehmer</td><td style="font-weight:bold; ">Anteile</td><td style="font-weight:bold; ">Einsatz / TN</td><td style="font-weight:bold; ">%ualer Ant.</td><td style="background-color:#ffff00; font-weight:bold; ">Geldeingang</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td > </td><td style="background-color:#ffff00; ">markus73</td><td style="background-color:#ffff00; text-align:right; ">10</td><td style="background-color:#ffff00; text-align:right; ">         72,00 € </td><td style="background-color:#ffff00; "> </td><td style="background-color:#ffff00; ">Abrg. Privat</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td > </td><td style="background-color:#ffff00; ">Ecart</td><td style="background-color:#ffff00; text-align:right; ">10</td><td style="background-color:#ffff00; text-align:right; ">         72,00 € </td><td style="background-color:#ffff00; "> </td><td style="background-color:#ffff00; text-align:right; ">06.11.2017</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td > </td><td >Peter K.</td><td style="text-align:right; ">5</td><td style="text-align:right; ">         36,00 € </td><td > </td><td > </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td > </td><td >Liane</td><td style="text-align:right; ">5</td><td style="text-align:right; ">         36,00 € </td><td > </td><td >KASSE</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td > </td><td style="background-color:#ffff00; ">Lustiger Astronaut</td><td style="background-color:#ffff00; text-align:right; ">4</td><td style="background-color:#ffff00; text-align:right; ">         28,80 € </td><td style="background-color:#ffff00; "> </td><td style="background-color:#ffff00; ">verrechnet mit Sylvester-TG</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td > </td><td style="background-color:#ffff00; ">tommyk</td><td style="background-color:#ffff00; text-align:right; ">3</td><td style="background-color:#ffff00; text-align:right; ">         21,60 € </td><td style="background-color:#ffff00; "> </td><td style="background-color:#ffff00; ">Abrg. Privat</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td > </td><td >snickers0879</td><td style="text-align:right; ">3</td><td style="text-align:right; ">         21,60 € </td><td > </td><td > </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td > </td><td >Matrix</td><td style="text-align:right; ">3</td><td style="text-align:right; ">         21,60 € </td><td > </td><td > </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td > </td><td style="background-color:#ffff00; ">lo-lue</td><td style="background-color:#ffff00; text-align:right; ">3</td><td style="background-color:#ffff00; text-align:right; ">         21,60 € </td><td style="background-color:#ffff00; "> </td><td style="background-color:#ffff00; text-align:right; ">06.11.2017</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >12</td><td > </td><td >Meggie</td><td style="text-align:right; ">3</td><td style="text-align:right; ">         21,60 € </td><td > </td><td > </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >13</td><td > </td><td style="background-color:#ffff00; ">Maximus</td><td style="background-color:#ffff00; text-align:right; ">2</td><td style="background-color:#ffff00; text-align:right; ">         14,40 € </td><td style="background-color:#ffff00; "> </td><td style="background-color:#ffff00; ">Abrg. Privat</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >14</td><td > </td><td style="background-color:#ffff00; ">Bruder Maximus</td><td style="background-color:#ffff00; text-align:right; ">2</td><td style="background-color:#ffff00; text-align:right; ">         14,40 € </td><td style="background-color:#ffff00; "> </td><td style="background-color:#ffff00; ">Abrg. Privat</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >15</td><td > </td><td style="background-color:#ffff00; ">skodakeule</td><td style="background-color:#ffff00; text-align:right; ">1</td><td style="background-color:#ffff00; text-align:right; ">            7,20 € </td><td style="background-color:#ffff00; "> </td><td style="background-color:#ffff00; text-align:right; ">06.11.2017</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >16</td><td > </td><td style="background-color:#ffff00; ">didi1952</td><td style="background-color:#ffff00; text-align:right; ">1</td><td style="background-color:#ffff00; text-align:right; ">            7,20 € </td><td style="background-color:#ffff00; "> </td><td style="background-color:#ffff00; text-align:right; ">06.11.2017</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >17</td><td > </td><td >Oli</td><td style="text-align:right; ">1</td><td style="text-align:right; ">            7,20 € </td><td > </td><td > </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >18</td><td > </td><td >Olibe</td><td style="text-align:right; ">1</td><td style="text-align:right; ">            7,20 € </td><td > </td><td > </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >19</td><td > </td><td style="background-color:#ffcc99; ">Hujuk</td><td style="background-color:#ffcc99; text-align:right; ">1</td><td style="background-color:#ffcc99; text-align:right; ">            7,20 € </td><td style="background-color:#ffcc99; "> </td><td style="background-color:#ffcc99; ">Verrechnung mit HQ-Gewinn nach 08.11.</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >20</td><td > </td><td style="background-color:#ffff00; ">Norbert</td><td style="background-color:#ffff00; text-align:right; ">1</td><td style="background-color:#ffff00; text-align:right; ">            7,20 € </td><td style="background-color:#ffff00; "> </td><td style="background-color:#ffff00; text-align:right; ">09.11.2017</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >21</td><td > </td><td style="background-color:#ffff00; ">fatimi</td><td style="background-color:#ffff00; text-align:right; ">3</td><td style="background-color:#ffff00; text-align:right; ">         21,60 € </td><td style="background-color:#ffff00; "> </td><td style="background-color:#ffff00; text-align:right; ">09.11.2017</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >22</td><td style="font-weight:bold; "> </td><td >Snuffx</td><td style="text-align:right; ">3</td><td style="text-align:right; ">         21,60 € </td><td > </td><td > </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >23</td><td > </td><td >didi1952</td><td style="text-align:right; ">1</td><td style="text-align:right; ">            7,20 € </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >24</td><td > </td><td >skodakeule</td><td style="text-align:right; ">1</td><td style="text-align:right; ">            7,20 € </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >25</td><td style="font-weight:bold; ">GESAMT</td><td style="font-weight:bold; "> </td><td style="font-weight:bold; text-align:right; ">67</td><td style="font-weight:bold; text-align:right; ">       482,40 € </td><td style="font-weight:bold; "> </td><td style="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 >C25</td><td >=SUMME(C3:C24)</td></tr><tr><td >D25</td><td >=SUMME(D3:D24)</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>


....und noch einen weiteren Anteil für skoda (PN) - :danke:

VG, Liane

[Peter K.]

:tor:


Das nächste Etappenziel - 23er-Zahlenpool - erreicht und überschritten :





:tor:

[tommyk]

ich erhöhe auf 10 Anteile

[Liane]

Original von tommyk
ich erhöhe auf 10 Anteile

:kuss: :danke: :D


<b>Tabelle1</b>

<table border="1" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:121px;" /><col style="width:53px;" /><col style="width:79px;" /><col style="width:85px;" /><col style="width:182px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >B</td><td >C</td><td >D</td><td >E</td><td >F</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="font-weight:bold; ">Teilnehmer</td><td style="font-weight:bold; ">Anteile</td><td style="font-weight:bold; ">Einsatz / TN</td><td style="font-weight:bold; ">%ualer Ant.</td><td style="background-color:#ffff00; font-weight:bold; ">Geldeingang</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="background-color:#ffff00; ">markus73</td><td style="background-color:#ffff00; text-align:right; ">10</td><td style="background-color:#ffff00; text-align:right; ">         72,00 € </td><td style="background-color:#ffff00; "> </td><td style="background-color:#ffff00; ">Abrg. Privat</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td style="background-color:#ffff00; ">Ecart</td><td style="background-color:#ffff00; text-align:right; ">10</td><td style="background-color:#ffff00; text-align:right; ">         72,00 € </td><td style="background-color:#ffff00; "> </td><td style="background-color:#ffff00; text-align:right; ">06.11.2017</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td style="background-color:#ffff00; ">tommyk</td><td style="background-color:#ffff00; text-align:right; ">10</td><td style="background-color:#ffff00; text-align:right; ">         72,00 € </td><td style="background-color:#ffff00; "> </td><td style="background-color:#ffff00; ">Abrg. Privat</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td >Peter K.</td><td style="text-align:right; ">5</td><td style="text-align:right; ">         36,00 € </td><td > </td><td > </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td style="background-color:#969696; ">Liane</td><td style="background-color:#969696; text-align:right; ">5</td><td style="background-color:#969696; text-align:right; ">         36,00 € </td><td style="background-color:#969696; "> </td><td style="background-color:#969696; ">KASSE</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td style="background-color:#ffff00; ">Lustiger Astronaut</td><td style="background-color:#ffff00; text-align:right; ">4</td><td style="background-color:#ffff00; text-align:right; ">         28,80 € </td><td style="background-color:#ffff00; "> </td><td style="background-color:#ffff00; ">verrechnet mit Sylvester-TG</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td >snickers0879</td><td style="text-align:right; ">3</td><td style="text-align:right; ">         21,60 € </td><td > </td><td > </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td >Matrix</td><td style="text-align:right; ">3</td><td style="text-align:right; ">         21,60 € </td><td > </td><td > </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td style="background-color:#ffff00; ">lo-lue</td><td style="background-color:#ffff00; text-align:right; ">3</td><td style="background-color:#ffff00; text-align:right; ">         21,60 € </td><td style="background-color:#ffff00; "> </td><td style="background-color:#ffff00; text-align:right; ">06.11.2017</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >12</td><td >Meggie</td><td style="text-align:right; ">3</td><td style="text-align:right; ">         21,60 € </td><td > </td><td > </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >13</td><td style="background-color:#ffff00; ">Maximus</td><td style="background-color:#ffff00; text-align:right; ">2</td><td style="background-color:#ffff00; text-align:right; ">         14,40 € </td><td style="background-color:#ffff00; "> </td><td style="background-color:#ffff00; ">Abrg. Privat</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >14</td><td style="background-color:#ffff00; ">Bruder Maximus</td><td style="background-color:#ffff00; text-align:right; ">2</td><td style="background-color:#ffff00; text-align:right; ">         14,40 € </td><td style="background-color:#ffff00; "> </td><td style="background-color:#ffff00; ">Abrg. Privat</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >15</td><td style="background-color:#ffff00; ">skodakeule</td><td style="background-color:#ffff00; text-align:right; ">1</td><td style="background-color:#ffff00; text-align:right; ">            7,20 € </td><td style="background-color:#ffff00; "> </td><td style="background-color:#ffff00; text-align:right; ">06.11.2017</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >16</td><td style="background-color:#ffff00; ">didi1952</td><td style="background-color:#ffff00; text-align:right; ">1</td><td style="background-color:#ffff00; text-align:right; ">            7,20 € </td><td style="background-color:#ffff00; "> </td><td style="background-color:#ffff00; text-align:right; ">06.11.2017</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >17</td><td >Oli</td><td style="text-align:right; ">1</td><td style="text-align:right; ">            7,20 € </td><td > </td><td > </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >18</td><td >Olibe</td><td style="text-align:right; ">1</td><td style="text-align:right; ">            7,20 € </td><td > </td><td > </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >19</td><td style="background-color:#ffcc99; ">Hujuk</td><td style="background-color:#ffcc99; text-align:right; ">1</td><td style="background-color:#ffcc99; text-align:right; ">            7,20 € </td><td style="background-color:#ffcc99; "> </td><td style="background-color:#ffcc99; ">Verrechnung mit HQ-Gewinn nach 08.11.</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >20</td><td style="background-color:#ffff00; ">Norbert</td><td style="background-color:#ffff00; text-align:right; ">1</td><td style="background-color:#ffff00; text-align:right; ">            7,20 € </td><td style="background-color:#ffff00; "> </td><td style="background-color:#ffff00; text-align:right; ">09.11.2017</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >21</td><td style="background-color:#ffff00; ">fatimi</td><td style="background-color:#ffff00; text-align:right; ">3</td><td style="background-color:#ffff00; text-align:right; ">         21,60 € </td><td style="background-color:#ffff00; "> </td><td style="background-color:#ffff00; text-align:right; ">09.11.2017</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >22</td><td >Snuffx</td><td style="text-align:right; ">3</td><td style="text-align:right; ">         21,60 € </td><td > </td><td > </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >23</td><td >didi1952</td><td style="text-align:right; ">1</td><td style="text-align:right; ">            7,20 € </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >24</td><td >skodakeule</td><td style="text-align:right; ">1</td><td style="text-align:right; ">            7,20 € </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >25</td><td style="font-weight:bold; ">GESAMT</td><td style="font-weight:bold; text-align:right; ">74</td><td style="font-weight:bold; text-align:right; ">       532,80 € </td><td style="font-weight:bold; "> </td><td style="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 >C25</td><td >=SUMME(C3:C24)</td></tr><tr><td >D25</td><td >=SUMME(D3:D24)</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>


VG, Liane