Zitat:Original von skodakeule
Hallo Liebe Teilnehmer am LSD 12.06.2010

Nachfolgend stelle ich die Gesamtabrechnung, bzw die einzelnen Gewinnquittungen ein.

Wenn ich mich nicht verzählt habe, hatten wir 17 dreier, und einen vierer.

Mein persönliches Fazit :

Immer wieder gerne "no Risc no Fun" , bzw

Der olympische Gedanke zählt, "hauptsache dabei" !!!

in diesem Sinne,

mit freundlichen Grüßen

skodakeule

Zitat:Original von Liane
@all,

nachstehend unsere Gewinne + Rückläufe

die LETZTE SPALTE ist die wichtigste :D - also die jeweilige Gesamtsumme pro TN aus Rücklauf + Gewinn

DIE BUCHUNG ERSCHEINT DANN IN DER MORGIGEN MI-ÜBERSICHT!!

nochmals vielen Dank@skodakeule!!

ich bin auf jeden Fall wieder mit dabei

Viele 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:115px;" /><col style="width:88px;" /><col style="width:106px;" /><col style="width:74px;" /><col style="width:103px;" /><col style="width:101px;" /></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:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td style="background-color:#ffff00; font-weight:bold; ">Lotto-Super-Ding</td><td style="background-color:#ffff00; font-weight:bold; text-align:right; ">Jun 10</td><td style="background-color:#ffff00; "> </td><td style="background-color:#ffff00; "> </td><td style="background-color:#ffff00; font-weight:bold; text-align:right; ">178,20 €</td><td style="background-color:#ffff00; color:#0000ff; font-weight:bold; ">Buchg.Forenkto</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="background-color:#ffcc00; font-weight:bold; ">TEILNEHMER</td><td style="background-color:#ffcc00; font-weight:bold; ">Einsatzanteil</td><td style="background-color:#ffcc00; font-weight:bold; ">%ualer Anteil</td><td style="background-color:#ffcc00; font-weight:bold; ">60% Rückl.</td><td style="background-color:#ffcc00; font-weight:bold; ">%ualer Gewinn</td><td style="background-color:#ffcc00; font-weight:bold; ">Ges.Gewinn/P.</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="background-color:#ccffcc; ">Norbert</td><td style="background-color:#ccffff; text-align:right; ">         30,00 € </td><td style="background-color:#ffff99; text-align:right; ">2,27%</td><td style="background-color:#99cc00; text-align:right; ">     18,00 € </td><td style="background-color:#cc99ff; text-align:right; ">              4,05 € </td><td style="background-color:#ff99cc; color:#0000ff; font-weight:bold; text-align:right; ">            22,05 € </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td style="background-color:#ccffcc; ">addua</td><td style="background-color:#ccffff; text-align:right; ">         60,00 € </td><td style="background-color:#ffff99; text-align:right; ">4,55%</td><td style="background-color:#99cc00; text-align:right; ">     36,00 € </td><td style="background-color:#cc99ff; text-align:right; ">              8,11 € </td><td style="background-color:#ff99cc; color:#0000ff; font-weight:bold; text-align:right; ">            44,11 € </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td style="background-color:#ccffcc; ">Liane</td><td style="background-color:#ccffff; text-align:right; ">       100,00 € </td><td style="background-color:#ffff99; text-align:right; ">7,58%</td><td style="background-color:#99cc00; text-align:right; ">     60,00 € </td><td style="background-color:#cc99ff; text-align:right; ">            13,50 € </td><td style="background-color:#ff99cc; color:#0000ff; font-weight:bold; text-align:right; ">            73,50 € </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td style="background-color:#ccffcc; ">ochjoo</td><td style="background-color:#ccffff; text-align:right; ">         40,00 € </td><td style="background-color:#ffff99; text-align:right; ">3,03%</td><td style="background-color:#99cc00; text-align:right; ">     24,00 € </td><td style="background-color:#cc99ff; text-align:right; ">              5,39 € </td><td style="background-color:#ff99cc; color:#0000ff; font-weight:bold; text-align:right; ">            29,39 € </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td style="background-color:#ccffcc; ">bluespider</td><td style="background-color:#ccffff; text-align:right; ">       120,00 € </td><td style="background-color:#ffff99; text-align:right; ">9,09%</td><td style="background-color:#99cc00; text-align:right; ">     72,00 € </td><td style="background-color:#cc99ff; text-align:right; ">            16,20 € </td><td style="background-color:#ff99cc; color:#0000ff; font-weight:bold; text-align:right; ">            88,20 € </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td style="background-color:#ccffcc; ">katzenkopf</td><td style="background-color:#ccffff; text-align:right; ">         50,00 € </td><td style="background-color:#ffff99; text-align:right; ">3,79%</td><td style="background-color:#99cc00; text-align:right; ">     30,00 € </td><td style="background-color:#cc99ff; text-align:right; ">              6,75 € </td><td style="background-color:#ff99cc; color:#0000ff; font-weight:bold; text-align:right; ">            36,75 € </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td style="background-color:#ccffcc; ">Peter</td><td style="background-color:#ccffff; text-align:right; ">         80,00 € </td><td style="background-color:#ffff99; text-align:right; ">6,06%</td><td style="background-color:#99cc00; text-align:right; ">     48,00 € </td><td style="background-color:#cc99ff; text-align:right; ">            10,80 € </td><td style="background-color:#ff99cc; color:#0000ff; font-weight:bold; text-align:right; ">            58,80 € </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td style="background-color:#ccffcc; ">Juliett</td><td style="background-color:#ccffff; text-align:right; ">       100,00 € </td><td style="background-color:#ffff99; text-align:right; ">7,58%</td><td style="background-color:#99cc00; text-align:right; ">     60,00 € </td><td style="background-color:#cc99ff; text-align:right; ">            13,50 € </td><td style="background-color:#ff99cc; color:#0000ff; font-weight:bold; text-align:right; ">            73,50 € </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td style="background-color:#ccffcc; ">Diesch11</td><td style="background-color:#ccffff; text-align:right; ">         80,00 € </td><td style="background-color:#ffff99; text-align:right; ">6,06%</td><td style="background-color:#99cc00; text-align:right; ">     48,00 € </td><td style="background-color:#cc99ff; text-align:right; ">            10,80 € </td><td style="background-color:#ff99cc; color:#0000ff; font-weight:bold; text-align:right; ">            58,80 € </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >12</td><td style="background-color:#ccffcc; ">WinR</td><td style="background-color:#ccffff; text-align:right; ">       100,00 € </td><td style="background-color:#ffff99; text-align:right; ">7,58%</td><td style="background-color:#99cc00; text-align:right; ">     60,00 € </td><td style="background-color:#cc99ff; text-align:right; ">            13,50 € </td><td style="background-color:#ff99cc; color:#0000ff; font-weight:bold; text-align:right; ">            73,50 € </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >13</td><td style="background-color:#ccffcc; ">Melli</td><td style="background-color:#ccffff; text-align:right; ">         50,00 € </td><td style="background-color:#ffff99; text-align:right; ">3,79%</td><td style="background-color:#99cc00; text-align:right; ">     30,00 € </td><td style="background-color:#cc99ff; text-align:right; ">              6,75 € </td><td style="background-color:#ff99cc; color:#0000ff; font-weight:bold; text-align:right; ">            36,75 € </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >14</td><td style="background-color:#ccffcc; ">Nico</td><td style="background-color:#ccffff; text-align:right; ">         50,00 € </td><td style="background-color:#ffff99; text-align:right; ">3,79%</td><td style="background-color:#99cc00; text-align:right; ">     30,00 € </td><td style="background-color:#cc99ff; text-align:right; ">              6,75 € </td><td style="background-color:#ff99cc; color:#0000ff; font-weight:bold; text-align:right; ">            36,75 € </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >15</td><td style="background-color:#ccffcc; ">Thilo</td><td style="background-color:#ccffff; text-align:right; ">         30,00 € </td><td style="background-color:#ffff99; text-align:right; ">2,27%</td><td style="background-color:#99cc00; text-align:right; ">     18,00 € </td><td style="background-color:#cc99ff; text-align:right; ">              4,05 € </td><td style="background-color:#ff99cc; color:#0000ff; font-weight:bold; text-align:right; ">            22,05 € </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >16</td><td style="background-color:#ccffcc; ">Karin</td><td style="background-color:#ccffff; text-align:right; ">         50,00 € </td><td style="background-color:#ffff99; text-align:right; ">3,79%</td><td style="background-color:#99cc00; text-align:right; ">     30,00 € </td><td style="background-color:#cc99ff; text-align:right; ">              6,75 € </td><td style="background-color:#ff99cc; color:#0000ff; font-weight:bold; text-align:right; ">            36,75 € </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >17</td><td style="background-color:#ccffcc; ">hessen-haas</td><td style="background-color:#ccffff; text-align:right; ">         50,00 € </td><td style="background-color:#ffff99; text-align:right; ">3,79%</td><td style="background-color:#99cc00; text-align:right; ">     30,00 € </td><td style="background-color:#cc99ff; text-align:right; ">              6,75 € </td><td style="background-color:#ff99cc; color:#0000ff; font-weight:bold; text-align:right; ">            36,75 € </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >18</td><td style="background-color:#ccffcc; ">fatimi</td><td style="background-color:#ccffff; text-align:right; ">       200,00 € </td><td style="background-color:#ffff99; text-align:right; ">15,15%</td><td style="background-color:#99cc00; text-align:right; ">   120,00 € </td><td style="background-color:#cc99ff; text-align:right; ">            27,00 € </td><td style="background-color:#ff99cc; color:#0000ff; font-weight:bold; text-align:right; ">          147,00 € </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >19</td><td style="background-color:#ccffcc; ">flicflac</td><td style="background-color:#ccffff; text-align:right; ">         60,00 € </td><td style="background-color:#ffff99; text-align:right; ">4,55%</td><td style="background-color:#99cc00; text-align:right; ">     36,00 € </td><td style="background-color:#cc99ff; text-align:right; ">              8,11 € </td><td style="background-color:#ff99cc; color:#0000ff; font-weight:bold; text-align:right; ">            44,11 € </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >20</td><td style="background-color:#ffcc99; ">skodakeule</td><td style="background-color:#ffcc99; text-align:right; ">         70,00 € </td><td style="background-color:#ffcc99; text-align:right; ">5,30%</td><td style="background-color:#ffcc99; text-align:right; ">     42,00 € </td><td style="background-color:#ffcc99; text-align:right; ">              9,44 € </td><td style="background-color:#ffcc99; text-align:right; ">            51,44 € </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >21</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >22</td><td style="background-color:#ff0000; font-weight:bold; ">Gesamt-Buchung</td><td style="background-color:#ff0000; font-weight:bold; text-align:right; ">    1.320,00 € </td><td style="background-color:#ff0000; font-weight:bold; text-align:right; ">100,00%</td><td style="background-color:#ff0000; font-weight:bold; text-align:right; ">   792,00 € </td><td style="background-color:#ff0000; font-weight:bold; text-align:right; ">           178,20 € </td><td style="background-color:#ff0000; font-weight:bold; text-align:right; ">          970,20 € </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >23</td><td style="font-weight:bold; "> </td><td style="font-weight:bold; "> </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >24</td><td style="background-color:#ff6600; font-weight:bold; ">an skodakeule:</td><td style="background-color:#ff6600; font-weight:bold; text-align:right; ">    1.250,00 € </td><td style="background-color:#00ff00; font-weight:bold; ">von skodakeule</td><td style="background-color:#00ff00; font-weight:bold; text-align:right; ">   750,00 € </td><td style="background-color:#00ff00; font-weight:bold; text-align:right; ">           168,76 € </td><td style="background-color:#00ff00; font-weight:bold; text-align:right; ">          918,76 € </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 >F3</td><td >=SUMME(D3:E3)</td></tr><tr><td >F4</td><td >=SUMME(D4:E4)</td></tr><tr><td >F5</td><td >=SUMME(D5:E5)</td></tr><tr><td >F6</td><td >=SUMME(D6:E6)</td></tr><tr><td >F7</td><td >=SUMME(D7:E7)</td></tr><tr><td >F8</td><td >=SUMME(D8:E8)</td></tr><tr><td >F9</td><td >=SUMME(D9:E9)</td></tr><tr><td >F10</td><td >=SUMME(D10:E10)</td></tr><tr><td >F11</td><td >=SUMME(D11:E11)</td></tr><tr><td >F12</td><td >=SUMME(D12:E12)</td></tr><tr><td >F13</td><td >=SUMME(D13:E13)</td></tr><tr><td >F14</td><td >=SUMME(D14:E14)</td></tr><tr><td >F15</td><td >=SUMME(D15:E15)</td></tr><tr><td >F16</td><td >=SUMME(D16:E16)</td></tr><tr><td >F17</td><td >=SUMME(D17:E17)</td></tr><tr><td >F18</td><td >=SUMME(D18:E18)</td></tr><tr><td >F19</td><td >=SUMME(D19:E19)</td></tr><tr><td >F20</td><td >=SUMME(D20:E20)</td></tr><tr><td >D22</td><td >=SUMME(D3:D21)</td></tr><tr><td >E22</td><td >=SUMME(E3:E21)</td></tr><tr><td >F22</td><td >=SUMME(F3:F21)</td></tr><tr><td >F24</td><td >=SUMME(D24:E24)</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>