First!

[Ees]

... to post after the forum breakdown

Martin

BTW: Y'all are right about the weekly stats not being correct. I can't seem to reply there though. Will correct later today or tomorrow.

[Sisyfos]

1st to post after Paulr as the 1st poster after the revised tables, which were posted as the 1st post after the 1st breakdown of the forums in a long time.

Thanks Martin.
I've been playing with the Excel external datasource thingy, but I would like to see what you've cooked up, so just send it my way if you please.
I'm on ADSL so don't worry about the size.

[Ees]

Well, I seem to be able to reply here. Here goes (still a bit off, but that's probably due to different sample times):

Top-50 fastest Dec 4-11:

<TABLE BORDER=1><TR><TH>name</TH><TH>wus</TH><TH>hours</TH><TH>average</TH></TR><TR><TD>Rags</TD><TD>42</TD><TD>126.05</TD><TD>3h 0m</TD></TR><TR><TD>cjolley</TD><TD>35</TD><TD>124.38</TD><TD>3h 33m</TD></TR><TR><TD>Swing</TD><TD>40</TD><TD>148.03</TD><TD>3h 42m</TD></TR><TR><TD>k1l</TD><TD>21</TD><TD>81.03</TD><TD>3h 52m</TD></TR><TR><TD>Mark F.</TD><TD>209</TD><TD>866.65</TD><TD>4h 9m</TD></TR><TR><TD>Bernd</TD><TD>12</TD><TD>52.98</TD><TD>4h 25m</TD></TR><TR><TD>Manex</TD><TD>37</TD><TD>164.14</TD><TD>4h 26m</TD></TR><TR><TD>Rolf Almekinder</TD><TD>3</TD><TD>13.61</TD><TD>4h 32m</TD></TR><TR><TD>Butcher</TD><TD>1062</TD><TD>4886.88</TD><TD>4h 36m</TD></TR><TR><TD>Stealth9</TD><TD>23</TD><TD>107.19</TD><TD>4h 40m</TD></TR><TR><TD>Negative Saucer</TD><TD>35</TD><TD>166.75</TD><TD>4h 46m</TD></TR><TR><TD>Raptor^</TD><TD>12</TD><TD>58.22</TD><TD>4h 51m</TD></TR><TR><TD>Guyver</TD><TD>144</TD><TD>706.85</TD><TD>4h 55m</TD></TR><TR><TD>Otis</TD><TD>26</TD><TD>127.63</TD><TD>4h 55m</TD></TR><TR><TD>Technoid</TD><TD>21</TD><TD>104.02</TD><TD>4h 57m</TD></TR><TR><TD>Duke</TD><TD>20</TD><TD>100.50</TD><TD>5h 2m</TD></TR><TR><TD>spazm</TD><TD>17</TD><TD>86.57</TD><TD>5h 6m</TD></TR><TR><TD>TomNuttall</TD><TD>119</TD><TD>609.31</TD><TD>5h 7m</TD></TR><TR><TD>Philip Mansfield</TD><TD>31</TD><TD>160.23</TD><TD>5h 10m</TD></TR><TR><TD>Charles</TD><TD>339</TD><TD>1759.79</TD><TD>5h 11m</TD></TR><TR><TD>Ackerot</TD><TD>47</TD><TD>244.04</TD><TD>5h 12m</TD></TR><TR><TD>Christian Schimmell</TD><TD>2</TD><TD>10.40</TD><TD>5h 12m</TD></TR><TR><TD>refles</TD><TD>4</TD><TD>21.03</TD><TD>5h 15m</TD></TR><TR><TD>Megacity2</TD><TD>87</TD><TD>457.89</TD><TD>5h 16m</TD></TR><TR><TD>Aaron K</TD><TD>24</TD><TD>127.10</TD><TD>5h 18m</TD></TR><TR><TD>Fleabus</TD><TD>13</TD><TD>68.90</TD><TD>5h 18m</TD></TR><TR><TD>acobra</TD><TD>32</TD><TD>169.68</TD><TD>5h 18m</TD></TR><TR><TD>dsheridan</TD><TD>105</TD><TD>557.59</TD><TD>5h 19m</TD></TR><TR><TD>Dan</TD><TD>32</TD><TD>170.79</TD><TD>5h 20m</TD></TR><TR><TD>cancer</TD><TD>3</TD><TD>16.02</TD><TD>5h 20m</TD></TR><TR><TD>BladeRunner</TD><TD>140</TD><TD>748.50</TD><TD>5h 21m</TD></TR><TR><TD>atra2</TD><TD>5</TD><TD>26.74</TD><TD>5h 21m</TD></TR><TR><TD>Wilt</TD><TD>24</TD><TD>128.52</TD><TD>5h 21m</TD></TR><TR><TD>Vincenzo Boemi</TD><TD>15</TD><TD>81.51</TD><TD>5h 26m</TD></TR><TR><TD>Liquid Snake</TD><TD>49</TD><TD>267.99</TD><TD>5h 28m</TD></TR><TR><TD>Electric Amish</TD><TD>33</TD><TD>183.85</TD><TD>5h 34m</TD></TR><TR><TD>Brian R.</TD><TD>108</TD><TD>604.47</TD><TD>5h 36m</TD></TR><TR><TD>Guru</TD><TD>203</TD><TD>1142.31</TD><TD>5h 38m</TD></TR><TR><TD>Maniak</TD><TD>3</TD><TD>16.88</TD><TD>5h 38m</TD></TR><TR><TD>Zyn</TD><TD>130</TD><TD>731.97</TD><TD>5h 38m</TD></TR><TR><TD>Maggi</TD><TD>22</TD><TD>124.97</TD><TD>5h 41m</TD></TR><TR><TD>Darkman</TD><TD>16</TD><TD>91.78</TD><TD>5h 44m</TD></TR><TR><TD>drzaius</TD><TD>1</TD><TD>5.78</TD><TD>5h 47m</TD></TR><TR><TD>steve99</TD><TD>24</TD><TD>141.26</TD><TD>5h 53m</TD></TR><TR><TD>Rob</TD><TD>31</TD><TD>183.96</TD><TD>5h 56m</TD></TR><TR><TD>Jorden</TD><TD>20</TD><TD>119.86</TD><TD>5h 60m</TD></TR><TR><TD>[dreamer]</TD><TD>10</TD><TD>60.16</TD><TD>6h 1m</TD></TR><TR><TD>endeavor</TD><TD>82</TD><TD>494.79</TD><TD>6h 2m</TD></TR><TR><TD>Android</TD><TD>22</TD><TD>133.82</TD><TD>6h 5m</TD></TR><TR><TD>mojo</TD><TD>44</TD><TD>270.46</TD><TD>6h 9m</TD></TR></TABLE>

Martin

[Ees]

By effort:

<TABLE BORDER=1><TR><TH>name</TH><TH>hours</TH><TH>weeks</TH></TR><TR><TD>Butcher</TD><TD>4886.88</TD><TD>29.09</TD></TR><TR><TD>agallag</TD><TD>3134.78</TD><TD>18.66</TD></TR><TR><TD>Tea m Narc</TD><TD>2987.91</TD><TD>17.79</TD></TR><TR><TD>Sisyfos</TD><TD>2905.85</TD><TD>17.30</TD></TR><TR><TD>Alastair</TD><TD>2637.08</TD><TD>15.70</TD></TR><TR><TD>Hecubus</TD><TD>2 487.56</TD><TD>14.81</TD></TR><TR><TD>breezer</TD><TD>2408.80</TD><TD>14.34</TD></TR><TR><TD>Munchy Boys</TD><TD>2180.28</TD><TD>12.98</TD></TR><TR><TD>Ees</TD><TD>2133.45</TD><TD>12.70</TD></TR><TR><TD>Charles</TD><TD>1759.79</TD><TD>10.47</TD></TR><TR><TD>JSB</TD><TD>1378.09</T D><TD>8.20</TD></TR><TR><TD>JJc</TD><TD>1338.94</TD><TD>7.97</TD></TR><TR><TD>Bob & Sons</TD><TD>1307.22</TD><TD>7.78</TD></TR><TR><TD>Pace3000</TD><TD>1280.05</TD><TD>7.62</TD></TR><TR><TD>ATinyMouse</TD><TD>1259.12</TD><TD>7.49</TD></TR><TR><TD>Guru</TD><TD>1142 .31</TD><TD>6.80</TD></TR><TR><TD>"old-timers"</TD><TD>987.42</TD><TD>5.88</TD></TR><TR><TD>Ant</TD><TD>980.57</TD><TD>5.84</TD></TR><TR><TD>Actioneer</TD><TD>946.00</TD><TD>5.63</ TD></TR><TR><TD><-TT-></TD><TD>900.26</TD><TD>5.36</TD></TR><TR><TD>Mark F.</TD><TD>866.65</TD><TD>5.16</TD></TR><TR><TD>DirtFarmer</TD><TD>792.09</TD><TD>4.71</TD></TR><TR><TD>Dyre</TD><TD>782.67</TD><TD>4.66</TD></TR><TR><TD>BladeRunner</TD><TD>748.50 </TD><TD>4.46</TD></TR><TR><TD>Zyn</TD><TD>731.97</TD><TD>4.36</TD></TR><TR><TD>RoyceyBaby</TD><TD>721.68</TD><TD>4.30</TD></TR><TR><TD>Guyver</TD><TD>706.85</TD><TD>4.21</TD></TR> <TR><TD>bert</TD><TD>671.39</TD><TD>4.00</TD></TR><TR><TD>Team CG</TD><TD>654.40</TD><TD>3.90</TD></TR><TR><TD>Atelier Media</TD><TD>646.59</TD><TD>3.85</TD></TR><TR><TD>TomNuttall</TD><TD>609.31</TD><TD>3.63</TD></TR><TR><TD>Brian R.</TD><TD>604.47</TD><TD>3.60</TD></TR><TR><TD>XenoSynth</TD><TD>601.76</TD><TD>3.58</TD></TR><TR><TD>DentyCracker</TD><TD>588.98</TD><TD>3.51</TD></TR><TR><TD>Chronos</TD><TD>575 .86</TD><TD>3.43</TD></TR><TR><TD>xgates</TD><TD>563.86</TD><TD>3.36</TD></TR><TR><TD>dsheridan</TD><TD>557.59</TD><TD>3.32</TD></TR><TR><TD>Kevin & Michelle</TD><TD>556.91</TD><TD>3.31</TD></TR><TR><TD>Jakob Kruse</TD><TD>550.56</TD><TD>3.28</TD></TR><TR><TD>SteveC</TD><TD>539.93</TD><TD>3.21</TD></TR><TR><TD>Manfred</TD><TD>537.55</TD><TD>3.20</TD></TR><TR><TD>ScooterX</TD><TD>525.98< /TD><TD>3.13</TD></TR><TR><TD>rocketmanx</TD><TD>496.67</TD><TD>2.96</TD></TR><TR><TD>endeavor</TD><TD>494.79</TD><TD>2.95</TD></TR><TR><TD>Madturk</TD><TD>489.68</TD><TD>2.91</TD> </TR><TR><TD>borg99</TD><TD>469.75</TD><TD>2.80</TD></TR><TR><TD>Megacity2</TD><TD>457.89</TD><TD>2.73</TD></TR><TR><TD>Laurie</TD><TD>440.01</TD><TD>2.62</TD></TR><TR><TD>Ash</TD> <TD>423.73</TD><TD>2.52</TD></TR><TR><TD>Ron</TD><TD>414.06</TD><TD>2.46</TD></TR></TABLE>

Martin

[Paulr]

1st to post after the revised Fastest/Effort tables were added!
Oooo, not sure if I'm allowed to do that

BladeRunner

[Ees]

Sisyfos,

I've put it on my ISP's webserver, so you can get it here.

Considering the state of the whole thing (I just fudged it together until it sort of half-worked), I'm afraid you'll need a little explanation about it though...

It consists of several sheets:
- One for each team in our window of interest: ta, os2, nippon, etc.
- And three summary sheets: "now", "historical" and "Table".

Once you open the file in Excel, it will automatically start updating the data in all the teams' worksheets. Wait until the "globe icon" in your Excel statusbar disappears.

Next, you'll want to open the "now" sheet. It should contain the current summary stats for all the teams. Copy the entire row number 3 (which is where the data is).

Then, go to the "historical" sheet and "Paste Special, Values" the data you just copied into the next available empty row. Don't just plain "Paste"! Take note of the row numbers you're interested in (for normal operations: the last two).

Next, go to the "Table" sheet. At the bottom (in rows 20 and 21), substitute those row numbers you remembered for the numbers that are there.

Hey presto: the table at the top of this page is refreshed. Except for "rank", which I didn't know how to do automatically in the time I spent on it.

This is where I stopped. Obviously, there's some room for improvement .

For instance:
- It heavily depends on the numbers in "historical" to be exactly where they are.
- It will require a boring cycle of Copy, Paste, Adjust whenever you want to add or remove a team.
- You'll still need to HTML-ify the table (probably easy, haven't tried).
- The layout of the different sheets (especially the summary sheets) is sub-optimal. It's messy

Generally, I only learn enough of Excel to make it "do what I want". The whole thing could probably be a lot more efficient and manageable. Maybe you (or someone else) can improve it. See it as a challenge .

Martin

[Swing]

Great job Ees, keep up the good work... please.

[Jorden]

Looks like I made it in the top whatever again

And that with even one PC (a i733 with 128Mb) running 3.0, making WU's at about 17 hours a piece.

Jord.

[Ees]

Jorden,

Are you sure about the "about 17 hrs a piece"? I just checked by hand, and "5h 60m" (let's just call that 6h ) really is what I'm getting for your average. Here's what I have:

<pre>
select * from stats_individual where name='jorden' and (run_no=8998 or run_no=8832);
+---------+--------+--------+------+--------+---------+----------+
| idno | run_no | name | rank | tot_wu | tot_cpu | ave_cpu |
+---------+--------+--------+------+--------+---------+----------+
| 2698475 | 8832 | Jorden | 141 | 473 | 3685.83 | 7.792500 |
| 2801855 | 8998 | Jorden | 140 | 493 | 3805.70 | 7.719500 |
+---------+--------+--------+------+--------+---------+----------+
</pre>

(493*7.719500-473*7.792500)/20=5.99

Martin

[Sisyfos]

Well, if it's running on NT or 2K it could be 17h real time, but 6h cpu time.

[Jorden]

Yup, the one at work is running at an average of 17 hours a WU. It's on a machine that's being used a lot as well. Can't even tweak it too much, for then I get a memory error telling me that Seti cannot start. So I just re-installed it and let it run at it's own piece.

The 6h average is because the other 3 PC's are crunching much faster at about 4 to 5 hours a WU. Maybe Seti doesn't believe my 17h WU's and doesn't take them

If I could get onto the last 10 WU's page, I could show you, but since it's still down, I can't

Jord.