Beiträge: 8.188
Themen: 219
Registriert seit: Dec 2009
Bewertung:
0
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.
.
Beiträge: 1.942
Themen: 265
Registriert seit: Feb 2014
Bewertung:
0
Zitat:Original von Liane
Zitat: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.
Beiträge: 8.188
Themen: 219
Registriert seit: Dec 2009
Bewertung:
0
: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.
.
Beiträge: 22
Themen: 1
Registriert seit: Feb 2017
Bewertung:
0
Ich nehme bitte 3 Anteile
danke
Beiträge: 18.694
Themen: 347
Registriert seit: Nov 2008
Bewertung:
11
Zitat: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
Beiträge: 18.694
Themen: 347
Registriert seit: Nov 2008
Bewertung:
11
Zitat: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>
Beiträge: 18.694
Themen: 347
Registriert seit: Nov 2008
Bewertung:
11
<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
Beiträge: 8.188
Themen: 219
Registriert seit: Dec 2009
Bewertung:
0
:tor:
Das nächste Etappenziel - 23er-Zahlenpool - erreicht und überschritten :
:tor:
Beiträge: 857
Themen: 13
Registriert seit: Jun 2011
Bewertung:
0
ich erhöhe auf 10 Anteile
Beiträge: 18.694
Themen: 347
Registriert seit: Nov 2008
Bewertung:
11
Zitat: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
|