OT (of sorts): stats masters... How do you do it?

[Rattledagger]

Personally, my method is basically:
1; Copy from stats-site and paste into Excel.
2; Copy from Excel, and back to Excel, choosing "Paste Special" / "Values". -- Doing it this way the data in the various columns and so on is correct, but all "garbage" is filtered-out. Note, if this works or not depends on stats-web-site, it example doesn't work with BoincStats, that still leaves-behind a lot of garbage.
3; Sort descending by total credit, afterwards move team-names up (that is sorted to bottom in own column), and fix SETI@Taiwain that has some unsupported characters in their name.
4; Copy-in yesterdays stats, and check if any teams has moved. (if "new team-name" = "yesterdays team-name";0;9999) makes it very easy to spot any differences.
5; Move "RAC" and "Total" to new locations, and delete all unneeded columns.
6; Copy-in the formula from yesterdays stats that does all calculations and 99% of formatting.
7; Choose whole sheet, and select "numbers, thousand-seperator, no decimals".
8; Copy over to notepad, copy the 1st. "tab", and choose "replace" to remove all the tabs.

Appart for TeAm AnandTech getting bolded, and any "extreme" values, like 1M days to overtake or less than 1k in any columns, the stats is fully formatted.

So, just needed to make a forum-post, add "header", "footer" and "title", and dig-out any news/technical news.

The SETI@home-stats takes roughly 5 minutes to collect, format & post, a little longer if any news to add...


With the mediocre interest in the stats, only reason is still doing them is the short time needed to post them.

 

[Assimilator1]

Opps I saw this a bit late

[edit] I see RDs posted his full method

I basically follow a method that RD origianlly taught me about 2yrs ago for SETI & which I now use for DPAD.The layout I use from DPAD is partly copied from amdborgs old stats threads.

Copy stats (from freeDC site after hitting 'yesterday' column to sort, DPAD only ,freeDC SETI numbers seem to whacko,lol )
Paste into excel ,copy that page
Open new page 'special paste' choose 'values'
Delete unwanted columns
Move name colums to the end (makes for better spacing of stats columns)
Copy spacing columns from previous stats I've done*
Copy headers from previous stats*
Total up 'days' points credit by hitting the sum icon twice.
Save.

Then copy into the new thread which already had the stats header I've copied from a previous days stats ,I think it takes me about 10-15mins now.

*Obviously starting from scratch involves lots of manual formatting which is a right PITA & takes ages! ,make sure you keep at least one lot of previous stats ,note some fonts translate more ditrectly onto the forums then others ,can't remember which is best ,Hellburner told me that one IIRC.

No idea how to use formulas here, I've never been trained/taught to use excel.

Gleem
Using notepad is a good idea ,if I ever have to start from scratch again I'll do that.
Though you might want to use my idea of copying spacing columns from previous stats

Bok
Good to see you're sorting out SETI stats

OD
Forgotten stats master?? ,no way dude you are legendary & we loved your commentary

 

[Rattledagger]

Originally posted by: Assimilator1
[edit] I see RDs posted his full method

Nearly, I see I forgot one point:

5a; Give 3 cells "special" names, so comparison with Anandtech and so on is right, regardless of how many spots Anandtech drops (or rises)...

No idea how to use formulas here, I've never been trained/taught to use excel.

Never really learned anything either, so don't ask me how to write a script or anything...

As for formulas, atleast for "normal" things like +, -, *, /, just type-in in Excel the same formula as you would have written on paper, but instead of using "x" or something, use "A1" or "B1" or something...

The most "advanced" I've become is to use "if"-statements, this greatly helps with formatting.

 

[Fullmetal Chocobo]

If no one minds, I'm going to start doing practice stats in this thread. Basically the only bad thing would be this thread being bumped. The Borg suggested boincsynergy and BOINC Stats, so I'll be getting stats from these places...

 

[Assimilator1]

Go right ahead , don't forget we're stats junkies around here

 

[Fullmetal Chocobo]

I forgot to mention... Anyone interested in doing stats and wanting some practice before doing the real ones--feel free to do whatever in here. And if you want comments, let us know.

 

[Fullmetal Chocobo]

Einstein @ Home
Team Rank Name Total Credit Recent Credit
TC RAC

1 2 mrwizer 1786606 2568.73
2 1 Sofa King 1208499 3837.56
4 4 Thehive 955184 1293.25
5 6 Alan J. Simpson 915403 1010.03
6 36 shuxclams 891270 30.65
8 8 Chris S 740984 541.82
10 13 danzigrules 459440 328.33
11 3 Robert Everly 437646 1935.19
12 10 petrusbroder 405679 488.35
13 41 Raider_Zero 244981 2.97
14 20 caferace 243136 160.67
16 26 SolRad 185325 102.53
18 11 jlaine 160492 373.04
22 7 Tallbill 126861 885.66
23 30 jnj 115623 79.35
24 18 rabidjade 115467 165.53
25 15 mrbeci 113817 281.87
26 27 mnelsonx 111042 101.07
28 29 elawyn 102486 96.55
30 16 Christian Diepold 100363 220.82
31 5 mk 98709 1023.62
32 44 rabrittain 91942 0.61
33 14 Big P 91431 305.17
34 19 Soni 88420 162.64
36 17 Tom Philippart 71637 200.75
37 21 geomagick 67485 157.88
42 22 ytinirt 54764 130.76
45 24 GhettoFob 45571 113.9
46 49 scoser 45456 0.07
54 42 Ingleside 35462 2.87
59 35 plasma 30618 31.17
60 38 Steven Ables 30580 16.09
61 51 Adam 24254 0.01
63 50 Todd 22949 0.03
66 32 iotone 21634 58.28
67 31 cyost91 21411 70.86
68 40 MardukNT 20852 5.66
70 25 ArchangelShrike 18818 103.94
74 12 Kevin 17055 346.88
76 52 Denbo 15462 0.01
79 9 Evadman 14236 499.77
81 46 Team DC 11349 0.21
83 23 Billy 10680 121.86
97 33 rune-san 7571 36.82
98 43 kadajawi 7416 1.57
100 37 Texkonc 6303 27.87

 

[Fullmetal Chocobo]

Hmmm. That didn't go as planned... Try #2

Rank.........RAC..........Name..........................Total Credit........Recent Credit

1.............. 2.............. mrwizer........................1786606 ............2568.73
2.............. 1.............. Sofa King......................1208499............3837.56
4.............. 4.............. Thehive.........................955184.............1293.25
5.............. 6.............. Alan J. Simpson.............915403.............1010.03
6.............. 36............ shuxclams......................891270............30.65
8.............. 8.............. Chris S..........................740984.............541.82
10............ 13............ danzigrules.....................459440.............328.33
11............ 3.............. Robert Everly..................437646............1935.19
12............ 10............ petrusbroder...................405679............488.35
13............ 41............ Raider_Zero....................244981............2.97
14............ 20............ caferace........................243136.............160.67
16............ 26............ SolRad..........................185325.............102.53
18............ 11............ jlaine.............................160492.............373.04
22............ 7.............. Tallbill............................126861.............885.66
23............ 30............ jnj..................................115623............79.35
24............ 18............ rabidjade........................115467............165.53
25............ 15............ mrbeci............................113817............281.87
26............ 27............ mnelsonx........................111042............101.07
28............ 29............ elawyn............................102486............96.55
30............ 16............ Christian Diepold..............100363............220.82
31............ 5.............. mk...................................98709............1023.62
32............ 44............ rabrittain..........................91942...............0.61
33............ 14............ Big P................................91431............305.17
34............ 19............ Soni..................................88420............162.64
36............ 17............ Tom Philippart....................71637............200.75
37............ 21............ geomagick........................67485............157.88
42............ 22............ ytinirt................................54764............130.76
45............ 24............ GhettoFob..........................45571............113.9
46............ 49............ scoser................................45456............0.07
54............ 42............ Ingleside............................35462............2.87
59............ 35............ plasma...............................30618............31.17
60............ 38............ Steven Ables......................30580............16.09
61............ 51............ Adam.................................24254............0.01
63............ 50............ Todd...................................22949............0.03
66............ 32............ iotone.................................21634............58.28
67............ 31............ cyost91...............................21411............70.86
68............ 40............ MardukNT............................20852............5.66
70............ 25............ ArchangelShrike...................18818............103.94
74............ 12............ Kevin...................................17055............346.88
76............ 52............ Denbo.................................15462............0.01
79............ 9.............. Evadman..............................14236............499.77
81............ 46............ Team DC..............................11349............0.21
83............ 23............ Billy.....................................10680............121.86
97............ 33............ rune-san................................7571............36.82
98............ 43............ kadajawi................................7416............1.57
100...........37............Texkonc.................................6303............27.87

 

[Spacehead]

Couple of things i've found out over the years:

Putting names last will will reduce the time to get the correct spacing. Most everyones numbers in a given column will be the same within a few digits, where name length can/will vary greatly.

In some cases, underscores will work better than dots to keep columns lined up neatly when going from the spreadsheet to a forum post. Even after "Previewing" your post & everything looks good you may still need to add/subtract dots in the final post. At east it was that way with the last forum version.




*ignore everything above if there's some way to automate the spacing & get it right. I do everything manually

 

[GLeeM]

1 ____ 2 __ 1786606 ___ mrwizer
2 ____ 1 __ 1208499 ___ SofaKing
4 ____ 4 ___ 955184 ___ Thehive
5 ____ 6 ___ 915403 ___ AlanJ.Simpson
6 ___ 36 ___ 891270 ___ shuxclams
8 ____ 8 ___ 740984 ___ ChrisS
10 __ 13 __ 459440 ___ danzigrules
11 ___ 3 __ 437646 ___ RobertEverly
12 __ 10 __ 405679 ___ petrusbroder
13 __ 41 __ 244981 ___ Raider_Zero
14 __ 20 __ 243136 ___ caferace
16 __ 26 __ 185325 ___ SolRad
18 __ 11 __ 160492 ___ jlaine
22 ___ 7 __ 126861 ___ Tallbill
23 __ 30 __ 115623 ___ jnj
24 __ 18 __ 115467 ___ rabidjade
25 __ 15 __ 113817 ___ mrbeci
26 __ 27 __ 111042 ___ mnelsonx
28 __ 29 __ 102486 ___ elawyn
30 __ 16 __ 100363 ___ ChristianDiepold
31 ___ 5 __ 98709 ___ mk
32 __ 44 __ 91942 ___ rabrittain
33 __ 14 __ 91431 ___ BigP
34 __ 19 __ 88420 ___ Soni
36 __ 17 __ 71637 ___ TomPhilippart
37 __ 21 __ 67485 ___ geomagick
42 __ 22 __ 54764 ___ ytinirt
45 __ 24 __ 45571 ___ GhettoFob
46 __ 49 __ 45456 ___ scoser
54 __ 42 __ 35462 ___ Ingleside
59 __ 35 __ 30618 ___ plasma
60 __ 38 __ 30580 ___ StevenAbles
61 __ 51 __ 24254 ___ Adam
63 __ 50 __ 22949 ___ Todd
66 __ 32 __ 21634 ___ iotone
67 __ 31 __ 21411 ___ cyost91
68 __ 40 __ 20852 ___ MardukNT
70 __ 25 __ 18818 ___ ArchangelShrike
74 __ 12 __ 17055 ___ Kevin
76 __ 52 __ 15462 ___ Denbo
79 ___ 9 __ 14236 ___ Evadman
81 __ 46 __ 11349 ___ TeamDC
83 __ 23 __ 10680 ___ Billy
97 __ 33 ___ 7571 ___ rune-san
98 __ 43 ___ 7416 ___ kadajawi
100 _ 37 ___ 6303 ___ Texkonc

 

[Smoke]

1,786,606 - mrwizer
1,208,499 - SofaKing
? 955,184 - Thehive
? 915,403 - AlanJ.Simpson
? 891,270 - shuxclams
? 740,984 - ChrisS
? 459,440 - danzigrules
? 437,646 - RobertEverly
? 405,679 - petrusbroder
? 244,981 - Raider_Zero
? 243,136 - caferace
? 185,325 - SolRad
? 160,492 - jlaine
? 126,861 - Tallbill
? 115,623 - jnj
? 115,467 - rabidjade
? 113,817 - mrbeci
? 111,042 - mnelsonx
? 102,486 - elawyn
? 100,363 - ChristianDiepold
?.. 98,709 - mk
?.. 91,942 - rabrittain
?.. 91,431 - BigP
?.. 88,420 - Soni
?.. 71,637 - TomPhilippart
?.. 67,485 - geomagick
?.. 54,764 - ytinirt
?.. 45,571 - GhettoFob
?.. 45,456 - scoser
?.. 35,462 - Ingleside
?.. 30,618 - plasma
?.. 30,580 - StevenAbles
?.. 24,254 - Adam
?.. 22,949 - Todd
?.. 21,634 - iotone
?.. 21,411 - cyost91
?.. 20,852 - MardukNT
?.. 18,818 - ArchangelShrike
?.. 17,055 - Kevin
?.. 15,462 - Denbo
?.. 14,236 - Evadman
?.. 11,349 - TeamDC
?.. 10,680 - Billy
??. 7,571 - rune-san
??. 7,416 - kadajawi
??. 6,303 - Texkonc


This is the IF STATEMENT I use in MS Excel to automatically place the proper number of periods to the left of my number columns. It is not perfect but it is the closest I have found over the years. The IF STATEMENT may need to have additional IF STATEMENTS inserted into the formula if your numbers are larger than 9,999,999.

=IF(B1>999999.9,"",IF(B1>99999.9,"?",IF(B1>9999.9,"?..",IF(B1>999.9,"??.",IF(B1>99.9,"??...",IF(B1>9.9,"???..",IF(B1>0.9,".............","")))))))

When I want to use ranking columns up to three digits, I use a shortened version of the same formula:

=IF(B1>99.9,"",IF(B1>9.9,".",IF(B1>0.9,"...")))

The above formulas would need to be placed in the 1st column. If there is a subset ranking then just copy/paste the forumula into the 3rd column. The referenced cell within the forumula needs to be the cell to the immediate right.

Then you would get the following report which includes rankings.



... 1 ... 2 .. 1,786,606 .. mrwizer
... 2 ... 1 .. 1,208,499 .. SofaKing
... 4 ... 4 .. ? 955,184 .. Thehive
... 5 ... 6 .. ? 915,403 .. AlanJ.Simpson
... 6 . 36 .. ? 891,270 .. shuxclams
... 8 ... 8 .. ? 740,984 .. ChrisS
. 10 . 13 .. ? 459,440 .. danzigrules
. 11 ... 3 .. ? 437,646 .. RobertEverly
. 12 . 10 .. ? 405,679 .. petrusbroder
. 13 . 41 .. ? 244,981 .. Raider_Zero
. 14 . 20 .. ? 243,136 .. caferace
. 16 . 26 .. ? 185,325 .. SolRad
. 18 . 11 .. ? 160,492 .. jlaine
. 22 ... 7 .. ? 126,861 .. Tallbill
. 23 . 30 .. ? 115,623 .. jnj
. 24 . 18 .. ? 115,467 .. rabidjade
. 25 . 15 .. ? 113,817 .. mrbeci
. 26 . 27 .. ? 111,042 .. mnelsonx
. 28 . 29 .. ? 102,486 .. elawyn
. 30 . 16 .. ? 100,363 .. ChristianDiepold
. 31 ... 5 .. ?.. 98,709 .. mk
. 32 . 44 .. ?.. 91,942 .. rabrittain
. 33 . 14 .. ?.. 91,431 .. BigP
. 34 . 19 .. ?.. 88,420 .. Soni
. 36 . 17 .. ?.. 71,637 .. TomPhilippart
. 37 . 21 .. ?.. 67,485 .. geomagick
. 42 . 22 .. ?.. 54,764 .. ytinirt
. 45 . 24 .. ?.. 45,571 .. GhettoFob
. 46 . 49 .. ?.. 45,456 .. scoser
. 54 . 42 .. ?.. 35,462 .. Ingleside
. 59 . 35 .. ?.. 30,618 .. plasma
. 60 . 38 .. ?.. 30,580 .. StevenAbles
. 61 . 51 .. ?.. 24,254 .. Adam
. 63 . 50 .. ?.. 22,949 .. Todd
. 66 . 32 .. ?.. 21,634 .. iotone
. 67 . 31 .. ?.. 21,411 .. cyost91
. 68 . 40 .. ?.. 20,852 .. MardukNT
. 70 . 25 .. ?.. 18,818 .. ArchangelShrike
. 74 . 12 .. ?.. 17,055 .. Kevin
. 76 . 52 .. ?.. 15,462 .. Denbo
. 79 ... 9 .. ?.. 14,236 .. Evadman
. 81 . 46 .. ?.. 11,349 .. TeamDC
. 83 . 23 .. ?.. 10,680 .. Billy
. 97 . 33 .. ??. 7,571 .. rune-san
. 98 . 43 .. ??. 7,416 .. kadajawi
100 . 37 .. ??. 6,303 .. Texkonc

No technique is perfect. I ask AT HQ to enable the power to post images every chance I get and though nothing has been promised I believe it will happen pretty soon.

 

[biodoc]

Hey FMC...check out my first Stats post here.

All it needed was some very bright colors and it's a perfect acid trip!

 

[GLeeM]

Thanks Smoke it works!

But it might take longer to paste in the formula than what I usually do

How about spaces in names? How do you manage them?

__ 1 _____ 1 __ 30,111 ___ Gravity
__ 2 _____ 2 __ 21,120 ___ MarkF_Williams
__ 3 _____ 4 ___ 8,559 ___ MadMurph
__ 4 _____ 5 ___ 8,136 ___ Sniderhouse
__ 5 _____ 9 ___ 7,526 ___ Insidious
__ 6 ____ 19 ___ 6,076 ___ mgpaulus
__ 7 ____ 35 ___ 5,280 ___ GSmith
__ 8 ___ 206 ___ 4,839 ___ MichaelK
__ 9 _____ 7 ___ 4,529 ___ scottv67
_ 10 ___ 153 ___ 4,206 ___ legoman666
_ 11 ____ 20 ___ 3,850 ___ o080o
_ 12 ____ 24 ___ 3,520 ___ jdiddy
_ 13 ____ 52 ___ 3,520 ___ blert
_ 14 ___ 146 ___ 3,520 ___ LouisWong
_ 15 _____ 6 ___ 3,221 ___ Athlex
_ 16 ___ 381 ___ 2,760 ___ $hooks
_ 17 ____ 15 ___ 2,704 ___ xbassman
_ 18 ____ 10 ___ 2,676 ___ HurricaneAndrew
_ 19 _____ 8 ___ 2,654 ___ GLeeM
_ 20 ____ 53 ___ 2,473 ___ jkresh
_ 21 ___ 299 ___ 2,103 ___ tomiko
_ 22 ____ 12 ___ 2,013 ___ ripship
_ 23 ____ 38 ___ 2,003 ___ phw
_ 24 ____ 13 ___ 1,993 ___ mike9o
_ 25 ____ 45 ___ 1,945 ___ TurtleBlue
_ 26 ____ 58 ___ 1,760 ___ KingSalami
_ 27 ____ 78 ___ 1,760 ___ Azuen
_ 28 ____ 79 ___ 1,760 ___ Cutthroat
_ 29 ____ 98 ___ 1,760 ___ Hefner
_ 30 ___ 122 ___ 1,760 ___ m1ldslide1
_ 31 ___ 187 ___ 1,760 ___ ch33zw1z
_ 32 ___ 224 ___ 1,760 ___ Esquire
_ 33 ___ 257 ___ 1,760 ___ sharad
_ 34 ___ 464 ___ 1,760 ___ lwalters
_ 35 ___ 527 ___ 1,760 ___ alfa147x
_ 36 ____ 37 ___ 1,551 ___ DavidBoaz
_ 37 ____ 29 ___ 1,415 ___ Thump553
_ 38 ____ 50 ___ 1,364 ___ kravahn
_ 39 ___ 258 ___ 1,330 ___ Schadenfroh
_ 40 ____ 82 ___ 1,243 ___ Desslok
_ 41 ____ 56 ___ 1,205 ___ PeterBarriga
_ 42 ____ 42 ___ 1,188 ___ fhonyotski
_ 43 ___ 472 ___ 1,135 ___ Arkany
_ 44 ____ 48 ___ 1,090 ___ Scott66
_ 45 ___ 235 ___ 1,090 ___ SlangNRox
_ 46 ___ 169 ___ 1,072 ___ ShawnD1
_ 47 ____ 73 ___ 1,029 ___ Nacelle
_ 48 ___ 195 ____ 961 ___ jonesthewine
_ 49 ____ 76 ____ 925 ___ brainwrinkle
_ 50 ____ 57 ____ 920 ___ HappyCracker
_ 51 ____ 75 ____ 883 ___ SilverSurfer042677
_ 52 ____ 91 ____ 883 ___ TAS-petrusbroder
_ 53 ____ 43 ____ 873 ___ stevty2889
_ 54 ____ 18 ____ 844 ___ bastula
_ 55 ____ 60 ____ 840 ___ MasterChef
_ 56 ____ 77 ____ 807 ___ deninc66
_ 57 ___ 262 ____ 801 ___ crackrabbit
_ 58 ____ 55 ____ 778 ___ Ruffilb
_ 59 ___ 700 ____ 770 ___ minendo
_ 60 ___ 170 ____ 750 ___ Deyer
_ 61 ____ 97 ____ 730 ___ maluman
_ 62 ___ 458 ____ 729 ___ Foxery
_ 63 ___ 237 ____ 701 ___ mchan1
_ 64 ___ 255 ____ 682 ___ Lopez
_ 65 ____ 83 ____ 678 ___ ChrisHuff
_ 66 ____ 65 ____ 635 ___ Neurodog
_ 67 ___ 708 ____ 635 ___ JetBlack69
_ 68 ____ 39 ____ 601 ___ Zensal
_ 69 ____ 40 ____ 551 ___ biodoc
_ 70 ___ 181 ____ 535 ___ clicq
_ 71 ___ 161 ____ 500 ___ plonk420
_ 72 ___ 242 ____ 461 ___ mnelsonx
_ 73 ___ 222 ____ 403 ___ cooldadd
_ 74 ____ 28 ____ 388 ___ dawks-rawks
_ 75 ___ 373 ____ 383 ___ narzy-AT
_ 76 __ 1,028 ____ 383 ___ NFS4
_ 77 ___ 638 ____ 373 ___ dafishman
_ 78 ___ 123 ____ 358 ___ kart17wins
_ 79 ____ 11 ____ 343 ___ Uppsala9496
_ 80 ____ 41 ____ 343 ___ Lnx227
_ 81 ___ 107 ____ 343 ___ jtmiller
_ 82 ___ 125 ____ 343 ___ Syntax
_ 83 ___ 131 ____ 343 ___ vigneron
_ 84 ___ 133 ____ 343 ___ wurkfur
_ 85 ___ 167 ____ 343 ___ felmerm
_ 86 ___ 270 ____ 343 ___ Jynx980
_ 87 ___ 289 ____ 343 ___ tooker
_ 88 ___ 421 ____ 343 ___ Toutatis
_ 89 ___ 502 ____ 343 ___ slurm
_ 90 ___ 543 ____ 343 ___ Axoliien
_ 91 ___ 595 ____ 343 ___ Mike5008
_ 92 ___ 704 ____ 343 ___ Shayne
_ 93 ___ 767 ____ 343 ___ pad1136
_ 94 ___ 172 ____ 330 ___ soydios
_ 95 ___ 134 ____ 310 ___ timvehrs
_ 96 ____ 14 ____ 295 ___ MartinTrevino
_ 97 __ 1,158 ____ 293 ___ S231
_ 98 ____ 21 ____ 292 ___ RustyNale
_ 99 ____ 68 ____ 292 ___ abel007
100 ___ 184 ____ 292 ___ epc
101 ___ 265 ____ 292 ___ [TA]Cawchy
102 ___ 749 ____ 290 ___ Tachyon74
103 ___ 288 ____ 284 ___ Titansfury
104 ___ 275 ____ 277 ___ CCHomebrew
105 ____ 17 ____ 243 ___ CupCak3
106 ____ 22 ____ 243 ___ XPBLACKDRAGON
107 ____ 34 ____ 243 ___ JoshLiechty
108 ____ 67 ____ 243 ___ kb3edk
109 ____ 71 ____ 243 ___ MadAmos
110 ____ 89 ____ 243 ___ TheTerl
111 ___ 111 ____ 243 ___ zerocool1
112 ___ 124 ____ 243 ___ futuristicmonkey
113 ___ 192 ____ 243 ___ zacharygthomas
114 ___ 197 ____ 243 ___ steined
115 ___ 252 ____ 243 ___ seanc85
116 ___ 280 ____ 243 ___ YoungGun21
117 ___ 517 ____ 243 ___ haphazard567
118 ___ 507 ____ 230 ___ tayloren
119 ___ 492 _____ 45 ___ weberr13
120 ___ 419 _____ 15 ___ Dennis7

 

[Smoke]

GLeeM,

I use one worksheet (FETCH) strickly for a data import from the web. In another worksheet, I keep the actual template I use for posting.

If the webpage is consistant and doesn't change that often, I then create on the template worksheet LINKS from the appropriate columns on the DATA FETCH worksheet.

 

[Smoke]

GLeeM,

I use one worksheet (which I've named DATA FETCH) strictly for a data import from the web. In another worksheet, I keep the actual template I use for posting.

If the web page is consistent and doesn't change that often, I then create on the template worksheet LINKS from the appropriate columns on the DATA FETCH worksheet.

Damn it, I wasn't finished but accidentally hit the RETURN key on my laptop as I'm posting this while watching (some what haphazardly) some TV. I continue:

So to do a new, fresh report, I open my excel workbook, click on the DATA FETCH tab and make sure the cursor is in cell A1. Then just click on the DATA FETCH button (not to be confused with the worksheet tab but the function) and wait for the magic to take place. That's it folks.

I have started this three different times. I was just called away to the media room where I had to get the DVD movie going for my wife and grandkids who are spending the night. whew

lol, now I see I double-posted. :roll:

Don't call RaySun2Be on me.

 

[Spacehead]

Originally posted by: Smoke
This is the IF STATEMENT I use in MS Excel to automatically place the proper number of periods to the left of my number columns. It is not perfect but it is the closest I have found over the years. The IF STATEMENT may need to have additional IF STATEMENTS inserted into the formula if your numbers are larger than 9,999,999.

=IF(B1>999999.9,"",IF(B1>99999.9,"?",IF(B1>9999.9,"?..",IF(B1>999.9,"??.",IF(B1>99.9,"??...",IF(B1>9.9,"???..",IF(B1>0.9,".............","")))))))

When I want to use ranking columns up to three digits, I use a shortened version of the same formula:

=IF(B1>99.9,"",IF(B1>9.9,".",IF(B1>0.9,"...")))

The above formulas would need to be placed in the 1st column. If there is a subset ranking then just copy/paste the forumula into the 3rd column. The referenced cell within the forumula needs to be the cell to the immediate right.

Interesting. I'll have to see how that works in Open Office.

Originally posted by: Smoke
No technique is perfect. I ask AT HQ to enable the power to post images every chance I get and though nothing has been promised I believe it will happen pretty soon.

Just use a free pic hosting site.
http://pics.bbzzdd.com/ is easy enough to use, if needed.

 

[Smoke]

Originally posted by: Spacehead

Originally posted by: Smoke
No technique is perfect. I ask AT HQ to enable the power to post images every chance I get and though nothing has been promised I believe it will happen pretty soon.

Just use a free pic hosting site.
http://pics.bbzzdd.com/ is easy enough to use, if needed.

I'm not talking about linked images, I'm talking about full blown images posted directly in the AT Forums. All sorts of interesting things would then be possible.

Check out this tutorial on BOINC VIEW available at one of our friendly crunching competitors.
Scroll down about 2/3 of the way to the section on UTILITY SOFTWARE / BOINC View.

 

[Spacehead]

Originally posted by: Smoke

Originally posted by: Spacehead

Originally posted by: Smoke
No technique is perfect. I ask AT HQ to enable the power to post images every chance I get and though nothing has been promised I believe it will happen pretty soon.

Just use a free pic hosting site.
http://pics.bbzzdd.com/ is easy enough to use, if needed.

I'm not talking about linked images, I'm talking about full blown images posted directly in the AT Forums. All sorts of interesting things would then be possible.

Check out this tutorial on BOINC VIEW available at one of our friendly crunching competitors.
Scroll down about 2/3 of the way to the section on UTILITY SOFTWARE / BOINC View.

Yeah, that's great. I had to refresh that page 3 times to get it to load :roll:
Not everyone had a fast internet connection.

From reading Forum Issues, i thought the admins/mods were against allowing embedded images?

 

[Smoke]

Originally posted by: Spacehead

From reading Forum Issues, i thought the admins/mods were against allowing embedded images?

That is the current situation but as the old Bob Dylan song goes, The times they are a-changin' .

 

[biodoc]

I would be happy with the choice of a "non-kerned" font like Courier New.

Every character takes the same amount of space so no alignment problems.

:beer:

 

[Fullmetal Chocobo]

Originally posted by: biodoc
I would be happy with the choice of a "non-kerned" font like Courier New.

Every character takes the same amount of space so no alignment problems.

:beer:

I wonder if there is a greasemonkey script to accomplish this. I'm going to have to look into that.

 

[Fullmetal Chocobo]

Just doing some space testing...

test..........11253.............34334

test 11253 34334

 

[Fullmetal Chocobo]

What stats (columns) would ya'll say are in every project? Or which would be best for a summary?

user | RAC | credits

Per BMC: (definitely makes more sense)
user | credits | team position | change in team position

 

[BlackMountainCow]

RAC is only for BOINC projects, though. And it's a fairly unimportant number in my opinion. Usually, if you do a project for a limited time, you hit the highest RAC right before you quit a project (like with TAS). And if you do a project for months, after a while your RAC will stay roughly the same. So, user, creds, team position and something like a change of position in team are the most interesting ones to me. :beer:

 

[Fullmetal Chocobo]

I just realized that searching the forums for "stats" is not the best way to find this thread. :laugh:

Okay, so after fusterclucking my way through the stats for a month, I learned quite a bit (primarily don't forget where you are getting your stats from!). But I have two quick questions: 1) how often are the stats normally done? Every day or week? I was doing them every 4 or 5 days; why I have no idea. Also, is there a standard for the milestones? I was roughly using something like 1k, 5k, 10k, 25k, 50k, 75k, 100k, every 100k after.

EDIT: Weird. This ended up being an accidental one month bump.