Doe hier een schatting voor

[Verwijderd]

het aantal geflushte blokjes zodra de stats van D.net weer werken.

/me schat dat we ineens /. voorbij zijn

(alhoewel ik me realiseer dat er nu veel meer gespaard word)

[crisp]

<center><table border=0 cellpadding=0 cellspacing=2><tr><td align=center><font face="arial" size=2>[Dutch Power Cows] aanvullende stats</font></td></tr><tr><td><table border=0 cellpadding=6 cellspacing=0><tr bgcolor="#770000"><td align=center><font face="arial" size=2 color="#ffffff">Datum</font></td><td align=center><font face="arial" size=2 color="#ffffff">Positie</font></td><td align=center><font face="arial" size=2 color="#ffffff">Blokjes</font></td><td align=center><font face="arial" size=2 color="#ffffff">Leden</font></td><td align=center><font face="arial" size=2 color="#ffffff">Flushers</font></td><td align=center><font face="arial" size=2 color="#ffffff">Gem.</font></td><td align=center><font face="arial" size=2 color="#ffffff">Jackpot</font></td><td align=center><font face="arial" size=2 color="#ffffff">DPC kans</font></td></tr><tr bgcolor="#ffffee"><td align=right><a href="http://gathering.tweakers.net/forum/list_messages/61881"><font face="arial" size=2 color="#993333">27 oktober</font></a></td><td align=center><font face="arial" size=2>1 ([img]http://tweakers.net/g/dpc/stil.gif>)</font></td><td[/img]<font face="arial" size=2>2.451.791</font></td><td align=right><font face="arial" size=2>3438</font></td><td align=center><font face="arial" size=2>1480</font></td><td align=right><font face="arial" size=2>1657</font></td><td align=right><font face="arial" size=2>1: 977</font></td><td align=center><font face="arial" size=2>1:19</font></td></tr><tr bgcolor="#eeeeee"><td align=right><a href="http://gathering.tweakers.net/forum/list_messages/62316"><font face="arial" size=2 color="#993333">28 oktober</font></a></td><td align=center><font face="arial" size=2>1 ([img]http://tweakers.net/g/dpc/stil.gif>)</font></td><td[/img]<font face="arial" size=2>1.759.488</font></td><td align=right><font face="arial" size=2>3445</font></td><td align=center><font face="arial" size=2>1347</font></td><td align=right><font face="arial" size=2>1306</font></td><td align=right><font face="arial" size=2>1:1216</font></td><td align=center><font face="arial" size=2>1:21</font></td></tr><tr bgcolor="#ffffee"><td align=right><a href="http://gathering.tweakers.net/forum/list_messages/62679"><font face="arial" size=2 color="#993333">29 oktober</font></a></td><td align=center><font face="arial" size=2>2 ([img]http://tweakers.net/g/dpc/down.gif>1)</font></td><td[/img]<font face="arial" size=2>2.793.215</font></td><td align=right><font face="arial" size=2>3460</font></td><td align=center><font face="arial" size=2>1457</font></td><td align=right><font face="arial" size=2>1917</font></td><td align=right><font face="arial" size=2>1:1097</font></td><td align=center><font face="arial" size=2>1:15</font></td></tr><tr bgcolor="#eeeeee"><td align=right><a href="http://gathering.tweakers.net/forum/list_messages/63547"><font face="arial" size=2 color="#993333">30 oktober</font></a></td><td align=center><font face="arial" size=2>1 ([img]http://tweakers.net/g/dpc/up.gif>1)</font></td><td[/img]<font face="arial" size=2>2.642.457</font></td><td align=right><font face="arial" size=2>3476</font></td><td align=center><font face="arial" size=2>1527</font></td><td align=right><font face="arial" size=2>1730</font></td><td align=right><font face="arial" size=2>1: 978</font></td><td align=center><font face="arial" size=2>1:18</font></td></tr><tr bgcolor="#ffffee"><td align=right><a href="http://gathering.tweakers.net/forum/list_messages/63922"><font face="arial" size=2 color="#993333">31 oktober</font></a></td><td align=center><font face="arial" size=2>1 ([img]http://tweakers.net/g/dpc/stil.gif>)</font></td><td[/img]<font face="arial" size=2>2.401.650</font></td><td align=right><font face="arial" size=2>3485</font></td><td align=center><font face="arial" size=2>1524</font></td><td align=right><font face="arial" size=2>1576</font></td><td align=right><font face="arial" size=2>1:1033</font></td><td align=center><font face="arial" size=2>1:18</font></td></tr><tr bgcolor="#eeeeee"><td align=right><a href="http://gathering.tweakers.net/showtopic/?????"><font face="arial" size=2 color="#993333">1 november</font></a></td><td align=center><font face="arial" size=2>1 ([img]http://tweakers.net/g/dpc/stil.gif>)</font></td><td[/img]<font face="arial" size=2>2.499.749</font></td><td align=right><font face="arial" size=2>3493</font></td><td align=center><font face="arial" size=2>1520</font></td><td align=right><font face="arial" size=2>1645</font></td><td align=right><font face="arial" size=2>1:1006</font></td><td align=center><font face="arial" size=2>1:18</font></td></tr><tr bgcolor="#ffffee"><td align=right><a href="http://gathering.tweakers.net/showtopic/?????"><font face="arial" size=2 color="#993333">2 november</font></a></td><td align=center><font face="arial" size=2>1 ([img]http://tweakers.net/g/dpc/stil.gif>)</font></td><td[/img]<font face="arial" size=2>2.607.764</font></td><td align=right><font face="arial" size=2>3501</font></td><td align=center><font face="arial" size=2>1520</font></td><td align=right><font face="arial" size=2>1716</font></td><td align=right><font face="arial" size=2>1:1020</font></td><td align=center><font face="arial" size=2>1:17</font></td></tr><tr bgcolor="#eeeeee"><td align=right><a href="http://gathering.tweakers.net/showtopic/?????"><font face="arial" size=2 color="#993333">3 november</font></a></td><td align=center><font face="arial" size=2>1 ([img]http://tweakers.net/g/dpc/stil.gif>)</font></td><td[/img]<font face="arial" size=2>2.458.305</font></td><td align=right><font face="arial" size=2>3509</font></td><td align=center><font face="arial" size=2>1520</font></td><td align=right><font face="arial" size=2>1617</font></td><td align=right><font face="arial" size=2>1:1021</font></td><td align=center><font face="arial" size=2>1:18</font></td></tr><tr bgcolor="#ffffee"><td align=right><a href="http://gathering.tweakers.net/showtopic/?????"><font face="arial" size=2 color="#993333">4 november</font></a></td><td align=center><font face="arial" size=2>1 ([img]http://tweakers.net/g/dpc/stil.gif>)</font></td><td[/img]<font face="arial" size=2>2.108.800</font></td><td align=right><font face="arial" size=2>3517</font></td><td align=center><font face="arial" size=2>1520</font></td><td align=right><font face="arial" size=2>1387</font></td><td align=right><font face="arial" size=2>1:1189</font></td><td align=center><font face="arial" size=2>1:18</font></td></tr><tr bgcolor="#eeeeee"><td align=right><a href="http://gathering.tweakers.net/showtopic/?????"><font face="arial" size=2 color="#993333">5 november</font></a></td><td align=center><font face="arial" size=2>1 ([img]http://tweakers.net/g/dpc/stil.gif>)</font></td><td[/img]<font face="arial" size=2>2.367.943</font></td><td align=right><font face="arial" size=2>3525</font></td><td align=center><font face="arial" size=2>1520</font></td><td align=right><font face="arial" size=2>1558</font></td><td align=right><font face="arial" size=2>1:1058</font></td><td align=center><font face="arial" size=2>1:18</font></td></tr></table></td></tr><tr><td align=left><font face="arial" size=1>© Mo-Bees / crisp</font></td></tr><tr><td align=center><font face="arial" size=3 color="#FF0000">Totaal aantal dagen op #1 : </font><font face= "arial" size=4 color="#FF0000">7 !</font></td></tr><tr><td align=center><font face="arial" size=3 color="#FF0000">Totaal aantal dagen op >2M : </font><font face= "arial" size=4 color="#FF0000">8 !</font></td></tr><tr><td></td></tr><tr><td></td></tr><tr><td><font face="arial" size=2>Hoogste aantal flushers: </font><a href="http://gathering.tweakers.net/forum/list_messages/63547"><font face="arial" size=2>30 oktober 2000</font></a><font face="arial" size=2> >>> </font><font face= "arial" size=2>1527</font></td></tr><tr><td><font face="arial" size=2>Hoogst aantal blocks gemiddeld: </font><a href="http://gathering.tweakers.net/forum/list_messages/42793"><font face="arial" size=2>8 september 2000</font></a><font face="arial" size=2> >>> </font><font face= "arial" size=2>3408</font></td></tr><tr><td><font face="arial" size=2>[DPC] flushrecord: </font><a href="http://gathering.tweakers.net/forum/list_messages/42793"><font face="arial" size=2>8 september 2000</font></a><font face="arial" size=2> >>> </font><font face= "arial" size=2>4.771.187</font></td></tr><tr><td><font face="arial" size=2>[DPC] subteam flushrecord: </font><a href="http://stats.distributed.net/rc5-64/psummary.php3?id=282974"><font face="arial" size=2>Team BoGoH</font></a><font face="arial" size=2>, </font><a href="http://gathering.tweakers.net/forum/list_messages/42201"><font face="arial" size=2>5 september 2000</font></a><font face="arial" size=2> >>> </font><font face= "arial" size=2>894.484</font></td></tr></table></center>

[Verwijderd]

Hmm..
Goeie schatting

*shit! nou valt er niets meer te fantaseren :(*

[Verwijderd]

Crisp, jij schijnt nogal veel verstand te hebben over het maken van eigen stats.

Ik ben nu ok ff bezig met stats voor het eigen team, maar zoek mooie voorspellingen zoals deze en groeirates per week(gewogen).

Ik weet alleen niet hoe ik ze in XL moet maken??

bvd.

Let stats be seen!!!!!!!soon?!?

[crisp]

jaap de boer

Probeer dit eens:

<TABLE BORDER=1><TR><TD ALIGN="right"><FONT FACE="Arial">2173401</FONT></TD><TD ALIGN="left"><FONT FACE="Arial">=AVERAGE(B3:B9)</FONT></TD></TR><TR><TD ALIGN="right"><FONT FACE="Arial">2148503</FONT></TD><TD ALIGN="left"><FONT FACE="Arial">=AVERAGE(B10:B16)</FONT></TD></TR><TR><TD ALIGN="right"><FONT FACE="Arial">2275601</FONT></TD><TD ALIGN="left"><FONT FACE="Arial">=AVERAGE(B17:B23)</FONT></TD></TR><TR><TD ALIGN="right"><FONT FACE="Arial">2278847</FONT></TD><TD ALIGN="left"><FONT FACE="Arial">=AVERAGE(B24:B30)</FONT></TD></TR><TR><TD ALIGN="right"><FONT FACE="Arial">2337250</FONT></TD><TD ALIGN="left"><FONT FACE="Arial">=AVERAGE(B31:B37)</FONT></TD></TR><TR><TD ALIGN="right"><FONT FACE="Arial">2427383</FONT></TD><TD ALIGN="left"><FONT FACE="Arial">=AVERAGE(B38:B44)</FONT></TD></TR><TR><TD ALIGN="right"><FONT FACE="Arial">2360421</FONT></TD><TD ALIGN="left"><FONT FACE="Arial">=AVERAGE(B45:B51)</FONT></TD></TR><TR><TD ALIGN="right"><FONT FACE="Arial">2440953</FONT></TD><TD ALIGN="left"><FONT FACE="Arial">=AVERAGE(B52:B58)</FONT></TD></TR><TR><TD ALIGN="right"><FONT FACE="Arial">0.988544</FONT></TD><TD ALIGN="left"><FONT FACE="Arial">=B62/B61</FONT></TD>
</TR><TR><TD ALIGN="right"><FONT FACE="Arial">1.059157</FONT></TD><TD ALIGN="left"><FONT FACE="Arial">=B63/B62</FONT></TD></TR><TR><TD ALIGN="right"><FONT FACE="Arial">1.001426</FONT></TD><TD ALIGN="left"><FONT FACE="Arial">=B64/B63</FONT></TD>
</TR><TR><TD ALIGN="right"><FONT FACE="Arial">1.025628</FONT></TD><TD ALIGN="left"><FONT FACE="Arial">=B65/B64</FONT></TD></TR><TR><TD ALIGN="right"><FONT FACE="Arial">1.038564</FONT></TD><TD ALIGN="left"><FONT FACE="Arial">=B66/B65</FONT></TD>
</TR><TR><TD ALIGN="right"><FONT FACE="Arial">0.972414</FONT></TD><TD ALIGN="left"><FONT FACE="Arial">=B67/B66</FONT></TD></TR><TR><TD ALIGN="right"><FONT FACE="Arial">1.034117</FONT></TD><TD ALIGN="left"><FONT FACE="Arial">=B68/B67</FONT></TD>
</TR><TR><TD ALIGN="right"><FONT FACE="Arial">1.017617</FONT></TD><TD ALIGN="left"><FONT FACE="Arial">=((((((POWER(B68/B67,(1/1))+POWER(B68/B66,(1/2)))/2+POWER(B68/B65,(1/3)))/2+POWER(B68/B64,(1/4)))/2+POWER(B68/B63,(1/5)))/2+POWER(B68/B62,(1/6)))/2+POWER(B68/B61,(1/7)))/2</FONT></TD></TR></TABLE>

Waarbij zeg maar B3 t/m B58 de dagelijkse standen bevat van de afgelopen 7 weken.
De eerste formule komt in B61 en bevat het gemiddelde van de eerste week etc.
Ik ga hier uit van exponentiele groei!
Verder zie je het verschil ten opzichte van elke vorige week, en de laatste kolom is een berekend voortschrijdend gemiddelde van de groeirate over alle 7 weken, waarbij de laatste weken zwaarder wegen als de voorgaande weken.

Suc6