Beiträge: 2.700
Themen: 504
Registriert seit: Dec 2008
Bewertung:
0
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
Geschäft ist Geschäft
Beiträge: 2.700
Themen: 504
Registriert seit: Dec 2008
Bewertung:
0
Beiträge: 2.700
Themen: 504
Registriert seit: Dec 2008
Bewertung:
0
Beiträge: 2.700
Themen: 504
Registriert seit: Dec 2008
Bewertung:
0
Beiträge: 2.700
Themen: 504
Registriert seit: Dec 2008
Bewertung:
0
Beiträge: 18.683
Themen: 347
Registriert seit: Nov 2008
Bewertung:
11
@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>
Beiträge: 2.139
Themen: 119
Registriert seit: Nov 2008
Bewertung:
0
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
Danke Skodakeule für deine Bemühungen,
jederzeit wieder
Wann ist das nächste LSD in NRW :was:
Viele Grüße
EM-Master Thilo :tor:
Beiträge: 18.683
Themen: 347
Registriert seit: Nov 2008
Bewertung:
11
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>
WICHTIG - NACHTRAG:
wie oben schon erwähnt, buch ich uns die Beträge per heute schon mal in der Tabelle gut - die Gutschrift auf´s Bankkonto erfolgt sehr wahrscheinlich bis FREITAG, 19.06.
Grüße, Liane
|